NOT LISTED FOR SALE

174 Blueberry Hill Rd Longmeadow, MA 01106

Estimated Value: $933,000 - $1,186,000

4 Beds
3.5 Baths
3,501 Sq Ft
$301/Sq Ft Est. Value

Last Sold July 21, 2023

Last sale price $975,000 $278 Per Sq Ft

Est. 8% increase in value since last sale

Current estimated payment $7,206/month

14 Days on Market

Highlights

  • Golf Course Community
  • Medical Services
  • Solar Power System
  • Blueberry Hill Rated A-
  • Cabana
  • 0.96 Acre Lot

About This Home

As of July 2023

Enjoy resort style living! Large lot in superb location! Pride of ownership shines throughout this custom property. Entertainer's layout features gorgeous kitchen with large granite island. Natural light enhances the beamed ceiling. Dining room has spectacular views. Spacious floor plan with large living room, sitting room with gas fireplace and main floor bedroom being used as an office. First floor laundry room. Half bath. Second floor main suite with loft area, bedroom with private deck, walk-in closets, bath with tub, walk-in shower, dual sinks and heated floor. Second floor guest wing with two additional bedrooms big enough for king beds. Remodeled full bath. Finished basement for family area with wet bar and guest suite with full bath. Impeccable backyard with two-tiered deck, hot tub, outdoor shower, wandering paths and gardens, inground pool and the most amazing cabana with stone fireplace, wet bar, changing, pantry and utility rooms. Heated workshop - and so, so much more!

Last Agent to Sell the Property

Roland Gelinas

Keller Williams Realty Listed on: 06/01/2023

Keller Williams Realty

Last Buyer's Agent

Heather Bennet

Keller Williams Realty

Keller Williams Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $15,744

Year Built

  • Built in 1972 | Remodeled

Lot Details

  • 0.96 Acre Lot
  • Stone Wall
  • Landscaped Professionally
  • Level Lot
  • Sprinkler System
  • Garden
  • Property is zoned RA1

Parking

  • 2 Car Attached Garage
  • Parking Storage or Cabinetry
  • Workshop in Garage
  • Side Facing Garage
  • Garage Door Opener
  • Driveway
  • Open Parking
  • Off-Street Parking

Home Design

  • Cape Cod Architecture
  • Block Foundation
  • Frame Construction
  • Shingle Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 3,501 Sq Ft Home
  • Open Floorplan
  • Wet Bar
  • Central Vacuum
  • Wired For Sound
  • Wainscoting
  • Beamed Ceilings
  • Cathedral Ceiling
  • Ceiling Fan
  • Skylights
  • Recessed Lighting
  • Decorative Lighting
  • Light Fixtures
  • 2 Fireplaces
  • Insulated Windows
  • Picture Window
  • Window Screens
  • French Doors
  • Sliding Doors
  • Insulated Doors
  • Mud Room
  • Sitting Room
  • Dining Area
  • Loft
  • Home Security System

Kitchen

  • Oven
  • Built-In Range
  • Stove
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Solid Surface Countertops
  • Disposal

Flooring

  • Wood
  • Wall to Wall Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

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

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Interior and Exterior Basement Entry
  • Sump Pump

Eco-Friendly Details

  • Energy-Efficient Thermostat
  • Whole House Vacuum System
  • Solar Power System

Pool

  • Cabana
  • In Ground Pool
  • Spa
  • Outdoor Shower

Outdoor Features

  • Balcony
  • Deck
  • Patio
  • Outdoor Storage
  • Rain Gutters
  • Porch

Location

  • Property is near schools

Schools

  • Blueberry Hill Elementary School
  • Williams Middle School
  • Longmeadow High School

Utilities

  • Whole House Fan
  • Central Air
  • 4 Cooling Zones
  • 5 Heating Zones
  • Heating System Uses Natural Gas
  • Baseboard Heating
  • 200+ Amp Service
  • Natural Gas Connected
  • Tankless Water Heater
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number M:0087 B:0045 L:0058,2542841

Community Details

Overview

  • No Home Owners Association
  • Blueberry Hill Subdivision

Amenities

  • Medical Services
  • Shops

Recreation

  • Golf Course Community
  • Tennis Courts
  • Community Pool
  • Park
  • Jogging Path
  • Bike Trail

Home Details

Home Type

Single Family

Est. Annual Taxes

$15,744

Year Built

Built in 1972 | Remodeled

Lot Details

0

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Cape
  • Property Condition: Updated/Remodeled, Remodeled
  • Year Built: 1972
  • Buyer Agency: 2.5
  • Subdivision Name: Blueberry Hill
  • Transaction Broker: 0
  • Year Built Details: Actual,Renovated Since
  • SUB AGENCY OFFERED: No
  • Year Round: Yes
  • Compensation Based On: Net Sale Price
  • ResoPropertyType: Residential
  • ResoBuildingAreaSource: PublicRecords
  • Special Features: VirtualTour

