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] => 678 [1] => RANDOLPH [2] => IL [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 678 LocID: RANDOLPH Region: IL State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 678 Igate: njhud LocID: 678 Region: RANDOLPH 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 = 678 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] => 678 [1] => RANDOLPH [2] => IL [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 678 LocID: RANDOLPH Region: IL State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 678 Igate: njhud LocID: 678 Region: RANDOLPH 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 = 678 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] => 678 [1] => RANDOLPH [2] => IL [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 678 LocID: RANDOLPH Region: IL State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 678 Igate: njhud LocID: 678 Region: RANDOLPH 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 = 678 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
|
Randolph
| Red Bud, Illinois
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Red Bud, Randolph, Illinois
Displaying 1 to 10 of 10 Properties (0 foreclosures)
Keller Williams Marquee
$75,000
2
bd /
1
ba /
925
sqft
322 Short Street
Red Bud
,
Illinois
62278
Keller Williams Pinnacle
$600,000
2
bd /
2
ba /
2,579
sqft
10116 Brickey Road
Red Bud
,
Illinois
62278
RE/MAX Preferred
$347,000
3
bd /
3
ba /
2,816
sqft
1018 Thomas Drive
Red Bud
,
Illinois
62278
eXp Realty
$325,000
3
bd /
3
ba /
3,641
sqft
415 East Market Street
Red Bud
,
Illinois
62278
Strano & Associates
$325,000
6
bd /
3
ba /
3,933
sqft
7 Pioneer Lane
Red Bud
,
Illinois
62278
Worth Clark Realty
$275,000
3
bd /
1
ba /
2,096
sqft
225 South Main
Red Bud
,
Illinois
62278
eXp Realty
$210,000
4
bd /
2
ba /
1,800
sqft
318 Charles St
Red Bud
,
Illinois
62278
eXp Realty
$180,000
4
bd /
1
ba /
1,392
sqft
217 North Fillmore Street
Red Bud
,
Illinois
62278
Southern Illinois Realty, LLC
$140,000
--
bd /
0
ba /
--
sqft
52 Beck Road
Red Bud
,
Illinois
62278
Strano & Associates
$100,000
3
bd /
2
ba /
1,676
sqft
312 Van Buren Street
Red Bud
,
Illinois
62278
Cities In RANDOLPH, IL
Baldwin
Chester
Coulterville
Ellis Grove
Evansville
Menard
Modoc
Percy
Prairie Du Rocher
Red Bud
Rockwood
Sparta
Steeleville
Tilden
Walsh
red bud
USHUD.com on the Go!