Discover this prime RIVERFRONT GEM, with an ADU where large windows frame breathtaking river vistas from nearly every room! This beautifully updated home features a updated roof, gutters, windows, lighting, and appliances, ensuring modern comfort and style throughout. Step into the stunning kitchen, equipped with a 6-burner Wolf range, exquisite cabinetry, and sleek quartz countertops—perfect for culinary enthusiasts. Stylish lighting fixtures throughout add a touch of elegance to every space. The spacious carport with epoxy floors offers ample parking and storage. Enjoy the expansive deck, ideal for relaxing or entertaining while taking in the amazing river views. Plus, benefit from private access to the water's edge. Centrally located in a gated neighborhood, this home is just minutes from shopping and dining, providing the perfect blend of tranquility and convenience. Don't miss your chance to experience riverfront living at its finest!