This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
$499,900
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
Property Description
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.
Full Property Details
Full Property Details for 910 Main St
General
- Sold For: $499,900
- Status: Closed
- Type: Multi-Family
- Source: Northern_Kentucky
- MLS ID: 642677
- Added to Site: 56 day(s) ago
Interior
- Interior Features: Soaking Tub, Kitchen Island, Eat-in Kitchen, Double Vanity, Chandelier, Bookcases
- Fireplace: Yes
- Number of Fireplaces: 2
- Fireplace(s): Inoperable
- Appliances: Electric Range, Stainless Steel Appliance(s), Dishwasher, Dryer, Microwave, Refrigerator, Washer
Rooms
Other Rooms
- Laundry: Lower Level
Exterior
- Exterior Features: Private Yard
- Porch/Patio/Deck: Patio
Parking
- Parking Features: Driveway, Off Street, On Street
Location
- County: Kenton
- Driving Directions: Route 8, R Philadelphia, L 5th, R Main St.
School Information
- Elementary School: John G. Carlisle Elementary
- Middle School: Holmes Middle School
- High School: Holmes Senior High
Community
- Community Name: K01 - Covington North
Heating & Cooling
- Central air: Yes
- Air Conditioning: Yes
- Cooling Type: Central Air Conditioning
- Heating Type: Natural Gas, Forced Air
Utilities
- Sewer: Public Sewer
- Water: Public
Structural Information
- # Buildings: 1
- Construction: Brick
- Basement Desc.: Full
- Roof: Asphalt, Shingle
- Windows: Vinyl Frames
- Square Feet: 2,499
- Living Area: 2,499 Sq. Ft.
- Property Condition: Existing Structure
Lot Features
- Lot Size (Acres): 0.05
- Lot Size (Sq. Ft.): 2,332
- Lot Size: .05
- Lot Dimensions: 106 x 22.4
- Zoning: Multi Family
- Fencing (Description): Metal
Disclosures and Reports
- Property ID: 054-22-07-033.00
Listed by Resource Realty Partners, Matthew Brock
Sold by Coldwell Banker Heritage, Brian Thomas
Get Pre-Approved Today
Schools
Schools serving 910 Main St
School District:Covington Independent School District
| Name | Grades | Distance |
|---|---|---|
John G Carlisle Elementary School 910 Holman Street, Covington, KY 41011 | K-5 | 0.2 mi |
Holmes Middle School 2500 Madison Avenue, Covington, KY 41014 | 6-8 | 1.5 mi |
Holmes High School 25th and Madison Ave, Covington, KY 41014 | 9-12 | 1.5 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 910 Main St
Date
Details
Price
Change
Source
6/19/2026
Sold
$499,900
—
MLS
5/17/2026
Listed
$499,900
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
910 Main Street, Covington, KY 41011 (MLS# 642677) is a Multi-Family property that was sold at $499,900 on June 19, 2026. Want to learn more about 910 Main Street? Do you have questions about finding other Multi-Family real estate for sale in Covington? You can browse all Covington real estate or contact a Coldwell Banker agent to request more information.

