Property Attributes
- MLS#2564278
- TypeSingle Family
- Listing Status Active
- CountyST TAMMANY
- CityMandeville
- NeighborhoodMandeville Annex
- Zip70448
- StyleFarmhouse
- Year Built2026
- Price$ 575,000
- Bedrooms4
- Full Bathrooms3
- Half Bathrooms0
- Sqr Footage2701
- Lot Size0.149 Acres
Data Source:
Gulf South Real Estate Information Network
Property Description
Experience elevated Northshore living in this stunning new construction home featuring 4 bedrooms, 3 full bathrooms, and approximately 2,701 living square feet of thoughtfully designed space. From the moment you enter, soaring ceilings, designer finishes, wide-plank flooring, and abundant natural light. Great up-an-coming area. Lots of room for growth and development. The open-concept living area showcases a striking tray ceiling with exposed wood beams, a sleek fireplace, and seamless flow into the dining area and chef-inspired kitchen. Designed for both everyday living and entertaining, the kitchen features custom cabinetry, quartz countertops, a large center island, premium fixtures, open shelving, a walk-in pantry, and generous workspace. The spacious primary suite serves as a private retreat with oversized windows, a luxurious spa-style bathroom, dual vanities, a freestanding soaking tub, an oversized walk-in shower, and a custom walk-in closet with built-in shelving. Three additional bedrooms and two beautifully appointed guest baths provide flexibility for family, guests, or work-from-home needs. A dedicated office offers a quiet space for remote work, study, or hobbies. The well-designed utility room includes custom cabinetry, folding space, and a utility sink for added convenience. Outdoor living is equally impressive with a covered rear patio featuring an outdoor kitchen, creating a great setting for entertaining, game days, and year-round enjoyment. The fenced backyard offers ample green space for recreation, gardening, or pets. Located in a desirable Mandeville area, this home is in the vicinity of shopping, dining, parks, recreation, highly regarded schools, and major commuter routes while maintaining the charm and lifestyle that make the Northshore so sought after. If you see the neighbor across the street, his name is Mr John - the current grass guy. He is super nice and you can say hi! He knows everything about the neighborhood.
| Price History | |
|---|---|
| 6/25/2026 | Listed $599,000 |
| 7/11/2026 | 2$589,000 |
| 8/8/2026 | 3$575,000 |
General Features
| Sewer | Public Sewer |
|---|---|
| Heating | Central |
| Cooling | Central Air |
| Roof | Asphalt,Shingle |
| Appliances | Dishwasher,Oven,Range,Refrigerator,ENERGY STAR Qualified Appliances |
| Patio/Porch Features | Other |
| Architectural Style | Farmhouse |
| Pool Features | None |
| Construction Materials | Brick,HardiPlank Type |
| Year Built | 2026 |
| Stories Count | 2 |
| Levels | Two |
| Property Subtype | Detached |
| County | St Tammany |
| New Construction | Yes |
| Property Type | Residential |
| Energy Efficient | Appliances,HVAC,Insulation,Water Heater |
| Subdivision Name | Mandeville Annex |
| Total Rooms | 14 |
| Full Baths | 3 |
| Status | Active |
| Directions | Florida / 190 Then North At Adair - Turns RT Into Orleans,House On Left By Tammany Trace |
| City | Mandeville |
| Home Warranty Y/N | Yes |
| Property Condition | New Construction |
| Standard Status | Active |
| Tax Lot | 6 |
| Property Sub Type Additional | Detached,Single Family Residence |
| PostalCity | Mandeville |
| Legal Description | LOT 6 OF RESUB OF LOT 1 SQ 147 MANDEVILLE MEAS 50 |
Interior Features
| Interior Amenities | Attic,Ceiling Fan(s),Carbon Monoxide Detector,Pull Down Attic Stairs,Stainless Steel Appliances,Smart Home |
|---|---|
| Fireplace Features | Other |
| Air Conditioning Y/N | Yes |
| Heating Y/N | Yes |
| Laundry Features | Washer Hookup,Dryer Hookup |
| Total Bedrooms | 4 |
| LivingAreaSource | Appraiser |
Exterior Features
| Exterior Amenities | Outdoor Kitchen |
|---|---|
| Parking Features | Driveway |
| Lot Features | City Lot,Rectangular Lot |
| Water Source | Public |
| Lot Size Area | 0.149 |
| Foundation Details | Raised |
| Building Area Total | 2867 |
| Lot Dimensions | 50 X 127 |
| Lot Size Acres | 0.149 |
Room Details
| Room | Dimensions | Level | Flooring | Details |
|---|---|---|---|---|
| Bathroom | Second | Tile | ||
| Bathroom | Second | Tile | ||
| Bedroom | Second | Plank,Simulated Wood | ||
| Bedroom | Second | Plank,Simulated Wood | ||
| Bedroom | Second | Plank,Simulated Wood | ||
| Dining Room | First | Plank,Simulated Wood | ||
| Foyer | First | Plank,Simulated Wood | ||
| Kitchen | First | Plank,Simulated Wood | ||
| Living Room | First | Plank,Simulated Wood | ||
| Office | First | Plank,Simulated Wood | ||
| Pantry | First | Plank,Simulated Wood | ||
| Primary Bathroom | First | Tile | ||
| Primary Bedroom | First | Plank,Simulated Wood | ||
| Utility Room | First | Tile |
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