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] => 2084 [1] => LORAIN [2] => OH [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2084 LocID: LORAIN Region: OH State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2084 Igate: njhud LocID: 2084 Region: LORAIN 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 = 2084 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2084 [1] => LORAIN [2] => OH [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2084 LocID: LORAIN Region: OH State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2084 Igate: njhud LocID: 2084 Region: LORAIN 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 = 2084 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2084 [1] => LORAIN [2] => OH [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2084 LocID: LORAIN Region: OH State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2084 Igate: njhud LocID: 2084 Region: LORAIN 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 = 2084 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Ohio (OH) Foreclosure Listings
|
Lorain
| Columbia Station, Ohio
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Columbia Station, Lorain, Ohio
Displaying 1 to 10 of 10 Properties (0 foreclosures)
Drees Homes Cleveland
$527,900
4
bd /
2
ba /
3,055
sqft
11202 Creek View Way
Columbia Station
,
Ohio
44028
Russell Real Estate Services
$5,250
--
bd /
0
ba /
--
sqft
27102 Royalton Road
Columbia Station
,
Ohio
44028
Drees Homes Cleveland
$456,900
4
bd /
2
ba /
2,478
sqft
8895 Larkspur Drive
Columbia Station
,
Ohio
44028
Drees Homes Cleveland
$439,900
4
bd /
2
ba /
2,265
sqft
8936 Firethorne Drive
Columbia Station
,
Ohio
44028
Drees Homes Cleveland
$389,900
3
bd /
2
ba /
1,525
sqft
8975 Firethorne Drive
Columbia Station
,
Ohio
44028
CENTURY 21 DePiero & Associate
$3,500
--
bd /
0
ba /
--
sqft
26700 Royalton Road
Columbia Station
,
Ohio
44028
Keller Williams Elevate
$229,000
--
bd /
0
ba /
--
sqft
Vl# 1 Crocker Road
Columbia Station
,
Ohio
44028
Drees Homes Cleveland
NA
4
bd /
2
ba /
2,718
sqft
10316 Baker Creek Lane
Columbia Station
,
Ohio
44028
Drees Homes Cleveland
NA
4
bd /
2
ba /
3,055
sqft
10324 Baker Creek Lane
Columbia Station
,
Ohio
44028
Drees Homes Cleveland
NA
4
bd /
2
ba /
2,899
sqft
8857 Larkspur Drive
Columbia Station
,
Ohio
44028
Cities In LORAIN, OH
Amherst
Avon
Avon Lake
Columbia Station
Elyria
Grafton
Kipton
Lagrange
Lorain
North Ridgeville
Oberlin
Sheffield Lake
Wellington
columbia station
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => lorain [3] => OH [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: lorain State: OH Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: lorain State: OH 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 = 2084 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Cynthia Hamlin
ASCII
Coldwell Banker Schmidt Realty
work
Call Today!
:
(440) 364-8579
I'm interested in properties in LORAIN, OH
1841382
1841382
0
Contact Me
USHUD.com on the Go!