407 Last Quarter Drive, Youngsville, LA 70592 (MLS # 2500003337)
Twitter
Facebook
Email
|
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.
| DAYS ON MARKET | 3 | LAST UPDATED | 9/11/2025 |
|---|---|---|---|
| TRACT | Detente Lakes | YEAR BUILT | 0 |
| COMMUNITY | P | GARAGE SPACES | 2.0 |
| COUNTY | Lafayette | STATUS | Active |
| PROPERTY TYPE(S) | Single Family |
| Elementary School | Ernest Gallet |
|---|---|
| Jr. High School | Youngsville |
| High School | Southside |
| ADDITIONAL DETAILS | |
| AIR | Central Air |
|---|---|
| AIR CONDITIONING | Yes |
| AMENITIES | Maintenance Grounds |
| APPLIANCES | Dishwasher, Disposal, Electric Range, Microwave |
| AREA | P |
| CONSTRUCTION | Brick Veneer, Frame |
| EXTERIOR | Lighting |
| FIREPLACE | Yes |
| GARAGE | Yes |
| HEAT | Central, Electric |
| HOA DUES | 500 |
| INTERIOR | Cathedral Ceiling(s), Crown Molding, Double Vanity, Granite Counters, High Ceilings, Kitchen Island, Vaulted Ceiling(s), Walk-In Closet(s) |
| LOT | 4356 sq ft |
| LOT DESCRIPTION | Landscaped, Waterfront |
| LOT DIMENSIONS | 60 x 135 |
| PARKING | Garage, Garage Faces Front |
| SEWER | Public Sewer |
| STORIES | 2 |
| STYLE | French, Traditional |
| SUBDIVISION | Detente Lakes |
| VIEW | Yes |
| VIEW DESCRIPTION | Water |
| WATERFRONT | Yes |
| WATERFRONT DESCRIPTION | Waterfront, Pond |
MORTGAGE CALCULATOR
TOTAL MONTHLY PAYMENT
0
P
I
*Estimate only
Listed with Reliance Real Estate Group
The data relating to real estate for sale on this web site comes in part from the IDX Program of the Realtor® Association of Acadiana’ MLS. Real Estate listings held by brokerage firms other than Dwight Andrus Real Estate Agency, LLC are marked with the MLS approved icon for IDX (a little black house).
IDX information is provided exclusively for consumers’ personal, non-commercial use, that it 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.
Copyright 2025 REALTOR® Association of Acadiana MLS. All rights reserved
This IDX solution is (c) Diverse Solutions 2025.
| SATELLITE VIEW |
| / | |
We respect your online privacy and will never spam you. By submitting this form with your telephone number
you are consenting for Matt
Andrus to contact you even if your name is on a Federal or State
"Do not call List".