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] => 1280 [1] => LENAWEE [2] => MI [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1280 LocID: LENAWEE Region: MI State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1280 Igate: njhud LocID: 1280 Region: LENAWEE State: MI 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 = 1280 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1280 [1] => LENAWEE [2] => MI [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1280 LocID: LENAWEE Region: MI State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1280 Igate: njhud LocID: 1280 Region: LENAWEE State: MI 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 = 1280 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1280 [1] => LENAWEE [2] => MI [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1280 LocID: LENAWEE Region: MI State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1280 Igate: njhud LocID: 1280 Region: LENAWEE State: MI 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 = 1280 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Michigan (MI) Foreclosure Listings
|
Lenawee
| Morenci, Michigan
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Morenci, Lenawee, Michigan
Displaying 1 to 10 of 14 Properties (2 foreclosures)
Goedert Real Estate - Adr
FORECLOSURE
$73,000
3
bd /
1
ba /
1,197
sqft
219 North
Morenci
,
Michigan
49256
Loss Realty Group
FORECLOSURE
$42,500
4
bd /
1
ba /
1,320
sqft
425 Centre
Morenci
,
Michigan
49256
Goedert Real Estate - Adr
$79,900
2
bd /
1
ba /
720
sqft
225 E Stephenson
Morenci
,
Michigan
49256
The Wagley Group
$29,900
--
bd /
0
ba /
--
sqft
328 Main
Morenci
,
Michigan
49256
Xsell Realty
$194,900
3
bd /
2
ba /
1,320
sqft
8936 Seneca
Morenci
,
Michigan
49256
Howard Hanna Real Estate Services-Adrian
$174,900
4
bd /
2
ba /
1,437
sqft
324 Owosso
Morenci
,
Michigan
49256
EXP Realty
$168,000
3
bd /
1
ba /
1,266
sqft
13829 Munson Hwy
Morenci
,
Michigan
49256
The Wagley Group
$149,900
2
bd /
1
ba /
1,047
sqft
804 Wakefield
Morenci
,
Michigan
49256
PRODUCTION REALTY
$142,000
--
bd /
1
ba /
2,553
sqft
113 W Main Street
Morenci
,
Michigan
49256
Xsell Realty
$135,000
--
bd /
0
ba /
6,720
sqft
148 W Main
Morenci
,
Michigan
49256
«
‹
1
2
›
»
Cities In LENAWEE, MI
Addison
Adrian
Blissfield
Britton
Cement City
Clayton
Clinton
Deerfield
Hudson
Jasper
Manitou Beach
Morenci
Onsted
Palmyra
Riga
Sand Creek
Tecumseh
Tipton
Weston
morenci
USHUD.com on the Go!