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 = '102'
$brokerage = array(
	'Brokerage' => array(
		'password' => '*****',
		'id' => '102',
		'account_executive_id' => '0',
		'archived' => false,
		'type' => 'team',
		'hide_from_frontend' => false,
		'agent_brokerage_data_override' => false,
		'featured_development' => false,
		'membership_type' => 'Basic',
		'max_properties' => '12',
		'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,
		'WOEID' => null,
		'timezone' => '',
		'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' => 'Compass',
		'broker_of_record_name' => 'Partners Trust',
		'short_name' => 'Compass',
		'username' => '',
		'password_reset_hash' => '',
		'monthly_invoice_amount' => '0.00',
		'monthly_invoice_start_date' => null,
		'monthly_invoice_end_date' => null,
		'contract_filename' => '',
		'active' => true,
		'lead_in' => 'You've tried the rest, now try the best',
		'short_description' => '',
		'description' => '<p>Lorem 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.</p>

<p>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.</p>
',
		'communities' => 'Los Angeles',
		'website' => 'https://compass.com',
		'address' => '680 E. Colorado Blvd',
		'address_2' => 'Suite 150',
		'city' => 'Pasadena',
		'state' => 'CA',
		'full_state' => 'California',
		'country' => 'USA',
		'market' => '',
		'market_2' => '',
		'postal_code' => '91101',
		'phone' => '8888888888',
		'phone_2' => '',
		'phone_3' => '',
		'wide_contact_image' => false,
		'contact_name' => 'F. Ron Smith',
		'contact_profile_link' => '',
		'contact_big_profile_link' => '',
		'contact_big_profile_link_text' => '',
		'contact_title' => 'Main Dude',
		'contact_dre_num' => '11624555',
		'contact_quote' => '',
		'contact_email' => 'fron@mailinator.com',
		'contact_facebook' => 'https://www.facebook..com',
		'contact_twitter' => 'https://www.twitter..com',
		'contact_instagram' => 'https://www.instagram..com',
		'contact_pinterest' => 'https://www.pinterest..com',
		'contact_linkedin' => 'https://www.linkedin..com',
		'contact_youtube' => 'https://www.youtube..com',
		'contact_phone' => '888-888-8888',
		'contact_email_2' => 'chris@jloop.com',
		'contact_2_facebook' => '',
		'contact_2_twitter' => '',
		'contact_2_instagram' => '',
		'contact_2_pinterest' => '',
		'contact_2_linkedin' => '',
		'contact_2_youtube' => '',
		'contact_phone_2' => '878-829-1672',
		'contact_website' => '',
		'contact_name_2' => 'Chris Stephonovich',
		'contact_profile_link_2' => '',
		'contact_big_profile_link_2' => '',
		'contact_big_profile_link_text_2' => '',
		'contact_title_2' => 'Associate Realtor',
		'contact_dre_num_2' => '41768321',
		'contact_email_3' => 'courtney@mailinator.com',
		'contact_name_3' => 'Courtney P. Wolpertinger',
		'contact_title_3' => 'Property Commander',
		'contact_dre_num_3' => '84919983',
		'contact_phone_3' => '158-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_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' => false,
		'created' => '2019-10-25 22:04:28',
		'modified' => '2022-06-24 11:37:26',
		'country_id' => '0',
		'dre_num' => '012345',
		'uri' => '/team-detail/102/compass',
		'website_short' => 'compass.com',
		'name_with_location' => 'Compass'
	),
	'Logo' => array(
		'id' => '2692',
		'model' => 'Brokerage',
		'model_id' => '102',
		'tag' => 'Logo',
		'name' => 'logo-compass.png',
		'type' => 'image/png',
		'size' => '3193',
		'uri' => '/assets/2692.png',
		'order' => '0',
		'created' => '2022-06-24 11:37:24',
		'modified' => '2022-06-24 11:37:26'
	),
	'MainImage' => array(
		'id' => '1737',
		'model' => 'Brokerage',
		'model_id' => '102',
		'tag' => 'MainImage',
		'name' => 'table_pic_fixed.jpg',
		'type' => 'image/jpeg',
		'size' => '520970',
		'uri' => '/assets/1737.jpg',
		'order' => '0',
		'created' => '2019-10-25 22:04:25',
		'modified' => '2022-06-24 11:37:26'
	),
	'ContactImage' => array(
		'id' => '1735',
		'model' => 'Brokerage',
		'model_id' => '102',
		'tag' => 'ContactImage',
		'name' => 'fron_square.jpg',
		'type' => 'image/jpeg',
		'size' => '32619',
		'uri' => '/assets/1735.jpg',
		'order' => '0',
		'created' => '2019-10-25 21:59:53',
		'modified' => '2022-06-24 11:37:26'
	),
	'ContactImage2' => array(
		'id' => '1762',
		'model' => 'Brokerage',
		'model_id' => '102',
		'tag' => 'ContactImage2',
		'name' => 'profile_square.jpg',
		'type' => 'image/jpeg',
		'size' => '363580',
		'uri' => '/assets/1762.jpg',
		'order' => '0',
		'created' => '2019-10-30 21:52:27',
		'modified' => '2022-06-24 11:37:26'
	),
	'ContactImage3' => array(
		'id' => '1763',
		'model' => 'Brokerage',
		'model_id' => '102',
		'tag' => 'ContactImage3',
		'name' => 'charmeling.jpg',
		'type' => 'image/jpeg',
		'size' => '32603',
		'uri' => '/assets/1763.jpg',
		'order' => '0',
		'created' => '2019-10-30 21:56:57',
		'modified' => '2022-06-24 11:37:26'
	),
	'BrokerOfRecordLogo' => array(
		'id' => '1761',
		'model' => 'Brokerage',
		'model_id' => '102',
		'tag' => 'BrokerOfRecordLogo',
		'name' => 'pt_trans.png',
		'type' => 'image/png',
		'size' => '26293',
		'uri' => '/assets/1761.png',
		'order' => '0',
		'created' => '2019-10-30 18:08:40',
		'modified' => '2022-06-24 11:37:26'
	),
	'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 Team | Compass

Properties / Compass

Compass

Main Dude: F. Ron Smith
8888888888
888-888-8888

Associate Realtor: Chris Stephonovich
878-829-1672

License #: 012345

Visit Website

The city is known for hosting the annual Rose Bowl football game and Tournament of Roses Parade

You've tried the rest, now try the best

Lorem 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.

Connect With Us

compass.com

Read Our Profile

All About Compass

Todd Pastell

Lorem ipsum

Topics:
Arts & Culture

Partner:
Compass

Compass Featured Properties

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

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

Cake Params
- plugin(null)
- controllerbrokerages
- actionview
- named(empty)
- pass(array)
  0102
  1compass
- 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/team-detail/*
====

Sql Log

Sql Logs

default

Total Time: 6 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`.`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` = 102 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` = (102) 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` = 102 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`.`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` = 102 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_dev2`.`assets` AS `Image` WHERE `Image`.`model` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` = (80) 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`.`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`, `ArticlesBrokerage`.`id`, `ArticlesBrokerage`.`article_id`, `ArticlesBrokerage`.`brokerage_id` FROM `leveragere_dev2`.`brokerages` AS `Brokerage` JOIN `leveragere_dev2`.`articles_brokerages` AS `ArticlesBrokerage` ON (`ArticlesBrokerage`.`article_id` = 80 AND `ArticlesBrokerage`.`brokerage_id` = `Brokerage`.`id`)	1	1	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`, `ArticlesLocation`.`id`, `ArticlesLocation`.`article_id`, `ArticlesLocation`.`location_id` FROM `leveragere_dev2`.`locations` AS `Location` JOIN `leveragere_dev2`.`articles_locations` AS `ArticlesLocation` ON (`ArticlesLocation`.`article_id` = 80 AND `ArticlesLocation`.`location_id` = `Location`.`id`)	1	1	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_dev2`.`properties` AS `Property` JOIN `leveragere_dev2`.`articles_properties` AS `ArticlesProperty` ON (`ArticlesProperty`.`article_id` = 80 AND `ArticlesProperty`.`property_id` = `Property`.`id`)	1	1	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `ArticlesTopic`.`id`, `ArticlesTopic`.`article_id`, `ArticlesTopic`.`topic_id` FROM `leveragere_dev2`.`topics` AS `Topic` JOIN `leveragere_dev2`.`articles_topics` AS `ArticlesTopic` ON (`ArticlesTopic`.`article_id` = 80 AND `ArticlesTopic`.`topic_id` = `Topic`.`id`)	1	1	0
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 (33, 27, 69, 40) ORDER BY `Image`.`order` ASC	6	6	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 11.09 MB

Message	Memory use
Component initialization	2.93 MB
Controller action start	3.84 MB
Controller render start	6.22 MB
View render complete	6.72 MB

Timers

Total Request Time: 178 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	24.95
Event: Controller.initialize	3.76
Event: Controller.startup	1.03
Controller action	30.00
Event: Controller.beforeRender	8.03
» Processing toolbar data	7.94
Rendering View	85.73
» Event: View.beforeRender	0.28
» Rendering APP/View/Brokerages/view_team.ctp	2.43
» » Rendering APP/View/Elements/article_list.ctp	0.18
» » 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	82.31
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)
 id33
 modelArticle
 model_id0
 archived(false)
 medium_featured(false)
 large_featured(false)
 titleLuxurious Desert Spas and Resorts
 authorLeverageRE
 date2014-08-22
 lead_inThe desert: a magical place full of serenity and wonder; the perfect destination for a relaxing weekend escape. But with the summer heat soaring, a desert vacation might not be on the top of your getaway list. Never fear! There are tons of fabulous desert spas that offer luxurious retreats to help you beat the […]
 body Have a look at five of our fave desert spas and imagine your next weekend here. <h2 style="text-align: center;"><a title="Miramonte" href="http://www.miramonteresort.com/palm-desert-spas.php" target="_blank">Miramonte Resort & Spa</a></h2> <img class="alignnone wp-image-5968 pure-img" src="/assets/772.jpg" alt="Desert Spas: Miramonte Resort & Spa" width="368" height="257" sizes="(max-width: 368px) 100vw, 368px"><img class="alignnone wp-image-5969 pure-img" src="/assets/773.jpg" alt="Desert Spas: Miramonte Resort & Spa" width="369" height="259" sizes="(max-width: 369px) 100vw, 369px"> Miramonte Resort & Spa is a premier California luxury spa destination, providing the ultimate in relaxation and rejuvenation. Located at a natural desert well in Palm Desert discovered hundreds of years ago, here you will enjoy <a title="Treatments" href="https://spadirect2.ryatta.com/en/eh/mm/well/spa-services?__utma=219161286.551702121.1406758458.1406758458.1406758458.1&__utmb=219161286.17.9.1406758973286&__utmc=219161286&__utmx=-&__utmz=219161286.1406758458.1.1.utmcsr=google%7Cutmccn=(organic)%7Cutmcmd=organic%7Cutmctr=(not%20provided)&__utmv=219161286.%7C4=device=pc=1&__utmk=55106024" target="_blank">unique indoor and outdoor treatments</a> including therapeutic muds and refreshing waters. <h2 style="text-align: center;"><a title="Ojai" href="http://www.ojairesort.com/spa-ojai/" target="_blank">Ojai Valley Inn & Spa</a></h2> <img class="alignnone wp-image-5978 pure-img" src="/assets/774.jpg" alt="Desert Spas: Ojai Valley Inn & Spa" width="369" height="215" sizes="(max-width: 369px) 100vw, 369px"><img class="alignnone wp-image-5979 pure-img" src="/assets/775.jpg" alt="Desert Spas: Ojai Valley Inn & Spa" width="371" height="216" sizes="(max-width: 371px) 100vw, 371px"> The award winning spa at the Ojai Valley Inn, overlooking the Topa Topa Mountains in Ojai, is a desert oasis with Moroccan-inspired ambience, featuring transcendent treatments such as the Ojai Rosemary Sage Salt Body Scrub, Lavender Sugar Body Polish and the Organic Sea Mineral Body Wrap. <h2 style="text-align: center;"><a title="Red Mountain Spa" href="http://redmountainresort.com/sagestone-spa-salon" target="_blank">Red Mountain Resort & Spa</a></h2> <img class="alignnone wp-image-6033 pure-img" src="/assets/776.png" alt="Desert Spas: Red Mountain Resort & Spa" width="362" height="215" sizes="(max-width: 362px) 100vw, 362px"> <img class="alignnone wp-image-6038 pure-img" src="/assets/777.png" alt="Desert Spas: Red Mountain Resort & Spa" width="368" height="214" sizes="(max-width: 368px) 100vw, 368px"> Idyllically located in the foothills of the stunning Red Rock Mountains in St. George, the Sagestone Spa at the Red Mountain Resort offers a serene sanctuary with treatments that feature Utah honey and mineral rich muds. Services include the Desert Renewal Body Polishers and the Warm Lava Detox Wrap. <h2 style="text-align: center;"><a title="Loretto" href="http://www.innatloretto.com/new-mexico-spas/santa-fe-day-spa.php" target="_blank">Loretto Inn & Spa</a></h2> <img class="alignnone wp-image-6018 pure-img" src="/assets/778.jpg" alt="Desert Spas: Loretto Inn & Spa" width="246" height="267"><img class="alignnone wp-image-6019 pure-img" src="/assets/779.jpg" alt="Desert Spas: Loretto Inn & Spa" width="492" height="266" sizes="(max-width: 492px) 100vw, 492px"> The award-winning spa at the Inn at Loretto represents the cultures and traditions of majestic Santa Fe, taking a holistic approach to the art of healing with unique treatments utilizing their own custom-crafted oil blends. Services include The Signature Salt Glow, the Milk & Honey Body Wrap, and the Sacred Journey stone massage. <h2 style="text-align: center;"><a title="La Quinta" href="http://www.laquintaresort.com/spa-fitness/" target="_blank">La Quinta Resort & Spa</a></h2> <img class="alignnone wp-image-6027 pure-img" src="/assets/780.jpg" alt="Desert Spas: La Quinta Resort & Spa" width="368" height="245" sizes="(max-width: 368px) 100vw, 368px"> <img class="alignnone wp-image-6028 pure-img" src="/assets/781.jpg" alt="Desert Spas: La Quinta Resort & Spa" width="368" height="245" sizes="(max-width: 368px) 100vw, 368px"> Enjoy the splendor of the magnificent spa and gardens at La Quinta Resort in gorgeous La Quinta. Revel in the wonder and beauty of your surroundings in your own private garden tub and indulge in the unique luxe treatments like the Desert Detox, Signature Citrus Smash, and Rosemary and Peppermint Awakening. What are your favorite desert spa services? Please share your thoughts below. <h6 style="text-align: right;">Photos courtesy of <a title="Miramonte" href="http://www.miramonteresort.com/palm-desert-spas.php" target="_blank">Miramonte Resort & Spa</a>, <a title="Ojai" href="http://www.ojairesort.com/spa-ojai/" target="_blank">Ojai Valley Inn & Spa</a>, <a title="Red Mountain Spa" href="http://redmountainresort.com/sagestone-spa-salon" target="_blank">Red Mountain Resort & Spa</a>, <a title="Loretto" href="http://www.innatloretto.com/new-mexico-spas/santa-fe-day-spa.php" target="_blank">Loretto Inn & Spa</a>, and <a title="La Quinta" href="http://www.laquintaresort.com/spa-fitness/" target="_blank">La Quinta Resort & Spa</a></h6>
 vimeo_id
 created2016-03-23 11:20:18
 modified2016-05-18 16:18:16
 uri/articles/view/33/luxurious-desert-spas-and-resorts
 Image(array)
 0(array)
 id782
 modelArticle
 model_id33
 tagImage
 namespa-homepage-4.jpg
 typeimage/jpg
 size269650
 uri/assets/782.jpg
 order0
 created2016-03-23 11:20:19
 modified2016-03-23 11:20:19
 1(array)
 Article(array)
 id27
 modelBrokerage
 model_id95
 archived(false)
 medium_featured(false)
 large_featured(false)
 titletest brokerage article
 authorme
 date2016-02-26
 lead_intest
 bodyLorem ipsum
 vimeo_id
 created2016-02-26 10:54:38
 modified2021-07-21 11:27:59
 uri/articles/view/27/test-brokerage-article
 Image(array)
 0(array)
 id728
 modelArticle
 model_id27
 tagImage
 namepexels-photo-52599.jpeg
 typeimage/jpeg
 size120826
 uri/assets/728.jpeg
 order0
 created2016-03-03 15:32:40
 modified2021-07-21 11:27:59
 1(array)
 id727
 modelArticle
 model_id27
 tagImage
 nameIMG_2137.jpg
 typeimage/jpeg
 size2396372
 uri/assets/727.jpg
 order1
 created2016-03-03 15:32:38
 modified2021-07-21 11:27:59
 2(array)
 id729
 modelArticle
 model_id27
 tagImage
 nameIMG_2136.jpg
 typeimage/jpeg
 size1768640
 uri/assets/729.jpg
 order2
 created2016-03-03 15:32:49
 modified2021-07-21 11:27:59
 2(array)
 Article(array)
 id69
 modelArticle
 model_id0
 archived(false)
 medium_featured(false)
 large_featured(false)
 titleVentana Fine Properties: Art de Vivre February 2016
 authorLeverageRE
 date2016-02-16
 lead_inWelcome to Art to Vivre, Ventana Fine Properties‘ luxury properties and lifestyles publication. This edition of Art de Vivre features their DC Ranch community as well as nearby neighborhoods. EXPLORE THE LATEST ISSUE: ART DE VIVRE FEBRUARY 2016
 body Welcome to Art to Vivre, Ventana Fine Properties‘ luxury properties and lifestyles publication. This edition of Art de Vivre features their DC Ranch community as well as nearby neighborhoods. <h3 style="text-align: center;"><a href="https://issuu.com/ventanafineproperties/docs/artdevivre-magazine-february-2016" target="_blank">EXPLORE THE LATEST ISSUE: ART DE VIVRE FEBRUARY 2016</a></h3> <a href="https://issuu.com/ventanafineproperties/docs/artdevivre-magazine-february-2016" target="_blank"><img class="aligncenter wp-image-11936 pure-img" src="/assets/1097.png" alt="Ventana Fine Properties: Art de Vivre February 2016" width="797" height="516" sizes="(max-width: 797px) 100vw, 797px"></a> <a href="https://issuu.com/ventanafineproperties/docs/artdevivre-magazine-february-2016" target="_blank"><img class="aligncenter wp-image-11937 pure-img" src="/assets/1098.png" alt="Ventana Fine Properties: Art de Vivre February 2016" width="472" height="614" sizes="(max-width: 472px) 100vw, 472px"></a>
 vimeo_id
 created2016-05-18 15:57:56
 modified2016-05-18 16:22:59
 uri/articles/view/69/ventana-fine-properties-art-de-vivre-february-2016
 Image(array)
 0(array)
 id1099
 modelArticle
 model_id69
 tagImage
 nameScreen-Shot-2016-02-16-at-4.49.02-PM.png
 typeimage/png
 size24441
 uri/assets/1099.png
 order0
 created2016-05-18 15:57:58
 modified2016-05-18 15:57:58
 3(array)
 Article(array)
 id40
 modelArticle
 model_id0
 archived(false)
 medium_featured(false)
 large_featured(false)
 titleFantastic 4th of July Celebrations Across the United States
 authorLeverageRE
 date2014-07-04
 lead_inThe 4th of July, America’s quintessential summer holiday, provides a plethora of festivities, including fireworks, food, family, and friends, all gathered together to celebrate our Independence Day.
 body Today, we have rounded up some of the best events in the United States, featuring several of our Leverage Global Partners cities: <h1 style="text-align: center;"> Orlando, Florida Home of Fusilier Realty Group </h1> <img class="aligncenter wp-image-5462 pure-img" src="/assets/837.jpg" alt="4th of July Orlando" width="640" height="435" sizes="(max-width: 640px) 100vw, 640px"> Watching <a href="https://disneyworld.disney.go.com/entertainment/magic-kingdom/4th-of-july-fireworks-magic-kingdom/" target="_blank">Disney’s Celebrate America!</a> at the Magic Kingdom represents the ultimate 4th of July experience for people of all ages, complete with marching bands, Disney characters in colonial attire, and fireworks above the iconic Cinderella Castle. <h1 style="text-align: center;"> Jackson Hole, Wyoming Home of Jackson Hole Real Estate Associates </h1> <img class="aligncenter wp-image-5485 pure-img" src="/assets/838.jpg" alt="4th of July Jackson Hole" width="634" height="476" sizes="(max-width: 634px) 100vw, 634px">Few experiences across the country can match <a href="http://www.jacksonholechamber.com/events/4th-of-july.php">Independence Day in Jackson Hole</a>. The Old West town enjoys a day of concerts and celebrations in the valley, and then looks to the surrounding mountains at night for an astounding view of spectacular fireworks. <h1 style="text-align: center;"> Denver, Colorado Home of Madison & Company Properties </h1> <img class="aligncenter wp-image-5486 size-full pure-img" src="/assets/839.jpg" alt="4th of July Denver" width="630" height="420" sizes="(max-width: 630px) 100vw, 630px">Denver’s <a href="http://www.denver.org/things-to-do/denver-holiday-events/denver-4th-july/">multitude of festivities</a> includes the Cherry Creek Arts Festival, concerts at the renowned Red Rocks Amphitheatre, fireworks at Elitch Gardens, and a unique Colorado Symphony performance titled ‘Independence Day Strikes Back’, featuring the music of Star Wars and other patriotic tunes. <h1 style="text-align: center;"> Washington D.C. Home of Evers & Co. Real Estate </h1> <img class="aligncenter wp-image-5491 size-full pure-img" src="/assets/840.jpg" alt="4th of July Washington DC" width="640" height="427" sizes="(max-width: 640px) 100vw, 640px"> Every July 4th, patriotic Americans flock to the nation’s capital. With rousing musical works and a background of some of the most distinguished monuments in America, the <a href="http://www.nps.gov/foju/index.htm">National Mall Independence Day Celebration</a> is sure to make any American citizen proud! <h1 style="text-align: center;"> Boston, Massachusetts Home of Sprogis & Neale Real Estate </h1> <img class="aligncenter wp-image-5484 pure-img" src="/assets/841.png" alt="4th of July Boston" width="698" height="413" sizes="(max-width: 698px) 100vw, 698px"> As a city proud of its revolutionary heritage, Boston’s largest and most celebrated tradition is <a href="http://www.july4th.org/">The Boston Pops Fireworks Spectacular</a>, an event that has thrilled spectators on the Charles River Esplanade every 4th of July for four decades. <h1 style="text-align: center;"> Newport Beach, California Home of The Boutique Real Estate Group </h1> <img class="aligncenter wp-image-5475 size-full pure-img" src="/assets/842.jpg" alt="4th of July Newport Beach" width="640" height="425" sizes="(max-width: 640px) 100vw, 640px"> Aiming to please people of all ages, <a href="http://www.visitnewportbeach.com/4th-of-july/">Independence Day on the Back Bay</a> offers fun for the whole family. Whether you’re eating delicious cuisine, listening to live music, or are simply there to see the fireworks display, Newport Beach will awe you with its coastal celebration. <h1 style="text-align: center;"> Mobile, Alabama Home of Ashurst & Niemeyer Real Estate </h1> <img class="aligncenter wp-image-5487 pure-img" src="/assets/843.jpg" alt="4th of July Mobile Alabama" width="717" height="477" sizes="(max-width: 717px) 100vw, 717px">Many residents of Mobile, Alabama rally to memorialize men and women in the military every July 4th. The battleship <a href="http://www.ussalabama.com/">U.S.S. Alabama</a> opens in the morning for everyone to get a taste of American history, with fireworks topping off the evening. How do you celebrate Independence Day? Share your 4th of July plans and traditions with us by leaving a comment below. <h6 style="text-align: left;"> Photos courtesy of <a href="https://disneyworld.disney.go.com/entertainment/magic-kingdom/4th-of-july-fireworks-magic-kingdom/" target="_blank">DisneyWorld.com</a>, <a href="http://www.jacksonholechamber.com/" target="_blank">Jackson Hole Chamber of Commerce</a>, <a href="http://thedistrictinsider.com/guide-where-to-watch-4th-of-july-firework-displays/" target="_blank">The District Insider</a>, <a href="http://www.denver.org/things-to-do/denver-holiday-events/denver-4th-july/" target="_blank">Denver.org</a>, <a href="https://www.facebook.com/pages/Boston-Pops-Fireworks-Spectacular/141252900157?ref=ts" target="_blank">Boston Pops Fireworks Spectacular</a>, <a href="http://www.al.com/#/0" target="_blank">AL.com</a> </h6> 
 vimeo_id
 created2016-03-23 11:27:15
 modified2016-05-18 16:18:16
 uri/articles/view/40/fantastic-4th-of-july-celebrations-across-the-united-states
 Image(array)
 0(array)
 id844
 modelArticle
 model_id40
 tagImage
 nameetravelblog.jpg
 typeimage/jpg
 size220497
 uri/assets/844.jpg
 order0
 created2016-03-23 11:27:15
 modified2016-03-23 11:27:15
- main_article(array)
 Article(array)
 id80
 modelBrokerage
 model_id102
 archived(false)
 medium_featured(true)
 large_featured(false)
 titleAll About Compass
 authorTodd Pastell
 date2019-10-30
 lead_inLorem ipsum
 bodyLorem 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.
 vimeo_id
 created2019-10-30 22:36:10
 modified2021-07-21 11:42:08
 uri/articles/view/80/all-about-compass
 flattened_topics(array)
 0Arts & Culture
 ParentBrokerage(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
 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)
 short_description(null)
 long_description(null)
 created(null)
 modified(null)
 timezone(null)
 population(null)
 Image(array)
 0(array)
 id1764
 modelArticle
 model_id80
 tagImage
 nameIMG_4617.jpg
 typeimage/jpeg
 size3435286
 uri/assets/1764.jpg
 order0
 created2019-10-30 22:35:50
 modified2021-07-21 11:42:08
 Brokerage(array)
 0(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
 ArticlesBrokerage(array)
 id11
 article_id80
 brokerage_id102
 Location(array)
 0(array)
 id5
 parent_id8
 brokerage_id21
 typeExclusive
 archived(false)
 use_as_topic(true)
 nameAgoura Hills
 short_nameAH Town
 group_index
 latitude34.153339
 longitude-118.761673
 country_code
 north0.000000
 south0.000000
 east0.000000
 west0.000000
 short_descriptionLorem ipsum dolor sit amet
 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-02-11 14:47:13
 modified2016-04-18 11:36:41
 timezoneAmerica/Los_Angeles
 population5400000
 uri/locations/view/5/agoura-hills
 tile_nameAgoura Hills
 ArticlesLocation(array)
 id9
 article_id80
 location_id5
 Property(array)
 0(array)
 id136
 brokerage_id103
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 name30 Moffat Street
 incomplete(false)
 archived(true)
 last_archived2021-03-17 14:00:58
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(false)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(true)
 luxury_feed_last_added_time2020-03-17 11:27:53
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(false)
 descriptionSpectacular French provincial home set in manicured formal gardens with swimming pool promises an outstanding family lifestyle in this blue-chip Bayside location in the popular Were Street precinct. Antique French timber and cast-iron double doors open to reveal interiors defined by sweeping polished ironbark floors, reconstituted granite, soaring ceilings, decorative cornices, and glorious garden or water outlooks from every angle. Vistas over the pond and swimming pool are enhanced by two rare century-old Canary Island palms. The homeâs formal and informal living and dining domain are complimented by a ground floor suite with walk-in-wardrobe and granite finished en suite. At the end of the wide hallway the full-width informal living and dining zone opens through three pairs of French doors to a large outdoor terrace overlooking the garden and swimming pool. The chefâs kitchen includes three Miele ovens and dishwasher, appliance cabinet and long stone benches overlooking the dining and living which boasts built-in bespoke joinery and glorious garden and pool views. Still downstairs, a very generous powder room and large laundry confirm the luxury of space and thoughtful design of this enviable family home. A grand carpeted timber and wrought iron staircase leads to a very spacious upper level that includes a large living room or teenagers retreat. Enjoying views through the treetops of the front garden and pond, the main suite includes a vestibule, private study or home office, walk-in wardrobe and generous ensuite with shower, bath set in granite and double vanity. Three more bedrooms include two that open to private balconies with garden views, while a granite-finished family bathroom and second ensuite complete the upstairs domain. A grand contemporary classic, this residence also includes solar glazed windows, ducted heating, reverse cycle air conditioning, smart wiring, powder room, attic storage, salt-chlorinated 9 metre solar heated swimming pool, and five car basement garage with workshop. Brilliantly positioned close to a range of schools including Xavier College, Haileybury, St Leonards, as well as Were Street shopping and the beach.
 address30 Moffat Street
 address_2
 cityMelbourne
 stateVIC
 postal_code3186
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price4800000
 price_20
 price_usd4800000
 price_usd_20
 statusPending
 status_last_changed2020-07-23 11:49:35
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms5
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_typeSingle Family
 juwai_categoryresidential
 propgolux_property_style21
 wapo_property_typeSingleFamily Home
 robb_property_typeSingle Family Home
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude-37.923420
 longitude144.997726
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(false)
 invalid(false)
 mlsidx_full_address30 Moffat Street Melbourne VIC
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2023-12-18 18:33:01
 created2020-03-17 11:27:53
 uri/property-detail/136/30-moffat-street-melbourne-vic-3186-usa
 absolute_urihttps://dev2.leveragere.com/property-detail/136/30-moffat-street-melbourne-vic-3186-usa
 address_concat30 Moffat Street Melbourne VIC 3186 USA
 google_maps_query_string30+Moffat+Street++Melbourne+VIC+3186+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 4,800,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty4
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2020-03-17
 overridden_brokerage_name
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 ArticlesProperty(array)
 id4
 article_id80
 property_id136
 Topic(array)
 0(array)
 id4
 nameArts & Culture
 created2016-02-12 10:04:42
 modified2016-02-24 11:51:27
 tile_nameArts & Culture
 ArticlesTopic(array)
 id46
 article_id80
 topic_id4
- locations(array)
 0(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
- 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)
 brokerageCompass, Pasadena
- brokerage(array)
 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
 Logo(array)
 id2692
 modelBrokerage
 model_id102
 tagLogo
 namelogo-compass.png
 typeimage/png
 size3193
 uri/assets/2692.png
 order0
 created2022-06-24 11:37:24
 modified2022-06-24 11:37:26
 MainImage(array)
 id1737
 modelBrokerage
 model_id102
 tagMainImage
 nametable_pic_fixed.jpg
 typeimage/jpeg
 size520970
 uri/assets/1737.jpg
 order0
 created2019-10-25 22:04:25
 modified2022-06-24 11:37:26
 ContactImage(array)
 id1735
 modelBrokerage
 model_id102
 tagContactImage
 namefron_square.jpg
 typeimage/jpeg
 size32619
 uri/assets/1735.jpg
 order0
 created2019-10-25 21:59:53
 modified2022-06-24 11:37:26
 ContactImage2(array)
 id1762
 modelBrokerage
 model_id102
 tagContactImage2
 nameprofile_square.jpg
 typeimage/jpeg
 size363580
 uri/assets/1762.jpg
 order0
 created2019-10-30 21:52:27
 modified2022-06-24 11:37:26
 ContactImage3(array)
 id1763
 modelBrokerage
 model_id102
 tagContactImage3
 namecharmeling.jpg
 typeimage/jpeg
 size32603
 uri/assets/1763.jpg
 order0
 created2019-10-30 21:56:57
 modified2022-06-24 11:37:26
 BrokerOfRecordLogo(array)
 id1761
 modelBrokerage
 model_id102
 tagBrokerOfRecordLogo
 namept_trans.png
 typeimage/png
 size26293
 uri/assets/1761.png
 order0
 created2019-10-30 18:08:40
 modified2022-06-24 11:37:26
 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	/team-detail/102/compass
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/team-detail/102/compass
Remote Port	21488
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 Cf Ray	a073934ead65376a-CMH
Http Accept Encoding	gzip, br
Http Cookie	CAKEPHP=vctja4v7uptofoossjgf1ap6es
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.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	aiN1Ec4JQCZiFPikroGjJgAAAYA
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	aiN1Ec4JQCZiFPikroGjJgAAAYA
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1780708625.728
Request Time	1780708625

====

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
====

Compass

Connect With Us

Read Our Profile

All About Compass

Compass 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: 15 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: 15 queries