We Purchase, Trade, Consult & Market Residential & Commercial Real Estate

  • About
  • Contact
  • Careers
  • 337-984-4345
Guidry and Company Real EstateGuidry and Company Real EstateGuidry and Company Real EstateGuidry and Company Real Estate
  • 337-984-4345
  • Home
  • Buyers
    • Looking to Buy?
    • Featured Listings
    • Homes for Sale
    • COMMERCIAL LISTINGS: Business Opportunity, Industrial, Office, Restaurant/Lounge, Shopping Center, Hotel/Motel, Medical/Dental or Retail
    • LAND LISTINGS: Commercial, Industrial, Residential, Farm or Timberland
    • Buyers Guidebook
    • Choose Your Realtor
    • Why Choose Us
  • Sellers
    • Why Choose Us
  • Services
    • Consultation Services
    • Inherited Land
  • Who’s Your REALTOR®?
  • Success Coaching
  • Blog
  • Reviews

$775,000
88 LONGWOOD Drive
Mandeville, LA 70471
MLS# NO2571738
4 beds  |  4 baths  |  4494 sqft


Photo 1
  1 / 47  
Photo 1 Photo 2 Photo 3 Photo 4 Photo 5 Photo 6 Photo 7 Photo 8 Photo 9 Photo 10 Photo 11 Photo 12 Photo 13 Photo 14 Photo 15 Photo 16 Photo 17 Photo 18 Photo 19 Photo 20 Photo 21 Photo 22 Photo 23 Photo 24 Photo 25 Photo 26 Photo 27 Photo 28 Photo 29 Photo 30 Photo 31 Photo 32 Photo 33 Photo 34 Photo 35 Photo 36 Photo 37 Photo 38 Photo 39 Photo 40 Photo 41 Photo 42 Photo 43 Photo 44 Photo 45 Photo 46 Photo 47

Property Description
BEAU CHENE GATED GOLF COMMUNITY - Beautifully appointed 4-bed, 4-full bath home with inground pool/spa. Flood Zone C. NEW LVP FLOORING JUST INSTALLED UPSTAIRS - New upper story photos coming soon! New carpet on stairs! 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. Expansive covered patio creates an inviting extension of the living space and overlooks a lush, resort-style private backyard with sparkling inground pool and spa surrounded by mature landscaping. Large fenced lot leaves ample extra room for gardening and outside hobbies. Two-car attached garage, large driveway allow for generous parking. PLEASE NOTE: Car charging connection is being removed prior to sale and owner will have it capped off. 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. In some rooms, furniture has been virtually removed using AI.

Details
Documents
Listing Info
Status: Active
Listing Date: 2026-08-13
Delayed Marketing: No
Listing Price: 775000
Current Price: $775,000
List Price/SqFt: 209.86
Type: Single Family Residence
Document Modified: 2026-08-15 23:09:02.678612
Modification Timestamp: 2026-09-13T23:00:24Z
Photo Modified: 2026-09-13T22:59:58Z
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
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
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; Bedroom 7; Bedroom 8
Fencing: Full
Patio: Covered
Amenities: Gated Community
Pool: Inground
Room Information
Room Name Length Width Remarks
Bedroom 113.7015.10Bedroom
Dining Room15.3013.30Dining Room
Dining Room15.3013.30Dining Room
Dining Room15.3013.30Dining Room
Dining Room15.3013.30Dining Room
Dining Room15.3013.30Dining Room
Dining Room15.3013.30Dining Room
Bedroom 213.7015.10Bedroom
Bedroom 313.7015.10Bedroom
Foyer10.508.70Foyer
Foyer10.508.70Foyer
Foyer10.508.70Foyer
Foyer10.508.70Foyer
Foyer10.508.70Foyer
Foyer10.508.70Foyer
Office13.0013.10Office
Office13.0013.10Office
Office13.0013.10Office
Office13.0013.10Office
Office13.0013.10Office
Office13.0013.10Office
Primary Bedroom16.9015.30Primary Bedroom
Primary Bedroom16.9015.30Primary Bedroom
Primary Bedroom16.9015.30Primary Bedroom
Primary Bedroom16.9015.30Primary Bedroom
Primary Bedroom16.9015.30Primary Bedroom
Primary Bedroom16.9015.30Primary Bedroom
Kitchen16.4013.60Kitchen
Kitchen16.4013.60Kitchen
Kitchen16.4013.60Kitchen
Kitchen16.4013.60Kitchen
Kitchen16.4013.60Kitchen
Kitchen16.4013.60Kitchen
Bedroom 413.7015.10Bedroom
Living Room18.8014.40Living Room
Living Room18.8014.40Living Room
Living Room18.8014.40Living Room
Living Room18.8014.40Living Room
Living Room18.8014.40Living Room
Living Room18.8014.40Living Room
Laundry8.606.40Laundry
Laundry8.606.40Laundry
Laundry8.606.40Laundry
Laundry8.606.40Laundry
Laundry8.606.40Laundry
Laundry8.606.40Laundry
Bedroom 514.1013.60Bedroom
Bedroom 614.1013.60Bedroom
Bedroom 714.1013.60Bedroom
Bedroom 814.1013.60Bedroom
Listing Documents
View Document New Attachment
View Document New Attachment

IDX
Listing Office: Keller Williams Realty Services

Last Updated: September - 13 - 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.


Search powered by FBS Products

Find Us

Get Directions
 

1232-A Camellia Blvd.
Lafayette, LA 70508
P: 337-984-4345

 

AGENT ON CALL | 337-446-6053

 

CALL US: 337-984-4345

 

GUIDRY & CO. REAL ESTATE, Lafayette, LA. All offices are independently owned and operated. 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 GUIDRY & CO. REAL ESTATE are marked with the MLS approved icon for IDX. “Information Deemed Reliable But Not Guaranteed”. Copyright 2016 REALTOR® Association of Acadiana, All rights reserved.

Licensed & Regulated in the jurisdiction of the Louisiana Real Estate Commission, Members of the National Association of Realtors®, Louisiana Realtors®, Realtor® Association of Acadiana, Multiple Listing Service (MLS), Louisiana Commercial (www.lacdb.com), The Realtor® Commercial Alliance, Equal Housing Opportunity.

  • Home
  • 337-984-4345
  • Buyers
    • Looking to Buy?
    • Featured Listings
    • Homes for Sale
    • COMMERCIAL LISTINGS: Business Opportunity, Industrial, Office, Restaurant/Lounge, Shopping Center, Hotel/Motel, Medical/Dental or Retail
    • LAND LISTINGS: Commercial, Industrial, Residential, Farm or Timberland
    • Buyers Guidebook
    • Choose Your Realtor
    • Why Choose Us
  • Sellers
    • Why Choose Us
  • Services
    • Consultation Services
    • Looking to Buy?
    • Inherited Real Estate?
    • Choose Your REALTOR®
  • Blog
  • Success Coaching
  • Who’s Your REALTOR®?
  • Careers
  • About Guidry & Co. Real Estate
  • Contact Us
  • Reviews
Guidry and Company Real Estate
Thank you for visiting Guidry & Co. Real Estate, for more information please register here:

"*" indicates required fields

This field is for validation purposes and should be left unchanged.
Name*

 

Return To Homepage