Coldwell Banker Home Page
Skip to main contentColdwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker American Homes
Property view
Listing view 2
Listing view 3

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

$1,300,000

3

Beds

2

Baths

1,496

Sq Ft

Single Family

Active

Listed by

David Esposito

Century Homes Realty Group LLC.

Last updated:

June 2, 2026, 10:43 AM

MLS#

991207

Source:

OneKey MLS

About This Home

42-46 247th Street

Investor or end user, whether you’re looking to generate rental income, or build a custom family home, this property presents a good opportunity in one of Queens’ most desirable neighborhoods, Little Neck, Queens. This single family home is Zoned R3-1 ,(R3-1 districts that allow two-family residences) Featuring 3 bedrooms, 1.5 bathrooms, a spacious kitchen, formal dining room, living room, and a home office / sitting room, full walk up attic and basement with separate entrance. This property is ideal for both end-users and investors alike. Situated within a top-rated public school district # 26, this home provides long-term value. Its convenient location offers easy access to the LIRR, MTA buses, schools, shopping, dining, and everyday essentials. R3-1 Zoning. All information deemed accurate yet should be independently verified by buyer agent / broker agent and or buyer. Shown by appointment.

Home Facts

Single Family

2 Baths

3 Bedrooms

Built in 1925

Price Summary

1,300,000

$868 per Sq. Ft.

MLS #:

991207

Last Updated:

June 2, 2026, 10:43 AM

Added:

a month ago

Rooms & Interior

Bedrooms

Total Bedrooms:

3

Bathrooms

Total Bathrooms:

2

Full Bathrooms:

1

Interior

Living Area:

1,496 Sq. Ft.

Structure

Structure

Architectural Style:

Cape Cod

Building Area:

1,496 Sq. Ft.

Year Built:

1925

Lot

Lot Size (Sq. Ft):

4,600

Finances & Disclosures

Finances

Price:

$1,300,000

Price per Sq. Ft:

$868 per Sq. Ft.

Source:OneKey MLS
Copyright 2026 OneKey MLS. All rights reserved. Listings courtesy of OneKey MLS as distributed by MLS GRID . OneKey MLS provides content displayed here (“provided content”) on an “as is” basis and makes no representations or warranties regarding the provided content, including, but not limited to those of non-infringement, timeliness, accuracy, or completeness. Individuals and companies using information presented are responsible for verification and validation of information they utilize and present to their customers and clients. OneKey MLS will not be liable for any damage or loss resulting from use of the provided content or the products available through Portals, IDX, VOW, and/or Syndication. Recipients of this information shall not resell, redistribute, reproduce, modify, or otherwise copy any portion thereof without the expressed written consent of OneKey MLS.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.