NOT LISTED FOR SALE

87 Prospect Ave Cedarhurst, NY 11516

Estimated Value: $1,883,449 - $2,290,000

5 Beds
4.5 Baths
2,725 Sq Ft
$766/Sq Ft Est. Value

Last Sold December 13, 2024

Last sale price $1,999,999 $734 Per Sq Ft

Est. 4% increase in value since last sale

Current estimated payment $11,931/month

119 Days on Market

Highlights

  • Colonial Architecture
  • Detached Garage
  • Central Air
  • 1 Fireplace
  • Porch

About This Home

As of December 2024

Welcome to 87 Prospect Ave, a luxurious fully renovated Colonial home in the heart of Cedarhurst. From High end appliances to custom details throughout, this home is a must see. 5 bedrooms and 3 baths on the 2nd and 3rd floors, Additional 2 bedrooms and full bath in the basement. Security cameras, intercom system, sprinkler system. Home was gutted down to the studs and custom finished with the finest finishes, move right in amd make it yours!, Additional information: Appearance:Diamond+++,Separate Hotwater Heater:Y

Last Agent to Sell the Property

Dov Segal

Five Towns Miller Realty Inc Brokerage Phone: 516-374-4100 License #10401371286 Listed on: 05/14/2024

Last Buyer's Agent

Don Miller

Five Towns Miller Realty Inc License #31MI1087734

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $14,827

Year Built

  • Built in 1917 | Remodeled in 2024

Lot Details

  • 8,096 Sq Ft Lot
  • Lot Dimensions are 88x90
  • Front and Back Yard Sprinklers

Parking

  • Detached Garage

Home Design

  • Colonial Architecture
  • Frame Construction
  • Vinyl Siding

Interior Spaces

  • 1 Fireplace
  • Finished Basement
  • Basement Fills Entire Space Under The House

Bedrooms and Bathrooms

  • 5 Bedrooms

Outdoor Features

  • Porch

Schools

  • Lawrence Middle School At Broadway Campus
  • Lawrence Senior High School

Utilities

  • Central Air
  • Heating System Uses Natural Gas
  • Hydro-Air Heating System
  • Gas Water Heater

Listing and Financial Details

  • Legal Lot and Block 301 / 252
  • Assessor Parcel Number 2003-39-252-00-0301-0

Home Details

Home Type

Single Family

Est. Annual Taxes

$14,827

Year Built

Built in 1917 | Remodeled in 2024

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architectural Style: Colonial
  • Property SubType: Single Family Residence
  • Year Built: 1917
  • Year Built Effective: 2024
  • Attribution Contact: 516-374-4100
  • CurrentPrice: 1999999.00
  • MlsMajorChangeType: Sold
  • ListPrice_By_OriginalListPrice: 1.00000
  • Special Features: VirtualTour
  • Property Sub Type: Detached
  • Year Renovated: 2024

Interior Features

  • Appliances: Gas Water Heater
  • Fireplaces: 1
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Basement: Finished, Full
  • Total Bedrooms: 5
  • Basement YN: No

Exterior Features

  • Construction Materials: Vinyl Siding, Frame
  • Pool Private: No
  • Spa: No
  • Patio and Porch Features: Porch

Garage/Parking

  • Parking Description: Detached, Private

Utilities

  • Cooling: Central Air
  • Heating: Natural Gas, Hydro Air
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • Senior Community: No
  • Association: No

Schools

  • Middle School: LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS

Lot Info

  • Lot Dimensions: 88x90
  • Lot Size Sq Ft: 8096
  • Lot Features: Sprinklers In Front, Sprinklers In Rear
  • Parcel Number: 2003-39-252-00-0301-0
  • Property Attached: No

Rental Info

  • Lease Considered: No

Multi Family

  • Units Total: 1

Tax Info

  • Tax Annual Amount: 14827.02
  • Tax Block: 252
  • Tax Lot: 301

