$547,500
Youngsville, LA 70592
MLS# 2500003331
4 beds | 3.1 baths
1 / 10
Property Description
Experience luxury living in this 4-bedroom, 3-bathroom waterfront gem, designed with professionally drawn house plans and nestled on a meticulously landscaped lot with captivating water views. The split floor plan highlights a gourmet kitchen with custom cabinets to the ceiling, Frigidaire Professional Series appliances, quartz countertops, and a spacious pantry. Elegant touches include custom molding, a gas fireplace, and premium Pfister, Delta, and Gerber plumbing fixtures. The outdoor kitchen, featuring a brick and granite design with a Coyote BBQ pit, sink, and mini fridge space, is perfect for gatherings. Plygem 1500 series windows, Duration shingles, and a large yard enhance this home's charm and waterfront allure.
Details
Documents
Listing Info
List Price/SqFt: 198.51
Property Attached: No
Document Modified: 2025-09-11 09:31:45.887679
Status: Active
Listing Date: 2025-09-11
Listing Price: 547500
Current Price: $547,500
Type: Single Family Residence
Modification Timestamp: 2025-09-22T13:59:07Z
Photo Modified: 2025-09-17T18:29:55Z
Location, Tax & Legal Info
Flood Zone: X
School District: Lafayette Parish
Legal Desc: LOT L-98 DETENTE LAKES PH II
General Property Description
Approximate Age: < 1 Year
Condition: New
Lot Dimensions: 60X135
Stories: 2
SqFt - Living: 2758
SqFt - Source: Owner
Mineral Rights: Conveyed
Assn Fee: Required
Assn Fee $: 500
Assn Fee Terms: Yearly
Property Condition: New Construction
Builder: Francez Builders LLC
Acreage Range: 0 - 0.5
Pool on Subject Property: No
# Bedrooms: 4
Baths - Full: 3
Baths - 1/2: 1
Total Baths: 3.1
Acres: 0.1
Remarks & Misc
Remarks: Experience luxury living in this 4-bedroom, 3-bathroom waterfront gem, designed with professionally drawn house plans and nestled on a meticulously landscaped lot with captivating water views. The split floor plan highlights a gourmet kitchen with custom cabinets to the ceiling, Frigidaire Professional Series appliances, quartz countertops, and a spacious pantry. Elegant touches include custom molding, a gas fireplace, and premium Pfister, Delta, and Gerber plumbing fixtures. The outdoor kitchen, featuring a brick and granite design with a Coyote BBQ pit, sink, and mini fridge space, is perfect for gatherings. Plygem 1500 series windows, Duration shingles, and a large yard enhance this home's charm and waterfront allure.
Office/Member/Contract Info
REO: No
Style
French: 1
Traditional: 1
Levels
Two: 1
Siding
Brick: 1
Parking
Garage: 1
Garage Spaces: 2
Garage Faces Front: 1
Equipment
Garage Door Opener: 1
Ceiling Fans: 1
Cable Available: 1
Fiber Available: 1
Road Frontage
City Street: 1
Construction
Frame: 1
Foundation
Slab: 1
Exterior
Outside Light: 1
Patio
Covered: 1
Open: 1
Fireplace
1 Fireplace: 1
Other: 1
Roof
Composition: 1
Heating
Central: 1
Electric: 1
Interior
9+ Ft Ceiling: 1
Attic Access: 1
Cathedral Ceiling: 1
Computer Nook: 1
Crown Molding: 1
Double Vanity: 1
Electric Dryer Con: 1
Electric Stove Con: 1
Electric Washer Con: 1
Gas Stove Con: 1
Kitchen Island: 1
Primary Bath: 1
Separate Shower: 1
Special Bath: 1
Standalone Tub: 1
Varied Ceiling Heights: 1
Vaulted Ceilings: 1
Walk-In Closet(s): 1
Cooling
Central Air: 1
Flooring
Laminate: 1
Tile: 1
Sewer
Public Sewer: 1
Water Source
Public: 1
Water Company: Youngsville
Appliances
Dishwasher: 1
Disposal: 1
Electric Range: 1
Microwave: 1
Plumbed For Ice Maker: 1
Utilities
Elec: SLEMCO: 1
Gas: Delta Utilities: 1
Countertops
Granite: 1
Waterfront
Frontage: 1
Pond: 1
View: 1
Documents
Property Disclosure: 1
Amenities
Park: 1
Playground: 1
Security Features
Smoke Detector(s): 1
Fencing
Full: 1
Wood: 1
Other: 1
Lot
Landscaped: 1
Water Frontage: 1
Other Structures
Storage: 1
Financing
Cash: 1
Conventional: 1
HOA Includes
Ground Keeping: 1
Recreation Facilities: 1
Originating Details
Originating System ID: M00000300
Originating System Key: 20250911141859982817
Originating System Listing ID: 2500003331
Originating System Name: RAA Flex
Location Tax Legal Info
Street Number: 403
Street Name: Last Quarter
St Suffix: Drive
Parish: Lafayette
State: LA
Zip Code: 70592
Subdivision: Detente Lakes
Area: P
Tax Assessment Number: 6171947
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.
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
Floor Plan Listing Office: Reliance Real Estate Group
Last Updated: September - 22 - 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.
GUIDRY & CO. REAL ESTATE, Lafayette, LA. All offices are independently owned and operated. 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 GUIDRY & CO. REAL ESTATE are marked with the MLS approved icon for
IDX
. “Information Deemed Reliable But Not Guaranteed”. Copyright 2016 REALTOR® Association of Acadiana, All rights reserved.
Licensed & Regulated in the jurisdiction of the Louisiana Real Estate Commission, Members of the National Association of Realtors®, Louisiana Realtors®, Realtor® Association of Acadiana, Multiple Listing Service (MLS), Louisiana Commercial (www.lacdb.com), The Realtor® Commercial Alliance, Equal Housing Opportunity.