Property Attributes
- MLS#2574497
- TypeSingle Family
- Listing Status Active
- ParishST TAMMANY
- CityMandeville
- NeighborhoodHunters Glen
- Zip70448
- StyleTraditional
- Year Built1998
- Price$ 529,000
- Bedrooms4
- Full Bathrooms3
- Half Bathrooms0
- Sqr Footage2707
Data Source:
Gulf South Real Estate Information Network
Property Description
Stunning 2 story home in Mandeville just minutes from shops, boutiques, stores and other amenities. This stunning 4-bedroom, 3-bath home offers the perfect blend of comfort, style, and entertaining space in a gated community with pool, playground, and access to the Tammany Trace Bike Trail. Enter into soaring 20-ft ceilings, an open floor plan, beautiful natural light, and a gourmet kitchen centrally located featuring custom cabinetry, gas range, island, two pantries, stainless appliances, wine rack, and showcase cabinets. The spacious living room has 12-ft ceilings, a shiplap-style fireplace, and access to the formal dining, breakfast area, kitchen bar, garage and expansive outdoor entertaining areas and screen porch. The main-level primary suite features wood flooring, high ceilings, a custom closet, screened porch access, and a stunning two-way fireplace connecting to the luxurious ensuite with soaking tub, separate shower, dual vanities, and private water closet. An additional bedroom is downstairs, with two more bedrooms, a bath, and upstairs living space. Outside, enjoy a beautifully shaded backyard with Live Oaks, fruit tree, low maintenance landscaping, private fencing, storage, and multiple areas for relaxing and entertaining. The entertaining spaces are available inside and outside for all year round options. New roof installed May 2024. A beautiful home in a fantastic location—come see all it has to offer!
| Price History | |
|---|---|
| 8/27/2026 | Listed $529,000 |
General Features
| Sewer | Public Sewer |
|---|---|
| Heating | Central,Multiple Heating Units |
| Cooling | Central Air,2 Units |
| Roof | Shingle |
| Appliances | Cooktop,Dishwasher,Disposal,Microwave,Oven |
| HOA Fee | 325 |
| Patio/Porch Features | Covered |
| Architectural Style | Traditional |
| Pool Features | Community |
| Construction Materials | Brick,Stucco,Vinyl Siding |
| Year Built | 1998 |
| Stories Count | 2 |
| Levels | Two |
| Property Subtype | Detached |
| Assoc Fee Paid Per | Quarterly |
| County | St Tammany |
| Property Type | Residential |
| Association Amenities | Clubhouse |
| HOA | Yes |
| Energy Efficient | Windows |
| Subdivision Name | Hunters Glen |
| Garage Y/N | Yes |
| Other Structures | Other,Shed(s) |
| Total Rooms | 11 |
| Full Baths | 3 |
| Status | Active |
| Directions | From Highway 190,turn onto Highway 59,turn left onto Remington Drive,Right right onto Winchester,first home on left |
| City | Mandeville |
| Association Name | Hunters Glen |
| Property Condition | Excellent |
| Standard Status | Active |
| Tax Lot | 97 |
| Property Sub Type Additional | Detached,Single Family Residence |
| PostalCity | Mandeville |
| Legal Description | Lot 97 Hunters Glen Ph 3A Inst No 986156 Inst No 1059435 |
Interior Features
| Interior Amenities | Attic,Tray Ceiling(s),Ceiling Fan(s),Granite Counters,Pantry,Pull Down Attic Stairs,Stainless Steel Appliances,Wired for Sound |
|---|---|
| Fireplace Features | Gas |
| Air Conditioning Y/N | Yes |
| Heating Y/N | Yes |
| Fireplace Y/N | Yes |
| Total Bedrooms | 4 |
| LivingAreaSource | Assessor |
Exterior Features
| Exterior Amenities | Fence |
|---|---|
| Parking Features | Attached,Garage,Two Spaces |
| Lot Features | City Lot,Rectangular Lot |
| Water Source | Public |
| Foundation Details | Slab |
| Building Area Total | 3410 |
| Lot Dimensions | 100x200 |
Room Details
| Room | Dimensions | Level | Flooring | Details |
|---|---|---|---|---|
| Bedroom | Second | Wood | ||
| Bedroom | First | Wood | ||
| Bedroom | Second | Wood | ||
| Breakfast Room/Nook | First | Tile | ||
| Dining Room | First | Tile | ||
| Foyer | First | Tile | ||
| Kitchen | First | Tile | ||
| Living Room | First | Tile | ||
| Loft | Second | Wood | ||
| Primary Bathroom | First | Tile | ||
| Primary Bedroom | First | Wood |
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