OPEN THU 6PM - 7:30PM
$40K PRICE DROP
14027 247th St Rosedale, NY 11422
Rosedale NeighborhoodEstimated payment $9,130/month
Total Views
6,933
6
Beds
5
Baths
--
Sq Ft
--
Price per Sq Ft
Highlights
- Gourmet Kitchen
- Main Floor Primary Bedroom
- Recessed Lighting
- Cathedral Ceiling
- Granite Countertops
- Bathroom on Main Level
About This Home
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 Agent
Keystone Realty USA Corp Brokerage Phone: 631-261-2800 License #10401217533 Listed on: 07/17/2026
Open House Schedule
-
Thursday, August 27, 20266:00 to 7:30 pm8/27/2026 6:00:00 PM +00:008/27/2026 7:30:00 PM +00:00Add to Calendar
-
Sunday, August 30, 20263:30 to 5:00 pm8/30/2026 3:30:00 PM +00:008/30/2026 5:00:00 PM +00:00Add to Calendar
Property Details
Home Type
- Multi-Family
Est. Annual Taxes
- $7,197
Year Built
- Built in 2026
Parking
- 1 Car Garage
- Private Parking
- Driveway
Home Design
- Duplex
- Brick Exterior Construction
- Frame Construction
Interior Spaces
- Cathedral Ceiling
- Recessed Lighting
- Chandelier
- Finished Basement
- Basement Fills Entire Space Under The House
- Washer and Dryer Hookup
Kitchen
- Gourmet Kitchen
- Kitchen Island
- Granite Countertops
Bedrooms and Bathrooms
- 6 Bedrooms
- Primary Bedroom on Main
- En-Suite Primary Bedroom
- Bathroom on Main Level
- 5 Full Bathrooms
Schools
- Contact Agent Elementary School
- Contact Agent High School
Utilities
- ENERGY STAR Qualified Air Conditioning
- Natural Gas Connected
Additional Features
- ENERGY STAR Qualified Equipment for Heating
- 5,000 Sq Ft Lot
Community Details
- 2 Units
Listing and Financial Details
- Assessor Parcel Number 13597-0020
Map
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2026 | $7,365 | $38,179 | $8,748 | $29,431 |
| 2025 | $7,330 | $38,090 | $10,504 | $27,586 |
| 2024 | $7,342 | $37,897 | $11,049 | $26,848 |
| 2023 | $6,681 | $34,664 | $10,260 | $24,404 |
| 2022 | $6,242 | $36,120 | $12,840 | $23,280 |
| 2021 | $6,197 | $31,920 | $12,840 | $19,080 |
| 2020 | $6,219 | $30,780 | $12,840 | $17,940 |
| 2019 | $6,112 | $32,100 | $12,840 | $19,260 |
| 2018 | $5,591 | $28,887 | $11,019 | $17,868 |
| 2017 | $5,256 | $27,253 | $11,237 | $16,016 |
| 2016 | $4,830 | $27,253 | $11,237 | $16,016 |
| 2015 | $2,881 | $25,712 | $10,708 | $15,004 |
| 2014 | $2,881 | $25,516 | $10,152 | $15,364 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 08/21/2026 08/21/26 | Price Changed | $1,555,000 | -2.5% | -- | |
| 07/17/2026 07/17/26 | For Sale | $1,595,000 | +135.9% | -- | |
| 12/04/2025 12/04/25 | Sold | $676,000 | -0.3% | $256 / Sq Ft | View Prior Sale |
| 10/13/2025 10/13/25 | Pending | -- | -- | -- | |
| 09/23/2025 09/23/25 | For Sale | $678,000 | -- | $257 / Sq Ft |
Source: OneKey® MLS
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Deed | $676,000 | -- | |
| Interfamily Deed Transfer | -- | -- | |
| Deed | $450,000 | -- | |
| Bargain Sale Deed | $212,000 | Old Republic Natl Title Ins |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $250,000 | Unknown | |
| Closed | $34,825 | Unknown | |
| Closed | $549,450 | Purchase Money Mortgage | |
| Previous Owner | $90,000 | No Value Available | |
| Previous Owner | $337,500 | No Value Available | |
| Previous Owner | $90,000 | No Value Available | |
| Previous Owner | $169,600 | Purchase Money Mortgage |
Source: Public Records
About the Listing Agent
Gabriel's Other Listings
-
$749,000 Open Sun 12:45PM - 2PM
- 4 Beds
- 2 Baths
- 2,280 Sq Ft
- 13314 Francis Lewis Blvd
- Springfield Gardens, NY
-
$1,699,000 Open Sun 11AM - 12:30PM
- 10 Beds
- 7 Baths
- 3,360 Sq Ft
- 21948 143rd Ave
- Springfield Gardens, NY
Source: OneKey® MLS
MLS Number: 1027504
APN: 13597-0020
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate for sale or lease on this web site comes in part from OneKey® MLS. Real estate listings held by brokerage firms other than Ten-X are marked with the OneKey® MLS logo or an abbreviated logo and detailed information about them includes the name of the listing broker.
Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Some IDX listings have been excluded from this website. IDX information is provided exclusively for 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 is deemed reliable but not guaranteed.
Copyright 2026 OneKey® MLS. All rights reserved.
Based on information submitted to the MLS GRID
Listings courtesy of OneKey® MLS as distributed by MLS GRID
Nearby Homes
- 140-36 247th St
- 139-21 246th St
- 14224 250th St
- 247-13 139th Ave
- 14225 250th St
- 241-33 143rd Ave
- 139-18 250th St
- 241-06 141st Ave
- 24322 Weller Ave
- 24102 142nd Ave
- 251-20 Memphis Ave
- 253-02 Memphis Ave
- 253-07 Memphis Ave
- 13812 249th St
- 24336 Caney Rd
- 138-32 242nd St
- 13816 243rd St
- 142-11 254th St
- 131 39 234 St Unit LL
- 233-06 131 Avenue E 233-06 131 Ave Unit 2
- 14019 247th St
- 13916 Caney Ln Unit 2
- 24111 143rd Ave Unit 1Fl
- 24111 143rd Ave Unit 2Fl
- 138-28 250th St Unit 1fl
- 247-22 S Conduit Ave
- 24125 144th Ave Unit 2nd Floor
- 243-12 144th Ave
- 240-20 Caney Rd
- 137-36 242nd St
- 137-36 242nd St Unit 2
- 24909 Mayda Rd Unit 2
- 145-29 243rd St Unit 2
- 13719 257th St
- 25322 147th Rd Unit 1
- 249-11 147th Rd Unit 2nd Floor
- 13539 Hook Creek Blvd
- 13539 Hook Creek Blvd Unit Beautiful One bedroo
- 139-51 231st St Unit 1
- 139-51 231st St
Your Personal Tour Guide
Ask me questions while you tour the home.