Date
Details
Price
Change
Source
3/24/2026
Listed
$444,900
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/39
$444,900 Just Listed
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/39
Property Description
Experience comfort and convenience at Union Promenade! The Drees Brandywine is a beautifully designed ranch-style townhome offering 3 bedrooms, 3 full baths, a finished lower level with a dedicated hobby room, and a 2-car garage. The open-concept layout features 9' ceilings, quartz countertops, a spacious kitchen island, walk-in pantry, stainless steel appliances, and luxury vinyl plank flooring throughout the main living areas. The private primary suite includes a well-appointed bath with double vanities and a generous walk-in closet. Ideally located within walking distance to shopping and dining, and situated in the Boone County School District.
Full Property Details
Full Property Details for 2220 Esplanade St #23D
General
- Price: $444,900
- HOA FEE: $275/month
- Status: Active
- Type: Townhouse
- Source: Northern_Kentucky
- MLS ID: 640839
- Updated: Today (3/24/2026)
- Added to Site: Today
Interior
- Number of Rooms: 9
- Interior Features: 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
- Appliances: Stainless Steel Appliance(s), Gas Range, Dishwasher, Disposal, Microwave
Rooms
Bathrooms
- Total Bathrooms: 3
- Full Bathrooms: 3
Bedrooms
- Total Bedrooms: 3
Additional Information
- Shared Amenities: Landscaping
- Security/Safety: Security System, Smoke Detector(s)
Exterior
- Porch/Patio/Deck: Covered, Deck, Patio, Porch
Parking
- Garage: Yes
- Attached garage: Yes
- Garage Spaces: 2
- Total Spaces: 2
- Parking Features: Attached, Driveway, Garage, Garage Door Opener, Garage Faces Front
Location
- County: Boone
- Subdivision: Union Promenade
- Driving Directions: I-71/75 to south on Rt. 42 (Florence exit) to right on Children's Way, to right on Venice Street, to right on Esplanade Street.
School Information
- Elementary School: Erpenbeck Elementary
- Middle School: Ockerman Middle School
- High School: Ryle High
Community
- Community Name: K11 - Richwd/Un/Wal/Ver/SB
- Association: Yes
- Assoc. Fees Include: Maintenance Grounds, Maintenance Structure, Snow Removal, Insurance
Heating & Cooling
- Central air: Yes
- Air Conditioning: Yes
- Cooling Type: Central Air Conditioning
- Heating Type: Natural Gas, Hot Water, Heat Pump
Utilities
- Sewer: Public Sewer
- Water: Public
- Cable Available: Yes
- Utility Description: Cable Available, Natural Gas Available, Sewer Available, Water Available
Structural Information
- Architectural Style: Traditional
- Construction: HardiPlank Type, Brick, Cedar, Stone, Vinyl Siding
- Basement Desc.: Full Finished Bath, Full, Finished, Storage Space, Walk-Out Access
- Roof: Shingle
- Windows: Insulated Windows, Vinyl Frames
- Year Built: 2026
- Property Condition: New Construction
Lot Features
- Lot Size Source: Builder
- Lot Dimensions: Irregular
- Frontage: State Road, Paved
- Zoning: Residential
Financial Considerations
- Association Fee: $275
- Assoc Fee Freq.: Monthly
Listed by Drees/Zaring Realty, John Heisler
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agent
— 2220 Esplanade St #23D —
John Heisler
Drees/Zaring Realty
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 2220 Esplanade St #23D
School District:Boone County School District
| Name | Grades | Distance |
|---|---|---|
Erpenbeck Elementary School US 42 9001 Wetherington Blvd, Florence, KY 41042 | K-5 | 1 mi |
Ockerman Middle School 8300 U.S. 42, Florence, KY 41042 | 6-8 | 2.2 mi |
Larry A. Ryle High School 10379 U.S. 42, Union, KY 41091 | 9-12 | 1.6 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 2220 Esplanade St #23D
Estimate the Cost
Estimate the Cost for 2220 Esplanade St #23D
Home Warranty : Included
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Condo
- Active
- Updated 5 days ago
- 2Beds
- 2Total Baths
- 1,236Sq. Ft.
- Single Family
- Active
- Updated 2 hours ago
- 3Beds
- 4Total Baths
- 1,902Sq. Ft.
- Single Family
- Active
- Updated 6 days ago
- 4Beds
- 4Total Baths
- 2,346Sq. Ft.
- Single Family
- Active
- Updated 1 hour ago
- 3Beds
- 2Total Baths
- 1,330Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Condo
- Active
- Updated 3 days ago
- 2Beds
- 2Total Baths
- 1,168Sq. Ft.
- Townhouse
- Active
- Updated 3 days ago
- 2Beds
- 2Total Baths
- 1,269Sq. Ft.
- Condo
- Active
- Updated 22 hours ago
- 3Beds
- 2Total Baths
- 1,408Sq. Ft.
Listed by Chrissy Graham (859) 750-4593
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
2220 Esplanade Street #23D, Union, KY 41091 (MLS# 640839) is a Townhouse property with 3 bedrooms and 3 full bathrooms. 2220 Esplanade Street #23D is currently listed for $444,900 and was received on March 24, 2026. Want to learn more about 2220 Esplanade Street #23D? Do you have questions about finding other Townhouse real estate for sale in Union? You can browse all Union real estate or contact a Coldwell Banker agent to request more information.