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 = '29'
$brokerage = array(
	'Brokerage' => array(
		'password' => '*****',
		'id' => '29',
		'account_executive_id' => '236',
		'archived' => false,
		'type' => 'brokerage',
		'hide_from_frontend' => false,
		'agent_brokerage_data_override' => false,
		'featured_development' => false,
		'membership_type' => 'Premium',
		'max_properties' => '8',
		'max_homepage_featured_by_member_properties' => '0',
		'featured_properties_sort_method' => 'manual',
		'lux_feed_mode' => 'StripeSubscription',
		'max_luxury_feed_properties' => '0',
		'membership_luxury_feed_properties' => '0',
		'can_participate_in_lux_feed_while_archived' => false,
		'full_training_video_access' => false,
		'country_id' => '1',
		'WOEID' => '2378426',
		'timezone' => 'US/Eastern',
		'luxury_feed_enrollment_mode' => 'manual',
		'luxury_feed_include_mlsidx_minimum_price' => '0',
		'luxury_feed_include_leverage_minimum_price' => '0',
		'digital_ad_contacts' => '',
		'add_agents_to_grr_auto_recipients' => true,
		'mlsidx_id' => '',
		'mlsidx_lux_autofeed' => false,
		'mlsidx_lux_autofeed_minimum_price' => '0',
		'mlsidx_logo_url' => '',
		'mlsidx_disclaimer' => '',
		'name' => 'HM Properties',
		'broker_of_record_name' => '',
		'short_name' => 'HM Properties',
		'username' => 'HMProperties',
		'password_reset_hash' => '',
		'monthly_invoice_amount' => null,
		'monthly_invoice_start_date' => '0000-00-00',
		'monthly_invoice_end_date' => '0000-00-00',
		'contract_filename' => '',
		'active' => true,
		'lead_in' => '',
		'short_description' => '',
		'description' => '<p>HM Properties is the exclusive representative for Leverage Global Partners in Mecklenburg County, Cabarrus County, Gaston County, Iredell County, Lincoln County, and Union County in Charlotte, North Carolina and Lancaster County and York County in South Carolina, USA.</p>
<p>HM Properties is a full-service residential real estate firm licensed in North and South Carolina, and serves the Charlotte region including upstate South Carolina. We also specialize in corporate relocation moves for individuals, businesses and relocation companies.</p>
<p>Founded in 2006 as a boutique real estate agency, HM Properties has quickly become one of the leading real estate companies in the Charlotte metro region. Our office is centrally located in the SouthPark area within Piedmont Town Center with over 55 top brokers and seven full-time employees including in-house Relocation and Marketing departments.</p>
<p>Valerie Mitchener, owner and Broker-in-Charge, has hand-picked top brokers in the region who possess exceptional customer service skills, experience and knowledge of our market, and a strong work ethic. "The success of HM Properties is due, in large part, because of our team concept which enables us to match each client with the agent(s) best qualified to assist them," states Mitchener. Our goal is to keep clients for life, so our commitment to you begins when we meet and never ends.</p>
<p>HM Properties specializes in the communities within Mecklenburg County, Cabarrus County, Gaston County, Iredell County, Lincoln County, and Union County in North Carolina; and Lancaster County and York County in South Carolina, including the areas of Lake Norman, Mountain Island Lake, and Lake Wylie.</p>
<p>Skyline Photo: Charlotte Photo</p>',
		'communities' => 'Charlotte North Carolina NC
Mecklenburg County North Carolina NC
Cabarrus County North Carolina NC
Gaston County North Carolina NC
Iredell County North Carolina NC
Lincoln County North Carolina NC
Union County North Carolina NC
Lancaster County South Carolina SC
York County South Carolina SC',
		'website' => 'http://www.hmproperties.com/index.html',
		'address' => '6857 Fairview Road',
		'address_2' => '',
		'city' => 'Charlotte',
		'state' => 'NC',
		'full_state' => 'North Carolina',
		'country' => 'USA',
		'market' => 'Charlotte',
		'market_2' => '',
		'postal_code' => '28210',
		'phone' => '(704) 552-9292',
		'phone_2' => '',
		'phone_3' => '',
		'wide_contact_image' => false,
		'contact_name' => 'Valerie Mitchener',
		'contact_profile_link' => '',
		'contact_big_profile_link' => 'http://www.leveragere.com/blog/meet-valerie-mitchener-president-of-hm-properties-charlotte-nc/',
		'contact_big_profile_link_text' => '',
		'contact_title' => 'Broker-in-Charge/Owner',
		'contact_dre_num' => '',
		'contact_quote' => '',
		'contact_email' => 'valerie@hmproperties.com',
		'contact_facebook' => '',
		'contact_twitter' => '',
		'contact_instagram' => '',
		'contact_pinterest' => '',
		'contact_linkedin' => '',
		'contact_youtube' => '',
		'contact_phone' => '',
		'contact_email_2' => '',
		'contact_2_facebook' => '',
		'contact_2_twitter' => '',
		'contact_2_instagram' => '',
		'contact_2_pinterest' => '',
		'contact_2_linkedin' => '',
		'contact_2_youtube' => '',
		'contact_phone_2' => '',
		'contact_website' => '',
		'contact_name_2' => '',
		'contact_profile_link_2' => '',
		'contact_big_profile_link_2' => '',
		'contact_big_profile_link_text_2' => '',
		'contact_title_2' => '',
		'contact_dre_num_2' => '',
		'contact_email_3' => '',
		'contact_name_3' => '',
		'contact_title_3' => '',
		'contact_dre_num_3' => '',
		'contact_phone_3' => '',
		'contact_3_facebook' => '',
		'contact_3_twitter' => '',
		'contact_3_instagram' => '',
		'contact_3_pinterest' => '',
		'contact_3_linkedin' => '',
		'contact_3_youtube' => '',
		'image_filename' => '29.jpg',
		'logo_filename' => '29.jpg',
		'contact_image_filename' => '29.jpg',
		'all_properties_link_image_filename' => '29.jpg',
		'all_properties_link' => 'http://www.hmproperties.com/charlotte-nc-homes-search-results.html',
		'video_embed_code' => '<script type="text/javascript" src="http://videocontent.jloop.com/players/3LwgmnCn-qzxAOUo0.js"></script>',
		'contact_video_embed_code' => '',
		'meta_title' => 'Charlotte Real Estate | HM Properties | Leverage Global Partners',
		'meta_description' => 'HM Properties is the exclusive representative for Leverage Global Partners in the Charlotte Region, North Carolina, USA.',
		'meta_keywords' => 'hm properties, charlotte real estate, valerie mitchener, leverage global partners',
		'login_message_counter' => '0',
		'stats_module_1_type' => '',
		'stats_module_1_value' => '',
		'stats_module_2_type' => '',
		'stats_module_2_value' => '',
		'stats_module_3_type' => '',
		'stats_module_3_value' => '',
		'last_activity_email_sent' => '0000-00-00 00:00:00',
		'converted' => true,
		'created' => '2013-05-23 15:42:36',
		'modified' => '2016-04-08 16:33:22',
		'dre_num' => '012345',
		'uri' => '/brokerage-detail/29/hm-properties',
		'website_short' => 'www.hmproperties.com/index.html',
		'name_with_location' => 'HM Properties'
	),
	'Logo' => array(
		'id' => '2323',
		'model' => 'Brokerage',
		'model_id' => '29',
		'tag' => 'Logo',
		'name' => '29.jpg',
		'type' => 'image/jpg',
		'size' => '216998',
		'uri' => '/assets/2323.jpg',
		'order' => '0',
		'created' => '2016-03-30 11:37:34',
		'modified' => '2016-03-30 11:37:34'
	),
	'MainImage' => array(
		'id' => '2322',
		'model' => 'Brokerage',
		'model_id' => '29',
		'tag' => 'MainImage',
		'name' => '29.jpg',
		'type' => 'image/jpg',
		'size' => '1408643',
		'uri' => '/assets/2322.jpg',
		'order' => '0',
		'created' => '2016-03-30 11:37:34',
		'modified' => '2016-03-30 11:37:34'
	),
	'ContactImage' => array(
		'id' => '2324',
		'model' => 'Brokerage',
		'model_id' => '29',
		'tag' => 'ContactImage',
		'name' => '29.jpg',
		'type' => 'image/jpg',
		'size' => '3112842',
		'uri' => '/assets/2324.jpg',
		'order' => '0',
		'created' => '2016-03-30 11:37:34',
		'modified' => '2016-03-30 11:37:34'
	),
	'ContactImage2' => array(
		'id' => null,
		'model' => null,
		'model_id' => null,
		'tag' => null,
		'name' => null,
		'type' => null,
		'size' => null,
		'uri' => null,
		'order' => null,
		'created' => null,
		'modified' => null
	),
	'ContactImage3' => array(
		'id' => null,
		'model' => null,
		'model_id' => null,
		'tag' => null,
		'name' => null,
		'type' => null,
		'size' => null,
		'uri' => null,
		'order' => null,
		'created' => null,
		'modified' => null
	),
	'BrokerOfRecordLogo' => array(
		'id' => null,
		'model' => null,
		'model_id' => null,
		'tag' => null,
		'name' => null,
		'type' => null,
		'size' => null,
		'uri' => null,
		'order' => null,
		'created' => null,
		'modified' => null
	),
	'FeaturedImage' => array()
)
BrokeragesController::view() - APP/Controller/BrokeragesController.php, line 537
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110

