✏️ Editing: propiedad.php

<?php
include 'conex.php';
  $sql=$conex->query ("SELECT * FROM  imagenes where id='1' ") or die(mysqli_error());
     if($row_cnt = $sql->num_rows>0) {       
          while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) {           
            $icon=$row{'archivo'};           
             }
}
  $sql=$conex->query ("SELECT * FROM  imagenes where id='2' ") or die(mysqli_error());
     if($row_cnt = $sql->num_rows>0) {       
          while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) {           
            $logo=$row{'archivo'};           
             }
}
$sql=$conex->query ("SELECT * FROM  imagenes where id='3' ") or die(mysqli_error());
     if($row_cnt = $sql->num_rows>0) {       
          while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) {           
            $header=$row{'archivo'};           
             }
}
$sql=$conex->query ("SELECT * FROM  imagenes where id='4' ") or die(mysqli_error());
     if($row_cnt = $sql->num_rows>0) {       
          while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) {           
            $imgtestimonio=$row{'archivo'};           
             }
}
 $sql=$conex->query ("SELECT razonsocial  FROM  configuracion where id='1' ") or die(mysqli_error());
     if($row_cnt = $sql->num_rows>0) {       
          while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) {           
            $razonsocialxx=$row{'razonsocial'};           
             }
}

$sql=$conex->query ("SELECT *  FROM  tasacambio where id='1' ") or die(mysqli_error());
     if($row_cnt = $sql->num_rows>0) {       
          while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) {           
            $tasa=$row{'monto'};           
             }
}
?>
<?php
// FORMULA DE KM DE DOS DISTANCIAS
function distance($lat1, $lon1, $lat2, $lon2) { 
$pi80 = M_PI / 180; 
$lat1 *= $pi80; 
$lon1 *= $pi80; 
$lat2 *= $pi80; 
$lon2 *= $pi80; 
$r = 6372.797; // mean radius of Earth in km 
$dlat = $lat2 - $lat1; 
$dlon = $lon2 - $lon1; 
$a = sin($dlat / 2) * sin($dlat / 2) + cos($lat1) * cos($lat2) * sin($dlon / 2) * sin($dlon / 2); 
$c = 2 * atan2(sqrt($a), sqrt(1 - $a)); 
$km = $r * $c; 
//echo ' '.$km; 
return $km; 
}

$id= isset($_GET['id']) ? $_GET['id'] : '' ;
 $imagenprincipal='miinmueble.png';

