ARETK is a CREA DDF® Technology Provider

A CREA (Canadian Real Estate Asscociation) subscription will allow Licenced Canadian REALTORS® to integrate their CREA DDF® (Data Distribution Facility) feed into their ARETK listing displays, including National Shared Pool (across Canada), Board Listings and Personal Listings. These listings will be automatically updated hourly and all listing information is stored on our ARETK server so they do not utilize your website hosting space and you can display listings from across Canada with ease.

Benefits: Website owners (and any agent you choose to include in your Aretk Plugin) receives the inquiries from all listings displayed on your site. That can result in a lot of leads!

Note: National Shared Pool and Board Feeds are subject to Brokerage approval. Ask your Broker of Record to see if your brokerage has opted into the National Shared Pool.

prefix . ARETKCREA_AGENT_TABLE; $getSubscriptionStatus = get_option('crea_subscription_status', true); ?>

prefix . ARETKCREA_USER_LISTING_DETAILS; $sql_select = "SELECT `username`, `ddf_type` FROM `$crea_user_listing_detail_table_name`"; $sql_prep = $wpdb->prepare( $sql_select, NULL ); $resultUsernameSetArr = $wpdb->get_results($sql_prep); $firstUserName = isset($resultUsernameSetArr[0]->username) ? $resultUsernameSetArr[0]->username : ''; $secondUserName = isset($resultUsernameSetArr[1]->username) ? $resultUsernameSetArr[1]->username : ''; $thirdUserName = isset($resultUsernameSetArr[2]->username) ? $resultUsernameSetArr[2]->username : ''; $fourthUserName = isset($resultUsernameSetArr[3]->username) ? $resultUsernameSetArr[3]->username : ''; $fifthUserName = isset($resultUsernameSetArr[4]->username) ? $resultUsernameSetArr[4]->username : ''; $firstUserDdf = isset($resultUsernameSetArr[0]->ddf_type) ? $resultUsernameSetArr[0]->ddf_type : ''; $secondUserDdf = isset($resultUsernameSetArr[1]->ddf_type) ? $resultUsernameSetArr[1]->ddf_type : ''; $thirdUserDdf = isset($resultUsernameSetArr[2]->ddf_type) ? $resultUsernameSetArr[2]->ddf_type : ''; $fourthUserDdf = isset($resultUsernameSetArr[3]->ddf_type) ? $resultUsernameSetArr[3]->ddf_type : ''; $fifthUserDdf = isset($resultUsernameSetArr[4]->ddf_type) ? $resultUsernameSetArr[4]->ddf_type : ''; if ($firstUserName != '') { $firstUserDataSet = get_option('firstUserNameresultSet'); if (!empty($firstUserDataSet) && isset($firstUserDataSet)) { $firstUserNameresultSet = $firstUserDataSet; } else { $firstUserNameresultSet = Aretk_Crea_Admin::aretkcrea_get_user_listing_data_by_username($firstUserName); } $firstUserNameresultSet = json_decode(stripslashes($firstUserNameresultSet)); if (isset($firstUserNameresultSet) && $firstUserNameresultSet != null && $firstUserNameresultSet != '') { if ((int) $firstUserNameresultSet[0]->TotalRecords > 0) { $firstUserNameuser_listing_details_obj_merged = (object) array_merge((array) $firstUserNameresultSet[0], (array) $firstUserNameresultSet[1]); if ($firstUserNameuser_listing_details_obj_merged != '' && isset($firstUserNameuser_listing_details_obj_merged) && $firstUserNameuser_listing_details_obj_merged != null) { $firstTotal = isset($firstUserNameuser_listing_details_obj_merged->ListingsTotal) ? $firstUserNameuser_listing_details_obj_merged->ListingsTotal : '-'; $firstLastUpdate = isset($firstUserNameuser_listing_details_obj_merged->LastUpdated) ? $firstUserNameuser_listing_details_obj_merged->LastUpdated : '-'; $firstStatus = isset($firstUserNameuser_listing_details_obj_merged->status) ? $firstUserNameuser_listing_details_obj_merged->status : '-'; } } else { $firstTotal = isset($firstUserNameresultSet[0]->TotalRecords) ? $firstUserNameresultSet[0]->TotalRecords : '-'; $firstLastUpdate = '-'; $firstStatus = '-'; } } } else { $firstTotal = '-'; $firstLastUpdate = '-'; $firstStatus = '-'; } if ($secondUserName != '') { $secondUserDataSet = get_option('secondUserNameresultSet'); if (!empty($secondUserDataSet) && isset($secondUserDataSet)) { $secondUserNameresultSet = $secondUserDataSet; } else { $secondUserNameresultSet = Aretk_Crea_Admin::aretkcrea_get_user_listing_data_by_username($secondUserName); } $secondUserNameresultSet = json_decode($secondUserNameresultSet); if (isset($secondUserNameresultSet) && $secondUserNameresultSet != null && $secondUserNameresultSet != '') { if ((int) $secondUserNameresultSet[0]->TotalRecords > 0) { $secondUserNameuser_listing_details_obj_merged = (object) array_merge((array) $secondUserNameresultSet[0], (array) $secondUserNameresultSet[1]); if ($secondUserNameuser_listing_details_obj_merged != '' && isset($secondUserNameuser_listing_details_obj_merged) && $secondUserNameuser_listing_details_obj_merged != null) { $secondTotal = isset($secondUserNameuser_listing_details_obj_merged->ListingsTotal) ? $secondUserNameuser_listing_details_obj_merged->ListingsTotal : '-'; $secondLastUpdate = isset($secondUserNameuser_listing_details_obj_merged->LastUpdated) ? $secondUserNameuser_listing_details_obj_merged->LastUpdated : '-'; $secondStatus = isset($secondUserNameuser_listing_details_obj_merged->status) ? $secondUserNameuser_listing_details_obj_merged->status : '-'; } } else { $secondTotal = isset($secondUserNameresultSet[0]->TotalRecords) ? $secondUserNameresultSet[0]->TotalRecords : '-'; $secondLastUpdate = '-'; $secondStatus = '-'; } } } else { $secondTotal = '-'; $secondLastUpdate = '-'; $secondStatus = '-'; } if ($thirdUserName != '') { $thirdUserDataSet = get_option('thirdUserNameresultSet'); if (!empty($thirdUserDataSet) && isset($thirdUserDataSet)) { $thirdUserNameresultSet = $thirdUserDataSet; } else { $thirdUserNameresultSet = Aretk_Crea_Admin::aretkcrea_get_user_listing_data_by_username($thirdUserName); } $thirdUserNameresultSet = json_decode($thirdUserNameresultSet); if (isset($thirdUserNameresultSet) && $thirdUserNameresultSet != null && $thirdUserNameresultSet != '') { if ((int) $thirdUserNameresultSet[0]->TotalRecords > 0) { $thirdUserNameuser_listing_details_obj_merged = (object) array_merge((array) $thirdUserNameresultSet[0], (array) $thirdUserNameresultSet[1]); if ($thirdUserNameuser_listing_details_obj_merged != '' && isset($thirdUserNameuser_listing_details_obj_merged) && $thirdUserNameuser_listing_details_obj_merged != null) { $thirdTotal = isset($thirdUserNameuser_listing_details_obj_merged->ListingsTotal) ? $thirdUserNameuser_listing_details_obj_merged->ListingsTotal : '-'; $thirdLastUpdate = isset($thirdUserNameuser_listing_details_obj_merged->LastUpdated) ? $thirdUserNameuser_listing_details_obj_merged->LastUpdated : '-'; $thirdStatus = isset($thirdUserNameuser_listing_details_obj_merged->status) ? $thirdUserNameuser_listing_details_obj_merged->status : '-'; } } else { $thirdTotal = isset($thirdUserNameresultSet[0]->TotalRecords) ? $thirdUserNameresultSet[0]->TotalRecords : '-'; $thirdLastUpdate = '-'; $thirdStatus = '-'; } } } else { $thirdTotal = '-'; $thirdLastUpdate = '-'; $thirdStatus = '-'; } if ($fourthUserName != '') { $fourthUserDataSet = get_option('fourthUserNameresultSet'); if (!empty($fourthUserDataSet) && isset($fourthUserDataSet)) { $fourthUserNameresultSet = $fourthUserDataSet; } else { $fourthUserNameresultSet = Aretk_Crea_Admin::aretkcrea_get_user_listing_data_by_username($fourthUserName); } $fourthUserNameresultSet = json_decode($fourthUserNameresultSet); if (isset($fourthUserNameresultSet) && $fourthUserNameresultSet != null && $fourthUserNameresultSet != '') { if ((int) $fourthUserNameresultSet[0]->TotalRecords > 0) { $fourthUserNameuser_listing_details_obj_merged = (object) array_merge((array) $fourthUserNameresultSet[0], (array) $fourthUserNameresultSet[1]); if ($fourthUserNameuser_listing_details_obj_merged != '' && isset($fourthUserNameuser_listing_details_obj_merged) && $fourthUserNameuser_listing_details_obj_merged != null) { $fourthTotal = isset($fourthUserNameuser_listing_details_obj_merged->ListingsTotal) ? $fourthUserNameuser_listing_details_obj_merged->ListingsTotal : '-'; $fourthLastUpdate = isset($fourthUserNameuser_listing_details_obj_merged->LastUpdated) ? $fourthUserNameuser_listing_details_obj_merged->LastUpdated : '-'; $fourthStatus = isset($fourthUserNameuser_listing_details_obj_merged->status) ? $fourthUserNameuser_listing_details_obj_merged->status : '-'; } } else { $fourthTotal = isset($fourthUserNameresultSet[0]->TotalRecords) ? $fourthUserNameresultSet[0]->TotalRecords : '-'; $fourthLastUpdate = '-'; $fourthStatus = '-'; } } } else { $fourthTotal = '-'; $fourthLastUpdate = '-'; $fourthStatus = '-'; } if ($fifthUserName != '') { $fifthUserDataSet = get_option('fifthUserNameresultSet'); if (!empty($fifthUserDataSet) && isset($fifthUserDataSet)) { $fifthUserNameresultSet = $fifthUserDataSet; } else { $fifthUserNameresultSet = Aretk_Crea_Admin::aretkcrea_get_user_listing_data_by_username($fifthUserName); } $fifthUserNameresultSet = json_decode($fifthUserNameresultSet); if (isset($fifthUserNameresultSet) && $fifthUserNameresultSet != null && $fifthUserNameresultSet != '') { if ((int) $fifthUserNameresultSet[0]->TotalRecords > 0) { $fifthUserNameuser_listing_details_obj_merged = (object) array_merge((array) $fifthUserNameresultSet[0], (array) $fifthUserNameresultSet[1]); if ($fifthUserNameuser_listing_details_obj_merged != '' && isset($fifthUserNameuser_listing_details_obj_merged) && $fifthUserNameuser_listing_details_obj_merged != null) { $fifthTotal = isset($fifthUserNameuser_listing_details_obj_merged->ListingsTotal) ? $fifthUserNameuser_listing_details_obj_merged->ListingsTotal : '-'; $fifthLastUpdate = isset($fifthUserNameuser_listing_details_obj_merged->LastUpdated) ? $fifthUserNameuser_listing_details_obj_merged->LastUpdated : '-'; $fifthStatus = isset($fifthUserNameuser_listing_details_obj_merged->status) ? $fifthUserNameuser_listing_details_obj_merged->status : '-'; } } else { $fifthTotal = isset($fifthUserNameresultSet[0]->TotalRecords) ? $fifthUserNameresultSet[0]->TotalRecords : '-'; $fifthLastUpdate = '-'; $fithStatus = '-'; } } } else { $fifthTotal = '-'; $fifthLastUpdate = '-'; $fithStatus = '-'; } ?>
1
2
3
4
5

