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 = '95'
$brokerage = array(
	'Brokerage' => array(
		'password' => '*****',
		'id' => '95',
		'account_executive_id' => '235',
		'archived' => false,
		'type' => 'brokerage',
		'hide_from_frontend' => false,
		'agent_brokerage_data_override' => false,
		'featured_development' => false,
		'membership_type' => 'Premium',
		'max_properties' => '8',
		'max_homepage_featured_by_member_properties' => '0',
		'featured_properties_sort_method' => 'manual',
		'lux_feed_mode' => 'StripeSubscription',
		'max_luxury_feed_properties' => '4',
		'membership_luxury_feed_properties' => '0',
		'can_participate_in_lux_feed_while_archived' => false,
		'full_training_video_access' => false,
		'country_id' => '0',
		'WOEID' => '2477058',
		'timezone' => 'US/Eastern',
		'luxury_feed_enrollment_mode' => 'manual',
		'luxury_feed_include_mlsidx_minimum_price' => '0',
		'luxury_feed_include_leverage_minimum_price' => '0',
		'digital_ad_contacts' => '',
		'add_agents_to_grr_auto_recipients' => true,
		'mlsidx_id' => '',
		'mlsidx_lux_autofeed' => false,
		'mlsidx_lux_autofeed_minimum_price' => '0',
		'mlsidx_logo_url' => '',
		'mlsidx_disclaimer' => '',
		'name' => 'Coleman Realtors',
		'broker_of_record_name' => '',
		'short_name' => 'Coleman Realtors',
		'username' => 'ColemanRealtors',
		'password_reset_hash' => '',
		'monthly_invoice_amount' => '0.00',
		'monthly_invoice_start_date' => null,
		'monthly_invoice_end_date' => null,
		'contract_filename' => '',
		'active' => true,
		'lead_in' => '',
		'short_description' => '',
		'description' => '<p>Coleman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill.</p>

<p>Local knowledge, world-class expertise.</p>

<p>Rhode Islanders pride themselves on their independence. So do we: we&#39;re an independent, third-generation residential real estate company, not a franchise. That means we&#39;re totally focused on you and your needs. We&#39;ve helped thousands of clients buy, sell, and rent since we opened our doors in 1929. Today our clients rely on our team of over 100 experienced professionals for our local knowledge and expertise: we know the neighborhoods, the towns and the people. With offices in Barrington, East Greenwich, Providence and Watch Hill, we&#39;re nearby too. So no matter your challenge, we&#39;ll bring you a wealth of experience, ideas and relationships - all geared toward producing results.</p>
',
		'communities' => 'Barrington, RI
Providence, RI
Watch Hill, RI
Newport, RI
Jamestown, RI
Bristol, RI
Charlestown, RI
Narragansett, RI
South Kingstown, RI
East Greenwich, RI',
		'website' => 'http://www.colemanrealtors.com/',
		'address' => '135 Elmgrove Avenue',
		'address_2' => '',
		'city' => 'Providence',
		'state' => 'RI',
		'full_state' => 'Rhode Island',
		'country' => 'USA',
		'market' => 'Providence',
		'market_2' => '',
		'postal_code' => '02906',
		'phone' => 'David Coleman: (401) 245-3050',
		'phone_2' => 'Michael Young: (401) 274-3636',
		'phone_3' => '',
		'wide_contact_image' => false,
		'contact_name' => 'David Coleman & Michael Young',
		'contact_profile_link' => '',
		'contact_big_profile_link' => '',
		'contact_big_profile_link_text' => '',
		'contact_title' => 'Co-Owners',
		'contact_dre_num' => '',
		'contact_quote' => 'We invite you to contact us personally about Providence real estate.',
		'contact_email' => 'dfc@colemanrealtors.com',
		'contact_facebook' => '',
		'contact_twitter' => '',
		'contact_instagram' => '',
		'contact_pinterest' => '',
		'contact_linkedin' => '',
		'contact_youtube' => '',
		'contact_phone' => '',
		'contact_email_2' => 'myoung@colemanrealtors.com',
		'contact_2_facebook' => '',
		'contact_2_twitter' => '',
		'contact_2_instagram' => '',
		'contact_2_pinterest' => '',
		'contact_2_linkedin' => '',
		'contact_2_youtube' => '',
		'contact_phone_2' => '',
		'contact_website' => '',
		'contact_name_2' => '',
		'contact_profile_link_2' => '',
		'contact_big_profile_link_2' => '',
		'contact_big_profile_link_text_2' => '',
		'contact_title_2' => '',
		'contact_dre_num_2' => '',
		'contact_email_3' => '',
		'contact_name_3' => '',
		'contact_title_3' => '',
		'contact_dre_num_3' => '',
		'contact_phone_3' => '',
		'contact_3_facebook' => '',
		'contact_3_twitter' => '',
		'contact_3_instagram' => '',
		'contact_3_pinterest' => '',
		'contact_3_linkedin' => '',
		'contact_3_youtube' => '',
		'image_filename' => '95.jpg',
		'logo_filename' => '95.png',
		'contact_image_filename' => '95.jpg',
		'all_properties_link_image_filename' => '95.jpg',
		'all_properties_link' => 'http://www.colemanrealtors.com/featured',
		'video_embed_code' => '',
		'contact_video_embed_code' => '',
		'meta_title' => 'Providence Real Estate | Coleman Realtors | Leverage Global Partners',
		'meta_description' => 'Coleman Realtors is the exclusive representative for Leverage Global Partners in Providence, Rhode Island, USA.',
		'meta_keywords' => 'Coleman Realtors, Providence Real Estate, Leverage Global Partners, Providence Rhode Island Real Estate, Barrington Real Estate, East Greenwich Real Estate, Providence Real Estate, Watch Hill Real Estate',
		'login_message_counter' => '0',
		'stats_module_1_type' => '',
		'stats_module_1_value' => '',
		'stats_module_2_type' => '',
		'stats_module_2_value' => '',
		'stats_module_3_type' => '',
		'stats_module_3_value' => '',
		'last_activity_email_sent' => '0000-00-00 00:00:00',
		'converted' => true,
		'created' => '2014-02-11 18:09:34',
		'modified' => '2016-04-08 16:34:01',
		'dre_num' => '012345',
		'uri' => '/brokerage-detail/95/coleman-realtors',
		'website_short' => 'www.colemanrealtors.com',
		'name_with_location' => 'Coleman Realtors'
	),
	'Logo' => array(
		'id' => '2521',
		'model' => 'Brokerage',
		'model_id' => '95',
		'tag' => 'Logo',
		'name' => '95.png',
		'type' => 'image/png',
		'size' => '12692',
		'uri' => '/assets/2521.png',
		'order' => '0',
		'created' => '2016-03-30 11:40:34',
		'modified' => '2016-03-30 11:40:34'
	),
	'MainImage' => array(
		'id' => '2520',
		'model' => 'Brokerage',
		'model_id' => '95',
		'tag' => 'MainImage',
		'name' => '95.jpg',
		'type' => 'image/jpg',
		'size' => '630270',
		'uri' => '/assets/2520.jpg',
		'order' => '0',
		'created' => '2016-03-30 11:40:33',
		'modified' => '2016-03-30 11:40:33'
	),
	'ContactImage' => array(
		'id' => '2522',
		'model' => 'Brokerage',
		'model_id' => '95',
		'tag' => 'ContactImage',
		'name' => '95.jpg',
		'type' => 'image/jpg',
		'size' => '3451252',
		'uri' => '/assets/2522.jpg',
		'order' => '0',
		'created' => '2016-03-30 11:40:34',
		'modified' => '2016-03-30 11:40:34'
	),
	'ContactImage2' => array(
		'id' => null,
		'model' => null,
		'model_id' => null,
		'tag' => null,
		'name' => null,
		'type' => null,
		'size' => null,
		'uri' => null,
		'order' => null,
		'created' => null,
		'modified' => null
	),
	'ContactImage3' => array(
		'id' => null,
		'model' => null,
		'model_id' => null,
		'tag' => null,
		'name' => null,
		'type' => null,
		'size' => null,
		'uri' => null,
		'order' => null,
		'created' => null,
		'modified' => null
	),
	'BrokerOfRecordLogo' => array(
		'id' => null,
		'model' => null,
		'model_id' => null,
		'tag' => null,
		'name' => null,
		'type' => null,
		'size' => null,
		'uri' => null,
		'order' => null,
		'created' => null,
		'modified' => null
	),
	'FeaturedImage' => array()
)
BrokeragesController::view() - APP/Controller/BrokeragesController.php, line 537
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110

Leverage Brokerage | Coleman Realtors

Properties / Coleman Realtors

Coleman Realtors

Co-Owners: David Coleman & Michael Young
David Coleman: (401) 245-3050

License #: 012345

Visit Website

Coleman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill.

Local knowledge, world-class expertise.

Rhode Islanders pride themselves on their independence. So do we: we're an independent, third-generation residential real estate company, not a franchise. That means we're totally focused on you and your needs. We've helped thousands of clients buy, sell, and rent since we opened our doors in 1929. Today our clients rely on our team of over 100 experienced professionals for our local knowledge and expertise: we know the neighborhoods, the towns and the people. With offices in Barrington, East Greenwich, Providence and Watch Hill, we're nearby too. So no matter your challenge, we'll bring you a wealth of experience, ideas and relationships - all geared toward producing results.

