Seller's Agent in 2025
Kellie McCoy
Paragon Realty Partners
(859) 630-8731
86 Total Sales
85 Us Highway 42 E Warsaw, KY 41095
8
Beds
12
Baths
9,413
Sq Ft
6.27
Acres
Highlights
- Docks
- Waterfront
- Deck
- River View
- Colonial Architecture
- Recreation Room
About This Home
As of May 2025Presenting the Opportunity of a Lifetime!! Here is the chance to own a historic luxury retreat on the banks of the Ohio River! This magnificent and unique estate would make a coveted private residence or continue the current tradition of operating a renowned, award winning, luxury Bed & Breakfast. Property is completely Turn-Key and comes fully furnished (even down to the silverware)! Boasting 7 Sumptuous Bedrooms & 9 Bathrooms in main house. You will also find a well appointed kitchen, conference room, billiards room with coffered ceilings & Living Room with a baby grand piano. Relax on front and back porches or the custom built, screened gazebo. The gazebo has cozy seating areas, dining area, an outdoor kitchen with granite counters and sweeping river views. This gorgeous River Front Estate sits on 6+ acres, includes a 6 car garage/events center and separate living quarters currently used by the Inn Keeper (This area could be rented out as a separate residence). Must see to fully appreciate all this fairytale property has to offer!! APPOINTMENT REQUIRED
Last Agent to Sell the Property
Paragon Realty Partners License #209902 Listed on: 02/10/2025
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
- Level Lot
- Private Yard
Parking
- 6 Car Garage
- Heated Garage
- Garage Door Opener
- Driveway
Property Views
- River
- Woods
Home Design
- Colonial Architecture
- Brick Exterior Construction
- Stone Foundation
- Poured Concrete
- Shingle Roof
Interior Spaces
- 9,413 Sq Ft Home
- 2-Story Property
- Built-In Features
- Bookcases
- Crown Molding
- Coffered Ceiling
- High Ceiling
- Ceiling Fan
- Skylights
- Chandelier
- 6 Fireplaces
- Gas Fireplace
- Double Hung Windows
- Bay Window
- Entrance Foyer
- Family Room
- Living Room
- Breakfast Room
- Formal Dining Room
- Den
- Library
- Recreation Room
- Bonus Room
- Storage In Attic
Kitchen
- Double Oven
- Electric Oven
- Electric Range
- Microwave
- Dishwasher
- Stainless Steel Appliances
- Granite Countertops
- Trash Compactor
- Disposal
Flooring
- Wood
- Carpet
- Ceramic Tile
Bedrooms and Bathrooms
- 8 Bedrooms
- Primary Bedroom on Main
- En-Suite Bathroom
- Walk-In Closet
- Double Vanity
- Shower Only
Laundry
- Dryer
- Washer
Unfinished Basement
- Partial Basement
- Basement Storage
Accessible Home Design
- Accessible Elevator Installed
- Accessible Full Bathroom
- Accessible Doors
- Accessible Approach with Ramp
Outdoor Features
- Docks
- Deck
- Patio
- Water Fountains
- Outdoor Kitchen
- Fire Pit
- Exterior Lighting
- Gazebo
- Separate Outdoor Workshop
- Shed
- Outbuilding
- Outdoor Grill
- Porch
Schools
- Gallatin County Elementary School
- Gallatin County Middle School
- Gallatin County High School
Utilities
- Forced Air Zoned Cooling and Heating System
- Geothermal Heating and Cooling
- Well
- Water Softener
- Septic Tank
- High Speed Internet
Community Details
- No Home Owners Association
Listing and Financial Details
- Assessor Parcel Number 013-53
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Feb 10, 2025
Closed on
May 8, 2025
Sold by
Mosmeier Amanda Marie
Bought by
Cnr Creations Llc
Seller's Agent
Kellie McCoy
Paragon Realty Partners
Buyer's Agent
Kellie McCoy
Paragon Realty Partners
List Price
$2,500,000
Sold Price
$2,200,000
Premium/Discount to List
-$300,000
-12%
Views
152
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-37.99%
Original Mortgage
$1,700,000
Outstanding Balance
$1,700,000
Interest Rate
6.64%
Mortgage Type
Seller Take Back
Estimated Equity
$357,627
Purchase Details
Closed on
Apr 8, 2024
Sold by
Branscum Hartman Ray
Bought by
Mosmeier Amanda Marie
Purchase Details
Closed on
Oct 27, 2020
Sold by
Riverside Developers Llc
Bought by
Branscum Hartman R and Branscum Amanda M
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
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
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
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $1,700,000 | Northwest Title | |
| Quit Claim Deed | -- | None Listed On Document | |
| Deed | $1,400,000 | Kentucky Land Title Agency | |
| Deed | $1,500,000 | -- |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $1,700,000 | Seller Take Back | |
| Previous Owner | $930,000 | Purchase Money Mortgage |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 05/08/2025 05/08/25 | Sold | $2,200,000 | -12.0% | $234 / Sq Ft |
| 03/31/2025 03/31/25 | Pending | -- | -- | -- |
| 02/10/2025 02/10/25 | For Sale | $2,500,000 | -- | $266 / Sq Ft |
Source: Northern Kentucky Multiple Listing Service
Tax History Compared to Growth
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
-
Kellie McCoy
Map
Source: Northern Kentucky Multiple Listing Service
MLS Number: 629816
APN: 013-53
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
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 Ten-X 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 2025 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.
Nearby Homes