$535,000
Youngsville, LA 70592
MLS# 2500002846
4 beds | 3 baths
1 / 52
Property Description
This meticulously maintained 2023 Parade Home in sought-after Détente Lakes offers pond views and a host of upgrades, all conveniently located near Southside High, ARCA, and Youngsville Sports Complex. Featuring a triple split floorplan with four bedrooms plus a private office, the home provides ample space for everyone. Guests are welcomed by mature landscaping, a charming front porch, and striking curb appeal. Inside, the foyer impresses with soaring ceilings, accent walls, and barn door access to the office, while the living room showcases floor-to-ceiling windows, a cathedral ceiling, and a fireplace focal point. The spacious kitchen includes a large island, custom tiled backsplash, walk-in pantry, and opens to a dining area with a wine fridge and added cabinetry. The generous primary suite easily fits large furniture and boasts a luxurious bath with dual vanities, a pedestal tub, custom tiled shower, and a well-appointed walk-in closet. Two guest bedrooms at the front of the home share a beautifully finished bath, while a third guest suite—ideal as a mother-in-law space—offers its own bath with private exterior access. Storage is abundant throughout, but the showstopper is the extended back porch, featuring a full outdoor kitchen, guest bath access, fireplace, shade screen, and storage closet. Additional highlights include a whole house generator, newly planted trees and roses, a LOMA letter confirming Flood Zone X with no history of flooding.
Details
Documents
Listing Info
List Price/SqFt: 215.55
Property Attached: No
Document Modified: 2025-08-27 17:20:32.428018
Status: Active
Listing Date: 2025-08-27
Listing Price: 535000
Current Price: $535,000
Type: Single Family Residence
Modification Timestamp: 2025-09-28T06:45:44Z
Photo Modified: 2025-09-23T16:43:57Z
Location, Tax & Legal Info
Flood Zone: X
School District: Lafayette Parish
Legal Desc: LOT L-6 DETENTE LAKES
(60X125.09X60X125.08)
General Property Description
Approximate Age: 1 - 3 Years
Condition: Excellent
Lot Dimensions: 60X125
Stories: 1
SqFt - Living: 2482
SqFt - Source: Approximate
Mineral Rights: Conveyed
Assn Fee: Required
Assn Fee $: 500
Assn Fee Terms: Yearly
Property Condition: New Construction
Builder: Hays Homes
Warranty: No
Acreage Range: 0 - 0.5
Pool on Subject Property: No
# Bedrooms: 4
Baths - Full: 3
Total Baths: 3
Year Built: 2023
Acres: 0.17
Remarks & Misc
Remarks: This meticulously maintained 2023 Parade Home in sought-after Détente Lakes offers pond views and a host of upgrades, all conveniently located near Southside High, ARCA, and Youngsville Sports Complex.
Featuring a triple split floorplan with four bedrooms plus a private office, the home provides ample space for everyone. Guests are welcomed by mature landscaping, a charming front porch, and striking curb appeal. Inside, the foyer impresses with soaring ceilings, accent walls, and barn door access to the office, while the living room showcases floor-to-ceiling windows, a cathedral ceiling, and a fireplace focal point. The spacious kitchen includes a large island, custom tiled backsplash, walk-in pantry, and opens to a dining area with a wine fridge and added cabinetry.
The generous primary suite easily fits large furniture and boasts a luxurious bath with dual vanities, a pedestal tub, custom tiled shower, and a well-appointed walk-in closet. Two guest bedrooms at the front of the home share a beautifully finished bath, while a third guest suite—ideal as a mother-in-law space—offers its own bath with private exterior access.
Storage is abundant throughout, but the showstopper is the extended back porch, featuring a full outdoor kitchen, guest bath access, fireplace, shade screen, and storage closet.
Additional highlights include a whole house generator, newly planted trees and roses, a LOMA letter confirming Flood Zone X with no history of flooding.
Office/Member/Contract Info
REO: No
Style
Modern Farm House: 1
Traditional: 1
Siding
Hardiplank: 1
Parking
Attached: 1
Garage: 1
Garage Spaces: 2
Garage Faces Front: 1
Equipment
Garage Door Opener: 1
Ceiling Fans: 1
Cable Available: 1
Cable Ready: 1
Fiber Available: 1
Generator: 1
Road Frontage
City Street: 1
Paved: 1
Construction
Frame: 1
Foundation
Slab: 1
Exterior
Gas/Propane Grill: 1
Outside Kitchen: 1
Outside Light: 1
Patio
Porch: 1
Covered: 1
Fireplace
Fireplace: 1
2 Fireplaces: 1
Gas: 1
Ventless: 1
Wood Burning: 1
Roof
Composition: 1
Heating
Central: 1
Interior
9+ Ft Ceiling: 1
Attic Access: 1
Beamed Ceilings: 1
Built-Ins: 1
Cathedral Ceiling: 1
Computer Nook: 1
Crown Molding: 1
Double Vanity: 1
Electric Dryer Con: 1
Gas Dryer Con: 1
Gas Stove Con: 1
Guest Suite: 1
Kitchen Island: 1
Primary Bath: 1
Separate Shower: 1
Special Bath: 1
Standalone Tub: 1
Vaulted Ceilings: 1
Walk-in Pantry: 1
Walk-In Closet(s): 1
Wet Bar: 1
Cooling
Central Air: 1
Flooring
Vinyl Plank: 1
Sewer
Public Sewer: 1
Sewer Company: City
Water Source
Public: 1
Water Company: City
Appliances
Dishwasher: 1
Disposal: 1
Gas Range: 1
Microwave: 1
Plumbed For Ice Maker: 1
Utilities
Elec: SLEMCO: 1
Gas: Delta Utilities: 1
Countertops
Granite: 1
Waterfront
Pond: 1
View: 1
Walk To: 1
Documents
Property Disclosure: 1
Security Features
Smoke Detector(s): 1
Fencing
Full: 1
Privacy: 1
Wood: 1
Lot
Landscaped: 1
Level: 1
Views: 1
Water Frontage: 1
Window Features
Double Pane Windows: 1
Financing
Cash: 1
Conventional: 1
FHA: 1
Rural Development: 1
VA: 1
Reserved Item
Other - See Remarks: 1
HOA Includes
Accounting: 1
Management: 1
Originating Details
Originating System ID: M00000300
Originating System Key: 20250827165740225577
Originating System Listing ID: 2500002846
Originating System Name: RAA Flex
Location Tax Legal Info
Street Number: 110
Street Name: Big Lake Run
Parish: Lafayette
State: LA
Zip Code: 70592
Subdivision: Detente Lakes
Area: P
Tax Assessment Number: 6168067
Elementary School: G T Lindon
Middle School: Youngsville
High School: Southside
Directions: Take Verot south to Youngsville round about. Left onto Hwy. 92 and right onto Chemin Metairie at the next round about. Turn right on Détente Rd. Left into Détente Lakes subdivision on Big Lake. Home on the right.
Property Features
Style: Modern Farm House; Traditional
Siding: Hardiplank
Parking: Attached; Garage; Garage Faces Front
Construction: Frame
Foundation: Slab
Road Frontage: City Street; Paved
Roof: Composition
Interior: 9+ Ft Ceiling; Attic Access; Beamed Ceilings; Built-Ins; Cathedral Ceiling; Computer Nook; Crown Molding; Double Vanity; Electric Dryer Con; Gas Dryer Con; Gas Stove Con; Guest Suite; Kitchen Island; Primary Bath; Separate Shower; Special Bath; Standalone Tub; Vaulted Ceilings; Walk-in Pantry; Walk-In Closet(s); Wet Bar
Fireplace: 2 Fireplaces; Gas; Fireplace; Ventless; Wood Burning
Flooring: Vinyl Plank
Heating: Central
Cooling: Central Air
Appliances: Dishwasher; Disposal; Gas Range; Microwave; Plumbed For Ice Maker
Countertops: Granite
Equipment: Generator
Security Features: Smoke Detector(s)
Fencing: Full; Privacy; Wood
Lot: Landscaped; Level; Views; Water Frontage
Patio: Covered; Porch
Exterior: Gas/Propane Grill; Outside Kitchen; Outside Light
Window Features: Double Pane Windows
Waterfront: Pond; View; Walk To
Sewer: Public Sewer
Water Source: Public
Utilities: Elec: SLEMCO; Gas: Delta Utilities
HOA Includes: Accounting; Management
Reserved Item: Other - See Remarks
Financing: Cash; Conventional; FHA; Rural Development; VA
Documents: Property Disclosure; Property Disclosure
Property Disclosure Listing Office: Compass
Last Updated: September - 28 - 2025
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.
Broker Attribution:
337-233-9700
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.