photo

photo

photo

photo photo

photo

photo

photo

photo photo

photo

prepare( $sql_select, NULL ); $get_agents_results = $wpdb->get_results($sql_prep); if (!empty($get_agents_results) && $get_agents_results != '') { $counter = 0; foreach ($get_agents_results as $get_agents_key => $get_agents_value) { $counter = $counter + 1; ?>

crea_agent_name; ?>

crea_agent_id; ?>

crea_agent_email; ?>

crea_agent_modified_date; ?>

 edit delete
- - - - - -

photo

photo

photo

DISCLAIMERS

The following disclaimer is required to be displayed either in your footer and/or on the property detail pages. This plugin will automatically place this disclaimer in the bottom of the property detail pages. If you would like to have this disclaimer in your theme footer, you will need to manually add it.

Use the inline dropdown boxes to modify the disclaimer to best fit your needs.

licensed to trade in real estate in . The out of province listing content on this website is not intended to solicit a trade in real estate. Any consumers interested in out of province listings must contact a person who is licensed to trade in real estate in that province.

Disclaimer Updated
prefix . ARETKCREA_USER_LISTING_DETAILS; $propertyListId = NULL; if ( isset($_GET['id']) && is_numeric($_GET['id']) ){ $propertyListId = (int) $_GET['id']; } if( $getSubscriptionStatus === 'valid' && !empty($propertyListId) ){ $sql_select = "SELECT `username` FROM `$crea_user_name_table_name`"; $sql_prep = $wpdb->prepare( $sql_select, NULL ); $getAllUsername = $wpdb->get_results($sql_prep); $userNameList = ''; if (isset($getAllUsername) && !empty($getAllUsername)) { foreach ($getAllUsername as $singleUsername) { $userName = $singleUsername->username; if ( !empty( $userName ) ){ $userNameList.=$userName.','; } unset($singleUsername); } unset($getAllUsername); $userNameList = rtrim($userNameList,','); $filter_array['property_ids'] = $propertyListId; $filter_array['result_type'] = 'full'; $filter_array['crea_feed_id'] = $userNameList; $listings = Aretk_Crea_Public::aretk_get_listings_subsc($subscriptionKey, $filter_array); if ( isset($listings) && !empty($listings)) { $allListingArr = (array)$listings['listing_data'][$propertyListId]; } $prop_lat = NULL; $prop_lon = NULL; $prop_heading = '270'; $prop_pitch = '0'; $prop_zoom = '1'; if (!empty($allListingArr['geocoded_latitude'])){ $prop_lat = $allListingArr['geocoded_latitude']; } if (!empty($allListingArr['geocoded_longitude'])){ $prop_lon = $allListingArr['geocoded_longitude']; } if ( !empty($prop_lat) && !empty($prop_lon) ){ $prop_latlng = '('. $prop_lat .', '. $prop_lon .')'; } else { $prop_latlng = NULL; } if (is_numeric($allListingArr['geocoded_pov_heading'])){ $prop_heading = $allListingArr['geocoded_pov_heading']; } if (is_numeric($allListingArr['geocoded_pov_pitch'])){ $prop_pitch = $allListingArr['geocoded_pov_pitch']; } if (is_numeric($allListingArr['geocoded_pov_zoom'])){ $prop_zoom = $allListingArr['geocoded_pov_zoom']; } } } ?>

<?php echo $allListingArr['generated_address']; ?>

Loading..
Loading..

prefix . ARETKCREA_AGENT_TABLE; ?>

Below will list all your exclusive listings that have been manually entered. To add listings, click the 'Add New Listing' button.

If the CREA ADD-ON is active, in addition to any exclusive listings, the listings below will include any listings from the CREA data feeds that are associated with the CREA AGENT IDs entered under Step 2 in the CREA DDF® SETTINGS page.

prepare( $sql_select, NULL ); $get_total_recods = $wpdb->get_results($sql_prep); $record_count = $get_total_recods[0]->count; if ($record_count >= 1) { ?>
prefix . ARETKCREA_USER_LISTING_DETAILS; $sql_select = "SELECT `username` FROM `$crea_user_name_table_name`"; $sql_prep = $wpdb->prepare( $sql_select, NULL ); $getAllUsername = $wpdb->get_results($sql_prep); $allListingArr = array(); //get all agent ids from database $crea_agent_table_name = $wpdb->prefix . ARETKCREA_AGENT_TABLE; $sql_select = "SELECT `crea_agent_id` FROM `$crea_agent_table_name`"; $sql_prep = $wpdb->prepare( $sql_select, NULL ); $getAllAgentIds = $wpdb->get_results($sql_prep); $getAllAgentIdArray = array(); if ( isset($getAllAgentIds) && !empty($getAllAgentIds) ){ foreach ($getAllAgentIds as $agent_key => $agent ) { $getAllAgentIdArray[] = $agent->crea_agent_id; } } if ( isset($getAllAgentIdArray) && !empty($getAllAgentIdArray)) { $agent_ids = implode(',',$getAllAgentIdArray); } else { $agent_ids = null; } $allListingArr = array(); $userNameList = ''; if (isset($getAllUsername) && !empty($getAllUsername)) { foreach ($getAllUsername as $singleUsername) { $userName = $singleUsername->username; if ( !empty( $userName ) ){ $userNameList.=$userName.','; } unset($singleUsername); } unset($getAllUsername); $userNameList = rtrim($userNameList,','); $result_type = 'basic'; if ( $agent_ids != null ){ $listings = Aretk_Crea_Admin::aretkcrea_get_listing_records_based_on_agents($userNameList, $result_type,$agent_ids); if ( isset($listings) && !empty($listings)) { foreach ($listings as $listing_key => $listing ){ if ( !isset( $listing->TotalRecords ) && empty( $listing->TotalRecords ) ) { $allListingArr[$listing->mlsID] = $listing; } } } } } $args = array( 'posts_per_page' => -1, 'post_type' => 'aretk_listing', 'post_status' => 'publish' ); $posts_array = (array) get_posts($args); $exclusiveArr = array(); foreach ($posts_array as $singlePost) { $singlePost1 = (array) $singlePost; $singlePost2 = (object) $singlePost1; $exclusiveArr[] = $singlePost2; } $allListingFinalArr = array_merge($allListingArr, $exclusiveArr); } else { //For Exclusive listing $args = array( 'posts_per_page' => -1, 'post_type' => 'aretk_listing', 'post_status' => 'publish' ); $posts_array = (array) get_posts($args); $exclusiveArr = array(); foreach ($posts_array as $singlePost) { $singlePost1 = (array) $singlePost; $singlePost2 = (object) $singlePost1; $exclusiveArr[] = $singlePost2; } $allListingFinalArr = $exclusiveArr; } $listings_counter = 1; foreach ($allListingFinalArr as $singleListing) { if (isset($singleListing->post_author) && !empty($singleListing->post_author)) { $ListingAddress = get_post_meta($singleListing->ID, 'listingAddress', true); $ListingCity = get_post_meta($singleListing->ID, 'listingcity', true); $ListingPrice = get_post_meta($singleListing->ID, 'listingPrice', true); $date = date('d-m-Y', strtotime($singleListing->post_date)); $crea_listing_images_detail_table_name = $wpdb->prefix . ARETKCREA_LISTING_IMAGES_HISTORY; $sql_select = "SELECT `image_url` FROM `$crea_listing_images_detail_table_name` WHERE `image_position`=1 AND `unique_id`=%d"; $sql_prep = $wpdb->prepare( $sql_select, $singleListing->ID ); $resultSet = $wpdb->get_results($sql_prep); if (isset($resultSet) && !empty($resultSet)) { $path = $resultSet[0]->image_url; } else { $path = ARETK_CREA_PLUGIN_URL.'admin/images/dummy_image.png'; } $listingpagecount = 0; $getSubscriptionStatus = get_option('crea_subscription_status', ''); $listingpageval = get_post_meta($singleListing->ID,'crea_aretk_db_listing_page_count',true); if( !empty( $listingpageval ) && $listingpageval !='' ) { $listingpagecount = $listingpageval; } else { $listingpagecount = 0; } $agentArrDecoded = get_post_meta($singleListing->ID,'listingAgentId',true); $agentArr = json_decode($agentArrDecoded); $htmlAgent = ''; if (isset($agentArr) && !empty($agentArr)) { $htmlAgent = ''; foreach ($agentArr as $singleAgent) { $crea_agent_table_name = $wpdb->prefix.ARETKCREA_AGENT_TABLE; $sql_select = "SELECT `crea_agent_name` FROM `$crea_agent_table_name` WHERE `crea_agent_id`= %s"; $sql_prep = $wpdb->prepare( $sql_select, $singleAgent ); $resultAgentArr = $wpdb->get_results($sql_prep); if ( isset($resultAgentArr) && !empty($resultAgentArr) ){ $htmlAgent .= $resultAgentArr[0]->crea_agent_name . ', '; } } } ?> listing_agents as $singleAgent) { $htmlAgent .= $singleAgent->Name . ', '; } if (is_object ($singleListing->listing_photos) ){ if ($singleListing->listing_photos->URL == '' || $singleListing->listing_photos->URL == null) { $apiListingImageURL = ARETK_CREA_PLUGIN_URL.'admin/images/dummy_image.png'; } else { $apiListingImageURL = $singleListing->listing_photos->URL; } } else if (is_object ($singleListing->listing_photos[0])) { if ($singleListing->listing_photos[0]->URL == '' || $singleListing->listing_photos[0]->URL == null) { $apiListingImageURL = ARETK_CREA_PLUGIN_URL.'admin/images/dummy_image.png'; } else { $apiListingImageURL = $singleListing->listing_photos[0]->URL; } } else { $apiListingImageURL = ARETK_CREA_PLUGIN_URL.'admin/images/dummy_image.png'; } $mlsId = isset($singleListing->mlsID) ? $singleListing->mlsID : '-'; $dates = isset($singleListing->ListingContractDate) ? $singleListing->ListingContractDate : '-'; $listingpagecount = isset( $singleListing->ViewCount ) ? $singleListing->ViewCount : 0; ?>
<?php echo $listings_counter; ?> Exclusive
Edit | Trash		 $
<?php echo $listings_counter; ?>
StreetAddress ; ?> City; ?> $Price; ?>
prefix . ARETKCREA_AGENT_TABLE; ?>
post_content; } $crea_unique_id = get_post_meta($crea_listing_ID, 'uniqueId', true); $crea_listingAgentId = get_post_meta($crea_listing_ID, 'listingAgentId', true); $crea_listingAddress = get_post_meta($crea_listing_ID, 'listingAddress', true); $crea_listingcity = get_post_meta($crea_listing_ID, 'listingcity', true); $crea_listingProvince = get_post_meta($crea_listing_ID, 'listingProvince', true); $crea_listingAgentStatus = get_post_meta($crea_listing_ID, 'listingAgentStatus', true); $crea_listingPrice = get_post_meta($crea_listing_ID, 'listingPrice', true); $crea_listingPropertyType = get_post_meta($crea_listing_ID, 'listingPropertyType', true); $crea_listingStructureType = get_post_meta($crea_listing_ID, 'listingStructureType', true); $crea_listingBedRooms = get_post_meta($crea_listing_ID, 'listingBedRooms', true); $crea_listingBathrooms = get_post_meta($crea_listing_ID, 'listingBathrooms', true); $crea_listingBathroomsPartial = get_post_meta($crea_listing_ID, 'listingBathroomsPartial', true); $crea_listingFinishedBasement = get_post_meta($crea_listing_ID, 'listingFinishedBasement', true); $crea_listingParkingSlot = get_post_meta($crea_listing_ID, 'listingParkingSlot', true); $crea_listingParkinggarage = get_post_meta($crea_listing_ID, 'listingParkinggarage', true); $crea_listingTourUrl = get_post_meta($crea_listing_ID, 'listingTourUrl', true); $crea_listingUtilityArr = get_post_meta($crea_listing_ID, 'listingUtilityArr', true); $crea_listingFeatureArr = get_post_meta($crea_listing_ID, 'listingFeatureArr', true); $crea_listingopenhosedatetimeArr = get_post_meta($crea_listing_ID, 'listingopenhosedatetimeArr', true); $crea_listing_type = get_post_meta($crea_listing_ID, 'listing_type', true); $crea_listingAgentId_decode = json_decode($crea_listingAgentId); ?>

$crea_listingAgentId_value) { $key_ids = ''; if ($crea_listingAgentId_key == 0) { $key_ids = ''; } else { $key_ids = $crea_listingAgentId_key; } ?>
delete delete
delete delete
delete delete
"No Commas or Spaces"
$crea_utility_array_val) { ?>
delete
delete
delete
$crea_feature_array_val) { ?>
delete
delete
delete
prefix . ARETKCREA_LISTING_IMAGES_HISTORY; $unique_id = (int) $crea_listing_ID; $sql_select = "SELECT * FROM `$crea_listing_images_detail_table_name` WHERE `unique_id` = %d ORDER BY `image_position` ASC"; $sql_prep = $wpdb->prepare( $sql_select, $unique_id ); $imageSet = $wpdb->get_results($sql_prep); if (isset($imageSet) && !empty($imageSet)) { ?>
reorder photos
prefix.ARETKCREA_LISTING_DOCUMENT_HISTORY; $unique_id = (int) $crea_listing_ID; $sql_select = "SELECT * FROM `$crea_listing_document_detail_table_name` WHERE `unique_id` = %d ORDER BY `ID` ASC"; $sql_prep = $wpdb->prepare( $sql_select, $unique_id ); $documentSet = $wpdb->get_results($sql_prep); foreach ($documentSet as $document) { ?>
Delete Document Document Icon

document_name; ?>

A maximum of 10 files can be added at a time

Only allowed .png, .jpg, .jpeg, .doc, .docx, .csv, .pdf and .txt

File Size Limit 5MB Per Document.

$crea_listing_date_time_value) { $crea_op_date = $crea_listing_date_time_value->date; $crea_op_start_time = $crea_listing_date_time_value->start_time; $crea_op_end_time = $crea_listing_date_time_value->end_time; ?>
delete
delete

SHOWCASES

Default 'Listings' Showcase
This ARETK plugin automatically creates a Default Listing page which you can copy and paste the shortcode into any of your WordPress pages. This showcase by default shows the listings by 'List View' and pulls listings from your exclusive listings (as well as CREA listings from the first Datafeed entered if you have subscribed to the CREA Add-On). You can simply use this Default Listing Showcase as it is and/or you can create additional new listing showcases (by clicking ADD NEW SHOWCASE button above). You have the option of 5 different listing displays (List, Grid, Carousel, Single Slider or Map View), various setting options and colour options. Once the new showcase has been done, a new shortcode will be created and you can copy and paste this new shortcode into any of your WordPress web pages.

Default 'Listing Details' Showcase
This 'listing details' showcase is a single listing page. A Page in your WordPress site will be automatically created when this plugin is installed. This page shows when you click on any particular listing from any of your listing showcases with the particulars of that listing. You can edit the Default 'Listing Details' showcase by clicking the edit button to the right of the shortcode, but you cannot delete the 'Listing Details' Showcase or create additional 'Listing Detail' Showcases.

Default - listings Search Showcase
The Default 'Search' Showcase can be edited and you can copy and paste the shortcode for this Search Box into any of your WordPress pages. By default this Search Box searches the Default 'Listings' Showcase and will post to this page. You can edit which Showcase the search box searches and how the results are displayed by selecting a different showcase under the settings tab when editing the Default 'Search' Showcase. You need to create the alternate listing showcase prior to changing this setting.

'aretk_showcase', 'post_status' => 'publish', 'orderby' => 'date', 'posts_per_page' => -1, 'order' => 'ASC' ); $showcase_array = get_posts( $get_aretk_showcase_args ); $showcase_counter = 4; foreach ( $showcase_array as $showcase_array_key=>$showcase_array_value ) { $get_showcase_category = get_the_terms( $showcase_array_value->ID, 'listing-showcase' ); ?>
No TITLE DATE SHOWCASE TYPE SHORT CODE ACTION
1 Default - Listings Showcase - Listings Showcase [ARTEK-DLS] -
2 Default - Listing Details Showcase - Listing Details Showcase - edit
3 Default - Listings Search Showcase - Search Showcase [ARETK-DSS] edit
post_title; ?> post_date; ?> $get_showcase_category_value ) { echo "Listings Showcase"; } } ?> ID,"showcse_crea_save_short_code",true)); ?> edit edit

