NOT LISTED FOR SALE

5017 Loch Dr Union, KY 41091

Estimated Value: $577,000 - $620,000

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

Last Sold July 21, 2023

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

Est. 12% increase in value since last sale

Current estimated payment $3,640/month

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

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2015

Lot Details

  • 0.27 Acre 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
  • 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

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
Spaulding-Cain Taylor and Cain Austin Stanton
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
$594,310

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$62,310
Avg. Annual Appreciation
4.27%
Original Mortgage
$478,800
Outstanding Balance
$466,198
Interest Rate
6.69%
Mortgage Type
New Conventional
Estimated Equity
$128,112

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
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
Spaulding-Cain Taylor $532,000 Acuity Title
Spaulding-Cain Taylor $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

Date Status Borrower Loan Amount
Open Spaulding-Cain Taylor $478,800
Closed Spaulding-Cain Taylor $478,800
Previous Owner Irfan Aftab $200,000
Previous Owner Chomyszak Bryan $311,930
Source: Public Records

Property History

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

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

  • Section Image
  • Section Image
  • 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

Your Personal Tour Guide

Ask me questions while you tour the home.