Locations / Glastonbury, CT, USA

Glastonbury, CT, USA

More information coming soon!

Location Represented By

License #: 012345

12:41am local time

Partner Search

Find partners with a map-based search

Related Locations

BIG ISLAND OF HAWAII, HI, USA

The Kona-Kohala Coast is a contrast between the old and the new offering unspoiled natural beauty, a pristine environment together with world class properties and amenities.

Lisbon, Portugal

San Francisco, CA, USA

Considered by millions as the Best City in America.

Washington, D.C, USA

Related Partners

Mauna Kea Realty

(808) 882-5600 | Email
License #: 012345

Marshall Realty

650-873-6844 | Email
License #: 012345

Special Properties

Office: (201) 934-7111 | Email
License #: 012345

Mammoth Village Properties

(800) 421-7005 | Email
License #: 012345

Recent Property Listings

Victorian Era Townhome in the Historic Landmark District

407 East Huntingdon Street
Savannah, GA 31401
$549,500

Artful Spaces

4421 Ridge Street
Chevy Chase, MD 20815
$2,200,000

Lovely & Detailed Remodel in South Pasadena

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

Beautiful Mid Century Gem

2544 Greenvalley Road
Los Angeles, CA 90046
$2,450,000

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

Array
(
)

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

Cake Params
- plugin(null)
- controllerlocations
- actionview
- named(empty)
- pass(array)
  0170
  1glastonbury-ct-usa
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

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

Sql Log

Sql Logs

default

Total Time: 26 ms
Total Queries: 19 queries

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

Query Explain:

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

====

Timer

Memory

Peak Memory Use 13.75 MB

Message	Memory use
Component initialization	2.88 MB
Controller action start	3.81 MB
Controller render start	6.64 MB
View render complete	7.19 MB

Timers

