Prevu by reAlpha
BuySellBlogBrowse Listings

14027 247th StreetRosedale, NY 11422

For Sale

$1,595,000

Smart Buyer Rebate $19,938

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!

Listed by Gabriel Kashi

·

Keystone Realty USA Corp

·

631-261-2800

Last updated July 26, 2026

·

Source: OneKey #1027504

Listing Facts

  • TypeMulti-family
  • NeighborhoodRosedale
  • Bedrooms6
  • Bathrooms5
  • Days on Prevu15
  • Taxes$7,197/year

Amenities

  • Parking

Location

Mortgage Calculator

Listing History

07/17/2026
Listed by Keystone Realty USA Corp
$1,595,000

Estimated Closing Costs

Attorney Fees
$4,000
NYC Mansion Tax
$15,950
Title Insurance
$7,178
Bank Attorney
$1,500
Mortgage Recording Tax
$24,563
Other Closing Costs
$4,000
Total
$57,191

Estimated closing costs are based on the list price of $1,595,000 and a 20% downpayment. These estimates are for indicative purposes only. Actual closing costs may vary for each transaction. See the Closing Costs Calculator for calculations specific to your situation.

Property Details for 14027 247th Street

Exterior

Construction

  • Number Of Units Total: 2
  • Year Built: 2026
  • Construction Materials: Brick, Frame

Measurements

  • Building Area Units: Square Feet
  • Lot Size Acres: 0.11
  • Lot Size Square Feet: 5,000

Financial

Taxes

  • Parcel Number: 13597-0020
  • Tax Annual Amount: $7,197.00
  • Tax Assessed Value: $56,040.00
  • Tax Year: 2025

Interior

Features

  • 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

Rooms

  • Basement: Finished, Full
  • Has Basement: Yes
  • Bathrooms Full: 5
  • Bathrooms Total Integer: 5
  • Bedrooms Total: 6

Parking

Parking

  • Garage Spaces: 1
  • Garage: Yes
  • Parking Features: Driveway, Garage, Private

Schools

Elementary School

  • Elementary School: Contact Agent
  • Elementary School District: Contact Agent

High School

  • High School: Contact Agent
  • High School District: Contact Agent

Middle or Junior School

  • Middle Or Junior School: Call Listing Agent
  • Middle Or Junior School District: Contact Agent

Utilities

Equipment

  • Cooling: ENERGY STAR Qualified Equipment
  • Heating: ENERGY STAR Qualified Equipment
  • Sewer: Public Sewer
  • Utilities: Natural Gas Connected
  • Water Source: Public

Frequently Asked Questions

How many bedrooms and bathrooms does this multi-family home have?

There are 6 bedrooms and 5 bathrooms in this multi-family home at 14027 247th Street.

What schools are nearby to 14027 247th Street?

Nearby schools include the Contact Agent Elementary School, Call Listing Agent Middle School, and Contact Agent High School.

Does this multi-family home have parking?

Yes, there is 1 parking space available for 14027 247th Street.

What are the annual taxes for 14027 247th Street?

Annual taxes for this multi-family home are estimated at $7,197.

How does 14027 247th Street compare to other multi-family homes in Rosedale?

This multi-family home is listed 50% above the average price for multi-family homes in Rosedale and has been on the market for 75 less days than the typical home in this area.

14027 247th Street is a 6-bedroom, 5-bath multi-family home for sale in Rosedale NY 11422. On Prevu for 15 days at $1,595,000. This property is located in Rosedale. The median listing price for multi-family homes in this area is $859,000. Nearby schools include Contact Agent Elementary School, Call Listing Agent Middle School, and Contact Agent High School. The home offers parking. Browse more multi-family home listings in Queens.

The data relating to real estate for sale on this website comes in part from the IDX Program of OneKey™ MLS. The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed. This information is provided exclusively for consumers’ personal, non-commercial use. Information Copyright 2026, OneKey™ MLS. All Rights Reserved.

Full MLS Disclaimers

Rebate estimate is indicative only and based on listing price and estimated buyer's agent commission paid by owner, if applicable. Final rebates are subject to Terms of Use and may vary due to final negotiated transaction terms.