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 = '30'
$brokerage = array(
	'Brokerage' => array(
		'password' => '*****',
		'id' => '30',
		'account_executive_id' => '0',
		'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' => '3',
		'membership_luxury_feed_properties' => '0',
		'can_participate_in_lux_feed_while_archived' => false,
		'full_training_video_access' => false,
		'WOEID' => '2161853',
		'timezone' => 'Asia/Hong_Kong',
		'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_auto_import_minimum_price' => '0',
		'mlsidx_logo_url' => '',
		'mlsidx_disclaimer' => '',
		'name' => 'Asia Pacific Properties',
		'broker_of_record_name' => '',
		'short_name' => 'Asia Pacific Properties',
		'username' => '',
		'password_reset_hash' => '',
		'monthly_invoice_amount' => '0.00',
		'monthly_invoice_start_date' => '0000-00-00',
		'monthly_invoice_end_date' => '0000-00-00',
		'contract_filename' => '',
		'active' => false,
		'lead_in' => '',
		'short_description' => '',
		'description' => '<p>We're excited to announce that Asia Pacific Properties is the exclusive representative for Leverage Global Partners in Shenzhen, China.</p>
<p>More information is coming soon.</p>',
		'communities' => 'Shenzhen China',
		'website' => 'http://www.asiapacificproperties.com/',
		'address' => 'Coming Soon',
		'address_2' => '',
		'city' => 'Shenzhen',
		'state' => '',
		'full_state' => '',
		'country' => '',
		'market' => '',
		'market_2' => '',
		'postal_code' => '',
		'phone' => 'Coming Soon',
		'phone_2' => '',
		'phone_3' => '',
		'wide_contact_image' => false,
		'contact_name' => 'Beverly L.W. Sunn',
		'contact_profile_link' => '',
		'contact_big_profile_link' => '',
		'contact_big_profile_link_text' => '',
		'contact_title' => 'President',
		'contact_dre_num' => '',
		'contact_quote' => '',
		'contact_email' => 'sunn@asiapacificproperties.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_filename' => '30.jpg',
		'logo_filename' => '30.gif',
		'contact_image_filename' => '30.jpg',
		'all_properties_link_image_filename' => '',
		'all_properties_link' => '',
		'video_embed_code' => '',
		'contact_video_embed_code' => '',
		'meta_title' => 'Shenzhen Real Estate | Asia Pacific Properties | Leverage Global Partners',
		'meta_description' => 'Asia Pacific Properties is the exclusive representative for Leverage Global Partners in Shenzhen, China.',
		'meta_keywords' => 'shenzhen real estate, asia pacific properties, leverage global partners, beverly sunn',
		'login_message_counter' => '0',
		'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-05-24 18:28:22',
		'modified' => '2016-02-26 15:37:56',
		'country_id' => '2',
		'dre_num' => '012345',
		'uri' => '/brokerage-detail/30/asia-pacific-properties',
		'website_short' => 'www.asiapacificproperties.com',
		'name_with_location' => 'Asia Pacific Properties'
	),
	'Logo' => array(
		'id' => '482',
		'model' => 'Brokerage',
		'model_id' => '30',
		'tag' => 'Logo',
		'name' => '30.gif',
		'type' => 'image/gif',
		'size' => '',
		'uri' => '',
		'order' => '0',
		'created' => '2016-02-26 15:03:22',
		'modified' => '2016-02-26 15:03:22'
	),
	'MainImage' => array(
		'id' => '481',
		'model' => 'Brokerage',
		'model_id' => '30',
		'tag' => 'MainImage',
		'name' => '30.jpg',
		'type' => 'image/jpg',
		'size' => '',
		'uri' => '',
		'order' => '0',
		'created' => '2016-02-26 15:03:22',
		'modified' => '2016-02-26 15:03:22'
	),
	'ContactImage' => array(
		'id' => '483',
		'model' => 'Brokerage',
		'model_id' => '30',
		'tag' => 'ContactImage',
		'name' => '30.jpg',
		'type' => 'image/jpg',
		'size' => '',
		'uri' => '',
		'order' => '0',
		'created' => '2016-02-26 15:03:22',
		'modified' => '2016-02-26 15:03:22'
	),
	'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 | Asia Pacific Properties

Properties / Asia Pacific Properties

Asia Pacific Properties

President: Beverly L.W. Sunn
Coming Soon

License #: 012345

Visit Website

We're excited to announce that Asia Pacific Properties is the exclusive representative for Leverage Global Partners in Shenzhen, China.

More information is coming soon.

Connect With Us

www.asiapacificproperties.com

Asia Pacific Properties Featured Properties

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

History
+
Request History
4 previous requests available
====
Session
+
Session
- 0(null)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerbrokerages
- actionview
- named(empty)
- pass(array)
  030
  1asia-pacific-properties
- 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: 6 ms
Total Queries: 10 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`.`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_auto_import_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`.`country_id`, `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_dev2`.`brokerages` AS `Brokerage` LEFT JOIN `leveragere_dev2`.`assets` AS `Logo` ON (`Logo`.`model_id` = `Brokerage`.`id` AND `Logo`.`model` = 'Brokerage' AND `Logo`.`tag` = 'Logo') LEFT JOIN `leveragere_dev2`.`assets` AS `MainImage` ON (`MainImage`.`model_id` = `Brokerage`.`id` AND `MainImage`.`model` = 'Brokerage' AND `MainImage`.`tag` = 'MainImage') LEFT JOIN `leveragere_dev2`.`assets` AS `ContactImage` ON (`ContactImage`.`model_id` = `Brokerage`.`id` AND `ContactImage`.`model` = 'Brokerage' AND `ContactImage`.`tag` = 'ContactImage') LEFT JOIN `leveragere_dev2`.`assets` AS `ContactImage2` ON (`ContactImage2`.`model_id` = `Brokerage`.`id` AND `ContactImage2`.`model` = 'Brokerage' AND `ContactImage2`.`tag` = 'ContactImage2') LEFT JOIN `leveragere_dev2`.`assets` AS `ContactImage3` ON (`ContactImage3`.`model_id` = `Brokerage`.`id` AND `ContactImage3`.`model` = 'Brokerage' AND `ContactImage3`.`tag` = 'ContactImage3') LEFT JOIN `leveragere_dev2`.`assets` AS `BrokerOfRecordLogo` ON (`BrokerOfRecordLogo`.`model_id` = `Brokerage`.`id` AND `BrokerOfRecordLogo`.`model` = 'Brokerage' AND `BrokerOfRecordLogo`.`tag` = 'BrokerOfRecordLogo') WHERE `Brokerage`.`id` = 30 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_dev2`.`assets` AS `FeaturedImage` WHERE `FeaturedImage`.`model` = 'Brokerage' AND `FeaturedImage`.`tag` = 'FeaturedImage' AND `FeaturedImage`.`model_id` = (30) 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`.`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`.`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_auto_import_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`.`country_id`, `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_dev2`.`locations` AS `Location` LEFT JOIN `leveragere_dev2`.`brokerages` AS `Brokerage` ON (`Location`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_dev2`.`assets` AS `Image` ON (`Image`.`model_id` = `Location`.`id` AND `Image`.`model` = 'Location' AND `Image`.`tag` = 'Image') WHERE `Location`.`brokerage_id` = 30 AND `Location`.`archived` = '0'	0	0	1	maybe slow
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`.`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_auto_import_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`.`country_id`, `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`.`short_description`, `ParentLocation`.`long_description`, `ParentLocation`.`created`, `ParentLocation`.`modified`, `ParentLocation`.`timezone`, `ParentLocation`.`population` FROM `leveragere_dev2`.`articles` AS `Article` LEFT JOIN `leveragere_dev2`.`brokerages` AS `ParentBrokerage` ON (`Article`.`model_id` = `ParentBrokerage`.`id` AND `Article`.`model` = 'Brokerage') LEFT JOIN `leveragere_dev2`.`locations` AS `ParentLocation` ON (`Article`.`model_id` = `ParentLocation`.`id` AND `Article`.`model` = 'Location') WHERE `Article`.`model` = 'Brokerage' AND `Article`.`model_id` = 30 LIMIT 1	0	0	1	maybe slow
SELECT `Article`.`id` FROM `leveragere_dev2`.`articles` AS `Article` WHERE `Article`.`archived` = '0' AND NOT (`Article`.`model` = ('News')) ORDER BY `Article`.`created` DESC LIMIT 50	50	50	0
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_dev2`.`assets` AS `Image` WHERE `Image`.`model` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (80, 79, 78, 77, 76, 75, 74, 73, 72, 71, 70, 69, 68, 67, 66, 65, 64, 63, 62, 61, 60, 59, 58, 57, 56, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 37, 38, 36, 35, 34, 33, 32, 31, 30, 29, 28, 27, 26, 24) ORDER BY `Image`.`order` ASC	52	52	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_dev2`.`articles` AS `Article` WHERE `Article`.`id` IN (80, 79, 78, 77, 76, 75, 74, 73, 72, 71, 70, 69, 68, 67, 66, 65, 64, 63, 62, 61, 60, 59, 58, 57, 56, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 37, 38, 36, 35, 34, 33, 32, 31, 30, 29, 28, 27, 26, 24) 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_dev2`.`assets` AS `Image` WHERE `Image`.`model` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (46, 65, 30, 24) 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`.`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`.`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_auto_import_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`.`country_id`, `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_dev2`.`locations` AS `Location` LEFT JOIN `leveragere_dev2`.`brokerages` AS `Brokerage` ON (`Location`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_dev2`.`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	1	maybe slow
SELECT `MlsComplianceData`.`id`, `MlsComplianceData`.`mlsidx_brokerage_id`, `MlsComplianceData`.`mlsidx_logo_url`, `MlsComplianceData`.`mlsidx_disclaimer`, `MlsComplianceData`.`created`, `MlsComplianceData`.`modified` FROM `leveragere_dev2`.`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 9.84 MB

Message	Memory use
Component initialization	2.92 MB
Controller action start	3.84 MB
Controller render start	5.99 MB
View render complete	6.54 MB

Timers

Total Request Time: 165 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	25.14
Event: Controller.initialize	3.78
Event: Controller.startup	1.08
Controller action	26.09
Event: Controller.beforeRender	6.76
» Processing toolbar data	6.66
Rendering View	81.74
» Event: View.beforeRender	0.25
» Rendering APP/View/Brokerages/view.ctp	0.69
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.21
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	80.14
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)
 id16
 parent_id15
 brokerage_id100
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameOrlando, FL, USA
 short_nameOrlando, FL, USA
 group_index
 latitude28.497662
 longitude-81.342773
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 short_description
 long_description
 created2019-08-20 16:04:26
 modified2019-08-20 16:14:30
 timezone
 population0
 uri/locations/view/16/orlando-fl-usa
 tile_nameOrlando, FL, USA
 Brokerage(array)
 id100
 account_executive_id0
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 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)
 WOEID(null)
 timezone
 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_auto_import_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameFusilier Realty Group
 broker_of_record_name
 short_nameFusilier Realty Group
 username
 password
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_inFusilier Realty Group is the exclusive representative for Leverage Global Partners in Orlando, Florida, USA.
 short_description
 descriptionFusilier Realty Group is located in the premiere Lake Nona area, home of Orlando's Medical City. Our agents have years of expertise in the South East Orlando and Saint Cloud region and are active members of the Local, State, and National Real Estate Association. Our dynamic, progressive, and savvy sales team is dedicated to fulfilling every client's needs. Our agency was founded on the belief that selling real estate can be an exciting and enjoyable experience for both buyer and seller.” Lake Nona Office 9145 Narcoosee Rd, Ste. 102 Orlando, FL 32827 407-281-8455 Harmony Office 7272 Harmony Square Dr, Harmony, FL 34773 407-259-2394 
 communitiesorlando
 websitehttp://www.realtygroupfl.com/
 address9145 Narcoossee Road
 address_2Suite 102
 cityOrlando
 stateFL
 full_stateFlorida
 countryUSA
 market
 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_emailchris@jloop.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_filename
 logo_filename
 contact_image_filename
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_title
 meta_description
 meta_keywords
 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(false)
 created2019-08-20 16:11:48
 modified2019-08-20 16:11:48
 country_id0
 dre_num012345
 uri/brokerage-detail/100/fusilier-realty-group
 website_shortwww.realtygroupfl.com
 name_with_locationFusilier Realty Group
 Image(array)
 id1628
 modelLocation
 model_id16
 tagImage
 namemobile_tile_FPO.png
 typeimage/png
 size16560
 uri/assets/1628.png
 order0
 created2019-08-20 16:04:24
 modified2019-08-20 16:14:30
 1(array)
 Location(array)
 id11
 parent_id6
 brokerage_id95
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameMagic Town LONG
 short_nameMagic Town SHORT
 group_index
 latitude37.077366
 longitude-95.786880
 country_code
 north0.000000
 south0.000000
 east0.000000
 west0.000000
 short_descriptionWhere people have antlers and are elk.
 long_descriptionLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
 created2016-03-11 11:19:58
 modified2016-05-06 13:43:56
 timezoneAmerica/Aruba
 population1337
 uri/locations/view/11/magic-town-long
 tile_nameMagic Town LONG
 Brokerage(array)
 id95
 account_executive_id8
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties20
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties-1
 membership_luxury_feed_properties-1
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 WOEID(null)
 timezone
 luxury_feed_enrollment_modeauto
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contactschris@jloop.com,swabby@mailinator.com
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id111
 mlsidx_auto_import_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameA 2.0 Brokerage
 broker_of_record_name
 short_name2.0 Brokerage
 usernametheusername
 password
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_inLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
 short_descriptionLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 descriptionLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. <figure><iframe allowfullscreen="1" frameborder="0" src="https://www.youtube.com/embed/XfR9iY5y94s?autoplay=0"></iframe> <figcaption>I come from a land down unda!</figcaption> </figure> 
 communitiesBelmont Shore
 websitehttp://jloop.com
 address425 E. 4th Street
 address_2Unit C
 cityLong Beach
 stateCA
 full_stateCalifornia
 countryUSA
 market
 market_2
 postal_code90802
 phone8888888888
 phone_2
 phone_3
 wide_contact_image(true)
 contact_nameChris Stevens
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCool Guy
 contact_dre_num
 contact_quote
 contact_emailchris@jloop.com
 contact_facebookhttp://jloop.com
 contact_twitter/debug
 contact_instagramhttp://moo.com
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2melissa@jloop.com
 contact_2_facebook
 contact_2_twitterhttp://jloop.com
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_28888888888
 contact_website
 contact_name_2Jane Doe
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2Boss
 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
 logo_filename
 contact_image_filename
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_title
 meta_description
 meta_keywords
 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)
 created2016-02-16 14:31:44
 modified2023-05-15 14:56:46
 country_id0
 dre_num012345
 uri/brokerage-detail/95/a-2-0-brokerage
 website_shortjloop.com
 name_with_locationA 2.0 Brokerage
 mlsidx_id_array(array)
 0111
 Image(array)
 id741
 modelLocation
 model_id11
 tagImage
 namehirsch-red-deer-cervus-elaphus-antler.jpg
 typeimage/jpeg
 size164333
 uri/assets/741.jpg
 order0
 created2016-03-11 11:19:05
 modified2016-05-06 13:43:56
 2(array)
 Location(array)
 id10
 parent_id8
 brokerage_id55
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameTestwood
 short_nameTestwood
 group_index
 latitude34.052235
 longitude-118.243683
 country_code
 north0.000000
 south0.000000
 east0.000000
 west0.000000
 short_descriptionThis is the short description
 long_descriptionThis is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description.
 created2016-03-04 17:12:14
 modified2016-11-04 13:59:00
 timezoneAmerica/Los_Angeles
 population4294967295
 uri/locations/view/10/testwood
 tile_nameTestwood
 Brokerage(array)
 id55
 account_executive_id0
 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_properties3
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 WOEID2434561
 timezone
 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_auto_import_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameJ. Rockcliff Realtors
 broker_of_record_name
 short_nameJ Rockcliff Realtors
 username
 password
 password_reset_hash
 monthly_invoice_amount0.00
 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 Lafayette, Moraga, Orinda, and Canyon, California, USA. 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 LaMorinda (Lafayette, Moraga, Orinda), Walnut Creek, Danville, Blackhawk, and Pleasanton/Dublin/Livermore, 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/56/J.-Rockcliff-Realtors">Walnut Creek</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Danville</a>, and <a href="../../../brokerage-detail/57/J.-Rockcliff-Realtors">Pleasanton</a>.
 communitiesMoraga Lafayette Orinda Canyon LaMorinda
 websitehttp://www.rockcliff.com/
 address3799 Mt. Diablo Boulevard
 address_2Suite 100
 cityLafayette
 stateCA
 full_stateCalifornia
 countryUSA
 marketLafayette
 market_2
 postal_code
 phone(925) 385-2330
 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_filename55.jpg
 logo_filename55.JPG
 contact_image_filename55.jpg
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_titleLafayette Real Estate | J. Rockcliff Realtors | Leverage Global Partners
 meta_descriptionJ. Rockcliff Realtors is the exclusive representative for Leverage Global Partners in Lafayette, CA, USA.
 meta_keywordsJ. Rockcliff Realtors, Lafayette 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 14:43:00
 modified2018-01-19 16:49:53
 country_id1
 dre_num012345
 uri/brokerage-detail/55/j-rockcliff-realtors
 website_shortwww.rockcliff.com
 name_with_locationJ. Rockcliff Realtors
 Image(array)
 id733
 modelLocation
 model_id10
 tagImage
 namepexels-photo-52599.jpeg
 typeimage/jpeg
 size120826
 uri/assets/733.jpeg
 order0
 created2016-03-04 17:10:53
 modified2016-11-04 13:59:00
 3(array)
 Location(array)
 id21
 parent_id6
 brokerage_id102
 typeExclusive
 archived(false)
 use_as_topic(false)
 namePasadena, CA, USA
 short_namePasadena
 group_index
 latitude34.147785
 longitude-118.144516
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 short_descriptionThe city is known for hosting the annual Rose Bowl football game and Tournament of Roses Parade
 long_description
 created2019-10-29 17:54:03
 modified2019-10-29 17:54:58
 timezoneAmerica/Los_Angeles
 population0
 uri/locations/view/21/pasadena-ca-usa
 tile_namePasadena, CA, USA
 Brokerage(array)
 id102
 account_executive_id0
 archived(false)
 typeteam
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties12
 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)
 WOEID(null)
 timezone
 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_auto_import_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameCompass
 broker_of_record_namePartners Trust
 short_nameCompass
 username
 password
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_inYou've tried the rest, now try the best
 short_description
 descriptionLorem ipsum dolor sit amet, consectetur adipiscing elit. Sed et est ut dui hendrerit auctor sit amet ut lorem. Proin eleifend tristique felis. Curabitur bibendum enim mauris, nec volutpat lectus aliquam a. Vestibulum laoreet tellus ac porta consectetur. Quisque quam tellus, tempus vel sollicitudin id, convallis ut erat. Nullam laoreet aliquet sapien non porttitor. Curabitur eu commodo quam, in pellentesque nibh. Etiam non dolor fermentum velit commodo feugiat a ut augue. Sed faucibus tincidunt vestibulum. Pellentesque tincidunt sed lorem at efficitur. Suspendisse maximus arcu eget fermentum pharetra. Praesent dapibus justo sit amet vestibulum molestie. Nullam eu faucibus nisi, sed lacinia eros. Quisque finibus nec ante eu scelerisque. In hac habitasse platea dictumst. Nam turpis augue, ornare sed odio a, placerat vestibulum augue. Curabitur posuere turpis sed nisl tempus, id feugiat ipsum dictum. Praesent venenatis pharetra nunc at tincidunt. Ut sollicitudin quam sit amet tortor molestie, at bibendum diam cursus. Cras ac metus vitae sapien condimentum consequat sit amet eget metus. Vestibulum et venenatis purus. Donec tincidunt pharetra ex quis tempor. Vivamus non sapien eget elit auctor ultrices at eget turpis. Nulla volutpat ut nibh eget placerat.
 communitiesLos Angeles
 websitehttps://compass.com
 address680 E. Colorado Blvd
 address_2Suite 150
 cityPasadena
 stateCA
 full_stateCalifornia
 countryUSA
 market
 market_2
 postal_code91101
 phone8888888888
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameF. Ron Smith
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleMain Dude
 contact_dre_num11624555
 contact_quote
 contact_emailfron@mailinator.com
 contact_facebookhttps://www.facebook..com
 contact_twitterhttps://www.twitter..com
 contact_instagramhttps://www.instagram..com
 contact_pinteresthttps://www.pinterest..com
 contact_linkedinhttps://www.linkedin..com
 contact_youtubehttps://www.youtube..com
 contact_phone888-888-8888
 contact_email_2chris@jloop.com
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2878-829-1672
 contact_website
 contact_name_2Chris Stephonovich
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2Associate Realtor
 contact_dre_num_241768321
 contact_email_3courtney@mailinator.com
 contact_name_3Courtney P. Wolpertinger
 contact_title_3Property Commander
 contact_dre_num_384919983
 contact_phone_3158-646-8246
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename
 logo_filename
 contact_image_filename
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_title
 meta_description
 meta_keywords
 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(false)
 created2019-10-25 22:04:28
 modified2022-06-24 11:37:26
 country_id0
 dre_num012345
 uri/team-detail/102/compass
 website_shortcompass.com
 name_with_locationCompass
 Image(array)
 id1738
 modelLocation
 model_id21
 tagImage
 namepasadena-city-hall-2-visit-pasadena.jpg
 typeimage/jpeg
 size765364
 uri/assets/1738.jpg
 order0
 created2019-10-29 17:53:57
 modified2019-10-29 17:54:58
