$375,000
PENDING

5100 Limerick Ct Union, KY 41091

Estimated payment $2,537/month

Total Views 1,085
3 Beds
2.5 Baths
2,162 Sq Ft
$173 Price per Sq Ft

Highlights

  • Open Floorplan
  • Clubhouse
  • Recreation Room
  • Shirley Mann Elementary School Rated A
  • Deck
  • Ranch Style House

About This Home

Welcome to the only freestanding Wembley in Ballyshannon! This gorgeous one-level home with a fully finished lower level offers 3 bedrooms and 2.5 baths. Every detail has been upgraded, making it truly one-of-a-kind, with 2,162 square feet of finished living space. The first floor features beautiful new LVT flooring, fresh lighting, painted cabinets, granite countertops, and soaring 10' ceilings. The spacious owner's suite is the perfect place to unwind at the end of the day. Outdoor living shines with a freshly stained deck and a lower-level patio with pavers, creating a stylish and functional space. Enjoy the ease of maintenance-free living—no mowing, mulching, or snow shoveling required. If you've been searching for a freestanding home that doesn't share walls with neighbors and is move-in ready from top to bottom, this is the one you've been waiting for!

Listing Agent

Cindy Shetterly

Keller Williams Realty Services License #220012 Listed on: 10/14/2025

Keller Williams Realty Services

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,887

Year Built

  • Built in 2022

Lot Details

  • 5,401 Sq Ft Lot
  • Year Round Access
  • Landscaped

HOA Fees

  • $225 Monthly HOA Fees

Parking

  • 2 Car Garage
  • Driveway

Home Design

  • Ranch Style House
  • Patio Home
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof
  • Vinyl Siding

Interior Spaces

  • 2,162 Sq Ft Home
  • Open Floorplan
  • High Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Chandelier
  • Fireplace
  • Vinyl Clad Windows
  • Insulated Windows
  • Window Treatments
  • Sliding Doors
  • Panel Doors
  • Entrance Foyer
  • Family Room
  • Living Room
  • Dining Room
  • Home Office
  • Recreation Room
  • Storage
  • Neighborhood Views
  • Fire and Smoke Detector

Kitchen

  • Eat-In Kitchen
  • Electric Oven
  • Electric Cooktop
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Granite Countertops

Flooring

  • Carpet
  • Luxury Vinyl Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • En-Suite Bathroom
  • Walk-In Closet
  • Double Vanity
  • Bathtub with Shower

Laundry

  • Laundry Room
  • Laundry on main level

Finished Basement

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

Outdoor Features

  • Deck
  • Covered Patio or Porch

Schools

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

Utilities

  • Central Air
  • Heating Available
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 051.05-15-689.01

Community Details

Overview

  • Association fees include association fees, ground maintenance, management, snow removal
  • Murry Feldstein Association, Phone Number (513) 489-4059
  • On-Site Maintenance

Recreation

  • Community Playground
  • Community Pool
  • Trails
  • Snow Removal

Additional Features

  • Clubhouse
  • Resident Manager or Management On Site

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,887

Year Built

Built in 2022

Lot Details

0

HOA Fees

$225 per month

Parking

2

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Patio Home
  • Lot Size Acres: 0.12
  • Year Built: 2022
  • Lot Size: Of Record
  • Road Frontage Type: City Street
  • Road Surface Type: Paved
  • Ownership: Consumer
  • Directions: Right onto Vintage Fleet Ln. Left onto Donegal Ave. Right onto Limerick Ct. Property is on the right hand side.
  • Architectural Style: Ranch
  • Garage Yn: Yes
  • New Construction: No
  • Property Attached Yn: No
  • Structure Type: House
  • 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
  • Location Tax Legal Info:Subdivision2: Ballyshannon
  • Contract Info:Auction YN: No
  • General Property Description:Half Baths: 1
  • General Property Description:Basement YN2: Yes
  • General Property Description:Fireplace YN: No
  • General Property Description:Lot Size Dimensions: Of Record
  • Architecture:Ranch: Yes
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Parking Features Parking Total: 2
  • Roof:Shingle: Yes
  • Sewer:Public Sewer: Yes
  • Levels:One: Yes
  • Utilities:Cable Available: 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.124
  • General Property Description:Living Area: 2162.0
  • General Property Description:Lot Size Square Feet: 5401.0
  • Structure Type:House: Yes
  • Laundry Features:Laundry Room2: Yes
  • Laundry Features:Main Level: Yes
  • Security Features:Smoke Detector(s): Yes
  • Location Tax Legal Info:Tax ID: 051.05-15-689.01
  • Appliances Refrigerators: Yes
  • Percent Basement Finished: Yes
  • Special Features: None

