For Sale
For Rent
Blog
Property Records
Schools
SEARCH
Property Records
For Sale
For Rent
MORE
Blog
Schools
See Home Value
Amherst Center 01002
151 Columbia Dr
$340,000
● House - Off Market

151 Columbia Dr

Amherst, MA 01002
bedrooms
3 Beds
bathrooms
2 Baths, 1 Half Bath
square feet
1,516 Ft²
$558,073
RealtyHop Estimate
69.16%
Since Aug 1, 2016
National-US
Primary Model

About This Property

A delightful pastoral view is offered from the pleasant, sunny yard of this Executive Ranch!  Tucked on a .53 acre lot which borders protected land, the floor plan is spacious, yet warm and inviting.  With mostly hardwood floors throughout, the gracious living room sports a wood burning fireplace and a wall of custom built-ins.  The dining room, generous in size, connects to a beautiful screened porch, perfect for everyday enjoyment or festive summer dinners!  A finished lower level includes a family room with fireplace, study and half bath.  Minutes to area colleges, downtown Amherst and shopping - a great place to call home!
Unit Size
1,516 Ft²
Days on Market
-
Land Size
0.53 acres
Price per sqft
$218
Property Type
House
Property Taxes
$464
HOA Dues
-
Year Built
1972

Payment Calculator

Home Price
Down Payment
%
Loan Term
Interest %

Your Estimated Monthly Payment

Principal + Interest:
Property Tax:
HOA:
Home Insurance:
Mortgage Insurance:

Cap Rate Calculator

Purchase Price
Monthly Property Taxes
Monthly Rental Income
Maintenance & HOA
Income Per Year
Expenses Per Year
Operating Profit Per Year
Cap Rate 100% Occupancy
N/A (extreme outlier)

What does this mean?

Based on our analysis, the cap rate of this property is 1.25%. A negative cap rate indicates that the property might not be feasible as an income-producing asset. The median cap rate for a near zip code 11238 is 4.23%.

How much can I actually make?

Actual monthly rental income may vary between $4,760 and $7,140 depending on unit-specific characteristics. You can change the amount using the slider to further explore.

How is cap rate calculated?

Cap Rate = Net Operating Income (NOI) / Property Asset Value.

When calculating the cap rate, we assume 100% occupancy. Leverage (mortgage) is not considered.

Cap Rate provided by RealtyHop and RentHop, learn more about cap rate here.

