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.
Active
$2,150,000
228 Esquinance Dr, Mandeville, LA 70448
6beds
4,638sqft
Est.:
Single Family Residence
Built in 1930
1.38 Acres Lot
$-- Zestimate®
$464/sqft
$-- HOA
What's special
Pool areaSpectacular lake viewsWatch the sunsetsSports pavilionNumerous upgradesLakefront compound
- 57 days |
- 663 |
- 46 |
Zillow last checked: 8 hours ago
Listing updated: October 13, 2025 at 09:10pm
Listed by:
Paul Slater 504-908-7285,
NOLA Property Advisors 504-908-7285
Source: GSREIN,MLS#: 2525016
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 5
- Full bathrooms: 5
Primary bedroom
- Description: Flooring: Wood
- Level: First
- Dimensions: 15 x 21
Bedroom
- Description: Flooring: Wood
- Level: First
- Dimensions: 15 x 24
Bedroom
- Description: Flooring: Wood
- Level: Second
- Dimensions: 15 x 27
Bedroom
- Description: Flooring: Wood
- Level: Second
- Dimensions: 17 x 21
Bedroom
- Description: Flooring: Wood
- Level: Second
- Dimensions: 9 x 18
Bedroom
- Description: Flooring: Carpet
- Level: Second
- Dimensions: 20 x 20
Primary bathroom
- Description: Flooring: Tile
- Level: First
- Dimensions: 32 x 8
Bathroom
- Description: Flooring: Tile
- Level: Second
- Dimensions: 10 x 8
Bathroom
- Description: Flooring: Tile
- Level: Second
- Dimensions: 7 x 10
Bathroom
- Description: Flooring: Tile
- Level: Second
- Dimensions: 8 x 5
Kitchen
- Description: Flooring: Wood
- Level: First
- Dimensions: 22 x 19
Living room
- Description: Flooring: Wood
- Level: First
- Dimensions: 27 x 15
Heating
- Central, Multiple Heating Units
Cooling
- Central Air, 2 Units
Appliances
- Included: Dryer, Dishwasher, Disposal, Ice Maker, Microwave, Oven, Range, Refrigerator, Washer
- Laundry: Washer Hookup, Dryer Hookup
Features
- Granite Counters
- Has fireplace: Yes
- Fireplace features: Wood Burning
Interior area
- Total structure area: 4,638
- Total interior livable area: 4,638 sqft
Property
Parking
- Parking features: Garage, Off Street, Two Spaces, Boat, RV Access/Parking
- Has garage: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Oversized, Wood, Patio, Porch, Screened
- Exterior features: Dock, Enclosed Porch, Outdoor Kitchen, Porch, Patio, Tennis Court(s)
- Pool features: Heated, In Ground
- Has spa: Yes
- On waterfront: Yes
- Waterfront features: Waterfront
Lot
- Size: 1.38 Acres
- Dimensions: 96 x 630
- Features: 1 to 5 Acres, City Lot, Oversized Lot
Details
- Additional structures: Cabana, Other
- Parcel number: 45173
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence
Materials
- Vinyl Siding
- Foundation: Raised
- Roof: Metal
Condition
- Average Condition
- Year built: 1930
Utilities & green energy
- Sewer: Public Sewer
- Water: Well
Community & HOA
Community
- Subdivision: Lewisburg
HOA
- Has HOA: No
Location
- Region: Mandeville
Financial & listing details
- Price per square foot: $464/sqft
- Tax assessed value: $1,244,962
- Annual tax amount: $14,552
- Date on market: 10/8/2025
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 10/13/2025 | Listed for sale | $2,150,000+4.9%$464/sqft |
Source:  GSREIN #2525016 Report a problem | ||
| 9/13/2025 | Listing removed | $2,049,000$442/sqft |
Source: GSREIN #2514214 Report a problem | ||
| 7/29/2025 | Listed for sale | $2,049,000$442/sqft |
Source: GSREIN #2514214 Report a problem | ||
| 11/15/2012 | Sold | -- |
Source: GSREIN #933908 Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $14,552 +13.3% | $124,496 +19.3% |
| 2023 | $12,844 | $104,398 |
| 2022 | $12,844 +0.2% | $104,398 |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$10,344/mo
Principal & interest
$8337
Property taxes
$1254
Home insurance
$753
Climate risks
Neighborhood: 70448
Nearby schools
GreatSchools rating
- 10/10Mandeville Elementary SchoolGrades: PK-3Distance: 1 mi
- 9/10Mandeville Junior High SchoolGrades: 7-8Distance: 1.4 mi
- 9/10Mandeville High SchoolGrades: 9-12Distance: 1.1 mi
- Loading
- Loading
