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 = 654 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 = 654 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 = 654 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;

3124 Niantic Road
Niantic, IL 62551
Barbara Endzelis with RE/MAX Professionals, original listing - (217) 787-7215

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $399,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 3188 Square Feet
Agency: RE/MAX Professionals
Agency Phone: (217) 787-7215

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 1905
Notes: Step into your dream farmhouse retreat! This expansive, fully restored early 1900's home offers 5 possibly 6 bedrooms, 3.5 bathrooms on a picturesque 2.33-acre property, featuring panoramic views in all directions, w/ stunning sunrises and sunsets. Nestled on the land, is a charming orchard w/ apple, cherry, peach, pear & mature pecan trees along with several blackberry and raspberry bushes that give an abundant harvest each year! The exterior showcases newly planted Maple and Poplar trees, several Lavender plants, a convenient chicken coop to match the house, and a spacious 90x54 pole barn complete W/ water and electricity and a 10x20 garden shed, 20x40 Hoop House. Enjoy serene surroundings from the expansive wrap-around front porch, enhanced w/a delightful porch swing. The property has been thoughtfully updated, with granite counter tops, tile backsplash, intricate woodwork throughout, a brand-new roof installed in 2023, an high efficient instant hot water heater, thermal floor heating featuring multiple zones, a whole house vacuum system, and a cozy propane fireplace. You'll also benefit from a whole-house generator (ready for hook up), as well as an owned propane tank for added convenience, all with public water added 2024 and still has the well for outside spigots. For your utmost comfort, Air Conditioning system was installed in 2023, ensuring year-round comfort.
MlsNumber: --
ListingId: CA1033975


Listing Provided By: RE/MAX Professionals, original listing
Phone: (217) 787-7215
Office Phone: (217) 787-7215
Agent Name: Barbara Endzelis
Disclaimer: Copyright © 2025 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