For Sale
House for sale at 14027 247th Street, New York, NY 11422 | MLS# 1027504 | Listing updated on 2026-10-28
Photo 1 of House for sale at 14027 247th Street, New York, NY 11422 | MLS# 1027504 | Listing updated on 2026-10-28
Photo 2 of House for sale at 14027 247th Street, New York, NY 11422 | MLS# 1027504 | Listing updated on 2026-10-28
Photo 3 of House for sale at 14027 247th Street, New York, NY 11422 | MLS# 1027504 | Listing updated on 2026-10-28
Photo 4 of House for sale at 14027 247th Street, New York, NY 11422 | MLS# 1027504 | Listing updated on 2026-10-28
10+
Beds Icon

Street View

$1,495,000

Monthly Est:$7,441

  • Beds Icon6 Beds
  • Beds Icon
    5 Baths
  • Beds Icon--sqft

14027 247th Street, New York, NY 11422

$7,441/moEst:

Get Pre-Approved

  • Duplex

  • Built in 2026

  • $-- HOA

  • 5,000 sqft lot

  • --/sqft

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 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!

  • Houzeo last checked: 6 minutes ago
  • Listing updated: October 28, 2026 at 9:01 am
  • Listing Provided by: Gabriel Kashi (347) 419-5268 , Michael Rodriguez | Keystone Realty USA Corp (631) 261-2800
  • Source: OneKey MLS-NY | MLS#: 1027504 OneKey MLS-NY

This condo is in:

Property Details

  • Status

    Active

  • Type

    Multi Family

  • No. of Stories

    -

  • County

    Queens County

  • City

    New York

  • Neighborhood

    Rosedale

  • Year Built

    2026

  • HOA Fees

    -

  • Finished Area

    - sqft

  • Lot Size

    5,000 sqft lot

  • Basement Area

    - sqft

  • MLS Name

    OneKey MLS

  • MLS Number

    1027504

  • MLS Status

    Active

  • Days on Market

    103

  • Cumulative Days on Market

    103

Continue Your Journey in App

Find your dream home, receive real-time updates, and many more!

Location

Facts & Features

Rooms

  • Bedrooms & bathrooms

    Bedrooms: 6

    Bathrooms: 5

Interior

  • Heating

    Energy Star Qualified Equipment

  • Cooling

    Energy Star Qualified Equipment

  • Interior Features

    First Floor Bedroom, First Floor Full Bath, Cathedral Ceiling(s), Chandelier, Chefs Kitchen, Granite Counters, Kitchen Island, Open Kitchen, Primary Bathroom, Master Downstairs, Recessed Lighting, Washer/dryer Hookup

  • Sewer

    Public Sewer

Construction

  • Year Built

    Year Built: 2026

  • Home type

    Duplex

  • Construction Materials

    Brick, Frame

Utilities & Energy

  • Basement

    Finished, Full

  • Water Source

    Public

  • Utilities

    Natural Gas Connected

  • Parking Features

    Driveway, Garage, Private

Price History

DateEventPrice

10/27/2026

Source: mls_logoOneKey MLS-NY #KEY1027504

Price Decreased

$1,495,000 -3.86%

$0/sqft

08/21/2026

Source: mls_logoOneKey MLS-NY #KEY1027504

Price Decreased

$1,555,000 -2.51%

$0/sqft

07/17/2026

Source: mls_logoOneKey MLS-NY #KEY1027504

Price Increased

$1,595,000 +6.69%

$0/sqft

07/17/2026

Source: mls_logoOneKey MLS-NY #KEY1027504

Listed for Sale

$1,495,000

$0/sqft

Rosedale Ranks #125 in New York, NY

Homes for sale
62

Homes

Rental prices
$2,325

Rental Prices

Median Home Price
$800K

Median Home Price

Rosedale, New York, NY neighborhood guide

Nearby Homes

Based on information from OneKey MLS, through Oct 29, 2026, 09:01PM. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. © 2026 OneKey® MLS. All rights reserved.

Advertising Broker: Derek Greene | The Greene Realty Group

Skip to Main Content