Redfin is joining Rocket

Discover how we're simplifying your journey home.

$2,798,000

150-28 17th Rd Whitestone, NY 11357

7 beds
7 full
Multi-Family

Property details

About 150-28 17th Rd

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.

Highlights

Home typeDuplex
HeatingElectric
StatusActive
CoolingCentral Air
BasementYes
Year built2025
ParkingDriveway, Garage
MLS #887234
Garage1 space

Summary

  • Full Bathrooms: 7
  • Basement: Yes
  • Interior: First Floor Bedroom, First Floor Full Bath, Eat-in Kitchen, Formal Dining, Marble Counters, Open Kitchen
  • Total Bedroom Count: 7
  • Garage Space: 1 space
  • Parking: Driveway, Garage
  • Heating: Electric
  • Cooling: Central Air
  • List Price: $2,798,000
  • Year Built: 2025
  • MLS Number: 887234
  • MLS Name: ONEKEY2
  • Office Name: E Realty International Corp
  • Office Phone: (718) 886-8110

IDX Listings courtesy of OneKey MLS as distributed by MLS GRID.

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. Properties displayed may be listed or sold by various participants in the MLS.

DMCA Notice

IDXThe data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the OneKey™ MLS. Real Estate listings held by brokerage firms other than this broker are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers. This information is provided exclusively for consumers’ personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed.

Information Copyright 2025, OneKey™ MLS. All Rights Reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.

This advertisement does not suggest that the broker has a listing in this property or properties or that any property is currently available.
Last updated on: 7/11/2025, 6:41:27 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.

Price information

Property sales

We're sorry, we currently don't have property sales data for this listing.

Tax history

We're sorry, we currently don't have tax history data for this listing.

Nearby schools

8

P.S. 209 Clearview Gardens School

Public Magnet PK-5

0.2 mi

1610 Utopia Pkwy

7

P.S. 184 Flushing Manor School

Public District KG-5

0.3 mi

16315 21st Rd

8

P.S. 169 Bay Terrace School

Public District PK-5

0.9 mi

1825 212th St

School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.

All data from GreatSchools

Neighborhood

The neighbors living near this home have an average income of $45,580. The most common annual income of people living in Whitestone, NY is less than $<35k. Typical family type is single, no kids. Typical level of education for residents in this area is high school diploma.

How much money do the neighbors make?

43%
<35k
39%
35k-100k
14%
100k-200k
4%
200k+

What level of education do the neighbors have?

High School Diploma
Post Secondary Degree
Masters Degree

What types of families live nearby?

57%
Single, No Kids
4%
Single, with Kids
26%
Married, No Kids
13%
Married, with Kids

Are the neighbors home owners or renters?

Home Owners
Renters

How old are people in this area?

8%
<11 yrs old
5%
12-17 yrs old
18%
18-34 yrs old
40%
35-64 yrs old
29%
65+ yrs old

What do the neighbors do for fun?

  • Men's TennisMen's Tennis
  • Live TheatreLive Theatre
  • Hiking/backpackingHiking/backpacking

Where do the neighbors shop?

  • Nordstrom RackNordstrom Rack
  • BloomingdalesBloomingdales

Where do the neighbors go to eat?

  • The Cheesecake FactoryThe Cheesecake Factory
  • Boston MarketBoston Market
  • StarbucksStarbucks

What do the neighbors drive?

  • VolvoVolvo
  • MercedesMercedes
  • AudiAudi

What do the neighbors listen to?

  • NewsNews
  • AlternativeAlternative
All data provided by Home Junction and Claritas

Similar homes for sale

Frequently asked questions

About 150-28 17th Rd

The listing price of 150-28 17th Rd property is $2,798,000.

The property 150-28 17th Rd is a multi located in Whitestone, New York, 11357.

Active Listing: 150-28 17th Rd is For Sale (Active/New) which means the seller is accepting offers.

The nearby schools for 150-28 17th Rd are: P.S. 209 Clearview Gardens School (GreatSchools Rating 8/10), P.S. 184 Flushing Manor School (GreatSchools Rating 7/10), P.S. 169 Bay Terrace School (GreatSchools Rating 8/10), J.H.S. 194 William Carr (GreatSchools Rating 7/10), Bell Academy (GreatSchools Rating 8/10), I.S. 25 Adrien Block School (GreatSchools Rating 7/10), Bayside High School (GreatSchools Rating 8/10), World Journalism Preparatory: A College Board School (GreatSchools Rating 8/10), Flushing International High School (GreatSchools Rating 3/10).

The year of construction for 150-28 17th Rd is 2025.

This home is located at 150-28 17th Rd in Whitestone, NY and zip code 11357 in the Whitestone neighborhood. Features: 7 bedrooms, 7 bathrooms. It has been listed on Rocket Homes since July 9, 2025 and is currently priced at $2,798,000.

In June 2025 more than 232 listings in Whitestone, NY were sold above the asking price. During the same period more than 1007 listings were sold at asking price, while more than 715 were sold below. In June 2025 in Whitestone, NY there were 4.3% less homes for sale than in May. In June 2025, listings were on the market for 99 days. During the same period, the median list price in this real estate market was $881,252.

From Rocket Homes Real Estate and based on county public records data.

More resources