- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around





Street View
$1,588,800
Monthly Est:$7,908
4 Beds
- 4 Baths
4 full baths
2,800sqft
42 Celler Ave, North Hempstead, NY 11540
$1,588,800
$7,908/moEst:
Get Pre-Approved
Single Family Residence
Built in 2025
$-- HOA
5,000 sqft lot
$567/sq.ft
Description
Experience elevated living in this stunning new construction (2025) custom home, perfectly blending sophisticated design with everyday comfort. Featuring 5 spacious bedrooms and 4 luxurious bathrooms, every inch of this residence has been thoughtfully crafted with premium finishes and exceptional attention to detail.
Step inside to an open, light-filled floor plan highlighted by radiant heated floors throughout the first level, soaring ceilings, and elegant architectural details. The designer chef’s kitchen showcases custom cabinetry, premium finishes, and an oversized island that flows seamlessly into the living and dining spaces—creating the perfect setting for entertaining or everyday living.
One of the home’s standout features is the covered backyard patio, conveniently accessed from both the kitchen and the main living area, offering a seamless indoor-outdoor lifestyle. Whether hosting summer gatherings, enjoying your morning coffee, or unwinding in the evening, this inviting space extends your living experience beyond the home.
The custom-designed bathrooms feature elegant, spa-inspired finishes, while every room reflects quality craftsmanship and timeless style.
The fully finished legal basement offers exceptional versatility, providing the perfect opportunity for extended family living, a recreation area, home office, or a high income-producing rental.
Situated in one of New Hyde Park’s most desirable neighborhoods, this exceptional residence offers easy access to parks, shopping, dining, schools, major highways, and transportation—delivering the perfect combination of luxury, convenience, and long-term value.
Luxury. Comfort. Craftsmanship. Income Potential. Welcome to your next home.
- Houzeo last checked: 6 hours ago
- Listing updated: October 8, 2026 at 11:39 am
- Listing Provided by: Shri Singh (516) 734-1299 | BERKSHIRE HATHAWAY (516) 741-3070
- Source: OneKey MLS-NY | MLS#: 1035629

Property Details
Status
Active
Type
Single Family Residence
No. of Stories
-
County
City
Neighborhood
--
Year Built
2025
HOA Fees
-
Finished Area
2,800 sqft
Lot Size
5,000 sqft lot
Basement Area
- sqft
MLS Name
OneKey MLS
MLS Number
1035629
MLS Status
Active
Days on Market
62
Cumulative Days on Market
63

Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 4
Bathrooms: 4
Interior
Flooring
Brick, Ceramic Tile, Hardwood
Heating
Hot Air, Natural Gas
Sewer
Public Sewer
Interior Features
First Floor Bedroom, First Floor Full Bath, Beamed Ceilings, Bidet, Breakfast Bar, Built In Features, Cathedral Ceiling(s), Ceiling Fan(s), Central Vacuum, Chandelier, Chefs Kitchen, Crown Molding, Double Vanity, Eat In Kitchen, Entrance Foyer, Formal Dining, High Ceilings, High Speed Internet, His And Hers Closets, Kitchen Island, Marble Counters, Open Floorplan, Open Kitchen, Pantry, Quartz/quartzite Counters, Recessed Lighting, Storage
Appliances
Dishwasher, Gas Oven, Humidifier, Refrigerator, Stainless Steel Appliance(s), Gas Water Heater
Cooling
Central Air
Construction
Year Built
Year Built: 2025
Home type
Single Family Residence
Construction Materials
Brick
Architectural Style
Colonial
Utilities & Energy
Basement
Finished, Full
Parking Features
Driveway
Water Source
Public
Laundry Features
In Basement
Utilities
Natural Gas Connected
Fireplace Features
Basement, Family Room, Free Standing, Gas, Living Room
Price History
| Date | Event | Price |
|---|---|---|
09/09/2026 Source: | Price Decreased | $1,588,800 -3.65% $567/sqft |
08/06/2026 Source: | Listed for Sale | $1,649,000 $589/sqft |
Find Homes by Property Features in North Hempstead, NY
Based on information from OneKey MLS, through Oct 08, 2026, 11:01AM. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. © 2026 OneKey® MLS. All rights reserved.
Advertising Broker: Derek Greene | The Greene Realty Group