$443,000
Youngsville, LA 70592
MLS# BR2026001691
4 beds | 2 baths | 3382 sqft
1 / 23
Property Description
Motivated seller here is your chance. Built by Milton Hebert Construction, this beautifully appointed split floor plan home in the sought-after Detente Lakes subdivision delivers the kind of everyday living that just feels right. Step through a welcoming entryway where the open living, kitchen, and dining areas unfold effortlessly anchored by custom cabinetry, granite countertops, stainless steel appliances, and a walk-in pantry that makes the space as functional as it is beautiful. Tall windows and light, airy finishes flood the room with natural light while framing views of the outdoor living area beyond. The primary suite is a true retreat, featuring a custom tiled shower and an abundance of closet space, while three guest bedrooms tuck privately on the opposite side of the home. Outside, the covered kitchen and living space is built for entertaining complete with a fireplace and beverage fridge and the front porch is the kind of spot you'll actually use, whether that's morning coffee or catching up with neighbors. Practical touches round it all out: a mudroom landing off the garage, large laundry room, and bonus storage nook. Detente Lakes itself is a gem peaceful ponds, a charming bridge, sidewalks throughout, and just 2.5 miles from the Youngsville Sports Complex. This one checks every box.
Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 201.18
Document Modified: 2026-03-09 14:27:42.190205
Status: Active
Listing Date: 2026-01-28
Listing Price: 443000
Current Price: $443,000
Type: Single Family Residence
Modification Timestamp: 2026-04-30T14:23:49Z
Photo Modified: 2026-04-27T21:12:56Z
Location, Tax & Legal Info
School District: Lafayette Parish
Legal Desc: Lot 110 of Detente Lakes Subdivision
General Property Description
Lot Dimensions: 60 x 123
Stories: 1
SqFt - Living: 2202
SqFt - Source: Blueprint
SqFt - Total: 3382
Mineral Rights: Negotiable
Assn Fee $: 500
Assn Fee Terms: Yearly
SqFt - Covered Porch: 632
SqFt - Garage: 548
Builder: Milton Hebert Home Builders, LLC
Acreage Range: 0 - 0.5
Pool on Subject Property: No
# Bedrooms: 4
Baths - Full: 2
Total Baths: 2
Year Built: 2022
Acres: 0.17
Remarks & Misc
Remarks: Motivated seller here is your chance. Built by Milton Hebert Construction, this beautifully appointed split floor plan home in the sought-after Detente Lakes subdivision delivers the kind of everyday living that just feels right. Step through a welcoming entryway where the open living, kitchen, and dining areas unfold effortlessly anchored by custom cabinetry, granite countertops, stainless steel appliances, and a walk-in pantry that makes the space as functional as it is beautiful. Tall windows and light, airy finishes flood the room with natural light while framing views of the outdoor living area beyond. The primary suite is a true retreat, featuring a custom tiled shower and an abundance of closet space, while three guest bedrooms tuck privately on the opposite side of the home. Outside, the covered kitchen and living space is built for entertaining complete with a fireplace and beverage fridge and the front porch is the kind of spot you'll actually use, whether that's morning coffee or catching up with neighbors. Practical touches round it all out: a mudroom landing off the garage, large laundry room, and bonus storage nook. Detente Lakes itself is a gem peaceful ponds, a charming bridge, sidewalks throughout, and just 2.5 miles from the Youngsville Sports Complex. This one checks every box.
Office/Member/Contract Info
List AOR: GBRAR
Style
Traditional: 1
Siding
Stucco: 1
Parking
Garage: 1
Construction
Brick: 1
Frame: 1
Foundation
Slab: 1
Exterior
Gas/Propane Grill: 1
Outside Light: 1
Patio
Covered: 1
Open: 1
Fireplace
2 Fireplaces: 1
Ventless: 1
Heating
Central: 1
Interior
9+ Ft Ceiling: 1
Crown Molding: 1
Double Vanity: 1
Kitchen Island: 1
Multi-Head Shower: 1
Separate Shower: 1
Walk-In Closet(s): 1
Cooling
Central Air: 1
Flooring
Laminate: 1
Tile: 1
Wood: 1
Appliances
Dishwasher: 1
Disposal: 1
Rooms
Bedroom 1: 1
Dining Room: 1
Foyer: 1
Kitchen: 1
Living Room: 1
Primary Bathroom: 1
Primary Bedroom: 1
Utility Room: 1
Bedroom 2: 1
Bedroom 3: 1
Bedroom 4: 1
Bedroom 5: 1
Bedroom 6: 1
Bedroom 7: 1
Bedroom 8: 1
Fencing
Full: 1
Wood: 1
Lot
Level: 1
Financing
Cash: 1
Conventional: 1
FHA: 1
Rural Development: 1
VA: 1
HOA Includes
Accounting: 1
Ground Keeping: 1
Insurance: 1
Legal: 1
Management: 1
Originating Details
Originating System ID: ROAMP
Originating System Key: 2026001691
Originating System Listing ID: 2026001691
Originating System Name: ROAM Paragon
Location Tax Legal Info
Street Number: 406
Street Name: Last Quarter Drive
Parish: Lafayette
State: LA
Zip Code: 70592
Subdivision: Detente Lakes
Tax Assessment Number: 6171959
Directions: From Hwy 90turn onto Ambassador Caffery, then left onto Chemin Metairie Rd. Right on Detente Rd. Last Quarter is on the Right.
Property Features
Style: Traditional
Siding: Stucco
Parking: Garage
Construction: Brick; Frame
Foundation: Slab
Interior: 9+ Ft Ceiling; Crown Molding; Double Vanity; Kitchen Island; Multi-Head Shower; Separate Shower; Walk-In Closet(s)
Fireplace: 2 Fireplaces; Ventless
Flooring: Laminate; Tile; Wood
Heating: Central
Cooling: Central Air
Appliances: Dishwasher; Disposal
Rooms: Bedroom 1; Dining Room; Foyer; Kitchen; Living Room; Primary Bathroom; Primary Bedroom; Utility Room; Bedroom 2; Bedroom 3; Bedroom 4; Bedroom 5; Bedroom 6; Bedroom 7; Bedroom 8
Fencing: Full; Wood
Lot: Level
Patio: Covered; Open
Exterior: Gas/Propane Grill; Outside Light
HOA Includes: Accounting; Ground Keeping; Insurance; Legal; Management
Financing: Cash; Conventional; FHA; Rural Development; VA
Room Information
| Room Name | Length | Width | Remarks |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bedroom | 15.00 | 15.00 | PRIMARY BEDROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Primary Bathroom | 9.20 | 15.00 | PRIMARY BATHROOM |
| Bedroom 1 | 12.90 | 11.00 | BEDROOM |
| Bedroom 2 | 12.00 | 11.00 | BEDROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Living Room | 18.00 | 20.00 | LIVING ROOM |
| Bedroom 3 | 12.70 | 11.00 | BEDROOM |
| Bedroom 4 | 12.70 | 11.00 | BEDROOM |
| Bedroom 5 | 12.00 | 11.00 | BEDROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Dining Room | 11.00 | 12.10 | DINING ROOM |
| Bedroom 6 | 12.90 | 11.00 | BEDROOM |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Foyer | 6.60 | 12.00 | FOYER |
| Bedroom 7 | 12.90 | 11.00 | BEDROOM |
| Bedroom 8 | 12.70 | 11.00 | BEDROOM |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Kitchen | 11.00 | 16.00 | KITCHEN |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
| Utility Room | 11.00 | 16.00 | UTILITY ROOM |
PDD IDX
Listing Office: Real Broker LLC
Last Updated: April - 30 - 2026
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.