Connect With Us

www.colemanrealtors.com

Coleman Realtors Featured Properties

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

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

Cake Params
- plugin(null)
- controllerbrokerages
- actionview
- named(empty)
- pass(array)
  095
  1coleman-realtors
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

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

Sql Log

Sql Logs

default

Total Time: 13 ms
Total Queries: 10 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `Logo`.`id`, `Logo`.`model`, `Logo`.`model_id`, `Logo`.`tag`, `Logo`.`name`, `Logo`.`type`, `Logo`.`size`, `Logo`.`uri`, `Logo`.`order`, `Logo`.`created`, `Logo`.`modified`, `MainImage`.`id`, `MainImage`.`model`, `MainImage`.`model_id`, `MainImage`.`tag`, `MainImage`.`name`, `MainImage`.`type`, `MainImage`.`size`, `MainImage`.`uri`, `MainImage`.`order`, `MainImage`.`created`, `MainImage`.`modified`, `ContactImage`.`id`, `ContactImage`.`model`, `ContactImage`.`model_id`, `ContactImage`.`tag`, `ContactImage`.`name`, `ContactImage`.`type`, `ContactImage`.`size`, `ContactImage`.`uri`, `ContactImage`.`order`, `ContactImage`.`created`, `ContactImage`.`modified`, `ContactImage2`.`id`, `ContactImage2`.`model`, `ContactImage2`.`model_id`, `ContactImage2`.`tag`, `ContactImage2`.`name`, `ContactImage2`.`type`, `ContactImage2`.`size`, `ContactImage2`.`uri`, `ContactImage2`.`order`, `ContactImage2`.`created`, `ContactImage2`.`modified`, `ContactImage3`.`id`, `ContactImage3`.`model`, `ContactImage3`.`model_id`, `ContactImage3`.`tag`, `ContactImage3`.`name`, `ContactImage3`.`type`, `ContactImage3`.`size`, `ContactImage3`.`uri`, `ContactImage3`.`order`, `ContactImage3`.`created`, `ContactImage3`.`modified`, `BrokerOfRecordLogo`.`id`, `BrokerOfRecordLogo`.`model`, `BrokerOfRecordLogo`.`model_id`, `BrokerOfRecordLogo`.`tag`, `BrokerOfRecordLogo`.`name`, `BrokerOfRecordLogo`.`type`, `BrokerOfRecordLogo`.`size`, `BrokerOfRecordLogo`.`uri`, `BrokerOfRecordLogo`.`order`, `BrokerOfRecordLogo`.`created`, `BrokerOfRecordLogo`.`modified` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` LEFT JOIN `leveragere_staging2`.`assets` AS `Logo` ON (`Logo`.`model_id` = `Brokerage`.`id` AND `Logo`.`model` = 'Brokerage' AND `Logo`.`tag` = 'Logo') LEFT JOIN `leveragere_staging2`.`assets` AS `MainImage` ON (`MainImage`.`model_id` = `Brokerage`.`id` AND `MainImage`.`model` = 'Brokerage' AND `MainImage`.`tag` = 'MainImage') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage` ON (`ContactImage`.`model_id` = `Brokerage`.`id` AND `ContactImage`.`model` = 'Brokerage' AND `ContactImage`.`tag` = 'ContactImage') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage2` ON (`ContactImage2`.`model_id` = `Brokerage`.`id` AND `ContactImage2`.`model` = 'Brokerage' AND `ContactImage2`.`tag` = 'ContactImage2') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage3` ON (`ContactImage3`.`model_id` = `Brokerage`.`id` AND `ContactImage3`.`model` = 'Brokerage' AND `ContactImage3`.`tag` = 'ContactImage3') LEFT JOIN `leveragere_staging2`.`assets` AS `BrokerOfRecordLogo` ON (`BrokerOfRecordLogo`.`model_id` = `Brokerage`.`id` AND `BrokerOfRecordLogo`.`model` = 'Brokerage' AND `BrokerOfRecordLogo`.`tag` = 'BrokerOfRecordLogo') WHERE `Brokerage`.`id` = 95 AND `Brokerage`.`archived` = '0' AND `Brokerage`.`hide_from_frontend` = '0' LIMIT 1	1	1	1
SELECT `FeaturedImage`.`id`, `FeaturedImage`.`model`, `FeaturedImage`.`model_id`, `FeaturedImage`.`tag`, `FeaturedImage`.`name`, `FeaturedImage`.`type`, `FeaturedImage`.`size`, `FeaturedImage`.`uri`, `FeaturedImage`.`order`, `FeaturedImage`.`created`, `FeaturedImage`.`modified` FROM `leveragere_staging2`.`assets` AS `FeaturedImage` WHERE `FeaturedImage`.`model` = 'Brokerage' AND `FeaturedImage`.`tag` = 'FeaturedImage' AND `FeaturedImage`.`model_id` = (95) ORDER BY `FeaturedImage`.`order` ASC	0	0	0
SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`locations` AS `Location` LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Location`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`assets` AS `Image` ON (`Image`.`model_id` = `Location`.`id` AND `Image`.`model` = 'Location' AND `Image`.`tag` = 'Image') WHERE `Location`.`brokerage_id` = 95 AND `Location`.`archived` = '0'	1	1	1
SELECT `Article`.`id`, `Article`.`model`, `Article`.`model_id`, `Article`.`archived`, `Article`.`medium_featured`, `Article`.`large_featured`, `Article`.`title`, `Article`.`author`, `Article`.`date`, `Article`.`lead_in`, `Article`.`body`, `Article`.`vimeo_id`, `Article`.`created`, `Article`.`modified`, `ParentBrokerage`.`id`, `ParentBrokerage`.`account_executive_id`, `ParentBrokerage`.`archived`, `ParentBrokerage`.`type`, `ParentBrokerage`.`hide_from_frontend`, `ParentBrokerage`.`agent_brokerage_data_override`, `ParentBrokerage`.`featured_development`, `ParentBrokerage`.`membership_type`, `ParentBrokerage`.`max_properties`, `ParentBrokerage`.`max_homepage_featured_by_member_properties`, `ParentBrokerage`.`featured_properties_sort_method`, `ParentBrokerage`.`lux_feed_mode`, `ParentBrokerage`.`max_luxury_feed_properties`, `ParentBrokerage`.`membership_luxury_feed_properties`, `ParentBrokerage`.`can_participate_in_lux_feed_while_archived`, `ParentBrokerage`.`full_training_video_access`, `ParentBrokerage`.`country_id`, `ParentBrokerage`.`WOEID`, `ParentBrokerage`.`timezone`, `ParentBrokerage`.`luxury_feed_enrollment_mode`, `ParentBrokerage`.`luxury_feed_include_mlsidx_minimum_price`, `ParentBrokerage`.`luxury_feed_include_leverage_minimum_price`, `ParentBrokerage`.`digital_ad_contacts`, `ParentBrokerage`.`add_agents_to_grr_auto_recipients`, `ParentBrokerage`.`mlsidx_id`, `ParentBrokerage`.`mlsidx_lux_autofeed`, `ParentBrokerage`.`mlsidx_lux_autofeed_minimum_price`, `ParentBrokerage`.`mlsidx_logo_url`, `ParentBrokerage`.`mlsidx_disclaimer`, `ParentBrokerage`.`name`, `ParentBrokerage`.`broker_of_record_name`, `ParentBrokerage`.`short_name`, `ParentBrokerage`.`username`, `ParentBrokerage`.`password`, `ParentBrokerage`.`password_reset_hash`, `ParentBrokerage`.`monthly_invoice_amount`, `ParentBrokerage`.`monthly_invoice_start_date`, `ParentBrokerage`.`monthly_invoice_end_date`, `ParentBrokerage`.`contract_filename`, `ParentBrokerage`.`active`, `ParentBrokerage`.`lead_in`, `ParentBrokerage`.`short_description`, `ParentBrokerage`.`description`, `ParentBrokerage`.`communities`, `ParentBrokerage`.`website`, `ParentBrokerage`.`address`, `ParentBrokerage`.`address_2`, `ParentBrokerage`.`city`, `ParentBrokerage`.`state`, `ParentBrokerage`.`full_state`, `ParentBrokerage`.`country`, `ParentBrokerage`.`market`, `ParentBrokerage`.`market_2`, `ParentBrokerage`.`postal_code`, `ParentBrokerage`.`phone`, `ParentBrokerage`.`phone_2`, `ParentBrokerage`.`phone_3`, `ParentBrokerage`.`wide_contact_image`, `ParentBrokerage`.`contact_name`, `ParentBrokerage`.`contact_profile_link`, `ParentBrokerage`.`contact_big_profile_link`, `ParentBrokerage`.`contact_big_profile_link_text`, `ParentBrokerage`.`contact_title`, `ParentBrokerage`.`contact_dre_num`, `ParentBrokerage`.`contact_quote`, `ParentBrokerage`.`contact_email`, `ParentBrokerage`.`contact_facebook`, `ParentBrokerage`.`contact_twitter`, `ParentBrokerage`.`contact_instagram`, `ParentBrokerage`.`contact_pinterest`, `ParentBrokerage`.`contact_linkedin`, `ParentBrokerage`.`contact_youtube`, `ParentBrokerage`.`contact_phone`, `ParentBrokerage`.`contact_email_2`, `ParentBrokerage`.`contact_2_facebook`, `ParentBrokerage`.`contact_2_twitter`, `ParentBrokerage`.`contact_2_instagram`, `ParentBrokerage`.`contact_2_pinterest`, `ParentBrokerage`.`contact_2_linkedin`, `ParentBrokerage`.`contact_2_youtube`, `ParentBrokerage`.`contact_phone_2`, `ParentBrokerage`.`contact_website`, `ParentBrokerage`.`contact_name_2`, `ParentBrokerage`.`contact_profile_link_2`, `ParentBrokerage`.`contact_big_profile_link_2`, `ParentBrokerage`.`contact_big_profile_link_text_2`, `ParentBrokerage`.`contact_title_2`, `ParentBrokerage`.`contact_dre_num_2`, `ParentBrokerage`.`contact_email_3`, `ParentBrokerage`.`contact_name_3`, `ParentBrokerage`.`contact_title_3`, `ParentBrokerage`.`contact_dre_num_3`, `ParentBrokerage`.`contact_phone_3`, `ParentBrokerage`.`contact_3_facebook`, `ParentBrokerage`.`contact_3_twitter`, `ParentBrokerage`.`contact_3_instagram`, `ParentBrokerage`.`contact_3_pinterest`, `ParentBrokerage`.`contact_3_linkedin`, `ParentBrokerage`.`contact_3_youtube`, `ParentBrokerage`.`image_filename`, `ParentBrokerage`.`logo_filename`, `ParentBrokerage`.`contact_image_filename`, `ParentBrokerage`.`all_properties_link_image_filename`, `ParentBrokerage`.`all_properties_link`, `ParentBrokerage`.`video_embed_code`, `ParentBrokerage`.`contact_video_embed_code`, `ParentBrokerage`.`meta_title`, `ParentBrokerage`.`meta_description`, `ParentBrokerage`.`meta_keywords`, `ParentBrokerage`.`login_message_counter`, `ParentBrokerage`.`stats_module_1_type`, `ParentBrokerage`.`stats_module_1_value`, `ParentBrokerage`.`stats_module_2_type`, `ParentBrokerage`.`stats_module_2_value`, `ParentBrokerage`.`stats_module_3_type`, `ParentBrokerage`.`stats_module_3_value`, `ParentBrokerage`.`last_activity_email_sent`, `ParentBrokerage`.`converted`, `ParentBrokerage`.`created`, `ParentBrokerage`.`modified`, `ParentBrokerage`.`dre_num`, `ParentLocation`.`id`, `ParentLocation`.`parent_id`, `ParentLocation`.`brokerage_id`, `ParentLocation`.`type`, `ParentLocation`.`archived`, `ParentLocation`.`use_as_topic`, `ParentLocation`.`name`, `ParentLocation`.`short_name`, `ParentLocation`.`group_index`, `ParentLocation`.`latitude`, `ParentLocation`.`longitude`, `ParentLocation`.`country_code`, `ParentLocation`.`north`, `ParentLocation`.`south`, `ParentLocation`.`east`, `ParentLocation`.`west`, `ParentLocation`.`zoom`, `ParentLocation`.`short_description`, `ParentLocation`.`long_description`, `ParentLocation`.`created`, `ParentLocation`.`modified`, `ParentLocation`.`timezone`, `ParentLocation`.`population` FROM `leveragere_staging2`.`articles` AS `Article` LEFT JOIN `leveragere_staging2`.`brokerages` AS `ParentBrokerage` ON (`Article`.`model_id` = `ParentBrokerage`.`id` AND `Article`.`model` = 'Brokerage') LEFT JOIN `leveragere_staging2`.`locations` AS `ParentLocation` ON (`Article`.`model_id` = `ParentLocation`.`id` AND `Article`.`model` = 'Location') WHERE `Article`.`model` = 'Brokerage' AND `Article`.`model_id` = 95 LIMIT 1	0	0	1	maybe slow
SELECT `Article`.`id` FROM `leveragere_staging2`.`articles` AS `Article` WHERE `Article`.`archived` = '0' AND NOT (`Article`.`model` = ('News')) ORDER BY `Article`.`created` DESC LIMIT 50	50	50	4	maybe slow
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (499, 498, 497, 495, 494, 493, 492, 491, 490, 487, 488, 486, 484, 485, 483, 482, 481, 480, 479, 478, 477, 476, 475, 473, 472, 470, 471, 468, 467, 466, 465, 464, 463, 462, 461, 459, 460, 458, 457, 456, 455, 454, 452, 453, 451, 450, 449, 448, 447, 446) ORDER BY `Image`.`order` ASC	50	50	1
SELECT `Article`.`id`, `Article`.`model`, `Article`.`model_id`, `Article`.`archived`, `Article`.`medium_featured`, `Article`.`large_featured`, `Article`.`title`, `Article`.`author`, `Article`.`date`, `Article`.`lead_in`, `Article`.`body`, `Article`.`vimeo_id`, `Article`.`created`, `Article`.`modified` FROM `leveragere_staging2`.`articles` AS `Article` WHERE `Article`.`id` IN (499, 498, 497, 495, 494, 493, 492, 491, 490, 487, 488, 486, 484, 485, 483, 482, 481, 480, 479, 478, 477, 476, 475, 473, 472, 470, 471, 468, 467, 466, 465, 464, 463, 462, 461, 459, 460, 458, 457, 456, 455, 454, 452, 453, 451, 450, 449, 448, 447, 446) ORDER BY RAND() ASC LIMIT 4	4	4	1	maybe slow
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (480, 463, 467, 485) ORDER BY `Image`.`order` ASC	4	4	0
SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`locations` AS `Location` LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Location`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`assets` AS `Image` ON (`Image`.`model_id` = `Location`.`id` AND `Image`.`model` = 'Location' AND `Image`.`tag` = 'Image') WHERE `Location`.`type` = 'Exclusive' AND `Location`.`archived` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	4
SELECT `MlsComplianceData`.`id`, `MlsComplianceData`.`mlsidx_brokerage_id`, `MlsComplianceData`.`mlsidx_logo_url`, `MlsComplianceData`.`mlsidx_disclaimer`, `MlsComplianceData`.`created`, `MlsComplianceData`.`modified` FROM `leveragere_staging2`.`mls_compliance_data` AS `MlsComplianceData` WHERE `MlsComplianceData`.`mlsidx_brokerage_id` IS NULL	0	0	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 10.73 MB

