Notice (8): Undefined index: mlsidx_id_array [APP/Controller/BrokeragesController.php, line 537]Code Context        $mls_compliance_data = $this->MlsComplianceData->find('all', [
            'conditions' => [
                'MlsComplianceData.mlsidx_brokerage_id' => $brokerage['Brokerage']['mlsidx_id_array']
$id = '36'
$brokerage = array(
	'Brokerage' => array(
		'password' => '*****',
		'id' => '36',
		'account_executive_id' => '235',
		'archived' => false,
		'type' => 'brokerage',
		'hide_from_frontend' => false,
		'agent_brokerage_data_override' => false,
		'featured_development' => false,
		'membership_type' => 'Premium',
		'max_properties' => '8',
		'max_homepage_featured_by_member_properties' => '0',
		'featured_properties_sort_method' => 'manual',
		'lux_feed_mode' => 'StripeSubscription',
		'max_luxury_feed_properties' => '0',
		'membership_luxury_feed_properties' => '0',
		'can_participate_in_lux_feed_while_archived' => false,
		'full_training_video_access' => false,
		'country_id' => '10',
		'WOEID' => '1105779',
		'timezone' => 'Australia/Sydney',
		'luxury_feed_enrollment_mode' => 'manual',
		'luxury_feed_include_mlsidx_minimum_price' => '0',
		'luxury_feed_include_leverage_minimum_price' => '0',
		'digital_ad_contacts' => '',
		'add_agents_to_grr_auto_recipients' => true,
		'mlsidx_id' => '',
		'mlsidx_lux_autofeed' => false,
		'mlsidx_lux_autofeed_minimum_price' => '0',
		'mlsidx_logo_url' => '',
		'mlsidx_disclaimer' => '',
		'name' => 'Burns and Burns',
		'broker_of_record_name' => '',
		'short_name' => 'Burns and Burns',
		'username' => 'BurnsandBurns',
		'password_reset_hash' => '',
		'monthly_invoice_amount' => null,
		'monthly_invoice_start_date' => '0000-00-00',
		'monthly_invoice_end_date' => '0000-00-00',
		'contract_filename' => '',
		'active' => true,
		'lead_in' => '',
		'short_description' => '',
		'description' => '<p>Burns and Burns is the exclusive representative for Leverage Global Partners on the North Shore and Upper North Shore of Sydney, Australia.</p>

<p>Burns &amp; Burns is a family business established for nearly 30 years and is one of the oldest continuing running real estate companies on the North Shore. Founded by Julia Burns, with husband Richard, son Andrew and daughter-in-law Catherine, the family concern has been blessed by long-term staff in both sales and support roles. This is shown by the strong work ethic and customer service, which results in 70% of the clients utilising Burns &amp; Burns services being either repeat or referral customers. Julia and Andrew Burns have dominated the prestige market for over 30 years and, as such, have a track record and network unequalled on the North Shore. Indeed, it is no surprise that the highest sales records for the Upper North Shore are held by Burns &amp; Burns in Pymble and Wahroonga. Knox Grammar School and other institutions have repeatedly used the trusted service of Burns &amp; Burns over the last 30 years being the highest recommendation and of which the family are very proud. However, Burns &amp; Burns deal in ALL price ranges and many of our staff have &lsquo;grown-up&rsquo; with their clients, as they move from property to property which is the backbone of the firm and will continue to be so.</p>
',
		'communities' => 'Upper North Shore of Sydney, Australia
North Shore of Sydney, Australia',
		'website' => 'http://burnsandburns.com.au/home',
		'address' => '1051 Pacific Highway',
		'address_2' => '',
		'city' => 'Pymble',
		'state' => '',
		'full_state' => '',
		'country' => 'Australia',
		'market' => 'Sydney North Shore',
		'market_2' => '',
		'postal_code' => 'NSW 2073',
		'phone' => '(+) 61 (0) 2 9449 9211',
		'phone_2' => '',
		'phone_3' => '',
		'wide_contact_image' => false,
		'contact_name' => 'Andrew Burns',
		'contact_profile_link' => '',
		'contact_big_profile_link' => 'http://www.leveragere.com/blog/meet-andrew-burns-director-of-burns-and-burns/',
		'contact_big_profile_link_text' => '',
		'contact_title' => 'Director',
		'contact_dre_num' => '',
		'contact_quote' => '',
		'contact_email' => 'andrew@burnsandburns.com.au',
		'contact_facebook' => '',
		'contact_twitter' => '',
		'contact_instagram' => '',
		'contact_pinterest' => '',
		'contact_linkedin' => '',
		'contact_youtube' => '',
		'contact_phone' => '',
		'contact_email_2' => '',
		'contact_2_facebook' => '',
		'contact_2_twitter' => '',
		'contact_2_instagram' => '',
		'contact_2_pinterest' => '',
		'contact_2_linkedin' => '',
		'contact_2_youtube' => '',
		'contact_phone_2' => '',
		'contact_website' => '',
		'contact_name_2' => '',
		'contact_profile_link_2' => '',
		'contact_big_profile_link_2' => '',
		'contact_big_profile_link_text_2' => '',
		'contact_title_2' => '',
		'contact_dre_num_2' => '',
		'contact_email_3' => '',
		'contact_name_3' => '',
		'contact_title_3' => '',
		'contact_dre_num_3' => '',
		'contact_phone_3' => '',
		'contact_3_facebook' => '',
		'contact_3_twitter' => '',
		'contact_3_instagram' => '',
		'contact_3_pinterest' => '',
		'contact_3_linkedin' => '',
		'contact_3_youtube' => '',
		'image_filename' => '36.jpg',
		'logo_filename' => '36.jpg',
		'contact_image_filename' => '36.jpg',
		'all_properties_link_image_filename' => '36.jpg',
		'all_properties_link' => 'http://burnsandburns.com.au/listings/ressale',
		'video_embed_code' => '',
		'contact_video_embed_code' => '',
		'meta_title' => 'Sydney North Shore Real Estate | Burns and Burns | Leverage Global Partners',
		'meta_description' => 'Burns and Burns is the exclusive representative for Leverage Global Partners in North Shore Sydney, Australia. ',
		'meta_keywords' => 'Burns & Burns, Burns & Burns real estate, North Shore Sydney real estate, Sydney Australia, Andrew Burns, leverage global partners',
		'login_message_counter' => '1',
		'stats_module_1_type' => '',
		'stats_module_1_value' => '',
		'stats_module_2_type' => '',
		'stats_module_2_value' => '',
		'stats_module_3_type' => '',
		'stats_module_3_value' => '',
		'last_activity_email_sent' => '0000-00-00 00:00:00',
		'converted' => true,
		'created' => '2013-06-19 10:54:50',
		'modified' => '2016-04-08 16:33:30',
		'dre_num' => '012345',
		'uri' => '/brokerage-detail/36/burns-and-burns',
		'website_short' => 'burnsandburns.com.au/home',
		'name_with_location' => 'Burns and Burns'
	),
	'Logo' => array(
		'id' => '2344',
		'model' => 'Brokerage',
		'model_id' => '36',
		'tag' => 'Logo',
		'name' => '36.jpg',
		'type' => 'image/jpg',
		'size' => '470882',
		'uri' => '/assets/2344.jpg',
		'order' => '0',
		'created' => '2016-03-30 11:37:49',
		'modified' => '2016-03-30 11:37:49'
	),
	'MainImage' => array(
		'id' => '2343',
		'model' => 'Brokerage',
		'model_id' => '36',
		'tag' => 'MainImage',
		'name' => '36.jpg',
		'type' => 'image/jpg',
		'size' => '645963',
		'uri' => '/assets/2343.jpg',
		'order' => '0',
		'created' => '2016-03-30 11:37:48',
		'modified' => '2016-03-30 11:37:48'
	),
	'ContactImage' => array(
		'id' => '2345',
		'model' => 'Brokerage',
		'model_id' => '36',
		'tag' => 'ContactImage',
		'name' => '36.jpg',
		'type' => 'image/jpg',
		'size' => '19112',
		'uri' => '/assets/2345.jpg',
		'order' => '0',
		'created' => '2016-03-30 11:37:49',
		'modified' => '2016-03-30 11:37:49'
	),
	'ContactImage2' => array(
		'id' => null,
		'model' => null,
		'model_id' => null,
		'tag' => null,
		'name' => null,
		'type' => null,
		'size' => null,
		'uri' => null,
		'order' => null,
		'created' => null,
		'modified' => null
	),
	'ContactImage3' => array(
		'id' => null,
		'model' => null,
		'model_id' => null,
		'tag' => null,
		'name' => null,
		'type' => null,
		'size' => null,
		'uri' => null,
		'order' => null,
		'created' => null,
		'modified' => null
	),
	'BrokerOfRecordLogo' => array(
		'id' => null,
		'model' => null,
		'model_id' => null,
		'tag' => null,
		'name' => null,
		'type' => null,
		'size' => null,
		'uri' => null,
		'order' => null,
		'created' => null,
		'modified' => null
	),
	'FeaturedImage' => array()
)
BrokeragesController::view() - APP/Controller/BrokeragesController.php, line 537
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110

Leverage Brokerage | Burns and Burns

Properties / Burns and Burns

Burns and Burns

Director: Andrew Burns
(+) 61 (0) 2 9449 9211

License #: 012345

Visit Website

Burns and Burns is the exclusive representative for Leverage Global Partners on the North Shore and Upper North Shore of Sydney, Australia.

Burns & Burns is a family business established for nearly 30 years and is one of the oldest continuing running real estate companies on the North Shore. Founded by Julia Burns, with husband Richard, son Andrew and daughter-in-law Catherine, the family concern has been blessed by long-term staff in both sales and support roles. This is shown by the strong work ethic and customer service, which results in 70% of the clients utilising Burns & Burns services being either repeat or referral customers. Julia and Andrew Burns have dominated the prestige market for over 30 years and, as such, have a track record and network unequalled on the North Shore. Indeed, it is no surprise that the highest sales records for the Upper North Shore are held by Burns & Burns in Pymble and Wahroonga. Knox Grammar School and other institutions have repeatedly used the trusted service of Burns & Burns over the last 30 years being the highest recommendation and of which the family are very proud. However, Burns & Burns deal in ALL price ranges and many of our staff have ‘grown-up’ with their clients, as they move from property to property which is the backbone of the firm and will continue to be so.

Connect With Us

burnsandburns.com.au/home

Read Our Profile

Meet Andrew Burns: Director of Burns and Burns

LeverageRE

"Your integrity and your reputation are, without question, the most important things you've got," explains Andrew Burns, Director of Burns and Burns, when asked about the qualities of success that others see in him. "I work very hard to make sure that is upheld."

Partner:
Burns and Burns

Burns and Burns Featured Properties

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgentcc2d3fd23c5dd98eb73e42c141648c0a
  time1781167996
  countdown10
- Explore(array)
  rejected_tiles(array)
  rejected_topics(empty)
  rejected_locations(empty)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerbrokerages
- actionview
- named(empty)
- pass(array)
  036
  1burns-and-burns
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys(empty)
- options(empty)
- defaults(array)
  controllerbrokerages
  actionview
  plugin(null)
- template/brokerage-detail/*
====

Sql Log

Sql Logs

default

Total Time: 10 ms
Total Queries: 15 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `Logo`.`id`, `Logo`.`model`, `Logo`.`model_id`, `Logo`.`tag`, `Logo`.`name`, `Logo`.`type`, `Logo`.`size`, `Logo`.`uri`, `Logo`.`order`, `Logo`.`created`, `Logo`.`modified`, `MainImage`.`id`, `MainImage`.`model`, `MainImage`.`model_id`, `MainImage`.`tag`, `MainImage`.`name`, `MainImage`.`type`, `MainImage`.`size`, `MainImage`.`uri`, `MainImage`.`order`, `MainImage`.`created`, `MainImage`.`modified`, `ContactImage`.`id`, `ContactImage`.`model`, `ContactImage`.`model_id`, `ContactImage`.`tag`, `ContactImage`.`name`, `ContactImage`.`type`, `ContactImage`.`size`, `ContactImage`.`uri`, `ContactImage`.`order`, `ContactImage`.`created`, `ContactImage`.`modified`, `ContactImage2`.`id`, `ContactImage2`.`model`, `ContactImage2`.`model_id`, `ContactImage2`.`tag`, `ContactImage2`.`name`, `ContactImage2`.`type`, `ContactImage2`.`size`, `ContactImage2`.`uri`, `ContactImage2`.`order`, `ContactImage2`.`created`, `ContactImage2`.`modified`, `ContactImage3`.`id`, `ContactImage3`.`model`, `ContactImage3`.`model_id`, `ContactImage3`.`tag`, `ContactImage3`.`name`, `ContactImage3`.`type`, `ContactImage3`.`size`, `ContactImage3`.`uri`, `ContactImage3`.`order`, `ContactImage3`.`created`, `ContactImage3`.`modified`, `BrokerOfRecordLogo`.`id`, `BrokerOfRecordLogo`.`model`, `BrokerOfRecordLogo`.`model_id`, `BrokerOfRecordLogo`.`tag`, `BrokerOfRecordLogo`.`name`, `BrokerOfRecordLogo`.`type`, `BrokerOfRecordLogo`.`size`, `BrokerOfRecordLogo`.`uri`, `BrokerOfRecordLogo`.`order`, `BrokerOfRecordLogo`.`created`, `BrokerOfRecordLogo`.`modified` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` LEFT JOIN `leveragere_staging2`.`assets` AS `Logo` ON (`Logo`.`model_id` = `Brokerage`.`id` AND `Logo`.`model` = 'Brokerage' AND `Logo`.`tag` = 'Logo') LEFT JOIN `leveragere_staging2`.`assets` AS `MainImage` ON (`MainImage`.`model_id` = `Brokerage`.`id` AND `MainImage`.`model` = 'Brokerage' AND `MainImage`.`tag` = 'MainImage') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage` ON (`ContactImage`.`model_id` = `Brokerage`.`id` AND `ContactImage`.`model` = 'Brokerage' AND `ContactImage`.`tag` = 'ContactImage') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage2` ON (`ContactImage2`.`model_id` = `Brokerage`.`id` AND `ContactImage2`.`model` = 'Brokerage' AND `ContactImage2`.`tag` = 'ContactImage2') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage3` ON (`ContactImage3`.`model_id` = `Brokerage`.`id` AND `ContactImage3`.`model` = 'Brokerage' AND `ContactImage3`.`tag` = 'ContactImage3') LEFT JOIN `leveragere_staging2`.`assets` AS `BrokerOfRecordLogo` ON (`BrokerOfRecordLogo`.`model_id` = `Brokerage`.`id` AND `BrokerOfRecordLogo`.`model` = 'Brokerage' AND `BrokerOfRecordLogo`.`tag` = 'BrokerOfRecordLogo') WHERE `Brokerage`.`id` = 36 AND `Brokerage`.`archived` = '0' AND `Brokerage`.`hide_from_frontend` = '0' LIMIT 1	1	1	1
SELECT `FeaturedImage`.`id`, `FeaturedImage`.`model`, `FeaturedImage`.`model_id`, `FeaturedImage`.`tag`, `FeaturedImage`.`name`, `FeaturedImage`.`type`, `FeaturedImage`.`size`, `FeaturedImage`.`uri`, `FeaturedImage`.`order`, `FeaturedImage`.`created`, `FeaturedImage`.`modified` FROM `leveragere_staging2`.`assets` AS `FeaturedImage` WHERE `FeaturedImage`.`model` = 'Brokerage' AND `FeaturedImage`.`tag` = 'FeaturedImage' AND `FeaturedImage`.`model_id` = (36) ORDER BY `FeaturedImage`.`order` ASC	0	0	0
SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`locations` AS `Location` LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Location`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`assets` AS `Image` ON (`Image`.`model_id` = `Location`.`id` AND `Image`.`model` = 'Location' AND `Image`.`tag` = 'Image') WHERE `Location`.`brokerage_id` = 36 AND `Location`.`archived` = '0'	1	1	1
SELECT `Article`.`id`, `Article`.`model`, `Article`.`model_id`, `Article`.`archived`, `Article`.`medium_featured`, `Article`.`large_featured`, `Article`.`title`, `Article`.`author`, `Article`.`date`, `Article`.`lead_in`, `Article`.`body`, `Article`.`vimeo_id`, `Article`.`created`, `Article`.`modified`, `ParentBrokerage`.`id`, `ParentBrokerage`.`account_executive_id`, `ParentBrokerage`.`archived`, `ParentBrokerage`.`type`, `ParentBrokerage`.`hide_from_frontend`, `ParentBrokerage`.`agent_brokerage_data_override`, `ParentBrokerage`.`featured_development`, `ParentBrokerage`.`membership_type`, `ParentBrokerage`.`max_properties`, `ParentBrokerage`.`max_homepage_featured_by_member_properties`, `ParentBrokerage`.`featured_properties_sort_method`, `ParentBrokerage`.`lux_feed_mode`, `ParentBrokerage`.`max_luxury_feed_properties`, `ParentBrokerage`.`membership_luxury_feed_properties`, `ParentBrokerage`.`can_participate_in_lux_feed_while_archived`, `ParentBrokerage`.`full_training_video_access`, `ParentBrokerage`.`country_id`, `ParentBrokerage`.`WOEID`, `ParentBrokerage`.`timezone`, `ParentBrokerage`.`luxury_feed_enrollment_mode`, `ParentBrokerage`.`luxury_feed_include_mlsidx_minimum_price`, `ParentBrokerage`.`luxury_feed_include_leverage_minimum_price`, `ParentBrokerage`.`digital_ad_contacts`, `ParentBrokerage`.`add_agents_to_grr_auto_recipients`, `ParentBrokerage`.`mlsidx_id`, `ParentBrokerage`.`mlsidx_lux_autofeed`, `ParentBrokerage`.`mlsidx_lux_autofeed_minimum_price`, `ParentBrokerage`.`mlsidx_logo_url`, `ParentBrokerage`.`mlsidx_disclaimer`, `ParentBrokerage`.`name`, `ParentBrokerage`.`broker_of_record_name`, `ParentBrokerage`.`short_name`, `ParentBrokerage`.`username`, `ParentBrokerage`.`password`, `ParentBrokerage`.`password_reset_hash`, `ParentBrokerage`.`monthly_invoice_amount`, `ParentBrokerage`.`monthly_invoice_start_date`, `ParentBrokerage`.`monthly_invoice_end_date`, `ParentBrokerage`.`contract_filename`, `ParentBrokerage`.`active`, `ParentBrokerage`.`lead_in`, `ParentBrokerage`.`short_description`, `ParentBrokerage`.`description`, `ParentBrokerage`.`communities`, `ParentBrokerage`.`website`, `ParentBrokerage`.`address`, `ParentBrokerage`.`address_2`, `ParentBrokerage`.`city`, `ParentBrokerage`.`state`, `ParentBrokerage`.`full_state`, `ParentBrokerage`.`country`, `ParentBrokerage`.`market`, `ParentBrokerage`.`market_2`, `ParentBrokerage`.`postal_code`, `ParentBrokerage`.`phone`, `ParentBrokerage`.`phone_2`, `ParentBrokerage`.`phone_3`, `ParentBrokerage`.`wide_contact_image`, `ParentBrokerage`.`contact_name`, `ParentBrokerage`.`contact_profile_link`, `ParentBrokerage`.`contact_big_profile_link`, `ParentBrokerage`.`contact_big_profile_link_text`, `ParentBrokerage`.`contact_title`, `ParentBrokerage`.`contact_dre_num`, `ParentBrokerage`.`contact_quote`, `ParentBrokerage`.`contact_email`, `ParentBrokerage`.`contact_facebook`, `ParentBrokerage`.`contact_twitter`, `ParentBrokerage`.`contact_instagram`, `ParentBrokerage`.`contact_pinterest`, `ParentBrokerage`.`contact_linkedin`, `ParentBrokerage`.`contact_youtube`, `ParentBrokerage`.`contact_phone`, `ParentBrokerage`.`contact_email_2`, `ParentBrokerage`.`contact_2_facebook`, `ParentBrokerage`.`contact_2_twitter`, `ParentBrokerage`.`contact_2_instagram`, `ParentBrokerage`.`contact_2_pinterest`, `ParentBrokerage`.`contact_2_linkedin`, `ParentBrokerage`.`contact_2_youtube`, `ParentBrokerage`.`contact_phone_2`, `ParentBrokerage`.`contact_website`, `ParentBrokerage`.`contact_name_2`, `ParentBrokerage`.`contact_profile_link_2`, `ParentBrokerage`.`contact_big_profile_link_2`, `ParentBrokerage`.`contact_big_profile_link_text_2`, `ParentBrokerage`.`contact_title_2`, `ParentBrokerage`.`contact_dre_num_2`, `ParentBrokerage`.`contact_email_3`, `ParentBrokerage`.`contact_name_3`, `ParentBrokerage`.`contact_title_3`, `ParentBrokerage`.`contact_dre_num_3`, `ParentBrokerage`.`contact_phone_3`, `ParentBrokerage`.`contact_3_facebook`, `ParentBrokerage`.`contact_3_twitter`, `ParentBrokerage`.`contact_3_instagram`, `ParentBrokerage`.`contact_3_pinterest`, `ParentBrokerage`.`contact_3_linkedin`, `ParentBrokerage`.`contact_3_youtube`, `ParentBrokerage`.`image_filename`, `ParentBrokerage`.`logo_filename`, `ParentBrokerage`.`contact_image_filename`, `ParentBrokerage`.`all_properties_link_image_filename`, `ParentBrokerage`.`all_properties_link`, `ParentBrokerage`.`video_embed_code`, `ParentBrokerage`.`contact_video_embed_code`, `ParentBrokerage`.`meta_title`, `ParentBrokerage`.`meta_description`, `ParentBrokerage`.`meta_keywords`, `ParentBrokerage`.`login_message_counter`, `ParentBrokerage`.`stats_module_1_type`, `ParentBrokerage`.`stats_module_1_value`, `ParentBrokerage`.`stats_module_2_type`, `ParentBrokerage`.`stats_module_2_value`, `ParentBrokerage`.`stats_module_3_type`, `ParentBrokerage`.`stats_module_3_value`, `ParentBrokerage`.`last_activity_email_sent`, `ParentBrokerage`.`converted`, `ParentBrokerage`.`created`, `ParentBrokerage`.`modified`, `ParentBrokerage`.`dre_num`, `ParentLocation`.`id`, `ParentLocation`.`parent_id`, `ParentLocation`.`brokerage_id`, `ParentLocation`.`type`, `ParentLocation`.`archived`, `ParentLocation`.`use_as_topic`, `ParentLocation`.`name`, `ParentLocation`.`short_name`, `ParentLocation`.`group_index`, `ParentLocation`.`latitude`, `ParentLocation`.`longitude`, `ParentLocation`.`country_code`, `ParentLocation`.`north`, `ParentLocation`.`south`, `ParentLocation`.`east`, `ParentLocation`.`west`, `ParentLocation`.`zoom`, `ParentLocation`.`short_description`, `ParentLocation`.`long_description`, `ParentLocation`.`created`, `ParentLocation`.`modified`, `ParentLocation`.`timezone`, `ParentLocation`.`population` FROM `leveragere_staging2`.`articles` AS `Article` LEFT JOIN `leveragere_staging2`.`brokerages` AS `ParentBrokerage` ON (`Article`.`model_id` = `ParentBrokerage`.`id` AND `Article`.`model` = 'Brokerage') LEFT JOIN `leveragere_staging2`.`locations` AS `ParentLocation` ON (`Article`.`model_id` = `ParentLocation`.`id` AND `Article`.`model` = 'Location') WHERE `Article`.`model` = 'Brokerage' AND `Article`.`model_id` = 36 LIMIT 1	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` = (86) ORDER BY `Image`.`order` ASC	1	1	0
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `ArticlesBrokerage`.`id`, `ArticlesBrokerage`.`article_id`, `ArticlesBrokerage`.`brokerage_id` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` JOIN `leveragere_staging2`.`articles_brokerages` AS `ArticlesBrokerage` ON (`ArticlesBrokerage`.`article_id` = 86 AND `ArticlesBrokerage`.`brokerage_id` = `Brokerage`.`id`)	0	0	0
SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `ArticlesLocation`.`id`, `ArticlesLocation`.`article_id`, `ArticlesLocation`.`location_id` FROM `leveragere_staging2`.`locations` AS `Location` JOIN `leveragere_staging2`.`articles_locations` AS `ArticlesLocation` ON (`ArticlesLocation`.`article_id` = 86 AND `ArticlesLocation`.`location_id` = `Location`.`id`)	0	0	0
SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created`, `ArticlesProperty`.`id`, `ArticlesProperty`.`article_id`, `ArticlesProperty`.`property_id` FROM `leveragere_staging2`.`properties` AS `Property` JOIN `leveragere_staging2`.`articles_properties` AS `ArticlesProperty` ON (`ArticlesProperty`.`article_id` = 86 AND `ArticlesProperty`.`property_id` = `Property`.`id`)	0	0	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `ArticlesTopic`.`id`, `ArticlesTopic`.`article_id`, `ArticlesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`articles_topics` AS `ArticlesTopic` ON (`ArticlesTopic`.`article_id` = 86 AND `ArticlesTopic`.`topic_id` = `Topic`.`id`)	0	0	0
SELECT `Article`.`id` FROM `leveragere_staging2`.`articles` AS `Article` WHERE `Article`.`archived` = '0' AND NOT (`Article`.`model` = ('News')) ORDER BY `Article`.`created` DESC LIMIT 50	50	50	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (499, 498, 497, 495, 494, 493, 492, 491, 490, 487, 488, 486, 484, 485, 483, 482, 481, 480, 479, 478, 477, 476, 475, 473, 472, 470, 471, 468, 467, 466, 465, 464, 463, 462, 461, 459, 460, 458, 457, 456, 455, 454, 452, 453, 451, 450, 449, 448, 447, 446) ORDER BY `Image`.`order` ASC	50	50	1
SELECT `Article`.`id`, `Article`.`model`, `Article`.`model_id`, `Article`.`archived`, `Article`.`medium_featured`, `Article`.`large_featured`, `Article`.`title`, `Article`.`author`, `Article`.`date`, `Article`.`lead_in`, `Article`.`body`, `Article`.`vimeo_id`, `Article`.`created`, `Article`.`modified` FROM `leveragere_staging2`.`articles` AS `Article` WHERE `Article`.`id` IN (499, 498, 497, 495, 494, 493, 492, 491, 490, 487, 488, 486, 484, 485, 483, 482, 481, 480, 479, 478, 477, 476, 475, 473, 472, 470, 471, 468, 467, 466, 465, 464, 463, 462, 461, 459, 460, 458, 457, 456, 455, 454, 452, 453, 451, 450, 449, 448, 447, 446) ORDER BY RAND() ASC LIMIT 4	4	4	1	maybe slow
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (464, 455, 476, 468) ORDER BY `Image`.`order` ASC	4	4	0
SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`locations` AS `Location` LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Location`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`assets` AS `Image` ON (`Image`.`model_id` = `Location`.`id` AND `Image`.`model` = 'Location' AND `Image`.`tag` = 'Image') WHERE `Location`.`type` = 'Exclusive' AND `Location`.`archived` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	4
SELECT `MlsComplianceData`.`id`, `MlsComplianceData`.`mlsidx_brokerage_id`, `MlsComplianceData`.`mlsidx_logo_url`, `MlsComplianceData`.`mlsidx_disclaimer`, `MlsComplianceData`.`created`, `MlsComplianceData`.`modified` FROM `leveragere_staging2`.`mls_compliance_data` AS `MlsComplianceData` WHERE `MlsComplianceData`.`mlsidx_brokerage_id` IS NULL	0	0	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 11.01 MB

Message	Memory use
Component initialization	2.94 MB
Controller action start	3.87 MB
Controller render start	6.18 MB
View render complete	6.69 MB

Timers

Total Request Time: 198 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	25.51
Event: Controller.initialize	4.09
Event: Controller.startup	1.07
Controller action	32.36
Event: Controller.beforeRender	8.24
» Processing toolbar data	8.16
Rendering View	104.35
» Event: View.beforeRender	0.25
» Rendering APP/View/Brokerages/view.ctp	0.91
» » Rendering APP/View/Elements/article_list.ctp	0.17
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.20
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	102.54
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- mls_compliance_data(empty)
- sidebar_locations(array)
 0(array)
 Location(array)
 id120
 parent_id9
 brokerage_id57
 typeExclusive
 archived(false)
 use_as_topic(false)
 namePleasanton, CA, USA
 short_namePleasanton, CA, USA
 group_index
 latitude37.662430
 longitude-121.874680
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-05 17:57:23
 modified2016-04-14 14:57:21
 timezoneAmerica/Los_Angeles
 population74000
 uri/locations/view/120/pleasanton-ca-usa
 tile_namePleasanton, CA, USA
 Brokerage(array)
 id57
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2474209
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameJ. Rockcliff Realtors
 broker_of_record_name
 short_nameJ Rockcliff Realtors
 usernameJRockcliffPleas
 password14a01d92dcd7b0cd5ad6f01dca84a3e626414a24
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionJ. Rockcliff Realtors is the exclusive representative for Leverage Global Partners in Pleasanton, Dublin, Livermore, Castro Valley, Fremont, and Sunol, California. J. Rockcliff Realtors is one of the fastest growing real estate companies in California and has distinguished itself as The East Bay’s Premier Real Estate Company. With offices located in <a href="../../../brokerage-detail/55/J.-Rockcliff-Realtors">LaMorinda</a> (Lafayette, Moraga, Orinda), <a href="../../../brokerage-detail/56/J.-Rockcliff-Realtors">Walnut Creek</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Danville</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Blackhawk</a>, and <a href="../../../brokerage-detail/57/J.-Rockcliff-Realtors">Pleasanton/Dublin/Livermore</a>, experienced Realtors can assist with your home buying or home selling needs in any real estate market. Looking for bank owned properties? We can help. J. Rockcliff Realtors’ Relocation Department provides home buying or home selling assistance around the corner or around the world. As members of Worldwide ERC (Employee Relocation Council), J. Rockcliff handles many corporate relocation moves as well. When listing or selling your home, you can rest assured that J. Rockcliff Realtors can provide the best real estate agents (Realtors) to help you buy or sell your home using the most innovative tools available, including; the finest marketing, the most advanced technology and resources unmatched by any other firm. J. Rockcliff Realtors is strategically positioned to be the company of choice now and in the future. J. Rockcliff Realtors is proudly licensed with the California Bureau of Real Estate - License #01793729. J.Rockcliff also has offices in <a href="../../../brokerage-detail/55/J.-Rockcliff-Realtors">Lafayette</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Danville</a>, and <a href="../../../brokerage-detail/56/J.-Rockcliff-Realtors">Walnut Creek</a>.
 communitiesPleasanton Dublin Livermore Castro Valley Sunol
 websitehttp://www.rockcliff.com/
 address5075 Hopyard Road
 address_2Suite 110
 cityPleasanton
 stateCA
 full_stateCalifornia
 countryUSA
 marketPleasanton
 market_2
 postal_code94588
 phone(925) 251-2500
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJeff Sposito
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_emailjsposito@rockcliff.com
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename57.jpg
 logo_filename57.jpg
 contact_image_filename57.jpg
 all_properties_link_image_filename57.jpg
 all_properties_linkhttp://www.rockcliff.com/Rockcliff-Listings#g=2a4505b8-af60-49e2-b0c4-b980136a5da0
 video_embed_code
 contact_video_embed_code
 meta_titlePleasanton Real Estate | J. Rockcliff Realtors | Leverage Global Partners
 meta_descriptionJ. Rockcliff Realtors is the exclusive representative for Leverage Global Partners in Pleasanton, CA, USA.
 meta_keywordsJ. Rockcliff Realtors, Pleasanton Real Estate, Leverage Global Partners, Jeff Sposito
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-09-26 15:00:06
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/57/j-rockcliff-realtors
 website_shortwww.rockcliff.com
 name_with_locationJ. Rockcliff Realtors
 Image(array)
 id3383
 modelLocation
 model_id120
 tagImage
 namepleasonton.jpg
 typeimage/jpeg
 size171746
 uri/assets/3383.jpg
 order0
 created2016-04-05 17:57:11
 modified2016-04-14 14:57:21
 1(array)
 Location(array)
 id24
 parent_id7
 brokerage_id166
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameUpper Cape Cod, MA, USA
 short_nameUpper Cape Cod, MA, USA
 group_index
 latitude41.896446
 longitude-70.552040
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 11:21:07
 modified2016-04-04 11:21:07
 timezoneAmerica/New_York
 population0
 uri/locations/view/24/upper-cape-cod-ma-usa
 tile_nameUpper Cape Cod, MA, USA
 Brokerage(array)
 id166
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID23511751
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameReal Estate Associates
 broker_of_record_name
 short_nameReal Estate Associates
 usernameRealEstateAssociates
 password348ba8892d60aa5fae48db2e4569b307d30c88c6
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionReal Estate Associates is the exclusive representative for Leverage Global Partners on the Upper Cape, Cape Cod; Bourne and the villages of Pocasset, Cataumet, Monument Beach, Bourne, Gray Gables, Buzzards Bay, Bournedale, Sagamore, Sagamore Beach, Sagamore Highlands. Mashpee and the villages of New Seabury, South Mashpee, Popponesset. Falmouth and the villages of Megansett, Silver Beach, North Falmouth, Hatchville, Falmouth, East Falmouth, West Falmouth, Waquoit, Sippewissett, Quissett, Woods Hole, Falmouth Heights, Maravista, Teaticket, Davisville, Massachusetts, USA. Real Estate Associates of Cape Cod is the Upper Cape's premier real estate agency for the high-end buyer. Proudly listing fine waterfront homes and estates in the towns of Falmouth, Bourne, and Mashpee, Real Estate Associates has a 40 year tradition of excellence representing buyers and sellers. Employing only the leading experts in the Cape Cod lifestyle, our agents match discerning homebuyers with the right home in the right neighborhood at the right price. Whether your buyer is looking for a deep water dock to pursue their boating passion, or quiet home overlooking a private beach and blazing sunsets, we have the home for your buyer and the knowledge to ensure a smooth sale. For those seeking to build their dream home, our agents can help them navigate the Cape's construction processes, even from a distance. With our combination of knowledgable agents, expert marketing techniques and investments in the latest real estate technology, Real Estate Associates provides the highest level of service imaginable.
 communitiesUpper Cape Cod Bourne Pocasset Cataumet Monument Beach Bourne Gray Gables Buzzards Bay Bournedale Sagamore Sagamore Beach Sagamore Highlands Mashpee New Seabury South Mashpee Popponesset Falmouth Megansett Silver Beach North Falmouth Hatchville Falmouth East Falmouth West Falmouth Waquoit Sippewissett Quissett Woods Hole Falmouth Heights Maravista Teaticket Davisville
 websitehttp://www.capecodhouses.com/
 address563 N. Falmouth Highway
 address_2
 cityNorth Falmouth
 stateMA
 full_stateMassachusetts
 countryUSA
 marketUpper Cape Cod
 market_2
 postal_code02556
 phoneOffice: (508) 563-7173
 phone_2Cell: (508) 264-1952
 phone_3
 wide_contact_image(false)
 contact_nameLynette Helms
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-real-estate-associates/
 contact_big_profile_link_textMeet Real Estate Associates
 contact_titleCEO
 contact_dre_num
 contact_quote
 contact_emaillhelms@capecodhouses.com
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename166.jpg
 logo_filename166.jpg
 contact_image_filename166.jpg
 all_properties_link_image_filename166.jpg
 all_properties_linkhttp://www.capecodhouses.com/app/snapshot/terabitzShare.php?key=VjMEYVEyWDVWYw==
 video_embed_code
 contact_video_embed_code
 meta_titleUpper Cape Cod Real Estate⎜Real Estate Associates⎜Leverage Global Partners
 meta_descriptionReal Estate Associates is the exclusive representative for Leverage Global Partners in Upper Cape Cod, MA, USA
 meta_keywordsReal Estate Associates, Upper Cape Cod Real Estate, Lynette Helms, Upper Cape Cod Real Estate, Bourne Real Estate, Pocasset Real Estate, Cataumet Real Estate, Monument Beach Real Estate, Bourne Real Estate, Gray Gables Real Estate, Buzzards Bay Real Estate, Bournedale Real Estate, Sagamore Real Estate, Sagamore Beach Real Estate, Sagamore Highlands Real Estate, Mashpee Real Estate, New Seabury Real Estate, South Mashpee Real Estate, Popponesset Real Estate, Falmouth Real Estate, Megansett Real Estate, Silver Beach Real Estate, North Falmouth Real Estate, Hatchville Real Estate, Falmouth Real Estate, East Falmouth Real Estate, West Falmouth Real Estate, Waquoit Real Estate, Sippewissett Real Estate, Quissett Real Estate, Woods Hole Real Estate, Falmouth Heights Real Estate, Maravista Real Estate, Teaticket Real Estate, Davisville Real Estate, Massachusetts, Leverage Global Partners
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-10-03 09:21:53
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/166/real-estate-associates
 website_shortwww.capecodhouses.com
 name_with_locationReal Estate Associates
 Image(array)
 id2951
 modelLocation
 model_id24
 tagImage
 nameUpper Cape Cod.jpg
 typeimage/jpeg
 size178475
 uri/assets/2951.jpg
 order0
 created2016-04-04 11:19:04
 modified2016-04-04 11:21:07
 2(array)
 Location(array)
 id26
 parent_id8
 brokerage_id99
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameOrlando, FL, USA
 short_nameOrlando, FL, USA
 group_index
 latitude28.538336
 longitude-81.379234
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 11:26:58
 modified2016-04-04 11:26:58
 timezoneAmerica/New_York
 population255000
 uri/locations/view/26/orlando-fl-usa
 tile_nameOrlando, FL, USA
 Brokerage(array)
 id99
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID12771965
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameFusilier Realty Group
 broker_of_record_name
 short_nameFusilier Realty Group
 usernameFusilierRealtyGroup
 passwordc2469a64cda51e8b0ea254a8f5426f218c65936d
 password_reset_hash
 monthly_invoice_amount500.00
 monthly_invoice_start_date2014-03-01
 monthly_invoice_end_date2015-02-28
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionFusilier Realty Group is the exclusive representative for Leverage Global Partners in Orlando, Florida, USA. More information coming soon! 
 communitiesorlando
 websitehttp://www.realtygroupfl.com/
 address9145 Narcoossee Road
 address_2Suite 102
 cityOrlando
 stateFL
 full_stateFlorida
 countryUSA
 marketOrlando
 market_2
 postal_code32827
 phoneOffice: (407) 281-8455
 phone_2Fax: (407) 218-7422
 phone_3
 wide_contact_image(false)
 contact_nameSteve Fusilier and Keith Race
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBrokers-in-Charge
 contact_dre_num
 contact_quote
 contact_emailSteveFusilier@yahoo.com
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2Keith@FMGRealEstate.com
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename99.jpg
 logo_filename99.jpg
 contact_image_filename99.jpg
 all_properties_link_image_filename99.jpg
 all_properties_linkhttp://www.realtygroupfl.com/purchase-residential-real-estate-lake-nona-orlando/
 video_embed_code
 contact_video_embed_code
 meta_titleOrlando Real Estate | Fusilier Realty Group | Leverage Global Partners
 meta_descriptionFusilier Realty Group is the exclusive representative for Leverage Global Partners in Orlando, Florida, USA.
 meta_keywordsOrlando Real Estate, Fusilier Realty Group, Leverage Global Partners, steve fusilier, keith race
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-02-24 16:37:04
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/99/fusilier-realty-group
 website_shortwww.realtygroupfl.com
 name_with_locationFusilier Realty Group
 Image(array)
 id2953
 modelLocation
 model_id26
 tagImage
 nameOrlando.jpg
 typeimage/jpeg
 size247259
 uri/assets/2953.jpg
 order0
 created2016-04-04 11:25:26
 modified2016-04-04 11:26:58
 3(array)
 Location(array)
 id42
 parent_id7
 brokerage_id162
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameUlster County, NY, USA
 short_nameUlster County, NY, USA
 group_index
 latitude41.858650
 longitude-74.311821
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 12:39:56
 modified2016-04-04 12:39:56
 timezoneAmerica/New_York
 population180000
 uri/locations/view/42/ulster-county-ny-usa
 tile_nameUlster County, NY, USA
 Brokerage(array)
 id162
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID12589367
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameMurphy Realty Group
 broker_of_record_name
 short_nameMurphy Realty Group
 usernameMurphyRealtyGroup
 password5492eed74b285e80d3597a297d44d6b21edff577
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionMurphy Realty Group is the exclusive representative for Leverage Global Partners in Ulster County, Kingston, Woodstock, Hurley, New Paltz, Stone Ridge, Saugerties, Gardiner, Rosendale, Phoenicia, Esopus, Highland, Shandaken, New York, USA. More information coming soon!
 communitiesUlster County Kingston Woodstock Hurley New Paltz Stone Ridge Saugerties Gardiner Rosendale Phoenicia Esopus Highland Shandaken
 websitehttp://www.murphyrealtygrp.com/
 address304 Wall Street
 address_2
 cityKingston
 stateNY
 full_stateNew York
 countryUSA
 marketUlster County
 market_2
 postal_code12401
 phoneOffice: (845) 338-5252
 phone_2Cell: (845) 453-0685
 phone_3
 wide_contact_image(false)
 contact_nameJohn Murphy
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner/Principal Broker
 contact_dre_num
 contact_quote
 contact_emailjm@murphyrealtygrp.com
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename162.jpg
 logo_filename162.jpg
 contact_image_filename162.jpg
 all_properties_link_image_filename162.jpg
 all_properties_linkhttp://www.murphyrealtygrp.com/featured-listings.php
 video_embed_code
 contact_video_embed_code
 meta_titleUlster County Real Estate ⎜Murphy Realty Group⎜Leverage Global Partners
 meta_descriptionMurphy Realty Group is the exclusive representative for Leverage Global Partners in Ulster County, NY, USA.
 meta_keywordsMurphy Realty Group, Ulster County Real Estate, John Murphy,Ulster County, Kingston Real Estate, Woodstock Real Estate, Hurley Real Estate, New Paltz Real Estate, Stone Ridge Real Estate, Saugerties Real Estate, Gardiner Real Estate, Rosendale Real Estate, Phoenicia Real Estate, Esopus Real Estate, Highland Real Estate, Shandaken Real Estate, New York, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-09-17 17:24:12
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/162/murphy-realty-group
 website_shortwww.murphyrealtygrp.com
 name_with_locationMurphy Realty Group
 Image(array)
 id2970
 modelLocation
 model_id42
 tagImage
 nameUlster COunty.jpg
 typeimage/jpeg
 size205572
 uri/assets/2970.jpg
 order0
 created2016-04-04 12:39:43
 modified2016-04-04 12:39:56
- sidebar_articles(array)
 0(array)
 Article(array)
 id464
 modelLocation
 model_id46
 archived(false)
 medium_featured(true)
 large_featured(false)
 titleLocation: Austin
 authorLeverageRE
 date2016-03-17
 lead_inAs the capital of the Lone Star state, Austin is the fourth largest city in Texas and the 11th largest city in the nation. Calling itself the Live Music Capital of the World, it hosts the annual Austin City Limits Music Festival and south by southwest conference (two of the most recognizing music events in the world) and boasts the unofficial motto of “Keep Austin Weird,” which is seen frequently around the city on everything from T-shirts to bumper stickers.
 bodyWith a robust economy and ample job opportunities thanks to its high concentration of technology companies (Dell, IBM, 3M, Apple Inc., Google, and Facebook, among others). Austin has also been dubbed Silicon Hills. Despite its foothold in the corporate world, though, the city is still a college town at heart, home to the University of Texas. The city’s laid-back and cool atmosphere is a major draw for its residents, including celebrities, like Matthew McConaughey, Sandra Bullock, Andy Roddick, who go there to disappear. Besides great music, famous residents, and a thriving economy, here are just a few more reasons to love the city. <h2>WHERE TO EAT:</h2> <h2><img class="aligncenter size-full wp-image-12601 pure-img" src="/assets/3199.png" /><img class="aligncenter size-full wp-image-12587 pure-img" src="/assets/3200.png" /><img class="aligncenter size-full wp-image-12602 pure-img" src="/assets/3201.png" /><img class="aligncenter wp-image-12590 pure-img" src="/assets/3202.png" /><img class="aligncenter size-full wp-image-12588 pure-img" src="/assets/3203.png" /><img class="aligncenter size-full wp-image-12589 pure-img" src="/assets/3204.png" /></h2> <h2>WHERE TO GO:</h2> <h2><img class="aligncenter size-full wp-image-12591 pure-img" src="/assets/3205.png" /><img class="aligncenter size-full wp-image-12592 pure-img" src="/assets/3206.png" /><img class="aligncenter size-full wp-image-12593 pure-img" src="/assets/3207.png" /><img class="aligncenter size-full wp-image-12595 pure-img" src="/assets/3208.png" /><img class="aligncenter size-full wp-image-12596 pure-img" src="/assets/3209.png" />WHERE TO STAY:</h2> <img class="aligncenter size-full wp-image-12598 pure-img" src="/assets/3210.png" /><img class="aligncenter size-full wp-image-12597 pure-img" src="/assets/3211.png" />
 vimeo_id
 created2016-04-05 14:31:50
 modified2016-04-14 12:20:12
 uri/articles/view/464/location-austin
 Image(array)
 0(array)
 id3212
 modelArticle
 model_id464
 tagImage
 nameAustin-TX.jpg
 typeimage/jpg
 size1118043
 uri/assets/3212.jpg
 order0
 created2016-04-05 14:31:50
 modified2016-04-14 12:20:12
 1(array)
 Article(array)
 id455
 modelLocation
 model_id114
 archived(false)
 medium_featured(true)
 large_featured(true)
 titleLocation: Hawaii
 authorLeverageRE
 date2016-03-23
 lead_inThe country's youngest state (which joined the Union only in 1959) is something of an anomaly. It's the only one of the United States with a tropical rain forest and a royal palace, but it's also the only state that is made up entirely of islands-eight of them: Niihau, Kauai, Oahu, Maui, Molokai, Lanai, Kahoolawe, and the Big Island. Leverage Partners Mauna Kea Realty (Big Island), The Wailea Group (Maui), and East Oahu Realty (Oahu) can attest that each island has its own unique characteristics. But needless to say, wherever you are, you'll find an airy, summertime vibe year-round, with plenty of flower leis, luaus, and beach scenes.
 bodyEach of the Hawaiian islands has a distinct cultural relevance. The Big Island, for instance, which is as big as all the others combined, encompasses about 4,000 square miles. It's a trove of hidden beaches, volcanic national parks, rain forests, otherworldly waterfalls, and lush vegetation. <img class="aligncenter wp-image-12718 pure-img" src="/assets/3150.png" /> On Oahu, you'll find markers of both American history-Pearl Harbor, the USS Arizona Memorial-and Hawaiian history-the Iolani Palace and the Byodo-In Temple. It's also the location of the capital city, Honolulu, which is the biggest city in Hawaii. The island of Maui boasts pristine beaches and shimmering shores, but it also is home to the Road to Hana, one of the most traveled trails in the state. Here, we explore destinations on the three islands in greater depth and share all the places to get out and enjoy before you say, "Aloha." Located on Waikiki Beach, <a href="http://www.halekulani.com/" target="_blank">Halekulani</a> welcomes travelers to an oasis of sophisticated luxury, and is recognized as one of the world's finest and most acclaimed independent luxury hotels since its inception in 1984. <img class="aligncenter size-full wp-image-12711 pure-img" src="/assets/3151.png" /> Chef Peter Merriman had a vision for the growth of local agriculture and the potential of Hawaii's rich volcanic soils. He, along with twelve other prominent chefs, encouraged farmers to grow local fruits and vegetables, raise meats locally, and start a healthier more sustainable Hawaii. Showcasing locally sourced menus of fresh line caught fish, grass fed meats, and Hawaii grown produce, the authentic flavors of Hawaii await at <a href="https://www.merrimanshawaii.com/fish-house/" target="_blank">Merriman's</a>. <img class="aligncenter wp-image-12710 pure-img" src="/assets/3152.png" /> <h3>ZIPLINE AT UMAUMA FALLS</h3> Catch the view from the top on this outdoor adventure, which boasts two miles of ziplines and family-friendly fun. <img class="aligncenter wp-image-12709 pure-img" src="/assets/3153.png" /> <h3>DOLPHIN SNORKEL SWIM, KAILUA-KONA</h3> Swim with the dolphins in Hawaii's crystal-clear waters. The same company also offers whale watching. <img class="aligncenter wp-image-12712 pure-img" src="/assets/3154.png" /> <h3>WAIPIO VALLEY</h3> The waterfalls in Waipio Valley, on the Big Island, are some of the most exquisite in the state. For a rustic adventure, see them from horseback. <img class="aligncenter wp-image-12719 pure-img" src="/assets/3155.png" /> <h3>DIAMOND HEAD</h3> This crater was created by a giant eruption 300,000 years ago. Today, it's a landmark on Oahu, and a hiking trail (0.8 mile) winds through it. <img class="aligncenter wp-image-12716 pure-img" src="/assets/3156.png" /> <h3>HANAUMA BAY</h3> When you imagine waters so blue that they'd be perfect for a postcard, this is the image that comes to mind. Sign up to snorkel to see angelfish, butterflyfish, and yellow tangs galore. <img class="aligncenter wp-image-12714 pure-img" src="/assets/3157.png" /> <h3>THE HIGHWAY HANA</h3> Wind through approximately 600 curves on this Maui road to see the lush green countryside. <img class="aligncenter wp-image-12708 pure-img" src="/assets/3158.png" /> <h3>SNORKELING AT MOLOKINI</h3> Swim with the turtles and fish at this Maui gem. For those who like to stay a bit drier, the yacht that takes you out is the perfect place to get a tan. <img class="aligncenter wp-image-12715 pure-img" src="/assets/3159.png" />
 vimeo_id
 created2016-04-05 14:30:50
 modified2016-04-08 09:46:02
 uri/articles/view/455/location-hawaii
 Image(array)
 0(array)
 id3160
 modelArticle
 model_id455
 tagImage
 nameScreen-Shot-2016-03-23-at-3.51.26-PM.png
 typeimage/png
 size2749979
 uri/assets/3160.png
 order0
 created2016-04-05 14:30:54
 modified2016-04-08 09:46:03
 2(array)
 Article(array)
 id476
 modelArticle
 model_id0
 archived(false)
 medium_featured(true)
 large_featured(false)
 titleHow to Plan and Plant Your Own Vegetable Garden
 authorLeverageRE
 date2016-03-29
 lead_inDeciding to plant your own vegetable garden is a healthy plan and rewarding in many ways, but when confronted with the actual execution and all the planning and care taking required, it can seem a little daunting.
 bodyNever fear! It's actually as easy as 1-2-3-4 (and some numbers in between). Check out these easy tips on how to plant your own vegetable garden this year: <div> <img class="aligncenter wp-image-13010 pure-img" src="/assets/3289.png" /> <ol> <li>Picking out your vegetables: <ul> <li>Decide what produce you want to grow and what makes sense for your household.</li> <li>Don't get too eager and over populate your garden with produce you will waste.</li> <li><a href="http://www.eatingwell.com/food_news_origins/seasonal_local/gardening/13_easy_to_grow_vegetables_and_herbs" target="_blank" title="Easy to grow vegetables">Check out these easy to grow vegetables</a> including green beans, beets and carrots.</li> <li>Do your research to find out <a href="http://www.motherearthnews.com/organic-gardening/best-vegetable-seed-companies-zm0z11zsto.aspx" target="_blank" title="seeds">which seeds you want to buy</a>.</li> </ul> </li> <li>Choosing a place for your vegetable garden: <ul> <li>Try to pick a place close to the house for easy access.</li> <li>The average vegetable garden is 400 to 600 square feet.</li> <li>Full sunlight exposure is best for vegetable gardens. 6 hours minimum of sunlight is necessary for optimum growth.</li> <li>Access to plenty of water is key so consider setting up a sprinkler system.</li> </ul> </li> <li>Prepping the area: <ul> <li>Consider how you want to plant: Raw Cropping means you plant in rows versus Intensive cropping with closer spacing between the produce.</li> <li>Check the quality and drainage of the soil or you can opt to raise the beds and fill with new loam soil (<a href="http://www.thisoldhouse.com/toh/how-to/intro/0,,20258509,00.html" target="_blank" title="raise vegetable garden beds">see how to raise the vegetable garden beds here</a>).</li> <li>Plant your seeds!</li> </ul> </li> <li>Caring for your vegetables: <ul> <li>Your veggies are in a safe, light filled healthy soiled place.</li> <li>Ensure the crops receive about an inch of water a week.</li> <li>Weed your garden regularly. <a href="http://www.dummies.com/how-to/content/when-to-add-compost-to-your-garden-beds.navId-403804.html" target="_blank" title="Compost">Consider using a mulch or compost</a> to help promote healthy growth.</li> </ul> </li> </ol> Even if you don't have a green thumb, you can still plant your own vegetable garden this Spring and when you're eating a delicious salad with fresh, incredible produce that you grew yourself (with the help of the Internet, of course), you will be glad that you did it! <h6>Article originally appeared on <a href="http://www.thepartnerstrust.com/blog/2014/02/how-to-plant-your-own-vegetable-garden/" target="_blank">Partners Trust Blog</a></h6> </div>
 vimeo_id
 created2016-04-05 14:34:55
 modified2016-04-11 17:08:13
 uri/articles/view/476/how-to-plan-and-plant-your-own-vegetable-garden
 Image(array)
 0(array)
 id3290
 modelArticle
 model_id476
 tagImage
 nameScreen-Shot-2016-03-29-at-3.33.17-PM.png
 typeimage/png
 size2171199
 uri/assets/3290.png
 order0
 created2016-04-05 14:34:56
 modified2016-04-11 17:08:13
 3(array)
 Article(array)
 id468
 modelArticle
 model_id0
 archived(false)
 medium_featured(true)
 large_featured(false)
 titleShop the Store: A+R
 authorLeverageRE
 date2016-03-15
 lead_inThrough its Los Angeles outposts, A+R showcases its selection of home-related goods and accessories in a brick-and-mortar capacity, but it's their online portal that buyers might find the most seductive. The rabbit hole of a site allows shoppers to search by category (cooking, office, furniture, gadgets, travel, etc.) as well as material (ceramic, cork, leather, stone, wax, etc.), grouping finding unexpected ways, allowing shoppers to rethink typical décor. Whether looking for the perfect housewarming gift or conversational pieces for your own home, the site always offers a mix of the unusual and the unique.
 body<img class="aligncenter wp-image-12459 size-full pure-img" src="/assets/3251.png" /> <img class="aligncenter wp-image-12455 size-full pure-img" src="/assets/3252.png" /><img class="aligncenter wp-image-12456 pure-img" src="/assets/3253.png" />
 vimeo_id
 created2016-04-05 14:32:04
 modified2016-04-12 07:37:25
 uri/articles/view/468/shop-the-store-a-r
 Image(array)
 0(array)
 id3254
 modelArticle
 model_id468
 tagImage
 nameAR.png
 typeimage/png
 size260415
 uri/assets/3254.png
 order0
 created2016-04-05 14:32:04
 modified2016-04-12 07:37:25
- main_article(array)
 Article(array)
 id86
 modelBrokerage
 model_id36
 archived(false)
 medium_featured(false)
 large_featured(false)
 titleMeet Andrew Burns: Director of Burns and Burns
 authorLeverageRE
 date2013-08-27
 lead_in"Your integrity and your reputation are, without question, the most important things you've got," explains Andrew Burns, Director of Burns and Burns, when asked about the qualities of success that others see in him. "I work very hard to make sure that is upheld."
 body <img class="size-medium wp-image-1519 pure-img float-right" title="Andrew Burns | Burns and Burns | North Shore Australia" src="/assets/216.jpg" alt="Andrew Burns | Burns and Burns | North Shore Australia" width="200" height="300">Andrew calls himself "very lucky" to have been born and raised in the world of real estate. His mother, Julia, started Burns and Burns, along with Andrew's father, Richard, in 1978. Andrew jokes that he basically "finished my (school) exams on a Friday at 5 PM and started working in real estate the next morning," in 1981. His parents have been, and continue to be, great mentors for him. They provided the template for Andrew so that he could take the company to the level it is today: one of the leading full-service real estate companies in Sydney, Australia's exquisite North Shore. Located just thirty minutes from Sydney, the beautiful North Shore area, surrounded by parks, is home to some of the country's best educational systems, both public and private, and is, therefore, a very desirable location for families. Andrew, husband to Catherine, and father to sons Richard and James, takes pride in owning the only real estate company in the area open seven days a week. He believes that, although Sunday may be seen as a day of leisure, business opportunities abound. Burns jokes, "while others may go to the beach, we make sales." <h4>How have technology, social media and online marketing changed/challenged your approach to your business?</h4> <blockquote>Andrew: When I started in 1981, none of this existed; there is no question that technology has changed the way we do business. You have to engage in social media and do it effectively; trying to find the time to do it, without taking too much time away from other parts of the business, is a real challenge. However, customer service and your relationships with people are always going to be of utmost importance.</blockquote> <h4>How do you deal with the new 24-hours-a-day business expectations?</h4> <blockquote>Andrew: People want things done "yesterday." I make myself available all the time; I have my phone with me everywhere I go and if I were to leave the phone at home, I'd feel very guilty about that. Having Barbara, Office Manager, know everything that's going on with our clients gives her the ability to respond immediately, as well.</blockquote> <h4>What career accomplishments are you most proud of?</h4> <blockquote>Andrew: Figuring out what our clientele wants to achieve, helping them accomplish it, and seeing them happy with the results. We have quite a number of record sales in the area but we work at all price points.</blockquote> <img class="aligncenter size-large wp-image-1518 pure-img" src="/assets/217.jpg" alt="andrewburns2" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/andrewburns2-300x200.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/andrewburns2-585x390.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/andrewburns2-360x240.jpg 360w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/andrewburns2-600x400.jpg 600w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/andrewburns2.jpg 1500w" sizes="(max-width: 1500px) 100vw, 1500px"> Andrew prides himself with maintaining long-term relationships with his team with the goal of helping agents make as much as possible. He makes himself available to go out on listings with them, assist with negotiations and supports an open office space so that his agents can come to him at any time for assistance. As it is important to have something to enjoy outside of the office, Andrew plays touch football weekly, which is "good fun, good exercise and quite good for business, as well," as it is a sport that is enjoyed by the entire community, easily played by all ages. Leverage Global Partners is truly honored to have Andrew Burns and his team at Burns and Burns as a member of the network.
 vimeo_id
 created2016-02-25 14:08:55
 modified2016-04-05 14:41:06
 uri/articles/view/86/meet-andrew-burns-director-of-burns-and-burns
 flattened_topics(empty)
 ParentBrokerage(array)
 id36
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id10
 WOEID1105779
 timezoneAustralia/Sydney
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameBurns and Burns
 broker_of_record_name
 short_nameBurns and Burns
 usernameBurnsandBurns
 passwordbe51d1b789bbecb96033435959b9b44ba880003f
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionBurns and Burns is the exclusive representative for Leverage Global Partners on the North Shore and Upper North Shore of Sydney, Australia. Burns & Burns is a family business established for nearly 30 years and is one of the oldest continuing running real estate companies on the North Shore. Founded by Julia Burns, with husband Richard, son Andrew and daughter-in-law Catherine, the family concern has been blessed by long-term staff in both sales and support roles. This is shown by the strong work ethic and customer service, which results in 70% of the clients utilising Burns & Burns services being either repeat or referral customers. Julia and Andrew Burns have dominated the prestige market for over 30 years and, as such, have a track record and network unequalled on the North Shore. Indeed, it is no surprise that the highest sales records for the Upper North Shore are held by Burns & Burns in Pymble and Wahroonga. Knox Grammar School and other institutions have repeatedly used the trusted service of Burns & Burns over the last 30 years being the highest recommendation and of which the family are very proud. However, Burns & Burns deal in ALL price ranges and many of our staff have ‘grown-up’ with their clients, as they move from property to property which is the backbone of the firm and will continue to be so.
 communitiesUpper North Shore of Sydney, Australia North Shore of Sydney, Australia
 websitehttp://burnsandburns.com.au/home
 address1051 Pacific Highway
 address_2
 cityPymble
 state
 full_state
 countryAustralia
 marketSydney North Shore
 market_2
 postal_codeNSW 2073
 phone(+) 61 (0) 2 9449 9211
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameAndrew Burns
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-andrew-burns-director-of-burns-and-burns/
 contact_big_profile_link_text
 contact_titleDirector
 contact_dre_num
 contact_quote
 contact_emailandrew@burnsandburns.com.au
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename36.jpg
 logo_filename36.jpg
 contact_image_filename36.jpg
 all_properties_link_image_filename36.jpg
 all_properties_linkhttp://burnsandburns.com.au/listings/ressale
 video_embed_code
 contact_video_embed_code
 meta_titleSydney North Shore Real Estate | Burns and Burns | Leverage Global Partners
 meta_descriptionBurns and Burns is the exclusive representative for Leverage Global Partners in North Shore Sydney, Australia.
 meta_keywordsBurns & Burns, Burns & Burns real estate, North Shore Sydney real estate, Sydney Australia, Andrew Burns, leverage global partners
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-06-19 10:54:50
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/36/burns-and-burns
 website_shortburnsandburns.com.au/home
 name_with_locationBurns and Burns
 ParentLocation(array)
 id(null)
 parent_id(null)
 brokerage_id(null)
 type(null)
 archived(null)
 use_as_topic(null)
 name(null)
 short_name(null)
 group_index(null)
 latitude(null)
 longitude(null)
 country_code(null)
 north(null)
 south(null)
 east(null)
 west(null)
 zoom(null)
 short_description(null)
 long_description(null)
 created(null)
 modified(null)
 timezone(null)
 population(null)
 Image(array)
 0(array)
 id218
 modelArticle
 model_id86
 tagImage
 nameandrewburns3.jpg
 typeimage/jpg
 size712144
 uri/assets/218.jpg
 order0
 created2016-02-25 14:08:55
 modified2016-02-25 14:08:55
 Brokerage(empty)
 Location(empty)
 Property(empty)
 Topic(empty)
- locations(array)
 0(array)
 Location(array)
 id100
 parent_id6
 brokerage_id36
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameSydney North Shore, Australia
 short_nameSydney North Shore, Australia
 group_index
 latitude-33.753227
 longitude150.705200
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-05 13:27:10
 modified2016-04-05 13:27:10
 timezoneAustralia/Sydney
 population207000
 uri/locations/view/100/sydney-north-shore-australia
 tile_nameSydney North Shore, Australia
 Brokerage(array)
 id36
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id10
 WOEID1105779
 timezoneAustralia/Sydney
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameBurns and Burns
 broker_of_record_name
 short_nameBurns and Burns
 usernameBurnsandBurns
 passwordbe51d1b789bbecb96033435959b9b44ba880003f
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionBurns and Burns is the exclusive representative for Leverage Global Partners on the North Shore and Upper North Shore of Sydney, Australia. Burns & Burns is a family business established for nearly 30 years and is one of the oldest continuing running real estate companies on the North Shore. Founded by Julia Burns, with husband Richard, son Andrew and daughter-in-law Catherine, the family concern has been blessed by long-term staff in both sales and support roles. This is shown by the strong work ethic and customer service, which results in 70% of the clients utilising Burns & Burns services being either repeat or referral customers. Julia and Andrew Burns have dominated the prestige market for over 30 years and, as such, have a track record and network unequalled on the North Shore. Indeed, it is no surprise that the highest sales records for the Upper North Shore are held by Burns & Burns in Pymble and Wahroonga. Knox Grammar School and other institutions have repeatedly used the trusted service of Burns & Burns over the last 30 years being the highest recommendation and of which the family are very proud. However, Burns & Burns deal in ALL price ranges and many of our staff have ‘grown-up’ with their clients, as they move from property to property which is the backbone of the firm and will continue to be so.
 communitiesUpper North Shore of Sydney, Australia North Shore of Sydney, Australia
 websitehttp://burnsandburns.com.au/home
 address1051 Pacific Highway
 address_2
 cityPymble
 state
 full_state
 countryAustralia
 marketSydney North Shore
 market_2
 postal_codeNSW 2073
 phone(+) 61 (0) 2 9449 9211
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameAndrew Burns
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-andrew-burns-director-of-burns-and-burns/
 contact_big_profile_link_text
 contact_titleDirector
 contact_dre_num
 contact_quote
 contact_emailandrew@burnsandburns.com.au
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename36.jpg
 logo_filename36.jpg
 contact_image_filename36.jpg
 all_properties_link_image_filename36.jpg
 all_properties_linkhttp://burnsandburns.com.au/listings/ressale
 video_embed_code
 contact_video_embed_code
 meta_titleSydney North Shore Real Estate | Burns and Burns | Leverage Global Partners
 meta_descriptionBurns and Burns is the exclusive representative for Leverage Global Partners in North Shore Sydney, Australia.
 meta_keywordsBurns & Burns, Burns & Burns real estate, North Shore Sydney real estate, Sydney Australia, Andrew Burns, leverage global partners
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-06-19 10:54:50
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/36/burns-and-burns
 website_shortburnsandburns.com.au/home
 name_with_locationBurns and Burns
 Image(array)
 id3034
 modelLocation
 model_id100
 tagImage
 namesydney.jpg
 typeimage/jpeg
 size118591
 uri/assets/3034.jpg
 order0
 created2016-04-05 13:25:05
 modified2016-04-05 13:27:10
- stats_modules(array)
 None
 agentsagents ready to help
 years_in_serviceyears in service
 office_locationsoffice locations
 markets_servedmarkets served
 listingsproperties listed
- custom_ga_event_properties(array)
 brokerageBurns and Burns, Pymble
- brokerage(array)
 Brokerage(array)
 id36
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id10
 WOEID1105779
 timezoneAustralia/Sydney
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameBurns and Burns
 broker_of_record_name
 short_nameBurns and Burns
 usernameBurnsandBurns
 passwordbe51d1b789bbecb96033435959b9b44ba880003f
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionBurns and Burns is the exclusive representative for Leverage Global Partners on the North Shore and Upper North Shore of Sydney, Australia. Burns & Burns is a family business established for nearly 30 years and is one of the oldest continuing running real estate companies on the North Shore. Founded by Julia Burns, with husband Richard, son Andrew and daughter-in-law Catherine, the family concern has been blessed by long-term staff in both sales and support roles. This is shown by the strong work ethic and customer service, which results in 70% of the clients utilising Burns & Burns services being either repeat or referral customers. Julia and Andrew Burns have dominated the prestige market for over 30 years and, as such, have a track record and network unequalled on the North Shore. Indeed, it is no surprise that the highest sales records for the Upper North Shore are held by Burns & Burns in Pymble and Wahroonga. Knox Grammar School and other institutions have repeatedly used the trusted service of Burns & Burns over the last 30 years being the highest recommendation and of which the family are very proud. However, Burns & Burns deal in ALL price ranges and many of our staff have ‘grown-up’ with their clients, as they move from property to property which is the backbone of the firm and will continue to be so.
 communitiesUpper North Shore of Sydney, Australia North Shore of Sydney, Australia
 websitehttp://burnsandburns.com.au/home
 address1051 Pacific Highway
 address_2
 cityPymble
 state
 full_state
 countryAustralia
 marketSydney North Shore
 market_2
 postal_codeNSW 2073
 phone(+) 61 (0) 2 9449 9211
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameAndrew Burns
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-andrew-burns-director-of-burns-and-burns/
 contact_big_profile_link_text
 contact_titleDirector
 contact_dre_num
 contact_quote
 contact_emailandrew@burnsandburns.com.au
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename36.jpg
 logo_filename36.jpg
 contact_image_filename36.jpg
 all_properties_link_image_filename36.jpg
 all_properties_linkhttp://burnsandburns.com.au/listings/ressale
 video_embed_code
 contact_video_embed_code
 meta_titleSydney North Shore Real Estate | Burns and Burns | Leverage Global Partners
 meta_descriptionBurns and Burns is the exclusive representative for Leverage Global Partners in North Shore Sydney, Australia.
 meta_keywordsBurns & Burns, Burns & Burns real estate, North Shore Sydney real estate, Sydney Australia, Andrew Burns, leverage global partners
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-06-19 10:54:50
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/36/burns-and-burns
 website_shortburnsandburns.com.au/home
 name_with_locationBurns and Burns
 Logo(array)
 id2344
 modelBrokerage
 model_id36
 tagLogo
 name36.jpg
 typeimage/jpg
 size470882
 uri/assets/2344.jpg
 order0
 created2016-03-30 11:37:49
 modified2016-03-30 11:37:49
 MainImage(array)
 id2343
 modelBrokerage
 model_id36
 tagMainImage
 name36.jpg
 typeimage/jpg
 size645963
 uri/assets/2343.jpg
 order0
 created2016-03-30 11:37:48
 modified2016-03-30 11:37:48
 ContactImage(array)
 id2345
 modelBrokerage
 model_id36
 tagContactImage
 name36.jpg
 typeimage/jpg
 size19112
 uri/assets/2345.jpg
 order0
 created2016-03-30 11:37:49
 modified2016-03-30 11:37:49
 ContactImage2(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 ContactImage3(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 BrokerOfRecordLogo(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 FeaturedImage(empty)
- membership_subscription_temp_allowed_login(null)
- newsletter_member_types(array)
 Leverage Member: AgentLeverage Member: Agent
 Leverage Member: Broker or ManagementLeverage Member: Broker or Management
 Non-MemberNon-Member
- $request->data(empty)
- $this->validationErrors(array)
 Subscription(empty)
 Brokerage(empty)
 Logo(empty)
 BrokerOfRecordLogo(empty)
 MainImage(empty)
 FeaturedImage(empty)
 ContactImage(empty)
 ContactImage2(empty)
 ContactImage3(empty)
 Location(empty)
 Image(empty)
 Article(empty)
 Property(empty)
 User(empty)
 PropertyFeature(empty)
 SecondaryPropertyCategory(empty)
 Topic(empty)
 ParentBrokerage(empty)
 ParentLocation(empty)
 ArticlesBrokerage(empty)
 ArticlesLocation(empty)
 ArticlesProperty(empty)
 ArticlesTopic(empty)
 MlsComplianceData(empty)
- Loaded Helpers(array)
 0Permission
 1Number
 2SimpleGraph
 3DebugTimer
 4Toolbar
 5Session
 6Text
 7Flash
 8HtmlToolbar
 9Html
 10Form
====

Environment

App Constants

Constant	Value
CONFIG	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Config/
GOOGLE_MAPS_PUBLIC_API_KEY	AIzaSyCD2zmgSzOEN-7tNHYSmGXL0MyWtMlHND4
GOOGLE_MAPS_PRIVATE_API_KEY	AIzaSyCIXpqYsaZp4_suK7IWeqUTIEbS_hMkoXs
RECAPTCHA_V2_SITE_KEY	6Lfs_EoUAAAAAKe8XSwR8p7AEMOLWB96veSLjRDv
RECAPTCHA_V2_SECRET_KEY	6Lfs_EoUAAAAAIo2vzNYILL-YwBaRxvTpjuemmKZ
PROTOCOL	https://
WEB_ENV	staging2
WEB_BASE_URL	https://staging2.leveragere.com
PROP_EMAIL_RECIPIENT	chris@jloop.com
STRIPE_ISSUES_EMAIL_RECIPIENT	chris@jloop.com
STRIPE_ENV	test
STRIPE_PK	pk_test_fIc7eHMfMVAhnrld2Vk2DDpG
STRIPE_SK	sk_test_D4NvWbVo5Fe04IJM0AItMKIR
SHELL_LAUNCHER	/opt/plesk/php/7.4/bin/php /var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Console/cake.php

CakePHP Constants

Constant	Value
APP	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/
APP_DIR	app
APPLIBS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Lib/
CACHE	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/tmp/cache/
CAKE	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib
CORE_PATH	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib/
CAKE_VERSION	2.10.19
CSS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://staging2.leveragere.com
IMAGES	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/img/
IMAGES_URL	img/
JS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/js/
JS_URL	js/
LOGS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/tmp/logs/
ROOT	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs
TESTS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Test/
TMP	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/tmp/
VENDORS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	7.4.33
User	leveragere
Home	/var/www/vhosts/leveragere.com
Script Name	/index.php
Request Uri	/brokerage-detail/36/burns-and-burns
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/brokerage-detail/36/burns-and-burns
Remote Port	16919
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	162.159.115.42
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http Cf Ray	a09e02d93ff521ca-CMH
Http Accept Encoding	gzip, br
Http Cookie	CAKEPHP=m6tn9clqbi226v9dkbh73km8g1
Http Accept	/
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http X Forwarded For	216.73.216.172
Proxy-nokeepalive	1
Ssl Tls Sni	staging2.leveragere.com
Https	on
Passenger Download Native Support Binary	0
Passenger Compile Native Support Binary	0
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Unique Id	aio_PFLEEfcqtnCHo5Uv4AAAAAU
Redirect Status	200
Redirect Ssl Tls Sni	staging2.leveragere.com
Redirect Https	on
Redirect Passenger Download Native Support Binary	0
Redirect Passenger Compile Native Support Binary	0
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Unique Id	aio_PFLEEfcqtnCHo5Uv4AAAAAU
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781153596.3718
Request Time	1781153596

====

Include
+
Included Files

Include Paths
- 0/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib
- 2/opt/plesk/php/7.4/share/pear
- 3-> /var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/AuthComponent.php
  1CORE/Controller/Component/SessionComponent.php
  2CORE/Controller/Component/CookieComponent.php
  3CORE/Controller/Component/RequestHandlerComponent.php
  4CORE/Controller/Component/Auth/FormAuthenticate.php
  5CORE/Controller/Component/Auth/BaseAuthenticate.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/CakeObject.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/RedirectRoute.php
  7CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/CakeText.php
  5CORE/Utility/ClassRegistry.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Component(array)
  0APP/Controller/Component/PermissionComponent.php
  1APP/Controller/Component/LocationSearchComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/BrokeragesController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/Subscription.php
  1APP/Model/AppModel.php
  2APP/Model/Brokerage.php
  3APP/Model/Asset.php
  4APP/Model/Location.php
  5APP/Model/Article.php
  6APP/Model/Property.php
  7APP/Model/User.php
  8APP/Model/PropertyFeature.php
  9APP/Model/PropertyCategory.php
  10APP/Model/Topic.php
  11APP/Model/MlsComplianceData.php
  Other(array)
  0APP/webroot/index.php
  1APP/Vendor/permissions.php
- plugins(array)
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
====

Burns and Burns

Connect With Us

Read Our Profile

Meet Andrew Burns: Director of Burns and Burns

Burns and Burns Featured Properties

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 10 ms Total Queries: 15 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 10 ms
Total Queries: 15 queries