$1,555,000
 $8,348 est/mo Sourced by Back At You

14027 247th Street,Rosedale, NY 11422

Rosedale, NY 11422

Share:

Description

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!

Details

MLS #1027504
Listing TypeFor Sale
Sub-TypeResale
StatusActive
Year2026
Days On Site118
Listing Provided ByKeystone Realty USA Corp | Gabriel Kashi

Features

Bed(s)6
Bath(s) 5 Total
Garage1
BasementY
Units2
Acreage0.11

Interior

CoolingENERGY STAR Qualified Equipment
HeatingENERGY STAR Qualified Equipment
Interior FeaturesFirst 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

Exterior

Construction MaterialsBrick, Frame

Parking

Garage Yes / NoYes
Parking FeaturesDriveway, Garage, Private

Utilities

UtilitiesNatural Gas Connected
SewerPublic Sewer

Taxes

Tax Year2025
Tax Assessed Value56040
Tax Annual Amount7197

Area Information

StateNY
CountyQueens
CityRosedale
Zip Code11422
School DistrictContact Agent
Elementary SchoolContact Agent
High SchoolContact Agent
Listing VS Median (in 11422)
Price:
$1,555,000
low | high
Med:
$750,000
100% of Average
On site:
118
low | high
Med:
124.5
94.779116465863% of Average
Sourced by Back At You

Market Activity 11422

Request a showing

Request a showing

Contact


Additional Information


Showing Information


Submit Form

Required Field
By submitting, you agree to receive promotional texts and/or calls from John J Lease Realtors at the number provided. Message/data rates may apply. Consent is not a condition of purchase, and you can opt out anytime by replying STOP.
MLS Internet Data Exchange (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, and that the data is deemed reliable but is not guaranteed accurate by the OneKey® MLS

Contact

Learn More About This Property

StateNY
CountyQueens
CityRosedale
Zip Code11422
School DistrictContact Agent
Elementary SchoolContact Agent
High SchoolContact Agent
Listing VS Median (in 11422)
Price:
$1,555,000
low | high
Med:
$750,000
100% of Average
On site:
118
low | high
Med:
124.5
94.779116465863% of Average
Sourced by Back At You
Nearby Listings (Within 1/4 mile)
Price: $1.166M - $1.943M
sqft: 0 - 0
Listing Updated: October 11, 2026 at 2:47:35 PM PDT