$900,000
$95K PRICE DROP

Estimated payment $5,695/month

Total Views 11,989
6 Beds
5.5 Baths
5,436 Sq Ft
$166 Price per Sq Ft

Highlights

  • Eat-In Gourmet Kitchen
  • City View
  • Living Room with Fireplace
  • Walnut Hills High School Rated A+
  • 0.46 Acre Lot
  • 4-minute walk to Clifton Plaza

About This Home

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.

Listing Agent

Billy Belshaw

Comey & Shepherd License #2015005470 Listed on: 04/04/2025

Comey & Shepherd

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1885

Lot Details

  • 0.46 Acre Lot
  • Lot Dimensions are 100x200
  • Aluminum or Metal Fence
  • Property is zoned Residential,Multi Family

Parking

  • 5 Car Detached Garage
  • Driveway
  • Off-Street Parking

Home Design

  • Brick Exterior Construction
  • Stone Foundation
  • Slate Roof
  • Membrane Roofing
  • Wood Siding

Interior Spaces

  • 5,436 Sq Ft Home
  • Woodwork
  • Crown Molding
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Wood Burning Fireplace
  • Gas Fireplace
  • Double Hung Windows
  • Panel Doors
  • Living Room with Fireplace
  • 4 Fireplaces
  • Wood Flooring
  • City Views
  • Unfinished Basement
  • Basement Fills Entire Space Under The House

Kitchen

  • Eat-In Gourmet Kitchen
  • Oven or Range
  • Gas Cooktop
  • Dishwasher
  • Kitchen Island
  • Solid Wood Cabinet
  • Disposal

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Main Floor Bedroom
  • Walk-In Closet

Outdoor Features

  • Balcony
  • Patio
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Gas
  • Gas Water Heater

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Year Built

Built in 1885

Lot Details

0

Parking

5

Listing Details

  • Suburb: Clifton
  • Cross Street: Clifton Ave & Glenmary Ave
  • Land Description: Less than .5 Acre
  • Access: City Street
  • Broker Approved: Yes
  • Miscellaneous: Ceiling Fan
  • Basement Sq Ft: 2309
  • Census Tract Realist: 71.00
  • Cooling: Central Air
  • Heating: Forced Air, Gas
  • Lot Area Realist: 9975.00
  • Sub Lease Expiration Date: 1800-01-01T00:00:00.000-05:00
  • Suburb S I C: Clifton
  • Taxes Annual: 0
  • Price Per Acre: 1965065.50
  • Public Transportn: Cincinnati Metro
  • Zoning: Residential,Multi Family
  • Basement Features: Unfinished
  • Bathroom 4: Full
  • Bathroom 4 Level: 3
  • Level 1 Bathroom Type: Full, Partial
  • Level 1 Bathroom: Yes
  • Bedroom 5 Area: 192
  • Level 1 Bedroom: Yes
  • Dining Room Feat: Fireplace, Wood Floor
  • Entry Area: 77
  • Entry Foyer: Open Foyer, Wood Floor
  • Living Great Rm Area: 300
  • Living Great Rm Dim: 20 x 15
  • Living Great Rm Len: 20
  • Living Great Rm Wid: 15
  • Living Room Feat: Bookcases, Fireplace, Wood Floor
  • Single Family Desc: Single Family
  • Study Lib Den: 16x14 Level: 1
  • Study Lib Den Area: 224
  • Study Lib Den Dim: 16 x 14
  • Study Lib Den Len: 16
  • Water Heating: Gas
  • Year Built: 1885
  • Architecture: Historical
  • Full Bathrooms: 5
  • Half Bathrooms: 1
  • Bedrooms: 6
  • Directions: Ludlow Ave, North on Clifton Ave
  • Lot Measurement: Acres
  • Status: Active
  • Property Subtype 1: Single Family Residence
  • Occupancy: At Closing
  • Second Floor Area: 2267
  • ADU Y/N: No
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Crown Molding, Multi Panel Doors, Natural Woodwork
  • Bedroom 2: 15x12 Level: 2
  • Bedroom 3: 18x13 Level: 2
  • Bedroom 4: 17x14 Level: 3
  • Bedroom 5: 16x12 Level: 3
  • Dining Room: 15x18 Level: 1
  • Living Room: 20x15 Level: 1
  • Flex Rooms: Other
  • Property Type: Residential
  • Other Tax Parcel I D: 214-0004-0003-00
  • Reciprocal Listing: No
  • Semi Annual Taxes: $0
  • Appliances: Dishwasher, Garbage Disposal, Gas Cooktop, Oven/Range
  • Kitchen Features: Pantry, Eat-In, Gourmet, Island, Wood Cabinets, Wood Floor
  • Bedroom 2 Area: 180
  • Basement: Full
  • Bedroom 3 Area: 234
  • Study Features: Wood Floor
  • Bedroom 4 Area: 238
  • Entry: 11x7 Level: 1
  • Bathrooms: 6.00
  • Kitchen Area: 195
  • Kitchen Dim: 15 x 13
  • Levels: Three+
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Level 1 Bath: 2
  • Bathroom 2: Full
  • Bathroom 2 Level: 2
  • Bathroom 3: Full
  • Bathroom 3 Level: 3
  • Diningroom Area: 270
  • Laundryroom Dim: 0 x 0
  • Recreation Room Dim: 0 x 0
  • Fireplace: Gas, Wood
  • Fireplaces: 4
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 5436.00
  • Total Rooms: 15
  • Windows: Storm, Double Hung, Wood
  • PrimaryBedroomArea: 288
  • PrimaryBedroomDim: 18 x 16
  • PrimaryBedroomLen: 18
  • Primary Bathrooms: Shower, Tile Floor, Tub, Marb/Gran/Slate
  • PrimaryBedFeat: Walk-in Closet, Dressing Area, Fireplace, Wood Floor
  • P R I M A R Y B E D R O O M: 18x16 Level: 2

Exterior Features

  • View: City
  • Fencing: Metal
  • Roof: Slate, Membrane
  • Construction: Brick, Stone, Wood Siding
  • Outside Features: Balcony, Patio, Porch
  • Foundation: Stone
  • Listing Price: 900000.00
  • Acres: 0.4580
  • New Construction: No

Garage/Parking

  • Garage Spaces: 5.00
  • Garage Carport: Garage Detached
  • Parking: Off Street, Driveway

Utilities

  • Gas: Natural
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • HOA Yes/No: No
  • Association: Cincinnati Area Multiple Listing Service

Schools

  • District: Cincinnati City SD

Lot Info

  • Lot Dimensions: 100x200
  • Lot Size Sq Ft: 19950.00
  • Total Assessed Value: Of Record

Rental Info

  • Sub Lease: No

Tax Info

  • Tax Abatement: No

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Property History

Date Event Price Change Sq Ft Price
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
07/18/2018 07/18/18 Pending -- -- --
06/04/2018 06/04/18 For Sale $499,000 -- $92 / Sq Ft
Source: MLS of Greater Cincinnati (CincyMLS)

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1836188

MLS of Greater Cincinnati (CincyMLS)