MLS Schools

  • High School: Lawrence Senior High School

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 14, 2024
Closed on
Dec 13, 2024
Sold by
87 Prospect Ave Llc
Bought by
Esquenazi Michael and Algrisi Shani
Seller's Agent
Dov Segal
Five Towns Miller Realty Inc
Buyer's Agent
Don Miller
Five Towns Miller Realty Inc
List Price
$2,299,000
Sold Price
$1,999,999
Premium/Discount to List
-$299,001
-13.01%
Views
77
Current Estimated Value
$2,086,725

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$86,726
Avg. Annual Appreciation
3.90%
Original Mortgage
$1,599,998
Outstanding Balance
$1,586,997
Interest Rate
6.78%
Mortgage Type
New Conventional
Estimated Equity
$499,728

Purchase Details

Listed on
Mar 16, 2023
Closed on
Sep 29, 2023
Sold by
Prospect 87 Llc
Bought by
87 Prospect Ave Llc
Seller's Agent
Annette Samant
BERKSHIRE HATHAWAY
Buyer's Agent
Etty Levy
BERKSHIRE HATHAWAY
List Price
$1,249,000
Sold Price
$900,000
Premium/Discount to List
-$349,000
-27.94%
Views
82

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
94.53%
Original Mortgage
$750,600
Interest Rate
7.18%
Mortgage Type
Construction

Purchase Details

Closed on
May 31, 2011
Sold by
Friedman Zvi and Bistricer Joseph
Bought by
Prospect 87 Llc

Purchase Details

Closed on
May 12, 2011
Sold by
Us Bank National Association
Bought by
Bistricer Joseph and Friedman Zvi

Purchase Details

Closed on
Feb 5, 2009
Sold by
Hershko Itzhak
Bought by
Mishpacha Llc

Purchase Details

Closed on
Sep 16, 2005
Sold by
Hanover Norman
Bought by
Nadav Properties Llc
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Esquenazi Michael $1,999,999 Your Title Experts
Esquenazi Michael $1,999,999 Your Title Experts
Esquenazi Michael $1,999,999 Your Title Experts
Esquenazi Michael $1,999,999 Your Title Experts
87 Prospect Ave Llc $918,000 None Available
87 Prospect Ave Llc $918,000 None Available
87 Prospect Ave Llc $918,000 None Available
87 Prospect Ave Llc $918,000 None Available
87 Prospect Ave Llc $918,000 None Available
Prospect 87 Llc -- --
Prospect 87 Llc -- --
Prospect 87 Llc -- --
Bistricer Joseph $475,000 --
Bistricer Joseph $475,000 --
Bistricer Joseph $475,000 --
Mishpacha Llc -- Attorney
Mishpacha Llc -- Attorney
Mishpacha Llc -- Attorney
Nadav Properties Llc $950,000 --
Nadav Properties Llc $950,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Esquenazi Michael $1,599,998
Closed Esquenazi Michael $1,599,998
Previous Owner 87 Prospect Ave Llc $750,600
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
12/13/2024 12/13/24 Sold $1,999,999 -13.0% $734 / Sq Ft
09/11/2024 09/11/24 Pending -- -- --
05/14/2024 05/14/24 For Sale $2,299,000 +155.4% $844 / Sq Ft
10/02/2023 10/02/23 Sold $900,000 0.0% $330 / Sq Ft View Prior Sale
08/16/2023 08/16/23 Pending -- -- --
07/16/2023 07/16/23 Off Market $900,000 -- --
04/25/2023 04/25/23 Price Changed $1,199,000 -4.0% $440 / Sq Ft
03/16/2023 03/16/23 For Sale $1,249,000 -- $458 / Sq Ft
Source: OneKey® MLS

Tax History Compared to Growth

Source: Public Records

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 $13,530 $963 $357 $606
2024 $4,741 $963 $357 $606
2023 $13,683 $963 $357 $606
2022 $13,683 $963 $357 $606
2021 $19,122 $944 $350 $594
2020 $14,826 $1,422 $914 $508
2019 $14,495 $1,422 $914 $508
2018 $13,944 $1,422 $0 $0
2017 $8,654 $1,422 $914 $508
2016 $12,763 $1,422 $914 $508
2015 $3,822 $1,422 $914 $508
2014 $3,822 $1,422 $914 $508
2013 $3,527 $1,422 $914 $508
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: OneKey® MLS

MLS Number: L3551414

OneKey® MLS

APN: 2003-39-252-00-0301-0