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 = 2092 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 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 = 2092 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 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 = 2092 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 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;

2583 N Rugged Hill Road
Casstown, OH 45312
Dana Ward with Home Experts Realty, original listing - (937) 435-6000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $781,900
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3392 Square Feet
Agency: Home Experts Realty
Agency Phone: (937) 435-6000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 2016
Notes: Custom built, high quality, full brick ranch was built in 2017 and sits on 5.7 acres. Plenty of space with 3,314 sq ft, featuring 4 bedrooms, 2 are primary suites at opposite ends of the home, and 3.5 baths. One primary has a walk-out patio, jetted tub, separate shower, with electric in one of the closets for a microwave/mini-refrigerator. Great room boasts a gorgeous stone fireplace (Gas, propane fueled) makes a wonderful focal point. Built-in bookcases have glass doors and IV cabinet. Primary bedroom suites offer walk-in closets, tile showers with wood benches, (one soak tub), and electric heaters. Kitchen features granite countertops and maple, custom cabinetry. Under cabinet lighting. Mudd room offers wood benches. Basement entry offers 4' stairs, finished drywall walls and ceiling with recessed lighting. Needs only finishing touches to make it your own. Three rooms plus bathroom. Plumbed for kitchen, full bath. Basement access from main level and garage. Steps going to/from basement are extra wide and deep. Additional storage offered in the concrete crawlspace. Generator. Geothermal HVAC features 3 zones, 2 sump pumps, 1 for exterior perimeter of home. Covered rear patio. 3 car garage is extra wide and deep and features floor drains under each parking area. Home has beautiful landscaping. Castle-block walkway to and around a rose garden featured in center of circular driveway. No lease with farmer on 3 acres planted. Farmer will need to have access to reap harvest in the fall. No additional lease. Seller needs 60 days occupancy post closing. This home is a top of the line home with lots of features. Book your appointment now!
MlsNumber: --
ListingId: 1032633


Listing Provided By: Home Experts Realty, original listing
Phone: (937) 701-4044
Office Phone: (937) 435-6000
Agent Name: Dana Ward
Disclaimer: Copyright © 2024 Western Regional Information Systems and Technology, Inc. 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