$499,900
SOLD JUN 19, 2026
-- Bed
-- Bath
2,499 Sq Ft
2,332 Sq Ft Lot

Sale Details

Date Sold: June 19, 2026

$200 Per Sq Ft

2 Days on Market

Highlights

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

About This Home

As of June 2026

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.

Last Agent to Sell the Property

Matt Brock

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

Last Buyer's Agent

Brian Thomas

Coldwell Banker Heritage License #222417

Coldwell Banker Heritage

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

Listing and Financial Details

  • The owner pays for water

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
  • Property Ownership:Property Ownership: Consumer
  • Unit Type:Unit Type: 1 Bedroom, 2 Bedroom
  • 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

Ownership 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 Name Owned For Owner Type

Purchase Details

Listed on
Jul 21, 2021
Closed on
Jan 31, 2022
Sold by
Bought by
Seller's Agent
Kathy Wolfe
Keller Williams Realty Service
Buyer's Agent
Shelli Stinson
eXp Realty LLC
List Price
$299,000
Sold Price
$275,000
Premium/Discount to List
-$24,000
-8.03%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
13.94%
Original Mortgage
$233,750
Interest Rate
4.5%
Mortgage Type
New Conventional

Purchase Details

Closed on
Mar 31, 2009
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$175,100
Interest Rate
5.1%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Oct 26, 1998
Sold by
Bought by
Source: Public Records
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

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 $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 $157,200 New Conventional
Previous Owner $175,100 Purchase Money Mortgage
Previous Owner $35,000 Credit Line Revolving
Previous Owner $100,000 Unknown
Previous Owner $21,000 Credit Line Revolving
Previous Owner $50,000 Credit Line Revolving
Previous Owner $22,000 Unknown
Source: Public Records

Property 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 Event Price List to Sale Price per Sq Ft Prior Sale
06/19/2026 06/19/26 Sold $499,900 0.0% $200 / Sq Ft
05/19/2026 05/19/26 Pending -- -- --
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

Tax 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.

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

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

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.