690 North Main St, Sheffield, MA 01257

$530,000
Property Type: Commercial Baths: 1 Square Footage: 3,280 Lot Size (sq. ft.): 36,155 Status: Closed
Current Price: $530,000 List Date: 7/19/2024 Last Modified: 5/09/2025

Overview

Description

This stunning property boasts a perfect blend of modern features and preserved post and beam architecture to maintain its timeless historic charm. Meticulously renovated and used by a master craftsman, it boasts a host of eco-friendly features ranging from solar panels, to offset electricity usage to radiant heating in the ground floor concrete. In addition, the floors have been insulated with HI-R insulation, the 2x6 walls are insulated with R-35, roof with R-49 and the basement exterior walls insulated with open cell spray foam. All insulation was installed on the exterior of the shell to preserve the interior sheathing and look of the original barn.

Supplements: The space also includes an insulated upstairs loft area that has an electric material lift to move material from the main floor to the loft. The entire building has been lifted and reinforced with new concrete footings as well as newly poured concrete floor with radiant heat adding extra space and character to the property. Everything has been repl ...

Listing Details MLS# 243971

Location, Tax & Legal

Registry
South Registry
Street #
690
Street Direction
North
Street Name
Main
Street Ext
St
State/Province
MA
Postal Code
01257
Taxes
2278.33
Tax Year
2024
Page
151
Concessions
NA

Contract Information

Original List Price
575000
Limited Service
No
Agent Interest
None

General Property Description

Realtor.COM Type
Commercial
Sq Ft Liv Apx
3280
Total Full Baths
Yes
Total Bathrooms
Yes
Parking Spaces Type
Off Street
Year Built Apx
1790
Year Built Source
Assessor
Yr Blt Description
Renovated Since
Lot Square Footage
36155
Acres Apx
0.83
Lot Size SqFt
36155
Sq Ft Source
Other
Betterment
No

Status Change Info

Status Change Date
2025-05-09
Under Contract Date
2025-03-05
Contingent
Yes
Contingent Remarks
Inspection
Sold Date
2025-05-01

Building Info

Ceiling Height
12'
Electric Meters #
Yes
Floors#
3
Heating Sys #
Yes
Hot Wtr Sys #
Yes
OH Door Height
6'

Bathrooms

# Full Bath
Yes

More Information

Remarks & Misc

Directions
Take Rt. 7 approx. 4.5 miles south of Rotary South of Downtown Great Barrington. Property on the left side.
Marketing/Headline
Offering both style and functionality for the energy conscious property/business owner.

Basement

Concrete Floor
Yes
Finished-Partially
Yes
Full
Yes
Interior Access
Yes
Walkout
Yes

Exterior Amenities

Bus-Public
Yes
Fieldstone Walls
Yes
Garden
Yes

Fuel

Propane
Yes
Solar
Yes

Hot Water

Propane
Yes
Solar
Yes

Interior Amenities

Emp Break Room
Yes
Emp Kitchen
Yes
Freight Elevator
Yes

Lead Paint

Unk
Yes

Lot Description

Irregular Shape
Yes

Business Type

Manufacturing
Yes
Mixed
Yes
Professional/Office
Yes
Restaurant
Yes
Retail
Yes
Warehouse
Yes

Underground Oil Tank

Unk
Yes

Features

Attic
Yes
Basement
Yes

Water

Well
Yes

Right to Farm Comm

Yes
Yes

Sewer

Private
Yes

Electric Type

200 Amp
Yes
Circuit Breaker
Yes
Other
Yes

Energy Features

Insulated Doors
Yes
Insulated Windows
Yes
ProgramThermostat
Yes
Solar Features
Yes

Construction

2x6 Walls
Yes
Concrete
Yes
Log
Yes
Masonry
Yes
Plank
Yes
Post/Beam
Yes
Wood Frame
Yes

Condition

Recently Renovated
Yes

Roof

Asphalt
Yes

Heat/Cool

Forced Air
Yes
Hot Water
Yes
Multizone
Yes
Radiant
Yes

Zoning

Agricultural
Yes
Business
Yes
Multi
Yes
Residential
Yes

Insulation

Rigid
Yes

Seller Disc

No
Yes

Possession

Close Of Escrow
Yes

Financing

Conventional
Yes

Property Features

Business Type: Manufacturing; Mixed; Professional/Office; Restaurant; Retail; Warehouse Underground Oil Tank: Unk Water: Well Sewer: Private Right to Farm Comm: Yes Condition: Recently Renovated Lot Description: Irregular Shape Electric Type: 200 Amp; Circuit Breaker; Other Interior Amenities: Emp Break Room; Emp Kitchen; Freight Elevator Exterior Amenities: Bus-Public; Fieldstone Walls; Garden Energy Features: Insulated Doors; Insulated Windows; ProgramThermostat; Solar Features Construction: 2x6 Walls; Concrete; Log; Masonry; Plank; Post/Beam; Wood Frame Roof: Asphalt Basement: Concrete Floor; Finished-Partially; Full; Interior Access; Walkout Features: Attic Fuel: Propane; Solar Hot Water: Propane; Solar Insulation: Rigid Lead Paint: Unk Zoning: Agricultural; Business; Multi; Residential Seller Disc: No Financing: Conventional Possession: Close Of Escrow

Documents

Listing Office: STONE HOUSE PROPERTIES, LLC
Listing Agent: Timothy Gallagher
Last Updated: May - 09 - 2025
Information from the Berkshire County Board of Realtors, Inc. or it's Multiple Listing Service. Site contains live data. Information herein believed to be accurate, but not warranted. All right, title and interest in the exclusively listed property information represented on this website was created, maintained and copyrighted by the Berkshire County Board of Realtors® and in copyrights therein, hall at all times remain vested in the Berkshire County Board of Realtors®. As a Participant of theBerkshire County Multiple Listing Service, this company was granted a lease to use this information in accordance with all rules and regulations of the Service. This information is being provided for Consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties Consumers may be interested in purchasing.