$sql=$conex->query ("SELECT * FROM inmueble  where id='$id' " ) or die(mysqli_error());   
     if($row_cnt = $sql->num_rows>0) {       
          while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) { 
$cptitulopublicacion=$row{'cptitulopublicacion'};
$cpprecio=$row{'cpprecio'};
$cptipo=$row{'cptipo'};
$cpcategoria=$row{'cpcategoria'};
$cpdescripcion=$row{'cpdescripcion'};
$cpestados=$row{'cpestados'};
$cpmunicipio=$row{'cpmunicipio'};
$cpparroquia=$row{'cpparroquia'};
$cpciudades=$row{'cpciudades'};
$cpdireccion=$row{'cpdireccion'};
$cpurbanizacion=$row{'cpurbanizacion'};
$status=$row{'status'};
$cpvideo=$row{'cpvideo'};
$cpagencia=$row{'cpagencia'};
$cpagente=$row{'cpagente'};
$cpsuperficietotal=$row{'cpsuperficietotal'};
$cpsuperficiecontruida=$row{'cpsuperficiecontruida'};
$cphabitaciones=$row{'cphabitaciones'};
$cpbanos=$row{'cpbanos'};
$cpcamas=$row{'cpcamas'};
$cpaccesos=$row{'cpaccesos'};
$cpestacionamientos=$row{'cpestacionamientos'};
$cpantiguedad=$row{'cpantiguedad'};
$cpsupeficiebalcon=$row{'cpsupeficiebalcon'};
$cpalacenas=$row{'cpalacenas'};
$cpcantpisos=$row{'cpcantpisos'};
$cpncasa=$row{'cpncasa'};
$cpdepartamentopiso=$row{'cpdepartamentopiso'};
$cpnumeropisound=$row{'cpnumeropisound'};
$cptipodepar=$row{'cptipodepar'};
$cpdisposicion=$row{'cpdisposicion'};
$cporientacion=$row{'cporientacion'};
$cpaptocredito=$row{'cpaptocredito'};
$cpmetrofrente=$row{'cpmetrofrente'};
$cpmetrofondo=$row{'cpmetrofondo'};
$cpformaterreno=$row{'cpformaterreno'};
$cpdisposicionlotes=$row{'cpdisposicionlotes'};
$cptipodecasas=$row{'cptipodecasas'};
$cpambientes=$row{'cpambientes'};
$cptipodebodegas=$row{'cptipodebodegas'};
$cpnumerooficinas=$row{'cpnumerooficinas'};
$cpaltura=$row{'cpaltura'};
$cpsoportepiso=$row{'cpsoportepiso'};
$cpplataformatrailer=$row{'cpplataformatrailer'};
$cpdistanciaasfalto=$row{'cpdistanciaasfalto'};
$cphuespedes=$row{'cphuespedes'};
$cpestrellas=$row{'cpestrellas'};
$cpnombrehotel=$row{'cpnombrehotel'};
$cpcamasindv=$row{'cpcamasindv'};
$cpcantidadcamasmatri=$row{'cpcantidadcamasmatri'};
$cpliteras=$row{'cpliteras'};
$cpcantidadsofacama=$row{'cpcantidadsofacama'};
$cpgastoscomunes=$row{'cpgastoscomunes'};
$cpoficinasporpiso=$row{'cpoficinasporpiso'};
$cpnombrecementerio=$row{'cpnombrecementerio'};
$cptipolotecementerio=$row{'cptipolotecementerio'};
$cpsectorcementerio=$row{'cpsectorcementerio'};
$cpparcela=$row{'cpparcela'};
$cpprofundidad=$row{'cpprofundidad'};
$cpancho=$row{'cpancho'};
$cplargo=$row{'cplargo'};
$cenumerotorre=$row{'cenumerotorre'};
$ceacine=$row{'ceacine'};
$cejinfantiles=$row{'cejinfantiles'};
$ceoficina=$row{'ceoficina'};
$cecanchatenis=$row{'cecanchatenis'};
$ceasensor=$row{'ceasensor'};
$cecanchabasquet=$row{'cecanchabasquet'};
$cecanchapaddel=$row{'cecanchapaddel'};
$cecanchamultiple=$row{'cecanchamultiple'};
$cechimeneas=$row{'cechimeneas'};
$ceareaverde=$row{'ceareaverde'};
$cecanchafutbol=$row{'cecanchafutbol'};
$ceestavisitante=$row{'ceestavisitante'};
$cegimnasio=$row{'cegimnasio'};
$ceheladera=$row{'ceheladera'};
$cerampasrueda=$row{'cerampasrueda'};
$cerecepcion=$row{'cerecepcion'};
$cesauna=$row{'cesauna'};
$cebascula=$row{'cebascula'};
$ceaireacondicionado=$row{'ceaireacondicionado'};
$cecalefaccion=$row{'cecalefaccion'};
$ceplantaelectrica=$row{'ceplantaelectrica'};
$cesistemaventi=$row{'cesistemaventi'};
$ceascensor=$row{'ceascensor'};
$ceaccesointernet=$row{'ceaccesointernet'};
$ceprobador=$row{'ceprobador'};
$cepolideportiva=$row{'cepolideportiva'};
$cesalonfiesta=$row{'cesalonfiesta'};
$cevaletparking=$row{'cevaletparking'};
$cecaballeriza=$row{'cecaballeriza'};
$ceplaya=$row{'ceplaya'};
$cecaliente=$row{'cecaliente'};
$celancha=$row{'celancha'};
$cebuceo=$row{'cebuceo'};
$cepaseos=$row{'cepaseos'};
$cecasino=$row{'cecasino'};
$ceminimercado=$row{'ceminimercado'};
$ceparque=$row{'ceparque'};
$cepisina=$row{'cepisina'};
$cesupermercado=$row{'cesupermercado'};
$cerestaurant=$row{'cerestaurant'};
$celavanderia=$row{'celavanderia'};
$cebowling=$row{'cebowling'};
$cecabana=$row{'cecabana'};
$cecanchabeisbol=$row{'cecanchabeisbol'};
$cecanchavoley=$row{'cecanchavoley'};
$cediscoteca=$row{'cediscoteca'};  
$ceestudio=$row{'ceestudio'}; 
$cebillar=$row{'cebillar'};
$cepingpoing=$row{'cepingpoing'};
$cemasajes=$row{'cemasajes'};
$ceenfermeria=$row{'ceenfermeria'};
$ceeventos=$row{'ceeventos'};
$ceexposicion=$row{'ceexposicion'};
$seaccesoin=$row{'seaccesoin'};
$seagua=$row{'seagua'};
$segasnatural=$row{'segasnatural'};
$selineatelefonica=$row{'selineatelefonica'};
$seaireacondicionado=$row{'seaireacondicionado'};
$secalentadorgas=$row{'secalentadorgas'};
$secalefaccion=$row{'secalefaccion'};
$secisterna=$row{'secisterna'};
$seenergiasolar=$row{'seenergiasolar'};
$seplantaelectrica=$row{'seplantaelectrica'};
$seluzelectrica=$row{'seluzelectrica'};
$secloaca=$row{'secloaca'};
$seconexion=$row{'seconexion'};
$sgtiposeguridad=$row{'sgtiposeguridad'};
$sgseguridad=$row{'sgseguridad'};
$sgbarriocerrado=$row{'sgbarriocerrado'};
$sgportonelectrico=$row{'sgportonelectrico'};
$sgalarma=$row{'sgalarma'};
$sgsistemacontrainc=$row{'sgsistemacontrainc'};
$sgaccesocontrolado=$row{'sgaccesocontrolado'};
$condemascota=$row{'condemascota'};
$condamoblado=$row{'condamoblado'};
$conducomercial=$row{'conducomercial'};
$condaptonino=$row{'condaptonino'};
$ambbalcon=$row{'ambbalcon'};
$ambcocina=$row{'ambcocina'};
$ambcomedor=$row{'ambcomedor'};
$ambareadesayuno=$row{'ambareadesayuno'};
$ambsuite=$row{'ambsuite'};
$ambestudio=$row{'ambestudio'};
$ambjacuzzi=$row{'ambjacuzzi'};
$ambcuartolavado=$row{'ambcuartolavado'};
$ambestar=$row{'ambestar'};
$ambpatio=$row{'ambpatio'};
$ambarmario=$row{'ambarmario'};
$ambvestier=$row{'ambvestier'};
$ambsaladejuego=$row{'ambsaladejuego'};
$ambbanovisita=$row{'ambbanovisita'};
$ambcuartoservicio=$row{'ambcuartoservicio'};
$ambjardin=$row{'ambjardin'};
$ambparrillera=$row{'ambparrillera'};
$ambpisina=$row{'ambpisina'};
$ambterraza=$row{'ambterraza'};
$ambatico=$row{'ambatico'};
$esplavaderocomun=$row{'esplavaderocomun'};
$espsalonfiesta=$row{'espsalonfiesta'};
$espsalonmultiple=$row{'espsalonmultiple'};
$esproofgarden=$row{'esproofgarden'};
$espforestacion=$row{'espforestacion'};
$esprecepcion=$row{'esprecepcion'};
$espsalareunion=$row{'espsalareunion'};
$espareacomedor=$row{'espareacomedor'};
$espareaverde=$row{'espareaverde'};
$esplobby=$row{'esplobby'};
$lat=$row{'lat'};
$lon=$row{'lon'};
$pais=$row{'pais'};
$estado=$row{'estado'};
$municipio=$row{'municipio'};
$codigopostal=$row{'codigopostal'};
$suburb=$row{'suburb'};
$city=$row{'ciudad'};
$geocoder=$row{'geocoder'};
$imagenprincipal=$row{'imagenprincipal'};
$codigomls=$row{'codigomls'};
        $cptitulopublicacionen=$row{'cptitulopublicacionen'};
        $cpdescripcionen=$row{'cpdescripcionen'};
			  
$mantenimiento=$row{'mantenimiento'};			  
$predial=$row{'predial'};
$land=$row{'land'};			  
$construction=$row{'construction'};
$asadorx=$row{'asadorx'};			  
$condominio=$row{'condominio'};
$relajacion=$row{'relajacion'};			  
$friendly=$row{'friendly'};
$terraza=$row{'terraza'};			  
$restaurant=$row{'restaurant'};
$cenote=$row{'cenote'};
$cppreciousd=$row{'cppreciousd'};

if($cpprecio=='')$cpprecio=$cppreciousd*$tasa;
if($cppreciousd=='')$cppreciousd=$cpprecio/$tasa;
               }
                }

$estadonm='';
                        $sqlx=$conex->query ("SELECT * FROM states where id='$cpestados' ") or die(mysqli_error());
                    if($row_cnt = $sqlx->num_rows>0) {       
                    while ($rowx = $sqlx->fetch_array(MYSQLI_ASSOC) ) { 
                            $estadonm=$rowx{'description'};
                        }
                      }

$municipionm='';
                        $sqlx=$conex->query ("SELECT * FROM municipalities where id='$cpmunicipio' ") or die(mysqli_error());
                    if($row_cnt = $sqlx->num_rows>0) {       
                    while ($rowx = $sqlx->fetch_array(MYSQLI_ASSOC) ) { 
                            $municipionm=$rowx{'description'};
                        }
                      }

$parroquianm='';
                        $sqlx=$conex->query ("SELECT * FROM suburbs where id='$cpparroquia' ") or die(mysqli_error());
                    if($row_cnt = $sqlx->num_rows>0) {       
                    while ($rowx = $sqlx->fetch_array(MYSQLI_ASSOC) ) { 
                            $parroquianm=$rowx{'description'};
                        }
                      }

