NOT LISTED FOR SALE

5017 Loch Dr Union, KY 41091

Union Area

Estimated Value: $577,590

5 Beds
4 Baths
4,445 Sq Ft
$130/Sq Ft Est. Value

Sale Details

Date Sold: July 21, 2023

Last sale price $532,000 $120 Per Sq Ft

Est. 9% increase in value since last sale

Current estimated payment $3,833 / mo

16 Days on Market

Highlights

  • Media Room
  • Open Floorplan
  • Deck
  • Longbranch Elementary School Rated A
  • Clubhouse
  • Recreation Room

About This Home

As of July 2023

Truly Impeccable! You'll love this extended Arlinghaus Mariemont floor plan located only a 4 minute walk to the pool & boasting of an open floor plan-ample natural light-hand scraped hardwood floors-1st floor study-gourmet kitchen with Granite countertops, tiled backsplash, stainless appliances & touch free faucet-enormous owner's suite with soaring ceilings, soaking tub, separate shower, & custom California walk in closet-large guest bedrooms with walk in closets-2nd floor family room & laundry-finished lower level with a possible 5th bedroom, enormous rec room, private theatre & walkout-awesome covered deck overlooking the flat fenced yard with paver stone patio & fire pit. This home truly has it all!

Last Agent to Sell the Property

The Treas Team

Huff Realty - Florence Listed on: 06/26/2023

Huff Realty - Florence

Last Buyer's Agent

Caitlyn Campbell

ERA Real Solutions LLC License #265237

ERA Real Solutions 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 Details

Home Type

  • Single Family

Year Built

  • Built in 2015

Lot Details

  • 11,761 Sq Ft Lot
  • Aluminum or Metal Fence
  • Landscaped
  • Cleared Lot

HOA Fees

  • $46 Monthly HOA Fees

Parking

  • 2 Car Garage
  • Front Facing Garage
  • Driveway

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof
  • Vinyl Siding
  • Stone

Interior Spaces

  • 4,445 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Crown Molding
  • Tray Ceiling
  • Vaulted Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Chandelier
  • Stone Fireplace
  • Gas Fireplace
  • Vinyl Clad Windows
  • Insulated Windows
  • Transom Windows
  • French Doors
  • Panel Doors
  • Entrance Foyer
  • Family Room
  • Living Room with Fireplace
  • Sitting Room
  • Breakfast Room
  • Formal Dining Room
  • Media Room
  • Home Office
  • Recreation Room
  • Storage Room
  • Basement

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Gas Range
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Granite Countertops
  • Solid Wood Cabinet
  • Utility Sink

Flooring

  • Wood
  • Carpet
  • Laminate

Bedrooms and Bathrooms

  • 5 Bedrooms
  • En-Suite Primary Bedroom
  • En-Suite Bathroom
  • Walk-In Closet
  • Double Vanity

Laundry

  • Laundry Room
  • Laundry on upper level

Outdoor Features

  • Deck
  • Patio
  • Fire Pit
  • Porch

Schools

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

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas

Listing and Financial Details

  • Assessor Parcel Number 051.00-15-074.00

Community Details

Overview

  • Association fees include association fees
  • Towne Properties Association, Phone Number (513) 489-4059

Amenities

  • Clubhouse

Recreation

  • Community Playground
  • Community Pool
  • Trails

Home Details

Home Type

Single Family

Year Built

Built in 2015

Lot Details

0.27 Acres

HOA Fees

$46 per month

Parking

