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] => 3043 [1] => GRANT [2] => WI [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3043 LocID: GRANT Region: WI State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3043 Igate: njhud LocID: 3043 Region: GRANT State: WI 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 = 3043 AND i.igate IN ('wihud','usahud','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 = 'wihud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3043 [1] => GRANT [2] => WI [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3043 LocID: GRANT Region: WI State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3043 Igate: njhud LocID: 3043 Region: GRANT State: WI 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 = 3043 AND i.igate IN ('wihud','usahud','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 = 'wihud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3043 [1] => GRANT [2] => WI [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3043 LocID: GRANT Region: WI State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3043 Igate: njhud LocID: 3043 Region: GRANT State: WI 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 = 3043 AND i.igate IN ('wihud','usahud','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 = 'wihud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Wisconsin (WI) Foreclosure Listings
|
Grant
| Hazel Green, Wisconsin
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Hazel Green, Grant, Wisconsin
Displaying 1 to 10 of 14 Properties (0 foreclosures)
Keller Williams Midwest Partners
$2,380,000
--
bd /
0
ba /
--
sqft
527 Badger
Hazel Green
,
Wisconsin
53811
Remax Advantage
$590,000
--
bd /
0
ba /
--
sqft
Lot 1 Wolff
Hazel Green
,
Wisconsin
53811
Remax Advantage
$590,000
--
bd /
0
ba /
--
sqft
Lot 2 Wolff
Hazel Green
,
Wisconsin
53811
Remax Advantage
$439,000
2
bd /
2
ba /
2,777
sqft
957 Whispering
Hazel Green
,
Wisconsin
53811
Lori Droessler Real Estate, Inc.
$359,000
3
bd /
2
ba /
3,326
sqft
3310 N Percival Street
Hazel Green
,
Wisconsin
53811
Lori Droessler Real Estate, Inc.
$30,500
--
bd /
0
ba /
--
sqft
Lot 3 23rd St Country Valley
Hazel Green
,
Wisconsin
53811
Lori Droessler Real Estate, Inc.
$28,000
--
bd /
0
ba /
--
sqft
Lot #6 Woodland Drive
Hazel Green
,
Wisconsin
53811-0367
Lori Droessler Real Estate, Inc.
$27,500
--
bd /
0
ba /
--
sqft
1845 23rd St Country Valley
Hazel Green
,
Wisconsin
53811
Lori Droessler Real Estate, Inc.
$23,500
--
bd /
0
ba /
--
sqft
1830 23rd St Country Valley
Hazel Green
,
Wisconsin
53811
Lori Droessler Real Estate, Inc.
$23,500
--
bd /
0
ba /
--
sqft
1840 23rd St Country Valley
Hazel Green
,
Wisconsin
53811
«
‹
1
2
›
»
Cities In GRANT, WI
Bagley
Beetown
Bloomington
Blue River
Boscobel
Cassville
Cuba City
Dickeyville
Fennimore
Glen Haven
Hazel Green
Kieler
Lancaster
Livingston
Montfort
Mount Hope
Muscoda
Patch Grove
Platteville
Potosi
Sinsinawa
Stitzer
Woodman
hazel green
USHUD.com on the Go!