$749,900
Mandeville, LA 70448
MLS# NO2561770
5 beds | 3.1 baths | 5774 sqft
1 / 41
Property Description
Nestled at the end of a cul-de-sac, this exceptional Colonial home offers stately curb appeal, generous living spaces and outstanding amenities designed for both everyday living and entertaining. Step inside to discover beautiful wood floors, a grand dining room that easily accommodates large family gatherings, holiday celebrations and elegant dinner parties. Just off the foyer, a versatile downstairs bedroom is currently used as a study, but can also serve as a downstairs primary suite, complete with it's own private bathroom. The spacious family room has a gas fireplace and is filled with natural light from the abundance of windows that offer a beautiful view of the backyard oasis. The open concept kitchen is the heart of the home featuring high end appliances ample workspace and a seamless flow into the breakfast area. For added convenience, the home boast a scullery, equipped with a second set of appliances for meal prep and additional storage. Outside, enjoy your own private retreat with the saltwater lap pool, hot tub and a spacious outdoor covered entertaining area for relaxing or for hosting guest year-round. The yard also has several fruit trees. Upstairs you will find four additional bedrooms, a lush primary bath including steam shower and spa tub. The large flexible bonus space can be used as either a game room, media room, or an oversized bedroom. The garage has an attached workshop which provides space for hobbies or additional outdoor storage. This meticulously maintained home combines classic elegance, modern conveniences and exceptional functionality all in one desirable location. This popular subdivision is only minutes from the Causeway bridge, great restaurants and shopping. For those who like to enjoy a nice walk or ride bikes, this house is adjacent to the subdivision path and also connects to Tammany Trace path. A true move in ready gem that offers a blend of comfort, style and space. Washer and dryer are included. Some furniture is for sale.
Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 173.91
Document Modified: 2026-06-09 08:46:29.521388
Status: Active
Listing Date: 2026-06-09
Listing Price: 749900
Current Price: $749,900
Type: Single Family Residence
Modification Timestamp: 2026-06-11T00:36:53Z
Photo Modified: 2026-06-09T13:51:43Z
General Property Description
Lot Dimensions: 42x148x179x183
Stories: 2
SqFt - Living: 4312
SqFt - Source: Appraiser
SqFt - Total: 5774
Assn Fee $: 198
Assn Fee Terms: Quarterly
Acreage Range: 0 - 0.5
# Bedrooms: 5
Baths - Full: 3
Baths - 1/2: 1
Total Baths: 3.1
Year Built: 1990
Remarks & Misc
Remarks: Nestled at the end of a cul-de-sac, this exceptional Colonial home offers stately curb appeal, generous living spaces and outstanding amenities designed for both everyday living and entertaining. Step inside to discover beautiful wood floors, a grand dining room that easily accommodates large family gatherings, holiday celebrations and elegant dinner parties. Just off the foyer, a versatile downstairs bedroom is currently used as a study, but can also serve as a downstairs primary suite, complete with it's own private bathroom. The spacious family room has a gas fireplace and is filled with natural light from the abundance of windows that offer a beautiful view of the backyard oasis. The open concept kitchen is the heart of the home featuring high end appliances ample workspace and a seamless flow into the breakfast area. For added convenience, the home boast a scullery, equipped with a second set of appliances for meal prep and additional storage. Outside, enjoy your own private retreat with the saltwater lap pool, hot tub and a spacious outdoor covered entertaining area for relaxing or for hosting guest year-round. The yard also has several fruit trees. Upstairs you will find four additional bedrooms, a lush primary bath including steam shower and spa tub. The large flexible bonus space can be used as either a game room, media room, or an oversized bedroom. The garage has an attached workshop which provides space for hobbies or additional outdoor storage. This meticulously maintained home combines classic elegance, modern conveniences and exceptional functionality all in one desirable location. This popular subdivision is only minutes from the Causeway bridge, great restaurants and shopping. For those who like to enjoy a nice walk or ride bikes, this house is adjacent to the subdivision path and also connects to Tammany Trace path. A true move in ready gem that offers a blend of comfort, style and space. Washer and dryer are included. Some furniture is for sale.
Office/Member/Contract Info
List AOR: NOMAR
Style
Colonial: 1
Parking
Attached: 1
Garage: 1
Construction
Brick: 1
Foundation
Slab: 1
Exterior
Outside Kitchen: 1
Patio
Covered: 1
Fireplace
Gas Log: 1
Roof
Composition: 1
Cooling
2 or More Units: 1
Appliances
Dishwasher: 1
Disposal: 1
Dryer: 1
Microwave: 1
Washer: 1
Countertops
Granite: 1
Rooms
Bedroom 1: 1
Den: 1
Dining Room: 1
Kitchen: 1
Primary Bedroom: 1
Bedroom 2: 1
Bedroom 3: 1
Fencing
Privacy: 1
Wood: 1
Other: 1
Lot
Cul-De-Sac: 1
Pool
Inground: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 58575304
Originating System Listing ID: 2561770
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 304
Street Name: VINE Court
Parish: St. Tammany
State: LA
Zip Code: 70448
Subdivision: Greenleaves Cornerstone
Tax Assessment Number: 45489
Directions: Bounding Streets: Cornerstone Drive Greenleaves Boulevard
Property Features
Style: Colonial
Parking: Attached; Garage
Construction: Brick
Foundation: Slab
Roof: Composition
Fireplace: Gas Log
Cooling: 2 or More Units
Appliances: Dishwasher; Disposal; Dryer; Microwave; Washer
Countertops: Granite
Rooms: Bedroom 1; Den; Dining Room; Kitchen; Primary Bedroom; Bedroom 2; Bedroom 3
Fencing: Privacy; Wood; Other
Lot: Cul-De-Sac
Patio: Covered
Exterior: Outside Kitchen
Pool: Inground
Room Information
| Room Name | Length | Width | Remarks |
| Primary Bedroom | 21.00 | 17.00 | Primary Bedroom |
| Primary Bedroom | 17.00 | 13.00 | Primary Bedroom |
| Den | 22.00 | 17.00 | Den |
| Dining Room | 17.00 | 12.00 | Dining Room |
| Kitchen | 17.00 | 12.00 | Kitchen |
| Bedroom 1 | 21.00 | 17.00 | Bedroom |
| Bedroom 2 | 14.00 | 12.00 | Bedroom |
| Bedroom 3 | 22.00 | 17.00 | Bedroom |
New Attachment IDX
Listing Office: Compass Covington (COMP27)
Last Updated: June - 11 - 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.