407 Last Quarter Drive, Youngsville, LA 70592
New Listing
$520,000
Property Type:
Residential
Bedrooms:
4
Baths:
3
Square Footage:
2,758
Lot Size (sq. ft.):
4,356
Status:
Active
Current Price:
$520,000
List Date:
9/11/2025
Last Modified:
9/11/2025
Description
Welcome to your dream waterfront retreat! This exquisite 4-bedroom, 3-bathroom home, designed with professionally drawn house plans, showcases a split floor plan and a stunning waterfront view on a professionally landscaped lot. The gourmet kitchen features custom cabinetry to the ceiling, Frigidaire Professional Series appliances, quartz countertops, and a spacious pantry. Luxurious details include top-line Pfister, Delta, and Gerber plumbing fixtures, custom molding, and a cozy gas fireplace. The outdoor oasis boasts a brick and granite kitchen with a Coyote BBQ pit, sink, and space for a mini fridge, ideal for entertaining. Plygem 1500 series windows, Duration shingles, and additional custom cabinets throughout elevate the home's elegance, while the large yard offers ample space to enjoy the breathtaking waterfront scenery.
Supplements: ********
More Information MLS# 2500003337
Listing Info
Status: Active
Listing Date: 2025-09-11
Listing Price: 520000
Current Price: $520,000
List Price/SqFt: 188.54
Type: Single Family Residence
Property Attached: No
Document Modified: 2025-09-11 10:29:51.793835
Modification Timestamp: 2025-09-11T15:38:25Z
Photo Modified: 2025-09-11T15:29:51Z
Location Tax Legal Info
Street Number: 407
Street Name: Last Quarter
St Suffix: Drive
Parish: Lafayette
State: LA
Zip Code: 70592
Subdivision: Detente Lakes
Area: P
Tax Assessment Number: 6171945
Elementary School: Ernest Gallet
Middle School: Youngsville
High School: Southside
Directions: From Hwy 90 turn onto E Verot School Rd., turn left onto Chemin Agreable, turn left onto Detente Rd., turn right onto Big Lake Run, turn right onto Last Quarter Dr., home is on the right.
General Property Description
# Bedrooms: 4
Baths - Full: 3
Total Baths: 3
SqFt - Living: 2758
SqFt - Source: Owner
Stories: 2
Approximate Age: < 1 Year
Property Condition: New Construction
Condition: New
Builder: Francez Builders LLC
Acres: 0.1
Acreage Range: 0 - 0.5
Assn Fee: Required
Assn Fee $: 500
Assn Fee Terms: Yearly
Lot Dimensions: 60X135
Mineral Rights: Conveyed
Pool on Subject Property: No
Parking
Garage Spaces: 2
Water Source
Water Company: Youngsville
Originating Details
Originating System ID: M00000300
Originating System Key: 20250911151544298185
Originating System Listing ID: 2500003337
Originating System Name: RAA Flex
Property Features
Style: French; Traditional
Levels: Two
Siding: Brick
Parking: Garage; Garage Faces Front
Construction: Frame
Foundation: Slab
Road Frontage: City Street
Roof: Composition
Interior: 9+ Ft Ceiling; Attic Access; Cathedral Ceiling; Computer Nook; Crown Molding; Double Vanity; Electric Dryer Con; Electric Stove Con; Electric Washer Con; Gas Stove Con; Kitchen Island; Primary Bath; Separate Shower; Special Bath; Standalone Tub; Varied Ceiling Heights; Vaulted Ceilings; Walk-In Closet(s)
Fireplace: 1 Fireplace; Other
Flooring: Laminate; Tile
Heating: Central; Electric
Cooling: Central Air
Appliances: Dishwasher; Disposal; Electric Range; Microwave; Plumbed For Ice Maker
Countertops: Granite
Security Features: Smoke Detector(s)
Fencing: Full; Wood; Other
Lot: Landscaped; Water Frontage
Patio: Covered; Open
Amenities: Park; Playground
Exterior: Outside Light
Other Structures: Storage
Waterfront: Frontage; Pond; View
Sewer: Public Sewer
Water Source: Public
Utilities: Elec: SLEMCO; Gas: Delta Utilities
HOA Includes: Ground Keeping; Recreation Facilities
Financing: Cash; Conventional
Documents: Property Disclosure; Property Disclosure
Flood Determination Disclosure ›Listing Office: Reliance Real Estate Group
Last Updated: September - 11 - 2025
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.