Robert J. Habberfield

42-20 247th Street, Little Neck, NY 11363

New - 10 Hours Ago
View Full Photo Gallery

Property Description

Welcome to this rare, BRAND-NEW luxury two-family home in the heart of Little Neck! The main unit features soaring ceilings, 4 bedrooms, and 3.5 bathrooms, including 2 spacious primary suites with large closets. The second unit offers 3 bedrooms and 2 full bathrooms. The property also includes a fully finished basement with 9-foot ceilings, a full bathroom, and two separate entrances, providing excellent flexibility for additional living or recreational space. A detached garage and a long private driveway offer ample parking for multiple vehicles. Situated on a 40' 115' lot with a 26' 61' building size, this exceptional home is built with premium construction materials and showcases high-end finishes throughout. Additional features include gas service, elegant glazed roof tiles, central air conditioning, a finished attic, a security camera system, soaring ceilings, and abundant natural light. Conveniently located near the LIRR, Q12 bus, P.S. 94, M.S. 67, JMart Supermarket, restaurants, shopping, and everything.

42-20 247th Street | MLS# 1025119

This multi-family property located at 42-20 247th Street, Little Neck, NY 11363 is currently listed for sale with an asking price of $2,698,000. 42-20 247th Street is located within the Queens 26 school district. Search Little Neck real estate on bob-habberfield.coldwellbankerprime.com today.

Gallery

Property Features

Property Type: Multi Unit - Multiple
Basement: Yes
Basement: Finished, Full, Walk-Out Access
Cooling: Central Air
Garage: 1
Heating: Natural Gas
Lot Size: 0.11 Acres
Taxes: $12,001
Year Built: 2026

Amenities

First Floor Bedroom
First Floor Full Bath
Cathedral Ceiling(s)
Open Kitchen
Primary Bathroom

Feature Descriptions

Building Area Total: 3058
Exterior: Brick
GarageY/N: Yes
On Market Date: 2026-07-13
Parcel Number: 08116-0092
Parking Features: Detached, Driveway, Private
Property Attached Y/N: 1
Rental Term: Monthly
Sewer: Public Sewer
Units: 2
Utilities: Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water: Public

Local Schools

High School: Benjamin N Cardozo High School
Middle School: Jhs 67 Louis Pasteur
Elementary School: Ps 94 David D Porter
School District: Queens 26

Estimate Your Payment

Estimated Payment

$ 7,791.58 per month $6,004.58 Principal & Interest $1,000.08 Property Tax $786.92 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)

Demographics

Listed By / Shown By

Listing By

Agency Name: H N L Realty Inc
Agency Contact: 718-504-7366

Shown By

Agent Name: Robert J. Habberfield
Agent Phone: (315) 415-2245 Cell
Agency Title: Coldwell Banker Prime Properties

IDX logo

Login to My Homefinder

Pixel