NOT LISTED FOR SALE

9217 Camp Ernst Rd Union, KY 41091

Estimated Value: $476,000

3 Beds
2 Baths
3,180 Sq Ft
$150/Sq Ft Est. Value

Last Sold November 01, 2022

Last sale price $500,000 $157 Per Sq Ft

Est. 5% decrease in value since last sale

Current estimated payment $2,725/month

Highlights

  • Barn
  • View of Trees or Woods
  • Heavily Wooded Lot
  • Longbranch Elementary School Rated A
  • 15.11 Acre Lot
  • Traditional Architecture

About This Home

As of November 2022

Welcome to a beautiful, secluded lot, 7 minutes from the heart of Union.
This property boasts 15.106 acres, beautiful mature trees, plenty of usable cleared outdoor space, and over 1,800 square ft of finished living space. It is a 3 bed, 2 bath home with a partially finished basement. The heating and cooling in the home are geothermal. Enjoy a coffee on the *new patio or on the covered front porch. The home has two garages, one 2 car garage on the main level and another 1 car garage in the basement. The property also includes a large barn with water and electric. This is a rare opportunity to have country living, yet only minutes away from the city! A home warranty will be provided by the seller. Schedule your tour today!

Last Agent to Sell the Property

Lauren Teepen

Keller Williams Realty Services License #269768 Listed on: 10/20/2022

Keller Williams Realty Services

Last Buyer's Agent

Doug Mayberry

Huff Realty - Florence License #186924

Huff Realty - Florence

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,491

Year Built

  • Built in 1994

Lot Details

  • 15.11 Acre Lot
  • Cleared Lot
  • Heavily Wooded Lot
  • Private Yard
  • 9275 Camp Ernst Rd. 10.610 Acres

Parking

  • 4 Car Garage
  • Front Facing Garage
  • Side Facing Garage
  • Driveway

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof

Interior Spaces

  • 3,180 Sq Ft Home
  • 2-Story Property
  • Wood Burning Fireplace
  • Insulated Windows
  • Bay Window
  • Family Room
  • Living Room with Fireplace
  • Formal Dining Room
  • Carpet
  • Views of Woods
  • Fire and Smoke Detector
  • Finished Basement

Kitchen

  • Electric Oven
  • Electric Cooktop
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Granite Countertops

Bedrooms and Bathrooms

  • 3 Bedrooms
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • 2 Full Bathrooms

Laundry

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

Outdoor Features

  • Covered Patio or Porch
  • Shed

Schools

  • Longbranch Elementary School
  • Ballyshannon Middle School
  • Cooper High School

Farming

  • Barn
  • Agricultural

Utilities

  • Cooling Available
  • Geothermal Heating and Cooling
  • Septic Tank

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Assessor Parcel Number 040.00-00-005.01

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,491

Year Built

Built in 1994

Lot Details

0

Parking

4

Listing Details

  • Cooling: Geothermal
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 15.11
  • Year Built: 1994
  • Lot Size: 15.106 Acres
  • Road Surface Type: Gravel, Paved
  • Directions: From Hathaway Road turn onto Camp Ernst Rd, drive 1.1 miles and the gravel driveway will be on your left. There is a small white fence at the end of the driveway. Drive down the driveway/road and it will be the first home on the left.
  • Architectural Style: Traditional
  • Garage Yn: Yes
  • 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: Longbranch
  • Location Tax Legal Info:Middle or Junior School: Ballyshannon Middle School
  • Location Tax Legal Info:High School: Cooper High School
  • Contract Info:Auction YN: No
  • General Property Description:Basement YN2: Yes
  • General Property Description:Fireplace YN: Yes
  • General Property Description:Lot Size Dimensions: 15.106 Acres
  • Appliances Microwave: Yes
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Room Type:Dining Room4: Yes
  • Room Type:Laundry Room3: Yes
  • Water Source:Public: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • General Property Description:Lot Size Acres: 15.106
  • General Property Description:Living Area: 3180.0
  • General Property Description:Lot Size Square Feet: 195846.0
  • Structure Type:House: Yes
  • Laundry Features:Laundry Room2: Yes
  • Laundry Features:Main Level: Yes
  • Miscellaneous Home Warranty: Yes
  • Security Features:Smoke Detector(s): Yes
  • Architecture:Traditional: Yes
  • Levels:Two: Yes
  • Location Tax Legal Info:Tax ID: 040.00-00-005.01
  • Appliances Refrigerators: Yes
  • Room Type:Living Room4: Yes
  • Other Structures:Shed(s): Yes
  • General Property Description:Fireplaces Total: 1
  • Appliances Dryer: Yes
  • Washers: Yes
  • View:TreesWoods: Yes
  • Utilities:Water Available: Yes
  • Vegetation:Partially Wooded: Yes
  • Percent Basement Finished: Yes
  • Zoning Description:Agricultural: Yes
  • Vegetation:Heavily Wooded: Yes
  • Other Structures:Barn(s): Yes
  • Road Surface Type:Gravel: Yes
  • Cooling:Geothermal2: Yes
  • Special Features: VirtualTour

