Sign In

Close

x
Showing 1 of 0
X
Save
2228 Esplanade Street Union KY 41091US3 Bed, 3.00 Bath (3 Full Bath), 634799
2228 Esplanade Street UnionKY41091
449900.0000 1/1/1900 12:00:00 AM
Drees/Zaring Realty
1 /

Courtesy of: John Heisler, Drees/Zaring Realty, jheisler@dreeshomes.com

2228 Esplanade Street
Union KY 41091 US

Save
1 /

Courtesy of: John Heisler, Drees/Zaring Realty, jheisler@dreeshomes.com

Get more info about this property

2228 Esplanade Street
Union KY 41091 US

$449,900

Active Listing ID 634799
bed icon
3 bed
bath icon
3.00 Bath (3 Full)
home icon
Townhouse

$449,900

Active Listing ID 634799
Save
3d icon
Maps

2228 Esplanade Street Live where comfort meets convenience at Union Promenade! The Drees Brandywine is a stylish ranch-style townhome featuring 3 bedrooms, 3 full baths, a finished lower level, and a 2-car garage. Enjoy an open floor plan with 9' ceilings, quartz countertops, a large kitchen island, walk-in pantry, stainless steel appliances, and luxury vinyl plank flooring. The spacious primary suite offers a luxury bath with double vanities and a large walk-in closet. All just a short walk from shops and dining, in the Boone County school district.

Collapse all

Property Features

  • Facts
  • Property Type: Residential
  • Property Sub-type: Townhouse
  • Features
  • Full Bathrooms: 3
  • Cooling System: Central Air
  • Exterior Finish: Lighting, Covered, Deck, Patio, Porch
  • Roof Type: Shingle
  • Heating Fuels: Heat Pump (Heating), Hot Water (Heating)
  • Additional Features
  • Patio

School Information

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

Property

  • propertytype: Residential
  • propertysubtype: Townhouse
  • listprice: 449900
  • unparsedaddress: 2228 Esplanade Street
  • postalcity: Union
  • stateorprovince: KY
  • country: US
  • postalcode: 41091
  • bathroomsfull: 3
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0
  • lotsizeunits: Acres
  • livingarea: 2124
  • livingareaunits: Square Feet
  • latitude: 38.95588
  • longitude: -84.678902
  • listagentfullname: John Heisler
  • listagentemail: jheisler@dreeshomes.com
  • listagentkey: 3yd-NKARKY-432512496
  • listagentmlsid: 432512496
  • listagentpreferredphone: 8594689032
  • listagentofficephone: 8595784200
  • listofficekey: 3yd-NKARKY-o432500082
  • listofficemlsid: o432500082
  • 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: 2025
  • listingcontractdate: 2025-07-29
  • countyorparish: Boone
  • elementaryschool: Erpenbeck Elementary
  • highschool: Ryle High
  • elementaryschooldistrict: Boone Co Public
  • middleorjuniorschooldistrict: Boone Co Public
  • highschooldistrict: Boone Co Public
  • appliances: Dishwasher, Garbage Disposer, Microwave, Range, Range - Gas, Washer
  • cooling: Central Air
  • constructionmaterials: Brick, Cedar, HardiPlank Type, Stone, Vinyl Siding
  • heating: Heat Pump (Heating), Hot Water (Heating)
  • fireplaceyn: False
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 2
  • parkingfeatures: Driveway, Garage
  • roof: Shingle
  • waterfrontyn: False
  • interiorfeatures: Kitchen Island, Wet Bar, Walk-in Closet(s), Storage, Stone Counters, Smart Thermostat, Pantry, Open Floorplan, Entrance Foyer, Double Vanity, High Ceilings, Recessed Lighting, Wired For Data
  • exteriorfeatures: Lighting, Covered, Deck, Patio, Porch
  • architecturalstyle: New Traditional
  • rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Dining Room, Family Room, Kitchen, Laundry
  • patioandporchfeatures: Patio, Porch, Deck
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -84.6789, 38.95588
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Drees/Zaring Realty", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "Expenses":[{"ExpenseCategory":"Home Owner Assessments Fee", "ExpenseFrequency":"Monthly", "ExpenseValue":275}], "GeocodeOptions":null, "LeadRoutingEmail":"jheisler@dreeshomes.com", "ListBrokerageCity":"Fort Mitchell", "ListBrokerageCountry":"US", "ListBrokerageEmail":"jackmiller@fuse.net", "ListBrokerageLogoUrl":null, "ListBrokerageName":"Drees/Zaring Realty", "ListBrokeragePhone":"(859) 380-4649", "ListBrokeragePostalCode":"41017", "ListBrokerageStateOrProvince":"KY", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"211 Grandview Drive", "ListBrokerageWebsiteUrl":"http://www.dreeshomes.com www.zaring.com", "ListOfficeAddress1":"211 Grandview Drive", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"656012954", "ListOfficeCity":"Fort Mitchell", "ListOfficeCountry":"US", "ListOfficeEmail":"bdrees@dreeshomes.com", "ListOfficePostalCode":"41017", "ListOfficeStateOrProvince":"KY", "ListPriceCurrencyType":"USD", "ListingTitle":"Townhouse, Traditional - Union, KY", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/2228-Esplanade-St_Union_KY_41091_M91316-46105?f=listhub&s=NKARKY&m=634799&c=rexren", "MLSModificationTimestamp":null, "Neighborhoods":[{"Description":null, "Name":"K11 - Richwd/Un/Wal/Ver/SB"}], "PostalCode":null, "RawPropertySubType":"Townhouse", "RawPropertyType":"Residential", "RoomCount":8, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 8/3/2025 4:01:58 PM GMT
Source Updated Date: 12/8/2025 6:53:59 PM GMT

Courtesy of: John Heisler, Drees/Zaring Realty, jheisler@dreeshomes.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