Skip to content
14027 247th Street, Rosedale, photo 1
View all 14 photos
14027 247th Street, photo 2
14027 247th Street, photo 3
14027 247th Street, photo 4
14027 247th Street, photo 5
14027 247th Street, photo 6
14027 247th Street, photo 7
14027 247th Street, photo 8
14027 247th Street, photo 9
14027 247th Street, photo 10
14027 247th Street, photo 11
14027 247th Street, photo 12
14027 247th Street, photo 13
14027 247th Street, photo 14

14027 247th Street

$1,555,000

Est. $8,459/mo

Rosedale, NY 11422 · Queens

Beds
6
Baths
5
Status
Active
On site
63 days

Know your budget before you tour. Get pre-qualified

About this home

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 with Keystone Realty USA Corp · Gabriel Kashi · Source: OneKey MLS

One Key MLS

Information provided by One Key MLS, and is deemed reliable but not guaranteed accurate. Data last updated: Sep 18, 2026, 7:07 AM ET. ©2026 One Key MLS.

Estimate Your Monthly Payment

Estimate your mortgage payment, including the principal and interest, taxes, insurance, HOA, and Private Mortgage Insurance.

$8,459.27Total / mo

Estimated Monthly Payment

Principal & interest
$7,659.52 (90.5%)
Taxes
$599.75 (7.1%)
Insurance
$200.00 (2.4%)

Representative rates

Representative rates only, indicative for comparison. Edit the interest rate for your own quote; your lender’s numbers vary with credit, points, and insurance.

Never miss a property

Be the first to know when a Queens home hits the market.

Save this search

Market Insights

The market around Rosedale, NY

Current Listings

New in the last 30 days

23

Sep 2026

Average Price

Active listings

$880,597

Sep 2026

Average Days on Market

Active listings

137 days

Sep 2026

Computed from 113 active OneKey MLS listings in Rosedale, NY.

Similar homes in Queens

See all 2,306
158-31 86th Street, Howard Beach, NY
Photo 1 of 18
Coming SoonNew

$1,849,000

3 Bed • 3.5 Bath • 2,201 Sq. Ft.

158-31 86th Street

Howard Beach, NY 11414

Listed with Century 21 Amiable Rlty Grp II

38-04 111th Street, Corona, NY
Coming SoonNew

$1,899,000

7 Bed • 4 Bath

38-04 111th Street

Corona, NY 11368

Listed with City Homes Realty Group LLC

7104 67th Place, Ridgewood, NY
Coming SoonNew

$1,449,900

6 Bed • 3 Bath

7104 67th Place

Ridgewood, NY 11385

Listed with Douglas Elliman Real Estate