<?php include 'admin/includes/db_config.php';
if($_GET['cat']==1) { $page="rent"; }
if($_GET['cat']==2) { $page="sale"; }?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Top Notch Real Estate</title>
<link href="css/bootstrap.css" rel="stylesheet">
<link href="css/revolution-slider.css" rel="stylesheet">
<link href="css/jquery-ui.css" rel="stylesheet">
<link href="css/style.css" rel="stylesheet">
<link rel="shortcut icon" href="images/favicon.png" type="image/x-icon">
<link rel="icon" href="images/favicon.png" type="image/x-icon">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0">
<link href="css/responsive.css" rel="stylesheet">
<link href="css/home.css" rel="stylesheet">
<link href="css/search.css" rel="stylesheet">
<link href="https://fonts.googleapis.com/css?family=Open+Sans:400,600,700&display=swap" rel="stylesheet">
<link rel="stylesheet" type="text/css" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<!--<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">-->
</head>
<style>
      .property-block-grid .lower-content{
          
          min-height:255px;
      }
  </style>
<body>
<div class="page-wrapper">
 	
  <?php include 'header.php';?>
    
   <section class="page-title" style="background-image:url(images/background/image-6.jpg);">
<!--        <div class="overlay-layer"></div>-->
        <div class="auto-container" style="max-width:400px;background-color: rgba(0, 0, 0, 0.6);">
            <div class="content-box">
                <h2>Properties for <?php if($_GET['cat']==1) {?>Rent<?php } if($_GET['cat']==2) { ?>Sell<?php }?> </h2>
                
            </div>
        </div>
    </section>
     
  <!--   <section class="page-info">
        <div class="auto-container">
            <div class="breadcrumb-outer">
                <ul class="bread-crumb clearfix">
                    <li><a href="index.php">Home</a></li>
                    <li class="active"><?php if($_GET['cat']==1) {?>Rental<?php } if($_GET['cat']==2) { ?>Buy<?php }?> Properties</li>
                </ul>
            </div>
        </div>
    </section>-->
     <?php include 'property-search-rent-sale.php';?>
       <section class="property-to-sell">
    	<div class="auto-container">
        	
        	<div class="">
               <?php include 'left-properties.php';?>
                <div class="col-md-9 col-sm-12 col-xs-12">
                
                 <div class="tab-content">
                            <div role="tabpanel" class="tab-pane active" id="grid">
                                <div class="show-property-area">
                                    <div class="row">
                                       
                                       <?php $cat=$_GET['cat']; $cat1=$_GET['cat1'];$type1=$_GET['type'];
										if($type1==""){
											//echo("select * from tbl_property where statuss=0 and category='$cat' and category1='$cat1'  order by bedrooms");
					$sel_prop=mysqli_query($con,"select * from tbl_property where statuss=0 and category='$cat' and category1='$cat1'  order by bedrooms");
											
										}
										else
										{
											//echo("select * from tbl_property where statuss=0 and category='$cat' and category1='$cat1' and type='$type1'  order by bedrooms");	
										$sel_prop=mysqli_query($con,"select * from tbl_property where statuss=0 and category='$cat' and category1='$cat1' and type='$type1'  order by bedrooms");	
										}
										$num=mysqli_num_rows($sel_prop);
						if($num>=1) {
				while($res_prop=mysqli_fetch_array($sel_prop))
					{ 
					$proid=$res_prop['propertyid'];
						
					?>
                                      <div class="property-block-grid col-lg-6 col-md-6 col-xs-12 mix mix_all" style="display: inline-block;">
                                           <div class="inner-box">
                                               <div class="image-box">
                                                   <?php 
						$sel_prop_gallery=mysqli_query($con,"select * from  tbl_property_imagegallery where property='$proid' order by galleryid");
					$res_prop_gallery=mysqli_fetch_array($sel_prop_gallery);
						?>
						    <figure class="image">
                              <img src="<?php echo $site_url;?>images/propertygallery/<?php echo $res_prop_gallery['image'];?>" alt="" style="width:500px;height:240px;">
                              
<!--                                <img src="images/propertygallery/<?php echo $res_prop_gallery['image'];?>&h=240&w=372" alt="">-->
                            
                            </figure>
                                                    <div class="ribbon"><?php $cat=$res_prop['category'];
					$sel_prop_category=mysqli_query($con,"select * from  tbl_category where categoryid=$cat");
					$res_prop_category=mysqli_fetch_array($sel_prop_category); echo $res_prop_category['title'];
						?></div>
                                                  <a href="property-details.php?pid=<?php echo $proid;?>" class="read-more-link">Read More</a>
                        </div>
                        <div class="lower-content">
<!--                            <h3><a href=""><?php echo $res_prop['title'];?></a></h3>-->
                            <h3><a href=""><?php echo $res_prop['name'];?></a></h3>
                            <div class="price">AED  <?php 
						echo number_format($res_prop['price']);?></div>
                            <div class="desc-text"><i class="fa fa-map-marker"></i> <?php $loc=$res_prop['location'];
						$sel_prop_location=mysqli_query($con,"select * from  tbl_location where locationid=$loc");
					$res_prop_location=mysqli_fetch_array($sel_prop_location); echo $res_prop_location['location'];
						?> / <?php $city=$res_prop['city'];
						$sel_prop_city=mysqli_query($con,"select * from  tbl_city where cityid=$city");
					$res_prop_city=mysqli_fetch_array($sel_prop_city); echo $res_prop_city['city'];?> </div>
                            <!--Specs List-->
                            <ul class="specs-list clearfix">
                               <?php if($res_prop['category1']==1) {?>
                                <li><div class="outer"><div class="icon"><span class="fa fa-expand"></span></div><div class="info"><?php echo number_format($res_prop['area']);?> sq ft</div></div></li>
                                 <!--<li><div class="outer"><div class="icon"><span class="fa fa-car"></span></div><div class="info"> Parking</div></div></li>-->
                                 <?php } if($res_prop['category1']==2) {?>
                                  <li><div class="outer"><div class="icon"><span class="fa fa-expand"></span></div><div class="info"><?php echo number_format($res_prop['area']);?> sq ft</div></div></li>
                                  <!--<li><div class="outer"><div class="icon"><span class="fa fa-car"></span></div><div class="info"><?php if($res_prop['garage']==0){ echo "No"; } else { echo $res_prop['garage'];}?> Parking</div></div></li>-->
                                <li><div class="outer"><div class="icon"><span class="fa fa-bed"></span></div><div class="info"><?php if($res_prop['bedrooms']==0){ echo "Studio"; } else { echo $res_prop['bedrooms']. " Bedroom";}?></div></div></li>
                                <li><div class="outer"><div class="icon"><i class="fa fa-bath"></i></div><div class="info"><?php echo $res_prop['bathrooms'];?> Bathrooms</div></div></li>
                                
                                <?php } ?>
                            </ul>
                           
                        </div>
                                             
                                            </div>
                                        </div>
                                       
                                         <?php } } else {?>
                                        <p style="color: #DB171A;
    text-align: center;
    font-weight: 600;
    margin-top: 15px;">No property available, Please Contact +971 50 144 9700</p>
                                                   
                                                                      <?php }  ?>                   
                                    </div>
                                </div>
                            </div>
                            
                          </div>
                
                
				</div>
        	</div>
        </div>
    </section>
     
     <?php include 'footer.php';?>
      
</div>
<!--End pagewrapper-->

<!--Scroll to top-->
<!--<div class="scroll-to-top scroll-to-target" data-target="html"><span class="icon fa fa-long-arrow-up"></span></div>-->

<script src="js/jquery-1.12.0.min.js"></script>
<!--<script src="js/jquery.js"></script> -->
<script src="js/bootstrap.min.js"></script>
<script src="js/jquery-ui.js"></script>
<script src="js/bxslider.js"></script>
<script src="js/jquery.fancybox.pack.js"></script>
<script src="js/jquery.fancybox-media.js"></script>
<script src="js/validate.js"></script>
<script src="js/owl.js"></script>
<script src="js/wow.js"></script>
<script src="js/script.js"></script>
</body>

<!-- Mirrored from themexriver.com/shelter/index.html by HTTrack Website Copier/3.x [XR&CO'2014], Tue, 17 Dec 2019 04:49:10 GMT -->
</html>
