- 3 beds
- 2 baths
- 1,226 sqft
- $179 per sqft
- 1997 build
Welcome to 24638 Esquinance St, a charming home nestled on a spacious corner lot that perfectly blends comfort and style. This delightful residence features 3 bedrooms and 2 bathrooms, making it an ideal choice for first-time homebuyers or those looking to downsize. As you approach, you’ll be greeted by three inviting porches—front, side, and rear—offering numerous options for enjoying your morning coffee or relaxing in the evening breeze. The property is surrounded by a vinyl fence with double gates on the driveway side, ensuring both privacy and convenience. Step inside to discover real hardwood floors that flow through the living room, dining area, and hallway, adding warmth and character to the home. The adorable kitchen is a true highlight, featuring granite countertops, a small island for extra prep space, and a built-in desk, perfect for your work-from-home needs. This home is centrally located between Mandeville and Slidell, providing easy access to I-12 and the Causeway for a convenient commute. Enjoy the outdoors with nearby attractions including Pelican Park, Fontainebleau State Park, and Big Branch Marsh Wildlife Refuge, making this location a nature lover's paradise. Don’t miss out on this super cute home that perfectly balances charm, functionality, and location—schedule your showing today!
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Jul 19, 2025
•
MLS# 2512244 —
The Building
-
Year Built:1997
-
Construction Materials:Vinyl Siding
-
Architectural Style:Cottage
-
Building Area Total:1377
-
Building Area Source:Appraiser
-
Roof:Shingle
-
Foundation:Raised
-
Exterior Features:Fence
-
Levels:One
-
Stories:1
Interior
-
Rooms Total:6
-
Interior Features:Tray Ceiling(s), Ceiling Fan(s), Granite Counters, Pantry
-
Living Area:1226
-
Living Area Source:Appraiser
-
Fireplace:Yes
-
Fireplace Features:Gas Starter, Wood Burning
-
Laundry Features:Washer Hookup, Dryer Hookup
Financial & Terms
-
Home Warranty:No
Location
-
Directions:Hwy 190 East, left on Snow St., house is on the right side, corner lot, driveway is on Snow, House on Esquinance
-
Cross Street:Snow St., Hwy 190
The Property
-
Parcel Number:45562
-
Property Type:Residential
-
Property Subtype:Detached
-
Property Subtype Additional:Detached, Single Family Residence
-
Property Condition:Very Good Condition
-
Lot Features:Corner Lot, Outside City Limits, Oversized Lot
-
Lot Size Area:0.2202
-
Lot Size Acres:0.2202
-
Lot Size Dimensions:74x129
Listing Agent
- Contact info:
- Agent phone:
- (504) 332-5211
- Office phone:
- (504) 332-5211
Taxes
-
Tax Lot:19
-
Tax Legal Description:LOT 19 FOUNTAINBLEAU HEIGHTS CB 1020 479 INST NO 1018179 INST NO 1066192 INST NO 1122131 INST NO 1152460 INST NO 1255791 INST NO 1255750 INST NO 1463381 INST NO 1678738 INST NO 1705899 INST NO 1705904
Beds
-
Bedrooms Total:3
Baths
-
Total Baths:2
-
Full Baths:2
The Listing
-
Current Price:$220,000
-
Special Listing Conditions:None
Heating & Cooling
-
Heating:Central
-
Heating:Yes
-
Cooling:Central Air
-
Cooling:Yes
Utilities
-
Sewer:Treatment Plant
-
Water Source:Well
Appliances
-
Appliances:Dishwasher, Microwave, Oven, Range
Schools
-
Elementary School:Www.Stpsb.Org
The Community
-
Subdivision Name:Fountinbleau
-
Pool Features:None
-
Association:No
Parking
-
Parking Features:Driveway
Extra Units
-
Other Structures:Shed(s)
Monthly cost estimate

Asking price
$220,000
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$1,178
|
Taxes | N/A |
Insurance | $60 |
Utilities | $123 See report |
Total | $1,361/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
7/19/25
Jul 19, 2025
|
Listed / Active | GSREIN | $220,000 |