557 Brewster Rd, Madisonville, LA 70447
- $1,500,000
- 5
- BD
- 6
- BA
- 4,421
- SqFt
- List Price
- $1,500,000
- Price Change
- ▼ $50,000 1781121750
- MLS#
- 2548797
- Status
- ACTIVE UNDER CONTRACT
- Type
- Single Family Residential
- Style
- French Provincial
- Stories
- 2
- Bedrooms
- 5
- Bathrooms
- 6
- Half-baths
- 1
- Acres
- 1.10
- Living Area
- 4,421
- Parish
- St Tammany
- Subdivision
- New Subdivision
Property Description
Welcome to 557 Brewster Road. An exquisite custom home in the highly sought-after school district! This stunning 5-bedroom, 5.5-bath residence offers exceptional living spaces with an additional office that can easily serve as a 6th bedroom. Situated on a picturesque 1.10 acre lot, this property features a massive Old Chicago paved back porch featuring an outdoor fireplace and outdoor kitchen overlooking serene surroundings and plenty of room to add a pool to create an outdoor oasis—perfect for relaxing or entertaining. Inside, you’ll find gorgeous wood floors throughout, designer light fixtures, and beautiful custom details at every turn. Home also has Fortified roof system! The chef’s kitchen is a showstopper, boasting a beautiful La Cornue gas range, a massive quartzite island, an expansive scullery, butler’s pantry, and a dedicated china closet by leading to the formal dining room. The open-concept living spaces are ideal for both everyday life and special gatherings. Retreat to the luxurious primary suite with a spa-like bath and generous closet space. Each additional bedroom offers ensuite bathrooms and plenty of storage galore! With refined craftsmanship, architectural elegance, and every modern convenience, this home truly has it all!!
/u.realgeeks.media/mooneyswift/header.png)
Additional Information
- Exterior Features
- Porch, Sound System
- Roof
- Shingle
- Sewer
- Treatment Plant
- Water
- Public
- Pool Description
- None
- Appliances
- Dishwasher, Disposal, Ice Maker, Microwave, Oven, Range, Refrigerator, Wine Cooler
- Heating
- Central, Multiple Heating Units
- Cooling
- Central Air, Multi Units
Mortgage Calculator
Participants, subscribers, and all users acknowledge that the information contained in the Multiple Listings Service is owned by the New Orleans Metropolitan Association of REALTORS®, Inc. and no user may, nor may they authorize or allow anyone to, download the active listings, sold listing data, or other information contained in the MLS for the recommercialization (resale) or for any purpose not authorized in writing by the New Orleans Metropolitan Association of REALTORS®, Inc. or the Gulf South Real Estate Information Network, Inc. Copyright 2026, New Orleans Metropolitan Association of REALTORS®, Inc. All rights reserved. Information deemed reliable, but not verified or guaranteed. Users are responsible for checking the accuracy, completeness, currency, and status of all information. The sharing of MLS database, or any portion thereof, with any unauthorized third party is strictly prohibited. Information contained on this site is believed to be reliable; yet, users of this web site are responsible for checking the accuracy, completeness, currency, or suitability of all information. Neither the New Orleans Metropolitan Association of REALTORS®, Inc. nor the Gulf South Real Estate Information Network, Inc. makes any representation, guarantees, or warranties as to the accuracy, completeness, currency, or suitability of the information provided. They specifically disclaim any and all liability for all claims or damages that may result from providing information to be used on the web site, or the information which it contains, including any web sites maintained by third parties, which may be linked to this web site. The information being provided is for the consumer’s personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties which consumers may be interested in purchasing. The user of this site is granted permission to copy a reasonable and limited number of copies to be used in satisfying the purposes identified in the preceding sentence. By using this site, you signify your agreement with and acceptance of these terms and conditions. If you do not accept this policy, you may not use this site in any way. Your continued use of this site, and/or its affiliates’ sites, following the posting of changes to these terms will mean you accept those changes, regardless of whether you are provided with additional notice of such changes. Listing data provided by GSREIN. Listing data is deemed accurate but not guaranteed. Other Broker's Listing.