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%')