Opportunity is here in Little Neck, Queens. This property offers unparalleled long-term value. Why You'll Love It: 3+ spacious bedrooms, 1.5 bathrooms, a formal dining room, cozy living room, and a bonus home office/sitting room. Bonus Square Footage: A full walk-up attic and a full basement with a private outside entrance-perfect for storage, a rec room, or guest space. Top-Tier Education: Situated in the highly coveted, Public School District #26 (including PS 98 Douglaston and JHS 67 Louis Pasteur). Commuter's Paradise: Enjoy a quiet, peaceful neighborhood feel while maintaining easy, rapid access to the LIRR, MTA buses, local shopping, and dining. Parking for 4+ Vehicles: Long private driveway plus a detached garage. Bring your design ideas and planting tools for the yard! This property is a rare find in a "silent zone" neighborhood where daily errands don't even require a car. This single-family Cape Cod, building size 22 x 24, with 1,496 sq. ft sits on a prime 40' x 115' lot (4,600 sq. ft.) featuring highly desirable R3-1 zoning, which permits conversion or construction of a two-family residence. Whether your goal is to flip, generate steady rental income in a high-demand market, or clear the lot for a custom luxury build, the fundamentals here are unbeatable.

Property Details of 42-46 247th Street

Property Details

Interior Features

Utilities and Appliances

Community

Other Details

Map Location

Driving Directions

Listings courtesy of OneKey® MLS as distributed by MLS GRID. Based on information submitted to the MLS GRID as of September 1, 2026 8:21 AM UTC. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. IDX information is provided exclusively for consumers’ personal noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed by MLS GRID. The use of the MLS GRID Data may be subject to an end user license agreement.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from East Egg Realty. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

$

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.