Buy
  • Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
    Canada Listings (1342)
    Advanced Search
Rent Sell Find an Agent
LakeHouse.com LakeHouse.com
My Account
  • Login
  • Manage My Real Estate Ads
  • Manage My Search Profile / Auto Notify
  • My Account Info
  • Manage My Favorites
Advertise Join
  • Buy
  • Rent
  • Sell
  • Find an Agent
  • My Account
    • Login
    • Manage My Real Estate Ads
    • Manage My Search Profile / Auto Notify
    • My Account Info
    • Manage My Favorites
  • Advertise
  • Join
Back to Search Back to Listing LakeHouse.com logo
Share
LakeHouse.com logo
Ad #7599639
MLS #1886145
Listing photo

First time on the market since its full renovation and 6,500 SF

5 Twin Hills Ridge Dr, Cincinnati, OH 45230
$3,250,000
6Beds
9Baths
12,373Sqft
10.640Acres

About this property

First time on the market since its full renovation and 6,500 SF addition in 2001. Just 10 minutes from downtown Cincinnati, yet a world apart, this 10.6-acre estate in California, Ohio offers ultimate privacy and breathtaking details. Perched high on a hill, it captures sweeping views of the Ohio River Valley and unforgettable sunsets. A stone-column gated entry and tree-lined drive set the tone for the exceptional lifestyle that awaits. Inside, the home's heart is a chef's kitchen designed for both grand entertaining and intimate gatherings. For the auto enthusiast there's garage space for 10 vehicles. The detached garage provides a professional heated detailing bay, heated workshop, and second flood storage. Outdoor living is totally private with a three-level stone terrace, pool and hot tub. Additional luxuries can be found on the feature list. Every detail has been designed to combine comfort, security, and elegance in one extraordinary property.

Property Features

6 Beds
9 Baths
12,373 Sqft
Built in 1962
10.640 Acres
Ohio River
View Type: Valley, Golf Course, River
Riverview
Driveway
Siding: Brick, Stone, Stucco
Shingle Roof
Has Fireplace
Natural Gas, Forced Air
Hamilton County

Additional Photos

Additional listing photo 1
Additional listing photo 2
Additional listing photo 3
Additional listing photo 4

Contact Information

M. Ryan Motz

Ken Perry Realty

859-240-8229

Location

Map
Listing Agent: M. Ryan Motz 859-240-8229
Broker: Ken Perry Realty 859-240-8229 Listing Site
Copyright © 2026 MLS of Greater Cincinnati, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
LakeHouse.com
Printed Jul 28, 2026

Photo Gallery

First time on the market since its full renovation and 6,500 SF - photo 1
First time on the market since its full renovation and 6,500 SF - photo 2
First time on the market since its full renovation and 6,500 SF - photo 3
First time on the market since its full renovation and 6,500 SF - photo 4
First time on the market since its full renovation and 6,500 SF - photo 5
First time on the market since its full renovation and 6,500 SF - photo 6
First time on the market since its full renovation and 6,500 SF - photo 7
First time on the market since its full renovation and 6,500 SF - photo 8
First time on the market since its full renovation and 6,500 SF - photo 9
First time on the market since its full renovation and 6,500 SF - photo 10
First time on the market since its full renovation and 6,500 SF - photo 11
First time on the market since its full renovation and 6,500 SF - photo 12
First time on the market since its full renovation and 6,500 SF - photo 13
First time on the market since its full renovation and 6,500 SF - photo 14
First time on the market since its full renovation and 6,500 SF - photo 15
First time on the market since its full renovation and 6,500 SF - photo 16
First time on the market since its full renovation and 6,500 SF - photo 17
First time on the market since its full renovation and 6,500 SF - photo 18
First time on the market since its full renovation and 6,500 SF - photo 19
First time on the market since its full renovation and 6,500 SF - photo 20
First time on the market since its full renovation and 6,500 SF - photo 21
First time on the market since its full renovation and 6,500 SF - photo 22
First time on the market since its full renovation and 6,500 SF - photo 23
First time on the market since its full renovation and 6,500 SF - photo 24
First time on the market since its full renovation and 6,500 SF - photo 25
First time on the market since its full renovation and 6,500 SF - photo 26
First time on the market since its full renovation and 6,500 SF - photo 27
First time on the market since its full renovation and 6,500 SF - photo 28
First time on the market since its full renovation and 6,500 SF - photo 29
First time on the market since its full renovation and 6,500 SF - photo 30
First time on the market since its full renovation and 6,500 SF - photo 31
First time on the market since its full renovation and 6,500 SF - photo 32
First time on the market since its full renovation and 6,500 SF - photo 33
First time on the market since its full renovation and 6,500 SF - photo 34
First time on the market since its full renovation and 6,500 SF - photo 35
First time on the market since its full renovation and 6,500 SF - photo 36
First time on the market since its full renovation and 6,500 SF - photo 37
First time on the market since its full renovation and 6,500 SF - photo 38
First time on the market since its full renovation and 6,500 SF - photo 39
First time on the market since its full renovation and 6,500 SF - photo 40
First time on the market since its full renovation and 6,500 SF - photo 41
First time on the market since its full renovation and 6,500 SF - photo 42
First time on the market since its full renovation and 6,500 SF - photo 43
First time on the market since its full renovation and 6,500 SF - photo 44
First time on the market since its full renovation and 6,500 SF - photo 45
First time on the market since its full renovation and 6,500 SF - photo 46
First time on the market since its full renovation and 6,500 SF - photo 47
First time on the market since its full renovation and 6,500 SF - photo 48
First time on the market since its full renovation and 6,500 SF - photo 49
First time on the market since its full renovation and 6,500 SF - photo 50

