Warning (2): Undefined property: MobileComponent::$isIphone [APP/controllers/components/mobile.php, line 79]Code        } else {
            foreach ($this->devices as $device => $regexp) {
                if ($this->isDevice($device)) {
MobileComponent::isDevice() - APP/controllers/components/mobile.php, line 79
MobileComponent::__construct() - APP/controllers/components/mobile.php, line 43
Component::_loadComponents() - CORE/cake/libs/controller/component.php, line 252
Component::init() - CORE/cake/libs/controller/component.php, line 78
Controller::constructClasses() - CORE/cake/libs/controller/controller.php, line 482
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 186
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 84

Warning (512): logger class DebugKitLogListener does not implement a write method. [CORE/cake/libs/cake_log.php, line 137]Code        }
        if (!is_callable(array($loggerName, 'write'))) {
            trigger_error(
Debugger::handleError() - CORE/cake/libs/debugger.php, line 306
CakeLog::_getLogger() - CORE/cake/libs/cake_log.php, line 137
CakeLog::config() - CORE/cake/libs/cake_log.php, line 105
LogPanel::__construct() - APP/plugins/debug_kit/controllers/components/toolbar.php, line 653
ToolbarComponent::_loadPanels() - APP/plugins/debug_kit/controllers/components/toolbar.php, line 289
ToolbarComponent::initialize() - APP/plugins/debug_kit/controllers/components/toolbar.php, line 121
Component::initialize() - CORE/cake/libs/controller/component.php, line 98
Controller::startupProcess() - CORE/cake/libs/controller/controller.php, line 520
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 187
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 84

Warning (2): Undefined variable $order [APP/controllers/sites_controller.php, line 1974]Code
            $temp    = array();
            foreach ($order as $k => $v) {
Debugger::handleError() - CORE/cake/libs/debugger.php, line 306
SitesController::display() - APP/controllers/sites_controller.php, line 1974
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 84

Warning (2): foreach() argument must be of type array|object, null given [APP/controllers/sites_controller.php, line 1974]Code
            $temp    = array();
            foreach ($order as $k => $v) {
Debugger::handleError() - CORE/cake/libs/debugger.php, line 306
SitesController::display() - APP/controllers/sites_controller.php, line 1974
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 84

Warning (2): Undefined property: LogPanel::$logger [APP/plugins/debug_kit/controllers/components/toolbar.php, line 665]Code **/
    function beforeRender(&$controller) {
        $logs = $this->logger->logs;
Debugger::handleError() - CORE/cake/libs/debugger.php, line 306
LogPanel::beforeRender() - APP/plugins/debug_kit/controllers/components/toolbar.php, line 665
ToolbarComponent::_gatherVars() - APP/plugins/debug_kit/controllers/components/toolbar.php, line 262
ToolbarComponent::beforeRender() - APP/plugins/debug_kit/controllers/components/toolbar.php, line 210
Component::triggerCallback() - CORE/cake/libs/controller/component.php, line 188
Controller::render() - CORE/cake/libs/controller/controller.php, line 863
SitesController::display() - APP/controllers/sites_controller.php, line 2086
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 84

Warning (2): Attempt to read property "logs" on null [APP/plugins/debug_kit/controllers/components/toolbar.php, line 665]Code **/
    function beforeRender(&$controller) {
        $logs = $this->logger->logs;
Debugger::handleError() - CORE/cake/libs/debugger.php, line 306
LogPanel::beforeRender() - APP/plugins/debug_kit/controllers/components/toolbar.php, line 665
ToolbarComponent::_gatherVars() - APP/plugins/debug_kit/controllers/components/toolbar.php, line 262
ToolbarComponent::beforeRender() - APP/plugins/debug_kit/controllers/components/toolbar.php, line 210
Component::triggerCallback() - CORE/cake/libs/controller/component.php, line 188
Controller::render() - CORE/cake/libs/controller/controller.php, line 863
SitesController::display() - APP/controllers/sites_controller.php, line 2086
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 84

Fraser Valley Real Estate :: Gelderman.ca Real Estate Team

Jonathan Gelderman
Personal Real Estate Corporation

Main Office: 604-743-SOLD (7653) Chilliwack Office: 604-791- SOLD (7653)

« prev next »

New Listing Alert!

MLS® Home Search

Free Online Evaluation

Fraser Valley Real Estate

Welcome to the Fraser Valley’s most comprehensive Real Estate website!

Our unique client based approach to real estate ensures that our listings are the best marketed and our clients the best serviced in the Fraser Valley! Real Estate Agent Jonathan Gelderman, Personal Real Estate Corporation and the Gelderman.ca Real Estate Team are one of the Fraser Valley’s top producing teams, selling residential, commercial, multi-family, and investment properties.

Please browse our website, check out our listings, and contact us with any questions that you have!

Serving Abbotsford, Chilliwack,
Mission, Aldergrove and Langley in the Fraser Valley.

Instant Access to Full Listing Details

Title Goes here

Notice (8): Only variables should be passed by reference [APP/views/helpers/form.php, line 548]Code        if ($text === null) {
            if (strpos($fieldName, '.') !== false) {
                $text = array_pop(explode('.', $fieldName));
Debugger::handleError() - CORE/cake/libs/debugger.php, line 306
FormHelper::label() - APP/views/helpers/form.php, line 548
FormHelper::_inputLabel() - APP/views/helpers/form.php, line 993
FormHelper::input() - APP/views/helpers/form.php, line 839
include - APP/views/themed/default/elements/listing_optin_new.ctp, line 123
View::_render() - CORE/cake/libs/view/view.php, line 736
DebugView::_render() - APP/plugins/debug_kit/views/debug.php, line 43
View::element() - CORE/cake/libs/view/view.php, line 397
DebugView::element() - APP/plugins/debug_kit/views/debug.php, line 65
include - APP/views/themed/default/layouts/default.ctp, line 120
View::_render() - CORE/cake/libs/view/view.php, line 736
DebugView::_render() - APP/plugins/debug_kit/views/debug.php, line 43
View::renderLayout() - CORE/cake/libs/view/view.php, line 494
View::render() - CORE/cake/libs/view/view.php, line 440
DebugView::render() - APP/plugins/debug_kit/views/debug.php, line 85
Controller::render() - CORE/cake/libs/controller/controller.php, line 908
SitesController::display() - APP/controllers/sites_controller.php, line 2086
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204

First Name

Notice: Only variables should be passed by reference in /home/performa/cake_app/app/views/helpers/form.php on line 548

Last Name

Notice: Only variables should be passed by reference in /home/performa/cake_app/app/views/helpers/form.php on line 548

Phone

Notice: Only variables should be passed by reference in /home/performa/cake_app/app/views/helpers/form.php on line 548

Price: $
Or call Now!
Jonathan Gelderman
Jonathan Gelderman, Personal Real Estate Corporation
604-791- SOLD (7653)

Warning (2): Undefined array key "title" [APP/views/elements/media_gallery.ctp, line 231]Code        <div id="thumbs">

            <?php foreach($videos as $key => $video): ?>

                <?php echo $this->Html->div(null, $this->YouTube->thumbnail($video['Video']['video'], $video['Video']['title'], array('num' => $key + 1))); ?>
Debugger::handleError() - CORE/cake/libs/debugger.php, line 306
include - APP/views/elements/media_gallery.ctp, line 231
View::_render() - CORE/cake/libs/view/view.php, line 736
DebugView::_render() - APP/plugins/debug_kit/views/debug.php, line 43
View::element() - CORE/cake/libs/view/view.php, line 397
DebugView::element() - APP/plugins/debug_kit/views/debug.php, line 65
include - APP/views/themed/default/layouts/default.ctp, line 123
View::_render() - CORE/cake/libs/view/view.php, line 736
DebugView::_render() - APP/plugins/debug_kit/views/debug.php, line 43
View::renderLayout() - CORE/cake/libs/view/view.php, line 494
View::render() - CORE/cake/libs/view/view.php, line 440
DebugView::render() - APP/plugins/debug_kit/views/debug.php, line 85
Controller::render() - CORE/cake/libs/controller/controller.php, line 908
SitesController::display() - APP/controllers/sites_controller.php, line 2086
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 84

Warning: Undefined array key "title" in /home/performa/cake_app/app/views/elements/media_gallery.ctp on line 231

History
+ –

Request History

No previous requests logged.

====
Session
+ –
Session
- Config
  userAgent29344a06db12e8ab8cd18395af4039b9
  time1749918035
  timeout10
====
Request
+ –
Request

Cake Params
- controllersites
- actiondisplay
- named(empty)
- pass
  0gelderman
  1home
- domaingelderman
- slughome
- plugin(null)
- url
  exthtml
  url/
- form(empty)
- isAjax(false)
$_GET
- url/
Cookie
- 0(empty)
Current Route
- keys(empty)
- options
  pass
  0domain
  1slug
  persist
  0domain
- defaults
  controllersites
  actiondisplay
  domaingelderman
  slughome
  plugin(null)
- template/
- _greedy(false)
- _compiledRoute#^/*$#
- __headerMap
  typecontent_type
  methodrequest_method
  serverserver_name
====

Sql Log

+ –

Sql Logs

default

Query	Affected	Num. rows	Took (ms)	Actions
SHOW FULL COLUMNS FROM `sites`	80	80	1
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';	1	1	0
SHOW FULL COLUMNS FROM `users`	12	12	0
SHOW FULL COLUMNS FROM `profiles`	16	16	0
SHOW FULL COLUMNS FROM `countries`	3	3	0
SHOW FULL COLUMNS FROM `colors`	8	8	0
SHOW FULL COLUMNS FROM `color_types`	5	5	0
SHOW FULL COLUMNS FROM `color_themes`	6	6	0
SHOW FULL COLUMNS FROM `photos`	11	11	0
SHOW FULL COLUMNS FROM `photos_sites`	13	13	0
SHOW FULL COLUMNS FROM `videos`	5	5	0
SHOW FULL COLUMNS FROM `sites_videos`	4	4	0
SHOW FULL COLUMNS FROM `leads`	29	29	0
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';	1	1	0
SHOW FULL COLUMNS FROM `content_pages`	22	22	0
SHOW FULL COLUMNS FROM `links`	8	8	0
SHOW FULL COLUMNS FROM `link_types`	3	3	0
SHOW FULL COLUMNS FROM `menu_items`	12	12	0
SHOW FULL COLUMNS FROM `menu_types`	3	3	0
SHOW FULL COLUMNS FROM `lead_notes`	8	8	0
SHOW FULL COLUMNS FROM `gallery_types`	2	2	0
SHOW FULL COLUMNS FROM `header_effects`	3	3	0
SHOW FULL COLUMNS FROM `content_blocks`	4	4	0
SHOW FULL COLUMNS FROM `content_block_types`	3	3	0
SHOW FULL COLUMNS FROM `listings`	41	41	0
SHOW FULL COLUMNS FROM `images`	6	6	0
SHOW FULL COLUMNS FROM `social_medias`	21	21	0
SHOW FULL COLUMNS FROM `day_tips`	6	6	0
SHOW FULL COLUMNS FROM `email_templates`	10	10	0
SHOW FULL COLUMNS FROM `mobiles`	7	7	0
SHOW FULL COLUMNS FROM `offers`	13	13	0
SHOW FULL COLUMNS FROM `video_tips`	6	6	0
SELECT `VideoTip`.`id`, `VideoTip`.`controller`, `VideoTip`.`action`, `VideoTip`.`video`, `VideoTip`.`created`, `VideoTip`.`modified` FROM `video_tips` AS `VideoTip` WHERE `controller` = 'sites' AND `action` = 'display'	0	0	0
SELECT `Site`.`id`, `Site`.`is_top_producer_enabled`, `Site`.`title`, `Site`.`subdomain`, `Site`.`domain`, `Site`.`user_id`, `Site`.`color_theme_id`, `Site`.`logo_id`, `Site`.`gallery_type_id`, `Site`.`header_effect_id`, `Site`.`header_slideshow_delay`, `Site`.`listing_slideshow_delay`, `Site`.`analytics_code`, `Site`.`remarketing_code`, `Site`.`adwords_conversion_code`, `Site`.`facebook_remarketing_code`, `Site`.`facebook_conversion_code`, `Site`.`meta_description`, `Site`.`meta_keywords`, `Site`.`created`, `Site`.`modified`, `Site`.`active`, `Site`.`coverflow_above`, `Site`.`display_listings`, `Site`.`display_opt_in`, `Site`.`auto_scroll`, `Site`.`header_menu_placeholder`, `Site`.`header_margin_bgcolor`, `Site`.`bottom_button`, `Site`.`personal_photo_shadow`, `Site`.`header_design`, `Site`.`header_size`, `Site`.`contact_no`, `Site`.`logo_design`, `Site`.`quick_question`, `Site`.`bb_backgrond_color`, `Site`.`call_today_text`, `Site`.`is_show_phone_new_line`, `Site`.`phone_alignment`, `Site`.`phone_row_background`, `Site`.`team_members_per_row`, `Site`.`affiliates_per_row`, `Site`.`domain_fontsize`, `Site`.`domain_lineheight`, `Site`.`socialmedia_margin`, `Site`.`team_member_id`, `Site`.`show_mls_logo`, `Site`.`socialmedia_size`, `Site`.`slogan_font`, `Site`.`custom_thank_you_message`, `Site`.`background_design`, `Site`.`background_design_color`, `Site`.`display_other_listings`, `Site`.`listing_page_layout`, `Site`.`listing_popup_style`, `Site`.`send_leads_owner`, `Site`.`video_share_buttons`, `Site`.`scroll_listing_member_address`, `Site`.`enable_mobile_site`, `Site`.`listings_display_opt_in`, `Site`.`listings_sold`, `Site`.`enable_cookie`, `Site`.`top_producer_page_id`, `Site`.`top_producer_assigned_to`, `Site`.`top_producer_source`, `Site`.`enable_social_media_opt_in_form`, `Site`.`assign_leads_status`, `Site`.`assign_leads_type`, `Site`.`assign_leads_interval`, `Site`.`assign_leads_sechdule`, `Site`.`sold_photo_scroll_type`, `Site`.`sold_auto_scroll`, `Site`.`sold_listing_slideshow_delay`, `Site`.`opt_in_after_listings`, `Site`.`show_opt_in_after_listings`, `Site`.`get_notofication_unsubscribe_leads`, `Site`.`google_site_verification`, `Site`.`pwp_lead_capture_api_key`, `Site`.`address_type`, `Site`.`custom_address` FROM `sites` AS `Site` WHERE `Site`.`subdomain` = 'gelderman' ORDER BY `created` ASC LIMIT 1	1	1	0
SHOW FULL COLUMNS FROM `visitors`	15	15	0
SELECT `SocialMedia`.`id`, `SocialMedia`.`site_id`, `SocialMedia`.`placeholder`, `SocialMedia`.`facebook_app_id`, `SocialMedia`.`facebook_secret_id`, `SocialMedia`.`facebook`, `SocialMedia`.`twitter`, `SocialMedia`.`linkdin`, `SocialMedia`.`google_plus`, `SocialMedia`.`youtube`, `SocialMedia`.`youtube_url`, `SocialMedia`.`pinterest`, `SocialMedia`.`facebook_image`, `SocialMedia`.`twitter_image`, `SocialMedia`.`linkdin_image`, `SocialMedia`.`google_image`, `SocialMedia`.`youtube_image`, `SocialMedia`.`pinterest_image`, `SocialMedia`.`email_share`, `SocialMedia`.`skypecall`, `SocialMedia`.`skype_name` FROM `social_medias` AS `SocialMedia` WHERE `SocialMedia`.`site_id` = 282 LIMIT 1	1	1	0
SELECT `ContentPage`.`id`, `ContentPage`.`site_id`, `ContentPage`.`link_id`, `ContentPage`.`optin_enabled`, `ContentPage`.`title`, `ContentPage`.`slug`, `ContentPage`.`content`, `ContentPage`.`custom_thank_you_message`, `ContentPage`.`is_show_custom_thanks_message`, `ContentPage`.`created`, `ContentPage`.`modified`, `ContentPage`.`description`, `ContentPage`.`team_members`, `ContentPage`.`external_embed_script`, `ContentPage`.`calculator`, `ContentPage`.`affiliates`, `ContentPage`.`external_frame_link`, `ContentPage`.`video`, `ContentPage`.`is_hide_default_report_pdf`, `ContentPage`.`is_display_video`, `ContentPage`.`is_show_sold_listings`, `ContentPage`.`is_home_evaluation`, `Site`.`id`, `Site`.`is_top_producer_enabled`, `Site`.`title`, `Site`.`subdomain`, `Site`.`domain`, `Site`.`user_id`, `Site`.`color_theme_id`, `Site`.`logo_id`, `Site`.`gallery_type_id`, `Site`.`header_effect_id`, `Site`.`header_slideshow_delay`, `Site`.`listing_slideshow_delay`, `Site`.`analytics_code`, `Site`.`remarketing_code`, `Site`.`adwords_conversion_code`, `Site`.`facebook_remarketing_code`, `Site`.`facebook_conversion_code`, `Site`.`meta_description`, `Site`.`meta_keywords`, `Site`.`created`, `Site`.`modified`, `Site`.`active`, `Site`.`coverflow_above`, `Site`.`display_listings`, `Site`.`display_opt_in`, `Site`.`auto_scroll`, `Site`.`header_menu_placeholder`, `Site`.`header_margin_bgcolor`, `Site`.`bottom_button`, `Site`.`personal_photo_shadow`, `Site`.`header_design`, `Site`.`header_size`, `Site`.`contact_no`, `Site`.`logo_design`, `Site`.`quick_question`, `Site`.`bb_backgrond_color`, `Site`.`call_today_text`, `Site`.`is_show_phone_new_line`, `Site`.`phone_alignment`, `Site`.`phone_row_background`, `Site`.`team_members_per_row`, `Site`.`affiliates_per_row`, `Site`.`domain_fontsize`, `Site`.`domain_lineheight`, `Site`.`socialmedia_margin`, `Site`.`team_member_id`, `Site`.`show_mls_logo`, `Site`.`socialmedia_size`, `Site`.`slogan_font`, `Site`.`custom_thank_you_message`, `Site`.`background_design`, `Site`.`background_design_color`, `Site`.`display_other_listings`, `Site`.`listing_page_layout`, `Site`.`listing_popup_style`, `Site`.`send_leads_owner`, `Site`.`video_share_buttons`, `Site`.`scroll_listing_member_address`, `Site`.`enable_mobile_site`, `Site`.`listings_display_opt_in`, `Site`.`listings_sold`, `Site`.`enable_cookie`, `Site`.`top_producer_page_id`, `Site`.`top_producer_assigned_to`, `Site`.`top_producer_source`, `Site`.`enable_social_media_opt_in_form`, `Site`.`assign_leads_status`, `Site`.`assign_leads_type`, `Site`.`assign_leads_interval`, `Site`.`assign_leads_sechdule`, `Site`.`sold_photo_scroll_type`, `Site`.`sold_auto_scroll`, `Site`.`sold_listing_slideshow_delay`, `Site`.`opt_in_after_listings`, `Site`.`show_opt_in_after_listings`, `Site`.`get_notofication_unsubscribe_leads`, `Site`.`google_site_verification`, `Site`.`pwp_lead_capture_api_key`, `Site`.`address_type`, `Site`.`custom_address`, `Link`.`id`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`site_id`, `Link`.`url`, `Link`.`target_blank`, `Link`.`created`, `Link`.`modified` FROM `content_pages` AS `ContentPage` LEFT JOIN `sites` AS `Site` ON (`ContentPage`.`site_id` = `Site`.`id`) LEFT JOIN `links` AS `Link` ON (`ContentPage`.`link_id` = `Link`.`id`) WHERE `ContentPage`.`site_id` = 282 AND `ContentPage`.`slug` = 'home' ORDER BY `ContentPage`.`title` ASC LIMIT 1	1	1	0
SHOW FULL COLUMNS FROM `attachment_types`	2	2	0
SHOW FULL COLUMNS FROM `attachments`	9	9	0
SELECT `AttachmentType`.`id`, `AttachmentType`.`type` FROM `attachment_types` AS `AttachmentType` WHERE 1 = 1	2	2	0
SELECT `Attachment`.`id`, `Attachment`.`site_id`, `Attachment`.`content_page_id`, `Attachment`.`listing_id`, `Attachment`.`attachment_type_id`, `Attachment`.`file_name`, `Attachment`.`attachment`, `Attachment`.`created`, `Attachment`.`modified` FROM `attachments` AS `Attachment` WHERE `Attachment`.`content_page_id` = 11373 AND `Attachment`.`attachment_type_id` IN (1, 2)	0	0	0
SELECT `User`.`id`, `User`.`is_admin`, `User`.`is_agent`, `User`.`email`, `User`.`password`, `User`.`status`, `User`.`created`, `User`.`modified`, `User`.`grl_email`, `User`.`grl_password`, `User`.`mass_email_status`, `User`.`is_subscribe_lead_emails`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`first_name`, `Profile`.`last_name`, `Profile`.`phone`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`title`, `Profile`.`company`, `Profile`.`country_id`, `Profile`.`sites_allotted`, `Profile`.`affiliate_code`, `Profile`.`show_affiliate_button`, `Profile`.`address`, `Profile`.`city`, `Profile`.`state`, (CONCAT(`Profile`.`first_name`, ' ', `Profile`.`last_name`)) AS `Profile__name` FROM `users` AS `User` LEFT JOIN `profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 240 LIMIT 1	1	1	0
SELECT `Country`.`abbrev` FROM `countries` AS `Country` WHERE `id` = 1 LIMIT 1	1	1	0
SHOW FULL COLUMNS FROM `form_fields`	9	9	0
SELECT `FormField`.`id`, `FormField`.`site_id`, `FormField`.`first_name`, `FormField`.`last_name`, `FormField`.`email`, `FormField`.`phone_no`, `FormField`.`city`, `FormField`.`street`, `FormField`.`address` FROM `form_fields` AS `FormField` WHERE `FormField`.`site_id` = 282 LIMIT 1	0	0	0
SHOW FULL COLUMNS FROM `banner_overlay_settings`	10	10	0
SELECT `BannerOverlaySetting`.`id`, `BannerOverlaySetting`.`profile_pic_params_o`, `BannerOverlaySetting`.`profile_pic_path_o`, `BannerOverlaySetting`.`has_profile_pic_o`, `BannerOverlaySetting`.`site_id`, `BannerOverlaySetting`.`is_anable_header_banner`, `BannerOverlaySetting`.`is_anable_big_header`, `BannerOverlaySetting`.`image`, `BannerOverlaySetting`.`left`, `BannerOverlaySetting`.`top` FROM `banner_overlay_settings` AS `BannerOverlaySetting` WHERE `BannerOverlaySetting`.`site_id` = 282 LIMIT 1	0	0	0
SELECT COUNT(*) AS `count` FROM `color_themes` AS `ColorTheme` WHERE `ColorTheme`.`id` = 281	1	1	0
SELECT `ColorType`.`abbrev`, `Color`.`value` FROM `colors` AS `Color` LEFT JOIN `users` AS `User` ON (`Color`.`user_id` = `User`.`id`) LEFT JOIN `color_types` AS `ColorType` ON (`Color`.`color_type_id` = `ColorType`.`id`) LEFT JOIN `color_themes` AS `ColorTheme` ON (`Color`.`color_theme_id` = `ColorTheme`.`id`) WHERE `color_theme_id` = 281	17	17	1	maybe slow
SELECT `HeaderPhoto`.`id`, `HeaderPhoto`.`site_id`, `HeaderPhoto`.`photo_id`, `HeaderPhoto`.`header_order`, `HeaderPhoto`.`gallery_order`, `HeaderPhoto`.`crop_x`, `HeaderPhoto`.`crop_y`, `HeaderPhoto`.`crop_x2`, `HeaderPhoto`.`crop_y2`, `HeaderPhoto`.`description`, `HeaderPhoto`.`is_includephoto_frontend`, `HeaderPhoto`.`header_photo_link`, `HeaderPhoto`.`is_showphoto_otherusers`, (crop_x2 - crop_x) AS `HeaderPhoto__crop_width`, (crop_y2 - crop_y) AS `HeaderPhoto__crop_height`, `Site`.`id`, `Site`.`is_top_producer_enabled`, `Site`.`title`, `Site`.`subdomain`, `Site`.`domain`, `Site`.`user_id`, `Site`.`color_theme_id`, `Site`.`logo_id`, `Site`.`gallery_type_id`, `Site`.`header_effect_id`, `Site`.`header_slideshow_delay`, `Site`.`listing_slideshow_delay`, `Site`.`analytics_code`, `Site`.`remarketing_code`, `Site`.`adwords_conversion_code`, `Site`.`facebook_remarketing_code`, `Site`.`facebook_conversion_code`, `Site`.`meta_description`, `Site`.`meta_keywords`, `Site`.`created`, `Site`.`modified`, `Site`.`active`, `Site`.`coverflow_above`, `Site`.`display_listings`, `Site`.`display_opt_in`, `Site`.`auto_scroll`, `Site`.`header_menu_placeholder`, `Site`.`header_margin_bgcolor`, `Site`.`bottom_button`, `Site`.`personal_photo_shadow`, `Site`.`header_design`, `Site`.`header_size`, `Site`.`contact_no`, `Site`.`logo_design`, `Site`.`quick_question`, `Site`.`bb_backgrond_color`, `Site`.`call_today_text`, `Site`.`is_show_phone_new_line`, `Site`.`phone_alignment`, `Site`.`phone_row_background`, `Site`.`team_members_per_row`, `Site`.`affiliates_per_row`, `Site`.`domain_fontsize`, `Site`.`domain_lineheight`, `Site`.`socialmedia_margin`, `Site`.`team_member_id`, `Site`.`show_mls_logo`, `Site`.`socialmedia_size`, `Site`.`slogan_font`, `Site`.`custom_thank_you_message`, `Site`.`background_design`, `Site`.`background_design_color`, `Site`.`display_other_listings`, `Site`.`listing_page_layout`, `Site`.`listing_popup_style`, `Site`.`send_leads_owner`, `Site`.`video_share_buttons`, `Site`.`scroll_listing_member_address`, `Site`.`enable_mobile_site`, `Site`.`listings_display_opt_in`, `Site`.`listings_sold`, `Site`.`enable_cookie`, `Site`.`top_producer_page_id`, `Site`.`top_producer_assigned_to`, `Site`.`top_producer_source`, `Site`.`enable_social_media_opt_in_form`, `Site`.`assign_leads_status`, `Site`.`assign_leads_type`, `Site`.`assign_leads_interval`, `Site`.`assign_leads_sechdule`, `Site`.`sold_photo_scroll_type`, `Site`.`sold_auto_scroll`, `Site`.`sold_listing_slideshow_delay`, `Site`.`opt_in_after_listings`, `Site`.`show_opt_in_after_listings`, `Site`.`get_notofication_unsubscribe_leads`, `Site`.`google_site_verification`, `Site`.`pwp_lead_capture_api_key`, `Site`.`address_type`, `Site`.`custom_address`, `Photo`.`id`, `Photo`.`user_id`, `Photo`.`is_preset`, `Photo`.`title`, `Photo`.`header_file_name`, `Photo`.`photo_file_name`, `Photo`.`logo_file_name`, `Photo`.`upload_file_name`, `Photo`.`gallery_file_name`, `Photo`.`created`, `Photo`.`modified` FROM `photos_sites` AS `HeaderPhoto` LEFT JOIN `sites` AS `Site` ON (`HeaderPhoto`.`site_id` = `Site`.`id`) LEFT JOIN `photos` AS `Photo` ON (`HeaderPhoto`.`photo_id` = `Photo`.`id`) WHERE `is_includephoto_frontend` = '1' AND `HeaderPhoto`.`site_id` = 282 AND NOT (`header_file_name` IS NULL) ORDER BY `header_order` ASC, `Photo`.`created` DESC, `Photo`.`id` ASC	10	10	1	maybe slow
SELECT `HeaderEffect`.`abbrev` FROM `header_effects` AS `HeaderEffect` WHERE `id` = 8 LIMIT 1	1	1	0
SELECT `MenuItem`.`id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_description`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id`, `Site`.`subdomain` FROM `menu_items` AS `MenuItem` LEFT JOIN `links` AS `Link` ON (`MenuItem`.`link_id` = `Link`.`id`) LEFT JOIN `sites` AS `Site` ON (`MenuItem`.`site_id` = `Site`.`id`) WHERE `MenuItem`.`site_id` = 282 AND `MenuItem`.`menu_type_id` = 1 ORDER BY `order` ASC	9	9	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11045	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11373	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11045)	0	0	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11049	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11380	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11049)	0	0	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11050	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11381	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 2	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11050)	0	0	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11059	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11374	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11059)	0	0	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11060	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11431	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11060)	0	0	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11052	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11383	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11052)	0	0	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11020	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11439	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11020)	0	0	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11046	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11376	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11046)	0	0	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11047	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11377	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11047)	0	0	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `MenuItem`.`id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_description`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id`, `Site`.`subdomain` FROM `menu_items` AS `MenuItem` LEFT JOIN `links` AS `Link` ON (`MenuItem`.`link_id` = `Link`.`id`) LEFT JOIN `sites` AS `Site` ON (`MenuItem`.`site_id` = `Site`.`id`) WHERE `MenuItem`.`site_id` = 282 AND `MenuItem`.`menu_type_id` = 2 ORDER BY `order` ASC	12	12	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11039	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11366	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11039)	0	0	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11048	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11379	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11048)	0	0	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11041	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11368	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11041)	0	0	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11037	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11364	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11037)	0	0	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11022	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11348	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11022)	0	0	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11043	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11370	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11043)	0	0	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11035	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11362	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11035)	0	0	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11030	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11356	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11030)	0	0	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11024	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11350	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11024)	0	0	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11026	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11352	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11026)	0	0	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11032	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11358	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11032)	0	0	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11028	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11354	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11028)	0	0	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `MenuItem`.`id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_description`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id`, `Site`.`subdomain` FROM `menu_items` AS `MenuItem` LEFT JOIN `links` AS `Link` ON (`MenuItem`.`link_id` = `Link`.`id`) LEFT JOIN `sites` AS `Site` ON (`MenuItem`.`site_id` = `Site`.`id`) WHERE `MenuItem`.`site_id` = 282 AND `MenuItem`.`menu_type_id` = 3 ORDER BY `order` ASC	0	0	0
SELECT `MenuItem`.`id`, `MenuItem`.`menu_type_id`, `MenuItem`.`link_id`, `MenuItem`.`site_id`, `MenuItem`.`title`, `MenuItem`.`subtitle`, `MenuItem`.`order`, `MenuItem`.`button_pic`, `MenuItem`.`button_description`, `MenuItem`.`status`, `MenuItem`.`created`, `MenuItem`.`modified`, `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id`, `Site`.`subdomain` FROM `menu_items` AS `MenuItem` LEFT JOIN `links` AS `Link` ON (`MenuItem`.`link_id` = `Link`.`id`) LEFT JOIN `sites` AS `Site` ON (`MenuItem`.`site_id` = `Site`.`id`) WHERE `MenuItem`.`site_id` = 282 AND `MenuItem`.`menu_type_id` = 4 ORDER BY `order` ASC	3	3	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11054	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11384	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11054)	0	0	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11056	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11385	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11056)	0	0	0
SELECT `Link`.`url`, `Link`.`target_blank`, `Link`.`content_page_id`, `Link`.`link_type_id`, `Link`.`id` FROM `links` AS `Link` WHERE `Link`.`id` = 11058	1	1	0
SELECT `ContentPage`.`slug` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`id` = 11386	1	1	0
SELECT `LinkType`.`abbrev` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	0
SELECT `ContentPage`.`slug`, `ContentPage`.`id`, `ContentPage`.`link_id` FROM `content_pages` AS `ContentPage` WHERE `ContentPage`.`link_id` = (11058)	0	0	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `Site`.`subdomain` FROM `sites` AS `Site` WHERE `Site`.`id` = 282	1	1	0
SELECT `SitesVideo`.`id`, `SitesVideo`.`site_id`, `SitesVideo`.`video_id`, `SitesVideo`.`order`, `Video`.`id`, `Video`.`user_id`, `Video`.`video`, `Video`.`created`, `Video`.`modified` FROM `sites_videos` AS `SitesVideo` LEFT JOIN `videos` AS `Video` ON (`SitesVideo`.`video_id` = `Video`.`id`) WHERE `SitesVideo`.`site_id` = 282 ORDER BY `SitesVideo`.`order` ASC, `Video`.`created` DESC LIMIT 5	5	5	0
SELECT `Logo`.`id`, `Logo`.`user_id`, `Logo`.`is_preset`, `Logo`.`title`, `Logo`.`header_file_name`, `Logo`.`photo_file_name`, `Logo`.`logo_file_name`, `Logo`.`upload_file_name`, `Logo`.`gallery_file_name`, `Logo`.`created`, `Logo`.`modified` FROM `photos` AS `Logo` WHERE `id` = 1345 AND `Logo`.`is_preset` = 1 AND NOT (`logo_file_name` IS NULL) ORDER BY `title` ASC LIMIT 1	0	0	0
SELECT `CustomLogosSite`.`id`, `CustomLogosSite`.`site_id`, `CustomLogosSite`.`photo_id`, `CustomLogosSite`.`header_order`, `CustomLogosSite`.`gallery_order`, `CustomLogosSite`.`crop_x`, `CustomLogosSite`.`crop_y`, `CustomLogosSite`.`crop_x2`, `CustomLogosSite`.`crop_y2`, `CustomLogosSite`.`description`, `CustomLogosSite`.`is_includephoto_frontend`, `CustomLogosSite`.`header_photo_link`, `CustomLogosSite`.`is_showphoto_otherusers`, (crop_x2 - crop_x) AS `CustomLogosSite__crop_width`, (crop_y2 - crop_y) AS `CustomLogosSite__crop_height`, `Logo`.`id`, `Logo`.`user_id`, `Logo`.`is_preset`, `Logo`.`title`, `Logo`.`header_file_name`, `Logo`.`photo_file_name`, `Logo`.`logo_file_name`, `Logo`.`upload_file_name`, `Logo`.`gallery_file_name`, `Logo`.`created`, `Logo`.`modified` FROM `photos_sites` AS `CustomLogosSite` LEFT JOIN `photos` AS `Logo` ON (`CustomLogosSite`.`photo_id` = `Logo`.`id`) WHERE `photo_id` = 1345 AND `site_id` = 282 AND NOT (`logo_file_name` IS NULL) LIMIT 1	1	1	0
SELECT `ContentBlock`.`id`, `ContentBlock`.`site_id`, `ContentBlock`.`content_block_type_id`, `ContentBlock`.`content`, `ContentBlockType`.`id`, `ContentBlockType`.`title`, `ContentBlockType`.`abbrev` FROM `content_blocks` AS `ContentBlock` LEFT JOIN `content_block_types` AS `ContentBlockType` ON (`ContentBlock`.`content_block_type_id` = `ContentBlockType`.`id`) WHERE `ContentBlock`.`site_id` = 282 ORDER BY `content_block_type_id` ASC	4	4	0
SELECT `Listing`.`id`, `Listing`.`site_id`, `Listing`.`seller_id`, `Listing`.`buyer_id`, `Listing`.`visible`, `Listing`.`description`, `Listing`.`location`, `Listing`.`type`, `Listing`.`lot_dimensions`, `Listing`.`sewer`, `Listing`.`water`, `Listing`.`age`, `Listing`.`year_built`, `Listing`.`style`, `Listing`.`bedrooms`, `Listing`.`heating`, `Listing`.`bathrooms`, `Listing`.`map_display`, `Listing`.`sold`, `Listing`.`title`, `Listing`.`address`, `Listing`.`banner`, `Listing`.`price`, `Listing`.`zoom`, `Listing`.`open_house_timing`, `Listing`.`order`, `Listing`.`display_opt_in`, `Listing`.`display_other_listings`, `Listing`.`video`, `Listing`.`cre_property_id`, `Listing`.`cre_property_listingId`, `Listing`.`cre_propety_updatedtimestamp`, `Listing`.`cre_property_gallary_link`, `Listing`.`crea_listing_type`, `Listing`.`crea_brokerage_name`, `Listing`.`is_crea_feed`, `Listing`.`is_active`, `Listing`.`is_sold_listing`, `Listing`.`area_id`, `Listing`.`created`, `Listing`.`modified`, `Site`.`id`, `Site`.`is_top_producer_enabled`, `Site`.`title`, `Site`.`subdomain`, `Site`.`domain`, `Site`.`user_id`, `Site`.`color_theme_id`, `Site`.`logo_id`, `Site`.`gallery_type_id`, `Site`.`header_effect_id`, `Site`.`header_slideshow_delay`, `Site`.`listing_slideshow_delay`, `Site`.`analytics_code`, `Site`.`remarketing_code`, `Site`.`adwords_conversion_code`, `Site`.`facebook_remarketing_code`, `Site`.`facebook_conversion_code`, `Site`.`meta_description`, `Site`.`meta_keywords`, `Site`.`created`, `Site`.`modified`, `Site`.`active`, `Site`.`coverflow_above`, `Site`.`display_listings`, `Site`.`display_opt_in`, `Site`.`auto_scroll`, `Site`.`header_menu_placeholder`, `Site`.`header_margin_bgcolor`, `Site`.`bottom_button`, `Site`.`personal_photo_shadow`, `Site`.`header_design`, `Site`.`header_size`, `Site`.`contact_no`, `Site`.`logo_design`, `Site`.`quick_question`, `Site`.`bb_backgrond_color`, `Site`.`call_today_text`, `Site`.`is_show_phone_new_line`, `Site`.`phone_alignment`, `Site`.`phone_row_background`, `Site`.`team_members_per_row`, `Site`.`affiliates_per_row`, `Site`.`domain_fontsize`, `Site`.`domain_lineheight`, `Site`.`socialmedia_margin`, `Site`.`team_member_id`, `Site`.`show_mls_logo`, `Site`.`socialmedia_size`, `Site`.`slogan_font`, `Site`.`custom_thank_you_message`, `Site`.`background_design`, `Site`.`background_design_color`, `Site`.`display_other_listings`, `Site`.`listing_page_layout`, `Site`.`listing_popup_style`, `Site`.`send_leads_owner`, `Site`.`video_share_buttons`, `Site`.`scroll_listing_member_address`, `Site`.`enable_mobile_site`, `Site`.`listings_display_opt_in`, `Site`.`listings_sold`, `Site`.`enable_cookie`, `Site`.`top_producer_page_id`, `Site`.`top_producer_assigned_to`, `Site`.`top_producer_source`, `Site`.`enable_social_media_opt_in_form`, `Site`.`assign_leads_status`, `Site`.`assign_leads_type`, `Site`.`assign_leads_interval`, `Site`.`assign_leads_sechdule`, `Site`.`sold_photo_scroll_type`, `Site`.`sold_auto_scroll`, `Site`.`sold_listing_slideshow_delay`, `Site`.`opt_in_after_listings`, `Site`.`show_opt_in_after_listings`, `Site`.`get_notofication_unsubscribe_leads`, `Site`.`google_site_verification`, `Site`.`pwp_lead_capture_api_key`, `Site`.`address_type`, `Site`.`custom_address` FROM `listings` AS `Listing` LEFT JOIN `sites` AS `Site` ON (`Listing`.`site_id` = `Site`.`id`) WHERE `site_id` = 282 AND `Listing`.`is_sold_listing` = '1' AND `Listing`.`site_id` = 282 ORDER BY `Listing`.`order` DESC, `Listing`.`title` ASC	1	1	0
SELECT `Image`.`id`, `Image`.`path`, `Image`.`listing_id`, `Image`.`type`, `Image`.`order`, `Image`.`is_crea_feed` FROM `images` AS `Image` WHERE `Image`.`listing_id` = (21429)	0	0	0
SHOW FULL COLUMNS FROM `areas`	7	7	0
SELECT `Area`.`id`, `Area`.`site_id`, `Area`.`name`, `Area`.`status`, `Area`.`order`, `Area`.`created`, `Area`.`modified` FROM `areas` AS `Area` WHERE `site_id` = 282 AND `status` = 1 ORDER BY `Area`.`order` asc	0	0	0
SELECT `Listing`.`id`, `Listing`.`site_id`, `Listing`.`seller_id`, `Listing`.`buyer_id`, `Listing`.`visible`, `Listing`.`description`, `Listing`.`location`, `Listing`.`type`, `Listing`.`lot_dimensions`, `Listing`.`sewer`, `Listing`.`water`, `Listing`.`age`, `Listing`.`year_built`, `Listing`.`style`, `Listing`.`bedrooms`, `Listing`.`heating`, `Listing`.`bathrooms`, `Listing`.`map_display`, `Listing`.`sold`, `Listing`.`title`, `Listing`.`address`, `Listing`.`banner`, `Listing`.`price`, `Listing`.`zoom`, `Listing`.`open_house_timing`, `Listing`.`order`, `Listing`.`display_opt_in`, `Listing`.`display_other_listings`, `Listing`.`video`, `Listing`.`cre_property_id`, `Listing`.`cre_property_listingId`, `Listing`.`cre_propety_updatedtimestamp`, `Listing`.`cre_property_gallary_link`, `Listing`.`crea_listing_type`, `Listing`.`crea_brokerage_name`, `Listing`.`is_crea_feed`, `Listing`.`is_active`, `Listing`.`is_sold_listing`, `Listing`.`area_id`, `Listing`.`created`, `Listing`.`modified`, `Site`.`id`, `Site`.`is_top_producer_enabled`, `Site`.`title`, `Site`.`subdomain`, `Site`.`domain`, `Site`.`user_id`, `Site`.`color_theme_id`, `Site`.`logo_id`, `Site`.`gallery_type_id`, `Site`.`header_effect_id`, `Site`.`header_slideshow_delay`, `Site`.`listing_slideshow_delay`, `Site`.`analytics_code`, `Site`.`remarketing_code`, `Site`.`adwords_conversion_code`, `Site`.`facebook_remarketing_code`, `Site`.`facebook_conversion_code`, `Site`.`meta_description`, `Site`.`meta_keywords`, `Site`.`created`, `Site`.`modified`, `Site`.`active`, `Site`.`coverflow_above`, `Site`.`display_listings`, `Site`.`display_opt_in`, `Site`.`auto_scroll`, `Site`.`header_menu_placeholder`, `Site`.`header_margin_bgcolor`, `Site`.`bottom_button`, `Site`.`personal_photo_shadow`, `Site`.`header_design`, `Site`.`header_size`, `Site`.`contact_no`, `Site`.`logo_design`, `Site`.`quick_question`, `Site`.`bb_backgrond_color`, `Site`.`call_today_text`, `Site`.`is_show_phone_new_line`, `Site`.`phone_alignment`, `Site`.`phone_row_background`, `Site`.`team_members_per_row`, `Site`.`affiliates_per_row`, `Site`.`domain_fontsize`, `Site`.`domain_lineheight`, `Site`.`socialmedia_margin`, `Site`.`team_member_id`, `Site`.`show_mls_logo`, `Site`.`socialmedia_size`, `Site`.`slogan_font`, `Site`.`custom_thank_you_message`, `Site`.`background_design`, `Site`.`background_design_color`, `Site`.`display_other_listings`, `Site`.`listing_page_layout`, `Site`.`listing_popup_style`, `Site`.`send_leads_owner`, `Site`.`video_share_buttons`, `Site`.`scroll_listing_member_address`, `Site`.`enable_mobile_site`, `Site`.`listings_display_opt_in`, `Site`.`listings_sold`, `Site`.`enable_cookie`, `Site`.`top_producer_page_id`, `Site`.`top_producer_assigned_to`, `Site`.`top_producer_source`, `Site`.`enable_social_media_opt_in_form`, `Site`.`assign_leads_status`, `Site`.`assign_leads_type`, `Site`.`assign_leads_interval`, `Site`.`assign_leads_sechdule`, `Site`.`sold_photo_scroll_type`, `Site`.`sold_auto_scroll`, `Site`.`sold_listing_slideshow_delay`, `Site`.`opt_in_after_listings`, `Site`.`show_opt_in_after_listings`, `Site`.`get_notofication_unsubscribe_leads`, `Site`.`google_site_verification`, `Site`.`pwp_lead_capture_api_key`, `Site`.`address_type`, `Site`.`custom_address` FROM `listings` AS `Listing` LEFT JOIN `sites` AS `Site` ON (`Listing`.`site_id` = `Site`.`id`) WHERE `site_id` = 282 AND `Listing`.`is_sold_listing` = '0' AND `Listing`.`site_id` = 282 ORDER BY `Listing`.`title` ASC	0	0	0
SELECT `Listing`.`id`, `Listing`.`site_id`, `Listing`.`seller_id`, `Listing`.`buyer_id`, `Listing`.`visible`, `Listing`.`description`, `Listing`.`location`, `Listing`.`type`, `Listing`.`lot_dimensions`, `Listing`.`sewer`, `Listing`.`water`, `Listing`.`age`, `Listing`.`year_built`, `Listing`.`style`, `Listing`.`bedrooms`, `Listing`.`heating`, `Listing`.`bathrooms`, `Listing`.`map_display`, `Listing`.`sold`, `Listing`.`title`, `Listing`.`address`, `Listing`.`banner`, `Listing`.`price`, `Listing`.`zoom`, `Listing`.`open_house_timing`, `Listing`.`order`, `Listing`.`display_opt_in`, `Listing`.`display_other_listings`, `Listing`.`video`, `Listing`.`cre_property_id`, `Listing`.`cre_property_listingId`, `Listing`.`cre_propety_updatedtimestamp`, `Listing`.`cre_property_gallary_link`, `Listing`.`crea_listing_type`, `Listing`.`crea_brokerage_name`, `Listing`.`is_crea_feed`, `Listing`.`is_active`, `Listing`.`is_sold_listing`, `Listing`.`area_id`, `Listing`.`created`, `Listing`.`modified`, `Site`.`id`, `Site`.`is_top_producer_enabled`, `Site`.`title`, `Site`.`subdomain`, `Site`.`domain`, `Site`.`user_id`, `Site`.`color_theme_id`, `Site`.`logo_id`, `Site`.`gallery_type_id`, `Site`.`header_effect_id`, `Site`.`header_slideshow_delay`, `Site`.`listing_slideshow_delay`, `Site`.`analytics_code`, `Site`.`remarketing_code`, `Site`.`adwords_conversion_code`, `Site`.`facebook_remarketing_code`, `Site`.`facebook_conversion_code`, `Site`.`meta_description`, `Site`.`meta_keywords`, `Site`.`created`, `Site`.`modified`, `Site`.`active`, `Site`.`coverflow_above`, `Site`.`display_listings`, `Site`.`display_opt_in`, `Site`.`auto_scroll`, `Site`.`header_menu_placeholder`, `Site`.`header_margin_bgcolor`, `Site`.`bottom_button`, `Site`.`personal_photo_shadow`, `Site`.`header_design`, `Site`.`header_size`, `Site`.`contact_no`, `Site`.`logo_design`, `Site`.`quick_question`, `Site`.`bb_backgrond_color`, `Site`.`call_today_text`, `Site`.`is_show_phone_new_line`, `Site`.`phone_alignment`, `Site`.`phone_row_background`, `Site`.`team_members_per_row`, `Site`.`affiliates_per_row`, `Site`.`domain_fontsize`, `Site`.`domain_lineheight`, `Site`.`socialmedia_margin`, `Site`.`team_member_id`, `Site`.`show_mls_logo`, `Site`.`socialmedia_size`, `Site`.`slogan_font`, `Site`.`custom_thank_you_message`, `Site`.`background_design`, `Site`.`background_design_color`, `Site`.`display_other_listings`, `Site`.`listing_page_layout`, `Site`.`listing_popup_style`, `Site`.`send_leads_owner`, `Site`.`video_share_buttons`, `Site`.`scroll_listing_member_address`, `Site`.`enable_mobile_site`, `Site`.`listings_display_opt_in`, `Site`.`listings_sold`, `Site`.`enable_cookie`, `Site`.`top_producer_page_id`, `Site`.`top_producer_assigned_to`, `Site`.`top_producer_source`, `Site`.`enable_social_media_opt_in_form`, `Site`.`assign_leads_status`, `Site`.`assign_leads_type`, `Site`.`assign_leads_interval`, `Site`.`assign_leads_sechdule`, `Site`.`sold_photo_scroll_type`, `Site`.`sold_auto_scroll`, `Site`.`sold_listing_slideshow_delay`, `Site`.`opt_in_after_listings`, `Site`.`show_opt_in_after_listings`, `Site`.`get_notofication_unsubscribe_leads`, `Site`.`google_site_verification`, `Site`.`pwp_lead_capture_api_key`, `Site`.`address_type`, `Site`.`custom_address` FROM `listings` AS `Listing` LEFT JOIN `sites` AS `Site` ON (`Listing`.`site_id` = `Site`.`id`) WHERE `site_id` = 282 AND `is_active` = '1' AND `is_crea_feed` = '1'	0	0	0
SELECT `Offer`.`id`, `Offer`.`site_id`, `Offer`.`title`, `Offer`.`description`, `Offer`.`amount`, `Offer`.`howworks`, `Offer`.`valid_days`, `Offer`.`status`, `Offer`.`created`, `Offer`.`modified`, `Offer`.`email_from`, `Offer`.`email_subject`, `Offer`.`facebook_share_title` FROM `offers` AS `Offer` WHERE `site_id` = 282 AND `status` = 1 ORDER BY `created` DESC	0	0	0
SELECT `Profile`.`id`, `Profile`.`user_id`, `Profile`.`first_name`, `Profile`.`last_name`, `Profile`.`phone`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`title`, `Profile`.`company`, `Profile`.`country_id`, `Profile`.`sites_allotted`, `Profile`.`affiliate_code`, `Profile`.`show_affiliate_button`, `Profile`.`address`, `Profile`.`city`, `Profile`.`state`, (CONCAT(`Profile`.`first_name`, ' ', `Profile`.`last_name`)) AS `Profile__name` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 240 LIMIT 1	1	1	0
SELECT `PersonalPhoto`.`id`, `PersonalPhoto`.`site_id`, `PersonalPhoto`.`photo_id`, `PersonalPhoto`.`header_order`, `PersonalPhoto`.`gallery_order`, `PersonalPhoto`.`crop_x`, `PersonalPhoto`.`crop_y`, `PersonalPhoto`.`crop_x2`, `PersonalPhoto`.`crop_y2`, `PersonalPhoto`.`description`, `PersonalPhoto`.`is_includephoto_frontend`, `PersonalPhoto`.`header_photo_link`, `PersonalPhoto`.`is_showphoto_otherusers`, (crop_x2 - crop_x) AS `PersonalPhoto__crop_width`, (crop_y2 - crop_y) AS `PersonalPhoto__crop_height`, `Site`.`id`, `Site`.`is_top_producer_enabled`, `Site`.`title`, `Site`.`subdomain`, `Site`.`domain`, `Site`.`user_id`, `Site`.`color_theme_id`, `Site`.`logo_id`, `Site`.`gallery_type_id`, `Site`.`header_effect_id`, `Site`.`header_slideshow_delay`, `Site`.`listing_slideshow_delay`, `Site`.`analytics_code`, `Site`.`remarketing_code`, `Site`.`adwords_conversion_code`, `Site`.`facebook_remarketing_code`, `Site`.`facebook_conversion_code`, `Site`.`meta_description`, `Site`.`meta_keywords`, `Site`.`created`, `Site`.`modified`, `Site`.`active`, `Site`.`coverflow_above`, `Site`.`display_listings`, `Site`.`display_opt_in`, `Site`.`auto_scroll`, `Site`.`header_menu_placeholder`, `Site`.`header_margin_bgcolor`, `Site`.`bottom_button`, `Site`.`personal_photo_shadow`, `Site`.`header_design`, `Site`.`header_size`, `Site`.`contact_no`, `Site`.`logo_design`, `Site`.`quick_question`, `Site`.`bb_backgrond_color`, `Site`.`call_today_text`, `Site`.`is_show_phone_new_line`, `Site`.`phone_alignment`, `Site`.`phone_row_background`, `Site`.`team_members_per_row`, `Site`.`affiliates_per_row`, `Site`.`domain_fontsize`, `Site`.`domain_lineheight`, `Site`.`socialmedia_margin`, `Site`.`team_member_id`, `Site`.`show_mls_logo`, `Site`.`socialmedia_size`, `Site`.`slogan_font`, `Site`.`custom_thank_you_message`, `Site`.`background_design`, `Site`.`background_design_color`, `Site`.`display_other_listings`, `Site`.`listing_page_layout`, `Site`.`listing_popup_style`, `Site`.`send_leads_owner`, `Site`.`video_share_buttons`, `Site`.`scroll_listing_member_address`, `Site`.`enable_mobile_site`, `Site`.`listings_display_opt_in`, `Site`.`listings_sold`, `Site`.`enable_cookie`, `Site`.`top_producer_page_id`, `Site`.`top_producer_assigned_to`, `Site`.`top_producer_source`, `Site`.`enable_social_media_opt_in_form`, `Site`.`assign_leads_status`, `Site`.`assign_leads_type`, `Site`.`assign_leads_interval`, `Site`.`assign_leads_sechdule`, `Site`.`sold_photo_scroll_type`, `Site`.`sold_auto_scroll`, `Site`.`sold_listing_slideshow_delay`, `Site`.`opt_in_after_listings`, `Site`.`show_opt_in_after_listings`, `Site`.`get_notofication_unsubscribe_leads`, `Site`.`google_site_verification`, `Site`.`pwp_lead_capture_api_key`, `Site`.`address_type`, `Site`.`custom_address`, `Photo`.`id`, `Photo`.`user_id`, `Photo`.`is_preset`, `Photo`.`title`, `Photo`.`header_file_name`, `Photo`.`photo_file_name`, `Photo`.`logo_file_name`, `Photo`.`upload_file_name`, `Photo`.`gallery_file_name`, `Photo`.`created`, `Photo`.`modified` FROM `photos_sites` AS `PersonalPhoto` LEFT JOIN `sites` AS `Site` ON (`PersonalPhoto`.`site_id` = `Site`.`id`) LEFT JOIN `photos` AS `Photo` ON (`PersonalPhoto`.`photo_id` = `Photo`.`id`) WHERE `PersonalPhoto`.`site_id` = 282 AND NOT (`photo_file_name` IS NULL) LIMIT 1	1	1	0
SELECT `Site`.`coverflow_above` FROM `sites` AS `Site` WHERE `subdomain` = 'gelderman' ORDER BY `created` ASC LIMIT 1	1	1	0
SELECT `Site`.`display_listings` FROM `sites` AS `Site` WHERE `subdomain` = 'gelderman' ORDER BY `created` ASC LIMIT 1	1	1	0
SELECT `Site`.`display_opt_in` FROM `sites` AS `Site` WHERE `subdomain` = 'gelderman' ORDER BY `created` ASC LIMIT 1	1	1	0
SELECT `Site`.`auto_scroll` FROM `sites` AS `Site` WHERE `subdomain` = 'gelderman' ORDER BY `created` ASC LIMIT 1	1	1	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Log
+ –

