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 = '210'
$brokerage = array(
	'Brokerage' => array(
		'password' => '*****',
		'id' => '210',
		'account_executive_id' => '0',
		'archived' => false,
		'type' => 'brokerage',
		'hide_from_frontend' => false,
		'agent_brokerage_data_override' => false,
		'featured_development' => false,
		'membership_type' => 'Basic',
		'max_properties' => '8',
		'max_homepage_featured_by_member_properties' => '0',
		'featured_properties_sort_method' => 'manual',
		'lux_feed_mode' => 'StripeSubscription',
		'max_luxury_feed_properties' => '0',
		'membership_luxury_feed_properties' => '0',
		'can_participate_in_lux_feed_while_archived' => false,
		'full_training_video_access' => false,
		'country_id' => '0',
		'WOEID' => '8676',
		'timezone' => 'America/Edmonton',
		'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' => 'Liv Real Estate',
		'broker_of_record_name' => '',
		'short_name' => 'Liv Real Estate',
		'username' => 'LivRealEstate',
		'password_reset_hash' => '',
		'monthly_invoice_amount' => null,
		'monthly_invoice_start_date' => null,
		'monthly_invoice_end_date' => null,
		'contract_filename' => '',
		'active' => true,
		'lead_in' => '',
		'short_description' => '',
		'description' => '<p>Liv Real Estate is the exclusive representative for Leverage Global Partners in Edmonton, Spruce Grove, St. Albert, Sherwood Park, Devon, Stony Plain, Leduc, Beaumont, and Fort Saskatchewan, Alberta, Canada.</p>

<p>Selling your home is about you, and should feel as familiar and safe as your backyard. We believe in making our clients savvy, so they are part of the conversation when it comes to aligning big decisions with the best move.</p>

<p>Liv offers a fresh perspective to real estate with a new outlook on dotted lines and traditional relationships between agents and homeowners. We take the artifice out of the transaction and the bus bench out of the relationship. We are homeowners too, and we stand behind a transparent process.</p>

<p>When it&rsquo;s time to give up the growth charts notched into your walls, or find familiar creaky floorboards in new surroundings, Liv is ready for you. We don&rsquo;t want to be famous, we just want you to Love Where You Liv, and help you make sense of moving in, or moving on.</p>

<p>This is how real estate really is.</p>
',
		'communities' => 'Edmonton
Spruce Grove
St. Albert
Sherwood Park
Devon
Stony Plain
Leduc
Beaumont
Fort Saskatchewan',
		'website' => 'http://www.livrealestate.ca/',
		'address' => '18831 111 Ave.',
		'address_2' => '',
		'city' => 'Edmonton',
		'state' => 'AB',
		'full_state' => 'Alberta',
		'country' => 'Canada',
		'market' => 'Edmonton',
		'market_2' => '',
		'postal_code' => 'T5S 2X4',
		'phone' => 'Direct: (780) 486-8655',
		'phone_2' => 'Cell: (780) 441-5576',
		'phone_3' => '',
		'wide_contact_image' => false,
		'contact_name' => 'Sheldon Johnston',
		'contact_profile_link' => '',
		'contact_big_profile_link' => '',
		'contact_big_profile_link_text' => '',
		'contact_title' => 'Broker/Owner',
		'contact_dre_num' => '',
		'contact_quote' => '',
		'contact_email' => 'sheldon@livrealestate.ca',
		'contact_facebook' => '',
		'contact_twitter' => '',
		'contact_instagram' => '',
		'contact_pinterest' => '',
		'contact_linkedin' => '',
		'contact_youtube' => '',
		'contact_phone' => '',
		'contact_email_2' => '',
		'contact_2_facebook' => '',
		'contact_2_twitter' => '',
		'contact_2_instagram' => '',
		'contact_2_pinterest' => '',
		'contact_2_linkedin' => '',
		'contact_2_youtube' => '',
		'contact_phone_2' => '',
		'contact_website' => '',
		'contact_name_2' => '',
		'contact_profile_link_2' => '',
		'contact_big_profile_link_2' => '',
		'contact_big_profile_link_text_2' => '',
		'contact_title_2' => '',
		'contact_dre_num_2' => '',
		'contact_email_3' => '',
		'contact_name_3' => '',
		'contact_title_3' => '',
		'contact_dre_num_3' => '',
		'contact_phone_3' => '',
		'contact_3_facebook' => '',
		'contact_3_twitter' => '',
		'contact_3_instagram' => '',
		'contact_3_pinterest' => '',
		'contact_3_linkedin' => '',
		'contact_3_youtube' => '',
		'image_filename' => '210.jpg',
		'logo_filename' => '210.jpg',
		'contact_image_filename' => '210.jpg',
		'all_properties_link_image_filename' => '210.jpg',
		'all_properties_link' => 'http://www.livrealestate.ca/our-listings/',
		'video_embed_code' => '',
		'contact_video_embed_code' => '',
		'meta_title' => 'Edmonton Real Estate⎜LIV Real Estate⎜Leverage Global Partners',
		'meta_description' => 'LIV Real Estate is the exclusive representative for Leverage Global Partners in Edmonton, AB, Canada.',
		'meta_keywords' => 'LIV Real Estate, Edmonton Real Estate, Spruce Grove Real Estate, St. Albert Real Estate, Sherwood Park Real Estate, Devon Real Estate, Stony Plain Real Estate, Leduc Real Estate, Beaumont Real Estate, Fort Saskatchewan Real Estate, Alberta Real Estate, Sheldon Johnston, Leverage Global Partners',
		'login_message_counter' => '1',
		'stats_module_1_type' => '',
		'stats_module_1_value' => '',
		'stats_module_2_type' => '',
		'stats_module_2_value' => '',
		'stats_module_3_type' => '',
		'stats_module_3_value' => '',
		'last_activity_email_sent' => '0000-00-00 00:00:00',
		'converted' => true,
		'created' => '2015-06-25 09:59:11',
		'modified' => '2016-04-14 10:57:52',
		'dre_num' => '012345',
		'uri' => '/brokerage-detail/210/liv-real-estate',
		'website_short' => 'www.livrealestate.ca',
		'name_with_location' => 'Liv Real Estate'
	),
	'Logo' => array(
		'id' => '2851',
		'model' => 'Brokerage',
		'model_id' => '210',
		'tag' => 'Logo',
		'name' => '210.jpg',
		'type' => 'image/jpg',
		'size' => '211602',
		'uri' => '/assets/2851.jpg',
		'order' => '0',
		'created' => '2016-03-30 11:44:44',
		'modified' => '2016-04-14 10:57:52'
	),
	'MainImage' => array(
		'id' => '2850',
		'model' => 'Brokerage',
		'model_id' => '210',
		'tag' => 'MainImage',
		'name' => '210.jpg',
		'type' => 'image/jpg',
		'size' => '3570580',
		'uri' => '/assets/2850.jpg',
		'order' => '0',
		'created' => '2016-03-30 11:44:43',
		'modified' => '2016-04-14 10:57:52'
	),
	'ContactImage' => array(
		'id' => '2852',
		'model' => 'Brokerage',
		'model_id' => '210',
		'tag' => 'ContactImage',
		'name' => '210.jpg',
		'type' => 'image/jpg',
		'size' => '83326',
		'uri' => '/assets/2852.jpg',
		'order' => '0',
		'created' => '2016-03-30 11:44:44',
		'modified' => '2016-04-14 10:57:52'
	),
	'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 | Liv Real Estate

Properties / Liv Real Estate

Liv Real Estate

Broker/Owner: Sheldon Johnston
Direct: (780) 486-8655

License #: 012345

Visit Website

North America's most northern major city will surprise you!

Liv Real Estate is the exclusive representative for Leverage Global Partners in Edmonton, Spruce Grove, St. Albert, Sherwood Park, Devon, Stony Plain, Leduc, Beaumont, and Fort Saskatchewan, Alberta, Canada.

Selling your home is about you, and should feel as familiar and safe as your backyard. We believe in making our clients savvy, so they are part of the conversation when it comes to aligning big decisions with the best move.

Liv offers a fresh perspective to real estate with a new outlook on dotted lines and traditional relationships between agents and homeowners. We take the artifice out of the transaction and the bus bench out of the relationship. We are homeowners too, and we stand behind a transparent process.

When it’s time to give up the growth charts notched into your walls, or find familiar creaky floorboards in new surroundings, Liv is ready for you. We don’t want to be famous, we just want you to Love Where You Liv, and help you make sense of moving in, or moving on.

This is how real estate really is.

Connect With Us

www.livrealestate.ca

Read Our Profile

Meet LIV REAL ESTATE: Edmonton, AB, Canada

LeverageRE

Get to know Liv Real Estate, the exclusive representative for Leverage Global Partners in Edmonton, Spruce Grove, St. Albert, Sherwood Park, Devon, Stony Plain, Leduc, Beaumont, and Fort Saskatchewan, Alberta, Canada.

Partner:
Liv Real Estate

Liv Real Estate 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)
  0210
  1liv-real-estate
