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] => 3215 [1] => PALM BEACH (COUNTY NORTH) [2] => FL [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3215 LocID: PALM BEACH (COUNTY NORTH) Region: FL State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3215 Igate: njhud LocID: 3215 Region: PALM BEACH (COUNTY NORTH) 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 = 3215 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3215 [1] => PALM BEACH (COUNTY NORTH) [2] => FL [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3215 LocID: PALM BEACH (COUNTY NORTH) Region: FL State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3215 Igate: njhud LocID: 3215 Region: PALM BEACH (COUNTY NORTH) 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 = 3215 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3215 [1] => PALM BEACH (COUNTY NORTH) [2] => FL [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3215 LocID: PALM BEACH (COUNTY NORTH) Region: FL State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3215 Igate: njhud LocID: 3215 Region: PALM BEACH (COUNTY NORTH) 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 = 3215 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Florida (FL) Foreclosure Listings
|
Palm Beach (County North)
| Palm Beach, Florida
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Palm Beach, Palm Beach (County North), Florida
Displaying 1 to 10 of 95 Properties (0 foreclosures)
Linda R. Olsson, Inc.
$9,995,000
5
bd /
4
ba /
3,410
sqft
165 Seminole Avenue
Palm Beach
,
Florida
33480
Linda R. Olsson, Inc.
$9,950,000
3
bd /
3
ba /
2,495
sqft
130 Sunrise Avenue
Palm Beach
,
Florida
33480
Sotheby's Intl. Realty, Inc.
$9,500,000
4
bd /
3
ba /
2,877
sqft
274 Monterey Road
Palm Beach
,
Florida
33480
Douglas Elliman (Palm Beach)
$9,500
2
bd /
2
ba /
903
sqft
226 Chilean Avenue
Palm Beach
,
Florida
33480
Douglas Elliman (Palm Beach)
$9,000
2
bd /
2
ba /
804
sqft
223 Atlantic Avenue
Palm Beach
,
Florida
33480
Douglas Elliman (Palm Beach)
$9,000
2
bd /
2
ba /
1,740
sqft
3400 S Ocean Boulevard
Palm Beach
,
Florida
33480
Douglas Elliman (Palm Beach)
$9,000
2
bd /
2
ba /
2,000
sqft
430 Australian Avenue
Palm Beach
,
Florida
33480
Waterfront Properties & Club C
$8,950,000
3
bd /
3
ba /
2,543
sqft
273 List Road
Palm Beach
,
Florida
33480
Partnership Realty Inc.
$8,500
2
bd /
2
ba /
1,498
sqft
3450 S Ocean Boulevard
Palm Beach
,
Florida
33480
Partnership Realty Inc.
$8,500
2
bd /
2
ba /
1,548
sqft
3450 S Ocean Boulevard Boulevard
Palm Beach
,
Florida
33480
«
‹
1
2
3
›
»
Cities In PALM BEACH (COUNTY NORTH), FL
Canal Point
Jupiter
Lake Harbor
North Palm Beach
Pahokee
Palm Beach
Palm Beach Gardens
Wellington
West Palm Beach
palm beach
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => palm-beach-county-north [3] => FL [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: palm-beach-county-north State: FL Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: palm-beach-county-north State: FL 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 = 3215 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Gwen Morgan
ASCII
COLDWELL BANKER
work
Call Today!
:
(561) 308-8669
I'm interested in properties in PALM BEACH (COUNTY NORTH), FL
1840014
1840014
0
Contact Me
USHUD.com on the Go!