Sought-after address on the edge of the bay