204 AARON Court, Mandeville, LA 70448
$590,000
Property Type:
Residential
Bedrooms:
4
Baths:
3.1
Square Footage:
4,267
Status:
Pending
Current Price:
$590,000
List Date:
9/25/2025
Last Modified:
1/12/2026
Description
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!
Supplements: ********
More Information MLS# NO2523272
Listing Info
Delayed Marketing: No
List Price/SqFt: 167.33
Document Modified: 2025-10-08 10:05:36.740535
Status: Pending
Listing Date: 2025-09-25
Listing Price: 590000
Current Price: $590,000
Type: Single Family Residence
Modification Timestamp: 2026-01-12T17:24:05Z
Photo Modified: 2025-09-26T13:39:04Z
Location, Tax & Legal Info
Legal Desc: LOT 67 CHERRY CREEK SUB PH 3
General Property Description
Lot Dimensions: 90x141x156x142
Stories: 2
SqFt - Living: 3526
SqFt - Source: Measured
SqFt - Total: 4267
Assn Fee $: 350
Assn Fee Terms: Yearly
Acreage Range: 0 - 0.5
# Bedrooms: 4
Baths - Full: 3
Baths - 1/2: 1
Total Baths: 3.1
Year Built: 1997
Remarks & Misc
Remarks: 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!
Office/Member/Contract Info
List AOR: NOMAR
Style
Traditional: 1
Siding
Stucco: 1
Vinyl Siding: 1
Parking
Attached: 1
Garage: 1
Construction
Brick: 1
Foundation
Slab: 1
Fireplace
Gas Log: 1
Roof
Composition: 1
Heating
Central: 1
Cooling
2 or More Units: 1
Central Air: 1
Appliances
Dishwasher: 1
Disposal: 1
Microwave: 1
Refrigerator: 1
Rooms
Bedroom 1: 1
Den: 1
Dining Room: 1
Kitchen: 1
Laundry: 1
Living Room: 1
Primary Bedroom: 1
Bedroom 2: 1
Bedroom 3: 1
Waterfront
Lake/Pond: 1
View: 1
Fencing
Other: 1
Lot
Cul-De-Sac: 1
Pool
Inground: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 52550095
Originating System Listing ID: 2523272
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 204
Street Name: AARON Court
Parish: St. Tammany
State: LA
Zip Code: 70448
Subdivision: Cherry Creek
Tax Assessment Number: 999
Directions: Hwy 190 to Cherry Creek Sub. At stop sign go straight onto Aaron, home on left in the cul de sac. Bounding Streets: Cherry Creek Dr
Status Change Info
Under Contract Date: 2025-12-27
Property Features
Style: Traditional
Siding: Stucco; Vinyl Siding
Parking: Attached; Garage
Construction: Brick
Foundation: Slab
Roof: Composition
Fireplace: Gas Log
Heating: Central
Cooling: 2 or More Units; Central Air
Appliances: Dishwasher; Disposal; Microwave; Refrigerator
Rooms: Bedroom 1; Den; Dining Room; Kitchen; Laundry; Living Room; Primary Bedroom; Bedroom 2; Bedroom 3
Fencing: Other
Lot: Cul-De-Sac
Waterfront: Lake/Pond; View
Pool: Inground
Room Information
Laundry
Length: 12.80
Width: 6.40
Remarks: Laundry
Dining Room
Length: 14.50
Width: 13.70
Remarks: Dining Room
Living Room
Length: 21.70
Width: 19.50
Remarks: Living Room
Den
Length: 12.90
Width: 12.30
Remarks: Den
Bedroom 1
Length: 14.50
Width: 13.90
Remarks: Bedroom
Bedroom 2
Length: 13.30
Width: 12.80
Remarks: Bedroom
Bedroom 3
Length: 14.20
Width: 13.60
Remarks: Bedroom
Kitchen
Length: 14.60
Width: 12.10
Remarks: Kitchen
Primary Bedroom
Length: 16.90
Width: 14.60
Remarks: Primary Bedroom
Documents
Floor Plan ›
Listing Office:
Berkshire Hathaway HomeServices Preferred, REALTOR
IDX
Last Updated: January - 12 - 2026
The data relating to real estate for sale or lease on this website comes in part from the IDX program of the REALTOR® Association of Acadiana MLS. The IDX information is provided exclusively for consumers’ personal, non-commericial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed accurate by the MLS.