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
| Sturbridge, Massachusetts
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Sturbridge, Worcester, Massachusetts
Displaying 1 to 10 of 12 Properties (0 foreclosures)
RE/MAX PROFESSIONAL ASSOCIATES (STURBRIDGE)
$999,900
3
bd /
2
ba /
1,488
sqft
32,33,35 Mt. Dan Road
Sturbridge
,
Massachusetts
01518
RE/MAX PROFESSIONAL ASSOCIATES (STURBRIDGE)
$995,000
7
bd /
5
ba /
5,300
sqft
14 Maple St
Sturbridge
,
Massachusetts
01566
RE/MAX PROFESSIONAL ASSOCIATES (STURBRIDGE)
$979,900
4
bd /
3
ba /
3,200
sqft
29 Whittemore
Sturbridge
,
Massachusetts
01566
RE/MAX PROFESSIONAL ASSOCIATES (STURBRIDGE)
$565,000
3
bd /
3
ba /
2,056
sqft
18 Hall Rd
Sturbridge
,
Massachusetts
01566
RE/MAX PROFESSIONAL ASSOCIATES (STURBRIDGE)
$549,000
4
bd /
4
ba /
3,000
sqft
112 Fiske Hill Rd
Sturbridge
,
Massachusetts
01566
RE/MAX PROFESSIONAL ASSOCIATES (STURBRIDGE)
$533,900
3
bd /
2
ba /
2,539
sqft
66 New Boston Rd
Sturbridge
,
Massachusetts
01566
RE/MAX PROFESSIONAL ASSOCIATES (STURBRIDGE)
$495,000
2
bd /
3
ba /
1,803
sqft
115 Colonial Drive
Sturbridge
,
Massachusetts
01566
RE/MAX PROFESSIONAL ASSOCIATES (STURBRIDGE)
$479,900
3
bd /
3
ba /
1,514
sqft
21 Collette Rd
Sturbridge
,
Massachusetts
01518
RE/MAX PROFESSIONAL ASSOCIATES (STURBRIDGE)
$475,000
4
bd /
3
ba /
2,320
sqft
69 Streeter Rd
Sturbridge
,
Massachusetts
01518
RE/MAX PROFESSIONAL ASSOCIATES (STURBRIDGE)
$365,000
2
bd /
2
ba /
1,791
sqft
34 Betsy Ross Cir
Sturbridge
,
Massachusetts
01566
«
‹
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
sturbridge
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!