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] => 871 [1] => POTTAWATTAMIE [2] => IA [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 871 LocID: POTTAWATTAMIE Region: IA State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 871 Igate: njhud LocID: 871 Region: POTTAWATTAMIE State: IA 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 = 871 AND i.igate IN ('nyhud','usahud','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 = 'nyhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 871 [1] => POTTAWATTAMIE [2] => IA [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 871 LocID: POTTAWATTAMIE Region: IA State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 871 Igate: njhud LocID: 871 Region: POTTAWATTAMIE State: IA 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 = 871 AND i.igate IN ('nyhud','usahud','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 = 'nyhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 871 [1] => POTTAWATTAMIE [2] => IA [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 871 LocID: POTTAWATTAMIE Region: IA State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 871 Igate: njhud LocID: 871 Region: POTTAWATTAMIE State: IA 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 = 871 AND i.igate IN ('nyhud','usahud','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 = 'nyhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Iowa (IA) Foreclosure Listings
|
Pottawattamie
| Council Bluffs, Iowa
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Council Bluffs, Pottawattamie, Iowa
Displaying 1 to 10 of 44 Properties (1 foreclosures)
CORY GORDON
FORECLOSURE
$66,100
3
bd /
1
ba /
--
sqft
715 Stutsman St
Council Bluffs
,
Iowa
51503
Better Homes and Gardens Real Estate The Good Life
$1,295,000
5
bd /
4
ba /
5,498
sqft
21085 Abbey Road
Council Bluffs
,
Iowa
51503
NextHome in the Bluffs
$725,000
4
bd /
1
ba /
4,008
sqft
4618 N Shore Drive
Council Bluffs
,
Iowa
51501
NextHome, Inc
$725,000
4
bd /
4
ba /
4,008
sqft
4618 North Shore Drive
Council Bluffs
,
Iowa
51501
United Country Menke Auction &
$624,000
4
bd /
3
ba /
2,512
sqft
7345 Stafford Drive
Council Bluffs
,
Iowa
51503
REAL
$540,000
6
bd /
6
ba /
--
sqft
543 Mill Street
Council Bluffs
,
Iowa
51503
Better Homes & Gardens Real Estate The Good Life G
$539,000
4
bd /
3
ba /
3,561
sqft
15068 Pinehurst Drive
Council Bluffs
,
Iowa
51503
Key Real Estate
$495,000
3
bd /
2
ba /
2,084
sqft
23023 Hillside Lane
Council Bluffs
,
Iowa
51503
Better Homes & Gardens Real Estate The Good Life G
$420,000
3
bd /
3
ba /
2,238
sqft
19 Kingsridge Drive N.
Council Bluffs
,
Iowa
51503
Better Homes & Gardens Real Estate The Good Life G
$410,000
5
bd /
2
ba /
2,344
sqft
2306 Rolling Hills Loop
Council Bluffs
,
Iowa
51503
«
‹
1
2
3
›
»
Cities In POTTAWATTAMIE, IA
Avoca
Carson
Carter Lake
Council Bluffs
Crescent
Hancock
Honey Creek
Macedonia
Mc Clelland
Minden
Neola
Oakland
Shelby
Treynor
Underwood
Walnut
council bluffs
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => pottawattamie [3] => IA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: pottawattamie State: IA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: pottawattamie State: IA 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 = 871 AND i.igate IN ('nyhud','usahud','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 = 'nyhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Sarah Smith
ASCII
Generic Real Estate
work
Cell
:
(241) 555-1812
work
Office
:
(241) 555-1776
I'm interested in properties in POTTAWATTAMIE, IA
18234
18234
0
Contact Me
USHUD.com on the Go!