Locations / San Carlos, CA, USA

San Carlos, CA, USA

More Information Coming Soon!

Location Represented By

License #: 012345

8:27pm local time

Partner Search

Find partners with a map-based search

Related Locations

Tampa, FL, USA

Redlands, CA, USA

Telluride, CO, USA

Everyone loves Telluride - the lifestyle is the best!

Kiawah Island, SC, USA

Kiawah and Seabrook Islands – luxury accommodations amidst championship golf courses and pristine beaches.

Related Partners

Quinta Properties

+351 289 396 073 | Email
License #: 012345

Mountain Oak Properties

(828) 318-8801 | Email
License #: 012345

Curri Properties

Cell: (321) 961-4487 | Email
License #: 012345

Marshall Realty

650-873-6844 | Email
License #: 012345

Recent Property Listings

Pretty Pretty Piece of Land

980 MARTIN LUTHER KING ROAD
Pawleys Island, SC 29585
$680,000

4311 Carpinteria Avenue

4311 Carpinteria Avenue
Santa Barbara, CA 93103
$1,475,000

Lovely & Detailed Remodel in South Pasadena

1817 Spruce Street
South Pasadena, CA 91030
$1,780,000

Beautiful Colonial in Legacy Woods

15 Shadowbrook Crossing
East Greenwich, RI 02818
$1,300,000

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

Array
(
)

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

Cake Params
- plugin(null)
- controllerlocations
- actionview
- named(empty)
- pass(array)
  0180
  1san-carlos-ca-usa
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys(array)
  0controller
  1action
- options(array)
  defaultRoute(true)
- defaults(array)
  plugin(null)
