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 ('tnhud','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 = 'tnhud', 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 ('tnhud','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 = 'tnhud', 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 ('tnhud','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 = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Massachusetts (MA) Foreclosure Listings
|
Berkshire
| Otis, Massachusetts
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Otis, Berkshire, Massachusetts
Displaying 1 to 10 of 21 Properties (0 foreclosures)
COLDWELL BANKER REALTY WESTFIELD
$899,900
3
bd /
2
ba /
2,049
sqft
24 Evergreen Dr
Otis
,
Massachusetts
01253
WILLIAM PITT SOTHEBY'S - GT BARRINGTON
$799,000
--
bd /
0
ba /
12,424
sqft
1570 North Main Rd
Otis
,
Massachusetts
01253
RED HORSE REAL ESTATE, LLC
$707,500
2
bd /
1
ba /
960
sqft
185 Pine Rd
Otis
,
Massachusetts
01253
WILLIAM PITT SOTHEBY'S - LENOX
$699,000
3
bd /
3
ba /
3,204
sqft
105 Harrington Rd
Otis
,
Massachusetts
01253
LANCE VERMEULEN RE, INC
$545,000
3
bd /
2
ba /
1,642
sqft
20 Deer Run --
Otis
,
Massachusetts
01253
DIGRIGOLI REAL ESTATE
$524,900
3
bd /
2
ba /
2,000
sqft
120 Lands End Dr
Otis
,
Massachusetts
01253
BERKSHIRE HATHAWAY HOMESERVICES REALTY PROFESSIONALS-WESTFIELD
$495,000
3
bd /
1
ba /
1,536
sqft
14 North Ridge St
Otis
,
Massachusetts
01253
RED HORSE REAL ESTATE, LLC
$399,000
3
bd /
1
ba /
640
sqft
245 D'wolfe Dr
Otis
,
Massachusetts
01253
WILLIAM PITT SOTHEBY'S - GT BARRINGTON
$395,000
--
bd /
0
ba /
--
sqft
0-12-28 Werden Rd
Otis
,
Massachusetts
01253
RED HORSE REAL ESTATE, LLC
$334,900
3
bd /
1
ba /
1,152
sqft
18 Ticonderoga Ave
Otis
,
Massachusetts
01253
«
‹
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
otis
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 ('tnhud','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 = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Jim Thurston, Lic#9560840
ASCII
Nocher Realty
work
Call Today!
:
(413) 329-4780
I'm interested in properties in BERKSHIRE, MA
1844343
1844343
0
Contact Me
USHUD.com on the Go!