NOT LISTED FOR SALE

409 Last Quarter Dr Youngsville, LA 70592

Estimated Value: $533,000 - $545,625

4 Beds
3 Baths
2,608 Sq Ft
$207/Sq Ft Est. Value

Last Sold February 21, 2025

Current estimated payment $3,083/month

188 Days on Market

Highlights

  • Lake Front
  • Nearby Water Access
  • Freestanding Bathtub
  • Green T. Lindon Elementary School Rated A-
  • Deck
  • Traditional Architecture

About This Home

As of February 2025

Loved the Francez Builder's 2024 Parade Home? Here's your chance to grab the highly sought after floor plan again - with a few changes you won't want to miss. The best part? This home is now complete and ready for its new owners! This latest creation by Francez Builders includes all of the amenities that makes its homes so popular. To fully appreciate the beauty, quality, and fantastic location of this home, come by and take a look!We think you will appreciate its many features: ML Murphy Design Group plan, professionally decorated, tile and 100% waterproof vinyl plank flooring, high/specialty ceilings, specialty LED energy efficient lighting features, marble slab countertops, full kitchen backsplash, GE stainless appliances, gas range-top, walk-in pantry, custom cypress mantel, 2 separate vanities flanking either side of the master bath, Jacuzzi freestanding soaker tub, unique tile shower, covered patio, outdoor kitchen, private deck overlooking the pond, privacy-fenced backyard, professional landscaping/sod, 8-foot tall garage door, low VOC paint, 14SEER Rheem AC, energy efficient, low-e windows, all brick for low maintenance, hurricane straps, wind-rated shingles, and Flood Zone X. You don't want to miss this one! We think you will appreciate its many features: ML Murphy Design Group plan, professionally decorated, tile and 100% waterproof vinyl plank flooring, high/specialty ceilings, specialty LED energy efficient lighting features, marble slab countertops, full kitchen backsplash, GE stainless appliances, gas range-top, walk-in pantry, ventless gas fireplace, custom cypress mantel, 2 separate vanities flanking either side of the master bath, Jacuzzi freestanding soaker tub, unique tile shower, dual shower heads, covered patio, outdoor kitchen, privacy-fenced backyard, professional landscaping/sod, 8-foot tall garage door, low VOC paint, 14SEER Rheem AC, energy efficient, low-e windows, all brick for low maintenance, hurricane straps, wind-rated shingles, and Flood Zone X. You don't want to miss this one!

Last Agent to Sell the Property

Alexis Gibbens

Keaty Real Estate Team Listed on: 07/24/2024

Co-Listed By

Ashley Lombas

Keaty Real Estate Team License #995713539

Last Buyer's Agent

Tony Dozart

EXP Realty, LLC License #995711768

EXP Realty, LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $646

Year Built

  • Built in 2024

Lot Details

  • 9,583 Sq Ft Lot
  • Lot Dimensions are 70.05 x 135 x 70 x 135
  • Lake Front
  • Property is Fully Fenced
  • Privacy Fence
  • Wood Fence

HOA Fees

  • $42 Monthly HOA Fees

Parking

  • 2 Car Garage
  • Open Parking

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Slab Foundation
  • Frame Construction
  • Composition Roof

Interior Spaces

  • 2,608 Sq Ft Home
  • 2-Story Property
  • Crown Molding
  • High Ceiling
  • Gas Fireplace
  • Water Views

Kitchen

  • Walk-In Pantry
  • Gas Cooktop
  • Dishwasher
  • Kitchen Island
  • Stone Countertops
  • Disposal

Flooring

  • Tile
  • Vinyl Plank

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • 3 Full Bathrooms
  • Double Vanity
  • Freestanding Bathtub
  • Multiple Shower Heads
  • Separate Shower

Outdoor Features

  • Nearby Water Access
  • Deck
  • Covered patio or porch
  • Outdoor Kitchen
  • Exterior Lighting

Schools

  • G T Lindon Elementary School
  • Youngsville Middle School
  • Southside High School

Utilities

  • Central Heating and Cooling System

Community Details

  • Association fees include ground maintenance, - see remarks
  • Detente Lakes Subdivision

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Tax Lot 95

