$277,273
SOLD SEP 22, 2023 RENTED NOV 15, 2024

5137 Limerick Ct Union, KY 41091

3 Beds
2.5 Baths
1,651 Sq Ft
$46/mo HOA Fee

Recently Sold

$168 Per Sq Ft

7% Below List Price

102 Days on Market

Highlights

  • New Construction
  • Traditional Architecture
  • High Ceiling
  • Longbranch Elementary School Rated A
  • Loft
  • Granite Countertops

About This Home

As of September 2024

New Construction by Fischer Homes in the beautiful Ballyshannon community with the Hudson plan, featuring a stunning kitchen with pantry, lots of cabinet space and granite countertops. Spacious family room expands to walkout dining space. Primary Suite with private bath and walk-in closet. Additional bedrooms, loft, and hall bath. Two car garage.

Last Agent to Sell the Property

Alexander Hencheck

HMS Real Estate License #193556 Listed on: 04/12/2023

Last Buyer's Agent

Michelle Lorms

Keller Williams Realty Services License #266998

Keller Williams Realty Services

Property Details

Home Type

  • Condominium

Est. Annual Taxes

  • $3,121

Year Built

  • Built in 2023 | New Construction

HOA Fees

  • $46 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Driveway

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Slab Foundation
  • Shingle Roof
  • Vinyl Siding

Interior Spaces

  • 1,651 Sq Ft Home
  • 2-Story Property
  • High Ceiling
  • Vinyl Clad Windows
  • Insulated Windows
  • Panel Doors
  • Family Room
  • Breakfast Room
  • Loft
  • Garage Access

Kitchen

  • Electric Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Solid Wood Cabinet
  • Disposal

Flooring

  • Carpet
  • Luxury Vinyl Tile

Bedrooms and Bathrooms

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

Laundry

  • Laundry Room
  • Laundry on upper level

Home Security

Schools

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

Utilities

  • Central Air
  • Heat Pump System
  • No Utilities

Additional Features

  • Patio
  • 051051569602

Listing and Financial Details

  • Home warranty included in the sale of the property

Community Details

Overview

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

Pet Policy

  • Pets Allowed

Security

  • Fire and Smoke Detector

Property Details

Home Type

Condominium

Est. Annual Taxes

$3,121

Year Built

Built in 2023 | New Construction

Lot Details

0

HOA Fees

$46 per month

Parking

2

Listing Details

  • Cooling: Central Air
  • Property Condition: New Construction
  • Property Sub Type: Condominium
  • Lot Size Acres: 0.06
  • Year Built: 2023
  • Lot Size: 30x88
  • Directions: I-75 to Union/Florence Exit 42, West on US 42 Right Old Union Right Orleans Blvd, Left Long Branch Left Ballyshannon Dr.
  • Architectural Style: Traditional
  • Garage Yn: Yes
  • New Construction: Yes
  • Property Attached Yn: Yes
  • Structure Type: Duplex
  • ResoPropertyType: Residential
  • Location Tax Legal Info:Property Attached YN: Yes
  • Location Tax Legal Info:New Construction: Yes
  • 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
  • Location Tax Legal Info:Subdivision2: Ballyshannon
  • Contract Info:Auction YN: No
  • General Property Description:Half Baths: 1
  • General Property Description:Basement YN2: No
  • General Property Description:Fireplace YN: No
  • General Property Description:Lot Size Dimensions: 30x88
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Roof:Shingle: Yes
  • Property Condition:New Construction4: Yes
  • Room Type:Family Room4: Yes
  • Sewer:Public Sewer: Yes
  • Water Source:Public: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: No
  • General Property Description:Lot Size Acres: 0.0606
  • General Property Description:Living Area: 1651.0
  • Laundry Features:Laundry Room2: Yes
  • Miscellaneous Home Warranty: Yes
  • Room Type:Breakfast Room2: Yes
  • Room Type:Breakfast Room Level: First
  • Security Features:Smoke Detector(s): Yes
  • Utilities:None14: Yes
  • Architecture:Traditional: Yes
  • Laundry Features:Upper Level: Yes
  • Room Type:Loft3: Yes
  • Levels:Two: Yes
  • Loft Features:Carpet Flooring9: Yes
  • Foundation:Slab: Yes
  • Condo Information:Entry Level: 1
  • Pets Allowed:Pets Allowed: Yes
  • Condo Information:Elevator(s)2: No
  • Structure Type:Duplex: Yes
  • Special Features: NewHome

