SELECT  propriete.*, prix.*,agence.nom,propriete.proprieteid as id
                FROM    propriete
                  LEFT JOIN prix
                  ON propriete.prixid = prix.prixid
                  LEFT JOIN agence
                  ON propriete.agenceid = agence.agenceid
                WHERE   0=0 AND propriete.pieces >= 1 AND propriete.surface_valeur >= 10 AND propriete.surface_valeur <= 2000   AND prix.valeur >= 1000 AND prix.valeur <= 10000000  AND propriete.agentid = achat-vente-bien-immobilier-maison-appartement-rouen-76
                ORDER BY propriete.ville ASC