Resultado da Busca - Dubai Imóveis

Resultado de Busca

SELECT * FROM timoveis, tcidades, tcategoria1, tcategoria3 where (ImoCadCodigo = '97519') AND ((Cat3DescricaoSingular like convert('%fazenda%' using utf8)) OR (Cat3DescricaoSingular like convert('%todos%' using utf8))) and ((ImoValor >= 0) and (ImoValor <= 1000000000000000) OR (ImoValorLoc >= 0) and (ImoValorLoc <= 1000000000000000)) AND (CidCodigo = ImoCidCodigo) AND (Cat1Codigo = ImoCat1) AND (Cat3Codigo = ImoCat3) and (ImoLiberado = 1 AND ImoSituacao<>'I') ORDER BY CAST(ImoValor AS SIGNED) ASC, CAST(ImoValorLoc AS SIGNED) ASC LIMIT 0, 18

Fazenda à venda, Rural, MANDAGUACU - PR

R$ 20.000.000,00

Zona Rural MANDAGUACU - PR

Ref.: 2001

Páginas