$459,000 ($203.28 per sqft)

Est. Mortgage $2,231/mo *

Call Text Schedule Tour Request More Information

Open House Schedule

Recently Renovated 3 bedroom Ranch in desirable Sheffield. 5 minute drive to GB, 2 minute drive to downtown Sheffield. Two apartments. New roof, New Septic! Rental potential, mother-daughter living!

05/22/2026
2:00 PM to 3:30 PM
Google calendar
Other calendars

689 N Main St, Sheffield, MA, 01257

View larger map Directions

3 beds

2 Full baths

1957

Ranch

2,258 sqft

OPEN HOUSE: Friday, May 22nd 2:00pm-3:30pm Completely renovated and exceptionally versatile, this spacious 3-bedroom ranch is located in desirable Sheffield, MA. Set on a .50-acre commercially zoned lot just a 5 minute drive to downtown Great Barrington, the property offers outstanding live/work, investment, or business potential. The 2,258 sq. ft. main residence features 3 spacious bedrooms, a large new kitchen, full bath, washer/dryer, and garage. A brand-new adjoining apartment includes a beautifully finished kitchen with granite countertops, full bath, washer/dryer, and private backyard access deal for rental income, extended family, Airbnb, or professional office use. Additional updates include a new 3-bedroom septic system and new roof.

Status:

Active

Type:

Multi-family

Units:

Zoning:

Business, Multi

Garage:

1-car Detached

Heating:

Electric, Forced Air, Multizone, Boiler

Energy Features:

Doors, Roof, Windows

Basement:

Other

Parking:

Garaged

Lot Size:

21780

Acreage:

0.5

Est. Taxes:

$3,209

Construction

Wood Frame, Wood

Utilities

Cable Available, Fiber Optic Avail

Lot Description:

Paved Drive, Irregular Shape

View Description:

Distant, Seasonal

Amenities:

Fenced-Partially, Landscaped, Patio, Trash Private, Curbside Recycling, Mature Landscaping, Cable Avail, High Speed Wiring, Inlaw/ Guest Qtrs, Jet Tub, Pets Allowed, Vaulted Ceilings

Elementary School:

Undermountain

Middle School:

Mount Everett

High School:

Mount Everett

Days on Market:

Appliances:

Washer, Refrigerator, Range, Microwave, Dryer, Dishwasher, Cooktop, Built-In Electric Oven

MLS #:

249626

Community Info

School Info

Walk Score

Mass Transit

Yelp

Similar Properties

$415,000

8 beds

4 baths

4,080 sqft

133-135 Brown Ave, Holyoke, MA, 01040

$500,000

5 beds

2 baths

2,179 sqft

88-90 Perry Street, Lowell, (Belvidere), MA, 01852

Price Reduced!

$449,000

8 beds

4 baths

2,657 sqft

180 Center St, Lee, (South Lee), MA, 01238

$419,000

6 beds

3 baths

2,553 sqft

1022-1024 Hampden St, Holyoke, MA, 01040

$499,900

4 beds

2.5 baths

1,788 sqft

189 Spruce St, Leominster, MA, 01453

$469,900

5 beds

2 baths

2,275 sqft

30 4th Avenue, Lowell, (Pawtucketville), MA, 01854

Price Reduced!

$449,900

4 beds

2 baths

1,964 sqft

41 Pearl St, #1-2, Great Barrington, MA, 01230

$465,000

8 beds

3.5 baths

2,347 sqft

18 Harrison Ave, Holyoke, MA, 01040

$419,000

7 beds

4.5 baths

4,682 sqft

312 South St, Pittsfield, MA, 01201

$499,900

3 beds

2 baths

1,792 sqft

83 Fairhaven Rd, Mattapoisett, MA, 02739

$479,000

3 beds

3 baths

1,765 sqft

107 S Main St, Sheffield, MA, 01257

$474,900

2,000 sqft

9 Dudley Street, Leominster, MA, 01453

$449,900

5 beds

3 baths

2,056 sqft

16 Washington Ave, Holyoke, MA, 01040

$425,000

3 beds

2 baths

3,038 sqft

137 Housatonic St, Lenox, MA, 01240

$489,000

6 beds

3 baths

2,789 sqft

49-51 Bowdoin St, Lawrence, (South Lawrence), MA, 01843

$499,000

6 beds

2 baths

2,909 sqft

24-26 Cady St, Lowell, MA, 01852

New or Coming Soon Properties

New Listing!

$499,000

4 beds

2 baths

2,470 sqft

