RIFF"WEBPVP8 Е�* �>�T�M'��%�u|�� gk�ZaQb�����o����lN���s�_�3��S+���c�€R��y����//����~��H�@�2oF�X ���R@'�:�ꞓ}��a�M,.� ��o��=�p�U�&g<�:���~���t��.�1���cyW�� We�M=�f�Y6v�����(nO���������^- �9(b _�s%{�C|�p�@�����37�}B0��u���i�Գ���� ������5�}���֮M?dz���q�e��N�~�&�N��K�av$]hO�i�C�,��"]�����@����M@�o O[�Æ*;�e]��_; }�p�?��)�'VC� J��L�y� v����18��)7c�d�mߛ�]I� ����d��?�{�.����b)49��c��Zy/��c^��%��/z�å̯�t��rS��Z��Uͩ�h��2����` �7�:��~��zP���Z����?v�R��TD���G����CJ���}�o��fs��̜#b��e"k9,���3�{Or�i��x":���{/ۈ�`�7RČ����(�p:I��%:�ͺ��W(|�=KP��3�7}���������ed��;�3�;�e��8�g�4�9 %v,B�GU�����T% ֯��B+�tR���p������F7�sT��oϱq �h�Rݧ�~*�܈_�Ck���}�nY�>��C�PQ�B��(o�६�qxy������f ���]��}����%=CW�k^t�—]����M�cX�i��%��!�Y������:N=|��wj<9ł��,�s�O�,,�U�!�������e���{���W��989�y*z�=�"E�CyW���N�2�ę��LN�HW��?����`V���DJ=#׶×ܽ$eF���o;b� ��0��&�W���Y�bR�� �Fֵ� `J�an�-Є@�tR�v��e2W��Mn�p��4P1�q ���®w���ũur*�җ.�#�4b���������:���g��ʧ�`R�4�+G�f���niU����$�K-'A�zE&]��Y�H2�4� ��˄�t��Q�4%��L�#��0FS8�Bu����ژ��"����۹�[�JK��4��z�v�ڌ��L*jD0.����?�ڃN��H��J����n�w��6Q(i;��I,.3?|�`���y���D_��(��w��������[��ZYhe�')��D*��kb����c��@� �|S�S3���- ���iq!*��w������Ł��ܩ��*FY���jV�4Q���4�,�ʑV!��N�.�1�KT,��Zp� ���iL�r��Ȧ����"y�tU���PS�ģ��?�QGng_�#yEk��B̝��1hr��ѕ�z*Ԧ�L8T�����H�^�k�-�g�z������w��N����v��RH��E��!0Cؚ)R�@�q�J�qA�r�$k4���om���Ьnu���x�������������y$�8�Z���v� &�+2�|���\r:[,!�Y�C#c��͊�{��7Щ��Y�LVę]�j��)��^���󶦙$�_����Hx>����[ +K�ڏ�1������Q�7@�^{�ik�;'H{�8 �ȇe vR����^� Meq�����Y�MC��U<��O�۫�nAfBf317���x��O�.u@3R}e�`�D��\�z���L��P������y8�?����I�"s`�b 3��ٹd�0��A�/���� ��{b�b������1� ����ka�&T�z�_4���I��PN��8��}N�r��]�՜���ӿ��9�|/.��� �fˑ.�`r�r��U-���7�Rx8L��d$H�m��Ǒ�*x�P{�D�����k��o�ueV�-.��j}���U2��g絍g���s �������aN�X�ҍ���C�� ��X��B�EF���8%p57<�x�Y�e�cϔ�\��C �OAj&N�V���!v��U��~J��j��4�V|��8�R�v�fD�)�HA�3�G��ds�7Z.���= ����+kI2�0=�'� K �H,`�ɴāTE\����E�'/��;���;��a���0"��� �x$J�T��#U=������j-�8�����y c8W����Ԋ�K��_��Y� '%Vg$I�Пq�shE�y�:�m�}�F1(:b�U�~� ���0}�C�}0����#�#}���e�S9��.��SP�m���<�~�y��� ��ɭ�ٮ6N��� ğ��t��A��N�V ������f�+�w�O1�Jq���U�B�T��į���� ��*�=z�x"yU S���� ��// ����W᫮��R�O�2W�M��<-�;�F�`9 �����t�:C{a�8�� <�r'���:�g8%�9J̞�˦��eV�7l�~�#����.yY)$��k�|�!�3���m���XS���J4B���`�����oL[]��aT[�C��@h�T�l��_�e>�����K<'��P�zgk�#fm��V�]�ݽ�j1����H��J��J58��ڱ��@�e&*�w��e���Q��HT8�ֽ��\�Fa�栆�A�ڝӚ׹@�:9`��G�h�7����t<���_˒|�\bU�O�����,M�a�oynGf�޶7�w�i`�m[��XE4�*�8}5��U1���^�B*��_%[����Yb�^���S�l�"A�1�T��ڈ��(???)j�S�n�8v%� Eo��� mE��|�Έ�Ai�3uy5O����7Rܽ���"L��X���1�@�=?5�_'��{j�����Z3L��k��^x6g3i�����r.��N��&��9[��ɓW[+�� 7�����fe�3�K�%��0F��+V�ϛ+3�B�p,y;Z�NGK�uWg䁯9�v��t��ǒx�JY�O��K�iY��#FJy�Bzt�Q^�Y��Uϲ-͖��9��g�X,�X] f�P/�]d�䠾�̔m%Q��겓\q(�%'����/EN�P�1�o��� ���}��'��c�F��Ju��4��0ck�N��w�1��&]a ��^I�)����֓��\;�1��3��� �L��{>�+���a��Jg��#����P���>�5�a<�`>>˔�]�ߎey�-T���ʵ���r���8`dmNm���_mӐK�Ҏ-޴�� ��RQ%�d�l"��l�_��ie0.�$Xh|.jv,���l\ uyj�u\�/� B:�܀�]� _��T��I���lz�&c�A�g{g��O˂�O���O�M�t��7Y�~? ቶ`�7��'�w��#���˚�\��_��� a��d���[Ҭњ��]ɢ�A$ �l�v=E�66d �WA\̬fsǭ}x;';���?�UW�O��{�&|_a�C� |ȹ��pka�|���zf[S�������[�Jcf�A�&�L�U)Pd+)�_�$1�0�z�'�v\u�' +;�!���dž�]h�N�{ku��<��a��.0�,��]q��ZKao=ILo�z�rb&�{@K�i*7nX).�/�̶��ӒU�v �B֝���a��n��تx ���P�AG7M4N�?r;Z�����7�@�wA�q��RM5�8ۭ ��g��8�g���G�Tſ�O�{2��P3r��6�W,/��kC���p�V���~�"���T���6�/<�4�U�>��T�H�Fc�T�D�^I���!�����=&\Em�>b�,|T��d���n��=@\Wzi���D��&�f���1�t�mC�Ih��m��&�������84�!H�i�|�Z���� ��W���g����8�h�B] OvQ�u����+�}n�� FE�+q�&j����I�u��&��=!��T�b�@�ք0 �D�W�W�t�V}�������^�g�Erb`j��2 �wr�\Y5��L�Ρ���_�bNU�)~�e�Z�U�*�����:�vƀu2�W-W��W{KKo0�)��G�K.��{̮���v�/��p� !�� �w;`��b ������F���/���:����I�lm��Vc�,x~m<=|�_�>n����(A�����{�膾���m�,{3 �ӀH=٘�%��[USd��!J�|�f_�/ �߻��)I%���G�ܑ�G |N������d��BU5��qvG�c,���A?!��w��� �S��-i���Fr�P�_��E�+��)��V��f��������~�����������}"sk��cHN�<� 5I�r��1gu�ݗ�,N�I��f��k�s���0��: 0�<�\ͩB�܄ �:�f2A��mҞ�Z�6��3��t�����͟~����J�R9�] �,h������Z�@�{����9��W�il!�:��P��P���wK)���p���!���KuB\�7 uI�?(���/��r3����v,\'�8��qUa�ء���!��(b��n?�YfӸ����r�$���ה�~��_�&�8g�<(Mx$ZO�������u`q��:�N�Q !�%`���h:�� �~>�D���m�^��[V!y�6=� ��m��ѡ��p4�Iꎸ��1cE��QS�ٷ��W�C����*�����Q��=��3���&���-#,åCCG�������9�i��3�C��S[t>���qm����B��s���������o��� J�^s|����r��\ԺΦ�a�{��1��wT'���� �̓Q���B��\xx}��8��Of!��U�n��f�����bA��UD�cC} �r�������c ���^�X���k�Ɩk�6��^E�C�E�sՀ`�Ⱦ,i��v�� ٺe˟�!�co�64x4��A�ah��ˏ<��%�@�*|�\�TY����#:9��|?S�[������G hUw9���z]��D��-J6�m,ʭ��2�Iz�4W9��&���t�߁ R�Z�gP��H�dj�`%ap}�^떟��*fb{�Q) Dd_V����$��,�߁� @D�&f�2��S6��M�ɤ�)Q\F�i���5p��Wb'PN�R�>�����9��]��\8{B8�� ��ю�������%� ӏۙ{]�j,_Y>��!�l���'���H�["��;c?cy��1< 0ϑ���/�AAЛ�� ; �j�(!��1 [)5ݻK ��A7��"[�%"���{��H ���V�� ���m�K���VLn��9鿹8�At΀@����f`�1y�rЅ��q��7Nf���x)y��, 0e�"{�ƨ�"� o �6� �.|Tm.���-r �G� [ed���–q���]�X�oG*�1>�� م�p_Y{δ(N�|s��^{i�`��͒ QӴx+X.ݕ�kP�g]�޿�4��Q|�O��h�*c�W�G�4{~x�k��A:�{Yu�倀#ތM�K!�e�;ȩ����r������'���D&H�$�0�ߜ�w��Sq dH��P�y����z����h��d��"�;0��#I2�F{����. W�wl���|>s�\ŌO�&bO/4(z9ܭua��`��_3d�Qpt�/�P -��#5�,�M��� �pA:©�q�����NW��ډ�A���� �9nʺج���� �TSM��{J6?7��r�@�\����D��� �׶���s�f�TJj?"��D��`?��̒� b�#�%�C*v�$�{�$����5Ծ�F�s��y�e/8��h-�f�̰&(����Gj�L:U� 2�� ����v�_k����Y��gp,�k�WF�R������_C�R��N@���R�@�ߔ?A�w9���F("iNa-S���Q�o�3tDMLh*�#4k�T/iQ��Y*�G��m����)��8�hBm/�I�,g�ﯖ���Z��}�Cz�q@´��d.����L�ŕ�,��1�Z�܌�: ̪���F+J-'��c�tvJ8��]Q-��b��y �6;*J`r_�d ��'�G ~p��)'�C,�%F��E(��2�k�����lР�z�!�=t ��_�0��f7��� ;�p�|�U �% 17 elementi $sel_camere = array_fill(0, 6, ""); // dim sel_camere(5) $sel_bagni = array_fill(0, 5, ""); // dim sel_bagni(4) $sel_prezzo = array_fill(0, 8, ""); // dim sel_prezzo(7) // Condizione base per la WHERE $stringa = " archivio = 0 AND cancellato = 0 AND venduto = 0 AND (avviso = 1 OR avviso IS NULL) AND disattivo = 0 AND annuncio = 2"; // ----------------------------------------------------------------------------- // FILTRO ISOLA / COMUNE // ----------------------------------------------------------------------------- $isola = isset($_POST['isola']) ? (int)$_POST['isola'] : 0; if ($isola > 0) { $sel_isola[$isola - 1] = 'selected="selected"'; $stringa_isola = ""; switch ($isola) { case 1: $stringa_isola = "ucase(isola) = 'ALICUDI'"; $sRicerca .= " - Isola = Alicudi"; break; case 2: $stringa_isola = "ucase(isola) = 'FILICUDI'"; $sRicerca .= " - Isola = Filicudi"; break; case 3: $stringa_isola = "ucase(isola) = 'LIPARI'"; $sRicerca .= " - Isola = Lipari"; break; case 4: $stringa_isola = "ucase(isola) = 'PANAREA'"; $sRicerca .= " - Isola = Panarea"; break; case 5: $stringa_isola = "ucase(isola) = 'SALINA'"; $sRicerca .= " - Isola = Salina"; break; case 6: $stringa_isola = "ucase(isola) = 'STROMBOLI'"; $sRicerca .= " - Isola = Stromboli"; break; case 7: $stringa_isola = "ucase(isola) = 'VULCANO'"; $sRicerca .= " - Isola = Vulcano"; break; case 8: $stringa_isola = "ucase(comune) = 'GIARDINI NAXOS'"; $sRicerca .= " - Comune = Giardini Naxos"; break; case 18: $stringa_isola = "ucase(comune) = 'BARCELLONA POZZO DI GOTTO'"; $sRicerca .= " - Comune = Barcellona Pozzo di Gotto"; break; case 9: $stringa_isola = "ucase(comune) = 'TAORMINA'"; $sRicerca .= " - Comune = Taormina"; break; case 10: $stringa_isola = "ucase(comune) = 'PORTO CERVO'"; $sRicerca .= " - Comune = Porto Cervo"; break; case 11: $stringa_isola = "ucase(comune) = 'MILANO'"; $sRicerca .= " - Comune = Milano"; break; case 12: $stringa_isola = "ucase(comune) = 'MILAZZO'"; $sRicerca .= " - Comune = Milazzo"; break; case 13: $stringa_isola = "ucase(comune) = 'SIRACUSA'"; $sRicerca .= " - Comune = Siracusa"; break; case 14: $stringa_isola = "ucase(comune) = 'MESSINA'"; $sRicerca .= " - Comune = Messina"; break; case 15: $stringa_isola = "ucase(comune) = 'NOTO'"; $sRicerca .= " - Comune = Noto"; break; case 16: $stringa_isola = "ucase(comune) = 'ROCCALUMERA'"; $sRicerca .= " - Comune = Roccalumera"; break; case 17: $stringa_isola = "ucase(comune) = 'ITALA'"; $sRicerca .= " - Comune = Itala"; break; } if (!empty($stringa_isola)) { $stringa .= " and " . $stringa_isola; } } // ----------------------------------------------------------------------------- // FILTRO tipologia // ----------------------------------------------------------------------------- $labelTipologia = [ "Re" => "Residenziale", "Co" => "Commerciale" ]; $tipologia = isset($_POST['tipologia']) ? $_POST['tipologia'] : 0; if ($tipologia !== "0") { // Ottieni il testo corrispondente $tipologiaLabel = isset($labelTipologia[$tipologia]) ? $labelTipologia[$tipologia] : $tipologia; $stringa .= " AND Categoria = '" . $tipologia . "'"; $sRicerca .= "; Categoria = '" . $tipologiaLabel . "'"; $sel_tipologia[$tipologia] = "selected='selected'"; } // ----------------------------------------------------------------------------- // FILTRO CAMERE / VANI // ----------------------------------------------------------------------------- $camere = isset($_POST['camere']) ? (int)$_POST['camere'] : 0; if ($camere > 0) { if ($camere == 6) { $stringa .= " and NrLocali = '>5'"; $sRicerca .= "; Nr. Locali = >5"; } else { $stringa .= " and NrLocali = '" . $camere . "'"; $sRicerca .= "; Nr. Locali = " . $camere; } $sel_camere[$camere - 1] = "selected='selected'"; } // ----------------------------------------------------------------------------- // FILTRO NUMERO BAGNI // ----------------------------------------------------------------------------- $bagni = isset($_POST['bagni']) ? (int)$_POST['bagni'] : 0; if ($bagni > 0) { switch ($bagni) { case 1: $stringa .= " and (Bagni='' or Bagni=' ' or Bagni = '1' or Bagni = '2' or Bagni ='3' or Bagni='>3')"; $sRicerca .= "; Nr. Bagni = 1 o più"; break; case 2: $stringa .= " and (Bagni = '2' or Bagni ='3' or Bagni='>3')"; $sRicerca .= "; Nr. Bagni = 2 o più"; break; case 3: $stringa .= " and (Bagni ='3' or Bagni='>3')"; $sRicerca .= "; Nr. Bagni = 3 o più"; break; case 4: $stringa .= " and Bagni = '>3'"; $sRicerca .= "; Nr. Bagni = più di 3"; break; } $sel_bagni[$bagni - 1] = "selected='selected'"; } // ----------------------------------------------------------------------------- // FILTRO PREZZO (FASCIA) // ----------------------------------------------------------------------------- $prezzo = isset($_POST['search_maxprice']) ? (int)$_POST['search_maxprice'] : 0; if ($prezzo > 0) { switch ($prezzo) { case 1: $stringa .= " and CodFascia <= " . $prezzo; $sRicerca .= "; Fascia di Prezzo = 0 - 100.000,00 €"; break; case 2: $stringa .= " and CodFascia <= " . $prezzo; $sRicerca .= "; Fascia di Prezzo = 0 - 150.000,00 €"; break; case 3: $stringa .= " and CodFascia <= " . $prezzo; $sRicerca .= "; Fascia di Prezzo = 0 - 200.000,00 €"; break; case 4: $stringa .= " and CodFascia <= " . $prezzo; $sRicerca .= "; Fascia di Prezzo = 0 - 300.000,00 €"; break; case 5: $stringa .= " and CodFascia <= " . $prezzo; $sRicerca .= "; Fascia di Prezzo = 0 - 500.000,00 €"; break; case 6: $stringa .= " and CodFascia = " . $prezzo; $sRicerca .= "; Fascia di Prezzo = oltre 500.000,00 €"; break; case 7: $stringa .= " and CodFascia = " . $prezzo; $sRicerca .= "; Fascia di Prezzo = Trattative Riservate"; break; } $sel_prezzo[$prezzo - 1] = "selected='selected'"; } // ----------------------------------------------------------------------------- // ORDINAMENTO E QUERY DI RICERCA // ----------------------------------------------------------------------------- $ordine = " order by posizione asc"; $rSQLRic = "SELECT COUNT(*) AS totale FROM annuncio WHERE" . $stringa . $ordine; $rSQLAnn = "SELECT * FROM annuncio WHERE" . $stringa . $ordine; $iRisu = 0; $iRisu = $config->conta_annuncio_sql($rSQLRic); ?> Lipari Case vacanze, vendita case, vendita immobili, case affitto, case Lipari, case Vulcano, case Panarea, case Stromboli, case Filicudi, case Alicudi, case Salina, case vendita ville

Affitti: ricerca annunci

L'Agenzia immobiliare EolieSolution, vende case, appartamenti e ville alle Isole Eolie.

0) { ?> ()
Annulla Filtri Nessun Annuncio Trovato per questa selezione

annuncio_isola_sql($rSQLAnn); ?>