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

Welcome to this fully rebuilt (2026) semi-attached 2-family home in the heart of Oakland Gardens/Bayside, located in the highly sought-after School District 26. Everything new, modern, and beautifully finished — truly shining from top to bottom.

Perfect for both end-users and investors, this versatile property features two spacious units with comfortable layouts and split AC systems in every room for efficient year-round comfort.

The first-floor unit offers 3 bedrooms and 2 full bathrooms, along with access to a full finished basement complete with laundry and a half bath, ideal for recreation, a home office, gym, or additional storage.

The second-floor unit features 2 bedrooms, bonus room perfect for home office, and 2 full bathrooms, along with in-unit washer and dryer for added convenience. This unit also duplexes to the third level, where you’ll find an additional ensuite bedroom with a full bathroom, perfect for extended family or additional living space.

The home is excellently configured with fully separated utilities, including 3 electric meters, 2 gas meters, and separate gas heating and hot water systems.

Additional highlights include a private driveway and a fully fenced property offering privacy and security.

Conveniently located near Bell Blvd, Springfield Blvd, Cunningham Park, shopping, dining, transportation, and the LIE, this property offers both a wonderful place to live and strong income potential.

Probably the best-priced 2-family in Bayside — don’t miss this opportunity!

Features
Heating System:
Natural Gas
Cooling System:
Ductless
Basement:
Finished, Full
Flooring:
Hardwood
Interior Features:
Washer/dryer Hookup, First Floor Bedroom, First Floor Full Bath, Primary Bathroom
Laundry Features:
In Basement
Parking Features:
Carport
Sewer:
Public Sewer
Utilities:
Electricity Available, Trash Collection Public, Natural Gas Connected, Water Connected
Address Map
City:
NY
State:
NY
County:
Queens
Directions:
Google Map
Property and Construction
Architectural Style:
Colonial
Carport Spaces:
1
Development Status:
Frame
Elementary School:
Ps 46 Alley Pond
High School:
Benjamin N Cardozo High School
Agent MlsId:
177825
Office MlsId:
KWLG01
MiddleOrJunior School:
Jhs 74 Nathaniel Hawthorne
Number Of Units:
2
Special Listing Conditions:
No
Tax Annual Amount:
$8,684
Water Source:
Public
PhotosCount:
42

Residential Income For Sale

64-46 217th Street, New York, NY

6 Bedrooms
6 Bathrooms
$1,485,000
Listing ID #962835
Basic Details
Property Type :
Residential Income
Property SubType :
Duplex
Listing ID :
962835
Price :
$1,485,000
Bedrooms :
6
Bathrooms :
6
Bathrooms Total :
6
Building Area :
1,982 Sqft
Year Built :
1950
Status :
Active
Status :
Active
Listing Office :
Keller Williams Legendary
Listing Agent :
Kenny Eng E-PRO PSA
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!