745 Yale Avenue, Terrace Park, OH 45174 (MLS # 1879720)
Twitter
Facebook
Email
|
From the gorgeous swimming pool with fountains to the full stage in the lower level - this Terrace Park home has it all! Open and bright with high ceilings throughout incl. a 15 ft barrel-vaulted ceiling in the study, high end finishes, every bedroom with an attached bath and large walk-in closet (one bedroom has 3!). Primary suite with vaulted ceiling, 2 walk-ins and large bath, huge first floor laundry and mudroom, formal butler's pantry, amazing finished lower level with fireplace, wet bar, bonus room/5th bed with walk-in closet, half bath, new gorgeous home gym AND a full performance stage with theater lighting! Walls of windows and french doors open to a lush, fully fenced and private backyard oasis with monumental outdoor fireplace and in-ground swimming pool with cascading water feature and an auto-retractable cover, surrounded by a stunning travertine terrace overlooking the lawn! Oversized 3-car attached garage, amazing craftmanship inside & out - unbeatable village location!
| DAYS ON MARKET | 3 | LAST UPDATED | 5/19/2026 |
|---|---|---|---|
| YEAR BUILT | 2007 | COMMUNITY | Hamilton-E08 |
| GARAGE SPACES | 3.0 | COUNTY | Hamilton |
| STATUS | Active | PROPERTY TYPE(S) | Single Family |
| ADDITIONAL DETAILS | |
| AIR | Central Air |
|---|---|
| AIR CONDITIONING | Yes |
| APPLIANCES | Gas Water Heater |
| AREA | Hamilton-E08 |
| BASEMENT | Finished, Full, Yes |
| CONSTRUCTION | Fiber Cement, Stone |
| FIREPLACE | Yes |
| GARAGE | Attached Garage, Yes |
| HEAT | Forced Air |
| INTERIOR | Eat-in Kitchen, Kitchen Island, Pantry, Walk-In Closet(s) |
| LOT | 0.3214 acre(s) |
| PARKING | On Street, Driveway, Attached |
| POOL | Yes |
| POOL DESCRIPTION | In Ground |
| SEWER | Septic Tank |
| STORIES | 2 |
| STYLE | Traditional |
| UTILITIES | Natural Gas Available |
| WATER | Public |
| ZONING | Residential |
MORTGAGE CALCULATOR
TOTAL MONTHLY PAYMENT
0
P
I
*Estimate only
| SATELLITE VIEW |
| / | |
We respect your online privacy and will never spam you. By submitting this form with your telephone number
you are consenting for Angela
Sexton to contact you even if your name is on a Federal or State
"Do not call List".
Listing provided by Sibcy Cline, Inc., phone# 513-793-2121, Steve Early, phone# 513-382-1218
The data relating to real estate for sale on this web site comes in part from the Broker
Reciprocity™ program of the Multiple Listing Service of Greater Cincinnati. Real estate
listings held by brokerage firms other than Coldwell Banker are marked with
the Broker Reciprocity™ logo (the small house as shown to the left) and detailed
information about them includes the name of the listing brokers.
Information Deemed Reliable but Not Guaranteed.
Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved.
Data last updated: 5/22/26 10:08 AM PDT
This IDX solution is (c) Diverse Solutions 2026.