We Purchase, Trade, Consult & Market Residential & Commercial Real Estate

  • About
  • Contact
  • Careers
  • 337-984-4345
Guidry and Company Real EstateGuidry and Company Real EstateGuidry and Company Real EstateGuidry and Company Real Estate
  • 337-984-4345
  • Home
  • Buyers
    • Looking to Buy?
    • Featured Listings
    • Homes for Sale
    • COMMERCIAL LISTINGS: Business Opportunity, Industrial, Office, Restaurant/Lounge, Shopping Center, Hotel/Motel, Medical/Dental or Retail
    • LAND LISTINGS: Commercial, Industrial, Residential, Farm or Timberland
    • Buyers Guidebook
    • Choose Your Realtor
    • Why Choose Us
  • Sellers
    • Why Choose Us
  • Services
    • Consultation Services
    • Inherited Land
  • Who’s Your REALTOR®?
  • Success Coaching
  • Blog
  • Reviews

$1,800,000
228 ESQUINANCE Drive
Mandeville, LA 70448
MLS# NO2525016
6 beds  |  5 baths  |  4638 sqft


Photo 1
  1 / 28  
Photo 1 Photo 2 Photo 3 Photo 4 Photo 5 Photo 6 Photo 7 Photo 8 Photo 9 Photo 10 Photo 11 Photo 12 Photo 13 Photo 14 Photo 15 Photo 16 Photo 17 Photo 18 Photo 19 Photo 20 Photo 21 Photo 22 Photo 23 Photo 24 Photo 25 Photo 26 Photo 27 Photo 28

Property Description
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.

Details
Documents
Listing Info
Status: Active
Listing Date: 2025-10-08
Delayed Marketing: No
Listing Price: 1800000
Current Price: $1,800,000
List Price/SqFt: 388.1
Type: Single Family Residence
Document Modified: 2026-08-01 17:57:19.576895
Modification Timestamp: 2026-08-01T22:57:47Z
Photo Modified: 2026-03-03T16:51:33Z
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
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
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 Bedroom15.0021.00Primary Bedroom
Kitchen22.0019.00Kitchen
Bedroom 115.0027.00Bedroom
Bedroom 29.0018.00Bedroom
Living Room27.0015.00Living Room
Bedroom 315.0024.00Bedroom
Bathroom 18.005.00Bathroom
Bedroom 417.0021.00Bedroom
Bathroom 27.0010.00Bathroom
Bedroom 520.0020.00Bedroom
Bathroom 310.008.00Bathroom
Primary Bathroom32.008.00Primary Bathroom
Listing Documents
View Document Property Disclosure
View Document LBD
View Document Concepts for Chnges & Additions

IDX
Listing Office: NOLA Property Advisors

Last Updated: August - 01 - 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.


Search powered by FBS Products

Find Us

Get Directions
 

1232-A Camellia Blvd.
Lafayette, LA 70508
P: 337-984-4345

 

AGENT ON CALL | 337-446-6053

 

CALL US: 337-984-4345

 

GUIDRY & CO. REAL ESTATE, Lafayette, LA. All offices are independently owned and operated. The data relating to real estate for sale on this web site comes in part from the IDX Program of the Realtor® Association of Acadiana; MLS Real Estate listings held by brokerage firms other than GUIDRY & CO. REAL ESTATE are marked with the MLS approved icon for IDX. “Information Deemed Reliable But Not Guaranteed”. Copyright 2016 REALTOR® Association of Acadiana, All rights reserved.

Licensed & Regulated in the jurisdiction of the Louisiana Real Estate Commission, Members of the National Association of Realtors®, Louisiana Realtors®, Realtor® Association of Acadiana, Multiple Listing Service (MLS), Louisiana Commercial (www.lacdb.com), The Realtor® Commercial Alliance, Equal Housing Opportunity.

  • Home
  • 337-984-4345
  • Buyers
    • Looking to Buy?
    • Featured Listings
    • Homes for Sale
    • COMMERCIAL LISTINGS: Business Opportunity, Industrial, Office, Restaurant/Lounge, Shopping Center, Hotel/Motel, Medical/Dental or Retail
    • LAND LISTINGS: Commercial, Industrial, Residential, Farm or Timberland
    • Buyers Guidebook
    • Choose Your Realtor
    • Why Choose Us
  • Sellers
    • Why Choose Us
  • Services
    • Consultation Services
    • Looking to Buy?
    • Inherited Real Estate?
    • Choose Your REALTOR®
  • Blog
  • Success Coaching
  • Who’s Your REALTOR®?
  • Careers
  • About Guidry & Co. Real Estate
  • Contact Us
  • Reviews
Guidry and Company Real Estate
Thank you for visiting Guidry & Co. Real Estate, for more information please register here:

"*" indicates required fields

This field is for validation purposes and should be left unchanged.
Name*

 

Return To Homepage