In today’s overheated housing market, is the concept of owning your own waterfront home a punishing fantasy or an achievable reality?