Property Image
Property Image
Property Image
Property Image
Property Image
select code_treb,status,agent_id,system_agent_id,pool_option,source,dom,image_name,listing_id,ml_num,image_available,ad_text,slug,lp_dol,pay_freq,addr,br,br_plus,bath_tot,sqft,tot_area,s_r ,class,community,lp_code,apt_num,disp_addr,latitude,longitude,municipality,lsc from w4rlistings.w4r_listings a where ( ( ( (system_agent_id IN (11111450) OR agent_id IN (9525275) ) OR (code_treb LIKE '2200%') ) AND (status = 1) ) OR ( (system_agent_id IN (11111450) OR agent_id IN (9525275) ) AND (status = 1) ) ) ORDER BY CASE WHEN system_agent_id = '11111450' THEN 1 WHEN agent_id = '9525275' THEN 2 WHEN system_agent_id = '11111450' THEN 3 END DESC limit 0,20