<?php
/**
 * Template Name: Default - Advance Search Listing
 *
 * A template used to demonstrate how to include the template
 * using this plugin.
 *
 * @package Aretk Crea
 * @since 	1.0.0
 * @version	1.0.0
 */
get_header();

global $wpdb;
$crea_showcase_search_theams_option = isset($_GET['layout_option']) ? $_GET['layout_option'] :'';
$crea_showcase_shortcode_id = isset($_GET['shortcode_id']) ? $_GET['shortcode_id'] :'';
$default_text_search = isset($_GET['keywords']) ? $_GET['keywords'] :'';
$crea_advance_search_property_type = trim(isset($_GET['property_type']) ? $_GET['property_type'] :'');
$crea_advance_search_structure_type = trim(isset($_GET['structure_type']) ? $_GET['structure_type'] :'');
$crea_advance_search_status = trim(isset($_GET['property_status']) ? $_GET['property_status'] :'');
$crea_advance_search_bedrooms = trim(isset($_GET['bedrooms']) ? $_GET['bedrooms'] :'');
$crea_advance_search_bathrooms = trim(isset($_GET['bathrooms']) ? $_GET['bathrooms'] :'');
$min_amount = isset($_GET['min_amount']) ? $_GET['min_amount'] :'';
$max_amount = isset($_GET['max_amount']) ? $_GET['max_amount'] :'';
$showcase_custom_result_type = "&result_type=full";
$getSubscriptionKey = get_option('crea_subscription_key', '');
$subscriptionKey = !empty($getSubscriptionKey) ? $getSubscriptionKey : '';

$showcse_crea_feed_include_exclude = maybe_unserialize(get_post_meta($crea_showcase_shortcode_id,'showcse_crea_feed_include_exclude',true));
$showcse_crea_feed_include_exclude = !empty( $showcse_crea_feed_include_exclude ) ? $showcse_crea_feed_include_exclude :'';
$showcse_crea_feed_ddf_type = maybe_unserialize(get_post_meta($crea_showcase_shortcode_id,'showcse_crea_feed_ddf_type',true));
$showcse_crea_feed_ddf_type = !empty( $showcse_crea_feed_ddf_type ) ? $showcse_crea_feed_ddf_type :'';

$serverArr = explode('/',$_SERVER['REQUEST_URI']);
$page_number_id = 1;
$offset = 0;
$page_number_id = basename(parse_url($_SERVER['REQUEST_URI'], PHP_URL_PATH));
$itemsPerPage = 20;

$default_text_search_results = "";
$crea_advance_search_property_type_results = "";
$crea_advance_search_structure_type_results = "";
$crea_advance_property_status_results = "";
$crea_advance_search_bedrooms_results = "";
$crea_advance_search_bathrooms_results = "";
$crea_advance_search_city_results = "";
$crea_advance_search_city="";
$min_amount_results = "";
$max_amount_results = "";
$showcase_orderby_property_listing_results ="";
$showcase_order_property_listing_results ="";

if(isset( $default_text_search ) && !empty( $default_text_search )) { 
	$default_text_search_results = $default_text_search;
}
if(isset( $crea_advance_search_property_type ) && !empty( $crea_advance_search_property_type )) { 
	$crea_advance_search_property_type_results = $crea_advance_search_property_type;
}
if(isset( $crea_advance_search_structure_type ) && !empty( $crea_advance_search_structure_type )) { 
	$crea_advance_search_structure_type_results = $crea_advance_search_structure_type;
}
if(isset( $crea_advance_search_status ) && !empty( $crea_advance_search_status )) { 
	$crea_advance_property_status_results = $crea_advance_search_status;
}
if(isset( $crea_advance_search_bedrooms ) && !empty( $crea_advance_search_bedrooms )) { 
	$crea_advance_search_bedrooms_results = $crea_advance_search_bedrooms;
}
if(isset( $crea_advance_search_bathrooms ) && !empty( $crea_advance_search_bathrooms )) { 
	$crea_advance_search_bathrooms_results = $crea_advance_search_bathrooms;
}
if(isset( $min_amount ) && !empty( $min_amount )) { 
	$min_amount_results = $min_amount;
}
if(isset( $max_amount ) && !empty( $max_amount )) { 
	$max_amount_results = $max_amount;
}


if ( is_numeric($page_number_id) ) {
	$offset = ( $page_number_id - 1) * $itemsPerPage + 1;
} else { 
	$offset = 0;
	$page_number_id = 1;
}

$getSubscriptionListingFeed = get_option('crea_subscription_status', '');
$allListingArr = array();
$ExculdeListinID = array();
$filter_array_results ="";

if( $crea_showcase_shortcode_id != 'Select Result layout' && $crea_showcase_shortcode_id !='Default - Listings Showcase' && !empty($crea_showcase_shortcode_id) )  {
	$showcaseselectedFeed = get_post_meta($crea_showcase_shortcode_id,'showcse_crea_feed_ddf_type',true);
	$showcaseselectedFeed = isset($showcaseselectedFeed) ? $showcaseselectedFeed : '';
	//Listing View Get Sorting
	$showcse_crea_filter_by_price_sorting = get_post_meta($crea_showcase_shortcode_id,'showcse_crea_serializable_listing_array',true); 
	$showcse_crea_filter_by_price_sorting = !empty( $showcse_crea_filter_by_price_sorting ) ? $showcse_crea_filter_by_price_sorting : '';
	
	//Grid View Get sorting 
	$showcse_crea_grid_view_price_sorting = get_post_meta($crea_showcase_shortcode_id,'showcse_crea_serializable_grid_array',true); 
	$showcse_crea_grid_view_price_sorting = !empty( $showcse_crea_grid_view_price_sorting ) ? $showcse_crea_grid_view_price_sorting : '';
	
	//Carousel View Get sorting 
	$showcse_crea_carousel_view_price_sorting = get_post_meta($crea_showcase_shortcode_id,'showcse_crea_serializable_carousel_array',true); 
	$showcse_crea_carousel_view_price_sorting = !empty( $showcse_crea_carousel_view_price_sorting ) ? $showcse_crea_carousel_view_price_sorting : '';
	
	//Slider View Get sorting 
	$showcse_crea_slider_view_price_sorting = get_post_meta($crea_showcase_shortcode_id,'showcse_crea_serializable_slider_array',true); 
	$showcse_crea_slider_view_price_sorting = !empty( $showcse_crea_slider_view_price_sorting ) ? $showcse_crea_slider_view_price_sorting : '';
	
	//Slider View Get sorting 
	$showcse_crea_map_view_array = get_post_meta($crea_showcase_shortcode_id,'showcse_crea_serializable_map_array',true); 
	$showcse_crea_map_view_array = !empty( $showcse_crea_map_view_array ) ? $showcse_crea_map_view_array : '';
	
	// selected setting price 
	$showcase_order_property_listing_results = "desc";
	$showcase_order_property_listing_results_api = "price-desc";
	$showcase_orderby_property_listing_results =  "meta_value_num";
	//List View Sorting
	if(isset( $showcse_crea_filter_by_price_sorting ) && !empty( $showcse_crea_filter_by_price_sorting )){ 
		$showcse_crea_price_sorting_unserialize = unserialize($showcse_crea_filter_by_price_sorting); 
		$showcase_order_property_listing = !empty( $showcse_crea_price_sorting_unserialize['listingshowcasename'] ) ? $showcse_crea_price_sorting_unserialize['listingshowcasename']:'';
		
		if( $showcase_order_property_listing === 'Price descending'){ 
			$showcase_order_property_listing_results = "desc";
			$showcase_order_property_listing_results_api = "price-desc";
			$showcase_orderby_property_listing_results =  "meta_value_num";
		}
		if( $showcase_order_property_listing === 'Price ascending' ){ 
			$showcase_order_property_listing_results = "asc";
			$showcase_order_property_listing_results_api = "price-asc";
			$showcase_orderby_property_listing_results =  "meta_value_num";
		}
		if( $showcase_order_property_listing === 'Listing date - newest to oldest' ){ 
			$showcase_order_property_listing_results = "DESC";
			$showcase_order_property_listing_results_api = "new2old";
			$showcase_orderby_property_listing_results =  "date";
		}
		if( $showcase_order_property_listing === 'Listing date - oldest to newest' ){ 
			$showcase_order_property_listing_results = "asc";
			$showcase_order_property_listing_results_api = "old2new";
			$showcase_orderby_property_listing_results =  "date";
		}
		if( $showcase_order_property_listing === 'Random' ){ 
			$showcase_order_property_listing_results = 'rand';
			$showcase_order_property_listing_results_api = "rand";
			$showcase_orderby_property_listing_results =  "rand";
		}
	}
	
	//Grid View Sorting 
	if(isset( $showcse_crea_grid_view_price_sorting ) && !empty( $showcse_crea_grid_view_price_sorting )) { 
		$showcse_crea_price_sorting_unserialize = unserialize($showcse_crea_grid_view_price_sorting);
		$showcase_order_property_listing = !empty( $showcse_crea_price_sorting_unserialize['gridviewshowcasename'] ) ? $showcse_crea_price_sorting_unserialize['gridviewshowcasename'] : '';
		if( $showcase_order_property_listing === 'Price descending'){ 
			$showcase_order_property_listing_results = "desc";
			$showcase_order_property_listing_results_api = "price-desc";
			$showcase_orderby_property_listing_results =  "meta_value_num";
		}
		if( $showcase_order_property_listing === 'Price ascending' ){ 
			$showcase_order_property_listing_results = "asc";
			$showcase_order_property_listing_results_api = "price-asc";
			$showcase_orderby_property_listing_results =  "meta_value_num";
		}
		if( $showcase_order_property_listing === 'Listing date - newest to oldest' ){ 
			$showcase_order_property_listing_results = "DESC";
			$showcase_order_property_listing_results_api = "new2old";
			$showcase_orderby_property_listing_results =  "date";
		}
		if( $showcase_order_property_listing === 'Listing date - oldest to newest' ){ 
			$showcase_order_property_listing_results = "asc";
			$showcase_order_property_listing_results_api = "old2new";
			$showcase_orderby_property_listing_results =  "date";
		}
		if( $showcase_order_property_listing === 'Random' ){ 
			$showcase_order_property_listing_results = 'rand';
			$showcase_order_property_listing_results_api = "rand";
			$showcase_orderby_property_listing_results =  "rand";
		}
	}
	
	$showcse_crea_map_view_array_lat_lng_sw_results = "";
	if( $crea_showcase_search_theams_option == 'Map') {  
		if(isset( $showcse_crea_map_view_array ) && !empty( $showcse_crea_map_view_array )){ 
			$showcse_crea_map_view_array_results = maybe_unserialize( $showcse_crea_map_view_array ); 
			if( isset( $showcse_crea_map_view_array_results ) && !empty( $showcse_crea_map_view_array_results )) {   
				$showcse_crea_map_view_array_lat_sw  =  $showcse_crea_map_view_array_results['mapfilterlat_sw'];
				$showcse_crea_map_view_array_lng_sw  =  $showcse_crea_map_view_array_results['mapfilterlong_sw'];
				$showcse_crea_map_view_array_lat_ne  =  $showcse_crea_map_view_array_results['mapfilterlat_ne'];
				$showcse_crea_map_view_array_lng_ne  =  $showcse_crea_map_view_array_results['mapfilterlong_ne'];
			}
		}		
		if( !empty($showcse_crea_map_view_array_lat_sw ) && isset( $showcse_crea_map_view_array_lat_sw ) ){ 
			$showcse_crea_map_view_array_lat_lng_sw_results.= "&lat_sw=".$showcse_crea_map_view_array_lat_sw;
		}
		if( !empty($showcse_crea_map_view_array_lat_sw ) && isset( $showcse_crea_map_view_array_lat_sw ) ){ 
			$showcse_crea_map_view_array_lat_lng_sw_results.= "&lng_sw=".$showcse_crea_map_view_array_lng_sw;
		}
		if( !empty($showcse_crea_map_view_array_lat_sw ) && isset( $showcse_crea_map_view_array_lat_sw ) ){ 
			$showcse_crea_map_view_array_lat_lng_sw_results.= "&lat_ne=".$showcse_crea_map_view_array_lat_ne;
		}
		if( !empty($showcse_crea_map_view_array_lat_sw ) && isset( $showcse_crea_map_view_array_lat_sw ) ){ 
			$showcse_crea_map_view_array_lat_lng_sw_results.= "&lng_ne=".$showcse_crea_map_view_array_lng_ne;
		}
		
		$showcase_custom_result_type = "&result_type=mapmarkers";
	}
	
	
	if( isset( $getSubscriptionListingFeed ) && !empty( $getSubscriptionListingFeed ) && $getSubscriptionListingFeed === 'valid'  ) { 
		
		$setPropertyValue = '';
		if( !empty( $default_text_search ) && $default_text_search != '' ) {
			$setPropertyValue .="&keyword=".rawurlencode($default_text_search);
		}
		
		if( !empty( $crea_advance_search_property_type ) && $crea_advance_search_property_type !='' ) {
			$setPropertyValue .="&property_types=".rawurlencode($crea_advance_search_property_type);	
		}
		if( !empty( $crea_advance_search_structure_type ) && $crea_advance_search_structure_type !='' ) {
			$setPropertyValue .="&structure_types=".rawurlencode($crea_advance_search_structure_type);		
		}
		if( !empty( $crea_advance_search_status ) && $crea_advance_search_status !='' ) {
			$crea_advance_search_status = strtolower($crea_advance_search_status);
			$setPropertyValue .="&transaction_type=".rawurlencode($crea_advance_search_status);
		}
		if( !empty( $crea_advance_search_bedrooms ) && $crea_advance_search_bedrooms !='' ) {
			$setPropertyValue .="&bed_min=$crea_advance_search_bedrooms";	
			//$setPropertyValue .="&bed_max=$crea_advance_search_bedrooms";	
		}
		if( !empty( $crea_advance_search_bathrooms ) && $crea_advance_search_bathrooms !='' ) {
			$setPropertyValue .="&bath_min=$crea_advance_search_bathrooms";	
			//$setPropertyValue .="&bath_max=$crea_advance_search_bathrooms";	
		}
		if( !empty( $crea_advance_search_city ) && $crea_advance_search_city !='' ) {
			$setPropertyValue .="&city=".rawurlencode($crea_advance_search_city);	
		}
		if( isset( $min_amount ) && $min_amount !='' ) {
			$setPropertyValue .="&price_min=$min_amount";
		}
		if( isset( $max_amount ) && $max_amount !='' ) {
			$setPropertyValue .="&price_max=$max_amount";	
		}
		
		if ( !empty($showcase_order_property_listing_results_api) ){ 
			$setPropertyValue .="&order=$showcase_order_property_listing_results_api";
		}
		
		$filter_array_results =  '';
		if( !empty($crea_showcase_search_theams_option) && $crea_showcase_search_theams_option == "Listing View" ) {  
	
			
			//API Record Limit
			if ( !empty($record_limit) ) { 
				$filter_array_results.= '&limit=20';
			}
			
			if ( !empty($offset) ) { 
				$filter_array_results.= '&offset='.$offset;
			}
		} elseif ( $crea_showcase_search_theams_option == "Grid View") { 
			//API Record Limit
			
			if ( !empty($record_limit) ) { 
				$filter_array_results.= '&limit=20';
			}
			
			if ( !empty($offset) ) { 
				$filter_array_results.= '&offset='.$offset;
			}
		}
		
		$filter_include_exclusive_result = '';
		if( !empty($showcse_crea_feed_include_exclude) || $showcse_crea_feed_include_exclude == 'yes' ) {
			$filter_include_exclusive_result .="&exclusive=true";	
		}
		
		
		$userNameFilter = '';
		if ( !empty($showcse_crea_feed_ddf_type) && $showcse_crea_feed_ddf_type != 'Exclusive Listing' ) { 
			$userNameFilter .= '&feed='.$showcse_crea_feed_ddf_type;
		}
		
		$final_query_param = '';
		$final_query_param = $setPropertyValue.$filter_array_results;
		
			
			//$showcse_crea_map_view_array_lat_lng_sw_results
			$domainName = $_SERVER['SERVER_NAME'];
			$ch = curl_init();
			if( $crea_showcase_search_theams_option == 'Map' ) { 
				curl_setopt($ch, CURLOPT_URL, "http://api.aretk.com/?key=$subscriptionKey&request=listings$filter_include_exclusive_result$userNameFilter$showcase_custom_result_type$setPropertyValue");	
			} else { 
				curl_setopt($ch, CURLOPT_URL, "http://api.aretk.com/?key=$subscriptionKey&request=listings$filter_include_exclusive_result$userNameFilter$showcase_custom_result_type$setPropertyValue$filter_array_results");
			}
			curl_setopt($ch, CURLOPT_HEADER, 0);
			curl_setopt($ch, CURLOPT_RETURNTRANSFER,true);
			curl_setopt($ch, CURLOPT_REFERER,$domainName);
	
			$data = curl_exec($ch);
			curl_close($ch);
			
			
			$listings = json_decode($data);
			$allListingArr = array();
			foreach ( $listings as $listing_key => $listing ){  
				
        		if ( !isset( $listing->TotalRecords ) && empty( $listing->TotalRecords ) ) { 
        			if ( $crea_showcase_search_theams_option == 'Map'  ){ 
        				$allListingArr[$listing->ID] = $listing;
        			} else {
        				$allListingArr[$listing->ID] = $listing;
        			}
        		}
        	}
		//}
		
		$total_listing_records = $listings[0]->TotalRecords;
	} else {
		$searchArray = array();
		if( $default_text_search !='' && !empty( $default_text_search ) ) {
			$searchArray[] = array(
				'key'     => 'listingAddress',
				'value'   => $default_text_search,
				'compare' => 'LIKE'
			);
		}
		
		if( $crea_advance_search_property_type !='' && !empty( $crea_advance_search_property_type ) ) {
			$searchArray[] = array(
				'key'     => 'listingPropertyType',
				'value'   => $crea_advance_search_property_type,
				'compare' => 'LIKE'
			);
		}
		
		if( $crea_advance_search_structure_type !='' && !empty( $crea_advance_search_structure_type ) ) {
			$searchArray[] = array(
				'key'     => 'listingStructureType',
				'value'   => $crea_advance_search_structure_type,
				'compare' => 'LIKE'
			);
		}
		
		if( $crea_advance_search_status !='' && !empty( $crea_advance_search_status ) ) {
			$searchArray[] = array(
				'key'     => 'listingAgentStatus',
				'value'   => $crea_advance_search_status,
				'compare' => 'LIKE'
			);
		}
		
		if( $crea_advance_search_bedrooms !='' && !empty( $crea_advance_search_bedrooms ) ) {
			$searchArray[] = array(
				'key'     => 'listingBedRooms',
				'value'   => $crea_advance_search_bedrooms,
				'compare' => '=',
				'type' => 'numeric'
			);
		}
		
		if( $crea_advance_search_bathrooms !='' && !empty( $crea_advance_search_bathrooms ) ) {
			$searchArray[] = array(
				'key'     => 'listingBathrooms',
				'value'   => $crea_advance_search_bathrooms,
				'compare' => '=',
				'type' => 'numeric'
			);
		}
		
		
		if( $min_amount !='' && isset( $min_amount ) ) {
			$searchArray[] = array(
				'key' => 'listingPrice',
				'value' => $min_amount,
				'compare' => '>=',
				'type' => 'numeric',
			);
		}
		
		if( $max_amount !='' && isset( $max_amount ) ) {
			$searchArray[] = array(
				'key' => 'listingPrice',
				'value' => $max_amount,
				'compare' => '<=',
				'type' => 'numeric',
			);
		}
		$args = array(
		    'post_type'  => 'aretk_listing',
		    'post_status'  => 'publish',
		    'posts_per_page' => -1,
		    'meta_key'  => 'listingPrice',
			'orderby' => $showcase_orderby_property_listing_results,
			'order' => $showcase_order_property_listing_results,
		    'meta_query' => array(
		       'relation' => 'AND',
		       $searchArray
		    )
		);
		
		$posts_array = (array) get_posts( $args );
						
		$propertyDataArr = array();
		
		foreach ($posts_array as $singlePost) {
			$propertyDataArr[]= $singlePost->ID;
		}
				
		$args_property = array(
			'post_type' => 'aretk_listing',
			'posts_per_page' => $itemsPerPage,
			'paged' => $page_number_id,
			'post_status'     => 'publish',
			'post__in' => $propertyDataArr,
			'meta_query' => array(
		       'relation' => 'AND',
		       $searchArray
		    )
		);
		
		$property_array = (array) get_posts( $args_property );
		
		$exclusiveArr = array();
		foreach ($property_array as $singlePost) {
			$singlePost1 = (array) $singlePost;
			$singlePost2 = (object) $singlePost1;
			$ExculdeListinID[] =  $singlePost2;
		}
		
		$allListingFinalArr = array();
		$allListingFinalArr = $exclusiveArr;
		$total_listing_records = count($propertyDataArr);
	}
	
	
} else { 
	
	$ExculdeListinID = array();
	$getSubscriptionListingFeed = get_option('crea_subscription_status', '');
	if( isset( $getSubscriptionListingFeed ) && !empty( $getSubscriptionListingFeed ) && $getSubscriptionListingFeed === 'valid'  ) { 
		
		$setPropertyValue = '';
		if( !empty( $default_text_search ) && $default_text_search != '' ) {
			$setPropertyValue .="&keyword=".rawurlencode($default_text_search);
		}
		
		if( !empty( $crea_advance_search_property_type ) && $crea_advance_search_property_type !='' ) {
			$setPropertyValue .="&property_types=".rawurlencode($crea_advance_search_property_type);	
		}
		if( !empty( $crea_advance_search_structure_type ) && $crea_advance_search_structure_type !='' ) {
			$setPropertyValue .="&structure_types=".rawurlencode($crea_advance_search_structure_type);		
		}
		if( !empty( $crea_advance_search_status ) && $crea_advance_search_status !='' ) {
			$crea_advance_search_status = strtolower($crea_advance_search_status);
			$setPropertyValue .="&transaction_type=".rawurlencode($crea_advance_search_status);
		}
		if( !empty( $crea_advance_search_bedrooms ) && $crea_advance_search_bedrooms !='' ) {
			$setPropertyValue .="&bed_min=$crea_advance_search_bedrooms";	
		}
		if( !empty( $crea_advance_search_bathrooms ) && $crea_advance_search_bathrooms !='' ) {
			$setPropertyValue .="&bath_min=$crea_advance_search_bathrooms";	
		}
		if( !empty( $crea_advance_search_city ) && $crea_advance_search_city !='' ) {
			$setPropertyValue .="&city=".rawurlencode($crea_advance_search_city);	
		}
		if( isset( $min_amount ) && $min_amount !='' ) {
			$setPropertyValue .="&price_min=$min_amount";
		}
		if( isset( $max_amount ) && $max_amount !='' ) {
			$setPropertyValue .="&price_max=$max_amount";	
		}
		
		$tableName= $wpdb->prefix.'crea_user_listing_detail';
		$getListingUsernameQuery = "SELECT `username` FROM `$tableName`";
		$getUserNameResults = $wpdb->get_results($getListingUsernameQuery);
		$userNameArray = array();
		//if( !empty( $getUserNameResults ) && $getUserNameResults !='' ) {
			$userNameValues = '';
			$userNameValues = $getUserNameResults[0]->username;
			$filter_by_username = '';
			if ( !empty($userNameValues) && $userNameValues != '') { 
				$filter_by_username .= '&feed='.$userNameValues; 
			}
			
			$filter_array_results =  '';
			if ( !empty($itemsPerPage) ) { 
				$filter_array_results.= '&limit=20';
			}
			
			if ( !empty($offset) ) { 
				$filter_array_results.= '&offset='.$offset;
			}
			
			$domainName = $_SERVER['SERVER_NAME'];
			$ch = curl_init();
			curl_setopt($ch, CURLOPT_URL, "http://api.aretk.com/?key=$subscriptionKey&request=listings&exclusive=true$filter_by_username$showcase_custom_result_type$setPropertyValue$filter_array_results");
			curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
			curl_setopt($ch, CURLOPT_HEADER, 0);
			curl_setopt($ch, CURLOPT_RETURNTRANSFER,true);
			curl_setopt($ch, CURLOPT_REFERER,$domainName);
	
			$data = curl_exec($ch);
			curl_close($ch);
			$listings = json_decode($data);
			$allListingArr = array();
			foreach ( $listings as $listing_key => $listing ){  
				
        		if ( !isset( $listing->TotalRecords ) && empty( $listing->TotalRecords ) ) { 
        			$allListingArr[$listing->ID] = $listing;
        		}
        	}
                	
			$total_listing_records = $listings[0]->TotalRecords;
			
		//}
	} else { 
	
		$searchArray = array();
		if( $default_text_search !='' && !empty( $default_text_search ) ) {
			$searchArray[] = array(
				'key'     => 'listingAddress',
				'value'   => $default_text_search,
				'compare' => 'LIKE'
			);
		}
		
		if( $crea_advance_search_property_type !='' && !empty( $crea_advance_search_property_type ) ) {
			$searchArray[] = array(
				'key'     => 'listingPropertyType',
				'value'   => $crea_advance_search_property_type,
				'compare' => 'LIKE'
			);
		}
		
		if( $crea_advance_search_structure_type !='' && !empty( $crea_advance_search_structure_type ) ) {
			$searchArray[] = array(
				'key'     => 'listingStructureType',
				'value'   => $crea_advance_search_structure_type,
				'compare' => 'LIKE'
			);
		}
		
		if( $crea_advance_search_status !='' && !empty( $crea_advance_search_status ) ) {
			$searchArray[] = array(
				'key'     => 'listingAgentStatus',
				'value'   => $crea_advance_search_status,
				'compare' => 'LIKE'
			);
		}
		
		if( $crea_advance_search_bedrooms !='' && !empty( $crea_advance_search_bedrooms ) ) {
			$searchArray[] = array(
				'key'     => 'listingBedRooms',
				'value'   => $crea_advance_search_bedrooms,
				'compare' => '=',
				'type' => 'numeric'
			);
		}
		
		if( $crea_advance_search_bathrooms !='' && !empty( $crea_advance_search_bathrooms ) ) {
			$searchArray[] = array(
				'key'     => 'listingBathrooms',
				'value'   => $crea_advance_search_bathrooms,
				'compare' => '=',
				'type' => 'numeric'
			);
		}
		
		
		if( $min_amount !='' && isset( $min_amount ) ) {
			$searchArray[] = array(
				'key' => 'listingPrice',
				'value' => $min_amount,
				'compare' => '>=',
				'type' => 'numeric',
			);
		}
		
		if( $max_amount !='' && isset( $max_amount ) ) {
			$searchArray[] = array(
				'key' => 'listingPrice',
				'value' => $max_amount,
				'compare' => '<=',
				'type' => 'numeric',
			);
		}
		
		
		$args = array(
		    'post_type'  => 'aretk_listing',
		    'post_status'  => 'publish',
		    'posts_per_page' => -1,
		    'meta_key'  => 'listingPrice',
			'orderby' => $showcase_orderby_property_listing_results,
			'order' => $showcase_order_property_listing_results,
		    'meta_query' => array(
		       'relation' => 'AND',
		       $searchArray
		    )
		);
		
		$posts_array = (array) get_posts( $args );
						
		$propertyDataArr = array();
		
		foreach ($posts_array as $singlePost) {
			$propertyDataArr[]= $singlePost->ID;
		}
				
		$args_property = array(
			'post_type' => 'aretk_listing',
			'posts_per_page' => $itemsPerPage,
			'paged' => $page_number_id,
			'post_status'     => 'publish',
			'post__in' => $propertyDataArr,
			'meta_query' => array(
		       'relation' => 'AND',
		       $searchArray
		    )
		);
		
		$property_array = (array) get_posts( $args_property );
		
		$exclusiveArr = array();
		foreach ($property_array as $singlePost) {
			$singlePost1 = (array) $singlePost;
			$singlePost2 = (object) $singlePost1;
			$ExculdeListinID[] =  $singlePost2;
		}
		
		$allListingFinalArr = array();
		$allListingFinalArr = $exclusiveArr;
		$total_listing_records = count($propertyDataArr);
		
	}
}

