S
Seller's Agent in 2025
Stanley Hayden
HomeSmart Premier Living Rlty
1 in this area
8 Total Sales
14027 247th St Rosedale, NY 11422
Rosedale NeighborhoodEstimated Value: $691,974 - $1,096,000
Studio
--
Bath
2,643
Sq Ft
$322/Sq Ft
Est. Value
About This Home
As of December 2025Introducing a prime multifamily investment opportunity in the desirable Rosedale neighborhood of Queens, NY. Whether you're an investor looking for a high-potential asset or a family ready to design your dream home from the ground up, this property is the perfect fit. Situated on a generous 50x100 lot with a two-car garage, this home offers a solid footprint and a classic layout with endless potential. This property is an ideal opportunity for a developer, cash buyer, or a buyer with a rehab loan. Its location is a major selling point, just minutes from JFK International Airport and close to local schools, shops, and public transportation. This is your chance to bring a vision to life in one of Queens' most established communities. Don't miss out on this unique opportunity. This property is being sold in as-is condition. The seller makes no guarantees about the property's condition, room count, or other physical characteristics. Schedule your showing today!
Last Agent to Sell the Property
HomeSmart Premier Living Rlty Brokerage Phone: 929-487-4001 License #10401382165 Listed on: 09/23/2025
Last Buyer's Agent
HomeSmart Premier Living Rlty Brokerage Phone: 929-487-4001 License #10401382165 Listed on: 09/23/2025
Property Details
Home Type
- Multi-Family
Est. Annual Taxes
- $7,365
Year Built
- Built in 1940
Lot Details
- 5,000 Sq Ft Lot
Parking
- 2 Car Garage
Home Design
- Duplex
- A-Frame Home
- Frame Construction
Unfinished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
Schools
- Ps/Ms 138 Sunrise Elementary School
- Collaborative Arts Middle School
- George Washington Carver High School For The Scie
Utilities
- No Cooling
- No Heating
Community Details
- 2 Units
Listing and Financial Details
- Assessor Parcel Number 13597-0020
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Sep 23, 2025
Closed on
Dec 4, 2025
Sold by
Jones Constance D and Jones Omar
Bought by
Yosef 18 Holdings Llc
Seller's Agent
Stanley Hayden
HomeSmart Premier Living Rlty
Buyer's Agent
Stanley Hayden
HomeSmart Premier Living Rlty
List Price
$678,000
Sold Price
$676,000
Premium/Discount to List
-$2,000
-0.29%
Views
36
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$174,244
Avg. Annual Appreciation
70.46%
Original Mortgage
$507,000
Outstanding Balance
$505,050
Interest Rate
6.22%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$345,195
Purchase Details
Closed on
Aug 4, 2021
Sold by
Jones Constance D
Bought by
Jones Constance D and Jones Omar
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$549,450
Interest Rate
2.7%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Oct 28, 2005
Sold by
Miller Gordon and Ramsay Linda J
Bought by
Jones Constance D
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$90,000
Interest Rate
5.93%
Purchase Details
Closed on
Jul 28, 1999
Sold by
Cepeda Eddie and Cepeda Antonia
Bought by
Miller Gordon and Ramsey Linda J
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$169,600
Interest Rate
7.6%
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
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 | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Yosef 18 Holdings Llc | $676,000 | -- | |
| Jones Constance D | -- | -- | |
| Jones Constance D | -- | -- | |
| Jones Constance D | -- | -- | |
| Jones Constance D | $450,000 | -- | |
| Jones Constance D | $450,000 | -- | |
| Miller Gordon | $212,000 | Old Republic Natl Title Ins | |
| Miller Gordon | $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 | Borrower | Loan Amount |
|---|---|---|---|
| Open | Yosef 18 Holdings Llc | $507,000 | |
| Previous Owner | Jones Constance D | $549,450 | |
| Previous Owner | Jones Constance D | $90,000 | |
| Previous Owner | Jones Constance D | $337,500 | |
| Previous Owner | Miller Gordon | $169,600 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 12/04/2025 12/04/25 | Sold | $676,000 | -0.3% | $256 / Sq Ft |
| 10/13/2025 10/13/25 | Pending | -- | -- | -- |
| 09/23/2025 09/23/25 | For Sale | $678,000 | -- | $257 / Sq Ft |
Source: OneKey® MLS
Tax History
| 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
Agents Affiliated with this Home
-
Stanley Hayden
Map
Source: OneKey® MLS
MLS Number: 916104
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
- 248-18 Memphis Ave
- 139-32 249th St
- 14112 250th St
- 139-21 246th St
- 24712 139th Ave
- 14224 250th St
- 13917 250th St
- 241-06 141st Ave
- 14146 253rd St
- 251-20 Memphis Ave
- 243-51 Caney Rd
- 14408 Weller Ln
- 14141 255th St
- 240-26 Caney Rd
- 240-24 Caney Rd
- 24909 Mayda Rd
- 24358 Mayda Rd
- 253-22 147th Ave
- 25707 147th Ave
- 14023 247th St
- 14031 247th St
- 140-19 247th St
- 14019 247th St
- 14019 247th St
- 14037 247th St
- 14030 248th St
- 14026 248th St
- 14030 248th St Unit 2nd Fl
- 14034 248th St
- 14022 248th St
- 14038 248th St
- 140-38 248th St
- 140-32 247th St
- 140-32 247th St Unit 1
- 140-22 247th St
- 14011 247th St
- 14028 247th St
- 14022 247th St
- 14032 247th St
Your Personal Tour Guide
Ask me questions while you tour the home.