Waterfront
Address
1174 Scarlet Oak Lane, Mandeville, LA
Price
$ 629,000
Property Attributes
  • MLS#2560969
  • TypeSingle Family
  • Listing Status Active
  • CountyST TAMMANY
  • CityMandeville
  • NeighborhoodThe Woodlands
  • Zip70448
  • StyleTraditional
  • Year Built2005
  • Price$ 629,000
  • Bedrooms5
  • Full Bathrooms3
  • Half Bathrooms2
  • Sqr Footage2920
Data Source:
Gulf South Real Estate Information Network
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!

Price History
6/2/2026 Listed $639,000
6/25/2026 2$629,000

General Features

Sewer Public Sewer
Heating Central,Multiple Heating Units
Cooling Central Air,2 Units
Roof Shingle
Appliances Dishwasher,Microwave,Oven,Range,Refrigerator
HOA Fee 288
Patio/Porch Features Covered
Architectural Style Traditional
Pool Features Heated,In Ground
Construction Materials Brick,Stucco
Year Built 2005
Electric Generator
Stories Count 1
Levels One
Property Subtype Detached
Assoc Fee Paid Per Quarterly
County St Tammany
Property Type Residential
HOA Yes
Subdivision Name The Woodlands
Garage Y/N Yes
Other Structures Shed(s)
Total Rooms 7
Full Baths 3
Status Active
Directions Use GPS
City Mandeville
Property Condition Excellent
Standard Status Active
Tax Lot 348
Property Sub Type Additional Detached,Single Family Residence
PostalCity Mandeville

Interior Features

Interior Amenities Carbon Monoxide Detector,Granite Counters,Pantry
Fireplace Features Gas
Air Conditioning Y/N Yes
Heating Y/N Yes
Fireplace Y/N Yes
Half Baths 2
Total Bedrooms 5
LivingAreaSource Measured

Exterior Features

Exterior Amenities Fence
Parking Features Garage,Two Spaces,Garage Door Opener
Lot Features Outside City Limits,Rectangular Lot
Water Source Public
Foundation Details Slab
Spa Yes
Building Area Total 3676
Lot Dimensions 13318

Room Details

Room Dimensions Level Flooring Details
Bedroom Lower
Bedroom Lower
Bedroom Lower
Bedroom Lower
Dining Room Lower
Living Room Lower
Primary Bedroom Lower

Amenities

  • Foreclosure
  • Views
  • Short Sale
  • New Construction
  • Adult 55+
  • Lease To Own
  • No HOA Fees
  • Furnished
  • Primary On Main
  • Air Conditioning
  • Seller Finance
  • Green
  • Fixer Upper
  • Horse
  • Golf
  • Fireplace
  • Deck
  • Garage
  • Basement
  • Pool

Property vs Single Family Average in 70448

Price
AVG $550K
$630K
Year Built
AVG 1990
2005
Visits
AVG 97
104
Data Provided by Inside Real Estate®

Looking for a more comfortable experience?

Download our mobile app for a personalized browsing experience.

Areas We Cover