NOT LISTED FOR SALE

304 Hickey Hill Rd Sheffield, MA 01257

Estimated Value: $1,188,000 - $1,677,568

4 Beds
3 Baths
4,000 Sq Ft
$356/Sq Ft Est. Value

Last Sold December 01, 2017

Last sale price $1,350,000 $338 Per Sq Ft

Est. 5% increase in value since last sale

Current estimated payment $8,929/month

656 Days on Market

Highlights

  • Scenic Views
  • Colonial Architecture
  • Cathedral Ceiling
  • 718,304 Sq Ft lot
  • Wooded Lot
  • Wood Flooring

About This Home

As of December 2017

Historic farmhouse originally part of Merryfield Farm in Sheffield. Built in the 1790's, it was meticulously renovated in 2012 with the help of a talented architect, renowned builder and exacting owner. Structural improvements include a new foundation, septic tank, well, roof, 5 zone heating and central air conditioning, new hot water tank, plumbing and electrical systems.

Last Agent to Sell the Property

Timothy Lovett

COMPASS MASSACHUSETTS , LLC GB License #9036091 Listed on: 01/17/2016

Last Buyer's Agent

Maxwell Lenihan

BERKSHIRE HOMES AND CONDOS

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $9,886

Year Built

  • 1799

Lot Details

  • 16.49 Acre Lot
  • Landscaped
  • Wooded Lot
  • Historic Home

Property Views

  • Scenic Vista
  • Pasture

Home Design

  • Colonial Architecture
  • Post and Beam
  • Farmhouse Style Home
  • Updated or Remodeled
  • Wood Frame Construction
  • Asphalt Shingled Roof
  • Fiberglass Roof
  • Wood Siding
  • Clap Board Siding
  • Clapboard

Interior Spaces

  • 4,000 Sq Ft Home
  • Central Vacuum
  • Cathedral Ceiling
  • Fireplace
  • Insulated Windows
  • Insulated Doors
  • Alarm System

Kitchen

  • Range with Range Hood
  • Microwave
  • Dishwasher
  • Granite Countertops

Flooring

  • Wood
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Main Floor Bedroom
  • Cedar Closet
  • Walk-In Closet
  • 3 Full Bathrooms

Laundry

  • Dryer
  • Washer

Unfinished Basement

  • Basement Fills Entire Space Under The House
  • Interior Basement Entry

Parking

  • No Garage
  • Off-Street Parking

Outdoor Features

  • Balcony
  • Porch

Schools

  • Undermountain Elementary School
  • Mount Everett Middle School
  • Mount Everett High School

Farming

  • Pasture

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Boiler Heating System
  • Radiant Heating System
  • Well
  • Propane Water Heater
  • Private Sewer

Home Details

Home Type

Single Family

Est. Annual Taxes

$9,886

Year Built

1799

Lot Details

0

Listing Details

  • Property Type: Residential - Single Family
  • Property Type: Residential
  • Style: Colonial, NE Farmhouse, Historic
  • Accessibility: 1st Fl Bdrm, 1st Flr Full Bath
  • Condition: Recently Renovated
  • Construction: Post/Beam, Wood Frame
  • Directions: From Sheffield, east on County Road, right onto Hickey Hill Road, up the hill to the house on the right.
  • Marketing Headline: 1799 CENTER CHIMNEY COLONIAL, RENOVATED AND ADDED TO, IN A BEAUTIFUL SETTING
  • Year Built Description: Renovated Since
  • Views: Distant, Scenic, Pastoral
  • Estimated Year Built: 1799
  • Right Of Way: Unk
  • Property Water Features: Pond, Brook
  • Special Features: None
  • Property Sub Type: Detached
  • Year Built: 1799

