23123 HIGHWAY 1088, Mandeville, LA 70448 (MLS# NO2525973)

23123 HIGHWAY 1088, Mandeville, LA 70448

$989,000
Property Type: Residential Bedrooms: 4 Baths: 3.1 Square Footage: 5,468 Lot Size (sq. ft.): 259,182 Status: Active
Current Price: $989,000 List Date: 10/13/2025 Last Modified: 2/03/2026

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!

Supplements: ********

More Information MLS# NO2525973

Listing Info

Delayed Marketing: No List Price/SqFt: 269.12 Document Modified: 2026-02-03 09:49:07.507747 Status: Active Listing Date: 2025-10-13 Listing Price: 989000 Current Price: $989,000 Type: Single Family Residence Modification Timestamp: 2026-02-03T15:54:12Z Photo Modified: 2026-02-03T15:54:12Z

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

Bedroom 1 Length: 11.62 Width: 11.45 Remarks: Bedroom Dining Room Length: 12.00 Width: 12.00 Remarks: Dining Room Primary Bedroom Length: 16.09 Width: 15.33 Remarks: Primary Bedroom Bedroom 2 Length: 11.33 Width: 12.12 Remarks: Bedroom Bedroom 3 Length: 11.09 Width: 14.33 Remarks: Bedroom Living Room Length: 19.50 Width: 23.00 Remarks: Living Room
Listing Office: Select Realty Group, LLC
IDX
Last Updated: February - 03 - 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.