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

This stunning newly built corner property is located in the heart of Bayside, the most desirable neighborhood, within the top-rated School District 26. Just steps from Bell Blvd’s vibrant shopping and dining, minutes to the LIRR station, offering express trains directly to Flushing(Main St) and Midtown Manhattan.
Designed with exceptional attention to detail and built with premium materials, this two-family residence is ideal for both investment and self-use. Each floor offers a spacious 3-bedroom, 2-bathroom layout with modern finishes and excellent natural light.
The fully finished basement features 9-foot high ceilings and a separate entrance, offering endless possibilities for extended living space or additional income(New York has implemented new rules regarding Accessory Dwelling Units (ADUs) to increase housing availability)
Elegant floor-to-ceiling windows flood the home with sunlight, and the dual grand entrances facing east and south enhance both brightness and prestige. The property also includes a detached double garage and a wide private driveway for multiple cars.
Situated on an unbeatable corner lot, this home combines luxury, convenience, and timeless value — a truly one-of-a-kind property worth cherishing for generations.

Features
Heating System:
Heat Pump
Cooling System:
Ductless
Basement:
Finished, Full
Garage Spaces:
1
Interior Features:
Eat-in Kitchen, Open Kitchen, Kitchen Island, First Floor Bedroom, First Floor Full Bath, Energy Star Qualified Door(s), Quartz/quartzite Counters, Natural Woodwork
Laundry Features:
Inside, Multiple Locations
Parking Features:
Driveway, Garage, Off Street, Detached, Garage Door Opener
Sewer:
Public Sewer
Utilities:
Trash Collection Public, Electricity Connected, Water Connected, Sewer Connected
Address Map
City:
NY
State:
NY
County:
Queens
Property and Construction
Architectural Style:
Modern
Carport Spaces:
3
Development Status:
Brick
Elementary School:
Ps 41 Crocheron
High School:
Bayside High School
Agent MlsId:
174105
Office MlsId:
SWTK01
MiddleOrJunior School:
Ms 158 Marie Curie
Number Of Units:
2
Special Listing Conditions:
No
Tax Annual Amount:
$4,831
Water Source:
Public
PhotosCount:
43

Residential Income For Sale

38-40 215th Street, New York, NY

3 Bedrooms
4 Bathrooms
$2,480,000
Listing ID #923517
Basic Details
Property Type :
Residential Income
Property SubType :
Triplex
Listing ID :
923517
Price :
$2,480,000
Bedrooms :
3
Bathrooms :
4
Bathrooms Total :
4
Year Built :
2025
Status :
Active
Status :
Active
Listing Office :
Sweet Key Realty Group Inc
Listing Agent :
Qun D. Lin
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!