209 Big Lake Run, Youngsville, LA 70592 (MLS# 2600005524)

209 Big Lake Run, Youngsville, LA 70592

$515,000
Property Type: Residential Bedrooms: 4 Baths: 3 Square Footage: 2,448 Lot Size (sq. ft.): 7,841 Status: Coming Soon - No Showings
Current Price: $515,000 List Date: 6/17/2026 Last Modified: 6/24/2026

Overview

Description

Get ready to fall in love with this beautiful lakefront home offering the perfect mix of quality, comfort, and charm. With 4 bedrooms, 3 bathrooms, a spacious single story layout, and soaring cathedral ceilings, this one is designed to impress from the moment you walk in. The chef's kitchen is a dream with custom cabinetry, solid surface countertops, a 36' apron front sink, refrigerator and a gas range. The private primary suite offers peaceful lake views, separate vanities, a soaking tub, custom tiled shower, and a fully customized oversized closet. Step outside and enjoy year round outdoor living with a full grilling kitchen, a second gas fireplace, and stunning sunset views over the water. Even more to love, this home also includes custom power blinds in the living room and primary suite, blinds and curtains throughout, French drains, gutters, the 2 cabinets and mirrors beside the fireplace, playset, washer, and dryer.

Listing Details MLS# 2600005524

Listing Info

Delayed Marketing
No
Listing Price
515000
List Price/SqFt
210.38
Type
Single Family Residence
Property Attached
No
Document Modified
2026-06-23 16:10:17.039528
Modification Timestamp
2026-06-24T20:20:02Z
Photo Modified
2026-06-23T21:22:50Z

Location Tax Legal Info

Street Number
209
Street Name
Big Lake
St Suffix
Run
Parish
Lafayette
State
LA
Zip Code
70592
Subdivision
Detente Lakes
Area
P
Tax Assessment Number
6168137
Elementary School
Ernest Gallet
Middle School
Youngsville
High School
Southside
Directions
Verot South to round a bout left on Hwy 92 right on Chemin Metairie towards Sugar Mill Pond past the sports complex right on Detente Road left into Detente Lakes onto Big Lake Run. House on the left on the pond

General Property Description

# Bedrooms
4
Baths - Full
3
Total Baths
3
SqFt - Living
2448
SqFt - Source
Approximate
Stories
Yes
Approximate Age
1 - 3 Years
Property Condition
Resale
Condition
Very Good
Acres
0.18
Acreage Range
0 - 0.5
Assn Fee
Required
Assn Fee $
500
Assn Fee Terms
Yearly
Lot Dimensions
60X135
Mineral Rights
Reserved
Pool on Subject Property
No

Parking

Garage Spaces
2
Attached
Yes
Garage
Yes
Garage Faces Front
Yes

Water Source

Water Company
Youngsville
Public
Yes

Originating Details

Originating System ID
M00000300
Originating System Key
20260618194530094530
Originating System Listing ID
2600005524
Originating System Name
RAA Flex

More Information

Location, Tax & Legal Info

Flood Zone
X & AE
School District
Lafayette Parish
Legal Desc
LOT L-76 DETENTE LAKES Subdivision Lafayette Parish Louisiana

Remarks & Misc

Remarks
Get ready to fall in love with this beautiful lakefront home offering the perfect mix of quality, comfort, and charm. With 4 bedrooms, 3 bathrooms, a spacious single story layout, and soaring cathedral ceilings, this one is designed to impress from the moment you walk in. The chef's kitchen is a dream with custom cabinetry, solid surface countertops, a 36' apron front sink, refrigerator and a gas range. The private primary suite offers peaceful lake views, separate vanities, a soaking tub, custom tiled shower, and a fully customized oversized closet. Step outside and enjoy year round outdoor living with a full grilling kitchen, a second gas fireplace, and stunning sunset views over the water. Even more to love, this home also includes custom power blinds in the living room and primary suite, blinds and curtains throughout, French drains, gutters, the 2 cabinets and mirrors beside the fireplace, playset, washer, and dryer.

Office/Member/Contract Info

REO
No

Style

Farmhouse
Yes

Siding

Brick
Yes
Hardiplank
Yes

Equipment

Cable Ready
Yes

Road Frontage

City Street
Yes
Paved
Yes

Construction

Frame
Yes

Foundation

Slab
Yes

Exterior

Gas/Propane Grill
Yes
Outside Kitchen
Yes
Outside Light
Yes

Patio

Porch
Yes
Covered
Yes

Fireplace

Fireplace
Yes
2 Fireplaces
Yes
Gas
Yes
Ventless
Yes

Roof

Composition
Yes

Heating

Central
Yes
Natural Gas
Yes

Interior

9+ Ft Ceiling
Yes
Beamed Ceilings
Yes
Cathedral Ceiling
Yes
Crown Molding
Yes
Double Vanity
Yes
Electric Dryer Con
Yes
Electric Washer Con
Yes
Gas Stove Con
Yes
Kitchen Island
Yes
Primary Bath
Yes
Separate Shower
Yes
Standalone Tub
Yes
Varied Ceiling Heights
Yes
Vaulted Ceilings
Yes
Walk-In Closet(s)
Yes
Window Treatments
Yes

Cooling

Central Air
Yes

Flooring

Tile
Yes
Vinyl Plank
Yes

Sewer

Public Sewer
Yes

Appliances

Dishwasher
Yes
Disposal
Yes
Gas Range
Yes
Microwave
Yes
Refrigerator
Yes

Utilities

Elec: SLEMCO
Yes
Gas: Delta Utilities
Yes

Countertops

Butcher Block
Yes
Quartz
Yes
Solid Surface
Yes

Waterfront

Frontage
Yes
Pond
Yes
View
Yes
Walk To
Yes

Documents

Property Disclosure
Yes

Amenities

Playground
Yes

Security Features

Carbon Monoxide Detector(s)
Yes
Smoke Detector(s)
Yes

Fencing

Wood
Yes
Other
Yes

Lot

Level
Yes
Views
Yes
Water Frontage
Yes

Window Features

Double Pane Windows
Yes

Financing

Cash
Yes
Conventional
Yes
FHA
Yes
VA
Yes

Reserved Item

Refrigerator
Yes

HOA Includes

Accounting
Yes
Management
Yes

Property Features

Style: Farmhouse Siding: Brick; Hardiplank Parking: Attached; Garage; Garage Faces Front Construction: Frame Foundation: Slab Road Frontage: City Street; Paved Roof: Composition Interior: 9+ Ft Ceiling; Beamed Ceilings; Cathedral Ceiling; Crown Molding; Double Vanity; Electric Dryer Con; Electric Washer Con; Gas Stove Con; Kitchen Island; Primary Bath; Separate Shower; Standalone Tub; Varied Ceiling Heights; Vaulted Ceilings; Walk-In Closet(s); Window Treatments Fireplace: 2 Fireplaces; Gas; Fireplace; Ventless Flooring: Tile; Vinyl Plank Heating: Central; Natural Gas Cooling: Central Air Appliances: Dishwasher; Disposal; Gas Range; Microwave; Refrigerator Countertops: Butcher Block; Quartz; Solid Surface Security Features: Carbon Monoxide Detector(s); Smoke Detector(s) Fencing: Wood; Other Lot: Level; Views; Water Frontage Patio: Covered; Porch Amenities: Playground Exterior: Gas/Propane Grill; Outside Kitchen; Outside Light Window Features: Double Pane Windows Waterfront: Frontage; Pond; View; Walk To Sewer: Public Sewer Water Source: Public Utilities: Elec: SLEMCO; Gas: Delta Utilities HOA Includes: Accounting; Management Reserved Item: Refrigerator Financing: Cash; Conventional; FHA; VA Documents: Property Disclosure; Property Disclosure
IDX
Listing Office: Compass
Last Updated: June - 24 - 2026
Broker Attribution: 337-233-9700

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.