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] => 2993 [1] => MC DOWELL [2] => WV [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2993 LocID: MC DOWELL Region: WV State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2993 Igate: njhud LocID: 2993 Region: MC DOWELL State: WV 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 = 2993 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] => 2993 [1] => MC DOWELL [2] => WV [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2993 LocID: MC DOWELL Region: WV State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2993 Igate: njhud LocID: 2993 Region: MC DOWELL State: WV 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 = 2993 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] => 2993 [1] => MC DOWELL [2] => WV [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2993 LocID: MC DOWELL Region: WV State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2993 Igate: njhud LocID: 2993 Region: MC DOWELL State: WV 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 = 2993 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
|
West Virginia (WV) Foreclosure Listings
|
Mc Dowell
| War, West Virginia
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
War, Mc Dowell, West Virginia
Displaying 1 to 8 of 8 Properties (0 foreclosures)
BERKSHIRE HATHAWAY HOMESERVICES FOUR SEASONS SELECT
$89,000
3
bd /
2
ba /
1,147
sqft
555 Cove Circle
War
,
West Virginia
24892
RIVERMONT REALTY GROUP, LLC
$52,000
--
bd /
0
ba /
--
sqft
00 Cove St
War
,
West Virginia
24892
PAYNE REAL ESTATE & INVESTMENT
$40,000
3
bd /
1
ba /
1,466
sqft
14091 Rocket Boys Dr.
War
,
West Virginia
24892
RIVERMONT REALTY GROUP, LLC
$15,500
--
bd /
0
ba /
--
sqft
00 Yukon River Rd
War
,
West Virginia
24892
RIVERMONT REALTY GROUP, LLC
$9,000
--
bd /
0
ba /
--
sqft
00 Shaft Hollow Rd
War
,
West Virginia
24892
RIVERMONT REALTY GROUP, LLC
$7,900
--
bd /
0
ba /
--
sqft
00 Excelsior Bottom Rd
War
,
West Virginia
24892
BERKSHIRE HATHAWAY HOMESERVICES FOUR SEASONS SELECT
$5,600
--
bd /
0
ba /
--
sqft
5 Miners City
War
,
West Virginia
24892
Cities In MC DOWELL, WV
Anawalt
Avondale
Bartley
Berwind
Big Sandy
Bradshaw
Cucumber
Davy
Eckman
Elbert
Elkhorn
Gary
Hensley
Iaeger
Isaban
Jenkinjones
Jolo
Kimball
Kyle
Maybeury
Mohawk
Newhall
Northfork
Pageton
Panther
Paynesville
Premier
Raysal
Roderfield
Squire
Switchback
Thorpe
War
Warriormine
Welch
Wilcoe
war
USHUD.com on the Go!