This completely renovated designer home at 42 Orchard Avenue offers the perfect blend of luxury, flexibility, and coastal living. Featuring 4 beds, 3.5 baths, beautiful water views, and a fully finished legal ADU cottage, this is a rare opportunity to own a move-in ready property just steps from the shoreline. Renovated top to bottom , every detail has been thoughtfully curated including all new siding, roof, windows, decking, HVAC, & central air. The main residence showcases a bright spacious layout with wide plank engineered hardwoods throughout, multiple living spaces, & elevated designer finishes at every turn. The stunning chef's kitchen features GE Caf appliances, quartz countertops, custom cabinetry, large pantry, and seamless flow for entertaining. Upstairs, a sun-filled secondary living area captures beautiful water views, and the private primary suite offers its own deck and oversized walk-in closet. Expansive outdoor spaces create the ideal setting for entertaining, morning coffee, or summer evenings by the water. Adding even more value and versatility is the detached 500 SF legal ADU cottage complete with its own kitchen, living space, 1 bed and full bath ideal for guests, multi-generational living, au pair quarters, home office, or income potential. Located in the award-winning Blue Ribbon Barrington school district and just moments to the water, this exceptional property combines designer living with the charm and lifestyle of coastal Rhode Island.