Orlando, FL, USA

Location Represented By

License #: 012345

Array
(
)

• 
• History
  +

  Request History

  3 previous requests available

  • Restore to current request
  • articles/view/62/location-location-costa-rica
  • explore/select_topics
  • our-services

  ====
• Session
  +

  Session

  • Config(array)
    • userAgentcc2d3fd23c5dd98eb73e42c141648c0a
    • time1780717508
    • countdown10
  • Explore(array)
    • rejected_tiles(array)
      • rejected_topics(empty)
      • rejected_locations(empty)

  ====
• Request
  +

  Request

  Cake Params

  • plugin(null)
  • controllerlocations
  • actionview
  • named(empty)
  • pass(array)
    • 016
    • 1orlando-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: 15 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`.`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_dev2`.`locations` AS `Location` LEFT JOIN `leveragere_dev2`.`assets` AS `Image` ON (`Image`.`model_id` = `Location`.`id` AND `Image`.`model` = 'Location' AND `Image`.`tag` = 'Image') WHERE `Location`.`id` = 16 AND `Location`.`archived` = '0' LIMIT 1	1	1	1
  SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`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_auto_import_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`.`country_id`, `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_dev2`.`brokerages` AS `Brokerage` LEFT JOIN `leveragere_dev2`.`users` AS `AccountExecutive` ON (`Brokerage`.`account_executive_id` = `AccountExecutive`.`id`) LEFT JOIN `leveragere_dev2`.`assets` AS `Logo` ON (`Logo`.`model_id` = `Brokerage`.`id` AND `Logo`.`model` = 'Brokerage' AND `Logo`.`tag` = 'Logo') LEFT JOIN `leveragere_dev2`.`assets` AS `MainImage` ON (`MainImage`.`model_id` = `Brokerage`.`id` AND `MainImage`.`model` = 'Brokerage' AND `MainImage`.`tag` = 'MainImage') LEFT JOIN `leveragere_dev2`.`assets` AS `ContactImage` ON (`ContactImage`.`model_id` = `Brokerage`.`id` AND `ContactImage`.`model` = 'Brokerage' AND `ContactImage`.`tag` = 'ContactImage') LEFT JOIN `leveragere_dev2`.`assets` AS `ContactImage2` ON (`ContactImage2`.`model_id` = `Brokerage`.`id` AND `ContactImage2`.`model` = 'Brokerage' AND `ContactImage2`.`tag` = 'ContactImage2') LEFT JOIN `leveragere_dev2`.`assets` AS `ContactImage3` ON (`ContactImage3`.`model_id` = `Brokerage`.`id` AND `ContactImage3`.`model` = 'Brokerage' AND `ContactImage3`.`tag` = 'ContactImage3') LEFT JOIN `leveragere_dev2`.`assets` AS `BrokerOfRecordLogo` ON (`BrokerOfRecordLogo`.`model_id` = `Brokerage`.`id` AND `BrokerOfRecordLogo`.`model` = 'Brokerage' AND `BrokerOfRecordLogo`.`tag` = 'BrokerOfRecordLogo') LEFT JOIN `leveragere_dev2`.`articles` AS `MainArticle` ON (`MainArticle`.`model_id` = `Brokerage`.`id` AND `MainArticle`.`model` = 'Brokerage') WHERE `Brokerage`.`id` = 100 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_dev2`.`assets` AS `FeaturedImage` WHERE `FeaturedImage`.`model` = 'Brokerage' AND `FeaturedImage`.`tag` = 'FeaturedImage' AND `FeaturedImage`.`model_id` = (100) 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`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population` FROM `leveragere_dev2`.`locations` AS `Location` WHERE `Location`.`brokerage_id` = (100)	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_dev2`.`users` AS `User` WHERE `User`.`brokerage_id` = (100)	0	0	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`.`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_auto_import_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`.`country_id`, `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`.`short_description`, `ParentLocation`.`long_description`, `ParentLocation`.`created`, `ParentLocation`.`modified`, `ParentLocation`.`timezone`, `ParentLocation`.`population` FROM `leveragere_dev2`.`articles` AS `Article` LEFT JOIN `leveragere_dev2`.`brokerages` AS `ParentBrokerage` ON (`Article`.`model_id` = `ParentBrokerage`.`id` AND `Article`.`model` = 'Brokerage') LEFT JOIN `leveragere_dev2`.`locations` AS `ParentLocation` ON (`Article`.`model_id` = `ParentLocation`.`id` AND `Article`.`model` = 'Location') WHERE `Article`.`model` = 'Location' AND `Article`.`model_id` = 16 LIMIT 1	0	0	1	maybe slow
  SELECT `Location`.`id`, `Location`.`name`, `Location`.`parent_id` FROM `leveragere_dev2`.`locations` AS `Location` WHERE `Location`.`id` = 16 AND `Location`.`archived` = '0' LIMIT 1	1	1	0
  SELECT `Location`.`id`, `Location`.`name` FROM `leveragere_dev2`.`locations` AS `Location` WHERE `Location`.`parent_id` = 16	0	0	0
  SELECT `Location`.`id`, `Location`.`brokerage_id` FROM `leveragere_dev2`.`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`.`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_auto_import_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`.`country_id`, `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_dev2`.`properties` AS `Property` LEFT JOIN `leveragere_dev2`.`property_categories` AS `PrimaryPropertyCategory` ON (`Property`.`primary_property_category_id` = `PrimaryPropertyCategory`.`id`) LEFT JOIN `leveragere_dev2`.`brokerages` AS `Brokerage` ON (`Property`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_dev2`.`stripe_subscriptions` AS `StripeSubscription` ON (`StripeSubscription`.`property_id` = `Property`.`id` AND `StripeSubscription`.`status` = 'active') LEFT JOIN `leveragere_dev2`.`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`.`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`.`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_auto_import_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`.`country_id`, `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_dev2`.`locations` AS `Location` LEFT JOIN `leveragere_dev2`.`brokerages` AS `Brokerage` ON (`Location`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_dev2`.`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	3	maybe slow
  SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`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_auto_import_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`.`country_id`, `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_dev2`.`brokerages` AS `Brokerage` LEFT JOIN `leveragere_dev2`.`assets` AS `Logo` ON (`Logo`.`model_id` = `Brokerage`.`id` AND `Logo`.`model` = 'Brokerage' AND `Logo`.`tag` = 'Logo') WHERE `Brokerage`.`archived` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	3	maybe slow
  SELECT `Property`.`id` FROM `leveragere_dev2`.`properties` AS `Property` WHERE `Property`.`archived` = '0' AND `Property`.`incomplete` = '0' ORDER BY `Property`.`created` DESC LIMIT 50	48	48	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`.`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_auto_import_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`.`country_id`, `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_dev2`.`properties` AS `Property` LEFT JOIN `leveragere_dev2`.`property_categories` AS `PrimaryPropertyCategory` ON (`Property`.`primary_property_category_id` = `PrimaryPropertyCategory`.`id`) LEFT JOIN `leveragere_dev2`.`brokerages` AS `Brokerage` ON (`Property`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_dev2`.`stripe_subscriptions` AS `StripeSubscription` ON (`StripeSubscription`.`property_id` = `Property`.`id` AND `StripeSubscription`.`status` = 'active') LEFT JOIN `leveragere_dev2`.`global_reach_reports` AS `GlobalReachReport` ON (`GlobalReachReport`.`property_id` = `Property`.`id`) WHERE `Property`.`id` IN (153, 157, 156, 155, 154, 152, 151, 146, 145, 144, 143, 142, 141, 140, 139, 95, 94, 93, 84, 83, 82, 81, 78, 77, 67, 66, 65, 64, 61, 48, 47, 46, 45, 44, 42, 41, 33, 29, 27, 26, 25, 16, 14, 11, 10, 9, 8, 7) AND `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	3	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_dev2`.`assets` AS `Image` WHERE `Image`.`model` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (7, 153, 142, 154) ORDER BY `Image`.`order` ASC	46	46	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_dev2`.`users` AS `User` JOIN `leveragere_dev2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (7, 153, 142, 154) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	2	2	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_dev2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_dev2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (7, 153, 142, 154) AND `PropertiesSecondaryPropertyCategory`.`property_category_id` = `SecondaryPropertyCategory`.`id`)	0	0	1	maybe slow
  SELECT `PropertyFeature`.`id`, `PropertyFeature`.`name`, `PropertyFeature`.`additional`, `PropertyFeature`.`created`, `PropertyFeature`.`modified`, `PropertiesPropertyFeature`.`id`, `PropertiesPropertyFeature`.`property_id`, `PropertiesPropertyFeature`.`property_feature_id` FROM `leveragere_dev2`.`property_features` AS `PropertyFeature` JOIN `leveragere_dev2`.`properties_property_features` AS `PropertiesPropertyFeature` ON (`PropertiesPropertyFeature`.`property_id` IN (7, 153, 142, 154) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	3	3	0
  SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_dev2`.`topics` AS `Topic` JOIN `leveragere_dev2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (7, 153, 142, 154) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	0

  Query Explain:

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

  ====
• Timer
  +

  Memory

  Peak Memory Use 10.27 MB

  Message	Memory use
  Component initialization	2.87 MB
  Controller action start	3.78 MB
  Controller render start	6.58 MB
  View render complete	7.09 MB

  Timers

  Total Request Time: 187 (ms)

  Message	Time in ms	Graph
  Core Processing (Derived from $_SERVER["REQUEST_TIME"])	26.22
  Event: Controller.initialize	4.26
  Event: Controller.startup	1.16
  Controller action	43.19
  Event: Controller.beforeRender	5.63
  » Processing toolbar data	5.54
  Rendering View	84.56
  » Event: View.beforeRender	0.27
  » Rendering APP/View/Locations/view.ctp	2.47
  » » 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.17
  » » Rendering APP/View/Elements/sidebar/property_list.ctp	1.24
  » » » Rendering APP/View/Elements/static_property_price.ctp	0.37
  » » » Rendering APP/View/Elements/static_property_price.ctp #2	0.16
  » » » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
  » » » Rendering APP/View/Elements/static_property_price.ctp #4	0.13
  » » Rendering APP/View/Elements/sidebar/property_search.ctp	0.20
  » Event: View.afterRender	0.01
  » Event: View.beforeLayout	0.01
  » Rendering APP/View/Layouts/front.ctp	81.10
  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)
        • id7
        • brokerage_id122
        • created_by_user_id596
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameLake Travis Estate
        • incomplete(false)
        • archived(false)
        • last_archived0000-00-00 00:00:00
        • auto_archived_from_mlsidx(false)
        • paid_featured(false)
        • featured(true)
        • homepage_featured(true)
        • brokerage_page_featured(true)
        • 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_time2017-02-08 15:54:46
        • 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)
        • description<p>Overlooking the broad beauty of Lake Travis, this magnificent home reflects a love of entertaining. It is a space to be shared with family and friends and is planned and adorned with beautiful surfaces and a designer’s touch. Every room is special, and its environs are luxurious, lovely, architecturally inspiring and above all, welcoming. Winding access down to the lake’s shore leads to an enclosed dock with a boat lift and room for 2 jet skis. The dock also has a kitchenette and an open area for patio furniture.</p>
        • address211 Bella Riva Drive
        • address_2
        • cityAustin
        • stateTexas
        • postal_code55555
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyMXN
        • price50000
        • price_20
        • price_usd2913
        • price_usd_20
        • statusSold
        • status_last_changed0000-00-00 00:00:00
        • status_last_changed_price_only0000-00-00 00:00:00
        • lease_period
        • price_upon_request(false)
        • bedrooms5
        • bedrooms_20
        • bathrooms9
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet0
        • square_meters
        • acres459.679
        • interior_unitsq_ft
        • interior_size0
        • lot_unitsq_ft
        • lot_size20023600
        • icon_1on-the-sand
        • icon_2acreage
        • icon_3dock
        • icon_4office
        • icon_5
        • icon_6
        • website
        • meta_titleLake Travis Estate | Austin Real Estate | Partners Trust Real Estate Brokerage and Acquisitions
        • meta_description211 Bella Riva Drive in Austin, Texas, United States is offered for sale and is presented by Partners Trust Real Estate Brokerage and Acquisitions
        • meta_keywordskeyword test!!!
        • bathrooms_partial2
        • bathrooms_partial_20
        • bathrooms_3_42
        • bathrooms_3_4_20
        • year_built
        • virtual_tourhttp://jloop.com
        • video_tourhttp://www.youtube.com/embed/CrKf--CayOU
        • digital_brochure
        • video_tour_embed_code<iframe width="560" height="315" src="//www.youtube.com/embed/CrKf--CayOU" frameborder="0" allowfullscreen></iframe>
        • digital_brochure_embed_code
        • mls_num
        • wsj_property_type
        • nyt_property_type
        • nyt_popular_features
        • propgolux_property_type
        • juwai_property_type
        • juwai_categoryresidential
        • 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
        • latitude30.388569
        • longitude-97.952347
        • invalid_required_fieldspostal_code, agent_name_1, agent_email_1, latitude, longitude
        • invalid_optional_fieldssquare_feet, square_meters, hectares, agent_phone_1, agent_name_2, agent_email_2, agent_phone_2, year_built, wsj_property_type, nyt_property_type
        • 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)
        • modified2023-12-18 18:33:01
        • created2013-06-26 09:46:34
        • uri/property-detail/7/211-bella-riva-drive-austin-texas-55555-usa
        • absolute_urihttps://dev2.leveragere.com/property-detail/7/211-bella-riva-drive-austin-texas-55555-usa
        • address_concat211 Bella Riva Drive Austin Texas 55555 USA
        • google_maps_query_string211+Bella+Riva+Drive++Austin+Texas+55555+USA
        • luxury_ad_enrolled_prettyYES
        • price_prettyMXN 50,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettySq. Ft.
        • bedrooms_pretty5
        • bathrooms_pretty9
        • bathrooms_partial_pretty2
        • bathrooms_3_4_pretty2
        • feed_full_bathrooms11
        • date_listed2013-06-26
        • overridden_brokerage_nameTest
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id122
        • account_executive_id0
        • archived(false)
        • typebrokerage
        • hide_from_frontend(true)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typeSelect
        • max_properties0
        • 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)
        • WOEID(null)
        • 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_auto_import_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • nameTest
        • broker_of_record_name
        • short_nameTest
        • username
        • password
        • 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
        • description
        • communities
        • websitehttp://test.com
        • addresstest
        • address_2
        • citytest
        • stateca
        • full_state
        • countryUSA
        • market
        • market_2
        • postal_code90720
        • phone4246341622
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameMichael Stratford
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_title
        • 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_filename
        • logo_filename
        • contact_image_filename
        • all_properties_link_image_filename
        • all_properties_link
        • video_embed_code
        • contact_video_embed_code
        • meta_title
        • meta_description
        • meta_keywords
        • 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(false)
        • created2025-01-23 10:15:32
        • modified2025-01-23 10:16:13
        • country_id0
        • dre_num
        • uri/brokerage-detail/122/test
        • website_shorttest.com
        • name_with_locationTest
      • StripeSubscription(array)
        • id6
        • brokerage_id122
        • user_id596
        • property_id7
        • typedigital_ad
        • stripe_idsub_1QkV9DGUAz7G0CnkJGHkGVve
        • stripe_customer_idcus_RdmVtR4NguJnfx
        • stripe_checkout_email[email protected]
        • stripe_promotion_code
        • stripe_promotion_code_id
        • stripe_coupon_code_id
        • statusactive
        • current_period_end2025-02-22 10:28:59
        • cancel_at_period_end(false)
        • ended0000-00-00 00:00:00
        • last_change0000-00-00 00:00:00
        • last_activity_email_sent0000-00-00 00:00:00
        • created2025-01-23 10:29:06
        • modified2025-01-23 10:29:06
      • 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)
          • id655
          • modelProperty
          • model_id7
          • tagImage
          • name22.jpg
          • typeimage/jpg
          • size147125
          • uri/assets/655.jpg
          • order0
          • created2021-05-26 10:57:42
          • modified2020-10-21 13:25:50
        • 1(array)
          • id656
          • modelProperty
          • model_id7
          • tagImage
          • name77.jpg
          • typeimage/jpg
          • size11987
          • uri/assets/656.jpg
          • order1
          • created2016-02-29 16:23:30
          • modified2020-10-21 13:25:50
        • 2(array)
          • id657
          • modelProperty
          • model_id7
          • tagImage
          • name78.jpg
          • typeimage/jpg
          • size11987
          • uri/assets/657.jpg
          • order2
          • created2016-02-29 16:23:30
          • modified2020-10-21 13:25:50
        • 3(array)
          • id658
          • modelProperty
          • model_id7
          • tagImage
          • name81.jpg
          • typeimage/jpg
          • size11987
          • uri/assets/658.jpg
          • order3
          • created2016-02-29 16:23:30
          • modified2020-10-21 13:25:50
        • 4(array)
          • id659
          • modelProperty
          • model_id7
          • tagImage
          • name82.jpg
          • typeimage/jpg
          • size11987
          • uri/assets/659.jpg
          • order4
          • created2016-02-29 16:23:30
          • modified2020-10-21 13:25:50
        • 5(array)
          • id660
          • modelProperty
          • model_id7
          • tagImage
          • name83.jpg
          • typeimage/jpg
          • size11987
          • uri/assets/660.jpg
          • order5
          • created2016-02-29 16:23:30
          • modified2020-10-21 13:25:50
        • 6(array)
          • id661
          • modelProperty
          • model_id7
          • tagImage
          • name84.jpg
          • typeimage/jpg
          • size11987
          • uri/assets/661.jpg
          • order6
          • created2016-02-29 16:23:30
          • modified2020-10-21 13:25:50
      • User(array)
        • 0(array)
          • id333
          • typeAgent
          • brokerage_id3
          • email[email protected]
          • password0bd8713370b3d9d8cf5f543409e446b8040b78da
          • recover_hash
          • first_nameToddwick
          • last_namePastarooni
          • title
          • dre_num
          • phone8888888888
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2017-08-07 15:19:24
          • created2017-08-07 15:19:24
          • notified(false)
          • full_nameToddwick Pastarooni
          • uri/agent-detail/333/toddwick-pastarooni
          • profile_complete(true)
          • UsersProperty(array)
            • id11
            • user_id333
            • property_id7
            • sort_order0
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(array)
        • 0(array)
          • id10
          • nameOn The Sand
          • additional(false)
          • created2016-02-23 15:40:59
          • modified2016-02-23 15:40:59
          • PropertiesPropertyFeature(array)
            • id75
            • property_id7
            • property_feature_id10
        • 1(array)
          • id9
          • nameOffice
          • additional(false)
          • created2016-02-23 15:40:37
          • modified2016-02-23 15:40:37
          • PropertiesPropertyFeature(array)
            • id74
            • property_id7
            • property_feature_id9
        • 2(array)
          • id3
          • nameDock
          • additional(false)
          • created2016-02-23 15:37:17
          • modified2016-02-23 15:37:17
          • PropertiesPropertyFeature(array)
            • id73
            • property_id7
            • property_feature_id3
      • Topic(empty)
    • 1(array)
      • Property(array)
        • id153
        • brokerage_id103
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • name210 Kaelepulu Drive
        • 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(true)
        • force_luxury_feed_featured(false)
        • luxury_autofeed_imported(true)
        • luxury_feed_last_added_time2023-02-07 16:53:33
        • 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_urlhttps://www.juwai.com/75932064.htm
        • 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)
        • descriptionINVESTORS! 3 units just one block from the famous Lanikai beach and Mokulua islands, this multi-generational property is ideal for entertaining and indoor/outdoor island living. The property is located on the corner leading up to the popular Pillbox hiking trail and Mid-Pac Country Club and a short walk to the beach. 2 electronic gates allow for lots of space for kids to safely play in the yard around the property. This home has 3 separate entrances and includes 2 beds 1 bath upstairs with view of the ocean from the living area, 3 beds 1 bath downstairs plus a large studio with its own electronic gate and driveway. There are 2 outdoor showers for rinsing off after the beach, added 200 amps of power, lots of storage and beautiful landscaping. This property has so much to offer and its location is prime for easy access in and out of Lanikai. Close to restaurants, shops and schools and so much more!
        • address210 Kaelepulu Drive
        • address_2
        • cityKailua
        • stateHI
        • postal_code96734
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price2500000
        • price_20
        • price_usd2500000
        • 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)
        • bedrooms6
        • bedrooms_20
        • bathrooms3
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet2326
        • square_meters
        • acres0
        • interior_unitsq_ft
        • interior_size2326
        • 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_num202210691
        • wsj_property_typesingle family
        • nyt_property_type1
        • nyt_popular_features
        • propgolux_property_type9
        • juwai_property_typeSingle Family
        • juwai_categoryresidential
        • propgolux_property_style21
        • wapo_property_typeSingleFamily Home
        • robb_property_typeSingle Family Home
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude21.391964
        • longitude-157.718781
        • invalid_required_fields
        • invalid_optional_fields
        • went_live_today(false)
        • converted(false)
        • invalid(false)
        • mlsidx_full_address210 Kaelepulu Drive Kailua HI
        • mlsidx_date_listed2022-06-04
        • mls_marketHI_HBR
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated2025-01-27 16:02:52
        • modified2025-01-27 16:02:52
        • created2025-01-27 01:53:33
        • uri/property-detail/153/210-kaelepulu-drive-kailua-hi-96734-usa
        • absolute_urihttps://dev2.leveragere.com/property-detail/153/210-kaelepulu-drive-kailua-hi-96734-usa
        • address_concat210 Kaelepulu Drive Kailua HI 96734 USA
        • google_maps_query_string210+Kaelepulu+Drive++Kailua+HI+96734+USA
        • luxury_ad_enrolled_prettyAUTO
        • price_prettyUSD 2,500,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty6
        • bathrooms_pretty3
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms3
        • date_listed2022-06-04
        • overridden_brokerage_nameLUVA Real Estate
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(true)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id103
        • account_executive_id0
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typeBasic
        • max_properties100
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeLegacy
        • max_luxury_feed_properties-1
        • membership_luxury_feed_properties-1
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • WOEID(null)
        • timezonePacific/Honolulu
        • luxury_feed_enrollment_modeauto
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id18,27
        • mlsidx_auto_import_minimum_price0
        • mlsidx_logo_url/img/logo-mls-listings.png
        • mlsidx_disclaimerBased on information from the MLSListings MLS) as of {{date}} (date the MLS data was obtained). All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
        • nameLUVA Real Estate
        • broker_of_record_name
        • short_nameLUVA Real Estate
        • username
        • password
        • password_reset_hash
        • monthly_invoice_amount0.00
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename
        • active(true)
        • lead_inLUVA Real Estate is the exclusive representative for Leverage Global Partners on the Island of Oahu including; Honolulu, HI, USA.
        • short_description
        • description<p>OUR STORY</p> <p>LUVA Real Estate was founded in 2012 as a lifestyle focused company bringing together like - minded individuals from the Real Estate, Entertainment and Start up Business sectors.</p> <p>Borne from the idea that there is no one-size-fits-all approach to its customers, LUVA prides itself on being a progressive, boutique-style, technologically savvy brokerage. LUVA has expanded their presence with the launch of it's Oahu office in 2018. </p> <p>WHO WE ARE:</p> <p>We are people.</p> <p>Adventurers, dog lovers, surfers, activists, Netflix bingers, paddlers, caffeine addicts, parents & partners.</p> <p>We are relational, not just transactional.</p> <p>The process of buying & selling real estate is an emotional, financial and mental journey.  We partner with our clients through the ups & downs to achieve goals.</p> <p>WHAT WE DO:</p> <p>We tell stories.</p> <p>Selling a home is more complex than graphs & stats.  We creatively convey the home’s story to align with a buyer’s hopes and dreams - making it a tangible thing.  A physical place to create life & lifestyle.</p> <p>We provide solutions.</p> <p>We are professionals.  We are solution driven.  We are a mix plate - local hybrid combining all the best things - of information, technology, social media, collaboration and team work culture.  Our goal is simple - “Connecting humans with homes.”</p> <p>Wish you were here?</p> <p>We can help you with that.</p>
        • communitiesHonolulu
        • websitehttps://www.luvarealestate.com/
        • address970 N. Kalaheo Ave
        • address_2Suite A110
        • cityKailua
        • stateHI
        • full_stateHawaii
        • countryUSA
        • market
        • market_2
        • postal_code96734
        • phone808-262-5882
        • phone_2
        • phone_3
        • wide_contact_image(true)
        • contact_nameBrian Collins
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titlePartner
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebookhttps://www.facebook.com/LuvaRealEstate/
        • contact_twitterhttps://twitter.com/luvarealestate?lang=en
        • contact_instagramhttps://www.instagram.com/luva_real_estate/
        • contact_pinterest
        • contact_linkedinhttps://www.linkedin.com/company/luva-real-estate
        • contact_youtube
        • contact_phone818-898-8585
        • 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_2989-929-9393
        • contact_website
        • contact_name_2Kimi Correa
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2Broker-in-Charge
        • 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_filename
        • logo_filename
        • contact_image_filename
        • all_properties_link_image_filename
        • all_properties_link
        • video_embed_code
        • contact_video_embed_code
        • meta_title
        • meta_description
        • meta_keywords
        • 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(false)
        • created2019-12-03 19:18:48
        • modified2023-02-07 16:55:06
        • country_id0
        • dre_num012345
        • uri/brokerage-detail/103/luva-real-estate
        • website_shortwww.luvarealestate.com
        • name_with_locationLUVA Real Estate
        • mlsidx_id_array(array)
          • 018
          • 127
      • 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)
          • id2705
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_fa5d9fdb2fcc2bdf721cc75fb135f2af.jpg
          • typeimage/jpeg
          • size45629
          • uri/assets/2705.jpg
          • order0
          • created2023-02-07 16:53:34
          • modified2023-02-07 16:53:34
        • 1(array)
          • id2706
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_31d58f8701d7c908a98a6971be28d240.jpg
          • typeimage/jpeg
          • size48536
          • uri/assets/2706.jpg
          • order1
          • created2023-02-07 16:53:34
          • modified2023-02-07 16:53:34
        • 2(array)
          • id2707
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_a5838c56efdb02eb256cdf1766e389f5.jpg
          • typeimage/jpeg
          • size53048
          • uri/assets/2707.jpg
          • order2
          • created2023-02-07 16:53:34
          • modified2023-02-07 16:53:34
        • 3(array)
          • id2708
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_6a0161986677fe5fb073bcf2bad2d1fa.jpg
          • typeimage/jpeg
          • size44102
          • uri/assets/2708.jpg
          • order3
          • created2023-02-07 16:53:34
          • modified2023-02-07 16:53:34
        • 4(array)
          • id2709
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_2bf88b317d3d37cc77753ac5844c4999.jpg
          • typeimage/jpeg
          • size60473
          • uri/assets/2709.jpg
          • order4
          • created2023-02-07 16:53:34
          • modified2023-02-07 16:53:34
        • 5(array)
          • id2710
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_0344e09a22ec253244b053107b11016b.jpg
          • typeimage/jpeg
          • size44575
          • uri/assets/2710.jpg
          • order5
          • created2023-02-07 16:53:34
          • modified2023-02-07 16:53:34
        • 6(array)
          • id2711
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_2fa2253233ebcae1a5696ea6cb011278.jpg
          • typeimage/jpeg
          • size46952
          • uri/assets/2711.jpg
          • order6
          • created2023-02-07 16:53:34
          • modified2023-02-07 16:53:34
        • 7(array)
          • id2712
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_5257fe78f689e11ea7e953c23aa0b958.jpg
          • typeimage/jpeg
          • size44107
          • uri/assets/2712.jpg
          • order7
          • created2023-02-07 16:53:34
          • modified2023-02-07 16:53:34
        • 8(array)
          • id2713
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_f850cdf591c31f355ff0d6b0c4ba6d47.jpg
          • typeimage/jpeg
          • size77152
          • uri/assets/2713.jpg
          • order8
          • created2023-02-07 16:53:34
          • modified2023-02-07 16:53:34
        • 9(array)
          • id2714
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_ac16adc2afc0e9fd6bbf0a72be723eed.jpg
          • typeimage/jpeg
          • size60127
          • uri/assets/2714.jpg
          • order9
          • created2023-02-07 16:53:35
          • modified2023-02-07 16:53:35
        • 10(array)
          • id2715
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_e88b83dd59acf44e740b00bedf611864.jpg
          • typeimage/jpeg
          • size65235
          • uri/assets/2715.jpg
          • order10
          • created2023-02-07 16:53:35
          • modified2023-02-07 16:53:35
        • 11(array)
          • id2716
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_c7f5a6406d3f4e6b2b15196551c6b64e.jpg
          • typeimage/jpeg
          • size74462
          • uri/assets/2716.jpg
          • order11
          • created2023-02-07 16:53:35
          • modified2023-02-07 16:53:35
        • 12(array)
          • id2717
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_f14afe927c6545546f9a04f78aaa9d1a.jpg
          • typeimage/jpeg
          • size58623
          • uri/assets/2717.jpg
          • order12
          • created2023-02-07 16:53:35
          • modified2023-02-07 16:53:35
        • 13(array)
          • id2718
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_72eecaa9e54a1d44a8f932c1fa2f69c9.jpg
          • typeimage/jpeg
          • size55207
          • uri/assets/2718.jpg
          • order13
          • created2023-02-07 16:53:35
          • modified2023-02-07 16:53:35
        • 14(array)
          • id2719
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_e69e1be5992aea6571cacb74ea229509.jpg
          • typeimage/jpeg
          • size55797
          • uri/assets/2719.jpg
          • order14
          • created2023-02-07 16:53:35
          • modified2023-02-07 16:53:35
        • 15(array)
          • id2720
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_dc7d8e4cf3e8ddf57dcde3ac07746446.jpg
          • typeimage/jpeg
          • size65399
          • uri/assets/2720.jpg
          • order15
          • created2023-02-07 16:53:35
          • modified2023-02-07 16:53:35
        • 16(array)
          • id2721
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_69dc41696c3812370d9ccc3393d34feb.jpg
          • typeimage/jpeg
          • size71851
          • uri/assets/2721.jpg
          • order16
          • created2023-02-07 16:53:36
          • modified2023-02-07 16:53:36
        • 17(array)
          • id2722
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_43ab4cee5dfb48a202c36166a6e664dc.jpg
          • typeimage/jpeg
          • size65516
          • uri/assets/2722.jpg
          • order17
          • created2023-02-07 16:53:36
          • modified2023-02-07 16:53:36
        • 18(array)
          • id2723
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_b52fbd73980386e2b2a64993cbab5d8c.jpg
          • typeimage/jpeg
          • size53228
          • uri/assets/2723.jpg
          • order18
          • created2023-02-07 16:53:36
          • modified2023-02-07 16:53:36
        • 19(array)
          • id2724
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_8583c8b5db12f860e0c0d8accb7a28e0.jpg
          • typeimage/jpeg
          • size55225
          • uri/assets/2724.jpg
          • order19
          • created2023-02-07 16:53:36
          • modified2023-02-07 16:53:36
        • 20(array)
          • id2725
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_460f2ac0d607b4c4139cfdf7b4a14b0e.jpg
          • typeimage/jpeg
          • size56865
          • uri/assets/2725.jpg
          • order20
          • created2023-02-07 16:53:36
          • modified2023-02-07 16:53:36
        • 21(array)
          • id2726
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_9a726158767b60cd524a58b67c418063.jpg
          • typeimage/jpeg
          • size41833
          • uri/assets/2726.jpg
          • order21
          • created2023-02-07 16:53:36
          • modified2023-02-07 16:53:36
        • 22(array)
          • id2727
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_4fa929b0621b001205ff85282f563833.jpg
          • typeimage/jpeg
          • size63906
          • uri/assets/2727.jpg
          • order22
          • created2023-02-07 16:53:36
          • modified2023-02-07 16:53:36
        • 23(array)
          • id2728
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_9f0716949beb90b71bd65c39cf1cf6a4.jpg
          • typeimage/jpeg
          • size65949
          • uri/assets/2728.jpg
          • order23
          • created2023-02-07 16:53:36
          • modified2023-02-07 16:53:36
        • 24(array)
          • id2729
          • modelProperty
          • model_id153
          • tagImage
          • name202210691_d0af964d9b1445c5cfc1e94c8e104c8e.jpg
          • typeimage/jpeg
          • size98568
          • uri/assets/2729.jpg
          • order24
          • created2023-02-07 16:53:37
          • modified2023-02-07 16:53:37
      • User(empty)
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(empty)
      • Topic(empty)
    • 2(array)
      • Property(array)
        • id142
        • brokerage_id105
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameBrokerageAdmin4
        • 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(true)
        • force_luxury_feed_featured(false)
        • luxury_autofeed_imported(false)
        • luxury_feed_last_added_time2020-11-19 13:34:04
        • 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_sent2021-07-08 13:52:49
        • digital_ad_summary_price_changed(false)
        • wsj_detail_urlhttps://realestate.wsj.com/losangeles/3305075
        • ft_detail_urlhttps://propertylistings.ft.com/homes/3180427
        • nyt_detail_url
        • juwai_detail_urlhttps://www.juwai.com/54348995.htm
        • pgl_detail_urlhttps://www.propgoluxury.com/en/homes/3180427
        • mg_detail_urlhttps://www.mansionglobal.com/listings/3305075
        • mg_c_detail_url
        • mg_s_detail_url
        • bp_detail_urlhttps://www.barrons.com/real-estate/listings/3305075
        • mw_detail_urlhttps://www.marketwatch.com/personal-finance/real-estate/listings/3305075
        • nikkei_detail_url
        • wapo_detail_urlhttps://realestate.washingtonpost.com/sales/detail/299-l-18136-12059/150-union-jack-mall-marina-del-rey-ca-90292
        • robb_detail_urlhttps://realestate.robbreport.com/listing/leverage-global-partners/12059
        • medium_featured(false)
        • large_featured(false)
        • detail_page(false)
        • description<p>BrokerageAdmin4</p>
        • address425 E. 4th Street
        • address_2
        • cityLong Beach
        • stateCA
        • postal_code90802
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price5000000
        • price_20
        • price_usd5000000
        • price_usd_20
        • statusFor Sale
        • status_last_changed2020-11-19 12:50:34
        • status_last_changed_price_only0000-00-00 00:00:00
        • lease_period
        • price_upon_request(false)
        • bedrooms0
        • bedrooms_20
        • bathrooms0
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet0
        • square_meters
        • acres0
        • interior_unitsq_ft
        • interior_size0
        • lot_unitacres
        • lot_size0
        • icon_1
        • icon_2
        • icon_3
        • icon_4
        • icon_5
        • icon_6
        • website
        • meta_title
        • meta_description
        • meta_keywords
        • bathrooms_partial0
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built
        • virtual_tour
        • video_tour
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num
        • wsj_property_typecondominium
        • nyt_property_type3
        • nyt_popular_features
        • propgolux_property_type2
        • juwai_property_typeSingle Family
        • juwai_categorycommercial
        • propgolux_property_style4
        • wapo_property_typeCondominium
        • robb_property_typeCondominium
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude33.772045
        • longitude-118.186913
        • invalid_required_fields
        • invalid_optional_fields
        • went_live_today(false)
        • converted(false)
        • invalid(false)
        • mlsidx_full_address
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2023-12-18 18:33:01
        • created2020-11-19 12:50:21
        • uri/property-detail/142/425-e-4th-street-long-beach-ca-90802-usa
        • absolute_urihttps://dev2.leveragere.com/property-detail/142/425-e-4th-street-long-beach-ca-90802-usa
        • address_concat425 E. 4th Street Long Beach CA 90802 USA
        • google_maps_query_string425+E.+4th+Street++Long+Beach+CA+90802+USA
        • luxury_ad_enrolled_prettyYES
        • price_prettyUSD 5,000,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty0
        • bathrooms_pretty0
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms0
        • date_listed2020-11-19
        • overridden_brokerage_nameThe Leverage Legacy
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id105
        • account_executive_id0
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typeBasic
        • max_properties20
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties2
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • WOEID(null)
        • timezoneAmerica/Los_Angeles
        • luxury_feed_enrollment_modemanual
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts[email protected],[email protected]
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id
        • mlsidx_auto_import_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • nameThe Leverage Legacy
        • broker_of_record_name
        • short_nameLeverage Legacy
        • username
        • password
        • 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
        • description<p>A test brokerage for the legacy transition</p>
        • communities
        • websitehttps://jloop.com
        • address425 E. 4th Street
        • address_2Suite C
        • cityLong Beach
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • market
        • market_2
        • postal_code90802
        • phone8888888888
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameChris Stevens
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titleSome Guy
        • 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_filename
        • logo_filename
        • contact_image_filename
        • all_properties_link_image_filename
        • all_properties_link
        • video_embed_code
        • contact_video_embed_code
        • meta_title
        • meta_description
        • meta_keywords
        • 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(false)
        • created2020-11-16 13:05:19
        • modified2022-01-03 13:31:19
        • country_id0
        • dre_num012345
        • uri/brokerage-detail/105/the-leverage-legacy
        • website_shortjloop.com
        • name_with_locationThe Leverage Legacy
      • 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)
          • id2494
          • modelProperty
          • model_id142
          • tagImage
          • namefpo_large.jpg
          • typeimage/jpeg
          • size71316
          • uri/assets/2494.jpg
          • order0
          • created2020-11-19 12:50:18
          • modified2020-11-19 12:50:21
      • User(array)
        • 0(array)
          • id584
          • typeAgent
          • brokerage_id105
          • email[email protected]
          • password6e83e74e5aad7dc2404b41f4dad53b857b4a34ae
          • recover_hash
          • first_nameFixed
          • last_nameMan
          • title
          • dre_num
          • phone8888888888
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2020-11-19 13:32:02
          • created2020-11-19 13:32:02
          • notified(false)
          • full_nameFixed Man
          • uri/agent-detail/584/fixed-man
          • profile_complete(true)
          • UsersProperty(array)
            • id41
            • user_id584
            • property_id142
            • sort_order0
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(empty)
      • Topic(empty)
    • 3(array)
      • Property(array)
        • id154
        • brokerage_id103
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • name4176 Keanu Street Unit: 1
        • 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(true)
        • force_luxury_feed_featured(false)
        • luxury_autofeed_imported(true)
        • luxury_feed_last_added_time2023-02-07 16:55:13
        • 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)
        • descriptionThis beautiful end unit boasts pride of ownership and includes stainless steel appliances, newer refrigerator, granite kitchen counters, washer/dryer hidden in a custom-built cabinet, full size bath downstairs and upstairs, tiling throughout including storage closet for additional pantry or utility storage, plus a drop-down ladder to the attic storage. Warm wood cabinetry in kitchen and accents throughout. Lots of natural lighting from the windows in every room. Living room has split a/c, ceiling fan in one bedroom and window a/c in 2nd bedroom. This unit comes complete with all of the features you need for comfort style living. The desirable Tropic Gardens is a very peaceful residential community conveniently located close to Kahala Mall, schools, restaurants, walking distance to the new Kuono Marktplace at Kahala and just minutes from Waikiki, golf spots, beaches and so much more!
        • address4176 Keanu Street Unit: 1
        • address_2
        • cityHonolulu
        • stateHI
        • postal_code96816
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price685000
        • price_20
        • price_usd685000
        • price_usd_20
        • statusFor Sale
        • status_last_changed0000-00-00 00:00:00
        • status_last_changed_price_only0000-00-00 00:00:00
        • lease_period
        • price_upon_request(false)
        • bedrooms2
        • bedrooms_20
        • bathrooms2
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet1032
        • square_meters
        • acres0
        • interior_unitsq_ft
        • interior_size1032
        • 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_num202219457
        • wsj_property_typecondo
        • nyt_property_type5
        • nyt_popular_features
        • propgolux_property_type2
        • juwai_property_typeApartments/Condo
        • juwai_categoryresidential
        • propgolux_property_style21
        • wapo_property_typeCondominium
        • robb_property_typeCondo
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude21.280785
        • longitude-157.786285
        • invalid_required_fields
        • invalid_optional_fields
        • went_live_today(false)
        • converted(false)
        • invalid(false)
        • mlsidx_full_address4176 Keanu Street Unit: 1 Honolulu HI
        • mlsidx_date_listed2022-09-14
        • mls_marketHI_HBR
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2023-12-18 18:33:01
        • created2023-02-07 16:55:13
        • uri/property-detail/154/4176-keanu-street-unit-1-honolulu-hi-96816-usa
        • absolute_urihttps://dev2.leveragere.com/property-detail/154/4176-keanu-street-unit-1-honolulu-hi-96816-usa
        • address_concat4176 Keanu Street Unit: 1 Honolulu HI 96816 USA
        • google_maps_query_string4176+Keanu+Street+Unit%3A+1++Honolulu+HI+96816+USA
        • luxury_ad_enrolled_prettyAUTO
        • price_prettyUSD 685,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty2
        • bathrooms_pretty2
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms2
        • date_listed2022-09-14
        • overridden_brokerage_nameLUVA Real Estate
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(true)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id103
        • account_executive_id0
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typeBasic
        • max_properties100
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeLegacy
        • max_luxury_feed_properties-1
        • membership_luxury_feed_properties-1
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • WOEID(null)
        • timezonePacific/Honolulu
        • luxury_feed_enrollment_modeauto
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id18,27
        • mlsidx_auto_import_minimum_price0
        • mlsidx_logo_url/img/logo-mls-listings.png
        • mlsidx_disclaimerBased on information from the MLSListings MLS) as of {{date}} (date the MLS data was obtained). All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
        • nameLUVA Real Estate
        • broker_of_record_name
        • short_nameLUVA Real Estate
        • username
        • password
        • password_reset_hash
        • monthly_invoice_amount0.00
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename
        • active(true)
        • lead_inLUVA Real Estate is the exclusive representative for Leverage Global Partners on the Island of Oahu including; Honolulu, HI, USA.
        • short_description
        • description<p>OUR STORY</p> <p>LUVA Real Estate was founded in 2012 as a lifestyle focused company bringing together like - minded individuals from the Real Estate, Entertainment and Start up Business sectors.</p> <p>Borne from the idea that there is no one-size-fits-all approach to its customers, LUVA prides itself on being a progressive, boutique-style, technologically savvy brokerage. LUVA has expanded their presence with the launch of it's Oahu office in 2018. </p> <p>WHO WE ARE:</p> <p>We are people.</p> <p>Adventurers, dog lovers, surfers, activists, Netflix bingers, paddlers, caffeine addicts, parents & partners.</p> <p>We are relational, not just transactional.</p> <p>The process of buying & selling real estate is an emotional, financial and mental journey.  We partner with our clients through the ups & downs to achieve goals.</p> <p>WHAT WE DO:</p> <p>We tell stories.</p> <p>Selling a home is more complex than graphs & stats.  We creatively convey the home’s story to align with a buyer’s hopes and dreams - making it a tangible thing.  A physical place to create life & lifestyle.</p> <p>We provide solutions.</p> <p>We are professionals.  We are solution driven.  We are a mix plate - local hybrid combining all the best things - of information, technology, social media, collaboration and team work culture.  Our goal is simple - “Connecting humans with homes.”</p> <p>Wish you were here?</p> <p>We can help you with that.</p>
        • communitiesHonolulu
        • websitehttps://www.luvarealestate.com/
        • address970 N. Kalaheo Ave
        • address_2Suite A110
        • cityKailua
        • stateHI
        • full_stateHawaii
        • countryUSA
        • market
        • market_2
        • postal_code96734
        • phone808-262-5882
        • phone_2
        • phone_3
        • wide_contact_image(true)
        • contact_nameBrian Collins
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titlePartner
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebookhttps://www.facebook.com/LuvaRealEstate/
        • contact_twitterhttps://twitter.com/luvarealestate?lang=en
        • contact_instagramhttps://www.instagram.com/luva_real_estate/
        • contact_pinterest
        • contact_linkedinhttps://www.linkedin.com/company/luva-real-estate
        • contact_youtube
        • contact_phone818-898-8585
        • 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_2989-929-9393
        • contact_website
        • contact_name_2Kimi Correa
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2Broker-in-Charge
        • 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_filename
        • logo_filename
        • contact_image_filename
        • all_properties_link_image_filename
        • all_properties_link
        • video_embed_code
        • contact_video_embed_code
        • meta_title
        • meta_description
        • meta_keywords
        • 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(false)
        • created2019-12-03 19:18:48
        • modified2023-02-07 16:55:06
        • country_id0
        • dre_num012345
        • uri/brokerage-detail/103/luva-real-estate
        • website_shortwww.luvarealestate.com
        • name_with_locationLUVA Real Estate
        • mlsidx_id_array(array)
          • 018
          • 127
      • 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)
          • id2730
          • modelProperty
          • model_id154
          • tagImage
          • name202219457_c5604e505cde1d0d0d9a5897fc76c31a.jpg
          • typeimage/jpeg
          • size46882
          • uri/assets/2730.jpg
          • order0
          • created2023-02-07 16:55:14
          • modified2023-02-07 16:55:14
        • 1(array)
          • id2731
          • modelProperty
          • model_id154
          • tagImage
          • name202219457_6554f7da27d0df03fdc32555117b826a.jpg
          • typeimage/jpeg
          • size48329
          • uri/assets/2731.jpg
          • order1
          • created2023-02-07 16:55:14
          • modified2023-02-07 16:55:14
        • 2(array)
          • id2732
          • modelProperty
          • model_id154
          • tagImage
          • name202219457_8f9b2e08281d685dc95ca40626a52d17.jpg
          • typeimage/jpeg
          • size48448
          • uri/assets/2732.jpg
          • order2
          • created2023-02-07 16:55:14
          • modified2023-02-07 16:55:14
        • 3(array)
          • id2733
          • modelProperty
          • model_id154
          • tagImage
          • name202219457_7c8c6ac13d7d75f85e12c131bb744ee6.jpg
          • typeimage/jpeg
          • size45353
          • uri/assets/2733.jpg
          • order3
          • created2023-02-07 16:55:14
          • modified2023-02-07 16:55:14
        • 4(array)
          • id2734
          • modelProperty
          • model_id154
          • tagImage
          • name202219457_32cb8db464bc2fed9990be6e6c061e44.jpg
          • typeimage/jpeg
          • size55198
          • uri/assets/2734.jpg
          • order4
          • created2023-02-07 16:55:14
          • modified2023-02-07 16:55:14
        • 5(array)
          • id2735
          • modelProperty
          • model_id154
          • tagImage
          • name202219457_86ca498d8cecfc21e742556d4f0cdfa2.jpg
          • typeimage/jpeg
          • size53569
          • uri/assets/2735.jpg
          • order5
          • created2023-02-07 16:55:14
          • modified2023-02-07 16:55:14
        • 6(array)
          • id2736
          • modelProperty
          • model_id154
          • tagImage
          • name202219457_3f987b09cdc4e80f230de8eb14a28f24.jpg
          • typeimage/jpeg
          • size47028
          • uri/assets/2736.jpg
          • order6
          • created2023-02-07 16:55:14
          • modified2023-02-07 16:55:14
        • 7(array)
          • id2737
          • modelProperty
          • model_id154
          • tagImage
          • name202219457_2854f2574f1cf2f5e7550c49c637ccd0.jpg
          • typeimage/jpeg
          • size73666
          • uri/assets/2737.jpg
          • order7
          • created2023-02-07 16:55:15
          • modified2023-02-07 16:55:15
        • 8(array)
          • id2738
          • modelProperty
          • model_id154
          • tagImage
          • name202219457_e8d7b25920bcf1c4045327135d67b5f4.jpg
          • typeimage/jpeg
          • size48004
          • uri/assets/2738.jpg
          • order8
          • created2023-02-07 16:55:15
          • modified2023-02-07 16:55:15
        • 9(array)
          • id2739
          • modelProperty
          • model_id154
          • tagImage
          • name202219457_06269f619bffb92b6de62b1cbcd85d98.jpg
          • typeimage/jpeg
          • size51459
          • uri/assets/2739.jpg
          • order9
          • created2023-02-07 16:55:15
          • modified2023-02-07 16:55:15
        • 10(array)
          • id2740
          • modelProperty
          • model_id154
          • tagImage
          • name202219457_a0084ddd3b599a3e55b9d7e5d1fa6bbb.jpg
          • typeimage/jpeg
          • size51259
          • uri/assets/2740.jpg
          • order10
          • created2023-02-07 16:55:15
          • modified2023-02-07 16:55:15
        • 11(array)
          • id2741
          • modelProperty
          • model_id154
          • tagImage
          • name202219457_cc1f64822027bf3a1479ea9a3dd8e018.jpg
          • typeimage/jpeg
          • size40970
          • uri/assets/2741.jpg
          • order11
          • created2023-02-07 16:55:15
          • modified2023-02-07 16:55:15
        • 12(array)
          • id2742
          • modelProperty
          • model_id154
          • tagImage
          • name202219457_69cdd976ecb507863463563de2bfc37b.jpg
          • typeimage/jpeg
          • size91529
          • uri/assets/2742.jpg
          • order12
          • created2023-02-07 16:55:15
          • modified2023-02-07 16:55:15
      • User(empty)
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(empty)
      • Topic(empty)
  • sidebar_brokerages(array)
    • 0(array)
      • Brokerage(array)
        • id43
        • account_executive_id0
        • 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)
        • WOEID2442043
        • 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_auto_import_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • nameCampi Properties, Inc.
        • broker_of_record_name
        • short_nameCampi Properties, Inc.
        • username
        • password
        • password_reset_hash
        • monthly_invoice_amount0.00
        • monthly_invoice_start_date0000-00-00
        • monthly_invoice_end_date0000-00-00
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>Campi Properties is the exclusive representative for Leverage Global Partners in Los Altos, Los Altos Hills, Palo Alto Hills, Portola Valley, Ladera, Mountain View, Cupertino, and Sunnyvale, California, USA.</p> <p>Campi Properties is an independent, locally owned residential real estate firm on the San Francisco Peninsula. Established in 1989 by owner-brokers Gary Campi and Karen Campi, Campi Properities is located in Los Altos in the heart of Silicon Valley. Renowned for representing some of the Peninsula's most exclusive properties, the 25+ agents at Campi Properites represent sellers and buyers of all types of residential real estate and investment properties throughout the Bay Area. No matter what your real estate need is, Campi Properties provides the kind of personalized service and hands-on local expertise that every client deserves.</p> <p>With experienced, attentive agents, Campi Properties distinguishes itself from other real estate companies with a level of service that sometimes becomes only a promise from other companies. When you select Campi Properties to represent you in the purchase or sale of a property, your best interests are always our top priority.</p> <p>Campi Properties is the exclusive representative of Leverage Global Partners in the communities of Los Altos, Los Altos Hills, Palo Alto Hills, Portola Valley, Ladera, Mountain View, Cupertino, and Sunnyvale, California.</p>
        • communitiesLos altos los altos hills palo alto hills portola valley ladera mountain view cupertino sunnyvale
        • websitehttp://campi.com/index.php
        • address195 S. San Antonio Road
        • address_2
        • cityLos Altos
        • stateCA
        • full_stateCalifornia
        • country
        • market
        • market_2
        • postal_code
        • phone(650) 941-4300
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameGary Campi
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titleFounder
        • 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_filename43.jpg
        • logo_filename43.jpg
        • contact_image_filename43.jpg
        • all_properties_link_image_filename
        • all_properties_link
        • video_embed_code
        • contact_video_embed_code
        • meta_titleLos Altos Real Estate | Campi Properties, Inc. | Leverage Global Partners
        • meta_descriptionCampi Properties, Inc. is the Leverage Global Partners exclusive representative in the Los Altos, California area.
        • meta_keywordscampi properties, gary campi, los altos real estate, gary campi, leverage global partners
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-08-21 16:31:27
        • modified2016-02-26 15:37:59
        • country_id1
        • dre_num012345
        • uri/brokerage-detail/43/campi-properties-inc
        • website_shortcampi.com/index.php
        • name_with_locationCampi Properties, Inc.
      • Logo(array)
        • id518
        • modelBrokerage
        • model_id43
        • tagLogo
        • name43.jpg
        • typeimage/jpg
        • size
        • uri
        • order0
        • created2016-02-26 15:03:35
        • modified2016-02-26 15:03:35
    • 1(array)
      • Brokerage(array)
        • id80
        • account_executive_id0
        • 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)
        • WOEID2514815
        • timezoneUS/Eastern
        • luxury_feed_enrollment_modemanual
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id
        • mlsidx_auto_import_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • nameEvers & Co. Real Estate
        • broker_of_record_name
        • short_nameEvers & Co. Real Estate
        • username
        • password
        • password_reset_hash
        • monthly_invoice_amount0.00
        • monthly_invoice_start_date0000-00-00
        • monthly_invoice_end_date0000-00-00
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>Evers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Washington, DC and <a href="../../../brokerage-detail/81/Evers-&-Co.-Real-Estate">Chevy Chase</a>, MD, USA.</p> <p>More information coming soon!</p>
        • communitieswashington, DC chevy chase dupont kalorama georgetown american university park cleveland park Palisades logan circle capitol hill forest hills
        • websitehttp://www.eversco.com/
        • address4400 Jenifer Street, NW
        • address_2
        • cityWashington, D.C
        • state
        • full_state
        • country
        • marketWashington, D.C
        • market_2
        • postal_code20015
        • phoneOffice: (202) 364-1700
        • phone_2Cell: (202) 255-5009
        • phone_3
        • wide_contact_image(false)
        • contact_nameDonna Evers
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titlePresident & Founder
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename80.jpg
        • logo_filename80.png
        • contact_image_filename80.jpg
        • all_properties_link_image_filename
        • all_properties_link
        • video_embed_code
        • contact_video_embed_code
        • meta_titleWashington DC Real Estate | Evers & Co. Real Estate | Leverage Global Partners
        • meta_descriptionEvers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Washington, DC , Chevy Chase, Dupont, Kalorama, Georgetown, American University Park, Cleveland Park, Palisades, Logan Circle, Capitol Hill, and Forest Hills.
        • meta_keywordsWashington DC Real Estate, Evers & Co. Real Estate, Leverage Global Partners, chevy chase real estate, dupont real estate, kalorama real estate, georgetown, american university park real estate, cleveland park real estate, Palisades real estate, logan circle real estate, capitol hill real estate, forest hills real estate
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2014-01-10 16:30:33
        • modified2016-02-26 15:38:02
        • country_id1
        • dre_num012345
        • uri/brokerage-detail/80/evers-co-real-estate
        • website_shortwww.eversco.com
        • name_with_locationEvers & Co. Real Estate
      • Logo(array)
        • id626
        • modelBrokerage
        • model_id80
        • tagLogo
        • name80.png
        • typeimage/png
        • size
        • uri
        • order0
        • created2016-02-26 15:03:45
        • modified2016-02-26 15:03:45
    • 2(array)
      • Brokerage(array)
        • id92
        • account_executive_id0
        • 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)
        • WOEID(null)
        • timezonePacific/Midway
        • 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_auto_import_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • nameTodd's Homes
        • broker_of_record_name
        • short_nameTodd's
        • usernametoddhome
        • password6e83e74e5aad7dc2404b41f4dad53b857b4a34ae
        • 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
        • description<p>Looking for upload headers...</p>
        • communities
        • websitehttp://jloop.com
        • address431 Broadway
        • address_2
        • cityLong Beach
        • stateCA
        • full_state
        • countryUSA
        • market
        • market_2
        • postal_code
        • phone123 123 1234
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameTodd
        • 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_filename92.png
        • logo_filename92.png
        • contact_image_filename92.png
        • all_properties_link_image_filename
        • all_properties_link
        • video_embed_code
        • contact_video_embed_code
        • meta_title
        • meta_description
        • meta_keywords
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2015-01-29 12:37:53
        • modified2016-02-26 15:38:05
        • country_id0
        • dre_num012345
        • uri/brokerage-detail/92/todd-s-homes
        • website_shortjloop.com
        • name_with_locationTodd's Homes
      • Logo(array)
        • id653
        • modelBrokerage
        • model_id92
        • tagLogo
        • name92.png
        • typeimage/png
        • size20398
        • uri/assets/653.png
        • order0
        • created2016-02-26 15:03:49
        • modified2016-02-26 15:03:49
    • 3(array)
      • Brokerage(array)
        • id23
        • account_executive_id0
        • 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)
        • WOEID2161838
        • timezoneAsia/Hong_Kong
        • luxury_feed_enrollment_modemanual
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id
        • mlsidx_auto_import_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • nameAsia Pacific Properties
        • broker_of_record_name
        • short_nameAsia Pacific Properties
        • username
        • password
        • password_reset_hash
        • monthly_invoice_amount0.00
        • monthly_invoice_start_date0000-00-00
        • monthly_invoice_end_date0000-00-00
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>Asia Pacific Properties is the exclusive representative for Leverage Global Partners in Guangzhou, China.</p> <p>Asia Pacific Properties (APP) is a fully licensed premium real estate brokerage that proudly represents high net worth individuals and multinational corporations – including 50 of the Fortune 500 – in their relocations to and across Hong Kong and the Greater China region.</p> <p>Headquartered in Hong Kong, with offices in Shanghai, Beijing and Guangzhou, APP is primely positioned to service clients in first-tier Mainland cities, while also being able to assist in second and third-tier cities having gained solid experience in over 20 locations since its inception in 1985.</p> <p>APP has long been committed to providing an unparalleled standard of service rooted in the most ethical business practices and a focus on corporate governance. We strive to provide each client with a tailored experience that goes beyond expectations, and drives their success in life, business results and real estate by helping them smoothly integrate into new surroundings and new lives.</p> <p>Our roster of comprehensive services extends across residential, commercial and industrial real estate in addition to relocation programs that include orientation services, immigration and work-permit processing, school admissions consulting, cross-cultural training and asset and tenancy management.</p> <p>Guangzhou is located on China’s southern coastline, along the Pearl River in Guangdong province. Consisting of three main commercial districts in the eastern part of the city, convenience, like in Hong Kong, is fundamental to many residing in the region. For that reason, residential districts such as Er Sha Island and Bin Jian Dong are clustered around the city center, offering a high quality of life with easy access to key business districts, shopping malls, restaurants and international schools to those who can afford it.</p> <p>With an agglomeration of luxury high-rise buildings and enormous duplexes and penthouses, the Bin Jian Dong neighborhood is fast becoming the city’s premiere residential community. APP is an expert in the area, with our consultants rigorously staying abreast of any trends and developments in the market to ensure the fulfillment of our company mission.</p> <p>We also have offices in <a href="../../../brokerage-detail/2/Asia-Pacific-Properties" target="_blank">Hong Kong</a>, <a href="../../../brokerage-detail/20/Asia-Pacific-Properties" target="_blank">Shanghai</a> and <a href="../../../brokerage-detail/22/Asia-Pacific-Properties" target="_blank">Beijing</a>.</p>
        • communitiesGuangzhou China
        • websitehttp://www.asiapacificproperties.com/
        • addressUnit 841 The Garden Tower
        • address_2368 Huanshi Dong Lu
        • cityGuangzhou
        • state
        • full_state
        • country
        • marketGuangzhou
        • market_2
        • postal_code510064
        • phone(+) 86 20 8365 2922
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameBeverly L.W. Sunn
        • 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_filename23.jpg
        • logo_filename23.gif
        • contact_image_filename23.jpg
        • all_properties_link_image_filename
        • all_properties_link
        • video_embed_code
        • contact_video_embed_code
        • meta_titleGuangzhou Real Estate | Asia Pacific Properties | Leverage Global Partners
        • meta_descriptionAsia Pacific Properties is the exclusive representative for Leverage Global Partners in Guangzhou, China.
        • meta_keywordsasia pacific properties, guangzhou real estate, guangzhou china, leverage global partners, beverly sunn
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-04-16 12:27:29
        • modified2016-02-26 15:37:56
        • country_id2
        • dre_num012345
        • uri/brokerage-detail/23/asia-pacific-properties
        • website_shortwww.asiapacificproperties.com
        • name_with_locationAsia Pacific Properties
      • Logo(array)
        • id461
        • modelBrokerage
        • model_id23
        • tagLogo
        • name23.gif
        • typeimage/gif
        • size
        • uri
        • order0
        • created2016-02-26 15:03:21
        • modified2016-02-26 15:03:21
  • sidebar_locations(array)
    • 0(array)
      • Location(array)
        • id16
        • parent_id15
        • brokerage_id100
        • typeExclusive
        • archived(false)
        • use_as_topic(false)
        • nameOrlando, FL, USA
        • short_nameOrlando, FL, USA
        • group_index
        • latitude28.497662
        • longitude-81.342773
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • short_description
        • long_description
        • created2019-08-20 16:04:26
        • modified2019-08-20 16:14:30
        • timezone
        • population0
        • uri/locations/view/16/orlando-fl-usa
        • tile_nameOrlando, FL, USA
      • Brokerage(array)
        • id100
        • account_executive_id0
        • 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)
        • WOEID(null)
        • 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_auto_import_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • nameFusilier Realty Group
        • broker_of_record_name
        • short_nameFusilier Realty Group
        • username
        • password
        • password_reset_hash
        • monthly_invoice_amount0.00
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename
        • active(true)
        • lead_inFusilier Realty Group is the exclusive representative for Leverage Global Partners in Orlando, Florida, USA.
        • short_description
        • description<p>Fusilier Realty Group is located in the premiere Lake Nona area, home of Orlando's Medical City. Our agents have years of expertise in the South East Orlando and Saint Cloud region and are active members of the Local, State, and National Real Estate Association. Our dynamic, progressive, and savvy sales team is dedicated to fulfilling every client's needs. Our agency was founded on the belief that selling real estate can be an exciting and enjoyable experience for both buyer and seller.”</p> <p> </p> <p><strong>Lake Nona Office</strong></p> <p>9145 Narcoosee Rd, Ste. 102</p> <p>Orlando, FL 32827</p> <p>407-281-8455</p> <p> </p> <p><strong>Harmony Office</strong></p> <p>7272 Harmony Square Dr,</p> <p>Harmony, FL 34773</p> <p>407-259-2394</p> <p> </p> <p> </p>
        • communitiesorlando
        • websitehttp://www.realtygroupfl.com/
        • address9145 Narcoossee Road
        • address_2Suite 102
        • cityOrlando
        • stateFL
        • full_stateFlorida
        • countryUSA
        • market
        • market_2
        • postal_code32827
        • phoneOffice: (407) 281-8455
        • phone_2Fax: (407) 218-7422
        • phone_3
        • wide_contact_image(false)
        • contact_nameSteve Fusilier and Keith Race
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titleBrokers-in-Charge
        • 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_filename
        • logo_filename
        • contact_image_filename
        • all_properties_link_image_filename
        • all_properties_link
        • video_embed_code
        • contact_video_embed_code
        • meta_title
        • meta_description
        • meta_keywords
        • 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(false)
        • created2019-08-20 16:11:48
        • modified2019-08-20 16:11:48
        • country_id0
        • dre_num012345
        • uri/brokerage-detail/100/fusilier-realty-group
        • website_shortwww.realtygroupfl.com
        • name_with_locationFusilier Realty Group
      • Image(array)
        • id1628
        • modelLocation
        • model_id16
        • tagImage
        • namemobile_tile_FPO.png
        • typeimage/png
        • size16560
        • uri/assets/1628.png
        • order0
        • created2019-08-20 16:04:24
        • modified2019-08-20 16:14:30
    • 1(array)
      • Location(array)
        • id10
        • parent_id8
        • brokerage_id55
        • typeExclusive
        • archived(false)
        • use_as_topic(false)
        • nameTestwood
        • short_nameTestwood
        • group_index
        • latitude34.052235
        • longitude-118.243683
        • country_code
        • north0.000000
        • south0.000000
        • east0.000000
        • west0.000000
        • short_descriptionThis is the short description
        • long_descriptionThis is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description. This is the long description.
        • created2016-03-04 17:12:14
        • modified2016-11-04 13:59:00
        • timezoneAmerica/Los_Angeles
        • population4294967295
        • uri/locations/view/10/testwood
        • tile_nameTestwood
      • Brokerage(array)
        • id55
        • account_executive_id0
        • 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)
        • WOEID2434561
        • 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_auto_import_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • nameJ. Rockcliff Realtors
        • broker_of_record_name
        • short_nameJ Rockcliff Realtors
        • username
        • password
        • password_reset_hash
        • monthly_invoice_amount0.00
        • monthly_invoice_start_date0000-00-00
        • monthly_invoice_end_date0000-00-00
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>J. Rockcliff Realtors is the exclusive representative for Leverage Global Partners in Lafayette, Moraga, Orinda, and Canyon, California, USA.</p> <p>J. Rockcliff Realtors is one of the fastest growing real estate companies in California and has distinguished itself as The East Bay’s Premier Real Estate Company.</p> <p>With offices located in LaMorinda (Lafayette, Moraga, Orinda), Walnut Creek, Danville, Blackhawk, and Pleasanton/Dublin/Livermore, experienced Realtors can assist with your home buying or home selling needs in any real estate market. Looking for bank owned properties? We can help.</p> <p>J. Rockcliff Realtors’ Relocation Department provides home buying or home selling assistance around the corner or around the world. As members of Worldwide ERC (Employee Relocation Council), J. Rockcliff handles many corporate relocation moves as well.</p> <p>When listing or selling your home, you can rest assured that J. Rockcliff Realtors can provide the best real estate agents (Realtors) to help you buy or sell your home using the most innovative tools available, including; the finest marketing, the most advanced technology and resources unmatched by any other firm. J. Rockcliff Realtors is strategically positioned to be the company of choice now and in the future. J. Rockcliff Realtors is proudly licensed with the California Bureau of Real Estate - License #01793729.</p> <p>J.Rockcliff also has offices in <a href="../../../brokerage-detail/56/J.-Rockcliff-Realtors">Walnut Creek</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Danville</a>, and <a href="../../../brokerage-detail/57/J.-Rockcliff-Realtors">Pleasanton</a>.</p>
        • communitiesMoraga Lafayette Orinda Canyon LaMorinda
        • websitehttp://www.rockcliff.com/
        • address3799 Mt. Diablo Boulevard
        • address_2Suite 100
        • cityLafayette
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • marketLafayette
        • market_2
        • postal_code
        • phone(925) 385-2330
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameJeff Sposito
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titlePresident
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename55.jpg
        • logo_filename55.JPG
        • contact_image_filename55.jpg
        • all_properties_link_image_filename
        • all_properties_link
        • video_embed_code
        • contact_video_embed_code
        • meta_titleLafayette Real Estate | J. Rockcliff Realtors | Leverage Global Partners
        • meta_descriptionJ. Rockcliff Realtors is the exclusive representative for Leverage Global Partners in Lafayette, CA, USA.
        • meta_keywordsJ. Rockcliff Realtors, Lafayette Real Estate, Leverage Global Partners, Jeff Sposito
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-09-26 14:43:00
        • modified2018-01-19 16:49:53
        • country_id1
        • dre_num012345
        • uri/brokerage-detail/55/j-rockcliff-realtors
        • website_shortwww.rockcliff.com
        • name_with_locationJ. Rockcliff Realtors
      • Image(array)
        • id733
        • modelLocation
        • model_id10
        • tagImage
        • namepexels-photo-52599.jpeg
        • typeimage/jpeg
        • size120826
        • uri/assets/733.jpeg
        • order0
        • created2016-03-04 17:10:53
        • modified2016-11-04 13:59:00
    • 2(array)
      • Location(array)
        • id20
        • parent_id19
        • brokerage_id2
        • typeExclusive
        • archived(false)
        • use_as_topic(false)
        • nameTokyo, Japan
        • short_nameTokyo
        • group_index
        • latitude35.676193
        • longitude139.650314
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • short_description
        • long_description
        • created2019-08-27 14:00:56
        • modified2019-08-27 14:00:56
        • timezone
        • population0
        • uri/locations/view/20/tokyo-japan
        • tile_nameTokyo, Japan
      • Brokerage(array)
        • id2
        • account_executive_id7
        • 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)
        • WOEID24865698
        • timezoneAsia/Hong_Kong
        • luxury_feed_enrollment_modemanual
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id
        • mlsidx_auto_import_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • nameAsia Pacific Properties
        • broker_of_record_name
        • short_nameAsia Pacific Properties
        • username
        • password
        • password_reset_hash
        • monthly_invoice_amount0.00
        • monthly_invoice_start_date0000-00-00
        • monthly_invoice_end_date0000-00-00
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>Asia Pacific Properties is the exclusive representative for Leverage Global Partners in Hong Kong, China.</p> <p>Asia Pacific Properties (APP) is a fully licensed premium real estate brokerage that proudly represents high net worth individuals and multinational corporations – including 50 of the Fortune 500 – in their relocations to and across Hong Kong and the Greater China region.</p> <p>Since its inception in 1985, APP has committed itself to providing an unparalleled standard of service rooted in the most ethical business practices and a focus on corporate governance. We strive to provide each client with a tailored experience that goes beyond expectations, and drives their success in life, business results and real estate by helping them smoothly integrate into new surroundings and new lives.</p> <p>Our roster of comprehensive services extends across residential, commercial and industrial real estate in addition to relocation programs that include orientation services, immigration and work-permit processing, school admissions consulting, cross-cultural training and asset and tenancy management.</p> <p>Hong Kong is one of Asia’s most dynamic cities. Anchored in a rich colonial past, the special administrative region has blossomed into a multicultural financial center that has long been touted as ‘The Gateway to China’. Famous for its captivating harbor, architecturally stunning skyscrapers, high concentration of luxury shopping malls and dim-sum, this magnificent city is the unique blend of East and West.</p> <p>With convenience being treated as a basic commodity, Hong Kongers are well connected to an extensive transportation network that makes for an easy commute to work – and even a relaxing weekend of island hopping if you are longing for the taste of a little Garoupa!</p> <p>Residences are mostly scattered across Hong Kong Island, the Kowloon Peninsula and the New Territories, with a rich and varied choice of neighborhoods and building styles between them. Expats tend to congregate around the Mid-Levels district, while the Peak and Southside have long been favored by the city’s upper crust. More recently, the growth of secondary business districts and high property prices have seen increased demand for newer developments away from the city’s core, most notably around Kowloon Station in line with the completion of the International Commerce Centre (Hong Kong’s tallest building), and in Western districts soon to be connected to the city’s MTR network.</p> <p>In Hong Kong, APP’s real estate division operates under the branding of its subsidiary, <a href="http://www.okay.com/home" target="_blank">OKAY.com</a> - whose name reflects the pronunciation of “Home” in Cantonese. With over 25 years of experience, and proprietary technology to ensure the most accurate listings on the market, clients are provided with superior market knowledge and a well-trained team of personable consultants that are continuously redefining the meaning of “dedicated service”.</p> <p>APP is headquarted in Hong Kong, with additional offices in <a href="../../../brokerage-detail/20/Asia-Pacific-Properties" target="_blank">Shanghai</a>, <a href="../../../brokerage-detail/22/Asia-Pacific-Properties" target="_blank">Beijing</a> and <a href="../../../brokerage-detail/23/Asia-Pacific-Properties" target="_blank">Guangzhou</a>.</p>
        • communitiesHong Kong
        • websitehttp://www.asiapacificproperties.com/
        • address14/F Wilson House
        • address_219-27 Wyndham Street
        • cityCentral
        • state
        • full_state
        • countryUSA
        • marketHong Kong
        • market_2
        • postal_code
        • phone(+) 852 2281 7800
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameBeverly L.W. Sunn
        • 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_filename2.jpg
        • logo_filename2.gif
        • contact_image_filename2.jpg
        • all_properties_link_image_filename
        • all_properties_link
        • video_embed_code
        • contact_video_embed_code
        • meta_titleHong Kong Real Estate | Asia Pacific Properties | Leverage Global Partners
        • meta_descriptionAsia Pacific Properties is the exclusive representative for Leverage Global Partners in Hong Kong.
        • meta_keywordshong kong real estate, leverage global partners, asia pacific properties, beverly sunn
        • 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-13 16:22:39
        • modified2016-02-26 15:37:17
        • country_id2
        • dre_num012345
        • uri/brokerage-detail/2/asia-pacific-properties
        • website_shortwww.asiapacificproperties.com
        • name_with_locationAsia Pacific Properties
      • Image(array)
        • id1645
        • modelLocation
        • model_id20
        • tagImage
        • namemobile_tile_FPO.png
        • typeimage/png
        • size16560
        • uri/assets/1645.png
        • order0
        • created2019-08-27 14:00:42
        • modified2019-08-27 14:00:56
    • 3(array)
      • Location(array)
        • id5
        • parent_id8
        • brokerage_id21
        • typeExclusive
        • archived(false)
        • use_as_topic(true)
        • nameAgoura Hills
        • short_nameAH Town
        • group_index
        • latitude34.153339
        • longitude-118.761673
        • country_code
        • north0.000000
        • south0.000000
        • east0.000000
        • west0.000000
        • short_descriptionLorem ipsum dolor sit amet
        • long_descriptionLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
        • created2016-02-11 14:47:13
        • modified2016-04-18 11:36:41
        • timezoneAmerica/Los_Angeles
        • population5400000
        • uri/locations/view/5/agoura-hills
        • tile_nameAgoura Hills
      • Brokerage(array)
        • id21
        • account_executive_id0
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties12
        • max_homepage_featured_by_member_properties1
        • 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)
        • WOEID23417205
        • 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_id1
        • mlsidx_auto_import_minimum_price0
        • mlsidx_logo_url/img/logo-mls-listings.png
        • mlsidx_disclaimerBased on information from the MLSListings MLS) as of {{date}} (date the MLS data was obtained). All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
        • nameAbrams Coastal Properties
        • broker_of_record_name
        • short_nameAbrams Coastal Properties
        • usernamejloop
        • password6e83e74e5aad7dc2404b41f4dad53b857b4a34ae
        • 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
        • description<p>Abrams Coastal Properties is the exclusive representative for Leverage Global Partners in Balboa Island, Corona Del Mar, Newport Beach, and Newport Coast in California, USA.</p> <p>Abrams Coastal Properties has intimate knowledge of Coastal Orange County and is dedicated to giving unbeatable service to its clients seeking to buy or sell homes on Balboa Island, Newport Beach, Corona del Mar, Newport Coast, Costa Mesa, Laguna Beach and Irvine.</p> <p>The firm is located on Balboa Island where Broker Don Abrams has sold more than 50% of the homes since 1998. Abrams Coastal Properties is one of Orange County’s most successful independent brokerages. During the past 15 years, Don has been personally involved in about half of the total number of sale transactions on Balboa Island, as well as many transactions in the surrounding coastal areas served by the firm. Since 2003, Don has sold 50-70% of all homes on Balboa Island and has been one of the top 10 selling Realtors in Newport Beach. Don received the prestigious 2012 Realtor of the Year award from the Newport Beach Association of Realtors.</p> <p>In addition to selling homes, Abrams Coastal also manages and leases many vacation rental and yearly rental homes on Balboa Island and greater Newport Beach. We look forward to putting our clients and guests’ interests first and assisting all in finding the perfect coastal home!</p> <p> </p> <p> </p>
        • communitiesNewport Beach California CA USA Newport Coast California CA USA Corona del Mar California CA USA Balboa Island California CA USA
        • websitehttp://www.abramscoastalproperties.com/
        • address315 Marine Avenue
        • address_2
        • cityBalboa Island
        • stateCA
        • full_state
        • countryUSA
        • marketNewport Beach
        • market_2
        • postal_code92662
        • phone(949) 675-4822 x 14
        • phone_2(714) 325-9055
        • phone_3
        • wide_contact_image(false)
        • contact_nameDonald L. Abrams
        • contact_profile_link
        • contact_big_profile_linkhttp://www.leveragere.com/blog/meet-don-abrams-abrams-coastal-properties-newport-beach-california/
        • contact_big_profile_link_text
        • contact_titleBroker
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone562.283.6189
        • 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_2562.283.6190
        • contact_website
        • contact_name_2Jon Doe
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2Tester
        • 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_filename21.JPG
        • logo_filename21.png
        • contact_image_filename21.JPG
        • all_properties_link_image_filename21.png
        • all_properties_linkhttp://www.google.com
        • video_embed_code
        • contact_video_embed_code
        • meta_titleNewport Beach Real Estate | Abrams Coastal Properties | Leverage Global Partners
        • meta_descriptionAbrams Coastal Properties is the exclusive representative for Leverage Global Partners in Newport Beach, CA, USA.
        • meta_keywordsabrams coastal properties, newport beach real estate, don abrams, leverage global partners
        • login_message_counter3
        • stats_module_1_typeagents
        • stats_module_1_value99
        • stats_module_2_typeyears_in_service
        • stats_module_2_value36
        • stats_module_3_typelistings
        • stats_module_3_value6000
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-04-12 18:09:00
        • modified2023-11-30 23:38:03
        • country_id1
        • dre_num012345
        • uri/brokerage-detail/21/abrams-coastal-properties
        • website_shortwww.abramscoastalproperties.com
        • name_with_locationAbrams Coastal Properties
        • mlsidx_id_array(array)
          • 01
      • Image(array)
        • id726
        • modelLocation
        • model_id5
        • tagImage
        • nameAgouravista.jpg
        • typeimage/jpeg
        • size3518147
        • uri/assets/726.jpg
        • order0
        • created2016-03-01 11:43:14
        • modified2016-04-18 11:36:41
  • location_properties(empty)
  • main_article(empty)
  • brokerage(array)
    • Brokerage(array)
      • id100
      • account_executive_id0
      • 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)
      • WOEID(null)
      • 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_auto_import_minimum_price0
      • mlsidx_logo_url
      • mlsidx_disclaimer
      • nameFusilier Realty Group
      • broker_of_record_name
      • short_nameFusilier Realty Group
      • username
      • password
      • password_reset_hash
      • monthly_invoice_amount0.00
      • monthly_invoice_start_date(null)
      • monthly_invoice_end_date(null)
      • contract_filename
      • active(true)
      • lead_inFusilier Realty Group is the exclusive representative for Leverage Global Partners in Orlando, Florida, USA.
      • short_description
      • description<p>Fusilier Realty Group is located in the premiere Lake Nona area, home of Orlando's Medical City. Our agents have years of expertise in the South East Orlando and Saint Cloud region and are active members of the Local, State, and National Real Estate Association. Our dynamic, progressive, and savvy sales team is dedicated to fulfilling every client's needs. Our agency was founded on the belief that selling real estate can be an exciting and enjoyable experience for both buyer and seller.”</p> <p> </p> <p><strong>Lake Nona Office</strong></p> <p>9145 Narcoosee Rd, Ste. 102</p> <p>Orlando, FL 32827</p> <p>407-281-8455</p> <p> </p> <p><strong>Harmony Office</strong></p> <p>7272 Harmony Square Dr,</p> <p>Harmony, FL 34773</p> <p>407-259-2394</p> <p> </p> <p> </p>
      • communitiesorlando
      • websitehttp://www.realtygroupfl.com/
      • address9145 Narcoossee Road
      • address_2Suite 102
      • cityOrlando
      • stateFL
      • full_stateFlorida
      • countryUSA
      • market
      • market_2
      • postal_code32827
      • phoneOffice: (407) 281-8455
      • phone_2Fax: (407) 218-7422
      • phone_3
      • wide_contact_image(false)
      • contact_nameSteve Fusilier and Keith Race
      • contact_profile_link
      • contact_big_profile_link
      • contact_big_profile_link_text
      • contact_titleBrokers-in-Charge
      • 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_filename
      • logo_filename
      • contact_image_filename
      • all_properties_link_image_filename
      • all_properties_link
      • video_embed_code
      • contact_video_embed_code
      • meta_title
      • meta_description
      • meta_keywords
      • 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(false)
      • created2019-08-20 16:11:48
      • modified2019-08-20 16:11:48
      • country_id0
      • dre_num012345
      • uri/brokerage-detail/100/fusilier-realty-group
      • website_shortwww.realtygroupfl.com
      • name_with_locationFusilier Realty Group - Orlando, FL, USA
    • AccountExecutive(array)
      • id(null)
      • type(null)
      • brokerage_id(null)
      • email(null)
      • password(null)
      • recover_hash(null)
      • first_name(null)
      • last_name(null)
      • title(null)
      • dre_num(null)
      • phone(null)
      • max_luxury_feed_properties(null)
      • headshot_filename(null)
      • bio(null)
      • brokerage_name_override(null)
      • stripe_customer_id(null)
      • digital_ad_first_free_month_coupon(null)
      • modified(null)
      • created(null)
      • notified(null)
      • full_name(null)
      • profile_complete(false)
    • Logo(array)
      • id1631
      • modelBrokerage
      • model_id100
      • tagLogo
      • nameA_BIG_IMAGE.jpg
      • typeimage/jpeg
      • size11987
      • uri/assets/1631.jpg
      • order0
      • created2019-08-20 16:11:46
      • modified2019-08-20 16:11:48
    • MainImage(array)
      • id1630
      • modelBrokerage
      • model_id100
      • tagMainImage
      • nameA_BIG_IMAGE.jpg
      • typeimage/jpeg
      • size11987
      • uri/assets/1630.jpg
      • order0
      • created2019-08-20 16:11:42
      • modified2019-08-20 16:11:48
    • ContactImage(array)
      • id(null)
      • model(null)
      • model_id(null)
      • tag(null)
      • name(null)
      • type(null)
      • size(null)
      • uri(null)
      • order(null)
      • created(null)
      • modified(null)
    • ContactImage2(array)
      • id(null)
      • model(null)
      • model_id(null)
      • tag(null)
      • name(null)
      • type(null)
      • size(null)
      • uri(null)
      • order(null)
      • created(null)
      • modified(null)
    • ContactImage3(array)
      • id(null)
      • model(null)
      • model_id(null)
      • tag(null)
      • name(null)
      • type(null)
      • size(null)
      • uri(null)
      • order(null)
      • created(null)
      • modified(null)
    • BrokerOfRecordLogo(array)
      • id(null)
      • model(null)
      • model_id(null)
      • tag(null)
      • name(null)
      • type(null)
      • size(null)
      • uri(null)
      • order(null)
      • created(null)
      • modified(null)
    • MainArticle(array)
      • id(null)
      • model(null)
      • model_id(null)
      • archived(null)
      • medium_featured(null)
      • large_featured(null)
      • title(null)
      • author(null)
      • date(null)
      • lead_in(null)
      • body(null)
      • vimeo_id(null)
      • created(null)
      • modified(null)
    • FeaturedImage(empty)
    • Location(array)
      • 0(array)
        • id16
        • parent_id15
        • brokerage_id100
        • typeExclusive
        • archived(false)
        • use_as_topic(false)
        • nameOrlando, FL, USA
        • short_nameOrlando, FL, USA
        • group_index
        • latitude28.497662
        • longitude-81.342773
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • short_description
        • long_description
        • created2019-08-20 16:04:26
        • modified2019-08-20 16:14:30
        • timezone
        • population0
        • uri/locations/view/16/orlando-fl-usa
        • tile_nameOrlando, FL, USA
    • User(empty)
  • location(array)
    • Location(array)
      • id16
      • parent_id15
      • brokerage_id100
      • typeExclusive
      • archived(false)
      • use_as_topic(false)
      • nameOrlando, FL, USA
      • short_nameOrlando, FL, USA
      • group_index
      • latitude28.497662
      • longitude-81.342773
      • country_code
      • north53.700001
      • south19.700001
      • east-52.599998
      • west-146.600006
      • short_description
      • long_description
      • created2019-08-20 16:04:26
      • modified2019-08-20 16:14:30
      • timezone
      • population0
      • uri/locations/view/16/orlando-fl-usa
      • tile_nameOrlando, FL, USA
    • Image(array)
      • id1628
      • modelLocation
      • model_id16
      • tagImage
      • namemobile_tile_FPO.png
      • typeimage/png
      • size16560
      • uri/assets/1628.png
      • order0
      • created2019-08-20 16:04:24
      • modified2019-08-20 16:14:30
  • 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
    • 7Flash
    • 8HtmlToolbar
    • 9Html
    • 10Form

  ====
• Environment
  +

  App Constants

  Constant	Value
  CONFIG	/var/www/vhosts/leveragere.com/subdomains/dev2/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	dev2
  WEB_BASE_URL	https://dev2.leveragere.com
  PROP_EMAIL_RECIPIENT	[email protected]
  STRIPE_ISSUES_EMAIL_RECIPIENT	[email protected]
  MEMBER_HELP_EMAIL_RECIPIENT	[email protected]
  FEED_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/dev2/httpdocs/app/Console/cake.php

  CakePHP Constants

  Constant	Value
  APP	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/
  APP_DIR	app
  APPLIBS	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/Lib/
  CACHE	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/tmp/cache/
  CAKE	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/lib/Cake/
  CAKE_CORE_INCLUDE_PATH	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/lib
  CORE_PATH	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/lib/
  CAKE_VERSION	2.10.19
  CSS	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/webroot/css/
  CSS_URL	css/
  DS	/
  FULL_BASE_URL	https://dev2.leveragere.com
  IMAGES	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/webroot/img/
  IMAGES_URL	img/
  JS	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/webroot/js/
  JS_URL	js/
  LOGS	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/tmp/logs/
  ROOT	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs
  TESTS	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/Test/
  TMP	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/tmp/
  VENDORS	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/vendors/
  WEBROOT_DIR	webroot
  WWW_ROOT	/var/www/vhosts/leveragere.com/subdomains/dev2/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/16/orlando-fl-usa
  Query String
  Request Method	GET
  Server Protocol	HTTP/1.1
  Gateway Interface	CGI/1.1
  Redirect Url	/locations/view/16/orlando-fl-usa
  Remote Port	16543
  Script Filename	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/webroot/index.php
  Server Admin	root@localhost
  Context Document Root	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/webroot
  Context Prefix
  Request Scheme	https
  Document Root	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/webroot
  Remote Addr	104.23.197.221
  Server Port	443
  Server Addr	172.24.32.44
  Server Name	dev2.leveragere.com
  Server Software	Apache
  Server Signature
  Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
  Http Host	dev2.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.217.63
  Http Cdn Loop	cloudflare; loops=1
  Http Cf Ray	a0730c9b0b7ccc36-CMH
  Http Accept Encoding	gzip, br
  Http Cookie	CAKEPHP=0dpdq41884rolu8nrgbtbmnkoa
  Http Accept	*/*
  Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
  Http X Forwarded For	216.73.217.63
  Proxy-nokeepalive	1
  Ssl Tls Sni	dev2.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	aiNfhJ6KG2zmvSDhGn67WwAAABQ
  Redirect Status	200
  Redirect Ssl Tls Sni	dev2.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	aiNfhJ6KG2zmvSDhGn67WwAAABQ
  Fcgi Role	RESPONDER
  Php Self	/index.php
  Request Time Float	1780703108.3522
  Request Time	1780703108

  ====
• Include
  +

  Included Files

  Include Paths

  • 0/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/lib
  • 2/opt/plesk/php/7.4/share/pear
  • 3-> /var/www/vhosts/leveragere.com/subdomains/dev2/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

  ====