204 Great Bear Pass, Foristell, MO 63348
Home value
$739,700
$688,000 - $791,000
$3,234/mo
Owner options
$3,234/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,234/mo
Rent Zestimate®
$250/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$250/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked:
Listing updated:
Stacey L Zykan 314-412-3753,
Magnolia Real Estate,
John W Becker 636-206-9106,
Magnolia Real Estate
John W Becker, 2014025447
Magnolia Real Estate
Stacey L Zykan, 2013004252
Magnolia Real Estate
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
- Level: Main
- Area: 240
- Dimensions: 16 x 15
Bedroom
- Level: Main
- Area: 165
- Dimensions: 11 x 15
Bedroom
- Level: Main
- Area: 144
- Dimensions: 12 x 12
Primary bathroom
- Level: Main
- Area: 210
- Dimensions: 14 x 15
Bathroom
- Level: Main
- Area: 60
- Dimensions: 10 x 6
Bathroom
- Level: Main
- Area: 72
- Dimensions: 12 x 6
Bathroom
- Level: Main
- Area: 30
- Dimensions: 5 x 6
Dining room
- Level: Main
- Area: 180
- Dimensions: 12 x 15
Great room
- Level: Main
- Area: 323
- Dimensions: 19 x 17
Kitchen
- Level: Main
- Area: 255
- Dimensions: 17 x 15
Laundry
- Level: Main
- Area: 99
- Dimensions: 11 x 9
Mud room
- Level: Main
- Area: 45
- Dimensions: 9 x 5
Office
- Level: Main
- Area: 144
- Dimensions: 12 x 12
Heating
- Forced Air, Natural Gas
Cooling
- Ceiling Fan(s), Central Air, Electric
Appliances
- Included: Stainless Steel Appliance(s), Dishwasher, Disposal, Exhaust Fan, Plumbed For Ice Maker, Microwave, Oven, Range Hood, Gas Range, Vented Exhaust Fan, Gas Water Heater
- Laundry: Main Level
Features
- Breakfast Bar, Ceiling Fan(s), Chandelier, Double Vanity, Eat-in Kitchen, Entrance Foyer, 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
- Flooring: Carpet
- Doors: Panel Door(s), Sliding Doors
- Windows: Double Pane Windows, Insulated Windows, Low Emissivity Windows, Tilt-In Windows
- Basement: Full,Concrete,Sump Pump,Unfinished,Walk-Out Access
- Has fireplace: Yes
- 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
- Attached garage spaces: 3
Accessibility
- Accessibility features: Central Living Area
Features
- Levels: One
- Exterior features: Private Yard
- Fencing: None
- Has view: Yes
- View description: Trees/Woods
Lot
- Size: 0.45 Acres
- Dimensions: .45 Acre
- Features: Adjoins Common Ground, Adjoins Wooded Area, Back Yard, Front Yard, Landscaped
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
- Foundation: Concrete Perimeter, Permanent
- Roof: Architectural Shingle
Condition
- New Construction
- New construction: Yes
Details
- Builder name: Zykan & Sons Homes Llc
- Warranty included: Yes
Utilities & green energy
- Electric: Single Phase
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Underground Utilities, Natural Gas Available
Green energy
- Energy efficient items: HVAC, Lighting, Windows
Community & HOA
Community
- Features: Sidewalks, Street Lights
- Security: Carbon Monoxide Detector(s), Smoke Detector(s)
- Subdivision: Stone Canyon
HOA
- Has HOA: Yes
- Amenities included: Common Ground
- Services included: Other
- HOA fee: $250 annually
- HOA name: Stone Canyon Homeowners Association
Location
- Region: Foristell
Financial & listing details
- Tax assessed value: $75,000
- Annual tax amount: $903
- Date on market: 4/12/2025
- Cumulative days on market: 206 days
- Listing terms: Cash,Conventional,VA Loan
- Ownership: Private
- Road surface type: Concrete
Price history
| Date | Event | Price |
|---|---|---|
| 11/4/2025 | Sold | -- |
Source: | ||
| 10/4/2025 | Contingent | $740,000$274/sqft |
Source: | ||
| 8/15/2025 | Price change | $740,000-1.3%$274/sqft |
Source: | ||
| 4/12/2025 | Listed for sale | $750,000$277/sqft |
Source: | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $941 +4.2% | $14,250 |
| 2024 | $903 | $14,250 |
Neighborhood: 63348
Nearby homes
- $--3 bd2 ba1.8k sqft210 Great Bear Pass, Foristell, MO 63348Sold

- $75,000-- bd-- ba-- sqft601 Meridian Ln, Foristell, MO 63348Off Market
- $75,000-- bd-- ba-- sqft209 Great Bear Pass, Foristell, MO 63348Off Market
- $--3 bd2 ba2.1k sqft212 Great Bear Pass, Foristell, MO 63348Sold

- $75,000-- bd-- ba-- sqft202 Great Bear Pass, Foristell, MO 63348Off Market
- $75,000-- bd-- ba-- sqft213 Great Bear Pass, Foristell, MO 63348Off Market
- $75,000-- bd-- ba-- sqft201 Great Bear Pass, Foristell, MO 63348Off Market
- $--3 bd2 ba1.8k sqft214 Great Bear Pass, Foristell, MO 63348Sold
Nearby schools
GreatSchools rating
- 9/10Wabash ElementaryGrades: K-5Distance: 2.5 mi
- 6/10North Point Middle SchoolGrades: 6-8Distance: 2.9 mi
- 8/10North Point High SchoolGrades: 9-12Distance: 3 mi
Schools provided by the listing agent
- Elementary: Wabash Elem.
- Middle: North Point Middle
- High: North Point
Source: MARIS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
$739,700
Get a cash offer in 3 minutes
$739,700
- Missouri
- Saint Charles County
- Foristell
- 63348
- 204 Great Bear Pass