Interior Features

  • Interior Amenities: Granite Counters
  • Basement: Finished
  • Heating: Geothermal
  • Levels: Two
  • Flooring: Carpet
  • Property Type: Residential
  • Appliances: Stainless Steel Appliance(s), Electric Cooktop, Electric Oven, Dishwasher, Dryer, Microwave, Refrigerator, Washer
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • Fireplace Features: Wood Burning
  • Fireplaces: 1
  • Fireplace: Yes
  • Living Area: 3180.0
  • Window Features: Bay Window(s), Insulated Window(s)
  • Appliances Dishwasher: Yes
  • Appliances:Electric Oven: Yes
  • Appliances:Stainless Steel Appliance(s): Yes
  • Interior Features:Granite Counters: Yes
  • Kitchen Features:Granite Countertops: Yes
  • Primary Bedroom Features:Bath Adjoins: Yes
  • Primary Bedroom Features:Carpet Flooring5: Yes
  • Primary Bedroom Features:Walk-In Closet(s): Yes
  • Fireplace Features:Wood Burning: Yes
  • Basement:Carpet Flooring7: Yes
  • Living Room Features:Carpet Flooring2: Yes
  • Living Room Features:Fireplace(s): Yes
  • Appliances:Electric Cooktop: Yes
  • Dining Room Features:Carpet Flooring3: Yes

Exterior Features

  • View: Trees/Woods
  • Roof: Shingle
  • Lot Features: Cleared, Raw Land, Wooded
  • View: Yes
  • Home Warranty: Yes
  • Construction Type: Brick
  • Exterior Features: Private Yard
  • Foundation Details: Poured Concrete
  • Other Structures: Garage(s), Barn(s), Shed(s)
  • Patio And Porch Features: Covered, Patio, Porch
  • Construction Materials:Brick2: Yes
  • Window Features:Insulated Window(s): Yes
  • Patio and Porch Features:Covered: Yes
  • Patio and Porch Features:Patio: Yes
  • Patio and Porch Features:Porch: Yes
  • Lot Features:Wooded: Yes
  • Exterior Features:Private Yard: Yes
  • Lot Features:Cleared: Yes
  • Lot Features:Raw Land: Yes
  • Window Features:Bay Window(s): Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway, Garage, Garage Faces Front, Garage Faces Side
  • General Property Description:Garage Spaces: 4.0
  • Parking Features:Driveway: Yes
  • Parking Features:Garage5: Yes
  • Parking Features:Garage Faces Front: Yes
  • Other Structures:Garage(s): Yes
  • Parking Features:Garage Faces Side: Yes

Utilities

  • Sewer: Septic Tank
  • Water Source: Public
  • Laundry Features: Laundry Room, Main Level
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Water Available
  • Sewer Septic Tank: Yes
  • Heating:Geothermal: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Association Information:Association YN: No

Schools

  • Elementary School: Longbranch
  • Junior High Dist: Boone Co Public
  • High School: Cooper High School
  • Middle Or Junior School: Ballyshannon Middle School

Lot Info

  • Lot Size Sq Ft: 195846.0
  • Additional Parcels Description: 9275 Camp Ernst Rd. 10.610 Acres
  • Zoning Description: Agricultural
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 20, 2022
Closed on
Nov 1, 2022
Sold by
Simpson Janice Claudene
Bought by
Wilson Andrew and Wilson Bridgette
Seller's Agent
Lauren Teepen
Keller Williams Realty Services
Buyer's Agent
Doug Mayberry
Huff Realty - Florence
List Price
$430,000
Sold Price
$500,000
Premium/Discount to List
$70,000
16.28%
Views
21
Current Estimated Value
$476,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$24,000
Avg. Annual Appreciation
-1.64%

Purchase Details

Closed on
Jul 17, 2013
Sold by
Huelsman Beverly S and Huelsman Beverly S
Bought by
Simpson Beverly Layne

Purchase Details

Closed on
Jan 31, 1995
Sold by
Simpson Leslie W
Bought by
Huelsman Beverly S

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$81,000
Interest Rate
7.38%
Mortgage Type
New Conventional
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
Wilson Andrew $500,000 360 American Title Services
Wilson Andrew $500,000 360 American Title Services
Simpson Beverly Layne $175,000 None Available
Huelsman Beverly S $107,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Huelsman Beverly S $81,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
11/01/2022 11/01/22 Sold $500,000 +16.3% $157 / Sq Ft
10/21/2022 10/21/22 Pending -- -- --
10/20/2022 10/20/22 For Sale $430,000 -- $135 / 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 $2,491 $294,600 $90,800 $203,800
2023 $2,502 $294,600 $90,800 $203,800
2022 $1,615 $233,200 $60,000 $173,200
2021 $1,693 $233,200 $60,000 $173,200
2020 $1,660 $233,200 $60,000 $173,200
2019 $1,680 $233,200 $60,000 $173,200
2018 $2,307 $233,200 $60,000 $173,200
2017 $1,997 $175,000 $39,000 $136,000
2015 $1,972 $175,000 $39,000 $136,000
2013 -- $175,000 $39,000 $136,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 608852

Northern Kentucky Multiple Listing Service

APN: 040.00-00-005.01