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

31182 2050 North Avenue
Arlington, IL 61312

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $189,000
Beds: 5
Baths: 3
Status: Pending
SqFt: 2200
Agency: Landmark Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 1871
Notes: You'll immediately fall in love with this idyllic 2.25-acre country estate! Located within easy reach of both LaSalle-Peru and Princeton, this five-bedroom, 3-bath Home practically oozes historic grandeur. And History there is aplenty! A one-family home for generations, it witnessed a major remodel which transformed and modernized the house in 1988. The present homeowner has added even more value with upgrades from furnace to floors to bathrooms (see attached list of additional information). What a perfect layout! A large kitchen boasting an impressive center island gives way to a grand formal dining room. From there, discover the myriad array of spacious rooms and find stunning millwork, trey ceiling, unique transoms, a full butler's pantry with pass-through window, and a luxurious clawfoot tub! A main-floor bedroom with full bath could easily be used as an in-law suite! Nine and ten-foot ceilings make you feel like you're in a palace, and the extravagant amount of living space only confirms that. Not a single small bedroom to be found. Take note of the sunroom upstairs, as well as the 2nd staircase! You'll be entranced with the views in every direction - a different palette of colors each Season! (and exteriorly, a series of porches that allow you to admire the vista from every angle!) Step outside - the beautiful acreage allows for any project that may come to mind - including a pasture for horses, goats, chickens . . . or perhaps a dirt-bike course!! You also have a full, dry basement, completely useable for an abundance of storage, or a workshop. Grain bins & building are NOT included in this property, but there is a possibility that you could arrange for use of the barn. Property being sold as-is. Come take a look at this unique Home - so many practical updates, but there's enough work left to do to give you the satisfaction of making it truly Your Own. Create your private retreat in this solid, elegant Home - come fall in love!
MlsNumber: 11971597


Listing Provided By: Landmark Realty, original listing
Name: Landmark Realty
Phone: (815) 875-1221
Office Name: Landmark Realty Of Illinois LLC
Office Phone: (815) 875-1221
Agent Name: Beth Mulcahy
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