Locations / Jackson Hole, WY, USA

Jackson Hole, WY, USA

One of the world’s most unique places; Recognized for our stunning natural beauty, diverse ecosystems, and abundant wildlife, Jackson Hole is a destination unparalleled in the mountain west. Uniquely located in the heart of 2.7 million protected acres of beautiful unspoiled mountain ranges, wilderness areas, wildlife refuges, National Parks, and rivers; 97% of our land is protected, leaving the 3% of developable property highly desirable with views that will never change. The region’s lifestyle benefits are matched only by the financial benefits of Wyoming Residency. The surreal natural beauty of the area is the perfect place to experience outdoor adventure paired with distinct western culture.

Location Represented By

License #: 012345

9.6 thousand population

Partner Search

Find partners with a map-based search

Related Locations

Related Partners

Recent Property Listings

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

Array
(
)

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

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

Message	Memory use
Component initialization	2.88 MB
Controller action start	3.81 MB
Controller render start	6.66 MB
View render complete	7.21 MB

Timers

Total Request Time: 276 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	38.05
Event: Controller.initialize	6.02
Event: Controller.startup	1.95
Controller action	78.87
Event: Controller.beforeRender	18.54
» Processing toolbar data	18.42
Rendering View	84.11
» Event: View.beforeRender	0.28
» Rendering APP/View/Locations/view.ctp	2.66
» » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.14
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.20
» » Rendering APP/View/Elements/sidebar/brokerage_list.ctp	0.17
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.30
» » » Rendering APP/View/Elements/static_property_price.ctp	0.40
» » » Rendering APP/View/Elements/static_property_price.ctp #2	0.16
» » » Rendering APP/View/Elements/static_property_price.ctp #3	0.16
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.21
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	80.37
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- sidebar_properties(array)
 0(array)
 Property(array)
 id3723
 brokerage_id157
 created_by_user_id0
 order2
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameRenovated 2 story expanded ranch
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(false)
 descriptionRenovated 2 story expanded ranch features a chefs kit w/adjoining family room, spacious living room & dining room with a wall of windows and French doors that lead to the incredible backyard setting that is wonderful to bbq, dine and entertain. There is a first floor luxurious master bedroom suite while the second floor includes three additional bedrooms plus an en-suite. The walk-out lower level boasts a recreation room, office, exercise room, art room, two full baths and loads of storage. Close-by to the #1 Deerfield elementary school, children are bused to the highly rated Millburn Middle School and Millburn High School.
 address90 Troy Drive
 address_2
 cityShort Hills
 stateNJ
 postal_code07078
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1595000
 price_20
 price_usd1595000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms5
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitewww.90TroyDr.com
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude40.754322
 longitude-74.312920
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 00:33:02
 created2016-04-13 07:00:07
 uri/property-detail/3723/90-troy-drive-short-hills-nj-07078-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3723/90-troy-drive-short-hills-nj-07078-usa
 address_concat90 Troy Drive Short Hills NJ 07078 USA
 google_maps_query_string90+Troy+Drive++Short+Hills+NJ+07078+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,595,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty5
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2016-04-13
 overridden_brokerage_nameTowne Realty Group
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id157
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2493140
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameTowne Realty Group
 broker_of_record_name
 short_nameTowne Realty Group
 usernameTowneRealtyGroup
 passworda4249a6dfad6cc2af05068e244f79544fefc464e
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionTowne Realty Group is the exclusive representative for Leverage Global Partners in Short Hills, Essex County, Morris County, Union County, New Jersey, USA. Towne Realty Group, LLC, is a real estate boutique in Short Hills, NJ, with unparalleled real estate market knowledge and experience. Our agents are tenacious advocates for your interests and we are a paperless company – all of our business is conducted electronically in the cloud. Our team of 25 professionals are all full-time pros, unmatched in the industry for their attention to detail. Our powerful marketing and advertising programs across dozens of websites and social media platforms, will help sell your home, and our deep roots in our local communities will serve you well as a buyer. We have transacted over $1 Billion in sales since we opened our doors in 2006. Our agents know the local markets in New Jersey - if it happens in Millburn, Short Hills, Maplewood, South Orange, West Orange, Summit, Livingston, Chatham, Madison, Florham Park, New Providence, Springfield, Montclair, Westfield, Cranford or surrounding towns in Essex, Morris, and Union, our agents know about it. We welcome the opportunity to assist you with any questions in our local real estate market.
 communitiesShort Hills Essex County Morris County Union County Somerset County
 websitehttp://www.trghome.com/
 address511 Millburn Avenue
 address_2
 cityShort Hills
 stateNJ
 full_stateNew Jersey
 countryUSA
 market
 market_2
 postal_code
 phoneKaren Mobile: (201) 417-1600
 phone_2Daniel Mobile: (973) 865-4144
 phone_3Barbara's Mobile: (908) 347-6945
 wide_contact_image(false)
 contact_nameKaren Bigos, Barbara Birkitt, Daniel Cannizzo
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-karen-biggs-daniel-cannizzo-towne-realty-group/
 contact_big_profile_link_textMeet Karen Bigos, Barbara Birkitt, Daniel Cannizzo
 contact_titleOwner/Managing Partner, Sales Manager/Broker of Record, Owner/Managing Partner
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Short Hills & Summit, NJ real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3[email protected]
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename157.jpg
 logo_filename157.JPG
 contact_image_filename157.jpg
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_titleShort Hills Real Estate | Towne Realty Group | Leverage Global Partners
 meta_description Towne Realty Group is the exclusive representative for Leverage Global Partners in Short Hills, New Jersey, USA.
 meta_keywordsTowne Realty Group, Short Hills Realty Group, Karen Bigos, Short Hills Real Estate, Essex County Real Estate, Morris County Real Estate, Union County Real Estate, Somerset County Real Estate, New Jersey Real Estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-09-02 15:10:33
 modified2021-07-18 10:38:47
 dre_num012345
 uri/brokerage-detail/157/towne-realty-group
 website_shortwww.trghome.com
 name_with_locationTowne Realty Group
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id20756
 modelProperty
 model_id3723
 tagImage
 namefront.jpg
 typeimage/jpeg
 size2812943
 uri/assets/20756.jpg
 order0
 created2016-04-13 06:58:25
 modified2016-04-13 07:00:07
 1(array)
 id20761
 modelProperty
 model_id3723
 tagImage
 namelv.jpg
 typeimage/jpeg
 size1636475
 uri/assets/20761.jpg
 order1
 created2016-04-13 06:59:08
 modified2016-04-13 07:00:07
 2(array)
 id20763
 modelProperty
 model_id3723
 tagImage
 namekitchen-2.jpg
 typeimage/jpeg
 size1630226
 uri/assets/20763.jpg
 order2
 created2016-04-13 06:59:10
 modified2016-04-13 07:00:07
 3(array)
 id20764
 modelProperty
 model_id3723
 tagImage
 namedining.jpg
 typeimage/jpeg
 size1980966
 uri/assets/20764.jpg
 order3
 created2016-04-13 06:59:10
 modified2016-04-13 07:00:07
 4(array)
 id20765
 modelProperty
 model_id3723
 tagImage
 namefam.jpg
 typeimage/jpeg
 size1760572
 uri/assets/20765.jpg
 order4
 created2016-04-13 06:59:11
 modified2016-04-13 07:00:07
 5(array)
 id20760
 modelProperty
 model_id3723
 tagImage
 namemaster-2.jpg
 typeimage/jpeg
 size1430080
 uri/assets/20760.jpg
 order5
 created2016-04-13 06:59:08
 modified2016-04-13 07:00:07
 6(array)
 id20762
 modelProperty
 model_id3723
 tagImage
 namemaster-bath.jpg
 typeimage/jpeg
 size2001914
 uri/assets/20762.jpg
 order6
 created2016-04-13 06:59:09
 modified2016-04-13 07:00:07
 7(array)
 id20759
 modelProperty
 model_id3723
 tagImage
 nameback-2.jpg
 typeimage/jpeg
 size2933204
 uri/assets/20759.jpg
 order7
 created2016-04-13 06:58:28
 modified2016-04-13 07:00:07
 8(array)
 id20757
 modelProperty
 model_id3723
 tagImage
 nameback-5.jpg
 typeimage/jpeg
 size3078942
 uri/assets/20757.jpg
 order8
 created2016-04-13 06:58:26
 modified2016-04-13 07:00:07
 9(array)
 id20758
 modelProperty
 model_id3723
 tagImage
 nameback.jpg
 typeimage/jpeg
 size3265128
 uri/assets/20758.jpg
 order9
 created2016-04-13 06:58:27
 modified2016-04-13 07:00:07
 User(array)
 0(array)
 id1273
 typeAgent
 brokerage_id157
 email[email protected]
 passworde12a1c18f923d356c3701925712f3ec758f9f791
 recover_hash
 first_nameDonna
 last_nameShaw
 title
 dre_num
 phone973-879-3128
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:24:02
 created2017-08-07 15:24:02
 notified(false)
 full_nameDonna Shaw
 uri/agent-detail/1273/donna-shaw
 profile_complete(true)
 UsersProperty(array)
 id1101
 user_id1273
 property_id3723
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 1(array)
 Property(array)
 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)
 2(array)
 Property(array)
 id3736
 brokerage_id36
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameLIGHT, LOCATION & LIFESTYLE
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(false)
 descriptionOnce you stroll down the private driveway, you will be impressed with this adorable family home which is set amongst an abundance of colour and private gardens. <ul> <li>3 spacious bedrooms (with built-ins) master complete with ensuite</li> <li>Elegant formal lounge dining room perfect for the entertainer</li> <li>Fabulous eat in kitchen with an amazing family room adjoining</li> <li>Casual living area opens onto private sundrenched courtyard</li> <li>Superb level garden and very low maintenance</li> <li>R/C airconditioning, double lock up garage with an abundance of storage</li> </ul> All located within a short stroll to rail, shops and schools FOR SALE BY EXPRESSIONS OF INTEREST CLOSING 6th May 2016 @ 4:00pm
 address8A Fulbourne Avenue
 address_2Pennant Hills
 citySydney
 stateNSW
 postal_code2120
 countryAustralia
 use_lat_lng_for_google_map(false)
 currencyAUD
 price0
 price_20
 price_usd0
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms3
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_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
 websiteburnsandburns.com.au
 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
 latitude-33.733246
 longitude-33.733246
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-17 23:54:43
 created2016-04-17 22:42:58
 uri/property-detail/3736/8a-fulbourne-avenue-pennant-hills-sydney-nsw-2120-australia
 absolute_urihttps://staging2.leveragere.com/property-detail/3736/8a-fulbourne-avenue-pennant-hills-sydney-nsw-2120-australia
 address_concat8A Fulbourne Avenue Pennant Hills Sydney NSW 2120 Australia
 google_maps_query_string8A+Fulbourne+Avenue+Pennant+Hills+Sydney+NSW+2120+Australia
 luxury_ad_enrolled_prettyNO
 price_prettyAUD 0
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty2
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2016-04-17
 overridden_brokerage_nameBurns and Burns
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 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
 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)
 id20905
 modelProperty
 model_id3736
 tagImage
 name1.jpg
 typeimage/jpeg
 size5373805
 uri/assets/20905.jpg
 order0
 created2016-04-17 22:41:47
 modified2016-04-17 23:54:07
 1(array)
 id20906
 modelProperty
 model_id3736
 tagImage
 name4.jpg
 typeimage/jpeg
 size5572872
 uri/assets/20906.jpg
 order1
 created2016-04-17 22:42:03
 modified2016-04-17 23:54:07
 2(array)
 id20910
 modelProperty
 model_id3736
 tagImage
 name5.jpg
 typeimage/jpeg
 size6065798
 uri/assets/20910.jpg
 order2
 created2016-04-17 22:42:52
 modified2016-04-17 23:54:07
 User(array)
 0(array)
 id449
 typeAgent
 brokerage_id36
 email[email protected]
 password39b6d71111583a7407ade4068d52e9cecb5f7334
 recover_hash
 first_nameLee
 last_nameBurrows
 title
 dre_num
 phone612 9449 9211
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:58
 created2017-08-07 15:22:58
 notified(false)
 full_nameLee Burrows
 uri/agent-detail/449/lee-burrows
 profile_complete(true)
 UsersProperty(array)
 id282
 user_id449
 property_id3736
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 3(array)
 Property(array)
 id3708
 brokerage_id80
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id1224
 agent_2_id1225
 agent_3_id0
 nameDowntown Dupont Luxury
 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)
 descriptionConstructed in 2013, be the first to own this stunning contemporary light-filled duplex. Open living space flanked by floor-to-ceiling windows; balconies, roof deck and finishing details meld beautifully with this historic building's exterior in this prime Dupont location, only two blocks from Metro's Red Line. Main Entrance: Foyer Interior Style: Floor Plan-Open Dining/Kitchen: Gourmet, Kit-Island, Kit-Dining Combo, Liv-Din Combo Appliances: Oven / Range - Gas, Six Burner Stove, Refrigerator, Icemaker, Exhaust Fan, Dishwasher, Disposal, Dryer - Front Loading, Washer - Front Loading, Water Heater - High-Efficiency Amenities: Attached Master Bathroom, Bathroom(s) - Ceramic Tile, Bedroom - Entry Level, Built-in Bookcases, Closet - Master Bedroom Walk-in, Countertop(s) - Granite, Elevator, Vanities - Double, Whirlpool Jets, Wood Floors, Shades / Blinds, Master Bathroom - Separate Shower, High Efficiency Toilet(s), Closet(s) - Walk-in, Tub - Soaking Security: Fire Detect Sys, Main Entrance Lock, Spkler Sys-indoor Windows/Doors: Double Pane Windows, Recessed Lighting, Sliding Glass Door Walls/Ceilings: 9'+ Ceilings, Dry Wall, Plaster Walls
 address1737 Connecticut Avenue, NW, #502
 address_2
 cityWashington
 stateDC
 postal_code20009
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1575000
 price_20
 price_usd1575000
 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)
 bedrooms2
 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/1737-CONNECTICUT-AVENUE-NORTHWEST-502-WASHINGTON-DC-20009/DC9599732/30/
 meta_titleDowntown Dupont Luxury | Washington Real Estate | Evers & Co. Real Estate
 meta_description1737 Connecticut Avenue, NW, #502 is a property offered for sale in Washington, DC, 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=300033619913
 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_fieldssquare_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 14:18:15
 uri/property-detail/3708/1737-connecticut-avenue-nw-502-washington-dc-20009-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3708/1737-connecticut-avenue-nw-502-washington-dc-20009-usa
 address_concat1737 Connecticut Avenue, NW, #502 Washington DC 20009 USA
 google_maps_query_string1737+Connecticut+Avenue%2C+NW%2C+%23502++Washington+DC+20009+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,575,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty2
 bathrooms_pretty2
 bathrooms_partial_pretty1
 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)
 id80
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2514815
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameEvers & Co. Real Estate
 broker_of_record_name
 short_nameEvers & Co. Real Estate
 usernameEversCoRealEstateDC
 password8c94cd238914e1ba6f88d53a1a78f02c47944eeb
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionEvers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Washington, DC and <a href="../../../brokerage-detail/81/Evers-&-Co.-Real-Estate">Chevy Chase</a>, MD, USA. We are 100+ salespeople who offer our clients a level of service that is unmatched in today’s real estate marketplace, and we deliver this extraordinary service with courtesy and integrity to everyone involved in each transaction. We are enthusiastic about the neighborhoods where we live and work, from Chevy Chase to Capitol Hill, from Dupont Circle to Arlington, and everywhere in between. The highly visible storefront offices of Evers & Co. in Downtown Washington, Friendship Heights in Upper Northwest, downtown Bethesda-Chevy Chase and in Bluemont in the Virginia Wine Country are bustling with the entrepreneurial energy of agents who have in-depth knowledge of local history, architecture and construction techniques as well as expert skills in marketing and negotiating, all of which adds value to our service and your investment. This spectrum of knowledge and our commitment to serving our clientele and fellow real estate associates with the highest level of integrity has made us the premier independent brokerage in the Metropolitan Washington area. Donna Evers and the agents of Evers & Co. invite you to join our growing community of buyers and sellers, who have been the source of 90% of our business for the past thirty years.
 communitieswashington, DC chevy chase dupont kalorama georgetown american university park cleveland park Palisades logan circle capitol hill forest hills
 websitehttp://www.eversco.com/
 address4400 Jenifer Street, NW
 address_2
 cityWashington, D.C
 state
 full_state
 countryUSA
 marketWashington, D.C
 market_2
 postal_code20015
 phoneOffice: (202) 364-1700
 phone_2Cell: (202) 255-5009
 phone_3
 wide_contact_image(false)
 contact_nameDonna Evers
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident & Founder
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename80.jpg
 logo_filename80.jpg
 contact_image_filename80.jpg
 all_properties_link_image_filename80.JPG
 all_properties_linkhttp://eversco.idxre.com/featured/40484?CFID=10711248&CFTOKEN=99152164
 video_embed_code
 contact_video_embed_code
 meta_titleWashington DC Real Estate | Evers & Co. Real Estate | Leverage Global Partners
 meta_descriptionEvers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Washington, DC , Chevy Chase, Dupont, Kalorama, Georgetown, American University Park, Cleveland Park, Palisades, Logan Circle, Capitol Hill, and Forest Hills.
 meta_keywordsWashington DC Real Estate, Evers & Co. Real Estate, Leverage Global Partners, chevy chase real estate, dupont real estate, kalorama real estate, georgetown, american university park real estate, cleveland park real estate, Palisades real estate, logan circle real estate, capitol hill real estate, forest hills real estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-01-10 16:30:33
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/80/evers-co-real-estate
 website_shortwww.eversco.com
 name_with_locationEvers & Co. Real Estate
 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)
 id20565
 modelProperty
 model_id3708
 tagImage
 name36012.jpg
 typeimage/jpg
 size5032972
 uri/assets/20565.jpg
 order2894
 created2016-04-07 17:34:09
 modified2016-04-07 17:34:09
 User(array)
 0(array)
 id1267
 typeAgent
 brokerage_id80
 email[email protected]
 password64ae12b776051115a6c20b7eb8f0d36df7c5c187
 recover_hash
 first_nameBren
 last_nameLizzio
 title
 dre_num
 phone2026694999
 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_nameBren Lizzio
 uri/agent-detail/1267/bren-lizzio
 profile_complete(true)
 UsersProperty(array)
 id1096
 user_id1267
 property_id3708
 sort_order0
 1(array)
 id1268
 typeAgent
 brokerage_id80
 email[email protected]
 password72ce72c1db831d3b7e5697bf25ee0217b3739349
 recover_hash
 first_nameAndrea
 last_nameEvers
 title
 dre_num
 phone2025508934
 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_nameAndrea Evers
 uri/agent-detail/1268/andrea-evers
 profile_complete(true)
 UsersProperty(array)
 id1097
 user_id1268
 property_id3708
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
- sidebar_brokerages(array)
 0(array)
 Brokerage(array)
 id57
 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
 WOEID2474209
 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
 nameJ. Rockcliff Realtors
 broker_of_record_name
 short_nameJ Rockcliff Realtors
 usernameJRockcliffPleas
 password14a01d92dcd7b0cd5ad6f01dca84a3e626414a24
 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
 descriptionJ. Rockcliff Realtors is the exclusive representative for Leverage Global Partners in Pleasanton, Dublin, Livermore, Castro Valley, Fremont, and Sunol, California. J. Rockcliff Realtors is one of the fastest growing real estate companies in California and has distinguished itself as The East Bay’s Premier Real Estate Company. With offices located in <a href="../../../brokerage-detail/55/J.-Rockcliff-Realtors">LaMorinda</a> (Lafayette, Moraga, Orinda), <a href="../../../brokerage-detail/56/J.-Rockcliff-Realtors">Walnut Creek</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Danville</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Blackhawk</a>, and <a href="../../../brokerage-detail/57/J.-Rockcliff-Realtors">Pleasanton/Dublin/Livermore</a>, experienced Realtors can assist with your home buying or home selling needs in any real estate market. Looking for bank owned properties? We can help. J. Rockcliff Realtors’ Relocation Department provides home buying or home selling assistance around the corner or around the world. As members of Worldwide ERC (Employee Relocation Council), J. Rockcliff handles many corporate relocation moves as well. When listing or selling your home, you can rest assured that J. Rockcliff Realtors can provide the best real estate agents (Realtors) to help you buy or sell your home using the most innovative tools available, including; the finest marketing, the most advanced technology and resources unmatched by any other firm. J. Rockcliff Realtors is strategically positioned to be the company of choice now and in the future. J. Rockcliff Realtors is proudly licensed with the California Bureau of Real Estate - License #01793729. J.Rockcliff also has offices in <a href="../../../brokerage-detail/55/J.-Rockcliff-Realtors">Lafayette</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Danville</a>, and <a href="../../../brokerage-detail/56/J.-Rockcliff-Realtors">Walnut Creek</a>.
 communitiesPleasanton Dublin Livermore Castro Valley Sunol
 websitehttp://www.rockcliff.com/
 address5075 Hopyard Road
 address_2Suite 110
 cityPleasanton
 stateCA
 full_stateCalifornia
 countryUSA
 marketPleasanton
 market_2
 postal_code94588
 phone(925) 251-2500
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJeff Sposito
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename57.jpg
 logo_filename57.jpg
 contact_image_filename57.jpg
 all_properties_link_image_filename57.jpg
 all_properties_linkhttp://www.rockcliff.com/Rockcliff-Listings#g=2a4505b8-af60-49e2-b0c4-b980136a5da0
 video_embed_code
 contact_video_embed_code
 meta_titlePleasanton Real Estate | J. Rockcliff Realtors | Leverage Global Partners
 meta_descriptionJ. Rockcliff Realtors is the exclusive representative for Leverage Global Partners in Pleasanton, CA, USA.
 meta_keywordsJ. Rockcliff Realtors, Pleasanton Real Estate, Leverage Global Partners, Jeff Sposito
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-09-26 15:00:06
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/57/j-rockcliff-realtors
 website_shortwww.rockcliff.com
 name_with_locationJ. Rockcliff Realtors
 Logo(array)
 id2401
 modelBrokerage
 model_id57
 tagLogo
 name57.jpg
 typeimage/jpg
 size659806
 uri/assets/2401.jpg
 order0
 created2016-03-30 11:39:05
 modified2016-03-30 11:39:05
 1(array)
 Brokerage(array)
 id159
 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
 WOEID2374635
 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
 nameMiloff Aubuchon Realty Group
 broker_of_record_name
 short_nameMiloff Aubuchon Realty Group
 usernameMiloffAubuchon
 password1710f8a5e4581f9f3b2398bd524ffac0dceb4c84
 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
 descriptionMiloff Aubuchon Realty Group, Inc. is the exclusive representative for Leverage Global Partners in Lee County and Collier County, including: Cape Coral, Bonita Springs, Fort Myers, Naples, and Sanibel, Florida, USA. Miloff Aubuchon Realty Group Gary Aubuchon and Jeff Miloff formed a partnership in 1998 that would later flourish and succeed beyond their expectations. Miloff Aubuchon Realty Group, the real estate division of Team Aubuchon, began in the garage of a model home with four agents and one staff member. Today, the company has grown to over 95 agents, with 4 real estate offices now open in Southwest Florida. Their success is a result of hard work, dedication to excellence in all aspects of business, and a focus on providing above and beyond customer service. Through the years, this company has helped thousands of people invest in real estate, sell their property, and find the home of their dreams. Choosing Miloff Aubuchon Realty Group means you get insight and market knowledge from the best agents in the area who are dedicated to professionalism and working in your best interest. Our team is passionate about improving the community and giving back. We support local organizations such as Ronald McDonald House Charities SWFL, Make-A-Wish Southern Florida, Builders Care, Relay for Life, and Kids With Cancer. We pride ourselves by getting in the game both financially and physically. Our support includes home renovations, volunteering on numerous committees and events, hosting events at our offices, and so much more. Our mission is to help make your vision a reality, and become one of our Raving Fans.
 communitiesCape Coral Bonita Springs Fort Myers Sanibel
 websitehttp://www.miloffaubuchonrealty.com/
 address4707 SE 9th Place
 address_2
 cityCape Coral
 stateFL
 full_stateFlorida
 countryUSA
 marketLee County
 market_2
 postal_code33904
 phone(239) 542-1075
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJeff Miloff
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleVice President
 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_filename159.jpg
 logo_filename159.gif
 contact_image_filename159.jpg
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_titleCape Coral Real Estate | Miloff Aubuchon Realty Group | Leverage Global Partners
 meta_descriptionMiloff Aubuchon Realty Group is the exclusive representative for Leverage Global Partners in Cape Coral, FL, USA.
 meta_keywordsMiloff Aubuchon Realty Group, Cape Coral real estate, Jeff Miloff, Bonita Springs real estate, Fort Myers real estate, and Sanibel real estate
 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-09-05 15:04:46
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/159/miloff-aubuchon-realty-group
 website_shortwww.miloffaubuchonrealty.com
 name_with_locationMiloff Aubuchon Realty Group
 Logo(array)
 id2710
 modelBrokerage
 model_id159
 tagLogo
 name159.gif
 typeimage/gif
 size83648
 uri/assets/2710.gif
 order0
 created2016-03-30 11:43:09
 modified2016-03-30 11:43:09
 2(array)
 Brokerage(array)
 id62
 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_properties-1
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID12588033
 timezoneUS/Hawaii
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameThe Wailea Group
 broker_of_record_name
 short_nameThe Wailea Group
 usernameWaileaGroup
 password96cbf310f1191af607d1a68cb3d3240778537715
 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
 descriptionThe Wailea Group is the exclusive representative for Leverage Global Partners in Maui, Lanai, and Moloka'i, Hawaii, USA. The Wailea Group is a collaboration of sales and marketing professionals with deep respect for Wailea-Makena’s past, present and future. Wailea-Makena will continue to grow, this is a certainty. But equally certain is the control of that growth ensuring an unparalleled quality of life on Maui. We have already exclusively represented new development projects valued at over $2 billion, a tribute to the vision and integrity of our founders and our unique marketing insights and strategies. Wailea Beach Villas, Ho’olei and Papali were all represented by us and we’re now exclusively representing the Andaz. Our inventory of existing homes and condos and our knowledge of future development make us not only the logical choice among buyers and sellers but also the smart choice. <a href="http://www.leveragere.com/project-detail/24/Makali'i-at-Wailea,-Maui,-Hawaii" target="_blank">Visit Makali’i at Wailea</a>
 communitiesMaui Lanai Moloka'i
 websitehttp://www.thewaileagroup.com/HomeMain.aspx
 address3750 Wailea Alanui
 address_2Suite 5EW
 cityWailea
 stateHI
 full_stateHawaii
 countryUSA
 marketMaui
 market_2
 postal_code96753
 phoneMain: (808) 875-6911
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameScott Nelson
 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_filename62.jpg
 logo_filename62.gif
 contact_image_filename62.jpg
 all_properties_link_image_filename62.jpg
 all_properties_linkhttp://www.thewaileagroup.com/Exclusive.aspx
 video_embed_code
 contact_video_embed_code
 meta_titleMaui Real Estate | The Wailea Group | Leverage Global Partners
 meta_descriptionThe Wailea Group is the exclusive representative for Leverage Global Partners in Maui, HI, USA.
 meta_keywordsThe Wailea Group, maui real estate, hawaii real estate, rene sand, leverage global partners
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-10-09 12:08:12
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/62/the-wailea-group
 website_shortwww.thewaileagroup.com/HomeMain.aspx
 name_with_locationThe Wailea Group
 Logo(array)
 id2416
 modelBrokerage
 model_id62
 tagLogo
 name62.gif
 typeimage/gif
 size13808
 uri/assets/2416.gif
 order0
 created2016-03-30 11:39:25
 modified2016-03-30 11:39:25
 3(array)
 Brokerage(array)
 id95
 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_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2477058
 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
 nameColeman Realtors
 broker_of_record_name
 short_nameColeman Realtors
 usernameColemanRealtors
 passwordc19a88afe4dbd7329004555ea008b2340aa6342b
 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
 descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill. Local knowledge, world-class expertise. Rhode Islanders pride themselves on their independence. So do we: we're an independent, third-generation residential real estate company, not a franchise. That means we're totally focused on you and your needs. We've helped thousands of clients buy, sell, and rent since we opened our doors in 1929. Today our clients rely on our team of over 100 experienced professionals for our local knowledge and expertise: we know the neighborhoods, the towns and the people. With offices in Barrington, East Greenwich, Providence and Watch Hill, we're nearby too. So no matter your challenge, we'll bring you a wealth of experience, ideas and relationships - all geared toward producing results.
 communitiesBarrington, RI Providence, RI Watch Hill, RI Newport, RI Jamestown, RI Bristol, RI Charlestown, RI Narragansett, RI South Kingstown, RI East Greenwich, RI
 websitehttp://www.colemanrealtors.com/
 address135 Elmgrove Avenue
 address_2
 cityProvidence
 stateRI
 full_stateRhode Island
 countryUSA
 marketProvidence
 market_2
 postal_code02906
 phoneDavid Coleman: (401) 245-3050
 phone_2Michael Young: (401) 274-3636
 phone_3
 wide_contact_image(false)
 contact_nameDavid Coleman & Michael Young
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCo-Owners
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Providence 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_filename95.jpg
 logo_filename95.png
 contact_image_filename95.jpg
 all_properties_link_image_filename95.jpg
 all_properties_linkhttp://www.colemanrealtors.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleProvidence Real Estate | Coleman Realtors | Leverage Global Partners
 meta_descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Providence, Rhode Island, USA.
 meta_keywordsColeman Realtors, Providence Real Estate, Leverage Global Partners, Providence Rhode Island Real Estate, Barrington Real Estate, East Greenwich Real Estate, Providence Real Estate, Watch Hill 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-02-11 18:09:34
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/95/coleman-realtors
 website_shortwww.colemanrealtors.com
 name_with_locationColeman Realtors
 Logo(array)
 id2521
 modelBrokerage
 model_id95
 tagLogo
 name95.png
 typeimage/png
 size12692
 uri/assets/2521.png
 order0
 created2016-03-30 11:40:34
 modified2016-03-30 11:40:34