- 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: 12 ms
Total Queries: 15 queries

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

Query Explain:

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

====

Timer

Memory

Peak Memory Use 11.67 MB

Message	Memory use
Component initialization	2.93 MB
Controller action start	3.86 MB
Controller render start	6.14 MB
View render complete	6.63 MB

Timers

Total Request Time: 223 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	36.15
Event: Controller.initialize	5.22
Event: Controller.startup	2.50
Controller action	60.96
Event: Controller.beforeRender	11.44
» Processing toolbar data	11.35
Rendering View	80.44
» Event: View.beforeRender	0.48
» Rendering APP/View/Brokerages/view.ctp	0.98
» » Rendering APP/View/Elements/article_list.ctp	0.17
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.20
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	78.20
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)
 id45
 parent_id9
 brokerage_id214
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameTruckee, Lake Tahoe, CA, USA
 short_nameTruckee, Lake Tahoe, CA, USA
 group_index
 latitude39.327961
 longitude-120.183250
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 12:48:14
 modified2016-04-04 12:48:14
 timezoneAmerica/Los_Angeles
 population16000
 uri/locations/view/45/truckee-lake-tahoe-ca-usa
 tile_nameTruckee, Lake Tahoe, CA, USA
 Brokerage(array)
 id214
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2508245
 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
 nameTahoe Mountain Realty
 broker_of_record_name
 short_nameTahoe Mountain Realty
 usernameTahoeMountainRealty
 password4cef6eba416704066d3a8b841f2c8f2c4c322fea
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionTahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, Northstar, Mountainside at Northstar, Lahontan, Schaffer's Mill, Old Greenwood, and Gray's Crossing, CA, USA. They are the leading brokerage for high end boutique luxury real estate with expertise in the most sought after resort communities and Tahoe lakefront properties in the North Tahoe region. TAHOE MARKET EXPERTS With a team of over 20 real estate professionals who love living the Tahoe life and enjoy helping others find their Tahoe dream, TMR is pleased to help you and your family with all your Tahoe real estate needs. Our successful sales history begins with our absolute focus on client service and includes many market advantages, such as, our high-traffic sales galleries in The Village at Northstar, The Ritz-Carlton, Gray's Crossing and Old Greenwood, the area’s largest and most productive database of prospective buyers and data driven marketing programs.
 communitiesTruckee Northstar Mountainside at Northstar Lahontan Schaffer's Mill Old Greenwood Gray's Crossing
 websitehttp://www.tmrrealestate.com/
 address3001 Northstar Drive Suite 100
 address_2PO Box 3757
 cityTruckee
 stateCA
 full_stateCalifornia
 countryUSA
 marketTruckee, Lake Tahoe
 market_2
 postal_code96160
 phone(530) 550-2000
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTahoe Market Experts
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-tahoe-mountain-realty/
 contact_big_profile_link_textMeet The Team at Tahoe Mountain Realty
 contact_titleLuxury Real Estate Professionals
 contact_dre_num
 contact_quoteWe invite you to contact us about Truckee, Lake Tahoe real estate
 contact_emailExpert@tahoemountainrealty.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_filename214.jpg
 logo_filename214.png
 contact_image_filename214.jpg
 all_properties_link_image_filename214.jpg
 all_properties_linkhttp://tahoemountainrealty.idxbroker.com/idx/featured
 video_embed_code
 contact_video_embed_code
 meta_titleTruckee Real Estate⎜Tahoe Mountain Realty⎜Leverage Global Partners
 meta_descriptionTahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, CA, USA.
 meta_keywordsTahoe Mountain Realty, Truckee Real Estate, Northstar Real Estate, Mountainside at Northstar Real Estate, Lahontan Real Estate, Schaffer's Mill Real Estate, Old Greenwood Real Estate, Gray's Crossing Real Estate, California Real Estate, Leverage Global Partners, Jeff Brown
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-07-21 10:20:40
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/214/tahoe-mountain-realty
 website_shortwww.tmrrealestate.com
 name_with_locationTahoe Mountain Realty
 Image(array)
 id2974
 modelLocation
 model_id45
 tagImage
 nameTruckee.jpg
 typeimage/jpeg
 size132695
 uri/assets/2974.jpg
 order0
 created2016-04-04 12:48:06
 modified2016-04-04 12:48:14
 1(array)
 Location(array)
 id21
 parent_id4
 brokerage_id7
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameLondon, United Kingdom
 short_nameLondon, United Kingdom
 group_index
 latitude51.507351
 longitude-0.127758
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionStylish London offers something for everyone at any time of the year.
 long_descriptionLondon has some of the world’s most stunning architecture and more history than imaginable. From grand period buildings and townhouses, elegant apartments and modern penthouses there is a style of property for every taste. A secure city made up of a series of small districts, London has world-famous shopping areas with exclusive luxury brand designer stores and each of these charming neighbourhoods in this diverse city offers a wealth of cafes, bars and restaurants for residents and visitors to choose from. And with nearly 40% of space taken up with public parks and gardens, London is one of the greenest cities in the world eclipsing many other global cities including Paris, New York and Tokyo.
 created2016-04-04 10:56:57
 modified2016-04-14 15:00:04
 timezoneEurope/London
 population8000000
 uri/locations/view/21/london-united-kingdom
 tile_nameLondon, United Kingdom
 Brokerage(array)
 id7
 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_id3
 WOEID44418
 timezoneEurope/London
 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
 nameBeauchamp Estates
 broker_of_record_name
 short_nameBeauchamp Estates
 usernameBeauchampLondon
 passworddf350318b621cfd44c11f9e03cb52e3b63899384
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_inBeauchamp Estates is the exclusive representative for Leverage Global Partners in London, England.
 short_description
 descriptionBeauchamp Estates is a two-partner, privately owned firm with some thirty years of experience in both the residential and commercial markets, specializing in particular in acquiring and selling prime central London houses, flats and developments. The two partners have worked together since the late 1970’s giving them a sense of continuity rarely experienced by our competitors. Our enthusiasm and dedication has resulted in a client list that reads like a who’s who of clients, applicants and developers alike. With an established international client base, we have successfully opened offices in <a href="../../../brokerage-detail/11/Beauchamp-Estates" target="_blank">Cannes in the South of France</a>, <a href="../../../brokerage-detail/10/Beauchamp-Estates" target="_blank">Mykonos, Greece</a>, and <a href="../../../brokerage-detail/12/Beauchamp-Estates" target="_blank">Florence, Italy</a> and have been able to consolidate and expand our business through these offices.
 communitiesMayfair England United Kingdom UK London England United Kingdom UK Knightsbridge England United Kingdom UK Belgravia England United Kingdom UK Chelsea England United Kingdom UK Regent's Park England United Kingdom UK South Kensington England United Kingdom UK Notting Hill England United Kingdom UK St. Johns Wood England United Kingdom UK Primrose Hill England United Kingdom UK Hampstead England United Kingdom UK
 websitehttp://www.beauchamp.com/
 address24 Curzon Street
 address_2
 cityLondon
 state
 full_state
 countryUnited Kingdom
 marketLondon
 market_2
 postal_codeW1J 7TF
 phone+44 (0) 20 7499 7722
 phone_2+44 (0) 20 7722 9793
 phone_3
 wide_contact_image(false)
 contact_nameGary Hersham
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/gary-hersham-beauchamp-estates-london-england/
 contact_big_profile_link_text
 contact_titleManaging Director/Partner
 contact_dre_num
 contact_quote
 contact_emailgary@beauchamp.co.uk
 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_filename7.jpg
 logo_filename7.jpg
 contact_image_filename7.JPG
 all_properties_link_image_filename7.jpg
 all_properties_linkhttp://www.beauchamp.co.uk/en/properties/category-sales/
 video_embed_code
 contact_video_embed_code
 meta_titleLondon Real Estate | Beauchamp Estates | Leverage Global Partners
 meta_descriptionBeauchamp Estates is a London real estate brokerage specializing in acquiring and selling prime central London houses, flats and developments. Beauchamp Estates is the exclusive representation in London, England for Leverage Global Partners.
 meta_keywordsbeauchamp estates, london real estate, london england real estate, leverage global partners, gary hersham
 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-03-19 14:40:02
 modified2021-07-28 11:19:52
 dre_num012345
 uri/brokerage-detail/7/beauchamp-estates
 website_shortwww.beauchamp.com
 name_with_locationBeauchamp Estates
 Image(array)
 id2948
 modelLocation
 model_id21
 tagImage
 nameLondon.jpg
 typeimage/jpeg
 size148084
 uri/assets/2948.jpg
 order0
 created2016-04-04 10:56:10
 modified2016-04-14 15:00:05
 2(array)
 Location(array)
 id83
 parent_id9
 brokerage_id168
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameNewport Beach, CA, USA
 short_nameNewport Beach, CA, USA
 group_index
 latitude33.599182
 longitude-117.872169
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionCelebrated as an alluring destination, Orange County’s beauty is more than skin deep.
 long_descriptionFrom sunset bike rides along the beach on a warm, summer evening to a quick winter weekend adventure in the mountains. From the alluring artwork of the hottest artists displayed in Laguna Beach, to the Village of Corona del Mar which offers amazing shopping in their seaside boutiques, to the historical architecture of Old Towne Orange and the history of US Presidents in Yorba Linda. Whether you choose a cozy beach bungalow or a custom estate built for a celebrity, there is a place here for everyone to call home. Known the world over as an alluring travel destination, the locals who are lucky enough to call Orange County “home” know that the beauty here is more than skin deep.
 created2016-04-05 10:17:09
 modified2016-04-18 10:38:04
 timezoneAmerica/Los_Angeles
 population3500000
 uri/locations/view/83/newport-beach-ca-usa
 tile_nameNewport Beach, CA, USA
 Brokerage(array)
 id168
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID23417205
 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
 nameThe Boutique Real Estate Group
 broker_of_record_name
 short_nameThe Boutique Real Estate Group
 usernameTheBoutiqueRealEstate
 password01759fcc62fbf8022ef42c08f544e99731e7b5f6
 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
 descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, Corona Del Mar, Balboa Island, Newport Coast, Huntington Beach, Sunset Beach, CA, USA. The Boutique Real Estate Group is a boutique real estate brokerage founded in Orange County, CA, that focuses on brilliant design, beautiful marketing & luxury services and will be opening multiple offices throughout the Southern California Luxury Real Estate Market. The Boutique has created a culture that spurs collaboration, technology and social media with a unique marketing approach. Our story goes a little something like this. Beautiful design evokes emotion. Emotion stirs the soul and creates a connection between client, agent and the home buying & selling process. The Boutique Real Estate Group has invested heavily in bringing all aspects of the real estate experience completely in-house. From custom design, professional staging, amazing photography, cinematography & film production, social media to technology, internet optimization & cloud based transaction management. This not only provides The Boutique with complete control of the design, marketing & technology of luxury real estate but also gives us the look & feel of a true boutique marketing agency. This design & tech-forward approach has earned The Boutique Real Estate Group accolades & awards worldwide. 2015 Inman News Innovator Award for Most Innovative Technology | Nominee 2015 Top 33 People Changing The Real Estate Industry 2014 Best Real Estate Video of The Year 2014 Inman News Innovator Award for Most Innovative Real Estate Agent | Nominee 2014 Next Generation Real Estate Brokerage 2014 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 20 Real Estate Videos in The USA
 communitiesNewport Beach Corona Del Mar Balboa Island Newport Coast Huntington Beach Sunset Beach
 websitehttp://www.theboutiquere.com/
 address3653 E. Coast Hwy
 address_2
 cityCorona Del Mar
 stateCA
 full_stateCalifornia
 countryUSA
 marketNewport Beach
 market_2
 postal_code
 phone(949) 612-2535
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameRaj Qsar
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-raj-qsar-the-boutique-real-estate-group/
 contact_big_profile_link_textMeet Raj
 contact_titlePrincipal/Owner
 contact_dre_num
 contact_quote
 contact_emailraj@theboutiquere.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_filename168.jpg
 logo_filename168.jpg
 contact_image_filename168.jpg
 all_properties_link_image_filename168.jpg
 all_properties_linkhttp://www.theboutiquere.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/xQ9ZyzIQ-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNewport Beach Real Estate⎜The Boutique Real Estate Group⎜Leverage Global Partners
 meta_descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, CA, USA.
 meta_keywordsThe Boutique Real Estate Group, Raj Qsar, Newport Beach Real Estate, Corona Del Mar Real Estate, Balboa Island Real Estate, Newport Coast Real Estate, Huntington Beach Real Estate, Sunset Beach Real Estate, California Real Estate, Leverage Global Partners
 login_message_counter2
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-10-28 16:37:40
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/168/the-boutique-real-estate-group
 website_shortwww.theboutiquere.com
 name_with_locationThe Boutique Real Estate Group
 Image(array)
 id3017
 modelLocation
 model_id83
 tagImage
 name39922990_aerial-beach.jpg
 typeimage/jpeg
 size14013480
 uri/assets/3017.jpg
 order0
 created2016-04-05 10:15:06
 modified2016-04-18 10:38:04
 3(array)
 Location(array)
 id28
 parent_id9
 brokerage_id142
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameMalibu, CA, USA
 short_nameMalibu, CA, USA
 group_index
 latitude34.025921
 longitude-118.779755
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionFamed for its beaches and cool surfer style, Malibu’s beauty is in a class by itself.
 long_descriptionThis idyllic beach community with 27 miles of scenic coastline beckons visitors from around the world and its wooded hills and canyons offer a chance to reconnect with nature. Despite its worldwide renown, Malibu still offers the feel of a small town where people know and care about each other. Known locally as the 'Bu, much of Malibu is arrayed along a long curving stretch of Pacific Coast Highway. Malibu real estate is all about the beach. Many of the area's most expensive properties sit directly on the beach with Carbon Beach being especially known for beautiful and very expensive real estate. Malibu real estate also extends into the surrounding hills and canyons where properties often have larger lots and feature ocean views.
 created2016-04-04 11:50:57
 modified2016-04-12 16:13:24
 timezoneAmerica/Los_Angeles
 population12800
 uri/locations/view/28/malibu-ca-usa
 tile_nameMalibu, CA, USA
 Brokerage(array)
 id142
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties12
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties2
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id0
 WOEID2444458
 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
 namePartners Trust Real Estate Brokerage and Acquisitions
 broker_of_record_name
 short_namePartners Trust Real Estate
 usernamePartnersTrustMalibu
 password8bf407910e1841b6dabffb27fe55be8fe9a8383e
 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
 descriptionPartners Trust is the exclusive representative for Leverage Global Partners in Malibu, California, USA. We are dedicated to being the finest real estate brokerage in Los Angeles. At Partners Trust, our objective is to present our clients with the most professional, successful and ethical real estate associates in the business and to represent our clients with care, confidentiality and the utmost attention to service. We believe we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market. We begin with a commodity that is hard-earned and easily lost: TRUST. Without the daily demonstration and commitment to uphold principles, a company’s mission statement is simply words on a page and nothing more. Partners Trust has adopted a mission statement that each Associate and staff member must sign to in order to participate with the Company, which articulates the core philosophy and culture of the Company. The Partners Trust founders utilized their extensive experience and resources to create a Company that is both unique and beneficial for those willing to commit to the rigorous standards that have been set forth. The Company’s intention is to empower each member of its sales force each and every step of the way. Partners Trust has additional office locations in <a href="../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../brokerage-detail/5/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Pasadena</a> and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai</a>.
 communitiesMalibu
 websitehttp://www.thepartnerstrust.com/home
 address23410 Civic Center Way
 address_2Suite C1
 cityMalibu
 stateCA
 full_stateCalifornia
 countryUSA
 market
 market_2
 postal_code90265
 phoneOffice: (310) 818-5752
 phone_2Cell: (424) 235-0143
 phone_3
 wide_contact_image(false)
 contact_nameSarah Kosasky
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleFounding Partner Malibu and Manager
 contact_dre_num
 contact_quote
 contact_emailSarah.Kosasky@thepartnerstrust.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_filename142.jpg
 logo_filename142.png
 contact_image_filename142.jpeg
 all_properties_link_image_filename142.jpg
 all_properties_linkhttp://www.thepartnerstrust.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleMalibu Real Estate | Partners Trust | Leverage Global Partners
 meta_descriptionPartners Trust is the exclusive representative for Leverage Global Partners in Malibu, CA, USA.
 meta_keywords29138 Pacific Coast Highway, Partners Trust, Leverage Global Partners, Malibu real estate, california 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-07-18 15:34:11
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/142/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortwww.thepartnerstrust.com/home
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 Image(array)
 id2957
 modelLocation
 model_id28
 tagImage
 nameMalibu.jpg
 typeimage/jpeg
 size152789
 uri/assets/2957.jpg
 order0
 created2016-04-04 11:49:43
 modified2016-04-12 16:13:24
