Locations / Jacksonville, FL, USA

Jacksonville, FL, USA

Northeast Florida offers something for everyone. Enjoy the year round Florida climate in a gorgeous Southern setting, with championship golf courses, exceptional boating, fishing, and watersports, professional and semi-pro sports, a world-class arts and culture scene, a multitude of fine shopping and dining options, and a livability unparalleled anywhere else. People travel from around the country to seek treatment at our highly regarded medical facilities at Mayo Clinic, MD Anderson Cancer Centers, University of Florida's Proton Therapy Center and Nemours Children's Specialty Care. Jacksonville is also home to two of the nation's top public high schools and two well-respected universities.

Location Represented By

License #: 012345

12:41am local time
1 million population

Partner Search

Find partners with a map-based search

Related Locations

Related Partners

Recent Property Listings

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

Array
(
)

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

Cake Params
- plugin(null)
- controllerlocations
- actionview
- named(empty)
- pass(array)
  078
  1jacksonville-fl-usa
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

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

Sql Log

Sql Logs

default

Total Time: 21 ms
Total Queries: 19 queries

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

Query Explain:

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

====

Timer

Memory

Peak Memory Use 12.48 MB

Message	Memory use
Component initialization	2.88 MB
Controller action start	3.80 MB
Controller render start	6.67 MB
View render complete	7.23 MB

Timers

