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
...
(Read more)
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.
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 |
Documents
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.

New Attachment ›