NOT LISTED FOR SALE

12 Indian Pipe Dr Hadley, MA 01035

Estimated Value: $943,000 - $1,221,000

4 Beds
5.5 Baths
3,845 Sq Ft
$285/Sq Ft Est. Value

Last Sold April 25, 2024

Last sale price $1,100,000 $286 Per Sq Ft

Current estimated payment $6,630/month

5 Days on Market

Highlights

  • 1.59 Acre Lot
  • Custom Closet System
  • Deck
  • Open Floorplan
  • Landscaped Professionally
  • Contemporary Architecture

About This Home

As of April 2024

Stunning Contemporary in Shattuck Estates offers quality, size & sophistication throughout. Thoughtfully designed, this home includes the finest materials & craftsmanship - a modern, open floor plan allowing for maximum flexibility. Awe-inspiring, the chefs kitchen includes custom-built cabinets w/upgraded DCS appliances, a large island & cozy dining area which incorporates nicely into the living room, the heart of the home. Office with cathedral ceiling, powder room, laundry & first floor BR w/ensuite bath complete the main level. A spacious main bedroom w/ exceptional bath & walk-in closet plus 2 additional BR's with ensuite baths are on the 2nd floor. The finished walkout basement boasts a large media room with custom CA built-ins, an exercise room, bath & additional laundry area. Located on a private 1.59 acres at the end of a cul de sac, the open sunny yard is surrounded by a wooded back drop. Newly added stone front is a beautiful addition. Meticulous! Matchless! Memorable!

Last Agent to Sell the Property

Jacqueline Zuzgo

5 College REALTORS® Listed on: 02/04/2024

Last Buyer's Agent

Heather Bennet

Keller Williams Realty

Keller Williams Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $9,737

Year Built

  • Built in 2015

Lot Details

  • 1.59 Acre Lot
  • Property fronts a private road
  • Cul-De-Sac
  • Landscaped Professionally
  • Level Lot
  • Garden
  • Property is zoned AR

HOA Fees

  • $25 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Parking Storage or Cabinetry
  • Garage Door Opener
  • Driveway
  • Open Parking
  • Off-Street Parking

Home Design

  • Contemporary Architecture
  • Frame Construction
  • Shingle Roof
  • Radon Mitigation System
  • Concrete Perimeter Foundation

Interior Spaces

  • 3,845 Sq Ft Home
  • Open Floorplan
  • Cathedral Ceiling
  • Recessed Lighting
  • Insulated Windows
  • French Doors
  • Insulated Doors
  • Entrance Foyer
  • Living Room with Fireplace
  • Dining Area
  • Home Office
  • Home Gym
  • Home Security System

Kitchen

  • Oven
  • Range
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Solid Surface Countertops

Flooring

  • Wood
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary bedroom located on second floor
  • Custom Closet System
  • Walk-In Closet
  • Double Vanity
  • Bathtub with Shower
  • Separate Shower

Laundry

  • Laundry on main level
  • Washer and Electric Dryer Hookup

Finished Basement

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

Outdoor Features

  • Deck
  • Rain Gutters

Schools

  • Hadley Elementary And Middle School
  • Hadley High School

Utilities

  • Forced Air Heating and Cooling System
  • 3 Cooling Zones
  • 5 Heating Zones
  • Heating System Uses Propane
  • 200+ Amp Service
  • Water Heater
  • Private Sewer
  • Internet Available
  • Cable TV Available

Additional Features

  • Energy-Efficient Thermostat
  • Property is near schools

Listing and Financial Details

  • Legal Lot and Block 7 / 51
  • Assessor Parcel Number M:0013 B:0051 L:0007,4339954

Community Details

Overview

  • Shattuck Estates Subdivision
  • Near Conservation Area

Amenities

  • Shops

Recreation

  • Jogging Path
  • Bike Trail

Home Details

Home Type

Single Family

Est. Annual Taxes

$9,737

Year Built

Built in 2015

Lot Details

0

HOA Fees

$25 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Contemporary
  • Year Built: 2015
  • Subdivision Name: Shattuck Estates
  • Year Built Details: Actual
  • SUB AGENCY OFFERED: No
  • Year Round: Yes
  • Compensation Based On: Net Sale Price
  • ResoPropertyType: Residential
  • ResoBuildingAreaSource: PublicRecords
  • Special Features: VirtualTour