Logs

====
Variables
+ –
View Variables
- auto_scroll1
- display_opt_in1
- coverflow_show1
- coverflow_above0
- siteActive1
- adminPage(false)
- topTabHighlightsites
- siteMenu(null)
- personalPhoto
 PersonalPhoto
 id4454
 site_id282
 photo_id1398
 header_order(null)
 gallery_order(null)
 crop_x(null)
 crop_y(null)
 crop_x2(null)
 crop_y2(null)
 description(null)
 is_includephoto_frontend0
 header_photo_link(null)
 is_showphoto_otherusers0
 crop_width(null)
 crop_height(null)
 Site
 id282
 is_top_producer_enabled1
 titleGelderman.ca Real Estate Team
 subdomaingelderman
 domain(empty)
 user_id240
 color_theme_id281
 logo_id1345
 gallery_type_id1
 header_effect_id8
 header_slideshow_delay5000
 listing_slideshow_delay4500
 analytics_code(null)
 remarketing_code(null)
 adwords_conversion_code(null)
 facebook_remarketing_code(null)
 facebook_conversion_code(null)
 meta_description(null)
 meta_keywords(null)
 created2014-04-02 13:53:49
 modified2017-02-02 12:39:43
 active1
 coverflow_above0
 display_listings1
 display_opt_in1
 auto_scroll1
 header_menu_placeholderabove
 header_margin_bgcolortransparent
 bottom_buttonbottom-buttons2
 personal_photo_shadow1
 header_designextended
 header_sizebig
 contact_no604-791- SOLD (7653)
 logo_designbig
 quick_question1
 bb_backgrond_color05_black.png
 call_today_textMain Office: 604-743-SOLD (7653) Chilliwack Office:
 is_show_phone_new_line1
 phone_alignmentcenter
 phone_row_backgroundtexture
 team_members_per_row1
 affiliates_per_row1
 domain_fontsize4.2
 domain_lineheight70
 socialmedia_margin75
 team_member_id240
 show_mls_logoshow
 socialmedia_size24x24
 slogan_fontPRISTINA
 custom_thank_you_messageThank you, you will be contacted shortly. Be sure to check your email and junkmail to gain access to your real estate search.
 background_designnew
 background_design_color05_black.png
 display_other_listings1
 listing_page_layoutnew
 listing_popup_stylenew
 send_leads_owner0
 video_share_buttonstraditional
 scroll_listing_member_address0
 enable_mobile_site1
 listings_display_opt_in1
 listings_sold0
 enable_cookie1
 top_producer_page_idSkdlbGRlcm1hbg==
 top_producer_assigned_to52131F4D-F3E8-430C-B470-51454349B68C
 top_producer_sourcePWP
 enable_social_media_opt_in_form0
 assign_leads_status0
 assign_leads_typedays
 assign_leads_interval10
 assign_leads_sechdule(null)
 sold_photo_scroll_type1
 sold_auto_scroll1
 sold_listing_slideshow_delay3000
 opt_in_after_listings2
 show_opt_in_after_listings0
 get_notofication_unsubscribe_leads0
 google_site_verification(null)
 pwp_lead_capture_api_key(null)
 address_type0
 custom_address(null)
 Photo
 id1398
 user_id240
 is_preset0
 title(null)
 header_file_name(null)
 photo_file_name430835_4622817182319_956811751_n.jpg
 logo_file_name(null)
 upload_file_name(null)
 gallery_file_name(null)
 created2014-06-18 13:10:32
 modified2014-06-18 13:10:32
