$550,000
PENDING

Estimated payment $3,495/month

Total Views 29,717
3 Beds
2 Baths
2,046 Sq Ft
$269 Price per Sq Ft

Highlights

  • Spa
  • Deck
  • 1 Fireplace
  • City View
  • Wood Flooring
  • 1-minute walk to George Steinford Park

About This Home

Live, rent, or both—this beautifully restored Mainstrasse gem offers incredible versatility just steps from all the action! This 3-bedroom, 2-bath home perfectly blends historic charm with modern updates, creating an urban oasis that's ready for its next chapter. Inside, you'll find spacious living areas with thoughtful improvements throughout. The spacious backyard features a hot tub, galvanized pool, and rare off-street parking—perfect for entertaining or hosting guests. With a walkable location near Covington's hottest restaurants, shops, and just minutes to downtown Cincinnati, this is a unique opportunity you won't want to miss! Sold fully furnished, no need to pack... just move right in!

Listing Agent

Cindy Shetterly

Keller Williams Realty Services License #220012 Listed on: 08/18/2025

Keller Williams Realty Services

Co-Listing Agent

Venus Bertucci

Keller Williams Realty Services License #220012

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,246

Year Built

  • Built in 1870

Lot Details

  • 1,995 Sq Ft Lot
  • Wood Fence
  • Cleared Lot
  • Private Yard
  • Historic Home

Property Views

  • City
  • Neighborhood

Home Design

  • Brick Exterior Construction
  • Stone Foundation
  • Membrane Roofing

Interior Spaces

  • 2,046 Sq Ft Home
  • 2-Story Property
  • Built-In Features
  • Woodwork
  • High Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Chandelier
  • 1 Fireplace
  • Vinyl Clad Windows
  • Window Treatments
  • Panel Doors
  • Entrance Foyer
  • Living Room
  • Storage
  • Fire and Smoke Detector
  • Unfinished Basement

Kitchen

  • Eat-In Kitchen
  • Gas Oven
  • Gas Range
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Granite Countertops

Flooring

  • Wood
  • Concrete
  • Tile
  • Luxury Vinyl Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 2 Full Bathrooms
  • Bathtub with Shower
  • Shower Only

Laundry

  • Laundry Room
  • Laundry on main level
  • Dryer
  • Washer

Parking

  • Driveway
  • On-Street Parking
  • Off-Street Parking

Pool

  • Spa
  • Above Ground Pool

Outdoor Features

  • Deck
  • Exterior Lighting
  • Pergola

Schools

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

Utilities

  • Central Air
  • Heating System Uses Natural Gas
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Assessor Parcel Number 054-21-03-013.00

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,246

Year Built

Built in 1870

Lot Details

0

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.05
  • Year Built: 1870
  • Lot Size: Of Record
  • Road Frontage Type: City Street
  • Road Surface Type: Paved
  • Co List Office Mls Id: o432501236
  • Co List Office Phone: 859-240-0727
  • Ownership: Consumer
  • Directions: Just steps from Mainstrasse center. Take Exit 192 from I-75 N/S to 5th Street/Covington. Turn Right onto Main Street, Left onto W 6th Street. Property is the last house before underpass, on the right hand side.
  • Architectural Style: Historic
  • New Construction: No
  • Property Attached Yn: No
  • Structure Type: House
  • Location Tax Legal Info:Property Attached YN: No
  • Location Tax Legal Info:New Construction: No
  • Location Tax Legal Info:Elementary School: John G. Carlisle Elementary
  • Location Tax Legal Info:Middle or Junior School: Holmes Middle School
  • Location Tax Legal Info:High School: Holmes Senior High
  • Contract Info:Auction YN: No
  • General Property Description:Basement YN2: Yes
  • General Property Description:Fireplace YN: Yes
  • General Property Description:Lot Size Dimensions: Of Record
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Sewer:Public Sewer: Yes
  • Utilities:Cable Available: Yes
  • Utilities:Natural Gas Available: Yes
  • Water Source:Public: Yes
  • Room Details:Family Room YN: No
  • Room Details:Formal Dining Rm YN: No
  • General Property Description:Lot Size Acres: 0.0458
  • General Property Description:Living Area: 2046.0
  • General Property Description:Lot Size Square Feet: 1995.0
  • Structure Type:House: Yes
  • Laundry Features:Main Level: Yes
  • Security Features:Smoke Detector(s): Yes
  • Levels:Two: Yes
  • Location Tax Legal Info:Tax ID: 054-21-03-013.00
  • Appliances Refrigerators: Yes
  • General Property Description:Fireplaces Total: 1
  • Appliances Dryer: Yes
  • Washers: Yes
  • Fencing:Wood3: Yes
  • Foundation:Stone3: Yes
  • Fencing:Privacy: Yes
  • View:City3: Yes
  • Utilities:Water Available: Yes
  • Pool Features:Above Ground: Yes
  • Architecture:Historic: Yes
  • Roof:Membrane: Yes
  • Other Structures:Pergola: Yes
  • Special Features: None

