NOT LISTED FOR SALE

Estimated Value: $989,000 - $2,209,344

8 Beds
10 Baths
9,413 Sq Ft
$175/Sq Ft Est. Value

Last Sold October 27, 2020

Last sale price $1,400,000 $149 Per Sq Ft

Est. 17% increase in value since last sale

Current estimated payment $10,123/month

13 Days on Market

Highlights

  • Guest House
  • River View
  • Waterfront
  • Gourmet Kitchen
  • Granite Flooring
  • Deck

About This Home

As of October 2020

Unique opportunity to own a magnificent historic home set on the high bank of the Ohio River! Currently operating as award-winning Riverside Inn Bed&Breakfast. Make this your private residence with lots of private and shared spaces, enjoy as a weekend retreat, continue to operate as B&B/event venue, or rent out one wing and live in the other-many options! Innkeeper's Suite, Conference Room, Elevator, unfinished Attic, Huge Gazebo w/kitchen, dining and lounge, 6-bay garage, out-building with 2 half baths. Furniture, fixtures and equipment included. No expense spared in the complete renovation!

Last Agent to Sell the Property

Amy Mersch

Robinson Sotheby's International Realty License #219739 Listed on: 08/12/2020

Co-Listed By

Lee Robinson

Robinson Sotheby's International Realty License #190017

Last Buyer's Agent

Kellie McCoy

Paragon Realty Partners License #209902

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $14,896

Year Built

  • Built in 1869

Lot Details

  • 6.27 Acre Lot
  • Waterfront
  • Wood Fence
  • Historic Home

Parking

  • 6 Car Garage
  • Driveway
  • Off-Street Parking

Home Design

  • Brick Exterior Construction
  • Stone Foundation
  • Shingle Roof

Interior Spaces

  • 9,413 Sq Ft Home
  • 2-Story Property
  • Elevator
  • Crown Molding
  • High Ceiling
  • Ceiling Fan
  • Chandelier
  • Gas Fireplace
  • Double Hung Windows
  • Family Room
  • Living Room with Fireplace
  • 6 Fireplaces
  • Formal Dining Room
  • Bonus Room
  • River Views
  • Partial Basement
  • Storage In Attic

Kitchen

  • Gourmet Kitchen
  • Microwave
  • Dishwasher
  • Wine Cooler
  • Trash Compactor
  • Disposal

Flooring

  • Wood
  • Granite
  • Marble
  • Slate Flooring
  • Ceramic Tile

Bedrooms and Bathrooms

  • 8 Bedrooms
  • En-Suite Primary Bedroom
  • Primary Bathroom includes a Walk-In Shower

Laundry

  • Dryer
  • Washer

Outdoor Features

  • Deck
  • Covered Patio or Porch
  • Gazebo
  • Shed
  • Outdoor Grill

Additional Homes

  • Guest House

Schools

  • Gallatin County Upper Elementary School
  • Gallatin County Middle School
  • Gallatin County High School

Utilities

  • Central Air
  • Geothermal Heating and Cooling
  • 220 Volts
  • Propane
  • Well
  • Septic Tank
  • Cable TV Available

Community Details

  • No Home Owners Association
  • The community has rules related to allowing corporate owners

Listing and Financial Details

  • Assessor Parcel Number 013-53

Home Details

Home Type

Single Family

Est. Annual Taxes

$14,896

Year Built

Built in 1869

Lot Details

0

Parking

6

Listing Details

  • Cooling: Central Air
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 6.27
  • Year Built: 1869
  • Lot Size: irregular
  • Co List Office Mls Id: o656001955
  • Co List Office Phone: 513-321-6000
  • Directions: US Highway 42, East of the City of Warsaw to address.
  • Architectural Style: Historic
  • New Construction: No
  • Property Attached Yn: No
  • Structure Type: House
  • ResoPropertyType: Residential
  • Location Tax Legal Info:Property Attached YN: No
  • Location Tax Legal Info:New Construction: No
  • Location Tax Legal Info:Elementary School: Gallatin County Upper Elementary
  • Location Tax Legal Info:Middle or Junior School: Gallatin County Middle School
  • Location Tax Legal Info:High School: Gallatin County High
  • Contract Info:Auction YN: No
  • General Property Description:Half Baths: 3
  • General Property Description:Fireplace YN: Yes
  • General Property Description:Lot Size Dimensions: irregular
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Roof:Shingle: Yes
  • Utilities:Cable Available: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • General Property Description:Lot Size Acres: 6.27
  • General Property Description:Living Area: 9413.0
  • General Property Description:Lot Size Square Feet: 273121.2
  • Structure Type:House: Yes
  • Levels:Two: Yes
  • Location Tax Legal Info:Tax ID: 013-53
  • Appliances Refrigerators: Yes
  • Other Structures:Shed(s): Yes
  • General Property Description:Fireplaces Total: 6
  • Appliances Dryer: Yes
  • Washers: Yes
  • Fencing:Wood3: Yes
  • Foundation:Stone3: Yes
  • Room Type:Bonus Room2: Yes
  • Utilities:Propane3: Yes
  • Property Ownership:Corporate: Yes
  • Architecture:Historic: Yes
  • Other Structures:Storage: Yes
  • Other Structures:Gazebo: Yes
  • Other Structures:Guest House: Yes
  • View:River: Yes
  • Water Source:Well: Yes
  • Special Features: None

