Water Front Luxury Realty

Save
Ask
Tour
Hide
Share
$2,798,000
23 Days On Site

150-28 17 Road
Whitestone, NY 11357

For Sale|Duplex|Active
7
Beds
7
Total Baths
7
Full Baths
3,300
SqFt
$848
/SqFt
2025
Built
County:
Queens
Listing courtesy of E Realty International Corp Anna.realtorny@gmail.com

Due to the health concerns created by Coronavirus we are offering personal 1-1 online video walkthough tours where possible.

Call Now: 987-456-3210
Is this the listing for you? We can help make it yours.
987-456-3210
Upcoming Open Houses
Due to COVID-19, we recommend you verify Open Houses before attending.
Sat, Aug 2, 2:30 PM - 4:30 PM
Sun, Aug 3, 2:30 PM - 4:30 PM
150-28 17 Road150-28 17 Road150-28 17 Road150-28 17 Road
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$12,766
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2025 Information is deemed reliable but not guaranteed.

Located in Whitestone, this huge two-family mansion newly built in 2025 has a magnificent appearance, high-end materials, fine workmanship, central air conditioning and customized wardrobes, which undoubtedly enhances the comfort and luxury of living. The high-end Crystal Chandelier decoration in the living room creates a perfect home life quality. The mansion also has solar energy installed. The solar energy system is not only environmentally friendly, but also effectively reduces energy consumption and reduces the economic burden. It is a double-excellent choice for self-occupancy and investment. The Front luxurious master unit: First floor: open kitchen and dining room + 1 bath Second floor: spacious 4 bedrooms and 3 baths (2 suites) and large living room with a large balcony High-ceiling attic with large windows, natural sun lights, can be used for bedrooms, study rooms or leisure areas. The back luxurious rental unit: Open kitchen and living room, 3 bedrooms and 2 baths High-ceiling basement, separate entrance and 1 Full bath , about 1,650 feet, relatively large area, can be used for a variety of purposes, such as family entertainment room, gym, etc. There is a one car garage and long driveway that can park multiple cars. It is only 5 minutes away from Parsons Blvd Hualian Supermarket, and only 1 minute walk to Bus Station Q15 to Flushing. There are banks, restaurants, and everything else nearby, with convenient transportation and shopping.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$2,798,000
Days On Site 
23 Days
Bedrooms 
7
Inside Area (SqFt) 
3,300 sqft
Total Baths 
7
Full Baths 
7
Partial Baths 
N/A
Lot Size 
N/A
Year Built 
2025
MLS® Number 
887234
Status 
Active
Property Tax 
$7,873
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
3 weeks agoListing first seen on site
3 weeks agoListing updated with changes from the MLS®
General Features
Energy Features 
Solar
Garage 
Yes
Garage Spaces 
1
Parking 
DrivewayGarage
Parking Spaces 
5
Property Sub Type 
Duplex
Sewer 
Public Sewer
SqFt Total 
3300
Utilities 
Electricity Connected
Water Source 
Public
Interior Features
Basement 
FinishedFullWalk-Out Access
Cooling 
Central Air
Heating 
Electric
Interior 
Eat-in Kitchen
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
Brick
Community Features
School District 
Queens 25
Schools
School District
Queens 25
Elementary School
Ps 79 Francis Lewis
Middle School
Jhs 194 William Carr
High School
Flushing High School
Listing courtesy of E Realty International Corp Anna.realtorny@gmail.com


Based on information submitted to the MLS GRID as of 2025-08-02 04:29 AM EDT. 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.

Neighborhood & Commute
Source: Walkscore
Community information and market data Powered by ATTOM Data Solutions. Copyright ©2019 ATTOM Data Solutions. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share

REACH MICHELLE MADTES!


    error: Content is protected !!