Elehhjhjjkjkfpf6df56fd65ffff

korsygfhrfggfhfgfffgffg6655665dtggggggzangaiide Elehhjhjjkjkfpf6df56fd65ffff

<?php
include 'includes/config.php';

$prty_type  = $_GET['SearchType'];
$prty_loc  = $_GET['SearchLocation'];

$prtys_type  = $_GET['SearchType'];
$prtye_loc  = $_GET['SearchLocation'];

if(!isset($_GET['SearchType'])) 
{
header ("Location: ./");
        exit();
}

if(!isset($_GET['SearchLocation'])) 
{
header ("Location: ./");
        exit();
}

if($prty_type == "used-cars")
{
    $prty_tdype = "Used Cars (Buy/Sell)";
}
else
{
        $prty_tdype = "Used Cars (Buy/Sell)";

}

?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="author" content="">
<meta name="theme-color" content="#e33324">
<meta name="description" content="Property Service , Banking Solution & Service - Mosampati">
<meta name="keywords" content="Apartment, Estate Agency, Housing, Real Estate, Real Estate Broker, Real Estate Property, Single Property">
<meta name="viewport" content="width=device-width, initial-scale=1.0">

<title><?php echo $prty_tdype; ?> Vehicle in <?php echo $prty_loc; ?> - Property Service , Banking Solution & Service - Mosampati</title>

<link rel="shortcut icon" href="images/logo/mslogo.png">

<link rel="stylesheet" href="css/stylesheet.css">

<link href="https://fonts.googleapis.com/css?family=Nunito:300,400,600,700,800&display=swap" rel="stylesheet">
<link href="https://fonts.googleapis.com/css?family=Open+Sans:400,600,700,800&display=swap" rel="stylesheet">

</head>

<div id="wrapper">

<?php include 'includes/header.php'; ?>
   
  
  
 
 
<?php

$sql4="SELECT  count('1')  FROM `vehcl_list`  WHERE (veh_ads LIKE '%".$prty_loc."%' OR veh_city LIKE '%".$prty_loc."%' OR
veh_state LIKE '%".$prty_loc."%' OR veh_zip LIKE '%".$prty_loc."%')

AND (is_completed='1' AND status='A')   ORDER BY id DESC";

$result4=mysqli_query($conn,$sql4);
$rows3=mysqli_fetch_array($result4);
?>
   
  <div class="container">
      
      
	<div class="row">
	    		<div class="col-md-12">
			<div class="row margin-bottom-30 margin-top-60">
			    
			    <a href="./" >
			        <div class="col-md-12"> 
				<h4 class="headline_part margin-top-0 margin-bottom-15">
				    
				    
				    <i class="fa fa-angle-left"></i>

&nbsp;<span style="font-weight: bold;"><?php echo $rows3[0];?> </span> Used Cars (Buy/Sell) Available
in <?php echo $prty_loc; ?>
				    
				</h4>
</a>

</div>
			  </a>
			  
			  
			  			  </div>
			  </div>
			  </div>
			  </div>
			  
	  <?php

$prty_type  = $_GET['SearchType'];
$prty_loc  = $_GET['SearchLocation'];

$src_bb = "search-used-cars?SearchType=$prty_type&SearchLocation=$prty_loc";

?>
  
  <div class="container">
    <div class="row sticky-wrapper">
      <div class="col-md-8"> 
        
        <div class="utf-sort-box-aera">
            <div class="sort-by">
              <label>Sort By:</label>
              <div class="sort-by-select">
                <select data-placeholder="Default Properties" class="utf-chosen-select-single-item"
                onchange="document.location.href = '<?php echo $src_bb; ?>&sortBy=' + this.value">
                  <option value="default">Default Properties</option>
                  <option value="price-desc">Low to High Price</option>
                  <option value="price-asc">High to Low Price</option>
                  <option value="newest-properties">Newest Properties</option>
                  <option value="oldest-properties">Oldest Properties</option>
                </select>
                
                
              </div>
            </div>
            <div class="utf-layout-switcher"> 
				<a href="#" class="list"><i class="sl sl-icon-list"></i></a> 
				<a href="#" class="grid"><i class="sl sl-icon-grid"></i></a> 
			</div>
        </div>
        
        
        <div class="utf-listings-container-area list-layout"> 
         
         
	
			
