NOT LISTED FOR SALE

10847 Charismatic Ln Union, KY 41091

Union Area

Estimated Value: $1,050,989

4 Beds
4.5 Baths
7,745 Sq Ft
$136/Sq Ft Est. Value

Sale Details

Date Sold: May 24, 2021

Last sale price $756,250 $98 Per Sq Ft

Est. 39% increase in value since last sale

Current estimated payment $6,602 / mo

Highlights

  • Spa
  • Gourmet Kitchen
  • 0.86 Acre Lot
  • New Haven Elementary School Rated A
  • View of Trees or Woods
  • Deck

About This Home

As of May 2021

Custom Built First Floor Master on .86 Acre Home Site in Exclusive Portion of Triple Crown * ONLY One of It's Kind * Open & Spacious Design with Gourmet Island Kitchen, Site Finished Hardwood Floors throughout 1st Floor * 3 Fireplaces * Great Room, Hearth Room (Built In's & Plantation Shutters), Morning Room, Formal DR & Study * Huge Secondary Bedrooms w/Private Baths * Finished Walk-Out Lower Level w/Covered Patio & Hot Tub * Lots of Unfinished Storage w/Exterior Access * Covered & Screened Rear Porch w/Trex Decking * Exercise Room could be a 5th BR * Impeccable Condition *

Last Agent to Sell the Property

John Lorms

Keller Williams Realty Service License #207396 Listed on: 04/01/2021

Keller Williams Realty Service

Last Buyer's Agent

Jane Ashcraft-West

RE/MAX Victory + Affiliates License #187308

RE/MAX Victory + Affiliates
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 Details

Home Type

  • Single Family

Year Built

  • Built in 2004

Lot Details

  • 37,462 Sq Ft Lot
  • Lot Dimensions are 169x221
  • Cul-De-Sac
  • Sloped Lot
  • Front and Back Yard Sprinklers
  • Wooded Lot

HOA Fees

  • $38 Monthly HOA Fees

Parking

  • 3 Car Garage
  • Driveway

Home Design

  • Transitional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof
  • Stone

Interior Spaces

  • 7,745 Sq Ft Home
  • 1.5-Story Property
  • Bookcases
  • Chair Railings
  • Crown Molding
  • Vaulted Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Chandelier
  • Marble Fireplace
  • Stone Fireplace
  • Gas Fireplace
  • Insulated Windows
  • Window Treatments
  • Picture Window
  • French Doors
  • Panel Doors
  • Family Room with Fireplace
  • 3 Fireplaces
  • Great Room
  • Living Room with Fireplace
  • Formal Dining Room
  • Views of Woods

Kitchen

  • Gourmet Kitchen
  • Breakfast Bar
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Solid Surface Countertops
  • Solid Wood Cabinet
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • Dual Vanity Sinks in Primary Bathroom
  • Primary Bathroom Bathtub Only
  • Primary Bathroom includes a Walk-In Shower

Finished Basement

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

Home Security

  • Home Security System
  • Fire and Smoke Detector

Outdoor Features

  • Spa
  • Deck
  • Covered Patio or Porch

Schools

  • New Haven Elementary School
  • Gray Middle School
  • Ryle High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Cable TV Available

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Assessor Parcel Number 064.16-07-242.00

Community Details

Overview

  • Association fees include management
  • Towne Properties Association, Phone Number (859) 291-5858
  • Triple Crown Country Club Subdivision

Recreation

  • Community Playground
  • Trails

Security

  • Resident Manager or Management On Site

Home Details

Home Type

Single Family

Year Built

Built in 2004

Lot Details

0.86 Acres

HOA Fees

$38 per month

Parking

3

Listing Details

  • Cooling: Central Air
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.86
  • Year Built: 2004
  • Lot Size: 169x221
  • Road Frontage Type: City Street
  • Subdivision Name: Triple Crown Country Club
  • Directions: Triple Crown Blvd. to Secretariat Run to Charismatic Lane. Home is located in the Cul-de-Sac
  • Architectural Style: Transitional
  • 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: New Haven Elementary
  • Location Tax Legal Info:Middle or Junior School: Gray Middle School
  • Location Tax Legal Info:High School: Ryle High
  • Location Tax Legal Info:Subdivision2: Triple Crown Country Club
  • Contract Info:Auction YN: No
  • General Property Description:Half Baths: 1
  • General Property Description:Fireplace YN: Yes
  • General Property Description:Lot Size Dimensions: 169x221
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Sewer:Public Sewer: Yes
  • Utilities:Cable Available: Yes
  • Utilities:Natural Gas Available: Yes
  • Utilities Electric Company: Owen Electric
  • Utilities Gas Company: Duke Energy
  • Water Company: Boone Co. Water Dept.
  • Water Source:Public: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • General Property Description:Lot Size Acres: 0.86
  • General Property Description:Living Area: 7745.0
  • General Property Description:Lot Size Square Feet: 37461.6
  • Structure Type:House: Yes
  • Miscellaneous Home Warranty: Yes
  • Security Features:Smoke Detector(s): Yes
  • Location Tax Legal Info:Tax ID: 064.16-07-242.00
  • Appliances Refrigerators: Yes
  • General Property Description:Fireplaces Total: 3
  • View:TreesWoods: Yes
  • Architecture:Transitional: Yes
  • Percent Basement Finished: Yes
  • Room Type:Great Room4: Yes
  • Security Features:Security System: Yes
  • Levels:One and One Half: Yes
  • Pets Allowed:Pets Allowed: Yes
  • Special Features: None

