Date
Details
Price
Change
Source
9/30/2024
Listed
$479,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/8
$479,900
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/8
Property Description
Located in the highly anticipated Union Promenade Entertainment District! New Drees ranch-style townhome with a finished lower level and 2 car attached garage. The Waverly offers 3 bedrooms and 3 baths. It has an open concept design with features like 9' smooth ceilings, quartz countertops, a large kitchen island, walk-in pantry, painted cabinets, luxury vinyl plank flooring, stainless steel appliances, double ovens, double vanity sinks in the primary bath and a luxurious super shower! It's also equipped with DreeSmart technology, which includes a video doorbell, programable thermostat, wireless router, home automation hub, and smart lock. Enjoy a quick walk to a variety of shopping and dining. All within Boone Country school district.
Full Property Details
Full Property Details for 2260 Esplanade St
General
- Price: $479,900
- HOA FEE: $257/month
- Status: Active
- Type: Condo
- Source: Northern_Kentucky
- MLS ID: 626910
- Updated: 12/9/2024
- Added to Site: 81 day(s) ago
Interior
- Number of Rooms: 8
- Interior Features: Kitchen Island, Wet Bar, Walk-In Closet(s), Storage, Stone Counters, Smart Thermostat, Smart Home, Pantry, Open Floorplan, Double Vanity, Ceiling Fan(s), High Ceilings, Recessed Lighting, Wired for Data
- Appliances: Stainless Steel Appliance(s), Electric Range, Gas Cooktop, Gas Oven, Dishwasher, Double Oven, Microwave
- Flooring: Carpet, Vinyl
Rooms
Bathrooms
- Total Bathrooms: 3
- Full Bathrooms: 3
Bedrooms
- Total Bedrooms: 3
Additional Information
- Shared Amenities: Other, Parking, Landscaping
- Security/Safety: Smoke Detector(s)
Exterior
- Exterior Features: Balcony, Lighting
- Porch/Patio/Deck: Covered, Deck, Patio, Porch
Parking
- Garage: Yes
- Attached garage: Yes
- Garage Spaces: 2
- Parking Features: Attached, Driveway, Garage, Garage Door Opener, Garage Faces Front
Location
- County: Boone
- Cross Streets: Venice Street
- Driving Directions: I-71/75 to south on Route 42 (Florence exit), right on Children's Way, right on Venice Street, right on Esplanade
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, Management, Snow Removal, Insurance
Heating & Cooling
- Central air: Yes
- Air Conditioning: Yes
- Cooling Type: Central Air Conditioning
- Heating Type: Natural Gas, Forced Air
Utilities
- Sewer: Public Sewer
- Water: Public
- Cable Available: Yes
- Utility Description: Cable Available, Natural Gas Available, Sewer Available, Water Available
Structural Information
- Architectural Style: Ranch
- Construction: HardiPlank Type, Brick, Cedar, Stone, Vinyl Siding
- Basement Desc.: Finished, Bath/Stubbed, Storage Space, Walk-Out Access
- Roof: Shingle
- Windows: Insulated Windows, Vinyl Frames
- Year Built: 2024
- Property Condition: New Construction
Lot Features
- Property View: Pond
- Lot Size Source: Builder
- Lot Dimensions: Irregular
- Frontage: Private Road, Paved
- Lot Features: Pond on Lot, Rolling Slope
- Zoning: Residential
Financial Considerations
- Association Fee: $257
- 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
— 2260 Esplanade St —
John Heisler
Drees/Zaring Realty
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 2260 Esplanade St
| Rating | Name | Grades | Distance |
|---|---|---|---|
|
9001 Wetherington Blvd, Florence, KY 41042 | PK-5 | 1 mi | |
|
10435 Us Highway 42, Union, KY 41091 | PK-5 | 1.8 mi | |
|
2805 Longbranch Rd, Union, KY 41091 | PK-5 | 2 mi | |
|
7515 Shamrock Avenue, Union, KY 41091 | 6-8 | 1.3 mi | |
|
10400 Us Highway 42, Union, KY 41091 | 6-8 | 1.7 mi | |
|
8300 Us Highway 42, Florence, KY 41042 | 6-8 | 2.2 mi | |
|
10379 Us Highway 42, Union, KY 41091 | 9-12 | 1.5 mi | |
|
2855 Longbranch Rd, Union, KY 41091 | 9-12 | 2.2 mi | |
|
99 Center St, Florence, KY 41042 | 9-12 | 4.1 mi |
Disclaimer: School ratings provided by
GreatSchools. Ratings are on a scale of 1-10.
Learn more about GreatSchools ratings.
School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 2260 Esplanade St
Estimate the Cost
Estimate the Cost for 2260 Esplanade St
Home Warranty : Included
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 22 hours ago
- 3Beds
- 2Total Baths
- 1,092Sq. Ft.
Listed by John Hodge (513) 315-8420
- Single Family
- Active
- Updated 2 days ago
- 4Beds
- 1Total Bath
- 1,144Sq. Ft.
Listed by Sherri Chamberlain (859) 496-3007
- Single Family
- Active
- Updated 21 hours ago
- 3Beds
- 2Total Baths
- 1,488Sq. Ft.
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
- 3Beds
- 3Total Baths
- 1,668Sq. Ft.
- Single Family
- Active
- Updated 1 day ago
- 4Beds
- 5Total Baths
- 4,334Sq. Ft.
- Single Family
- Active
- Updated 4 days ago
- 4Beds
- 2Total Baths
- 1,421Sq. Ft.
- Single Family
- Active
- Updated 3 days ago
- 4Beds
- 3Total Baths
- 2,576Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
2260 Esplanade Street, Union, KY 41091 (MLS# 626910) is a Condo property with 3 bedrooms and 3 full bathrooms. 2260 Esplanade Street is currently listed for $479,900 and was received on September 30, 2024. Want to learn more about 2260 Esplanade Street? Do you have questions about finding other Condo real estate for sale in Union? You can browse all Union real estate or contact a Coldwell Banker agent to request more information.