Properties /

SPRAWLING, SECLUDED MEDITERRANEAN

5020 Angeles Crest Highway | La Canada Flintridge, CA 91011, USA | $2,950,000 | MLS ID: 316002275

5 Beds
4 Baths
1 Half Ba
Garage
Swimming Pool

Secluded, gated estate! Set back off of the street & buffered by a large circular courtyard/driveway & oak trees this 2004 built home has been transformed by the current owner into an exquisitely designed entertainer's dream. This sprawling two story Mediterranean style home sits on a large, flat 23,075 square foot lot and features an open floor plan, high ceilings, hardwood floors, custom lighting and fixtures, abundant storage & a three-car garage. There are 5 beds, 5 baths, formal living & dining rooms, formal 2 story entry, large great room & an upstairs family room loft. The gourmet kitchen has a large center island, stainless steel appliances, a breakfast counter, a nook & pantry room. The large master suite features a foyer, work-out room, large custom closet, steam shower & tub. The great room French doors lead to the resort like backyard featuring a sparkling PebbleTec pool & spa with 5 water features, grass, covered patios & more. La Canada Schools. Sewers IN, CONNECTED & PAID!

Represented By: Partners Trust Real Estate Brokerage and Acquisitions

www.thepartnerstrust.com | License #: 012345

Deanne Anderson
818.266.8561
Email

Main Office: 594 E. Colorado Boulevard
Pasadena, CA 91101
USA

More About Deanne

View On Map Property Website Video Tour

Highlighted Properties

Spectacular Estate with Stunning Views

1428 Glen Oaks Blvd. | Pasadena, CA 91105
$2,750,000

Custom-Built Contemporary Mediterranean

2040 Glen Springs Road | Pasadena, CA 91107
$2,080,000

Represented By

Agent Contacts: Deanne Anderson 818.266.8561 | Email

Featured Location

Related Property Listings

Lovely & Detailed Remodel in South Pasadena

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

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

Cake Params
- plugin(null)
- controllerproperties
- actionview
- named(empty)
- pass(array)
  03596
  15020-angeles-crest-highway-la-canada-flintridge-ca-91011-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: 7 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` = 3596 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` = 5 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` = 5 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` = 5 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` = 5 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` = 5 AND `ContactImage3`.`model` = 'Brokerage' AND `ContactImage3`.`tag` = 'ContactImage3'	0	0	0
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` = 5 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` = 5 AND `MainArticle`.`model` = 'Brokerage'	1	1	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` = (5) 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` = (5)	0	0	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` = (5)	27	27	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` = (3596) 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` = 3596 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` = 5	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` = 1035 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` = 1035 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` = 3596 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` = 3596 AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	2	2	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` = 4 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	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` = 12 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` = 3596 AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	0
SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created`, `PrimaryPropertyCategory`.`id`, `PrimaryPropertyCategory`.`name`, `PrimaryPropertyCategory`.`created`, `PrimaryPropertyCategory`.`modified`, `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `StripeSubscription`.`id`, `StripeSubscription`.`brokerage_id`, `StripeSubscription`.`user_id`, `StripeSubscription`.`property_id`, `StripeSubscription`.`type`, `StripeSubscription`.`stripe_id`, `StripeSubscription`.`stripe_customer_id`, `StripeSubscription`.`stripe_checkout_email`, `StripeSubscription`.`stripe_promotion_code`, `StripeSubscription`.`stripe_promotion_code_id`, `StripeSubscription`.`stripe_coupon_code_id`, `StripeSubscription`.`status`, `StripeSubscription`.`current_period_end`, `StripeSubscription`.`cancel_at_period_end`, `StripeSubscription`.`ended`, `StripeSubscription`.`last_change`, `StripeSubscription`.`last_activity_email_sent`, `StripeSubscription`.`created`, `StripeSubscription`.`modified`, `GlobalReachReport`.`id`, `GlobalReachReport`.`property_id`, `GlobalReachReport`.`wsj_desktop`, `GlobalReachReport`.`wsj_mobile`, `GlobalReachReport`.`wsj_expires`, `GlobalReachReport`.`wsj_capture_started`, `GlobalReachReport`.`mg_desktop`, `GlobalReachReport`.`mg_mobile`, `GlobalReachReport`.`mg_expires`, `GlobalReachReport`.`mg_capture_started`, `GlobalReachReport`.`bp_desktop`, `GlobalReachReport`.`bp_mobile`, `GlobalReachReport`.`bp_expires`, `GlobalReachReport`.`gp_capture_started`, `GlobalReachReport`.`mw_desktop`, `GlobalReachReport`.`mw_mobile`, `GlobalReachReport`.`mw_expires`, `GlobalReachReport`.`mw_capture_started`, `GlobalReachReport`.`ft_desktop`, `GlobalReachReport`.`ft_mobile`, `GlobalReachReport`.`ft_expires`, `GlobalReachReport`.`ft_capture_started`, `GlobalReachReport`.`nikkei_desktop`, `GlobalReachReport`.`nikkei_mobile`, `GlobalReachReport`.`nikkei_expires`, `GlobalReachReport`.`nikkei_capture_started`, `GlobalReachReport`.`pgl_desktop`, `GlobalReachReport`.`pgl_mobile`, `GlobalReachReport`.`pgl_expires`, `GlobalReachReport`.`pgl_capture_started`, `GlobalReachReport`.`robb_desktop`, `GlobalReachReport`.`robb_mobile`, `GlobalReachReport`.`robb_expires`, `GlobalReachReport`.`robb_capture_started`, `GlobalReachReport`.`juwai_desktop`, `GlobalReachReport`.`juwai_mobile`, `GlobalReachReport`.`juwai_expires`, `GlobalReachReport`.`juwai_capture_started`, `GlobalReachReport`.`leverage_desktop`, `GlobalReachReport`.`leverage_mobile`, `GlobalReachReport`.`leverage_expires`, `GlobalReachReport`.`leverage_capture_started`, `GlobalReachReport`.`created`, `GlobalReachReport`.`modified` FROM `leveragere_staging2`.`properties` AS `Property` LEFT JOIN `leveragere_staging2`.`property_categories` AS `PrimaryPropertyCategory` ON (`Property`.`primary_property_category_id` = `PrimaryPropertyCategory`.`id`) LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Property`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`stripe_subscriptions` AS `StripeSubscription` ON (`StripeSubscription`.`property_id` = `Property`.`id` AND `StripeSubscription`.`status` = 'active') LEFT JOIN `leveragere_staging2`.`global_reach_reports` AS `GlobalReachReport` ON (`GlobalReachReport`.`property_id` = `Property`.`id`) WHERE `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`id` != 3596 AND `Property`.`brokerage_id` = 5 AND `Property`.`status` != 'Sold' AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 2	2	2	2
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (3273, 3471) 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 (3273, 3471) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	2	2	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 (3273, 3471) 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 (3273, 3471) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	8	8	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 (3273, 3471) 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` = 5 LIMIT 1	0	0	1	maybe slow
SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created`, `PrimaryPropertyCategory`.`id`, `PrimaryPropertyCategory`.`name`, `PrimaryPropertyCategory`.`created`, `PrimaryPropertyCategory`.`modified`, `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `StripeSubscription`.`id`, `StripeSubscription`.`brokerage_id`, `StripeSubscription`.`user_id`, `StripeSubscription`.`property_id`, `StripeSubscription`.`type`, `StripeSubscription`.`stripe_id`, `StripeSubscription`.`stripe_customer_id`, `StripeSubscription`.`stripe_checkout_email`, `StripeSubscription`.`stripe_promotion_code`, `StripeSubscription`.`stripe_promotion_code_id`, `StripeSubscription`.`stripe_coupon_code_id`, `StripeSubscription`.`status`, `StripeSubscription`.`current_period_end`, `StripeSubscription`.`cancel_at_period_end`, `StripeSubscription`.`ended`, `StripeSubscription`.`last_change`, `StripeSubscription`.`last_activity_email_sent`, `StripeSubscription`.`created`, `StripeSubscription`.`modified`, `GlobalReachReport`.`id`, `GlobalReachReport`.`property_id`, `GlobalReachReport`.`wsj_desktop`, `GlobalReachReport`.`wsj_mobile`, `GlobalReachReport`.`wsj_expires`, `GlobalReachReport`.`wsj_capture_started`, `GlobalReachReport`.`mg_desktop`, `GlobalReachReport`.`mg_mobile`, `GlobalReachReport`.`mg_expires`, `GlobalReachReport`.`mg_capture_started`, `GlobalReachReport`.`bp_desktop`, `GlobalReachReport`.`bp_mobile`, `GlobalReachReport`.`bp_expires`, `GlobalReachReport`.`gp_capture_started`, `GlobalReachReport`.`mw_desktop`, `GlobalReachReport`.`mw_mobile`, `GlobalReachReport`.`mw_expires`, `GlobalReachReport`.`mw_capture_started`, `GlobalReachReport`.`ft_desktop`, `GlobalReachReport`.`ft_mobile`, `GlobalReachReport`.`ft_expires`, `GlobalReachReport`.`ft_capture_started`, `GlobalReachReport`.`nikkei_desktop`, `GlobalReachReport`.`nikkei_mobile`, `GlobalReachReport`.`nikkei_expires`, `GlobalReachReport`.`nikkei_capture_started`, `GlobalReachReport`.`pgl_desktop`, `GlobalReachReport`.`pgl_mobile`, `GlobalReachReport`.`pgl_expires`, `GlobalReachReport`.`pgl_capture_started`, `GlobalReachReport`.`robb_desktop`, `GlobalReachReport`.`robb_mobile`, `GlobalReachReport`.`robb_expires`, `GlobalReachReport`.`robb_capture_started`, `GlobalReachReport`.`juwai_desktop`, `GlobalReachReport`.`juwai_mobile`, `GlobalReachReport`.`juwai_expires`, `GlobalReachReport`.`juwai_capture_started`, `GlobalReachReport`.`leverage_desktop`, `GlobalReachReport`.`leverage_mobile`, `GlobalReachReport`.`leverage_expires`, `GlobalReachReport`.`leverage_capture_started`, `GlobalReachReport`.`created`, `GlobalReachReport`.`modified` FROM `leveragere_staging2`.`properties` AS `Property` LEFT JOIN `leveragere_staging2`.`property_categories` AS `PrimaryPropertyCategory` ON (`Property`.`primary_property_category_id` = `PrimaryPropertyCategory`.`id`) LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Property`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`stripe_subscriptions` AS `StripeSubscription` ON (`StripeSubscription`.`property_id` = `Property`.`id` AND `StripeSubscription`.`status` = 'active') LEFT JOIN `leveragere_staging2`.`global_reach_reports` AS `GlobalReachReport` ON (`GlobalReachReport`.`property_id` = `Property`.`id`) WHERE `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`brokerage_id` = 5 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 (3734, 3463, 3555, 3695) ORDER BY `Image`.`order` ASC	40	40	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 (3734, 3463, 3555, 3695) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	2	2	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 (3734, 3463, 3555, 3695) 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 (3734, 3463, 3555, 3695) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	8	8	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 (3734, 3463, 3555, 3695) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 15.12 MB