- sidebar_articles(array)
 0(array)
 Article(array)
 id490
 modelLocation
 model_id152
 archived(false)
 medium_featured(false)
 large_featured(false)
 titleLocation: Vancouver
 authorLeverageRE
 date2016-03-29
 lead_inThe unspoiled natural beauty of Vancouver frequently ends up permanently seducing unsuspecting visitors to this coastal city in British Columbia. Home to the busiest and largest port in Canada, the city is just behind Toronto in diversity. And, at 1,100 square miles with a population of over 600,000, it is the most densely populated Canadian municipality.
 body While contemporary architecture calls the shots on this city's skyline, the former downtown retains historical charm with Edwardian buildings erected in the early 20th century as some of the tallest buildings of their time. Ethnic diversity combined with proximity to the Pacific makes for a food lover's paradise, and more than 5,000 restaurants dish up an eclectic mix of international cuisine. This spring, the city gave nearly 600 restaurants permission to keep outside patios open until midnight-allowing an extra hour to enjoy warm-weather nights. Besides striking natural beauty, world-class cuisine, and rich cultural offerings, here are a few more reasons to love the city: <a href="http://theloden.com/" target="_blank">LODEN HOTEL</a> This boutique hotel profits from both the ocean promenade and mountain views in the trendy Coal Harbour neighborhood. Complementary bikes make exploring the Vancouver Seawall-the 14-mile path on the city's water- front-a breeze. <img class="aligncenter wp-image-13044 pure-img" src="/assets/3357.png" alt="Screen Shot 2016-03-29 at 4.50.15 PM" width="671" height="396" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.50.15-PM-300x177.png 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.50.15-PM-768x453.png 768w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.50.15-PM-585x345.png 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.50.15-PM.png 1350w" sizes="(max-width: 671px) 100vw, 671px"> <a href="http://www.hawksworthrestaurant.com/about/our-people/david-hawksworth/" target="_blank">HAWKSWORTH RESTAURANT</a> Foodies book months in advance at star chef David Hawksworth's downtown restaurant. <img class="aligncenter wp-image-13043 pure-img" src="/assets/3358.png" alt="Screen Shot 2016-03-29 at 4.49.32 PM" width="652" height="488" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.49.32-PM-300x225.png 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.49.32-PM-768x575.png 768w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.49.32-PM-585x438.png 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.49.32-PM-80x60.png 80w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.49.32-PM.png 940w" sizes="(max-width: 652px) 100vw, 652px"> <a href="http://vancouver.ca/parks-recreation-culture/stanley-park.aspx" target="_blank">STANLEY PARK</a> Some 17 miles of trails wind through North America's third-largest park, founded in 1888. <img class="aligncenter wp-image-13048 pure-img" src="/assets/3359.png" alt="Screen Shot 2016-03-29 at 4.54.33 PM" width="601" height="450" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.54.33-PM-768x574.png 768w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.54.33-PM-585x438.png 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.54.33-PM-80x60.png 80w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.54.33-PM.png 1095w" sizes="(max-width: 601px) 100vw, 601px"> <a href="http://www.granville-eyeland.com/" target="_blank">GRANVILLE EYELAND FRAMEMAKERS</a> Canada's only custom handmade frame maker creates spectacles from materials such as gold, silver, antique tortoiseshell, water buffalo horn, and wood. <img class="aligncenter wp-image-13047 pure-img" src="/assets/3360.png" alt="Screen Shot 2016-03-29 at 4.54.01 PM" width="465" height="445" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.54.01-PM-300x287.png 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.54.01-PM-768x735.png 768w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.54.01-PM-585x560.png 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.54.01-PM.png 817w" sizes="(max-width: 465px) 100vw, 465px"> <a href="http://www.litchfieldtheshop.com/" target="_blank">LITCHFIELD</a> A curated selection of home goods and fashion fi reflect the taste of owner Jonathon Litchfield, who is heavily influenced by a childhood spent in Japan. <img class="aligncenter wp-image-13045 pure-img" src="/assets/3361.png" alt="Screen Shot 2016-03-29 at 4.51.00 PM" width="575" height="380" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.51.00-PM-300x198.png 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.51.00-PM-768x507.png 768w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.51.00-PM-585x386.png 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.51.00-PM.png 887w" sizes="(max-width: 575px) 100vw, 575px"> <a href="http://www.rosewoodhotels.com/en/hotel-georgia-vancouver" target="_blank">ROSEWOOD HOTEL GEORGIA</a> Legend has it Marlene Dietrich once arrived with 40 suitcases at this downtown hotel, which opened in 1927. A 2011 restoration integrated the latest technology with the elegance of the Roaring Twenties. <img class="aligncenter wp-image-13046 pure-img" src="/assets/3362.png" alt="Screen Shot 2016-03-29 at 4.52.58 PM" width="834" height="621" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.52.58-PM-300x223.png 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.52.58-PM-768x572.png 768w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.52.58-PM-585x435.png 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-29-at-4.52.58-PM.png 970w" sizes="(max-width: 834px) 100vw, 834px">
 vimeo_id
 created2016-04-05 14:35:23
 modified2016-04-05 14:41:07
 uri/articles/view/490/location-vancouver
 Image(array)
 0(array)
 id3363
 modelArticle
 model_id490
 tagImage
 nameScreen-Shot-2016-03-29-at-4.55.53-PM.png
 typeimage/png
 size3367055
 uri/assets/3363.png
 order0
 created2016-04-05 14:35:25
 modified2016-04-05 14:35:26
 1(array)
 Article(array)
 id462
 modelArticle
 model_id0
 archived(false)
 medium_featured(true)
 large_featured(false)
 titleShop the Store: Miele
 authorLeverageRE
 date2016-03-17
 lead_inThe oldest family-owned appliance company in the world, Miele manufactures its household products at its factories in Germany, where each item is thoroughly tested before it's shipped to the buyer. Long praised for its quiet and thorough yet gentle dishwasher-the only dishwasher that stemware company Riedel recommends to wash its notoriously delicate glasses-Miele has newer appliances that equally impress: A refrigerator with Wi-Fi alerts homeowners of temperature drops, and a combi-steam oven perfectly cooks everything from fish and desserts to oatmeal and eggs, nearly omitting the need for a range. Each product can be viewed, and many of them tested, at the company's design centers, which offer cooking demonstrations as well as the opportunity for potential buyers to bring in a load of laundry to test.
 body<a href="http://www.mieleusa.com/Product/List/27" target="_blank"><img class="aligncenter wp-image-12621 pure-img" src="/assets/3190.jpg" /></a> <h3><a href="http://www.mieleusa.com/Product/List/27" target="_blank">WINE STORAGE</a></h3> Proprietary technology that alerts of sudden temperature drops is just one of the under-counter unit's compelling features. Also appealing: 38-bottle capacity; a vibration-free compressor; and three full- extension shelves. $2,945 <a href="http://www.mieleusa.com/Product/List/21" target="_blank"><img class="aligncenter wp-image-12622 pure-img" src="/assets/3191.jpg" /></a> <h3><a href="http://www.mieleusa.com/Product/List/21" target="_blank">COFFEE SYSTEM</a></h3> Like a master barista, the unit grinds beans, froths milk, and makes a perfect cup of coffee, espresso, latte, or cap- puccino at the touch of a button. $3,349
 vimeo_id
 created2016-04-05 14:31:49
 modified2016-04-14 12:24:59
 uri/articles/view/462/shop-the-store-miele
 Image(array)
 0(array)
 id3192
 modelArticle
 model_id462
 tagImage
 namemiele.jpg
 typeimage/jpg
 size161660
 uri/assets/3192.jpg
 order0
 created2016-04-05 14:31:49
 modified2016-04-14 12:24:59
 2(array)
 Article(array)
 id482
 modelArticle
 model_id0
 archived(false)
 medium_featured(true)
 large_featured(true)
 titleStyle File: Modern Mountain Style
 authorLeverageRE
 date2016-03-29
 lead_inWith expansive vistas, sprawling forests, and towering mountain peaks, the western slopes of the Rocky Mountains create a natural backdrop of serenity and grandeur. Famous for its refuge within a box canyon of 13,000-foot peaks in the San Juan Mountains, Telluride is an idyllic community that has served as a rustic mountain retreat for vacationers and permanent settlers alike. It began as a mining town for gold and silver during the late 19th century and later struck gold in the form of a major ski resort in the 1970s.
 body<img class="aligncenter wp-image-12976 pure-img" src="/assets/3320.png" /> But Telluride is more than an old mining town. In fact, with its majestic beauty, its tight-knit community, and a flourish of cultural attractions from visiting ballet companies to its annual Bluegrass Festival and the exclusive star-studded Telluride Film Festival, the town has gained a reputation for being one of the best-kept secrets on the western slopes of the Continental Divide. <img class="aligncenter wp-image-12975 pure-img" src="/assets/3321.png" /> In such an inspiring environment of natural beauty, it's no wonder that the overarching theme for Telluride design draws extensively on the aesthetics of nature. But while mountain living has long garnered a reputation for showcasing heavy stained timber with large rock and a darker color palette of greens, maroons, and browns, Telluride showcases a brighter side to mountain style that blends lighter palettes and natural components that invite nature indoors. "We're seeing a significant trend into what has become 'mountain modern.' Details are not as heavy. They're lighter and there's a lot more open air," says local real estate broker Brian O'Neill of Telluride Properties. "Things are more vibrant, festive, and fresh, which may have to do with the youthful, active demographic of the town." <img class="aligncenter wp-image-12977 pure-img" src="/assets/3322.png" /> In keeping with the town's mining heritage, plenty of iron and steel accents appear throughout the architecture and interior design, but in a much more subtle and refined way. Local interior design firm Tweed Interiors has focused its work toward modern and minimalist style. Business partners Robyn Shaw and Victoria Crawford blend both contemporary and antique elements to display originality, and they love to use white for a clean look but emphasize the importance of color to bring life to a space. <img class="aligncenter wp-image-12978 pure-img" src="/assets/3323.png" /> "We steer away from the heavy Western look and focus more on native prints, clean lines, and spacious rooms. A lot of our clients are younger families who want lighter spaces or people looking to freshen up what they already have. So we try to start basic and clean and then add layers minimally," says Crawford. She adds that there's a benefit to hiring a designer in Telluride-they'll know how to get hard-to-find items in the isolated small town. "We'll use a number of things from larger retailers, but for unique local finds, you have to know where to go."
 vimeo_id
 created2016-04-05 14:35:04
 modified2016-04-11 16:57:15
 uri/articles/view/482/style-file-modern-mountain-style
 Image(array)
 0(array)
 id3324
 modelArticle
 model_id482
 tagImage
 nameScreen-Shot-2016-03-29-at-12.23.35-PM.png
 typeimage/png
 size2587934
 uri/assets/3324.png
 order0
 created2016-04-05 14:35:06
 modified2016-04-11 16:57:15
 3(array)
 Article(array)
 id479
 modelLocation
 model_id21
 archived(false)
 medium_featured(false)
 large_featured(true)
 titleLocation: London
 authorLeverageRE
 date2016-03-29
 lead_inLondon Calling! Synonymous with Big Ben, Westminster Abbey, double-decker buses, and the Royal Family, London is undoubtedly the most fascinating city in the United Kingdom. Home of Leverage Partner Beauchamp Estates, London is also the political, economic and cultural capital of England, offering thousands of historical and modern-day attractions.
 bodyIt is one of the world’s most visited cities, as well as being a global city steeped in arts, entertainment, media, fashion and finance. It boasts some 43 universities, and is culturally diverse, with more than 300 languages spoken in Greater London. The depth and array of what London has to offer is virtually unparalleled anywhere in the world! <img src="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-28-at-7.35.29-PM.png" /> BAT. The Marylebone Cricket Club was founded in St. John's Wood in 1787, launching England's national sport. There's no better place to learn about wickets and donkey drops than <a href="http://www.lords.org/" target="_blank">Lord's Cricket Ground</a>, which has a museum and hosts regular tours. <img class="aligncenter wp-image-12911 pure-img" src="/assets/3301.png" /> LET IT BE. <a href="http://www.abbeyroad.com/" target="_blank">Abbey Road Studios</a> was immortalized by the Beatles, but Paul Robeson recorded there as far back as 1931. Fab Four pilgrims can't tour inside, but they can take a picture at the famous zebra crossing that graced the Beatles album and post it on the live "Crossing Cam," or write their name on the wall in front of the building. PREEN. The High Street area is chocka-block with cool boutiques: hip French labels like <a href="http://www.thekooples.com/" target="_blank">The Kooples</a> and prêt-à-porter pioneer <a href="http://www.georges-rech.fr/" target="_blank">Georges Rech</a>, the designer brand retailer <a href="http://www.joseph-fashion.com/" target="_blank">Joseph</a> and one outpost of Nicky Kinnaird's beauty products empire, <a href="http://www.spacenk.com/" target="_blank">SpaceNK</a>. <img class="aligncenter wp-image-12910 pure-img" src="/assets/3302.png" /> STROLL. Primrose Hill Park is where the locals hang. Its views of London are un-paralleled, and the bucolic quietude of this green space distills the reason why people live here. <img class="aligncenter wp-image-12909 pure-img" src="/assets/3303.png" /> 
 vimeo_id
 created2016-04-05 14:34:59
 modified2016-04-11 16:51:49
 uri/articles/view/479/location-london
 Image(array)
 0(array)
 id3304
 modelArticle
 model_id479
 tagImage
 nameScreen-Shot-2016-03-28-at-7.36.18-PM.png
 typeimage/png
 size1989440
 uri/assets/3304.png
 order0
 created2016-04-05 14:35:00
 modified2016-04-11 16:51:49