85 Garfield Ave, Easthampton, MA, 01027

New Listing!

$449,000

6 beds

3 baths

2,400 sqft

109-111 Brown Ave, Holyoke, MA, 01040

$499,000

4 beds

2 baths

2,615 sqft

108 School St, New Bedford, (Center), MA, 02740

New Listing!

$449,900

8 beds

3 baths

3,496 sqft

18 Wendell Pl, Springfield, MA, 01105

New Listing!

$465,000

5 beds

2 baths

2,476 sqft

15 Mcdonald Street, Spencer, MA, 01562

New Listing!

$449,000

6 beds

2 baths

1,594 sqft

89 Oak Street, Fall River, MA, 02720

New Listing!

$479,900

6 beds

2.5 baths

2,064 sqft

47 Winter St, Southbridge, MA, 01550

New Listing!

$474,900

4 beds

2 baths

2,653 sqft

15 Winter St., Leominster, MA, 01453

New Listing!

$429,900

11 beds

4 baths

3,901 sqft

8-12 Hall Pl, Pittsfield, MA, 01201

New Listing!

$448,000

4 beds

2 baths

1,450 sqft

98 Cross St, Southbridge, MA, 01550

New Listing!

$485,000

5 beds

3 baths

2,643 sqft

32 Main St, Spencer, MA, 01562

New Listing!

$500,000

3 beds

2 baths

1690 Herring Brook Road, Eastham, MA, 02642

New Listing!

$469,000

5 beds

3 baths

3,083 sqft

93 Chapin St, Southbridge, MA, 01550

New Listing!

$499,000

7 beds

5 baths

3,604 sqft

2143-2145 Northampton St, Holyoke, MA, 01040

New Listing!

$499,900

4 beds

2 baths

1,840 sqft

7 Whitin Avenue, Northbridge, (Whitinsville), MA, 01588

New Listing!

$425,000

5 beds

4 baths

3,250 sqft

$459,000 ($203.28 per sqft)

Open House Schedule

689 N Main St, Sheffield, MA, 01257

Community Info

School Info

Walk Score

Mass Transit

Yelp

Similar Properties

$415,000

133-135 Brown Ave, Holyoke, MA, 01040

$500,000

88-90 Perry Street, Lowell, (Belvidere), MA, 01852

$449,000

180 Center St, Lee, (South Lee), MA, 01238

$419,000

1022-1024 Hampden St, Holyoke, MA, 01040

$499,900

189 Spruce St, Leominster, MA, 01453

$469,900

30 4th Avenue, Lowell, (Pawtucketville), MA, 01854

$449,900

41 Pearl St, #1-2, Great Barrington, MA, 01230

$465,000

18 Harrison Ave, Holyoke, MA, 01040

$419,000

312 South St, Pittsfield, MA, 01201

$499,900

83 Fairhaven Rd, Mattapoisett, MA, 02739

$479,000

107 S Main St, Sheffield, MA, 01257

$474,900

9 Dudley Street, Leominster, MA, 01453

$449,900

16 Washington Ave, Holyoke, MA, 01040

$425,000

137 Housatonic St, Lenox, MA, 01240

$489,000

49-51 Bowdoin St, Lawrence, (South Lawrence), MA, 01843

$499,000

24-26 Cady St, Lowell, MA, 01852

New or Coming Soon Properties

$499,000

85 Garfield Ave, Easthampton, MA, 01027

$449,000

109-111 Brown Ave, Holyoke, MA, 01040

$499,000

108 School St, New Bedford, (Center), MA, 02740

$449,900

18 Wendell Pl, Springfield, MA, 01105

$465,000

15 Mcdonald Street, Spencer, MA, 01562

$449,000

89 Oak Street, Fall River, MA, 02720

$479,900

47 Winter St, Southbridge, MA, 01550

$474,900

15 Winter St., Leominster, MA, 01453

$429,900

8-12 Hall Pl, Pittsfield, MA, 01201

$448,000

98 Cross St, Southbridge, MA, 01550

$485,000

32 Main St, Spencer, MA, 01562

$500,000

1690 Herring Brook Road, Eastham, MA, 02642

$469,000

93 Chapin St, Southbridge, MA, 01550

$499,000

2143-2145 Northampton St, Holyoke, MA, 01040

$499,900

7 Whitin Avenue, Northbridge, (Whitinsville), MA, 01588

$425,000

53 Union St., Athol, MA, 01331

689 N Main St, Sheffield, MA, 01257

Your Raveis Experience

Your best can only get better...