$362,241 - $451,000
RENTED APR 10, 2025

151 Rue Esplanade None Slidell, LA 70461

4 Beds
2.5 Baths
3,200 Sq Ft
$123 Price per Sq Ft

Highlights

  • 0.91 Acre Lot
  • Hydromassage or Jetted Bathtub
  • Stainless Steel Appliances
  • Cypress Cove Elementary School Rated A-
  • Granite Countertops
  • Oversized Lot

About This Home

As of April 2025

New rate and Outstanding opportunity. Welcome to luxury lease living at its finest. Stunning 4 bedrooms, 2.5 baths ranch on a one-acre lot. Conveniently located in a desirable Slidell neighborhood and within a highly rated school district. This home is minutes away from shopping, dining, and parks. The property also features an oversized living room with cozy fireplace, gourmet Kitchen, large comfortable Den and an office. Recently renovated with luxury flooring throughout including natural stone, scored concrete, onyx, and porcelain flooring with inlaid features plus wide classic crown molding throughout. The updated kitchen includes granite countertops with richly appointed cabinets, neutral color palette throughout, along with stainless-steel appliances and wet bar. Baths feature hydro tubs with shower, body sprays, and latest fashion fixtures. Add in an expansive yard, nice landscaping and a large rear patio for outdoor enjoyment.

Last Agent to Rent the Property

GILBERT BATTISTE

LATTER & BLUM (LATT09) License #NOM:000056993 Listed on: 03/06/2024

LATTER & BLUM (LATT09)

Last Renter's Agent

DWANA STEVENSON

Brittny McKay Real Estate License #NOM:995680867

Brittny McKay Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,215

Year Built

  • Built in 2023

Lot Details

  • 0.91 Acre Lot
  • Lot Dimensions are 204x200
  • Oversized Lot
  • Property is in very good condition

Home Design

  • Brick Exterior Construction
  • Slab Foundation
  • Stucco Exterior
  • HardiePlank Type

Interior Spaces

  • 3,200 Sq Ft Home
  • 1-Story Property
  • Ceiling Fan
  • Fireplace
  • Fire and Smoke Detector

Kitchen

  • Oven or Range
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Granite Countertops

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Hydromassage or Jetted Bathtub

Laundry

  • Dryer
  • Washer

Parking

  • 2 Car Garage
  • Off-Street Parking

Schools

  • Honey Island Elementary School
  • Boyet Middle School
  • North Shore H High School

Utilities

  • Central Heating and Cooling System
  • Two Heating Systems
  • ENERGY STAR Qualified Water Heater
  • Septic System
  • Internet Available

Additional Features

  • Porch
  • Outside City Limits

Community Details

  • French Branch Subdivision

Listing and Financial Details

  • Security Deposit $2,600
  • Assessor Parcel Number 120997

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,215

Year Built

Built in 2023

Lot Details

0

Rental Info

  • Electricity Paid By: Tenant
  • Rent Spree Y N: No
  • Security Deposit Amt: 2600
  • Termof Lease: 12 mo
  • Types Of Leases: Residential
  • Water Paid By: Tenant

Listing Details

  • Property Type: Lease
  • Style: Ranch
  • Lease Property Sub Type: Single Family
  • Condition: Vrgd
  • ADA Features: No
  • Additional Features: Ceiling Fan, Fireplace, Granite Counters, Hydro Tub, Smoke Alarm, Stainless Steel Appliances, Washer/Dryer Hookups
  • Lp Amt Sq Ft: 0.81
  • Measurmnt Apprx Not Guaranteed: Yes
  • Stories In Building: 1.0000
  • Total Area: 3600
  • Year Renovated: 2023
  • Age: 46
  • Special Features: None
  • Property Sub Type: Detached
  • Year Built: 2023

Interior Features

  • Appliance Include: Dryer, Dishwasher, Microwave, Refrigerator, Range/Oven, Washer
  • Total Bedrooms: 4
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Room Count: 8
  • Estimated Living Area: 3200
  • Total Bathrooms: 3.00
  • Furnished YN: No
  • Total Sq Ft: 3200

Exterior Features

  • Pool Type: None
  • Exterior: Brick, Hardy Plank, Stucco
  • ExteriorFeatures: Porch
  • Foundation: Slab
  • Fencing: None

Garage/Parking

  • Car Storage: 2
  • Car Storage: Two, Garage, Off Street Parking
  • Internet: Yes

Utilities

  • Air Conditioner: One, Central
  • Electricity Provided By: Cleco
  • Gas Paid By: Tenant
  • Gas Type: Natural
  • Heating: Two, Central
  • Sewer Type: Septic
  • Water Type: Public

Condo/Co-op/Association

  • Pet Restrictions: Yes
  • Pets Allowed: None

Schools

  • Elementary School: Honey Island
  • Middle School: Boyet
  • High School: north Shore H

Lot Info

  • Acres: 0.9100
  • Elevation Certificate: No
  • Lot Description: Oversized
  • Lot Num: 78
  • Lot Size: 204x200
  • Parcel #: 120997

Green Features

  • Energy Efficient Features: Water Heater
  • Green Building Cert Attached Y N: No

MLS Schools

  • Elementary School: Honey Island
  • High School: north Shore H
  • Middle School: Boyet

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Aug 7, 2025
Sold by
Battiste Gilbert A
Bought by
Parish Of St Tammany
Current Estimated Value
$394,560
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Parish Of St Tammany -- --
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/10/2025 04/10/25 Rented $2,600 0.0% --
03/25/2025 03/25/25 Under Contract -- -- --
01/31/2025 01/31/25 Price Changed $2,600 -7.1% $1 / Sq Ft
08/01/2024 08/01/24 Price Changed $2,800 -9.7% $1 / Sq Ft
03/06/2024 03/06/24 For Rent $3,100 -- --
Source: Gulf South Real Estate Information Network

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $3,215 $31,781 $4,500 $27,281
2023 $3,215 $25,296 $4,500 $20,796
2022 $256,251 $25,296 $4,500 $20,796
2021 $2,559 $25,296 $4,500 $20,796
2020 $2,546 $25,296 $4,500 $20,796
2019 $3,942 $26,151 $4,000 $22,151
2018 $3,957 $26,151 $4,000 $22,151
2017 $3,982 $26,151 $4,000 $22,151
2016 $4,075 $26,151 $4,000 $22,151
2015 $2,656 $23,984 $4,000 $19,984
2014 $2,606 $23,984 $4,000 $19,984
2013 -- $23,984 $4,000 $19,984
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Gulf South Real Estate Information Network

MLS Number: 2433399

Gulf South Real Estate Information Network

APN: 120997