$615,000
$48K PRICE DROP

Estimated payment $3,818/month

Total Views 25,567
4 Beds
3.5 Baths
2,500 Sq Ft
$246 Price per Sq Ft

Highlights

  • Lake Front
  • Nearby Water Access
  • Medical Services
  • Ernest Gallet Elementary School Rated A-
  • Fitness Center
  • 2-minute walk to Bella Vista Park

About This Home

NOW OFFERING 15K VALUE 6 seater premium GOLF CART Included in the sale of home! Standout is a .11 acre Yard ( big enough for pool) and a Golf Cart Garage. Gorgeous one owner custom built home in amenity-rich Sugar Mill Pond where life is truly sweeter! LOCATION is amazing just across from Palfrey Park , and just a walk across to El Paso, Rouse's, Andy's. Freshly painted interior and exterior of home with updates such as new flooring upstairs and new light fixtures. Living room is light , bright and airy with a relaxed coastal feel with it's tall vaulted ceilings complete with plantation shutters and a beautiful fireplace in the center. This spacious layout offers 4 bedrooms and 3.5 baths, plus a dedicated doggie room and multiple added storage closets the sellers thoughtfully added , perfect for staying organized and keeping everything in its place.Outdoor living shines with new tile on both the front porch and back patio, and a spacious rear patio with a cozy fireplace, ideal for relaxing or entertaining year round. The oversized 2.5-car garage provides room for large vehicles, extra storage, and golf carts.Enjoy the Sugar Mill Pond lifestyle with the ability to walk, bike, or take a golf cart to gyms, parks, green spaces, and the pond, plus nearby favorites like Rouses and Andy's, along with boutiques and trendy eats. Subdivision amenities include gyms, parks, pond, green spaces, and nighttime security with monthly alarm monitoring. A must-see in one of Youngsville's most loved communities!

Listing Agent

Lulu David

Lulu David Real Estate Co LLC License #0995692446 Listed on: 01/13/2026

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2012

Lot Details

  • 21,780 Sq Ft Lot
  • Lot Dimensions are 41.81 x 116 x 41.63 x 116
  • Lake Front
  • Property is Fully Fenced
  • Privacy Fence
  • Wood Fence
  • Landscaped

HOA Fees

  • $137 Monthly HOA Fees

Parking

  • 2.5 Car Garage
  • Rear-Facing Garage
  • Open Parking

Home Design

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

Interior Spaces

  • 2,500 Sq Ft Home
  • 2-Story Property
  • Crown Molding
  • Vaulted Ceiling
  • 1 Fireplace
  • Double Pane Windows
  • Plantation Shutters

Kitchen

  • Microwave
  • Dishwasher
  • Granite Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • In-Law or Guest Suite
  • Separate Shower

Outdoor Features

  • Nearby Water Access
  • Covered Patio or Porch
  • Outdoor Kitchen
  • Exterior Lighting

Schools

  • Ernest Gallet Elementary School
  • Youngsville Middle School
  • Southside High School

Utilities

  • Central Heating and Cooling System

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Tax Lot F-17

Community Details

Overview

  • Association fees include ground maintenance
  • Sugar Mill Pond Subdivision

Amenities

  • Medical Services
  • Shops

Recreation

  • Recreation Facilities
  • Community Playground
  • Fitness Center
  • Community Pool
  • Park

Home Details

Home Type

Single Family

Year Built

Built in 2012

Lot Details

0.5 Acres

HOA Fees

$137 per month

Parking

2

Listing Details

  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.5
  • Lot Size: 41.81 x 116 x 41.63 x 116
  • Road Frontage Type: City Street
  • Subdivision Name: Sugar Mill Pond
  • Directions: Ambassador Caffrey towards Verot. Right on Verot School Road, first round about go around and take the E. Milton/Hwy 92. Take a right on Chemin Metairie (at the Walgreens round about). Take a left on Stonehurst and a right on Harbor.
  • Architectural Style: Coastal, Modern, Traditional
  • Carport Y N: No
  • Garage Yn: Yes
  • Building Stories: 2
  • Year Built: 2012
  • List_136: 92.012747
  • Special Features: None
  • Stories: 2

Interior Features

  • Appliances: Dishwasher, Disposal, Gas Range, Microwave, Refrigerator
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Fireplace Features: 1 Fireplace
  • Fireplaces: 1
  • Fireplace: Yes
  • Flooring: Carpet, Tile, Wood
  • Interior Amenities: High Ceilings, Crown Molding, Guest Suite, Separate Shower, Varied Ceiling Heights, Walk-In Closet(s), Granite Counters
  • Living Area: 2500
  • Window Features: Double Pane Windows

