function CRIA_QUERY()
{
var sql = "SELECT codigo,referencia,valor,tipodeimovel,cidade,bairro,dormitorio,suites,garagens,areautil,areaterreno,areaconstruida,finalidade,condominio_fechado,divida,tipo,image1,image2,image3,image4,image5,image6,image7,image8,image9,image10,mostradestaque,plantao,oportunidade,video from imoveisnosite where referencia > 0";
	if(document.getElementById('codigo').value!='')
	{
		sql += " and referencia = "+document.getElementById('codigo').value;
	}
	else
	{
//--------------------------------------------------------------------------------------------------------------------------
		
		if(document.getElementById('tp_consulta').value!='')
		{
			if(document.getElementById('tp_consulta').value=='1')
			{		
				sql += " and valor <> 0 ";
			}
			else if (document.getElementById('tp_consulta').value=='2')
			{
				sql +=" and valor <> 0 ";				
			}
		}
		if(document.getElementById('tpimovel').value!='')
		{
			sql += " and tipodeimovel = '"+document.getElementById('tpimovel').value+"'";
		}
//-----------------------------------------------------------------------------------------------------	
		if(document.getElementById('mindorm').value!='0')
		{
			sql += " and dormitorio = "+document.getElementById('mindorm').value;
		}
//--------------------------------------------------------------------------------------------------------------------------
		
		if(document.getElementById('tp_consulta').value =='2')
		{
			if((document.getElementById('valor').value!='') && (document.getElementById('valor').value!='0'))
			{
				sql += " and valor "+document.getElementById('valor').value;
			}
		}
		else
		{
			if((document.getElementById('valor').value!='') && (document.getElementById('valor').value!='0'))
			{
				sql += " and valor "+document.getElementById('valor').value;
			}
		}
		
//-----------------------------------------------------------------------------------------------------	
		if(document.getElementById('bairro').value!='selecione')
		{
			sql += " and bairro = '"+document.getElementById('bairro').value+"'";
		}
	}
 
//-----------------------------------------------------------------------------------------------------	
	sql += " order by valor asc"

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

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