SELECT COUNT(*) AS COUNT FROM Listing L INNER JOIN Firm F ON L.FirmId = F.FirmId WHERE L.StateId = 33 AND L.TownId = 14586 AND F.StateId = 33 AND F.TownId = 14586 AND L.CategoryId = 8489 your city Yellow Pages | Fave Central Community