4520 Water Street Custom waterfront home offering a rare combination of privacy, recreation, and entertaining space in a small-town setting. This iconic Columbiaville building has been converted into a residential home with a large addition, this unique property sits on two city lots with no neighboring homes in lakeview sight and overlooks an excellent walleye fishing area. The home features 3 bedrooms, 3 full baths, and 2 half baths, including both first- and second-floor primary suites. Inside, you'll find custom kitchens with custom countertops, a chef's kitchen with oversized pantry with extra fridge & freezer plus an Ice maker, dedicated coffee bar area, upstairs full wet bar, two gas fireplaces, and extensive updates including all new electrical and plumbing, three new furnaces, new windows within the last five years, new appliances, reverse osmosis system, two on-demand water heaters, heated shop floors, and new roofing including a flat roof with a 20-year warranty. The outdoor entertaining areas are equally impressive with a large upper waterfront patio, expansive lower patio, hidden fire pit patio built into the rock wall at the water's edge, professionally landscaped hardscape, docks, pontoon hoist, and jet ski hoist. Small boats and jet skis can access the big all-sports water while the pontoon can travel far upriver for a private leisurely cruise. Additional features include a heated slab in the new garage, dry basement storage, and included pontoon boat plus two jet skis.