Interior Features

  • Interior Amenities: Barn Door(s), Kitchen Island, Storage, Stone Counters, Pantry, High Speed Internet, Granite Counters, Entrance Foyer, Eat-in Kitchen, Chandelier, Built-in Features, Ceiling Fan(s), High Ceilings, Multi Panel Doors, Natural Woodwork, Recessed Lighting
  • Basement: Unfinished
  • Heating: Natural Gas
  • Levels: Two
  • Property Type: Residential
  • Appliances: Stainless Steel Appliance(s), Gas Range, Gas Oven, Dishwasher, Dryer, Microwave, Refrigerator, Washer
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • Fireplace Features: See Remarks
  • Fireplaces: 1
  • Fireplace: Yes
  • Living Area: 2046.0
  • Window Features: Vinyl Frames
  • Appliances Dishwasher: Yes
  • Appliances:Stainless Steel Appliance(s): Yes
  • Interior Features:Built-in Features2: Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features:Entrance Foyer2: Yes
  • Interior Features:Granite Counters: Yes
  • Interior Features:High Ceilings: Yes
  • Interior Features:Kitchen Island2: Yes
  • Interior Features:Multi Panel Doors: Yes
  • Interior Features:Pantry2: Yes
  • Interior Features:Storage2: Yes
  • Basement:Unfinished2: Yes
  • Appliances:Gas Range: Yes
  • Interior Features:Eat-in Kitchen2: Yes
  • Basement:Concrete Flooring: Yes
  • Interior Features:Natural Woodwork: Yes
  • Interior Features:High Speed Internet: Yes
  • Interior Features:Chandelier2: Yes
  • Interior Features:Stone Counters: Yes
  • Interior Features:Recessed Lighting: Yes
  • Appliances:Gas Oven: Yes
  • Interior Features:Barn Door(s): Yes
  • Fireplace Features:See Remarks41: Yes

Exterior Features

  • View: City, Neighborhood
  • Fencing: Privacy, Wood
  • Roof: Membrane
  • Lot Features: Cleared
  • Pool Features: Above Ground
  • View: Yes
  • Construction Type: Brick
  • Exterior Features: Private Yard, Hot Tub, Lighting
  • Foundation Details: Stone
  • Other Structures: Pergola
  • Patio And Porch Features: Deck
  • Construction Materials:Brick2: Yes
  • Window Features:Vinyl Frames: Yes
  • Patio and Porch Features:Deck: Yes
  • Exterior Features:Private Yard: Yes
  • Lot Features:Cleared: Yes
  • Exterior Features:Lighting: Yes
  • Exterior Features:Hot Tub: Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway, Off Street, On Street
  • Parking Features:Driveway: Yes
  • Parking Features:Off Street2: Yes
  • Parking Features:On Street: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Main Level
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Cable Available, Natural Gas Available, Water Available
  • Heating:Natural Gas2: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Association Information:Association YN: No

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: 1995.0
  • Zoning Description: Residential

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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