- sidebar_locations(array)
 0(array)
 Location(array)
 id106
 parent_id6
 brokerage_id9
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameTokyo, Japan
 short_nameTokyo, Japan
 group_index
 latitude35.689487
 longitude139.691711
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-05 13:40:55
 modified2016-04-05 13:40:55
 timezoneAsia/Tokyo
 population13350000
 uri/locations/view/106/tokyo-japan
 tile_nameTokyo, Japan
 Brokerage(array)
 id9
 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_id8
 WOEID1118370
 timezoneAsia/Tokyo
 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
 nameHousing Japan
 broker_of_record_name
 short_nameHousing Japan
 usernameHousingJapan
 passwordf672ec38b72eb055ce94ca707e4c7948f6bda00b
 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
 descriptionHousing Japan is the exclusive representative for Leverage Global Partners in Tokyo, Japan. Housing Japan aims to be the innovative leader of real-estate service providers in Japan. Our company philosophy is “Think, Innovate and Create.” It is a part of everything we do. Housing Japan started in 2000 providing leasing services to expatriates relocating to Tokyo. Our business has evolved to provide a broad range of real-estate services to domestic and international clients. Our reputation is built on providing superior levels of service, honest and transparent communication, and achieving great results for our clients. Over the years we have had the privilege to work with clients including many global corporations, finance companies, embassies and international schools. We have also worked on various development projects ranging from beach houses in Chiba to executive houses in Tokyo. Our experienced professionals serve clients everyday with leasing, sales, property management and development projects in Tokyo. We look forward to a future of growth based on the relationships we have built and experiences we have enjoyed over the last decade. We are excited about real estate in Japan and we look forward to working with you.
 communitiesTokyo
 websitehttp://www.housingjapan.com
 addressCR Kamiyacho Bldg. 7F 1-11-9
 address_2
 cityAzabudai, Minato-ku Tokyo
 state
 full_state
 countryJapan
 marketTokyo
 market_2
 postal_codeJapan 106-0041
 phone+81 3 3588 8860
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameMitsuo Hashimoto
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename9.jpg
 logo_filename9.png
 contact_image_filename9.JPG
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_titleTokyo Real Estate | Housing Japan | Leverage Global Partners
 meta_descriptionHousing Japan is the exclusive Tokyo real estate representative for Leverage Global Partners.
 meta_keywordstokyo real estate, housing japan, tokyo, tokyo japan, 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-03-19 16:53:05
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/9/housing-japan
 website_shortwww.housingjapan.com
 name_with_locationHousing Japan
 Image(array)
 id3040
 modelLocation
 model_id106
 tagImage
 nameTokyo.jpg
 typeimage/jpeg
 size192789
 uri/assets/3040.jpg
 order0
 created2016-04-05 13:40:49
 modified2016-04-05 13:40:55
 1(array)
 Location(array)
 id161
 parent_id6
 brokerage_id186
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameShanghai, China
 short_nameShanghai, China
 group_index
 latitude31.230415
 longitude121.473701
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 16:26:24
 modified2016-04-12 16:26:24
 timezoneAsia/Shanghai
 population0
 uri/locations/view/161/shanghai-china
 tile_nameShanghai, China
 Brokerage(array)
 id186
 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(true)
 country_id0
 WOEID2151849
 timezoneAsia/Hong_Kong
 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
 usernamePTChina
 password30b07d20993afbee7a407c6a933d798408b3f362
 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
 descriptionPartners Trust now has an office in Shanghai on the Bund and a presence in Hong Kong in order to better serve our buyers coming from China. Partners Trust China provides Chinese buyers with the latest information on real estate investing in the United States and offers concierge-quality service for those interested in making a purchase in Los Angeles. Partners Trust China is an active participant in luxury exhibits and real estate shows throughout China, Taiwan, and Hong Kong. We also have experienced consultants available to consult on immigration, tax, and private wealth concerns. 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>, and <a href="../../brokerage-detail/142/Partners-Trust" target="_blank">Malibu</a>, and <a href="../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>.
 communitiesShanghai
 websitehttp://www.partnerstrustchina.com/
 addressZhongshan East 1st Road
 address_2
 cityShanghai
 state
 full_state
 countryChina
 marketShanghai
 market_2
 postal_code200085
 phone+86 (21) 3120 3218
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameSean Mei
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleFounding 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_2Nick Segal
 contact_profile_link_2http://www.leveragere.com/brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2President/Co-Founder
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename186.jpg
 logo_filename186.png
 contact_image_filename186.jpg
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_titleShanghai 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 Shanghai, China.
 meta_keywordspartners trust, partners trust real estate, shanghai 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)
 created2015-02-02 14:52:01
 modified2016-04-08 16:34:20
 dre_num012345
 uri/brokerage-detail/186/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortwww.partnerstrustchina.com
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 Image(array)
 id20718
 modelLocation
 model_id161
 tagImage
 nameScreen Shot 2016-04-12 at 4.24.28 PM.png
 typeimage/png
 size514779
 uri/assets/20718.png
 order0
 created2016-04-12 16:25:13
 modified2016-04-12 16:26:24
 2(array)
 Location(array)
 id72
 parent_id9
 brokerage_id45
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameRedlands, CA, USA
 short_nameRedlands, CA, USA
 group_index
 latitude37.090240
 longitude-95.712891
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 18:02:08
 modified2016-04-14 11:05:16
 timezoneAmerica/Los_Angeles
 population70000
 uri/locations/view/72/redlands-ca-usa
 tile_nameRedlands, CA, USA
 Brokerage(array)
 id45
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2525109
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameElite Realty Group
 broker_of_record_name
 short_nameElite Realty Group
 usernameEliteRealty
 passworde1a63e2def7ed55f3dbf026430e9a42cc49521b0
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionElite Realty is the exclusive representative for Leverage Global Partners in Redlands, Yucaipa, Colton, Grand Terrace, San Bernardino, Highland, Loma Linda, Mentone, Calimesa, Cherry Valley, Beaumont, and Banning, California, USA. Specializing in homes for sale and the San Bernardino and Riverside County real estate market, you have found your realtor resource for buying and selling your next home. With expertise in realty for both purchasing and listing properties in Yucaipa, Calimesa, Redlands, Cherry Valley, Oak Glen and Beaumont and all surrounding San Bernardino and Riverside Counties, you have found the right resource for all of your real estate needs. Whether you are looking for a new Cherry Valley property or Calimesa land, or you are in the preliminary stages of your real estate search, you have found the best in professional service.
 communitiesRedlands Yucaipa Colton Grand Terrace San Bernardino Highland Loma linda Mentone Calimesa Cherry Valley Beaumont Banning
 websitehttp://www.eliterealtygroup.net/
 address1447 Ford Street
 address_2
 cityRedlands
 stateCA
 full_stateCalifornia
 countryUSA
 market
 market_2
 postal_code92374
 phone(909) 793-3222
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameDennis Miller
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBroker/Co-Owner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename45.jpg
 logo_filename45.png
 contact_image_filename45.JPG
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_titleYucaipa Real Estate | Elite Realty Group | Leverage Global Partners
 meta_descriptionElite Realty Group is the exclusive representative for Leverage Global Partners in Yucaipa, CA, USA.
 meta_keywordsElite Realty Group, yucaipa real estate, Dennis Miller, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-09-10 13:01:01
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/45/elite-realty-group
 website_shortwww.eliterealtygroup.net
 name_with_locationElite Realty Group
 Image(array)
 id3004
 modelLocation
 model_id72
 tagImage
 nameRedlands.jpg
 typeimage/jpeg
 size165492
 uri/assets/3004.jpg
 order0
 created2016-04-04 18:01:39
 modified2016-04-14 11:05:16
 3(array)
 Location(array)
 id127
 parent_id8
 brokerage_id86
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameLexington, KY, USA
 short_nameLexington, KY, USA
 group_index
 latitude38.048813
 longitude-84.509109
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionYou’ve heard the expression “it’s in the water.” Well, here in the Bluegrass it truly is in the water.
 long_descriptionYou’ve heard the expression “it’s in the water.” Well, here in the Bluegrass it truly is in the water. “It” is the rich limestone bed beneath our fertile Kentucky soil. That limestone provides calcium to our newborn Thoroughbreds and affords the perfect base for crisp Kentucky Bourbon. “It” is what truly makes the Bluegrass Region of Kentucky world-renowned. Those things – Bourbon and horses – are what have shaped the Bluegrass in many ways to become the productive yet friendly community it remains. At Kirkpatrick & Company, we’re more than just trusted advisors; we’re ambassadors for our beloved Bluegrass. We invite you to visit Central Kentucky, and allow us to introduce you to the best the region has to offer.
 created2016-04-06 10:36:21
 modified2016-04-14 11:04:52
 timezoneAmerica/New_York
 population500000
 uri/locations/view/127/lexington-ky-usa
 tile_nameLexington, KY, USA
 Brokerage(array)
 id86
 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
 WOEID2438841
 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
 nameKirkpatrick & Co.
 broker_of_record_name
 short_nameKirkpatrick & Co.
 usernameKirkpatrick
 password22cbd25f50324e9fd2172d3ff062c0264feeab9f
 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
 descriptionKirkpatrick & Co. is the exclusive representative for Leverage Global Partners in Lexington, Kentucky, USA. We’ve made our living helping clients buy and sell the finest real estate in the Bluegrass for over thirty years. Our particular expertise includes equestrian farms and land, country estates & historic properties. When Arnold Kirkpatrick formed Kirkpatrick & Company three decades ago, he envisioned a brokerage that would offer not only authoritative knowledge and experience but a sense of integrity permeating the firm’s every action. Arnold understood that the purchase or sale of a property was not the end of a relationship, but a prelude. He treasured the friendships he built with clients, offering a unique blend of industry expertise and Bluegrass hospitality to individuals both local and international. Steeped in that tradition, Kirkpatrick & Company remains pleased to provide clients excellent - and gracious - representation.
 communitiesLexington
 websitehttp://kirkfarms.com/
 address535 W. Second St.
 address_2Suite 104
 cityLexington
 stateKY
 full_stateKentucky
 countryUSA
 marketLexington
 market_2
 postal_code40508
 phonePhone: (859) 576-8195
 phone_2Fax: (859) 254-8372
 phone_3
 wide_contact_image(false)
 contact_nameZachary A. Davis
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-zachary-a-davis-president-and-principal-broker-kirkpatrick-co-lexington-kentucky/
 contact_big_profile_link_text
 contact_titlePresident & Principal 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_filename86.jpg
 logo_filename86.png
 contact_image_filename86.jpg
 all_properties_link_image_filename86.jpg
 all_properties_linkhttp://kirkfarms.com/residential-listings/
 video_embed_code
 contact_video_embed_code
 meta_titleLexington Real Estate | Kirkpatrick & Co. | Leverage Global Partners
 meta_descriptionKirkpatrick & Co. is the exclusive representative for Leverage Global Partners in Lexington, Kentucky, USA.
 meta_keywordsKirkpatrick & Co., Lexington Real Estate, Leverage Global Partners, Zachary A. Davis, Lexington, Lexington Kentucky
 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-24 16:35:29
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/86/kirkpatrick-co
 website_shortkirkfarms.com
 name_with_locationKirkpatrick & Co.
 Image(array)
 id3390
 modelLocation
 model_id127
 tagImage
 name86.jpg
 typeimage/jpeg
 size231092
 uri/assets/3390.jpg
 order0
 created2016-04-06 10:34:14
 modified2016-04-14 11:04:52
