There is no favorite listings!

Properties For Sale or Rent

Check out our newly listed properties for sale or rent in your area by using our search tools.

Property Description

Located in the heart of Little Neck, Queens, this well-maintained 2-family home , Zoned R3-1 offers space, flexibility, and exceptional potential. Featuring 4 bedrooms, 2 full bathrooms, a spacious kitchen, formal dining room, inviting living room, and a home office / sitting room, this property is ideal for both end-users and investors alike.

Situated within a top-rated public school district # 26, this home provides both comfort and long-term value. Its convenient location offers easy access to the LIRR, MTA buses, schools, shopping, dining, and everyday essentials.

Whether you’re looking to live in, generate rental income, or build a larger custom 2-family home, this property presents a rare opportunity in one of Queens’ most desirable neighborhoods.

R3-1 Zoning: The 0.5 FAR (Floor Area Ratio) may be increased by an attic allowance of up to 20% for the inclusion of a space beneath a pitched roof. The perimeter wall may rise to 21 feet before sloping or being set back to a maximum building height of 35 feet.)

Features
Heating System:
Steam
Cooling System:
Wall/window Unit(s)
Basement:
Full, Walk-out Access, See Remarks
Flooring:
Hardwood
Garage Spaces:
1
Interior Features:
Entrance Foyer
Parking Features:
Driveway, Garage
Sewer:
Public Sewer
Utilities:
Trash Collection Public, Natural Gas Connected, Electricity Connected, Cable Connected, Water Connected, Sewer Connected, Phone Connected
Address Map
City:
NY
State:
NY
County:
Queens
Direction Faces:
East
Directions:
Waze. From Flushing, Northern Blvd East, North (Left) on 247th St.
Property and Construction
Architectural Style:
Cape Cod
Development Status:
Shingle Siding
Elementary School:
Ps 94 David D Porter
High School:
Benjamin N Cardozo High School
Agent MlsId:
190866
Office MlsId:
DAER01
MiddleOrJunior School:
Jhs 67 Louis Pasteur
Number Of Units:
2
Special Listing Conditions:
No
Tax Annual Amount:
$7,977
Water Source:
Public
PhotosCount:
5

Residential Income For Sale

42-46 247th Street, New York, NY

$1,498,000
Listing ID #985292
Basic Details
Property Type :
Residential Income
Property SubType :
Duplex
Listing ID :
985292
Price :
$1,498,000
Bathrooms Total :
0
Building Area :
1,496 Sqft
Year Built :
1925
Status :
Active
Status :
Active
Listing Office :
Century Homes Realty Group LLC
Listing Agent :
David Esposito
Agent info
Kasner Properties
284 W Park Ave Long Beach, NY 11561
Contact Agent
Walkscore
Style Selector
Select the layout
Choose the theme
Preset colors
No Preset
Select the pattern

Saved Searches

You should login first to see your saved searches!