Search
Two-Family Duplex with Finished Basement
For Sale
$1,595,000

14027 247th Street, Rosedale, NY 11422

MULTI_FAMILY - Rosedale, NY

Lot Size0.11 Acres
Days on Market17

Property Features for 14027 247th Street

General Information

Property type Residential Multi Family
Property subtype Duplex
Property condition Under Construction
Bedrooms 6
Bathrooms 5
Full bathrooms 5
Rooms Bedroom 3, Bathroom 2, Bathroom 4, Bedroom 4, Bathroom 1, Bedroom 1, Bedroom 6, Bathroom 5, Bedroom 5, Bathroom 3, Bedroom 2, Basement
Parking features Driveway, Garage
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
Basement Full, Finished
Elementary school Contact Agent
Middle school Call Listing Agent
High school Contact Agent
Elementary school district Contact Agent
Middle school district Contact Agent
High school district Contact Agent
Standard status Active
APN 13597-0020
Lot size 0.11 Acres

Taxes and HOA fees

Tax Year 2025
Tax Annual Amount 7197

Utilities

Sewer type Public Sewer
Heating system Energy Star Qualified Equipment (Heating)
Cooling system ENERGY STAR Qualified Equipment
Water source Public

Building Details

Year built 2026
Number of units 2
Building materials Brick, Frame
Listing Agency: Keystone Realty USA Corp
Listed By: Gabriel Kashi
Added: Jul 17 Changed: Aug 1 Last Checked: Aug 2 at 3:06PM
MLS# 1027504

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.

Investment Insights

Based on property information with market context.

Under construction two-family duplex on a 50x100 lot, built with brick and frame construction and scheduled for a 2026 build year. The home is laid out as two separate units, each offering three bedrooms and two bathrooms, with open kitchen and living/dining areas designed for everyday living and entertaining. Interior features include cathedral ceilings, recessed lighting, a kitchen island, granite counters, and washer/dryer hookup.

A high-ceiling full finished basement is included with both interior and exterior access, offering flexibility for a media room, guest quarters, recreation space, or an ADU. Parking is provided via a wide private driveway and a garage, supported by public water and public sewer. Heating and cooling are Energy Star qualified.

The property is located at 140-27 247th Street in Rosedale, Queens, just off Francis Lewis Boulevard, with convenient access to major transportation routes including the Belt Parkway. Nearby are schools, Green Acres Commons, JFK Airport, and local dining, cafes, and parks.

Key Highlights

  • Two 3‑bedroom, 2‑bath units in an under‑construction two‑family
  • 50x100 lot with wide private driveway plus garage
  • High‑ceiling full finished basement with interior and exterior access

Property Analytics

Current Use

Duplexes

Suggested Use

Top Pick Law Firm Dental Office Skin Care Clinic Gym & Fitness Center Parking Lot & Garage Real Estate Agency

Score = modeled unmet demand for each use within ~1 mi (higher = bigger opportunity). Zoning and permitted uses should be independently verified with local authorities.

Lease Details

Multi-tenant
Tenancy

Location Intelligence

Trade Area within ½ mile

942
Businesses Nearby

Demographics for 11422, NY

32,839
Population
10,694
Households
3.1
Avg Household Size
41
Median Age
33%
College-Educated
90%
High-School Grad
2.1 sq mi
ZIP Area
15,638
Density / Sq Mi
$108,519
Median Household Income
$51,788
Median Earnings
$2,327
Median Rent
$629,100
Median Home Value

Market

Vacancy Rate% for Multifamily in Northeast region

4% 2022
4.6% 2023
5.3% 2024
5.6% 2025
Rey
Questions? Ask Rey
Realmo’s AI knows this listing — price, zoning, demand, history. Ask anything.

Frequently Asked Questions

What type of property is this?
Duplex - Under-construction two-family on a 50x100 lot with two 3-bedroom, 2-bath units, private driveway, and full finished basement.
Where is this duplex located?
The property is located at 14027 247th Street Rosedale, NY.
What is the asking price?
The asking price for this property is $1,595,000.
What are key features of this property?
This property features: Two 3‑bedroom, 2‑bath units in an under‑construction two‑family; 50x100 lot with wide private driveway plus garage; High‑ceiling full finished basement with interior and exterior access
More about this property
Thanks! Your message was sent.
Error! Your message wasn't sent.
Please enter your name
Please enter email
Please enter the email in the correct format
Please enter phone
Please enter the number in the correct format
Please enter message