Interior Features

  • Interior Amenities: Kitchen Island, Walk-In Closet(s), Pantry, Granite Counters, Double Vanity, High Ceilings, Multi Panel Doors
  • Heating: Heat Pump, Electric
  • Levels: Two
  • Entry Level: 1
  • Property Type: Residential
  • Appliances: Electric Range, Dishwasher, Disposal, Microwave
  • Accessibility Features: None
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Fireplace: No
  • Living Area: 1651.0
  • Window Features: Insulated Window(s), Vinyl Frames
  • Appliances Dishwasher: Yes
  • Interior Features:Double Vanity2: Yes
  • Interior Features:Granite Counters: Yes
  • Interior Features:High Ceilings: Yes
  • Interior Features:Kitchen Island2: Yes
  • Interior Features:Multi Panel Doors: Yes
  • Interior Features:Pantry2: Yes
  • Interior Features:Walk-In Closet(s)2: Yes
  • Kitchen Features:Granite Countertops: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Kitchen Features:Luxury Vinyl Flooring11: 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
  • Appliances:Electric Range: Yes
  • Family Room Features:Carpet Flooring4: Yes

Exterior Features

  • Roof: Shingle
  • Home Warranty: Yes
  • Construction Type: Brick, Vinyl Siding
  • Foundation Details: Slab
  • Patio And Porch Features: Patio
  • Construction Materials:Brick2: Yes
  • Construction Materials:Vinyl Siding: Yes
  • Window Features:Insulated Window(s): Yes
  • Window Features:Vinyl Frames: Yes
  • Patio and Porch Features:Patio: Yes
  • Accessibility Features:None15: Yes

Garage/Parking

  • Attached Garage: Yes
  • Parking Features: Attached, Driveway, Garage
  • General Property Description:Garage Spaces: 2.0
  • Parking Features:Attached: Yes
  • Parking Features:Driveway: Yes
  • Parking Features:Garage5: Yes
  • Condo Information:Direct Entry Garage-Unit: Yes
  • Condo Information:Direct Entry Garage-Building: No

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Laundry Room, Upper Level
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: None
  • Heating:Electric2: Yes
  • Heating:Heat Pump2: Yes

Condo/Co-op/Association

  • 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 Information:Association Fee: 550.0
  • Association Information:Association Fee Frequency: Annually

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: 2639.74
  • Additional Parcels Description: 051051569602
  • Zoning Description: Residential
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 2, 2024
Closed on
Sep 30, 2024
Sold by
Smith Stefanie
Bought by
Jones Prop Llc
Seller's Agent
John Lorms Home Team
Keller Williams Realty Services
Buyer's Agent
John Lorms Home Team
Keller Williams Realty Services
List Price
$298,500
Sold Price
$292,000
Premium/Discount to List
-$6,500
-2.18%
Views
32
Current Estimated Value
$314,733

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$22,733
Avg. Annual Appreciation
7.27%

Purchase Details

Listed on
Apr 12, 2023
Closed on
Sep 7, 2023
Sold by
Fischer Single Family Homes Iv Llc
Bought by
Smith Stefanie
Seller's Agent
Alexander Hencheck
HMS Real Estate
Buyer's Agent
Michelle Lorms
Keller Williams Realty Services
List Price
$297,273
Sold Price
$277,273
Premium/Discount to List
-$20,000
-6.73%
Views
362

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.20%
Source: Public Records