<?php

$total_pagess_sql = "SELECT * FROM  vehcl_list   WHERE (veh_ads LIKE '%".$prty_loc."%' OR veh_city LIKE '%".$prty_loc."%' OR
veh_state LIKE '%".$prty_loc."%' OR veh_zip LIKE '%".$prty_loc."%')

AND (is_completed='1' AND status='A')     ORDER BY id DESC ";

$ressult = mysqli_query($conn,$total_pagess_sql);

$numas = mysqli_num_rows($ressult);
if($numas > 0)
{
 
//Getting default page number
        if (isset($_GET['pageno'])) {
            $pageno = $_GET['pageno'];
        } else {
            $pageno = 1;
        }
// Formula for pagination

$tot_pp = 10;

$no_of_records_per_page = $tot_pp;
        $offset = ($pageno-1) * $no_of_records_per_page;
// Getting total number of pages
        $total_pages_sql = "SELECT COUNT(*) FROM vehcl_list   WHERE (veh_ads LIKE '%".$prty_loc."%' OR veh_city LIKE '%".$prty_loc."%' OR
veh_state LIKE '%".$prty_loc."%' OR veh_zip LIKE '%".$prty_loc."%')

AND (is_completed='1' AND status='A')      ORDER BY id DESC ";
        $result = mysqli_query($conn,$total_pages_sql);
        $total_rows = mysqli_fetch_array($result)[0];
        $total_pages = ceil($total_rows / $no_of_records_per_page);

if (isset($_GET['sortBy'])) {
            $sort_val = $_GET['sortBy'];
        } else {
            $sort_val = "ID DESC";
        }

if($sort_val == "price-desc")
        {
            $sorting_v = "`veh_prc` ASC";
        }
        elseif($sort_val == "price-asc")
        {
            $sorting_v = "`veh_prc` DESC";

}
        elseif($sort_val == "newest-properties")
        {
            $sorting_v = "`id` DESC";

}
        elseif($sort_val == "oldest-properties")
        {
            $sorting_v = "`id` ASC";

}
        else
        {
            $sorting_v = "`id` DESC";

}

$seledctquery="SELECT * FROM `vehcl_list`    WHERE (veh_ads LIKE '%".$prty_loc."%' OR veh_city LIKE '%".$prty_loc."%' OR
veh_state LIKE '%".$prty_loc."%' OR veh_zip LIKE '%".$prty_loc."%')

AND (is_completed='1' AND status='A')   ORDER BY $sorting_v LIMIT $offset, $no_of_records_per_page";

$qsuery = mysqli_query($conn,$seledctquery);

