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] => 1234 [1] => WORCESTER [2] => MA [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1234 LocID: WORCESTER Region: MA State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1234 Igate: njhud LocID: 1234 Region: WORCESTER 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 = 1234 AND i.igate IN ('wahud','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 = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1234 [1] => WORCESTER [2] => MA [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1234 LocID: WORCESTER Region: MA State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1234 Igate: njhud LocID: 1234 Region: WORCESTER 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 = 1234 AND i.igate IN ('wahud','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 = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1234 [1] => WORCESTER [2] => MA [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1234 LocID: WORCESTER Region: MA State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1234 Igate: njhud LocID: 1234 Region: WORCESTER 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 = 1234 AND i.igate IN ('wahud','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 = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Massachusetts (MA) Foreclosure Listings
|
Worcester
| Clinton, Massachusetts
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Clinton, Worcester, Massachusetts
Displaying 1 to 10 of 13 Properties (0 foreclosures)
RE/MAX Journey
$8
--
bd /
0
ba /
25,000
sqft
89 Parker St
Clinton
,
Massachusetts
01510
RE/MAX Journey
$725,000
--
bd /
0
ba /
--
sqft
291-293 Berlin St
Clinton
,
Massachusetts
01510
RE/MAX Journey
$725,000
2
bd /
1
ba /
884
sqft
293 Berlin St
Clinton
,
Massachusetts
01510
RE/MAX Journey
$6
--
bd /
0
ba /
75,000
sqft
75 Green St
Clinton
,
Massachusetts
01510
RE/MAX Journey
$595,000
--
bd /
0
ba /
1,794
sqft
678 Main St
Clinton
,
Massachusetts
01510
Keller Williams Realty North Central
$574,000
2
bd /
2
ba /
2,232
sqft
503 Linwood Ct
Clinton
,
Massachusetts
01510
RE/MAX Journey
$5,500
--
bd /
0
ba /
5,650
sqft
184 Stone St
Clinton
,
Massachusetts
01510
RE/MAX Journey
$549,900
10
bd /
3
ba /
4,094
sqft
50,50 1/2 Parker Street
Clinton
,
Massachusetts
01510
Keller Williams Realty Boston Northwest
$499,000
2
bd /
2
ba /
2,001
sqft
803 Ledgewood Way
Clinton
,
Massachusetts
01510
RE/MAX Signature Properties
$399,900
2
bd /
2
ba /
1,267
sqft
2205 Briarwood Village
Clinton
,
Massachusetts
01510
«
‹
1
2
›
»
Cities In WORCESTER, MA
Ashburnham
Athol
Auburn
Baldwinville
Barre
Berlin
Blackstone
Bolton
Boylston
Brookfield
Charlton
Charlton City
Charlton Depot
Cherry Valley
Clinton
Douglas
Dudley
East Brookfield
East Princeton
East Templeton
Fayville
Fiskdale
Fitchburg
Gardner
Gilbertville
Grafton
Hardwick
Harvard
Holden
Hopedale
Hubbardston
Jefferson
Lancaster
Leicester
Leominster
Linwood
Lunenburg
Manchaug
Mendon
Milford
Millbury
Millville
New Braintree
North Brookfield
North Grafton
North Oxford
North Uxbridge
Northborough
Northbridge
Oakham
Oxford
Paxton
Petersham
Princeton
Rochdale
Royalston
Rutland
Shrewsbury
South Barre
South Grafton
South Lancaster
Southborough
Southbridge
Spencer
Sterling
Still River
Sturbridge
Sutton
Templeton
Upton
Uxbridge
Warren
Webster
West Boylston
West Brookfield
West Millbury
West Warren
Westborough
Westminster
Wheelwright
Whitinsville
Winchendon
Winchendon Springs
Worcester
clinton
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => worcester [3] => MA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: worcester State: MA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: worcester 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 = 1234 AND i.igate IN ('wahud','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 = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Dawn Szczygiel
ASCII
1 Worcester Homes
work
Call Today!
:
(508) 330-7344
I'm interested in properties in WORCESTER, MA
1824136
1824136
0
Contact Me
USHUD.com on the Go!