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
| Multiple Cities
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Barnstable, Massachusetts
Displaying 11 to 20 of 1292 Properties (1 foreclosures)
Beachfront Realty
$999,000
2
bd /
2
ba /
737
sqft
30 Alden Street
Provincetown
,
Massachusetts
02657
Today Real Estate
$999,000
3
bd /
2
ba /
2,459
sqft
2 Maxwell Lane
Sandwich
,
Massachusetts
02563
Premier Commercial
$998,000
8
bd /
4
ba /
2,869
sqft
9 Pond Road
Truro
,
Massachusetts
02666
Foran Realty
$997,000
2
bd /
1
ba /
1,264
sqft
235 Pierce Road
Eastham
,
Massachusetts
02642
Berkshire Hathaway HomeServices Robert Paul Properties
$9,950,000
5
bd /
4
ba /
7,157
sqft
25 Oyster Way
Osterville
,
Massachusetts
02655
Christie's International Real Estate Atlantic Brokerage
$995,000
3
bd /
3
ba /
2,027
sqft
2955 Main Street
Barnstable
,
Massachusetts
02630
Kinlin Grover Compass
$995,000
4
bd /
4
ba /
3,628
sqft
16 Weatherdeck Drive
Bourne
,
Massachusetts
02532
Gibson Sotheby's International Realty
$995,000
--
bd /
0
ba /
--
sqft
0 The Channel Way
Brewster
,
Massachusetts
02631
ERA Cape Real Estate, LLC
$995,000
3
bd /
3
ba /
2,080
sqft
10 A P Newcomb Road
Brewster
,
Massachusetts
02631
Compass Massachusetts, LLC
$995,000
2
bd /
2
ba /
2,934
sqft
16 Quinns Way
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
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!