$i=1;
  while($rs4es = mysqli_fetch_array($qsuery))
{

$id = $rs4es['id'];
$juser_id = $rs4es['user_id'];
$vehicle_id = $rs4es['vehicle_id'];
$veh_title = $rs4es['veh_title'];
$veh_brand = $rs4es['veh_brand'];
$veh_rgdno = $rs4es['veh_rgdno'];
$veh_mk = $rs4es['veh_mk'];
$veh_kmdr = $rs4es['veh_kmdr'];
$veh_prc1 = $rs4es['veh_prc'];
$veh_desc = $rs4es['veh_desc'];
$veh_ads = $rs4es['veh_ads'];
$veh_city = $rs4es['veh_city'];
$veh_state = $rs4es['veh_state'];
$veh_zip = $rs4es['veh_zip'];
$cont_name = $rs4es['cont_name'];
$cont_email = $rs4es['cont_email'];
$cont_phone = $rs4es['cont_phone'];
$vfile_id = $rs4es['vfile_id'];
$veh_video = $rs4es['veh_video'];
$is_completed = $rs4es['is_completed'];
$status = $rs4es['status'];
$fet_sts = $rs4es['fet_sts'];
$tot_views = $rs4es['tot_views'];
$posted_ovn = $rs4es['posted_on'];
$updated_on = $rs4es['updated_on'];

$veh_sprc = number_format($veh_prc1,2);

$sql4sd5 ="SELECT * from `user_dtls` WHERE user_id='$juser_id' ORDER BY id DESC ";
$quer5s6y = mysqli_query($conn,$sql4sd5);
while($sres565s4 = mysqli_fetch_array($quer5s6y))
{
$row_id1  = $sres565s4['id'];
$usefr_nm = $sres565s4['user_nm'];

$user_phone = $sres565s4['user_phone'];
$user_emails = $sres565s4['user_email'];
$profgile_pice = $sres565s4['profile_pic'];

$st_addres  = $sres565s4['st_addres'];	
$address2  = $sres565s4['address2'];	
$country_nm	  = $sres565s4['country_nm'];
$state_nm  = $sres565s4['state_nm'];	
$city_nm	  = $sres565s4['city_nm'];
$zip_code   = $sres565s4['zip_code'];  
          
}

// $timeago = get_timeago(strtotime($posted_ovn));

$timeago = date("jS M, Y", strtotime($posted_ovn));

?>
   
          
          
				<div class="utf-listing-item"> 
				  <a href="single-vehicle-page-1.php?vehicle_id=<?php echo $vehicle_id; ?>" class="utf-smt-listing-img-container">
				  <div class="utf-listing-badges-item"> 
				  
				  <?php
				  if($fet_sts == '1')
				  {
				      ?>
				      
				      					<span class="featured">Featured</span>

<?php
				  }
				  else
				  {
				      
				  }
				  ?>
				  
					
					
					<span class="for-sale">For Buy/Sell</span> 
				  </div>				  
				  <div class="utf-listing-img-content-item"> 
				  
				  <?php
				  if(empty($profgile_pice))
				  {
				      ?>
				      					<img class="utf-user-picture" src="uploads/download.png" alt="Mosampati User" />

<?php
				  }
				  else
				  {
				      ?>
				      
				      					<img class="utf-user-picture" src="uploads/<?php echo $profgile_pice; ?>" alt="Mosampati User" />

<?php
				      
				  }
				  ?>

<?php
					if(empty($veh_video))
					{
					    ?>
					 
					 <span class="video-lbutton with-tip" data-tip-content="No Video" style="content: none;">
					     <i class="icon-feather-video-off with-tip"  data-tip-content="No Video"></i></span>
	
<?php
					    
					}
					else
					{
					    ?>
					    
					 <span class="video-button with-tip" data-tip-content="Video Added"></span>

<?php
					}
					?>
					
					
					
					
									  </div>
				  <div class="utf-listing-carousel-item">
				      
				      <?php
				       
    $sql456="SELECT * FROM `property_file` WHERE  `pfile_id` = '$vfile_id'  ORDER BY id ASC";

$query545 = mysqli_query($conn,$sql456);
                                     while($re4s5 = mysqli_fetch_array($query545))
                                     {
                $filed_name = $re4s5['file_name'];

<div>
	    
	  <img src="uploads/<?php echo $filed_name; ?>" alt="<?php echo $veh_title; ?>"
	 style="max-height: 250px !important;height:250px !important;width: 100%  !important;">
	  
	  
	</div>
					
					<?php
                                      }
                                      ?>
                                      
                                      
				  </div>
				  </a>
				  <div class="utf-listing-content">				
					<div class="utf-listing-title">
					  <span class="utf-listing-price">₹ <?php echo $veh_sprc; ?></span> 						  	
					  <h4 id="pro_title"><a href="single-vehicle-page-1?vehicle_id=<?php echo $vehicle_id; ?>"><?php echo $veh_title; ?></a></h4>
					  <span class="utf-listing-address"><i class="icon-material-outline-location-on"></i> 
					  
					  <a href="http://maps.google.com/maps?q=<?php echo $veh_ads.', '.$veh_city.', '.$veh_state.', '.$veh_zip; ?>" target="_blank" >

</span> 											  
					</div>

<div class="utf-listing-user-info" style="padding-top: 0px;padding-bottom: 0px;font-size: 14px;">Make/Model<span>Km Driven</span></div>	
					 
					 
					 
<div class="utf-listing-user-info" style="padding-top: 0px;padding-bottom: 0px;font-size: 14px;font-weight: bold;color: #000;">
    <?php echo $veh_mk; ?><span>₹ <?php echo $veh_kmdr; ?> kms</span></div>	
					 
					 
					
					
					
					
					<div class="utf-listing-user-info"><a>
					    <i class="icon-line-awesome-user"></i> <?php echo $usefr_nm; ?></a> <span><?php echo $timeago; ?></span>
					 </div>	
				  </div>
				</div>
           
         
	
	
<?php
}
?>

