138-142 W. Pike St., Covington, KY 41011

Local realty services provided by:ERA Real Solutions Realty
138-142 W. Pike St.,Covington, KY 41011
$789,000
  • 4 Beds
  • 5 Baths
  • 6,000 sq. ft.
  • Multi-family
  • Active
Listed by: haley runion
Office: comey & shepherd realtors
MLS#:636482
Source:KY_NKMLS

Price summary

  • Price:$789,000
  • Price per sq. ft.:$131.5

About this home

***FEB 2026 UPDATE: Commercial unit vacant as of mid-February*** This historic mixed-use building offers the perfect combination of charm, income, and location. Property is a great opportunity for commercial investors or work/live entrepreneurs. From W. Pike St., the 2,500+ sq ft. main level features two storefront entrances. From Russell St., residential tenants enjoy two private parking garages and the entrance to their 2nd-level condo with over 2,500 sq ft of living space, including four bedrooms and three full baths. From either street, you're just steps away from Covington's main attractions including Hotel Covington, Braxton Brewery, and Mainstresse Village! This beautiful historic Covington building has been previously approved for short term rental license (Airbnb, VRBO, etc.) and receives great foot traffic and visibility with over 7,500 cars passing by each day! A great investment opportunity awaits at this low-maintenance, cash-flowing property.

Contact an agent

contact an agent

Yes, I would like more information. Please use and/or share my information with an ERA®  affiliated agent to contact me about my real estate needs. By clicking Send message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an ERA®  affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE® , CENTURY 21® , Coldwell Banker® , Corcoran® , Sotheby's International Realty® ).
 I acknowledge that I have read and agree to theTerms of useandPrivacy notice

Home facts

  • Listing ID #:636482
  • Added:172 day(s) ago
  • Updated:February 26, 2026 at 03:53 AM

Rooms and interior

  • Bedrooms:4
  • Total bathrooms:5
  • Full bathrooms:3
  • Half bathrooms:2
  • Kitchen Description:Convection Oven, Dishwasher, Electric Range, Microwave, Pantry, Refrigerator, Stainless Steel Appliance(s)
  • Basement Description:Partial
  • Living area:6,000 sq. ft.

Heating and cooling

  • Cooling:Central Air
  • Heating:Forced Air
  • Central air:Yes

Structure and exterior

  • Building area:6,000 sq. ft.
  • Lot area:0.07 Acres
  • Lot Features:Corner Lot
  • Construction Materials:Brick
  • Foundation Description:Concrete Perimeter

Schools

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

Utilities

  • Water:Public, Water Available
  • Sewer:Public Sewer, Sewer Available

Finances and disclosures

  • Price:$789,000
  • Price per sq. ft.:$131.5

Features and amenities

  • Appliances:Microwave, Refrigerator
  • Laundry features:Washer/Dryer Stacked
  • Amenities:Granite Counters, Smoke Detector(s), Storage, Vinyl Frames

Parking

  • Total parking spaces:2
  • Garage:Yes
  • Garage spaces:2
Information Deemed Reliable but Not Guaranteed. 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 ERA Real Solutions Realty 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. Copyright 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.