14027 247th St

Rosedale, NY 11422
  • $1,595,000

    Price
  • 6

    Bed
  • 5

    Bath
  • 0

    SqFt

Open House Times

  • Sun. Jul. 19 at 1:00pm to 3:00pm

About the Listing KEEG02 - 163722

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 Highlights

Status Active
Days on Site 1
Property Type Multi-Family
MLS ® 1027504
Year Built 2026
Total Square Footage 0
Lot/Acreage 0.11
County Queens
School District Contact Agent
Elementary School Contact Agent
High School Contact Agent

Interior Details

  • Bedrooms: 6
  • Bathrooms: 5 Full
  • Appliances:
  • Air Cond: ENERGY STAR Qualified Equipment
  • Heating: ENERGY STAR Qualified Equipment
  • Fireplaces:
  • Floor:
  • Above Ground Sq Ft:
  • Below Ground Sq Ft: n/a
  • Basement: Finished,Full
  • Other: 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
  • Water: Public

Exterior Details

  • Lot Description: No Waterfront
  • Garage Capacity: 1 car
  • Roof:
  • Others:
  • Sewer: Public Sewer
  • Parking Features: Driveway,Garage,Private

Financial Details

  • Tax Amount: $7,197
  • Taxes w/Assessments: N/A
  • Tax/Property ID: 13597-0020
  • Tax Year: N/A

Payment Calculator

Monthly Payment

  • in Principal and Interest
  • in Taxes
Years
% Down Payment
% Mortgage Rate

Questions About..

14027 247th St Rosedale, NY 11422

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Never Miss A New Property

Get notified any time there's a new home on the market in this neighborhood!

Don't worry! We'll never spam you or sell your details. You can unsubscribe whenever you'd like.

Originating MLS: onekey2

home

Are you buying or selling a home?

Buying
Selling
Both
home

When are you planning on buying a new home?

1-3 Mo
3-6 Mo
6+ Mo
home

Are you pre-approved for a mortgage?

Yes
No
Using Cash
home

Would you like to schedule a consultation now?

Yes
No

When would you like us to call?

Thanks! We’ll give you a call as soon as possible.

home

When are you planning on selling your home?

1-3 Mo
3-6 Mo
6+ Mo

Would you like to schedule a consultation or see your home value?

Schedule Consultation
My Home Value

or another way