Properties /

SPANISH STYLE HOME LUSH WITH CHARM

612 N. Sierra Bonita Avenue | Los Angeles, CA 90036, USA | $1,625,000 | MLS ID: 16106916

4 Beds
3 Baths
Guest House

Courtyard Spanish, lush with charm and style. This once-published house offers the best of classic 1920’s LA Spanish melded with today’s amenities and desired open plan. Living room with dramatic barreled ceiling, wedding cake moldings, hardwood floors, rustic brick fireplace, and large garden picture window. Large formal dining room, bathed with light, opens up to a spacious kitchen with stainless steel high-end appliances, tall ceilings, and timeless finishes. Three bedrooms and two baths in the main house. The wisteria-covered patio is ideal for summer al fresco dining. Sunny yard with room for a pool. Expanded and converted garage space with loft and bath completes the rear. Gated long driveway and courtyard front entry makes for a secluded and intimate setting. Great mid-block location – this is the one you’ve been waiting for!

Represented By: Partners Trust Real Estate Brokerage and Acquisitions

thepartnerstrust.com | License #: 012345

Carrie Berkman Lewis
310.500.3991
Email

Main Office: 9378 Wilshire Boulevard,
Suite 200
Beverly Hills, CA 90212
USA

More About Carrie

View On Map Virtual Tour

Highlighted Properties

Elegant Hollywood Hills Beauty

2345 Castilian Drive | Los Angeles , CA 90068
$2,195,000

Newly Constructed Laguna Beach Home

31885 Circle Drive | Laguna Beach, CA 92651
$8,995,000

Represented By

Agent Contacts: Carrie Berkman Lewis 310.500.3991 | Email

Featured Location

Beverly Hills, CA, USA

Iconic Beverly Hills is more than just a famous zip code, this town is synonymous with the good life.

Related Property Listings

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

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

Cake Params
- plugin(null)
- controllerproperties
- actionview
- named(empty)
- pass(array)
  03623
  1612-n-sierra-bonita-avenue-los-angeles-ca-90036-usa
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

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

Sql Log

Sql Logs

default

Total Time: 12 ms
Total Queries: 35 queries

