Primary listing photo
Listing photo 2
Listing photo 3
Listing photo 4
Listing photo 5

228 Esquinance Dr, Mandeville, LA, 70448

6beds
5baths
4,638sqft
$1,995,000
$430price/sqft
$13,533/moest. monthly cost
$541,320/yrincome needed

About This Home

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.

Getting Around

11
WalkingCar-Dependent
0
TransitVery Limited Transit
31
BikeSomewhat Bikeable

Schools

10/10
Mandeville Elementary SchoolGrades PK-31.0 mi
9/10
Mandeville Junior High SchoolGrades 7-81.4 mi
9/10
Mandeville High SchoolGrades 9-121.1 mi

Construction

Condition

  • Property condition: Average Condition
  • Year built: 1930

Materials

  • Foundation: Raised
  • Roof: Metal
  • Construction materials: Vinyl Siding

Type & Style

  • Home type: SingleFamily
  • Architectural style: Colonial
  • Property subType: Single Family Residence

Interior

Appliances

  • Appliances included: Dryer,Dishwasher,Disposal,Ice Maker,Microwave,Oven,Range,Refrigerator,Washer
  • Laundry features: Washer Hookup,Dryer Hookup

Bathroom

  • Level: Second
  • Dimensions: 10 x 8

Bathroom

  • Level: Second
  • Dimensions: 7 x 10

Bathroom

  • Level: Second
  • Dimensions: 8 x 5

Bedroom

  • Level: First
  • Dimensions: 15 x 24

Bedroom

  • Level: Second
  • Dimensions: 15 x 27

Bedroom

  • Level: Second
  • Dimensions: 17 x 21

Bedroom

  • Level: Second
  • Dimensions: 9 x 18

Bedroom

  • Level: Second
  • Dimensions: 20 x 20

Bedrooms & Bathrooms

  • Bedrooms: 6
  • Bathrooms: 5
  • Full bathrooms: 5

Features

  • Granite Counters
  • Fireplace features: Wood Burning
  • Fireplace: Yes

Heating & Cooling

  • Heating features: Central,Multiple Heating Units
  • Cooling features: Central Air,2 Units

Interior Area

  • Total structure area: 4,638
  • Total interior livable area: 4,638 sqft

Kitchen

  • Level: First
  • Dimensions: 22 x 19

Living Room

  • Level: First
  • Dimensions: 27 x 15

Master Bathroom

  • Level: First
  • Dimensions: 32 x 8

Master Bedroom

  • Level: First
  • Dimensions: 15 x 21

Property

Details

  • Parcel number: 45173
  • Special condition: None

Features

  • Levels: Two
  • Stories: 2
  • Pool features: Heated,In Ground
  • Patio & porch: Oversized,Wood,Patio,Porch,Screened
  • Exterior features: Dock,Enclosed Porch,Outdoor Kitchen,Porch,Patio,Tennis Court(s)
  • Has spa: Yes
  • On waterfront: Yes
  • Waterfront features: Waterfront

Lot

  • Lot size: 1.38 Acres
  • Features: 1 to 5 Acres,City Lot,Oversized Lot
  • Lot size dimensions: 96 x 630

Parking

  • Total spaces: 2
  • Parking features: Garage,Off Street,Two Spaces,Boat,RV Access/Parking
  • Has garage: Yes