Locations / Ashland, OR, USA

Ashland, OR, USA

More information coming soon!

Location Represented By

License #: 012345

7:24pm local time
21 thousand population

Partner Search

Find partners with a map-based search

Related Locations

Bend, OR, USA

Dubbed the "outdoor playground of the West" for a thousand good reasons, Central Oregon is world famous for both its outdoor activities and majestic, snow-capped mountain peaks along the high-desert skyline.

Lisbon, Portugal

Newport Beach, CA, USA

Celebrated as an alluring destination, Orange County’s beauty is more than skin deep.

London, United Kingdom

Stylish London offers something for everyone at any time of the year.

Related Partners

Madison & Company Properties, LTD.

(303) 771-3850 | Email
License #: 012345

Boris Mannsfeld & Associates

(303) 495-5536 | Email
License #: 012345

Property BVI Realtors

(284) 494 0101 | Email
License #: 012345

Housing Japan

+81 3 3588 8860 | Email
License #: 012345

Recent Property Listings

Classic, Detailed Colonial With Endless Possibilities

1795 Warwick Road
San Marino, CA 91108
$2,198,000

Modern, Updated Ranch Home with Mesmerizing Ocean Views

545 Catalonia Avenue
Pacific Palisades, CA 90272
$2,995,000

Sunset Strip Complex

9255 Swallow Drive
Los Angeles, CA 90069
$12,000,000

Extraordinary Family Home

27424 Alpen
Lake Arrowhead, CA 92352
$545,000

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

Array
(
)

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

Cake Params
- plugin(null)
- controllerlocations
- actionview
- named(empty)
- pass(array)
  048
  1ashland-or-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: 19 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` = 48 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` = 109 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` = (109) 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` = (109)	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` = (109)	3	3	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` = 48 LIMIT 1	0	0	1	maybe slow
SELECT `Location`.`id`, `Location`.`name`, `Location`.`parent_id` FROM `leveragere_staging2`.`locations` AS `Location` WHERE `Location`.`id` = 48 AND `Location`.`archived` = '0' LIMIT 1	1	1	0
SELECT `Location`.`id`, `Location`.`name` FROM `leveragere_staging2`.`locations` AS `Location` WHERE `Location`.`parent_id` = 48	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	3	maybe slow
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 (3733, 3741, 3755, 3712) ORDER BY `Image`.`order` ASC	31	31	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 (3733, 3741, 3755, 3712) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	4	4	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 (3733, 3741, 3755, 3712) 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 (3733, 3741, 3755, 3712) 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 (3733, 3741, 3755, 3712) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	2	2	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 9.93 MB

Message	Memory use
Component initialization	2.88 MB
Controller action start	3.80 MB
Controller render start	6.59 MB
View render complete	7.14 MB

Timers