$url='https://www.mexicoprop.com/';
$cptitulopublicacionenx = str_replace(" ", "%20", $cptitulopublicacionen);
$urlcomp="https://www.mexicoprop.com/en/propiedad.php?id=$id&n=$cptitulopublicacionenx";
$urlcomp=urlencode($urlcomp);
$cpvideo= explode("watch?v=", $cpvideo);
$cpvideo='https://www.youtube.com/embed/'.$cpvideo['1'];
?>
<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">   
    <meta name="description" content="<?=$cpdescripcionen?>" />
    <meta name="author" content="info@miinmueble.online" />
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
   <title><?=$cptitulopublicacionen?></title>
    
    <link rel="shortcut icon" href="https://www.mexicoprop.com/imagenes/<?=$icon?>" />

<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Barlow+Semi+Condensed:300,500,600,700%7CRoboto:300,400,500,700">

<link rel="stylesheet" href="css/font-awesome/all.min.css" />
    <link rel="stylesheet" href="css/flaticon/flaticon.css" />
    <link rel="stylesheet" href="css/bootstrap/bootstrap.min.css" />

<link rel="stylesheet" href="css/datetimepicker/datetimepicker.min.css" />
    <link rel="stylesheet" href="css/slick/slick-theme.css" />

<link rel="stylesheet" href="css/style.css" />
 <link rel="stylesheet" href="https://unpkg.com/leaflet@1.9.4/dist/leaflet.css"
     integrity="sha256-p4NxAoJBhIIN+hmNHrzRCf9tD/miZyoHS5obTRR9BMY="
     crossorigin=""/>
     <script src="https://unpkg.com/leaflet@1.9.4/dist/leaflet.js"
     integrity="sha256-20nQCchB9co0qIjJZRGuk2/Z9VM+kNiyxNV1lvTlZBo="
     crossorigin=""></script>

.gallery-image {
    margin: 10px;
    cursor: pointer;
    transition: transform 0.3s;
}

.overlay {
    display: none;
    position: fixed;
    top: 0;
    left: 0;
    width: 100%;
    height: 100%;
    background-color: rgba(0, 0, 0, 0.7);
    align-items: center;
    justify-content: center;
     z-index: 9999;
}

.overlay-image {
    max-width: 90%;
    max-height: 90%;
    cursor: zoom-out;

}

.close-btn {
    position: absolute;
    top: 10px;
    right: 10px;
    font-size: 30px;
    color: white;
    cursor: pointer;
}

</style>
  </head>
 <style type="text/css">
     #map { height: 480px;
       }

.loader {
    position: fixed;
    left: 0px;
    top: 0px;
    width: 100%;
    height: 100%;
    z-index: 9999;
    background: url('images/500.gif') 50% 50% no-repeat rgb(249,249,249);
    opacity: .8;
}
    </style>
  
<body>

<?php
 include 'menu.php';

$cpprecio=number_format($cpprecio,2);
$cppreciousd=number_format($cppreciousd,2);
$cpsuperficietotal=number_format($cpsuperficietotal,2);
$cpsuperficiecontruida=number_format($cpsuperficiecontruida,2);
if($imagenprincipal=='') $imagenprincipal='miinmueble.png';

$nagente='';
                    $aagente='';
                    $fagente='';
                    $nombreagente='';
     $fagente='miinmueble.png';
                    $sqlx=$conex->query ("SELECT * FROM agente where id='$cpagente' ") or die(mysqli_error());
                    if($row_cnt = $sqlx->num_rows>0) {       
                    while ($rowx = $sqlx->fetch_array(MYSQLI_ASSOC) ) { 
                            $nagente=$rowx{'nombre'};
                            $aagente=$rowx{'apellido'};
                            $fagente=$rowx{'foto'};
                            $whatsapp=$rowx{'whatsapp'};
                            $fagente=$rowx{'foto'};
                            $agencia=$rowx{'agencia'};
                            $nombreagente=$nagente.' '.$aagente;
                        }
                      }
      if($fagente=='') $fagente='miinmueble.png';
                    $agencianombre='';
                    $sqlx=$conex->query ("SELECT * FROM agencia where id='$agencia' ") or die(mysqli_error());
                    if($row_cnt = $sqlx->num_rows>0) {       
                    while ($rowx = $sqlx->fetch_array(MYSQLI_ASSOC) ) { 
                            $agencianombre=$rowx{'nombre'};
                       }
                      }

$tipo='';
                    $sqlx=$conex->query ("SELECT * FROM tipo where id='$cptipo' ") or die(mysqli_error());
                    if($row_cnt = $sqlx->num_rows>0) {       
                    while ($rowx = $sqlx->fetch_array(MYSQLI_ASSOC) ) { 
                            $tipo=$rowx{'nombreen'};
                        }
                      }

$categoria='';
                    $sqlx=$conex->query ("SELECT * FROM categoria where id='$cpcategoria' ") or die(mysqli_error());
                    if($row_cnt = $sqlx->num_rows>0) {       
                    while ($rowx = $sqlx->fetch_array(MYSQLI_ASSOC) ) { 
                            $categoria=$rowx{'nombreen'};
                        }
                      }

$tipodecasas='';
                    $sqlx=$conex->query ("SELECT * FROM tipocasas where id='$cptipodecasas' ") or die(mysqli_error());
                    if($row_cnt = $sqlx->num_rows>0) {       
                    while ($rowx = $sqlx->fetch_array(MYSQLI_ASSOC) ) { 
                            $tipodecasas=$rowx{'nombre'};
                        }
                      }

$orientacion='';
                    $sqlx=$conex->query ("SELECT * FROM orientacion where id='$cporientacion' ") or die(mysqli_error());
                    if($row_cnt = $sqlx->num_rows>0) {       
                    while ($rowx = $sqlx->fetch_array(MYSQLI_ASSOC) ) { 
                            $orientacion=$rowx{'nombre'};
                        }
                      }
		  
		  			$sqlx=$conex->query ("SELECT * FROM tipodepartamento where id='$cptipodepar' ") or die(mysqli_error());
                    if($row_cnt = $sqlx->num_rows>0) {       
                    while ($rowx = $sqlx->fetch_array(MYSQLI_ASSOC) ) { 
                            $cptipodepar=$rowx{'nombre'};
                        }
                      }
?>

<ul class="property-detail-meta list-unstyled ">                
                <li><a href="https://api.whatsapp.com/send?phone=<?=$whatsapp?>&text=<?=$urlcomp?>" style="background-color:#128C7E; color:white;"> <i  class="fab fa-whatsapp pe-2"></i>Whatsapp</a></li>
                <li class="share-box">
                  <a href="#"> <i class="fas fa-share-alt"></i> </a>
                  <ul class="list-unstyled share-box-social">
<li> <a style="font-size: 30px;" href="https://www.facebook.com/sharer/sharer.php?u=<?=$urlcomp?>"><i class="fab fa-facebook-f" style="color: white;"></i></a> </li>
<li> <a style="font-size: 30px;" href="https://twitter.com/intent/tweet?text=<?=$cptitulopublicacion?>&url=<?=$urlcomp?>&"><i class="fab fa-twitter" style="color: white;"></i></a> </li>
<li> <a style="font-size: 30px;" href="https://www.linkedin.com/sharing/share-offsite/?url=<?=$urlcomp?>"><i class="fab fa-linkedin" style="color: white;"></i></a> </li>
<li> <a style="font-size: 30px;" href="https://telegram.me/share/url?url=<?=$urlcomp?>&text=<?=$cptitulopublicacion?>"><i class="fab fa-telegram" style="color: white;"></i></a> </li>
<li> <a style="font-size: 30px;" href="https://api.whatsapp.com/send?text=<?=$urlcomp?>"><i class="fab fa-whatsapp" style="color: white;"></i></a> </li>
                  </ul>
                </li>
                  
             
              </ul>
            
            </div>
            <div class="agent-contact-inner  p-4 d-none d-sm-none d-md-block" style='background-color:#192359;'>

