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] => 2979 [1] => GREENBRIER [2] => WV [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2979 LocID: GREENBRIER Region: WV State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2979 Igate: njhud LocID: 2979 Region: GREENBRIER 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 = 2979 AND i.igate IN ('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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2979 [1] => GREENBRIER [2] => WV [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2979 LocID: GREENBRIER Region: WV State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2979 Igate: njhud LocID: 2979 Region: GREENBRIER 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 = 2979 AND i.igate IN ('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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2979 [1] => GREENBRIER [2] => WV [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2979 LocID: GREENBRIER Region: WV State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2979 Igate: njhud LocID: 2979 Region: GREENBRIER 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 = 2979 AND i.igate IN ('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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
West Virginia (WV) Foreclosure Listings
|
Greenbrier
| Rainelle, West Virginia
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Rainelle, Greenbrier, West Virginia
Displaying 1 to 10 of 18 Properties (0 foreclosures)
Grist Real Estate Associates, Inc
$270,000
3
bd /
1
ba /
1,718
sqft
39638 Midland Trl
Rainelle
,
West Virginia
25962
Coldwell Banker Stuart and Watts Real Estate
$169,000
--
bd /
2
ba /
2,500
sqft
308 Main St
Rainelle
,
West Virginia
25962
Fathom Realty, LLC
$160,000
3
bd /
2
ba /
1,344
sqft
1585 Sewell St S
Rainelle
,
West Virginia
25962
Coldwell Banker Stuart and Watts Real Estate
$150,000
3
bd /
1
ba /
1,500
sqft
421 9th St
Rainelle
,
West Virginia
25962
Home Style Realty & Design
$149,000
3
bd /
2
ba /
1,682
sqft
1747 S Sewell St
Rainelle
,
West Virginia
25962
EXIT ELEVATION REALTY
$139,000
3
bd /
2
ba /
1,200
sqft
340 Horton Avenue East
Rainelle
,
West Virginia
25962
Grist Real Estate Associates, Inc
$130,000
2
bd /
2
ba /
--
sqft
218 11th St
Rainelle
,
West Virginia
25962
EXIT ELEVATION REALTY
$123,000
3
bd /
2
ba /
1,170
sqft
1759 Sewell St S
Rainelle
,
West Virginia
25962
Country Road Realty, LLC
$122,500
3
bd /
1
ba /
972
sqft
170 Twenty-fourth St
Rainelle
,
West Virginia
25962
EXIT ELEVATION REALTY
$120,000
--
bd /
0
ba /
--
sqft
506 Main Street
Rainelle
,
West Virginia
25962
«
‹
1
2
›
»
Cities In GREENBRIER, WV
Asbury
Caldwell
Charmco
Crawley
Fairlea
Frankford
Grassy Meadows
Leslie
Lewisburg
Maxwelton
Quinwood
Rainelle
Renick
Ronceverte
Rupert
Smoot
White Sulphur Springs
Williamsburg
rainelle
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => greenbrier [3] => WV [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: greenbrier State: WV Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: greenbrier State: WV 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 = 2979 AND i.igate IN ('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 = '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 GREENBRIER, WV
18234
18234
0
Contact Me
USHUD.com on the Go!