- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes





Street View
$1,495,000
Monthly Est:$7,441
6 Beds
- 5 Baths
5 full baths
--sqft
14027 247th Street, New York, NY 11422
$1,495,000
$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

This condo is in:
Property Details
Status
Active
Type
Multi Family
No. of Stories
-
County
City
Neighborhood
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!
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
| Date | Event | Price |
|---|---|---|
10/27/2026 Source: | Price Decreased | $1,495,000 -3.86% $0/sqft |
08/21/2026 Source: | Price Decreased | $1,555,000 -2.51% $0/sqft |
07/17/2026 Source: | Price Increased | $1,595,000 +6.69% $0/sqft |
07/17/2026 Source: | Listed for Sale | $1,495,000 $0/sqft |
Rosedale Ranks #125 in New York, NY
Homes
Rental Prices
Median Home Price
Nearby Homes
Find Homes by Property Features in New York, NY
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











