Title Page Background
DEBUG FN args: Array ( [0] => 2067 [1] => [2] => [3] => agent ) BEFORE: Site: 2067 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2067 Igate: njhud LocID: 2067 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2067 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2067 [1] => [2] => [3] => lender ) BEFORE: Site: 2067 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2067 Igate: njhud LocID: 2067 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2067 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2067 [1] => [2] => [3] => other ) BEFORE: Site: 2067 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2067 Igate: njhud LocID: 2067 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2067 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

49197 John Tomcho Road
Cumberland, OH 43732
Carol Cunningham with NextHome New Horizons Equity Realty, original listing - (833) THE-NEXT

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $350,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 2376 Square Feet
Agency: NextHome New Horizons Equity Realty
Agency Phone: (833) THE-NEXT

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1900
Notes: 4-5 BEDROOMS on 1/2+ ACRE with FREE GAS in NOBLE LOCAL SCHOOL DISTRICT! Bring your family to the country and have tons of room inside and out! This large home offers 5 bedrooms (or 4 bedrooms on 2nd floor and game/media room on 3rd floor) and currently has FREE GAS! The first floor offers a formal living room with gas fireplace, family room with parlor doors to a side deck, kitchen with maple cabinets, 2 large islands/breakfast bar, and lots of counter space, a formal dining room with built-in bookcases/hutches on each side of the gas fireplace plus a full bath. The second floor houses 3 bedrooms, a 2nd full bath, the master bedroom with a huge walk-in closet, master bath with a claw-foot tub, tiled shower, and laundry with washer/dryer. The third floor could be your 5th bedroom/game room/media room. Lots of closet and storage space in addition to the mudroom and the insulated 28x32 4-CAR ATTACHED GARAGE with attic storage. Paved driveway, plenty of yard space, covered front porch, unfinished basement, metal roof, new gutters, GFA with 2 central air units plus portable AC units. Free gas until such time well is capped or no longer producing. Right of way for shared drive. Recent survey from parcel split. Minerals rights do not transfer. Don't miss this great family home! Call to tour!
MlsNumber: --
ListingId: 5117872


Listing Provided By: NextHome New Horizons Equity Realty, original listing
Phone: (740) 255-3799
Office Phone: (833) THE-NEXT
Agent Name: Carol Cunningham
Disclaimer: Copyright © 2025 NextHome, Inc. 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => guernsey [3] => OH [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: guernsey State: OH Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: guernsey State: OH Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2067 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Sheri Bruner Badertscher
Sheri Bruner Badertscher
ASCIICarol Goff & Associates - Cambridge
Call Today!: (740) 685-3003

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App