Skip main navigation
Off market
  • $399,300

    400 Last Quarter Dr, Youngsville, LA 70592

    4beds
    2,128sqft
    SingleFamily
    Built in 2022
    8,276 Square Feet Lot
    $399,300 Zestimate®
    $188/sqft
    $2,503 Estimated rent

    Home value

    $399,300

    $379,000 - $423,000

    $2,503/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $2,503/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $2,503/mo

    Rent Zestimate®

    Refinance and save

    $2,296/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $2,296/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Your Dream Home has officially arrived! Welcome to 400 Last Quarter Dive, a brand new build by the AHBA 2019 Builder of the Year, Schoeffler Built Homes. Situated on a corner lot in the highly sought after Southside development of Detente Lakes, this stunning home features a spacious 2,128 sqft triple split floor plan that includes 4 bedrooms, 3 full baths, and all of the bells and whistles youve come to expect from a Schoeffler Built home, plus more! Upon entering the home, the inviting foyer leads you into the heart of the home, the large open living/ kitchen and dining area. Your attention will be immediately drawn to the soaring vaulted ceilings in the living room and the patio views from the large energy-efficient windows, all offering an abundance of natural light.Youll find gorgeous wood beam accents over the entryways, beautiful custom crown molding, a modern designer color palette, luxury vinyl plank wood flooring, and the centerpiece of the room, the huge custom ventless gas fireplace. Designed with entertaining in mind the spacious living area opens directly to the magnificent Chefs kitchen, a dream area to cook in with a large eat-in furniture-style island, stainless appliances with a gas range/oven, custom pull-out spice/storage racks, granite countertops, tile backsplash, a pot-filler, and a stainless under-mount sink with a large window above! Off of the kitchen is a wonderful bar area with pantry access, a space for the wine fridge, and custom wine glass & bottle storage, and direct access to the dining room offering a truly wonderful space for your next dinner party. The primary suite features a spacious bedroom with a tray ceiling, large windows offering great natural light, and a personal bathroom oasis with dual vanity areas, a make-up counter/sitting area, a large freestanding soaking tub, and a huge tiled walk-in shower, and a massive walk-in closet. In the front of the home off of the foyer, youll find two of the guest bedrooms that share a hall bath with a tiled tub/shower combo. The 4th bedroom can be found off of the living room and also offers easy access to a full bathroom. Outside is a large covered patio area with a built-in fireplace, a custom TV storage cabinet, and an outdoor grilling area that will feature a gas grill, sink, and space for a beverage cooler! Youll enjoy spending time outside in the large backyard, especially for BBQs and the next Saints games! Detente Lakes includes multiple subdivision lakes with gazebos available for you to enjoy at your leisure! All this and more, in a location that is second to none...only about 1.5 miles to the Youngsville Sports Complex, and only around 3 miles away from the great shopping at Rouses and the restaurants & bars at Metairie Centre! Did we also mention that this home is located in the Southside High School District!!! You do not want to miss out on this one as it is an absolute must-see that will not last long! Contact us today to set up an appointment. Feel the Quality...Afford the Luxury with Schoeffler Built Homes! Builder offering $2000 in Builder Incentives at closing. Lender Credit is available with the use of the Preferred Lender.

    This property is not currently displayed as for sale or rent on Zillow. This may be different from what's on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 3
    • Full bathrooms: 3
    Heating
    • Other
    Cooling
    • Central
    Appliances
    • Included: Garbage disposal, Microwave, Washer
    Features
    • Flooring: Tile, Linoleum / Vinyl
    Interior area
    • Total interior livable area: 2,128 sqft

    Property

    Lot
    • Size: 8,276 Square Feet
    Details
    • Parcel number: 6171956

    Construction

    Type & style
    • Home type: SingleFamily
    Materials
    • Roof: Composition
    Condition
    • Year built: 2022

    Community & HOA

    Location
    • Region: Youngsville

    Financial & listing details

    • Price per square foot: $188/sqft
    • Tax assessed value: $407,600
    • Annual tax amount: $3,980

    Price history

    DateEventPrice
    3/22/2023Sold--
    Source: RAA #22005080 Report a problem
    2/24/2023Pending sale$438,000$206/sqft
    Source: RAA #22005080 Report a problem
    2/6/2023Price change$438,000-1.1%$206/sqft
    Source: RAA #22005080 Report a problem
    6/1/2022Listed for sale$443,000$208/sqft
    Source: RAA #22005080 Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2024$3,980 +599.2%$40,760 +602.8%
    2023$569 0%$5,800
    2022$569 $5,800
    Find assessor info on the county website

    Neighborhood: 70592

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: G T Lindon
    • Middle: Youngsville
    • High: Southside

    Source: The MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get pre-qualified for a loan
    At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.

    An equal housing lender. NMLS #10287.

    Sell for more on Zillow
    Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
    $399,300
    2% more
    +$7,986
    With Zillow Showcase(estimated)
    $407,286