- cookie
 nameCakeCookie
 time(null)
 path/
 domain(empty)
 secure(false)
 samesiteLax
 keyhFioX2Dpvd2idahoDiRpX2PYJADxnYHnhTQNrHak
 __values(empty)
 __typecipher
 __reset(null)
 __expires0
 enabled(true)
- profile_detail
 Profile
 id240
 user_id240
 first_nameJonathan
 last_nameGelderman
 phone(null)
 created2014-04-02 13:53:04
 modified2014-04-02 13:53:04
 titleSales Representative
 companyJonathan Gelderman, Personal Real Estate Corporation
 country_id1
 sites_allotted1
 affiliate_code(null)
 show_affiliate_button1
 address(null)
 city(null)
 state(null)
 nameJonathan Gelderman
- offer(empty)
- crea_feed_listings(empty)
- title_for_layoutFraser Valley Real Estate :: Gelderman.ca Real Estate Team
- currentVideo0
- showAffiliateButton1
- affiliateHash(null)
- sliderImages(empty)
- listings(empty)
- areas(empty)
- sold_listings
 0
 Listing
 id21429
 site_id282
 seller_id(null)
 buyer_id(null)
 visible1
 descriptiontest
 location(null)
 type(null)
 lot_dimensions(null)
 sewer(null)
 water(null)
 age(null)
 year_built(null)
 style(null)
 bedrooms(null)
 heating(null)
 bathrooms(null)
 map_display(null)
 sold0
 title(empty)
 address(null)
 banner0
 price(null)
 zoom14
 open_house_timing(null)
 order21429
 display_opt_in1
 display_other_listings1
 video(null)
 cre_property_id(null)
 cre_property_listingId(null)
 cre_propety_updatedtimestamp(null)
 cre_property_gallary_link(null)
 crea_listing_typepersonal
 crea_brokerage_name(null)
 is_crea_feed0
 is_active1
 is_sold_listing1
 area_id0
 created(null)
 modified(null)
 Site
 id282
 is_top_producer_enabled1
 titleGelderman.ca Real Estate Team
 subdomaingelderman
 domain(empty)
 user_id240
 color_theme_id281
 logo_id1345
 gallery_type_id1
 header_effect_id8
 header_slideshow_delay5000
 listing_slideshow_delay4500
 analytics_code(null)
 remarketing_code(null)
 adwords_conversion_code(null)
 facebook_remarketing_code(null)
 facebook_conversion_code(null)
 meta_description(null)
 meta_keywords(null)
 created2014-04-02 13:53:49
 modified2017-02-02 12:39:43
 active1
 coverflow_above0
 display_listings1
 display_opt_in1
 auto_scroll1
 header_menu_placeholderabove
 header_margin_bgcolortransparent
 bottom_buttonbottom-buttons2
 personal_photo_shadow1
 header_designextended
 header_sizebig
 contact_no604-791- SOLD (7653)
 logo_designbig
 quick_question1
 bb_backgrond_color05_black.png
 call_today_textMain Office: 604-743-SOLD (7653) Chilliwack Office:
 is_show_phone_new_line1
 phone_alignmentcenter
 phone_row_backgroundtexture
 team_members_per_row1
 affiliates_per_row1
 domain_fontsize4.2
 domain_lineheight70
 socialmedia_margin75
 team_member_id240
 show_mls_logoshow
 socialmedia_size24x24
 slogan_fontPRISTINA
 custom_thank_you_messageThank you, you will be contacted shortly. Be sure to check your email and junkmail to gain access to your real estate search.
 background_designnew
 background_design_color05_black.png
 display_other_listings1
 listing_page_layoutnew
 listing_popup_stylenew
 send_leads_owner0
 video_share_buttonstraditional
 scroll_listing_member_address0
 enable_mobile_site1
 listings_display_opt_in1
 listings_sold0
 enable_cookie1
 top_producer_page_idSkdlbGRlcm1hbg==
 top_producer_assigned_to52131F4D-F3E8-430C-B470-51454349B68C
 top_producer_sourcePWP
 enable_social_media_opt_in_form0
 assign_leads_status0
 assign_leads_typedays
 assign_leads_interval10
 assign_leads_sechdule(null)
 sold_photo_scroll_type1
 sold_auto_scroll1
 sold_listing_slideshow_delay3000
 opt_in_after_listings2
 show_opt_in_after_listings0
 get_notofication_unsubscribe_leads0
 google_site_verification(null)
 pwp_lead_capture_api_key(null)
 address_type0
 custom_address(null)
 Image(empty)
