$989,000
Mandeville, LA 70448
MLS# NO2525973
4 beds | 3.1 baths | 5468 sqft
1 / 47
Property Description
If you are looking for something truly extraordinary, this one-of-a-kind Mandeville estate offers it all. Nestled on 5.95 beautiful, tree-lined acres just south of I-12, this property features a main residence, a separate office, an RV/workshop building with a full one-bedroom apartment, two ponds, and a resort-style outdoor living area complete with a swimming pool. The four-bedroom main home showcases a stunning kitchen and butler's pantry, along with exceptional functionality that includes a flex room that can be used for a media room, game room, or whatever fits your lifestyle. There's also an air-conditioned upstairs bonus room for added versatility. Under the same roofline, a spacious brick-floored office offers endless possibilities including working from home, hobbies, or entertaining. Step out onto the oversized covered porch and enjoy your own private paradise featuring an outdoor kitchen, outdoor fireplace, and sparkling in-ground pool. A screened porch with a pool bath completes the ideal entertainment setup, while a covered workroom adds convenience and storage space. The separate RV/workshop building includes a beautifully designed one-bedroom apartment with a full kitchen, stackable washer/dryer, and custom shower great for guests, extended family, or potential rental income. The apartment's covered porch overlooks the property's serene grounds, and a whole-house generator ensures comfort and peace of mind. This remarkable property combines elegance, privacy, and functionality in a highly desirable Mandeville location. Opportunities like this are rare, don't miss your chance to own this exceptional estate!
Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 269.12
Document Modified: 2026-02-09 09:58:35.540139
Status: Active
Listing Date: 2025-10-13
Listing Price: 989000
Current Price: $989,000
Type: Single Family Residence
Modification Timestamp: 2026-02-09T15:58:48Z
Photo Modified: 2026-02-09T15:53:33Z
General Property Description
Lot Dimensions: 455x320x257x522x338x536x60x200
Stories: 1
SqFt - Living: 3675
SqFt - Source: Appraiser
SqFt - Total: 5468
Acreage Range: 3 - 5.99
# Bedrooms: 4
Baths - Full: 3
Baths - 1/2: 1
Total Baths: 3.1
Year Built: 1996
Acres: 5.95
Remarks & Misc
Remarks: If you are looking for something truly extraordinary, this one-of-a-kind Mandeville estate offers it all. Nestled on 5.95 beautiful, tree-lined acres just south of I-12, this property features a main residence, a separate office, an RV/workshop building with a full one-bedroom apartment, two ponds, and a resort-style outdoor living area complete with a swimming pool. The four-bedroom main home showcases a stunning kitchen and butler's pantry, along with exceptional functionality that includes a flex room that can be used for a media room, game room, or whatever fits your lifestyle. There's also an air-conditioned upstairs bonus room for added versatility. Under the same roofline, a spacious brick-floored office offers endless possibilities including working from home, hobbies, or entertaining. Step out onto the oversized covered porch and enjoy your own private paradise featuring an outdoor kitchen, outdoor fireplace, and sparkling in-ground pool. A screened porch with a pool bath completes the ideal entertainment setup, while a covered workroom adds convenience and storage space. The separate RV/workshop building includes a beautifully designed one-bedroom apartment with a full kitchen, stackable washer/dryer, and custom shower great for guests, extended family, or potential rental income. The apartment's covered porch overlooks the property's serene grounds, and a whole-house generator ensures comfort and peace of mind. This remarkable property combines elegance, privacy, and functionality in a highly desirable Mandeville location. Opportunities like this are rare, don't miss your chance to own this exceptional estate!
Office/Member/Contract Info
List AOR: NOMAR
Style
Traditional: 1
Parking
Detached: 1
Garage: 1
RV Access/Parking: 1
Construction
Brick: 1
Foundation
Slab: 1
Exterior
Outside Kitchen: 1
Patio
Covered: 1
Fireplace
Gas Log: 1
Roof
Composition: 1
Heating
Central: 1
Cooling
2 or More Units: 1
Central Air: 1
Water Source
Well: 1
Appliances
Dishwasher: 1
Microwave: 1
Refrigerator: 1
Utilities
Elec: Wst: 1
Rooms
Bedroom 1: 1
Dining Room: 1
Living Room: 1
Primary Bedroom: 1
Bedroom 2: 1
Bedroom 3: 1
Waterfront
Lake/Pond: 1
Amenities
Acreage: 1
Other Structures
Barn(s): 1
Pool
Inground: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 52733010
Originating System Listing ID: 2525973
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 23123
Street Name: HIGHWAY 1088
Parish: St. Tammany
State: LA
Zip Code: 70448
Subdivision: None
Tax Assessment Number: 139749
Directions: Take the Highway 1088 Exit off of I-12, drive south and the property will be on the right past the Forest Brook subdvision red light Bounding Streets: Highway 1088
Property Features
Style: Traditional
Parking: Detached; Garage; RV Access/Parking
Construction: Brick
Foundation: Slab
Roof: Composition
Fireplace: Gas Log
Heating: Central
Cooling: 2 or More Units; Central Air
Appliances: Dishwasher; Microwave; Refrigerator
Rooms: Bedroom 1; Dining Room; Living Room; Primary Bedroom; Bedroom 2; Bedroom 3
Patio: Covered
Amenities: Acreage
Exterior: Outside Kitchen
Other Structures: Barn(s)
Waterfront: Lake/Pond
Water Source: Well
Utilities: Elec: Wst
Pool: Inground
Room Information
| Room Name | Length | Width | Remarks |
| Bedroom 1 | 11.62 | 11.45 | Bedroom |
| Dining Room | 12.00 | 12.00 | Dining Room |
| Primary Bedroom | 16.09 | 15.33 | Primary Bedroom |
| Bedroom 2 | 11.33 | 12.12 | Bedroom |
| Bedroom 3 | 11.09 | 14.33 | Bedroom |
| Living Room | 19.50 | 23.00 | Living Room |
Property Disclosure IDX
Listing Office: Select Realty Group, LLC
Last Updated: February - 09 - 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.
GUIDRY & CO. REAL ESTATE, Lafayette, LA. All offices are independently owned and operated. The data relating to real estate for sale on this web site comes in part from the IDX Program of the Realtor® Association of Acadiana; MLS Real Estate listings held by brokerage firms other than GUIDRY & CO. REAL ESTATE are marked with the MLS approved icon for
IDX
. “Information Deemed Reliable But Not Guaranteed”. Copyright 2016 REALTOR® Association of Acadiana, All rights reserved.
Licensed & Regulated in the jurisdiction of the Louisiana Real Estate Commission, Members of the National Association of Realtors®, Louisiana Realtors®, Realtor® Association of Acadiana, Multiple Listing Service (MLS), Louisiana Commercial (www.lacdb.com), The Realtor® Commercial Alliance, Equal Housing Opportunity.