Interior Features

  • Flooring: Tile, Carpet, Hardwood, Flooring - Hardwood, Flooring - Stone/Ceramic Tile
  • Interior Amenities: Closet/Cabinets - Custom Built, Recessed Lighting, Lighting - Sconce, Ceiling - Beamed, Closet, Bathroom - Full, Bathroom - Tiled With Shower Stall, Ceiling Fan(s), Sitting Room, Mud Room, Loft, Bathroom, Central Vacuum, Wet Bar, Wired for Sound, Other
  • Door Features: Insulated Doors, French Doors
  • Fireplace YN: Yes
  • Fireplaces: 2
  • Appliances: Oven,Dishwasher,Disposal,Microwave,Countertop Range,Refrigerator,Washer,Dryer,Vacuum System,Other, Tank Water Heaterless, Utility Connections for Gas Range, Utility Connections for Electric Oven, Utility Connections for Gas Dryer
  • Total Bedrooms: 4
  • Room Bedroom2 Level: Second
  • Room Bedroom2 Features: Flooring - Wall to Wall Carpet, Closet - Double
  • Room Bedroom3 Features: Flooring - Wall to Wall Carpet, Closet - Double
  • Room Bedroom3 Level: Second
  • Room Bedroom4 Level: Main,First
  • Room Bedroom4 Features: Flooring - Hardwood, French Doors, Recessed Lighting, Remodeled, Lighting - Overhead
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bathrooms: 4
  • Main Level Bathrooms: 1
  • Main Level Bedrooms: 1
  • Total Bathrooms: 3.5
  • Room Master Bedroom Features: Bathroom - Full, Skylight, Ceiling Fan(s), Vaulted Ceiling(s), Walk-In Closet(s), Closet/Cabinets - Custom Built, Flooring - Stone/Ceramic Tile, Flooring - Wall to Wall Carpet, Deck - Exterior, Exterior Access, Recessed Lighting, Remodeled, Slider, Lighting - Overhead
  • Room Master Bedroom Level: Second
  • Master Bathroom Features: Yes
  • Bathroom 1 Features: Bathroom - Half, Ceiling Fan(s), Flooring - Stone/Ceramic Tile, Deck - Exterior, Remodeled, Lighting - Sconce, Pedestal Sink
  • Bathroom 1 Level: Main,First
  • Bathroom 2 Level: Second
  • Bathroom 2 Features: Bathroom - Full, Bathroom - Double Vanity/Sink, Bathroom - Tiled With Shower Stall, Bathroom - With Tub, Skylight, Closet, Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid, Recessed Lighting, Remodeled, Lighting - Sconce
  • Bathroom 3 Features: Bathroom - Full, Bathroom - With Tub & Shower, Ceiling Fan(s), Closet - Linen, Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid, Remodeled, Lighting - Sconce, Lighting - Overhead
  • Bathroom 3 Level: Second
  • Room Dining Room Features: Skylight, Ceiling Fan(s), Flooring - Stone/Ceramic Tile, Window(s) - Picture, Deck - Exterior, Exterior Access, Open Floorplan, Remodeled, Slider, Lighting - Overhead
  • Room Dining Room Level: Main,First
  • Room Family Room Level: Basement
  • Room Family Room Features: Bathroom - Full, Closet, Closet/Cabinets - Custom Built, Flooring - Wall to Wall Carpet, Wet Bar, Exterior Access, Open Floorplan, Recessed Lighting, Remodeled, Lighting - Pendant, Lighting - Overhead, Beadboard
  • Room Kitchen Level: Main,First
  • Room Kitchen Features: Cathedral Ceiling(s), Ceiling Fan(s), Beamed Ceilings, Flooring - Stone/Ceramic Tile, Dining Area, Countertops - Stone/Granite/Solid, Kitchen Island, Open Floorplan, Recessed Lighting, Remodeled, Stainless Steel Appliances, Gas Stove, Lighting - Pendant, Lighting - Overhead
  • Laundry Features: Flooring - Stone/Ceramic Tile, Pantry, Main Level, Gas Dryer Hookup, Remodeled, Washer Hookup, Lighting - Overhead, First Floor
  • Room Living Room Level: Main,First
  • Room Living Room Features: Ceiling Fan(s), Flooring - Hardwood, Window(s) - Picture, Cable Hookup, Open Floorplan, Recessed Lighting, Remodeled, Lighting - Sconce
  • Basement: Full, Finished, Walk-Out Access, Interior Entry, Sump Pump
  • Living Area: 3501
  • Spa Features: Private
  • Spa YN: Yes
  • Window Features: Skylight, Insulated Windows, Screens
  • MAIN LO: M95273
  • LIST PRICE PER Sq Ft: 278.49
  • PRICE PER Sq Ft: 278.49
  • MAIN SO: M95273

