magazine-worthy waterfront home