Property Attributes
- MLS#2574405
- TypeSingle Family
- Listing Status Active Under Contract
- ParishST TAMMANY
- CityMandeville
- NeighborhoodGreenleaves Chateau Loire
- Zip70448
- StyleTraditional
- Year Built1990
- Price$ 359,000
- Bedrooms4
- Full Bathrooms2
- Half Bathrooms0
- Sqr Footage1902
Data Source:
Gulf South Real Estate Information Network
Property Description
What a great price for a 4 bedroom home with Tammany Trace bike trail access from the s/d! This spacious home offers a comfortable and versatile floor plan. The inviting living room features warm wood floors, a wood burning fireplace with built-ins, and a wall of windows that fills the space with natural light. The adjacent dining room offers flexibility as a home office, hobby room, playroom, or additional living space. The kitchen provides abundant cabinetry and granite countertops, making meal prep breeze. The spacious primary suite is a relaxing retreat with a tray ceiling and a generous bath featuring dual vanities, a garden tub, separate shower and plenty of space. Outside, enjoy the privacy of a large fully fenced backyard and unwind on the spacious screened porch which is perfect for morning coffee, afternoon relaxation, or entertaining friends and family. Ideally located in a desirable neighborhood with convenient access to shopping, dining, parks, and top-rated schools. This one has a wonderful combination of space, comfort, and location so don't miss the opportunity to make this home your own! NOTE: Some photos virtually staged with furniture.
| Price History | |
|---|---|
| 9/1/2026 | Listed $359,000 |
General Features
| Sewer | Public Sewer |
|---|---|
| Heating | Central |
| Cooling | Central Air |
| Roof | Shingle |
| HOA Fee | 152 |
| Patio/Porch Features | Covered,Porch |
| Architectural Style | Traditional |
| Pool Features | None |
| Construction Materials | Brick,Stucco,Vinyl Siding |
| Year Built | 1990 |
| Stories Count | 1 |
| Levels | One |
| Property Subtype | Detached |
| Assoc Fee Paid Per | Quarterly |
| County | St Tammany |
| Property Type | Residential |
| HOA | Yes |
| Subdivision Name | Greenleaves Chateau Loire |
| Garage Y/N | Yes |
| Other Structures | Shed(s) |
| Total Rooms | 9 |
| Full Baths | 2 |
| Status | Active Under Contract |
| Directions | Hwy 190 turn on Greenleaves Blvd to Chateau Loire on the right |
| City | Mandeville |
| Property Condition | Excellent |
| Standard Status | Active Under Contract |
| Tax Lot | 33 |
| Property Sub Type Additional | Detached,Single Family Residence |
| PostalCity | Mandeville |
Interior Features
| Interior Amenities | Granite Counters,Stainless Steel Appliances |
|---|---|
| Fireplace Features | Wood Burning |
| Air Conditioning Y/N | Yes |
| Heating Y/N | Yes |
| Fireplace Y/N | Yes |
| Total Bedrooms | 4 |
| LivingAreaSource | Appraiser |
Exterior Features
| Exterior Amenities | Fence,Porch |
|---|---|
| Parking Features | Attached,Garage,Two Spaces,Garage Door Opener |
| Lot Features | Outside City Limits,Oversized Lot |
| Water Source | Public |
| Foundation Details | Slab |
| Building Area Total | 2734 |
| Lot Dimensions | 90 x 160 |
Room Details
| Room | Dimensions | Level | Flooring | Details |
|---|---|---|---|---|
| Bedroom | Lower | Carpet | ||
| Bedroom | Lower | Carpet | ||
| Bedroom | Lower | Carpet | ||
| Breakfast Room/Nook | Lower | Tile | ||
| Dining Room | Lower | Wood | ||
| Foyer | Lower | Wood | ||
| Kitchen | Lower | Tile | ||
| Living Room | Lower | Wood | ||
| Primary Bedroom | Lower | Carpet |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Copyright © 2026 New Orleans Metropolitan Association of REALTORS®, Inc. All Rights Reserved. The sharing of MLS database, or any portion thereof, with any unauthorized third party is strictly prohibited. Information contained on this site is believed to be reliable; yet, users of this web site are responsible for checking the accuracy, completeness, currency, or suitability of all information. Neither the New Orleans Metropolitan Association of REALTORS®, Inc. nor the Gulf South Real
MLS United® - All information deemed reliable but not guaranteed. All properties are subject to prior sale, change, or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating