Locations / Cleveland, OH, USA

Cleveland, OH, USA

Northeast Ohio offers a lifestyle for every person with an affordability that enriches all. We enjoy the four seasons, the Cuyahoga Metro Park’s Emerald Necklace, life along the shores of Lake Erie and its arteries of rivers and canals that meander through Cleveland and the Akron/Canton suburbs. Great entertainment abounds with the arts, sporting, gaming, Rock and Roll and Football Halls of Fame, as well as other museums and sites of interest. We are home to world renowned health care & hospitals. Our market features housing stock from the early 1900’s to present and revitalized downtown living.

Location Represented By

License #: 012345

11:51pm local time
390 thousand population

Partner Search

Find partners with a map-based search

Related Locations

Related Partners

Recent Property Listings

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

Array
(
)

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

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

Query Explain:

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

====

Timer

Memory

Peak Memory Use 12.55 MB

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

Timers

Total Request Time: 196 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	25.93
Event: Controller.initialize	3.78
Event: Controller.startup	1.10
Controller action	46.28
Event: Controller.beforeRender	10.05
» Processing toolbar data	9.97
Rendering View	83.00
» Event: View.beforeRender	0.25
» Rendering APP/View/Locations/view.ctp	2.60
» » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.14
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.18
» » Rendering APP/View/Elements/sidebar/brokerage_list.ctp	0.16
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.25
» » » Rendering APP/View/Elements/static_property_price.ctp	0.38
» » » Rendering APP/View/Elements/static_property_price.ctp #2	0.16
» » » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.13
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.19
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	79.47
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)
 id3723
 brokerage_id157
 created_by_user_id0
 order2
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameRenovated 2 story expanded ranch
 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)
 descriptionRenovated 2 story expanded ranch features a chefs kit w/adjoining family room, spacious living room & dining room with a wall of windows and French doors that lead to the incredible backyard setting that is wonderful to bbq, dine and entertain. There is a first floor luxurious master bedroom suite while the second floor includes three additional bedrooms plus an en-suite. The walk-out lower level boasts a recreation room, office, exercise room, art room, two full baths and loads of storage. Close-by to the #1 Deerfield elementary school, children are bused to the highly rated Millburn Middle School and Millburn High School.
 address90 Troy Drive
 address_2
 cityShort Hills
 stateNJ
 postal_code07078
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1595000
 price_20
 price_usd1595000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms5
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitewww.90TroyDr.com
 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
 latitude40.754322
 longitude-74.312920
 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-13 07:00:07
 uri/property-detail/3723/90-troy-drive-short-hills-nj-07078-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3723/90-troy-drive-short-hills-nj-07078-usa
 address_concat90 Troy Drive Short Hills NJ 07078 USA
 google_maps_query_string90+Troy+Drive++Short+Hills+NJ+07078+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,595,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty5
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2016-04-13
 overridden_brokerage_nameTowne Realty Group
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id157
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2493140
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameTowne Realty Group
 broker_of_record_name
 short_nameTowne Realty Group
 usernameTowneRealtyGroup
 passworda4249a6dfad6cc2af05068e244f79544fefc464e
 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
 descriptionTowne Realty Group is the exclusive representative for Leverage Global Partners in Short Hills, Essex County, Morris County, Union County, New Jersey, USA. Towne Realty Group, LLC, is a real estate boutique in Short Hills, NJ, with unparalleled real estate market knowledge and experience. Our agents are tenacious advocates for your interests and we are a paperless company – all of our business is conducted electronically in the cloud. Our team of 25 professionals are all full-time pros, unmatched in the industry for their attention to detail. Our powerful marketing and advertising programs across dozens of websites and social media platforms, will help sell your home, and our deep roots in our local communities will serve you well as a buyer. We have transacted over $1 Billion in sales since we opened our doors in 2006. Our agents know the local markets in New Jersey - if it happens in Millburn, Short Hills, Maplewood, South Orange, West Orange, Summit, Livingston, Chatham, Madison, Florham Park, New Providence, Springfield, Montclair, Westfield, Cranford or surrounding towns in Essex, Morris, and Union, our agents know about it. We welcome the opportunity to assist you with any questions in our local real estate market.
 communitiesShort Hills Essex County Morris County Union County Somerset County
 websitehttp://www.trghome.com/
 address511 Millburn Avenue
 address_2
 cityShort Hills
 stateNJ
 full_stateNew Jersey
 countryUSA
 market
 market_2
 postal_code
 phoneKaren Mobile: (201) 417-1600
 phone_2Daniel Mobile: (973) 865-4144
 phone_3Barbara's Mobile: (908) 347-6945
 wide_contact_image(false)
 contact_nameKaren Bigos, Barbara Birkitt, Daniel Cannizzo
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-karen-biggs-daniel-cannizzo-towne-realty-group/
 contact_big_profile_link_textMeet Karen Bigos, Barbara Birkitt, Daniel Cannizzo
 contact_titleOwner/Managing Partner, Sales Manager/Broker of Record, Owner/Managing Partner
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Short Hills & Summit, NJ 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_filename157.jpg
 logo_filename157.JPG
 contact_image_filename157.jpg
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_titleShort Hills Real Estate | Towne Realty Group | Leverage Global Partners
 meta_description Towne Realty Group is the exclusive representative for Leverage Global Partners in Short Hills, New Jersey, USA.
 meta_keywordsTowne Realty Group, Short Hills Realty Group, Karen Bigos, Short Hills Real Estate, Essex County Real Estate, Morris County Real Estate, Union County Real Estate, Somerset County Real Estate, New 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)
 created2014-09-02 15:10:33
 modified2021-07-18 10:38:47
 dre_num012345
 uri/brokerage-detail/157/towne-realty-group
 website_shortwww.trghome.com
 name_with_locationTowne Realty Group
 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)
 id20756
 modelProperty
 model_id3723
 tagImage
 namefront.jpg
 typeimage/jpeg
 size2812943
 uri/assets/20756.jpg
 order0
 created2016-04-13 06:58:25
 modified2016-04-13 07:00:07
 1(array)
 id20761
 modelProperty
 model_id3723
 tagImage
 namelv.jpg
 typeimage/jpeg
 size1636475
 uri/assets/20761.jpg
 order1
 created2016-04-13 06:59:08
 modified2016-04-13 07:00:07
 2(array)
 id20763
 modelProperty
 model_id3723
 tagImage
 namekitchen-2.jpg
 typeimage/jpeg
 size1630226
 uri/assets/20763.jpg
 order2
 created2016-04-13 06:59:10
 modified2016-04-13 07:00:07
 3(array)
 id20764
 modelProperty
 model_id3723
 tagImage
 namedining.jpg
 typeimage/jpeg
 size1980966
 uri/assets/20764.jpg
 order3
 created2016-04-13 06:59:10
 modified2016-04-13 07:00:07
 4(array)
 id20765
 modelProperty
 model_id3723
 tagImage
 namefam.jpg
 typeimage/jpeg
 size1760572
 uri/assets/20765.jpg
 order4
 created2016-04-13 06:59:11
 modified2016-04-13 07:00:07
 5(array)
 id20760
 modelProperty
 model_id3723
 tagImage
 namemaster-2.jpg
 typeimage/jpeg
 size1430080
 uri/assets/20760.jpg
 order5
 created2016-04-13 06:59:08
 modified2016-04-13 07:00:07
 6(array)
 id20762
 modelProperty
 model_id3723
 tagImage
 namemaster-bath.jpg
 typeimage/jpeg
 size2001914
 uri/assets/20762.jpg
 order6
 created2016-04-13 06:59:09
 modified2016-04-13 07:00:07
 7(array)
 id20759
 modelProperty
 model_id3723
 tagImage
 nameback-2.jpg
 typeimage/jpeg
 size2933204
 uri/assets/20759.jpg
 order7
 created2016-04-13 06:58:28
 modified2016-04-13 07:00:07
 8(array)
 id20757
 modelProperty
 model_id3723
 tagImage
 nameback-5.jpg
 typeimage/jpeg
 size3078942
 uri/assets/20757.jpg
 order8
 created2016-04-13 06:58:26
 modified2016-04-13 07:00:07
 9(array)
 id20758
 modelProperty
 model_id3723
 tagImage
 nameback.jpg
 typeimage/jpeg
 size3265128
 uri/assets/20758.jpg
 order9
 created2016-04-13 06:58:27
 modified2016-04-13 07:00:07
 User(array)
 0(array)
 id1273
 typeAgent
 brokerage_id157
 email[email protected]
 passworde12a1c18f923d356c3701925712f3ec758f9f791
 recover_hash
 first_nameDonna
 last_nameShaw
 title
 dre_num
 phone973-879-3128
 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_nameDonna Shaw
 uri/agent-detail/1273/donna-shaw
 profile_complete(true)
 UsersProperty(array)
 id1101
 user_id1273
 property_id3723
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 1(array)
 Property(array)
 id3707
 brokerage_id81
 created_by_user_id0
 order7
 multi_unit(false)
 agent_1_id625
 agent_2_id0
 agent_3_id0
 nameKenwood Classic
 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)
 descriptionGreat possibilities in this classic colonial with front and back staircase, 4 bedrooms and screened porch, breezeway and one car garage.
 address5811 Brookside Drive
 address_2
 cityChevy Chase
 stateMD
 postal_code20815
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1249000
 price_20
 price_usd1249000
 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
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://www.eversco.com/agent-detail/Patricia-Lore/48969/
 meta_titleKenwood Classic | Chevy Chase Real Estate | Evers & Co. Real Estate
 meta_description5811 Brookside Drive 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=300028152280
 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:03
 created2016-04-06 13:27:58
 uri/property-detail/3707/5811-brookside-drive-chevy-chase-md-20815-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3707/5811-brookside-drive-chevy-chase-md-20815-usa
 address_concat5811 Brookside Drive Chevy Chase MD 20815 USA
 google_maps_query_string5811+Brookside+Drive++Chevy+Chase+MD+20815+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,249,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty3
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 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)
 id20564
 modelProperty
 model_id3707
 tagImage
 name36011.jpg
 typeimage/jpg
 size1915677
 uri/assets/20564.jpg
 order2894
 created2016-04-07 17:34:09
 modified2016-04-07 17:34:09
 User(array)
 0(array)
 id822
 typeAgent
 brokerage_id81
 email[email protected]
 passworde33b7374dd87e26f3a702e17e69c93ff56065efb
 recover_hash
 first_namePat
 last_nameLore
 title
 dre_num
 phone301-908-1242
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:24
 created2017-08-07 15:23:24
 notified(false)
 full_namePat Lore
 uri/agent-detail/822/pat-lore
 profile_complete(true)
 UsersProperty(array)
 id565
 user_id822
 property_id3707
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 2(array)
 Property(array)
 id3706
 brokerage_id81
 created_by_user_id0
 order6
 multi_unit(false)
 agent_1_id150
 agent_2_id0
 agent_3_id0
 nameTudor Accents
 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)
 descriptionAs good as it gets! This picturesque block of Oakridge Avenue is spectacular! It's peaceful, scenic & so convenient with its access to downtown Bethesda (via Thornapple Path!) These long-time, caring owners have taken wonderful care of this classic Chevy Chase residence. The dramatic family room addition with due east exposure & soaring ceilings is amazing! *Loft retreat with bedroom & office*
 address6907 Oakridge Avenue
 address_2
 cityChevy Chase
 stateMD
 postal_code20815
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1395000
 price_20
 price_usd1395000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://www.eversco.com/homes-for-sale-details/6907-OAKRIDGE-AVENUE-CHEVY-CHASE-MD-20815/MC9581947/30/
 meta_titleTudor Accents | Chevy Chase Real Estate | Evers & Co. Real Estate
 meta_description6907 Oakridge Avenue is a property offered for sale in Chevy Chase, MD, USA, presented by Evers & Co. Real Estate
 meta_keywords
 bathrooms_partial2
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://slideshow.mris.com/slideshow/slideshow.htm?ListingKey=300027450487
 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:03
 created2016-04-06 12:20:13
 uri/property-detail/3706/6907-oakridge-avenue-chevy-chase-md-20815-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3706/6907-oakridge-avenue-chevy-chase-md-20815-usa
 address_concat6907 Oakridge Avenue Chevy Chase MD 20815 USA
 google_maps_query_string6907+Oakridge+Avenue++Chevy+Chase+MD+20815+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,395,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-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)
 id20563
 modelProperty
 model_id3706
 tagImage
 name36010.jpg
 typeimage/jpg
 size5169715
 uri/assets/20563.jpg
 order2894
 created2016-04-07 17:34:08
 modified2016-04-07 17:34:08
 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)
 id175
 user_id373
 property_id3706
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 3(array)
 Property(array)
 id3741
 brokerage_id3
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameModern, Updated Ranch Home with Mesmerizing Ocean Views
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(false)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(false)
 descriptionPalisades modern ranch with mesmerizing ocean views by renowned architect, David Kellen. A special updated home, perched on a promontory above the street on a 16,000 ft. lot with abundant natural light and bright, open spaces. Enter into an open living, dining, and music room, which leads seamlessly to the large grassy backyard area with pool. Sleek and simple modern kitchen with breakfast nook. Two bedroom suites (including a junior master) and a den downstairs, all opening to the lovely outdoors. Upstairs is a breathtaking master suite with open loft style walls with oversized windows and sweeping ocean, city and canyon views. Additional bedroom suite upstairs.
 address545 Catalonia Avenue
 address_2
 cityPacific Palisades
 stateCA
 postal_code90272
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2995000
 price_20
 price_usd2995000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms5
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://545cataloniaavenue.thepartnerstrust.com/
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1955
 virtual_tour
 video_tourhttp://www.onvedeo.com/properties/755499/embed
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num16112996
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style33
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude34.047157
 longitude34.047157
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2024-10-24 08:39:37
 created2016-04-18 09:57:58
 uri/property-detail/3741/545-catalonia-avenue-pacific-palisades-ca-90272-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3741/545-catalonia-avenue-pacific-palisades-ca-90272-usa
 address_concat545 Catalonia Avenue Pacific Palisades CA 90272 USA
 google_maps_query_string545+Catalonia+Avenue++Pacific+Palisades+CA+90272+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,995,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty5
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2016-04-18
 overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id3
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties12
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties2
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id1
 WOEID2442047
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePartners Trust Real Estate Brokerage and Acquisitions
 broker_of_record_name
 short_namePartners Trust Real Estate
 usernamePartnersTrustLA
 password165bb7b526009554e197bcf82dabaa84ae727155
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPartners Trust is the exclusive representative for Leverage Global Partners in Los Angeles, California, USA. At Partners Trust, our real estate associates are the most professional, successful and ethical in the business, representing each of our clients with care, confidentiality and the utmost attention to service. As a company, we offer our associates and clients a level of technology and communication unmatched in today’s real estate market. Los Angeles provides the ideal canvas to make your dream become a reality. We live, work, and entertain everywhere, from our beautiful beaches and the vibrant, newly revitalized downtown to the expansive mountain ranges overlooking the serene desert landscapes. With a culture that attracts celebrities, sports figures and entrepreneurs, the Southern California lifestyle is in high demand. Great representation in this real estate market is essential. Our associates proudly handle all types of homes, ranging from the architectural estate to the contemporary condominium to the historic, traditional home. Each property and client is represented with the highest quality of presentation and service, leading to unparalleled success. Partners Trust has additional office locations in <a href="../../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/5/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Pasadena</a>, <a href="../../../brokerage-detail/142/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Malibu</a>, and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a>
 communitiesLos Angeles Brentwood West Los Angeles
 websitehttp://thepartnerstrust.com
 address11726 San Vicente Blvd
 address_2Suite 350
 cityLos Angeles
 stateCA
 full_stateCalifornia
 countryUSA
 marketLos Angeles
 market_2
 postal_code90049
 phone(310) 500-1388
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameNick Segal
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/presidential-profile-partners-trust-real-estate-brokerage-aquisitions-nick-segal/
 contact_big_profile_link_text
 contact_titlePresident/Co-Founder
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename3.jpg
 logo_filename3.png
 contact_image_filename3.jpg
 all_properties_link_image_filename3.jpg
 all_properties_linkhttp://www.thepartnerstrust.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleLos Angeles Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
 meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Los Angeles, CA is a premier boutique real estate brokerage, serving home buyers and sellers in the Los Angeles real estate market.
 meta_keywordspartners trust, Partners Trust Real Estate, los angeles real estate, nick segal, leverage global partners
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-03-18 15:09:20
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/3/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortthepartnerstrust.com
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id20971
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_LoRes_(1_of_33).jpg.jpg
 typeimage/jpeg
 size449059
 uri/assets/20971.jpg
 order0
 created2016-04-18 09:57:16
 modified2024-10-24 08:39:26
 1(array)
 id20968
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_HiRes_(6_of_33).jpg.jpg
 typeimage/jpeg
 size273879
 uri/assets/20968.jpg
 order1
 created2016-04-18 09:57:16
 modified2024-10-24 08:39:26
 2(array)
 id20970
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_LoRes_(5_of_33).jpg.jpg
 typeimage/jpeg
 size360705
 uri/assets/20970.jpg
 order2
 created2016-04-18 09:57:16
 modified2024-10-24 08:39:26
 3(array)
 id20964
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_HiRes_(11_of_33).jpg.jpg
 typeimage/jpeg
 size210712
 uri/assets/20964.jpg
 order3
 created2016-04-18 09:57:15
 modified2024-10-24 08:39:26
 4(array)
 id20963
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_HiRes_(22_of_33).jpg.jpg
 typeimage/jpeg
 size155986
 uri/assets/20963.jpg
 order4
 created2016-04-18 09:57:15
 modified2024-10-24 08:39:26
 5(array)
 id20966
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_HiRes_(16_of_33).jpg.jpg
 typeimage/jpeg
 size310096
 uri/assets/20966.jpg
 order5
 created2016-04-18 09:57:15
 modified2024-10-24 08:39:26
 6(array)
 id20965
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_HiRes_(13_of_33).jpg.jpg
 typeimage/jpeg
 size291598
 uri/assets/20965.jpg
 order6
 created2016-04-18 09:57:15
 modified2024-10-24 08:39:26
 7(array)
 id20969
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_HiRes_(18_of_33).jpg.jpg
 typeimage/jpeg
 size255914
 uri/assets/20969.jpg
 order7
 created2016-04-18 09:57:16
 modified2024-10-24 08:39:26
 8(array)
 id20967
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_HiRes_(3_of_33).jpg.jpg
 typeimage/jpeg
 size301571
 uri/assets/20967.jpg
 order8
 created2016-04-18 09:57:16
 modified2024-10-24 08:39:26
 9(array)
 id20972
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_LoRes_(30_of_33).jpg.jpg
 typeimage/jpeg
 size493336
 uri/assets/20972.jpg
 order9
 created2016-04-18 09:57:16
 modified2024-10-24 08:39:26
 User(array)
 0(array)
 id1173
 typeAgent
 brokerage_id3
 email[email protected]
 passwordba579c44380627d37c115b910cd6401d0a7a4a71
 recover_hash
 first_nameRichard
 last_nameStearns
 title
 dre_num
 phone310.850.9284
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:56
 created2017-08-07 15:23:56
 notified(false)
 full_nameRichard Stearns
 uri/agent-detail/1173/richard-stearns
 profile_complete(true)
 UsersProperty(array)
 id1130
 user_id1173
 property_id3741
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id4753
 property_id3741
 property_feature_id14
 1(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id4752
 property_id3741
 property_feature_id12
 Topic(array)
 0(array)
 id12
 nameModern Architecture
 created2016-02-25 11:25:00
 modified2016-02-25 11:33:26
 tile_nameModern Architecture
 PropertiesTopic(array)
 id58
 property_id3741
 topic_id12
 1(array)
 id4
 nameKiller Views
 created2016-02-25 11:25:00
 modified2016-02-25 11:33:10
 tile_nameKiller Views
 PropertiesTopic(array)
 id57
 property_id3741
 topic_id4
- sidebar_brokerages(array)
 0(array)
 Brokerage(array)
 id203
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2508333
 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
 nameWalker, Wallace & Emerson Realty
 broker_of_record_name
 short_nameWalker, Wallace & Emerson Realty
 usernameWWERealty
 passwordb2c88b61e8d302c43950497fe1d586bb5767cb1b
 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
 descriptionWalker, Wallace & Emerson Realty is the exclusive representative for Leverage Global Partners in the Carolina Foothills, including the Western North Carolina towns and surrounding communities of Tryon, Columbus, Saluda, Mill Spring, Rutherfordton, Spindale, Forest City and Lake Lure as well as the Upstate South Carolina towns and surrounding communities of Landrum, Campobello, Gowensville and Lake Bowen. Tryon, NC, is considered one of the major equi-centers of the United States, with a broad and deep history of equestrian culture and sport. The area enjoys four seasons of amazing weather, warmed in the winter and cooled in the summer by the unique weather phenomenon known as the “thermal effect.” The rolling Carolina Foothills, situated at the edge of the dramatically beautiful Blue Ridge Escarpment, grew in popularity as a resort area after the railway came through in 1917. Tryon quickly became known as a place where moneyed northerners could enjoy riding horses and playing golf during the winter months and coastal southerners could come to enjoy cooler temperatures during the summers. Soon there was a Tryon Riding and Hunt Club, an annual steeplechase and a horse show. The U.S. Equestrian Team held the selection trials for the 1956 Stockholm Olympics here. Today the area boasts two hunts, a number of neighborhood trail associations, a carriage club, a hunter/jumper association, and a pony club, as well as two local competition venues (FENCE and Harmon Field). Attracted by the natural beauty, wide open land and equestrian history of the "thermal belt," the Tryon Resort opened in 2014, offering “the most significant, new equestrian lifestyle destination in the world.” It will feature the Tryon International Equestrian Center, currently in operation. When fully completed, the facility will feature up to 10 riding arenas, including the recently completed stadium with seating for 6,000, as well as 1,000 permanent stalls, a Tryon Sports Complex, and a hotel overlooking the equestrian center. Madelon Wallace, co-owner of Walker, Wallace & Emerson Realty and a Foothills area resident for over 45 years, is dedicated to preserving the open space that has made the area so attractive to equestrians and others. She came from Ohio to attend nearby Converse College, and after graduation accepted a job galloping race horses and breaking yearlings for Tony Wallace at Fairview Farms in Landrum, SC. She married Tony in 1975, and together they broke and gave early training to such nationally known stakes horses as Eclipse Award winners Chris Evert and Turkoman. In 1995, Madelon embarked on a new phase of her career as a full time Realtor and a co-owner with Trux Emerson of Walker, Wallace & Emerson Realty in Landrum. Her love of the area inspired her to work with the market to protect and conserve land from the sprawling housing developments that were looming. Madelon says she has seen “too many communities like ours swept away by the urban sprawl that follows in the wake of un-planned development. I have made it my mission to protect and conserve the land and the community that I love.” In 2005, Madelon was honored with the Conservation Steward of the Year Award from Upstate Forever in Greenville, SC, partially for her work conserving Fairview Farms, as a premiere, large tract residential equestrian community now known as Greenspace of Fairview, with 1,331 acres of protected land including 14 farm tracts, 2 agricultural tracts and 778 acres of open space protected in perpetuity from further development and owned by the Greenspace of Fairview tract owners. Walker, Wallace & Emerson Realty, the "Carolina Foothills" oldest real estate firm, began serving the community in 1964. We have sought to embody the very best in service to our clients, our customers and our community. Even in today’s electronic world "we believe there is no substitute for careful, hands on interaction and a proper dose of privacy when it comes selling a home or relocating to a new community." Walker, Wallace & Emerson’s experienced team of locally grounded professionals has created the perfect balance of the old and the new in the industry. If you're considering buying or selling property, or conducting real estate related activities in this area, we welcome you to contact Walker, Wallace & Emerson Realty. We want to understand exactly what you are looking for and will help you find the perfect property where you can live your dream.
 communitiesPolk County Tryon Saluda Mill Spring Columbus Rutherfordton Spindale Forest City Lake Lure Landrum Campobello Gowensville Lake Bowen
 websitehttp://wwerealty.com/
 address400 E. Rutherford Street
 address_2Suite 100
 cityLandrum, SC
 state
 full_stateNorth Carolina
 countryUSA
 marketTryon, NC
 market_2
 postal_code29356
 phone(864) 457-2448
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameMadelon Wallace
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCo-Owner, Broker-In-Charge
 contact_dre_num
 contact_quoteOne of our team members would like to talk to you personally about Tryon, NC 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_filename203.jpg
 logo_filename203.jpg
 contact_image_filename203.jpg
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_titleTryon Real Estate | Walker, Wallace & Emerson Realty | Leverage Global Partners
 meta_descriptionWalker, Wallace & Emerson Realty is the exclusive representative for Leverage Global Partners in Polk County, Tryon, Mill Spring, Columbus, Rutherfordton, Spindale, Forest Cit, Lake Lure, North Carolina, USA, and Saluda, Landrum, Campobello, Gowensville, Lake Bowen, South Carolina, USA.
 meta_keywordsPolk County Real Estate, Tryon Real Estate, Mill Spring Real Estate, Columbus Real Estate, Rutherfordton Real Estate, Spindale Real Estate, Forest Cit Real Estate, Lake Lure Real Estate, Saluda Real Estate, Landrum Real Estate, Campobello Real Estate, Gowensville Real Estate, Lake Bowen Real Estate, South Carolina Real Estate, North Carolina Real Estate, Madelon Wallace, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-04-22 11:35:25
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/203/walker-wallace-emerson-realty
 website_shortwwerealty.com
 name_with_locationWalker, Wallace & Emerson Realty
 Logo(array)
 id2836
 modelBrokerage
 model_id203
 tagLogo
 name203.jpg
 typeimage/jpg
 size61218
 uri/assets/2836.jpg
 order0
 created2016-03-30 11:44:39
 modified2016-03-30 11:44:39
 1(array)
 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
 Logo(array)
 id2452
 modelBrokerage
 model_id73
 tagLogo
 name73.jpg
 typeimage/jpg
 size181732
 uri/assets/2452.jpg
 order0
 created2016-03-30 11:39:50
 modified2016-03-30 11:39:50
 2(array)
 Brokerage(array)
 id39
 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
 WOEID2405797
 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
 nameIntercoastal Realty
 broker_of_record_name
 short_nameIntercoastal Realty
 usernameIntercoastalRealty
 password9c8b255daf1d29accdc3643af0c35f4bd571b4f5
 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
 descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Broward County, Florida, USA. Intercoastal Realty is as unique as the customers and homes that we represent. Founded by Beth Beauchamp more than 30 years ago, Intercoastal Realty originally sold only waterfront homes. Over the years, Beth grew a two person office into the dominant real estate company in waterfront neighborhoods of Southeast Fort Lauderdale. This growth came from her focus on market knowledge and personal service which she continues to use to help educate her clients and friends. Beth has also imparted this focus to the real estate professionals of Intercoastal Realty who have helped make her so successful. With changes in the market and demands from clients, Intercoastal Realty has now expanded to represent all types of residential properties, but we still remain the only true waterfront experts. Although our market has changed, our goals remain the same. Intercoastal Realty exclusively represents and promotes the best homes for the finest clients. With hundreds of years of combined local experience, Intercoastal Realty’s team of knowledgeable, professional Realtor associates provide both buyers and sellers the facts and opportunities for success in our one-of-a kind real estate market. Our team approach means we work together and with the entire real estate community to bring buyers and sellers together. Our unmatched knowledge and experience combined with our network of local, regional, national and international real estate affiliates gives us the ability to locate a buyer across the street or around the globe! Joining with Leverage Global Partners expands this national and international reach and provides our clients with even more market knowledge and strength. New Website now available! 2015 WaterWays Magazine - <a href="http://www.waterways.flmag.com/" target="_blank">http://www.waterways.flmag.com/</a>
 communitiesFort Lauderdale Ft Lauderdale Broward County
 websitehttp://www.intercoastalrealty.com
 address1500 East Las Olas Boulevard
 address_2
 cityFort Lauderdale
 stateFL
 full_stateFlorida
 countryUSA
 marketFort Lauderdale
 market_2
 postal_code33301
 phone(954) 467-1448
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJohn Beauchamp
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-john-beauchamp-president-intercoastal-realty/
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename39.jpg
 logo_filename39.png
 contact_image_filename39.jpg
 all_properties_link_image_filename39.jpg
 all_properties_linkhttp://www.intercoastalrealty.com/exclusive
 video_embed_code
 contact_video_embed_code
 meta_titleFort Lauderdale Real Estate | Intercoastal Realty | Leverage Global Partners
 meta_descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Fort Lauderdale, FL, USA.
 meta_keywordsIntercoastal Realty, fort lauderdale real estate, John Beauchamp, leverage global partners
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-07-29 17:01:16
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/39/intercoastal-realty
 website_shortwww.intercoastalrealty.com
 name_with_locationIntercoastal Realty
 Logo(array)
 id2353
 modelBrokerage
 model_id39
 tagLogo
 name39.png
 typeimage/png
 size21078
 uri/assets/2353.png
 order0
 created2016-03-30 11:38:46
 modified2016-03-30 11:38:46
 3(array)
 Brokerage(array)
 id25
 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
 WOEID2487889
 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
 nameAscent Real Estate
 broker_of_record_name
 short_nameAscent Real Estate
 usernameAscentSDCoastal
 password847ba57e0102581b0d6aaa7f2a3e234bbcb6e1f9
 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
 descriptionAscent Real Estate is the exclusive representative for Leverage Global Partners in Oceanside, Carlsbad, Encinitas, Solana beach, Del Mar, La jolla, Pacific Beach, Point loma, Ocean Beach, Coronado, Imperial Beach, and Coastal San Diego, California, USA. At Ascent Real Estate, our Mission is to hire, develop, and retain the real estate industry’s most respected agents; cultivating a work environment that is cutting edge, diverse, ethical, compassionate, and strong in its convictions. Ascent Real Estate, established in 2005, is a privately held company that is owned and operated in San Diego, California. It was founded by Penny Nathan and Ken Pecus, two leading agents in the competitive San Diego marketplace. The partners share a combined experience of over 27 years as agents, and each has a diverse range of entrepreneurial experience. They created Ascent Real Estate to fill the customer service vacuum formed by the multi-national real estate monoliths as they expanded during the favorable market cycle. Ascent Real Estate is comprised of a talented and highly motivated team with extensive training and experience in all phases of real estate transactions. The company maintains excellent relationships with key players across the residential real estate industry including brokers, homebuilders, and financial partners. The Ascent Real Estate team is experienced in property sales and acquisitions ranging from expansive estates to single-family homes and condominiums. Ascent Real Estate embodies an enviable combination of entrepreneurial energy, comprehensive industry experience, and local market knowledge. This mix lets Ascent “out national” its local competition thanks to its exceptional professional team and world-class infrastructure, and “out local” the national competition thanks to its laser-like focus on the specific markets in which it operates. Now, with our alliance with Leverage Global Partners, we are able to connect our local communities with others around the world. Our local area experts welcome you, our global neighbors, to sunny San Diego. In addition Ascent Real Estate also has locations in <a href="../../../brokerage-detail/115/Ascent-Real-Estate">North Inland</a>, <a href="../../../brokerage-detail/116/Ascent-Real-Estate">Central Inland</a>, and <a href="../../../brokerage-detail/117/Ascent-Real-Estate">South/East</a>, San Diego, CA. 
 communitiesSan Diego Coastal Oceanside Carlsbad Encinitas Solana Beach Del Mar La Jolla Pacific Beach Point Loma Ocean Beach Coronado Imperial Beach
 websitehttp://www.ascentrealestate.net/
 address410 Kalmia Street
 address_2
 citySan Diego
 stateCA
 full_stateCalifornia
 countryUSA
 marketSan Diego - Coastal
 market_2
 postal_code92101
 phone(619) 325-4100
 phone_2
 phone_3
 wide_contact_image(false)
 contact_namePenny Nathan
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-penny-nathan-president-at-ascent-real-estate-san-diego/
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename25.jpg
 logo_filename25.gif
 contact_image_filename25.jpg
 all_properties_link_image_filename25.jpg
 all_properties_linkhttp://www.ascentrealestate.net/featured-properties
 video_embed_code
 contact_video_embed_code
 meta_titleSan Diego Real Estate | Ascent Real Estate | Leverage Global Partners
 meta_descriptionAscent Real Estate is the exclusive representative for Leverage Global Partners in San Diego, California, USA.
 meta_keywordsascent real estate, san diego real estate, san diego california, penny nathan, leverage global partners
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-05-07 09:51:34
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/25/ascent-real-estate
 website_shortwww.ascentrealestate.net
 name_with_locationAscent Real Estate
 Logo(array)
 id2305
 modelBrokerage
 model_id25
 tagLogo
 name25.gif
 typeimage/gif
 size61001
 uri/assets/2305.gif
 order0
 created2016-03-30 11:37:28
 modified2016-03-30 11:37:28
- sidebar_locations(array)
 0(array)
 Location(array)
 id171
 parent_id5
 brokerage_id100
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameCairo, Egypt
 short_nameCairo, Egypt
 group_index
 latitude30.044420
 longitude31.235712
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 18:45:02
 modified2016-04-12 18:47:53
 timezoneAfrica/Cairo
 population0
 uri/locations/view/171/cairo-egypt
 tile_nameCairo, Egypt
 Brokerage(array)
 id100
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID1521894
 timezoneAfrica/Cairo
 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
 nameExpat-Egypt Real Estate
 broker_of_record_name
 short_nameExpat-Egypt Real Estate
 usernameExpatEgypt
 password7e4fdbaa2d0f97f41653caa8ad277131a78d5cea
 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
 descriptionExpat-Egypt Real Estate is the exclusive representative for Leverage Global Partners in Cairo, Maadi and Zamalek, Egypt. Our Company, Expat-Egypt Real Estate, www.expat-egypt.com, has been established on 2008 in Zamalek, by the G. M. Mr. Mohamed Abd El Moniem, since then has been offering excellent services and high level products to many clients, citizens and foreigners. Our vast knowledge of the market allows us to offer the best locations and deals, helping our customers finding their new homes. We are known to be always providing the most honest and accurate information to all of our customers, owners, tenants and buyers. That’s why we have been quite successful a long all this years. Most of our clients recommend us and we have built a large list of VIP clients from different countries, for them we are a reference in Egypt. Our approach We make sure to know and understand our clients requirements - both in rentals or sales - with as much details as possible. We never forget that each customer has its own needs and that we never receive two similar requests. At EXPAT-EGYPT Real Estate, we ensure the understanding of our customers and try to predict their desires. Our team Our multilingual (English, Italian, German, Spanish and Arabic) and professional staff, dedicated services and individual oriented approach will enable you to find your perfect home as fast as possible. Our Goals • Guarantee a high quality of service, thanks to our expertise and knowledge of the real estate market in Egypt. • Ensure our clients the best deal, providing them with a nice selection of properties. • Allow our clients to benefit from our competencies, know-how and experience, providing them with support in all administrative and logistical issues surrounding the rental or sales process. Social Media Channels: http://www.facebook.com/pages/EXPAT-Egypt/188019051268230 https://twitter.com/@expategypt http://expat-egypt.blogspot.com/
 communitiesCairo Maadi Zamalek
 websitehttp://www.propertiesinegypt.net/
 address19 Hassan Assem Street,
 address_2Front of Irish Embassy
 cityZamalek, Cairo
 state
 full_state
 countryEgypt
 marketCairo
 market_2
 postal_code
 phone(+20) 106-402-7499
 phone_2(+20) 122-339-3544
 phone_3
 wide_contact_image(false)
 contact_nameAlex Mohamed
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename100.jpg
 logo_filename100.png
 contact_image_filename100.jpg
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_titleCairo Real Estate | Expat-Egypt Real Estate | Leverage Global Partners
 meta_descriptionExpat-Egypt Real Estate is the exclusive representative for Leverage Global Partners in Cairo, Maadi and Zamalek, Egypt.
 meta_keywordsCairo Real Estate, Expat-Egypt Real Estate, Leverage Global Partners, Alex Mohamed
 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-26 17:42:17
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/100/expat-egypt-real-estate
 website_shortwww.propertiesinegypt.net
 name_with_locationExpat-Egypt Real Estate
 Image(array)
 id20741
 modelLocation
 model_id171
 tagImage
 nameScreen Shot 2016-04-12 at 6.46.35 PM.png
 typeimage/png
 size844989
 uri/assets/20741.png
 order0
 created2016-04-12 18:47:13
 modified2016-04-12 18:47:53
 1(array)
 Location(array)
 id49
 parent_id8
 brokerage_id140
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameLake Jocassee, SC, USA
 short_nameLake Jocassee, SC, USA
 group_index
 latitude34.981285
 longitude-82.923264
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionBest Recreational Lakes in the Southeast – Lakes Jocassee and Keowee.
 long_descriptionLakes Jocassee and Keowee, tucked in the NW corner of South Carolina with majestic Blue Ridge Mountains as the backdrop, are truly a paradise found. National Geographic has named The Jocassee Gorges as one of “50 of the World’s Last Great Places – Destinations of a Lifetime”. Here you will find lifelong residents and newcomers alike enjoying the amazing surroundings and outdoor activities (boating, golfing, tennis, hiking, river rafting, hunting, fishing). Plus Greenville, SC and Clemson University are right in our back yard – we really do have it all!! Jocassee Real Estate specializes in estate style lake homes, waterfront lots, upscale golf communities and large acreage tracts.
 created2016-04-04 13:00:28
 modified2016-04-14 11:33:38
 timezoneAmerica/New_York
 population195000
 uri/locations/view/49/lake-jocassee-sc-usa
 tile_nameLake Jocassee, SC, USA
 Brokerage(array)
 id140
 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
 WOEID2429402
 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
 nameJocassee Real Estate Company, Inc.
 broker_of_record_name
 short_nameJocassee Real Estate Company, Inc.
 usernameJocasseeRealEstate
 password570a54a24d585bf558ca6f7fa97b7876bc53b9f1
 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
 descriptionJocassee Real Estate Co, Inc. is the exclusive representative for Leverage Global Partners in Lake Jocassee, Lake Keowee, Lake Hartwell, Seneca, Clemson, Walhalla, Pickens and Oconee Counties, SC, USA. Jocassee Real Estate Co, Inc. (JREC) is a leading real estate company which specializes in lake front estate homes and exceptional lake front lots, as well as, waterfront and country club communities. The quality and diversity of our group of professionals affords a unique advantage in the marketing and sales of premier properties. The Upstate of South Carolina is seeing a large influx of property owners into the Lake Keowee and Lake Jocassee areas and it is the goal of JREC is to provide the highest level of satisfaction for both buyers and sellers. The JREC staff partners with top professionals, such as builders and interior designers, in the area to provide you a full service for your real estate investments. Bruce May, Co-Founder of Jocassee Real Estate, is an experienced businessmen with 16 years at Procter & Gamble. He moved to this area because he fell in love with the beauty, weather, people, and the lifestyle here in the Upstate. He owns property in The Cliffs and The Reserve and has homes for clients to utilize during their search and while they build. Bruce is knowledgeable about the area and would be happy to assist you with the many beautiful communities in the lakes area. See Bio for more detailed information. If you're considering buying or selling property, or conducting real estate related activities in this area, we welcome you to contact Jocassee Real Estate Company. We assure you that you will not be disappointed with our real estate services, experience, home sales and exclusive listing offerings. We want to understand what you are looking for and will help you find the perfect property for you to live your dream
 communitiesLake Jocassee Lake Keowee Lake Hartwell Seneca Clemson Walhalla Pickens Oconee
 websitehttp://www.jocasseerealestate.com/
 address306 A Bypass 123
 address_2
 cityLake Jocassee
 stateSC
 full_stateSouth Carolina
 countryUSA
 market
 market_2
 postal_code29678
 phone(864) 723-3674
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameBruce May
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCo-Founder
 contact_dre_num
 contact_quoteI invite you to contact me personally about Lake Jocassee and Lake Keowee Real Estate or to learn more about this beautiful area.
 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_filename140.jpg
 logo_filename140.jpg
 contact_image_filename140.jpg
 all_properties_link_image_filename140.jpg
 all_properties_linkhttp://www.jocasseerealestate.com/SearchProperties.aspx
 video_embed_code
 contact_video_embed_code
 meta_titleLake Jocassee Real Estate | Jocassee Real Estate Company, Inc. | Leverage Global Partners
 meta_descriptionJocassee Real Estate Company, Inc. is the exclusive representative for Leverage Global Partners in Lake Jocassee, SC, USA.
 meta_keywordsJocassee Real Estate Company, Inc., lake jocassee real estate, Lake Keowee real estate, Lake Hartwell real estate, Seneca real estate, Clemson real estate, Walhalla real estate, Pickens real estate, Oconee 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 10:58:35
 modified2016-04-08 16:34:09
 dre_num012345
 uri/brokerage-detail/140/jocassee-real-estate-company-inc
 website_shortwww.jocasseerealestate.com
 name_with_locationJocassee Real Estate Company, Inc.
 Image(array)
 id2977
 modelLocation
 model_id49
 tagImage
 name39922990_dji_0014_-_cropped.jpg
 typeimage/jpeg
 size2657572
 uri/assets/2977.jpg
 order0
 created2016-04-04 12:53:07
 modified2016-04-14 11:33:38
 2(array)
 Location(array)
 id73
 parent_id9
 brokerage_id45
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameRedlands, CA, USA
 short_nameRedlands, CA, USA
 group_index
 latitude34.055569
 longitude-117.182541
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 18:02:34
 modified2016-04-04 18:02:34
 timezoneAmerica/Los_Angeles
 population70000
 uri/locations/view/73/redlands-ca-usa
 tile_nameRedlands, CA, USA
 Brokerage(array)
 id45
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2525109
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameElite Realty Group
 broker_of_record_name
 short_nameElite Realty Group
 usernameEliteRealty
 passworde1a63e2def7ed55f3dbf026430e9a42cc49521b0
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionElite Realty is the exclusive representative for Leverage Global Partners in Redlands, Yucaipa, Colton, Grand Terrace, San Bernardino, Highland, Loma Linda, Mentone, Calimesa, Cherry Valley, Beaumont, and Banning, California, USA. Specializing in homes for sale and the San Bernardino and Riverside County real estate market, you have found your realtor resource for buying and selling your next home. With expertise in realty for both purchasing and listing properties in Yucaipa, Calimesa, Redlands, Cherry Valley, Oak Glen and Beaumont and all surrounding San Bernardino and Riverside Counties, you have found the right resource for all of your real estate needs. Whether you are looking for a new Cherry Valley property or Calimesa land, or you are in the preliminary stages of your real estate search, you have found the best in professional service.
 communitiesRedlands Yucaipa Colton Grand Terrace San Bernardino Highland Loma linda Mentone Calimesa Cherry Valley Beaumont Banning
 websitehttp://www.eliterealtygroup.net/
 address1447 Ford Street
 address_2
 cityRedlands
 stateCA
 full_stateCalifornia
 countryUSA
 market
 market_2
 postal_code92374
 phone(909) 793-3222
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameDennis Miller
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBroker/Co-Owner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename45.jpg
 logo_filename45.png
 contact_image_filename45.JPG
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_titleYucaipa Real Estate | Elite Realty Group | Leverage Global Partners
 meta_descriptionElite Realty Group is the exclusive representative for Leverage Global Partners in Yucaipa, CA, USA.
 meta_keywordsElite Realty Group, yucaipa real estate, Dennis Miller, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-09-10 13:01:01
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/45/elite-realty-group
 website_shortwww.eliterealtygroup.net
 name_with_locationElite Realty Group
 Image(array)
 id3005
 modelLocation
 model_id73
 tagImage
 nameRedlands.jpg
 typeimage/jpeg
 size165492
 uri/assets/3005.jpg
 order0
 created2016-04-04 18:02:25
 modified2016-04-04 18:02:34
 3(array)
 Location(array)
 id128
 parent_id4
 brokerage_id183
 typeExclusive
 archived(false)
 use_as_topic(true)
 nameSicily, Italy
 short_nameSicily, Italy
 group_index
 latitude37.599995
 longitude14.015356
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionLive it once and you’ll stay around. Sicily, “Where Dreams Come True".
 long_descriptionSicily has always been the most appreciated and desired island of the Mediterranean. For ages it has been considered the cradle of the ancient Magna Graecia. Romans left their heritage after the 5th Century A.D., followed by Normans and many great cultures. Its history, culture, beaches and coasts, along with food, prestigious wine labels and Sicilian warmth make it the perfect destination to restore and relax, away from the frantic, daily life. Time here slows down… the blue sky cheers you up, sun warms your body and soul, and tasty food brings you back to life.
 created2016-04-07 14:12:17
 modified2016-04-14 11:01:21
 timezoneEurope/Rome
 population5000000
 uri/locations/view/128/sicily-italy
 tile_nameSicily, Italy
 Brokerage(array)
 id183
 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
 WOEID7153344
 timezoneEurope/Rome
 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
 nameBuy In Sicily Real Estate
 broker_of_record_name
 short_nameBuy In Sicily Real Estate
 usernameBuyInSicily
 passworde080ac9ff550e1171515c67b968e33273dc64e37
 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
 descriptionBuy in Sicily Real Estate is the exclusive representative for Leverage Global Partners in Sicily, Italy. "Buy in Sicily Real Estate" was born from the love for Our Land, and is an on-line real estate company specializing in the sale of properties in Sicily. Buy in Sicily Real Estate quickly became a meeting point for the landowners who want to sell and the potential National and International buyers looking for their dream house in Sicily. The network is comprised of a team of Sicilian Real Estate Agents with a perfect knowledge of the territory, specialized in selecting the best properties for sale on the island, and making sure that all the documentation is good to start a secure purchase and sale. Our clients are well cared for through the entire process, from the search of the property, to the negotiation, to the notarial deed, and taking care of all the technical-legal and notarial forms. On our website, the section PRESTIGE is rich in Exclusive Properties located in the most enchanting places of Sicily, meeting all the requirements of our most demanding clients. Buy in Sicily Real Estate was also mentioned in the FINANCIAL TIMES. We list our properties on the most important National and International real estate websites, in local magazines, in prestigious magazines specializing in the advertisement of Italy abroad and the purchase of second properties, and in the Prestige property section. In addition, we participate in the most important National and International meetings of the real estate field. Apex of our success are the National and International Real Estate Companies Networks, with which we have been working for years now for the advertisement of our properties, and also select local companies. In addition, among our many strong points, we have in house photography for our property, including of a high-definition video which permits buyers to view the property easily from their homes from anywhere in the world! In addition to our specialized real estate team, our group also includes professionals from the financial field, who are glad to share their knowledge and assist you in obtaining loans at a subsidized rate. Our renovation firm is specialized to estimate very particular renovations, very advantageous and competitive, taking care of all the works to release your property turnkey. Thanks to the visibility on the web and to the operative system, Buy in Sicily - Real estate is the ideal window to give light to your property, to increase the chances to sell quickly and to have a bigger buyer’s data bank.
 communitiesSicily
 websitehttp://www.buyinsicily.com/no_cache/en.html
 addressVia Savona, 14
 address_2Paterno
 citySicily
 state
 full_state
 countryItaly
 marketSicily
 market_2
 postal_code
 phone39.392.023.4214
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameFabrizio Vitellino
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleDirector
 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_filename183.jpg
 logo_filename183.jpg
 contact_image_filename183.JPG
 all_properties_link_image_filename183.jpg
 all_properties_linkhttp://www.buyinsicily.com/en/sicily-real-estate.html
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/KSXZGQXL-qzxAOUo0.js"></script>
 contact_video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/b3KjwkKN-Mwvk3CWK.js"></script>
 meta_titleSicily Real Estate⎜Buy in Sicily Real Estate ⎜Leverage Global Partners
 meta_descriptionBuy in Sicily Real Estate is the exclusive representative for Leverage Global Partners in Sicily, Italy
 meta_keywordsBuy in Sicily Real Estate, Sicily Real Estate, Leverage Global Partners, Italy Real Estate, Fabrizio Vitellino
 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 15:03:04
 modified2016-04-08 16:34:20
 dre_num012345
 uri/brokerage-detail/183/buy-in-sicily-real-estate
 website_shortwww.buyinsicily.com/no_cache/en.html
 name_with_locationBuy In Sicily Real Estate
 Image(array)
 id3660
 modelLocation
 model_id128
 tagImage
 nameSicily.jpg
 typeimage/jpeg
 size160897
 uri/assets/3660.jpg
 order0
 created2016-04-07 14:10:40
 modified2016-04-14 11:01:21
- location_properties(empty)
- main_article(empty)
- brokerage(array)
 Brokerage(array)
 id133
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2381475
 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
 nameStouffer Realty Inc
 broker_of_record_name
 short_nameStouffer Realty Inc
 usernameStoufferRealty
 password90e3506a4fa22fac2c3589ef68513c472431da13
 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
 descriptionGary Stouffer, Owner and Founder of Stouffer Realty, began specializing in upscale real estate and large tracts of land in his hometown of Bath, Ohio 33 years ago. His outstanding sales record and reputation in the area inspired him to get his Broker’s license and open Stouffer Realty. The legacy of Stouffer Realty took root, tripling their sales force within three years. This phenomenal rate of growth continues at Stouffer Realty, making it one of the foremost Real Estate brokerages in Northeast Ohio and your best choice for locating and selling Exquisite Homes across this region. Stouffer Realty’s agents share a unique spirit of cooperation, which are both our strongest asset as well as the foundation of the company’s exceptional service. Our dedicated agents work together as a team by always putting the needs of the client first. Our satisfied buyers and sellers are our best form of advertisement. Stouffer agents represent the top realtors in the area, many of which are multi-million dollar producers who specialize in selling exquisite residential and commercial properties at the best possible price. Hundreds of clients have discovered or built their dream property with Stouffer Realty. All Stouffer Realty professionals live in and support the communities they serve. They have first-hand knowledge of area property values, school systems, neighborhoods and finance options. As a result, they are able to negotiate from a position of understanding, integrity, experience and strength in the marketplace. Stouffer realty, Inc. is a leading real estate company in Northeast Ohio, built on a reputation of integrity and exceptional service. Locally owned and operated since 1997, Stouffer Realty has more than 160 agents and specialists in offices serving Akron/Fairlawn, Brecksville/Broadview Heights, Chagrin Falls/Solon, Green/Canton, Kent/Brimfield, Stow/Hudson/Cuyahoga Falls, Strongsville/Brunswick, Medina County and surrounding communities
 communitiesCleveland Hudson Solon Akron Fairlawn Bath Copley Richfield Medina Green Canton Cuyahoga Falls Stow Brimfield Kent Chagrin Valley Summit Wayne Stark Portage Geauga Cuyahoga Counties
 websitehttp://www.stoufferrealty.com/Exquisite-Homes/
 address130 North Miller Road
 address_2
 cityFairlawn
 stateOH
 full_stateOhio
 countryUSA
 marketCleveland
 market_2
 postal_code44333
 phone(330) 835-4900
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJim Fox
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBroker - Vice President of Sales & Operations
 contact_dre_num
 contact_quoteI invite you to contact me personally about Northeast Ohio 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_filename133.jpg
 logo_filename133.jpg
 contact_image_filename133.jpg
 all_properties_link_image_filename133.JPG
 all_properties_linkhttp://www.stoufferrealty.com/listings/query.php?property_category=1&state=39&&pricemin=%24+750%2C000&cidonly=1&
 video_embed_code
 contact_video_embed_code
 meta_titleCleveland Real Estate | Stouffer Realty Inc | Leverage Global Partners
 meta_descriptionStouffer Realty Inc. is the exclusive representative for Leverage Global Partners in Cleveland, OH, USA.
 meta_keywordsStouffer Realty, Cleveland Real Estate, Jim Fox, Hudson real estate, Solon real estate, akron real estate, fairlawn real estate, bath real estate, copley real estate, richfield real estate, medina real estate, green real estate, canton real estate, cuyahoga falls real estate, stow real estate, brimfield real estate, kent real estate, summit real estate, chagrin valley real estate, wayne real estate, stark real estate, portage real estate, geauga real estate, cuyahoga real estate, ohio real estate, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-06-24 09:40:22
 modified2016-04-08 16:34:09
 dre_num012345
 uri/brokerage-detail/133/stouffer-realty-inc
 website_shortwww.stoufferrealty.com/Exquisite-Homes
 name_with_locationStouffer Realty Inc - Cleveland, OH, 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)
 id2638
 modelBrokerage
 model_id133
 tagLogo
 name133.jpg
 typeimage/jpg
 size750656
 uri/assets/2638.jpg
 order0
 created2016-03-30 11:41:50
 modified2016-03-30 11:41:50
 MainImage(array)
 id2637
 modelBrokerage
 model_id133
 tagMainImage
 name133.jpg
 typeimage/jpg
 size1573579
 uri/assets/2637.jpg
 order0
 created2016-03-30 11:41:49
 modified2016-03-30 11:41:49
 ContactImage(array)
 id2639
 modelBrokerage
 model_id133
 tagContactImage
 name133.jpg
 typeimage/jpg
 size180355
 uri/assets/2639.jpg
 order0
 created2016-03-30 11:41:50
 modified2016-03-30 11:41:50
 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)
 id110
 parent_id9
 brokerage_id133
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameCleveland, OH, USA
 short_nameCleveland, OH, USA
 group_index
 latitude41.499321
 longitude-81.694359
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionExperience life on other Coastal State, the Northeast Ohio Great Lakes!
 long_descriptionNortheast Ohio offers a lifestyle for every person with an affordability that enriches all. We enjoy the four seasons, the Cuyahoga Metro Park’s Emerald Necklace, life along the shores of Lake Erie and its arteries of rivers and canals that meander through Cleveland and the Akron/Canton suburbs. Great entertainment abounds with the arts, sporting, gaming, Rock and Roll and Football Halls of Fame, as well as other museums and sites of interest. We are home to world renowned health care & hospitals. Our market features housing stock from the early 1900’s to present and revitalized downtown living.
 created2016-04-05 14:05:18
 modified2016-04-05 14:05:18
 timezoneAmerica/New_York
 population390000
 uri/locations/view/110/cleveland-oh-usa
 tile_nameCleveland, OH, USA
 User(array)
 0(array)
 id141
 typeBrokerageAdmin
 brokerage_id133
 email[email protected]
 password90e3506a4fa22fac2c3589ef68513c472431da13
 recover_hash
 first_nameJim
 last_nameFox
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2016-04-12 08:28:24
 created2016-04-08 16:34:09
 notified(true)
 full_nameJim Fox
 uri/agent-detail/141/jim-fox
 profile_complete(true)
 1(array)
 id757
 typeAgent
 brokerage_id133
 email[email protected]
 password749efc6316cb37bf1a67eb6dea37631f5a3d63a3
 recover_hash
 first_nameKelly
 last_nameVrba
 title
 dre_num
 phone3308190144
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:19
 created2017-08-07 15:23:19
 notified(false)
 full_nameKelly Vrba
 uri/agent-detail/757/kelly-vrba
 profile_complete(true)
 2(array)
 id758
 typeAgent
 brokerage_id133
 email[email protected]
 password54814716d2601b9eff05576151b5e9c71cbfa3d2
 recover_hash
 first_nameJames
 last_nameFox
 title
 dre_num
 phone2162878888
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:19
 created2017-08-07 15:23:19
 notified(false)
 full_nameJames Fox
 uri/agent-detail/758/james-fox
 profile_complete(true)
 3(array)
 id814
 typeAgent
 brokerage_id133
 email[email protected]
 password211adcff6d26143372b9175ddfb80e2935ed31dd
 recover_hash
 first_nameSusan
 last_nameHerberich
 title
 dre_num
 phone330-701-2758
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:24
 created2017-08-07 15:23:24
 notified(false)
 full_nameSusan Herberich
 uri/agent-detail/814/susan-herberich
 profile_complete(true)
 4(array)
 id993
 typeAgent
 brokerage_id133
 email[email protected]
 passwordb77d3d2bd104f0f2123648e9bc8af0cbb92a814b
 recover_hash
 first_nameTom
 last_nameBoggs
 title
 dre_num
 phone330.322.7500
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:47
 created2017-08-07 15:23:47
 notified(false)
 full_nameTom Boggs
 uri/agent-detail/993/tom-boggs
 profile_complete(true)
 5(array)
 id1085
 typeAgent
 brokerage_id133
 email[email protected]
 passworde3cad227aba63bda0385ed798d282069e0a5571f
 recover_hash
 first_nameMike
 last_nameStoerkel
 title
 dre_num
 phone330.701.4426
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:53
 created2017-08-07 15:23:53
 notified(false)
 full_nameMike Stoerkel
 uri/agent-detail/1085/mike-stoerkel
 profile_complete(true)
 6(array)
 id1257
 typeAgent
 brokerage_id133
 email[email protected]
 password05a412c37f9cb87fcc004b5761f29621079cfa7c
 recover_hash
 first_nameAmy
 last_nameStaats
 title
 dre_num
 phone3308354900
 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_nameAmy Staats
 uri/agent-detail/1257/amy-staats
 profile_complete(true)
 7(array)
 id1258
 typeAgent
 brokerage_id133
 email[email protected]
 password7c562a21bffac94d3bce605d150f1cba255c1fe3
 recover_hash
 first_nameJonna
 last_nameD'Amicone
 title
 dre_num
 phone3304164330
 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_nameJonna D'Amicone
 uri/agent-detail/1258/jonna-d-amicone
 profile_complete(true)
- location(array)
 Location(array)
 id110
 parent_id9
 brokerage_id133
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameCleveland, OH, USA
 short_nameCleveland, OH, USA
 group_index
 latitude41.499321
 longitude-81.694359
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionExperience life on other Coastal State, the Northeast Ohio Great Lakes!
 long_descriptionNortheast Ohio offers a lifestyle for every person with an affordability that enriches all. We enjoy the four seasons, the Cuyahoga Metro Park’s Emerald Necklace, life along the shores of Lake Erie and its arteries of rivers and canals that meander through Cleveland and the Akron/Canton suburbs. Great entertainment abounds with the arts, sporting, gaming, Rock and Roll and Football Halls of Fame, as well as other museums and sites of interest. We are home to world renowned health care & hospitals. Our market features housing stock from the early 1900’s to present and revitalized downtown living.
 created2016-04-05 14:05:18
 modified2016-04-05 14:05:18
 timezoneAmerica/New_York
 population390000
 uri/locations/view/110/cleveland-oh-usa
 tile_nameCleveland, OH, USA
 Image(array)
 id3044
 modelLocation
 model_id110
 tagImage
 namecleveland.jpg
 typeimage/jpeg
 size177465
 uri/assets/3044.jpg
 order0
 created2016-04-05 14:04:42
 modified2016-04-05 14:05:18