Interior Features

  • Interior Amenities: Kitchen Island, Walk-In Closet(s), Storage, Stone Counters, Pantry, Open Floorplan, High Speed Internet, Granite Counters, Entrance Foyer, Eat-in Kitchen, Double Vanity, Chandelier, Ceiling Fan(s), High Ceilings, Multi Panel Doors, Recessed Lighting
  • Basement: Full, Finished, Storage Space, Walk-Out Access
  • Heating: Electric
  • Levels: One
  • Property Type: Residential
  • Appliances: Stainless Steel Appliance(s), Electric Cooktop, Electric Oven, Dishwasher, Microwave, Refrigerator
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Door Features: Sliding Doors
  • Fireplace: No
  • Living Area: 2162.0
  • Window Features: Insulated Windows, Vinyl Frames
  • Full Basement: Yes
  • Appliances Dishwasher: Yes
  • Appliances:Electric Oven: 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:High Ceilings: 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
  • Basement:Walk-Out Access7: Yes
  • Interior Features:Eat-in Kitchen2: Yes
  • Basement:Storage Space: Yes
  • Basement:Carpet Flooring7: Yes
  • Interior Features:High Speed Internet: Yes
  • Interior Features:Chandelier2: Yes
  • Appliances:Electric Cooktop: Yes
  • Interior Features:Stone Counters: Yes
  • Interior Features:Recessed Lighting: Yes

Exterior Features

  • View: Neighborhood
  • Roof: Shingle
  • View: Yes
  • Construction Type: Brick, Vinyl Siding
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Covered, 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:Covered: Yes
  • Patio and Porch Features:Deck: Yes
  • Patio and Porch Features:Patio: Yes
  • Patio and Porch Features:Porch: Yes
  • Door Features:Sliding Doors: Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway, Garage
  • Total Parking Spaces: 2.0
  • General Property Description:Garage Spaces: 2.0
  • Parking Features:Driveway: Yes
  • Parking Features:Garage5: Yes

Utilities

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

Condo/Co-op/Association

  • Amenities: Landscaping, Lake Year Round, Playground, Pool, Clubhouse, Trail(s)
  • Association Fee: 225.0
  • Association Fee Frequency: Monthly
  • Association: Yes

Association/Amenities

  • Association Information:Association YN: Yes
  • Association Information:Association Management Name 1: Murry Feldstein
  • Association Information:Association Management Phone 1: 5134894059
  • Association Information:Total Yearly Fees: 2700.0
  • Association Fee Includes:Association Fees: Yes
  • Association Fee Includes:Maintenance Grounds: Yes
  • Association Fee Includes:Snow Removal: Yes
  • Association Information:Association Fee: 225.0
  • Association Information:Association Fee Frequency: Monthly
  • Association Amenities:Management: Yes
  • Association Amenities:Clubhouse: Yes
  • Association Amenities:Playground: Yes
  • Association Amenities:Pool5: Yes
  • Association Amenities:Trail(s): Yes
  • Association Amenities:Landscaping: Yes
  • Association Amenities:Lake Year Round: Yes

Fee Information

  • Association Fee Includes: Association Fees, Maintenance Grounds, Management, Snow Removal

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: 5401.0
  • Zoning Description: Residential

Map

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

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,887 $347,000 $43,100 $303,900
2023 $75 $43,100 $43,100 $0
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
10/15/2025 10/15/25 Pending -- -- --
10/14/2025 10/14/25 For Sale $375,000 +8.1% $173 / Sq Ft
01/26/2023 01/26/23 Sold $346,990 -1.9% $160 / Sq Ft View Prior Sale
11/01/2022 11/01/22 Pending -- -- --
07/20/2022 07/20/22 For Sale $353,709 -- $164 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

Purchase History

Date Type Sale Price Title Company
Deed $346,990 --
Deed $346,990 None Listed On Document
Warranty Deed $388,000 None Listed On Document
Source: Public Records

About the Listing Agent

Cindy Shetterly

Keller Williams Realty Services

(859) 681-8694

Section Image

#1 Team in our market, The Cindy Shetterly Team is a team of full-time Realtors who specialize in buying, selling, and investing in real estate. We are a team of 13 that takes you from the beginning to the end of your buying or selling process with experts on every step. Our agents study the market every day and are well-versed in new- construction, land, investment properties, and re-sale real estate transactions. With over 75 years of experience, we have worked in virtually every situation

