910 Main Street

Beds
Baths
2,499 Sq. Ft.
$200 / Sq. Ft.
2,499
Sq. Ft.
$200
per Sq. Ft.

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....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.
  1. Listed by Matthew Brock • Brokerage DRE #270894 • Resource Realty Partners
    P: (859)-445-8331 C: (859)-445-8331 mattb@resourcerealtypartners.com

Property Details for 910 Main Street

Zoning Description
Multi Family
LISTING UPDATED: 05/19/2026 09:22 AM

Property Details for 910 Main Street

StatusPending
MLS #642677
Days on Market2
Taxes-
HOA Fees-
Condo/Co-op Fees-
Property TypeMulti Family
MLS TypeMulti Family / Multi Family
Year Built-
Lot Size0.05 AC / 2,178 SF
CountyKenton County

Location

Listing Courtesy of Resource Realty Partners
Add your commute

Building Information for 910 Main Street

Stories-Residences2Year Built-Building Size-Lot Size0.05 AC / 2,178 SF

Payment Calculator

$2,795 per month

30 year fixed, 6.36% Interest

Principal and Interest

$2,491

Property Taxes

$304

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 910 Main Street

Summary
Location and General Information
  • Longitude: -84.517044
  • Latitude: 39.079851
  • Directions: Route 8, R Philadelphia, L 5th, R Main St.
  • MLSArea Major: K01 - Covington North
  • MLSArea Minor: K01 - Covington North
  • Year Built Known: No
  • SIC: CO - Covington
Taxes and HOA
  • Parcel Number: 054-22-07-033.00
  • Tax Rate: 16.03
Distance To
  • Distance To Bus Comments: Busline Near
School Information
  • High School District: Covington Indep
  • Elementary School: John G. Carlisle Elementary
  • Middle Or Junior School: Holmes Middle School
  • High School: Holmes Senior High
Parking
  • Parking Features: On Street, Driveway, Off Street
  • Attached Garage: No
Property
Lot Information
  • Lot Size Units: Acres
  • Lot Size Square Feet: 2332.0
  • Lot Size Acres: 0.0535
  • Lot Size Dimensions: 106x22.4
  • Lot Size Area: 0.05
Property and Assessments
  • New Construction: No
  • Property Condition: Existing Structure
  • Living Area: 2499.0
  • Living Area Units: Square Feet
  • Living Area Source: Public Records
Building Features
  • Number Of Buildings: 1
  • Structure Type: Duplex
  • Foundation Details: Stone
  • Construction Materials: Brick
Utilities
  • Sewer: Public Sewer
  • Water Source: Public
  • Gas Company: Duke
  • Electric Company: Duke
  • Water Company: NKY Water
  • Sanitation Company: SD1
Interior and Exterior Features
Interior Features
  • Appliances: Dryer, Dishwasher, Microwave, Refrigerator, Washer, Stainless Steel Appliance(s), Electric Range
  • Cooling: Central Air
  • Fireplaces Total: 2
  • Fireplace: Yes
  • Window Features: Vinyl Frames
  • Has Heating: Yes
  • Has Cooling: Yes
  • Basement: Full
  • Interior Features: Bookcases, Chandelier, Double Vanity, Eat-in Kitchen, Kitchen Island, Soaking Tub
  • Laundry Features: Lower Level
  • Heating: Forced Air, Natural Gas
  • Fireplace Features: Inoperable
  • Laundry Features: Lower Level
Exterior Features
  • Exterior Features: Private Yard
  • Patio And Porch Features: Patio
  • Fencing: Metal
  • Roof: Shingle
Multi Family
Multi Family Information
  • Number Of Units Total: 2
  • Unit Type: 1 Bedroom, 2 Bedroom
Unit Information
Unit 1
  • CurrentlyRented: No
Unit 2
  • CurrentlyRented: No
Unit 3
  • CurrentlyRented: No
Unit 4
  • CurrentlyRented: No
Rental
Rent Information
  • Owner Pays: Water

Property History for 910 Main Street

DateEvent & SourcePriceAppreciation
May 19, 2026

Contract Signed

Northern Kentucky Multiple Listing Service #642677

May 17, 2026

Listed (Active)

Northern Kentucky Multiple Listing Service #642677

$499,900
Jan 31, 2022

Sold (Public Record)

Public Record #1482836482

$275,000
DateEvent & SourcePrice
05/19/2026

Contract Signed

Northern Kentucky Multiple Listing Service #642677

05/17/2026

Listed (Active)

Northern Kentucky Multiple Listing Service #642677

$499,900
01/31/2022

Sold (Public Record)

Public Record #1482836482

$275,000

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 910 Main Street

Taxable ValueLand$10,000Additions$265,000Total$275,000
Tax Record2025$3,644 ($304 / month)
Home Facts
Baths1Total Finished SqFt2,499 SqFtAbove Grade Finished SqFt2,499 SqFtStories3Lot Size2,374 SqFtStyleDuplexYear Built1909CountyKENTONAPN054-22-07-033.00

Schools near 910 Main Street

This home is within Covington Independent.
Rating
School
Type
Grades
Distance
Public - K to 5
Public - K to 12
Public - 9 to 12
Public - K to 5
Rating
School
Distance
John G Carlisle Elementary School
PublicK to 5

Transformational Learning Center
PublicK to 12

Holmes High School
Public9 to 12

Glenn O Swing Elementary School
PublicK to 5

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Resource Realty Partners

The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of NKMLS. Real estate listings held by IDX Brokerage firms other than Compass and its related brokerages are marked with the Internet Data Exchange logo or the Internet Data Exchange thumbnail logo and detailed information about them includes the name of the listing Brokers. Listing information is deemed reliable, but not guaranteed. Copyright 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.