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

17627 Us Hwy 54
Rockport, IL 62370

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $389,000
Beds: 4
Baths: 4
Status: Active
SqFt: 3990
Agency: PIKE COUNTY REAL ESTATE INCORPORATED

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: --
Notes: Built in 1823 and used originally as a trading post between Alton, IL & Keokuk, IA, this breathtaking brick home is the oldest structure standing in Pike County, Illinois today! The history around this property is endless, and if the walls of this place could talk, oh the stories they could tell!! From Brigham Young staying here for 7 weeks in the 1840's as he moved the Moormans out of Illinois, to a signature of Davey Crockett on the floor joist in the basement, this home has seen many travelers come & go from all different time periods and many walks of life! Today this sprawling brick home has been completely restored and modernized to fit a growing family, or easily set up for a Bed & Breakfast at one of the area's most well-known 4-way intersections in Atlas, Illinois. The home boasts 4 bedrooms, 2 of which are set up as master suites, and 3.5 bathrooms, and nearly 4,000 square feet of immaculate living space. All appliances convey including the hot tub on the covered patio. There is also a private, fenced-in backyard perfect for pets, family gatherings and/or backyard barbecues. The extras to this property really enhance the value! There are 2 rental properties on the west side of the property, each of which are 2 bedroom, 1 bath units, beautifully finished and already generating some monthly income. $1,000 per month rent is being paid for one of the units and the other is vacant and ready to be rented either as a permanent monthly rental, or as a hotel-style rental with nightly income. There are 2 large carports that convey with these rentals, providing some covered parking for each unit. In addition to these, there is a beautiful, insulated 42x45 machine shed adjacent to the house that has parking for 2 cars in front and an RV in back. The shed also has 2 storage rooms, one on each floor of the building. Don't miss out on this rare opportunity to own a fabulous, historic, investment property in a great location!! Call us today for a private tour
MlsNumber: 11231926


Listing Provided By: PIKE COUNTY REAL ESTATE INCORPORATED, original listing
Name: PIKE COUNTY REAL ESTATE INCORPORATED
Phone: (217) 285-5800
Office Name: PCRE REAL ESTATE & AUCTION, INC
Office Phone: (217) 285-5800
Agent Name: Christopher Nichols
Disclaimer: Copyright © 2024 My State MLS. 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