402 Last Quarter Drive, Youngsville, LA 70592
New Listing
$405,000
Property Type:
Residential
Bedrooms:
3
Baths:
2
Square Footage:
1,909
Lot Size (sq. ft.):
7,405
Status:
Active
Current Price:
$405,000
List Date:
5/29/2026
Last Modified:
5/29/2026
Listing Details MLS# 2600004773
Listing Info
- Delayed Marketing
- No
- Listing Price
- 405000
- List Price/SqFt
- 212.15
- Type
- Single Family Residence
- Property Attached
- No
- Document Modified
- 2026-05-29 17:03:05.645957
- Modification Timestamp
- 2026-05-29T22:11:50Z
- Photo Modified
- 2026-05-29T22:03:05Z
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
- Garage Faces Front
- Yes
Water Source
- Water Company
- City of Youngsville
- Public
- Yes
Originating Details
- Originating System ID
- M00000300
- Originating System Key
- 20260528173222222871
- Originating System Listing ID
- 2600004773
- Originating System Name
- RAA Flex
More Information
Location, Tax & Legal Info
- Flood Zone
- X
- School District
- Lafayette Parish
- Legal Desc
- Lot L-108 Detente Lakes PH II (60x122.16x60x121.82) (7319 SQ FT)
Remarks & Misc
- Remarks
- 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 tray ceilings emphasize the gas fireplace. Your beautiful dining area is bathed in light and has built-in buffet with storage & floating shelves. Enter the primary suite where grandeur continues: large bedroom, ensuite bath with high ceilings, free-standing tub and separate custom tile shower, and finally the huge primary closet complete our tour of the inside of this home. Step into the backyard to the covered patio complete with built-in grill, sink, and corner fireplace. An entertainer's dream for sure! For this home, the word ''custom'' sums it up just perfectly; schedule a private showing before it's too late!
Office/Member/Contract Info
- REO
- No
Style
- Contemporary
- Yes
- Traditional
- Yes
Levels
- One
- Yes
Siding
- Brick
- Yes
- Hardiplank
- Yes
Equipment
- Garage Door Opener
- Yes
- Ceiling Fans
- Yes
- Cable Available
- Yes
Road Frontage
- City Street
- Yes
- Paved
- Yes
Construction
- Frame
- Yes
Foundation
- Slab
- Yes
Exterior
- Gas/Propane Grill
- Yes
- Outside Kitchen
- Yes
- Outside Light
- Yes
Patio
- Covered
- Yes
Fireplace
- Fireplace
- Yes
- 2 Fireplaces
- Yes
- Gas
- Yes
- Ventless
- Yes
Roof
- Composition
- Yes
Heating
- Central
- Yes
Interior
- 9+ Ft Ceiling
- Yes
- Attic Access
- Yes
- Beamed Ceilings
- Yes
- Bookcases
- Yes
- Built-Ins
- Yes
- Cathedral Ceiling
- Yes
- Computer Nook
- Yes
- Crown Molding
- Yes
- Double Vanity
- Yes
- Electric Dryer Con
- Yes
- Electric Washer Con
- Yes
- Gas Stove Con
- Yes
- Kitchen Island
- Yes
- Primary Bath
- Yes
- Separate Shower
- Yes
- Standalone Tub
- Yes
- Varied Ceiling Heights
- Yes
- Vaulted Ceilings
- Yes
- Walk-in Pantry
- Yes
- Walk-In Closet(s)
- Yes
Cooling
- Central Air
- Yes
Flooring
- Tile
- Yes
- Vinyl Plank
- Yes
Sewer
- Public Sewer
- Yes
Appliances
- Dishwasher
- Yes
- Disposal
- Yes
- Gas Range
- Yes
- Microwave
- Yes
- Plumbed For Ice Maker
- Yes
- Other
- Yes
Utilities
- Elec: SLEMCO
- Yes
- Gas: Delta Utilities
- Yes
Countertops
- Granite
- Yes
Waterfront
- Walk To
- Yes
Documents
- Property Disclosure
- Yes
Amenities
- Park
- Yes
- Other
- Yes
Security Features
- Smoke Detector(s)
- Yes
Fencing
- Full
- Yes
- Privacy
- Yes
- Wood
- Yes
Lot
- Landscaped
- Yes
- Level
- Yes
Window Features
- Double Pane Windows
- Yes
Financing
- Cash
- Yes
- Conventional
- Yes
- FHA
- Yes
- VA
- Yes
HOA Includes
- Other - See Remarks
- Yes
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
Property Disclosure ›
IDX
Listing Office:
Real Broker, LLC
Last Updated: May - 29 - 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.