Interior Features

  • Flooring: Wood, Tile, Flooring - Stone/Ceramic Tile, Flooring - Hardwood
  • Interior Amenities: Bathroom - Full, Bathroom - Tiled With Tub & Shower, Countertops - Stone/Granite/Solid, Cathedral Ceiling(s), Closet, Bathroom, Office, Exercise Room, Foyer, Internet Available - Unknown
  • Door Features: French Doors, Insulated Doors
  • Fireplace Features: Living Room
  • Fireplace YN: Yes
  • Fireplaces: 1
  • Appliances: Water Heater, Range, Oven, Dishwasher, Refrigerator
  • Total Bedrooms: 4
  • Room Bedroom2 Level: First
  • Room Bedroom2 Features: Bathroom - 3/4, Closet, Flooring - Hardwood
  • Room Bedroom3 Features: Bathroom - Full, Closet, Flooring - Hardwood
  • Room Bedroom3 Level: Second
  • Room Bedroom4 Level: Second
  • Room Bedroom4 Features: Bathroom - Full, Closet, Flooring - Hardwood
  • Full Bathrooms: 5
  • Half Bathrooms: 1
  • Total Bathrooms: 6
  • Main Level Bathrooms: 1
  • Room Master Bedroom Features: Bathroom - Full, Walk-In Closet(s), Flooring - Hardwood
  • Room Master Bedroom Level: Second
  • Master Bathroom Features: Yes
  • Bathroom 1 Features: Bathroom - 3/4, Bathroom - Tiled With Shower Stall, Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid, Cabinets - Upgraded, Double Vanity
  • Bathroom 1 Level: Main,First
  • Bathroom 2 Level: First
  • Bathroom 2 Features: Bathroom - Half, Flooring - Stone/Ceramic Tile, Dryer Hookup - Electric, Washer Hookup
  • Bathroom 3 Features: Bathroom - Full, Bathroom - Tiled With Tub & Shower, Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid, Double Vanity
  • Bathroom 3 Level: Second
  • Room Dining Room Features: Flooring - Hardwood
  • Room Dining Room Level: Main,First
  • Room Family Room Level: Basement
  • Room Family Room Features: Closet/Cabinets - Custom Built, Flooring - Stone/Ceramic Tile
  • Room Kitchen Level: Main,First
  • Room Kitchen Features: Flooring - Stone/Ceramic Tile, Dining Area, Countertops - Stone/Granite/Solid, Kitchen Island, Cabinets - Upgraded, Open Floorplan, Recessed Lighting, Stainless Steel Appliances
  • Laundry Features: Flooring - Stone/Ceramic Tile, First Floor
  • Room Living Room Level: First
  • Room Living Room Features: Flooring - Hardwood, Cable Hookup, Deck - Exterior, Exterior Access, Open Floorplan
  • Room Office Level: First
  • Room Office Features: Ceiling - Cathedral, Flooring - Hardwood, French Doors
  • Basement: Full, Finished, Interior Entry, Radon Remediation System
  • Accessibility Features: No
  • Living Area: 3845
  • Spa YN: No
  • Window Features: Insulated Windows
  • MAIN LO: AN1019
  • MAIN SO: M95273
  • Insulation: Full

Exterior Features

  • Exterior Features: Deck, Rain Gutters, Professional Landscaping, Garden
  • Construction Materials: Frame
  • Foundation Details: Concrete Perimeter
  • Home Warranty YN: No
  • Patio And Porch Features: Deck
  • Road Frontage Type: Private Road
  • Road Surface Type: Paved
  • Roof: Shingle
  • Waterfront YN: No
  • Waterview Flag: No

Garage/Parking

  • Garage Spaces: 3
  • Attached Garage YN: Yes
  • Carport Y N: No
  • Covered Parking Spaces: 3
  • Garage YN: Yes
  • Open Parking YN: Yes
  • Parking Features: Attached, Garage Door Opener, Storage, Paved Drive, Off Street, Paved
  • Total Parking Spaces: 3

