Your browser does not support the video tag.
Knowledge Center
Email Alerts
Mortgage/Credit Help
FAQ
Reviews
Professionals
Search
Refine Search
Beds:
Any
1 +
2 +
3 +
4 +
5 +
6 +
7 +
8 +
9 +
10 +
Baths:
Any
1 +
2 +
3 +
4 +
5 +
6 +
7 +
8 +
9 +
10 +
Property Type:
Any
Conventional
Foreclosure
Price Range:
to
Refine
DEBUG FN args: Array ( [0] => 1222 [1] => BERKSHIRE [2] => MA [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1222 LocID: BERKSHIRE Region: MA State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1222 Igate: njhud LocID: 1222 Region: BERKSHIRE State: MA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2
QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1222 AND i.igate IN ('cahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1222 [1] => BERKSHIRE [2] => MA [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1222 LocID: BERKSHIRE Region: MA State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1222 Igate: njhud LocID: 1222 Region: BERKSHIRE State: MA Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2
QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1222 AND i.igate IN ('cahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1222 [1] => BERKSHIRE [2] => MA [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1222 LocID: BERKSHIRE Region: MA State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1222 Igate: njhud LocID: 1222 Region: BERKSHIRE State: MA Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2
QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1222 AND i.igate IN ('cahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Massachusetts (MA) Foreclosure Listings
|
Berkshire
| Great Barrington, Massachusetts
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Great Barrington, Berkshire, Massachusetts
Displaying 1 to 10 of 44 Properties (0 foreclosures)
WILLIAM PITT SOTHEBY'S INTERNATIONAL REALTY, LENOX
$6,850,000
5
bd /
4
ba /
3,474
sqft
77 Seekonk Cross Rd
Great Barrington
,
Massachusetts
01230
William Pitt Sotheby's Int'l
$6,850,000
2
bd /
4
ba /
3,474
sqft
77 Seekonk Cross Road
Great Barrington
,
Massachusetts
01230
LANDVEST, INC.
$4,500,000
4
bd /
6
ba /
7,000
sqft
6 Seekonk Cross Rd
Great Barrington
,
Massachusetts
01230
WILLIAM PITT SOTHEBY'S INTERNATIONAL REALTY
$3,900,000
2
bd /
2
ba /
12,207
sqft
685 South Egremont Rd
Great Barrington
,
Massachusetts
01230
WILLIAM PITT SOTHEBY'S INTERNATIONAL REALTY
$3,500,000
5
bd /
5
ba /
9,008
sqft
300 Alcott Rd
Great Barrington
,
Massachusetts
01230
Birch Properties
$2,750,000
2
bd /
3
ba /
13,350
sqft
410 Park St
Great Barrington
,
Massachusetts
01236
Berkshire Property Agents LLC
$2,400,000
4
bd /
4
ba /
3,478
sqft
3 Berkshire Heights Rd
Great Barrington
,
Massachusetts
01230
Berkshire Property Agents LLC
$2,195,000
6
bd /
6
ba /
5,000
sqft
37-39 Dresser Ave
Great Barrington
,
Massachusetts
01230
WILLIAM PITT SOTHEBY'S INTERNATIONAL REALTY
$1,875,000
4
bd /
4
ba /
4,156
sqft
9 Round Hill Rd
Great Barrington
,
Massachusetts
01230
WHEELER & TAYLOR REALTY CO., INC.
$1,800,000
3
bd /
3
ba /
2,900
sqft
21 Kalliste Hill
Great Barrington
,
Massachusetts
01230
«
‹
1
2
3
›
»
Cities In BERKSHIRE, MA
Adams
Ashley Falls
Becket
Berkshire
Cheshire
Dalton
Drury
East Otis
Glendale
Great Barrington
Hinsdale
Housatonic
Lanesboro
Lee
Lenox
Lenox Dale
Mill River
Monterey
North Adams
North Egremont
Otis
Pittsfield
Richmond
Sandisfield
Savoy
Sheffield
South Egremont
South Lee
Southfield
Stockbridge
Tyringham
West Stockbridge
Williamstown
Windsor
great barrington
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => berkshire [3] => MA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: berkshire State: MA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: berkshire State: MA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1
QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1222 AND i.igate IN ('cahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Amy Wood
ASCII
Steepleview Realty
work
Call Today!
:
(413) 652-4184
I'm interested in properties in BERKSHIRE, MA
1842574
1842574
0
Contact Me
USHUD.com on the Go!