$639,000
Mandeville, LA 70448
MLS# NO2560969
5 beds | 3.2 baths | 3676 sqft
1 / 22
Property Description
Originally designed as the builder's personal home, this spacious beauty offers a rare combination of size, functionality, and luxury within the highly sought-after gated community of The Woodlands. With 5 bedrooms, 3 full baths, and 2 half baths, this home provides exceptional flexibility for everyday living, entertaining, multi-generational needs, or working from home. Thoughtful updates throughout. All bedroom flooring replaced in 2023 with ceramic plank. NO CARPET! Tankless water heaters added in 2023/2024. The home is equipped with two HVAC systems, one of which was fully updated inside and out in 2024, and the roof is approximately 7 years old. Designed for both comfort and peace of mind, the property also features a whole-home generator less than one year old, helping you stay prepared through hurricane season and beyond. Step outside into your own private backyard oasis featuring a heated in-ground pool, raised hot tub, and inviting outdoor living spaces perfect for relaxing or entertaining year-round. The covered patio provides plenty of space to gather, while a separate screened porch offers a comfortable spot to enjoy the outdoors year-round. A convenient pool half bath means guests can easily access restroom facilities without tracking water through the house. Located in one of Mandeville's few true gated communities, The Woodlands offers residents an unmatched lifestyle with neighborhood pools, tennis courts, basketball court, playgrounds, walking trails, green space, and year-round community events. Conveniently located near I-12, the Causeway, Pelican Park, and the Mandeville Lakefront, with access to award-winning schools and situated in Flood Zone X!
Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 218.84
Document Modified: 2026-06-03 09:58:17.934654
Status: Active
Listing Date: 2026-06-02
Listing Price: 639000
Current Price: $639,000
Type: Single Family Residence
Modification Timestamp: 2026-06-03T16:00:06Z
Photo Modified: 2026-06-02T17:51:36Z
General Property Description
Lot Dimensions: 13318
Stories: 1
SqFt - Living: 2920
SqFt - Source: Measured
SqFt - Total: 3676
Assn Fee $: 288
Assn Fee Terms: Quarterly
Acreage Range: 0 - 0.5
# Bedrooms: 5
Baths - Full: 3
Baths - 1/2: 2
Total Baths: 3.2
Year Built: 2005
Remarks & Misc
Remarks: Originally designed as the builder's personal home, this spacious beauty offers a rare combination of size, functionality, and luxury within the highly sought-after gated community of The Woodlands. With 5 bedrooms, 3 full baths, and 2 half baths, this home provides exceptional flexibility for everyday living, entertaining, multi-generational needs, or working from home. Thoughtful updates throughout. All bedroom flooring replaced in 2023 with ceramic plank. NO CARPET! Tankless water heaters added in 2023/2024. The home is equipped with two HVAC systems, one of which was fully updated inside and out in 2024, and the roof is approximately 7 years old. Designed for both comfort and peace of mind, the property also features a whole-home generator less than one year old, helping you stay prepared through hurricane season and beyond. Step outside into your own private backyard oasis featuring a heated in-ground pool, raised hot tub, and inviting outdoor living spaces perfect for relaxing or entertaining year-round. The covered patio provides plenty of space to gather, while a separate screened porch offers a comfortable spot to enjoy the outdoors year-round. A convenient pool half bath means guests can easily access restroom facilities without tracking water through the house. Located in one of Mandeville's few true gated communities, The Woodlands offers residents an unmatched lifestyle with neighborhood pools, tennis courts, basketball court, playgrounds, walking trails, green space, and year-round community events. Conveniently located near I-12, the Causeway, Pelican Park, and the Mandeville Lakefront, with access to award-winning schools and situated in Flood Zone X!
Office/Member/Contract Info
List AOR: NOMAR
Style
Traditional: 1
Siding
Stucco: 1
Parking
Garage: 1
Equipment
Generator: 1
Construction
Brick: 1
Other: 1
Foundation
Slab: 1
Patio
Covered: 1
Fireplace
Gas Log: 1
Roof
Composition: 1
Heating
Central: 1
Cooling
2 or More Units: 1
Central Air: 1
Appliances
Dishwasher: 1
Microwave: 1
Refrigerator: 1
Countertops
Granite: 1
Rooms
Bedroom 1: 1
Dining Room: 1
Living Room: 1
Primary Bedroom: 1
Bedroom 2: 1
Bedroom 3: 1
Bedroom 4: 1
Fencing
Wood: 1
Other: 1
Other Structures
Workshop: 1
Pool
Inground: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 58487016
Originating System Listing ID: 2560969
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 1174
Street Name: SCARLET OAK Lane
Parish: St. Tammany
State: LA
Zip Code: 70448
Subdivision: The Woodlands
Tax Assessment Number: 53634
Directions: Use GPS Bounding Streets: Butternut & Kingswood
Property Features
Style: Traditional
Siding: Stucco
Parking: Garage
Construction: Brick; Other
Foundation: Slab
Roof: Composition
Fireplace: Gas Log
Heating: Central
Cooling: 2 or More Units; Central Air
Appliances: Dishwasher; Microwave; Refrigerator
Countertops: Granite
Rooms: Bedroom 1; Dining Room; Living Room; Primary Bedroom; Bedroom 2; Bedroom 3; Bedroom 4
Equipment: Generator
Fencing: Wood; Other
Patio: Covered
Other Structures: Workshop
Pool: Inground
Room Information
| Room Name | Length | Width | Remarks |
| Bedroom 1 | 11.00 | 11.50 | Bedroom |
| Bedroom 2 | 11.80 | 11.70 | Bedroom |
| Living Room | 18.50 | 22.40 | Living Room |
| Dining Room | 12.50 | 12.10 | Dining Room |
| Bedroom 3 | 14.40 | 15.50 | Bedroom |
| Bedroom 4 | 10.70 | 13.30 | Bedroom |
| Primary Bedroom | 16.20 | 18.20 | Primary Bedroom |
Recent Termite Service IDX
Listing Office: Blue Heron Realty
Last Updated: June - 03 - 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.