<form>
                <div class="mb-3">
				  <input type="hidden" class="form-control" name="titulopub" id="titulopub" value="<?=$cptitulopublicacion?>" >
                  <input type="email" class="form-control" name="email" id="email"  placeholder="Your email address">
                </div>
                <div class="mb-3">
                  <input type="text" class="form-control"  name="telefono" id="telefono" placeholder="Your phone number">
                </div>
                <div class="mb-3">
                  <textarea class="form-control" rows="3"  name="mensaje" id="mensaje" placeholder="Write a message"></textarea>
                </div>
                
                <a class="btn btn-primary d-grid" onclick="miFunc()" >Enviar mensaje</a>
              </form>
            </div>
          </div>
        </div>
        <div class="col-lg-8 order-lg-1">
			
			<div class="d-none d-sm-none d-md-block">
          <div class="property-detail-gallery overflow-hidden">
            <ul class="nav nav-tabs nav-tabs-02 mb-4" id="pills-tab" role="tablist">
              <li class="nav-item">
                <a class="nav-link shadow active" id="photo-tab" data-bs-toggle="pill" href="#photo" role="tab" aria-controls="photo" aria-selected="true">Gallery</a>
              </li>
              <li class="nav-item">
                <a class="nav-link shadow" id="map-tab" data-bs-toggle="pill" href="#map" role="tab" aria-controls="map" aria-selected="false">Map</a>
              </li>
              
            </ul>
            <div class="tab-content" id="pills-tabContent">
              <div class="tab-pane fade show active" id="photo" role="tabpanel" aria-labelledby="photo-tab">
                <div class="slider-slick">
                  <div class="slider slider-for detail-big-car-gallery">
                    <div align="center" class="gallery-image" id="../publicaciones/<?=$imagenprincipal?>" style="width: 600px; height: 400px;background: url('../publicaciones/<?=$imagenprincipal?>') center;background-size: cover;'">
     </div>

<?php
                     $sqlx=$conex->query ("SELECT * FROM galeria where propiedad='$id' ") or die(mysqli_error());
                    if($row_cnt = $sqlx->num_rows>0) {       
                    while ($rowx = $sqlx->fetch_array(MYSQLI_ASSOC) ) { 
                            $imagenprincipalssfsf=$rowx{'nombre'};  
                   echo "<div align='center' id='../galeria/$imagenprincipalssfsf' class='gallery-image' style='width: 600px;height:400px;background: url(../galeria/$imagenprincipalssfsf) center; backdrop-filter: blur(10px);background-size: cover;'></div>";  
                        }
                      }
                    ?>

</div>
                  <div class="slider slider-nav">                    
     <div align="center" style="width: 150px; height: 100px;background: url('../publicaciones/<?=$imagenprincipal?>') center;background-size: cover;'"></div>
                       <?php
                     $sqlx=$conex->query ("SELECT * FROM galeria where propiedad='$id' ") or die(mysqli_error());
                    if($row_cnt = $sqlx->num_rows>0) {       
                    while ($rowx = $sqlx->fetch_array(MYSQLI_ASSOC) ) { 
                            $imagenprincipalssfsf=$rowx{'nombre'};  
               echo "<div align='center'  style='width: 150px;height:100px;background: url(../galeria/$imagenprincipalssfsf) center; backdrop-filter: blur(10px);background-size: cover;'></div>";  
                        }
                      }
                    ?>                   
                 </div>
                </div>
              </div>
              <div class="tab-pane fade" id="map" role="tabpanel" aria-labelledby="map-tab">
                
                
                <iframe src="app/map.php?lat=<?=$lat?>&lon=<?=$lon?>" style="border:0; width: 100%; height: 100%;"></iframe>
          
              </div>
              <div class="tab-pane fade" id="street-map-view" role="tabpanel" aria-labelledby="street-map-view-tab">
                <div id="street-view"></div>
              </div>
            </div>
          </div>
				
				 </div>
			
              <div class="d-sm-block d-md-none">				  
          <div class="property-detail-gallery overflow-hidden">
            <ul class="nav nav-tabs nav-tabs-02 mb-4" id="pills-tab" role="tablist">
              <li class="nav-item">
                <a class="nav-link shadow active" id="photo-tab" data-bs-toggle="pill" href="#photo2" role="tab" aria-controls="photo" aria-selected="true">Galería</a>
              </li>
              <li class="nav-item">
                <a class="nav-link shadow" id="map-tab" data-bs-toggle="pill" href="#map2" role="tab" aria-controls="map" aria-selected="false">Mapa</a>
              </li>
              
            </ul>
            <div class="tab-content" id="pills-tabContent">
              <div class="tab-pane fade show active" id="photo2" role="tabpanel" aria-labelledby="photo-tab">
                <div class="slider-slick">
                  <div class="slider slider-for detail-big-car-gallery">
     <div align="center" class="gallery-image" id="../publicaciones/<?=$imagenprincipal?>" style="width: 400px; height: 290px;background: url('../publicaciones/<?=$imagenprincipal?>') center;background-size: cover;'"></div>

<?php
                     $sqlx=$conex->query ("SELECT * FROM galeria where propiedad='$id' ") or die(mysqli_error());
                    if($row_cnt = $sqlx->num_rows>0) {       
                    while ($rowx = $sqlx->fetch_array(MYSQLI_ASSOC) ) { 
                            $imagenprincipalssfsf=$rowx{'nombre'};  
                    echo "<div align='center' id='../galeria/$imagenprincipalssfsf' class='gallery-image' style='width: 400px;height:290px;background: url(../galeria/$imagenprincipalssfsf) center; backdrop-filter: blur(10px);background-size: cover;'></div>"; 
                        }
                      }
                    ?>

</div>
                  <div class="slider slider-nav">                    
                  
					   <div align="center" style="width: 150px; height: 80px;background: url('../publicaciones/<?=$imagenprincipal?>') center;background-size: cover;'"></div>
                       <?php
                     $sqlx=$conex->query ("SELECT * FROM galeria where propiedad='$id' ") or die(mysqli_error());
                    if($row_cnt = $sqlx->num_rows>0) {       
                    while ($rowx = $sqlx->fetch_array(MYSQLI_ASSOC) ) { 
                            $imagenprincipalssfsf=$rowx{'nombre'};  
              //  echo "<img class='img-fluid' src='../galeria/$imagenprincipalssfsf' style='width: 250px; height: 100px;' alt=''>";
	 echo "<div align='center'  style='width: 150px;height:80px;background: url(../galeria/$imagenprincipalssfsf) center; backdrop-filter: blur(10px);background-size: cover;'></div>"; 
                        }
                      }
                    ?>                   
                 </div>
                </div>
              </div>
              <div class="tab-pane fade" id="map2" role="tabpanel" aria-labelledby="map-tab">
                
                
                <iframe src="app/map.php?lat=<?=$lat?>&lon=<?=$lon?>" style="border:0; width: 100%; height: 290px;"></iframe>
          
              </div>
              <div class="tab-pane fade" id="street-map-view" role="tabpanel" aria-labelledby="street-map-view-tab">
                <div id="street-view"></div>
              </div>
            </div>
          </div>
				  
				  </div>

