Locations / Redondo Beach, CA, USA

Redondo Beach, CA, USA

More information coming soon!

Location Represented By

Partners Trust Real Estate Brokerage and Acquisitions

License #: 012345

8:51pm local time

Partner Search

Find partners with a map-based search

Related Locations

Boise, ID, USA

Welcome to the Treasure Valley and Boise, Idaho

Jackson Hole, WY, USA

One of the world’s most unique places; Jackson Hole is a destination unparalleled in the mountain west.

Melbourne, FL, USA

City of Chicago, IL, USA

Chicago is architecturally rich, artistically inspiring and comprised of 77 vibrant neighborhoods.

Related Partners

Forest Hill Real Estate Inc

Office: (416) 488-2875 | Email
License #: 012345

Quinta Properties

+351 289 396 073 | Email
License #: 012345

Nathan Grace Real Estate

Cell: (972) 670-3437 | Email
License #: 012345

Congdon & Coleman Real Estate

(508) 325-5016 | Email
License #: 012345

Recent Property Listings

Pretty Pretty Piece of Land

980 MARTIN LUTHER KING ROAD
Pawleys Island, SC 29585
$680,000

Elegant, Contemporary Oasis Overlooking Pacific Ocean

31652 Broad Beach Road
Malibu, CA 90265
$5,800,000

Iconic corner brownstone on uptown Garden Street

1200 Garden St.
Hoboken, NJ 07030
$2,850,000

Handsome English Tudor

38 Sherwood Road
Short Hills, NJ 07078
$1,500,000

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

Array
(
)

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

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

Query Explain:

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

====

Timer

Memory

Peak Memory Use 11.58 MB

Message	Memory use
Component initialization	2.88 MB
Controller action start	3.80 MB
Controller render start	6.65 MB
View render complete	7.20 MB

Timers

