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 ('tnhud','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 = 'tnhud', 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 ('tnhud','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 = 'tnhud', 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 ('tnhud','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 = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Michigan (MI) Foreclosure Listings
|
Lenawee
| Onsted, Michigan
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Onsted, Lenawee, Michigan
Displaying 1 to 10 of 38 Properties (0 foreclosures)
Howard Hanna Real Estate Services-Adrian
$98,000
--
bd /
0
ba /
--
sqft
8000 Blk Stephenson
Onsted
,
Michigan
49265
Foundation Realty, LLC
$85,000
--
bd /
0
ba /
--
sqft
10000 M50
Onsted
,
Michigan
49265
EXP Realty Plymouth
$80,000
--
bd /
0
ba /
--
sqft
7709 Dalton Road
Onsted
,
Michigan
49265
RE/MAX IRISH HILLS REALTY
$77,900
--
bd /
0
ba /
945
sqft
10500 Us-223
Onsted
,
Michigan
49265
RE/MAX IRISH HILLS REALTY
$749,000
4
bd /
3
ba /
2,791
sqft
605 Pentecost Highway
Onsted
,
Michigan
49265
RE/MAX IRISH HILLS REALTY
$749,000
5
bd /
4
ba /
4,320
sqft
8528 Slee Road
Onsted
,
Michigan
49265
Howard Hanna Real Estate Services-Adrian
$65,000
--
bd /
0
ba /
1,100
sqft
8877 Onsted
Onsted
,
Michigan
49265
Irish Hills Realty
$60,000
--
bd /
0
ba /
--
sqft
1000 Chisholm
Onsted
,
Michigan
49265
Re/Max Platinum
$60,000
--
bd /
0
ba /
--
sqft
Lot 27 Castlebar Lane
Onsted
,
Michigan
49265
Re/Max Platinum
$60,000
--
bd /
0
ba /
--
sqft
Lot 28 Castlebar Lane
Onsted
,
Michigan
49265
«
‹
1
2
3
›
»
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
onsted
USHUD.com on the Go!