$3,250,000

6
Beds
9
Baths
12,373
Sqft

5 Twin Hills Ridge Dr, Cincinnati, OH 45230

By contacting this agent you agree to these Terms and Conditions.
Home Ohio Ohio River
First time on the market since its full renovation and 6,500 SF - photo 1
First time on the market since its full renovation and 6,500 SF - photo 2
First time on the market since its full renovation and 6,500 SF - photo 3
First time on the market since its full renovation and 6,500 SF - photo 4
First time on the market since its full renovation and 6,500 SF - photo 5
MLS# 1886145
Home For Sale

First time on the market since its full renovation and 6,500 SF

$3,250,000

5 Twin Hills Ridge Dr, Cincinnati, OH 45230

6
Beds
9
Baths
12,373
Sqft
10.640
Acres
$3,250,000
5 Twin Hills Ridge Dr, Cincinnati, OH 45230
6 Beds
9 Baths
12,373 Sqft
10.640 Acres
First time on the market since its full renovation and 6,500 SF addition in 2001. Just 10 minutes from downtown Cincinnati, yet a world apart, this 10.6-acre estate in California, Ohio offers ultimate privacy and breathtaking details. Perched high on a hill, it captures sweeping views of the Ohio River Valley and unforgettable sunsets. A stone-column gated entry and tree-lined drive set the tone for the exceptional lifestyle that awaits. Inside, the home's heart is a chef's kitchen designed for both grand entertaining and intimate gatherings. For the auto enthusiast there's garage space for 10 vehicles. The detached garage provides a professional heated detailing bay, heated workshop, and second flood storage. Outdoor living is totally private with a three-level stone terrace, pool and hot tub. Additional luxuries can be found on the feature list. Every detail has been designed to combine comfort, security, and elegance in one extraordinary property.
12 days
on LakeHouse.com
29
views
0
saves

Property Details

HOME DETAILS

6 Beds
9 Baths
12,373 Sqft
Built in 1962
10.640 Acres

WATER & VIEW

Ohio River
View Type: Valley, Golf Course, River
Riverview

EXTERIOR

Driveway
Siding: Brick, Stone, Stucco
Shingle Roof

INTERIOR

Has Fireplace
Natural Gas, Forced Air

FINANCIAL & COMMUNITY

Hamilton County
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

About Ohio River

Looking for riverfront homes on Ohio River? Find river front real estate for sale here. Located in Hamilton County, Ohio. Discover the best river front listings - properties, lots, and acreage to build your dream house, cottage or cabin on. Search for an agent who specializes in waterfront property to help you buy or sell a home.

Ad Statistics

Ad Number
7599639
Viewed
29 times
Listing Status
Active
Added
Jul 15, 2026
Last Refresh
Jul 28, 2026 08:31:55 AM

Listing Information

Data Source
MLS of Greater Cincinnati, Inc.
Source Property ID
1886145
Listing Agent: M. Ryan Motz 859-240-8229
Broker: Ken Perry Realty 859-240-8229 Listing Site
Copyright © 2026 MLS of Greater Cincinnati, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Request Information

By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.

Start advertising today

Explore options for real estate agents and homeowners advertising on LakeHouse.com
Sell Your Home

Explore Similar Properties

No similar properties found.

SEARCH STATES
Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
MountainHomes.com BeachHouse.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 LakeHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.07.28
Terms & Policy

Search Filters
Price
-
0
$100,000
$100,000+
$200,000
$200,000+
$300,000
$300,000+
$400,000
$400,000+
$500,000
$500,000+
$600,000
$600,000+
$700,000
$700,000+
$800,000
$800,000+
$900,000
Any Price
Any Price
Beds & Baths
-
-
Property Type
Sale Status
More Filters
-
-
-
-
Advanced Search

Ohio River

Read more
Sort By: Featured
  • Featured
  • Newest
  • Price - Low To High
  • Price - High To Low
  • Sqft - Low To High
  • Sqft - High To Low

Ohio River Real Estate Agent Info

About Ohio River

Click to activate
Request Information
By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.
Contact Agent
By contacting this agent you agree to these Terms and Conditions.
Share this Ad
Link copied
Video/Virtual Tour
Loading...
SEARCH STATES
Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
MountainHomes.com BeachHouse.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 LakeHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.07.28
Terms & Policy