- main_article(array)
 Article(array)
 id424
 modelBrokerage
 model_id210
 archived(false)
 medium_featured(true)
 large_featured(true)
 titleMeet LIV REAL ESTATE: Edmonton, AB, Canada
 authorLeverageRE
 date2015-11-13
 lead_inGet to know Liv Real Estate, the exclusive representative for Leverage Global Partners in Edmonton, Spruce Grove, St. Albert, Sherwood Park, Devon, Stony Plain, Leduc, Beaumont, and Fort Saskatchewan, Alberta, Canada.
 body <img class="aligncenter wp-image-11433 pure-img" src="/assets/2173.jpg" alt="Meet LIV REAL ESTATE: Edmonton, AB, Canada" width="819" height="466" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/LivRealEstate-300x171.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/LivRealEstate-585x333.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/LivRealEstate.jpg 3264w" sizes="(max-width: 819px) 100vw, 819px"> We wanted to have a brand that represented our values. One that was focused on how we would want to be treated as a customer and as an agent. We wanted to bring together a fun, collaborative, professional group of agents that get results by working hard, and doing it right. We are very committed to providing excellent customer service and to prove it we don’t have any sales awards, we only recognize exceptional customer service, leadership and community involvement. Sheldon Johnston: Early in my career I was motivated by numbers; every year I chased awards and achieved my goals, becoming one of the top producing agents in Canada. When I realized that my past clients weren’t coming back to me, I also realized that I needed to shift my focus; just because my numbers said I was awesome, didn’t mean that I was. From that point on my focus has been on my clients, and we only select agents to work at Liv that put their clients first. <img class="aligncenter wp-image-11431 pure-img" src="/assets/2174.jpg" alt="Meet LIV REAL ESTATE: Edmonton, AB, Canada" width="776" height="582" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/P9200085-300x225.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/P9200085-585x439.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/P9200085-80x60.jpg 80w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/P9200085.jpg 1200w" sizes="(max-width: 776px) 100vw, 776px"> Sara MacLennan: After five years at the Canadian head office for Coldwell Banker, showing agents and brokers how to use the power of the internet to grow their businesses, I decided to take my skills to the street and found my true calling running the brokerage with Sheldon. At Liv Real Estate, I focus on marketing (although I'm licensed to sell real estate) and business development for our brokerage. Today our small brokerage has some of the most visited real estate web sites in Edmonton, getting over 225,000 sessions and 3.5 million page views/month! It was the scariest and best decision I ever made. Online marketing is the core of our success. Our dominant position in search engine results has levelled the playing field between us and the big guys. Through inbound marketing we reach buyers and sellers when they are actually thinking about buying or selling a home. Being found is a huge asset to us in driving business to our agents and it allows us the pick of the best agents that fit our values. <img class="aligncenter wp-image-11430 pure-img" src="/assets/2175.jpg" alt="Meet LIV REAL ESTATE: Edmonton, AB, Canada" width="786" height="590" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/FolkFest-300x225.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/FolkFest-585x439.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/FolkFest-80x60.jpg 80w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/FolkFest.jpg 1200w" sizes="(max-width: 786px) 100vw, 786px"> Edmonton is an amazing city; there is so much going on here. Our incredible River Valley, which runs right through the city, is the largest urban park in North America (22 times bigger than Central Park in New York). We love hitting the trails in the River Valley on our mountain bikes – there’s over 1300 km of trails in Edmonton so you never run out of places to ride. Edmonton is big on festivals, we have about 300 every year including the largest and oldest “Fringe Festival” in North America, and an amazing Folk Festival held in the river valley with our city skyline as a backdrop. And then of course there is the “Ice District” a new downtown 25 acre sports and entertainment development centred around a new hockey arena (yes, hockey is a VERY big deal here). <img class="aligncenter wp-image-11434 pure-img" src="/assets/2176.jpg" alt="Meet LIV REAL ESTATE: Edmonton, AB, Canada" width="849" height="444" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/EREB-Awards1-300x157.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/EREB-Awards1-585x306.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/EREB-Awards1.jpg 1200w" sizes="(max-width: 849px) 100vw, 849px"> Leverage Global Partners is proud to have Sheldon Johnston, Sara MacLennan, and the team at Liv Real Estate as our partners in the network.
 vimeo_id
 created2016-02-25 14:14:31
 modified2016-04-05 14:41:07
 uri/articles/view/424/meet-liv-real-estate-edmonton-ab-canada
 flattened_topics(empty)
 ParentBrokerage(array)
 id210
 account_executive_id0
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID8676
 timezoneAmerica/Edmonton
 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
 nameLiv Real Estate
 broker_of_record_name
 short_nameLiv Real Estate
 usernameLivRealEstate
 password043b3ff63be4366b17c1e79d5a02160f148729ec
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionLiv Real Estate is the exclusive representative for Leverage Global Partners in Edmonton, Spruce Grove, St. Albert, Sherwood Park, Devon, Stony Plain, Leduc, Beaumont, and Fort Saskatchewan, Alberta, Canada. Selling your home is about you, and should feel as familiar and safe as your backyard. We believe in making our clients savvy, so they are part of the conversation when it comes to aligning big decisions with the best move. Liv offers a fresh perspective to real estate with a new outlook on dotted lines and traditional relationships between agents and homeowners. We take the artifice out of the transaction and the bus bench out of the relationship. We are homeowners too, and we stand behind a transparent process. When it’s time to give up the growth charts notched into your walls, or find familiar creaky floorboards in new surroundings, Liv is ready for you. We don’t want to be famous, we just want you to Love Where You Liv, and help you make sense of moving in, or moving on. This is how real estate really is.
 communitiesEdmonton Spruce Grove St. Albert Sherwood Park Devon Stony Plain Leduc Beaumont Fort Saskatchewan
 websitehttp://www.livrealestate.ca/
 address18831 111 Ave.
 address_2
 cityEdmonton
 stateAB
 full_stateAlberta
 countryCanada
 marketEdmonton
 market_2
 postal_codeT5S 2X4
 phoneDirect: (780) 486-8655
 phone_2Cell: (780) 441-5576
 phone_3
 wide_contact_image(false)
 contact_nameSheldon Johnston
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBroker/Owner
 contact_dre_num
 contact_quote
 contact_emailsheldon@livrealestate.ca
 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_filename210.jpg
 logo_filename210.jpg
 contact_image_filename210.jpg
 all_properties_link_image_filename210.jpg
 all_properties_linkhttp://www.livrealestate.ca/our-listings/
 video_embed_code
 contact_video_embed_code
 meta_titleEdmonton Real Estate⎜LIV Real Estate⎜Leverage Global Partners
 meta_descriptionLIV Real Estate is the exclusive representative for Leverage Global Partners in Edmonton, AB, Canada.
 meta_keywordsLIV Real Estate, Edmonton Real Estate, Spruce Grove Real Estate, St. Albert Real Estate, Sherwood Park Real Estate, Devon Real Estate, Stony Plain Real Estate, Leduc Real Estate, Beaumont Real Estate, Fort Saskatchewan Real Estate, Alberta Real Estate, Sheldon Johnston, Leverage Global Partners
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-06-25 09:59:11
 modified2016-04-14 10:57:52
 dre_num012345
 uri/brokerage-detail/210/liv-real-estate
 website_shortwww.livrealestate.ca
 name_with_locationLiv Real Estate
 ParentLocation(array)
 id(null)
 parent_id(null)
 brokerage_id(null)
 type(null)
 archived(null)
 use_as_topic(null)
 name(null)
 short_name(null)
 group_index(null)
 latitude(null)
 longitude(null)
 country_code(null)
 north(null)
 south(null)
 east(null)
 west(null)
 zoom(null)
 short_description(null)
 long_description(null)
 created(null)
 modified(null)
 timezone(null)
 population(null)
 Image(array)
 0(array)
 id2177
 modelArticle
 model_id424
 tagImage
 namePPSS-28.jpg
 typeimage/jpg
 size267876
 uri/assets/2177.jpg
 order0
 created2016-02-25 14:14:31
 modified2016-02-25 14:14:31
 Brokerage(empty)
 Location(empty)
 Property(empty)
 Topic(empty)
- locations(array)
 0(array)
 Location(array)
 id144
 parent_id9
 brokerage_id210
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameEdmonton, AB, Canada
 short_nameEdmonton, AB, Canada
 group_index
 latitude53.544388
 longitude-113.490929
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionNorth America's most northern major city will surprise you!
 long_descriptionEdmonton, the true gateway to the North, is the most northern City in North America, with over 1 million people. It's the passage from which countless abundant resources flow; natural gas, oil, coal, minerals and diamonds. National Geographic recognized it as a top summer destination to visit in 2015. Edmonton embraces Winter with Ice castles, festivals and freezeways. This northern jewel, is regarded as an amazing place to raise a family with exceptional schools, healthcare and Universities. Be dazzled by the northern lights, endless green space and immaculate campgrounds; including quick access to the rocky mountains. Edmonton will surprise you.
 created2016-04-07 16:22:59
 modified2016-04-14 10:59:09
 timezoneAmerica/Edmonton
 population875000
 uri/locations/view/144/edmonton-ab-canada
 tile_nameEdmonton, AB, Canada
 Brokerage(array)
 id210
 account_executive_id0
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID8676
 timezoneAmerica/Edmonton
 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
 nameLiv Real Estate
 broker_of_record_name
 short_nameLiv Real Estate
 usernameLivRealEstate
 password043b3ff63be4366b17c1e79d5a02160f148729ec
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionLiv Real Estate is the exclusive representative for Leverage Global Partners in Edmonton, Spruce Grove, St. Albert, Sherwood Park, Devon, Stony Plain, Leduc, Beaumont, and Fort Saskatchewan, Alberta, Canada. Selling your home is about you, and should feel as familiar and safe as your backyard. We believe in making our clients savvy, so they are part of the conversation when it comes to aligning big decisions with the best move. Liv offers a fresh perspective to real estate with a new outlook on dotted lines and traditional relationships between agents and homeowners. We take the artifice out of the transaction and the bus bench out of the relationship. We are homeowners too, and we stand behind a transparent process. When it’s time to give up the growth charts notched into your walls, or find familiar creaky floorboards in new surroundings, Liv is ready for you. We don’t want to be famous, we just want you to Love Where You Liv, and help you make sense of moving in, or moving on. This is how real estate really is.
 communitiesEdmonton Spruce Grove St. Albert Sherwood Park Devon Stony Plain Leduc Beaumont Fort Saskatchewan
 websitehttp://www.livrealestate.ca/
 address18831 111 Ave.
 address_2
 cityEdmonton
 stateAB
 full_stateAlberta
 countryCanada
 marketEdmonton
 market_2
 postal_codeT5S 2X4
 phoneDirect: (780) 486-8655
 phone_2Cell: (780) 441-5576
 phone_3
 wide_contact_image(false)
 contact_nameSheldon Johnston
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBroker/Owner
 contact_dre_num
 contact_quote
 contact_emailsheldon@livrealestate.ca
 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_filename210.jpg
 logo_filename210.jpg
 contact_image_filename210.jpg
 all_properties_link_image_filename210.jpg
 all_properties_linkhttp://www.livrealestate.ca/our-listings/
 video_embed_code
 contact_video_embed_code
 meta_titleEdmonton Real Estate⎜LIV Real Estate⎜Leverage Global Partners
 meta_descriptionLIV Real Estate is the exclusive representative for Leverage Global Partners in Edmonton, AB, Canada.
 meta_keywordsLIV Real Estate, Edmonton Real Estate, Spruce Grove Real Estate, St. Albert Real Estate, Sherwood Park Real Estate, Devon Real Estate, Stony Plain Real Estate, Leduc Real Estate, Beaumont Real Estate, Fort Saskatchewan Real Estate, Alberta Real Estate, Sheldon Johnston, Leverage Global Partners
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-06-25 09:59:11
 modified2016-04-14 10:57:52
 dre_num012345
 uri/brokerage-detail/210/liv-real-estate
 website_shortwww.livrealestate.ca
 name_with_locationLiv Real Estate
 Image(array)
 id10356
 modelLocation
 model_id144
 tagImage
 nameEdmonton.jpg
 typeimage/jpeg
 size167781
 uri/assets/10356.jpg
 order0
 created2016-04-07 16:20:14
 modified2016-04-14 10:59:09
- 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)
 brokerageLiv Real Estate, Edmonton
