Title Page Background
HFQUERY 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 = 631 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 631 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 631 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

620 Michael Drive
Morris, IL 60450

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $689,900
Beds: 4
Baths: 5
Status: Active
SqFt: 3184
Agency: Tiered Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1993
Notes: Amazing Home In Hickory Lake With A Stunning View Has Been Upgraded Throughout And Looks Out Over The Water. Spacious Front Porch. All New Kitchen With Quartz Counters And All New Stainless Steel Appliances And Exhaust Hood. Hardwood And Bamboo Floors Throughout. Living Room With Fireplace And Vaulted Ceiling. There Is Both An Office And A Library With So Many Possible Uses. Deluxe Primary Suite With Fireplace, Walk-In Closet And Full Bathroom With Make-Up Area, Separate Shower, Soaker Tub And Dual Sinks. Bedrooms 2 And 3 Have A Full Jack-And-Jill Bathroom. Bedroom 3 Also Has A Walk-In Closet And A Balcony. Bedroom 4 Is Another Full Suite With A Walk-In Closet And Full Private Bathroom. Main Floor Laundry Also Has A New Washer And Dryer, A Sink And A Quartz Counter. Full Basement Is Finished With Rec Room And Great Room And An Electric Fireplace. Central Vacuum With New Collector Unit. Home Has Both A 2-Car And A 1-Car Attached Garage. New Furnace. New Air Conditioner. Two Hot Water Heaters, One Is New And The Other Is Only 3 Years Old. The Gazebo And Newly Expanded Deck Is Over 40 Feet Long And Looks Out Over The Water. The Property Has Been Built Up 4 Feet And A Retaining Wall Was Built Within The Last 6 Months. The Lot Extends Into The Water Which Opens Up A Possible Dock Or More. This Luxurious Home Has Been Completely Updated And Upgraded And Is Ready For You To Move In.
MlsNumber: 12076456


Listing Provided By: Tiered Real Estate, original listing
Name: Tiered Real Estate
Phone: (815) 521-9102
Office Name: Tiered Real Estate
Office Phone: (815) 521-9102
Agent Name: Ryan Van Der Karr
Disclaimer: Copyright © 2024 Midwest Real Estate Data, LLC. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App