*/ ?>

value="yes">Include the Exclusive Listing

photo checked value="Listing View" class ='search_crea_display_theme_option'>List
photo checked value="Grid View" class ='search_crea_display_theme_option'>Grid
photo checked value="Carousel" class ='search_crea_display_theme_option' >Carousel
photo checked value="Map" class ='search_crea_display_theme_option' >Map
photo checked value="Slider" class ='search_crea_display_theme_option' >Slider
photo List
photo Grid
photo Carousel

photo Map
photo Slider

Only show listings added in the last

Days

Only show listings with an upcoming open house checked value="yes" value="no" name="crea_checkbox_open_house_filter" type="checkbox">


     




prefix . ARETKCREA_AGENT_TABLE; $sql_select = "SELECT `crea_id`, `crea_agent_name`, `crea_agent_id`, `crea_agent_email`, `crea_agent_modified_date` FROM `$crea_agent_table_name` ORDER BY `crea_agent_name` ASC"; $sql_prep = $wpdb->prepare( $sql_select, NULL ); $get_agents_results = $wpdb->get_results($sql_prep); if (!empty($get_agents_results) && $get_agents_results != '') { ?>


Filter by Map Radius

Use this section to filter out listings within a specific radius.

Drag the red marker on the map below to the desired location and select a radius. If no radius is set, then all listings will be returned from the selected feed.

Filter Radius KM

Filter by Board

[ ]

Leave blank to display all listings belonging to the selected feed(s).

*/ ?>

Text color
Address Text Colours
Price Text Colours
Status Text Color
Open House Background Colour
Open House Text Colour

Below is your short code for this showcase, copy and paste it into any page on this website

Include Agent Information checked="checked" type="radio" name="include_information" value="Yes">Yes checked="checked" value="No">No
Include Contact Form checked value="Yes">Yes checked value="No">No
Include Map checked value="Yes">Yes checked value="No">No["Include Google map key in plugin settings"]
Include Walk Score checked value="Yes">Yes checked value="No">No["Include walkscore key in plugin settings"]
Include Print Button checked value="Yes">Yes checked value="No">No
Include Email Address of Agent checked type="radio" name="include_email_address_of_agent" value="Yes">Yes checked value="No">No

Send Button Background Colour
Send Button Text Colour

">
" >
">
">
">
">
">
">
">

checked value="yes">Yes checked value="no">No
checked value="yes">Yes checked value="no">No

value="yes" />Include the Exclusive Listing

type="radio" name="aretkcrea_showcase_search_advancefilterclosed" value="yes" />Yes     type="radio" name="aretkcrea_showcase_search_advancefilterclosed" value="no" />No

/>Status

/>Bedrooms

/>Bathrooms

/>Property Type

Default 10,000,000

'. __('LEADS', ARETKCREA_PLUGIN_SLUG) .''; echo ''; exit; } /** * @return redirect to aretk Lead Categories. * @package Phase 1 * @since Phase 1 * @version * @author Aretk Inc. * @param null */ function aretkcrea_custom_create_new_lead_category_html(){ $url = admin_url() . 'edit-tags.php?taxonomy=lead-category'; echo '

'. __('LEAD CATEGORIES', ARETKCREA_PLUGIN_SLUG) .'

'; echo ''; exit; } /** * create function for aretkcrea_custom_lead_form_listing * * @return return html for the CREA Lead Form listing * @package Phase 1 * @since Phase 1 * @version * @author Aretk Inc. * @param null */ function aretkcrea_custom_lead_form_listing() {?>

01 01-01-2016 [ARTEK-BF]
02 01-01-2016 [ARTEK-SF]
03 01-01-2016 [ARTEK-CF]
prefix . ARETKCREA_AGENT_TABLE; ?>
post_content; } /** * record unserialize */ $crea_lead_phone_no_unserialize = maybe_unserialize($crea_lead_phone_no); $crea_lead_phone_email_unserialize = maybe_unserialize($crea_lead_phone_email); $crea_agent_social_type_unserialize = maybe_unserialize($crea_agent_social_type); ?>

