11,000 sq ft Multigenerational Estate on 59+- ac w/private lake. Lower level offers space perfect for mother-in-laws/secondary living w/2nd full kitchen, 2nd full laundry, 2 more bedrooms, gym, family/media room w/fireplace & full bar-all walks out to large patio & pool. Main floor features 18' ceilings, striking millwork, triple crown, coffered tray ceilings & custom columns. Luxury Primary suite offers dual closets, wet bar, FP, separate bathrooms & water closets w/access to Grand gazebo w/wet bar & access to outside. Two more ensuites on main floor feature walk in closets. Main Chef's kitchen offers center cooktop & custom hood, bkfst dining leads to deck w/breathtaking view. Large living rm features woodburning FP, custom panoramic doors open to the sunroom. 60x46X14'T Outbuilding - Dual Climate controlled w/2 bi-fold hanger doors & water. Whole house back up generator. Additional outbuilding measures 35x24x11'T w/2 overhead doors. Located just minutes from 2 major interstates.
Active
$3,900,000
962 Highway W, Foristell, MO 63348
5beds
11,536sqft
Est.:
Farm
Built in 1996
59 Acres Lot
$-- Zestimate®
$338/sqft
$-- HOA
What's special
Private lakeWoodburning fpCustom columnsGrand gazeboBreathtaking viewLuxury primary suiteCustom hood
- 367 days
- on Zillow |
- 1,661 |
- 81 |
Zillow last checked: 7 hours ago
Listing updated: April 28, 2025 at 05:55pm
Listing Provided by:
Stacey Blondin 314-713-1463,
Main St. Real Estate
Source: MARIS,MLS#: 24035064
Originating MLS: St. Charles County Association of REALTORS