Last updated: 4 months ago (MLSPIN #72010117)

Price History

Date / Event Date Event Price
Nov 30, 2020 Sold
Premium
Sold
Sep 20, 2020 Listed by 5 College REALTORS® $450,000
Listed by 5 College REALTORS®
Jul 12, 2016 Sold
Premium
Sold
May 20, 2016 Listed by 5 College REALTORS® $329,900
Listed by 5 College REALTORS®

Property Highlights

Garage
Parking Available
Air Conditioning
Fireplace

Building Info

Overview

    General

  • Year Built: 1972
  • Effective Year Built: 1972
  • Building Count: 1
  • Total Rooms: 6
  • Bedroom Count: 3
  • Bathroom Count: 3
  • Full Bathrooms: 2
  • Partial Bathrooms: 3
  • Building Condition: 3
  • Building Quality: 0
  • Construction Type: 0
  • Building Style: 11
  • Exterior Walls Type: 18
  • Interior Walls Type: 0
  • Roof Shape Type: 1
  • Roof Cover Type: 15
  • Floor Count: 100
  • Living Units: 1
  • Floor Cover: 0
  • Basement Type: 0
  • Basement Area: 0
  • Garage Type: 0
  • Parking Space Count: 0
  • Patio Type: 0
  • Porch Type: 0
  • Pool Type: 0

    Dimensions

  • Lot Size Square Feet: 22,948
  • Total Building Area: 1,516
  • Gross Building Area: 3,752
  • Building Area: 1,516
  • Building Area Measurement: L

    Heating and Cooling

  • Air Conditioning: 13
  • Heating: 4
  • Heated Square Feet: 1,516
  • Heating Fuel Type: 6

    Utilities

  • Sewer System: 0
  • Water Service: 0

Building

  • Building Type: 0
  • Property Class: R
  • Subdivision: HUNTER S HILL
  • Land Acres: 0000000527
  • Standard Land Use Code: 1001
  • County Land Use Code: 101

Neighborhood

  • School District Name: Amherst School District
  • Census Tract: 820500

Geography

  • Account Number: 9251
  • District: 8
  • Parcel: AMHE M:0016D B:0000 L:0224
  • Lot: 224
  • Municipality: AMHERST
  • Latitude: 42.3543
  • Longitude: -72.5297

    Address

  • Full Address: 151 Columbia Dr
  • Address - House Number: 151
  • Address - Street Name: Columbia
  • Address - Suffix Type: Dr
  • State: MA
  • City Name: Amherst
  • Carrier Code: C006
  • 4-Digit Zip Code: 3107
  • Zip Code: 01002

Valuation

    Tax

  • Tax Year: 2024
  • Tax Amount: $972,900
  • Initial Tax Delinquent Year: 2024

    Appraisal Valuation

  • Standard Deviation: 0.2146
  • Valuation Date: Apr 03, 2024
  • Confidence Score: 70
  • Final Value: 556,776
  • High Value: 676,312
  • Low Value: 437,239

    Assessments Valuation

  • Assessed Year: 2024
  • Assessed Total Value: $525,600
  • Assessed Land Value: $177,000
  • Assessed Improvements Value: $348,600

    Sales

  • Current Sale Contract Date: Nov 27, 2020
  • Current Sale Recording Date: Nov 30, 2020
  • Current Sale Price:
    Premium
  • Current Sale Document Type: O
  • Current Sale Input Document Number: 25398
  • Previous Sale Recording Date: Jul 12, 2016
  • Previous Sale Amount: $340,000
  • Previous Sale Document Type: O
Data used for valuation calculations is provided by RealtyHop, and other third party sources
Request mortgage information redaction

Comparables

Unit
Status
Type
Beds
Baths
ft²
Price/ft²
Asking Price
Listed On
Closing Price
Sold On
HOA + Taxes

About Amherst Center

Stats & Trends

Median Asking:

$575,000

Sale Price/ft²

$321

Below Asking

0.01%

Average Days on Market

53

Average Home Size

1944 ft²

Average Home Age

82.6 years

Currently For Sale

22 Listings
Based on RH Advisors, Inc. calculations of home data from MLS and/or public records.

Similar Homes for Sale

Currently no similar homes around

Nearby Rentals

Rentals Near You

Click here to view more rentals in the neighborhood.
Last Updated: 4 months ago
Data Source: MLS PIN, MLS# 72010117

Frequently Asked Questions

When was property at 151 Columbia Drive built and last sold?
The property at 151 Columbia Drive was built in 1972 and last sold on Nov 27, 2020 for $455,938.
How much is this home worth?
The estimated value of the home located at 151 Columbia Drive is $456,580.
What are some comparable homes to 151 Columbia Drive?
There are currently no comparable homes to 151 Columbia Drive.
Recent Neighborhood News
Lake House Prices Near NYC in 2026: What Waterfront Actually Costs (Labor Day Buyer's Guide)
9 New York City Seafood and Raw Bars
Why Some NYC Tenement Apartments Had Bathtubs in the Kitchen
The Current Status of iBuying in 2026: What To Know
Popular Searches
Amherst Homes for Sale
Amherst Houses for Sale
Amherst Condos for Sale
Amherst Multifamily for Sale
Amherst Land for Sale
Amherst Commercial for Sale
Amherst Homes with Basements
Amherst Homes with Pools
Nearby Cities
Chicopee Homes for Sale
Amherst Center Homes for Sale
Belchertown Homes for Sale
South Amherst Homes for Sale
North Amherst Homes for Sale
South Deerfield Homes for Sale
Granby Homes for Sale
Hatfield Homes for Sale
Nearby Property Records
Hampshire County, MA Property Records
Franklin County, MA Property Records
Hampden County, MA Property Records
Worcester County, MA Property Records
Berkshire County, MA Property Records
Tolland County, CT Property Records
Cheshire County, NH Property Records
Hartford County, CT Property Records
Nearby Counties
Chicopee Homes for Sale
Ludlow Homes for Sale
South Hadley Homes for Sale
Belchertown Homes for Sale
Montague Homes for Sale
Granby Homes for Sale
Hadley Homes for Sale
Deerfield Homes for Sale
Top Real Estate Agents
Top Agents in Amherst
Top Agents in Chicopee
Top Agents in Chicopee
Top Agents in 01040
Top Agents in 01020
Top Agents in 01002
Top Agents in Ludlow
Top Agents in South Hadley