228 Esquinance St

Mandeville, LA 70448

$2,150,000
Price
6
Beds
4,638 Sq. Ft.
$464 / Sq. Ft.
4,638
Sq. Ft.
$464
per Sq. Ft.

Description

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?...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.
  1. Listed by Paul Slater • NOLA Property Advisors
    P: (504)-908-7285 C: (504)-908-7285 pslater60@gmail.com

Property Details for 228 Esquinance Street

Architectural Style
Colonial Style
Subdivision Name
Lewisburg
Waterfront Features
Dock/Mooring, Ocean Access
LISTING UPDATED: 10/13/2025 11:35 PM

Property Details for 228 Esquinance Street

StatusActive
MLS #2525016
Days on Market107
Taxes-
HOA Fees-
Condo/Co-op Fees-
Compass TypeSingle Family
MLS TypeResidential / Detached Single Family / Single Family Home
Year Built1930
Lot Size1.38 AC / 60,082 SF
CountySt. Tammany Parish

Location

Listing Courtesy of NOLA Property Advisors
Add your commute

Building Information for 228 Esquinance Street

Stories2Year Built1930Building Size-Lot Size1.38 AC / 60,082 SF

Payment Calculator

$11,692 per month

30 year fixed, 6.15% Interest

Principal and Interest

$10,479

Property Taxes

$1,213

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Property Information for 228 Esquinance Street

Summary
Location and General Information
  • Directions: Bounding Streets: Fountain
  • Latitude: 30.37
  • Longitude: -90.10
  • MLS Area Minor: ST. TAMMANY
  • Year Built: 1,930
  • In City Limits: 1
  • Neighborhood: Lewisburg
Parking
  • Parking Features: 2 Car, Garage, Off Street, RV Carport
Taxes and HOA
  • Association Amenities: Subd Acreage
  • Association: No
  • Tax Legal Description: 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
  • Tax Lot: 5A
Virtual Tour
Property
Lot Information
  • Building Area Total: 4638.0
  • Living Area: 4638.0
  • Living Area Source: Appraiser
  • Lot Features: Waterfront
  • Lot Size Acres: 1.3793
  • Lot Size Dimensions: 96 x 630
Property and Assessments
  • Home Warranty: No
  • Parcel Number: 45173
  • Property Sub Type: Detached Single Family
  • Property Type: Residential
  • Sub Type: Single Family Home
  • Overall Condition: Average
Utilities
  • Sewer: Public Sewer
  • Water Source: Well
  • GS Utilities Gas: Other Gas
  • EL Utilities Elec: CLECO
Interior and Exterior Features
Exterior Features
  • Construction Materials: Vinyl Siding
  • Exterior Features: Outdoor Kitchen, Porch, Tennis Court(s)
  • Fencing: Chain Link
  • Foundation Details: Pillar/Post/Pier
  • Patio And Porch Features: Porch, Patio: Wood, Patio: Oversized
  • Pool Features: Heated, In Ground
  • Roof: Metal
  • Stories: 2
Interior Features
  • Appliances: Disposal, Dishwasher, Ice Maker, Microwave, Range, Refrigerator
  • Bathrooms Full: 5
  • Bathrooms Partial: 0
  • Bedrooms Total: 6
  • Cooling: Multi Units, Central Air
  • Fireplace Features: Wood Burning
  • Heating: 2 or More Units, Central
  • Interior Features: Ice Maker
  • Laundry Features: Dryer, Washer, Washer/Dryer Hookups
  • Bathrooms Display: 5/0
Room Information
Room 1
  • Room Description: Primary Bathroom
  • Room Dimensions: 32 x 8
Room 2
  • Room Description: Bedroom
  • Room Dimensions: 15 x 27
  • Room Type: Bedroom
Room 3
  • Room Description: Bathroom
  • Room Dimensions: 10 x 8
  • Room Type: Bathroom
Room 4
  • Room Description: Bedroom
  • Room Dimensions: 17 x 21
  • Room Type: Bedroom
Room 5
  • Room Description: Bedroom
  • Room Dimensions: 9 x 18
  • Room Type: Bedroom
Room 6
  • Room Description: Bathroom
  • Room Dimensions: 7 x 10
  • Room Type: Bathroom
Room 7
  • Room Description: Living Room
  • Room Dimensions: 27 x 15
  • Room Type: Living Room
Room 8
  • Room Description: Kitchen
  • Room Dimensions: 22 x 19
  • Room Type: Kitchen
Room Information
  • KF Kitchen Features: Counters Granite

Property History for 228 Esquinance Street

DateEvent & SourcePriceAppreciation
Oct 8, 2025

Listed (Active)

ROAM MLS #2525016

$2,150,000—
Sep 12, 2025

Permanently Off Market

ROAM MLS #2514214

$2,049,000—
Jul 29, 2025

Listed (Active)

ROAM MLS #2514214

$2,049,000—
Nov 15, 2012

Sold (Public Record)

Public Record #1119398847

—
Nov 15, 2012

Sold

ROAM MLS #NO933908

—
Nov 14, 2012

Contract Signed

ROAM MLS #NO933908

—
Nov 13, 2012

Listed (Active)

ROAM MLS #NO933908

$1,550,000—
Apr 20, 2009

Sold

ROAM MLS #NO768343

—
Mar 20, 2009

Contract Signed

ROAM MLS #NO768343

—
Nov 20, 2008

Listed (Active)

ROAM MLS #NO768343

$1,275,900—
Nov 7, 2008

Temporarily Off Market

ROAM MLS #NO766841

$1,275,900—
Nov 7, 2008

Listed (Active)

ROAM MLS #NO766841

$1,275,900—
Jan 31, 2007

Sold

ROAM MLS #NO669427

—
Sep 21, 2006

