88 Longwood Drive Dr, Mandeville, LA 70471 (MLS # NO2571738)
|
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.
| DAYS ON MARKET | 4 | LAST UPDATED | 8/15/2026 |
|---|---|---|---|
| TRACT | Beau Chene | YEAR BUILT | 1991 |
| COUNTY | St. Tammany | STATUS | Active |
| PROPERTY TYPE(S) | Single Family |
| ADDITIONAL DETAILS | |
| AIR | Central Air, Multi Units |
|---|---|
| AIR CONDITIONING | Yes |
| CONSTRUCTION | Brick, Stucco |
| FIREPLACE | Yes |
| GARAGE | Attached Garage, Yes |
| HEAT | Central |
| HOA DUES | 265 |
| INTERIOR | Entrance Foyer, Granite Counters |
| LOT | 0.36 acre(s) |
| LOT DIMENSIONS | 100 x 140 |
| PARKING | Attached, Garage |
| POOL DESCRIPTION | In Ground |
| STORIES | 2 |
| STYLE | Traditional |
| SUBDIVISION | Beau Chene |
MORTGAGE CALCULATOR
TOTAL MONTHLY PAYMENT
0
P
I
*Estimate only
Listed with Keller Williams Realty Services
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 Dwight Andrus Real Estate Agency, LLC are marked with the MLS approved icon for IDX (a little black house).
IDX information is provided exclusively for consumers’ personal, non-commercial use, that it 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.
Copyright 2026 REALTOR® Association of Acadiana MLS. All rights reserved
This IDX solution is (c) Diverse Solutions 2026.
| SATELLITE VIEW |
| / | |
We respect your online privacy and will never spam you. By submitting this form with your telephone number
you are consenting for Matt
Andrus to contact you even if your name is on a Federal or State
"Do not call List".