- location_properties(empty)
- main_article(empty)
- brokerage(array)
 Brokerage(array)
 id69
 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
 WOEID23511794
 timezoneUS/Mountain
 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
 nameJackson Hole Real Estate Associates
 broker_of_record_name
 short_nameJackson Hole Real Estate Associates
 usernameJacksonHole
 passwordb7b28ec0650589666dc21d2965e1e78fbbd3e998
 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
 descriptionJackson Hole Real Estate Associates is the exclusive representative for Leverage Global Partners in Jackson Hole, WY, Star Valley, WY, and Teton Valley, Idaho, USA. Welcome to Jackson Hole Real Estate Associates; the region’s largest and most dynamic real estate company. Our organization is comprised of experienced, successful and dedicated real estate professionals. Our collection of properties is unsurpassed and includes some of the most unique and sought-after real estate in the world. Jackson Hole Real Estate Associates is committed to being the leading luxury real estate brand in the Teton region. By staying on top of market trends and continually striving to offer cutting edge marketing and advertising services we deliver extraordinary experiences to clients and exceed their expectations. As a market leader in Jackson Hole, we believe the success of our company is based on the value that we provide for our clients, community and agents. It is this value-driven philosophy that has helped to guide the successful growth of our organization.
 communitiesJackson Hole Star Valley Teton Valley
 websitehttp://jhrea.com/
 address80 W. Broadway
 address_2PO Box 4897
 cityJackson
 state WY
 full_stateWyoming
 countryUSA
 marketJackson Hole
 market_2
 postal_code83001
 phone(307) 733-6060
 phone_2(888) 733-6060
 phone_3
 wide_contact_image(false)
 contact_nameThe Team at Jackson Hole Real Estate Associates
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwners and Real Estate Professionals
 contact_dre_num
 contact_quoteWe invite you to contact us about Jackson Hole 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_filename69.jpg
 logo_filename69.png
 contact_image_filename69.jpg
 all_properties_link_image_filename69.jpg
 all_properties_linkhttp://search.jhrea.com/idx/featured
 video_embed_code<iframe width="560" height="315" src="https://www.youtube.com/embed/LgDWINq8GMo?controls=0&showinfo=0" frameborder="0" allowfullscreen></iframe>
 contact_video_embed_code
 meta_titleJackson Hole Real Estate | Jackson Hole Real Estate Associates | Leverage Global Partners
 meta_descriptionJackson Hole Real Estate Associates is the exclusive representative for Leverage Global Partners in Jackson Hole, WY, Star Valley, WY, and Teton Valley, Idaho.
 meta_keywordsJackson Hole Real Estate Associates, leverage global partners, jackson hole real estate, star valley real estate, teton valley real estate, jackson real estate, Julie Faupel, Matt Faupel
 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-11-12 13:31:18
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/69/jackson-hole-real-estate-associates
 website_shortjhrea.com
 name_with_locationJackson Hole Real Estate Associates - Jackson Hole, WY, USA
 AccountExecutive(array)
 id235
 typeAccountExecutive
 brokerage_id0
 email[email protected]
 passworde5cc5a96287695cf8b7cace1463b1699895dcf92
 recover_hash
 first_nameAlec
 last_nameMegerdichian
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2020-12-23 09:21:42
 created2016-04-14 15:40:35
 notified(false)
 full_nameAlec Megerdichian
 uri/agent-detail/235/alec-megerdichian
 profile_complete(true)
 Logo(array)
 id2437
 modelBrokerage
 model_id69
 tagLogo
 name69.png
 typeimage/png
 size16391
 uri/assets/2437.png
 order0
 created2016-03-30 11:39:41
 modified2016-03-30 11:39:41
 MainImage(array)
 id2436
 modelBrokerage
 model_id69
 tagMainImage
 name69.jpg
 typeimage/jpg
 size2546025
 uri/assets/2436.jpg
 order0
 created2016-03-30 11:39:40
 modified2016-03-30 11:39:40
 ContactImage(array)
 id2438
 modelBrokerage
 model_id69
 tagContactImage
 name69.jpg
 typeimage/jpg
 size190442
 uri/assets/2438.jpg
 order0
 created2016-03-30 11:39:41
 modified2016-03-30 11:39:41
 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)
 id116
 parent_id9
 brokerage_id69
 typeExclusive
 archived(false)
 use_as_topic(true)
 nameJackson Hole, WY, USA
 short_nameJackson Hole, WY, USA
 group_index
 latitude43.468697
 longitude-110.672417
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionOne of the world’s most unique places; Jackson Hole is a destination unparalleled in the mountain west.
 long_descriptionOne of the world’s most unique places; Recognized for our stunning natural beauty, diverse ecosystems, and abundant wildlife, Jackson Hole is a destination unparalleled in the mountain west. Uniquely located in the heart of 2.7 million protected acres of beautiful unspoiled mountain ranges, wilderness areas, wildlife refuges, National Parks, and rivers; 97% of our land is protected, leaving the 3% of developable property highly desirable with views that will never change. The region’s lifestyle benefits are matched only by the financial benefits of Wyoming Residency. The surreal natural beauty of the area is the perfect place to experience outdoor adventure paired with distinct western culture.
 created2016-04-05 17:28:58
 modified2016-04-14 10:55:04
 timezone
 population9577
 uri/locations/view/116/jackson-hole-wy-usa
 tile_nameJackson Hole, WY, USA
 User(array)
 0(array)
 id102
 typeBrokerageAdmin
 brokerage_id69
 email[email protected]
 passwordb7b28ec0650589666dc21d2965e1e78fbbd3e998
 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:25:18
 created2016-04-08 16:33:30
 notified(true)
 full_name
 uri/agent-detail/102/
 profile_complete(false)
 1(array)
 id289
 typeAgent
 brokerage_id69
 email[email protected]
 passwordcedf2096e5a7621572e9532aeea90481d5670654
 recover_hash
 first_nameGraham
 last_nameFaupel
 title
 dre_num
 phone(307) 690-0812
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:41
 created2017-08-07 15:22:41
 notified(false)
 full_nameGraham Faupel
 uri/agent-detail/289/graham-faupel
 profile_complete(true)
 2(array)
 id292
 typeAgent
 brokerage_id69
 email[email protected]
 passwordb43678c48dbf092dedab7e25c0a72fa319eea504
 recover_hash
 first_nameChad
 last_nameBudge
 title
 dre_num
 phone(307) 413-1364
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:41
 created2017-08-07 15:22:41
 notified(false)
 full_nameChad Budge
 uri/agent-detail/292/chad-budge
 profile_complete(true)
 3(array)
 id293
 typeAgent
 brokerage_id69
 email[email protected]
 passwordc4662fac083b96e1f1b8c11063b4c2a7f87b154a
 recover_hash
 first_nameDianne
 last_nameBudge
 title
 dre_num
 phone(307) 413-1362
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:41
 created2017-08-07 15:22:41
 notified(false)
 full_nameDianne Budge
 uri/agent-detail/293/dianne-budge
 profile_complete(true)
 4(array)
 id294
 typeAgent
 brokerage_id69
 email[email protected]
 passwordd7036aaaff38aeefb1179e3b63b05e3b26ba065c
 recover_hash
 first_nameCarol
 last_nameLinton
 title
 dre_num
 phone(307) 699-1139
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:41
 created2017-08-07 15:22:41
 notified(false)
 full_nameCarol Linton
 uri/agent-detail/294/carol-linton
 profile_complete(true)
 5(array)
 id295
 typeAgent
 brokerage_id69
 email[email protected]
 password617984519b70b58250c8bcda9ada1058c866c8f2
 recover_hash
 first_nameRichard
 last_nameLewis
 title
 dre_num
 phone(307) 690-8855
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:41
 created2017-08-07 15:22:41
 notified(false)
 full_nameRichard Lewis
 uri/agent-detail/295/richard-lewis
 profile_complete(true)
 6(array)
 id296
 typeAgent
 brokerage_id69
 email[email protected]
 passwordda3a89dfdc9906ac704e2f55c960e8700e162fc7
 recover_hash
 first_nameChopper
 last_nameGrassell
 title
 dre_num
 phone(307) 231-2603
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:41
 created2017-08-07 15:22:41
 notified(false)
 full_nameChopper Grassell
 uri/agent-detail/296/chopper-grassell
 profile_complete(true)
 7(array)
 id321
 typeAgent
 brokerage_id69
 email[email protected]
 password8562d2d6758c4c91afb7ffdec30a6946e6eaecc8
 recover_hash
 first_nameNeville
 last_nameGroup
 title
 dre_num
 phone(307) 690-3209
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:45
 created2017-08-07 15:22:45
 notified(false)
 full_nameNeville Group
 uri/agent-detail/321/neville-group
 profile_complete(true)
 8(array)
 id374
 typeAgent
 brokerage_id69
 email[email protected]
 password3e6a4eb821e361a83dc78d0f6363b6371268e878
 recover_hash
 first_nameJocelyn
 last_nameEmery
 title
 dre_num
 phone(307) 690-7138
 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_nameJocelyn Emery
 uri/agent-detail/374/jocelyn-emery
 profile_complete(true)
 9(array)
 id827
 typeAgent
 brokerage_id69
 email[email protected]
 password86346991b9aafa87aa1e5b1261fa913ee035439d
 recover_hash
 first_nameMelissa
 last_nameHarrison
 title
 dre_num
 phone(307) 690-0086
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:40
 created2017-08-07 15:23:40
 notified(false)
 full_nameMelissa Harrison
 uri/agent-detail/827/melissa-harrison
 profile_complete(true)