- template/:controller/:action/*
====

Sql Log

Sql Logs

default

Total Time: 20 ms
Total Queries: 19 queries

Query	Affected	Num. rows	Took (ms)	Actions
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`, `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`.`assets` AS `Image` ON (`Image`.`model_id` = `Location`.`id` AND `Image`.`model` = 'Location' AND `Image`.`tag` = 'Image') WHERE `Location`.`id` = 180 AND `Location`.`archived` = '0' LIMIT 1	1	1	0
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `AccountExecutive`.`id`, `AccountExecutive`.`type`, `AccountExecutive`.`brokerage_id`, `AccountExecutive`.`email`, `AccountExecutive`.`password`, `AccountExecutive`.`recover_hash`, `AccountExecutive`.`first_name`, `AccountExecutive`.`last_name`, `AccountExecutive`.`title`, `AccountExecutive`.`dre_num`, `AccountExecutive`.`phone`, `AccountExecutive`.`max_luxury_feed_properties`, `AccountExecutive`.`headshot_filename`, `AccountExecutive`.`bio`, `AccountExecutive`.`brokerage_name_override`, `AccountExecutive`.`stripe_customer_id`, `AccountExecutive`.`digital_ad_first_free_month_coupon`, `AccountExecutive`.`modified`, `AccountExecutive`.`created`, `AccountExecutive`.`notified`, (CONCAT(`AccountExecutive`.`first_name`, " ", `AccountExecutive`.`last_name`)) AS `AccountExecutive__full_name`, `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`, `MainArticle`.`id`, `MainArticle`.`model`, `MainArticle`.`model_id`, `MainArticle`.`archived`, `MainArticle`.`medium_featured`, `MainArticle`.`large_featured`, `MainArticle`.`title`, `MainArticle`.`author`, `MainArticle`.`date`, `MainArticle`.`lead_in`, `MainArticle`.`body`, `MainArticle`.`vimeo_id`, `MainArticle`.`created`, `MainArticle`.`modified` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` LEFT JOIN `leveragere_staging2`.`users` AS `AccountExecutive` ON (`Brokerage`.`account_executive_id` = `AccountExecutive`.`id`) 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') LEFT JOIN `leveragere_staging2`.`articles` AS `MainArticle` ON (`MainArticle`.`model_id` = `Brokerage`.`id` AND `MainArticle`.`model` = 'Brokerage') WHERE `Brokerage`.`id` = 242 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` = (242) 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` FROM `leveragere_staging2`.`locations` AS `Location` WHERE `Location`.`brokerage_id` = (242)	1	1	0
SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name` FROM `leveragere_staging2`.`users` AS `User` WHERE `User`.`brokerage_id` = (242)	0	0	0
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` = 'Location' AND `Article`.`model_id` = 180 LIMIT 1	0	0	1	maybe slow
SELECT `Location`.`id`, `Location`.`name`, `Location`.`parent_id` FROM `leveragere_staging2`.`locations` AS `Location` WHERE `Location`.`id` = 180 AND `Location`.`archived` = '0' LIMIT 1	1	1	0
SELECT `Location`.`id`, `Location`.`name` FROM `leveragere_staging2`.`locations` AS `Location` WHERE `Location`.`parent_id` = 180	0	0	0
SELECT `Location`.`id`, `Location`.`brokerage_id` FROM `leveragere_staging2`.`locations` AS `Location` WHERE `Location`.`brokerage_id` != 0 AND `Location`.`id` IS NULL	0	0	0
SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created`, `PrimaryPropertyCategory`.`id`, `PrimaryPropertyCategory`.`name`, `PrimaryPropertyCategory`.`created`, `PrimaryPropertyCategory`.`modified`, `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`, `StripeSubscription`.`id`, `StripeSubscription`.`brokerage_id`, `StripeSubscription`.`user_id`, `StripeSubscription`.`property_id`, `StripeSubscription`.`type`, `StripeSubscription`.`stripe_id`, `StripeSubscription`.`stripe_customer_id`, `StripeSubscription`.`stripe_checkout_email`, `StripeSubscription`.`stripe_promotion_code`, `StripeSubscription`.`stripe_promotion_code_id`, `StripeSubscription`.`stripe_coupon_code_id`, `StripeSubscription`.`status`, `StripeSubscription`.`current_period_end`, `StripeSubscription`.`cancel_at_period_end`, `StripeSubscription`.`ended`, `StripeSubscription`.`last_change`, `StripeSubscription`.`last_activity_email_sent`, `StripeSubscription`.`created`, `StripeSubscription`.`modified`, `GlobalReachReport`.`id`, `GlobalReachReport`.`property_id`, `GlobalReachReport`.`wsj_desktop`, `GlobalReachReport`.`wsj_mobile`, `GlobalReachReport`.`wsj_expires`, `GlobalReachReport`.`wsj_capture_started`, `GlobalReachReport`.`mg_desktop`, `GlobalReachReport`.`mg_mobile`, `GlobalReachReport`.`mg_expires`, `GlobalReachReport`.`mg_capture_started`, `GlobalReachReport`.`bp_desktop`, `GlobalReachReport`.`bp_mobile`, `GlobalReachReport`.`bp_expires`, `GlobalReachReport`.`gp_capture_started`, `GlobalReachReport`.`mw_desktop`, `GlobalReachReport`.`mw_mobile`, `GlobalReachReport`.`mw_expires`, `GlobalReachReport`.`mw_capture_started`, `GlobalReachReport`.`ft_desktop`, `GlobalReachReport`.`ft_mobile`, `GlobalReachReport`.`ft_expires`, `GlobalReachReport`.`ft_capture_started`, `GlobalReachReport`.`nikkei_desktop`, `GlobalReachReport`.`nikkei_mobile`, `GlobalReachReport`.`nikkei_expires`, `GlobalReachReport`.`nikkei_capture_started`, `GlobalReachReport`.`pgl_desktop`, `GlobalReachReport`.`pgl_mobile`, `GlobalReachReport`.`pgl_expires`, `GlobalReachReport`.`pgl_capture_started`, `GlobalReachReport`.`robb_desktop`, `GlobalReachReport`.`robb_mobile`, `GlobalReachReport`.`robb_expires`, `GlobalReachReport`.`robb_capture_started`, `GlobalReachReport`.`juwai_desktop`, `GlobalReachReport`.`juwai_mobile`, `GlobalReachReport`.`juwai_expires`, `GlobalReachReport`.`juwai_capture_started`, `GlobalReachReport`.`leverage_desktop`, `GlobalReachReport`.`leverage_mobile`, `GlobalReachReport`.`leverage_expires`, `GlobalReachReport`.`leverage_capture_started`, `GlobalReachReport`.`created`, `GlobalReachReport`.`modified` FROM `leveragere_staging2`.`properties` AS `Property` LEFT JOIN `leveragere_staging2`.`property_categories` AS `PrimaryPropertyCategory` ON (`Property`.`primary_property_category_id` = `PrimaryPropertyCategory`.`id`) LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Property`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`stripe_subscriptions` AS `StripeSubscription` ON (`StripeSubscription`.`property_id` = `Property`.`id` AND `StripeSubscription`.`status` = 'active') LEFT JOIN `leveragere_staging2`.`global_reach_reports` AS `GlobalReachReport` ON (`GlobalReachReport`.`property_id` = `Property`.`id`) WHERE `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`brokerage_id` IS NULL AND `Property`.`incomplete` = '0'	0	0	1	maybe slow
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 `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` 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') WHERE `Brokerage`.`archived` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	4
SELECT `Property`.`id` FROM `leveragere_staging2`.`properties` AS `Property` WHERE `Property`.`archived` = '0' AND `Property`.`incomplete` = '0' ORDER BY `Property`.`created` DESC LIMIT 50	50	50	3	maybe slow
SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created`, `PrimaryPropertyCategory`.`id`, `PrimaryPropertyCategory`.`name`, `PrimaryPropertyCategory`.`created`, `PrimaryPropertyCategory`.`modified`, `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`, `StripeSubscription`.`id`, `StripeSubscription`.`brokerage_id`, `StripeSubscription`.`user_id`, `StripeSubscription`.`property_id`, `StripeSubscription`.`type`, `StripeSubscription`.`stripe_id`, `StripeSubscription`.`stripe_customer_id`, `StripeSubscription`.`stripe_checkout_email`, `StripeSubscription`.`stripe_promotion_code`, `StripeSubscription`.`stripe_promotion_code_id`, `StripeSubscription`.`stripe_coupon_code_id`, `StripeSubscription`.`status`, `StripeSubscription`.`current_period_end`, `StripeSubscription`.`cancel_at_period_end`, `StripeSubscription`.`ended`, `StripeSubscription`.`last_change`, `StripeSubscription`.`last_activity_email_sent`, `StripeSubscription`.`created`, `StripeSubscription`.`modified`, `GlobalReachReport`.`id`, `GlobalReachReport`.`property_id`, `GlobalReachReport`.`wsj_desktop`, `GlobalReachReport`.`wsj_mobile`, `GlobalReachReport`.`wsj_expires`, `GlobalReachReport`.`wsj_capture_started`, `GlobalReachReport`.`mg_desktop`, `GlobalReachReport`.`mg_mobile`, `GlobalReachReport`.`mg_expires`, `GlobalReachReport`.`mg_capture_started`, `GlobalReachReport`.`bp_desktop`, `GlobalReachReport`.`bp_mobile`, `GlobalReachReport`.`bp_expires`, `GlobalReachReport`.`gp_capture_started`, `GlobalReachReport`.`mw_desktop`, `GlobalReachReport`.`mw_mobile`, `GlobalReachReport`.`mw_expires`, `GlobalReachReport`.`mw_capture_started`, `GlobalReachReport`.`ft_desktop`, `GlobalReachReport`.`ft_mobile`, `GlobalReachReport`.`ft_expires`, `GlobalReachReport`.`ft_capture_started`, `GlobalReachReport`.`nikkei_desktop`, `GlobalReachReport`.`nikkei_mobile`, `GlobalReachReport`.`nikkei_expires`, `GlobalReachReport`.`nikkei_capture_started`, `GlobalReachReport`.`pgl_desktop`, `GlobalReachReport`.`pgl_mobile`, `GlobalReachReport`.`pgl_expires`, `GlobalReachReport`.`pgl_capture_started`, `GlobalReachReport`.`robb_desktop`, `GlobalReachReport`.`robb_mobile`, `GlobalReachReport`.`robb_expires`, `GlobalReachReport`.`robb_capture_started`, `GlobalReachReport`.`juwai_desktop`, `GlobalReachReport`.`juwai_mobile`, `GlobalReachReport`.`juwai_expires`, `GlobalReachReport`.`juwai_capture_started`, `GlobalReachReport`.`leverage_desktop`, `GlobalReachReport`.`leverage_mobile`, `GlobalReachReport`.`leverage_expires`, `GlobalReachReport`.`leverage_capture_started`, `GlobalReachReport`.`created`, `GlobalReachReport`.`modified` FROM `leveragere_staging2`.`properties` AS `Property` LEFT JOIN `leveragere_staging2`.`property_categories` AS `PrimaryPropertyCategory` ON (`Property`.`primary_property_category_id` = `PrimaryPropertyCategory`.`id`) LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Property`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`stripe_subscriptions` AS `StripeSubscription` ON (`StripeSubscription`.`property_id` = `Property`.`id` AND `StripeSubscription`.`status` = 'active') LEFT JOIN `leveragere_staging2`.`global_reach_reports` AS `GlobalReachReport` ON (`GlobalReachReport`.`property_id` = `Property`.`id`) WHERE `Property`.`id` IN (3762, 3761, 3760, 3759, 3758, 3757, 3756, 3755, 3754, 3753, 3752, 3749, 3747, 3745, 3743, 3742, 3741, 3740, 3739, 3738, 3736, 3734, 3733, 3732, 3731, 3730, 3729, 3728, 3727, 3726, 3724, 3723, 3722, 3721, 3719, 3718, 3717, 3716, 3715, 3714, 3713, 3712, 3711, 3710, 3708, 3707, 3706, 3705, 3704, 3703) AND `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	5	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` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (3747, 3760, 3734, 3703) ORDER BY `Image`.`order` ASC	55	55	1
SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (3747, 3760, 3734, 3703) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	3	3	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (3747, 3760, 3734, 3703) AND `PropertiesSecondaryPropertyCategory`.`property_category_id` = `SecondaryPropertyCategory`.`id`)	0	0	0
SELECT `PropertyFeature`.`id`, `PropertyFeature`.`name`, `PropertyFeature`.`additional`, `PropertyFeature`.`created`, `PropertyFeature`.`modified`, `PropertiesPropertyFeature`.`id`, `PropertiesPropertyFeature`.`property_id`, `PropertiesPropertyFeature`.`property_feature_id` FROM `leveragere_staging2`.`property_features` AS `PropertyFeature` JOIN `leveragere_staging2`.`properties_property_features` AS `PropertiesPropertyFeature` ON (`PropertiesPropertyFeature`.`property_id` IN (3747, 3760, 3734, 3703) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	6	6	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (3747, 3760, 3734, 3703) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	1	1	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 11.62 MB

Message	Memory use
Component initialization	2.88 MB
Controller action start	3.81 MB
Controller render start	6.68 MB
View render complete	7.23 MB

Timers

Total Request Time: 316 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	129.52
Event: Controller.initialize	4.16
Event: Controller.startup	1.23
Controller action	54.23
Event: Controller.beforeRender	9.20
» Processing toolbar data	9.11
Rendering View	93.29
» Event: View.beforeRender	0.28
» Rendering APP/View/Locations/view.ctp	2.56
» » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.13
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.16
» » Rendering APP/View/Elements/sidebar/brokerage_list.ctp	0.15
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.23
» » » Rendering APP/View/Elements/static_property_price.ctp	0.36
» » » Rendering APP/View/Elements/static_property_price.ctp #2	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.13
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.22
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	89.75
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- sidebar_properties(array)
 0(array)
 Property(array)
 id3747
 brokerage_id70
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 namePretty Pretty Piece of Land
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(false)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time2018-08-22 14:52:23
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_urlhttps://propertylistings.ft.com/homes/2552920/new-york-property-for-sale/7-hubert-street-new-york-new-york
 nyt_detail_urlhttps://www.nytimes.com/real-estate/usa/ca/beverly-hills/homes-for-sale/9491-rembert-ln/1995-801-1-19-524596
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(false)
 description8 Acres Located On Pawleys Island, Approximately 70 Miles Fromcharleston And 25 Miles South Of Myrtle Beach. It Is Known As One Of The Oldest And Most Unique Summer Resorts On The East Coast With Nearby Golf Courses. Home Of The Famous Rope Hammocks And World Known Hammock Shops And The Unspoiled, Casual, Delightful Stretch Of Wide Beach And Sand Dunes, Create A Charming Place To Live. Housing Developers Are Welcome. Pawleys Continues To Be Known For Its Shoeless, Carefree, Laid-back Life Style, Which Includes Crabbing In The Creek, Fishing, And The Stories Of Ghosts (Gray Man & Alice...to Name A Few). Come Enjoy This Charming Lifestyle.
 address980 MARTIN LUTHER KING ROAD
 address_2
 cityPawleys Island
 stateSC
 postal_code29585
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price680000
 price_20
 price_usd0
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms0
 bedrooms_20
 bathrooms0
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_typeapartment
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type1
 juwai_property_type
 juwai_category
 propgolux_property_style1
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude33.420074
 longitude-79.183090
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(false)
 invalid(false)
 mlsidx_full_address980 MARTIN LUTHER KING ROAD Pawleys Island SC
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2019-10-29 18:47:35
 created2018-05-02 14:29:44
 uri/property-detail/3747/980-martin-luther-king-road-pawleys-island-sc-29585-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3747/980-martin-luther-king-road-pawleys-island-sc-29585-usa
 address_concat980 MARTIN LUTHER KING ROAD Pawleys Island SC 29585 USA
 google_maps_query_string980+MARTIN+LUTHER+KING+ROAD++Pawleys+Island+SC+29585+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 680,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty0
 bathrooms_pretty0
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms0
 date_listed2018-05-02
 overridden_brokerage_nameQuinta Properties
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id70
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties3
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id13
 WOEID23706483
 timezoneEurope/Lisbon
 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_id9
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameQuinta Properties
 broker_of_record_name
 short_nameQuinta Properties
 usernameQuintaProperties
 passwordbfa20d0f7d557565a3e9f0589db0a06e4c9546f3
 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
 descriptionQuinta Properties is the exclusive representative for Leverage Global Partners in the Algarve, Portugal. Quinta Properties deal with some of the most exclusive luxury villas and exciting property in and around Quinta do Lago. As the chosen associates of Savills, they offer in-depth knowledge and experience to meet your real estate needs. Anyone who knows Quinta Properties and has dealt with Alison, Kerstin, and their team will know they are passionate about property. Their wide experience in the local property market enables them to recommend legal, architectural, financial and construction professionals who understand the needs of prospective buyers in the locality. Quinta Properties are registered with the Portuguese authorities as licensed agents, meeting stringent standards. Their staff are fluent in English, German, French, and Portuguese. "We make it our business to support you, to explain all the options, procedures and pitfalls and to carefully guide you through the entire process from purchasing to sellingluxury Quinta do Lago villas and other fine properties in the Quinta do Lago and the whole Algarve area." --Alison Buechner Hojbjerg and Kerstin Buechner
 communitiesalgarve the algarve quinta do lago
 websitehttp://www.quintaproperty.com/
 addressAvenida da Gondra
 address_2Quinta do Lago
 cityAlmancil
 state
 full_state
 countryPortugal
 marketAlgarve
 market_2
 postal_code8135-162
 phone+351 289 396 073
 phone_2+351 289 398086 (Fax)
 phone_3
 wide_contact_image(false)
 contact_nameAlison Buechner Hojbjerg and Kerstin Buechner
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleDirectors
 contact_dre_num
 contact_quoteWe invite you to contact us about real estate in the Algarve
 contact_email[email protected]
 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_filename70.jpg
 logo_filename70.jpg
 contact_image_filename70.jpg
 all_properties_link_image_filename70.jpg
 all_properties_linkhttp://www.quintaproperty.com/algarve/
 video_embed_code
 contact_video_embed_code
 meta_titleAlgarve Real Estate | Quinta Properties | Leverage Global Partners
 meta_descriptionQuinta Properties is the exclusive representative for Leverage Global Partners in the Algarve, Portugal.
 meta_keywordsQuinta Properties, Algarve Real Estate, Leverage Global Partners, Alison Buechner Hojbjerg
 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-11-15 11:23:29
 modified2020-11-20 12:05:11
 dre_num012345
 uri/brokerage-detail/70/quinta-properties
 website_shortwww.quintaproperty.com
 name_with_locationQuinta Properties
 mlsidx_id_array(array)
 09
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id22844
 modelProperty
 model_id3747
 tagImage
 name1724068_5-1.jpg
 typeimage/jpeg
 size102864
 uri/assets/22844.jpg
 order0
 created2018-05-02 14:29:45
 modified2018-05-02 14:35:42
 1(array)
 id22845
 modelProperty
 model_id3747
 tagImage
 name1724068_5-2.jpg
 typeimage/jpeg
 size86680
 uri/assets/22845.jpg
 order1
 created2018-05-02 14:29:45
 modified2018-05-02 14:35:42
 2(array)
 id22846
 modelProperty
 model_id3747
 tagImage
 name1724068_5-3.jpg
 typeimage/jpeg
 size86613
 uri/assets/22846.jpg
 order2
 created2018-05-02 14:29:45
 modified2018-05-02 14:35:42
 3(array)
 id22847
 modelProperty
 model_id3747
 tagImage
 name1724068_5-4.jpg
 typeimage/jpeg
 size130988
 uri/assets/22847.jpg
 order3
 created2018-05-02 14:29:45
 modified2018-05-02 14:35:42
 4(array)
 id22848
 modelProperty
 model_id3747
 tagImage
 name1724068_5-5.jpg
 typeimage/jpeg
 size138280
 uri/assets/22848.jpg
 order4
 created2018-05-02 14:29:45
 modified2018-05-02 14:35:42
 5(array)
 id22849
 modelProperty
 model_id3747
 tagImage
 name1724068_5-6.jpg
 typeimage/jpeg
 size140711
 uri/assets/22849.jpg
 order5
 created2018-05-02 14:29:46
 modified2018-05-02 14:35:42
 6(array)
 id22850
 modelProperty
 model_id3747
 tagImage
 name1724068_5-7.jpg
 typeimage/jpeg
 size212343
 uri/assets/22850.jpg
 order6
 created2018-05-02 14:29:46
 modified2018-05-02 14:35:42
 7(array)
 id22851
 modelProperty
 model_id3747
 tagImage
 name1724068_5-8.jpg
 typeimage/jpeg
 size199205
 uri/assets/22851.jpg
 order7
 created2018-05-02 14:29:46
 modified2018-05-02 14:35:42
 8(array)
 id22852
 modelProperty
 model_id3747
 tagImage
 name1724068_5-9.jpg
 typeimage/jpeg
 size203812
 uri/assets/22852.jpg
 order8
 created2018-05-02 14:29:46
 modified2018-05-02 14:35:42
 9(array)
 id22853
 modelProperty
 model_id3747
 tagImage
 name1724068_5-10.jpg
 typeimage/jpeg
 size205836
 uri/assets/22853.jpg
 order9
 created2018-05-02 14:29:47
 modified2018-05-02 14:35:42
 10(array)
 id22854
 modelProperty
 model_id3747
 tagImage
 name1724068_5-11.jpg
 typeimage/jpeg
 size219211
 uri/assets/22854.jpg
 order10
 created2018-05-02 14:29:47
 modified2018-05-02 14:35:42
 11(array)
 id22855
 modelProperty
 model_id3747
 tagImage
 name1724068_5-12.jpg
 typeimage/jpeg
 size195677
 uri/assets/22855.jpg
 order11
 created2018-05-02 14:29:47
 modified2018-05-02 14:35:42
 12(array)
 id22856
 modelProperty
 model_id3747
 tagImage
 name1724068_5-13.jpg
 typeimage/jpeg
 size192282
 uri/assets/22856.jpg
 order12
 created2018-05-02 14:29:47
 modified2018-05-02 14:35:42
 13(array)
 id22857
 modelProperty
 model_id3747
 tagImage
 name1724068_5-14.jpg
 typeimage/jpeg
 size185810
 uri/assets/22857.jpg
 order13
 created2018-05-02 14:29:47
 modified2018-05-02 14:35:42
 14(array)
 id22858
 modelProperty
 model_id3747
 tagImage
 name1724068_5-15.jpg
 typeimage/jpeg
 size190086
 uri/assets/22858.jpg
 order14
 created2018-05-02 14:29:48
 modified2018-05-02 14:35:42
 User(array)
 0(array)
 id1281
 typeAgent
 brokerage_id70
 email[email protected]
 password6e83e74e5aad7dc2404b41f4dad53b857b4a34ae
 recover_hash
 first_nameMike
 last_nameStratford
 title
 dre_num
 phone4246341622
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2018-08-22 14:50:21
 created2018-08-22 14:50:21
 notified(false)
 full_nameMike Stratford
 uri/agent-detail/1281/mike-stratford
 profile_complete(true)
 UsersProperty(array)
 id1110
 user_id1281
 property_id3747
 sort_order0
 1(array)
 id1278
 typeAgent
 brokerage_id70
 email[email protected]
 password6e83e74e5aad7dc2404b41f4dad53b857b4a34ae
 recover_hash
 first_nameCynthia
 last_nameMurray
 title
 dre_num
 phone8888888888
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2018-04-25 13:15:33
 created2018-04-25 13:15:33
 notified(false)
 full_nameCynthia Murray
 uri/agent-detail/1278/cynthia-murray
 profile_complete(true)
 UsersProperty(array)
 id1111
 user_id1278
 property_id3747
 sort_order1
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id2
 nameBeach Access
 additional(false)
 created2016-04-07 14:00:52
 modified2016-04-07 14:00:52
 PropertiesPropertyFeature(array)
 id4721
 property_id3747
 property_feature_id2
 Topic(array)
 0(array)
 id8
 nameBeach
 created2016-02-25 11:25:00
 modified2016-02-25 11:30:26
 tile_nameBeach
 PropertiesTopic(array)
 id50
 property_id3747
 topic_id8
 1(array)
 Property(array)
 id3760
 brokerage_id143
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 name4311 Carpinteria Avenue
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(true)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(true)
 wsj_detail_urlhttps://realestate.wsj.com/listings/9708233
 ft_detail_urlhttps://propertylistings.ft.com/6096645
 nyt_detail_url
 juwai_detail_urlhttps://www.juwai.com/78114484.htm?autorotate=off
 pgl_detail_urlhttps://www.propgoluxury.com/en/homes/6096645
 mg_detail_urlhttps://www.mansionglobal.com/listings/9708233
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_urlhttps://www.barrons.com/real-estate/listings/9708233
 mw_detail_urlhttps://www.marketwatch.com/personal-finance/real-estate/listings/9708233
 nikkei_detail_url
 wapo_detail_url
 robb_detail_urlhttps://robbreport.com/listing/4311-carpinteria-avenue/
 medium_featured(false)
 large_featured(false)
 detail_page(false)
 descriptionLive near the Shore at this light and bright newly remodeled and freshly painted Carpinteria Gem. Step into your new pad with wood floors throughout, vaulted ceiling for plenty of light, primary bedroom with updated ensuite bath. Two other bedrooms with shared bath. Single story 3bd 2ba 1,272 sqft in total. Eastern facing glass french doors open to patio and backyard. Chef's kitchen open to dining room and outside patio. Newly remodeled baths and lighting. Wonderful location, close to all of Carpinteria and minutes from Summerland and Montecito. Detached 2 car garage and additional parking included, RV or Boat. Come experience this Carpinteria beauty.
 address4311 Carpinteria Avenue
 address_2
 citySanta Barbara
 stateCA
 postal_code93103
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1475000
 price_20
 price_usd1475000
 price_usd_20
 statusFor Sale
 status_last_changed2025-06-25 13:31:11
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms3
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet1272
 square_meters
 acres0
 interior_unitsq_ft
 interior_size1272
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1920
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num25-2418
 wsj_property_typesingle family
 nyt_property_type
 nyt_popular_features
 propgolux_property_type9
 juwai_property_typeSingle Family
 juwai_categoryresidential
 propgolux_property_style21
 wapo_property_type
 robb_property_typeSingle Family Home
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude34.422787
 longitude-119.675362
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(false)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2025-06-25 13:37:28
 created2025-06-25 13:30:55
 uri/property-detail/3760/4311-carpinteria-avenue-santa-barbara-ca-93103-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3760/4311-carpinteria-avenue-santa-barbara-ca-93103-usa
 address_concat4311 Carpinteria Avenue Santa Barbara CA 93103 USA
 google_maps_query_string4311+Carpinteria+Avenue++Santa+Barbara+CA+93103+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 1,475,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty2
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2025-06-25
 overridden_brokerage_nameSanta Barbara Brokers
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id143
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2488828
 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
 nameSanta Barbara Brokers
 broker_of_record_name
 short_nameSanta Barbara Brokers
 usernameSantaBarbaraBrokersSB
 password0c548da0233eab4b0b07524df249cf675ba01106
 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
 descriptionSanta Barbara Brokers is the exclusive representative for Leverage Global Partners in Santa Barbara, Montecito, Hope Ranch, Goleta, Summerland, Carpinteria, California, USA. We are a boutique real estate firm that provides custom, flexible, and creative solutions for buyers and sellers. Our agents have a history of consistently high sales volume, high ethics, and deep community involvement. At Santa Barbara Brokers, we all work together in a team environment to help each other become successful. At the core of Santa Barbara Brokers is our entrepreneurial spirit, which includes the habit of hard work, leadership, street smarts, and the motivation to achieve. Santa Barbara Brokers is located in suite 613 of the “The Balboa Building” in downtown Santa Barbara at 735 State Street.
 communitiesSanta Barbara Summerland Montecito Hope Ranch Goleta Carpinteria
 websitehttp://santabarbarabrokers.com/
 address735 State Street, Suite 613
 address_2
 citySanta Barbara
 stateCA
 full_stateCalifornia
 countryUSA
 marketSanta Barbara
 market_2
 postal_code93101
 phoneAndy Alexander (805) 722-2531
 phone_2Ryan Malmsten (805) 444-7926
 phone_3
 wide_contact_image(false)
 contact_nameAndy Alexander, Ryan Malmsten
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwners
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Santa Barbara Real Estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 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_filename143.jpg
 logo_filename143.png
 contact_image_filename143.jpg
 all_properties_link_image_filename143.jpg
 all_properties_linkhttp://santabarbarabrokers.com/featured-listings/
 video_embed_code
 contact_video_embed_code
 meta_titleSanta Barbara Real Estate | Santa Barbara Brokers | Leverage Global Partners
 meta_descriptionSanta Barbara Brokers is the exclusive representative for Leverage Global Partners in Santa Barbara, California, USA.
 meta_keywordsSanta Barbara Brokers, Santa Barbara Real Estate, Andy Alexander, Ryan Malmsten, Hope Ranch Real Estate, Goleta Real Estate, Mission Canyon Real Estate, Montecito Real Estate, Summerland Real Estate, Carpinteria Real Estate Santa Barbara California, 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)
 created2014-07-22 15:26:05
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/143/santa-barbara-brokers
 website_shortsantabarbarabrokers.com
 name_with_locationSanta Barbara Brokers
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id1
 property_id3760
 wsj_desktophttps://api.apiflash.com/v1/urltoimage?access_key=762fab49e0184656a1d87e9d2a9c465c&user_agent=LGP_MG_Bot&url=https%3A%2F%2Frealestate.wsj.com%2Flistings%2F9708233&ttl=2592000&width=1500&height=1500&cookies=wsjregion%3Dna%2Cus&css=.style--hat--1vqyrZZ3+%7B+display%3A+none%3B+%7D+.WSJTheme--market-data--hC5Q8XMG+%7B+display%3A+none%3B+%7D
 wsj_mobilehttps://api.apiflash.com/v1/urltoimage?access_key=762fab49e0184656a1d87e9d2a9c465c&user_agent=LGP_MG_Bot&url=https%3A%2F%2Frealestate.wsj.com%2Flistings%2F9708233&ttl=2592000&width=402&height=874&cookies=wsjregion%3Dna%2Cus&css=.style--hat--1vqyrZZ3+%7B+display%3A+none%3B+%7D+.WSJTheme--market-data--hC5Q8XMG+%7B+display%3A+none%3B+%7D
 wsj_expires2025-07-25 13:36:20
 wsj_capture_started(null)
 mg_desktophttps://api.apiflash.com/v1/urltoimage?access_key=762fab49e0184656a1d87e9d2a9c465c&user_agent=LGP_MG_Bot&url=https%3A%2F%2Fwww.mansionglobal.com%2Flistings%2F9708233&ttl=2592000&width=1500&height=1500&css=%23mg-top-header+%7B+display%3A+none%3B+%7D
 mg_mobilehttps://api.apiflash.com/v1/urltoimage?access_key=762fab49e0184656a1d87e9d2a9c465c&user_agent=LGP_MG_Bot&url=https%3A%2F%2Fwww.mansionglobal.com%2Flistings%2F9708233&ttl=2592000&width=402&height=874&css=%23mg-top-header+%7B+display%3A+none%3B+%7D
 mg_expires2025-07-25 13:37:43
 mg_capture_started(null)
 bp_desktophttps://api.apiflash.com/v1/urltoimage?access_key=762fab49e0184656a1d87e9d2a9c465c&user_agent=LGP_MG_Bot&url=https%3A%2F%2Fwww.barrons.com%2Freal-estate%2Flistings%2F9708233&ttl=2592000&width=1300&height=1300
 bp_mobilehttps://api.apiflash.com/v1/urltoimage?access_key=762fab49e0184656a1d87e9d2a9c465c&user_agent=LGP_MG_Bot&url=https%3A%2F%2Fwww.barrons.com%2Freal-estate%2Flistings%2F9708233&ttl=2592000&width=402&height=874
 bp_expires2025-07-25 13:37:51
 gp_capture_started(null)
 mw_desktophttps://api.apiflash.com/v1/urltoimage?access_key=762fab49e0184656a1d87e9d2a9c465c&user_agent=LGP_MG_Bot&url=https%3A%2F%2Fwww.marketwatch.com%2Fpersonal-finance%2Freal-estate%2Flistings%2F9708233&ttl=2592000&width=1300&height=1300&delay=5
 mw_mobilehttps://api.apiflash.com/v1/urltoimage?access_key=762fab49e0184656a1d87e9d2a9c465c&user_agent=LGP_MG_Bot&url=https%3A%2F%2Fwww.marketwatch.com%2Fpersonal-finance%2Freal-estate%2Flistings%2F9708233&ttl=2592000&width=402&height=874&delay=5
 mw_expires2025-07-25 13:37:59
 mw_capture_started(null)
 ft_desktophttps://api.apiflash.com/v1/urltoimage?access_key=762fab49e0184656a1d87e9d2a9c465c&user_agent=LGP_MG_Bot&url=https%3A%2F%2Fpropertylistings.ft.com%2F6096645&ttl=2592000&width=1200&height=1200&css=%23leaderboard-banner+%7B+display%3A+none%3B+%7D+.privacy-policy-message+%7B+display%3A+none%3B+%7D+div%5Bdata-o-cookie-message-privacy-message%5D+%7B+display%3A+none%3B+%7D
 ft_mobilehttps://api.apiflash.com/v1/urltoimage?access_key=762fab49e0184656a1d87e9d2a9c465c&user_agent=LGP_MG_Bot&url=https%3A%2F%2Fpropertylistings.ft.com%2F6096645&ttl=2592000&width=402&height=874&css=%23leaderboard-banner+%7B+display%3A+none%3B+%7D+.privacy-policy-message+%7B+display%3A+none%3B+%7D+div%5Bdata-o-cookie-message-privacy-message%5D+%7B+display%3A+none%3B+%7D
 ft_expires2025-07-25 13:37:50
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktophttps://api.apiflash.com/v1/urltoimage?access_key=762fab49e0184656a1d87e9d2a9c465c&user_agent=LGP_MG_Bot&url=https%3A%2F%2Fwww.propgoluxury.com%2Fen%2Fhomes%2F6096645&ttl=2592000&width=1200&height=1200&css=div.ai-navbar-container+center+%7B+display%3A+none%3B+%7D
 pgl_mobilehttps://api.apiflash.com/v1/urltoimage?access_key=762fab49e0184656a1d87e9d2a9c465c&user_agent=LGP_MG_Bot&url=https%3A%2F%2Fwww.propgoluxury.com%2Fen%2Fhomes%2F6096645&ttl=2592000&width=402&height=874&css=div.ai-navbar-container+center+%7B+display%3A+none%3B+%7D
 pgl_expires2025-07-25 13:37:52
 pgl_capture_started(null)
 robb_desktophttps://api.apiflash.com/v1/urltoimage?access_key=762fab49e0184656a1d87e9d2a9c465c&user_agent=LGP_MG_Bot&url=https%3A%2F%2Frobbreport.com%2Flisting%2F4311-carpinteria-avenue%2F&ttl=2592000&width=1200&height=1200&css=div.header__leaderboard+%7B+display%3A+none%3B+%7D+.fb_lightbox-overlay+%7B+display%3A+none+%21important%3B+%7D+.preloaded_lightbox+%7B+display%3A+none+%21important%3B+%7D
 robb_mobilehttps://api.apiflash.com/v1/urltoimage?access_key=762fab49e0184656a1d87e9d2a9c465c&user_agent=LGP_MG_Bot&url=https%3A%2F%2Frobbreport.com%2Flisting%2F4311-carpinteria-avenue%2F&ttl=2592000&width=402&height=874&css=div.header__leaderboard+%7B+display%3A+none%3B+%7D+.fb_lightbox-overlay+%7B+display%3A+none+%21important%3B+%7D+.preloaded_lightbox+%7B+display%3A+none+%21important%3B+%7D
 robb_expires2025-07-25 13:38:08
 robb_capture_started(null)
 juwai_desktophttps://api.apiflash.com/v1/urltoimage?access_key=762fab49e0184656a1d87e9d2a9c465c&user_agent=LGP_MG_Bot&url=https%3A%2F%2Fwww.juwai.com%2F78114484.htm%3Fautorotate%3Doff&ttl=2592000&width=1100&height=1100&delay=5&js=var+new_panel2+%3D+%24%28%22%23new_panel2%22%29%3B+%24%28%22%23new_panel2%22%29.prop%28%22id%22%2C+%22%22%29%3B+%24%28new_panel2%29.css%28%22left%22%2C+%2226px%22%29%3B
 juwai_mobilehttps://api.apiflash.com/v1/urltoimage?access_key=762fab49e0184656a1d87e9d2a9c465c&user_agent=LGP_MG_Bot&url=https%3A%2F%2Fwww.juwai.com%2F78114484.htm%3Fautorotate%3Doff&ttl=2592000&width=402&height=874&delay=5&js=var+new_panel2+%3D+%24%28%22%23new_panel2%22%29%3B+%24%28%22%23new_panel2%22%29.prop%28%22id%22%2C+%22%22%29%3B+%24%28new_panel2%29.css%28%22left%22%2C+%2226px%22%29%3B
 juwai_expires2025-07-25 13:37:54
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created2025-06-25 13:35:56
 modified2025-06-25 13:38:08
 wsj_available(true)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot/global_reach_reports/screenshot/1/wsj_desktop
 wsj_mobile_proxy_screenshot/global_reach_reports/screenshot/1/wsj_mobile
 mg_available(true)
 mg_expired(true)
 mg_desktop_proxy_screenshot/global_reach_reports/screenshot/1/mg_desktop
 mg_mobile_proxy_screenshot/global_reach_reports/screenshot/1/mg_mobile
 bp_available(true)
 bp_expired(true)
 bp_desktop_proxy_screenshot/global_reach_reports/screenshot/1/bp_desktop
 bp_mobile_proxy_screenshot/global_reach_reports/screenshot/1/bp_mobile
 mw_available(true)
 mw_expired(true)
 mw_desktop_proxy_screenshot/global_reach_reports/screenshot/1/mw_desktop
 mw_mobile_proxy_screenshot/global_reach_reports/screenshot/1/mw_mobile
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(true)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot/global_reach_reports/screenshot/1/pgl_desktop
 pgl_mobile_proxy_screenshot/global_reach_reports/screenshot/1/pgl_mobile
 robb_available(true)
 robb_expired(true)
 robb_desktop_proxy_screenshot/global_reach_reports/screenshot/1/robb_desktop
 robb_mobile_proxy_screenshot/global_reach_reports/screenshot/1/robb_mobile
 juwai_available(true)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot/global_reach_reports/screenshot/1/juwai_desktop
 juwai_mobile_proxy_screenshot/global_reach_reports/screenshot/1/juwai_mobile
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id23110
 modelProperty
 model_id3760
 tagImage
 name7.jpg
 typeimage/jpeg
 size69974
 uri/assets/23110.jpg
 order0
 created2025-06-25 13:30:50
 modified2025-06-25 13:30:55
 1(array)
 id23111
 modelProperty
 model_id3760
 tagImage
 name11.jpg
 typeimage/jpeg
 size79797
 uri/assets/23111.jpg
 order1
 created2025-06-25 13:30:50
 modified2025-06-25 13:30:55
 2(array)
 id23112
 modelProperty
 model_id3760
 tagImage
 name14.jpg
 typeimage/jpeg
 size75232
 uri/assets/23112.jpg
 order2
 created2025-06-25 13:30:50
 modified2025-06-25 13:30:55
 3(array)
 id23113
 modelProperty
 model_id3760
 tagImage
 name4.jpg
 typeimage/jpeg
 size92136
 uri/assets/23113.jpg
 order3
 created2025-06-25 13:30:50
 modified2025-06-25 13:30:55
 4(array)
 id23114
 modelProperty
 model_id3760
 tagImage
 name3.jpg
 typeimage/jpeg
 size97757
 uri/assets/23114.jpg
 order4
 created2025-06-25 13:30:50
 modified2025-06-25 13:30:55
 5(array)
 id23115
 modelProperty
 model_id3760
 tagImage
 name12.jpg
 typeimage/jpeg
 size71780
 uri/assets/23115.jpg
 order5
 created2025-06-25 13:30:50
 modified2025-06-25 13:30:55
 6(array)
 id23116
 modelProperty
 model_id3760
 tagImage
 name6.jpg
 typeimage/jpeg
 size70215
 uri/assets/23116.jpg
 order6
 created2025-06-25 13:30:50
 modified2025-06-25 13:30:55
 7(array)
 id23117
 modelProperty
 model_id3760
 tagImage
 name5.jpg
 typeimage/jpeg
 size78714
 uri/assets/23117.jpg
 order7
 created2025-06-25 13:30:50
 modified2025-06-25 13:30:55
 8(array)
 id23118
 modelProperty
 model_id3760
 tagImage
 name13.jpg
 typeimage/jpeg
 size95036
 uri/assets/23118.jpg
 order8
 created2025-06-25 13:30:50
 modified2025-06-25 13:30:55
 9(array)
 id23119
 modelProperty
 model_id3760
 tagImage
 name8.jpg
 typeimage/jpeg
 size91048
 uri/assets/23119.jpg
 order9
 created2025-06-25 13:30:51
 modified2025-06-25 13:30:55
 10(array)
 id23120
 modelProperty
 model_id3760
 tagImage
 name19.jpg
 typeimage/jpeg
 size96713
 uri/assets/23120.jpg
 order10
 created2025-06-25 13:30:51
 modified2025-06-25 13:30:55
 11(array)
 id23121
 modelProperty
 model_id3760
 tagImage
 name10.jpg
 typeimage/jpeg
 size114428
 uri/assets/23121.jpg
 order11
 created2025-06-25 13:30:51
 modified2025-06-25 13:30:55
 12(array)
 id23122
 modelProperty
 model_id3760
 tagImage
 name16.jpg
 typeimage/jpeg
 size160160
 uri/assets/23122.jpg
 order12
 created2025-06-25 13:30:51
 modified2025-06-25 13:30:55
 13(array)
 id23123
 modelProperty
 model_id3760
 tagImage
 name17.jpg
 typeimage/jpeg
 size143805
 uri/assets/23123.jpg
 order13
 created2025-06-25 13:30:51
 modified2025-06-25 13:30:55
 14(array)
 id23124
 modelProperty
 model_id3760
 tagImage
 name9.jpg
 typeimage/jpeg
 size206799
 uri/assets/23124.jpg
 order14
 created2025-06-25 13:30:51
 modified2025-06-25 13:30:55
 15(array)
 id23125
 modelProperty
 model_id3760
 tagImage
 name20.jpg
 typeimage/jpeg
 size189915
 uri/assets/23125.jpg
 order15
 created2025-06-25 13:30:51
 modified2025-06-25 13:30:55
 16(array)
 id23126
 modelProperty
 model_id3760
 tagImage
 name18.jpg
 typeimage/jpeg
 size200879
 uri/assets/23126.jpg
 order16
 created2025-06-25 13:30:51
 modified2025-06-25 13:30:55
 17(array)
 id23127
 modelProperty
 model_id3760
 tagImage
 name2.jpg
 typeimage/jpeg
 size222542
 uri/assets/23127.jpg
 order17
 created2025-06-25 13:30:51
 modified2025-06-25 13:30:55
 18(array)
 id23128
 modelProperty
 model_id3760
 tagImage
 name1.jpg
 typeimage/jpeg
 size214145
 uri/assets/23128.jpg
 order18
 created2025-06-25 13:30:51
 modified2025-06-25 13:30:55
 19(array)
 id23129
 modelProperty
 model_id3760
 tagImage
 name15.jpg
 typeimage/jpeg
 size254842
 uri/assets/23129.jpg
 order19
 created2025-06-25 13:30:51
 modified2025-06-25 13:30:55
 User(array)
 0(array)
 id456
 typeAgent
 brokerage_id143
 email[email protected]
 password19786dae8cca7b4b3f767f01dafff9600b2a4964
 recover_hash
 first_nameTroy
 last_nameHoidal
 title
 dre_num
 phone805-689-6808
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2025-06-25 14:47:29
 created2017-08-07 15:22:58
 notified(false)
 full_nameTroy Hoidal
 uri/agent-detail/456/troy-hoidal
 profile_complete(true)
 UsersProperty(array)
 id1138
 user_id456
 property_id3760
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 2(array)
 Property(array)
 id3734
 brokerage_id5
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameLovely & Detailed Remodel in South Pasadena
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(false)
 descriptionLovely and creatively remodeled home w/ a 2nd story in 2002 while preserving the 1925 integrity of the estate. Grand foyer w/ custom stairwell & impressive chandelier offers a stately entrance to this impeccable home loaded w/ an abundance of charm & character. There are impressive intricate details throughout. Adjacent to the foyer is a formal living room offering natural light by day & a cozy romantic fireplace by night. Gourmet kitchen is a chef's dream w/ center island, double ovens, stove top & opens to the family room. Luxurious master suite is located on the 2nd level w/ inspiring views of the rear gardens. Master bath offers dual sinks, soaking tub & oversized shower w/ bench. Backyard is ideal for entertaining under the grandiose pergola or simply relaxing & enjoying the vistas of the grassy area & mature trees. This a special South Pasadena home that has been lovingly maintained for the past 21 years by the current owners. Thank you for sharing in the joy of viewing this home.
 address1817 Spruce Street
 address_2
 citySouth Pasadena
 stateCA
 postal_code91030
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1780000
 price_20
 price_usd1780000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet2846
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://1817sprucestreetstreet.thepartnerstrust.com/
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial2
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1925
 virtual_tour
 video_tourhttp://www.onvedeo.com/properties/759797/embed
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num316002835
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style42
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude34.105072
 longitude-118.145790
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 00:33:02
 created2016-04-15 16:49:02
 uri/property-detail/3734/1817-spruce-street-south-pasadena-ca-91030-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3734/1817-spruce-street-south-pasadena-ca-91030-usa
 address_concat1817 Spruce Street South Pasadena CA 91030 USA
 google_maps_query_string1817+Spruce+Street++South+Pasadena+CA+91030+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,780,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty2
 bathrooms_partial_pretty2
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2016-04-15
 overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id5
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties12
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties2
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id1
 WOEID2468964
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePartners Trust Real Estate Brokerage and Acquisitions
 broker_of_record_name
 short_namePartners Trust Real Estate
 usernamePartnersTrustPas
 password5b28522e46f56278664573d82c2b0f03520519d0
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPartners Trust is the exclusive representative for Leverage Global Partners in Pasadena and La Cañada Flintridge, California, USA. At Partners Trust, we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market, presenting our clients with the most professional, successful and ethical real estate associates in the business. We represent our clients with care, confidentiality and the utmost attention to service. Pasadena is a harmonious blend of past and present. Experience the nationally-televised Rose Parade, catch an exciting football game at the Rose Bowl, get smart at Caltech, or revel in the Jet Propulsion Laboratory. The community is renowned for its charming and diverse neighborhoods whose residents honor and preserve the splendor of early California architecture. Opportunities abound to experience Pasadena’s sophisticated culture with the diversified entertainment at the Pasadena Playhouse, the Norton Simon Museum, the Huntington Library and Botanical Gardens and even by walking along the vibrant, historic district of Colorado Boulevard. Partners Trust associates are proud to represent a wide variety of historic and architecturally diverse homes, including the Craftsman-style home. We understand our clients discerning needs, and provide a high level of service and local area knowledge. Partners Trust has additional office locations in <a href="../../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/142/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Malibu</a>, and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a>
 communitiesPasadena La Canada Flintridge San Marino La Canada Flintridge
 websitehttp://www.thepartnerstrust.com
 address594 E. Colorado Boulevard
 address_2
 cityPasadena
 stateCA
 full_stateCalifornia
 countryUSA
 marketPasadena
 market_2
 postal_code91101
 phone(626) 696-4802
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameScott Brown
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-scott-brown-managing-director-partners-trust-pasadena/
 contact_big_profile_link_text
 contact_titleManaging Director
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2Nick Segal
 contact_profile_link_2http://www.leveragere.com/brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2President/Co-Founder
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename5.jpg
 logo_filename5.png
 contact_image_filename5.jpg
 all_properties_link_image_filename5.jpg
 all_properties_linkhttp://www.thepartnerstrust.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titlePasadena Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
 meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Pasadena, CA is a premier boutique Pasadena real estate brokerage and the exclusive Pasadena representative for Leverage Global Partners.
 meta_keywordspartners trust, partners trust real estate, pasadena real estate, leverage global partners, pasadena homes for sale, scott brown
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-03-18 16:08:06
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/5/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortwww.thepartnerstrust.com
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id20890
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_001_HIGHRES.jpg
 typeimage/jpeg
 size10361514
 uri/assets/20890.jpg
 order0
 created2016-04-15 16:47:48
 modified2016-04-15 16:49:02
 1(array)
 id20879
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_008_HIGHRES.jpg
 typeimage/jpeg
 size6804950
 uri/assets/20879.jpg
 order1
 created2016-04-15 16:47:42
 modified2016-04-15 16:49:02
 2(array)
 id20877
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_017_HIGHRES.jpg
 typeimage/jpeg
 size5626562
 uri/assets/20877.jpg
 order2
 created2016-04-15 16:47:39
 modified2016-04-15 16:49:02
 3(array)
 id20876
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_022_HIGHRES.jpg
 typeimage/jpeg
 size5719147
 uri/assets/20876.jpg
 order3
 created2016-04-15 16:47:38
 modified2016-04-15 16:49:02
 4(array)
 id20878
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_014_HIGHRES.jpg
 typeimage/jpeg
 size5358186
 uri/assets/20878.jpg
 order4
 created2016-04-15 16:47:40
 modified2016-04-15 16:49:02
 5(array)
 id20882
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_009_HIGHRES.jpg
 typeimage/jpeg
 size6157612
 uri/assets/20882.jpg
 order5
 created2016-04-15 16:47:46
 modified2016-04-15 16:49:02
 6(array)
 id20881
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_038_HIGHRES.jpg
 typeimage/jpeg
 size9795680
 uri/assets/20881.jpg
 order6
 created2016-04-15 16:47:44
 modified2016-04-15 16:49:02
 7(array)
 id20894
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_044_HIGHRES.jpg
 typeimage/jpeg
 size11888212
 uri/assets/20894.jpg
 order7
 created2016-04-15 16:47:50
 modified2016-04-15 16:49:02
 8(array)
 id20883
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_035_HIGHRES.jpg
 typeimage/jpeg
 size10217742
 uri/assets/20883.jpg
 order8
 created2016-04-15 16:47:47
 modified2016-04-15 16:49:02
 9(array)
 id20880
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_040_HIGHRES.jpg
 typeimage/jpeg
 size10614464
 uri/assets/20880.jpg
 order9
 created2016-04-15 16:47:43
 modified2016-04-15 16:49:02
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id9
 nameOffice
 additional(false)
 created2016-04-07 14:03:21
 modified2016-04-07 14:03:21
 PropertiesPropertyFeature(array)
 id4405
 property_id3734
 property_feature_id9
 1(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id4404
 property_id3734
 property_feature_id4
 Topic(empty)
 3(array)
 Property(array)
 id3703
 brokerage_id95
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id1223
 agent_2_id0
 agent_3_id0
 nameBeautiful Colonial in Legacy Woods
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionBeautiful Colonial in sought after neighborhood, Gourmet kitchen, Huge master bed room with master bath,finished basement great for entertaining. Gorgeous inground pool with outdoor hot tub and beautiful stone patio. A must see!!
 address15 Shadowbrook Crossing
 address_2
 cityEast Greenwich
 stateRI
 postal_code02818
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1300000
 price_20
 price_usd1300000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms3
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1pool
 icon_2media-room
 icon_3garage
 icon_4
 icon_5
 icon_6
 website
 meta_titleBeautiful Colonial in Legacy Woods | East Greenwich Real Estate | Coleman Realtors
 meta_description15 Shadowbrook Crossing is a property offered for sale in East Greenwich, RI, USA, presented by Coleman Realtors
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built2004
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num1118980
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style10
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude41.648308
 longitude-71.524071
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2016-04-06 07:17:36
 uri/property-detail/3703/15-shadowbrook-crossing-east-greenwich-ri-02818-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3703/15-shadowbrook-crossing-east-greenwich-ri-02818-usa
 address_concat15 Shadowbrook Crossing East Greenwich RI 02818 USA
 google_maps_query_string15+Shadowbrook+Crossing++East+Greenwich+RI+02818+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 1,300,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty4
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2016-04-06
 overridden_brokerage_nameColeman Realtors
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id95
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2477058
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameColeman Realtors
 broker_of_record_name
 short_nameColeman Realtors
 usernameColemanRealtors
 passwordc19a88afe4dbd7329004555ea008b2340aa6342b
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill. Local knowledge, world-class expertise. Rhode Islanders pride themselves on their independence. So do we: we're an independent, third-generation residential real estate company, not a franchise. That means we're totally focused on you and your needs. We've helped thousands of clients buy, sell, and rent since we opened our doors in 1929. Today our clients rely on our team of over 100 experienced professionals for our local knowledge and expertise: we know the neighborhoods, the towns and the people. With offices in Barrington, East Greenwich, Providence and Watch Hill, we're nearby too. So no matter your challenge, we'll bring you a wealth of experience, ideas and relationships - all geared toward producing results.
 communitiesBarrington, RI Providence, RI Watch Hill, RI Newport, RI Jamestown, RI Bristol, RI Charlestown, RI Narragansett, RI South Kingstown, RI East Greenwich, RI
 websitehttp://www.colemanrealtors.com/
 address135 Elmgrove Avenue
 address_2
 cityProvidence
 stateRI
 full_stateRhode Island
 countryUSA
 marketProvidence
 market_2
 postal_code02906
 phoneDavid Coleman: (401) 245-3050
 phone_2Michael Young: (401) 274-3636
 phone_3
 wide_contact_image(false)
 contact_nameDavid Coleman & Michael Young
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCo-Owners
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Providence real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename95.jpg
 logo_filename95.png
 contact_image_filename95.jpg
 all_properties_link_image_filename95.jpg
 all_properties_linkhttp://www.colemanrealtors.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleProvidence Real Estate | Coleman Realtors | Leverage Global Partners
 meta_descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Providence, Rhode Island, USA.
 meta_keywordsColeman Realtors, Providence Real Estate, Leverage Global Partners, Providence Rhode Island Real Estate, Barrington Real Estate, East Greenwich Real Estate, Providence Real Estate, Watch Hill Real Estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-02-11 18:09:34
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/95/coleman-realtors
 website_shortwww.colemanrealtors.com
 name_with_locationColeman Realtors
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id8805
 modelProperty
 model_id3703
 tagImage
 name36006.jpg
 typeimage/jpg
 size3406385
 uri/assets/8805.jpg
 order0
 created2016-04-07 16:11:05
 modified2016-04-07 16:11:05
 1(array)
 id8802
 modelProperty
 model_id3703
 tagImage
 name35998.jpg
 typeimage/jpg
 size1515170
 uri/assets/8802.jpg
 order1
 created2016-04-07 16:11:04
 modified2016-04-07 16:11:04
 2(array)
 id8801
 modelProperty
 model_id3703
 tagImage
 name35999.jpg
 typeimage/jpg
 size1752454
 uri/assets/8801.jpg
 order2
 created2016-04-07 16:11:04
 modified2016-04-07 16:11:04
 3(array)
 id8800
 modelProperty
 model_id3703
 tagImage
 name36000.jpg
 typeimage/jpg
 size1477593
 uri/assets/8800.jpg
 order3
 created2016-04-07 16:11:04
 modified2016-04-07 16:11:04
 4(array)
 id8799
 modelProperty
 model_id3703
 tagImage
 name36001.jpg
 typeimage/jpg
 size1673188
 uri/assets/8799.jpg
 order4
 created2016-04-07 16:11:04
 modified2016-04-07 16:11:04
 5(array)
 id8798
 modelProperty
 model_id3703
 tagImage
 name36002.jpg
 typeimage/jpg
 size1470683
 uri/assets/8798.jpg
 order5
 created2016-04-07 16:11:03
 modified2016-04-07 16:11:04
 6(array)
 id8797
 modelProperty
 model_id3703
 tagImage
 name36003.jpg
 typeimage/jpg
 size1828645
 uri/assets/8797.jpg
 order6
 created2016-04-07 16:11:03
 modified2016-04-07 16:11:03
 7(array)
 id8803
 modelProperty
 model_id3703
 tagImage
 name36004.jpg
 typeimage/jpg
 size1765406
 uri/assets/8803.jpg
 order7
 created2016-04-07 16:11:04
 modified2016-04-07 16:11:04
 8(array)
 id8804
 modelProperty
 model_id3703
 tagImage
 name36005.jpg
 typeimage/jpg
 size3513723
 uri/assets/8804.jpg
 order8
 created2016-04-07 16:11:04
 modified2016-04-07 16:11:04
 9(array)
 id8806
 modelProperty
 model_id3703
 tagImage
 name36007.jpg
 typeimage/jpg
 size3107628
 uri/assets/8806.jpg
 order9
 created2016-04-07 16:11:05
 modified2016-04-07 16:11:06
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id1418
 property_id3703
 property_feature_id12
 1(array)
 id8
 nameMedia Room
 additional(false)
 created2016-04-07 14:03:04
 modified2016-04-07 14:03:04
 PropertiesPropertyFeature(array)
 id1419
 property_id3703
 property_feature_id8
 2(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id1420
 property_id3703
 property_feature_id4
 Topic(empty)
- sidebar_brokerages(array)
 0(array)
 Brokerage(array)
 id70
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties3
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id13
 WOEID23706483
 timezoneEurope/Lisbon
 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_id9
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameQuinta Properties
 broker_of_record_name
 short_nameQuinta Properties
 usernameQuintaProperties
 passwordbfa20d0f7d557565a3e9f0589db0a06e4c9546f3
 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
 descriptionQuinta Properties is the exclusive representative for Leverage Global Partners in the Algarve, Portugal. Quinta Properties deal with some of the most exclusive luxury villas and exciting property in and around Quinta do Lago. As the chosen associates of Savills, they offer in-depth knowledge and experience to meet your real estate needs. Anyone who knows Quinta Properties and has dealt with Alison, Kerstin, and their team will know they are passionate about property. Their wide experience in the local property market enables them to recommend legal, architectural, financial and construction professionals who understand the needs of prospective buyers in the locality. Quinta Properties are registered with the Portuguese authorities as licensed agents, meeting stringent standards. Their staff are fluent in English, German, French, and Portuguese. "We make it our business to support you, to explain all the options, procedures and pitfalls and to carefully guide you through the entire process from purchasing to sellingluxury Quinta do Lago villas and other fine properties in the Quinta do Lago and the whole Algarve area." --Alison Buechner Hojbjerg and Kerstin Buechner
 communitiesalgarve the algarve quinta do lago
 websitehttp://www.quintaproperty.com/
 addressAvenida da Gondra
 address_2Quinta do Lago
 cityAlmancil
 state
 full_state
 countryPortugal
 marketAlgarve
 market_2
 postal_code8135-162
 phone+351 289 396 073
 phone_2+351 289 398086 (Fax)
 phone_3
 wide_contact_image(false)
 contact_nameAlison Buechner Hojbjerg and Kerstin Buechner
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleDirectors
 contact_dre_num
 contact_quoteWe invite you to contact us about real estate in the Algarve
 contact_email[email protected]
 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_filename70.jpg
 logo_filename70.jpg
 contact_image_filename70.jpg
 all_properties_link_image_filename70.jpg
 all_properties_linkhttp://www.quintaproperty.com/algarve/
 video_embed_code
 contact_video_embed_code
 meta_titleAlgarve Real Estate | Quinta Properties | Leverage Global Partners
 meta_descriptionQuinta Properties is the exclusive representative for Leverage Global Partners in the Algarve, Portugal.
 meta_keywordsQuinta Properties, Algarve Real Estate, Leverage Global Partners, Alison Buechner Hojbjerg
 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-11-15 11:23:29
 modified2020-11-20 12:05:11
 dre_num012345
 uri/brokerage-detail/70/quinta-properties
 website_shortwww.quintaproperty.com
 name_with_locationQuinta Properties
 mlsidx_id_array(array)
 09
 Logo(array)
 id2443
 modelBrokerage
 model_id70
 tagLogo
 name70.jpg
 typeimage/jpg
 size696260
 uri/assets/2443.jpg
 order0
 created2016-03-30 11:39:44
 modified2018-04-25 10:57:26
 1(array)
 Brokerage(array)
 id113
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2356566
 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
 nameMountain Oak Properties
 broker_of_record_name
 short_nameMountain Oak Properties
 usernameMountainOakProperties
 passwordde66630c678d1e389d6693754f7b541ad5e428f5
 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
 descriptionMountain Oak Properties is the exclusive representative for Leverage Global Partners in Asheville, North Carolina, USA. As Western North Carolina's premier real estate firm, Mountain Oak Properties was founded on the principle that individualized service and attention define the real estate experience. With over three decades of combined sales and marketing experience – both in the residential and development segments - our founding partners are completely committed to building Western North Carolina's leading resource for buying and selling real estate in Western North Carolina. Mountain Oak Properties’ agents live and work in some of the areas most popular communities. Our trained team is dedicated, reliable, honest and resourceful. Whether you are prepared to purchase your first home, are relocating to the area, buying a piece of property or downsizing, we want to be your exclusive resource for all things real estate. Our company was founded in 2013 by three ambitious partners, Sean McLaughlin, Kevin Scarmack, and Mitch Miller, committed to creating a premium customer service experience for clients who trust in our mission. Individually, each partner has extensive experience in the development segment of the business. Sean and Mitch were previously employed at The Cliffs Communities, an exclusive set of golf communities in North and South Carolina. Kevin worked for Land Resource Companies, who developed several high-end communities throughout the Southeast. We specialize in working with clients from around the world who are looking to retire or buy a second home in the Carolinas.
 communities
 websitehttp://www.mountainoakproperties.com/
 address32 All Souls Crescent
 address_2Suite 202
 cityAsheville
 stateNC
 full_stateNorth Carolina
 countryUSA
 marketAsheville
 market_2
 postal_code28803
 phone (828) 318-8801
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameSean McLaughlin, Kevin Scarmack, Mitch Miller
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwners
 contact_dre_num
 contact_quoteYour Resource for All Things Real Estate in Western North Carolina.
 contact_email[email protected]
 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_filename113.jpg
 logo_filename113.png
 contact_image_filename113.jpg
 all_properties_link_image_filename113.jpg
 all_properties_linkhttp://www.mountainoakproperties.com/our-listings/
 video_embed_code<iframe width="560" height="315" src="//www.youtube.com/embed/Ghik1qR1cDI" frameborder="0" allowfullscreen></iframe>
 contact_video_embed_code
 meta_titleAsheville Real Estate | Mountain Oak Properties | Leverage Global Partners
 meta_descriptionMountain Oak Properties is the exclusive representative for Leverage Global Partners in Asheville, North Carolina, USA.
 meta_keywordsMountain Oak Properties, Asheville Real Estate, Kevin Scarmack, Mitch Miller, Sean McLaughlin, Asheville North Carolina, 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)
 created2014-04-23 13:20:21
 modified2016-04-08 16:34:09
 dre_num012345
 uri/brokerage-detail/113/mountain-oak-properties
 website_shortwww.mountainoakproperties.com
 name_with_locationMountain Oak Properties
 Logo(array)
 id2578
 modelBrokerage
 model_id113
 tagLogo
 name113.png
 typeimage/png
 size57326
 uri/assets/2578.png
 order0
 created2016-03-30 11:41:11
 modified2016-03-30 11:41:11
 2(array)
 Brokerage(array)
 id229
 account_executive_id236
 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(true)
 country_id0
 WOEID2449097
 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
 nameCurri Properties
 broker_of_record_name
 short_nameCurri Properties
 usernamecurriproperties
 password9e8524ed8ef59b0e785808fcccc169873ee3c9dd
 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
 descriptionCurri Properties is the exclusive representative for Leverage Global Partners in all of Brevard County, including Melbourne, FL, USA. Curri Properties was established in late 2003 after realizing there was a void in Brevard County, Fl for a local, professional boutique real estate brokerage firm, that specialized in Waterfront, Luxury & Commercial property sales. Consisting of just over 20 associates, we pride ourselves on dynamic marketing skills that allows for greater global exposure. This is achieved by marketing our properties through our internet affiliates, and within our company website, which is top ranked amongst Google’s search engine. <a title="www.CurriProperties.com" href="http://www.CurriProperties.com" target="_blank">www.CurriProperties.com</a> Selling luxury & waterfront real estate is not only a career, but a passion we portray in all aspects of what we do. We focus on the basics of what any and all small business relies on, community involvement and building lifelong relationships. In handling the sale or purchase of a home, it not only is a desire, or a dream, but a financial commitment which is generally a family’s largest investment. We are here to insure our client’s best interest each and every time, while giving you five star service along the way. Our service will never be compromised, as we continue to stay focused on our motto. Professionalism, Integrity, Building Relationships.
 communitiesMelbourne Brevard County
 websitehttp://www.curriproperties.net/
 address2893 N. Harbor City Blvd.
 address_2
 cityMelbourne
 stateFL
 full_stateFlorida
 countryUSA
 market
 market_2
 postal_code32935
 phoneCell: (321) 961-4487
 phone_2Office: (888) 638-3832
 phone_3
 wide_contact_image(false)
 contact_nameJohn Curri
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner/CEO
 contact_dre_num
 contact_quote
 contact_email[email protected]
 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_filename229.jpg
 logo_filename229.JPG
 contact_image_filename229.png
 all_properties_link_image_filename229.jpg
 all_properties_linkhttp://www.curriproperties.net/Exclusive-Listings-6-269.html
 video_embed_code
 contact_video_embed_code
 meta_titleMelbourne Real Estate | Curri Properties | Leverage Global Partners
 meta_descriptionCurri Properties is the exclusive representative for Leverage Global Partners in all of Brevard County, including Melbourne, FL, USA.
 meta_keywordscurri properties, melbourne real estate, brevard county real estate, leverage global partners, florida real estate
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-10-07 16:02:52
 modified2016-04-08 16:34:31
 dre_num012345
 uri/brokerage-detail/229/curri-properties
 website_shortwww.curriproperties.net
 name_with_locationCurri Properties
 Logo(array)
 id2899
 modelBrokerage
 model_id229
 tagLogo
 name229.JPG
 typeimage/JPG
 size558494
 uri/assets/2899.JPG
 order0
 created2016-03-30 11:45:19
 modified2016-03-30 11:45:19
 3(array)
 Brokerage(array)
 id242
 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
 WOEID(null)
 timezoneAmerica/Los_Angeles
 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
 nameMarshall Realty
 broker_of_record_name
 short_nameMarshall Realty
 username
 password
 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
 descriptionMarshall Realty is the exclusive representative for Leverage Global Partners in Daly City, Colma, Brisbane, South San Francisco, San Bruno, Pacifica, Millbrae, Hillsborough, Burlingame, San Mateo, Foster, Belmont, San Carlos, Halfmoon Bay and Redwood City CA, USA. 
 communitiesDaly City Colma Brisbane South San Francisco San Bruno, Pacifica Millbrae Hillsborough Burlingame San Mateo Foster Belmont San Carlos Halfmoon Bay Redwood City.
 websitehttp://www.marshallrealty.com/
 address716 Laurel Street,
 address_2#3
 citySan Carlos
 stateCA
 full_stateCalifornia
 countryUSA
 market
 market_2
 postal_code94070
 phone650-873-6844
 phone_2650-291-9775
 phone_3
 wide_contact_image(false)
 contact_nameAnne Oliva
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBroker | Owner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone650-291-9775
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2650-867-2709
 contact_website
 contact_name_2Bob Marshall
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2Owner
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename
 logo_filename
 contact_image_filename
 all_properties_link_image_filename
 all_properties_linkhttp://www.marshallrealty.com/marshall-listings.php
 video_embed_code
 contact_video_embed_code
 meta_title
 meta_description
 meta_keywords
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(false)
 created2016-04-18 10:18:58
 modified2016-04-18 10:21:31
 dre_num012345
 uri/brokerage-detail/242/marshall-realty
 website_shortwww.marshallrealty.com
 name_with_locationMarshall Realty
 Logo(array)
 id20976
 modelBrokerage
 model_id242
 tagLogo
 namecoming soon logo.png
 typeimage/png
 size8726
 uri/assets/20976.png
 order0
 created2016-04-18 10:15:22
 modified2016-04-18 10:21:31
- sidebar_locations(array)
 0(array)
 Location(array)
 id130
 parent_id8
 brokerage_id154
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameTampa, FL, USA
 short_nameTampa, FL, USA
 group_index
 latitude27.950575
 longitude-82.457176
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-07 14:17:42
 modified2016-04-07 14:17:42
 timezoneAmerica/New_York
 population353000
 uri/locations/view/130/tampa-fl-usa
 tile_nameTampa, FL, USA
 Brokerage(array)
 id154
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2503863
 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
 nameCornerstone Properties International
 broker_of_record_name
 short_nameCornerstone Properties International
 usernameCornerstoneProperty
 passwordf300ceb25cdb1505430722d88bff1cb47b6d4200
 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
 descriptionCornerstone Properties International is the exclusive representative for Leverage Global Partners in Tampa, St. Petersburg, Clearwater Beach, Odessa, Wesley Chapel, Dunedin, Palm Harbor, Treasure Island, Tierra Verde, Belleair, Thonototosassa, Davis Islands, Harbour Island, Florida, USA. In 2001, Steve Eckhardt took a small group of dedicated, top-performing Realtors in the Tampa area real estate market and broke from the tradition of the corporate and often impersonal real estate mega-companies to form an upscale, boutique real estate agency with an unprecedented knowledge of the local market and community. Cornerstone Properties grew very quickly and opened additional offices in Fort Myers and Key Largo, Florida to serve luxury clientele looking for vacation homes and waterfront properties from the Tampa Bay area to Sarasota, Fort Myers, Naples, and into the Florida Keys. Cornerstone Properties has consistently earned its position as one of the top boutique residential real estate firms on the Gulf Coast of Florida. Furthermore, Cornerstone Properties was named by Florida Realtor Magazine as one of the top company real estate websites in the state of Florida and has been recognized by Who’s Who In Luxury Real Estate since 2002. In addition to providing the strongest team of agents in area, Steve has developed a completely unique branding and a leading edge marketing standard that truly positions a client’s property apart from the rest. With over 16 years in the real estate industry, 12 years in the mortgage industry, and entrepreneurial experience spanning over 25 years, Steve provides the knowledge, experience, and dedication you would expect from a true luxury real estate professional. And, he offers his clients service that is second to none.
 communitiesTampa, St. Petersburg Clearwater Beach Odessa Wesley Chapel Dunedin Palm Harbor Treasure Island Tierra Verde Belleair Thonototosassa Davis Islands Harbour Island
 websitehttp://thefloridaauthority.com/
 address8875 Hidden River Parkway
 address_2Suite 300
 cityTampa
 stateFL
 full_stateFlorida
 countryUSA
 market
 market_2
 postal_code33637
 phone(813) 765-1182
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameSteve Eckhardt
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_email[email protected]
 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_filename154.jpg
 logo_filename154.jpg
 contact_image_filename154.jpg
 all_properties_link_image_filename
 all_properties_link
 video_embed_code<iframe src="https://player.vimeo.com/video/121701442?color=ffffff&title=0&byline=0&portrait=0" width="420" height="236" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>
 contact_video_embed_code
 meta_titleTampa Real Estate | Cornerstone Properties International | Leverage Global Partners
 meta_descriptionCornerstone Properties International is the exclusive member for Leverage Global Partners in Tampa, FL, USA.
 meta_keywordsCornerstone Properties International, Tampa Real Estate, Steve Eckhardt, Hillsborough Real Estate, Pinellas Real Estate, Pasco Real Estate, Florida Real Estate, Levergage 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)
 created2014-08-25 16:13:56
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/154/cornerstone-properties-international
 website_shortthefloridaauthority.com
 name_with_locationCornerstone Properties International
 Image(array)
 id3662
 modelLocation
 model_id130
 tagImage
 nameTampa.jpg
 typeimage/jpeg
 size144110
 uri/assets/3662.jpg
 order0
 created2016-04-07 14:17:37
 modified2016-04-07 14:17:42
 1(array)
 Location(array)
 id73
 parent_id9
 brokerage_id45
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameRedlands, CA, USA
 short_nameRedlands, CA, USA
 group_index
 latitude34.055569
 longitude-117.182541
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 18:02:34
 modified2016-04-04 18:02:34
 timezoneAmerica/Los_Angeles
 population70000
 uri/locations/view/73/redlands-ca-usa
 tile_nameRedlands, CA, USA
 Brokerage(array)
 id45
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2525109
 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
 nameElite Realty Group
 broker_of_record_name
 short_nameElite Realty Group
 usernameEliteRealty
 passworde1a63e2def7ed55f3dbf026430e9a42cc49521b0
 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
 descriptionElite Realty is the exclusive representative for Leverage Global Partners in Redlands, Yucaipa, Colton, Grand Terrace, San Bernardino, Highland, Loma Linda, Mentone, Calimesa, Cherry Valley, Beaumont, and Banning, California, USA. Specializing in homes for sale and the San Bernardino and Riverside County real estate market, you have found your realtor resource for buying and selling your next home. With expertise in realty for both purchasing and listing properties in Yucaipa, Calimesa, Redlands, Cherry Valley, Oak Glen and Beaumont and all surrounding San Bernardino and Riverside Counties, you have found the right resource for all of your real estate needs. Whether you are looking for a new Cherry Valley property or Calimesa land, or you are in the preliminary stages of your real estate search, you have found the best in professional service.
 communitiesRedlands Yucaipa Colton Grand Terrace San Bernardino Highland Loma linda Mentone Calimesa Cherry Valley Beaumont Banning
 websitehttp://www.eliterealtygroup.net/
 address1447 Ford Street
 address_2
 cityRedlands
 stateCA
 full_stateCalifornia
 countryUSA
 market
 market_2
 postal_code92374
 phone(909) 793-3222
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameDennis Miller
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBroker/Co-Owner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 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_filename45.jpg
 logo_filename45.png
 contact_image_filename45.JPG
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_titleYucaipa Real Estate | Elite Realty Group | Leverage Global Partners
 meta_descriptionElite Realty Group is the exclusive representative for Leverage Global Partners in Yucaipa, CA, USA.
 meta_keywordsElite Realty Group, yucaipa real estate, Dennis Miller, 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-09-10 13:01:01
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/45/elite-realty-group
 website_shortwww.eliterealtygroup.net
 name_with_locationElite Realty Group
 Image(array)
 id3005
 modelLocation
 model_id73
 tagImage
 nameRedlands.jpg
 typeimage/jpeg
 size165492
 uri/assets/3005.jpg
 order0
 created2016-04-04 18:02:25
 modified2016-04-04 18:02:34
 2(array)
 Location(array)
 id112
 parent_id9
 brokerage_id41
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameTelluride, CO, USA
 short_nameTelluride, CO, USA
 group_index
 latitude37.957722
 longitude-107.882080
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionEveryone loves Telluride - the lifestyle is the best!
 long_descriptionVisitors are immediately enchanted with the breathtaking setting of the historic Town of Telluride. The grand snowcapped mountain peaks ensnare the senses, while the warm embrace of the Telluride community welcomes them to paradise. Each summer the town plays host to such world-renowned events as the Telluride Bluegrass Festival, Telluride Film Festival, and Telluride Blues & Brews Festival. Telluride, Mountain Village and their surrounding areas boast a desirable array of high-end luxury and value-oriented properties. Unlike other high profile resorts, Telluride and Mountain Village both offer true ski-in/out condos & homes with grand views and sumptuous amenities.
 created2016-04-05 16:30:17
 modified2016-04-05 16:30:17
 timezoneAmerica/Boise
 population3686
 uri/locations/view/112/telluride-co-usa
 tile_nameTelluride, CO, USA
 Brokerage(array)
 id41
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties-1
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2504615
 timezoneUS/Mountain
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameTelluride Properties
 broker_of_record_name
 short_nameTelluride Properties
 usernameTelllurideProperties
 passworddf9e1cb9ed6ee8ffbaeb602e5a977dba189b7205
 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
 descriptionTelluride Properties is the exclusive representative for Leverage Global Partners in Telluride, Colorado, USA. Telluride Properties has earned a reputation as the premier Telluride real estate firm, bringing buyers and sellers together since 1986. We understand every aspect of the Telluride real estate market, including ski homes and condominiums, Telluride’s historic Victorian residences, developments, ranches, short sale & bank owned properties, vacation homes and year-round residences. Telluride Properties’ success is based on yours. We provide the tools and proactive guidance it takes to reach our clients’ goals. Our attention to details that matter most to you are hallmarks that significantly enhance the experience you deserve. Telluride Properties has a proven team of skilled real estate brokers ready to assist you with your Telluride real estate assets.
 communitiesTelluride
 websitehttp://www.tellurideproperties.com
 address237 S. Oak Street
 address_2PO Box 37
 cityTelluride
 stateCO
 full_stateColorado
 countryUSA
 marketTelluride
 market_2
 postal_code81435
 phone(970) 708-5527
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameAlbert Roer
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-albert-roer-managing-partner-telluride-properties/
 contact_big_profile_link_text
 contact_titleManaging Partner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 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_filename41.jpg
 logo_filename41.jpg
 contact_image_filename41.jpg
 all_properties_link_image_filename41.jpg
 all_properties_linkhttp://www.searchtelluriderealestate.com/results/?UserID=all
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/klILER0J-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleTelluride Real Estate | Telluride Properties | Leverage Global Partners
 meta_descriptionTelluride Properties is the exclusive representative for Leverage Global Partners in Telluride, Colorado, USA.
 meta_keywordsTelluride real estate, Telluride Properties, Albert Roer, Telluride Colorado, leverage global partners
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-08-09 12:10:53
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/41/telluride-properties
 website_shortwww.tellurideproperties.com
 name_with_locationTelluride Properties
 Image(array)
 id3375
 modelLocation
 model_id112
 tagImage
 name39922990_telluride_town_shot.jpg
 typeimage/jpeg
 size8168766
 uri/assets/3375.jpg
 order0
 created2016-04-05 16:17:35
 modified2016-04-05 16:30:17
 3(array)
 Location(array)
 id137
 parent_id8
 brokerage_id92
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameKiawah Island, SC, USA
 short_nameKiawah Island, SC, USA
 group_index
 latitude32.608238
 longitude-80.084816
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionKiawah and Seabrook Islands – luxury accommodations amidst championship golf courses and pristine beaches.
 long_descriptionBoth Kiawah and Seabrook Islands, just 21 miles south of historic downtown Charleston, offer a unique, rural flavor that attracts nature-lovers, sports enthusiasts and vacation seekers from all over the world. Guests and residents alike enjoy access to miles of unspoiled beach, seven championship golf courses, tennis, biking, boating, wildlife and so much more. Local farms provide an abundance of fresh produce, while surrounding creeks and rivers offer fresh “catch of the day”. Whether you seek views of the ocean, championship fairways, maritime forests or lush marshes, here, you will find your special place.
 created2016-04-07 15:25:59
 modified2016-04-07 15:25:59
 timezoneAmerica/New_York
 population1700
 uri/locations/view/137/kiawah-island-sc-usa
 tile_nameKiawah Island, SC, USA
 Brokerage(array)
 id92
 account_executive_id236
 archived(false)
 typedevelopment
 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
 WOEID2432153
 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
 namePam Harrington Exclusives
 broker_of_record_name
 short_namePam Harrington Exclusives
 usernamePamHarringtonExclusives
 passwordd9957a95a4927b3d3325d107e05944a461d55de6
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename92.pdf
 active(true)
 lead_in
 short_description
 descriptionPam Harrington Exclusives is the exclusive representative for Leverage Global Partners in Wadmalaw Island, Seabrook Island, Johns Island, Kiawah Island, South Carolina, USA. In 1987, Pam Harrington Exclusives began as a small, independent firm amid a sea of large, corporate realty companies and developers competing for business on Kiawah and Seabrook Island. The Pam Harrington Exclusives team quickly established relationships with discerning island homeowners who sought to rent their properties during peak season. Those early relationships continued to grow and served as the foundation upon which our small firm blossomed into the renowned full service real estate company we are today. With over 30 years of experience in island realty, we enjoy sharing our surroundings. If you're looking for oceanfront, fairway, deep water or secluded marshlands, we'll find it on the islands of Kiawah, Seabrook, Johns or Wadmalaw. If the city suits your fancy, we are equally at home in Charleston. We’ve had the pleasure of helping families get to know Seabrook and Kiawah Island through our seasonal rentals – and the honor of seeing them fall in love with these islands and helping them become permanent members of our community. As an independent firm, we are free of corporate demands and able to focus on what’s most important – helping our clients find happiness in the beautiful places we are lucky to call home. Distinguished by profound personal attention, Pam Harrington Exclusives has closed over one billion dollars in sales, one transaction at a time. If you're interested in buying or selling a home or property on Kiawah, Seabrook or the adjacent islands, look no further. We’re proud to represent the beloved island communities whose beauty, value and legacy endure
 communitiesWadmalaw Island Seabrook Island Johns Island Kiawah Island
 websitehttp://www.pamharringtonexclusives.com/
 address4343 Betsy Kerrison Pkwy
 address_2
 cityJohns Island
 stateSC
 full_stateSouth Carolina
 countryUSA
 marketKiawah Island
 market_2
 postal_code29455
 phoneOffice: (843) 768-3635
 phone_2
 phone_3
 wide_contact_image(false)
 contact_namePam Harrington
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_email[email protected]
 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_filename92.jpg
 logo_filename92.jpg
 contact_image_filename92.jpg
 all_properties_link_image_filename92.JPG
 all_properties_linkhttp://www.pamharringtonexclusives.com/real-estate/kiawah-real-estate
 video_embed_code
 contact_video_embed_code
 meta_titleKiawah Island Real Estate | Pam Harrington Exclusives | Leverage Global Partners
 meta_descriptionPam Harrington Exclusives is the exclusive representative for Leverage Global Partners in Kiawah Island, South Carolina, USA.
 meta_keywordsKiawah Island Real Estate, Pam Harrington Exclusives, Leverage Global Partners, Wadmalaw Island Real Estate, Seabrook Island Real Estate, Johns Island Real Estate
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-01-31 18:29:33
 modified2019-09-09 11:37:58
 dre_num012345
 uri/development-detail/92/pam-harrington-exclusives
 website_shortwww.pamharringtonexclusives.com
 name_with_locationPam Harrington Exclusives
 Image(array)
 id5323
 modelLocation
 model_id137
 tagImage
 nameKiawah Island.jpg
 typeimage/jpeg
 size25958
 uri/assets/5323.jpg
 order0
 created2016-04-07 15:25:01
 modified2016-04-07 15:25:59
- location_properties(empty)
- main_article(empty)
- brokerage(array)
 Brokerage(array)
 id242
 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
 WOEID(null)
 timezoneAmerica/Los_Angeles
 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
 nameMarshall Realty
 broker_of_record_name
 short_nameMarshall Realty
 username
 password
 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
 descriptionMarshall Realty is the exclusive representative for Leverage Global Partners in Daly City, Colma, Brisbane, South San Francisco, San Bruno, Pacifica, Millbrae, Hillsborough, Burlingame, San Mateo, Foster, Belmont, San Carlos, Halfmoon Bay and Redwood City CA, USA. 
 communitiesDaly City Colma Brisbane South San Francisco San Bruno, Pacifica Millbrae Hillsborough Burlingame San Mateo Foster Belmont San Carlos Halfmoon Bay Redwood City.
 websitehttp://www.marshallrealty.com/
 address716 Laurel Street,
 address_2#3
 citySan Carlos
 stateCA
 full_stateCalifornia
 countryUSA
 market
 market_2
 postal_code94070
 phone650-873-6844
 phone_2650-291-9775
 phone_3
 wide_contact_image(false)
 contact_nameAnne Oliva
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBroker | Owner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone650-291-9775
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2650-867-2709
 contact_website
 contact_name_2Bob Marshall
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2Owner
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename
 logo_filename
 contact_image_filename
 all_properties_link_image_filename
 all_properties_linkhttp://www.marshallrealty.com/marshall-listings.php
 video_embed_code
 contact_video_embed_code
 meta_title
 meta_description
 meta_keywords
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(false)
 created2016-04-18 10:18:58
 modified2016-04-18 10:21:31
 dre_num012345
 uri/brokerage-detail/242/marshall-realty
 website_shortwww.marshallrealty.com
 name_with_locationMarshall Realty - San Carlos, CA, USA
 AccountExecutive(array)
 id235
 typeAccountExecutive
 brokerage_id0
 email[email protected]
 passworde5cc5a96287695cf8b7cace1463b1699895dcf92
 recover_hash
 first_nameAlec
 last_nameMegerdichian
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2020-12-23 09:21:42
 created2016-04-14 15:40:35
 notified(false)
 full_nameAlec Megerdichian
 uri/agent-detail/235/alec-megerdichian
 profile_complete(true)
 Logo(array)
 id20976
 modelBrokerage
 model_id242
 tagLogo
 namecoming soon logo.png
 typeimage/png
 size8726
 uri/assets/20976.png
 order0
 created2016-04-18 10:15:22
 modified2016-04-18 10:21:31
 MainImage(array)
 id20977
 modelBrokerage
 model_id242
 tagMainImage
 nameshutterstock_66222787.jpg
 typeimage/jpeg
 size2045549
 uri/assets/20977.jpg
 order0
 created2016-04-18 10:18:57
 modified2016-04-18 10:21:31
 ContactImage(array)
 id20975
 modelBrokerage
 model_id242
 tagContactImage
 namecoming soon contact image.jpg
 typeimage/jpeg
 size7349
 uri/assets/20975.jpg
 order0
 created2016-04-18 10:15:10
 modified2016-04-18 10:21:31
 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)
 MainArticle(array)
 id(null)
 model(null)
 model_id(null)
 archived(null)
 medium_featured(null)
 large_featured(null)
 title(null)
 author(null)
 date(null)
 lead_in(null)
 body(null)
 vimeo_id(null)
 created(null)
 modified(null)
 FeaturedImage(empty)
 Location(array)
 0(array)
 id180
 parent_id9
 brokerage_id242
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameSan Carlos, CA, USA
 short_nameSan Carlos
 group_index
 latitude37.507160
 longitude-122.260521
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore Information Coming Soon!
 created2016-04-18 12:40:18
 modified2016-04-18 12:40:18
 timezoneAmerica/Los_Angeles
 population0
 uri/locations/view/180/san-carlos-ca-usa
 tile_nameSan Carlos, CA, USA
 User(empty)
- location(array)
 Location(array)
 id180
 parent_id9
 brokerage_id242
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameSan Carlos, CA, USA
 short_nameSan Carlos
 group_index
 latitude37.507160
 longitude-122.260521
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore Information Coming Soon!
 created2016-04-18 12:40:18
 modified2016-04-18 12:40:18
 timezoneAmerica/Los_Angeles
 population0
 uri/locations/view/180/san-carlos-ca-usa
 tile_nameSan Carlos, CA, USA
 Image(array)
 id21018
 modelLocation
 model_id180
 tagImage
 nameshutterstock_66222787.jpg
 typeimage/jpeg
 size2045549
 uri/assets/21018.jpg
 order0
 created2016-04-18 12:37:34
 modified2016-04-18 12:40:18
- 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)
 Location(empty)
 Image(empty)
 Brokerage(empty)
 AccountExecutive(empty)
 Logo(empty)
 MainImage(empty)
 ContactImage(empty)
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 Property(empty)
 User(empty)
 PropertyFeature(empty)
 SecondaryPropertyCategory(empty)
 Topic(empty)
 FeaturedImage(empty)
 Article(empty)
 ParentBrokerage(empty)
 ParentLocation(empty)
 ArticlesBrokerage(empty)
 ArticlesLocation(empty)
 ArticlesProperty(empty)
 ArticlesTopic(empty)
 PrimaryPropertyCategory(empty)
 StripeSubscription(empty)
 GlobalReachReport(empty)
 UsersProperty(empty)
 PropertiesSecondaryPropertyCategory(empty)
 PropertiesPropertyFeature(empty)
 PropertiesTopic(empty)
- Loaded Helpers(array)
 0Permission
 1Geography
 2Number
 3SimpleGraph
 4DebugTimer
 5Toolbar
 6Session
 7Text
 8Flash
 9HtmlToolbar
 10Html
 11Form
====

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	[email protected]
STRIPE_ISSUES_EMAIL_RECIPIENT	[email protected]
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	/locations/view/180/san-carlos-ca-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/locations/view/180/san-carlos-ca-usa
Remote Port	18341
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	162.159.115.41
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http Cf Ray	a09d853178e234fc-CMH
Http Accept Encoding	gzip, br
Http Cookie	CAKEPHP=3u9vmbm7vk0q766jnlu7et61er
Http Accept	/
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
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	aiorIfK8CRJnCvkkTtrr2AAAANc
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	aiorIfK8CRJnCvkkTtrr2AAAANc
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781148449.535
Request Time	1781148449

====

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/ExploreComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/LocationsController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/Subscription.php
  1APP/Model/AppModel.php
  2APP/Model/Location.php
  3APP/Model/Asset.php
  4APP/Model/Brokerage.php
  5APP/Model/User.php
  6APP/Model/Article.php
  7APP/Model/Property.php
  8APP/Model/PropertyFeature.php
  9APP/Model/PropertyCategory.php
  10APP/Model/Topic.php
  11APP/Model/StripeSubscription.php
  12APP/Model/GlobalReachReport.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
====

San Carlos, CA, USA

Location Represented By

Related Articles

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 20 ms Total Queries: 19 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 20 ms
Total Queries: 19 queries