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 ('nwhud','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 = 'nwhud', 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 ('nwhud','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 = 'nwhud', 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 ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Massachusetts (MA) Foreclosure Listings
|
Worcester
| Westborough, Massachusetts
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Westborough, Worcester, Massachusetts
Displaying 1 to 7 of 7 Properties (0 foreclosures)
KW Pinnacle MetroWest
$935,000
3
bd /
2
ba /
2,715
sqft
27 Nash St
Westborough
,
Massachusetts
01581
Keller Williams Realty Boston Northwest
$575,000
3
bd /
2
ba /
1,874
sqft
5 Robin Circle
Westborough
,
Massachusetts
01581
KW Pinnacle MetroWest
$425,000
3
bd /
1
ba /
864
sqft
20 Endicott Drive
Westborough
,
Massachusetts
01581
RE/MAX Executive Realty
$19
--
bd /
0
ba /
--
sqft
134 Flanders Rd
Westborough
,
Massachusetts
01581
RE/MAX Executive Realty
$18
--
bd /
0
ba /
--
sqft
176 E Main St
Westborough
,
Massachusetts
01581
RE/MAX Executive Realty
$18
--
bd /
0
ba /
40,000
sqft
69 Milk St
Westborough
,
Massachusetts
01581
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
westborough
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 ('nwhud','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 = 'nwhud', 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!