Total Request Time: 233 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	27.75
Event: Controller.initialize	4.09
Event: Controller.startup	1.33
Controller action	52.02
Event: Controller.beforeRender	11.18
» Processing toolbar data	11.08
Rendering View	110.57
» Event: View.beforeRender	0.31
» Rendering APP/View/Locations/view.ctp	2.57
» » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.14
» » 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.24
» » » 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.14
» » » 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	106.97
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)
 id3717
 brokerage_id4
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id1153
 agent_2_id1228
 agent_3_id0
 nameCharming Craftsman in Premier Area
 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(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_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)
 descriptionCharming Castellammare Craftsman. A white picket fence welcomes you to a quality of life that offers cool ocean breezes, incredible schools and a convenient location in the famed Castellammare neighborhood. This turn-key home provides stainless steel appliances, butcher-block countertops, a wide-open family room with french doors guiding you to a beautiful backyard with a stunning trellis, an outdoor dining area with a lounge and firepit. This is a rare opportunity to live in a premier area in a home that is rich in character and amenities.
 address333 Bellino Drive
 address_2
 cityPacific Palisades
 stateCA
 postal_code90272
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2125000
 price_20
 price_usd2125000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms3
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1sq-ft
 icon_2views
 icon_3garage
 icon_4
 icon_5
 icon_6
 websitehttp://333bellinodrive.thepartnerstrust.com/
 meta_titleCharming Craftsman in Premier Area | Pacific Palisades Real Estate | Partners Trust Real Estate Brokerage and Acquisitions
 meta_description333 Bellino Drive is a property offered for sale in Pacific Palisades, CA, USA, presented by Partners Trust Real Estate Brokerage and Acquisitions
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1952
 virtual_tour
 video_tourhttp://www.onvedeo.com/properties/740302/embed
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num16110926
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style20
 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.045139
 longitude-118.561409
 invalid_required_fields
 invalid_optional_fieldsbathrooms_partial, square_meters, acres, hectares, virtual_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2024-10-24 08:42:56
 created2016-04-11 10:42:59
 uri/property-detail/3717/333-bellino-drive-pacific-palisades-ca-90272-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3717/333-bellino-drive-pacific-palisades-ca-90272-usa
 address_concat333 Bellino Drive Pacific Palisades CA 90272 USA
 google_maps_query_string333+Bellino+Drive++Pacific+Palisades+CA+90272+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 2,125,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty2
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2016-04-11
 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)
 id4
 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
 WOEID2488892
 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
 usernamePartnersTrustSM
 password74c7d5ff6cf0a7cb1e382c45ff916c0d15196817
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPartners Trust is the exclusive representative for Leverage Global Partners in Santa Monica, California, USA. At Partners Trust, our real estate associates are the most professional, successful and ethical in the business, representing each of our clients with care, confidentiality and the utmost attention to service. As a company, we offer our associates and clients a level of technology and communication unmatched in today’s real estate market. Situated on the Pacific coast, Santa Monica’s excellent weather, proximity to the beach and its pedestrian and bike-friendly topography makes it one of the most desirable communities to call home in the country. Santa Monica offers an eclectic and rich mixture of commerce, affluent, single-family neighborhoods, renters, young professionals, and students. Our associates proudly represent a wide array of homes, ranging from a beachfront property or classic traditional, to the hillside contemporary estate. Whether our clients are homeowners or builders or international investors, Partners Trust associates understand their discerning needs and provide impeccable service with a high level of local area expertise. Partners Trust has additional office locations in <a href="../../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/5/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Pasadena</a>, <a href="../../../brokerage-detail/142/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Malibu</a> and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai</a>.
 communitiesSanta Monica Marina Del Rey Venice Mar Vista Pacific Palisades
 websitehttp://www.thepartnerstrust.com
 address1333 Montana Avenue
 address_2
 citySanta Monica
 stateCA
 full_stateCalifornia
 countryUSA
 marketSanta Monica
 market_2
 postal_code90403
 phone(310) 500-1307
 phone_2(310) 505-9420
 phone_3
 wide_contact_image(false)
 contact_nameScott Carmody
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-scott-carmody-managing-director-partners-trust-santa-monica/
 contact_big_profile_link_text
 contact_titleManaging Director
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2Nick Segal
 contact_profile_link_2http://www.leveragere.com/brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2President/Co-Founder
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename4.jpg
 logo_filename4.png
 contact_image_filename4.JPG
 all_properties_link_image_filename4.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_titleSanta Monica Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
 meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Santa Monica, CA is a boutique real estate brokerage, focused on providing the highest level of service to home buyers and sellers in the Santa Monica real estate market.
 meta_keywordspartners trust, partners trust real estate, santa monica real estate, santa monica real estate agents, scott carmody, leverage global partners
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-03-18 15:36:48
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/4/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortwww.thepartnerstrust.com
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id20632
 modelProperty
 model_id3717
 tagImage
 name36086.jpg
 typeimage/jpeg
 size398741
 uri/assets/20632.jpg
 order0
 created2016-04-11 18:18:35
 modified2024-10-24 08:42:48
 1(array)
 id20626
 modelProperty
 model_id3717
 tagImage
 name36090.jpg
 typeimage/jpeg
 size363363
 uri/assets/20626.jpg
 order1
 created2016-04-11 18:18:26
 modified2024-10-24 08:42:48
 2(array)
 id20623
 modelProperty
 model_id3717
 tagImage
 name36091.jpg
 typeimage/jpeg
 size192923
 uri/assets/20623.jpg
 order2
 created2016-04-11 18:18:25
 modified2024-10-24 08:42:48
 3(array)
 id20624
 modelProperty
 model_id3717
 tagImage
 name36088.jpg
 typeimage/jpeg
 size224311
 uri/assets/20624.jpg
 order3
 created2016-04-11 18:18:25
 modified2024-10-24 08:42:48
 4(array)
 id20625
 modelProperty
 model_id3717
 tagImage
 name36087.jpg
 typeimage/jpeg
 size241455
 uri/assets/20625.jpg
 order4
 created2016-04-11 18:18:25
 modified2024-10-24 08:42:48
 5(array)
 id20627
 modelProperty
 model_id3717
 tagImage
 name36089.jpg
 typeimage/jpeg
 size387159
 uri/assets/20627.jpg
 order5
 created2016-04-11 18:18:26
 modified2024-10-24 08:42:48
 6(array)
 id20628
 modelProperty
 model_id3717
 tagImage
 name36092.jpg
 typeimage/jpeg
 size186447
 uri/assets/20628.jpg
 order6
 created2016-04-11 18:18:26
 modified2024-10-24 08:42:48
 7(array)
 id20629
 modelProperty
 model_id3717
 tagImage
 name36093.jpg
 typeimage/jpeg
 size192625
 uri/assets/20629.jpg
 order7
 created2016-04-11 18:18:26
 modified2024-10-24 08:42:48
 8(array)
 id20630
 modelProperty
 model_id3717
 tagImage
 name36094.jpg
 typeimage/jpeg
 size190386
 uri/assets/20630.jpg
 order8
 created2016-04-11 18:18:26
 modified2024-10-24 08:42:48
 9(array)
 id20631
 modelProperty
 model_id3717
 tagImage
 name36095.jpg
 typeimage/jpeg
 size452931
 uri/assets/20631.jpg
 order9
 created2016-04-11 18:18:27
 modified2024-10-24 08:42:48
 User(array)
 0(array)
 id1222
 typeAgent
 brokerage_id4
 email[email protected]
 password6bec43a6c86d9cfff48b4d877c01d6b595651ebd
 recover_hash
 first_nameMark
 last_nameKitching
 title
 dre_num
 phone310.902.0221
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:59
 created2017-08-07 15:23:59
 notified(false)
 full_nameMark Kitching
 uri/agent-detail/1222/mark-kitching
 profile_complete(true)
 UsersProperty(array)
 id1133
 user_id1222
 property_id3717
 sort_order0
 1(array)
 id1271
 typeAgent
 brokerage_id4
 email[email protected]
 passwordf7e6e6676d058ebcac2f2621cc1310ed2cb095b1
 recover_hash
 first_nameKristen
 last_namePartipilo
 title
 dre_num
 phone310.500.1304
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:24:02
 created2017-08-07 15:24:02
 notified(false)
 full_nameKristen Partipilo
 uri/agent-detail/1271/kristen-partipilo
 profile_complete(true)
 UsersProperty(array)
 id1134
 user_id1271
 property_id3717
 sort_order1
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id4758
 property_id3717
 property_feature_id14
 1(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id4757
 property_id3717
 property_feature_id4
 Topic(empty)
 1(array)
 Property(array)
 id3749
 brokerage_id70
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameDebordieu Colony.
 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-08 16:16:24
 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 Debordieu Colony...An Exclusive Oceanfront Gated Community Surrounded By Hundreds Of Acres Of Wildlife And Nature Preserves With Private Golf And Tennis Along With An Beachfront Pool And Dining. This Charming Home Is Located On A Corner Lot With A Floating Dock Giving You Direct Boat Access To The Creeks, North Inlet And The Atlantic Ocean Plus Walking Distance To The Beach. A Direct Beach Access Is Located Across The Street From Tabby Lane. With Approx. 4500 Heated Sq Ft, 3 Levels Of Living Space, 8 Bedrooms, 8 Baths, 3 Living Areas, A Huge Kitchen With A Breakfast Bar That Seats 8, Plus A Large Open Dining Area, This Wonderful Family Home Has All The Space You Will Need For Your Entire Family! A Rooftop Deck Gives Way To Incredible Panoramic Views Of The Ocean And Creek. What An Amazing Place To Relax And Watch The Sunrise With A Cup Of Coffee Or Sunset With A Glass Of Wine. The Home Boost Large Double Wrap Around Screened Porches With Access To These Porches From Several Of The Bedrooms And Living Areas. The Ground Floor Has The Foyer Entrance And Parking Underneath The House With Ample Storage Space For Your Beach Toys, Golf Cart, Kayaks, Etc And An Outside Shower. All Levels Are Accessible By An Elevator. The First Floor Has 4 Bedroom/4 Bath And A Living Area. The Main Floor Is An Open Floor Plan With A Large Family Room With Built In Book Cases, A Gas Fireplace, Large Dining Area And Kitchen With A Breakfast Bar That Seats 8. The Kitchen Has A Double Oven, 2 Refrigerators, 2 Pantry Areas, Granite Counter Tops, A Gas Cook Top And Lots And Lots Of Cabinets And Work Space. There Are Also 2 Bedrooms/2 Baths On The Main Level As Well. The Third Floor Has 2 Bedrooms/2 Baths And Living Area. This Is A Great Place For Kids To Have Their Own Space. There Are Stairs To The Roof Top Deck From The Third Level. Beautiful Wood Flooring In All The Living Areas And Kitchen. Debordieu Is Located Just South Of Pawleys Island And About 90 Minutes North Of Charle
 address84 Tabby Lane
 address_2
 cityGeorgetown
 stateSC
 postal_code29440
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1895000
 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)
 bedrooms8
 bedrooms_20
 bathrooms8
 bathrooms_20
 no_beds_baths(false)
 square_feet4501
 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_built2010
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style21
 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.366425
 longitude-79.153259
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(false)
 invalid(false)
 mlsidx_full_address84 Tabby Lane Georgetown SC
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2018-08-08 16:16:24
 created2018-07-10 15:50:16
 uri/property-detail/3749/84-tabby-lane-georgetown-sc-29440-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3749/84-tabby-lane-georgetown-sc-29440-usa
 address_concat84 Tabby Lane Georgetown SC 29440 USA
 google_maps_query_string84+Tabby+Lane++Georgetown+SC+29440+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 1,895,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty8
 bathrooms_pretty8
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms8
 date_listed2018-07-10
 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)
 id22884
 modelProperty
 model_id3749
 tagImage
 namekitchen-3.jpg
 typeimage/jpeg
 size405594
 uri/assets/22884.jpg
 order0
 created2018-07-10 15:51:35
 modified2018-07-10 15:51:38
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 2(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
 3(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)
- sidebar_brokerages(array)
 0(array)
 Brokerage(array)
 id168
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID23417205
 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
 nameThe Boutique Real Estate Group
 broker_of_record_name
 short_nameThe Boutique Real Estate Group
 usernameTheBoutiqueRealEstate
 password01759fcc62fbf8022ef42c08f544e99731e7b5f6
 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
 descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, Corona Del Mar, Balboa Island, Newport Coast, Huntington Beach, Sunset Beach, CA, USA. The Boutique Real Estate Group is a boutique real estate brokerage founded in Orange County, CA, that focuses on brilliant design, beautiful marketing & luxury services and will be opening multiple offices throughout the Southern California Luxury Real Estate Market. The Boutique has created a culture that spurs collaboration, technology and social media with a unique marketing approach. Our story goes a little something like this. Beautiful design evokes emotion. Emotion stirs the soul and creates a connection between client, agent and the home buying & selling process. The Boutique Real Estate Group has invested heavily in bringing all aspects of the real estate experience completely in-house. From custom design, professional staging, amazing photography, cinematography & film production, social media to technology, internet optimization & cloud based transaction management. This not only provides The Boutique with complete control of the design, marketing & technology of luxury real estate but also gives us the look & feel of a true boutique marketing agency. This design & tech-forward approach has earned The Boutique Real Estate Group accolades & awards worldwide. 2015 Inman News Innovator Award for Most Innovative Technology | Nominee 2015 Top 33 People Changing The Real Estate Industry 2014 Best Real Estate Video of The Year 2014 Inman News Innovator Award for Most Innovative Real Estate Agent | Nominee 2014 Next Generation Real Estate Brokerage 2014 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 20 Real Estate Videos in The USA
 communitiesNewport Beach Corona Del Mar Balboa Island Newport Coast Huntington Beach Sunset Beach
 websitehttp://www.theboutiquere.com/
 address3653 E. Coast Hwy
 address_2
 cityCorona Del Mar
 stateCA
 full_stateCalifornia
 countryUSA
 marketNewport Beach
 market_2
 postal_code
 phone(949) 612-2535
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameRaj Qsar
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-raj-qsar-the-boutique-real-estate-group/
 contact_big_profile_link_textMeet Raj
 contact_titlePrincipal/Owner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename168.jpg
 logo_filename168.jpg
 contact_image_filename168.jpg
 all_properties_link_image_filename168.jpg
 all_properties_linkhttp://www.theboutiquere.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/xQ9ZyzIQ-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNewport Beach Real Estate⎜The Boutique Real Estate Group⎜Leverage Global Partners
 meta_descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, CA, USA.
 meta_keywordsThe Boutique Real Estate Group, Raj Qsar, Newport Beach Real Estate, Corona Del Mar Real Estate, Balboa Island Real Estate, Newport Coast Real Estate, Huntington Beach Real Estate, Sunset Beach Real Estate, California Real Estate, 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)
 created2014-10-28 16:37:40
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/168/the-boutique-real-estate-group
 website_shortwww.theboutiquere.com
 name_with_locationThe Boutique Real Estate Group
 Logo(array)
 id2734
 modelBrokerage
 model_id168
 tagLogo
 name168.jpg
 typeimage/jpg
 size596689
 uri/assets/2734.jpg
 order0
 created2016-03-30 11:43:18
 modified2016-03-30 11:43:18
 1(array)
 Brokerage(array)
 id232
 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(true)
 country_id0
 WOEID2449435
 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
 nameKerwin & Associates
 broker_of_record_name
 short_nameKerwin & Associates
 usernamekerwinassociates
 passwordfdfee2c837ca0afd3f1b1218abc68713af252711
 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
 descriptionKerwin & Associates is the exclusive representative for Leverage Global Partners in Atherton, Palo Alto, Menlo Park, and Woodside, CA, USA. Kerwin & Associates, Silicon Valley The most celebrated properties in Silicon Valley’s prestige neighborhoods—Atherton, Woodside, Menlo Park, Palo Alto—rarely get listed. In fact, more than 35% of our transactions are private, off-market sales. This area is unique, and its elite roster of buyers and sellers value discretion, integrity and privacy. So that is what we provide. Kerwin & Associates is the preferred agent among Silicon Valley’s demanding executive residents for many reasons: highly customized and personal service, a vast support network, meticulous attention to detail, fierce negotiation and, of course, an encyclopedic knowledge of every neighborhood, street and address we serve. If you want to know about the finest properties in Silicon Valley’s best neighborhoods, don’t bother with listings. Just call us. Terri Kerwin Terri was recently named one of Wall Street Journal’s Top Realtors Nationwide. Although she comes from a distinguished real estate lineage, she did not begin her career as an agent. Instead, she started with the renowned Xerox sales training program. Since then, she has emerged as a leader in the local market and the preferred broker for Silicon Valley’s most-demanding clientele. She has also built 10 custom homes from the ground up, cementing her expertise in determining high-end property value and investment potential. When she isn’t helping clients find their dream homes and estates, she loves having family and friends over to spend time in the backyard overlooking the natural beauty that Portola Valley offers.
 communitiesAtherton Palo Alto Menlo Park Woodside
 websitehttp://www.kerwinassociates.com/
 address201 El Camino Real
 address_2
 cityMenlo Park
 stateCA
 full_stateCalifornia
 countryUSA
 marketAtherton
 market_2
 postal_code94025
 phone(650) 473-1500
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTerri Kerwin
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename232.jpg
 logo_filename232.jpg
 contact_image_filename232.jpg
 all_properties_link_image_filename232.jpg
 all_properties_linkhttp://www.kerwinassociates.com/Our-Featured-Listings
 video_embed_code
 contact_video_embed_code
 meta_titleAtherton Real Estate | Kerwin & Associates | Leverage Global Partners
 meta_descriptionKerwin & Associates is the exclusive representative for Leverage Global Partners in Atherton, Palo Alto, Menlo Park, Woodside, Redwood City, and San Carlos, CA, USA.
 meta_keywordsKerwin & Associates, Leverage Global Partners, Atherton real estate, Palo Alto real estate, Menlo Park real estate, Woodside real estate, Redwood City real estate, San Carlos real estate, California real estate, Silicon valley
 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-10-26 16:05:26
 modified2016-04-18 11:56:15
 dre_num012345
 uri/brokerage-detail/232/kerwin-associates
 website_shortwww.kerwinassociates.com
 name_with_locationKerwin & Associates
 Logo(array)
 id2908
 modelBrokerage
 model_id232
 tagLogo
 name232.jpg
 typeimage/jpg
 size35751
 uri/assets/2908.jpg
 order0
 created2016-03-30 11:45:30
 modified2016-04-18 11:56:15
 2(array)
 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
 Logo(array)
 id2704
 modelBrokerage
 model_id157
 tagLogo
 name157.JPG
 typeimage/JPG
 size39066
 uri/assets/2704.JPG
 order0
 created2016-03-30 11:42:33
 modified2021-07-18 10:38:47
 3(array)
 Brokerage(array)
 id6
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2510611
 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
 nameGateway Land and Development Real Estate
 broker_of_record_name
 short_nameGateway Land and Development
 usernameGatewayLand
 passwordb17782d097733f59e365f87cad485736c79b54f3
 password_reset_hash
 monthly_invoice_amount500.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename6.pdf
 active(true)
 lead_in
 short_description
 descriptionGateway Land & Development is the exclusive representative for Leverage Global Partners in Eagle County, Colorado, USA. Gateway Land and Development Real Estate was established in 1993 in Edwards, Colorado and is owned and operated by Suzi Apple, a 40-year Vail Valley resident. Much like the area it serves, Gateway is without peer. From exceptional ski homes to spectacular ranch properties, unique commercial endeavors to new developments, no real estate opportunity is outside of Gateway’s expertise. Gateway was founded upon the conviction that relationships are to be coveted and honored. These same values continue to be the cornerstone of our business and are evidenced by the fact that the majority of our business continues to originate from referrals and repeat customers. Conveniently located in the heart of Vail Village and in downtown Edwards, Let Gateway Lead You Home.
 communitiesVail Valley USA United States of America Eagle United States USA United States of America Beaver Creek USA United States of America Vail USA United States of America Cordillera USA United States of America Edwards USA United States of America Colorado USA United States of America Eagle County USA United States of America Colorado
 websitehttp://www.gatewaytovail.com/
 address183 Gore Creek Trail
 address_2
 cityVail
 stateCO
 full_stateColorado
 countryUSA
 marketVail
 market_2
 postal_code81658
 phone970.376.5417
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameSuzi Apple
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/suzi-apple-gateway-lands-president-loves-living-and-working-in-vail/
 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_websitehttp://www.suziapple.com
 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_filename6.jpg
 logo_filename6.jpg
 contact_image_filename6.jpg
 all_properties_link_image_filename6.jpg
 all_properties_linkhttp://gatewayland.com/search-properties/exclusive-to-gateway
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/EAp4pAeV-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleVail Real Estate | Gateway Land and Development Real Estate | Leverage Global Partners
 meta_descriptionGateway Land and Development Real Estate is the exclusive representative for Leverage Global Partners in Vail, Colorado, USA.
 meta_keywordsgateway land and development real estate, gateway land, vail real estate, leverage global partners, suzi apple
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-03-18 18:33:20
 modified2016-04-18 10:40:09
 dre_num012345
 uri/brokerage-detail/6/gateway-land-and-development-real-estate
 website_shortwww.gatewaytovail.com
 name_with_locationGateway Land and Development Real Estate
 Logo(array)
 id2257
 modelBrokerage
 model_id6
 tagLogo
 name6.jpg
 typeimage/jpg
 size96973
 uri/assets/2257.jpg
 order0
 created2016-03-30 11:36:06
 modified2016-04-18 10:40:09