Cindy's Other Listings

  • 5805 Stillwater Ln, Burlington, KY 41005

    $534,800 Open Sun 12PM - 1PM

    • 4 Beds
    • 2.5 Baths
    • 2,640 Sq Ft
    • 5805 Stillwater Ln
    • Burlington, KY

    You've found the home that has it all! This spacious Alden floor plan by Drees is located in the sought-after Stillwater community. Designed for gathering, it offers an open kitchen and family room that flow seamlessly to a covered patio. The home features 4 bedrooms, first-floor study, 2.5 baths, and a dramatic two-story family room with soaring ceilings. A versatile game room sits just steps

    Cindy Shetterly Keller Williams Realty Services

    Section Image
  • 7163 Cascade Dr, Florence, KY 41042

    $233,500 Open Sat 3:30PM - 5:30PM

    • 3 Beds
    • 2.5 Baths
    • 1,828 Sq Ft
    • 7163 Cascade Dr
    • Florence, KY

    Welcome to this spacious 3-bedroom, 2.5-bath townhome in the highly sought-after Oakbrook community! This well-maintained condo offers an abundance of living space, featuring newer flooring throughout and a versatile lower-level bonus room—perfect as a third bedroom, home office, or cozy family room. Enjoy the light-filled main living area with direct access to a quiet patio with serene views.

    Cindy Shetterly Keller Williams Realty Services

    Section Image
  • 113 Vernon Dr, Crestview Hills, KY 41017

    $535,000 Open Sat 2PM - 3PM

    • 4 Beds
    • 4 Baths
    • 113 Vernon Dr
    • Crestview Hills, KY

    Sprawling Ranch in Prime Crestview Hills Location!This extra-large 4 bed, 4 bath ranch offers nearly half an acre of level, usable yard—perfect for entertaining, gardening, or relaxing in a park-like setting. Located directly across from the vibrant Crestview Hills Towne Center, you'll enjoy immediate access to top-tier shopping, dining, and amenities, all while tucked into a peaceful

    Cindy Shetterly Keller Williams Realty Services

    Section Image
  • 3270 Ballantree Way, Verona, KY 41092

    $1,029,000

    • 4 Beds
    • 4.5 Baths
    • 4,281 Sq Ft
    • 3270 Ballantree Way
    • Verona, KY

    Luxury Custom Ranch w/ Guest Suite & Incredible LayoutDiscerning buyers will appreciate this stunning, custom, ranch featuring the utmost & unique features in a home, along w/ a perfect generational private-entry apartment with it's own kitchen, living room, laundry, & bath. The main floor showcases 8' solid-core 5-panel stained doors, upgraded farmhouse trim, a raised dining area

    Cindy Shetterly Keller Williams Realty Services

    Section Image
  • 3146 Meadoway Ct, Independence, KY 41051

    $289,000 Pending

    • 3 Beds
    • 2.5 Baths
    • 1,700 Sq Ft
    • 3146 Meadoway Ct
    • Independence, KY

    Welcome to this well-maintained 3-bedroom, 2.5-bath home tucked away on a quiet cul-de-sac, just one home away from the neighborhood park. The first floor features a bright living room with soaring cathedral ceilings, a convenient half bath, and a beautifully tiled kitchen with stainless steel appliances and a large pantry. Upstairs, you'll find three spacious bedrooms, including a primary suite

    Cindy Shetterly Keller Williams Realty Services

    Section Image
  • 3018 Observatory Hill Ct, Villa Hills, KY 41017

    $350,000

    • 2 Beds
    • 4 Baths
    • 1,288 Sq Ft
    • 3018 Observatory Hill Ct
    • Villa Hills, KY

    Breathtaking panoramic views of the Ohio River and Cincinnati skyline set the stage for this beautifully updated 2-bedroom landominium in a private section of a vibrant community. Enjoy the outdoors with lush green space, walking trails, and recreational amenities, including a pool, clubhouse, tennis, and basketball courts. Inside, the home features a brand new composite deck (2024), fully

    Cindy Shetterly Keller Williams Realty Services

    Section Image
  • 2195 Tantallon Dr, Fort Mitchell, KY 41017

    $338,800

    • 3 Beds
    • 4 Baths
    • 1,818 Sq Ft
    • 2195 Tantallon Dr
    • Fort Mitchell, KY

    Step into this stunning 3bd, 4ba townhome in coveted Fort Mitchell, just minutes from the airport and downtown. Beautifully updated from top to bottom, this home features new flooring, lighting, countertops, and newer carpet throughout. Retreat to the spacious owner's suite with a spa like bath showcasing a separate soaking tub, gorgeous walk-in corner shower with bench, double vanities, new

    Cindy Shetterly Keller Williams Realty Services

    Section Image
  • 1048 Licking Pike, Newport, KY 41076

    $650,000

    • Land
    • 11.39 Acres
    • $57,068 per Acre
    • 1048 Licking Pike
    • Newport, KY

    Incredible commercial opportunity to be in a high traffic area with multiple zoning.

    Cindy Shetterly Keller Williams Realty Services

    Section Image
  • 1516 Bloomin Spring Ct, Hebron, KY 41048

    $599,900 Pending

    • 4 Beds
    • 4.5 Baths
    • 1516 Bloomin Spring Ct
    • Hebron, KY

    Welcome to this stunning, extra-large 4-bedroom, 4.5-bath home in the desirable Thornewilde community — perfectly designed for entertaining and multi-generational living!The spacious first floor offers an open-concept layout filled with natural light, a cozy gas fireplace, and elegant touches throughout. A private office, formal dining room, and expansive great room flow seamlessly into

    Cindy Shetterly Keller Williams Realty Services

    Section Image

Source: Northern Kentucky Multiple Listing Service

MLS Number: 637130

Northern Kentucky Multiple Listing Service

APN: 051.05-15-689.01