5114 Cleves Warsaw Pike Green Twp. - Hamilton Co., OH 45238
3
Bed
3/1
Bath
4,891
Sq. Ft
8.52
Acres
$1,599,900
MLS# 1853955
3 BR
3/1 BA
4,891 Sq. Ft
8.52 AC
Photos
Map
Photos
Map
More About 5114 Cleves Warsaw Pike
Showings beginning 09/09. Behind iron gates on Cincinnati's Westside lies historic Covedale Gables, a 1921 Tudor estate spanning nearly 9 acres of pastures & woodlands. Designed by R.C. Hunter & Brothers, the estate begins with a charming gate lodge before opening to the 4,000+ sqft main residence, featuring 3 beds and 3.5 baths. The marble & limestone-clad foyer, arched doorways, & grand staircase set the tone for elegant living. Highlights include a richly wood-paneled living room with decorative plaster ceilings, a travertine solarium with French doors to a heart-shaped terrace, & a concealed prohibition-era speakeasy. Entertain in the formal dining room, then retreat upstairs to the primary suite with dual closets & en-suite. Guestrooms feature timeless character and a balcony overlooking the grounds. With original details, 2 detached garages, & the original staff quarters nearby, this estate offers unmatched history, architecture, & opportunity for private living or redevelopment.
Connect with a loan officer to get started!
Information Refreshed: 12/19/2025 7:49 AM
Property Details
MLS#:
1853955Type:
Single FamilySq. Ft:
4,891County:
HamiltonAge:
104Appliances:
Oven/Range, Dishwasher, Refrigerator, Microwave, Washer, Dryer, Electric CooktopArchitecture:
Historical, TudorBasement Type:
FullConstruction:
Stone, StuccoCooling:
Window UnitFireplace:
Wood, Ceramic, InoperableFlex Room:
SolariumGarage:
Garage Detached, OversizedGarage Spaces:
4Gas:
NaturalHeating:
Gas, Hot Water, RadiatorInside Features:
Multi Panel Doors, French Doors, 9Ft + Ceiling, Crown Molding, Natural WoodworkKitchen:
Wood Cabinets, Tile Floor, Window TreatmentMechanical Systems:
Central Vacuum, Garage Door OpenerMisc:
Laundry Chute, Fountain, Smoke Alarm, Attic StorageParking:
Asphalt, DrivewayPrimary Bedroom:
Wood Floor, Bath Adjoins, Walk-in Closet, Dressing Area, Window TreatmentS/A Taxes:
6132School District:
Cincinnati Public SchoolsSewer:
Public SewerView:
WoodsWater:
Public
Rooms
Bath 1:
F (Level: 2)Bath 2:
F (Level: 2)Bath 3:
F (Level: L)Bath 4:
P (Level: 1)Bedroom 1:
19x19 (Level: 2)Bedroom 2:
16x12 (Level: 2)Bedroom 3:
15x9 (Level: 2)Breakfast Room:
10x6 (Level: 1)Dining Room:
19x16 (Level: 1)Entry:
23x16 (Level: 1)Kitchen:
15x9 (Level: 1)Laundry Room:
17x15 (Level: Lower)Living Room:
35x15 (Level: 1)Study:
13x12 (Level: 1)
Online Views:
0This listing courtesy of Rakesh Ram (513) 608-1199, Grayson Combs (513) 614-4575, Coldwell Banker Realty (513) 922-9400
Lifestyle in the Surrounding Area
Monthly Cost
Mortgage Calculator
*The rates & payments shown are illustrative only.
Payment displayed does not include taxes and insurance. Rates last updated on 12/18/2025 from Freddie Mac Primary Mortgage Market Survey. Contact a loan officer for actual rate/payment quotes.
Payment displayed does not include taxes and insurance. Rates last updated on 12/18/2025 from Freddie Mac Primary Mortgage Market Survey. Contact a loan officer for actual rate/payment quotes.

Sell with Sibcy Cline
Enter your address for a free market report on your home. Explore your home value estimate, buyer heatmap, supply-side trends, and more.
Must reads
The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc. Those listings held by brokerage firms other than Sibcy Cline, Inc. are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity. Copyright© 2022 Multiple Listing Services of Greater Cincinnati / All Information is believed accurate, but is NOT guaranteed.



