408 Last Quarter Drive, Youngsville, LA 70592
$475,000
Property Type:
Residential
Bedrooms:
4
Baths:
3
Square Footage:
2,299
Lot Size (sq. ft.):
8,712
Status:
Active
Current Price:
$475,000
List Date:
8/08/2025
Last Modified:
9/26/2025
Description
Experience quality craftsmanship and thoughtful design in this beautifully built home by Milton Hebert Construction. Designed with both comfort and style in mind, this residence features a soft, inviting color palette, elegant custom bathrooms, and designer lighting throughout.
The spacious split floor plan offers exceptional flow and functionality, with a well-appointed kitchen boasting custom cabinetry, granite countertops, and sleek stainless steel appliances—perfect for both everyday living and entertaining.
Retreat to the luxurious primary suite, complete with a custom-tiled shower, stylish flooring, and generous closet space to accommodate all your storage needs.
Step outside to an impressive outdoor living area, ideal for entertaining guests. Enjoy the warmth of a built-in fireplace and the convenience of an outdoor refrigerator—perfect for keeping drinks chilled while relaxing or hosting gatherings.
Don't miss the opportunity to make this exceptional property your new home.
Supplements: ********
More Information MLS# 2500002072
Listing Info
Delayed Marketing: No
List Price/SqFt: 206.61
Property Attached: No
Document Modified: 2025-08-08 11:14:35.774765
Status: Active
Listing Date: 2025-08-05
Listing Price: 475000
Current Price: $475,000
Type: Single Family Residence
Modification Timestamp: 2025-09-26T14:51:32Z
Photo Modified: 2025-08-07T21:02:16Z
Location, Tax & Legal Info
School District: Lafayette Parish
Legal Desc: LOT L-111 DETENTE LAKES PH II
General Property Description
Approximate Age: 1 - 3 Years
Lot Dimensions: 70x123.25x70x122.85
Stories: 1
SqFt - Living: 2299
SqFt - Source: Approximate
Mineral Rights: Conveyed
Assn Fee: Required
Assn Fee $: 500
Assn Fee Terms: Yearly
Property Condition: Resale
Builder: Milton Hebert
Acreage Range: 0 - 0.5
Pool on Subject Property: No
# Bedrooms: 4
Baths - Full: 3
Total Baths: 3
Acres: 0.2
Remarks & Misc
Remarks: Experience quality craftsmanship and thoughtful design in this beautifully built home by Milton Hebert Construction. Designed with both comfort and style in mind, this residence features a soft, inviting color palette, elegant custom bathrooms, and designer lighting throughout.
The spacious split floor plan offers exceptional flow and functionality, with a well-appointed kitchen boasting custom cabinetry, granite countertops, and sleek stainless steel appliances—perfect for both everyday living and entertaining.
Retreat to the luxurious primary suite, complete with a custom-tiled shower, stylish flooring, and generous closet space to accommodate all your storage needs.
Step outside to an impressive outdoor living area, ideal for entertaining guests. Enjoy the warmth of a built-in fireplace and the convenience of an outdoor refrigerator—perfect for keeping drinks chilled while relaxing or hosting gatherings.
Don't miss the opportunity to make this exceptional property your new home.
Office/Member/Contract Info
REO: No
List AOR: RAA
Style
Traditional: 1
Siding
Brick: 1
Hardiplank: 1
Stucco: 1
Parking
Garage Spaces: 2
Equipment
Garage Door Opener: 1
Ceiling Fans: 1
Cable Available: 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
Disposal: 1
Gas Range: 1
Microwave: 1
Utilities
Elec: SLEMCO: 1
Countertops
Granite: 1
Security Features
Smoke Detector(s): 1
Fencing
Full: 1
Wood: 1
Lot
Back Yard Access: 1
Landscaped: 1
Level: 1
Financing
Cash: 1
Conventional: 1
FHA: 1
Rural Development: 1
VA: 1
Originating Details
Originating System ID: M00000300
Originating System Key: 20250805195827774745
Originating System Listing ID: 2500002072
Originating System Name: RAA Flex
Location Tax Legal Info
Street Number: 408
Street Name: Last Quarter
St Suffix: Drive
Parish: Lafayette
State: LA
Zip Code: 70592
Subdivision: Detente Lakes
Area: P
Tax Assessment Number: 6171960
Elementary School: Ernest Gallet
Middle School: Youngsville
High School: Southside
Directions: From Hwy 90, turn onto Ambassador Caffery. Turn Left on Chemin Metairie Rd. Turn Right on Detente Rd Subdivision, Last Quarter is on the Right
Property Features
Style: Traditional
Siding: Brick; Hardiplank; Stucco
Construction: Frame
Foundation: Slab
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: Disposal; Gas Range; Microwave
Countertops: Granite
Security Features: Smoke Detector(s)
Fencing: Full; Wood
Lot: Back Yard Access; Landscaped; Level
Patio: Covered; Open; Porch
Exterior: Gas/Propane Grill; Outside Light
Sewer: Public Sewer
Water Source: Public
Utilities: Elec: SLEMCO
Financing: Cash; Conventional; FHA; Rural Development; VA
Flood Determination Disclosure ›Listing Office: EXP Realty, LLC
Last Updated: September - 26 - 2025
Broker Attribution:
337-522-7554
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.