SELECT COUNT(p.List_Number) AS Total FROM properties p WHERE 1 AND deleted IS NULL AND (City = 'Goleta') AND (p.Features LIKE '%Oceanfront%')