Cathy Smith Realtor since 2000
Real Estate Sales, & Internet Marketing since 2000
REALTOR®, 2000000409
BEDS5
BATHS7 full 5 partial
SQUARE FEET12,784
MLS#1876487
STATUSActive
PROPERTY TYPEResidential - Single Family
SCHOOLForest Hills S
Property Description
A commanding estate of rare distinction, this 12,784 sq ft brick and stone home sits on 4.5 private acres with panoramic Ohio River and Kentucky hillside views. Located in prestigious Riverview Estates at Coldstream Country Club, it showcases timeless architecture, exceptional craftsmanship, and refined finishes throughout. Thoughtfully updated and meticulously maintained, features include soaring coffered and recessed ceilings, custom millwork, an elevator to all levels, integrated lighting and sound, and geothermal HVAC. Expansive upper and lower flagstone verandas with masonry fireplaces overlook a resort-style gunite pool and spa. Perfect for entertaining and taking in breathtaking sunsets. Four-car garage and elegant paver drive complete this extraordinary offering.
Property Features
Property Type: Residential - Single Family
Basement: Full
Basement: Yes
Cooling: Central Air, ENERGY STAR, Geothermal
Fireplaces: 2
Garage: 4
Heating: Forced Air, Gas, Gas Furn EF Rtd 95%+, Geothermal
Home Style: Traditional
Lot Size: 4.54 Acres
Roof Type: Shingle
Stories: 2.0
Taxes: $78,906
Year Built: 2013
Amenities
9Ft + Ceiling
Beam Ceiling
Cathedral Ceiling
Crown Molding
Elevator
Natural Woodwork
Vaulted Ceiling
Balcony
BBQ Grill
Covered Deck/Patio
Fireplace
Hot Tub
Patio
Porch
Sprinklers
Yard Lights
Feature Descriptions
Access: City Street
Appliances: Convection Oven, Dishwasher, Double Oven, Garbage Disposal, Gas Cooktop, Refrigerator, Wine Cooler
Association Includes: AssociationDues
Basement Fatures: Finished, Fireplace, Walkout
Days on Site: 1
Exterior: Stone
Family Room: Tile Floor, Fireplace, Wet Bar, Window Treatment
Fencing: Metal
Fireplace Features: Marble, Stone, Gas
Flex Rooms: Media Room, Bonus Room, Exercise Room, Solarium, Game Room, Wine Cellar, GuestSuite w/o Ktchn, Other
Foundation: Poured
Garage/Carport: Oversized, Garage Attached, Heated
Gas: Natural
HOA Fee: 1000/Annually
HOA Y/N: 1
Hot Tub: Yes
Kitchen: Butlers Pantry, Counter Bar, Eat-In, Gourmet, Island, Wood Floor
Mechanical Systems: Garage Door Opener, Humidifier, Security System, Sump Pump w/Backup
Miscellaneous: Ceiling Fan, Fountain, Home Warranty, Recessed Lights, Smoke Alarm
Parcel #: 5000184003500
Parking: Driveway
Primary Bathroom: Built-In Shower Seat, Double Shower, Tile Floor, Double Vanity, Heated Floors, Marb/Gran/Slate
Primary Bedroom: Bath Adjoins, Vaulted Ceiling, Walk-in Closet, Dressing Area, Fireplace, Sitting Room, Wood Floor
Rooms Total: 19
Security: yes
Sewer: Public Sewer
Smart Technology: Garage Door Opener, HVAC, Irrigation System, Lighting, Security
Special View Info: River
SQFT Basement: 6537
Study: Bookcases, Wall-to-Wall Carpet, French Doors, Window Treatment, Other
Swimming Pool: Gunite, Heated, In-Ground
Swimming Pool: Yes
Tax Abatement: No
Topography: Cleared, Sloped
Trees: Other
Water: Public
Water Heater: Gas, High Efficiency Tank
Window Features: Casement, Double Pane, Wood
Room Sizes
Primary Bedroom: 29 X 17 Level - 1
Bedroom 2: 23 X 17 Level - 2
Bedroom 3: 24 X 15 Level - 2
Bedroom 4: 18 X 17 Level - 2
Bedroom 5: 19 X 17 Level - 1
Dining Room: 17 X 12 Level - 1
Entry: 18 X 13 Level - 1
Family Room: 25 X 21 Level - 1
Laundry Room: 13 X 8 Level - 1
Recreation Room: 28 X 17 Level - Lower
Study/Den: 18 X 17 Level - 1
Local Schools
School District: Forest Hills S
Listed By / Shown By
Listed By
Agency Name: Sibcy Cline, Inc.
Agency Phone: 513-793-2121
Agent Name: Patrick Lach
Shown By
Agent Name: Cathy Smith Realtor since 2000
Agent Phone: Cell: (419) 280-3942
Agency Title: Key Realty
Estimate Your Payment
Estimated Payment
$ 35,708.14 per month $27,688.89 Principal & Interest $6,575.50 Property Tax $1,443.75 Homeowner's InsuranceChange Payment Information
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --
Agency License Information: 1-877-539-7589 | Ohio Lic# REC.2010002888 6800 W Central Ave #B, Toledo, OH 43617 | Michigan Lic# 6505366134 8040 Summerfield Rd, Lambertville, MI 48144 | Indiana Lic# RC52400106 3029 W Smith Valley Rd #211, Greenwood, IN 46142 | West Virginia LIC# 010306 Erin Rickman, Broker. 410 Market St #3, Parkersburg, WV, 26101 | Colorado LIC# EC.100108419 603 Rood Ave, Grand Junction, CO 81501 | Nevada LIC# B.0146350.LLC 9190 Double Diamond Pwky, Reno, NV 89521 | Florida LIC# CQ1073507 16638 Mooner Plank Cir, Wimauma, FL 33598
7951 Ayers Road | MLS# 1876487
This single family home located at 7951 Ayers Road, Anderson Twp, OH 45255 is currently listed for sale with an asking price of $4,950,000. This property was built in 2013 and has 5 bedrooms and 7 full and 5 partial baths with 12784 sq. ft. Ayers Road is located within the Forest Hills S school district. Search Anderson Twp real estate on cathysmith.ikeyrealty.com today.