Welcome to a rare riverfront opportunity on a quiet side street with convenient central location! Originally built in 1953, this beautifully updated 4 bedroom, 4 bath home sits on approximately .43 acres with 90' of exceptional Mississippi river frontage and some of the easiest water access in the area. Offering over 2,800 finished sq ft including the fully remodeled basement, this property blends charm, comfort, and even income potential. The 2025 renovation transformed the entire basement and a main floor bath, featuring new water lines, fixtures, cabinetry, R-21 insulation, and new carpet throughout. Upstairs layout includes a private ensuite with jacuzzi tub, plus three additional bedrooms, another bathroom & storage galore. Main level is spacious : Enjoy the attached four-season porch, six-person hot tub with new lid, fire pit, in-ground irrigation system updated in 2025, and an attached 4+ car garage. Previously operated as a successful Airbnb since 2023, the home is being offered fully furnished and an active transferable short-term rental license. Ideal as a turnkey investment, vacation retreat, or move-in-ready family home, this property offers flexibility, space, and unbeatable waterfront living!