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 luxurious contemporary two-family residence is perfectly positioned in the heart of Bayside, just steps from Northern Boulevard, offering exceptional convenience and lifestyle appeal. Surrounded by the area’s vibrant dining, shopping, and transportation options, this home masterfully blends modern architecture with thoughtful, practical design.

Property Highlights

Lot Size: 4,000 sq ft

Building Dimensions: 26’ x 53’

Living Space: 1,378 sqft per floor

Total Interior Space: 2,400 sqft

The home is filled with natural light, enhanced by Andersen windows throughout, soaring double-height ceilings, and a stunning chandelier that creates a bright, elegant, and welcoming atmosphere. A lifetime glazed tile roof provides lasting durability, while gas heating and full spray-foam insulation ensure superior energy efficiency and year-round comfort.

Additional features include:

Private paved driveway with off-street parking

2 boilers & 2 hot water tanks

3 electric meters & 2 gas meters

Unit Layout

First & Second Floor Duplex:

4 generously sized bedrooms

3.5 bathrooms

Custom-built closets in every bedroom for optimal storage

First-Floor Rear Unit:

2 bedrooms

2 full bathrooms

Finished Basement
A fully finished high-ceiling basement with a separate entrance, offering flexible space for recreation, extended living, or additional use.

Prime Location
Located within the highly desirable School District #26 and close to all amenities, this exceptional home offers the perfect balance of luxury, comfort, and functionality. A rare opportunity to own a meticulously crafted, modern property in one of Bayside’s most sought-after locations.

Features
Heating System:
Forced Air
Cooling System:
Central Air
Basement:
Finished, Full, Walk-out Access
Flooring:
Hardwood
Garage Spaces:
1
Interior Features:
Eat-in Kitchen, Granite Counters, High Ceilings, Formal Dining, First Floor Bedroom, First Floor Full Bath, Chandelier, Built-in Features
Parking Features:
Driveway, Private, Detached
Sewer:
Public Sewer
Utilities:
Natural Gas Connected, Electricity Connected
Address Map
City:
NY
State:
NY
County:
Queens
Property and Construction
Architectural Style:
Contemporary
Development Status:
Brick
Elementary School:
Ps 162 John Golden
High School:
Francis Lewis High School
Agent MlsId:
216542
Office MlsId:
EXP02
MiddleOrJunior School:
Ms 158 Marie Curie
Number Of Units:
2
Special Listing Conditions:
No
Tax Annual Amount:
$12,293
Water Source:
Public
PhotosCount:
27

Residential Income For Sale

200-38 45th Avenue, New York, NY

6 Bedrooms
7 Bathrooms
$2,480,000
Listing ID #939584
Basic Details
Property Type :
Residential Income
Property SubType :
Duplex
Listing ID :
939584
Price :
$2,480,000
Bedrooms :
6
Bathrooms :
7
Bathrooms Total :
7
Building Area :
2,400 Sqft
Year Built :
2019
Status :
Active
Status :
Active
Listing Office :
EXP Realty
Listing Agent :
Xingye Fu
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!