Emily Foebar

Sales Associate

  • Listing status icon

    $4,500,000

  • Active | MLS#: 1540688
  • 5Beds
  • 7Baths

1567 Tri County Highway Sterling Twp, OH 45176

Favorite
Share
Close
Info Visit Search

Overview

Take A Majestic Drive Into A 91 Ac Farm*Private Gated Entry*A Must See Estate*Faithfully Maintained*5 Bedroom Mansion Surrounded By A Private Tree Line*6 Car Garage*5 Bay Barn*Amish Build Equestrian Horse Barn*15 Min. From Dwntwn Cin*Extravagant Architecture*Dual Atrium Staircase Entryway*Elevator*Stained Glass*Grand Master Ste*Spa Pool In Basement

Listing provided courtesy of: Keller Williams Distinctive Real Estate Services, Jennifer Haubner: 859-331-3180

General Features

  • Residential Sub-Type Farm
  • Acreage 91
  • Hoa No
  • Hoa Fee N/A
  • Auction No
  • Available for Lease No
  • Documents Available Aerial Photo
  • Occupancy Negotiable
  • New Construction No
  • Semi-Annual Taxes 8,000
  • County Brown
  • Days on Market 127

Building Features

  • Foundation Poured
  • Degree Complete Existing Structure
  • Appliances Oven/Range, Dishwasher, Garbage Disposal, Refrigerator, Microwave
  • Architecture Victorian
  • Basement Full
  • Basement Features Finished, Concrete Floor, Other
  • Disability Access Yes
  • Heating Electric,Heat Pump
  • Cooling Central Air
  • Levels Three
  • Garage Attached,Detached,Oversized
  • Garage Spaces 12.00
  • Parking Driveway
  • Windows Insulated, Vinyl, Double Hung, Bay/Bow, Picture
  • Structures Horse Barn, Workshop, Tractor Barn, Misc Shed
  • Roof Slate
  • # of Fireplaces 4
  • Fireplace Description Gas,Brick,Stone
  • Construction Stone

Room Features

  • Master Bedroom 30x22 Level: 2
  • Master Bedroom Features Wall-to-Wall Carpet, Bath Adjoins, Walk-in Closet, Dressing Area, Sitting Room, Fireplace, Vaulted Ceiling, Other
  • Bedroom 2 18x17 Level: 2
  • Bedroom 3 17x13 Level: 2
  • Bedroom 4 13x10 Level: 3
  • Bedroom 5 14x10 Level: 3
  • Entry 27x13 Level: 1
  • Entry/Foyer Wall-to-Wall Carpet,Open Foyer,Double Doors,Other
  • Living/Great Room 35x22 Level: 1
  • Living Room Features Wall-to-Wall Carpet,Fireplace,Bookcase,Other
  • Dining Room 37x15 Level: 1
  • Dining Room Features Wall-to-Wall Carpet, Chandelier, Chair Rail, Walkout, French Doors, Fireplace, Other
  • Kitchen 26x20 Level: 1
  • Formal Dining Room Yes
  • Family Room 34x22 Level: 1
  • Family Room Features Wood Floors, Fireplace, Other
  • Study Features Wall-to-Wall Carpet,Other
  • Study/Library/Den 10x7 Level: 1

Property Features

  • Access County Road
  • Buildings Storage Shed, Barn, Stable, Other
  • Farm Type Horses, Cattle, Recreational, Dairy, Poultry, Sheep, Crop(Grain, Corn, Soy)
  • Fencing Miscellaneous Welded Wire
  • Land Description 50 to 99 Acres
  • Gas Natural
  • Sewer Septic
  • Water Source Public
  • Topography Cleared, Level, Pasture
  • View Lake/Pond

Schools

  • School District Western Brown Local

Listing agent photo

Emily Foebar

513-512-9898Anderson Office

Ask a Question

Price & Status History

Days on Market

  • This property has been listed on the market for 184 days
  • Average days-on-market for homes between $3,600,000 - $5,400,000 = 184 (in zip code 45176)

Location

The property map location is: Accurate, based on Google's address match.

Walk Score

Get the Walk Score Report

Home Valuation

Get the Home Value Report
Share Report

Share this report with a friend

Get Monthly Update

Save my Home Value Report

Updated report will be emailed every 4 weeks.

Listing agent photo

Emily Foebar

513-512-9898Anderson Office

Ask A Question

Community Demographics for Zip Code 45176 (Sterling Twp)

Housing Occupancy
  • Home Owners: 2,444 (65%)
  • Renters: 633 (17%)
  • Vacant: 693 (18%)
  • Total Housing Units: 3,770
Households
  • Average Household Size: 2.68
  • Housing Density (People per square mile): 158
Age Range (number of people)
  • Age 0-14: 1,695
  • Age 15-24: 1,107
  • Age 25-39: 1,591
  • Age 40-59: 2,086
  • Age 60-79: 1,547
  • Age 80+: 290
  • Total: 8,316

* All numbers in this section are 2016 projections provided by Geolytics Inc

School Information for 45176 (Sterling Twp)

Public Schools in Zip Code 45176 (Sterling Twp)

* This list of schools may not match the property above.

WILLIAMSBURG HIGH SCHOOL 500 SOUTH 5TH ST WILLIAMSBURG, OH 45176 Phone: 5137242211 6th-12th
Grade Size Distribution
  • 6th: 72
  • 7th: 83
  • 8th: 86
  • 9th: 103
  • 10th: 79
  • 11th: 69
  • 12th: 56
School Population
  • Teachers: 29
  • Students per Teacher: 18.9
  • Students: 548
  • Male/Female: 281/265
School District
  • WILLIAMSBURG LOCAL
  • 549A WEST MAIN ST WILLIAMSBURG, OH 45176
  • Phone: 5137243077
District Population
  • Schools: 2
  • Full-Time Teachers: 60
  • Students per Teacher: 17.3
  • Staff: 116
  • Students: 1042
WILLIAMSBURG ELEMENTARY SCHOOL 839 SPRING ST WILLIAMSBURG, OH 45176 Phone: 5137242241 PreK-5th
Grade Size Distribution
  • PreK: 19
  • Knd: 74
  • 1st: 95
  • 2nd: 90
  • 3rd: 64
  • 4th: 70
  • 5th: 82
School Population
  • Teachers: 28
  • Students per Teacher: 17.6
  • Students: 494
  • Male/Female: 244/244
School District
  • WILLIAMSBURG LOCAL
  • 549A WEST MAIN ST WILLIAMSBURG, OH 45176
  • Phone: 5137243077
District Population
  • Schools: 2
  • Full-Time Teachers: 60
  • Students per Teacher: 17.3
  • Staff: 116
  • Students: 1042

* School data provided by US Department of Education


The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity™ program of the Multiple Listing Service of Greater Cincinnati. Real estate listings held by brokerage firms other than Huff Realty are marked with the Broker Reciprocity™ logo and detailed information about them includes the name of the listing brokers. This data is up-to-date as of 12/13/2017 2:34 PM PST.



* Rates and payment information listed in the mortgage calculator are provided as for general reference only. Specific mortgage information should be verified with a qualified lending professional