- sidebar_locations(array)
 0(array)
 Location(array)
 id178
 parent_id8
 brokerage_id188
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameNaples, FL, USA
 short_nameNaples, FL, USA
 group_index
 latitude26.142036
 longitude-81.794807
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 19:10:29
 modified2016-04-12 19:11:53
 timezoneAmerica/New_York
 population0
 uri/locations/view/178/naples-fl-usa
 tile_nameNaples, FL, USA
 Brokerage(array)
 id188
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2457027
 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
 nameMiloff Aubuchon Realty Group
 broker_of_record_name
 short_nameMiloff Aubuchon Realty Group
 usernameMiloffAubuchonNaples
 password1710f8a5e4581f9f3b2398bd524ffac0dceb4c84
 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
 descriptionMiloff Aubuchon Realty Group, Inc. is the exclusive representative for Leverage Global Partners in Collier County and Lee County, including: Naples, Cape Coral, Bonita Springs, Fort Myers, and Sanibel, Florida, USA. Miloff Aubuchon Realty Group Gary Aubuchon and Jeff Miloff formed a partnership in 1998 that would later flourish and succeed beyond their expectations. Miloff Aubuchon Realty Group, the real estate division of Team Aubuchon, began in the garage of a model home with four agents and one staff member. Today, the company has grown to over 95 agents, with 4 real estate offices now open in Southwest Florida. Their success is a result of hard work, dedication to excellence in all aspects of business, and a focus on providing above and beyond customer service. Through the years, this company has helped thousands of people invest in real estate, sell their property, and find the home of their dreams. Choosing Miloff Aubuchon Realty Group means you get insight and market knowledge from the best agents in the area who are dedicated to professionalism and working in your best interest. Our team is passionate about improving the community and giving back. We support local organizations such as Ronald McDonald House Charities SWFL, Make-A-Wish Southern Florida, Builders Care, Relay for Life, and Kids With Cancer. We pride ourselves by getting in the game both financially and physically. Our support includes home renovations, volunteering on numerous committees and events, hosting events at our offices, and so much more. Our mission is to help make your vision a reality, and become one of our Raving Fans.
 communitiesNaples Cape Coral Bonita Springs Fort Myers Sanibel
 websitehttp://www.miloffaubuchonrealty.com/
 address28901 Trails Edge Boulevard
 address_2Suite 201
 cityBonita Springs
 stateFL
 full_stateFlorida
 countryUSA
 marketNaples
 market_2
 postal_code34134
 phone239-719-0400
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameChris Horky
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleDirector of Sales
 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_filename188.jpg
 logo_filename188.gif
 contact_image_filename188.jpg
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_titleNaplesl Real Estate | Miloff Aubuchon Realty Group | Leverage Global Partners
 meta_descriptionMiloff Aubuchon Realty Group is the exclusive representative for Leverage Global Partners in Naples, FL, USA.
 meta_keywordsMiloff Aubuchon Realty Group, Cape Coral real estate, Jeff Miloff, Bonita Springs real estate, Fort Myers real estate, and Sanibel real estate, naples real estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-02-05 14:32:19
 modified2016-04-15 11:47:38
 dre_num012345
 uri/brokerage-detail/188/miloff-aubuchon-realty-group
 website_shortwww.miloffaubuchonrealty.com
 name_with_locationMiloff Aubuchon Realty Group
 Image(array)
 id20752
 modelLocation
 model_id178
 tagImage
 nameScreen Shot 2016-04-12 at 7.10.52 PM.png
 typeimage/png
 size1130912
 uri/assets/20752.png
 order0
 created2016-04-12 19:11:16
 modified2016-04-12 19:11:53
 1(array)
 Location(array)
 id130
 parent_id8
 brokerage_id154
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameTampa, FL, USA
 short_nameTampa, FL, USA
 group_index
 latitude27.950575
 longitude-82.457176
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-07 14:17:42
 modified2016-04-07 14:17:42
 timezoneAmerica/New_York
 population353000
 uri/locations/view/130/tampa-fl-usa
 tile_nameTampa, FL, USA
 Brokerage(array)
 id154
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2503863
 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
 nameCornerstone Properties International
 broker_of_record_name
 short_nameCornerstone Properties International
 usernameCornerstoneProperty
 passwordf300ceb25cdb1505430722d88bff1cb47b6d4200
 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
 descriptionCornerstone Properties International is the exclusive representative for Leverage Global Partners in Tampa, St. Petersburg, Clearwater Beach, Odessa, Wesley Chapel, Dunedin, Palm Harbor, Treasure Island, Tierra Verde, Belleair, Thonototosassa, Davis Islands, Harbour Island, Florida, USA. In 2001, Steve Eckhardt took a small group of dedicated, top-performing Realtors in the Tampa area real estate market and broke from the tradition of the corporate and often impersonal real estate mega-companies to form an upscale, boutique real estate agency with an unprecedented knowledge of the local market and community. Cornerstone Properties grew very quickly and opened additional offices in Fort Myers and Key Largo, Florida to serve luxury clientele looking for vacation homes and waterfront properties from the Tampa Bay area to Sarasota, Fort Myers, Naples, and into the Florida Keys. Cornerstone Properties has consistently earned its position as one of the top boutique residential real estate firms on the Gulf Coast of Florida. Furthermore, Cornerstone Properties was named by Florida Realtor Magazine as one of the top company real estate websites in the state of Florida and has been recognized by Who’s Who In Luxury Real Estate since 2002. In addition to providing the strongest team of agents in area, Steve has developed a completely unique branding and a leading edge marketing standard that truly positions a client’s property apart from the rest. With over 16 years in the real estate industry, 12 years in the mortgage industry, and entrepreneurial experience spanning over 25 years, Steve provides the knowledge, experience, and dedication you would expect from a true luxury real estate professional. And, he offers his clients service that is second to none.
 communitiesTampa, St. Petersburg Clearwater Beach Odessa Wesley Chapel Dunedin Palm Harbor Treasure Island Tierra Verde Belleair Thonototosassa Davis Islands Harbour Island
 websitehttp://thefloridaauthority.com/
 address8875 Hidden River Parkway
 address_2Suite 300
 cityTampa
 stateFL
 full_stateFlorida
 countryUSA
 market
 market_2
 postal_code33637
 phone(813) 765-1182
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameSteve Eckhardt
 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_filename154.jpg
 logo_filename154.jpg
 contact_image_filename154.jpg
 all_properties_link_image_filename
 all_properties_link
 video_embed_code<iframe src="https://player.vimeo.com/video/121701442?color=ffffff&title=0&byline=0&portrait=0" width="420" height="236" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>
 contact_video_embed_code
 meta_titleTampa Real Estate | Cornerstone Properties International | Leverage Global Partners
 meta_descriptionCornerstone Properties International is the exclusive member for Leverage Global Partners in Tampa, FL, USA.
 meta_keywordsCornerstone Properties International, Tampa Real Estate, Steve Eckhardt, Hillsborough Real Estate, Pinellas Real Estate, Pasco Real Estate, Florida Real Estate, Levergage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-08-25 16:13:56
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/154/cornerstone-properties-international
 website_shortthefloridaauthority.com
 name_with_locationCornerstone Properties International
 Image(array)
 id3662
 modelLocation
 model_id130
 tagImage
 nameTampa.jpg
 typeimage/jpeg
 size144110
 uri/assets/3662.jpg
 order0
 created2016-04-07 14:17:37
 modified2016-04-07 14:17:42
 2(array)
 Location(array)
 id79
 parent_id8
 brokerage_id112
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameUPPER FLORIDA KEYS, FL, USA
 short_nameUPPER FLORIDA KEYS, FL, USA
 group_index
 latitude24.909195
 longitude-80.688171
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionIslamorada, Florida Keys, an island paradise where the Atlantic Ocean and The Gulf of Mexico meet.
 long_descriptionEveryone is looking for a vacation getaway in the fabulous Florida Keys. Islamorada offers the perfect setting for relaxation, yet also provides many arts and cultural experiences and water based activities. With an average air temperature of 80 degrees and water temperature of 78 degrees, Islamorada truly is an island paradise. There are many great dining experiences, boutiques, art galleries and small town "mom and pops" within walking or biking distance from our beautiful waterfront homes and condos. Our island is rich in history and has several interactive museums showcasing our past. Known as the Sport fishing capitol of the world, and home to a living coral reef, Islamorada is the best place to fish, dive, snorkle, paddleboard, or take in an Eco tour. Monthly full moon parties on the beach and nightly sunset celebrations are always a hit with our "locals" and many welcome visitors as well. From a cozy island cottage, to a luxurious waterfront estate.... Let us show you!
 created2016-04-05 09:41:54
 modified2016-04-05 09:41:54
 timezoneAmerica/New_York
 population11000
 uri/locations/view/79/upper-florida-keys-fl-usa
 tile_nameUPPER FLORIDA KEYS, FL, USA
 Brokerage(array)
 id112
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID23511750
 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
 nameMoorings Realty Inc.
 broker_of_record_name
 short_nameMoorings Realty Inc.
 usernameMooringsRealty
 passwordb4d70d90004784f7fa7f6794baf6b5bfd090651c
 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
 descriptionMoorings Realty Inc. is the exclusive representative for Leverage Global Partners in the Upper Florida Keys, Florida, USA. More information coming soon!
 communities
 websitehttp://www.mooringsrealty.com/
 address81610 Overseas Highway
 address_2
 cityIslamorada
 stateFL
 full_stateFlorida
 countryUSA
 marketUpper Florida Keys
 market_2
 postal_code33036
 phone(305) 393-0513
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameRhonda Brewer
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename112.jpg
 logo_filename112.jpg
 contact_image_filename112.jpg
 all_properties_link_image_filename112.jpg
 all_properties_linkhttp://www.mooringsrealty.com/featured-listings
 video_embed_code
 contact_video_embed_code
 meta_titleUpper Florida Keys Real Estate | Moorings Realty Inc. | Leverage Global Partners
 meta_descriptionMoorings Realty Inc. is the exclusive representative for Leverage Global Partners in the Upper Florida Keys, Florida, USA.
 meta_keywordsMoorings Realty Inc. Upper Florida Keys Real Estate, Rhonda Brewer, Upper Florida Keys Florida, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-04-23 12:41:44
 modified2016-04-08 16:34:09
 dre_num012345
 uri/brokerage-detail/112/moorings-realty-inc
 website_shortwww.mooringsrealty.com
 name_with_locationMoorings Realty Inc.
 Image(array)
 id3011
 modelLocation
 model_id79
 tagImage
 name112.jpg
 typeimage/jpeg
 size86344
 uri/assets/3011.jpg
 order0
 created2016-04-05 09:39:24
 modified2016-04-05 09:41:54
 3(array)
 Location(array)
 id84
 parent_id7
 brokerage_id240
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameCity of Pittsburgh, PA, USA
 short_nameCity of Pittsburgh, PA, USA
 group_index
 latitude40.613708
 longitude-80.056023
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionWhere three rivers meet - Pittsburgh’s appeal begins with its scenery.
 long_descriptionPittsburgh, Pennsylvania is a place where two rivers merge to form the mighty Ohio River. Over the years, the waterways were used strategically for exploration and trade. Today, the rivers provide a beautiful, scenic background for a city that is receiving many accolades for its quality of life, leisure activities, restaurants and affordable housing. While the Pittsburgh market may not boast the kind of blockbuster price tags found in other comparable cities, Pittsburgh is full of charming, older houses nestled in the hills and valleys around our region as well as sleek lofts and penthouses with incredible views.
 created2016-04-05 10:57:49
 modified2016-04-05 10:57:49
 timezoneAmerica/New_York
 population305000
 uri/locations/view/84/city-of-pittsburgh-pa-usa
 tile_nameCity of Pittsburgh, PA, USA
 Brokerage(array)
 id240
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2473224
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts[email protected]
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameAchieve Realty
 broker_of_record_name
 short_nameAchieve Realty
 usernameAchieveRealty
 password8b469e715f5dfcdc32692d657c20869180bcca9d
 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
 descriptionAchieve Realty is the exclusive representative for Leverage Global Partners in the City of Pittsburgh, North Allegheny County, West Allegheny County, Butler County, including communities such as Bradford Woods, Collier Township, Fox Chapel, Franklin Park, Hampton Township, Marshall Township, McCandless Township, Ohio Township, Pine Township, Richland Township, Sewickley, Adams Township, Cranberry Township, and Penn Township, Pennsylvania, USA. Achieve Realty, Inc. is a real estate brokerage headquartered in the Pittsburgh, Pennsylvania suburb of Wexford. The firm is owed by husband and wife lawyers Lawton and Kristen Stokes. The Stokes’ have been engaged in the title insurance business since 1993 and in the real estate brokerage business since 2000. Lawton Stokes is also an Associate Broker. Together, the Stokes’ provide a wealth of support and guidance to the team of sales agents at Achieve Realty. Achieve Realty is comprised of many of the area’s top real estate sales agents. From new construction to existing homes, from condominiums to townhouses, we have the residential market covered. Thanks to our tremendous affiliations, Achieve Realty is a one-stop shop for all of the ancillary services including mortgage, title and homeowners insurance. Achieve Realty is a proud member of the Leverage Global Partners network.
 communitiesCity of Pittsburgh North Allegheny County West Allegheny County Butler County Bradford Woods Collier Township Fox Chapel Franklin Park Hampton Township Marshall Township McCandless Township Ohio Township Pine Township Richland Township Sewickley Adams Township Cranberry Township Penn Township
 websitehttp://www.achieverealty.net/
 address10475 Perry Highway
 address_2
 cityWexford
 statePA
 full_state
 countryUSA
 marketCity of Pittsburgh
 market_2
 postal_code
 phone(724) 933-1980
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameLawton Stokes
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename240.jpg
 logo_filename240.png
 contact_image_filename240.jpg
 all_properties_link_image_filename240.jpg
 all_properties_linkhttp://www.achieverealty.net/listings/query.php?aid=&oid=&aname=&aimg=&chome=&odoor=&agent_hasfeat=&state=42&newsearch=1&newsearchresults=1&saved_search=0&keySession=&sort_by=1&property_category=1&pricemin=&pricemax=&bedrooms=&bedmore=1&bath_full=&bath_th
 video_embed_code
 contact_video_embed_code
 meta_titleCity of Pittsburgh Real Estate | Achieve Realty | Leverage Global Partners
 meta_descriptionAchieve Realty is the exclusive representative for Leverage Global Partners in the City of Pittsburgh, PA, USA.
 meta_keywordsAchieve Realty, Pittsburgh real estate, leverage global partners, Lawton Stokes
 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)
 created2016-02-03 17:08:44
 modified2022-01-13 09:50:57
 dre_num012345
 uri/brokerage-detail/240/achieve-realty
 website_shortwww.achieverealty.net
 name_with_locationAchieve Realty
 Image(array)
 id3018
 modelLocation
 model_id84
 tagImage
 name240.jpg
 typeimage/jpeg
 size177532
 uri/assets/3018.jpg
 order0
 created2016-04-05 10:52:25
 modified2016-04-05 10:57:49
