NOT LISTED FOR SALE

400 S Undermountain Rd Sheffield, MA 01257

Sheffield Area

Estimated Value: $665,000 - $997,000

7 Beds
6 Baths
3,128 Sq Ft
$268/Sq Ft Est. Value

Sale Details

Date Sold: October 3, 2018

Last sale price $374,000 $120 Per Sq Ft

Est. 124% increase in value since last sale

Current estimated payment $5,258 / mo

184 Days on Market

Highlights

  • Access To Lake
  • Multiple Garages
  • Wooded Lot
  • Spa
  • 91,476 Sq Ft lot
  • Vaulted Ceiling

About This Home

As of October 2018

*NEW PRICE* The Ramblewood Inn. A quaint Country Inn in the Berkshires w/ deeded Lake Lot. 7 Bedrooms - 6 Guestrooms, plus a separate 1 Bedroom Apt for the owner/caretaker. Continue its tradition, or take advantage of the generous space for you and your family. Well cared for, with upgraded mechanicals (including *new SEPTIC*) and exterior improvements that include a fire-pit & hot tub. Property also includes deeded access to Berkshire Lake. Minutes from the Berkshire School, Catamount Ski, Gt Barrington, Salisbury, CT and More...

Last Agent to Sell the Property

Steven Weisz

WILLIAM PITT SOTHEBY'S - GT BARRINGTON License #150149 Listed on: 02/13/2018

Co-Listed By

Maggie Merelle

WILLIAM PITT SOTHEBY'S - GT BARRINGTON License #009537394

Last Buyer's Agent

Paul Harsch

HARSCH ASSOCIATES License #92676

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 Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,362

Year Built

  • 1986

Lot Details

  • 2.1 Acre Lot
  • Mature Landscaping
  • Privacy
  • Wooded Lot
  • Landscaped with Trees

Home Design

  • Log Cabin
  • Asphalt Shingled Roof
  • Fiberglass Roof
  • Log Siding

Interior Spaces

  • 3,128 Sq Ft Home
  • Vaulted Ceiling
  • Ceiling Fan
  • Fireplace

Kitchen

  • Range with Range Hood
  • Dishwasher
  • Granite Countertops

Flooring

  • Wood
  • Carpet
  • Linoleum
  • Ceramic Tile

Bedrooms and Bathrooms

  • 7 Bedrooms
  • Main Floor Bedroom
  • In-Law or Guest Suite
  • Bathroom on Main Level
  • 6 Full Bathrooms

Laundry

  • Dryer
  • Washer

Partially Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Interior Basement Entry
  • Garage Access

Parking

  • 2 Car Attached Garage
  • Multiple Garages
  • Off-Street Parking

Outdoor Features

  • Spa
  • Access To Lake
  • Patio
  • Exterior Lighting
  • Porch

Schools

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

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Heating System Uses Oil
  • Private Water Source
  • Electric Water Heater
  • Private Sewer
  • Cable TV Available

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,362

Year Built

1986

Lot Details

2.1 Acres

Listing Details

  • Property Type: Residential - Single Family
  • Property Type: Residential
  • Style: Log
  • Accessibility: 1st Fl Bdrm | 1st Flr Full Bath | 1st Flr Bdrm w/Bath
  • Construction: Log
  • Directions: Route 41 South, Sheffield. Look for sign.
  • Right Of Way: Unk
  • Special Features: None
  • Property Sub Type: Detached
  • Year Built: 1986

Interior Features

  • Appliances Included: Dishwasher, Washer, Range, Refrigerator, Range Hood, Dryer
  • Total Bedrooms: 7
  • Total Bathrooms: 6.00
  • Total Full Baths: 6
  • Basement: Finished-Partially, Walkout, Interior Access, Garage Access, Full
  • Interior Amenities: Cable Available | Vaulted Ceilings | Fireplace (s) | Inlaw/Guest Qtrs | Hot Tub | Granite Counter
  • Floor: Carpet | Wood | Linoleum | Ceramic Tile
  • Sq Ft Liv Apx: 3128.00

Exterior Features

  • Exterior Amenities: Bus-School | Mature Landscaping | Privacy | Porch | Patio | Landscaped | Lighting | Deciduous Shade Trees
  • Roof: Asphalt Shingles | Fiberglass
  • Waterfront: Close to Water | Lake Access | Deeded Rights
  • Waterfront Lake Pond Name: Berkshire Lake
  • Exterior Siding: Log

Garage/Parking

  • Garage Stalls: 2
  • Parking Spaces: 8.00
  • Parking Spaces Type: Garaged & Off-Street
  • Garage: Attached | Multiple

Utilities

  • Electric Type: 200 Amp
  • Fuel: Oil
  • Hot Water: Electric
  • Internet Service: Cable Available
  • Sewer: Private
  • Underground Oil Tank: Unk
  • Water: Private
  • Flood Hazard Area: Unk
  • Heat Cool Vent: Ceiling Fan | Multizone | Forced Air | Central AC

Lot Info

  • Estimated Acres: 2.10
  • Total Assessed Value: 433400.00
  • Assessed Year: 2017.00
  • Lot Description: Wooded
  • Lot Size Sq Ft: 91476.00
  • Right To Farm Comm: Yes
  • Zoning: Residential
  • Lot Dimensions: 91476
  • Easement: Unk
  • Survey: Unk

Tax Info

  • Taxes: 6362.00
  • Tax Year: 2017