Total Request Time: 228 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	26.59
Event: Controller.initialize	3.73
Event: Controller.startup	1.99
Controller action	77.72
Event: Controller.beforeRender	4.97
» Processing toolbar data	4.89
Rendering View	80.02
» Event: View.beforeRender	0.26
» Rendering APP/View/Locations/view.ctp	2.50
» » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.15
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.15
» » 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.37
» » » Rendering APP/View/Elements/static_property_price.ctp #2	0.16
» » » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.20
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	76.56
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)
 id3733
 brokerage_id5
 created_by_user_id0
 order6
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameClassic, Detailed Colonial With Endless Possibilities
 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)
 descriptionThis classic shingled Colonial located close to Valentine School in San Marino abounds in character and fine workmanship. The classic formal entry is flanked by an elegant living room with fireplace and the formal dining room. The kitchen is adjoined by a cozy paneled breakfast room. There is one bedroom and bath downstairs and 3 bedrooms upstairs. The master suite opens with french doors to a gracious deck. Details include exquisite moldings and paneling, wainscoting and many french doors. The large lot has mature trees, a 3 car garage and endless possibilities.
 address1795 Warwick Road
 address_2
 citySan Marino
 stateCA
 postal_code91108
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2198000
 price_20
 price_usd2198000
 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
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet2321
 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://1795warwickroad.thepartnerstrust.com/
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1936
 virtual_tour
 video_tourhttp://www.onvedeo.com/properties/762172/embed
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num316003233
 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
 latitude34.115185
 longitude-118.118011
 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:17:52
 uri/property-detail/3733/1795-warwick-road-san-marino-ca-91108-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3733/1795-warwick-road-san-marino-ca-91108-usa
 address_concat1795 Warwick Road San Marino CA 91108 USA
 google_maps_query_string1795+Warwick+Road++San+Marino+CA+91108+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,198,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty3
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 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)
 id20874
 modelProperty
 model_id3733
 tagImage
 name1.jpg
 typeimage/jpeg
 size11605128
 uri/assets/20874.jpg
 order0
 created2016-04-15 16:16:05
 modified2016-04-15 16:24:47
 1(array)
 id20870
 modelProperty
 model_id3733
 tagImage
 name5.jpg
 typeimage/jpeg
 size5791865
 uri/assets/20870.jpg
 order1
 created2016-04-15 16:15:59
 modified2016-04-15 16:24:47
 2(array)
 id20868
 modelProperty
 model_id3733
 tagImage
 name10.jpg
 typeimage/jpeg
 size5088423
 uri/assets/20868.jpg
 order2
 created2016-04-15 16:15:57
 modified2016-04-15 16:24:47
 3(array)
 id20867
 modelProperty
 model_id3733
 tagImage
 name8.jpg
 typeimage/jpeg
 size4967444
 uri/assets/20867.jpg
 order3
 created2016-04-15 16:15:56
 modified2016-04-15 16:24:47
 4(array)
 id20869
 modelProperty
 model_id3733
 tagImage
 name12.jpg
 typeimage/jpeg
 size4731499
 uri/assets/20869.jpg
 order4
 created2016-04-15 16:15:58
 modified2016-04-15 16:24:47
 5(array)
 id20865
 modelProperty
 model_id3733
 tagImage
 name16.jpg
 typeimage/jpeg
 size3907702
 uri/assets/20865.jpg
 order5
 created2016-04-15 16:15:54
 modified2016-04-15 16:24:47
 6(array)
 id20866
 modelProperty
 model_id3733
 tagImage
 name22.jpg
 typeimage/jpeg
 size3946374
 uri/assets/20866.jpg
 order6
 created2016-04-15 16:15:55
 modified2016-04-15 16:24:47
 7(array)
 id20873
 modelProperty
 model_id3733
 tagImage
 name15.jpg
 typeimage/jpeg
 size6695297
 uri/assets/20873.jpg
 order7
 created2016-04-15 16:16:03
 modified2016-04-15 16:24:47
 8(array)
 id20871
 modelProperty
 model_id3733
 tagImage
 name28.jpg
 typeimage/jpeg
 size6515193
 uri/assets/20871.jpg
 order8
 created2016-04-15 16:16:00
 modified2016-04-15 16:24:47
 9(array)
 id20872
 modelProperty
 model_id3733
 tagImage
 name26.jpg
 typeimage/jpeg
 size7551017
 uri/assets/20872.jpg
 order9
 created2016-04-15 16:16:02
 modified2016-04-15 16:24:47
 User(array)
 0(array)
 id940
 typeAgent
 brokerage_id5
 email[email protected]
 passwordcb48b7281adb1166af7c1c68a117a685c757de42
 recover_hash
 first_nameFran
 last_nameBenuska
 title
 dre_num
 phone626.253.0029
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:45
 created2017-08-07 15:23:45
 notified(false)
 full_nameFran Benuska
 uri/agent-detail/940/fran-benuska
 profile_complete(true)
 UsersProperty(array)
 id702
 user_id940
 property_id3733
 sort_order0
 1(array)
 id941
 typeAgent
 brokerage_id5
 email[email protected]
 passwordabc682447210f48fc403bf8f71bbb0b2b3a0e6a1
 recover_hash
 first_nameLeann
 last_nameHealy
 title
 dre_num
 phone626.696.4770
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:45
 created2017-08-07 15:23:45
 notified(false)
 full_nameLeann Healy
 uri/agent-detail/941/leann-healy
 profile_complete(true)
 UsersProperty(array)
 id704
 user_id941
 property_id3733
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id4400
 property_id3733
 property_feature_id4
 Topic(empty)
 1(array)
 Property(array)
 id3741
 brokerage_id3
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameModern, Updated Ranch Home with Mesmerizing Ocean Views
 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(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)
 descriptionPalisades modern ranch with mesmerizing ocean views by renowned architect, David Kellen. A special updated home, perched on a promontory above the street on a 16,000 ft. lot with abundant natural light and bright, open spaces. Enter into an open living, dining, and music room, which leads seamlessly to the large grassy backyard area with pool. Sleek and simple modern kitchen with breakfast nook. Two bedroom suites (including a junior master) and a den downstairs, all opening to the lovely outdoors. Upstairs is a breathtaking master suite with open loft style walls with oversized windows and sweeping ocean, city and canyon views. Additional bedroom suite upstairs.
 address545 Catalonia Avenue
 address_2
 cityPacific Palisades
 stateCA
 postal_code90272
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2995000
 price_20
 price_usd2995000
 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
 bathrooms5
 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
 websitehttp://545cataloniaavenue.thepartnerstrust.com/
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1955
 virtual_tour
 video_tourhttp://www.onvedeo.com/properties/755499/embed
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num16112996
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style33
 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.047157
 longitude34.047157
 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)
 modified2024-10-24 08:39:37
 created2016-04-18 09:57:58
 uri/property-detail/3741/545-catalonia-avenue-pacific-palisades-ca-90272-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3741/545-catalonia-avenue-pacific-palisades-ca-90272-usa
 address_concat545 Catalonia Avenue Pacific Palisades CA 90272 USA
 google_maps_query_string545+Catalonia+Avenue++Pacific+Palisades+CA+90272+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,995,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty5
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2016-04-18
 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)
 id3
 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
 WOEID2442047
 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
 usernamePartnersTrustLA
 password165bb7b526009554e197bcf82dabaa84ae727155
 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 Los Angeles, California, USA. At Partners Trust, our real estate associates are the most professional, successful and ethical in the business, representing each of our clients with care, confidentiality and the utmost attention to service. As a company, we offer our associates and clients a level of technology and communication unmatched in today’s real estate market. Los Angeles provides the ideal canvas to make your dream become a reality. We live, work, and entertain everywhere, from our beautiful beaches and the vibrant, newly revitalized downtown to the expansive mountain ranges overlooking the serene desert landscapes. With a culture that attracts celebrities, sports figures and entrepreneurs, the Southern California lifestyle is in high demand. Great representation in this real estate market is essential. Our associates proudly handle all types of homes, ranging from the architectural estate to the contemporary condominium to the historic, traditional home. Each property and client is represented with the highest quality of presentation and service, leading to unparalleled success. 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/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/5/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Pasadena</a>, <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>
 communitiesLos Angeles Brentwood West Los Angeles
 websitehttp://thepartnerstrust.com
 address11726 San Vicente Blvd
 address_2Suite 350
 cityLos Angeles
 stateCA
 full_stateCalifornia
 countryUSA
 marketLos Angeles
 market_2
 postal_code90049
 phone(310) 500-1388
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameNick Segal
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/presidential-profile-partners-trust-real-estate-brokerage-aquisitions-nick-segal/
 contact_big_profile_link_text
 contact_titlePresident/Co-Founder
 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_filename3.jpg
 logo_filename3.png
 contact_image_filename3.jpg
 all_properties_link_image_filename3.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_titleLos Angeles Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
 meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Los Angeles, CA is a premier boutique real estate brokerage, serving home buyers and sellers in the Los Angeles real estate market.
 meta_keywordspartners trust, Partners Trust Real Estate, los angeles real estate, nick segal, leverage global partners
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-03-18 15:09:20
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/3/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortthepartnerstrust.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)
 id20971
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_LoRes_(1_of_33).jpg.jpg
 typeimage/jpeg
 size449059
 uri/assets/20971.jpg
 order0
 created2016-04-18 09:57:16
 modified2024-10-24 08:39:26
 1(array)
 id20968
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_HiRes_(6_of_33).jpg.jpg
 typeimage/jpeg
 size273879
 uri/assets/20968.jpg
 order1
 created2016-04-18 09:57:16
 modified2024-10-24 08:39:26
 2(array)
 id20970
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_LoRes_(5_of_33).jpg.jpg
 typeimage/jpeg
 size360705
 uri/assets/20970.jpg
 order2
 created2016-04-18 09:57:16
 modified2024-10-24 08:39:26
 3(array)
 id20964
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_HiRes_(11_of_33).jpg.jpg
 typeimage/jpeg
 size210712
 uri/assets/20964.jpg
 order3
 created2016-04-18 09:57:15
 modified2024-10-24 08:39:26
 4(array)
 id20963
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_HiRes_(22_of_33).jpg.jpg
 typeimage/jpeg
 size155986
 uri/assets/20963.jpg
 order4
 created2016-04-18 09:57:15
 modified2024-10-24 08:39:26
 5(array)
 id20966
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_HiRes_(16_of_33).jpg.jpg
 typeimage/jpeg
 size310096
 uri/assets/20966.jpg
 order5
 created2016-04-18 09:57:15
 modified2024-10-24 08:39:26
 6(array)
 id20965
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_HiRes_(13_of_33).jpg.jpg
 typeimage/jpeg
 size291598
 uri/assets/20965.jpg
 order6
 created2016-04-18 09:57:15
 modified2024-10-24 08:39:26
 7(array)
 id20969
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_HiRes_(18_of_33).jpg.jpg
 typeimage/jpeg
 size255914
 uri/assets/20969.jpg
 order7
 created2016-04-18 09:57:16
 modified2024-10-24 08:39:26
 8(array)
 id20967
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_HiRes_(3_of_33).jpg.jpg
 typeimage/jpeg
 size301571
 uri/assets/20967.jpg
 order8
 created2016-04-18 09:57:16
 modified2024-10-24 08:39:26
 9(array)
 id20972
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_LoRes_(30_of_33).jpg.jpg
 typeimage/jpeg
 size493336
 uri/assets/20972.jpg
 order9
 created2016-04-18 09:57:16
 modified2024-10-24 08:39:26
 User(array)
 0(array)
 id1173
 typeAgent
 brokerage_id3
 email[email protected]
 passwordba579c44380627d37c115b910cd6401d0a7a4a71
 recover_hash
 first_nameRichard
 last_nameStearns
 title
 dre_num
 phone310.850.9284
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:56
 created2017-08-07 15:23:56
 notified(false)
 full_nameRichard Stearns
 uri/agent-detail/1173/richard-stearns
 profile_complete(true)
 UsersProperty(array)
 id1130
 user_id1173
 property_id3741
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id4753
 property_id3741
 property_feature_id14
 1(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id4752
 property_id3741
 property_feature_id12
 Topic(array)
 0(array)
 id12
 nameModern Architecture
 created2016-02-25 11:25:00
 modified2016-02-25 11:33:26
 tile_nameModern Architecture
 PropertiesTopic(array)
 id58
 property_id3741
 topic_id12
 1(array)
 id4
 nameKiller Views
 created2016-02-25 11:25:00
 modified2016-02-25 11:33:10
 tile_nameKiller Views
 PropertiesTopic(array)
 id57
 property_id3741
 topic_id4
 2(array)
 Property(array)
 id3755
 brokerage_id244
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameSunset Strip Complex
 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(true)
 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)
 descriptionLorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris ut gravida metus, sit amet ornare nisl. In sed velit magna. Vestibulum convallis, lectus eu luctus aliquam, velit mi suscipit nibh, eget ullamcorper nunc turpis vehicula dolor. Quisque aliquet eros nec nibh accumsan, sed suscipit risus pharetra. Curabitur condimentum porta dolor, eget porta erat placerat id. Curabitur eget mollis leo, et ornare dolor. Mauris eget dui libero. Interdum et malesuada fames ac ante ipsum primis in faucibus. Phasellus consequat diam et magna molestie, at condimentum ipsum consequat.
 address9255 Swallow Drive
 address_2
 cityLos Angeles
 stateCA
 postal_code90069
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price12000000
 price_20
 price_usd12000000
 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_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 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.104874
 longitude-118.389793
 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)
 modified2019-10-31 00:13:54
 created2019-10-31 00:13:45
 uri/property-detail/3755/9255-swallow-drive-los-angeles-ca-90069-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3755/9255-swallow-drive-los-angeles-ca-90069-usa
 address_concat9255 Swallow Drive Los Angeles CA 90069 USA
 google_maps_query_string9255+Swallow+Drive++Los+Angeles+CA+90069+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 12,000,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty0
 bathrooms_pretty0
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms0
 date_listed2019-10-31
 overridden_brokerage_nameSmith & Berg
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id244
 account_executive_id0
 archived(false)
 typeteam
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties10
 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
 nameSmith & Berg
 broker_of_record_nameCompass
 short_nameSmith & Berg
 username
 password
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_inYou've tried the rest, now try the best
 short_description
 descriptionLorem ipsum dolor sit amet, consectetur adipiscing elit. Sed et est ut dui hendrerit auctor sit amet ut lorem. Proin eleifend tristique felis. Curabitur bibendum enim mauris, nec volutpat lectus aliquam a. Vestibulum laoreet tellus ac porta consectetur. Quisque quam tellus, tempus vel sollicitudin id, convallis ut erat. Nullam laoreet aliquet sapien non porttitor. Curabitur eu commodo quam, in pellentesque nibh. Etiam non dolor fermentum velit commodo feugiat a ut augue. Sed faucibus tincidunt vestibulum. Pellentesque tincidunt sed lorem at efficitur. Suspendisse maximus arcu eget fermentum pharetra. Praesent dapibus justo sit amet vestibulum molestie. Nullam eu faucibus nisi, sed lacinia eros. Quisque finibus nec ante eu scelerisque. In hac habitasse platea dictumst. Nam turpis augue, ornare sed odio a, placerat vestibulum augue. Curabitur posuere turpis sed nisl tempus, id feugiat ipsum dictum. Praesent venenatis pharetra nunc at tincidunt. Ut sollicitudin quam sit amet tortor molestie, at bibendum diam cursus. Cras ac metus vitae sapien condimentum consequat sit amet eget metus. Vestibulum et venenatis purus. Donec tincidunt pharetra ex quis tempor. Vivamus non sapien eget elit auctor ultrices at eget turpis. Nulla volutpat ut nibh eget placerat.
 communitiesLos Angeles
 websitehttps://compass.com
 address680 E. Colorado Blvd
 address_2Suite 150
 cityPasadena
 stateCA
 full_stateCalifornia
 countryUSA
 market
 market_2
 postal_code91101
 phone8888888888
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameF. Ron Smith
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal
 contact_dre_num11624555
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone565-135-7745
 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_2878-829-1672
 contact_website
 contact_name_2Chris Stephonovich
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2Associate Realtor
 contact_dre_num_241768321
 contact_email_3[email protected]
 contact_name_3Courtney P. Wolpertinger
 contact_title_3Associate Realtor
 contact_dre_num_384919983
 contact_phone_3158-646-8246
 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_link
 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)
 created2019-10-31 00:07:13
 modified2021-07-18 10:40:16
 dre_num012345
 uri/team-detail/244/smith-berg
 website_shortcompass.com
 name_with_locationSmith & Berg
 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)
 id23088
 modelProperty
 model_id3755
 tagImage
 name7ab079e6d3fcc3f540f780f5080587df8beb7d73.jpeg
 typeimage/jpeg
 size520160
 uri/assets/23088.jpeg
 order0
 created2019-10-31 00:13:42
 modified2019-10-31 00:13:45
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 3(array)
 Property(array)
 id3712
 brokerage_id76
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id777
 agent_2_id0
 agent_3_id0
 nameExtraordinary Family Home
 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(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(true)
 descriptionExtraordinary family home w/ stunning lake view! Perfect for full-time use or vacation get-away. Entertainer's dream home! 3 large decks (Trex decking) great for BBQing while looking at gorgeous Lake Arrowhead. Game room, open floor plan, beamed ceilings. 2 sliding glass doors off of family rm. open up to a beautiful view of the lake. Stunning stone fireplace w/ solid wood mantle. This is a MUST SEE home!
 address27424 Alpen
 address_2
 cityLake Arrowhead
 stateCA
 postal_code92352
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price545000
 price_20
 price_usd545000
 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_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1garage
 icon_2office
 icon_3views
 icon_4
 icon_5
 icon_6
 websitehttp://www.therealestateplace.com/property/2326-2/
 meta_titleExtraordinary Family Home | Lake Arrowhead Real Estate | Prime Properties
 meta_description27424 Alpen is a property offered for sale in Lake Arrowhead, CA, USA, presented by Prime Properties
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tourhttp://www.tourfactory.com/1505216
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 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
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, year_built, virtual_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(true)
 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-07 10:56:58
 uri/property-detail/3712/27424-alpen-lake-arrowhead-ca-92352-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3712/27424-alpen-lake-arrowhead-ca-92352-usa
 address_concat27424 Alpen Lake Arrowhead CA 92352 USA
 google_maps_query_string27424+Alpen++Lake+Arrowhead+CA+92352+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 545,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty2
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2016-04-07
 overridden_brokerage_namePrime Properties
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id76
 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
 WOEID2434729
 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
 namePrime Properties
 broker_of_record_name
 short_namePrime Properties
 usernamePrimeProperties
 password4b7dee5c791770c42ce3df75d5b8fb072b481b38
 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
 descriptionPrime Properties is the exclusive representative for Leverage Global Partners in Lake Arrowhead, California, USA. “Different isn’t always better, but better is always different,” has been founder, and president, Jeff Perlis’ motto for providing outstanding service to his clients for almost 25 years. Jeff created Prime Properties as a boutique real estate company that provides Nordstrom-quality customer service to its clients. The Prime Properties Team purposes to continually show community support. Such support can be exemplified by their sweeping transformation of its current office location. The office’s strategic location, houses the Arrowhead Welcome Center, Jeff’s vision for providing a warm and inviting first-stop for Lake Arrowhead visitors and clients. The Prime Properties Team includes, Arrowhead Rental Agency, the full-time rental department. Lake Arrowhead is a four season resort community centered around the uniqueness of a private lake. Located in an altitude of 5,100 feet, Lake Arrowhead has been described as the “Jewel of Southern California,” known as “Little Switzerland.” Close to local ski resorts and National Forest trails, Lake Arrowhead is less than a two-hour drive from Los Angeles, San Diego, or Palm Springs.
 communitieslake arrowhead
 websitehttp://www.therealestateplace.com/
 address26816 Highway 189
 address_2
 cityLake Arrowhead
 stateCA
 full_stateCalifornia
 countryUSA
 marketLake Arrowhead
 market_2
 postal_code92352
 phone(909) 337-7653
 phone_2(909) 224-5631
 phone_3
 wide_contact_image(false)
 contact_nameJeff Perlis
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner/Broker
 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_websitehttp://www.JeffPerlis.com
 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_filename76.jpg
 logo_filename76.jpg
 contact_image_filename76.jpg
 all_properties_link_image_filename76.jpg
 all_properties_linkhttp://www.therealestateplace.com/properties
 video_embed_code
 contact_video_embed_code
 meta_titleLake Arrowhead Real Estate | Prime Properties | Leverage Global Partners
 meta_descriptionPrime Properties is the exclusive representative for Leverage Global Partners in Lake Arrowhead, California, USA.
 meta_keywordsLake Arrowhead Real Estate, Prime Properties, Leverage Global Partners, Jeff Perlis
 login_message_counter2
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-12-09 16:21:37
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/76/prime-properties
 website_shortwww.therealestateplace.com
 name_with_locationPrime Properties
 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)
 id11165
 modelProperty
 model_id3712
 tagImage
 name36037.jpg
 typeimage/jpg
 size3559005
 uri/assets/11165.jpg
 order2895
 created2016-04-07 16:25:28
 modified2016-04-07 16:25:28
 1(array)
 id11166
 modelProperty
 model_id3712
 tagImage
 name36038.jpg
 typeimage/jpg
 size2525853
 uri/assets/11166.jpg
 order2896
 created2016-04-07 16:25:34
 modified2016-04-07 16:25:34
 2(array)
 id11167
 modelProperty
 model_id3712
 tagImage
 name36039.jpg
 typeimage/jpg
 size2800068
 uri/assets/11167.jpg
 order2897
 created2016-04-07 16:25:36
 modified2016-04-07 16:25:36
 3(array)
 id11168
 modelProperty
 model_id3712
 tagImage
 name36040.jpg
 typeimage/jpg
 size3027894
 uri/assets/11168.jpg
 order2898
 created2016-04-07 16:25:38
 modified2016-04-07 16:25:38
 4(array)
 id11169
 modelProperty
 model_id3712
 tagImage
 name36041.jpg
 typeimage/jpg
 size2301281
 uri/assets/11169.jpg
 order2899
 created2016-04-07 16:25:40
 modified2016-04-07 16:25:40
 5(array)
 id11170
 modelProperty
 model_id3712
 tagImage
 name36042.jpg
 typeimage/jpg
 size2420895
 uri/assets/11170.jpg
 order2900
 created2016-04-07 16:25:42
 modified2016-04-07 16:25:42
 6(array)
 id11171
 modelProperty
 model_id3712
 tagImage
 name36043.jpg
 typeimage/jpg
 size2423264
 uri/assets/11171.jpg
 order2901
 created2016-04-07 16:25:44
 modified2016-04-07 16:25:44
 7(array)
 id11172
 modelProperty
 model_id3712
 tagImage
 name36044.jpg
 typeimage/jpg
 size2540978
 uri/assets/11172.jpg
 order2902
 created2016-04-07 16:25:45
 modified2016-04-07 16:25:45
 8(array)
 id11173
 modelProperty
 model_id3712
 tagImage
 name36045.jpg
 typeimage/jpg
 size1916356
 uri/assets/11173.jpg
 order2903
 created2016-04-07 16:25:49
 modified2016-04-07 16:25:49
 9(array)
 id11174
 modelProperty
 model_id3712
 tagImage
 name36046.jpg
 typeimage/jpg
 size4040003
 uri/assets/11174.jpg
 order2904
 created2016-04-07 16:25:51
 modified2016-04-07 16:25:51
 User(array)
 0(array)
 id969
 typeAgent
 brokerage_id76
 email[email protected]
 password576f947779f7edcccdd25932c65b363f8265be2d
 recover_hash
 first_nameJeff
 last_namePerlis
 title
 dre_num
 phone909-337-7653
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:46
 created2017-08-07 15:23:46
 notified(false)
 full_nameJeff Perlis
 uri/agent-detail/969/jeff-perlis
 profile_complete(true)
 UsersProperty(array)
 id726
 user_id969
 property_id3712
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id1987
 property_id3712
 property_feature_id4
 1(array)
 id9
 nameOffice
 additional(false)
 created2016-04-07 14:03:21
 modified2016-04-07 14:03:21
 PropertiesPropertyFeature(array)
 id1988
 property_id3712
 property_feature_id9
 2(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id1989
 property_id3712
 property_feature_id14
 Topic(empty)
- sidebar_brokerages(array)
 0(array)
 Brokerage(array)
 id102
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2391279
 timezoneUS/Mountain
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameMadison & Company Properties, LTD.
 broker_of_record_name
 short_nameMadison & Company Properties, LTD.
 usernameMadisonCompanyProperties
 password8541ab1d4f117636ccf50dec264f6087f8469e75
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionMadison and Company Properties LTD. is the exclusive representative for Leverage Global Partners in Denver, Aurora, Broomfield, Castle Rock, Cherry Hills Village, Golden, Greenwood Village, Highlands Ranch, Lakewood, Littleton, Lone Tree, Parker, Denver County, Adams County, Arapahoe County, Jefferson County, Douglas County, Elbert County, CO, USA. “Welcome to Madison & Company Properties. Over the last 5 years, our company has experienced an explosion of growth. In that time, we have added some incredible broker associates and new exciting locations. More importantly, we have continually added great people who help make our culture collaborative, professional, and fun to be associated with. We are one of the fastest growing boutique real estate firms in Denver, Colorado and we want to be your trusted real estate firm for all of your real estate needs. At Madison & Company, we are committed to providing our clients with an outstanding experience. We hope you choose Madison either to buy or sell your home. I know that our brokers will take care of you with the utmost care and responsibility.” —— Todd Narlinger President & Founder Madison & Company Properties
 communitiesDenver Aurora Broomfield Castle Rock Cherry Hills Village Golden Greenwood Village Highlands Ranch Lakewood Littleton Lone Tree Parker Denver County Adams County Arapahoe County Jefferson County Douglas County Elbert County
 websitehttp://www.madisonprops.com/
 address5600 S. Quebec Street
 address_2Suite A-113
 cityGreenwood Village
 stateCO
 full_stateColorado
 countryUSA
 marketDenver
 market_2
 postal_code80111
 phone(303) 771-3850
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTodd Narlinger
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-todd-narlinger/
 contact_big_profile_link_textMeet Todd
 contact_titleBroker Owner
 contact_dre_num
 contact_quote
 contact_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_filename102.jpg
 logo_filename102.png
 contact_image_filename102.jpg
 all_properties_link_image_filename102.jpg
 all_properties_linkhttp://www.madisonprops.com/IDXMini.aspx?segmentid=7044292&uid=118945&htmlfile=1883217.html
 video_embed_code<iframe src="https://player.vimeo.com/video/134034523?color=ffffff&title=0&byline=0&portrait=0" width="500" height="281" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>
 contact_video_embed_code
 meta_titleDenver Real Estate | Madison and Company Properties LTD. | Leverage Global Partners
 meta_descriptionMadison and Company Properties LTD. is the exclusive representative for Leverage Global Partners in Denver, CO, USA.
 meta_keywordsMadison and Company Properties LTD, Denver Real Estate, Todd Narlinger, Denver, Aurora, Broomfield, Castle Rock, Cherry Hills Village, Golden, Greenwood Village, Highlands Ranch, Lakewood, Littleton, Lone Tree, Parker, Denver County, Adams County, Arapahoe County, Jefferson County, Douglas County, Elbert County Real Estate, Denver Colorado
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-03-05 17:29:54
 modified2016-04-08 16:34:09
 dre_num012345
 uri/brokerage-detail/102/madison-company-properties-ltd
 website_shortwww.madisonprops.com
 name_with_locationMadison & Company Properties, LTD.
 Logo(array)
 id2542
 modelBrokerage
 model_id102
 tagLogo
 name102.png
 typeimage/png
 size4826
 uri/assets/2542.png
 order0
 created2016-03-30 11:40:56
 modified2016-03-30 11:40:56
 1(array)
 Brokerage(array)
 id184
 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_properties1
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID23424760
 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
 nameBoris Mannsfeld & Associates
 broker_of_record_name
 short_nameBoris Mannsfeld & Associates
 usernameBorisMannsfeld
 passwordfdddb06bee50f8c891dc0fc9de6dc15c95fa063b
 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
 descriptionBoris Mannsfeld & Associates is the exclusive representative for Leverage Global Partners in Placencia, Belize. Welcome to Boris Mannsfeld & Associates Belize Real Estate and beautiful Belize. Our loyalty to our client’s best interest has established us as the top real set firm in the region. Our expert team is ready and excited to guide you step–by–step in finding the perfect property or securing a successful sale or investment. Belize truly is a jewel and it’s no secret that Placencia is THE place to be, rich in both tropical beauty, lifestyle and endless real estate and investment opportunities with great rewards. Founder Boris Mannsfeld successfully developed and sold property in Denver Colorado for many years before transitioning his efforts to Belize. Boris fell in love with the country of Belize upon his first trip in 1992. Besides running the top brokerage firm in Placencia, Boris is heavily invested in the real estate and hospitality markets here owning various businesses, including development projects and resorts. Boris is always excited to share his experience, contacts, knowledge and tourism tips with anyone interested in Belize. His partner Frik De Meyere, originally from Brussels, Belgium fell in love with Barefoot Paradise in 2004. He decided to move with his family to Belize and has since been buying and investing in properties in Placencia, set up a concrete company and spearheaded the start of the Placencia private school. Frik possesses extensive experience in a variety of international real estate projects, and has spearheaded many business development projects and start up companies. If you or your customers are seeking exceptional service, proven experience, professionalism, and the know-how and determination to get things done then look no further. We ARE your experts and your life-time partners here in Placencia, Belize. Even though we specialize in the Placencia peninsula, we have a reliable network of real estate firms and developers throughout Belize with whom we can collaborate to provide you with real estate options across this beautiful country. We look forward to working with you and to welcome you to our amazing lifestyle.
 communitiesPlancencia Belize
 websitehttps://realestateplacencia.com/
 addressMain Street
 address_2
 cityPlacencia, Stann Creek
 state
 full_state
 countryBelize
 marketPlacencia
 market_2
 postal_code
 phone(303) 495-5536
 phone_2
 phone_3
 wide_contact_image(true)
 contact_nameBoris Mannsfeld & Frik De Meyere
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleManager & Sales: Sales & Business Development
 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[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_filename184.jpg
 logo_filename184.jpg
 contact_image_filename184.jpg
 all_properties_link_image_filename184.jpg
 all_properties_linkhttps://realestateplacencia.com/listings/all-listings/
 video_embed_code
 contact_video_embed_code
 meta_titlePlacencia Real Estate⎜Boris Mannsfeld & Associates⎜Leverage Global Partners
 meta_descriptionBoris Mannsfeld & Associates is the exclusive member for Leverage Global Partners in Placencia, Belize.
 meta_keywordsBoris Mannsfeld & Associates, Leverage Global Partners, Boris Mannsfeld, Frik De Meyere, Placencia Real Estate, Belize 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)
 created2015-01-26 09:16:56
 modified2016-04-15 17:17:50
 dre_num012345
 uri/brokerage-detail/184/boris-mannsfeld-associates
 website_shortrealestateplacencia.com
 name_with_locationBoris Mannsfeld & Associates
 Logo(array)
 id2755
 modelBrokerage
 model_id184
 tagLogo
 name184.jpg
 typeimage/jpg
 size798470
 uri/assets/2755.jpg
 order0
 created2016-03-30 11:43:37
 modified2016-04-15 17:17:50
 2(array)
 Brokerage(array)
 id212
 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
 WOEID12485816
 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
 nameProperty BVI Realtors
 broker_of_record_name
 short_nameProperty BVI Realtors
 usernamePropertyBVIRealtors
 password70ff72a576e6d71935d223c42ca432d02da706ab
 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
 descriptionProperty BVI Realtors is the exclusive representative for Leverage Global Partners in the British Virgin Islands, including Islands of Tortola, Virgin Gorda, Anegada, and Jost Van Dyke. <a href="http://www.bvipropertyyacht.com/vi-bvi/readers-choice-2/" target="_blank">Best Real Estate in the BVI</a>
 communitiesBritish Virgin Islands Islands of Tortola Virgin Gorda Anegada Jost Van Dyke
 websitehttp://www.propertybvi.com/PropBVI/pages/home.xhtml
 address19 Waterfront Drive
 address_2
 cityRoad Town, Tortola
 state
 full_state
 countryCaribbean
 marketBritish Virgin Islands
 market_2
 postal_code
 phone(284) 494 0101
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameGreg George
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleFounder/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_filename212.jpg
 logo_filename212.png
 contact_image_filename212.png
 all_properties_link_image_filename212.jpg
 all_properties_linkhttp://www.propertybvi.com/PropBVI/pages/home.xhtml?faces-redirect=true
 video_embed_code
 contact_video_embed_code
 meta_titleBritish Virgin Islands Real Estate⎜Property BVI Realtors⎜Leverage Global Partners
 meta_descriptionProperty BVI Realtors is the exclusive representative for Leverage Global Partners in the British Virgin Islands.
 meta_keywordsProperty BVI Realtors, British Virgin Islands Real Estate, Tortola Real Estate, Road Town Real Estate, Islands of Tortola Real Estate, Virgin Gorda Real Estate, Anegada Real Estate, Jost Van Dyke Real Estate, Greg George, 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)
 created2015-07-06 20:53:31
 modified2016-04-08 16:34:20
 dre_num012345
 uri/brokerage-detail/212/property-bvi-realtors
 website_shortwww.propertybvi.com/PropBVI/pages/home.xhtml
 name_with_locationProperty BVI Realtors
 Logo(array)
 id2764
 modelBrokerage
 model_id212
 tagLogo
 name212.png
 typeimage/png
 size58564
 uri/assets/2764.png
 order0
 created2016-03-30 11:43:39
 modified2016-03-30 11:43:39
 3(array)
 Brokerage(array)
 id9
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id8
 WOEID1118370
 timezoneAsia/Tokyo
 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
 nameHousing Japan
 broker_of_record_name
 short_nameHousing Japan
 usernameHousingJapan
 passwordf672ec38b72eb055ce94ca707e4c7948f6bda00b
 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
 descriptionHousing Japan is the exclusive representative for Leverage Global Partners in Tokyo, Japan. Housing Japan aims to be the innovative leader of real-estate service providers in Japan. Our company philosophy is “Think, Innovate and Create.” It is a part of everything we do. Housing Japan started in 2000 providing leasing services to expatriates relocating to Tokyo. Our business has evolved to provide a broad range of real-estate services to domestic and international clients. Our reputation is built on providing superior levels of service, honest and transparent communication, and achieving great results for our clients. Over the years we have had the privilege to work with clients including many global corporations, finance companies, embassies and international schools. We have also worked on various development projects ranging from beach houses in Chiba to executive houses in Tokyo. Our experienced professionals serve clients everyday with leasing, sales, property management and development projects in Tokyo. We look forward to a future of growth based on the relationships we have built and experiences we have enjoyed over the last decade. We are excited about real estate in Japan and we look forward to working with you.
 communitiesTokyo
 websitehttp://www.housingjapan.com
 addressCR Kamiyacho Bldg. 7F 1-11-9
 address_2
 cityAzabudai, Minato-ku Tokyo
 state
 full_state
 countryJapan
 marketTokyo
 market_2
 postal_codeJapan 106-0041
 phone+81 3 3588 8860
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameMitsuo Hashimoto
 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_filename9.jpg
 logo_filename9.png
 contact_image_filename9.JPG
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_titleTokyo Real Estate | Housing Japan | Leverage Global Partners
 meta_descriptionHousing Japan is the exclusive Tokyo real estate representative for Leverage Global Partners.
 meta_keywordstokyo real estate, housing japan, tokyo, tokyo japan, 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-03-19 16:53:05
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/9/housing-japan
 website_shortwww.housingjapan.com
 name_with_locationHousing Japan
 Logo(array)
 id2266
 modelBrokerage
 model_id9
 tagLogo
 name9.png
 typeimage/png
 size72796
 uri/assets/2266.png
 order0
 created2016-03-30 11:36:11
 modified2016-03-30 11:36:11
