805 Waterview Road, Youngsville, LA 70592
New Listing
$945,000
Property Type:
Residential
Bedrooms:
5
Baths:
3.1
Square Footage:
3,380
Status:
Active
Current Price:
$945,000
List Date:
8/18/2026
Last Modified:
8/18/2026
Listing Details MLS# 2600007644
Listing Info
- Delayed Marketing
- No
- Listing Price
- 945000
- List Price/SqFt
- 279.59
- Type
- Single Family Residence
- Property Attached
- No
- Document Modified
- 2026-08-17 13:36:12.963824
- Modification Timestamp
- 2026-08-18T19:39:32Z
- Photo Modified
- 2026-08-18T19:38:31Z
Location Tax Legal Info
- Street Number
- 805
- Street Name
- Waterview
- St Suffix
- Road
- Parish
- Lafayette
- State
- LA
- Zip Code
- 70592
- Subdivision
- Sugar Mill Pond
- Area
- P
- Tax Assessment Number
- 15307298
- Elementary School
- Ernest Gallet
- Middle School
- Youngsville
- High School
- Southside
- Directions
- From Lafayette take Verot School Rd toward Youngsville, at Hwy 92 traffic circle turn left to the next traffic circle at Chemin Metairie and go right. Turn left onto Palfrey Parkway and continue to Waterview Rd
General Property Description
- # Bedrooms
- 5
- Baths - Full
- 3
- Baths - 1/2
- Yes
- Total Baths
- 3.1
- SqFt - Living
- 3380
- SqFt - Source
- Owner
- Stories
- 2
- Approximate Age
- 6 - 10 Years
- Property Condition
- Resale
- Builder
- Shivers
- Warranty
- Yes
- Assn Fee
- Required
- Assn Fee $
- 410
- Assn Fee Terms
- Quarterly
- Lot Dimensions
- See Plat
- Mineral Rights
- Conveyed
- Pool on Subject Property
- Yes
Parking
- Garage Spaces
- 2
- Garage Faces Front
- Yes
Water Source
- Water Company
- city
- Public
- Yes
Originating Details
- Originating System ID
- M00000300
- Originating System Key
- 20260810194434739039
- Originating System Listing ID
- 2600007644
- Originating System Name
- RAA Flex
More Information
Location, Tax & Legal Info
- Flood Zone
- x
- School District
- Lafayette Parish
- Legal Desc
- Lot H-31 Phase 9C of Sugar Mill Pond Development
Remarks & Misc
- Remarks
- 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 beautifully detailed front elevation that immediately sets it apart. Inside, the thoughtfully designed floor plan offers five bedrooms, three and a half baths, generous living spaces, and beautifully updated interiors. The spacious primary suite includes a private adjoining room ideal for a home office, nursery, sitting room, or additional flex space, allowing the home to easily adapt to your needs. The kitchen opens to the den, creating a comfortable flow for everyday living and entertaining. Abundant natural light, custom architectural details, and spacious rooms give the home a warm and inviting feel throughout. Outdoors, the private backyard becomes an extension of the living space with a swimming pool and hot tub , perfect for relaxing, entertaining, and enjoying Louisiana evenings at home. With five bedrooms, versatile living spaces, a pool and hot tub, an exceptional corner lot, and the walkable lifestyle and amenities Sugar Mill Pond is known for, this custom home offers a rare combination of space, character, and location.
Office/Member/Contract Info
- REO
- No
Style
- Colonial
- Yes
- Traditional
- Yes
Levels
- Two
- Yes
Siding
- Stucco
- Yes
Equipment
- Garage Door Opener
- Yes
- Cable Ready
- Yes
Road Frontage
- City Street
- Yes
Construction
- Frame
- Yes
Foundation
- Slab
- Yes
Exterior
- Balcony
- Yes
- Gas/Propane Grill
- Yes
- Hot Tub
- Yes
- Outside Kitchen
- Yes
- Outside Light
- Yes
Patio
- Covered
- Yes
Fireplace
- 1 Fireplace
- Yes
Roof
- Composition
- Yes
Heating
- Central
- Yes
Interior
- Attic Access
- Yes
- Crown Molding
- Yes
- Double Vanity
- Yes
- Gas Dryer Con
- Yes
- Gas Stove Con
- Yes
- Kitchen Island
- Yes
- Primary Bath
- Yes
- Multi-Head Shower
- Yes
- Separate Shower
- Yes
- Walk-in Pantry
- Yes
- Walk-In Closet(s)
- Yes
Cooling
- Central Air
- Yes
Flooring
- Pavers
- Yes
- Wood Laminate
- Yes
Sewer
- Public Sewer
- Yes
Appliances
- Built-In Gas Oven
- Yes
- Dishwasher
- Yes
- Disposal
- Yes
- Gas Cooktop
- Yes
- Gas Range
- Yes
- Microwave
- Yes
- Refrigerator
- Yes
Utilities
- Elec: SLEMCO
- Yes
- Gas: Delta Utilities
- Yes
Countertops
- Granite
- Yes
Waterfront
- Walk To
- Yes
Amenities
- Club House
- Yes
- Community Pool
- Yes
- Health Club
- Yes
- Park
- Yes
- Playground
- Yes
- Shopping/Mall
- Yes
Security Features
- Carbon Monoxide Detector(s)
- Yes
- Prewired
- Yes
- Security System
- Yes
- Smoke Detector(s)
- Yes
Fencing
- Privacy
- Yes
Lot
- Back Yard Access
- Yes
- Corner
- Yes
- Easements
- Yes
- Landscaped
- Yes
- Level
- Yes
- Zero Lot Line
- Yes
Other Structures
- Outdoor Kitchen
- Yes
Window Features
- Aluminum Frames
- Yes
Financing
- Cash
- Yes
- Conventional
- Yes
- FHA
- Yes
Pool
- Inground
- Yes
HOA Includes
- Ground Keeping
- Yes
- Other Utilities
- Yes
- Pool
- Yes
- Recreation Facilities
- Yes
Property Features
Style:
Colonial; Traditional
Levels:
Two
Siding:
Stucco
Parking:
Garage Faces Front
Construction:
Frame
Foundation:
Slab
Road Frontage:
City Street
Roof:
Composition
Interior:
Attic Access; Crown Molding; Double Vanity; Gas Dryer Con; Gas Stove Con; Kitchen Island; Multi-Head Shower; Primary Bath; Separate Shower; Walk-in Pantry; Walk-In Closet(s)
Fireplace:
1 Fireplace
Flooring:
Pavers; Wood Laminate
Heating:
Central
Cooling:
Central Air
Appliances:
Built-In Gas Oven; Dishwasher; Disposal; Gas Cooktop; Gas Range; Microwave; Refrigerator
Countertops:
Granite
Security Features:
Carbon Monoxide Detector(s); Prewired; Security System; Smoke Detector(s)
Fencing:
Privacy
Lot:
Back Yard Access; Corner; Easements; Landscaped; Level; Zero Lot Line
Patio:
Covered
Amenities:
Club House; Community Pool; Health Club; Park; Playground; Shopping/Mall
Exterior:
Balcony; Gas/Propane Grill; Hot Tub; Outside Kitchen; Outside Light
Other Structures:
Outdoor Kitchen
Window Features:
Aluminum Frames
Waterfront:
Walk To
Sewer:
Public Sewer
Water Source:
Public
Utilities:
Elec: SLEMCO; Gas: Delta Utilities
Pool:
Inground
HOA Includes:
Ground Keeping; Other Utilities; Pool; Recreation Facilities
Financing:
Cash; Conventional; FHA
Property Disclosure ›
IDX
Listing Office:
Lulu David Real Estate Co LLC
Last Updated: August - 18 - 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.