174-28 128th Avenue, New York, NY

Name: 174-28 128th Avenue, For Sale in New York - Zoocasa
Brand: Keystone Realty USA Corp
SKU: 1027635
Price: 1495000 USD

Real Estate

For Sale

Listed price in listed location currency (USD).

$1,495,000

850

MLS® 1027635

Overview

Key Facts

Type Duplex

Levels Residential Income

Size -

Garage No

Taxes $7,000

Days Active 0

Lot Size

Approx. Age 2026

MLS® Number 1027635

Property Address: 174-28 128th Avenue, New York, NY, 11434

Average square foot calculated using Size range provided by listing agent.

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!

MLS® Number1027635

Laundry Level

Central VacNo

FireplaceNo

Acreage

Exterior

GarageNo

Approx. Age2026

BasementFinished, Full

DrivewayDriveway, Private

Garage Spaces

HeatForced Air

A/CCentral Air

Extras

Map

Like what you see?

Complete the form and we'll be in touch. No login necessary.

Add a Comment

I want to view this property

Yes, I'd like to receive free weekly market insights and buying and selling tips. Unsubscribe at any time.

By pressing "Take a Tour", I confirm that I have read and agree to the eXp Privacy Policy, and Terms of Use.

By pressing "Take a Tour", I am electronically signing and consenting to receive marketing comms about real estate brokerage and mortgage lending services, delivered via email, phone and/or text (using "automated technology" such as an automatic telephone dialing system, and/or an artificial or prerecorded voice), from eXp Realty® and its independent contractor real estate professionals and their affiliate SUCCESS® Lending using the contact information I provided. Your consent is not a condition of purchase and you may revoke it at any time by replying "STOP" to any texts. Text HELP for more info. Message and data rates may apply. You may also contact us directly at 1-844-683-4664.

Similar Listings

Comparable Properties

The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA.

eXp Realty holds real estate brokerage licenses in multiple states. Zoocasa (Canada), Inc. holds real estate brokerage licenses in multiple provinces. For information on licenses please contact us at [email protected]

For listings in Canada, the trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA. Used under license.

MLS® Compliance Statements
Tony King – Designated Managing Broker, Broker Operations – TX.
Texas Real Estate Commission information about brokerage services
Texas Real Estate Commission Consumer Protection Notice

eXp Realty® is committed to adhering to the guidelines of The New York State Fair Housing Regulations. The Fair Housing Notice→

*Standardized Operating Procedure for Purchasers of Real Estate Pursuant to Real Property Law 442-H. Learn More→

eXp Realty of California, Inc. | CA DRE# 01878277 | Deborah Penny – Designated Broker
eXp Realty of Southern California, Inc. | CA DRE# 02187306 | Gina Saad – Designated Broker
eXp Realty of Greater Los Angeles, Inc. | CA DRE# 02188471 | Anita Cruz – Designated Broker
eXp Realty of Northern California, Inc. | CA DRE# 01951343 | Ryan Rosas Penny – Designated Broker
Fair Housing and Reasonable Accommodations
DMCA Notice

2026 AODA Compliance Report
Feedback can be submitted through our standard communication channels such as our internal chat platform, email, phone etc., and accommodations are available upon request. Zoocasa reviews all feedback received, acknowledges concerns, and works to respond in a timely manner. Feedback is assessed and addressed appropriately to support continuous improvement of our services and accessibility practices.