">
false, 'orderby' => 'name', 'order' => 'ASC', 'post_per_page' => -1 ); $tax_terms = get_terms($taxonomy,$term_args); ?>
*
Category
$crea_lead_phone_value) { $phone_counter = ''; if ($crea_lead_phone_key == 0) { $phone_counter = ''; } else { $phone_counter = $crea_lead_phone_key; } ?>

delete

delete

delete

delete

*
$crea_lead_phone_email_value) { ?>

class ="create-new-lead-phone-no-list primery_mail_check" id="create_new_lead_primart_mail" value="">Make Primary Email delete

checked value="" class ="create-new-lead-phone-no-list primery_mail_check" id="create_new_lead_primart_mail">Make Primary Email delete

Make Primary Email delete

Make Primary Email delete

$crea_agent_social_type_value) { ?>

prefix.'postmeta'; $sql_select = "SELECT `meta_id`, `meta_key`, `meta_value` FROM `$post_meta_table` WHERE `meta_key` LIKE 'crea_lead_corrsponding_text%' AND `post_id` = %d ORDER BY `meta_id` DESC"; $sql_prep = $wpdb->prepare( $sql_select, $crea_lead_ID, NULL ); $get_lead_corrsponding_ids_count = $wpdb->get_results($sql_prep); if( !empty($get_lead_corrsponding_ids_count) && $get_lead_corrsponding_ids_count != '' ) { ?>
Correspondence History
$get_lead_corrsponding_ids_value ) { $corrsponding_messages = $get_lead_corrsponding_ids_value->meta_value; $corrsponding_messages = json_decode($corrsponding_messages); if( is_array($corrsponding_messages) ) { $corrsponding_message = $corrsponding_messages[1]; $correspondace_date = $corrsponding_messages[2]; $corrsponding_subject = $corrsponding_messages[3]; $corrsponding_type = $corrsponding_messages[4]; } else { $corrsponding_message = $corrsponding_messages; $correspondace_date = ''; $corrsponding_subject = ''; $corrsponding_type = ''; } ?>
delete
Subject:
[ view ]
Add Reminder
prefix.ARETKCREA_LEAD_REMINDER_HISTORY; $sql_select = "SELECT * FROM `$reminderTableName` WHERE `reminder_lead_id` = %d ORDER BY `id` ASC"; $sql_prep = $wpdb->prepare( $sql_select, $crea_lead_ID ); $getReminderResults = $wpdb->get_results($sql_prep); if ( !empty( $getReminderResults) && $getReminderResults !='' ) { $reminderCounter = 1; foreach ( $getReminderResults as $getReminderResultsValue ) { ?>

Email - The address of the person receiving the reminder

Email*

Subject*

Comment

Date and Time*

Repeat

 reminder_repeat) && $getReminderResultsValue->reminder_repeat=="no-repeat") echo "checked";?> value="no-repeat">No Repeat
reminder_repeat) && $getReminderResultsValue->reminder_repeat=="daily") echo "checked";?> value="daily">Daily
reminder_repeat) && $getReminderResultsValue->reminder_repeat=="weekly") echo "checked";?> value="weekly">Weekly
reminder_repeat) && $getReminderResultsValue->reminder_repeat=="monthly") echo "checked";?> value="monthly">Monthly
reminder_repeat) && $getReminderResultsValue->reminder_repeat=="yearly") echo "checked";?> value="yearly">Yearly
Update Remove Reminder
Note: email delivery times are approximate
$all_lead_primary_email_value ) { if( $all_lead_primary_email_value != "" && !empty($all_lead_primary_email_value)) { $all_bcc_email[$all_lead_primary_email_key] = $all_lead_primary_email_value; } } $lead_unserialize_array = array(); $lead_unserialize_array_value = array(); foreach ( $all_lead_first_email as $all_lead_first_email_key=>$all_lead_first_email_value ){ $lead_unserialize_array = maybe_unserialize($all_lead_first_email_value); if( is_array($lead_unserialize_array)) { $lead_unserialize_array_value[$all_lead_first_email_key] = $lead_unserialize_array[0]; } else{ $lead_unserialize_array_value[$all_lead_first_email_key] = $lead_unserialize_array; } } $merge_email_array_duplicate = $all_bcc_email + $lead_unserialize_array_value; $store_email_lead_ids = array(); foreach ( $merge_email_array_duplicate as $merge_email_array_duplicate_key =>$merge_email_array_duplicate_value ) { $store_email_lead_ids[$merge_email_array_duplicate_key] = $merge_email_array_duplicate_value; $lead_ids .= $merge_email_array_duplicate_key .','; } $lead_ids = rtrim($lead_ids, ','); $add_multiple_email_lead_ids = $store_email_lead_ids; if( $add_multiple_email_lead_ids != '' && !empty($add_multiple_email_lead_ids) ) { update_option('crea_bulk_email_lead_ids', json_encode( $add_multiple_email_lead_ids )); } $all_selected_mail_bcc = implode(",", $merge_email_array_duplicate); } elseif (!empty($lead_ids) && is_numeric($lead_ids)){ $lead_name = get_the_title($lead_ids); $all_lead_primay_email = get_post_meta($lead_ids, 'lead_primary_email', true); if( $all_lead_primay_email == "" ) { $all_lead_first_email = maybe_unserialize( get_post_meta($lead_ids,'lead_phone_email',true) ); $selected_mail_to = $all_lead_first_email[0]; } else { $selected_mail_to = $all_lead_primay_email; } $add_single_array[$lead_ids] = $selected_mail_to; update_option('crea_bulk_email_lead_ids', json_encode( $add_single_array) ); } else { update_option('crea_bulk_email_lead_ids', '' ); } $admin_email_address = get_option('admin_email'); ?>
">

