<!-- domain name: www.pianeta-casa.net-->
<!-- test: SELECT
   properties_istances.MUIS_________ID,
   properties_istances.status,
   properties.MUNI_________ID,
   properties_istances.value,
   properties_istances.estimation,
   properties.notes,
   properties_istances.quotation,
   properties_istances.acquisition_date,
	properties_istances.expiration_date,
	properties_istances.sources,
	properties_istances.active,
	properties_istances.margin,
	properties_istances.period,
	properties_istances.exclusive,
	properties_istances.occupied,
	properties_istances.duration,
	properties_istances.reason,
	properties_istances.reasons,
	properties_istances.sold_by,
	'',
	'',
	'',
	'',
	'',
	properties.number,
	properties.sub_number,
	properties.zone_name,
	properties.zone_id,
	xrem_vuoto.municipality.codice_comune,
	xrem_vuoto.municipality.nome_comune,		
   	properties.state,   
	properties.street_type,
	properties.address,
	properties.type,
	properties.sub_type,
	properties.category,
	properties.rooms,
	properties.squaremeters,
	properties.commercial_squaremeters,
	properties.floor,
	properties.floor_type,
	properties.energy_efficiency,
	properties.ipe,
	properties.description,
	properties.year_built,
	properties.year_restructured,
	properties.notes,
	properties.geolocation,
	properties_istances.update_date,
	media.file_name,
	media.file_type,
	properties_istances.reference,
	properties_istances.private_negotiation,
	properties.agency_id,
	properties.communityExpenses,
	properties.elevator	
FROM
   properties INNER JOIN properties_istances 
ON properties.MUNI_________ID = properties_istances.MUNI_________ID
   INNER JOIN xrem_vuoto.municipality 
ON properties.city = xrem_vuoto.municipality.codice_comune 
   AND properties.state = xrem_vuoto.municipality.codice_provincia 
INNER JOIN media ON properties.MUNI_________ID = media.MUNI_________ID 
   WHERE properties_istances.`active`= 1 AND media.default_rec = 1 AND properties_istances.`status`= 'incarico' AND properties_istances.`is_current_status` = 'Y'  AND (properties_istances.value >= 0) ORDER BY properties_istances.reason DESC, properties_istances.update_date DESC LIMIT 0,8-->

<!-- test1: 
		SELECT	
			COUNT(properties_istances.MUIS_________ID)
		 FROM
   properties INNER JOIN properties_istances 
ON properties.MUNI_________ID = properties_istances.MUNI_________ID
   INNER JOIN xrem_vuoto.municipality 
ON properties.city = xrem_vuoto.municipality.codice_comune 
   AND properties.state = xrem_vuoto.municipality.codice_provincia 
INNER JOIN media ON properties.MUNI_________ID = media.MUNI_________ID 
   WHERE properties_istances.`active`= 1 AND media.default_rec = 1 
   AND properties_istances.`status`= 'incarico' 
   AND properties_istances.`is_current_status` = 'Y' AND (properties_istances.value >= 0) ORDER BY properties_istances.reason DESC, properties_istances.update_date DESC-->

	<!-- test2: SELECT
   properties_istances.MUIS_________ID,
   properties_istances.status,
   properties.MUNI_________ID,
   properties_istances.value,
   properties_istances.estimation,
   properties.notes,
   properties_istances.quotation,
   properties_istances.acquisition_date,
	properties_istances.expiration_date,
	properties_istances.sources,
	properties_istances.active,
	properties_istances.margin,
	properties_istances.period,
	properties_istances.exclusive,
	properties_istances.occupied,
	properties_istances.duration,
	properties_istances.reason,
	properties_istances.reasons,
	properties_istances.sold_by,
	'',
	'',
	'',
	'',
	'',
	properties.number,
	properties.sub_number,
	properties.zone_name,
	properties.zone_id,
	xrem_vuoto.municipality.codice_comune,
	xrem_vuoto.municipality.nome_comune,		
   	properties.state,   
	properties.street_type,
	properties.address,
	properties.type,
	properties.sub_type,
	properties.category,
	properties.rooms,
	properties.squaremeters,
	properties.commercial_squaremeters,
	properties.floor,
	properties.floor_type,
	properties.energy_efficiency,
	properties.ipe,
	properties.description,
	properties.year_built,
	properties.year_restructured,
	properties.notes,
	properties.geolocation,
	properties_istances.update_date,
	media.file_name,
	media.file_type,
	properties_istances.reference,
	properties_istances.private_negotiation,
	properties.agency_id,
	properties.communityExpenses,
	properties.elevator	