Exterior Features

  • Fencing: Full, Privacy, Wood
  • Lot Features: 0 to 0.5 Acres, Landscaped
  • Pool Private: No
  • Waterfront Features: Lake, Walk To
  • Disclosures: Property Disclosure
  • Home Warranty: Yes
  • Construction Type: Brick Veneer, Stucco, Frame
  • Exterior Features: Outdoor Kitchen, Lighting
  • Foundation Details: Slab
  • Patio And Porch Features: Covered, Porch
  • Property Condition: Resale
  • Roof: Composition

Garage/Parking

  • Covered Parking Spaces: 2.5
  • Garage Spaces: 2.5
  • Open Parking: Yes
  • Parking Features: Garage, Garage Faces Rear
  • Total Parking Spaces: 2.5

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: Pool, Fitness Center, Medical Facility, Park, Playground, Shopping/Mall
  • Amenities: Recreation Facilities
  • Association Fee: 410
  • Association Fee Frequency: Quarterly
  • Association: Yes

Fee Information

  • Association Fee Includes: Maintenance Grounds

Schools

  • Elementary School: Ernest Gallet
  • Junior High Dist: Lafayette Parish
  • High School: Southside
  • Middle Or Junior School: Youngsville

Lot Info

  • Lot Size Sq Ft: 21780

Tax Info

  • Tax Lot: F-17

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
2025 $3,652 $37,859 $5,000 $32,859
2024 $3,046 $37,859 $5,000 $32,859
2023 $3,046 $36,642 $5,000 $31,642
2022 $3,239 $32,991 $5,000 $27,991
2021 $3,250 $32,991 $5,000 $27,991
2020 $3,248 $32,991 $5,000 $27,991
2019 $2,101 $32,991 $5,000 $27,991
2018 $2,533 $32,991 $5,000 $27,991
2017 $2,530 $32,991 $5,000 $27,991
2015 $2,290 $30,557 $5,000 $25,557
2013 -- $30,557 $5,000 $25,557
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
04/27/2026 04/27/26 Price Changed $615,000 -5.4% $246 / Sq Ft
03/17/2026 03/17/26 Price Changed $649,900 -2.0% $260 / Sq Ft
01/30/2026 01/30/26 For Sale $663,000 -- $265 / Sq Ft
Source: REALTOR® Association of Acadiana

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Cash Sale Deed $334,880 None Available
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Loan Amount Loan Type
Open $332,000 New Conventional
Closed $360,000 New Conventional
Closed $311,880 New Conventional
Source: Public Records

About the Listing Agent

Lulu David

Lulu David Real Estate Co LLC

(337) 495-4159

Section Image

To say I love everything about Acadiana would be an understatement. I was born and raised here and have proudly called Acadiana home for over 42 years. The people, culture, sense of community, and joie de vivre found here are truly unmatched. It is, and always will be, the place I’m proud to call home.

As a graduate of the University of Louisiana at Lafayette with a Bachelor’s degree in Design and Merchandising, I’ve always had a passion for homes, design, and helping people create