Interior Features

  • Interior Amenities: Crown Molding, Ceiling Fan(s), French Doors, High Ceilings, Multi Panel Doors, Recessed Lighting, Vaulted Ceiling(s)
  • Basement: Full, Finished, Walk-Out Access
  • Heating: Natural Gas, Forced Air
  • Levels: One and One Half
  • Flooring: Carpet
  • Property Type: Residential
  • Appliances: Dishwasher, Disposal, Microwave, Oven, Range, Refrigerator
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Fireplace Features: Stone, Ceramic, Gas, Marble
  • Fireplaces: 3
  • Fireplace: Yes
  • Living Area: 7745.0
  • Window Features: Insulated Window(s), Picture Window(s)
  • Full Basement: Yes
  • Appliances Dishwasher: Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features:High Ceilings: Yes
  • Interior Features:Multi Panel Doors: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Basement:Walk-Out Access7: Yes
  • Interior Features:French Doors: Yes
  • Kitchen Features Pantry: Yes
  • Kitchen Features:Wood Cabinets: Yes
  • Primary Bedroom Features:Bath Adjoins: Yes
  • Primary Bedroom Features:Walk-In Closet(s): Yes
  • Kitchen Features:Walk-Out Access3: Yes
  • Primary Bath Features:Shower: Yes
  • Basement:Fireplace(s)7: Yes
  • Interior Features:Crown Molding: Yes
  • Living Room Features:Wood Flooring2: Yes
  • Dining Room Features:Wood Flooring3: Yes
  • Family Room Features:Fireplace(s)4: Yes
  • Kitchen Features:Wood Flooring4: Yes
  • Basement:Carpet Flooring7: Yes
  • Fireplace Features:Gas: Yes
  • Family Room Features:Window Treatments4: Yes
  • Living Room Features:Fireplace(s): Yes
  • Interior Features:Vaulted Ceiling(s): Yes
  • Dining Room Features:Chandelier: Yes
  • Kitchen Features:Breakfast Bar: Yes
  • Primary Bedroom Features:Window Treatments6: Yes
  • Kitchen Features:Solid Surface Counters: Yes
  • Fireplace Features:Ceramic: Yes
  • Interior Features:Recessed Lighting: Yes
  • Kitchen Features:Gourmet Kitchen: Yes
  • Primary Bath Features:Double Vanity: Yes
  • Primary Bedroom Features:Wood Flooring7: Yes
  • Fireplace Features:Stone4: Yes
  • Primary Bath Features:Ceramic Tile Flooring: Yes
  • Appliances Range: Yes
  • Dining Room Features:Window Treatments2: Yes
  • Primary Bath Features:Tub: Yes
  • Family Room Features:Wood Flooring5: Yes
  • Family Room Features:Bookcases2: Yes
  • Dining Room Features:Chair Rail: Yes
  • Fireplace Features:Marble: Yes

Exterior Features

  • View: Trees/Woods
  • Roof: Shingle
  • Lot Features: Cul-De-Sac, Sloped, Sprinklers In Front, Sprinklers In Rear, Wooded
  • View: Yes
  • Home Warranty: Yes
  • Construction Type: Brick, Stone
  • Exterior Features: Hot Tub
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Covered, Deck, Patio
  • Construction Materials:Brick2: Yes
  • Window Features:Insulated Window(s): Yes
  • Patio and Porch Features:Covered: Yes
  • Patio and Porch Features:Deck: Yes
  • Patio and Porch Features:Patio: Yes
  • Construction Materials:Stone2: Yes
  • Window Features:Picture Window(s): Yes
  • Lot Features:Wooded: Yes
  • Lot Features:Cul-De-Sac: Yes
  • Lot Features:Sloped: Yes
  • Lot Features:Sprinklers In Front: Yes
  • Lot Features:Sprinklers In Rear: Yes
  • Exterior Features:Hot Tub: Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway
  • General Property Description:Garage Spaces: 3.0
  • Parking Features:Driveway: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Security: Security System, Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Cable Available, Natural Gas Available
  • Heating:Natural Gas2: Yes
  • Heating:Forced Air: Yes

Condo/Co-op/Association

  • Amenities: Playground, Trail(s)
  • Association Fee: 450.0
  • Association Fee Frequency: Annually
  • Association: Yes
  • ResoAssociationFeeFrequency: Annually

