Tul xxx Tul

Viewing: index.php

<?php 
ini_set('session.cache_limiter','public');
session_cache_limiter(false);
session_start();
include("config.php");

function pd_has_value($value) {
	$value = trim((string)$value);
	if ($value === '') {
		return false;
	}
	if (is_numeric($value) && (float)$value == 0.0) {
		return false;
	}
	return true;
}

$citiesResult = mysqli_query($con, "SELECT DISTINCT city FROM property WHERE city IS NOT NULL AND city != '' ORDER BY city ASC");
$cities = [];
if ($citiesResult) {
	while ($cityRow = mysqli_fetch_assoc($citiesResult)) {
		$cities[] = $cityRow['city'];
	}
}

$statesResult = mysqli_query($con, "SELECT DISTINCT TRIM(state) AS state FROM property WHERE state IS NOT NULL AND state != '' ORDER BY TRIM(state) ASC");
$states = [];
if ($statesResult) {
	while ($stateRow = mysqli_fetch_assoc($statesResult)) {
		if(isset($stateRow['state']) && $stateRow['state'] !== '') {
			$states[] = $stateRow['state'];
		}
	}
}

$typesResult = mysqli_query($con, "SELECT DISTINCT type FROM property WHERE type IS NOT NULL AND type != '' ORDER BY type ASC");
$types = [];
if ($typesResult) {
	while ($typeRow = mysqli_fetch_assoc($typesResult)) {
		$types[] = $typeRow['type'];
	}
}

$typeLabels = [
	'apartment' => 'Apartamento',
	'flat'      => 'Piso',
	'building'  => 'Edificio',
	'house'     => 'Casa',
	'villa'     => 'Villa',
	'office'    => 'Oficina',
];

$stypesResult = mysqli_query($con, "SELECT DISTINCT stype FROM property WHERE stype IS NOT NULL AND stype != '' ORDER BY stype ASC");
$stypes = [];
if ($stypesResult) {
	while ($stypeRow = mysqli_fetch_assoc($stypesResult)) {
		$stypes[] = $stypeRow['stype'];
	}
}

$stypeLabels = [
	'rent' => 'Alquiler',
	'sale' => 'Venta',
];
							
?>
<!DOCTYPE html>
<html lang="en">

<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

<!-- Meta Tags -->
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<link rel="shortcut icon" type="image/png" href="images/logo/logo.png">

<!--	Fonts
	========================================================-->
<link href="https://fonts.googleapis.com/css?family=Muli:400,400i,500,600,700&amp;display=swap" rel="stylesheet">
<link href="https://fonts.googleapis.com/css?family=Comfortaa:400,700" rel="stylesheet">

<!--	Css Link
	========================================================-->
<link rel="stylesheet" type="text/css" href="css/bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="css/bootstrap-slider.css">
<link rel="stylesheet" type="text/css" href="css/jquery-ui.css">
<link rel="stylesheet" type="text/css" href="css/layerslider.css">
<link rel="stylesheet" type="text/css" href="css/color.css" id="color-change">
<link rel="stylesheet" type="text/css" href="css/owl.carousel.min.css">
<link rel="stylesheet" type="text/css" href="css/font-awesome.min.css">
<link rel="stylesheet" type="text/css" href="fonts/flaticon/flaticon.css">
<link rel="stylesheet" type="text/css" href="css/style.css">

<!--	Title
	=========================================================-->
<title>Inmobiliaria PHP</title>
</head>
<body>

<!--	Page Loader  -->
<!--<div class="page-loader position-fixed z-index-9999 w-100 bg-white vh-100">
	<div class="d-flex justify-content-center y-middle position-relative">
	  <div class="spinner-border" role="status">
		<span class="sr-only">Loading...</span>
	  </div>
	</div>
</div>  -->
<!--	Page Loader  -->

