function BUSCA_RAPIDA(){
var sql = "SELECT a.codigo,a.bairro,a.distribuicao,a.codigo,a.suites,a.dormitorio,a.garagens,a.venda,a.locacao,a.areautil,a.condominio, b.NomeCidade, b.NomeUf, c.Zona from imoveissite a INNER JOIN CADUnidade b on (a.codigo = b.IDunidade) LEFT JOIN CADzona c ON (b.IDzona = c.IDzona) where a.codigo > 0 and b.Bolsite = 1";
	
		if(document.getElementById('tp_consulta').value!='' && document.getElementById('tp_consulta').value!='')
		{
			sql += " and a."+document.getElementById('tp_consulta').value+" <> 0 ";
		}
//--------------------------------------------------------------------------------------------------		
		if(document.getElementById('tipodeimovel').value!='')
		{
			sql += " and a.tpimovel = '" +document.getElementById('tipodeimovel').value+ "'";
		}
//-----------------------------------------------------------------------------------------------------	
		
		if(document.getElementById('bairro').value!='')
		{
			sql += " and a.bairro = '"+document.getElementById('bairro').value+"'";
		}
	
//-----------------------------------------------------------------------------------------------------	
		if(document.getElementById('Zona').value!='')
		{
			sql += " and c.zona = "+document.getElementById('Zona').value;
		}
//--------------------------------------------------------------------------------------------------------------------------
		if(document.getElementById('mindorm').value!='')
		{
			sql += " and a.dormitorio = "+document.getElementById('mindorm').value;
		}
//--------------------------------------------------------------------------------------------------------------------------
	
		if(document.getElementById('tp_consulta').value =='locacao')
		{
			if((document.getElementById('valor').value!='') && (document.getElementById('valor').value!='0'))
			{
				sql += " and a.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 a.venda "+document.getElementById('valor').value;
			}
		}
		
//-----------------------------------------------------------------------------------------------------	
	if(document.getElementById('tp_consulta').value!='')
	{
		sql += " order by a."+document.getElementById('tp_consulta').value+" asc"
	}
	else if(document.getElementById('tp_consulta').value=='todos')
	{
		sql += " order by a.venda,a.locacao asc"
	}
	else{
		sql += " order by a.venda asc"
	}
	
//-----------------------------------------------------------------------------------------------------	

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

}