- layoutdefault
- bodyClassdefault
- countryCodeca
- reportFile(false)
- contentBlocks
 0
 id1114
 site_id282
 content_block_type_id1
 contentJonathan Gelderman
 1
 id1115
 site_id282
 content_block_type_id2
 contentPersonal Real Estate Corporation
 2
 id1116
 site_id282
 content_block_type_id3
 contentJonathan Gelderman, Personal Real Estate Corporation
 3
 id1117
 site_id282
 content_block_type_id4
 contentYour Home Sold in 35 Days Or We'll Pay You Cash!!
- logo
 CustomLogosSite
 id4332
 site_id282
 photo_id1345
 header_order(null)
 gallery_order(null)
 crop_x(null)
 crop_y(null)
 crop_x2(null)
 crop_y2(null)
 description(null)
 is_includephoto_frontend0
 header_photo_link(null)
 is_showphoto_otherusers0
 crop_width(null)
 crop_height(null)
 Logo
 id1345
 user_id240
 is_preset0
 titleRE/MAX Aldercentre
 header_file_name(null)
 photo_file_name(null)
 logo_file_nameremaxaldercenter.jpg
 upload_file_name(null)
 gallery_file_name(null)
 created2014-04-05 13:01:36
 modified2014-04-05 13:01:36
