Wide private drivewayBeautiful chefs granite kitchensMassive lot
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!
34 days
|
536
|
30
|
Zillow last checked:
Listing updated:
Listed by:
Keystone Realty USA Corp631-261-2800,
Gabriel Kashi347-419-5268,
Angela Babakhanov602-570-2953,
Keystone Realty USA Corp
Source: OneKey® MLS as distributed by MLS GRID,MLS#: 1027635
Facts & features
Interior
Bedrooms & bathrooms
Bedrooms: 8
Bathrooms: 5
Full bathrooms: 5
Heating
Forced Air
Cooling
Central Air
Appliances
Laundry: Washer/Dryer Hookup
Features
First Floor Bedroom, First Floor Full Bath, Chefs Kitchen, Granite Counters, Master Downstairs, Recessed Lighting
Basement: Finished,Full
Property
Parking
Total spaces: 1
Parking features: Driveway, Private
Carport spaces: 1
Has uncovered spaces: Yes
Details
Special conditions: None
Construction
Type & style
Home type: MultiFamily
Property subtype: Duplex, Multi Family
Materials
Brick
Condition
Year built: 2026
Utilities & green energy
Sewer: Public Sewer
Water: Public
Utilities for property: Electricity Connected
Community & HOA
Location
Region: Jamaica
Financial & listing details
Annual tax amount: $7,000
Date on market: 7/17/2026
Cumulative days on market: 34 days
Listing agreement: Exclusive Right To Sell
Electric utility on property: Yes
Estimated market value
Zestimate®
Not available
Estimated sales range
Not available
Rent Zestimate®
Not available
Price history
Date
Event
Price
8/18/2026
Pending sale
$1,495,000
Source: OneKey® MLS as distributed by MLS GRID #1027635Report a problem
7/17/2026
Listed for sale
$1,495,000
Source: OneKey® MLS as distributed by MLS GRID #1027635Report a problem
Public tax history
Tax history is unavailable.
Monthly payment
Estimated monthly payment$1,822
Principal & interest
$1,547
Mortgage insurance
$0
Property taxes
$170
Home insurance
$105
HOA fees
$0
Utilities
Not included
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
See how much you could borrow to make a competitive offer.
Source: OneKey® MLS as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.