$520,000
Youngsville, LA 70592
MLS# 2500003300
4 beds | 3 baths | 3558 sqft
1 / 52
Open House (12/21/2025 - 1:00 pm - 3:00 pm)
Property Description
Buyer got cold feet , so this Brand New 15K Price Improvement could be your gain! If you are looking for a larger yard, LOT next Door is also available to purchase for a Really Large Yard! Just two years old, this 4 bedroom, 3 bath home offers nearly 2,500 sq. ft. with a triple split floor plan, bonus office space, and a fenced backyard with beautiful pond views. Features include fresh landscaping, plantation shutters, full window treatments, and a whole-home generator. With high coffered ceilings, brass accents, and designer-selected finishes, this home feels straight out of HGTV. Upstairs provides a private suite with en-suite bath and custom cabinetry landing zone. Built by Parade of Homes builder Hays Homes, the property is not in a flood zone and has never flooded. Located in a desirable community with stocked ponds, walking paths, and green spaces—close to the Sports Complex, Sugar Mill Pond, schools, shops, and restaurants. Preferred lender offering up to $5,000 toward closing costs!
Details
Documents
Listing Info
List Price/SqFt: 209.26
Property Attached: No
Document Modified: 2025-09-15 15:37:39.482148
Status: Active
Listing Date: 2025-09-10
Listing Price: 520000
Current Price: $520,000
Type: Single Family Residence
Modification Timestamp: 2025-12-16T15:26:48Z
Photo Modified: 2025-12-14T00:10:50Z
Location, Tax & Legal Info
Flood Zone: x
School District: Lafayette Parish
Legal Desc: LOT L-5 DETENTE LAKES
(60X125.08X60X125.07)
General Property Description
Approximate Age: 1 - 3 Years
Lot Dimensions: (60X125.08X60X125.07)
Stories: 2
SqFt - Living: 2485
SqFt - Lower: 2056
SqFt - Source: Blueprint
SqFt - Upper: 429
SqFt - Total: 3558
Mineral Rights: Conveyed
Assn Fee: Required
Assn Fee $: 500
Assn Fee Terms: Yearly
SqFt - Covered Porch: 378
SqFt - Garage: 695
Property Condition: Resale
Builder: Hays Homes
Warranty: Yes
Acreage Range: 0 - 0.5
Pool on Subject Property: No
# Bedrooms: 4
Baths - Full: 3
Total Baths: 3
Acres: 0.17
Remarks & Misc
Remarks: Buyer got cold feet , so this Brand New 15K Price Improvement could be your gain! If you are looking for a larger yard, LOT next Door is also available to purchase for a Really Large Yard! Just two years old, this 4 bedroom, 3 bath home offers nearly 2,500 sq. ft. with a triple split floor plan, bonus office space, and a fenced backyard with beautiful pond views. Features include fresh landscaping, plantation shutters, full window treatments, and a whole-home generator.
With high coffered ceilings, brass accents, and designer-selected finishes, this home feels straight out of HGTV. Upstairs provides a private suite with en-suite bath and custom cabinetry landing zone.
Built by Parade of Homes builder Hays Homes, the property is not in a flood zone and has never flooded. Located in a desirable community with stocked ponds, walking paths, and green spaces—close to the Sports Complex, Sugar Mill Pond, schools, shops, and restaurants. Preferred lender offering up to $5,000 toward closing costs!
Office/Member/Contract Info
REO: No
Style
Contemporary: 1
Traditional: 1
Siding
Hardiplank: 1
Stucco: 1
Parking
Garage Spaces: 2
Equipment
Garage Door Opener: 1
Ceiling Fans: 1
Cable Ready: 1
Fiber Available: 1
Road Frontage
City Street: 1
Paved: 1
Construction
Frame: 1
Foundation
Slab: 1
Patio
Covered: 1
Fireplace
1 Fireplace: 1
Roof
Composition: 1
Heating
Central: 1
Interior
9+ Ft Ceiling: 1
Attic Access: 1
Bookcases: 1
Built-Ins: 1
Computer Nook: 1
Crown Molding: 1
Double Vanity: 1
Dual Closets: 1
Electric Dryer Con: 1
Electric Stove Con: 1
Gas Stove Con: 1
Guest Suite: 1
Kitchen Island: 1
Primary Bath: 1
Separate Shower: 1
Vaulted Ceilings: 1
Walk-in Pantry: 1
Walk-In Closet(s): 1
Cooling
Central Air: 1
Flooring
Vinyl Tile: 1
Sewer
Public Sewer: 1
Water Source
Public: 1
Water Company: city
Appliances
Dishwasher: 1
Gas Range: 1
Microwave: 1
Utilities
Elec: SLEMCO: 1
Gas: Delta Utilities: 1
Countertops
Granite: 1
Waterfront
Pond: 1
Fencing
Privacy: 1
Wood: 1
Financing
Cash: 1
Conventional: 1
FHA: 1
Private Banking: 1
Rural Development: 1
VA: 1
Originating Details
Originating System ID: M00000300
Originating System Key: 20250910174110209581
Originating System Listing ID: 2500003300
Originating System Name: RAA Flex
Location Tax Legal Info
Street Number: 108
Street Name: Big Lake Run
Parish: Lafayette
State: LA
Zip Code: 70592
Subdivision: Detente Lakes
Area: P
Tax Assessment Number: 6168066
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 RIGHT
Property Features
Style: Contemporary; Traditional
Siding: Hardiplank; Stucco
Construction: Frame
Foundation: Slab
Road Frontage: City Street; Paved
Roof: Composition
Interior: 9+ Ft Ceiling; Attic Access; Bookcases; Built-Ins; Computer Nook; Crown Molding; Double Vanity; Dual Closets; Electric Dryer Con; Electric Stove Con; Gas Stove Con; Guest Suite; Kitchen Island; Primary Bath; Separate Shower; Vaulted Ceilings; Walk-in Pantry; Walk-In Closet(s)
Fireplace: 1 Fireplace
Flooring: Vinyl Tile
Heating: Central
Cooling: Central Air
Appliances: Dishwasher; Gas Range; Microwave
Countertops: Granite
Fencing: Privacy; Wood
Patio: Covered
Waterfront: Pond
Sewer: Public Sewer
Water Source: Public
Utilities: Elec: SLEMCO; Gas: Delta Utilities
Financing: Cash; Conventional; FHA; Private Banking; Rural Development; VA
LOMA IDX
Listing Office: Lulu David Real Estate Co LLC
Last Updated: December - 16 - 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.
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.