We Purchase, Trade, Consult & Market Residential & Commercial Real Estate

  • About
  • Contact
  • Careers
  • 337-984-4345
Guidry and Company Real EstateGuidry and Company Real EstateGuidry and Company Real EstateGuidry and Company Real Estate
  • 337-984-4345
  • Home
  • Buyers
    • Looking to Buy?
    • Featured Listings
    • Homes for Sale
    • COMMERCIAL LISTINGS: Business Opportunity, Industrial, Office, Restaurant/Lounge, Shopping Center, Hotel/Motel, Medical/Dental or Retail
    • LAND LISTINGS: Commercial, Industrial, Residential, Farm or Timberland
    • Buyers Guidebook
    • Choose Your Realtor
    • Why Choose Us
  • Sellers
    • Why Choose Us
  • Services
    • Consultation Services
    • Inherited Land
    • Professional Development
  • Who’s Your REALTOR®?
  • Blog
  • Reviews

Agent on Call

Andrea Laborde REALTOR® Sales Associate
337-277-6503


$825,000
304 Bella Vista Parkway
Youngsville, LA 70592
MLS# 2600000219
Status: Active/Contingent - Showings Allowed
4 beds  |  3.1 baths  |  2920 sqft


48FEA479-16EB-485C-BF7E-042A3FBA0C7F
  1 / 13  
48FEA479-16EB-485C-BF7E-042A3FBA0C7F 2712A452-B6EB-4E9B-968B-CF5C1D7EEDBD FA474C9E-8518-4965-95D1-5FFADD972D5E B5770781-CCCA-4771-9396-EA0DCD1C6F62 1B4FE234-A74D-4946-8827-E4A7C85B64B2 898A60CE-D565-4549-A812-AB6DB3864028 409EACE8-66C3-4955-A415-2A8F548B5987 93796BDC-B53C-497A-8E6F-FCC1AFBBC660 smp neighborhood1 smp neighborhood smp neighborhood1 smp neighborhood2 smp neighborhood