<div class="property-info mt-5">
            <div class="row">
              <div class="col-sm-3 mb-3 mb-sm-0">
                <h5>Property details</h5>
              </div>

<div class="col-sm-9">
                <div class="row mb-3">
                  <div class="col-sm-6">
                    <ul class="property-list list-unstyled">
	 <?php if($cptipodepar!=''){ ?>                   <li><b>Style:</b> <?=$cptipodepar?></li> <?php } ?> 
	 <?php if($cphabitaciones!=''){ ?>         <li><b>Bedrooms:</b> <?=$cphabitaciones?></li>          <?php } ?>  
	<?php if($cpbanos!=''){ ?>                  <li><b>Bathrooms:</b> <?=$cpbanos?></li> <?php } ?> 
	<?php if($cpalacenas!=''){ ?>         <li><b>Half bathrooms:</b> <?=$cpalacenas?></li>  <?php } ?>  						
    <?php if($cpsuperficietotal!=''){ ?>         <li><b>Land:</b> <?=$cpsuperficietotal?> m2</li>  <?php } ?>  
	<?php if($cpantiguedad!=''){ ?>         <li><b>Year Built:</b> <?=$cpantiguedad?></li>  <?php } ?>  
    <?php if($cpgastoscomunes!=''){ ?>         <li><b>Common expenses:</b> <?=$cpgastoscomunes?> MXN</li>    <?php } ?>  
						
    <?php if($cpcamas!=''){ ?>         <li><b>Beds:</b> <?=$cpcamas?></li>                     <?php } ?>    
    
    <?php if($cpncasa!=''){ ?>         <li><b>Apartment or House  number:</b> <?=$cpncasa?></li> <?php } ?>  
    <?php if($cpnumeropisound!=''){ ?>         <li><b>Unit floor number:</b> <?=$cpnumeropisound?></li> <?php } ?>  
    <?php if($cpdisposicion!=''){ ?>         <li><b>Provision:</b> <?=$cpdisposicion?></li>   <?php } ?>                      
    <?php if($cpaptocredito!=''){ ?>         <li><b>Suitable credit:</b> <?=$cpaptocredito?></li> <?php } ?>  
		<?php if($mantenimiento!=''){ ?>  			 <li><b>Maintenance fee:</b> <?=$mantenimiento?></li>    <?php } ?>                    
    <?php if($predial!=''){ ?>         <li><b>Annual tax:</b> <?=$predial?></li>  <?php } ?>  
    <?php if($tipodecasas!=''){ ?>         <li><b>House Type:</b> <?=$tipodecasas?></li> <?php } ?>  
    <?php if($cpnumerooficinas!=''){ ?>         <li><b>Number of offices:</b> <?=$cpnumerooficinas?></li>  <?php } ?>  
    <?php if($cptipodebodegas!=''){ ?>         <li><b>Winery type:</b> <?=$cptipodebodegas?></li>  <?php } ?>  
    <?php if($cpplataformatrailer!=''){ ?>         <li><b>Trailer platforms:</b> <?=$cpplataformatrailer?></li>  <?php } ?>  
    <?php if($cpmetrofrente!=''){ ?>         <li><b>Meters in front:</b> <?=$cpmetrofrente?> m</li> <?php } ?>  
    <?php if($cpmetrofondo!=''){ ?>         <li><b>Bottom meters:</b> <?=$cpmetrofondo?> m</li> <?php } ?>  
    
    <?php if($cpdistanciaasfalto!=''){ ?>         <li><b>Distance to asphalt:</b> <?=$cpdistanciaasfalto?> ft</li> <?php } ?>  
    <?php if($cpnombrehotel!=''){ ?>         <li><b>Name of the hotel:</b> <?=$cpnombrehotel?></li> <?php } ?>  
    <?php if($cpliteras!=''){ ?>         <li><b>Bunk beds:</b> <?=$cpliteras?></li>   <?php } ?>  
    <?php if($cpestrellas!=''){ ?>         <li><b>Stars:</b> <?=$cpestrellas?></li>  <?php } ?>  
    <?php if($cpcantidadsofacama!=''){ ?>         <li><b>Quantity of sofa beds:</b> <?=$cpcantidadsofacama?></li> <?php } ?>  
    <?php if($cpnombrecementerio!=''){ ?>         <li><b>Cemetery name:</b> <?=$cpnombrecementerio?> </li>    <?php } ?>               
                    </ul>
                  </div>
                  <div class="col-sm-6">
                    <ul class="property-list list-unstyled">
    <?php if($cpsuperficiecontruida!=''){ ?>          <li><b>Construction:</b> <?=$cpsuperficiecontruida?> m2</li> <?php } ?> 
    
    <?php if($cpestacionamientos!=''){ ?>                   <li><b>Parking lots:</b> <?=$cpestacionamientos?></li> <?php } ?> 
    <?php if($cpsupeficiebalcon!=''){ ?>                   <li><b>Balcony area:</b> <?=$cpsupeficiebalcon?></li> <?php } ?> 
    <?php if($cpcantpisos!=''){ ?>                   <li><b>Number of floors:</b> <?=$cpcantpisos?></li> <?php } ?> 
    <?php if($cpdepartamentopiso!=''){ ?>                   <li><b>Apartments per floor:</b> <?=$cpdepartamentopiso?></li> <?php } ?> 
   
    <?php if($orientacion!=''){ ?>                   <li><b>Orientation:</b> <?=$orientacion?></li> <?php } ?> 
		<?php if($land!=''){ ?> 				          <li><b>Land:</b> <?=$land?></li> <?php } ?>                       
    <?php if($construction!=''){ ?>                   <li><b>Construction:</b> <?=$construction?></li>   <?php } ?>                   
    <?php if($cpambientes!=''){ ?>                   <li><b>Environments:</b> <?=$cpambientes?></li> <?php } ?> 
    <?php if($cpsoportepiso!=''){ ?>                   <li><b>Floor support:</b> <?=$cpsoportepiso?> m2</li> <?php } ?> 
    <?php if($cpaltura!=''){ ?>                    <li><b>Height:</b> <?=$cpaltura?> m</li> <?php } ?> 
    <?php if($cpaccesos!=''){ ?>                    <li><b>Access:</b> <?=$cpaccesos?></li> <?php } ?> 
    <?php if($cpdisposicionlotes!=''){ ?>                    <li><b>Lot layout:</b> <?=$cpdisposicionlotes?></li>  <?php } ?> 
    <?php if($cpformaterreno!=''){ ?>                    <li><b>Land shape:</b> <?=$cpformaterreno?></li>  <?php } ?>   
    <?php if($cpcamasindv!=''){ ?>                    <li><b>Number of single beds:</b> <?=$cpcamasindv?></li>  <?php } ?> 
    <?php if($cphuespedes!=''){ ?>                    <li><b>Guests:</b> <?=$cphuespedes?></li>  <?php } ?> 
    <?php if($cpcantidadcamasmatri!=''){ ?>                     <li><b>Number of double beds:</b> <?=$cpcantidadcamasmatri?></li> <?php } ?> 
    <?php if($cpsectorcementerio!=''){ ?>                     <li><b>Sector inside the cemetery:</b> <?=$cpsectorcementerio?></li> <?php } ?> 
    <?php if($cpprofundidad!=''){ ?>                     <li><b>Depth:</b> <?=$cpprofundidad?> m</li> <?php } ?> 
    <?php if($cpparcela!=''){ ?>                     <li><b>Parcel:</b> <?=$cpparcela?></li> <?php } ?> 
    <?php if($cpancho!=''){ ?>                     <li><b>Broad:</b> <?=$cpancho?> m</li>  <?php } ?> 
    <?php if($cptipolotecementerio!=''){ ?>                     <li><b>Cemetery Plot Type:</b> <?=$cptipolotecementerio?></li> <?php } ?> 
    <?php if($cplargo!=''){ ?>                     <li><b>Long:</b> <?=$cplargo?> m</li> <?php } ?>

