NOT LISTED FOR SALE

400 S Undermountain Rd Sheffield, MA 01257

Estimated Value: $709,000 - $957,000

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

Last Sold October 03, 2018

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

Est. 117% increase in value since last sale

Current estimated payment $4,903/month

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

WILLIAM PITT SOTHEBY'S - GT BARRINGTON

Co-Listed By

Maggie Merelle

WILLIAM PITT SOTHEBY'S - GT BARRINGTON License #009537394

Last Buyer's Agent

Paul Harsch

HARSCH ASSOCIATES License #92676

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

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 13, 2018
Closed on
Oct 3, 2018
Sold by
Hawver Nadine A
Bought by
Jenks-Feuer Susan V
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
$812,378

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$438,378
Avg. Annual Appreciation
10.94%
Original Mortgage
$299,200
Outstanding Balance
$260,920
Interest Rate
4.5%
Mortgage Type
New Conventional
Estimated Equity
$551,458

Purchase Details

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

Purchase Details

Closed on
Aug 27, 2001
Sold by
Desmond Harry Joseph and Desmond Holly Marie
Bought by
Hawver Nadine A 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
$125,000
Interest Rate
7.21%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Jan 28, 2000
Sold by
Ederer Martin and Ederer June Rita
Bought by
Desmond Harry Joseph 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

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
Jenks-Feuer Susan V $374,000 --
Hawver Nadine A -- --
Hawver Nadine A $385,200 --
Desmond Harry Joseph $302,500 --
Ederer Martin $25,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Jenks-Feuer Susan V $299,200
Previous Owner Ederer Martin $30,000
Previous Owner Ederer Martin $125,000
Previous Owner Ederer Martin $207,000
Source: Public Records

Property History

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

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

  • Steven Weisz

    Seller's Agent in 2018

    Steven Weisz

    William Pitt

    (917) 670-6339

    2 in this area

    59 Total Sales

    Steven Weisz
    Section Image
  • Maggie Merelle

    Seller Co-Listing Agent in 2018

    Maggie Merelle

    William Pitt

    (413) 717-0717

    4 in this area

    66 Total Sales

    Maggie Merelle
    Section Image
  • Paul Harsch

    Buyer's Agent in 2018

    Paul Harsch

    HARSCH ASSOCIATES

    (413) 458-4444

    76 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

Not Listed for Sale

Detached

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.