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

126 E 4th Street
Mount Carmel, IL 62863
Jordan Crow with SARA STORCKMAN REALTY INC, original listing - (618) 262-7698

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $239,900
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 4200 Square Feet
Agency: SARA STORCKMAN REALTY INC
Agency Phone: (618) 262-7698

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1905
Notes: Remarkable Victorian Home with Classic Touches and Stellar Updates! Entering from the wrap-around front porch and stately front door with leaded glass, you'll find an inviting foyer where the home's impeccable mouldings, hardwood floors and character just begin. The original hardwood floors feature ornate detail and have been totally refinished and span the majority of the home. The main floor boasts a formal living room, family room, formal dining room, full bath with clawfoot tub, laundry room with great storage, and spacious kitchen which has been fully remodeled with quartz countertops, stainless steel appliances, large island, and heated ceramic tile flooring. Upstairs is a large common area that serves as the perfect office space or sitting room. 4 generously sized bedrooms offering ample closet space, a main hall bath with linen closet, and half bath complete the 2nd story. The 3rd floor with designated interior or separate exterior access offers additional living quarters, with options for an income producing apartment or in-law suite. This space (approx. 1200 square feet) offers 2 bedrooms, a full bath, spacious kitchen with included laundry area, living and dining rooms. It also includes kitchen appliances and washer/dryer. The backyard offers a newly built deck with updated railings, double carport, and large outbuilding, which is currently utilized as a workshop. The full basement offers refuge from storms and lots of storage. Other great updates include vinyl replacement windows, energy efficient tankless water heater, and a nearly new architectural shingle roof. This home is truly one of a kind and a must see! Call today to schedule your private showing!
MlsNumber: --
ListingId: 11324123


Listing Provided By: SARA STORCKMAN REALTY INC, original listing
Phone: (618) 240-4870
Office Phone: (618) 262-7698
Agent Name: Jordan Crow
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