Tax History

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
2024 $6,246 $475,000 $15,000 $460,000
2023 $6,327 $475,000 $15,000 $460,000
2022 $3,441 $260,000 $15,000 $245,000
2021 $2,706 $176,000 $15,000 $161,000
2020 $2,693 $176,000 $15,000 $161,000
2019 $2,723 $176,000 $15,000 $161,000
2018 $2,780 $176,000 $15,000 $161,000
2017 $2,345 $145,500 $15,000 $130,500
2015 $2,930 $145,500 $15,000 $130,500
2014 $2,924 $145,500 $15,000 $130,500
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
09/05/2025 09/05/25 Pending -- -- --
08/18/2025 08/18/25 For Sale $550,000 +15.8% $269 / Sq Ft
06/17/2022 06/17/22 Sold $475,000 0.0% $232 / Sq Ft
05/14/2022 05/14/22 Pending -- -- --
05/05/2022 05/05/22 Price Changed $474,900 -3.1% $232 / Sq Ft
04/20/2022 04/20/22 Price Changed $489,900 -2.0% $239 / Sq Ft
03/16/2022 03/16/22 Price Changed $499,900 -9.1% $244 / Sq Ft
02/16/2022 02/16/22 For Sale $549,900 +111.5% $269 / Sq Ft
08/27/2021 08/27/21 Sold $260,000 -1.5% $127 / Sq Ft
08/06/2021 08/06/21 Pending -- -- --
08/06/2021 08/06/21 For Sale $264,000 -- $129 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

Purchase History

Date Type Sale Price Title Company
Warranty Deed $475,000 360 American Title
Warranty Deed $475,000 360 American Title
Warranty Deed $260,000 360 American Title Svcs Llc
Warranty Deed $176,000 Hallmark Title
Warranty Deed $145,500 Lawyers Title Cincinnati Inc
Interfamily Deed Transfer -- American Homeland Title Agen
Warranty Deed $48,000 --
Warranty Deed $20,000 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $380,000 New Conventional
Closed $380,000 New Conventional
Previous Owner $356,554 New Conventional
Previous Owner $170,720 New Conventional
Previous Owner $177,625 FHA
Previous Owner $145,500 Purchase Money Mortgage
Previous Owner $104,000 Stand Alone Refi Refinance Of Original Loan
Previous Owner $40,000 Purchase Money Mortgage
Source: Public Records

About the Listing Agent

Cindy Shetterly

Keller Williams Realty Services

(859) 484-8856

Section Image

#1 Team in our market, The Cindy Shetterly Team is a team of full-time Realtors who specialize in buying, selling, and investing in real estate. We are a team of 13 that takes you from the beginning to the end of your buying or selling process with experts on every step. Our agents study the market every day and are well-versed in new- construction, land, investment properties, and re-sale real estate transactions. With over 75 years of experience, we have worked in virtually every situation

