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 = '240'
$brokerage = array(
	'Brokerage' => array(
		'password' => '*****',
		'id' => '240',
		'account_executive_id' => '235',
		'archived' => false,
		'type' => 'brokerage',
		'hide_from_frontend' => false,
		'agent_brokerage_data_override' => false,
		'featured_development' => false,
		'membership_type' => 'Basic',
		'max_properties' => '8',
		'max_homepage_featured_by_member_properties' => '0',
		'featured_properties_sort_method' => 'manual',
		'lux_feed_mode' => 'StripeSubscription',
		'max_luxury_feed_properties' => '0',
		'membership_luxury_feed_properties' => '0',
		'can_participate_in_lux_feed_while_archived' => false,
		'full_training_video_access' => false,
		'country_id' => '0',
		'WOEID' => '2473224',
		'timezone' => '',
		'luxury_feed_enrollment_mode' => 'manual',
		'luxury_feed_include_mlsidx_minimum_price' => '0',
		'luxury_feed_include_leverage_minimum_price' => '0',
		'digital_ad_contacts' => 'annalisa.povlock@leveragere.com',
		'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' => 'Achieve Realty',
		'broker_of_record_name' => '',
		'short_name' => 'Achieve Realty',
		'username' => 'AchieveRealty',
		'password_reset_hash' => '',
		'monthly_invoice_amount' => null,
		'monthly_invoice_start_date' => null,
		'monthly_invoice_end_date' => null,
		'contract_filename' => '',
		'active' => true,
		'lead_in' => '',
		'short_description' => '',
		'description' => '<p>Achieve Realty is the exclusive representative for Leverage Global Partners in the City of Pittsburgh, North Allegheny County, West Allegheny County, Butler County, including communities&nbsp;such&nbsp;as Bradford Woods, Collier Township, Fox Chapel, Franklin Park, Hampton Township, Marshall Township, McCandless Township, Ohio Township, Pine Township, Richland Township, Sewickley, Adams Township, Cranberry Township, and Penn Township, Pennsylvania, USA.</p>

<p>Achieve Realty, Inc. is a real estate brokerage headquartered in the Pittsburgh, Pennsylvania suburb of Wexford. The firm is owed by husband and wife lawyers Lawton and Kristen Stokes.</p>

<p>The Stokes&rsquo; have been engaged in the title insurance business since 1993 and in the real estate brokerage business since 2000. Lawton Stokes is also an Associate Broker. Together, the Stokes&rsquo; provide a wealth of support and guidance to the team of sales agents at Achieve Realty.</p>

<p>Achieve Realty is comprised of many of the area&rsquo;s top real estate sales agents. From new construction to existing homes, from condominiums to townhouses, we have the residential market covered. Thanks to our tremendous affiliations, Achieve Realty is a one-stop shop for all of the ancillary services including mortgage, title and homeowners insurance.</p>

<p>Achieve Realty is a proud member of the Leverage Global Partners network.</p>
',
		'communities' => 'City of Pittsburgh
North Allegheny County
West Allegheny County
Butler County
Bradford Woods
Collier Township
Fox Chapel
Franklin Park
Hampton Township
Marshall Township
McCandless Township
Ohio Township
Pine Township
Richland Township
Sewickley
Adams Township
Cranberry Township
Penn Township',
		'website' => 'http://www.achieverealty.net/',
		'address' => '10475 Perry Highway',
		'address_2' => '',
		'city' => 'Wexford',
		'state' => 'PA',
		'full_state' => '',
		'country' => 'USA',
		'market' => 'City of Pittsburgh',
		'market_2' => '',
		'postal_code' => '',
		'phone' => '(724) 933-1980',
		'phone_2' => '',
		'phone_3' => '',
		'wide_contact_image' => false,
		'contact_name' => 'Lawton Stokes',
		'contact_profile_link' => '',
		'contact_big_profile_link' => '',
		'contact_big_profile_link_text' => '',
		'contact_title' => 'Owner',
		'contact_dre_num' => '',
		'contact_quote' => '',
		'contact_email' => 'admin@allsett.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' => '240.jpg',
		'logo_filename' => '240.png',
		'contact_image_filename' => '240.jpg',
		'all_properties_link_image_filename' => '240.jpg',
		'all_properties_link' => 'http://www.achieverealty.net/listings/query.php?aid=&oid=&aname=&aimg=&chome=&odoor=&agent_hasfeat=&state=42&newsearch=1&newsearchresults=1&saved_search=0&keySession=&sort_by=1&property_category=1&pricemin=&pricemax=&bedrooms=&bedmore=1&bath_full=&bath_th',
		'video_embed_code' => '',
		'contact_video_embed_code' => '',
		'meta_title' => 'City of Pittsburgh Real Estate | Achieve Realty | Leverage Global Partners',
		'meta_description' => 'Achieve Realty is the exclusive representative for Leverage Global Partners in the City of Pittsburgh, PA, USA.',
		'meta_keywords' => 'Achieve Realty, Pittsburgh real estate, leverage global partners, Lawton Stokes',
		'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' => '2016-02-03 17:08:44',
		'modified' => '2022-01-13 09:50:57',
		'dre_num' => '012345',
		'uri' => '/brokerage-detail/240/achieve-realty',
		'website_short' => 'www.achieverealty.net',
		'name_with_location' => 'Achieve Realty'
	),
	'Logo' => array(
		'id' => '2932',
		'model' => 'Brokerage',
		'model_id' => '240',
		'tag' => 'Logo',
		'name' => '240.png',
		'type' => 'image/png',
		'size' => '15740',
		'uri' => '/assets/2932.png',
		'order' => '0',
		'created' => '2016-03-30 11:45:46',
		'modified' => '2022-01-13 09:50:57'
	),
	'MainImage' => array(
		'id' => '2931',
		'model' => 'Brokerage',
		'model_id' => '240',
		'tag' => 'MainImage',
		'name' => '240.jpg',
		'type' => 'image/jpg',
		'size' => '490879',
		'uri' => '/assets/2931.jpg',
		'order' => '0',
		'created' => '2016-03-30 11:45:46',
		'modified' => '2022-01-13 09:50:57'
	),
	'ContactImage' => array(
		'id' => '2933',
		'model' => 'Brokerage',
		'model_id' => '240',
		'tag' => 'ContactImage',
		'name' => '240.jpg',
		'type' => 'image/jpg',
		'size' => '66335',
		'uri' => '/assets/2933.jpg',
		'order' => '0',
		'created' => '2016-03-30 11:45:46',
		'modified' => '2022-01-13 09:50:57'
	),
	'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 | Achieve Realty

Properties / Achieve Realty

Achieve Realty

Owner: Lawton Stokes
(724) 933-1980

License #: 012345

Visit Website

Where three rivers meet - Pittsburgh’s appeal begins with its scenery.

Achieve Realty is the exclusive representative for Leverage Global Partners in the City of Pittsburgh, North Allegheny County, West Allegheny County, Butler County, including communities such as Bradford Woods, Collier Township, Fox Chapel, Franklin Park, Hampton Township, Marshall Township, McCandless Township, Ohio Township, Pine Township, Richland Township, Sewickley, Adams Township, Cranberry Township, and Penn Township, Pennsylvania, USA.

Achieve Realty, Inc. is a real estate brokerage headquartered in the Pittsburgh, Pennsylvania suburb of Wexford. The firm is owed by husband and wife lawyers Lawton and Kristen Stokes.

The Stokes’ have been engaged in the title insurance business since 1993 and in the real estate brokerage business since 2000. Lawton Stokes is also an Associate Broker. Together, the Stokes’ provide a wealth of support and guidance to the team of sales agents at Achieve Realty.

Achieve Realty is comprised of many of the area’s top real estate sales agents. From new construction to existing homes, from condominiums to townhouses, we have the residential market covered. Thanks to our tremendous affiliations, Achieve Realty is a one-stop shop for all of the ancillary services including mortgage, title and homeowners insurance.

Achieve Realty is a proud member of the Leverage Global Partners network.

Connect With Us

www.achieverealty.net

Achieve Realty Featured Properties

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

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

Cake Params
- plugin(null)
- controllerbrokerages
- actionview
- named(empty)
- pass(array)
  0240
  1achieve-realty
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

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

Sql Log

Sql Logs

default

Total Time: 12 ms
Total Queries: 10 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `Logo`.`id`, `Logo`.`model`, `Logo`.`model_id`, `Logo`.`tag`, `Logo`.`name`, `Logo`.`type`, `Logo`.`size`, `Logo`.`uri`, `Logo`.`order`, `Logo`.`created`, `Logo`.`modified`, `MainImage`.`id`, `MainImage`.`model`, `MainImage`.`model_id`, `MainImage`.`tag`, `MainImage`.`name`, `MainImage`.`type`, `MainImage`.`size`, `MainImage`.`uri`, `MainImage`.`order`, `MainImage`.`created`, `MainImage`.`modified`, `ContactImage`.`id`, `ContactImage`.`model`, `ContactImage`.`model_id`, `ContactImage`.`tag`, `ContactImage`.`name`, `ContactImage`.`type`, `ContactImage`.`size`, `ContactImage`.`uri`, `ContactImage`.`order`, `ContactImage`.`created`, `ContactImage`.`modified`, `ContactImage2`.`id`, `ContactImage2`.`model`, `ContactImage2`.`model_id`, `ContactImage2`.`tag`, `ContactImage2`.`name`, `ContactImage2`.`type`, `ContactImage2`.`size`, `ContactImage2`.`uri`, `ContactImage2`.`order`, `ContactImage2`.`created`, `ContactImage2`.`modified`, `ContactImage3`.`id`, `ContactImage3`.`model`, `ContactImage3`.`model_id`, `ContactImage3`.`tag`, `ContactImage3`.`name`, `ContactImage3`.`type`, `ContactImage3`.`size`, `ContactImage3`.`uri`, `ContactImage3`.`order`, `ContactImage3`.`created`, `ContactImage3`.`modified`, `BrokerOfRecordLogo`.`id`, `BrokerOfRecordLogo`.`model`, `BrokerOfRecordLogo`.`model_id`, `BrokerOfRecordLogo`.`tag`, `BrokerOfRecordLogo`.`name`, `BrokerOfRecordLogo`.`type`, `BrokerOfRecordLogo`.`size`, `BrokerOfRecordLogo`.`uri`, `BrokerOfRecordLogo`.`order`, `BrokerOfRecordLogo`.`created`, `BrokerOfRecordLogo`.`modified` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` LEFT JOIN `leveragere_staging2`.`assets` AS `Logo` ON (`Logo`.`model_id` = `Brokerage`.`id` AND `Logo`.`model` = 'Brokerage' AND `Logo`.`tag` = 'Logo') LEFT JOIN `leveragere_staging2`.`assets` AS `MainImage` ON (`MainImage`.`model_id` = `Brokerage`.`id` AND `MainImage`.`model` = 'Brokerage' AND `MainImage`.`tag` = 'MainImage') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage` ON (`ContactImage`.`model_id` = `Brokerage`.`id` AND `ContactImage`.`model` = 'Brokerage' AND `ContactImage`.`tag` = 'ContactImage') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage2` ON (`ContactImage2`.`model_id` = `Brokerage`.`id` AND `ContactImage2`.`model` = 'Brokerage' AND `ContactImage2`.`tag` = 'ContactImage2') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage3` ON (`ContactImage3`.`model_id` = `Brokerage`.`id` AND `ContactImage3`.`model` = 'Brokerage' AND `ContactImage3`.`tag` = 'ContactImage3') LEFT JOIN `leveragere_staging2`.`assets` AS `BrokerOfRecordLogo` ON (`BrokerOfRecordLogo`.`model_id` = `Brokerage`.`id` AND `BrokerOfRecordLogo`.`model` = 'Brokerage' AND `BrokerOfRecordLogo`.`tag` = 'BrokerOfRecordLogo') WHERE `Brokerage`.`id` = 240 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` = (240) 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` = 240 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` = 240 LIMIT 1	0	0	1	maybe slow
SELECT `Article`.`id` FROM `leveragere_staging2`.`articles` AS `Article` WHERE `Article`.`archived` = '0' AND NOT (`Article`.`model` = ('News')) ORDER BY `Article`.`created` DESC LIMIT 50	50	50	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 (449, 488, 453, 478) 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 9.83 MB

Message	Memory use
Component initialization	2.94 MB
Controller action start	3.86 MB
Controller render start	6.08 MB
View render complete	6.64 MB

Timers

Total Request Time: 188 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	34.91
Event: Controller.initialize	4.90
Event: Controller.startup	1.38
Controller action	33.35
Event: Controller.beforeRender	10.86
» Processing toolbar data	10.77
Rendering View	83.63
» Event: View.beforeRender	0.26
» Rendering APP/View/Brokerages/view.ctp	0.68
» » 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	82.05
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)
 id121
 parent_id9
 brokerage_id56
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameWalnut Creek, CA, USA
 short_nameWalnut Creek, CA, USA
 group_index
 latitude37.910076
 longitude-122.065186
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-05 17:59:30
 modified2016-04-14 14:56:55
 timezoneAmerica/Los_Angeles
 population67000
 uri/locations/view/121/walnut-creek-ca-usa
 tile_nameWalnut Creek, CA, USA
 Brokerage(array)
 id56
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2513768
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameJ. Rockcliff Realtors
 broker_of_record_name
 short_nameJ Rockcliff Realtors
 usernameJRockcliffWC
 password14a01d92dcd7b0cd5ad6f01dca84a3e626414a24
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionJ. Rockcliff Realtors is the exclusive representative for Leverage Global Partners in Walnut Creek, Concord, Pleasant Hill, Martinez, Alamo, Diablo and Clayton, California. J. Rockcliff Realtors is one of the fastest growing real estate companies in California and has distinguished itself as The East Bay’s Premier Real Estate Company. With offices located in <a href="../../../brokerage-detail/55/J.-Rockcliff-Realtors">LaMorinda</a> (Lafayette, Moraga, Orinda), <a href="../../../brokerage-detail/56/J.-Rockcliff-Realtors">Walnut Creek</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Danville</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Blackhawk</a>, and <a href="../../../brokerage-detail/57/J.-Rockcliff-Realtors">Pleasanton/Dublin/Livermore</a>, experienced Realtors can assist with your home buying or home selling needs in any real estate market. Looking for bank owned properties? We can help. J. Rockcliff Realtors’ Relocation Department provides home buying or home selling assistance around the corner or around the world. As members of Worldwide ERC (Employee Relocation Council), J. Rockcliff handles many corporate relocation moves as well. When listing or selling your home, you can rest assured that J. Rockcliff Realtors can provide the best real estate agents (Realtors) to help you buy or sell your home using the most innovative tools available, including; the finest marketing, the most advanced technology and resources unmatched by any other firm. J. Rockcliff Realtors is strategically positioned to be the company of choice now and in the future. J. Rockcliff Realtors is proudly licensed with the California Bureau of Real Estate - License #01793729. J.Rockcliff also has offices in <a href="../../../brokerage-detail/55/J.-Rockcliff-Realtors">Lafayette</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Danville</a>, and <a href="../../../brokerage-detail/57/J.-Rockcliff-Realtors">Pleasanton</a>.
 communitiesWalnut Creek Concord Pleasant Hill Martinez Clayton Alamo Diablo
 websitehttp://www.rockcliff.com/
 address1700 N. Main Street
 address_2
 cityWalnut Creek
 stateCA
 full_stateCalifornia
 countryUSA
 marketWalnut Creek
 market_2
 postal_code94596
 phone(925) 280-8500
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJeff Sposito
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_emailjsposito@rockcliff.com
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename56.jpg
 logo_filename56.jpg
 contact_image_filename56.jpg
 all_properties_link_image_filename56.jpg
 all_properties_linkhttp://www.rockcliff.com/Rockcliff-Listings#g=2a4505b8-af60-49e2-b0c4-b980136a5da0
 video_embed_code
 contact_video_embed_code
 meta_titleWalnut Creek Real Estate | J. Rockcliff Realtors | Leverage Global Partners
 meta_descriptionJ. Rockcliff Realtors is the exclusive representative for Leverage Global Partners in Walnut Creek, CA, USA.
 meta_keywordsJ. Rockcliff Realtors, Walnut Creek Real Estate, Leverage Global Partners, Jeff Sposito
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-09-26 14:52:34
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/56/j-rockcliff-realtors
 website_shortwww.rockcliff.com
 name_with_locationJ. Rockcliff Realtors
 Image(array)
 id3384
 modelLocation
 model_id121
 tagImage
 namewalnut creek.jpg
 typeimage/jpeg
 size159277
 uri/assets/3384.jpg
 order0
 created2016-04-05 17:58:38
 modified2016-04-14 14:56:55
 1(array)
 Location(array)
 id156
 parent_id7
 brokerage_id37
 typeExclusive
 archived(false)
 use_as_topic(true)
 nameNantucket, MA, USA
 short_nameNantucket, MA, USA
 group_index
 latitude41.283470
 longitude-70.099449
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 15:41:00
 modified2016-04-14 10:55:17
 timezoneAmerica/New_York
 population10500
 uri/locations/view/156/nantucket-ma-usa
 tile_nameNantucket, MA, USA
 Brokerage(array)
 id37
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2456968
 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
 nameCongdon & Coleman Real Estate
 broker_of_record_name
 short_nameCongdon & Coleman
 usernameCongdonColeman
 passwordf9492e65b683bc67dda66f994a01ecfb704a5f81
 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
 descriptionCongdon & Coleman Real Estate is the exclusive representative for Leverage Global Partners in Nantucket, Massachusetts, USA. Resident Experts: Nantucket Real Estate & Summer Rentals Congdon & Coleman Real Estate, founded in 1931, is a fourth generation Nantucket business. It is the only combined Nantucket real estate and insurance company on island. Our real estate agents are all Nantucket island residents who are active in the community and committed to preserving the quality of life here. If you choose to invest in Nantucket real estate, rely on the people who know it best. Congdon & Coleman Real Estate is a full service firm handling listing, selling and rentals. Each of our agents is a Realtor and a member of the Cape Cod & Islands Association of Realtors. We are also members of the Nantucket Association of Real Estate Brokers, which gives us accurate, current information on all properties for sale on Nantucket. When you list your property with Congdon & Coleman, inclusion with this service ensures that your property receives maximum exposure to all agents on Nantucket. Simply put, our brokers can show you any Nantucket real estate for sale on the island.
 communitiesNantucket
 websitehttp://www.congdonandcoleman.com
 address57 Main Street
 address_2
 cityNantucket
 stateMA
 full_stateMassachusetts
 countryUSA
 marketNantucket
 market_2
 postal_code02554
 phone(508) 325-5016
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTom Kennelly
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-tom-kennelly-president-congdon-and-coleman-real-estate/
 contact_big_profile_link_text
 contact_titlePresident, Broker
 contact_dre_num
 contact_quote
 contact_emailtomk@congdonandcoleman.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_filename37.jpg
 logo_filename37.png
 contact_image_filename37.jpg
 all_properties_link_image_filename37.jpg
 all_properties_linkhttp://www.congdonandcoleman.com/nantucket-sales/homes.asp
 video_embed_code
 contact_video_embed_code
 meta_titleNantucket Real Estate | Congdon & Coleman Real Estate | Leverage Global Partners
 meta_descriptionCongdon & Coleman Real Estate is Leverage Global Partners' exclusive representative in Nantucket, MA, USA.
 meta_keywordsNantucket real estate, Massachusetts real estate, Tom Kennelly, Congdon & Coleman, 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-07-24 14:33:33
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/37/congdon-coleman-real-estate
 website_shortwww.congdonandcoleman.com
 name_with_locationCongdon & Coleman Real Estate
 Image(array)
 id20713
 modelLocation
 model_id156
 tagImage
 nameScreen Shot 2016-04-12 at 3.40.28 PM.png
 typeimage/png
 size457517
 uri/assets/20713.png
 order0
 created2016-04-12 15:40:48
 modified2016-04-14 10:55:17
 2(array)
 Location(array)
 id145
 parent_id7
 brokerage_id153
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameGreater Toronto, Ontario, Canada
 short_nameGreater Toronto, Ontario, Canada
 group_index
 latitude43.653225
 longitude-79.383186
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionToronto is perfect for those who love big city life with a neighborhood feel.
 long_descriptionOne of the world’s top ten most economically powerful cities, Toronto is fundamentally a city of neighbourhoods. From the waterfront skyline home to major world class sports teams to the lush parks, trails and ravine systems, it’s a wide cultural network of languages, cuisines and festivals. The city prides itself on its thriving performing arts and entertainment scene and welcomes many A-list stars each year at TIFF. The downtown core, with its principle stock exchange and prestigious universities, is known for its continually booming condominium market. As North America’s third largest concentration of private IT companies, Toronto is truly the economic heart of Canada, remaining highly attractive to investors due to its projected future prosperity and quality of life.
 created2016-04-08 14:32:13
 modified2016-04-08 14:32:13
 timezoneAmerica/New_York
 population2165999
 uri/locations/view/145/greater-toronto-ontario-canada
 tile_nameGreater Toronto, Ontario, Canada
 Brokerage(array)
 id153
 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
 WOEID4118
 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
 nameForest Hill Real Estate Inc
 broker_of_record_name
 short_nameForest Hill Real Estate Inc
 usernameForestHillRealEstate
 passwordf43a3ef674ab80ffe6ede6e641951411f4b7f152
 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
 descriptionForest Hill Real Estate is the exclusive representative for Leverage Global Partners in the Greater Toronto area and Cottage Country, Ontario, Canada. Founded in 1985 Forest Hill Real Estate Inc., has specialized in the sale of prestigious homes, luxury condominiums, country properties, estates, vacant lots and commercial and industrial properties. In the past decade alone, the company has participated in well over ten billion dollars in real estate sales volume. Forest Hill Real Estate Inc., is a premier leader in the Toronto and surrounding areas real estate market. Our fourteen offices are strategically located in Toronto, Muskoka, Kawarthas and Lake Simcoe Cottage Country and opening soon in Oakville, Ontario, as a fast growing upwardly bound and upscale area, we proudly boast 450 sales people….and growing. Forest Hill Real Estate Inc., attributes the tremendous success of the company, to committed personalized client service to both Sellers and Buyers, combined with target marketing, upscale internet networking, sophisticated technology, on-going sales training to further help our very experienced and professional real estate sales associates, our full-time knowledgeable, dedicated support staff is a wonderful asset to our company. Contributing further to the company's success is extensive market research, print advertising, advanced computer technology is always number one in our goals, our weekly in-house meetings and frequent seminars conducted by both real estate and other professionals in the business community, adds to our continued success. Our association with world renowned Who's Who in Luxury Real Estate further builds and enhances our company profile and exposes our listings to an upscale international market through their website. www.luxuryrealestate.com Our own website, www.foresthill.com, is a user friendly and effective way for the public to locate our luxury homes, "first time" buying opportunities, condominium developments, summer homes, and wide range of commercial properties. Our social media department which populates Facebook, LinkedIn, Twitter and Instagram and monitored daily by our in-house marketing staff. It is a pleasure to align ourselves with our esteemed new partner “Leverage Global Part firms from around the world, creating a global network of professionals that serve the relocation needs of homebuyers and sellers, nationally and internationally. Within each market, the consumer and brokerage communities alike have direct access to the President of each exclusive Global Partner. www.leveragere.com As the founder I am proud of our company's success, reputation and accomplishments. Each sales representative is a vital cog in our wheel of our good fortune. Our name says Forest Hill…Our market is simply your neighbourhood.
 communitiesToronto Port Carling Thornhill Bala Port Sandfield
 websitehttp://www.foresthill.com/
 address441 Spadina Road
 address_2
 cityGreater Toronto
 stateOntario
 full_state
 countryCanada
 market
 market_2
 postal_code
 phoneOffice: (416) 488-2875
 phone_2Cell: (416) 464-6344
 phone_3
 wide_contact_image(false)
 contact_nameRonni Fingold
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleFounding Partner
 contact_dre_num
 contact_quote
 contact_emailronnif@foresthill.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_filename153.jpg
 logo_filename153.jpg
 contact_image_filename153.jpg
 all_properties_link_image_filename153.jpg
 all_properties_linkhttp://www.foresthill.com/treblistings/show
 video_embed_code
 contact_video_embed_code
 meta_titleGreater Toronto Real Estate | Forest Hill Real Estate Inc | Leverage Global Partners
 meta_descriptionForest Hill Real Estate is the exclusive representative for Leverage Global Partners in Greater Toronto, Ontario, Canada.
 meta_keywordsForest Hill Real Estate, Toronto Real Estate, Ronni Fingold, Toronto real estate, Port Carling real estate, Thornhill real estate, Peterborough real estate, Bala real estate, Port Sandfield real estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-08-20 15:34:38
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/153/forest-hill-real-estate-inc
 website_shortwww.foresthill.com
 name_with_locationForest Hill Real Estate Inc
 Image(array)
 id20593
 modelLocation
 model_id145
 tagImage
 name153.jpg
 typeimage/jpeg
 size164589
 uri/assets/20593.jpg
 order0
 created2016-04-08 14:27:33
 modified2016-04-08 14:32:13
 3(array)
 Location(array)
 id61
 parent_id9
 brokerage_id63
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameSquaw Valley, Lake Tahoe, CA, USA
 short_nameSquaw Valley, Lake Tahoe, CA, USA
 group_index
 latitude39.163059
 longitude-120.228195
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionSquaw Valley is a dynamic mountain community bringing truth to the mountain lifestyle.
 long_descriptionDuring the last half century, Olympic Valley, also known as Squaw Valley, has grown from an undiscovered mountain valley into a world renown ski community. The most prominent feature is Squaw Valley Ski Area, home to the 1960 Winter Olympic Games, which provides numerous ways to play year round and simply enjoy the mountain lifestyle. Squaw Valley and the nearby Lake Tahoe, are part of Northern California’s nature playground attracting worldwide visitors throughout the changing seasons. Squaw Valley holds a special place in in the hearts of many… full time residents, second homeowners, and visitors alike.
 created2016-04-04 16:35:42
 modified2016-04-18 10:37:15
 timezoneAmerica/Los_Angeles
 population897
 uri/locations/view/61/squaw-valley-lake-tahoe-ca-usa
 tile_nameSquaw Valley, Lake Tahoe, CA, USA
 Brokerage(array)
 id63
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID12798239
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameLawrence Realty
 broker_of_record_name
 short_nameLawrence Realty
 usernameLawrenceRealty
 passwordf19b510a3b7103cacaf2581678aa4565be13bf0a
 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
 descriptionLawrence Realty is the exclusive representative for Leverage Global Partners in Squaw Valley, Alpine Meadows, and Martis Camp, California, USA. Representing Buyers and Sellers in the niche markets of Squaw Valley, Alpine Meadows and Martis Camp. Lawrence Realty is a family owned and operated real estate business located in Squaw Valley, (Lake Tahoe) California. Roland “Larry” Lawrence moved to Squaw Valley in 1969, following his love of the mountains and skiing. He began selling real estate in 1974, became a broker two years later and started Lawrence Realty in 1985. As part of the real estate process, Larry provides a wealth of local knowledge and expertise empowering his clients to make educated decisions within the market place. Lawrence Realty sells residential real estate predominantly in the niche markets of Squaw Valley, the adjacent valley Alpine Meadows, and the nearby private community of Martis Camp. Squaw Valley, home to the world renowned ski area, Squaw Valley USA, along with its sister mountain in the adjacent valley, Alpine Meadows, provide some of the nation’s premiere skiing and riding. The real estate market within these communities ranges from high end ski-in/ski-out homes, to mountain chalets and condominiums in prime locations. Value is largely driven by views, location and accessibility as it relates to the ski slopes. Lawrence Realty, a long time market leader, assists their clientele as they evaluate their priorities in buying a vacation home and guide them through a smooth transaction process. Martis Camp, a private golf and ski community of great distinction in the Tahoe area, has emerged in recent years. Lawrence Realty has been involved in Martis Camp since the beginning, representing buyers as they walked the developer lots, contemplating the factors of sun exposure, lot size, view and proximity to the array of top notch amenities Martis Camp offers. Lawrence Realty has continued to participate in the Martis Camp real estate market representing both buyers and sellers of homes and lots. Larry Lawrence is an active member of the Martis Camp community, both as a property owner and golf member, offering another level of insight to his clientele. Larry and his team members each contribute their own strengths to Lawrence Realty resulting in a dynamic, well rounded group who is well known and well respected in the local community and the broader San Francisco Bay Area client base. Over the years, the referral business amongst clientele has continued to empower this real estate team as they strive to stay at the cutting edge of technology in the ever advancing real estate market.
 communitiesMartis Camp Squaw Valley Alpine Meadows Lake Tahoe
 websitehttp://www.lawrencerealtysquawvalley.com/
 addressP.O. Box 2365
 address_2
 cityOlympic Valley
 stateCA
 full_stateCalifornia
 countryUSA
 marketSquaw Valley, Lake Tahoe
 market_2Martis Camp
 postal_code96146
 phone(530) 583-1529
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameRoland “Larry” Lawrence
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-larry-lawrence-president-lawrence-realty/
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quoteI invite you to contact me personally about Martis Camp and Squaw Valley, Lake Tahoe real estate.
 contact_emailLarry@LawrenceRealty.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_filename63.jpg
 logo_filename63.jpg
 contact_image_filename63.jpg
 all_properties_link_image_filename63.jpg
 all_properties_linkhttp://www.lawrencerealty.com/real-estate-featured/
 video_embed_code
 contact_video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/xtjgpjyC-Mwvk3CWK.js"></script>
 meta_titleMartis Camp and Squaw Valley Real Estate | Lawrence Realty | Leverage Global Partners
 meta_descriptionLawrence Realty is the exclusive representative for Leverage Global Partners in Martis Camp and Squaw Valley, CA, USA.
 meta_keywordsSquaw Valley, Lawrence Realty, squaw valley real estate, squaw valley California real estate, martis camp real estate, Larry Lawrence, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-10-17 17:48:05
 modified2016-10-24 09:54:24
 dre_num012345
 uri/brokerage-detail/63/lawrence-realty
 website_shortwww.lawrencerealtysquawvalley.com
 name_with_locationLawrence Realty
 Image(array)
 id2993
 modelLocation
 model_id61
 tagImage
 name39922990_home_squawsummer.jpg
 typeimage/jpeg
 size344822
 uri/assets/2993.jpg
 order0
 created2016-04-04 16:32:41
 modified2016-04-18 10:37:15
- sidebar_articles(array)
 0(array)
 Article(array)
 id449
 modelArticle
 model_id0
 archived(false)
 medium_featured(true)
 large_featured(false)
 titleSaturday In The Neighborhood: Koh Samui, Thailand
 authorLeverageRE
 date2016-03-24
 lead_inBASK. The island's beaches are an embarrassment of riches. The livelier party crowd hangs at Chaweng Beach, with surf shops and bar crawls along the Green Mango strip. Families gravitate toward lower-key Lamai Beach (less bustling, but still near shopping and restaurants) and Bophut (with its Chinese wooden shop-houses). Backpackers and others who really want to chill head straight to Maenam Beach.
 body<img class="wp-image-12780 aligncenter pure-img" src="/assets/3120.jpg" /> UNWIND. <a href="http://www.tamarindsprings.com/" target="_blank">Tamarind Springs</a>, between Lamai and Chaweng, is renowned for its creative "forest spa" concept, which includes a steam cave and a rock plunge pool. <img class="aligncenter wp-image-12777 pure-img" src="/assets/3121.png" /> CONTEMPLATE. The majority of the island's residents are Buddhist, so beautiful temples abound: Wat Phra Yai, known for its golden, nearly 40-foot Big Buddha; Wat Plai Laem (one of the most colorful complexes); Wat Laem Sor (known for its golden chedi, or pagoda, by the sea) and many <a href="http://samui.sawadee.com/temples/" target="_blank">more</a>. <img class="aligncenter wp-image-12775 pure-img" src="/assets/3122.png" /> DINE. The island possesses prodigious culinary delights. Among the leaders is <a href="http://www.hansarhotels.com/hotels/samui/facilities/h-bistro/" target="_blank">H-Bistro</a> in Bophut, which has frequently wound up on "Best of" lists. <img class="aligncenter wp-image-12781 pure-img" src="/assets/3123.png" /> DIVE. Charter a boat for a day trip exploring <a href="http://www.kosamui.com/ang-thong.htm" target="_blank">Ang Thong National Marine Park</a>, a string of 42 pristine jungle islands offering some of the best kayaking, snorkeling, and diving in the world. Langur monkeys, otters, reef egrets, Hawksbill turtles-they thrive on land and in the secluded bays and lagoons. A major marine spawning ground, it's also home to majestic whale sharks. <img class="aligncenter wp-image-12779 pure-img" src="/assets/3124.png" />
 vimeo_id
 created2016-04-05 14:30:43
 modified2016-04-11 17:08:21
 uri/articles/view/449/saturday-in-the-neighborhood-koh-samui-thailand
 Image(array)
 0(array)
 id3125
 modelArticle
 model_id449
 tagImage
 nameThai-Cover.jpg
 typeimage/jpg
 size1292409
 uri/assets/3125.jpg
 order0
 created2016-04-05 14:30:44
 modified2016-04-11 17:08:21
 1(array)
 Article(array)
 id488
 modelLocation
 model_id28
 archived(false)
 medium_featured(false)
 large_featured(true)
 titleLocation: Malibu
 authorLeverageRE
 date2016-03-30
 lead_inWith the ocean, mountains, sun and sky, discover California dreamin' in the beautiful beach town of Malibu. Breathtaking sunsets and perfect, year-round climate, rugged beaches, numerous hiking trails, and plenty of Hollywood's beautiful people make Malibu an iconic destination.
 bodyMake a reservation to try one of Chef Nobu Matsuhisa's signature dishes, such as Tiradito, Yellowtail Sashimi with Jalapeño, and Black Cod Miso at his beachside restaurant Nobu. Then take the scenic Pacific Coast Highway to Westward Rock, where you can catch the sunset. <img class="aligncenter wp-image-13084 pure-img" src="/assets/3350.png" /> Rent a board from Malibu Surf Shack and catch a wave or paddleboard Malibu's famous Surfrider Beach. More than just a rental shop, the Surf Shack offers surfing, stand-up paddleboard, and kayak lessons, as well as tours of the coast. <img class="aligncenter size-full wp-image-13083 pure-img" src="/assets/3351.jpg" /> Visit Crosscreek Road at Malibu Country Mart, California's premier location for shopping, dining, and relaxing. Unlike more typical stores, Malibu Country Mart goes beyond the usual cookie-cutter consumerism, offering its own unique and upscale boutiques, art galleries, and sculpture gardens. <img class="aligncenter wp-image-13056 pure-img" src="/assets/3352.png" /> Say hi to George, owner of Zuma Canyon Orchids, and pick up one of his orchids, most of which can only be described as "outrageous." Wake up early to grab a fried-egg sandwich at Malibu Farm Pier Cafe. Located at the beginning and end of the pier, the cafe sources all of its organic ingredients and produce locally-some of the eggs even come from the chickens in the owner's backyard. <img class="aligncenter wp-image-13052 pure-img" src="/assets/3353.jpg" /> <h6>Photos courtesy of: <a href="http://www.noburestaurants.com/malibu/experience/" target="_blank">Nobu</a>, <a href="http://malibusurfshack.com/" target="_blank">Malibu Surf Shack</a>, <a href="https://www.facebook.com/malibufarm/photos_stream?tab=photos_stream" target="_blank">Malibu Farm Facebook</a>, <a href="http://www.malibucountrymart.com/" target="_blank">Malibu Country Mart</a></h6>
 vimeo_id
 created2016-04-05 14:35:21
 modified2016-04-11 16:59:36
 uri/articles/view/488/location-malibu
 Image(array)
 0(array)
 id3354
 modelArticle
 model_id488
 tagImage
 nameScreen-Shot-2016-03-28-at-7.01.41-PM.png
 typeimage/png
 size2266902
 uri/assets/3354.png
 order0
 created2016-04-05 14:35:22
 modified2016-04-11 16:59:36
 2(array)
 Article(array)
 id453
 modelArticle
 model_id0
 archived(false)
 medium_featured(false)
 large_featured(false)
 titleShop The Store: Holly Hunt
 authorLeverageRE
 date2016-03-24
 lead_inSince its opening in 1984 in Chicago's Merchandise Mart, Holly Hunt has been delivering well-crafted, modern-designed furniture for every room of the home. In the 30 years since, the company has expanded to showrooms in 26 locations, including New York, Los Angeles, and even London and São Paolo. In addition to offering their own designs, the showroom offers pieces from established designers such as Christian Astuguevielle as well as newcomers like lighting designer Alison Berger and furniture designer Paul Mathieu. For statement lighting, eye- catching tables, or a timeless sofa, Holly Hunt is sure to please, no matter the style or aesthetic of a home.
 body<a href="https://www.hollyhunt.com/ShowProduct.aspx?ProductID=8573&ManufacturerID=33" target="_blank">Sea Urchin Pendant</a> Designer Stefan Gulassa created this pendant light, whose LED lights shine through bubble-inflected glass to create a unique glow. $5,580 <img class="aligncenter wp-image-12742 pure-img" src="/assets/3139.png" /> <a href="https://www.hollyhunt.com/ShowProduct.aspx?ProductID=4940&ManufacturerID=24" target="_blank">Reve Occasional Chair</a> Low-slung and with a generous width, this chair takes cues from Hollywood Regency pieces, but updates them with a slim silhouette. $7,800 <img class="aligncenter wp-image-12743 pure-img" src="/assets/3140.png" /> <a href="https://www.hollyhunt.com/ShowProduct.aspx?ProductID=4748&ManufacturerID=1" target="_blank">São Paolo Sofa</a> The perfect transitional-style sectional, the piece is available in a range of fabrics, from linen to leather. $12,600 as shown <img class="aligncenter size-full wp-image-12746 pure-img" src="/assets/3141.png" /> <a href="https://www.hollyhunt.com/ShowProduct.aspx?ProductID=8559&ManufacturerID=1" target="_blank">Fortis Bed</a> A fabric- wrapped base and headboard combine with a wooden back and matching wing panels in this sleek bed. $17,520 <img class="aligncenter wp-image-12745 pure-img" src="/assets/3142.png" /> <a href="https://www.hollyhunt.com/" target="_blank">Convex Mirror</a> Part wall art, part functional mirror, this piece offers a Mondrian-like wooden frame around a convex mirror to add intrigue to any wall. $5,470 <img class="aligncenter wp-image-12744 pure-img" src="/assets/3143.png" />
 vimeo_id
 created2016-04-05 14:30:48
 modified2016-04-08 09:43:54
 uri/articles/view/453/shop-the-store-holly-hunt
 Image(array)
 0(array)
 id3144
 modelArticle
 model_id453
 tagImage
 nameHolly-Hunt.jpg
 typeimage/jpg
 size2187512
 uri/assets/3144.jpg
 order0
 created2016-04-05 14:30:49
 modified2016-04-08 09:43:54
 3(array)
 Article(array)
 id478
 modelLocation
 model_id92
 archived(false)
 medium_featured(false)
 large_featured(true)
 titleLocation: Maui
 authorLeverageRE
 date2016-03-29
 lead_inRemarkable beaches, magnificent waterfalls and breathtaking views, Maui radiates natural beauty. Settled between two mountains, Maui is referred to as the “Valley Isle,” and is the second largest Hawaiian island and home to Leverage Partner The Wailea Group.
 bodyIt is also home to more than 80 beaches, exhibiting black, white or red sand along its 120 miles of shoreline. Grab your camera and take one of the most scenic drives in the world on the Road to Hana, with over 60 curves and 54 bridges. In the mood for dining or shopping? Then Lahaina, once a thriving whaling port in the mid 1800’s, is the destination for you. Snorkeling, surfing, kiteboarding, and even whale watching are among the many activities to experience on Maui. Countless activities to be had on a little piece of paradise: <img class="aligncenter wp-image-12905 pure-img" src="/assets/3294.png" /> REJUVENATE. Get pampered at the new Andaz Maui at Wailea's <a href="http://maui.andaz.hyatt.com/hyatt/pure/spas/" target="_blank">‘Awili Spa and Salon</a> with treatments featuring custom-blended products from the apothecary bar. <img class="aligncenter wp-image-12900 pure-img" src="/assets/3295.png" /> SWING. Soak up the ocean views on the rugged terrain of the <a href="http://www.waileagolf.com/index.php?linksid=4" target="_blank">Wailea Golf Club's Gold Course</a> or the more player-friendly <a href="http://www.waileagolf.com/index.php?linksid=13" target="_blank">Emerald Course</a>. <img class="aligncenter wp-image-12902 pure-img" src="/assets/3296.png" /> DINE. Tap into the island's Polynesian roots with a visit to the famed <a href="http://www.mamasfishhouse.com/" target="_blank">Mama's Fish House</a> restaurant,a local legend since 1973. Savor traditional fresh fare caught by local fi against the backdrop of a secluded white-sand beach. DRESS. The <a href="http://www.fourseasons.com/maui/services_and_amenities/other_facilities_and_services/shopping_boutiques/" target="_blank">Four Seasons Resort Maui at Wailea</a> has earned its stripes not only as one of the island's premiere hotels, but as a shopping destination, too. Overseen by retail experts Seaside Luxe, three distinct boutiques on the property offer everything from branded resort wear to designer apparel from Tory Burch and Stella McCartney. <img class="aligncenter wp-image-12901 pure-img" src="/assets/3297.png" /> SPLASH. With locations in Kihei and Lahaina, the pros at <a href="http://www.mauiwaveriders.com/" target="_blank">Maui Wave Riders</a> school have aspiring surfers and stand-up paddlers covered. <img class="aligncenter wp-image-12906 pure-img" src="/assets/3298.png" />
 vimeo_id
 created2016-04-05 14:34:57
 modified2016-04-14 12:19:38
 uri/articles/view/478/location-maui
 Image(array)
 0(array)
 id3299
 modelArticle
 model_id478
 tagImage
 nameScreen-Shot-2016-03-28-at-7.16.19-PM.png
 typeimage/png
 size1869697
 uri/assets/3299.png
 order0
 created2016-04-05 14:34:58
 modified2016-04-14 12:19:38
- main_article(empty)
- locations(array)
 0(array)
 Location(array)
 id84
 parent_id7
 brokerage_id240
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameCity of Pittsburgh, PA, USA
 short_nameCity of Pittsburgh, PA, USA
 group_index
 latitude40.613708
 longitude-80.056023
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionWhere three rivers meet - Pittsburgh’s appeal begins with its scenery.
 long_descriptionPittsburgh, Pennsylvania is a place where two rivers merge to form the mighty Ohio River. Over the years, the waterways were used strategically for exploration and trade. Today, the rivers provide a beautiful, scenic background for a city that is receiving many accolades for its quality of life, leisure activities, restaurants and affordable housing. While the Pittsburgh market may not boast the kind of blockbuster price tags found in other comparable cities, Pittsburgh is full of charming, older houses nestled in the hills and valleys around our region as well as sleek lofts and penthouses with incredible views.
 created2016-04-05 10:57:49
 modified2016-04-05 10:57:49
 timezoneAmerica/New_York
 population305000
 uri/locations/view/84/city-of-pittsburgh-pa-usa
 tile_nameCity of Pittsburgh, PA, USA
 Brokerage(array)
 id240
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2473224
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contactsannalisa.povlock@leveragere.com
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameAchieve Realty
 broker_of_record_name
 short_nameAchieve Realty
 usernameAchieveRealty
 password8b469e715f5dfcdc32692d657c20869180bcca9d
 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
 descriptionAchieve Realty is the exclusive representative for Leverage Global Partners in the City of Pittsburgh, North Allegheny County, West Allegheny County, Butler County, including communities such as Bradford Woods, Collier Township, Fox Chapel, Franklin Park, Hampton Township, Marshall Township, McCandless Township, Ohio Township, Pine Township, Richland Township, Sewickley, Adams Township, Cranberry Township, and Penn Township, Pennsylvania, USA. Achieve Realty, Inc. is a real estate brokerage headquartered in the Pittsburgh, Pennsylvania suburb of Wexford. The firm is owed by husband and wife lawyers Lawton and Kristen Stokes. The Stokes’ have been engaged in the title insurance business since 1993 and in the real estate brokerage business since 2000. Lawton Stokes is also an Associate Broker. Together, the Stokes’ provide a wealth of support and guidance to the team of sales agents at Achieve Realty. Achieve Realty is comprised of many of the area’s top real estate sales agents. From new construction to existing homes, from condominiums to townhouses, we have the residential market covered. Thanks to our tremendous affiliations, Achieve Realty is a one-stop shop for all of the ancillary services including mortgage, title and homeowners insurance. Achieve Realty is a proud member of the Leverage Global Partners network.
 communitiesCity of Pittsburgh North Allegheny County West Allegheny County Butler County Bradford Woods Collier Township Fox Chapel Franklin Park Hampton Township Marshall Township McCandless Township Ohio Township Pine Township Richland Township Sewickley Adams Township Cranberry Township Penn Township
 websitehttp://www.achieverealty.net/
 address10475 Perry Highway
 address_2
 cityWexford
 statePA
 full_state
 countryUSA
 marketCity of Pittsburgh
 market_2
 postal_code
 phone(724) 933-1980
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameLawton Stokes
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner
 contact_dre_num
 contact_quote
 contact_emailadmin@allsett.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_filename240.jpg
 logo_filename240.png
 contact_image_filename240.jpg
 all_properties_link_image_filename240.jpg
 all_properties_linkhttp://www.achieverealty.net/listings/query.php?aid=&oid=&aname=&aimg=&chome=&odoor=&agent_hasfeat=&state=42&newsearch=1&newsearchresults=1&saved_search=0&keySession=&sort_by=1&property_category=1&pricemin=&pricemax=&bedrooms=&bedmore=1&bath_full=&bath_th
 video_embed_code
 contact_video_embed_code
 meta_titleCity of Pittsburgh Real Estate | Achieve Realty | Leverage Global Partners
 meta_descriptionAchieve Realty is the exclusive representative for Leverage Global Partners in the City of Pittsburgh, PA, USA.
 meta_keywordsAchieve Realty, Pittsburgh real estate, leverage global partners, Lawton Stokes
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2016-02-03 17:08:44
 modified2022-01-13 09:50:57
 dre_num012345
 uri/brokerage-detail/240/achieve-realty
 website_shortwww.achieverealty.net
 name_with_locationAchieve Realty
 Image(array)
 id3018
 modelLocation
 model_id84
 tagImage
 name240.jpg
 typeimage/jpeg
 size177532
 uri/assets/3018.jpg
 order0
 created2016-04-05 10:52:25
 modified2016-04-05 10:57:49
- 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)
 brokerageAchieve Realty, Wexford
- brokerage(array)
 Brokerage(array)
 id240
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2473224
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contactsannalisa.povlock@leveragere.com
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameAchieve Realty
 broker_of_record_name
 short_nameAchieve Realty
 usernameAchieveRealty
 password8b469e715f5dfcdc32692d657c20869180bcca9d
 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
 descriptionAchieve Realty is the exclusive representative for Leverage Global Partners in the City of Pittsburgh, North Allegheny County, West Allegheny County, Butler County, including communities such as Bradford Woods, Collier Township, Fox Chapel, Franklin Park, Hampton Township, Marshall Township, McCandless Township, Ohio Township, Pine Township, Richland Township, Sewickley, Adams Township, Cranberry Township, and Penn Township, Pennsylvania, USA. Achieve Realty, Inc. is a real estate brokerage headquartered in the Pittsburgh, Pennsylvania suburb of Wexford. The firm is owed by husband and wife lawyers Lawton and Kristen Stokes. The Stokes’ have been engaged in the title insurance business since 1993 and in the real estate brokerage business since 2000. Lawton Stokes is also an Associate Broker. Together, the Stokes’ provide a wealth of support and guidance to the team of sales agents at Achieve Realty. Achieve Realty is comprised of many of the area’s top real estate sales agents. From new construction to existing homes, from condominiums to townhouses, we have the residential market covered. Thanks to our tremendous affiliations, Achieve Realty is a one-stop shop for all of the ancillary services including mortgage, title and homeowners insurance. Achieve Realty is a proud member of the Leverage Global Partners network.
 communitiesCity of Pittsburgh North Allegheny County West Allegheny County Butler County Bradford Woods Collier Township Fox Chapel Franklin Park Hampton Township Marshall Township McCandless Township Ohio Township Pine Township Richland Township Sewickley Adams Township Cranberry Township Penn Township
 websitehttp://www.achieverealty.net/
 address10475 Perry Highway
 address_2
 cityWexford
 statePA
 full_state
 countryUSA
 marketCity of Pittsburgh
 market_2
 postal_code
 phone(724) 933-1980
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameLawton Stokes
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner
 contact_dre_num
 contact_quote
 contact_emailadmin@allsett.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_filename240.jpg
 logo_filename240.png
 contact_image_filename240.jpg
 all_properties_link_image_filename240.jpg
 all_properties_linkhttp://www.achieverealty.net/listings/query.php?aid=&oid=&aname=&aimg=&chome=&odoor=&agent_hasfeat=&state=42&newsearch=1&newsearchresults=1&saved_search=0&keySession=&sort_by=1&property_category=1&pricemin=&pricemax=&bedrooms=&bedmore=1&bath_full=&bath_th
 video_embed_code
 contact_video_embed_code
 meta_titleCity of Pittsburgh Real Estate | Achieve Realty | Leverage Global Partners
 meta_descriptionAchieve Realty is the exclusive representative for Leverage Global Partners in the City of Pittsburgh, PA, USA.
 meta_keywordsAchieve Realty, Pittsburgh real estate, leverage global partners, Lawton Stokes
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2016-02-03 17:08:44
 modified2022-01-13 09:50:57
 dre_num012345
 uri/brokerage-detail/240/achieve-realty
 website_shortwww.achieverealty.net
 name_with_locationAchieve Realty
 Logo(array)
 id2932
 modelBrokerage
 model_id240
 tagLogo
 name240.png
 typeimage/png
 size15740
 uri/assets/2932.png
 order0
 created2016-03-30 11:45:46
 modified2022-01-13 09:50:57
 MainImage(array)
 id2931
 modelBrokerage
 model_id240
 tagMainImage
 name240.jpg
 typeimage/jpg
 size490879
 uri/assets/2931.jpg
 order0
 created2016-03-30 11:45:46
 modified2022-01-13 09:50:57
 ContactImage(array)
 id2933
 modelBrokerage
 model_id240
 tagContactImage
 name240.jpg
 typeimage/jpg
 size66335
 uri/assets/2933.jpg
 order0
 created2016-03-30 11:45:46
 modified2022-01-13 09:50:57
 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/240/achieve-realty
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/brokerage-detail/240/achieve-realty
Remote Port	16486
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	162.159.115.41
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept Encoding	gzip, br
Http Accept	/
Http Cf Ray	a09d1ce6188bbd4a-CMH
Http X Forwarded For	216.73.216.172
Proxy-nokeepalive	1
Ssl Tls Sni	staging2.leveragere.com
Https	on
Passenger Download Native Support Binary	0
Passenger Compile Native Support Binary	0
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Unique Id	aioacagWUmgYuyi40B7u5QAAAUw
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	aioacagWUmgYuyi40B7u5QAAAUw
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781144177.7152
Request Time	1781144177

====

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

Achieve Realty

Connect With Us

Achieve Realty Featured Properties

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 12 ms Total Queries: 10 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 12 ms
Total Queries: 10 queries