NOT LISTED FOR SALE

87 Esplanade Dr Rochester, NY 14610

Estimated Value: $445,000 - $770,794

2 Beds
2.5 Baths
2,711 Sq Ft
$246/Sq Ft Est. Value

Last Sold October 31, 2022

Last sale price $575,000 $212 Per Sq Ft

Est. 16% increase in value since last sale

Current estimated payment $4,999/month

32 Days on Market

Highlights

  • Built-In Refrigerator
  • 0.66 Acre Lot
  • Marble Flooring
  • Council Rock Primary School Rated A
  • Wooded Lot
  • Granite Countertops

About This Home

As of October 2022

Remarks: Spectacular doesn't even begin to describe this home situated in coveted Council Rock Estates. Rarely available 2700 sq RANCH. Current owner has put much love and attention to detail in all facets of this home over the last 5 years. Gorgeous Imported Italian tile in foyer. Living room is like a contemporary art gallery with customized wood burning fireplace. A wall of windows overlooks the garden of this backyard paradise. Huge fam rm walks out to a skylit covered patio- Top of the line eat in SieMatic kitchen, Miele and Subzero appliances, a chef's dream...Butler’s pantry/bar leads into formal dining room with built ins and glass shelves. Front den/office with built ins. En suite spacious master bedroom with new spa-like bath. Guest bedroom and updated full bath. Newly designed powder room off kitchen. First floor laundry. All updated HVAC, Hot Water and softener systems. There is no basement per se, but a bomb shelter with lots of storage.....Nothing left to do but move in to this exceptional, special offering.

Last Agent to Sell the Property

Michael Haymes

Listing by RE/MAX Realty Group License #10301209258 Listed on: 07/11/2022

RE/MAX Realty Group

Co-Listed By

Randy Young

Listing by RE/MAX Realty Group License #30YO0602949

Last Buyer's Agent

Derek Heerkens

Listing by RE/MAX Plus License #10401261047

RE/MAX Plus

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $14,217

Year Built

  • Built in 1952

Lot Details

  • 0.66 Acre Lot
  • Lot Dimensions are 157 x 145
  • Wooded Lot
  • Private Yard

Home Design

  • Block Foundation
  • Stone Frame
  • Asphalt Roof
  • Partial Copper Plumbing

Interior Spaces

  • 2,711 Sq Ft Home
  • 1-Story Property
  • Wood Burning Fireplace
  • Thermal Windows
  • Drapes & Rods
  • Family Room
  • Living Room
  • Formal Dining Room
  • Home Office
  • Partial Basement
  • Security System Owned

Kitchen

  • Eat-In Kitchen
  • Walk-In Pantry
  • Built-In Range
  • Range Hood
  • Microwave
  • Built-In Refrigerator
  • Dishwasher
  • Granite Countertops
  • Disposal

Flooring

  • Wood
  • Wall to Wall Carpet
  • Marble
  • Ceramic Tile

Bedrooms and Bathrooms

  • 2 Bedrooms

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Parking

  • 2.5 Car Attached Garage
  • Garage Door Opener

Outdoor Features

  • Patio
  • Porch

Schools

  • French Road Elementary School
  • Twelve Corners Middle School
  • Brighton High School

Utilities

  • Forced Air Cooling System
  • Humidifier
  • Heating System Uses Gas
  • Programmable Thermostat
  • Gas Water Heater
  • Water Softener is Owned
  • Cable TV Available

Community Details

  • Council Rock Estates Community
  • Council Rock Estates Subdivision

Listing and Financial Details

  • Assessor Parcel Number 262000-137-070-0003-024-100

Home Details

Home Type

Single Family

Est. Annual Taxes

$14,217

Year Built

Built in 1952

Lot Details

0

Listing Details

  • NY Swis Code: Brighton-Monroe Co.-262000
  • Total Assessed Value: 326200
  • Foundation Description: Block
  • Listing Type: Exclusive Right To Sell
  • Lot Dimension Depth: 157
  • Lot Dimension Front: 145
  • Lot Information: Neighborhood Street, Wooded Lot
  • Nearest Cross Street: Clover
  • Number of Stories: 1.0000
  • Property Type: Single Family Residential
  • Ratio Close Price By Acres: 871212.12
  • Ratio Close Price By Sq Ft: 212.10
  • Ratio List Price By Acres: 908939.39
  • Ratio List Price By Sq Ft: 221.28
  • Regional Board Code: Rochester
  • Roof Description: Asphalt
  • School Tax: 8645
  • Styles of Residence: Ranch
  • Sub Board Code: Rochester
  • Type of Sale: Normal
  • Year Built Description: Existing
  • Lot Sq Ft: 28750
  • Age of Building: 70
  • Year Built: 1952
  • Above Grade Finished Sq Ft: 2711
  • Directions To Property: Clover Street to Esplanade- Council Rock Estates
  • Sq Ft Total Pub: 2711
  • Subdivision Comm Complex: Council Rock Estates
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1
  • Year Built: 1952