- location_properties(empty)
- main_article(empty)
- brokerage(array)
 Brokerage(array)
 id227
 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
 WOEID2428344
 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
 nameFred Miller Group, Inc.
 broker_of_record_name
 short_nameFred Miller Group, Inc.
 usernamefredmillergroup
 password95774aeb779564b5ae074d99e6d6168b99e07156
 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
 descriptionFred Miller Group, Inc. is the exclusive representative for Leverage Global Partners in Jacksonville, FL, including all of Duval County and Clay County. Fred and Carol Miller established Fred Miller Group in 1995 in the same historic Ortega Village building in which it is located today. Fred’s eldest son, Ted, joined the company in 1997 and became President in 2005. In 2012, Fred’s middle son, Nathan, brought a focus on home building to Fred Miller Group with his experience working in residential new construction. The Miller family has been rooted in Jacksonville business circles for more than a century, succeeding in industries including printing, marketing and advertising, and most recently, residential real estate sales. Over the past two decades, the company has grown to incorporate a dynamic association of dedicated real estate professionals whose individual sales and performance surpass the production of agents at larger real estate franchises. Fred Miller Group and its agents adhere to the highest standards of professionalism and ethics, and are recognized around town as conscientious, reliable real estate agents. When you place your confidence in a Fred Miller Group REALTOR®, you can rest assured that you have chosen a professional who will help guide you through the process of buying or selling a home with respect, discretion, and the skills acquired through the individual and collective experiences of all our agents. Fred Miller Group is blessed with a company culture of mutual respect, camaraderie, and achievement that is unparalleled in our industry. We look forward to sharing that culture with you.
 communitiesJacksonville Clay County Duval County
 websitehttp://fredmillergroup.com/
 address2905 Corinthian Avenue
 address_2
 cityJacksonville
 stateFL
 full_stateFlorida
 countryUSA
 marketJacksonville
 market_2
 postal_code32210
 phoneOffice: (904) 388-0000
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTed Miller & Fred Miller
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleManaging Broker/Owner/President & Broker/Owner/CEO
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Jacksonville real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename227.jpg
 logo_filename227.jpg
 contact_image_filename227.jpg
 all_properties_link_image_filename227.jpg
 all_properties_linkhttp://fredmillergroup.com/our-listings
 video_embed_code
 contact_video_embed_code
 meta_titleJacksonville Real Estate | Fred Miller Group, Inc. | Leverage Global Partners
 meta_descriptionFred Miller Group, Inc. is the exclusive representative for Leverage Global Partners in Jacksonville, FL, including all of Duval County and Clay County.
 meta_keywordsFred Miller Group, Inc., jacksonville real estate, florida real estate, duval county real estate, clay county real estate, leverage global partners
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-09-30 15:37:56
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/227/fred-miller-group-inc
 website_shortfredmillergroup.com
 name_with_locationFred Miller Group, Inc. - Jacksonville, FL, USA
 AccountExecutive(array)
 id236
 typeAccountExecutive
 brokerage_id0
 email[email protected]
 passworde5cc5a96287695cf8b7cace1463b1699895dcf92
 recover_hash
 first_nameLauren
 last_namePena
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2020-12-23 09:21:16
 created2016-04-14 15:43:52
 notified(false)
 full_nameLauren Pena
 uri/agent-detail/236/lauren-pena
 profile_complete(true)
 Logo(array)
 id2866
 modelBrokerage
 model_id227
 tagLogo
 name227.jpg
 typeimage/jpg
 size93375
 uri/assets/2866.jpg
 order0
 created2016-03-30 11:44:52
 modified2016-03-30 11:44:52
 MainImage(array)
 id2865
 modelBrokerage
 model_id227
 tagMainImage
 name227.jpg
 typeimage/jpg
 size931509
 uri/assets/2865.jpg
 order0
 created2016-03-30 11:44:52
 modified2016-03-30 11:44:52
 ContactImage(array)
 id2867
 modelBrokerage
 model_id227
 tagContactImage
 name227.jpg
 typeimage/jpg
 size91217
 uri/assets/2867.jpg
 order0
 created2016-03-30 11:44:52
 modified2016-03-30 11:44:52
 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)
 id472
 modelBrokerage
 model_id227
 archived(false)
 medium_featured(false)
 large_featured(false)
 titleMeet FRED MILLER: Fred Miller Group, Inc. | Jacksonville, Florida
 authorLeverageRE
 date2016-03-05
 lead_inGet to know Fred Miller, Broker/Owner/CEO of Fred Miller Group, Inc., the exclusive Leverage Partner in the Jacksonville, Florida area.
 body<h3>What was your vision in founding Fred Miller Group, Inc.?</h3> After 14 years in a family printing and graphics business that was very labor and capital intensive, I wanted to form a people business with unlimited potential and low labor and capital intensity and take advantage of our family name in business that began here in 1911. In 1978, a friend and I formed a full service advertising company, which flourished for 12 years. In 1990, I got my residential real estate license and one year later got my broker's license. My wife Carol and I started our residential real estate agency in 1995, grew to 70 associates in two offices and 'ungrew' back to 25 associates in one office, thanks to the deep housing recession. We now have plans to acquire appropriate small but highly professional agencies and create two new offices in strategic areas of the city. <img class="aligncenter wp-image-12349 pure-img" src="/assets/3271.jpg" /> <h3>What do you love most about working and living in Jacksonville?</h3> We love the modest four seasons, the Atlantic ocean and the huge St. Johns River, as well as the recovering residential market. Northeast Florida is an outstanding place to live, work and play year round. We have a wonderful symphony and arts community, in addition to a world-class medical system which includes Mayo Clinic and M. D. Anderson Cancer Center affiliates. <h3>How do you like to spend your free time – when you have it?</h3> In addition to working and playing with three sons and daughters-in-law and seven brilliant grandchildren, I enjoy fly-fishing here and in the North Carolina mountains and in Oregon, as well as waterfowl hunting in Louisiana, Mississippi and Arkansas. I am active in numerous charitable and civic associations, and Carol and I spend four to six weeks each year in Western North Carolina. <h3>What is your daily "must-do"?</h3> Regardless of when I wake up, within 20 minutes I am in a favorite breakfast restaurant every day, sometimes at 5am but usually 7-8am. I use this quiet time to read and respond to email as I plan my day. <h3>Name one thing that we might not know about you.</h3> I grew up swimming competitively, which lasted through college, after which I became a runner in my twenties. I ran the NYC Marathon in October 1983. Otherwise, I enjoy reading non-fiction, especially biographies. <img class="aligncenter wp-image-12351 pure-img" src="/assets/3272.jpg" /> Leverage Global Partners is proud to have Fred Miller and the team at Fred Miller Group, Inc. as our partners in the network. <img class="aligncenter wp-image-12386 pure-img" src="/assets/3273.jpg" />
 vimeo_id
 created2016-04-05 14:32:10
 modified2016-04-08 09:56:58
 uri/articles/view/472/meet-fred-miller-fred-miller-group-inc-jacksonville-florida
 FeaturedImage(empty)
 Location(array)
 0(array)
 id78
 parent_id8
 brokerage_id227
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameJacksonville, FL, USA
 short_nameJacksonville, FL, USA
 group_index
 latitude30.277594
 longitude-81.723999
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionNortheast Florida is a great place to work, live, and play.
 long_descriptionNortheast Florida offers something for everyone. Enjoy the year round Florida climate in a gorgeous Southern setting, with championship golf courses, exceptional boating, fishing, and watersports, professional and semi-pro sports, a world-class arts and culture scene, a multitude of fine shopping and dining options, and a livability unparalleled anywhere else. People travel from around the country to seek treatment at our highly regarded medical facilities at Mayo Clinic, MD Anderson Cancer Centers, University of Florida's Proton Therapy Center and Nemours Children's Specialty Care. Jacksonville is also home to two of the nation's top public high schools and two well-respected universities.
 created2016-04-05 09:29:51
 modified2016-04-05 09:29:51
 timezoneAmerica/New_York
 population1000000
 uri/locations/view/78/jacksonville-fl-usa
 tile_nameJacksonville, FL, USA
 User(array)
 0(array)
 id196
 typeBrokerageAdmin
 brokerage_id227
 email[email protected]
 password95774aeb779564b5ae074d99e6d6168b99e07156
 recover_hash
 first_name
 last_name
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2016-04-12 08:31:42
 created2016-04-08 16:34:26
 notified(true)
 full_name
 uri/agent-detail/196/
 profile_complete(false)
 1(array)
 id1125
 typeAgent
 brokerage_id227
 email[email protected]
 password4f5d54af21c8c06d4496be703a634563d2da01a9
 recover_hash
 first_nameTed
 last_nameMiller
 title
 dre_num
 phone904-463-1731
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:55
 created2017-08-07 15:23:55
 notified(false)
 full_nameTed Miller
 uri/agent-detail/1125/ted-miller
 profile_complete(true)
 2(array)
 id1126
 typeAgent
 brokerage_id227
 email[email protected]
 password4260562587581d4b9c15d63a0b65faf2ce4e8ce7
 recover_hash
 first_nameNathan
 last_nameMiller
 title
 dre_num
 phone904-465-3001
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:55
 created2017-08-07 15:23:55
 notified(false)
 full_nameNathan Miller
 uri/agent-detail/1126/nathan-miller
 profile_complete(true)
 3(array)
 id1133
 typeAgent
 brokerage_id227
 email[email protected]
 password1d0114af9d2fd1db94fa446f9621396d19c49761
 recover_hash
 first_nameNancy
 last_nameMcFauls
 title
 dre_num
 phone904-449-8698
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:55
 created2017-08-07 15:23:55
 notified(false)
 full_nameNancy McFauls
 uri/agent-detail/1133/nancy-mcfauls
 profile_complete(true)
 4(array)
 id1134
 typeAgent
 brokerage_id227
 email[email protected]
 password2408e1ced858e52b4d01ac181b5ac90b7e34f1a3
 recover_hash
 first_nameAnne Clay
 last_nameMcNulty
 title
 dre_num
 phone904-334-3433
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:55
 created2017-08-07 15:23:55
 notified(false)
 full_nameAnne Clay McNulty
 uri/agent-detail/1134/anne-clay-mcnulty
 profile_complete(true)
 5(array)
 id1135
 typeAgent
 brokerage_id227
 email[email protected]
 password22d5bbeef559dcbad950b75b020b5f545b8c8776
 recover_hash
 first_nameLindsey
 last_nameSmith
 title
 dre_num
 phone904-318-6911
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:55
 created2017-08-07 15:23:55
 notified(false)
 full_nameLindsey Smith
 uri/agent-detail/1135/lindsey-smith
 profile_complete(true)
 6(array)
 id1144
 typeAgent
 brokerage_id227
 email[email protected]
 passworda8b6f59343fcab73f00421d017788b20e901289e
 recover_hash
 first_nameEllen
 last_nameGould
 title
 dre_num
 phone904-716-9106
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:55
 created2017-08-07 15:23:55
 notified(false)
 full_nameEllen Gould
 uri/agent-detail/1144/ellen-gould
 profile_complete(true)
 7(array)
 id1188
 typeAgent
 brokerage_id227
 email[email protected]
 password132a7cd8e2cb739ed44a595b5034b169abeba28c
 recover_hash
 first_nameBeverly
 last_nameSleeth
 title
 dre_num
 phone904-705-7414
 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_nameBeverly Sleeth
 uri/agent-detail/1188/beverly-sleeth
 profile_complete(true)
