- 6 beds
- 6 baths
- 6,000 sqft
- ~1 acre lot
- $583 per sqft
- 2025 build
- – on site
Luxury New Construction by Piazza Custom Builders – Half Hollow Hills SD Experience refined living in this nearly 6,000 sq ft custom-built masterpiece, crafted by renowned Piazza Custom Builders and situated on a quiet, tree-lined block in the Half Hollow Hills School District. Every detail in this extraordinary 6-bedroom, 5.5-bathroom residence has been thoughtfully designed to blend modern luxury with timeless craftsmanship. Step through the impressive 22-foot front-to-back entry foyer into a light-filled open-concept living space featuring soaring 10-foot ceilings throughout the main level and tray ceilings in the formal dining room, great room, and den. Anchored by a striking porcelain stone fireplace, the great room flows seamlessly into the heart of the home—a designer kitchen boasting custom white oak cabinetry, an oversized quartzite island, and top-of-the-line Thermador appliances. The first-floor guest suite with private entrance offers ideal flexibility for in-laws, guests, or au pair accommodations. A spacious mudroom with built-in storage and a three-car garage ensure functionality meets elegance. Retreat upstairs to the primary suite, a true sanctuary with a spa-inspired ensuite bathroom featuring radiant heated floors, dual vanities, and premium finishes. Two additional ensuite bedrooms and a Jack-and-Jill bath offer private accommodations for family and guests, while a second-floor laundry room adds everyday convenience. The home includes a full walk-out basement with 10' ceilings and approximately 3,000 sq ft of space—ready for future customization. The full-height attic provides abundant storage and expansion potential. Built with superior energy efficiency in mind, the home features spray foam insulation, Marvin windows, exterior finishes of Hardie board and stone and the latest smart home technology. Outside, a professionally landscaped backyard is lined with mature Green Giant Arborvitae, creating a private oasis. Located minutes from schools, major highways, shopping, and more—this exceptional home combines luxury, convenience, and craftsmanship at every turn. Completion expected by September 2025. Transfer taxes and water/sewer hookup to be paid by the buyer.
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Jul 8, 2025
•
MLS# 868685 —
The Building
-
Year Built:2025
-
Basement:true
-
Architectural Style:Estate
-
Construction Materials:HardiPlank Type, Stone
-
Building Area Units:Square Feet
-
Building Area Total:9000
-
Building Area Source:Plans
-
Window Features:Casement, Oversized Windows
-
Laundry Features:Laundry Room
-
Attic:Full,See Remarks,Unfinished
Interior
-
Living Area:6000
-
Total Rooms:11
-
Interior Features:First Floor Bedroom, First Floor Full Bath, Built-in Features, Cathedral Ceiling(s), Central Vacuum, Chandelier, Chefs Kitchen, Crown Molding, Entrance Foyer, Formal Dining, His and Hers Closets, In-Law Floorplan, Kitchen Island, Open Floorplan, Open Kitchen, Pantry, Quartz/Quartzite Counters, Recessed Lighting, Smart Thermostat, Tray Ceiling(s), Walk-In Closet(s)
-
Fireplaces Total:1
-
Fireplace:true
-
Flooring:Hardwood
-
Living Area Source:Plans
-
# of Kitchens:1
Financial & Terms
-
Lease Considered:false
The Property
-
Lot Features:Near School
-
Lot Size Acres:1
-
Parcel Number:0400-244-00-03-00-057-000
-
Property Type:Residential
-
Property Subtype:Single Family Residence
-
Lot Size SqFt:43,560 Sqft
-
Property Attached:false
-
Additional Parcels:false
-
Lot Size Dimensions:1
-
Waterfront:false
Listing Agent
- Contact info:
- Agent phone:
- (917) 837-1085
- Office phone:
- (631) 824-8484
Taxes
-
Tax Year:2025
-
Tax Source:Other
-
Tax Lot:57
Beds
-
Total Bedrooms:6
Baths
-
Full Baths:5
-
Half Baths:1
-
Total Baths:6
The Listing
-
Special Listing Conditions:None
Heating & Cooling
-
Heating:Hydro Air, Propane
-
Cooling:Central Air, ENERGY STAR Qualified Equipment
Utilities
-
Sewer:Septic Tank
-
Utilities:Cable Available, Electricity Available, Propane
-
Water Source:Public
Appliances
-
Appliances:Convection Oven, Dishwasher, Dryer, ENERGY STAR Qualified Appliances, Exhaust Fan, Freezer, Gas Cooktop, Microwave, Oven, Refrigerator, Stainless Steel Appliance(s), Washer, Wine Refrigerator
Schools
-
High School:Half Hollow Hills High School East
-
Elementary School:Signal Hill Elementary School
-
High School District:Half Hollow Hills
-
Middle School:West Hollow Middle School
-
Elementary School District:Half Hollow Hills
-
Middle School District:Half Hollow Hills
The Community
-
Association:false
-
Senior Community:false
-
Additional Fees:No
-
Pool Private:false
-
Spa:false
Parking
-
Parking Features:Attached, Private
-
Garage:true
-
Garage Spaces:3
-
Carport:false
Monthly cost estimate

Asking price
$3,499,800
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$18,740
|
Taxes | N/A |
Insurance | $962 |
Utilities | $313 See report |
Total | $20,015/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
6/5/25
Jun 5, 2025
|
Listed / Active | ONEKEY | $3,499,800 | |
5/30/25
May 30, 2025
|
Coming Soon | ONEKEY | $3,499,800 |