Amazing WATERFRONT condo in this magnificent mansion called "The Tides" with sweeping unobstructed views of Bristol Harbor and bay with breathtaking sunsets! This second floor end unit also boasts an amazing 20x14 deck with spectacular water views, plus an awesome place to watch the July 4th parade with family and friends! There is also a private back deck to enjoy coffee or cocktails overlooking the bay. Updates to this freshly painted unit include a renovated kitchen with new appliances and granite, new flooring, two A/C wall units and new hot water tank. The renovated bathroom also has a new stackable washer/dryer. Brand new remote window shades in all windows. The spacious open living/dining area has curved walls and large windows with tons of natural sunlight. This property is adjacent to a small town beach where you can launch your kayak or canoe or perhaps take a swim. A short stroll to vibrant downtown Bristol with shopping and fine dining at your fingertips. As a bonus there is a large storage space in the basement along with two parking places. Buyer to pay 1/2 % of 1 % of sales price for working capital. Don't miss out on this amazing opportunity to own a slice of heaven in Bristol!!