14027 247th Street, Rosedale, NY 11422

bedrooms 6
bathrooms 5
|Townhouse
NZD $2,717,456
USD $1,495,000
Published on: 18 Jul 2026
Last updated on: 17 Nov 2026
14027 247th Street, Rosedale, NY 11422
14027 247th Street, Rosedale, NY 11422
14027 247th Street, Rosedale, NY 11422
+14
14027 247th Street, Rosedale, NY 11422
  • 14
Property ID: 110119391649
Translate to English

Residential Income, Rosedale, NY

14027 247th Street, Rosedale, NY 11422
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 140-27-247th Street! Sitting on a 50x100 lot on a beautiful picturesque block of Rosedale! Featuring a wide private driveway, garage, and tons of yard space to enjoy outdoor gatherings. Offering two 3 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. Fully tiled bathrooms that boast state of the art wall & floor tiles. 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 Rosedale 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 Francis Lewis Blvd, Memphis Avenue, S Conduit, 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 in the Rosedale market that checks all the boxes for modern day luxury, space, & style!

Property Details

Basic Info

Property Type
Townhouse
Listing Status
Active
Land Size
464.58 m2
Year Built
2026
Rooms
6 bedroom(s), 5 bathroom(s)
County
Queens
Parcel ID
13597-0020
Provider
OneKey MLS
Brokerage Office Name
Keystone Realty USA
Brokerage Office Phone
631-486-1126
Address
14027 247th Street, Rosedale, NY 11422

Nearby Schools

TypeSchool nameDistrict name
HighContact AgentNot available
Not availableNot availableNot available
ElementaryContact AgentNot available
Not availableNot availableNot available
MiddleCall Listing AgentNot available
Not availableNot availableNot available
JuniorhighCall Listing AgentNot available
Not availableNot availableNot available

Tax History

YearTax amount
2025USD $7197NZD $13,082*

*Converted price in your currency provided by Open Exchange Rates. Exchange rates are subject to continuous change. Neither realestate.co.nz nor its affiliates guarantee that the conversion reflects current conversion rates and are not responsible for any inaccuracies. realestate.co.nz recommends that you independently verify any information before relying on it.

Contact Agent
Gabriel Kashi
Keystone Realty USA Corp
60 E Main St , Kings Park, NY 11754
Get in touch
Report this page

Contact Agent

Contact Agent

Email enquiry to Keystone Realty USA Corp

Gabriel Kashi
60 E Main St , Kings Park, NY 11754
What's your enquiry about?
      By clicking "Submit", you accept our Privacy Policy and acknowledge that as the agent for this property is located overseas, your information may not be handled in accordance with the privacy laws applicable to this website.

      Property ID: 110119391649

      Original Property ID: 3yd-MLSLINY-1027504
      Data provided by OneKey MLS, MLS #: 1027504
      * THIS SERVICE MAY CONTAIN TRANSLATIONS POWERED BY GOOGLE. GOOGLE DISCLAIMS ALL WARRANTIES RELATED TO THE TRANSLATIONS, EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF ACCURACY, RELIABILITY, AND ANY IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
      Copyright © 2026 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.