2175 Esplanade StreetUnion, KY 41091

2175 Esplanade StreetUnion, KY 41091

1/4 Fullscreen
$464,900
Residential - Townhouse MLS 639679
3 beds 3 full baths
Ask a Question Make an Offer Schedule a Showing
Google Map
Get Directions

Listed By

Agency Name: Drees/Zaring Realty
Agency Phone: 859-578-4200

Shown By

Agency Title: Cutler Real Estate
Agency Phone: 888-763-7575

IDX logo

TOUR THIS HOME

Choose a date and time to see 2175 Esplanade Street, Union, KY 41091.
An agent will get in touch to confirm your request shortly.

Choose your video chat app
Request a Showing
  • Thursday March 12
  • Friday March 13
  • Saturday March 14
  • Sunday March 15
  • Monday March 16
  • Tuesday March 17
  • Wednesday March 18
  • Thursday March 19
  • Friday March 20
  • Saturday March 21
  • Sunday March 22
  • Monday March 23
  • Tuesday March 24
  • Wednesday March 25
  • Thursday March 26
  • 7:00 AM
  • 7:30 AM
  • 8:00 AM
  • 8:30 AM
  • 9:00 AM
  • 9:30 AM
  • 10:00 AM
  • 10:30 AM
  • 11:00 AM
  • 11:30 AM
  • 12:00 PM
  • 12:30 PM
  • 1:00 PM
  • 1:30 PM
  • 2:00 PM
  • 2:30 PM
  • 3:00 PM
  • 3:30 PM
  • 4:00 PM
  • 4:30 PM
  • 5:00 PM
  • 5:30 PM
  • 6:00 PM
  • 6:30 PM
  • 7:00 PM
  • 7:30 PM
  • 8:00 PM
  • 8:30 PM
  • 9:00 PM
Preferred Communication Method
Cross Country Logo

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, youre just a short walk from a variety of shops and restaurants, all within the Boone County school district.

2175 Esplanade Street | MLS# 639679

This townhouse located at 2175 Esplanade Street, Union, KY 41091 is currently listed for sale with an asking price of $464,900. This property was built in 2026 and has 3 bedrooms and 3 full baths. Esplanade Street is located in the Union Promenade subdivision within the Boone Co Public school district. Search Union Promenade real estate on 9590shawneetrail.cutlerhomes.com today.

Property Features

Property Type: Residential - Townhouse
Basement: Yes
Basement: Full
Cooling: Central Air
Days on Market: 34
Garage: 2 car attached
Heating: Natural Gas, Hot Water, Heat Pump
Home Style: Traditional
Lot Size: Irregular
Roof Type: Shingle
Stories: 1.0
Year Built: 2026

Feature Descriptions

Appliances: Stainless Steel Appliance(s), Gas Range, Dishwasher, Disposal, Microwave
Association Fee Includes: Association Fees, Maintenance Grounds, Maintenance Structure, Snow Removal, Insurance
Exterior: HardiPlank Type, Brick, Cedar, Stone, Vinyl Siding
Foundation: Poured Concrete
HOA: Yes
HOA Fee: 245/Monthly
Interior: Kitchen Island, Walk-In Closet(s), Storage, Stone Counters, Smart Thermostat, Pantry, Open Floorplan, Entrance Foyer, Double Vanity, High Ceilings, Recessed Lighting
Lot Dimensions: Irregular
Parking: Attached, Garage, Garage Door Opener, Garage Faces Front
Parking Total: 2
Patio/Porch: Covered, Deck, Patio, Porch
Property Attached: Yes
Rooms Total: 8
Security: yes
Security: Security System, Smoke Detector(s)
Sewer: Public Sewer
Structure Type: Multi Family
Sub Type: Townhouse
Utilities: Cable Available, Natural Gas Available, Sewer Available, Water Available
Water: Public
Window: Vinyl Frames

Room Sizes

Entry: 9 X 4 Level - First
Family Room: 15 X 14 Level - First
Dining Room: 14 X 11 Level - First
Kitchen: 12 X 9 Level - First
Laundry: 9 X 7 Level - First
Primary Bedroom: 14 X 13 Level - First
Bedroom 2: 11 X 10 Level - First
Primary Bath: 12 X 9 Level - First
Bathroom 2: 8 X 6 Level - First
Bedroom 3: 14 X 12 Level - Lower
Bathroom 3: 9 X 5 Level - Lower
Recreation Room: 24 X 13 Level - Lower

Local Schools

High School: Ryle High
Middle School: Ockerman Middle School
Elementary School: Erpenbeck Elementary
School District: Boone Co Public

Market Trends

Boone County Residential Market Trend Graphs
  • Zip Code 41091

Source: Delta Media Group, Inc.

Demographics

Boone County Demographic Information for 2175 Esplanade Street, Union, KY 41091
Fips
Fips Code 21015
Population
2020 to 2023 Change up 3.3%
2010 Count 118,811
2020 Count 135,968
2023 Estimate (V2023) 140,496
2020 Estimate (V2023) 135,988
Age Distribution (Years Old)
0 to 4 6.4%
5 to 17 25.1%
18 to 64 53.4%
65 and Older 15.1%
Gender
Male 49.9%
Female 50.1%
Place of Birth
Foreign 6.3%
US 93.7%
Education
High School Graduate, Age 25+ 93.8%
Bachelor's Degree or Higher, Age 25+ 34.6%
Computer and Internet use
Households with a computer 96.0%
Households with a broadband Internet subscription 92.0%
Language
English is Second Language, Age 5+ 8.4%
English is First Language, Age 5+ 91.6%
Veterans
Veterans 8,575
Income
Per Capita Income $41,281
Median Household Income $91,697
People in Poverty 7.4%
Commute
Average Work Commute Time 25 minutes
Housing
Total Housing Units 53,449
Households 49,587
Average Household Size 2.72
Owner-Occupied 76.2%
Multi-Family 21.9%
Owner-Occupied Median Value $237,600
Median selected monthly owner costs -with a mortgage $1,546
Median selected monthly owner costs -without a mortgage $546
Median gross rent $1,177
Building Permits
New Private Housing Issued 2023 798
Years at Residence
1 Year or More 86.4%
Less Than 1 Year 13.6%
Business and Employment
Private non-farm Establishments 3,153
Private non-farm Employment 85,591
Private non-farm Employment Growth up 1.9%
Nonemployer Establishments 9,115
Number of Firms 8,886
Business Production
Value of Shipments $4,702,457,000
Wholesale Trade $37,571,250,000
Retail Trade $4,772,007,000
Retail Sales Per Capita $20,797
Accommodation and Food Services $403,126,000
Land
Land Area 246.36 sq. miles
Population Per Square Mile 483

Source: US Census Bureau

Estimate Your Payment

Estimated Payment

$ 2,403.85 per month $2,268.25 Principal & Interest $0.00 Property Tax (data not provided by mls) $135.60 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)
Croos Country Mortgage
SUBMIT AN OFFERx