Cindy's Other Listings

  • 1232 Clark St, Covington, KY 41011

    $235,000

    • 2 Beds
    • 2 Baths
    • 1232 Clark St
    • Covington, KY

    Charming 2-Bedroom Urban Gem Near Downtown Cincinnati!Discover the perfect blend of comfort and convenience in this updated 2 bed, 2 bath home just minutes from downtown Cincinnati. Featuring an open floor plan, this home offers great flow for entertaining or everyday living. The lower level is partially finished, adding extra living or flex space. Enjoy the privacy of a fully fenced

    Cindy Shetterly Keller Williams Realty Services

    Section Image
  • 246 Glenwood Ave, Ludlow, KY 41016

    $178,800 Pending

    • 2 Beds
    • 1 Bath
    • 1,037 Sq Ft
    • 246 Glenwood Ave
    • Ludlow, KY

    This is your chance to own a home in the vibrant Ludlow area! Just steps away from breweries, shops and groceries. This impeccably maintained two-bedroom, one bath home has been lovingly cared for by its previous owner for over 40 years. Enjoy newer flooring throughout, an updated kitchen, with barley-used appliances, and take in the seasonal river views from your fenced-in backyard. Whether

    Cindy Shetterly Keller Williams Realty Services

    Section Image
  • 2151 Fulton Ave, Cincinnati, OH 45206

    $160,000 Pending

    • 2 Beds
    • 1 Bath
    • 717 Sq Ft
    • 2151 Fulton Ave
    • Cincinnati, OH

    Historic Charm Meets Modern Living in Eden Park Top-floor 2-bedroom condo in a beautifully preserved 1873 building, just 2 miles from Fountain Square and the vibrant heart of downtown Cincinnati. Enjoy gleaming hardwood floors, soaring ceilings with exposed ductwork, deep-set dormer windows, and rich original woodwork that radiates timeless character. The open, airy layout feels both bright and

    Cindy Shetterly Keller Williams Distinctive RE

    Section Image
  • 114 Wessex Place, Fort Thomas, KY 41075

    $299,900

    • 3 Beds
    • 2.5 Baths
    • 1,800 Sq Ft
    • 114 Wessex Place
    • Fort Thomas, KY

    Beautifully updated 3 bed, 2.5 bath townhome in highly sought-after Fort Thomas! The open-concept first floor features a spacious living area with a cozy wood-burning fireplace, custom built-ins, and a well-appointed kitchen with walkout access to a private backyard—perfect for entertaining or relaxing. Convenient first-floor bedroom and laundry add flexibility and ease. Upstairs, you'll find two

    Cindy Shetterly Keller Williams Realty Services

    Section Image
  • 214 Grant St, Fort Thomas, KY 41075

    $75,000

    • Land
    • 0.24 Acre
    • $312,500 per Acre
    • 214 Grant St
    • Fort Thomas, KY

    Beautiful Lot in Fort Thomas! Just a few steps from Woodfill Elementary School. The city has already approved exemptions to the standard set back requirements.

    Cindy Shetterly Keller Williams Realty Services

    Section Image
  • 1048 Licking Pike, Newport, KY 41076

    $650,000

    • Land
    • 11.39 Acres
    • $57,068 per Acre
    • 1048 Licking Pike
    • Newport, KY

    Incredible commercial opportunity to be in a high traffic area with multiple zoning.

    Cindy Shetterly Keller Williams Realty Services

    Section Image
  • 113 Vernon Dr, Crestview Hills, KY 41017

    $545,000

    • 4 Beds
    • 4 Baths
    • 113 Vernon Dr
    • Crestview Hills, KY

    Sprawling Ranch in Prime Crestview Hills Location!This extra-large 4 bed, 4 bath ranch offers nearly half an acre of level, usable yard—perfect for entertaining, gardening, or relaxing in a park-like setting. Located directly across from the vibrant Crestview Hills Towne Center, you'll enjoy immediate access to top-tier shopping, dining, and amenities, all while tucked into a peaceful

    Cindy Shetterly Keller Williams Realty Services

    Section Image
  • 2201 Piazza Ridge, Covington, KY 41017

    $338,800 Pending

    • 3 Beds
    • 2.5 Baths
    • 2201 Piazza Ridge
    • Covington, KY

    If space and low maintenance are what you're looking for, this is the perfect place! This 3-bedroom plus study, 2.5-bath penthouse condo is ready for you. Enter through your private 2-car garage and head straight up to your luxury unit where style and comfort abound.The open-concept kitchen features a large island, granite countertops, and multi-height cabinetry offering ample storage,

    Cindy Shetterly Keller Williams Realty Services

    Section Image
  • 219 W 70th St, Cincinnati, OH 45216

    $168,000 Pending

    • 1,229 Sq Ft
    • 219 W 70th St
    • Cincinnati, OH

    Great Investment Opportunity! Add this versatile duplex to your portfolio and unlock multiple income streamsincluding the oversized 3-stall garage with rental potential Unit 1 offers up to 3 bedrooms and 2 full baths, featuring updated flooring and fresh paint throughoutmove-in ready or immediately rentable.The lower-level efficiency apartment generates solid rental income and adds to the

    Cindy Shetterly Keller Williams Distinctive RE

    Section Image

Source: Northern Kentucky Multiple Listing Service

MLS Number: 635446

Northern Kentucky Multiple Listing Service

APN: 054-21-03-013.00