2

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.27
  • Year Built: 2015
  • Lot Size: Of record
  • MLS Status: Sold
  • Standard Status: Closed
  • Directions: 42 to Old Union to Orleans Blvd to Longbranch to Left onto Ballyshannon Way to Right onto Loch Dr.
  • 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:Half Baths: 2
  • General Property Description:Basement YN2: Yes
  • General Property Description:Fireplace YN: Yes
  • General Property Description:Lot Size Dimensions: Of record
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Room Type:Dining Room4: Yes
  • Room Type:Entry: Yes
  • Room Type:Family Room4: Yes
  • Room Type:Laundry Room3: Yes
  • Sewer:Public Sewer: Yes
  • Utilities Electric Company: Owen
  • Utilities Gas Company: Duke
  • Water Company: Boone County
  • Water Source:Public: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • General Property Description:Lot Size Acres: 0.27
  • General Property Description:Living Area: 4445.0
  • Structure Type:House: Yes
  • Room Type:Breakfast Room2: Yes
  • Room Type:Breakfast Room Level: First
  • Architecture:Traditional: Yes
  • Laundry Features:Upper Level: Yes
  • Levels:Two: Yes
  • Location Tax Legal Info:Tax ID: 051.00-15-074.00
  • Appliances Refrigerators: Yes
  • Room Type:Living Room4: Yes
  • General Property Description:Fireplaces Total: 1
  • Room Type:Study: Yes
  • Roof:Asphalt: Yes
  • Entry Features:Wood Flooring: Yes
  • Fencing:Metal4: Yes
  • Study Room Features:Carpet Flooring13: Yes
  • Recreation Room Features:Laminate Flooring12: Yes
  • Recreation Room Features:Recessed Lighting10: Yes
  • Fencing Fenced: Yes
  • Special Features: VirtualTour

Interior Features

  • Interior Amenities: Barn Door(s), Kitchen Island, Walk-In Closet(s), Tray Ceiling(s), Storage, Pantry, Open Floorplan, Granite Counters, Entrance Foyer, Eat-in Kitchen, Double Vanity, Crown Molding, Chandelier, Ceiling Fan(s), Multi Panel Doors, Recessed Lighting, Vaulted Ceiling(s)
  • Basement: Other
  • Heating: Natural Gas, Forced Air
  • Levels: Two
  • Property Type: Residential
  • Appliances: Stainless Steel Appliance(s), Gas Range, Dishwasher, Microwave, Refrigerator
  • Full Bathrooms: 2
  • Half Bathrooms: 2
  • Total Bedrooms: 5
  • Door Features: French Doors
  • Fireplace Features: Stone, Gas
  • Fireplaces: 1
  • Fireplace: Yes
  • Living Area: 4445.0
  • Window Features: Insulated Windows, Vinyl Frames
  • Appliances Dishwasher: Yes
  • Appliances:Stainless Steel Appliance(s): Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features:Double Vanity2: Yes
  • Interior Features:Entrance Foyer2: Yes
  • Interior Features:Granite Counters: Yes
  • Interior Features:Kitchen Island2: Yes
  • Interior Features:Multi Panel Doors: Yes
  • Interior Features:Open Floorplan: Yes
  • Interior Features:Pantry2: Yes
  • Interior Features:Storage2: Yes
  • Interior Features:Walk-In Closet(s)2: Yes
  • Kitchen Features:Granite Countertops: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Primary Bedroom Features:Ceiling Fan(s)8: Yes
  • Appliances:Gas Range: Yes
  • Kitchen Features Pantry: Yes
  • Kitchen Features:Wood Cabinets: Yes
  • Primary Bedroom Features:Bath Adjoins: Yes
  • Primary Bedroom Features:Carpet Flooring5: Yes
  • Primary Bedroom Features:Walk-In Closet(s): Yes
  • Family Room Features:Carpet Flooring4: Yes
  • Interior Features:Eat-in Kitchen2: Yes
  • Interior Features:Crown Molding: Yes
  • Dining Room Features:Wood Flooring3: Yes
  • Kitchen Features:Wood Flooring4: Yes
  • Kitchen Features:Eat-in Kitchen: Yes
  • Fireplace Features:Gas: Yes
  • Living Room Features:Carpet Flooring2: Yes
  • Living Room Features:Fireplace(s): Yes
  • Interior Features:Chandelier2: Yes
  • Interior Features:Vaulted Ceiling(s): Yes
  • Living Room Features:Ceiling Fan(s)6: Yes
  • Dining Room Features:Chandelier: Yes
  • Dining Room Features:Walk-Out Access2: Yes
  • Kitchen Features:Breakfast Bar: Yes
  • Primary Bedroom Features:High Ceiling(s)6: Yes
  • Interior Features:Recessed Lighting: Yes
  • Kitchen Features:Recessed Lighting3: Yes
  • Fireplace Features:Stone4: Yes
  • Primary Bedroom Features:Recessed Lighting7: Yes
  • Primary Bedroom Features:Sitting Room: Yes
  • Living Room Features:Recessed Lighting4: Yes
  • Interior Features:Tray Ceiling(s): Yes
  • Primary Bedroom Features:Tray Ceiling(s)2: Yes
  • Kitchen Features:Crown Molding2: Yes
  • Interior Features:Barn Door(s): Yes
  • Basement:Other16: Yes