FROM
   properties INNER JOIN properties_istances 
ON properties.MUNI_________ID = properties_istances.MUNI_________ID
   INNER JOIN xrem_vuoto.municipality 
ON properties.city = xrem_vuoto.municipality.codice_comune 
   AND properties.state = xrem_vuoto.municipality.codice_provincia 
INNER JOIN media ON properties.MUNI_________ID = media.MUNI_________ID 
   WHERE properties_istances.`active`= 1 AND media.default_rec = 1 AND properties_istances.`status`= 'incarico' AND properties_istances.`is_current_status` = 'Y'  AND (properties_istances.value >= 0) ORDER BY properties_istances.reason DESC, properties_istances.update_date DESC LIMIT 0,8-->
	
			<!-- prezzo_visualizzato: 0 -->
			
			<!-- prezzo_visualizzato: 0 -->
			
		<!-- provincia sql:SELECT DISTINCT(state), 
							xrem_vuoto.municipality.nome_provincia FROM properties 
							LEFT OUTER JOIN xrem_vuoto.municipality ON properties.state = xrem_vuoto.municipality.codice_provincia WHERE xrem_vuoto.municipality.nome_provincia != ''-->﻿<!DOCTYPE html>
<html lang="it">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="icon" href="../_common/www.pianeta-casa.net/images/favicon.ico" />
<title>Pianeta Casa - immobili in vendita e affitto - Rozzano</title>
<link href="../_common/www.pianeta-casa.net/css/main.css" rel="stylesheet" type="text/css">
<link rel="stylesheet" href="../_common/www.pianeta-casa.net/css/menu.css" />
<script src="../_common/www.pianeta-casa.net/javascript/jquery.min.js"></script>
<script src="../_common/www.pianeta-casa.net/javascript/doubletaptogo.js"></script>

