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 ('mihud','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 = 'mihud', 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 ('mihud','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 = 'mihud', 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 ('mihud','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 = 'mihud', 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 31 to 40 of 66 Properties (1 foreclosures)
RE/MAX Preferred Associates
$71,900
--
bd /
0
ba /
--
sqft
Parcel 4 Pawson
Onsted
,
Michigan
49265-9737
Howard Hanna Real Estate Services-Adrian
$65,000
--
bd /
0
ba /
1,100
sqft
8877 Onsted
Onsted
,
Michigan
49265
Real Estate 4U - Lambertville
$55,000
--
bd /
0
ba /
--
sqft
8332 Odowling
Onsted
,
Michigan
49265
Irish Hills Realty
$48,500
--
bd /
0
ba /
--
sqft
225 E Third
Onsted
,
Michigan
49265
Howard Hanna Real Estate Services-Adrian
$42,000
--
bd /
0
ba /
--
sqft
8000 Blk Lot 10 Stephenson
Onsted
,
Michigan
49265
Howard Hanna Real Estate Services-Adrian
$42,000
--
bd /
0
ba /
--
sqft
8000 Blk Lot 8 Stephenson
Onsted
,
Michigan
49265
Howard Hanna Real Estate Services-Adrian
$42,000
--
bd /
0
ba /
--
sqft
8000 Blk Lot 9 Stephenson
Onsted
,
Michigan
49265
Irish Hills Realty
$23,500
--
bd /
0
ba /
--
sqft
Wadding
Onsted
,
Michigan
49265
Your Premiere Properties LLC
$22,900
--
bd /
0
ba /
--
sqft
7604 Sherlock Drive
Onsted
,
Michigan
49265
ERA REARDON - BROOKLYN
$20,000
--
bd /
0
ba /
--
sqft
7568 Norfolk Drive
Onsted
,
Michigan
49265
«
‹
2
3
4
5
6
›
»
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!