• Ricerca per località
• ALME'
• PALAZZAGO
• ZOGNO

SELECT immobili.id AS idimm, immobili.mi AS migl, immobili.pubblica AS pubbl, immobili.archiviato AS archi, immobili.assistente AS immassist, immobili.categoria AS categoriacod, immobili.via AS viaimm, immobili.numero AS numeroimm, immobili.mq AS mqimm, immobili.prezzo AS prezzoimm, immobili.dataweb AS dataimm, categorie.descrizione AS categoriaimm, localita.localita AS localitaimm, esterni.tipo AS tipoimm, tipoimm.descrizione AS descrizioneimm, utenti.nominativo AS nomeconsul, assist.nominativo AS nomeassist, zone.zona AS zonaimm FROM immobili, zone, localita, tipoimm, esterni, categorie, utenti, utenti AS assist WHERE immobili.localita <> 283 AND (immobili.categoria=1 OR immobili.categoria=2) AND immobili.agenzia=1 AND (immobili.archiviato='No') AND (immobili.pubblica='si') AND (immobili.localita=localita.id) AND (immobili.categoria=categorie.id) AND (immobili.esterni=esterni.id) AND (immobili.tipo=tipoimm.id) AND (immobili.consulente=utenti.login) AND ((immobili.assistente=assist.login) OR (immobili.assistente='Nessuno') AND (assist.login=utenti.login)) AND (zone.id=immobili.zona) ORDER BY immobili.ultimamod DESC

---