Skip main navigation
Open: Sun 3:30pm-5pm
For salePrice cut: $40K (8/21)
$1,555,000
6beds
--sqft

14027 247th Street, Rosedale, NY 11422

6beds
--sqft
Duplex, multi family
Built in 2026
1 Garage space

What's special

Wide private drivewayBeautiful chefs granite kitchens

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!

43 days
|
1,724
|
85
|
Source: OneKey® MLS as distributed by MLS GRID,MLS#: 1027504MLS Logo
Travel times

Living Room

Kitchen

Primary Bedroom

Zillow last checked:

Listing updated:

Listed by:

Keystone Realty USA Corp 631-261-2800,

Gabriel Kashi 347-419-5268

Source: OneKey® MLS as distributed by MLS GRID,MLS#: 1027504MLS Logo

Facts & features

Interior

Bedrooms & bathrooms
  • Bedrooms: 6
  • Bathrooms: 5
  • Full bathrooms: 5
Heating
  • ENERGY STAR Qualified Equipment
Cooling
  • ENERGY STAR Qualified Equipment
Appliances
  • Laundry: Washer/Dryer Hookup
Features
  • 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
  • Basement: Finished,Full

Property

Parking
  • Total spaces: 1
  • Parking features: Driveway, Garage, Private
  • Garage spaces: 1
  • Has uncovered spaces: Yes
Lot
  • Size: 5,000 Square Feet
Details
  • Parcel number: 135970020
  • Special conditions: None

Construction

Type & style
  • Home type: MultiFamily
  • Property subtype: Duplex, Multi Family
Materials
  • Brick, Frame
Condition
  • Year built: 2026

Utilities & green energy

  • Sewer: Public Sewer
  • Water: Public
  • Utilities for property: Natural Gas Connected

Community & HOA

Location
  • Region: Rosedale

Financial & listing details

  • Tax assessed value: $56,040
  • Annual tax amount: $7,197
  • Date on market: 7/17/2026
  • Cumulative days on market: 43 days
  • Listing agreement: Exclusive Right To Sell

Price history

DateEventPrice
8/21/2026Price change$1,555,000-2.5%
Source: OneKey® MLS as distributed by MLS GRID #1027504 Report a problem
7/17/2026Listed for sale$1,595,000+135.9%
Source: OneKey® MLS as distributed by MLS GRID #1027504 Report a problem
12/4/2025Sold$676,000-0.3%
Source: OneKey® MLS as distributed by MLS GRID #916104 Report a problem
10/14/2025Pending sale$678,000
Source: OneKey® MLS as distributed by MLS GRID #916104 Report a problem
9/23/2025Listed for sale$678,000+50.7%
Source: OneKey® MLS as distributed by MLS GRID #916104 Report a problem
11/28/2005Sold$450,000+112.3%
Source: Public Record Report a problem
8/24/1999Sold$212,000
Source: Public Record Report a problem

Public tax history

YearProperty taxesTax assessment
2025-- $46,560 +5.7%
2024-- $44,040 +1.5%
2023-- $43,380 +20.1%
2022-- $36,120 +13.2%
2021-- $31,920 +3.7%
2020$6,219 +0.6%$30,780 -4.1%
2019$6,185 +2.3%$32,100 +11.1%
2018$6,043 +8.8%$28,887 +6%
2017$5,556 +17.6%$27,253 +6%
2016$4,725 $25,712
2015$4,725 +64%$25,712 +0.8%
2014$2,881 $25,516 +6%
2013-- $24,073 +6%
2012-- $22,711 +6%
2011-- $21,427
2010-- $21,427 +0.8%
2009-- $21,264 +6%
2008-- $20,061

Find assessor info on the county website

Monthly payment

Estimated monthly payment$1,822
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
See how much you could borrow to make a competitive offer.

Estimated market value

Not available

Estimated sales range

Not available

Not available

Climate risks

Explore flood, wildfire, and other predictive climate risk information for this property on First Street®️.

Neighborhood: Rosedale

Nearby schools

P.S. / M.S. 138 Sunrise
Grades PK-80.3 miles
5/10
GreatSchools® Rating
Test Score Rating
4/10
Student Progress Rating
6/10
Excelsior Preparatorty High School
Grades 9-121.3 miles
5/10
GreatSchools® Rating
Test Score Rating
4/10
College Readiness Rating
6/10
Collaborative Arts Middle School
Grades 6-81.3 miles
5/10
GreatSchools® Rating
Test Score Rating
5/10
Student Progress Rating
5/10

Open houses

  • Sun, Aug 30

    3:30 PM - 5:00 PM

    Add to calendar
  • Mon, Aug 31

    4:00 PM - 5:30 PM

    Add to calendar