Seller's Agent in 2023
Adam Hayhow
Coldwell Banker Realty
(513) 315-1501
207 Total Sales
1743 Coachtrail Dr Hebron, KY 41048
Hebron AreaEstimated Value: $1,055,000 - $1,121,000
6
Beds
5.5
Baths
6,900
Sq Ft
$159/Sq Ft
Est. Value
Highlights
- Eat-In Gourmet Kitchen
- River View
- Fireplace in Primary Bedroom
- North Pointe Elementary School Rated A
- 0.73 Acre Lot
- Deck
About This Home
As of October 2023Beautiful estate in picturesque Rivershore Farms! This custom built home features high-end finishes throughout on 3⁄4 acre lot with seasonal river views! New gourmet kitchen, updated flooring and paint throughout. Multi functional layout with 6+ bedrooms with adjoining baths. Expansive outdoor living space with fireplace and built-in grill. Entertain in the incredible lower level with pub-style bar, media room, wine tasting room and gym. Over 6900sf. Private setting with over-sized four car garage.
Last Agent to Sell the Property
Coldwell Banker Realty License #267911 Listed on: 06/28/2023
Last Buyer's Agent
Susan Huff
Huff Realty - Florence License #226913
Home Details
Home Type
- Single Family
Year Built
- Built in 2005
Lot Details
- 31,799 Sq Ft Lot
- Private Yard
HOA Fees
- $33 Monthly HOA Fees
Parking
- 4 Car Garage
- Side Facing Garage
- Driveway
Property Views
- River
- Valley
Home Design
- Traditional Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
- Stone
Interior Spaces
- 6,900 Sq Ft Home
- 2-Story Property
- Wet Bar
- Sound System
- Built-In Features
- Bookcases
- Woodwork
- Crown Molding
- Vaulted Ceiling
- Ceiling Fan
- Recessed Lighting
- Chandelier
- Wood Burning Fireplace
- Gas Fireplace
- Window Treatments
- Wood Frame Window
- French Doors
- Panel Doors
- Entrance Foyer
- Family Room with Fireplace
- 4 Fireplaces
- Living Room with Fireplace
- Breakfast Room
- Formal Dining Room
- Den
- Bonus Room
- Home Gym
Kitchen
- Eat-In Gourmet Kitchen
- Butlers Pantry
- Electric Oven
- Gas Cooktop
- Microwave
- Dishwasher
- Wine Cooler
- Stainless Steel Appliances
- Kitchen Island
- Granite Countertops
- Solid Wood Cabinet
Flooring
- Wood
- Carpet
- Tile
- Vinyl Plank
Bedrooms and Bathrooms
- 6 Bedrooms
- Fireplace in Primary Bedroom
- En-Suite Primary Bedroom
- Walk-In Closet
- Double Vanity
Laundry
- Laundry Room
- Laundry on main level
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Finished Basement Bathroom
- Stubbed For A Bathroom
Outdoor Features
- Deck
- Covered Patio or Porch
- Outdoor Grill
Schools
- North Pointe Elementary School
- Conner Middle School
- Conner Senior High School
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- 220 Volts
Listing and Financial Details
- Home warranty included in the sale of the property
- Assessor Parcel Number 034.00-02-084.00
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Jun 28, 2023
Closed on
Oct 16, 2023
Sold by
Bought by
Seller's Agent
Adam Hayhow
Coldwell Banker Realty
Buyer's Agent
Susan Huff
Huff Realty - Florence
List Price
$1,050,000
Sold Price
$960,000
Premium/Discount to List
-$90,000
-8.57%
Views
101
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$139,767
Avg. Annual Appreciation
5.09%
Original Mortgage
$460,000
Interest Rate
0.0718%
Mortgage Type
New Conventional
Purchase Details
Closed on
Jun 27, 2023
Sold by
Bought by
Purchase Details
Listed on
Feb 26, 2021
Closed on
May 13, 2021
Sold by
Bought by
Seller's Agent
Brent Gillman
New Castle Real Estate, LLC
Buyer's Agent
Brent Gillman
New Castle Real Estate, LLC
List Price
$840,000
Sold Price
$822,000
Premium/Discount to List
-$18,000
-2.14%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.80%
Original Mortgage
$657,600
Interest Rate
0.031%
Mortgage Type
New Conventional
Purchase Details
Closed on
Oct 5, 2012
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$250,000
Interest Rate
0.0358%
Mortgage Type
Credit Line Revolving
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
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $960,000 | None Listed On Document | ||
| $1,057,000 | Metro Title | ||
| $822,000 | 360 American Title Svcs Llc | ||
| $810,000 | None Available |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | $218,000 | ||
| Open | $466,000 | ||
| Closed | $460,000 | ||
| Previous Owner | $657,600 | ||
| Previous Owner | $250,000 | ||
| Previous Owner | $250,000 | ||
| Previous Owner | $417,000 | ||
| Previous Owner | $250,000 | ||
| Previous Owner | $199,000 | ||
| Previous Owner | $100,500 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 10/16/2023 10/16/23 | Sold | $960,000 | -6.3% | $139 / Sq Ft | |
| 08/08/2023 08/08/23 | Pending | -- | -- | -- | |
| 07/18/2023 07/18/23 | Price Changed | $1,025,000 | -2.4% | $149 / Sq Ft | |
| 06/28/2023 06/28/23 | For Sale | $1,050,000 | +27.7% | $152 / Sq Ft | |
| 05/14/2021 05/14/21 | Sold | $822,000 | -2.1% | $119 / Sq Ft | View Prior Sale |
| 03/19/2021 03/19/21 | Pending | -- | -- | -- | |
| 02/26/2021 02/26/21 | For Sale | $840,000 | 0.0% | $122 / Sq Ft | |
| 02/26/2021 02/26/21 | Price Changed | $840,000 | +2.2% | $122 / Sq Ft | |
| 01/01/2021 01/01/21 | Off Market | $822,000 | -- | -- | |
| 10/15/2020 10/15/20 | Price Changed | $835,000 | -2.3% | $121 / Sq Ft | |
| 09/22/2020 09/22/20 | Price Changed | $855,000 | -1.2% | $124 / Sq Ft | |
| 09/09/2020 09/09/20 | Price Changed | $865,000 | -0.6% | $125 / Sq Ft | |
| 07/28/2020 07/28/20 | For Sale | $870,000 | -- | $126 / Sq Ft |
Source: Northern Kentucky Multiple Listing Service
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| 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 |
|---|---|---|---|---|
| 2025 | $10,227 | $960,000 | $100,000 | $860,000 |
| 2024 | $10,045 | $960,000 | $100,000 | $860,000 |
| 2023 | $8,779 | $822,000 | $100,000 | $722,000 |
| 2022 | $8,818 | $822,000 | $100,000 | $722,000 |
| 2021 | $8,750 | $810,000 | $75,000 | $735,000 |
| 2020 | $8,835 | $810,000 | $75,000 | $735,000 |
| 2019 | $8,904 | $810,000 | $75,000 | $735,000 |
| 2018 | $8,839 | $810,000 | $75,000 | $735,000 |
| 2017 | $8,829 | $810,000 | $65,000 | $745,000 |
| 2015 | $8,764 | $810,000 | $65,000 | $745,000 |
| 2013 | -- | $810,000 | $65,000 | $745,000 |
Source: Public Records
Agents Affiliated with this Home
-
Adam Hayhow
-
S
Buyer's Agent in 2023
Susan Huff
Huff Realty - Florence
-
B
Seller's Agent in 2021
Brent Gillman
New Castle Real Estate, LLC
Map
Source: Northern Kentucky Multiple Listing Service
MLS Number: 614794
APN: 034.00-02-084.00
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 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.
Nearby Homes
- 720 Broomtail Ln
- 2016 Falling Water Ln
- 2011 Falling Water Ln
- 2097 Glenview Dr
- 1987 Montpelier Dr
- 1365 Dominion Trail
- 1804 Patton Dr
- 1911 Nettlewood Ct
- 2115 Canyon Ct
- 1833 Patton Dr
- 1023 Meadowbrook Ct
- 2309 Bentwood Ct
- 2309 Bentwood Ct
- 1522 Autumn Ridge Dr
- 909 Surfridge Dr
- 1413 Brookline Ct
- 1618 Ravine Trail
- 1759 Barons Cove
- 1709 Ledgestone Way
- 1745 Ledgestone Way
- 1747 Coachtrail Dr
- 1739 Coachtrail Dr
- 1738 Coachtrail Dr
- 1742 Coachtrail Dr
- 1737 Coachtrail Dr
- 1755 Coachtrail Dr
- 1734 Coachtrail Dr
- 1746 Coachtrail Dr
- 1775 Coachtrail Dr
- 27 Coachtrail Dr Unit 27
- 1905 Coachtrail Dr Unit 11
- 16 Coachtrail Dr Unit 16
- 689 Sulky Ct
- 689 Sulky Ct Unit H72
- 1750 Coachtrail Dr
- 1726 Coachtrail Dr
- 68 Coachtrail Dr
- 681 Sulky Ct
- 1722 Coachtrail Dr
- 1723 Coachtrail Dr
Your Personal Tour Guide
Ask me questions while you tour the home.