Description

IMMEDIATE OCCUPANCY ***
Waterfront ”Penthouse!” Fischer Hayward nearly 1500 sf+/- Open concept floorplan + Cathedral ceilings, large windows & glass doors access the deck & view of the ”lake” revealing an expansive ”vibe’. Room for 10′ Christmas tree (+/-) or tall decorative plants. Add to this ”picture”, the corner fireplace with abundance of space for the holiday candles & decor. There’s the primary bedroom w/2 separate closets joined by the massive primary bathroom featuring large garden tub PLUS separate shower & double vanity. Guest room & hall bath + office/3rd bedroom on the opposite end of condo give privacy for guests/roommates/family. Just in time for cold snowy days, the private entry garage with direct access to this Hayward design makes for a safer, warmer experience coming home to ”your” 1st floor Entry & Coat Closet. All Appliances + Washer/Dryer*Solid Surface countertops*Freshly painted throughout* Walk, bike to restaurants/Shopping/Library*Erpenbeck Elementary*
Owners transferred. NO relocation company.
ACHOSA Home Warranty

Address

Open on Google Maps

Address:1854 Mimosa Trail
City:Florence
Zip/Postal Code:41042
Area:Boone

Details

Updated on November 14, 2025 at 4:57 pm

Property ID637677
Price$259,900
Property Size1500 Sqft
Land Area0.01 Acres
Bedrooms3
Rooms7
Bathrooms2
Garage1.0
Garage Sizex x
Year Built2004
Property TypeCondominium, Residential

Additional details

Association Fee400.0
RoofShingle
UtilitiesCable Available,Sewer Available,Water Available,None
SewerPublic Sewer
CoolingCentral Air
HeatingElectric
CountyBoone
Property TypeResidential
ParkingDriveway,Garage,Garage Door Opener,Garage Faces Front,Off Street
Elementary SchoolErpenbeck Elementary
Middle SchoolOckerman Middle School
High SchoolRyle High
Architectural StyleTransitional

Schedule a Tour

Mortgage Calculator

Disclaimer: Property listing data is provided by the Northern Kentucky MLS. Information is deemed reliable but not guaranteed. Properties are subject to prior sale, change, or withdrawal at any time. The Amy Houston Team and Real Broker, LLC provide real estate brokerage services. Amy Houston is licensed in the states of Kentucky and Ohio — Kentucky License #220192. Buyers are encouraged to verify all information independently, including but not limited to: square footage, lot size, school district boundaries, zoning, utilities, and property features. School district enrollment and boundaries are subject to change and should be confirmed directly with the appropriate district. Equal Housing Opportunity. REALTOR®.