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

201 5th Street
Carmi, IL 62821
Kimberly A Gwaltney with Town & Country Real Estate, Inc., original listing - (618) 384-3033

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $222,500
Beds: 4
Baths: Full: 1, ½: 1
Status: Active
SqFt: 2403 Square Feet
Agency: Town & Country Real Estate, Inc.
Agency Phone: (618) 384-3033

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Farm
Year Built: 1896
Notes: Set on 1.5 Town Lots - 2400+ Sq.Ft. You will be Warmly Welcomed w/ Your Wrap-around Railed Front Porch (composition material, of course) , ... to 'Swing-away The Day'! Entering the Front Door of Your "Heritage Home" (w/ original bell ringer), the Foyer shares the First Heart-pull as You are Charmed with Crown Moldings, Perfectly Painted Current Color Palette Ceilings and Walls, Beautiful Baseboards, Built-ins & Trim Accents. And then, there are First rate Floorings, to say Everything about a Fabulous Floor Plan! This Just Right 2400 Sq.Ft. Home presents on the Main Floor; *Living/Gathering Room for TRUE Relaxation, *Formal Dining Room w/ Fireplace for Candle lit Celebrations, *Adjacent, a Comforting Cafe' Kitchen that no one wants to leave, *Breakfast / Den Room *Large Master Suite (15x20) w/ Walk-in Closet & Sundry Closet, Recently Remodeled Bath *Guest Bedroom 'A' (16x17) w /Cedar Closet *Lovely Laundry Room The Second Floor presents; *Guest Bedroom 'B' (15x16) *Guest Bedroom 'C' (14x15) *Study Landing or Library *Powder Bath Special Crafts & Hobbies? ... Your Lower-Level Basement is the answer! Special 4-Legged Friends? ... Fenced Back Yard & Patio w Privacy Wall! AND - So Much More... *NEW 2022 TriCo Roof - *NEWER Replacement Windows - *NEW 2022 Midea Splitter A/C Systems- *NEW 2022 ~ 2 Plus (30x30) Insulated Garage w/ Radiant Heated Floors, Can & LED Lighting Pkg - *NEW 2022 Concrete Sidewalk / Back Patio. AND - Even More To See & Experience for Yourself ~ In Person!!!! From Your New Home's Curb-appeal to it's Very Heart You are Surrounded by Ambiance and you Know You are Home!
MlsNumber: --
ListingId: 11351296


Listing Provided By: Town & Country Real Estate, Inc., original listing
Phone: (618) 384-3033
Office Phone: (618) 384-3033
Agent Name: Kimberly A Gwaltney
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