- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes


Street View
$1,199,888
Monthly Est:$5,972
3 Beds
- 2 Baths
1 full bath + 1 half bath
1,496sqft
42-46 247th Street, New York, NY 11363
$1,199,888
$5,972/moEst:
Get Pre-Approved
Single Family Residence
Built in 1925
$-- HOA
4,600 sqft lot
$802/sq.ft
Description
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.
- Houzeo last checked: 12 hours ago
- Listing updated: October 1, 2026 at 10:09 pm
- Listing Provided by: David Esposito (718) 309-8656 | Century Homes Realty Group LLC (718) 886-6800
- Source: OneKey MLS-NY as distributed by MLS GRID | MLS#: 991207

Property Details
Status
Pending
Type
Single Family Residence
No. of Stories
-
County
City
Neighborhood
Year Built
1925
HOA Fees
-
Finished Area
1,496 sqft
Lot Size
4,600 sqft lot
Basement Area
- sqft
MLS Name
OneKey MLS
MLS Number
991207
MLS Status
Pending
Days on Market
189
Cumulative Days on Market
119

Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 3
Bathrooms: 2
Living Room
Level: First
Bedroom 1
Level: Second
Basement
Level: Basement
Interior
Appliances
Dishwasher, Microwave, Oven, Range, Refrigerator, Gas Water Heater
Interior Features
Ceiling Fan(s), Entrance Foyer, Formal Dining
Flooring
Hardwood
Heating
Natural Gas
Sewer
Public Sewer
Cooling
Wall/window Unit(s)
Construction
Year Built
Year Built: 1925
Home type
Single Family Residence
Construction Materials
Shingle Siding
Architectural Style
Cape Cod
Property Condition
Actual
Utilities & Energy
Basement
Full, Walk Out Access
Parking Features
Driveway
Water Source
Public
Utilities
Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Security Features
Building Security
Price History
| Date | Event | Price |
|---|---|---|
08/25/2026 Source: | Pending | $1,199,888 $802/sqft |
06/23/2026 Source: | Price Decreased | $1,199,888 -7.70% $802/sqft |
05/10/2026 Source: | Price Decreased | $1,300,000 -13.22% $869/sqft |
04/27/2026 Source: | Price Increased | $1,498,000 +24.84% $1,001/sqft |
04/27/2026 Source: | Listed for Sale | $1,199,888 $802/sqft |
Nearby Homes
Find Homes by Property Features in New York, NY
Based on information from OneKey MLS® through Nov 02, 2026, 02:16PM as submitted to and distributed by MLS GRID. 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 non-commercial use. It 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 prescribed by the Member Participant’s applicable MLS, if any, and as amended from time to time. © 2026 OneKey MLS. All rights reserved.
Advertising Broker: Derek Greene | The Greene Realty Group










