Lake Homes Realty
Enter City, Zip or MLS

228 esquinance drive

Mandeville, LA 70448

$1,995,000

6 BEDS 5 BATHS
4,638 SQFT1.37 AC LOT
Residential - Detached
Image 1: Front Elevation
Image 2: Living Room
Image 3: Eat-in kitchen
Image 4: Primary Bedroom
Bedrooms 6
Total Baths 5
Full Baths 5
Square Feet 4638
Acreage 1.3793
Status Active
MLS # 2525016
County St Tammany
More Info
Category Residential - Detached
Status Active
Square Feet 4638
Acreage 1.3793
MLS # 2525016
County St Tammany
PRICE REDUCTION. 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 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.
Location not available

Exterior Features

  • Style Colonial
  • Construction Single Family
  • Siding VinylSiding
  • Exterior Dock, EnclosedPorch, OutdoorKitchen, Porch, Patio, TennisCourts
  • Roof Metal
  • Garage Yes
  • Garage Description Garage, OffStreet, TwoSpaces, Boat, RvAccessParking
  • Water Well
  • Sewer PublicSewer
  • Lot Description OneToFiveAcres, CityLot, OversizedLot

Interior Features

  • Appliances Dryer, Dishwasher, Disposal, IceMaker, Microwave, Oven, Range, Refrigerator, Washer
  • Heating Central, MultipleHeatingUnits
  • Cooling CentralAir, TwoUnits
  • Fireplaces Yes
  • Fireplaces Description WoodBurning
  • Living Area 4,638 SQFT
  • Year Built 1930

Neighborhood & Schools

  • Subdivision Lewisburg

Financial Information

  • Parcel ID 45173

Additional Services

Internet Service Providers

Listing Information

Listing Provided Courtesy of NOLA Property Advisors
IDX provided courtesy of NOM MLS via Lake Homes Realty
Listing data is current as of 06/18/2026.

Contact Our Agent

By clicking “Submit,” I agree to be contacted by Lake Homes Realty, LLC, its affiliates, and real estate professionals via call, text, and email for real estate services. This includes by automated means, even if your number is on a federal, state, or our internal Do Not Call list. To opt out, you can reply "stop" at any time or reply "help" for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. You also agree to our Terms of Use and Privacy Policy.