David Moot had always fantasized about owning a beachfront retreat on Cape Cod, but never thought he could afford it—until he stumbled upon a coastal gem listed for just $395,000. At roughly half the median sales price in the area according to recent estimates, the listing seemed too good to be true. And it was...