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

Agent on Call

agent

Candice Scriber, REALTOR® Sales Associate
337-277-6503


$645,000
787 CLAIRE Drive
Mandeville, LA 70471
MLS# NO2578227
5 beds  |  3 baths  |  3753 sqft


Photo 1
  1 / 33  
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

Property Description
Beautifully appointed 5-bedroom, 3-bath home in the highly desirable Beau West neighborhood. Soaring 10' to 12' ceilings give every room an open, airy feel, complemented by modern lighting and designer finishes throughout. Downstairs, hardwood and brick-tiled floors set the tone, with an abundance of large windows framing pool views throughout the main living space. The updated kitchen features quartz countertops, new dishwasher, new gas cooktop, new built-in microwave, and new Wifi enabled smart oven, ready for everyday meals and entertaining alike. Adjacent to the kitchen is both a breakfast area and a keeping room. A gas fireplace anchors the living room, and indoor surround sound adds to the home's entertaining appeal. A generous laundry room adds real day-to-day function, and upstairs, the fifth bedroom offers flexible space that could also be used as a home office, playroom, or workout room. Outside, enjoy a covered back patio overlooking the heated pool and hot tub, all within a fully fenced rear yard and established landscaping for privacy and easy living. Move-in ready and thoughtfully updated in a sought-after location -- schedule your showing today. Roof is 4 years young! Outdoor kitchen is movable and not included

Details
Documents
Listing Info
Status: Active
Listing Date: 2026-10-01
Delayed Marketing: No
Listing Price: 645000
Current Price: $645,000
List Price/SqFt: 212.17
Type: Single Family Residence
Document Modified: 2026-10-01 08:44:46.095761
Modification Timestamp: 2026-10-11T16:23:03Z
Photo Modified: 2026-10-01T13:39:43Z
General Property Description
# Bedrooms: 5
Baths - Full: 3
Total Baths: 3
SqFt - Living: 3040
SqFt - Total: 3753
SqFt - Source: Appraiser
Stories: 2
Year Built: 2002
Acreage Range: 0 - 0.5
Assn Fee $: 425
Assn Fee Terms: Yearly
Lot Dimensions: 90x125
Originating Details
Originating System ID: ROAMM
Originating System Key: 59826449
Originating System Listing ID: 2578227
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 787
Street Name: CLAIRE Drive
Parish: St. Tammany
State: LA
Zip Code: 70471
Subdivision: Beau West
Tax Assessment Number: 60793
Directions: From Highway 22, turn onto Beau West Boulevard, turn right onto Claire Drive. Home is on the left. Bounding Streets: Beau West Boulevard
Property Features
Style: French
Siding: Stucco
Parking: Garage
Construction: Brick; Other
Foundation: Slab
Roof: Composition
Fireplace: Gas Log
Heating: Central
Cooling: 2 or More Units; Central Air
Appliances: Dishwasher
Rooms: Bedroom 1; Dining Room; Kitchen; Living Room; Primary Bedroom; Bedroom 2; Bedroom 3; Bedroom 4
Fencing: Full; Wood; Other
Patio: Covered
Other Structures: Workshop
Pool: Inground
Room Information
Room Name Remarks
Bedroom 1Bedroom
Primary BedroomPrimary Bedroom
Dining RoomDining Room
Bedroom 2Bedroom
KitchenKitchen
Bedroom 3Bedroom
Living RoomLiving Room
Bedroom 4Bedroom
Listing Documents
View Document 787 Claire Drive - Flood Declarations
View Document 787 Claire Drive - Property, WOW, LBP &
View Document 787 Claire Drive - Updates and Property
View Document 787 Claire Drive - Floorplan
View Document 787 Claire Drive - Survey

IDX
Listing Office: Coldwell Banker TEC

Last Updated: October - 11 - 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-277-6503

 

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