Lake Homes Realty
Enter City or Zip

228 esquinance drive

Mandeville, LA 70448

$2,150,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
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.
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 11/03/2025.

Contact our Agent !

By clicking “Submit”, you agree that Lake Homes Realty, its affiliates, and real estate professionals may contact you by phone, text, or email to any phone number and email address you provided, including by automated means, even if your number is on a federal, state, or our internal Do Not Call list. You also agree to our Terms of Use and Privacy Policy.