Skip main navigation
Sold for $860,000
  • $860,000

    3507 Clifton Ave, Cincinnati, OH 45220

    6beds
    5,436sqft
    Single Family Residence
    Built in 1885
    0.46 Acres Lot
    $875,800 Zestimate®
    $158/sqft
    $4,926 Estimated rent

    Home value

    $875,800

    $797,000 - $963,000

    $4,926/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $4,926/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $4,926/mo

    Rent Zestimate®

    Refinance and save

    $5,720/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $5,720/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    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.

    Zillow last checked:

    Listing updated:

    Listed by:

    Billy Belshaw 513-800-0330,

    Comey & Shepherd 513-489-2100

    Bought with:

    Milford J Allen, 0000311530

    Plum Tree Realty

    Source: Cincy MLS,MLS#: 1852985MLS LogoOriginating MLS: Cincinnati Area Multiple Listing Service

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 6
    • Bathrooms: 6
    • Full bathrooms: 5
    • 1/2 bathrooms: 1
    Primary bedroom
    • Features: Walk-In Closet(s), Dressing Area, Fireplace, Wood Floor
    • Level: Second
    • Area: 288
    • Dimensions: 18 x 16
    Bedroom 2
    • Level: Second
    • Area: 180
    • Dimensions: 15 x 12
    Bedroom 3
    • Level: Second
    • Area: 234
    • Dimensions: 18 x 13
    Bedroom 4
    • Level: Third
    • Area: 238
    • Dimensions: 17 x 14
    Bedroom 5
    • Level: Third
    • Area: 192
    • Dimensions: 16 x 12
    Primary bathroom
    • Features: Shower, Tile Floor, Tub, Marb/Gran/Slate
    Bathroom 1
    • Features: Full
    • Level: Second
    Bathroom 2
    • Features: Full
    • Level: Second
    Bathroom 3
    • Features: Full
    • Level: Third
    Bathroom 4
    • Features: Full
    • Level: Third
    Dining room
    • Features: Fireplace, Wood Floor
    • Level: First
    • Area: 270
    • Dimensions: 15 x 18
    Family room
    • Area: 0
    • Dimensions: 0 x 0
    Kitchen
    • Features: Pantry, Eat-in Kitchen, Gourmet, Kitchen Island, Wood Cabinets, Wood Floor
    • Area: 195
    • Dimensions: 15 x 13
    Living room
    • Features: Bookcases, Fireplace, Wood Floor
    • Area: 300
    • Dimensions: 20 x 15
    Office
    • Features: Wood Floor
    • Level: First
    • Area: 224
    • Dimensions: 16 x 14
    Heating
    • Forced Air, Gas
    Cooling
    • Central Air
    Appliances
    • Included: Dishwasher, Disposal, Gas Cooktop, Oven/Range, Gas Water Heater
    Features
    • High Ceilings, Crown Molding, Natural Woodwork, Ceiling Fan(s)
    • Doors: Multi Panel Doors
    • Windows: Storm Window(s), Double Hung, Wood Frames
    • Basement: Full,Unfinished
    • Number of fireplaces: 4
    • Fireplace features: Gas, Wood Burning, Dining Room, Living Room, Master Bedroom
    Interior area
    • Total structure area: 5,436
    • Total interior livable area: 5,436 sqft

    Property

    Parking
    • Total spaces: 5
    • Parking features: Off Street, Driveway
    • Garage spaces: 5
    • Has uncovered spaces: Yes
    Features
    • Stories: 3
    • Patio & porch: Patio, Porch
    • Exterior features: Balcony
    • Fencing: Metal
    • Has view: Yes
    • View description: City
    Lot
    • Size: 0.46 Acres
    • Dimensions: 100 x 200
    • Features: Less than .5 Acre
    Details
    • Parcel number: 2140004000400
    • Zoning description: Residential,Multi Family

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence
    Materials
    • Brick, Stone, Wood Siding
    • Foundation: Stone
    • Roof: Slate,Membrane
    Condition
    • New construction: No
    • Year built: 1885

    Utilities & green energy

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

    Community & HOA

    HOA
    • Has HOA: No
    Location
    • Region: Cincinnati

    Financial & listing details

    • Price per square foot: $158/sqft
    • Date on market: 8/26/2025
    • Listing terms: No Special Financing,Conventional

    Price history

    DateEventPrice
    11/12/2025Sold$860,000-0.6%$158/sqft
    Source: Cincy MLS #1852985 Report a problem
    10/20/2025Pending sale$865,000$159/sqft
    Source: Cincy MLS #1852985 Report a problem
    8/26/2025Price change$865,000-3.9%$159/sqft
    Source: Cincy MLS #1852985 Report a problem
    7/25/2025Price change$900,000-4.3%$166/sqft
    Source: Cincy MLS #1836188 Report a problem
    6/30/2025Price change$940,000-5.5%$173/sqft
    Source: Cincy MLS #1836188 Report a problem
    4/11/2025Listed for sale$995,000+24.5%$183/sqft
    Source: Cincy MLS #1836188 Report a problem
    1/16/2024Listing removed--
    Source: Cincy MLS #1791997 Report a problem
    12/14/2023Listed for sale$799,500-0.1%$147/sqft
    Source: Cincy MLS #1791997 Report a problem
    12/14/2023Listing removed$800,000$147/sqft
    Source: Cincy MLS #1779371 Report a problem
    10/31/2023Listing removed$800,000$147/sqft
    Source: Cincy MLS #1779371 Report a problem
    7/27/2023Listed for sale$800,000+77.8%$147/sqft
    Source: Cincy MLS #1779371 Report a problem
    8/30/2018Sold$450,000$83/sqft
    Source: Cincy MLS #1582306 Report a problem

    Public tax history

    Tax history is unavailable.

    Neighborhood: Clifton

    Nearby schools

    GreatSchools rating
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $875,800
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $875,800