For those looking for that rare oceanfront property for sale on the north end of Sandbridge, one has just come…