Subject*

To

Body*

200, 'textarea_name' => 'crea_email_body_content', 'quicktags' => false, 'media_buttons' => false, 'wpautop' => false)); ?>

'; } ?>

Yes, absolutly. The CREA DDF® add-on is needed if you are a Canadaian REALTOR® and would to automatically sync the CREA DDF® listings within your website. Without this add-on you will need to manually add your listings under the 'Listings' tab and click on ADD NEW LISTING.

Under the Subscription Tab, click on GET API KEY. This will bring you to www.aretk.com where you will sign up for a subscription for your website. Each API Key is only valid for 1 primary domain name. If you have multiple websites, then you will need to purchase an API key for each website. Once you receive your API key, copy and paste it into your Aretk Plugin under the Subscription tab.

An Aretk Subscription is $25/month. This is purchased on a month to month basis and can be cancelled anytime.

Yes, once you cancel the Aretk Subscription, the CREA listings will no longer be viewed on your website. But you can continue to use your Aretk Plugin and all the listings showcases with your own manually entered Listings as well as continue to use the Contact Management System and all the Contact Forms.

Go to the Showcase Tab and click on the Edit button (pencil) beside the default listing showcase. This will bring you to the Feeds page where you can select which feed you want to use as well if you want to include your Exclusive listings along with the feed. Then click on the Display button and you can select a List View, Grid View, Carousel View, Map View or Slider. You can filter based the location or show only new listings or open houses. Under the Settings Tab you can choose to add a Search Bar or not as well as other setting options. Lastly is the Colours tab where you can make some changes to the colours displayed. Save the changes, they will automatically be reflected in the listings default wordpress page created by your plugin.

