This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/9
$1,495,000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/9
Property Description
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!
Full Property Details
Full Property Details for 174-28 128th Ave
General
- Price: $1,495,000
- Taxes: $7,000
- Status: Active
- Type: Multi-Family
- Source: Long_Island
- MLS ID: 1027635
- Updated: 7/17/2026
- Added to Site: 50 day(s) ago
Interior
- Interior Features: First Floor Bedroom, First Floor Full Bath, Chefs Kitchen, Granite Counters, Master Downstairs, Recessed Lighting, Washer/Dryer Hookup
Rooms
Bathrooms
- Total Bathrooms: 5
- Full Bathrooms: 5
Bedrooms
- Total Bedrooms: 8
Parking
- Parking Features: Driveway, Private
Location
- County: Queens
School Information
- High School District: Contact Agent
- Elementary School: Contact Agent
- Middle School: Call Listing Agent
- High School: Contact Agent
Heating & Cooling
- Central air: Yes
- Cooling Type: Central Air
- Heating Type: Forced Air
Utilities
- Sewer: Public Sewer
- Water: Public
- Utility Description: Electricity Connected
Structural Information
- Detached/Attached: Detached
- Construction: Brick
- Basement: Yes
- Basement Desc.: Finished, Full Basement
- Year Built: 2026
Financial Considerations
- Tax Amount: $7,000
Disclosures and Reports
- Special Conditions: None
Listed by Keystone Realty USA Corp
Get Pre-Approved Today
Price & Sales History for 174-28 128th Ave
Date
Details
Price
Change
Source
7/17/2026
Listed
$1,495,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Estimate the Cost
Estimate the Cost for 174-28 128th Ave
174-28 128th Avenue, Rochdale, NY 11434 (MLS# 1027635) is a Multi-Family property with 2 units containing 8 bedrooms and 5 full bathrooms. 174-28 128th Avenue is currently listed for $1,495,000 and was received on July 17, 2026. Want to learn more about 174-28 128th Avenue? Do you have questions about finding other Multi-Family real estate for sale in Rochdale? You can browse all Rochdale real estate or contact a Coldwell Banker agent to request more information.

