Seller's Agent in 2026
Matt Brock
Resource Realty Partners
(859) 445-8331
6 in this area
129 Total Sales
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
Resource Realty Partners License #223022 Listed on: 05/17/2026
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
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 | -- |
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 |
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 |
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 |
Seller's Agent in 2026
Matt Brock
Resource Realty Partners
(859) 445-8331
6 in this area
129 Total Sales
Buyer's Agent in 2026
Brian Thomas
Coldwell Banker Heritage
(513) 503-9763
1 in this area
158 Total Sales
Seller's Agent in 2022
Kathy Wolfe
Keller Williams Realty Service
(859) 991-6396
3 in this area
51 Total Sales
N
Seller Co-Listing Agent in 2022
Natalie Haines
Keller Williams Realty Service
Buyer's Agent in 2022
Shelli Stinson
eXp Realty LLC
(859) 468-2730
2 in this area
131 Total Sales
Source: Northern Kentucky Multiple Listing Service
MLS Number: 642677
APN: 054-22-07-033.00
Ask me questions while you tour the home.