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

Delayed Marketing: No

List Price/SqFt: 232.83

Property Attached: No

Document Modified: 2026-06-10 12:11:51.897599

Status: Active

Listing Date: 2026-05-13

Listing Price: 619099

Current Price: $619,099

Type: Single Family Residence

Modification Timestamp: 2026-06-15T13:51:54Z

Photo Modified: 2026-06-15T13:51:36Z

Flood Zone: X

School District: Lafayette Parish

Legal Desc: Lot Z-4 of Sugar Mill Pond Phase 26

Approximate Age: < 1 Year

Condition: New

Lot Dimensions: 55x128.50x65.10x128.50

Stories: 2

SqFt - Living: 2659

SqFt - Lower: 1948

SqFt - Source: Blueprint

SqFt - Upper: 711

SqFt - Total: 3525

Mineral Rights: Reserved

Assn Fee: Required

Assn Fee $: 410

Assn Fee Terms: Quarterly

SqFt - Covered Porch: 308

SqFt - Garage: 558

Property Condition: Under Construction

Builder: Level Homes

Model Name: Celine B

Acreage Range: 0 - 0.5

Pool on Subject Property: No

# Bedrooms: 4

Baths - Full: 3

Baths - 1/2: 1

Total Baths: 3.1

Year Built: 2026

Acres: 0.18

Remarks: 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

REO: No

Traditional: 1

Two: 1

Brick: 1

Hardiplank: 1

Attached: 1

Garage: 1

Garage Spaces: 2

Garage Faces Rear: 1

Garage Door Opener: 1

Cable Ready: 1

City Street: 1

Paved: 1

Frame: 1

Slab: 1

Outside Light: 1

Covered: 1

1 Fireplace: 1

Gas Log: 1

Ventless: 1

Asbestos Shingle: 1

Metal: 1

Central: 1

9+ Ft Ceiling: 1

Attic Access: 1

Crown Molding: 1

Electric Dryer Con: 1

Electric Washer Con: 1

Gas Stove Con: 1

Kitchen Island: 1

Primary Bath: 1

Separate Shower: 1

Walk-in Pantry: 1

Walk-In Closet(s): 1

Central Air: 1

Carpet: 1

Tile: 1

Wood Laminate: 1

Public Sewer: 1

Sewer Company: City of Youngsville

Public: 1

Water Company: City of Youngsville

Built-In Gas Oven: 1

Dishwasher: 1

Disposal: 1

Gas Cooktop: 1

Microwave: 1

Plumbed For Ice Maker: 1

Elec: SLEMCO: 1

Gas: Delta Utilities: 1

Quartz: 1

Dining Room: 1

Dining Room Level: First

Kitchen: 1

Kitchen Level: First

Living Room: 1

Living Room Level: First

Primary Bedroom: 1

Primary Bedroom Level: First

Other: 1

Other Level: Second

Bedroom 2: 1

Bedroom 2 Level: First

Bedroom 3: 1

Bedroom 3 Level: Second

Bedroom 4: 1

Bedroom 4 Level: Second

Community Pool: 1

Health Club: 1

Park: 1

Prewired: 1

Security System: 1

Smoke Detector(s): 1

Privacy: 1

Wood: 1

Level: 1

Double Pane Windows: 1

Cash: 1

Conventional: 1

FHA: 1

VA: 1

See Remarks: 1

Management: 1

Pool: 1

Recreation Facilities: 1

Originating System ID: M00000300

Originating System Key: 20260513185335409293

Originating System Listing ID: 2600004245

Originating System Name: RAA Flex

Street Number: 506

Street Name: Oceans

St Suffix: Boulevard

Parish: Lafayette

State: LA

Zip Code: 70592

Subdivision: Sugar Mill Pond

Area: P

Tax Assessment Number: 00000

Elementary School: Ernest Gallet

Middle School: Youngsville

High School: Southside

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.