Skip main navigation
Active
  • $750,000

    204 Great Bear Pass, Foristell, MO 63348

    4beds
    2,704sqft
    : 
    Single Family Residence
    Built in 2025
    0.45 Acres Lot
    $-- Zestimate®
    $277/sqft
    $21/mo HOA

    What's special

    Gas fireplaceCovered composite deckWalk-out basementSolid surface countertopsOpen-concept designPrimary suiteDouble sinks
    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
    42 days
    on Zillow
    |
    503
    |
    23
    |

    Zillow last checked: 7 hours ago

    Listing updated: 14 hours ago

    Listing Provided by:

    Stacey L Zykan 314-412-3753,

    Magnolia Real Estate,

    John W Becker 636-206-9106,

    Magnolia Real Estate

    Source: MARIS,MLS#: 25022505MLS LogoOriginating MLS: St. Charles County Association of REALTORS
    Travel times

    Tour with a buyer’s agent

    We’ll find a local expert to take you on a private tour of 204 Great Bear Pass.

    Next available tour time:Today at 11am

    Open houses

    • Sat, May 24

      11:00 AM - 4:00 PM

    • Sun, May 25

      11:00 AM - 4:00 PM

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 4
    • Full bathrooms: 3
    • 1/2 bathrooms: 1
    • Main level bathrooms: 4
    • Main level bedrooms: 4
    Primary bedroom
    • Features: Floor Covering: Laminate
    • Level: Main
    • Area: 240
    • Dimensions: 16 x 15
    Bedroom
    • Features: Floor Covering: Carpeting
    • Level: Main
    • Area: 144
    • Dimensions: 12 x 12
    Bedroom
    • Features: Floor Covering: Carpeting
    • Level: Main
    • Area: 165
    • Dimensions: 11 x 15
    Primary bathroom
    • Features: Floor Covering: Ceramic Tile
    • Level: Main
    • Area: 210
    • Dimensions: 14 x 15
    Bathroom
    • Level: Main
    • Area: 72
    • Dimensions: 12 x 6
    Bathroom
    • Features: Floor Covering: Ceramic Tile
    • Level: Main
    • Area: 60
    • Dimensions: 10 x 6
    Bathroom
    • Features: Floor Covering: Laminate
    • Level: Main
    • Area: 30
    • Dimensions: 5 x 6
    Dining room
    • Features: Floor Covering: Laminate
    • Level: Main
    • Area: 180
    • Dimensions: 12 x 15
    Great room
    • Features: Floor Covering: Laminate
    • Level: Main
    • Area: 323
    • Dimensions: 19 x 17
    Kitchen
    • Features: Floor Covering: Laminate
    • Level: Main
    • Area: 255
    • Dimensions: 17 x 15
    Laundry
    • Features: Floor Covering: Laminate
    • Level: Main
    • Area: 99
    • Dimensions: 11 x 9
    Mud room
    • Features: Floor Covering: Laminate
    • Level: Main
    • Area: 45
    • Dimensions: 9 x 5
    Office
    • Features: Floor Covering: Laminate
    • Level: Main
    • Area: 144
    • Dimensions: 12 x 12
    Heating
    • Forced Air, Natural Gas
    Cooling
    • Ceiling Fan(s), Central Air, Electric
    Appliances
    • Included: Gas Water Heater, Dishwasher, Disposal, Microwave, Gas Range, Gas Oven, Stainless Steel Appliance(s)
    • Laundry: Main Level
    Features
    • Kitchen/Dining Room Combo, Open Floorplan, High Ceilings, Walk-In Closet(s), Breakfast Bar, Kitchen Island, Custom Cabinetry, Eat-in Kitchen, Pantry, Solid Surface Countertop(s), Walk-In Pantry, High Speed Internet, Double Vanity, Tub, Entrance Foyer
    • Flooring: Carpet
    • Doors: Panel Door(s), Sliding Doors
    • Windows: Low Emissivity Windows, Insulated Windows, Tilt-In Windows
    • Basement: Full,Concrete,Sump Pump,Unfinished,Walk-Out Access
    • Has fireplace: No
    • Fireplace features: Great Room
    Interior area
    • Total structure area: 2,704
    • Total interior livable area: 2,704 sqft
    • Finished area above ground: 2,704

    Property

    Parking
    • Total spaces: 3
    • Parking features: Attached, Garage, Garage Door Opener
    • Attached garage spaces: 3
    Accessibility
    • Accessibility features: Central Living Area
    Features
    • Levels: One
    • Patio & porch: Composite, Deck, Patio, Covered
    Lot
    • Size: 0.45 Acres
    • Dimensions: .45 Acre
    • Features: Adjoins Common Ground, Adjoins Wooded Area
    Details
    • Parcel number: 40008D418000016.0000000
    • Special conditions: Standard

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Traditional,Ranch
    • Property subtype: Single Family Residence
    Materials
    • Stone Veneer, Brick Veneer, Frame, Vinyl Siding
    Condition
    • Year built: 2025
    Details
    • Builder name: Zykan & Sons Homes Llc
    • Warranty included: Yes

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: Underground Utilities, Natural Gas Available

    Community & HOA

    Community
    • Security: Smoke Detector(s)
    • Subdivision: Stone Canyon
    HOA
    • HOA fee: $250 annually
    Location
    • Region: Foristell

    Financial & listing details

    • Price per square foot: $277/sqft
    • Tax assessed value: $75,000
    • Annual tax amount: $903
    • Date on market: 4/12/2025
    • Listing terms: Cash,Conventional,VA Loan
    • Ownership: Private
    • Road surface type: Concrete
    • Loading
    • Loading