Awesome builder rate and FREE Refrigerator. (restrictions apply)! Brand NEW Construction built by DSLD HOMES in Cornerstone! The YANCY III G has an open floor plan with 4 bedrooms and 2.5 bathrooms. This home includes upgraded stainless appliances with a gas range, cabinet package, undermount cabinet lighting and more. Special plan features include kitchen island, granite counters with undermount sinks throughout, vinyl plank flooring in living room and all wet areas, walk-in closet, garden tub & separate shower in primary bedroom, smart connect Wi-Fi thermostat, ceiling fans in the living room and primary bedroom, recessed lighting, smart connect wi-fi thermostat, smoke and carbon monoxide detectors, post tension slab, automatic garage door with two remotes, fully sodded yard with seasonal landscaping, architectural 30-year shingles, flood lights, rear porch and more! Energy Efficient Features: a tankless gas water heater, a stainless kitchen appliance package, low E tilt-in windows, radiant barrier roof decking and more!
Active
$261,525
46014 Terra Cotta Ct, Hammond, LA 70401
4beds
1,788sqft
Single Family Residence
Built in 2025
9,583 sqft lot
$-- Zestimate®
$146/sqft
$33/mo HOA
What's special
Open floor planSeparate showerSmart connect wi-fi thermostatFlood lightsFully sodded yardGarden tubUpgraded stainless appliances
- 42 days
- on Zillow |
- 59 |
- 5 |
Zillow last checked: 7 hours ago
Listing updated: June 03, 2025 at 08:06am
Listed by:
Saun Sullivan 225-369-6111,
Cicero Realty, LLC 225-369-6111
Source: GSREIN,MLS#: NO2025007709

Travel times
Schedule tour
Select your preferred tour type — either in-person or real-time video tour — then discuss available options with the builder representative you're connected with.
Select a date
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Dimensions: 14.9x12.0
Bedroom
- Dimensions: 11.9x12.8
Bedroom
- Dimensions: 10.3x10.10
Bedroom
- Dimensions: 10.2x10.0
Dining room
- Dimensions: 10.10x13.7
Kitchen
- Dimensions: 11.0x17.1
Living room
- Dimensions: 17.6x13.9
Heating
- Central, Gas
Cooling
- Central Air
Appliances
- Included: Cooktop, Dishwasher, Disposal, Microwave, Oven, Range
- Laundry: Washer Hookup, Dryer Hookup
Features
- Ceiling Fan(s), Granite Counters, Pantry, Stainless Steel Appliances
- Windows: Screens
Interior area
- Total structure area: 2,341
- Total interior livable area: 1,788 sqft
Property
Parking
- Parking features: Attached, Garage, Two Spaces
- Has garage: Yes
Features
- Levels: One
- Stories: 1
- Patio & porch: Concrete, Covered, Porch
- Exterior features: Porch
Lot
- Size: 9,583 sqft
- Dimensions: 81 x 120
- Features: Outside City Limits
Details
- Parcel number: NEW
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence
Materials
- Brick, Vinyl Siding
- Foundation: Slab
- Roof: Asphalt
Condition
- New Construction
- New construction: Yes
- Year built: 2025
Details
- Builder name: Dsld, Llc
- Warranty included: Yes
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Natural Gas Available
Green energy
- Energy efficient items: Insulation, Lighting, Water Heater, Windows
Community & HOA
Community
- Security: Smoke Detector(s)
- Subdivision: Cornerstone
HOA
- Has HOA: Yes
- HOA fee: $400 annually
Location
- Region: Hammond
Financial & listing details
- Price per square foot: $146/sqft
- Date on market: 4/29/2025
About the community
Welcome to Cornerstone! This community is conveniently located off River Road, which can be accessed by Highway 190 in Hammond. This location offers serene country life, but you are still conveniently located to local shopping, Hammond airport, downtown Hammond, and the interstate. You are only three miles away from Downtown Hammond, which offers many things to do including some of the best breakfast spots, local restaurants, shopping, and Southeastern Louisiana University. Go Lions!
Hammond is also well known for fun local events, such as Hot August Night and Starry November Night. These two events are a great time to gather with the community and enjoy late shopping, dining, and entertainment. Hammond Square Mall is continuing to grow with more well-known businesses and restaurants that we all love. Some of these include Home Goods, 5 Below, Old Navy, Walk-Ons, Chipotle, and Five Guys. The options are endless.
Cornerstone is conveniently located less than a fourth of a mile from the two schools in Hammond. Hammond Eastside Magnet School is for grades Pre-K through eighth grade and Hammond High School for ninth through twelfth grade. On a beautiful day, what a perfect way to start your day with a short walk to school.
In Cornerstone, you can choose between a variety of 3 and 4-bedroom floor plans. Our floor plans offer amenities such as 3 CM granite countertops, under-mount sinks, pull-down faucet, luxury vinyl in the living area, halls, and all wet areas, LED lighting, and so much more. You can also choose from a large selection of colors and upgraded options to give your new home your own personal touch. Call today to take your first step in making Cornerstone your place to call home!
Source: DSLD Homes