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 ('nvhud','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 = 'nvhud', 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 ('nvhud','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 = 'nvhud', 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 ('nvhud','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 = 'nvhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
West Virginia (WV) Foreclosure Listings
|
Greenbrier
| White Sulphur Springs, West Virginia
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
White Sulphur Springs, Greenbrier, West Virginia
Displaying 1 to 10 of 19 Properties (0 foreclosures)
Grist Real Estate Associates, Inc.
$1,895,000
4
bd /
4
ba /
--
sqft
116 Mountain Laurel Ln
White Sulphur Springs
,
West Virginia
24986
Old Colony, REALTORS®
$1,895,000
4
bd /
4
ba /
2,971
sqft
2025 Village Run Road
White Sulphur Springs
,
West Virginia
24986
Greenbrier Real Estate Service
$630,000
7
bd /
7
ba /
--
sqft
463 W Main St
White Sulphur Springs
,
West Virginia
24986
Greenbrier Real Estate Service
$335,000
4
bd /
4
ba /
--
sqft
447 W Main St
White Sulphur Springs
,
West Virginia
24986
VQ, Inc. dba RE/MAX Vision Quest
$315,000
5
bd /
3
ba /
--
sqft
185 Central Ave
White Sulphur Springs
,
West Virginia
24986
Greenbrier Real Estate Service
$309,000
3
bd /
2
ba /
--
sqft
894 Pleasant Valley Rd
White Sulphur Springs
,
West Virginia
24986
ALTRUIST REALTY GROUP
$279,900
5
bd /
3
ba /
2,288
sqft
110 Schoolhouse Way
White Sulphur Springs
,
West Virginia
24986
Coldwell Banker Stuart and Watts Real Estate
$265,500
4
bd /
2
ba /
--
sqft
614 Greenbrier Ave
White Sulphur Springs
,
West Virginia
24986
Coldwell Banker Stuart and Watts Real Estate
$249,900
3
bd /
3
ba /
--
sqft
114 Rivoire Cir
White Sulphur Springs
,
West Virginia
24986
Dogwood Realty LLC
$249,000
1
bd /
1
ba /
--
sqft
502 Grass Run Rd
White Sulphur Springs
,
West Virginia
24986
«
‹
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
white sulphur springs
USHUD.com on the Go!