</ul>
                  </div>
                </div>              
              </div>

</div>
          </div>

<?php
			if($cpvideo!='https://www.youtube.com/embed/'){
			?>
			
			<hr class="mt-4 mb-4 mb-sm-5 mt-sm-5">
          <div class="property-video">
            <div class="row">
              <div class="col-sm-3 mb-3 mb-sm-0">
                <h5>Property video</h5>
              </div>
              <div class="col-sm-9">
                <div class="embed-responsive embed-responsive-16by9">
                  <iframe width="546" height="315" src="<?=$cpvideo?>" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
                </div>
              </div>
            </div>
          </div>
			<?php
			} 
			?>

<?php            
       if($cpdescripcion!='' ) {          
              ?>
          <hr class="mt-4 mb-4 mb-sm-5 mt-sm-5">
          <div class="property-description">
            <div class="row">
              <div class="col-sm-3 mb-3 mb-sm-0">
                <h5>Description</h5>
              </div>
              <div class="col-sm-9">
                <p><?=$cpdescripcionen?></p>                
              </div>
            </div>
          </div>

<?php
      } 
      ?>

<?php            
       if($ceprobador=='SI' or $ambvestier=='SI' or $ambbanovisita=='SI' or $ambterraza=='SI' or $espareaverde=='SI' or $condamoblado=='SI' or $conducomercial=='SI' or $condaptonino=='SI'  or $seenergiasolar=='SI'  or $seplantaelectrica=='SI' or $sgportonelectrico=='SI' or $seconexion=='SI' or $ambsaladejuego=='SI' or $ambbalcon=='SI' or $ambcocina=='SI' or $ambcomedor=='SI' or $ambareadesayuno=='SI' or $ambsuite=='SI' or $ambestudio=='SI' or $ambatico=='SI' or $ambcuartolavado=='SI' or $ambestar=='SI' or $ambarmario=='SI' or $ambjardin=='SI') {          
              ?>

<hr class="mt-4 mb-4 mb-sm-5 mt-sm-5">
          <div class="property-features">
            <div class="row">
              <div class="col-sm-3 mb-3 mb-sm-0">
                <h5>Features</h5>
              </div>
              <div class="col-sm-9">
                <div class="row">

<?php
                  if($ceprobador=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>High-speed Internet</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ambvestier=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Private pool</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ambbanovisita=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Private Jacuzzi</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ambterraza=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Private rooftop</li>                  
                    </ul>
                  </div> ";                  
                    }

if($espareaverde=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Furnished</li>                  
                    </ul>
                  </div> ";                  
                    }

if($condamoblado=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Furnished and equipped</li>                  
                    </ul>
                  </div> ";                  
                    }

if($conducomercial=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Furnished partial</li>                  
                    </ul>
                  </div> ";                  
                    }

if($condaptonino=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Without Furniture</li>                  
                    </ul>
                  </div> ";                  
                    }

if($seenergiasolar=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Renewable Energy</li>                  
                    </ul>
                  </div> ";                  
                    }

if($seplantaelectrica=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Smart Home</li>                  
                    </ul>
                  </div> ";                  
                    }

if($sgportonelectrico=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Alarm System</li>                  
                    </ul>
                  </div> ";                  
                    }

if($seconexion=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Security Cameras</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ambsaladejuego=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Quiet</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ambbalcon=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Cozy</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ambcocina=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Spacious</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ambcomedor=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Well maintained</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ambareadesayuno=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Good distribution</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ambsuite=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Elegant</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ambestudio=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Luxurious</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ambatico=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Bright</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ambcuartolavado=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Modern</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ambestar=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Sliding windows</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ambarmario=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Ventilated</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ambjardin=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Remodeled</li>                  
                    </ul>
                  </div> ";                  
                    }

</div>              
              </div>
            </div>
          </div>

<?php
      } 
      ?>
      <?php            
       if($seaccesoin=='SI' or $sgseguridad=='SI' or $sgaccesocontrolado=='SI' or $cerecepcion=='SI' or $ambpisina=='SI' or $espsalonmultiple=='SI' or $cesauna=='SI' or $friendly=='SI' or $condemascota=='SI' or $cecanchabasquet=='SI' or $esplobby=='SI' or $asadorx=='SI' or $restaurant=='SI' or $ceestavisitante=='SI' or $sgbarriocerrado=='SI' or $ceoficina=='SI' or $cejinfantiles=='SI' or $ambjacuzzi=='SI' or $terraza=='SI' or $ceplaya=='SI' or $cecaliente=='SI' or $segasnatural=='SI' or $ceacine=='SI' or $cecanchamultiple=='SI' or $ceaccesointernet=='SI' or $espsalonfiesta=='SI' or $cegimnasio=='SI' or $sgsistemacontrainc=='SI') {          
              ?>

<hr class="mt-4 mb-4 mb-sm-5 mt-sm-5">
          <div class="property-features">
            <div class="row">
              <div class="col-sm-3 mb-3 mb-sm-0">
                <h5>Amenities</h5>
              </div>
              <div class="col-sm-9">
                <div class="row">              
               <?php
                  if($ceasensor=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Elevator</li>                  
                    </ul>
                  </div> ";                  
                    }

if($sgseguridad=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Security 24/7</li>                  
                    </ul>
                  </div> ";                  
                    }

if($sgaccesocontrolado=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Controlled Access 24/7</li>                  
                    </ul>
                  </div> ";                  
                    }

if($cerecepcion=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Reception 24/7</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ambpisina=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Swimming Pool</li>                  
                    </ul>
                  </div> ";                  
                    }

if($espsalonmultiple=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Múltiple Uses Area</li>                  
                    </ul>
                  </div> ";                  
                    }

if($cesauna=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Spa- Wellness Area</li>                  
                    </ul>
                  </div> ";                  
                    }

if($friendly=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Pet Friendly</li>                  
                    </ul>
                  </div> ";                  
                    }

if($condemascota=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Pet spaces</li>                  
                    </ul>
                  </div> ";                  
                    }

if($cecanchabasquet=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Golf course</li>                  
                    </ul>
                  </div> ";                  
                    }

if($esplobby=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Solarium</li>                  
                    </ul>
                  </div> ";                  
                    }

if($asadorx=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>BBQ</li>                  
                    </ul>
                  </div> ";                  
                    }

if($restaurant=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Snack bar - Restaurant</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ceestavisitante=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Parking</li>                  
                    </ul>
                  </div> ";                  
                    }

if($sgbarriocerrado=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Gated Community</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ceoficina=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Business center</li>                  
                    </ul>
                  </div> ";                  
                    }

if($cejinfantiles=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Kids club</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ambjacuzzi=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Jacuzzi</li>                  
                    </ul>
                  </div> ";                  
                    }

if($terraza=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Rooftop</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ceplaya=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Access to Beach Club</li>                  
                    </ul>
                  </div> ";                  
                    }

if($cecaliente=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Beach Club Benefits</li>                  
                    </ul>
                  </div> ";                  
                    }

if($segasnatural=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Natural well</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ceacine=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Natural Areas</li>                  
                    </ul>
                  </div> ";                  
                    }

if($cecanchamultiple=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Sports courts</li>                  
                    </ul>
                  </div> ";                  
                    }

if($ceaccesointernet=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Wi-Fi in common areas</li>                  
                    </ul>
                  </div> ";                  
                    }

if($espsalonfiesta=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Events room</li>                  
                    </ul>
                  </div> ";                  
                    }

if($cegimnasio=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Gym</li>                  
                    </ul>
                  </div> ";                  
                    }

if($sgsistemacontrainc=='SI'){
                    echo "
                  <div class='col-sm-4'>
                     <ul class='property-list-style-2 list-unstyled mb-0'>
                      <li>Security Cameras</li>                  
                    </ul>
                  </div> ";                  
                    }

?>            
                 </div>              
              </div>
            </div>
          </div>
                   <?php
      } 
      ?>
     
			
         
        