- contentPage
 ContentPage
 id11373
 site_id282
 link_id(null)
 optin_enabled0
 titleFraser Valley Real Estate
 slughome
 contentWelcome to the Fraser Valley’s most comprehensive Real Estate website! Our unique client based approach to real estate ensures that our listings are the best marketed and our clients the best serviced in the Fraser Valley! Real Estate Agent Jonathan Gelderman, Personal Real Estate Corporation and the Gelderman.ca Real Estate Team are one of the Fraser Valley’s top producing teams, selling residential, commercial, multi-family, and investment properties. Please browse our website, check out our listings, and contact us with any questions that you have!   <a title="Gelderman.ca Real Estate Team Facebook Page" href="https://www.facebook.com/pages/Geldermanca-Real-Estate-Team/211555467092" target="_blank"><img src="http://i990.photobucket.com/albums/af25/katie-gelderman/facebook_zps583fec34.png" alt="" width="40" height="40" /></a> <a title="Gelderman Team Twitter" href="https://twitter.com/geldermanteam" target="_blank"><img src="http://i990.photobucket.com/albums/af25/katie-gelderman/twitter-logo_zpsf382c2e0.png" alt="" width="40" height="40" /></a>   Serving Abbotsford, Chilliwack, Mission, Aldergrove and Langley in the Fraser Valley.
 custom_thank_you_message(empty)
 is_show_custom_thanks_message0
 created2014-04-02 13:54:02
 modified2014-05-14 16:36:12
 description(null)
 team_members0
 external_embed_script(empty)
 calculator(empty)
 affiliates0
 external_frame_link(empty)
 video(empty)
 is_hide_default_report_pdf1
 is_display_video0
 is_show_sold_listings0
 is_home_evaluation0
 Site
 id282
 is_top_producer_enabled1
 titleGelderman.ca Real Estate Team
 subdomaingelderman
 domain(empty)
 user_id240
 color_theme_id281
 logo_id1345
 gallery_type_id1
 header_effect_id8
 header_slideshow_delay5000
 listing_slideshow_delay4500
 analytics_code(null)
 remarketing_code(null)
 adwords_conversion_code(null)
 facebook_remarketing_code(null)
 facebook_conversion_code(null)
 meta_description(null)
 meta_keywords(null)
 created2014-04-02 13:53:49
 modified2017-02-02 12:39:43
 active1
 coverflow_above0
 display_listings1
 display_opt_in1
 auto_scroll1
 header_menu_placeholderabove
 header_margin_bgcolortransparent
 bottom_buttonbottom-buttons2
 personal_photo_shadow1
 header_designextended
 header_sizebig
 contact_no604-791- SOLD (7653)
 logo_designbig
 quick_question1
 bb_backgrond_color05_black.png
 call_today_textMain Office: 604-743-SOLD (7653) Chilliwack Office:
 is_show_phone_new_line1
 phone_alignmentcenter
 phone_row_backgroundtexture
 team_members_per_row1
 affiliates_per_row1
 domain_fontsize4.2
 domain_lineheight70
 socialmedia_margin75
 team_member_id240
 show_mls_logoshow
 socialmedia_size24x24
 slogan_fontPRISTINA
 custom_thank_you_messageThank you, you will be contacted shortly. Be sure to check your email and junkmail to gain access to your real estate search.
 background_designnew
 background_design_color05_black.png
 display_other_listings1
 listing_page_layoutnew
 listing_popup_stylenew
 send_leads_owner0
 video_share_buttonstraditional
 scroll_listing_member_address0
 enable_mobile_site1
 listings_display_opt_in1
 listings_sold0
 enable_cookie1
 top_producer_page_idSkdlbGRlcm1hbg==
 top_producer_assigned_to52131F4D-F3E8-430C-B470-51454349B68C
 top_producer_sourcePWP
 enable_social_media_opt_in_form0
 assign_leads_status0
 assign_leads_typedays
 assign_leads_interval10
 assign_leads_sechdule(null)
 sold_photo_scroll_type1
 sold_auto_scroll1
 sold_listing_slideshow_delay3000
 opt_in_after_listings2
 show_opt_in_after_listings0
 get_notofication_unsubscribe_leads0
 google_site_verification(null)
 pwp_lead_capture_api_key(null)
 address_type0
 custom_address(null)
 Link
 id(null)
 content_page_id(null)
 link_type_id(null)
 site_id(null)
 url(null)
 target_blank(null)
 created(null)
 modified(null)
- videos
 0
 SitesVideo
 id639
 site_id282
 video_id638
 order0
 Video
 id638
 user_id240
 videoWpVVjtuFWSQ
 created2014-04-05 12:49:54
 modified2014-04-23 13:58:49
 1
 SitesVideo
 id659
 site_id282
 video_id658
 order1
 Video
 id658
 user_id240
 video7w2LA9H0aQE
 created2014-05-26 16:31:07
 modified2014-05-26 16:31:07
 2
 SitesVideo
 id658
 site_id282
 video_id657
 order2
 Video
 id657
 user_id240
 videoK71RksAVhGc
 created2014-05-26 16:30:23
 modified2014-05-26 16:30:23
 3
 SitesVideo
 id657
 site_id282
 video_id656
 order3
 Video
 id656
 user_id240
 videouortNhGKn0o
 created2014-05-26 16:30:05
 modified2014-05-26 16:30:05
 4
 SitesVideo
 id656
 site_id282
 video_id655
 order4
 Video
 id655
 user_id240
 videoG3H_d2jY0QM
 created2014-05-26 16:29:49
 modified2014-05-26 16:29:49
- billbord
 0
 MenuItem
 id6214
 menu_type_id4
 link_id11054
 site_id282
 titleNew Listing Alert!
 subtitle(null)
 order1
 button_pic(null)
 button_description(empty)
 status1
 created2014-04-02 13:54:03
 modified2014-04-02 13:54:03
 Link
 url(null)
 target_blank0
 content_page_id11384
 link_type_id1
 id11054
 ContentPage
 slugnew-listing-alert
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
 1
 MenuItem
 id6215
 menu_type_id4
 link_id11056
 site_id282
 titleMLS® Home Search
 subtitle(null)
 order2
 button_pic(null)
 button_description(empty)
 status1
 created2014-04-02 13:54:03
 modified2014-04-02 13:54:03
 Link
 url(null)
 target_blank0
 content_page_id11385
 link_type_id1
 id11056
 ContentPage
 slugmls-home-search
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
 2
 MenuItem
 id6216
 menu_type_id4
 link_id11058
 site_id282
 titleFree Online Evaluation
 subtitle(null)
 order3
 button_pic(null)
 button_description(empty)
 status1
 created2014-04-02 13:54:03
 modified2014-04-16 12:46:37
 Link
 url(empty)
 target_blank0
 content_page_id11386
 link_type_id1
 id11058
 ContentPage
 slugfree-home-evaluation
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
- footerLinks(empty)
- bottomMenuItems
 0
 MenuItem
 id6204
 menu_type_id2
 link_id11039
 site_id282
 titleHot New Listings
 subtitleBuyers
 order1
 button_pic1371825598_HotNewListings.png
 button_descriptionEvery serious buyer wants to gain access the best and most recent listings on the market and until now this has never been easy. Click here to start your search to hottest new listings on the market.
 status1
 created2014-04-02 13:54:02
 modified2014-04-02 13:54:02
 Link
 url(null)
 target_blank0
 content_page_id11366
 link_type_id1
 id11039
 ContentPage
 slughot-new-listings
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
 1
 MenuItem
 id6210
 menu_type_id2
 link_id11048
 site_id282
 titleYour Area Prices
 subtitleBuyer / Seller
 order2
 button_pic1371825653_SeePricesInYourArea.jpg
 button_descriptionDo you want to see what the price of the home down the road is, or what it sold for? Perhaps you are just curious, or you really need this information because you are getting ready to buy or sell.
 status1
 created2014-04-02 13:54:02
 modified2014-04-02 13:54:02
 Link
 url(null)
 target_blank0
 content_page_id11379
 link_type_id1
 id11048
 ContentPage
 slugprices-in-your-area
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
 2
 MenuItem
 id6205
 menu_type_id2
 link_id11041
 site_id282
 titleHiring a Real Estate Professional®
 subtitleSpecial Report
 order3
 button_pic1371825720_HiringARealtor.jpeg
 button_descriptionNot all Real Estate Professionals are the same, before you seek the help of a Real Estate Professional here is a list of some very important questions that you will need when making this very important decision.
 status1
 created2014-04-02 13:54:02
 modified2014-04-02 13:54:02
 Link
 url(null)
 target_blank0
 content_page_id11368
 link_type_id1
 id11041
 ContentPage
 slughiring-a-realtor
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
 3
 MenuItem
 id6203
 menu_type_id2
 link_id11037
 site_id282
 titleDistress Sales
 subtitleBuyers
 order4
 button_pic1371825801_DistressSales.jpeg
 button_descriptionDistress sales often resulting from bank foreclosures and other situations can often lead to one of the one of the best ways to find a great deal on a home. Let us know what you are looking for.
 status1
 created2014-04-02 13:54:02
 modified2014-04-02 13:54:02
 Link
 url(null)
 target_blank0
 content_page_id11364
 link_type_id1
 id11037
 ContentPage
 slugdistress-sales
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
 4
 MenuItem
 id6196
 menu_type_id2
 link_id11022
 site_id282
 title29 Essential Tips
 subtitleSellers
 order5
 button_pic1371825886_29EssentialTips.jpeg
 button_descriptionIn this report you will learn the power of well-kept secrets, when you should or should not pass along information to the buyer, fixing & repair tips, the emotional side of selling and much more.
 status1
 created2014-04-02 13:54:01
 modified2014-04-02 13:54:01
 Link
 url(null)
 target_blank0
 content_page_id11348
 link_type_id1
 id11022
 ContentPage
 slug29-essential-tips
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
 5
 MenuItem
 id6206
 menu_type_id2
 link_id11043
 site_id282
 titleLegal Issues
 subtitleSpecial Report
 order6
 button_pic1371826492_CostlyLegalIssues.jpeg
 button_descriptionWhen you're buying or selling a home, there are many small but important legal issues that you may be unaware of that are, nevertheless, critical and imortant to your sale.
 status1
 created2014-04-02 13:54:02
 modified2014-04-02 13:54:02
 Link
 url(null)
 target_blank0
 content_page_id11370
 link_type_id1
 id11043
 ContentPage
 slugcostly-legal-issues
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
 6
 MenuItem
 id6202
 menu_type_id2
 link_id11035
 site_id282
 titleWhy Pay Rent?
 subtitleBuyers
 order7
 button_pic1371826408_WhyPay-rent.jpg
 button_descriptionIf you're like most renters, you feel trapped within the walls of a house or apartment that doesn't feel like yours. How could it when you're not even permitted to bang in a nail or two without a hassle?
 status1
 created2014-04-02 13:54:02
 modified2014-04-02 13:54:02
 Link
 url(null)
 target_blank0
 content_page_id11362
 link_type_id1
 id11035
 ContentPage
 slugwhy-pay-rent
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
 7
 MenuItem
 id6200
 menu_type_id2
 link_id11030
 site_id282
 titleSelling Privately
 subtitleSellers
 order8
 button_pic1371826430_PrivateSellers.jpeg
 button_descriptionThe minute you put the "For Sale by Owner" sign up, the phone will start ringing off the hook. Unfortunately, most calls are not from prospective buyers, but rather from every Real Estate Professional who will...
 status1
 created2014-04-02 13:54:01
 modified2014-04-02 13:54:01
 Link
 url(null)
 target_blank0
 content_page_id11356
 link_type_id1
 id11030
 ContentPage
 slugselling-privately
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
 8
 MenuItem
 id6197
 menu_type_id2
 link_id11024
 site_id282
 title9 Buying Traps
 subtitleSpecial Report
 order9
 button_pic1371826221_9buyer_traps.jpg
 button_descriptionBuying a home is a major investment no matter which way you look at it. But for many homebuyers, it's an even more expensive process than it needs to be because of these mistakes.
 status1
 created2014-04-02 13:54:01
 modified2014-04-02 13:54:01
 Link
 url(null)
 target_blank0
 content_page_id11350
 link_type_id1
 id11024
 ContentPage
 slug9-major-buying-traps
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
 9
 MenuItem
 id6198
 menu_type_id2
 link_id11026
 site_id282
 titlePay Much Less!
 subtitleBuyers
 order10
 button_pic1371830503_AvoidPayingToMuch.jpg
 button_descriptionNegotiating skills are important, however there are many myths that are blown right out of the water in this special report. Along with negotiating there are several other factors that must be considered.
 status1
 created2014-04-02 13:54:01
 modified2014-04-02 13:54:01
 Link
 url(null)
 target_blank0
 content_page_id11352
 link_type_id1
 id11026
 ContentPage
 slugavoid-paying-too-much
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
 10
 MenuItem
 id6201
 menu_type_id2
 link_id11032
 site_id282
 titleHome Didn't Sell?
 subtitleSellers
 order11
 button_pic1371826154_YourHomeDidNotSell.jpeg
 button_descriptionIf your Property just come off the market and did not sell, don't be discouraged. The reason your home did not sell may have nothing to do with your home or the current market. In reality...
 status1
 created2014-04-02 13:54:02
 modified2014-04-02 13:54:02
 Link
 url(null)
 target_blank0
 content_page_id11358
 link_type_id1
 id11032
 ContentPage
 slugyour-home-didnt-sell
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
 11
 MenuItem
 id6199
 menu_type_id2
 link_id11028
 site_id282
 title4 Seller Mistakes
 subtitleSpecial Report
 order12
 button_pic1371825976_4BigSellerMistkes.jpeg
 button_descriptionThe system we follow has been outlined in a new FREE special report outlining the 4 common mistakes most homesellers make when negotiating the price they will sell for.
 status1
 created2014-04-02 13:54:01
 modified2014-04-02 13:54:01
 Link
 url(null)
 target_blank0
 content_page_id11354
 link_type_id1
 id11028
 ContentPage
 slug4-big-seller-mistakes
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
- topMenuItems
 0
 MenuItem
 id6207
 menu_type_id1
 link_id11045
 site_id282
 titleHome
 subtitle(null)
 order0
 button_pic(null)
 button_description(empty)
 status1
 created2014-04-02 13:54:02
 modified2014-05-12 17:34:17
 Link
 url(null)
 target_blank0
 content_page_id11373
 link_type_id1
 id11045
 ContentPage
 slughome
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
 1
 MenuItem
 id6211
 menu_type_id1
 link_id11049
 site_id282
 titleMeet The Team
 subtitle(null)
 order1
 button_pic(null)
 button_description(empty)
 status1
 created2014-04-02 13:54:02
 modified2014-05-12 17:34:17
 Link
 url(empty)
 target_blank0
 content_page_id11380
 link_type_id1
 id11049
 ContentPage
 slugabout-us
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
 2
 MenuItem
 id6212
 menu_type_id1
 link_id11050
 site_id282
 titleBlog
 subtitle(null)
 order2
 button_pic(null)
 button_description(empty)
 status1
 created2014-04-02 13:54:03
 modified2014-05-12 17:34:17
 Link
 urljonathan-gelderman.blogspot.ca
 target_blank0
 content_page_id11381
 link_type_id2
 id11050
 ContentPage
 slugblog
 LinkType
 abbrevexternal
 Site
 subdomaingelderman
 3
 MenuItem
 id6217
 menu_type_id1
 link_id11059
 site_id282
 titleWhat Others Say
 subtitle(null)
 order3
 button_pic(null)
 button_description(empty)
 status1
 created2014-04-05 08:24:41
 modified2014-05-12 17:34:17
 Link
 url(empty)
 target_blank0
 content_page_id11374
 link_type_id1
 id11059
 ContentPage
 slugwhat-others-say
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
 4
 MenuItem
 id6218
 menu_type_id1
 link_id11060
 site_id282
 titleAchievements
 subtitle(null)
 order4
 button_pic(null)
 button_description(empty)
 status1
 created2014-04-07 00:55:17
 modified2014-05-12 17:34:17
 Link
 urlwww.gelderman.ca/awards
 target_blank1
 content_page_id11431
 link_type_id1
 id11060
 ContentPage
 slugawards
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
 5
 MenuItem
 id6213
 menu_type_id1
 link_id11052
 site_id282
 titleOur Listings
 subtitle(null)
 order5
 button_pic(null)
 button_description(empty)
 status1
 created2014-04-02 13:54:03
 modified2014-05-12 17:34:17
 Link
 url(empty)
 target_blank0
 content_page_id11383
 link_type_id1
 id11052
 ContentPage
 slugview-listings
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
 6
 MenuItem
 id6195
 menu_type_id1
 link_id11020
 site_id282
 titleWhy Gelderman.ca
 subtitle(null)
 order6
 button_pic(null)
 button_description(empty)
 status1
 created2014-04-02 13:54:01
 modified2014-05-12 17:34:17
 Link
 url(empty)
 target_blank0
 content_page_id11439
 link_type_id1
 id11020
 ContentPage
 slugsell-your-home-faster-more-money
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
 7
 MenuItem
 id6208
 menu_type_id1
 link_id11046
 site_id282
 titleCalculators
 subtitle(null)
 order7
 button_pic(null)
 button_description(empty)
 status1
 created2014-04-02 13:54:02
 modified2014-05-12 17:34:17
 Link
 url(empty)
 target_blank0
 content_page_id11376
 link_type_id1
 id11046
 ContentPage
 slugmortgage-calculator
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
 8
 MenuItem
 id6209
 menu_type_id1
 link_id11047
 site_id282
 titleContact Us
 subtitle(null)
 order8
 button_pic(null)
 button_description(empty)
 status1
 created2014-04-02 13:54:02
 modified2014-05-12 17:34:17
 Link
 url(empty)
 target_blank0
 content_page_id11377
 link_type_id1
 id11047
 ContentPage
 slugcontact-us
 LinkType
 abbrevinternal
 Site
 subdomaingelderman
