$769,900
PENDING

1977 Coachtrail Dr Hebron, KY 41048

Estimated payment $4,628/month

Total Views 507
3 Beds
4.5 Baths
4,132 Sq Ft
$186 Price per Sq Ft

Highlights

  • Eat-In Gourmet Kitchen
  • 2.04 Acre Lot
  • Stream or River on Lot
  • North Pointe Elementary School Rated A
  • Deck
  • Wooded Lot

About This Home

Located in the prestigious Rivershore Farms Subdivision, this Hebron KY home is perfect for those who love to entertain while enjoying privacy. Situated on approximately 2 acres, the curb appeal is enhanced by the gated circular driveway and mature landscaping. Inside, a dramatic 2-story foyer with a split staircase opens to multiple living spaces, including a formal dining room, and a chef's kitchen with stainless steel appliances and granite counters. The light-filled living room with arched windows overlooks a serene backyard waterfall and flows through a see-through fireplace into the hearth room. Retreat to the expansive primary suite with a luxury bath, or enjoy the convenience of a main-level ensuite. The massive finished lower level offers ornate coffered ceilings, a wet bar, fitness area, and walkout to the lush backyard. The oversized covered deck with composite decking is where you can relax overlooking your private estate setting, The oversized 3-car garage complete this property—all in an ideal location minutes from shopping, dining, and CVG airport.

Listing Agent

Jason Asch

eXp Realty LLC License #194210 Listed on: 08/29/2025

eXp Realty LLC

Co-Listing Agent

Teresa Gillum

eXp Realty, LLC License #188708

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,909

Year Built

  • Built in 1989

Lot Details

  • 2.04 Acre Lot
  • Aluminum or Metal Fence
  • Landscaped
  • Wooded Lot

HOA Fees

  • $35 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Side Facing Garage
  • Garage Door Opener
  • Driveway
  • On-Street Parking
  • Off-Street Parking

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof
  • Composition Roof
  • Wood Siding
  • Stone

Interior Spaces

  • 4,132 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Sound System
  • Built-In Features
  • Chair Railings
  • Cathedral Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • 2 Fireplaces
  • Double Sided Fireplace
  • Wood Burning Fireplace
  • Brick Fireplace
  • Gas Fireplace
  • Awning
  • Insulated Windows
  • Panel Doors
  • Entrance Foyer
  • Family Room
  • Living Room
  • Formal Dining Room
  • Home Office

Kitchen

  • Eat-In Gourmet Kitchen
  • Electric Oven
  • Electric Range
  • Microwave
  • Dishwasher
  • Wine Cooler
  • Stainless Steel Appliances
  • Kitchen Island
  • Granite Countertops
  • Utility Sink
  • Disposal

Flooring

  • Wood
  • Carpet
  • Luxury Vinyl Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • En-Suite Bathroom
  • Walk-In Closet
  • Dressing Area
  • Double Vanity
  • Shower Only
  • Built-In Shower Bench

Laundry

  • Laundry Room
  • Laundry on main level

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Basement Storage

Outdoor Features

  • Stream or River on Lot
  • Deck
  • Patio

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
  • High Speed Internet

Listing and Financial Details

  • Assessor Parcel Number 034.00-02-003.00

Community Details

Overview

  • Association fees include management
  • Stonegate Property Management Association, Phone Number (859) 534-0900

Security

  • Resident Manager or Management On Site

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,909

Year Built

Built in 1989

Lot Details

0

HOA Fees

$35 per month

Parking

3

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 2.04
  • Year Built: 1989
  • Lot Size: irregular
  • Road Frontage Type: City Street
  • Road Surface Type: Paved
  • Co List Office Mls Id: o432501863
  • Co List Office Phone: 859-600-1397
  • Ownership: Consumer
  • Directions: North on 237 to Right on Coachtrail.
  • Architectural Style: Traditional
  • Garage Yn: Yes
  • New Construction: No
  • Property Attached Yn: No
  • Location Tax Legal Info:Property Attached YN: No
  • Location Tax Legal Info:New Construction: No
  • Location Tax Legal Info:Elementary School: North Pointe Elementary
  • Location Tax Legal Info:Middle or Junior School: Conner Middle School
  • Location Tax Legal Info:High School: Conner Senior High
  • Location Tax Legal Info:Subdivision2: Rivershore Farms
  • Contract Info:Auction YN: No
  • General Property Description:Half Baths: 1
  • General Property Description:Basement YN2: Yes
  • General Property Description:Fireplace YN: Yes
  • General Property Description:Lot Size Dimensions: irregular
  • General Property Description:Approx SqFt2: 4132.0
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Sewer:Public Sewer: Yes
  • Utilities Electric Company: Owen Electric
  • Utilities Gas Company: Duke
  • Water Company: Boone County Water
  • Water Source:Public: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • General Property Description:Lot Size Acres: 2.0387
  • General Property Description:Living Area: 4132.0
  • General Property Description:Lot Size Square Feet: 88807.0
  • Laundry Features:Laundry Room2: Yes
  • Laundry Features:Main Level: Yes
  • Architecture:Traditional: Yes
  • Levels:Two: Yes
  • Location Tax Legal Info:Tax ID: 034.00-02-003.00
  • Appliances Refrigerators: Yes
  • Roof:Composition: Yes
  • General Property Description:Fireplaces Total: 2
  • Percent Basement Finished: Yes
  • Fencing:Aluminum: Yes
  • Electric 220 Volts: Yes
  • Electric:Fuses: Yes
  • Special Features: None