Leverage Brokerage | HM Properties

Properties / HM Properties

HM Properties

Broker-in-Charge/Owner: Valerie Mitchener
(704) 552-9292

License #: 012345

Visit Website

Known as the Queen City, Charlotte, North Carolina, is one of the fastest growing cities in the United States.

HM Properties is the exclusive representative for Leverage Global Partners in Mecklenburg County, Cabarrus County, Gaston County, Iredell County, Lincoln County, and Union County in Charlotte, North Carolina and Lancaster County and York County in South Carolina, USA.

HM Properties is a full-service residential real estate firm licensed in North and South Carolina, and serves the Charlotte region including upstate South Carolina. We also specialize in corporate relocation moves for individuals, businesses and relocation companies.

Founded in 2006 as a boutique real estate agency, HM Properties has quickly become one of the leading real estate companies in the Charlotte metro region. Our office is centrally located in the SouthPark area within Piedmont Town Center with over 55 top brokers and seven full-time employees including in-house Relocation and Marketing departments.

Valerie Mitchener, owner and Broker-in-Charge, has hand-picked top brokers in the region who possess exceptional customer service skills, experience and knowledge of our market, and a strong work ethic. "The success of HM Properties is due, in large part, because of our team concept which enables us to match each client with the agent(s) best qualified to assist them," states Mitchener. Our goal is to keep clients for life, so our commitment to you begins when we meet and never ends.

HM Properties specializes in the communities within Mecklenburg County, Cabarrus County, Gaston County, Iredell County, Lincoln County, and Union County in North Carolina; and Lancaster County and York County in South Carolina, including the areas of Lake Norman, Mountain Island Lake, and Lake Wylie.

Skyline Photo: Charlotte Photo

Connect With Us

www.hmproperties.com/index.html

Read Our Profile

Meet Valerie Mitchener: President of HM Properties

LeverageRE

In August 2006, Valerie Mitchener decided to turn her dream of owning a real estate company into a reality and founded HM Properties. The company began as a boutique agency with six agents and has grown to be one of the leading independent and award-winning real estate firms in the Charlotte region with over 60 agents and seven full-time staff.

Partner:
HM Properties

HM Properties Featured Properties

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

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

Cake Params
- plugin(null)
- controllerbrokerages
- actionview
- named(empty)
- pass(array)
  029
  1hm-properties
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

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

Sql Log

Sql Logs

default