Exterior Features

  • Exterior Features: Balcony, Rain Gutters, Storage, Professional Landscaping, Sprinkler System, Decorative Lighting, Garden, Outdoor Shower, Stone Wall
  • Construction Materials: Frame, Conventional (2x4-2x6)
  • Fencing: Fenced/Enclosed, Fenced
  • Foundation Details: Concrete Perimeter, Block
  • Home Warranty YN: No
  • Other Structures: Cabana
  • Patio And Porch Features: Porch, Deck - Wood, Patio
  • Pool Features: In Ground
  • Pool Private YN: Yes
  • Road Frontage Type: Public
  • Road Surface Type: Paved
  • Roof: Shingle
  • Waterfront YN: No

Garage/Parking

  • Garage Spaces: 2
  • Attached Garage YN: Yes
  • Carport Y N: No
  • Covered Parking Spaces: 2
  • Garage YN: Yes
  • Open Parking YN: Yes
  • Parking Features: Attached, Garage Door Opener, Storage, Workshop in Garage, Garage Faces Side, Paved Drive, Off Street, Paved
  • Total Parking Spaces: 4

Utilities

  • Sewer: Public Sewer
  • Utilities: for Gas Range, for Electric Oven, for Gas Dryer, Washer Hookup
  • Cooling: Central Air, Whole House Fan
  • Heating: Baseboard, Natural Gas, Fireplace(s)
  • Cooling Y N: Yes
  • Electric: Circuit Breakers, 200+ Amp Service, Other (See Remarks)
  • Heating YN: Yes
  • Security Features: Security System
  • Water Source: Public
  • HEAT ZONES: 5
  • COOLING ZONES: 4

Condo/Co-op/Association

  • Association YN: No
  • Community Features: Shopping, Pool, Tennis Court(s), Park, Walk/Jog Trails, Golf, Medical Facility, Bike Path, Highway Access, House of Worship, Private School, Public School, University, Sidewalks
  • Senior Community YN: No

Lot Info

  • Parcel Number: M:0087 B:0045 L:0058,2542841
  • Zoning: RA1
  • Farm Land Area Units: Square Feet
  • Lot Features: Level, Other
  • Lot Size Acres: 0.96
  • Lot Size Area: 0.96
  • Lot Size Sq Ft: 41761
  • Lot Size Units: Acres
  • Property Attached YN: No
  • PAGE: 310
  • ResoLotSizeUnits: Acres

Green Features

  • Green Energy Efficient: Thermostat
  • Green Energy Generation: Solar

Tax Info

  • Tax Year: 2023
  • Tax Annual Amount: 15744
  • Tax Book Number: 12745

Multi Family

  • Basement Included Sq Ft: No

MLS Schools

  • High School: Longmeadow
  • Elementary School: Blueberry Hill
  • Middle Or Junior School: Williams

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
May 31, 1991
Sold by
Davis Steven A and Davis Ramona N
Bought by
Mckay David A and Mckay Nancy S
Current Estimated Value
$1,054,638
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
Mckay David A $295,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Bull David A $700,000
Closed Mckay David A $200,000
Closed Mckay David A $189,000
Closed Mckay David A $80,000
Closed Mckay David A $365,000
Closed Mckay David A $95,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/21/2023 07/21/23 Sold $975,000 0.0% $278 / Sq Ft
06/16/2023 06/16/23 Pending -- -- --
06/05/2023 06/05/23 For Sale $975,000 0.0% $278 / Sq Ft
06/04/2023 06/04/23 Off Market $975,000 -- --
06/01/2023 06/01/23 For Sale $975,000 -- $278 / 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 $17,515 $829,300 $234,200 $595,100
2024 $17,150 $829,300 $234,200 $595,100
2023 $15,878 $686,900 $183,800 $503,100
2022 $15,085 $612,200 $191,900 $420,300
2021 $14,710 $594,600 $190,700 $403,900
2020 $14,267 $589,300 $206,300 $383,000
2019 $13,389 $555,800 $206,300 $349,500
2018 $13,363 $549,000 $224,600 $324,400
2017 $12,945 $549,000 $224,600 $324,400
2016 $12,698 $521,900 $209,900 $312,000
2015 $12,278 $519,800 $207,800 $312,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MLS Property Information Network (MLS PIN)

MLS Number: 73118603

MLS Property Information Network (MLS PIN)

APN: LONG-000087-000045-000058