Prime Cul-de-Sac Location in Cherry Creek Subdivision! This beautifully maintained home offers a sparkling pool and peaceful pond views, all in a convenient setting close to the Causeway, shopping, and dining. The impressive two-story foyer welcomes you with a graceful winding staircase and private study. The open, sun-filled layout flows seamlessly from the inviting family room with a double sided fireplace, into the spacious kitchen and cozy sitting area—perfect for entertaining or everyday living. Upstairs, two bedrooms share a Jack-and-Jill bath, while a fourth bedroom enjoys its own private bath. This home is clean, move-in ready, and waiting for its next owner!
Closed
Price Unknown
204 Aaron Ct, Mandeville, LA 70448
4beds
3,526sqft
Single Family Residence
Built in 1997
-- sqft lot
$587,300 Zestimate®
$--/sqft
$4,477 Estimated rent
Home value
$587,300
$540,000 - $640,000
$4,477/mo
Zestimate® history
Owner options
List your home for rent
$4,477/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$4,477/mo
Rent Zestimate®
Refinance and save
$350/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$350/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Sparkling poolGraceful winding staircaseImpressive two-story foyerPrivate studyPeaceful pond viewsPrivate bathSpacious kitchen
Zillow last checked:
Listing updated:
Listed by:
Jennifer Rice 985-966-1321,
Berkshire Hathaway HomeServices Preferred, REALTOR,
Lauren Mendheim 985-373-7231,
Berkshire Hathaway HomeServices Preferred, REALTOR
Bought with:
Jamie Mixon Cure
Keller Williams Realty Services
Source: GSREIN,MLS#: 2523272
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Primary bedroom
- Level: First
- Dimensions: 16.9x14.6
Bedroom
- Level: Second
- Dimensions: 14.2x13.6
Bedroom
- Level: Second
- Dimensions: 14.5x13.9
Bedroom
- Level: Second
- Dimensions: 13.3x12.8
Breakfast room nook
- Level: First
- Dimensions: 22.1x17
Den
- Level: First
- Dimensions: 12.9x12.3
Dining room
- Level: First
- Dimensions: 14.5x13.7
Kitchen
- Level: First
- Dimensions: 14.6x12.1
Laundry
- Level: First
- Dimensions: 12.8x6.4
Living room
- Level: First
- Dimensions: 21.7x19.5
Heating
- Central, Multiple Heating Units
Cooling
- Central Air, 3+ Units
Appliances
- Included: Cooktop, Dishwasher, Disposal, Microwave, Oven, Refrigerator
Features
- Ceiling Fan(s), Pantry, Cable TV
- Has fireplace: Yes
- Fireplace features: Gas
Interior area
- Total structure area: 4,267
- Total interior livable area: 3,526 sqft
Property
Parking
- Total spaces: 2
- Parking features: Attached, Garage, Two Spaces, Garage Door Opener
- Has attached garage: Yes
Features
- Levels: Two
- Stories: 2
- Exterior features: Fence
- Pool features: In Ground
Lot
- Dimensions: 90 x 141 x 156 x 142
- Features: Cul-De-Sac, Outside City Limits, Oversized Lot, Pond on Lot
Details
- Parcel number: 999
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence
Materials
- Brick, Stucco, Vinyl Siding
- Foundation: Slab
- Roof: Shingle
Condition
- Very Good Condition
- Year built: 1997
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & neighborhood
Security
- Security features: Smoke Detector(s)
Location
- Region: Mandeville
- Subdivision: Cherry Creek
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $350 annually
Price history
| Date | Event | Price |
|---|---|---|
| 2/6/2026 | Sold | -- |
Source:  GSREIN #2523272 Report a problem | ||
| 12/31/2025 | Pending sale | $590,000$167/sqft |
Source: BHHS broker feed #2523272 Report a problem | ||
| 12/30/2025 | Contingent | $590,000$167/sqft |
Source: GSREIN #2523272 Report a problem | ||
| 11/5/2025 | Price change | $590,000-4.1%$167/sqft |
Source: GSREIN #2523272 Report a problem | ||
| 10/8/2025 | Price change | $615,000-1.6%$174/sqft |
Source: GSREIN #2523272 Report a problem | ||
| 9/25/2025 | Listed for sale | $625,000+25.3%$177/sqft |
Source: GSREIN #2523272 Report a problem | ||
| 12/2/2020 | Sold | -- |
Source: GSREIN #2262298 Report a problem | ||
| 11/2/2020 | Pending sale | $499,000$142/sqft |
Source: Real Estate Resource Group LLC #2262298 Report a problem | ||
| 8/31/2020 | Price change | $499,000-4.4%$142/sqft |
Source: Real Estate Resource Group LLC #2262298 Report a problem | ||
| 8/2/2020 | Listed for sale | $522,000$148/sqft |
Source: Real Estate Resource Group LLC #2262298 Report a problem | ||
| 6/25/2010 | Sold | -- |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $5,843 -3.6% | $48,712 |
| 2024 | $6,059 +15.9% | $48,712 +23.5% |
| 2023 | $5,227 0% | $39,437 |
| 2022 | $5,227 +0.2% | $39,437 |
| 2021 | $5,218 +0.1% | $39,437 |
| 2020 | $5,212 -0.7% | $39,437 +3% |
| 2019 | $5,249 -0.1% | $38,288 |
| 2018 | $5,257 -0.9% | $38,288 |
| 2017 | $5,306 -0.8% | $38,288 |
| 2016 | $5,347 | $38,288 +14.1% |
| 2015 | $5,347 +11.1% | $33,548 |
| 2014 | $4,814 +1.1% | $33,548 |
| 2013 | $4,763 -6.9% | $33,548 -5.1% |
| 2011 | $5,115 | $35,342 |
Find assessor info on the county website
Neighborhood: 70448
Nearby schools
GreatSchools rating
- 10/10Mandeville Elementary SchoolGrades: PK-3Distance: 1.1 mi
- 7/10Fontainebleau Junior High SchoolGrades: 7-8Distance: 2.7 mi
- 8/10Fontainebleau High SchoolGrades: 9-12Distance: 2.9 mi
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$587,300
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$587,300
- Louisiana
- Saint Tammany Parish
- Mandeville
- 70448
- 204 Aaron Ct
Nearby cities
Nearby zip codes
Other Mandeville Topics
