Seller's Agent in 2025
Billy Belshaw
Comey & Shepherd
(513) 800-0330
4 in this area
59 Total Sales
This historic Queen Anne mansion in Clifton Gaslight, cherished by only two owners since 1942. A masterpiece of preserved craftsmanship, it boasts exquisite original features, including imported woodwork, German fireplace mantels and tile, stained glass throughout, functional pocket doors, hand-painted ceiling murals, and a slate roof with copper gutters. Modern upgrades enhance its grandeur, featuring a gourmet kitchen, an expansive primary suite with laundry, updated HVAC, and a fully renovated exterior. Could be a grand single family or an income generating property with many options for multiple units/short term rentals. Current owners live on first two floors and generate $4,600 in monthly rental income from just the third floor and studio units. Total potential rental income around $9000+ monthly. Outdoor entertaining is elevated with a .23-acre additional parcel, while a 5-car garage/carriage house provides ample off-street parking.
Last Agent to Sell the Property
Comey & Shepherd License #2015005470 Listed on: 08/26/2025
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 11/12/2025 11/12/25 | Sold | $860,000 | -0.6% | $158 / Sq Ft | |
| 10/20/2025 10/20/25 | Pending | -- | -- | -- | |
| 08/26/2025 08/26/25 | For Sale | $865,000 | -3.9% | $159 / Sq Ft | |
| 07/25/2025 07/25/25 | Price Changed | $900,000 | -4.3% | $166 / Sq Ft | |
| 06/30/2025 06/30/25 | Price Changed | $940,000 | -5.5% | $173 / Sq Ft | |
| 05/01/2025 05/01/25 | For Sale | $995,000 | 0.0% | $183 / Sq Ft | |
| 04/15/2025 04/15/25 | Off Market | $995,000 | -- | -- | |
| 04/11/2025 04/11/25 | For Sale | $995,000 | 0.0% | $183 / Sq Ft | |
| 04/09/2025 04/09/25 | Off Market | $995,000 | -- | -- | |
| 01/09/2019 01/09/19 | Off Market | $450,000 | -- | -- | |
| 08/30/2018 08/30/18 | Sold | $450,000 | -9.8% | $83 / Sq Ft | View Prior Sale |
| 07/18/2018 07/18/18 | Pending | -- | -- | -- | |
| 06/04/2018 06/04/18 | For Sale | $499,000 | -- | $92 / Sq Ft |
Seller's Agent in 2025
Billy Belshaw
Comey & Shepherd
(513) 800-0330
4 in this area
59 Total Sales
Buyer's Agent in 2025
Milford Allen
Plum Tree Realty
(513) 703-8151
1 in this area
54 Total Sales
D
Buyer's Agent in 2025
Default zSystem
zSystem Default
A
Seller's Agent in 2018
Adam Sanregret
Keller Williams Advisors
Seller Co-Listing Agent in 2018
Amber Zaragoza
eXp Realty
(513) 814-7654
10 Total Sales
Buyer Co-Listing Agent in 2018
Andrea Destefano
Sibcy Cline
(513) 309-3184
343 Total Sales
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1852985