Coldwell Banker Home Page

Local Realty Service Provided By: Coldwell Banker Realty

Property view
Listing view 2
Listing view 3

617 Fairfield Avenue, 
Bellevue, KY 41073

$475,000


2

Beds


2

Baths


2,312

Sq Ft


Multi-Family


Virtual Tour

Active

Listed by

Heather Herr

Nicole Hayden

Side Realty LLC.

Last updated:

September 10, 2026, 07:52 PM

MLS#

646534

Source:

KY NKMLS

About This Home

617 Fairfield Avenue

Rare live/work opportunity in the heart of Bellevue! 617 Fairfield Avenue offers incredible flexibility for an owner-occupant, investor or entrepreneur looking to combine residential living with commercial potential in one of Northern Kentucky's most vibrant communities. The property features commercial space on the main level with a separate two bedroom apartment above, creating multiple possibilities for how the property can be used. Live upstairs and operate your business below, create an income producing investment, or reimagine the spaces to fit your needs. A detached garage adds valuable storage and functionality. Located directly on Fairfield Avenue, surrounded by Bellevue's shops, restaurants and local businesses, and just minutes from Downtown Cincinnati. This is an opportunity to own a distinctive property in a highly visible and walkable location with both residential charm and business opportunities.

Home Facts

Multi-Family

2 Baths

2 Bedrooms

Price Summary

475,000

$205 per Sq. Ft.

MLS #:

646534

Last Updated:

September 10, 2026, 07:52 PM

Added:

2 day(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

2

Bathrooms

Total Bathrooms:

2

Full Bathrooms:

2

Interior

Living Area:

2,312 Sq. Ft.


Structure

Structure

Building Area:

2,312 Sq. Ft.


Lot

Lot Size (Sq. Ft):

3,877


Finances & Disclosures

Finances

Price:

$475,000

Price per Sq. Ft:

$205 per Sq. Ft.

Source:KY NKMLS
Information Deemed Reliable but Not Guaranteed. The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of NKMLS. Real estate listings held by IDX Brokerage firms other than Coldwell Banker Realty are marked with the Internet Data Exchange logo or the Internet Data Exchange thumbnail logo and detailed information about them includes the name of the listing Brokers. Copyright 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.