Prevu by reAlpha
BuySellBlogBrowse Listings

42 Celler AvenueNew Hyde Park, NY 11540

For Sale

$1,588,800

Smart Buyer Rebate $15,888

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.

Listed by Shri Singh

·

BERKSHIRE HATHAWAY

·

516-741-3070

Last updated September 14, 2026

·

Source: OneKey #1035629

Listing Facts

  • TypeSingle-family
  • NeighborhoodNorth New Hyde Park
  • Bedrooms4
  • Bathrooms4
  • Days on Prevu40
  • Taxes$13,000/year
  • Size2,800 sqft
  • Price per sqft$567

Amenities

  • Dishwasher
  • Air Conditioning
  • Parking

Location

Mortgage Calculator

Listing History

09/09/2026
Price Decreased
$1,588,800
08/06/2026
Listed by BERKSHIRE HATHAWAY
$1,649,000
  1. 09/09/2026$1,588,800
    Price Decreased
  2. 08/06/2026$1,649,000
    Listed by BERKSHIRE HATHAWAY

Property Details for 42 Celler Avenue

Exterior

Construction

  • Year Built: 2025
  • Architectural Style: Colonial
  • Construction Materials: Brick

Measurements

  • Building Area Units: Square Feet
  • Lot Size Acres: 0.11
  • Lot Size Dimensions: 50,100
  • Lot Size Square Feet: 5,000

Financial

Taxes

  • Parcel Number: 2289-08-212-00-713-0
  • Tax Annual Amount: $13,000.00
  • Tax Year: 2025

Interior

Features

  • Appliances: Dishwasher, Gas Oven, Humidifier, Refrigerator, Stainless Steel Appliance(s), Gas Water Heater
  • Fireplace Features: Basement, Family Room, Free Standing, Gas, Living Room
  • Fireplace: Yes
  • Fireplaces Total: 2
  • Flooring: Brick, Ceramic Tile, Hardwood
  • 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

Measurements

  • Living Area: 2,800
  • Living Area Source: Public Records

Rooms

  • Basement: Finished, Full
  • Has Basement: Yes
  • Bathrooms Full: 4
  • Bathrooms Total Integer: 4
  • Bedrooms Total: 4
  • Rooms Total: 8

Other

Location

  • Tax Block: 212
  • Tax Lot: 713

Parking

Parking

  • Garage Spaces: 2
  • Garage: Yes
  • Parking Features: Driveway

Schools

Elementary School

  • Elementary School: Manor Oaks William Bowie School
  • Elementary School District: New Hyde Park-Garden City Park

High School

  • High School: New Hyde Park Memorial High School
  • High School District: Sewanhaka Central

Middle or Junior School

  • Middle Or Junior School: New Hyde Park Memorial High School
  • Middle Or Junior School District: Sewanhaka Central

Utilities

Equipment

  • Cooling: Central Air
  • Heating: Hot Air, Natural Gas
  • Laundry Features: In Basement
  • Sewer: Public Sewer
  • Utilities: Natural Gas Connected
  • Water Source: Public

Frequently Asked Questions

How many bedrooms and bathrooms does this single-family home have?

There are 4 bedrooms and 4 bathrooms in this single-family home at 42 Celler Avenue.

What schools are nearby to 42 Celler Avenue?

Nearby schools include the Manor Oaks William Bowie School Elementary School, New Hyde Park Memorial High School Middle School, and New Hyde Park Memorial High School.

Does this single-family home have parking?

Yes, there are 2 parking spaces available for 42 Celler Avenue.

What are the annual taxes for 42 Celler Avenue?

Annual taxes for this single-family home are estimated at $13,000.

How does 42 Celler Avenue compare to other single-family homes in North New Hyde Park?

This single-family home is listed 42% above the average price for single-family homes in North New Hyde Park and has been on the market for 2 less days than the typical home in this area.

What is the square footage on this single-family home?

According to the MLS, this listing is 2,800 sqft.

42 Celler Avenue is a 4-bedroom, 4-bath single-family home for sale in New Hyde Park NY 11540. Listed on Prevu for 40 days at $1,588,800. This includes a recent price decrease of $60,200. This property features 2,800 square feet of living space, located in North New Hyde Park. The median listing price for single-family homes in this area is $982,500. Nearby schools include Manor Oaks William Bowie School Elementary School, New Hyde Park Memorial High School Middle School, and New Hyde Park Memorial High School. Additional amenities include dishwasher, air conditioning, and parking. View other single-family home listings in Nassau County.

The data relating to real estate for sale on this website comes in part from the IDX Program of OneKey™ MLS. The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed. This information is provided exclusively for consumers’ personal, non-commercial use. Information Copyright 2026, OneKey™ MLS. All Rights Reserved.

Full MLS Disclaimers

Rebate estimate is indicative only and based on listing price and estimated buyer's agent commission paid by owner, if applicable. Final rebates are subject to Terms of Use and may vary due to final negotiated transaction terms.