Sign up to get new listings emailed daily! JOIN SIGN IN
Katie Berry
Branch Manager
REALTOR®, CIPS, AHWD, RENE, C2EX
314.541.4887
Facebook Icon 

152 Frontenac Forest, Saint Louis, MO 63131

$3,375,000
  • 152 Frontenac Forest, Saint Louis, MO 63131 Main Photo

20 Total Photos [Click to View All]

Pending
BEDS5 BATHS5 full 2 partial SQUARE FEET6,916 MLS#24040522
STATUSPending PROPERTY TYPEResidential - Single Family SUBDIVISIONFrontenac Forest SCHOOLLadue

Property Description

Located in prestigious Frontenac Forest/Ladue Schools, DeBrecht Homes, known for its superb craftsmanship & distinctive architectural, elements & finishes, offers modern luxury home w/open floor plan, hardwood flooring, & 10' ceilings, perfect for daily comfort or entertaining. Great room features custom cabinets, large gas fireplace, & accent ceiling, while stunning vaults soar above the beamed hearth room & kitchen. Culinary enthusiasts will appreciate a designer kitchen w/custom inset cabinetry, quartzite waterfall countertops, Wolf appliances, & massive island. Primary suite includes a coffered ceiling, custom closets, & spa-like bath. Second floor, w/hardwood throughout, has ensuite bedrms w/walk-in closets & loft. Lookout LL features a bar, full bath, exercise room, & space for a theater area & game room. Exterior with 4 four-car garage, a beautiful covered paver patio w/a fireplace looking out over the expansive yard w/designer landscaping & ample space for a pool. Finished12/24

152 Frontenac Forest | MLS# 24040522

This single family home located at 152 Frontenac Forest, Saint Louis, MO 63131 is currently listed for sale with an asking price of $3,375,000. This property has 5 bedrooms and 5 full and 2 partial baths with 6916 sq. ft. Frontenac Forest is located in the Frontenac Forest subdivision within the Ladue school district. Search Frontenac Forest real estate on katieberry.redkeystlouis.com today.

Property Features

Property Type: Residential - Single Family
Basement: Yes
Basement: 9 ft + Pour, Bathroom, Full, Daylight, Daylight/Lookout, Partially Finished, Concrete, Sleeping Area, Sump Pump
Cooling: Zoned
Garage: 4 car attached
Heating: Natural Gas, Zoned
Home Style: Traditional, Other
Lot Size: 0.96 Acres
Taxes: $7,611

Amenities

Bookcases
Coffered Ceiling(s)
Open Floorplan
Vaulted Ceiling(s)
Walk-In Closet(s)
Breakfast Bar
Breakfast Room
Butler Pantry
Kitchen Island
Custom Cabinetry
Eat-in Kitchen
Walk-In Pantry
Tub
Two Story Entrance Foyer
Entrance Foyer

Feature Descriptions

Appliances: Dishwasher, Disposal, Double Oven, Free-Standing Range, Range, Gas Range, Gas Oven, Refrigerator, Gas Water Heater
Days on Site: 737
Exterior: Stone Veneer, Brick Veneer, Fiber Cement
Fireplace: Kitchen
Lot: Adjoins Wooded Area, Level
Lot Dimensions: 124 x 293 x 171 x 300
Parcel#: 20N-14-0275
Parking: Attached, Garage, Garage Door Opener, Off Street
Sewer: Public Sewer
SQFT. Above Grade: 5393
SQFT. Below Grade: 1523
Utilities: Natural Gas Available
Water: Public
Window: Bay Window(s)

Room Sizes

Dining Room: 16 x 14
Office: 16 x 14
Other: 9 x 13
Kitchen: 22 x 22
Hearth Room: 14 x 16
Great Room: 22 x 21
Laundry: 8 x 12
Bathroom: 5 x 5
Mud Room: 5 x 12
Bathroom: 5 x 6
Primary Bedroom: 20 x 17
Other: 10 x 5
Loft: 16 x 15
Bedroom: 16 x 14
Bathroom: 9 x 5
Bedroom: 18 x 10
Bathroom: 10 x 5
Bedroom: 12 x 12
Bathroom: 5 x 9
Recreation Room: 32 x 14
Recreation Room: 16 x 11
Exercise Room: 21 x 10
Bedroom: 14 x 11
Bathroom: 13 x 5

Local Schools

High School: Ladue Horton Watkins High
Middle School: Ladue Middle
Elementary School: Conway Elem.
School District: Ladue

Listed By / Shown By

Listed By

Agency Name: Coldwell Banker Realty - Gundaker

Shown By

Agent Name: Katie Berry
Agent Phone: 314.541.4887
Agency Title: RedKey Realty Leaders

IDX logo

Estimate Your Payment

Estimated Payment

$ 20,006.10 per month $18,387.48 Principal & Interest $634.25 Property Tax $984.38 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)
Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided 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. Information on this site was last updated 07/05/2026. The listing information on this page last changed on 07/05/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Sun 07/05/2026 12:29:59 AM EST) or MARIS MLS (last updated Sun 07/05/2026 12:11:22 AM EST). Real estate listings held by brokerage firms other than RedKey Realty Leaders may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

Listing data and photos distributed by MLSGRID
Member Participants (and their affiliated licensees, if applicable) shall indicate on their websites that 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.
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.



Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder

Pixel