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
    • Professional Development
  • Who’s Your REALTOR®?
  • Blog
  • Reviews

Agent on Call

Andrea Laborde REALTOR® Sales Associate
337-277-6503


$649,000
204 LEGENDRE Drive
Slidell, LA 70460
MLS# NO2542888
4 beds  |  3.1 baths  |  6972 sqft


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

Property Description
Stunning waterfront home on Bayou Bonfouca, offering direct access to Lake Pontchartrain in minutes. With 155 feet of waterfront, a 95-foot dock, and your own private boat launch, everyday life here can include sunset boat rides, fishing or crabbing from your dock, and peaceful evenings watching wildlife drift along the bayou. Inside, the home is designed for both comfort and entertaining. The gourmet kitchen features a large island, matching quartz countertops, soft-close Thomasville cabinetry, stainless appliances, and double ovens, making it the natural gathering place after a day on the water. The home offers three private suites, including a spacious upstairs retreat with cathedral ceilings, exposed beams, and its own sitting area. A large flex room provides space for a game room, office, or media room. Following a rebuild, the home was wrapped in Structural Insulated Panels (SIPS)--an approximately $43,000 upgrade designed for exceptional strength and energy efficiency while helping reduce heating and cooling costs. The kitchen was so impressive that Home Depot showcased the home as a cabinet display reference for nearly two years. Recent improvements include engineered wood plank flooring (2020), new refrigerator and dishwasher (2025), updated front entry steps and porch fan (2025), and a touch-activated kitchen faucet with lifetime warranty. Systems have been professionally maintained with HVAC, plumbing, and electrical inspections completed in 2025. The home also features a metal roof, stainless appliances, and approximately 3,000 sq ft of ground-level garage / usable storage space with rear yard vehicle access. Enjoy the views from the screened porch overlooking the oversized ground-level patio, and take advantage of an assumable flood insurance policy currently around $1,036 per year. A rare opportunity to own a waterfront home that combines location, lifestyle, and thoughtful construction.

Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 169.27
Document Modified: 2026-03-18 19:51:11.959432
Status: Active
Listing Date: 2026-03-09
Listing Price: 649000
Current Price: $649,000
Type: Single Family Residence
Modification Timestamp: 2026-03-19T00:51:31Z
Photo Modified: 2026-03-19T00:51:14Z
Location, Tax & Legal Info
Legal Desc: LOT 7 SQ 2 COIN DU LESTIN ADD 2 CB 894 465 INST NO 1011887 INST NO 1263668 INST NO 1412181 INST NO 1749466 INST NO 1871872
General Property Description
Lot Dimensions: 60 x 225 x 154 x 193
Stories: 2
SqFt - Living: 3834
SqFt - Source: Appraiser
SqFt - Total: 6972
Assn Fee $: 150
Assn Fee Terms: Yearly
Acreage Range: 0 - 0.5
Pool on Subject Property: No
# Bedrooms: 4
Baths - Full: 3
Baths - 1/2: 1
Total Baths: 3.1
Year Built: 2014
Acres: 0.5
Remarks & Misc
Remarks: Stunning waterfront home on Bayou Bonfouca, offering direct access to Lake Pontchartrain in minutes. With 155 feet of waterfront, a 95-foot dock, and your own private boat launch, everyday life here can include sunset boat rides, fishing or crabbing from your dock, and peaceful evenings watching wildlife drift along the bayou. Inside, the home is designed for both comfort and entertaining. The gourmet kitchen features a large island, matching quartz countertops, soft-close Thomasville cabinetry, stainless appliances, and double ovens, making it the natural gathering place after a day on the water. The home offers three private suites, including a spacious upstairs retreat with cathedral ceilings, exposed beams, and its own sitting area. A large flex room provides space for a game room, office, or media room. Following a rebuild, the home was wrapped in Structural Insulated Panels (SIPS)--an approximately $43,000 upgrade designed for exceptional strength and energy efficiency while helping reduce heating and cooling costs. The kitchen was so impressive that Home Depot showcased the home as a cabinet display reference for nearly two years. Recent improvements include engineered wood plank flooring (2020), new refrigerator and dishwasher (2025), updated front entry steps and porch fan (2025), and a touch-activated kitchen faucet with lifetime warranty. Systems have been professionally maintained with HVAC, plumbing, and electrical inspections completed in 2025. The home also features a metal roof, stainless appliances, and approximately 3,000 sq ft of ground-level garage / usable storage space with rear yard vehicle access. Enjoy the views from the screened porch overlooking the oversized ground-level patio, and take advantage of an assumable flood insurance policy currently around $1,036 per year. A rare opportunity to own a waterfront home that combines location, lifestyle, and thoughtful construction.
Office/Member/Contract Info
List AOR: NOMAR
Style
Traditional: 1
Siding
Hardiplank: 1
Parking
Garage: 1
RV Access/Parking: 1
Foundation
Piers: 1
Exterior
Balcony: 1
Patio
Covered: 1
Roof
Metal: 1
Heating
Central: 1
Interior
Cathedral Ceiling: 1
Vaulted Ceilings: 1
Cooling
2 or More Units: 1
Central Air: 1
Appliances
Dishwasher: 1
Disposal: 1
Dryer: 1
Microwave: 1
Refrigerator: 1
Washer: 1
Rooms
Bedroom 1: 1
Den: 1
Dining Room: 1
Kitchen: 1
Laundry: 1
Living Room: 1
Primary Bedroom: 1
Game Room: 1
Bedroom 2: 1
Bedroom 3: 1
Waterfront
Bayou/River: 1
Dock/Mooring: 1
Lot
Water Frontage: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 57038106
Originating System Listing ID: 2542888
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 204
Street Name: LEGENDRE Drive
Parish: St. Tammany
State: LA
Zip Code: 70460
Subdivision: Coin Du Lestin
Tax Assessment Number: 105306
Directions: From Hwy 433, turn left onto Nunez Rd. Then, turn left onto Laurent Rd. Then, turn right on Legendre Dr. House is on the left. Bounding Streets: Laurent Road and Nunez Road
Property Features
Style: Traditional
Siding: Hardiplank
Parking: Garage; RV Access/Parking
Foundation: Piers
Roof: Metal
Interior: Cathedral Ceiling; Vaulted Ceilings
Heating: Central
Cooling: 2 or More Units; Central Air
Appliances: Dishwasher; Disposal; Dryer; Microwave; Refrigerator; Washer
Rooms: Bedroom 1; Den; Dining Room; Kitchen; Laundry; Living Room; Primary Bedroom; Game Room; Bedroom 2; Bedroom 3
Lot: Water Frontage
Patio: Covered
Exterior: Balcony
Waterfront: Bayou/River; Dock/Mooring
Room Information
Room Name Length Width Remarks
Primary Bedroom15.7012.50Primary Bedroom
Dining Room11.5010.90Dining Room
Bedroom 117.6017.30Bedroom
Bedroom 210.9010.30Bedroom
Bedroom 317.8010.10Bedroom
Laundry11.105.90Laundry
Den44.5012.10Den
Kitchen15.9012.70Kitchen
Living Room19.3018.30Living Room
Game Room15.7013.50Game Room
Listing Documents
View Document Property Disclosures
View Document Flood Insurance
View Document Waiver of Warranty and Redhibition Right
View Document Deposit Addendum
View Document 204 Legendre - GoogleEarth Details

IDX
Listing Office: Keller Williams Realty Services

Last Updated: March - 19 - 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®
    • Professional Development
  • Blog
  • 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