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] => 1221 [1] => BARNSTABLE [2] => MA [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1221 LocID: BARNSTABLE Region: MA State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1221 Igate: njhud LocID: 1221 Region: BARNSTABLE 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 = 1221 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] => 1221 [1] => BARNSTABLE [2] => MA [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1221 LocID: BARNSTABLE Region: MA State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1221 Igate: njhud LocID: 1221 Region: BARNSTABLE 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 = 1221 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] => 1221 [1] => BARNSTABLE [2] => MA [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1221 LocID: BARNSTABLE Region: MA State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1221 Igate: njhud LocID: 1221 Region: BARNSTABLE 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 = 1221 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
|
Barnstable
| Mashpee, Massachusetts
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Mashpee, Barnstable, Massachusetts
Displaying 11 to 20 of 134 Properties (0 foreclosures)
Realty Executives Cape Cod
$2,742,957
5
bd /
5
ba /
4,805
sqft
14 Azalea Lane
Mashpee
,
Massachusetts
02649
Southworth Willowbend RE, LLC
$2,695,000
4
bd /
3
ba /
4,371
sqft
16 Willow Circle
Mashpee
,
Massachusetts
02649
Southworth Willowbend RE, LLC
$2,525,000
4
bd /
4
ba /
4,371
sqft
15 Willow Circle
Mashpee
,
Massachusetts
02649
Compass Massachusetts, LLC
$2,525,000
4
bd /
3
ba /
5,797
sqft
326 Willowbend Drive
Mashpee
,
Massachusetts
02649
New Seabury Sotheby's International Realty
$2,495,000
4
bd /
3
ba /
1,456
sqft
149 Popponesset Island Road
Mashpee
,
Massachusetts
02649
Priscilla Stolba R E
$2,495,000
4
bd /
3
ba /
3,310
sqft
34 Quaker Run Road
Mashpee
,
Massachusetts
02649
Southworth Willowbend RE, LLC
$2,395,000
4
bd /
4
ba /
3,992
sqft
63 The Heights
Mashpee
,
Massachusetts
02649
Compass Massachusetts, LLC
$2,199,000
6
bd /
3
ba /
4,112
sqft
130 Pimlico Pond Road
Mashpee
,
Massachusetts
02649
New Seabury Sotheby's International Realty
$2,195,000
3
bd /
2
ba /
1,854
sqft
8 Taffrail Way
Mashpee
,
Massachusetts
02649
Compass Massachusetts, LLC
$2,100,000
3
bd /
2
ba /
2,701
sqft
101 Willowbend Drive
Mashpee
,
Massachusetts
02649
«
‹
1
2
3
4
›
»
Cities In BARNSTABLE, MA
Barnstable
Brewster
Buzzards Bay
Cataumet
Centerville
Chatham
Cotuit
Cummaquid
Dennis
Dennis Port
East Dennis
East Falmouth
East Orleans
East Sandwich
Eastham
Falmouth
Forestdale
Harwich
Harwich Port
Hyannis
Hyannis Port
Marstons Mills
Mashpee
Monument Beach
North Chatham
North Eastham
North Falmouth
North Truro
Orleans
Osterville
Pocasset
Provincetown
Sagamore
Sagamore Beach
Sandwich
Silver Beach
South Chatham
South Dennis
South Harwich
South Orleans
South Wellfleet
South Yarmouth
Truro
Wellfleet
West Barnstable
West Chatham
West Dennis
West Falmouth
West Harwich
West Hyannisport
West Yarmouth
Woods Hole
Yarmouth Port
mashpee
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => barnstable [3] => MA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: barnstable State: MA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: barnstable 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 = 1221 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;
Dennis Reardon
ASCII
Cape and Islands Realty Advisors
work
Call Today!
:
(508) 274-2805
I'm interested in properties in BARNSTABLE, MA
1840606
1840606
0
Contact Me
USHUD.com on the Go!