Total Request Time: 206 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	25.15
Event: Controller.initialize	3.81
Event: Controller.startup	1.07
Controller action	55.13
Event: Controller.beforeRender	11.19
» Processing toolbar data	11.11
Rendering View	86.43
» Event: View.beforeRender	0.30
» Rendering APP/View/Locations/view.ctp	2.52
» » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.13
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.15
» » Rendering APP/View/Elements/sidebar/brokerage_list.ctp	0.16
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.27
» » » Rendering APP/View/Elements/static_property_price.ctp	0.36
» » » Rendering APP/View/Elements/static_property_price.ctp #2	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #3	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.15
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.19
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	82.41
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)
 id3747
 brokerage_id70
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 namePretty Pretty Piece of Land
 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_time2018-08-22 14:52:23
 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_urlhttps://propertylistings.ft.com/homes/2552920/new-york-property-for-sale/7-hubert-street-new-york-new-york
 nyt_detail_urlhttps://www.nytimes.com/real-estate/usa/ca/beverly-hills/homes-for-sale/9491-rembert-ln/1995-801-1-19-524596
 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)
 description8 Acres Located On Pawleys Island, Approximately 70 Miles Fromcharleston And 25 Miles South Of Myrtle Beach. It Is Known As One Of The Oldest And Most Unique Summer Resorts On The East Coast With Nearby Golf Courses. Home Of The Famous Rope Hammocks And World Known Hammock Shops And The Unspoiled, Casual, Delightful Stretch Of Wide Beach And Sand Dunes, Create A Charming Place To Live. Housing Developers Are Welcome. Pawleys Continues To Be Known For Its Shoeless, Carefree, Laid-back Life Style, Which Includes Crabbing In The Creek, Fishing, And The Stories Of Ghosts (Gray Man & Alice...to Name A Few). Come Enjoy This Charming Lifestyle.
 address980 MARTIN LUTHER KING ROAD
 address_2
 cityPawleys Island
 stateSC
 postal_code29585
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price680000
 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)
 bedrooms0
 bedrooms_20
 bathrooms0
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_typeapartment
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type1
 juwai_property_type
 juwai_category
 propgolux_property_style1
 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
 latitude33.420074
 longitude-79.183090
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(false)
 invalid(false)
 mlsidx_full_address980 MARTIN LUTHER KING ROAD Pawleys Island SC
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2019-10-29 18:47:35
 created2018-05-02 14:29:44
 uri/property-detail/3747/980-martin-luther-king-road-pawleys-island-sc-29585-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3747/980-martin-luther-king-road-pawleys-island-sc-29585-usa
 address_concat980 MARTIN LUTHER KING ROAD Pawleys Island SC 29585 USA
 google_maps_query_string980+MARTIN+LUTHER+KING+ROAD++Pawleys+Island+SC+29585+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 680,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty0
 bathrooms_pretty0
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms0
 date_listed2018-05-02
 overridden_brokerage_nameQuinta Properties
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id70
 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_properties3
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id13
 WOEID23706483
 timezoneEurope/Lisbon
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id9
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameQuinta Properties
 broker_of_record_name
 short_nameQuinta Properties
 usernameQuintaProperties
 passwordbfa20d0f7d557565a3e9f0589db0a06e4c9546f3
 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
 descriptionQuinta Properties is the exclusive representative for Leverage Global Partners in the Algarve, Portugal. Quinta Properties deal with some of the most exclusive luxury villas and exciting property in and around Quinta do Lago. As the chosen associates of Savills, they offer in-depth knowledge and experience to meet your real estate needs. Anyone who knows Quinta Properties and has dealt with Alison, Kerstin, and their team will know they are passionate about property. Their wide experience in the local property market enables them to recommend legal, architectural, financial and construction professionals who understand the needs of prospective buyers in the locality. Quinta Properties are registered with the Portuguese authorities as licensed agents, meeting stringent standards. Their staff are fluent in English, German, French, and Portuguese. "We make it our business to support you, to explain all the options, procedures and pitfalls and to carefully guide you through the entire process from purchasing to sellingluxury Quinta do Lago villas and other fine properties in the Quinta do Lago and the whole Algarve area." --Alison Buechner Hojbjerg and Kerstin Buechner
 communitiesalgarve the algarve quinta do lago
 websitehttp://www.quintaproperty.com/
 addressAvenida da Gondra
 address_2Quinta do Lago
 cityAlmancil
 state
 full_state
 countryPortugal
 marketAlgarve
 market_2
 postal_code8135-162
 phone+351 289 396 073
 phone_2+351 289 398086 (Fax)
 phone_3
 wide_contact_image(false)
 contact_nameAlison Buechner Hojbjerg and Kerstin Buechner
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleDirectors
 contact_dre_num
 contact_quoteWe invite you to contact us about real estate in the Algarve
 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_filename70.jpg
 logo_filename70.jpg
 contact_image_filename70.jpg
 all_properties_link_image_filename70.jpg
 all_properties_linkhttp://www.quintaproperty.com/algarve/
 video_embed_code
 contact_video_embed_code
 meta_titleAlgarve Real Estate | Quinta Properties | Leverage Global Partners
 meta_descriptionQuinta Properties is the exclusive representative for Leverage Global Partners in the Algarve, Portugal.
 meta_keywordsQuinta Properties, Algarve Real Estate, Leverage Global Partners, Alison Buechner Hojbjerg
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-11-15 11:23:29
 modified2020-11-20 12:05:11
 dre_num012345
 uri/brokerage-detail/70/quinta-properties
 website_shortwww.quintaproperty.com
 name_with_locationQuinta Properties
 mlsidx_id_array(array)
 09
 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)
 id22844
 modelProperty
 model_id3747
 tagImage
 name1724068_5-1.jpg
 typeimage/jpeg
 size102864
 uri/assets/22844.jpg
 order0
 created2018-05-02 14:29:45
 modified2018-05-02 14:35:42
 1(array)
 id22845
 modelProperty
 model_id3747
 tagImage
 name1724068_5-2.jpg
 typeimage/jpeg
 size86680
 uri/assets/22845.jpg
 order1
 created2018-05-02 14:29:45
 modified2018-05-02 14:35:42
 2(array)
 id22846
 modelProperty
 model_id3747
 tagImage
 name1724068_5-3.jpg
 typeimage/jpeg
 size86613
 uri/assets/22846.jpg
 order2
 created2018-05-02 14:29:45
 modified2018-05-02 14:35:42
 3(array)
 id22847
 modelProperty
 model_id3747
 tagImage
 name1724068_5-4.jpg
 typeimage/jpeg
 size130988
 uri/assets/22847.jpg
 order3
 created2018-05-02 14:29:45
 modified2018-05-02 14:35:42
 4(array)
 id22848
 modelProperty
 model_id3747
 tagImage
 name1724068_5-5.jpg
 typeimage/jpeg
 size138280
 uri/assets/22848.jpg
 order4
 created2018-05-02 14:29:45
 modified2018-05-02 14:35:42
 5(array)
 id22849
 modelProperty
 model_id3747
 tagImage
 name1724068_5-6.jpg
 typeimage/jpeg
 size140711
 uri/assets/22849.jpg
 order5
 created2018-05-02 14:29:46
 modified2018-05-02 14:35:42
 6(array)
 id22850
 modelProperty
 model_id3747
 tagImage
 name1724068_5-7.jpg
 typeimage/jpeg
 size212343
 uri/assets/22850.jpg
 order6
 created2018-05-02 14:29:46
 modified2018-05-02 14:35:42
 7(array)
 id22851
 modelProperty
 model_id3747
 tagImage
 name1724068_5-8.jpg
 typeimage/jpeg
 size199205
 uri/assets/22851.jpg
 order7
 created2018-05-02 14:29:46
 modified2018-05-02 14:35:42
 8(array)
 id22852
 modelProperty
 model_id3747
 tagImage
 name1724068_5-9.jpg
 typeimage/jpeg
 size203812
 uri/assets/22852.jpg
 order8
 created2018-05-02 14:29:46
 modified2018-05-02 14:35:42
 9(array)
 id22853
 modelProperty
 model_id3747
 tagImage
 name1724068_5-10.jpg
 typeimage/jpeg
 size205836
 uri/assets/22853.jpg
 order9
 created2018-05-02 14:29:47
 modified2018-05-02 14:35:42
 10(array)
 id22854
 modelProperty
 model_id3747
 tagImage
 name1724068_5-11.jpg
 typeimage/jpeg
 size219211
 uri/assets/22854.jpg
 order10
 created2018-05-02 14:29:47
 modified2018-05-02 14:35:42
 11(array)
 id22855
 modelProperty
 model_id3747
 tagImage
 name1724068_5-12.jpg
 typeimage/jpeg
 size195677
 uri/assets/22855.jpg
 order11
 created2018-05-02 14:29:47
 modified2018-05-02 14:35:42
 12(array)
 id22856
 modelProperty
 model_id3747
 tagImage
 name1724068_5-13.jpg
 typeimage/jpeg
 size192282
 uri/assets/22856.jpg
 order12
 created2018-05-02 14:29:47
 modified2018-05-02 14:35:42
 13(array)
 id22857
 modelProperty
 model_id3747
 tagImage
 name1724068_5-14.jpg
 typeimage/jpeg
 size185810
 uri/assets/22857.jpg
 order13
 created2018-05-02 14:29:47
 modified2018-05-02 14:35:42
 14(array)
 id22858
 modelProperty
 model_id3747
 tagImage
 name1724068_5-15.jpg
 typeimage/jpeg
 size190086
 uri/assets/22858.jpg
 order14
 created2018-05-02 14:29:48
 modified2018-05-02 14:35:42
 User(array)
 0(array)
 id1281
 typeAgent
 brokerage_id70
 email[email protected]
 password6e83e74e5aad7dc2404b41f4dad53b857b4a34ae
 recover_hash
 first_nameMike
 last_nameStratford
 title
 dre_num
 phone4246341622
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2018-08-22 14:50:21
 created2018-08-22 14:50:21
 notified(false)
 full_nameMike Stratford
 uri/agent-detail/1281/mike-stratford
 profile_complete(true)
 UsersProperty(array)
 id1110
 user_id1281
 property_id3747
 sort_order0
 1(array)
 id1278
 typeAgent
 brokerage_id70
 email[email protected]
 password6e83e74e5aad7dc2404b41f4dad53b857b4a34ae
 recover_hash
 first_nameCynthia
 last_nameMurray
 title
 dre_num
 phone8888888888
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2018-04-25 13:15:33
 created2018-04-25 13:15:33
 notified(false)
 full_nameCynthia Murray
 uri/agent-detail/1278/cynthia-murray
 profile_complete(true)
 UsersProperty(array)
 id1111
 user_id1278
 property_id3747
 sort_order1
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id2
 nameBeach Access
 additional(false)
 created2016-04-07 14:00:52
 modified2016-04-07 14:00:52
 PropertiesPropertyFeature(array)
 id4721
 property_id3747
 property_feature_id2
 Topic(array)
 0(array)
 id8
 nameBeach
 created2016-02-25 11:25:00
 modified2016-02-25 11:30:26
 tile_nameBeach
 PropertiesTopic(array)
 id50
 property_id3747
 topic_id8
 1(array)
 Property(array)
 id3739
 brokerage_id1
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameElegant, Contemporary Oasis Overlooking Pacific Ocean
 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)
 descriptionWelcome to an oasis over looking the Pacific Ocean, where crashing waves and vivid sunsets create the quintessential beach living environment. The controlled access exterior entry sets the tone for the elegance and sophistication that awaits you upon entering the residence. Built with style and taste, this contemporary villa offers great scale for avid art collectors and a casual, "kick your shoes off" environment to simply relax and enjoy the success you've created. Beyond the elegant main living room and entertainment spaces, prepare for the explosive, head on ocean views that beckon beyond banks of oversized French doors. The grand deck with fire pit, spa tub and dedicated access to the sand below creates one of the finest locations to enjoy one of nature's true wonders. The master suite is ideally situated to take in the majestic views and with an oversized bath and large en-suite closet; you'll realize that the layout has been carefully thought out.
 address31652 Broad Beach Road
 address_2
 cityMalibu
 stateCA
 postal_code90265
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price5800000
 price_20
 price_usd5800000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms3
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet3563
 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://31652broadbeachroad1.thepartnerstrust.com/
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1994
 virtual_tour
 video_tourhttp://www.onvedeo.com/properties/762171/embed
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num16114818
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style17
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude34.036472
 longitude-118.864647
 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 09:11:09
 created2016-04-18 09:07:21
 uri/property-detail/3739/31652-broad-beach-road-malibu-ca-90265-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3739/31652-broad-beach-road-malibu-ca-90265-usa
 address_concat31652 Broad Beach Road Malibu CA 90265 USA
 google_maps_query_string31652+Broad+Beach+Road++Malibu+CA+90265+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 5,800,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty3
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-04-18
 overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id1
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties12
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties1
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id1
 WOEID2363796
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePartners Trust Real Estate Brokerage and Acquisitions
 broker_of_record_name
 short_namePartners Trust Real Estate
 usernamePartnersTrustBH
 password2a77eb13ee7deac93b310ba1431a4982bfdbddeb
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 description<h2> </h2> Partners Trust is the exclusive representative for Leverage Global Partners in Beverly Hills, California, USA. We are dedicated to being the finest real estate brokerage in Los Angeles. At Partners Trust, our objective is to present our clients with the most professional, successful and ethical real estate associates in the business and to represent our clients with care, confidentiality and the utmost attention to service. We believe we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market. We begin with a commodity that is hard-earned and easily lost: TRUST. Without the daily demonstration and commitment to uphold principles, a company’s mission statement is simply words on a page and nothing more. Partners Trust has adopted a mission statement that each Associate and staff member must sign to in order to participate with the Company, which articulates the core philosophy and culture of the Company. The Partners Trust founders utilized their extensive experience and resources to create a Company that is both unique and beneficial for those willing to commit to the rigorous standards that have been set forth. The Company’s intention is to empower each member of its sales force each and every step of the way. Partners Trust has additional office locations in <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/5/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Pasadena</a>, <a href="../../../brokerage-detail/142/Partners-Trust" target="_blank">Malibu</a> and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a>
 communitiesBeverly Hills Bel Air Century City Westwood West Hollywood
 websitehttp://thepartnerstrust.com
 address9378 Wilshire Boulevard
 address_2Suite 200
 cityBeverly Hills
 stateCA
 full_stateCalifornia
 countryUSA
 marketBeverly Hills
 market_2
 postal_code90212
 phone(310) 500-1388
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameNick Segal
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/presidential-profile-partners-trust-real-estate-brokerage-aquisitions-nick-segal/
 contact_big_profile_link_text
 contact_titlePresident/Co-Founder
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename1.jpg
 logo_filename1.png
 contact_image_filename1.jpg
 all_properties_link_image_filename1.jpg
 all_properties_linkhttp://www.thepartnerstrust.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleBeverly Hills Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
 meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions is an award-winning real estate brokerage representing Leverage Global Partners in Beverly Hills, CA, USA.
 meta_keywordspartners trust, partners trust real estate, beverly hills real estate, beverly hills real estate agents, leverage global partners
 login_message_counter2
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-02-21 13:57:13
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/1/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortthepartnerstrust.com
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id20944
 modelProperty
 model_id3739
 tagImage
 name31652broadbeach-high-1.jpg.jpg
 typeimage/jpeg
 size308963
 uri/assets/20944.jpg
 order0
 created2016-04-18 09:06:27
 modified2016-04-18 09:07:21
 1(array)
 id20943
 modelProperty
 model_id3739
 tagImage
 name31652broadbeach-high-9.jpg.jpg
 typeimage/jpeg
 size193413
 uri/assets/20943.jpg
 order1
 created2016-04-18 09:06:27
 modified2016-04-18 09:07:21
 2(array)
 id20945
 modelProperty
 model_id3739
 tagImage
 name7.jpg
 typeimage/jpeg
 size281415
 uri/assets/20945.jpg
 order2
 created2016-04-18 09:06:27
 modified2016-04-18 09:07:21
 3(array)
 id20946
 modelProperty
 model_id3739
 tagImage
 name8.jpg
 typeimage/jpeg
 size1609822
 uri/assets/20946.jpg
 order3
 created2016-04-18 09:06:29
 modified2016-04-18 09:07:21
 4(array)
 id20948
 modelProperty
 model_id3739
 tagImage
 name14.jpg
 typeimage/jpeg
 size3136334
 uri/assets/20948.jpg
 order4
 created2016-04-18 09:06:32
 modified2016-04-18 09:07:21
 5(array)
 id20949
 modelProperty
 model_id3739
 tagImage
 name-.jpg
 typeimage/jpeg
 size3188234
 uri/assets/20949.jpg
 order5
 created2016-04-18 09:06:34
 modified2016-04-18 09:07:21
 6(array)
 id20950
 modelProperty
 model_id3739
 tagImage
 name16.jpg
 typeimage/jpeg
 size3828702
 uri/assets/20950.jpg
 order6
 created2016-04-18 09:06:35
 modified2016-04-18 09:07:21
 7(array)
 id20951
 modelProperty
 model_id3739
 tagImage
 name- 3.jpg
 typeimage/jpeg
 size3057167
 uri/assets/20951.jpg
 order7
 created2016-04-18 09:06:36
 modified2016-04-18 09:07:21
 8(array)
 id20947
 modelProperty
 model_id3739
 tagImage
 nameDining Room_Broad Beach.jpg
 typeimage/jpeg
 size2836493
 uri/assets/20947.jpg
 order8
 created2016-04-18 09:06:31
 modified2016-04-18 09:07:21
 9(array)
 id20952
 modelProperty
 model_id3739
 tagImage
 nameOcean View _Broad Beach.jpg
 typeimage/jpeg
 size3363440
 uri/assets/20952.jpg
 order9
 created2016-04-18 09:06:37
 modified2016-04-18 09:07:21
 User(array)
 0(array)
 id299
 typeAgent
 brokerage_id1
 email[email protected]
 password5752832063d4fe000ce359059ea51ec8c2330095
 recover_hash
 first_nameFelecia
 last_nameWesley
 title
 dre_num
 phone310.500.1383
 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_nameFelecia Wesley
 uri/agent-detail/299/felecia-wesley
 profile_complete(true)
 UsersProperty(array)
 id74
 user_id299
 property_id3739
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id4409
 property_id3739
 property_feature_id1
 1(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id4410
 property_id3739
 property_feature_id14
 Topic(array)
 0(array)
 id1
 nameArts & Culture
 created2016-02-25 11:25:00
 modified2016-02-25 11:29:58
 tile_nameArts & Culture
 PropertiesTopic(array)
 id41
 property_id3739
 topic_id1
 1(array)
 id8
 nameBeach
 created2016-02-25 11:25:00
 modified2016-02-25 11:30:26
 tile_nameBeach
 PropertiesTopic(array)
 id42
 property_id3739
 topic_id8
 2(array)
 Property(array)
 id3721
 brokerage_id165
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameIconic corner brownstone on uptown Garden Street
 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)
 descriptionIconic corner brownstone on uptown Garden Street with 2+ car parking. A truly exceptional property, 1200 Garden Street offers southern, eastern & western exposures, a contemporary open floor plan, deck & large yard professionally landscaped by Hufnagel. Three beautiful bay windows grace the parlor floor accompanied by a gas fireplace, parquet floors with marquetry inlay border, formal dining room & powder room. The designer kitchen has a Viking 6 burner gas range, Sub Zero refrigerator, Bosch dishwasher and double wall ovens. The second floor offers a master retreat with cathedral ceiling, skylights and sliding glass doors to Juliette balcony. Private en suite bath features marble and limestone tile, dual sink vanity, separate shower & freestanding Bain Ultra air bubble tub. Completing the second floor – an additional bedroom/family room with custom built-in cabinetry and additional full bathroom. The top floor has 2 large, bright bedrooms and a full bath. Other features include a finished basement/playroom, storage, laundry center with laundry chute, gas baseboard heat, 3 zone high velocity heat & central air conditioning, central alarm system, crown moldings, medallions, hardwood floors & custom window shutters.
 address1200 Garden St.
 address_2
 cityHoboken
 stateNJ
 postal_code07030
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2850000
 price_20
 price_usd2850000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_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://homes.hudsonplacerealty.com/idx/details/homes/b120/160005043/1200-GARDEN-ST-Hoboken-New-Jersey
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial2
 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.751541
 longitude-74.028709
 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 10:33:01
 created2016-04-12 10:02:35
 uri/property-detail/3721/1200-garden-st-hoboken-nj-07030-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3721/1200-garden-st-hoboken-nj-07030-usa
 address_concat1200 Garden St. Hoboken NJ 07030 USA
 google_maps_query_string1200+Garden+St.++Hoboken+NJ+07030+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,850,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty3
 bathrooms_partial_pretty2
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-04-12
 overridden_brokerage_nameHudson Place Realty
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id165
 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
 WOEID2422673
 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
 nameHudson Place Realty
 broker_of_record_name
 short_nameHudson Place Realty
 usernameHudsonPlaceRealty
 passwordbef5e4553a98ab317b9ec8fad37181955e6d7c1a
 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
 descriptionHudson Place Realty is the exclusive representative for Leverage Global Partners in Hoboken, Jersey City, Weehawken, Hudson County, New Jersey, USA. A Tradition of Professionalism Established in 1979, Hudson Place Realty has provided intelligent and sophisticated real estate services to buyers and sellers in Hoboken, Jersey City and the extended Hudson County communities. Though initially just a handful of agents, the firm was positioned to be a pivotal contributor to the renaissance of Hoboken. Its mission was clear to help re- energize the community by drawing attention to the opportunities that lay here. As residents ourselves, we saw the potential for a dynamic community carrying on a grand urban tradition. From the beginning, HPR felt that the best way to serve our neighbors was from the community out. Through good times and bad, HPR has been steadfast, continuing to help our clients realize their goals with our extensive knowledge of the market, home-grown business savvy, and the distinctive HPR personal touch that has earned their loyalty and friendship. In those early years, Hudson Place Realty agents became experts in our fields of service, whether residential, commercial, investment or development. Today, we have added the immense power of technology and advanced marketing strategies. We remain a community-based boutique firm and our first priority, now as then, is to build strong relationships with our clients and to continue fostering the neighborhoods we serve. We have recruited over the years a highly selective group of the best agents in the business who every day offer their knowledge and skills to the clients we are privileged to serve. Our office, like the neighborhoods we live in, is comprised of a wide diversity of personalities, talents, and professional training. Collectively, we hold a vast network of resources to benefit our eclectic, urban clientele. Now, as then, we are united in our commitment to one goal: Uncompromising excellence in the service we provide to our clients.
 communitiesHoboken Jersey City Weehawken Hudson County
 websitehttp://hudsonplacerealty.com/
 address132 Washington Street
 address_2
 cityHoboken
 stateNJ
 full_stateNew Jersey
 countryUSA
 market
 market_2
 postal_code07030
 phone(201) 420-7393
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJon Sisti
 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_filename165.jpg
 logo_filename165.jpg
 contact_image_filename165.jpg
 all_properties_link_image_filename165.jpg
 all_properties_linkhttp://homes.hudsonplacerealty.com/idx/featured
 video_embed_code
 contact_video_embed_code
 meta_titleHoboken Real Estate | Hudson Place Realty | Leverage Global Partners
 meta_descriptionHudson Place Realty is the exclusive representative for Leverage Global Partners in Hoboken, NJ, USA.
 meta_keywordsHudson Place Realty, Hoboken Real Estate, Jon Sisti, Jersey City real estate, Weehawken real estate, Hudson County 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-30 14:36:22
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/165/hudson-place-realty
 website_shorthudsonplacerealty.com
 name_with_locationHudson Place Realty
 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)
 id20670
 modelProperty
 model_id3721
 tagImage
 name_DSC6585.jpg
 typeimage/jpeg
 size5140581
 uri/assets/20670.jpg
 order0
 created2016-04-12 10:02:21
 modified2016-04-12 10:02:35
 1(array)
 id20663
 modelProperty
 model_id3721
 tagImage
 name_DSC6065.jpg
 typeimage/jpeg
 size6451893
 uri/assets/20663.jpg
 order1
 created2016-04-12 09:59:00
 modified2016-04-12 10:02:35
 2(array)
 id20664
 modelProperty
 model_id3721
 tagImage
 name_DSC6071.jpg
 typeimage/jpeg
 size4847028
 uri/assets/20664.jpg
 order2
 created2016-04-12 09:59:16
 modified2016-04-12 10:02:35
 3(array)
 id20665
 modelProperty
 model_id3721
 tagImage
 name_DSC6088.jpg
 typeimage/jpeg
 size6703840
 uri/assets/20665.jpg
 order3
 created2016-04-12 09:59:49
 modified2016-04-12 10:02:35
 4(array)
 id20666
 modelProperty
 model_id3721
 tagImage
 name_DSC6095.jpg
 typeimage/jpeg
 size6828837
 uri/assets/20666.jpg
 order4
 created2016-04-12 09:59:59
 modified2016-04-12 10:02:35
 5(array)
 id20667
 modelProperty
 model_id3721
 tagImage
 name_DSC6124.jpg
 typeimage/jpeg
 size5918753
 uri/assets/20667.jpg
 order5
 created2016-04-12 10:01:04
 modified2016-04-12 10:02:35
 6(array)
 id20668
 modelProperty
 model_id3721
 tagImage
 name_DSC6129.jpg
 typeimage/jpeg
 size6880195
 uri/assets/20668.jpg
 order6
 created2016-04-12 10:01:33
 modified2016-04-12 10:02:35
 7(array)
 id20669
 modelProperty
 model_id3721
 tagImage
 nameIMG_4560.jpg
 typeimage/jpeg
 size6551733
 uri/assets/20669.jpg
 order7
 created2016-04-12 10:02:00
 modified2016-04-12 10:02:35
 User(array)
 0(array)
 id1198
 typeAgent
 brokerage_id165
 email[email protected]
 passwordce7171db7786602ed88319856b5134098996f127
 recover_hash
 first_nameIrene
 last_namePerello
 title
 dre_num
 phone20168161910
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:58
 created2017-08-07 15:23:58
 notified(false)
 full_nameIrene Perello
 uri/agent-detail/1198/irene-perello
 profile_complete(true)
 UsersProperty(array)
 id1005
 user_id1198
 property_id3721
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id16
 nameWasher Dryer
 additional(false)
 created2016-04-07 14:05:42
 modified2016-04-07 14:05:42
 PropertiesPropertyFeature(array)
 id4370
 property_id3721
 property_feature_id16
 Topic(empty)
 3(array)
 Property(array)
 id3715
 brokerage_id157
 created_by_user_id0
 order1
 multi_unit(false)
 agent_1_id283
 agent_2_id284
 agent_3_id0
 nameHandsome English Tudor
 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)
 descriptionHandsome 5 Bedroom, 3 full and 2 half bath, English Tudor in Old Short Hills. An easy walk to downtown Millburn and close to the Midtown Direct train. Located in a picturesque neighborhood in the Hartshorn School District with exquisite landscaping and a private back yard. Impressive curb appeal with a beautiful multi-colored slate roof, all copper gutters and leaders, decorative stained and leaded glass windows and unique architectural details throughout. A 2-story stained glass bay window greets you in the entry foyer and grand staircase. A fireplace, bay window seat and leaded glass bar add special appeal to the grand living room that opens to a sun room or office which leads to a stone patio, surrounded by flowering gardens. The dining room seats 12 comfortably with 2 corner leaded glass cabinets offering ample storage for dishes and stemware. Just off the modern kitchen are a sunny breakfast room, the laundry closet and a cozy nanny's bedroom and bath en-suite. Right outside there is a small open porch, with wood storage below, that leads to an upper patio, driveway that is perfect for trikes and basketball, and a grassy yard for relaxing and entertaining. Upstairs are 4 bedrooms, 2 bathrooms, a lovely landing area to cozy up with a book, and one bedroom has an extra room that can be used as a dressing room. The over-sized master bedroom has 2 walk-in closets and wonderful views from many windows. The storage attic runs the entire width of the house and there is also a ground level basement. The recreation room features a stone fireplace, a half bath, lots of storage, a work shop, access to the 2 car garage and plenty of natural light from big windows and a door to the yard. 
 address38 Sherwood Road
 address_2
 cityShort Hills
 stateNJ
 postal_code07078
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1500000
 price_20
 price_usd1500000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms5
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1garage
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://www.38Sherwood.com
 meta_titleHandsome English Tudor | Short Hills Real Estate | Towne Realty Group
 meta_description38 Sherwood Road is a property offered for sale in Short Hills, NJ, USA, presented by Towne Realty Group
 meta_keywords
 bathrooms_partial2
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://www.seetheproperty.com/196342
 video_tourhttp://seetheproperty.com/196342/video
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude37.090240
 longitude-95.712891
 invalid_required_fields
 invalid_optional_fieldssquare_feet, square_meters, acres, hectares
 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-08 09:12:57
 uri/property-detail/3715/38-sherwood-road-short-hills-nj-07078-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3715/38-sherwood-road-short-hills-nj-07078-usa
 address_concat38 Sherwood Road Short Hills NJ 07078 USA
 google_maps_query_string38+Sherwood+Road++Short+Hills+NJ+07078+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,500,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty3
 bathrooms_partial_pretty2
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-04-08
 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)
 id20606
 modelProperty
 model_id3715
 tagImage
 name36067.jpg
 typeimage/jpeg
 size8450952
 uri/assets/20606.jpg
 order0
 created2016-04-11 18:10:59
 modified2016-04-11 18:12:53
 1(array)
 id20608
 modelProperty
 model_id3715
 tagImage
 name36070.jpg
 typeimage/jpeg
 size11188714
 uri/assets/20608.jpg
 order1
 created2016-04-11 18:11:03
 modified2016-04-11 18:12:53
 2(array)
 id20607
 modelProperty
 model_id3715
 tagImage
 name36069.jpg
 typeimage/jpeg
 size13230811
 uri/assets/20607.jpg
 order2
 created2016-04-11 18:11:01
 modified2016-04-11 18:12:53
 3(array)
 id20612
 modelProperty
 model_id3715
 tagImage
 name36071.jpg
 typeimage/jpeg
 size8029109
 uri/assets/20612.jpg
 order3
 created2016-04-11 18:11:09
 modified2016-04-11 18:12:53
 4(array)
 id20613
 modelProperty
 model_id3715
 tagImage
 name36072.jpg
 typeimage/jpeg
 size7617858
 uri/assets/20613.jpg
 order4
 created2016-04-11 18:12:21
 modified2016-04-11 18:12:53
 5(array)
 id20609
 modelProperty
 model_id3715
 tagImage
 name36073.jpg
 typeimage/jpeg
 size8253500
 uri/assets/20609.jpg
 order5
 created2016-04-11 18:11:04
 modified2016-04-11 18:12:53
 6(array)
 id20605
 modelProperty
 model_id3715
 tagImage
 name36068.jpg
 typeimage/jpeg
 size9278928
 uri/assets/20605.jpg
 order6
 created2016-04-11 18:10:57
 modified2016-04-11 18:12:53
 7(array)
 id20610
 modelProperty
 model_id3715
 tagImage
 name36074.jpg
 typeimage/jpeg
 size8414125
 uri/assets/20610.jpg
 order7
 created2016-04-11 18:11:06
 modified2016-04-11 18:12:53
 8(array)
 id20611
 modelProperty
 model_id3715
 tagImage
 name36075.jpg
 typeimage/jpeg
 size7708807
 uri/assets/20611.jpg
 order8
 created2016-04-11 18:11:07
 modified2016-04-11 18:12:53
 User(array)
 0(array)
 id496
 typeAgent
 brokerage_id157
 email[email protected]
 passwordc80aef26fd457ef0cffd6a16e16dde7ddf08bb12
 recover_hash
 first_nameKaren
 last_nameBigos
 title
 dre_num
 phone201-417-1600
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:01
 created2017-08-07 15:23:01
 notified(false)
 full_nameKaren Bigos
 uri/agent-detail/496/karen-bigos
 profile_complete(true)
 UsersProperty(array)
 id319
 user_id496
 property_id3715
 sort_order0
 1(array)
 id497
 typeAgent
 brokerage_id157
 email[email protected]
 passwordb0e054b97f20dd600a8a6a7e55c2c1338afb9fcc
 recover_hash
 first_nameDaniel
 last_nameCannizzo
 title
 dre_num
 phone973-865-4144
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:01
 created2017-08-07 15:23:01
 notified(false)
 full_nameDaniel Cannizzo
 uri/agent-detail/497/daniel-cannizzo
 profile_complete(true)
 UsersProperty(array)
 id327
 user_id497
 property_id3715
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id4356
 property_id3715
 property_feature_id4
 Topic(empty)
