Schedule Tour
$1,555,000

14027 247th St

Rosedale, NY
Active
6
Bedrooms
5
Bathrooms
0.11
Lot Size (acres)
2026
Year Built
102
Days On Market

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!

Listing Information

Listing Updated
50 minutes ago
Listed By
Gabriel Kashi · Keystone Realty USA Corp, 6312612800
MLS#
1027504
Source
OneKey MLS
Status
Active

Open Houses

  • Sunday, November 1
    10:00 AM – 11:00 AM

Facts & Features

Location

Community Information

Address
14027 247th St, Rosedale, NY 11422
City
Rosedale
County
Queens
Zip Code
11422

Architecture

Bedrooms
6
Bathrooms
5
Year Built
2026
Construction Materials
Frame, Brick
Garage
Yes
Garage Spaces
1
Parking Features
Driveway, Private, Garage

Features & Amenities

Interior Features
Cathedral Ceiling(s), Kitchen Island, Master Downstairs, Granite Counters, Recessed Lighting, Chandelier
Cooling
ENERGY STAR Qualified Equipment
Heating
ENERGY STAR Qualified Equipment

Property Features

Lot Size
0.11 Acres
Water
Public
Sewer
Public Sewer
Utilities
Natural Gas Available, Natural Gas Connected

Tax & Financial Information

List Price
$1,555,000
Annual Taxes
$7,197

Schools

100/100
Ps 181 Brookfield
Elementary · Grades PK–05 · 1.1 mi
City
Springfield Gardens
Students
393
Student body
85% Black · 9% Hispanic / Latino · 2% Two or More Races
Free/reduced lunch
72%
Phone
(718) 528-5807
99/100
Ps/Middle School 138 Sunrise
Elementary · Grades PK–08 · 0.2 mi
City
Rosedale
Students
793
Student body
83% Black · 8% Hispanic / Latino · 3% Asian
Free/reduced lunch
76%
Phone
(929) 600-5777
97/100
Ps 156 Laurelton
Elementary · Grades PK–05 · 0.8 mi
City
Springfield Gardens
Students
301
Parent reviews
1.0★ avg · 4 reviews
Student body
90% Black · 7% Hispanic / Latino · 2% Asian
Free/reduced lunch
73%
Phone
(718) 528-9173
76/100
Valley Stream South High School
High · Grades 07–12 · 1.3 mi
City
Valley Stream
Students
1,248
Parent reviews
5.0★ avg · 2 reviews
Student body
32% Hispanic / Latino · 28% Black · 23% Asian
Free/reduced lunch
30%
Phone
(516) 791-0310
57/100
Forest Road School
Elementary · Grades PK–06 · 1.1 mi
City
Valley Stream
Students
328
Student body
38% Asian · 33% Black · 18% Hispanic / Latino
Free/reduced lunch
38%
Phone
(516) 434-3803
56/100
Clearstream Avenue School
Elementary · Grades PK–06 · 1 mi
City
Valley Stream
Students
377
Student body
39% Black · 35% Hispanic / Latino · 19% Asian
Free/reduced lunch
50%
Phone
(516) 434-3553
56/100
Ogden Elementary School
Elementary · Grades 02–05 · 1.2 mi
City
Valley Stream
Students
340
Student body
56% White · 19% Hispanic / Latino · 12% Black
Free/reduced lunch
30%
Phone
(516) 792-4700
55/100
Ps 38 Rosedale
Elementary · Grades KG–05 · 0.6 mi
City
Rosedale
Students
269
Student body
85% Black · 10% Hispanic / Latino · 2% White
Free/reduced lunch
78%
Phone
(718) 528-2276

School ratings are provided for informational purposes only and are subject to change. Attendance boundaries are for reference only — contact the school or district directly to verify enrollment eligibility.

Historical Data

Price History

DateEventPrice
08/21/2026Price change$1,555,000
07/17/2026Listed for sale$1,595,000

Listed by Gabriel Kashi · Keystone Realty USA Corp · 6312612800

Listing information provided exclusively for consumers' 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 deemed reliable but not guaranteed by the MLS. The listing broker’s offer of compensation is made only to participants of the MLS where the listing is filed. Copyright 2026, OneKey MLS. All rights reserved.

Last Updated: October 27, 2026 at 5:43 PM | Source: OneKey MLS | MLS#: 1027504

Let's work together

Start Your Real Estate Journey

Whether you have questions about this listing, want to schedule a showing, or just want to talk through your options, Jeromy Dunn-Portella is here to help. Reach out and expect a response within one business day.

How can I help?

Jeromy Dunn-Portella is here to help. Reach out and expect a response within one business day.

Lending calculator

Make A Plan For Your Purchase

Know what you can afford before you start shopping — then run the numbers on any home you have in mind.

How much house can I afford?

$500,000
You can afford
$0
Monthly payment
  • Principal & interest
  • Property taxes
  • Homeowner's insurance
  • HOA dues

Enter your income, debts, and down payment to see how much home you may qualify for. Estimates only — not a lending decision.

Want to know more?

Jeromy Dunn-Portella is here to help. Reach out and expect a response within one business day.