- sidebar_locations(array)
 0(array)
 Location(array)
 id27
 parent_id9
 brokerage_id130
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameBend, OR, USA
 short_nameBend, OR, USA
 group_index
 latitude43.965721
 longitude-121.219643
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionDubbed the "outdoor playground of the West" for a thousand good reasons, Central Oregon is world famous for both its outdoor activities and majestic, snow-capped mountain peaks along the high-desert skyline.
 long_descriptionIn the high-desert of Central Oregon just east of the Cascade Range and nestled at the base of the Deschutes National Forest, Bend is to Oregon as Aspen is to Colorado or Truckee is to California. Bend has been growing rapidly over the years making it into the news as one of the best places to move and capturing the attention of retirees, young people, families, and small business entrepreneurs. For many who move to Bend, they are in search of a lifestyle change away from city living and are attracted to the year round ability of playing outside.
 created2016-04-04 11:36:16
 modified2016-04-04 11:36:16
 timezoneAmerica/Los_Angeles
 population200000
 uri/locations/view/27/bend-or-usa
 tile_nameBend, OR, USA
 Brokerage(array)
 id130
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID12798773
 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
 nameTotal Property Resources
 broker_of_record_name
 short_nameTotal Property Resources
 usernameTotalPropertyResource
 password141eb89e9f854e36925435c1cbd9632bbba8132f
 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
 descriptionTotal Property Resources is the exclusive representative for Leverage Global Partners in Bend, Sunriver, Redmond, Sisters, La Pine, Prineville, Tumalo, Crosswater, Pronghorn, Black Butte, Terrebonne, Madras, Powell Butte, Brasada, Culver and surrounding communities in Deschutes, Jefferson and Crook Counties, Oregon, USA. More information coming soon!
 communitiesSunriver Redmond Sisters La Pine Prineville Tumalo Crosswater Pronghorn Black Butte Terrebonne Madras Powell Butte Brasada Culver Deschutes Jefferson Crook
 websitehttp://totalbendrealestate.com/
 address547 SW 13th Street
 address_2Suite 201
 cityBend
 stateOR
 full_stateOregon
 countryUSA
 marketBend
 market_2
 postal_code97702
 phoneOffice: (503) 467-7237
 phone_2Cell: (503) 804-3927
 phone_3
 wide_contact_image(false)
 contact_nameJanis Alexander
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident and 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_filename130.jpg
 logo_filename130.png
 contact_image_filename130.JPG
 all_properties_link_image_filename130.jpg
 all_properties_linkhttp://totalbendrealestate.com/top-picks/
 video_embed_code
 contact_video_embed_code
 meta_titleBend Real Estate | Total Property Resources | Leverage Global Partners
 meta_descriptionTotal Property Resources is the exclusive representative for Leverage Global Partners in the Bend, Oregon, USA.
 meta_keywordsTotal Property Resources, Bend Real Estate, Janis Alexander, Sunriver Real Estate, Redmond Real Estate, Sisters Real Estate, La Pine Real Estate, Prineville Real Estate, Tumalo Real Estate, Crosswater Real Estate, Pronghorn Real Estate, Black Butte Real Estate, Terrebonne Real Estate, Madras Real Estate, Powell Butte Real Estate, Brasada Real Estate, Culver 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-06-06 16:10:01
 modified2016-04-08 16:34:09
 dre_num012345
 uri/brokerage-detail/130/total-property-resources
 website_shorttotalbendrealestate.com
 name_with_locationTotal Property Resources
 Image(array)
 id2955
 modelLocation
 model_id27
 tagImage
 name39922990_tm814.jpg
 typeimage/jpeg
 size676078
 uri/assets/2955.jpg
 order0
 created2016-04-04 11:35:36
 modified2016-04-04 11:36:16
 1(array)
 Location(array)
 id149
 parent_id4
 brokerage_id73
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameLisbon, Portugal
 short_nameLisbon, Portugal
 group_index
 latitude38.722252
 longitude-9.139337
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 07:28:50
 modified2016-04-12 07:28:50
 timezoneEurope/Lisbon
 population530000
 uri/locations/view/149/lisbon-portugal
 tile_nameLisbon, Portugal
 Brokerage(array)
 id73
 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_id13
 WOEID742676
 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_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePorta da Frente
 broker_of_record_name
 short_namePorta da Frente
 usernamePortadaFrente
 password32bdc972eb960b1abb44f4c864b114df2b21e383
 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
 descriptionWe are excited to announce Porta da Frente as the exclusive representative for Leverage Global Partners in Lisbon, Cascais, and Aletenjo, Portugal. Porta da Frente was born in 1995 with the clear objective of specialising in the medium-high to high segments of the residential property market. Entrepreneurial development and specialisation in this area of business have allowed the widening and diversification of the range of services it offers to its clients, a service of full support to the promoter, with particular emphasis on the after-sale phase, guaranteeing maximum assistance in the selection of the property, its sale/purchase/let, design, architecture, assessment of its true commercial value, finance and fiscal and/or legal advice. Porta da Frente has a solid sales team, comprising approximately 35 individuals comprising a department of short and long-term rentals made up of qualified professionals with a clear vocation for giving dedicated attention to each and every client. Increasing demand in other markets has led to the need to create a department exclusively dedicated to the international market. Talent, dedication, attentiveness, personal service and special treatment are traits that make it stand out against all the other players in the market.
 communitieslisbon cascais aletenjo
 websitehttp://www.portadafrente.com/
 addressAvenida Marginal, 8648 B
 address_2
 cityCascais
 state
 full_state
 countryPortugal
 marketLisbon
 market_2
 postal_code
 phone(351) 214 866-560
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameRafael Ascenso
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleGeneral Manager
 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_filename73.jpg
 logo_filename73.jpg
 contact_image_filename73.jpg
 all_properties_link_image_filename73.jpg
 all_properties_linkhttp://www.portadafrente.com/engb/properties
 video_embed_code
 contact_video_embed_code
 meta_titleLisbon Real Estate | Porta de Frente | Leverage Global Partners
 meta_descriptionPorta de Frente is the exclusive representative for Leverage Global Partners in Lisbon, Cascais, and Aletenjo, Portugal.
 meta_keywordsPorta de Frente, Lisbon, Cascais, and Aletenjo, Portugal real estate, lisbon real estate, golden triangle real estate, lisbon real estate, cascais real estate, aletenjo real estate, leverage global partners, Rafael Ascenso
 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-26 18:16:38
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/73/porta-da-frente
 website_shortwww.portadafrente.com
 name_with_locationPorta da Frente
 Image(array)
 id20662
 modelLocation
 model_id149
 tagImage
 nameLisbon.jpg
 typeimage/jpeg
 size244371
 uri/assets/20662.jpg
 order0
 created2016-04-12 07:26:48
 modified2016-04-12 07:28:50
 2(array)
 Location(array)
 id83
 parent_id9
 brokerage_id168
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameNewport Beach, CA, USA
 short_nameNewport Beach, CA, USA
 group_index
 latitude33.599182
 longitude-117.872169
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionCelebrated as an alluring destination, Orange County’s beauty is more than skin deep.
 long_descriptionFrom sunset bike rides along the beach on a warm, summer evening to a quick winter weekend adventure in the mountains. From the alluring artwork of the hottest artists displayed in Laguna Beach, to the Village of Corona del Mar which offers amazing shopping in their seaside boutiques, to the historical architecture of Old Towne Orange and the history of US Presidents in Yorba Linda. Whether you choose a cozy beach bungalow or a custom estate built for a celebrity, there is a place here for everyone to call home. Known the world over as an alluring travel destination, the locals who are lucky enough to call Orange County “home” know that the beauty here is more than skin deep.
 created2016-04-05 10:17:09
 modified2016-04-18 10:38:04
 timezoneAmerica/Los_Angeles
 population3500000
 uri/locations/view/83/newport-beach-ca-usa
 tile_nameNewport Beach, CA, USA
 Brokerage(array)
 id168
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID23417205
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameThe Boutique Real Estate Group
 broker_of_record_name
 short_nameThe Boutique Real Estate Group
 usernameTheBoutiqueRealEstate
 password01759fcc62fbf8022ef42c08f544e99731e7b5f6
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, Corona Del Mar, Balboa Island, Newport Coast, Huntington Beach, Sunset Beach, CA, USA. The Boutique Real Estate Group is a boutique real estate brokerage founded in Orange County, CA, that focuses on brilliant design, beautiful marketing & luxury services and will be opening multiple offices throughout the Southern California Luxury Real Estate Market. The Boutique has created a culture that spurs collaboration, technology and social media with a unique marketing approach. Our story goes a little something like this. Beautiful design evokes emotion. Emotion stirs the soul and creates a connection between client, agent and the home buying & selling process. The Boutique Real Estate Group has invested heavily in bringing all aspects of the real estate experience completely in-house. From custom design, professional staging, amazing photography, cinematography & film production, social media to technology, internet optimization & cloud based transaction management. This not only provides The Boutique with complete control of the design, marketing & technology of luxury real estate but also gives us the look & feel of a true boutique marketing agency. This design & tech-forward approach has earned The Boutique Real Estate Group accolades & awards worldwide. 2015 Inman News Innovator Award for Most Innovative Technology | Nominee 2015 Top 33 People Changing The Real Estate Industry 2014 Best Real Estate Video of The Year 2014 Inman News Innovator Award for Most Innovative Real Estate Agent | Nominee 2014 Next Generation Real Estate Brokerage 2014 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 20 Real Estate Videos in The USA
 communitiesNewport Beach Corona Del Mar Balboa Island Newport Coast Huntington Beach Sunset Beach
 websitehttp://www.theboutiquere.com/
 address3653 E. Coast Hwy
 address_2
 cityCorona Del Mar
 stateCA
 full_stateCalifornia
 countryUSA
 marketNewport Beach
 market_2
 postal_code
 phone(949) 612-2535
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameRaj Qsar
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-raj-qsar-the-boutique-real-estate-group/
 contact_big_profile_link_textMeet Raj
 contact_titlePrincipal/Owner
 contact_dre_num
 contact_quote
 contact_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_filename168.jpg
 logo_filename168.jpg
 contact_image_filename168.jpg
 all_properties_link_image_filename168.jpg
 all_properties_linkhttp://www.theboutiquere.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/xQ9ZyzIQ-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNewport Beach Real Estate⎜The Boutique Real Estate Group⎜Leverage Global Partners
 meta_descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, CA, USA.
 meta_keywordsThe Boutique Real Estate Group, Raj Qsar, Newport Beach Real Estate, Corona Del Mar Real Estate, Balboa Island Real Estate, Newport Coast Real Estate, Huntington Beach Real Estate, Sunset Beach Real Estate, California Real Estate, Leverage Global Partners
 login_message_counter2
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-10-28 16:37:40
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/168/the-boutique-real-estate-group
 website_shortwww.theboutiquere.com
 name_with_locationThe Boutique Real Estate Group
 Image(array)
 id3017
 modelLocation
 model_id83
 tagImage
 name39922990_aerial-beach.jpg
 typeimage/jpeg
 size14013480
 uri/assets/3017.jpg
 order0
 created2016-04-05 10:15:06
 modified2016-04-18 10:38:04
 3(array)
 Location(array)
 id21
 parent_id4
 brokerage_id7
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameLondon, United Kingdom
 short_nameLondon, United Kingdom
 group_index
 latitude51.507351
 longitude-0.127758
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionStylish London offers something for everyone at any time of the year.
 long_descriptionLondon has some of the world’s most stunning architecture and more history than imaginable. From grand period buildings and townhouses, elegant apartments and modern penthouses there is a style of property for every taste. A secure city made up of a series of small districts, London has world-famous shopping areas with exclusive luxury brand designer stores and each of these charming neighbourhoods in this diverse city offers a wealth of cafes, bars and restaurants for residents and visitors to choose from. And with nearly 40% of space taken up with public parks and gardens, London is one of the greenest cities in the world eclipsing many other global cities including Paris, New York and Tokyo.
 created2016-04-04 10:56:57
 modified2016-04-14 15:00:04
 timezoneEurope/London
 population8000000
 uri/locations/view/21/london-united-kingdom
 tile_nameLondon, United Kingdom
 Brokerage(array)
 id7
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id3
 WOEID44418
 timezoneEurope/London
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameBeauchamp Estates
 broker_of_record_name
 short_nameBeauchamp Estates
 usernameBeauchampLondon
 passworddf350318b621cfd44c11f9e03cb52e3b63899384
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_inBeauchamp Estates is the exclusive representative for Leverage Global Partners in London, England.
 short_description
 descriptionBeauchamp Estates is a two-partner, privately owned firm with some thirty years of experience in both the residential and commercial markets, specializing in particular in acquiring and selling prime central London houses, flats and developments. The two partners have worked together since the late 1970’s giving them a sense of continuity rarely experienced by our competitors. Our enthusiasm and dedication has resulted in a client list that reads like a who’s who of clients, applicants and developers alike. With an established international client base, we have successfully opened offices in <a href="../../../brokerage-detail/11/Beauchamp-Estates" target="_blank">Cannes in the South of France</a>, <a href="../../../brokerage-detail/10/Beauchamp-Estates" target="_blank">Mykonos, Greece</a>, and <a href="../../../brokerage-detail/12/Beauchamp-Estates" target="_blank">Florence, Italy</a> and have been able to consolidate and expand our business through these offices.
 communitiesMayfair England United Kingdom UK London England United Kingdom UK Knightsbridge England United Kingdom UK Belgravia England United Kingdom UK Chelsea England United Kingdom UK Regent's Park England United Kingdom UK South Kensington England United Kingdom UK Notting Hill England United Kingdom UK St. Johns Wood England United Kingdom UK Primrose Hill England United Kingdom UK Hampstead England United Kingdom UK
 websitehttp://www.beauchamp.com/
 address24 Curzon Street
 address_2
 cityLondon
 state
 full_state
 countryUnited Kingdom
 marketLondon
 market_2
 postal_codeW1J 7TF
 phone+44 (0) 20 7499 7722
 phone_2+44 (0) 20 7722 9793
 phone_3
 wide_contact_image(false)
 contact_nameGary Hersham
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/gary-hersham-beauchamp-estates-london-england/
 contact_big_profile_link_text
 contact_titleManaging Director/Partner
 contact_dre_num
 contact_quote
 contact_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_filename7.jpg
 logo_filename7.jpg
 contact_image_filename7.JPG
 all_properties_link_image_filename7.jpg
 all_properties_linkhttp://www.beauchamp.co.uk/en/properties/category-sales/
 video_embed_code
 contact_video_embed_code
 meta_titleLondon Real Estate | Beauchamp Estates | Leverage Global Partners
 meta_descriptionBeauchamp Estates is a London real estate brokerage specializing in acquiring and selling prime central London houses, flats and developments. Beauchamp Estates is the exclusive representation in London, England for Leverage Global Partners.
 meta_keywordsbeauchamp estates, london real estate, london england real estate, leverage global partners, gary hersham
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-03-19 14:40:02
 modified2021-07-28 11:19:52
 dre_num012345
 uri/brokerage-detail/7/beauchamp-estates
 website_shortwww.beauchamp.com
 name_with_locationBeauchamp Estates
 Image(array)
 id2948
 modelLocation
 model_id21
 tagImage
 nameLondon.jpg
 typeimage/jpeg
 size148084
 uri/assets/2948.jpg
 order0
 created2016-04-04 10:56:10
 modified2016-04-14 15:00:05
