14027 247th Street, Rosedale, NY 11422
What's special
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!
- 64 days |
- 698 |
- 38 |
Travel times
Living Room
Kitchen
Primary Bedroom
Zillow last checked:
Listing updated:
Keystone Realty USA Corp 631-261-2800,
Gabriel Kashi 347-419-5268
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: 65 days
- Listing agreement: Exclusive Right To Sell
Price history
| Date | Event | Price |
|---|---|---|
| 8/21/2026 | Price change | $1,555,000-2.5% |
Source:  OneKey® MLS as distributed by MLS GRID #1027504 Report a problem | ||
| 7/17/2026 | Listed for sale | $1,595,000+135.9% |
Source: OneKey® MLS as distributed by MLS GRID #1027504 Report a problem | ||
| 12/4/2025 | Sold | $676,000-0.3% |
Source: OneKey® MLS as distributed by MLS GRID #916104 Report a problem | ||
| 10/14/2025 | Pending sale | $678,000 |
Source: OneKey® MLS as distributed by MLS GRID #916104 Report a problem | ||
| 9/23/2025 | Listed for sale | $678,000+50.7% |
Source: OneKey® MLS as distributed by MLS GRID #916104 Report a problem | ||
| 11/28/2005 | Sold | $450,000+112.3% |
Source: Public Record Report a problem | ||
| 8/24/1999 | Sold | $212,000 |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax 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 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®️.