88 Longwood Dr, Mandeville, LA 70471
- $775,000
- 4
- BD
- 4
- BA
- 3,693
- SqFt
- List Price
- $775,000
- MLS#
- 2571738
- Status
- ACTIVE
- Type
- Single Family Residential
- Style
- Traditional
- Stories
- 2
- Bedrooms
- 4
- Bathrooms
- 4
- Acres
- 0.36
- Living Area
- 3,693
- Parish
- St Tammany
- Subdivision
- Beau Chene
Property Description
BEAU CHÊNE 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.
/u.realgeeks.media/thescoggingroup/scoggin-properties.jpg)
Additional Information
- Hoa Fee
- $265
- Roof
- Shingle
- Sewer
- Public Sewer
- Water
- Public
- Pool Description
- In Ground
- Heating
- Central, Multiple Heating Units
- Cooling
- Central Air, Multi Units
- Elementary School
- www.stpsb.org
- Middle School
- www.stpsb.org
- High School
- www.stpsb.org
Mortgage Calculator
Participants, subscribers, and all users acknowledge that the information contained in the Multiple Listings Service is owned by the New Orleans Metropolitan Association of REALTORS®, Inc. and no user may, nor may they authorize or allow anyone to, download the active listings, sold listing data, or other information contained in the MLS for the recommercialization (resale) or for any purpose not authorized in writing by the New Orleans Metropolitan Association of REALTORS®, Inc. or the Gulf South Real Estate Information Network, Inc. Copyright 2026, New Orleans Metropolitan Association of REALTORS®, Inc. All rights reserved. Information deemed reliable, but not verified or guaranteed. Users are responsible for checking the accuracy, completeness, currency, and status of all information. The sharing of MLS database, or any portion thereof, with any unauthorized third party is strictly prohibited. Information contained on this site is believed to be reliable; yet, users of this web site are responsible for checking the accuracy, completeness, currency, or suitability of all information. Neither the New Orleans Metropolitan Association of REALTORS®, Inc. nor the Gulf South Real Estate Information Network, Inc. makes any representation, guarantees, or warranties as to the accuracy, completeness, currency, or suitability of the information provided. They specifically disclaim any and all liability for all claims or damages that may result from providing information to be used on the web site, or the information which it contains, including any web sites maintained by third parties, which may be linked to this web site. The information being provided is for the consumer’s personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties which consumers may be interested in purchasing. The user of this site is granted permission to copy a reasonable and limited number of copies to be used in satisfying the purposes identified in the preceding sentence. By using this site, you signify your agreement with and acceptance of these terms and conditions. If you do not accept this policy, you may not use this site in any way. Your continued use of this site, and/or its affiliates’ sites, following the posting of changes to these terms will mean you accept those changes, regardless of whether you are provided with additional notice of such changes. Listing data provided by GSREIN. Listing data is deemed accurate but not guaranteed. Other Broker's Listing.