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] => 2913 [1] => AUGUSTA-STAUNTON-WAYNESBORO [2] => VA [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2913 LocID: AUGUSTA-STAUNTON-WAYNESBORO Region: VA State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2913 Igate: njhud LocID: 2913 Region: AUGUSTA-STAUNTON-WAYNESBORO State: VA 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 = 2913 AND i.igate IN ('nmhud','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 = 'nmhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2913 [1] => AUGUSTA-STAUNTON-WAYNESBORO [2] => VA [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2913 LocID: AUGUSTA-STAUNTON-WAYNESBORO Region: VA State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2913 Igate: njhud LocID: 2913 Region: AUGUSTA-STAUNTON-WAYNESBORO State: VA 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 = 2913 AND i.igate IN ('nmhud','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 = 'nmhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2913 [1] => AUGUSTA-STAUNTON-WAYNESBORO [2] => VA [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2913 LocID: AUGUSTA-STAUNTON-WAYNESBORO Region: VA State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2913 Igate: njhud LocID: 2913 Region: AUGUSTA-STAUNTON-WAYNESBORO State: VA 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 = 2913 AND i.igate IN ('nmhud','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 = 'nmhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Virginia (VA) Foreclosure Listings
|
Augusta-Staunton-Waynesboro
| Multiple Cities
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Augusta-Staunton-Waynesboro, Virginia
Displaying 1 to 10 of 463 Properties (1 foreclosures)
Massanutten Realty
FORECLOSURE
$199,900
3
bd /
2
ba /
1,485
sqft
200 Wild Turkey Ln
Crimora
,
Virginia
24431
KELLER WILLIAMS COMMONWEALTH
$999,000
8
bd /
4
ba /
3,780
sqft
1325 W Main St
Waynesboro
,
Virginia
22980
KELLER WILLIAMS COMMONWEALTH
$999,000
6
bd /
1
ba /
2,097
sqft
1407 W Broad St
Waynesboro
,
Virginia
22980
KELLER WILLIAMS COMMONWEALTH
$999,000
6
bd /
4
ba /
3,227
sqft
605 S Wayne Ave
Waynesboro
,
Virginia
22980
AUGUSTA REALTY GROUP
$999,000
--
bd /
0
ba /
5,117
sqft
625 Lew Dewitt Blvd
Waynesboro
,
Virginia
22980
REAL ESTATE PLUS
$99,900
--
bd /
0
ba /
--
sqft
Lot 37a1 Rifes Ford Rd
Verona
,
Virginia
24482
TRIANGLE REALTORS
$998,000
--
bd /
0
ba /
--
sqft
0 Lifecore Dr
Fishersville
,
Virginia
22939
PREMIER PROPERTIES
$99,500
--
bd /
0
ba /
--
sqft
833 Bells Ln
Staunton
,
Virginia
24401
Funkhouser Real Estate Group
$990,000
5
bd /
3
ba /
3,673
sqft
71 First St
Fishersville
,
Virginia
22939
REAL ESTATE PLUS
$99,000
--
bd /
0
ba /
--
sqft
Lot 10 Rifes Ford Rd
Verona
,
Virginia
24482
«
‹
1
2
3
›
»
Cities In AUGUSTA-STAUNTON-WAYNESBORO, VA
Augusta Springs
Churchville
Craigsville
Crimora
Deerfield
Fishersville
Fort Defiance
Greenville
Lyndhurst
Middlebrook
Mint Spring
Mount Sidney
Mount Solon
New Hope
Staunton
Steeles Tavern
Stuarts Draft
Swoope
Verona
Waynesboro
West Augusta
Weyers Cave
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => augusta-staunton-waynesboro [3] => VA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: augusta-staunton-waynesboro State: VA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: augusta-staunton-waynesboro State: VA 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 = 2913 AND i.igate IN ('nmhud','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 = 'nmhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Sherri Kondash
ASCII
Kline May Realty
work
Call Today!
:
(540) 810-2793
I'm interested in properties in AUGUSTA-STAUNTON-WAYNESBORO, VA
1842605
1842605
0
Contact Me
USHUD.com on the Go!