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
| Wellfleet, Massachusetts
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Wellfleet, Barnstable, Massachusetts
Displaying 21 to 30 of 36 Properties (0 foreclosures)
William Raveis Real Estate & Home Services
$2,500,000
4
bd /
4
ba /
4,228
sqft
195 King Phillip Road
Wellfleet
,
Massachusetts
02667
eXp Realty, LLC
$249,900
1
bd /
1
ba /
644
sqft
210 West Rd C13
Wellfleet
,
Massachusetts
02667
Berkshire Hathaway Home Services Town and Country
$2,350,000
3
bd /
2
ba /
3,356
sqft
20 Catboat Road
Wellfleet
,
Massachusetts
02667
Gibson Sotheby's International Realty
$2,350,000
3
bd /
2
ba /
1,536
sqft
51 9th Street
Wellfleet
,
Massachusetts
02667
RE/MAX Executive Realty
$2,000,000
2
bd /
1
ba /
2,158
sqft
95 Old County Road
Wellfleet
,
Massachusetts
02667
Berkshire Hathaway HomeServices Robert Paul Properties
$1,795,000
5
bd /
5
ba /
4,049
sqft
40 Leilla Rich Drive
Wellfleet
,
Massachusetts
02667
Gibson Sotheby's International Realty
$1,749,000
2
bd /
2
ba /
1,818
sqft
175 Cliff Road
Wellfleet
,
Massachusetts
02667
Gibson Sotheby's International Realty
$1,600,000
4
bd /
2
ba /
2,206
sqft
15 Jason Path
Wellfleet
,
Massachusetts
02667
Kinlin Grover Compass
$1,595,000
3
bd /
2
ba /
3,240
sqft
255 High Toss Road
Wellfleet
,
Massachusetts
02667
Commercial Realty Advisors, Inc.
$1,500,000
--
bd /
0
ba /
4,484
sqft
1035 Cemetery Road
Wellfleet
,
Massachusetts
02667
«
‹
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
wellfleet
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!