First time on the market, Desirous neighborhood, one block to beach, Property sold in as-is condition only