#25030902, Listing office: The Cova Group
$750,000 List price
204 Great Bear Pass Foristell, MO 63348
4 beds
3 full, 1 partial
2,704 sqft
0.5 acres
$277 / sqft
House
Property details
About 204 Great Bear Pass
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
Highlights
Home typeSingle Family Residence
HeatingForced Air, Natural Gas
StatusActive
CoolingCeiling Fan(s), Central Air, Electric
Size2,704 sqft
BasementYes
Lot size0.4542 Acres
Year built2025
ParkingAttached, Garage, Garage Door Opener
MLS #25022505
Attached garage3 spaces
FireplaceGreat Room
Summary
- Partial Bathrooms: 1
- Full Bathrooms: 3
- Appliances: Gas Water Heater, Dishwasher, Disposal, Microwave, Gas Range, Gas Oven, Stainless Steel Appliance(s)
- Basement: Yes
- Flooring Type: Carpet
- Interior: 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
- Fireplace: Great Room
- Total Bedroom Count: 4
- Garage Space: 3 spaces
- Attached Garage: Yes
- Parking: Attached, Garage, Garage Door Opener
- Exterior: Deck, Patio, Porch/Covered
- Architectural Style: Traditional, Ranch
- Heating: Forced Air, Natural Gas
- Cooling: Ceiling Fan(s), Central Air, Electric
- List Price: $750,000
- Price/SqFt: $277
- HOA Amount: $250 Annually
- 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
- Year Built: 2025
- Living Area: 2,704 SqFt
- Lot Size: 0.4542 Acres
- MLS Number: 25022505
- MLS Name: MARIS2
- Office Name: Magnolia Real Estate
- Office Phone: (636) 442-0214
Listings courtesy of Mid America Regional Information System as distributed by MLS GRID.
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.
DMCA Notice
Based on information submitted to the MLS GRID. 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.
IDX information is provided exclusively for consumers personal non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.
Listings courtesy of MARIS MLS as distributed by MLS GRID. Copyright © 2025 Mid America Regional Information System (MARIS). All Rights Reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 7/16/2025, 12:53:26 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Price information
Property sales
We're sorry, we currently don't have property sales data for this listing.
Tax history
| Year | Assessment | Property Tax |
|---|---|---|
| 2024 | $14,250 | $- |
History based on county public records data.
Nearby schools
5
Journey Elementary School
Public District KG-5
2.8 mi
•2000 Interstate Dr
3
Wabash Elementary School
Public District KG-5
3.5 mi
•100 Golden Gate Pkwy
5
Stone Creek Elementary School
Public District KG-5
4.5 mi
•1820 Highway Z
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $87,110. Typical income of Foristell, MO residents is between $35k-100k annually. Typical family type is married, with kids. The majority of residents in this area have post secondary degree education.
How much money do the neighbors make?
10%
<35k
53%
35k-100k
32%
100k-200k
5%
200k+
What level of education do the neighbors have?
High School Diploma
Post Secondary Degree
Masters Degree
What types of families live nearby?
19%
Single, No Kids
9%
Single, with Kids
35%
Married, No Kids
37%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
20%
<11 yrs old
10%
12-17 yrs old
19%
18-34 yrs old
41%
35-64 yrs old
10%
65+ yrs old
What do the neighbors do for fun?
College Football
Soccer
NASCAR
Where do the neighbors shop?
Best Buy
Old Navy
Dick's Sporting Goods
Where do the neighbors go to eat?
Texas Roadhouse
Jimmy Johns
Arbys
What do the neighbors drive?
Ram
GMC
Lexus
What do the neighbors listen to?
Contemporary Christian
New Country
Adult Hits
All data provided by Home Junction and Claritas
Similar homes for sale
Tour
#25028581, Listing office: Magnolia Real Estate
Tour
#25015043, Listing office: Magnolia Real Estate
#25018753, Listing office: ListWithFreedom.com Inc
1 day on Rocket
#25048092, Listing office: STL Buy & Sell, LLC
15 hours on Rocket
#25048246, Listing office: STL Buy & Sell, LLC
Frequently asked questions
About 204 Great Bear Pass
The listing price of 204 Great Bear Pass property is $750,000.
The property 204 Great Bear Pass is a house located in Foristell, Missouri, 63348.
Active Listing: 204 Great Bear Pass is For Sale (Active/New) which means the seller is accepting offers.
The nearby schools for 204 Great Bear Pass are: Journey Elementary School (GreatSchools Rating 5/10), Wabash Elementary School (GreatSchools Rating 3/10), Stone Creek Elementary School (GreatSchools Rating 5/10), Wentzville Middle School (GreatSchools Rating 4/10), Wentzville South Middle School (GreatSchools Rating 5/10), Wright City Middle School (GreatSchools Rating 4/10), North Point High School (GreatSchools Rating 6/10), Holt High School (GreatSchools Rating 7/10), Timberland High School (GreatSchools Rating 7/10).
The property at 204 Great Bear Pass has 4 bedrooms and 3 full and 1 half bathrooms.
The property 204 Great Bear Pass is 2,704 SqFt (source: MLS/tax record).
The year of construction for 204 Great Bear Pass is 2025.
This home is located at 204 Great Bear Pass in Foristell, MO and zip code 63348. This 2,704 square foot home, which was built in 2025, sits on a 0.45 acre lot. Features: 4 bedrooms, 4 bathrooms. It has been listed on Rocket Homes since April 11, 2025 and is currently priced at $750,000.
In June 2025, from all listings sold in Foristell, MO there were more than 4 sold above asking price, over 3 sold below and more than 6 were sold right at the asked price. Between May and June 2025, Foristell, MO real estate market has seen increase in the number of listings by 14.1%. The median list price of listings available in June 2025 was $368,000, while the average time on the real estate market was 48 days.
From Rocket Homes Real Estate and based on county public records data.