Rare investment opportunity situated directly across from the Chippawa Creek, this 9-unit building boasts incredible waterfront proximity with added potential to lease the land across the street for a dock or other value-enhancing features. With Tourist Commercial (TC) zoning, the property supports a wide range of uses including long-term rentals, short-term Airbnb stays, or a hybrid model, making it ideal for savvy investors.The building includes seven 1-bedroom units with scenic water views, two 2-bedroom units at the rear, all sharing a common laundry and storage area. Seven units and common areas have already been demo'd and cleaned, with updated emergency lighting, a new backflow prevention valve, and front cleanouts installed. A two-year-old roof adds peace of mind. Remaining work includes general interior finishes and final touches, with the building nearing the final stages of revitalization. Whether you're looking to reposition the property as a premium rental offering or capitalize on the area's strong short-term rental demand, this location offers exceptional flexibility, waterfront charm, and long-term upside.