<?php
       }
       else
       {

<div class="container-fluid  margin-top-60">
				 <div class="row">
				 
					<div class="col-md-12">
					
							<div class="card">
						
						
						<div class="card-body cart">
								<div class="col-sm-12 empty-cart-cls text-center">
									<img src="images/logo/property_empty.png" width="130" height="130" class="img-fluid mb-4 mr-3">
									<h3><strong>Vehicle Listing is Empty</strong></h3>
									<h4>No results matching your search! :)</h4>

</div>
						</div>
				</div>
						
					
					</div>
				 
				 </div>
				
				</div>
				
<a href="add-new-vehicles.php" class="utf-centered-button button  margin-top-60">Add New Vehicle</a>

<?php
           
       }
       
       ?>
        </div>
         
        
        
        
        <?php
                         
if (isset($_GET['sort_val'])) 
{
$sort_valdsf = '?sort_val='.$sort_val.'&pageno';
} else 
{
$sort_valdsf = '?pageno';
}

<?php
if($total_rows > $tot_pp)
{
 
 ?>
 
 
        <div class="utf-pagination-container margin-top-60">
          <nav class="pagination">
            <ul>

<?php

$numbers = range(1, $total_pages);
foreach ($numbers as $number) 
{

if($pageno == $number )
        {
         ?>
                
			  <li><a href="<?php echo $sort_valdsf;?>=<?php echo $number; ?>" class="current-page"><?php echo $number; ?></a></li>
              
              
              
<?php

}
        else
        {
            
            ?>
            
            
    <li><a href="<?php echo $sort_valdsf;?>=<?php echo $number; ?>" ><?php echo $number; ?></a></li>

<?php
            
        }
  
                        
}
?>

<li><a href="<?php if($pageno >= $total_pages){ echo ''; } else { echo "$sort_valdsf=".($pageno + 1); } ?>"><i class="fa fa-angle-right"></i></a></li>
			  
			  
			  
            </ul>
          </nav>          
        </div>
           
        
        <?php
}
else
{
    
}
?>
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
      
       
       
       
       
       
       
              
      </div>
      
      
      <div class="col-md-4">

<div class="widget utf-sidebar-widget-item">
			  <div class="utf-boxed-list-headline-item">
				  <h3>Categories</h3>
				  <div class="utf-sidebar-categorie"> 
					<ul>
					    
					    	  <?php
					  
$selectquery="SELECT * FROM `category_dtls` WHERE status='A'  ORDER BY id asc";
$query = mysqli_query($conn,$selectquery);
$nums = mysqli_num_rows($query);
$i=1;
while($res = mysqli_fetch_array($query))
{
$row_id  = $res['id'];
$category_id = $res['category_id'];
$category_nm = $res['category_nm'];
$cate_linkS = $res['cate_link'];
$status = $res['status'];

if($category_nm == 'Used Cars (Buy/Sell)')
{
    
$sql66="select count('1') from vehcl_list WHERE   is_completed='1' AND status='A'  ";
$result66=mysqli_query($conn,$sql66);
$row6=mysqli_fetch_array($result66);

$no_prop1 = $row6[0];

}

else
{

$sql66="select count('1') from property_list WHERE prty_type='$category_nm' AND  is_completed='1' AND status='A'  ";
$result66=mysqli_query($conn,$sql66);
$row6=mysqli_fetch_array($result66);

$no_prop1 = $row6[0];

}

?>
					    
					  <li><a href="<?php echo $cate_linkS.'.php'; ?>"><?php echo $category_nm; ?></a><span><?php echo $no_prop1; ?> Nos</span></li> 
					  
					  
					  <?php
}
?>

</ul>
				  </div>
			  </div>              
            </div>

<div class="clearfix"></div>	
        </div>
      </div>
       
    </div>
  </div>
  
  
                   <?php include 'includes/footer.php'; ?>

<div id="backtotop"><a href="#"></a></div>
</div>

