MMCT TEAM
Server IP : 103.53.40.154  /  Your IP : 18.223.206.84
Web Server : Apache
System : Linux md-in-35.webhostbox.net 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64
User : ppcad7no ( 715)
PHP Version : 8.2.25
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON
Directory (0750) :  /home2/ppcad7no/mansacdcc.com/../uttamnagarproperties.com/includes/../

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home2/ppcad7no/mansacdcc.com/../uttamnagarproperties.com/includes/../search-property.php
<?php include("uttam-header.php");?>
<!-- .site-header -->
<div class="page-head " style="background: url(images/banner.jpg) #494c53 no-repeat center top;  background-size: cover;">
    <div class="breadcrumb-wrapper">
        <div class="container">
            <nav>
                <ol class="breadcrumb">
                    <li><a href="index.php">Home</a></li>
                    <li class="active">Search Properties</li>
                </ol>
            </nav>
        </div>
    </div>
    <!-- .breadcrumb-wrapper -->
</div>
<?php
if($_REQUEST['Serach_Submit']=='Search'){
	  
  $proLocation = $_REQUEST['location'];
  $proType = $_REQUEST['type'];
  $proSellRent = $_REQUEST['status'];
  $proBedrooms = $_REQUEST['bedrooms'];
  
  $proMinPriceGrp = $_REQUEST['min-price'];
  $proMinPrice = explode("~",$proMinPriceGrp);  
  
  $proMaxPriceGrp = $_REQUEST['max-price'];
  $proMaxPrice = explode("~",$proMaxPriceGrp);
  $proMinArea = $_REQUEST['min-area'];  
  $addQuery = "";
  if($proLocation!='any'){
	 $addQuery .= " and (posted_properties_loc_parent='$proLocation' OR posted_properties_loc_child='$proLocation')"; 
  }
  if($proType!='any'){
	 $addQuery .= " and (posted_properties_type_parent='$proType' OR posted_properties_type_child='$proType')"; 
  }
  if($proSellRent!='any'){
	 $addQuery .= " and posted_properties_rent_sale='$proSellRent'"; 
  }
  if($proBedrooms!='any'){
	 $addQuery .= " and posted_properties_bedrooms='$proBedrooms'"; 
  }
  if($proMinPrice[0]!='any'){
	 $addQuery .= " and posted_properties_price>='$proMinPrice[0]' AND posted_properties_price_postfix='$proMinPrice[1]'"; 
  }
  if($proMaxPrice[0]!='any'){
	 $addQuery .= " and posted_properties_price<='$proMaxPrice[0]' AND posted_properties_price_postfix='$proMaxPrice[1]'"; 
  }
  if($proMinArea!=''){
	 $addQuery .= " and (posted_properties_area>='$proMinArea' AND posted_properties_area_postfix='SqFt')"; 
  }
  
 }
 ?>