- location_properties(empty)
- main_article(empty)
- brokerage(array)
 Brokerage(array)
 id109
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2356616
 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
 nameRoyce Real Estate
 broker_of_record_name
 short_nameRoyce Real Estate
 usernameRoyceRealEstate
 password06fa50ddb6c4dc5fa684154ab8e1ae9861a667be
 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
 descriptionRoyce Real Estate is the exclusive representative for Leverage Global Partners in Ashland, Talent, and Medford, Oregon, USA. More information coming soon!
 communitiesTalent Medford
 websitehttp://www.roycerealestate.net/
 address145 E Main Street
 address_2
 cityAshland
 stateOR
 full_stateOregon
 countryUSA
 marketAshland
 market_2
 postal_code97502
 phone(541) 482-3814
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameSandy Royce
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner
 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_filename109.jpg
 logo_filename109.png
 contact_image_filename109.jpg
 all_properties_link_image_filename109.jpg
 all_properties_linkhttp://www.roycerealestate.net/ashland-homes-for-sale
 video_embed_code
 contact_video_embed_code
 meta_titleAshland Real Estate | Royce Real Estate | Leverage Global Partners
 meta_descriptionRoyce Real Estate is the exclusive representative for Leverage Global Partners in Ashland, Oregon, USA.
 meta_keywordsRoyce Real Estate, Ashland Real Estate, Sandy Royce, Talent Medford Real Estate, Ashland Oregon, 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-03-31 16:16:13
 modified2016-04-08 16:34:09
 dre_num012345
 uri/brokerage-detail/109/royce-real-estate
 website_shortwww.roycerealestate.net
 name_with_locationRoyce Real Estate - Ashland, OR, 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)
 id2566
 modelBrokerage
 model_id109
 tagLogo
 name109.png
 typeimage/png
 size14989
 uri/assets/2566.png
 order0
 created2016-03-30 11:41:05
 modified2016-03-30 11:41:05
 MainImage(array)
 id2565
 modelBrokerage
 model_id109
 tagMainImage
 name109.jpg
 typeimage/jpg
 size317367
 uri/assets/2565.jpg
 order0
 created2016-03-30 11:41:05
 modified2016-03-30 11:41:05
 ContactImage(array)
 id2567
 modelBrokerage
 model_id109
 tagContactImage
 name109.jpg
 typeimage/jpg
 size621822
 uri/assets/2567.jpg
 order0
 created2016-03-30 11:41:05
 modified2016-03-30 11:41:05
 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)
 id48
 parent_id9
 brokerage_id109
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameAshland, OR, USA
 short_nameAshland, OR, USA
 group_index
 latitude42.194576
 longitude-122.709480
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 12:52:41
 modified2016-04-04 12:52:41
 timezoneAmerica/Los_Angeles
 population21000
 uri/locations/view/48/ashland-or-usa
 tile_nameAshland, OR, USA
 User(array)
 0(array)
 id128
 typeBrokerageAdmin
 brokerage_id109
 email[email protected]
 password06fa50ddb6c4dc5fa684154ab8e1ae9861a667be
 recover_hash
 first_nameSandy
 last_nameRoyce
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2016-04-12 08:27:42
 created2016-04-08 16:34:09
 notified(true)
 full_nameSandy Royce
 uri/agent-detail/128/sandy-royce
 profile_complete(true)
 1(array)
 id643
 typeAgent
 brokerage_id109
 email[email protected]
 password2013b0cbdc6e41d8ee8262257bff586329a695a5
 recover_hash
 first_nameEric
 last_nameBonetti
 title
 dre_num
 phone541-951-7653
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:12
 created2017-08-07 15:23:12
 notified(false)
 full_nameEric Bonetti
 uri/agent-detail/643/eric-bonetti
 profile_complete(true)
 2(array)
 id644
 typeAgent
 brokerage_id109
 email[email protected]
 passworddd3debdda0208e4cf682f48e9e3a35124adfca16
 recover_hash
 first_nameGreg
 last_nameGoebelt
 title
 dre_num
 phone541-840-5966
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:13
 created2017-08-07 15:23:13
 notified(false)
 full_nameGreg Goebelt
 uri/agent-detail/644/greg-goebelt
 profile_complete(true)