Lulu's Other Listings

  • 805 Waterview Rd, Youngsville, LA 70592

    $945,000 Open Wed 11AM - 1PM

    • 5 Beds
    • 3.5 Baths
    • 3,380 Sq Ft
    • 805 Waterview Rd
    • Youngsville, LA

    POOL, CORNER LOT. 5 BEDROOMS plus an OFFICE! WALK to Palfrey Park in your backyard without the maintenance of all the green space. Welcome to this beautifully maintained, one-owner custom-built home situated on a desirable corner lot in the heart of Sugar Mill Pond. Designed with timeless curb appeal, the home welcomes you with an expansive front porch, impressive second-story balcony, and a

    Lulu David Lulu David Real Estate Co LLC

    Section Image
  • 406 Waterview Rd, Youngsville, LA 70592

    $585,000

    • 4 Beds
    • 2.5 Baths
    • 2,250 Sq Ft
    • 406 Waterview Rd
    • Youngsville, LA

    Tucked away in one of the most peaceful pockets of Sugar Mill Pond, 406 Waterview Road overlooks the common green space with beautiful canopies of mature trees and walking and biking paths, surrounded by the quiet charm of an established neighborhood setting. Enjoy the feeling of an expansive front yard without the maintenance, evening walks, bike rides, and a slower pace just beyond your front

    Lulu David Lulu David Real Estate Co LLC

    Section Image
  • 604 Gunter Grass Ct, Lafayette, LA 70508

    $7,000,000 New Construction

    • 6 Beds
    • 9 Baths
    • 8,486 Sq Ft
    • 604 Gunter Grass Ct
    • Lafayette, LA

    Set behind private gates, 604 Gunter Grass Court is a one-of-a-kind estate where refined design, privacy, and modern wellness come together. Offered fully furnished with a curated Restoration Hardware furniture package, this exceptional residence was designed not simply as a home, but around the way life is meant to be lived.At the heart of the estate is a private wellness experience rarely found

    Lulu David Lulu David Real Estate Co LLC

    Section Image
  • 125 E Edith Rd, Lafayette, LA 70508

    $925,000 $74K PRICE DROP

    • 4 Beds
    • 2.5 Baths
    • 2,703 Sq Ft
    • 125 E Edith Rd
    • Lafayette, LA

    NEW PRICE | $925,000 The new price gives the next owner even more flexibility to personalize the property whether completing the third bath, adding a pool, or simply enjoying everything already here. An incredible opportunity to own 2.628 acres with a beautifully Updated Custom home + Acreage ( No Restrictions) and an exceptional detached 30x75 Workshop + Entertaining space in one of South

    Lulu David Lulu David Real Estate Co LLC

    Section Image
  • 215 Renee Ave, Lafayette, LA 70503

    $585,000 Pending

    • 3 Beds
    • 2.5 Baths
    • 2,485 Sq Ft
    • 215 Renee Ave
    • Lafayette, LA

    Located just off West Bayou Parkway in one of Lafayette's most desirable and established areas and zoned for Woodvale Elementary, this beautifully reimagined home pairs the character of an established property with the updates and amenities of newer construction.Completely renovated in 2020, the extensive transformation included a new roof, new HVAC system, new water heater, an added garage,

    Lulu David Lulu David Real Estate Co LLC

    Section Image
  • 406 Annaberg Dr, Youngsville, LA 70592

    $598,000 Sold Jun 18, 2026

    • 4 Beds
    • 3 Baths
    • 2,386 Sq Ft
    • 406 Annaberg Dr
    • Youngsville, LA

    There is NO OTHER Home on Market with POOL FULLY RENOVATED! Stunning fully renovated 2025 home on a prime CORNER lot in Sugar Mill Pond, featuring custom high-end finishes and appliances, a fabulous floor plan, and an exceptional private backyard oasis with an amazing pool and Large garage to fit Golf Cart too and storage. This beautifully updated 4-bedroom, 3 full bath home with a dedicated

    Lulu David Lulu David Real Estate Co LLC

  • 304 Bella Vista Pkwy, Youngsville, LA 70592

    $825,000 Sold Apr 24, 2026

    • 4 Beds
    • 3.5 Baths
    • 2,752 Sq Ft
    • 304 Bella Vista Pkwy
    • Youngsville, LA

    Homes with this kind of setting don't come around often. Located on Palfrey Park in Sugar Mill Pond, this gorgeous Custom Built home welcomes you with a spacious front patio and perfect for taking in the park views and the rhythm of the neighborhood.Step inside to a large foyer that opens into an airy, open-concept living and kitchen space featuring antique beams, built-in shelving, and a

    Lulu David Lulu David Real Estate Co LLC

  • 305 Annaberg Dr, Youngsville, LA 70592

    $550,000 Sold Dec 09, 2025

    • 4 Beds
    • 3 Baths
    • 2,419 Sq Ft
    • 305 Annaberg Dr
    • Youngsville, LA

    Priced Under Appraisal $50k Instant Equity. Sellers to contribute 10k towards update allowance or to buy down interest rate, Sweet Living in Sugar Mill Pond. Warm, inviting, and full of character, this Southern-style home offers timeless charm paired with modern comfort all nestled on one of the largest lots in the neighborhood. 4 Bedrooms| 3 Baths Almost 2500SF living space and ONE STORY

    Lulu David Lulu David Real Estate Co LLC

Source: REALTOR® Association of Acadiana

MLS Number: 2500006996

REALTOR® Association of Acadiana

APN: 6147787

Your Personal Tour Guide

Ask me questions while you tour the home.