<!-- Gallery -->
<!-- jQuery library (served from Google) -->
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script>
<!-- bxSlider Javascript file -->
<script src="../_common/www.pianeta-casa.net/javascript/jquery.bxslider.min.js"></script>
<!-- bxSlider CSS file -->
<link href="../_common/www.pianeta-casa.net/css/jquery.bxslider.css" rel="stylesheet" />
<!-- fine Gallery -->

      <script>

           <!-- SCRIPT GESTIONE FORM RICERCA -->	
         function aggiornaComuni(provincia){ 
         	var comuniArray = new Array("Casarile","Rozzano");
         	var CodComuniArray = new Array("055","189");
         	var elencoProvincie = new Array("015","015");
         	var counter = 1;
         	var elSel = document.getElementById("comune");
         	var i;
         	var select_true = "";
         	for (i = elSel.length - 1; i>=1; i--) { 
         		elSel.remove(i);
         	}
         
         		for (x=0; x<comuniArray.length; x++)
         	{ 
         		if (elencoProvincie[x] == provincia && comuniArray[x] != ""){ 
         			if (comuniArray[x] == ""){
         				select_true = "true";
         			}
         			document.getElementById("comune").options[counter]=new Option(comuniArray[x],CodComuniArray[x],false);
         			document.getElementById("comune").options[counter].selected= select_true;
         			var codice_comune = CodComuniArray[x];
         			document.getElementById("comune").options[counter].setAttribute("cod_comuni",codice_comune);
         			select_true = "";
         			counter = counter + 1;
         		}
         	}
         }
         
         
            function aggiornaZone(codice_comune){			
                
            }
         
            function aggiornaTipo(tipo){ 
                if(tipo=="Re"){		
					document.getElementById("residenziale").checked = true;			
                    var resArray = new Array("Appartamenti","Box-posti-auto","Casa-affiancata","Casa-indipendente","Casa-semi-indipendente","Casa-vacanze","Rustici-cascine-case","Stanza","Terreni","Villa");
                    var lunghezzaArray = resArray.length; 
                    var counter = 1;
                    var elSel = document.getElementById("tipo_immobile");
                    var select_true = "";
                    var i;
                    for (i = elSel.length - 1; i>=1; i--) { 
                        elSel.remove(i);
                    }
            
                        for (x=0; x<lunghezzaArray; x++)
                    { 
                            if (resArray[x] == ""){
                            select_true = "true";
                            }
                            document.getElementById("tipo_immobile").options[counter]=new Option(resArray[x],resArray[x],false);
                            document.getElementById("tipo_immobile").options[counter].selected= select_true;
                            select_true = "";
                            counter = counter + 1;
                    }
                }else if(tipo=="Co"){
					document.getElementById("commerciale").checked = true;
                    var comArray = new Array("Capannoni","Complessi-commerciali","Complessi-industriali","Laboratorio","Magazzino","Negozio","Ufficio");
                    var lunghezzaArray = comArray.length;
                    var counter = 1;
                    var elSel = document.getElementById("tipo_immobile");
                    var select_true = "";
                    var i;
                    for (i = elSel.length - 1; i>=1; i--) { 
                        elSel.remove(i);
                    }
            
                        for (x=0; x<lunghezzaArray; x++)
                    { 
                            if (comArray[x] == ""){
                            select_true = "true";
                            }
                            document.getElementById("tipo_immobile").options[counter]=new Option(comArray[x],comArray[x],false);
                            document.getElementById("tipo_immobile").options[counter].selected= select_true;
                            select_true = "";
                            counter = counter + 1;
                    }
                }else if(tipo=="Pr"){
					document.getElementById("prestigio").checked = true;
                    var selectobject = document.getElementById("tipo_immobile");
					var i;
					for (i = selectobject.length - 1; i>=1; i--){
						selectobject.remove(i);
					}
                     
                }else if(tipo=="Ca"){
					document.getElementById("cantieri").checked = true;
                    var selectobject = document.getElementById("tipo_immobile");
					var i;
					for (i = selectobject.length - 1; i>=1; i--){
						selectobject.remove(i);
					}  
                }else {
					document.getElementById("residenziale").checked = true;
                    var resArray = new Array("Appartamenti","Box-posti-auto","Casa-affiancata","Casa-indipendente","Casa-semi-indipendente","Casa-vacanze","Rustici-cascine-case","Stanza","Terreni","Villa");
                    var lunghezzaArray = resArray.length; 
                    var counter = 1;
                    var elSel = document.getElementById("tipo_immobile");
                    var select_true = "";
                    var i;
                    for (i = elSel.length - 1; i>=1; i--) { 
                        elSel.remove(i);
                    }
            
                        for (x=0; x<lunghezzaArray; x++)
                    { 
                            if (resArray[x] == ""){
                            select_true = "true";
                            }
                            document.getElementById("tipo_immobile").options[counter]=new Option(resArray[x],resArray[x],false);
                            document.getElementById("tipo_immobile").options[counter].selected= select_true;
                            select_true = "";
                            counter = counter + 1;
					}
				
				}
            
            }
         
            function aggiornaSottotipo(tipo){
				var tipoArray = new Array("Appartamenti","Appartamenti","Appartamenti","Appartamenti","Appartamenti","Appartamenti","Appartamenti","Appartamenti","Appartamenti","Appartamenti","Appartamenti","Appartamenti","Appartamento-in-villa","Appartamento-in-villa","Appartamento-in-villa","Appartamento-in-villa","Appartamento-in-villa","Appartamento-in-villa","Appartamento-in-villa","Appartamento-in-villa","Appartamento-in-villa","Appartamento-in-villa","Appartamento-in-villa","Box-posti-auto","Box-posti-auto","Cantieri","Capannoni","Casa-affiancata","Casa-indipendente","Casa-semi-indipendente","Complessi-commerciali","Complessi-industriali","Laboratorio","Magazzino","Negozio","Negozio","Rustici-cascine-case","Rustici-cascine-case","Rustici-cascine-case","Rustici-cascine-case","Rustici-cascine-case","Rustici-cascine-case","Rustici-cascine-case","Rustici-cascine-case","Rustici-cascine-case","Rustici-cascine-case","Rustici-cascine-case","Rustici-cascine-case","Rustici-cascine-case","Rustici-cascine-case","Rustici-cascine-case","Rustici-cascine-case","Rustici-cascine-case","Rustici-cascine-case","Stanza","Terreni","Terreni","Terreni","Ufficio","Ufficio","Villa","Villa","Villa","Villa","Villa","Villa","Villa","Villa","Villa","Villa","Villa","Villa","Villa","Villa");
				var sottoTipoArray = new Array("2 locali","3 locali","4 locali","5 locali","6 locali","Attico","Loft","Maisonnette","Mansarda","Monolocale","Multilocale","Palazzina","2 locali","3 locali","4 locali","5 locali","6 locali","Attico","Loft","Mansarda","Monolocale","Multilocale","Palazzina","Box","Posto auto","Cantiere","Capannone","","","","Complesso commerciale","Complesso industriale","Laboratorio","Magazzino","Mono-vetrina","Multi-vetrina","Baglio","Baita","Casa colonica","Casa di corte","Casa indipendente","Casa semindipendente","Casale","Cascina","Chalet","Dammuso","Maso","Masseria","Nuraghe","Porzione","Rifugio","Rustico","Sasso","Trullo","Stanza","Terreno agricolo","Terreno edificabile","Terreno residenziale","Casa e ufficio","Ufficio","","Bifamiliare","Centrale","Porzione","Porzione di bifamiliare","Porzione di quadrifamiliare","Porzione di trifamiliare","Quadrifamiliare","Schiera","Schiera centrale","Schiera di testa","Singola","Testa","Trifamiliare");
				var counter = 1;
				var elSel = document.getElementById("sottotipo");
				var i;
				var select_true = "";
				for (i = elSel.length - 1; i>=1; i--) { 
					elSel.remove(i);
				}
				
				for (x=0; x<sottoTipoArray.length; x++)
				{
				
					if (tipoArray[x] == tipo){ 
						if (sottoTipoArray[x] == ""){					
							select_true = "true";
						}
						
					document.getElementById("sottotipo").options[counter]=new Option(sottoTipoArray[x],sottoTipoArray[x],false);
					document.getElementById("sottotipo").options[counter].selected= select_true;
					select_true = "";
					counter = counter + 1;
					}
				}
			}
         
            function verifica_prezzo(obj){ 
         	
             		if (document.getElementById("prezzo_minimo").value > document.getElementById('prezzo_massimo').value){ 
             			alert("Attenzione: prezzo massimo inferiore del prezzo minimo.");
             			obj.value = "";
             		}
             }
      </script>

  </head>
  <body>
    <header>
    <a href="../homepage" title="Pagina iniziale" >
    	<img class="logows logows-m display_logo_big" src="../_common/www.pianeta-casa.net/images/logo-pianeta-casa.jpg" border="0" alt="Pianeta Casa - immobiliare">
        <img class="logows logows-m display_logo_small" src="../_common/www.pianeta-casa.net/images/logo-pianeta-casa_mob.jpg" border="0" alt="Pianeta Casa Small - immobiliare">
        
    </a>
        <nav id="nav" role="navigation">
            <a href="#nav" title="Mostra menu">Show navigation</a>
            <a href="#" title="Nascondi menu">Hide navigation</a>
            <ul class="clearfix">
                <li><a href="../homepage/homepage.php">HOME</a></li>
                <li><a href="../vendita/vendita.php?vend_aff=vendita&uso=Re&provincia=&comune=&tipo_immobile=&sottotipo=&prezzo_minimo=&prezzo_massimo=">VENDITA</a></li>
                <li><a href="../vendita/vendita.php?vend_aff=affitto&uso=Re&provincia=&comune=&tipo_immobile=&sottotipo=&prezzo_minimo=&prezzo_massimo=">AFFITTO</a></li>
                <li><a href="../pagina/pagina.php?pagina=chi-siamo">CHI SIAMO</a></li>
                <li><a href="../pagina/pagina.php?pagina=servizi">SERVIZI</a></li>
                <li><a href="../pagina/pagina.php?pagina=crea_richiesta_immobile">CREA RICHIESTA</a></li>
                <li><a href="../pagina/pagina.php?pagina=contattaci">CONTATTACI</a></li>
            </ul>
        </nav>

    </header>
    <article>
        <!--<ul class="bxslider">
          <li><img src="../_common/www.pianeta-casa.net/images/annunci-immobiliari-rozzano-01.jpg"></li>
          <li><img src="../_common/www.pianeta-casa.net/images/annunci-immobiliari-rozzano-01.jpg"></li>
          <li><img src="../_common/www.pianeta-casa.net/images/annunci-immobiliari-rozzano-01.jpg"></li>
	  		<li><img src="../_common/www.pianeta-casa.net/images/annunci-immobiliari-rozzano-01.jpg"></li>
        </ul>-->

        <div id="ricerca_immobili">
		
	<form id="contact-form" name="home_src" action="../vendita/vendita.php"  onSubmit="return verifica_prezzo()">
            <div id="vendita-affitto" class="radio">
                <input type="radio" id="vendita" name="vend_aff" value="vendita" checked="checked" ><label for="vendita"><span></span>Vendita</label>
                <input type="radio" id="affitto" name="vend_aff" value="affitto"  ><label for="affitto"><span></span>Affitto</label>
            </div>
            <div id="residenziale-commerciale" class="radio">
                <input type="radio" name="uso" id="residenziale" value="Re" onClick="aggiornaTipo('Re');" checked="checked" /><label for="residenziale"><span></span>Residenziale</label>
                <!--input type="radio" name="uso" id="prestigio" value="Pr" onClick="aggiornaTipo('Pr');" /><label for="prestigio"><span></span>Prestigio</label-->
                <!--input type="radio" name="uso" id="cantieri" value="Ca" onClick="aggiornaTipo('Ca');" /><label for="cantieri"><span></span>Cantieri</label-->
                <input type="radio" name="uso" id="commerciale" value="Co" onClick="aggiornaTipo('Co');"   /><label for="commerciale"><span></span>Commerciale</label>
            </div>
            <div id="provincia-tipologia">
                <span>
                    
		
		<select name="provincia" id="provincia" onchange="aggiornaComuni(this.value)"> <option value = "" >Provincia</option><option value = "015">Milano</option><option value = "018">Pavia</option></select>                </span>
                <span>
                    <select id="comune" name="comune">
                        <option value="">localit&aacute;</option>
                    </select>
		    
                </span>
                <span>
                    <select id="tipo_immobile" name="tipo_immobile" onchange="aggiornaSottotipo(this.value)">
                        <option value="">tipologia</option>
                    </select>
                </span>
                <span>
                    <select id="sottotipo" name="sottotipo"> </select>
                </span>
                <!--
                <span>
                    <input type="text" placeholder="mq min.">
                </span>
                <span>
                    <input type="text" placeholder="mq max.">
                </span>
                -->
                <span>
                    <input type="text" placeholder="euro da" value="" 
                                                        onfocus='if(this.value=="any")this.value="";'
                                                      	onblur='if(this.value=="")this.value="";' id="prezzo_minimo" name="prezzo_minimo">
                </span>
                <span>
                    <input type="text" placeholder="euro a" value="" 
                                                    	onfocus='if(this.value=="any")this.value="euro a";' 
                                                        onblur='if(this.value=="")this.value="euro a";' id="prezzo_massimo" name="prezzo_massimo">
                </span>
                <span id="trova">
                    <input type="submit" value="Trova" style="border:2px #CCC solid;color:#FFF; cursor:pointer; height:39px; background-color:#003787" />
                </span>
            </div>          
		  <script>
             aggiornaTipo(document.home_src.uso.value);
          </script>
        </form>

        </div>


	<div>&nbsp;</div>
        <!-- inizio contenuto -->
        <div class="news_sub_title"><h3> PAGINA IN ALLESTIMENTO</h3></div>
         <div style="clear:both"> </div>
	   <div class="page-content" ><!--style='padding-left: 2%;'-->
            	
            	<p> Prossimamente nuovi contenuti </p>           </div>
        <!-- fine contenuto -->
        <div style="clear:both;background-color:#fff;">&nbsp;</div>
        

    </article>
    <footer class="footer">
		﻿<div class="footer-element"><a href="../pagina/pagina.php?pagina=privacy" class="link_bianco">Privacy</a></div>
        <div class="footer-element">Powered by XREM – <a href="http://www.xrem.it" class="link_bianco" target="_blank">software gestionale immobiliare </a></div>
        <div class="footer-element" style="float:none; text-align:right">&copy; 2024 IMMOBILIARE PIANETA CASA S.a.S.<br>
Via Lombardia 25 – 20089 Rozzano Milano <br>
Tel. +39 02 5751 1411<br>
Email: <a href="mailto:info@pianeta-casa.net" target="_blank"> info@pianeta-casa.net</a> <br>
P.IVA 10426460159</div>		
    </footer>
  </body>
<script type="text/javascript">
  $(document).ready(function(){    
	$('.bxslider').bxSlider({
		autoStart: true,
		minSlides: 1,
		maxSlides: 1,
		slideWidth: 1280,
		slideMargin: 0,
		auto:true,
		captions: true
		
	});
  });

  aggiornaTipo(document.home_src.uso.value);

</script>


<script>
	document.getElementById("provincia").value = "";
	aggiornaComuni("");
	document.getElementById("comune").value = "";
	aggiornaTipo("Re")
	document.getElementById("tipo_immobile").value = "";
	aggiornaSottotipo(document.getElementById("tipo_immobile").value);
</script>

</html>