New Drees ranch-style townhome with a finished lower level and 2 car attached garage. Stunning lake views from the covered deck and patio. The Brandywine has 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, white painted cabinets, luxury vinyl plank flooring, stainless steel appliances, double ovens, and double vanity sinks in the primary bath. It's also equipped with DreeSmart technology, which includes a video doorbell, programable thermostat, wireless router, home automation hub, and smart lock. Enjoy community amenities such as an adult-only pool, kid's pool and kids splash area, outdoor amphitheater, fitness center, and walking paths. Conveniently located near Kroger Market Place and just across the street from Union Promenade, the highly anticipated shopping and entertainment district! All within Boone Country school district.
Sold for $405,801
$405,801
8404 Concerto Ct #246E, Union, KY 41091
3beds
2,392sqft
Townhouse, Residential, Multi Family
Built in 2023
-- sqft lot
$408,200 Zestimate®
$170/sqft
$2,848 Estimated rent
Home value
$408,200
$388,000 - $429,000
$2,848/mo
Zestimate® history
Owner options
List your home for rent
$2,848/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$2,848/mo
Rent Zestimate®
Refinance and save
$2,723/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$2,723/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
Stunning lake viewsWhite painted cabinetsProgramable thermostatNew drees ranch-style townhomeAdult-only poolFitness centerOutdoor amphitheater
Zillow last checked:
Listing updated:
Listed by:
John Heisler 859-468-9032,
Drees/Zaring Realty
Bought with:
Crystal Gibson, 264845
Pivot Realty Group
Source: NKMLS,MLS#: 618276
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 3
Primary bedroom
- Features: Carpet Flooring, Walk-In Closet(s), Bath Adjoins, Ceiling Fan(s)
- Level: First
- Area: 182
- Dimensions: 14 x 13
Bedroom 2
- Features: Carpet Flooring
- Level: First
- Area: 110
- Dimensions: 11 x 10
Bedroom 3
- Features: Carpet Flooring
- Level: Lower
- Area: 144
- Dimensions: 12 x 12
Other
- Features: Carpet Flooring
- Level: Lower
- Area: 360
- Dimensions: 24 x 15
Other
- Features: Carpet Flooring
- Level: Lower
- Area: 266
- Dimensions: 19 x 14
Dining room
- Features: Luxury Vinyl Flooring
- Level: First
- Area: 144
- Dimensions: 16 x 9
Family room
- Features: Luxury Vinyl Flooring
- Level: First
- Area: 224
- Dimensions: 16 x 14
Kitchen
- Features: Kitchen Island, Pantry, Luxury Vinyl Flooring
- Level: First
- Area: 176
- Dimensions: 16 x 11
Primary bath
- Features: Double Vanity, Shower, Luxury Vinyl Flooring
- Level: First
- Area: 108
- Dimensions: 12 x 9
Heating
- Heat Pump, Forced Air
Cooling
- Central Air
Appliances
- Included: Stainless Steel Appliance(s), Electric Range, Gas Cooktop, Dishwasher, Double Oven, Microwave
Features
- Kitchen Island, Wet Bar, Walk-In Closet(s), Storage, Stone Counters, Smart Thermostat, Smart Home, Pantry, Open Floorplan, Entrance Foyer, Double Vanity, Built-in Features, Ceiling Fan(s), High Ceilings, Recessed Lighting, Wired for Data, Master Downstairs
- Windows: Vinyl Frames
- Basement: None
Interior area
- Total structure area: 2,392
- Total interior livable area: 2,392 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, Porch
- Exterior features: Balcony
- Has view: Yes
- View description: Lake
- Has water view: Yes
- Water view: Lake
Details
- Zoning description: Residential
Construction
Type & style
- Home type: Townhouse
- Architectural style: Traditional
- Property subtype: Townhouse, Residential, Multi Family
- Attached to another structure: Yes
Materials
- HardiPlank Type, Brick, 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: Security System, Smoke Detector(s)
HOA
- Has HOA: Yes
- Amenities included: Parking, Landscaping, Lake Year Round, Playground, Pool, Clubhouse, Fitness Center, Trail(s)
- Services included: Maintenance Grounds, Maintenance Structure, Management, Sewer, Snow Removal, Water
- HOA fee: $245 monthly
- Second HOA fee: $250 quarterly
Location
- Region: Union
Financial & listing details
- Price per square foot: $170/sqft
- Date on market: 6/15/2025
- Cumulative days on market: 128 days
Price history
| Date | Event | Price |
|---|---|---|
| 4/12/2024 | Sold | $405,801-4.5%$170/sqft |
Source:  NKMLS #618276 Report a problem | ||
| 3/11/2024 | Pending sale | $424,900$178/sqft |
Source: NKMLS #618276 Report a problem | ||
| 3/1/2024 | Price change | $424,900-3%$178/sqft |
Source: NKMLS #618276 Report a problem | ||
| 11/2/2023 | Listed for sale | $437,901$183/sqft |
Source: NKMLS #618276 Report a problem | ||
Public tax history
Tax history is unavailable.
Neighborhood: 41091
Nearby homes
- $299,9002 bd2 ba1.3k sqft8497 Concerto Court Union Ky, Union, KY 41091Sold
- $--3 bd3 ba2.1k sqft8462 Concerto Court Union Ky, Union, KY 41091Off Market
- $--3 bd3 ba1.8k sqft8458 Concerto Court Union Ky, Union, KY 41091Off Market
- $484,9003 bd3 ba2.6k sqft8450 Concerto Ct, Union, KY 41091Sold
- $--2 bd3 ba1.8k sqft8454 Concerto Court Union Ky, Union, KY 41091Off Market
- $325,0003 bd2 ba1.7k sqft8501 Concerto Court Union Ky, Union, KY 41091Off Market
- $424,2423 bd3 ba2.3k sqft8458 Concerto Ct #248B, Union, KY 41091Sold
- $451,8552 bd2 ba1.5k sqft8442 Concerto Ct, Union, KY 41091Sold
Nearby schools
GreatSchools rating
- 8/10Erpenbeck Elementary SchoolGrades: PK-5Distance: 1.2 mi
- 4/10Ockerman Middle SchoolGrades: 6-8Distance: 2.5 mi
- 9/10Larry A. Ryle High SchoolGrades: 9-12Distance: 1.2 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
$408,200
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
$408,200
- Kentucky
- Boone County
- Union
- 41091
- 8404 Concerto Ct Unit 246E
Nearby cities
Nearby zip codes
Other Union Topics
