Skip main navigation
Active
    • Price cut: $195K (6/23)
    $1,800,000

    228 Esquinance Dr, Mandeville, LA 70448

    6beds
    4,638sqft
    : 
    Loading
    Get pre-qualified
    Single Family Residence
    Built in 1930
    1.38 Acres Lot
    $-- Zestimate®
    $388/sqft
    $-- HOA

    What's special

    Pool areaSpectacular lake viewsWatch the sunsetsSports pavilionNumerous upgradesLakefront compound
    HUGE PRICE REDUCTION. A chance to snap up this wonderful lakefront property. 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.
    276 days
    |
    753
    |
    53
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Paul Slater 504-908-7285,

    NOLA Property Advisors 504-908-7285

    Source: GSREIN,MLS#: 2525016MLS Logo

    Loading...

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 6
      • Bathrooms: 5
      • Full bathrooms: 5
      Primary bedroom
      • Description: Flooring: Wood
      • Level: First
      • Dimensions: 15 x 21
      Bedroom
      • Description: Flooring: Wood
      • Level: First
      • Dimensions: 15 x 24
      Bedroom
      • Description: Flooring: Wood
      • Level: Second
      • Dimensions: 15 x 27
      Bedroom
      • Description: Flooring: Wood
      • Level: Second
      • Dimensions: 17 x 21
      Bedroom
      • Description: Flooring: Wood
      • Level: Second
      • Dimensions: 9 x 18
      Bedroom
      • Description: Flooring: Carpet
      • Level: Second
      • Dimensions: 20 x 20
      Primary bathroom
      • Description: Flooring: Tile
      • Level: First
      • Dimensions: 32 x 8
      Bathroom
      • Description: Flooring: Tile
      • Level: Second
      • Dimensions: 10 x 8
      Bathroom
      • Description: Flooring: Tile
      • Level: Second
      • Dimensions: 7 x 10
      Bathroom
      • Description: Flooring: Tile
      • Level: Second
      • Dimensions: 8 x 5
      Kitchen
      • Description: Flooring: Wood
      • Level: First
      • Dimensions: 22 x 19
      Living room
      • Description: Flooring: Wood
      • Level: First
      • Dimensions: 27 x 15
      Heating
      • Central, Multiple Heating Units
      Cooling
      • Central Air, 2 Units
      Appliances
      • Included: Dryer, Dishwasher, Disposal, Ice Maker, Microwave, Oven, Range, Refrigerator, Washer
      • Laundry: Washer Hookup, Dryer Hookup
      Features
      • Granite Counters
      • Has fireplace: Yes
      • Fireplace features: Wood Burning
      Interior area
      • Total structure area: 4,638
      • Total interior livable area: 4,638 sqft

      Property

      Parking
      • Total spaces: 2
      • Parking features: Garage, Off Street, Two Spaces, Boat, RV Access/Parking
      • Has garage: Yes
      Features
      • Levels: Two
      • Stories: 2
      • Patio & porch: Oversized, Wood, Patio, Porch, Screened
      • Exterior features: Dock, Enclosed Porch, Outdoor Kitchen, Porch, Patio, Tennis Court(s)
      • Pool features: Heated, In Ground
      • Has spa: Yes
      • On waterfront: Yes
      • Waterfront features: Waterfront
      Lot
      • Size: 1.38 Acres
      • Dimensions: 96 x 630
      • Features: 1 to 5 Acres, City Lot, Oversized Lot
      Details
      • Additional structures: Cabana, Other
      • Parcel number: 45173
      • Special conditions: None

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Colonial
      • Property subtype: Single Family Residence
      Materials
      • Vinyl Siding
      • Foundation: Raised
      • Roof: Metal
      Condition
      • Average Condition
      • Year built: 1930

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Well

      Community & HOA

      Community
      • Subdivision: Lewisburg
      HOA
      • Has HOA: No
      Location
      • Region: Mandeville

      Financial & listing details

      • Price per square foot: $388/sqft
      • Tax assessed value: $1,319,762
      • Annual tax amount: $14,932
      • Date on market: 10/8/2025

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        6/23/2026Price change$1,800,000-9.8%$388/sqft
        Source: GSREIN #2525016 Report a problem
        3/3/2026Price change$1,995,000-7.2%$430/sqft
        Source: GSREIN #2525016 Report a problem
        10/13/2025Listed for sale$2,150,000+4.9%$464/sqft
        Source: GSREIN #2525016 Report a problem
        9/13/2025Listing removed$2,049,000$442/sqft
        Source: GSREIN #2514214 Report a problem
        7/29/2025Listed for sale$2,049,000$442/sqft
        Source: GSREIN #2514214 Report a problem
        11/15/2012Sold--
        Source: GSREIN #933908 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$14,932 +2.6%$131,976 +6%
        2024$14,552 +13.3%$124,496 +19.3%
        2023$12,844 $104,398
        2022$12,844 +0.2%$104,398
        2021$12,820 +0.1%$104,398
        2020$12,806 -6.7%$104,398 -3%
        2019$13,723 -0.1%$107,605
        2018$13,743 -7.8%$107,605
        2017$14,911 +6.7%$107,605
        2016$13,981 $107,605 +11.6%
        2015$13,981 +9.6%$96,403
        2014$12,757 +1.1%$96,403
        2013$12,622 -3.5%$96,403 +6.7%
        2011$13,074 +0.4%$90,342
        2010$13,025 $90,342
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: 70448

        Getting around

        11 / 100
        Car-Dependent
        31 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

              Nearby cities

              Nearby zip codes

              Other Mandeville Topics

                Search
                Updates
                Favorites
                Plan
                Inbox