- brokerage(array)
 Brokerage(array)
 id210
 account_executive_id0
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID8676
 timezoneAmerica/Edmonton
 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
 nameLiv Real Estate
 broker_of_record_name
 short_nameLiv Real Estate
 usernameLivRealEstate
 password043b3ff63be4366b17c1e79d5a02160f148729ec
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionLiv Real Estate is the exclusive representative for Leverage Global Partners in Edmonton, Spruce Grove, St. Albert, Sherwood Park, Devon, Stony Plain, Leduc, Beaumont, and Fort Saskatchewan, Alberta, Canada. Selling your home is about you, and should feel as familiar and safe as your backyard. We believe in making our clients savvy, so they are part of the conversation when it comes to aligning big decisions with the best move. Liv offers a fresh perspective to real estate with a new outlook on dotted lines and traditional relationships between agents and homeowners. We take the artifice out of the transaction and the bus bench out of the relationship. We are homeowners too, and we stand behind a transparent process. When it’s time to give up the growth charts notched into your walls, or find familiar creaky floorboards in new surroundings, Liv is ready for you. We don’t want to be famous, we just want you to Love Where You Liv, and help you make sense of moving in, or moving on. This is how real estate really is.
 communitiesEdmonton Spruce Grove St. Albert Sherwood Park Devon Stony Plain Leduc Beaumont Fort Saskatchewan
 websitehttp://www.livrealestate.ca/
 address18831 111 Ave.
 address_2
 cityEdmonton
 stateAB
 full_stateAlberta
 countryCanada
 marketEdmonton
 market_2
 postal_codeT5S 2X4
 phoneDirect: (780) 486-8655
 phone_2Cell: (780) 441-5576
 phone_3
 wide_contact_image(false)
 contact_nameSheldon Johnston
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBroker/Owner
 contact_dre_num
 contact_quote
 contact_emailsheldon@livrealestate.ca
 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_filename210.jpg
 logo_filename210.jpg
 contact_image_filename210.jpg
 all_properties_link_image_filename210.jpg
 all_properties_linkhttp://www.livrealestate.ca/our-listings/
 video_embed_code
 contact_video_embed_code
 meta_titleEdmonton Real Estate⎜LIV Real Estate⎜Leverage Global Partners
 meta_descriptionLIV Real Estate is the exclusive representative for Leverage Global Partners in Edmonton, AB, Canada.
 meta_keywordsLIV Real Estate, Edmonton Real Estate, Spruce Grove Real Estate, St. Albert Real Estate, Sherwood Park Real Estate, Devon Real Estate, Stony Plain Real Estate, Leduc Real Estate, Beaumont Real Estate, Fort Saskatchewan Real Estate, Alberta Real Estate, Sheldon Johnston, Leverage Global Partners
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-06-25 09:59:11
 modified2016-04-14 10:57:52
 dre_num012345
 uri/brokerage-detail/210/liv-real-estate
 website_shortwww.livrealestate.ca
 name_with_locationLiv Real Estate
 Logo(array)
 id2851
 modelBrokerage
 model_id210
 tagLogo
 name210.jpg
 typeimage/jpg
 size211602
 uri/assets/2851.jpg
 order0
 created2016-03-30 11:44:44
 modified2016-04-14 10:57:52
 MainImage(array)
 id2850
 modelBrokerage
 model_id210
 tagMainImage
 name210.jpg
 typeimage/jpg
 size3570580
 uri/assets/2850.jpg
 order0
 created2016-03-30 11:44:43
 modified2016-04-14 10:57:52
 ContactImage(array)
 id2852
 modelBrokerage
 model_id210
 tagContactImage
 name210.jpg
 typeimage/jpg
 size83326
 uri/assets/2852.jpg
 order0
 created2016-03-30 11:44:44
 modified2016-04-14 10:57:52
 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/210/liv-real-estate
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/brokerage-detail/210/liv-real-estate
Remote Port	14460
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	162.159.115.41
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	a09df6eb7e1c2a83-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	aio9U0qFdFKg_eEneUt7dAAAAIc
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	aio9U0qFdFKg_eEneUt7dAAAAIc
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781153107.8827
Request Time	1781153107

====

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

Liv Real Estate

Connect With Us

Read Our Profile

Meet LIV REAL ESTATE: Edmonton, AB, Canada

Liv Real Estate Featured Properties

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 12 ms Total Queries: 15 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 12 ms
Total Queries: 15 queries