Total Request Time: 618 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	417.96
Event: Controller.initialize	3.93
Event: Controller.startup	1.34
Controller action	55.36
Event: Controller.beforeRender	13.69
» Processing toolbar data	13.58
Rendering View	90.87
» Event: View.beforeRender	0.27
» Rendering APP/View/Locations/view.ctp	2.62
» » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.15
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.15
» » Rendering APP/View/Elements/sidebar/brokerage_list.ctp	0.16
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.27
» » » Rendering APP/View/Elements/static_property_price.ctp	0.38
» » » Rendering APP/View/Elements/static_property_price.ctp #2	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #3	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.22
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	87.21
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)
 id3743
 brokerage_id101
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameVictorian Era Townhome in the Historic Landmark District
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(false)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(false)
 descriptionc. 1890 -1900 This authentic Victorian Era semi-attached townhome is located in a quiet neighborhood in Savannah’s Historic Landmark District, just three blocks from Forsyth Park. With three bedrooms, two & a half bathrooms, a large private courtyard and two off street parking spaces, this home has it all! Entering the home through double doors into the foyer and entry hall you will immediately appreciate the flood of natural light that fills this home amplifying the beauty of the heart pine floors, high ceilings and period details. The double parlor separated by working pocket doors, provides a large dining room and living room with two fireplaces. A large bay window perfectly frames the beauty of the neighboring historic properties. A light and airy updated kitchen, with high end appliances, solid surface counters and beautiful tile has views of the lush and private courtyard. A powder room is situated in a rear entry hall that offers access to the deck and courtyard. Upstairs a comfortable master suite with fireplace, and large bay window awaits. The adjoining bath is large and bright with a claw-footed tub. A second large bedroom with a fireplace and southern exposure is a perfect space for visiting guest. A beautifully updated second bath is adjacent to a third cozy bedroom with views into the garden. Once outside, the beauty of the lushly landscaped garden is breathtaking. Palms, bamboo, fern and beds filled with perennials and annuals surround a large brick patio perfect for summertime parties. An adorable garden house offers those with a green thumb plenty of space for their garden tools. Through a gate at the rear of the garden, are located two off street parking spaces and access to the lane.
 address407 East Huntingdon Street
 address_2
 citySavannah
 stateGA
 postal_code31401
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price549500
 price_20
 price_usd549500
 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
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet1884
 square_meters
 acres8
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size8
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude37.090240
 longitude37.090240
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id3
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2024-09-26 12:45:33
 created2016-04-18 11:57:57
 uri/property-detail/3743/407-east-huntingdon-street-savannah-ga-31401-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3743/407-east-huntingdon-street-savannah-ga-31401-usa
 address_concat407 East Huntingdon Street Savannah GA 31401 USA
 google_maps_query_string407+East+Huntingdon+Street++Savannah+GA+31401+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 549,500
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty2
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2016-04-18
 overridden_brokerage_nameThree Oaks Realty Co.
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id3
 nameUnder $1 Million
 created2019-08-22 10:08:27
 modified2019-08-29 09:59:08
 uri/category-detail/3/under-1-million
 Brokerage(array)
 id101
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2489314
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameThree Oaks Realty Co.
 broker_of_record_name
 short_nameThree Oaks Realty Co.
 usernameThreeOaksRealty
 password2e25ea6416fb35cb0184a531b476e7a8d1233cf9
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionThree Oaks Realty Co. is the exclusive representative for Leverage Global Partners in Historic Savannah, Tybee Island, Wilmington Island, Whitemarsh Island, Isle of Hope, Skidaway Island, Pooler, Rincon, Richmond Hill, Garden City, Hutchinson Island and Savannah, Georgia, USA. We founded Three Oaks Realty Company on the idea that you should love what you do, do it better than anyone else, and attract others that appreciate those two principles. Our company culture is not only extraordinarily customer centric, but it is built on a foundation of mutual respect for one another, our colleagues and vendors. This bond transcends everything we do. We’re also really fun people, so if you’re ever in the neighborhood- stop by and say hi. Why Three Oaks? At Three Oaks Realty, we have a vast amount of experience selling Savannah and the Low Country. We decided to start our company because we believe in a different approach to real estate, and we are eager to share our experience and our approach with you. We believe that you should be the center of everything we do. Not a fancy brand or a complex process. Life is busy, we get that, and our goal is to make your transaction smooth, efficient, satisfying and above all, enjoyable. We chose our name, Three Oaks Realty Company, not only because the oak tree stands as one of our area’s most distinctive landmarks, but because its unique stature embodies everything we love about living and working in the low country. The enchanting, understated, natural beauty captures the unique allure that makes Savannah the perfect place to call home. Part of what makes our Southern Live Oak trees so iconic is the presence of Spanish moss- a bit like a natural partnership. We believe that real estate should embody this same principal. It should be collaborative- between realtors, clients, vendors and community partners. When all of these things are working together- it has the power to turn real estate dreams into reality. No two oaks are the same, but they are unified in their strong roots and the foundation from which they grow. That mirrors how we feel about our partnership at Three Oaks Realty Company. We all bring different perspectives and different strengths to the table, but we have the same core beliefs. It’s these beliefs that represent the roots of this company and everything we do. Simply, love what you do, and do it better than anyone else.
 communitiesSkidaway Island Isle of Hope Tybee Island Pooler, Rincon Richmond Hill Garden City Whitemarsh Island Wilmington Island Hutchinson Island Historic district Historic Savannah
 websitehttp://www.threeoaksrealtycompany.com/
 address509 Barnard Street
 address_2
 citySavannah
 stateGA
 full_stateGeorgia
 countryUSA
 marketSavannah
 market_2
 postal_code
 phoneOffice: (912) 777-4560
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameCliff Murse, Stephanie Wilson-Evans, Tommy Reese
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePartners
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Savannah real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3[email protected]
 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_filename101.jpg
 logo_filename101.jpeg
 contact_image_filename101.jpeg
 all_properties_link_image_filename101.jpg
 all_properties_linkhttp://www.threeoaksrealtycompany.com/category/featured-property/
 video_embed_code
 contact_video_embed_code
 meta_titleSavannah Real Estate | Three Oaks Realty Co. | Leverage Global Partners
 meta_descriptionThree Oaks Realty Co. is the exclusive representative for Leverage Global Partners in Savannah, Georgia, USA.
 meta_keywordsSavannah Real Estate, Three Oaks Realty Co., Leverage Global Partners, Cliff Murse, Historic District, Historic Savannah
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-02-27 16:38:01
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/101/three-oaks-realty-co
 website_shortwww.threeoaksrealtycompany.com
 name_with_locationThree Oaks Realty Co.
 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)
 id20999
 modelProperty
 model_id3743
 tagImage
 nameThree-Oaks-Realty-407 E Huntingdon-Ext 1.jpg
 typeimage/jpeg
 size740866
 uri/assets/20999.jpg
 order0
 created2016-04-18 11:46:37
 modified2016-04-18 11:57:57
 1(array)
 id21005
 modelProperty
 model_id3743
 tagImage
 nameThree-Oaks-Realty-407 E Huntingdon-LR1.jpg
 typeimage/jpeg
 size540590
 uri/assets/21005.jpg
 order1
 created2016-04-18 11:49:45
 modified2016-04-18 11:57:57
 2(array)
 id21000
 modelProperty
 model_id3743
 tagImage
 nameThree-Oaks-Realty-407 E Huntingdon-DR3.jpg
 typeimage/jpeg
 size459452
 uri/assets/21000.jpg
 order2
 created2016-04-18 11:48:53
 modified2016-04-18 11:57:57
 3(array)
 id21001
 modelProperty
 model_id3743
 tagImage
 nameThree-Oaks-Realty-407 E Huntingdon-Kitchen2.jpg
 typeimage/jpeg
 size348281
 uri/assets/21001.jpg
 order3
 created2016-04-18 11:49:11
 modified2016-04-18 11:57:57
 4(array)
 id21011
 modelProperty
 model_id3743
 tagImage
 nameThree-Oaks-Realty-407 E Huntingdon-Bar.jpg
 typeimage/jpeg
 size400648
 uri/assets/21011.jpg
 order4
 created2016-04-18 11:50:35
 modified2016-04-18 11:57:57
 5(array)
 id21008
 modelProperty
 model_id3743
 tagImage
 nameThree-Oaks-Realty-407 E Huntingdon-Master Bed.jpg
 typeimage/jpeg
 size440915
 uri/assets/21008.jpg
 order5
 created2016-04-18 11:50:08
 modified2016-04-18 11:57:57
 6(array)
 id21006
 modelProperty
 model_id3743
 tagImage
 nameThree-Oaks-Realty-407 E Huntingdon-Master Bath2.jpg
 typeimage/jpeg
 size380634
 uri/assets/21006.jpg
 order6
 created2016-04-18 11:50:01
 modified2016-04-18 11:57:57
 7(array)
 id21017
 modelProperty
 model_id3743
 tagImage
 nameThree-Oaks-Realty-407 E Huntingdon-Office.jpg
 typeimage/jpeg
 size448423
 uri/assets/21017.jpg
 order7
 created2016-04-18 11:53:30
 modified2016-04-18 11:57:57
 8(array)
 id21015
 modelProperty
 model_id3743
 tagImage
 nameThree-Oaks-Realty-407 E Huntingdon-Ext Back.jpg
 typeimage/jpeg
 size1119456
 uri/assets/21015.jpg
 order8
 created2016-04-18 11:50:56
 modified2016-04-18 11:57:57
 User(array)
 0(array)
 id791
 typeAgent
 brokerage_id101
 email[email protected]
 passwordecfd706419eabeb047a9d7c668aa60b8567a1b2c
 recover_hash
 first_nameStephanie
 last_nameWilson-Evans
 title
 dre_num
 phone912-272-0010
 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_nameStephanie Wilson-Evans
 uri/agent-detail/791/stephanie-wilson-evans
 profile_complete(true)
 UsersProperty(array)
 id544
 user_id791
 property_id3743
 sort_order0
 1(array)
 id792
 typeAgent
 brokerage_id101
 email[email protected]
 password28100f4d1cac251bc920031825d0b18d82b40f43
 recover_hash
 first_nameCliff
 last_nameMurse
 title
 dre_num
 phone205-706-6863
 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_nameCliff Murse
 uri/agent-detail/792/cliff-murse
 profile_complete(true)
 UsersProperty(array)
 id551
 user_id792
 property_id3743
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 1(array)
 Property(array)
 id3704
 brokerage_id81
 created_by_user_id0
 order2
 multi_unit(false)
 agent_1_id150
 agent_2_id0
 agent_3_id0
 nameArtful Spaces
 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)
 descriptionDramatic new home by PKK Builders & design by GTM Architects. Exceptional quality throughout. Stunning design. Beautiful scale. Unbeatable location,-talk about a great lifestyle!!! Completion early 2016. This is a great time to pick finishes and customize. Walk to downtown Bethesda, metro, shopping, restaurant district, entertainment & more! Comprehensive resident services by Town of Ch Chase!
 address4421 Ridge Street
 address_2
 cityChevy Chase
 stateMD
 postal_code20815
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2200000
 price_20
 price_usd2200000
 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_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://www.eversco.com/homes-for-sale-details/4421-RIDGE-STREET-CHEVY-CHASE-MD-20815/MC9503168/30/
 meta_titleArtful Spaces | Chevy Chase Real Estate | Evers & Co. Real Estate
 meta_description4421 Ridge Street is a property offered for sale in Chevy Chase, MD, USA, presented by Evers & Co. Real Estate
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://slideshow.mris.com/slideshow/slideshow.htm?ListingKey=99076375432
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 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 05:33:02
 created2016-04-06 11:36:57
 uri/property-detail/3704/4421-ridge-street-chevy-chase-md-20815-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3704/4421-ridge-street-chevy-chase-md-20815-usa
 address_concat4421 Ridge Street Chevy Chase MD 20815 USA
 google_maps_query_string4421+Ridge+Street++Chevy+Chase+MD+20815+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,200,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty4
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2016-04-06
 overridden_brokerage_nameEvers & Co. Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id81
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2379523
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameEvers & Co. Real Estate
 broker_of_record_name
 short_nameEvers & Co. Real Estate
 usernameEversCoRealEstateCC
 password440e06f17502b0b97a9e4aa2f069e898691a3b4c
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionEvers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Chevy Chase, MD, and <a href="../../../brokerage-detail/80/Evers-&-Co.-Real-Estate">Washington, D.C</a>, USA., We are 100+ salespeople who offer our clients a level of service that is unmatched in today’s real estate marketplace, and we deliver this extraordinary service with courtesy and integrity to everyone involved in each transaction. We are enthusiastic about the neighborhoods where we live and work, from Chevy Chase to Capitol Hill, from Dupont Circle to Arlington, and everywhere in between. The highly visible storefront offices of Evers & Co. in Downtown Washington, Friendship Heights in Upper Northwest, downtown Bethesda-Chevy Chase and in Bluemont in the Virginia Wine Country are bustling with the entrepreneurial energy of agents who have in-depth knowledge of local history, architecture and construction techniques as well as expert skills in marketing and negotiating, all of which adds value to our service and your investment. This spectrum of knowledge and our commitment to serving our clientele and fellow real estate associates with the highest level of integrity has made us the premier independent brokerage in the Metropolitan Washington area. Donna Evers and the agents of Evers & Co. invite you to join our growing community of buyers and sellers, who have been the source of 90% of our business for the past thirty years.
 communitiesBethesda Chevy Chase Village Town of Chevy Chase Somerset Edgemoor Kenwood Kenwood Park Burning Tree Avenel Silver Spring
 websitehttp://www.eversco.com/
 address7032 Wisconsin Avenue
 address_2
 cityChevy Chase
 stateMD
 full_stateMaryland
 countryUSA
 marketChevy Chase
 market_2
 postal_code20815
 phoneOffice: (301) 656-1800
 phone_2Cell: (202) 255-5009
 phone_3
 wide_contact_image(false)
 contact_nameDonna Evers
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident & Founder
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename81.jpg
 logo_filename81.jpg
 contact_image_filename81.jpg
 all_properties_link_image_filename81.JPG
 all_properties_linkhttp://eversco.idxre.com/featured/40484?CFID=10711248&CFTOKEN=99152164
 video_embed_code
 contact_video_embed_code
 meta_titleChevy Chase Real Estate | Evers & Co. Real Estate | Leverage Global Partners
 meta_descriptionEvers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Bethesda, Chevy Chase Village, Town of Chevy Chase, Somerset, Edgemoor, Kenwood, Kenwood Park, Burning Tree, Avenel, and Silver Spring, MD.
 meta_keywordsChevy Chase Real Estate, Evers & Co. Real Estate, Leverage Global Partners, Bethesda real estate, Chevy Chase Village real estate, Town of Chevy Chase real estate, Somerset real estate, Edgemoor real estate, Kenwood real estate, Kenwood Park real estate, Burning Tree real estate, Avenel real estate, and Silver Spring real estate, MD.
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-01-10 16:43:02
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/81/evers-co-real-estate
 website_shortwww.eversco.com
 name_with_locationEvers & Co. Real Estate
 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)
 id12970
 modelProperty
 model_id3704
 tagImage
 name36008.jpg
 typeimage/jpg
 size1341879
 uri/assets/12970.jpg
 order0
 created2016-04-07 16:36:06
 modified2016-04-07 16:36:06
 User(array)
 0(array)
 id373
 typeAgent
 brokerage_id81
 email[email protected]
 passwordb55b12a59c129a72a8f1b8e192578b4ea7cdc2a3
 recover_hash
 first_nameEric
 last_nameMurtagh
 title
 dre_num
 phone301-412-9066
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:49
 created2017-08-07 15:22:49
 notified(false)
 full_nameEric Murtagh
 uri/agent-detail/373/eric-murtagh
 profile_complete(true)
 UsersProperty(array)
 id169
 user_id373
 property_id3704
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 2(array)
 Property(array)
 id3734
 brokerage_id5
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameLovely & Detailed Remodel in South Pasadena
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(false)
 descriptionLovely and creatively remodeled home w/ a 2nd story in 2002 while preserving the 1925 integrity of the estate. Grand foyer w/ custom stairwell & impressive chandelier offers a stately entrance to this impeccable home loaded w/ an abundance of charm & character. There are impressive intricate details throughout. Adjacent to the foyer is a formal living room offering natural light by day & a cozy romantic fireplace by night. Gourmet kitchen is a chef's dream w/ center island, double ovens, stove top & opens to the family room. Luxurious master suite is located on the 2nd level w/ inspiring views of the rear gardens. Master bath offers dual sinks, soaking tub & oversized shower w/ bench. Backyard is ideal for entertaining under the grandiose pergola or simply relaxing & enjoying the vistas of the grassy area & mature trees. This a special South Pasadena home that has been lovingly maintained for the past 21 years by the current owners. Thank you for sharing in the joy of viewing this home.
 address1817 Spruce Street
 address_2
 citySouth Pasadena
 stateCA
 postal_code91030
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1780000
 price_20
 price_usd1780000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet2846
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://1817sprucestreetstreet.thepartnerstrust.com/
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial2
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1925
 virtual_tour
 video_tourhttp://www.onvedeo.com/properties/759797/embed
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num316002835
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style42
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude34.105072
 longitude-118.145790
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 00:33:02
 created2016-04-15 16:49:02
 uri/property-detail/3734/1817-spruce-street-south-pasadena-ca-91030-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3734/1817-spruce-street-south-pasadena-ca-91030-usa
 address_concat1817 Spruce Street South Pasadena CA 91030 USA
 google_maps_query_string1817+Spruce+Street++South+Pasadena+CA+91030+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,780,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty2
 bathrooms_partial_pretty2
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2016-04-15
 overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id5
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties12
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties2
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id1
 WOEID2468964
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePartners Trust Real Estate Brokerage and Acquisitions
 broker_of_record_name
 short_namePartners Trust Real Estate
 usernamePartnersTrustPas
 password5b28522e46f56278664573d82c2b0f03520519d0
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPartners Trust is the exclusive representative for Leverage Global Partners in Pasadena and La Cañada Flintridge, California, USA. At Partners Trust, we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market, presenting our clients with the most professional, successful and ethical real estate associates in the business. We represent our clients with care, confidentiality and the utmost attention to service. Pasadena is a harmonious blend of past and present. Experience the nationally-televised Rose Parade, catch an exciting football game at the Rose Bowl, get smart at Caltech, or revel in the Jet Propulsion Laboratory. The community is renowned for its charming and diverse neighborhoods whose residents honor and preserve the splendor of early California architecture. Opportunities abound to experience Pasadena’s sophisticated culture with the diversified entertainment at the Pasadena Playhouse, the Norton Simon Museum, the Huntington Library and Botanical Gardens and even by walking along the vibrant, historic district of Colorado Boulevard. Partners Trust associates are proud to represent a wide variety of historic and architecturally diverse homes, including the Craftsman-style home. We understand our clients discerning needs, and provide a high level of service and local area knowledge. Partners Trust has additional office locations in <a href="../../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/142/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Malibu</a>, and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a>
 communitiesPasadena La Canada Flintridge San Marino La Canada Flintridge
 websitehttp://www.thepartnerstrust.com
 address594 E. Colorado Boulevard
 address_2
 cityPasadena
 stateCA
 full_stateCalifornia
 countryUSA
 marketPasadena
 market_2
 postal_code91101
 phone(626) 696-4802
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameScott Brown
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-scott-brown-managing-director-partners-trust-pasadena/
 contact_big_profile_link_text
 contact_titleManaging Director
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2Nick Segal
 contact_profile_link_2http://www.leveragere.com/brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2President/Co-Founder
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename5.jpg
 logo_filename5.png
 contact_image_filename5.jpg
 all_properties_link_image_filename5.jpg
 all_properties_linkhttp://www.thepartnerstrust.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titlePasadena Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
 meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Pasadena, CA is a premier boutique Pasadena real estate brokerage and the exclusive Pasadena representative for Leverage Global Partners.
 meta_keywordspartners trust, partners trust real estate, pasadena real estate, leverage global partners, pasadena homes for sale, scott brown
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-03-18 16:08:06
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/5/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortwww.thepartnerstrust.com
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id20890
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_001_HIGHRES.jpg
 typeimage/jpeg
 size10361514
 uri/assets/20890.jpg
 order0
 created2016-04-15 16:47:48
 modified2016-04-15 16:49:02
 1(array)
 id20879
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_008_HIGHRES.jpg
 typeimage/jpeg
 size6804950
 uri/assets/20879.jpg
 order1
 created2016-04-15 16:47:42
 modified2016-04-15 16:49:02
 2(array)
 id20877
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_017_HIGHRES.jpg
 typeimage/jpeg
 size5626562
 uri/assets/20877.jpg
 order2
 created2016-04-15 16:47:39
 modified2016-04-15 16:49:02
 3(array)
 id20876
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_022_HIGHRES.jpg
 typeimage/jpeg
 size5719147
 uri/assets/20876.jpg
 order3
 created2016-04-15 16:47:38
 modified2016-04-15 16:49:02
 4(array)
 id20878
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_014_HIGHRES.jpg
 typeimage/jpeg
 size5358186
 uri/assets/20878.jpg
 order4
 created2016-04-15 16:47:40
 modified2016-04-15 16:49:02
 5(array)
 id20882
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_009_HIGHRES.jpg
 typeimage/jpeg
 size6157612
 uri/assets/20882.jpg
 order5
 created2016-04-15 16:47:46
 modified2016-04-15 16:49:02
 6(array)
 id20881
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_038_HIGHRES.jpg
 typeimage/jpeg
 size9795680
 uri/assets/20881.jpg
 order6
 created2016-04-15 16:47:44
 modified2016-04-15 16:49:02
 7(array)
 id20894
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_044_HIGHRES.jpg
 typeimage/jpeg
 size11888212
 uri/assets/20894.jpg
 order7
 created2016-04-15 16:47:50
 modified2016-04-15 16:49:02
 8(array)
 id20883
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_035_HIGHRES.jpg
 typeimage/jpeg
 size10217742
 uri/assets/20883.jpg
 order8
 created2016-04-15 16:47:47
 modified2016-04-15 16:49:02
 9(array)
 id20880
 modelProperty
 model_id3734
 tagImage
 nameegpimaging_1817Spruce_040_HIGHRES.jpg
 typeimage/jpeg
 size10614464
 uri/assets/20880.jpg
 order9
 created2016-04-15 16:47:43
 modified2016-04-15 16:49:02
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id9
 nameOffice
 additional(false)
 created2016-04-07 14:03:21
 modified2016-04-07 14:03:21
 PropertiesPropertyFeature(array)
 id4405
 property_id3734
 property_feature_id9
 1(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id4404
 property_id3734
 property_feature_id4
 Topic(empty)
 3(array)
 Property(array)
 id3711
 brokerage_id142
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id1184
 agent_2_id1185
 agent_3_id1227
 nameBeautiful Mid Century Gem
 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(true)
 detail_page(true)
 descriptionBeautiful Mid Century home built by the distinguished Forrest Theriot as his personal residence in 1954, has been featured in numerous publications. Main house offers 3 bed, 3 bath, all with direct access to outdoor space, plus guest house with kitchenette and bath. With gourmet kitchen, floor to ceiling windows, stunning custom floors by artist Russell Metzger and open floor plan creating indoor outdoor flow and tons of natural light, ideal for entertaining! With generous tranquil outdoor space featuring multiple sitting areas and a secluded, quiet salt water pool. The extensive grounds with orange, lemon and avocado trees, and beautiful walking paths. All set off the street and tucked behind a gated entrance. Located in the Wonderland School District on one of the most highly desirable streets and a short distance to the Mulholland Tennis Club. This is a must see home, a true Hollywood Mid Century gem!
 address2544 Greenvalley Road
 address_2
 cityLos Angeles
 stateCA
 postal_code90046
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2450000
 price_20
 price_usd2450000
 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_feet2200
 square_meters
 acres36
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size36
 icon_1sq-ft
 icon_2pool
 icon_3guest-house
 icon_4acreage
 icon_5views
 icon_6
 websitehttp://2544greenvalleyroad.thepartnerstrust.com/
 meta_titleBeautiful Mid Century Gem | Los Angeles Real Estate | Partners Trust Real Estate Brokerage and Acquisitions
 meta_description2544 Greenvalley Road is a property offered for sale in Los Angeles, CA, USA, presented by Partners Trust Real Estate Brokerage and Acquisitions
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1954
 virtual_tour
 video_tourhttp://www.onvedeo.com/properties/740299/embed
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num16110470
 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.117191
 longitude34.117191
 invalid_required_fields
 invalid_optional_fieldssquare_meters, hectares, virtual_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2016-04-07 10:14:23
 uri/property-detail/3711/2544-greenvalley-road-los-angeles-ca-90046-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3711/2544-greenvalley-road-los-angeles-ca-90046-usa
 address_concat2544 Greenvalley Road Los Angeles CA 90046 USA
 google_maps_query_string2544+Greenvalley+Road++Los+Angeles+CA+90046+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,450,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty3
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-04-07
 overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id142
 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_id0
 WOEID2444458
 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
 usernamePartnersTrustMalibu
 password8bf407910e1841b6dabffb27fe55be8fe9a8383e
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPartners Trust is the exclusive representative for Leverage Global Partners in Malibu, California, USA. We are dedicated to being the finest real estate brokerage in Los Angeles. At Partners Trust, our objective is to present our clients with the most professional, successful and ethical real estate associates in the business and to represent our clients with care, confidentiality and the utmost attention to service. We believe we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market. We begin with a commodity that is hard-earned and easily lost: TRUST. Without the daily demonstration and commitment to uphold principles, a company’s mission statement is simply words on a page and nothing more. Partners Trust has adopted a mission statement that each Associate and staff member must sign to in order to participate with the Company, which articulates the core philosophy and culture of the Company. The Partners Trust founders utilized their extensive experience and resources to create a Company that is both unique and beneficial for those willing to commit to the rigorous standards that have been set forth. The Company’s intention is to empower each member of its sales force each and every step of the way. Partners Trust has additional office locations in <a href="../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../brokerage-detail/5/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Pasadena</a> and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai</a>.
 communitiesMalibu
 websitehttp://www.thepartnerstrust.com/home
 address23410 Civic Center Way
 address_2Suite C1
 cityMalibu
 stateCA
 full_stateCalifornia
 countryUSA
 market
 market_2
 postal_code90265
 phoneOffice: (310) 818-5752
 phone_2Cell: (424) 235-0143
 phone_3
 wide_contact_image(false)
 contact_nameSarah Kosasky
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleFounding Partner Malibu and Manager
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename142.jpg
 logo_filename142.png
 contact_image_filename142.jpeg
 all_properties_link_image_filename142.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_titleMalibu Real Estate | Partners Trust | Leverage Global Partners
 meta_descriptionPartners Trust is the exclusive representative for Leverage Global Partners in Malibu, CA, USA.
 meta_keywords29138 Pacific Coast Highway, Partners Trust, Leverage Global Partners, Malibu real estate, california real estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-07-18 15:34:11
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/142/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortwww.thepartnerstrust.com/home
 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)
 id11156
 modelProperty
 model_id3711
 tagImage
 name36026.jpg
 typeimage/jpg
 size614012
 uri/assets/11156.jpg
 order0
 created2016-04-07 16:25:10
 modified2016-04-12 07:51:59
 1(array)
 id11162
 modelProperty
 model_id3711
 tagImage
 name36033.jpg
 typeimage/jpg
 size5981241
 uri/assets/11162.jpg
 order1
 created2016-04-07 16:25:21
 modified2016-04-12 07:51:59
 2(array)
 id11161
 modelProperty
 model_id3711
 tagImage
 name36032.jpg
 typeimage/jpg
 size5742541
 uri/assets/11161.jpg
 order2
 created2016-04-07 16:25:19
 modified2016-04-12 07:51:59
 3(array)
 id11160
 modelProperty
 model_id3711
 tagImage
 name36031.jpg
 typeimage/jpg
 size6435531
 uri/assets/11160.jpg
 order3
 created2016-04-07 16:25:17
 modified2016-04-12 07:51:59
 4(array)
 id11159
 modelProperty
 model_id3711
 tagImage
 name36030.jpg
 typeimage/jpg
 size6299187
 uri/assets/11159.jpg
 order4
 created2016-04-07 16:25:15
 modified2016-04-12 07:51:59
 5(array)
 id11155
 modelProperty
 model_id3711
 tagImage
 name36027.jpg
 typeimage/jpg
 size656497
 uri/assets/11155.jpg
 order5
 created2016-04-07 16:25:10
 modified2016-04-12 07:51:59
 6(array)
 id11157
 modelProperty
 model_id3711
 tagImage
 name36028.jpg
 typeimage/jpg
 size8025557
 uri/assets/11157.jpg
 order6
 created2016-04-07 16:25:10
 modified2016-04-12 07:51:59
 7(array)
 id11164
 modelProperty
 model_id3711
 tagImage
 name36035.jpg
 typeimage/jpg
 size9877587
 uri/assets/11164.jpg
 order7
 created2016-04-07 16:25:25
 modified2016-04-12 07:51:59
 8(array)
 id11158
 modelProperty
 model_id3711
 tagImage
 name36029.jpg
 typeimage/jpg
 size12907528
 uri/assets/11158.jpg
 order8
 created2016-04-07 16:25:12
 modified2016-04-12 07:51:59
 9(array)
 id11163
 modelProperty
 model_id3711
 tagImage
 name36034.jpg
 typeimage/jpg
 size6128168
 uri/assets/11163.jpg
 order9
 created2016-04-07 16:25:23
 modified2016-04-12 07:51:59
 User(array)
 0(array)
 id1247
 typeAgent
 brokerage_id142
 email[email protected]
 passwordd255e1da43b092d387d1974757d05a13a8be3ecf
 recover_hash
 first_nameShirley
 last_nameSherman
 title
 dre_num
 phone310.849.8834
 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_nameShirley Sherman
 uri/agent-detail/1247/shirley-sherman
 profile_complete(true)
 UsersProperty(array)
 id1074
 user_id1247
 property_id3711
 sort_order0
 1(array)
 id1248
 typeAgent
 brokerage_id142
 email[email protected]
 password9c6607511a21fbc1c19a802a8ce7a3638a01f556
 recover_hash
 first_nameBrittany
 last_nameSherman
 title
 dre_num
 phone310.804.5992
 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_nameBrittany Sherman
 uri/agent-detail/1248/brittany-sherman
 profile_complete(true)
 UsersProperty(array)
 id1076
 user_id1248
 property_id3711
 sort_order0
 2(array)
 id1270
 typeAgent
 brokerage_id142
 email[email protected]
 passwordd3194a08107ab763927efa6dc9c64c48a2168239
 recover_hash
 first_nameLloyd
 last_nameSherman
 title
 dre_num
 phone310.893.1668
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:24:02
 created2017-08-07 15:24:02
 notified(false)
 full_nameLloyd Sherman
 uri/agent-detail/1270/lloyd-sherman
 profile_complete(true)
 UsersProperty(array)
 id1098
 user_id1270
 property_id3711
 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)
 id1984
 property_id3711
 property_feature_id12
 1(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id1985
 property_id3711
 property_feature_id5
 2(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id1986
 property_id3711
 property_feature_id14
 Topic(array)
 0(array)
 id12
 nameModern Architecture
 created2016-02-25 11:25:00
 modified2016-02-25 11:33:26
 tile_nameModern Architecture
 PropertiesTopic(array)
 id15
 property_id3711
 topic_id12
- sidebar_brokerages(array)
 0(array)
 Brokerage(array)
 id48
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2513177
 timezoneUS/Hawaii
 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
 nameMauna Kea Realty
 broker_of_record_name
 short_nameMauna Kea Realty
 usernameMaunaKea
 passwordce54200a54501e1e806c9faa3211e9ae1705158c
 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
 descriptionMauna Kea Realty is the exclusive representative for Leverage Global Partners in the County of Hawaii, Hawaii, USA. Aloha from Mauna Kea Realty, the exclusive real estate brokerage company at the legendary Mauna Kea Resort. In addition to serving the needs of the property owners at Mauna Kea Resort, we also provide insight and services for the surrounding areas and resorts on the Kona-Kohala Coast. These include Kukio, Hualalai, Mauna Lani, Waikoloa, Puako, Kohala Waterfront, Kohala Ranch, Waimea and North Kohala. The principals of Mauna Kea Realty started their real estate careers over 30 years ago, when the Kona Village Resort and the Mauna Kea Beach Hotel were the only lodging north of Kailua-Kona. We have been part of the evolution of what has become one of the premier real estate markets in the world. We have participated in numerous transactions in all of the resorts and communities along the coast. We have a long-term perspective and the local knowledge that allows us to effectively serve the needs of our clients and customers. Mauna Kea Realty has assembled a select group of highly talented professionals who service all sectors of the real estate market, including oceanfront, resort, ranch, single family, condominium and vacant land properties. Our combined $2+ billion in sales on the island, years of experience and market knowledge are some of the factors that separate Mauna Kea Realty from other real estate companies on the Big Island. Please allow us the opportunity to demonstrate to you our professional commitment to finding the right place, at the right price for you and your family. Mahalo, Bob Chancer & Steve Hurwitz
 communitieskona kohala hamakua Huala
 websitehttp://www.maunakearealty.com/
 address62-100 Mauna Kea Beach Drive
 address_2
 cityKohala Coast
 stateHI
 full_stateHawaii
 countryUSA
 marketBig Island of Hawaii
 market_2
 postal_code96743
 phone(808) 882-5600
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameSteve Hurwitz
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quoteI invite you to contact me personally about Hawaii’s Big Island real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename48.jpg
 logo_filename48.jpg
 contact_image_filename48.jpg
 all_properties_link_image_filename48.jpg
 all_properties_linkhttp://maunakearealty.idxbroker.com/idx/featured
 video_embed_code
 contact_video_embed_code
 meta_titleBig Island of Hawaii Real Estate | Mauna Kea Realty | Leverage Global Partners
 meta_descriptionMauna Kea Realty is the exclusive representative for Leverage Global Partners on the Island of Hawaii, HI, USA.
 meta_keywordsMauna Kea Realty, hawaii real estate, Bob Chancer, leverage global partners, Steve Hurwitz
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-09-13 16:06:14
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/48/mauna-kea-realty
 website_shortwww.maunakearealty.com
 name_with_locationMauna Kea Realty
 Logo(array)
 id2380
 modelBrokerage
 model_id48
 tagLogo
 name48.jpg
 typeimage/jpg
 size22228
 uri/assets/2380.jpg
 order0
 created2016-03-30 11:38:55
 modified2016-03-30 11:38:55
 1(array)
 Brokerage(array)
 id242
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID(null)
 timezoneAmerica/Los_Angeles
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameMarshall Realty
 broker_of_record_name
 short_nameMarshall Realty
 username
 password
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionMarshall Realty is the exclusive representative for Leverage Global Partners in Daly City, Colma, Brisbane, South San Francisco, San Bruno, Pacifica, Millbrae, Hillsborough, Burlingame, San Mateo, Foster, Belmont, San Carlos, Halfmoon Bay and Redwood City CA, USA. 
 communitiesDaly City Colma Brisbane South San Francisco San Bruno, Pacifica Millbrae Hillsborough Burlingame San Mateo Foster Belmont San Carlos Halfmoon Bay Redwood City.
 websitehttp://www.marshallrealty.com/
 address716 Laurel Street,
 address_2#3
 citySan Carlos
 stateCA
 full_stateCalifornia
 countryUSA
 market
 market_2
 postal_code94070
 phone650-873-6844
 phone_2650-291-9775
 phone_3
 wide_contact_image(false)
 contact_nameAnne Oliva
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBroker | Owner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone650-291-9775
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2650-867-2709
 contact_website
 contact_name_2Bob Marshall
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2Owner
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename
 logo_filename
 contact_image_filename
 all_properties_link_image_filename
 all_properties_linkhttp://www.marshallrealty.com/marshall-listings.php
 video_embed_code
 contact_video_embed_code
 meta_title
 meta_description
 meta_keywords
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(false)
 created2016-04-18 10:18:58
 modified2016-04-18 10:21:31
 dre_num012345
 uri/brokerage-detail/242/marshall-realty
 website_shortwww.marshallrealty.com
 name_with_locationMarshall Realty
 Logo(array)
 id20976
 modelBrokerage
 model_id242
 tagLogo
 namecoming soon logo.png
 typeimage/png
 size8726
 uri/assets/20976.png
 order0
 created2016-04-18 10:15:22
 modified2016-04-18 10:21:31
 2(array)
 Brokerage(array)
 id206
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2486435
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameSpecial Properties
 broker_of_record_name
 short_nameSpecial Properties
 usernameSpecialProperties
 password80bff9ecdfafd4cb525f795d439c9f6d73b691dd
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionSpecial Properties is the exclusive representative for Leverage Global Partners in Allendale, Alpine, Cliffside Park, Cresskill, Demarest, Edgewater, Englewood, Englewood Cliffs, Fort Lee, Franklin Lakes, Ho Ho Kus, Mahwah, Oakland, Old Tappan, Ramsey, Ridgewood, Saddle River, Tenafly, Upper Saddle River, Woodcliff Lake, Wyckoff, NJ USA. Special Properties, Division of Brook Hollow Group, Inc. Realtors is a Real Estate brokerage firm located in Saddle River, NJ, serving New Jersey and New York. Established in 1992, we specialize in the marketing and selling of luxury properties. We market at the highest level and offer a full range of real estate services. Our Realtor Associates and our staff are highly experienced and operate at an unparalleled level. We are pleased to announce the opening of 2 new offices in Mahwah and Franklin Lakes, New Jersey. Please contact us to find out more information regarding Special Properties Real Estate Services, LLC. Our exclusive affiliation with Christie’s International Real Estate for Northwest Bergen County offers us the ability to relocate our clients anywhere in the world at the same high standard they expect in doing business with us. Our newest affiliation with Leverage Global Partners is adding to our network of affiliates who have the same high level of marketing and service standards that we do. We are very excited about this new relationship. We have exclusive affiliations with several magazine publications which are national as well as New York City/Metropolitan area based. Contact us for additional information about our extensive marketing program, our exclusive listings as well as all multiple listed properties on our website.
 communitiesSaddle River Bergen County Allendale Alpine Cliffside Park Cresskill Demarest Edgewater Englewood Englewood Cliffs Fort Lee Franklin Lakes Ho Ho Kus Mahwah Oakland Old Tappan Ramsey Ridgewood Saddle River Tenafly Upper Saddle River Woodcliff Lake Wyckoff
 websitehttp://www.specialproperties.com/
 address158 West Saddle River Road
 address_2
 citySaddle River
 stateNJ
 full_stateNew Jersey
 countryUSA
 market
 market_2
 postal_code07458
 phoneOffice: (201) 934-7111
 phone_2Cell: (201) 390-5880
 phone_3
 wide_contact_image(false)
 contact_nameVicki Gaily
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCo Owner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename206.jpg
 logo_filename206.jpg
 contact_image_filename206.jpg
 all_properties_link_image_filename206.jpg
 all_properties_linkhttp://www.specialproperties.com/sales/usa/broker-listings-dstype
 video_embed_code
 contact_video_embed_code
 meta_titleSaddle River Real Estate | Special Properties | Leverage Global Partners
 meta_descriptionSpecial Properties is the exclusive representative for Leverage Global Partners in Saddle River including all of Bergen County, NJ USA.
 meta_keywordsSpecial Properties, Saddle River real estate, Bergen County real estate, North Jersey real estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-06-18 09:41:48
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/206/special-properties
 website_shortwww.specialproperties.com
 name_with_locationSpecial Properties
 Logo(array)
 id2839
 modelBrokerage
 model_id206
 tagLogo
 name206.jpg
 typeimage/jpg
 size590314
 uri/assets/2839.jpg
 order0
 created2016-03-30 11:44:41
 modified2016-03-30 11:44:41
 3(array)
 Brokerage(array)
 id185
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties1
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2444592
 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
 nameMammoth Village Properties
 broker_of_record_name
 short_nameMammoth Village Properties
 usernameMammothVillageProperties
 passwordb431aed5e92859d92d84f03983dd4aa8931efb09
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionMammoth Village Properties is the exclusive representative for Leverage Global Partners in Mammoth and Mammoth Lakes, CA. Mammoth Village Properties, Inc. is a family owned real estate company serving the Eastern Sierra. Our team of professionals is committed to delivering our clients the highest level of personal service and professional representation. We believe our company’s true value can only be measured by the level of respect which we have earned from our clients, associates and competitors.
 communitiesMammoth Mammoth Lakes
 websitehttp://mammothvillageproperties.com/
 address6201 Minaret Road
 address_2Suite 232
 cityMammoth Lakes
 stateCA
 full_stateCalifornia
 countryUSA
 marketMammoth
 market_2
 postal_code
 phone(800) 421-7005
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameKathy & Shields Richardson
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBrokers/Owners
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Mammoth and Mammoth Lakes real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename185.jpg
 logo_filename185.jpg
 contact_image_filename185.jpg
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_titleMammoth Real Estate | Mammoth Village Properties | Leverage Global Partners
 meta_descriptionMammoth Village Properties is the exclusive representative for Leverage Global Partners in Mammoth and Mammoth Lakes, CA
 meta_keywordsMammoth Village Properties, Leverage Global Partners, Mammoth Real Estate, California Real Estate, Mammoth Lakes Real Estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-01-26 11:10:15
 modified2016-04-08 16:34:20
 dre_num012345
 uri/brokerage-detail/185/mammoth-village-properties
 website_shortmammothvillageproperties.com
 name_with_locationMammoth Village Properties
 Logo(array)
 id2758
 modelBrokerage
 model_id185
 tagLogo
 name185.jpg
 typeimage/jpg
 size803882
 uri/assets/2758.jpg
 order0
 created2016-03-30 11:43:37
 modified2016-03-30 11:43:37
- sidebar_locations(array)
 0(array)
 Location(array)
 id114
 parent_id9
 brokerage_id48
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameBIG ISLAND OF HAWAII, HI, USA
 short_nameBIG ISLAND OF HAWAII, HI, USA
 group_index
 latitude37.090240
 longitude-95.712891
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionThe Kona-Kohala Coast is a contrast between the old and the new offering unspoiled natural beauty, a pristine environment together with world class properties and amenities.
 long_descriptionThe Kona-Kohala Coast of the Big Island of Hawaii is synonymous with world class resort/residential living. Home to some of Hawaii's finest golf courses, white sand beaches, restaurants and hotels, the Kona-Kohala Coast is within close proximity to ancient valleys, waterfalls, historically significant Heiaus and two of the tallest mountains in the world; Mauna Kea and Mauna Loa. Renown for its spectacular year round climate, the Big Island has attracted some of the titans of business, technology, medicine, entertainment, science and education who call the Kona-Kohala Coast their home away from home. Once the playground of Hawaiian royalty, the Big Island remains relatively untouched and offers a lifestyle found no where else in the world.
 created2016-04-05 17:01:23
 modified2016-04-05 17:01:23
 timezonePacific/Honolulu
 population65000
 uri/locations/view/114/big-island-of-hawaii-hi-usa
 tile_nameBIG ISLAND OF HAWAII, HI, USA
 Brokerage(array)
 id48
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2513177
 timezoneUS/Hawaii
 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
 nameMauna Kea Realty
 broker_of_record_name
 short_nameMauna Kea Realty
 usernameMaunaKea
 passwordce54200a54501e1e806c9faa3211e9ae1705158c
 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
 descriptionMauna Kea Realty is the exclusive representative for Leverage Global Partners in the County of Hawaii, Hawaii, USA. Aloha from Mauna Kea Realty, the exclusive real estate brokerage company at the legendary Mauna Kea Resort. In addition to serving the needs of the property owners at Mauna Kea Resort, we also provide insight and services for the surrounding areas and resorts on the Kona-Kohala Coast. These include Kukio, Hualalai, Mauna Lani, Waikoloa, Puako, Kohala Waterfront, Kohala Ranch, Waimea and North Kohala. The principals of Mauna Kea Realty started their real estate careers over 30 years ago, when the Kona Village Resort and the Mauna Kea Beach Hotel were the only lodging north of Kailua-Kona. We have been part of the evolution of what has become one of the premier real estate markets in the world. We have participated in numerous transactions in all of the resorts and communities along the coast. We have a long-term perspective and the local knowledge that allows us to effectively serve the needs of our clients and customers. Mauna Kea Realty has assembled a select group of highly talented professionals who service all sectors of the real estate market, including oceanfront, resort, ranch, single family, condominium and vacant land properties. Our combined $2+ billion in sales on the island, years of experience and market knowledge are some of the factors that separate Mauna Kea Realty from other real estate companies on the Big Island. Please allow us the opportunity to demonstrate to you our professional commitment to finding the right place, at the right price for you and your family. Mahalo, Bob Chancer & Steve Hurwitz
 communitieskona kohala hamakua Huala
 websitehttp://www.maunakearealty.com/
 address62-100 Mauna Kea Beach Drive
 address_2
 cityKohala Coast
 stateHI
 full_stateHawaii
 countryUSA
 marketBig Island of Hawaii
 market_2
 postal_code96743
 phone(808) 882-5600
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameSteve Hurwitz
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quoteI invite you to contact me personally about Hawaii’s Big Island real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename48.jpg
 logo_filename48.jpg
 contact_image_filename48.jpg
 all_properties_link_image_filename48.jpg
 all_properties_linkhttp://maunakearealty.idxbroker.com/idx/featured
 video_embed_code
 contact_video_embed_code
 meta_titleBig Island of Hawaii Real Estate | Mauna Kea Realty | Leverage Global Partners
 meta_descriptionMauna Kea Realty is the exclusive representative for Leverage Global Partners on the Island of Hawaii, HI, USA.
 meta_keywordsMauna Kea Realty, hawaii real estate, Bob Chancer, leverage global partners, Steve Hurwitz
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-09-13 16:06:14
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/48/mauna-kea-realty
 website_shortwww.maunakearealty.com
 name_with_locationMauna Kea Realty
 Image(array)
 id3377
 modelLocation
 model_id114
 tagImage
 name48.jpg
 typeimage/jpeg
 size140881
 uri/assets/3377.jpg
 order0
 created2016-04-05 16:58:54
 modified2016-04-05 17:01:23
 1(array)
 Location(array)
 id149
 parent_id4
 brokerage_id73
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameLisbon, Portugal
 short_nameLisbon, Portugal
 group_index
 latitude38.722252
 longitude-9.139337
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 07:28:50
 modified2016-04-12 07:28:50
 timezoneEurope/Lisbon
 population530000
 uri/locations/view/149/lisbon-portugal
 tile_nameLisbon, Portugal
 Brokerage(array)
 id73
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id13
 WOEID742676
 timezoneEurope/Lisbon
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePorta da Frente
 broker_of_record_name
 short_namePorta da Frente
 usernamePortadaFrente
 password32bdc972eb960b1abb44f4c864b114df2b21e383
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionWe are excited to announce Porta da Frente as the exclusive representative for Leverage Global Partners in Lisbon, Cascais, and Aletenjo, Portugal. Porta da Frente was born in 1995 with the clear objective of specialising in the medium-high to high segments of the residential property market. Entrepreneurial development and specialisation in this area of business have allowed the widening and diversification of the range of services it offers to its clients, a service of full support to the promoter, with particular emphasis on the after-sale phase, guaranteeing maximum assistance in the selection of the property, its sale/purchase/let, design, architecture, assessment of its true commercial value, finance and fiscal and/or legal advice. Porta da Frente has a solid sales team, comprising approximately 35 individuals comprising a department of short and long-term rentals made up of qualified professionals with a clear vocation for giving dedicated attention to each and every client. Increasing demand in other markets has led to the need to create a department exclusively dedicated to the international market. Talent, dedication, attentiveness, personal service and special treatment are traits that make it stand out against all the other players in the market.
 communitieslisbon cascais aletenjo
 websitehttp://www.portadafrente.com/
 addressAvenida Marginal, 8648 B
 address_2
 cityCascais
 state
 full_state
 countryPortugal
 marketLisbon
 market_2
 postal_code
 phone(351) 214 866-560
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameRafael Ascenso
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleGeneral Manager
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename73.jpg
 logo_filename73.jpg
 contact_image_filename73.jpg
 all_properties_link_image_filename73.jpg
 all_properties_linkhttp://www.portadafrente.com/engb/properties
 video_embed_code
 contact_video_embed_code
 meta_titleLisbon Real Estate | Porta de Frente | Leverage Global Partners
 meta_descriptionPorta de Frente is the exclusive representative for Leverage Global Partners in Lisbon, Cascais, and Aletenjo, Portugal.
 meta_keywordsPorta de Frente, Lisbon, Cascais, and Aletenjo, Portugal real estate, lisbon real estate, golden triangle real estate, lisbon real estate, cascais real estate, aletenjo real estate, leverage global partners, Rafael Ascenso
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-11-26 18:16:38
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/73/porta-da-frente
 website_shortwww.portadafrente.com
 name_with_locationPorta da Frente
 Image(array)
 id20662
 modelLocation
 model_id149
 tagImage
 nameLisbon.jpg
 typeimage/jpeg
 size244371
 uri/assets/20662.jpg
 order0
 created2016-04-12 07:26:48
 modified2016-04-12 07:28:50
 2(array)
 Location(array)
 id96
 parent_id9
 brokerage_id18
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameSan Francisco, CA, USA
 short_nameSan Francisco, CA, USA
 group_index
 latitude37.774929
 longitude-122.419418
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionConsidered by millions as the Best City in America.
 long_descriptionWith San Francisco’s sweeping vistas, charming neighborhoods, beautiful beaches, world-class cultural and sports activities -- not to mention some of the best food, architecture, music and art in the U.S., it's easy to see why so many are lured to this spectacular City by the Bay. Besides being one of the most visually stunning places on earth, San Francisco has a proud history of attracting pioneers, entrepreneurs and forward thinking innovators in business, technology, government, science, the arts, food & wine, healthy living and so much more. It’s no wonder that its residents and millions of annual visitors alike consider it the Best City in America.
 created2016-04-05 11:33:25
 modified2016-04-14 13:33:16
 timezoneAmerica/Los_Angeles
 population852469
 uri/locations/view/96/san-francisco-ca-usa
 tile_nameSan Francisco, CA, USA
 Brokerage(array)
 id18
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties5
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2487956
 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
 nameVanguard Properties
 broker_of_record_name
 short_nameVanguard Properties
 usernameVanguardSF
 passworde8045814d4cc920c82b1497cdc9288d62d2c8c16
 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
 descriptionVanguard Properties is the exclusive representative for Leverage Global Partners in San Francisco, California, USA. For close to 30 years, Vanguard Properties has offered impeccable service to buyers and sellers in San Francisco. We are proud of our team of professionals, who are service-driven and passionately share in your goal to find the home that’s right for you in the manner that fits your lifestyle. COMMITMENT At Vanguard, we stake our reputation on every relationship we create. Your unique client experience will be built on the high degree of professionalism and on our commitment to delivering service tailored to your individual needs, at every point of contact. With Vanguard by your side, you can feel confident that all aspects of your development are in good hands. We are proud to have provided developers with expert service for over twenty years now, including buyer insights that come by working with discerning buyers in highly dynamic markets. But we are only as good as the service we offer to the valued clients we work with today. They demand nothing but the best. Fortunately, we're in a position to deliver. DISTINCTION Vanguard brings exceptional homes to market, consistently and with outstanding results, under the guidance of some of the most respected professionals in the business. Our founder, James Nunemacher, is within the top 1% of real estate sales in the nation, and an acknowledged expert in the market. His exacting standards set the tone for everything we do. Simply put, no one is more qualified than Vanguard. This was true when we opened for business selling residential real estate. It has never been truer today, as our services have grown to encompass every aspect of the process of developing and marketing the most sought-after homes and developments in one of the most competitive markets. SERVICE Vanguard understands what discerning buyers and sellers are looking for, and equally importantly, what they are not. As your trusted partner, we will review and advise on every aspect of your home, from floor plans to finishing touches. Our instinct for detail may result in suggestions that surprise you. MARKETING Quality homes may be timeless. Marketing, however, demands the ability to match the leading-edge of customer expectations and stay several steps ahead of your competition. Vanguard's leadership is no more obvious than in the field of marketing. We will develop fresh, innovative strategies for you, incorporating a keen sense of brand-identity and integrating the technology that drives the housing market today. Your home is much more than simply brick and mortar. It is an investment upon which you expect the highest returns. With Vanguard's marketing acumen you can be confident that your home-buying audience is appropriately targeted and your return on investment is fully realized. Vanguard Properties also has locations in the beautiful California wine country region of <a href="../../../brokerage-detail/46/Vanguard-Properties" target="_blank">Sonoma County</a>. 
 communitiesSan Francisco
 websitehttp://vanguardsf.com/
 address2501 Mission Street
 address_2
 citySan Francisco
 stateCA
 full_stateCalifornia
 countryUSA
 marketSan Francisco
 market_2
 postal_code94110
 phone(415) 321-7007
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJames Nunemacher
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-james-nunemacher-principal-vanguard-properties/
 contact_big_profile_link_text
 contact_titleCEO
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename18.jpg
 logo_filename18.jpg
 contact_image_filename18.jpg
 all_properties_link_image_filename18.jpg
 all_properties_linkhttp://vanguardsf.com/VGlistings.php
 video_embed_code
 contact_video_embed_code
 meta_titleSan Francisco Real Estate | Vanguard Properties | Leverage Global Partners
 meta_descriptionVanguard Properties is the exclusive representative for Leverage Global Partners in San Francisco, California, USA.
 meta_keywordsSan Francisco Real Estate, Leverage Global Partners, vanguard properties, james nunemacher
 login_message_counter2
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-04-01 17:26:09
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/18/vanguard-properties
 website_shortvanguardsf.com
 name_with_locationVanguard Properties
 Image(array)
 id3030
 modelLocation
 model_id96
 tagImage
 name18.jpg
 typeimage/jpeg
 size204183
 uri/assets/3030.jpg
 order0
 created2016-04-05 11:31:23
 modified2016-04-14 13:33:16
 3(array)
 Location(array)
 id105
 parent_id7
 brokerage_id80
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameWashington, D.C, USA
 short_nameWashington, D.C, USA
 group_index
 latitude38.907192
 longitude-77.036873
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-05 13:36:56
 modified2016-04-14 10:44:02
 timezoneAmerica/New_York
 population660000
 uri/locations/view/105/washington-d-c-usa
 tile_nameWashington, D.C, USA
 Brokerage(array)
 id80
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2514815
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameEvers & Co. Real Estate
 broker_of_record_name
 short_nameEvers & Co. Real Estate
 usernameEversCoRealEstateDC
 password8c94cd238914e1ba6f88d53a1a78f02c47944eeb
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionEvers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Washington, DC and <a href="../../../brokerage-detail/81/Evers-&-Co.-Real-Estate">Chevy Chase</a>, MD, USA. We are 100+ salespeople who offer our clients a level of service that is unmatched in today’s real estate marketplace, and we deliver this extraordinary service with courtesy and integrity to everyone involved in each transaction. We are enthusiastic about the neighborhoods where we live and work, from Chevy Chase to Capitol Hill, from Dupont Circle to Arlington, and everywhere in between. The highly visible storefront offices of Evers & Co. in Downtown Washington, Friendship Heights in Upper Northwest, downtown Bethesda-Chevy Chase and in Bluemont in the Virginia Wine Country are bustling with the entrepreneurial energy of agents who have in-depth knowledge of local history, architecture and construction techniques as well as expert skills in marketing and negotiating, all of which adds value to our service and your investment. This spectrum of knowledge and our commitment to serving our clientele and fellow real estate associates with the highest level of integrity has made us the premier independent brokerage in the Metropolitan Washington area. Donna Evers and the agents of Evers & Co. invite you to join our growing community of buyers and sellers, who have been the source of 90% of our business for the past thirty years.
 communitieswashington, DC chevy chase dupont kalorama georgetown american university park cleveland park Palisades logan circle capitol hill forest hills
 websitehttp://www.eversco.com/
 address4400 Jenifer Street, NW
 address_2
 cityWashington, D.C
 state
 full_state
 countryUSA
 marketWashington, D.C
 market_2
 postal_code20015
 phoneOffice: (202) 364-1700
 phone_2Cell: (202) 255-5009
 phone_3
 wide_contact_image(false)
 contact_nameDonna Evers
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident & Founder
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename80.jpg
 logo_filename80.jpg
 contact_image_filename80.jpg
 all_properties_link_image_filename80.JPG
 all_properties_linkhttp://eversco.idxre.com/featured/40484?CFID=10711248&CFTOKEN=99152164
 video_embed_code
 contact_video_embed_code
 meta_titleWashington DC Real Estate | Evers & Co. Real Estate | Leverage Global Partners
 meta_descriptionEvers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Washington, DC , Chevy Chase, Dupont, Kalorama, Georgetown, American University Park, Cleveland Park, Palisades, Logan Circle, Capitol Hill, and Forest Hills.
 meta_keywordsWashington DC Real Estate, Evers & Co. Real Estate, Leverage Global Partners, chevy chase real estate, dupont real estate, kalorama real estate, georgetown, american university park real estate, cleveland park real estate, Palisades real estate, logan circle real estate, capitol hill real estate, forest hills real estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-01-10 16:30:33
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/80/evers-co-real-estate
 website_shortwww.eversco.com
 name_with_locationEvers & Co. Real Estate
 Image(array)
 id3039
 modelLocation
 model_id105
 tagImage
 nameDC.jpg
 typeimage/jpeg
 size109939
 uri/assets/3039.jpg
 order0
 created2016-04-05 13:36:23
 modified2016-04-14 10:44:02
- location_properties(empty)
- main_article(empty)
- brokerage(array)
 Brokerage(array)
 id182
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties4
 membership_luxury_feed_properties4
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2410661
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts[email protected]
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameExecutive Real Estate
 broker_of_record_name
 short_nameExecutive Real Estate
 usernameExecutiveRealEstate
 password4c47b873ee3bf155444a6c1e0983923d63eb4293
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionExecutive Real Estate is the exclusive representative for Leverage Global Partners in Hartford, Middlesex and Tolland counties, CT, USA. My Story, I began in real estate at the ripe age of 18. Right out of high school I worked at Century 21 in Glastonbury Village Green and felt as if I was this little girl in the big world of Real Estate. My first few months were hard, I felt as if I was spinning my wheels and having to borrow gas money to get to my appointments. My current office manager, Armand, who was my broker at that time, offered a trip to New York all-expenses paid which could be won through a contest. Being 18 I had never been to NYC so I thought it would be amazing to win the contest and the trip; 10 transactions in one month. I plotted a plan to do just that. Once again I borrowed money to get gas and food and went on a mission. I sought out and then knocked on doors of ‘for sale by owners’ and ‘expireds’. I was so wide eyed and eager to win that trip I informed every potential seller and buyer that I needed to not only list, but sell their home immediately to win the trip. I won the trip. I found that setting a GOAL had helped me achieve what I truly wanted. I then spent every month setting and obtaining those goals. At the age of 21 I was driving a Lincoln; I had a nicer car than most agents around me at the time. I was also pregnant with my first child. This seemed scary as I was making great sales, so my new goal was to stock up on my finances and secure a future for my baby boy. I knew the in and outs of Real Estate and only in a few short years living as an agent, I had superseded all my goals which happen to make me the Century 21 1997 Top 10 Producers in the state of CT. I was the Century 21 Top Producer. I calculated my career path and got extremely large, so large that my business model outgrew me. I had arranged a team of Agents for fielding my buyer calls and I maintained my personal referrals. The agents started to flock around me and after years of flourishing in this fashion my team came to me and asked if I would open my own firm. My team, the founding agents of Executive Real Estate, formed with me a new business entity. We immediately became one of the largest independent offices in our local Realtor market. We were all scared about venturing off on our own. But the simple truth is that if your Customer Service is held to the highest standard then growth is unstoppable. Our clients then began to grow our business; the personal referrals to all of our executive agents had flourished. Today, we are over 50 agents strong and always growing!
 communitiesGlastonbury Hartford County Middlesex County Tolland County
 websitehttp://www.executiverealestatellc.com/
 address17 School Street
 address_2
 cityGlastonbury
 stateCT
 full_stateConnecticut
 countryUSA
 market
 market_2
 postal_code06033
 phoneCell: (860) 916-6048
 phone_2Office: (860) 633-8800
 phone_3
 wide_contact_image(false)
 contact_nameAmy Rio
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner/Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename182.jpg
 logo_filename182.jpg
 contact_image_filename182.png
 all_properties_link_image_filename182.jpg
 all_properties_link
 video_embed_code<iframe width="560" height="315" src="https://www.youtube.com/embed/mlI0ztD_zGo?controls=0&showinfo=0" frameborder="0" allowfullscreen></iframe>
 contact_video_embed_code
 meta_titleGlastonbury Real Estate⎜Executive Real Estate⎜Leverage Global Partners
 meta_descriptionExecutive Real Estate is the exclusive representative for Leverage Global Partners in Hartford, Middlesex and Tolland counties, CT, USA.
 meta_keywordsExecutive Real Estate, Leverage Global Partners, Hartford Real Estate, Middlesex Real Estate, Tolland Real Estate, Connecticut Real Estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-01-15 11:28:32
 modified2022-01-13 09:51:32
 dre_num012345
 uri/brokerage-detail/182/executive-real-estate
 website_shortwww.executiverealestatellc.com
 name_with_locationExecutive Real Estate - Glastonbury, CT, USA
 AccountExecutive(array)
 id235
 typeAccountExecutive
 brokerage_id0
 email[email protected]
 passworde5cc5a96287695cf8b7cace1463b1699895dcf92
 recover_hash
 first_nameAlec
 last_nameMegerdichian
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2020-12-23 09:21:42
 created2016-04-14 15:40:35
 notified(false)
 full_nameAlec Megerdichian
 uri/agent-detail/235/alec-megerdichian
 profile_complete(true)
 Logo(array)
 id23093
 modelBrokerage
 model_id182
 tagLogo
 name142748.png
 typeimage/png
 size9564
 uri/assets/23093.png
 order0
 created2020-12-22 13:15:11
 modified2022-01-13 09:51:32
 MainImage(array)
 id2748
 modelBrokerage
 model_id182
 tagMainImage
 name182.jpg
 typeimage/jpg
 size2694844
 uri/assets/2748.jpg
 order0
 created2016-03-30 11:43:27
 modified2022-01-13 09:51:32
 ContactImage(array)
 id2750
 modelBrokerage
 model_id182
 tagContactImage
 name182.png
 typeimage/png
 size10018020
 uri/assets/2750.png
 order0
 created2016-03-30 11:43:29
 modified2022-01-13 09:51:32
 ContactImage2(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 ContactImage3(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 BrokerOfRecordLogo(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 MainArticle(array)
 id(null)
 model(null)
 model_id(null)
 archived(null)
 medium_featured(null)
 large_featured(null)
 title(null)
 author(null)
 date(null)
 lead_in(null)
 body(null)
 vimeo_id(null)
 created(null)
 modified(null)
 FeaturedImage(empty)
 Location(array)
 0(array)
 id170
 parent_id7
 brokerage_id182
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameGlastonbury, CT, USA
 short_nameGlastonbury, CT, USA
 group_index
 latitude41.686180
 longitude-72.545074
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 18:39:55
 modified2016-04-12 18:42:40
 timezoneAmerica/New_York
 population0
 uri/locations/view/170/glastonbury-ct-usa
 tile_nameGlastonbury, CT, USA
 User(array)
 0(array)
 id165
 typeBrokerageAdmin
 brokerage_id182
 email[email protected]
 password4c47b873ee3bf155444a6c1e0983923d63eb4293
 recover_hash
 first_nameAmy
 last_nameRio
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2025-09-05 10:57:27
 created2016-04-08 16:34:20
 notified(true)
 full_nameAmy Rio
 uri/agent-detail/165/amy-rio
 profile_complete(true)
 1(array)
 id329
 typeAgent
 brokerage_id182
 email[email protected]
 password3a3eae3bdb21b4c8829f103750df4c47efcbe19e
 recover_hash
 first_nameDawn
 last_nameNostin
 title
 dre_num
 phone860.202.6145
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2025-09-05 10:58:37
 created2017-08-07 15:22:47
 notified(false)
 full_nameDawn Nostin
 uri/agent-detail/329/dawn-nostin
 profile_complete(true)
 2(array)
 id922
 typeAgent
 brokerage_id182
 email[email protected]
 password56417e7002cca8c57daf99c82aae9f5e63f38d33
 recover_hash
 first_nameSuzy
 last_nameCouture
 title
 dre_num
 phone860-944-4370
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2025-09-05 10:58:09
 created2017-08-07 15:23:44
 notified(false)
 full_nameSuzy Couture
 uri/agent-detail/922/suzy-couture
 profile_complete(true)
- location(array)
 Location(array)
 id170
 parent_id7
 brokerage_id182
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameGlastonbury, CT, USA
 short_nameGlastonbury, CT, USA
 group_index
 latitude41.686180
 longitude-72.545074
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 18:39:55
 modified2016-04-12 18:42:40
 timezoneAmerica/New_York
 population0
 uri/locations/view/170/glastonbury-ct-usa
 tile_nameGlastonbury, CT, USA
 Image(array)
 id20736
 modelLocation
 model_id170
 tagImage
 nameScreen Shot 2016-04-12 at 6.40.19 PM.png
 typeimage/png
 size1124721
 uri/assets/20736.png
 order0
 created2016-04-12 18:42:37
 modified2016-04-12 18:42:40
- membership_subscription_temp_allowed_login(null)
- newsletter_member_types(array)
 Leverage Member: AgentLeverage Member: Agent
 Leverage Member: Broker or ManagementLeverage Member: Broker or Management
 Non-MemberNon-Member
- $request->data(empty)
- $this->validationErrors(array)
 Subscription(empty)
 Location(empty)
 Image(empty)
 Brokerage(empty)
 AccountExecutive(empty)
 Logo(empty)
 MainImage(empty)
 ContactImage(empty)
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 Property(empty)
 User(empty)
 PropertyFeature(empty)
 SecondaryPropertyCategory(empty)
 Topic(empty)
 FeaturedImage(empty)
 Article(empty)
 ParentBrokerage(empty)
 ParentLocation(empty)
 ArticlesBrokerage(empty)
 ArticlesLocation(empty)
 ArticlesProperty(empty)
 ArticlesTopic(empty)
 PrimaryPropertyCategory(empty)
 StripeSubscription(empty)
 GlobalReachReport(empty)
 UsersProperty(empty)
 PropertiesSecondaryPropertyCategory(empty)
 PropertiesPropertyFeature(empty)
 PropertiesTopic(empty)
- Loaded Helpers(array)
 0Permission
 1Geography
 2Number
 3SimpleGraph
 4DebugTimer
 5Toolbar
 6Session
 7Text
 8Flash
 9HtmlToolbar
 10Html
 11Form
====

Environment

App Constants

Constant	Value
CONFIG	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Config/
GOOGLE_MAPS_PUBLIC_API_KEY	AIzaSyCD2zmgSzOEN-7tNHYSmGXL0MyWtMlHND4
GOOGLE_MAPS_PRIVATE_API_KEY	AIzaSyCIXpqYsaZp4_suK7IWeqUTIEbS_hMkoXs
RECAPTCHA_V2_SITE_KEY	6Lfs_EoUAAAAAKe8XSwR8p7AEMOLWB96veSLjRDv
RECAPTCHA_V2_SECRET_KEY	6Lfs_EoUAAAAAIo2vzNYILL-YwBaRxvTpjuemmKZ
PROTOCOL	https://
WEB_ENV	staging2
WEB_BASE_URL	https://staging2.leveragere.com
PROP_EMAIL_RECIPIENT	[email protected]
STRIPE_ISSUES_EMAIL_RECIPIENT	[email protected]
STRIPE_ENV	test
STRIPE_PK	pk_test_fIc7eHMfMVAhnrld2Vk2DDpG
STRIPE_SK	sk_test_D4NvWbVo5Fe04IJM0AItMKIR
SHELL_LAUNCHER	/opt/plesk/php/7.4/bin/php /var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Console/cake.php

CakePHP Constants

Constant	Value
APP	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/
APP_DIR	app
APPLIBS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Lib/
CACHE	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/tmp/cache/
CAKE	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib
CORE_PATH	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib/
CAKE_VERSION	2.10.19
CSS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://staging2.leveragere.com
IMAGES	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/img/
IMAGES_URL	img/
JS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/js/
JS_URL	js/
LOGS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/tmp/logs/
ROOT	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs
TESTS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Test/
TMP	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/tmp/
VENDORS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	7.4.33
User	leveragere
Home	/var/www/vhosts/leveragere.com
Script Name	/index.php
Request Uri	/locations/view/170/glastonbury-ct-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/locations/view/170/glastonbury-ct-usa
Remote Port	20967
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.114
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	a09df223df965c4f-CMH
Http Accept Encoding	gzip, br
Http Cookie	CAKEPHP=e2b0h79qke6icvjvru586r4got
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	aio8j0qFdFKg_eEneUt6wQAAAIA
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	aio8j0qFdFKg_eEneUt6wQAAAIA
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781152911.9901
Request Time	1781152911

====

Include
+
Included Files

Include Paths
- 0/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib
- 2/opt/plesk/php/7.4/share/pear
- 3-> /var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/AuthComponent.php
  1CORE/Controller/Component/SessionComponent.php
  2CORE/Controller/Component/CookieComponent.php
  3CORE/Controller/Component/RequestHandlerComponent.php
  4CORE/Controller/Component/Auth/FormAuthenticate.php
  5CORE/Controller/Component/Auth/BaseAuthenticate.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/CakeObject.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/RedirectRoute.php
  7CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/CakeText.php
  5CORE/Utility/ClassRegistry.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Component(array)
  0APP/Controller/Component/PermissionComponent.php
  1APP/Controller/Component/ExploreComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/LocationsController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/Subscription.php
  1APP/Model/AppModel.php
  2APP/Model/Location.php
  3APP/Model/Asset.php
  4APP/Model/Brokerage.php
  5APP/Model/User.php
  6APP/Model/Article.php
  7APP/Model/Property.php
  8APP/Model/PropertyFeature.php
  9APP/Model/PropertyCategory.php
  10APP/Model/Topic.php
  11APP/Model/StripeSubscription.php
  12APP/Model/GlobalReachReport.php
  Other(array)
  0APP/webroot/index.php
  1APP/Vendor/permissions.php
- plugins(array)
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
====

Glastonbury, CT, USA

Location Represented By

Related Articles

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 26 ms Total Queries: 19 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 26 ms
Total Queries: 19 queries