Query	Affected	Num. rows	Took (ms)	Actions
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` = 3623 AND `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`incomplete` = '0' LIMIT 1	1	1	1
SELECT `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` FROM `leveragere_staging2`.`users` AS `AccountExecutive` WHERE `AccountExecutive`.`id` = 236	1	1	0
SELECT `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`.`assets` AS `Logo` WHERE `Logo`.`model_id` = 1 AND `Logo`.`model` = 'Brokerage' AND `Logo`.`tag` = 'Logo'	1	1	0
SELECT `MainImage`.`id`, `MainImage`.`model`, `MainImage`.`model_id`, `MainImage`.`tag`, `MainImage`.`name`, `MainImage`.`type`, `MainImage`.`size`, `MainImage`.`uri`, `MainImage`.`order`, `MainImage`.`created`, `MainImage`.`modified` FROM `leveragere_staging2`.`assets` AS `MainImage` WHERE `MainImage`.`model_id` = 1 AND `MainImage`.`model` = 'Brokerage' AND `MainImage`.`tag` = 'MainImage'	1	1	0
SELECT `ContactImage`.`id`, `ContactImage`.`model`, `ContactImage`.`model_id`, `ContactImage`.`tag`, `ContactImage`.`name`, `ContactImage`.`type`, `ContactImage`.`size`, `ContactImage`.`uri`, `ContactImage`.`order`, `ContactImage`.`created`, `ContactImage`.`modified` FROM `leveragere_staging2`.`assets` AS `ContactImage` WHERE `ContactImage`.`model_id` = 1 AND `ContactImage`.`model` = 'Brokerage' AND `ContactImage`.`tag` = 'ContactImage'	1	1	0
SELECT `ContactImage2`.`id`, `ContactImage2`.`model`, `ContactImage2`.`model_id`, `ContactImage2`.`tag`, `ContactImage2`.`name`, `ContactImage2`.`type`, `ContactImage2`.`size`, `ContactImage2`.`uri`, `ContactImage2`.`order`, `ContactImage2`.`created`, `ContactImage2`.`modified` FROM `leveragere_staging2`.`assets` AS `ContactImage2` WHERE `ContactImage2`.`model_id` = 1 AND `ContactImage2`.`model` = 'Brokerage' AND `ContactImage2`.`tag` = 'ContactImage2'	0	0	0
SELECT `ContactImage3`.`id`, `ContactImage3`.`model`, `ContactImage3`.`model_id`, `ContactImage3`.`tag`, `ContactImage3`.`name`, `ContactImage3`.`type`, `ContactImage3`.`size`, `ContactImage3`.`uri`, `ContactImage3`.`order`, `ContactImage3`.`created`, `ContactImage3`.`modified` FROM `leveragere_staging2`.`assets` AS `ContactImage3` WHERE `ContactImage3`.`model_id` = 1 AND `ContactImage3`.`model` = 'Brokerage' AND `ContactImage3`.`tag` = 'ContactImage3'	0	0	1	maybe slow
SELECT `BrokerOfRecordLogo`.`id`, `BrokerOfRecordLogo`.`model`, `BrokerOfRecordLogo`.`model_id`, `BrokerOfRecordLogo`.`tag`, `BrokerOfRecordLogo`.`name`, `BrokerOfRecordLogo`.`type`, `BrokerOfRecordLogo`.`size`, `BrokerOfRecordLogo`.`uri`, `BrokerOfRecordLogo`.`order`, `BrokerOfRecordLogo`.`created`, `BrokerOfRecordLogo`.`modified` FROM `leveragere_staging2`.`assets` AS `BrokerOfRecordLogo` WHERE `BrokerOfRecordLogo`.`model_id` = 1 AND `BrokerOfRecordLogo`.`model` = 'Brokerage' AND `BrokerOfRecordLogo`.`tag` = 'BrokerOfRecordLogo'	0	0	0
SELECT `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`.`articles` AS `MainArticle` WHERE `MainArticle`.`model_id` = 1 AND `MainArticle`.`model` = 'Brokerage'	0	0	0
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` = (1) 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` = (1)	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` = (1)	35	35	0
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` = (3623) ORDER BY `Image`.`order` ASC	10	10	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`, `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` = 3623 AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	1	1	0
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` WHERE `Brokerage`.`id` = 1	1	1	0
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_id` = 463 AND `Image`.`model` = 'User' AND `Image`.`tag` = 'Image'	0	0	0
SELECT `BrokerageLogoOverride`.`id`, `BrokerageLogoOverride`.`model`, `BrokerageLogoOverride`.`model_id`, `BrokerageLogoOverride`.`tag`, `BrokerageLogoOverride`.`name`, `BrokerageLogoOverride`.`type`, `BrokerageLogoOverride`.`size`, `BrokerageLogoOverride`.`uri`, `BrokerageLogoOverride`.`order`, `BrokerageLogoOverride`.`created`, `BrokerageLogoOverride`.`modified` FROM `leveragere_staging2`.`assets` AS `BrokerageLogoOverride` WHERE `BrokerageLogoOverride`.`model_id` = 463 AND `BrokerageLogoOverride`.`model` = 'User' AND `BrokerageLogoOverride`.`tag` = 'BrokerageLogoOverride'	0	0	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` = 3623 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` = 3623 AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	1	1	0
SELECT `Icon`.`id`, `Icon`.`model`, `Icon`.`model_id`, `Icon`.`tag`, `Icon`.`name`, `Icon`.`type`, `Icon`.`size`, `Icon`.`uri`, `Icon`.`order`, `Icon`.`created`, `Icon`.`modified` FROM `leveragere_staging2`.`assets` AS `Icon` WHERE `Icon`.`model_id` = 5 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	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` = 3623 AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	1	1	0
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_id` = 14 AND `Image`.`model` = 'Topic' AND `Image`.`tag` = 'Image'	1	1	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`.`id` != 3623 AND `Property`.`brokerage_id` = 1 AND `Property`.`status` != 'Sold' AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 2	2	2	6	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 (2866, 2040) ORDER BY `Image`.`order` ASC	19	19	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`, `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 (2866, 2040) 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 (2866, 2040) 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 (2866, 2040) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	5	5	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 (2866, 2040) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	0
SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `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`.`archived` = '0' AND `Location`.`brokerage_id` = 1 LIMIT 1	1	1	1
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` = 1 AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	2	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 (3566, 3738, 3598, 2040) ORDER BY `Image`.`order` ASC	39	39	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 (3566, 3738, 3598, 2040) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	6	6	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 (3566, 3738, 3598, 2040) 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 (3566, 3738, 3598, 2040) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	9	9	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 (3566, 3738, 3598, 2040) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	1	1	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 13.84 MB

Message	Memory use
Component initialization	3.07 MB
Controller action start	4.01 MB
Controller render start	6.87 MB
View render complete	7.39 MB

Timers

Total Request Time: 297 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	74.08
Event: Controller.initialize	9.46
Event: Controller.startup	2.12
Controller action	75.75
Event: Controller.beforeRender	16.30
» Processing toolbar data	16.21
Rendering View	81.81
» Event: View.beforeRender	0.43
» Rendering APP/View/Properties/view.ctp	3.33
» » Rendering APP/View/Elements/static_property_price.ctp	0.45
» » Rendering APP/View/Elements/property_features.ctp	0.22
» » 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/sidebar/location_list.ctp	0.16
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.02
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #5	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #6	0.16
» » » Rendering APP/View/Elements/static_property_price.ctp #7	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	77.22
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)
  id3566
  brokerage_id1
  created_by_user_id0
  order0
  multi_unit(false)
  agent_1_id687
  agent_2_id688
  agent_3_id0
  nameSECLUDED CUL-DE-SAC ESTATE
  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)
  description<p>Come to visit and be prepared to stay. This 4 bedroom 5 bath secluded estate is located on a quiet cul-de-sac in BHPO. With a gated entry and a expansive back yard, the home is transformed into a retreat. The large and spacious rooms are light and bright throughout. The master suite features a fireplace and french doors that open up to the view of the canyons.</p>
  address9982 Reevesbury Drive
  address_2
  cityBeverly Hills
  stateCA
  postal_code90210
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price3495000
  price_20
  price_usd3495000
  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_1
  icon_2
  icon_3
  icon_4
  icon_5
  icon_6
  websitehttp://9982reevesburydrive.thepartnerstrust.com/
  meta_titleSECLUDED CUL-DE-SAC ESTATE | Beverly Hills Real Estate | Partners Trust Real Estate Brokerage and Acquisitions
  meta_description9982 Reevesbury Drive is a property offered for sale in Beverly Hills, CA, USA, presented by Partners Trust Real Estate Brokerage and Acquisitions
  meta_keywords
  bathrooms_partial2
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built1990
  virtual_tour
  video_tourhttp://www.onvedeo.com/properties/645227/embed
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_num16978313
  wsj_property_typesingle family
  nyt_property_type1
  nyt_popular_features
  propgolux_property_type9
  juwai_property_type
  juwai_category
  propgolux_property_style22
  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.111031
  longitude-118.436546
  invalid_required_fields
  invalid_optional_fieldssquare_feet, square_meters, acres, hectares, virtual_tour
  went_live_today(false)
  converted(true)
  invalid(false)
  mlsidx_full_address
  mlsidx_date_listed0000-00-00
  mls_market
  primary_property_category_id0
  realstaq_initial_image_sync(false)
  digital_ad_listing_urls_automated(null)
  modified2016-04-18 05:33:03
  created2016-03-07 10:47:55
  uri/property-detail/3566/9982-reevesbury-drive-beverly-hills-ca-90210-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/3566/9982-reevesbury-drive-beverly-hills-ca-90210-usa
  address_concat9982 Reevesbury Drive Beverly Hills CA 90210 USA
  google_maps_query_string9982+Reevesbury+Drive++Beverly+Hills+CA+90210+USA
  luxury_ad_enrolled_prettyNO
  price_prettyUSD 3,495,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty4
  bathrooms_pretty2
  bathrooms_partial_pretty2
  bathrooms_3_4_pretty0
  feed_full_bathrooms2
  date_listed2016-03-07
  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)
  id1
  account_executive_id236
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties12
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties1
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(true)
  country_id1
  WOEID2363796
  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
  usernamePartnersTrustBH
  password2a77eb13ee7deac93b310ba1431a4982bfdbddeb
  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
  description<h2> </h2> <p>Partners Trust is the exclusive representative for Leverage Global Partners in Beverly Hills, California, USA.</p> <p>We are dedicated to being the finest real estate brokerage in Los Angeles.</p> <p>At Partners Trust, our objective is to present our clients with the most professional, successful and ethical real estate associates in the business and to represent our clients with care, confidentiality and the utmost attention to service. We believe we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market.</p> <p>We begin with a commodity that is hard-earned and easily lost: TRUST.</p> <p>Without the daily demonstration and commitment to uphold principles, a company’s mission statement is simply words on a page and nothing more. Partners Trust has adopted a mission statement that each Associate and staff member must sign to in order to participate with the Company, which articulates the core philosophy and culture of the Company.</p> <p>The Partners Trust founders utilized their extensive experience and resources to create a Company that is both unique and beneficial for those willing to commit to the rigorous standards that have been set forth. The Company’s intention is to empower each member of its sales force each and every step of the way.</p> <p>Partners Trust has additional office locations in <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/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" target="_blank">Malibu</a> and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a></p>
  communitiesBeverly Hills Bel Air Century City Westwood West Hollywood
  websitehttp://thepartnerstrust.com
  address9378 Wilshire Boulevard
  address_2Suite 200
  cityBeverly Hills
  stateCA
  full_stateCalifornia
  countryUSA
  marketBeverly Hills
  market_2
  postal_code90212
  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_filename1.jpg
  logo_filename1.png
  contact_image_filename1.jpg
  all_properties_link_image_filename1.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_titleBeverly Hills Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
  meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions is an award-winning real estate brokerage representing Leverage Global Partners in Beverly Hills, CA, USA.
  meta_keywordspartners trust, partners trust real estate, beverly hills real estate, beverly hills real estate agents, 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)
  created2013-02-21 13:57:13
  modified2016-04-08 16:33:22
  dre_num012345
  uri/brokerage-detail/1/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)
  id19813
  modelProperty
  model_id3566
  tagImage
  name34655.jpg
  typeimage/jpg
  size923860
  uri/assets/19813.jpg
  order2742
  created2016-04-07 17:24:58
  modified2016-04-07 17:24:58
  1(array)
  id19814
  modelProperty
  model_id3566
  tagImage
  name34656.jpg
  typeimage/jpg
  size599347
  uri/assets/19814.jpg
  order2743
  created2016-04-07 17:24:58
  modified2016-04-07 17:24:58
  2(array)
  id19815
  modelProperty
  model_id3566
  tagImage
  name34657.jpg
  typeimage/jpg
  size218034
  uri/assets/19815.jpg
  order2744
  created2016-04-07 17:24:58
  modified2016-04-07 17:24:58
  3(array)
  id19816
  modelProperty
  model_id3566
  tagImage
  name34658.jpg
  typeimage/jpg
  size388516
  uri/assets/19816.jpg
  order2745
  created2016-04-07 17:24:58
  modified2016-04-07 17:24:58
  4(array)
  id19817
  modelProperty
  model_id3566
  tagImage
  name34659.jpg
  typeimage/jpg
  size425242
  uri/assets/19817.jpg
  order2746
  created2016-04-07 17:24:58
  modified2016-04-07 17:24:58
  5(array)
  id19818
  modelProperty
  model_id3566
  tagImage
  name34660.jpg
  typeimage/jpg
  size303817
  uri/assets/19818.jpg
  order2747
  created2016-04-07 17:24:58
  modified2016-04-07 17:24:58
  6(array)
  id19819
  modelProperty
  model_id3566
  tagImage
  name34661.jpg
  typeimage/jpg
  size406689
  uri/assets/19819.jpg
  order2748
  created2016-04-07 17:24:58
  modified2016-04-07 17:24:58
  7(array)
  id19820
  modelProperty
  model_id3566
  tagImage
  name34662.jpg
  typeimage/jpg
  size384623
  uri/assets/19820.jpg
  order2749
  created2016-04-07 17:24:58
  modified2016-04-07 17:24:59
  8(array)
  id19821
  modelProperty
  model_id3566
  tagImage
  name34663.jpg
  typeimage/jpg
  size432084
  uri/assets/19821.jpg
  order2750
  created2016-04-07 17:24:59
  modified2016-04-07 17:24:59
  9(array)
  id19822
  modelProperty
  model_id3566
  tagImage
  name34664.jpg
  typeimage/jpg
  size807213
  uri/assets/19822.jpg
  order2751
  created2016-04-07 17:24:59
  modified2016-04-07 17:24:59
  User(array)
  0(array)
  id883
  typeAgent
  brokerage_id1
  email[email protected]
  passwordfcdc1daba00182c29679f13a2802491b4bcd9bc4
  recover_hash
  first_nameDavid
  last_nameBerg
  title
  dre_num
  phone310.500.3931
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2020-07-27 12:50:45
  created2017-08-07 15:23:42
  notified(false)
  full_nameDavid Berg
  uri/agent-detail/883/david-berg
  profile_complete(true)
  UsersProperty(array)
  id646
  user_id883
  property_id3566
  sort_order0
  1(array)
  id884
  typeAgent
  brokerage_id1
  email[email protected]
  password8092091892b0e96c04879de4bff4fa69762bf808
  recover_hash
  first_nameF. Ron
  last_nameSmith
  title
  dre_num
  phone310.500.1373
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:23:43
  created2017-08-07 15:23:43
  notified(false)
  full_nameF. Ron Smith
  uri/agent-detail/884/f-ron-smith
  profile_complete(true)
  UsersProperty(array)
  id650
  user_id884
  property_id3566
  sort_order0
  SecondaryPropertyCategory(empty)
  PropertyFeature(empty)
  Topic(empty)
  1(array)
  Property(array)
  id3738
  brokerage_id1
  created_by_user_id0
  order0
  multi_unit(false)
  agent_1_id0
  agent_2_id0
  agent_3_id0
  nameTastefully Updated and Maintained Deluxe Condo in a Phenomenal Location
  incomplete(false)
  archived(false)
  last_archived0000-00-00 00:00:00
  auto_archived_from_mlsidx(false)
  paid_featured(false)
  featured(false)
  homepage_featured(false)
  brokerage_page_featured(false)
  requested_homepage_featured_by_member(false)
  homepage_featured_by_member(false)
  dot_luxury_featured(false)
  luxury_feed_featured(true)
  force_luxury_feed_featured(false)
  luxury_autofeed_imported(false)
  luxury_feed_last_added_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)
  description<p>Tastefully updated and impeccably maintained top floor deluxe condominium with dazzling city & mountain views! Owner spared no expense remodeling this bright and spacious home. Amazing open kitchen with GE profile appliances, custom cabinetry, tumbled stone backsplash, granite countertops, & 46 bottle wine fridge. Both bathrooms are renovated with travertine and have skylights. Newer AC with wireless thermostat. Floor to ceiling windows bring in lots of light and VIEWS. Other features include LED energy efficient recessed lights with dimmers, surround sound speakers, newer doors, huge secluded balcony, huge bedroom with views & en-suite closet, & much more. Building has EQ insurance, pool, spa, courtyard, guest parking, copper plumbing, renovated elevator & hallways, and low HOA dues. Phenomenal location moments from Runyon Canyon Park, Hollywood & Highland, the Metro-Rail Subway, Rock & Roll Ralph's, and West Hollywood. This unit is immaculate & pristine. Please see private remarks.</p>
  address7270 Hillside Avenue
  address_2Unit 307
  cityLos Angeles
  stateCA
  postal_code90046
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price529000
  price_20
  price_usd529000
  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)
  bedrooms1
  bedrooms_20
  bathrooms2
  bathrooms_20
  no_beds_baths(false)
  square_feet929
  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://7270hillsideavenue307.thepartnerstrust.com/
  meta_title
  meta_description
  meta_keywords
  bathrooms_partial0
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built1965
  virtual_tour
  video_tourhttp://www.onvedeo.com/properties/759796/embed
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_num16114060
  wsj_property_typecondominium
  nyt_property_type5
  nyt_popular_features
  propgolux_property_type2
  juwai_property_type
  juwai_category
  propgolux_property_style16
  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.104309
  longitude-118.348297
  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_id3
  realstaq_initial_image_sync(false)
  digital_ad_listing_urls_automated(null)
  modified2019-08-22 10:12:40
  created2016-04-18 08:50:12
  uri/property-detail/3738/7270-hillside-avenue-unit-307-los-angeles-ca-90046-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/3738/7270-hillside-avenue-unit-307-los-angeles-ca-90046-usa
  address_concat7270 Hillside Avenue Unit 307 Los Angeles CA 90046 USA
  google_maps_query_string7270+Hillside+Avenue+Unit+307+Los+Angeles+CA+90046+USA
  luxury_ad_enrolled_prettyYES
  price_prettyUSD 529,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty1
  bathrooms_pretty2
  bathrooms_partial_pretty0
  bathrooms_3_4_pretty0
  feed_full_bathrooms2
  date_listed2016-04-18
  overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
  overridden_brokerage_logo_uri
  lux_ad_auto_enrolled(false)
  PrimaryPropertyCategory(array)
  id3
  nameUnder $1 Million
  created2019-08-22 10:08:27
  modified2019-08-29 09:59:08
  uri/category-detail/3/under-1-million
  Brokerage(array)
  id1
  account_executive_id236
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties12
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties1
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(true)
  country_id1
  WOEID2363796
  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
  usernamePartnersTrustBH
  password2a77eb13ee7deac93b310ba1431a4982bfdbddeb
  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
  description<h2> </h2> <p>Partners Trust is the exclusive representative for Leverage Global Partners in Beverly Hills, California, USA.</p> <p>We are dedicated to being the finest real estate brokerage in Los Angeles.</p> <p>At Partners Trust, our objective is to present our clients with the most professional, successful and ethical real estate associates in the business and to represent our clients with care, confidentiality and the utmost attention to service. We believe we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market.</p> <p>We begin with a commodity that is hard-earned and easily lost: TRUST.</p> <p>Without the daily demonstration and commitment to uphold principles, a company’s mission statement is simply words on a page and nothing more. Partners Trust has adopted a mission statement that each Associate and staff member must sign to in order to participate with the Company, which articulates the core philosophy and culture of the Company.</p> <p>The Partners Trust founders utilized their extensive experience and resources to create a Company that is both unique and beneficial for those willing to commit to the rigorous standards that have been set forth. The Company’s intention is to empower each member of its sales force each and every step of the way.</p> <p>Partners Trust has additional office locations in <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/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" target="_blank">Malibu</a> and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a></p>
  communitiesBeverly Hills Bel Air Century City Westwood West Hollywood
  websitehttp://thepartnerstrust.com
  address9378 Wilshire Boulevard
  address_2Suite 200
  cityBeverly Hills
  stateCA
  full_stateCalifornia
  countryUSA
  marketBeverly Hills
  market_2
  postal_code90212
  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_filename1.jpg
  logo_filename1.png
  contact_image_filename1.jpg
  all_properties_link_image_filename1.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_titleBeverly Hills Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
  meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions is an award-winning real estate brokerage representing Leverage Global Partners in Beverly Hills, CA, USA.
  meta_keywordspartners trust, partners trust real estate, beverly hills real estate, beverly hills real estate agents, 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)
  created2013-02-21 13:57:13
  modified2016-04-08 16:33:22
  dre_num012345
  uri/brokerage-detail/1/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)
  id20942
  modelProperty
  model_id3738
  tagImage
  name1.jpg
  typeimage/jpeg
  size508290
  uri/assets/20942.jpg
  order0
  created2016-04-18 08:49:08
  modified2019-08-22 10:12:34
  1(array)
  id20935
  modelProperty
  model_id3738
  tagImage
  name4.jpg
  typeimage/jpeg
  size309359
  uri/assets/20935.jpg
  order1
  created2016-04-18 08:49:08
  modified2019-08-22 10:12:34
  2(array)
  id20934
  modelProperty
  model_id3738
  tagImage
  name22.jpg
  typeimage/jpeg
  size298555
  uri/assets/20934.jpg
  order2
  created2016-04-18 08:49:08
  modified2019-08-22 10:12:34
  3(array)
  id20940
  modelProperty
  model_id3738
  tagImage
  name16.jpg
  typeimage/jpeg
  size376361
  uri/assets/20940.jpg
  order3
  created2016-04-18 08:49:08
  modified2019-08-22 10:12:34
  4(array)
  id20937
  modelProperty
  model_id3738
  tagImage
  name23.jpg
  typeimage/jpeg
  size288132
  uri/assets/20937.jpg
  order4
  created2016-04-18 08:49:08
  modified2019-08-22 10:12:34
  5(array)
  id20933
  modelProperty
  model_id3738
  tagImage
  name25.jpg
  typeimage/jpeg
  size272129
  uri/assets/20933.jpg
  order5
  created2016-04-18 08:49:08
  modified2019-08-22 10:12:34
  6(array)
  id20936
  modelProperty
  model_id3738
  tagImage
  name26.jpg
  typeimage/jpeg
  size292700
  uri/assets/20936.jpg
  order6
  created2016-04-18 08:49:08
  modified2019-08-22 10:12:34
  7(array)
  id20939
  modelProperty
  model_id3738
  tagImage
  name8.jpg
  typeimage/jpeg
  size420302
  uri/assets/20939.jpg
  order7
  created2016-04-18 08:49:08
  modified2019-08-22 10:12:34
  8(array)
  id20938
  modelProperty
  model_id3738
  tagImage
  name27.jpg
  typeimage/jpeg
  size402446
  uri/assets/20938.jpg
  order8
  created2016-04-18 08:49:08
  modified2019-08-22 10:12:34
  9(array)
  id20941
  modelProperty
  model_id3738
  tagImage
  name30.jpg
  typeimage/jpeg
  size524194
  uri/assets/20941.jpg
  order9
  created2016-04-18 08:49:08
  modified2019-08-22 10:12:34
  User(array)
  0(array)
  id1277
  typeAgent
  brokerage_id1
  email[email protected]
  password8e8b5fcac6e3ab69670f2940cd8f2f3461040a84
  recover_hash
  first_nameJimmy
  last_nameMartinez
  title
  dre_num
  phone323.377.0548
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:24:02
  created2017-08-07 15:24:02
  notified(false)
  full_nameJimmy Martinez
  uri/agent-detail/1277/jimmy-martinez
  profile_complete(true)
  UsersProperty(array)
  id1103
  user_id1277
  property_id3738
  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)
  id4724
  property_id3738
  property_feature_id14
  1(array)
  id4
  nameGarage
  additional(false)
  created2016-04-07 14:01:52
  modified2016-04-07 14:01:52
  PropertiesPropertyFeature(array)
  id4723
  property_id3738
  property_feature_id4
  2(array)
  id1
  nameBalcony/Terrace
  additional(false)
  created2016-04-07 14:00:26
  modified2016-04-07 14:00:26
  PropertiesPropertyFeature(array)
  id4722
  property_id3738
  property_feature_id1
  Topic(array)
  0(array)
  id4
  nameKiller Views
  created2016-02-25 11:25:00
  modified2016-02-25 11:33:10
  tile_nameKiller Views
  PropertiesTopic(array)
  id51
  property_id3738
  topic_id4
  2(array)
  Property(array)
  id3598
  brokerage_id1
  created_by_user_id0
  order0
  multi_unit(false)
  agent_1_id475
  agent_2_id474
  agent_3_id0
  nameLIFESTYLE DESIGNED 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)
  description<p>Enter via wood/iron electric gates & circular driveway professionally designed by RH Modern landscape architect Sean Femrite. Graceful 2-story entry leads to liv rm w/ frplc & new oversized pane windows while a wood paneled den beckons w/walk up bar. Beamed ceilings crown a formal din rm. Entertainer's kitchen w/ custom armoire refrigs/frzrs, Center Island, built-in leather banquet, butler's pantry & 800+bottle wine room. Adjoining fam rm w/ frplc opens to the bckyrd. A bdrm ste & powder rm complete the downstairs. Upstairs discover 2 bdrm suites w/ access to a balcony overlooking the bckyrd. Mstr ste has a beam ceiling, frplc, Juliet balcony, & dual custom fitted walk in closets. Mstr ba pampers w/ a Victoria & Albert soaking tub, steam shower, dual sinks & toilets. Grounds include zero edge pool, Spa w/ water feature, built-in BBQ, din loggia, outdr den w/fire-pit & separate art studio/gym. Add'l Features include too many to list. A truly special lifestyle designed home!</p>
  address1715 Chevy Chase Drive
  address_2
  cityBeverly Hills
  stateCA
  postal_code90210
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price6995000
  price_20
  price_usd6995000
  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
  bathrooms4
  bathrooms_20
  no_beds_baths(false)
  square_feet4723
  square_meters
  acres0
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size0
  icon_1sq-ft
  icon_2guest-house
  icon_3pool
  icon_4cellar
  icon_5
  icon_6
  websitehttp://1715chevychasedrive.thepartnerstrust.com/
  meta_titleLIFESTYLE DESIGNED HOME | Beverly Hills Real Estate | Partners Trust Real Estate Brokerage and Acquisitions
  meta_description1715 Chevy Chase Drive is a property offered for sale in Beverly Hills, CA, USA, presented by Partners Trust Real Estate Brokerage and Acquisitions
  meta_keywords
  bathrooms_partial1
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built1935
  virtual_tour
  video_tourhttp://www.onvedeo.com/properties/697613/embed
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_num16104480
  wsj_property_typesingle family
  nyt_property_type1
  nyt_popular_features
  propgolux_property_type9
  juwai_property_type
  juwai_category
  propgolux_property_style42
  wapo_property_type
  robb_property_type
  propgolux_location_id_override
  open_house_1_start0000-00-00 00:00:00
  open_house_1_end_time00:00:00
  latitude34.084286
  longitude-118.422569
  invalid_required_fields
  invalid_optional_fieldssquare_meters, acres, hectares, virtual_tour
  went_live_today(false)
  converted(true)
  invalid(false)
  mlsidx_full_address
  mlsidx_date_listed0000-00-00
  mls_market
  primary_property_category_id0
  realstaq_initial_image_sync(false)
  digital_ad_listing_urls_automated(null)
  modified2016-04-18 05:33:03
  created2016-03-15 16:15:13
  uri/property-detail/3598/1715-chevy-chase-drive-beverly-hills-ca-90210-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/3598/1715-chevy-chase-drive-beverly-hills-ca-90210-usa
  address_concat1715 Chevy Chase Drive Beverly Hills CA 90210 USA
  google_maps_query_string1715+Chevy+Chase+Drive++Beverly+Hills+CA+90210+USA
  luxury_ad_enrolled_prettyNO
  price_prettyUSD 6,995,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty4
  bathrooms_pretty4
  bathrooms_partial_pretty1
  bathrooms_3_4_pretty0
  feed_full_bathrooms4
  date_listed2016-03-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)
  id1
  account_executive_id236
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties12
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties1
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(true)
  country_id1
  WOEID2363796
  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
  usernamePartnersTrustBH
  password2a77eb13ee7deac93b310ba1431a4982bfdbddeb
  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
  description<h2> </h2> <p>Partners Trust is the exclusive representative for Leverage Global Partners in Beverly Hills, California, USA.</p> <p>We are dedicated to being the finest real estate brokerage in Los Angeles.</p> <p>At Partners Trust, our objective is to present our clients with the most professional, successful and ethical real estate associates in the business and to represent our clients with care, confidentiality and the utmost attention to service. We believe we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market.</p> <p>We begin with a commodity that is hard-earned and easily lost: TRUST.</p> <p>Without the daily demonstration and commitment to uphold principles, a company’s mission statement is simply words on a page and nothing more. Partners Trust has adopted a mission statement that each Associate and staff member must sign to in order to participate with the Company, which articulates the core philosophy and culture of the Company.</p> <p>The Partners Trust founders utilized their extensive experience and resources to create a Company that is both unique and beneficial for those willing to commit to the rigorous standards that have been set forth. The Company’s intention is to empower each member of its sales force each and every step of the way.</p> <p>Partners Trust has additional office locations in <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/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" target="_blank">Malibu</a> and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a></p>
  communitiesBeverly Hills Bel Air Century City Westwood West Hollywood
  websitehttp://thepartnerstrust.com
  address9378 Wilshire Boulevard
  address_2Suite 200
  cityBeverly Hills
  stateCA
  full_stateCalifornia
  countryUSA
  marketBeverly Hills
  market_2
  postal_code90212
  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_filename1.jpg
  logo_filename1.png
  contact_image_filename1.jpg
  all_properties_link_image_filename1.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_titleBeverly Hills Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
  meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions is an award-winning real estate brokerage representing Leverage Global Partners in Beverly Hills, CA, USA.
  meta_keywordspartners trust, partners trust real estate, beverly hills real estate, beverly hills real estate agents, 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)
  created2013-02-21 13:57:13
  modified2016-04-08 16:33:22
  dre_num012345
  uri/brokerage-detail/1/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)
  id19965
  modelProperty
  model_id3598
  tagImage
  name34946.jpg
  typeimage/jpg
  size1947900
  uri/assets/19965.jpg
  order2745
  created2016-04-07 17:25:14
  modified2016-04-07 17:25:14
  1(array)
  id19966
  modelProperty
  model_id3598
  tagImage
  name34947.jpg
  typeimage/jpg
  size630154
  uri/assets/19966.jpg
  order2746
  created2016-04-07 17:25:14
  modified2016-04-07 17:25:14
  2(array)
  id19967
  modelProperty
  model_id3598
  tagImage
  name34948.jpg
  typeimage/jpg
  size802122
  uri/assets/19967.jpg
  order2747
  created2016-04-07 17:25:14
  modified2016-04-07 17:25:15
  3(array)
  id19968
  modelProperty
  model_id3598
  tagImage
  name34949.jpg
  typeimage/jpg
  size784532
  uri/assets/19968.jpg
  order2748
  created2016-04-07 17:25:15
  modified2016-04-07 17:25:15
  4(array)
  id19969
  modelProperty
  model_id3598
  tagImage
  name34950.jpg
  typeimage/jpg
  size631248
  uri/assets/19969.jpg
  order2749
  created2016-04-07 17:25:15
  modified2016-04-07 17:25:15
  5(array)
  id19970
  modelProperty
  model_id3598
  tagImage
  name34951.jpg
  typeimage/jpg
  size437945
  uri/assets/19970.jpg
  order2750
  created2016-04-07 17:25:15
  modified2016-04-07 17:25:15
  6(array)
  id19971
  modelProperty
  model_id3598
  tagImage
  name34952.jpg
  typeimage/jpg
  size600563
  uri/assets/19971.jpg
  order2751
  created2016-04-07 17:25:15
  modified2016-04-07 17:25:15
  7(array)
  id19972
  modelProperty
  model_id3598
  tagImage
  name34953.jpg
  typeimage/jpg
  size1045122
  uri/assets/19972.jpg
  order2752
  created2016-04-07 17:25:15
  modified2016-04-07 17:25:15
  8(array)
  id19973
  modelProperty
  model_id3598
  tagImage
  name34954.jpg
  typeimage/jpg
  size1646355
  uri/assets/19973.jpg
  order2753
  created2016-04-07 17:25:15
  modified2016-04-07 17:25:15
  9(array)
  id19974
  modelProperty
  model_id3598
  tagImage
  name34955.jpg
  typeimage/jpg
  size519908
  uri/assets/19974.jpg
  order2754
  created2016-04-07 17:25:15
  modified2016-04-07 17:25:15
  User(array)
  0(array)
  id681
  typeAgent
  brokerage_id1
  email[email protected]
  password22992f76f576546bd954e4ffa280f0668c475b28
  recover_hash
  first_nameNancy
  last_nameRoss
  title
  dre_num
  phone310.968.4180
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:23:15
  created2017-08-07 15:23:15
  notified(false)
  full_nameNancy Ross
  uri/agent-detail/681/nancy-ross
  profile_complete(true)
  UsersProperty(array)
  id467
  user_id681
  property_id3598
  sort_order0
  1(array)
  id682
  typeAgent
  brokerage_id1
  email[email protected]
  password0a36b9c3a6ddc65e65ac59315cae7cc2781f40ce
  recover_hash
  first_nameLaura
  last_nameBarton
  title
  dre_num
  phone310.600.2746
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:23:15
  created2017-08-07 15:23:15
  notified(false)
  full_nameLaura Barton
  uri/agent-detail/682/laura-barton
  profile_complete(true)
  UsersProperty(array)
  id468
  user_id682
  property_id3598
  sort_order0
  SecondaryPropertyCategory(empty)
  PropertyFeature(array)
  0(array)
  id5
  nameGuest House
  additional(false)
  created2016-04-07 14:02:13
  modified2016-04-07 14:02:13
  PropertiesPropertyFeature(array)
  id4222
  property_id3598
  property_feature_id5
  1(array)
  id12
  nameSwimming Pool
  additional(false)
  created2016-04-07 14:04:12
  modified2016-04-07 14:04:12
  PropertiesPropertyFeature(array)
  id4223
  property_id3598
  property_feature_id12
  2(array)
  id18
  nameWine Cellar
  additional(false)
  created2016-04-07 14:06:17
  modified2016-04-07 14:06:17
  PropertiesPropertyFeature(array)
  id4224
  property_id3598
  property_feature_id18
  Topic(empty)
  3(array)
  Property(array)
  id2040
  brokerage_id1
  created_by_user_id0
  order1
  multi_unit(false)
  agent_1_id515
  agent_2_id0
  agent_3_id0
  nameNewly Constructed Laguna Beach 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)
  description<p>Like a luxurious yacht anchored at the shore, with stunning unobstructed ocean views from nearly every room and world-class style at each turn, this newly constructed, never-before-lived-in custom estate blends state-of-the-art with top-of-the-line over a cove adjacent to Thousand Steps beach in Laguna. Inspiring, sleek, sexy, warm, smart and inviting, the architectural masterpiece is one of only a few brand-new homes on the coast in Laguna Beach, reflecting more than a decade of design and construction that has resulted in a virtually transparent 3-level estate destined to remain a significant residential achievement for generations to come. A blend of modern and organic finishes and fine details impresses at every glance, including globally sourced lighting, vanishing door systems, a circular pneumatic elevator, cutting-edge furnishings, and an unparalleled smart home system controlled from in-home wall pads or anywhere on earth via smart devices. 3 of 4 bedrooms offer custom fireplaces, 6 bathrooms are unique from one another, and a great room and kitchen level offers clean lines and high-end appliances. Natural finishes abound, including marble, onyx, recycled glass, polished stones, rustic wood tile, walnut, steel, pine and more.</p>
  address31885 Circle Drive
  address_2
  cityLaguna Beach
  stateCA
  postal_code92651
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price8995000
  price_20
  price_usd8995000
  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_feet3400
  square_meters
  acres0
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size0
  icon_1sq-ft
  icon_2
  icon_3views
  icon_4balcony-terrace
  icon_5beach-access
  icon_6
  websitehttp://www.thepartnerstrust.com/property/43069696/31885-Circle-Drive-Laguna-Beach-CA-92651
  meta_titleNewly Constructed Laguna Beach Home | Laguna Beach Real Estate | Partners Trust Real Estate Brokerage and Acquisitions
  meta_description31885 Circle Drive is a property offered for sale in Laguna Beach, CA, USA, presented by Partners Trust Real Estate Brokerage and Acquisitions
  meta_keywords
  bathrooms_partial1
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built2014
  virtual_tour
  video_tour
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_numLG15137916MR
  wsj_property_typesingle family
  nyt_property_type1
  nyt_popular_features
  propgolux_property_type9
  juwai_property_type
  juwai_category
  propgolux_property_style22
  wapo_property_type
  robb_property_type
  propgolux_location_id_override
  open_house_1_start0000-00-00 00:00:00
  open_house_1_end_time00:00:00
  latitude33.498810
  longitude-117.742920
  invalid_required_fields
  invalid_optional_fieldsagent_2_id, square_meters, acres, hectares, virtual_tour, video_tour
  went_live_today(false)
  converted(true)
  invalid(false)
  mlsidx_full_address
  mlsidx_date_listed0000-00-00
  mls_market
  primary_property_category_id0
  realstaq_initial_image_sync(false)
  digital_ad_listing_urls_automated(null)
  modified2016-04-18 05:33:02
  created2015-04-28 13:48:30
  uri/property-detail/2040/31885-circle-drive-laguna-beach-ca-92651-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/2040/31885-circle-drive-laguna-beach-ca-92651-usa
  address_concat31885 Circle Drive Laguna Beach CA 92651 USA
  google_maps_query_string31885+Circle+Drive++Laguna+Beach+CA+92651+USA
  luxury_ad_enrolled_prettyNO
  price_prettyUSD 8,995,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty4
  bathrooms_pretty5
  bathrooms_partial_pretty1
  bathrooms_3_4_pretty0
  feed_full_bathrooms5
  date_listed2015-04-28
  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)
  id1
  account_executive_id236
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties12
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties1
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(true)
  country_id1
  WOEID2363796
  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
  usernamePartnersTrustBH
  password2a77eb13ee7deac93b310ba1431a4982bfdbddeb
  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
  description<h2> </h2> <p>Partners Trust is the exclusive representative for Leverage Global Partners in Beverly Hills, California, USA.</p> <p>We are dedicated to being the finest real estate brokerage in Los Angeles.</p> <p>At Partners Trust, our objective is to present our clients with the most professional, successful and ethical real estate associates in the business and to represent our clients with care, confidentiality and the utmost attention to service. We believe we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market.</p> <p>We begin with a commodity that is hard-earned and easily lost: TRUST.</p> <p>Without the daily demonstration and commitment to uphold principles, a company’s mission statement is simply words on a page and nothing more. Partners Trust has adopted a mission statement that each Associate and staff member must sign to in order to participate with the Company, which articulates the core philosophy and culture of the Company.</p> <p>The Partners Trust founders utilized their extensive experience and resources to create a Company that is both unique and beneficial for those willing to commit to the rigorous standards that have been set forth. The Company’s intention is to empower each member of its sales force each and every step of the way.</p> <p>Partners Trust has additional office locations in <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/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" target="_blank">Malibu</a> and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a></p>
  communitiesBeverly Hills Bel Air Century City Westwood West Hollywood
  websitehttp://thepartnerstrust.com
  address9378 Wilshire Boulevard
  address_2Suite 200
  cityBeverly Hills
  stateCA
  full_stateCalifornia
  countryUSA
  marketBeverly Hills
  market_2
  postal_code90212
  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_filename1.jpg
  logo_filename1.png
  contact_image_filename1.jpg
  all_properties_link_image_filename1.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_titleBeverly Hills Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
  meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions is an award-winning real estate brokerage representing Leverage Global Partners in Beverly Hills, CA, USA.
  meta_keywordspartners trust, partners trust real estate, beverly hills real estate, beverly hills real estate agents, 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)
  created2013-02-21 13:57:13
  modified2016-04-08 16:33:22
  dre_num012345
  uri/brokerage-detail/1/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)
  id14354
  modelProperty
  model_id2040
  tagImage
  name18628.jpg
  typeimage/jpg
  size244826
  uri/assets/14354.jpg
  order0
  created2016-04-07 16:45:08
  modified2016-04-07 16:45:08
  1(array)
  id14357
  modelProperty
  model_id2040
  tagImage
  name18631.jpg
  typeimage/jpg
  size354159
  uri/assets/14357.jpg
  order1
  created2016-04-07 16:45:08
  modified2016-04-07 16:45:08
  2(array)
  id14356
  modelProperty
  model_id2040
  tagImage
  name18630.jpg
  typeimage/jpg
  size246312
  uri/assets/14356.jpg
  order2
  created2016-04-07 16:45:08
  modified2016-04-07 16:45:08
  3(array)
  id14355
  modelProperty
  model_id2040
  tagImage
  name18629.jpg
  typeimage/jpg
  size219790
  uri/assets/14355.jpg
  order3
  created2016-04-07 16:45:08
  modified2016-04-07 16:45:08
  4(array)
  id14361
  modelProperty
  model_id2040
  tagImage
  name18635.jpg
  typeimage/jpg
  size212437
  uri/assets/14361.jpg
  order4
  created2016-04-07 16:45:08
  modified2016-04-07 16:45:08
  5(array)
  id14358
  modelProperty
  model_id2040
  tagImage
  name18632.jpg
  typeimage/jpg
  size285643
  uri/assets/14358.jpg
  order5
  created2016-04-07 16:45:08
  modified2016-04-07 16:45:08
  6(array)
  id14359
  modelProperty
  model_id2040
  tagImage
  name18633.jpg
  typeimage/jpg
  size264040
  uri/assets/14359.jpg
  order6
  created2016-04-07 16:45:08
  modified2016-04-07 16:45:08
  7(array)
  id14360
  modelProperty
  model_id2040
  tagImage
  name18634.jpg
  typeimage/jpg
  size310890
  uri/assets/14360.jpg
  order7
  created2016-04-07 16:45:08
  modified2016-04-07 16:45:08
  8(array)
  id14362
  modelProperty
  model_id2040
  tagImage
  name18636.jpg
  typeimage/jpg
  size327830
  uri/assets/14362.jpg
  order8
  created2016-04-07 16:45:08
  modified2016-04-07 16:45:08
  User(array)
  0(array)
  id717
  typeAgent
  brokerage_id1
  email[email protected]
  passwordd4308f9ca1b0188685e49a21d4b3476e7a6c24fe
  recover_hash
  first_nameKevin
  last_nameDees
  title
  dre_num
  phone310.500.3015
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:23:17
  created2017-08-07 15:23:17
  notified(false)
  full_nameKevin Dees
  uri/agent-detail/717/kevin-dees
  profile_complete(true)
  UsersProperty(array)
  id492
  user_id717
  property_id2040
  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)
  id2851
  property_id2040
  property_feature_id14
  1(array)
  id1
  nameBalcony/Terrace
  additional(false)
  created2016-04-07 14:00:26
  modified2016-04-07 14:00:26
  PropertiesPropertyFeature(array)
  id2852
  property_id2040
  property_feature_id1
  2(array)
  id2
  nameBeach Access
  additional(false)
  created2016-04-07 14:00:52
  modified2016-04-07 14:00:52
  PropertiesPropertyFeature(array)
  id2853
  property_id2040
  property_feature_id2
  Topic(empty)
- sidebar_locations(array)
  0(array)
  Location(array)
  id33
  parent_id9
  brokerage_id1
  typeExclusive
  archived(false)
  use_as_topic(true)
  nameBeverly Hills, CA, USA
  short_nameBeverly Hills, CA, USA
  group_index
  latitude34.073620
  longitude-118.400352
  country_code
  north53.700001
  south19.700001
  east-52.599998
  west-146.600006
  zoom0
  short_descriptionIconic Beverly Hills is more than just a famous zip code, this town is synonymous with the good life.
  long_descriptionKnown around the world as a symbol of luxury and beauty, Beverly Hills is more than just a pretty face. Behind the flash of Rodeo Drive and the trendy allure of Robertson Blvd. is a city rich in culture and historic style. As a world-renowned shopping destination, Beverly Hills boasts some of the best boutiques in the area and nearly every major luxury brand has a presence in the city. Celebrity sightings are common among those who want to see and be seen. The city’s long history means that a variety of architectural styles abound, from the grand mansions to more modest older homes. Much of the real estate lies in the flats, which features all sorts of homes for sale from Tudors and Spanish Revivals to newer modern architecturals.
  created2016-04-04 12:04:35
  modified2016-04-14 10:50:42
  timezoneAmerica/Los_Angeles
  population35000
  uri/locations/view/33/beverly-hills-ca-usa
  tile_nameBeverly Hills, CA, USA
  Brokerage(array)
  id1
  account_executive_id236
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties12
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties1
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(true)
  country_id1
  WOEID2363796
  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
  usernamePartnersTrustBH
  password2a77eb13ee7deac93b310ba1431a4982bfdbddeb
  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
  description<h2> </h2> <p>Partners Trust is the exclusive representative for Leverage Global Partners in Beverly Hills, California, USA.</p> <p>We are dedicated to being the finest real estate brokerage in Los Angeles.</p> <p>At Partners Trust, our objective is to present our clients with the most professional, successful and ethical real estate associates in the business and to represent our clients with care, confidentiality and the utmost attention to service. We believe we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market.</p> <p>We begin with a commodity that is hard-earned and easily lost: TRUST.</p> <p>Without the daily demonstration and commitment to uphold principles, a company’s mission statement is simply words on a page and nothing more. Partners Trust has adopted a mission statement that each Associate and staff member must sign to in order to participate with the Company, which articulates the core philosophy and culture of the Company.</p> <p>The Partners Trust founders utilized their extensive experience and resources to create a Company that is both unique and beneficial for those willing to commit to the rigorous standards that have been set forth. The Company’s intention is to empower each member of its sales force each and every step of the way.</p> <p>Partners Trust has additional office locations in <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/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" target="_blank">Malibu</a> and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a></p>
  communitiesBeverly Hills Bel Air Century City Westwood West Hollywood
  websitehttp://thepartnerstrust.com
  address9378 Wilshire Boulevard
  address_2Suite 200
  cityBeverly Hills
  stateCA
  full_stateCalifornia
  countryUSA
  marketBeverly Hills
  market_2
  postal_code90212
  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_filename1.jpg
  logo_filename1.png
  contact_image_filename1.jpg
  all_properties_link_image_filename1.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_titleBeverly Hills Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
  meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions is an award-winning real estate brokerage representing Leverage Global Partners in Beverly Hills, CA, USA.
  meta_keywordspartners trust, partners trust real estate, beverly hills real estate, beverly hills real estate agents, 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)
  created2013-02-21 13:57:13
  modified2016-04-08 16:33:22
  dre_num012345
  uri/brokerage-detail/1/partners-trust-real-estate-brokerage-and-acquisitions
  website_shortthepartnerstrust.com
  name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
  Image(array)
  id2961
  modelLocation
  model_id33
  tagImage
  nameBeverly Hills.jpg
  typeimage/jpeg
  size147969
  uri/assets/2961.jpg
  order0
  created2016-04-04 12:04:27
  modified2016-04-14 10:50:42
- highlighted_properties(array)
  0(array)
  Property(array)
  id2866
  brokerage_id1
  created_by_user_id0
  order6
  multi_unit(false)
  agent_1_id946
  agent_2_id68
  agent_3_id257
  nameElegant Hollywood Hills Beauty
  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)
  description<p>Elegant Hollywood Hills Spanish c. 1946. This Mediterranean beauty sits poised to enjoy views from every room. Features include a gracious formal living and dining room, an extensively remodeled cook's kitchen, a spacious master suite starring a relaxing bath with enviable views, steam shower andFrench doors opening to it's own private patio. There are 2 additional bedrooms ~ both en suite, gleaming wood floors and period built-ins. This home has a walled courtyard entry, direct access garage and multiple patio areas with space for entertaining. Enjoy a cool night in the hot tub or dinner el fresco. Welcome home to Old Hollywood Romance.</p>
  address2345 Castilian Drive
  address_2
  cityLos Angeles
  stateCA
  postal_code90068
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price2195000
  price_20
  price_usd2195000
  price_usd_20
  statusFor Sale
  status_last_changed0000-00-00 00:00:00
  status_last_changed_price_only0000-00-00 00:00:00
  lease_period
  price_upon_request(false)
  bedrooms3
  bedrooms_20
  bathrooms3
  bathrooms_20
  no_beds_baths(false)
  square_feet0
  square_meters
  acres0
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size0
  icon_1views
  icon_2balcony-terrace
  icon_3
  icon_4
  icon_5
  icon_6
  websitehttp://www.thepartnerstrust.com/property/43528835/2345-Castilian-Drive-Los-Angeles-CA-90068
  meta_titleElegant Hollywood Hills Beauty | Los Angeles Real Estate | Partners Trust Real Estate Brokerage and Acquisitions
  meta_description2345 Castilian Drive is a property offered for sale in Los Angeles , CA, USA, presented by Partners Trust Real Estate Brokerage and Acquisitions
  meta_keywords
  bathrooms_partial1
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built1946
  virtual_tour
  video_tour
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_num16-972363
  wsj_property_typesingle family
  nyt_property_type1
  nyt_popular_features
  propgolux_property_type9
  juwai_property_type
  juwai_category
  propgolux_property_style39
  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.112915
  longitude-118.343582
  invalid_required_fields
  invalid_optional_fieldssquare_feet, square_meters, acres, hectares, virtual_tour, video_tour
  went_live_today(false)
  converted(true)
  invalid(false)
  mlsidx_full_address
  mlsidx_date_listed0000-00-00
  mls_market
  primary_property_category_id0
  realstaq_initial_image_sync(false)
  digital_ad_listing_urls_automated(null)
  modified2016-04-18 05:33:02
  created2015-10-06 17:53:43
  uri/property-detail/2866/2345-castilian-drive-los-angeles-ca-90068-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/2866/2345-castilian-drive-los-angeles-ca-90068-usa
  address_concat2345 Castilian Drive Los Angeles CA 90068 USA
  google_maps_query_string2345+Castilian+Drive++Los+Angeles++CA+90068+USA
  luxury_ad_enrolled_prettyNO
  price_prettyUSD 2,195,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty3
  bathrooms_pretty3
  bathrooms_partial_pretty1
  bathrooms_3_4_pretty0
  feed_full_bathrooms3
  date_listed2015-10-06
  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)
  id1
  account_executive_id236
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties12
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties1
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(true)
  country_id1
  WOEID2363796
  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
  usernamePartnersTrustBH
  password2a77eb13ee7deac93b310ba1431a4982bfdbddeb
  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
  description<h2> </h2> <p>Partners Trust is the exclusive representative for Leverage Global Partners in Beverly Hills, California, USA.</p> <p>We are dedicated to being the finest real estate brokerage in Los Angeles.</p> <p>At Partners Trust, our objective is to present our clients with the most professional, successful and ethical real estate associates in the business and to represent our clients with care, confidentiality and the utmost attention to service. We believe we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market.</p> <p>We begin with a commodity that is hard-earned and easily lost: TRUST.</p> <p>Without the daily demonstration and commitment to uphold principles, a company’s mission statement is simply words on a page and nothing more. Partners Trust has adopted a mission statement that each Associate and staff member must sign to in order to participate with the Company, which articulates the core philosophy and culture of the Company.</p> <p>The Partners Trust founders utilized their extensive experience and resources to create a Company that is both unique and beneficial for those willing to commit to the rigorous standards that have been set forth. The Company’s intention is to empower each member of its sales force each and every step of the way.</p> <p>Partners Trust has additional office locations in <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/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" target="_blank">Malibu</a> and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a></p>
  communitiesBeverly Hills Bel Air Century City Westwood West Hollywood
  websitehttp://thepartnerstrust.com
  address9378 Wilshire Boulevard
  address_2Suite 200
  cityBeverly Hills
  stateCA
  full_stateCalifornia
  countryUSA
  marketBeverly Hills
  market_2
  postal_code90212
  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_filename1.jpg
  logo_filename1.png
  contact_image_filename1.jpg
  all_properties_link_image_filename1.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_titleBeverly Hills Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
  meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions is an award-winning real estate brokerage representing Leverage Global Partners in Beverly Hills, CA, USA.
  meta_keywordspartners trust, partners trust real estate, beverly hills real estate, beverly hills real estate agents, 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)
  created2013-02-21 13:57:13
  modified2016-04-08 16:33:22
  dre_num012345
  uri/brokerage-detail/1/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)
  id17150
  modelProperty
  model_id2866
  tagImage
  name27366.jpg
  typeimage/jpg
  size507151
  uri/assets/17150.jpg
  order0
  created2016-04-07 17:02:17
  modified2016-04-07 17:02:17
  1(array)
  id17144
  modelProperty
  model_id2866
  tagImage
  name27360.jpg
  typeimage/jpg
  size394257
  uri/assets/17144.jpg
  order1
  created2016-04-07 17:02:16
  modified2016-04-07 17:02:16
  2(array)
  id17145
  modelProperty
  model_id2866
  tagImage
  name27361.jpg
  typeimage/jpg
  size300242
  uri/assets/17145.jpg
  order2
  created2016-04-07 17:02:16
  modified2016-04-07 17:02:17
  3(array)
  id17146
  modelProperty
  model_id2866
  tagImage
  name27362.jpg
  typeimage/jpg
  size365378
  uri/assets/17146.jpg
  order3
  created2016-04-07 17:02:17
  modified2016-04-07 17:02:17
  4(array)
  id17149
  modelProperty
  model_id2866
  tagImage
  name27365.jpg
  typeimage/jpg
  size418243
  uri/assets/17149.jpg
  order4
  created2016-04-07 17:02:17
  modified2016-04-07 17:02:17
  5(array)
  id17147
  modelProperty
  model_id2866
  tagImage
  name27363.jpg
  typeimage/jpg
  size386285
  uri/assets/17147.jpg
  order5
  created2016-04-07 17:02:17
  modified2016-04-07 17:02:17
  6(array)
  id17148
  modelProperty
  model_id2866
  tagImage
  name27364.jpg
  typeimage/jpg
  size361110
  uri/assets/17148.jpg
  order6
  created2016-04-07 17:02:17
  modified2016-04-07 17:02:17
  7(array)
  id17143
  modelProperty
  model_id2866
  tagImage
  name27359.jpg
  typeimage/jpg
  size463104
  uri/assets/17143.jpg
  order7
  created2016-04-07 17:02:16
  modified2016-04-07 17:02:16
  8(array)
  id17151
  modelProperty
  model_id2866
  tagImage
  name34944.jpg
  typeimage/jpg
  size1665820
  uri/assets/17151.jpg
  order8
  created2016-04-07 17:02:17
  modified2016-04-07 17:02:17
  9(array)
  id17152
  modelProperty
  model_id2866
  tagImage
  name34945.jpg
  typeimage/jpg
  size1639396
  uri/assets/17152.jpg
  order9
  created2016-04-07 17:02:17
  modified2016-04-07 17:02:17
  User(array)
  0(array)
  id300
  typeAgent
  brokerage_id1
  email[email protected]
  password00fef6ffbbe0ee7288deec08e424f56096dbc9eb
  recover_hash
  first_nameNick
  last_nameSegal
  title
  dre_num
  phone310.500.1388
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:41
  created2017-08-07 15:22:41
  notified(false)
  full_nameNick Segal
  uri/agent-detail/300/nick-segal
  profile_complete(true)
  UsersProperty(array)
  id77
  user_id300
  property_id2866
  sort_order0
  1(array)
  id471
  typeAgent
  brokerage_id1
  email[email protected]
  passwordd776606bb6319d1a7d897ec6767bcd2bb8bcc27d
  recover_hash
  first_nameRick
  last_nameOjeda
  title
  dre_num
  phone310.500.1343
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:59
  created2017-08-07 15:22:59
  notified(false)
  full_nameRick Ojeda
  uri/agent-detail/471/rick-ojeda
  profile_complete(true)
  UsersProperty(array)
  id295
  user_id471
  property_id2866
  sort_order0
  2(array)
  id1109
  typeAgent
  brokerage_id1
  email[email protected]
  password2db95aa8e432230a14ab3ed86c1e6f5eecfea00b
  recover_hash
  first_nameKatrina
  last_nameWebb
  title
  dre_num
  phone323.387.8011
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:23:54
  created2017-08-07 15:23:54
  notified(false)
  full_nameKatrina Webb
  uri/agent-detail/1109/katrina-webb
  profile_complete(true)
  UsersProperty(array)
  id877
  user_id1109
  property_id2866
  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)
  id3590
  property_id2866
  property_feature_id14
  1(array)
  id1
  nameBalcony/Terrace
  additional(false)
  created2016-04-07 14:00:26
  modified2016-04-07 14:00:26
  PropertiesPropertyFeature(array)
  id3591
  property_id2866
  property_feature_id1
  Topic(empty)
  1(array)
  Property(array)
  id2040
  brokerage_id1
  created_by_user_id0
  order1
  multi_unit(false)
  agent_1_id515
  agent_2_id0
  agent_3_id0
  nameNewly Constructed Laguna Beach 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)
  description<p>Like a luxurious yacht anchored at the shore, with stunning unobstructed ocean views from nearly every room and world-class style at each turn, this newly constructed, never-before-lived-in custom estate blends state-of-the-art with top-of-the-line over a cove adjacent to Thousand Steps beach in Laguna. Inspiring, sleek, sexy, warm, smart and inviting, the architectural masterpiece is one of only a few brand-new homes on the coast in Laguna Beach, reflecting more than a decade of design and construction that has resulted in a virtually transparent 3-level estate destined to remain a significant residential achievement for generations to come. A blend of modern and organic finishes and fine details impresses at every glance, including globally sourced lighting, vanishing door systems, a circular pneumatic elevator, cutting-edge furnishings, and an unparalleled smart home system controlled from in-home wall pads or anywhere on earth via smart devices. 3 of 4 bedrooms offer custom fireplaces, 6 bathrooms are unique from one another, and a great room and kitchen level offers clean lines and high-end appliances. Natural finishes abound, including marble, onyx, recycled glass, polished stones, rustic wood tile, walnut, steel, pine and more.</p>
  address31885 Circle Drive
  address_2
  cityLaguna Beach
  stateCA
  postal_code92651
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price8995000
  price_20
  price_usd8995000
  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_feet3400
  square_meters
  acres0
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size0
  icon_1sq-ft
  icon_2
  icon_3views
  icon_4balcony-terrace
  icon_5beach-access
  icon_6
  websitehttp://www.thepartnerstrust.com/property/43069696/31885-Circle-Drive-Laguna-Beach-CA-92651
  meta_titleNewly Constructed Laguna Beach Home | Laguna Beach Real Estate | Partners Trust Real Estate Brokerage and Acquisitions
  meta_description31885 Circle Drive is a property offered for sale in Laguna Beach, CA, USA, presented by Partners Trust Real Estate Brokerage and Acquisitions
  meta_keywords
  bathrooms_partial1
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built2014
  virtual_tour
  video_tour
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_numLG15137916MR
  wsj_property_typesingle family
  nyt_property_type1
  nyt_popular_features
  propgolux_property_type9
  juwai_property_type
  juwai_category
  propgolux_property_style22
  wapo_property_type
  robb_property_type
  propgolux_location_id_override
  open_house_1_start0000-00-00 00:00:00
  open_house_1_end_time00:00:00
  latitude33.498810
  longitude-117.742920
  invalid_required_fields
  invalid_optional_fieldsagent_2_id, square_meters, acres, hectares, virtual_tour, video_tour
  went_live_today(false)
  converted(true)
  invalid(false)
  mlsidx_full_address
  mlsidx_date_listed0000-00-00
  mls_market
  primary_property_category_id0
  realstaq_initial_image_sync(false)
  digital_ad_listing_urls_automated(null)
  modified2016-04-18 05:33:02
  created2015-04-28 13:48:30
  uri/property-detail/2040/31885-circle-drive-laguna-beach-ca-92651-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/2040/31885-circle-drive-laguna-beach-ca-92651-usa
  address_concat31885 Circle Drive Laguna Beach CA 92651 USA
  google_maps_query_string31885+Circle+Drive++Laguna+Beach+CA+92651+USA
  luxury_ad_enrolled_prettyNO
  price_prettyUSD 8,995,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty4
  bathrooms_pretty5
  bathrooms_partial_pretty1
  bathrooms_3_4_pretty0
  feed_full_bathrooms5
  date_listed2015-04-28
  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)
  id1
  account_executive_id236
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties12
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties1
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(true)
  country_id1
  WOEID2363796
  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
  usernamePartnersTrustBH
  password2a77eb13ee7deac93b310ba1431a4982bfdbddeb
  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
  description<h2> </h2> <p>Partners Trust is the exclusive representative for Leverage Global Partners in Beverly Hills, California, USA.</p> <p>We are dedicated to being the finest real estate brokerage in Los Angeles.</p> <p>At Partners Trust, our objective is to present our clients with the most professional, successful and ethical real estate associates in the business and to represent our clients with care, confidentiality and the utmost attention to service. We believe we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market.</p> <p>We begin with a commodity that is hard-earned and easily lost: TRUST.</p> <p>Without the daily demonstration and commitment to uphold principles, a company’s mission statement is simply words on a page and nothing more. Partners Trust has adopted a mission statement that each Associate and staff member must sign to in order to participate with the Company, which articulates the core philosophy and culture of the Company.</p> <p>The Partners Trust founders utilized their extensive experience and resources to create a Company that is both unique and beneficial for those willing to commit to the rigorous standards that have been set forth. The Company’s intention is to empower each member of its sales force each and every step of the way.</p> <p>Partners Trust has additional office locations in <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/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" target="_blank">Malibu</a> and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a></p>
  communitiesBeverly Hills Bel Air Century City Westwood West Hollywood
  websitehttp://thepartnerstrust.com
  address9378 Wilshire Boulevard
  address_2Suite 200
  cityBeverly Hills
  stateCA
  full_stateCalifornia
  countryUSA
  marketBeverly Hills
  market_2
  postal_code90212
  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_filename1.jpg
  logo_filename1.png
  contact_image_filename1.jpg
  all_properties_link_image_filename1.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_titleBeverly Hills Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
  meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions is an award-winning real estate brokerage representing Leverage Global Partners in Beverly Hills, CA, USA.
  meta_keywordspartners trust, partners trust real estate, beverly hills real estate, beverly hills real estate agents, 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)
  created2013-02-21 13:57:13
  modified2016-04-08 16:33:22
  dre_num012345
  uri/brokerage-detail/1/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)
  id14354
  modelProperty
  model_id2040
  tagImage
  name18628.jpg
  typeimage/jpg
  size244826
  uri/assets/14354.jpg
  order0
  created2016-04-07 16:45:08
  modified2016-04-07 16:45:08
  1(array)
  id14357
  modelProperty
  model_id2040
  tagImage
  name18631.jpg
  typeimage/jpg
  size354159
  uri/assets/14357.jpg
  order1
  created2016-04-07 16:45:08
  modified2016-04-07 16:45:08
  2(array)
  id14356
  modelProperty
  model_id2040
  tagImage
  name18630.jpg
  typeimage/jpg
  size246312
  uri/assets/14356.jpg
  order2
  created2016-04-07 16:45:08
  modified2016-04-07 16:45:08
  3(array)
  id14355
  modelProperty
  model_id2040
  tagImage
  name18629.jpg
  typeimage/jpg
  size219790
  uri/assets/14355.jpg
  order3
  created2016-04-07 16:45:08
  modified2016-04-07 16:45:08
  4(array)
  id14361
  modelProperty
  model_id2040
  tagImage
  name18635.jpg
  typeimage/jpg
  size212437
  uri/assets/14361.jpg
  order4
  created2016-04-07 16:45:08
  modified2016-04-07 16:45:08
  5(array)
  id14358
  modelProperty
  model_id2040
  tagImage
  name18632.jpg
  typeimage/jpg
  size285643
  uri/assets/14358.jpg
  order5
  created2016-04-07 16:45:08
  modified2016-04-07 16:45:08
  6(array)
  id14359
  modelProperty
  model_id2040
  tagImage
  name18633.jpg
  typeimage/jpg
  size264040
  uri/assets/14359.jpg
  order6
  created2016-04-07 16:45:08
  modified2016-04-07 16:45:08
  7(array)
  id14360
  modelProperty
  model_id2040
  tagImage
  name18634.jpg
  typeimage/jpg
  size310890
  uri/assets/14360.jpg
  order7
  created2016-04-07 16:45:08
  modified2016-04-07 16:45:08
  8(array)
  id14362
  modelProperty
  model_id2040
  tagImage
  name18636.jpg
  typeimage/jpg
  size327830
  uri/assets/14362.jpg
  order8
  created2016-04-07 16:45:08
  modified2016-04-07 16:45:08
  User(array)
  0(array)
  id717
  typeAgent
  brokerage_id1
  email[email protected]
  passwordd4308f9ca1b0188685e49a21d4b3476e7a6c24fe
  recover_hash
  first_nameKevin
  last_nameDees
  title
  dre_num
  phone310.500.3015
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:23:17
  created2017-08-07 15:23:17
  notified(false)
  full_nameKevin Dees
  uri/agent-detail/717/kevin-dees
  profile_complete(true)
  UsersProperty(array)
  id492
  user_id717
  property_id2040
  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)
  id2851
  property_id2040
  property_feature_id14
  1(array)
  id1
  nameBalcony/Terrace
  additional(false)
  created2016-04-07 14:00:26
  modified2016-04-07 14:00:26
  PropertiesPropertyFeature(array)
  id2852
  property_id2040
  property_feature_id1
  2(array)
  id2
  nameBeach Access
  additional(false)
  created2016-04-07 14:00:52
  modified2016-04-07 14:00:52
  PropertiesPropertyFeature(array)
  id2853
  property_id2040
  property_feature_id2
  Topic(empty)
- custom_ga_event_properties(array)
  brokeragePartners Trust Real Estate Brokerage and Acquisitions, Beverly Hills
- property(array)
  Property(array)
  id3623
  brokerage_id1
  created_by_user_id0
  order0
  multi_unit(false)
  agent_1_id249
  agent_2_id0
  agent_3_id0
  nameSPANISH STYLE HOME LUSH WITH CHARM
  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)
  description<p>Courtyard Spanish, lush with charm and style. This once-published house offers the best of classic 1920’s LA Spanish melded with today’s amenities and desired open plan. Living room with dramatic barreled ceiling, wedding cake moldings, hardwood floors, rustic brick fireplace, and large garden picture window. Large formal dining room, bathed with light, opens up to a spacious kitchen with stainless steel high-end appliances, tall ceilings, and timeless finishes. Three bedrooms and two baths in the main house. The wisteria-covered patio is ideal for summer al fresco dining. Sunny yard with room for a pool. Expanded and converted garage space with loft and bath completes the rear. Gated long driveway and courtyard front entry makes for a secluded and intimate setting. Great mid-block location – this is the one you’ve been waiting for!</p>
  address612 N. Sierra Bonita Avenue
  address_2
  cityLos Angeles
  stateCA
  postal_code90036
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price1625000
  price_20
  price_usd1625000
  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_feet2085
  square_meters
  acres0
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size0
  icon_1sq-ft
  icon_2guest-house
  icon_3
  icon_4
  icon_5
  icon_6
  website
  meta_titleSPANISH STYLE HOME LUSH WITH CHARM | Los Angeles Real Estate | Partners Trust Real Estate Brokerage and Acquisitions
  meta_description612 N. Sierra Bonita Avenue is a property offered for sale in Los Angeles, CA, USA, presented by Partners Trust Real Estate Brokerage and Acquisitions
  meta_keywords
  bathrooms_partial0
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built1926
  virtual_tourhttp://612sierrabonita.com/
  video_tour
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_num16106916
  wsj_property_typesingle family
  nyt_property_type1
  nyt_popular_features
  propgolux_property_type9
  juwai_property_type
  juwai_category
  propgolux_property_style39
  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.082245
  longitude-118.353958
  invalid_required_fields
  invalid_optional_fieldsagent_2_id, bathrooms_partial, square_meters, acres, hectares, video_tour
  went_live_today(false)
  converted(true)
  invalid(false)
  mlsidx_full_address
  mlsidx_date_listed0000-00-00
  mls_market
  primary_property_category_id0
  realstaq_initial_image_sync(false)
  digital_ad_listing_urls_automated(null)
  modified2016-04-18 05:33:03
  created2016-03-18 14:52:10
  uri/property-detail/3623/612-n-sierra-bonita-avenue-los-angeles-ca-90036-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/3623/612-n-sierra-bonita-avenue-los-angeles-ca-90036-usa
  address_concat612 N. Sierra Bonita Avenue Los Angeles CA 90036 USA
  google_maps_query_string612+N.+Sierra+Bonita+Avenue++Los+Angeles+CA+90036+USA
  luxury_ad_enrolled_prettyNO
  price_prettyUSD 1,625,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty4
  bathrooms_pretty3
  bathrooms_partial_pretty0
  bathrooms_3_4_pretty0
  feed_full_bathrooms3
  date_listed2016-03-18
  overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
  overridden_brokerage_logo_uri/assets/2230.png
  lux_ad_auto_enrolled(false)
  PrimaryPropertyCategory(array)
  id(null)
  name(null)
  created(null)
  modified(null)
  Brokerage(array)
  id1
  account_executive_id236
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties12
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties1
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(true)
  country_id1
  WOEID2363796
  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
  usernamePartnersTrustBH
  password2a77eb13ee7deac93b310ba1431a4982bfdbddeb
  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
  description<h2> </h2> <p>Partners Trust is the exclusive representative for Leverage Global Partners in Beverly Hills, California, USA.</p> <p>We are dedicated to being the finest real estate brokerage in Los Angeles.</p> <p>At Partners Trust, our objective is to present our clients with the most professional, successful and ethical real estate associates in the business and to represent our clients with care, confidentiality and the utmost attention to service. We believe we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market.</p> <p>We begin with a commodity that is hard-earned and easily lost: TRUST.</p> <p>Without the daily demonstration and commitment to uphold principles, a company’s mission statement is simply words on a page and nothing more. Partners Trust has adopted a mission statement that each Associate and staff member must sign to in order to participate with the Company, which articulates the core philosophy and culture of the Company.</p> <p>The Partners Trust founders utilized their extensive experience and resources to create a Company that is both unique and beneficial for those willing to commit to the rigorous standards that have been set forth. The Company’s intention is to empower each member of its sales force each and every step of the way.</p> <p>Partners Trust has additional office locations in <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/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" target="_blank">Malibu</a> and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a></p>
  communitiesBeverly Hills Bel Air Century City Westwood West Hollywood
  websitehttp://thepartnerstrust.com
  address9378 Wilshire Boulevard
  address_2Suite 200
  cityBeverly Hills
  stateCA
  full_stateCalifornia
  countryUSA
  marketBeverly Hills
  market_2
  postal_code90212
  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_filename1.jpg
  logo_filename1.png
  contact_image_filename1.jpg
  all_properties_link_image_filename1.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_titleBeverly Hills Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
  meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions is an award-winning real estate brokerage representing Leverage Global Partners in Beverly Hills, CA, USA.
  meta_keywordspartners trust, partners trust real estate, beverly hills real estate, beverly hills real estate agents, 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)
  created2013-02-21 13:57:13
  modified2016-04-08 16:33:22
  dre_num012345
  AccountExecutive(array)
  id236
  typeAccountExecutive
  brokerage_id0
  email[email protected]
  passworde5cc5a96287695cf8b7cace1463b1699895dcf92
  recover_hash
  first_nameLauren
  last_namePena
  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:16
  created2016-04-14 15:43:52
  notified(false)
  full_nameLauren Pena
  uri/agent-detail/236/lauren-pena
  profile_complete(true)
  Logo(array)
  id2230
  modelBrokerage
  model_id1
  tagLogo
  name1.png
  typeimage/png
  size101949
  uri/assets/2230.png
  order0
  created2016-03-30 11:35:41
  modified2016-03-30 11:35:41
  MainImage(array)
  id2229
  modelBrokerage
  model_id1
  tagMainImage
  name1.jpg
  typeimage/jpg
  size2458551
  uri/assets/2229.jpg
  order0
  created2016-03-30 11:35:40
  modified2016-03-30 11:35:40
  ContactImage(array)
  id2231
  modelBrokerage
  model_id1
  tagContactImage
  name1.jpg
  typeimage/jpg
  size5965844
  uri/assets/2231.jpg
  order0
  created2016-03-30 11:35:41
  modified2016-03-30 11:35:41
  ContactImage2(empty)
  ContactImage3(empty)
  BrokerOfRecordLogo(empty)
  MainArticle(empty)
  FeaturedImage(empty)
  Location(array)
  0(array)
  id33
  parent_id9
  brokerage_id1
  typeExclusive
  archived(false)
  use_as_topic(true)
  nameBeverly Hills, CA, USA
  short_nameBeverly Hills, CA, USA
  group_index
  latitude34.073620
  longitude-118.400352
  country_code
  north53.700001
  south19.700001
  east-52.599998
  west-146.600006
  zoom0
  short_descriptionIconic Beverly Hills is more than just a famous zip code, this town is synonymous with the good life.
  long_descriptionKnown around the world as a symbol of luxury and beauty, Beverly Hills is more than just a pretty face. Behind the flash of Rodeo Drive and the trendy allure of Robertson Blvd. is a city rich in culture and historic style. As a world-renowned shopping destination, Beverly Hills boasts some of the best boutiques in the area and nearly every major luxury brand has a presence in the city. Celebrity sightings are common among those who want to see and be seen. The city’s long history means that a variety of architectural styles abound, from the grand mansions to more modest older homes. Much of the real estate lies in the flats, which features all sorts of homes for sale from Tudors and Spanish Revivals to newer modern architecturals.
  created2016-04-04 12:04:35
  modified2016-04-14 10:50:42
  timezoneAmerica/Los_Angeles
  population35000
  uri/locations/view/33/beverly-hills-ca-usa
  tile_nameBeverly Hills, CA, USA
  User(array)
  0(array)
  id64
  typeBrokerageAdmin
  brokerage_id1
  email[email protected]
  password380caa25f95eecd4c9009e6d5ff51561617cd297
  recover_hash
  first_nameNick
  last_nameSegal
  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-15 10:00:26
  created2016-04-08 16:33:22
  notified(true)
  full_nameNick Segal
  uri/agent-detail/64/nick-segal
  profile_complete(true)
  1(array)
  id299
  typeAgent
  brokerage_id1
  email[email protected]
  password5752832063d4fe000ce359059ea51ec8c2330095
  recover_hash
  first_nameFelecia
  last_nameWesley
  title
  dre_num
  phone310.500.1383
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:41
  created2017-08-07 15:22:41
  notified(false)
  full_nameFelecia Wesley
  uri/agent-detail/299/felecia-wesley
  profile_complete(true)
  2(array)
  id300
  typeAgent
  brokerage_id1
  email[email protected]
  password00fef6ffbbe0ee7288deec08e424f56096dbc9eb
  recover_hash
  first_nameNick
  last_nameSegal
  title
  dre_num
  phone310.500.1388
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:41
  created2017-08-07 15:22:41
  notified(false)
  full_nameNick Segal
  uri/agent-detail/300/nick-segal
  profile_complete(true)
  3(array)
  id309
  typeAgent
  brokerage_id1
  email[email protected]
  passwordc545e08065fcf3d1c5bd1f12be3be31b36d44e2c
  recover_hash
  first_nameLorin
  last_nameRuttenberg
  title
  dre_num
  phone310.500.3905
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:45
  created2017-08-07 15:22:45
  notified(false)
  full_nameLorin Ruttenberg
  uri/agent-detail/309/lorin-ruttenberg
  profile_complete(true)
  4(array)
  id338
  typeAgent
  brokerage_id1
  email[email protected]
  passworda894a0c2ee9e00bcf9a6c2251cf3e5161596dad9
  recover_hash
  first_nameLisa
  last_nameGamo
  title
  dre_num
  phone714.390.0333
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:47
  created2017-08-07 15:22:47
  notified(false)
  full_nameLisa Gamo
  uri/agent-detail/338/lisa-gamo
  profile_complete(true)
  5(array)
  id457
  typeAgent
  brokerage_id1
  email[email protected]
  password87700b14633e9484a5583d862fe044ed9dd9b450
  recover_hash
  first_nameMark
  last_nameKitching
  title
  dre_num
  phone310.500.1367
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:58
  created2017-08-07 15:22:58
  notified(false)
  full_nameMark Kitching
  uri/agent-detail/457/mark-kitching
  profile_complete(true)
  6(array)
  id458
  typeAgent
  brokerage_id1
  email[email protected]
  passwordf5e020ec07940c69a54b677526fec4d7bbee9858
  recover_hash
  first_nameMark
  last_nameRutstein
  title
  dre_num
  phone310.500.3923
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:58
  created2017-08-07 15:22:58
  notified(false)
  full_nameMark Rutstein
  uri/agent-detail/458/mark-rutstein
  profile_complete(true)
  7(array)
  id459
  typeAgent
  brokerage_id1
  email[email protected]
  password7ecf637eaf02dd9ed462949925d36fa4978a8456
  recover_hash
  first_nameGreg
  last_nameHolcomb
  title
  dre_num
  phone310.500.3925
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:58
  created2017-08-07 15:22:58
  notified(false)
  full_nameGreg Holcomb
  uri/agent-detail/459/greg-holcomb
  profile_complete(true)
  8(array)
  id460
  typeAgent
  brokerage_id1
  email[email protected]
  passwordecd3e7befb8f9e22a79445c76572d76b27f00eae
  recover_hash
  first_nameLee
  last_nameMintz
  title
  dre_num
  phone310.500.3297
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:58
  created2017-08-07 15:22:58
  notified(false)
  full_nameLee Mintz
  uri/agent-detail/460/lee-mintz
  profile_complete(true)
  9(array)
  id461
  typeAgent
  brokerage_id1
  email[email protected]
  passworda54f18b55f3a08d677bc5739893a0295240975df
  recover_hash
  first_nameMadison
  last_nameHildebrand
  title
  dre_num
  phone310.818.5788
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:58
  created2017-08-07 15:22:58
  notified(false)
  full_nameMadison Hildebrand
  uri/agent-detail/461/madison-hildebrand
  profile_complete(true)
  10(array)
  id462
  typeAgent
  brokerage_id1
  email[email protected]
  password14627a3bcb47c5710d907d7f4f843601b3247ff3
  recover_hash
  first_nameJennifer
  last_nameChrisman
  title
  dre_num
  phone310.818.5788
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:58
  created2017-08-07 15:22:58
  notified(false)
  full_nameJennifer Chrisman
  uri/agent-detail/462/jennifer-chrisman
  profile_complete(true)
  11(array)
  id463
  typeAgent
  brokerage_id1
  email[email protected]
  password5614c6c2218a8573fe54757bdccf31c6ee522127
  recover_hash
  first_nameCarrie
  last_nameBerkman Lewis
  title
  dre_num
  phone310.500.3991
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:58
  created2017-08-07 15:22:58
  notified(false)
  full_nameCarrie Berkman Lewis
  uri/agent-detail/463/carrie-berkman-lewis
  profile_complete(true)
  12(array)
  id471
  typeAgent
  brokerage_id1
  email[email protected]
  passwordd776606bb6319d1a7d897ec6767bcd2bb8bcc27d
  recover_hash
  first_nameRick
  last_nameOjeda
  title
  dre_num
  phone310.500.1343
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:59
  created2017-08-07 15:22:59
  notified(false)
  full_nameRick Ojeda
  uri/agent-detail/471/rick-ojeda
  profile_complete(true)
  13(array)
  id472
  typeAgent
  brokerage_id1
  email[email protected]
  password6a7a05ba19c8872516483a4efb5e4b150f4ad442
  recover_hash
  first_nameDavid
  last_nameFindley
  title
  dre_num
  phone310.500.1333
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:59
  created2017-08-07 15:22:59
  notified(false)
  full_nameDavid Findley
  uri/agent-detail/472/david-findley
  profile_complete(true)
  14(array)
  id605
  typeAgent
  brokerage_id1
  email[email protected]
  password170e21290070dfbe8351a77f7eed659ec1411bec
  recover_hash
  first_nameJenny
  last_nameSavitsky
  title
  dre_num
  phone310.500.1395
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:23:11
  created2017-08-07 15:23:11
  notified(false)
  full_nameJenny Savitsky
  uri/agent-detail/605/jenny-savitsky
  profile_complete(true)
  15(array)
  id606
  typeAgent
  brokerage_id1
  email[email protected]
  password9a926908d0b3ffe4546df0d845d01e4270b0fe89
  recover_hash
  first_nameLee
  last_nameZamos
  title
  dre_num
  phone310.500.1395
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:23:11
  created2017-08-07 15:23:11
  notified(false)
  full_nameLee Zamos
  uri/agent-detail/606/lee-zamos
  profile_complete(true)
  16(array)
  id680
  typeAgent
  brokerage_id1
  email[email protected]
  password42dec04c5d9393568fe0ad508b15c53461a48bb3
  recover_hash
  first_nameDario
  last_nameSvidler
  title
  dre_num
  phone310.500.3301
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:23:15
  created2017-08-07 15:23:15
  notified(false)
  full_nameDario Svidler
  uri/agent-detail/680/dario-svidler
  profile_complete(true)
  17(array)
  id681
  typeAgent
  brokerage_id1
  email[email protected]
  password22992f76f576546bd954e4ffa280f0668c475b28
  recover_hash
  first_nameNancy
  last_nameRoss
  title
  dre_num
  phone310.968.4180
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:23:15
  created2017-08-07 15:23:15
  notified(false)
  full_nameNancy Ross
  uri/agent-detail/681/nancy-ross
  profile_complete(true)
  18(array)
  id682
  typeAgent
  brokerage_id1
  email[email protected]
  password0a36b9c3a6ddc65e65ac59315cae7cc2781f40ce
  recover_hash
  first_nameLaura
  last_nameBarton
  title
  dre_num
  phone310.600.2746
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:23:15
  created2017-08-07 15:23:15
  notified(false)
  full_nameLaura Barton
  uri/agent-detail/682/laura-barton
  profile_complete(true)
  19(array)
  id713
  typeAgent
  brokerage_id1
  email[email protected]
  password17dee90cb08fd26d7af83dff38a602c15197aa2a
  recover_hash
  first_nameRichard
  last_nameStearns
  title
  dre_num
  phone310.500.1301
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:23:17
  created2017-08-07 15:23:17
  notified(false)
  full_nameRichard Stearns
  uri/agent-detail/713/richard-stearns
  profile_complete(true)
  20(array)
  id714
  typeAgent
  brokerage_id1
  email[email protected]
  passwordbe504740d742895b2149fb3cda7e738174ed12ba
  recover_hash
  first_nameRutstein | Holcomb
  last_nameTeam
  title
  dre_num
  phone310.500.3921
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:23:17
  created2017-08-07 15:23:17
  notified(false)
  full_nameRutstein | Holcomb Team
  uri/agent-detail/714/rutstein-holcomb-team
  profile_complete(true)
  21(array)
  id717
  typeAgent
  brokerage_id1
  email[email protected]
  passwordd4308f9ca1b0188685e49a21d4b3476e7a6c24fe
  recover_hash
  first_nameKevin
  last_nameDees
  title
  dre_num
  phone310.500.3015
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:23:17
  created2017-08-07 15:23:17
  notified(false)
  full_nameKevin Dees
  uri/agent-detail/717/kevin-dees
  profile_complete(true)
  22(array)
  id795
  typeAgent
  brokerage_id1
  email[email protected]
  passwordb2094d69ee9ddf7933ad937c2f8b0ddac8dcca8f
  recover_hash
  first_nameLisa
  last_nameGamo
  title
  dre_num
  phone 310.382.8545
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:23:23
  created2017-08-07 15:23:23
  notified(false)
  full_nameLisa Gamo
  uri/agent-detail/795/lisa-gamo
  profile_complete(true)
  23(array)
  id851
  typeAgent
  brokerage_id1
  email[email protected]
  passwordeaa8b13b32d5611a88fd3583b5bed774ac859c81
  recover_hash
  first_nameDana
  last_nameCataldi
  title
  dre_num
  phone310.500.1355
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:23:41
  created2017-08-07 15:23:41
  notified(false)
  full_nameDana Cataldi
  uri/agent-detail/851/dana-cataldi
  profile_complete(true)
  24(array)
  id856
  typeAgent
  brokerage_id1
  email[email protected]
  password7a00933a2333ab1a5ee767c4a2781a0869a79147
  recover_hash
  first_nameHugh
  last_nameEvans III
  title
  dre_num
  phone310.500.1331
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:23:41
  created2017-08-07 15:23:41
  notified(false)
  full_nameHugh Evans III
  uri/agent-detail/856/hugh-evans-iii
  profile_complete(true)
  25(array)
  id883
  typeAgent
  brokerage_id1
  email[email protected]
  passwordfcdc1daba00182c29679f13a2802491b4bcd9bc4
  recover_hash
  first_nameDavid
  last_nameBerg
  title
  dre_num
  phone310.500.3931
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2020-07-27 12:50:45
  created2017-08-07 15:23:42
  notified(false)
  full_nameDavid Berg
  uri/agent-detail/883/david-berg
  profile_complete(true)
  26(array)
  id884
  typeAgent
  brokerage_id1
  email[email protected]
  password8092091892b0e96c04879de4bff4fa69762bf808
  recover_hash
  first_nameF. Ron
  last_nameSmith
  title
  dre_num
  phone310.500.1373
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:23:43
  created2017-08-07 15:23:43
  notified(false)
  full_nameF. Ron Smith
  uri/agent-detail/884/f-ron-smith
  profile_complete(true)
  27(array)
  id936
  typeAgent
  brokerage_id1
  email[email protected]
  passworde462262e649f16a5cdc3b470de3f2ce62069b450
  recover_hash
  first_nameDarlene
  last_nameHutton
  title
  dre_num
  phone310.500.1385
  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_nameDarlene Hutton
  uri/agent-detail/936/darlene-hutton
  profile_complete(true)
  28(array)
  id937
  typeAgent
  brokerage_id1
  email[email protected]
  password3e415c2f98f361b0e76e9d3886d1736a1042f4cf
  recover_hash
  first_nameKevin
  last_nameBotsford
  title
  dre_num
  phone310.500.3937
  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_nameKevin Botsford
  uri/agent-detail/937/kevin-botsford
  profile_complete(true)
  29(array)
  id944
  typeAgent
  brokerage_id1
  email[email protected]
  password752a25fdf528f64212e88e87517af42f17d23217
  recover_hash
  first_nameKaren
  last_nameMisraje
  title
  dre_num
  phone310.500.3931
  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_nameKaren Misraje
  uri/agent-detail/944/karen-misraje
  profile_complete(true)
  30(array)
  id968
  typeAgent
  brokerage_id1
  email[email protected]
  password3e7ffdfae482808b9375189aaaa1a2a9d8aae095
  recover_hash
  first_nameJoseph
  last_nameTreves
  title
  dre_num
  phone310.500.3017
  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_nameJoseph Treves
  uri/agent-detail/968/joseph-treves
  profile_complete(true)
  31(array)
  id1012
  typeAgent
  brokerage_id1
  email[email protected]
  password5ca2cf2adc659698f1980256782b672a21f17533
  recover_hash
  first_nameMagnus
  last_nameHellberg
  title
  dre_num
  phone310.500.1357
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:23:48
  created2017-08-07 15:23:48
  notified(false)
  full_nameMagnus Hellberg
  uri/agent-detail/1012/magnus-hellberg
  profile_complete(true)
  32(array)
  id1109
  typeAgent
  brokerage_id1
  email[email protected]
  password2db95aa8e432230a14ab3ed86c1e6f5eecfea00b
  recover_hash
  first_nameKatrina
  last_nameWebb
  title
  dre_num
  phone323.387.8011
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:23:54
  created2017-08-07 15:23:54
  notified(false)
  full_nameKatrina Webb
  uri/agent-detail/1109/katrina-webb
  profile_complete(true)
  33(array)
  id1164
  typeAgent
  brokerage_id1
  email[email protected]
  passworda8e131867f2610ea45c57bd8843a82213b9facef
  recover_hash
  first_nameWheeler
  last_nameCoberly
  title
  dre_num
  phone310.351.6234
  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_nameWheeler Coberly
  uri/agent-detail/1164/wheeler-coberly
  profile_complete(true)
  34(array)
  id1277
  typeAgent
  brokerage_id1
  email[email protected]
  password8e8b5fcac6e3ab69670f2940cd8f2f3461040a84
  recover_hash
  first_nameJimmy
  last_nameMartinez
  title
  dre_num
  phone323.377.0548
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:24:02
  created2017-08-07 15:24:02
  notified(false)
  full_nameJimmy Martinez
  uri/agent-detail/1277/jimmy-martinez
  profile_complete(true)
  uri/brokerage-detail/1/partners-trust-real-estate-brokerage-and-acquisitions
  website_shortthepartnerstrust.com
  name_with_locationPartners Trust Real Estate Brokerage and Acquisitions - Beverly Hills, CA, USA
  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)
  id20138
  modelProperty
  model_id3623
  tagImage
  name35217.jpg
  typeimage/jpg
  size354680
  uri/assets/20138.jpg
  order2806
  created2016-04-07 17:25:39
  modified2016-04-07 17:25:39
  1(array)
  id20139
  modelProperty
  model_id3623
  tagImage
  name35218.jpg
  typeimage/jpg
  size163554
  uri/assets/20139.jpg
  order2807
  created2016-04-07 17:25:39
  modified2016-04-07 17:25:39
  2(array)
  id20140
  modelProperty
  model_id3623
  tagImage
  name35219.jpg
  typeimage/jpg
  size147830
  uri/assets/20140.jpg
  order2808
  created2016-04-07 17:25:39
  modified2016-04-07 17:25:39
  3(array)
  id20141
  modelProperty
  model_id3623
  tagImage
  name35220.jpg
  typeimage/jpg
  size172623
  uri/assets/20141.jpg
  order2809
  created2016-04-07 17:25:39
  modified2016-04-07 17:25:40
  4(array)
  id20142
  modelProperty
  model_id3623
  tagImage
  name35221.jpg
  typeimage/jpg
  size110818
  uri/assets/20142.jpg
  order2810
  created2016-04-07 17:25:40
  modified2016-04-07 17:25:40
  5(array)
  id20143
  modelProperty
  model_id3623
  tagImage
  name35222.jpg
  typeimage/jpg
  size176390
  uri/assets/20143.jpg
  order2811
  created2016-04-07 17:25:40
  modified2016-04-07 17:25:40
  6(array)
  id20144
  modelProperty
  model_id3623
  tagImage
  name35223.jpg
  typeimage/jpg
  size191009
  uri/assets/20144.jpg
  order2812
  created2016-04-07 17:25:40
  modified2016-04-07 17:25:40
  7(array)
  id20145
  modelProperty
  model_id3623
  tagImage
  name35224.jpg
  typeimage/jpg
  size90253
  uri/assets/20145.jpg
  order2813
  created2016-04-07 17:25:40
  modified2016-04-07 17:25:40
  8(array)
  id20146
  modelProperty
  model_id3623
  tagImage
  name35225.jpg
  typeimage/jpg
  size345507
  uri/assets/20146.jpg
  order2814
  created2016-04-07 17:25:40
  modified2016-04-07 17:25:40
  9(array)
  id20147
  modelProperty
  model_id3623
  tagImage
  name35226.jpg
  typeimage/jpg
  size332587
  uri/assets/20147.jpg
  order2815
  created2016-04-07 17:25:40
  modified2016-04-07 17:25:40
  User(array)
  0(array)
  id463
  typeAgent
  brokerage_id1
  email[email protected]
  password5614c6c2218a8573fe54757bdccf31c6ee522127
  recover_hash
  first_nameCarrie
  last_nameBerkman Lewis
  title
  dre_num
  phone310.500.3991
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:58
  created2017-08-07 15:22:58
  notified(false)
  full_nameCarrie Berkman Lewis
  uri/agent-detail/463/carrie-berkman-lewis
  profile_complete(true)
  UsersProperty(array)
  id294
  user_id463
  property_id3623
  sort_order0
  Brokerage(array)
  id1
  account_executive_id236
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties12
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties1
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(true)
  country_id1
  WOEID2363796
  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
  usernamePartnersTrustBH
  password2a77eb13ee7deac93b310ba1431a4982bfdbddeb
  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
  description<h2> </h2> <p>Partners Trust is the exclusive representative for Leverage Global Partners in Beverly Hills, California, USA.</p> <p>We are dedicated to being the finest real estate brokerage in Los Angeles.</p> <p>At Partners Trust, our objective is to present our clients with the most professional, successful and ethical real estate associates in the business and to represent our clients with care, confidentiality and the utmost attention to service. We believe we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market.</p> <p>We begin with a commodity that is hard-earned and easily lost: TRUST.</p> <p>Without the daily demonstration and commitment to uphold principles, a company’s mission statement is simply words on a page and nothing more. Partners Trust has adopted a mission statement that each Associate and staff member must sign to in order to participate with the Company, which articulates the core philosophy and culture of the Company.</p> <p>The Partners Trust founders utilized their extensive experience and resources to create a Company that is both unique and beneficial for those willing to commit to the rigorous standards that have been set forth. The Company’s intention is to empower each member of its sales force each and every step of the way.</p> <p>Partners Trust has additional office locations in <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/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" target="_blank">Malibu</a> and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a></p>
  communitiesBeverly Hills Bel Air Century City Westwood West Hollywood
  websitehttp://thepartnerstrust.com
  address9378 Wilshire Boulevard
  address_2Suite 200
  cityBeverly Hills
  stateCA
  full_stateCalifornia
  countryUSA
  marketBeverly Hills
  market_2
  postal_code90212
  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_filename1.jpg
  logo_filename1.png
  contact_image_filename1.jpg
  all_properties_link_image_filename1.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_titleBeverly Hills Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
  meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions is an award-winning real estate brokerage representing Leverage Global Partners in Beverly Hills, CA, USA.
  meta_keywordspartners trust, partners trust real estate, beverly hills real estate, beverly hills real estate agents, 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)
  created2013-02-21 13:57:13
  modified2016-04-08 16:33:22
  dre_num012345
  uri/brokerage-detail/1/partners-trust-real-estate-brokerage-and-acquisitions
  website_shortthepartnerstrust.com
  name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
  Image(empty)
  BrokerageLogoOverride(empty)
  SecondaryPropertyCategory(empty)
  PropertyFeature(array)
  0(array)
  id5
  nameGuest House
  additional(false)
  created2016-04-07 14:02:13
  modified2016-04-07 14:02:13
  PropertiesPropertyFeature(array)
  id4265
  property_id3623
  property_feature_id5
  Icon(array)
  id3554
  modelPropertyFeature
  model_id5
  tagIcon
  name133.png
  typeimage/png
  size1953
  uri/assets/3554.png
  order0
  created2016-04-07 14:02:11
  modified2016-04-07 14:02:13
  Topic(array)
  0(array)
  id14
  nameSpanish Architecture
  created2016-02-25 11:25:00
  modified2016-02-25 11:34:03
  tile_nameSpanish Architecture
  PropertiesTopic(array)
  id13
  property_id3623
  topic_id14
  Image(array)
  id17
  modelTopic
  model_id14
  tagImage
  nameSpanish Architecture.jpg
  typeimage/jpeg
  size2329600
  uri/assets/17.jpg
  order0
  created2016-02-25 11:34:00
  modified2016-02-25 11:34:03
- 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)
  Property(empty)
  User(empty)
  PropertyFeature(empty)
  SecondaryPropertyCategory(empty)
  Topic(empty)
  PrimaryPropertyCategory(empty)
  Brokerage(empty)
  StripeSubscription(empty)
  GlobalReachReport(empty)
  AccountExecutive(empty)
  Logo(empty)
  MainImage(empty)
  ContactImage(empty)
  ContactImage2(empty)
  ContactImage3(empty)
  BrokerOfRecordLogo(empty)
  MainArticle(empty)
  Location(empty)
  FeaturedImage(empty)
  Image(empty)
  UsersProperty(empty)
  BrokerageLogoOverride(empty)
  PropertiesSecondaryPropertyCategory(empty)
  PropertiesPropertyFeature(empty)
  Icon(empty)
  PropertiesTopic(empty)
- Loaded Helpers(array)
  0Permission
  1Number
  2SimpleGraph
  3DebugTimer
  4Toolbar
  5Session
  6Text
  7Flash
  8HtmlToolbar
  9Html
  10Form
====

Environment

App Constants

Constant	Value
CONFIG	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Config/
GOOGLE_MAPS_PUBLIC_API_KEY	AIzaSyCD2zmgSzOEN-7tNHYSmGXL0MyWtMlHND4
GOOGLE_MAPS_PRIVATE_API_KEY	AIzaSyCIXpqYsaZp4_suK7IWeqUTIEbS_hMkoXs
RECAPTCHA_V2_SITE_KEY	6Lfs_EoUAAAAAKe8XSwR8p7AEMOLWB96veSLjRDv
RECAPTCHA_V2_SECRET_KEY	6Lfs_EoUAAAAAIo2vzNYILL-YwBaRxvTpjuemmKZ
PROTOCOL	https://
WEB_ENV	staging2
WEB_BASE_URL	https://staging2.leveragere.com
PROP_EMAIL_RECIPIENT	[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	/property-detail/3623/612-n-sierra-bonita-avenue-los-angeles-ca-90036-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/property-detail/3623/612-n-sierra-bonita-avenue-los-angeles-ca-90036-usa
Remote Port	21142
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	104.23.197.115
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	a09e917e0f73eddd-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	aipWDzpysHdOfAmunoyPJgAAAE8
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	aipWDzpysHdOfAmunoyPJgAAAE8
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781159439.1614
Request Time	1781159439

====

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

SPANISH STYLE HOME LUSH WITH CHARM

Represented By: Partners Trust Real Estate Brokerage and Acquisitions

thepartnerstrust.com | License #: 012345

Highlighted Properties

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 12 ms Total Queries: 35 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 12 ms
Total Queries: 35 queries