Prevu by reAlpha
BuySellBlogBrowse Listings

174-28 128th AvenueRochdale, NY 11434

For Sale

$1,495,000

Smart Buyer Rebate $18,688

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!

Listed by Gabriel Kashi

·

Keystone Realty USA Corp

·

631-261-2800

Listed by Angela Babakhanov

·

Keystone Realty USA Corp

Last updated July 25, 2026

·

Source: OneKey #1027635

Listing Facts

  • TypeMulti-family
  • NeighborhoodSt. Albans
  • Bedrooms8
  • Bathrooms5
  • Days on Prevu14
  • Taxes$7,000/year

Amenities

  • Air Conditioning
  • Parking

Location

Mortgage Calculator

Listing History

07/17/2026
Listed by Keystone Realty USA Corp
$1,495,000

Estimated Closing Costs

Attorney Fees
$4,000
NYC Mansion Tax
$14,950
Title Insurance
$6,728
Bank Attorney
$1,500
Mortgage Recording Tax
$23,023
Other Closing Costs
$4,000
Total
$54,201

Estimated closing costs are based on the list price of $1,495,000 and a 20% downpayment. These estimates are for indicative purposes only. Actual closing costs may vary for each transaction. See the Closing Costs Calculator for calculations specific to your situation.

Property Details for 174-28 128th Avenue

Exterior

Construction

  • Number Of Units Total: 2
  • Year Built: 2026
  • Construction Materials: Brick

Measurements

  • Building Area Units: Square Feet

Financial

Taxes

  • Tax Annual Amount: $7,000.00
  • Tax Year: 202

Interior

Features

  • Interior Features: First Floor Bedroom, First Floor Full Bath, Chefs Kitchen, Granite Counters, Master Downstairs, Recessed Lighting, Washer/Dryer Hookup

Rooms

  • Basement: Finished, Full
  • Has Basement: Yes
  • Bathrooms Full: 5
  • Bathrooms Total Integer: 5
  • Bedrooms Total: 8

Parking

Parking

  • Carport Spaces: 1
  • Carport: Yes
  • Parking Features: Driveway, Private

Schools

Elementary School

  • Elementary School: Contact Agent
  • Elementary School District: Contact Agent

High School

  • High School: Contact Agent
  • High School District: Contact Agent

Middle or Junior School

  • Middle Or Junior School: Call Listing Agent
  • Middle Or Junior School District: Contact Agent

Utilities

Equipment

  • Cooling: Central Air
  • Heating: Forced Air
  • Sewer: Public Sewer
  • Utilities: Electricity Connected
  • Water Source: Public

Frequently Asked Questions

How many bedrooms and bathrooms does this multi-family home have?

There are 8 bedrooms and 5 bathrooms in this multi-family home at 174-28 128th Avenue.

What schools are nearby to 174-28 128th Avenue?

Nearby schools include the Contact Agent Elementary School, Call Listing Agent Middle School, and Contact Agent High School.

What are the annual taxes for 174-28 128th Avenue?

Annual taxes for this multi-family home are estimated at $7,000.

How does 174-28 128th Avenue compare to other multi-family homes in St. Albans?

This multi-family home is listed 32% above the average price for multi-family homes in St. Albans and has been on the market for 74 less days than the typical home in this area.

174-28 128th Avenue is a 8-bedroom, 5-bath multi-family home for sale in Rochdale NY 11434. Available on Prevu for 14 days at $1,495,000. This home is located in St. Albans. The median listing price for multi-family homes in this area is $855,999. Nearby schools include Contact Agent Elementary School, Call Listing Agent Middle School, and Contact Agent High School. Additional amenities include air conditioning and parking. View other multi-family home listings in Queens.

The data relating to real estate for sale on this website comes in part from the IDX Program of OneKey™ MLS. 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. This information is provided exclusively for consumers’ personal, non-commercial use. Information Copyright 2026, OneKey™ MLS. All Rights Reserved.

Full MLS Disclaimers

Rebate estimate is indicative only and based on listing price and estimated buyer's agent commission paid by owner, if applicable. Final rebates are subject to Terms of Use and may vary due to final negotiated transaction terms.