151 Rue Esplanade
Description
Listing Agent
![Gilbert Battiste]()
gilbert.battiste@compass.comP: (504)-339-8686
Property Details for 151 Rue Esplanade
Property Details for 151 Rue Esplanade
| Status | Closed |
|---|---|
| MLS # | 2433399 |
| Days on Market | 383 |
| Rental Incentives | - |
| Costs & Fees | - |
| Available Date | 02/01/2025 |
| Lease Term | Lease Length: 12 Months |
| Furnished | - |
| Compass Type | Rental |
| MLS Type | Residential Lease / Single Family Residence |
| Year Built | 1978 |
| Lot Size | 0.94 AC / 40,800 SF |
| County | St. Tammany Parish |
Location
Building Information for 151 Rue Esplanade
Property Information for 151 Rue Esplanade
- Directions: I-10 East to Fremaux ,east to military rd. , north to Rue Esplanade, west to address Bounding Streets: Rue Lamothe, Rue Chateau, Military rd.
- Latitude: 30.27
- Longitude: -89.73
- MLS Area Minor: ST. TAMMANY
- Year Built: 1,978
- In City Limits: Yes
- Parking Features: 2 Car, Garage, Off Street
- High School: north Shore H
- Elementary School: Honey Island
- Middle School: Boyet
- Tax Lot Number: 78
- Virtual Tour URL Branded: https://www.propertypanorama.com/instaview/roam/2433399
- Building Area Total: 3600.0
- Living Area: 3200.0
- Living Area Source: Appraiser
- Lot Features: Oversized
- Lot Size Dimensions: 204x200
- Lot Size Area: 0.91
- Parcel Number: 120997
- Property Sub Type: Single Family Residence
- Property Type: Residential Lease
- Apx Age: 46
- Green Energy Efficient: Water Heater
- Sewer: Septic Tank
- Water Source: Public
- GS Utilities Gas: Other Gas
- EL Utilities Elec: CLECO
- Construction Materials: Brick, HardiPlank Type, Stucco
- Fencing: None
- Foundation Details: Slab: Traditional
- Stories: 1
- Appliances: Dishwasher, Microwave, Range, Refrigerator, Stainless Steel Appliance(s)
- Bathrooms Full: 2
- Bathrooms Partial: 1
- Bedrooms Total: 4
- Cooling: Central Air
- Fireplace Features: Other
- Heating: Coal, Central Heat
- Interior Features: Ceiling Fans
- Other Equipment: Dryer, Smoke Detector, Washer, Washer/Dryer Hookups
- Bathrooms Display: 2/1
- BA Master Bath: MBA Tub: Jetted
- KF Kitchen Features: Counters Granite
- Tenant Pays: Electricity, Gas, Water
- Pet Comments: None
- Lease Term Description: 12 mo
- Pets: No
- Rent Spree Online Screening: No
- Rent Assist Or Low Inc: No
Property History for 151 Rue Esplanade
| Date | Event & Source | Price | Appreciation |
|---|---|---|---|
| Apr 10, 2025 | Rented ROAM MLS #NO2433399 | — | |
| Mar 25, 2025 | Application Pending ROAM MLS #NO2433399 | — | |
| Mar 6, 2024 | Listed (Active) ROAM MLS #NO2433399 | $3,100 | — |
| Date | Event & Source | Price |
|---|---|---|
| 04/10/2025 | Rented ROAM MLS #NO2433399 | — |
| 03/25/2025 | Application Pending ROAM MLS #NO2433399 | — |
| 03/06/2024 | Listed (Active) ROAM MLS #NO2433399 | $3,100 |
For completeness, Compass often displays two records for one sale: the MLS record and the public record.
Schools near 151 Rue Esplanade
Rating | School | Type | Grades | Distance |
|---|---|---|---|---|
| Public - | PK to 1 | |||
| Public - | 2 to 3 | |||
| Public - | 4 to 6 | |||
| Public - | 7 to 8 |
Rating | School | Distance |
|---|---|---|
Cypress Cove Elementary School PublicPK to 1 | ||
Honey Island Elementary School Public2 to 3 | ||
Little Oak Middle School Public4 to 6 | ||
Boyet Junior High School Public7 to 8 |
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.
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 owner. 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.
