459 Flinn Avenue Columbia/Tusculum, OH 45226

3
Bed
3/1
Bath
$1,329,999
MLS# 1831329
3 BR
3/1 BA
  • New Construction

More About 459 Flinn Avenue

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.

Seller open to concessions based on the terms of the offer!

Directions to this Listing

: North on Hoge St, Right on Rushton, Right on Grandin Rd, Right on Missouri. Missouri becomes Flinn.

Information Refreshed: 5/11/2025 3:12 PM

Headshot of Peter McGarey Jr.

Peter McGarey Jr.

Realtor

513-295-1196
CallText
Headshot of Madeline Lawrence

Madeline Lawrence

Realtor

513-283-3152
CallText
Contact us to learn more or 

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Property Details

  • MLS#:

    1831329

  • Type:

    Single Family

  • County:

    Hamilton

  • Appliances:

    Oven/Range, Dishwasher, Refrigerator, Microwave, Gas Cooktop

  • Architecture:

    Transitional

  • Basement:

    Finished, Walkout

  • Basement Type:

    Full

  • Construction:

    Wood Siding

  • Cooling:

    Energy Star, Geothermal

  • Fireplace:

    Gas

  • Garage:

    Built in, Front, Oversized

  • Garage Spaces:

    3

  • Gas:

    At Street

  • Great Room:

    Fireplace, Wood Floor

  • Heating:

    Geothermal, Energy Star, Program Thermostat

  • Inside Features:

    Heated Floors, Elevator, 9Ft + Ceiling

  • Kitchen:

    Pantry, Wood Cabinets, Marble/Granite/Slate, Wood Floor, Eat-In, Island

  • Lot Description:

    37.5X100

  • Mechanical Systems:

    Dehumidifier, Garage Door Opener

  • Misc:

    Ceiling Fan, CO Detector, Recessed Lights, Smoke Alarm

  • Outside:

    Wheelchair Ramp - No Step, Handrails

  • Parking:

    On Street

  • Primary Bedroom:

    Bath Adjoins, Walk-in Closet

  • School District:

    Cincinnati Public Schools

  • Sewer:

    Public Sewer, At Street

  • View:

    Valley

  • Water:

    Public

Rooms

  • Bath 1:

    F (Level: 1)

  • Bath 2:

    F (Level: L)

  • Bath 3:

    F (Level: 3)

  • Bath 4:

    P (Level: 2)

  • Bedroom 1:

    17x16 (Level: 1)

  • Bedroom 2:

    14x14 (Level: Lower)

  • Bedroom 3:

    14x16 (Level: Lower)

  • Dining Room:

    13x17 (Level: 2)

  • Family Room:

    18x13 (Level: Lower)

  • Great Room:

    18x19 (Level: 2)

  • Laundry Room:

    10x8 (Level: Lower)

  • Recreation Room:

    18x16 (Level: 3)
This listing courtesy of Peter McGarey Jr. (513) 295-1196, Madeline McGarey Lawrence (513) 283-3152, Hyde Park Office (513) 321-9922

Explore Columbia-Tusculum & Surrounding Area

Monthly Cost

Mortgage Calculator

*The rates & payments shown are illustrative only.
Payment displayed does not include taxes and insurance. Rates last updated on 5/8/2025 from Freddie Mac Primary Mortgage Market Survey. Contact a loan officer for actual rate/payment quotes.
$6,908*
Estimated monthly total
Get Pre-Approved
OH•45226•Hamilton County•Columbia/Tusculum•459 Flinn Avenue
Headshot of Peter McGarey Jr.

Peter McGarey Jr.

Realtor

513-295-1196
CallText
Headshot of Madeline Lawrence

Madeline Lawrence

Realtor

513-283-3152
CallText
Contact us to learn more or 

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Sell with Sibcy Cline

Enter your address for a free market report on your home. Explore your home value estimate, buyer heatmap, supply-side trends, and more.

Must reads

The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc. Those listings held by brokerage firms other than Sibcy Cline, Inc. are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity. Copyright© 2022 Multiple Listing Services of Greater Cincinnati / All Information is believed accurate, but is NOT guaranteed.