$589,900
Mandeville, LA 70448
MLS# NO2556491
Status: Pending
6 beds | 3 baths | 4000 sqft
1 / 35
Property Description
Experience a flawless blend of timeless Mandeville elegance and modern design in this extensively remodeled Acadian gem. Situated on a lush .45-acre corner lot in the sought-after Greenleaves Colony. This 5-bedroom, 3-bathroom + a game room or 6th bedroom home welcomes you with a deep, covered front porch. Lead glass door opens to 2 story foyer, with wood stairs and iron balusters, and a designer chandelier. Enter the formal dining room with another Gabby chandelier, which leads into the spacious kitchen. Casual eating area with shiplap vaulted ceiling makes a statement. The chef's kitchen is a true showpiece, boasting crisp white cabinetry, premium granite countertops, stainless steel appliances, and a potfiller. No detail was spared in the complete renovation, featuring all-new sheetrock, interior doors, fresh paint, and stunning engineered wood floors throughout. High-end designer lighting elevates the space, including a Gabby dining chandelier and E.F. Chapman fixtures. The primary suite serves as a private retreat, complete with a free-standing tub and a custom, walk-in glass-enclosed shower, Carrera marble counters and floors. Glass enclosed walk in shower, plus spacious closet complete the space. Large laundry room and 2 car garage also! Additional premium upgrades include a 2021 roof and a brand-new 2026 tankless water heater. Located in an excellent public school district with quick access to the Causeway Bridge, local shopping, and dining!
Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 178.97
Document Modified: 2026-06-06 12:24:46.173381
Status: Pending
Listing Date: 2026-06-03
Listing Price: 589900
Current Price: $589,900
Type: Single Family Residence
Modification Timestamp: 2026-06-15T16:05:28Z
Photo Modified: 2026-06-04T19:26:24Z
Location, Tax & Legal Info
Legal Desc: LOT 62 GREENLEAVES COLONY PH 1 CB 1278 742 CB 1350 157 CB 1488 625 INST NO 1125135 INST NO 1589568 INST NO 1639175 INST NO 1665567 INST NO 2004448 INST NO 2013319
General Property Description
Lot Dimensions: 120 x 140
SqFt - Living: 3296
SqFt - Source: Public Record
SqFt - Total: 4000
Assn Fee $: 198
Assn Fee Terms: Quarterly
Acreage Range: 0 - 0.5
Pool on Subject Property: No
# Bedrooms: 6
Baths - Full: 3
Total Baths: 3
Year Built: 1988
Acres: 0.45
Remarks & Misc
Remarks: Experience a flawless blend of timeless Mandeville elegance and modern design in this extensively remodeled Acadian gem. Situated on a lush .45-acre corner lot in the sought-after Greenleaves Colony. This 5-bedroom, 3-bathroom + a game room or 6th bedroom home welcomes you with a deep, covered front porch. Lead glass door opens to 2 story foyer, with wood stairs and iron balusters, and a designer chandelier. Enter the formal dining room with another Gabby chandelier, which leads into the spacious kitchen. Casual eating area with shiplap vaulted ceiling makes a statement. The chef's kitchen is a true showpiece, boasting crisp white cabinetry, premium granite countertops, stainless steel appliances, and a potfiller. No detail was spared in the complete renovation, featuring all-new sheetrock, interior doors, fresh paint, and stunning engineered wood floors throughout. High-end designer lighting elevates the space, including a Gabby dining chandelier and E.F. Chapman fixtures. The primary suite serves as a private retreat, complete with a free-standing tub and a custom, walk-in glass-enclosed shower, Carrera marble counters and floors. Glass enclosed walk in shower, plus spacious closet complete the space. Large laundry room and 2 car garage also! Additional premium upgrades include a 2021 roof and a brand-new 2026 tankless water heater. Located in an excellent public school district with quick access to the Causeway Bridge, local shopping, and dining!
Office/Member/Contract Info
List AOR: NOMAR
Style
Acadian: 1
Siding
Wood: 1
Parking
Attached: 1
Garage: 1
Construction
Brick: 1
Foundation
Slab: 1
Fireplace
Wood Burning: 1
Roof
Composition: 1
Heating
Central: 1
Interior
Vaulted Ceilings: 1
Cooling
2 or More Units: 1
Central Air: 1
Appliances
Dishwasher: 1
Microwave: 1
Rooms
Bedroom 1: 1
Dining Room: 1
Foyer: 1
Kitchen: 1
Laundry: 1
Living Room: 1
Primary Bedroom: 1
Game Room: 1
Bedroom 2: 1
Bedroom 3: 1
Bedroom 4: 1
Bedroom 5: 1
Bedroom 6: 1
Fencing
None: 1
Lot
Corner: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 58020231
Originating System Listing ID: 2556491
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 62
Street Name: COLONY TRAIL Drive
Parish: St. Tammany
State: LA
Zip Code: 70448
Subdivision: Greenleaves Colony
Tax Assessment Number: 44938
Directions: Greenleaves Blvd. to Colony, house is on the corner on left Bounding Streets: Greenleaves Boulevard
Status Change Info
Under Contract Date: 2026-06-08
Property Features
Style: Acadian
Siding: Wood
Parking: Attached; Garage
Construction: Brick
Foundation: Slab
Roof: Composition
Interior: Vaulted Ceilings
Fireplace: Wood Burning
Heating: Central
Cooling: 2 or More Units; Central Air
Appliances: Dishwasher; Microwave
Rooms: Bedroom 1; Dining Room; Foyer; Kitchen; Laundry; Living Room; Primary Bedroom; Game Room; Bedroom 2; Bedroom 3; Bedroom 4; Bedroom 5; Bedroom 6
Fencing: None
Lot: Corner
Room Information
| Room Name | Length | Width | Remarks |
| Bedroom 1 | 12.60 | 12.00 | Bedroom |
| Bedroom 2 | 17.00 | 14.00 | Bedroom |
| Game Room | 17.70 | 14.30 | Game Room |
| Dining Room | 12.70 | 12.10 | Dining Room |
| Bedroom 3 | 13.40 | 12.10 | Bedroom |
| Bedroom 4 | 12.10 | 11.50 | Bedroom |
| Primary Bedroom | 17.10 | 13.80 | Primary Bedroom |
| Bedroom 5 | 12.50 | 11.30 | Bedroom |
| Kitchen | 14.00 | 12.00 | Kitchen |
| Living Room | 21.80 | 20.60 | Living Room |
| Foyer | 15.30 | 8.10 | Foyer |
| Bedroom 6 | 17.00 | 14.00 | Bedroom |
| Laundry | 12.00 | 7.60 | Laundry |
Property Disclosures IDX
Listing Office: Coldwell Banker TEC
Last Updated: June - 15 - 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.