204 Great Bear
- Listed by Stacey Zykan • Magnolia Real Estate
- Listed by John W Becker • Magnolia Real Estate
Property Details for 204 Great Bear
Property Details for 204 Great Bear
| Status | Closed |
|---|---|
| MLS # | 25022505 |
| Days on Market | 206 |
| Taxes | $903 / year |
| HOA Fees | $250 / year |
| Condo/Co-op Fees | - |
| Compass Type | Single Family |
| MLS Type | Residential / Single Family Residence |
| Year Built | - |
| Lot Size | 0.45 AC / 19,785 SF |
| County | St. Charles County |
Location
Sold By Magnolia Real Estate
Building Information for 204 Great Bear
Payment Calculator
$3,641 per month
30 year fixed, 6.15% Interest
$3,545
$75
$21
Know your buying power with a preapproval and custom rate in minutes
1Property Information for 204 Great Bear
- City: Foristell
- County Or Parish: St. Charles
- Directions: HWY 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
- Latitude: 38.826361
- Longitude: -90.95805
- Postal Code: 63348
- State Or Province: MO
- Sub division Name: Stone Canyon
- List AOR: St. Charles County Association of REALTORS
- Association Fee: $250.00
- Association Fee Frequency: Annually
- Association Fee Includes: Other
- Parcel Number: 4-0008-D418-00-0016.0000000
- Tax Annual Amount: $903.00
- Tax Legal Description: STONE CANYON #2 LOT 16
- Tax Year: 2024
- Township: Foristell
- Attached Garage: Yes
- Carport Spaces: 0.0
- Carport: No
- Garage Spaces: 3.0
- Garage: Yes
- Parking Features: Attached, Garage
- Parking Total: 3.0
- Elementary School: Wabash Elem.
- High School: North Point
- High School District: Wentzville R-IV
- Middle Or Junior School: North Point Middle
- Living Area: 2704.0
- Lot Features: Adjoins Common Ground, Adjoins Wooded Area, Back Yard, Front Yard, Landscaped
- Lot Size Acres: 0.4542
- Lot Size Area: 0.45
- Lot Size Dimensions: .45 Acre
- Lot Size Source: Public Records
- Lot Size Square Feet: 19785.0
- Property Condition: New Construction
- Property Sub Type: Single Family Residence
- Builder Name: Zykan & Sons Homes LLC
- Property Type: Residential
- Above Grade Finished Area: 2704.0
- Above Grade Finished Area Source: Builder
- Documents Available: Floor Plan,List of Inclusions
- Documents Count: 3
- Photos Count: 1
- Disclosures: Flood Plain No
- Construction Materials: Stone Veneer, Brick Veneer, Frame, Vinyl Siding
- Ownership Type: Private
- Electric: Single Phase
- Sewer: Public Sewer
- Utilities: Underground Utilities, Natural Gas Available
- Water Source: Public
- Accessibility Features: Central Living Area
- Association Amenities: Common Ground
- Fencing: None
- Road Surface Type: Concrete
- Roof: Architectural Shingle
- Appliances: Stainless Steel Appliance(s), Dishwasher, Disposal, Exhaust Fan, Plumbed For Ice Maker, Microwave, Oven, Range Hood, Gas Range, Vented Exhaust Fan, Gas Water Heater
- Basement: Egress Window, Full, Concrete, Roughed-In Bath, Sump Pump, Unfinished, Walk-Out Access
- Basement YN: Yes
- Levels: One
- Main Level Bedrooms: 4.0
- Bathrooms Full: 3
- Bathrooms Half: 1
- Bathrooms Total Integer: 4
- Bedrooms Total: 4
- Cooling: Ceiling Fan(s), Central Air, Electric
- Fireplace Features: Great Room
- Fireplaces Total: 0
- Fireplace: Yes
- Heating: Forced Air, Natural Gas
- Interior 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
- Laundry Features: Main Level
- Window Features: Double Pane Windows, Insulated Windows, Low Emissivity Windows, Tilt-In Windows
- Rooms Total: 6
- Room Dimensions: 19 x 17
- Room Length: 19.0
- Room Level: Main
- Room Type: Great Room
- Room Width: 17.0
- Room Dimensions: 17 x 15
- Room Length: 17.0
- Room Level: Main
- Room Type: Kitchen
- Room Width: 15.0
- Room Dimensions: 12 x 15
- Room Length: 12.0
- Room Level: Main
- Room Type: Dining Room
- Room Width: 15.0
- Room Dimensions: 16 x 15
- Room Length: 16.0
- Room Level: Main
- Room Type: Primary Bedroom
- Room Width: 15.0
- Room Dimensions: 14 x 15
- Room Length: 14.0
- Room Level: Main
- Room Type: Primary Bathroom
- Room Width: 15.0
- Room Dimensions: 11 x 15
- Room Length: 11.0
- Room Level: Main
- Room Type: Bedroom
- Room Width: 15.0
- Room Dimensions: 10 x 6
- Room Length: 10.0
- Room Level: Main
- Room Type: Bathroom
- Room Width: 6.0
- Room Dimensions: 12 x 12
- Room Length: 12.0
- Room Level: Main
- Room Type: Bedroom
- Room Width: 12.0
- Room Dimensions: 12 x 6
- Room Length: 12.0
- Room Level: Main
- Room Type: Bathroom
- Room Width: 6.0
- Room Dimensions: 12 x 12
- Room Length: 12.0
- Room Level: Main
- Room Type: Office
- Room Width: 12.0
- Room Dimensions: 5 x 6
- Room Length: 5.0
- Room Level: Main
- Room Type: Bathroom
- Room Width: 6.0
- Room Dimensions: 11 x 9
- Room Length: 11.0
- Room Level: Main
- Room Type: Laundry
- Room Width: 9.0
- Room Dimensions: 9 x 5
- Room Length: 9.0
- Room Level: Main
- Room Type: Mud Room
- Room Width: 5.0
- Number Of Units In Community: 148
Property History for 204 Great Bear
| Date | Event & Source | Price | Appreciation |
|---|---|---|---|
| Nov 4, 2025 | Closed MARIS #25022505 | $727,400 | — |
| Nov 3, 2025 | Pending MARIS #25022505 | — | |
| Oct 4, 2025 | Active Under Contract MARIS #25022505 | — | |
| Aug 15, 2025 | Price Change MARIS #25022505 | $740,000 | — |
| Apr 12, 2025 | Listed (Active) MARIS #25022505 | $750,000 | — |
| Date | Event & Source | Price |
|---|---|---|
| 11/04/2025 | Closed MARIS #25022505 | $727,400 |
| 11/03/2025 | Pending MARIS #25022505 | — |
| 10/04/2025 | Active Under Contract MARIS #25022505 | — |
| 08/15/2025 | Price Change MARIS #25022505 | $740,000 |
| 04/12/2025 | Listed (Active) MARIS #25022505 | $750,000 |
For completeness, Compass often displays two records for one sale: the MLS record and the public record.
Public Records for 204 Great Bear
Schools near 204 Great Bear
Rating | School | Type | Grades | Distance |
|---|---|---|---|---|
| Public - | K to 5 | |||
| Public - | 6 to 8 | |||
| Public - | 9 to 12 | |||
| Public - | 3 to 5 |
Rating | School | Distance |
|---|---|---|
Wabash Elementary PublicK to 5 | ||
North Point Middle School Public6 to 8 | ||
North Point High School Public9 to 12 | ||
Heritage Intermediate School Public3 to 5 |
School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.
Similar Homes
Similar Sold Homes
Explore Nearby Homes
- Boone Township - St. Charles County Homes for Sale
- Charrette Township - Warren County Homes for Sale
- Clark Township - Lincoln County Homes for Sale
- Flint Hill Homes for Sale
- Hickory Grove Township - Warren County Homes for Sale
- Wentzville Township - St. Charles County Homes for Sale
- Monroe Township - Lincoln County Homes for Sale
- Lake Saint Louis Homes for Sale
- North Elkhorn Township - Warren County Homes for Sale
- South Elkhorn Township - Warren County Homes for Sale
- Lake St. Louis Township - St. Charles County Homes for Sale
- Bedford Township - Lincoln County Homes for Sale
- Hawk Point Township - Lincoln County Homes for Sale
- Chain of Rocks Homes for Sale
- Josephville Homes for Sale
- Wright City Homes for Sale
- Wentzville Homes for Sale
- Lake Sherwood Homes for Sale
- Foristell Homes for Sale
- New Melle Homes for Sale
- Moscow Mills Homes for Sale
- Innsbrook Homes for Sale
- Troy Homes for Sale
- Lake St. Louis Homes for Sale
- O'Fallon Homes for Sale
- Warrenton Homes for Sale
- Defiance Homes for Sale
- Truesdale Homes for Sale
- Marthasville Homes for Sale
- Augusta Homes for Sale
- 63390 Homes for Sale
- 63379 Homes for Sale
- 63385 Homes for Sale
- 63332 Homes for Sale
- 63341 Homes for Sale
- 63357 Homes for Sale
- 63362 Homes for Sale
- 63365 Homes for Sale
- 63369 Homes for Sale
- 63367 Homes for Sale
- 63366 Homes for Sale
- 63304 Homes for Sale
- 63383 Homes for Sale
- 63380 Homes for Sale
- 63368 Homes for Sale
No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.
Listing Courtesy of Magnolia Real Estate
Based on information submitted to the MLS GRID as of 11/05/2025 04:31 PM. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Properties displayed may be listed or sold by various participants in the MLS. IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed by MLS GRID. Use of the MLS GRID data may be subject to an end user license agreement prescribed by the applicable MLS of the Member Participant, if any, and as amended from time to time.