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
| Blissfield, Michigan
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Blissfield, Lenawee, Michigan
Displaying 1 to 7 of 7 Properties (2 foreclosures)
Century 21 Affiliated
FORECLOSURE
$154,900
4
bd /
1
ba /
2,401
sqft
220 E Adrian Street
Blissfield
,
Michigan
49228
Goedert Real Estate
FORECLOSURE
$104,900
2
bd /
1
ba /
1,378
sqft
678 Jipson
Blissfield
,
Michigan
49228
Coldwell Banker Haynes Real Estate, Inc.
$249,900
3
bd /
3
ba /
2,323
sqft
9758 Pence Highway
Blissfield
,
Michigan
49228
Binns Realty, Inc.
$189,900
3
bd /
1
ba /
1,608
sqft
11348 Rouget
Blissfield
,
Michigan
49228
Edward Surovell realtors
$179,900
2
bd /
1
ba /
1,048
sqft
4961 S Wellsville
Blissfield
,
Michigan
49228
Xsell Realty
$150,000
4
bd /
1
ba /
1,365
sqft
10407 S Deerfield
Blissfield
,
Michigan
49228
Edward Surovell realtors
$150,000
2
bd /
1
ba /
1,072
sqft
753 S Lane
Blissfield
,
Michigan
49228
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
blissfield
USHUD.com on the Go!