Message	Memory use
Component initialization	3.07 MB
Controller action start	4.01 MB
Controller render start	6.96 MB
View render complete	7.48 MB

Timers

Total Request Time: 391 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	194.00
Event: Controller.initialize	4.38
Event: Controller.startup	1.63
Controller action	40.88
Event: Controller.beforeRender	18.35
» Processing toolbar data	18.24
Rendering View	92.86
» Event: View.beforeRender	0.42
» Rendering APP/View/Properties/view.ctp	3.30
» » Rendering APP/View/Elements/static_property_price.ctp	0.43
» » 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.16
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.15
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.00
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #5	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #6	0.14
» » » 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	88.37
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)
 id3734
 brokerage_id5
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameLovely & Detailed Remodel in South Pasadena
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(false)
 descriptionLovely and creatively remodeled home w/ a 2nd story in 2002 while preserving the 1925 integrity of the estate. Grand foyer w/ custom stairwell & impressive chandelier offers a stately entrance to this impeccable home loaded w/ an abundance of charm & character. There are impressive intricate details throughout. Adjacent to the foyer is a formal living room offering natural light by day & a cozy romantic fireplace by night. Gourmet kitchen is a chef's dream w/ center island, double ovens, stove top & opens to the family room. Luxurious master suite is located on the 2nd level w/ inspiring views of the rear gardens. Master bath offers dual sinks, soaking tub & oversized shower w/ bench. Backyard is ideal for entertaining under the grandiose pergola or simply relaxing & enjoying the vistas of the grassy area & mature trees. This a special South Pasadena home that has been lovingly maintained for the past 21 years by the current owners. Thank you for sharing in the joy of viewing this home.
 address1817 Spruce Street
 address_2
 citySouth Pasadena
 stateCA
 postal_code91030
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1780000
 price_20
 price_usd1780000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet2846
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://1817sprucestreetstreet.thepartnerstrust.com/
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial2
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1925
 virtual_tour
 video_tourhttp://www.onvedeo.com/properties/759797/embed
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num316002835
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style42
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude34.105072
 longitude-118.145790
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 00:33:02
 created2016-04-15 16:49:02
 uri/property-detail/3734/1817-spruce-street-south-pasadena-ca-91030-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3734/1817-spruce-street-south-pasadena-ca-91030-usa
 address_concat1817 Spruce Street South Pasadena CA 91030 USA
 google_maps_query_string1817+Spruce+Street++South+Pasadena+CA+91030+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,780,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty2
 bathrooms_partial_pretty2
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2016-04-15
 overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id5
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties12
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties2
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id1
 WOEID2468964
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePartners Trust Real Estate Brokerage and Acquisitions
 broker_of_record_name
 short_namePartners Trust Real Estate
 usernamePartnersTrustPas
 password5b28522e46f56278664573d82c2b0f03520519d0
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPartners Trust is the exclusive representative for Leverage Global Partners in Pasadena and La Cañada Flintridge, California, USA. At Partners Trust, we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market, presenting our clients with the most professional, successful and ethical real estate associates in the business. We represent our clients with care, confidentiality and the utmost attention to service. Pasadena is a harmonious blend of past and present. Experience the nationally-televised Rose Parade, catch an exciting football game at the Rose Bowl, get smart at Caltech, or revel in the Jet Propulsion Laboratory. The community is renowned for its charming and diverse neighborhoods whose residents honor and preserve the splendor of early California architecture. Opportunities abound to experience Pasadena’s sophisticated culture with the diversified entertainment at the Pasadena Playhouse, the Norton Simon Museum, the Huntington Library and Botanical Gardens and even by walking along the vibrant, historic district of Colorado Boulevard. Partners Trust associates are proud to represent a wide variety of historic and architecturally diverse homes, including the Craftsman-style home. We understand our clients discerning needs, and provide a high level of service and local area knowledge. Partners Trust has additional office locations in <a href="../../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/142/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Malibu</a>, and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a>
 communitiesPasadena La Canada Flintridge San Marino La Canada Flintridge
 websitehttp://www.thepartnerstrust.com
 address594 E. Colorado Boulevard
 address_2
 cityPasadena
 stateCA
 full_stateCalifornia
 countryUSA
 marketPasadena
 market_2
 postal_code91101
 phone(626) 696-4802
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameScott Brown
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-scott-brown-managing-director-partners-trust-pasadena/
 contact_big_profile_link_text
 contact_titleManaging Director
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2Nick Segal
 contact_profile_link_2http://www.leveragere.com/brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2President/Co-Founder
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename5.jpg
 logo_filename5.png
 contact_image_filename5.jpg
 all_properties_link_image_filename5.jpg
 all_properties_linkhttp://www.thepartnerstrust.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titlePasadena Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
 meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Pasadena, CA is a premier boutique Pasadena real estate brokerage and the exclusive Pasadena representative for Leverage Global Partners.
 meta_keywordspartners trust, partners trust real estate, pasadena real estate, leverage global partners, pasadena homes for sale, scott brown
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-03-18 16:08:06
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/5/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortwww.thepartnerstrust.com
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id20890
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_001_HIGHRES.jpg
 typeimage/jpeg
 size10361514
 uri/assets/20890.jpg
 order0
 created2016-04-15 16:47:48
 modified2016-04-15 16:49:02
 1(array)
 id20879
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_008_HIGHRES.jpg
 typeimage/jpeg
 size6804950
 uri/assets/20879.jpg
 order1
 created2016-04-15 16:47:42
 modified2016-04-15 16:49:02
 2(array)
 id20877
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_017_HIGHRES.jpg
 typeimage/jpeg
 size5626562
 uri/assets/20877.jpg
 order2
 created2016-04-15 16:47:39
 modified2016-04-15 16:49:02
 3(array)
 id20876
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_022_HIGHRES.jpg
 typeimage/jpeg
 size5719147
 uri/assets/20876.jpg
 order3
 created2016-04-15 16:47:38
 modified2016-04-15 16:49:02
 4(array)
 id20878
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_014_HIGHRES.jpg
 typeimage/jpeg
 size5358186
 uri/assets/20878.jpg
 order4
 created2016-04-15 16:47:40
 modified2016-04-15 16:49:02
 5(array)
 id20882
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_009_HIGHRES.jpg
 typeimage/jpeg
 size6157612
 uri/assets/20882.jpg
 order5
 created2016-04-15 16:47:46
 modified2016-04-15 16:49:02
 6(array)
 id20881
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_038_HIGHRES.jpg
 typeimage/jpeg
 size9795680
 uri/assets/20881.jpg
 order6
 created2016-04-15 16:47:44
 modified2016-04-15 16:49:02
 7(array)
 id20894
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_044_HIGHRES.jpg
 typeimage/jpeg
 size11888212
 uri/assets/20894.jpg
 order7
 created2016-04-15 16:47:50
 modified2016-04-15 16:49:02
 8(array)
 id20883
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_035_HIGHRES.jpg
 typeimage/jpeg
 size10217742
 uri/assets/20883.jpg
 order8
 created2016-04-15 16:47:47
 modified2016-04-15 16:49:02
 9(array)
 id20880
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_040_HIGHRES.jpg
 typeimage/jpeg
 size10614464
 uri/assets/20880.jpg
 order9
 created2016-04-15 16:47:43
 modified2016-04-15 16:49:02
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id9
 nameOffice
 additional(false)
 created2016-04-07 14:03:21
 modified2016-04-07 14:03:21
 PropertiesPropertyFeature(array)
 id4405
 property_id3734
 property_feature_id9
 1(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id4404
 property_id3734
 property_feature_id4
 Topic(empty)
 1(array)
 Property(array)
 id3463
 brokerage_id5
 created_by_user_id0
 order2
 multi_unit(false)
 agent_1_id507
 agent_2_id0
 agent_3_id0
 nameCustom Home in the Hills of La Cañada
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionThe home sits peacefully on a multi-level 40,000+ square foot lot and is extremely private with beautiful views of the mountains. Entertaining is fabulous with its grand Living and Dining Room with walls of glass, enormous over-sized brick fireplace, exposed 18 foot ceilings, antique glass lanterns and large covered porch. In total the home has over 50 SF of original art from Judson Studios-one of the world's leading glass art studios, imbedded in its very architecture. The kitchen is incredible with unique granite and copper sinks, professional appliances, hand-crafted cabinetry and breakfast area. Off of the kitchen is an outdoor cooking and entertaining pavilion with an Argentine Asador Grill. The sprawling yard is complimented with a large rose garden, pool, spa, grass area and numerous trees. This home is absolutely unique and spectacular with incredible details throughout! Come on home to your own retreat!
 address845 Highland Drive
 address_2
 cityLa Cañada Flintridge
 stateCA
 postal_code91011
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price4699999
 price_20
 price_usd4699999
 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)
 bedrooms6
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1balcony-terrace
 icon_2office
 icon_3pool
 icon_4
 icon_5
 icon_6
 websitehttp://www.thepartnerstrust.com/property/47083167/845-Highland-Drive-La-Canada-Flintridge-CA-91011
 meta_titleCustom home in the hills of La Canada | La Canada Flintridge Real Estate | Partners Trust Real Estate Brokerage and Acquisitions
 meta_description845 Highland Drive is a property offered for sale in La Canada Flintridge, 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_built1962
 virtual_tourhttp://845highlanddrive.thepartnerstrust.com
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num316000525
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type7
 juwai_property_type
 juwai_category
 propgolux_property_style21
 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.185577
 longitude-118.194221
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, 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 10:48:00
 created2016-02-20 16:26:18
 uri/property-detail/3463/845-highland-drive-la-ca-ada-flintridge-ca-91011-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3463/845-highland-drive-la-ca-ada-flintridge-ca-91011-usa
 address_concat845 Highland Drive La Cañada Flintridge CA 91011 USA
 google_maps_query_string845+Highland+Drive++La+Ca%C3%B1ada+Flintridge+CA+91011+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 4,699,999
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty6
 bathrooms_pretty4
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2016-02-20
 overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id5
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties12
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties2
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id1
 WOEID2468964
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePartners Trust Real Estate Brokerage and Acquisitions
 broker_of_record_name
 short_namePartners Trust Real Estate
 usernamePartnersTrustPas
 password5b28522e46f56278664573d82c2b0f03520519d0
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPartners Trust is the exclusive representative for Leverage Global Partners in Pasadena and La Cañada Flintridge, California, USA. At Partners Trust, we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market, presenting our clients with the most professional, successful and ethical real estate associates in the business. We represent our clients with care, confidentiality and the utmost attention to service. Pasadena is a harmonious blend of past and present. Experience the nationally-televised Rose Parade, catch an exciting football game at the Rose Bowl, get smart at Caltech, or revel in the Jet Propulsion Laboratory. The community is renowned for its charming and diverse neighborhoods whose residents honor and preserve the splendor of early California architecture. Opportunities abound to experience Pasadena’s sophisticated culture with the diversified entertainment at the Pasadena Playhouse, the Norton Simon Museum, the Huntington Library and Botanical Gardens and even by walking along the vibrant, historic district of Colorado Boulevard. Partners Trust associates are proud to represent a wide variety of historic and architecturally diverse homes, including the Craftsman-style home. We understand our clients discerning needs, and provide a high level of service and local area knowledge. Partners Trust has additional office locations in <a href="../../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/142/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Malibu</a>, and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a>
 communitiesPasadena La Canada Flintridge San Marino La Canada Flintridge
 websitehttp://www.thepartnerstrust.com
 address594 E. Colorado Boulevard
 address_2
 cityPasadena
 stateCA
 full_stateCalifornia
 countryUSA
 marketPasadena
 market_2
 postal_code91101
 phone(626) 696-4802
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameScott Brown
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-scott-brown-managing-director-partners-trust-pasadena/
 contact_big_profile_link_text
 contact_titleManaging Director
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2Nick Segal
 contact_profile_link_2http://www.leveragere.com/brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2President/Co-Founder
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename5.jpg
 logo_filename5.png
 contact_image_filename5.jpg
 all_properties_link_image_filename5.jpg
 all_properties_linkhttp://www.thepartnerstrust.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titlePasadena Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
 meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Pasadena, CA is a premier boutique Pasadena real estate brokerage and the exclusive Pasadena representative for Leverage Global Partners.
 meta_keywordspartners trust, partners trust real estate, pasadena real estate, leverage global partners, pasadena homes for sale, scott brown
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-03-18 16:08:06
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/5/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortwww.thepartnerstrust.com
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id20863
 modelProperty
 model_id3463
 tagImage
 nameegpimaging_845Highland_080_HIGHRES.jpg
 typeimage/jpeg
 size8712934
 uri/assets/20863.jpg
 order0
 created2016-04-15 16:05:56
 modified2016-04-15 16:06:24
 1(array)
 id13685
 modelProperty
 model_id3463
 tagImage
 name33602.jpg
 typeimage/jpg
 size465469
 uri/assets/13685.jpg
 order1
 created2016-04-07 16:41:02
 modified2016-04-15 16:06:24
 2(array)
 id13686
 modelProperty
 model_id3463
 tagImage
 name33601.jpg
 typeimage/jpg
 size474246
 uri/assets/13686.jpg
 order2
 created2016-04-07 16:41:02
 modified2016-04-15 16:06:24
 3(array)
 id13678
 modelProperty
 model_id3463
 tagImage
 name33609.jpg
 typeimage/jpg
 size468069
 uri/assets/13678.jpg
 order3
 created2016-04-07 16:41:02
 modified2016-04-15 16:06:24
 4(array)
 id13684
 modelProperty
 model_id3463
 tagImage
 name33603.jpg
 typeimage/jpg
 size477546
 uri/assets/13684.jpg
 order4
 created2016-04-07 16:41:02
 modified2016-04-15 16:06:24
 5(array)
 id13683
 modelProperty
 model_id3463
 tagImage
 name33604.jpg
 typeimage/jpg
 size444146
 uri/assets/13683.jpg
 order5
 created2016-04-07 16:41:02
 modified2016-04-15 16:06:24
 6(array)
 id13682
 modelProperty
 model_id3463
 tagImage
 name33605.jpg
 typeimage/jpg
 size324353
 uri/assets/13682.jpg
 order6
 created2016-04-07 16:41:02
 modified2016-04-15 16:06:24
 7(array)
 id13681
 modelProperty
 model_id3463
 tagImage
 name33606.jpg
 typeimage/jpg
 size494361
 uri/assets/13681.jpg
 order7
 created2016-04-07 16:41:02
 modified2016-04-15 16:06:24
 8(array)
 id13679
 modelProperty
 model_id3463
 tagImage
 name33608.jpg
 typeimage/jpg
 size1008623
 uri/assets/13679.jpg
 order8
 created2016-04-07 16:41:02
 modified2016-04-15 16:06:24
 9(array)
 id13680
 modelProperty
 model_id3463
 tagImage
 name33607.jpg
 typeimage/jpg
 size811070
 uri/assets/13680.jpg
 order9
 created2016-04-07 16:41:02
 modified2016-04-15 16:06:24
 User(array)
 0(array)
 id709
 typeAgent
 brokerage_id5
 email[email protected]
 password1d0030842b16e5056035a18eddb12ecc6ff0950d
 recover_hash
 first_nameChristine
 last_nameNavarro
 title
 dre_num
 phone818.488.5812
 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_nameChristine Navarro
 uri/agent-detail/709/christine-navarro
 profile_complete(true)
 UsersProperty(array)
 id486
 user_id709
 property_id3463
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id2675
 property_id3463
 property_feature_id12
 1(array)
 id9
 nameOffice
 additional(false)
 created2016-04-07 14:03:21
 modified2016-04-07 14:03:21
 PropertiesPropertyFeature(array)
 id2674
 property_id3463
 property_feature_id9
 2(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id2673
 property_id3463
 property_feature_id1
 Topic(empty)
 2(array)
 Property(array)
 id3555
 brokerage_id5
 created_by_user_id0
 order9
 multi_unit(false)
 agent_1_id28
 agent_2_id0
 agent_3_id0
 nameRENOVATED & EXPANDED HOME NEAR ROSE BOWL
 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)
 descriptionOne of a finite number of properties fortunate enough to be situated at the edge of the world famous Rose Bowl. Originally built in 1920, the home has been renovated and expanded in recent years to include a fabulous great room/kitchen and master suite. Several of the rooms enjoy the beautiful views through French Doors out to the expansive grassy yard, Rose Bowl and Brookside golf course. There are 3 bedrooms in total and 3 baths. The great room has many beautiful built-ins including a desk area and entertainment console. Also included is a workshop/office attached to the newly upgraded garage and a tidy basement with lots of storage and shelving. Upgrades include copper plumbing throughout, upgraded electrical, new driveway, new front walk way, rain gutters, shades throughout on interior windows and exterior and interior paint.
 address1119 Wotkyns Drive
 address_2
 cityPasadena
 stateCA
 postal_code91103
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1895000
 price_20
 price_usd1895000
 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_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://1119wotkynsdrive.thepartnerstrust.com/
 meta_titleRENOVATED & EXPANDED HOME NEAR ROSE BOWL | Pasadena Real Estate | Partners Trust Real Estate Brokerage and Acquisitions
 meta_description1119 Wotkyns Drive is a property offered for sale in Pasadena , 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_built1920
 virtual_tour
 video_tourhttp://www.onvedeo.com/properties/682851/embed
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num316001850
 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.164013
 longitude-118.165230
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, bathrooms_partial, square_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 00:33:02
 created2016-03-04 17:24:44
 uri/property-detail/3555/1119-wotkyns-drive-pasadena-ca-91103-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3555/1119-wotkyns-drive-pasadena-ca-91103-usa
 address_concat1119 Wotkyns Drive Pasadena CA 91103 USA
 google_maps_query_string1119+Wotkyns+Drive++Pasadena++CA+91103+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,895,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty3
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-03-04
 overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id5
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties12
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties2
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id1
 WOEID2468964
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePartners Trust Real Estate Brokerage and Acquisitions
 broker_of_record_name
 short_namePartners Trust Real Estate
 usernamePartnersTrustPas
 password5b28522e46f56278664573d82c2b0f03520519d0
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPartners Trust is the exclusive representative for Leverage Global Partners in Pasadena and La Cañada Flintridge, California, USA. At Partners Trust, we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market, presenting our clients with the most professional, successful and ethical real estate associates in the business. We represent our clients with care, confidentiality and the utmost attention to service. Pasadena is a harmonious blend of past and present. Experience the nationally-televised Rose Parade, catch an exciting football game at the Rose Bowl, get smart at Caltech, or revel in the Jet Propulsion Laboratory. The community is renowned for its charming and diverse neighborhoods whose residents honor and preserve the splendor of early California architecture. Opportunities abound to experience Pasadena’s sophisticated culture with the diversified entertainment at the Pasadena Playhouse, the Norton Simon Museum, the Huntington Library and Botanical Gardens and even by walking along the vibrant, historic district of Colorado Boulevard. Partners Trust associates are proud to represent a wide variety of historic and architecturally diverse homes, including the Craftsman-style home. We understand our clients discerning needs, and provide a high level of service and local area knowledge. Partners Trust has additional office locations in <a href="../../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/142/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Malibu</a>, and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a>
 communitiesPasadena La Canada Flintridge San Marino La Canada Flintridge
 websitehttp://www.thepartnerstrust.com
 address594 E. Colorado Boulevard
 address_2
 cityPasadena
 stateCA
 full_stateCalifornia
 countryUSA
 marketPasadena
 market_2
 postal_code91101
 phone(626) 696-4802
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameScott Brown
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-scott-brown-managing-director-partners-trust-pasadena/
 contact_big_profile_link_text
 contact_titleManaging Director
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2Nick Segal
 contact_profile_link_2http://www.leveragere.com/brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2President/Co-Founder
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename5.jpg
 logo_filename5.png
 contact_image_filename5.jpg
 all_properties_link_image_filename5.jpg
 all_properties_linkhttp://www.thepartnerstrust.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titlePasadena Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
 meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Pasadena, CA is a premier boutique Pasadena real estate brokerage and the exclusive Pasadena representative for Leverage Global Partners.
 meta_keywordspartners trust, partners trust real estate, pasadena real estate, leverage global partners, pasadena homes for sale, scott brown
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-03-18 16:08:06
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/5/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortwww.thepartnerstrust.com
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id18219
 modelProperty
 model_id3555
 tagImage
 name34568.jpg
 typeimage/jpg
 size662423
 uri/assets/18219.jpg
 order0
 created2016-04-07 17:08:09
 modified2016-04-15 11:22:07
 1(array)
 id18218
 modelProperty
 model_id3555
 tagImage
 name34561.jpg
 typeimage/jpg
 size883951
 uri/assets/18218.jpg
 order1
 created2016-04-07 17:08:09
 modified2016-04-15 11:22:07
 2(array)
 id18217
 modelProperty
 model_id3555
 tagImage
 name34562.jpg
 typeimage/jpg
 size492062
 uri/assets/18217.jpg
 order2
 created2016-04-07 17:08:09
 modified2016-04-15 11:22:07
 3(array)
 id18220
 modelProperty
 model_id3555
 tagImage
 name34563.jpg
 typeimage/jpg
 size298694
 uri/assets/18220.jpg
 order3
 created2016-04-07 17:08:09
 modified2016-04-15 11:22:07
 4(array)
 id18222
 modelProperty
 model_id3555
 tagImage
 name34565.jpg
 typeimage/jpg
 size519991
 uri/assets/18222.jpg
 order4
 created2016-04-07 17:08:09
 modified2016-04-15 11:22:07
 5(array)
 id18223
 modelProperty
 model_id3555
 tagImage
 name34566.jpg
 typeimage/jpg
 size464743
 uri/assets/18223.jpg
 order5
 created2016-04-07 17:08:09
 modified2016-04-15 11:22:07
 6(array)
 id18224
 modelProperty
 model_id3555
 tagImage
 name34567.jpg
 typeimage/jpg
 size408901
 uri/assets/18224.jpg
 order6
 created2016-04-07 17:08:09
 modified2016-04-15 11:22:07
 7(array)
 id18225
 modelProperty
 model_id3555
 tagImage
 name34569.jpg
 typeimage/jpg
 size396412
 uri/assets/18225.jpg
 order7
 created2016-04-07 17:08:09
 modified2016-04-15 11:22:07
 8(array)
 id18221
 modelProperty
 model_id3555
 tagImage
 name34571.jpg
 typeimage/jpg
 size555854
 uri/assets/18221.jpg
 order8
 created2016-04-07 17:08:09
 modified2016-04-15 11:22:07
 9(array)
 id18226
 modelProperty
 model_id3555
 tagImage
 name34570.jpg
 typeimage/jpg
 size263952
 uri/assets/18226.jpg
 order9
 created2016-04-07 17:08:09
 modified2016-04-15 11:22:07
 User(array)
 0(array)
 id268
 typeAgent
 brokerage_id5
 email[email protected]
 passwordd92c183f7d14d918e71c867381742f5a999d816b
 recover_hash
 first_nameAason
 last_nameAlms
 title
 dre_num
 phone626.696.4812
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:39
 created2017-08-07 15:22:39
 notified(false)
 full_nameAason Alms
 uri/agent-detail/268/aason-alms
 profile_complete(true)
 UsersProperty(array)
 id43
 user_id268
 property_id3555
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 3(array)
 Property(array)
 id3695
 brokerage_id5
 created_by_user_id0
 order11
 multi_unit(false)
 agent_1_id1215
 agent_2_id1216
 agent_3_id0
 nameLuxury Home With Commanding Views
 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 Situated at the top of the gated Marshall Canyon Estates, this luxury home built in 1998 offers a commanding view overlooking the San Gabriel Valley. Entertain in style with a formal living room, formal dining room, cook's kitchen and full butler's serving pantry. Enjoy the convenience of a spacious great room with a private family dining area adjacent to the open kitchen. The opulent master suite upstairs offers a media area, fireplace, wet bar, two walk-in closets and a luxurious bath with double shower. 2 additional bedrooms with private baths are also located upstairs. The main level also features a master suite for guests or extended family with a sitting area, private full bath with soaking tub plus a private view balcony. The lower level offers a home office, fifth bedroom and a 2nd family room. Private backyard includes a beautiful pool and spa with waterfall and slide and also has a comfortable grassy area, built in barbecue, fire pit and covered patio. Full Solar System incl.
 address2522 Galicia
 address_2
 cityLa Verne
 stateCA
 postal_code91750
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1650000
 price_20
 price_usd1650000
 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)
 bedrooms5
 bedrooms_20
 bathrooms5
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1pool
 icon_2balcony-terrace
 icon_3office
 icon_4
 icon_5
 icon_6
 websitehttp://www.thepartnerstrust.com/property/48376451/2522-Galicia-La-Verne-CA-91750
 meta_titleLuxury Home With Commanding Views | La Verne Real Estate | Partners Trust Real Estate Brokerage and Acquisitions
 meta_description2522 Galicia is a property offered for sale in La Verne, 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_built1998
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num316002922
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style21
 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.150417
 longitude-117.756081
 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 00:33:02
 created2016-04-04 12:46:23
 uri/property-detail/3695/2522-galicia-la-verne-ca-91750-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3695/2522-galicia-la-verne-ca-91750-usa
 address_concat2522 Galicia La Verne CA 91750 USA
 google_maps_query_string2522+Galicia++La+Verne+CA+91750+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,650,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty5
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2016-04-04
 overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id5
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties12
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties2
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id1
 WOEID2468964
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePartners Trust Real Estate Brokerage and Acquisitions
 broker_of_record_name
 short_namePartners Trust Real Estate
 usernamePartnersTrustPas
 password5b28522e46f56278664573d82c2b0f03520519d0
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPartners Trust is the exclusive representative for Leverage Global Partners in Pasadena and La Cañada Flintridge, California, USA. At Partners Trust, we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market, presenting our clients with the most professional, successful and ethical real estate associates in the business. We represent our clients with care, confidentiality and the utmost attention to service. Pasadena is a harmonious blend of past and present. Experience the nationally-televised Rose Parade, catch an exciting football game at the Rose Bowl, get smart at Caltech, or revel in the Jet Propulsion Laboratory. The community is renowned for its charming and diverse neighborhoods whose residents honor and preserve the splendor of early California architecture. Opportunities abound to experience Pasadena’s sophisticated culture with the diversified entertainment at the Pasadena Playhouse, the Norton Simon Museum, the Huntington Library and Botanical Gardens and even by walking along the vibrant, historic district of Colorado Boulevard. Partners Trust associates are proud to represent a wide variety of historic and architecturally diverse homes, including the Craftsman-style home. We understand our clients discerning needs, and provide a high level of service and local area knowledge. Partners Trust has additional office locations in <a href="../../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/142/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Malibu</a>, and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a>
 communitiesPasadena La Canada Flintridge San Marino La Canada Flintridge
 websitehttp://www.thepartnerstrust.com
 address594 E. Colorado Boulevard
 address_2
 cityPasadena
 stateCA
 full_stateCalifornia
 countryUSA
 marketPasadena
 market_2
 postal_code91101
 phone(626) 696-4802
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameScott Brown
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-scott-brown-managing-director-partners-trust-pasadena/
 contact_big_profile_link_text
 contact_titleManaging Director
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2Nick Segal
 contact_profile_link_2http://www.leveragere.com/brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2President/Co-Founder
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename5.jpg
 logo_filename5.png
 contact_image_filename5.jpg
 all_properties_link_image_filename5.jpg
 all_properties_linkhttp://www.thepartnerstrust.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titlePasadena Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
 meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Pasadena, CA is a premier boutique Pasadena real estate brokerage and the exclusive Pasadena representative for Leverage Global Partners.
 meta_keywordspartners trust, partners trust real estate, pasadena real estate, leverage global partners, pasadena homes for sale, scott brown
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-03-18 16:08:06
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/5/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortwww.thepartnerstrust.com
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id20012
 modelProperty
 model_id3695
 tagImage
 name35931.jpg
 typeimage/jpg
 size5892745
 uri/assets/20012.jpg
 order0
 created2016-04-07 17:25:23
 modified2016-04-07 17:25:23
 1(array)
 id20013
 modelProperty
 model_id3695
 tagImage
 name35932.jpg
 typeimage/jpg
 size4083851
 uri/assets/20013.jpg
 order1
 created2016-04-07 17:25:25
 modified2016-04-07 17:25:25
 2(array)
 id20014
 modelProperty
 model_id3695
 tagImage
 name35933.jpg
 typeimage/jpg
 size3659744
 uri/assets/20014.jpg
 order2
 created2016-04-07 17:25:26
 modified2016-04-07 17:25:26
 3(array)
 id20015
 modelProperty
 model_id3695
 tagImage
 name35934.jpg
 typeimage/jpg
 size4194573
 uri/assets/20015.jpg
 order3
 created2016-04-07 17:25:27
 modified2016-04-07 17:25:27
 4(array)
 id20016
 modelProperty
 model_id3695
 tagImage
 name35935.jpg
 typeimage/jpg
 size4529730
 uri/assets/20016.jpg
 order4
 created2016-04-07 17:25:29
 modified2016-04-07 17:25:29
 5(array)
 id20017
 modelProperty
 model_id3695
 tagImage
 name35936.jpg
 typeimage/jpg
 size3652871
 uri/assets/20017.jpg
 order5
 created2016-04-07 17:25:30
 modified2016-04-07 17:25:30
 6(array)
 id20018
 modelProperty
 model_id3695
 tagImage
 name35937.jpg
 typeimage/jpg
 size3779488
 uri/assets/20018.jpg
 order6
 created2016-04-07 17:25:32
 modified2016-04-07 17:25:32
 7(array)
 id20019
 modelProperty
 model_id3695
 tagImage
 name35938.jpg
 typeimage/jpg
 size5389737
 uri/assets/20019.jpg
 order7
 created2016-04-07 17:25:33
 modified2016-04-07 17:25:33
 8(array)
 id20020
 modelProperty
 model_id3695
 tagImage
 name35939.jpg
 typeimage/jpg
 size3592623
 uri/assets/20020.jpg
 order8
 created2016-04-07 17:25:34
 modified2016-04-07 17:25:34
 9(array)
 id20021
 modelProperty
 model_id3695
 tagImage
 name35940.jpg
 typeimage/jpg
 size3325821
 uri/assets/20021.jpg
 order9
 created2016-04-07 17:25:35
 modified2016-04-07 17:25:35
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id4236
 property_id3695
 property_feature_id12
 1(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id4237
 property_id3695
 property_feature_id1
 2(array)
 id9
 nameOffice
 additional(false)
 created2016-04-07 14:03:21
 modified2016-04-07 14:03:21
 PropertiesPropertyFeature(array)
 id4238
 property_id3695
 property_feature_id9
 Topic(empty)
- sidebar_locations(empty)
- highlighted_properties(array)
 0(array)
 Property(array)
 id3273
 brokerage_id5
 created_by_user_id0
 order5
 multi_unit(false)
 agent_1_id29
 agent_2_id0
 agent_3_id0
 nameSpectacular Estate with Stunning Views
 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)
 descriptionThis spectacular Estate in the hillside neighborhoods above Annandale Golf Club was designed for those who enjoy entertaining their family and friends. Providing stunning views of the valley and out to the ocean, this is a highly desirable area is perfect for those wanting the Pasadena lifestyle in an area providing easy access to the Westside, beach areas and downtown Los Angeles. This property has been extensively remodeled in the past 10-years with new kitchen, new baths, new HVAC, new flooring, and many more upgrades. Hillside properties providing views often have little or no flat land. This property with over 15,000 SF in land provides three outside areas, shaded patio, barbecue area and pool and spa area and these are areas adjacent to the interior living spaces. Competitively priced for a home offering over 5,000 SF it provides an amazing home at a very affordable price.
 address1428 Glen Oaks Blvd.
 address_2
 cityPasadena
 stateCA
 postal_code91105
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2750000
 price_20
 price_usd2750000
 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_feet5095
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1sq-ft
 icon_2views
 icon_3garage
 icon_4office
 icon_5balcony-terrace
 icon_6
 websitehttp://www.thepartnerstrust.com/property/48112253/1428-Glen-Oaks-Boulevard-Pasadena-CA-91105
 meta_titleSpectacular Estate with Stunning Views | Pasadena Real Estate | Partners Trust Real Estate Brokerage and Acquisitions
 meta_description1428 Glen Oaks Blvd. is a property offered for sale in Pasadena, 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_built1987
 virtual_tour
 video_tourhttps://vimeo.com/158265990
 digital_brochure
 video_tour_embed_code<iframe src="https://player.vimeo.com/video/158265990?title=0&byline=0&portrait=0" width="500" height="281" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>
 digital_brochure_embed_code
 mls_num316002246
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style17
 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.158264
 longitude-118.179626
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, bathrooms_partial, 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 00:33:02
 created2016-01-12 16:57:21
 uri/property-detail/3273/1428-glen-oaks-blvd-pasadena-ca-91105-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3273/1428-glen-oaks-blvd-pasadena-ca-91105-usa
 address_concat1428 Glen Oaks Blvd. Pasadena CA 91105 USA
 google_maps_query_string1428+Glen+Oaks+Blvd.++Pasadena+CA+91105++USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,750,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty3
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-01-12
 overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id5
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties12
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties2
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id1
 WOEID2468964
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePartners Trust Real Estate Brokerage and Acquisitions
 broker_of_record_name
 short_namePartners Trust Real Estate
 usernamePartnersTrustPas
 password5b28522e46f56278664573d82c2b0f03520519d0
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPartners Trust is the exclusive representative for Leverage Global Partners in Pasadena and La Cañada Flintridge, California, USA. At Partners Trust, we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market, presenting our clients with the most professional, successful and ethical real estate associates in the business. We represent our clients with care, confidentiality and the utmost attention to service. Pasadena is a harmonious blend of past and present. Experience the nationally-televised Rose Parade, catch an exciting football game at the Rose Bowl, get smart at Caltech, or revel in the Jet Propulsion Laboratory. The community is renowned for its charming and diverse neighborhoods whose residents honor and preserve the splendor of early California architecture. Opportunities abound to experience Pasadena’s sophisticated culture with the diversified entertainment at the Pasadena Playhouse, the Norton Simon Museum, the Huntington Library and Botanical Gardens and even by walking along the vibrant, historic district of Colorado Boulevard. Partners Trust associates are proud to represent a wide variety of historic and architecturally diverse homes, including the Craftsman-style home. We understand our clients discerning needs, and provide a high level of service and local area knowledge. Partners Trust has additional office locations in <a href="../../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/142/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Malibu</a>, and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a>
 communitiesPasadena La Canada Flintridge San Marino La Canada Flintridge
 websitehttp://www.thepartnerstrust.com
 address594 E. Colorado Boulevard
 address_2
 cityPasadena
 stateCA
 full_stateCalifornia
 countryUSA
 marketPasadena
 market_2
 postal_code91101
 phone(626) 696-4802
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameScott Brown
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-scott-brown-managing-director-partners-trust-pasadena/
 contact_big_profile_link_text
 contact_titleManaging Director
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2Nick Segal
 contact_profile_link_2http://www.leveragere.com/brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2President/Co-Founder
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename5.jpg
 logo_filename5.png
 contact_image_filename5.jpg
 all_properties_link_image_filename5.jpg
 all_properties_linkhttp://www.thepartnerstrust.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titlePasadena Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
 meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Pasadena, CA is a premier boutique Pasadena real estate brokerage and the exclusive Pasadena representative for Leverage Global Partners.
 meta_keywordspartners trust, partners trust real estate, pasadena real estate, leverage global partners, pasadena homes for sale, scott brown
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-03-18 16:08:06
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/5/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortwww.thepartnerstrust.com
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id18683
 modelProperty
 model_id3273
 tagImage
 name31614.jpg
 typeimage/jpg
 size802713
 uri/assets/18683.jpg
 order2406
 created2016-04-07 17:11:04
 modified2016-04-07 17:11:04
 1(array)
 id18684
 modelProperty
 model_id3273
 tagImage
 name31615.jpg
 typeimage/jpg
 size458566
 uri/assets/18684.jpg
 order2407
 created2016-04-07 17:11:04
 modified2016-04-07 17:11:04
 2(array)
 id18685
 modelProperty
 model_id3273
 tagImage
 name31616.jpg
 typeimage/jpg
 size378741
 uri/assets/18685.jpg
 order2408
 created2016-04-07 17:11:04
 modified2016-04-07 17:11:04
 3(array)
 id18686
 modelProperty
 model_id3273
 tagImage
 name31617.jpg
 typeimage/jpg
 size392130
 uri/assets/18686.jpg
 order2409
 created2016-04-07 17:11:04
 modified2016-04-07 17:11:04
 4(array)
 id18687
 modelProperty
 model_id3273
 tagImage
 name31618.jpg
 typeimage/jpg
 size500257
 uri/assets/18687.jpg
 order2410
 created2016-04-07 17:11:04
 modified2016-04-07 17:11:04
 5(array)
 id18688
 modelProperty
 model_id3273
 tagImage
 name31619.jpg
 typeimage/jpg
 size227644
 uri/assets/18688.jpg
 order2411
 created2016-04-07 17:11:04
 modified2016-04-07 17:11:04
 6(array)
 id18689
 modelProperty
 model_id3273
 tagImage
 name31620.jpg
 typeimage/jpg
 size397179
 uri/assets/18689.jpg
 order2412
 created2016-04-07 17:11:04
 modified2016-04-07 17:11:04
 7(array)
 id18690
 modelProperty
 model_id3273
 tagImage
 name31621.jpg
 typeimage/jpg
 size781365
 uri/assets/18690.jpg
 order2413
 created2016-04-07 17:11:04
 modified2016-04-07 17:11:04
 8(array)
 id18691
 modelProperty
 model_id3273
 tagImage
 name31622.jpg
 typeimage/jpg
 size279388
 uri/assets/18691.jpg
 order2414
 created2016-04-07 17:11:04
 modified2016-04-07 17:11:04
 9(array)
 id18692
 modelProperty
 model_id3273
 tagImage
 name31623.jpg
 typeimage/jpg
 size595090
 uri/assets/18692.jpg
 order2415
 created2016-04-07 17:11:04
 modified2016-04-07 17:11:04
 User(array)
 0(array)
 id269
 typeAgent
 brokerage_id5
 email[email protected]
 password262c94cda9dd93269c020701d66fd562edc301d3
 recover_hash
 first_nameSusan
 last_nameRatliff
 title
 dre_num
 phone626.696.4728
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:39
 created2017-08-07 15:22:39
 notified(false)
 full_nameSusan Ratliff
 uri/agent-detail/269/susan-ratliff
 profile_complete(true)
 UsersProperty(array)
 id45
 user_id269
 property_id3273
 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)
 id3952
 property_id3273
 property_feature_id14
 1(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id3953
 property_id3273
 property_feature_id4
 2(array)
 id9
 nameOffice
 additional(false)
 created2016-04-07 14:03:21
 modified2016-04-07 14:03:21
 PropertiesPropertyFeature(array)
 id3954
 property_id3273
 property_feature_id9
 3(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id3955
 property_id3273
 property_feature_id1
 Topic(empty)
 1(array)
 Property(array)
 id3471
 brokerage_id5
 created_by_user_id0
 order8
 multi_unit(false)
 agent_1_id404
 agent_2_id0
 agent_3_id0
 nameCustom-Built Contemporary Mediterranean
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 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)
 descriptionThis stunning single level Contemporary Mediterranean is located behind the gates in Kinneloa Estates & was custom-built w/entertaining in mind. The exterior and formal rooms are graced with thick concrete pillars. Quality features incl. vaulted ceilings, mitered windows, walls of glass, hardwood and tiled flooring. Two pillars set amidst a large arch lead into the formal LR w/dramatic fireplace, skylights & refinished HW floors. FRD w/high ceiling and semi-circular paned windows & skylights. Fam Rm w/curved flp, wood beamed ceiling & wet-bar. Lrg kitchen w/built-ins. The MBR suite is located in the south wing of the home w/high ceiling, spacious closet & large bath with soaking tub & Stall shower. The north wing affords two additional bedrm suites and a sunroom/office. A large laundry rm/utility access the two car garage. Pool, spa, low maintenance grounds, Partial city and mountain views. Truly a sophisticated well maintained adult home. 1/10 interest in private tennis court
 address2040 Glen Springs Road
 address_2
 cityPasadena
 stateCA
 postal_code91107
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2080000
 price_20
 price_usd2080000
 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_feet3679
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1sq-ft
 icon_2garage
 icon_3views
 icon_4tennis
 icon_5pool
 icon_6
 websitehttp://2040glenspringsroad.thepartnerstrust.com/
 meta_titleCustom-Built Contemporary Mediterranean | Pasadena Real Estate | Partners Trust Real Estate Brokerage and Acquisitions
 meta_description2040 Glen Springs Road is a property offered for sale in Pasadena, 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_built1997
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num316000293
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style17
 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.179680
 longitude-118.090782
 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 00:33:02
 created2016-02-22 12:58:53
 uri/property-detail/3471/2040-glen-springs-road-pasadena-ca-91107-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3471/2040-glen-springs-road-pasadena-ca-91107-usa
 address_concat2040 Glen Springs Road Pasadena CA 91107 USA
 google_maps_query_string2040+Glen+Springs+Road++Pasadena+CA+91107+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,080,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty3
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-02-22
 overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id5
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties12
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties2
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id1
 WOEID2468964
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePartners Trust Real Estate Brokerage and Acquisitions
 broker_of_record_name
 short_namePartners Trust Real Estate
 usernamePartnersTrustPas
 password5b28522e46f56278664573d82c2b0f03520519d0
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPartners Trust is the exclusive representative for Leverage Global Partners in Pasadena and La Cañada Flintridge, California, USA. At Partners Trust, we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market, presenting our clients with the most professional, successful and ethical real estate associates in the business. We represent our clients with care, confidentiality and the utmost attention to service. Pasadena is a harmonious blend of past and present. Experience the nationally-televised Rose Parade, catch an exciting football game at the Rose Bowl, get smart at Caltech, or revel in the Jet Propulsion Laboratory. The community is renowned for its charming and diverse neighborhoods whose residents honor and preserve the splendor of early California architecture. Opportunities abound to experience Pasadena’s sophisticated culture with the diversified entertainment at the Pasadena Playhouse, the Norton Simon Museum, the Huntington Library and Botanical Gardens and even by walking along the vibrant, historic district of Colorado Boulevard. Partners Trust associates are proud to represent a wide variety of historic and architecturally diverse homes, including the Craftsman-style home. We understand our clients discerning needs, and provide a high level of service and local area knowledge. Partners Trust has additional office locations in <a href="../../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/142/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Malibu</a>, and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a>
 communitiesPasadena La Canada Flintridge San Marino La Canada Flintridge
 websitehttp://www.thepartnerstrust.com
 address594 E. Colorado Boulevard
 address_2
 cityPasadena
 stateCA
 full_stateCalifornia
 countryUSA
 marketPasadena
 market_2
 postal_code91101
 phone(626) 696-4802
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameScott Brown
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-scott-brown-managing-director-partners-trust-pasadena/
 contact_big_profile_link_text
 contact_titleManaging Director
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2Nick Segal
 contact_profile_link_2http://www.leveragere.com/brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2President/Co-Founder
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename5.jpg
 logo_filename5.png
 contact_image_filename5.jpg
 all_properties_link_image_filename5.jpg
 all_properties_linkhttp://www.thepartnerstrust.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titlePasadena Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
 meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Pasadena, CA is a premier boutique Pasadena real estate brokerage and the exclusive Pasadena representative for Leverage Global Partners.
 meta_keywordspartners trust, partners trust real estate, pasadena real estate, leverage global partners, pasadena homes for sale, scott brown
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-03-18 16:08:06
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/5/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortwww.thepartnerstrust.com
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id19484
 modelProperty
 model_id3471
 tagImage
 name33748.jpg
 typeimage/jpg
 size605103
 uri/assets/19484.jpg
 order0
 created2016-04-07 17:24:13
 modified2016-04-07 17:24:13
 1(array)
 id19485
 modelProperty
 model_id3471
 tagImage
 name33749.jpg
 typeimage/jpg
 size459086
 uri/assets/19485.jpg
 order1
 created2016-04-07 17:24:13
 modified2016-04-07 17:24:13
 2(array)
 id19486
 modelProperty
 model_id3471
 tagImage
 name33750.jpg
 typeimage/jpg
 size392990
 uri/assets/19486.jpg
 order2
 created2016-04-07 17:24:13
 modified2016-04-07 17:24:13
 3(array)
 id19487
 modelProperty
 model_id3471
 tagImage
 name33751.jpg
 typeimage/jpg
 size364630
 uri/assets/19487.jpg
 order3
 created2016-04-07 17:24:13
 modified2016-04-07 17:24:13
 4(array)
 id19488
 modelProperty
 model_id3471
 tagImage
 name33752.jpg
 typeimage/jpg
 size280914
 uri/assets/19488.jpg
 order4
 created2016-04-07 17:24:13
 modified2016-04-07 17:24:13
 5(array)
 id19489
 modelProperty
 model_id3471
 tagImage
 name33753.jpg
 typeimage/jpg
 size429855
 uri/assets/19489.jpg
 order5
 created2016-04-07 17:24:13
 modified2016-04-07 17:24:13
 6(array)
 id19490
 modelProperty
 model_id3471
 tagImage
 name33754.jpg
 typeimage/jpg
 size325101
 uri/assets/19490.jpg
 order6
 created2016-04-07 17:24:13
 modified2016-04-07 17:24:13
 7(array)
 id19491
 modelProperty
 model_id3471
 tagImage
 name33755.jpg
 typeimage/jpg
 size474952
 uri/assets/19491.jpg
 order7
 created2016-04-07 17:24:13
 modified2016-04-07 17:24:13
 8(array)
 id19492
 modelProperty
 model_id3471
 tagImage
 name33756.jpg
 typeimage/jpg
 size457620
 uri/assets/19492.jpg
 order8
 created2016-04-07 17:24:13
 modified2016-04-07 17:24:13
 User(array)
 0(array)
 id611
 typeAgent
 brokerage_id5
 email[email protected]
 password3a00bf7e961797c63bcfc0f51e08b27374e42d64
 recover_hash
 first_nameMichael
 last_nameDilsaver
 title
 dre_num
 phone626.696.4806
 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_nameMichael Dilsaver
 uri/agent-detail/611/michael-dilsaver
 profile_complete(true)
 UsersProperty(array)
 id389
 user_id611
 property_id3471
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id4128
 property_id3471
 property_feature_id4
 1(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id4129
 property_id3471
 property_feature_id14
 2(array)
 id13
 nameTennis Court
 additional(false)
 created2016-04-07 14:04:41
 modified2016-04-07 14:04:41
 PropertiesPropertyFeature(array)
 id4130
 property_id3471
 property_feature_id13
 3(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id4131
 property_id3471
 property_feature_id12
 Topic(empty)
- custom_ga_event_properties(array)
 brokeragePartners Trust Real Estate Brokerage and Acquisitions, Pasadena
- property(array)
 Property(array)
 id3596
 brokerage_id5
 created_by_user_id0
 order4
 multi_unit(false)
 agent_1_id857
 agent_2_id0
 agent_3_id0
 nameSPRAWLING, SECLUDED MEDITERRANEAN
 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)
 descriptionSecluded, gated estate! Set back off of the street & buffered by a large circular courtyard/driveway & oak trees this 2004 built home has been transformed by the current owner into an exquisitely designed entertainer's dream. This sprawling two story Mediterranean style home sits on a large, flat 23,075 square foot lot and features an open floor plan, high ceilings, hardwood floors, custom lighting and fixtures, abundant storage & a three-car garage. There are 5 beds, 5 baths, formal living & dining rooms, formal 2 story entry, large great room & an upstairs family room loft. The gourmet kitchen has a large center island, stainless steel appliances, a breakfast counter, a nook & pantry room. The large master suite features a foyer, work-out room, large custom closet, steam shower & tub. The great room French doors lead to the resort like backyard featuring a sparkling PebbleTec pool & spa with 5 water features, grass, covered patios & more. La Canada Schools. Sewers IN, CONNECTED & PAID!
 address5020 Angeles Crest Highway
 address_2
 cityLa Canada Flintridge
 stateCA
 postal_code91011
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2950000
 price_20
 price_usd2950000
 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)
 bedrooms5
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet5620
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1sq-ft
 icon_2garage
 icon_3pool
 icon_4
 icon_5
 icon_6
 websitehttp://5020angelescrest.com/
 meta_titleSPRAWLING, SECLUDED MEDITERRANEAN | La Canada Flintridge Real Estate | Partners Trust Real Estate Brokerage and Acquisitions
 meta_description5020 Angeles Crest Highway is a property offered for sale in La Canada Flintridge, 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_built2004
 virtual_tour
 video_tourhttp://www.onvedeo.com/properties/702629/embed
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num316002275
 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.213329
 longitude-118.199501
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, 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 00:33:02
 created2016-03-15 14:20:07
 uri/property-detail/3596/5020-angeles-crest-highway-la-canada-flintridge-ca-91011-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3596/5020-angeles-crest-highway-la-canada-flintridge-ca-91011-usa
 address_concat5020 Angeles Crest Highway La Canada Flintridge CA 91011 USA
 google_maps_query_string5020+Angeles+Crest+Highway++La+Canada+Flintridge+CA+91011+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,950,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 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/assets/2251.png
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id5
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties12
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties2
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id1
 WOEID2468964
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePartners Trust Real Estate Brokerage and Acquisitions
 broker_of_record_name
 short_namePartners Trust Real Estate
 usernamePartnersTrustPas
 password5b28522e46f56278664573d82c2b0f03520519d0
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPartners Trust is the exclusive representative for Leverage Global Partners in Pasadena and La Cañada Flintridge, California, USA. At Partners Trust, we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market, presenting our clients with the most professional, successful and ethical real estate associates in the business. We represent our clients with care, confidentiality and the utmost attention to service. Pasadena is a harmonious blend of past and present. Experience the nationally-televised Rose Parade, catch an exciting football game at the Rose Bowl, get smart at Caltech, or revel in the Jet Propulsion Laboratory. The community is renowned for its charming and diverse neighborhoods whose residents honor and preserve the splendor of early California architecture. Opportunities abound to experience Pasadena’s sophisticated culture with the diversified entertainment at the Pasadena Playhouse, the Norton Simon Museum, the Huntington Library and Botanical Gardens and even by walking along the vibrant, historic district of Colorado Boulevard. Partners Trust associates are proud to represent a wide variety of historic and architecturally diverse homes, including the Craftsman-style home. We understand our clients discerning needs, and provide a high level of service and local area knowledge. Partners Trust has additional office locations in <a href="../../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/142/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Malibu</a>, and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a>
 communitiesPasadena La Canada Flintridge San Marino La Canada Flintridge
 websitehttp://www.thepartnerstrust.com
 address594 E. Colorado Boulevard
 address_2
 cityPasadena
 stateCA
 full_stateCalifornia
 countryUSA
 marketPasadena
 market_2
 postal_code91101
 phone(626) 696-4802
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameScott Brown
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-scott-brown-managing-director-partners-trust-pasadena/
 contact_big_profile_link_text
 contact_titleManaging Director
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2Nick Segal
 contact_profile_link_2http://www.leveragere.com/brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2President/Co-Founder
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename5.jpg
 logo_filename5.png
 contact_image_filename5.jpg
 all_properties_link_image_filename5.jpg
 all_properties_linkhttp://www.thepartnerstrust.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titlePasadena Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
 meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Pasadena, CA is a premier boutique Pasadena real estate brokerage and the exclusive Pasadena representative for Leverage Global Partners.
 meta_keywordspartners trust, partners trust real estate, pasadena real estate, leverage global partners, pasadena homes for sale, scott brown
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-03-18 16:08:06
 modified2016-04-08 16:33:22
 dre_num012345
 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)
 id2251
 modelBrokerage
 model_id5
 tagLogo
 name5.png
 typeimage/png
 size101949
 uri/assets/2251.png
 order0
 created2016-03-30 11:35:55
 modified2016-03-30 11:35:55
 MainImage(array)
 id2250
 modelBrokerage
 model_id5
 tagMainImage
 name5.jpg
 typeimage/jpg
 size4165793
 uri/assets/2250.jpg
 order0
 created2016-03-30 11:35:53
 modified2016-03-30 11:35:53
 ContactImage(array)
 id2252
 modelBrokerage
 model_id5
 tagContactImage
 name5.jpg
 typeimage/jpg
 size1252190
 uri/assets/2252.jpg
 order0
 created2016-03-30 11:35:55
 modified2016-03-30 11:35:55
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(array)
 id79
 modelBrokerage
 model_id5
 archived(false)
 medium_featured(false)
 large_featured(false)
 titleMeet Scott Brown: Managing Director, Partners Trust Pasadena
 authorLeverageRE
 date2013-08-09
 lead_in"I believe in our product and I believe in where we're going," says an exuberant Scott Brown, Managing Director of Partners Trust's Pasadena Office, when talking about his company. "I'm a big fan of being surrounded by visionaries who value quality over quantity and uphold the highest standards of integrity, morals and reputation."
 body Scott is a twenty-four-year, top-producing real estate veteran, whose previous experiences under the corporate umbrella left him feeling unsatisfied. When he would propose changes or new ideas, he had to contend with layers of corporate roadblocks. Scott, along with his wife, Giusy, were consistently selling over 60 properties a year, and when the opportunity knocked to helm the Pasadena office, he jumped at the chance. <img class="aligncenter size-large wp-image-1389 pure-img" alt="Scott Brown 1" src="/assets/205.jpg" width="750" height="1000" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/scottbrown4-225x300.jpg 225w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/scottbrown4-585x780.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/scottbrown4.jpg 750w" sizes="(max-width: 750px) 100vw, 750px"> With ownership in the company (a percentage is set aside for each partner associate at the company, vested over time) Scott can sit across the table from a potential client with a completely different mindset. "It holds a lot of water to be able to talk not only as an agent, but an owner," says Scott. As Managing Director, Scott oversees the entire office and all its associates. He leads weekly "action meetings" where "we work as a team and talk as owners" when making decisions about marketing or advertising or anything that affects the bottom line. Leverage: How has social media been incorporated into your and your agents’ business practices? Scott: It was a little overwhelming at first, but Partners Trust has a social media expert and a data analyst on staff to help all of us. They do seminars on how to blog, assist us in using Facebook, Twitter and LinkedIn, provide analysis and statistics on any market and are available exclusively for this purpose. <img class="aligncenter wp-image-1388 pure-img" alt="Scott Brown 2" src="/assets/206.jpg" width="1000" height="667" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/scottbrown1-300x200.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/scottbrown1-585x390.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/scottbrown1-360x240.jpg 360w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/scottbrown1-600x400.jpg 600w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/scottbrown1.jpg 1000w" sizes="(max-width: 1000px) 100vw, 1000px"> Leverage: How do you handle the new 24-hours-a-day business expectations? Scott: When I started [years ago], we didn't even have a fax machine. We've become better equipped and much more efficient now that we have the technology of our smart phones. If someone is heading out to see Open Houses and forgets the newspaper at home, they can pull up all the listings at their fingertips. Leverage: What drew you to Pasadena? Scott: My wife and I met in Milan, where she was born and raised, and on a visit to Pasadena, we fell in love with the culture, the preservation of the neighborhoods and were both reminded of Italy. Walking-friendly parklets are being planned which will surround the new Partners Trust office (opening this month); it will be a central location for dining and activity. <img class="aligncenter size-large wp-image-1387 pure-img" alt="Scott Brown 3" src="/assets/207.jpg" width="1000" height="750" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/scottbrown2-300x225.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/scottbrown2-585x438.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/scottbrown2-80x60.jpg 80w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/scottbrown2.jpg 1000w" sizes="(max-width: 1000px) 100vw, 1000px"> When not in the office, or with their two Jack Russell terriers, Scott and Giusy share a passion for exercise and fitness and have an ownership interest in the popular Pasadena gym Breakthru Fitness. They love kickboxing, yoga, and Zumba and have been featured in numerous workout DVDs. Leverage Global Partners is proud to have Scott Brown and Partners Trust as valued members of the network.
 vimeo_id
 created2016-02-25 14:08:52
 modified2016-04-05 14:41:06
 uri/articles/view/79/meet-scott-brown-managing-director-partners-trust-pasadena
 FeaturedImage(empty)
 Location(empty)
 User(array)
 0(array)
 id67
 typeBrokerageAdmin
 brokerage_id5
 email[email protected]
 password380caa25f95eecd4c9009e6d5ff51561617cd297
 recover_hash
 first_nameScott
 last_nameBrown
 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 09:54:27
 created2016-04-08 16:33:22
 notified(true)
 full_nameScott Brown
 uri/agent-detail/67/scott-brown
 profile_complete(true)
 1(array)
 id268
 typeAgent
 brokerage_id5
 email[email protected]
 passwordd92c183f7d14d918e71c867381742f5a999d816b
 recover_hash
 first_nameAason
 last_nameAlms
 title
 dre_num
 phone626.696.4812
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:39
 created2017-08-07 15:22:39
 notified(false)
 full_nameAason Alms
 uri/agent-detail/268/aason-alms
 profile_complete(true)
 2(array)
 id269
 typeAgent
 brokerage_id5
 email[email protected]
 password262c94cda9dd93269c020701d66fd562edc301d3
 recover_hash
 first_nameSusan
 last_nameRatliff
 title
 dre_num
 phone626.696.4728
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:39
 created2017-08-07 15:22:39
 notified(false)
 full_nameSusan Ratliff
 uri/agent-detail/269/susan-ratliff
 profile_complete(true)
 3(array)
 id279
 typeAgent
 brokerage_id5
 email[email protected]
 password1e1ff7a1f5034b9b14f634af30761042f7252d8b
 recover_hash
 first_nameSookie
 last_nameMathews
 title
 dre_num
 phone818.488.5820
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:39
 created2017-08-07 15:22:39
 notified(false)
 full_nameSookie Mathews
 uri/agent-detail/279/sookie-mathews
 profile_complete(true)
 4(array)
 id280
 typeAgent
 brokerage_id5
 email[email protected]
 password060a9795d99bd69f0059b8e3db4ff02cb453784c
 recover_hash
 first_nameGiusy
 last_nameMele-Brown
 title
 dre_num
 phone626.696.4804
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:39
 created2017-08-07 15:22:39
 notified(false)
 full_nameGiusy Mele-Brown
 uri/agent-detail/280/giusy-mele-brown
 profile_complete(true)
 5(array)
 id281
 typeAgent
 brokerage_id5
 email[email protected]
 password067cbf017928c379ac7109e2b0f5615938b286f4
 recover_hash
 first_nameJennifer
 last_nameChan
 title
 dre_num
 phone626.696.4840
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:39
 created2017-08-07 15:22:39
 notified(false)
 full_nameJennifer Chan
 uri/agent-detail/281/jennifer-chan
 profile_complete(true)
 6(array)
 id282
 typeAgent
 brokerage_id5
 email[email protected]
 password54fb0c3139b85a7634c96cb7ab56ab63c518b92a
 recover_hash
 first_nameJerry
 last_nameCurrent
 title
 dre_num
 phone626.696.4732
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:39
 created2017-08-07 15:22:39
 notified(false)
 full_nameJerry Current
 uri/agent-detail/282/jerry-current
 profile_complete(true)
 7(array)
 id286
 typeAgent
 brokerage_id5
 email[email protected]
 passwordc37bdea58ad91e3d3507cfdd7d5ed7501b79d403
 recover_hash
 first_nameRichard
 last_name Von Ernst
 title
 dre_num
 phone626.696.4844
 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_nameRichard Von Ernst
 uri/agent-detail/286/richard-von-ernst
 profile_complete(true)
 8(array)
 id450
 typeAgent
 brokerage_id5
 email[email protected]
 passwordf44801f3d517e5dc636aad6b584a7bfff980248b
 recover_hash
 first_nameLady
 last_nameRodriguez
 title
 dre_num
 phone310.500.3087
 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_nameLady Rodriguez
 uri/agent-detail/450/lady-rodriguez
 profile_complete(true)
 9(array)
 id451
 typeAgent
 brokerage_id5
 email[email protected]
 password47b68d8b589b4dcc5cff7b772989be154e18015e
 recover_hash
 first_nameThe Botsford
 last_nameGroup
 title
 dre_num
 phone626.696.4810
 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_nameThe Botsford Group
 uri/agent-detail/451/the-botsford-group
 profile_complete(true)
 10(array)
 id583
 typeAgent
 brokerage_id5
 email[email protected]
 password55f059e0099875cdee0dd1c88b4cac9a4f730e29
 recover_hash
 first_nameVicky
 last_nameBotsford
 title
 dre_num
 phone626.696.4810
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:08
 created2017-08-07 15:23:08
 notified(false)
 full_nameVicky Botsford
 uri/agent-detail/583/vicky-botsford
 profile_complete(true)
 11(array)
 id584
 typeAgent
 brokerage_id5
 email[email protected]
 password618c580fa65f9e3397651493a45c90f4758c81c6
 recover_hash
 first_nameJeff
 last_nameBotsford
 title
 dre_num
 phone626.696.4808
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:09
 created2017-08-07 15:23:09
 notified(false)
 full_nameJeff Botsford
 uri/agent-detail/584/jeff-botsford
 profile_complete(true)
 12(array)
 id611
 typeAgent
 brokerage_id5
 email[email protected]
 password3a00bf7e961797c63bcfc0f51e08b27374e42d64
 recover_hash
 first_nameMichael
 last_nameDilsaver
 title
 dre_num
 phone626.696.4806
 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_nameMichael Dilsaver
 uri/agent-detail/611/michael-dilsaver
 profile_complete(true)
 13(array)
 id691
 typeAgent
 brokerage_id5
 email[email protected]
 passworda86e1b0b3ea988e0ba7df206fb2cdb45daa45155
 recover_hash
 first_nameSusan
 last_nameMohr
 title
 dre_num
 phone626.696.4816
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:16
 created2017-08-07 15:23:16
 notified(false)
 full_nameSusan Mohr
 uri/agent-detail/691/susan-mohr
 profile_complete(true)
 14(array)
 id692
 typeAgent
 brokerage_id5
 email[email protected]
 passwordc7824c28d765f64ab07d56dc28195439a1d7fab3
 recover_hash
 first_nameBradley
 last_nameMohr
 title
 dre_num
 phone626.696.4814
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:16
 created2017-08-07 15:23:16
 notified(false)
 full_nameBradley Mohr
 uri/agent-detail/692/bradley-mohr
 profile_complete(true)
 15(array)
 id709
 typeAgent
 brokerage_id5
 email[email protected]
 password1d0030842b16e5056035a18eddb12ecc6ff0950d
 recover_hash
 first_nameChristine
 last_nameNavarro
 title
 dre_num
 phone818.488.5812
 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_nameChristine Navarro
 uri/agent-detail/709/christine-navarro
 profile_complete(true)
 16(array)
 id718
 typeAgent
 brokerage_id5
 email[email protected]
 passworde16764db912cdf36d1c6dd5a2bd159203fbdde22
 recover_hash
 first_nameKaren
 last_nameNielsen
 title
 dre_num
 phone626.696.4830
 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_nameKaren Nielsen
 uri/agent-detail/718/karen-nielsen
 profile_complete(true)
 17(array)
 id799
 typeAgent
 brokerage_id5
 email[email protected]
 password6a8edc8e7cf7037bf2cf6502a2c10d09d9355e26
 recover_hash
 first_nameCarey
 last_nameHaynes
 title
 dre_num
 phone818.488.5800
 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_nameCarey Haynes
 uri/agent-detail/799/carey-haynes
 profile_complete(true)
 18(array)
 id800
 typeAgent
 brokerage_id5
 email[email protected]
 passworda33aeef99eccbf38e6d6406733974410653e92bd
 recover_hash
 first_nameBen
 last_nameKelly
 title
 dre_num
 phone818.488.5802
 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_nameBen Kelly
 uri/agent-detail/800/ben-kelly
 profile_complete(true)
 19(array)
 id940
 typeAgent
 brokerage_id5
 email[email protected]
 passwordcb48b7281adb1166af7c1c68a117a685c757de42
 recover_hash
 first_nameFran
 last_nameBenuska
 title
 dre_num
 phone626.253.0029
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:45
 created2017-08-07 15:23:45
 notified(false)
 full_nameFran Benuska
 uri/agent-detail/940/fran-benuska
 profile_complete(true)
 20(array)
 id941
 typeAgent
 brokerage_id5
 email[email protected]
 passwordabc682447210f48fc403bf8f71bbb0b2b3a0e6a1
 recover_hash
 first_nameLeann
 last_nameHealy
 title
 dre_num
 phone626.696.4770
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:45
 created2017-08-07 15:23:45
 notified(false)
 full_nameLeann Healy
 uri/agent-detail/941/leann-healy
 profile_complete(true)
 21(array)
 id957
 typeAgent
 brokerage_id5
 email[email protected]
 passwordea43c458ee3f911dff1b50417437612482157035
 recover_hash
 first_nameCindy
 last_nameSalcido
 title
 dre_num
 phone626.696.4820
 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_nameCindy Salcido
 uri/agent-detail/957/cindy-salcido
 profile_complete(true)
 22(array)
 id958
 typeAgent
 brokerage_id5
 email[email protected]
 password95a632a81b4aa42a5f3f139b6c9ef124e019f060
 recover_hash
 first_nameJeff
 last_nameSalcido
 title
 dre_num
 phone626.696.4822
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:46
 created2017-08-07 15:23:46
 notified(false)
 full_nameJeff Salcido
 uri/agent-detail/958/jeff-salcido
 profile_complete(true)
 23(array)
 id981
 typeAgent
 brokerage_id5
 email[email protected]
 passworddc4f4409de3089147271a3d206f538b593ef8b05
 recover_hash
 first_nameKevin
 last_nameGrahn
 title
 dre_num
 phone818.269.4954
 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_nameKevin Grahn
 uri/agent-detail/981/kevin-grahn
 profile_complete(true)
 24(array)
 id1035
 typeAgent
 brokerage_id5
 email[email protected]
 password1353337173d32385c5c1466107b69b36f7aeeffc
 recover_hash
 first_nameDeanne
 last_nameAnderson
 title
 dre_num
 phone818.266.8561
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:50
 created2017-08-07 15:23:50
 notified(false)
 full_nameDeanne Anderson
 uri/agent-detail/1035/deanne-anderson
 profile_complete(true)
 25(array)
 id1168
 typeAgent
 brokerage_id5
 email[email protected]
 password91c38e1649f0bdb90e8e55ceaee329e8db54fdf1
 recover_hash
 first_nameCarol
 last_nameKurachi
 title
 dre_num
 phone626.688.2477
 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_nameCarol Kurachi
 uri/agent-detail/1168/carol-kurachi
 profile_complete(true)
 26(array)
 id1249
 typeAgent
 brokerage_id5
 email[email protected]
 password88c479f0fb5fc9318950253b1708ad8490220c7c
 recover_hash
 first_nameStephanie
 last_nameMiller
 title
 dre_num
 phone626.394.9818
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:24:00
 created2017-08-07 15:24:00
 notified(false)
 full_nameStephanie Miller
 uri/agent-detail/1249/stephanie-miller
 profile_complete(true)
 uri/brokerage-detail/5/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortwww.thepartnerstrust.com
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id19688
 modelProperty
 model_id3596
 tagImage
 name34929.jpg
 typeimage/jpg
 size483739
 uri/assets/19688.jpg
 order0
 created2016-04-07 17:24:54
 modified2016-04-07 17:24:54
 1(array)
 id19689
 modelProperty
 model_id3596
 tagImage
 name34930.jpg
 typeimage/jpg
 size376903
 uri/assets/19689.jpg
 order1
 created2016-04-07 17:24:54
 modified2016-04-07 17:24:54
 2(array)
 id19690
 modelProperty
 model_id3596
 tagImage
 name34931.jpg
 typeimage/jpg
 size411391
 uri/assets/19690.jpg
 order2
 created2016-04-07 17:24:54
 modified2016-04-07 17:24:54
 3(array)
 id19691
 modelProperty
 model_id3596
 tagImage
 name34932.jpg
 typeimage/jpg
 size438581
 uri/assets/19691.jpg
 order3
 created2016-04-07 17:24:54
 modified2016-04-07 17:24:54
 4(array)
 id19692
 modelProperty
 model_id3596
 tagImage
 name34933.jpg
 typeimage/jpg
 size289461
 uri/assets/19692.jpg
 order4
 created2016-04-07 17:24:54
 modified2016-04-07 17:24:54
 5(array)
 id19693
 modelProperty
 model_id3596
 tagImage
 name34934.jpg
 typeimage/jpg
 size360972
 uri/assets/19693.jpg
 order5
 created2016-04-07 17:24:54
 modified2016-04-07 17:24:54
 6(array)
 id19694
 modelProperty
 model_id3596
 tagImage
 name34935.jpg
 typeimage/jpg
 size321131
 uri/assets/19694.jpg
 order6
 created2016-04-07 17:24:54
 modified2016-04-07 17:24:54
 7(array)
 id19695
 modelProperty
 model_id3596
 tagImage
 name34936.jpg
 typeimage/jpg
 size769873
 uri/assets/19695.jpg
 order7
 created2016-04-07 17:24:54
 modified2016-04-07 17:24:54
 8(array)
 id19696
 modelProperty
 model_id3596
 tagImage
 name34937.jpg
 typeimage/jpg
 size632865
 uri/assets/19696.jpg
 order8
 created2016-04-07 17:24:54
 modified2016-04-07 17:24:54
 9(array)
 id19697
 modelProperty
 model_id3596
 tagImage
 name34938.jpg
 typeimage/jpg
 size952805
 uri/assets/19697.jpg
 order9
 created2016-04-07 17:24:54
 modified2016-04-07 17:24:54
 User(array)
 0(array)
 id1035
 typeAgent
 brokerage_id5
 email[email protected]
 password1353337173d32385c5c1466107b69b36f7aeeffc
 recover_hash
 first_nameDeanne
 last_nameAnderson
 title
 dre_num
 phone818.266.8561
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:50
 created2017-08-07 15:23:50
 notified(false)
 full_nameDeanne Anderson
 uri/agent-detail/1035/deanne-anderson
 profile_complete(true)
 UsersProperty(array)
 id793
 user_id1035
 property_id3596
 sort_order0
 Brokerage(array)
 id5
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties12
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties2
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id1
 WOEID2468964
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePartners Trust Real Estate Brokerage and Acquisitions
 broker_of_record_name
 short_namePartners Trust Real Estate
 usernamePartnersTrustPas
 password5b28522e46f56278664573d82c2b0f03520519d0
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPartners Trust is the exclusive representative for Leverage Global Partners in Pasadena and La Cañada Flintridge, California, USA. At Partners Trust, we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market, presenting our clients with the most professional, successful and ethical real estate associates in the business. We represent our clients with care, confidentiality and the utmost attention to service. Pasadena is a harmonious blend of past and present. Experience the nationally-televised Rose Parade, catch an exciting football game at the Rose Bowl, get smart at Caltech, or revel in the Jet Propulsion Laboratory. The community is renowned for its charming and diverse neighborhoods whose residents honor and preserve the splendor of early California architecture. Opportunities abound to experience Pasadena’s sophisticated culture with the diversified entertainment at the Pasadena Playhouse, the Norton Simon Museum, the Huntington Library and Botanical Gardens and even by walking along the vibrant, historic district of Colorado Boulevard. Partners Trust associates are proud to represent a wide variety of historic and architecturally diverse homes, including the Craftsman-style home. We understand our clients discerning needs, and provide a high level of service and local area knowledge. Partners Trust has additional office locations in <a href="../../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/142/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Malibu</a>, and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a>
 communitiesPasadena La Canada Flintridge San Marino La Canada Flintridge
 websitehttp://www.thepartnerstrust.com
 address594 E. Colorado Boulevard
 address_2
 cityPasadena
 stateCA
 full_stateCalifornia
 countryUSA
 marketPasadena
 market_2
 postal_code91101
 phone(626) 696-4802
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameScott Brown
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-scott-brown-managing-director-partners-trust-pasadena/
 contact_big_profile_link_text
 contact_titleManaging Director
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2Nick Segal
 contact_profile_link_2http://www.leveragere.com/brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2President/Co-Founder
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename5.jpg
 logo_filename5.png
 contact_image_filename5.jpg
 all_properties_link_image_filename5.jpg
 all_properties_linkhttp://www.thepartnerstrust.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titlePasadena Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
 meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Pasadena, CA is a premier boutique Pasadena real estate brokerage and the exclusive Pasadena representative for Leverage Global Partners.
 meta_keywordspartners trust, partners trust real estate, pasadena real estate, leverage global partners, pasadena homes for sale, scott brown
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-03-18 16:08:06
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/5/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortwww.thepartnerstrust.com
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 Image(empty)
 BrokerageLogoOverride(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id4181
 property_id3596
 property_feature_id4
 Icon(array)
 id3553
 modelPropertyFeature
 model_id4
 tagIcon
 name132.png
 typeimage/png
 size2141
 uri/assets/3553.png
 order0
 created2016-04-07 14:01:51
 modified2016-04-07 14:01:52
 1(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id4182
 property_id3596
 property_feature_id12
 Icon(array)
 id3561
 modelPropertyFeature
 model_id12
 tagIcon
 name140.png
 typeimage/png
 size1464
 uri/assets/3561.png
 order0
 created2016-04-07 14:04:11
 modified2016-04-07 14:04:12
 Topic(empty)
- membership_subscription_temp_allowed_login(null)
- newsletter_member_types(array)
 Leverage Member: AgentLeverage Member: Agent
 Leverage Member: Broker or ManagementLeverage Member: Broker or Management
 Non-MemberNon-Member
- $request->data(empty)
- $this->validationErrors(array)
 Subscription(empty)
 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/3596/5020-angeles-crest-highway-la-canada-flintridge-ca-91011-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/property-detail/3596/5020-angeles-crest-highway-la-canada-flintridge-ca-91011-usa
Remote Port	14413
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 Cf Ray	a09e117d18541709-CMH
Http Accept Encoding	gzip, br
Http Cookie	CAKEPHP=id5ovnijgfoa5pitosi679i103
Http Accept	/
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
Http X Forwarded For	216.73.216.172
Proxy-nokeepalive	1
Ssl Tls Sni	staging2.leveragere.com
Https	on
Passenger Download Native Support Binary	0
Passenger Compile Native Support Binary	0
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Unique Id	aipBlFLEEfcqtnCHo5U6egAAABg
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	aipBlFLEEfcqtnCHo5U6egAAABg
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781154196.0352
Request Time	1781154196

====

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

SPRAWLING, SECLUDED MEDITERRANEAN

Represented By: Partners Trust Real Estate Brokerage and Acquisitions

www.thepartnerstrust.com | License #: 012345

Highlighted Properties

Spectacular Estate with Stunning Views

Custom-Built Contemporary Mediterranean

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

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