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] => 376 [1] => POLK (NORTH) [2] => FL [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 376 LocID: POLK (NORTH) Region: FL State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 376 Region: POLK (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 = 376 AND eai.ishudvalues = 1 AND m.expertType = 'agent' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 376 [1] => POLK (NORTH) [2] => FL [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 376 LocID: POLK (NORTH) Region: FL State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 376 Region: POLK (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 = 376 AND eai.ishudvalues = 1 AND m.expertType = 'lender' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 376 [1] => POLK (NORTH) [2] => FL [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 376 LocID: POLK (NORTH) Region: FL State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 376 Region: POLK (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 = 376 AND eai.ishudvalues = 1 AND m.expertType = 'other' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Florida (FL) Foreclosure Listings
|
Polk (North)
| Winter Haven, Florida
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Winter Haven, Polk (North), Florida
Displaying 1 to 10 of 281 Properties (3 foreclosures)
Allstate Realty Services, LLC
FORECLOSURE
$389,950
3
bd /
2
ba /
1,616
sqft
1604 Meadow Lane Ne
Winter Haven
,
Florida
33881
DWIGHT HEAD
FORECLOSURE
$389,950
3
bd /
2
ba /
1,638
sqft
1604 Meadow Ln Ne
Winter Haven
,
Florida
33881
Carter Company Realtors
FORECLOSURE
$314,900
3
bd /
2
ba /
1,852
sqft
5850 Forest Ridge Drive
Winter Haven
,
Florida
33881
Smart Realty of Winter Haven LLC
$825,000
4
bd /
4
ba /
3,214
sqft
1250 W Lake Hamilton Drive
Winter Haven
,
Florida
33881
Smart Realty of Winter Haven LLC
$795,000
6
bd /
5
ba /
3,873
sqft
1521 N Lake Howard Drive
Winter Haven
,
Florida
33881
Real Estate Brokers USA, Inc
$730,000
4
bd /
2
ba /
2,424
sqft
547 Sanctuary Boulevard
Winter Haven
,
Florida
33881
Coldwell Banker Real Estate Winter Haven
$550,000
4
bd /
3
ba /
1,770
sqft
2022 Leisure Drive
Winter Haven
,
Florida
33881
eXp Realty LLC
$549,900
3
bd /
3
ba /
3,000
sqft
4 Casarena Court
Winter Haven
,
Florida
33881
Real Broker, LLC.
$535,000
5
bd /
4
ba /
3,186
sqft
107 Broad Street
Winter Haven
,
Florida
33881
LPT Realty, LLC.
$535,000
4
bd /
3
ba /
3,269
sqft
722 Lake Martha Drive Ne
Winter Haven
,
Florida
33881
«
‹
1
2
3
›
»
Cities In POLK (NORTH), FL
Alturas
Auburndale
Bradley
Davenport
Eaton Park
Haines City
Highland City
Homeland
Intercession City
Kathleen
Kissimmee
Lake Alfred
Lake Hamilton
Lake Wales
Lakeland
Loughman
Nichols
Polk City
Waverly
Winter Haven
winter haven
USHUD.com on the Go!