dois valores
coluna_valor:
sql_min: SELECT FROM imovel WHERE imovel_id_imobiliaria = '343' AND rec = '0' AND imovel_excluido = '0' AND imovel_ativo = '1'
sql_max: SELECT FROM imovel WHERE imovel_id_imobiliaria = '343' AND rec = '0' AND imovel_excluido = '0' AND imovel_ativo = '1'
valor_minv: 250000.00
valor_maxv: 3500000.00
valor_minl: 500.00
valor_maxl: 2700.00

venda/locacao

valor_min1: 500.00/valor_min2: 500.00/valor_maxl: 2700.00

SELECT im_valor_locacao FROM imovel WHERE imovel_id_imobiliaria = '343' AND rec = '0' AND imovel_excluido = '0' AND im_locacao = '1' AND im_valor_locacao BETWEEN '500.00' AND '1000'
valor_min1: 500.00/valor_min2: 1000/valor_maxl: 2700.00
tem imóvel no valor entre: 500.00 e 1000
SELECT im_valor_locacao FROM imovel WHERE imovel_id_imobiliaria = '343' AND rec = '0' AND imovel_excluido = '0' AND im_locacao = '1' AND im_valor_locacao BETWEEN '500.00' AND '1000'


SELECT im_valor_locacao FROM imovel WHERE imovel_id_imobiliaria = '343' AND rec = '0' AND imovel_excluido = '0' AND im_locacao = '1' AND im_valor_locacao BETWEEN '1000' AND '2000'
valor_min1: 1000/valor_min2: 2000/valor_maxl: 2700.00
tem imóvel no valor entre: 1000 e 2000
SELECT im_valor_locacao FROM imovel WHERE imovel_id_imobiliaria = '343' AND rec = '0' AND imovel_excluido = '0' AND im_locacao = '1' AND im_valor_locacao BETWEEN '1000' AND '2000'


SELECT im_valor_locacao FROM imovel WHERE imovel_id_imobiliaria = '343' AND rec = '0' AND imovel_excluido = '0' AND im_locacao = '1' AND im_valor_locacao BETWEEN '2000' AND '3000'
valor_min1: 2000/valor_min2: 3000/valor_maxl: 2700.00
tem imóvel no valor entre: 2000 e 3000
SELECT im_valor_locacao FROM imovel WHERE imovel_id_imobiliaria = '343' AND rec = '0' AND imovel_excluido = '0' AND im_locacao = '1' AND im_valor_locacao BETWEEN '2000' AND '3000'

tem imóvel no valor entre: 250000.00 e 450000
SELECT im_valor_venda FROM imovel WHERE imovel_id_imobiliaria = '343' AND rec = '0' AND imovel_excluido = '0' AND im_venda = '1' AND im_valor_venda BETWEEN '250000.00' AND '450000'

tem imóvel no valor entre: 450000 e 650000
SELECT im_valor_venda FROM imovel WHERE imovel_id_imobiliaria = '343' AND rec = '0' AND imovel_excluido = '0' AND im_venda = '1' AND im_valor_venda BETWEEN '450000' AND '650000'

tem imóvel no valor entre: 650000 e 850000
SELECT im_valor_venda FROM imovel WHERE imovel_id_imobiliaria = '343' AND rec = '0' AND imovel_excluido = '0' AND im_venda = '1' AND im_valor_venda BETWEEN '650000' AND '850000'

tem imóvel no valor entre: 850000 e 1050000
SELECT im_valor_venda FROM imovel WHERE imovel_id_imobiliaria = '343' AND rec = '0' AND imovel_excluido = '0' AND im_venda = '1' AND im_valor_venda BETWEEN '850000' AND '1050000'

tem imóvel no valor entre: 1050000 e 3050000
SELECT im_valor_venda FROM imovel WHERE imovel_id_imobiliaria = '343' AND rec = '0' AND imovel_excluido = '0' AND im_venda = '1' AND im_valor_venda BETWEEN '1050000' AND '3050000'

tem imóvel no valor entre: 3050000 e 5050000
SELECT im_valor_venda FROM imovel WHERE imovel_id_imobiliaria = '343' AND rec = '0' AND imovel_excluido = '0' AND im_venda = '1' AND im_valor_venda BETWEEN '3050000' AND '5050000'