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] => 2083 [1] => LOGAN (COUNTY) [2] => OH [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2083 LocID: LOGAN (COUNTY) Region: OH State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2083 Igate: njhud LocID: 2083 Region: LOGAN (COUNTY) State: OH 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 = 2083 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2083 [1] => LOGAN (COUNTY) [2] => OH [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2083 LocID: LOGAN (COUNTY) Region: OH State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2083 Igate: njhud LocID: 2083 Region: LOGAN (COUNTY) State: OH 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 = 2083 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2083 [1] => LOGAN (COUNTY) [2] => OH [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2083 LocID: LOGAN (COUNTY) Region: OH State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2083 Igate: njhud LocID: 2083 Region: LOGAN (COUNTY) State: OH 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 = 2083 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Ohio (OH) Foreclosure Listings
|
Logan (County)
| Russells Point, Ohio
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Russells Point, Logan (County), Ohio
Displaying 1 to 10 of 43 Properties (0 foreclosures)
Zimmerman Realty, Ltd.
$1,000,000
5
bd /
3
ba /
3,871
sqft
7868 Beech Avenue
Russells Point
,
Ohio
43348
Choice Properties Real Estate
$899,000
3
bd /
2
ba /
1,642
sqft
7933 Hickory Avenue
Russells Point
,
Ohio
43348
Delicious Real Estate Group
$679,900
3
bd /
2
ba /
1,908
sqft
7842 Hickory Avenue
Russells Point
,
Ohio
43348
Zimmerman Realty, Ltd.
$679,000
2
bd /
2
ba /
836
sqft
7917 Hickory Avenue
Russells Point
,
Ohio
43348
Choice Properties Real Estate
$679,000
2
bd /
1
ba /
1,045
sqft
7925 Hickory Avenue
Russells Point
,
Ohio
43348
Bell Hankins Realty Group, LLC
$500,000
--
bd /
0
ba /
--
sqft
. Oak Island
Russells Point
,
Ohio
43348
Howard Hanna Real Estate Services
$499,000
--
bd /
0
ba /
2,550
sqft
421 Madison Street
Russells Point
,
Ohio
43348
Howard Hanna Real Estate Services
$499,000
3
bd /
1
ba /
745
sqft
7690 Walnut Street
Russells Point
,
Ohio
43348
Choice Properties Real Estate
$479,900
--
bd /
0
ba /
3,200
sqft
113 E Kress Street
Russells Point
,
Ohio
43348
Choice Properties Real Estate
$449,900
4
bd /
1
ba /
1,350
sqft
7419 Mingo Way
Russells Point
,
Ohio
43348
«
‹
1
2
3
›
»
Cities In LOGAN (COUNTY), OH
Belle Center
Bellefontaine
De Graff
East Liberty
Huntsville
Lakeview
Lewistown
Middleburg
Quincy
Rushsylvania
Russells Point
West Liberty
West Mansfield
Zanesfield
russells point
USHUD.com on the Go!