Home Details

Home Type

Single Family

Est. Annual Taxes

$646

Year Built

Built in 2024

Lot Details

0

HOA Fees

$42 per month

Parking

2

Listing Details

  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.22
  • Lot Size: 70.05 x 135 x 70 x 135
  • Road Frontage Type: Paved
  • Co List Office Mls Id: l000932
  • Co List Office Phone: 337-235-7770
  • Subdivision Name: Detente Lakes
  • Directions: From Hwy 90 turn onto Ambassador Caffery Pkwy., turn left onto Chemin Metairie Rd., turn right onto Detente Rd., subdivision will be on the left. Take a left onto Big Lake Run, home is on the right.
  • Architectural Style: Traditional
  • Carport Y N: No
  • Garage Yn: Yes
  • New Construction: No
  • Building Stories: 2
  • Year Built: 2024
  • Special Features: 4098
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Appliances: Dishwasher, Disposal, Gas Cooktop
  • Full Bathrooms: 3
  • Total Bedrooms: 4
  • Fireplace Features: 1 Fireplace, Gas
  • Fireplaces: 1
  • Fireplace: Yes
  • Flooring: Tile, Vinyl Plank
  • Interior Amenities: High Ceilings, Crown Molding, Double Vanity, Kitchen Island, Multi-Head Shower, Separate Shower, Standalone Tub, Varied Ceiling Heights, Walk-in Pantry, Walk-In Closet(s), Stone Counters
  • Living Area: 2608

Exterior Features

  • Fencing: Full, Privacy, Wood
  • Lot Features: 0 to 0.5 Acres, Views, Waterfront
  • Pool Private: No
  • View: Water
  • View: Yes
  • Waterfront Features: Lake, Walk To
  • Waterfront: Yes
  • Home Warranty: Yes
  • Construction Type: Brick Veneer, Frame
  • Exterior Features: Outdoor Kitchen, Lighting
  • Foundation Details: Slab
  • Other Structures: Outdoor Kitchen, See Remarks
  • Patio And Porch Features: Covered, Deck, Open
  • Roof: Composition

Garage/Parking

  • Covered Parking Spaces: 2
  • Garage Spaces: 2
  • Open Parking: Yes
  • Parking Features: Garage, Garage Faces Front
  • Total Parking Spaces: 2

Utilities

  • Cooling: Central Air
  • Cooling Y N: Yes
  • Heating: Central
  • Heating Yn: Yes
  • Electric: Elec: SLEMCO
  • Electricity On Property: Yes
  • Sewer: Public Sewer
  • Gas Company: Gas: Delta Utilities

Condo/Co-op/Association

  • Community Features: Other
  • Association Fee: 500
  • Association Fee Frequency: Annually
  • Association: Yes

Fee Information

  • Association Fee Includes: Maintenance Grounds, Other - See Remarks

Schools

  • Elementary School: G T Lindon
  • Junior High Dist: Lafayette Parish
  • High School: Southside
  • Middle Or Junior School: Youngsville

Lot Info

  • Lot Size Sq Ft: 9583.2

Tax Info

  • Tax Lot: 95

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 24, 2024
Closed on
Feb 21, 2025
Sold by
Francez Builders Llc
Bought by
Bordelon Kevin J
Seller's Agent
Alexis Gibbens
Keaty Real Estate Team
Buyer's Agent
Tony Dozart
EXP Realty, LLC
List Price
$515,000
Sold Price
$535,000
Premium/Discount to List
$20,000
3.88%
Views
928
Current Estimated Value
$539,156

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$4,156
Avg. Annual Appreciation
-0.25%
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Bordelon Kevin J $535,000 None Listed On Document
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/21/2025 02/21/25 Sold -- -- --
01/28/2025 01/28/25 Pending -- -- --
07/24/2024 07/24/24 For Sale $515,000 -- $197 / Sq Ft
Source: REALTOR® Association of Acadiana

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $646 $6,617 $6,617 $0
2023 $646 $6,617 $6,617 $0
2022 $325 $3,308 $3,308 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: REALTOR® Association of Acadiana

MLS Number: 24006976

REALTOR® Association of Acadiana

APN: 6171944