<div id="page-wrapper">
    <div class="row"> 
        <!--	Header start  -->
		<?php include("include/header.php");?>
        <!--	Header end  -->
		
        <!--	Banner Start   -->
        <div class="overlay-black w-100 slider-banner1 position-relative" style="background-image: url('images/banner/rshmpg.jpg'); background-size: cover; background-position: center center; background-repeat: no-repeat;">
            <div class="container h-100">
                <div class="row h-100 align-items-center">
                    <div class="col-lg-12">
                        <div class="text-white">
                            <h1 class="mb-4"><span class="text-success">Déjanos</span><br>
                            Guiarte a Casa</h1>
                            <form method="post" action="propertygrid.php">
                                <div class="row">
                                    <div class="col-md-6 col-lg-2">
                                        <div class="form-group">
                                            <select class="form-control" name="type">
                                                <option value="">Seleccionar Tipo</option>
                                                <?php foreach ($types as $t): ?>
                                                <option value="<?php echo htmlspecialchars($t, ENT_QUOTES); ?>">
                                                    <?php echo isset($typeLabels[$t]) ? $typeLabels[$t] : ucfirst($t); ?>
                                                </option>
                                                <?php endforeach; ?>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-6 col-lg-2">
                                        <div class="form-group">
                                            <select class="form-control" name="stype">
                                                <option value="">Seleccionar Estado</option>
                                                <?php foreach ($stypes as $st): ?>
                                                <option value="<?php echo htmlspecialchars($st, ENT_QUOTES); ?>">
                                                    <?php echo isset($stypeLabels[$st]) ? $stypeLabels[$st] : ucfirst($st); ?>
                                                </option>
                                                <?php endforeach; ?>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-6 col-lg-2">
                                        <div class="form-group">
                                            <select class="form-control" name="state">
                                                <option value="">Seleccionar Departamento</option>
                                                <?php foreach ($states as $stateName): ?>
                                                <option value="<?php echo htmlspecialchars($stateName, ENT_QUOTES); ?>"><?php echo htmlspecialchars($stateName); ?></option>
                                                <?php endforeach; ?>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-6 col-lg-4">
                                        <div class="form-group">
                                            <select class="form-control" name="city">
                                                <option value="">Seleccionar Ciudad</option>
                                                <?php foreach ($cities as $cityName): ?>
                                                <option value="<?php echo htmlspecialchars($cityName, ENT_QUOTES); ?>"><?php echo htmlspecialchars($cityName); ?></option>
                                                <?php endforeach; ?>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-6 col-lg-2">
                                        <div class="form-group">
                                            <button type="submit" name="filter" class="btn btn-success w-100">Buscar Propiedad</button>
                                        </div>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <!--	Banner End  -->
        
        <!--	Recent Properties  -->
        <div class="full-row">
            <div class="container">
                <div class="row">
                    <div class="col-md-12">
                        <h2 class="text-secondary double-down-line text-center mb-4">Propiedades Disponibles</h2>
                    </div>
                    <!--- <div class="col-md-6">
                        <ul class="nav property-btn float-right" id="pills-tab" role="tablist">
                            <li class="nav-item"> <a class="nav-link py-3 active" id="pills-home-tab" data-toggle="pill" href="#pills-home" role="tab" aria-controls="pills-home" aria-selected="true">New</a> </li>
                            <li class="nav-item"> <a class="nav-link py-3" id="pills-profile-tab" data-toggle="pill" href="#pills-profile" role="tab" aria-controls="pills-profile" aria-selected="false">Featured</a> </li>
                            <li class="nav-item"> <a class="nav-link py-3" id="pills-contact-tab2" data-toggle="pill" href="#pills-contact" role="tab" aria-controls="pills-contact" aria-selected="false">Top Sale</a> </li>
                            <li class="nav-item"> <a class="nav-link py-3" id="pills-contact-tab3" data-toggle="pill" href="#pills-resturant" role="tab" aria-controls="pills-contact" aria-selected="false">Best Sale</a> </li>
                        </ul>
                    </div> --->
                    <div class="col-md-12">
                        <div class="tab-content mt-4" id="pills-tabContent">
                            <div class="tab-pane fade show active" id="pills-home" role="tabpanel" aria-labelledby="pills-home">
                                <div class="row">
                                
                                    <?php 
                                    $query=mysqli_query($con,"SELECT p.*, COALESCE(u.uname,'Admin') AS uname, u.utype, u.uimage FROM `property` p LEFT JOIN `user` u ON p.uid=u.uid WHERE p.status='available' ORDER BY p.date DESC LIMIT 9");
                                    
                                    if(mysqli_num_rows($query) > 0) {
                                        while($row=mysqli_fetch_array($query))
                                        {
                                    ?>

                                    <div class="col-md-6 col-lg-4">
                                        <a href="propertydetail.php?pid=<?php echo $row['0'];?>" class="featured-thumb hover-zoomer mb-4 d-block" style="text-decoration:none;color:inherit;">
                                            <?php
										$thumbSrc = '';
										foreach (['18', '19', '20', '21', '22'] as $imgField) {
											$filename = isset($row[$imgField]) ? trim((string)$row[$imgField]) : '';
											if ($filename === '') {
												continue;
											}
											$filePath = __DIR__ . DIRECTORY_SEPARATOR . 'admin' . DIRECTORY_SEPARATOR . 'property' . DIRECTORY_SEPARATOR . $filename;
											if (!is_file($filePath)) {
												continue;
											}
											$thumbSrc = 'admin/property/' . $filename;
											break;
										}
									?>
                                            <div class="overlay-black overflow-hidden position-relative">
										<?php if ($thumbSrc !== '') { ?>
										<img src="<?php echo htmlspecialchars($thumbSrc, ENT_QUOTES); ?>" alt="pimage">
										<?php } else { ?>
										<div style="height: 250px; background: #f3f4f6;"></div>
										<?php } ?>
                                                <div class="featured bg-success text-white">Nuevo</div>
										<?php if (pd_has_value($row['5'])) { ?>
                                                <div class="sale bg-success text-white text-capitalize">En <?php echo $row['5'];?></div>
										<?php } ?>
										<?php if (pd_has_value($row['13']) || pd_has_value($row['12'])) { ?>
                                                <div class="price text-primary">
												<?php if (pd_has_value($row['13'])) { ?><b>$<?php echo $row['13'];?> </b><?php } ?>
												<?php if (pd_has_value($row['12'])) { ?><span class="text-white"><?php echo $row['12'];?> Sqft</span><?php } ?>
											</div>
										<?php } ?>
                                            </div>
                                            <div class="featured-thumb-data shadow-one">
                                                <div class="p-3">
                                                    <h5 class="text-secondary hover-text-success mb-2 text-capitalize"><?php echo $row['1'];?></h5>
											<?php if (pd_has_value($row['14'])) { ?>
                                                    <span class="location text-capitalize"><i class="fas fa-map-marker-alt text-success"></i> <?php echo $row['14'];?></span>
											<?php } ?>
                                                </div>
											<?php
												$hasQuantity = pd_has_value($row['12']) || pd_has_value($row['6']) || pd_has_value($row['7']) || pd_has_value($row['9']) || pd_has_value($row['8']);
											?>
											<?php if ($hasQuantity) { ?>
											<div class="bg-gray quantity px-4 pt-4">
                                                    <ul>
													<?php if (pd_has_value($row['12'])) { ?><li><span><?php echo $row['12'];?></span> Sqft</li><?php } ?>
													<?php if (pd_has_value($row['6'])) { ?><li><span><?php echo $row['6'];?></span> Habitaciones</li><?php } ?>
													<?php if (pd_has_value($row['7'])) { ?><li><span><?php echo $row['7'];?></span> Baños</li><?php } ?>
													<?php if (pd_has_value($row['9'])) { ?><li><span><?php echo $row['9'];?></span> Cocina</li><?php } ?>
													<?php if (pd_has_value($row['8'])) { ?><li><span><?php echo $row['8'];?></span> Balcón</li><?php } ?>
                                                    </ul>
                                                </div>
											<?php } ?>
                                                <div class="p-4 d-inline-block w-100">
                                                    <div class="float-left text-capitalize"><i class="fas fa-user text-success mr-1"></i>Por : <?php echo $row['uname'];?></div>
                                                    <div class="float-right"><i class="far fa-calendar-alt text-success mr-1"></i> <?php echo date('d-m-Y', strtotime($row['date']));?></div>
                                                </div>
                                            </div>
                                        </a>
                                    </div>
                                    <?php 
                                        }
                                    } else { 
                                    ?>
                                    <div class="col-12">
                                        <div class="alert alert-info text-center p-5" role="alert">
                                            <i class="fas fa-home fa-3x mb-3 text-success"></i>
                                            <h4 class="alert-heading">¡No hay propiedades disponibles en este momento!</h4>
                                            <p class="mb-0">Estamos trabajando para traerte las mejores opciones. Por favor, vuelve pronto.</p>
                                        </div>
                                    </div>
                                    <?php } ?>

                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
		<!--	Recent Properties  -->

        <!--	Text Block One
		======================================================-->
        <div class="full-row bg-gray">
            <div class="container">
                <div class="row">
                    <div class="col-lg-12"><!-- FOR MORE PROJECTS visit: codeastro.com -->
                        <h2 class="text-secondary double-down-line text-center mb-5">Lo Que Hacemos</h2></div>
                </div>
                <div class="text-box-one">
                    <div class="row">
                        <div class="col-lg-3 col-md-6">
                            <div class="p-4 text-center hover-bg-white hover-shadow rounded mb-4 transation-3s"> 
								<i class="flaticon-rent text-success flat-medium" aria-hidden="true"></i>
                                <h5 class="text-secondary hover-text-success py-3 m-0"><a href="#">Servicio de Venta</a></h5>
                                <p>Ofrecemos servicios profesionales de venta de propiedades con asesoría personalizada...</p>
                            </div>
                        </div>
                        <div class="col-lg-3 col-md-6">
                            <div class="p-4 text-center hover-bg-white hover-shadow rounded mb-4 transation-3s"> 
								<i class="flaticon-for-rent text-success flat-medium" aria-hidden="true"></i>
                                <h5 class="text-secondary hover-text-success py-3 m-0"><a href="#">Servicio de Alquiler</a></h5>
                                <p>Facilitamos el alquiler de propiedades con contratos seguros y transparentes...</p>
                            </div>
                        </div>
                        <div class="col-lg-3 col-md-6">
                            <div class="p-4 text-center hover-bg-white hover-shadow rounded mb-4 transation-3s"> 
								<i class="flaticon-list text-success flat-medium" aria-hidden="true"></i>
                                <h5 class="text-secondary hover-text-success py-3 m-0"><a href="#">Listado de Propiedades</a></h5>
                                <p>Publicamos tu propiedad en nuestro portal con máxima visibilidad...</p>
                            </div>
                        </div>
                        <div class="col-lg-3 col-md-6">
                            <div class="p-4 text-center hover-bg-white hover-shadow rounded mb-4 transation-3s"> 
								<i class="flaticon-diagram text-success flat-medium" aria-hidden="true"></i>
                                <h5 class="text-secondary hover-text-success py-3 m-0"><a href="#">Inversión Legal</a></h5>
                                <p>Asesoría legal completa para inversiones inmobiliarias seguras...</p>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
		<!-----  Our Services  ---->
		
        <!--	Why Choose Us -->
        <div class="full-row living bg-one overlay-secondary-half" style="background-image: url('images/01.jpg'); background-size: cover; background-position: center center; background-repeat: no-repeat;">
            <div class="container">
                <div class="row">
                    <div class="col-md-12 col-lg-6">
                        <div class="living-list pr-4">
                            <h3 class="pb-4 mb-3 text-white">Por Qué Elegirnos</h3>
                            <ul>
                                <li class="mb-4 text-white d-flex"> 
									<i class="flaticon-reward flat-medium float-left d-table mr-4 text-success" aria-hidden="true"></i>
									<div class="pl-2">
										<h5 class="mb-3">Mejor Calificados</h5>
										<p>Somos una empresa con las mejores calificaciones y reseñas de nuestros clientes satisfechos.</p>
									</div>
                                </li>
                                <li class="mb-4 text-white d-flex"> 
									<i class="flaticon-real-estate flat-medium float-left d-table mr-4 text-success" aria-hidden="true"></i>
									<div class="pl-2">
										<h5 class="mb-3">Calidad Experimentada</h5>
										<p>Años de experiencia nos respaldan ofreciendo servicios de la más alta calidad.</p>
									</div>
                                </li>
                                <li class="mb-4 text-white d-flex"> 
									<i class="flaticon-seller flat-medium float-left d-table mr-4 text-success" aria-hidden="true"></i>
									<div class="pl-2">
										<h5 class="mb-3">Agentes Experimentados</h5>
										<p>Nuestro equipo de agentes profesionales está capacitado para atender todas tus necesidades.</p>
									</div>
                                </li>
                            </ul>
                        </div>
                    </div>
                </div>
            </div>
        </div>
		<!--	why choose us -->
		
		<!--	How it work -->
        <div class="full-row">
            <div class="container">
                <div class="row">
                    <div class="col-lg-12">
                        <h2 class="text-secondary double-down-line text-center mb-5">Cómo Funciona</h2>
                        </div>
                </div>
                <div class="row">
                    <div class="col-md-4">
                        <div class="icon-thumb-one text-center mb-5">
                            <div class="bg-success text-white rounded-circle position-absolute z-index-9">1</div>
                            <div class="left-arrow"><i class="flaticon-investor flat-medium icon-success" aria-hidden="true"></i></div>
                            <h5 class="text-secondary mt-5 mb-4">Discusión</h5>
                            <p>Conversamos contigo para entender tus necesidades y expectativas sobre la propiedad que buscas.</p>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="icon-thumb-one text-center mb-5">
                            <div class="bg-success text-white rounded-circle position-absolute z-index-9">2</div>
                            <div class="left-arrow"><i class="flaticon-search flat-medium icon-success" aria-hidden="true"></i></div>
                            <h5 class="text-secondary mt-5 mb-4">Revisión de Archivos</h5>
                            <p>Revisamos toda la documentación legal y técnica de la propiedad para garantizar transparencia.</p>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="icon-thumb-one text-center mb-5">
                            <div class="bg-success text-white rounded-circle position-absolute z-index-9">3</div>
                            <div><i class="flaticon-handshake flat-medium icon-success" aria-hidden="true"></i></div>
                            <h5 class="text-secondary mt-5 mb-4">Adquirir</h5>
                            <p>Te acompañamos en todo el proceso de adquisición hasta que obtengas las llaves de tu propiedad.</p>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        
        <!--	How It Work -->
        
        <!--	Achievement
        ============================================================-->
        <div class="full-row overlay-secondary" style="background-image: url('images/breadcromb.jpg'); background-size: cover; background-position: center center; background-repeat: no-repeat;">
            <div class="container">
                <div class="fact-counter">
                    <div class="row">
                        <div class="col-md-3">
                            <div class="count wow text-center  mb-sm-50" data-wow-duration="300ms"> <i class="flaticon-house flat-large text-white" aria-hidden="true"></i>
								<?php
										$query=mysqli_query($con,"SELECT count(pid) FROM property");
											while($row=mysqli_fetch_array($query))
												{
										?>
                                <div class="count-num text-success my-4" data-speed="3000" data-stop="<?php 
												$total = $row[0];
												echo $total;?>">0</div>
								<?php } ?>
                                <div class="text-white h5">Propiedades Disponibles</div>
                            </div>
                        </div>
						<div class="col-md-3">
                            <div class="count wow text-center  mb-sm-50" data-wow-duration="300ms"> <i class="flaticon-house flat-large text-white" aria-hidden="true"></i>
								<?php
										$query=mysqli_query($con,"SELECT count(pid) FROM property where stype='sale'");
											while($row=mysqli_fetch_array($query))
												{
										?>
                                <div class="count-num text-success my-4" data-speed="3000" data-stop="<?php 
												$total = $row[0];
												echo $total;?>">0</div>
								<?php } ?>
                                <div class="text-white h5">Propiedades en Venta</div>
                            </div>
                        </div>
						<div class="col-md-3">
                            <div class="count wow text-center  mb-sm-50" data-wow-duration="300ms"> <i class="flaticon-house flat-large text-white" aria-hidden="true"></i>
								<?php
										$query=mysqli_query($con,"SELECT count(pid) FROM property where stype='rent'");
											while($row=mysqli_fetch_array($query))
												{
										?>
                                <div class="count-num text-success my-4" data-speed="3000" data-stop="<?php 
												$total = $row[0];
												echo $total;?>">0</div>
								<?php } ?>
                                <div class="text-white h5">Propiedades en Alquiler</div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="count wow text-center  mb-sm-50" data-wow-duration="300ms"> <i class="flaticon-man flat-large text-white" aria-hidden="true"></i>
                                <?php
										$query=mysqli_query($con,"SELECT count(uid) FROM user");
											while($row=mysqli_fetch_array($query))
												{
										?>
                                <div class="count-num text-success my-4" data-speed="3000" data-stop="<?php 
												$total = $row[0];
												echo $total;?>">0</div>
								<?php } ?>
                                <div class="text-white h5">Usuarios Registrados</div>
                            </div>
                        </div>

                    </div>
                </div>
            </div>
        </div>
        
        <!--	Popular Place -->
        <div class="full-row bg-gray">
            <div class="container">
                <div class="row">
                    <div class="col-lg-12">
                        <h2 class="text-secondary double-down-line text-center mb-5">Lugares Populares</h2></div>
                </div><!-- FOR MORE PROJECTS visit: codeastro.com -->
                <div class="col-lg-12">
                    <div class="row">
                        <div class="col-md-6 col-lg-3 pb-1">
                            <div class="overflow-hidden position-relative overlay-secondary hover-zoomer mx-n13 z-index-9"> <img src="images/thumbnail4/1.jpg" alt="">
                                <div class="text-white xy-center z-index-9 position-absolute text-center w-100">
									<?php
										$query=mysqli_query($con,"SELECT count(state), property.* FROM property where city='Olisphis'");
											while($row=mysqli_fetch_array($query))
												{
										?>
                                    <h4 class="hover-text-success text-capitalize"><a href="stateproperty.php?id=<?php echo $row['17']?>"><?php echo $row['state'];?></a></h4>
                                    <span><?php 
												$total = $row[0];
												echo $total;?> Propiedades Listadas</span> </div>
									<?php } ?>
                            </div>
                        </div><!-- FOR MORE PROJECTS visit: codeastro.com -->
                        <div class="col-md-6 col-lg-3 pb-1">
                            <div class="overflow-hidden position-relative overlay-secondary hover-zoomer mx-n13 z-index-9"> <img src="images/thumbnail4/2.jpg" alt="">
                                <div class="text-white xy-center z-index-9 position-absolute text-center w-100">
									<?php
										$query=mysqli_query($con,"SELECT count(state), property.* FROM property where city='Awrerton'");
											while($row=mysqli_fetch_array($query))
												{
										?>
                                    <h4 class="hover-text-success text-capitalize"><a href="stateproperty.php?id=<?php echo $row['17']?>"><?php echo $row['state'];?></a></h4>
                                    <span><?php 
												$total = $row[0];
												echo $total;?> Propiedades Listadas</span> </div>
									<?php } ?>
                            </div>
                        </div>
                        <div class="col-md-6 col-lg-3 pb-1"><!-- FOR MORE PROJECTS visit: codeastro.com -->
                            <div class="overflow-hidden position-relative overlay-secondary hover-zoomer mx-n13 z-index-9"> <img src="images/thumbnail4/3.jpg" alt="">
                                <div class="text-white xy-center z-index-9 position-absolute text-center w-100">
                                    <?php
										$query=mysqli_query($con,"SELECT count(state), property.* FROM property where city='Floson'");
											while($row=mysqli_fetch_array($query))
												{
										?>
                                    <h4 class="hover-text-success text-capitalize"><a href="stateproperty.php?id=<?php echo $row['17']?>"><?php echo $row['state'];?></a></h4>
                                    <span><?php 
												$total = $row[0];
												echo $total;?> Propiedades Listadas</span> </div>
									<?php } ?>
                            </div>
                        </div>
                        <div class="col-md-6 col-lg-3 pb-1">
                            <div class="overflow-hidden position-relative overlay-secondary hover-zoomer mx-n13 z-index-9"> <img src="images/thumbnail4/4.jpg" alt="">
                                <div class="text-white xy-center z-index-9 position-absolute text-center w-100">
                                    <?php
										$query=mysqli_query($con,"SELECT count(state), property.* FROM property where city='Ulmore'");
											while($row=mysqli_fetch_array($query))
												{
										?>
                                    <h4 class="hover-text-success text-capitalize"><a href="stateproperty.php?id=<?php echo $row['17']?>"><?php echo $row['state'];?></a></h4>
                                    <span><?php 
												$total = $row[0];
												echo $total;?> Propiedades Listadas</span> </div>
									<?php } ?>
                            </div>
                        </div><!-- FOR MORE PROJECTS visit: codeastro.com -->
                    </div>
                </div>
            </div>
        </div>
        <!--	Popular Places -->
		
		<!--	Testonomial Section Removed -->
		
		
        <!--	Footer   start-->
		<?php include("include/footer.php");?>
		<!--	Footer   start-->
        
        
        <!-- Scroll to top --> 
        <a href="#" class="bg-success text-white hover-text-secondary" id="scroll"><i class="fas fa-angle-up"></i></a> 
        <!-- End Scroll To top --> 
    </div>
</div>
<!-- Wrapper End --> 

<!--	Js Link
============================================================--> 
<script src="js/jquery.min.js"></script> 
<!--jQuery Layer Slider --> 
<script src="js/greensock.js"></script> 
<script src="js/layerslider.transitions.js"></script> 
<script src="js/layerslider.kreaturamedia.jquery.js"></script> 
<!--jQuery Layer Slider --> 
<script src="js/popper.min.js"></script> 
<script src="js/bootstrap.min.js"></script> 
<script src="js/owl.carousel.min.js"></script> 
<script src="js/tmpl.js"></script> 
<script src="js/jquery.dependClass-0.1.js"></script> 
<script src="js/draggable-0.1.js"></script> 
<script src="js/jquery.slider.js"></script> 
<script src="js/wow.js"></script> 
<script src="js/YouTubePopUp.jquery.js"></script> 
<script src="js/validate.js"></script> 
<script src="js/jquery.cookie.js"></script> 
<script src="js/custom.js"></script>
</body>

</html>
User / IP	: 216.73.216.227
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64