Skip to main content

MLS ID KEY1027635Last updated Aug 17, 2026

Duplex

174-28 128th Avenue

Pending · Queens, NY 11434

Asking price$1,495,000Check current status
Bedrooms
8 Beds
Bathrooms
5 Baths
Year built
2026
Est. monthly taxes
$583.33
Property gallery0 / 15
Loading photo…Photo unavailable

About this home

Whether you're seeking a sophisticated primary residence with supplemental income or a valuable addition to your investment portfolio, this remarkable property offers the perfect blend of luxury, flexibility, and long-term value. This custom built brand new construction two family will captivate you from the moment you arrive with its warm & welcoming energy. Ideal for buyers looking for space, plus income generating rental property to assist with mortgage payments. Welcome to 174-28-128th Avenue! A Custom Built Massive Two Family spanning 8 bedrooms & 5 Full baths. Tucked away on a beautiful picturesque block of The Rochdale/ Locus Manor border Sitting on a massive lot featuring a wide private driveway Offering two 4 bedroom 2 bath units over a high ceiling full finished basement with both interior and exterior access. Both units enjoy modern, open concept living/dining areas which provide great space for entertaining. Beautiful chefs granite kitchens equipped with floor to ceiling custom cabinetry, adorned with a full fleet of stainless steel appliances and equipped with island for bar stool seating. Well proportioned bedrooms with ample closet space. The primary suite is your private escape. Featuring a private en suite with spa like finishes. Down the hall a additional fully tiled bathroom is adorned with state of the art wall & floor tiles and shared between the additional bedrooms. The high ceiling full finished basement can easily be used as a media den, guest quarters, additional recreational space or ADU This exceptional two family presents a rare opportunity to own a piece of Rochdale/Locust Manor, while enjoying the space, privacy, and lifestyle the neighborhood has to offer. Conveniently located with close proximity to major transportation which makes commuting a breeze. Just off Merrick Blvd, Baisley Blvd, Farmers Blvd, Belt Parkway. Short blocks to schools, Green Acres Commons, JFK Airport, restaurants, cafes, parks and many other vibrant neighborhood amenities. Do not miss your opportunity to own one of the last houses on the market in Rochdale, that checks all the boxes for modern day luxury, space, & style!

Listing snapshot

Days on site
59 days
Listed on MLS
Jul 17, 2026
Full baths
5
Annual property tax (MLS)
$7,000
Tax year
202
Listing brokerage
Keystone Realty USA Corp
MLS ID
KEY1027635
Last updated
Aug 17, 2026

General features

Property type
Duplex
Year built
2026
Garage
No
Parking
Driveway, Private
Water source
Public
Sewer
Public Sewer
Utilities
Electricity Connected

Interior features

Basement
Finished, Full
Heating
Forced Air
Cooling
Central Air
Interior
First Floor Bedroom, First Floor Full Bath, Chefs Kitchen, Granite Counters, Master Downstairs, Recessed Lighting, Washer/Dryer Hookup

Exterior features

Construction materials
Brick

Schools (MLS)

Elementary school
Contact Agent
Elementary school district
Contact Agent
Middle school
Call Listing Agent
Middle school district
Contact Agent
High school
Contact Agent
High school district
Contact Agent

School information is provided by the MLS. Confirm attendance eligibility with the school district.

Recent activity

  1. First seen on this site
  2. Listing updated from MLS
  3. MLS status changed

Location

Queens, NY 11434Show interactive map
174-28 128th Avenue

Queens, NY 11434

Google Maps directions

Listing data is supplied by the MLS and may change without notice.