function BUSCA_SITE(){

if (document.getElementById('interesse').value=='')	{
	alert('Você gostaria de comprar ou alugar? Por favor selecione uma opção');
	return false;
	} else {
	
	var sql = "SELECT * FROM imoveissite LEFT JOIN CADzona on imoveissite.zona = CADzona.IDzona where codigo > 0";
	
	//---------------------------------------------------------------------------------	
			if(document.getElementById('interesse').value!='' && document.getElementById('interesse').value!='todos'){
				sql += " and "+document.getElementById('interesse').value+" <> 0 ";
			}
			
		if(document.getElementById('finalidade').value!=''){
				sql += " and tipo = " +document.getElementById('finalidade').value;
			}
	
	//---------------------------------------------------------------------------------	
			if(document.getElementById('tipodeimovel').value!=''){
				sql += " and tpimovel = '" +document.getElementById('tipodeimovel').value+ "'";
			}
	
	//--------------------------------------------------------------------------------------------------------------------------		
		if(document.getElementById('dorms').value!='0'){
				sql += " and dormitorio = " +document.getElementById('dorms').value;
			}		
	//--------------------------------------------------------------------------------------------------------------------------
	
		if(document.getElementById('vagas').value!='0'){
				sql += " and garagens = " +document.getElementById('vagas').value;
			}		
	//--------------------------------------------------------------------------------------------------------------------------	
		if(document.getElementById('tpzona').value!=''){
				sql += " and cadZona.IDzona = " +document.getElementById('tpzona').value;
			}
	//-----------------------------------------------------------------------------------------------------	
		if(document.getElementById('bairro').value!='')
		{
			sql += " and bairro = '"+document.getElementById('bairro').value+"'";
		}
	//--------------------------------------------------------------------------------------------------------------------------
	
			if(document.getElementById('interesse').value =='locacao'){
				if((document.getElementById('valor1').value!='') && (document.getElementById('valor1').value!='0')){
					sql += " and locacao "+document.getElementById('valor1').value;
				}
			}else if(document.getElementById('interesse').value =='venda'){
				if((document.getElementById('valor').value!='') && (document.getElementById('valor').value!='0')){
					sql += " and venda "+document.getElementById('valor').value;
				}
			}
	//-----------------------------------------------------------------------------------------------------	
			if(document.getElementById('fotosBusca').value=='ComFoto')
			{
				sql += " and image1 is not null"
			}
		else if(document.getElementById('fotosBusca').value=='SemFoto')
			{
				sql += " and image1 is null"
			}
			
	//-----------------------------------------------------------------------------------------------------		
		if(document.getElementById('interesse').value!=''){
			sql += " order by "+document.getElementById('interesse').value+" asc"
		}else{
			sql += " order by venda asc"
		}
		//--------------------------------------------------------------------------------------------------------------------------
		
		

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