Similar Homes in the area

  • 9075 Royal Oak Ln, Union, KY 41091

    $335,000

    • 2 Beds
    • 2 Baths
    • 9075 Royal Oak Ln
    • Union, KY

    ***OPEN HOUSE THURSDAY 3PM-5PM 7/24/2025***Are you ready for a carefree, low maintenance lifestyle? This step free condo is located within walking distance of restaurants, shopping and the library*Neutral decor is ready for your personal touches*Spacious bedrooms and a bonus room with French doors for added privacy*The living room opens to kitchen and eating area for easy entertaining*The peace

    Jean Paul RE/MAX Victory + Affiliates

    Section Image
  • 8492 Concerto Ct, Union, KY 41091

    $275,900

    • 2 Beds
    • 2 Baths
    • 1,436 Sq Ft
    • 8492 Concerto Ct
    • Union, KY

    Why build when you can buy practically brand new. Enjoy one level listing in the very desirable Harmony Bluffs community. This condo offers 2 bedrooms, 2 baths and a 2 car garage. No steps from the garage entrance. The Breck floor plan has an open concept design with 9 ft ceilings, quartz countertops, large kitchen island stainless steel appliances, and luxury vinyl flooring. Primary bedroom

    Cara Klare Coldwell Banker Realty FM

    Section Image
  • 8480 Concerto Ct, Union, KY 41091

    $305,000

    • 3 Beds
    • 2 Baths
    • 1,787 Sq Ft
    • 8480 Concerto Ct
    • Union, KY

    Ask how you can lock your interest rate on this home today! Discover the new Drees Caywood floor plan in the Harmony Bluffs community. This second-floor condominium features three spacious bedrooms and two modern baths, along with an attached two-car garage with a private entrance, and covered deck. The open-concept design creates an inviting atmosphere, highlighted by 9-foot ceilings. The

    John Heisler Drees/Zaring Realty

    Section Image
  • 8524 Concerto Ct, Union, KY 41091

    $315,000

    • 2 Beds
    • 2 Baths
    • 1,386 Sq Ft
    • 8524 Concerto Ct
    • Union, KY

    Ask how you can lock your interest rate on this home today! Experience the convenience of first-floor living in a brand new Drees Atwood condominium, set in the beautiful Harmony Bluffs community. This inviting home features wide doorways, ensuring effortless accessibility. With two spacious bedrooms, two stylish baths, and a two-car garage, every corner is designed for comfort. The

    John Heisler Drees/Zaring Realty

    Section Image
  • 8528 Concerto Ct, Union, KY 41091

    $305,000

    • 2 Beds
    • 2 Baths
    • 1,436 Sq Ft
    • 8528 Concerto Ct
    • Union, KY

    Ask how you can lock your interest rate on this home today! Enjoy the convenience of first-floor, one-level living in this brand-new Drees Breck condominium, located in the desirable Harmony Bluffs community. Designed for maximum accessibility, this home features wide doorways and no steps from the garage, ensuring easy entry. The layout includes 2 bedrooms, 2 bathrooms, and a 2-car garage. The

    John Heisler Drees/Zaring Realty

    Section Image
  • 8536 Concerto Ct, Union, KY 41091

    $315,000

    • 2 Beds
    • 2 Baths
    • 1,386 Sq Ft
    • 8536 Concerto Ct
    • Union, KY

    Ask how you can lock your interest rate on this home today! Experience the convenience of first-floor living in a brand new Drees Homes Atwood condominium, set in the beautiful Harmony Bluffs community. This inviting home features wide doorways, ensuring effortless accessibility. With two spacious bedrooms, two stylish baths, and a two-car garage, every corner is designed for comfort. The

    John Heisler Drees/Zaring Realty

    Section Image
  • 8540 Concerto Ct, Union, KY 41091

    $315,000

    • 3 Beds
    • 2 Baths
    • 1,787 Sq Ft
    • 8540 Concerto Ct
    • Union, KY

    Ask how you can lock your interest rate on this home today! Step into the Drees Homes Caywood—a stylish 3-bed, 2-bath condo in Harmony Bluffs. Enjoy open-concept living with 9' ceilings, quartz counters, a spacious island, walk-in pantry, and covered deck perfect for relaxing. The primary suite features double vanities and generous walk-in closets. Smart home features like a video doorbell and

    John Heisler Drees/Zaring Realty

    Section Image
  • 1305 Rubyhill Ln, Florence, KY 41042

    $312,000

    • 2 Beds
    • 2 Baths
    • 1,633 Sq Ft
    • 1305 Rubyhill Ln
    • Florence, KY

    UTTERLY PRISTINE and IMPECCABLY MAINTAINED, this Tuscon Model Condo in the esteemed Preston at Plantation Pointe Two is just the home you are looking for! With 2 beds, 2 full baths, PLUS an OFFICE, attached one car GARAGE with direct entry into the home, COVERED DECK, OPEN FLOORPLAN and SO MUCH MORE!!! Gorgeous GRANITE counters highlight an AMAZING KITCHEN complete with STAINLESS appliances

    Amy Walter Berkshire Hathaway Home Services Professional Realty

    Section Image
  • 1460 Taramore Dr, Florence, KY 41042

    $215,000

    • 2 Beds
    • 2 Baths
    • 1,130 Sq Ft
    • 1460 Taramore Dr
    • Florence, KY

    Located just a short walk from shops, restaurants, the library, and the grocery store, everything you need is right at your doorstep. Low maintenance living offering the perfect blend of style, comfort, and convenience for first-time buyers, those navigating a new chapter, or those ready to downsize without compromise. Inside, you'll love the warmth of luxury vinyl plank flooring, vaulted

    Janell Stuckwisch eXp Realty, LLC

    Section Image