$allListingFinalArr = array_merge($allListingArr,$ExculdeListinID);
$allLisgngFinalArrCount =  count($allListingFinalArr);

//Layout based HTML
$showcaseSCID = !empty($crea_showcase_shortcode_id) ? $crea_showcase_shortcode_id :'';
$site_image_path = ARETK_CREA_PLUGIN_URL.'public/images/preview_img.jpg';
$finalResultsArr = array();
$mergeSearchArray = array();

//get showcse shotcode values
$showcse_crea_filter_brokerage ='';
$showcse_crea_display_theams_option ='';
$showcse_crea_feed_include_exclude ='';
$showcse_crea_feed_ddf_type ='';
$showcse_crea_filter_office ='';
$showcse_crea_filter_inclue_open_house ='';
$showcse_crea_filter_by_other_day ='';
$showcse_crea_filter_by_map_km ='';
$showcse_crea_filter_listing ='';
$showcse_crea_serializable_listing_array ='';
$showcse_crea_serializable_grid_array ='';
$showcse_crea_serializable_carousel_array ='';
$showcse_crea_serializable_map_array ='';
$showcse_crea_serializable_slider_array ='';
$Showcase_crea_grid_view_color_array ='';
$Showcase_crea_listing_view_color_array ='';
$Showcase_crea_slider_view_color_array ='';
$Showcase_crea_map_view_color_array =''; 
$Showcase_crea_carousel_view_color_array ='';

if ( !empty( $total_listing_records ) ){ 
	$max_numbers_pagination = ($total_listing_records / $itemsPerPage);
}

$html ="";

