Sign In

Close

x
Showing 1 of 0
X
Save
8540 Concerto Court Union KY 41091US3 Bed, 2.00 Bath (2 Full Bath), 638534
8540 Concerto Court UnionKY41091
2500.0000 1/1/1900 12:00:00 AM
Keller Williams Realty Services

8540 Concerto Court
Union KY 41091 US

Save
1 /

Courtesy of: Venus Bertucci, Keller Williams Realty Services, vbertucci@kw.com

Get more info about this property

8540 Concerto Court
Union KY 41091 US

$2,500

Active Listing ID 638534
bed icon
3 bed
bath icon
2.00 Bath (2 Full)
home icon
Condominium

$2,500

Active Listing ID 638534
Save
3d icon
Maps

8540 Concerto Court Great lease opportunity! 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. Smart home features like a video doorbell and smart lock offer modern convenience. Enjoy community amenities like an adult-only pool, a kids' splash area, and scenic walking paths leading to a tranquil lake. Conveniently located near Kroger Marketplace and the vibrant Union Promenade, this home perfectly balances serenity and accessibility-all within the Boone County school district.

Collapse all

Property Features

  • Facts
  • Property Type: Residential
  • Property Sub-type: Condominium
  • Features
  • Full Bathrooms: 2
  • Cooling System: Central Air
  • Exterior Finish: Balcony
  • Roof Type: Shingle
  • Heating Fuels: Electric (Heating)
  • Additional Features
  • Patio

School Information

  • School
  • Erpenbeck Elementary(Elementary)
  • Ockerman Middle School(MiddleSchool)
  • Ryle High(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Condominium
  • listprice: 2500
  • unparsedaddress: 8540 Concerto Court
  • postalcity: Union
  • stateorprovince: KY
  • country: US
  • postalcode: 41091
  • bathroomsfull: 2
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeunits: Acres
  • livingarea: 0
  • livingareaunits: Square Feet
  • latitude: 38.949177
  • longitude: -84.674688
  • listagentfullname: Venus Bertucci
  • listagentemail: vbertucci@kw.com
  • listagentkey: 3yd-NKARKY-432510132
  • listagentmlsid: 432510132
  • listagentpreferredphone: 8599929905
  • listagentofficephone: 8592400727
  • listofficekey: 3yd-NKARKY-o432501236
  • listagentstatelicense: 220012
  • listofficemlsid: o432501236
  • disclaimer: Copyright © 2025 Northern Kentucky MLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: NKARKY
  • yearbuilt: 2024
  • listingcontractdate: 2025-12-08
  • listagenturl: http://www.sellingnorthernkentucky.com
  • countyorparish: Boone
  • elementaryschool: Erpenbeck Elementary
  • highschool: Ryle High
  • elementaryschooldistrict: Boone Co Public
  • middleorjuniorschooldistrict: Boone Co Public
  • highschooldistrict: Boone Co Public
  • appliances: Electric Range, Electric Oven, Stainless Steel Appliance(s), Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Washer
  • cooling: Central Air
  • constructionmaterials: HardiPlank Type, Brick, Stone, Vinyl Siding
  • heating: Electric (Heating)
  • fireplaceyn: False
  • transactiontype: ForRent
  • storiestotal: 1
  • parkingtotal: 0
  • parkingfeatures: Driveway, Garage, Open, On Street, Off Street
  • roof: Shingle
  • waterfrontyn: False
  • franchiseaffiliation: Keller Williams Realty
  • interiorfeatures: Stone Counters, Open Floorplan, Pantry, Kitchen Island, Entrance Foyer, Double Vanity, Walk-In Closet(s), Smart Thermostat, High Ceilings, Wired for Data
  • exteriorfeatures: Balcony
  • windowfeatures: Insulated Windows, Vinyl Frames
  • architecturalstyle: Other
  • rooms: Laundry Room, Bedroom 1, Dining Room, Bedroom 2, Bedroom 3, Bathroom 2, Bathroom 1
  • utilities: Cable Available
  • patioandporchfeatures: Deck
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: False
  • internetconsumercommentyn: False
  • location: -84.67469, 38.949177
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Keller Williams Realty Services", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"vbertucci@kw.com", "ListBrokerageCity":"Florence", "ListBrokerageCountry":"US", "ListBrokerageEmail":"klrw866@kw.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/NKARKY/fa219a916a6d11dfb4ac00219b994c72/20100614164901720.png", "ListBrokerageName":"Keller Williams Realty Services", "ListBrokeragePhone":"(859) 240-0727", "ListBrokeragePostalCode":"41042", "ListBrokerageStateOrProvince":"KY", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"7210 Turfway Rd", "ListBrokerageWebsiteUrl":"http://www.sellingnorthernkentucky.com", "ListOfficeAddress1":"7210 Turfway Rd ", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"o432501236", "ListOfficeCity":"Florence", "ListOfficeCountry":"USA", "ListOfficeEmail":"mrottinghaus@kw.com", "ListOfficePostalCode":"41042", "ListOfficeStateOrProvince":"KY", "ListPriceCurrencyType":"USD", "ListingTitle":"CONDOS - Other - Union, KY", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/8540-Concerto-Ct_Union_KY_41091_M90068-72066?f=listhub&s=NKARKY&m=638534&c=rexren", "MLSModificationTimestamp":"2025-12-09 19:23:51", "Neighborhoods":[{"Description":null, "Name":"K11 - Richwd/Un/Wal/Ver/SB"}], "PostalCode":null, "RoomCount":6, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 12/19/2025 10:12:44 PM GMT
Source Updated Date: 12/20/2025 6:50:27 PM GMT

Courtesy of: Venus Bertucci, Keller Williams Realty Services, vbertucci@kw.com

Copyright © 2025 Northern Kentucky MLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Contact