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] => 2052 [1] => COLUMBIANA [2] => OH [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2052 LocID: COLUMBIANA Region: OH State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 2052 Region: COLUMBIANA 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 = 2052 AND eai.ishudvalues = 1 AND m.expertType = 'agent' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2052 [1] => COLUMBIANA [2] => OH [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2052 LocID: COLUMBIANA Region: OH State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 2052 Region: COLUMBIANA 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 = 2052 AND eai.ishudvalues = 1 AND m.expertType = 'lender' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2052 [1] => COLUMBIANA [2] => OH [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2052 LocID: COLUMBIANA Region: OH State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 2052 Region: COLUMBIANA 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 = 2052 AND eai.ishudvalues = 1 AND m.expertType = 'other' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Ohio (OH) Foreclosure Listings
|
Columbiana
| Salem, Ohio
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Salem, Columbiana, Ohio
Displaying 1 to 10 of 10 Properties (1 foreclosures)
CENTURY 21 MASELLE & ASSOCIATES
FORECLOSURE
$189,900
5
bd /
2
ba /
--
sqft
14960 Academy Ln
Salem
,
Ohio
44460
Keller Williams Chervenic Rlty
$55,000
--
bd /
0
ba /
--
sqft
Lot 83 Painter Road
Salem
,
Ohio
44460
Keller Williams Chervenic Rlty
$55,000
--
bd /
0
ba /
--
sqft
Lot 84 Painter Road
Salem
,
Ohio
44460
Keller Williams Chervenic Rlty
$55,000
--
bd /
0
ba /
--
sqft
Lot 86 Painter Road
Salem
,
Ohio
44460
Keller Williams Chervenic Rlty
$52,500
--
bd /
0
ba /
--
sqft
Lot 82 Painter Road
Salem
,
Ohio
44460
Keller Williams Chervenic Rlty
$350,000
--
bd /
0
ba /
6,000
sqft
387 S Broadway Avenue
Salem
,
Ohio
44460
Keller Williams Chervenic Rlty
$25,000
--
bd /
0
ba /
--
sqft
691 E 3rd Street
Salem
,
Ohio
44460
Bang Realty
$216,480
4
bd /
2
ba /
3,318
sqft
816 S Lincoln Ave
Salem
,
Ohio
44460
Keller Williams Legacy Group Realty
$1,869
--
bd /
0
ba /
--
sqft
2789 E State Street
Salem
,
Ohio
44460
Keller Williams Capital Ptnrs
$125,000
2
bd /
1
ba /
912
sqft
1995 Oak Street
Salem
,
Ohio
44460
Cities In COLUMBIANA, OH
Columbiana
East Liverpool
East Palestine
East Rochester
Elkton
Hanoverton
Homeworth
Kensington
Leetonia
Lisbon
Negley
New Waterford
North Georgetown
Rogers
Salem
Salineville
Summitville
Washingtonville
Wellsville
West Point
Winona
salem
USHUD.com on the Go!