Date
Details
Price
Change
Source
2/05/2026
Listed
$464,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/2
$464,900 Just Listed
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/2
Property Description
Live in the highly anticipated Union Promenade! The Drees Medford is a stunning ranch-style townhome designed for modern living. With a finished lower level and a 2-car attached garage, this home features 3 spacious bedrooms and 3 full baths. The open concept design boasts 9' ceilings, quartz countertops, a large kitchen island, and a walk-in pantry-perfect for culinary creativity. Enjoy luxury vinyl plank flooring, stainless steel appliances, and a gas range. The primary suite is your private retreat, with double vanities and a walk-in closet that dreams are made of. Plus, you're just a short walk from a variety of shops and restaurants, all within the Boone County school district.
Full Property Details
Full Property Details for 2175 Esplanade St
General
- Price: $464,900
- HOA FEE: $245/month
- Status: Active
- Type: Townhouse
- Source: Northern_Kentucky
- MLS ID: 639679
- Updated: 2/5/2026
- Added to Site: Today
Interior
- Number of Rooms: 8
- Interior Features: Kitchen Island, Walk-In Closet(s), Storage, Stone Counters, Smart Thermostat, Pantry, Open Floorplan, Entrance Foyer, Double Vanity, High Ceilings, Recessed Lighting
- Appliances: Stainless Steel Appliance(s), Gas Range, Dishwasher, Disposal, Microwave
Rooms
Bathrooms
- Total Bathrooms: 3
- Full Bathrooms: 3
Bedrooms
- Total Bedrooms: 3
Additional Information
- 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, 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 La Croisette.
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: Association Fees, 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
- Roof: Shingle
- Windows: Vinyl Frames
- Year Built: 2026
Lot Features
- Lot Size Source: Builder
- Lot Dimensions: Irregular
- Zoning: Residential
Financial Considerations
- Association Fee: $245
- 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
— 2175 Esplanade St —
John Heisler
Drees/Zaring Realty
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 2175 Esplanade St
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 Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 2175 Esplanade St
Tax History
Tax History for 2175 Esplanade St
Year
Property Taxes
Change
Tax Assessment
Change
2025
—
$200,000
—
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Estimate the Cost
Estimate the Cost for 2175 Esplanade St
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.
- Single Family
- Active
- Updated 1 day ago
- 4Beds
- 4Total Baths
- 2,851Sq. Ft.
Listed by Stephanie Simpson (859) 468-4227
- Condo
- Active
- Updated 1 day ago
- 2Beds
- 2Total Baths
- 952Sq. Ft.
- Single Family
- Active
- Updated 12 hours ago
- 3Beds
- 2Total Baths
- 1,040Sq. Ft.
- Single Family
- Active
- Updated 3 days ago
- 3Beds
- 1Total Bath
- 936Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Condo
- Active
- Updated 11 hours ago
- 2Beds
- 3Total Baths
- 1,580Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
2175 Esplanade Street, Union, KY 41091 (MLS# 639679) is a Townhouse property with 3 bedrooms and 3 full bathrooms. 2175 Esplanade Street is currently listed for $464,900 and was received on February 05, 2026. Want to learn more about 2175 Esplanade Street? 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.