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)
| Marshfield, Massachusetts
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Marshfield, Plymouth (County), Massachusetts
Displaying 1 to 10 of 10 Properties (0 foreclosures)
Keller Williams Realty
$950,000
--
bd /
0
ba /
--
sqft
0 Main
Marshfield
,
Massachusetts
02050
Keller Williams Realty Signature Properties
$949,000
4
bd /
2
ba /
1,874
sqft
8 Knox St
Marshfield
,
Massachusetts
02050
Kinlin Grover Compass
$675,000
4
bd /
2
ba /
2,264
sqft
24 Meadowview Street
Marshfield
,
Massachusetts
02050
Keller Williams Elite
$660,000
3
bd /
1
ba /
1,502
sqft
588 Main Street
Marshfield
,
Massachusetts
02050
Keller Williams Realty Boston South West
$549,000
3
bd /
1
ba /
1,344
sqft
53 Jefferson Ave
Marshfield
,
Massachusetts
02050
RE/MAX Realty Plus
$469,000
3
bd /
1
ba /
1,214
sqft
78 Tower Ave
Marshfield
,
Massachusetts
02050
Keller Williams Realty Signature Properties
$395,000
--
bd /
0
ba /
--
sqft
1024 Forest St.
Marshfield
,
Massachusetts
02050
Keller Williams Realty
$375
--
bd /
0
ba /
1,176
sqft
545 Plain St
Marshfield
,
Massachusetts
02050
Keller Williams Elite
$250,000
--
bd /
0
ba /
--
sqft
0 Ocean St
Marshfield
,
Massachusetts
02050
Keller Williams Realty Signature Properties
$1,499,000
4
bd /
3
ba /
3,356
sqft
308 Ocean Street
Marshfield
,
Massachusetts
02050
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
marshfield
USHUD.com on the Go!