Property Description
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 breathtaking wall of windows overlooking the covered back patio and pool. The primary suite is tucked downstairs and feels like a true retreat with a cathedral ceiling, antique beams, and French doors that lead straight to the pool and covered patio. The primary bath offers a separate soaking tub, custom cabinetry, a dedicated vanity area, and a large walk-in closet with direct access to the laundry room—a detail you'll appreciate every day. A powder room sits off the foyer near another set of double doors that open to the pool area, creating an effortless flow for entertaining. You'll also find an additional downstairs bedroom with an attached bath, plus storage under the stairs. Upstairs includes two more bedroom with both rooms sharing access to a full bath. At the upstairs landing, a wet bar leads out to the covered balcony, adding another inviting spot to unwind. Outside is the showstopper: a beautiful outdoor kitchen, a lovely pool with water fountains, and multiple outdoor living areas designed for relaxing and gathering. And beyond the home, Sugar Mill Pond is loved for its lifestyle: biking, golf carts , walkable tree lined streets, parks and green spaces, scenic ponds, playgrounds, and a true neighborhood feel, all just minutes from local favorites and everyday conveniences. HOA fees include access to world class gym, pools, security system and security monitoring . Seller has home Freshly landscaped, and a generator transfer switch has been installed. Additional upgrades include a new 5-ton A/C system and a new pool heater system with warranty.

Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 299.78
Property Attached: No
Document Modified: 2026-01-23 12:36:14.888414
Status: Active/Contingent - Showings Allowed
Listing Date: 2026-01-23
Listing Price: 825000
Current Price: $825,000
Type: Single Family Residence
Modification Timestamp: 2026-02-20T18:18:35Z
Photo Modified: 2026-01-23T18:36:14Z
Location, Tax & Legal Info
Flood Zone: X
School District: Lafayette Parish
Legal Desc: Lot H-15 Sugar Mill Pond Ph 9B
General Property Description
Approximate Age: 6 - 10 Years
Lot Dimensions: Irregular
Stories: 2
SqFt - Living: 2752
SqFt - Source: Appraiser
SqFt - Total: 2920
Mineral Rights: Conveyed
Assn Fee: Required
Assn Fee $: 340
Assn Fee Terms: Quarterly
Property Condition: Resale
Builder: Ketteringham
Warranty: No
Acreage Range: 0 - 0.5
Pool on Subject Property: Yes
# Bedrooms: 4
Baths - Full: 3
Baths - 1/2: 1
Total Baths: 3.1
Year Built: 2015
Acres: 0.15
Remarks & Misc
Remarks: 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 breathtaking wall of windows overlooking the covered back patio and pool. The primary suite is tucked downstairs and feels like a true retreat with a cathedral ceiling, antique beams, and French doors that lead straight to the pool and covered patio. The primary bath offers a separate soaking tub, custom cabinetry, a dedicated vanity area, and a large walk-in closet with direct access to the laundry room—a detail you'll appreciate every day. A powder room sits off the foyer near another set of double doors that open to the pool area, creating an effortless flow for entertaining. You'll also find an additional downstairs bedroom with an attached bath, plus storage under the stairs. Upstairs includes two more bedroom with both rooms sharing access to a full bath. At the upstairs landing, a wet bar leads out to the covered balcony, adding another inviting spot to unwind. Outside is the showstopper: a beautiful outdoor kitchen, a lovely pool with water fountains, and multiple outdoor living areas designed for relaxing and gathering. And beyond the home, Sugar Mill Pond is loved for its lifestyle: biking, golf carts , walkable tree lined streets, parks and green spaces, scenic ponds, playgrounds, and a true neighborhood feel, all just minutes from local favorites and everyday conveniences. HOA fees include access to world class gym, pools, security system and security monitoring . Seller has home Freshly landscaped, and a generator transfer switch has been installed. Additional upgrades include a new 5-ton A/C system and a new pool heater system with warranty.
Office/Member/Contract Info
REO: No
Style
Coastal: 1
Siding
Brick: 1
Hardiplank: 1
Stucco: 1
Parking
Garage Spaces: 2
Equipment
Garage Door Opener: 1
Ceiling Fans: 1
Cable Available: 1
Road Frontage
City Street: 1
Construction
Frame: 1
Foundation
Slab: 1
Exterior
Balcony: 1
Gas/Propane Grill: 1
Outside Kitchen: 1
Outside Light: 1
Patio
Covered: 1
Open: 1
Fireplace
1 Fireplace: 1
Gas: 1
Roof
Composition: 1
Heating
Central: 1
Multi Units: 1
Interior
9+ Ft Ceiling: 1
Beamed Ceilings: 1
Built-Ins: 1
Crown Molding: 1
Double Vanity: 1
Electric Dryer Con: 1
Electric Washer Con: 1
Garden Tub: 1
Gas Stove Con: 1
Kitchen Island: 1
Primary Bath: 1
Separate Shower: 1
Varied Ceiling Heights: 1
Vaulted Ceilings: 1
Walk-in Pantry: 1
Walk-In Closet(s): 1
Cooling
2 or More Units: 1
Central Air: 1
Flooring
Carpet: 1
Tile: 1
Wood: 1
Sewer
Public Sewer: 1
Water Source
Public: 1
Water Company: City of Youngsville
Appliances
Dishwasher: 1
Disposal: 1
Gas Cooktop: 1
Ice Machine: 1
Microwave: 1
Plumbed For Ice Maker: 1
Utilities
Elec: SLEMCO: 1
Gas: Delta Utilities: 1
Countertops
Granite: 1
Quartz: 1
Waterfront
Pond: 1
Walk To: 1
Documents
Property Disclosure: 1
Amenities
Community Pool: 1
Health Club: 1
Park: 1
Playground: 1
Security Features
Security System: 1
Smoke Detector(s): 1
Fencing
Full: 1
Privacy: 1
Wood: 1
Lot
Back Yard Access: 1
Landscaped: 1
Level: 1
Window Features
Double Pane Windows: 1
Financing
Cash: 1
Conventional: 1
VA: 1
Reserved Item
Refrigerator: 1
Pool
Gunite: 1
Inground: 1
HOA Includes
Ground Keeping: 1
Management: 1
Pool: 1
Recreation Facilities: 1
Originating Details
Originating System ID: M00000300
Originating System Key: 20260123175810571337
Originating System Listing ID: 2600000219
Originating System Name: RAA Flex
Location Tax Legal Info
Street Number: 304
Street Name: Bella Vista
St Suffix: Parkway
Parish: Lafayette
State: LA
Zip Code: 70592
Subdivision: Sugar Mill Pond
Area: P
Tax Assessment Number: 6155364
Elementary School: Ernest Gallet
Middle School: Youngsville
High School: Southside
Directions: Verot School Road to Hwy 92 round-a-bout; take the third exit towards Sugar Mill Pond round-a-bout; take the first exit onto Chemin Metairie; Left on Palfrey Pkwy; Left on Bella Vista. Home on the right
Status Change Info
Under Contract Date: 2026-02-20
Property Features
Style: Coastal
Siding: Brick; Hardiplank; Stucco
Construction: Frame
Foundation: Slab
Road Frontage: City Street
Roof: Composition
Interior: 9+ Ft Ceiling; Beamed Ceilings; Built-Ins; Crown Molding; Double Vanity; Electric Dryer Con; Electric Washer Con; Garden Tub; Gas Stove Con; Kitchen Island; Primary Bath; Separate Shower; Varied Ceiling Heights; Vaulted Ceilings; Walk-in Pantry; Walk-In Closet(s)
Fireplace: 1 Fireplace; Gas
Flooring: Carpet; Tile; Wood
Heating: Central; Multi Units
Cooling: 2 or More Units; Central Air
Appliances: Dishwasher; Disposal; Gas Cooktop; Ice Machine; Microwave; Plumbed For Ice Maker
Countertops: Granite; Quartz
Security Features: Security System; Smoke Detector(s)
Fencing: Full; Privacy; Wood
Lot: Back Yard Access; Landscaped; Level
Patio: Covered; Open
Amenities: Community Pool; Health Club; Park; Playground
Exterior: Balcony; Gas/Propane Grill; Outside Kitchen; Outside Light
Window Features: Double Pane Windows
Waterfront: Pond; Walk To
Sewer: Public Sewer
Water Source: Public
Utilities: Elec: SLEMCO; Gas: Delta Utilities
Pool: Gunite; Inground
HOA Includes: Ground Keeping; Management; Pool; Recreation Facilities
Reserved Item: Refrigerator
Financing: Cash; Conventional; VA
Documents: Property Disclosure; Property Disclosure
Listing Documents
View Document Flood Determination Disclosure
View Document Property Disclosure