- membership_subscription_temp_allowed_login(null)
- newsletter_member_types(array)
 Leverage Member: AgentLeverage Member: Agent
 Leverage Member: Broker or ManagementLeverage Member: Broker or Management
 Non-MemberNon-Member
- $request->data(empty)
- $this->validationErrors(array)
 Subscription(empty)
 Location(empty)
 Image(empty)
 Brokerage(empty)
 AccountExecutive(empty)
 Logo(empty)
 MainImage(empty)
 ContactImage(empty)
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 Property(empty)
 User(empty)
 PropertyFeature(empty)
 SecondaryPropertyCategory(empty)
 Topic(empty)
 FeaturedImage(empty)
 Article(empty)
 ParentBrokerage(empty)
 ParentLocation(empty)
 ArticlesBrokerage(empty)
 ArticlesLocation(empty)
 ArticlesProperty(empty)
 ArticlesTopic(empty)
 PrimaryPropertyCategory(empty)
 StripeSubscription(empty)
 GlobalReachReport(empty)
 UsersProperty(empty)
 PropertiesSecondaryPropertyCategory(empty)
 PropertiesPropertyFeature(empty)
 PropertiesTopic(empty)
- Loaded Helpers(array)
 0Permission
 1Geography
 2Number
 3SimpleGraph
 4DebugTimer
 5Toolbar
 6Session
 7Text
 8Flash
 9HtmlToolbar
 10Html
 11Form
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	7.4.33
User	leveragere
Home	/var/www/vhosts/leveragere.com
Script Name	/index.php
Request Uri	/locations/view/110/cleveland-oh-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/locations/view/110/cleveland-oh-usa
Remote Port	16785
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	162.159.115.42
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
Http Accept Encoding	gzip, br
Http Accept	/
Http Cf Ray	a09da82b68ecae97-CMH
Http X Forwarded For	216.73.216.172
Proxy-nokeepalive	1
Ssl Tls Sni	staging2.leveragere.com
Https	on
Passenger Download Native Support Binary	0
Passenger Compile Native Support Binary	0
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Unique Id	aiowum7yC1TpDG5SpsnqKQAAAoM
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	aiowum7yC1TpDG5SpsnqKQAAAoM
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781149882.1726
Request Time	1781149882

====

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

Cleveland, OH, 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: 21 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: 21 ms
Total Queries: 19 queries