Truly rare opportunity to own a one-of-a-kind property offering endless residential, business, and revenue-generating possibilities. With desirable MX1 zoning, this unique character building could easily function as a stunning family home, office-front residence, or be converted into a double or triple-suited revenue property. The options here are truly endless. Pride of ownership is evident throughout, with extensive renovations and thoughtful upgrades completed over the years. Tastefully decorated and full of charm, this impressive property features 4 bedrooms, a den, and 3 bathrooms, along with an incredible 35' x 24' office/shop front complete with separate street-front entry. The main floor boasts a beautifully updated kitchen with eat-up island and natural gas stove, flowing nicely into the living area and heated rear porch - the perfect entertaining space featuring a stunning barn door entrance. Recent upgrades include shingles, soffits, eavestroughs, siding, doors, windows, high-efficiency furnace, flooring, paint, tankless water heater, 200 amp service, 220 wiring, and much more. Larger lot gives access for a double detached garage and still have room for a garden and greenspace . Also the yard adds comfort with both a patio and deck for all the entertaining you can handle . Upstairs offers an abundance of flexible living space, highlighted by a spacious primary bedroom connected to a huge family room with natural gas fireplace and an absolutely stunning custom bathroom featuring a separate glass shower and tub. A large second-floor laundry/office room adds even more functionality to this incredible home. Located just steps from coffee shops, restaurants, shopping, downtown, and the river, this property combines character, convenience, and unlimited potential. A must-see property to truly appreciate everything it has to offer