88 LONGWOOD Drive, Mandeville, LA 70471 (MLS# NO2571738)

88 LONGWOOD Drive, Mandeville, LA 70471

New Listing
$775,000
Property Type: Residential Bedrooms: 4 Baths: 4 Square Footage: 4,494 Lot Size (sq. ft.): 15,682 Status: Active
Current Price: $775,000 List Date: 8/13/2026 Last Modified: 8/16/2026

Overview

Description

BEAU CHENE GATED GOLF COMMUNITY - Beautifully appointed 4-bed, 4-full bath home with inground pool/spa. Flood Zone C. Primary bedroom downstairs with optional second 1st-floor bedroom! With its striking architectural character and versatile floor plan, this home offers a wonderful combination of comfort, personality and style. A charming entry welcomes guests with a decorative glass front door, arched transom and staircase. First-floor flex room offers excellent potential for a fifth bedroom, guest suite or home office (current use). The spacious kitchen has abundant cabinetry, granite countertops, a large center island with gas cooktop, stainless appliances and plenty of workspace for everyday living and entertaining. The breakfast area is currently used as an extra informal sitting room. The elegant formal dining room is finished with intricate molding and wainscoting. The main living area is flooded with natural light from a wall of windows and contains convenient built-in cabinetry ...

Listing Details MLS# NO2571738

Listing Info

Delayed Marketing
No
Listing Price
775000
List Price/SqFt
209.86
Type
Single Family Residence
Document Modified
2026-08-15 23:09:02.678612
Modification Timestamp
2026-08-16T04:19:31Z
Photo Modified
2026-08-16T04:19:03Z

Location Tax Legal Info

Street Number
88
Street Name
LONGWOOD Drive
Parish
St. Tammany
State
LA
Zip Code
70471
Subdivision
Beau Chene
Tax Assessment Number
47831
Directions
Bounding Streets: Beau Chene Drive, Tete Lours Drive

General Property Description

# Bedrooms
4
Baths - Full
4
Total Baths
4
SqFt - Living
3693
SqFt - Total
4494
SqFt - Source
Appraiser
Stories
2
Year Built
1991
Acres
0.36
Acreage Range
0 - 0.5
Assn Fee $
265
Assn Fee Terms
Monthly
Lot Dimensions
100 x 140

Originating Details

Originating System ID
ROAMM
Originating System Key
59380949
Originating System Listing ID
2571738
Originating System Name
ROAM Matrix

Location, Tax & Legal Info

Legal Desc
LOT 863 BEAU CHENE CB 1519 298 INST NO 927094 INST NO 1202631 INST NO 1254693 INST NO 1281728 INST NO 1383153 INST NO 1434535 INST NO 1626040

Remarks & Misc

Remarks
BEAU CHENE GATED GOLF COMMUNITY - Beautifully appointed 4-bed, 4-full bath home with inground pool/spa. Flood Zone C. Primary bedroom downstairs with optional second 1st-floor bedroom! With its striking architectural character and versatile floor plan, this home offers a wonderful combination of comfort, personality and style. A charming entry welcomes guests with a decorative glass front door, arched transom and staircase. First-floor flex room offers excellent potential for a fifth bedroom, guest suite or home office (current use). The spacious kitchen has abundant cabinetry, granite countertops, a large center island with gas cooktop, stainless appliances and plenty of workspace for everyday living and entertaining. The breakfast area is currently used as an extra informal sitting room. The elegant formal dining room is finished with intricate molding and wainscoting. The main living area is flooded with natural light from a wall of windows and contains convenient built-in cabinetry and shelving as well as a gas fireplace. Engineered wood flooring throughout main living areas, first floor office/bedroom, and primary bedroom. Multiple living and flex spaces in both first and second stories, which can be used as bedrooms, or 1st and 2nd level office/study areas, provide exceptional lifestyle versatility for family, extended family and guests. The primary suite, complete with tray ceilings, room for sitting area, and a stunning view of the pool, is complemented by a beautifully updated ensuite bathroom featuring a freestanding soaking tub, dual vessel sinks, expansive vanity and elegant tilework. Upstairs, find 3 bedrooms and 2 full baths, plus an impressive entertainment area/media room with vaulted ceilings, built-in shelving and wet bar. Excellent storage throughout home. Outside, the expansive covered patio creates an inviting extension of the living space and overlooks a lush, resort-style private backyard with a sparkling inground pool and spa surrounded by mature landscaping. Large fenced lot leaves plenty of extra room for gardening or other outside hobbies. Two-car attached garage, large driveway allow for generous parking. HOA fee includes garbage pickup (4x per week), sewerage, security, maintenance of common grounds, and mosquito control. Visit www.bchoa.org for Covenants and Restrictions.

More Information

Office/Member/Contract Info

List AOR
NOMAR

Style

Traditional
Yes

Siding

Stucco
Yes

Parking

Attached
Yes
Garage
Yes

Construction

Brick
Yes

Foundation

Slab
Yes

Patio

Covered
Yes

Fireplace

Gas Log
Yes

Roof

Composition
Yes

Heating

Central
Yes

Cooling

2 or More Units
Yes
Central Air
Yes

Countertops

Granite
Yes

Rooms

Bedroom 1
Yes
Dining Room
Yes
Foyer
Yes
Kitchen
Yes
Laundry
Yes
Living Room
Yes
Primary Bedroom
Yes
Office
Yes
Bedroom 2
Yes
Bedroom 3
Yes
Bedroom 4
Yes
Bedroom 5
Yes
Bedroom 6
Yes

Amenities

Gated Community
Yes

Fencing

Full
Yes

Pool

Inground
Yes

Property Features

Style: Traditional Siding: Stucco Parking: Attached; Garage Construction: Brick Foundation: Slab Roof: Composition Fireplace: Gas Log Heating: Central Cooling: 2 or More Units; Central Air Countertops: Granite Rooms: Bedroom 1; Dining Room; Foyer; Kitchen; Laundry; Living Room; Office; Primary Bedroom; Bedroom 2; Bedroom 3; Bedroom 4; Bedroom 5; Bedroom 6 Fencing: Full Patio: Covered Amenities: Gated Community Pool: Inground

Room Information

Room Name Length Width Remarks
Dining Room 15.30 13.30 Dining Room
Dining Room 15.30 13.30 Dining Room
Bedroom 1 13.70 15.10 Bedroom
Bedroom 2 13.70 15.10 Bedroom
Foyer 10.50 8.70 Foyer
Foyer 10.50 8.70 Foyer
Primary Bedroom 16.90 15.30 Primary Bedroom
Primary Bedroom 16.90 15.30 Primary Bedroom
Kitchen 16.40 13.60 Kitchen
Kitchen 16.40 13.60 Kitchen
Laundry 8.60 6.40 Laundry
Laundry 8.60 6.40 Laundry
Office 13.00 13.10 Office
Office 13.00 13.10 Office
Bedroom 3 14.10 13.60 Bedroom
Bedroom 4 14.10 13.60 Bedroom
Living Room 18.80 14.40 Living Room
Living Room 18.80 14.40 Living Room
Bedroom 5 14.10 13.60 Bedroom
Bedroom 6 14.10 13.60 Bedroom
IDX
Listing Office: Keller Williams Realty Services
Last Updated: August - 16 - 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.