- sidebar_brokerages(array)
 0(array)
 Brokerage(array)
 id153
 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
 WOEID4118
 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
 nameForest Hill Real Estate Inc
 broker_of_record_name
 short_nameForest Hill Real Estate Inc
 usernameForestHillRealEstate
 passwordf43a3ef674ab80ffe6ede6e641951411f4b7f152
 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
 descriptionForest Hill Real Estate is the exclusive representative for Leverage Global Partners in the Greater Toronto area and Cottage Country, Ontario, Canada. Founded in 1985 Forest Hill Real Estate Inc., has specialized in the sale of prestigious homes, luxury condominiums, country properties, estates, vacant lots and commercial and industrial properties. In the past decade alone, the company has participated in well over ten billion dollars in real estate sales volume. Forest Hill Real Estate Inc., is a premier leader in the Toronto and surrounding areas real estate market. Our fourteen offices are strategically located in Toronto, Muskoka, Kawarthas and Lake Simcoe Cottage Country and opening soon in Oakville, Ontario, as a fast growing upwardly bound and upscale area, we proudly boast 450 sales people….and growing. Forest Hill Real Estate Inc., attributes the tremendous success of the company, to committed personalized client service to both Sellers and Buyers, combined with target marketing, upscale internet networking, sophisticated technology, on-going sales training to further help our very experienced and professional real estate sales associates, our full-time knowledgeable, dedicated support staff is a wonderful asset to our company. Contributing further to the company's success is extensive market research, print advertising, advanced computer technology is always number one in our goals, our weekly in-house meetings and frequent seminars conducted by both real estate and other professionals in the business community, adds to our continued success. Our association with world renowned Who's Who in Luxury Real Estate further builds and enhances our company profile and exposes our listings to an upscale international market through their website. www.luxuryrealestate.com Our own website, www.foresthill.com, is a user friendly and effective way for the public to locate our luxury homes, "first time" buying opportunities, condominium developments, summer homes, and wide range of commercial properties. Our social media department which populates Facebook, LinkedIn, Twitter and Instagram and monitored daily by our in-house marketing staff. It is a pleasure to align ourselves with our esteemed new partner “Leverage Global Part firms from around the world, creating a global network of professionals that serve the relocation needs of homebuyers and sellers, nationally and internationally. Within each market, the consumer and brokerage communities alike have direct access to the President of each exclusive Global Partner. www.leveragere.com As the founder I am proud of our company's success, reputation and accomplishments. Each sales representative is a vital cog in our wheel of our good fortune. Our name says Forest Hill…Our market is simply your neighbourhood.
 communitiesToronto Port Carling Thornhill Bala Port Sandfield
 websitehttp://www.foresthill.com/
 address441 Spadina Road
 address_2
 cityGreater Toronto
 stateOntario
 full_state
 countryCanada
 market
 market_2
 postal_code
 phoneOffice: (416) 488-2875
 phone_2Cell: (416) 464-6344
 phone_3
 wide_contact_image(false)
 contact_nameRonni Fingold
 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_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_filename153.jpg
 logo_filename153.jpg
 contact_image_filename153.jpg
 all_properties_link_image_filename153.jpg
 all_properties_linkhttp://www.foresthill.com/treblistings/show
 video_embed_code
 contact_video_embed_code
 meta_titleGreater Toronto Real Estate | Forest Hill Real Estate Inc | Leverage Global Partners
 meta_descriptionForest Hill Real Estate is the exclusive representative for Leverage Global Partners in Greater Toronto, Ontario, Canada.
 meta_keywordsForest Hill Real Estate, Toronto Real Estate, Ronni Fingold, Toronto real estate, Port Carling real estate, Thornhill real estate, Peterborough real estate, Bala real estate, Port Sandfield real estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-08-20 15:34:38
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/153/forest-hill-real-estate-inc
 website_shortwww.foresthill.com
 name_with_locationForest Hill Real Estate Inc
 Logo(array)
 id2692
 modelBrokerage
 model_id153
 tagLogo
 name153.jpg
 typeimage/jpg
 size79813
 uri/assets/2692.jpg
 order0
 created2016-03-30 11:42:28
 modified2016-03-30 11:42:28
 1(array)
 Brokerage(array)
 id70
 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_properties3
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id13
 WOEID23706483
 timezoneEurope/Lisbon
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id9
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameQuinta Properties
 broker_of_record_name
 short_nameQuinta Properties
 usernameQuintaProperties
 passwordbfa20d0f7d557565a3e9f0589db0a06e4c9546f3
 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
 descriptionQuinta Properties is the exclusive representative for Leverage Global Partners in the Algarve, Portugal. Quinta Properties deal with some of the most exclusive luxury villas and exciting property in and around Quinta do Lago. As the chosen associates of Savills, they offer in-depth knowledge and experience to meet your real estate needs. Anyone who knows Quinta Properties and has dealt with Alison, Kerstin, and their team will know they are passionate about property. Their wide experience in the local property market enables them to recommend legal, architectural, financial and construction professionals who understand the needs of prospective buyers in the locality. Quinta Properties are registered with the Portuguese authorities as licensed agents, meeting stringent standards. Their staff are fluent in English, German, French, and Portuguese. "We make it our business to support you, to explain all the options, procedures and pitfalls and to carefully guide you through the entire process from purchasing to sellingluxury Quinta do Lago villas and other fine properties in the Quinta do Lago and the whole Algarve area." --Alison Buechner Hojbjerg and Kerstin Buechner
 communitiesalgarve the algarve quinta do lago
 websitehttp://www.quintaproperty.com/
 addressAvenida da Gondra
 address_2Quinta do Lago
 cityAlmancil
 state
 full_state
 countryPortugal
 marketAlgarve
 market_2
 postal_code8135-162
 phone+351 289 396 073
 phone_2+351 289 398086 (Fax)
 phone_3
 wide_contact_image(false)
 contact_nameAlison Buechner Hojbjerg and Kerstin Buechner
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleDirectors
 contact_dre_num
 contact_quoteWe invite you to contact us about real estate in the Algarve
 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_filename70.jpg
 logo_filename70.jpg
 contact_image_filename70.jpg
 all_properties_link_image_filename70.jpg
 all_properties_linkhttp://www.quintaproperty.com/algarve/
 video_embed_code
 contact_video_embed_code
 meta_titleAlgarve Real Estate | Quinta Properties | Leverage Global Partners
 meta_descriptionQuinta Properties is the exclusive representative for Leverage Global Partners in the Algarve, Portugal.
 meta_keywordsQuinta Properties, Algarve Real Estate, Leverage Global Partners, Alison Buechner Hojbjerg
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-11-15 11:23:29
 modified2020-11-20 12:05:11
 dre_num012345
 uri/brokerage-detail/70/quinta-properties
 website_shortwww.quintaproperty.com
 name_with_locationQuinta Properties
 mlsidx_id_array(array)
 09
 Logo(array)
 id2443
 modelBrokerage
 model_id70
 tagLogo
 name70.jpg
 typeimage/jpg
 size696260
 uri/assets/2443.jpg
 order0
 created2016-03-30 11:39:44
 modified2018-04-25 10:57:26
 2(array)
 Brokerage(array)
 id235
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties1
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id0
 WOEID2388929
 timezoneUS/Central
 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
 nameNathan Grace Real Estate
 broker_of_record_name
 short_nameNathan Grace Real Estate
 usernameNathanGraceREdallas
 passwordd651c364db6b22a62aead6006aa3c4dc078158e9
 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
 descriptionNathan Grace Real Estate is the exclusive representative for Leverage Global Partners in Dallas, Texas, representing all of Dallas County. We are also the exclusive representative for Leverage Global Partners in <a href="../../../brokerage-detail/236/Nathan-Grace-Real-Estate" target="_blank">Collin County</a>. Nathan Grace Real Estate is a boutique real estate company dedicated to the client, community and industry. As a business and as individuals we strive to act with integrity and personal excellence in all we do. Our core values inspire our actions and decisions. We live these values every day: Inspire Trust, Act Responsibly, Embrace Diversity, Pursue Growth and Learning, Support Our Communities, Communicate with Honesty, Participate in Forward Thinking and Celebrate the Fun in Life. Nathan Grace is committed to giving back to the communities and industry we serve. As an organization and as individuals we donate time, material goods and money to a variety of organizations.
 communitiesDallas Dallas County Collin County Frisco Plano McKinney Allen Prosper
 websitehttp://www.nathangracerealestate.com/
 address5949 Sherry Lane, Suite 1220
 address_2
 cityDallas
 stateTX
 full_stateTexas
 countryUSA
 marketDallas
 market_2
 postal_code75225
 phoneCell: (972) 670-3437
 phone_2Office: (214) 765-0601
 phone_3
 wide_contact_image(false)
 contact_nameVickie Parker
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Dallas 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_filename235.jpg
 logo_filename235.jpg
 contact_image_filename235.jpg
 all_properties_link_image_filename235.jpg
 all_properties_linkhttp://www.nathangracerealestate.com/pages/nathangrace-content/Featured_listings/
 video_embed_code
 contact_video_embed_code
 meta_titleDallas Real Estate | Nathan Grace Real Estate | Leverage Global Partners
 meta_descriptionNathan Grace Real Estate is the exclusive representative for Leverage Global Partners in Dallas, Texas, representing all of Dallas County.
 meta_keywordsNathan Grace Real Estate, Leverage Global Partners, Dallas real estate, Texas real estate, Dallas County
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-11-23 10:38:41
 modified2016-04-08 16:34:31
 dre_num012345
 uri/brokerage-detail/235/nathan-grace-real-estate
 website_shortwww.nathangracerealestate.com
 name_with_locationNathan Grace Real Estate
 Logo(array)
 id2917
 modelBrokerage
 model_id235
 tagLogo
 name235.jpg
 typeimage/jpg
 size60339
 uri/assets/2917.jpg
 order0
 created2016-03-30 11:45:37
 modified2016-03-30 11:45:37
 3(array)
 Brokerage(array)
 id37
 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
 WOEID2456968
 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
 nameCongdon & Coleman Real Estate
 broker_of_record_name
 short_nameCongdon & Coleman
 usernameCongdonColeman
 passwordf9492e65b683bc67dda66f994a01ecfb704a5f81
 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
 descriptionCongdon & Coleman Real Estate is the exclusive representative for Leverage Global Partners in Nantucket, Massachusetts, USA. Resident Experts: Nantucket Real Estate & Summer Rentals Congdon & Coleman Real Estate, founded in 1931, is a fourth generation Nantucket business. It is the only combined Nantucket real estate and insurance company on island. Our real estate agents are all Nantucket island residents who are active in the community and committed to preserving the quality of life here. If you choose to invest in Nantucket real estate, rely on the people who know it best. Congdon & Coleman Real Estate is a full service firm handling listing, selling and rentals. Each of our agents is a Realtor and a member of the Cape Cod & Islands Association of Realtors. We are also members of the Nantucket Association of Real Estate Brokers, which gives us accurate, current information on all properties for sale on Nantucket. When you list your property with Congdon & Coleman, inclusion with this service ensures that your property receives maximum exposure to all agents on Nantucket. Simply put, our brokers can show you any Nantucket real estate for sale on the island.
 communitiesNantucket
 websitehttp://www.congdonandcoleman.com
 address57 Main Street
 address_2
 cityNantucket
 stateMA
 full_stateMassachusetts
 countryUSA
 marketNantucket
 market_2
 postal_code02554
 phone(508) 325-5016
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTom Kennelly
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-tom-kennelly-president-congdon-and-coleman-real-estate/
 contact_big_profile_link_text
 contact_titlePresident, 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_filename37.jpg
 logo_filename37.png
 contact_image_filename37.jpg
 all_properties_link_image_filename37.jpg
 all_properties_linkhttp://www.congdonandcoleman.com/nantucket-sales/homes.asp
 video_embed_code
 contact_video_embed_code
 meta_titleNantucket Real Estate | Congdon & Coleman Real Estate | Leverage Global Partners
 meta_descriptionCongdon & Coleman Real Estate is Leverage Global Partners' exclusive representative in Nantucket, MA, USA.
 meta_keywordsNantucket real estate, Massachusetts real estate, Tom Kennelly, Congdon & Coleman, 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-07-24 14:33:33
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/37/congdon-coleman-real-estate
 website_shortwww.congdonandcoleman.com
 name_with_locationCongdon & Coleman Real Estate
 Logo(array)
 id2347
 modelBrokerage
 model_id37
 tagLogo
 name37.png
 typeimage/png
 size8160
 uri/assets/2347.png
 order0
 created2016-03-30 11:37:49
 modified2016-03-30 11:37:49
