grand waterfront estate for sale