Interior Features

  • Interior Amenities: Kitchen Island, Wet Bar, Walk-In Closet(s), Sound System, High Speed Internet, Granite Counters, Entrance Foyer, Eat-in Kitchen, Built-in Features, Cathedral Ceiling(s), Ceiling Fan(s), High Ceilings, Multi Panel Doors, Wired for Sound
  • Basement: Full, Finished, Storage Space, Walk-Out Access
  • Heating: Natural Gas, Forced Air
  • Levels: Two
  • Property Type: Residential
  • Appliances: Wine Cooler, Stainless Steel Appliance(s), Electric Oven, Electric Range, Dishwasher, Disposal, Microwave, Refrigerator
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Fireplace Features: Double Sided, Brick, Gas, Wood Burning
  • Fireplaces: 2
  • Fireplace: Yes
  • Living Area: 4132.0
  • Window Features: Insulated Windows
  • Full Basement: Yes
  • Appliances Dishwasher: Yes
  • Appliances:Electric Oven: 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:Walk-In Closet(s)2: Yes
  • Interior Features:Wet Bar4: Yes
  • Basement:Walk-Out Access7: Yes
  • Appliances:Electric Range: Yes
  • Interior Features:Eat-in Kitchen2: Yes
  • Fireplace Features:Wood Burning: Yes
  • Basement:Storage Space: Yes
  • Fireplace Features:Brick3: Yes
  • Fireplace Features:Gas: Yes
  • Interior Features:High Speed Internet: Yes
  • Interior Features:Cathedral Ceiling(s): Yes
  • Basement:Wet Bar5: Yes
  • Interior Features:Wired for Sound: Yes
  • Basement:Built-in Features3: Yes
  • Appliances:WineBeverage Cooler: Yes
  • Interior Features:Sound System: Yes
  • Basement:Luxury Vinyl Flooring2: Yes
  • Fireplace Features:Double Sided: Yes

Exterior Features

  • Fencing: Aluminum
  • Roof: Composition, Shingle
  • Lot Features: Stream, Wooded
  • Construction Type: Brick, Stone, Wood Siding
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Deck, Patio
  • Construction Materials:Brick2: Yes
  • Window Features:Insulated Window(s): Yes
  • Patio and Porch Features:Deck: Yes
  • Patio and Porch Features:Patio: Yes
  • Construction Materials:Stone2: Yes
  • Lot Features:Wooded: Yes
  • Construction Materials:Wood Siding: Yes
  • Patio and Porch Features:Awning(s): Yes
  • Lot Features:Stream: Yes

Garage/Parking

  • Attached Garage: Yes
  • Parking Features: Attached, Driveway, Garage Door Opener, Garage Faces Side, Off Street, On Street
  • General Property Description:Garage Spaces: 3.0
  • Parking Features:Attached: Yes
  • Parking Features:Driveway: Yes
  • Parking Features:Garage Door Opener: Yes
  • Parking Features:Off Street2: Yes
  • Parking Features:On Street: Yes
  • Parking Features:Garage Faces Side: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Laundry Room, Main Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electric: 220 Volts, Fuses
  • Heating:Natural Gas2: Yes
  • Heating:Forced Air: Yes

Condo/Co-op/Association

  • Amenities: Landscaping
  • Association Fee: 425.0
  • Association Fee Frequency: Annually
  • Association: Yes

Association/Amenities

  • Association Information:Association YN: Yes
  • Association Information:Association Management Name 1: Stonegate Property Management
  • Association Information:Association Management Phone 1: (859) 534-0900
  • Association Information:Total Yearly Fees: 425.0
  • Association Information:Association Fee: 425.0
  • Association Information:Association Fee Frequency: Annually
  • Association Amenities:Management: Yes
  • Association Amenities:Landscaping: Yes

Fee Information

  • Association Fee Includes: Management

Schools

  • Elementary School: North Pointe Elementary
  • Junior High Dist: Boone Co Public
  • High School: Conner Senior High
  • Middle Or Junior School: Conner Middle School

Lot Info

  • Lot Size Sq Ft: 88807.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 $5,909 $561,800 $125,000 $436,800
2023 $4,896 $451,400 $125,000 $326,400
2022 $4,842 $451,400 $125,000 $326,400
2021 $4,909 $451,400 $125,000 $326,400
2020 $4,924 $451,400 $125,000 $326,400
2019 $4,672 $425,000 $100,000 $325,000
2018 $4,674 $425,000 $100,000 $325,000
2017 $4,633 $425,000 $65,000 $360,000
2015 $4,599 $425,000 $65,000 $360,000
2013 -- $500,000 $65,000 $435,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/31/2025 08/31/25 Pending -- -- --
08/29/2025 08/29/25 For Sale $769,900 -- $186 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

Purchase History

Date Type Sale Price Title Company
Fiduciary Deed $425,000 None Available
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $300,000 New Conventional
Closed $287,000 New Conventional
Closed $318,750 New Conventional
Source: Public Records

Source: Northern Kentucky Multiple Listing Service

MLS Number: 635812

Northern Kentucky Multiple Listing Service

APN: 034.00-02-003.00