Total Time: 15 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` = 29 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` = (29) 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` = 29 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` = 29 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` = (74) ORDER BY `Image`.`order` ASC	1	1	1
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` = 74 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` = 74 AND `ArticlesLocation`.`location_id` = `Location`.`id`)	0	0	2	maybe slow
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` = 74 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` = 74 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 (477, 480, 448, 490) 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 8.98 MB

Message	Memory use
Component initialization	2.94 MB
Controller action start	3.87 MB
Controller render start	6.23 MB
View render complete	6.74 MB

Timers

Total Request Time: 533 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	386.92
Event: Controller.initialize	4.07
Event: Controller.startup	1.20
Controller action	37.83
Event: Controller.beforeRender	4.48
» Processing toolbar data	4.39
Rendering View	79.94
» Event: View.beforeRender	0.27
» Rendering APP/View/Brokerages/view.ctp	0.91
» » Rendering APP/View/Elements/article_list.ctp	0.17
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.21
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	78.11
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)
 id12
 parent_id9
 brokerage_id193
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameSandpoint, ID, USA
 short_nameSandpoint, ID, USA
 group_index
 latitude48.276577
 longitude-116.553467
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionWhy choose between mountains and the lake? Sandpoint, Idaho has both!
 long_descriptionSandpoint is conveniently nestled between a world class ski resort, Schweitzer Mountain, and Lake Pend Oreille, the largest lake in Idaho. Sandpoint is an outdoor enthusiast’s paradise, with extensive hiking, biking and horseback riding trails in addition to snow sports and lake activities. But it also has cultural amenities: innovative restaurants, wineries and breweries, art galleries, outdoor music festivals, a historically restored theatre and state-of-the-art concert venue. Whether you are looking to buy a mountain chalet or a waterfront condo, undeveloped land in the country or a luxury home on a golf course, Sandpoint, Idaho has it all.
 created2016-04-04 09:29:15
 modified2016-04-04 09:30:13
 timezoneAmerica/Boise
 population7500
 uri/locations/view/12/sandpoint-id-usa
 tile_nameSandpoint, ID, USA
 Brokerage(array)
 id193
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2488486
 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
 nameRealm Partners
 broker_of_record_name
 short_nameRealm Partners
 usernameRealmPartners
 password3155a1962479fd9359ac809fa35950b166d70c3a
 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
 descriptionRealm Partners is the exclusive representative for Leverage Global Partners in all of Bonner County, including Sandpoint, Idaho, USA. Headquartered in Sandpoint, Realm was founded by Tom Puckett and Teague Mullen, most often referred to as Puckett and Teague, and known as Sandpoint’s finest real estate team. After more than a decade of trendsetting in a corporate real estate culture, the two envisioned a professional cutting edge real estate agency that combines local expertise and an unrivaled network with innovative technology and next level marketing techniques. Realm is their investment in your next real estate dream.
 communitiesSandpoint Bonner County
 websitehttp://realmidaho.com/
 address215 Cedar
 address_2
 citySandpoint
 stateID
 full_stateIdaho
 countryUSA
 market
 market_2
 postal_code83864
 phoneTeague: (208) 255-6650
 phone_2Tom: (208) 255-8269
 phone_3
 wide_contact_image(false)
 contact_nameTom Puckett & Teague Mullen
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwners
 contact_dre_num
 contact_quote
 contact_emailteague@realmidaho.com
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2tom@realmidaho.com
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename193.jpg
 logo_filename193.jpg
 contact_image_filename193.jpg
 all_properties_link_image_filename193.jpg
 all_properties_linkhttp://realmidaho.idxbroker.com/idx/featured
 video_embed_code
 contact_video_embed_code
 meta_titleRealm Partners | Leverage Global Partners | Sandpoint Real Estate
 meta_descriptionRealm Partners is the exclusive representative for Leverage Global Partners in Sandpoint, including all of Bonner County, ID, USA.
 meta_keywordsRealm Partners, Leverage Global Partners, Sandpoint Real Estate, Bonner County Real Estate, Idaho Real Estate, Tom Puckett, Teague Mullen
 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)
 created2015-02-13 11:47:44
 modified2016-04-08 16:34:20
 dre_num012345
 uri/brokerage-detail/193/realm-partners
 website_shortrealmidaho.com
 name_with_locationRealm Partners
 Image(array)
 id2939
 modelLocation
 model_id12
 tagImage
 nameSandpoint.jpg
 typeimage/jpeg
 size127307
 uri/assets/2939.jpg
 order0
 created2016-04-04 09:28:49
 modified2016-04-04 09:30:13
 1(array)
 Location(array)
 id134
 parent_id9
 brokerage_id102
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameDenver, CO, USA
 short_nameDenver, CO, USA
 group_index
 latitude39.739235
 longitude-104.990250
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-07 15:14:50
 modified2016-04-18 10:39:05
 timezoneAmerica/Denver
 population650000
 uri/locations/view/134/denver-co-usa
 tile_nameDenver, CO, USA
 Brokerage(array)
 id102
 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
 WOEID2391279
 timezoneUS/Mountain
 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
 nameMadison & Company Properties, LTD.
 broker_of_record_name
 short_nameMadison & Company Properties, LTD.
 usernameMadisonCompanyProperties
 password8541ab1d4f117636ccf50dec264f6087f8469e75
 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
 descriptionMadison and Company Properties LTD. is the exclusive representative for Leverage Global Partners in Denver, Aurora, Broomfield, Castle Rock, Cherry Hills Village, Golden, Greenwood Village, Highlands Ranch, Lakewood, Littleton, Lone Tree, Parker, Denver County, Adams County, Arapahoe County, Jefferson County, Douglas County, Elbert County, CO, USA. “Welcome to Madison & Company Properties. Over the last 5 years, our company has experienced an explosion of growth. In that time, we have added some incredible broker associates and new exciting locations. More importantly, we have continually added great people who help make our culture collaborative, professional, and fun to be associated with. We are one of the fastest growing boutique real estate firms in Denver, Colorado and we want to be your trusted real estate firm for all of your real estate needs. At Madison & Company, we are committed to providing our clients with an outstanding experience. We hope you choose Madison either to buy or sell your home. I know that our brokers will take care of you with the utmost care and responsibility.” —— Todd Narlinger President & Founder Madison & Company Properties
 communitiesDenver Aurora Broomfield Castle Rock Cherry Hills Village Golden Greenwood Village Highlands Ranch Lakewood Littleton Lone Tree Parker Denver County Adams County Arapahoe County Jefferson County Douglas County Elbert County
 websitehttp://www.madisonprops.com/
 address5600 S. Quebec Street
 address_2Suite A-113
 cityGreenwood Village
 stateCO
 full_stateColorado
 countryUSA
 marketDenver
 market_2
 postal_code80111
 phone(303) 771-3850
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTodd Narlinger
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-todd-narlinger/
 contact_big_profile_link_textMeet Todd
 contact_titleBroker Owner
 contact_dre_num
 contact_quote
 contact_emailtodd@madisonprops.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_filename102.jpg
 logo_filename102.png
 contact_image_filename102.jpg
 all_properties_link_image_filename102.jpg
 all_properties_linkhttp://www.madisonprops.com/IDXMini.aspx?segmentid=7044292&uid=118945&htmlfile=1883217.html
 video_embed_code<iframe src="https://player.vimeo.com/video/134034523?color=ffffff&title=0&byline=0&portrait=0" width="500" height="281" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>
 contact_video_embed_code
 meta_titleDenver Real Estate | Madison and Company Properties LTD. | Leverage Global Partners
 meta_descriptionMadison and Company Properties LTD. is the exclusive representative for Leverage Global Partners in Denver, CO, USA.
 meta_keywordsMadison and Company Properties LTD, Denver Real Estate, Todd Narlinger, Denver, Aurora, Broomfield, Castle Rock, Cherry Hills Village, Golden, Greenwood Village, Highlands Ranch, Lakewood, Littleton, Lone Tree, Parker, Denver County, Adams County, Arapahoe County, Jefferson County, Douglas County, Elbert County Real Estate, Denver Colorado
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-03-05 17:29:54
 modified2016-04-08 16:34:09
 dre_num012345
 uri/brokerage-detail/102/madison-company-properties-ltd
 website_shortwww.madisonprops.com
 name_with_locationMadison & Company Properties, LTD.
 Image(array)
 id5320
 modelLocation
 model_id134
 tagImage
 nameDenver.jpg
 typeimage/jpeg
 size160418
 uri/assets/5320.jpg
 order0
 created2016-04-07 15:11:56
 modified2016-04-18 10:39:05
 2(array)
 Location(array)
 id63
 parent_id9
 brokerage_id179
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameScottsdale, AZ, USA
 short_nameScottsdale, AZ, USA
 group_index
 latitude33.680302
 longitude-111.833008
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionWelcome to Scottsdale, Paradise Valley, Phoenix, the beautiful Valley of the Sun!
 long_descriptionThe Scottsdale, Paradise Valley, Phoenix area is one of the most picturesque, engaging and dynamic areas in Arizona. Boasting about 300 days of sunshine each year, it is known for its elegant resorts, world-class golf, elite shopping experiences, gorgeous sunsets and desert vistas, incredible parks and open space and one-of-a-kind annual events. Whether you live in the area permanently or seasonally, you will find beautiful neighborhoods to fit your discerning tastes, offering a wide variety of amenities and architectural styles, enhanced by a rich Western history. The Scottsdale • Paradise Valley • Phoenix area is the perfect place to call home.
 created2016-04-04 16:49:19
 modified2016-04-04 16:49:19
 timezoneAmerica/Phoenix
 population1800000
 uri/locations/view/63/scottsdale-az-usa
 tile_nameScottsdale, AZ, USA
 Brokerage(array)
 id179
 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
 WOEID2347561
 timezoneUS/Mountain
 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
 nameVentana Fine Properties
 broker_of_record_name
 short_nameVentana Fine Properties
 usernameVentanaFineProperties
 password6e247d502975b7ceaa5fc08026566869946ee27e
 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
 descriptionVentana Fine Properties is the exclusive representative for Leverage Global Partners in Scottsdale, North East Phoenix, Biltmore, Camelback Corridor, Arcadia, Desert Ridge, Tatum Highlands, Tatum Ranch, Dove Valley, Lone Mountain, Paradise Valley, Carefree, Cave Creek, Rio Verde, Tonto Verde, Rio Verde Foothills, Fountain Hills, Arizona, USA. Humanity is the experience of individuals engaging in the world around them, and through our products, services and brand, Ventana Fine Properties participates in this process. We affirm that each individual can, and must, make a difference in the way we experience life while living in harmony with each other. As a team of diverse people motivated and strengthened by this belief, we speak many languages but have one voice. Powered by insight, we deliver inclusive world-class real estate marketing and brokerage services with local expertise and global response. The Ventana Fine Properties brand opens the ‘window of opportunity’ in real estate and represents our call to action through servant leadership. Our mission is to increase value in the communities we serve. We stand with our clients, friends and neighbors to protect and preserve their real estate assets. We are a consumer centric company with an entrepreneurial spirit delivering an authentic relational experience through the principal of ‘The Platinum Rule’… we treat our clients and customers the way they want to be treated. Our belief is that when we cooperate with the world around us with purposeful, passionate and proactive service, nothing stands in our way. May we open the window to your dreams?
 communitiesScottsdale North East Phoenix Biltmore Camelback Corridor Arcadia, Desert Ridge Tatum Highlands Tatum Ranch Dove Valley Lone Mountain Paradise Valley Carefree Cave Creek Rio Verde Tonto Verde Rio Verde Foothills Fountain Hills
 websitehttp://www.ventanafineproperties.com/
 addressMarket Street CommonsScottsdale
 address_220865 North 90th Place, Suite 105
 cityScottsdale
 stateAZ
 full_stateArizona
 countryUSA
 market
 market_2
 postal_code85255
 phone(480) 204-6015
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJohn Birsner
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleDesignated Broker/Owner
 contact_dre_num
 contact_quote
 contact_emailjohnb@ventanafineproperties.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_filename179.jpg
 logo_filename179.jpg
 contact_image_filename179.jpg
 all_properties_link_image_filename179.jpg
 all_properties_linkhttp://www.ventanafineproperties.com/communities/ventana-fine-properties-listings-latest-listings/
 video_embed_code
 contact_video_embed_code
 meta_titleScottsdale Real Estate | Ventana Fine Properties | Leverage Global Partners
 meta_descriptionVentana Fine Properties is the exclusive representative for Leverage Global Partners in Scottsdale, AZ, USA.
 meta_keywordsScottsdale real estate, Ventana Fine Properties, John Birsner, Scottsdale real estate, North East Phoenix real estate, Biltmore real estate, Camelback Corridor real estate, Arcadia real estate, Desert Ridge real estate, Tatum Highlands real estate, Tatum Ranch real estate, Dove Valley real estate, Lone Mountain real estate, Paradise Valley real estate, Carefree real estate, Cave Creek real estate, Rio Verde real estate, Tonto Verde real estate, Rio Verde Foothills real estate, Fountain Hills real estate
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-11-24 14:42:11
 modified2016-04-08 16:34:20
 dre_num012345
 uri/brokerage-detail/179/ventana-fine-properties
 website_shortwww.ventanafineproperties.com
 name_with_locationVentana Fine Properties
 Image(array)
 id2995
 modelLocation
 model_id63
 tagImage
 name39922990_2013-06-28-aztripsunset.jpg
 typeimage/jpeg
 size2449325
 uri/assets/2995.jpg
 order0
 created2016-04-04 16:45:05
 modified2016-04-04 16:49:19
 3(array)
 Location(array)
 id31
 parent_id9
 brokerage_id4
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameSanta Monica, CA, USA
 short_nameSanta Monica, CA, USA
 group_index
 latitude34.019455
 longitude-118.491188
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionSun, sand, and Silicon Beach, Santa Monica represents the epitome of the Southern California beach lifestyle.
 long_descriptionThis seaside location has been featured so frequently in movies and television shows that it may seem instantly familiar. Santa Monica’s resort appeal stretches back over a century and beachside chic combines glamorous shopping, a thriving downtown, and the energy of the many entrepreneurs who have launched startups in the area. The Santa Monica lifestyle is a mix of laidback beach style with a side of Los Angeles hustle. Outdoor living is the order of the day whether it is biking along the strand, strolling along Montana Avenue or taking an outdoor fitness class in the park while enjoying an ocean view. Santa Monica’s real estate is as varied as its citizenry. There are a variety of homes for sale, from beachy bungalows to new construction luxury homes and condo buildings.
 created2016-04-04 12:01:12
 modified2016-04-12 16:17:59
 timezoneAmerica/Los_Angeles
 population92500
 uri/locations/view/31/santa-monica-ca-usa
 tile_nameSanta Monica, CA, USA
 Brokerage(array)
 id4
 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_properties1
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id1
 WOEID2488892
 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
 usernamePartnersTrustSM
 password74c7d5ff6cf0a7cb1e382c45ff916c0d15196817
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPartners Trust is the exclusive representative for Leverage Global Partners in Santa Monica, California, USA. At Partners Trust, our real estate associates are the most professional, successful and ethical in the business, representing each of our clients with care, confidentiality and the utmost attention to service. As a company, we offer our associates and clients a level of technology and communication unmatched in today’s real estate market. Situated on the Pacific coast, Santa Monica’s excellent weather, proximity to the beach and its pedestrian and bike-friendly topography makes it one of the most desirable communities to call home in the country. Santa Monica offers an eclectic and rich mixture of commerce, affluent, single-family neighborhoods, renters, young professionals, and students. Our associates proudly represent a wide array of homes, ranging from a beachfront property or classic traditional, to the hillside contemporary estate. Whether our clients are homeowners or builders or international investors, Partners Trust associates understand their discerning needs and provide impeccable service with a high level of local area expertise. Partners Trust has additional office locations in <a href="../../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/5/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Pasadena</a>, <a href="../../../brokerage-detail/142/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Malibu</a> and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai</a>.
 communitiesSanta Monica Marina Del Rey Venice Mar Vista Pacific Palisades
 websitehttp://www.thepartnerstrust.com
 address1333 Montana Avenue
 address_2
 citySanta Monica
 stateCA
 full_stateCalifornia
 countryUSA
 marketSanta Monica
 market_2
 postal_code90403
 phone(310) 500-1307
 phone_2(310) 505-9420
 phone_3
 wide_contact_image(false)
 contact_nameScott Carmody
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-scott-carmody-managing-director-partners-trust-santa-monica/
 contact_big_profile_link_text
 contact_titleManaging Director
 contact_dre_num
 contact_quote
 contact_emailscott.carmody@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_2Nick Segal
 contact_profile_link_2http://www.leveragere.com/brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2President/Co-Founder
 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_filename4.jpg
 logo_filename4.png
 contact_image_filename4.JPG
 all_properties_link_image_filename4.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_titleSanta Monica Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
 meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Santa Monica, CA is a boutique real estate brokerage, focused on providing the highest level of service to home buyers and sellers in the Santa Monica real estate market.
 meta_keywordspartners trust, partners trust real estate, santa monica real estate, santa monica real estate agents, scott carmody, leverage global partners
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-03-18 15:36:48
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/4/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortwww.thepartnerstrust.com
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 Image(array)
 id2960
 modelLocation
 model_id31
 tagImage
 nameSanta Monica.jpg
 typeimage/jpeg
 size121061
 uri/assets/2960.jpg
 order0
 created2016-04-04 12:00:24
 modified2016-04-12 16:17:59
- sidebar_articles(array)
 0(array)
 Article(array)
 id477
 modelArticle
 model_id0
 archived(false)
 medium_featured(false)
 large_featured(false)
 titlePartners Trust Sells Vince Vaughn's La Canada Home
 authorLeverageRE
 date2016-03-29
 lead_inLeverage Partner Partners Trust has sold Vince Vaughn's La Cañada home for $4.8 million. Christine Navarro of Partners Trust handled the transaction.
 body<div> As the <a href="http://www.latimes.com/business/realestate/hot-property/la-fi-hotprop-vince-vaughn-20160309-story.html" target="_blank">L.A. Times reported</a>, he purchased the home three years ago. The neoclassical home, built in 2000, has a timeless appearance with a grand columned porch, lush landscaping, and exquisitely crafted traditional touches. <img class="aligncenter size-full wp-image-13005 pure-img" src="/assets/3291.jpg" /> The five-bedroom home sits on approximately 3/4 of an acre. A gracious two-story entry with sweeping staircase leads to the living room and formal dining room which feature large windows and finely detailed moldings. The gourmet kitchen has a butler's pantry and adjoins the light filled family room. The family room opens out to a covered brick patio, salt water pool, lawn and sport court. <img class="aligncenter size-full wp-image-13006 pure-img" src="/assets/3292.jpg" /> A rich paneled library, guest room or office, laundry room and powder room complete the first floor. The master suite features a large closet, spectacular bath with soaking tub, steam shower, and views of the yard. This home also has an attached three car garage with plenty of storage. </div> <h6>Article originally appeared on <a href="http://www.thepartnerstrust.com/blog/2016/03/partners-trust-sells-vince-vaughns-la-canada-home/" target="_blank">Partners Trust Blog</a></h6>
 vimeo_id
 created2016-04-05 14:34:56
 modified2016-04-08 09:57:59
 uri/articles/view/477/partners-trust-sells-vince-vaughn-s-la-canada-home
 Image(array)
 0(array)
 id3293
 modelArticle
 model_id477
 tagImage
 nameScreen-Shot-2016-03-29-at-2.49.30-PM.png
 typeimage/png
 size3168691
 uri/assets/3293.png
 order0
 created2016-04-05 14:34:56
 modified2016-04-08 09:57:59
 1(array)
 Article(array)
 id480
 modelArticle
 model_id0
 archived(false)
 medium_featured(true)
 large_featured(false)
 titleCelebrity Spotlight: Madison Hildebrand
 authorLeverageRE
 date2016-03-29
 lead_inThough reality television enthusiasts are used to seeing Madison Hildebrand's million-dollar smile on BRAVO's Million Dollar Listing Los Angeles for the past eight seasons, this summer he could be found everywhere from a yacht on the French Riviera to wielding a shovel and mixing cement in Managua.
 body<div> <div> <div> </div> </div> <div> <div> He started the summer as an ambassador with <a href="https://givebackhomes.com/" target="_blank">Give Back Homes</a>, traveling to the capital of Nicaragua to build a home for a local family. "With every brick you lay and shovel you shovel, every pile of rocks you move, you feel good. It's blood, sweat, and tears in the heat, but you can't help but feel good about it," Hildebrand said. <img class="aligncenter size-full wp-image-12996 pure-img" src="/assets/3305.png" /> Not one to miss an opportunity, Hildebrand mixed service with business and pleasure by meeting with Partners Trust and Leverage Global Partners while in Nicaragua-but in a slightly different locale. "We took a helicopter across the country to Guacalito, which is a surf town. To get there you fly over a massive volcano, which is incredible, and land at Mukul Resort. They hosted us and gave us a four-bedroom villa, a butler-it was an amazing couple of days," he reflected. "It was awesome and refreshing. It's one of the coolest things to build a house and experience a different part of the country." <img class="aligncenter wp-image-12997 pure-img" src="/assets/3306.png" /> Hildebrand has summered abroad every year since moving to Malibu in 1999 to attend Pepperdine University. This year's odyssey took him along the azure coasts of Italy and the French Riviera. </div> <div> "This summer I had the fortunate opportunity to board a 110-foot yacht that one of my clients and best friends booked. We flew into Florence, then eight of my best friends took the yacht from the port down to Positano, where one of my friends got engaged." From Positano to Corsica, Monaco, Nice, and Antibes, Hildebrand described the theme of the trip as "you don't even know what you don't even know," as only the host knew what adventure awaited them at the next port. <img class="aligncenter size-full wp-image-12992 pure-img" src="/assets/3307.png" /> <div> <div> <div> An avid traveler, gardener, real estate guru, and enthusiast of joie de vivre, Hildebrand believes in loving what you do and doing what you love. His company, <a href="http://www.themalibulife.com/" target="_blank">The Malibu Life</a>, is inspired by just that: the aspirational lifestyle that draws people to the area's more laid-back, yet glamorous, sensibility. "It's really that we are an extension of selling the lifestyle more than just a house. It's a very chic, but casually sophisticated group of people with all sorts of backgrounds," Hildebrand explains. "More than anything, Mother Nature is a key element that ties it all together, but you're still on the cusp of everything LA-so you still have fashion and the entertainment events-but out here it's much more easygoing and relaxed." <img class="aligncenter size-full wp-image-12994 pure-img" src="/assets/3308.png" /> Hildebrand wears many hats, including acting as a concierge of sorts. "My brand and myself are resources to live the lifestyle they came here to live. If they want surf instructors, or they want horseback riding, I have all those connections. You want fancy cars? I've got a car dealer. If they need a private jet, I've got an affiliation with that company." </div> <div> One of the roles he's taken on again this past year is appearing on Million Dollar Listing Los Angeles. He "retired" after season 6, but fans will see him come out of retirement with his own episodes midway through this season. Hildebrand said his hiatus from the show came from his regular practice of reevaluating priorities. "Our show in particular is one of the longest-filmed shows for reality. It takes about ten or eleven months to get the 12 to 14 episodes, and between filming and wardrobe, it's absolutely exhausting," he explains. "At the end of the day it was time to look at why I was doing it, and I just felt like it was time to tap out. I've come back because it can be on my terms, and I'm excited to update my fans on what's going on in my life." <img class="aligncenter size-full wp-image-12993 pure-img" src="/assets/3309.png" /> </div> <div> Hildebrand's priorities this fall include hosting the Breast Cancer Research Foundation's Play For P.I.N.K. golf tournament in October, a cause close to his heart after losing his grandmother to the disease. He will participate in another Give Back Homes buildsite in San Diego in November, as well as speaking at the National Association of Realtors Conference. Hildebrand's life won't be slowing down anytime soon-and that's just how he likes it. "I think you're either expanding or contracting," he said. "That's just the way it is. If you're not lifting weight, your muscles are deflating; if you are, they're inflating. Your mind is the same way. If I'm not doing something good for my soul like gardening or exercising, then I'm doing something healthy for my mind-so if that's meditating, reading, learning something new, or finding another passion, that's also a big part of who I am." <img class="aligncenter wp-image-12995 pure-img" src="/assets/3310.png" /> </div> </div> </div> </div> </div> </div>
 vimeo_id
 created2016-04-05 14:35:00
 modified2016-04-11 17:49:35
 uri/articles/view/480/celebrity-spotlight-madison-hildebrand
 Image(array)
 0(array)
 id3311
 modelArticle
 model_id480
 tagImage
 name2-3.jpg
 typeimage/jpg
 size106052
 uri/assets/3311.jpg
 order0
 created2016-04-05 14:35:01
 modified2016-04-11 17:49:35
 2(array)
 Article(array)
 id448
 modelLocation
 model_id74
 archived(false)
 medium_featured(true)
 large_featured(true)
 titleLocation: Vail
 authorLeverageRE
 date2016-03-24
 lead_inThough a year-round destination, Vail was predominately created by and for skiing. As popular as skiing is in the winter, activities such as hiking, cycling and golfing fill the void in the summer.
 bodyThe small town offers signature, year-round events, dozens of nightlife hotspots, diverse dining, luxurious spas and hundreds of shops. Whether you're looking for outdoor adventure or some much needed R&R, there's an activity for everyone to enjoy while in Vail: INDULGE. Nothing repairs sore ski muscles like the Hot Toddy for the Body treatment at the spa at the <a href="http://www.ritzcarlton.com/en/hotels/colorado/bachelor-gulch" target="_blank">Ritz-Carlton, Bachelor Gulch</a>, where a scrub containing sweet almond oil, jojoba beads, and shea butter scented with cinnamon and nutmeg is massaged into the skin to eliminate dry patches and relax muscles. <img class="aligncenter wp-image-12787 pure-img" src="/assets/3115.png" /> SOCIALIZE. Stop in après ski or post-hike at <a href="http://www.larkspurvail.com/" target="_blank">Larkspur</a> in Edwards and join locals for a classic Larkburger paired with parmesan truffle fries and a local brew. <img class="aligncenter wp-image-12788 pure-img" src="/assets/3116.png" /> CHALLENGE. The <a href="http://www.beavercreek.com/events-and-activities/world-cup.aspx" target="_blank">Birds of Prey</a> down-hill course at Beaver Creek is one of the most difficult downhill courses in the world, featuring a vertical drop of 2,484 feet loaded with steep pitches and sharp turns. <img class="aligncenter wp-image-12786 pure-img" src="/assets/3117.png" /> SHOP. The <a href="http://vailfarmersmarket.com/" target="_blank">Vail Farmer's Market</a> is the largest in Colorado. Stock up on everything from organic, locally grown produce and meats to wine from Colorado's Bookcliff Vineyards and goat cheese from Jumpin' Good Goat Dairy. EXPLORE. Spend the day with <a href="http://www.vailvalleyanglers.com/" target="_blank">Vail Valley Anglers</a> and experience fishing for brown, rainbow, cutthroat, and brook trout paired with hiking and wildlife spotting. <img class="aligncenter wp-image-12789 pure-img" src="/assets/3118.png" /> DINE. A Vail Village classic, <a href="https://sweetbasilvail.com/" target="_blank">Sweet Basil</a> is headed by executive chef Paul Anders, who continues to produce a creative menu of modern American cuisine.
 vimeo_id
 created2016-04-05 14:30:41
 modified2016-04-11 17:03:53
 uri/articles/view/448/location-vail
 Image(array)
 0(array)
 id3119
 modelArticle
 model_id448
 tagImage
 nameVail.jpg
 typeimage/jpg
 size782803
 uri/assets/3119.jpg
 order0
 created2016-04-05 14:30:42
 modified2016-04-11 17:03:53
 3(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
- main_article(array)
 Article(array)
 id74
 modelBrokerage
 model_id29
 archived(false)
 medium_featured(false)
 large_featured(false)
 titleMeet Valerie Mitchener: President of HM Properties
 authorLeverageRE
 date2013-07-15
 lead_inIn August 2006, Valerie Mitchener decided to turn her dream of owning a real estate company into a reality and founded HM Properties. The company began as a boutique agency with six agents and has grown to be one of the leading independent and award-winning real estate firms in the Charlotte region with over 60 agents and seven full-time staff.
 body Valerie's unique business model allowed her to build a niche within a very competitive real estate market. Her focus was to create a brand centered around top-producing agents whose experience would help enhance this brand. Hand-picking the right combination of brokers and staff was paramount in being able to provide consistent exceptional customer service. Every choice was intentional from the office location to the company colors, logo design, print collateral and advertising, right down to the office wall paint color and furniture choices which were chosen with the HM brand in mind… and it did not take long to set HM Properties apart from its competition. After graduating from the University of North Carolina at Chapel Hill, Valerie worked as a writer and owned a company that provided training materials and documentations for the banking industry, while renovating homes on the side. Knowing she had a passion for real estate, Valerie sold her company in 1998, and transitioned into the industry full-time. She quickly became a top producer at her previous firm and seven years later made the decision to create her own brand – one that represented the values she believed to be important to the real estate industry. <img class="wp-image-1140 pure-img float-left" src="/assets/189.jpg" alt="Valerie Mitchener (high res) black" width="351" height="439" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Valerie-Mitchener-high-res-black-585x731.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Valerie-Mitchener-high-res-black.jpg 3045w" sizes="(max-width: 351px) 100vw, 351px">HM Properties was founded during a time when the real estate market was solid and no one could have predicted the economic collapse that began to spiral downward a mere seven months later. However, the business model Valerie had built not only successfully withstood the downturn, her company continued to grow and even thrive in many aspects. Valerie attributes this success to being able to adapt to the constant changes that were taking place within the real estate market and she was determined to succeed despite the odds. Valerie says, "Professionally, I am most proud of the company. More specifically, I am proud of the team of brokers and staff that I have here. We have been in business for seven years in August (2013), and only had three agents leave and go to another firm, which is highly unusual in our marketplace. We've added people, but it's been the same staff for all these years and I'm really proud of that." Family has always been Valerie's greatest influence and she says that she started HM Properties with family in mind. She founded this company with the intent of building a stable future for her and her children. She is a proud mother of two teenage sons and two stepsons, and they, along with her husband, former NFL player and current investment banker Joe Pellegrini, are her biggest supporters. Valerie moved to North Carolina in 1986, and believes Charlotte is a wonderful place to live and to raise a family. A short drive to the mountains and a few hours to the coast, Charlotte offers something for everyone, she says. A wonderful quality of life, natural beauty, and family friendly surroundings make Charlotte an ideal city to call home. A major turning point for Valerie came shortly after the doors opened at HM Properties. A large real estate company approached her in an attempt to acquire the business. This company gave her a multitude of reasons that HM Properties would fail in the downward turning marketplace. After hearing this opinion, she felt even more driven to make it work and walked out of that meeting with a renewed motivation and commitment to the HM Properties team. Flash forward to today, HM Properties is one of the leading real estate companies in the Charlotte metro area. Utilizing technology, social media, and email campaigns are an integral part of the HM Properties' marketing, but Valerie is a firm believer in relationship-based business. "Technology can't replace personal contact," Valerie says. Her long-term clients and customer base are those people that she calls, meets with, or keeps in touch with on a personal basis. When she's not running HM Properties or selling prime Charlotte real estate, Valerie is a huge fan of decorating, furnishing, and interior design. Just this past year, she has built and designed two homes and is currently working on another. She is also a travel enthusiast and owns a second home in Palmetto Bluff, South Carolina, where she likes to get away with her family. She enjoys spending time outdoors biking, and paddle-boarding with her husband. In addition, she is a big fan of the NBA's Charlotte Bobcats and HM Properties has been its Preferred Realtor® of the team since 2010, and she will often travel to away games, even as far as Miami. Whenever she has time to spare, Valerie also enjoys baking. When asked how her colleagues would describe her as a partner, Valerie said lightheartedly, "I guess it depends on the day." Then, she went on to describe herself as honest and fair with a strong work ethic. She also told us that she might tend to get stubborn sometimes when it comes to decisions about her company. The strength of Valerie's vision and drive were felt in her closing remarks when she said, "I feel strongly about my business and the decisions I make about our brand." With that kind of commitment and dedication to your work and brand, it's no surprise that HM Properties is one of Charlotte's top real estate agencies. Leverage Global Partners is honored to welcome Valerie Mitchener and her team at HM Properties to the network. Header Photo Courtesy of Photo Charlotte
 vimeo_id
 created2016-02-25 14:08:46
 modified2016-04-05 14:41:06
 uri/articles/view/74/meet-valerie-mitchener-president-of-hm-properties
 flattened_topics(empty)
 ParentBrokerage(array)
 id29
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2378426
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameHM Properties
 broker_of_record_name
 short_nameHM Properties
 usernameHMProperties
 password3d70a6783edaaeded5ee1f3d9bbedd1789cdd676
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionHM Properties is the exclusive representative for Leverage Global Partners in Mecklenburg County, Cabarrus County, Gaston County, Iredell County, Lincoln County, and Union County in Charlotte, North Carolina and Lancaster County and York County in South Carolina, USA. HM Properties is a full-service residential real estate firm licensed in North and South Carolina, and serves the Charlotte region including upstate South Carolina. We also specialize in corporate relocation moves for individuals, businesses and relocation companies. Founded in 2006 as a boutique real estate agency, HM Properties has quickly become one of the leading real estate companies in the Charlotte metro region. Our office is centrally located in the SouthPark area within Piedmont Town Center with over 55 top brokers and seven full-time employees including in-house Relocation and Marketing departments. Valerie Mitchener, owner and Broker-in-Charge, has hand-picked top brokers in the region who possess exceptional customer service skills, experience and knowledge of our market, and a strong work ethic. "The success of HM Properties is due, in large part, because of our team concept which enables us to match each client with the agent(s) best qualified to assist them," states Mitchener. Our goal is to keep clients for life, so our commitment to you begins when we meet and never ends. HM Properties specializes in the communities within Mecklenburg County, Cabarrus County, Gaston County, Iredell County, Lincoln County, and Union County in North Carolina; and Lancaster County and York County in South Carolina, including the areas of Lake Norman, Mountain Island Lake, and Lake Wylie. Skyline Photo: Charlotte Photo
 communitiesCharlotte North Carolina NC Mecklenburg County North Carolina NC Cabarrus County North Carolina NC Gaston County North Carolina NC Iredell County North Carolina NC Lincoln County North Carolina NC Union County North Carolina NC Lancaster County South Carolina SC York County South Carolina SC
 websitehttp://www.hmproperties.com/index.html
 address6857 Fairview Road
 address_2
 cityCharlotte
 stateNC
 full_stateNorth Carolina
 countryUSA
 marketCharlotte
 market_2
 postal_code28210
 phone(704) 552-9292
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameValerie Mitchener
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-valerie-mitchener-president-of-hm-properties-charlotte-nc/
 contact_big_profile_link_text
 contact_titleBroker-in-Charge/Owner
 contact_dre_num
 contact_quote
 contact_emailvalerie@hmproperties.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_filename29.jpg
 logo_filename29.jpg
 contact_image_filename29.jpg
 all_properties_link_image_filename29.jpg
 all_properties_linkhttp://www.hmproperties.com/charlotte-nc-homes-search-results.html
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/3LwgmnCn-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleCharlotte Real Estate | HM Properties | Leverage Global Partners
 meta_descriptionHM Properties is the exclusive representative for Leverage Global Partners in the Charlotte Region, North Carolina, USA.
 meta_keywordshm properties, charlotte real estate, valerie mitchener, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-05-23 15:42:36
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/29/hm-properties
 website_shortwww.hmproperties.com/index.html
 name_with_locationHM Properties
 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)
 id190
 modelArticle
 model_id74
 tagImage
 nameCharlotte-Photo4-Credit-Photo-Charlotte.jpg
 typeimage/jpg
 size6627848
 uri/assets/190.jpg
 order0
 created2016-02-25 14:08:47
 modified2016-02-25 14:08:47
 Brokerage(empty)
 Location(empty)
 Property(empty)
 Topic(empty)
- locations(array)
 0(array)
 Location(array)
 id132
 parent_id8
 brokerage_id29
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameCharlotte, NC, USA
 short_nameCharlotte, NC, USA
 group_index
 latitude35.227085
 longitude-80.843124
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionKnown as the Queen City, Charlotte, North Carolina, is one of the fastest growing cities in the United States.
 long_descriptionKnown as the “Queen City”, Charlotte is situated in the Piedmont region of the Carolinas which is two hours east of the Blue Ridge Mountains, three hours west of the North Carolina coast, and is centrally located between Maine and Florida. Charlotte has been consistently voted one of the Best Places to Live and remains one of the fastest growing cities in the U.S. because of its superb quality of life, low cost of living, mild year-round climate, nationally renowed healthcare, and its abundant educational, cultural and recreational opportunities. In addition, the Charlotte region has a tremendous pro-business environment and has become a financial, distribution and transportation center for the entire area and is headquarters to many national and international companies. Charlotte is also home to the NFL’s Carolina Panthers, the NBA’s Charlotte Hornets, and minor league hockey, baseball and soccer teams. Each spring, golf fans enjoy the PGA’s Wells Fargo Championship and we are also proud to have the U.S. National Whitewater Center, a world-class training and sports adventure center. Another popular sport is stock car racing and Charlotte is home to the NASCAR Hall of Fame and Museum as well as the Charlotte Motor Speedway, which is the largest sports facility in the southeast. With a population of over 800,000 in Charlotte and more than 2.4 million in the metro area, the Charlotte region offers residents all the amenities of a major urban city while maintaining its Southern charm and small town feel.
 created2016-04-07 14:23:08
 modified2016-04-07 14:23:08
 timezoneAmerica/New_York
 population800000
 uri/locations/view/132/charlotte-nc-usa
 tile_nameCharlotte, NC, USA
 Brokerage(array)
 id29
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2378426
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameHM Properties
 broker_of_record_name
 short_nameHM Properties
 usernameHMProperties
 password3d70a6783edaaeded5ee1f3d9bbedd1789cdd676
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionHM Properties is the exclusive representative for Leverage Global Partners in Mecklenburg County, Cabarrus County, Gaston County, Iredell County, Lincoln County, and Union County in Charlotte, North Carolina and Lancaster County and York County in South Carolina, USA. HM Properties is a full-service residential real estate firm licensed in North and South Carolina, and serves the Charlotte region including upstate South Carolina. We also specialize in corporate relocation moves for individuals, businesses and relocation companies. Founded in 2006 as a boutique real estate agency, HM Properties has quickly become one of the leading real estate companies in the Charlotte metro region. Our office is centrally located in the SouthPark area within Piedmont Town Center with over 55 top brokers and seven full-time employees including in-house Relocation and Marketing departments. Valerie Mitchener, owner and Broker-in-Charge, has hand-picked top brokers in the region who possess exceptional customer service skills, experience and knowledge of our market, and a strong work ethic. "The success of HM Properties is due, in large part, because of our team concept which enables us to match each client with the agent(s) best qualified to assist them," states Mitchener. Our goal is to keep clients for life, so our commitment to you begins when we meet and never ends. HM Properties specializes in the communities within Mecklenburg County, Cabarrus County, Gaston County, Iredell County, Lincoln County, and Union County in North Carolina; and Lancaster County and York County in South Carolina, including the areas of Lake Norman, Mountain Island Lake, and Lake Wylie. Skyline Photo: Charlotte Photo
 communitiesCharlotte North Carolina NC Mecklenburg County North Carolina NC Cabarrus County North Carolina NC Gaston County North Carolina NC Iredell County North Carolina NC Lincoln County North Carolina NC Union County North Carolina NC Lancaster County South Carolina SC York County South Carolina SC
 websitehttp://www.hmproperties.com/index.html
 address6857 Fairview Road
 address_2
 cityCharlotte
 stateNC
 full_stateNorth Carolina
 countryUSA
 marketCharlotte
 market_2
 postal_code28210
 phone(704) 552-9292
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameValerie Mitchener
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-valerie-mitchener-president-of-hm-properties-charlotte-nc/
 contact_big_profile_link_text
 contact_titleBroker-in-Charge/Owner
 contact_dre_num
 contact_quote
 contact_emailvalerie@hmproperties.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_filename29.jpg
 logo_filename29.jpg
 contact_image_filename29.jpg
 all_properties_link_image_filename29.jpg
 all_properties_linkhttp://www.hmproperties.com/charlotte-nc-homes-search-results.html
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/3LwgmnCn-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleCharlotte Real Estate | HM Properties | Leverage Global Partners
 meta_descriptionHM Properties is the exclusive representative for Leverage Global Partners in the Charlotte Region, North Carolina, USA.
 meta_keywordshm properties, charlotte real estate, valerie mitchener, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-05-23 15:42:36
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/29/hm-properties
 website_shortwww.hmproperties.com/index.html
 name_with_locationHM Properties
 Image(array)
 id3664
 modelLocation
 model_id132
 tagImage
 nameCharlotte.jpg
 typeimage/jpeg
 size105553
 uri/assets/3664.jpg
 order0
 created2016-04-07 14:23:01
 modified2016-04-07 14:23:08
- 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)
 brokerageHM Properties, Charlotte
- brokerage(array)
 Brokerage(array)
 id29
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2378426
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameHM Properties
 broker_of_record_name
 short_nameHM Properties
 usernameHMProperties
 password3d70a6783edaaeded5ee1f3d9bbedd1789cdd676
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionHM Properties is the exclusive representative for Leverage Global Partners in Mecklenburg County, Cabarrus County, Gaston County, Iredell County, Lincoln County, and Union County in Charlotte, North Carolina and Lancaster County and York County in South Carolina, USA. HM Properties is a full-service residential real estate firm licensed in North and South Carolina, and serves the Charlotte region including upstate South Carolina. We also specialize in corporate relocation moves for individuals, businesses and relocation companies. Founded in 2006 as a boutique real estate agency, HM Properties has quickly become one of the leading real estate companies in the Charlotte metro region. Our office is centrally located in the SouthPark area within Piedmont Town Center with over 55 top brokers and seven full-time employees including in-house Relocation and Marketing departments. Valerie Mitchener, owner and Broker-in-Charge, has hand-picked top brokers in the region who possess exceptional customer service skills, experience and knowledge of our market, and a strong work ethic. "The success of HM Properties is due, in large part, because of our team concept which enables us to match each client with the agent(s) best qualified to assist them," states Mitchener. Our goal is to keep clients for life, so our commitment to you begins when we meet and never ends. HM Properties specializes in the communities within Mecklenburg County, Cabarrus County, Gaston County, Iredell County, Lincoln County, and Union County in North Carolina; and Lancaster County and York County in South Carolina, including the areas of Lake Norman, Mountain Island Lake, and Lake Wylie. Skyline Photo: Charlotte Photo
 communitiesCharlotte North Carolina NC Mecklenburg County North Carolina NC Cabarrus County North Carolina NC Gaston County North Carolina NC Iredell County North Carolina NC Lincoln County North Carolina NC Union County North Carolina NC Lancaster County South Carolina SC York County South Carolina SC
 websitehttp://www.hmproperties.com/index.html
 address6857 Fairview Road
 address_2
 cityCharlotte
 stateNC
 full_stateNorth Carolina
 countryUSA
 marketCharlotte
 market_2
 postal_code28210
 phone(704) 552-9292
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameValerie Mitchener
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-valerie-mitchener-president-of-hm-properties-charlotte-nc/
 contact_big_profile_link_text
 contact_titleBroker-in-Charge/Owner
 contact_dre_num
 contact_quote
 contact_emailvalerie@hmproperties.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_filename29.jpg
 logo_filename29.jpg
 contact_image_filename29.jpg
 all_properties_link_image_filename29.jpg
 all_properties_linkhttp://www.hmproperties.com/charlotte-nc-homes-search-results.html
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/3LwgmnCn-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleCharlotte Real Estate | HM Properties | Leverage Global Partners
 meta_descriptionHM Properties is the exclusive representative for Leverage Global Partners in the Charlotte Region, North Carolina, USA.
 meta_keywordshm properties, charlotte real estate, valerie mitchener, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-05-23 15:42:36
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/29/hm-properties
 website_shortwww.hmproperties.com/index.html
 name_with_locationHM Properties
 Logo(array)
 id2323
 modelBrokerage
 model_id29
 tagLogo
 name29.jpg
 typeimage/jpg
 size216998
 uri/assets/2323.jpg
 order0
 created2016-03-30 11:37:34
 modified2016-03-30 11:37:34
 MainImage(array)
 id2322
 modelBrokerage
 model_id29
 tagMainImage
 name29.jpg
 typeimage/jpg
 size1408643
 uri/assets/2322.jpg
 order0
 created2016-03-30 11:37:34
 modified2016-03-30 11:37:34
 ContactImage(array)
 id2324
 modelBrokerage
 model_id29
 tagContactImage
 name29.jpg
 typeimage/jpg
 size3112842
 uri/assets/2324.jpg
 order0
 created2016-03-30 11:37:34
 modified2016-03-30 11:37:34
 ContactImage2(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 ContactImage3(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 BrokerOfRecordLogo(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 FeaturedImage(empty)
- membership_subscription_temp_allowed_login(null)
- newsletter_member_types(array)
 Leverage Member: AgentLeverage Member: Agent
 Leverage Member: Broker or ManagementLeverage Member: Broker or Management
 Non-MemberNon-Member
- $request->data(empty)
- $this->validationErrors(array)
 Subscription(empty)
 Brokerage(empty)
 Logo(empty)
 BrokerOfRecordLogo(empty)
 MainImage(empty)
 FeaturedImage(empty)
 ContactImage(empty)
 ContactImage2(empty)
 ContactImage3(empty)
 Location(empty)
 Image(empty)
 Article(empty)
 Property(empty)
 User(empty)
 PropertyFeature(empty)
 SecondaryPropertyCategory(empty)
 Topic(empty)
 ParentBrokerage(empty)
 ParentLocation(empty)
 ArticlesBrokerage(empty)
 ArticlesLocation(empty)
 ArticlesProperty(empty)
 ArticlesTopic(empty)
 MlsComplianceData(empty)
- Loaded Helpers(array)
 0Permission
 1Number
 2SimpleGraph
 3DebugTimer
 4Toolbar
 5Session
 6Text
 7Flash
 8HtmlToolbar
 9Html
 10Form
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	7.4.33
User	leveragere
Home	/var/www/vhosts/leveragere.com
Script Name	/index.php
Request Uri	/brokerage-detail/29/hm-properties
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/brokerage-detail/29/hm-properties
Remote Port	21092
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 Cf Ray	a09e76168d5a5e44-CMH
Http Accept Encoding	gzip, br
Http Cookie	CAKEPHP=6lm1e5j8t0a6bkevp53kpopihc
Http Accept	/
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http X Forwarded For	216.73.216.172
Proxy-nokeepalive	1
Ssl Tls Sni	staging2.leveragere.com
Https	on
Passenger Download Native Support Binary	0
Passenger Compile Native Support Binary	0
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Unique Id	aipRrMq_rDk8TmUDj2da2AAAAIY
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	aipRrMq_rDk8TmUDj2da2AAAAIY
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781158316.5912
Request Time	1781158316

====

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

HM Properties

Connect With Us

Read Our Profile

Meet Valerie Mitchener: President of HM Properties

HM Properties Featured Properties

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 15 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: 15 ms
Total Queries: 15 queries