306 Last Quarter Drive, Youngsville, LA 70592
$499,000
Property Type:
Residential
Bedrooms:
4
Baths:
3
Square Footage:
2,324
Lot Size (sq. ft.):
7,405
Status:
Active
Current Price:
$499,000
List Date:
3/27/2026
Last Modified:
4/27/2026
Listing Details MLS# 2600002533
Listing Info
- Delayed Marketing
- No
- Listing Price
- 499000
- List Price/SqFt
- 214.72
- Type
- Single Family Residence
- Property Attached
- No
- Document Modified
- 2026-03-31 11:18:21.283445
- Modification Timestamp
- 2026-04-27T06:48:34Z
- Photo Modified
- 2026-03-27T13:20:31Z
Location Tax Legal Info
- Street Number
- 306
- Street Name
- Last Quarter
- St Suffix
- Drive
- Parish
- Lafayette
- State
- LA
- Zip Code
- 70592
- Subdivision
- Detente Lakes
- Area
- P
- Tax Assessment Number
- 6171954
- Elementary School
- G T Lindon
- Middle School
- Youngsville
- High School
- Southside
- Directions
- Take Chemin Metairie into Youngsville- go toward the sports complex but stay on Chemin Metairie. Detente Road is across from one of the entrances to the sports complex- take Detente road all the way down. Take a left into the subdivision on Big Lake Run. Go all the way down to the back of the subdivision, Last Quarter is the last street on the right. The house is second to last one on the left
General Property Description
- # Bedrooms
- 4
- Baths - Full
- 3
- Total Baths
- 3
- SqFt - Living
- 2324
- SqFt - Source
- Appraiser
- Stories
- Yes
- Approximate Age
- 4 - 5 Years
- Property Condition
- Resale
- Condition
- Excellent
- Acres
- 0.17
- Acreage Range
- 0 - 0.5
- Assn Fee
- Required
- Assn Fee $
- 500
- Assn Fee Terms
- Yearly
- Lot Dimensions
- 60X120
- Mineral Rights
- Reserved
- Pool on Subject Property
- No
Parking
- Garage Spaces
- 2
Water Source
- Water Company
- City of Youngsville
Originating Details
- Originating System ID
- M00000300
- Originating System Key
- 20260326134319541436
- Originating System Listing ID
- 2600002533
- Originating System Name
- RAA Flex
More Information
Location, Tax & Legal Info
- Flood Zone
- X
- School District
- Lafayette Parish
- Legal Desc
- LOT L-105 DETENTE LAKES PH II
Remarks & Misc
- Remarks
- Fabulous home built by Milton Hebert in 2022 that is better than new and enhanced by the homeowner in all the ways that would cost you thousands to do on a new construction. Plantation shutters, custom blinds and drapes, Omega concrete coating in the garage and the back patio, gutters, 24/7 (not just motion activated) cameras, security system, tv mounts in every room, and one of the best parts- the prettiest greenest grass in your front yard. Seller just had the front yard re-graded and re-sodded with Cobalt Grass. This unique blade has a rich, deep green color and is drought tolerant. It is described as a hybrid turfgrass and built for warmer climates. About the inside of the house- it is a 4 bedroom, 3 bath triple split floorpan- PLUS OFFICE. Kitchen is open to the living and dining rooms. Endless supply of kitchen cabinets plus large pantry and large broom closet in the laundry room. Primary bath is large and features soaking tub and large shower. Exiting the home onto the back patio- enjoy the sitting area with gas log fireplace and outdoor kitchen with grill and mini fridge. Flood zone X, never flooded. Open this Sunday from 3- 4:30- come tour 306 Last Quarter where the grass really is greener on the other side. HOA is $500/year- it includes upkeep at front entrance and ponds. Slemco is electricity provider and averages $150 - 250/mo. City of Youngsville for water and trash and averages $140/month. Centerpoint for gas and averages $50/month. Two fireplaces, central heat and TWO water heaters are all gas. Preferred lender, Nicholas Richard with CrossCountry Mortgage, will contribute up to a $3,000 credit to be used towards cash to close or a 1-0 temporary buydown, reducing the buyer's interest rate by 1% for the first year--lower monthly payments to help ease into homeownership!
Office/Member/Contract Info
- REO
- No
Style
- Traditional
- Yes
Levels
- One
- Yes
Siding
- Brick
- Yes
- Hardiplank
- Yes
Equipment
- Ceiling Fans
- Yes
Foundation
- Slab
- Yes
Exterior
- Gas/Propane Grill
- Yes
- Outside Kitchen
- Yes
- Outside Light
- Yes
Patio
- Covered
- Yes
Fireplace
- 2 Fireplaces
- Yes
- Ventless
- Yes
Roof
- Composition
- Yes
Heating
- Electric
- Yes
- Natural Gas
- Yes
Interior
- 9+ Ft Ceiling
- Yes
- Crown Molding
- Yes
- Electric Dryer Con
- Yes
- Kitchen Island
- Yes
- Primary Bath
- Yes
- Separate Shower
- Yes
- Standalone Tub
- Yes
- Varied Ceiling Heights
- Yes
- Walk-in Pantry
- Yes
- Walk-In Closet(s)
- Yes
- Window Treatments
- Yes
Cooling
- Central Air
- Yes
Flooring
- Tile
- Yes
Sewer
- Public Sewer
- Yes
Appliances
- Built-In Gas Oven
- Yes
- Dishwasher
- Yes
- Disposal
- Yes
- Gas Cooktop
- Yes
- Microwave
- Yes
Utilities
- Elec: SLEMCO
- Yes
Countertops
- Granite
- Yes
Waterfront
- Pond
- Yes
- Walk To
- Yes
Security Features
- Security System Owned
- Yes
- Smoke Detector(s)
- Yes
Fencing
- Full
- Yes
- Privacy
- Yes
- Wood
- Yes
Lot
- Landscaped
- Yes
Window Features
- Double Pane Windows
- Yes
Financing
- Cash
- Yes
- Conventional
- Yes
- FHA
- Yes
- VA
- Yes
Reserved Item
- Gas Logs
- Yes
- Other - See Remarks
- Yes
HOA Includes
- Ground Keeping
- Yes
Property Features
Style:
Traditional
Levels:
One
Siding:
Brick; Hardiplank
Foundation:
Slab
Roof:
Composition
Interior:
9+ Ft Ceiling; Crown Molding; Electric Dryer Con; Kitchen Island; Primary Bath; Separate Shower; Standalone Tub; Varied Ceiling Heights; Walk-in Pantry; Walk-In Closet(s); Window Treatments
Fireplace:
2 Fireplaces; Ventless
Flooring:
Tile
Heating:
Electric; Natural Gas
Cooling:
Central Air
Appliances:
Built-In Gas Oven; Dishwasher; Disposal; Gas Cooktop; Microwave
Countertops:
Granite
Security Features:
Security System Owned; Smoke Detector(s)
Fencing:
Full; Privacy; Wood
Lot:
Landscaped
Patio:
Covered
Exterior:
Gas/Propane Grill; Outside Kitchen; Outside Light
Window Features:
Double Pane Windows
Waterfront:
Pond; Walk To
Sewer:
Public Sewer
Utilities:
Elec: SLEMCO
HOA Includes:
Ground Keeping
Reserved Item:
Gas Logs; Other - See Remarks
Financing:
Cash; Conventional; FHA; VA
Property Disclosure ›
IDX
Listing Office:
Dwight Andrus Real Estate Agency, LLC
Last Updated: April - 27 - 2026
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.