To create additional show cases, click on "Add New Showcase" on the top left hand corner of the Showcases tab. Select the DDF® feed you would like to use for this showcase and select whether you want to include your manually entered exclusive listings within this showcase. Select one of the 5 different showcases available, LIST, GRID,, CAROUSEL, MAP and SLIDERS. You can also filter by area, newest listings and/or only to display Open Houses. Once the settings and colours have been selected, Save the new Showcase. This new showcase will now be listed in your Showcase Tab. You can then copy and paste the shortcode into any Wordpress page.

Go to the Showcase page and Edit button (pencil) beside the Listings Details Showcase. There you can update the colours and settings such as including agent information, contact form, Google map, Walk Score, print button, and email address and Save. This will automatically be reflected in the Listing Details Page created by the plugin within your WordPress website.

In the Showcase tab, there is a Default Search Showcase, you can copy and paste this short-code into any Wordpress Website.

Create a NEW Listing Showcase and choose the feed you want to use as well as any of the filters/settings. Then edit the Default Search Showcase tab and under the settings tab you can select from all the showcase you have created and you can pick from them which you would like to search and post the results to. By default, the Search Showcase will search the first data feed in your plugin and your Exclusive Listings and will display in the default Listing Showcase (Grid Layout). If you do not have an active Aretk CREA DDF® Subscription, this search box will only search your exclusive listings.