Contract Signed

ROAM MLS #NO669427

—
Sep 21, 2006

Listed (Active)

ROAM MLS #NO669427

$1,150,000—
May 28, 2003

Sold

ROAM MLS #NO513015

—
Mar 31, 2003

Contract Signed

ROAM MLS #NO513015

—
Mar 27, 2003

Listed (Active)

ROAM MLS #NO513015

$1,150,000—
Dec 3, 2001

Sold

ROAM MLS #NO455970

—
Oct 19, 2001

Contract Signed

ROAM MLS #NO455970

—
Aug 2, 2001

Listed (Active)

ROAM MLS #NO455970

$1,295,000—
Apr 14, 1997

Sold

ROAM MLS #NO309951

—
Jan 15, 1997

Contract Signed

ROAM MLS #NO309951

—
Jan 14, 1997

Listed (Active)

ROAM MLS #NO309951

$715,000—
Jun 21, 1993

Sold

ROAM MLS #NO218759

—
Apr 30, 1993

Contract Signed

ROAM MLS #NO218759

—
Jan 15, 1993

Listed (Active)

ROAM MLS #NO218759

$575,000—
DateEvent & SourcePrice
10/08/2025

Listed (Active)

ROAM MLS #2525016

$2,150,000
09/12/2025

Permanently Off Market

ROAM MLS #2514214

$2,049,000
07/29/2025

Listed (Active)

ROAM MLS #2514214

$2,049,000
11/15/2012

Sold (Public Record)

Public Record #1119398847

—
11/15/2012

Sold

ROAM MLS #NO933908

—
11/14/2012

Contract Signed

ROAM MLS #NO933908

—
11/13/2012

Listed (Active)

ROAM MLS #NO933908

$1,550,000
04/20/2009

Sold

ROAM MLS #NO768343

—
03/20/2009

Contract Signed

ROAM MLS #NO768343

—
11/20/2008

Listed (Active)

ROAM MLS #NO768343

$1,275,900
11/07/2008

Temporarily Off Market

ROAM MLS #NO766841

$1,275,900
11/07/2008

Listed (Active)

ROAM MLS #NO766841

$1,275,900
01/31/2007

Sold

ROAM MLS #NO669427

—
09/21/2006

Contract Signed

ROAM MLS #NO669427

—
09/21/2006

Listed (Active)

ROAM MLS #NO669427

$1,150,000
05/28/2003

Sold

ROAM MLS #NO513015

—
03/31/2003

Contract Signed

ROAM MLS #NO513015

—
03/27/2003

Listed (Active)

ROAM MLS #NO513015

$1,150,000
12/03/2001

Sold

ROAM MLS #NO455970

—
10/19/2001

Contract Signed

ROAM MLS #NO455970

—
08/02/2001

Listed (Active)

ROAM MLS #NO455970

$1,295,000
04/14/1997

Sold

ROAM MLS #NO309951

—
01/15/1997

Contract Signed

ROAM MLS #NO309951

—
01/14/1997

Listed (Active)

ROAM MLS #NO309951

$715,000
06/21/1993

Sold

ROAM MLS #NO218759

—
04/30/1993

Contract Signed

ROAM MLS #NO218759

—
01/15/1993

Listed (Active)

ROAM MLS #NO218759

$575,000

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 228 Esquinance Street

Taxable ValueLand$55,000Additions$69,496Total$124,496
Tax Record2024$14,552 ($1,213 / month)
Home Facts
Beds0Total Finished SqFt3,882 SqFtAbove Grade Finished SqFt3,882 SqFtStyleSingle Family ResidenceYear Built1930CountySAINT TAMMANYAPN45173Fireplace TypeHas Fireplace

Schools near 228 Esquinance Street

This home is within St. Tammany Parish School District.
Rating
School
Type
Grades
Distance
Mandeville Elementary School
Public - PK to 3
Tchefuncte Middle School
Public - 4 to 6
Mandeville Junior High School
Public - 7 to 8
Mandeville High School
Public - 9 to 12
Rating
School
Distance
Mandeville Elementary School
PublicPK to 3

Tchefuncte Middle School
Public4 to 6

Mandeville Junior High School
Public7 to 8

Mandeville High School
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Similar Sold Homes

Explore Nearby Homes

More information about 228 Esquinance Street, Mandeville, LA 70448

228 Esquinance Street is a single family home for sale in Mandeville, LA 70448. This property was listed for sale on October 8, 2025 by NOLA Property Advisors, it's currently listed at $2,150,000. It has been on the market for a total of 107 days and was last sold on November 15, 2012. This listing's school district is St. Tammany Parish School District. Nearby schools include Mandeville Elementary School, Tchefuncte Middle School and Mandeville Junior High School. 228 Esquinance Street is a 6-bed, 5-bath, 4,638 sqft single family home built in 1930.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass makes no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.

Listing Courtesy of NOLA Property Advisors

The data relating to real estate listings on this website comes in part from the Internet Data Exchange (IDX) program of Multiple Listing Service of ROAM MLS, Gulf Coast Association of REALTORS, REALTOR Association of Acadiana and South West Louisiana Association of REALTORS. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Listings provided by brokerages other than Compass are identified with the ROAM MLS, Gulf Coast Association of REALTORS, REALTOR Association of Acadiana and South West Louisiana Association of REALTORS Logos. All Information Is Deemed Reliable But Is Not Guaranteed Accurate. All information should be verified by the recipient and none is guaranteed as accurate by ROAM MLS, Gulf Coast, REALTOR Association of Acadiana and South West Louisiana Association of REALTORS.Listing information Copyright© 2026 MLS of ROAM, Gulf Coast, REALTOR Association of Acadiana and South West Louisiana Multiple Listing Service, Inc. All Rights Reserved.