Hi There! Is this Your First Time?

Did you know if you Register you have access to free search tools including the ability to save listings and property searches? Did you know that you can bypass the search altogether and have listings sent directly to your email address? Check out our how-to page for more info.

  • Price$5,000,000
  • Beds5
  • Baths7
  • Acres91.00

1567 Tri County Hwy, Sterling Twp

Take A Majestic Drive Into A 92 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

Essential Information

  • MLS® #1540688
  • Price$5,000,000
  • Bedrooms5
  • Bathrooms7.00
  • Full Baths5
  • Half Baths2
  • Acres91.00
  • TypeResidential
  • Sub-TypeFarm
  • StatusActive


  • Parking Spaces12
  • ParkingDriveway
  • GaragesAttached, Detached, Oversized
  • ViewLake/Pond


  • Exterior FeaturesPatio, Balcony, Metal Fence, Yard Lights, Wooded Lot, Other
  • WindowsInsulated, Vinyl, Double Hung, Bay/Bow, Picture
  • RoofSlate
  • ConstructionStone
  • FoundationPoured

Additional Information

  • Date ListedJune 12th, 2017
  • Days on Market39
  • ZoningResidential, Agricultural

Community Information

  • Address1567 Tri County Hwy
  • AreaSterling Twp.
  • CitySterling Twp
  • CountyBrown
  • StateOH
  • Zip Code45176


  • Interior Features9Ft + Ceiling, Crown Molding, Natural Woodwork, Cathedral Ceiling, Vaulted Ceiling, Beam Ceiling, French Doors, Indoor Pool, Elevator, Other, Atrium
  • AppliancesOven/Range, Dishwasher, Garbage Disposal, Refrigerator, Microwave
  • HeatingElectric, Heat Pump
  • CoolingCentral Air
  • Has BasementYes
  • BasementFull
  • FireplaceYes
  • # of Fireplaces4
  • FireplacesGas, Brick, Stone

School Information

  • DistrictWestern Brown Local

Listing Details

  • Listing AgentJennifer M. Haubner, (859) 991-9035
  • Courtesy of Keller Williams Distinctive RE, (859) 331-3180

Similar Properties to 1567 Tri County Hwy

7855 Ayers Rd

Photo of Listing #1533962


  • 4 Beds
  • 7 Baths
  • 7.03 Acres


Anderson Twp, OH

Spotless 8 Yr Old Ross Brothers Resale In River View Estates Sitting On Over 7ac W/spectacular Views Of River. Old English Charm Meets Country Cottage Feel. 11,000sf Finished. Includes: Ponderosa Pine Beams, Quarter Sawn Floors, Onyx/marble/soap S... read more

9200 Shawnee Run Rd

Photo of Listing #1491218


  • 5 Beds
  • 9 Baths
  • 12.58 Acres


Indian Hill, OH

Alberly Manor. This 1926 English Manor Is An Architectural Work Of Art. The Manor And Grounds Were Expertly Designed To Inspire And Epitomize Grandeur, Graciousness And Poise. Today Alberly Manor Proudly Retains Its Original Integrity And Signific... read more

Courtesy of the MLS of Greater Cincinnati.

Information Deemed Reliable but Not Guaranteed.

Copyright 2017, MLS of Greater Cincinnati, Inc. All rights reserved.

Listing information last updated on July 21st, 2017 at 1:38pm CDT.

MLS® 1540688 is a Farm home located at 1567 Tri County Hwy in Sterling Twp OH. The property features 5 bedrooms and 7.00 bathrooms. This property is currently listed for $5,000,000.

This property comes with Electric and Heat Pump heating and Central Air cooling. The exterior features include Patio, Balcony, Metal Fence, Yard Lights, Wooded Lot and Other. The interior features include 9Ft + Ceiling, Crown Molding, Natural Woodwork, Cathedral Ceiling, Vaulted Ceiling, Beam Ceiling, French Doors, Indoor Pool, Elevator, Other and Atrium.

According to statistics, there are currently 28 listings for sale in Sterling Twp. The average listing price is $377,663, with the highest price being $5,000,000.

Please provide a valid email address.