- headerEffectwaterfall
- headerPhotos
 0
 HeaderPhoto
 id4632
 site_id282
 photo_id1450
 header_order0
 gallery_order(null)
 crop_x(null)
 crop_y(null)
 crop_x2(null)
 crop_y2(null)
 description(empty)
 is_includephoto_frontend1
 header_photo_link(empty)
 is_showphoto_otherusers0
 crop_width(null)
 crop_height(null)
 Site
 id282
 is_top_producer_enabled1
 titleGelderman.ca Real Estate Team
 subdomaingelderman
 domain(empty)
 user_id240
 color_theme_id281
 logo_id1345
 gallery_type_id1
 header_effect_id8
 header_slideshow_delay5000
 listing_slideshow_delay4500
 analytics_code(null)
 remarketing_code(null)
 adwords_conversion_code(null)
 facebook_remarketing_code(null)
 facebook_conversion_code(null)
 meta_description(null)
 meta_keywords(null)
 created2014-04-02 13:53:49
 modified2017-02-02 12:39:43
 active1
 coverflow_above0
 display_listings1
 display_opt_in1
 auto_scroll1
 header_menu_placeholderabove
 header_margin_bgcolortransparent
 bottom_buttonbottom-buttons2
 personal_photo_shadow1
 header_designextended
 header_sizebig
 contact_no604-791- SOLD (7653)
 logo_designbig
 quick_question1
 bb_backgrond_color05_black.png
 call_today_textMain Office: 604-743-SOLD (7653) Chilliwack Office:
 is_show_phone_new_line1
 phone_alignmentcenter
 phone_row_backgroundtexture
 team_members_per_row1
 affiliates_per_row1
 domain_fontsize4.2
 domain_lineheight70
 socialmedia_margin75
 team_member_id240
 show_mls_logoshow
 socialmedia_size24x24
 slogan_fontPRISTINA
 custom_thank_you_messageThank you, you will be contacted shortly. Be sure to check your email and junkmail to gain access to your real estate search.
 background_designnew
 background_design_color05_black.png
 display_other_listings1
 listing_page_layoutnew
 listing_popup_stylenew
 send_leads_owner0
 video_share_buttonstraditional
 scroll_listing_member_address0
 enable_mobile_site1
 listings_display_opt_in1
 listings_sold0
 enable_cookie1
 top_producer_page_idSkdlbGRlcm1hbg==
 top_producer_assigned_to52131F4D-F3E8-430C-B470-51454349B68C
 top_producer_sourcePWP
 enable_social_media_opt_in_form0
 assign_leads_status0
 assign_leads_typedays
 assign_leads_interval10
 assign_leads_sechdule(null)
 sold_photo_scroll_type1
 sold_auto_scroll1
 sold_listing_slideshow_delay3000
 opt_in_after_listings2
 show_opt_in_after_listings0
 get_notofication_unsubscribe_leads0
 google_site_verification(null)
 pwp_lead_capture_api_key(null)
 address_type0
 custom_address(null)
 Photo
 id1450
 user_id240
 is_preset0
 title(null)
 header_file_name15_Gelderman_Header_awards.jpg
 photo_file_name(null)
 logo_file_name(null)
 upload_file_name(null)
 gallery_file_name(null)
 created2015-01-20 17:19:32
 modified2015-01-20 17:19:32
 1
 HeaderPhoto
 id4395
 site_id282
 photo_id677
 header_order1
 gallery_order(null)
 crop_x(null)
 crop_y(null)
 crop_x2(null)
 crop_y2(null)
 descriptionhow to sell your home, tips for selling your home, tricks and hints, sell your home, sell a house
 is_includephoto_frontend1
 header_photo_linkhttp://gelderman.performancewebpage.com/your-home-didnt-sell
 is_showphoto_otherusers0
 crop_width(null)
 crop_height(null)
 Site
 id282
 is_top_producer_enabled1
 titleGelderman.ca Real Estate Team
 subdomaingelderman
 domain(empty)
 user_id240
 color_theme_id281
 logo_id1345
 gallery_type_id1
 header_effect_id8
 header_slideshow_delay5000
 listing_slideshow_delay4500
 analytics_code(null)
 remarketing_code(null)
 adwords_conversion_code(null)
 facebook_remarketing_code(null)
 facebook_conversion_code(null)
 meta_description(null)
 meta_keywords(null)
 created2014-04-02 13:53:49
 modified2017-02-02 12:39:43
 active1
 coverflow_above0
 display_listings1
 display_opt_in1
 auto_scroll1
 header_menu_placeholderabove
 header_margin_bgcolortransparent
 bottom_buttonbottom-buttons2
 personal_photo_shadow1
 header_designextended
 header_sizebig
 contact_no604-791- SOLD (7653)
 logo_designbig
 quick_question1
 bb_backgrond_color05_black.png
 call_today_textMain Office: 604-743-SOLD (7653) Chilliwack Office:
 is_show_phone_new_line1
 phone_alignmentcenter
 phone_row_backgroundtexture
 team_members_per_row1
 affiliates_per_row1
 domain_fontsize4.2
 domain_lineheight70
 socialmedia_margin75
 team_member_id240
 show_mls_logoshow
 socialmedia_size24x24
 slogan_fontPRISTINA
 custom_thank_you_messageThank you, you will be contacted shortly. Be sure to check your email and junkmail to gain access to your real estate search.
 background_designnew
 background_design_color05_black.png
 display_other_listings1
 listing_page_layoutnew
 listing_popup_stylenew
 send_leads_owner0
 video_share_buttonstraditional
 scroll_listing_member_address0
 enable_mobile_site1
 listings_display_opt_in1
 listings_sold0
 enable_cookie1
 top_producer_page_idSkdlbGRlcm1hbg==
 top_producer_assigned_to52131F4D-F3E8-430C-B470-51454349B68C
 top_producer_sourcePWP
 enable_social_media_opt_in_form0
 assign_leads_status0
 assign_leads_typedays
 assign_leads_interval10
 assign_leads_sechdule(null)
 sold_photo_scroll_type1
 sold_auto_scroll1
 sold_listing_slideshow_delay3000
 opt_in_after_listings2
 show_opt_in_after_listings0
 get_notofication_unsubscribe_leads0
 google_site_verification(null)
 pwp_lead_capture_api_key(null)
 address_type0
 custom_address(null)
 Photo
 id677
 user_id2
 is_preset0
 title(null)
 header_file_nameYour_Home_Did_5.png
 photo_file_name(null)
 logo_file_name(null)
 upload_file_name(null)
 gallery_file_name(null)
 created2012-08-09 09:16:00
 modified2012-08-09 09:16:00
 2
 HeaderPhoto
 id4400
 site_id282
 photo_id627
 header_order2
 gallery_order(null)
 crop_x(null)
 crop_y(null)
 crop_x2(null)
 crop_y2(null)
 descriptionnew listings, real estate for sale, property for sale, homes for sale, mls listings
 is_includephoto_frontend1
 header_photo_linkhttp://gelderman.performancewebpage.com/hot-new-listings
 is_showphoto_otherusers0
 crop_width(null)
 crop_height(null)
 Site
 id282
 is_top_producer_enabled1
 titleGelderman.ca Real Estate Team
 subdomaingelderman
 domain(empty)
 user_id240
 color_theme_id281
 logo_id1345
 gallery_type_id1
 header_effect_id8
 header_slideshow_delay5000
 listing_slideshow_delay4500
 analytics_code(null)
 remarketing_code(null)
 adwords_conversion_code(null)
 facebook_remarketing_code(null)
 facebook_conversion_code(null)
 meta_description(null)
 meta_keywords(null)
 created2014-04-02 13:53:49
 modified2017-02-02 12:39:43
 active1
 coverflow_above0
 display_listings1
 display_opt_in1
 auto_scroll1
 header_menu_placeholderabove
 header_margin_bgcolortransparent
 bottom_buttonbottom-buttons2
 personal_photo_shadow1
 header_designextended
 header_sizebig
 contact_no604-791- SOLD (7653)
 logo_designbig
 quick_question1
 bb_backgrond_color05_black.png
 call_today_textMain Office: 604-743-SOLD (7653) Chilliwack Office:
 is_show_phone_new_line1
 phone_alignmentcenter
 phone_row_backgroundtexture
 team_members_per_row1
 affiliates_per_row1
 domain_fontsize4.2
 domain_lineheight70
 socialmedia_margin75
 team_member_id240
 show_mls_logoshow
 socialmedia_size24x24
 slogan_fontPRISTINA
 custom_thank_you_messageThank you, you will be contacted shortly. Be sure to check your email and junkmail to gain access to your real estate search.
 background_designnew
 background_design_color05_black.png
 display_other_listings1
 listing_page_layoutnew
 listing_popup_stylenew
 send_leads_owner0
 video_share_buttonstraditional
 scroll_listing_member_address0
 enable_mobile_site1
 listings_display_opt_in1
 listings_sold0
 enable_cookie1
 top_producer_page_idSkdlbGRlcm1hbg==
 top_producer_assigned_to52131F4D-F3E8-430C-B470-51454349B68C
 top_producer_sourcePWP
 enable_social_media_opt_in_form0
 assign_leads_status0
 assign_leads_typedays
 assign_leads_interval10
 assign_leads_sechdule(null)
 sold_photo_scroll_type1
 sold_auto_scroll1
 sold_listing_slideshow_delay3000
 opt_in_after_listings2
 show_opt_in_after_listings0
 get_notofication_unsubscribe_leads0
 google_site_verification(null)
 pwp_lead_capture_api_key(null)
 address_type0
 custom_address(null)
 Photo
 id627
 user_id2
 is_preset0
 title(null)
 header_file_namebanner_1.jpg
 photo_file_name(null)
 logo_file_name(null)
 upload_file_name(null)
 gallery_file_name(null)
 created2012-08-08 12:03:50
 modified2012-08-08 12:03:50
 3
 HeaderPhoto
 id4631
 site_id282
 photo_id1449
 header_order3
 gallery_order(null)
 crop_x(null)
 crop_y(null)
 crop_x2(null)
 crop_y2(null)
 description(empty)
 is_includephoto_frontend1
 header_photo_link(empty)
 is_showphoto_otherusers0
 crop_width(null)
 crop_height(null)
 Site
 id282
 is_top_producer_enabled1
 titleGelderman.ca Real Estate Team
 subdomaingelderman
 domain(empty)
 user_id240
 color_theme_id281
 logo_id1345
 gallery_type_id1
 header_effect_id8
 header_slideshow_delay5000
 listing_slideshow_delay4500
 analytics_code(null)
 remarketing_code(null)
 adwords_conversion_code(null)
 facebook_remarketing_code(null)
 facebook_conversion_code(null)
 meta_description(null)
 meta_keywords(null)
 created2014-04-02 13:53:49
 modified2017-02-02 12:39:43
 active1
 coverflow_above0
 display_listings1
 display_opt_in1
 auto_scroll1
 header_menu_placeholderabove
 header_margin_bgcolortransparent
 bottom_buttonbottom-buttons2
 personal_photo_shadow1
 header_designextended
 header_sizebig
 contact_no604-791- SOLD (7653)
 logo_designbig
 quick_question1
 bb_backgrond_color05_black.png
 call_today_textMain Office: 604-743-SOLD (7653) Chilliwack Office:
 is_show_phone_new_line1
 phone_alignmentcenter
 phone_row_backgroundtexture
 team_members_per_row1
 affiliates_per_row1
 domain_fontsize4.2
 domain_lineheight70
 socialmedia_margin75
 team_member_id240
 show_mls_logoshow
 socialmedia_size24x24
 slogan_fontPRISTINA
 custom_thank_you_messageThank you, you will be contacted shortly. Be sure to check your email and junkmail to gain access to your real estate search.
 background_designnew
 background_design_color05_black.png
 display_other_listings1
 listing_page_layoutnew
 listing_popup_stylenew
 send_leads_owner0
 video_share_buttonstraditional
 scroll_listing_member_address0
 enable_mobile_site1
 listings_display_opt_in1
 listings_sold0
 enable_cookie1
 top_producer_page_idSkdlbGRlcm1hbg==
 top_producer_assigned_to52131F4D-F3E8-430C-B470-51454349B68C
 top_producer_sourcePWP
 enable_social_media_opt_in_form0
 assign_leads_status0
 assign_leads_typedays
 assign_leads_interval10
 assign_leads_sechdule(null)
 sold_photo_scroll_type1
 sold_auto_scroll1
 sold_listing_slideshow_delay3000
 opt_in_after_listings2
 show_opt_in_after_listings0
 get_notofication_unsubscribe_leads0
 google_site_verification(null)
 pwp_lead_capture_api_key(null)
 address_type0
 custom_address(null)
 Photo
 id1449
 user_id240
 is_preset0
 title(null)
 header_file_name15_Gelderman_Header_awards.jpg
 photo_file_name(null)
 logo_file_name(null)
 upload_file_name(null)
 gallery_file_name(null)
 created2015-01-20 17:18:49
 modified2015-01-20 17:18:49
 4
 HeaderPhoto
 id4396
 site_id282
 photo_id668
 header_order4
 gallery_order(null)
 crop_x(null)
 crop_y(null)
 crop_x2(null)
 crop_y2(null)
 descriptionsell your home, tips to sell your home, tricks, hints, how to sell a house
 is_includephoto_frontend1
 header_photo_linkhttp://gelderman.performancewebpage.com/29-essential-tips
 is_showphoto_otherusers0
 crop_width(null)
 crop_height(null)
 Site
 id282
 is_top_producer_enabled1
 titleGelderman.ca Real Estate Team
 subdomaingelderman
 domain(empty)
 user_id240
 color_theme_id281
 logo_id1345
 gallery_type_id1
 header_effect_id8
 header_slideshow_delay5000
 listing_slideshow_delay4500
 analytics_code(null)
 remarketing_code(null)
 adwords_conversion_code(null)
 facebook_remarketing_code(null)
 facebook_conversion_code(null)
 meta_description(null)
 meta_keywords(null)
 created2014-04-02 13:53:49
 modified2017-02-02 12:39:43
 active1
 coverflow_above0
 display_listings1
 display_opt_in1
 auto_scroll1
 header_menu_placeholderabove
 header_margin_bgcolortransparent
 bottom_buttonbottom-buttons2
 personal_photo_shadow1
 header_designextended
 header_sizebig
 contact_no604-791- SOLD (7653)
 logo_designbig
 quick_question1
 bb_backgrond_color05_black.png
 call_today_textMain Office: 604-743-SOLD (7653) Chilliwack Office:
 is_show_phone_new_line1
 phone_alignmentcenter
 phone_row_backgroundtexture
 team_members_per_row1
 affiliates_per_row1
 domain_fontsize4.2
 domain_lineheight70
 socialmedia_margin75
 team_member_id240
 show_mls_logoshow
 socialmedia_size24x24
 slogan_fontPRISTINA
 custom_thank_you_messageThank you, you will be contacted shortly. Be sure to check your email and junkmail to gain access to your real estate search.
 background_designnew
 background_design_color05_black.png
 display_other_listings1
 listing_page_layoutnew
 listing_popup_stylenew
 send_leads_owner0
 video_share_buttonstraditional
 scroll_listing_member_address0
 enable_mobile_site1
 listings_display_opt_in1
 listings_sold0
 enable_cookie1
 top_producer_page_idSkdlbGRlcm1hbg==
 top_producer_assigned_to52131F4D-F3E8-430C-B470-51454349B68C
 top_producer_sourcePWP
 enable_social_media_opt_in_form0
 assign_leads_status0
 assign_leads_typedays
 assign_leads_interval10
 assign_leads_sechdule(null)
 sold_photo_scroll_type1
 sold_auto_scroll1
 sold_listing_slideshow_delay3000
 opt_in_after_listings2
 show_opt_in_after_listings0
 get_notofication_unsubscribe_leads0
 google_site_verification(null)
 pwp_lead_capture_api_key(null)
 address_type0
 custom_address(null)
 Photo
 id668
 user_id2
 is_preset0
 title(null)
 header_file_name29_Essential_Tips_5.png
 photo_file_name(null)
 logo_file_name(null)
 upload_file_name(null)
 gallery_file_name(null)
 created2012-08-09 09:11:08
 modified2012-08-09 09:11:08
 5
 HeaderPhoto
 id4398
 site_id282
 photo_id665
 header_order5
 gallery_order(null)
 crop_x(null)
 crop_y(null)
 crop_x2(null)
 crop_y2(null)
 descriptionwhat is my home worth, home evaluation, market evaluation, real estate evaluation
 is_includephoto_frontend1
 header_photo_linkhttp://gelderman.performancewebpage.com/free-home-evaluation
 is_showphoto_otherusers0
 crop_width(null)
 crop_height(null)
 Site
 id282
 is_top_producer_enabled1
 titleGelderman.ca Real Estate Team
 subdomaingelderman
 domain(empty)
 user_id240
 color_theme_id281
 logo_id1345
 gallery_type_id1
 header_effect_id8
 header_slideshow_delay5000
 listing_slideshow_delay4500
 analytics_code(null)
 remarketing_code(null)
 adwords_conversion_code(null)
 facebook_remarketing_code(null)
 facebook_conversion_code(null)
 meta_description(null)
 meta_keywords(null)
 created2014-04-02 13:53:49
 modified2017-02-02 12:39:43
 active1
 coverflow_above0
 display_listings1
 display_opt_in1
 auto_scroll1
 header_menu_placeholderabove
 header_margin_bgcolortransparent
 bottom_buttonbottom-buttons2
 personal_photo_shadow1
 header_designextended
 header_sizebig
 contact_no604-791- SOLD (7653)
 logo_designbig
 quick_question1
 bb_backgrond_color05_black.png
 call_today_textMain Office: 604-743-SOLD (7653) Chilliwack Office:
 is_show_phone_new_line1
 phone_alignmentcenter
 phone_row_backgroundtexture
 team_members_per_row1
 affiliates_per_row1
 domain_fontsize4.2
 domain_lineheight70
 socialmedia_margin75
 team_member_id240
 show_mls_logoshow
 socialmedia_size24x24
 slogan_fontPRISTINA
 custom_thank_you_messageThank you, you will be contacted shortly. Be sure to check your email and junkmail to gain access to your real estate search.
 background_designnew
 background_design_color05_black.png
 display_other_listings1
 listing_page_layoutnew
 listing_popup_stylenew
 send_leads_owner0
 video_share_buttonstraditional
 scroll_listing_member_address0
 enable_mobile_site1
 listings_display_opt_in1
 listings_sold0
 enable_cookie1
 top_producer_page_idSkdlbGRlcm1hbg==
 top_producer_assigned_to52131F4D-F3E8-430C-B470-51454349B68C
 top_producer_sourcePWP
 enable_social_media_opt_in_form0
 assign_leads_status0
 assign_leads_typedays
 assign_leads_interval10
 assign_leads_sechdule(null)
 sold_photo_scroll_type1
 sold_auto_scroll1
 sold_listing_slideshow_delay3000
 opt_in_after_listings2
 show_opt_in_after_listings0
 get_notofication_unsubscribe_leads0
 google_site_verification(null)
 pwp_lead_capture_api_key(null)
 address_type0
 custom_address(null)
 Photo
 id665
 user_id2
 is_preset0
 title(null)
 header_file_nameMarket_Evaluation_3.png
 photo_file_name(null)
 logo_file_name(null)
 upload_file_name(null)
 gallery_file_name(null)
 created2012-08-08 15:17:15
 modified2012-08-08 15:17:15
 6
 HeaderPhoto
 id4630
 site_id282
 photo_id1448
 header_order6
 gallery_order(null)
 crop_x(null)
 crop_y(null)
 crop_x2(null)
 crop_y2(null)
 description(empty)
 is_includephoto_frontend1
 header_photo_link(empty)
 is_showphoto_otherusers0
 crop_width(null)
 crop_height(null)
 Site
 id282
 is_top_producer_enabled1
 titleGelderman.ca Real Estate Team
 subdomaingelderman
 domain(empty)
 user_id240
 color_theme_id281
 logo_id1345
 gallery_type_id1
 header_effect_id8
 header_slideshow_delay5000
 listing_slideshow_delay4500
 analytics_code(null)
 remarketing_code(null)
 adwords_conversion_code(null)
 facebook_remarketing_code(null)
 facebook_conversion_code(null)
 meta_description(null)
 meta_keywords(null)
 created2014-04-02 13:53:49
 modified2017-02-02 12:39:43
 active1
 coverflow_above0
 display_listings1
 display_opt_in1
 auto_scroll1
 header_menu_placeholderabove
 header_margin_bgcolortransparent
 bottom_buttonbottom-buttons2
 personal_photo_shadow1
 header_designextended
 header_sizebig
 contact_no604-791- SOLD (7653)
 logo_designbig
 quick_question1
 bb_backgrond_color05_black.png
 call_today_textMain Office: 604-743-SOLD (7653) Chilliwack Office:
 is_show_phone_new_line1
 phone_alignmentcenter
 phone_row_backgroundtexture
 team_members_per_row1
 affiliates_per_row1
 domain_fontsize4.2
 domain_lineheight70
 socialmedia_margin75
 team_member_id240
 show_mls_logoshow
 socialmedia_size24x24
 slogan_fontPRISTINA
 custom_thank_you_messageThank you, you will be contacted shortly. Be sure to check your email and junkmail to gain access to your real estate search.
 background_designnew
 background_design_color05_black.png
 display_other_listings1
 listing_page_layoutnew
 listing_popup_stylenew
 send_leads_owner0
 video_share_buttonstraditional
 scroll_listing_member_address0
 enable_mobile_site1
 listings_display_opt_in1
 listings_sold0
 enable_cookie1
 top_producer_page_idSkdlbGRlcm1hbg==
 top_producer_assigned_to52131F4D-F3E8-430C-B470-51454349B68C
 top_producer_sourcePWP
 enable_social_media_opt_in_form0
 assign_leads_status0
 assign_leads_typedays
 assign_leads_interval10
 assign_leads_sechdule(null)
 sold_photo_scroll_type1
 sold_auto_scroll1
 sold_listing_slideshow_delay3000
 opt_in_after_listings2
 show_opt_in_after_listings0
 get_notofication_unsubscribe_leads0
 google_site_verification(null)
 pwp_lead_capture_api_key(null)
 address_type0
 custom_address(null)
 Photo
 id1448
 user_id240
 is_preset0
 title(null)
 header_file_name15_Gelderman_Header_awards.jpg
 photo_file_name(null)
 logo_file_name(null)
 upload_file_name(null)
 gallery_file_name(null)
 created2015-01-20 17:18:01
 modified2015-01-20 17:18:01
 7
 HeaderPhoto
 id4399
 site_id282
 photo_id660
 header_order7
 gallery_order(null)
 crop_x(null)
 crop_y(null)
 crop_x2(null)
 crop_y2(null)
 descriptionmls listings, homes for sale, property for sale, realtor.ca listings, search for homes for sale
 is_includephoto_frontend1
 header_photo_linkhttp://www.gelderman.ca/mls-home-search
 is_showphoto_otherusers0
 crop_width(null)
 crop_height(null)
 Site
 id282
 is_top_producer_enabled1
 titleGelderman.ca Real Estate Team
 subdomaingelderman
 domain(empty)
 user_id240
 color_theme_id281
 logo_id1345
 gallery_type_id1
 header_effect_id8
 header_slideshow_delay5000
 listing_slideshow_delay4500
 analytics_code(null)
 remarketing_code(null)
 adwords_conversion_code(null)
 facebook_remarketing_code(null)
 facebook_conversion_code(null)
 meta_description(null)
 meta_keywords(null)
 created2014-04-02 13:53:49
 modified2017-02-02 12:39:43
 active1
 coverflow_above0
 display_listings1
 display_opt_in1
 auto_scroll1
 header_menu_placeholderabove
 header_margin_bgcolortransparent
 bottom_buttonbottom-buttons2
 personal_photo_shadow1
 header_designextended
 header_sizebig
 contact_no604-791- SOLD (7653)
 logo_designbig
 quick_question1
 bb_backgrond_color05_black.png
 call_today_textMain Office: 604-743-SOLD (7653) Chilliwack Office:
 is_show_phone_new_line1
 phone_alignmentcenter
 phone_row_backgroundtexture
 team_members_per_row1
 affiliates_per_row1
 domain_fontsize4.2
 domain_lineheight70
 socialmedia_margin75
 team_member_id240
 show_mls_logoshow
 socialmedia_size24x24
 slogan_fontPRISTINA
 custom_thank_you_messageThank you, you will be contacted shortly. Be sure to check your email and junkmail to gain access to your real estate search.
 background_designnew
 background_design_color05_black.png
 display_other_listings1
 listing_page_layoutnew
 listing_popup_stylenew
 send_leads_owner0
 video_share_buttonstraditional
 scroll_listing_member_address0
 enable_mobile_site1
 listings_display_opt_in1
 listings_sold0
 enable_cookie1
 top_producer_page_idSkdlbGRlcm1hbg==
 top_producer_assigned_to52131F4D-F3E8-430C-B470-51454349B68C
 top_producer_sourcePWP
 enable_social_media_opt_in_form0
 assign_leads_status0
 assign_leads_typedays
 assign_leads_interval10
 assign_leads_sechdule(null)
 sold_photo_scroll_type1
 sold_auto_scroll1
 sold_listing_slideshow_delay3000
 opt_in_after_listings2
 show_opt_in_after_listings0
 get_notofication_unsubscribe_leads0
 google_site_verification(null)
 pwp_lead_capture_api_key(null)
 address_type0
 custom_address(null)
 Photo
 id660
 user_id2
 is_preset0
 title(null)
 header_file_nameDirect_Access_3.png
 photo_file_name(null)
 logo_file_name(null)
 upload_file_name(null)
 gallery_file_name(null)
 created2012-08-08 15:14:44
 modified2012-08-08 15:14:44
 8
 HeaderPhoto
 id4397
 site_id282
 photo_id667
 header_order8
 gallery_order(null)
 crop_x(null)
 crop_y(null)
 crop_x2(null)
 crop_y2(null)
 descriptionreal estate, stop paying rent, own your own home, buying a house
 is_includephoto_frontend1
 header_photo_linkhttp://www.gelderman.ca/why-pay-rent
 is_showphoto_otherusers0
 crop_width(null)
 crop_height(null)
 Site
 id282
 is_top_producer_enabled1
 titleGelderman.ca Real Estate Team
 subdomaingelderman
 domain(empty)
 user_id240
 color_theme_id281
 logo_id1345
 gallery_type_id1
 header_effect_id8
 header_slideshow_delay5000
 listing_slideshow_delay4500
 analytics_code(null)
 remarketing_code(null)
 adwords_conversion_code(null)
 facebook_remarketing_code(null)
 facebook_conversion_code(null)
 meta_description(null)
 meta_keywords(null)
 created2014-04-02 13:53:49
 modified2017-02-02 12:39:43
 active1
 coverflow_above0
 display_listings1
 display_opt_in1
 auto_scroll1
 header_menu_placeholderabove
 header_margin_bgcolortransparent
 bottom_buttonbottom-buttons2
 personal_photo_shadow1
 header_designextended
 header_sizebig
 contact_no604-791- SOLD (7653)
 logo_designbig
 quick_question1
 bb_backgrond_color05_black.png
 call_today_textMain Office: 604-743-SOLD (7653) Chilliwack Office:
 is_show_phone_new_line1
 phone_alignmentcenter
 phone_row_backgroundtexture
 team_members_per_row1
 affiliates_per_row1
 domain_fontsize4.2
 domain_lineheight70
 socialmedia_margin75
 team_member_id240
 show_mls_logoshow
 socialmedia_size24x24
 slogan_fontPRISTINA
 custom_thank_you_messageThank you, you will be contacted shortly. Be sure to check your email and junkmail to gain access to your real estate search.
 background_designnew
 background_design_color05_black.png
 display_other_listings1
 listing_page_layoutnew
 listing_popup_stylenew
 send_leads_owner0
 video_share_buttonstraditional
 scroll_listing_member_address0
 enable_mobile_site1
 listings_display_opt_in1
 listings_sold0
 enable_cookie1
 top_producer_page_idSkdlbGRlcm1hbg==
 top_producer_assigned_to52131F4D-F3E8-430C-B470-51454349B68C
 top_producer_sourcePWP
 enable_social_media_opt_in_form0
 assign_leads_status0
 assign_leads_typedays
 assign_leads_interval10
 assign_leads_sechdule(null)
 sold_photo_scroll_type1
 sold_auto_scroll1
 sold_listing_slideshow_delay3000
 opt_in_after_listings2
 show_opt_in_after_listings0
 get_notofication_unsubscribe_leads0
 google_site_verification(null)
 pwp_lead_capture_api_key(null)
 address_type0
 custom_address(null)
 Photo
 id667
 user_id2
 is_preset0
 title(null)
 header_file_nameStop_Paying_3.png
 photo_file_name(null)
 logo_file_name(null)
 upload_file_name(null)
 gallery_file_name(null)
 created2012-08-08 15:18:10
 modified2012-08-08 15:18:10
 9
 HeaderPhoto
 id4629
 site_id282
 photo_id1447
 header_order9
 gallery_order(null)
 crop_x(null)
 crop_y(null)
 crop_x2(null)
 crop_y2(null)
 description(empty)
 is_includephoto_frontend1
 header_photo_link(empty)
 is_showphoto_otherusers0
 crop_width(null)
 crop_height(null)
 Site
 id282
 is_top_producer_enabled1
 titleGelderman.ca Real Estate Team
 subdomaingelderman
 domain(empty)
 user_id240
 color_theme_id281
 logo_id1345
 gallery_type_id1
 header_effect_id8
 header_slideshow_delay5000
 listing_slideshow_delay4500
 analytics_code(null)
 remarketing_code(null)
 adwords_conversion_code(null)
 facebook_remarketing_code(null)
 facebook_conversion_code(null)
 meta_description(null)
 meta_keywords(null)
 created2014-04-02 13:53:49
 modified2017-02-02 12:39:43
 active1
 coverflow_above0
 display_listings1
 display_opt_in1
 auto_scroll1
 header_menu_placeholderabove
 header_margin_bgcolortransparent
 bottom_buttonbottom-buttons2
 personal_photo_shadow1
 header_designextended
 header_sizebig
 contact_no604-791- SOLD (7653)
 logo_designbig
 quick_question1
 bb_backgrond_color05_black.png
 call_today_textMain Office: 604-743-SOLD (7653) Chilliwack Office:
 is_show_phone_new_line1
 phone_alignmentcenter
 phone_row_backgroundtexture
 team_members_per_row1
 affiliates_per_row1
 domain_fontsize4.2
 domain_lineheight70
 socialmedia_margin75
 team_member_id240
 show_mls_logoshow
 socialmedia_size24x24
 slogan_fontPRISTINA
 custom_thank_you_messageThank you, you will be contacted shortly. Be sure to check your email and junkmail to gain access to your real estate search.
 background_designnew
 background_design_color05_black.png
 display_other_listings1
 listing_page_layoutnew
 listing_popup_stylenew
 send_leads_owner0
 video_share_buttonstraditional
 scroll_listing_member_address0
 enable_mobile_site1
 listings_display_opt_in1
 listings_sold0
 enable_cookie1
 top_producer_page_idSkdlbGRlcm1hbg==
 top_producer_assigned_to52131F4D-F3E8-430C-B470-51454349B68C
 top_producer_sourcePWP
 enable_social_media_opt_in_form0
 assign_leads_status0
 assign_leads_typedays
 assign_leads_interval10
 assign_leads_sechdule(null)
 sold_photo_scroll_type1
 sold_auto_scroll1
 sold_listing_slideshow_delay3000
 opt_in_after_listings2
 show_opt_in_after_listings0
 get_notofication_unsubscribe_leads0
 google_site_verification(null)
 pwp_lead_capture_api_key(null)
 address_type0
 custom_address(null)
 Photo
 id1447
 user_id240
 is_preset0
 title(null)
 header_file_name15_Gelderman_Header_awards.jpg
 photo_file_name(null)
 logo_file_name(null)
 upload_file_name(null)
 gallery_file_name(null)
 created2015-01-20 17:06:13
 modified2015-01-20 17:06:13
