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] => 364 [1] => MANATEE (SOUTH) [2] => FL [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 364 LocID: MANATEE (SOUTH) Region: FL State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 364 Igate: njhud LocID: 364 Region: MANATEE (SOUTH) State: FL 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 = 364 AND i.igate IN ('flhud','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 = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 364 [1] => MANATEE (SOUTH) [2] => FL [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 364 LocID: MANATEE (SOUTH) Region: FL State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 364 Igate: njhud LocID: 364 Region: MANATEE (SOUTH) State: FL 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 = 364 AND i.igate IN ('flhud','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 = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 364 [1] => MANATEE (SOUTH) [2] => FL [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 364 LocID: MANATEE (SOUTH) Region: FL State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 364 Igate: njhud LocID: 364 Region: MANATEE (SOUTH) State: FL 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 = 364 AND i.igate IN ('flhud','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 = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Florida (FL) Foreclosure Listings
|
Manatee (South)
| Holmes Beach, Florida
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Holmes Beach, Manatee (South), Florida
Displaying 1 to 10 of 55 Properties (0 foreclosures)
Coldwell Banker
$18,750,000
5
bd /
7
ba /
7,163
sqft
104 Sunset Lane
Holmes Beach
,
Florida
34217
Coldwell Banker
$9,995,000
6
bd /
7
ba /
5,921
sqft
535 70th Street
Holmes Beach
,
Florida
34217
Sato Real Estate, Inc.
$7,950,000
3
bd /
4
ba /
3,325
sqft
95 52nd Street
Holmes Beach
,
Florida
34217
Sato Real Estate, Inc.
$5,900,000
5
bd /
7
ba /
4,101
sqft
726 Key Royale Drive
Holmes Beach
,
Florida
34217
Sato Real Estate, Inc.
$5,750,000
4
bd /
5
ba /
3,418
sqft
212 Haverkos Court
Holmes Beach
,
Florida
34217
Sato Real Estate, Inc.
$5,495,000
5
bd /
5
ba /
3,282
sqft
731 Key Royale Drive
Holmes Beach
,
Florida
34217
Island Real Estate of Anna Maria Island, Inc
$4,630,000
5
bd /
5
ba /
2,636
sqft
203 N Harbor Drive
Holmes Beach
,
Florida
34217
Keller Williams on the Water Sarasota
$4,490,000
5
bd /
5
ba /
2,784
sqft
3702 5th Avenue
Holmes Beach
,
Florida
34217
ADDvantage Real Estate
$3,950,000
--
bd /
0
ba /
6,002
sqft
3707 Gulf Drive
Holmes Beach
,
Florida
34217
Pineywoods Realty LLC
$3,850,000
6
bd /
7
ba /
3,566
sqft
502 Key Royale Drive
Holmes Beach
,
Florida
34217
«
‹
1
2
3
›
»
Cities In MANATEE (SOUTH), FL
Anna Maria
Bradenton
Bradenton Beach
Cortez
Holmes Beach
Laurel
Myakka City
North Port
Oneco
Sarasota
Tallevast
Terra Ceia
holmes beach
Local Mortgage Pro
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => manatee-south [3] => FL [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: manatee-south State: FL Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: manatee-south State: FL Experttype: lender 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 = 364 AND i.igate IN ('flhud','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 = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Joe Spellman NMLS# 2142845
ASCII
Family First Mortgage USA empowered by NEXA
work
Call Today!
:
(863) 559-8288
I'm interested in properties in MANATEE (SOUTH), FL
1829662
1829662
0
Contact Me
USHUD.com on the Go!