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] => 3007 [1] => RALEIGH [2] => WV [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3007 LocID: RALEIGH Region: WV State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 3007 Region: RALEIGH 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 = 3007 AND eai.ishudvalues = 1 AND m.expertType = 'agent' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3007 [1] => RALEIGH [2] => WV [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3007 LocID: RALEIGH Region: WV State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 3007 Region: RALEIGH 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 = 3007 AND eai.ishudvalues = 1 AND m.expertType = 'lender' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3007 [1] => RALEIGH [2] => WV [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3007 LocID: RALEIGH Region: WV State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 3007 Region: RALEIGH 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 = 3007 AND eai.ishudvalues = 1 AND m.expertType = 'other' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
West Virginia (WV) Foreclosure Listings
|
Raleigh
| Shady Spring, West Virginia
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Shady Spring, Raleigh, West Virginia
Displaying 1 to 10 of 12 Properties (0 foreclosures)
WV MOUNTAINEER REAL ESTATE
$259,000
3
bd /
3
ba /
1,800
sqft
288 Country Roads Estates
Shady Spring
,
West Virginia
25918
Old Colony of Beckley
$249,900
3
bd /
2
ba /
2,177
sqft
1541 Pluto Road
Shady Spring
,
West Virginia
25918
ALTRUIST REALTY GROUP
$249,900
3
bd /
2
ba /
1,350
sqft
248 Pinewood Drive
Shady Spring
,
West Virginia
25918
EXIT ELEVATION REALTY
$229,000
3
bd /
2
ba /
1,888
sqft
268 Marshall Circle
Shady Spring
,
West Virginia
25918
Bass Sinko Real Estate
$227,000
3
bd /
2
ba /
1,200
sqft
134 Laurel Wood Lane
Shady Spring
,
West Virginia
25918
TIM BERRY REAL ESTATE CO, INC
$225,000
--
bd /
0
ba /
--
sqft
270,272 Mont Phillips Road
Shady Spring
,
West Virginia
25918
EXIT ELEVATION REALTY
$219,900
3
bd /
2
ba /
1,288
sqft
372 Pinewood Drive
Shady Spring
,
West Virginia
25918
TIM BERRY REAL ESTATE CO, INC
$209,999
3
bd /
2
ba /
1,493
sqft
126 1st Street
Shady Spring
,
West Virginia
25918
ALTRUIST REALTY GROUP
$199,900
3
bd /
2
ba /
1,344
sqft
163 Briarwood Drive
Shady Spring
,
West Virginia
25918
Old Colony of Beckley
$169,900
3
bd /
2
ba /
1,911
sqft
318 Briarwood Drive
Shady Spring
,
West Virginia
25918
«
‹
1
2
›
»
Cities In RALEIGH, WV
Arnett
Artie
Beaver
Beckley
Bolt
Bradley
Clear Creek
Coal City
Colcord
Cool Ridge
Crab Orchard
Daniels
Dorothy
Dry Creek
Eccles
Fairdale
Ghent
Glen Daniel
Glen White
Harper
Helen
Josephine
Lanark
Lester
Mabscott
Mac Arthur
Midway
Naoma
Odd
Piney View
Princewick
Prosperity
Raleigh
Rhodell
Rock Creek
Shady Spring
Skelton
Slab Fork
Sophia
Stanaford
Surveyor
White Oak
shady spring
USHUD.com on the Go!