- colors
 body-bg#000000
 media-bg#850303
 top-current#000000
 top-active#000000
 top#aaaaaa
 top-hover#444444
 bottom#ffffff
 bottom-cap#343434
 #FFFFFF
 header-bg-color#113B69
 header-text-color#FFFFFF
 top-button-bg#000000
 bottom-shadow#7a8199
 quick-question#113b69
 billbord-text#000000
 bottom-text-color#333333
 bottom-button-top-text-color#ffffff
- site
 Site
 id282
 is_top_producer_enabled1
 titleGelderman.ca Real Estate Team
 subdomaingelderman
 domain(empty)
 user_id240
 color_theme_id281
 logo_id1345
 gallery_type_id1
 header_effect_id8
 header_slideshow_delay5000
 listing_slideshow_delay4500
 analytics_code(null)
 remarketing_code(null)
 adwords_conversion_code(null)
 facebook_remarketing_code(null)
 facebook_conversion_code(null)
 meta_description(null)
 meta_keywords(null)
 created2014-04-02 13:53:49
 modified2017-02-02 12:39:43
 active1
 coverflow_above0
 display_listings1
 display_opt_in1
 auto_scroll1
 header_menu_placeholderabove
 header_margin_bgcolortransparent
 bottom_buttonbottom-buttons2
 personal_photo_shadow1
 header_designextended
 header_sizebig
 contact_no604-791- SOLD (7653)
 logo_designbig
 quick_question1
 bb_backgrond_color05_black.png
 call_today_textMain Office: 604-743-SOLD (7653) Chilliwack Office:
 is_show_phone_new_line1
 phone_alignmentcenter
 phone_row_backgroundtexture
 team_members_per_row1
 affiliates_per_row1
 domain_fontsize4.2
 domain_lineheight70
 socialmedia_margin75
 team_member_id240
 show_mls_logoshow
 socialmedia_size24x24
 slogan_fontPRISTINA
 custom_thank_you_messageThank you, you will be contacted shortly. Be sure to check your email and junkmail to gain access to your real estate search.
 background_designnew
 background_design_color05_black.png
 display_other_listings1
 listing_page_layoutnew
 listing_popup_stylenew
 send_leads_owner0
 video_share_buttonstraditional
 scroll_listing_member_address0
 enable_mobile_site1
 listings_display_opt_in1
 listings_sold0
 enable_cookie1
 top_producer_page_idSkdlbGRlcm1hbg==
 top_producer_assigned_to52131F4D-F3E8-430C-B470-51454349B68C
 top_producer_sourcePWP
 enable_social_media_opt_in_form0
 assign_leads_status0
 assign_leads_typedays
 assign_leads_interval10
 assign_leads_sechdule(null)
 sold_photo_scroll_type1
 sold_auto_scroll1
 sold_listing_slideshow_delay3000
 opt_in_after_listings2
 show_opt_in_after_listings0
 get_notofication_unsubscribe_leads0
 google_site_verification(null)
 pwp_lead_capture_api_key(null)
 address_type0
 custom_address(null)
