$787,000
Madisonville, LA 70448
MLS# NO2558640
5 beds | 3 baths | 4600 sqft
1 / 20
Property Description
**Agents Protected** Stunning Southern Traditional home on nearly an acre with private lake access in the gated community of The Lakes. This established Mandeville neighborhood features large lots, mature trees, and an ideal location near the St. Tammany Trace and just 2.5 miles from Lake Pontchartrain. This beautifully updated home offers 5 bedrooms, 3 full baths, a dedicated office, and a three car garage with extended parking pad. The backyard is a true retreat with an in ground pool, outdoor kitchen, pergola, and private access to the stocked neighborhood lake--perfect for canoeing, paddleboarding, or fishing. Inside, the home welcomes you with a private office and a formal dining room. The living room, anchored by a gas fireplace, flows into the updated kitchen featuring Quartz countertops, stainless steel appliances, and generous prep space. The breakfast area overlooks the pool and the wooded south side of the property, offering a peaceful setting for daily meals. The oversized primary suite provides a luxurious escape with a soaking tub, dual vanities, and a glass enclosed walk in shower. Significant updates completed over the past two years include: * Full outdoor kitchen, pergola, and pool fencing * Whole house natural gas generator * Two new HVAC systems with new interior air handlers and ductwork * New water heater * Updated kitchen and all three bathrooms A rare opportunity to enjoy privacy, water access, and modern upgrades in one of Mandeville's most desirable gated communities.
Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 227.46
Document Modified: 2026-05-20 13:26:48.393153
Status: Active
Listing Date: 2026-05-20
Listing Price: 787000
Current Price: $787,000
Type: Single Family Residence
Modification Timestamp: 2026-05-22T02:20:56Z
Photo Modified: 2026-05-20T18:26:50Z
Location, Tax & Legal Info
Legal Desc: LOT 53B THE LAKES OF GREENLEAVES PH 1 CB 1367 303 INST NO 1215590 INST NO 1392648 INST NO 1515034 INST NO 1812139 INST NO 1888967 GREENLEAVES LAKES THE
General Property Description
Lot Dimensions: 220x248x288x60
Stories: 2
SqFt - Living: 3460
SqFt - Source: Appraiser
SqFt - Total: 4600
Assn Fee $: 1400
Assn Fee Terms: Yearly
Acreage Range: 0.51 - 0.99
# Bedrooms: 5
Baths - Full: 3
Total Baths: 3
Year Built: 1991
Acres: 0.92
Remarks & Misc
Remarks: **Agents Protected** Stunning Southern Traditional home on nearly an acre with private lake access in the gated community of The Lakes. This established Mandeville neighborhood features large lots, mature trees, and an ideal location near the St. Tammany Trace and just 2.5 miles from Lake Pontchartrain. This beautifully updated home offers 5 bedrooms, 3 full baths, a dedicated office, and a three car garage with extended parking pad. The backyard is a true retreat with an in ground pool, outdoor kitchen, pergola, and private access to the stocked neighborhood lake--perfect for canoeing, paddleboarding, or fishing. Inside, the home welcomes you with a private office and a formal dining room. The living room, anchored by a gas fireplace, flows into the updated kitchen featuring Quartz countertops, stainless steel appliances, and generous prep space. The breakfast area overlooks the pool and the wooded south side of the property, offering a peaceful setting for daily meals. The oversized primary suite provides a luxurious escape with a soaking tub, dual vanities, and a glass enclosed walk in shower. Significant updates completed over the past two years include: * Full outdoor kitchen, pergola, and pool fencing * Whole house natural gas generator * Two new HVAC systems with new interior air handlers and ductwork * New water heater * Updated kitchen and all three bathrooms A rare opportunity to enjoy privacy, water access, and modern upgrades in one of Mandeville's most desirable gated communities.
Office/Member/Contract Info
List AOR: NOMAR
Style
Colonial: 1
Siding
Vinyl Siding: 1
Foundation
Slab: 1
Fireplace
Gas Log: 1
Roof
Composition: 1
Heating
Central: 1
Cooling
2 or More Units: 1
Central Air: 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
Pool
Inground: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 58205289
Originating System Listing ID: 2558640
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 6006
Street Name: WALDEN Place
Parish: St. Tammany
State: LA
Zip Code: 70448
Subdivision: The Lakes
Tax Assessment Number: 45790
Directions: Bounding Streets: Greenleaves Blvd., Lonesome Road
Property Features
Style: Colonial
Siding: Vinyl Siding
Foundation: Slab
Roof: Composition
Fireplace: Gas Log
Heating: Central
Cooling: 2 or More Units; Central Air
Rooms: Bedroom 1; Den; Dining Room; Kitchen; Laundry; Living Room; Primary Bedroom; Bedroom 2; Bedroom 3; Bedroom 4
Pool: Inground
Room Information
| Room Name | Length | Width | Remarks |
| Bedroom 1 | 15.80 | 11.60 | Bedroom |
| Bedroom 2 | 15.80 | 11.60 | Bedroom |
| Living Room | 14.90 | 12.90 | Living Room |
| Bedroom 3 | 14.20 | 13.80 | Bedroom |
| Bedroom 4 | 14.20 | 13.80 | Bedroom |
| Dining Room | 15.20 | 14.20 | Dining Room |
| Den | 24.00 | 18.40 | Den |
| Laundry | 8.00 | 6.00 | Laundry |
| Kitchen | 15.90 | 13.90 | Kitchen |
| Primary Bedroom | 20.00 | 16.00 | Primary Bedroom |
New Attachment IDX
Listing Office: Falaya
Last Updated: May - 22 - 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.