Message	Memory use
Component initialization	2.94 MB
Controller action start	3.86 MB
Controller render start	6.01 MB
View render complete	6.57 MB

Timers

Total Request Time: 226 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	34.55
Event: Controller.initialize	7.34
Event: Controller.startup	1.86
Controller action	36.91
Event: Controller.beforeRender	11.38
» Processing toolbar data	11.28
Rendering View	106.14
» Event: View.beforeRender	0.28
» Rendering APP/View/Brokerages/view.ctp	0.69
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.21
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	104.47
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)
  id66
  parent_id9
  brokerage_id121
  typeExclusive
  archived(false)
  use_as_topic(false)
  namePortland, OR, USA
  short_namePortland, OR, USA
  group_index
  latitude45.403168
  longitude-122.688202
  country_code
  north53.700001
  south19.700001
  east-52.599998
  west-146.600006
  zoom0
  short_descriptionNatural beauty boasting properties that “live where you work and work where you play.”
  long_descriptionIn the land of tall green fir trees in the Great Northwest stands the internationally active port city of Portland, Oregon and its glistening lake centered city of Lake Oswego. Boasting view and waterfront living, working and dining framed by majestic mountains and coastlines, the Greater Portland area has natural beauty, urban and country properties among the best anywhere. The area is buoyed by excellent educational institutions, high tech, sports, tourism, wine, beer and service industries attracting the highest levels of talent and energy. “Live where you work and work where you play” is the area’s creed due to the proximity of peerless outdoor locations, activities and vistas.
  created2016-04-04 17:09:17
  modified2016-04-04 17:09:17
  timezoneAmerica/Los_Angeles
  population2500000
  uri/locations/view/66/portland-or-usa
  tile_namePortland, OR, USA
  Brokerage(array)
  id121
  account_executive_id235
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties8
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties0
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id0
  WOEID2475687
  timezoneUS/Pacific
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameHarnish Properties LLC
  broker_of_record_name
  short_nameHarnish Properties LLC
  usernameHarnishProperties
  passwordea3a979ff4570da2ccc1d9882d4bbd44012f1fcb
  password_reset_hash
  monthly_invoice_amount0.00
  monthly_invoice_start_date(null)
  monthly_invoice_end_date(null)
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Harnish Properties LLC is the exclusive representative for Leverage Global Partners in Lake Oswego, Tualatin, Wilsonville, West Linn, Northwest Portland, Southwest Portland, Portland Heights, Irvington, Dunthorpe, Happy Valley, East/West Moreland, and Portland, Oregon, USA.</p> <p>More information coming soon!</p>
  communitiesLake Oswego Tualatin Wilsonville West Linn Northweset Portland Southwest Portland Portland Heights Irvington Dunthorpe Happy Valley East/West Moreland Portland
  websitehttp://harnishproperties.com/
  addressLocated in Downtown
  address_2
  cityLake Oswego
  stateOR
  full_stateOregon
  countryUSA
  marketPortland
  market_2
  postal_code97034
  phone(503) 699-8483
  phone_2
  phone_3
  wide_contact_image(false)
  contact_nameJustin Harnish
  contact_profile_link
  contact_big_profile_link
  contact_big_profile_link_text
  contact_titlePrincipal Broker/Partner
  contact_dre_num
  contact_quote
  contact_emailharnish@harnishproperties.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_filename121.jpg
  logo_filename121.jpg
  contact_image_filename121.jpg
  all_properties_link_image_filename121.jpg
  all_properties_linkhttp://www.harnishproperties.idxco.com/idx/4601/featured.php
  video_embed_code
  contact_video_embed_code
  meta_titlePortland Real Estate | Harnish Properties LLC | Leverage Global Partners
  meta_descriptionHarnish Properties LLC is the exclusive representative for Leverage Global Partners in Portland, Oregon, USA.
  meta_keywordsPortland Real Estate, Harnish Properties LLC, Leverage Global Partners, Justin Harnish
  login_message_counter0
  stats_module_1_type
  stats_module_1_value
  stats_module_2_type
  stats_module_2_value
  stats_module_3_type
  stats_module_3_value
  last_activity_email_sent0000-00-00 00:00:00
  converted(true)
  created2014-05-13 18:43:59
  modified2016-04-08 16:34:09
  dre_num012345
  uri/brokerage-detail/121/harnish-properties-llc
  website_shortharnishproperties.com
  name_with_locationHarnish Properties LLC
  Image(array)
  id2998
  modelLocation
  model_id66
  tagImage
  name121.jpg
  typeimage/jpeg
  size122603
  uri/assets/2998.jpg
  order0
  created2016-04-04 17:06:50
  modified2016-04-04 17:09:17
  1(array)
  Location(array)
  id120
  parent_id9
  brokerage_id57
  typeExclusive
  archived(false)
  use_as_topic(false)
  namePleasanton, CA, USA
  short_namePleasanton, CA, USA
  group_index
  latitude37.662430
  longitude-121.874680
  country_code
  north53.700001
  south19.700001
  east-52.599998
  west-146.600006
  zoom0
  short_description
  long_descriptionMore information coming soon!
  created2016-04-05 17:57:23
  modified2016-04-14 14:57:21
  timezoneAmerica/Los_Angeles
  population74000
  uri/locations/view/120/pleasanton-ca-usa
  tile_namePleasanton, CA, USA
  Brokerage(array)
  id57
  account_executive_id235
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties8
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties0
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id1
  WOEID2474209
  timezoneUS/Pacific
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameJ. Rockcliff Realtors
  broker_of_record_name
  short_nameJ Rockcliff Realtors
  usernameJRockcliffPleas
  password14a01d92dcd7b0cd5ad6f01dca84a3e626414a24
  password_reset_hash
  monthly_invoice_amount(null)
  monthly_invoice_start_date0000-00-00
  monthly_invoice_end_date0000-00-00
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>J. Rockcliff Realtors is the exclusive representative for Leverage Global Partners in Pleasanton, Dublin, Livermore, Castro Valley, Fremont, and Sunol, California. </p> <p>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.</p> <p>With offices located in <a href="../../../brokerage-detail/55/J.-Rockcliff-Realtors">LaMorinda</a> (Lafayette, Moraga, Orinda), <a href="../../../brokerage-detail/56/J.-Rockcliff-Realtors">Walnut Creek</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Danville</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Blackhawk</a>, and <a href="../../../brokerage-detail/57/J.-Rockcliff-Realtors">Pleasanton/Dublin/Livermore</a>, experienced Realtors can assist with your home buying or home selling needs in any real estate market. Looking for bank owned properties? We can help.</p> <p>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.</p> <p>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.</p> <p>J.Rockcliff also has offices in <a href="../../../brokerage-detail/55/J.-Rockcliff-Realtors">Lafayette</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Danville</a>, and <a href="../../../brokerage-detail/56/J.-Rockcliff-Realtors">Walnut Creek</a>.</p>
  communitiesPleasanton Dublin Livermore Castro Valley Sunol
  websitehttp://www.rockcliff.com/
  address5075 Hopyard Road
  address_2Suite 110
  cityPleasanton
  stateCA
  full_stateCalifornia
  countryUSA
  marketPleasanton
  market_2
  postal_code94588
  phone(925) 251-2500
  phone_2
  phone_3
  wide_contact_image(false)
  contact_nameJeff Sposito
  contact_profile_link
  contact_big_profile_link
  contact_big_profile_link_text
  contact_titlePresident
  contact_dre_num
  contact_quote
  contact_emailjsposito@rockcliff.com
  contact_facebook
  contact_twitter
  contact_instagram
  contact_pinterest
  contact_linkedin
  contact_youtube
  contact_phone
  contact_email_2
  contact_2_facebook
  contact_2_twitter
  contact_2_instagram
  contact_2_pinterest
  contact_2_linkedin
  contact_2_youtube
  contact_phone_2
  contact_website
  contact_name_2
  contact_profile_link_2
  contact_big_profile_link_2
  contact_big_profile_link_text_2
  contact_title_2
  contact_dre_num_2
  contact_email_3
  contact_name_3
  contact_title_3
  contact_dre_num_3
  contact_phone_3
  contact_3_facebook
  contact_3_twitter
  contact_3_instagram
  contact_3_pinterest
  contact_3_linkedin
  contact_3_youtube
  image_filename57.jpg
  logo_filename57.jpg
  contact_image_filename57.jpg
  all_properties_link_image_filename57.jpg
  all_properties_linkhttp://www.rockcliff.com/Rockcliff-Listings#g=2a4505b8-af60-49e2-b0c4-b980136a5da0
  video_embed_code
  contact_video_embed_code
  meta_titlePleasanton Real Estate | J. Rockcliff Realtors | Leverage Global Partners
  meta_descriptionJ. Rockcliff Realtors is the exclusive representative for Leverage Global Partners in Pleasanton, CA, USA.
  meta_keywordsJ. Rockcliff Realtors, Pleasanton Real Estate, Leverage Global Partners, Jeff Sposito
  login_message_counter0
  stats_module_1_type
  stats_module_1_value
  stats_module_2_type
  stats_module_2_value
  stats_module_3_type
  stats_module_3_value
  last_activity_email_sent0000-00-00 00:00:00
  converted(true)
  created2013-09-26 15:00:06
  modified2016-04-08 16:33:30
  dre_num012345
  uri/brokerage-detail/57/j-rockcliff-realtors
  website_shortwww.rockcliff.com
  name_with_locationJ. Rockcliff Realtors
  Image(array)
  id3383
  modelLocation
  model_id120
  tagImage
  namepleasonton.jpg
  typeimage/jpeg
  size171746
  uri/assets/3383.jpg
  order0
  created2016-04-05 17:57:11
  modified2016-04-14 14:57:21
  2(array)
  Location(array)
  id40
  parent_id9
  brokerage_id66
  typeExclusive
  archived(false)
  use_as_topic(false)
  nameBandon, OR, USA
  short_nameBandon, OR, USA
  group_index
  latitude43.118999
  longitude-124.408447
  country_code
  north53.700001
  south19.700001
  east-52.599998
  west-146.600006
  zoom0
  short_description
  long_descriptionMore information coming soon!
  created2016-04-04 12:33:14
  modified2016-04-04 12:33:14
  timezoneAmerica/Los_Angeles
  population3000
  uri/locations/view/40/bandon-or-usa
  tile_nameBandon, OR, USA
  Brokerage(array)
  id66
  account_executive_id235
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties8
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties0
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id1
  WOEID2358911
  timezoneUS/Pacific
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameBandon Property
  broker_of_record_name
  short_nameBandon Property
  usernameBandonProperty
  passworda75facc074e42f294adc1de9e6ea78b5258493d9
  password_reset_hash
  monthly_invoice_amount(null)
  monthly_invoice_start_date0000-00-00
  monthly_invoice_end_date0000-00-00
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Bandon Properties is the exclusive representative for Leverage Global Partners in Bandon, Florence, Reedsport, Lakeside, North Bend, Coos Bay, Coquille, Myrtle Point, Langlois, Port Orford, Gold Beach and Brookings, Oregon, USA.</p> <p>Hunter Finch founded Bandon Property LLC in 2006 after noticing the untapped need for a real estate brokerage that specializes in special properties: higher-end, unique homes, ranches and businesses, that deserve a higher level of service.</p> <p>Bandon Properties caters to a broad diversity of properties across all price ranges. However, for those special properties with inherently unique characteristics, Bandon Properties is able to provide a level of service higher than is typical for the regular real estate brokerage. Business is brisk and seasonally frenetic, and the demands are such that it isn't reasonably possible to help everyone wishing to buy or sell without sacrificing the quality of service provided, which is an unacceptable option.</p> <p>The objective isn't to be all things to all people. Nor is it to have a hand in every deal that goes to escrow. Instead, Bandon Property strives to selectively invest efforts, thereby facilitating the ability to provide superior service to buyers and sellers of premium and development properties, whether oceanfront, suburban, rural or farmland.</p> <p>As is the case with U.S. real estate generally, prices here have fallen with the downturn in the market, and there are many excellent values to be found relative to other coastal areas. It’s not unusual for visitors from California or Arizona to be pleasantly surprised to find how far their money will go in rural Oregon.</p> <p>Further, there are factors specific to Bandon, not the least of which is Bandon Dunes Golf Resort's national media exposure, which promise the potential for strong future growth, and there are many who see Bandon as being one of the best long term investments on the southern Oregon coast. Our clients come to us from all over the United States. Many are private investors looking for long term value and/or soon-to-be retirees seeking an area with a higher quality of living. Most of our business is conducted by appointment and through referrals.</p>
  communitiesFlorence Bandon Reedsport Lakeside North Bend Coos Bay Coquille Myrtle Point Langlois Port Orford Gold Beach Brookings
  websitehttp://www.bandonproperty.com/index.php
  address100 Seabird Drive
  address_2PO Box 1622
  city Bandon
  stateOR
  full_stateOregon
  countryUSA
  marketBandon
  market_2
  postal_code
  phone(541) 404-5888
  phone_2(541) 347-5500 Ext. 222
  phone_3
  wide_contact_image(false)
  contact_nameHunter Finch
  contact_profile_link
  contact_big_profile_linkhttp://www.leveragere.com/blog/meet-hunter-finch-principal-broker-bandon-property/
  contact_big_profile_link_text
  contact_titlePrincipal Broker
  contact_dre_num
  contact_quote
  contact_emailHunter@BandonProperty.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_filename66.jpg
  logo_filename66.jpg
  contact_image_filename66.JPG
  all_properties_link_image_filename66.jpg
  all_properties_linkhttp://bandonproperty.idxbroker.com/idx/featured
  video_embed_code
  contact_video_embed_code
  meta_titleBandon Real Estate | Bandon Property | Leverage Global Partners
  meta_descriptionBandon Property is the exclusive representative for Leverage Global Partners in Bandon, Oregon, USA.
  meta_keywordsbandon property, bandon real estate, oregon real estate, leverage global partners
  login_message_counter0
  stats_module_1_type
  stats_module_1_value
  stats_module_2_type
  stats_module_2_value
  stats_module_3_type
  stats_module_3_value
  last_activity_email_sent0000-00-00 00:00:00
  converted(true)
  created2013-10-28 11:17:07
  modified2016-04-08 16:33:30
  dre_num012345
  uri/brokerage-detail/66/bandon-property
  website_shortwww.bandonproperty.com/index.php
  name_with_locationBandon Property
  Image(array)
  id2968
  modelLocation
  model_id40
  tagImage
  nameBandon.jpg
  typeimage/jpeg
  size121406
  uri/assets/2968.jpg
  order0
  created2016-04-04 12:33:01
  modified2016-04-04 12:33:14
  3(array)
  Location(array)
  id32
  parent_id9
  brokerage_id28
  typeExclusive
  archived(false)
  use_as_topic(false)
  nameHonolulu, Oahu, HI, USA
  short_nameHonolulu, Oahu, HI, USA
  group_index
  latitude21.296232
  longitude-157.701981
  country_code
  north53.700001
  south19.700001
  east-52.599998
  west-146.600006
  zoom0
  short_descriptionHonolulu, Oahu: Paradise has been found and it's calling your name!
  long_descriptionWhether you’re a sun-seeker, metropolitan maven, or adventure addict, Honolulu is the place to be! Located on beautiful Oahu, also known as the “The Gathering Place”, Hawaii’s most populous city is an alluring melting pot of cultures and cuisines. The relaxed lifestyle and ‘Aloha’ spirit will keep your mind at ease while our stunning mountains and pristine beaches keep you young and active. From famous historical sites to secluded natural treasures, residents here enjoy a boundless supply of scenic beauty and rejuvenating adventure. Also boasting world-class shopping, commerce and entertainment, you are sure to find your place in the sun!
  created2016-04-04 12:01:25
  modified2016-04-04 12:03:35
  timezonePacific/Honolulu
  population953000
  uri/locations/view/32/honolulu-oahu-hi-usa
  tile_nameHonolulu, Oahu, HI, USA
  Brokerage(array)
  id28
  account_executive_id236
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties8
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties0
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id1
  WOEID12485533
  timezoneUS/Hawaii
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameEast Oahu Realty, RB-16090
  broker_of_record_name
  short_nameEast Oahu Realty
  usernameEastOahu
  password184254dea91b6c8586489ec50b8219bece099e54
  password_reset_hash
  monthly_invoice_amount(null)
  monthly_invoice_start_date0000-00-00
  monthly_invoice_end_date0000-00-00
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>East Oahu Realty is the exclusive representative for Leverage Global Partners in Honolulu, Oahu, Hawaii, USA.</p> <p>In 1992, Jack Leslein, President & Founder of East Oahu Realty, Inc., ventured forward with his dream of creating a real estate company of Realtors that would make a difference. Our mission is to be a pacesetter in real estate services by sharing our knowledge and skillfully guiding our clients beyond their expectations.</p> <p>Specializing in helping clients achieve their real estate objectives and focusing on personalized service and attention, East Oahu Realty became the home of trained and experienced Realtors, state of the art technology and dedicated support staff. East Oahu Realty is able to provide the utmost in professional real estate service.</p> <p>As a locally owned, Kama’aina company, we respect and value our island heritage. We are committed to enhancing the lives of those who reside here by providing the utmost in service and community support. We know our market as well as the economic and social factors that shape it. Our knowledge, combined with our broad base of experience, assures you have the information you need to make an informed decision.</p> <p>We are committed to your success, and we are leaders in our industry and our community. We take an active role in shaping the future of both. We are committed to maintaining our reputation of integrity and honesty.</p> <p>We represent our clients enthusiastically and fairly and have done so since 1992. Choosing can make all the difference.</p> <p>What Our Clients Can Expect:</p> <ul> <li>Premier Market Presence</li> <li>Select Team of Successful Real Estate Professionals</li> <li>Global Networking and Exposure</li> <li>Comprehensive Market Analysis & Plans</li> <li>Member of Luxury Real Estate</li> <li>State of the Art Technology</li> <li>Multi-Lingual Realtors</li> <li>Mortgage Services On-Site</li> </ul>
  communitiesHonolulu Hawaii HI USA Oahu Hawaii HI USA
  websitehttp://www.eastoahu.com/
  address6600 Kalanianaole Hwy # 114
  address_2
  cityHonolulu, Oahu
  stateHI
  full_stateHawaii
  countryUSA
  market
  market_2
  postal_code96825
  phone(808) 791-2216
  phone_2
  phone_3
  wide_contact_image(false)
  contact_nameCherie Tsukamoto
  contact_profile_link
  contact_big_profile_link
  contact_big_profile_link_text
  contact_titlePrincipal Broker, RB - 14911
  contact_dre_num
  contact_quoteI invite you to contact me personally regarding East Oahu Realty.
  contact_emailcherie.tsukamoto@eastoahu.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_filename28.jpg
  logo_filename28.jpg
  contact_image_filename28.jpg
  all_properties_link_image_filename28.jpg
  all_properties_linkhttp://www.eastoahu.com/search/FeaturedListings.aspx
  video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/4U1wTm0Z-qzxAOUo0.js"></script>
  contact_video_embed_code
  meta_titleHonolulu, Oahu Real Estate | East Oahu Realty | Leverage Global Partners
  meta_descriptionEast Oahu Realty is the exclusive representative for Leverage Global Partners in Oahu, Hawaii, USA.
  meta_keywordseast oahu realty, oahu real estate, honolulu real estate, oahu hawaii, jack leslein, leverage global partners
  login_message_counter0
  stats_module_1_type
  stats_module_1_value
  stats_module_2_type
  stats_module_2_value
  stats_module_3_type
  stats_module_3_value
  last_activity_email_sent0000-00-00 00:00:00
  converted(true)
  created2013-05-10 18:19:12
  modified2016-04-08 16:33:22
  dre_num012345
  uri/brokerage-detail/28/east-oahu-realty-rb-16090
  website_shortwww.eastoahu.com
  name_with_locationEast Oahu Realty, RB-16090
  Image(array)
  id2956
  modelLocation
  model_id32
  tagImage
  nameeast oahu realty.jpg
  typeimage/jpeg
  size148264
  uri/assets/2956.jpg
  order0
  created2016-04-04 11:41:09
  modified2016-04-04 12:03:35