MLS Schools

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

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 13, 2018
Closed on
Oct 3, 2018
Sold by
Hawver Nadine
Bought by
Seller's Agent
Steven Weisz
WILLIAM PITT SOTHEBY'S - GT BARRINGTON
Buyer's Agent
Paul Harsch
HARSCH ASSOCIATES
List Price
$399,500
Sold Price
$374,000
Premium/Discount to List
-$25,500
-6.38%
Current Estimated Value
$838,792

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$464,792
Avg. Annual Appreciation
10.72%
Original Mortgage
$299,200
Outstanding Balance
$255,453
Interest Rate
4.5%
Mortgage Type
New Conventional
Estimated Equity
$583,339

Purchase Details

Closed on
May 30, 2017
Sold by
Hawver Clifton
Bought by
Hawver Nadine

Purchase Details

Closed on
Aug 27, 2001
Sold by
Desmond Harry and Desmond Holly Marie
Bought by
Hawver Nadine and Hawver Clifton J

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$25,000
Interest Rate
7.21%

Purchase Details

Closed on
Jan 28, 2000
Sold by
Ederer Martin and Ederer June Rita
Bought by
Desmond Harry and Desmond Holly Marie

Purchase Details

Closed on
Jun 18, 1999
Sold by
Stendardi Serafino and Stendardi A
Bought by
Ederer Martin and Ederer June Rita
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Agents Specializing in Sheffield, MA

  • AB

    Allen Bassen

    BERKSHIRE HOMES AND CONDOS

    (413) 414-4432

    18 Total Sales

    1 in Sheffield

    $350,000 Price

    Allen Bassen
     Section Image
  • Selina Lamb Real Estate Agent - BIRCH PROPERTIES

    Selina Lamb

    BIRCH PROPERTIES

    (413) 344-2689

    78 Total Sales

    5 in Sheffield

    $550K - $1.8M Price Range

    Selina Lamb
     Section Image
  • Chapin Fish Real Estate Agent - William Pitt Sothebys Intn'l

    Chapin Fish

    William Pitt Sothebys Intn'l

    (860) 362-2105

    89 Total Sales

    5 in Sheffield

    $525K - $2.5M Price Range

    Chapin Fish
     Section Image
  • Wendy Eichman Real Estate Agent - Raynard & Peirce Realty,LLC

    Wendy Eichman

    Raynard & Peirce Realty,LLC

    (860) 499-4974

    99 Total Sales

    6 in Sheffield

    $110K - $1.1M Price Range

    Wendy Eichman
     Section Image
  • Dan Alden Real Estate Agent - ALDEN COUNTRY REAL ESTATE SERVICES

    Dan Alden

    ALDEN COUNTRY REAL ESTATE SERVICES

    (413) 331-7821

    78 Total Sales

    21 in Sheffield

    $225K - $1.1M Price Range

    Dan Alden
     Section Image
  • Cristian Sanchez Real Estate Agent - COHEN & WHITE ASSOCIATES

    Cristian Sanchez

    COHEN & WHITE ASSOCIATES

    (860) 362-2125

    48 Total Sales

    2 in Sheffield

    $390K - $493K Price Range

    Cristian Sanchez
     Section Image
See All Agents

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$374,000 --
Hawver Nadine -- --
Hawver Nadine $385,200 --
Desmond Harry $302,500 --
Ederer Martin $25,000 --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open -- $299,200
Previous Owner Hawver Nadine A $149,900
Previous Owner Hawver Clifton J $30,000
Previous Owner Hawver Clifton J $330,000
Closed Hawver Nadine A $25,000
Previous Owner Hawver Nadine A $207,000
Previous Owner Desmond Harry Joseph $70,000
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
10/03/2018 10/03/18 Sold $374,000 -6.4% $120 / Sq Ft
08/16/2018 08/16/18 Pending -- -- --
02/13/2018 02/13/18 For Sale $399,500 -- $128 / Sq Ft
Source: Berkshire County Board of REALTORS®

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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 $7,564 $624,600 $111,500 $513,100
2024 $7,339 $624,600 $111,500 $513,100
2023 $6,754 $624,600 $111,500 $513,100
2022 $6,754 $542,900 $111,500 $431,400
2021 $6,742 $485,700 $106,400 $379,300
2020 $6,503 $464,500 $106,400 $358,100
2019 $6,718 $433,400 $92,300 $341,100
2018 $6,388 $433,400 $92,300 $341,100
2017 $6,362 $433,400 $92,300 $341,100
2016 $5,958 $415,500 $88,600 $326,900
2015 $6,021 $415,500 $88,600 $326,900
Source: Public Records

Agents Affiliated with this Home

  • SW

    Seller's Agent in 2018

    Steven Weisz

    William Pitt

  • Maggie Merelle Real Estate Agent - William Pitt

    Seller Co-Listing Agent in 2018

    Maggie Merelle

    William Pitt

    (413) 717-0717

    51 Total Sales

    Maggie Merelle
    Section Image
  • Paul Harsch Real Estate Agent - HARSCH ASSOCIATES

    Buyer's Agent in 2018

    Paul Harsch

    HARSCH ASSOCIATES

    (413) 458-4444

    77 Total Sales

    Paul Harsch
    Section Image
See All Agents

Map

Source: Berkshire County Board of REALTORS®

MLS Number: 221997

Berkshire County Board of REALTORS®

APN: SHEF-000140-000002-000040

Massachusetts Berkshire County Sheffield 01257

400 S Undermountain Rd, Sheffield, MA

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Berkshire County Board of REALTORS® IDX information is provided exclusively for consumers' personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed to be reliable but not guaranteed.

The data relating to real estate for sale on this website comes from Berkshire County Board of Realtors and the Broker Reciprocity Program.
Copyright 2026 Berkshire County Board of Realtors. All rights reserved.

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.