459 Flinn Avenue Columbia/Tusculum, OH 45226

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

Sale Pending

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.

Connect with a loan officer to get started!

Directions to this Listing

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

Information Refreshed: 10/13/2026 4:13 AM

Ask a Question

Contact our Customer Care team or
513-985-4010
CallText

By providing a telephone number and submitting the form, you are consenting to be contacted by SMS text message and agreeing to our Privacy Policy. Message frequency may vary. Message and data rates may apply. Reply STOP to opt out out of further messaging. Reply HELP for more information.

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

Call us now at 513-985-4010

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)

  • Kitchen:

    15x17 (Level: 2)

  • Laundry Room:

    10x8 (Level: Lower)

  • Recreation Room:

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

Frequently Asked Questions

How much does 459 Flinn Avenue cost?
459 Flinn Avenue, Columbia/Tusculum, OH is listed at $1,329,999.
How many bedrooms and bathrooms does 459 Flinn Avenue have?
459 Flinn Avenue has 3 bedrooms, 3 full bathrooms, and 1 half bathroom.
What type of property is 459 Flinn Avenue?
459 Flinn Avenue is a Single Family.
Is 459 Flinn Avenue still available?
459 Flinn Avenue is currently listed as Pending.
What school district serves 459 Flinn Avenue?
459 Flinn Avenue is served by the Cincinnati Public Schools school district.

Explore Columbia-Tusculum & Surrounding Area

Columbia Tusculum

Columbia-Tusculum

The restoration in Columbia-Tusculum is preserving the distinctive historical character of the area. There's an abundance of old frame homes with high ceilings, wood floors, and many decorative elements like gingerbread and steam boat gothic. Stately Vi...

View Community
East End

East End

Originally called Vanceville (in honor of a major land owner named James Vance), the East End received its name after a former East End Baseball Park located in the area. Offering amazing views of the Ohio River and Northern Kentucky, the East End has a...

View Community
Hyde Park

Hyde Park - Mt. Lookout

Hyde Park and Mt. Lookout are adjacent urban communities where people of all ages enjoy the convenience of being centrally located and only minutes from downtown. Throughout this community, older homes are lovingly care for in an urban setting with a su...

View Community
Linwood OH

Linwood

Linwood has a variety of home styles and price ranges. Most of the homes are older and many of them have been well loved and kept in great condition. The community is small with only 230 residents.

View Community
OH•45226•Hamilton County•Columbia/Tusculum•459 Flinn Avenue

Ask a Question

Contact our Customer Care team or
513-985-4010
CallText

By providing a telephone number and submitting the form, you are consenting to be contacted by SMS text message and agreeing to our Privacy Policy. Message frequency may vary. Message and data rates may apply. Reply STOP to opt out out of further messaging. Reply HELP for more information.

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

Call us now at 513-985-4010

Monthly Cost

Mortgage Calculator

Enter your details for an estimated monthly payment. See how much house you can afford

%
LEGAL DISCLAIMERS▼

Your estimated payment

$7,367
per month
PRINCIPAL & INTEREST
$7,367
CHAT WITH A LOAN OFFICER

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© 2026 Multiple Listing Services of Greater Cincinnati / All Information is believed accurate, but is NOT guaranteed.