New ranch-style townhome with a finished lower level and 2 car attached garage. The Drees Waverly offers 3 bedrooms and 3 baths. It has an open concept design with features like 9' smooth ceilings, quartz countertops, a large kitchen island, walk-in pantry, painted cabinets, luxury vinyl plank flooring, stainless steel appliances, double ovens, double vanity sinks in the primary bath and a super shower! It's also equipped with DreeSmart technology, which includes a video doorbell, programable thermostat, wireless router, home automation hub, and smart lock. All within Boone Country school district.
Sold for $484,900
$484,900
8450 Concerto Ct #248D, Union, KY 41091
3beds
2,629sqft
Townhouse, Residential, Multi Family
Built in 2023
-- sqft lot
$462,600 Zestimate®
$184/sqft
$3,024 Estimated rent
Home value
$462,600
$439,000 - $486,000
$3,024/mo
Zestimate® history
Owner options
List your home for rent
$3,024/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,024/mo
Rent Zestimate®
Refinance and save
$3,206/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$3,206/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked:
Listing updated:
Listed by:
John Heisler 859-468-9032,
Drees/Zaring Realty
Bought with:
Jewel Buckley, 203682
Coldwell Banker Realty FM
Scott Oyler, 208503
Coldwell Banker Realty
Source: NKMLS,MLS#: 618789
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 3
Primary bedroom
- Features: Carpet Flooring, Walk-In Closet(s), Bath Adjoins
- Level: First
- Area: 208
- Dimensions: 16 x 13
Bedroom 2
- Features: Carpet Flooring
- Level: First
- Area: 154
- Dimensions: 14 x 11
Bedroom 3
- Features: Carpet Flooring, Walk-In Closet(s)
- Level: Lower
- Area: 154
- Dimensions: 14 x 11
Other
- Features: Walk-Out Access, Carpet Flooring
- Level: Lower
- Area: 510
- Dimensions: 30 x 17
Dining room
- Features: Luxury Vinyl Flooring
- Level: First
- Area: 182
- Dimensions: 13 x 14
Family room
- Features: Walk-Out Access, Luxury Vinyl Flooring
- Level: First
- Area: 238
- Dimensions: 17 x 14
Other
- Features: Carpet Flooring
- Level: Lower
- Area: 187
- Dimensions: 17 x 11
Primary bath
- Features: Double Vanity, Shower
- Level: First
- Area: 54
- Dimensions: 9 x 6
Heating
- Has Heating (Unspecified Type)
Cooling
- Central Air
Appliances
- Included: Stainless Steel Appliance(s), Gas Cooktop, Dishwasher, Disposal, Double Oven, Microwave
- Laundry: Electric Dryer Hookup, Laundry Room, Main Level, Washer Hookup
Features
- Kitchen Island, Wet Bar, Walk-In Closet(s), Storage, Stone Counters, Pantry, Open Floorplan, Entrance Foyer, Double Vanity, Ceiling Fan(s), Wired for Data, Master Downstairs
- Windows: Vinyl Frames
- Basement: Full
Interior area
- Total structure area: 2,629
- Total interior livable area: 2,629 sqft
Property
Parking
- Total spaces: 2
- Parking features: Attached, Driveway, Garage, Garage Door Opener, Garage Faces Front
- Attached garage spaces: 2
- Has uncovered spaces: Yes
Accessibility
- Accessibility features: Accessible Doors, Accessible Full Bath, Accessible Kitchen
Features
- Levels: One
- Stories: 1
- Patio & porch: Covered, Deck, Patio
- Exterior features: Balcony, Lighting
- Has view: Yes
- View description: Lake, Neighborhood
- Has water view: Yes
- Water view: Lake
- Waterfront features: Waterfront
Lot
- Residential vegetation: Brush
Details
- Zoning description: Residential
Construction
Type & style
- Home type: Townhouse
- Architectural style: Ranch
- Property subtype: Townhouse, Residential, Multi Family
- Attached to another structure: Yes
Materials
- HardiPlank Type, Concrete, Stone, Vinyl Siding
- Foundation: Poured Concrete
- Roof: Shingle
Condition
- Under Construction
- New construction: Yes
- Year built: 2023
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Available, Natural Gas Available, Sewer Available, Water Available
Community & HOA
Community
- Security: Smoke Detector(s)
HOA
- Has HOA: Yes
- Amenities included: Parking, Lake Year Round, Playground, Pool, Clubhouse, Fitness Center, Trail(s)
- Services included: Association Fees, Maintenance Grounds, Management, Sewer, Snow Removal, Water
- HOA fee: $245 monthly
- Second HOA fee: $245 quarterly
Location
- Region: Union
Financial & listing details
- Price per square foot: $184/sqft
- Date on market: 3/28/2025
- Cumulative days on market: 207 days
- Road surface type: Paved
Price history
| Date | Event | Price |
|---|---|---|
| 8/15/2024 | Sold | $484,900-1%$184/sqft |
Source:  NKMLS #618789 Report a problem | ||
| 7/15/2024 | Pending sale | $489,900$186/sqft |
Source: NKMLS #618789 Report a problem | ||
| 7/9/2024 | Price change | $489,900-0.9%$186/sqft |
Source: NKMLS #618789 Report a problem | ||
| 6/7/2024 | Listed for sale | $494,227$188/sqft |
Source: NKMLS #618789 Report a problem | ||
| 5/16/2024 | Pending sale | $494,227$188/sqft |
Source: NKMLS #618789 Report a problem | ||
| 11/22/2023 | Listed for sale | $494,227$188/sqft |
Source: NKMLS #618789 Report a problem | ||
Public tax history
Tax history is unavailable.
Neighborhood: 41091
Nearby homes
- $434,4833 bd3 ba2.3k sqft8454 Concerto Ct #248C, Union, KY 41091Sold
- $477,5963 bd3 ba2.6k sqft8462 Concerto Ct #248A, Union, KY 41091Sold
- $467,0452 bd2 ba2.1k sqft8400 Concerto Ct, Union, KY 41091Sold
- $299,9002 bd2 ba1.3k sqft8497 Concerto Court Union Ky, Union, KY 41091Sold
- $336,6003 bd2 ba1.5k sqft8430 Concerto Ct #247, Union, KY 41091Off Market
- $448,312-- bd-- ba-- sqft8430 Concerto Ct, Union, KY 41091Sold
- $386,8002 bd3 ba2.3k sqft8408 Concerto Ct, Union, KY 41091Off Market
- $424,2423 bd3 ba2.3k sqft8458 Concerto Ct #248B, Union, KY 41091Sold
Nearby schools
GreatSchools rating
- 8/10Erpenbeck Elementary SchoolGrades: PK-5Distance: 1.1 mi
- 4/10Ockerman Middle SchoolGrades: 6-8Distance: 2.4 mi
- 9/10Larry A. Ryle High SchoolGrades: 9-12Distance: 1.3 mi
Schools provided by the listing agent
- Elementary: Erpenbeck Elementary
- Middle: Ockerman Middle School
- High: Ryle High
Source: NKMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$462,600
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$462,600
- Kentucky
- Boone County
- Union
- 41091
- 8450 Concerto Ct Unit 248D
Nearby cities
Nearby zip codes
Other Union Topics