Utilities

  • Sewer: Private Sewer
  • Cooling: Central Air
  • Heating: Forced Air, Propane
  • Cooling Y N: Yes
  • Electric: Circuit Breakers, 200+ Amp Service
  • Heating YN: Yes
  • Security Features: Security System
  • Water Source: Public
  • HEAT ZONES: 5
  • COOLING ZONES: 3

Condo/Co-op/Association

  • Association Fee: 300
  • Association Fee Frequency: Annually
  • Association YN: Yes
  • Community Features: Shopping, Walk/Jog Trails, Bike Path, Conservation Area, Highway Access, House of Worship, Private School, Public School
  • Senior Community YN: No
  • REQD OWN ASSOCIATION: Yes
  • ResoAssociationFeeFrequency: Annually

Lot Info

  • Parcel Number: M:0013 B:0051 L:0007,4339954
  • Zoning: AR
  • Farm Land Area Units: Square Feet
  • Lot Features: Cul-De-Sac, Level
  • Lot Size Acres: 1.59
  • Lot Size Sq Ft: 69204
  • Lot Size Units: Acres
  • Property Attached YN: No
  • ResoLotSizeUnits: Acres

Green Features

  • Green Energy Efficient: Thermostat

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 9737
  • Tax Block: 51
  • Tax Lot: 7

Multi Family

  • Basement Included Sq Ft: No

MLS Schools

  • High School: Hadley
  • Elementary School: Hadley
  • Middle Or Junior School: Hadley

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 20, 2020
Closed on
Nov 23, 2020
Sold by
Eagle Pine Holdings Llc
Bought by
Mcconkey Shaun and Mcconkey Nancy
Seller's Agent
Gregory Haughton
5 College REALTORS®
Buyer's Agent
Jacqueline Zuzgo
5 College REALTORS®
List Price
$799,000
Sold Price
$799,000
Current Estimated Value
$1,097,549

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$298,549
Avg. Annual Appreciation
6.42%
Original Mortgage
$714,000
Outstanding Balance
$635,359
Interest Rate
2.8%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$462,190

Purchase Details

Closed on
Apr 20, 2016
Sold by
Bercume Construction L
Bought by
Eagle Pine Holdings Ll

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$640,000
Interest Rate
3%
Mortgage Type
Unknown
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
Mcconkey Shaun $799,000 None Available
Eagle Pine Holdings Ll $850,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Mcconkey Shaun $714,000
Previous Owner Eagle Pine Holdings Ll $640,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
04/25/2024 04/25/24 Sold $1,100,000 -4.3% $286 / Sq Ft
02/10/2024 02/10/24 Pending -- -- --
02/04/2024 02/04/24 For Sale $1,150,000 +43.9% $299 / Sq Ft
11/30/2020 11/30/20 Sold $799,000 0.0% $210 / Sq Ft View Prior Sale
10/20/2020 10/20/20 Pending -- -- --
10/19/2020 10/19/20 For Sale $799,000 0.0% $210 / Sq Ft
10/16/2020 10/16/20 Off Market $799,000 -- --
10/03/2020 10/03/20 Pending -- -- --
05/20/2020 05/20/20 For Sale $799,000 +30.3% $210 / Sq Ft
07/10/2015 07/10/15 Sold $613,000 -4.1% $192 / Sq Ft View Prior Sale
07/03/2015 07/03/15 Pending -- -- --
04/02/2015 04/02/15 For Sale $639,000 -- $200 / Sq Ft
Source: MLS Property Information Network (MLS PIN)

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 $10,469 $900,200 $169,800 $730,400
2024 $9,737 $854,900 $169,800 $685,100
2023 $9,866 $854,900 $169,800 $685,100
2022 $9,839 $807,800 $169,800 $638,000
2021 $9,667 $805,600 $169,800 $635,800
2020 $9,709 $759,700 $169,800 $589,900
2019 $9,552 $772,800 $169,800 $603,000
2018 $9,343 $772,800 $169,800 $603,000
2017 $9,012 $778,900 $169,800 $609,100
2016 $1,893 $169,800 $169,800 $0
2015 $1,844 $169,800 $169,800 $0
2014 $482 $45,300 $45,300 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: MLS Property Information Network (MLS PIN)

MLS Number: 73199335

MLS Property Information Network (MLS PIN)

APN: HADL-000013-000051-000007