Property Attributes
- MLS#2600004245
- TypeSingle Family
- Listing Status Active
- ParishLafayette
- CityYoungsville
- AreaP
- NeighborhoodSugar Mill Pond
- Zip70592
- StyleTraditional
- Year Built2026
- Price$ 619,099
- Bedrooms4
- Full Bathrooms3
- Half Bathrooms1
- Sqr Footage2659
- Lot Size0.18 Acres
Data Source:
REALTOR® Association of Acadiana (LBRMLS)
Property Description
Charming 'Celine A' floor plan by Level Homes underway in Sugar Mill Pond! The Celine is a two-story plan featuring four bedrooms, three and a half baths plus a spacious loft! Enter this home by walking up the bricked steps onto the inviting front porch with flickering gas lantern. The front door opens into the living room which is open to the dining and kitchen and has an exposed stained beam for some separation. The gourmet kitchen will feature custom painted cabinets with extended uppers, under cabinet lighting and 5' hardware pulls, large center island with single basin granite composite sink and overhanging pendant lights, stunning Calacatta Gold quartz counter tops, 3x12' glossy white subway tile backsplash, gold faucet, stainless appliances including a 36' gas cooktop and single wall oven, walk in pantry and an open gallery area off the kitchen. The spacious covered side porch is located off the kitchen and is perfect for outdoor dining or entertaining. The master suite is located downstairs along with an additional bedroom and full bath. The master suite has a spa-like bath featuring a 6-foot soaking tub, separate custom-built tiled shower with seamless glass enclosure, dual vanities with under mount sinks and quartz countertops, framed mirrors and a HUGE walk-in closet. Upstairs features two additional bedrooms, a full bath, and an open loft which leads out to the balcony. Stunning 'Brass' LVP wood flooring throughout living areas and downstairs bedrooms, brushed gold plumbing fixtures and hardware and brushed gold mixed with aged brass lighting fixtures! The yard will be professionally landscaped, fenced and fully sodded. Estimated completion date of September 2026, buyers can pick/approve certain colors and options for a limited period of time. *The completed pictures are not of the actual home but are of the same floorplan
| Elementary School | Middle School | High School |
|---|---|---|
| Ernest Gallet Elementary School | Youngsville Middle School | Southside High School |
| Price History | |
|---|---|
| 5/13/2026 | Listed $619,475 |
| 6/10/2026 | Listed $619,099 |
General Features
| Road Frontage Type | City Street,Paved |
|---|---|
| Association Amenities | Management,Pool,Recreation Facilities |
| Half Baths | 1 |
| Sewer | Public Sewer |
| Heating | Central |
| Cooling | Central Air |
| Roof | Asbestos Shingle,Metal |
| Appliances | Built-In Gas Oven,Dishwasher,Disposal,Gas Cooktop,Microwave,Gas Stove Con |
| HOA Fee | 410 |
| Gas Y/N | Gas: Delta Utilities |
| Patio/Porch Features | Covered |
| Architectural Style | Traditional |
| Construction Materials | Brick Veneer,HardiPlank Type,Frame |
| Year Built | 2026 |
| Electric | Elec: SLEMCO |
| Stories Count | 2 |
| Property Subtype | Single Family Residence |
| Community Features | Pool,Fitness Center,Park |
| Assoc Fee Paid Per | Quarterly |
| County | Lafayette |
| New Construction | true |
| Property Type | Residential |
| HOA | true |
| Subdivision Name | Sugar Mill Pond |
| Garage Y/N | true |
| Full Baths | 3 |
| Status | Active |
| Directions | From Ambassador Caffery, turn on Bonin Rd (Super One side), straight through the traffic circles at Fortune & 92, right on Prescott Blvd, left on Broyles Ln, right on Appleton Ln, right on Edgemere St, left on Oceans Blvd and the home will be on the right. |
| City | Youngsville |
| High School District | Lafayette Parish |
| MLS Area | P |
| Lot Size Square Feet | 7840.8 |
| Carport Y/N | false |
| Home Warranty Y/N | false |
| Property Condition | Under Construction |
| Primary Bedroom Level | First |
| Living Area Units | Square Feet |
| Builder Name | Level Homes |
| Standard Status | Active |
| Middle/Junior School District | Lafayette Parish |
| Elementary School District | Lafayette Parish |
| Legal Description | Lot Z-4 of Sugar Mill Pond Phase 26 |
Interior Features
| Interior Amenities | High Ceilings,Crown Molding,Kitchen Island,Separate Shower,Walk-in Pantry,Walk-In Closet(s),Bedroom 2,Bedroom 3,Bedroom 4,Dining Room,Kitchen,Living Room,Other Room,Quartz Counters |
|---|---|
| Flooring | Carpet,Tile,Wood Laminate |
| Fireplace Features | 1 Fireplace,Gas Log,Ventless |
| Kitchen Level | First |
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Window Features | Double Pane Windows |
| Fireplace Y/N | true |
| Laundry Features | Electric Dryer Hookup,Washer Hookup |
| Total Bedrooms | 4 |
| Living Room Level | First |
| LivingAreaSource | Plans |
| Total Baths | 4 |
| Dining Room Level | First |
| Bedroom 4 Level | Second |
| Bedroom 3 Level | Second |
| Second Bedroom Level | First |
Exterior Features
| Exterior Amenities | Lighting |
|---|---|
| Fencing | Privacy,Wood |
| Parking Features | Attached,Garage,Garage Faces Rear |
| Lot Features | 0 to 0.5 Acres,Level |
| Total Parking | 2 |
| Lot Size Area | 7840.8 |
| Foundation Details | Slab |
| Building Area Total | 3525 |
| Lot Dimensions | 55 x 128.50 x 65.10 x 128.50 |
| Lot Size Acres | 0.18 |
| Horse Y/N | false |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
The data relating to real estate for sale on this website comes in part from the IDX Program of the REALTOR Association of Acadiana MLS. This IDX information is provided exclusively for consumer's personal, non-commercial use. It 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.
Copyright © 2026 REALTOR® Association of Acadiana MLS. All rights rese