<!-- .page-head -->
<div id="content-wrapper" class="site-content-wrapper site-pages">
    <div id="content" class="site-content layout-boxed">
        <div class="container">
            <div class="row">
                <div class="col-md-9 site-main-content">
                    <main id="main" class="site-main">
                        <div class="page-listing-control clearfix">
                            <div class="row">
                                <div class="col-xs-12 col-lg-12">
                                    <h3 class="heading results"><?=db_scalar("select count(*) from tbl_posted_properties where 1 and posted_properties_status='Approved' $addQuery");?> Properties Found</h3>
                                </div>
                                <!-- .page-controls-wrapper -->
                            </div>
                            <!-- .row -->
                        </div>
                        <!-- .page-listing-control -->
                        <?php
					  $prptySql = db_query("select * from tbl_posted_properties where 1 and posted_properties_status='Approved' $addQuery");
					  if(mysqli_num_rows($prptySql)>0){
						  while($PRPTYDATA = mysqli_fetch_array($prptySql)){
							  ?>
                        <article class="property-listing-simple property-listing-simple-2 hentry clearfix">
                            <div class="property-thumbnail col-sm-5 zero-horizontal-padding">
                                <div class="price-wrapper">
                                    <span class="price"><i class="fa fa-inr"></i> <?=$PRPTYDATA['posted_properties_price']?> <?=$PRPTYDATA['posted_properties_price_postfix']?></span>
                                </div>
                                <div class="gallery-slider-two flexslider">
                                    <ul class="slides">
                                        
                                        <li>
                                            <a title="<?=$PRPTYDATA['posted_properties_title'];?>" href="property-detail.php?main_property_id=<?=$PRPTYDATA['posted_properties_id'];?>">
                                                <img class="img-responsive" src="property_image/<?=db_scalar("select properties_image_name from tbl_properties_image where 1 and properties_image_property_id='$PRPTYDATA[posted_properties_id]' order by properties_image_id desc limit 0,1");?>" alt="<?=$PRPTYDATA['posted_properties_title'];?>">
                                            </a>
                                        </li>
                                    </ul>
                                </div>
                            </div>
                            <!-- .property-thumbnail -->
                            <div class="title-and-meta col-sm-7">
                                <header class="entry-header">
                                    <h3 class="entry-title">
                                    <a href="property-detail.php?main_property_id=<?=$PRPTYDATA['posted_properties_id'];?>" rel="bookmark"><?=$PRPTYDATA['posted_properties_project'];?><br>
                                    <?=$PRPTYDATA['posted_properties_title'];?></a></h3>
                                </header>
                                <div class="property-meta entry-meta clearfix">
                                    <div class="meta-item">
                                        <i class="meta-item-icon icon-area">
                                            <svg xmlns="http://www.w3.org/2000/svg" class="meta-icon-container" width="30" height="30" viewBox="0 0 48 48">
                                                <path class="meta-icon" fill="#0DBAE8" d="M46 16v-12c0-1.104-.896-2.001-2-2.001h-12c0-1.103-.896-1.999-2.002-1.999h-11.997c-1.105 0-2.001.896-2.001 1.999h-12c-1.104 0-2 .897-2 2.001v12c-1.104 0-2 .896-2 2v11.999c0 1.104.896 2 2 2v12.001c0 1.104.896 2 2 2h12c0 1.104.896 2 2.001 2h11.997c1.106 0 2.002-.896 2.002-2h12c1.104 0 2-.896 2-2v-12.001c1.104 0 2-.896 2-2v-11.999c0-1.104-.896-2-2-2zm-4.002 23.998c0 1.105-.895 2.002-2 2.002h-31.998c-1.105 0-2-.896-2-2.002v-31.999c0-1.104.895-1.999 2-1.999h31.998c1.105 0 2 .895 2 1.999v31.999zm-5.623-28.908c-.123-.051-.256-.078-.387-.078h-11.39c-.563 0-1.019.453-1.019 1.016 0 .562.456 1.017 1.019 1.017h8.935l-20.5 20.473v-8.926c0-.562-.455-1.017-1.018-1.017-.564 0-1.02.455-1.02 1.017v11.381c0 .562.455 1.016 1.02 1.016h11.39c.562 0 1.017-.454 1.017-1.016 0-.563-.455-1.019-1.017-1.019h-8.933l20.499-20.471v8.924c0 .563.452 1.018 1.018 1.018.561 0 1.016-.455 1.016-1.018v-11.379c0-.132-.025-.264-.076-.387-.107-.249-.304-.448-.554-.551z"/>
                                            </svg>
                                        </i>
                                        <div class="meta-inner-wrapper">
                                            <span class="meta-item-label">Area</span>
                                            <span class="meta-item-value"><?=$PRPTYDATA['posted_properties_area'];?><sub class="meta-item-unit"><?=$PRPTYDATA['posted_properties_area_postfix'];?></sub></span>
                                        </div>
                                    </div>
                                    <div class="meta-item">
                                        <i class="meta-item-icon icon-bed">
                                            <svg xmlns="http://www.w3.org/2000/svg" class="meta-icon-container" width="30" height="30" viewBox="0 0 48 48">
                                                <path class="meta-icon" fill="#0DBAE8" d="M21 48.001h-19c-1.104 0-2-.896-2-2v-31c0-1.104.896-2 2-2h19c1.106 0 2 .896 2 2v31c0 1.104-.895 2-2 2zm0-37.001h-19c-1.104 0-2-.895-2-1.999v-7.001c0-1.104.896-2 2-2h19c1.106 0 2 .896 2 2v7.001c0 1.104-.895 1.999-2 1.999zm25 37.001h-19c-1.104 0-2-.896-2-2v-31c0-1.104.896-2 2-2h19c1.104 0 2 .896 2 2v31c0 1.104-.896 2-2 2zm0-37.001h-19c-1.104 0-2-.895-2-1.999v-7.001c0-1.104.896-2 2-2h19c1.104 0 2 .896 2 2v7.001c0 1.104-.896 1.999-2 1.999z"/>
                                            </svg>
                                        </i>
                                        <div class="meta-inner-wrapper">
                                            <span class="meta-item-label">Bedrooms</span>
                                            <span class="meta-item-value"><?=$PRPTYDATA['posted_properties_bedrooms'];?></span>
                                        </div>
                                    </div>
                                    <div class="meta-item">
                                        <i class="meta-item-icon icon-bath">
                                            <svg xmlns="http://www.w3.org/2000/svg" class="meta-icon-container" width="30" height="30" viewBox="0 0 48 48">
                                                <path class="meta-icon" fill="#0DBAE8" d="M37.003 48.016h-4v-3.002h-18v3.002h-4.001v-3.699c-4.66-1.65-8.002-6.083-8.002-11.305v-4.003h-3v-3h48.006v3h-3.001v4.003c0 5.223-3.343 9.655-8.002 11.305v3.699zm-30.002-24.008h-4.001v-17.005s0-7.003 8.001-7.003h1.004c.236 0 7.995.061 7.995 8.003l5.001 4h-14l5-4-.001.01.001-.009s.938-4.001-3.999-4.001h-1s-4 0-4 3v17.005000000000003h-.001z"/>
                                            </svg>
                                        </i>
                                        <div class="meta-inner-wrapper">
                                            <span class="meta-item-label">Bathrooms</span>
                                            <span class="meta-item-value"><?=$PRPTYDATA['posted_properties_bathrooms'];?></span>
                                        </div>
                                    </div>
                                    <div class="meta-item">
                                        <i class="meta-item-icon icon-garage">
                                            <svg xmlns="http://www.w3.org/2000/svg" class="meta-icon-container" width="30" height="30" viewBox="0 0 48 48">
                                                <path class="meta-icon" fill="#0DBAE8" d="M44 0h-40c-2.21 0-4 1.791-4 4v44h6v-40c0-1.106.895-2 2-2h31.999c1.106 0 2.001.895 2.001 2v40h6v-44c0-2.209-1.792-4-4-4zm-36 8.001h31.999v2.999h-31.999zm0 18h6v5.999h-2c-1.104 0-2 .896-2 2.001v6.001c0 1.103.896 1.998 2 1.998h2v2.001c0 1.104.896 2 2 2s2-.896 2-2v-2.001h11.999v2.001c0 1.104.896 2 2.001 2 1.104 0 2-.896 2-2v-2.001h2c1.104 0 2-.895 2-1.998v-6.001c0-1.105-.896-2.001-2-2.001h-2v-5.999h5.999v-3h-31.999v3zm8 12.999c-1.104 0-2-.895-2-1.999s.896-2 2-2 2 .896 2 2-.896 1.999-2 1.999zm10.5 2h-5c-.276 0-.5-.225-.5-.5 0-.273.224-.498.5-.498h5c.275 0 .5.225.5.498 0 .275-.225.5-.5.5zm1-2h-7c-.275 0-.5-.225-.5-.5s.226-.499.5-.499h7c.275 0 .5.224.5.499s-.225.5-.5.5zm-6.5-2.499c0-.276.224-.5.5-.5h5c.275 0 .5.224.5.5s-.225.5-.5.5h-5c-.277 0-.5-.224-.5-.5zm11 2.499c-1.104 0-2.001-.895-2.001-1.999s.896-2 2.001-2c1.104 0 2 .896 2 2s-.896 1.999-2 1.999zm0-12.999v5.999h-16v-5.999h16zm-24-13.001h31.999v3h-31.999zm0 5h31.999v3h-31.999z"/>
                                            </svg>
                                        </i>
                                        <div class="meta-inner-wrapper">
                                            <span class="meta-item-label">Parking</span>
                                            <span class="meta-item-value"><?=$PRPTYDATA['posted_properties_garage'];?></span>
                                        </div>
                                    </div>
                                    <div class="meta-item">
                                        <i class="meta-item-icon icon-ptype">
                                            <svg xmlns="http://www.w3.org/2000/svg" class="meta-icon-container" width="30" height="30" viewBox="0 0 48 48">
                                                <path class="meta-icon" fill-rule="evenodd" clip-rule="evenodd" fill="#0DBAE8" d="M24 48.001c-13.255 0-24-10.745-24-24.001 0-13.254 10.745-24 24-24s24 10.746 24 24c0 13.256-10.745 24.001-24 24.001zm10-27.001l-10-8-10 8v11c0 1.03.888 2.001 2 2.001h3.999v-9h8.001v9h4c1.111 0 2-.839 2-2.001v-11z"/>
                                            </svg>
                                        </i>
                                        <div class="meta-inner-wrapper">
                                            <span class="meta-item-label">Type</span>
                                            <span class="meta-item-value"><?=$PRPTYDATA['posted_properties_type_parent'];?> <?=$PRPTYDATA['posted_properties_type_child'];?></span>
                                        </div>
                                    </div>
                                    <div class="meta-item">
                                        <i class="meta-item-icon icon-tag">
                                            <svg xmlns="http://www.w3.org/2000/svg" class="meta-icon-container" width="30" height="30" viewBox="0 0 48 48">
                                                <path class="meta-icon" fill-rule="evenodd" clip-rule="evenodd" fill="#0DBAE8" d="M47.199 24.176l-23.552-23.392c-.504-.502-1.174-.778-1.897-.778l-19.087.09c-.236.003-.469.038-.696.1l-.251.1-.166.069c-.319.152-.564.321-.766.529-.497.502-.781 1.196-.778 1.907l.092 19.124c.003.711.283 1.385.795 1.901l23.549 23.389c.221.218.482.393.779.523l.224.092c.26.092.519.145.78.155l.121.009h.012c.239-.003.476-.037.693-.098l.195-.076.2-.084c.315-.145.573-.319.791-.539l18.976-19.214c.507-.511.785-1.188.781-1.908-.003-.72-.287-1.394-.795-1.899zm-35.198-9.17c-1.657 0-3-1.345-3-3 0-1.657 1.343-3 3-3 1.656 0 2.999 1.343 2.999 3 0 1.656-1.343 3-2.999 3z"/>
                                            </svg>
                                        </i>
                                        <div class="meta-inner-wrapper">
                                            <span class="meta-item-label">Status</span>
                                            <span class="meta-item-value"><?=$PRPTYDATA['posted_properties_rent_sale'];?></span>
                                        </div>
                                    </div>
                                </div>
                                <!-- .property-meta -->
                            </div>
                            <!-- .title-and-meta -->
                        </article>
                        <? }} ?>
                        <!-- .property-listing-simple-2 -->                       
                        <!--<div class="pagination">
                            <a class="prev page-numbers" href="#"><i class="fa fa-angle-left"></i></a>
                            <span class="page-numbers current">1</span>
                            <a class="page-numbers" href="#">2</a>
                            <a class="next page-numbers" href="#"><i class="fa fa-angle-right"></i></a>
                        </div>-->
                        <!-- .pagination -->
                    </main>
                    <!-- .site-main -->
                </div>
                <!-- .site-main-content -->
                <div class="col-md-3 site-sidebar-content">
                    <aside class="sidebar">
                        <section class="widget widget-advance-search advance-search">
                            <h3 class="advance-search-widget-title"><i class="fa fa-search"></i>Find Your Home</h3>
                            <?php include("sell-property-search.php");?>
                            <!-- .advance-search-form -->
                        </section>
                        <section class="widget widget-featured-properties">
                            <h3 class="widget-title">Featured Properties</h3>
                            <ul class="widget-featured-properties">
                               <?php 
					  $fprptySql = db_query("select * from tbl_posted_properties where 1 and posted_properties_status='Approved' and  posted_properties_is_feature='Yes' order by rand() limit 0,2");
					  if(mysqli_num_rows($fprptySql)>0){
						  while($FDATA = mysqli_fetch_array($fprptySql)){
							  ?>
                                <li>
                                    <figure class="featured-properties-thumbnail">
                                        <span class="price"><i class="fa fa-inr"></i> <?=$FDATA['posted_properties_price']?> <?=$FDATA['posted_properties_price_postfix']?></span>
                                        <a title="<?=$FDATA['posted_properties_title'];?>" href="property-detail.php?main_property_id=<?=$FDATA['posted_properties_id'];?>">
                                                <img class="img-responsive" src="property_image/<?=db_scalar("select properties_image_name from tbl_properties_image where 1 and properties_image_property_id='$FDATA[posted_properties_id]' order by properties_image_id desc limit 0,1");?>" alt="<?=$FDATA['posted_properties_title'];?>">
                                            </a>
                                        </figure>
                                    <h4 class="featured-properties-title"><a href="property-detail.php?main_property_id=<?=$FDATA['posted_properties_id'];?>"><?=$FDATA['posted_properties_title']?></a></h4>
                                    <?php $descp = $FDATA['posted_properties_description'];?>
                                    <p><?=substr($descp,0,85);?>… <a href="property-detail.php?main_property_id=<?=$FDATA['posted_properties_id'];?>" class="read-more-link">Know More</a></p>
                                </li>
                                <? }} ?>
                            </ul>
                        </section>
                    </aside>
                    <!-- .sidebar -->
                </div>
                <!-- .site-sidebar-content -->
            </div>
            <!-- .row -->
        </div>
        <!-- .container -->
    </div>
    <!-- .site-content -->
</div>
<!-- .site-content-wrapper -->
<script type="text/javascript">
function redirectURL(sortBy){
if(sortBy=='dateDesc'){
var newurl='sell-property.php';
window.location.href=newurl;
}else{
var newurl='sell-property.php?filterName='+sortBy;
window.location.href=newurl;
}
}
</script>
<?php include("uttam-footer.php");?>

MMCT - 2023