We Purchase, Trade, Consult & Market Residential & Commercial Real Estate

Delayed Marketing: No

List Price/SqFt: 211.17

Property Attached: No

Document Modified: 2026-01-28 15:48:42.397902

Status: Active

Listing Date: 2026-01-26

Listing Price: 465000

Current Price: $465,000

Type: Single Family Residence

Modification Timestamp: 2026-01-28T21:57:23Z

Photo Modified: 2026-01-28T21:48:42Z

Flood Zone: X

School District: Lafayette Parish

Legal Desc: Lot 110 of Detente Lakes Subdivision

Approximate Age: 4 - 5 Years

Lot Dimensions: 60x122.85x60

Stories: 1

SqFt - Living: 2202

SqFt - Source: Blueprint

SqFt - Total: 3382

Mineral Rights: Reserved

Assn Fee: Required

Assn Fee $: 500

Assn Fee Terms: Yearly

SqFt - Covered Porch: 632

SqFt - Garage: 548

Property Condition: Resale

Builder: Milton Hebert Constu

Acreage Range: 0 - 0.5

Pool on Subject Property: No

# Bedrooms: 4

Baths - Full: 2

Total Baths: 2

Year Built: 2022

Acres: 0.17

Remarks: This beautiful one-owner 4-bedroom 2-bath home built by Milton Hebert Construction offers quality craftsmanship and modern design in a bright, welcoming setting. The home is only five years old, which helps keep homeowner's insurance costs lower. It is located in flood zone X, so no flood insurance is usually required, which is a huge bonus for buyers. Step inside to an open and inviting layout featuring soft neutral colors, custom bathrooms, and elegant light fixtures throughout. The spacious split floor plan provides privacy with a stunning primary suite that includes a custom tiled shower, tiled flooring, and generous closet space. The kitchen is perfect for everyday living and entertaining with custom cabinetry, granite countertops, and stainless steel appliances. Enjoy your backyard entertaining space, complete with an outdoor fireplace and built-in refrigerator, making it ideal for hosting family and friends year-round. This well-maintained, move-in-ready home combines comfort, style, and quality construction in a highly desirable location. Schedule your private showing today and be one of the first to see this incredible home before it's gone.

REO: No

Traditional: 1

One: 1

Brick: 1

Hardiplank: 1

Stucco: 1

Garage Spaces: 2

Garage Door Opener: 1

Ceiling Fans: 1

Cable Available: 1

Paved: 1

Frame: 1

Slab: 1

Gas/Propane Grill: 1

Outside Light: 1

Porch: 1

Covered: 1

Open: 1

Fireplace: 1

2 Fireplaces: 1

Ventless: 1

Composition: 1

Central: 1

Electric: 1

9+ Ft Ceiling: 1

Attic Access: 1

Crown Molding: 1

Double Vanity: 1

Electric Dryer Con: 1

Electric Washer Con: 1

Gas Stove Con: 1

Kitchen Island: 1

Primary Bath: 1

Separate Shower: 1

Varied Ceiling Heights: 1

Walk-in Pantry: 1

Walk-In Closet(s): 1

Central Air: 1

Tile: 1

Wood Laminate: 1

Public Sewer: 1

Public: 1

Water Company: City of Youngsville

Dishwasher: 1

Disposal: 1

Gas Range: 1

Microwave: 1

Elec: SLEMCO: 1

Granite: 1

Dining Room: 1

Foyer: 1

Kitchen: 1

Living Room: 1

Primary Bathroom: 1

Primary Bedroom: 1

Utility Room: 1

Bedroom 2: 1

Bedroom 3: 1

Bedroom 4: 1

Property Disclosure: 1

Smoke Detector(s): 1

Full: 1

Wood: 1

Back Yard Access: 1

Landscaped: 1

Level: 1

Double Pane Windows: 1

Cash: 1

Conventional: 1

FHA: 1

Rural Development: 1

VA: 1

Ground Keeping: 1

Recreation Facilities: 1

Originating System ID: M00000300

Originating System Key: 20260126171452396768

Originating System Listing ID: 2600000373

Originating System Name: RAA Flex

Street Number: 406

Street Name: Last Quarter

St Suffix: Drive

Parish: Lafayette

State: LA

Zip Code: 70592

Subdivision: Detente Lakes

Area: P

Tax Assessment Number: 6171959

Zone: RES

Elementary School: Ernest Gallet

Middle School: Youngsville

High School: Southside

Directions: From Hwy 90turn onto Ambassador Caffery, then left onto Chemin Metairie Rd. Right on Detente Rd. Last Quarter is on the Right.