- sidebar_articles(array)
  0(array)
  Article(array)
  id480
  modelArticle
  model_id0
  archived(false)
  medium_featured(true)
  large_featured(false)
  titleCelebrity Spotlight: Madison Hildebrand
  authorLeverageRE
  date2016-03-29
  lead_inThough reality television enthusiasts are used to seeing Madison Hildebrand's million-dollar smile on BRAVO's Million Dollar Listing Los Angeles for the past eight seasons, this summer he could be found everywhere from a yacht on the French Riviera to wielding a shovel and mixing cement in Managua.
  body<div> <div> <div> </div> </div> <div> <div> <p>He started the summer as an ambassador with <a href="https://givebackhomes.com/" target="_blank">Give Back Homes</a>, traveling to the capital of Nicaragua to build a home for a local family.</p> <p>"With every brick you lay and shovel you shovel, every pile of rocks you move, you feel good. It's blood, sweat, and tears in the heat, but you can't help but feel good about it," Hildebrand said.</p> <p><img class="aligncenter size-full wp-image-12996 pure-img" src="/assets/3305.png" /></p> <p>Not one to miss an opportunity, Hildebrand mixed service with business and pleasure by meeting with Partners Trust and Leverage Global Partners while in Nicaragua-but in a slightly different locale.</p> <p>"We took a helicopter across the country to Guacalito, which is a surf town. To get there you fly over a massive volcano, which is incredible, and land at Mukul Resort. They hosted us and gave us a four-bedroom villa, a butler-it was an amazing couple of days," he reflected. "It was awesome and refreshing. It's one of the coolest things to build a house and experience a different part of the country."</p> <p><img class="aligncenter wp-image-12997 pure-img" src="/assets/3306.png" /></p> <p>Hildebrand has summered abroad every year since moving to Malibu in 1999 to attend Pepperdine University. This year's odyssey took him along the azure coasts of Italy and the French Riviera.</p> </div> <div> <p>"This summer I had the fortunate opportunity to board a 110-foot yacht that one of my clients and best friends booked. We flew into Florence, then eight of my best friends took the yacht from the port down to Positano, where one of my friends got engaged."</p> <p>From Positano to Corsica, Monaco, Nice, and Antibes, Hildebrand described the theme of the trip as "you don't even know what you don't even know," as only the host knew what adventure awaited them at the next port.</p> <p><img class="aligncenter size-full wp-image-12992 pure-img" src="/assets/3307.png" /></p> <div> <div> <div> <p>An avid traveler, gardener, real estate guru, and enthusiast of joie de vivre, Hildebrand believes in loving what you do and doing what you love. His company, <a href="http://www.themalibulife.com/" target="_blank">The Malibu Life</a>, is inspired by just that: the aspirational lifestyle that draws people to the area's more laid-back, yet glamorous, sensibility.</p> <p>"It's really that we are an extension of selling the lifestyle more than just a house. It's a very chic, but casually sophisticated group of people with all sorts of backgrounds," Hildebrand explains. "More than anything, Mother Nature is a key element that ties it all together, but you're still on the cusp of everything LA-so you still have fashion and the entertainment events-but out here it's much more easygoing and relaxed."</p> <p><img class="aligncenter size-full wp-image-12994 pure-img" src="/assets/3308.png" /></p> <p>Hildebrand wears many hats, including acting as a concierge of sorts. "My brand and myself are resources to live the lifestyle they came here to live. If they want surf instructors, or they want horseback riding, I have all those connections. You want fancy cars? I've got a car dealer. If they need a private jet, I've got an affiliation with that company."</p> </div> <div> <p>One of the roles he's taken on again this past year is appearing on Million Dollar Listing Los Angeles. He "retired" after season 6, but fans will see him come out of retirement with his own episodes midway through this season. Hildebrand said his hiatus from the show came from his regular practice of reevaluating priorities.</p> <p>"Our show in particular is one of the longest-filmed shows for reality. It takes about ten or eleven months to get the 12 to 14 episodes, and between filming and wardrobe, it's absolutely exhausting," he explains. "At the end of the day it was time to look at why I was doing it, and I just felt like it was time to tap out. I've come back because it can be on my terms, and I'm excited to update my fans on what's going on in my life."</p> <p><img class="aligncenter size-full wp-image-12993 pure-img" src="/assets/3309.png" /></p> </div> <div> <p>Hildebrand's priorities this fall include hosting the Breast Cancer Research Foundation's Play For P.I.N.K. golf tournament in October, a cause close to his heart after losing his grandmother to the disease. He will participate in another Give Back Homes buildsite in San Diego in November, as well as speaking at the National Association of Realtors Conference.</p> <p>Hildebrand's life won't be slowing down anytime soon-and that's just how he likes it.</p> <p>"I think you're either expanding or contracting," he said. "That's just the way it is. If you're not lifting weight, your muscles are deflating; if you are, they're inflating. Your mind is the same way. If I'm not doing something good for my soul like gardening or exercising, then I'm doing something healthy for my mind-so if that's meditating, reading, learning something new, or finding another passion, that's also a big part of who I am."</p> <p><img class="aligncenter wp-image-12995 pure-img" src="/assets/3310.png" /></p> </div> </div> </div> </div> </div> </div>
  vimeo_id
  created2016-04-05 14:35:00
  modified2016-04-11 17:49:35
  uri/articles/view/480/celebrity-spotlight-madison-hildebrand
  Image(array)
  0(array)
  id3311
  modelArticle
  model_id480
  tagImage
  name2-3.jpg
  typeimage/jpg
  size106052
  uri/assets/3311.jpg
  order0
  created2016-04-05 14:35:01
  modified2016-04-11 17:49:35
  1(array)
  Article(array)
  id463
  modelArticle
  model_id0
  archived(false)
  medium_featured(false)
  large_featured(false)
  titleShop the Store: Aether
  authorLeverageRE
  date2016-03-17
  lead_inFounded in 2009 by film producers/outdoorsmen Palmer West and Jonah Smith, the Los Angeles brand AETHER Apparel is known for its functional mountain wear that remains stylish in the city. While early collections focused on lightweight jackets and performance apparel, recent seasons have included loungewear, swimwear, and base layers. Brick-and-mortar outlets are limited to their Los Angeles and San Francisco locations-the latter of which is made entirely from shipping containers-but Aether's comprehensive website offers its own merchandise as well as hand-picked gadgets and gear.
  body<p><a href="http://www.aetherapparel.com/products/apex" target="_blank"><img class="aligncenter wp-image-12608 pure-img" src="/assets/3193.jpg" /></a></p> <p><a href="http://www.aetherapparel.com/products/apex" target="_blank">APEX SNOW PANT</a></p> <p>These waterproof, seam-sealed pants are available in seven colors and feature a three-layer shell, weather-proof zippers, thigh zip vents, snow gaiters, and an integrated RECCO rescue reflector. <em>$375</em></p> <p><a href="http://www.aetherapparel.com/products/cashmere-watch-cap" target="_blank"><img class="aligncenter wp-image-12615 pure-img" src="/assets/3194.jpg" /></a></p> <p><a href="http://www.aetherapparel.com/products/cashmere-watch-cap" target="_blank">CASHMERE WATCH CAP</a></p> <p>Soft and form-fitting, this 100-percent cashmere hat available in jet black or charcoal feels like a plush blanket for your head. <em>$110</em></p> <p><a href="http://www.aetherapparel.com/products/hooded-henley" target="_blank"><img class="aligncenter wp-image-12617 pure-img" src="/assets/3195.jpg" /></a></p> <p><a href="http://www.aetherapparel.com/products/hooded-henley" target="_blank">HOODED HENLEY</a></p> <p>New this season, this French terry pullover, lined with Supima cotton slub jersey for ultimate softness, features a kangaroo pocket to keep your hands toasty. <em>$110</em></p> <p><a href="http://www.aetherapparel.com/" target="_blank"><img class="aligncenter wp-image-12613 pure-img" src="/assets/3196.jpg" /></a></p> <p><a href="http://www.aetherapparel.com/" target="_blank">ANORAK</a></p> <p>Water and wind resistant, this lightweight jacket offers 100 grams of PrimaLoft insulation, an adjustable hood, and three pockets. <em>$325</em></p> <p><a href="http://www.aetherapparel.com/products/waffle-circle-scarf" target="_blank"><img class="aligncenter wp-image-12614 pure-img" src="/assets/3197.jpg" /></a></p> <p><a href="http://www.aetherapparel.com/products/waffle-circle-scarf" target="_blank">WAFFLE CIRCLE SCARF</a></p> <p>The single circle allows you to wear it long or double looped for extra warmth, while the waffled cashmere makes it work whether you're dressed for the slopes or the city. <em>$235</em></p>
  vimeo_id
  created2016-04-05 14:31:49
  modified2016-04-08 09:49:29
  uri/articles/view/463/shop-the-store-aether
  Image(array)
  0(array)
  id3198
  modelArticle
  model_id463
  tagImage
  nameaether.jpg
  typeimage/jpg
  size930834
  uri/assets/3198.jpg
  order0
  created2016-04-05 14:31:49
  modified2016-04-08 09:49:29
  2(array)
  Article(array)
  id467
  modelLocation
  model_id153
  archived(false)
  medium_featured(false)
  large_featured(false)
  titleLocation: Paris
  authorLeverageRE
  date2016-03-15
  lead_inIts nickname is the City of Lights, but you could easily swap in love, culture, or croissants. Home to nearly one-fifth of the population of France, Paris is the fifth largest city in the European Union by population and the third most visited city in the world, annually drawing 29 million visitors.
  body<p>The hearty tourism industry has helped make Paris the sixth richest city in the world by gross domestic product. Upcoming events include contemporary interior design fair <a href="http://www.maison-objet.com/en/paris" target="_blank">Maison &</a> <a href="http://www.maison-objet.com/en/paris">Objet</a> (January), <a href="http://tradeshows.whosnext.com/" target="_blank">Fashion Week</a> (February), and international art event <a href="http://www.artparis.fr/en" target="_blank">Art Paris</a> (March). Each year, some 900 movies are filmed at the city's iconic landmarks, among them the most visited museum in the world, the <a href="http://www.louvre.fr/" target="_blank">Louvre</a>.</p> <p>However, statistics show that 60 percent of visitors are there to shop. The city is home to some of the most prestigious fashion labels in the world, and established destinations such as <a href="http://www.louisvuitton.com/front/%23/dispatch" target="_blank">Louis Vuitton</a> and <a href="http://www.colette.fr/" target="_blank">Colette</a> have recently been joined by new flagships for <a href="http://home.emiliopucci.com/news-home" target="_blank">Emilio Pucci</a> and <a href="http://www.ralphlauren.com/home/index.jsp?ab=Geo_iUS_rUS_dUS" target="_blank">Ralph Lauren</a>. This well-heeled crowd is also well-fed, with more than 70 Michelin-starred restaurants to choose from.</p> <p>City navigation is based on a clockwise spiral of 20 arrondissements-or administrative districts- each with its own mayor. Meandering through is the River Seine, where leafy parks beckon. The most famous shopping streets and exclusive real estate lies within the Triangle d'Or-the Golden Triangle-bordered by Avenues des Champs- Élysées, George V, and Montaigne.</p> <p>Besides great culture, shopping, food, and a thriving economy, here are just a few more reasons to love the city.</p> <h2><em><strong>WHERE TO EAT:</strong></em></h2> <p><img class="aligncenter wp-image-12468 pure-img" src="/assets/3239.png" /></p> <p><img class="aligncenter size-full wp-image-12469 pure-img" src="/assets/3240.png" /></p> <p><img class="aligncenter size-full wp-image-12466 pure-img" src="/assets/3241.png" /></p> <p><img class="aligncenter size-full wp-image-12467 pure-img" src="/assets/3242.png" /></p> <h2><em><strong>WHERE TO GO:</strong></em></h2> <p><img class="aligncenter size-full wp-image-12470 pure-img" src="/assets/3243.png" /></p> <p><img class="aligncenter size-full wp-image-12472 pure-img" src="/assets/3244.png" /></p> <h2><em><strong>WHERE TO STAY:</strong></em></h2> <p><img class="aligncenter size-full wp-image-12473 pure-img" src="/assets/3245.png" /><img class="aligncenter size-full wp-image-12474 pure-img" src="/assets/3246.png" /></p> <p><img class="aligncenter size-full wp-image-12489 pure-img" src="/assets/3247.png" /></p> <p><img class="aligncenter size-full wp-image-12476 pure-img" src="/assets/3248.png" /><img class="aligncenter size-full wp-image-12477 pure-img" src="/assets/3249.png" /></p>
  vimeo_id
  created2016-04-05 14:32:03
  modified2016-04-08 09:52:26
  uri/articles/view/467/location-paris
  Image(array)
  0(array)
  id3250
  modelArticle
  model_id467
  tagImage
  nameScreen-Shot-2016-03-15-at-11.08.07-AM.png
  typeimage/png
  size2001038
  uri/assets/3250.png
  order0
  created2016-04-05 14:32:04
  modified2016-04-08 09:52:26
  3(array)
  Article(array)
  id485
  modelArticle
  model_id0
  archived(false)
  medium_featured(true)
  large_featured(false)
  titleGet the Look: Spanish Influenced
  authorLeverageRE
  date2016-03-29
  lead_inQuintessential Spanish-Style Interior and Architectural Designs TILE STYLE Designs (from left): Alcala Gold, Tesoro, and Madrid Terracotta. $6.80–$8.30 per 8-inch square piece. The Cement Tile Shop. LIGHT ON Antique iron Hassler lantern, $4,350. Paul Ferrante. THE WRITE STUFF Archive Home and Monarch Collection Dali Secretary Deck, price upon request. Century Furniture. NAILED IT St. Andrews tufted […]
  body<h2><strong><em>Quintessential Spanish-Style Interior and Architectural Designs</em></strong></h2> <h3><strong>TILE STYLE</strong></h3> <p>Designs (from left): Alcala Gold, Tesoro, and Madrid Terracotta.</p> <p>$6.80–$8.30 per 8-inch square piece. <a href="http://www.cementtileshop.com/cement-tile/mexican-encaustic-cement-tile.html" target="_blank">The Cement Tile Shop.</a></p> <p><img class="aligncenter size-full wp-image-12951 pure-img" src="/assets/3334.png" /></p> <h3><strong>LIGHT ON</strong></h3> <p>Antique iron Hassler lantern, $4,350. <a href="http://www.paulferrante.com/" target="_blank">Paul Ferrante.</a></p> <h3><img class="aligncenter wp-image-12954 pure-img" src="/assets/3335.png" /><strong>THE WRITE STUFF</strong></h3> <p>Archive Home and Monarch Collection Dali Secretary Deck, price upon request. <a href="https://www.centuryfurniture.com/" target="_blank">Century Furniture.</a></p> <h3><img class="aligncenter wp-image-12955 pure-img" src="/assets/3336.png" /><strong>N</strong><strong>AILED</strong> <strong>IT</strong></h3> <p>St. Andrews tufted leather sofa with Spanish-style nailhead trim, $3,499. <a href="https://www.horchow.com/" target="_blank">Horchow.</a></p> <h3><img class="aligncenter size-full wp-image-12958 pure-img" src="/assets/3337.png" /><strong>HOLD A CANDLE</strong></h3> <p>Villa candlesticks in hand-leafed silver, $230 per pair. <a href="http://www.blisshomeanddesign.com/" target="_blank">Bliss Home &</a> Design.</p> <h3><img class="aligncenter wp-image-12956 pure-img" src="/assets/3338.png" /><strong>MISSION STATEMENT</strong></h3> <p>Spanish lowboy in primavera solids, price upon request. <a href="http://ebanista.com/" target="_blank">Ebanista.</a></p> <h3><img class="aligncenter wp-image-12952 pure-img" src="/assets/3339.png" /><strong>IRON GIST</strong></h3> <p>Balcon du Guadalquivir tablewear,$115–$440 per piece. <a href="http://usa.hermes.com/house/table/porcelain-earthenware/balcon-du-guadalquivir.html" target="_blank">Hermès.</a></p> <p><img class="aligncenter wp-image-12957 pure-img" src="/assets/3340.jpg" /></p>
  vimeo_id
  created2016-04-05 14:35:07
  modified2016-04-11 16:57:57
  uri/articles/view/485/get-the-look-spanish-influenced
  Image(array)
  0(array)
  id3341
  modelArticle
  model_id485
  tagImage
  nameSpanish-Influence.jpg
  typeimage/jpg
  size1210902
  uri/assets/3341.jpg
  order0
  created2016-04-05 14:35:08
  modified2016-04-11 16:57:57
