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] => 3141 [1] => LAKE (COUNTY SOUTH) [2] => IL [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3141 LocID: LAKE (COUNTY SOUTH) Region: IL State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3141 Igate: njhud LocID: 3141 Region: LAKE (COUNTY SOUTH) State: IL 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 = 3141 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3141 [1] => LAKE (COUNTY SOUTH) [2] => IL [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3141 LocID: LAKE (COUNTY SOUTH) Region: IL State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3141 Igate: njhud LocID: 3141 Region: LAKE (COUNTY SOUTH) State: IL 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 = 3141 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3141 [1] => LAKE (COUNTY SOUTH) [2] => IL [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3141 LocID: LAKE (COUNTY SOUTH) Region: IL State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3141 Igate: njhud LocID: 3141 Region: LAKE (COUNTY SOUTH) State: IL 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 = 3141 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Illinois (IL) Foreclosure Listings
|
Lake (County South)
| Wauconda, Illinois
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Wauconda, Lake (County South), Illinois
Displaying 1 to 10 of 14 Properties (0 foreclosures)
RE/MAX Plaza
$735,000
--
bd /
0
ba /
--
sqft
435 Barrington Road
Wauconda
,
Illinois
60084
Troy Realty Ltd
$699,000
--
bd /
0
ba /
--
sqft
26068 N Barrington Road
Wauconda
,
Illinois
60084
Homesmart Connect LLC
$525,000
4
bd /
2
ba /
2,402
sqft
2550 Coneflower Court
Wauconda
,
Illinois
60084
Keller Williams Realty Ptnr,LL
$498,000
3
bd /
2
ba /
1,800
sqft
26181 N Anderson Road
Wauconda
,
Illinois
60084
RE/MAX Suburban
$474,900
4
bd /
3
ba /
2,632
sqft
2717 Moraine Valley Road
Wauconda
,
Illinois
60084
RE/MAX At Home
$400,000
3
bd /
2
ba /
2,317
sqft
2860 Fieldbrook Avenue
Wauconda
,
Illinois
60084
New Concept Realty
$379,000
--
bd /
0
ba /
2,982
sqft
316 S Main Street S
Wauconda
,
Illinois
60084
RE/MAX Plaza
$378,000
--
bd /
0
ba /
--
sqft
431 Barrington Road
Wauconda
,
Illinois
60084
RE/MAX Suburban
$349,900
2
bd /
2
ba /
1,463
sqft
910 Sheridan Drive
Wauconda
,
Illinois
60084
Chase Real Estate LLC
$344,700
3
bd /
2
ba /
1,248
sqft
400 High Street
Wauconda
,
Illinois
60084
«
‹
1
2
›
»
Cities In LAKE (COUNTY SOUTH), IL
Buffalo Grove
Deerfield
Fort Sheridan
Grayslake
Great Lakes
Highland Park
Highwood
Lake Bluff
Lake Forest
Lake Zurich
Libertyville
Lincolnshire
Mundelein
Round Lake
Vernon Hills
Wauconda
wauconda
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => lake-county-south [3] => IL [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: lake-county-south State: IL Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: lake-county-south State: IL 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 = 3141 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Larry Lazar
ASCII
Charles Rutenberg Realty
cell
Mobile
:
(312) 933-7822
I'm interested in properties in LAKE (COUNTY SOUTH), IL
1826615
1826615
0
Contact Me
USHUD.com on the Go!