Interior Features

  • Appliances Included: Dishwasher, Washer, Refrigerator, Range, Range Hood, Microwave, Dryer
  • Total Bedrooms: 4
  • Total Bathrooms: 3.00
  • Total Full Baths: 3
  • Basement: Full, Interior Access, Concrete Floor, Unfinished
  • Insulation: Foam
  • Interior Amenities: Alarm System, Radiant Heat, Cedar Closet(s), Cathedral Ceilings, Granite Counter, Interior Balcony, Walk-In Closet(s), High Speed Wiring, Fireplace (s), Central Vacuum
  • Floor: Ceramic Tile, Wood
  • Sq Ft Liv Apx: 4000.00
  • Total Rooms: 8

Exterior Features

  • Exterior Amenities: Landscaped, Porch
  • Roof: Asphalt Shingles, Fiberglass
  • Exterior Siding: Wood, Clapboard

Garage/Parking

  • Parking Spaces Type: Off Street
  • Garage: None

Utilities

  • Electric Type: 200 Amp
  • Fuel: Propane
  • Hot Water: Propane
  • Internet Service: Cable Available
  • Sewer: Private
  • Underground Oil Tank: Unk
  • Water: Well
  • Flood Hazard Area: Unk
  • Heat Cool Vent: Central AC, Hybrid, Boiler, Radiant, Multizone, Forced Air

Schools

  • Elementary School: Undermountain
  • Middle School: Mount Everett
  • High School: Mount Everett

Lot Info

  • Estimated Acres: 16.49
  • Total Assessed Value: 9500.00
  • Assessed Year: 2017.00
  • Lot Description: Wooded, Pasture
  • Lot Size Sq Ft: 718304.00
  • Map Ref: M:021 B:0001 & 0002 L:0012.0 & 0012.6 & 0001.0
  • Right To Farm Comm: Yes
  • Zoning: Residential
  • Lot Dimensions: 1
  • Easement: Unk
  • Survey: Unk

Green Features

  • Energy Features: Insulated Windows, Insulated Doors

Tax Info

  • Taxes: 9886.00
  • Tax Year: 2016

MLS Schools

  • Elementary School: Undermountain
  • High School: Mount Everett
  • Middle School: Mount Everett

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
May 16, 2016
Sold by
Spirakis David J
Bought by
Spirakis David J and Chaplin Penelope
Current Estimated Value
$1,422,142

Purchase Details

Closed on
Mar 4, 2011
Sold by
Waldman Sacha and Berkshire Bk
Bought by
Spirakis David J

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$617,400
Interest Rate
4%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Dec 14, 2007
Sold by
Ustico Edward J and Shiels Michael J
Bought by
Waldman Sacha

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$818,000
Interest Rate
6.3%
Mortgage Type
Purchase Money Mortgage
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
Spirakis David J -- --
Spirakis David J $368,000 --
Waldman Sacha $710,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Fox Matthew S $4,500,000
Previous Owner Spirakis David J $595,000
Previous Owner Spirakis David J $617,400
Previous Owner Waldman Sacha $818,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/01/2017 12/01/17 Sold $1,350,000 -3.2% $338 / Sq Ft
11/03/2017 11/03/17 Pending -- -- --
01/17/2016 01/17/16 For Sale $1,395,000 -- $349 / Sq Ft
Source: Berkshire County Board of REALTORS®

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 $14,882 $1,228,900 $111,500 $1,117,400
2024 $14,440 $1,228,900 $111,500 $1,117,400
2023 $13,058 $1,228,900 $111,500 $1,117,400
2022 $13,058 $1,049,700 $111,500 $938,200
2021 $12,720 $916,400 $106,400 $810,000
2020 $12,769 $912,100 $106,400 $805,700
2019 $12,975 $837,100 $92,200 $744,900
2018 $7,839 $531,800 $92,200 $439,600
2017 $7,807 $531,800 $92,200 $439,600
2016 $7,530 $525,100 $88,500 $436,600
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Berkshire County Board of REALTORS®

MLS Number: 217829

Berkshire County Board of REALTORS®

APN: SHEF M:021.0 B:0001 L:0012.0