Property Attributes
- MLS#2600004473
- TypeSingle Family
- Listing Status Active
- ParishLafayette
- CityYoungsville
- AreaP
- NeighborhoodDetente Lakes
- Zip70592
- StyleModern Farm House
- Year Built2022
- Price$ 495,000
- Bedrooms4
- Full Bathrooms3
- Half Bathrooms0
- Sqr Footage2400
- Lot Size0.17 Acres
Data Source:
REALTOR® Association of Acadiana (LBRMLS)
Property Description
Embrace the perfect blend of modern farmhouse charm and peaceful waterfront living in this stunning, thoughtfully designed home. The heart of the residence features an expansive, open-concept living area anchored by a grand fireplace that sets an inviting tone for any gathering. Culinary enthusiasts will love the spacious kitchen, which boasts a generous center island ideal for casual dining. For optimal privacy, the layout utilizes a clever split-bedroom floor plan, highlighted by a luxurious primary suite complete with a spa-inspired en-suite bath. Outside, the covered back patio serves as the ultimate retreat, fully equipped with an outdoor kitchen featuring a built-in gas grill, refrigerator, and sink--all overlooking the beautiful, tranquil views of the pond. Perfectly situated just minutes from the Youngsville Sports Complex, Sugar Mill Pond, and the area's vibrant local dining and entertainment spots, this exceptional property delivers both timeless style and unbeatable convenience. Contact us today to schedule your private tour!
| Elementary School | Middle School | High School |
|---|---|---|
| G T Lindon Elementary School | Youngsville Middle School | Southside High School |
| Price History | |
|---|---|
| 5/20/2026 | Listed $525,000 |
| 6/18/2026 | 2$515,000 |
| 8/27/2026 | 4$495,000 |
General Features
| Road Frontage Type | City Street,Paved |
|---|---|
| Association Amenities | Management,Recreation Facilities |
| Zoning | Residential |
| Sewer | Public Sewer |
| Heating | Central,Natural Gas |
| Cooling | Central Air |
| Roof | Composition |
| Appliances | Dishwasher,Disposal,Gas Range,Microwave,Refrigerator,Gas Stove Con |
| HOA Fee | 500 |
| Gas Y/N | Gas: Delta Utilities |
| Patio/Porch Features | Covered,Porch |
| Architectural Style | Modern Farm House |
| Construction Materials | Brick Veneer,HardiPlank Type,Frame |
| Year Built | 2022 |
| Electric | Elec: SLEMCO |
| View | Water |
| Stories Count | 1 |
| Property Subtype | Single Family Residence |
| Waterfront Features | Waterfront,Pond |
| Assoc Fee Paid Per | Annually |
| County | Lafayette |
| Property Type | Residential |
| HOA | true |
| Subdivision Name | Detente Lakes |
| Garage Y/N | true |
| Full Baths | 3 |
| Status | Active |
| Directions | From Lafayette head south east on Verot School Rd, Go through the roundabout at Hwy 92 and continue on Verot School Rd, At the curve continue left on Hwy 339, Continue onto Chemin Agreable, Turn left on Detente Rd, Turn Right onto Big Lake Run |
| City | Youngsville |
| High School District | Lafayette Parish |
| MLS Area | P |
| Lot Size Square Feet | 7405.2 |
| Carport Y/N | false |
| Home Warranty Y/N | true |
| Property Condition | Resale |
| Living Area Units | Square Feet |
| Builder Name | Heritage Homes |
| Standard Status | Active |
| Middle/Junior School District | Lafayette Parish |
| Elementary School District | Lafayette Parish |
| Legal Description | LOT L-75 DETENTE LAKES (60X135) |
Interior Features
| Interior Amenities | High Ceilings,Cathedral Ceiling(s),Crown Molding,Double Vanity,Guest Suite,Kitchen Island,Separate Shower,Standalone Tub,Varied Ceiling Heights,Walk-in Pantry,Walk-In Closet(s),Quartz Counters |
|---|---|
| Flooring | Tile,Vinyl Plank |
| Fireplace Features | 1 Fireplace,Gas Log,Ventless |
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Window Features | Double Pane Windows |
| Fireplace Y/N | true |
| Laundry Features | Electric Dryer Hookup |
| Total Bedrooms | 4 |
| LivingAreaSource | Approximate |
| Total Baths | 3 |
Exterior Features
| Exterior Amenities | Outdoor Grill,Outdoor Kitchen,Lighting |
|---|---|
| Fencing | Other,Wood |
| Parking Features | Garage Faces Front |
| Lot Features | 0 to 0.5 Acres,Landscaped,Views,Waterfront |
| Total Parking | 2 |
| Lot Size Area | 7405.2 |
| Foundation Details | Slab |
| Building Area Total | 3540 |
| Lot Dimensions | 60 x 135 |
| Lot Size Acres | 0.17 |
| 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