- sidebar_articles(array)
 0(array)
 Article(array)
 id46
 modelArticle
 model_id0
 archived(false)
 medium_featured(false)
 large_featured(false)
 titleMeet East Oahu Realty
 authorLeverageRE
 date2014-06-18
 lead_inWatch this video and get to know East Oahu Realty, the exclusive representative for Leverage Global Partners in Oahu, Hawaii, USA.
 body <img class="aligncenter wp-image-5075 pure-img" src="/assets/885.jpg" alt="Video: Meet East Oahu Realty" width="574" height="318" sizes="(max-width: 574px) 100vw, 574px">
 vimeo_id
 created2016-03-23 11:27:20
 modified2016-05-18 16:18:16
 uri/articles/view/46/meet-east-oahu-realty
 Image(array)
 0(array)
 id886
 modelArticle
 model_id46
 tagImage
 nameEast-Oahu-3.jpg
 typeimage/jpg
 size1198836
 uri/assets/886.jpg
 order0
 created2016-03-23 11:27:20
 modified2016-03-23 11:27:20
 1(array)
 Article(array)
 id65
 modelArticle
 model_id0
 archived(false)
 medium_featured(false)
 large_featured(false)
 titleSaturday In The Neighborhood: Dallas
 authorLeverageRE
 date2016-03-24
 lead_inNOSH. Casa Rubia at Trinity Groves was awarded a James Beard nod as one of the country's best new restaurants; it's the go-to for modern tapas and paellas.
 body <img class="aligncenter size-full wp-image-12874 pure-img" src="/assets/988.png" alt="Screen Shot 2016-03-28 at 6.17.15 PM" width="1085" height="721" sizes="(max-width: 1085px) 100vw, 1085px"> NEST. In the Dallas Design District, <a href="http://www.ceylonetcie.com/" target="_blank">Ceylon et Cie</a> is a design trove filled with eclectic finds from around the world. WALK. While White Rock Lake is across the street from Mount Vernon's gates, many stroll seekers like the <a href="http://www.dallasparks.org/downloads/trails/katy.pdf" target="_blank">Katy Trail</a>, a jogging and bicycle path that follows the old Missouri-Kansas-Texas Railroad. <img class="aligncenter size-full wp-image-12873 pure-img" src="/assets/989.png" alt="Screen Shot 2016-03-28 at 6.16.48 PM" width="982" height="647" sizes="(max-width: 982px) 100vw, 982px"> DRESS. <a href="http://www.vodboutique.com/" target="_blank">V.O.D.</a> is what you get when a former fashion journalist and seasoned women's buyer open a boutique. Jackie Bolin and Liz Thompson bring hard-to-find lines and exquisite vintage pieces to Dallas's Victory Park location. VIEW. <a href="http://www.perotmuseum.org/" target="_blank">The Perot Museum of Nature and Science</a> opened to much fanfare last year. Designed by Pritzker Architecture Prize Laureate Thom Mayne, the 180,000-square-foot facility received the highest possible Green Globes rating for its sustainable design. <img class="aligncenter size-full wp-image-12872 pure-img" src="/assets/990.png" alt="Screen Shot 2016-03-28 at 6.15.06 PM" width="1230" height="815" sizes="(max-width: 1230px) 100vw, 1230px"> 
 vimeo_id
 created2016-04-05 14:22:29
 modified2016-05-18 16:18:17
 uri/articles/view/65/saturday-in-the-neighborhood-dallas
 Image(array)
 0(array)
 id991
 modelArticle
 model_id65
 tagImage
 nameDallas-4.jpg
 typeimage/jpg
 size673857
 uri/assets/991.jpg
 order0
 created2016-04-05 14:22:30
 modified2016-04-05 14:22:30
 2(array)
 Article(array)
 id30
 modelArticle
 model_id0
 archived(false)
 medium_featured(false)
 large_featured(false)
 titleSavor the End of Summer: Outdoor Grilling Spaces
 authorLeverageRE
 date2014-09-01
 lead_inThe end of summer is rapidly approaching. It's time to savor the last moments of the season. What better way to celebrate and soak up the remaining sunshine than by hosting one final outdoor soirée for your friends and family. Fire up a feast and send summer out in style, with these luxurious outdoor grilling […]
 body Fire up a feast and send summer out in style, with these luxurious outdoor grilling spaces from some of our Leverage Global Partners: <h1 style="text-align: center;"> Mediterranean Summit Estate Represented by Ascent Real Estate </h1> <img class="aligncenter wp-image-6264 size-full pure-img" src="/assets/748.jpg" alt="Outdoor Grilling Spaces: Ascent Real Estate" width="960" height="640" sizes="(max-width: 960px) 100vw, 960px"> Designed and built by the current owner, this Mediterranean-style home is located on a sprawling corner lot that offers privacy and panoramic mountain views and lots of exterior entertaining spaces. <h1 style="text-align: center;">Waterfront Home with Expansive Views Represented by Coleman Realtors</h1> <img class="aligncenter wp-image-6274 size-full pure-img" src="/assets/749.jpg" alt="Outdoor Grilling Spaces: Coleman Realtors" width="960" height="593" sizes="(max-width: 960px) 100vw, 960px"> Watch the boats sail by as you grill on the spacious wooden deck of this recently renovated Barringon, Rhode Island home, which features expansive water views and a deepwater dock. <h1 style="text-align: center;">Custom Private Home With Lakefront Access Represented by Harnish Properties</h1> <img class="aligncenter wp-image-6270 size-full pure-img" src="/assets/750.jpg" alt="Outdoor Grilling Spaces: Harnish Properties" width="960" height="640" sizes="(max-width: 960px) 100vw, 960px"> A custom contemporary on a private bluff in Lake Oswego, Oregon provides a covered outdoor entertaining space with multiple terraces complete with a grill, and an indoor/outdoor bar. <h1 style="text-align: center;">Unbelievable In Town Estate Represented by The Marchant Company</h1> <img class="aligncenter wp-image-6266 size-full pure-img" src="/assets/751.jpg" alt="Outdoor Grilling Spaces: The Marchant Company" width="960" height="557" sizes="(max-width: 960px) 100vw, 960px"> The oversized deck of this Greenville, South Carolina estate that has a permanent gas line for grilling year-round, and is nestled amongst mature trees and spectacular views to the Blue Ridge Mountains. <h1 style="text-align: center;">Silver Building Penthouse Represented by Vanguard Properties</h1> <img class="aligncenter wp-image-6267 size-full pure-img" src="/assets/752.jpg" alt="Outdoor Grilling Spaces: Vanguard Properties" width="960" height="641" sizes="(max-width: 960px) 100vw, 960px"> This stunning 3-story San Francisco penthouse offers modern urban living at its best, featuring a beautiful private rooftop deck with a grilling area and hot tub overlooking the city. <h1 style="text-align: center;"> Builder’s Executive Home Represented by Moorings Realty Inc. </h1> <img class="aligncenter wp-image-6265 size-full pure-img" src="/assets/753.jpg" alt="Outdoor Grilling Spaces: Moorings Realty" width="960" height="640" sizes="(max-width: 960px) 100vw, 960px"> This custom-built home in the Florida Keys offers a charming back patio and grilling space, plus access to the bay for boating and waterfront activities for the whole family. <h1 style="text-align: center;"> Wailea’s Finest Ocean Front Villa Represented by The Wailea Group </h1> <img class="aligncenter wp-image-6268 size-full pure-img" src="/assets/754.jpg" alt="Outdoor Grilling Spaces: The Wailea Group" width="960" height="640" sizes="(max-width: 960px) 100vw, 960px"> Enjoy the warm Maui sun and watch the waves crash as you grill outside this elegant and spacious villa, located just a few steps away from the white sand of Wailea Beach. <h1 style="text-align: center;">Mermaid Boathouse: Charming Water View Cottage Represented by Point B Realty, LLC</h1> <img class="aligncenter wp-image-6273 size-full pure-img" src="/assets/755.jpg" alt="Outdoor Grilling Spaces: Point B Realty" width="960" height="540" sizes="(max-width: 960px) 100vw, 960px"> This Martha’s Vineyard cottage has an expansive mahogany deck with a retractable awning, the perfect place to enjoy an afternoon barbecue with lakefront views. Do you dream of a luxurious outdoor space to soak up the last days of summer? Share your thoughts and leave your comments below.
 vimeo_id
 created2016-03-23 11:20:14
 modified2016-05-18 16:18:16
 uri/articles/view/30/savor-the-end-of-summer-outdoor-grilling-spaces
 Image(array)
 0(array)
 id756
 modelArticle
 model_id30
 tagImage
 nameGrills-Wordpress.jpg
 typeimage/jpg
 size477536
 uri/assets/756.jpg
 order0
 created2016-03-23 11:20:16
 modified2016-03-23 11:20:16
 3(array)
 Article(array)
 id24
 modelArticle
 model_id0
 archived(false)
 medium_featured(true)
 large_featured(true)
 titlePark Hyatt Mallorca: Coming to Mallorca in 2015
 authorLeverageRE
 date2013-04-19
 lead_inHyatt Hotels is no stranger to pristine natural environments and resort worthy destinations. So, it should come as no surprise to hear that a Hyatt-brand hotel is scheduled to open on the island of Mallorca, Spain in the year 2015. Mallorca, Spain is home to some of the most beautiful sites, historic natural landscapes, crystal […]
 bodyMallorca, Spain is home to some of the most beautiful sites, historic natural landscapes, crystal blue waters, and breathtaking Mediterranean sunsets you have ever seen, and Hyatt Hotels wants to share that with the world. To be the first branded hotel on the island, the Park Hyatt Mallorca will be designed and built in the traditional Mallorcan hilltop village style. With all of today's current Hyatt amenities and luxury resort offerings, <a href="http://www.hotelnewsresource.com/article69867New_Park_Hyatt_Hotel_Announced_for_Mallorca__Spain.html" target="_blank" title="Park Hyatt Hotel | Mallorca Spain">the Park Hyatt hotel will boast state-of-the-art technologies along with Hyatt's unprecedented hospitality services:</a> "The hotel will overlook the Canyamel valley with views of the sea and the ancient town of Artá. Adjacent to an international standard 18-hole golf course, Park Hyatt Mallorca will also be within walking distance to the historic Coves d'Artá. The hotel is located at the centre of a 61-acre master development, which is owned and being developed by Grupo Cap Vermell, that will include residential properties and a number of high-end luxury villas." <img class="pure-img" src="/assets/377.jpg" />The 142-room, luxury resort hotel will be the first of its kind on the island, and aims to increase the already popular tourist flow on the island. Spain is one of the most popular tourist destinations in the world, and <a href="http://www.park.hyatt.com/en/parkhyatt.html" target="_blank" title="Park Hyatt">Hyatt hotels hope to gain brand recognition throughout the process and highlight some of Mallorca's most stunning attributes.</a> What do you think about this Park Hyatt Mallorca development? Will a branded hotel of this stature tarnish the pristine allure of an island like Mallorca? Would you be more likely to stay at a larger chain hotel than a smaller inn on an island like this? Feel free to drop us a line in the comments below.
 vimeo_id
 created2016-02-25 13:50:50
 modified2021-07-21 11:42:34
 uri/articles/view/24/park-hyatt-mallorca-coming-to-mallorca-in-2015
 Image(array)
 0(array)
 id378
 modelArticle
 model_id24
 tagImage
 namemallorca-beach.jpg
 typeimage/jpg
 size252248
 uri/assets/378.jpg
 order0
 created2016-02-25 13:50:50
 modified2021-07-21 11:42:34
