SELECT COUNT(*) as cnt FROM vwr1_listing_master as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.city IN('Spirit Lake')
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=