select count(*) AS count from GLD WHERE L_StatusCatID='Active' AND LM_Char10_22!='' AND L_City!='' AND (L_AskingPrice BETWEEN '00100000' AND '99000000')