- main_article(empty)
- locations(empty)
- 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)
 brokerageAsia Pacific Properties, Shenzhen
- brokerage(array)
 Brokerage(array)
 id30
 account_executive_id0
 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_properties3
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 WOEID2161853
 timezoneAsia/Hong_Kong
 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_auto_import_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameAsia Pacific Properties
 broker_of_record_name
 short_nameAsia Pacific Properties
 username
 password
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(false)
 lead_in
 short_description
 descriptionWe're excited to announce that Asia Pacific Properties is the exclusive representative for Leverage Global Partners in Shenzhen, China. More information is coming soon.
 communitiesShenzhen China
 websitehttp://www.asiapacificproperties.com/
 addressComing Soon
 address_2
 cityShenzhen
 state
 full_state
 country
 market
 market_2
 postal_code
 phoneComing Soon
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameBeverly L.W. Sunn
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_emailsunn@asiapacificproperties.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_filename30.jpg
 logo_filename30.gif
 contact_image_filename30.jpg
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_titleShenzhen Real Estate | Asia Pacific Properties | Leverage Global Partners
 meta_descriptionAsia Pacific Properties is the exclusive representative for Leverage Global Partners in Shenzhen, China.
 meta_keywordsshenzhen real estate, asia pacific properties, leverage global partners, beverly sunn
 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-05-24 18:28:22
 modified2016-02-26 15:37:56
 country_id2
 dre_num012345
 uri/brokerage-detail/30/asia-pacific-properties
 website_shortwww.asiapacificproperties.com
 name_with_locationAsia Pacific Properties
 Logo(array)
 id482
 modelBrokerage
 model_id30
 tagLogo
 name30.gif
 typeimage/gif
 size
 uri
 order0
 created2016-02-26 15:03:22
 modified2016-02-26 15:03:22
 MainImage(array)
 id481
 modelBrokerage
 model_id30
 tagMainImage
 name30.jpg
 typeimage/jpg
 size
 uri
 order0
 created2016-02-26 15:03:22
 modified2016-02-26 15:03:22
 ContactImage(array)
 id483
 modelBrokerage
 model_id30
 tagContactImage
 name30.jpg
 typeimage/jpg
 size
 uri
 order0
 created2016-02-26 15:03:22
 modified2016-02-26 15:03:22
 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/dev2/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	dev2
