This home's estimate is 24.4% higher than the average sale price ($460K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood













823 Brewster Rd, Madisonville, LA 70447
About this home
Grand New Construction on 1/2 Acre Lot with plenty room for RV/ Boat /additional garage/ work room/ swim pool/ Cabana. Property has triple driveway, double garage and circular driveway on corner lot, kitchen island open to living room, quartz counters throughout, office room, mud room, living room with raised wood ceiling, beautiful electric fireplace on stone wall that can be used year round with bookcases in family room and wall of windows, luxurious master bedroom and bath with marble look tile in shower, with a total of 4 bedrooms plus an office and 3 baths, wood look tile throughout and no carpet, upgraded lighting with lighted mirrors in bath, breakfast room and family room has gorgeous chandeliers and windows overlooking extra large rear patio 32.5' x 13', brick front porch, 6 gallon electric hot water heater fed by tank-less hot water heater for faster, endless hot water, very high elevation 24 feet above sea level in Flood Zone C. Low Homeowner Dues $45 Quarterly. $15,000 Total for closing cost, interest rate buy down, fence, decorating allowance. Continue To Show
Redfin Estimate
Earn from this home
List your home with Redfin and save $5,726
List your home for rent
Market trends in 70447, LA
Last updated October 2026
Buyer's Market
Seller's Market
Balanced market
See all
Provided by Redfin
Sale history for 823 Brewster Rd
$242/sq ft
$242/sq ft
$243/sq ft
$255/sq ft
As the MLS and public records start to fill up, we'll list the details here.
Public record
Property details
Parking
- Garage/Carport Information
- Has Garage
- Parking
- Features: Garage, Two Spaces, Garage Door Opener
Interior
- Bathroom Information
- # of Full Bathrooms: 3
- Room Information
- # of Rooms (Total): 12
- Equipment
- Appliances: Cooktop, Microwave, Oven
- Interior Features
- Window Features: Screen(s)
- Other Features: Attic, Tray Ceiling(s), Ceiling Fan(s), Pantry, Pull Down Attic Stairs, Stone Counters
Exterior
- Building Information
- Stories: 1
- Year Built Details: 0
- New Construction
- Roof Details: Shingle
- Construction Details: Brick, Stucco
- Builder Name: Grand Homes
- Exterior Features
- Patio And Porch Features: Covered, Oversized
- Security Features: Smoke Detector(s)
- Green Features
- Green Energy Efficient: HVAC, Insulation, Water Heater, Windows
- Lot Information
- Lot Size Area: 0.5
- Lot Size Acres: 0.5
- Lot Size Dimensions: 125.9 x 171.25x135,84x171,25
- Lot Features: Outside City Limits, Oversized Lot
- Property Information
- Foundation Details: Slab
- Never Occupied, New Construction
Utilities
- Utility Information
- Sewer: Public Sewer
- Water Source: Public
- Heating & Cooling
- Has Cooling
- Cooling: Central Air, 1 Unit
- Has Heating
Location
- HOA Information
- Has Home Owners Association
- Association Fee: $45
- Quarterly
Public facts
- Beds: —
- Baths: —
- Sq. Ft.: —
- Stories: —
- Lot Size: —
- Style: Single Family Residential
- Year Built: —
- Year Renovated: —
- County: St. Tammany Parish
- APN: —
Other
- Listing Information
- Is Human Modified
Around this home
Schools
Public 3-6 • Assigned • 1.6mi
Public 7-8 • Assigned • 4.4mi
Public 9-12 • Assigned • 8.4mi
Lifestyle
Provided by Walk Score and Local Logic
Sun exposure
In this area, properties receive around 9.1 hours in June and 5 hours in December, which is comparable to the U.S. average for solar exposure.
Nearby similar homes
New listings for sale in 70447
Home values near 823 Brewster Rd
| Address | Redfin Estimate |
|---|---|
- Beds | - Baths | 2810 Sq. Ft. | $637,033 |
4 Beds | 2 Baths | 1885 Sq. Ft. | $341,817 |
| Address | Redfin Estimate |
|---|---|
4 Beds | 3 Baths | 2751 Sq. Ft. | $683,390 |
3 Beds | 2 Baths | 1987 Sq. Ft. | $370,547 |
| Address | Redfin Estimate |
|---|---|
4 Beds | 2 Baths | 1990 Sq. Ft. | $367,038 |
4 Beds | 2 Baths | 2204 Sq. Ft. | $366,619 |
More real estate resources
- Zip Codes
- Cities
- Popular Searches
| 70447 homes for sale | |||
| 70433 homes for sale |
| Mandeville homes for sale | |||
| Covington homes for sale | |||
| New Orleans homes for sale |
Find us
Subsidiaries
Affiliated Business
Copyright: © 2026 Redfin. All rights reserved.
Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.
Do not sell or share my personal information.
REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.
California DRE #01521930
Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures
New Mexico Real Estate Licenses
TREC: Info About Brokerage Services, Consumer Protection Notice
All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.
Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.
If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.
REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.


















































United States
Canada