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 = 689 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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 = 689 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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 = 689 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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;

4851 Sheridan Road
Groveland, IL 61535

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,900,000
Beds: 6
Baths: 6
Status: Active
SqFt: 6830
Agency: Honig Realty Inc (dba Coldwell Banker Honig-Bell)

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential
Year Built: 2006
Notes: It is almost time...to enjoy this home, with the privacy and In one of 2 POOLS! Noah Herman & Sons, Custom Built! Simply Said~STUNNING!! Zoned Ag~Taxes are on all 20.68 Acres. Seller is selling the Home and approximately 4 acres at this time. If someone is interested in the entire parcel, Seller, would work with a buyer. This is a One of a Kind Phenominal Beauty you could make this your Ranch or "HomeStead," (Greenhouse Included),! Two pools (one inground saltwater outdoors with a hot tub & slide and one exercise pool and hot tub inside~in a temp. controlled spa, w/a private sauna). This home has been Meticulously Built, Cared For and Loved! Completely updated and ready for its new residents! Updates include: Roof, 2 HVAC units, 2 H2O Heaters, Kitchen updates and new appliances, light fixtures and paint throughout, gutters, downspouts, pool cover and sand filter. This home is truly, like living at your own Private Country Club! Gorgeous Estate is within 5 minutes of Morton, and its award-winning schools, ten minutes to the airport, fifteen minutes to downtown Peoria, and a short 30 minute drive to Rivian and State Farm~Bloomington! This home would make for a short commute! Destination Perfect Found Here!
MlsNumber: PA1248842


Listing Provided By: Honig Realty Inc (dba Coldwell Banker Honig-Bell), original listing
Name: Honig Realty Inc (dba Coldwell Banker Honig-Bell)
Phone: (815) 553-2406
Office Name: Coldwell Banker Real Estate Gr
Office Phone: (815) 553-2406
Agent Name: Jennifer Fielder
Disclaimer: Copyright © 2024 RMLS Alliance. 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