Exterior Features

  • Fencing: Fenced, Metal
  • Roof: Asphalt
  • Lot Features: Cleared
  • Construction Type: Brick, Stone, Vinyl Siding
  • Exterior Features: Fire Pit
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Deck, Patio, Porch
  • Construction Materials:Brick2: Yes
  • Construction Materials:Vinyl Siding: Yes
  • Window Features:Insulated Window(s): Yes
  • Window Features:Vinyl Frames: Yes
  • Patio and Porch Features:Deck: Yes
  • Patio and Porch Features:Patio: Yes
  • Patio and Porch Features:Porch: Yes
  • Construction Materials:Stone2: Yes
  • Exterior Features:Fire Pit: Yes
  • Lot Features:Cleared: Yes
  • Study Room Features:French Doors7: Yes
  • Door Features:French Doors: Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway, Garage Faces Front
  • General Property Description:Garage Spaces: 2.0
  • Parking Features:Driveway: Yes
  • Parking Features:Garage Faces Front: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Upper Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Heating:Natural Gas2: Yes
  • Heating:Forced Air: Yes

Condo/Co-op/Association

  • Amenities: Landscaping, Playground, Pool, Clubhouse, Trail(s)
  • Association Fee: 550.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: 513-489-4059
  • Association Information:Total Yearly Fees: 550.0
  • Association Fee Includes:Association Fees: Yes
  • Association Information:Association Fee: 550.0
  • Association Information:Association Fee Frequency: Annually
  • Association Amenities:Clubhouse: Yes
  • Association Amenities:Playground: Yes
  • Association Amenities:Pool5: Yes
  • Association Amenities:Trail(s): Yes
  • Association Amenities:Landscaping: Yes

Fee Information

  • Association Fee Includes: Association Fees

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: 11761.2
  • 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
Jun 26, 2023
Closed on
Jul 21, 2023
Sold by
Irfan Aftab and Irfan Yasmeen
Bought by
Seller's Agent
The Treas Team
Huff Realty - Florence
Buyer's Agent
Caitlyn Campbell
ERA Real Solutions LLC
List Price
$534,900
Sold Price
$532,000
Premium/Discount to List
-$2,900
-0.54%
Views
142
Current Estimated Value
$577,590

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$45,590
Avg. Annual Appreciation
2.61%
Original Mortgage
$478,800
Outstanding Balance
$461,713
Interest Rate
6.69%
Mortgage Type
New Conventional
Estimated Equity
$115,877

Purchase Details

Listed on
Jul 25, 2020
Closed on
Aug 31, 2020
Sold by
Chomyszak Bryan and Chomyszak Martha
Bought by
Irfan Aftab and Irfan Yasmeen
Seller's Agent
Sara Mirus
Keller Williams Realty Service
Buyer's Agent
Amy Walter
Berkshire Hathaway HomeService
List Price
$399,900
Sold Price
$398,900
Premium/Discount to List
-$1,000
-0.25%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
10.48%
Original Mortgage
$200,000
Interest Rate
3%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jan 5, 2015
Sold by
Arlinghaus Builders Llc
Bought by
Chomyszak Bryan and Chomyszak Martha

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$311,930
Interest Rate
3.89%
Mortgage Type
New Conventional

Purchase Details

