Price Reduced Listing
$1,588,800
 $8,529 est/mo Sourced by Back At You

42 Celler Avenue,New Hyde Park, NY 11540

New Hyde Park, NY 11540

Share:

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.

Details

MLS #1035629
Listing TypeFor Sale
StyleHouse
Sub-TypeResale
StatusActive
Year2025
Days On Site40
Listing Provided ByBERKSHIRE HATHAWAY | Shri Singh

Features

Bed(s)4
Bath(s) 4 Total
SQ Feet2,800
Garage2
BasementY
Acreage0.11

Interior

CoolingCentral Air
HeatingHot Air, Natural Gas
Interior FeaturesFirst 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
AppliancesDishwasher, Gas Oven, Humidifier, Refrigerator, Stainless Steel Appliance(s), Gas Water Heater

Exterior

Construction MaterialsBrick

Parking

Garage Yes / NoYes
Parking FeaturesDriveway

Utilities

UtilitiesNatural Gas Connected
SewerPublic Sewer

Taxes

Tax Year2025
Tax Annual Amount13000
Tax Lot713

Area Information

StateNY
CountyNassau County
CityNew Hyde Park
Zip Code11540
School DistrictNew Hyde Park Memorial High Scho
Elementary SchoolManor Oaks William Bowie School
High SchoolNew Hyde Park Memorial High Scho
Listing VS Median (in 11540)
Price:
$1,588,800
low | high
Med:
$1,588,800
50% of Average
sqft:
2,800
low | high
Med:
2,800
50% of Average
$ / sqft:
$567
low | high
Med:
$567
50% of Average
On site:
40
low | high
Med:
40
100% of Average
Sourced by Back At You

Request a showing

Request a showing

Contact


Additional Information


Showing Information


Submit Form

Required Field
By submitting, you agree to receive promotional texts and/or calls from John J Lease Realtors at the number provided. Message/data rates may apply. Consent is not a condition of purchase, and you can opt out anytime by replying STOP.
MLS Internet Data Exchange (IDX) information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the OneKey® MLS

Contact

Learn More About This Property

StateNY
CountyNassau County
CityNew Hyde Park
Zip Code11540
School DistrictNew Hyde Park Memorial High Scho
Elementary SchoolManor Oaks William Bowie School
High SchoolNew Hyde Park Memorial High Scho
Listing VS Median (in 11540)
Price:
$1,588,800
low | high
Med:
$1,588,800
50% of Average
sqft:
2,800
low | high
Med:
2,800
50% of Average
$ / sqft:
$567
low | high
Med:
$567
50% of Average
On site:
40
low | high
Med:
40
100% of Average
Sourced by Back At You
Nearby Listings (Within 1/4 mile)
Price: $1.191M - $1.986M
sqft: 2,000 - 3,500
Nearby Listings Property ImageNearby Listings Details
1635 Hillside Avenue Property Photo 1
$150,000
1635 Hillside Avenue
New Hyde Park, NY 11040
Listing Updated: September 14, 2026 at 4:13:14 PM PDT