- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes
Street View
$1,800,000
Monthly Est:$8,959
6 Beds
5 Baths5 full baths
4,638sqft
228 Esquinance Dr, Mandeville, LA 70448
$1,800,000
$8,959/moEst:
Get Pre-Approved
Single Family Residence
Built in 1930
$-- HOA
1.38 acres lot
$388/sq.ft
Description
HUGE PRICE REDUCTION. A chance to snap up this wonderful lakefront property. 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 and 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.
- Houzeo last checked: 7 minutes ago
- Listing updated: September 23, 2026 at 1:22 pm
- Listing Provided by: Paul Slater (504) 908-7285 | NOLA Property Advisors (504) 908-7285
- Source: New Orleans Metropolitan AOR (NOMAR) MLS-LA | MLS#: 2525016
Property Details
Status
Active
Type
Single Family Residence
No. of Stories
2
County
City
Neighborhood
--
Year Built
1930
HOA Fees
-
Finished Area
4,638 sqft
Lot Size
1.38 acres lot
Basement Area
- sqft
MLS Name
New Orleans Metropolitan AOR (NOMAR) MLS
MLS Number
2525016
MLS Status
Active
Days on Market
363
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 6
Bathrooms: 5
Bathroom
Level: Second
Area: 40.00 Square Feet
Dimensions: 8 x 5
Bedroom
Level: Second
Area: 400.00 Square Feet
Dimensions: 20 x 20
Bathroom
Level: Second
Area: 70.00 Square Feet
Dimensions: 7 x 10
Bedroom
Level: Second
Area: 162.00 Square Feet
Dimensions: 9 x 18
Bedroom
Level: Second
Area: 357.00 Square Feet
Dimensions: 17 x 21
Bathroom
Level: Second
Area: 80.00 Square Feet
Dimensions: 10 x 8
Bedroom
Level: Second
Area: 405.00 Square Feet
Dimensions: 15 x 27
PrimaryBathroom
Level: First
Area: 256.00 Square Feet
Dimensions: 32 x 8
PrimaryBedroom
Level: First
Area: 315.00 Square Feet
Dimensions: 15 x 21
Bedroom
Level: First
Area: 360.00 Square Feet
Dimensions: 15 x 24
Kitchen
Level: First
Area: 418.00 Square Feet
Dimensions: 22 x 19
LivingRoom
Level: First
Area: 405.00 Square Feet
Dimensions: 27 x 15
Interior
Appliances
Dryer, Dishwasher, Disposal, Ice Maker, Microwave, Oven, Range, Refrigerator, Washer
Sewer
Public Sewer
Interior Features
Granite Counters
Cooling
Central Air, Two Units
Heating
Central, Multiple Heating Units
Exterior Features
Dock, Enclosed Porch, Outdoor Kitchen, Porch, Patio, Tennis Courts
Construction
Year Built
Year Built: 1930
Home type
Single Family Residence
Foundation Details
Raised
Roof
Metal
Property Condition
Average Condition
Construction Materials
Vinyl Siding
Architectural Style
Colonial
Utilities & Energy
Parking Features
Garage, Off Street, Two Spaces, Boat, Rv Access Parking
Pool Features
Heated, In Ground
Fireplace Features
Wood Burning
Laundry Features
Washer Hookup, Dryer Hookup
Water Source
Well
Other Features
Lot Features
One To Five Acres, City Lot, Oversized Lot
Subdivision Name
Lewisburg
Patio And Porch Features
Oversized, Wood, Patio, Porch, Screened
Price History
| Date | Event | Price |
|---|---|---|
09/23/2026 Source: | Listed for Sale | $1,800,000 $388/sqft |
06/23/2026 Source: | Price Decreased | $1,800,000 -9.77% $388/sqft |
03/03/2026 Source: | Price Decreased | $1,995,000 -7.21% $430/sqft |
10/14/2025 Source: | Off Market | $2,150,000 +4.93% $464/sqft |
09/12/2025 Source: | Listing Removed | $2,049,000 $442/sqft |
Show more
Nearby Homes
Find Homes by Property Features in Mandeville, LA
Nearby New Homes For Sale
Based on information from the ROAM MLS through Oct 11, 2026, 07:30AM. IDX information is provided exclusively for consumers' personal, non-commercial use. It 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. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. © 2026 ROAM MLS. All Rights Reserved.
Advertising Broker: Jared Andrew English | Congress Realty, Inc