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;

8390 Wildcat Road
Tipp City, OH 45371
Boyd Warner with RE/MAX Alliance Realty Inc., original listing - (937) 898-4400

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $749,900
Beds: 5
Baths: Full: 3
Status: Pending
SqFt: 4283 Square Feet
Agency: RE/MAX Alliance Realty Inc.
Agency Phone: (937) 898-4400

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 1920
Notes: WOW! Nothing else can describe this AMAZING home situated down a long private driveway on 12.34 acres of peace & serenity in desirable Bethel Township! This home was just expanded to over 4000sf of living space in 2020 when the NEW addition was put on to include an incredible 18x14 master suite with a spa-like private bathroom, 3 additional spacious bedrooms and hall bath with double vanities! The oversize open staircase leads you up to this incredible upstairs from the also NEW 20x20 family room surrounded by a wall of windows that has million dollar views! There is also a beautiful laundry area and full bath! The original part of this slice of heaven was remodeled several years ago to include an incredible kitchen, dining area and living room with w/b fireplace. There is also an additional bedroom on the first floor that is currently being used as an office. 2 HVAC systems to control the original home as well as the new addition. This homestead has incredible views from everywhere, especially the NEW wrap around porch with knotty pine ceilings repurposed from the original farmhouse! As an added bonus, the master bathroom and downstairs bathroom has optional heated blowers. There is also a large above ground pool with wrap around deck and plenty of space to add more along with a pond for those who enjoy fishing! Most, if not all of this home is new(er) so there is literally nothing for you to do but take the drive down the lane to your NEW home and enjoy everything that country living has to offer!
MlsNumber: --
ListingId: 1021878


Listing Provided By: RE/MAX Alliance Realty Inc., original listing
Phone: (937) 415-2791
Office Phone: (937) 898-4400
Agent Name: Boyd Warner
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