- location(array)
 Location(array)
 id116
 parent_id9
 brokerage_id69
 typeExclusive
 archived(false)
 use_as_topic(true)
 nameJackson Hole, WY, USA
 short_nameJackson Hole, WY, USA
 group_index
 latitude43.468697
 longitude-110.672417
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionOne of the world’s most unique places; Jackson Hole is a destination unparalleled in the mountain west.
 long_descriptionOne of the world’s most unique places; Recognized for our stunning natural beauty, diverse ecosystems, and abundant wildlife, Jackson Hole is a destination unparalleled in the mountain west. Uniquely located in the heart of 2.7 million protected acres of beautiful unspoiled mountain ranges, wilderness areas, wildlife refuges, National Parks, and rivers; 97% of our land is protected, leaving the 3% of developable property highly desirable with views that will never change. The region’s lifestyle benefits are matched only by the financial benefits of Wyoming Residency. The surreal natural beauty of the area is the perfect place to experience outdoor adventure paired with distinct western culture.
 created2016-04-05 17:28:58
 modified2016-04-14 10:55:04
 timezone
 population9577
 uri/locations/view/116/jackson-hole-wy-usa
 tile_nameJackson Hole, WY, USA
 Image(array)
 id3379
 modelLocation
 model_id116
 tagImage
 name69.jpg
 typeimage/jpeg
 size145276
 uri/assets/3379.jpg
 order0
 created2016-04-05 17:28:52
 modified2016-04-14 10:55:04
- 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/116/jackson-hole-wy-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/locations/view/116/jackson-hole-wy-usa
Remote Port	20693
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.41
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	a09e25684fd84628-CMH
Http Accept Encoding	gzip, br
Http Cookie	CAKEPHP=23blhb7rg9ucbj3qc34fo1d229
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	aipEw0qFdFKg_eEneUuCiQAAAIM
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	aipEw0qFdFKg_eEneUuCiQAAAIM
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781155011.9045
Request Time	1781155011

====

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

Jackson Hole, WY, 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: 37 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: 37 ms
Total Queries: 19 queries