- sidebar_locations(array)
 0(array)
 Location(array)
 id141
 parent_id9
 brokerage_id175
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameBoise, ID, USA
 short_nameBoise, ID, USA
 group_index
 latitude43.618710
 longitude-116.214607
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionWelcome to the Treasure Valley and Boise, Idaho
 long_descriptionSituated along the beautiful Boise River in the shadow of the Rocky Mountains is a fast-growing city. Boise is located at the center of commerce, government, and culture in Idaho's capital. Boasting several Fortune 500 companies with national headquarters, Boise benefits from high-technology, natural beauty and a focus on an idyllic "lifestyle".
 created2016-04-07 16:06:12
 modified2016-04-07 16:06:12
 timezoneAmerica/Denver
 population600000
 uri/locations/view/141/boise-id-usa
 tile_nameBoise, ID, USA
 Brokerage(array)
 id175
 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_modeLegacy
 max_luxury_feed_properties3
 membership_luxury_feed_properties3
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2366355
 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
 nameAmherst Madison Partners
 broker_of_record_name
 short_nameAmherst Madison Partners
 usernameAmherstMadisonPartners
 password6d698ab9779b23da643ce61980178e148037cae4
 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
 descriptionAmherst Madison Partners is the exclusive representative for Leverage Global Partners in all of Canyon & Ada Counties, including Boise, Meridian, Eagle, Caldwell, Nampa, Kuna, and Star, Idaho, USA. Our brokerage has been described as the “pre-eminent luxury brand in Idaho” due to our personalized service, large social network, in-house media department, and intimate knowledge of the local market. We offer our clients a level of care that stands above the rest. While we represent you with the highest levels of service and attention to detail, our true love is the friendships created in the process. Whether you are buying or selling we understand the process can often be challenging and complicated. We focus on reducing any pressure, so clear and intelligent decisions can be made every step of the way. Your unequivocal satisfaction is our primary goal, and we utilize our competence, technology, and “Concierge Approach” to make that happen. For us, marketing a home is an art form. We thrive on perfection, and we showcase this for our Clients through staging, aerial photography, 3-D home tours, high definition media, Ad-Agency content creation, paid social media, search engine optimization, and a cloud based transaction management platform. We know that each buying or selling situation is unique, therefore each approach will to be specifically tailored to your requirements. Every one of our Agents and Staff is vested in making sure you receive the results you are looking for no matter what it takes. Amherst Madison Partners was the first Idaho real estate brokerage featured on HGTV and the first Idaho company to use branded 3-D Home Tours.
 communitiesBoise Meridian Eagle Caldwell Nampa Kuna Star Ada County Canyon County
 websitehttp://www.amherstmadisonpartners.com/
 address410 East State Street
 address_2
 cityEagle
 stateID
 full_stateIdaho
 countryUSA
 marketBoise
 market_2
 postal_code83616
 phoneCell: (208) 573-1619
 phone_2Office: (208) 450-3000
 phone_3
 wide_contact_image(false)
 contact_nameAlei Merrill Gothberg
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-alei-merrill-gothberg-amherst-madison-partners-boise-id/
 contact_big_profile_link_textMEET ALEI
 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_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_filename175.jpg
 logo_filename175.jpg
 contact_image_filename175.jpg
 all_properties_link_image_filename175.jpg
 all_properties_linkhttp://www.amherstmadisonpartners.com/global-leverage-partners-property-showcase/
 video_embed_code
 contact_video_embed_code
 meta_titleBoise Real Estate⎜Amherst Madison Partners⎜Leverage Global Partners
 meta_descriptionAmherst Madison Partners is the exclusive representative for Leverage Global Partners in Boise, Idaho, USA.
 meta_keywordsAmherst Madison Partners, Boise Real Estate, Idaho Real Estate, Leverage Global Partners, Meridian Real Estate, Eagle Real Estate, Caldwell Real Estate, Nampa Real Estate, Kuna Real Estate, Star Real Estate, Ada County Real Estate, Canyon County Real Estate
 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_sent2019-11-12 19:43:49
 converted(true)
 created2014-11-12 15:56:19
 modified2020-11-20 12:05:11
 dre_num012345
 uri/brokerage-detail/175/amherst-madison-partners
 website_shortwww.amherstmadisonpartners.com
 name_with_locationAmherst Madison Partners
 Image(array)
 id6725
 modelLocation
 model_id141
 tagImage
 nameBoise.jpg
 typeimage/jpeg
 size2226832
 uri/assets/6725.jpg
 order0
 created2016-04-07 15:57:20
 modified2016-04-07 16:06:12
 1(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
 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
 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
 2(array)
 Location(array)
 id71
 parent_id8
 brokerage_id229
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameMelbourne, FL, USA
 short_nameMelbourne, FL, USA
 group_index
 latitude28.083628
 longitude-80.608109
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 17:58:51
 modified2016-04-04 17:58:51
 timezoneAmerica/New_York
 population77500
 uri/locations/view/71/melbourne-fl-usa
 tile_nameMelbourne, FL, USA
 Brokerage(array)
 id229
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id0
 WOEID2449097
 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
 nameCurri Properties
 broker_of_record_name
 short_nameCurri Properties
 usernamecurriproperties
 password9e8524ed8ef59b0e785808fcccc169873ee3c9dd
 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
 descriptionCurri Properties is the exclusive representative for Leverage Global Partners in all of Brevard County, including Melbourne, FL, USA. Curri Properties was established in late 2003 after realizing there was a void in Brevard County, Fl for a local, professional boutique real estate brokerage firm, that specialized in Waterfront, Luxury & Commercial property sales. Consisting of just over 20 associates, we pride ourselves on dynamic marketing skills that allows for greater global exposure. This is achieved by marketing our properties through our internet affiliates, and within our company website, which is top ranked amongst Google’s search engine. <a title="www.CurriProperties.com" href="http://www.CurriProperties.com" target="_blank">www.CurriProperties.com</a> Selling luxury & waterfront real estate is not only a career, but a passion we portray in all aspects of what we do. We focus on the basics of what any and all small business relies on, community involvement and building lifelong relationships. In handling the sale or purchase of a home, it not only is a desire, or a dream, but a financial commitment which is generally a family’s largest investment. We are here to insure our client’s best interest each and every time, while giving you five star service along the way. Our service will never be compromised, as we continue to stay focused on our motto. Professionalism, Integrity, Building Relationships.
 communitiesMelbourne Brevard County
 websitehttp://www.curriproperties.net/
 address2893 N. Harbor City Blvd.
 address_2
 cityMelbourne
 stateFL
 full_stateFlorida
 countryUSA
 market
 market_2
 postal_code32935
 phoneCell: (321) 961-4487
 phone_2Office: (888) 638-3832
 phone_3
 wide_contact_image(false)
 contact_nameJohn Curri
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner/CEO
 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_filename229.jpg
 logo_filename229.JPG
 contact_image_filename229.png
 all_properties_link_image_filename229.jpg
 all_properties_linkhttp://www.curriproperties.net/Exclusive-Listings-6-269.html
 video_embed_code
 contact_video_embed_code
 meta_titleMelbourne Real Estate | Curri Properties | Leverage Global Partners
 meta_descriptionCurri Properties is the exclusive representative for Leverage Global Partners in all of Brevard County, including Melbourne, FL, USA.
 meta_keywordscurri properties, melbourne real estate, brevard county real estate, leverage global partners, florida 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)
 created2015-10-07 16:02:52
 modified2016-04-08 16:34:31
 dre_num012345
 uri/brokerage-detail/229/curri-properties
 website_shortwww.curriproperties.net
 name_with_locationCurri Properties
 Image(array)
 id3003
 modelLocation
 model_id71
 tagImage
 nameCurri Properties.jpg
 typeimage/jpeg
 size229870
 uri/assets/3003.jpg
 order0
 created2016-04-04 17:57:58
 modified2016-04-04 17:58:51
 3(array)
 Location(array)
 id113
 parent_id9
 brokerage_id19
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameCity of Chicago, IL, USA
 short_nameCity of Chicago, IL, USA
 group_index
 latitude41.892914
 longitude-87.635910
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionChicago is architecturally rich, artistically inspiring and comprised of 77 vibrant neighborhoods.
 long_descriptionChicago, the "Windy City" or “Second City” as it is commonly referred to, boasts 2.7 million residents and is the third most populated city in the country. The city covers an area of 60,000 hectares and sits along Lake Michigan, the fifth largest body of fresh water in the world. Home to O'Hare International Airport, the second busiest airport in the world, Chicago has become the international hub for finance, commerce, industry, technology, telecommunications, and transportation alike. Chicago boasts 77 vibrant neighborhoods. Famed for its bold architecture and renowned museums, the city attracts an estimated 40 million visitors annually.
 created2016-04-05 16:45:39
 modified2016-04-05 16:45:39
 timezoneAmerica/Mexico_City
 population2700000
 uri/locations/view/113/city-of-chicago-il-usa
 tile_nameCity of Chicago, IL, USA
 Brokerage(array)
 id19
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id1
 WOEID2379574
 timezoneUS/Central
 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
 nameRelated Realty
 broker_of_record_name
 short_nameRelated Realty
 usernamerelatedrealty
 password0f37c5dd7671fb186eb45f8ee1f5f73184bfa997
 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
 descriptionRelated Realty is the exclusive representative for Leverage Global Partners in the City of Chicago, IL, USA. Related Realty is a full-service residential brokerage and an affiliate of Related Companies, the most prominent privately-owned real estate firm in the United States with over 40 years of experience in virtually every aspect of development, acquisitions, management, finance, marketing and sales. At Related Realty, we are committed to the same standards of excellence that our parent company has thrived on for decades past. Leveraging the track records and vast networks of our market-leading brokers, Related Realty represents discerning buyers and sellers with a winning combination of personalized support, unique resources and progressive marketing strategies. Our next generation technology systems allow us to capture and convert your leads and seamlessly manage the resulting transaction. Our Mission: At Related Realty, our mission is to elevate all facets of the residential real estate experience. Our core philosophy focuses on providing our brokers with the unrivaled support and resources they need to deliver exceptional results. We help our brokers take their business to the next level by challenging industry standards to achieve an unprecedented level of success.
 communitiesCity of Chicago
 websitehttp://www.relatedrealtychicago.com
 address350 W. Hubbard Street
 address_2
 cityChicago
 stateIL
 full_stateIllinois
 countryUSA
 marketCity of Chicago
 market_2
 postal_code60654
 phoneCell: (312) 446-9957
 phone_2Office: (312) 274-3939
 phone_3
 wide_contact_image(false)
 contact_nameJeanine McShea
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleVice President - Managing Broker
 contact_dre_num
 contact_quoteI invite you to contact us regarding any of your real estate needs in the City of Chicago.
 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_filename19.jpg
 logo_filename19.jpg
 contact_image_filename19.jpg
 all_properties_link_image_filename19.jpg
 all_properties_linkhttp://www.relatedrealtychicago.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleCity of Chicago Real Estate | Related Realty | Leverage Global Partners
 meta_descriptionRelated Realty is the exclusive representative for Leverage Global Partners in the City of Chicago, IL, USA.
 meta_keywordsrelated realty, chicago real estate, leverage global partners, Jeanine McShea
 login_message_counter2
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-04-01 17:28:36
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/19/related-realty
 website_shortwww.relatedrealtychicago.com
 name_with_locationRelated Realty
 Image(array)
 id3376
 modelLocation
 model_id113
 tagImage
 name39922990_istock_gold_coast_2.jpg
 typeimage/jpeg
 size1929986
 uri/assets/3376.jpg
 order0
 created2016-04-05 16:39:51
 modified2016-04-05 16:45:39
