Property Attributes
- MLS#2600008260
- TypeSingle Family
- Listing Status Active
- ParishLafayette
- CityYoungsville
- AreaP
- NeighborhoodDetente Lakes
- Zip70592
- StyleTraditional
- Year Built2006
- Price$ 564,200
- Bedrooms4
- Full Bathrooms3
- Half Bathrooms0
- Sqr Footage2606
- Lot Size0.19 Acres
Data Source:
REALTOR® Association of Acadiana (LBRMLS)
Property Description
Lakefront Living in Youngsville! Quality and charm greet you the moment you step inside this beautiful 4-bedroom, 3-bath single-story home. The well-planned 3-way split, open floor plan offers three spacious guest bedrooms, a large open dining area, walk-in pantry, and a laundry room complete with sink and abundant storage. The kitchen blends beauty and function with a gas range, quartz countertops, and custom cabinetry, all overlooking the great room and its stunning lake view. The private master suite is a true retreat, featuring a unique ceiling treatment, dual vanities with a linen cabinet, freestanding soaking tub, custom-tiled shower, private toilet closet, and an oversized walk-in closet. Step outside to your own outdoor living and grilling kitchen, complete with a fireplace to soak in the gorgeous lake views--perfect for relaxing or entertaining year-round.
| Elementary School | Middle School | High School |
|---|---|---|
| G T Lindon Elementary School | Youngsville Middle School | Southside High School |
| Price History | |
|---|---|
| 9/2/2026 | Listed $564,200 |
General Features
| Road Frontage Type | City Street,Paved |
|---|---|
| Association Amenities | Management |
| Sewer | Public Sewer |
| Heating | Central,Natural Gas |
| Cooling | Central Air |
| Roof | Composition |
| Appliances | Dishwasher,Disposal,Gas Range,Microwave,Gas Stove Con |
| HOA Fee | 500 |
| Gas Y/N | Gas: Delta Utilities |
| Patio/Porch Features | Covered |
| Architectural Style | Traditional |
| Construction Materials | Brick Veneer,HardiPlank Type,Frame |
| Year Built | 2006 |
| Electric | Elec: SLEMCO |
| Stories Count | 1 |
| Property Subtype | Single Family Residence |
| Waterfront Features | Pond |
| Community Features | Other |
| Assoc Fee Paid Per | Annually |
| County | Lafayette |
| New Construction | true |
| Property Type | Residential |
| HOA | true |
| Subdivision Name | Detente Lakes |
| Garage Y/N | true |
| Full Baths | 3 |
| Status | Active |
| 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 right. |
| City | Youngsville |
| High School District | Lafayette Parish |
| MLS Area | P |
| Lot Size Square Feet | 8276.4 |
| Carport Y/N | false |
| Home Warranty Y/N | false |
| Property Condition | New Construction |
| Living Area Units | Square Feet |
| Builder Name | Heritage/L.R. Mitchell |
| Standard Status | Active |
| Middle/Junior School District | Lafayette Parish |
| Elementary School District | Lafayette Parish |
| Legal Description | Lot 19 Detente Lakes Subdivision Lafayette Parish Louisiana |
Interior Features
| Interior Amenities | High Ceilings,Beamed Ceilings,Built-in Features,Crown Molding,Double Vanity,Kitchen Island,Separate Shower,Varied Ceiling Heights,Walk-in Pantry,Walk-In Closet(s),Granite Counters,Quartz Counters,Solid Surface Counters |
|---|---|
| Flooring | Tile,Wood Laminate |
| Fireplace Features | 2 Fireplaces,Gas,Factory Built,Ventless |
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Window Features | Double Pane Windows |
| Fireplace Y/N | true |
| Total Bedrooms | 4 |
| LivingAreaSource | Plans |
| Total Baths | 3 |
Exterior Features
| Exterior Amenities | Outdoor Kitchen,Lighting |
|---|---|
| Parking Features | Attached,Garage,Garage Faces Front |
| Lot Features | 0 to 0.5 Acres,Landscaped,Views,Waterfront |
| Total Parking | 2 |
| Lot Size Area | 8276.4 |
| Foundation Details | Slab |
| Lot Dimensions | 60 x 135 |
| Lot Size Acres | 0.19 |
| Waterfront Y/N | true |
| Horse Y/N | false |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
The data relating to real estate for sale on this website comes in part from the IDX Program of the REALTOR Association of Acadiana MLS. This IDX information is provided exclusively for consumer's personal, non-commercial use. It 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.
Copyright © 2026 REALTOR® Association of Acadiana MLS. All rights rese