Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$475,000 Just Listed

  • For Sale
  • Active
  • Multi-Family
  • 2 Total Beds
  • 2 Car Garage
  • Updated 1 day ago
See This Home
Save This Home
See This Home
Save This Home
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.

Full Property Details for 617 Fairfield Ave

General

  • Price: $475,000
  • Status: Active
  • Type: Multi-Family
  • Source: Northern_Kentucky
  • MLS ID: 646534
  • Updated: 9/10/2026
  • Added to Site: 1 day(s) ago

Interior

  • Interior Features: Pantry
  • Fireplace: Yes
  • Number of Fireplaces: 2
  • Fireplace(s): Decorative, Gas, Inoperable
  • Appliances: Gas Range, Gas Oven, Dishwasher, Refrigerator

Rooms

Bathrooms

  • Total Bathrooms: 2
  • Full Bathrooms: 2

Bedrooms

  • Total Bedrooms: 2

Exterior

  • Exterior Features: Balcony
  • Porch/Patio/Deck: Patio, Porch

Parking

  • Garage: Yes
  • Garage Spaces: 2
  • Parking Features: Driveway, Garage

Location

  • County: Campbell
  • Driving Directions: Fairfield

School Information

  • Elementary School: Grandview Elementary
  • Middle School: Bellevue High
  • High School: Bellevue High

Community

  • Community Name: K15 - Bellevue/Dayton/Wood

Heating & Cooling

  • Central air: Yes
  • Air Conditioning: Yes
  • Cooling Type: Central Air Conditioning, Window Unit(s)
  • Heating Type: Natural Gas, Forced Air

Utilities

  • Sewer: Public Sewer
  • Water: Public
  • Cable Available: Yes
  • Utility Description: Cable Available, Natural Gas Available

Structural Information

  • # Buildings: 1
  • Construction: Brick
  • Basement Desc.: Full
  • Roof: Shingle
  • Windows: Double-Hung
  • Square Feet: 2,312
  • Living Area: 2,312 Sq. Ft.
  • Property Condition: Existing Structure

Lot Features

  • Lot Size (Acres): 0.09
  • Lot Size (Sq. Ft.): 3,877
  • Lot Size: .09
  • Lot Dimensions: appro x

Disclosures and Reports

  • Property ID: 999-99-07-802.00

Listed by Side Realty LLC, Heather Herr and Side Realty LLC, Nicole Hayden

Quickly Find Out More

* Indicates a required field

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 Send Message, 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 an 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.

We Value Your Privacy

Listing agents

— 617 Fairfield Ave —

  • Heather Herr

    Side Realty LLC

  • Nicole Hayden

    Side Realty LLC

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 617 Fairfield Ave

School District:Bellevue Independent School District
NameGradesDistance
Grandview Elementary School, Bellevue, KY
500 Grandview Avenue, Bellevue, KY 41073
PK-50.5 mi
Bellevue High School, Bellevue, KY
201 Center Street, Bellevue, KY 41073
6-120.4 mi
Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 617 Fairfield Ave Get Price Alerts and Save Property

Date
Details
Price
Change
Source
9/10/2026
Listed
$475,000
20.25%
MLS
8/09/2023
Sold
$395,000
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 617 Fairfield Ave

Year
Property Taxes
Change
Tax Assessment
Change
2025
$4,787
1%
$395,000
—
2024
$4,760
-21%
$395,000
-8%
2023
$5,989
121%
$427,500
114%
2022
$2,708
-5%
$200,000
—
2021
$2,856
-1%
$200,000
—
2019
$2,890
56%
$200,000
51%
2018
$1,856
2%
$132,500
—
2017
$1,811
6%
$132,500
—
2016
$1,708
3%
$132,500
—
2014
$1,665
4%
$132,500
—
2013
$1,606
—
$132,500
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 617 Fairfield Ave

$
Down Payment
%
$
%

$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by Side Realty LLC, Heather Herr and Side Realty LLC, Nicole Hayden