Go to the Listings tab in your Aretk Plugin. If you have activated your Aretk CREA DDF® subscription then all the listings displayed will be associated to the Agent ID that you have entered in the CREA DDF® SETTINGS Tab. You can click on "Add new Listing" on the top right corner to add Exclusive Listings. If you have not activated your Aretk CREA DDF® subscription, there will be no listings displayed until you manually enter your own listings by clicking "Add New Listing".

You can only edit the manually entered exclusive listings. You can not edit any of the listings have been downloaded from CREA. If any of these listings are displaying incorrect information, it could be because it hasn`t been updated yet (can take up to 24 hours to update changes made with your board) or you need to make those updates with your board so your website and www.realtor.ca receive the updates.

Under the Leads tab there is a subtab called "Leads Form". This shows 3 pre-created forms for you to use in your website, CONTACT FORM, BUYER FORM and SELLER FORM. These three forms have short-codes that you can copy and paste into any WordPress page. All leads received from these forms will be captured in your LEADS section of your Aretk Plugin. An email will also be sent to is the email address listed in the WordPress settings page of your WordPress Dashboard.

In your Outlook, you can export your contacts into either a "comma separated values" or csv format. Save this file onto your computer and then in your plugin in the LEADS tab, click on "Import Leads" and upload this CVS file you have saved.

Walk Score gives each property a rating as to how walkable it is to the nearest ammentities. If you want your real estate listings to display a walk score, you need to get a Walk Score widget API key and enter it into your ARETK plugin settings. To get your Walk Score API key go to this website - https://www.walkscore.com/professional/sign-up.php and sign up - it's free! Once you have signed up with Walk Score they will email you an API key which you will need to copy and paste it into your ARETK plugin under settings.

The Google Maps API key allows you to display Google Maps within your website. To get a Google Maps API key, go to this site - https://developers.google.com/maps/web/ and click on "GET A KEY". If you are not already logged into Google you will be required to at this point. Once logged in select "create a new project" and give your project a name, like "Website Gmap API" and then click the button labeled ""CREATE AND ENABLE API" to continue. You will get an API Key, copy and paste this API key into your ARETK plugin settings. Note: to improve your API key security, restrict this key's usage in the API Console - click the link to access the API console. Under key restrictions select "HTTP referrers" and then add your websites domain name in the feild provided and then save your changes. This extra step will prevent others from using you API key.

photo

photo

photo

photo photo

photo

photo

photo

photo photo

photo

photo

photo

photo

Sample CSV file for Add Leads




Click here to sign up for a Walk Score API Key



Click here to sign up for a Google Map API Key
/>





Click here to sign up for Google's reCAPTCHA