$1,495,000

Duplex In Rochdale

  • 8 Beds
  • 5 Baths
  • Updated: Today
  • 2
    Views for last 30 days
  • Source:
    OneKey MLS  MLS#1027635

About the Property

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 s
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!
  • Property type

    House

  • Year built

    2026

Features

  • Open Kitchen
  • Modern
  • New Builds
  • Investment Property
  • Privacy
  • Duplex
  • Kitchen island
  • High Ceiling
  • Parking
Features

Lot

  • Privacy
  • New Builds
  • Duplex
  • Investment Property
  • Modern

Indoor

  • High Ceiling
  • Kitchen island
  • Open Kitchen
  • Basement
  • Stone Countertops

Outdoor

  • Parking

Explore the Area

174-28 128th Avenue, New York, New York, United States View on Google Maps
Price per sqft
Low
High

View 7,073 more listings in New York

Keystone Realty USA Corp - Kings Park

Joined 7 months ago
Your message
You have inquired about this property

The agent will contact you soon by

Listed by

Keystone Realty USA Corp - Kings Park
New York, United States
View agency profile
33
Listings
2026
Joined

Book home tour with the agent

Choose a date and whether you'd like a virtual or in-person tour with the agent.

In-person tour
Preferred date
Tour type
Keystone Realty USA Corp - Kings Park
Kings Park, New York, United States
View agency profile
Last updated
Today
First listed
Jul 18
Listing reference
1027635
Listing status
Call

Start phone call with:

Hello, I’m calling for the property with the reference 1027635, which I discovered on JamesEdition.

After the call, we'll provide your contacts to the agent for easy communication.

brokerages we
partnered with