- main_article(empty)
- locations(array)
  0(array)
  Location(array)
  id23
  parent_id7
  brokerage_id95
  typeExclusive
  archived(false)
  use_as_topic(false)
  nameProvidence, RI, USA
  short_nameProvidence, RI, USA
  group_index
  latitude41.823990
  longitude-71.412834
  country_code
  north53.700001
  south19.700001
  east-52.599998
  west-146.600006
  zoom0
  short_description
  long_descriptionMore information coming soon!
  created2016-04-04 11:12:00
  modified2016-04-04 11:12:00
  timezoneAmerica/New_York
  population178000
  uri/locations/view/23/providence-ri-usa
  tile_nameProvidence, RI, USA
  Brokerage(array)
  id95
  account_executive_id235
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties8
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties4
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id0
  WOEID2477058
  timezoneUS/Eastern
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameColeman Realtors
  broker_of_record_name
  short_nameColeman Realtors
  usernameColemanRealtors
  passwordc19a88afe4dbd7329004555ea008b2340aa6342b
  password_reset_hash
  monthly_invoice_amount0.00
  monthly_invoice_start_date(null)
  monthly_invoice_end_date(null)
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Coleman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill.</p> <p>Local knowledge, world-class expertise.</p> <p>Rhode Islanders pride themselves on their independence. So do we: we're an independent, third-generation residential real estate company, not a franchise. That means we're totally focused on you and your needs. We've helped thousands of clients buy, sell, and rent since we opened our doors in 1929. Today our clients rely on our team of over 100 experienced professionals for our local knowledge and expertise: we know the neighborhoods, the towns and the people. With offices in Barrington, East Greenwich, Providence and Watch Hill, we're nearby too. So no matter your challenge, we'll bring you a wealth of experience, ideas and relationships - all geared toward producing results.</p>
  communitiesBarrington, RI Providence, RI Watch Hill, RI Newport, RI Jamestown, RI Bristol, RI Charlestown, RI Narragansett, RI South Kingstown, RI East Greenwich, RI
  websitehttp://www.colemanrealtors.com/
  address135 Elmgrove Avenue
  address_2
  cityProvidence
  stateRI
  full_stateRhode Island
  countryUSA
  marketProvidence
  market_2
  postal_code02906
  phoneDavid Coleman: (401) 245-3050
  phone_2Michael Young: (401) 274-3636
  phone_3
  wide_contact_image(false)
  contact_nameDavid Coleman & Michael Young
  contact_profile_link
  contact_big_profile_link
  contact_big_profile_link_text
  contact_titleCo-Owners
  contact_dre_num
  contact_quoteWe invite you to contact us personally about Providence real estate.
  contact_emaildfc@colemanrealtors.com
  contact_facebook
  contact_twitter
  contact_instagram
  contact_pinterest
  contact_linkedin
  contact_youtube
  contact_phone
  contact_email_2myoung@colemanrealtors.com
  contact_2_facebook
  contact_2_twitter
  contact_2_instagram
  contact_2_pinterest
  contact_2_linkedin
  contact_2_youtube
  contact_phone_2
  contact_website
  contact_name_2
  contact_profile_link_2
  contact_big_profile_link_2
  contact_big_profile_link_text_2
  contact_title_2
  contact_dre_num_2
  contact_email_3
  contact_name_3
  contact_title_3
  contact_dre_num_3
  contact_phone_3
  contact_3_facebook
  contact_3_twitter
  contact_3_instagram
  contact_3_pinterest
  contact_3_linkedin
  contact_3_youtube
  image_filename95.jpg
  logo_filename95.png
  contact_image_filename95.jpg
  all_properties_link_image_filename95.jpg
  all_properties_linkhttp://www.colemanrealtors.com/featured
  video_embed_code
  contact_video_embed_code
  meta_titleProvidence Real Estate | Coleman Realtors | Leverage Global Partners
  meta_descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Providence, Rhode Island, USA.
  meta_keywordsColeman Realtors, Providence Real Estate, Leverage Global Partners, Providence Rhode Island Real Estate, Barrington Real Estate, East Greenwich Real Estate, Providence Real Estate, Watch Hill Real Estate
  login_message_counter0
  stats_module_1_type
  stats_module_1_value
  stats_module_2_type
  stats_module_2_value
  stats_module_3_type
  stats_module_3_value
  last_activity_email_sent0000-00-00 00:00:00
  converted(true)
  created2014-02-11 18:09:34
  modified2016-04-08 16:34:01
  dre_num012345
  uri/brokerage-detail/95/coleman-realtors
  website_shortwww.colemanrealtors.com
  name_with_locationColeman Realtors
  Image(array)
  id2950
  modelLocation
  model_id23
  tagImage
  nameColeman.jpg
  typeimage/jpeg
  size181216
  uri/assets/2950.jpg
  order0
  created2016-04-04 11:10:18
  modified2016-04-04 11:12:00