Just Listed near 617 Fairfield Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

401 Benham St, Dayton, KY 41074 - Photo 1 Just Listed
$259,900
Open House

401 Benham St  Dayton, KY 41074

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,540
    Sq. Ft.
769 E 11th St, Newport, KY 41071 - Photo 1 Just Listed
$1,495,000

769 E 11th St  Newport, KY 41071

  • Single Family
  • Active
  • Updated 1 hour ago
  • 3
    Beds
  • 4
    Total Baths
Listed by Patrick Gunning (513) 300-6929
400 Riverboat Row, Newport, KY 41071 - Photo 1 Just Listed
$2,450,000

400 Riverboat Row  #2001  Newport, KY 41071

  • Condo
  • Active
  • Updated 1 hour ago
  • 3
    Beds
  • 4
    Total Baths
  • 3,269
    Sq. Ft.
705 Park Ave, Newport, KY 41071 - Photo 1 Just Listed
$390,000

705 Park Ave  Newport, KY 41071

  • Single Family
  • Active
  • Updated 2 days ago
  • 4
    Beds
  • 2
    Total Baths
  • 2,027
    Sq. Ft.

Price Reduced near 617 Fairfield Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

507 3rd Ave, Dayton, KY 41074 - Photo 1 Price Reduced
-$10,100 (-5.32%)
$179,900

507 3rd Ave  Dayton, KY 41074

  • Single Family
  • Active
  • Updated 1 hour ago
  • 2
    Beds
  • 1
    Total Bath
  • 902
    Sq. Ft.
326 W 11th St, Newport, KY 41071 - Photo 1 Price Reduced
-$14,000 (-6.39%)
$205,000

326 W 11th St  Newport, KY 41071

  • Single Family
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 1
    Total Bath
  • 1,160
    Sq. Ft.
Listed by Mandy Kinley (859) 912-9655
120 Main St, Newport, KY 41071 - Photo 1 Price Reduced
-$24,000 (-6%)
$375,900

120 Main St  #212  Newport, KY 41071

  • Condo
  • Active
  • Updated 2 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,009
    Sq. Ft.
1019 Orchard St, Newport, KY 41071 - Photo 1 Price Reduced
-$4,000 (-1.92%)
$204,500

1019 Orchard St  Newport, KY 41071

  • Single Family
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,908
    Sq. Ft.

Recent Sales near 617 Fairfield Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

253 Foote Ave, Bellevue, KY 41073 - Photo 1 Sold
$440,500

253 Foote Ave  Bellevue, KY 41073

  • Single Family
  • Closed
  • 4
    Beds
  • 2
    Total Baths
  • 1,800
    Sq. Ft.
1221 Martin Dr, Cincinnati, OH 45202 - Photo 1 Sold
$499,900

1221 Martin Dr  Cincinnati, OH 45202

  • Single Family
  • Closed
  • Updated 9 days ago
  • 4
    Beds
  • 4
    Total Baths
  • 2,120
    Sq. Ft.
Listed by Mike McEntush
982 Hatch St, Cincinnati, OH 45208 - Photo 1 Sold
$472,000

982 Hatch St  Cincinnati, OH 45208

  • Duplex
  • Closed
2026 Michigan Ave, Dayton, KY 41074 - Photo 1 Sold
$487,000

2026 Michigan Ave  Dayton, KY 41074

  • Single Family
  • Closed
  • 4
    Beds
  • 4
    Total Baths
  • 3,041
    Sq. Ft.

617 Fairfield Avenue, Bellevue, KY 41073 (MLS# 646534) is a Multi-Family property with 2 units containing 2 bedrooms and 2 full bathrooms. 617 Fairfield Avenue is currently listed for $475,000 and was received on September 10, 2026. Want to learn more about 617 Fairfield Avenue? Do you have questions about finding other Multi-Family real estate for sale in Bellevue? You can browse all Bellevue real estate or contact a Coldwell Banker agent to request more information.

Tour this property