Y
Seller's Agent in 2023
Yaakov Esterzohn
Blooming Realty
(929) 379-7159
13 in this area
26 Total Sales
247 Ardmore Ave Staten Island, NY 10314
Willowbrook NeighborhoodEstimated Value: $1,019,639 - $1,070,000
5
Beds
2
Baths
2,504
Sq Ft
$415/Sq Ft
Est. Value
Highlights
- 0.09 Acre Lot
- 1 Car Attached Garage
- Back, Front, and Side Yard
- P.S. 54 Charles W Leng Rated A
- Eat-In Kitchen
- Walk-In Closet
About This Home
As of February 2023This is a GORGEOUS One Family , fully renovated professionally Interior Decorated Custom home . This house was completely gutted and remodeled. Every bell and whistle including Brand new plumbing , heating , air condition , electrical and heating unit , roof , landscaping and concrete . Nestled on a very quiet block in beautiful Emerson Hill this house will absolutely not last . Serious inquiries only . 5 bedroom 2 baths , HUGE family room with a Custom Bar and entertainment room. The entire house is wired for cable and has a custom theatre system built throughout the entire house. State of the Art alarm security and camera system. Automated Sprinkler System .4th Bedroom was converted to a Custom Closet .HOUSE IS MOVE IN READY WITH ABSOLUTELY NOTHING TO DO OTHER THAN UNPACK YOUR STUFF!!!
Last Agent to Sell the Property
Blooming Realty Brokerage Phone: 929-379-7159 License #10401355464 Listed on: 08/15/2022
Co-Listed By
Jaccob Halpern
Blooming Realty Brokerage Phone: 929-379-7159 License #10401317576
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $8,016
Year Built
- Built in 1965
Lot Details
- 4,000 Sq Ft Lot
- Lot Dimensions are 40x100
- Back, Front, and Side Yard
- Property is zoned R3-1
Parking
- 1 Car Attached Garage
- Off-Street Parking
Home Design
- Aluminum Siding
Interior Spaces
- 2,504 Sq Ft Home
- 2-Story Property
- Open Floorplan
Kitchen
- Eat-In Kitchen
- Microwave
- Freezer
- Dishwasher
Bedrooms and Bathrooms
- 5 Bedrooms
- Walk-In Closet
- 2 Full Bathrooms
Laundry
- Dryer
- Washer
Outdoor Features
- Outdoor Gas Grill
Utilities
- Forced Air Heating System
- Heating System Uses Natural Gas
- 220 Volts
Listing and Financial Details
- Legal Lot and Block 0083 / 00788
- Assessor Parcel Number 00788-0083
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Aug 15, 2022
Closed on
Feb 13, 2023
Sold by
Jld Realty Holdings Llc
Bought by
Brandwein Yosef D and Eisenbach Leah
Seller's Agent
Yaakov Esterzohn
Blooming Realty
Buyer's Agent
Jaccob Halpern
Blooming Realty
List Price
$1,199,000
Sold Price
$950,000
Premium/Discount to List
-$249,000
-20.77%
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
$88,910
Avg. Annual Appreciation
3.51%
Original Mortgage
$760,000
Outstanding Balance
$736,996
Interest Rate
6.13%
Mortgage Type
New Conventional
Estimated Equity
$301,914
Purchase Details
Closed on
Jan 30, 2018
Sold by
Derrico Joseph
Bought by
Jld Realty Holdings Llc
Purchase Details
Listed on
Jul 22, 2012
Closed on
Jan 15, 2013
Sold by
247 Ardmore Ave Llc
Bought by
Derrico Joseph
Seller's Agent
Gary Kerber
Seller IQ, Inc.
Buyer's Agent
Joseph Pugliese
Compass Realty Central Inc.
List Price
$530,000
Sold Price
$530,000
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.45%
Original Mortgage
$417,000
Interest Rate
3.35%
Mortgage Type
New Conventional
Purchase Details
Listed on
Mar 7, 2012
Closed on
Apr 17, 2012
Sold by
Deutsche Bank National Trust Company
Bought by
Kohm Kevin and Kohm Linda
Seller's Agent
Thomas Marcotrigiano
Tom Marco Real Estate, Inc.
Buyer's Agent
Anthony Trimarche
Coldwell Banker Advantage
List Price
$320,000
Sold Price
$320,000
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
99.61%
Purchase Details
Closed on
Oct 27, 2010
Sold by
Brown Ira Leslie
Bought by
Deutsche Bank National Trust Company
Purchase Details
Closed on
Aug 14, 1997
Sold by
Brown Ira Leslie and Brown Clara
Bought by
Brown Ira Leslie
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
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Brandwein Yosef D | $950,000 | Exclusive Land Services | |
| Jld Realty Holdings Llc | -- | Thompson Land Services Inc | |
| Derrico Joseph | $530,000 | None Available | |
| 245 Ardmore Ave Llc | -- | None Available | |
| Kohm Kevin | $320,000 | None Available | |
| Deutsche Bank National Trust Company | $1,000 | Webtitle Agency | |
| Brown Ira Leslie | -- | -- |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Brandwein Yosef D | $760,000 | |
| Previous Owner | Derrico Joseph | $417,000 | |
| Previous Owner | Brown Ira Leslie | $200,000 | |
| Previous Owner | Brown Ira Leslie | $250,000 |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 02/13/2023 02/13/23 | Sold | $950,000 | -20.8% | $379 / Sq Ft |
| 12/06/2022 12/06/22 | Pending | -- | -- | -- |
| 08/15/2022 08/15/22 | For Sale | $1,199,000 | +126.2% | $479 / Sq Ft |
| 01/15/2013 01/15/13 | Sold | $530,000 | 0.0% | $212 / Sq Ft |
| 12/24/2012 12/24/12 | Pending | -- | -- | -- |
| 07/22/2012 07/22/12 | For Sale | $530,000 | +65.6% | $212 / Sq Ft |
| 04/25/2012 04/25/12 | Sold | $320,000 | 0.0% | $128 / Sq Ft |
| 03/19/2012 03/19/12 | Pending | -- | -- | -- |
| 03/07/2012 03/07/12 | For Sale | $320,000 | -- | $128 / Sq Ft |
Source: Staten Island Multiple Listing Service
Tax History Compared to Growth
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 |
|---|---|---|---|---|
| 2025 | $8,431 | $60,960 | $7,708 | $53,252 |
| 2024 | $8,431 | $55,500 | $7,987 | $47,513 |
| 2023 | $8,042 | $39,600 | $7,407 | $32,193 |
| 2022 | $7,604 | $49,200 | $10,560 | $38,640 |
| 2021 | $8,016 | $46,140 | $10,560 | $35,580 |
| 2020 | $12,621 | $51,000 | $10,560 | $40,440 |
| 2019 | $10,980 | $46,440 | $10,560 | $35,880 |
| 2018 | $6,727 | $33,000 | $10,560 | $22,440 |
| 2017 | $3,298 | $31,740 | $10,560 | $21,180 |
| 2016 | $6,393 | $31,980 | $10,560 | $21,420 |
| 2015 | $5,953 | $32,881 | $8,725 | $24,156 |
| 2014 | $5,953 | $31,020 | $8,820 | $22,200 |
Source: Public Records
Agents Affiliated with this Home
-
Yaakov Esterzohn
-
J
Seller Co-Listing Agent in 2023
Jaccob Halpern
Blooming Realty
-
G
Seller's Agent in 2013
Gary Kerber
Seller IQ, Inc.
-
Joseph Pugliese
J
Buyer's Agent in 2013
Joseph Pugliese
Compass Realty Central Inc.
(917) 699-7596
6 Total Sales
-
Thomas Marcotrigiano
T
Seller's Agent in 2012
Thomas Marcotrigiano
Tom Marco Real Estate, Inc.
(718) 998-7100
221 Total Sales
-
Anthony Trimarche
A
Buyer's Agent in 2012
Anthony Trimarche
Coldwell Banker Advantage
(888) 276-0630
19 Total Sales
Map
Source: Staten Island Multiple Listing Service
MLS Number: 1156957
APN: 00788-0083
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.
Certain real estate listing data is provided by Staten Island MLS under its Internet Data Exchange program. This data is provided exclusively for consumers’ personal, non-commercial use and may only be used for identifying prospective properties consumers may be interested in purchasing or renting. Any other use of the data is hereby prohibited. Data deemed reliable but is not guaranteed accurate by Staten Island MLS and should be independently verified. Copyright 2025 Staten Island Multiple Listing Service, Inc. All rights reserved.
Nearby Homes
- 198 Warwick Ave
- 182 Ardmore Ave
- 5 Birchard Ave
- 619 Ingram Ave
- 274 Crafton Ave
- 15 Boone St
- 0 Woodward Ave
- 0 Roosevelt Ave
- 97 Martin Ave
- 546 Buchanan Ave Unit B
- 591 Woolley Ave
- 148 Roosevelt Ave
- 566 Buchanan Ave Unit B
- 147 Roosevelt Ave
- 267 Purdy Ave
- 27 Bascom Place
- 49 Sheraden Ave
- 664 S Gannon Ave
- 50 Bradley Ct Unit 52
- 53 Carmel Ave
- 251 Ardmore Ave
- 243 Ardmore Ave
- 255 Ardmore Ave
- 239 Ardmore Ave
- 250 Sheraden Ave
- 254 Sheraden Ave
- 246 Sheraden Ave
- 259 Ardmore Ave
- 235 Ardmore Ave
- 258 Sheraden Ave
- 242 Sheraden Ave
- 262 Sheraden Ave
- 238 Sheraden Ave
- 263 Ardmore Ave
- 231 Ardmore Ave
- 231 Ardmore Ave Unit 2fl
- 250 Ardmore Ave
- 246 Ardmore Ave
- 254 Ardmore Ave
- 242 Ardmore Ave