Interior Features

  • Full Bathrooms: 2
  • Additional Interior Features: Circuit Breakers - Some, Copper Plumbing - Some, Drapes - Some, Security System - Owned, Water Softener - Owned
  • Additional Rooms: 1st Floor Bedroom, 1st Floor Master Bedroom, 1st Floor Master Suite, Den/Study, Family Room, Foyer/Entry Hall, Laundry-1st Floor, Living Room, Master Bedroom Bath, Office, Porch - Open
  • Attic Description: Crawl Space
  • Basement Description: Partial
  • Floor Description: Ceramic-Some, Hardwood-Some, Marble-Some, Wall To Wall Carpet-Some
  • Kitchen Appliances Included: Cooktop - Electric, Dishwasher, Disposal, Dryer, Microwave, Oven/Range Built-In, Range Hood-Exhaust Fan, Refrigerator-Built In, Washer
  • Kitchen Dining Description: Eat-In, Formal Dining Room, Granite Counter, Walk-In Pantry
  • Number of Bedrooms 1st Floor: 2
  • Number of Fireplaces Total Calculated: 1
  • Number of Fireplaces Woodburning: 1
  • Number of 1st Floor Full Bathrooms: 2
  • Number of 1st Floor Half Bathrooms: 1
  • Number of Rooms: 7
  • Half Bathrooms: 1
  • Total Bathrooms: 2.10
  • Total Bedrooms: 2
  • Total Sq Ft: 2711

Exterior Features

  • Construction: Stone and Frame
  • Additional Exterior Features: Cable TV Available, Garage Door Opener, Patio, Private Yard - see Remarks, Thermal Windows - Some
  • Number of Acres: 0.6600

Garage/Parking

  • Driveway Description: Concrete
  • Garage Description: Attached
  • Number of Garage Spaces: 2.5000

Utilities

  • Heating Fuel Description: Gas
  • Hvac Type: Forced Air, Humidifier, Programmable Thermostat
  • Sewer Description: Sewer Connected
  • Water Heater Fuel: Gas

Schools

  • School District: Brighton
  • Elementary School: French Road Elementary
  • Middle School: Twelve Corners Middle
  • High School: Brighton High

Lot Info

  • Parcel Number: 262000-137-070-0003-024-100

Tax Info

  • Total Taxes: 14217

MLS Schools

  • Elementary School Name: French Road Elementary
  • High School Name: Brighton High
  • Middle School Name: Twelve Corners Middle
  • School District Name: Brighton

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 11, 2022
Closed on
Oct 12, 2022
Sold by
Miller Ira S
Bought by
Huss Michael D and Hume Susan H
Seller's Agent
Michael Haymes
RE/MAX Realty Group
Buyer's Agent
Derek Heerkens
RE/MAX Plus
List Price
$599,900
Sold Price
$575,000
Premium/Discount to List
-$24,900
-4.15%
Views
53
Current Estimated Value
$667,699

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$92,699
Avg. Annual Appreciation
5.15%
Original Mortgage
$546,250
Outstanding Balance
$528,759
Interest Rate
6.02%
Mortgage Type
New Conventional
Estimated Equity
$133,370

Purchase Details

Listed on
Feb 9, 2015
Closed on
Mar 12, 2015
Sold by
Shapiro Marcia
Bought by
Miller Ira S
Seller's Agent
Marilyn Greenberg
Howard Hanna
Buyer's Agent
Michael Haymes
RE/MAX Realty Group
List Price
$289,900
Sold Price
$290,000
Premium/Discount to List
$100
0.03%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
9.39%
Original Mortgage
$232,000
Interest Rate
2.92%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jan 16, 2013
Sold by
Shapiro Marcia G
Bought by
The Marcia Shapiro Trust
Source: Public Records

Range of Values:

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
Huss Michael D $575,000 --
Miller Ira S $290,000 None Available
The Marcia Shapiro Trust -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Huss Michael D $546,250
Previous Owner The Marcia Shapiro Trust $232,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
10/31/2022 10/31/22 Sold $575,000 -4.2% $212 / Sq Ft
08/12/2022 08/12/22 Pending -- -- --
07/11/2022 07/11/22 For Sale $599,900 +106.9% $221 / Sq Ft
03/18/2015 03/18/15 Sold $290,000 0.0% $107 / Sq Ft
02/12/2015 02/12/15 Pending -- -- --
02/09/2015 02/09/15 For Sale $289,900 -- $107 / Sq Ft
Source: Upstate New York Real Estate Information Services (UNYREIS)

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
2024 $16,336 $349,200 $95,300 $253,900
2023 $16,185 $349,200 $95,300 $253,900
2022 $14,324 $326,200 $95,300 $230,900
2021 $14,036 $326,200 $95,300 $230,900
2020 $13,949 $326,200 $95,300 $230,900
2019 $12,573 $326,200 $95,300 $230,900
2018 $13,516 $326,200 $95,300 $230,900
2017 $7,727 $280,000 $130,000 $150,000
2016 $12,573 $280,000 $130,000 $150,000
2015 -- $280,000 $130,000 $150,000
2014 -- $280,000 $130,000 $150,000
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Upstate New York Real Estate Information Services (UNYREIS)

MLS Number: R1419739

Upstate New York Real Estate Information Services (UNYREIS)

APN: 262000-137-070-0003-024-100