$795,500
Mandeville, LA 70471
MLS# NO2544385
Status: Pending
5 beds | 4 baths | 3858 sqft
1 / 31
Property Description
Pristine 5-Bedroom Estate with Custom Pool in Woodstone. This immaculate 5-bedroom, 4-bath home in the prestigious Woodstone subdivision offers luxury living with exceptional indoor and outdoor spaces. Situated among estate-sized homes and oversized lots, this property combines elegance, comfort, and thoughtful updates throughout. Step inside to discover soaring high ceilings, rich hardwood floors, granite countertops, and custom knotty pine cabinetry. The spacious layout features oversized bedrooms, a large living area, dedicated study, and a charming keeping room--perfect for additional gathering space or a cozy retreat. The primary suite boasts a beautifully updated bath (Summer 2024), creating a spa-like escape. All carpet has been replaced with high-end, tightly-woven Berber flooring, and durable LVT has been recently installed in the game room, office, and downstairs guest bedrooms for both style and functionality. Designed for entertaining, the backyard showcases a custom pool with new LED lighting, a new heater (warrantied through 2027), and an updated control panel (2021). The immaculate, lush landscaping enhances the outdoor entertaining space, making it ideal for gatherings year-round. Major system upgrades include three HVAC units replaced in 2024, including all ductwork, offering peace of mind and energy efficiency. Located just minutes from the Causeway Bridge, premier dining, and top-rated schools, this exceptional home offers the perfect blend of luxury, convenience, and comfort.
Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 215
Document Modified: 2026-03-11 13:31:17.371574
Status: Pending
Listing Date: 2026-02-26
Listing Price: 795500
Current Price: $795,500
Type: Single Family Residence
Modification Timestamp: 2026-03-11T18:46:37Z
Photo Modified: 2026-02-26T10:15:44Z
Location, Tax & Legal Info
Legal Desc: LOT 15 WOODSTONE PH 2B INST NO 1203397 INST NO 1442431 INST NO 1504253 INST NO 1785259 INST NO 2184845
General Property Description
Lot Dimensions: 90 x 140 x 90 x 140
Stories: 2
SqFt - Living: 3700
SqFt - Source: Appraiser
SqFt - Total: 3858
Assn Fee $: 550
Assn Fee Terms: Yearly
Acreage Range: 0 - 0.5
# Bedrooms: 5
Baths - Full: 4
Total Baths: 4
Year Built: 2005
Acres: 0.28
Remarks & Misc
Remarks: Pristine 5-Bedroom Estate with Custom Pool in Woodstone. This immaculate 5-bedroom, 4-bath home in the prestigious Woodstone subdivision offers luxury living with exceptional indoor and outdoor spaces. Situated among estate-sized homes and oversized lots, this property combines elegance, comfort, and thoughtful updates throughout. Step inside to discover soaring high ceilings, rich hardwood floors, granite countertops, and custom knotty pine cabinetry. The spacious layout features oversized bedrooms, a large living area, dedicated study, and a charming keeping room--perfect for additional gathering space or a cozy retreat. The primary suite boasts a beautifully updated bath (Summer 2024), creating a spa-like escape. All carpet has been replaced with high-end, tightly-woven Berber flooring, and durable LVT has been recently installed in the game room, office, and downstairs guest bedrooms for both style and functionality. Designed for entertaining, the backyard showcases a custom pool with new LED lighting, a new heater (warrantied through 2027), and an updated control panel (2021). The immaculate, lush landscaping enhances the outdoor entertaining space, making it ideal for gatherings year-round. Major system upgrades include three HVAC units replaced in 2024, including all ductwork, offering peace of mind and energy efficiency. Located just minutes from the Causeway Bridge, premier dining, and top-rated schools, this exceptional home offers the perfect blend of luxury, convenience, and comfort.
Office/Member/Contract Info
List AOR: NOMAR
Style
French: 1
Siding
Stucco: 1
Vinyl Siding: 1
Parking
Attached: 1
Garage: 1
Construction
Brick: 1
Foundation
Slab: 1
Fireplace
Gas Log: 1
Roof
Composition: 1
Heating
Central: 1
Interior
Guest Suite: 1
Handicap Acc: 1
Cooling
2 or More Units: 1
Central Air: 1
Appliances
Dishwasher: 1
Disposal: 1
Dryer: 1
Microwave: 1
Refrigerator: 1
Washer: 1
Countertops
Granite: 1
Rooms
Bedroom 1: 1
Den: 1
Dining Room: 1
Kitchen: 1
Laundry: 1
Living Room: 1
Primary Bedroom: 1
Bedroom 2: 1
Bedroom 3: 1
Bedroom 4: 1
Fencing
Wood: 1
Other: 1
Pool
Inground: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 57158716
Originating System Listing ID: 2544385
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 27
Street Name: BRETTON Way
Parish: St. Tammany
State: LA
Zip Code: 70471
Subdivision: Woodstone Sub
Tax Assessment Number: 61213
Directions: from West Causeway Approach, enter either Woodstone entrance, drive to Bretton Way & turn; home is in the middle of the block, backs up to field behind school. Bounding Streets: West Causeway Approach, Mark Smith Dr.,
Status Change Info
Under Contract Date: 2026-03-05
Property Features
Style: French
Siding: Stucco; Vinyl Siding
Parking: Attached; Garage
Construction: Brick
Foundation: Slab
Roof: Composition
Interior: Guest Suite; Handicap Acc
Fireplace: Gas Log
Heating: Central
Cooling: 2 or More Units; Central Air
Appliances: Dishwasher; Disposal; Dryer; Microwave; Refrigerator; Washer
Countertops: Granite
Rooms: Bedroom 1; Den; Dining Room; Kitchen; Laundry; Living Room; Primary Bedroom; Bedroom 2; Bedroom 3; Bedroom 4
Fencing: Wood; Other
Pool: Inground
Room Information
| Room Name | Length | Width | Remarks |
| Laundry | 8.00 | 7.00 | Laundry |
| Bedroom 1 | 18.80 | 13.50 | Bedroom |
| Primary Bedroom | 15.00 | 15.00 | Primary Bedroom |
| Kitchen | 14.00 | 13.00 | Kitchen |
| Bedroom 2 | 13.00 | 12.00 | Bedroom |
| Living Room | 18.00 | 21.00 | Living Room |
| Den | 14.00 | 12.00 | Den |
| Bedroom 3 | 11.00 | 13.00 | Bedroom |
| Bedroom 4 | 13.00 | 14.00 | Bedroom |
| Dining Room | 13.00 | 10.00 | Dining Room |
27 Bretton Way floorplan IDX
Listing Office: Coldwell Banker TEC
Last Updated: March - 11 - 2026
The data relating to real estate for sale or lease on this website comes in part from the IDX program of the REALTOR® Association of Acadiana MLS. The IDX information is provided exclusively for consumers’ personal, non-commericial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed accurate by the MLS.
GUIDRY & CO. REAL ESTATE, Lafayette, LA. All offices are independently owned and operated. The data relating to real estate for sale on this web site comes in part from the IDX Program of the Realtor® Association of Acadiana; MLS Real Estate listings held by brokerage firms other than GUIDRY & CO. REAL ESTATE are marked with the MLS approved icon for
IDX
. “Information Deemed Reliable But Not Guaranteed”. Copyright 2016 REALTOR® Association of Acadiana, All rights reserved.
Licensed & Regulated in the jurisdiction of the Louisiana Real Estate Commission, Members of the National Association of Realtors®, Louisiana Realtors®, Realtor® Association of Acadiana, Multiple Listing Service (MLS), Louisiana Commercial (www.lacdb.com), The Realtor® Commercial Alliance, Equal Housing Opportunity.