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] => 655 [1] => MACOUPIN [2] => IL [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 655 LocID: MACOUPIN Region: IL State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 655 Igate: njhud LocID: 655 Region: MACOUPIN 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 = 655 AND i.igate IN ('ilhud','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 = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 655 [1] => MACOUPIN [2] => IL [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 655 LocID: MACOUPIN Region: IL State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 655 Igate: njhud LocID: 655 Region: MACOUPIN 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 = 655 AND i.igate IN ('ilhud','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 = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 655 [1] => MACOUPIN [2] => IL [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 655 LocID: MACOUPIN Region: IL State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 655 Igate: njhud LocID: 655 Region: MACOUPIN 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 = 655 AND i.igate IN ('ilhud','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 = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Illinois (IL) Foreclosure Listings
|
Macoupin
| Girard, Illinois
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Girard, Macoupin, Illinois
Displaying 1 to 10 of 12 Properties (0 foreclosures)
Campo Realty, Inc.
$750,000
--
bd /
0
ba /
76,000
sqft
115 E Mound Street
Girard
,
Illinois
62640
RE/MAX Professionals
$74,900
--
bd /
0
ba /
5,368
sqft
118 N 1st Street
Girard
,
Illinois
62640
Coldwell Banker Brown Realtors
$59,900
3
bd /
1
ba /
800
sqft
109 North Mckinley
Girard
,
Illinois
62640
RE/MAX Professionals
$54,000
2
bd /
1
ba /
905
sqft
109 N Wilson Street
Girard
,
Illinois
62640
RE/MAX Professionals
$425,000
3
bd /
3
ba /
3,360
sqft
31162 Deer Creek Road
Girard
,
Illinois
62640
Re/Max Alliance
$31,680
2
bd /
1
ba /
1,664
sqft
620 W Madison St Street
Girard
,
Illinois
62640
RE/MAX Professionals
$274,000
3
bd /
3
ba /
2,818
sqft
820 W North Street
Girard
,
Illinois
62640
RE/MAX Professionals
$244,900
3
bd /
2
ba /
2,225
sqft
612 N 3rd Street
Girard
,
Illinois
62640
RE/MAX Professionals
$214,900
2
bd /
2
ba /
1,757
sqft
30384 Cypress Lane
Girard
,
Illinois
62640
Firm Foundations Realty
$20,000
--
bd /
0
ba /
--
sqft
403 S 4th Street
Girard
,
Illinois
62640
«
‹
1
2
›
»
Cities In MACOUPIN, IL
Benld
Brighton
Bunker Hill
Carlinville
Chesterfield
Eagarville
Gillespie
Girard
Hettick
Modesto
Mount Olive
Nilwood
Palmyra
Piasa
Sawyerville
Scottville
Shipman
Staunton
Virden
Wilsonville
girard
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => macoupin [3] => IL [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: macoupin State: IL Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: macoupin 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 = 655 AND i.igate IN ('ilhud','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 = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Nikki Machin
ASCII
The Real Estate Group LLC
work
Call Today!
:
(217) 816-6818
I'm interested in properties in MACOUPIN, IL
1841351
1841351
0
Contact Me
USHUD.com on the Go!