<!--
          <hr class="mt-4 mb-4 mb-sm-5 mt-sm-5">
          <div class="property-nearby">
            <div class="row">
              <div class="col-sm-3 mb-3 mb-sm-0">
                <h5>Que hay cerca</h5>
              </div>
              <div class="col-sm-9">
                <div class="nearby-info mb-4">
                  <span class="nearby-title mb-2 d-block text-info">
                    <i class="fas fa-graduation-cap me-2"></i><b>Educación</b>
                  </span>
                  <div class="nearby-list">
                    <ul class="property-list list-unstyled mb-0">

<?php
$type='school';
$radio='1500';
// $url='https://maps.googleapis.com/maps/api/place/nearbysearch/json?location='.$lat.'%2C'.$lon.'&radius='.$radio.'&type='.$type.'&key=AIzaSyByB8HRZtUv1KtXLqprR4oRsQ9BXafTDoY';
$curl = curl_init();
curl_setopt_array($curl, array(
  CURLOPT_URL => $url,
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => '',
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 0,
  CURLOPT_FOLLOWLOCATION => true,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => 'GET',
));
$response = curl_exec($curl);

</ul>
                  </div>
                </div>
                <div class="nearby-info mb-4">
                  <span class="nearby-title mb-2 d-block text-success">
                    <i class="fas fa-user-md me-2"></i><b>Salud y Medicina</b>
                  </span>
                  <div class="nearby-list">
                    <ul class="property-list list-unstyled mb-0">

<?php
                        $type='hospital';
                        $radio='1500';
                    //   $url='https://maps.googleapis.com/maps/api/place/nearbysearch/json?location='.$lat.'%2C'.$lon.'&radius='.$radio.'&type='.$type.'&key=AIzaSyByB8HRZtUv1KtXLqprR4oRsQ9BXafTDoY';
                        $curl = curl_init();
                        curl_setopt_array($curl, array(
                          CURLOPT_URL => $url,
                          CURLOPT_RETURNTRANSFER => true,
                          CURLOPT_ENCODING => '',
                          CURLOPT_MAXREDIRS => 10,
                          CURLOPT_TIMEOUT => 0,
                          CURLOPT_FOLLOWLOCATION => true,
                          CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
                          CURLOPT_CUSTOMREQUEST => 'GET',
                        ));
                        $response = curl_exec($curl);

