If you need assistance, please call 513-368-3751

  • DESCRIPTION

    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

    KEY DETAILS
    • Price:
    • $4,500,000
    • Bedrooms:
    • 5
    • Full Baths:
    • 5
    • Half Baths:
    • 2
    • Square Footage:
    • n/a
    • Acreage:
    • 91.00
    • Year Built:
    • 2005
    • Listing ID #:
    • 1540688
    • Street Address:
    • 1567 Tri-County Hwy
    • City:
    • Sterling Twp
    • State:
    • OH
    • Postal Code:
    • 45176
    • County:
    • Brown
    • Area:
    • Brown-E11
    • Subarea
    • Sterling Twp.
    • Listing Status:
    • For Sale - Active

    Building

    • Age Of Dwelling:
    • 12
    • Architecture Style:
    • Victorian
    • Basement Description:
    • Finished, Concrete Floor, Other
    • Basement Type:
    • Full
    • Complex/Building Access:
    • County Road
    • Exterior Features:
    • Patio, Balcony, Yard Lights, Wooded Lot, Hot Tub, Other
    • Fireplace:
    • Gas, Brick, Stone
    • Foundation:
    • Poured
    • Interior Features:
    • 9ft + Ceiling, Crown Molding, Natural Woodwork, Cathedral Ceiling, Vaulted Ceiling, Beam Ceiling, French Doors, Elevator, Other
    • Miscellaneous Features:
    • Cable, Ceiling Fan, Recessed Lights, Smoke Alarm, 220 Volt, Other
    • Number Of Fireplaces:
    • 4
    • Siding:
    • Stone
    • Stories:
    • Three+
    • Total # Of Buildings:
    • Shed, Barn, Stable, Other
    • Type Of Roof:
    • Slate
    • View:
    • Lake/Pond
    • Windows:
    • Insulated, Vinyl, Double Hung, Bay/Bow, Picture
    • Year Built:
    • 2005

    Land

    • Conforms To Zoning:
    • Residential, Agricultural
    • Farm Type:
    • Horse, Cattle, Recreational, Dairy, Poultry, Sheep, Crop(grain, Corn, Soy)
    • Lot Description:
    • 50 To 99 Acres
    • Lot Square Footage:
    • 3963960.00
    • Topography:
    • Cleared, Level, Pasture

    Listing

    • Days On Market:
    • 182
    • Price Per Acre:
    • 49450.55

    Rooms

    • Bathroom #1 On Level:
    • 2
    • Bathroom #2 On Level:
    • 2
    • Bathroom #3 On Level:
    • 2
    • Bedroom #2 Dimensions:
    • 18 X 17
    • Bedroom #3 Dimensions:
    • 17 X 13
    • Bedroom #4 Dimensions:
    • 13 X 10
    • Bedroom #5 Dimensions:
    • 14 X 10
    • Dining Room:
    • Yes
    • Dining Room Area:
    • 555
    • Dining Room Dimensions:
    • 37 X 15
    • Dining Room Length:
    • 37 Ft
    • Dining Room Width:
    • 15 Ft
    • Family Room:
    • Yes
    • Family Room Dimensions:
    • 748
    • Family Room Length:
    • 34 X 22 Ft
    • Kitchen:
    • Tile Floor, Eat-In, Gourmet, Wood Cabinets, Island, Walkout, Planning Desk, Butler's Pantry, Other
    • Kitchen Area:
    • 520
    • Kitchen Dimensions:
    • 26 X 20
    • Kitchen Room Length:
    • 26 Ft
    • Kitchen Room Width:
    • 20 Ft
    • Living Room:
    • 35x22 Level: 1
    • Master Bedroom Area:
    • 660
    • Master Bedroom Description:
    • 30x22 Level: 2
    • Master Bedroom Dimensions:
    • 30 X 22
    • Recreation Room Width:
    • 0 X 0
    • Total Rooms:
    • 16

    Structures

    • Garage Parking Spaces:
    • 12.00
    • Garage Type:
    • Attached, Detached, Oversized
    • Parking Description:
    • Garage Attached, Garage Detached, Oversized

    Systems

    • Appliances:
    • Oven/Range, Dishwasher, Garbage Disposal, Refrigerator, Microwave
    • Cooling System:
    • Central Air
    • Gas:
    • Natural
    • Heating:
    • Electric, Heat Pump
    • Sewage Type:
    • Septic

    Source

    • Listing Provided By: Jennifer M. Haubner of Keller Williams Distinctive RE (859-991-9035)

      CINCY
    REQUEST SHOWING
    WHAT'S NEARBY
    Loading

    Yelp
    SCHOOL RATINGS
    n/a

    CALL SD 937-444-2044
    Elementary School
    Public

    NOTES

    No notes have been added for this home.

    CONTACT AN AGENT


    By submitting this form, you agree to our Terms of Use & Privacy Policy.

    SCORECARD

    0
    PROS
    0
    CONS
    Condition
    Location
    Nearby
    Schools
    Taxes
  • Add Note
  • Add to Notebook
  • Share