prefix . CREA_USER_LISTING_DETAILS; $getAllUsername = $wpdb->get_results("SELECT username FROM $crea_user_name_table_name"); $getSubscriptionListingFilter = get_option('crea_subscription_status', ''); if( isset( $getSubscriptionListingFilter ) && !empty( $getSubscriptionListingFilter ) && $getSubscriptionListingFilter === 'valid' && empty($listing_type) && $listing_type != 'exclusive' ) { if ( !empty($is_exclusive) && $is_exclusive == 'exclusive' ) { $listings = Aretk_Crea_Admin::get_property_detail_page_result_for_exclusive($listing_id); $listings = json_decode(json_encode($listings)); if ( isset($listings) && !empty($listings)) { foreach ($listings as $listing_key => $listing ){ if ( !isset( $listing->TotalRecords ) && empty( $listing->TotalRecords ) ) { $allListingArr[$listing->ID] = $listing; } } } } else { $allListingArr = array(); if (isset($getAllUsername) && !empty($getAllUsername)) { foreach ($getAllUsername as $singleUsername) { $userName = $singleUsername->username; $result_type = 'full'; $listings = Aretk_Crea_Admin::get_property_detail_page_result($userName, $result_type,$listing_id); # JSON Encode data to work properly with old listing details template $listings = json_decode(json_encode($listings), false); if ( isset($listings) && !empty($listings)) { foreach ($listings as $listing_key => $listing ){ if ( !isset( $listing->TotalRecords ) && empty( $listing->TotalRecords ) ) { $allListingArr[$listing->ID] = $listing; } } } unset($singleUsername); } unset($getAllUsername); $property_record_returned = $listings[0]->RecordsReturned; } } $crea_property_detail_page = (object) $allListingArr[$listing_id]; if ( !empty( $allListingArr[$listing_id] ) && isset( $allListingArr[$listing_id] ) ) { //address link url $listing_full_address_path_url = ''; if ( !empty($crea_property_detail_page->StreetAddress) && !empty( $crea_property_detail_page->City ) && !empty( $crea_property_detail_page->Province ) ) { if ( !empty( $crea_property_detail_page->StreetAddress ) ) { $singleListingStreetAddress = trim($crea_property_detail_page->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_url.= $singleListingStreetAddress; } if ( !empty( $crea_property_detail_page->City ) ) { $singleListingStreetCity = trim($crea_property_detail_page->City); $singleListingStreetCity = str_replace(' ', '-', $singleListingStreetCity); $singleListingStreetCity = str_replace('#', '', $singleListingStreetCity); $singleListingStreetCity = str_replace('-','-',$singleListingStreetCity); $singleListingStreetCity = str_replace('--','-',$singleListingStreetCity); $singleListingStreetCity = str_replace('---','-',$singleListingStreetCity); $listing_full_address_path_url.='-'.trim($singleListingStreetCity); } if ( !empty( $crea_property_detail_page->Province ) ) { $singleListingStreetProvince = trim($crea_property_detail_page->Province); $singleListingStreetProvince = str_replace(' ', '-', $singleListingStreetProvince); $singleListingStreetProvince = str_replace('#', '', $singleListingStreetProvince); $singleListingStreetProvince = str_replace('-','-',$singleListingStreetProvince); $singleListingStreetProvince = str_replace('--','-',$singleListingStreetProvince); $singleListingStreetProvince = str_replace('---','-',$singleListingStreetProvince); $listing_full_address_path_url.='-'.trim($singleListingStreetProvince); } } else { if ( !empty( $crea_property_detail_page->generated_address ) ) { $singleListinggeneratedAddress = trim($crea_property_detail_page->generated_address); $singleListinggeneratedAddress = str_replace(' ', '-', $singleListinggeneratedAddress); $singleListinggeneratedAddress = str_replace('#', '', $singleListinggeneratedAddress); $singleListinggeneratedAddress = str_replace('--','-',$singleListinggeneratedAddress); $singleListinggeneratedAddress = str_replace('--','-',$singleListinggeneratedAddress); $singleListinggeneratedAddress = str_replace('---','-',$singleListinggeneratedAddress); $listing_full_address_path_url.= $singleListinggeneratedAddress; } } if( (!empty( $crea_property_detail_page->mlsID ) || $crea_property_detail_page->mlsID == 'Exclusive') && $listing_full_address_path_url === $listing_get_full_address ) { $post_listing_detail_count_table = $wpdb->prefix.CREA_LISTING_DETAIL_COUNT; $page_visit_view_counter = 1; $property_detail_exclusive_or_not_results = "In-Exclusive"; if(isset( $is_exclusive ) && !empty( $is_exclusive ) && $is_exclusive == 'exclusive'){ $property_detail_exclusive_or_not_results = "Exclusive"; } $getlisting_detail_count_results = "SELECT * FROM $post_listing_detail_count_table WHERE `property_id`=$listing_id"; $getlisting_detail_count_results_array = $wpdb->get_results($getlisting_detail_count_results); if(isset( $getlisting_detail_count_results_array ) && empty( $getlisting_detail_count_results_array )){ $wpdb->insert( $post_listing_detail_count_table, array( 'property_id' => $listing_id, 'property_type' => $property_detail_exclusive_or_not_results ,'view_count' => $page_visit_view_counter ), array( '%s','%s', '%d' ) ); }else { foreach ( $getlisting_detail_count_results_array as $getlisting_detail_count_results_array_listings ) { $page_visit_view_counter = $getlisting_detail_count_results_array[0]->view_count; } $page_visit_view_counter = $page_visit_view_counter+1; $wpdb->update( $post_listing_detail_count_table, array( 'property_type' => $property_detail_exclusive_or_not_results,'view_count'=>$page_visit_view_counter), array( 'property_id' => $listing_id ), array( '%s', '%s' ), array( '%d' ) ); } $postId = $listing_id; $listing_count = $page_visit_view_counter; Aretk_Crea_Public::update_view_count( $postId, $listing_count ); } $crea_listing_price = ''; $crea_listing_price = $crea_property_detail_page->Price; if( $crea_listing_price === "0.00" ){ $crea_listing_price = $crea_property_detail_page->Lease; } $crea_listing_price = !empty($crea_listing_price) ? number_format($crea_listing_price) : ''; $crea_property_detail_page_exclusive_or_not = !empty($crea_property_detail_page->mlsID) ? $crea_property_detail_page->mlsID :''; $listingFullAddress = !empty( $crea_property_detail_page->generated_address ) ? $crea_property_detail_page->generated_address :''; $listingFullAddress = !empty($listingFullAddress) ? $listingFullAddress : ''; $listingDescription = !empty( $crea_property_detail_page->PublicRemarks ) ? $crea_property_detail_page->PublicRemarks :'' ; $listingDescription = !empty($listingDescription) ? $listingDescription : ''; $listingTransactionType = !empty($crea_property_detail_page->TransactionType ) ? $crea_property_detail_page->TransactionType :''; $listingTransactionType = !empty($listingTransactionType) ? $listingTransactionType : ''; $listingPropertyBathRooms = !empty($crea_property_detail_page->BathroomTotal) ? $crea_property_detail_page->BathroomTotal :''; $listingPropertyBathRooms = !empty($listingPropertyBathRooms) ? $listingPropertyBathRooms : ''; //Address Tab $listingAddress = !empty($crea_property_detail_page->AddressLine1)? $crea_property_detail_page->AddressLine1 :''; $listingAddress = !empty($listingAddress) ? $listingAddress : ''; $listingCity = !empty($crea_property_detail_page->City) ? $crea_property_detail_page->City : ''; $listingCity = !empty($listingCity) ? $listingCity : ''; $listingPostalCode = !empty($crea_property_detail_page->PostalCode) ? $crea_property_detail_page->PostalCode :'' ; $listingPostalCode = !empty($listingPostalCode) ? $listingPostalCode : ''; $listingCountry = !empty($crea_property_detail_page->Country) ? $crea_property_detail_page->Country :'' ; $listingCountry = !empty($listingCountry) ? $listingCountry : ''; $listing_full_address_path_for_meta_title = ''; if ( !empty( $crea_property_detail_page->StreetAddress ) ) { $listing_full_address_path_for_meta_title.= $crea_property_detail_page->StreetAddress; } if ( !empty( $crea_property_detail_page->City ) ) { $listing_full_address_path_for_meta_title.= " ".$crea_property_detail_page->City; } if ( !empty( $crea_property_detail_page->Province ) ) { $listing_full_address_path_for_meta_title.= ' '.$crea_property_detail_page->Province; } $listing_full_address_path_for_meta_title = !empty( $listing_full_address_path_for_meta_title ) ? $listing_full_address_path_for_meta_title : 'Address not available'; //Details Tab $listingLID= !empty($crea_property_detail_page->LID ) ? $crea_property_detail_page->LID :''; $listingPrice = !empty($crea_property_detail_page->Price ) ? $crea_property_detail_page->Price :''; //Details Tab if( !empty( $crea_property_detail_page ) && $crea_property_detail_page !=''){ if( !empty( $crea_property_detail_page->Price ) && isset( $crea_property_detail_page->Price ) && $crea_property_detail_page->Price == '0.00' ) { $listingPrice = number_format($crea_property_detail_page->Lease) ; } else { $listingPrice = number_format($crea_property_detail_page->Price); } } //$listingPrice = !empty($listingPrice) ? number_format($listingPrice) : ''; $listingBathroomTotal = !empty( $crea_property_detail_page->BathroomTotal ) ? $crea_property_detail_page->BathroomTotal :''; $listingPropertyBathRooms = !empty($listingBathroomTotal) ? $listingBathroomTotal : ''; $listingBedroomsTotal = !empty($crea_property_detail_page->BedroomsTotal) ? $crea_property_detail_page->BedroomsTotal :''; $listingBedroomsTotal = !empty($listingBedroomsTotal) ? $listingBedroomsTotal : ''; if( !empty( $crea_property_detail_page ) && $crea_property_detail_page !=''){ if( !empty( $crea_property_detail_page->listing_rooms) && isset( $crea_property_detail_page->listing_rooms)){ $listingRoomsTotal = count($crea_property_detail_page->listing_rooms); $listingRoomsTotal = !empty($listingRoomsTotal) ? $listingRoomsTotal : ''; } } $listingAppliances = !empty($crea_property_detail_page->Appliances)?$crea_property_detail_page->Appliances:''; $listingAppliances = !empty($listingAppliances) ? $listingAppliances : ''; $listingFeatures = !empty($crea_property_detail_page->Features)?$crea_property_detail_page->Features:''; $listingFeatures = !empty($listingFeatures) ? $listingFeatures : ''; //Agents Array $listingPropertyListingAgents = !empty($crea_property_detail_page->listing_agents)? $crea_property_detail_page->listing_agents :''; $listingPropertyListingAgents = !empty($listingPropertyListingAgents) ? $listingPropertyListingAgents : array(); $listingPropertyListingRoom = !empty( $crea_property_detail_page->listing_rooms ) ? $crea_property_detail_page->listing_rooms :''; $listingPropertyListingRoom = !empty($listingPropertyListingRoom) ? $listingPropertyListingRoom : array(); $is_exclusive_list = ''; $property_link_url = ''; if(!empty( $crea_property_detail_page ) && $crea_property_detail_page !=''){ if ( !empty( $crea_property_detail_page->mlsID ) && $crea_property_detail_page->mlsID == 'Exclusive'){ $is_exclusive_list = '/exclusive'; $property_link_url = site_url().'/listing-detail/'.$crea_property_detail_page->ID.$is_exclusive_list.'/'.$listing_full_address_path_url; } else { $property_link_url = site_url().'/listing-detail/'.$crea_property_detail_page->ID.'/'.$listing_full_address_path_url; } } $site_image_path = ARETK_CREA_PLUGIN_URL.'public/images/preview_img.jpg'; if ( $crea_property_detail_page->listing_photos != null ) { if ( isset( $crea_property_detail_page->listing_photos) && !empty( $crea_property_detail_page->listing_photos ) && !is_array($crea_property_detail_page->listing_photos) ){ if( !empty( $crea_property_detail_page->listing_photos )) { $domain_name = $_SERVER['SERVER_NAME']; $singleListingimag_array = explode('/',$crea_property_detail_page->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($crea_property_detail_page->listing_photos->URL); if( !empty( $width ) && $width !='0') { $singleListingImage = $crea_property_detail_page->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 = $crea_property_detail_page->listing_photos->URL; } } } } else { $singleListingImage = $crea_property_detail_page->listing_photos[0]->URL; } } else { $singleListingImage = $site_image_path; } ?>

$

® #".$crea_property_detail_page->mlsID; ?>

listing_photos; $crea_property_detail_page_images_count = count($crea_property_detail_page_images); if ( isset($crea_property_detail_page_images) && !empty($crea_property_detail_page_images) && is_array($crea_property_detail_page_images) ) { ?> PublicRemarks ) ){ echo "

". $crea_property_detail_page->PublicRemarks."

"; } ?>
geocoded_latitude; $property_long = $crea_property_detail_page->geocoded_longitude; $listingBedroomsTotal_results = "Bedroom: 0"; $listingBathroomTotal_results = "Bathroom: 0"; if(isset( $listingBedroomsTotal ) && !empty( $listingBedroomsTotal ) && $listingBedroomsTotal !=''){ $listingBedroomsTotal_results = " Bedroom: ".$listingBedroomsTotal; } if(isset( $listingBathroomTotal ) && !empty( $listingBathroomTotal ) && $listingBathroomTotal !=''){ $listingBathroomTotal_results = " Bathoom: ".$listingBathroomTotal; } $google_map_api_key = get_option('google-map-api-name'); if( (!empty( $google_map_api_key ) && $google_map_api_key != "" ) ) { if ( !empty($site_property_url) && !empty($property_lat) && !empty($property_long) ) { if ( $property_lat != '57.678079218156' && $property_long != '-101.8051686875' ) { ?>
StreetAddress ) || !empty( $listingCity ) || !empty( $crea_property_detail_page->Province ) ) { ?>
Address
    StreetAddress)) {?>
  • Street Address : StreetAddress; ?>
  • City :
  • Province)) {?>
  • Province : Province; ?>
mlsID ) || !empty( $crea_listing_price ) || !empty( $listingBedroomsTotal ) || !empty( $listingBathroomTotal ) || !empty( $crea_property_detail_page->SizeInterior ) ) { ?>
Detail
    mlsID ) ) { ?>
  • MLS®# : mlsID; ?>
  • Price :
  • 0 ) {?>
  • Bedroom :
  • 0 ) {?>
  • Bathroom :
  • SizeInterior ) && $crea_property_detail_page->SizeInterior > 0 ) {?>
  • Area : SizeInterior; ?>
  • SizeIrregular ) && $crea_property_detail_page->SizeIrregular > 0) {?>
  • Property Lot Size : SizeIrregular; ?>
Feature
geocoded_latitude; $property_long = $crea_property_detail_page->geocoded_longitude; $crea_property_detail_page_address = urlencode($crea_property_detail_page->generated_address); if ( !empty($property_lat) && !empty($property_long) ) { if ( $property_lat != '57.678079218156' && $property_long != '-101.8051686875' ) { $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, "http://api.walkscore.com/score?format=json&address=$crea_property_detail_page_address&lat=$property_lat&lon=$property_long&wsapikey=$walkscore_api_results"); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_HEADER, 0); $data = curl_exec($ch); curl_close($ch); $resultSet = json_decode($data); if ( !empty($resultSet->status) ){ ?>
WalkScore
Rooms

Room Dimension

Type; ?> Dimension; ?>

office; } $listinged_by_companyname = array_unique($listingPropertyListingAgent_listed_by); if ( isset($listinged_by_companyname) && !empty( $listinged_by_companyname ) ) { ?>

Listed By:

MLS®, REALTOR®, and the associated logos are trademarks of The Canadian Real Estate Association.

Feedtype ) ? $crea_property_detail_page->Feedtype: ''; if( empty( $_COOKIE["aretk_crea_terms_of_use"] ) && isset( $getSubscriptionStatus ) && !empty( $getSubscriptionStatus) && $getSubscriptionStatus === 'valid' && !empty($crea_property_detail_page_exclusive_or_not) && $crea_property_detail_page_exclusive_or_not != 'Exclusive' && !empty( $crea_property_feed_type ) && ( $crea_property_feed_type == 'National Pool' || $crea_property_feed_type == 'Board Listings' ) ) { ?>

Terms & Conditions Agreement

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.

REALTOR®, REALTORS®, and the REALTOR® logo are certification marks that are owned by REALTOR® 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® Code. The MLS® trademark and the MLS® logo are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA.

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.

prefix.'crea_agent'; foreach ( $listingPropertyListingAgents as $listingPropertyListingAgent ){ #$listingagentname = $listingPropertyListingAgent->Name; $listingAgentQuery = "SELECT * FROM $crea_agent_tabel WHERE `crea_agent_id` = '$listingPropertyListingAgent->ID'"; #$listingAgentQuery = "SELECT * FROM $crea_agent_tabel WHERE `crea_agent_name` = '$listingPropertyListingAgent->Name' and `crea_agent_id` = '$listingPropertyListingAgent->ID'"; $listing_contact_us_agent_email_id[] = $listingPropertyListingAgent->ID; $listingAgentResults = $wpdb->get_results($listingAgentQuery); if( !empty( $listingAgentResults ) && isset( $listingAgentResults ) && $listingAgentResults != '0'){ ?>
photo_url; if(isset( $agent_photo_url ) && !empty( $agent_photo_url ) && $agent_photo_url != "no photo"){ ?>
prefix.'crea_agent'; $getAgentidResults = "SELECT * FROM $post_meta_table WHERE `crea_agent_id`=$listingPropertyListingAgent->ID"; $getAgentidResultsarray = $wpdb->get_results($getAgentidResults); if(isset( $getAgentidResultsarray ) && !empty( $getAgentidResultsarray )) { foreach ( $getAgentidResultsarray as $getAgentidResultEmail ) { $listing_agent_email = $getAgentidResultEmail->crea_agent_email; } } ?>

Name; ?>

Position;?> agentPhones; foreach ( $listingPropertyListingAgentPhones as $listingPropertyListingAgentPhone ) { ?> PhoneNumber; ?>

Company name:

office; ?>
" id="contact_us_agents_mail">

Contact Me

>

mlsID ) ) { $Contact_mlsId = "(MLS®#".$crea_property_detail_page->mlsID.")"; ?>
captcha_code
The property that you are looking for no longer exists."; } } else if ( !empty($listing_type) && $listing_type == 'exclusive' ) { //$listing_post_values = get_post($listing_id); $listing_agent_ids = json_decode( get_post_meta($listing_id, 'listingAgentId', true)); $listing_agent_primary_id = isset( $listing_agent_ids[0] ) ? $listing_agent_ids[0] :''; $crea_listing_ID = $listing_id; $crea_post_title = get_the_title($crea_listing_ID); $content_post = get_post($crea_listing_ID); if (!empty($content_post) && $content_post != '') { $crea_post_content = $content_post->post_content; } $crea_post_content = !empty($crea_post_content) ? $crea_post_content : 'Property content not available.'; $crea_unique_id = get_post_meta($crea_listing_ID, 'uniqueId', true); $crea_unique_id = !empty($crea_unique_id) ? $crea_unique_id : ''; $crea_listingAgentId = get_post_meta($crea_listing_ID, 'listingAgentId', true); $crea_listingAgentId = !empty($crea_listingAgentId) ? $crea_listingAgentId : ''; $crea_listingAddress = get_post_meta($crea_listing_ID, 'listingAddress', true); $crea_listingAddress = !empty($crea_listingAddress) ? $crea_listingAddress : ''; $crea_listingcity = get_post_meta($crea_listing_ID, 'listingcity', true); $crea_listingcity = !empty($crea_listingcity) ? $crea_listingcity : ''; $crea_listingProvince = get_post_meta($crea_listing_ID, 'listingProvince', true); $crea_listingProvince = !empty($crea_listingProvince) ? $crea_listingProvince : ''; $crea_listingAgentStatus = get_post_meta($crea_listing_ID, 'listingAgentStatus', true); $crea_listingAgentStatus = !empty($crea_listingAgentStatus) ? $crea_listingAgentStatus : ''; $crea_listingPrice = get_post_meta($crea_listing_ID, 'listingPrice', true); $crea_listingPrice = !empty($crea_listingPrice) ? $crea_listingPrice : ''; $crea_listingPropertyType = get_post_meta($crea_listing_ID, 'listingPropertyType', true); $crea_listingPropertyType = !empty($crea_listingPropertyType) ? $crea_listingPropertyType : ''; $crea_listingStructureType = get_post_meta($crea_listing_ID, 'listingStructureType', true); $crea_listingStructureType = !empty($crea_listingStructureType) ? $crea_listingStructureType : ''; $crea_listingBedRooms = get_post_meta($crea_listing_ID, 'listingBedRooms', true); $crea_listingBedRooms = !empty($crea_listingBedRooms) ? $crea_listingBedRooms : ''; $crea_listingBathrooms = get_post_meta($crea_listing_ID, 'listingBathrooms', true); $crea_listingBathrooms = !empty($crea_listingBathrooms) ? $crea_listingBathrooms : ''; $crea_listingBathroomsPartial = get_post_meta($crea_listing_ID, 'listingBathroomsPartial', true); $crea_listingBathroomsPartial = !empty($crea_listingBathroomsPartial) ? $crea_listingBathroomsPartial : ''; $crea_listingFinishedBasement = get_post_meta($crea_listing_ID, 'listingFinishedBasement', true); $crea_listingFinishedBasement = !empty($crea_listingFinishedBasement) ? $crea_listingFinishedBasement : ''; $crea_listingParkingSlot = get_post_meta($crea_listing_ID, 'listingParkingSlot', true); $crea_listingParkingSlot = !empty($crea_listingParkingSlot) ? $crea_listingParkingSlot : ''; $crea_listingParkinggarage = get_post_meta($crea_listing_ID, 'listingParkinggarage', true); $crea_listingParkinggarage = !empty($crea_listingParkinggarage) ? $crea_listingParkinggarage : ''; $crea_listingTourUrl = get_post_meta($crea_listing_ID, 'listingTourUrl', true); $crea_listingTourUrl = !empty($crea_listingTourUrl) ? $crea_listingTourUrl : ''; $crea_listingUtilityArr = get_post_meta($crea_listing_ID, 'listingUtilityArr', true); $crea_listingUtilityArr = !empty($crea_listingUtilityArr) ? $crea_listingUtilityArr : ''; $crea_listingFeatureArr = get_post_meta($crea_listing_ID, 'listingFeatureArr', true); $crea_listingFeatureArr = !empty($crea_listingFeatureArr) ? $crea_listingFeatureArr : ''; $crea_listingopenhosedatetimeArr = get_post_meta($crea_listing_ID, 'listingopenhosedatetimeArr', true); $crea_listingopenhosedatetimeArr = !empty($crea_listingopenhosedatetimeArr) ? $crea_listingopenhosedatetimeArr : ''; $crea_listing_type = get_post_meta($crea_listing_ID, 'listing_type', true); $property_lat = get_post_meta($crea_listing_ID,'crea_google_map_latitude',true); $property_long = get_post_meta($crea_listing_ID,'crea_google_map_longitude',true); $crea_listing_images_detail_table_name = $wpdb->prefix . CREA_LISTING_IMAGES_HISTORY; $querySelectFirstImage = "SELECT image_url FROM $crea_listing_images_detail_table_name WHERE unique_id = $crea_listing_ID"; $crea_property_detail_page_images = $wpdb->get_results($querySelectFirstImage); ?>

$

    image_url ) ) { $crea_property_listing_detail_image = $crea_property_detail_page_image->image_url; if(isset( $crea_property_listing_detail_image ) && !empty( $crea_property_listing_detail_image )){ $crea_property_listing_detail_image_url.= $crea_property_listing_detail_image; } else { $crea_property_listing_detail_image_url.=$site_image_path; } } else { $crea_property_listing_detail_image_url.=$site_image_path; } } } else { $crea_property_listing_detail_image_url.=$site_image_path; } if ( $crea_listing_include_print_btn === "Yes") {?>
".$crea_post_content."

"; } ?>
image_url ) ) { $path = $crea_property_detail_page_images[0]->image_url; } else { $path = $site_image_path; } $property_image = $path; $google_map_api_key = get_option('google-map-api-name'); if(!empty( $google_map_api_key ) && $google_map_api_key !=""){ if ( !empty($site_property_url) && !empty($property_lat) && !empty($property_long) ) { if ( $property_lat != '57.678079218156' && $property_long != '-101.8051686875' ) { ?>
Address
  • Street Address :
  • City :
  • Province :
Detail
  • Price :
  • Bedroom :
  • Bathroom :
Feature
status) ){ ?>
WalkScore
prefix.'crea_agent'; $crea_listing_agenIDS = json_decode($crea_listingAgentId); foreach ($crea_listing_agenIDS as $crea_listingAgentKey=>$crea_listingAgentValue ) { $listingAgentQuery = "SELECT * FROM $crea_agent_tabel WHERE `crea_agent_id` = '$crea_listingAgentValue'"; $listingAgentResults = $wpdb->get_results($listingAgentQuery); ?>

crea_agent_name ) ? $listingAgentResults[0]->crea_agent_name :'';?>

Position) ? $listingAgentResults[0]->Position : ''; ?> crea_agent_email ) ? $listingAgentResults[0]->crea_agent_email :'';?> office) && !empty( $listingAgentResults->office ) ){ ?>

Company name:

office; ?>

Contact Me

captcha_code
The property that you are looking for no longer exists."; } get_footer();