24664 Esquinance St

1,468 Sq. Ft.
$174 / Sq. Ft.
1,468
Sq. Ft.
$174
per Sq. Ft.

Description

This adorable 3 bedroom 2 bath home is neat, clean and in mint, move in condition! It has high ceilings sits in a huge 180 x 120 lot with several beautiful oak trees. It is quality built, has no carpet and has been well maintained by the present owners. The foam insulation keeps the utility bills very reasonable. In 2024 the kitchen was renovated with quartz countertops and 42" tall natural wood cabinets. It also has stainless appliances and the sale includes the refrigerator, washer and the dryer....This adorable 3 bedroom 2 bath home is neat, clean and in mint, move in condition! It has high ceilings sits in a huge 180 x 120 lot with several beautiful oak trees. It is quality built, has no carpet and has been well maintained by the present owners. The foam insulation keeps the utility bills very reasonable. In 2024 the kitchen was renovated with quartz countertops and 42" tall natural wood cabinets. It also has stainless appliances and the sale includes the refrigerator, washer and the dryer. In February 2026 the hardy plank exterior was freshly painted. The well, water tank and pump were replaced, as well as the pipe leading to the ditch on the septic system. A 12x16 Office was added and it is separate from the main house. It was built in 2012 and is insulated, has sheetrock walls, a metal roof and has a window unit and water. The bedrooms are all a nice size and both the formal dining and the living rooms are spacious as well. This home is located in the award wining Mandeville School district and is only 1.5 miles from Fontainebleau State Park. The covered carport has a storage shed attached. Enjoy quiet evenings or have your morning coffee in the courtyard area which also has a gazebo. Flood Zone X (flood insurance is optional)

Listing Agent

  1. Lisa Greenleaf

    Lisa Greenleaf

    Listing Agent

    Compass

    P: (985)-966-5472

Property Details for 24664 Esquinance Street

Architectural Style
Traditional Style
Subdivision Name
Fountains
LISTING UPDATED: 05/14/2026 01:18 PM

Property Details for 24664 Esquinance Street

StatusActive
MLS #2557779
Days on Market8
Taxes-
HOA Fees-
Condo/Co-op Fees-
Property TypeSingle Family
MLS TypeResidential / Detached Single Family / Single Family Home
Year Built2004
Lot Size0.50 AC / 21,600 SF
CountySt. Tammany Parish

Location

Add your commute

Building Information for 24664 Esquinance Street

Stories1Year Built2004Building Size-Lot Size0.50 AC / 21,600 SF

Payment Calculator

$1,357 per month

30 year fixed, 6.36% Interest

Principal and Interest

$1,271

Property Taxes

$86

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 24664 Esquinance Street

Summary
Location and General Information
  • Directions: Hwy 190 east. Go 1.8 miles past Fontainebleau State Park to Snow Street. North on Snow to Esquinance Bounding Streets: Snow, Raymond Rd, Hwy 190
  • Latitude: 30.34
  • Longitude: -89.99
  • MLS Area Minor: ST. TAMMANY
  • Year Built: 2,004
  • In City Limits: No
  • Neighborhood: Fountainbleau Height
Parking
  • Parking Features: 2 Car, Attached, Carport, Driveway
Taxes and HOA
  • Association: No
Virtual Tour
Property
Lot Information
  • Building Area Total: 1875.0
  • Living Area: 1468.0
  • Living Area Source: Appraiser
  • Lot Features: Rear Yard Vehicle Access
  • Lot Size Acres: 0.0
  • Lot Size Dimensions: 180x120
Property and Assessments
  • Home Warranty: No
  • Parcel Number: 52655
  • Property Sub Type: Detached Single Family
  • Property Type: Residential
  • Sub Type: Single Family Home
  • Overall Condition: Excellent
Utilities
  • Sewer: Waste Water Utility
  • Water Source: Well
  • GS Utilities Gas: None
  • EL Utilities Elec: CLECO
Interior and Exterior Features
Exterior Features
  • Construction Materials: HardiPlank Type
  • Exterior Features: Courtyard
  • Foundation Details: Slab
  • Other Structures: Shed(s)
  • Patio And Porch Features: Patio: Concrete, Covered
  • Pool Private: No
  • Roof: Metal
  • Stories: 1
Interior Features
  • Appliances: Dishwasher, Disposal, Microwave, Range, Refrigerator, Stainless Steel Appliance(s)
  • Bathrooms Full: 2
  • Bathrooms Partial: 0
  • Bedrooms Total: 3
  • Cooling: Central Air
  • Heating: Central
  • Interior Features: Ceiling Fan(s)
  • Laundry Features: Dryer, Washer, Washer/Dryer Hookups
  • Other Equipment: Smoke Detector
  • Bathrooms Display: 2/0
Room Information
Room Information
  • KF Kitchen Features: Counters Stone,Pantry

Property History for 24664 Esquinance Street

DateEvent & SourcePriceAppreciation
May 14, 2026

Listed (Active)

ROAM MLS #2557779

$255,000—
Jul 29, 2011

Temporarily Off Market

ROAM MLS #NO879364

$150,000—
Jun 14, 2011

Listed (Active)

ROAM MLS #NO879364

$150,000—
DateEvent & SourcePrice
05/14/2026

Listed (Active)

ROAM MLS #2557779

$255,000
07/29/2011

Temporarily Off Market

ROAM MLS #NO879364

$150,000
06/14/2011

Listed (Active)

ROAM MLS #NO879364

$150,000

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

Public Records for 24664 Esquinance Street

Taxable ValueLand$3,399Additions$12,609Total$16,008
Tax Record2025$1,037 ($86 / month)
Home Facts
Beds0Total Finished SqFt1,272 SqFtAbove Grade Finished SqFt1,272 SqFtLot Size21,780 SqFtStyleSingle Family ResidenceYear Built2004CountySAINT TAMMANYAPN52655

Schools near 24664 Esquinance Street

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

Mandeville Middle School
Public4 to 6

L.P. Monteleone Junior High School
Public7 to 8

Lakeshore 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

24664 Esquinance Street is a single family home for sale in Lacombe, LA 70445. This property was listed for sale on May 14, 2026 by Compass, it's currently listed at $255,000. This listing's school district is St. Tammany Parish School District. Nearby schools include Woodlake Elementary School, Mandeville Middle School and L.P. Monteleone Junior High School. 24664 Esquinance Street is a 3-bed, 2-bath, 1,468 sqft single family home built in 2004.

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.

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.