Interior Features

  • Interior Amenities: Crown Molding, 220 Volts, Attic Storage, Ceiling Fan(s), Elevator, High Ceilings
  • Basement: Partial
  • Heating: Geothermal
  • Levels: Two
  • Property Type: Residential
  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Oven, Range, Refrigerator, Trash Compactor, Washer, Wine/Beverage Cooler
  • Full Bathrooms: 7
  • Half Bathrooms: 3
  • Total Bedrooms: 8
  • Fireplace Features: Gas
  • Fireplaces: 6
  • Fireplace: Yes
  • Living Area: 9413.0
  • Window Features: Double Hung
  • Appliances Dishwasher: Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features:High Ceilings: Yes
  • Primary Bedroom Features:Bath Adjoins: Yes
  • Primary Bath Features:Shower: Yes
  • Interior Features:_two_20 Volts: Yes
  • Interior Features:Crown Molding: Yes
  • Living Room Features:Wood Flooring2: Yes
  • Appliances:Trash Compactor: Yes
  • Fireplace Features:Gas: Yes
  • Interior Features:Attic Storage: Yes
  • Living Room Features:Fireplace(s): Yes
  • Kitchen Features:Ceramic Tile Flooring2: Yes
  • Dining Room Features:Chandelier: Yes
  • Dining Room Features:Walk-Out Access2: Yes
  • Primary Bedroom Features:Window Treatments6: Yes
  • Kitchen Features:Gourmet Kitchen: Yes
  • Primary Bedroom Features:Wood Flooring7: Yes
  • Primary Bath Features:Ceramic Tile Flooring: Yes
  • Appliances Range: Yes
  • Dining Room Features:Window Treatments2: Yes
  • Basement:Partial: Yes
  • Primary Bath Features:Granite Flooring3: Yes
  • Primary Bath Features:Marble Flooring3: Yes
  • Primary Bath Features:Slate Flooring3: Yes
  • Appliances:WineBeverage Cooler: Yes
  • Interior Features:Elevator: Yes

Exterior Features

  • View: River
  • Fencing: Wood
  • Roof: Shingle
  • Lot Features: Waterfront
  • View: Yes
  • Construction Type: Brick
  • Exterior Features: Outdoor Grill
  • Foundation Details: Stone
  • Other Structures: Gazebo, Guest House, Shed(s), Storage
  • Patio And Porch Features: Covered, Deck, Patio, Porch
  • Construction Materials:Brick2: Yes
  • Patio and Porch Features:Covered: Yes
  • Patio and Porch Features:Deck: Yes
  • Patio and Porch Features:Patio: Yes
  • Patio and Porch Features:Porch: Yes
  • Window Features:Double Hung: Yes
  • Exterior Features:Outdoor Grill: Yes
  • Lot Features:Waterfront: Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway, Off Street
  • General Property Description:Garage Spaces: 6.0
  • Parking Features:Driveway: Yes
  • Parking Features:Off Street2: Yes

Utilities

  • Sewer: Septic Tank
  • Water Source: Well
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Cable Available, Propane
  • Sewer Septic Tank: Yes
  • Heating:Geothermal: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Association Information:Association YN: No

Schools

  • Elementary School: Gallatin County Upper Elementary
  • Junior High Dist: Gallatin Co Public
  • High School: Gallatin County High
  • Middle Or Junior School: Gallatin County Middle School

Lot Info

  • Lot Size Sq Ft: 273121.2
  • Zoning Description: Residential
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
May 8, 2025
Sold by
Mosmeier Amanda Marie
Bought by
Cnr Creations Llc
Current Estimated Value
$1,642,836

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,700,000
Outstanding Balance
$1,700,000
Interest Rate
6.64%
Mortgage Type
Seller Take Back
Estimated Equity
-$57,164

Purchase Details

Closed on
Apr 8, 2024
Sold by
Branscum Hartman Ray
Bought by
Mosmeier Amanda Marie

Purchase Details

Listed on
Aug 12, 2020
Closed on
Oct 27, 2020
Sold by
Riverside Developers Llc
Bought by
Branscum Hartman R and Branscum Amanda M
Seller's Agent
Amy Mersch
Robinson Sotheby's International Realty
Buyer's Agent
Kellie McCoy
Paragon Realty Partners
List Price
$1,450,000
Sold Price
$1,400,000
Premium/Discount to List
-$50,000
-3.45%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.35%
Original Mortgage
$930,000
Interest Rate
2.8%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
May 14, 2010
Sold by
Jackson Elizabeth Roberts
Bought by
Riverside Developers Llc
Source: Public Records

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

Purchase History

Date Buyer Sale Price Title Company
Cnr Creations Llc $1,700,000 Northwest Title
Mosmeier Amanda Marie -- None Listed On Document
Branscum Hartman R $1,400,000 Kentucky Land Title Agency
Riverside Developers Llc $1,500,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Cnr Creations Llc $1,700,000
Previous Owner Branscum Hartman R $930,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
10/27/2020 10/27/20 Sold $1,400,000 -3.4% $149 / Sq Ft
08/25/2020 08/25/20 Pending -- -- --
08/12/2020 08/12/20 For Sale $1,450,000 -- $154 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

Tax History Compared to Growth

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 $14,896 $1,400,000 $261,700 $1,138,300
2023 $15,008 $1,400,000 $261,700 $1,138,300
2022 $15,064 $1,400,000 $261,700 $1,138,300
2021 $15,176 $1,400,000 $261,700 $1,138,300
2020 $14,248 $1,283,420 $261,700 $1,021,720
2019 $14,330 $1,283,420 $261,700 $1,021,720
2018 $14,335 $1,283,420 $261,700 $1,021,720
2017 $14,335 $1,283,420 $261,700 $1,021,720
2016 -- $1,283,420 $261,700 $1,021,720
2014 $11,807 $1,067,920 $46,200 $1,021,720
2011 $11,807 $1,062,720 $41,000 $1,021,720
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Source: Northern Kentucky Multiple Listing Service

MLS Number: 540642

Northern Kentucky Multiple Listing Service

APN: 013-53