405 Harbor Road, Youngsville, LA 70592
New Listing
$459,900
Property Type:
Residential
Bedrooms:
3
Baths:
2.1
Square Footage:
2,084
Lot Size (sq. ft.):
6,098
Status:
Active
Current Price:
$459,900
List Date:
9/23/2026
Last Modified:
9/23/2026
Overview
Description
...
(Read more)
Welcome to the lifestyle so many love in Sugar Mill Pond. Built by respected local Parade of Homes builder Brian Guidry, this beautifully maintained home sits on a convenient corner lot directly behind the pond-front homes, offering a desirable setting within one of Acadiana's most beloved communities.
Traditional arches and subtle European-inspired details give the home timeless character, while thoughtful renovations completed approximately two years ago bring a fresh, updated feel. Improvements include fresh interior paint, new ceramic tile flooring throughout the living room, dining room, kitchen, half bath and hallway, a fully remodeled kitchen, updated bathroom countertops, and a beautifully refreshed primary bedroom and en suite bath with new countertops. House also has Bose Surround Sound system in Main areas and in Outdoor Patio.
The kitchen opens naturally to the extended rear patio and backyard, creating an easy flow for everyday living and entertaining. Architectural beams add warmth and character, while the outdoor kitchen, patio swings and newly coated patio create an inviting place to gather. The backyard has also been upgraded with brand-new low-maintenance turf, a new privacy fence and gate.
The spacious primary suite features a large bathroom with an oversized vanity and dedicated makeup area, offering abundant space for cosmetics, jewelry and personal organization. Two additional bedrooms share a convenient Jack-and-Jill bathroom, with a separate half bath located down the hallway. A mini-split system in the garage provides added comfort and versatility.
Living in Sugar Mill Pond is more than owning a home, it is a lifestyle. Enjoy neighborhood pools, a fitness center, ponds, parks, walking and biking paths, nightly security patrols, and convenient access to Youngsville's dining, shopping and everyday amenities. Thoughtfully renovated, full of character and ready to enjoy.
Listing Details MLS# 2600008764
Listing Info
- Delayed Marketing
- No
- Listing Price
- 459900
- List Price/SqFt
- 220.68
- Type
- Single Family Residence
- Property Attached
- No
- Document Modified
- 2026-09-17 17:58:01.932262
- Modification Timestamp
- 2026-09-23T14:42:16Z
- Photo Modified
- 2026-09-23T14:41:30Z
Location Tax Legal Info
- Street Number
- 405
- Street Name
- Harbor
- St Suffix
- Road
- Parish
- Lafayette
- State
- LA
- Zip Code
- 70592
- Subdivision
- Sugar Mill Pond
- Area
- P
- Tax Assessment Number
- 6127660
- Elementary School
- Ernest Gallet
- Middle School
- Youngsville
- High School
- Southside
- Directions
- From Verot School Road, turn east onto Chemin Metairie Parkway. Turn right onto Prescott Boulevard, then right onto Harbor Road. Continue to **405 Harbor Road**, located on the corner.
General Property Description
- # Bedrooms
- 3
- Baths - Full
- 2
- Baths - 1/2
- Yes
- Total Baths
- 2.1
- SqFt - Living
- 2084
- SqFt - Source
- Approximate
- Stories
- Yes
- SqFt - Garage
- 2
- Year Built
- 2009
- Approximate Age
- 16 - 20 Years
- Property Condition
- Updated/Remodeled
- Condition
- Excellent
- Builder
- Brian Guidry
- Warranty
- No
- Acres
- 0.14
- Acreage Range
- 0 - 0.5
- Assn Fee
- Required
- Assn Fee $
- 70
- Assn Fee Terms
- Monthly
- Lot Dimensions
- 55.21 X 113.45
- Mineral Rights
- Conveyed
- Pool on Subject Property
- No
Parking
- Garage Spaces
- 2
- Garage
- Yes
- Garage Faces Rear
- Yes
Water Source
- Water Company
- City
- Public
- Yes
Originating Details
- Originating System ID
- M00000300
- Originating System Key
- 20260917150601342454
- Originating System Listing ID
- 2600008764
- Originating System Name
- RAA Flex
More Information
Location, Tax & Legal Info
- Flood Zone
- X
- School District
- Lafayette Parish
- Legal Desc
- Lot B-59, Phase I, Sugar Mill Pond, Lafayette Parish
Remarks & Misc
- Remarks
- Welcome to the lifestyle so many love in Sugar Mill Pond. Built by respected local Parade of Homes builder Brian Guidry, this beautifully maintained home sits on a convenient corner lot directly behind the pond-front homes, offering a desirable setting within one of Acadiana's most beloved communities. Traditional arches and subtle European-inspired details give the home timeless character, while thoughtful renovations completed approximately two years ago bring a fresh, updated feel. Improvements include fresh interior paint, new ceramic tile flooring throughout the living room, dining room, kitchen, half bath and hallway, a fully remodeled kitchen, updated bathroom countertops, and a beautifully refreshed primary bedroom and en suite bath with new countertops. House also has Bose Surround Sound system in Main areas and in Outdoor Patio. The kitchen opens naturally to the extended rear patio and backyard, creating an easy flow for everyday living and entertaining. Architectural beams add warmth and character, while the outdoor kitchen, patio swings and newly coated patio create an inviting place to gather. The backyard has also been upgraded with brand-new low-maintenance turf, a new privacy fence and gate. The spacious primary suite features a large bathroom with an oversized vanity and dedicated makeup area, offering abundant space for cosmetics, jewelry and personal organization. Two additional bedrooms share a convenient Jack-and-Jill bathroom, with a separate half bath located down the hallway. A mini-split system in the garage provides added comfort and versatility. Living in Sugar Mill Pond is more than owning a home, it is a lifestyle. Enjoy neighborhood pools, a fitness center, ponds, parks, walking and biking paths, nightly security patrols, and convenient access to Youngsville's dining, shopping and everyday amenities. Thoughtfully renovated, full of character and ready to enjoy.
Office/Member/Contract Info
- REO
- No
Style
- Bungalow
- Yes
- French
- Yes
Levels
- One
- Yes
Siding
- Stucco
- Yes
Equipment
- Garage Door Opener
- Yes
- Ceiling Fans
- Yes
- Cable Ready
- Yes
Road Frontage
- City Street
- Yes
Construction
- Frame
- Yes
Foundation
- Slab
- Yes
Exterior
- Gas/Propane Grill
- Yes
- Outdoor Speakers
- Yes
- Outside Kitchen
- Yes
- Outside Light
- Yes
Patio
- Porch
- Yes
- Covered
- Yes
Fireplace
- 1 Fireplace
- Yes
Roof
- Composition
- Yes
Heating
- Central
- Yes
- Electric
- Yes
Interior
- 9+ Ft Ceiling
- Yes
- Attic Access
- Yes
- Computer Nook
- Yes
- Crown Molding
- Yes
- Double Vanity
- Yes
- Gas Stove Con
- Yes
- Kitchen Island
- Yes
- Primary Bath
- Yes
- Separate Shower
- Yes
- Varied Ceiling Heights
- Yes
- Walk-In Closet(s)
- Yes
- Window Treatments
- Yes
Cooling
- Central Air
- Yes
Flooring
- Tile
- Yes
- Wood
- Yes
Sewer
- Public Sewer
- Yes
Appliances
- Dishwasher
- Yes
- Disposal
- Yes
- Gas Cooktop
- Yes
- Microwave
- Yes
Utilities
- Elec: SLEMCO
- Yes
- Gas: Delta Utilities
- Yes
Waterfront
- Lake
- Yes
- Pond
- Yes
- View
- Yes
- Walk To
- Yes
Documents
- Property Disclosure
- Yes
Amenities
- Medical Facility
- Yes
- Park
- Yes
- Playground
- Yes
Security Features
- Security System
- Yes
- Smoke Detector(s)
- Yes
Fencing
- Wood
- Yes
Lot
- Back Yard Access
- Yes
- Landscaped
- Yes
- Views
- Yes
Other Structures
- Storage
- Yes
Window Features
- Double Pane Windows
- Yes
Financing
- 1031 Exchange
- Yes
- Cash
- Yes
- Conventional
- Yes
- FHA
- Yes
- Private Banking
- Yes
- Rural Development
- Yes
- VA
- Yes
Reserved Item
- Drapes
- Yes
- Rods
- Yes
HOA Includes
- Other - See Remarks
- Yes
Property Features
Style:
Bungalow; French
Levels:
One
Siding:
Stucco
Parking:
Garage; Garage Faces Rear
Construction:
Frame
Foundation:
Slab
Road Frontage:
City Street
Roof:
Composition
Interior:
9+ Ft Ceiling; Attic Access; Computer Nook; Crown Molding; Double Vanity; Gas Stove Con; Kitchen Island; Primary Bath; Separate Shower; Varied Ceiling Heights; Walk-In Closet(s); Window Treatments
Fireplace:
1 Fireplace
Flooring:
Tile; Wood
Heating:
Central; Electric
Cooling:
Central Air
Appliances:
Dishwasher; Disposal; Gas Cooktop; Microwave
Security Features:
Security System; Smoke Detector(s)
Fencing:
Wood
Lot:
Back Yard Access; Landscaped; Views
Patio:
Covered; Porch
Amenities:
Medical Facility; Park; Playground
Exterior:
Gas/Propane Grill; Outdoor Speakers; Outside Kitchen; Outside Light
Other Structures:
Storage
Window Features:
Double Pane Windows
Waterfront:
Lake; Pond; View; Walk To
Sewer:
Public Sewer
Water Source:
Public
Utilities:
Elec: SLEMCO; Gas: Delta Utilities
HOA Includes:
Other - See Remarks
Reserved Item:
Drapes; Rods
Financing:
1031 Exchange; Cash; Conventional; FHA; Private Banking; Rural Development; VA
Documents:
Property Disclosure; Property Disclosure
Documents
IDX
Listing Office:
Lulu David Real Estate Co LLC
Last Updated: September - 23 - 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.

Flood Determination Disclosure ›