Locations / Sarasota, FL, USA

Sarasota, FL, USA

Imagine… Sand beneath your feet, the sight of emerald fairways, or waiting for the overture to start. Discover your way of life with prices ranging from $100,000 – $20,000,000+. Tropical Climate, Gorgeous Beaches, Arts, Culture, Outdoor Activities, Affordable Housing and a Relaxed Lifestyle await you on Florida’s “Sun Coast!" Beach-front Homes & Condos, Beach Cottages, Stunning Mansions, Luxury Golf Course homes, “Florida-style” bungalows as well as traditional Family homes – all within 30 minutes of USA’s #1 Beach, Shopping on St. Armand’s Circle, Downtown Arts & Culture, Restaurants, Polo fields, Skull & Rowing facilities, World-Class Golf Courses, and more.

Location Represented By

License #: 012345

11:50pm local time
1 million 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
- Config(array)
  userAgentcc2d3fd23c5dd98eb73e42c141648c0a
  time1781164226
  countdown10
- Explore(array)
  rejected_tiles(array)
  rejected_topics(empty)
  rejected_locations(empty)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerlocations
- actionview
- named(empty)
- pass(array)
  067
  1sarasota-fl-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: 18 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` = 67 AND `Location`.`archived` = '0' LIMIT 1	1	1	0
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `AccountExecutive`.`id`, `AccountExecutive`.`type`, `AccountExecutive`.`brokerage_id`, `AccountExecutive`.`email`, `AccountExecutive`.`password`, `AccountExecutive`.`recover_hash`, `AccountExecutive`.`first_name`, `AccountExecutive`.`last_name`, `AccountExecutive`.`title`, `AccountExecutive`.`dre_num`, `AccountExecutive`.`phone`, `AccountExecutive`.`max_luxury_feed_properties`, `AccountExecutive`.`headshot_filename`, `AccountExecutive`.`bio`, `AccountExecutive`.`brokerage_name_override`, `AccountExecutive`.`stripe_customer_id`, `AccountExecutive`.`digital_ad_first_free_month_coupon`, `AccountExecutive`.`modified`, `AccountExecutive`.`created`, `AccountExecutive`.`notified`, (CONCAT(`AccountExecutive`.`first_name`, " ", `AccountExecutive`.`last_name`)) AS `AccountExecutive__full_name`, `Logo`.`id`, `Logo`.`model`, `Logo`.`model_id`, `Logo`.`tag`, `Logo`.`name`, `Logo`.`type`, `Logo`.`size`, `Logo`.`uri`, `Logo`.`order`, `Logo`.`created`, `Logo`.`modified`, `MainImage`.`id`, `MainImage`.`model`, `MainImage`.`model_id`, `MainImage`.`tag`, `MainImage`.`name`, `MainImage`.`type`, `MainImage`.`size`, `MainImage`.`uri`, `MainImage`.`order`, `MainImage`.`created`, `MainImage`.`modified`, `ContactImage`.`id`, `ContactImage`.`model`, `ContactImage`.`model_id`, `ContactImage`.`tag`, `ContactImage`.`name`, `ContactImage`.`type`, `ContactImage`.`size`, `ContactImage`.`uri`, `ContactImage`.`order`, `ContactImage`.`created`, `ContactImage`.`modified`, `ContactImage2`.`id`, `ContactImage2`.`model`, `ContactImage2`.`model_id`, `ContactImage2`.`tag`, `ContactImage2`.`name`, `ContactImage2`.`type`, `ContactImage2`.`size`, `ContactImage2`.`uri`, `ContactImage2`.`order`, `ContactImage2`.`created`, `ContactImage2`.`modified`, `ContactImage3`.`id`, `ContactImage3`.`model`, `ContactImage3`.`model_id`, `ContactImage3`.`tag`, `ContactImage3`.`name`, `ContactImage3`.`type`, `ContactImage3`.`size`, `ContactImage3`.`uri`, `ContactImage3`.`order`, `ContactImage3`.`created`, `ContactImage3`.`modified`, `BrokerOfRecordLogo`.`id`, `BrokerOfRecordLogo`.`model`, `BrokerOfRecordLogo`.`model_id`, `BrokerOfRecordLogo`.`tag`, `BrokerOfRecordLogo`.`name`, `BrokerOfRecordLogo`.`type`, `BrokerOfRecordLogo`.`size`, `BrokerOfRecordLogo`.`uri`, `BrokerOfRecordLogo`.`order`, `BrokerOfRecordLogo`.`created`, `BrokerOfRecordLogo`.`modified`, `MainArticle`.`id`, `MainArticle`.`model`, `MainArticle`.`model_id`, `MainArticle`.`archived`, `MainArticle`.`medium_featured`, `MainArticle`.`large_featured`, `MainArticle`.`title`, `MainArticle`.`author`, `MainArticle`.`date`, `MainArticle`.`lead_in`, `MainArticle`.`body`, `MainArticle`.`vimeo_id`, `MainArticle`.`created`, `MainArticle`.`modified` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` LEFT JOIN `leveragere_staging2`.`users` AS `AccountExecutive` ON (`Brokerage`.`account_executive_id` = `AccountExecutive`.`id`) LEFT JOIN `leveragere_staging2`.`assets` AS `Logo` ON (`Logo`.`model_id` = `Brokerage`.`id` AND `Logo`.`model` = 'Brokerage' AND `Logo`.`tag` = 'Logo') LEFT JOIN `leveragere_staging2`.`assets` AS `MainImage` ON (`MainImage`.`model_id` = `Brokerage`.`id` AND `MainImage`.`model` = 'Brokerage' AND `MainImage`.`tag` = 'MainImage') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage` ON (`ContactImage`.`model_id` = `Brokerage`.`id` AND `ContactImage`.`model` = 'Brokerage' AND `ContactImage`.`tag` = 'ContactImage') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage2` ON (`ContactImage2`.`model_id` = `Brokerage`.`id` AND `ContactImage2`.`model` = 'Brokerage' AND `ContactImage2`.`tag` = 'ContactImage2') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage3` ON (`ContactImage3`.`model_id` = `Brokerage`.`id` AND `ContactImage3`.`model` = 'Brokerage' AND `ContactImage3`.`tag` = 'ContactImage3') LEFT JOIN `leveragere_staging2`.`assets` AS `BrokerOfRecordLogo` ON (`BrokerOfRecordLogo`.`model_id` = `Brokerage`.`id` AND `BrokerOfRecordLogo`.`model` = 'Brokerage' AND `BrokerOfRecordLogo`.`tag` = 'BrokerOfRecordLogo') LEFT JOIN `leveragere_staging2`.`articles` AS `MainArticle` ON (`MainArticle`.`model_id` = `Brokerage`.`id` AND `MainArticle`.`model` = 'Brokerage') WHERE `Brokerage`.`id` = 226 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` = (226) 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` = (226)	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` = (226)	4	4	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` = 67 LIMIT 1	0	0	1	maybe slow
SELECT `Location`.`id`, `Location`.`name`, `Location`.`parent_id` FROM `leveragere_staging2`.`locations` AS `Location` WHERE `Location`.`id` = 67 AND `Location`.`archived` = '0' LIMIT 1	1	1	1
SELECT `Location`.`id`, `Location`.`name` FROM `leveragere_staging2`.`locations` AS `Location` WHERE `Location`.`parent_id` = 67	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	4
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 (3707, 3759, 3754, 3706) ORDER BY `Image`.`order` ASC	23	23	0
SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (3707, 3759, 3754, 3706) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	3	3	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 (3707, 3759, 3754, 3706) 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 (3707, 3759, 3754, 3706) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	0	0	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 (3707, 3759, 3754, 3706) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 14.74 MB

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

Timers

Total Request Time: 221 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	25.30
Event: Controller.initialize	3.76
Event: Controller.startup	1.08
Controller action	46.18
Event: Controller.beforeRender	15.67
» Processing toolbar data	15.57
Rendering View	99.06
» Event: View.beforeRender	0.27
» Rendering APP/View/Locations/view.ctp	2.55
» » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.14
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.16
» » Rendering APP/View/Elements/sidebar/brokerage_list.ctp	0.16
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.22
» » » Rendering APP/View/Elements/static_property_price.ctp	0.36
» » » Rendering APP/View/Elements/static_property_price.ctp #2	0.16
» » » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.19
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	95.55
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)
 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)
 1(array)
 Property(array)
 id3759
 brokerage_id1
 created_by_user_id457
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 name123
 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)
 description123
 address123
 address_2
 cityOrlando
 stateFL
 postal_code43656
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price0
 price_20
 price_usd0
 price_usd_20
 statusFor Sale
 status_last_changed2024-10-24 10:13:34
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms0
 bedrooms_20
 bathrooms0
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude28.538383
 longitude-81.378929
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(false)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2024-10-24 10:16:28
 created2024-10-24 10:12:43
 uri/property-detail/3759/123-orlando-fl-43656-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3759/123-orlando-fl-43656-usa
 address_concat123 Orlando FL 43656 USA
 google_maps_query_string123++Orlando+FL+43656+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 0
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty0
 bathrooms_pretty0
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms0
 date_listed2024-10-24
 overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id1
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties12
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties1
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id1
 WOEID2363796
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePartners Trust Real Estate Brokerage and Acquisitions
 broker_of_record_name
 short_namePartners Trust Real Estate
 usernamePartnersTrustBH
 password2a77eb13ee7deac93b310ba1431a4982bfdbddeb
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 description<h2> </h2> Partners Trust is the exclusive representative for Leverage Global Partners in Beverly Hills, California, USA. We are dedicated to being the finest real estate brokerage in Los Angeles. At Partners Trust, our objective is to present our clients with the most professional, successful and ethical real estate associates in the business and to represent our clients with care, confidentiality and the utmost attention to service. We believe we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market. We begin with a commodity that is hard-earned and easily lost: TRUST. Without the daily demonstration and commitment to uphold principles, a company’s mission statement is simply words on a page and nothing more. Partners Trust has adopted a mission statement that each Associate and staff member must sign to in order to participate with the Company, which articulates the core philosophy and culture of the Company. The Partners Trust founders utilized their extensive experience and resources to create a Company that is both unique and beneficial for those willing to commit to the rigorous standards that have been set forth. The Company’s intention is to empower each member of its sales force each and every step of the way. Partners Trust has additional office locations in <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/5/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Pasadena</a>, <a href="../../../brokerage-detail/142/Partners-Trust" target="_blank">Malibu</a> and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a>
 communitiesBeverly Hills Bel Air Century City Westwood West Hollywood
 websitehttp://thepartnerstrust.com
 address9378 Wilshire Boulevard
 address_2Suite 200
 cityBeverly Hills
 stateCA
 full_stateCalifornia
 countryUSA
 marketBeverly Hills
 market_2
 postal_code90212
 phone(310) 500-1388
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameNick Segal
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/presidential-profile-partners-trust-real-estate-brokerage-aquisitions-nick-segal/
 contact_big_profile_link_text
 contact_titlePresident/Co-Founder
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename1.jpg
 logo_filename1.png
 contact_image_filename1.jpg
 all_properties_link_image_filename1.jpg
 all_properties_linkhttp://www.thepartnerstrust.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleBeverly Hills Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
 meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions is an award-winning real estate brokerage representing Leverage Global Partners in Beverly Hills, CA, USA.
 meta_keywordspartners trust, partners trust real estate, beverly hills real estate, beverly hills real estate agents, leverage global partners
 login_message_counter2
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-02-21 13:57:13
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/1/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortthepartnerstrust.com
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id23109
 modelProperty
 model_id3759
 tagImage
 name2-Westridge-MLS-Exterior-2-1390x580.jpg
 typeimage/jpeg
 size269041
 uri/assets/23109.jpg
 order0
 created2024-10-24 10:12:41
 modified2024-10-24 10:12:43
 User(array)
 0(array)
 id457
 typeAgent
 brokerage_id1
 email[email protected]
 password87700b14633e9484a5583d862fe044ed9dd9b450
 recover_hash
 first_nameMark
 last_nameKitching
 title
 dre_num
 phone310.500.1367
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:58
 created2017-08-07 15:22:58
 notified(false)
 full_nameMark Kitching
 uri/agent-detail/457/mark-kitching
 profile_complete(true)
 UsersProperty(array)
 id1137
 user_id457
 property_id3759
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 2(array)
 Property(array)
 id3754
 brokerage_id16
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameBoutique State-of-the-Art Condo in the West Village
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(false)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time2019-10-29 20:09:29
 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_sent2019-10-31 20:45:16
 digital_ad_summary_price_changed(false)
 wsj_detail_urlhttps://realestate.wsj.com/newyork/2204846-385-west-12th-street-10014?mod=search&pos=7&page=1&
 ft_detail_urlhttps://propertylistings.ft.com/homes/2755194
 nyt_detail_urlhttps://www.nytimes.com/real-estate/usa/ny/new-york/west-village/homes-for-sale/385-west-12th-street/1106-PRCH-2762625
 juwai_detail_urlhttps://www.juwai.com/50318262.htm
 pgl_detail_urlhttps://www.propgoluxury.com/en/homes/2755194
 mg_detail_urlhttps://www.mansionglobal.com/newyork/2204846-385-west-12th-street-10014?mod=search&pos=6&page=1&&region=na,us
 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)
 description385 West 12th Street, a boutique and state-of-the-art condominium in the West Village, boasts this magnificent 3-bedroom, 2.5-bathroom apartment. It is meticulously designed to the highest standard and spans 2,711SF. A private elevator landing opens to the heart of the home. Upon entering, the thoughtful layout leads left to the living areas and additional bedrooms, ensuring privacy to the master suite which is to the right. A powder room is cleverly tucked opposite the landing, perfect for guests. The sitting room is anchored by a gas fireplace and leads to the light-filled living room. Separating the living and dining areas is discreet storage. Treetops and the cobblestoned street can be seen through the massive, floor-to-ceiling window that frames the dining room. Overlooking the dining room is an oversized chefâs kitchen; ideal for both large events, and intimate, countertop eating. It boasts custom white lacquered oak cabinetry complimented by the marble countertops and backsplash. Itâs equipped with top-of-the-line Miele and Gaggenau appliances, Franke sinks/faucets and wine fridge. The spacious master suite features a generous terrace, walk-in closet and stunning five-piece bathroom. The bathroom is outfitted in Italian marble with a deep-soaking tub, glass-enclosed shower, and radiant floor heating. A media room, home office, two additional bedrooms, an additional full bathroom and washer/dryer complete the home. Additional features include Control 4- fully integrated home automation. Completed in 2010, 385 West 12th Street is a boutique condominium with only 12 units among 7 stories. Amenities offer the perfect balance of leisure and entertainment and feature a recently renovated and beautifully landscaped rooftop with a 55-foot swimming pool, Jacuzzi, outdoor shower, two gas grills and dining space. Direct views of the Hudson River, the West Village, and Empire State Building, with views to the north crown the rooftop. Additional building amenities include a 24-hour doorman/concierge, millwork club locker in the lobby, bike storage, and cellar storage room.
 address385 West 12th Street
 address_23WEST
 cityNew York
 stateNY
 postal_code10014
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price5000000
 price_20
 price_usd5000000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms0
 bedrooms_20
 bathrooms0
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built2004
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num123456
 wsj_property_typecondominium
 nyt_property_type5
 nyt_popular_features
 propgolux_property_type2
 juwai_property_typeApartments/Condo
 juwai_categoryresidential
 propgolux_property_style25
 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.737713
 longitude-74.008759
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(false)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2019-10-31 20:45:16
 created2019-10-29 20:06:20
 uri/property-detail/3754/385-west-12th-street-3west-new-york-ny-10014-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3754/385-west-12th-street-3west-new-york-ny-10014-usa
 address_concat385 West 12th Street 3WEST New York NY 10014 USA
 google_maps_query_string385+West+12th+Street+3WEST+New+York+NY+10014+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 5,000,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty0
 bathrooms_pretty0
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms0
 date_listed2019-10-29
 overridden_brokerage_nameCORE
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id16
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties20
 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
 WOEID12589342
 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
 nameCORE
 broker_of_record_name
 short_nameCORE
 usernameCORENYC
 password6bbc31e8f00594b7e3433f0a9c0cd7334bff73ae
 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
 descriptionCORE is the exclusive representative for Leverage Global Partners in New York City, New York, USA. CORE is the leading, full-service, boutique real estate brokerage specializing in the marketing of premiere residential properties. Headquartered in New York City, CORE was founded by CEO Shaun Osher and Jack Cayre, who envisioned a dynamic boutique brokerage based on integrity, informed by expertise and driven by innovation. CORE offers comprehensive real estate solutions for buyers, sellers, landlords, investors and developers. The firm is powered by an integrated team of accomplished professionals with extensive expertise in all aspects of real estate transactions. Thanks to a unique marketing approach, CORE ensures that its clients earn the highest market-driven prices. Our agents educate and shepherd buyers, sellers and landlords through the sales or leasing process. And we partner closely with developers, from the earliest stages of a project through closing; partnerships, which boast a proven, profitable track record. Within the past 8 years, CORE has marketed more than 30 new development properties and is the #1 brokerage in its class.
 communitiesManhattan Chelsea New York City Tribeca Midtown
 websitehttp://corenyc.com/
 address104 Fifth Avenue
 address_2
 cityNew York
 stateNY
 full_stateNew York
 countryUSA
 marketNew York
 market_2
 postal_code10011
 phone(212) 726-0778
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameShaun Osher
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-shaun-osher-founder-and-ceo-of-core/
 contact_big_profile_link_text
 contact_titleFounder and CEO
 contact_dre_num
 contact_quoteI invite you to contact me personally about New York City 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_filename16.jpg
 logo_filename16.jpg
 contact_image_filename16.jpg
 all_properties_link_image_filename16.jpg
 all_properties_linkhttp://corenyc.com/listings
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/cxxGtpBt-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNew York City Real Estate | CORE | Leverage Global Partners
 meta_descriptionCORE is Leverage Global Partners' exclusive representative in New York City, NY, USA.
 meta_keywordsnew york city real estate, manhattan real estate, shaun osher, CORE, 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-04-01 15:35:47
 modified2019-10-29 20:06:57
 dre_num012345
 uri/brokerage-detail/16/core
 website_shortcorenyc.com
 name_with_locationCORE
 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)
 id23063
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv6b4i17.jpg
 typeimage/jpeg
 size1392149
 uri/assets/23063.jpg
 order0
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 1(array)
 id23071
 modelProperty
 model_id3754
 tagImage
 namePI-1tia0th4t2.jpg
 typeimage/jpeg
 size745950
 uri/assets/23071.jpg
 order1
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 2(array)
 id23061
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv6ad5r0.jpg
 typeimage/jpeg
 size953561
 uri/assets/23061.jpg
 order2
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 3(array)
 id23062
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv5v65vv.jpg
 typeimage/jpeg
 size1120705
 uri/assets/23062.jpg
 order3
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 4(array)
 id23064
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv5ud7qf.jpg
 typeimage/jpeg
 size819805
 uri/assets/23064.jpg
 order4
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 5(array)
 id23065
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv5u6hao.jpg
 typeimage/jpeg
 size1354457
 uri/assets/23065.jpg
 order5
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 6(array)
 id23066
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv6c8c2k.jpg
 typeimage/jpeg
 size667117
 uri/assets/23066.jpg
 order6
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 7(array)
 id23067
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv62hm1n.jpg
 typeimage/jpeg
 size1142542
 uri/assets/23067.jpg
 order7
 created2019-10-29 20:06:01
 modified2019-10-29 20:06:20
 8(array)
 id23068
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv60kn0g.jpg
 typeimage/jpeg
 size900053
 uri/assets/23068.jpg
 order8
 created2019-10-29 20:06:01
 modified2019-10-29 20:06:20
 9(array)
 id23069
 modelProperty
 model_id3754
 tagImage
 namePI-1tia0rna64.jpg
 typeimage/jpeg
 size667255
 uri/assets/23069.jpg
 order9
 created2019-10-29 20:06:01
 modified2019-10-29 20:06:20
 10(array)
 id23070
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv64a3ih.jpg
 typeimage/jpeg
 size1295530
 uri/assets/23070.jpg
 order10
 created2019-10-29 20:06:01
 modified2019-10-29 20:06:20
 11(array)
 id23072
 modelProperty
 model_id3754
 tagImage
 namePI-1tia0uv5i1.jpg
 typeimage/jpeg
 size816357
 uri/assets/23072.jpg
 order11
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 12(array)
 id23073
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv64q2c3.jpg
 typeimage/jpeg
 size1246171
 uri/assets/23073.jpg
 order12
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 13(array)
 id23074
 modelProperty
 model_id3754
 tagImage
 namePI-1tlejtukfi.jpg
 typeimage/jpeg
 size1296375
 uri/assets/23074.jpg
 order13
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 14(array)
 id23075
 modelProperty
 model_id3754
 tagImage
 namePI-1tlek8ckib.jpg
 typeimage/jpeg
 size821336
 uri/assets/23075.jpg
 order14
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 15(array)
 id23076
 modelProperty
 model_id3754
 tagImage
 namePI-1tlek3e9dr.jpg
 typeimage/jpeg
 size1122053
 uri/assets/23076.jpg
 order15
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 16(array)
 id23077
 modelProperty
 model_id3754
 tagImage
 namePI-1tlek0qvrl.jpg
 typeimage/jpeg
 size1277836
 uri/assets/23077.jpg
 order16
 created2019-10-29 20:06:03
 modified2019-10-29 20:06:20
 17(array)
 id23078
 modelProperty
 model_id3754
 tagImage
 namePI-1tlek8f4uk.jpg
 typeimage/jpeg
 size955578
 uri/assets/23078.jpg
 order17
 created2019-10-29 20:06:03
 modified2019-10-29 20:06:20
 18(array)
 id23079
 modelProperty
 model_id3754
 tagImage
 namePI-1tlek8p84e.jpg
 typeimage/jpeg
 size900653
 uri/assets/23079.jpg
 order18
 created2019-10-29 20:06:03
 modified2019-10-29 20:06:20
 19(array)
 id23080
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv5smv25.jpg
 typeimage/jpeg
 size1276220
 uri/assets/23080.jpg
 order19
 created2019-10-29 20:06:10
 modified2019-10-29 20:06:20
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 3(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)
- sidebar_brokerages(array)
 0(array)
 Brokerage(array)
 id10
 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_id6
 WOEID957831
 timezoneEurope/Athens
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameBeauchamp Estates
 broker_of_record_name
 short_nameBeauchamp Estates
 usernameBeauchampMykonos
 passwordba8b6054115d97d03e74e079d6a6feeb65ddff58
 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
 descriptionBeauchamp Estates is the exclusive representative for Leverage Global Partners in Mykonos, Greece. Following on from the successful opening of the office in Cannes, this is Beauchamp Estates’ newest addition to its overseas office portfolio. Mykonos, recognized as one of the world's most cosmopolitan destinations, with an increasingly wealthy and exclusive clientele, has some of the most upmarket, and expensive real estate available in Greece. Beauchamp Estates Mykonos specializes in residential sales at the very top end of the market, handles commercial investments, potential sites, new developments and luxury villa rentals. They offer an all around package and frequently earn repeat business from clients. With an established international client base, Beauchamp Estates has additional offices in <a href="../../../brokerage-detail/7/Beauchamp-Estates" target="_blank">London, England</a>, <a href="../../../brokerage-detail/11/Beauchamp-Estates" target="_blank">Cannes in the South of France</a>, and <a href="../../../brokerage-detail/12/Beauchamp-Estates" target="_blank">Florence, Italy</a>.
 communitiesMykonos Greece GR
 websitehttp://www.beauchamp.com/
 addressRohari
 address_2
 cityMykonos
 state
 full_state
 countryGreece
 marketMykonos
 market_2
 postal_code84600
 phone+3022890 24797
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameRoi Deldimou
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-roi-deldimou-beauchamp-estates-mykonos-greece/
 contact_big_profile_link_text
 contact_titleBeauchamp Estates
 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_filename10.jpg
 logo_filename10.jpg
 contact_image_filename10.jpeg
 all_properties_link_image_filename10.jpg
 all_properties_linkhttp://www.beauchamp.gr/index.php?act=viewCat&catId=64
 video_embed_code
 contact_video_embed_code
 meta_titleMykonos Real Estate | Beauchamp Estates Mykonos | Leverage Global Partners
 meta_descriptionBeauchamp Estates is the exclusive real estate representative for Leverage Global Partners in Mykonos, Greece.
 meta_keywordsmykonos real estate, beauchamp estates, beauchamp estates mykonos, leverage global partners, gary hersham
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-03-19 17:01:23
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/10/beauchamp-estates
 website_shortwww.beauchamp.com
 name_with_locationBeauchamp Estates
 Logo(array)
 id2269
 modelBrokerage
 model_id10
 tagLogo
 name10.jpg
 typeimage/jpg
 size21708
 uri/assets/2269.jpg
 order0
 created2016-03-30 11:36:14
 modified2016-03-30 11:36:14
 1(array)
 Brokerage(array)
 id113
 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
 WOEID2356566
 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
 nameMountain Oak Properties
 broker_of_record_name
 short_nameMountain Oak Properties
 usernameMountainOakProperties
 passwordde66630c678d1e389d6693754f7b541ad5e428f5
 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
 descriptionMountain Oak Properties is the exclusive representative for Leverage Global Partners in Asheville, North Carolina, USA. As Western North Carolina's premier real estate firm, Mountain Oak Properties was founded on the principle that individualized service and attention define the real estate experience. With over three decades of combined sales and marketing experience – both in the residential and development segments - our founding partners are completely committed to building Western North Carolina's leading resource for buying and selling real estate in Western North Carolina. Mountain Oak Properties’ agents live and work in some of the areas most popular communities. Our trained team is dedicated, reliable, honest and resourceful. Whether you are prepared to purchase your first home, are relocating to the area, buying a piece of property or downsizing, we want to be your exclusive resource for all things real estate. Our company was founded in 2013 by three ambitious partners, Sean McLaughlin, Kevin Scarmack, and Mitch Miller, committed to creating a premium customer service experience for clients who trust in our mission. Individually, each partner has extensive experience in the development segment of the business. Sean and Mitch were previously employed at The Cliffs Communities, an exclusive set of golf communities in North and South Carolina. Kevin worked for Land Resource Companies, who developed several high-end communities throughout the Southeast. We specialize in working with clients from around the world who are looking to retire or buy a second home in the Carolinas.
 communities
 websitehttp://www.mountainoakproperties.com/
 address32 All Souls Crescent
 address_2Suite 202
 cityAsheville
 stateNC
 full_stateNorth Carolina
 countryUSA
 marketAsheville
 market_2
 postal_code28803
 phone (828) 318-8801
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameSean McLaughlin, Kevin Scarmack, Mitch Miller
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwners
 contact_dre_num
 contact_quoteYour Resource for All Things Real Estate in Western North Carolina.
 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_filename113.jpg
 logo_filename113.png
 contact_image_filename113.jpg
 all_properties_link_image_filename113.jpg
 all_properties_linkhttp://www.mountainoakproperties.com/our-listings/
 video_embed_code<iframe width="560" height="315" src="//www.youtube.com/embed/Ghik1qR1cDI" frameborder="0" allowfullscreen></iframe>
 contact_video_embed_code
 meta_titleAsheville Real Estate | Mountain Oak Properties | Leverage Global Partners
 meta_descriptionMountain Oak Properties is the exclusive representative for Leverage Global Partners in Asheville, North Carolina, USA.
 meta_keywordsMountain Oak Properties, Asheville Real Estate, Kevin Scarmack, Mitch Miller, Sean McLaughlin, Asheville North Carolina, 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-04-23 13:20:21
 modified2016-04-08 16:34:09
 dre_num012345
 uri/brokerage-detail/113/mountain-oak-properties
 website_shortwww.mountainoakproperties.com
 name_with_locationMountain Oak Properties
 Logo(array)
 id2578
 modelBrokerage
 model_id113
 tagLogo
 name113.png
 typeimage/png
 size57326
 uri/assets/2578.png
 order0
 created2016-03-30 11:41:11
 modified2016-03-30 11:41:11
 2(array)
 Brokerage(array)
 id17
 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
 WOEID2450022
 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
 nameShelton and Stewart Realtors
 broker_of_record_name
 short_nameShelton and Stewart Realtors
 usernameSheltonStewart
 password1266fa776158a05774ae9d7bf451b6f5cbca91e4
 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
 descriptionShelton and Stewart Realtors is the exclusive representative for Leverage Global Partners in Coconut Grove, Coral Gables, Pinecrest, and South Miami, Florida, USA. Shelton and Stewart Realtors, LLC is South Florida’s Premier Real Estate Boutique specializing in residential, commercial and industrial properties. Miami Dade County is one of the most affluent destinations in the world and is known for its numerous upscale neighborhoods and incredible selection of luxury homes ranging from waterfront properties to exclusive gated communities. Shelton and Stewart Realtors has over 100 associates that provide broad market coverage and knowledge for both buyers and sellers of homes, town houses, waterfront and lakefront homes, new homes, gated communities and condominium units spanning a wide array of communities including Coral Gables, Cocoplum, Brickell, Key Biscayne, Pinecrest, Palmetto Bay, South Miami, Miami Beach, Kendall, Cutler Bay, Doral and other South Florida residential areas. Shelton and Stewart’s success is attributable to the very personalized service provided by the partners and associates combined with traditional marketing channels of communication coupled with state of the art technology. The number of recurring customers and the relationships that have been developed throughout the years is a testament to the company’s success.
 communitiesCoral Gables Florida FL USA South Miami Florida FL USA Coconut Grove Florida FL USA Pinecrest Florida FL USA
 websitehttp://www.sheltonandstewart.com/
 address6301 Sunset Drive
 address_2Suite 202
 citySouth Miami
 stateFL
 full_stateFlorida
 countryUSA
 marketMiami - South
 market_2
 postal_code33143
 phone(305) 666-0669
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTere Shelton Bernace
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-tere-shelton-bernace-shelton-and-stewart-realtors-coral-gables-florida/
 contact_big_profile_link_text
 contact_titleManaging Partner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename17.jpg
 logo_filename17.jpg
 contact_image_filename17.JPG
 all_properties_link_image_filename17.JPG
 all_properties_linkhttp://www.sheltonandstewart.com/find-your-home/featured-properties.aspx
 video_embed_code
 contact_video_embed_code
 meta_titleCoral Gables Real Estate | Shelton and Stewart Realtors | Leverage Global Partners
 meta_descriptionShelton and Stewart Realtors is the exclusive representative for Leverage Global Partners in Coral Gables, Florida, USA.
 meta_keywordscoral gables real estate, shelton and stewart realtors, tere shelton bernace, south miami 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)
 created2013-04-01 15:38:39
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/17/shelton-and-stewart-realtors
 website_shortwww.sheltonandstewart.com
 name_with_locationShelton and Stewart Realtors
 Logo(array)
 id2281
 modelBrokerage
 model_id17
 tagLogo
 name17.jpg
 typeimage/jpg
 size379825
 uri/assets/2281.jpg
 order0
 created2016-03-30 11:36:19
 modified2016-03-30 11:36:19
 3(array)
 Brokerage(array)
 id155
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties1
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2480894
 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
 nameSmall & Associates Real Estate
 broker_of_record_name
 short_nameSmall & Associates Real Estate
 usernameSmallAssociatesRealEstate
 passwordd16e623ad2ac5d8c1266af342ea6f1394f860fb3
 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
 descriptionSmall & Associates Real Estate is the exclusive representative for Leverage Global Partners in Richmond, Chesterfield County, Goochland County, Henrico County, Hanover County, Virginia, USA. When Chris Small named his real estate company Small & Associates, it wasn’t because of his surname. It was also because of his vision – a vision for a close-knit “family” of real estate professionals bonded by a commitment to always making the customer’s needs their first priority. Chris soon found that his “quality over quantity” approach was appreciated not only by the company’s elite clientele, but also by many of the best agents Richmond has to offer. One by one they joined Small & Associates, along the way building an unsurpassed reputation for outstanding real estate services. So the next time you’re buying or selling a home or a property, For Big Result, Think Small. When it comes to Richmond real estate, size does matter. At Small & Associates Real Estate, owner and founder Chris Small never desired to create another large, faceless real estate behemoth. Instead he set out to develop a small, tight-knit company that put quality over quantity and took pride in providing an elevated level of personal service to fellow Richmond residents.  That was in 1982. Today, Small & Associates has earned a sterling reputation throughout the region for living up to Chris’s lofty ideals. The company’s strong local connections and independent ownership provide a superior alternative to the franchises and huge, corporate-owned companies.
 communitiesRichmond Chesterfield County Goochland County Henrico County Hanover County
 websitehttp://www.smallrealestate.com/#&panel1-1
 address5413 Patterson Avenue
 address_2Suite 200
 cityRichmond
 stateVA
 full_stateVirginia
 countryUSA
 market
 market_2
 postal_code23226
 phoneOffice: (804) 343-6860
 phone_2Mobile: (804) 350-0879
 phone_3
 wide_contact_image(false)
 contact_nameChris Small
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename155.jpg
 logo_filename155.jpg
 contact_image_filename155.jpg
 all_properties_link_image_filename155.jpg
 all_properties_linkhttp://smallrealestate.com/main/homes?isfeatured=1&isnew
 video_embed_code
 contact_video_embed_code
 meta_titleRichmond Real Estate | Small & Associates Real Estate | Leverage Global Partners
 meta_descriptionSmall & Associates Real Estate is the exclusive representative for Leverage Global Partners in Richmond, Virginia, USA.
 meta_keywordsSmall & Associates Real Estate, Richmond Real Estate, Chesterfield County Real Estate, Goochland County Real Estate, Henrico County Real Estate, Real Estate Hanover County
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-08-26 18:10:55
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/155/small-associates-real-estate
 website_shortwww.smallrealestate.com/#&panel1-1
 name_with_locationSmall & Associates Real Estate
 Logo(array)
 id2698
 modelBrokerage
 model_id155
 tagLogo
 name155.jpg
 typeimage/jpg
 size206231
 uri/assets/2698.jpg
 order0
 created2016-03-30 11:42:31
 modified2016-03-30 11:42:31
- sidebar_locations(array)
 0(array)
 Location(array)
 id99
 parent_id8
 brokerage_id203
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameTryon, NC, USA
 short_nameTryon, NC, USA
 group_index
 latitude35.208168
 longitude-82.238449
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-05 13:24:07
 modified2016-04-05 13:24:07
 timezoneAmerica/New_York
 population1600
 uri/locations/view/99/tryon-nc-usa
 tile_nameTryon, NC, USA
 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
 Image(array)
 id3033
 modelLocation
 model_id99
 tagImage
 nameTryon.jpg
 typeimage/jpeg
 size127559
 uri/assets/3033.jpg
 order0
 created2016-04-05 13:23:13
 modified2016-04-05 13:24:07
 1(array)
 Location(array)
 id142
 parent_id8
 brokerage_id152
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameEastern Shore, Chesapeake Bay, VA, USA
 short_nameEastern Shore, Chesapeake Bay, VA, USA
 group_index
 latitude36.686474
 longitude-76.228386
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionEnjoy a Serene Costal Lifestyle in Virginia's Scenic Eastern Shore
 long_descriptionVirginia’s Scenic Eastern Shore is a slender, peninsula tucked between the Atlantic Ocean and the Chesapeake Bay. An easy drive to Virginia Beach, Virginia across the Chesapeake Bay Bridge-Tunnel, the Shore offers relaxed, coastal lifestyles and a variety of both unimproved land and fine homes in colorful little towns and in rural areas with a private soft sand beach, or a dock on a Bay or Ocean tributary. Small to large acreages and farms are available as well as historic homes and charming new homes in the Palmer and Nicklaus golf courses. Serene and pristine, the natural beauty of the Shore is unmatched, and its magnificent Barrier Islands comprise one of the United Nation’s protected Biospheres.
 created2016-04-07 16:09:27
 modified2016-04-14 10:56:03
 timezoneAmerica/New_York
 population45000
 uri/locations/view/142/eastern-shore-chesapeake-bay-va-usa
 tile_nameEastern Shore, Chesapeake Bay, VA, USA
 Brokerage(array)
 id152
 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
 WOEID2443743
 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
 nameBlue Heron Realty Co.
 broker_of_record_name
 short_nameBlue Heron Realty Co.
 usernameBlueHeronRealty
 password40b7904098026a8745b6e14ff8e6be8e61a5cc86
 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
 descriptionBlue Heron Realty Co. is the exclusive representative for Leverage Global Partners on Virginia's Eastern Shore including, Cape Charles, Machipongo, Nassawadox, Wachapreague, Chincoteague, Onancock, Accomack County, Northampton County, and in the Chesapeake Bay area, Virginia, USA. The picturesque Eastern Shore of Virginia is a slender peninsula located one half hour north of Virginia Beach, Virginia. It is the pristine tip of the Delmarva Peninsula, bordered on the west by the Chesapeake Bay and on the east by the Atlantic Ocean. Blue Heron is a full-service boutique firm specializing in luxury beachfront, boating and golf homes and lots and land acreage. As a market leader of Eastern Shore waterfront estates, we offer the highest level of service and expertise to our clients. Although we are a small firm with less than 15 agents, Blue Heron’s dedication to the needs of our clients has made us a top volume office in our MLS for many years. The Eastern Shore offers a delightful and unique quality of life not only for those who are looking for the sweet waterfront lifestyle but also for small town and historic home buffs since the discovery and colonization of Virginia’s Eastern Shore dates all the way back to 1608, Capt. John Smith and Pocahontas. Although we are still in a pristine rural area, replete with beautiful family farms and working watermen, we also have amazing waterfront properties and two gorgeous Bayfront Signature golf courses, a Jack Nicklaus and an Arnold Palmer, making it possible to offer our buyer clients choices for capturing our relaxing “beach-boating-golf” coastal lifestyles.
 communitiesEastern Shore Accomack County Northampton County Cape Charles Eastville Machipongo Nassawadox Wachapreague Chincoteague Onancock
 websitehttp://www.blueheronva.com/
 address7134 Wilsonia Neck Drive
 address_2P.O. Box 1
 cityMachipongo
 stateVA
 full_stateVirginia
 countryUSA
 marketEastern Shore, Chesapeake Bay
 market_2
 postal_code23405
 phone(757) 678-5200
 phone_2
 phone_3
 wide_contact_image(true)
 contact_nameLemoin, Montaigne & Marlene Cree
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleFounders
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Eastern Shore real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename152.jpg
 logo_filename152.jpg
 contact_image_filename152.jpg
 all_properties_link_image_filename152.jpg
 all_properties_linkhttp://www.blueheronva.com/properties/
 video_embed_code
 contact_video_embed_code
 meta_titleEastern Shore Real Estate | Blue Heron Realty Co. | Leverage Global Partners
 meta_descriptionBlue Heron Realty Co. is the exclusive representative for Leverage Global Partners in Eastern Shore, Virginia, USA.
 meta_keywordsBlue Heron Realty Co., Eastern Shore Real Estate, Lemoin & Marlene Cree, Eastern Shore Real Estate, Accomack County Real Estate, Northampton County Real Estate, Cape Charles Real Estate, Eastville Real Estate, Machipongo Real Estate, Nassawadox Real Estate, Wachapreague Real Estate, Chincoteague Real Estate, Onancock 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-08-18 17:03:28
 modified2016-04-18 13:06:26
 dre_num012345
 uri/brokerage-detail/152/blue-heron-realty-co
 website_shortwww.blueheronva.com
 name_with_locationBlue Heron Realty Co.
 Image(array)
 id8296
 modelLocation
 model_id142
 tagImage
 nameBlue Heron.jpg
 typeimage/jpeg
 size131696
 uri/assets/8296.jpg
 order0
 created2016-04-07 16:07:56
 modified2016-04-14 10:56:03
 2(array)
 Location(array)
 id100
 parent_id6
 brokerage_id36
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameSydney North Shore, Australia
 short_nameSydney North Shore, Australia
 group_index
 latitude-33.753227
 longitude150.705200
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-05 13:27:10
 modified2016-04-05 13:27:10
 timezoneAustralia/Sydney
 population207000
 uri/locations/view/100/sydney-north-shore-australia
 tile_nameSydney North Shore, Australia
 Brokerage(array)
 id36
 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_id10
 WOEID1105779
 timezoneAustralia/Sydney
 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
 nameBurns and Burns
 broker_of_record_name
 short_nameBurns and Burns
 usernameBurnsandBurns
 passwordbe51d1b789bbecb96033435959b9b44ba880003f
 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
 descriptionBurns and Burns is the exclusive representative for Leverage Global Partners on the North Shore and Upper North Shore of Sydney, Australia. Burns & Burns is a family business established for nearly 30 years and is one of the oldest continuing running real estate companies on the North Shore. Founded by Julia Burns, with husband Richard, son Andrew and daughter-in-law Catherine, the family concern has been blessed by long-term staff in both sales and support roles. This is shown by the strong work ethic and customer service, which results in 70% of the clients utilising Burns & Burns services being either repeat or referral customers. Julia and Andrew Burns have dominated the prestige market for over 30 years and, as such, have a track record and network unequalled on the North Shore. Indeed, it is no surprise that the highest sales records for the Upper North Shore are held by Burns & Burns in Pymble and Wahroonga. Knox Grammar School and other institutions have repeatedly used the trusted service of Burns & Burns over the last 30 years being the highest recommendation and of which the family are very proud. However, Burns & Burns deal in ALL price ranges and many of our staff have ‘grown-up’ with their clients, as they move from property to property which is the backbone of the firm and will continue to be so.
 communitiesUpper North Shore of Sydney, Australia North Shore of Sydney, Australia
 websitehttp://burnsandburns.com.au/home
 address1051 Pacific Highway
 address_2
 cityPymble
 state
 full_state
 countryAustralia
 marketSydney North Shore
 market_2
 postal_codeNSW 2073
 phone(+) 61 (0) 2 9449 9211
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameAndrew Burns
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-andrew-burns-director-of-burns-and-burns/
 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_filename36.jpg
 logo_filename36.jpg
 contact_image_filename36.jpg
 all_properties_link_image_filename36.jpg
 all_properties_linkhttp://burnsandburns.com.au/listings/ressale
 video_embed_code
 contact_video_embed_code
 meta_titleSydney North Shore Real Estate | Burns and Burns | Leverage Global Partners
 meta_descriptionBurns and Burns is the exclusive representative for Leverage Global Partners in North Shore Sydney, Australia.
 meta_keywordsBurns & Burns, Burns & Burns real estate, North Shore Sydney real estate, Sydney Australia, Andrew Burns, 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-06-19 10:54:50
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/36/burns-and-burns
 website_shortburnsandburns.com.au/home
 name_with_locationBurns and Burns
 Image(array)
 id3034
 modelLocation
 model_id100
 tagImage
 namesydney.jpg
 typeimage/jpeg
 size118591
 uri/assets/3034.jpg
 order0
 created2016-04-05 13:25:05
 modified2016-04-05 13:27:10
 3(array)
 Location(array)
 id170
 parent_id7
 brokerage_id182
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameGlastonbury, CT, USA
 short_nameGlastonbury, CT, USA
 group_index
 latitude41.686180
 longitude-72.545074
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 18:39:55
 modified2016-04-12 18:42:40
 timezoneAmerica/New_York
 population0
 uri/locations/view/170/glastonbury-ct-usa
 tile_nameGlastonbury, CT, USA
 Brokerage(array)
 id182
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties4
 membership_luxury_feed_properties4
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2410661
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts[email protected]
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameExecutive Real Estate
 broker_of_record_name
 short_nameExecutive Real Estate
 usernameExecutiveRealEstate
 password4c47b873ee3bf155444a6c1e0983923d63eb4293
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionExecutive Real Estate is the exclusive representative for Leverage Global Partners in Hartford, Middlesex and Tolland counties, CT, USA. My Story, I began in real estate at the ripe age of 18. Right out of high school I worked at Century 21 in Glastonbury Village Green and felt as if I was this little girl in the big world of Real Estate. My first few months were hard, I felt as if I was spinning my wheels and having to borrow gas money to get to my appointments. My current office manager, Armand, who was my broker at that time, offered a trip to New York all-expenses paid which could be won through a contest. Being 18 I had never been to NYC so I thought it would be amazing to win the contest and the trip; 10 transactions in one month. I plotted a plan to do just that. Once again I borrowed money to get gas and food and went on a mission. I sought out and then knocked on doors of ‘for sale by owners’ and ‘expireds’. I was so wide eyed and eager to win that trip I informed every potential seller and buyer that I needed to not only list, but sell their home immediately to win the trip. I won the trip. I found that setting a GOAL had helped me achieve what I truly wanted. I then spent every month setting and obtaining those goals. At the age of 21 I was driving a Lincoln; I had a nicer car than most agents around me at the time. I was also pregnant with my first child. This seemed scary as I was making great sales, so my new goal was to stock up on my finances and secure a future for my baby boy. I knew the in and outs of Real Estate and only in a few short years living as an agent, I had superseded all my goals which happen to make me the Century 21 1997 Top 10 Producers in the state of CT. I was the Century 21 Top Producer. I calculated my career path and got extremely large, so large that my business model outgrew me. I had arranged a team of Agents for fielding my buyer calls and I maintained my personal referrals. The agents started to flock around me and after years of flourishing in this fashion my team came to me and asked if I would open my own firm. My team, the founding agents of Executive Real Estate, formed with me a new business entity. We immediately became one of the largest independent offices in our local Realtor market. We were all scared about venturing off on our own. But the simple truth is that if your Customer Service is held to the highest standard then growth is unstoppable. Our clients then began to grow our business; the personal referrals to all of our executive agents had flourished. Today, we are over 50 agents strong and always growing!
 communitiesGlastonbury Hartford County Middlesex County Tolland County
 websitehttp://www.executiverealestatellc.com/
 address17 School Street
 address_2
 cityGlastonbury
 stateCT
 full_stateConnecticut
 countryUSA
 market
 market_2
 postal_code06033
 phoneCell: (860) 916-6048
 phone_2Office: (860) 633-8800
 phone_3
 wide_contact_image(false)
 contact_nameAmy Rio
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner/Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename182.jpg
 logo_filename182.jpg
 contact_image_filename182.png
 all_properties_link_image_filename182.jpg
 all_properties_link
 video_embed_code<iframe width="560" height="315" src="https://www.youtube.com/embed/mlI0ztD_zGo?controls=0&showinfo=0" frameborder="0" allowfullscreen></iframe>
 contact_video_embed_code
 meta_titleGlastonbury Real Estate⎜Executive Real Estate⎜Leverage Global Partners
 meta_descriptionExecutive Real Estate is the exclusive representative for Leverage Global Partners in Hartford, Middlesex and Tolland counties, CT, USA.
 meta_keywordsExecutive Real Estate, Leverage Global Partners, Hartford Real Estate, Middlesex Real Estate, Tolland Real Estate, Connecticut Real Estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-01-15 11:28:32
 modified2022-01-13 09:51:32
 dre_num012345
 uri/brokerage-detail/182/executive-real-estate
 website_shortwww.executiverealestatellc.com
 name_with_locationExecutive Real Estate
 Image(array)
 id20736
 modelLocation
 model_id170
 tagImage
 nameScreen Shot 2016-04-12 at 6.40.19 PM.png
 typeimage/png
 size1124721
 uri/assets/20736.png
 order0
 created2016-04-12 18:42:37
 modified2016-04-12 18:42:40
- location_properties(empty)
- main_article(empty)
- brokerage(array)
 Brokerage(array)
 id226
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id0
 WOEID2489025
 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
 nameSaraBay Real Estate, Inc.
 broker_of_record_name
 short_nameSaraBay Real Estate, Inc.
 usernameSaraBayRE
 password9c132b442137deb2cc4f5844ca409d070fd64b83
 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
 descriptionSaraBay Real Estate Inc. is the exclusive representative for Leverage Global Partners in Sarasota, Bradenton, Lakewood Ranch, Longboat Key, Palmetto, and Myakka City, FL, USA. About SaraBay… SaraBay Real Estate is a locally owned and operated luxury boutique real estate company consisting of an exclusive group of experienced real estate professionals. Every SaraBay agent is a real estate professional you can trust, with a history of success and integrity that you can depend on. Each is an experienced negotiator with expert knowledge of the local market. SaraBay’s commitment to Buyers is that we will get you the best price on a home that is perfectly suited to your needs and lifestyle – not just today, but for years to come. The commitment to Sellers is that we will use our knowledge and expertise to price your home competitively, to market it aggressively, and help you reach your real estate goals in as little time as possible. Choosing a real estate agent who has the tools, skills and experience to make dreams come true can be as challenging as the buying or selling process itself. Let us make it simple… at SaraBay, our real estate professionals have the knowledge, the expertise and desire to work with you and help your move be as seamless as possible.
 communitiesSarasota Bradenton Lakewood Ranch Longboat Key Palmetto Myakka City
 websitehttp://www.sarabay.com/
 address7333 North Tamiami Trail
 address_2
 citySarasota
 stateFL
 full_stateFlorida
 countryUSA
 market
 market_2
 postal_code34243
 phoneCell: (941) 348-3448
 phone_2Office: (941) 355-7696
 phone_3
 wide_contact_image(false)
 contact_nameMichael Holderness, Jr., Mike Holderness, Sr.
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwners/ Agents
 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_filename226.jpg
 logo_filename226.png
 contact_image_filename226.jpg
 all_properties_link_image_filename226.jpg
 all_properties_linkhttp://www.sarabay.com/rets/
 video_embed_code
 contact_video_embed_code
 meta_titleSarasota Real Estate | SaraBay Real Estate, Inc. | Leverage Global Partners
 meta_descriptionSaraBay Real Estate Inc. is the exclusive representative for Leverage Global Partners in Sarasota, Bradenton, Lakewood Ranch, Longboat Key, Palmetto, and Myakka City, FL, USA.
 meta_keywordsSaraBay Real Estate Inc., Leverage Global Partners, Sarasota Real Estate, Bradenton Real Estate, Lakewood Ranch Real Estate, Longboat Key Real Estate, Palmetto Real Estate, Myakka City Real Estate, Florida Real Estate, USA Real Estate.
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-09-29 14:14:10
 modified2016-04-08 16:34:31
 dre_num012345
 uri/brokerage-detail/226/sarabay-real-estate-inc
 website_shortwww.sarabay.com
 name_with_locationSaraBay Real Estate, Inc. - Sarasota, FL, USA
 AccountExecutive(array)
 id236
 typeAccountExecutive
 brokerage_id0
 email[email protected]
 passworde5cc5a96287695cf8b7cace1463b1699895dcf92
 recover_hash
 first_nameLauren
 last_namePena
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2020-12-23 09:21:16
 created2016-04-14 15:43:52
 notified(false)
 full_nameLauren Pena
 uri/agent-detail/236/lauren-pena
 profile_complete(true)
 Logo(array)
 id2893
 modelBrokerage
 model_id226
 tagLogo
 name226.png
 typeimage/png
 size124589
 uri/assets/2893.png
 order0
 created2016-03-30 11:45:12
 modified2016-03-30 11:45:12
 MainImage(array)
 id2892
 modelBrokerage
 model_id226
 tagMainImage
 name226.jpg
 typeimage/jpg
 size2191290
 uri/assets/2892.jpg
 order0
 created2016-03-30 11:45:11
 modified2016-03-30 11:45:11
 ContactImage(array)
 id2894
 modelBrokerage
 model_id226
 tagContactImage
 name226.jpg
 typeimage/jpg
 size185670
 uri/assets/2894.jpg
 order0
 created2016-03-30 11:45:12
 modified2016-03-30 11:45:12
 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)
 id67
 parent_id8
 brokerage_id226
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameSarasota, FL, USA
 short_nameSarasota, FL, USA
 group_index
 latitude37.090240
 longitude-95.712891
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionSarasota, Florida is one of 2016's Best Places to Live!
 long_descriptionImagine… Sand beneath your feet, the sight of emerald fairways, or waiting for the overture to start. Discover your way of life with prices ranging from $100,000 – $20,000,000+. Tropical Climate, Gorgeous Beaches, Arts, Culture, Outdoor Activities, Affordable Housing and a Relaxed Lifestyle await you on Florida’s “Sun Coast!" Beach-front Homes & Condos, Beach Cottages, Stunning Mansions, Luxury Golf Course homes, “Florida-style” bungalows as well as traditional Family homes – all within 30 minutes of USA’s #1 Beach, Shopping on St. Armand’s Circle, Downtown Arts & Culture, Restaurants, Polo fields, Skull & Rowing facilities, World-Class Golf Courses, and more.
 created2016-04-04 17:19:05
 modified2016-04-04 17:19:05
 timezoneAmerica/New_York
 population1000000
 uri/locations/view/67/sarasota-fl-usa
 tile_nameSarasota, FL, USA
 User(array)
 0(array)
 id204
 typeBrokerageAdmin
 brokerage_id226
 email[email protected]
 password9c132b442137deb2cc4f5844ca409d070fd64b83
 recover_hash
 first_name
 last_name
 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:32:02
 created2016-04-08 16:34:31
 notified(true)
 full_name
 uri/agent-detail/204/
 profile_complete(false)
 1(array)
 id1218
 typeAgent
 brokerage_id226
 email[email protected]
 passworde725213935ed946500ba7740acaf9e969e930c53
 recover_hash
 first_nameLISA
 last_nameKARTZ
 title
 dre_num
 phone941-587-3602
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:59
 created2017-08-07 15:23:59
 notified(false)
 full_nameLISA KARTZ
 uri/agent-detail/1218/lisa-kartz
 profile_complete(true)
 2(array)
 id1219
 typeAgent
 brokerage_id226
 email[email protected]
 password88f69e44850d3f6ee6ee2c4ccf39f769384f868f
 recover_hash
 first_nameMike
 last_nameHolderness, Sr.
 title
 dre_num
 phone941-356-0685
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:59
 created2017-08-07 15:23:59
 notified(false)
 full_nameMike Holderness, Sr.
 uri/agent-detail/1219/mike-holderness-sr
 profile_complete(true)
 3(array)
 id1266
 typeAgent
 brokerage_id226
 email[email protected]
 password7a6ec18fdedf5d7055ae4141a3d3280e9d1150ab
 recover_hash
 first_nameApril
 last_nameTisdale
 title
 dre_num
 phone941-735-9926
 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_nameApril Tisdale
 uri/agent-detail/1266/april-tisdale
 profile_complete(true)
- location(array)
 Location(array)
 id67
 parent_id8
 brokerage_id226
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameSarasota, FL, USA
 short_nameSarasota, FL, USA
 group_index
 latitude37.090240
 longitude-95.712891
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionSarasota, Florida is one of 2016's Best Places to Live!
 long_descriptionImagine… Sand beneath your feet, the sight of emerald fairways, or waiting for the overture to start. Discover your way of life with prices ranging from $100,000 – $20,000,000+. Tropical Climate, Gorgeous Beaches, Arts, Culture, Outdoor Activities, Affordable Housing and a Relaxed Lifestyle await you on Florida’s “Sun Coast!" Beach-front Homes & Condos, Beach Cottages, Stunning Mansions, Luxury Golf Course homes, “Florida-style” bungalows as well as traditional Family homes – all within 30 minutes of USA’s #1 Beach, Shopping on St. Armand’s Circle, Downtown Arts & Culture, Restaurants, Polo fields, Skull & Rowing facilities, World-Class Golf Courses, and more.
 created2016-04-04 17:19:05
 modified2016-04-04 17:19:05
 timezoneAmerica/New_York
 population1000000
 uri/locations/view/67/sarasota-fl-usa
 tile_nameSarasota, FL, USA
 Image(array)
 id2999
 modelLocation
 model_id67
 tagImage
 name39922990_siesta_key.jpg
 typeimage/jpeg
 size68270
 uri/assets/2999.jpg
 order0
 created2016-04-04 17:13:53
 modified2016-04-04 17:19:05
- 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/67/sarasota-fl-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/locations/view/67/sarasota-fl-usa
Remote Port	17034
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 Cf Ray	a09da6d1f9ce3191-CMH
Http Accept Encoding	gzip, br
Http Cookie	CAKEPHP=jru6jkl5ujtrpvebu7a1g0ht5a
Http Accept	/
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
Http X Forwarded For	216.73.216.172
Proxy-nokeepalive	1
Ssl Tls Sni	staging2.leveragere.com
Https	on
Passenger Download Native Support Binary	0
Passenger Compile Native Support Binary	0
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Unique Id	aiowgu8a9lJ8yShPtH28XQAAAsQ
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	aiowgu8a9lJ8yShPtH28XQAAAsQ
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781149826.8992
Request Time	1781149826

====

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

Sarasota, FL, 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: 18 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: 18 ms
Total Queries: 19 queries