1#@!#!123s

file_get_contents 1#@!#!123s
: / home / u247928417 / domains / propertybaazars.com / public_html /
Filename : load-apartments-villas-more.php
back
<?php
error_reporting(0);
session_start();
include("admin/config/config.php");


if($_REQUEST['LatestListings']=='LatestListings'){
	
	
		
	if($_REQUEST['amenities_features']!=''){
		
		
		$search="and pi_categories_id IN ('".mysqli_real_escape_string($conn,$_REQUEST['amenities_features'])."')";
		
	}
	if($_REQUEST['amenities_filters']!=''){
		
		
		$search="and amenities_feature_id IN ('".mysqli_real_escape_string($conn,$_REQUEST['amenities_filters'])."')";
		
	}
	if($_REQUEST['bedrooms']!=''){
		
		
		$search="and bedrooms IN ('".mysqli_real_escape_string($conn,$_REQUEST['bedrooms'])."')";
		
	}
	if($_REQUEST['amenities_features']!='' and $_REQUEST['amenities_filters']!='' and $_REQUEST['bedrooms']!=''){
		
		
		$search="and pi_categories_id IN ('".mysqli_real_escape_string($conn,$_REQUEST['amenities_features'])."') and amenities_feature_id IN ('".mysqli_real_escape_string($conn,$_REQUEST['amenities_filters'])."') and bedrooms IN ('".mysqli_real_escape_string($conn,$_REQUEST['bedrooms'])."')";
		
	} 
	if($_REQUEST['amenities_features']!='' and $_REQUEST['amenities_filters']!=''){
		
		
		$search="and pi_categories_id IN ('".mysqli_real_escape_string($conn,$_REQUEST['amenities_features'])."') and amenities_feature_id IN ('".mysqli_real_escape_string($conn,$_REQUEST['amenities_filters'])."')";
		
	} 
	if($_REQUEST['amenities_features']!=''  and $_REQUEST['bedrooms']!=''){
		
		
		$search="and pi_categories_id IN ('".mysqli_real_escape_string($conn,$_REQUEST['amenities_features'])."')   and bedrooms IN ('".mysqli_real_escape_string($conn,$_REQUEST['bedrooms'])."')";
		
	}
	if($_REQUEST['amenities_filters']!='' and $_REQUEST['bedrooms']!=''){
		
		
		$search="and   amenities_feature_id IN ('".mysqli_real_escape_string($conn,$_REQUEST['amenities_filters'])."') and bedrooms IN ('".mysqli_real_escape_string($conn,$_REQUEST['bedrooms'])."')";
		
	} 	
	
	if($_REQUEST['amenities_features']=='' and $_REQUEST['amenities_filters']=='' and $_REQUEST['bedrooms']==''){
		
		
		$search="";
		
	}
	
$LatestListings="SELECT t1.id,property_title,city_name,state_name,added_date,t4.property_type,t1.description,t1.property_size,t1.property_pincode,t1.latitude,t1.longitude,t1.lot_size,t1.rooms,t1.bedrooms,t1.bathrooms,t1.garages,t1.garage_size,t1.year_built,t1.basement,t1.extra_details,t1.roofing,t1.floors_number,t1.owner_agent_notes,t1.property_price,t5.tag_name,t6.value_type FROM `pi_properties_listing` t1 
left join pi_state t2 on t1.property_state_id=t2.state_id
left join pi_city t3 on t1.property_city_id=t3.city_id  
left join pi_property_type t4 on t1.pi_property_type_id=t4.id 
left join pi_property_tags t5 on t1.pi_property_tag_id=t5.id 
left join pi_price_value t6 on t1.pi_price_value_id=t6.id	where pi_categories_id IN('1','3','10') ".$search."	order by t1.id DESC";
$queryLatestList=mysqli_query($conn,$LatestListings); 
		
?>
                         <div class="tab-content">
                        <div class="tab-pane fade active show" id="liton_product_grid">
                            <div class="ltn__product-tab-content-inner ltn__product-grid-view">
                                <div class="row">
                                    <div class="col-lg-12">
                                        <!-- Search Widget -->
                                        <div class="ltn__search-widget mb-30">
                                             <form action="search-properties?text=<?php echo $_REQUEST['text-search'];?>" method="GET">
                                                <input type="text" name="text-search" placeholder="Search your keyword...">
                                                <button type="submit"><i class="fas fa-search"></i></button>
                                            </form>
                                        </div>
                                    </div>
                                    <!-- ltn__product-item -->
									<?php 
											 
	 
									while($fetchListing=mysqli_fetch_assoc($queryLatestList)){
													
									$myname_new2 = str_replace( array(' '),'-',$fetchListing['property_title']);
									$myname_new_2 = str_replace( array('%'),'-',$myname_new2);
									$myname_new_3 = str_replace( array('&amp;'),'-',$myname_new_2);
									$myname_new_4 = str_replace( array('-'),'-',$myname_new_3);
									$myname_new_5 = str_replace( array('/'),'-',$myname_new_4);

									//get image
									$getImage="select property_image from pi_images_listing WHERE property_listing_id='".$fetchListing['id']."'";
									$queryImage=mysqli_query($conn,$getImage); 
									$NumRows=mysqli_num_rows($queryImage);	
									$fetchImg=mysqli_fetch_assoc($queryImage);	
																		
									
									
									?>
									<div class="col-xl-6 col-sm-6 col-12">
                                        <div class="ltn__product-item ltn__product-item-4 ltn__product-item-5 text-center---">
                                            <div class="product-img">
                                                <a href="<?php echo  strtolower($myname_new_5); ?>-<?php echo $fetchListing['id'];?>.html"><img class="latestListingImg" src="<?php echo $fetchImg['property_image'];?>" alt="<?php echo $fetchPro['property_title'];?>"></a>
                                                
                                            </div>
                                            <div class="product-info">
                                                <div class="product-badge">
                                                    <ul>
                                                        <li class="sale-badg">For <?php echo $fetchListing['property_type'];?></li>
                                                    </ul>
                                                </div>
                                                <h2 class="product-title"><a href="<?php echo  strtolower($myname_new_5); ?>-<?php echo $fetchListing['id'];?>.html"><?php echo $fetchListing['property_title'];?></a></h2>
                                                <div class="product-img-location">
                                                    <ul>
                                                        <li>
                                                            <a href="<?php echo  strtolower($myname_new_5); ?>-<?php echo $fetchListing['id'];?>.html"><i class="flaticon-pin"></i> <?php echo ucwords(strtolower($fetchListing['city_name'])).', '.ucwords(strtolower($fetchListing['state_name']));?></a>
                                                        </li>
                                                    </ul>
                                                </div>
                                                <ul class="ltn__list-item-2--- ltn__list-item-2-before--- ltn__plot-brief">
                                                     <li><span><?php echo $fetchListing['rooms'];?> <i class="flaticon-bed"></i></span>
                                    Bedrooms
                                </li>
                                <li><span><?php echo $fetchListing['bathrooms'];?> <i class="flaticon-clean"></i></span>
                                    Bathrooms
                                </li>
                                <li><span><?php echo $fetchListing['property_size'];?> <i class="flaticon-square-shape-design-interface-tool-symbol"></i></span>
                                    square Ft
                                </li>
                                                </ul>
                                                
                                            </div>
                                            <div class="product-info-bottom">
                                                <div class="product-price">
                                                    <span>Rs. <?php echo $fetchListing['property_price'];?> <?php echo $fetchListing['value_type'];?><?php if($fetchListing['property_type']=='Rent'){?><label> /Month</label><?php }?></span>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
									<?php }?>
                                    <!-- ltn__product-item -->
                
                                </div>
                            </div>
                        </div>
   
                    </div>
									
   
<?php

	
}

?>