Rare Riverfront Opportunity - 515' of Water Frontage | Walkout Basement | Motivated Seller *** Built in 2006, this home offers approximately 1,900 sq. ft. on the main level, plus a partially finished walkout basement, all situated to take full advantage of the stunning river views. The home features a smart, spacious layout with an open-concept living area, quartz countertops, and a generous primary suite overlooking the water. An attached 2 Stall Garage, plus Shed and 1 stall detached Garage offer great storage or workspace. Property needs TLC, motivated seller is offering it strictly as-is. This is a great opportunity for investors, contractors, or buyers looking to build equity with some updates. No FHA, VA, or USDA financing. Cash or conventional financing only. With an excellent floor plan, and unbeatable location, this home is ready for your vision. Bring your ideas and make the most of this rare riverfront gem!