Foristell, MO 63348 204 Great Bear Pass

204 Great Bear Pass Foristell, MO - Image 1204 Great Bear Pass Foristell, MO - Image 2204 Great Bear Pass Foristell, MO - Image 3
45 more
204 Great Bear Pass Foristell, MO - Image 4204 Great Bear Pass Foristell, MO - Image 5204 Great Bear Pass Foristell, MO - Image 6204 Great Bear Pass Foristell, MO - Image 7204 Great Bear Pass Foristell, MO - Image 8204 Great Bear Pass Foristell, MO - Image 9204 Great Bear Pass Foristell, MO - Image 10204 Great Bear Pass Foristell, MO - Image 11204 Great Bear Pass Foristell, MO - Image 12204 Great Bear Pass Foristell, MO - Image 13204 Great Bear Pass Foristell, MO - Image 14204 Great Bear Pass Foristell, MO - Image 15204 Great Bear Pass Foristell, MO - Image 16204 Great Bear Pass Foristell, MO - Image 17204 Great Bear Pass Foristell, MO - Image 18204 Great Bear Pass Foristell, MO - Image 19204 Great Bear Pass Foristell, MO - Image 20204 Great Bear Pass Foristell, MO - Image 21204 Great Bear Pass Foristell, MO - Image 22204 Great Bear Pass Foristell, MO - Image 23204 Great Bear Pass Foristell, MO - Image 24204 Great Bear Pass Foristell, MO - Image 25204 Great Bear Pass Foristell, MO - Image 26204 Great Bear Pass Foristell, MO - Image 27204 Great Bear Pass Foristell, MO - Image 28204 Great Bear Pass Foristell, MO - Image 29204 Great Bear Pass Foristell, MO - Image 30204 Great Bear Pass Foristell, MO - Image 31204 Great Bear Pass Foristell, MO - Image 32204 Great Bear Pass Foristell, MO - Image 33204 Great Bear Pass Foristell, MO - Image 34204 Great Bear Pass Foristell, MO - Image 35204 Great Bear Pass Foristell, MO - Image 36204 Great Bear Pass Foristell, MO - Image 37204 Great Bear Pass Foristell, MO - Image 38204 Great Bear Pass Foristell, MO - Image 39204 Great Bear Pass Foristell, MO - Image 40204 Great Bear Pass Foristell, MO - Image 41204 Great Bear Pass Foristell, MO - Image 42204 Great Bear Pass Foristell, MO - Image 43204 Great Bear Pass Foristell, MO - Image 44204 Great Bear Pass Foristell, MO - Image 45204 Great Bear Pass Foristell, MO - Image 46204 Great Bear Pass Foristell, MO - Image 47204 Great Bear Pass Foristell, MO - Image 48204 Great Bear Pass Foristell, MO - Image 49
Presented By: Magnolia Real Estate
  • MLS# 25022505
  • 04/11/2025
  • Request Tour
  • Request Info
  • Beds • 4
  • Full/Half Baths • 3 / 1
  • SQFT • 2,704
  • Garage • 3

Home Details

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
Presented By: Magnolia Real Estate

Interior Features for 204 Great Bear Pass

Bedrooms

Main Level Bedrooms4
Total Bedrooms4

Bathrooms

Half Baths1
Total Baths4

Other Interior Features

LivingAreaSourceBuilder
Above Grade Finished Area2704
Above Grade Finished Area SourceBuilder
Above Grade Finished Area Unit TypeSquare Feet
Basement9 ft + Pour, Egress Window, Full, Concrete, Roughed-In Bath, Sump Pump, Unfinished, Walk-Out Access
Basement (Y/N)Yes
Fireplace FeaturesGreat Room
Fireplace Y/NNo
FlooringCarpet
Interior AmenitiesBreakfast 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, S
Laundry FeaturesMain Level
Total Fireplaces
Window FeaturesDouble Pane Windows, Insulated Windows, Low Emissivity Windows, Tilt-In Windows

General for 204 Great Bear Pass

AccessibilityCentral Living Area
AppliancesStainless 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
Architectural StyleTraditional, Ranch
Assoc Fee Paid PerAnnually
Association AmenitiesCommon Ground
Association Fee IncludesOther
Attached Garage Yes
Builder NameZykan & Sons Homes LLC
Building FeaturesBasement, Bathrooms, Fiber Optic, Kitchen Facilities, Lighting, Patio, Wi-Fi
Carport Spaces
Carport Y/NNo
CityForistell
Community FeaturesSidewalks, Street Lights
Construction MaterialsStone Veneer, Brick Veneer, Frame, Vinyl Siding
CoolingCeiling Fan(s), Central Air, Electric
CountySt. Charles
DirectionsHWY 70 West to HWY W. North on HWY W for a half mile. Left on Stone Canyon Blvd. Left on Great Bear Pass. Home will be on your left. Google Maps Directions https://maps.app.goo.gl/NjLwCdxHaZsGT5hH8
DisclosuresFlood Plain No
ElectricSingle Phase
Elementary SchoolWabash Elem.
Energy EfficientHVAC, Lighting, Windows
Full Baths3
Garage Spaces3
Garage Y/NYes
HOAYes
HOA Fee$250
HeatingForced Air, Natural Gas
High SchoolNorth Point
High School DistrictWentzville R-IV
Home Warranty Y/NYes
Lease Considered Y/NNo
Legal DescriptionSTONE CANYON #2 LOT 16
LevelsOne
Living Area UnitsSquare Feet
Lot Size Square Feet19785
Lot Size UnitsAcres
MLS Area418 – Wentzville-North Point
Middle/Junior High SchoolNorth Point Middle
ModificationTimestamp2025-09-15T05:31:42.771Z
New ConstructionYes
Ownership TypePrivate
Patio/Porch FeaturesComposite, Deck, Patio, Covered
PossessionClose Of Escrow
Property Attached Y/NNo
Property ConditionNew Construction
Property SubtypeSingle Family Residence
Property TypeResidential
RoofArchitectural Shingle
Security FeaturesCarbon Monoxide Detector(s), Smoke Detector(s)
Senior Community Y/NNo
SewerPublic Sewer
Standard StatusActive
StatusActive
Structure TypeHouse
Subdivision NameStone Canyon
Tax Annual Amount903
Tax Year2024
Total Rooms6
TownshipForistell
UtilitiesUnderground Utilities, Natural Gas Available
Virtual TourClick here

Exterior for 204 Great Bear Pass

Door FeaturesPanel Door(s), Sliding Door(s)
Exterior AmenitiesPrivate Yard
Lot Dimensions.45 Acre
Lot FeaturesAdjoins Common Ground, Adjoins Wooded Area, Landscaped, Sprinklers In Front, Sprinklers In Rear
Lot Size Acres0.4542
Lot Size Area0.45
Lot Size SourcePublic Records
Other EquipmentIrrigation Equipment
Parking FeaturesAttached, Garage, Garage Door Opener
Road Surface TypeConcrete
Total Parking3
Water SourcePublic
Waterfront Y/NNo

Additional Details

Price History

Schools

Elementary School Wabash Elem.
High School North Point High School
Middle School North Point Middle

Craig Ziegel

Realtor
Price $740,000
MLS#25022505
List Date 04/11/2025
Property Type Single Family
Request Tour
Request Info
Visit My Website

Similar Properties to 204 Great Bear Pass