Property Attributes
- MLS#2504031
- TypeSingle Family
- Listing Status Active
- CountyST TAMMANY
- CityMandeville
- NeighborhoodLewisburg
- Zip70448
- StyleTraditional
- Year Built2001
- Price$ 2,700,000
- Bedrooms3
- Full Bathrooms4
- Half Bathrooms1
- Sqr Footage4558
- Lot Size2.23 Acres
Data Source:
Gulf South Real Estate Information Network
Property Description
Experience year-round vacation living in one of the most magnificent homes in Historic Lewisburg, set on three expansive lots directly on the shores of Lake Pontchartrain. This extraordinary waterfront estate captures breathtaking panoramic views from every room and welcomes refreshing lake breezes across its many porches and patios. Inside, a grand living room with soaring ceilings and elegant French doors opens seamlessly to a stunning screened-in porch complete with an outdoor TV—perfect for entertaining or unwinding at sunset. A separate den with a wet bar provides additional space to relax, while the glass-lined dining room beautifully blends indoor and outdoor living. The chef’s kitchen is equipped with professional-grade appliances, sleek quartz countertops, and an adjacent climate-controlled wine cellar. The luxurious owner’s suite serves as a private retreat, featuring a spa-inspired bath and its own secluded study. The ground level offers exceptional functionality with abundant storage, a climate-controlled gym, a full bath, and a covered patio designed for lakefront barbecues and crawfish boils. An elevator and whole-house generator add both convenience and peace of mind. Extensive recent improvements elevate this remarkable property even further, including a newly constructed 500-foot all-steel and fiberglass pier with an 18-ton boat lift, enhanced grading with underground drainage and irrigation, a rebuilt exterior staircase, a finished ground floor with epoxy flooring, three new HVAC systems, a new septic system, and the addition of a private Padel tennis court.
| Price History | |
|---|---|
| 6/6/2025 | Listed $3,000,000 |
| 4/8/2026 | 2$2,950,000 |
| 6/11/2026 | 9$2,700,000 |
General Features
| Sewer | Septic Tank |
|---|---|
| Heating | Central,Multiple Heating Units |
| Cooling | Central Air,3+ Units |
| Roof | Metal |
| Appliances | Dishwasher,Ice Maker,Microwave,Oven,Range,Refrigerator |
| Patio/Porch Features | Covered,Balcony,Porch,Screened |
| Architectural Style | Traditional |
| Pool Features | None |
| Security Features | Security System,Fire Sprinkler System |
| Construction Materials | Stucco |
| Year Built | 2001 |
| Electric | Generator |
| Stories Count | 3 |
| Levels | Three Or More |
| Property Subtype | Detached |
| Waterfront Features | Waterfront,Lake |
| County | St Tammany |
| Property Type | Residential |
| Subdivision Name | Lewisburg |
| Garage Y/N | Yes |
| Other Structures | Other |
| Total Rooms | 9 |
| Full Baths | 4 |
| Status | Active |
| City | Mandeville |
| Property Condition | Excellent |
| Standard Status | Active |
| Property Sub Type Additional | Detached,Single Family Residence |
| PostalCity | Mandeville |
| Legal Description | LOT 27-A (.66ACS) LOT 27-B (.69ACS) LOT 28-A (.88ACS) LEWISBURG CB 700 803 CB 706 328 CB 735 360 CB 1050 819 CB 1103 21 CB 1170 786 CB 1287 164 INST N |
Interior Features
| Interior Amenities | Cathedral Ceiling(s),Elevator,High Ceilings,Stainless Steel Appliances,Vaulted Ceiling(s) |
|---|---|
| Fireplace Features | Gas |
| Air Conditioning Y/N | Yes |
| Heating Y/N | Yes |
| Fireplace Y/N | Yes |
| Half Baths | 1 |
| Total Bedrooms | 3 |
| LivingAreaSource | Appraiser |
Exterior Features
| Exterior Amenities | Balcony,Dock,Enclosed Porch |
|---|---|
| Parking Features | Attached,Garage,Three or more Spaces,Garage Door Opener |
| Lot Features | 1 to 5 Acres,Outside City Limits |
| Water Source | Well |
| Lot Size Area | 2.23 |
| Foundation Details | Raised |
| Building Area Total | 9035 |
| Lot Dimensions | 2.23 Acres |
| Lot Size Acres | 2.23 |
Room Details
| Room | Dimensions | Level | Flooring | Details |
|---|---|---|---|---|
| Bedroom | Second | Wood | ||
| Bedroom | Second | Wood | ||
| Breakfast Room/Nook | First | Wood | ||
| Den | First | Wood | ||
| Dining Room | First | Wood | ||
| Keeping Room | First | Wood | ||
| Kitchen | First | Wood | ||
| Living Room | First | Wood | ||
| Primary Bedroom | First | 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