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','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 = 612 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 = 612 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;

6715 Old Highway 50
Flora, IL 62839
Amy Bailey with AMY LEE REALTY LLC, original listing - (618) 662-3170

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $267,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2100 Square Feet
Agency: AMY LEE REALTY LLC
Agency Phone: (618) 662-3170

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 18 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1943
Notes: Prime Location 18+/-Acres Wooded Retreat with TWO homes adjoining Charlie Brown Park! Tucked away down a wood lined driveway, you will discover a one-of-a-kind home, a guest home with shop, and a fantastic older barn. This property is a hidden gem awaiting transformation. Main House: A large 2100 Sq Ft of living space. As you enter, you will be greeted by a large entry area complete with home bar. This area is open the massive living room, which is also partially open to a huge bonus room. The bonus room is currently being used as an art studio but would make a great additional space for just about anything! The kitchen has a vast amount of cabinetry, shelving, and even a unique built-in table. Full appliance package is included. There are 3 bedrooms, all are large with excellent closet space. The primary has a large bay window to allow you to take in the beauty of your surroundings. Two bathrooms are also in this home. Large rooms, some hardwood flooring, boiler heat, replacement windows, and updated metal roof, will give you peace of mind. The homes have separate aeration septic for each, and city utilities. The second home- This is a 1700+sq ft living space with an additional garage on each end, a double carport, and bonus workshop. The living room is massive and has shelving as you enter to add to storage areas. If you want a large kitchen, then you will love the space of this one! The bedroom is also huge and has large closet space. A full bathroom, with additional, versatile space. There is a laundry room that has closet space and is currently being used as a home gym. A workshop, garage, and full-length attic space will allow you to have enough space for all your needs & wants. Could the homes use some work? Sure, but they are in good condition and are at a good place to put your personal touch on them. Live in one while working on the other! An adorable treehouse on pillars adds to the charm of this property, and the paths throughout the wooded 18 acres will give you years of joy. There is an older barn that has been updated with metal siding and roof and has stalls, a large loft, a large fenced area, complete with chickens! (chickens can be included) The property itself is beautiful and tranquil Schedule a viewing today and envision the future of your very own hideaway.
MlsNumber: --
ListingId: 11381571


Listing Provided By: AMY LEE REALTY LLC, original listing
Phone: (618) 662-3170
Office Phone: (618) 662-3170
Agent Name: Amy Bailey
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.


Local Real Estate Expert

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','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;
Real Estate Expert Photo for Tomi Tomlin-Buening
Tomi Tomlin-Buening
ASCIICENTURY 21 Realty Concepts
Call Today!: (618) 367-5869

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App