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

104 Main Street
Golconda, IL 62938
Tonya Hughes with Hunt and Farm Realty, original listing - (618) 559-2967

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $84,000
Beds: 2
Baths: Full: 1
Status: Active
SqFt: 1378 Square Feet
Agency: Hunt and Farm Realty
Agency Phone: (618) 559-2967

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1907
Notes: Welcome to this wonderfully updated home in the charming Historic Golconda! Nestled close to the beautiful Ohio River, Marina, and Shawnee National Forest, this location offers endless opportunities for adventure. Plus, you'll find fantastic restaurants and shopping just blocks away-talk about convenience! This incredible property has been completely transformed and is ready for you to move right in! With a brand new roof installed in 2018 and an enclosed back porch added the same year, this home is full of delightful upgrades. The new front door, set to welcome you in , pairs perfectly with the gorgeous new flooring throughout the entire home. Say goodbye to the old drop-down ceilings; 2024 has brought a stylish sheet-rocked ceiling instead! You'll love the fresh interior paint, also completed in 2024, and the exterior paint job from 2019. We've added plenty of storage with new closets in the bedrooms and a handy kitchen pantry. Primary Bedroom has a large walk-in closet. Enjoy modern lighting with new can lights and ceiling fans, installed 2024, while the updated electric and electrical panel installed in 2021. Step into your stunning new kitchen, featuring gorgeous granite countertops and brand new stainless steel appliances! Plus, a fabulous stackable stainless steel washer and dryer are also on hand. With vinyl dual-pane windows throughout, this home is as energy-efficient as it is inviting. Completely remodeled bathroom with walk in shower and updated plumbing. Home would make a wonderful business in a great location or a great family home. This property boasts an excellent layout and is truly move-in ready-don't miss out on the chance to make it yours! Approximate Room Sizes: Living Room 16 x 14.6; Primary Bedroom 22 x 16; Bathroom 9 x 5; Kitchen (L shaped with room for dining table) 16 x 13; Guest Bedroom 13 x 14; Covered Back Porch 8 x 13.
MlsNumber: --
ListingId: 11407575


Listing Provided By: Hunt and Farm Realty, original listing
Phone: (618) 559-2967
Office Phone: (618) 559-2967
Agent Name: Tonya Hughes
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