   <!--Properties Section-->
    <section class="properties-section" style="padding-top:50px!important;">
    	<div class="auto-container">
        	<!--Title Style One-->
            <div class="title-style-one left-aligned">
                <div class="title"><h2>Properties For Sell</h2></div>
            </div>
            
            <!--Carousel-->
        	<div class="properties-carousel three-items-carousel">
			<?php 
					$sel_prop=mysqli_query($con,"select * from tbl_property where statuss=0 and category=2 order by propertyid desc limit 6");
					$num=mysqli_num_rows($sel_prop);
					if($num>=1) {
					while($res_prop=mysqli_fetch_array($sel_prop))
					{ 
//						print_r($res_prop);
					$proid=$res_prop['propertyid'];
						
					?>
            	<!--Slide Item-->
            	<div class="slide-item">
                    <!--Property Block-->
                    <div class="property-block-grid">
                        <div class="inner-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);
						
						?>
                            <div class="image-box">
                                  <figure class="image">  <img src="<?php echo $site_url;?>images/propertygallery/<?php echo $res_prop_gallery['image'];?>" alt="" style="width:372px;height:240px;"></figure>
                                <div class="ribbon">Sale</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['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 $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 $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>
                </div>
          <?php } } ?>
         
                
        	</div>
            
        </div>
    </section>