- 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)
  brokerageColeman Realtors, Providence
- brokerage(array)
  Brokerage(array)
  id95
  account_executive_id235
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties8
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties4
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id0
  WOEID2477058
  timezoneUS/Eastern
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameColeman Realtors
  broker_of_record_name
  short_nameColeman Realtors
  usernameColemanRealtors
  passwordc19a88afe4dbd7329004555ea008b2340aa6342b
  password_reset_hash
  monthly_invoice_amount0.00
  monthly_invoice_start_date(null)
  monthly_invoice_end_date(null)
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Coleman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill.</p> <p>Local knowledge, world-class expertise.</p> <p>Rhode Islanders pride themselves on their independence. So do we: we're an independent, third-generation residential real estate company, not a franchise. That means we're totally focused on you and your needs. We've helped thousands of clients buy, sell, and rent since we opened our doors in 1929. Today our clients rely on our team of over 100 experienced professionals for our local knowledge and expertise: we know the neighborhoods, the towns and the people. With offices in Barrington, East Greenwich, Providence and Watch Hill, we're nearby too. So no matter your challenge, we'll bring you a wealth of experience, ideas and relationships - all geared toward producing results.</p>
  communitiesBarrington, RI Providence, RI Watch Hill, RI Newport, RI Jamestown, RI Bristol, RI Charlestown, RI Narragansett, RI South Kingstown, RI East Greenwich, RI
  websitehttp://www.colemanrealtors.com/
  address135 Elmgrove Avenue
  address_2
  cityProvidence
  stateRI
  full_stateRhode Island
  countryUSA
  marketProvidence
  market_2
  postal_code02906
  phoneDavid Coleman: (401) 245-3050
  phone_2Michael Young: (401) 274-3636
  phone_3
  wide_contact_image(false)
  contact_nameDavid Coleman & Michael Young
  contact_profile_link
  contact_big_profile_link
  contact_big_profile_link_text
  contact_titleCo-Owners
  contact_dre_num
  contact_quoteWe invite you to contact us personally about Providence real estate.
  contact_emaildfc@colemanrealtors.com
  contact_facebook
  contact_twitter
  contact_instagram
  contact_pinterest
  contact_linkedin
  contact_youtube
  contact_phone
  contact_email_2myoung@colemanrealtors.com
  contact_2_facebook
  contact_2_twitter
  contact_2_instagram
  contact_2_pinterest
  contact_2_linkedin
  contact_2_youtube
  contact_phone_2
  contact_website
  contact_name_2
  contact_profile_link_2
  contact_big_profile_link_2
  contact_big_profile_link_text_2
  contact_title_2
  contact_dre_num_2
  contact_email_3
  contact_name_3
  contact_title_3
  contact_dre_num_3
  contact_phone_3
  contact_3_facebook
  contact_3_twitter
  contact_3_instagram
  contact_3_pinterest
  contact_3_linkedin
  contact_3_youtube
  image_filename95.jpg
  logo_filename95.png
  contact_image_filename95.jpg
  all_properties_link_image_filename95.jpg
  all_properties_linkhttp://www.colemanrealtors.com/featured
  video_embed_code
  contact_video_embed_code
  meta_titleProvidence Real Estate | Coleman Realtors | Leverage Global Partners
  meta_descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Providence, Rhode Island, USA.
  meta_keywordsColeman Realtors, Providence Real Estate, Leverage Global Partners, Providence Rhode Island Real Estate, Barrington Real Estate, East Greenwich Real Estate, Providence Real Estate, Watch Hill Real Estate
  login_message_counter0
  stats_module_1_type
  stats_module_1_value
  stats_module_2_type
  stats_module_2_value
  stats_module_3_type
  stats_module_3_value
  last_activity_email_sent0000-00-00 00:00:00
  converted(true)
  created2014-02-11 18:09:34
  modified2016-04-08 16:34:01
  dre_num012345
  uri/brokerage-detail/95/coleman-realtors
  website_shortwww.colemanrealtors.com
  name_with_locationColeman Realtors
  Logo(array)
  id2521
  modelBrokerage
  model_id95
  tagLogo
  name95.png
  typeimage/png
  size12692
  uri/assets/2521.png
  order0
  created2016-03-30 11:40:34
  modified2016-03-30 11:40:34
  MainImage(array)
  id2520
  modelBrokerage
  model_id95
  tagMainImage
  name95.jpg
  typeimage/jpg
  size630270
  uri/assets/2520.jpg
  order0
  created2016-03-30 11:40:33
  modified2016-03-30 11:40:33
  ContactImage(array)
  id2522
  modelBrokerage
  model_id95
  tagContactImage
  name95.jpg
  typeimage/jpg
  size3451252
  uri/assets/2522.jpg
  order0
  created2016-03-30 11:40:34
  modified2016-03-30 11:40:34
  ContactImage2(array)
  id(null)
  model(null)
  model_id(null)
  tag(null)
  name(null)
  type(null)
  size(null)
  uri(null)
  order(null)
  created(null)
  modified(null)
  ContactImage3(array)
  id(null)
  model(null)
  model_id(null)
  tag(null)
  name(null)
  type(null)
  size(null)
  uri(null)
  order(null)
  created(null)
  modified(null)
  BrokerOfRecordLogo(array)
  id(null)
  model(null)
  model_id(null)
  tag(null)
  name(null)
  type(null)
  size(null)
  uri(null)
  order(null)
  created(null)
  modified(null)
  FeaturedImage(empty)
