$499,900

Estimated payment $2,970/month

-- Bed
-- Bath
2,499 Sq Ft
$200 Price per Sq Ft

Highlights

  • 2 Fireplaces
  • Stainless Steel Appliances
  • Soaking Tub
  • Private Yard
  • Eat-In Kitchen
  • 5-minute walk to Kenney Shields Park

About This Home

Rare opportunity in the heart of Covington's highly desirable Mainstrasse Village! This beautifully furnished, character-rich multi-family property is currently operating as a successful short-term rental and offers exceptional flexibility for investors or owner-occupants alike. Unit 1 features a stunning first-floor 1-bedroom setup with a spacious living room, eat-in kitchen with stainless steel appliances, stackable laundry, large bedroom, full bath, and direct walkout access to a private courtyard. Unit 2 occupies the entire second and third floors, offering 2 bedrooms, 2 full baths, oversized living spaces, an eat-in kitchen with stainless steel appliances, and an incredible third-floor primary suite complete with a huge bedroom, sitting area, walk-in shower, and clawfoot tub. Overflowing with historic charm and thoughtfully designed throughout, this property is absolutely beautifully furnished, with furnishings available for purchase. Enjoy off-street parking with room to potentially add an additional space, plus a gorgeous courtyard perfect for entertaining. Located just steps from Mainstrasse's popular bars, restaurants, and shops... and only minutes from Downtown Cincinnati... This turnkey property offers location, style, and income potential. Adding even more value, the property includes a transferable, and permanent Zoning Change of Use permit that allows for Short Term Rental operation.. a highly sought-after approval in this area. Buyer will still need to obtain the required STR license.

Listing Agent

Matt Brock

Resource Realty Partners License #223022 Listed on: 05/17/2026

Property Details

Home Type

  • Multi-Family

Lot Details

  • 2,332 Sq Ft Lot
  • Lot Dimensions are 106x22.4
  • Aluminum or Metal Fence
  • Private Yard

Home Design

  • Duplex
  • Brick Exterior Construction
  • Stone Foundation
  • Shingle Roof

Interior Spaces

  • 2,499 Sq Ft Home
  • Bookcases
  • Chandelier
  • 2 Fireplaces
  • Non-Functioning Fireplace
  • Vinyl Clad Windows
  • Basement Fills Entire Space Under The House

Kitchen

  • Eat-In Kitchen
  • Electric Range
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island

Bedrooms and Bathrooms

  • Double Vanity
  • Soaking Tub

Laundry

  • Laundry on lower level
  • Dryer
  • Washer

Parking

  • Driveway
  • On-Street Parking
  • Off-Street Parking

Outdoor Features

  • Patio

Schools

  • John G. Carlisle Elementary School
  • Holmes Middle School
  • Holmes Senior High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas

Community Details

  • 2 Units

Property Details

Home Type

Multi-Family

Lot Details

2,332 Sq Ft Lot

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Multi Family
  • Owner Pays: Water
  • Lot Size Acres: 0.0535
  • Lot Size: 106x22.4
  • Ownership: Consumer
  • Directions: Route 8, R Philadelphia, L 5th, R Main St.
  • New Construction: No
  • Structure Type: Duplex
  • Contract Info:Auction YN: No
  • General Property Description:Basement YN2: Yes
  • General Property Description:Approx SqFt2: 2499.0
  • Utilities Electric Company: Duke
  • Utilities Gas Company: Duke
  • Water Company: NKY Water
  • Special Features: None

Interior Features

  • Interior Amenities: Bookcases, Chandelier, Double Vanity, Eat-in Kitchen, Kitchen Island, Soaking Tub
  • Basement: Full
  • Heating: Forced Air, Natural Gas
  • Property Type: MultiFamily
  • Number Of Buildings: 1
  • Appliances: Dryer, Dishwasher, Microwave, Refrigerator, Washer, Stainless Steel Appliance(s), Electric Range
  • Fireplace Features: Inoperable
  • Fireplaces: 2
  • Fireplace: Yes
  • Living Area: 2499.0
  • Window Features: Vinyl Frames

Exterior Features

  • Fencing: Metal
  • Roof: Shingle
  • Construction Type: Brick
  • Exterior Features: Private Yard
  • Foundation Details: Stone
  • Patio And Porch Features: Patio

Garage/Parking

  • Attached Garage: No
  • Parking Features: On Street, Driveway, Off Street

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Lower Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Laundry Features: Lower Level

Schools

  • Elementary School: John G. Carlisle Elementary
  • Junior High Dist: Covington Indep
  • High School: Holmes Senior High
  • Middle Or Junior School: Holmes Middle School

Lot Info

  • Lot Size Sq Ft: 2332.0
  • Zoning Description: Multi Family

Multi Family

  • Number Of Units Total: 2

Map

Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $3,644 $275,000 $10,000 $265,000
2024 $3,616 $275,000 $10,000 $265,000
2023 $3,663 $275,000 $10,000 $265,000
2022 $2,470 $185,000 $10,000 $175,000
2021 $2,841 $185,000 $10,000 $175,000
2020 $2,826 $185,000 $10,000 $175,000
2019 $2,858 $185,000 $10,000 $175,000
2018 $2,918 $185,000 $10,000 $175,000
2017 $2,961 $185,000 $10,000 $175,000
2015 $3,822 $185,000 $10,000 $175,000
2014 $3,654 $185,000 $10,000 $175,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
05/17/2026 05/17/26 For Sale $499,900 +81.8% $200 / Sq Ft
01/31/2022 01/31/22 Sold $275,000 -8.0% $110 / Sq Ft View Prior Sale
11/05/2021 11/05/21 Pending -- -- --
09/25/2021 09/25/21 For Sale $299,000 +8.7% $120 / Sq Ft
09/21/2021 09/21/21 Off Market $275,000 -- --
08/09/2021 08/09/21 For Sale $299,000 0.0% $120 / Sq Ft
07/29/2021 07/29/21 Pending -- -- --
07/21/2021 07/21/21 For Sale $299,000 -- $120 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Warranty Deed $275,000 None Listed On Document
Warranty Deed $275,000 None Listed On Document
Warranty Deed $224,400 None Available
Deed $80,900 --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Loan Amount Loan Type
Closed $233,750 New Conventional
Closed $233,750 New Conventional
Previous Owner $175,100 Purchase Money Mortgage
Previous Owner $72,800 New Conventional
Source: Public Records

Source: Northern Kentucky Multiple Listing Service

MLS Number: 642677

Northern Kentucky Multiple Listing Service

APN: 054-22-07-033.00

Your Personal Tour Guide

Ask me questions while you tour the home.