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] => 1232 [1] => PLYMOUTH (County) [2] => MA [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1232 LocID: PLYMOUTH (County) Region: MA State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1232 Igate: njhud LocID: 1232 Region: PLYMOUTH (County) 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 = 1232 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1232 [1] => PLYMOUTH (County) [2] => MA [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1232 LocID: PLYMOUTH (County) Region: MA State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1232 Igate: njhud LocID: 1232 Region: PLYMOUTH (County) 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 = 1232 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1232 [1] => PLYMOUTH (County) [2] => MA [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1232 LocID: PLYMOUTH (County) Region: MA State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1232 Igate: njhud LocID: 1232 Region: PLYMOUTH (County) 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 = 1232 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Massachusetts (MA) Foreclosure Listings
|
Plymouth (County)
| Kingston, Massachusetts
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Kingston, Plymouth (County), Massachusetts
Displaying 1 to 7 of 7 Properties (0 foreclosures)
Keller Williams Realty Signature Properties
$995,000
3
bd /
2
ba /
1,370
sqft
33 Rocky Nook Ave
Kingston
,
Massachusetts
02364
RE/MAX Platinum
$869,900
3
bd /
2
ba /
3,400
sqft
53 Nobadeer Cir
Kingston
,
Massachusetts
02364
Keller Williams Realty Signature Properties
$849,900
3
bd /
2
ba /
3,132
sqft
37 Higgins Rd
Kingston
,
Massachusetts
02364
Keller Williams Realty
$649,900
3
bd /
2
ba /
1,548
sqft
4 Tall Timbers Ln
Kingston
,
Massachusetts
02364
RE/MAX Platinum
$365,000
2
bd /
1
ba /
1,412
sqft
21 Bayberry Lane
Kingston
,
Massachusetts
02364
RE/MAX Platinum
$1,700,000
--
bd /
0
ba /
--
sqft
62 - 70a Summer St
Kingston
,
Massachusetts
02364
Keller Williams Realty Signature Properties
$1,675,000
6
bd /
3
ba /
5,767
sqft
299 Country Club Way
Kingston
,
Massachusetts
02364
Cities In PLYMOUTH (County), MA
Abington
Accord
Brant Rock
Bridgewater
Brockton
Bryantville
Carver
Duxbury
East Bridgewater
East Wareham
Elmwood
Green Harbor
Greenbush
Halifax
Hanover
Hanson
Hingham
Hull
Humarock
Kingston
Lakeville
Manomet
Marion
Marshfield
Marshfield Hills
Mattapoisett
Middleboro
Minot
Monponsett
North Carver
North Marshfield
North Pembroke
North Scituate
Norwell
Ocean Bluff
Onset
Pembroke
Plymouth
Plympton
Rochester
Rockland
Scituate
South Carver
Wareham
West Bridgewater
West Wareham
White Horse Beach
Whitman
kingston
USHUD.com on the Go!