if( $showcaseSCID == 'Select Result layout' || $showcaseSCID =='Default - Listings Showcase' || empty($showcaseSCID) ) {
	//No any showcase selected
	//default listing view selected.<br>
	
	$html ='';
	$html.='<div class="se-pre-con"></div>';
	$html.='<div class="aretk-wrap">';
	$html.='<div id="paging_container_date" class="container">';
				
		$html.='<ul class="content">';
		$crea_default_listing_text				= get_option('crea_default_listing_text');
		$crea_default_listing_address 	 		= get_option('crea_default_listing_address_bar_listing_include');
		$crea_default_listing_price			 	= get_option('crea_default_listing_price_color');
		$crea_default_listing_status 			= get_option('crea_default_listing_status_color');
		$crea_default_listing_openhouse			= get_option('crea_default_listing_openhouse_color');
		
		$crea_default_listing_text_color 		= isset($crea_default_listing_text)?$crea_default_listing_text : 'ab2567';
		$crea_default_listing_address_color		= isset($crea_default_listing_address)?$crea_default_listing_address : 'ab2567';
		$crea_default_listing_price_color 		= isset($crea_default_listing_price)?$crea_default_listing_price : 'ab2567';
		$crea_default_listing_status_color 		= isset($crea_default_listing_status)?$crea_default_listing_status : 'ab2567';
		$crea_default_listing_openhouse_color 	= isset($crea_default_listing_openhouse)?$crea_default_listing_openhouse : 'ab2567';
		$allLisgngFinalArrCount =  count($allListingFinalArr);

		if ( !empty($allListingFinalArr) && isset($allListingFinalArr) && $allLisgngFinalArrCount > 0 )  {
			foreach ( $allListingFinalArr as $singleListing ) {
				
				if ( isset( $singleListing->post_author ) && !empty( $singleListing->post_author ) ) { 
					$content_post = get_post($singleListing->ID);
					
					if (!empty($content_post) && $content_post != '') {
						$listing_post_content = $content_post->post_content;
					}
					
					$ListingAddress = get_post_meta($singleListing->ID,'listingAddress',true);
					$ListingAddress = !empty($ListingAddress) ? $ListingAddress : '';
					
					$ListingCity = get_post_meta($singleListing->ID,'listingcity',true);
					$ListingCity = !empty($ListingCity) ? $ListingCity : '';
					
					$listingProvince = get_post_meta($singleListing->ID,'listingProvince',true);
					$listingProvince = !empty($listingProvince) ? $listingProvince : '';
					
					$ListingPrice = get_post_meta($singleListing->ID,'listingPrice',true);
					$ListingPrice = !empty($ListingPrice) ? $ListingPrice : '';
					
					$ListingBedRooms = get_post_meta($singleListing->ID, 'listingBedRooms', true);
					$ListingBedRooms = !empty($ListingBedRooms) ? $ListingBedRooms : '';
					
					$ListingBathrooms = get_post_meta($singleListing->ID, 'listingBathrooms', true);
					$ListingBathrooms = !empty($ListingBathrooms) ? $ListingBathrooms : '';
					
					
					$listingAgentStatus = get_post_meta($singleListing->ID, 'listingAgentStatus', true);
					$listingAgentStatus = !empty($listingAgentStatus) ? $listingAgentStatus : '';
					
					$listingopenhosedatetimeArr = get_post_meta($singleListing->ID, 'listingopenhosedatetimeArr', true);
					$listingopenhosedatetimeArr = json_decode($listingopenhosedatetimeArr);
					$listingopenhosedatetimeArr = !empty($listingopenhosedatetimeArr) ? $listingopenhosedatetimeArr : '';
					
					$date = date('d-m-Y',strtotime($singleListing->post_date));
					
					$crea_listing_images_detail_table_name = $wpdb->prefix . CREA_LISTING_IMAGES_HISTORY;
					$querySelectFirstImage = "SELECT image_url FROM $crea_listing_images_detail_table_name WHERE image_position =1 AND unique_id = $singleListing->ID";
					
					$resultSet = $wpdb->get_results($querySelectFirstImage);
					if (isset($resultSet) && !empty($resultSet)) {
						$path = $resultSet[0]->image_url;
					} else {
						$path = $site_image_path;
					}
					
					$listing_full_address_path = '';
					if ( !empty( $ListingAddress )  ) {
						$singleListingStreetAddress = trim($ListingAddress);
						$singleListingStreetAddress = str_replace(' ', '-', $singleListingStreetAddress);
						$singleListingStreetAddress = str_replace('#', '', $singleListingStreetAddress);
						$singleListingStreetAddress = str_replace('--','-',$singleListingStreetAddress);
						$singleListingStreetAddress = str_replace('---','-',$singleListingStreetAddress);
						$listing_full_address_path.= $singleListingStreetAddress;
					}
					
					if ( !empty( $ListingCity ) ) {
						$singleListingStreetCity = trim($ListingCity);
						$singleListingStreetCity = str_replace(' ', '-', $singleListingStreetCity);
						$singleListingStreetCity = str_replace('#', '', $singleListingStreetCity);
						$singleListingStreetCity = str_replace('--','-',$singleListingStreetCity);
						$singleListingStreetCity = str_replace('---','-',$singleListingStreetCity);
						$listing_full_address_path.='-'.trim($singleListingStreetCity);
					}
					
					if ( !empty( $listingProvince ) ) {
						$singleListingStreetProvince = trim($listingProvince);
						$singleListingStreetProvince = str_replace(' ', '-', $singleListingStreetProvince);
						$singleListingStreetProvince = str_replace('#', '', $singleListingStreetProvince);
						$singleListingStreetProvince = str_replace('--','-',$singleListingStreetProvince);
						$singleListingStreetProvince = str_replace('---','-',$singleListingStreetProvince);
						$listing_full_address_path.='-'.trim($singleListingStreetProvince);
					}
					
					$property_address = $ListingAddress;
					
					if( isset( $listing_full_address_path ) && !empty( $listing_full_address_path ) && $listing_full_address_path != " " ) {
							$html .='<li>';
								$html .='<div class="prop-listing default pr ">'; 
									$html .='<div class="aret-row">';
										$html .='<div class="aret-col-3 pr">';
											
										$default_listing_searchbar_yes_or_not 	= get_option('crea_default_listing_searchbar_yes_or_not');
										$default_listing_openhouse_yes_or_not 	= get_option('crea_default_listing_openhouse_yes_or_not');
										
										$default_listing_status_yes_or_not 		= get_option('crea_default_listing_status_yes_or_not');
										
										$default_listing_openhouse_bg_color 	= get_option('crea_default_listing_openhouse_color');
										$default_listing_openhouse_color_text 	= get_option('crea_default_listing_openhouse_text_color');
										
										$default_listing_status_color_bg_text 	= get_option('crea_default_listing_status_color');
										$default_listing_status_color_text 		= get_option('crea_default_listing_status_text_color');
										
										$open_house_text_color 	 = !empty( $default_listing_openhouse_color_text ) ? $default_listing_openhouse_color_text :'fff';
										$open_house_bg_color 	 = !empty( $default_listing_openhouse_bg_color ) ? $default_listing_openhouse_bg_color :'fff';
										
										$status_text_color		 = !empty( $default_listing_status_color_text ) ? $default_listing_status_color_text :'fff';
										$status_bg_color		 = !empty( $default_listing_status_color_bg_text ) ? $default_listing_status_color_bg_text :'000';
											
											if( isset( $default_listing_openhouse_yes_or_not ) && !empty( $default_listing_openhouse_yes_or_not )){ 
												if( $default_listing_openhouse_yes_or_not == 'yes') { 
													if ( !empty( $listingopenhosedatetimeArr[0]->date ) ) { 
														$html .= '<p class="listing_openhouse defalut_listing_openhouse" style="color:#'.$open_house_text_color.';background: #'.$open_house_bg_color.'">open house</p>';
													}		
												}
											}
											$listing_full_address_path_results = str_replace('-', ' ', $listing_full_address_path);	
											$html .='<a class="property_link" href="'.home_url().'/listing-detail/'.$singleListing->ID.'/'.$listing_full_address_path.'"><img src="'.$path.'" class="imag_listing" alt="'.$listing_full_address_path_results.'"></a>';
											
											if( isset( $default_listing_status_yes_or_not) && !empty( $default_listing_status_yes_or_not ) && $default_listing_status_yes_or_not == 'yes' ){
												$html.='<p class="listing_status listing_statusdefault_listing" style="color:#'.$status_text_color.';background:#'.$status_bg_color.'">'.$listingAgentStatus.'</p>';		
											}
											
										$html .='</div>';
										
										$html .='<a class="property_link" href="'.home_url().'/listing-detail/'.$singleListing->ID.'/'.$listing_full_address_path.'"><div class="aret-col-9 no-mar-right">';
											$html .='<div class="info-box">';
												if( isset( $Showcase_crea_listing_view_color_array_reults ) && !empty( $Showcase_crea_listing_view_color_array_reults ) ) { 
													$Showcase_crea_listing_view_color_title =  $Showcase_crea_listing_view_color_array_reults['listingShowcaseAddressBarColor'];					
													if(!empty( $Showcase_crea_listing_view_color_title )  ) { 
														$Showcase_crea_listing_color_title = $Showcase_crea_listing_view_color_title;
													} else { 
														$Showcase_crea_listing_color_title = '000';
													}
												}
												
												$html .='<h4 style="color:#'.$crea_default_listing_address_color.'">'.$listing_full_address_path.'</h4>';
												$html .='<div class="info-bar">';
													if ( !empty( $ListingBedRooms ) ) { 
														$html .='<span class="bad">'.$ListingBedRooms.' Bedrooms</span>';
													}
													
													if ( !empty( $ListingBathrooms ) ) { 
														$html .='<span class="bathroom">'.$ListingBathrooms.' Bathrooms</span>';
													}
												$html .='</div>';
												
											
												if( $listing_post_content == ''){  
													
													$html .='<p style =color:#'.$crea_default_listing_text_color.'>No Property description.</p>';	
												} else { 
													$html .='<p style =color:#'.$crea_default_listing_text_color.'>'.strip_tags(substr($listing_post_content,0,150)).'...</p>';								
												}
												
											$html .='</div>';
										$html .='</div></a>';
											
										
											if ( !empty($ListingPrice)){ 
												
												$html .='<div class="footer-info aret-col-9"><span style = "color:#'.$crea_default_listing_price_color.'">'.'$'.number_format($ListingPrice).'</span> ';
											}
										
											$html .='<div class="menu" style="display: none;  background-color:#'.$crea_default_listing_address_color.'">';
												$sharing_url = site_url('/listing-detail/'.$singleListing->ID.'/'.$listing_full_address_path);	
												$html .='<a class="social_facebook" target="_blank" href="http://www.facebook.com/sharer.php?u='.$sharing_url.'/&amp;t='.$listing_full_address_path.'"></a>';
												$html .='<a class="social_tweet" target="_blank" href="http://twitter.com/home?status='.$listing_full_address_path.'+'.$sharing_url.'"  ></a>';
												//$html .='<a class="social_google" target="_blank" onclick="javascript:window.open(this.href, " ", "menubar=no,toolbar=no,resizable=yes,scrollbars=yes,height=600,width=600");return false;" href="https://plus.google.com/share?url='.$sharing_url.'/" ></a>'; 
												$html .='<a class="social_google" target="_blank"  href="https://plus.google.com/share?url='.$sharing_url.'/" ></a>'; 
												$html .='<a class="social_pinterest" target="_blank" href="http://pinterest.com/pin/create/button/?url='.$sharing_url.'/&media='.$path.'&description='.$listing_full_address_path.'" ></a>';
											$html .='</div>';
											$html.='<a  class="aret-icon share showmenu_listing"></a>';
										$html .='</div>';
									$html .='</div>';
								$html .='</div>';
							$html .='</li>';
					}
				
				} else { 
							
							$listing_full_address_path = '';
							
							if ( !empty($singleListing->StreetAddress) && !empty( $singleListing->City ) && !empty( $singleListing->Province ) ) { 
								if ( !empty( $singleListing->StreetAddress )  ) {
									$singleListingStreetAddress = trim($singleListing->StreetAddress);
									$singleListingStreetAddress = str_replace(' ', '-', $singleListingStreetAddress);
									$singleListingStreetAddress = str_replace('#', '', $singleListingStreetAddress);
									$singleListingStreetAddress = str_replace('--','-',$singleListingStreetAddress);
									$singleListingStreetAddress = str_replace('---','-',$singleListingStreetAddress);
									$listing_full_address_path.= $singleListingStreetAddress;
								}
								
								if ( !empty( $singleListing->City ) ) {
									$singleListingStreetCity = trim($singleListing->City);
									$singleListingStreetCity = str_replace(' ', '-', $singleListingStreetCity);
									$singleListingStreetCity = str_replace('#', '', $singleListingStreetCity);
									$singleListingStreetCity = str_replace('--','-',$singleListingStreetCity);
									$singleListingStreetCity = str_replace('---','-',$singleListingStreetCity);
									$listing_full_address_path.='-'.trim($singleListingStreetCity);
								}
								
								if ( !empty( $singleListing->Province ) ) {
									$singleListingStreetProvince = trim($singleListing->Province);
									$singleListingStreetProvince = str_replace(' ', '-', $singleListingStreetProvince);
									$singleListingStreetProvince = str_replace('#', '', $singleListingStreetProvince);
									$singleListingStreetProvince = str_replace('--','-',$singleListingStreetProvince);
									$singleListingStreetProvince = str_replace('---','-',$singleListingStreetProvince);
									$listing_full_address_path.='-'.trim($singleListingStreetProvince);
								}
							} else { 
								if ( !empty( $singleListing->generated_address ) ) { 
									$singleListinggeneratedAddress = trim($singleListing->generated_address);
									$singleListinggeneratedAddress = str_replace(' ', '-', $singleListinggeneratedAddress);
									$singleListinggeneratedAddress = str_replace('#', '', $singleListinggeneratedAddress);
									$singleListinggeneratedAddress = str_replace('--','-',$singleListinggeneratedAddress);
									$singleListinggeneratedAddress = str_replace('---','-',$singleListinggeneratedAddress);
									$listing_full_address_path.= $singleListinggeneratedAddress;
								}
							}
							
							$property_address = !empty( $singleListing->StreetAddress ) ? $singleListing->StreetAddress : 'Address not available';
							$listing_openHouses = !empty( $singleListing->listing_openHouses ) ? $singleListing->listing_openHouses : '';
							$listingSizeInterior = !empty($singleListing->SizeInterior) ? $singleListing->SizeInterior : '';
							
							if ( $singleListing->listing_photos != null ) { 
									if ( isset( $singleListing->listing_photos) && !empty( $singleListing->listing_photos ) && !is_array($singleListing->listing_photos) ){
										if( !empty( $singleListing->listing_photos )) {  
											$domain_name = $_SERVER['SERVER_NAME'];
											$singleListingimag_array  = explode('/',$singleListing->listing_photos->URL);
											if( !empty($singleListingimag_array )){ 
												$single_listing_carousel = $singleListingimag_array[2];
												if( $domain_name == $single_listing_carousel ){ 
													list($width, $height, $type, $attr) = getimagesize($singleListing->listing_photos->URL);
														if( !empty( $width ) &&  $width !='0') { 
															$singleListingImage = $singleListing->listing_photos->URL;
														} else { 
															$singleListingImage = $site_image_path;
														}
												} else if( $domain_name != $single_listing_carousel && $single_listing_carousel !='static.aretk.com' ) { 
													$singleListingImage = $site_image_path;
												} else { 
													$singleListingImage = $singleListing->listing_photos->URL;
												}
											}
											
										}
										
									} else { 
										$domain_name = $_SERVER['SERVER_NAME'];
										$singleListingimag_array  = explode('/',$singleListing->listing_photos[0]->URL);
										if( !empty($singleListingimag_array )){ 
											$single_listing_carousel = $singleListingimag_array[2];
											if( $domain_name == $single_listing_carousel ){ 
												list($width, $height, $type, $attr) = getimagesize($singleListing->listing_photos[0]->URL);
													if( !empty( $width ) &&  $width !='0') { 
														$singleListingImage = $singleListing->listing_photos[0]->URL;
													} else { 
														$singleListingImage = $site_image_path;
													}
											} else if( $domain_name != $single_listing_carousel && $single_listing_carousel !='static.aretk.com' ) { 
												$singleListingImage = $site_image_path;
											} else { 
												$singleListingImage = $singleListing->listing_photos[0]->URL;
											}
										}						

									}
								} else { 
									
									$singleListingImage = $site_image_path;
								}
							
							$is_exclusive_list = '';
							$property_link_url = '';	
							if ( !empty( $singleListing->mlsID ) && $singleListing->mlsID == 'Exclusive'){ 
								$is_exclusive_list = '/exclusive';
								$property_link_url = site_url().'/listing-detail/'.$singleListing->ID.$is_exclusive_list.'/'.$listing_full_address_path;
							} else { 
								$property_link_url = site_url().'/listing-detail/'.$singleListing->ID.'/'.$listing_full_address_path;
							}
							
								$html .='<li>';
									$html .='<div class="prop-listing default pr">'; 
										$html .='<div class="aret-row">';
											$html .='<div class="aret-col-3 pr">';
												if( isset( $Showcase_crea_listing_view_color_array_reults ) && !empty( $Showcase_crea_listing_view_color_array_reults ) ) { 
													$Showcase_crea_listing_view_color_status =  $Showcase_crea_listing_view_color_array_reults['listingShowcaseStatusColor'];					
													$Showcase_crea_listing_view_Text_color_status =  $Showcase_crea_listing_view_color_array_reults['listingShowcaseStatusTextColor'];					
													if(!empty( $Showcase_crea_listing_view_color_status )  ) { 
														$Showcase_crea_listing_color_status = $Showcase_crea_listing_view_color_status;
													} else { 
														$Showcase_crea_listing_color_status = '000';
													}
												}
												
												$default_listing_searchbar_yes_or_not = get_option('crea_default_listing_searchbar_yes_or_not');
												$default_listing_openhouse_yes_or_not = get_option('crea_default_listing_openhouse_yes_or_not');
												$default_listing_status_yes_or_not = get_option('crea_default_listing_status_yes_or_not');
												
												$default_listing_openhouse_bg_color 	= get_option('crea_default_listing_openhouse_color');
												$default_listing_openhouse_color_text 	= get_option('crea_default_listing_openhouse_text_color');
												
												$default_listing_status_color_bg_text 	= get_option('crea_default_listing_status_color');
												$default_listing_status_color_text 		= get_option('crea_default_listing_status_text_color');
												
												$open_house_text_color 	 				= !empty( $default_listing_openhouse_color_text ) ? $default_listing_openhouse_color_text :'fff';
												$open_house_bg_color 	 				= !empty( $default_listing_openhouse_bg_color ) ? $default_listing_openhouse_bg_color :'fff';
												
												$status_text_color		 				= !empty( $default_listing_status_color_text ) ? $default_listing_status_color_text :'fff';
												$status_bg_color		 				= !empty( $default_listing_status_color_bg_text ) ? $default_listing_status_color_bg_text :'000';
												
											 	
												if( isset( $default_listing_openhouse_yes_or_not ) && !empty( $default_listing_openhouse_yes_or_not )){ 
													if( $default_listing_openhouse_yes_or_not == 'yes') { 
														if ( $listing_openHouses != null ){ 
															$html .= '<p class="listing_openhouse defalut_listing_openhouse" style="color:#'.$open_house_text_color.';background:#'.$open_house_bg_color.' ">open house</p>';
														}	
													}
												}
												$listing_full_address_path_results = str_replace('-', ' ', $listing_full_address_path);	
												$html .='<a class="property_link" href="'.$property_link_url.'"><img src="'.$singleListingImage.'" class="imag_listing" alt="'.$listing_full_address_path_results.'"></a>';
	
												if( isset( $default_listing_status_yes_or_not) && !empty( $default_listing_status_yes_or_not ) && $default_listing_status_yes_or_not == 'yes' ){	
													$html.='<p class=listing_statusdefault_listing style=color:#'.$status_text_color.';background:#'.$status_bg_color.'>'.$singleListing->TransactionType.'</p>';
												}
												
											$html .='</div>';
											$html .='<a class="property_link" href="'.site_url().'/listing-detail/'.$singleListing->ID.'/'.$listing_full_address_path.'"><div class="aret-col-9 no-mar-right">';
												$html .='<div class="info-box">';
													if( isset( $Showcase_crea_listing_view_color_array_reults ) && !empty( $Showcase_crea_listing_view_color_array_reults ) ) { 
														$Showcase_crea_listing_view_color_title =  $Showcase_crea_listing_view_color_array_reults['listingShowcaseAddressBarColor'];					
														if(!empty( $Showcase_crea_listing_view_color_title )  ) { 
															$Showcase_crea_listing_color_title = $Showcase_crea_listing_view_color_title;
														} else { 
															$Showcase_crea_listing_color_title = '000';
														}
													}
													
													if(isset( $singleListing->mlsID ) && !empty( $singleListing->mlsID )) {
														$html.='<span><h4 style="color:#'.$crea_default_listing_address_color.'" class="default_listing_mlsID" >MLS&reg#'.$singleListing->mlsID.'</h4></span>';
													}
													
													if ( !empty( $singleListing->StreetAddress ) ) { 
														$html .='<h4  style="color:#'.$crea_default_listing_address_color.'">'.$singleListing->StreetAddress.'</h4>';
													} else { 
														$html .='<h4  style="color:#'.$crea_default_listing_address_color.'">'.$singleListing->generated_address.'</h4>';
													}
													
													$html .='<div class="info-bar">';
														if ( !empty( $singleListing->BedroomsTotal ) && $singleListing->BedroomsTotal > 0 ){ 
															$html .='<span class="bad">'.$singleListing->BedroomsTotal.' Bedrooms</span>';
														}
														
														if ( !empty( $singleListing->BathroomTotal ) && $singleListing->BathroomTotal > 0 ){ 
															$html .='<span class="bathroom">'.$singleListing->BathroomTotal.' Bathrooms</span>';
														}
														
													$html .='</div>';
													
													if( isset( $Showcase_crea_listing_view_color_array_reults ) && !empty( $Showcase_crea_listing_view_color_array_reults ) ) { 
														$Showcase_crea_listing_view_color_text =  $Showcase_crea_listing_view_color_array_reults['listingShowcaseTextColor'];					
														if(!empty( $Showcase_crea_listing_view_color_text )  ) { 
															$Showcase_crea_listing_color_text = $Showcase_crea_listing_view_color_text;
														} else { 
															$Showcase_crea_listing_color_text = '000';
														}
													}
													
													if ( !empty( $singleListing->PublicRemarks ) ){ 
														$html .='<p style="color:#'.$crea_default_listing_text_color.'" >'.strip_tags(substr($singleListing->PublicRemarks,0,150)).'...</p>';
													}
													
												$html .='</div>';
											$html .='</div></a>';
												
												if( $singleListing->Price != '' ) { 
													if( $singleListing->Price == '0.00' ) { 
														$single_listing_prise = $singleListing->Lease;
													} else {
														$single_listing_prise = $singleListing->Price;
													} 
												
												$Showcase_crea_listing_color_price = 	$crea_default_listing_price_color;
												
													$html .='<div class="footer-info aret-col-9"><span style="color:#'.$Showcase_crea_listing_color_price.'">'.'$'.number_format($single_listing_prise).'</span>';
														$html .='<div class="menu" style="display: none;background-color:#'.$crea_default_listing_address_color.'">';
															$sharing_url = site_url('/listing-detail/'.$singleListing->ID.'/'.$listing_full_address_path);	
															$html .='<a class="social_facebook"  target="_blank" href="http://www.facebook.com/sharer.php?u='.$property_link_url.'/&amp;t='.$listing_full_address_path.'"></a>';
															$html .='<a class="social_tweet"  target="_blank" href="http://twitter.com/home?status='.$listing_full_address_path.'+'.$property_link_url.'"  ></a>';
															$html .='<a class="social_google" target="_blank" onclick="javascript:window.open(this.href, " ", "menubar=no,toolbar=no,resizable=yes,scrollbars=yes,height=600,width=600");return false;" href="https://plus.google.com/share?url='.$property_link_url.'/" ></a>'; 
															$html .='<a class="social_pinterest" target="_blank" href="http://pinterest.com/pin/create/button/?url='.$property_link_url.'/&media='.$singleListingImage.'=&description='.$listing_full_address_path.'" ></a>';
														$html .='</div>'; 
														$html .='<a  class="aret-icon share showmenu_listing"></a>';
													$html .='</div>'; 
												} else {
													$html .='<div class="footer-info aret-col-9"><span></span>';
														$html .='<div class="menu" style="display: none; background-color:#'.$crea_default_listing_address_color.'">';
															$sharing_url = site_url('/listing-detail/'.$singleListing->ID.'/'.$listing_full_address_path);	
															$html .='<a class="social_facebook" target="_blank" href="http://www.facebook.com/sharer.php?u='.$property_link_url.'/&amp;t='.$listing_full_address_path.'"></a>';
															$html .='<a class="social_tweet" target="_blank" href="http://twitter.com/home?status='.$listing_full_address_path.'+'.$property_link_url.'"  ></a>';
															$html .='<a class="social_google"  target="_blank" onclick="javascript:window.open(this.href, " ", "menubar=no,toolbar=no,resizable=yes,scrollbars=yes,height=600,width=600");return false;" href="https://plus.google.com/share?url='.$property_link_url.'/" ></a>';
															$html .='<a class="social_pinterest" target="_blank" href="http://pinterest.com/pin/create/button/?url='.$property_link_url.'/&media='.$singleListingImage.'&description='.$listing_full_address_path.'" ></a>';
														$html .='</div>';
														$html.='<a  class="aret-icon share showmenu_listing"></a>';
													$html .='</div>';
												}
												
										$html .='</div>';
									$html .='</div>';
								$html .='</li>';
							
						}
					 }
				} else { 
					$html .='<p> Sorry no properties found </p>';
				}
				 
			
			$html.='</ul>';	
					
			$crea_default_listing_pagiantion		= get_option('crea_default_listing_pagination_color_id_yes_or_not');
			$crea_default_listing_pagiantion_result 	= !empty($crea_default_listing_pagiantion)?$crea_default_listing_pagiantion : 'ab2567';
			
			$crea_default_listing_pagiantion_text_color		= get_option('crea_default_listing_pagination_text_color_id_yes_or_not');
			$crea_default_listing_pagiantion_text_color_result 	= !empty($crea_default_listing_pagiantion_text_color)?$crea_default_listing_pagiantion_text_color : 'ab2567'; ?>
			<style type="text/css">
			a.page_link {background: <?php echo "#".$crea_default_listing_pagiantion_result ?>;color:<?php echo "#".$crea_default_listing_pagiantion_text_color; ?>}
			.page_navigation a, .alt_page_navigation a{ background: <?php echo "#".$crea_default_listing_pagiantion_result ?>;color:<?php echo "#".$crea_default_listing_pagiantion_text_color; ?> }
			a.first_link.no_more{ background: <?php echo "#".$crea_default_listing_pagiantion_result ?>;color:<?php echo "#".$crea_default_listing_pagiantion_text_color; ?>}
			.active_page{background-color:<?php echo "#".$crea_default_listing_pagiantion_text_color?> !important;color:<?php echo "#".$crea_default_listing_pagiantion_result?> !important }
			
			.active_page{background-color:<?php echo "#".$crea_default_listing_pagiantion_text_color?> !important;color:<?php echo "#".$crea_default_listing_pagiantion_result?> !important  }
			span.page-numbers.current{background-color:<?php echo "#".$crea_default_listing_pagiantion_result?> !important;color:<?php echo "#".$crea_default_listing_pagiantion_text_color?> !important  }
			div.pagination a{background-color:<?php echo "#".$crea_default_listing_pagiantion_text_color?> !important;color:<?php echo "#".$crea_default_listing_pagiantion_result?> !important }
			
			div.pagination a{ background-color:#<?php echo $crea_default_listing_pagiantion_result; ?>!important;color:<?php  echo "#".$crea_default_listing_pagiantion_text_color; ?>!important}
			div.pagination a{ background-color:#<?php echo $crea_default_listing_pagiantion_result; ?>!important;color:<?php  echo "#".$crea_default_listing_pagiantion_text_color; ?>!important}
			div.pagination span.current{background-color:<?php echo "#".$crea_default_listing_pagiantion_text_color?> !important;color:<?php echo "#".$crea_default_listing_pagiantion_result?> !important }
			</style> 
			
			<?php
			if ( $allLisgngFinalArrCount > 0 ){ 
				$html .='<div class="pagination">';
					if ( !empty( $max_numbers_pagination ) ) {  
						$custom_pagination = Aretk_Crea_Public::custom_pagination(ceil( $max_numbers_pagination ),"",$page_number_id);
						$html.=$custom_pagination;
					}
				$html .='</div>';
			}
			
			$getSubscriptionListingFeed = get_option('crea_subscription_status', '');
			if ( !empty($userNameValues) && !empty( $userNameValues) && !empty($getSubscriptionListingFeed) && $getSubscriptionListingFeed === 'valid' && $allLisgngFinalArrCount > 0 ){ 
				$html .='<div class="custom_listing_content_subscription_active"><p>MLS&reg;, REALTOR&reg;, and the associated logos are trademarks of The Canadian Real Estate Association.</p></div>';
			}
			
			//Terms of use
			/*if( empty( $_COOKIE["aretk_crea_terms_of_use"] ) && !empty($userNameValues) && isset( $getSubscriptionListingFeed ) && !empty( $getSubscriptionListingFeed) && $getSubscriptionListingFeed === 'valid' ) {
				$html.='<div id="aretk_crea_disclaimer_container" style="position:absolute; left: 0; right: 0; margin:auto; top:15%; z-index:1001;"><div style="margin:auto; width:75%;"><h2 style="color:white; font-size: 24px; font-family: arial; margin-bottom: 20px;">Terms & Conditions Agreement</h2><p style="color:white; font-size: 14px; line-height: 22px; margin-bottom: 20px !important;">The listing content on this website is protected by copyright and other laws, and is intended solely for the private, non-commercial use by individuals. Any other reproduction, distribution or use of the content, in whole or in part, is specifically forbidden. The prohibited uses include commercial use, "screen scraping", "database scraping", and any other activity intended to collect, store, reorganize or manipulate data on the pages produced by or displayed on this website.</p>
						<p style="color:white; font-size: 14px; line-height: 22px; margin-bottom: 20px !important;">REALTOR&reg;, REALTORS&reg;, and the REALTOR&reg; logo are certification marks that are owned by REALTOR&reg; Canada Inc. and licensed exclusively to The Canadian Real Estate Association (CREA). These certification marks identify real estate professionals who are members of CREA and who must abide by CREA\'s By-Laws, Rules, and the REALTOR&reg; Code. The MLS&reg; trademark and the MLS&reg; logo are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA.</p>
						<p style="color:white; font-size: 14px; line-height: 22px; margin-bottom: 20px !important;">The information contained on this site is based in whole or in part on information that is provided by members of The Canadian Real Estate Association, who are responsible for its accuracy. CREA reproduces and distributes this information as a service for its members and assumes no responsibility for its accuracy.</p><div>
						<input type="button" value="Accept" id="aretk_crea_disclaimer_accept"><input type="button" value="Decline" id="aretk_crea_disclaimer_decline"></div></div></div>
						<div id="aretk_crea_disclaimer_background" style="position:fixed; top:0; bottom:0; width:100%; left: 0; right: 0; z-index:1000; background:black; opacity:0.9"></div>';
			}*/

			
		$html.='</div>';	
		$html.='</div>';	
		
	
	//End listing Html
	
} else {

	/*slected showcase results*/
	if ( isset($showcaseSCID) && !empty($showcaseSCID) ) {
		$showcse_crea_filter_brokerage = maybe_unserialize(get_post_meta($showcaseSCID,'showcse_crea_filter_brokerage',true));
		$showcse_crea_filter_brokerage = !empty( $showcse_crea_filter_brokerage ) ? $showcse_crea_filter_brokerage :'';
		$showcse_crea_display_theams_option = maybe_unserialize(get_post_meta($showcaseSCID,'showcse_crea_display_theams_option',true));
		$showcse_crea_display_theams_option= !empty( $showcse_crea_display_theams_option ) ? $showcse_crea_display_theams_option:'';
		$showcse_crea_feed_include_exclude = maybe_unserialize(get_post_meta($showcaseSCID,'showcse_crea_feed_include_exclude',true));
		$showcse_crea_feed_include_exclude = !empty( $showcse_crea_feed_include_exclude ) ? $showcse_crea_feed_include_exclude :'';
		$showcse_crea_feed_ddf_type = maybe_unserialize(get_post_meta($showcaseSCID,'showcse_crea_feed_ddf_type',true));
		$showcse_crea_feed_ddf_type = !empty( $showcse_crea_feed_ddf_type ) ? $showcse_crea_feed_ddf_type :'';
		$showcse_crea_filter_office = maybe_unserialize(get_post_meta($showcaseSCID,'showcse_crea_filter_office',true));
		$showcse_crea_filter_agent_name = maybe_unserialize(get_post_meta($showcaseSCID,'showcse_crea_filter_agent_name',true));
		$showcse_crea_filter_inclue_open_house = maybe_unserialize(get_post_meta($showcaseSCID,'showcse_crea_filter_inclue_open_house',true));
		$showcse_crea_filter_by_other_day = maybe_unserialize(get_post_meta($showcaseSCID,'showcse_crea_filter_by_other_day',true));
		$showcse_crea_filter_by_map_km = maybe_unserialize(get_post_meta($showcaseSCID,'showcse_crea_filter_by_map_km',true));
		$showcse_crea_filter_listing = maybe_unserialize(get_post_meta($showcaseSCID,'showcse_crea_filter_listing',true));
		$showcse_crea_serializable_listing_array = maybe_unserialize(get_post_meta($showcaseSCID,'showcse_crea_serializable_listing_array',true));
		$showcse_crea_serializable_grid_array = maybe_unserialize(get_post_meta($showcaseSCID,'showcse_crea_serializable_grid_array',true));
		$showcse_crea_serializable_carousel_array = maybe_unserialize(get_post_meta($showcaseSCID,'showcse_crea_serializable_carousel_array',true));
		$showcse_crea_serializable_map_array = maybe_unserialize(get_post_meta($showcaseSCID,'showcse_crea_serializable_map_array',true));
		$showcse_crea_serializable_slider_array = maybe_unserialize(get_post_meta($showcaseSCID,'showcse_crea_serializable_slider_array',true));
		$Showcase_crea_grid_view_color_array_results = maybe_unserialize( get_post_meta($showcaseSCID,'Showcase_crea_grid_view_color_array',true));
		$Showcase_crea_listing_view_color_array_reults = maybe_unserialize( get_post_meta($showcaseSCID,'Showcase_crea_listing_view_color_array',true));
		$Showcase_crea_slider_view_color_array_reults = maybe_unserialize( get_post_meta($showcaseSCID,'Showcase_crea_slider_view_color_array',true));
		$Showcase_crea_map_view_color_array_results = maybe_unserialize( get_post_meta($showcaseSCID,'Showcase_crea_map_view_color_array',true));
		$Showcase_crea_carousel_view_color_array_reults = maybe_unserialize( get_post_meta($showcaseSCID,'Showcase_crea_carousel_view_color_array',true));
		
		$showcse_crea_serializable_listing_array = get_post_meta($showcaseSCID,'showcse_crea_serializable_listing_array',true);
		if(isset( $showcse_crea_serializable_listing_array ) && !empty( $showcse_crea_serializable_listing_array)) { 
			$showcse_crea_serializable_listing_array = maybe_unserialize($showcse_crea_serializable_listing_array);
			$showcse_crea_serializable_maxlistingonpage  = !empty($showcse_crea_serializable_listing_array['maxlistingonpage'] ) ? $showcse_crea_serializable_listing_array['maxlistingonpage'] : '';
			if(isset( $showcse_crea_serializable_maxlistingonpage ) && !empty($showcse_crea_serializable_maxlistingonpage )) {
				$showcse_crea_serializable_maxlistingonpage_results   = $showcse_crea_serializable_maxlistingonpage;
			} else { 
				$showcse_crea_serializable_maxlistingonpage_results   = "20";
			}
		} else {
			$showcse_crea_serializable_maxlistingonpage_results   = "20";
		}
			
		$showcse_crea_serializable_map_array = maybe_unserialize($showcse_crea_serializable_map_array);
		$mapfilterlatitude =  !empty( $showcse_crea_serializable_map_array['mapfilterlatitude'] ) ? $showcse_crea_serializable_map_array['mapfilterlatitude'] : '56.1304';
		$mapfilterlongitude =  !empty( $showcse_crea_serializable_map_array['mapfilterlongitude'] ) ? $showcse_crea_serializable_map_array['mapfilterlongitude'] : '-106.3468';
		$showcasemapimagezoom =  !empty( $showcse_crea_serializable_map_array['showcasemapimagezoom'] ) ? $showcse_crea_serializable_map_array['showcasemapimagezoom'] : '6';
	} 
	
	if( $showcse_crea_display_theams_option == 'Listing View' ) {
		//Start showcase listing view html
		$html ='';
		if ( !empty($allListingFinalArr) && isset($allListingFinalArr) && $allLisgngFinalArrCount > 0 ) {
			
			$html.='<input type="hidden" id="advance_search_total_listing_records_count" value="'.$total_listing_records.'">';
			$html.='<div class="aretk-wrap">';
			$html.='<ul class="content">';
				
					foreach ( $allListingFinalArr as $singleListing ) { 
						if ( isset( $singleListing->post_author ) && !empty( $singleListing->post_author ) ) { 
							$content_post = get_post($singleListing->ID);
							
							if (!empty($content_post) && $content_post != '') {
								$listing_post_content = $content_post->post_content;
							}
							
							$ListingAddress = get_post_meta($singleListing->ID,'listingAddress',true);
							$ListingCity = get_post_meta($singleListing->ID,'listingcity',true);
							$listingProvince = get_post_meta($singleListing->ID,'listingProvince',true);
							$ListingPrice = get_post_meta($singleListing->ID,'listingPrice',true);
							
							$ListingBedRooms = get_post_meta($singleListing->ID, 'listingBedRooms', true);
							$ListingBedRooms = !empty($ListingBedRooms) ? $ListingBedRooms : '';
							
							$ListingBathrooms = get_post_meta($singleListing->ID, 'listingBathrooms', true);
							$ListingBathrooms = !empty($ListingBathrooms) ? $ListingBathrooms : '';
							
							
							$listingAgentStatus = get_post_meta($singleListing->ID, 'listingAgentStatus', true);
							$listingAgentStatus = !empty($listingAgentStatus) ? $listingAgentStatus : '';
							
							$listingopenhosedatetimeArr = get_post_meta($singleListing->ID, 'listingopenhosedatetimeArr', true);
							$listingopenhosedatetimeArr = json_decode($listingopenhosedatetimeArr);
							$listingopenhosedatetimeArr = !empty($listingopenhosedatetimeArr) ? $listingopenhosedatetimeArr : '';
							
							$date = date('d-m-Y',strtotime($singleListing->post_date));
							
							$crea_listing_images_detail_table_name = $wpdb->prefix . CREA_LISTING_IMAGES_HISTORY;
							$querySelectFirstImage = "SELECT image_url FROM $crea_listing_images_detail_table_name WHERE image_position =1 AND unique_id = $singleListing->ID";
							
							$resultSet = $wpdb->get_results($querySelectFirstImage);
							if (isset($resultSet) && !empty($resultSet)) {
								$path = $resultSet[0]->image_url;
							} else {
								$path = $site_image_path;
							}
							
							$listing_full_address_path = '';
							if ( !empty( $ListingAddress )  ) {
								$singleListingStreetAddress = trim($ListingAddress);
								$singleListingStreetAddress = str_replace(' ', '-', $singleListingStreetAddress);
								$singleListingStreetAddress = str_replace('#', '', $singleListingStreetAddress);
								$singleListingStreetAddress = str_replace('--','-',$singleListingStreetAddress);
								$singleListingStreetAddress = str_replace('---','-',$singleListingStreetAddress);
								$listing_full_address_path.= $singleListingStreetAddress;
							}
							
							if ( !empty( $ListingCity ) ) {
								$singleListingStreetCity = trim($ListingCity);
								$singleListingStreetCity = str_replace(' ', '-', $singleListingStreetCity);
								$singleListingStreetCity = str_replace('#', '', $singleListingStreetCity);
								$singleListingStreetCity = str_replace('--','-',$singleListingStreetCity);
								$singleListingStreetCity = str_replace('---','-',$singleListingStreetCity);
								$listing_full_address_path.='-'.trim($singleListingStreetCity);
							}
							
							if ( !empty( $listingProvince ) ) {
								$singleListingStreetProvince = trim($listingProvince);
								$singleListingStreetProvince = str_replace(' ', '-', $singleListingStreetProvince);
								$singleListingStreetProvince = str_replace('#', '', $singleListingStreetProvince);
								$singleListingStreetProvince = str_replace('--','-',$singleListingStreetProvince);
								$singleListingStreetProvince = str_replace('---','-',$singleListingStreetProvince);
								$listing_full_address_path.='-'.trim($singleListingStreetProvince);
							}
							
							$property_address = $ListingAddress;
							
							if( isset( $listing_full_address_path ) && !empty( $listing_full_address_path ) && $listing_full_address_path != " " ) {
								//$html .='<tr>';
									$html .='<li>';
										$html .='<div class="prop-listing default pr ">'; 
											$html .='<div class="aret-row">';
												$html .='<div class="aret-col-3 pr">';
													$Showcase_crea_listing_color_status ='';
													if( isset( $Showcase_crea_listing_view_color_array_reults ) && !empty( $Showcase_crea_listing_view_color_array_reults ) ) { 
														$Showcase_crea_listing_view_color_status =  $Showcase_crea_listing_view_color_array_reults['listingShowcaseStatusColor'];					
														if(!empty( $Showcase_crea_listing_view_color_status )  ) { 
															$Showcase_crea_listing_color_status = $Showcase_crea_listing_view_color_status;
														} else { 
															$Showcase_crea_listing_color_status = 'FF38A1';
														}
													}
													
													if ( !empty( $listingopenhosedatetimeArr[0]->date ) ) { 
														$html .= '<p class="listing_openhouse" style="background: #'.$Showcase_crea_listing_color_status.'">open house</p>';
													}
													
														
													$html .='<a class="property_link" href="'.home_url().'/listing-detail/'.$singleListing->ID.'/'.$listing_full_address_path.'"><img src="'.$path.'" class="imag_listing" alt="'.str_replace('-', ' ', $listing_full_address_path).'"></a>';
												$html .='</div>';
												$html .='<div class="aret-col-9 no-mar-right">';
													$html .='<a class="property_link" href="'.home_url().'/listing-detail/'.$singleListing->ID.'/'.$listing_full_address_path.'"><div class="info-box">';
														if( isset( $Showcase_crea_listing_view_color_array_reults ) && !empty( $Showcase_crea_listing_view_color_array_reults ) ) { 
															$Showcase_crea_listing_view_color_title =  $Showcase_crea_listing_view_color_array_reults['listingShowcaseAddressBarColor'];					
															if(!empty( $Showcase_crea_listing_view_color_title )  ) { 
																$Showcase_crea_listing_color_title = $Showcase_crea_listing_view_color_title;
															} else { 
																$Showcase_crea_listing_color_title = '000';
															}
														}
														
														$html .='<h4 style="color:#'.$Showcase_crea_listing_color_title.'">'.$listing_full_address_path.'</h4>';
														$html .='<div class="info-bar">';
															if ( !empty( $ListingBedRooms ) ) { 
																$html .='<span class="bad">'.$ListingBedRooms.' Bedrooms</span>';
															}
															
															if ( !empty( $ListingBathrooms ) ) { 
																$html .='<span class="bathroom">'.$ListingBathrooms.' Bathrooms</span>';
															}
														$html .='</div>';
														
														if( isset( $Showcase_crea_listing_view_color_array_reults ) && !empty( $Showcase_crea_listing_view_color_array_reults ) ) { 
															$Showcase_crea_listing_view_color_text =  $Showcase_crea_listing_view_color_array_reults['listingShowcaseTextColor'];					
															if(!empty( $Showcase_crea_listing_view_color_text )  ) { 
																$Showcase_crea_listing_color_text = $Showcase_crea_listing_view_color_text;
															} else { 
																$Showcase_crea_listing_color_text = '000';
															}
														}
														
														if( $listing_post_content == ''){  
															$html .='<p style =color:#'.$Showcase_crea_listing_color_text.'>No Property description.</p>';	
														} else { 
															
															$html .='<p style =color:#'.$Showcase_crea_listing_color_text.'>'.strip_tags(substr($listing_post_content,0,150)).'...</p>';								
														}
													$html .='</div></a>';
												$html .='</div>';
												
												if( $ListingPrice != '' && $ListingPrice != 0 ) {  
													if( isset( $Showcase_crea_listing_view_color_array_reults ) && !empty( $Showcase_crea_listing_view_color_array_reults ) ) { 
														$Showcase_crea_listing_view_color_prise =  $Showcase_crea_listing_view_color_array_reults['listingShowcasePriceColor'];					
														if(!empty( $Showcase_crea_listing_view_color_prise )  ) { 
															$Showcase_crea_listing_color_price = $Showcase_crea_listing_view_color_prise;
														} else { 
															$Showcase_crea_listing_color_price = '000';
														}
													}
													$ListingPrice_results =  $ListingPrice;
													
													
												}
												$html .='<div class="footer-info aret-col-9"><span style = "color:#'.$Showcase_crea_listing_color_price.'">'.'$'.number_format($ListingPrice_results).'</span> ';
													$html .='<div class="menu" style="display: none;  background-color:#'.$Showcase_crea_listing_color_title.'">';
														$sharing_url = site_url('/listing-detail/'.$singleListing->ID.'/'.$listing_full_address_path);	
														$html .='<a class="social_facebook" target="_blank" href="http://www.facebook.com/sharer.php?u='.$sharing_url.'/&amp;t='.$listing_full_address_path.'"></a>';
														$html .='<a class="social_tweet" target="_blank" href="http://twitter.com/home?status='.$listing_full_address_path.'+'.$sharing_url.'"  ></a>';
														$html .='<a class="social_google"  target="_blank" onclick="javascript:window.open(this.href, " ", "menubar=no,toolbar=no,resizable=yes,scrollbars=yes,height=600,width=600");return false;" href="https://plus.google.com/share?url='.$sharing_url.'/" ></a>'; 
														$html .='<a class="social_pinterest" target="_blank" href="http://pinterest.com/pin/create/button/?url='.$sharing_url.'/&media='.$path.'&description='.$listing_full_address_path.'" ></a>';
													$html .='</div>';
													$html.='<a  class="aret-icon share showmenu_listing"></a>';
												$html .='</div>';
											$html .='</div>';
										$html .='</div>';
									$html .='</li>';
								//$html .='</tr>';
							}
						
						} else {  
							
							if( !isset( $singleListing->RecordsReturned )) {										
								
								$listing_full_address_path = '';
								
								if ( !empty($singleListing->StreetAddress) && !empty( $singleListing->City ) && !empty( $singleListing->Province ) ) { 
										if ( !empty( $singleListing->StreetAddress )  ) {
										$singleListingStreetAddress = trim($singleListing->StreetAddress);
										$singleListingStreetAddress = str_replace(' ', '-', $singleListingStreetAddress);
										$singleListingStreetAddress = str_replace('#','',$singleListingStreetAddress);
										$singleListingStreetAddress = str_replace('--','-',$singleListingStreetAddress);
										$singleListingStreetAddress = str_replace('---','-',$singleListingStreetAddress);
										$listing_full_address_path.= $singleListingStreetAddress;
									}
									
									if ( !empty( $singleListing->City ) ) {
										$singleListingStreetCity = trim($singleListing->City);
										$singleListingStreetCity = str_replace(' ', '-', $singleListingStreetCity);
										$singleListingStreetCity = str_replace('#','',$singleListingStreetCity);
										$singleListingStreetCity = str_replace('--','-',$singleListingStreetCity);
										$singleListingStreetCity = str_replace('---','-',$singleListingStreetCity);
										$listing_full_address_path.='-'.trim($singleListingStreetCity);
									}
									
									if ( !empty( $singleListing->Province ) ) {
										$singleListingStreetProvince = trim($singleListing->Province);
										$singleListingStreetProvince = str_replace(' ', '-', $singleListingStreetProvince);
										$singleListingStreetProvince = str_replace('#','',$singleListingStreetProvince);
										$singleListingStreetProvince = str_replace('--','-',$singleListingStreetProvince);
										$singleListingStreetProvince = str_replace('---','-',$singleListingStreetProvince);
										$listing_full_address_path.='-'.trim($singleListingStreetProvince);
									}
								} else { 
									if ( !empty( $singleListing->generated_address ) ) { 
										$singleListinggeneratedAddress = trim($singleListing->generated_address);
										$singleListinggeneratedAddress = str_replace(' ', '-', $singleListinggeneratedAddress);
										$singleListinggeneratedAddress = str_replace('#','',$singleListinggeneratedAddress);
										$singleListinggeneratedAddress = str_replace('--','-',$singleListinggeneratedAddress);
										$singleListinggeneratedAddress = str_replace('---','-',$singleListinggeneratedAddress);
										$listing_full_address_path.= $singleListinggeneratedAddress;
									}
								}
								
								$listing_openHouses = $singleListing->listing_openHouses;
								$listingSizeInterior = $singleListing->SizeInterior;
								$listingSizeInterior = !empty($listingSizeInterior) ? $listingSizeInterior : '';
								
								if ( $singleListing->listing_photos != null ) { 
									if ( isset( $singleListing->listing_photos) && !empty( $singleListing->listing_photos ) ) {
										if( !empty( $singleListing->listing_photos )) {  
											$domain_name = $_SERVER['SERVER_NAME'];
											$singleListingimag_array  = explode('/',$singleListing->listing_photos[0]->URL);
											if( !empty($singleListingimag_array )){ 
												$single_listing_carousel = $singleListingimag_array[2];
												if( $domain_name == $single_listing_carousel ){ 
													list($width, $height, $type, $attr) = getimagesize($singleListing->listing_photos->URL);
														if( !empty( $width ) &&  $width !='0') { 
															$singleListingImage = $singleListing->listing_photos->URL;
														} else { 
															$singleListingImage = $site_image_path;
														}
												} else if( $domain_name != $single_listing_carousel && $single_listing_carousel !='static.aretk.com' ) { 
													$singleListingImage = $site_image_path;
												} else { 
													$singleListingImage = $singleListing->listing_photos[0]->URL;
												}
											}
											
										}
										
									} else { 
										
										$domain_name = $_SERVER['SERVER_NAME'];
										$singleListingimag_array  = explode('/',$singleListing->listing_photos[0]->URL);
										if( !empty($singleListingimag_array )){ 
											$single_listing_carousel = $singleListingimag_array[2];
											if( $domain_name == $single_listing_carousel ){ 
												list($width, $height, $type, $attr) = getimagesize($singleListing->listing_photos->URL);
													if( !empty( $width ) &&  $width !='0') { 
														$singleListingImage = $singleListing->listing_photos->URL;
													} else { 
														$singleListingImage = $site_image_path;
													}
											} else if( $domain_name != $single_listing_carousel && $single_listing_carousel !='static.aretk.com' ) { 
												$singleListingImage = $site_image_path;
											} else { 
												$singleListingImage = $singleListing->listing_photos[0]->URL;
											}
										}
										
										/*$singleListingImage = $singleListing->listing_photos[0]->URL;*/
									}
								} else { 
									
									$singleListingImage = $site_image_path;
								}
														
								//$html .='<tr>';
									$html .='<li>';
										$html .='<div class="prop-listing default pr">'; 
											$html .='<div class="aret-row">';
												$html .='<div class="aret-col-3 pr">';
													if( isset( $Showcase_crea_listing_view_color_array_reults ) && !empty( $Showcase_crea_listing_view_color_array_reults ) ) { 
														$Showcase_crea_listing_view_color_status =  $Showcase_crea_listing_view_color_array_reults['listingShowcaseStatusColor'];					
														if(!empty( $Showcase_crea_listing_view_color_status )  ) { 
															$Showcase_crea_listing_color_status = $Showcase_crea_listing_view_color_status;
														} else { 
															$Showcase_crea_listing_color_status = '000';
														}
														
														if(!empty( $Showcase_crea_listing_view_color_status_text )  ) { 
															$Showcase_crea_listing_view_color_status_text = $Showcase_crea_listing_view_color_status_text;
														} else { 
															$Showcase_crea_listing_view_color_status_text = '000';
														}
													}
													
													$is_open_house = !empty( $singleListing->listing_openHouses ) ? $singleListing->listing_openHouses : '';
													if ( $is_open_house != null ){ 
														$html .= '<p class="listing_openhouse" style="background:#'.$Showcase_crea_listing_color_status.' ">open house</p>';
													}
													
													if(isset( $showcse_crea_serializable_listing_array ) && !empty( $showcse_crea_serializable_listing_array ) ) {
														$showcse_crea_serializable_listing_array_listingstatus_or_not = $showcse_crea_serializable_listing_array['listingstatus'];
														if(isset( $showcse_crea_serializable_listing_array_listingstatus_or_not ) && !empty( $showcse_crea_serializable_listing_array_listingstatus_or_not ) && $showcse_crea_serializable_listing_array_listingstatus_or_not === 'yes'){
															$html.='<p class="listing_status listing_statusdefault_listing" style="color:#'.$Showcase_crea_listing_view_color_status_text.';background:#'.$Showcase_crea_listing_color_status.'">'.$singleListing->TransactionType.'</p>';		
														}
													}
													
												$is_exclusive_list = '';
												$property_link_url = '';	
												if ( !empty( $singleListing->mlsID ) && $singleListing->mlsID == 'Exclusive'){ 
													$is_exclusive_list = '/exclusive';
													$property_link_url = site_url().'/listing-detail/'.$singleListing->ID.$is_exclusive_list.'/'.$listing_full_address_path;
												} else { 
													$property_link_url = site_url().'/listing-detail/'.$singleListing->ID.'/'.$listing_full_address_path;
												}
												
												$html .='<a class="property_link" href="'.$property_link_url.'"><img src="'.$singleListingImage.'"  class="imag_listing" alt="'.str_replace('-', ' ', $listing_full_address_path).'"></a>';
												$html .='</div>';
												$html .='<div class="aret-col-9 no-mar-right">';
												
												
													$html .='<a href="'.$property_link_url.'"><div class="info-box">';
														if( isset( $Showcase_crea_listing_view_color_array_reults ) && !empty( $Showcase_crea_listing_view_color_array_reults ) ) { 
															$Showcase_crea_listing_view_color_title =  $Showcase_crea_listing_view_color_array_reults['listingShowcaseAddressBarColor'];					
															if(!empty( $Showcase_crea_listing_view_color_title )  ) { 
																$Showcase_crea_listing_color_title = $Showcase_crea_listing_view_color_title;
															} else { 
																$Showcase_crea_listing_color_title = '000';
															}
														}
														
														if(isset( $singleListing->mlsID ) && !empty( $singleListing->mlsID )) {
															$html.='<h4 style="color:#'.$Showcase_crea_listing_color_title.'" class="default_listing_mlsID" >MLS&reg#'.$singleListing->mlsID.'</h4>';
														}
														if ( !empty( $singleListing->StreetAddress ) ) { 
															$html .='<h4  style="color:#'.$Showcase_crea_listing_color_title.'">'.$singleListing->StreetAddress.'</h4>';
														} else { 
															$html .='<h4  style="color:#'.$Showcase_crea_listing_color_title.'">'.$singleListing->generated_address.'</h4>';
														}
														
														$html .='<div class="info-bar">';
															if ( !empty( $singleListing->BedroomsTotal ) && $singleListing->BedroomsTotal > 0 ){ 
																$html .='<span class="bad">'.$singleListing->BedroomsTotal.' Bedroom</span>';
															}else { 
																$html .='<span class="bad">0 Bed</span>';
															}
															
															if ( !empty( $singleListing->BathroomTotal ) && $singleListing->BathroomTotal > 0 ){ 
																$html .='<span class="bathroom">'.$singleListing->BathroomTotal.' Bathroom	</span>';
															} else{ 
																$html .='<span class="bathroom">0 Bathroom</span>';
															} 
															
														$html .='</div>';
														
														if( isset( $Showcase_crea_listing_view_color_array_reults ) && !empty( $Showcase_crea_listing_view_color_array_reults ) ) { 
															$Showcase_crea_listing_view_color_text =  $Showcase_crea_listing_view_color_array_reults['listingShowcaseTextColor'];					
															if(!empty( $Showcase_crea_listing_view_color_text )  ) { 
																$Showcase_crea_listing_color_text = $Showcase_crea_listing_view_color_text;
															} else { 
																$Showcase_crea_listing_color_text = '000';
															}
														}
														
														if ( !empty( $singleListing->PublicRemarks ) ){ 
															$html .='<p style="color:#'.$Showcase_crea_listing_color_text.'" >'.strip_tags(substr($singleListing->PublicRemarks,0,150)).'...</p>';
														}
													$html .='</div></a>';
												$html .='</div>';
												if( $singleListing->Price != '' ) { 
													if( isset( $Showcase_crea_listing_view_color_array_reults ) && !empty( $Showcase_crea_listing_view_color_array_reults ) ) { 
														$Showcase_crea_listing_view_color_prise =  $Showcase_crea_listing_view_color_array_reults['listingShowcasePriceColor'];					
														if(!empty( $Showcase_crea_listing_view_color_prise )  ) { 
															$Showcase_crea_listing_color_price = $Showcase_crea_listing_view_color_prise;
														} else { 
															$Showcase_crea_listing_color_price = '000';
														}
													}
													
													if( $singleListing->Price == '0.00' ) { 
														$single_listing_prise = $singleListing->Lease;
														} else {
														$single_listing_prise = $singleListing->Price;
													}
													
												 
													$html .='<div class="footer-info aret-col-9"><span style="color:#'.$Showcase_crea_listing_color_price.'">'.'$'.number_format($single_listing_prise).'</span>';
														$html .='<div class="menu" style="display: none;background-color:#'.$Showcase_crea_listing_color_title.'">';
															$sharing_url = site_url('/listing-detail/'.$singleListing->ID.'/'.$listing_full_address_path);	
															$html .='<a class="social_facebook" target="_blank" href="http://www.facebook.com/sharer.php?u='.$property_link_url.'/&amp;t='.$listing_full_address_path.'"></a>';
															$html .='<a class="social_tweet" target="_blank" href="http://twitter.com/home?status='.$listing_full_address_path.'+'.$property_link_url.'"  ></a>';
															$html .='<a class="social_google"  target="_blank" onclick="javascript:window.open(this.href, " ", "menubar=no,toolbar=no,resizable=yes,scrollbars=yes,height=600,width=600");return false;" href="https://plus.google.com/share?url='.$property_link_url.'/" ></a>'; 
															$html .='<a class="social_pinterest" target="_blank" href="http://pinterest.com/pin/create/button/?url='.$property_link_url.'/&media='.$site_image_path.'&description='.$listing_full_address_path.'" ></a>';
														$html .='</div>'; 
														$html .='<a  class="aret-icon share showmenu_listing"></a>';
													$html .='</div>'; 
												} else {
													$html .='<div class="footer-info aret-col-9"><span></span>';
														$html .='<div class="menu" style="display: none; background-color:#'.$Showcase_crea_listing_color_title.'">';
															$sharing_url = site_url('/listing-detail/'.$singleListing->ID.'/'.$listing_full_address_path);	
															$html .='<a class="social_facebook" target="_blank" href="http://www.facebook.com/sharer.php?u='.$property_link_url.'/&amp;t='.$listing_full_address_path.'"></a>';
															$html .='<a class="social_tweet" target="_blank"  href="http://twitter.com/home?status='.$listing_full_address_path.'+'.$property_link_url.'"  ></a>';
															$html .='<a class="social_google" target="_blank" onclick="javascript:window.open(this.href, " ", "menubar=no,toolbar=no,resizable=yes,scrollbars=yes,height=600,width=600");return false;" href="https://plus.google.com/share?url='.$property_link_url.'/" ></a>';
															$html .='<a class="social_pinterest" target="_blank" href="http://pinterest.com/pin/create/button/?url='.$property_link_url.'/&media='.$site_image_path.'&description='.$listing_full_address_path.'" ></a>';
														$html .='</div>';
														$html.='<a  class="aret-icon share showmenu_listing"></a>';
													$html .='</div>';
												}
											$html .='</div>';
										$html .='</div>';
									$html .='</li>';
							}
						}
					}
				 
		$html.='</ul>';
		$html.='</div>';
		$Showcase_crea_listing_view_color_pagination_color = "DB5C04";		
		$Showcase_crea_listing_view_color_pagination_text_color = "000000";	
						
		if(isset( $Showcase_crea_listing_view_color_array_reults ) && !empty( $Showcase_crea_listing_view_color_array_reults ) ){ 
			$Showcase_crea_listing_view_color_pagination_results = $Showcase_crea_listing_view_color_array_reults['listingShowcasepaginationColor'];
			$Showcase_crea_listing_view_color_text_pagination_results = $Showcase_crea_listing_view_color_array_reults['listingShowcasepaginationtextColor'];
			if( !empty( $Showcase_crea_listing_view_color_pagination_results ) ){ 
				$Showcase_crea_listing_view_color_pagination_color = $Showcase_crea_listing_view_color_pagination_results;
			}
			if( !empty( $Showcase_crea_listing_view_color_text_pagination_results ) ){ 
				$Showcase_crea_listing_view_color_pagination_text_color = $Showcase_crea_listing_view_color_text_pagination_results;
			}
		}
			
		?>
		
	<style  type="text/css">
	div.pagination a{ background-color:#<?php echo $Showcase_crea_listing_view_color_pagination_color; ?>!important;color:<?php  echo "#".$Showcase_crea_listing_view_color_pagination_text_color; ?>!important}
	div.pagination a{ background-color:#<?php echo $Showcase_crea_listing_view_color_pagination_color; ?>!important;color:<?php  echo "#".$Showcase_crea_listing_view_color_pagination_text_color; ?>!important}
	div.pagination span.current{background-color:<?php echo "#".$Showcase_crea_listing_view_color_pagination_text_color?> !important;color:<?php echo "#".$Showcase_crea_listing_view_color_pagination_color?> !important }
	</style>
		
		<?php 
		if ($allLisgngFinalArrCount > 0 ){ 
			//$html.='<div class="page_navigation"></div>';
			$html .='<div id="advance_search_listing_pagination" class="pagination">';
				if ( !empty( $max_numbers_pagination ) ) {  
					$custom_pagination = Aretk_Crea_Public::custom_pagination( ceil ( $max_numbers_pagination ) ,"",$page_number_id);
					$html.=$custom_pagination;
				}
			$html .='</div>';
		}
		
		if ( !empty($showcse_crea_feed_ddf_type) && !empty( $showcse_crea_feed_ddf_type) && !empty($getSubscriptionListingFeed) && $getSubscriptionListingFeed === 'valid' && $allLisgngFinalArrCount > 0){ 
			$html .='<div class="custom_listing_content_subscription_active"><p>MLS&reg;, REALTOR&reg;, and the associated logos are trademarks of The Canadian Real Estate Association.</p></div>';
		}
		
		//Terms of use
		/*if( empty( $_COOKIE["aretk_crea_terms_of_use"] ) && !empty($showcse_crea_feed_ddf_type) && isset( $getSubscriptionListingFeed ) && !empty( $getSubscriptionListingFeed) && $getSubscriptionListingFeed === 'valid' ) {
			$html.='<div id="aretk_crea_disclaimer_container" style="position:absolute; left: 0; right: 0; margin:auto; top:15%; z-index:1001;"><div style="margin:auto; width:75%;"><h2 style="color:white; font-size: 24px; font-family: arial; margin-bottom: 20px;">Terms & Conditions Agreement</h2><p style="color:white; font-size: 14px; line-height: 22px; margin-bottom: 20px !important;">The listing content on this website is protected by copyright and other laws, and is intended solely for the private, non-commercial use by individuals. Any other reproduction, distribution or use of the content, in whole or in part, is specifically forbidden. The prohibited uses include commercial use, "screen scraping", "database scraping", and any other activity intended to collect, store, reorganize or manipulate data on the pages produced by or displayed on this website.</p>
			<p style="color:white; font-size: 14px; line-height: 22px; margin-bottom: 20px !important;">REALTOR&reg;, REALTORS&reg;, and the REALTOR&reg; logo are certification marks that are owned by REALTOR&reg; Canada Inc. and licensed exclusively to The Canadian Real Estate Association (CREA). These certification marks identify real estate professionals who are members of CREA and who must abide by CREA\'s By-Laws, Rules, and the REALTOR&reg; Code. The MLS&reg; trademark and the MLS&reg; logo are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA.</p>
			<p style="color:white; font-size: 14px; line-height: 22px; margin-bottom: 20px !important;">The information contained on this site is based in whole or in part on information that is provided by members of The Canadian Real Estate Association, who are responsible for its accuracy. CREA reproduces and distributes this information as a service for its members and assumes no responsibility for its accuracy.</p><div>
			<input type="button" value="Accept" id="aretk_crea_disclaimer_accept"><input type="button" value="Decline" id="aretk_crea_disclaimer_decline"></div></div></div>
			<div id="aretk_crea_disclaimer_background" style="position:fixed; top:0; bottom:0; width:100%; left: 0; right: 0; z-index:1000; background:black; opacity:0.9"></div>';
		}*/
		
		} else { 
			$html.='<p>Sorry no properties found</p>';
		}
			
		
	}
	
	if( $showcse_crea_display_theams_option == 'Grid View' ) { 
	if( isset( $allLisgngFinalArrCount ) && !empty( $allLisgngFinalArrCount ) && $allLisgngFinalArrCount > 0 ) {	
	//Start Grid View Html
		$html = '';
		$showcase_crea_display_grid_array = $showcse_crea_serializable_grid_array;
		if( isset( $showcase_crea_display_grid_array ) && !empty( $showcase_crea_display_grid_array )) { 
			$showcase_crea_display_maxselected_column	= $showcase_crea_display_grid_array['maxgridviewselectedcolumn'];	
			$showcase_crea_display_maxselected_row 	= $showcase_crea_display_grid_array['maxgridviewselectedrow'];	
			if( $showcase_crea_display_maxselected_column == '2' ) { 
				$grid_view_listing_class = 'grid-view-box pr aret-col-6';
			} else { 
				$grid_view_listing_class = 'aret-col-3 grid-view-box pr';
			}
			
			switch ($showcase_crea_display_maxselected_column) {
				case "1":
					$grid_view_listing_class = 'grid-view-box pr aret-col-12';
				break;
				case "2":
					$grid_view_listing_class = 'grid-view-box pr aret-col-6';
				break;
				case "3":
					$grid_view_listing_class = 'grid-view-box pr aret-col-4';
				break;
				case "4":
					$grid_view_listing_class = 'grid-view-box pr aret-col-3';
				break;    
				default:
					$grid_view_listing_class = 'grid-view-box pr aret-col-3';
			}
		}
		
		$showcse_crea_serializable_maxlistingonpage_results = 20;
		
		$html .= '<div class="aretk-wrap">';
		$html .= '<div id="pagingi_container6" class="container">';
		$html .= '<div class="property-listing grid-view pr">';
		$html .= '<div class="aret-row">';
		
		$html .= '<ul class="content">';
			$singleListingConter = 1;
			
			foreach ( $allListingFinalArr as $singleListing ) { 
				
				if ( isset( $singleListing->post_author ) && !empty( $singleListing->post_author ) ) { 
				
					$content_post = get_post($singleListing->ID);
				
					if (!empty($content_post) && $content_post != '') {
						$listing_post_content = $content_post->post_content;
					}
					
					$ListingAddress = get_post_meta($singleListing->ID,'listingAddress',true);
					$ListingCity = get_post_meta($singleListing->ID,'listingcity',true);
					$listingProvince = get_post_meta($singleListing->ID,'listingProvince',true);
					$ListingPrice = get_post_meta($singleListing->ID,'listingPrice',true);
					$ListingBedRooms = get_post_meta($singleListing->ID, 'listingBedRooms', true);
					$ListingBedRooms = !empty($ListingBedRooms) ? $ListingBedRooms : '';
					$ListingBathrooms = get_post_meta($singleListing->ID, 'listingBathrooms', true);
					$ListingBathrooms = !empty($ListingBathrooms) ? $ListingBathrooms : '';
					
					$listingopenhosedatetimeArr = get_post_meta($singleListing->ID, 'listingopenhosedatetimeArr', true);
					$listingopenhosedatetimeArr = json_decode($listingopenhosedatetimeArr);
					$listingopenhosedatetimeArr = !empty($listingopenhosedatetimeArr) ? $listingopenhosedatetimeArr : '';
					
					$listingPropertyStatus = get_post_meta($singleListing->ID, 'listingAgentStatus', true);
					$listingPropertyStatus = !empty($listingPropertyStatus) ? $listingPropertyStatus : '';
					
					$date = date('d-m-Y',strtotime($singleListing->post_date));
					
					$crea_listing_images_detail_table_name = $wpdb->prefix . CREA_LISTING_IMAGES_HISTORY;
					$querySelectFirstImage = "SELECT image_url FROM $crea_listing_images_detail_table_name WHERE image_position =1 AND unique_id = $singleListing->ID";
					
					$resultSet = $wpdb->get_results($querySelectFirstImage);
					if (isset($resultSet) && !empty($resultSet)) {
						$path = $resultSet[0]->image_url;
					} else {
						$path = $site_image_path;
					}
					
					$listing_full_address_path = '';
					if ( !empty( $ListingAddress )  ) {
						$singleListingStreetAddress = trim($ListingAddress);
						$singleListingStreetAddress = str_replace(' ', '-', $singleListingStreetAddress);
						$singleListingStreetAddress = str_replace('#', '', $singleListingStreetAddress);
						$singleListingStreetAddress = str_replace('---','-',$singleListingStreetAddress);
						$listing_full_address_path.= $singleListingStreetAddress;
					}
						
					if ( !empty( $ListingCity ) ) {
						$listing_full_address_path.='-'.trim($ListingCity);
					}
					
					if ( !empty( $listingProvince ) ) {
						$listing_full_address_path.='-'.trim($listingProvince);
					}
					
					$listing_full_address_path_results = str_replace('-', ' ', $listing_full_address_path);	
				   
				     //if (isset( $listing_full_address_path )&& !empty( $listing_full_address_path) && $listing_full_address_path != '') { 
				     	$html .='<li  class="'.$grid_view_listing_class.'" ><div>';
						$html .='<div class="property-gried-main">';
								if( isset( $Showcase_crea_grid_view_color_array_results ) && !empty( $Showcase_crea_grid_view_color_array_results )  ) { 	
								$Showcase_crea_grid_view_addressbar = $Showcase_crea_grid_view_color_array_results['gridShowcaseAddressBarColor'];
										if( isset( $Showcase_crea_grid_view_addressbar ) && !empty( $Showcase_crea_grid_view_addressbar ) ) { 
										$Showcase_crea_grid_view_addressbar_result = $Showcase_crea_grid_view_addressbar;
										} else { 
											$Showcase_crea_grid_view_addressbar_result = '8FC2FF';
										}
								} 
								
						$html .='<a class="property_link" href="'.home_url().'/listing-detail/'.$singleListing->ID.'/'.$listing_full_address_path.'"><div class="heading" style="background-color: #'.$Showcase_crea_grid_view_addressbar_result.';"><div class="inner-head"><h3>'.strip_tags(substr($listing_full_address_path_results,0,15)).'...</h3></div></div>';
						if( isset( $Showcase_crea_grid_view_color_array_results ) && !empty( $Showcase_crea_grid_view_color_array_results )  ) { 	
								$Showcase_crea_grid_view_Status = $Showcase_crea_grid_view_color_array_results['gridShowcaseStatusBoxColor'];
										if( isset( $Showcase_crea_grid_view_Status ) && !empty( $Showcase_crea_grid_view_Status ) ) { 
										$Showcase_crea_grid_view_status_result = $Showcase_crea_grid_view_Status;
										} else { 
											$Showcase_crea_grid_view_status_result = '8FC2FF';
										}
								} 
						
						$html .='<div class="property-image"><img src="'.$path.'" alt="'.$listing_full_address_path.'"><a class="sky-btn" style="background-color: #'.$Showcase_crea_grid_view_status_result.';" href="javascript:void(0);">'.$listingPropertyStatus.'</a></div></a>';
							$html .='<div class="info-bar">';
									
									if( isset( $Showcase_crea_grid_view_color_array_results ) && !empty( $Showcase_crea_grid_view_color_array_results )  ) { 	
									$Showcase_crea_grid_view_text = $Showcase_crea_grid_view_color_array_results['gridShowcaseTextColor'];
										if( isset( $Showcase_crea_grid_view_text ) && !empty( $Showcase_crea_grid_view_text ) ) { 
										$Showcase_crea_grid_view_text_result = $Showcase_crea_grid_view_text;
										} else { 
											$Showcase_crea_grid_view_text_result = '8FC2FF';
										}
									}  
									if ( !empty($ListingBedRooms) && $ListingBedRooms > 0){ 
										$html .='<span class="bad" style=color:#'.$Showcase_crea_grid_view_text_result.'>'.$ListingBedRooms.' Bedrooms</span>';
									} else { 
										$html .='<span class="bad" style=color:#'.$Showcase_crea_grid_view_text_result.'>0 Bedrooms</span>';
									}
									
									if ( !empty($ListingBathrooms) && $ListingBathrooms > 0){ 
										$html .='<span class="bathroom" style=color:#'.$Showcase_crea_grid_view_text_result.'>'.$ListingBathrooms.' Bathrooms</span>';
									} else { 
										$html .='<span class="bathroom" style=color:#'.$Showcase_crea_grid_view_text_result.'>0 Bathrooms</span>';
									}
									
								$html .='</div>';
							$html .='<div class="footer-info">';
								if( $ListingPrice != '' ) { 
											$ListingPrice_results =  $ListingPrice;
									}
								$html .='<div class="menu" style="display: none; background-color: #'.$Showcase_crea_grid_view_addressbar_result.';">';
									$sharing_url = site_url('/listing-detail/'.$singleListing->ID.'/'.$listing_full_address_path);	
									$html .='<a class="social_facebook" target="_blank" href="http://www.facebook.com/sharer.php?u='.$sharing_url.'/&amp;t='.$listing_full_address_path.'"></a>';
									$html .='<a class="social_tweet" target="_blank" href="http://twitter.com/home?status='.$listing_full_address_path.'+'.$sharing_url.'"  ></a>';
									$html .='<a class="social_google" target="_blank" onclick="javascript:window.open(this.href, " ", "menubar=no,toolbar=no,resizable=yes,scrollbars=yes,height=600,width=600");return false;" href="https://plus.google.com/share?url='.$sharing_url.'/" ></a>'; 
									
									$html .='<a class="social_pinterest" target="_blank" href="http://pinterest.com/pin/create/button/?url='.$sharing_url.'/&media=https://static.aretk.com/img/properties/11703848/1.jpg&description='.$listing_full_address_path.'" ></a>';
								$html .='</div>';
							//$html .='<div class="showmenu">Click Here</div>';
									$html .='<a  class="aret-icon share showmenu"></a><span style=color:#'.$Showcase_crea_grid_view_text_result.'>$'.number_format($ListingPrice_results).'</span>';                        
								$html .='</div>';
						$html .='</div>
							</div></li>';
						$singleListingConter++;
				      //}
			} else {  
				
				if( !isset( $singleListing->RecordsReturned )) {
					
					$listing_full_address_path = '';
					
					if ( !empty($singleListing->StreetAddress) && !empty( $singleListing->City ) && !empty( $singleListing->Province ) ) { 
							if ( !empty( $singleListing->StreetAddress )  ) {
							$singleListingStreetAddress = trim($singleListing->StreetAddress);
							$singleListingStreetAddress = str_replace(' ', '-', $singleListingStreetAddress);
							$singleListingStreetAddress = str_replace('#', '', $singleListingStreetAddress);
							$singleListingStreetAddress = str_replace('--','-',$singleListingStreetAddress);
							$singleListingStreetAddress = str_replace('--','-',$singleListingStreetAddress);
							$singleListingStreetAddress = str_replace('---','-',$singleListingStreetAddress);
							$listing_full_address_path.= $singleListingStreetAddress;
						}
						
						if ( !empty( $singleListing->City ) ) {
							$singleListingStreetCity = trim($singleListing->City);
							$singleListingStreetCity = str_replace(' ', '-', $singleListingStreetCity);
							$singleListingStreetCity = str_replace('#','',$singleListingStreetCity);
							$singleListingStreetCity = str_replace('--','-',$singleListingStreetCity);
							$singleListingStreetCity = str_replace('---','-',$singleListingStreetCity);
							$listing_full_address_path.='-'.trim($singleListingStreetCity);
						}
						
						if ( !empty( $singleListing->Province ) ) {
							$singleListingStreetProvince = trim($singleListing->Province);
							$singleListingStreetProvince = str_replace(' ', '-', $singleListingStreetProvince);
							$singleListingStreetProvince = str_replace('#','',$singleListingStreetProvince);
							$singleListingStreetProvince = str_replace('--','-',$singleListingStreetProvince);
							$singleListingStreetProvince = str_replace('---','-',$singleListingStreetProvince);
							$listing_full_address_path.='-'.trim($singleListingStreetProvince);
						}
					} else { 
						if ( !empty( $singleListing->generated_address ) ) { 
							$singleListinggeneratedAddress = trim($singleListing->generated_address);
							$singleListinggeneratedAddress = str_replace(' ', '-', $singleListinggeneratedAddress);
							$singleListinggeneratedAddress = str_replace('#','',$singleListinggeneratedAddress);
							$singleListinggeneratedAddress = str_replace('--','-',$singleListinggeneratedAddress);
							$singleListinggeneratedAddress = str_replace('---','-',$singleListinggeneratedAddress);
							$listing_full_address_path.= $singleListinggeneratedAddress;
						}
					}
					
					$listing_openHouses = $singleListing->listing_openHouses;
					$listing_full_address_path_results = str_replace('-', ' ', $listing_full_address_path);
								
					
					if (isset( $listing_full_address_path )&& !empty( $listing_full_address_path) && $listing_full_address_path != '') {
						$html .='<li class="'.$grid_view_listing_class.'">';
						$html .='<div>';
						$html .= '<div class="property-gried-main">';
						$Showcase_crea_grid_view_addressbar_result ='';
						if( isset( $Showcase_crea_grid_view_color_array_results ) && !empty( $Showcase_crea_grid_view_color_array_results )  ) { 	
							$Showcase_crea_grid_view_addressbar = $Showcase_crea_grid_view_color_array_results['gridShowcaseAddressBarColor'];
							if( isset( $Showcase_crea_grid_view_addressbar ) && !empty( $Showcase_crea_grid_view_addressbar ) ) { 
								$Showcase_crea_grid_view_addressbar_result = $Showcase_crea_grid_view_addressbar;
							} else { 
								$Showcase_crea_grid_view_addressbar_result = '8FC2FF';
							}
						}
						$Showcase_crea_grid_view_status_result ='';
						if( isset( $Showcase_crea_grid_view_color_array_results ) && !empty( $Showcase_crea_grid_view_color_array_results )  ) { 	
						$Showcase_crea_grid_view_Status = $Showcase_crea_grid_view_color_array_results['gridShowcaseStatusBoxColor'];
							if( isset( $Showcase_crea_grid_view_Status ) && !empty( $Showcase_crea_grid_view_Status ) ) { 
							$Showcase_crea_grid_view_status_result = $Showcase_crea_grid_view_Status;
							} else { 
								$Showcase_crea_grid_view_status_result = '8FC2FF';
							}
						}		
						
						
						if ( $singleListing->listing_photos != null ) { 
							if ( isset( $singleListing->listing_photos) && !empty( $singleListing->listing_photos ) ) {
								if( !empty( $singleListing->listing_photos )) {  
									$domain_name = $_SERVER['SERVER_NAME'];
									$singleListingimag_array  = explode('/',$singleListing->listing_photos[0]->URL);
									if( !empty($singleListingimag_array )){ 
										$single_listing_carousel = $singleListingimag_array[2];
										if( $domain_name == $single_listing_carousel ){ 
											list($width, $height, $type, $attr) = getimagesize($singleListing->listing_photos->URL);
												if( !empty( $width ) &&  $width !='0') { 
													$singleListingImage = $singleListing->listing_photos->URL;
												} else { 
													$singleListingImage = $site_image_path;
												}
										} else if( $domain_name != $single_listing_carousel && $single_listing_carousel !='static.aretk.com' ) { 
											$singleListingImage = $site_image_path;
										} else { 
											$singleListingImage = $singleListing->listing_photos[0]->URL;
										}
									}
									
								}
								
							} else {  
								
								$domain_name = $_SERVER['SERVER_NAME'];
								$singleListingimag_array  = explode('/',$singleListing->listing_photos[0]->URL);
								if( !empty($singleListingimag_array )){ 
									$single_listing_carousel = $singleListingimag_array[2];
									if( $domain_name == $single_listing_carousel ){ 
										list($width, $height, $type, $attr) = getimagesize($singleListing->listing_photos->URL);
											if( !empty( $width ) &&  $width !='0') { 
												$singleListingImage = $singleListing->listing_photos->URL;
											} else { 
												$singleListingImage = $site_image_path;
											}
									} else if( $domain_name != $single_listing_carousel && $single_listing_carousel !='static.aretk.com' ) { 
										$singleListingImage = $site_image_path;
									} else { 
										$singleListingImage = $singleListing->listing_photos[0]->URL;
									}
								}
								/*$singleListingImage = $singleListing->listing_photos[0]->URL;*/
							}
						} else { 
							
							$singleListingImage = $site_image_path;
						}
						
						$is_exclusive_list = '';
						$property_link_url = '';	
						if ( !empty( $singleListing->mlsID ) && $singleListing->mlsID == 'Exclusive'){ 
							$is_exclusive_list = '/exclusive';
							$property_link_url = site_url().'/listing-detail/'.$singleListing->ID.$is_exclusive_list.'/'.$listing_full_address_path;
						} else { 
							$property_link_url = site_url().'/listing-detail/'.$singleListing->ID.'/'.$listing_full_address_path;
						}
						
						$Showcase_crea_listing_color_title = '';
						if( !empty( $Showcase_crea_listing_color_title ) && $Showcase_crea_listing_color_title !=''){ 
							$Showcase_crea_listing_color_title = $Showcase_crea_listing_color_title;
						}

						$html .='<a class="property_link" href="'.$property_link_url.'"><div class="heading" style="background-color: #'.$Showcase_crea_grid_view_addressbar_result.';"><div class="inner-head">';
						$html.='<h3 style="color:#'.$Showcase_crea_listing_color_title.'" class="default_listing_mlsID" >MLS&reg#'.$singleListing->mlsID.'</h3><h3>'.strip_tags(substr($listing_full_address_path_results,0,15)).'...</h3></div></div><div class="property-image"><img src="'.$singleListingImage.'" alt="'.$listing_full_address_path.'"><a class="sky-btn" style="background-color: #'.$Showcase_crea_grid_view_status_result.';"  href="javascript:void(0);">'.$singleListing->TransactionType.'</a></div></a>';
						$html .='<div class="info-bar">';
								
								if( isset( $Showcase_crea_grid_view_color_array_results ) && !empty( $Showcase_crea_grid_view_color_array_results )  ) { 	
										$Showcase_crea_grid_view_text = $Showcase_crea_grid_view_color_array_results['gridShowcaseTextColor'];
									if( isset( $Showcase_crea_grid_view_text ) && !empty( $Showcase_crea_grid_view_text ) ) { 
										$Showcase_crea_grid_view_text_result = $Showcase_crea_grid_view_text;
									} else { 
										$Showcase_crea_grid_view_text_result = '8FC2FF';
									}
								}
								
								if ( !empty($singleListing->BedroomsTotal) && $singleListing->BedroomsTotal > 0 ){ 
									$html .='<span class="bad" style=color:#'.$Showcase_crea_grid_view_text_result.'>'.$singleListing->BedroomsTotal.' Bedrooms</span>';
								} else { 
									$html .='<span class="bad" style=color:#'.$Showcase_crea_grid_view_text_result.'>0 Bedroom</span>';
								}
								
								if ( !empty($singleListing->BathroomTotal) && $singleListing->BathroomTotal > 0 ){ 
									$html .='<span class="bathroom" style=color:#'.$Showcase_crea_grid_view_text_result.'>'.$singleListing->BathroomTotal.' Bathrooms</span>';
								} else{ 
									$html .='<span class="bathroom" style=color:#'.$Showcase_crea_grid_view_text_result.'>0 Bathroom</span>';
								}
						
								
							$html .='</div>';
							$html .='<div class="footer-info">';
								$html .='<div class="menu" style="display: none; background-color: #'.$Showcase_crea_grid_view_addressbar_result.';">';
								
									$sharing_url = site_url('/listing-detail/'.$singleListing->ID.'/'.$listing_full_address_path);	
									$html .='<a class="social_facebook" target="_blank" href="http://www.facebook.com/sharer.php?u='.$property_link_url.'/&amp;t='.$listing_full_address_path.'"></a>';
									$html .='<a class="social_tweet"  target="_blank" href="http://twitter.com/home?status='.$listing_full_address_path.'+'.$property_link_url.'"  ></a>';
									$html .='<a class="social_google" target="_blank" onclick="javascript:window.open(this.href, " ", "menubar=no,toolbar=no,resizable=yes,scrollbars=yes,height=600,width=600");return false;" href="https://plus.google.com/share?url='.$property_link_url.'/" ></a>'; 
									
									$html .='<a class="social_pinterest" target="_blank" href="http://pinterest.com/pin/create/button/?url='.$property_link_url.'/&media='.$singleListingImage.'&description='.$listing_full_address_path.'" ></a>';
								
								$html .='</div>';
							//$html .='<div class="showmenu">Click Here</div>';
							
							if( $singleListing->Price == '0.00' ) { 
								$single_listing_prise = $singleListing->Lease;
								} else {
								$single_listing_prise = $singleListing->Price;
							}

								$html .='<a class="aret-icon share showmenu"></a><span style=color:#'.$Showcase_crea_grid_view_text_result.'>$'.number_format($single_listing_prise).'</span>';                         
							$html .='</div>';
						$html .='</div>';
						$html .='</div>';
						$html .='</li>';
						
						$singleListingConter++;
					   }
					}
				}
			}
				
			$html .='</ul>';
		 $html .= '</div>';
		$html .= '</div>';
		$html .= '</div>';
		
	
		$Showcase_crea_grid_view_color_pagination = "DB5C04";
		$Showcase_crea_grid_view_text_color_pagination ="00000";
		if( isset( $Showcase_crea_grid_view_color_array_results ) && !empty( $Showcase_crea_grid_view_color_array_results )){ 
			$Showcase_crea_grid_view_color_pagination = $Showcase_crea_grid_view_color_array_results['gridShowcasePaginationColor'];
			$Showcase_crea_grid_view_text_color_pagination = $Showcase_crea_grid_view_color_array_results['gridShowcasePaginationTextColor'];
		}
		?>
		
		<style  type="text/css">
			div.pagination a{ background-color:#<?php echo $Showcase_crea_grid_view_color_pagination; ?>!important;color:<?php  echo "#".$Showcase_crea_grid_view_text_color_pagination; ?>!important}
			div.pagination a{ background-color:#<?php echo $Showcase_crea_grid_view_color_pagination; ?>!important;color:<?php  echo "#".$Showcase_crea_grid_view_text_color_pagination; ?>!important}
			div.pagination span.current{background-color:<?php echo "#".$Showcase_crea_grid_view_text_color_pagination?> !important;color:<?php echo "#".$Showcase_crea_grid_view_color_pagination?> !important }
		</style>
		<?php
		if( isset( $allLisgngFinalArrCount ) && !empty( $allLisgngFinalArrCount ) && $allLisgngFinalArrCount > 0 ){
			//$html .= '<div class="page_navigation"></div>';
			$html .='<div id="grid_advance_search_pagination" class="pagination">';
				if ( !empty( $max_numbers_pagination ) ) {  
					$custom_pagination = Aretk_Crea_Public::custom_pagination(ceil( $max_numbers_pagination ),"",$page_number_id);
					$html.=$custom_pagination;
				}
			$html .='</div>';
		}
		
		
		$html .= '</div>';
		
		if ( !empty($showcse_crea_feed_ddf_type) && !empty( $showcse_crea_feed_ddf_type) && !empty($getSubscriptionListingFeed) && $getSubscriptionListingFeed === 'valid' && $allLisgngFinalArrCount > 0){ 
			$html .='<div class="custom_listing_content_subscription_active"><p>MLS&reg;, REALTOR&reg;, and the associated logos are trademarks of The Canadian Real Estate Association.</p></div>';
		}
		
		//Terms of use
		/*if( empty( $_COOKIE["aretk_crea_terms_of_use"] ) && !empty($showcse_crea_feed_ddf_type) && isset( $getSubscriptionListingFeed ) && !empty( $getSubscriptionListingFeed) && $getSubscriptionListingFeed === 'valid' ) {
			$html.='<div id="aretk_crea_disclaimer_container" style="position:absolute; left: 0; right: 0; margin:auto; top:15%; z-index:1001;"><div style="margin:auto; width:75%;"><h2 style="color:white; font-size: 24px; font-family: arial; margin-bottom: 20px;">Terms & Conditions Agreement</h2><p style="color:white; font-size: 14px; line-height: 22px; margin-bottom: 20px !important;">The listing content on this website is protected by copyright and other laws, and is intended solely for the private, non-commercial use by individuals. Any other reproduction, distribution or use of the content, in whole or in part, is specifically forbidden. The prohibited uses include commercial use, "screen scraping", "database scraping", and any other activity intended to collect, store, reorganize or manipulate data on the pages produced by or displayed on this website.</p>
			<p style="color:white; font-size: 14px; line-height: 22px; margin-bottom: 20px !important;">REALTOR&reg;, REALTORS&reg;, and the REALTOR&reg; logo are certification marks that are owned by REALTOR&reg; Canada Inc. and licensed exclusively to The Canadian Real Estate Association (CREA). These certification marks identify real estate professionals who are members of CREA and who must abide by CREA\'s By-Laws, Rules, and the REALTOR&reg; Code. The MLS&reg; trademark and the MLS&reg; logo are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA.</p>
			<p style="color:white; font-size: 14px; line-height: 22px; margin-bottom: 20px !important;">The information contained on this site is based in whole or in part on information that is provided by members of The Canadian Real Estate Association, who are responsible for its accuracy. CREA reproduces and distributes this information as a service for its members and assumes no responsibility for its accuracy.</p><div>
			<input type="button" value="Accept" id="aretk_crea_disclaimer_accept"><input type="button" value="Decline" id="aretk_crea_disclaimer_decline"></div></div></div>
			<div id="aretk_crea_disclaimer_background" style="position:fixed; top:0; bottom:0; width:100%; left: 0; right: 0; z-index:1000; background:black; opacity:0.9"></div>';
		}*/
		
		} else  {
				$html .='<p>Sorry no properties found</p>';
		}
		
			
	//END Grid View Html
	}
	
	if( $showcse_crea_display_theams_option == 'Map' ) { 
			//Start map view search
			$html ='';
			$html ='<div class="aretk-wrap">';
			$html ='<div class="showcase_map" id="crea_custom_map_result">';
			$html .='<div id="property_count_preview_example_advance_search"></div>';
			$html .='<input type="hidden" id="showcse_crea_feed_include_exclude" value="'.$showcse_crea_feed_include_exclude.'">';
			$html .='<input type = "hidden" id ="areatk_plugin_url" value="'.ARETK_CREA_PLUGIN_URL.'">';
			
				$html .='<div class="property-listing map-view pr">';
				$html .='<input type="hidden" id="default_map_search_param" value="'.$final_query_param.'">';
				$html .='<input type="hidden" id="subscription_advance_search_select_feed" value="'.$showcaseselectedFeed.'">';
				$html .='<input type="hidden" id="map_lat_sw" value="">';
				$html .='<input type="hidden" id="map_lng_sw" value="">';
				$html .='<input type="hidden" id="map_lat_ne" value="">';
				$html .='<input type="hidden" id="map_lng_ne" value="">';
				$html .='<input type="hidden" id="map_zoom_level" value="'.$showcasemapimagezoom.'" name="map_zoom_level">';
				
				 $google_map_api_key_setting = get_option('google-map-api-name',''); 
			  		if( !empty( $google_map_api_key_setting ) && isset( $google_map_api_key_setting )) {
						$html .='<div class="map-iframe-main">';
							$html .='<div id="mapProperty"></div>';
						$html .='</div>';
			  		} else { 
			  			$html .='<div class="map-iframe-main">';
							$html .='<div class="map_key_unvalid_message">Please Enter Google Map APi Key in Plugin Setting</div>';
						$html .='</div>';
			  				
			  		}
					
			  		$html .='<div class="map-view-right">';
			  		$html .='<div class="map-search">';
					$property_map_array = array();
					$propety_counter = 0;
					$setcounter = 0;
					
					if( !empty( $google_map_api_key_setting ) && isset( $google_map_api_key_setting )) {
					$html.="<script>
						var dragend_lat = jQuery('#dragendlatitude_value').val();
										var dragend_long =jQuery('#dragendlongitude_value').val();
										var subscription_feed_select =jQuery('#subscription_feed_select').val();
										var showcse_crea_feed_include_exclude =jQuery('#showcse_crea_feed_include_exclude').val();
										var markerCluster;
										var map = null;
										var site_path = jQuery('#areatk_plugin_url').val();
										var imageUrl = site_path+'public/images/map_marker_home.png';
										var infoWindow = null;
										var subscription_feed = jQuery('#subscription_feed_select').val();
										var markers = [];
										var zoom_effect = jQuery('#showcasemapimagezoomaction').val();
										var markerImage = new google.maps.MarkerImage(imageUrl,
										new google.maps.Size(32, 37));
									
										  
										function get_markers_advance( extra_var ) {  
											subscription_feed_results  = jQuery('#subscription_advance_search_select_feed').val();
						
											var mapbound_lat_sw = map.getBounds().getSouthWest().lat();
											var mapbound_lng_sw = map.getBounds().getSouthWest().lng();
											var mapbound_lat_ne = map.getBounds().getNorthEast().lat();
											var mapbound_lng_ne = map.getBounds().getNorthEast().lng(); 
											var map_zoom_level = map.getZoom();
				
											
											jQuery('#map_lat_sw').val(mapbound_lat_sw);
											jQuery('#map_lng_sw').val(mapbound_lng_sw);
											jQuery('#map_lat_ne').val(mapbound_lat_ne);
											jQuery('#map_lng_ne').val(mapbound_lng_ne);
											jQuery('#map_zoom_level').val(map_zoom_level);
											
											var advance_search_permeter = jQuery('#default_map_search_param').val();
											
											if(markers.length > 0) {
												for (var i = 0; i < markers.length; i++)  { 
													markers[i].setMap(null);
												}
												
												markerCluster.clearMarkers();
											}
											markers = [];
											
											//ajaxindicatorstart('Please wait we are updating the data..');
											jQuery.ajax({ 
								type: 'POST',
								url:adminajaxjs.adminajaxjsurl,
								data: ({
									action: 'custom_ajax_for_map_view_dragend',
									subscription_feed_results :subscription_feed_results, 
									advance_search_permeter :advance_search_permeter,
									mapbound_lat_sw :mapbound_lat_sw, 
									mapbound_lng_sw :mapbound_lng_sw, 
									mapbound_lat_ne :mapbound_lat_ne, 
									mapbound_lng_ne :mapbound_lng_ne, 
									map_zoom_level :map_zoom_level, 
									showcse_crea_feed_include_exclude:showcse_crea_feed_include_exclude,
								}),
								success: function (response) { 
									jQuery('.se-pre-con').show();
									
									markerImage = new google.maps.MarkerImage(imageUrl,
									new google.maps.Size(32, 37));
									var property_response = jQuery.parseJSON(response);
									var property_count = property_response.count;
									
									//jQuery('#property_count_preview_example_advance_search').html('');
									//jQuery('#property_count_preview_example_advance_search').html('Listings:' +property_count);
									
									for (var i = 0; i < property_count; i++) {
									var titleText = property_response.property[i].property_id;
									if (titleText === '') {
									  titleText = 'No title';
									}
									var item = document.createElement('DIV');
									var title = document.createElement('A');
									title.href = '#';
									title.className = 'title';
									title.innerHTML = titleText;
									item.appendChild(title);
									var latLng = new google.maps.LatLng(property_response.property[i].latitude,
									property_response.property[i].longitude); 
							
									/*var imageUrl = 'http://chart.apis.google.com/chart?cht=mm&chs=24x32&chco=' +
										'FFFFFF,008CFF,000000&ext=.png';*/
										
									var imageUrl = site_path+'public/images/map_marker_home.png';
										
									var markerImage = new google.maps.MarkerImage(imageUrl,
										new google.maps.Size(32, 37));
									
									var marker = new google.maps.Marker({
									  'position': latLng,
									  'icon': markerImage,
									  scrollwheel: false
									});
									
									var fn = markerClickFunction(property_response.property[i]['property_id'], latLng);
									
									google.maps.event.addListener(marker, 'click', fn);
										
									google.maps.event.addDomListener(title, 'click', fn);
									markers.push(marker);
									}
									
									showOnlyVisibleMarkers();
								 markerCluster = new MarkerClusterer(map, markers, {imagePath: site_path+'public/images/m',maxZoom: 15});
									jQuery('.se-pre-con').hide();
								}
							});								
																	  	
											return false;
										}
										  	
					var subscription_feed = jQuery('#subscription_advance_search_select_feed').val();		  
					function markerClickFunction( property, latlng ) { 
					 var title = property;
						return function(e) {
						e.cancelBubble = true;
						e.returnValue = false;
						if (e.stopPropagation) {
						  e.stopPropagation();
						  e.preventDefault();
						} 
						jQuery.ajax({
						type: 'POST',
						url:adminajaxjs.adminajaxjsurl,
						
						data: ({
							action: 'custom_ajax_for_map_view_infobox',
							property_id:property,
							subscription_feed:subscription_feed,
							showcse_crea_feed_include_exclude:showcse_crea_feed_include_exclude,
						
						}),
						success: function (response) { 
							
							var infoHtml = response;
							infoWindow.setContent(infoHtml);
							infoWindow.setPosition(latlng);
							infoWindow.open(map);
							
						}
						});
						
						};
						markerCluster = new MarkerClusterer(map, markers, {imagePath: site_path+'public/images/m',maxZoom: 15});
						
					}
					
						function showOnlyVisibleMarkers() {
						    var bounds = map.getBounds(),
						        count = 0;
						                                   
						    for (var i = 0; i < markers.length; i++) {
						        var marker = markers[i];
						                                           
						        if(bounds.contains(marker.getPosition())===true) {
						            count++;
						        }
						    }
						    jQuery('#property_count_preview_example_advance_search').html('Listings:'+count);
						}
											

						function initialize() {
											
						var mapOptions = {
						zoom: $showcasemapimagezoom,
						scrollwheel: false,
						center: new google.maps.LatLng($mapfilterlatitude, $mapfilterlongitude),
						//scrollwheel: map_scrollwheel,
						mapTypeControlOptions: {style: google.maps.MapTypeControlStyle.DROPDOWN_MENU}
						};
						map = new google.maps.Map(document.getElementById('mapProperty'), mapOptions);
						
						infoWindow = new google.maps.InfoWindow();
							
			            
							google.maps.event.addListener(map, 'dragend', function(ev){
								
								get_markers_advance('dragend' );
								
							});
							
							google.maps.event.addListener(map, 'zoom_changed', function(ev){
								
								setTimeout(function() {
							// wait 1 second to ensure zoom complete
								get_markers_advance( 'zoom_changed' );
								}, 1000);
							});
							
							google.maps.event.addListenerOnce(map, 'bounds_changed', function() {
								
								
								get_markers_advance( 'zoom_changed' );
								console.log('bounds_changed' );
							});
							
							// Fired when the map becomes idle after panning or zooming.
							google.maps.event.addListener(map, 'idle', function() {
						        showOnlyVisibleMarkers();
						    });
					}
						
						initialize();
						</script>";
					}							
					 
					$html .='</div>';
					
			
		$html .='</div>'; 
		$html .='</div>';
		
		if ( !empty($showcse_crea_feed_ddf_type) && !empty( $showcse_crea_feed_ddf_type) && !empty($getSubscriptionListingFeed) && $getSubscriptionListingFeed === 'valid' ){ 
			$html .='<div class="custom_listing_content_subscription_active"><p>MLS&reg;, REALTOR&reg;, and the associated logos are trademarks of The Canadian Real Estate Association.</p></div>';
		}
		
		//Terms of use
		/*if( empty( $_COOKIE["aretk_crea_terms_of_use"] ) && !empty($showcse_crea_feed_ddf_type) && isset( $getSubscriptionListingFeed ) && !empty( $getSubscriptionListingFeed) && $getSubscriptionListingFeed === 'valid' ) {
			$html.='<div id="aretk_crea_disclaimer_container" style="position:absolute; left: 0; right: 0; margin:auto; top:15%; z-index:1001;"><div style="margin:auto; width:75%;"><h2 style="color:white; font-size: 24px; font-family: arial; margin-bottom: 20px;">Terms & Conditions Agreement</h2><p style="color:white; font-size: 14px; line-height: 22px; margin-bottom: 20px !important;">The listing content on this website is protected by copyright and other laws, and is intended solely for the private, non-commercial use by individuals. Any other reproduction, distribution or use of the content, in whole or in part, is specifically forbidden. The prohibited uses include commercial use, "screen scraping", "database scraping", and any other activity intended to collect, store, reorganize or manipulate data on the pages produced by or displayed on this website.</p>
			<p style="color:white; font-size: 14px; line-height: 22px; margin-bottom: 20px !important;">REALTOR&reg;, REALTORS&reg;, and the REALTOR&reg; logo are certification marks that are owned by REALTOR&reg; Canada Inc. and licensed exclusively to The Canadian Real Estate Association (CREA). These certification marks identify real estate professionals who are members of CREA and who must abide by CREA\'s By-Laws, Rules, and the REALTOR&reg; Code. The MLS&reg; trademark and the MLS&reg; logo are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA.</p>
			<p style="color:white; font-size: 14px; line-height: 22px; margin-bottom: 20px !important;">The information contained on this site is based in whole or in part on information that is provided by members of The Canadian Real Estate Association, who are responsible for its accuracy. CREA reproduces and distributes this information as a service for its members and assumes no responsibility for its accuracy.</p><div>
			<input type="button" value="Accept" id="aretk_crea_disclaimer_accept"><input type="button" value="Decline" id="aretk_crea_disclaimer_decline"></div></div></div>
			<div id="aretk_crea_disclaimer_background" style="position:fixed; top:0; bottom:0; width:100%; left: 0; right: 0; z-index:1000; background:black; opacity:0.9"></div>';
		}*/
		
		$html .='</div>'; 
		$html .='</div>'; 
	}
}

echo  $html;
		
get_footer();