Set within a magnificent Colonial Revival mansion named The Tides (c1893), this stunning waterfront condo offers spectacular unobstructed water views of Bristol Harbor & down the bay to the Newport Bridge. Occupying half of the entire 1st floor of this elegant historic building, the condo offers one floor living. Enjoy countless hours of watching boats in Bristol harbor, sunsets over the water, sailboat racing, the Prudence Island ferry & bird wildlife. Wonderful period details within the unit include hardwood floors, high ceilings, cornice moldings, wainscoting, decorative fireplace & graceful mantelpiece with glass fronted display shelves. Highlights include an updated kitchen with new appliances, a newer gas boiler (5 yrs), ductless air conditioning for kitchen & great room & plentiful built-in storage. There are 2 outdoor areas overlooking the water - a deck off the kitchen & a lower-level brick patio. For boat owners, Tides' owners are eligible to apply for a mooring. Set on an 2/3-acre waterfront parcel with beautifully maintained grounds, immediately to the north is a beach where you can swim, launch a paddleboard or kayak. Flood insurance is included in the condo fees. Enjoy waterfront living within historic downtown Bristol within walking distance to numerous restaurants, shops, museums, bars, the East Bay bike path from Bristol to Providence & Bristol ferries to Prudence Island as well as the seasonal high-speed ferry between Bristol, Newport & Providence.