WEB_BASE_URL	https://dev2.leveragere.com
PROP_EMAIL_RECIPIENT	chris@jloop.com
STRIPE_ISSUES_EMAIL_RECIPIENT	chris@jloop.com
MEMBER_HELP_EMAIL_RECIPIENT	chris@jloop.com
FEED_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/dev2/httpdocs/app/Console/cake.php

CakePHP Constants

Constant	Value
APP	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/
APP_DIR	app
APPLIBS	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/Lib/
CACHE	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/tmp/cache/
CAKE	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/lib
CORE_PATH	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/lib/
CAKE_VERSION	2.10.19
CSS	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://dev2.leveragere.com
IMAGES	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/webroot/img/
IMAGES_URL	img/
JS	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/webroot/js/
JS_URL	js/
LOGS	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/tmp/logs/
ROOT	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs
TESTS	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/Test/
TMP	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/tmp/
VENDORS	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/vhosts/leveragere.com/subdomains/dev2/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/30/asia-pacific-properties
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/brokerage-detail/30/asia-pacific-properties
Remote Port	17525
Script Filename	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/webroot
Remote Addr	104.23.243.125
Server Port	443
Server Addr	172.24.32.44
Server Name	dev2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	dev2.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.217.63
Http Cdn Loop	cloudflare; loops=1
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept Encoding	gzip, br
Http Accept	/
Http Cf Ray	a07303d20ee74628-CMH
Http X Forwarded For	216.73.217.63
Proxy-nokeepalive	1
Ssl Tls Sni	dev2.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	aiNeHBTeGjqEoMUiCFtE8QAAAZU
Redirect Status	200
Redirect Ssl Tls Sni	dev2.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	aiNeHBTeGjqEoMUiCFtE8QAAAZU
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1780702748.5126
Request Time	1780702748

====

Include
+
Included Files

Include Paths
- 0/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/lib
- 2/opt/plesk/php/7.4/share/pear
- 3-> /var/www/vhosts/leveragere.com/subdomains/dev2/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
====

Asia Pacific Properties

Connect With Us

Asia Pacific Properties Featured Properties

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 6 ms Total Queries: 10 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 6 ms
Total Queries: 10 queries