42-46 247th Street, Little Neck, NY 11363 | MLS 991207 | Listing Information | Arash Real Estate - Mohsen Zandieh | MLSLI.com - Long Island Real Estate
fill
fill
fill
Arash Real Estate
Main Office:
718-279-0300
Mohsen@arashrealestate.com
fill
fill
fill
fill
Arash Real Estate
fill
Main Office:
718-279-0300
Mohsen@
arashrealestate.com
fill
fill
fill
fill
fill
fill
fill
Email Alerts
fill
Buyer Information
fill
Seller Information
fill
Your Home's Value
fill
Community & School Info
fill
Real Estate Glossary
fill
fill
fill
FOR SALE
$1,199,888

42-46 247th Street
Little Neck, NY 11363

Single Family
Residential
3
Beds
1
Baths
1,496
Sq. Ft.
0.105
Acre Lot
Courtesy: Century Homes Realty Group LLC
MLSLI> New York> Little Neck> 11363
Welcome home to this charming 1,496 sq. ft. Cape Cod nestled on a generous 4,600 sq. ft. lot in beautiful, tranquil Little Neck. Whether you are looking to move right into a classic neighborhood or build your absolute dream custom family home, this property offers unparalleled long-term value. Why You'll Love It: Space to Grow: 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, top-rated 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. Investors and builders, take note! This single-family Cape Cod 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. The Asset Details: Current Layout: 1,496 sq. ft. footprint, 3 BR / 1.5 BA, formal dining, and home office. Income Potential: Full walk-out basement with its own separate private entrance and separate meters, plus a full walk-up attic. Location Premium: Located in School District #26 - traditionally one of the highest-performing districts in New York City, ensuring historic property value resilience and fierce demand from tenants. Logistics: Detached garage with a 4-car driveway. Short distance to the Little Neck LIRR station for an easy commute into Manhattan. ?? Shown by Appointment Only. Contact us today to schedule a private walkthrough! All information deemed accurate yet should be independently verified by buyer agent / broker agent and or buyer
991207
Residential - Single Family, Cape Cod
3
1 Full/1 Half
1925
Queens
0.105 Acres
Public Water
Shingle Siding
Public Sewer
Loading...
Loading...

Estimated Payment:

Principle & Interest
Taxes
Insurance
%
%
Courtesy: Century Homes Realty Group LLC
This content last refreshed on 7/10/2026 6:02 PM CST. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.
Information is deemed reliable but is not guaranteed.