Skip main navigation
Pending
    • $1,329,999

    459 Flinn Ave, Cincinnati, OH 45226

    3beds
    --sqft
    : 
    $9,441/mo
    Get pre-qualified
    Single Family Residence
    Built in ----
    3,750 Square Feet Lot
    $-- Zestimate®
    $--/sqft
    $-- HOA

    What's special

    New construction in historic Columbia Tusculum. Panoramic views from 2 terraces. Over 4000 square feet of livable space with an additional 972 square feet of Terraces. LEED certified with tax abatement. Fully approved through Hillside and Zoning. Elevator to all floors. Opportunity to build to suit. Agent has interest in property and build.
    260 days
    |
    2
    |
    0
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Peter McGarey Jr 513-295-1196,

    Sibcy Cline, Inc. 513-321-9922,

    Madeline M. Lawrence 513-283-3152,

    Sibcy Cline, Inc.

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

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 4
      • Full bathrooms: 3
      • 1/2 bathrooms: 1
      Primary bedroom
      • Features: Bath Adjoins, Walk-In Closet(s)
      • Level: First
      • Area: 272
      • Dimensions: 17 x 16
      Bedroom 2
      • Level: Lower
      • Area: 196
      • Dimensions: 14 x 14
      Bedroom 3
      • Level: Lower
      • Area: 224
      • Dimensions: 14 x 16
      Bedroom 4
      • Area: 0
      • Dimensions: 0 x 0
      Bedroom 5
      • Area: 0
      • Dimensions: 0 x 0
      Primary bathroom
      • Features: Built-In Shower Seat, Shower, Tile Floor, Double Vanity, Heated Floors
      Bathroom 1
      • Features: Full
      • Level: First
      Bathroom 2
      • Features: Full
      • Level: Lower
      Bathroom 3
      • Features: Full
      • Level: Third
      Bathroom 4
      • Features: Partial
      • Level: Second
      Dining room
      • Features: Open
      • Level: Second
      • Area: 221
      • Dimensions: 13 x 17
      Family room
      • Area: 234
      • Dimensions: 18 x 13
      Great room
      • Features: Fireplace, Wood Floor
      • Level: Second
      • Area: 342
      • Dimensions: 18 x 19
      Kitchen
      • Features: Pantry, Eat-in Kitchen, Kitchen Island, Wood Cabinets, Wood Floor, Marble/Granite/Slate
      • Area: 255
      • Dimensions: 15 x 17
      Living room
      • Area: 0
      • Dimensions: 0 x 0
      Office
      • Area: 0
      • Dimensions: 0 x 0
      Heating
      • Program Thermostat, ENERGY STAR Qualified Equipment, Geothermal
      Cooling
      • ENERGY STAR Qualified Equipment, Geothermal
      Appliances
      • Included: Dishwasher, Gas Cooktop, Microwave, Oven/Range, Refrigerator, Electric Water Heater
      Features
      • High Ceilings, Elevator, Heated Floors, Ceiling Fan(s), Recessed Lighting
      • Doors: 31 5/8 Min Width
      • Windows: Double Hung, Double Pane Windows, Insulated Windows
      • Basement: Full,Finished,Walk-Out Access
      • Number of fireplaces: 1
      • Fireplace features: Gas, Great Room
      Interior area
      • Total structure area: 0

      Property

      Parking
      • Total spaces: 3
      • Parking features: On Street, Garage Door Opener
      • Garage spaces: 3
      • Has uncovered spaces: Yes
      Accessibility
      • Accessibility features: Handrails, Accessible Approach with Ramp
      Features
      • Stories: 3
      • Patio & porch: Covered Deck/Patio
      • Exterior features: Balcony, Entertain Ctr
      • Has view: Yes
      • View description: Valley
      Lot
      • Size: 3,750 Square Feet
      • Dimensions: 37.5 x 100
      • Features: Less than .5 Acre
      • Topography: Sloping
      Details
      • Parcel number: NEW/UNDER CONST/TO BE BUILT
      • Zoning description: Residential
      • Other equipment: Dehumidifier

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Transitional
      • Property subtype: Single Family Residence
      Materials
      • Wood Siding
      • Foundation: Concrete Perimeter
      • Roof: Slate,Membrane
      Condition
      • New construction: Yes

      Utilities & green energy

      • Gas: At Street
      • Sewer: Public Sewer, At Street
      • Water: Public

      Community & HOA

      Community
      • Security: Carbon Monoxide Detector(s), Smoke Alarm
      HOA
      • Has HOA: No
      Location
      • Region: Cincinnati

      Financial & listing details

      • Tax assessed value: $110,900
      • Annual tax amount: $2,460
      • Date on market: 2/19/2025
      • Listing terms: No Special Financing

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        9/23/2025Pending sale$1,329,999
        Source: Cincy MLS #1831329 Report a problem
        2/19/2025Listed for sale$1,329,999+1464.7%
        Source: Cincy MLS #1831329 Report a problem
        12/12/2024Sold$85,000-15%
        Source: Cincy MLS #1797043 Report a problem
        7/6/2024Pending sale$100,000
        Source: Cincy MLS #1797043 Report a problem
        2/23/2024Listed for sale$100,000-25.9%
        Source: Cincy MLS #1797043 Report a problem
        11/21/2017Sold$135,000
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2024$2,460 -0.2%$38,815
        2023$2,465 +120.2%$38,815 +145.7%
        2022$1,119 -3.3%$15,799
        2021$1,157 +5%$15,799
        2020$1,102 $15,799
        2019-- --
        2018-- --
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: East End

        Getting around

        37 / 100
        Car-Dependent
        29 / 100
        Some Transit
        63 / 100
        Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

            Nearby cities

            Nearby neighborhoods

            Nearby zip codes

            Other Cincinnati Topics

              Search
              Updates
              Favorites
              Plan
              Inbox