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] => 1045 [1] => HARLAN [2] => KY [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1045 LocID: HARLAN Region: KY State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1045 Igate: njhud LocID: 1045 Region: HARLAN State: KY 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 = 1045 AND i.igate IN ('azhud','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 = 'azhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1045 [1] => HARLAN [2] => KY [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1045 LocID: HARLAN Region: KY State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1045 Igate: njhud LocID: 1045 Region: HARLAN State: KY 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 = 1045 AND i.igate IN ('azhud','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 = 'azhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1045 [1] => HARLAN [2] => KY [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1045 LocID: HARLAN Region: KY State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1045 Igate: njhud LocID: 1045 Region: HARLAN State: KY 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 = 1045 AND i.igate IN ('azhud','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 = 'azhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Kentucky (KY) Foreclosure Listings
|
Harlan
| Evarts, Kentucky
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Evarts, Harlan, Kentucky
Displaying 1 to 10 of 14 Properties (0 foreclosures)
Hayden Outdoors Real Estate
$350,000
--
bd /
0
ba /
--
sqft
0 Highway 38
Evarts
,
Kentucky
40828
CENTURY 21 Advantage Realty
$225,000
4
bd /
3
ba /
2,102
sqft
549 Kildav Loop Road
Evarts
,
Kentucky
40828
WEICHERT REALTORS - Ford Brothers
$199,500
3
bd /
3
ba /
1,646
sqft
115 Kelly Street
Evarts
,
Kentucky
40828
Turn Key Realty
$160,000
--
bd /
0
ba /
--
sqft
120 South Main Street
Evarts
,
Kentucky
40828
Forever Home
$116,900
3
bd /
2
ba /
1,298
sqft
3 James Court
Evarts
,
Kentucky
40828
Forever Home
$112,000
3
bd /
1
ba /
1,636
sqft
101 Dizney
Evarts
,
Kentucky
40828
WEICHERT REALTORS - Ford Brothers
$109,000
3
bd /
2
ba /
1,508
sqft
117 Kelly Street
Evarts
,
Kentucky
40828
Forever Home
$75,000
5
bd /
3
ba /
2,821
sqft
31 Husky Lane
Evarts
,
Kentucky
40828
Century 21 Virginia Wilder Real Estate
$54,900
2
bd /
1
ba /
696
sqft
41 Cochran Road
Evarts
,
Kentucky
40828
Coldwell Banker Bisceglia Realty & Auction Co
$40,000
3
bd /
1
ba /
1,344
sqft
103 Stewart Street
Evarts
,
Kentucky
40828
«
‹
1
2
›
»
Cities In HARLAN, KY
Ages Brookside
Baxter
Benham
Big Laurel
Bledsoe
Cawood
Closplint
Coalgood
Coldiron
Cranks
Cumberland
Dayhoit
Evarts
Grays Knob
Gulston
Harlan
Holmes Mill
Kenvir
Lejunior
Loyall
Lynch
Mary Alice
Pathfork
Putney
Totz
Wallins Creek
evarts
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => harlan [3] => KY [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: harlan State: KY Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: harlan State: KY 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 = 1045 AND i.igate IN ('azhud','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 = 'azhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Sarah Smith (Fabian Test Account)
ASCII
Better Homes and Gardens Real Estate - Nicholson Group
cell
Mobile
:
(241) 555-1812
Beware of the Bear - Look I am a Hooman
I'm interested in properties in HARLAN, KY
18234
18234
0
Contact Me
USHUD.com on the Go!