curl_close($curl);
                        $response = json_decode($response, true);
                        foreach ($response["results"] as $valor) {
                          
                           $name = $valor["name"];
                           $rating = $valor["rating"];
                           $geometrylat = $valor["geometry"]["location"]["lat"];
                           $geometrylng = $valor["geometry"]["location"]["lng"];
                           $ksm=distance($lat,$lon,$geometrylat,$geometrylng);
                           $ksm=round($ksm, 2);
                           $rating=round($rating);
                            echo "

</ul>
                  </div>
                </div>
                <div class="nearby-info">
                  <span class="nearby-title mb-2 d-block text-danger">
                    <i class="fas fa-bus-alt me-2"></i><b>Transporte</b>
                  </span>
                  <div class="nearby-list">
                    <ul class="property-list list-unstyled mb-0">
                      <?php
                        $type='transit_station';
                        $radio='1500';
                  //   $url='https://maps.googleapis.com/maps/api/place/nearbysearch/json?location='.$lat.'%2C'.$lon.'&radius='.$radio.'&type='.$type.'&key=AIzaSyByB8HRZtUv1KtXLqprR4oRsQ9BXafTDoY';
                        $curl = curl_init();
                        curl_setopt_array($curl, array(
                          CURLOPT_URL => $url,
                          CURLOPT_RETURNTRANSFER => true,
                          CURLOPT_ENCODING => '',
                          CURLOPT_MAXREDIRS => 10,
                          CURLOPT_TIMEOUT => 0,
                          CURLOPT_FOLLOWLOCATION => true,
                          CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
                          CURLOPT_CUSTOMREQUEST => 'GET',
                        ));
                        $response = curl_exec($curl);

</ul>
                  </div>
                </div>

<div class="nearby-info">
                  <span class="nearby-title mb-2 d-block text-success" >
                    <i class="fa fa-shopping-cart me-2"></i><b>Supermercado</b>
                  </span>
                  <div class="nearby-list">
                    <ul class="property-list list-unstyled mb-0">
                      <?php
                        $type='supermarket';
                        $radio='1500';
                     //  $url='https://maps.googleapis.com/maps/api/place/nearbysearch/json?location='.$lat.'%2C'.$lon.'&radius='.$radio.'&type='.$type.'&key=AIzaSyByB8HRZtUv1KtXLqprR4oRsQ9BXafTDoY';
                        $curl = curl_init();
                        curl_setopt_array($curl, array(
                          CURLOPT_URL => $url,
                          CURLOPT_RETURNTRANSFER => true,
                          CURLOPT_ENCODING => '',
                          CURLOPT_MAXREDIRS => 10,
                          CURLOPT_TIMEOUT => 0,
                          CURLOPT_FOLLOWLOCATION => true,
                          CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
                          CURLOPT_CUSTOMREQUEST => 'GET',
                        ));
                        $response = curl_exec($curl);

</ul>
                  </div>
                </div>

</div>
            </div>
          </div>
        -->

</div>
      </div>
    </div>
  </section>

<section class="space-pt">
  <div class="container">
    <hr class="mb-5 mt-0">
    <h5 class="mb-4">Similar properties</h5>
    <div class="row">

<?php
      $sql=$conex->query ("SELECT ciudadactiva,cppreciousd,cptitulopublicacionen,cpdescripcionen,cpestados,cptitulopublicacion,cpdireccion,cpprecio,cpcamas,cphabitaciones,cpbanos,cpsuperficietotal,fecha,imagenprincipal,id,cptipo,cpcategoria,cpagencia,cpagente FROM inmueble  where status='1' and cpcategoria='$cpcategoria' and id!=$id limit 3" ) or die(mysqli_error());   
      if($row_cnt = $sql->num_rows>0) {       
      while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) {
        $idpub=$row{'id'};
        $cptitulopublicacion=$row{'cptitulopublicacion'};
        $cpprecio=$row{'cpprecio'};
        $cppreciousd=$row{'cppreciousd'};
        $cpdireccion=$row{'cpdireccion'};
        $cpcamas=$row{'cpcamas'};
        $cphabitaciones=$row{'cphabitaciones'};
        $cpbanos=$row{'cpbanos'};
        $cpsuperficietotal=$row{'cpsuperficietotal'};
        $fecha=$row{'fecha'};
        $imagenprincipal=$row{'imagenprincipal'};
        $cptipo=$row{'cptipo'};
        $cpcategoria=$row{'cpcategoria'};
        $cpagencia=$row{'cpagencia'};
        $cpagente=$row{'cpagente'};
        $cpestado=$row{'cpestados'};
        $ciudadactiva=$row{'ciudadactiva'};
        
        if($cpprecio=='')$cpprecio=$cppreciousd*$tasa;
        if($cppreciousd=='')$cppreciousd=$cpprecio/$tasa;

$cptitulopublicacionen=$row{'cptitulopublicacionen'};
        $cpdescripcionen=$row{'cpdescripcionen'};

$cpprecio = number_format($cpprecio);
        $cppreciousd = number_format($cppreciousd);

$cpcategoriax='';
     $sqls=$conex->query ("SELECT * FROM categoria  where id='$cpcategoria' limit 1" ) or die(mysqli_error());   
     if($row_cnt = $sqls->num_rows>0) {       
     while ($rows = $sqls->fetch_array(MYSQLI_ASSOC) ) { 
        $cpcategoriax=$rows{'nombre'};
       }
      }

$cptipox='';
     $sqls=$conex->query ("SELECT * FROM tipo  where id='$cptipo' limit 1" ) or die(mysqli_error());   
     if($row_cnt = $sqls->num_rows>0) {       
     while ($rows = $sqls->fetch_array(MYSQLI_ASSOC) ) { 
        $cptipox=$rows{'nombre'};
       }
      }

$cpagentex='';
    $cpagentefx='';
     $sqls=$conex->query ("SELECT * FROM agente where id='$cpagente' limit 1" ) or die(mysqli_error());   
     if($row_cnt = $sqls->num_rows>0) {       
     while ($rows = $sqls->fetch_array(MYSQLI_ASSOC) ) { 
        $cpagentenx=$rows{'nombre'};
        $cpagenteax=$rows{'apellido'};
        $cpagentefx=$rows{'foto'};

$cpagentex=$cpagentenx.' '.$cpagenteax;
       }
      }

$cpagenciax='';    
     $sqls=$conex->query ("SELECT * FROM agencia where id='$cpagencia' limit 1" ) or die(mysqli_error());   
     if($row_cnt = $sqls->num_rows>0) {       
     while ($rows = $sqls->fetch_array(MYSQLI_ASSOC) ) { 
        $cpagenciax=$rows{'nombre'};       
       }
      }

$stadonm='';
                        $sqlx=$conex->query ("SELECT * FROM states where id='$cpestados' ") or die(mysqli_error());
                    if($row_cnt = $sqlx->num_rows>0) {       
                    while ($rowx = $sqlx->fetch_array(MYSQLI_ASSOC) ) { 
                            $estadonm=$rowx{'description'};
                        }
                      }
                      
                      
                        $sqls=$conex->query ("SELECT * FROM ciudadactiva where id='$ciudadactiva'" ) or die(mysqli_error());   
     if($row_cnt = $sqls->num_rows>0) {       
     while ($rows = $sqls->fetch_array(MYSQLI_ASSOC) ) { 
        $ciudadactiva=$rows{'nombre'};       
       }
      }

echo "
 <div class='col-md-4'>
        <div class='property-item'>
		 <a  href='propiedad.php?id=$idpub&n=$cptitulopublicacionen'>
          <div class='property-image bg-overlay-gradient-04'>
		  
            <img class='img-fluid' src='../publicaciones/$imagenprincipal' style='width: 400px;height: 300px;' alt=''>
			
            <div class='property-lable'>
              <span class='badge badge-md bg-primary'>$cpcategoriax</span>
              <span class='badge badge-md' style='background-color:#192359;'>$cptipox </span>
            </div>

</div>
		  </a>
          <div class='property-details'>
            <div class='property-details-inner'>
              <h5 class='property-title'><a href='propiedad.php?id=$idpub&n=$cptitulopublicacionen'>$cptitulopublicacionen</a></h5>
              <span class='property-address' style='color:black;'><i class='fas fa-map-marker-alt fa-xs'></i>$ciudadactiva</span>
             
              <div class='property-price'><span style='color:black;'>$</span>$cpprecio<span style='color:black;'> MXN</span>
                 </br>
                  <span>$ $cppreciousd USD</span>
             </div>
              
            </div>
            <div class='property-btn'>
              <a class='property-link' href='propiedad.php?id=$idpub&n=$cptitulopublicacionen'>See details</a>

</div>
          </div>
        </div>
      </div>
";
         }
      } 
      ?>

</div>
  </div>
</section>

</div>

<?php
include 'banner.php';
include 'footer.php';
?>
	<div class="overlay">
        <img style="position: absolute; z-index: 9999;"  src="" alt="Imagen en detalle" class="overlay-image" id="zoomed-image">
        <span class="close-btn" id="close-btn">&times;</span>
    </div>

<script type="text/javascript">

</script>

<script src="js/slick/slick.min.js"></script>
  <script src="js/datetimepicker/moment.min.js"></script>
  <script src="js/datetimepicker/datetimepicker.min.js"></script>

<script src="js/custom.js"></script>

galleryImages.forEach((image) => {
    image.addEventListener('dblclick', () => {
        overlay.style.display = 'flex';
        zoomedImage.src = image.id;
    });
});

overlay.addEventListener('click', () => {
    overlay.style.display = 'none';
});

zoomedImage.addEventListener('click', (event) => {
    event.stopPropagation();
});

closeBtn.addEventListener('click', () => {
    overlay.style.display = 'none';
});

</script>

</body>
</html>

Ubuntu

Sid Gifari From Gifari Industries - BD Cyber Security Team



Ubuntu

Sid Gifari From Gifari Industries - BD Cyber Security Team