- banneroverlaysetting(false)
- attachments
 0
 AttachmentType
 id1
 typepdf
 Attachment(empty)
 1
 AttachmentType
 id2
 typevideo
 Attachment(empty)
- contentpage_link_details(null)
- social_media
 id1398
 site_id282
 placeholderabove
 facebook_app_id331534077057461
 facebook_secret_id791f180672ce25f119c31df4a780b079
 facebook1
 twitter1
 linkdin1
 google_plus1
 youtube1
 youtube_urlhttps://www.youtube.com/user/GeldermanREMAX/videos?shelf_id=2&view=0&sort=dd
 pinterest1
 facebook_imageset10_facebook.png
 twitter_imagetwitter.png
 linkdin_imageset10_linkedin.png
 google_imageset9_gplus.png
 youtube_imageset9_youtube.png
 pinterest_imageset2_pinterest.png
 email_share1
 skypecall1
 skype_namejonathan.gelderman
- baseurlhttp://gelderman.performancewebpage.com
- is_bot1
- devicetypedesktop
- captcha
 image_width215
 image_height80
 font_ratio(null)
 image_type2
 image_bg_color
 r255
 g255
 b255
 text_color
 r112
 g112
 b112
 line_color
 r112
 g112
 b112
 noise_color
 r112
 g112
 b112
 text_transparency_percentage20
 use_transparent_text(true)
 code_length6
 use_random_spaces(false)
 use_text_angles(false)
 use_random_baseline(false)
 use_random_boxes(false)
 case_sensitive(false)
 charsetabcdefghijkmnopqrstuvwxzyABCDEFGHJKLMNPQRSTUVWXZY0123456789
 expiry_time900
 session_namePERFORMANCE
 use_wordlist(false)
 perturbation0.85
 num_lines5
 noise_level2
 image_signature(empty)
 signature_color
 r112
 g112
 b112
 signature_font/home/performa/cake_app/app/vendors/securimage/AHGBold.ttf
 use_sqlite_db(false)
 use_database(false)
 skip_table_check(false)
 database_driversqlite
 database_hostlocalhost
 database_user(empty)
 database_pass(empty)
 database_name(empty)
 database_tablecaptcha_codes
 database_file/home/performa/cake_app/app/vendors/securimage/database/securimage.sq3
 captcha_type0
 namespacedefault
 ttf_file/home/performa/cake_app/app/vendors/securimage/AHGBold.ttf
 wordlist_file/home/performa/cake_app/app/vendors/securimage/words/words.txt
 wordlist_file_encoding(null)
 background_directory(null)
 sqlite_database(null)
 audio_path/home/performa/cake_app/app/vendors/securimage/audio/en/
 audio_use_sox(false)
 sox_binary_path/usr/bin/sox
 audio_noise_path/home/performa/cake_app/app/vendors/securimage/audio/noise/
 audio_use_noise(true)
 audio_mix_normalization0.8
 degrade_audio(true)
 audio_gap_min0
 audio_gap_max3000
 log_path/home/performa/cake_app/app/vendors/securimage
 log_filesecurimage.error_log
 securimage_path/home/performa/cake_app/app/vendors/securimage
 display_value(null)
- devicedesktop
- video_tips(empty)
- adminUser(false)
- $this->data(null)
- $this->validationErrors(empty)
- Loaded Helpers
 0simpleGraph
 1number
 2htmlToolbar
 3toolbar
 4commonFunction
 5image
 6affiliate
 7link
 8upload
 9customForm
 10thumbnail
 11youTube
 12javascript
 13farbtastic
 14autoJavascript
 15subMenu
 16button
 17session
 18jqueryEngine
 19js
 20form
 21html
====

Share With Your Friend
Recipient Email	:	OR
Accessing your contacts from your existing address books is easy. Just select the account(s) below where your contacts are stored and they will open right here.

Sender Email	:
Message	:

Message	Memory use
Component initialization	7.54 MB
Controller action start	7.58 MB
Controller render start	8.36 MB
View render complete	10.78 MB

Message	Time in ms	Graph
Core Processing (Derived)	82.93
Component initialization and startup	2.68
Controller action	37.42
Render Controller Action	21.56
» Rendering View	21.17
» » Rendering APP/views/sites/home.ctp	14.63
» » » Rendering APP/views/elements/content.ctp	0.64
» » » » Rendering APP/views/elements/report_download.ctp	0.03
» » » » Rendering APP/views/elements/attachments.ctp	0.07
» » » » Rendering APP/views/themed/default/elements/team_members.ctp	0.06
» » » » Rendering APP/views/themed/default/elements/affiliates.ctp	0.05
» » » » Rendering APP/views/elements/optin.ctp	0.07
» » Rendering APP/views/themed/default/layouts/default.ctp	6.42
» » » Rendering APP/views/themed/default/elements/header.ctp	1.57
» » » » Rendering APP/views/themed/default/elements/top_logo.ctp	0.14
» » » » Rendering APP/views/themed/default/elements/social_media.ctp	0.33
» » » » Rendering APP/views/themed/default/elements/header_slider.ctp	0.40
» » » Rendering APP/views/themed/default/elements/mid_buttons.ctp	0.20
» » » Rendering APP/views/themed/default/elements/slider.ctp	0.20
» » » Rendering APP/views/themed/default/elements/bottom_buttons.ctp	0.86
» » » Rendering APP/views/themed/default/elements/listing_optin_new.ctp	1.71
» » » Rendering APP/views/elements/media_gallery.ctp	1.08
» » » Rendering APP/views/elements/footer_links.ctp	0.07
» » » Rendering APP/views/themed/default/elements/end.ctp	0.05

Your Home Sold in 35 Days Or We'll Pay You Cash!!

Share With Your Friend

New Listing Alert!

MLS® Home Search

Free Online Evaluation

Fast Answers

Fraser Valley Real Estate

Instant Access to Full Listing Details

Title Goes here

default

Query Explain:

Memory

Timers

Your Home Sold in 35 Days Or We'll Pay You Cash!!

Share With Your Friend

New Listing Alert!

MLS® Home Search

Free Online Evaluation

Fast Answers

Fraser Valley Real Estate

Instant Access to Full Listing Details

Title Goes here

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Query Explain:

Memory

Timers

Logs

View Variables