402 Last Quarter Drive, Youngsville, LA 70592 (MLS# 2600004773)

Have a particular community in mind? Explore our Communities → City pages to find homes for sale and local guidance for each area.

402 Last Quarter Drive, Youngsville, LA 70592

$395,000
Property Type: Residential Bedrooms: 3 Baths: 2 Square Footage: 1,909 Lot Size (sq. ft.): 7,405 Status: Active
Current Price: $395,000 List Date: 5/29/2026 Last Modified: 9/07/2026

Overview

Description

Welcome home to Detente Lakes, a lovely neighborhood with community ponds, walkways, and piers, conveniently located just South of the Youngsville Sports Complex and close to all the wonderful schools Youngsville has to offer. When you step into 402 Last Quarter Drive, a spacious Contemporary-style, 3 bed 2 bath, quality-built Schoeffler home less than 5 years old, you will immediately notice a difference from the norm: refined rustic style, with wood beam accents, a sublime color palette, and natural light pouring throughout. Floors are wide-width luxury plank vinyl & tile in bathrooms; no carpet at all. Upon entering the home from your 2-car garage, find your built-in drop area/mudroom & large laundry room with its own sink. The open kitchen has custom cabinetry, under-cabinet lighting, and beaded board island with plenty of counter space. The split floorplan includes the guest wing, with desk/office area, two spacious spare bedrooms and spare bath. Back in the living room, tall ...

Listing Details MLS# 2600004773

Listing Info

Delayed Marketing
No
Listing Price
395000
List Price/SqFt
206.91
Type
Single Family Residence
Property Attached
No
Document Modified
2026-05-29 17:03:05.645957
Modification Timestamp
2026-09-07T16:13:53Z
Photo Modified
2026-09-07T16:13:33Z

Location Tax Legal Info

Street Number
402
Street Name
Last Quarter
St Suffix
Drive
Parish
Lafayette
State
LA
Zip Code
70592
Subdivision
Detente Lakes
Area
P
Tax Assessment Number
6171957
Zone
Residential
Elementary School
G T Lindon
Middle School
Youngsville
High School
Southside
Directions
From Ambassador Caffery, take Chemin Metairie towards Youngsville/Hwy 92/Milton Hwy. At the roundabout at Detente Rd, take the first exit onto Detente. Left on Big Lake Run into subdivision; right on

General Property Description

# Bedrooms
3
Baths - Full
2
Total Baths
2
SqFt - Living
1909
SqFt - Source
Approximate
Stories
Yes
Year Built
2022
Approximate Age
4 - 5 Years
Property Condition
Resale
Builder
Schoeffler
Warranty
Yes
Acres
0.17
Acreage Range
0 - 0.5
Assn Fee
Required
Assn Fee $
500
Assn Fee Terms
Yearly
Lot Dimensions
60 x 122.16 x 60 x 121.82
Mineral Rights
Reserved
Pool on Subject Property
No

Parking

Garage Spaces
2

Water Source

Water Company
City of Youngsville

Originating Details

Originating System ID
M00000300
Originating System Key
20260528173222222871
Originating System Listing ID
2600004773
Originating System Name
RAA Flex

More Information

Property Features

Style: Contemporary; Traditional Levels: One Siding: Brick; Hardiplank Parking: Garage Faces Front Construction: Frame Foundation: Slab Road Frontage: City Street; Paved Roof: Composition Interior: 9+ Ft Ceiling; Attic Access; Beamed Ceilings; Bookcases; Built-Ins; Cathedral Ceiling; Computer Nook; Crown Molding; Double Vanity; Electric Dryer Con; Electric Washer Con; Gas Stove Con; Kitchen Island; Primary Bath; Separate Shower; Standalone Tub; Varied Ceiling Heights; Vaulted Ceilings; Walk-in Pantry; Walk-In Closet(s) Fireplace: 2 Fireplaces; Gas; Fireplace; Ventless Flooring: Tile; Vinyl Plank Heating: Central Cooling: Central Air Appliances: Dishwasher; Disposal; Gas Range; Microwave; Plumbed For Ice Maker; Other Countertops: Granite Security Features: Smoke Detector(s) Fencing: Full; Privacy; Wood Lot: Landscaped; Level Patio: Covered Amenities: Park; Other Exterior: Gas/Propane Grill; Outside Kitchen; Outside Light Window Features: Double Pane Windows Waterfront: Walk To Sewer: Public Sewer Water Source: Public Utilities: Elec: SLEMCO; Gas: Delta Utilities HOA Includes: Other - See Remarks Financing: Cash; Conventional; FHA; VA Documents: Property Disclosure; Property Disclosure
IDX
Listing Office: Real Broker, LLC
Last Updated: September - 07 - 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.