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
| Osterville, Massachusetts
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Osterville, Barnstable, Massachusetts
Displaying 21 to 30 of 32 Properties (0 foreclosures)
Berkshire Hathaway HomeServices Robert Paul Properties
$2,995,000
4
bd /
3
ba /
3,015
sqft
21 Cockachoiset Lane
Osterville
,
Massachusetts
02655
Kinlin Grover Compass
$2,850,000
5
bd /
3
ba /
3,576
sqft
290 Starboard Lane
Osterville
,
Massachusetts
02655
The Foley Company
$2,695,000
4
bd /
3
ba /
3,478
sqft
100 Meadowlark Lane
Osterville
,
Massachusetts
02655
Barnstable Harbor Realty
$2,599,000
3
bd /
4
ba /
3,290
sqft
201 Old Mill Road
Osterville
,
Massachusetts
02655
Kinlin Grover Compass
$1,595,000
3
bd /
3
ba /
2,923
sqft
22 Felicity Lane
Osterville
,
Massachusetts
02655
SilverStone Capeside Realty Group
$1,400,000
3
bd /
3
ba /
3,182
sqft
35 Waterfield Road
Osterville
,
Massachusetts
02655
Today Real Estate
$1,395,000
4
bd /
3
ba /
2,982
sqft
38 Evans Street
Osterville
,
Massachusetts
02655
Berkshire Hathaway HomeServices Robert Paul Properties
$13,000,000
7
bd /
6
ba /
4,896
sqft
255 Bayberry Way
Osterville
,
Massachusetts
02655
Berkshire Hathaway HomeServices Robert Paul Properties
$12,500,000
8
bd /
4
ba /
4,033
sqft
227 Bridge Street
Osterville
,
Massachusetts
02655
Kinlin Grover Compass
$1,225,000
3
bd /
2
ba /
2,458
sqft
200 Sturbridge Drive
Osterville
,
Massachusetts
02655
«
‹
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
osterville
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!