Active MLS# 25022505

204 Great Bear Pass, Foristell, MO 63348

Subdivision: Stone Canyon

List Price: $740,000

4

Bedrooms

4

Baths

2,704

Area (sq.ft)

$277

Cost/sq.ft

1 Story

Type

Description

Experience refined living in this stunning 4-bedroom, 4-bath ranch nestled in the tranquil Stone Canyon community of Foristell. Spanning 2,704 sq ft, this Alpine model by Zykan & Sons Homes boasts an open-concept design with soaring 10-foot ceilings, a gourmet kitchen featuring custom cabinetry, solid surface countertops, and a walk-in pantry. The spacious great room, adorned with a gas fireplace, seamlessly connects to a covered composite deck, perfect for entertaining or relaxing. The primary suite offers a luxurious retreat with a spa-like bath, double sinks, and a separate tub and shower. Additional highlights include a dedicated office, main-floor laundry, and a walk-out basement with 9-foot pour and roughed-in bath, ready for your personal touch. Situated on a 0.45-acre lot backing to trees and common ground, this home combines elegance, comfort, and privacy. Located within the Wentzville School District and close to amenities, it's the perfect blend of luxury and convenience! Additional Rooms: Mud Room

Property Information

List Price $ 740,000

Original Price $ 750,000

Status Active

MLS# 25022505

Bedrooms 4

Full baths 3

Half baths 1

Main Floor Full Baths 3

Sq. Ft. Above 2,704

Lot Size 0

Acres 0

Subdivision Stone Canyon

Municipality Foristell

School District Wentzville R-IV

County St Charles

Property Type Residential

Style 1 Story

Style Description Ranch

Transaction Type Sale

Special Conditions Standard

Type

Building Exterior Amenities Common Ground

Building Style Traditional,Ranch

Ownership Private

Special Description Standard

Appliances Some Stainless Steel Appliance(s),Dishwasher,Disposal,Exhaust Fan,Plumbed For Ice Maker,Microwave,Convection Oven,Gas Oven,Range Hood,Gas Range,Vented Exhaust Fan,Gas Water Heater

Miscellaneous Builders Warranty,Deck-Composite,Deck-Covered,High Spd Connection,Patio,Patio-Covered,Porch-Covered,Smoke Alarm/Detec

Disclosures Flood Plain No

Age 0

Sewer Main Size Public Sewer

Water Main Size Public

Conditions Flood Plain No

Additional Information

Elementary School Wabash Elem.

Jr. High School North Point Middle

Sr. High School North Point

Association Fee $250 /Annually

Architecture Traditional,Ranch

Construction Stone Veneer,Brick Veneer,Frame,Vinyl Siding

Garage Spaces 3

Carport Spaces 0

Basement Description 9 ft + Pour,Egress Window,Full,Concrete,Roughed-In Bath,Sump Pump,Unfinished,Walk-Out Access

Fireplace Type Great Room

Fireplace Location Great Room

Lot Dimensions .45 Acre

Special Areas Den/Office,Entry Foyer,Great Room,Main Floor Laundry,Mud Room

Cooling Ceiling Fan(s),Central Air,Electric

Sewer Public Sewer Sewer

Heating Forced Air,Natural Gas

Water Public

Heat Source Gas

Kitchen Breakfast Bar,Center Island,Custom Cabinetry,Eat-In Kitchen,Pantry,Solid Surface Counter,Walk-In Pantry

Appliances Stainless Steel Appliance(s),Dishwasher,Disposal,Exhaust Fan,Plumbed For Ice Maker,Microwave,Convection Oven,Gas Oven,Range Hood,Gas Range,Vented Exhaust Fan,Gas Water Heater

Dining Kitchen/Dining Combo

Interior Decor Breakfast Bar,Ceiling Fan(s),Chandelier,Custom Cabinetry,Double Vanity,Eat-in Kitchen,Entrance Foyer,High Ceilings,High Speed Internet,Kitchen Island,Kitchen/Dining Room Combo,Open Floorplan,Pantry,Separate Shower,Soaking Tub,Solid Surface Countertop(s),Tray Ceiling(s),Tub,Walk-In Closet(s),Walk-In Pantry,Wired for Data

Property Tax $903

Map Location

Directions

Rooms Dimensions

Room	Dimensions (sq.rt)
Great Room (Level-Main)	19 x 17
Kitchen (Level-Main)	17 x 15
Dining Room (Level-Main)	12 x 15
Primary Bedroom (Level-Main)	16 x 15
Primary Bathroom (Level-Main)	14 x 15
Bedroom (Level-Main)	11 x 15
Bathroom (Level-Main)	10 x 6
Bedroom (Level-Main)	12 x 12
Bathroom (Level-Main)	12 x 6
Office (Level-Main)	12 x 12
Bathroom (Level-Main)	5 x 6
Laundry (Level-Main)	11 x 9
Mud Room (Level-Main)	9 x 5

MORE REALTORS

Agent

Call MORE

Contact Us

We look forward to helping you. Please add any additional comments below and we will be in touch with you shortly.

First Name

Last Name

Your Email

Phone

Home Phone

How soon are you looking to buy or sell ?

Comments, Questions, Special Requests ? *All Fields Are Requried

When would you like to view this listing?

By clicking continue or signup, you agree to our Term of Use & Privacy Policy.

First Name

Last Name

Your Email

Phone

Home Phone

Pick Date

Pick Time

Please pick date first

Listing Courtesy of Magnolia Real Estate - [email protected]

The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA") provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to [email protected] AND [email protected]/

The DMCA requires that your notice of alleged copyright infringement include the following information:

Description of the copyrighted work that is the subject of claimed infringement.
Description of the alleged infringing content and information sufficient to permit us to locate the content.
Contact information for you, including your address, telephone number and email address.
A statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law.
A statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed.
A physical or electronic signature of the copyright owner or a person authorized to act on the copyright owners behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.

The price homes have sold for is not public information in most counties in Missouri therefore our REALTOR® MLS rules require that before we give you access to the sold information you must agree to the Terms of Use below:

You acknowledge:

That you have reviewed the Missouri Broker Disclosure Form, available by clicking the link below, which describes the various types of representation available to consumers. Furthermore, that you have NOT entered into an exclusive agency relationship with our firm, MORE, REALTORS, therefore, we do not have a client relationship with you at this point nor do you have any financial obligation to us at all and that our relationship at this point is you as a consumer and us as a broker. Furthermore, you have reviewed our privacy policy which is accessed by the link at the bottom of our site.
The information you will gain access to on this site shall only by used by you only and no one else and then only for your personal and non-commercial use.
That your interest in obtaining sold prices and sold listing data is because you have a bona fide interest in the purchase, sale or lease of real estate of the type being displayed on this site.
You agree not to copy, redistribute or retransmit any of the information provided to you on this site except in connection with your consideration of the purchase or sale of an individual property.
You understand and acknowledge that the data displayed on this site comes from a databased that is owned by Mid America Regional Information Systems (MARIS) and is subject to their copyright on the data. In addition, the compilation of the data and display of the data is subject to copyright by MORE, REALTORS.
In order to verify our compliance with rules, MARIS may need to access our database which will include your registration information which you hereby grant permission to us to allow and to MARIS to access for compliance purposes.

By checking this box I affirm that I have read and agree to the above Terms and Conditions.