6 days on RocketTour
$6,650 Closing Credit¹
#25028581, Listing Office: Magnolia Real Estate
$750,000 List price
204 Great Bear Pass Foristell, MO 63348
$8,906
Closing credit¹
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!
Highlights
Home typeResidential
HeatingForced Air
StatusActive
CoolingCeiling Fan(s), Electric
Size2,704 sqft
BasementYes
Lot size0.4542 Acres
Year built2025
ParkingAttached Garage, Garage Door Opener
MLS #25022505
Attached garage3 spaces
FireplaceGas
Summary
- Partial Bathrooms: 1
- Full Bathrooms: 3
- Appliances: Dishwasher, Disposal, Microwave, Gas Oven, Stainless Steel Appliance(s)
- Basement: Yes
- Interior: High Ceilings, Open Floorplan, Carpets, Walk-in Closet(s)
- Fireplace: Gas
- Total Bedroom Count: 4
- Garage Space: 3 spaces
- Attached Garage: Yes
- Private Pool: No
- Parking: Attached Garage, Garage Door Opener
- Architectural Style: Traditional
- Heating: Forced Air
- Cooling: Ceiling Fan(s), Electric
- List Price: $750,000
- Price/SqFt: $277
- HOA Amount: $21
- HOA Frequency: Annually
- Lot: Wooded Back
- 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: MARIS
- Office Name: Magnolia Real Estate
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.
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: 5/7/2025, 3:23:29 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹
$750,000
204 Great Bear Pass
$8,906
closing credit¹
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
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. The majority of Foristell, MO residents have income between $35k-100k annually. Residents typically live in married, with kids family. Typical level of education for residents in this area is post secondary degree.
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
$6,246 Closing Credit¹
#25015043, Listing Office: Magnolia Real Estate
$4,701 Closing Credit¹
#25002255, Listing Office: ListWithFreedom.com Inc
$4,305 Closing Credit¹
#25018753, Listing Office: ListWithFreedom.com Inc
$4,436 Closing Credit¹
#24070053, Listing Office: ListWithFreedom.com Inc
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.
Foristell, MO housing market in April 2025 saw over 4 listings sold above listed price, more than 4 sold at listed price and over 1 sold below. The number of homes for sale in Foristell, MO increased by 1.7% between March and April 2025. While the average time on the market in April 2025 was 77 days, the median list price was $362,500.
From Rocket Homes Real Estate and based on county public records data.