Travel times
Tour with a buyer’s agent
Tour with a buyer’s agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 7
- Full bathrooms: 4
- 1/2 bathrooms: 3
- Main level bathrooms: 5
- Main level bedrooms: 3
Primary bedroom
- Features: Floor Covering: Carpeting, Wall Covering: Some
- Level: Main
- Area: 552
- Dimensions: 24x23
Bedroom
- Features: Floor Covering: Carpeting, Wall Covering: Some
- Level: Lower
- Area: 272
- Dimensions: 17x16
Bedroom
- Features: Floor Covering: Carpeting, Wall Covering: Some
- Level: Main
Bedroom
- Features: Floor Covering: Carpeting, Wall Covering: Some
- Level: Main
- Area: 208
- Dimensions: 16x13
Bedroom
- Features: Floor Covering: Carpeting, Wall Covering: Some
- Level: Lower
- Area: 300
- Dimensions: 20x15
Primary bathroom
- Features: Floor Covering: Marble, Wall Covering: Some
- Level: Main
- Area: 396
- Dimensions: 22x18
Bathroom
- Features: Floor Covering: Ceramic Tile
- Level: Lower
- Area: 35
- Dimensions: 7x5
Bathroom
- Features: Floor Covering: Ceramic Tile
- Level: Main
- Area: 50
- Dimensions: 10x5
Bathroom
- Features: Floor Covering: Ceramic Tile
- Level: Lower
- Area: 72
- Dimensions: 12x6
Bathroom
- Features: Floor Covering: Ceramic Tile
- Level: Main
- Area: 30
- Dimensions: 6x5
Bathroom
- Features: Floor Covering: Carpeting, Wall Covering: Some
- Level: Main
- Area: 50
- Dimensions: 10x5
Bathroom
- Features: Floor Covering: Marble, Wall Covering: Some
- Level: Main
- Area: 50
- Dimensions: 10x5
Bonus room
- Features: Floor Covering: Carpeting
- Level: Lower
- Area: 216
- Dimensions: 18x12
Breakfast room
- Features: Floor Covering: Ceramic Tile
- Level: Main
- Area: 238
- Dimensions: 17x14
Den
- Features: Floor Covering: Carpeting, Wall Covering: Some
- Level: Main
- Area: 480
- Dimensions: 24x20
Dining room
- Features: Floor Covering: Carpeting, Wall Covering: Some
- Level: Main
- Area: 208
- Dimensions: 16x13
Exercise room
- Features: Floor Covering: Carpeting
- Level: Lower
- Area: 294
- Dimensions: 21x14
Family room
- Features: Floor Covering: Carpeting
- Level: Lower
- Area: 864
- Dimensions: 32x27
Great room
- Features: Floor Covering: Carpeting
- Level: Main
- Area: 357
- Dimensions: 21x17
Kitchen
- Features: Floor Covering: Ceramic Tile, Wall Covering: Some
- Level: Lower
- Area: 270
- Dimensions: 18x15
Kitchen
- Features: Floor Covering: Ceramic Tile
- Level: Main
- Area: 208
- Dimensions: 16x13
Laundry
- Features: Floor Covering: Ceramic Tile
- Level: Lower
- Area: 144
- Dimensions: 18x8
Laundry
- Features: Floor Covering: Ceramic Tile
- Level: Main
- Area: 255
- Dimensions: 17x15
Living room
- Features: Floor Covering: Carpeting, Wall Covering: Some
- Level: Main
- Area: 675
- Dimensions: 27x25
Loft
- Features: Floor Covering: Carpeting, Wall Covering: Some
- Level: Upper
- Area: 208
- Dimensions: 16x13
Office
- Features: Floor Covering: Carpeting, Wall Covering: Some
- Level: Main
- Area: 221
- Dimensions: 17x13
Recreation room
- Features: Floor Covering: Wood, Wall Covering: Some
- Level: Main
- Area: 726
- Dimensions: 33x22
Storage
- Features: Floor Covering: Vinyl
- Level: Lower
- Area: 119
- Dimensions: 17x7
Storage
- Features: Floor Covering: Carpeting
- Level: Main
- Area: 30
- Dimensions: 6x5
Storage
- Features: Floor Covering: Carpeting
- Level: Main
- Area: 88
- Dimensions: 11x8
Storage
- Features: Floor Covering: Carpeting
- Level: Main
- Area: 64
- Dimensions: 8x8
Storage
- Features: Floor Covering: Carpeting
- Level: Main
Storage
- Features: Floor Covering: Carpeting
- Level: Lower
- Area: 40
- Dimensions: 8x5
Sunroom
- Features: Floor Covering: Ceramic Tile
- Level: Main
- Area: 324
- Dimensions: 18x18
Heating
- Dual Fuel/Off Peak, Forced Air, Electric, Propane
Cooling
- Ceiling Fan(s), Central Air, Electric, Zoned
Appliances
- Included: Stainless Steel Appliance(s), Electric Water Heater
Features
- Central Vacuum, High Speed Internet, Breakfast Bar, Cathedral Ceiling(s), Entrance Foyer, Granite Counters, Pantry, Separate Dining, Walk-In Closet(s)
- Basement: Full,Partially Finished,Concrete,Walk-Out Access
- Number of fireplaces: 4
- Fireplace features: Recreation Room, Wood Burning, Basement, Family Room, Living Room, Master Bedroom
Interior area
- Total structure area: 11,536
- Total interior livable area: 11,536 sqft
- Finished area above ground: 11,536
Video & virtual tour
Property
Parking
- Total spaces: 8
- Parking features: Additional Parking, Attached, Circular Driveway, Covered, Detached, Garage, Garage Door Opener, Off Street, Storage, Workshop in Garage
- Attached garage spaces: 4
- Carport spaces: 4
- Covered spaces: 8
- Has uncovered spaces: Yes
Features
- Patio & porch: Deck, Patio, Covered
- Pool features: In Ground
- Fencing: Wire
- Has view: Yes
- View description: Water
- Water view: Water
- Waterfront features: Waterfront, Lake
Lot
- Size: 59 Acres
- Features: Adjoins Wooded Area, Suitable for Horses, Views, Waterfront, Gently Rolling, Level, Meadow, Pasture, Scattered Woods, Wooded
- Topography: Terraced
Details
- Additional structures: Equipment Shed, Garage(s), Metal Building, Outbuilding, Pole Barn(s), RV/Boat Storage, Second Garage, Shed(s), Storage, Utility Building, Workshop
- Parcel number: 40007S008000002.1100000
- Special conditions: Standard
- Other equipment: Satellite Dish
- Horses can be raised: Yes
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary,Traditional
- Property subtype: Farm
Materials
- Brick, Frame
Condition
- Year built: 1996
Utilities & green energy
- Sewer: Septic Tank
- Water: Well
- Utilities for property: Underground Utilities, Propane Owned, Electricity Available, Natural Gas Available, Water Available, Sewer Available, Phone Available
Community & HOA
Community
- Security: Security System Owned, Smoke Detector(s)
- Subdivision: None
Location
- Region: Foristell
Financial & listing details
- Price per square foot: $338/sqft
- Tax assessed value: $1,525,065
- Annual tax amount: $18,113
- Date on market: 6/14/2024
- Listing terms: Cash,Conventional
- Inclusions: Mineral Rights if Owned
- Ownership: Private
- Electric utility on property: Yes
- Road surface type: Asphalt
- Loading
- Loading