Active

14027 247th Street

Rosedale, NY 11422
Mark as Favorite
Bed 6

Bed

Bath 5

Bath

Acres0.11

Acre(Lot)

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!

Read More Expand

Detail Ic Property Details

Property Type : Residential Income

Price : $1,555,000

AD Id : 88157206

MLS Id : 1027504

Beds : 6

Lot Size : 0.11 Acre

Tax Amount : 7197.00

Year Built : 2026

Garage : 1

County : Queens

  • Map Map

Map

Map What's Nearby

Map Nearby Areas

Feature Features

  • Bedroom Information

    Total beds: 6

    Bathroom Information

    Total Baths: 5 Full Baths: 5

    Room Information

    Basement: Finished, Full
  • Interior Features

    Cathedral Ceiling(s), Chandelier, Granite Counters, Kitchen Island, Master Downstairs, Recessed Lighting
  • Heating & Cooling

    Has Heating: Yes Heating: ENERGY STAR Qualified Equipment Has Cooling: Yes Cooling: ENERGY STAR Qualified Equipment

  • Building Information

    Year Built: 2026 Construction Materials: Brick, Frame Private Pool: No

  • Lot Information

    Lot Size Acres: 0.1148 Lot Size Square Feet: 5000

  • Listing Price Information

    Listing Price: $1555000 Original Price: $1595000

  • Tax Information

    Parcel Number: 13597-0020 Annual Tax: $7197

  • Parking Information

    Driveway, Garage, Private

    Garage Information

    Has Garage: Yes Garage Space: 1

  • School Information

    Elementary School: Contact Agent
    Junior High School: Call Listing Agent
    Senior High School: Contact Agent
  • Utility Information

    Natural Gas Available, Natural Gas Connected
  • Location Information

    WaterSource: Public
Sell a home like this and save $92,801 Find out How

How much is this property worth?

Curious about this home's true market value? Use our free Home Evaluation Tool to instantly get a personalized Comparative Market Analysis (CMA) report. Make smarter, data-driven decisions before you buy.

Images
Loading, please wait...

Nearby Home Value

Address Estimate Bed Bath Sq. Ft Lot Size
148-74 262nd Place, Rosedale, NY, 11422 $999,000 6 4 -- 0.10 Acre
14809 Hook Creek Boulev.., Rosedale, NY, 11422 $799,000 6 4 -- 0.09 Acre
25770 145th Avenue, Rosedale, NY, 11422 $1,495,000 4 5 -- 0.09 Acre
13723 249th Street, Rosedale, NY, 11422 $595,000 4 2 -- 0.06 Acre
25742 145th Avenue, Rosedale, NY, 11422 $989,000 4 2 -- 0.08 Acre
247-20 136th Road, Rosedale, NY, 11422 $1,150,000 6 3 -- 0.11 Acre
24720 136th Road, Rosedale, NY, 11422 $1,200,000 6 3 -- 0.11 Acre
255-31 149 Road, Rosedale, NY, 11422 $1,050,500 6 4 -- --
255-29 149th Road, Rosedale, NY, 11422 $950,000 6 4 -- 0.07 Acre
25612 147th Avenue, Rosedale, NY, 11422 $975,000 5 3 -- 0.08 Acre

The data relating to real estate for sale on this website comes in part from the Internet Data exchange of OneKey MLS. IDX information is 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. Copyright © 2026 OneKey MLS. All Rights Reserved

ByOwner last updated this listing 09/03/2026 @ 13:16

MLS: 1027504 LISTED BY: Gabriel Kashi, Keystone Realty USA Corp 631-261-2800 SOURCE: OneKey MLS

Homes around $1,555,000

Selling? Save $92,801 when you sell a home like this

Tour with a ByOwner Agent