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

6215 Buncombe Road
Vienna, IL 62995

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $650,000
Beds: 7
Baths: 3
Status: Active
SqFt: 5212
Agency: Midwest Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 20 acre(s)
Property Type: Residential
Year Built: 2016
Notes: Beautiful 20 Acre Estate! Private Home W/Buildings Suitable For Variety of Business Opportunities! HOME-Amish Built 2016, with 5,212 Sq', 7 BR(master on main floor), 3 Full BA(2 main floor,1 up), Huge Kitchen+Separate Pantry,Zero Carpet (9' Ceilings,Main Floor). Full Unfinished Basement (11'Ceiling, 6" Poured Walls), Front & Back Porches. New Energy Eff Heat Pump. Walls 6",Thermal Windows,Well Insulated. BUILDING(S)- With Countless Possibilities/Uses, Approx 13,202 TOTAL SQ' + Lean-To, Bath, Office Area, Bays w/Commercial Garage Doors(see pics).Each Areas Open/Accessible to the Next. Concrete, Etc Built to BPP Code. LIMITLESS POSSIBILITIES AS PARCEL HAS NO RESTRICTIONS. Was Former A-1/JC Metals. Property Has High Elevation w/View, Is Fenced, Has Pond, Mix Pasture & Timber. (Great Hunting). Only 1.2 Miles Off RT 37, On Hard Surface Rd, Between I-57 & I-24. Weather Your Family is Large or Small, Relocating or Starting a Business(small manufacturing,etc), Need Place For Your Show Livestock or Pleasure/Race Horses, Rent or Need RV/Car Storage, Do Mechanic/Restoration, Or Dream of An Event Center/Airbnb, THIS LISTING CAN ACCOMMODATE ALL YOUR NEEDS!! CALL & LETS LOOK!!
MlsNumber: EB450075


Listing Provided By: Midwest Real Estate, original listing
Name: Midwest Real Estate
Phone: (618) 658-2006
Office Name: Midwest Real Estate
Office Phone: (618) 658-2006
Agent Name: LYNN BEASLEY
Disclaimer: Copyright © 2024 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