- location_properties(empty)
- main_article(empty)
- brokerage(array)
 Brokerage(array)
 id224
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties12
 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
 WOEID2479664
 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
 namePartners Trust Real Estate Brokerage and Acquisitions
 broker_of_record_name
 short_namePartners Trust Real Estate
 usernamePartnersTrustRedondo
 passwordbd14f6ea444daa213da72e610c4f769298079632
 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 is the exclusive representative for Leverage Global Partners in Redondo Beach, CA, USA. We are also the exclusive representative for Leverage Global Partners in <a href="../../../brokerage-detail/223/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Manhattan Beach and Hermosa Beach, CA</a>. More information coming soon!
 communitiesRedondo Beach
 websitehttp://www.thepartnerstrust.com/
 address1219 Morningside Drive, Suite 202
 address_2
 cityManhattan Beach
 stateCA
 full_stateCalifornia
 countryUSA
 marketRedondo Beach
 market_2
 postal_code90266
 phoneCell: (310) 689-8779
 phone_2Office: (310) 500-3971
 phone_3
 wide_contact_image(false)
 contact_nameJan Rhees
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_title Founding Partner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename224.jpg
 logo_filename224.png
 contact_image_filename224.jpg
 all_properties_link_image_filename
 all_properties_linkhttp://www.thepartnerstrust.com/properties
 video_embed_code
 contact_video_embed_code
 meta_titleRedondo Beach 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 Redondo Beach, CA, USA.
 meta_keywordspartners trust, partners trust real estate, Redondo Beach real estate, Redondo Beach real estate agents, 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-09-18 17:02:43
 modified2016-04-15 10:29:17
 dre_num012345
 uri/brokerage-detail/224/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortwww.thepartnerstrust.com
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions - Redondo Beach, CA, USA
 AccountExecutive(array)
 id236
 typeAccountExecutive
 brokerage_id0
 email[email protected]
 passworde5cc5a96287695cf8b7cace1463b1699895dcf92
 recover_hash
 first_nameLauren
 last_namePena
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2020-12-23 09:21:16
 created2016-04-14 15:43:52
 notified(false)
 full_nameLauren Pena
 uri/agent-detail/236/lauren-pena
 profile_complete(true)
 Logo(array)
 id2887
 modelBrokerage
 model_id224
 tagLogo
 name224.png
 typeimage/png
 size12022
 uri/assets/2887.png
 order0
 created2016-03-30 11:45:09
 modified2016-04-15 10:29:17
 MainImage(array)
 id2886
 modelBrokerage
 model_id224
 tagMainImage
 name224.jpg
 typeimage/jpg
 size6198170
 uri/assets/2886.jpg
 order0
 created2016-03-30 11:45:07
 modified2016-04-15 10:29:17
 ContactImage(array)
 id20852
 modelBrokerage
 model_id224
 tagContactImage
 name2870.jpg
 typeimage/jpeg
 size8192
 uri/assets/20852.jpg
 order0
 created2016-04-15 10:27:34
 modified2016-04-15 10:29:17
 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)
 id163
 parent_id9
 brokerage_id224
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameRedondo Beach, CA, USA
 short_nameRedondo Beach, CA, USA
 group_index
 latitude33.849182
 longitude-118.388405
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 16:50:59
 modified2016-04-18 09:59:47
 timezoneAmerica/Los_Angeles
 population0
 uri/locations/view/163/redondo-beach-ca-usa
 tile_nameRedondo Beach, CA, USA
 User(array)
 0(array)
 id202
 typeBrokerageAdmin
 brokerage_id224
 email[email protected]
 passwordbd14f6ea444daa213da72e610c4f769298079632
 recover_hash
 first_nameBrad
 last_nameSimpson
 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:31:49
 created2016-04-08 16:34:26
 notified(true)
 full_nameBrad Simpson
 uri/agent-detail/202/brad-simpson
 profile_complete(true)
 1(array)
 id237
 typeBrokerageAdmin
 brokerage_id224
 email[email protected]
 password380caa25f95eecd4c9009e6d5ff51561617cd297
 recover_hash
 first_nameJan
 last_nameRhess
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2016-04-15 10:17:21
 created2016-04-15 10:17:21
 notified(false)
 full_nameJan Rhess
 uri/agent-detail/237/jan-rhess
 profile_complete(true)