- membership_subscription_temp_allowed_login(null)
- newsletter_member_types(array)
  Leverage Member: AgentLeverage Member: Agent
  Leverage Member: Broker or ManagementLeverage Member: Broker or Management
  Non-MemberNon-Member
- $request->data(empty)
- $this->validationErrors(array)
  Subscription(empty)
  Brokerage(empty)
  Logo(empty)
  BrokerOfRecordLogo(empty)
  MainImage(empty)
  FeaturedImage(empty)
  ContactImage(empty)
  ContactImage2(empty)
  ContactImage3(empty)
  Location(empty)
  Image(empty)
  Article(empty)
  Property(empty)
  User(empty)
  PropertyFeature(empty)
  SecondaryPropertyCategory(empty)
  Topic(empty)
  ParentBrokerage(empty)
  ParentLocation(empty)
  ArticlesBrokerage(empty)
  ArticlesLocation(empty)
  ArticlesProperty(empty)
  ArticlesTopic(empty)
  MlsComplianceData(empty)
- Loaded Helpers(array)
  0Permission
  1Number
  2SimpleGraph
  3DebugTimer
  4Toolbar
  5Session
  6Text
  7Flash
  8HtmlToolbar
  9Html
  10Form
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

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

====

Include
+
Included Files

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

Coleman Realtors

Connect With Us

Coleman Realtors Featured Properties

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 13 ms Total Queries: 10 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 13 ms
Total Queries: 10 queries