228 ESQUINANCE Drive, Mandeville, LA 70448
$1,995,000
Property Type:
Residential
Bedrooms:
6
Baths:
5
Square Footage:
4,638
Lot Size (sq. ft.):
59,677
Status:
Active
Current Price:
$1,995,000
List Date:
10/08/2025
Last Modified:
4/10/2026
Overview
Description
Listing Details MLS# NO2525016
Listing Info
- Delayed Marketing
- No
- Listing Price
- 1995000
- List Price/SqFt
- 430.14
- Type
- Single Family Residence
- Document Modified
- 2026-04-10 10:29:47.989822
- Modification Timestamp
- 2026-04-10T15:30:02Z
- Photo Modified
- 2026-03-03T16:51:33Z
Location Tax Legal Info
- Street Number
- 228
- Street Name
- ESQUINANCE Drive
- Parish
- St. Tammany
- State
- LA
- Zip Code
- 70448
- Subdivision
- Lewisburg
- Tax Assessment Number
- 45173
- Directions
- Bounding Streets: Fountain
General Property Description
- # Bedrooms
- 6
- Baths - Full
- 5
- Total Baths
- 5
- SqFt - Living
- 4638
- SqFt - Total
- 4638
- SqFt - Source
- Appraiser
- Stories
- 2
- Year Built
- 1930
- Acres
- 1.37
- Acreage Range
- 1 - 2.99
- Lot Dimensions
- 96 x 630
Originating Details
- Originating System ID
- ROAMM
- Originating System Key
- 52665229
- Originating System Listing ID
- 2525016
- Originating System Name
- ROAM Matrix
Location, Tax & Legal Info
- Legal Desc
- LOT 5A LEWISBURG CB 1258 815 CB 1378 696 CB 1555 932 INST NO 1042486 INST NO 1278165 INST NO 1382314 INST NO 1608907 INST NO 1723410 INST NO 1879454
Remarks & Misc
- Remarks
- 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.
More Information
Office/Member/Contract Info
- List AOR
- NOMAR
Style
- Colonial
- Yes
Siding
- Vinyl Siding
- Yes
Parking
- Garage
- Yes
- RV Access/Parking
- Yes
Foundation
- Piers
- Yes
Exterior
- Outside Kitchen
- Yes
Fireplace
- Wood Burning
- Yes
Roof
- Metal
- Yes
Heating
- Central
- Yes
Cooling
- 2 or More Units
- Yes
- Central Air
- Yes
Water Source
- Well
- Yes
Appliances
- Dishwasher
- Yes
- Disposal
- Yes
- Dryer
- Yes
- Ice Machine
- Yes
- Microwave
- Yes
- Refrigerator
- Yes
- Washer
- Yes
Countertops
- Granite
- Yes
Rooms
- Bathroom 1
- Yes
- Bedroom 1
- Yes
- Kitchen
- Yes
- Living Room
- Yes
- Primary Bathroom
- Yes
- Primary Bedroom
- Yes
- Bedroom 2
- Yes
- Bedroom 3
- Yes
- Bedroom 4
- Yes
- Bedroom 5
- Yes
- Bathroom 2
- Yes
- Bathroom 3
- Yes
Waterfront
- Dock/Mooring
- Yes
Amenities
- Acreage
- Yes
Fencing
- Chain Link
- Yes
Lot
- Water Frontage
- Yes
Other Structures
- Cabana
- Yes
- Tennis Court(s)
- Yes
Pool
- Inground
- Yes
Property Features
Style:
Colonial
Siding:
Vinyl Siding
Parking:
Garage; RV Access/Parking
Foundation:
Piers
Roof:
Metal
Fireplace:
Wood Burning
Heating:
Central
Cooling:
2 or More Units; Central Air
Appliances:
Dishwasher; Disposal; Dryer; Ice Machine; Microwave; Refrigerator; Washer
Countertops:
Granite
Rooms:
Bathroom 1; Bedroom 1; Kitchen; Living Room; Primary Bathroom; Primary Bedroom; Bedroom 2; Bedroom 3; Bedroom 4; Bedroom 5; Bathroom 2; Bathroom 3
Fencing:
Chain Link
Lot:
Water Frontage
Amenities:
Acreage
Exterior:
Outside Kitchen
Other Structures:
Cabana; Tennis Court(s)
Waterfront:
Dock/Mooring
Water Source:
Well
Pool:
Inground
Room Information
| Room Name | Length | Width | Remarks |
|---|---|---|---|
| Primary Bedroom | 15.00 | 21.00 | Primary Bedroom |
| Kitchen | 22.00 | 19.00 | Kitchen |
| Bedroom 1 | 15.00 | 27.00 | Bedroom |
| Bedroom 2 | 9.00 | 18.00 | Bedroom |
| Living Room | 27.00 | 15.00 | Living Room |
| Bedroom 3 | 15.00 | 24.00 | Bedroom |
| Bathroom 1 | 8.00 | 5.00 | Bathroom |
| Bedroom 4 | 17.00 | 21.00 | Bedroom |
| Bathroom 2 | 7.00 | 10.00 | Bathroom |
| Bedroom 5 | 20.00 | 20.00 | Bedroom |
| Bathroom 3 | 10.00 | 8.00 | Bathroom |
| Primary Bathroom | 32.00 | 8.00 | Primary Bathroom |
Property Disclosure ›
IDX
Listing Office:
NOLA Property Advisors
Last Updated: April - 10 - 2026
The data relating to real estate for sale or lease on this website comes in part from the IDX program of the REALTOR® Association of Acadiana MLS. The IDX information is provided exclusively for consumers’ personal, non-commericial use and 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.