Live every day like you’re on vacation—this is your opportunity.
Exceptional waterfront ranch with stunning views set on a 14-acre lake, featuring nearly 1,000 feet of shoreline and over 10 private, wooded acres with walking trails. This fully renovated home has been updated from top to bottom.
Find gorgeous hand-scraped hickory flooring flowing from the foyer through the vaulted great room, complete with skylights and wood-burning stone fireplace. The open layout leads into a bright breakfast room and an updated kitchen with upgraded cabinetry, stainless steel appliances, tile flooring, and solid stone countertops.
Off the kitchen, a beautiful 17x9 sunroom addition offers a tongue-and-groove vaulted wood ceiling and panoramic views of the wooded property and lake—perfect for relaxing year-round with climate control.
The layout of the home offers spacious primary suite featuring a second fireplace and a luxurious en-suite bath with tile flooring, whirlpool tub, double vanities, and a separate shower. Two additional bedrooms and a fully remodeled bath complete the main level.
The walkout lower level adds even more living space with a fourth bedroom, full bath, laundry room, and ample unfinished space ready for your customization.
Outside, enjoy an expansive composite deck overlooking the water—ideal for entertaining or quiet evenings by the lake.
Additional updates include a new roof (2023), deck (2006), concrete driveway, and siding (2006). Tucked at the end of a cul-de-sac, the property also features a picturesque waterfall and creek, with Indian Camp Creek just a short walk away.
A rare opportunity to own a private waterfront retreat in a truly serene setting.
Closed
Listed by: Hero Realty, LLC • Dale J Rowe • Contact: 314-409-6489
Bought with: Compass Realty Group
Price Unknown
26 Madre Ct, Foristell, MO 63348
4beds
2,288sqft
Single Family Residence
Built in 1986
10.28 Acres Lot
$650,000 Zestimate®
$--/sqft
$2,715 Estimated rent
Home value
$650,000
$611,000 - $689,000
$2,715/mo
Zestimate® history
Owner options
List your home for rent
$2,715/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$2,715/mo
Rent Zestimate®
Refinance and save
$308/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$308/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
Wood-burning stone fireplaceSecond fireplacePicturesque waterfall and creekWalkout lower levelTwo additional bedroomsLuxurious en-suite bathLaundry room
Zillow last checked:
Listing updated:
Listed by:
Dale J Rowe 314-409-6489,
Hero Realty, LLC,
Alli J Bilger 636-734-2753,
Hero Realty, LLC
Bought with:
Trevor Olwig, 2018038825
Compass Realty Group
Source: MARIS,MLS#: 26021821
Originating MLS: St. Charles County Association of REALTORS
Originating MLS: St. Charles County Association of REALTORSFacts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 3
- Main level bathrooms: 2
- Main level bedrooms: 3
Heating
- Electric, Forced Air, Geothermal
Cooling
- Ceiling Fan(s), Central Air, Electric, Geothermal
Appliances
- Included: Stainless Steel Appliance(s)
Features
- Ceiling Fan(s), Country Kitchen, Custom Cabinetry, Double Vanity, Entrance Foyer, Kitchen Island, Kitchen/Dining Room Combo, Open Floorplan, Pantry, Recessed Lighting, Separate Shower, Solid Surface Countertop(s), Storage, Vaulted Ceiling(s), Walk-In Closet(s)
- Flooring: Carpet, Ceramic Tile, Wood
- Doors: Panel Door(s)
- Basement: Partially Finished,Sump Pump,Walk-Out Access
- Number of fireplaces: 2
- Fireplace features: Family Room, Master Bedroom
Interior area
- Total structure area: 2,288
- Total interior livable area: 2,288 sqft
- Finished area above ground: 1,525
Property
Parking
- Total spaces: 2
- Parking features: Garage - Attached
- Attached garage spaces: 2
Features
- Levels: One
- Patio & porch: Composite, Deck, Enclosed, Porch
- Exterior features: Private Yard
- Has view: Yes
- View description: Lake, Trees/Woods, Water
- Water view: Lake,Water
- Waterfront features: Waterfront, Lake, Lake Front, Lake Privileges, Navigable Water
Lot
- Size: 10.28 Acres
- Features: Adjoins Common Ground, Adjoins Open Ground, Adjoins Wooded Area, Back Yard, Cul-De-Sac, Views, Waterfront, Wooded
Details
- Additional structures: Shed(s)
- Parcel number: 400035363000026.0000000
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
- Attached to another structure: Yes
Materials
- Vinyl Siding
- Foundation: Concrete Perimeter
- Roof: Architectural Shingle
Condition
- Updated/Remodeled
- New construction: No
- Year built: 1986
Utilities & green energy
- Electric: Other
- Sewer: Septic Tank
- Water: Community
Green energy
- Energy efficient items: HVAC
Community & HOA
Community
- Features: Lake
- Subdivision: Big Country Ac
HOA
- Has HOA: Yes
- Amenities included: Common Ground, Lake
- Services included: Maintenance Parking/Roads, Common Area Maintenance, Trash, Water
- HOA fee: $308 quarterly
- HOA name: Unknown
Location
- Region: Foristell
Financial & listing details
- Tax assessed value: $442,777
- Annual tax amount: $5,187
- Date on market: 4/16/2026
- Cumulative days on market: 219 days
- Listing terms: Cash,Conventional,FHA,VA Loan
- Ownership: Private
- Road surface type: Asphalt
Price history
| Date | Event | Price |
|---|---|---|
| 7/2/2026 | Sold | -- |
Source:  MARIS #26021821 Report a problem | ||
| 6/1/2026 | Pending sale | $750,000$328/sqft |
Source: MARIS #26021821 Report a problem | ||
| 5/8/2026 | Price change | $750,000-6.2%$328/sqft |
Source: MARIS #26021821 Report a problem | ||
| 4/16/2026 | Listed for sale | $799,900$350/sqft |
Source: MARIS #26021821 Report a problem | ||
| 3/10/2026 | Listing removed | $799,900$350/sqft |
Source: MARIS #25062709 Report a problem | ||
| 2/24/2026 | Price change | $799,900-5.9%$350/sqft |
Source: MARIS #25062709 Report a problem | ||
| 12/29/2025 | Price change | $849,900-5.6%$371/sqft |
Source: MARIS #25062709 Report a problem | ||
| 10/15/2025 | Price change | $899,900-5.3%$393/sqft |
Source: MARIS #25062709 Report a problem | ||
| 9/17/2025 | Listed for sale | $949,900$415/sqft |
Source: MARIS #25062709 Report a problem | ||
| 2/21/2002 | Sold | -- |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $5,187 +7.6% | $84,128 +10.6% |
| 2024 | $4,821 +0% | $76,043 |
| 2023 | $4,820 +8.7% | $76,043 +16.5% |
| 2022 | $4,434 | $65,272 |
| 2021 | -- | $65,272 +10.9% |
| 2020 | -- | $58,866 |
| 2019 | $4,112 | $58,866 -1.2% |
| 2018 | $4,112 +0% | $59,563 |
| 2017 | $4,112 -1.9% | $59,563 +2.3% |
| 2016 | $4,193 +1.3% | $58,196 |
| 2015 | $4,137 +15.4% | $58,196 +7.5% |
| 2014 | $3,586 | $54,130 |
| 2013 | -- | $54,130 -1.4% |
| 2012 | -- | $54,890 -19.3% |
| 2011 | -- | $68,040 |
| 2010 | -- | $68,040 -5.4% |
| 2009 | -- | $71,950 -7.3% |
| 2008 | -- | $77,630 -78% |
| 2007 | -- | $352,970 |
| 2006 | -- | $352,970 |
| 2005 | -- | $352,970 +59.5% |
| 2004 | -- | $221,350 +16.9% |
| 2003 | -- | $189,430 |
| 2002 | -- | -- |
| 2001 | -- | -- |
Find assessor info on the county website
Neighborhood: 63348
Nearby homes
- $688,4003 bd3 ba2k sqft1500 Madre Dr, Foristell, MO 63348Off Market
- $496,8003 bd3 ba1.5k sqft5 Madre Ct, Foristell, MO 63348Off Market
- $749,7004 bd3 ba2.3k sqft18 Madre Ct, Foristell, MO 63348Off Market
- $511,1003 bd2 ba1.7k sqft1523 Madre Dr, Foristell, MO 63348Off Market
- $552,0004 bd3 ba1.9k sqft1529 Madre Dr, Foristell, MO 63348Off Market
- $558,2004 bd3 ba1.5k sqft1509 Madre Dr, Foristell, MO 63348Off Market
- $28,34663.634 AcresDietrich Rd, Foristell, MO 63348Off Market
- $524,7003 bd4 ba1.6k sqft1517 Madre Dr, Foristell, MO 63348Off Market
Nearby schools
GreatSchools rating
- 9/10Wabash ElementaryGrades: K-5Distance: 3.6 mi
- 6/10North Point Middle SchoolGrades: 6-8Distance: 3.4 mi
- 8/10North Point High SchoolGrades: 9-12Distance: 3.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
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$650,000
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$650,000
- Missouri
- Saint Charles County
- Foristell
- 63348
- 26 Madre Ct
Nearby cities
Nearby zip codes
Other Foristell Topics
