Welcome to the Dream on Stream!! Stunning renovation of the entire home in 2022 designed by renowned Rivers Spencer Interiors! Fabulous curb appeal on this French Provincial beauty on a corner lot with hardwood trees on a quiet cul-de-sac. Exterior features include 3 year old slate-style multi-faceted roof (F-Wave) with 50 year life adding architectural depth, brick exterior, raised brick front porch, elegant Bevolo gas lanterns at both entrances, Bevolo lantern, iron fountain,audio/video security, lush, low maintenance landscaping in front, back and side w/ sprinkler system & landscape lighting, generator, gutters w/ leaf guard & fenced yard with rear yard access and plenty of privacy. Step inside and enjoy the "WOW FACTOR" with 12 ft. ceilings, open floorplan, gourmet kitchen with new custom wood cabinets, luxury appliances and hood, quartz counters, reverse osmosis water filtration system w/ UV treatment, wood floors, quad moldings, plantation shutters, gorgeous lighting and plumbing fixtures, lavish primary bath, tankless water heater, 20 SEER variable speed HVAC replaced 2022 including all new duct system. Beautiful custom window treatments remain. Fresh top of the line paint on entire exterior and interior. There is an approx. 400 sq. ft. unfinished bonus room with stairs and window in place if more space desired. Seller added over $250K in improvements. Forest Brook offers a community pool, playground, adding a 2nd entrance, walking/bike path and has convenient access to schools, restaurants, lakefront, Pelican Park, and I-12. Located in preferred flood zone C. Gorgeous home meticulously styled with high-end finishes and timeless detail!! Premium quality safe is included. Industrial grade vinyl playset remains or will be removed if desired.
Closed
Price Unknown
3501 Stream Ct, Mandeville, LA 70448
4beds
2,098sqft
Single Family Residence
Built in 2004
0.33 Acres Lot
$480,000 Zestimate®
$--/sqft
$2,510 Estimated rent
Owner options
What's special
Zillow last checked: 8 hours ago
Listing updated: November 20, 2025 at 01:40pm
Listed by:
Darlene Gurievsky 985-789-2434,
Berkshire Hathaway HomeServices Preferred, REALTOR,
Barry Gurievsky 985-264-2444,
Berkshire Hathaway HomeServices Preferred, REALTOR
Bought with:
Darlene Gurievsky
Berkshire Hathaway HomeServices Preferred, REALTOR
Source: GSREIN,MLS#: 2524094
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 2
- Full bathrooms: 2
Primary bedroom
- Level: Lower
- Dimensions: 15.20 X 14.90
Bedroom
- Level: Lower
- Dimensions: 11.40 X 10.00
Bedroom
- Level: Lower
- Dimensions: 11.80 X 10.70
Bedroom
- Level: Lower
- Dimensions: 13.10 X 10.30
Breakfast room nook
- Level: Lower
- Dimensions: 13.50 X 10.90
Dining room
- Description: Flooring: Engineered Hardwood
- Level: Lower
- Dimensions: 12.10 X 11
Kitchen
- Description: Flooring: Engineered Hardwood
- Level: Lower
- Dimensions: 15.60 X 13.60
Laundry
- Level: Lower
- Dimensions: 6.10 X 5.10
Living room
- Description: Flooring: Engineered Hardwood
- Level: Lower
- Dimensions: 19.50 X 18.30
Heating
- Central
Cooling
- Central Air, 1 Unit
Appliances
- Included: Dryer, Dishwasher, Disposal, Microwave, Oven, Range, Refrigerator, Washer
Features
- Attic, Pantry, Stone Counters, Stainless Steel Appliances
- Has fireplace: Yes
- Fireplace features: Gas
Interior area
- Total structure area: 2,636
- Total interior livable area: 2,098 sqft
Property
Parking
- Parking features: Attached, Garage, Two Spaces, Garage Door Opener
- Has attached garage: Yes
Features
- Levels: One
- Stories: 1
- Patio & porch: Concrete, Covered, Porch
- Exterior features: Fence, Sprinkler/Irrigation, Porch
- Pool features: Community
Lot
- Size: 0.33 Acres
- Dimensions: 90 x 160
- Features: Corner Lot, Outside City Limits, Oversized Lot
Details
- Parcel number: 704483501STREAMCT282
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: French Provincial
- Property subtype: Single Family Residence
Materials
- Brick
- Foundation: Slab
Condition
- Excellent
- Year built: 2004
Utilities & green energy
- Electric: Generator
- Sewer: Public Sewer
- Water: Public
Green energy
- Energy efficient items: Roof
Community & neighborhood
Security
- Security features: Security System, Fire Sprinkler System
Community
- Community features: Pool
Location
- Region: Mandeville
- Subdivision: Forest Brook
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $146 quarterly
Sell with ease on Zillow
Get a Zillow Showcase℠ listing at no additional cost and you could sell for —faster.
$480,000
2% more+$9,600
With Zillow Showcase(estimated)$489,600