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] => 2992 [1] => MASON [2] => WV [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2992 LocID: MASON Region: WV State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2992 Igate: njhud LocID: 2992 Region: MASON 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 = 2992 AND i.igate IN ('cihud','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 = 'cihud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2992 [1] => MASON [2] => WV [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2992 LocID: MASON Region: WV State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2992 Igate: njhud LocID: 2992 Region: MASON 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 = 2992 AND i.igate IN ('cihud','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 = 'cihud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2992 [1] => MASON [2] => WV [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2992 LocID: MASON Region: WV State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2992 Igate: njhud LocID: 2992 Region: MASON 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 = 2992 AND i.igate IN ('cihud','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 = 'cihud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
West Virginia (WV) Foreclosure Listings
|
Mason
| Gallipolis Ferry, West Virginia
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Gallipolis Ferry, Mason, West Virginia
Displaying 1 to 9 of 9 Properties (0 foreclosures)
The Angie Zimmerman Realty Group
$80,000
2
bd /
1
ba /
980
sqft
11022 Redmond Ridge Road
Gallipolis Ferry
,
West Virginia
25550
The Angie Zimmerman Realty Group
$74,000
--
bd /
0
ba /
--
sqft
7272 Sand Fork Road
Gallipolis Ferry
,
West Virginia
25515
Village Realty Group, Inc.
$459,000
5
bd /
3
ba /
3,816
sqft
1177 Split Rock Drive
Gallipolis Ferry
,
West Virginia
25515
The Angie Zimmerman Realty Group
$389,900
--
bd /
0
ba /
--
sqft
1216 Rancho Vista Drive
Gallipolis Ferry
,
West Virginia
25515
The Angie Zimmerman Realty Group
$38,000
--
bd /
0
ba /
--
sqft
1313 Pleasant Ridge Road
Gallipolis Ferry
,
West Virginia
25515
The Angie Zimmerman Realty Group
$285,000
--
bd /
0
ba /
--
sqft
0 Rancho Vista Drive
Gallipolis Ferry
,
West Virginia
25515
The Angie Zimmerman Realty Group
$219,000
2
bd /
2
ba /
1,348
sqft
19157 Huntington Road
Gallipolis Ferry
,
West Virginia
25515
The Angie Zimmerman Realty Group
$169,900
3
bd /
1
ba /
1,344
sqft
208 Caudill Lane
Gallipolis Ferry
,
West Virginia
25515
The Angie Zimmerman Realty Group
$15,000
--
bd /
0
ba /
--
sqft
0 Redmond Ridge Road
Gallipolis Ferry
,
West Virginia
25515
Cities In MASON, WV
Apple Grove
Ashton
Gallipolis Ferry
Glenwood
Hartford
Henderson
Leon
Letart
Mason
Mount Alto
New Haven
Point Pleasant
Southside
West Columbia
gallipolis ferry
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => mason [3] => WV [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: mason State: WV Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: mason 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 = 2992 AND i.igate IN ('cihud','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 = 'cihud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Sarah Smith
ASCII
Generic Real Estate
work
Cell
:
(241) 555-1812
work
Office
:
(241) 555-1776
I'm interested in properties in MASON, WV
18234
18234
0
Contact Me
USHUD.com on the Go!