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!
その他
$583 月々の税金
Built in 2026
MLS/物件ID 1027635
2 ユニット
Construction - Brick
冷房 - セントラル空調
Heating - Forced Air
シェフズ・キッチン
花崗岩カウンタートップ
マスター・ダウンステアーズ
Recessed Lighting
洗濯機/乾燥機の接続
駐車 - 駐車場
Parking - Private
Public Sewer
Public Water
The data relating to real estate for sale on this web site comes in part from the OneKey® MLS. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) nor the website owner shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Property locations as displayed on any map are best approximations only and exact locations should be independently verified. IDX information is provided exclusively for consumers personal non-commercial use and it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
©{{YEAR}} OneKey® MLS. All rights reserved.