- location(array)
 Location(array)
 id48
 parent_id9
 brokerage_id109
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameAshland, OR, USA
 short_nameAshland, OR, USA
 group_index
 latitude42.194576
 longitude-122.709480
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 12:52:41
 modified2016-04-04 12:52:41
 timezoneAmerica/Los_Angeles
 population21000
 uri/locations/view/48/ashland-or-usa
 tile_nameAshland, OR, USA
 Image(array)
 id2976
 modelLocation
 model_id48
 tagImage
 nameRoyce.jpg
 typeimage/jpeg
 size163780
 uri/assets/2976.jpg
 order0
 created2016-04-04 12:52:31
 modified2016-04-04 12:52:41
- 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/48/ashland-or-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/locations/view/48/ashland-or-usa
Remote Port	15364
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	162.159.115.41
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
Http Accept Encoding	gzip, br
Http Accept	/
Http Cf Ray	a09d28c9cd0bb1bb-CMH
Http X Forwarded For	216.73.216.172
Proxy-nokeepalive	1
Ssl Tls Sni	staging2.leveragere.com
Https	on
Passenger Download Native Support Binary	0
Passenger Compile Native Support Binary	0
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Unique Id	aiocWKgWUmgYuyi40B73ZAAAAUA
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	aiocWKgWUmgYuyi40B73ZAAAAUA
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781144664.7014
Request Time	1781144664

====

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

Ashland, OR, 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: 19 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: 19 ms
Total Queries: 19 queries