Member Gateway

406 Last Quarter Drive, Youngsville, LA 70592 (MLS# BR2026001691)

406 Last Quarter Drive, Youngsville, LA 70592

$443,000
Property Type: Residential Bedrooms: 4 Baths: 2 Square Footage: 3,382 Lot Size (sq. ft.): 7,405 Status: Active
Current Price: $443,000 List Date: 1/28/2026 Last Modified: 4/30/2026

Overview

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 coff ...

Listing Details MLS# BR2026001691

Listing Info

Delayed Marketing
No
Listing Price
443000
List Price/SqFt
201.18
Type
Single Family Residence
Document Modified
2026-03-09 14:27:42.190205
Modification Timestamp
2026-04-30T14:23:49Z
Photo Modified
2026-04-27T21:12:56Z

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.

General Property Description

# Bedrooms
4
Baths - Full
2
Total Baths
2
SqFt - Living
2202
SqFt - Total
3382
SqFt - Source
Blueprint
Stories
Yes
SqFt - Covered Porch
632
SqFt - Garage
548
Year Built
2022
Builder
Milton Hebert Home Builders, LLC
Acres
0.17
Acreage Range
0 - 0.5
Assn Fee $
500
Assn Fee Terms
Yearly
Lot Dimensions
60 x 123
Mineral Rights
Negotiable
Pool on Subject Property
No

Originating Details

Originating System ID
ROAMP
Originating System Key
2026001691
Originating System Listing ID
2026001691
Originating System Name
ROAM Paragon

Location, Tax & Legal Info

School District
Lafayette Parish
Legal Desc
Lot 110 of Detente Lakes Subdivision

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.

More Information

Office/Member/Contract Info

List AOR
GBRAR

Style

Traditional
Yes

Siding

Stucco
Yes

Parking

Garage
Yes

Construction

Brick
Yes
Frame
Yes

Foundation

Slab
Yes

Exterior

Gas/Propane Grill
Yes
Outside Light
Yes

Patio

Covered
Yes
Open
Yes

Fireplace

2 Fireplaces
Yes
Ventless
Yes

Heating

Central
Yes

Interior

9+ Ft Ceiling
Yes
Crown Molding
Yes
Double Vanity
Yes
Kitchen Island
Yes
Multi-Head Shower
Yes
Separate Shower
Yes
Walk-In Closet(s)
Yes

Cooling

Central Air
Yes

Flooring

Laminate
Yes
Tile
Yes
Wood
Yes

Appliances

Dishwasher
Yes
Disposal
Yes

Rooms

Bedroom 1
Yes
Dining Room
Yes
Foyer
Yes
Kitchen
Yes
Living Room
Yes
Primary Bathroom
Yes
Primary Bedroom
Yes
Utility Room
Yes
Bedroom 2
Yes
Bedroom 3
Yes
Bedroom 4
Yes
Bedroom 5
Yes
Bedroom 6
Yes
Bedroom 7
Yes
Bedroom 8
Yes

Fencing

Full
Yes
Wood
Yes

Lot

Level
Yes

Financing

Cash
Yes
Conventional
Yes
FHA
Yes
Rural Development
Yes
VA
Yes

HOA Includes

Accounting
Yes
Ground Keeping
Yes
Insurance
Yes
Legal
Yes
Management
Yes

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

Documents

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.
Search powered by FBS Products