Closed on
Nov 14, 2014
Sold by
Longbranch Development Inc
Bought by
Arlinghaus Builders Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$311,930
Interest Rate
3.89%
Mortgage Type
New Conventional
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

  • Tasha Klaber-Flood Real Estate Agent - Sibcy Cline, REALTORS-Florence

    Tasha Klaber-Flood

    Sibcy Cline, REALTORS-Florence

    (513) 599-0879

    96 Total Sales

    34 in Union

    $168K - $3.9M Price Range

    Tasha Klaber-Flood
     Section Image
  • Nicholas Groh Real Estate Agent - Horan Rosenhagen Real Estate

    Nicholas Groh

    Horan Rosenhagen Real Estate

    (513) 657-4561

    94 Total Sales

    1 in Union

    $287,579 Price

    Nicholas Groh
     Section Image
  • Katrina Robke Holtmeier Real Estate Agent - Keller Williams Realty Service

    Katrina Robke Holtmeier

    Keller Williams Realty Service

    (513) 866-7832

    144 Total Sales

    6 in Union

    $66K - $716K Price Range

    Katrina Robke Holtmeier
     Section Image
  • JoLynn Johnston Real Estate Agent - e-Merge Real Estate Victory

    JoLynn Johnston

    e-Merge Real Estate Victory

    (513) 813-4925

    68 Total Sales

    2 in Union

    $525K - $870K Price Range

    JoLynn Johnston
     Section Image
  • Shelli Stinson Real Estate Agent - eXp Realty LLC

    Shelli Stinson

    eXp Realty LLC

    (859) 757-0169

    136 Total Sales

    9 in Union

    $180K - $550K Price Range

    Shelli Stinson
     Section Image
  • Doug Mayberry Real Estate Agent - Huff Realty - Florence

    Doug Mayberry

    Huff Realty - Florence

    (859) 600-6390

    179 Total Sales

    19 in Union

    $64K - $625K Price Range

    Doug Mayberry
     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
$532,000 Acuity Title
Irfan Aftab $398,900 360 American Title Svcs Llc
Chomyszak Bryan $328,348 360 American Title Services
Arlinghaus Builders Llc $45,400 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 $478,800
Previous Owner Irfan Aftab $200,000
Previous Owner Chomyszak Bryan $35,250
Previous Owner Chomyszak Bryan $311,930
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
07/21/2023 07/21/23 Sold $532,000 0.0% $120 / Sq Ft
07/13/2023 07/13/23 Pending -- -- --
07/10/2023 07/10/23 Off Market $532,000 -- --
06/26/2023 06/26/23 For Sale $534,900 +34.1% $120 / Sq Ft
08/31/2020 08/31/20 Sold $398,900 -0.3% $113 / Sq Ft View Prior Sale
07/26/2020 07/26/20 Pending -- -- --
07/25/2020 07/25/20 For Sale $399,900 -- $113 / 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 $6,020 $532,000 $65,000 $467,000
2024 $5,919 $532,000 $65,000 $467,000
2023 $4,539 $398,900 $46,000 $352,900
2022 $4,478 $398,900 $46,000 $352,900
2021 $4,563 $398,900 $46,000 $352,900
2020 $3,760 $328,430 $45,400 $283,030
2019 $3,804 $328,430 $45,400 $283,030
2018 $3,822 $328,430 $45,400 $283,030
2017 $3,747 $328,430 $45,400 $283,030
2015 $512 $45,400 $45,400 $0
Source: Public Records

Agents Affiliated with this Home

  • TT

    Seller's Agent in 2023

    The Treas Team

    Huff Realty - Florence

    (859) 525-5788

    562 Total Sales

    The Treas Team
    Section Image

  • CC

    Buyer's Agent in 2023

    Caitlyn Campbell

    ERA Real Solutions LLC

    Section Image

  • SM

    Seller's Agent in 2020

    Sara Mirus

    Keller Williams Realty Service

  • Amy Walter Real Estate Agent - Berkshire Hathaway HomeService

    Buyer's Agent in 2020

    Amy Walter

    Berkshire Hathaway HomeService

    (859) 630-9384

    16 Total Sales

    Amy Walter
    Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 614728

Northern Kentucky Multiple Listing Service

APN: 051.00-15-074.00

Kentucky Boone County Union 41091

5017 Loch Dr, 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.