IDX
Listing Office: Lulu David Real Estate Co LLC

Last Updated: February - 20 - 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.


Search powered by FBS Products

Find Us

Get Directions
 

1232-A Camellia Blvd.
Lafayette, LA 70508
P: 337-984-4345

 

AGENT ON CALL | 337-277-6503
 

 

CALL US: 337-984-4345

 

GUIDRY & CO. REAL ESTATE, Lafayette, LA. All offices are independently owned and operated. The data relating to real estate for sale on this web site comes in part from the IDX Program of the Realtor® Association of Acadiana; MLS Real Estate listings held by brokerage firms other than GUIDRY & CO. REAL ESTATE are marked with the MLS approved icon for IDX. “Information Deemed Reliable But Not Guaranteed”. Copyright 2016 REALTOR® Association of Acadiana, All rights reserved.

Licensed & Regulated in the jurisdiction of the Louisiana Real Estate Commission, Members of the National Association of Realtors®, Louisiana Realtors®, Realtor® Association of Acadiana, Multiple Listing Service (MLS), Louisiana Commercial (www.lacdb.com), The Realtor® Commercial Alliance, Equal Housing Opportunity.

  • Home
  • 337-984-4345
  • Buyers
    • Looking to Buy?
    • Featured Listings
    • Homes for Sale
    • COMMERCIAL LISTINGS: Business Opportunity, Industrial, Office, Restaurant/Lounge, Shopping Center, Hotel/Motel, Medical/Dental or Retail
    • LAND LISTINGS: Commercial, Industrial, Residential, Farm or Timberland
    • Buyers Guidebook
    • Choose Your Realtor
    • Why Choose Us
  • Sellers
    • Why Choose Us
  • Services
    • Consultation Services
    • Looking to Buy?
    • Inherited Real Estate?
    • Choose Your REALTOR®
    • Professional Development
  • Blog
  • Who’s Your REALTOR®?
  • Careers
  • About Guidry & Co. Real Estate
  • Contact Us
  • Reviews
Guidry and Company Real Estate
Thank you for visiting Guidry & Co. Real Estate, for more information please register here:

"*" indicates required fields

This field is for validation purposes and should be left unchanged.
Name*

 

Return To Homepage