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

9349 Baltimore Phillipsburg Road
Brookville, OH 45309
Jackie Halderman with Sibcy Cline, Inc., original listing - (937) 898-1234

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $545,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2000 Square Feet
Agency: Sibcy Cline, Inc.
Agency Phone: (937) 898-1234

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1886
Notes: Horse Lover's Paradise! Be the lucky new owner of this hard to find mini-farm on peaceful, serene 10-acre square property with tranquil 1/3 acre pond. Charming late 1800's circa renovated farmhouse features 4 bedrooms, 2 1/2 baths & 3-car detached garage (each door/bay is 12x24 & has auto-openers). Exceptionally well-maintained outbuildings boasts an incredible 104x56 indoor riding arena, a 48x48 6-stall horse barn, 20x24 workshop & 4 covered equipment bays (each is 12x24). Water & electric in the horse barn, overhead lights in arena, electric (including outlet for welding) in workshop, & solar-powered electric pasture fence. Updated tack & feed rooms in horse barn, gravel circle drive around arena, & updated pasture fencing add to this wonderful setting. Combined kitchen & dining room. Remodeled kitchen features farmer's sink, newer appliances, island & new cabinets. Pocket doors off living room lead to main level owner's suite featuring an updated owner's suite bath. 1st floor laundry room. 2nd floor has 3 bedrooms & full bath. Updated 1/2 bath off kitchen can be converted back to full bath - for 3 total full baths. Access to covered porch off owner's suite. Enjoy pond views from many rooms. Pasture & hay field - hay reaps approximately $1800/year income (300 bales/$6 per bale). Wood pellet stove added to dining room. 6-zone mini-split heating/cooling system. Well pressure tank 2020. Whole house iron filter. Double-paned vinyl windows. Newer metal roof on home 2019 & vinyl-sided for minimal exterior maintenance. Stocked pond (12' to middle) has dock, deck & fire ring. Outdoor living space includes covered front porch & paver patio. All kitchen appliances, iron filter, & blanket racks & bridle hooks in tack room convey. Convenient to I-70, shopping, grocery & restaurants. Property is buffered on all 3 sides by nursery. Enjoy beautiful sunsets & sunrises each day! Property receives CAUV tax deduction. Clay Township - no city taxes.
MlsNumber: --
ListingId: 1036731


Listing Provided By: Sibcy Cline, Inc., original listing
Phone: (937) 239-0315
Office Phone: (937) 898-1234
Agent Name: Jackie Halderman
Disclaimer: Copyright © 2025 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.


Local Real Estate Expert

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 = 2094 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;
Real Estate Expert Photo for Paula Collins
Paula Collins
ASCIIHoward Hanna
Call Today!: (937) 271-4638

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App