406 Last Quarter Drive, Youngsville, LA 70592
$449,000
Property Type:
Residential
Bedrooms:
4
Baths:
2
Square Footage:
3,382
Lot Size (sq. ft.):
7,405
Status:
Active
Current Price:
$449,000
List Date:
1/28/2026
Last Modified:
3/30/2026
Description
Built by Milton Hebert Construction, this beautifully appointed split-floor plan home in the sought-after Détente 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, a large laundry room, and a bonus storage nook. Détente 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.
Supplements: ********
More Information MLS# 2600000373
Listing Info
Delayed Marketing: No
List Price/SqFt: 203.91
Property Attached: No
Document Modified: 2026-01-28 15:48:42.397902
Status: Active
Listing Date: 2026-01-26
Listing Price: 449000
Current Price: $449,000
Type: Single Family Residence
Modification Timestamp: 2026-03-30T15:55:27Z
Photo Modified: 2026-01-28T21:48:42Z
Location, Tax & Legal Info
Flood Zone: X
School District: Lafayette Parish
Legal Desc: Lot 110 of Detente Lakes Subdivision
General Property Description
Approximate Age: 4 - 5 Years
Lot Dimensions: 60x122.85x60
Stories: 1
SqFt - Living: 2202
SqFt - Source: Blueprint
SqFt - Total: 3382
Mineral Rights: Reserved
Assn Fee: Required
Assn Fee $: 500
Assn Fee Terms: Yearly
SqFt - Covered Porch: 632
SqFt - Garage: 548
Property Condition: Resale
Builder: Milton Hebert Constu
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: Built by Milton Hebert Construction, this beautifully appointed split-floor plan home in the sought-after Détente 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, a large laundry room, and a bonus storage nook. Détente 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
REO: No
Style
Traditional: 1
Levels
One: 1
Siding
Brick: 1
Hardiplank: 1
Stucco: 1
Parking
Garage Spaces: 2
Equipment
Garage Door Opener: 1
Ceiling Fans: 1
Cable Available: 1
Road Frontage
Paved: 1
Construction
Frame: 1
Foundation
Slab: 1
Exterior
Gas/Propane Grill: 1
Outside Light: 1
Patio
Porch: 1
Covered: 1
Open: 1
Fireplace
Fireplace: 1
2 Fireplaces: 1
Ventless: 1
Roof
Composition: 1
Heating
Central: 1
Electric: 1
Interior
9+ Ft Ceiling: 1
Attic Access: 1
Crown Molding: 1
Double Vanity: 1
Electric Dryer Con: 1
Electric Washer Con: 1
Gas Stove Con: 1
Kitchen Island: 1
Primary Bath: 1
Separate Shower: 1
Varied Ceiling Heights: 1
Walk-in Pantry: 1
Walk-In Closet(s): 1
Cooling
Central Air: 1
Flooring
Tile: 1
Wood Laminate: 1
Sewer
Public Sewer: 1
Water Source
Public: 1
Water Company: City of Youngsville
Appliances
Dishwasher: 1
Disposal: 1
Gas Range: 1
Microwave: 1
Utilities
Elec: SLEMCO: 1
Countertops
Granite: 1
Rooms
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
Documents
Property Disclosure: 1
Security Features
Smoke Detector(s): 1
Fencing
Full: 1
Wood: 1
Lot
Back Yard Access: 1
Landscaped: 1
Level: 1
Window Features
Double Pane Windows: 1
Financing
Cash: 1
Conventional: 1
FHA: 1
Rural Development: 1
VA: 1
HOA Includes
Ground Keeping: 1
Recreation Facilities: 1
Originating Details
Originating System ID: M00000300
Originating System Key: 20260126171452396768
Originating System Listing ID: 2600000373
Originating System Name: RAA Flex
Location Tax Legal Info
Street Number: 406
Street Name: Last Quarter
St Suffix: Drive
Parish: Lafayette
State: LA
Zip Code: 70592
Subdivision: Detente Lakes
Area: P
Tax Assessment Number: 6171959
Zone: RES
Elementary School: Ernest Gallet
Middle School: Youngsville
High School: Southside
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
Levels: One
Siding: Brick; Hardiplank; Stucco
Construction: Frame
Foundation: Slab
Road Frontage: Paved
Roof: Composition
Interior: 9+ Ft Ceiling; Attic Access; Crown Molding; Double Vanity; Electric Dryer Con; Electric Washer Con; Gas Stove Con; Kitchen Island; Primary Bath; Separate Shower; Varied Ceiling Heights; Walk-in Pantry; Walk-In Closet(s)
Fireplace: 2 Fireplaces; Fireplace; Ventless
Flooring: Tile; Wood Laminate
Heating: Central; Electric
Cooling: Central Air
Appliances: Dishwasher; Disposal; Gas Range; Microwave
Countertops: Granite
Rooms: Dining Room; Foyer; Kitchen; Living Room; Primary Bathroom; Primary Bedroom; Utility Room; Bedroom 2; Bedroom 3; Bedroom 4
Security Features: Smoke Detector(s)
Fencing: Full; Wood
Lot: Back Yard Access; Landscaped; Level
Patio: Covered; Open; Porch
Exterior: Gas/Propane Grill; Outside Light
Window Features: Double Pane Windows
Sewer: Public Sewer
Water Source: Public
Utilities: Elec: SLEMCO
HOA Includes: Ground Keeping; Recreation Facilities
Financing: Cash; Conventional; FHA; Rural Development; VA
Documents: Property Disclosure; Property Disclosure
Room Information
Primary Bedroom
Length: 15.00
Width: 15.00
Primary Bathroom
Length: 9.20
Width: 15.00
Bedroom 2
Length: 12.70
Width: 11.00
Bedroom 3
Length: 12.90
Width: 11.00
Bedroom 4
Length: 12.00
Width: 11.00
Living Room
Length: 18.00
Width: 20.00
Dining Room
Length: 11.00
Width: 12.10
Kitchen
Length: 11.00
Width: 16.00
Utility Room
Length: 11.00
Width: 16.00
Foyer
Length: 6.60
Width: 12.00
Listing Office:
Real Broker, LLC
IDX
Last Updated: March - 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.

Disclosures ›