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

605 Church St
Xenia, IL 62899
Katie Matthews with Keys Real Estate, original listing - (618) 516-3135

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $109,900
Beds: 3
Baths: Full: 1
Status: Active
SqFt: 1782 Square Feet
Agency: Keys Real Estate
Agency Phone: (618) 516-3135

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1920
Notes: Welcome to a unique opportunity nestled on 1.03 acres of picturesque land boasting fruit trees and endless potential, including apple trees and pear trees. This property offers a captivating blend of historic charm and modern convenience, presenting an ideal canvas for both homeowners and investors alike. The main home is a quaint 1921-built 3-bedroom, 1-bathroom house spanning 1,782 square feet across two stories, with additional basement space and a welcoming porch. While it awaits your personal touch and renovations, envision the possibilities of restoring this vintage gem to its former glory. Refinish the original hardwood floors. Put up the original wood work. Adjacent to the main house stands a remarkable 2017-built shop featuring an 800 square foot, 1-bedroom, 1-bathroom apartment. Complete with a spacious living room and a fully equipped kitchen, this apartment provides comfortable living quarters amidst the serenity of the property. The shop itself spans an expansive 1,600 square feet, equipped with a rolling garage door, padded concrete floors, and superior insulation-a haven for hobbies, storage, or entrepreneurial ventures. Additionally, a generous 30x40 covered area attached to the shop offers a perfect spot for morning coffees or casual gatherings. Each dwelling enjoys separate water and electric meters, enhancing convenience and utility management. Consider the flexibility of residing in the shop apartment while meticulously renovating the main house, creating a lifestyle blending modern comforts with a project close to heart. Alternatively, capitalize on the income potential by leasing out the shop apartment once the main house achieves its full potential. Located in a quaint neighborhood with serene surroundings and sidewalks, this property invites you to explore the limitless possibilities it offers. Whether you're envisioning a private oasis, a savvy investment opportunity, or a combination of both, seize the chance to make your mark on this exceptional property. Embrace the charm, embrace the potential-schedule your tour today and imagine the future awaiting you at 605 Church Street.
MlsNumber: --
ListingId: 11456575


Listing Provided By: Keys Real Estate, original listing
Phone: (618) 516-3135
Office Phone: (618) 516-3135
Agent Name: Katie Matthews
Disclaimer: Copyright © 2025 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