Association/Amenities

  • Association Information:Association YN: Yes
  • Association Information:Association Management Name 1: Towne Properties
  • Association Information:Association Management Phone 1: 859-291-5858
  • Association Information:Association Fee: 450.0
  • Association Information:Association Fee Frequency: Annually
  • Association Amenities:Management: Yes
  • Association Amenities:Playground: Yes
  • Association Amenities:Trail(s): Yes

Fee Information

  • Association Fee Includes: Management

Schools

  • Elementary School: New Haven Elementary
  • Junior High Dist: Boone Co Public
  • High School: Ryle High
  • Middle Or Junior School: Gray Middle School

Lot Info

  • Lot Size Sq Ft: 37461.6
  • Zoning Description: {"Residential":true}
  • ResoLotSizeUnits: Acres

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
Apr 1, 2021
Closed on
May 24, 2021
Sold by
Bought by
Seller's Agent
John Lorms
Keller Williams Realty Service
Buyer's Agent
Jane Ashcraft-West
RE/MAX Victory + Affiliates
List Price
$775,000
Sold Price
$756,250
Premium/Discount to List
-$18,750
-2.42%
Current Estimated Value
$1,050,989

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$294,739
Avg. Annual Appreciation
6.55%
Original Mortgage
$642,750
Outstanding Balance
$570,164
Interest Rate
3%
Mortgage Type
New Conventional
Estimated Equity
$480,825

Purchase Details

Closed on
Jun 14, 2019
Sold by
Bought by
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Agents Specializing in Union, KY

  • Cara Chitwood Real Estate Agent - Keller Williams Realty Service

    Cara Chitwood

    Keller Williams Realty Service

    (513) 854-6469

    112 Total Sales

    13 in Union

    $200K - $619K Price Range

    Cara Chitwood
     Section Image
  • Kathy Crawford Real Estate Agent - ERA Real Solutions Realty

    Kathy Crawford

    ERA Real Solutions Realty

    (859) 600-0770

    39 Total Sales

    5 in Union

    $173K - $570K Price Range

    Kathy Crawford
     Section Image
  • Brandon Stamper Real Estate Agent - Plum Tree Realty

    Brandon Stamper

    Plum Tree Realty

    (859) 888-1472

    127 Total Sales

    10 in Union

    $163K - $865K Price Range

    Brandon Stamper
     Section Image
  • Lena Keith Real Estate Agent - Pivot Realty Group

    Lena Keith

    Responds Quickly

    Pivot Realty Group

    (859) 279-4304

    108 Total Sales

    5 in Union

    $173K - $558K Price Range

    Lena Keith
     Section Image
  • Ben Walling Real Estate Agent - Cahill Real Estate Services

    Ben Walling

    Cahill Real Estate Services

    (513) 586-6760

    91 Total Sales

    3 in Union

    $270K - $769K Price Range

    Ben Walling
     Section Image
  • Cherish Jessup Real Estate Agent - eXp Realty

    Cherish Jessup

    Responds Quickly

    eXp Realty

    (859) 279-4286

    74 Total Sales

    7 in Union

    $163K - $360K Price Range

    Cherish Jessup
     Section Image
See All Agents

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
$756,250 Agility Closing & Title Svcs
$675,000 Lawyers Ttl Of Cincinnati In
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 $63,000
Open $642,750
Previous Owner $250,000
Previous Owner $320,000
Previous Owner $30,000
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
05/24/2021 05/24/21 Sold $756,250 -2.4% $98 / Sq Ft
04/01/2021 04/01/21 Pending -- -- --
04/01/2021 04/01/21 For Sale $775,000 -- $100 / 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 $9,306 $828,300 $125,000 $703,300
2024 $8,368 $756,300 $125,000 $631,300
2023 $8,607 $756,300 $125,000 $631,300
2022 $8,642 $756,300 $125,000 $631,300
2021 $7,817 $675,000 $125,000 $550,000
2020 $7,889 $675,000 $125,000 $550,000
2019 $7,661 $690,000 $125,000 $565,000
2018 $7,643 $690,000 $125,000 $565,000
2017 $7,417 $635,600 $120,000 $515,600
2015 $7,367 $635,600 $120,000 $515,600
2013 -- $635,600 $120,000 $515,600
Source: Public Records

Agents Affiliated with this Home

  • John Lorms Real Estate Agent - Keller Williams Realty Service

    Seller's Agent in 2021

    John Lorms

    Keller Williams Realty Service

    (859) 486-0060

    35 Total Sales

    John Lorms
    Section Image

  • J

    Buyer's Agent in 2021

    Jane Ashcraft-West

    RE/MAX

    Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 547253

Northern Kentucky Multiple Listing Service

APN: 064.16-07-242.00

Kentucky Boone County Union 41091

10847 Charismatic Ln, Union, KY

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.

Northern Kentucky Multiple Listing Service 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
Your Personal Tour Guide

Ask me questions while you tour the home.