SELECT ID,code,source,vendrelouer,SUSP,prix,cacherprix,commune,chambre,chambresup,garage,garagesup,titre,titrenl,typelib,datecrea,photo1,`peb`,nouveaute,IDresidence,video,`360` FROM 056_biens WHERE prix >='25000' AND prix <='10000000' AND (vendrelouer='V' OR vendrelouer='P') AND IDresidence='' AND source='747' ORDER BY prix LIMIT 0, 12
