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 ('azhud','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 = 'azhud', 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 ('azhud','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 = 'azhud', 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 ('azhud','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 = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Massachusetts (MA) Foreclosure Listings
|
Berkshire
| Stockbridge, Massachusetts
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Stockbridge, Berkshire, Massachusetts
Displaying 1 to 10 of 22 Properties (0 foreclosures)
WILLIAM PITT SOTHEBY'S - GT BARRINGTON
$9,950,000
5
bd /
6
ba /
9,339
sqft
7 Prospect Hill Rd
Stockbridge
,
Massachusetts
01262
ROBERTS & ASSOC. REALTY, INC
$695,000
2
bd /
2
ba /
1,610
sqft
176 Old Stockbridge Rd
Stockbridge
,
Massachusetts
01262
BERKSHIRE PROPERTY AGENTS, LLC
$667,000
3
bd /
1
ba /
1,922
sqft
3 Yale Ct
Stockbridge
,
Massachusetts
01262
NOCHER REALTY
$599,900
3
bd /
1
ba /
1,360
sqft
17 Christian Hill Rd
Stockbridge
,
Massachusetts
01262
BERKSHIRE PROPERTY AGENTS, LLC
$570,000
--
bd /
0
ba /
--
sqft
1 Campion Farms Rd
Stockbridge
,
Massachusetts
01262
G. FULS JR. REAL ESTATE CO.
$550,000
--
bd /
0
ba /
--
sqft
Mohawk Lake Rd
Stockbridge
,
Massachusetts
01262
MACCARO REAL ESTATE
$510,000
2
bd /
2
ba /
1,768
sqft
2 Wallace Rd
Stockbridge
,
Massachusetts
01262
BIRCH PROPERTIES
$495,000
4
bd /
2
ba /
1,409
sqft
23 Church St
Stockbridge
,
Massachusetts
01262
LANCE VERMEULEN RE, INC
$450,000
--
bd /
0
ba /
--
sqft
Parcel A&b Glendale Rd
Stockbridge
,
Massachusetts
01262
BIRCH PROPERTIES
$425,000
--
bd /
0
ba /
--
sqft
9 Wheatley Dr
Stockbridge
,
Massachusetts
01262
«
‹
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
stockbridge
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 ('azhud','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 = 'azhud', 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!