Save
Ask
Tour
Hide
$2,150,000
113 Days On Site
228 ESQUINANCE DriveMandeville, LA 70448
For Sale|Single Family Residence|Active
6
Beds
5
Total Baths
5
Full Baths
4,638
SqFt
$464
/SqFt
1930
Built
Subdivision:
Lewisburg
County:
St Tammany
Call Now: 985-467-7355
Is this the listing for you? We can help make it yours.
985-467-7355
Save
Ask
Tour
Hide
Mortgage Calculator
Monthly Payment (Est.)
$9,809Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.
It's only once in a while a magnificent property like this becomes available. Set majestically on over 1.5 acres, this lakefront compound, conveniently located just over the Causeway bridge, is ready for new owners to make their own special memories. The home boasts 6 bedrooms, 5 bathrooms with numerous upgrades throughout. Enjoy the spectacular lake views from the porch or wander down to the pool area to watch the sunsets and drink in the magnificence of lakefront living. Feeling more energetic? How about a game of tennis or pickleball, complete with its own sports pavilion. This oasis away from the hustle and bustle is ready and waiting to welcome a new family. Call today for a private viewing, you won't be disappointed.
Save
Ask
Tour
Hide
Listing Snapshot
Price
$2,150,000
Days On Site
113 Days
Bedrooms
6
Inside Area (SqFt)
4,638 sqft
Total Baths
5
Full Baths
5
Partial Baths
N/A
Lot Size
1.3793 Acres
Year Built
1930
MLS® Number
2525016
Status
Active
Property Tax
N/A
HOA/Condo/Coop Fees
N/A
Sq Ft Source
Appraiser
Friends & Family
Recent Activity
| 4 months ago | Listing first seen on site | |
| 4 months ago | Listing updated with changes from the MLS® |
General Features
Acres
1.3793
Cross Street
Fountain
Foundation
Raised
Garage
Yes
Levels
Two
Parking
GarageOff StreetBoatRV Access/Parking
Parking Spaces
2
Property Sub Type
Single Family Residence
Sewer
Public Sewer
SqFt Total
4638
Style
Colonial
Water Source
PrivateWell
Interior Features
Appliances
DryerDishwasherDisposalIce MakerMicrowaveOvenRangeRefrigeratorWasher
Cooling
Central AirMulti Units
Fireplace
Yes
Fireplace Features
Wood Burning
Heating
Central
Interior
Granite Counters
Laundry Features
Washer Hookup
Spa
Yes
Bathroom
Dimensions - 7 x 10Level - Second
Bedroom
Dimensions - 15 x 24Level - First
Kitchen
Dimensions - 22 x 19Level - First
Living Room
Dimensions - 27 x 15Level - First
Master Bathroom
Dimensions - 32 x 8Level - First
Master Bedroom
Dimensions - 15 x 21Level - First
Save
Ask
Tour
Hide
Exterior Features
Construction Details
Vinyl Siding
Exterior
DockOutdoor KitchenTennis Court(s)
Lot Features
City LotWaterfront
Other Structures
CabanaOther
Patio And Porch
PatioPorchScreened
Pool Features
HeatedIn Ground
Roof
Metal
Spa
Yes
Waterfront
Yes
Waterfront Features
Waterfront
Listing courtesy of NOLA Property Advisors
Copyright © 2017-present, New Orleans Metropolitan Association of REALTORS®, Inc. All rights reserved. Information deemed reliable, but not verified or guaranteed. Users are responsible for checking the accuracy, completeness, currency, and status of all information.
Copyright © 2017-present, New Orleans Metropolitan Association of REALTORS®, Inc. All rights reserved. Information deemed reliable, but not verified or guaranteed. Users are responsible for checking the accuracy, completeness, currency, and status of all information.
Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Did you know? You can invite friends and family to your search. They can join your search, rate and discuss listings with you.