Property Attributes
- MLS#2561770
- TypeSingle Family
- Listing Status Active
- CountyST TAMMANY
- CityMandeville
- NeighborhoodGreenleaves Cornerstone
- Zip70448
- StyleColonial
- Year Built1990
- Price$ 648,000
- Bedrooms5
- Full Bathrooms3
- Half Bathrooms1
- Sqr Footage4312
Data Source:
Gulf South Real Estate Information Network
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.
| Price History | |
|---|---|
| 6/9/2026 | Listed $749,900 |
| 7/8/2026 | 7$698,000 |
| 8/16/2026 | 8$648,000 |
General Features
| Sewer | Public Sewer |
|---|---|
| Heating | Multiple Heating Units |
| Cooling | 3+ Units |
| Roof | Shingle |
| Appliances | Cooktop,Double Oven,Dryer,Dishwasher,Disposal,Microwave,Washer |
| HOA Fee | 198 |
| Patio/Porch Features | Covered,Pavers,Patio |
| Architectural Style | Colonial |
| Pool Features | In Ground,Salt Water |
| Security Features | Fire Sprinkler System |
| Construction Materials | Brick |
| Year Built | 1990 |
| Stories Count | 2 |
| Levels | Two |
| Property Subtype | Detached |
| Assoc Fee Paid Per | Quarterly |
| County | St Tammany |
| Property Type | Residential |
| HOA | Yes |
| Subdivision Name | Greenleaves Cornerstone |
| Garage Y/N | Yes |
| Other Structures | Workshop |
| Total Rooms | 9 |
| Full Baths | 3 |
| Status | Active |
| City | Mandeville |
| Property Condition | Excellent |
| Standard Status | Active |
| Tax Lot | 36 |
| Property Sub Type Additional | Detached,Single Family Residence |
| PostalCity | Mandeville |
Interior Features
| Interior Amenities | Ceiling Fan(s),Granite Counters,Jetted Tub,Pantry,Stainless Steel Appliances |
|---|---|
| Fireplace Features | Gas |
| Air Conditioning Y/N | Yes |
| Heating Y/N | Yes |
| Fireplace Y/N | Yes |
| Half Baths | 1 |
| Total Bedrooms | 5 |
| LivingAreaSource | Appraiser |
Exterior Features
| Exterior Amenities | Fence,Sprinkler/Irrigation,Permeable Paving,Patio,Outdoor Kitchen |
|---|---|
| Parking Features | Attached,Garage,Two Spaces,Driveway,Garage Door Opener |
| Lot Features | Cul-De-Sac,Outside City Limits |
| Water Source | Public |
| Foundation Details | Slab |
| Spa | Yes |
| Building Area Total | 5774 |
| Lot Dimensions | 42x148x179x183 |
Room Details
| Room | Dimensions | Level | Flooring | Details |
|---|---|---|---|---|
| Bedroom | First | Wood | ||
| Bedroom | Second | Carpet | ||
| Bedroom | Second | Wood | ||
| Breakfast Room/Nook | First | Wood | ||
| Den | First | Wood | ||
| Dining Room | First | Wood | ||
| Kitchen | First | Wood | ||
| Primary Bedroom | First | Wood | ||
| Primary Bedroom | Second | Wood |
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
Copyright © 2026 New Orleans Metropolitan Association of REALTORS®, Inc. All Rights Reserved. The sharing of MLS database, or any portion thereof, with any unauthorized third party is strictly prohibited. Information contained on this site is believed to be reliable; yet, users of this web site are responsible for checking the accuracy, completeness, currency, or suitability of all information. Neither the New Orleans Metropolitan Association of REALTORS®, Inc. nor the Gulf South Real