$865,000

Estimated payment $5,569/month

Total Views 824
6 Beds
5.5 Baths
5,436 Sq Ft
$159 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: 08/26/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: 1888646.29
  • 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: 865000.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)

Similar Homes in Cincinnati, OH

  • 163 Compton Rd, Cincinnati, OH 45215

    $1,049,000

    • 5 Beds
    • 6 Baths
    • 5,054 Sq Ft
    • 163 Compton Rd
    • Cincinnati, OH

    Welcome to 163 Compton Rd! This stunning home in the Wyoming school district offers luxury and space with 5 bedrooms, 6 full baths, and incredible curb appeal. The gourmet kitchen, huge first-floor primary suite with an ensuite and bidet, and massive media room provide modern comfort. The finished basement features a second kitchen/bar, bath, bedroom, and exercise room! With natural light and a

    Robert Smith Coldwell Banker Realty

    Section Image
  • 204 Brocdorf Dr, Cincinnati, OH 45215

    $795,000

    • 6 Beds
    • 2.5 Baths
    • 5,138 Sq Ft
    • 204 Brocdorf Dr
    • Cincinnati, OH

    Welcome to 204 Brocdorf Dr, a spacious and timeless residence in the highly sought-after Wyoming community. This impressive stone home offers over 4,200 sq.ft. of thoughtfully designed living space, blending classic style with comfortable functionality. With 6 bedrooms and 2.5 bathrooms, this home provides plenty of room for daily living, entertaining, or creating dedicated spaces for work or

    Jonathan Hardy Keller Williams Seven Hills Re

    Section Image
  • 7652 Clough Pike, Cincinnati, OH 45244

    $735,000

    • 4 Beds
    • 2.5 Baths
    • 7652 Clough Pike
    • Cincinnati, OH

    To be Built! Amazing First Floor Suite home with all the modern amenities. 9' Ceilings, hardwood floors, ceramic baths, gaurmet Kitchen, covered front and rear porches, and much more. This home sits on .618 acres but could be combined with the lot a 7660 for an additional cost. Perfect location and all utilities are there. Other homes and plans available through Zeilman-James Homes, Inc. or

    Jeff Rosa eXp Realty

    Section Image
  • 11157 Snider Rd, Cincinnati, OH 45249

    $789,000

    • 4 Beds
    • 3.5 Baths
    • 3,336 Sq Ft
    • 11157 Snider Rd
    • Cincinnati, OH

    You'll find beautiful updates to this 4 BR/3.5 BA home with an unbeatable Sycamore Twp. location plus room to roam with 5500 + SF & 1/2 acre lot! Hardwoods on entire 1st floor, new carpet on 2nd floor, replacement windows throughout, HVAC replaced 2019. Kitchen renovated with white cabs, new appliances & granite tops. Finished LL w/ Rec Rm & Bonus Rooms for fitness/craft/media. Pergola & stamped

    Helena Cameron Sibcy Cline, Inc.

    Section Image
  • 3507 Clifton Ave, Cincinnati, OH 45220

    $900,000

    • 6 Beds
    • 5.5 Baths
    • 5,436 Sq Ft
    • 3507 Clifton Ave
    • Cincinnati, OH

    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,

    Billy Belshaw Comey & Shepherd

    Section Image
  • 12 Cypress Garden Ave, Cincinnati, OH 45220

    $748,500

    • 4 Beds
    • 2.5 Baths
    • 2,891 Sq Ft
    • 12 Cypress Garden Ave
    • Cincinnati, OH

    Quality throughout this Classic Clifton Gaslight Home! Traditional brick construction with newer windows, furnace, and water heater. Hardwood flooring throughout, plaster walls with moldings, and built-ins. Park-like front and rear yards on a quaint street within a pleasant walk up Clifton Avenue to UC's campus or the hospitals and many restaurants on Ludlow.

    Nick Guetle Cincinnati Boardwalk, Inc.

    Section Image
  • 435 Lafayette Ave, Cincinnati, OH 45220

    $700,000

    • 4 Beds
    • 3.5 Baths
    • 3,501 Sq Ft
    • 435 Lafayette Ave
    • Cincinnati, OH

    Welcome to 435 Lafayette Ave, a stunning single-family home nestled in Cincinnati's desirable Clifton neighborhood. Built in 1968, this spacious residence offers 4 bedrooms and 4 bathrooms across 2,901 square feet of living space. Key features include, A finished basement, central air conditioning, and a cozy fireplace enhance comfort and functionality. Situated on a generous 0.42-acre lot,

    Christopher Woodward NavX Realty, LLC

    Section Image
  • 144 Lafayette Ln, Cincinnati, OH 45220

    $995,000

    • 4 Beds
    • 4 Baths
    • 2,862 Sq Ft
    • 144 Lafayette Ln
    • Cincinnati, OH

    Nestled within a secluded wooded enclave in Clifton's coveted Gaslight district, this architectural masterpiece by Stanley Prowler embodies the essence of mid-century modern international style. The dramatic great room impresses with soaring 24-foot ceilings and expansive glass walls on three sides, flooding the space with natural light. Elegant fireplace adds warmth and charm at its heart.

    Joan Elfein Ohio Broker Direct

    Section Image
  • 892 Clifton Crest Terrace, Cincinnati, OH 45220

    $699,999

    • 5 Beds
    • 4 Baths
    • 4,288 Sq Ft
    • 892 Clifton Crest Terrace
    • Cincinnati, OH

    This stunning new construction LEED Home features a blend of traditional and modern elements and is situated on a semi-private drive in the desirable Gas District of Cincinnati. Boasting a first-floor owner suite, an open floor plan, and a finished lower level that leads out to a spacious backyard - this home offers both elegance and functionality. With convenient access to the Ludlow district's

    Apryll Fambro-Watkins Keller Williams Advisors

    Section Image

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1852985

MLS of Greater Cincinnati (CincyMLS)