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 ('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] => 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 ('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] => 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 ('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
|
Barnstable
| Hyannis, Massachusetts
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Hyannis, Barnstable, Massachusetts
Displaying 1 to 10 of 40 Properties (0 foreclosures)
Margo & Company
$975,000
5
bd /
3
ba /
3,070
sqft
25 Ripple Cove Road
Hyannis
,
Massachusetts
02601
Seaport Village Realty
$879,900
3
bd /
3
ba /
1,326
sqft
6 Estey Avenue
Hyannis
,
Massachusetts
02601
Premier Commercial
$849,000
--
bd /
0
ba /
3,092
sqft
294 Main Street
Hyannis
,
Massachusetts
02601
Kinlin Grover Compass
$849,000
--
bd /
0
ba /
4,800
sqft
426-428 Main St
Hyannis
,
Massachusetts
02601
Greer Real Estate, LLC
$775,000
3
bd /
2
ba /
2,512
sqft
80 Old Colony Road
Hyannis
,
Massachusetts
02601
Seaport Village Realty
$729,900
--
bd /
0
ba /
3,462
sqft
307 Falmouth Road
Hyannis
,
Massachusetts
02601
Premier Commercial
$72,000
--
bd /
0
ba /
3,595
sqft
235 Ocean Street
Hyannis
,
Massachusetts
02601
Cape Cod Real Estate Group
$699,000
2
bd /
3
ba /
3,886
sqft
554 Strawberry Hill Road
Hyannis
,
Massachusetts
02601
Cape Harbor Realty
$695,000
3
bd /
2
ba /
1,741
sqft
31 Daybreak Lane
Hyannis
,
Massachusetts
02601
Griffin Realty Group
$650
--
bd /
0
ba /
5,400
sqft
1436 Iyannough Road
Hyannis
,
Massachusetts
02601
«
‹
1
2
3
›
»
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
hyannis
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 ('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;
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!