function BUSCA_RAPIDA() {
    var sql = "SELECT a.codigo,a.destaques,b.Zona FROM imoveissite a INNER JOIN CADunidade c on (a.codigo=c.IDunidade) INNER JOIN CADZONA b on (b.IDZona=c.IDzona) where a.codigo > 0";

    if (document.getElementById('tp_consulta').value != '' && document.getElementById('tp_consulta').value != 'selecione' && document.getElementById('tp_consulta').value != 'todos') {
        sql += " and " + document.getElementById('tp_consulta').value + " = 0 ";
    }
    else if (document.getElementById('tp_consulta').value == 'todos') {
        sql += " and venda <> 0 and locacao <> 0 ";
    }
    //--------------------------------------------------------------------------------------------------		
    if (document.getElementById('tipodeimovel').value != 'selecione') {
        sql += " and tpimovel = '" + document.getElementById('tipodeimovel').value + "'";
    }
    //-----------------------------------------------------------------------------------------------------	
    if (document.getElementById('zona').value != 'selecione') {
        sql += " and b.Zona = '" + document.getElementById('zona').value + "'";
    }
   //--------------------------------------------------------------------------------------------------------------------------

    if (document.getElementById('tp_consulta').value == 'locacao') {
        if ((document.getElementById('valor').value != '') && (document.getElementById('valor').value != '0')) {
            sql += " and locacao " + document.getElementById('valor').value;
        }
    } else if (document.getElementById('tp_consulta').value == 'venda') {
        if ((document.getElementById('valor').value != '') && (document.getElementById('valor').value != '0')) {
            sql += " and venda " + document.getElementById('valor').value;
        }
    } else if (document.getElementById('tp_consulta').value == 'todos') {
        if ((document.getElementById('valor').value != '') && (document.getElementById('valor').value != '0')) {
            sql += " and venda " + document.getElementById('valor').value + " AND locacao " + document.getElementById('valor').value;
        }
    }
    //-----------------------------------------------------------------------------------------------------	
    if (document.getElementById('tp_consulta').value != 'selecione') {
        sql += " order by codigo asc"
    }
    else {
        sql += " order by codigo desc"
    }

    //-----------------------------------------------------------------------------------------------------	

    document.getElementById('SQL').innerHTML = sql
    document.busca.submit();

}