<?php include 'admin/includes/db_config.php';
$page="index";?>
<!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">
</head>

<body>
<div class="page-wrapper">
 	
  <?php include 'header.php';?>
    
    
    <!--Main Banner Slider-->
    <section class="main-banner-slider">
    	<div class="slider-container">
        	<div class="main-slider">
            	
                <!--Side Item-->
                <div class="slide-item" style="background-image:url(images/slider1new.jpg);">
                	<div class="overlay-layer"></div>
                    
                	<div class="auto-container">
                    	<div class="content-box">
<!--                        	<div class="bordered-layer"></div>-->
                            <h2>Succesfully completed 15 years<br> in the Real Estate Market</h2><br>
                        	<h2> Top Notch Real Estate provides the <br>
finest value properties in UAE </h2><br>
<!--                         <marquee behavior="scroll" direction="left" scrollamount="fast">Here is some scrolling text... right to left!</marquee>-->
                        </div>
                        
                    </div>
                </div>
                
                <!--Side Item-->
                <div class="slide-item" style="background-image:url(images/slider2new.jpg);">
                	<div class="overlay-layer"></div>
                    
                	<div class="auto-container">
                    	<div class="content-box">
<!--                        	<div class="bordered-layer"></div>-->
                           <h2>Succesfully completed 15 years<br> in the Real Estate Market</h2><br>
                        	<h2> Top Notch Real Estate provides the <br>
finest value properties in UAE </h2><br>
                        </div>
                        
                    </div>
                </div>
                
                  <div class="slide-item" style="background-image:url(images/slider3.jpg);">
                	<div class="overlay-layer"></div>
                    
                	<div class="auto-container">
                    	<div class="content-box">
<!--                        	<div class="bordered-layer"></div>-->
                           <h2>Succesfully completed 15 years<br> in the Real Estate Market</h2><br>
                        	<h2> Top Notch Real Estate provides the<br>
finest value properties in UAE </h2><br>
                        </div>
                        
                    </div>
                </div>
                
                 <div class="slide-item" style="background-image:url(images/slider4.jpg);">
                	<div class="overlay-layer"></div>
                    
                	<div class="auto-container">
                    	<div class="content-box">
<!--                        	<div class="bordered-layer"></div>-->
                           <h2>Succesfully completed 15 years<br> in the Real Estate Market</h2><br>
                        	<h2> Top Notch Real Estate provides the<br>
finest value properties in UAE </h2><br>
                        </div>
                        
                    </div>
                </div>
                
            </div>
        </div>
    </section>
    <?php include 'property-search.php';?>
  
    
    <section class="property-features">
    	<div class="auto-container">
        	<div class="row clearfix">
            	
                
                <!--Right Column-->
                <div class="col-md-12 col-sm-12 col-xs-12">
                    <div class="inner">
                        <!--Title Style One-->
                        <div class="title-style-one center-aligned">
                           
                            <div class="title"><h2>Welcome to Top Notch Real Estate</h2></div>
                          <!--  <div class="sub-title" style="font-size:21px;">Registered Real Estate Company with RERA under the ORN #1295 </div>-->
							<div class="sub-title">Your Property Search Ends Here</div>
                        </div>
                        
                        <p style="line-height:25px;">Top Notch Real Estate is a company that has been established for over a Decade now. We here care a lot about our service that is provided to our clients. The slogan “Your Property Search Ends Here" is merely an example of our service that is provided by us. Our experience and passion for Real Estate has grown rapidly over time. <a href="about-us.php" style="float:right;color: #e11a31;">Read More...</a></p>
                       
                        
                    </div>
                </div><!--Right Column-->
                
                
        	</div>
        </div>
    </section>

    <!--Properties Section-->
    <section class="properties-section" style="padding-top:50px!important;padding-bottom:0px!important;">
    	<div class="auto-container">
        	<!--Title Style One-->
            <div class="title-style-one left-aligned">
                <div class="title"><h2>Properties For Sale</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 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>
                </div>
          <?php } } ?>
         
                
        	</div>
            
        </div>
    </section>
	
	<!--Properties Section-->
    <section class="properties-section" style="padding-top:0px!important;">
    	<div class="auto-container">
        	<!--Title Style One-->
            <div class="title-style-one left-aligned">
                <div class="title"><h2>Properties For Rent</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=1 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">Rent</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 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>
                </div>
          <?php } } ?>
         
                
        	</div>
            
        </div>
    </section>
    
	
    <?php //include 'property-list-sale.php';?>
	
 <?php //include 'property-list.php';?>
 
 <?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>
