If you need assistance, please call 937-304-7307

1567 Tri County Hwy, Sterling Twp, OH 45176
5 Beds
7 Baths
17,348 sqft

Share

   
OR
Photos
Map
Street
Tour
Welcome to Daydream Manor! This one-of-a-kind priv 91 acre estate & horse farm is loc in Williamsburg OH, just 20 min from I-275. Feat over 10,000 sqft, this exquisite masterpiece was built in 2005 w/5 bdrms,7 baths,elevator,indoor swim spa,gated entry,gar space for 26 vehicles,Amish built 60 x 90 barn w/ indoor riding arena, slate roof & much more
  • Price:
  • $3,495,000
  • Bedrooms:
  • 5
  • Full Baths:
  • 4
  • Half Baths:
  • 3
  • Square Footage:
  • 17,348
  • Acreage:
  • 90.21
  • Year Built:
  • 2005
  • Listing ID #:
  • 1607529
  • Street Address:
  • 1567 Tri County Hwy
  • City:
  • Sterling Twp
  • State:
  • Ohio
  • Postal Code:
  • 45176
  • County:
  • Brown
  • Listing Status:
  • Active
  • Architecture Style:
  • Tudor
  • Basement Description:
  • Concrete Floor, Finished, Walkout, Other
  • Basement Type:
  • Full
  • Exterior Features:
  • Balcony, Covered Deck/Patio, Entertain Ctr, Fireplace, Patio, Yard Lights, Other
  • Fireplace:
  • Brick, Gas, Stone
  • Foundation:
  • Poured
  • Interior Features:
  • 9ft + Ceiling, Beam Ceiling, Cathedral Ceiling, Crown Molding, Elevator, French Doors, Heated Floors, Multi Panel Doors, Natural Woodwork, Vaulted Ceiling, Other
  • Miscellaneous Features:
  • 220 Volt, Ceiling Fan, Fountain, Recessed Lights, Smoke Alarm, Other
  • Number Of Fireplaces:
  • 4
  • Siding:
  • Stone
  • Stories:
  • Three+
  • Total # Of Buildings:
  • Pole Barn, Shed, Stable, Workshop
  • Total Building Square Footage:
  • 17348
  • Type Of Roof:
  • Slate
  • Windows:
  • Bay/Bow, Casement, Wood
  • Year Built:
  • 2005
  • Conforms To Zoning:
  • Residential, Agricultural
  • Lot Description:
  • 50 To 99 Acres
  • Lot Square Footage:
  • 3929548.00
  • Topography:
  • Cleared, Level
  • Days On Market:
  • 100
  • Price Per Acre:
  • 38742.93
  • Bathroom #1 On Level:
  • 2
  • Bathroom #2 On Level:
  • 2
  • Bathroom #3 On Level:
  • 2
  • Bedroom #2 Dimensions:
  • 19 X 19
  • Bedroom #3 Dimensions:
  • 18 X 14
  • Bedroom #4 Dimensions:
  • 19 X 12
  • Bedroom #5 Dimensions:
  • 15 X 15
  • Dining Room:
  • Yes
  • Dining Room Area:
  • 464
  • Dining Room Dimensions:
  • 29 X 16
  • Dining Room Length:
  • 29 Ft
  • Dining Room Width:
  • 16 Ft
  • Family Room:
  • Yes
  • Family Room Dimensions:
  • 667
  • Family Room Length:
  • 29 X 23 Ft
  • Kitchen:
  • Butler's Pantry, Counter Bar, Eat-In, Gourmet, Island, Planning Desk, Tile Floor, Walkout, Window Treatment, Wood Cabinets
  • Kitchen Area:
  • 520
  • Kitchen Dimensions:
  • 26 X 20
  • Kitchen Room Length:
  • 26 Ft
  • Kitchen Room Width:
  • 20 Ft
  • Laundry:
  • 14x10 Level: 1
  • Living Room:
  • 40x24 Level: 1
  • Master Bedroom Area:
  • 736
  • Master Bedroom Description:
  • 32x23 Level: 2
  • Master Bedroom Dimensions:
  • 32 X 23
  • Recreation Room Width:
  • 46 X 26
  • Total Rooms:
  • 20
  • Garage Parking Spaces:
  • 26.00
  • Parking Description:
  • Built In, Garage Attached, Garage Detached, Heated
  • Appliances:
  • Double Oven, Electric Cooktop, Garbage Disposal, Microwave, Oven/Range, Refrigerator, Warming Drawer
  • Cooling System:
  • Central Air
  • Heating:
  • Electric, Heat Pump
  • Sewage Type:
  • Septic
$

$

%

$

$

$


The amounts for the Tax, Insurance, and HOA are estimates and not actual amounts.

Your Payment
$1,400/mo
  • Courtesy of Brian P. Leisgang of Coldwell Banker West Shell (513-519-7200)
  • Copyright © 2019 Multiple Listing Services of Greater Cincinnati / All Information is believed accurate, but NOT guaranteed.
    The data relating to real estate for sale on this Web site comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc. Those listings held by brokerage firms other than are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity. Data on this site was last updated: April 25, 2019
    CINCY
  • Broker: Mike Sogard (937-304-7307)

Similar Properties

Image Unavailable
ACTIVE
$3,600,000
8950 Given Rd, Indian Hill, OH 45243
0 Beds | 0 Baths
CINCY Courtesy of Ryan K. Gehris of Usrealty.Com Llp (866-807-9087)
Image Unavailable
ACTIVE
$3,795,000
8875 Fawnmeadow Ln, Indian Hill, OH 45242
6 Beds | 7.5 Baths
CINCY Courtesy of Carol Harris of Comey & Shepherd (513-703-1203)
Image Unavailable
ACTIVE
$3,389,000
7180 Given Rd, Indian Hill, OH 45243
6 Beds | 7.5 Baths
CINCY Courtesy of Beth Bokon Onthank of Sibcy Cline (513-505-8815)