- location(array)
 Location(array)
 id78
 parent_id8
 brokerage_id227
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameJacksonville, FL, USA
 short_nameJacksonville, FL, USA
 group_index
 latitude30.277594
 longitude-81.723999
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionNortheast Florida is a great place to work, live, and play.
 long_descriptionNortheast Florida offers something for everyone. Enjoy the year round Florida climate in a gorgeous Southern setting, with championship golf courses, exceptional boating, fishing, and watersports, professional and semi-pro sports, a world-class arts and culture scene, a multitude of fine shopping and dining options, and a livability unparalleled anywhere else. People travel from around the country to seek treatment at our highly regarded medical facilities at Mayo Clinic, MD Anderson Cancer Centers, University of Florida's Proton Therapy Center and Nemours Children's Specialty Care. Jacksonville is also home to two of the nation's top public high schools and two well-respected universities.
 created2016-04-05 09:29:51
 modified2016-04-05 09:29:51
 timezoneAmerica/New_York
 population1000000
 uri/locations/view/78/jacksonville-fl-usa
 tile_nameJacksonville, FL, USA
 Image(array)
 id3010
 modelLocation
 model_id78
 tagImage
 name39922990_skyline_with_bird.jpg
 typeimage/jpeg
 size597786
 uri/assets/3010.jpg
 order0
 created2016-04-05 09:27:59
 modified2016-04-05 09:29:51
- 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/78/jacksonville-fl-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/locations/view/78/jacksonville-fl-usa
Remote Port	21241
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	162.159.115.41
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http 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	a09df1b52a6d724e-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	aio8flLEEfcqtnCHo5Ui4wAAAAs
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	aio8flLEEfcqtnCHo5Ui4wAAAAs
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781152894.2871
Request Time	1781152894

====

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

Jacksonville, FL, USA

Location Represented By

Related Articles

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 21 ms Total Queries: 19 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 21 ms
Total Queries: 19 queries