- location(array)
 Location(array)
 id163
 parent_id9
 brokerage_id224
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameRedondo Beach, CA, USA
 short_nameRedondo Beach, CA, USA
 group_index
 latitude33.849182
 longitude-118.388405
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 16:50:59
 modified2016-04-18 09:59:47
 timezoneAmerica/Los_Angeles
 population0
 uri/locations/view/163/redondo-beach-ca-usa
 tile_nameRedondo Beach, CA, USA
 Image(array)
 id20722
 modelLocation
 model_id163
 tagImage
 nameScreen Shot 2016-04-12 at 4.51.33 PM.png
 typeimage/png
 size947059
 uri/assets/20722.png
 order0
 created2016-04-12 16:51:54
 modified2016-04-18 09:59:47
- 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/163/redondo-beach-ca-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/locations/view/163/redondo-beach-ca-usa
Remote Port	16805
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	162.159.115.42
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
Http Accept Encoding	gzip, br
Http Accept	/
Http Cf Ray	a09da82c1a3cae97-CMH
Http X Forwarded For	216.73.216.172
Proxy-nokeepalive	1
Ssl Tls Sni	staging2.leveragere.com
Https	on
Passenger Download Native Support Binary	0
Passenger Compile Native Support Binary	0
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Unique Id	aiowum7yC1TpDG5SpsnqKgAAAoc
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	aiowum7yC1TpDG5SpsnqKgAAAoc
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781149882.2723
Request Time	1781149882

====

Include
+
Included Files

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

Redondo Beach, CA, 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: 30 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: 30 ms
Total Queries: 19 queries