<div id="utf-signin-dialog-block" class="zoom-anim-dialog mfp-hide dialog-with-tabs"> 
  <div class="utf-signin-form-part">
    <ul class="utf-popup-tabs-nav-item">
      <li><a href="#login">Log In</a></li>
      <li><a href="#register">Register</a></li>
    </ul>
    <div class="utf-popup-container-part-tabs"> 
      
      <div class="utf-popup-tab-content-item" id="login"> 
        <div class="utf-welcome-text-item">
          <h3>Welcome Back Sign in to Continue</h3>
          <span>Don't Have an Account? <a href="#" class="register-tab">Sign Up!</a></span> 
		</div>
        <form method="post" id="login-form">
          <div class="utf-no-border">
            <input type="text" name="emailaddress" id="emailaddress" placeholder="Email Address" required/>
          </div>
          <div class="utf-no-border">
            <input type="password" name="password" id="password" placeholder="Password" required/>
          </div>
		  <div class="checkbox margin-top-0">
			<input type="checkbox" id="two-step">
			<label for="two-step"><span class="checkbox-icon"></span> Remember Me</label>
		  </div>
          <a href="forgot_password.html" class="forgot-password">Forgot Password?</a>
        </form>
        <button class="button full-width utf-button-sliding-icon ripple-effect" type="submit" form="login-form">Log In <i class="icon-feather-chevrons-right"></i></button>
        <div class="utf-social-login-separator-item"><span>Or Login in With</span></div>
        <div class="utf-social-login-buttons-block">
          <button class="facebook-login ripple-effect"><i class="icon-brand-facebook-f"></i> Facebook</button>
		  <button class="google-login ripple-effect"><i class="icon-brand-google"></i> Google</button>
		  <button class="twitter-login ripple-effect"><i class="icon-brand-twitter"></i> Twitter</button>
        </div>
      </div>
      
      
      <div class="utf-popup-tab-content-item" id="register"> 
        <div class="utf-welcome-text-item">
          <h3>Create your Account!</h3>
		  <span>Don't Have an Account? <a href="#" class="register-tab">Sign Up!</a></span> 
        </div>        
        <form method="post" id="utf-register-account-form">
          <div class="utf-no-border margin-bottom-20">
			<select class="utf-chosen-select-single-item utf-with-border" title="Single User">
				<option>Single User</option>
				<option>Agent</option>
				<option>Multi User</option>				
			</select>
		  </div>
		  <div class="utf-no-border">
            <input type="text" name="name" id="name" placeholder="User Name" required/>
          </div>
		  <div class="utf-no-border">
            <input type="text" name="emailaddress-register" id="emailaddress-register" placeholder="Email Address" required/>
          </div>
		  <div class="utf-no-border">
            <input type="password" name="password-register" id="password-register" placeholder="Password" required/>
          </div>
          <div class="utf-no-border">
            <input type="password" name="password-repeat-register" id="password-repeat-register" placeholder="Repeat Password" required/>
          </div>
		  <div class="checkbox margin-top-0">
			<input type="checkbox" id="two-step0">
			<label for="two-step0"><span class="checkbox-icon"></span> By Registering You Confirm That You Accept <a href="#">Terms & Conditions</a> and <a href="#">Privacy Policy</a></label>
		  </div>
        </form>
        <button class="margin-top-10 button full-width utf-button-sliding-icon ripple-effect" type="submit" form="utf-register-account-form">Register <i class="icon-feather-chevrons-right"></i></button>        
      </div>
    </div>
  </div>
</div>

<script src="scripts/jquery-3.3.1.min.js"></script> 
<script src="scripts/bootstrap.min.js"></script>
<script src="scripts/chosen.min.js"></script> 
<script src="scripts/magnific-popup.min.js"></script> 
<script src="scripts/owl.carousel.min.js"></script> 
<script src="scripts/rangeSlider.js"></script> 
<script src="scripts/sticky-kit.min.js"></script> 
<script src="scripts/slick.min.js"></script> 
<script src="scripts/mmenu.min.js"></script> 
<script src="scripts/tooltips.min.js"></script> 
<script src="scripts/masonry.min.js"></script> 
<script src="scripts/custom_jquery.js"></script> 
</body>
</html>