SELECT SQL_CALC_FOUND_ROWS sno, property_id, saleprice, user_code, propertyfor, proptype, sel_dist, sel_loca, locality, post_date, pactive, total_land, saleprice, const_area, bed, bath, furnishing, thumb FROM post_property where pactive > 0 and propertyfor = 'sale' and proptype like '%Office Space For Sale In Flat For Sale In Flat For Sale In Flat For Sale In Flat For Sale In Office Space For Sale In Flat For Sale In Flat%' and ( (locality like '%projects/projects/js/counter/jquery.countTo.js%' or sel_loca like '%projects/projects/js/counter/jquery.countTo.js%' or sel_dist like '%projects/projects/js/counter/jquery.countTo.js%') ) ORDER BY sno desc Limit 0, 16
