SELECT COUNT(p.List_Number) AS Total  FROM properties p WHERE 1  AND deleted IS NULL  AND (SUBSTRING(p.Area, 1, 2) = '10') AND (p.Features LIKE '%Oceanfront%')