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
| Gardner, Massachusetts
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Gardner, Worcester, Massachusetts
Displaying 1 to 10 of 11 Properties (1 foreclosures)
CENTURY 21 MASELLE & ASSOCIATES
FORECLOSURE
$469,900
2
bd /
1
ba /
1,974
sqft
303 Parker St
Gardner
,
Massachusetts
01440
Keller Williams Realty North Central
$95,000
5
bd /
3
ba /
2,907
sqft
56 Pearl St
Gardner
,
Massachusetts
01440
Keller Williams Realty
$749,000
--
bd /
0
ba /
24,583
sqft
115 Coburn Ave
Gardner
,
Massachusetts
01440
Keller Williams Realty Boston Northwest
$385,000
3
bd /
2
ba /
1,509
sqft
48 Winslow Street
Gardner
,
Massachusetts
01440
Keller Williams Realty North Central
$360,000
4
bd /
2
ba /
2,036
sqft
57 Jay St
Gardner
,
Massachusetts
01440
Keller Williams Realty North Central
$350,000
3
bd /
1
ba /
960
sqft
181 Dyer St
Gardner
,
Massachusetts
01440
RE/MAX Vision
$349,000
3
bd /
1
ba /
1,084
sqft
434 Temple St
Gardner
,
Massachusetts
01440
Keller Williams Realty North Central
$299,000
3
bd /
1
ba /
1,350
sqft
370 Parker Street
Gardner
,
Massachusetts
01440
Keller Williams Realty North Central
$258,900
2
bd /
1
ba /
1,024
sqft
29-2 Olde Colonial Drive
Gardner
,
Massachusetts
01440
Keller Williams Realty North Central
$230,000
--
bd /
0
ba /
6,316
sqft
176 West St
Gardner
,
Massachusetts
01440
«
‹
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
gardner
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!