$545,000
Mandeville, LA 70448
MLS# NO2551714
4 beds | 2.1 baths | 3855 sqft
1 / 27
Property Description
Charming French country home with timeless character located in highly desirable Greenleaves. Offering a detached guesthouse with a full bath great for an office, your private home gym or entertaining guests. Featuring a fully renovated kitchen with stainless steal appliances, modern finishes every cook craves and updated bathrooms throughout. The primary suite offers a spa-like retreat, separate tub and custom walk-in shower in travertine. The flexible floor plan has a fourth bedroom currently used as an office suited for todays lifestyle includes two separate living areas with beautiful hardwood and brick floors and tongue and groove cypress ceiling. The den leads to the brick covered patio and outdoors with several gas lanterns copper gutters and a new fortified roof! The patio overlooks a serene flagstone courtyard, expansive landscaped yard and stunning fountain creating a serene space for relaxing or entertaining. All of this with St. Tammany Trace, easy access to the Causeway bridge, top rated schools, shopping, restaurants and the beauty of Lake Ponchatrain. The charm of this home and the sanctuary of this courtyard make this one you won't want to leave.
Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 168.99
Document Modified: 2026-04-15 12:15:31.478363
Status: Active
Listing Date: 2026-04-14
Listing Price: 545000
Current Price: $545,000
Type: Single Family Residence
Modification Timestamp: 2026-04-23T06:35:00Z
Photo Modified: 2026-04-14T15:19:02Z
Location, Tax & Legal Info
Legal Desc: Lot 53 Greenleaves Colony SUB PH 1
General Property Description
Lot Dimensions: 100x142x100x139
Stories: 2
SqFt - Living: 3225
SqFt - Source: Public Record
SqFt - Total: 3855
Assn Fee $: 190
Assn Fee Terms: Quarterly
Acreage Range: 0 - 0.5
Pool on Subject Property: No
# Bedrooms: 4
Baths - Full: 2
Baths - 1/2: 1
Total Baths: 2.1
Year Built: 1987
Remarks & Misc
Remarks: Charming French country home with timeless character located in highly desirable Greenleaves. Offering a detached guesthouse with a full bath great for an office, your private home gym or entertaining guests. Featuring a fully renovated kitchen with stainless steal appliances, modern finishes every cook craves and updated bathrooms throughout. The primary suite offers a spa-like retreat, separate tub and custom walk-in shower in travertine. The flexible floor plan has a fourth bedroom currently used as an office suited for todays lifestyle includes two separate living areas with beautiful hardwood and brick floors and tongue and groove cypress ceiling. The den leads to the brick covered patio and outdoors with several gas lanterns copper gutters and a new fortified roof! The patio overlooks a serene flagstone courtyard, expansive landscaped yard and stunning fountain creating a serene space for relaxing or entertaining. All of this with St. Tammany Trace, easy access to the Causeway bridge, top rated schools, shopping, restaurants and the beauty of Lake Ponchatrain. The charm of this home and the sanctuary of this courtyard make this one you won't want to leave.
Office/Member/Contract Info
List AOR: NOMAR
Style
French: 1
Siding
Hardiplank: 1
Stucco: 1
Parking
Attached: 1
Garage: 1
Construction
Brick: 1
Foundation
Slab: 1
Patio
Covered: 1
Fireplace
Gas Log: 1
Roof
Composition: 1
Cooling
2 or More Units: 1
Appliances
Dishwasher: 1
Disposal: 1
Microwave: 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
Bedroom 5: 1
Bedroom 6: 1
Bedroom 7: 1
Bedroom 8: 1
Fencing
Partial: 1
Other: 1
Other Structures
Barn(s): 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 57669539
Originating System Listing ID: 2551714
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 53
Street Name: COLONY TRAIL Drive
Parish: St. Tammany
State: LA
Zip Code: 70448
Subdivision: Greenleaves Colony
Tax Assessment Number: 45020
Directions: HWY 190 to Greenleaves. Turn into Greenleaves Colony. Take a left onto Colony Trail Dr. House will be on the right. Bounding Streets: Wingate Talbot
Property Features
Style: French
Siding: Hardiplank; Stucco
Parking: Attached; Garage
Construction: Brick
Foundation: Slab
Roof: Composition
Fireplace: Gas Log
Cooling: 2 or More Units
Appliances: Dishwasher; Disposal; Microwave
Countertops: Granite
Rooms: Bedroom 1; Den; Dining Room; Kitchen; Laundry; Living Room; Primary Bedroom; Bedroom 2; Bedroom 3; Bedroom 4; Bedroom 5; Bedroom 6; Bedroom 7; Bedroom 8
Fencing: Partial; Other
Patio: Covered
Other Structures: Barn(s)
Room Information
| Room Name | Length | Width | Remarks |
| Laundry | 11.00 | 7.00 | Laundry |
| Laundry | 11.00 | 7.00 | Laundry |
| Laundry | 11.00 | 7.00 | Laundry |
| Living Room | 19.00 | 19.00 | Living Room |
| Living Room | 19.00 | 19.00 | Living Room |
| Living Room | 19.00 | 19.00 | Living Room |
| Bedroom 1 | 15.40 | 11.10 | Bedroom |
| Bedroom 2 | 15.40 | 11.10 | Bedroom |
| Bedroom 3 | 15.40 | 12.50 | Bedroom |
| Bedroom 4 | 15.40 | 12.50 | Bedroom |
| Den | 21.00 | 19.00 | Den |
| Den | 21.00 | 19.00 | Den |
| Den | 21.00 | 19.00 | Den |
| Bedroom 5 | 11.50 | 10.00 | Bedroom |
| Dining Room | 12.00 | 12.00 | Dining Room |
| Dining Room | 12.00 | 12.00 | Dining Room |
| Dining Room | 12.00 | 12.00 | Dining Room |
| Primary Bedroom | 15.80 | 15.40 | Primary Bedroom |
| Primary Bedroom | 15.80 | 15.40 | Primary Bedroom |
| Primary Bedroom | 15.80 | 15.40 | Primary Bedroom |
| Kitchen | 16.00 | 12.00 | Kitchen |
| Kitchen | 16.00 | 12.00 | Kitchen |
| Kitchen | 16.00 | 12.00 | Kitchen |
| Bedroom 6 | 11.50 | 10.00 | Bedroom |
| Bedroom 7 | 15.40 | 12.50 | Bedroom |
| Bedroom 8 | 15.40 | 11.10 | Bedroom |
Property Disclosures IDX
Listing Office: Compass Mandeville (COMP15)
Last Updated: April - 23 - 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.