See All Homes in Union

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 Type Sale Price Title Company
Warranty Deed $292,000 360 American Title Services
Deed $277,500 Homestead Title Agency
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/15/2024 11/15/24 Under Contract -- -- --
10/07/2024 10/07/24 For Rent $2,300 0.0% --
09/30/2024 09/30/24 Sold $292,000 -2.2% $173 / Sq Ft
08/07/2024 08/07/24 Pending -- -- --
08/02/2024 08/02/24 For Sale $298,500 +7.7% $177 / Sq Ft
09/22/2023 09/22/23 Sold $277,273 0.0% $168 / Sq Ft
07/24/2023 07/24/23 Pending -- -- --
07/13/2023 07/13/23 Price Changed $277,273 -6.7% $168 / Sq Ft
04/12/2023 04/12/23 For Sale $297,273 -- $180 / 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 $3,121 $277,300 $45,500 $231,800
2023 $490 $43,100 $43,100 $0
Source: Public Records

Agents Affiliated with this Home

  • J

    Seller's Agent in 2024

    John Lorms Home Team

    Keller Williams Realty Services

    (859) 486-0060

    53 in this area

    86 Total Sales

    John Lorms Home Team
    Section Image
  • Michelle Lorms

    Seller Co-Listing Agent in 2024

    Michelle Lorms

    Keller Williams Realty Services

    (859) 462-7760

    7 in this area

    11 Total Sales

    Michelle Lorms
    Section Image
  • Alexander Hencheck

    Seller's Agent in 2023

    Alexander Hencheck

    HMS Real Estate

    (513) 469-2400

    500 in this area

    11,314 Total Sales

    Alexander Hencheck
    Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 612642

Northern Kentucky Multiple Listing Service

APN: 051.05-15-696.02

Kentucky Boone County Union 41091

5137 Limerick Ct, Union, KY

This home is located at 5137 Limerick Ct, Union, KY 41091 and is currently priced at $277,273, approximately $167 per square foot. This property was built in 2023. 5137 Limerick Ct is a home located in Boone County with nearby schools including Longbranch Elementary School, Ballyshannon Middle School, and Randall K. Cooper High School.

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 2025 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.

Nearby Homes