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.
For sale
$2,798,000
150-28 17 Road, Whitestone, NY 11357
7beds
3,300sqft
Duplex, Multi Family
Built in 2025
-- sqft lot
$-- Zestimate®
$848/sqft
$-- HOA
What's special
Central air conditioningOne car garageCustomized wardrobesHigh-end crystal chandelier decorationLong driveway
- 23 days
- on Zillow |
- 1,634 |
- 77 |
Zillow last checked: 7 hours ago
Listing updated: July 29, 2025 at 06:17am
Listing by:
E Realty International Corp 718-886-8110,
Yanan Eill 516-493-5363
Source: OneKey® MLS,MLS#: 887234

Travel times
Tour with a buyer's agent
Tour with a buyer's agent
Open houses
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 7
- Bathrooms: 7
- Full bathrooms: 7
Heating
- Electric
Cooling
- Central Air
Features
- First Floor Bedroom, First Floor Full Bath, Eat-in Kitchen, Formal Dining, Marble Counters, Open Kitchen
- Basement: Finished,Full,Walk-Out Access
- Attic: Finished,Full
Interior area
- Total structure area: 3,300
- Total interior livable area: 3,300 sqft
Property
Parking
- Total spaces: 5
- Parking features: Driveway, Garage
- Garage spaces: 1
- Carport spaces: 4
- Has uncovered spaces: Yes
Lot
- Size: 5,000 Square Feet
- Dimensions: 50 x 100
Details
- Parcel number: 046860038
- Special conditions: None
Construction
Type & style
- Home type: MultiFamily
- Property subtype: Duplex, Multi Family
Materials
- Brick
Condition
- Year built: 2025
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Electricity Connected
Green energy
- Energy generation: Solar
Community & HOA
Location
- Region: Flushing
Financial & listing details
- Price per square foot: $848/sqft
- Tax assessed value: $1,232,000
- Annual tax amount: $7,873
- Date on market: 7/9/2025
- Listing agreement: Exclusive Right To Sell
- Electric utility on property: Yes
- Loading
- Loading