function BUSCA_RAPIDA()
{
var sql = "SELECT a.bairro,a.venda,a.locacao,a.areautil,a.destaques,a.dormitorio,a.suites,a.condominio,a.garagens,a.codigo,b.Imediacoes,b.NomeCidade,b.NomeUF,b.IDtipoImovel,a.areaconstruida,a.areaterreno,a.banheiro,a.areatotal,a.image1 FROM imoveissite a INNER JOIN CADUnidade b on (a.codigo=b.IDunidade) where b.Bolsite = 1 AND a.codigo > 0";

//--------------------------------------------------------------------------------------------------------------------------
		if(document.getElementById('tp_consulta').value!='' && document.getElementById('tp_consulta').value!='todos')
		{
			sql += " and "+document.getElementById('tp_consulta').value+" <> 0 ";
		}
//--------------------------------------------------------------------------------------------------		
		if(document.getElementById('tipodeimovel').value!='')
		{
			sql += " and tpimovel = '" +document.getElementById('tipodeimovel').value+ "'";
		}
//-----------------------------------------------------------------------------------------------------	
		if(document.getElementById('bairro').value!='selecione')
		{
			sql += " and bairro = '"+document.getElementById('bairro').value+"'";
		}		
//-----------------------------------------------------------------------------------------------------		
	
		if(document.getElementById('mindorm').value!='0')
		{
			sql += " and dormitorio = "+document.getElementById('mindorm').value;
		}
//--------------------------------------------------------------------------------------------------------------------------

		if(document.getElementById('mingar').value!='0')
		{
			sql += " and garagens = "+document.getElementById('mingar').value;
		}
//--------------------------------------------------------------------------------------------------------------------------		
		if(document.getElementById('fotos').value=='1')
		{
			sql += " and image1 is not NULL"
		}
		else if(document.getElementById('fotos').value=='2')
		{
			sql += " and image1 is NULL"
		}
//--------------------------------------------------------------------------------------------------------------------------
		
		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;
			}
		}
//-----------------------------------------------------------------------------------------------------	
	if(document.getElementById('tp_consulta').value!='todos')
	{
		sql += " order by a.codigo desc"
	}
	else{
		sql += " order by a.codigo desc"
	}
	
//-----------------------------------------------------------------------------------------------------	

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

}