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
| Lunenburg, Massachusetts
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Lunenburg, Worcester, Massachusetts
Displaying 1 to 8 of 8 Properties (0 foreclosures)
Keller Williams Realty North Central
$2,500,000
--
bd /
0
ba /
--
sqft
200-365 Hollis Hill Road
Lunenburg
,
Massachusetts
01462
Keller Williams Realty North Central
$1,100,000
6
bd /
4
ba /
4,845
sqft
24 Leominster Road
Lunenburg
,
Massachusetts
01462
Keller Williams Realty North Central
$759,000
3
bd /
2
ba /
2,475
sqft
313 New West Townsend Road
Lunenburg
,
Massachusetts
01462
Keller Williams Realty North Central
$635,000
3
bd /
2
ba /
2,064
sqft
391 Chase Road
Lunenburg
,
Massachusetts
01462
Keller Williams Realty North Central
$349,900
3
bd /
1
ba /
1,176
sqft
79 Cove Road
Lunenburg
,
Massachusetts
01462
Keller Williams South Watuppa
$272,500
2
bd /
1
ba /
980
sqft
415 New West Townsend Rd
Lunenburg
,
Massachusetts
01462
Keller Williams Realty North Central
$190,000
--
bd /
0
ba /
--
sqft
14 Sunset Avenue
Lunenburg
,
Massachusetts
01462
Keller Williams Realty Boston Northwest
$49,900
--
bd /
0
ba /
--
sqft
781r Page St
Lunenburg
,
Massachusetts
01462
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
lunenburg
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!