Locations / San Antonio, TX, USA

San Antonio, TX, USA

San Antonio is located in the heart of the Texas Hill Country, and is Texas’ most affordable major metropolitan city. Known as “big city with a small town feel” it is a blend of charm and sophistication. San Antonio boasts the top tourist attractions in Texas: the Alamo and the Riverwalk. The city is home to the San Antonio Spurs, great shopping, fine dining, museums, and, it’s a short drive to the beautiful Hill Country. With good schools, a variety of housing styles, and short commute times, San Antonio is a great place to live. Discover San Antonio, there is something for everyone.

Location Represented By

License #: 012345

11:41pm local time
1.4 million population

Partner Search

Find partners with a map-based search

Related Locations

Related Partners

Recent Property Listings

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

Array
(
)

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

Cake Params
- plugin(null)
- controllerlocations
- actionview
- named(empty)
- pass(array)
  0135
  1san-antonio-tx-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: 19 ms
Total Queries: 19 queries

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

Query Explain:

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

====

Timer

Memory

Peak Memory Use 13.50 MB

Message	Memory use
Component initialization	2.88 MB
Controller action start	3.81 MB
Controller render start	6.67 MB
View render complete	7.22 MB

Timers

Total Request Time: 1810 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	1632.23
Event: Controller.initialize	3.88
Event: Controller.startup	1.15
Controller action	46.98
Event: Controller.beforeRender	12.24
» Processing toolbar data	12.14
Rendering View	85.44
» Event: View.beforeRender	0.27
» Rendering APP/View/Locations/view.ctp	2.64
» » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.14
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.17
» » Rendering APP/View/Elements/sidebar/brokerage_list.ctp	0.18
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.26
» » » Rendering APP/View/Elements/static_property_price.ctp	0.36
» » » Rendering APP/View/Elements/static_property_price.ctp #2	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
» » 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.81
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)
 id3703
 brokerage_id95
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id1223
 agent_2_id0
 agent_3_id0
 nameBeautiful Colonial in Legacy Woods
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionBeautiful Colonial in sought after neighborhood, Gourmet kitchen, Huge master bed room with master bath,finished basement great for entertaining. Gorgeous inground pool with outdoor hot tub and beautiful stone patio. A must see!!
 address15 Shadowbrook Crossing
 address_2
 cityEast Greenwich
 stateRI
 postal_code02818
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1300000
 price_20
 price_usd1300000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms3
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1pool
 icon_2media-room
 icon_3garage
 icon_4
 icon_5
 icon_6
 website
 meta_titleBeautiful Colonial in Legacy Woods | East Greenwich Real Estate | Coleman Realtors
 meta_description15 Shadowbrook Crossing is a property offered for sale in East Greenwich, RI, USA, presented by Coleman Realtors
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built2004
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num1118980
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style10
 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
 latitude41.648308
 longitude-71.524071
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2016-04-06 07:17:36
 uri/property-detail/3703/15-shadowbrook-crossing-east-greenwich-ri-02818-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3703/15-shadowbrook-crossing-east-greenwich-ri-02818-usa
 address_concat15 Shadowbrook Crossing East Greenwich RI 02818 USA
 google_maps_query_string15+Shadowbrook+Crossing++East+Greenwich+RI+02818+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 1,300,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty4
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2016-04-06
 overridden_brokerage_nameColeman Realtors
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id95
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2477058
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameColeman Realtors
 broker_of_record_name
 short_nameColeman Realtors
 usernameColemanRealtors
 passwordc19a88afe4dbd7329004555ea008b2340aa6342b
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill. Local knowledge, world-class expertise. Rhode Islanders pride themselves on their independence. So do we: we're an independent, third-generation residential real estate company, not a franchise. That means we're totally focused on you and your needs. We've helped thousands of clients buy, sell, and rent since we opened our doors in 1929. Today our clients rely on our team of over 100 experienced professionals for our local knowledge and expertise: we know the neighborhoods, the towns and the people. With offices in Barrington, East Greenwich, Providence and Watch Hill, we're nearby too. So no matter your challenge, we'll bring you a wealth of experience, ideas and relationships - all geared toward producing results.
 communitiesBarrington, RI Providence, RI Watch Hill, RI Newport, RI Jamestown, RI Bristol, RI Charlestown, RI Narragansett, RI South Kingstown, RI East Greenwich, RI
 websitehttp://www.colemanrealtors.com/
 address135 Elmgrove Avenue
 address_2
 cityProvidence
 stateRI
 full_stateRhode Island
 countryUSA
 marketProvidence
 market_2
 postal_code02906
 phoneDavid Coleman: (401) 245-3050
 phone_2Michael Young: (401) 274-3636
 phone_3
 wide_contact_image(false)
 contact_nameDavid Coleman & Michael Young
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCo-Owners
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Providence real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename95.jpg
 logo_filename95.png
 contact_image_filename95.jpg
 all_properties_link_image_filename95.jpg
 all_properties_linkhttp://www.colemanrealtors.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleProvidence Real Estate | Coleman Realtors | Leverage Global Partners
 meta_descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Providence, Rhode Island, USA.
 meta_keywordsColeman Realtors, Providence Real Estate, Leverage Global Partners, Providence Rhode Island Real Estate, Barrington Real Estate, East Greenwich Real Estate, Providence Real Estate, Watch Hill Real Estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-02-11 18:09:34
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/95/coleman-realtors
 website_shortwww.colemanrealtors.com
 name_with_locationColeman Realtors
 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)
 id8805
 modelProperty
 model_id3703
 tagImage
 name36006.jpg
 typeimage/jpg
 size3406385
 uri/assets/8805.jpg
 order0
 created2016-04-07 16:11:05
 modified2016-04-07 16:11:05
 1(array)
 id8802
 modelProperty
 model_id3703
 tagImage
 name35998.jpg
 typeimage/jpg
 size1515170
 uri/assets/8802.jpg
 order1
 created2016-04-07 16:11:04
 modified2016-04-07 16:11:04
 2(array)
 id8801
 modelProperty
 model_id3703
 tagImage
 name35999.jpg
 typeimage/jpg
 size1752454
 uri/assets/8801.jpg
 order2
 created2016-04-07 16:11:04
 modified2016-04-07 16:11:04
 3(array)
 id8800
 modelProperty
 model_id3703
 tagImage
 name36000.jpg
 typeimage/jpg
 size1477593
 uri/assets/8800.jpg
 order3
 created2016-04-07 16:11:04
 modified2016-04-07 16:11:04
 4(array)
 id8799
 modelProperty
 model_id3703
 tagImage
 name36001.jpg
 typeimage/jpg
 size1673188
 uri/assets/8799.jpg
 order4
 created2016-04-07 16:11:04
 modified2016-04-07 16:11:04
 5(array)
 id8798
 modelProperty
 model_id3703
 tagImage
 name36002.jpg
 typeimage/jpg
 size1470683
 uri/assets/8798.jpg
 order5
 created2016-04-07 16:11:03
 modified2016-04-07 16:11:04
 6(array)
 id8797
 modelProperty
 model_id3703
 tagImage
 name36003.jpg
 typeimage/jpg
 size1828645
 uri/assets/8797.jpg
 order6
 created2016-04-07 16:11:03
 modified2016-04-07 16:11:03
 7(array)
 id8803
 modelProperty
 model_id3703
 tagImage
 name36004.jpg
 typeimage/jpg
 size1765406
 uri/assets/8803.jpg
 order7
 created2016-04-07 16:11:04
 modified2016-04-07 16:11:04
 8(array)
 id8804
 modelProperty
 model_id3703
 tagImage
 name36005.jpg
 typeimage/jpg
 size3513723
 uri/assets/8804.jpg
 order8
 created2016-04-07 16:11:04
 modified2016-04-07 16:11:04
 9(array)
 id8806
 modelProperty
 model_id3703
 tagImage
 name36007.jpg
 typeimage/jpg
 size3107628
 uri/assets/8806.jpg
 order9
 created2016-04-07 16:11:05
 modified2016-04-07 16:11:06
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id1418
 property_id3703
 property_feature_id12
 1(array)
 id8
 nameMedia Room
 additional(false)
 created2016-04-07 14:03:04
 modified2016-04-07 14:03:04
 PropertiesPropertyFeature(array)
 id1419
 property_id3703
 property_feature_id8
 2(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id1420
 property_id3703
 property_feature_id4
 Topic(empty)
 1(array)
 Property(array)
 id3714
 brokerage_id76
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id783
 agent_2_id0
 agent_3_id0
 nameCozy Cabin Mountain Get-Away
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionCozy cabin with a great big panoramic view. Enjoy this view on the spacious deck or from the wall of windows in the living room. Open beamed ceilings, knotty pine through out. Bedrooms are on the lower level. Full bath is on the main. Level parking and entry. Lake Gregory, the park and Crestline village are only a couple minuets away by car. Hurry! Don’t miss out on this cabin in the mountains and all the summer fun you can have! - See more at: http://www.therealestateplace.com/property/cozy-cabin-with-a-giant-view/#sthash.ZnUX3nkP.dpuf
 address340 Donner Dr
 address_2
 cityLake Arrowhead
 stateCA
 postal_code92352
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price175000
 price_20
 price_usd175000
 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
 bathrooms1
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1views
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://www.therealestateplace.com/property/cozy-cabin-with-a-giant-view/
 meta_titleCozy Cabin Mountain Get-Away | Lake Arrowhead Real Estate | Prime Properties
 meta_description340 Donner Dr is a property offered for sale in Lake Arrowhead, CA, USA, presented by Prime Properties
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://www.tourfactory.com/1523656
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, year_built, video_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(true)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-04-07 11:14:42
 uri/property-detail/3714/340-donner-dr-lake-arrowhead-ca-92352-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3714/340-donner-dr-lake-arrowhead-ca-92352-usa
 address_concat340 Donner Dr Lake Arrowhead CA 92352 USA
 google_maps_query_string340+Donner+Dr++Lake+Arrowhead+CA+92352+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 175,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty2
 bathrooms_pretty1
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms1
 date_listed2016-04-07
 overridden_brokerage_namePrime Properties
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id76
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2434729
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePrime Properties
 broker_of_record_name
 short_namePrime Properties
 usernamePrimeProperties
 password4b7dee5c791770c42ce3df75d5b8fb072b481b38
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPrime Properties is the exclusive representative for Leverage Global Partners in Lake Arrowhead, California, USA. “Different isn’t always better, but better is always different,” has been founder, and president, Jeff Perlis’ motto for providing outstanding service to his clients for almost 25 years. Jeff created Prime Properties as a boutique real estate company that provides Nordstrom-quality customer service to its clients. The Prime Properties Team purposes to continually show community support. Such support can be exemplified by their sweeping transformation of its current office location. The office’s strategic location, houses the Arrowhead Welcome Center, Jeff’s vision for providing a warm and inviting first-stop for Lake Arrowhead visitors and clients. The Prime Properties Team includes, Arrowhead Rental Agency, the full-time rental department. Lake Arrowhead is a four season resort community centered around the uniqueness of a private lake. Located in an altitude of 5,100 feet, Lake Arrowhead has been described as the “Jewel of Southern California,” known as “Little Switzerland.” Close to local ski resorts and National Forest trails, Lake Arrowhead is less than a two-hour drive from Los Angeles, San Diego, or Palm Springs.
 communitieslake arrowhead
 websitehttp://www.therealestateplace.com/
 address26816 Highway 189
 address_2
 cityLake Arrowhead
 stateCA
 full_stateCalifornia
 countryUSA
 marketLake Arrowhead
 market_2
 postal_code92352
 phone(909) 337-7653
 phone_2(909) 224-5631
 phone_3
 wide_contact_image(false)
 contact_nameJeff Perlis
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner/Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_websitehttp://www.JeffPerlis.com
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename76.jpg
 logo_filename76.jpg
 contact_image_filename76.jpg
 all_properties_link_image_filename76.jpg
 all_properties_linkhttp://www.therealestateplace.com/properties
 video_embed_code
 contact_video_embed_code
 meta_titleLake Arrowhead Real Estate | Prime Properties | Leverage Global Partners
 meta_descriptionPrime Properties is the exclusive representative for Leverage Global Partners in Lake Arrowhead, California, USA.
 meta_keywordsLake Arrowhead Real Estate, Prime Properties, Leverage Global Partners, Jeff Perlis
 login_message_counter2
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-12-09 16:21:37
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/76/prime-properties
 website_shortwww.therealestateplace.com
 name_with_locationPrime Properties
 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)
 id20576
 modelProperty
 model_id3714
 tagImage
 name36057.jpg
 typeimage/jpg
 size4491599
 uri/assets/20576.jpg
 order2895
 created2016-04-07 17:34:23
 modified2016-04-07 17:34:23
 1(array)
 id20577
 modelProperty
 model_id3714
 tagImage
 name36058.jpg
 typeimage/jpg
 size3978667
 uri/assets/20577.jpg
 order2896
 created2016-04-07 17:34:25
 modified2016-04-07 17:34:25
 2(array)
 id20578
 modelProperty
 model_id3714
 tagImage
 name36059.jpg
 typeimage/jpg
 size2333726
 uri/assets/20578.jpg
 order2897
 created2016-04-07 17:34:26
 modified2016-04-07 17:34:26
 3(array)
 id20579
 modelProperty
 model_id3714
 tagImage
 name36060.jpg
 typeimage/jpg
 size2771257
 uri/assets/20579.jpg
 order2898
 created2016-04-07 17:34:28
 modified2016-04-07 17:34:28
 4(array)
 id20580
 modelProperty
 model_id3714
 tagImage
 name36061.jpg
 typeimage/jpg
 size3063397
 uri/assets/20580.jpg
 order2899
 created2016-04-07 17:34:30
 modified2016-04-07 17:34:30
 5(array)
 id20581
 modelProperty
 model_id3714
 tagImage
 name36062.jpg
 typeimage/jpg
 size3961632
 uri/assets/20581.jpg
 order2900
 created2016-04-07 17:34:31
 modified2016-04-07 17:34:31
 6(array)
 id20582
 modelProperty
 model_id3714
 tagImage
 name36063.jpg
 typeimage/jpg
 size3586973
 uri/assets/20582.jpg
 order2901
 created2016-04-07 17:34:33
 modified2016-04-07 17:34:33
 7(array)
 id20583
 modelProperty
 model_id3714
 tagImage
 name36064.jpg
 typeimage/jpg
 size4205847
 uri/assets/20583.jpg
 order2902
 created2016-04-07 17:34:34
 modified2016-04-07 17:34:34
 8(array)
 id20584
 modelProperty
 model_id3714
 tagImage
 name36065.jpg
 typeimage/jpg
 size4187920
 uri/assets/20584.jpg
 order2903
 created2016-04-07 17:34:36
 modified2016-04-07 17:34:36
 9(array)
 id20585
 modelProperty
 model_id3714
 tagImage
 name36066.jpg
 typeimage/jpg
 size5185756
 uri/assets/20585.jpg
 order2904
 created2016-04-07 17:34:37
 modified2016-04-07 17:34:37
 User(array)
 0(array)
 id975
 typeAgent
 brokerage_id76
 email[email protected]
 passwordc6c6dec5d7e005197be3010c5570953a73f47b96
 recover_hash
 first_nameKerry
 last_nameJenkins
 title
 dre_num
 phone909-553-7087
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:46
 created2017-08-07 15:23:46
 notified(false)
 full_nameKerry Jenkins
 uri/agent-detail/975/kerry-jenkins
 profile_complete(true)
 UsersProperty(array)
 id732
 user_id975
 property_id3714
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id4355
 property_id3714
 property_feature_id14
 Topic(empty)
 2(array)
 Property(array)
 id3739
 brokerage_id1
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameElegant, Contemporary Oasis Overlooking Pacific Ocean
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(false)
 descriptionWelcome to an oasis over looking the Pacific Ocean, where crashing waves and vivid sunsets create the quintessential beach living environment. The controlled access exterior entry sets the tone for the elegance and sophistication that awaits you upon entering the residence. Built with style and taste, this contemporary villa offers great scale for avid art collectors and a casual, "kick your shoes off" environment to simply relax and enjoy the success you've created. Beyond the elegant main living room and entertainment spaces, prepare for the explosive, head on ocean views that beckon beyond banks of oversized French doors. The grand deck with fire pit, spa tub and dedicated access to the sand below creates one of the finest locations to enjoy one of nature's true wonders. The master suite is ideally situated to take in the majestic views and with an oversized bath and large en-suite closet; you'll realize that the layout has been carefully thought out.
 address31652 Broad Beach Road
 address_2
 cityMalibu
 stateCA
 postal_code90265
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price5800000
 price_20
 price_usd5800000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms3
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet3563
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://31652broadbeachroad1.thepartnerstrust.com/
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1994
 virtual_tour
 video_tourhttp://www.onvedeo.com/properties/762171/embed
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num16114818
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style17
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude34.036472
 longitude-118.864647
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 09:11:09
 created2016-04-18 09:07:21
 uri/property-detail/3739/31652-broad-beach-road-malibu-ca-90265-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3739/31652-broad-beach-road-malibu-ca-90265-usa
 address_concat31652 Broad Beach Road Malibu CA 90265 USA
 google_maps_query_string31652+Broad+Beach+Road++Malibu+CA+90265+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 5,800,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty3
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-04-18
 overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id1
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties12
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties1
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id1
 WOEID2363796
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePartners Trust Real Estate Brokerage and Acquisitions
 broker_of_record_name
 short_namePartners Trust Real Estate
 usernamePartnersTrustBH
 password2a77eb13ee7deac93b310ba1431a4982bfdbddeb
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 description<h2> </h2> Partners Trust is the exclusive representative for Leverage Global Partners in Beverly Hills, California, USA. We are dedicated to being the finest real estate brokerage in Los Angeles. At Partners Trust, our objective is to present our clients with the most professional, successful and ethical real estate associates in the business and to represent our clients with care, confidentiality and the utmost attention to service. We believe we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market. We begin with a commodity that is hard-earned and easily lost: TRUST. Without the daily demonstration and commitment to uphold principles, a company’s mission statement is simply words on a page and nothing more. Partners Trust has adopted a mission statement that each Associate and staff member must sign to in order to participate with the Company, which articulates the core philosophy and culture of the Company. The Partners Trust founders utilized their extensive experience and resources to create a Company that is both unique and beneficial for those willing to commit to the rigorous standards that have been set forth. The Company’s intention is to empower each member of its sales force each and every step of the way. Partners Trust has additional office locations in <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/5/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Pasadena</a>, <a href="../../../brokerage-detail/142/Partners-Trust" target="_blank">Malibu</a> and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a>
 communitiesBeverly Hills Bel Air Century City Westwood West Hollywood
 websitehttp://thepartnerstrust.com
 address9378 Wilshire Boulevard
 address_2Suite 200
 cityBeverly Hills
 stateCA
 full_stateCalifornia
 countryUSA
 marketBeverly Hills
 market_2
 postal_code90212
 phone(310) 500-1388
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameNick Segal
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/presidential-profile-partners-trust-real-estate-brokerage-aquisitions-nick-segal/
 contact_big_profile_link_text
 contact_titlePresident/Co-Founder
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename1.jpg
 logo_filename1.png
 contact_image_filename1.jpg
 all_properties_link_image_filename1.jpg
 all_properties_linkhttp://www.thepartnerstrust.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleBeverly Hills Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
 meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions is an award-winning real estate brokerage representing Leverage Global Partners in Beverly Hills, CA, USA.
 meta_keywordspartners trust, partners trust real estate, beverly hills real estate, beverly hills real estate agents, leverage global partners
 login_message_counter2
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-02-21 13:57:13
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/1/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortthepartnerstrust.com
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id20944
 modelProperty
 model_id3739
 tagImage
 name31652broadbeach-high-1.jpg.jpg
 typeimage/jpeg
 size308963
 uri/assets/20944.jpg
 order0
 created2016-04-18 09:06:27
 modified2016-04-18 09:07:21
 1(array)
 id20943
 modelProperty
 model_id3739
 tagImage
 name31652broadbeach-high-9.jpg.jpg
 typeimage/jpeg
 size193413
 uri/assets/20943.jpg
 order1
 created2016-04-18 09:06:27
 modified2016-04-18 09:07:21
 2(array)
 id20945
 modelProperty
 model_id3739
 tagImage
 name7.jpg
 typeimage/jpeg
 size281415
 uri/assets/20945.jpg
 order2
 created2016-04-18 09:06:27
 modified2016-04-18 09:07:21
 3(array)
 id20946
 modelProperty
 model_id3739
 tagImage
 name8.jpg
 typeimage/jpeg
 size1609822
 uri/assets/20946.jpg
 order3
 created2016-04-18 09:06:29
 modified2016-04-18 09:07:21
 4(array)
 id20948
 modelProperty
 model_id3739
 tagImage
 name14.jpg
 typeimage/jpeg
 size3136334
 uri/assets/20948.jpg
 order4
 created2016-04-18 09:06:32
 modified2016-04-18 09:07:21
 5(array)
 id20949
 modelProperty
 model_id3739
 tagImage
 name-.jpg
 typeimage/jpeg
 size3188234
 uri/assets/20949.jpg
 order5
 created2016-04-18 09:06:34
 modified2016-04-18 09:07:21
 6(array)
 id20950
 modelProperty
 model_id3739
 tagImage
 name16.jpg
 typeimage/jpeg
 size3828702
 uri/assets/20950.jpg
 order6
 created2016-04-18 09:06:35
 modified2016-04-18 09:07:21
 7(array)
 id20951
 modelProperty
 model_id3739
 tagImage
 name- 3.jpg
 typeimage/jpeg
 size3057167
 uri/assets/20951.jpg
 order7
 created2016-04-18 09:06:36
 modified2016-04-18 09:07:21
 8(array)
 id20947
 modelProperty
 model_id3739
 tagImage
 nameDining Room_Broad Beach.jpg
 typeimage/jpeg
 size2836493
 uri/assets/20947.jpg
 order8
 created2016-04-18 09:06:31
 modified2016-04-18 09:07:21
 9(array)
 id20952
 modelProperty
 model_id3739
 tagImage
 nameOcean View _Broad Beach.jpg
 typeimage/jpeg
 size3363440
 uri/assets/20952.jpg
 order9
 created2016-04-18 09:06:37
 modified2016-04-18 09:07:21
 User(array)
 0(array)
 id299
 typeAgent
 brokerage_id1
 email[email protected]
 password5752832063d4fe000ce359059ea51ec8c2330095
 recover_hash
 first_nameFelecia
 last_nameWesley
 title
 dre_num
 phone310.500.1383
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:41
 created2017-08-07 15:22:41
 notified(false)
 full_nameFelecia Wesley
 uri/agent-detail/299/felecia-wesley
 profile_complete(true)
 UsersProperty(array)
 id74
 user_id299
 property_id3739
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id4409
 property_id3739
 property_feature_id1
 1(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id4410
 property_id3739
 property_feature_id14
 Topic(array)
 0(array)
 id1
 nameArts & Culture
 created2016-02-25 11:25:00
 modified2016-02-25 11:29:58
 tile_nameArts & Culture
 PropertiesTopic(array)
 id41
 property_id3739
 topic_id1
 1(array)
 id8
 nameBeach
 created2016-02-25 11:25:00
 modified2016-02-25 11:30:26
 tile_nameBeach
 PropertiesTopic(array)
 id42
 property_id3739
 topic_id8
 3(array)
 Property(array)
 id3756
 brokerage_id244
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameHistoric landmark estate in Langham area of Pasadena
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(true)
 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)
 descriptionDesigned by well known Arts and Crafts movement architects Arthur and Alfred Heineman. In addition to the main house there is a 1,000 sq ft guest house and a 1,476 sq ft finished basement. This home is under The Mills Act which offers reduced property tax.
 address1330 Hillcrest Avenue
 address_2
 cityPasadena
 stateCA
 postal_code91106
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price6500000
 price_20
 price_usd6500000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms0
 bedrooms_20
 bathrooms0
 bathrooms_20
 no_beds_baths(false)
 square_feet10764
 square_meters
 acres0.459137
 interior_unitsq_m
 interior_size1000
 lot_unitsq_ft
 lot_size20000
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude34.124477
 longitude-118.131401
 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)
 modified2021-10-20 14:10:15
 created2019-10-31 00:14:48
 uri/property-detail/3756/1330-hillcrest-avenue-pasadena-ca-91106-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3756/1330-hillcrest-avenue-pasadena-ca-91106-usa
 address_concat1330 Hillcrest Avenue Pasadena CA 91106 USA
 google_maps_query_string1330+Hillcrest+Avenue++Pasadena+CA+91106+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 6,500,000
 interior_unit_prettySq. M.
 lot_unit_prettySq. Ft.
 bedrooms_pretty0
 bathrooms_pretty0
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms0
 date_listed2019-10-31
 overridden_brokerage_nameSmith & Berg
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id244
 account_executive_id0
 archived(false)
 typeteam
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties10
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID(null)
 timezoneAmerica/Los_Angeles
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameSmith & Berg
 broker_of_record_nameCompass
 short_nameSmith & Berg
 username
 password
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_inYou've tried the rest, now try the best
 short_description
 descriptionLorem ipsum dolor sit amet, consectetur adipiscing elit. Sed et est ut dui hendrerit auctor sit amet ut lorem. Proin eleifend tristique felis. Curabitur bibendum enim mauris, nec volutpat lectus aliquam a. Vestibulum laoreet tellus ac porta consectetur. Quisque quam tellus, tempus vel sollicitudin id, convallis ut erat. Nullam laoreet aliquet sapien non porttitor. Curabitur eu commodo quam, in pellentesque nibh. Etiam non dolor fermentum velit commodo feugiat a ut augue. Sed faucibus tincidunt vestibulum. Pellentesque tincidunt sed lorem at efficitur. Suspendisse maximus arcu eget fermentum pharetra. Praesent dapibus justo sit amet vestibulum molestie. Nullam eu faucibus nisi, sed lacinia eros. Quisque finibus nec ante eu scelerisque. In hac habitasse platea dictumst. Nam turpis augue, ornare sed odio a, placerat vestibulum augue. Curabitur posuere turpis sed nisl tempus, id feugiat ipsum dictum. Praesent venenatis pharetra nunc at tincidunt. Ut sollicitudin quam sit amet tortor molestie, at bibendum diam cursus. Cras ac metus vitae sapien condimentum consequat sit amet eget metus. Vestibulum et venenatis purus. Donec tincidunt pharetra ex quis tempor. Vivamus non sapien eget elit auctor ultrices at eget turpis. Nulla volutpat ut nibh eget placerat.
 communitiesLos Angeles
 websitehttps://compass.com
 address680 E. Colorado Blvd
 address_2Suite 150
 cityPasadena
 stateCA
 full_stateCalifornia
 countryUSA
 market
 market_2
 postal_code91101
 phone8888888888
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameF. Ron Smith
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal
 contact_dre_num11624555
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone565-135-7745
 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_2878-829-1672
 contact_website
 contact_name_2Chris Stephonovich
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2Associate Realtor
 contact_dre_num_241768321
 contact_email_3[email protected]
 contact_name_3Courtney P. Wolpertinger
 contact_title_3Associate Realtor
 contact_dre_num_384919983
 contact_phone_3158-646-8246
 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-10-31 00:07:13
 modified2021-07-18 10:40:16
 dre_num012345
 uri/team-detail/244/smith-berg
 website_shortcompass.com
 name_with_locationSmith & Berg
 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)
 id23089
 modelProperty
 model_id3756
 tagImage
 name8d7f54a999bc95b7b618e15d75d5f37072fe28cd.jpeg
 typeimage/jpeg
 size460522
 uri/assets/23089.jpeg
 order0
 created2019-10-31 00:14:45
 modified2021-10-20 14:10:05
 User(array)
 0(array)
 id1286
 typeAgent
 brokerage_id244
 email[email protected]
 passwordb04bb448b10ef979db88d5bbb12f5dca893bbf65
 recover_hash
 first_nameSmithberg
 last_nameTester
 title
 dre_num123654
 phone8888888888
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2020-06-09 13:36:25
 created2020-06-09 13:36:25
 notified(false)
 full_nameSmithberg Tester
 uri/agent-detail/1286/smithberg-tester
 profile_complete(true)
 UsersProperty(array)
 id1118
 user_id1286
 property_id3756
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
- sidebar_brokerages(array)
 0(array)
 Brokerage(array)
 id246
 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)
 country_id0
 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_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameEric B Test
 broker_of_record_name
 short_nameEric B Test
 username
 password
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 description
 communities
 websitehttp://LeverageRE.com
 address111 Main
 address_2
 cityNew York
 stateMV
 full_state
 countryUSA
 market
 market_2
 postal_code10016
 phone3076992337
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameEric Test
 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)
 created2024-12-18 22:38:09
 modified2024-12-18 23:03:27
 dre_num
 uri/brokerage-detail/246/eric-b-test
 website_shortLeverageRE.com
 name_with_locationEric B Test
 Logo(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 1(array)
 Brokerage(array)
 id73
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id13
 WOEID742676
 timezoneEurope/Lisbon
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePorta da Frente
 broker_of_record_name
 short_namePorta da Frente
 usernamePortadaFrente
 password32bdc972eb960b1abb44f4c864b114df2b21e383
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionWe are excited to announce Porta da Frente as the exclusive representative for Leverage Global Partners in Lisbon, Cascais, and Aletenjo, Portugal. Porta da Frente was born in 1995 with the clear objective of specialising in the medium-high to high segments of the residential property market. Entrepreneurial development and specialisation in this area of business have allowed the widening and diversification of the range of services it offers to its clients, a service of full support to the promoter, with particular emphasis on the after-sale phase, guaranteeing maximum assistance in the selection of the property, its sale/purchase/let, design, architecture, assessment of its true commercial value, finance and fiscal and/or legal advice. Porta da Frente has a solid sales team, comprising approximately 35 individuals comprising a department of short and long-term rentals made up of qualified professionals with a clear vocation for giving dedicated attention to each and every client. Increasing demand in other markets has led to the need to create a department exclusively dedicated to the international market. Talent, dedication, attentiveness, personal service and special treatment are traits that make it stand out against all the other players in the market.
 communitieslisbon cascais aletenjo
 websitehttp://www.portadafrente.com/
 addressAvenida Marginal, 8648 B
 address_2
 cityCascais
 state
 full_state
 countryPortugal
 marketLisbon
 market_2
 postal_code
 phone(351) 214 866-560
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameRafael Ascenso
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleGeneral Manager
 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_filename73.jpg
 logo_filename73.jpg
 contact_image_filename73.jpg
 all_properties_link_image_filename73.jpg
 all_properties_linkhttp://www.portadafrente.com/engb/properties
 video_embed_code
 contact_video_embed_code
 meta_titleLisbon Real Estate | Porta de Frente | Leverage Global Partners
 meta_descriptionPorta de Frente is the exclusive representative for Leverage Global Partners in Lisbon, Cascais, and Aletenjo, Portugal.
 meta_keywordsPorta de Frente, Lisbon, Cascais, and Aletenjo, Portugal real estate, lisbon real estate, golden triangle real estate, lisbon real estate, cascais real estate, aletenjo real estate, leverage global partners, Rafael Ascenso
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-11-26 18:16:38
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/73/porta-da-frente
 website_shortwww.portadafrente.com
 name_with_locationPorta da Frente
 Logo(array)
 id2452
 modelBrokerage
 model_id73
 tagLogo
 name73.jpg
 typeimage/jpg
 size181732
 uri/assets/2452.jpg
 order0
 created2016-03-30 11:39:50
 modified2016-03-30 11:39:50
 2(array)
 Brokerage(array)
 id133
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2381475
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameStouffer Realty Inc
 broker_of_record_name
 short_nameStouffer Realty Inc
 usernameStoufferRealty
 password90e3506a4fa22fac2c3589ef68513c472431da13
 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
 descriptionGary Stouffer, Owner and Founder of Stouffer Realty, began specializing in upscale real estate and large tracts of land in his hometown of Bath, Ohio 33 years ago. His outstanding sales record and reputation in the area inspired him to get his Broker’s license and open Stouffer Realty. The legacy of Stouffer Realty took root, tripling their sales force within three years. This phenomenal rate of growth continues at Stouffer Realty, making it one of the foremost Real Estate brokerages in Northeast Ohio and your best choice for locating and selling Exquisite Homes across this region. Stouffer Realty’s agents share a unique spirit of cooperation, which are both our strongest asset as well as the foundation of the company’s exceptional service. Our dedicated agents work together as a team by always putting the needs of the client first. Our satisfied buyers and sellers are our best form of advertisement. Stouffer agents represent the top realtors in the area, many of which are multi-million dollar producers who specialize in selling exquisite residential and commercial properties at the best possible price. Hundreds of clients have discovered or built their dream property with Stouffer Realty. All Stouffer Realty professionals live in and support the communities they serve. They have first-hand knowledge of area property values, school systems, neighborhoods and finance options. As a result, they are able to negotiate from a position of understanding, integrity, experience and strength in the marketplace. Stouffer realty, Inc. is a leading real estate company in Northeast Ohio, built on a reputation of integrity and exceptional service. Locally owned and operated since 1997, Stouffer Realty has more than 160 agents and specialists in offices serving Akron/Fairlawn, Brecksville/Broadview Heights, Chagrin Falls/Solon, Green/Canton, Kent/Brimfield, Stow/Hudson/Cuyahoga Falls, Strongsville/Brunswick, Medina County and surrounding communities
 communitiesCleveland Hudson Solon Akron Fairlawn Bath Copley Richfield Medina Green Canton Cuyahoga Falls Stow Brimfield Kent Chagrin Valley Summit Wayne Stark Portage Geauga Cuyahoga Counties
 websitehttp://www.stoufferrealty.com/Exquisite-Homes/
 address130 North Miller Road
 address_2
 cityFairlawn
 stateOH
 full_stateOhio
 countryUSA
 marketCleveland
 market_2
 postal_code44333
 phone(330) 835-4900
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJim Fox
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBroker - Vice President of Sales & Operations
 contact_dre_num
 contact_quoteI invite you to contact me personally about Northeast Ohio real estate
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename133.jpg
 logo_filename133.jpg
 contact_image_filename133.jpg
 all_properties_link_image_filename133.JPG
 all_properties_linkhttp://www.stoufferrealty.com/listings/query.php?property_category=1&state=39&&pricemin=%24+750%2C000&cidonly=1&
 video_embed_code
 contact_video_embed_code
 meta_titleCleveland Real Estate | Stouffer Realty Inc | Leverage Global Partners
 meta_descriptionStouffer Realty Inc. is the exclusive representative for Leverage Global Partners in Cleveland, OH, USA.
 meta_keywordsStouffer Realty, Cleveland Real Estate, Jim Fox, Hudson real estate, Solon real estate, akron real estate, fairlawn real estate, bath real estate, copley real estate, richfield real estate, medina real estate, green real estate, canton real estate, cuyahoga falls real estate, stow real estate, brimfield real estate, kent real estate, summit real estate, chagrin valley real estate, wayne real estate, stark real estate, portage real estate, geauga real estate, cuyahoga real estate, ohio real estate, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-06-24 09:40:22
 modified2016-04-08 16:34:09
 dre_num012345
 uri/brokerage-detail/133/stouffer-realty-inc
 website_shortwww.stoufferrealty.com/Exquisite-Homes
 name_with_locationStouffer Realty Inc
 Logo(array)
 id2638
 modelBrokerage
 model_id133
 tagLogo
 name133.jpg
 typeimage/jpg
 size750656
 uri/assets/2638.jpg
 order0
 created2016-03-30 11:41:50
 modified2016-03-30 11:41:50
 3(array)
 Brokerage(array)
 id206
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2486435
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameSpecial Properties
 broker_of_record_name
 short_nameSpecial Properties
 usernameSpecialProperties
 password80bff9ecdfafd4cb525f795d439c9f6d73b691dd
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionSpecial Properties is the exclusive representative for Leverage Global Partners in Allendale, Alpine, Cliffside Park, Cresskill, Demarest, Edgewater, Englewood, Englewood Cliffs, Fort Lee, Franklin Lakes, Ho Ho Kus, Mahwah, Oakland, Old Tappan, Ramsey, Ridgewood, Saddle River, Tenafly, Upper Saddle River, Woodcliff Lake, Wyckoff, NJ USA. Special Properties, Division of Brook Hollow Group, Inc. Realtors is a Real Estate brokerage firm located in Saddle River, NJ, serving New Jersey and New York. Established in 1992, we specialize in the marketing and selling of luxury properties. We market at the highest level and offer a full range of real estate services. Our Realtor Associates and our staff are highly experienced and operate at an unparalleled level. We are pleased to announce the opening of 2 new offices in Mahwah and Franklin Lakes, New Jersey. Please contact us to find out more information regarding Special Properties Real Estate Services, LLC. Our exclusive affiliation with Christie’s International Real Estate for Northwest Bergen County offers us the ability to relocate our clients anywhere in the world at the same high standard they expect in doing business with us. Our newest affiliation with Leverage Global Partners is adding to our network of affiliates who have the same high level of marketing and service standards that we do. We are very excited about this new relationship. We have exclusive affiliations with several magazine publications which are national as well as New York City/Metropolitan area based. Contact us for additional information about our extensive marketing program, our exclusive listings as well as all multiple listed properties on our website.
 communitiesSaddle River Bergen County Allendale Alpine Cliffside Park Cresskill Demarest Edgewater Englewood Englewood Cliffs Fort Lee Franklin Lakes Ho Ho Kus Mahwah Oakland Old Tappan Ramsey Ridgewood Saddle River Tenafly Upper Saddle River Woodcliff Lake Wyckoff
 websitehttp://www.specialproperties.com/
 address158 West Saddle River Road
 address_2
 citySaddle River
 stateNJ
 full_stateNew Jersey
 countryUSA
 market
 market_2
 postal_code07458
 phoneOffice: (201) 934-7111
 phone_2Cell: (201) 390-5880
 phone_3
 wide_contact_image(false)
 contact_nameVicki Gaily
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCo Owner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename206.jpg
 logo_filename206.jpg
 contact_image_filename206.jpg
 all_properties_link_image_filename206.jpg
 all_properties_linkhttp://www.specialproperties.com/sales/usa/broker-listings-dstype
 video_embed_code
 contact_video_embed_code
 meta_titleSaddle River Real Estate | Special Properties | Leverage Global Partners
 meta_descriptionSpecial Properties is the exclusive representative for Leverage Global Partners in Saddle River including all of Bergen County, NJ USA.
 meta_keywordsSpecial Properties, Saddle River real estate, Bergen County real estate, North Jersey real estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-06-18 09:41:48
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/206/special-properties
 website_shortwww.specialproperties.com
 name_with_locationSpecial Properties
 Logo(array)
 id2839
 modelBrokerage
 model_id206
 tagLogo
 name206.jpg
 typeimage/jpg
 size590314
 uri/assets/2839.jpg
 order0
 created2016-03-30 11:44:41
 modified2016-03-30 11:44:41
- sidebar_locations(array)
 0(array)
 Location(array)
 id77
 parent_id6
 brokerage_id220
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameSydney Sutherland Shire, Australia
 short_nameSydney Sutherland Shire, Australia
 group_index
 latitude-33.867489
 longitude151.206985
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionThe Sutherland Shire - one of the best kept secrets you’ll ever find!
 long_descriptionThe Sutherland Shire, affectionately known as “The Shire” is a wonderful place to live – home to the world famous beaches of Cronulla with its golden sands, great surfing, pristine waters and the best sun kissed beach bodies in Australia, the Shire is alive with trendy bars, vibrant restaurants, cafes, boutique shopping and the unspoilt beauty of the Royal National Park, you will instantly fall in love with this stunning area of Sydney and never want to leave! Homes range from modest dwellings to magnificent designer homes, outstanding water and riverfront mansions with unsurpassed views and high end apartments and penthouses with expansive water views. The Shire offers an unbeatable and enviable lifestyle, why not come see for yourself?
 created2016-04-05 09:24:10
 modified2016-04-05 09:24:10
 timezoneAustralia/Sydney
 population220000
 uri/locations/view/77/sydney-sutherland-shire-australia
 tile_nameSydney Sutherland Shire, Australia
 Brokerage(array)
 id220
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id0
 WOEID1094945
 timezoneAustralia/Sydney
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameAllam Real Estate
 broker_of_record_name
 short_nameAllam Real Estate
 usernameallamrealestate
 password28eaf452dcfe1bbfc0b8f59e8df4acc23a7f6391
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionAllam Real Estate is the exclusive representative for Leverage Global Partners in the municipalities of Sutherland Shire and St. George, including the suburbs of Cronulla, Greenhills Beach, Woolooware, Caringbah, Burraneer, Sylvania Waters, Yowie Bay, Caringbah South, Lilli Pilli, and Dolans Bay, NSW, Australia. With any dream comes a backbone to make that dream a reality. Ours is simple, yet detailed enough to ensure we deliver on those dreams with consistency and desire. Honesty Because people love doing business with people they can trust. At no point will you ever get the double glazed version of the stretched truth, just straight down the line, black and white honesty – because the truth doesn’t need to be presented any different. Promises If we say we will do it, you can bet you dollar it will happen. No false statements to suck you in, just plain hard work time and time again without compromise. At the end of a sale, we are not happy unless you walk away recommending us to your friends, family and anyone else you know interested in real estate. Service A great agent doesn’t need to work 24/7, but does need to be there 24/7. Try us out, send us an email, leave us a missed call, even sms us and see how quickly we get back to you. Opportunities in real estate come and go very quickly, so we do our best to make sure they are never missed. Results Facts always speak louder than words. That’s why we are proud of our results and over the last 18 months we have achieved; Auction Clearance Rate – 94% Average Price Achieved Above Reserve Price At Auction – $56,000 Average Days On Market – 19 Days Average Price Above Listed Price When Selling ‘Offers Above’ – $33,400 Listed to Sold Ratio – 92% Sell Rate
 communitiesSutherland Shire St. George Cronulla Greenhills Beach Woolooware Caringbah Burraneer Sylvania Waters Yowie Bay Caringbah South Lilli Pilli Dolans Bay
 websitehttp://www.allamre.com.au/
 address1/317 Kingsway
 address_2
 cityCaringbah
 state
 full_state
 countryAustralia
 marketSydney Sutherland Shire
 market_2
 postal_codeNSW 2229
 phone+61 (029) 525-3333
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameRichard Bowen & Camille Allam
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePartner & Managing Director
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Sydney Sutherland Shire real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename220.jpg
 logo_filename220.jpg
 contact_image_filename220.jpg
 all_properties_link_image_filename220.jpg
 all_properties_linkhttp://www.allamre.com.au/listings/
 video_embed_code
 contact_video_embed_code
 meta_titleSydney Sutherland Shire Real Estate | Allam Real Estate | Leverage Global Partners
 meta_descriptionAllam Real Estate is the exclusive representative for Leverage Global Partners in the municipalities of Sutherland Shire and St. George, including the suburbs of Cronulla, Greenhills Beach, Woolooware, Caringbah, Burraneer, Sylvania Waters, Yowie Bay, Caringbah South, Lilli Pilli, and Dolans Bay, NSW, Australia.
 meta_keywordsAllam Real Estate, municipalities of Sutherland Shire Real Estate, municipalities of St. George Real Estate, suburbs of Cronulla Real Estate, Greenhills Beach Real Estate, Woolooware Real Estate, Caringbah Real Estate, Burraneer Real Estate, Sylvania Waters Real Estate, Yowie Bay Real Estate, Caringbah South Real Estate, Lilli Pilli Real Estate, Dolans Bay, NSW Real Estate, Australia Real Estate.
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-08-27 13:58:14
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/220/allam-real-estate
 website_shortwww.allamre.com.au
 name_with_locationAllam Real Estate
 Image(array)
 id3009
 modelLocation
 model_id77
 tagImage
 name39922990_cronulla-beach-36142.jpg
 typeimage/jpeg
 size118801
 uri/assets/3009.jpg
 order0
 created2016-04-05 09:19:18
 modified2016-04-05 09:24:10
 1(array)
 Location(array)
 id33
 parent_id9
 brokerage_id1
 typeExclusive
 archived(false)
 use_as_topic(true)
 nameBeverly Hills, CA, USA
 short_nameBeverly Hills, CA, USA
 group_index
 latitude34.073620
 longitude-118.400352
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionIconic Beverly Hills is more than just a famous zip code, this town is synonymous with the good life.
 long_descriptionKnown around the world as a symbol of luxury and beauty, Beverly Hills is more than just a pretty face. Behind the flash of Rodeo Drive and the trendy allure of Robertson Blvd. is a city rich in culture and historic style. As a world-renowned shopping destination, Beverly Hills boasts some of the best boutiques in the area and nearly every major luxury brand has a presence in the city. Celebrity sightings are common among those who want to see and be seen. The city’s long history means that a variety of architectural styles abound, from the grand mansions to more modest older homes. Much of the real estate lies in the flats, which features all sorts of homes for sale from Tudors and Spanish Revivals to newer modern architecturals.
 created2016-04-04 12:04:35
 modified2016-04-14 10:50:42
 timezoneAmerica/Los_Angeles
 population35000
 uri/locations/view/33/beverly-hills-ca-usa
 tile_nameBeverly Hills, CA, USA
 Brokerage(array)
 id1
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties12
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties1
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id1
 WOEID2363796
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePartners Trust Real Estate Brokerage and Acquisitions
 broker_of_record_name
 short_namePartners Trust Real Estate
 usernamePartnersTrustBH
 password2a77eb13ee7deac93b310ba1431a4982bfdbddeb
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 description<h2> </h2> Partners Trust is the exclusive representative for Leverage Global Partners in Beverly Hills, California, USA. We are dedicated to being the finest real estate brokerage in Los Angeles. At Partners Trust, our objective is to present our clients with the most professional, successful and ethical real estate associates in the business and to represent our clients with care, confidentiality and the utmost attention to service. We believe we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market. We begin with a commodity that is hard-earned and easily lost: TRUST. Without the daily demonstration and commitment to uphold principles, a company’s mission statement is simply words on a page and nothing more. Partners Trust has adopted a mission statement that each Associate and staff member must sign to in order to participate with the Company, which articulates the core philosophy and culture of the Company. The Partners Trust founders utilized their extensive experience and resources to create a Company that is both unique and beneficial for those willing to commit to the rigorous standards that have been set forth. The Company’s intention is to empower each member of its sales force each and every step of the way. Partners Trust has additional office locations in <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/5/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Pasadena</a>, <a href="../../../brokerage-detail/142/Partners-Trust" target="_blank">Malibu</a> and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a>
 communitiesBeverly Hills Bel Air Century City Westwood West Hollywood
 websitehttp://thepartnerstrust.com
 address9378 Wilshire Boulevard
 address_2Suite 200
 cityBeverly Hills
 stateCA
 full_stateCalifornia
 countryUSA
 marketBeverly Hills
 market_2
 postal_code90212
 phone(310) 500-1388
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameNick Segal
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/presidential-profile-partners-trust-real-estate-brokerage-aquisitions-nick-segal/
 contact_big_profile_link_text
 contact_titlePresident/Co-Founder
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename1.jpg
 logo_filename1.png
 contact_image_filename1.jpg
 all_properties_link_image_filename1.jpg
 all_properties_linkhttp://www.thepartnerstrust.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleBeverly Hills Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
 meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions is an award-winning real estate brokerage representing Leverage Global Partners in Beverly Hills, CA, USA.
 meta_keywordspartners trust, partners trust real estate, beverly hills real estate, beverly hills real estate agents, leverage global partners
 login_message_counter2
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-02-21 13:57:13
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/1/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortthepartnerstrust.com
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 Image(array)
 id2961
 modelLocation
 model_id33
 tagImage
 nameBeverly Hills.jpg
 typeimage/jpeg
 size147969
 uri/assets/2961.jpg
 order0
 created2016-04-04 12:04:27
 modified2016-04-14 10:50:42
 2(array)
 Location(array)
 id143
 parent_id7
 brokerage_id34
 typeExclusive
 archived(false)
 use_as_topic(true)
 nameHamptons, NY, USA
 short_nameHamptons, NY, USA
 group_index
 latitude40.924618
 longitude-72.354790
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description The Hamptons, the world's playground for the rich and famous.
 long_descriptionThe absolute bastion of luxury and real estate opulence. The Hamptons has been the home of America's most expensive and resilient real estate since the turn of the 20th Century. Located just 90 miles from the financial center of the world, New York City, the East End is the preferred resort community for businessmen and celebrities alike. A collection of small, unique towns and hamlets, the area is home to world renown restaurants, designer boutiques, unparalleled entertainment and of course the east coast's most beautiful ocean beaches. A true paradise and one of the most sought after real estate markets.
 created2016-04-07 16:14:57
 modified2016-04-14 10:51:05
 timezoneAmerica/New_York
 population15000
 uri/locations/view/143/hamptons-ny-usa
 tile_nameHamptons, NY, USA
 Brokerage(array)
 id34
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2518253
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameFirst Hampton International Realty
 broker_of_record_name
 short_nameFirst Hampton International Realty
 usernameFirstHampton
 passwordc6d7951ad2b1432ff444a7a5acca6784d6573bb9
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionFirst Hampton International Realty is the exclusive representative for Leverage Global Partners in The Hamptons, New York, USA. Lawrence Citarelli Jr. is a successful, former finance/ economics executive of 14 years and possesses over 17 years of real estate investment and development experience. Mr. Citarelli has forged the Lawrence III Group, The group is comprised of a multi award winning design/construction management firm, Westhampton Partners, a development and acquisition arm and First Hampton International Realty, a global real estate entity. Through the vertical integration of these three entities clients and customers are provided with an experience and service model that is unrivaled in the industry. Mr. Citarelli is also a consummate humanitarian and is aligned with various noteworthy athletes, entertainers and celebrities. He has recently been awarded a congressional award for his international business dealings which are specifically tied to helping the less fortunate children and the communities where he is active.
 communitiesWesthampton Beach Westhampton Quogue Remsenburg hamptons southampton east hampton
 websitehttp://www.firsthamptonrealty.com
 address50 Main Street
 address_2
 cityWesthampton Beach
 stateNY
 full_stateNew York
 countryUSA
 marketHamptons
 market_2
 postal_code11978
 phone(631) 872-0280
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameLawrence Citarelli
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-lawrence-citarelli-principal-first-hampton-realty/
 contact_big_profile_link_text
 contact_titlePrincipal
 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_filename34.jpg
 logo_filename34.jpg
 contact_image_filename34.jpg
 all_properties_link_image_filename34.jpg
 all_properties_linkhttp://www.firsthamptonrealty.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleThe Hamptons Real Estate | First Hampton International Realty | Leverage Global Partners
 meta_descriptionFirst Hampton International Realty is Leverage Global Partners' exclusive representative in the Hamptons, New York, USA.
 meta_keywordsFirst Hampton International Realty, The Hamptons Real Estate, Westhampton beach real estate, Lawrence Citarelli, 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-06-07 11:03:46
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/34/first-hampton-international-realty
 website_shortwww.firsthamptonrealty.com
 name_with_locationFirst Hampton International Realty
 Image(array)
 id9030
 modelLocation
 model_id143
 tagImage
 nameHamptons.jpg
 typeimage/jpeg
 size240646
 uri/assets/9030.jpg
 order0
 created2016-04-07 16:12:57
 modified2016-04-14 10:51:05
 3(array)
 Location(array)
 id48
 parent_id9
 brokerage_id109
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameAshland, OR, USA
 short_nameAshland, OR, USA
 group_index
 latitude42.194576
 longitude-122.709480
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 12:52:41
 modified2016-04-04 12:52:41
 timezoneAmerica/Los_Angeles
 population21000
 uri/locations/view/48/ashland-or-usa
 tile_nameAshland, OR, USA
 Brokerage(array)
 id109
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2356616
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameRoyce Real Estate
 broker_of_record_name
 short_nameRoyce Real Estate
 usernameRoyceRealEstate
 password06fa50ddb6c4dc5fa684154ab8e1ae9861a667be
 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
 descriptionRoyce Real Estate is the exclusive representative for Leverage Global Partners in Ashland, Talent, and Medford, Oregon, USA. More information coming soon!
 communitiesTalent Medford
 websitehttp://www.roycerealestate.net/
 address145 E Main Street
 address_2
 cityAshland
 stateOR
 full_stateOregon
 countryUSA
 marketAshland
 market_2
 postal_code97502
 phone(541) 482-3814
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameSandy Royce
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename109.jpg
 logo_filename109.png
 contact_image_filename109.jpg
 all_properties_link_image_filename109.jpg
 all_properties_linkhttp://www.roycerealestate.net/ashland-homes-for-sale
 video_embed_code
 contact_video_embed_code
 meta_titleAshland Real Estate | Royce Real Estate | Leverage Global Partners
 meta_descriptionRoyce Real Estate is the exclusive representative for Leverage Global Partners in Ashland, Oregon, USA.
 meta_keywordsRoyce Real Estate, Ashland Real Estate, Sandy Royce, Talent Medford Real Estate, Ashland Oregon, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-03-31 16:16:13
 modified2016-04-08 16:34:09
 dre_num012345
 uri/brokerage-detail/109/royce-real-estate
 website_shortwww.roycerealestate.net
 name_with_locationRoyce Real Estate
 Image(array)
 id2976
 modelLocation
 model_id48
 tagImage
 nameRoyce.jpg
 typeimage/jpeg
 size163780
 uri/assets/2976.jpg
 order0
 created2016-04-04 12:52:31
 modified2016-04-04 12:52:41
- location_properties(empty)
- main_article(empty)
- brokerage(array)
 Brokerage(array)
 id191
 account_executive_id236
 archived(false)
 typedevelopment
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(true)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2487796
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameNIX Realty Company
 broker_of_record_name
 short_nameNIX Realty Company
 usernameNIXRealtyCompany
 password8cdefc75e1cc80987ef5f25f14119ae502ff4e35
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionNIX Realty Company is the exclusive representative for Leverage Global Partners in San Antonio, TX, including Bexar County, Texas Hill County, Alamo Heights, Terrel Hills, Olmos Park, Boerne, TX, USA. Nix Realty Company, a residential real estate brokerage firm, was founded in 2007 by Kate Coiner Park and Marnie Tate Simpson. They saw a need for a boutique company that could specialize its services to each client’s specific needs. Their main focus is to provide excellent customer service and up to date knowledge and advice. Kate and Marnie’s families have been in San Antonio a long time, with roots reaching back to the Alamo itself, and some of downtown’s landmarks, including the Nix Hospital and the current Emily Morgan Hotel, both built by J.M. and Birdie Nix, Kate’s ancestors, and real estate developers. Nix Realty Company is named after them. Nix Realty Company has a “family” atmosphere, with about twenty agents at the firm. Agents range from over thirty years in the business, to just a few years, but all have the common goal of teamwork, professionalism, and providing their clients with exceptional service. Every year since 2010, Nix has been ranked in the top four firms in the San Antonio Business Journal for its average sales price. Thank you for your interest in Nix Realty Company, and please let us know how we can assist you.
 communitiesBexar County Texas Hill County Alamo Heights Terrel Hills Olmos Park Boerne
 websitehttp://nixrealtycompany.com/
 address120 West Olmos Drive
 address_2
 citySan Antonio
 stateTX
 full_stateTexas
 countryUSA
 market
 market_2
 postal_code78212
 phone Cell: 210-364-4703
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameKate Park
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCo-Owner/Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename191.jpg
 logo_filename191.jpg
 contact_image_filename191.jpg
 all_properties_link_image_filename191.jpg
 all_properties_linkhttp://nixrealtycompany.com/category/listings/
 video_embed_code
 contact_video_embed_code
 meta_titleSan Antonio, TX⎜NIX Realty Company⎜Leverage Global Partners
 meta_descriptionNIX Realty Company is the exclusive representative for Leverage Global Partners in San Antonio, TX, including Bexar County, Texas Hill County, Alamo Heights, Terrel Hills, Olmos Park, Boerne, TX, USA.
 meta_keywordsNIX Realty Company, Leverage Global Partners, San Antonio Real Estate, Texas Real Estate, Bexar County, Texas Hill County, Alamo Heights, Terrel Hills, Olmos Park, Boerne, Texas
 login_message_counter2
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-02-12 10:28:46
 modified2019-09-09 11:33:38
 dre_num012345
 uri/development-detail/191/nix-realty-company
 website_shortnixrealtycompany.com
 name_with_locationNIX Realty Company - San Antonio, TX, USA
 AccountExecutive(array)
 id236
 typeAccountExecutive
 brokerage_id0
 email[email protected]
 passworde5cc5a96287695cf8b7cace1463b1699895dcf92
 recover_hash
 first_nameLauren
 last_namePena
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2020-12-23 09:21:16
 created2016-04-14 15:43:52
 notified(false)
 full_nameLauren Pena
 uri/agent-detail/236/lauren-pena
 profile_complete(true)
 Logo(array)
 id2809
 modelBrokerage
 model_id191
 tagLogo
 name191.jpg
 typeimage/jpg
 size55804
 uri/assets/2809.jpg
 order0
 created2016-03-30 11:44:12
 modified2019-09-09 11:33:38
 MainImage(array)
 id2808
 modelBrokerage
 model_id191
 tagMainImage
 name191.jpg
 typeimage/jpg
 size2176495
 uri/assets/2808.jpg
 order0
 created2016-03-30 11:44:11
 modified2019-09-09 11:33:38
 ContactImage(array)
 id2810
 modelBrokerage
 model_id191
 tagContactImage
 name191.jpg
 typeimage/jpg
 size1525155
 uri/assets/2810.jpg
 order0
 created2016-03-30 11:44:12
 modified2019-09-09 11:33:38
 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(array)
 0(array)
 id23010
 modelBrokerage
 model_id191
 tagFeaturedImage
 nameapartment-architectural-design-architecture-323780.jpg
 typeimage/jpeg
 size332829
 uri/assets/23010.jpg
 order0
 created2019-09-09 11:30:04
 modified2019-09-09 11:33:38
 1(array)
 id23011
 modelBrokerage
 model_id191
 tagFeaturedImage
 namearchitectural-design-architecture-blue-sky-462358.jpg
 typeimage/jpeg
 size382238
 uri/assets/23011.jpg
 order1
 created2019-09-09 11:30:05
 modified2019-09-09 11:33:38
 2(array)
 id23012
 modelBrokerage
 model_id191
 tagFeaturedImage
 nameaerial-photography-architecture-building-1546168.jpg
 typeimage/jpeg
 size356213
 uri/assets/23012.jpg
 order2
 created2019-09-09 11:30:05
 modified2019-09-09 11:33:38
 3(array)
 id23013
 modelBrokerage
 model_id191
 tagFeaturedImage
 nameaerial-aerial-shot-architecture-1642125.jpg
 typeimage/jpeg
 size743664
 uri/assets/23013.jpg
 order3
 created2019-09-09 11:30:05
 modified2019-09-09 11:33:38
 4(array)
 id23014
 modelBrokerage
 model_id191
 tagFeaturedImage
 nameappartment-building-appartments-architecture-87223.jpg
 typeimage/jpeg
 size309517
 uri/assets/23014.jpg
 order4
 created2019-09-09 11:30:05
 modified2019-09-09 11:33:38
 5(array)
 id23015
 modelBrokerage
 model_id191
 tagFeaturedImage
 namearchitectural-design-architecture-blue-sky-1838640.jpg
 typeimage/jpeg
 size895148
 uri/assets/23015.jpg
 order5
 created2019-09-09 11:30:05
 modified2019-09-09 11:33:38
 6(array)
 id23016
 modelBrokerage
 model_id191
 tagFeaturedImage
 namearchitecture-bird-s-eye-view-buildings-1587947.jpg
 typeimage/jpeg
 size980979
 uri/assets/23016.jpg
 order6
 created2019-09-09 11:30:06
 modified2019-09-09 11:33:38
 7(array)
 id23017
 modelBrokerage
 model_id191
 tagFeaturedImage
 namebackyard-lights-mansion-32870.jpg
 typeimage/jpeg
 size353456
 uri/assets/23017.jpg
 order7
 created2019-09-09 11:30:06
 modified2019-09-09 11:33:38
 8(array)
 id23018
 modelBrokerage
 model_id191
 tagFeaturedImage
 namearchitectural-design-architecture-clouds-1732414.jpg
 typeimage/jpeg
 size363725
 uri/assets/23018.jpg
 order8
 created2019-09-09 11:30:06
 modified2019-09-09 11:33:38
 9(array)
 id23019
 modelBrokerage
 model_id191
 tagFeaturedImage
 nameapartment-architectural-design-architecture-1436190.jpg
 typeimage/jpeg
 size818644
 uri/assets/23019.jpg
 order9
 created2019-09-09 11:30:06
 modified2019-09-09 11:33:38
 Location(array)
 0(array)
 id135
 parent_id8
 brokerage_id191
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameSan Antonio, TX, USA
 short_nameSan Antonio, TX, USA
 group_index
 latitude29.424122
 longitude-98.493629
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionSan Antonio, historic and dynamic -- something for everyone.
 long_descriptionSan Antonio is located in the heart of the Texas Hill Country, and is Texas’ most affordable major metropolitan city. Known as “big city with a small town feel” it is a blend of charm and sophistication. San Antonio boasts the top tourist attractions in Texas: the Alamo and the Riverwalk. The city is home to the San Antonio Spurs, great shopping, fine dining, museums, and, it’s a short drive to the beautiful Hill Country. With good schools, a variety of housing styles, and short commute times, San Antonio is a great place to live. Discover San Antonio, there is something for everyone.
 created2016-04-07 15:21:12
 modified2016-04-07 15:21:12
 timezoneAmerica/Chicago
 population1400000
 uri/locations/view/135/san-antonio-tx-usa
 tile_nameSan Antonio, TX, USA
 User(array)
 0(array)
 id181
 typeBrokerageAdmin
 brokerage_id191
 email[email protected]
 password8cdefc75e1cc80987ef5f25f14119ae502ff4e35
 recover_hash
 first_nameKate
 last_namePark
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2016-04-12 08:30:22
 created2016-04-08 16:34:20
 notified(true)
 full_nameKate Park
 uri/agent-detail/181/kate-park
 profile_complete(true)
 1(array)
 id265
 typeAgent
 brokerage_id191
 email[email protected]
 passworda94d5d36a9f0ffbe7fd3ca2adaf261955bafe729
 recover_hash
 first_nameBetty
 last_nameBoston
 title
 dre_num
 phone210-863-2909
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:39
 created2017-08-07 15:22:39
 notified(false)
 full_nameBetty Boston
 uri/agent-detail/265/betty-boston
 profile_complete(true)
 2(array)
 id266
 typeAgent
 brokerage_id191
 email[email protected]
 passwordd923f8dd5470e02e0beafad22f1ff0a29ea07a99
 recover_hash
 first_nameMolly
 last_nameWilkes
 title
 dre_num
 phone210-857-1711
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:39
 created2017-08-07 15:22:39
 notified(false)
 full_nameMolly Wilkes
 uri/agent-detail/266/molly-wilkes
 profile_complete(true)
 3(array)
 id267
 typeAgent
 brokerage_id191
 email[email protected]
 password009a1795f68ed071d45639096160c42bb3fb7a03
 recover_hash
 first_nameJeanie-
 last_nameTravis
 title
 dre_num
 phone210-385-0182
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:39
 created2017-08-07 15:22:39
 notified(false)
 full_nameJeanie- Travis
 uri/agent-detail/267/jeanie-travis
 profile_complete(true)
 4(array)
 id270
 typeAgent
 brokerage_id191
 email[email protected]
 password6f08511a8945fe6a958adaffbfb1c66ee740ab33
 recover_hash
 first_nameKate
 last_namePark
 title
 dre_num
 phone210-364-4703
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:39
 created2017-08-07 15:22:39
 notified(false)
 full_nameKate Park
 uri/agent-detail/270/kate-park
 profile_complete(true)
 5(array)
 id273
 typeAgent
 brokerage_id191
 email[email protected]
 passwordc57756f5ac7581fcc25841eefc1e9a6e92604f05
 recover_hash
 first_nameMarnie
 last_nameSimpson
 title
 dre_num
 phone210-365-4327
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:39
 created2017-08-07 15:22:39
 notified(false)
 full_nameMarnie Simpson
 uri/agent-detail/273/marnie-simpson
 profile_complete(true)
 6(array)
 id314
 typeAgent
 brokerage_id191
 email[email protected]
 passworde3a94229adc0877b88b1ed90c43398616533b857
 recover_hash
 first_nameJamie
 last_nameWest
 title
 dre_num
 phone210-313-1598
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:45
 created2017-08-07 15:22:45
 notified(false)
 full_nameJamie West
 uri/agent-detail/314/jamie-west
 profile_complete(true)
 7(array)
 id347
 typeAgent
 brokerage_id191
 email[email protected]
 passwordf6ee9541e7829c1bb555978cdd365905134791f2
 recover_hash
 first_nameSally
 last_nameBlecher
 title
 dre_num
 phone210-822-7979
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:48
 created2017-08-07 15:22:48
 notified(false)
 full_nameSally Blecher
 uri/agent-detail/347/sally-blecher
 profile_complete(true)
 8(array)
 id532
 typeAgent
 brokerage_id191
 email[email protected]
 password8d2d7df1caff95ea838006e57d5ed2d608fbcece
 recover_hash
 first_nameSuzanne
 last_nameSimpson
 title
 dre_num
 phone210-838-4440
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:05
 created2017-08-07 15:23:05
 notified(false)
 full_nameSuzanne Simpson
 uri/agent-detail/532/suzanne-simpson
 profile_complete(true)
 9(array)
 id637
 typeAgent
 brokerage_id191
 email[email protected]
 passworddcdd425f2529a079622817ffa4a0883bfd656113
 recover_hash
 first_nameKatherine
 last_nameEversberg
 title
 dre_num
 phone210-240-0414
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:12
 created2017-08-07 15:23:12
 notified(false)
 full_nameKatherine Eversberg
 uri/agent-detail/637/katherine-eversberg
 profile_complete(true)
 10(array)
 id910
 typeAgent
 brokerage_id191
 email[email protected]
 password46ed377d482d1db2ebc3858dd4b23ab7e7573eb8
 recover_hash
 first_nameLaura
 last_nameHobbs
 title
 dre_num
 phone(210) 884-2482
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:44
 created2017-08-07 15:23:44
 notified(false)
 full_nameLaura Hobbs
 uri/agent-detail/910/laura-hobbs
 profile_complete(true)
 11(array)
 id918
 typeAgent
 brokerage_id191
 email[email protected]
 passwordfc6baf611a64bb54f6bc018566ce4b305f37342b
 recover_hash
 first_nameNena
 last_nameKing
 title
 dre_num
 phone2102882107
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:44
 created2017-08-07 15:23:44
 notified(false)
 full_nameNena King
 uri/agent-detail/918/nena-king
 profile_complete(true)
 12(array)
 id943
 typeAgent
 brokerage_id191
 email[email protected]
 passwordc8a43b34126410d6de9379630b6f9c6befeeff40
 recover_hash
 first_nameSuzi
 last_nameBirnbaum
 title
 dre_num
 phone210-325-0773
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:45
 created2017-08-07 15:23:45
 notified(false)
 full_nameSuzi Birnbaum
 uri/agent-detail/943/suzi-birnbaum
 profile_complete(true)
 13(array)
 id1063
 typeAgent
 brokerage_id191
 email[email protected]
 passwordbbf321b96c4bb1270a6fb804b4e169f45a7d1dbe
 recover_hash
 first_nameJill
 last_nameFitch
 title
 dre_num
 phone210-710-5043
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:51
 created2017-08-07 15:23:51
 notified(false)
 full_nameJill Fitch
 uri/agent-detail/1063/jill-fitch
 profile_complete(true)
 14(array)
 id1237
 typeAgent
 brokerage_id191
 email[email protected]
 password0ee8718d00beba9823aa982325065aaba348b913
 recover_hash
 first_nameDoreen
 last_nameMagoon
 title
 dre_num
 phone210.843.1092
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:59
 created2017-08-07 15:23:59
 notified(false)
 full_nameDoreen Magoon
 uri/agent-detail/1237/doreen-magoon
 profile_complete(true)
- location(array)
 Location(array)
 id135
 parent_id8
 brokerage_id191
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameSan Antonio, TX, USA
 short_nameSan Antonio, TX, USA
 group_index
 latitude29.424122
 longitude-98.493629
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionSan Antonio, historic and dynamic -- something for everyone.
 long_descriptionSan Antonio is located in the heart of the Texas Hill Country, and is Texas’ most affordable major metropolitan city. Known as “big city with a small town feel” it is a blend of charm and sophistication. San Antonio boasts the top tourist attractions in Texas: the Alamo and the Riverwalk. The city is home to the San Antonio Spurs, great shopping, fine dining, museums, and, it’s a short drive to the beautiful Hill Country. With good schools, a variety of housing styles, and short commute times, San Antonio is a great place to live. Discover San Antonio, there is something for everyone.
 created2016-04-07 15:21:12
 modified2016-04-07 15:21:12
 timezoneAmerica/Chicago
 population1400000
 uri/locations/view/135/san-antonio-tx-usa
 tile_nameSan Antonio, TX, USA
 Image(array)
 id5321
 modelLocation
 model_id135
 tagImage
 nameSan Antonio.jpg
 typeimage/jpeg
 size168507
 uri/assets/5321.jpg
 order0
 created2016-04-07 15:21:10
 modified2016-04-07 15:21:12
- membership_subscription_temp_allowed_login(null)
- newsletter_member_types(array)
 Leverage Member: AgentLeverage Member: Agent
 Leverage Member: Broker or ManagementLeverage Member: Broker or Management
 Non-MemberNon-Member
- $request->data(empty)
- $this->validationErrors(array)
 Subscription(empty)
 Location(empty)
 Image(empty)
 Brokerage(empty)
 AccountExecutive(empty)
 Logo(empty)
 MainImage(empty)
 ContactImage(empty)
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 Property(empty)
 User(empty)
 PropertyFeature(empty)
 SecondaryPropertyCategory(empty)
 Topic(empty)
 FeaturedImage(empty)
 Article(empty)
 ParentBrokerage(empty)
 ParentLocation(empty)
 ArticlesBrokerage(empty)
 ArticlesLocation(empty)
 ArticlesProperty(empty)
 ArticlesTopic(empty)
 PrimaryPropertyCategory(empty)
 StripeSubscription(empty)
 GlobalReachReport(empty)
 UsersProperty(empty)
 PropertiesSecondaryPropertyCategory(empty)
 PropertiesPropertyFeature(empty)
 PropertiesTopic(empty)
- Loaded Helpers(array)
 0Permission
 1Geography
 2Number
 3SimpleGraph
 4DebugTimer
 5Toolbar
 6Session
 7Text
 8Flash
 9HtmlToolbar
 10Html
 11Form
====

Environment

App Constants

Constant	Value
CONFIG	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Config/
GOOGLE_MAPS_PUBLIC_API_KEY	AIzaSyCD2zmgSzOEN-7tNHYSmGXL0MyWtMlHND4
GOOGLE_MAPS_PRIVATE_API_KEY	AIzaSyCIXpqYsaZp4_suK7IWeqUTIEbS_hMkoXs
RECAPTCHA_V2_SITE_KEY	6Lfs_EoUAAAAAKe8XSwR8p7AEMOLWB96veSLjRDv
RECAPTCHA_V2_SECRET_KEY	6Lfs_EoUAAAAAIo2vzNYILL-YwBaRxvTpjuemmKZ
PROTOCOL	https://
WEB_ENV	staging2
WEB_BASE_URL	https://staging2.leveragere.com
PROP_EMAIL_RECIPIENT	[email protected]
STRIPE_ISSUES_EMAIL_RECIPIENT	[email protected]
STRIPE_ENV	test
STRIPE_PK	pk_test_fIc7eHMfMVAhnrld2Vk2DDpG
STRIPE_SK	sk_test_D4NvWbVo5Fe04IJM0AItMKIR
SHELL_LAUNCHER	/opt/plesk/php/7.4/bin/php /var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Console/cake.php

CakePHP Constants

Constant	Value
APP	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/
APP_DIR	app
APPLIBS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Lib/
CACHE	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/tmp/cache/
CAKE	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib
CORE_PATH	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib/
CAKE_VERSION	2.10.19
CSS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://staging2.leveragere.com
IMAGES	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/img/
IMAGES_URL	img/
JS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/js/
JS_URL	js/
LOGS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/tmp/logs/
ROOT	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs
TESTS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Test/
TMP	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/tmp/
VENDORS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	7.4.33
User	leveragere
Home	/var/www/vhosts/leveragere.com
Script Name	/index.php
Request Uri	/locations/view/135/san-antonio-tx-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/locations/view/135/san-antonio-tx-usa
Remote Port	20975
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	104.23.197.114
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http Cf Ray	a09df22efa6f5c4f-CMH
Http Accept Encoding	gzip, br
Http Cookie	CAKEPHP=e2b0h79qke6icvjvru586r4got
Http Accept	/
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
Http X Forwarded For	216.73.216.172
Proxy-nokeepalive	1
Ssl Tls Sni	staging2.leveragere.com
Https	on
Passenger Download Native Support Binary	0
Passenger Compile Native Support Binary	0
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Unique Id	aio8kW6JJRDGsdfxHgrO9QAAAg8
Redirect Status	200
Redirect Ssl Tls Sni	staging2.leveragere.com
Redirect Https	on
Redirect Passenger Download Native Support Binary	0
Redirect Passenger Compile Native Support Binary	0
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Unique Id	aio8kW6JJRDGsdfxHgrO9QAAAg8
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781152913.7814
Request Time	1781152913

====

Include
+
Included Files

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

San Antonio, TX, USA

Location Represented By

Related Articles

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 19 ms Total Queries: 19 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 19 ms
Total Queries: 19 queries