Skip main navigation
For sale
$1,649,000
4beds
2,800sqft

42 Celler Avenue, New Hyde Park, NY 11540

4beds
2,800sqft
Single family residence, residential
Built in 2025
5,000 sqft
2 Garage spaces
$589 price/sqft

What's special

Open light-filled floor planOversized islandSoaring ceilingsElegant architectural detailsPremium finishesCustom cabinetry

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.

25 days
|
4,040
|
118
|
Source: OneKey® MLS as distributed by MLS GRID,MLS#: 1035629MLS Logo
Travel times

Living Room

Kitchen

Primary Bedroom

Zillow last checked:

Listing updated:

Listed by:

BERKSHIRE HATHAWAY 516-741-3070,

Shri Singh 516-734-1299

Source: OneKey® MLS as distributed by MLS GRID,MLS#: 1035629MLS Logo

Facts & features

Interior

Bedrooms & bathrooms
  • Bedrooms: 4
  • Bathrooms: 4
  • Full bathrooms: 4
Other
  • Description: Entrance foyer, LR w/FP, EIK, 1BR Full Bath , Porch and covered deck
  • Level: First
Other
  • Description: MB suite, 3 Bedrooms, Full Bath , attic
  • Level: Second
Other
  • Description: Walk up attic
  • Level: Other
Other
  • Description: Full finished basement , OSE, Full Bath , Family Room with W/D
  • Level: Basement
Heating
  • Hot Air, Natural Gas
Cooling
  • Central Air
Appliances
  • Included: Dishwasher, Gas Oven, Humidifier, Refrigerator, Stainless Steel Appliance(s), Gas Water Heater
  • Laundry: In Basement
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
  • Flooring: Brick, Ceramic Tile, Hardwood
  • Basement: Finished,Full
  • Attic: Finished,Full
  • Number of fireplaces: 2
  • Fireplace features: Basement, Family Room, Free Standing, Gas, Living Room
Interior area
  • Total structure area: 2,800
  • Total interior livable area: 2,800 sqft

Property

Parking
  • Total spaces: 2
  • Parking features: Driveway
  • Garage spaces: 2
  • Has uncovered spaces: Yes
Lot
  • Size: 5,000 Square Feet
  • Dimensions: 50 x 100
Details
  • Parcel number: 228908212007130
  • Special conditions: None

Construction

Type & style
  • Home type: SingleFamily
  • Architectural style: Colonial
  • Property subtype: Single Family Residence, Residential
Materials
  • Brick
Condition
  • Year built: 2025

Utilities & green energy

  • Sewer: Public Sewer
  • Water: Public
  • Utilities for property: Natural Gas Connected

Community & HOA

HOA
  • Has HOA: No
Location
  • Region: New Hyde Park

Financial & listing details

  • Price per square foot: $589/sqft
  • Annual tax amount: $13,000
  • Date on market: 8/6/2026
  • Cumulative days on market: 26 days
  • Listing agreement: Exclusive Right To Sell

Price history

DateEventPrice
8/6/2026Listed for sale$1,649,000$589/sqft
Source: OneKey® MLS as distributed by MLS GRID #1035629 Report a problem

Public tax history

Tax history is unavailable.

Monthly payment

Estimated monthly payment$1,822
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
See how much you could borrow to make a competitive offer.
Get pre-qualified

Estimated market value

Not available

Estimated sales range

Not available

Not available

Climate risks

Explore flood, wildfire, and other predictive climate risk information for this property on First Street®️.

Neighborhood: North New Hyde Park

Nearby schools

Manor Oaks William Bowie School
Grades PK-6 • 0.4 miles
7/10
GreatSchools® Rating
Test Score Rating
9/10
Student Progress Rating
4/10
New Hyde Park Memorial High School
Grades 7-12 • 0.8 miles
7/10
GreatSchools® Rating
Test Score Rating
9/10
College Readiness Rating
7/10
Student Progress Rating
3/10

      Nearby cities

      Nearby neighborhoods

      Nearby zip codes

      Other New Hyde Park Topics

        Search
        Updates
        Favorites
        Plan
        Inbox