Locations / Gloucester, Chesapeake Bay, VA

Gloucester, Chesapeake Bay, VA

More information coming soon!

Location Represented By

License #: 012345

11:27pm local time

Partner Search

Find partners with a map-based search

Related Locations

Greensboro, NC, USA

Bullhead City, AZ, USA

Marin County, CA, USA

Why so many are lured to this spectacular county.

San Antonio, TX, USA

San Antonio, historic and dynamic -- something for everyone.

Related Partners

J. Rockcliff Realtors

(925) 280-8500 | Email
License #: 012345

Fusilier Realty Group

Office: (407) 281-8455 | Email
License #: 012345

Allam Real Estate

+61 (029) 525-3333 | Email
License #: 012345

Lawrence Realty

(530) 583-1529 | Email
License #: 012345

Recent Property Listings

Historic landmark estate in Langham area of Pasadena

1330 Hillcrest Avenue
Pasadena, CA 91106
$6,500,000

104 Park Road

104 Park Road
Toronto C09, ON M4W 2N7
$8,950,000 CAD

Extraordinary Family Home

27424 Alpen
Lake Arrowhead, CA 92352
$545,000

The Cliffs at Walnut Cove

14 Foxbridge Way
Arden, North Carolina 28704
$927,500

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

Array
(
)

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

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

Query Explain:

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

====

Timer

Memory

Peak Memory Use 13.27 MB

Message	Memory use
Component initialization	2.88 MB
Controller action start	3.81 MB
Controller render start	6.71 MB
View render complete	7.26 MB

Timers

Total Request Time: 782 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	559.92
Event: Controller.initialize	6.10
Event: Controller.startup	6.02
Controller action	57.83
Event: Controller.beforeRender	13.94
» Processing toolbar data	13.84
Rendering View	89.10
» Event: View.beforeRender	0.28
» Rendering APP/View/Locations/view.ctp	2.68
» » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.17
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.16
» » Rendering APP/View/Elements/sidebar/brokerage_list.ctp	0.17
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.27
» » » Rendering APP/View/Elements/static_property_price.ctp	0.37
» » » Rendering APP/View/Elements/static_property_price.ctp #2	0.17
» » » 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	85.43
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)
 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)
 1(array)
 Property(array)
 id3762
 brokerage_id254
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 name104 Park Road
 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)
 descriptionOriginally a stately classic residence, this exceptional Rosedale home was thoughtfully reimagined in 2021 under the direction of acclaimed interior designers Michelle R. Smith and Hayley Bridget Cavagnolo. The result is a rare and seamless blend of timeless character and contemporary luxury-refined, welcoming, and rich in detail. Set behind lush landscaping, the home offers striking street presence with a quiet confidence that immediately captures attention. Inside, five bedrooms and five beautifully designed bathrooms are complemented by craftsmanship rarely found. Hand-painted flooring throughout the main level adds subtle artistry, while three wood-burning fireplaces-one anchoring the kitchen-bring warmth and charm to everyday living.The chef's kitchen is both functional and elegant, featuring a Wolf range, Sub-Zero Pro Series refrigeration, an oversized eat-in area, and a walk-out to an expansive deck that seamlessly extends the living space outdoors. A butler's pantry adds thoughtful storage and effortless entertaining appeal.Designed for hosting and relaxing alike, the home features a built-in Sonos sound system throughout the interior and backyard. Outdoors, a private resort-style setting awaits with a saltwater pool equipped with smart heating and lighting-perfect for year-round enjoyment.The third-floor retreat offers exceptional flexibility, complete with a family lounge, workspace, guest bedroom, full bath, and private rooftop deck. On the lower level, a sauna provides a spa-like escape, completing this truly one-of-a-kind Rosedale residence.
 address104 Park Road
 address_2
 cityToronto C09
 stateON
 postal_codeM4W 2N7
 countryCanada
 use_lat_lng_for_google_map(false)
 currencyCAD
 price8950000
 price_20
 price_usd6539765
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms5
 bedrooms_20
 bathrooms5
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 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_numC12697034
 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
 latitude43.675617
 longitude-79.382629
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(false)
 invalid(false)
 mlsidx_full_address104 Park Road Toronto C09 ON
 mlsidx_date_listed2026-01-14
 mls_marketTRREB
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2026-02-26 11:12:04
 created2026-02-26 11:11:35
 uri/property-detail/3762/104-park-road-toronto-c09-on-m4w-2n7-canada
 absolute_urihttps://staging2.leveragere.com/property-detail/3762/104-park-road-toronto-c09-on-m4w-2n7-canada
 address_concat104 Park Road Toronto C09 ON M4W 2N7 Canada
 google_maps_query_string104+Park+Road++Toronto+C09+ON+M4W+2N7+Canada
 luxury_ad_enrolled_prettyNO
 price_prettyCAD 8,950,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty5
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2026-01-14
 overridden_brokerage_nameSAGE Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id254
 account_executive_id0
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties50
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties4
 membership_luxury_feed_properties4
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID(null)
 timezoneAmerica/Toronto
 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(false)
 mlsidx_id146
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameSAGE Real Estate
 broker_of_record_name
 short_nameSage Real Estate
 username
 password
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_inSAGE Real Estate is a Leverage member in East, West, & Uptown Toronto, Canada
 short_description
 descriptionAt SAGE, we believe our clients deserve our very best. From expert counsel to custom marketing materials and great service, we’ve designed a real estate experience that’s remarkable. <h2>SAGE agents: Where integrity and results meet</h2> SAGE built a real estate experience centered, exclusively, around clients. Our agents live and breathe doing what’s right for each. They have an obsession with detail, a passion for integrity and a flair for delivering results. <h2>Design studio and print shop</h2> We’re so passionate about the pivotal role that great design and plays in selling a home, we built a design studio. We’re proud to have a team of talented designers and markers as full-time SAGE staff, collaborating with agents to ensure every home in our inventory is beautifully marketed and receives exposure locally, nationally, and internationally. <h2>Unmatched marketing</h2> SAGE’s in-house team of designers and marketers customize a marketing campaign for each listing. We deploy an array of marketing tactics to attract the greatest number of qualified buyers for each seller. <h2>Experienced leadership</h2> Ours is a family-run business led by career entrepreneurs who have more than five decades of combined experience in Toronto’s real estate industry. We strive for excellence in every facet of our business, iterating constantly so we continue delivering exceptional value. Every SAGE agent is hand-picked and supported by an in-house team of talented marketers, designers, front and back office administrators and managers. Every staff member is dedicated to enabling our agents delivery of remarkable real estate experiences.
 communitiesToronto East Toronto West Toronto Uptown Toronto Canada
 websitehttps://sagerealestate.ca/
 address2010 Yonge St
 address_2
 cityToronto
 stateON
 full_stateOntario
 countryCanada
 market
 market_2
 postal_codeM4S 1Z9
 phone416-483-8000
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameLarry Sage
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident & Broker of Record
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone(416) 483-8000
 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)
 created2026-02-26 10:58:32
 modified2026-02-26 10:58:33
 dre_num
 uri/brokerage-detail/254/sage-real-estate
 website_shortsagerealestate.ca
 name_with_locationSAGE Real Estate
 mlsidx_id_array(array)
 0146
 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)
 id23144
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvNTJjZTMzNjAtNzZlMC00OGFkLWE0NjgtZmZhMmQyNzY4ZWI1LmpwZw.jpg
 typeimage/jpeg
 size773305
 uri/assets/23144.jpg
 order0
 created2026-02-26 11:11:35
 modified2026-02-26 11:12:04
 1(array)
 id23145
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvMDhjNzA0YzktYjJjNS00MDUxLTgyYTgtM2U0MGZhNzE5ZjcyLmpwZw.jpg
 typeimage/jpeg
 size702345
 uri/assets/23145.jpg
 order1
 created2026-02-26 11:11:35
 modified2026-02-26 11:12:04
 2(array)
 id23146
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvZWIxMjg3MTgtODJiOS00MjczLTgxM2YtNzJlNmI4OGRhMWMwLmpwZw.jpg
 typeimage/jpeg
 size242535
 uri/assets/23146.jpg
 order2
 created2026-02-26 11:11:35
 modified2026-02-26 11:12:04
 3(array)
 id23147
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvNTUxNGM2NzQtN2E0YS00MDQ3LTlmYTgtYjMwOTk1YTAwZDYwLmpwZw.jpg
 typeimage/jpeg
 size320530
 uri/assets/23147.jpg
 order3
 created2026-02-26 11:11:35
 modified2026-02-26 11:12:04
 4(array)
 id23148
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvYzFiMGY4NmEtYjc2Ni00MTljLTllYmEtNmFlZDJlZDdlNzI0LmpwZw.jpg
 typeimage/jpeg
 size267782
 uri/assets/23148.jpg
 order4
 created2026-02-26 11:11:35
 modified2026-02-26 11:12:04
 5(array)
 id23149
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvNGYxZjRkZDgtZGViZC00OWEyLWE5ZmQtZmFjNjQ5ZDNkNjA2LmpwZw.jpg
 typeimage/jpeg
 size284101
 uri/assets/23149.jpg
 order5
 created2026-02-26 11:11:35
 modified2026-02-26 11:12:04
 6(array)
 id23150
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvZDc4NWIxNWMtNmM5Mi00ZGJhLWFjMWUtYTJhOGE2ZDUzNWE0LmpwZw.jpg
 typeimage/jpeg
 size302211
 uri/assets/23150.jpg
 order6
 created2026-02-26 11:11:35
 modified2026-02-26 11:12:04
 7(array)
 id23151
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvNjc4YWFjMDUtZjRjZi00NjExLTkyN2YtMTEyYTdkNmE3N2I2LmpwZw.jpg
 typeimage/jpeg
 size264058
 uri/assets/23151.jpg
 order7
 created2026-02-26 11:11:35
 modified2026-02-26 11:12:04
 8(array)
 id23152
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvYzFiN2U3MDMtYTI2Yi00ZmYyLWE3OTItYzk1MWUzMTE4MzIwLmpwZw.jpg
 typeimage/jpeg
 size267070
 uri/assets/23152.jpg
 order8
 created2026-02-26 11:11:35
 modified2026-02-26 11:12:04
 9(array)
 id23153
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvMWY0NWIzMTgtNmZhZC00MmUwLTk3ODUtZWRmYzQ0ZGJmOWM4LmpwZw.jpg
 typeimage/jpeg
 size368891
 uri/assets/23153.jpg
 order9
 created2026-02-26 11:11:35
 modified2026-02-26 11:12:04
 10(array)
 id23154
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvYWU0ZDk0NTktYzNiMi00YTRhLWE4ZjMtMzczZjlhYzlmMDBhLmpwZw.jpg
 typeimage/jpeg
 size306130
 uri/assets/23154.jpg
 order10
 created2026-02-26 11:11:35
 modified2026-02-26 11:12:04
 11(array)
 id23155
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvMGU4NTk1ZmQtY2FjOC00Zjk5LWE5MTMtNDYyZGM5NmY1OGM1LmpwZw.jpg
 typeimage/jpeg
 size272757
 uri/assets/23155.jpg
 order11
 created2026-02-26 11:11:36
 modified2026-02-26 11:12:04
 12(array)
 id23156
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvMmE1YTkxMjktYjczOS00MmM2LTk4MGUtNzJiY2YzMmM1OGY2LmpwZw.jpg
 typeimage/jpeg
 size262267
 uri/assets/23156.jpg
 order12
 created2026-02-26 11:11:36
 modified2026-02-26 11:12:04
 13(array)
 id23157
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvMGFkMDU4MmQtOTVkZS00NjA3LWI3MWQtYzc1MzdiYzhjNjE4LmpwZw.jpg
 typeimage/jpeg
 size284374
 uri/assets/23157.jpg
 order13
 created2026-02-26 11:11:36
 modified2026-02-26 11:12:04
 14(array)
 id23158
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvMmRjM2IxNjgtMWZlZC00NmRhLTg0NGMtY2IxNzhiNDRjNmYzLmpwZw.jpg
 typeimage/jpeg
 size218813
 uri/assets/23158.jpg
 order14
 created2026-02-26 11:11:36
 modified2026-02-26 11:12:04
 15(array)
 id23159
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvMzNlN2E3NWYtNGRmMy00YWIwLTlmZGEtNGMzMjAwZmY5OTZhLmpwZw.jpg
 typeimage/jpeg
 size284285
 uri/assets/23159.jpg
 order15
 created2026-02-26 11:11:36
 modified2026-02-26 11:12:04
 16(array)
 id23160
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvZWIxMTM3YWUtNjA4MS00NDg4LThhNzUtMTgxZDNmYzNkMGUzLmpwZw.jpg
 typeimage/jpeg
 size776600
 uri/assets/23160.jpg
 order16
 created2026-02-26 11:11:36
 modified2026-02-26 11:12:04
 17(array)
 id23161
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvYjJjYTY4NzEtNGExOC00MTNlLWFkODktYWM5OTcwODA4MjBiLmpwZw.jpg
 typeimage/jpeg
 size772983
 uri/assets/23161.jpg
 order17
 created2026-02-26 11:11:36
 modified2026-02-26 11:12:04
 18(array)
 id23162
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvNzNlMWIzYjMtNGU3YS00NDBhLWIyMTgtY2UyMjJkYmM3MDhkLmpwZw.jpg
 typeimage/jpeg
 size550102
 uri/assets/23162.jpg
 order18
 created2026-02-26 11:11:36
 modified2026-02-26 11:12:04
 19(array)
 id23163
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvZDA5YzM4MTEtMDU2My00N2U2LTg3YjktYzRjNDI4YWZkMzU3LmpwZw.jpg
 typeimage/jpeg
 size765437
 uri/assets/23163.jpg
 order19
 created2026-02-26 11:11:36
 modified2026-02-26 11:12:04
 20(array)
 id23164
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvMDkzZGI0ZmItMDZhYy00YmJjLWI2ODUtNWJiODIxNzE3MzVmLmpwZw.jpg
 typeimage/jpeg
 size730252
 uri/assets/23164.jpg
 order20
 created2026-02-26 11:11:36
 modified2026-02-26 11:12:04
 21(array)
 id23165
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvOTFiNjVkNWUtMGMxZS00NTllLTllNTMtZTk3NTQ5ZDE1NjU0LmpwZw.jpg
 typeimage/jpeg
 size821917
 uri/assets/23165.jpg
 order21
 created2026-02-26 11:11:36
 modified2026-02-26 11:12:04
 22(array)
 id23166
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvMmFiMWE1ZmUtOTQ3OC00YTE3LWIyYzItZWEyZTFhMTIwYTc5LmpwZw.jpg
 typeimage/jpeg
 size795684
 uri/assets/23166.jpg
 order22
 created2026-02-26 11:11:36
 modified2026-02-26 11:12:04
 23(array)
 id23167
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvNGI1M2Q1OGYtZGMzNS00ODY4LTkwNmUtNWMyMDBiYTk2Nzk3LmpwZw.jpg
 typeimage/jpeg
 size670164
 uri/assets/23167.jpg
 order23
 created2026-02-26 11:11:36
 modified2026-02-26 11:12:04
 24(array)
 id23168
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvYWY5ZmE4ZTktNzFjNy00MDczLThmNzUtNjc1ZTlmMGRjZGYxLmpwZw.jpg
 typeimage/jpeg
 size694140
 uri/assets/23168.jpg
 order24
 created2026-02-26 11:11:36
 modified2026-02-26 11:12:04
 25(array)
 id23169
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvYzM1NTMyNDUtNDJhYi00ZDg4LTliNWItZWFlNWFlNjg0MmNiLmpwZw.jpg
 typeimage/jpeg
 size289408
 uri/assets/23169.jpg
 order25
 created2026-02-26 11:11:36
 modified2026-02-26 11:12:04
 26(array)
 id23170
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvZTU3YTIwNzMtOGVjNy00OTAyLThiOTMtMTNmZTZmNjY4Mzc2LmpwZw.jpg
 typeimage/jpeg
 size184861
 uri/assets/23170.jpg
 order26
 created2026-02-26 11:11:36
 modified2026-02-26 11:12:04
 27(array)
 id23171
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvNTIzMmI5MmEtYTI3YS00ZjU0LTgwZTEtYjQyYWQyOGM3NzYyLmpwZw.jpg
 typeimage/jpeg
 size237547
 uri/assets/23171.jpg
 order27
 created2026-02-26 11:11:36
 modified2026-02-26 11:12:04
 28(array)
 id23172
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvM2JlMDE0NWQtMDIyMS00NTQxLTg1YjktODFiMzI2YTA2M2M0LmpwZw.jpg
 typeimage/jpeg
 size633199
 uri/assets/23172.jpg
 order28
 created2026-02-26 11:11:36
 modified2026-02-26 11:12:04
 29(array)
 id23173
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvNzJmMzhhYjYtNmY1ZS00ZTNmLWFlOTMtOTBmNzlkNDk5NWNiLmpwZw.jpg
 typeimage/jpeg
 size304619
 uri/assets/23173.jpg
 order29
 created2026-02-26 11:11:37
 modified2026-02-26 11:12:04
 30(array)
 id23174
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvNmMyMGQ2NDAtNDdhMy00YmUwLWI2MzItNjliYzkwM2JjMDA4LmpwZw.jpg
 typeimage/jpeg
 size288495
 uri/assets/23174.jpg
 order30
 created2026-02-26 11:11:37
 modified2026-02-26 11:12:04
 31(array)
 id23175
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvNzhkYmU3MTQtODAyZi00ZGVmLWE2NzAtYmQzMDQxNTliM2ZiLmpwZw.jpg
 typeimage/jpeg
 size234634
 uri/assets/23175.jpg
 order31
 created2026-02-26 11:11:37
 modified2026-02-26 11:12:04
 32(array)
 id23176
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvYzlmYTFlYmUtMGVmZi00M2Q5LTlmNWItYzE5ZWNjZmM1YTQwLmpwZw.jpg
 typeimage/jpeg
 size208924
 uri/assets/23176.jpg
 order32
 created2026-02-26 11:11:37
 modified2026-02-26 11:12:04
 33(array)
 id23177
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvNjc1ODM4Y2ItNzVlMC00N2EwLThjZjYtNmFkMmEwYTM0NjU2LmpwZw.jpg
 typeimage/jpeg
 size299260
 uri/assets/23177.jpg
 order33
 created2026-02-26 11:11:37
 modified2026-02-26 11:12:04
 34(array)
 id23178
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvZDY5MDc5ZWItMDc1ZS00NDE4LWI2MWQtNjRjZmU3MDY1NzkwLmpwZw.jpg
 typeimage/jpeg
 size205872
 uri/assets/23178.jpg
 order34
 created2026-02-26 11:11:37
 modified2026-02-26 11:12:04
 35(array)
 id23179
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvZWNkNjA2ZGMtOWQxZC00NmFhLTg3YmItZjI2OGNmNTVhOWQ1LmpwZw.jpg
 typeimage/jpeg
 size184308
 uri/assets/23179.jpg
 order35
 created2026-02-26 11:11:37
 modified2026-02-26 11:12:04
 36(array)
 id23180
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvNjViNGZkOTYtMDVmMC00YjVjLTgxYmEtMTc4NzdjYWJkZjkzLmpwZw.jpg
 typeimage/jpeg
 size295265
 uri/assets/23180.jpg
 order36
 created2026-02-26 11:11:37
 modified2026-02-26 11:12:04
 37(array)
 id23181
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvNTBiZjczZWUtZWU1OS00NmIzLWI3ZjctZDEwN2I1NmYzNjE1LmpwZw.jpg
 typeimage/jpeg
 size405726
 uri/assets/23181.jpg
 order37
 created2026-02-26 11:11:37
 modified2026-02-26 11:12:04
 38(array)
 id23182
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvNjJmMjk1NjAtMGVmNy00N2UwLWEwMDAtODQ0YzFmMmI0ZGRlLmpwZw.jpg
 typeimage/jpeg
 size433827
 uri/assets/23182.jpg
 order38
 created2026-02-26 11:11:37
 modified2026-02-26 11:12:04
 39(array)
 id23183
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvZjNiYzQ2MGEtZjAwMC00ZTI0LWJhOGItNDRlOTYyZmM3YzllLmpwZw.jpg
 typeimage/jpeg
 size496690
 uri/assets/23183.jpg
 order39
 created2026-02-26 11:11:37
 modified2026-02-26 11:12:04
 40(array)
 id23184
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvZjBiZWYzMjgtMjE0Ni00NzgxLTg3ZjktMDcwNzJkNzliYzE0LmpwZw.jpg
 typeimage/jpeg
 size514791
 uri/assets/23184.jpg
 order40
 created2026-02-26 11:11:37
 modified2026-02-26 11:12:04
 41(array)
 id23185
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvZDIwZDVhMWEtMWRhNy00OWU5LTkzZGYtNjE5N2NlMTBiNTI5LmpwZw.jpg
 typeimage/jpeg
 size481721
 uri/assets/23185.jpg
 order41
 created2026-02-26 11:11:37
 modified2026-02-26 11:12:04
 42(array)
 id23186
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvZmFmOGQ1ZmMtM2ZkYi00NzlkLWJhYTItZDRhM2M0MGY0NWFhLmpwZw.jpg
 typeimage/jpeg
 size846644
 uri/assets/23186.jpg
 order42
 created2026-02-26 11:11:37
 modified2026-02-26 11:12:04
 43(array)
 id23187
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvZThjYTQ2OGItZDY2OS00NmE0LWIzNDUtYjk5MWM0NjE2NTg4LmpwZw.jpg
 typeimage/jpeg
 size492111
 uri/assets/23187.jpg
 order43
 created2026-02-26 11:11:37
 modified2026-02-26 11:12:04
 44(array)
 id23188
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvMTA2ZDU4NzEtOTZlYi00MjdhLWE5NTYtNTBlOWE2NjIzMzk0LmpwZw.jpg
 typeimage/jpeg
 size907299
 uri/assets/23188.jpg
 order44
 created2026-02-26 11:11:37
 modified2026-02-26 11:12:04
 45(array)
 id23189
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvYWYyZTdlYTgtMzA1ZS00MmI2LTkzYjgtYWU2MGEwODZiZTBkLmpwZw.jpg
 typeimage/jpeg
 size406113
 uri/assets/23189.jpg
 order45
 created2026-02-26 11:11:37
 modified2026-02-26 11:12:04
 46(array)
 id23190
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvNjkwYzFhNDctYzY0Mi00NzhmLTlmM2UtZjExY2VhNjJmNWIxLmpwZw.jpg
 typeimage/jpeg
 size388470
 uri/assets/23190.jpg
 order46
 created2026-02-26 11:11:37
 modified2026-02-26 11:12:04
 47(array)
 id23191
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvYzczNDYwNzUtMDkyNy00ZDJiLTg3MDMtNWI3NDc0MzZmMGRlLmpwZw.jpg
 typeimage/jpeg
 size300590
 uri/assets/23191.jpg
 order47
 created2026-02-26 11:11:37
 modified2026-02-26 11:12:04
 48(array)
 id23192
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvNTNkZDkzNDYtMGYxNi00OWFjLThhMDQtYjZjNjNlNjBjNjgxLmpwZw.jpg
 typeimage/jpeg
 size348841
 uri/assets/23192.jpg
 order48
 created2026-02-26 11:11:38
 modified2026-02-26 11:12:04
 49(array)
 id23193
 modelProperty
 model_id3762
 tagImage
 nameL3RycmViL2xpc3RpbmdzLzQyLzc5LzIzLzY0L3AvZmVkNWZlNzAtNjY3Yi00OTAzLWEyMjktMzQ0YjJmOGJhZjc2LmpwZw.jpg
 typeimage/jpeg
 size340053
 uri/assets/23193.jpg
 order49
 created2026-02-26 11:11:38
 modified2026-02-26 11:12:04
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 2(array)
 Property(array)
 id3712
 brokerage_id76
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id777
 agent_2_id0
 agent_3_id0
 nameExtraordinary Family Home
 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)
 descriptionExtraordinary family home w/ stunning lake view! Perfect for full-time use or vacation get-away. Entertainer's dream home! 3 large decks (Trex decking) great for BBQing while looking at gorgeous Lake Arrowhead. Game room, open floor plan, beamed ceilings. 2 sliding glass doors off of family rm. open up to a beautiful view of the lake. Stunning stone fireplace w/ solid wood mantle. This is a MUST SEE home!
 address27424 Alpen
 address_2
 cityLake Arrowhead
 stateCA
 postal_code92352
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price545000
 price_20
 price_usd545000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1garage
 icon_2office
 icon_3views
 icon_4
 icon_5
 icon_6
 websitehttp://www.therealestateplace.com/property/2326-2/
 meta_titleExtraordinary Family Home | Lake Arrowhead Real Estate | Prime Properties
 meta_description27424 Alpen is a property offered for sale in Lake Arrowhead, CA, USA, presented by Prime Properties
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tourhttp://www.tourfactory.com/1505216
 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, virtual_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:02
 created2016-04-07 10:56:58
 uri/property-detail/3712/27424-alpen-lake-arrowhead-ca-92352-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3712/27424-alpen-lake-arrowhead-ca-92352-usa
 address_concat27424 Alpen Lake Arrowhead CA 92352 USA
 google_maps_query_string27424+Alpen++Lake+Arrowhead+CA+92352+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 545,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty2
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 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)
 id11165
 modelProperty
 model_id3712
 tagImage
 name36037.jpg
 typeimage/jpg
 size3559005
 uri/assets/11165.jpg
 order2895
 created2016-04-07 16:25:28
 modified2016-04-07 16:25:28
 1(array)
 id11166
 modelProperty
 model_id3712
 tagImage
 name36038.jpg
 typeimage/jpg
 size2525853
 uri/assets/11166.jpg
 order2896
 created2016-04-07 16:25:34
 modified2016-04-07 16:25:34
 2(array)
 id11167
 modelProperty
 model_id3712
 tagImage
 name36039.jpg
 typeimage/jpg
 size2800068
 uri/assets/11167.jpg
 order2897
 created2016-04-07 16:25:36
 modified2016-04-07 16:25:36
 3(array)
 id11168
 modelProperty
 model_id3712
 tagImage
 name36040.jpg
 typeimage/jpg
 size3027894
 uri/assets/11168.jpg
 order2898
 created2016-04-07 16:25:38
 modified2016-04-07 16:25:38
 4(array)
 id11169
 modelProperty
 model_id3712
 tagImage
 name36041.jpg
 typeimage/jpg
 size2301281
 uri/assets/11169.jpg
 order2899
 created2016-04-07 16:25:40
 modified2016-04-07 16:25:40
 5(array)
 id11170
 modelProperty
 model_id3712
 tagImage
 name36042.jpg
 typeimage/jpg
 size2420895
 uri/assets/11170.jpg
 order2900
 created2016-04-07 16:25:42
 modified2016-04-07 16:25:42
 6(array)
 id11171
 modelProperty
 model_id3712
 tagImage
 name36043.jpg
 typeimage/jpg
 size2423264
 uri/assets/11171.jpg
 order2901
 created2016-04-07 16:25:44
 modified2016-04-07 16:25:44
 7(array)
 id11172
 modelProperty
 model_id3712
 tagImage
 name36044.jpg
 typeimage/jpg
 size2540978
 uri/assets/11172.jpg
 order2902
 created2016-04-07 16:25:45
 modified2016-04-07 16:25:45
 8(array)
 id11173
 modelProperty
 model_id3712
 tagImage
 name36045.jpg
 typeimage/jpg
 size1916356
 uri/assets/11173.jpg
 order2903
 created2016-04-07 16:25:49
 modified2016-04-07 16:25:49
 9(array)
 id11174
 modelProperty
 model_id3712
 tagImage
 name36046.jpg
 typeimage/jpg
 size4040003
 uri/assets/11174.jpg
 order2904
 created2016-04-07 16:25:51
 modified2016-04-07 16:25:51
 User(array)
 0(array)
 id969
 typeAgent
 brokerage_id76
 email[email protected]
 password576f947779f7edcccdd25932c65b363f8265be2d
 recover_hash
 first_nameJeff
 last_namePerlis
 title
 dre_num
 phone909-337-7653
 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_nameJeff Perlis
 uri/agent-detail/969/jeff-perlis
 profile_complete(true)
 UsersProperty(array)
 id726
 user_id969
 property_id3712
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id1987
 property_id3712
 property_feature_id4
 1(array)
 id9
 nameOffice
 additional(false)
 created2016-04-07 14:03:21
 modified2016-04-07 14:03:21
 PropertiesPropertyFeature(array)
 id1988
 property_id3712
 property_feature_id9
 2(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id1989
 property_id3712
 property_feature_id14
 Topic(empty)
 3(array)
 Property(array)
 id3731
 brokerage_id113
 created_by_user_id0
 order1
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameThe Cliffs at Walnut Cove
 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)
 descriptionDon't miss this opportunity to own one of the most affordable properties in The Cliffs at Walnut Cove. The thoughtful design of this townhome offers a seamless flow of outdoor and indoor living spaces. The floor plan is open and bright with plenty of windows to take in the views. The home is situated overlooking the park like common area which includes a pond and stream. Being situated in the "The Meadows" townhome enclave this home offers the convenience of low maintenance living.
 address14 Foxbridge Way
 address_2
 cityArden
 stateNorth Carolina
 postal_code28704
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price927500
 price_20
 price_usd927500
 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_feet3105
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://www.mountainoakproperties.com/property/nc/arden/28704/the-cliffs-at-walnut-cove/14-foxbridge-way/57106fbd30e08a6f7700000d/
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude35.455807
 longitude35.455807
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 10:33:01
 created2016-04-15 11:19:11
 uri/property-detail/3731/14-foxbridge-way-arden-north-carolina-28704-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3731/14-foxbridge-way-arden-north-carolina-28704-usa
 address_concat14 Foxbridge Way Arden North Carolina 28704 USA
 google_maps_query_string14+Foxbridge+Way++Arden+North+Carolina+28704+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 927,500
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty3
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-04-15
 overridden_brokerage_nameMountain Oak Properties
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id113
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2356566
 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
 nameMountain Oak Properties
 broker_of_record_name
 short_nameMountain Oak Properties
 usernameMountainOakProperties
 passwordde66630c678d1e389d6693754f7b541ad5e428f5
 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
 descriptionMountain Oak Properties is the exclusive representative for Leverage Global Partners in Asheville, North Carolina, USA. As Western North Carolina's premier real estate firm, Mountain Oak Properties was founded on the principle that individualized service and attention define the real estate experience. With over three decades of combined sales and marketing experience – both in the residential and development segments - our founding partners are completely committed to building Western North Carolina's leading resource for buying and selling real estate in Western North Carolina. Mountain Oak Properties’ agents live and work in some of the areas most popular communities. Our trained team is dedicated, reliable, honest and resourceful. Whether you are prepared to purchase your first home, are relocating to the area, buying a piece of property or downsizing, we want to be your exclusive resource for all things real estate. Our company was founded in 2013 by three ambitious partners, Sean McLaughlin, Kevin Scarmack, and Mitch Miller, committed to creating a premium customer service experience for clients who trust in our mission. Individually, each partner has extensive experience in the development segment of the business. Sean and Mitch were previously employed at The Cliffs Communities, an exclusive set of golf communities in North and South Carolina. Kevin worked for Land Resource Companies, who developed several high-end communities throughout the Southeast. We specialize in working with clients from around the world who are looking to retire or buy a second home in the Carolinas.
 communities
 websitehttp://www.mountainoakproperties.com/
 address32 All Souls Crescent
 address_2Suite 202
 cityAsheville
 stateNC
 full_stateNorth Carolina
 countryUSA
 marketAsheville
 market_2
 postal_code28803
 phone (828) 318-8801
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameSean McLaughlin, Kevin Scarmack, Mitch Miller
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwners
 contact_dre_num
 contact_quoteYour Resource for All Things Real Estate in Western North Carolina.
 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_filename113.jpg
 logo_filename113.png
 contact_image_filename113.jpg
 all_properties_link_image_filename113.jpg
 all_properties_linkhttp://www.mountainoakproperties.com/our-listings/
 video_embed_code<iframe width="560" height="315" src="//www.youtube.com/embed/Ghik1qR1cDI" frameborder="0" allowfullscreen></iframe>
 contact_video_embed_code
 meta_titleAsheville Real Estate | Mountain Oak Properties | Leverage Global Partners
 meta_descriptionMountain Oak Properties is the exclusive representative for Leverage Global Partners in Asheville, North Carolina, USA.
 meta_keywordsMountain Oak Properties, Asheville Real Estate, Kevin Scarmack, Mitch Miller, Sean McLaughlin, Asheville North Carolina, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-04-23 13:20:21
 modified2016-04-08 16:34:09
 dre_num012345
 uri/brokerage-detail/113/mountain-oak-properties
 website_shortwww.mountainoakproperties.com
 name_with_locationMountain Oak 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)
 id20853
 modelProperty
 model_id3731
 tagImage
 nameIMG_2861_tonemapped.jpg
 typeimage/jpeg
 size6694766
 uri/assets/20853.jpg
 order0
 created2016-04-15 11:19:07
 modified2016-04-15 11:23:18
 1(array)
 id20854
 modelProperty
 model_id3731
 tagImage
 nameIMG_2862_tonemapped.jpg
 typeimage/jpeg
 size6176536
 uri/assets/20854.jpg
 order1
 created2016-04-15 11:19:51
 modified2016-04-15 11:23:18
 2(array)
 id20855
 modelProperty
 model_id3731
 tagImage
 nameIMG_2864_tonemapped.jpg
 typeimage/jpeg
 size6643030
 uri/assets/20855.jpg
 order2
 created2016-04-15 11:20:07
 modified2016-04-15 11:23:18
 3(array)
 id20856
 modelProperty
 model_id3731
 tagImage
 nameIMG_2867_tonemapped.jpg
 typeimage/jpeg
 size7066213
 uri/assets/20856.jpg
 order3
 created2016-04-15 11:20:21
 modified2016-04-15 11:23:18
 4(array)
 id20857
 modelProperty
 model_id3731
 tagImage
 nameIMG_2875_tonemapped.jpg
 typeimage/jpeg
 size6443929
 uri/assets/20857.jpg
 order4
 created2016-04-15 11:20:34
 modified2016-04-15 11:23:18
 5(array)
 id20858
 modelProperty
 model_id3731
 tagImage
 nameIMG_2885_tonemapped.jpg
 typeimage/jpeg
 size7111792
 uri/assets/20858.jpg
 order5
 created2016-04-15 11:20:49
 modified2016-04-15 11:23:18
 User(array)
 0(array)
 id348
 typeAgent
 brokerage_id113
 email[email protected]
 password10212efdb1372fb08d645dd65d8b94b5917a88e3
 recover_hash
 first_nameMitch
 last_nameMiller
 title
 dre_num
 phone828-273-0671
 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_nameMitch Miller
 uri/agent-detail/348/mitch-miller
 profile_complete(true)
 UsersProperty(array)
 id136
 user_id348
 property_id3731
 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)
 id4398
 property_id3731
 property_feature_id14
 Topic(empty)
- sidebar_brokerages(array)
 0(array)
 Brokerage(array)
 id56
 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
 WOEID2513768
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameJ. Rockcliff Realtors
 broker_of_record_name
 short_nameJ Rockcliff Realtors
 usernameJRockcliffWC
 password14a01d92dcd7b0cd5ad6f01dca84a3e626414a24
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionJ. Rockcliff Realtors is the exclusive representative for Leverage Global Partners in Walnut Creek, Concord, Pleasant Hill, Martinez, Alamo, Diablo and Clayton, California. J. Rockcliff Realtors is one of the fastest growing real estate companies in California and has distinguished itself as The East Bay’s Premier Real Estate Company. With offices located in <a href="../../../brokerage-detail/55/J.-Rockcliff-Realtors">LaMorinda</a> (Lafayette, Moraga, Orinda), <a href="../../../brokerage-detail/56/J.-Rockcliff-Realtors">Walnut Creek</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Danville</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Blackhawk</a>, and <a href="../../../brokerage-detail/57/J.-Rockcliff-Realtors">Pleasanton/Dublin/Livermore</a>, experienced Realtors can assist with your home buying or home selling needs in any real estate market. Looking for bank owned properties? We can help. J. Rockcliff Realtors’ Relocation Department provides home buying or home selling assistance around the corner or around the world. As members of Worldwide ERC (Employee Relocation Council), J. Rockcliff handles many corporate relocation moves as well. When listing or selling your home, you can rest assured that J. Rockcliff Realtors can provide the best real estate agents (Realtors) to help you buy or sell your home using the most innovative tools available, including; the finest marketing, the most advanced technology and resources unmatched by any other firm. J. Rockcliff Realtors is strategically positioned to be the company of choice now and in the future. J. Rockcliff Realtors is proudly licensed with the California Bureau of Real Estate - License #01793729. J.Rockcliff also has offices in <a href="../../../brokerage-detail/55/J.-Rockcliff-Realtors">Lafayette</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Danville</a>, and <a href="../../../brokerage-detail/57/J.-Rockcliff-Realtors">Pleasanton</a>.
 communitiesWalnut Creek Concord Pleasant Hill Martinez Clayton Alamo Diablo
 websitehttp://www.rockcliff.com/
 address1700 N. Main Street
 address_2
 cityWalnut Creek
 stateCA
 full_stateCalifornia
 countryUSA
 marketWalnut Creek
 market_2
 postal_code94596
 phone(925) 280-8500
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJeff Sposito
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename56.jpg
 logo_filename56.jpg
 contact_image_filename56.jpg
 all_properties_link_image_filename56.jpg
 all_properties_linkhttp://www.rockcliff.com/Rockcliff-Listings#g=2a4505b8-af60-49e2-b0c4-b980136a5da0
 video_embed_code
 contact_video_embed_code
 meta_titleWalnut Creek Real Estate | J. Rockcliff Realtors | Leverage Global Partners
 meta_descriptionJ. Rockcliff Realtors is the exclusive representative for Leverage Global Partners in Walnut Creek, CA, USA.
 meta_keywordsJ. Rockcliff Realtors, Walnut Creek Real Estate, Leverage Global Partners, Jeff Sposito
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-09-26 14:52:34
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/56/j-rockcliff-realtors
 website_shortwww.rockcliff.com
 name_with_locationJ. Rockcliff Realtors
 Logo(array)
 id2398
 modelBrokerage
 model_id56
 tagLogo
 name56.jpg
 typeimage/jpg
 size659806
 uri/assets/2398.jpg
 order0
 created2016-03-30 11:39:04
 modified2016-03-30 11:39:04
 1(array)
 Brokerage(array)
 id99
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID12771965
 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
 nameFusilier Realty Group
 broker_of_record_name
 short_nameFusilier Realty Group
 usernameFusilierRealtyGroup
 passwordc2469a64cda51e8b0ea254a8f5426f218c65936d
 password_reset_hash
 monthly_invoice_amount500.00
 monthly_invoice_start_date2014-03-01
 monthly_invoice_end_date2015-02-28
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionFusilier Realty Group is the exclusive representative for Leverage Global Partners in Orlando, Florida, USA. More information coming soon! 
 communitiesorlando
 websitehttp://www.realtygroupfl.com/
 address9145 Narcoossee Road
 address_2Suite 102
 cityOrlando
 stateFL
 full_stateFlorida
 countryUSA
 marketOrlando
 market_2
 postal_code32827
 phoneOffice: (407) 281-8455
 phone_2Fax: (407) 218-7422
 phone_3
 wide_contact_image(false)
 contact_nameSteve Fusilier and Keith Race
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBrokers-in-Charge
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[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_filename99.jpg
 logo_filename99.jpg
 contact_image_filename99.jpg
 all_properties_link_image_filename99.jpg
 all_properties_linkhttp://www.realtygroupfl.com/purchase-residential-real-estate-lake-nona-orlando/
 video_embed_code
 contact_video_embed_code
 meta_titleOrlando Real Estate | Fusilier Realty Group | Leverage Global Partners
 meta_descriptionFusilier Realty Group is the exclusive representative for Leverage Global Partners in Orlando, Florida, USA.
 meta_keywordsOrlando Real Estate, Fusilier Realty Group, Leverage Global Partners, steve fusilier, keith race
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-02-24 16:37:04
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/99/fusilier-realty-group
 website_shortwww.realtygroupfl.com
 name_with_locationFusilier Realty Group
 Logo(array)
 id2533
 modelBrokerage
 model_id99
 tagLogo
 name99.jpg
 typeimage/jpg
 size23522
 uri/assets/2533.jpg
 order0
 created2016-03-30 11:40:53
 modified2016-03-30 11:40:53
 2(array)
 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
 Logo(array)
 id2878
 modelBrokerage
 model_id220
 tagLogo
 name220.jpg
 typeimage/jpg
 size190861
 uri/assets/2878.jpg
 order0
 created2016-03-30 11:44:53
 modified2016-03-30 11:44:53
 3(array)
 Brokerage(array)
 id63
 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_id1
 WOEID12798239
 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
 nameLawrence Realty
 broker_of_record_name
 short_nameLawrence Realty
 usernameLawrenceRealty
 passwordf19b510a3b7103cacaf2581678aa4565be13bf0a
 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
 descriptionLawrence Realty is the exclusive representative for Leverage Global Partners in Squaw Valley, Alpine Meadows, and Martis Camp, California, USA. Representing Buyers and Sellers in the niche markets of Squaw Valley, Alpine Meadows and Martis Camp. Lawrence Realty is a family owned and operated real estate business located in Squaw Valley, (Lake Tahoe) California. Roland “Larry” Lawrence moved to Squaw Valley in 1969, following his love of the mountains and skiing. He began selling real estate in 1974, became a broker two years later and started Lawrence Realty in 1985. As part of the real estate process, Larry provides a wealth of local knowledge and expertise empowering his clients to make educated decisions within the market place. Lawrence Realty sells residential real estate predominantly in the niche markets of Squaw Valley, the adjacent valley Alpine Meadows, and the nearby private community of Martis Camp. Squaw Valley, home to the world renowned ski area, Squaw Valley USA, along with its sister mountain in the adjacent valley, Alpine Meadows, provide some of the nation’s premiere skiing and riding. The real estate market within these communities ranges from high end ski-in/ski-out homes, to mountain chalets and condominiums in prime locations. Value is largely driven by views, location and accessibility as it relates to the ski slopes. Lawrence Realty, a long time market leader, assists their clientele as they evaluate their priorities in buying a vacation home and guide them through a smooth transaction process. Martis Camp, a private golf and ski community of great distinction in the Tahoe area, has emerged in recent years. Lawrence Realty has been involved in Martis Camp since the beginning, representing buyers as they walked the developer lots, contemplating the factors of sun exposure, lot size, view and proximity to the array of top notch amenities Martis Camp offers. Lawrence Realty has continued to participate in the Martis Camp real estate market representing both buyers and sellers of homes and lots. Larry Lawrence is an active member of the Martis Camp community, both as a property owner and golf member, offering another level of insight to his clientele. Larry and his team members each contribute their own strengths to Lawrence Realty resulting in a dynamic, well rounded group who is well known and well respected in the local community and the broader San Francisco Bay Area client base. Over the years, the referral business amongst clientele has continued to empower this real estate team as they strive to stay at the cutting edge of technology in the ever advancing real estate market.
 communitiesMartis Camp Squaw Valley Alpine Meadows Lake Tahoe
 websitehttp://www.lawrencerealtysquawvalley.com/
 addressP.O. Box 2365
 address_2
 cityOlympic Valley
 stateCA
 full_stateCalifornia
 countryUSA
 marketSquaw Valley, Lake Tahoe
 market_2Martis Camp
 postal_code96146
 phone(530) 583-1529
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameRoland “Larry” Lawrence
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-larry-lawrence-president-lawrence-realty/
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quoteI invite you to contact me personally about Martis Camp and Squaw Valley, Lake Tahoe 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_filename63.jpg
 logo_filename63.jpg
 contact_image_filename63.jpg
 all_properties_link_image_filename63.jpg
 all_properties_linkhttp://www.lawrencerealty.com/real-estate-featured/
 video_embed_code
 contact_video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/xtjgpjyC-Mwvk3CWK.js"></script>
 meta_titleMartis Camp and Squaw Valley Real Estate | Lawrence Realty | Leverage Global Partners
 meta_descriptionLawrence Realty is the exclusive representative for Leverage Global Partners in Martis Camp and Squaw Valley, CA, USA.
 meta_keywordsSquaw Valley, Lawrence Realty, squaw valley real estate, squaw valley California real estate, martis camp real estate, Larry Lawrence, 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-10-17 17:48:05
 modified2016-10-24 09:54:24
 dre_num012345
 uri/brokerage-detail/63/lawrence-realty
 website_shortwww.lawrencerealtysquawvalley.com
 name_with_locationLawrence Realty
 Logo(array)
 id2419
 modelBrokerage
 model_id63
 tagLogo
 name63.jpg
 typeimage/jpg
 size910599
 uri/assets/2419.jpg
 order0
 created2016-03-30 11:39:25
 modified2016-10-24 09:54:24
- sidebar_locations(array)
 0(array)
 Location(array)
 id93
 parent_id8
 brokerage_id122
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameGreensboro, NC, USA
 short_nameGreensboro, NC, USA
 group_index
 latitude36.072636
 longitude-79.791977
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-05 11:25:13
 modified2016-04-05 11:25:13
 timezoneAmerica/New_York
 population280000
 uri/locations/view/93/greensboro-nc-usa
 tile_nameGreensboro, NC, USA
 Brokerage(array)
 id122
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2414469
 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
 nameTyler Redhead & McAlister Real Estate
 broker_of_record_name
 short_nameTyler Redhead & McAlister Real Estate
 usernameTylerRedheadMcAlister
 passwordd9a1873a0974fea384d9263a2659236f46149e30
 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
 descriptionTyler Redhead & McAlister Real Estate is the exclusive representative for Leverage Global Partners in Greensboro, Winston Salem, High Point, Summerfield, Oak Ridge, Kernersville, and Jamestown, North Carolina, USA. More information coming soon!
 communitiesGreensboro Winston Salem High Point Summerfield Oak Ridge Kernersville Jamestown
 websitehttp://www.trmrealestate.com/
 address1401 Sunset Drive, Suite 100
 address_2
 cityGreensboro
 stateNC
 full_stateNorth Carolina
 countryUSA
 marketGreensboro
 market_2
 postal_code27408
 phone(336) 274-1717
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameMarti Tyler, Alec McAlister & Katie Redhead
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePartners
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Greensboro real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3[email protected]
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename122.jpg
 logo_filename122.jpg
 contact_image_filename122.jpg
 all_properties_link_image_filename122.jpg
 all_properties_linkhttp://www.trmrealestate.com/listings
 video_embed_code
 contact_video_embed_code
 meta_titleGreensboro Real Estate | Tyler Redhead & McAlister Real Estate | Leverage Global Partners
 meta_descriptionTyler Redhead & McAlister Real Estate is the exclusive representative for Leverage Global Partners in Greensboro, North Carolina, USA.
 meta_keywordsGreensboro Real Estate, Tyler Redhead & McAlister Real Estate, Leverage Global Partners, Alec McAlister
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-05-19 09:02:14
 modified2016-04-08 16:34:09
 dre_num012345
 uri/brokerage-detail/122/tyler-redhead-mcalister-real-estate
 website_shortwww.trmrealestate.com
 name_with_locationTyler Redhead & McAlister Real Estate
 Image(array)
 id3027
 modelLocation
 model_id93
 tagImage
 namegreensboro.jpg
 typeimage/jpeg
 size145338
 uri/assets/3027.jpg
 order0
 created2016-04-05 11:25:06
 modified2016-04-05 11:25:13
 1(array)
 Location(array)
 id94
 parent_id9
 brokerage_id192
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameBullhead City, AZ, USA
 short_nameBullhead City, AZ, USA
 group_index
 latitude35.135941
 longitude-114.528595
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-05 11:28:06
 modified2016-04-05 11:28:06
 timezoneAmerica/Phoenix
 population40000
 uri/locations/view/94/bullhead-city-az-usa
 tile_nameBullhead City, AZ, USA
 Brokerage(array)
 id192
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2371675
 timezoneUS/Mountain
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameUS Southwest
 broker_of_record_name
 short_nameUS Southwest
 usernameUSSouthwestLLC
 passwordaca3f804a48f1447c4a6fd356b1f302279862050
 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
 descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, Mohave Valley, Fort Mohave AZ, USA. US Southwest is a boutique real estate company comprised of like minded pro-fessionals whose mission is to provide the best professional service so their clients can make informed decisions to achieve their goals. The talent and depth within the company is unmatched in Mohave County. Several of the key players at US Southwest have managed a business or owned their own busi- ness. The combined talents provide a unique business platform in which diversity, collaboration, team work, and professionalism, foster a business perspective and environment that generates creativity and productivity, and ultimately, successful results for clients. US Southwest has the capability, expertise and area relationships to assist its clients in any type of real estate endeavor. Its founders, Ann L. Pettit and Ray W. Jackson III, have worked in every kind of real estate enterprise for over 30 years in Northwestern Arizona and are perceived as innovative leaders and pioneers of the industry. They have a relationship building philosophy and their motto is - Your Success is Our Success.
 communitiesBullhead City Fort Mohave Mohave Valley
 websitehttp://ussw.net/
 address3767 Highway 95
 address_2
 cityBullhead City
 stateAZ
 full_stateArizona
 countryUSA
 market
 market_2
 postal_code86442
 phone(928) 763-2288
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameAnn Pettit
 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_filename192.jpg
 logo_filename192.jpg
 contact_image_filename192.png
 all_properties_link_image_filename192.jpg
 all_properties_linkhttp://ussw.net/wolfnet-properties
 video_embed_code
 contact_video_embed_code
 meta_titleBullhead City Real Estate | US Southwest | Leverage Global Partners
 meta_descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, AZ, USA.
 meta_keywordsUS Southwest LLC, Bullhead city real estate, arizona real estate, ann pettit, bullhead city, leverage global partners, Fort Mohave, Mohave Valley
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-02-13 10:18:22
 modified2016-04-08 16:34:20
 dre_num012345
 uri/brokerage-detail/192/us-southwest
 website_shortussw.net
 name_with_locationUS Southwest
 Image(array)
 id3028
 modelLocation
 model_id94
 tagImage
 nameBullhead city.jpg
 typeimage/jpeg
 size140053
 uri/assets/3028.jpg
 order0
 created2016-04-05 11:25:58
 modified2016-04-05 11:28:06
 2(array)
 Location(array)
 id95
 parent_id9
 brokerage_id107
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameMarin County, CA, USA
 short_nameMarin County, CA, USA
 group_index
 latitude37.920559
 longitude-122.508987
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionWhy so many are lured to this spectacular county.
 long_descriptionMarin County is one of the most coveted places to live in the Bay Area. With the Golden Gate Bridge as its gateway, it’s flanked by the Bay and Pacific and highlighted by lofty Mt. Tamalpais. Incredibly, 80% of the county is designated as Open Space. Amidst majestic redwoods and captivating views, outdoor lovers enjoy a bounty of activities. Families flock here for its excellent schools, abundant sunshine, and friendly, welcoming communities. Residents enjoy numerous Farmers Markets, exceptional restaurants and a variety of options for active living. Marin offers the amenities of big city living just minutes away but with the feel of small town America.
 created2016-04-05 11:28:35
 modified2016-04-14 13:32:01
 timezoneAmerica/Los_Angeles
 population260750
 uri/locations/view/95/marin-county-ca-usa
 tile_nameMarin County, CA, USA
 Brokerage(array)
 id107
 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_properties3
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID12587690
 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
 nameVanguard Properties
 broker_of_record_name
 short_nameVanguard Properties
 usernameVanguardMarin
 passworde8045814d4cc920c82b1497cdc9288d62d2c8c16
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename107.pdf
 active(true)
 lead_in
 short_description
 descriptionVanguard Properties is the exclusive representative for Leverage Global Partners in Marin County, California, USA. For close to 30 years, Vanguard Properties has offered impeccable service to buyers and sellers throughout the Bay Area. We are proud of our team of professionals, who are service-driven and passionately share in your goal to find the home that’s right for you in the manner that fits your lifestyle. COMMITMENT At Vanguard, we stake our reputation on every relationship we create. Your unique client experience will be built on the high degree of professionalism and on our commitment to delivering service tailored to your individual needs, at every point of contact. With Vanguard by your side, you can feel confident that all aspects of your development are in good hands. We are proud to have provided developers with expert service for over twenty years now, including buyer insights that come by working with discerning buyers in highly dynamic markets. But we are only as good as the service we offer to the valued clients we work with today. They demand nothing but the best. Fortunately, we're in a position to deliver. DISTINCTION VVanguard brings exceptional homes to market, consistently and with outstanding results, under the guidance of some of the most respected professionals in the business. Our founder, James Nunemacher, is within the top 1% of real estate sales in the nation, and an acknowledged expert in the market. His exacting standards set the tone for everything we do. Simply put, no one is more qualified than Vanguard. This was true when we opened for business selling residential real estate. It has never been truer today, as our services have grown to encompass every aspect of the process of developing and marketing the most sought-after homes and developments in one of the most competitive markets. SERVICE Vanguard understands what discerning buyers and sellers are looking for, and equally importantly, what they are not. As your trusted partner, we will review and advise on every aspect of your home, from floor plans to finishing touches. Our instinct for detail may result in suggestions that surprise you. MARKETING Quality homes may be timeless. Marketing, however, demands the ability to match the leading-edge of customer expectations and stay several steps ahead of your competition. Vanguard's leadership is no more obvious than in the field of marketing. We will develop fresh, innovative strategies for you, incorporating a keen sense of brand-identity and integrating the technology that drives the housing market today. Your home is much more than simply brick and mortar. It is an investment upon which you expect the highest returns. With Vanguard's marketing acumen you can be confident that your home-buying audience is appropriately targeted and your return on investment is fully realized.
 communitiesmarin county
 websitehttp://vanguardsf.com/
 address770 Tamalpais Drive, #306
 address_2
 cityCorte Madera Town Center
 stateCA
 full_stateCalifornia
 countryUSA
 marketMarin County
 market_2
 postal_code94925
 phone(415) 886-8171
 phone_2Fax: (415) 886-8172
 phone_3
 wide_contact_image(false)
 contact_nameKevin Patsel
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-kevin-patsel-vanguard-properties/
 contact_big_profile_link_text
 contact_titleSales 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_filename107.jpg
 logo_filename107.jpg
 contact_image_filename107.jpg
 all_properties_link_image_filename107.jpg
 all_properties_linkhttp://vanguardsf.com/VGlistings.php
 video_embed_code
 contact_video_embed_code
 meta_titleMarin County Real Estate | Vanguard Properties | Leverage Global Partners
 meta_descriptionVanguard Properties is the exclusive representative for Leverage Global Partners in Marin County, California, USA.
 meta_keywordsMarin County Real Estate, Vanguard Properties, Leverage Global Partners, James Nunemacher
 login_message_counter2
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-03-28 09:32:44
 modified2016-04-08 16:34:09
 dre_num012345
 uri/brokerage-detail/107/vanguard-properties
 website_shortvanguardsf.com
 name_with_locationVanguard Properties
 Image(array)
 id3029
 modelLocation
 model_id95
 tagImage
 name107.jpg
 typeimage/jpeg
 size121461
 uri/assets/3029.jpg
 order0
 created2016-04-05 11:28:07
 modified2016-04-14 13:32:01
 3(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
 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
 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
- location_properties(empty)
- main_article(empty)
- brokerage(array)
 Brokerage(array)
 id172
 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
 WOEID12590355
 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
 nameVirginia Country Real Estate, Inc.
 broker_of_record_name
 short_nameVirginia Country Real Estate, Inc.
 usernameVirginiaCountryRealEstate
 password84b9dfec8ae16d163a095a6a2238dad66090eea2
 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
 descriptionVirginia Country Real Estate, Inc. of Gloucester, VA is the exclusive representative of Leverage Global Partners in the Coastal Virginia Region of the Chesapeake Bay; serving the counties of Gloucester, Mathews, and Middlesex, including Gloucester Courthouse, Mathews Courthouse, Gloucester Point, Hayes, Ordinary, Gwynns Island, Cobbs Creek, North, Moon, Urbana, Deltaville, Hartfield, within the Middle Peninsula of Chesapeake Bay, VA, USA. Masters in the Art of Real Estate Our focus at Virginia Country Real Estate has always been and continues to be bringing buyers and sellers together for an enjoyable experience. We take pride in a reputation for quality customer & client service dating back to 1982, when our company was established. “WE CARE!”- At Virginia Country Real Estate, these words are more than a slogan. We care about the quality of our service and results we deliver to our clients. We built our business on this philosophy, making our firm the best choice for luxury Real Estate in the market area. Our skilled sales associates are supported by a comprehensive team, powerful promotion, and exclusive marketing system. Virginia Country’s home buyers and sellers can be confident they are working with a company that takes pride in their business. Virginia Country sales associates work hard to be the best. They know the real estate business and they know the local markets. Furthermore, our sales associates are people oriented professionals who are actively involved in serving their community through civic organizations, youth sports, charities, foundations, service boards, and other aspects. They are committed to understanding clients and satisfying their client’s needs at every step of a transaction. It takes in-depth knowledge and highly developed skills to succeed at being the best we can be; therefore professional education receives a high priority at Virginia Country Real Estate. Our Master Buyer’s and Seller’s Service Systems provide a guide for our associates to help their customers and clients through the complex process of buying and selling real estate. Our sales associates are equipped with the most effective tools available anywhere in the home and property industries; real estate tools designed to communicate and get results. Through the Master Service System, Virginia Country Real Estate’s sales associates develop detailed client action plans, backed by our Service Guarantee, to help sell homes even in the most challenging market conditions. Our prestigious Master Rewards Program provides additional marketing and advertising resources for select properties. Buyers can be assured A Masters Reward Home is in market condition and is priced appropriately. To meet the needs of luxury properties, we offer our Estate and Elite Marketing System with an array of expanding features for promotion of luxury and waterfront properties. We welcome you to join us in Coastal Virginia by the Chesapeake Bay. A place made for lovers of fishing, sailing, boating, history, country roads, peaceful living, quaint villages and towns. Coastal Virginia is also perfect for those who seek to be close to the pulse of the city, where all can enjoy shopping, dining, colleges and universities in nearby Williamsburg, Newport News, Richmond, and Virginia Beach. We are ideally located in a peaceful and somewhat “undiscovered” niche of the Chesapeake Bay Region you will want to call home. Contact us for more information or visit our website to learn more about our wonderful state of Virginia, with the motto“ Virginia is for Lovers” and discover Gloucester, a piece of heaven along the Chesapeake Bay and Rivers Region known as “The Land of Life worth Living” See You Soon! Jeanne P. Hockaday Principal Broker and Owner Omega Tau Rho Time Honored Real Estate Fraternity CRB, CRS, GRI, ABR, EPRO, SFR My 42 years of experience in a leadership position have given me a solid foundation to guide our associates and provide them with the knowledge and training necessary to deliver top notch service to our clients. Throughout my career, I have been an active participant in the National Association of Realtors, Industry Conventions, and Political Action Committees. I have served at the state level of Virginia Association of Realtor as Director and member of the Virginia Managers Council. In addition I held the office of President for three terms as the leader of the Chesapeake Bay and Rivers Association of Realtors. Currently, I serve on the Virginia State Appeals Board and hold membership in the National Association of Housing and Building. My education experience includes studies at the: University of Mississippi, Christopher Newport University, a comprehensive list of Real Estate related courses as well as earned Professional designations and certifications. Community service and involvement is paramount to me and to Virginia Country Real Estate. I am proud to be a Paul Harris Fellow Rotarian, member of the Chamber of Commerce, contributor and supporter of numerous service organizations, to include among them the Gloucester Community Foundation. The “WE CARE” approach to business is far more than a slogan to us; it’s a way of doing business. It is a pledge practiced at Virginia Country Real Estate every day for every home and property we sell. We believe this philosophy will continue to help us lead the way to offering services that keep pace with the changing needs of the real estate market, such as our association with Leverage Global Partners. It’s a pledge that we will remain the very best choice in the real estate business to serve our Luxury Home market. We look forward to serving you and working with you to achieve meeting your Real Estate needs.
 communitiesGloucester County Mathews County Middlesex County Gloucester Courthouse Mathews Courthouse Gloucester Point Hayes Ordinary Gwynns Island Cobbs Creek North Moon Urbanna Deltaville Hartfield Middle Peninsula of Chesapeake Bay
 websitehttp://virginiacountryrealestate.com/
 address3765 George Washington Memorial Highway
 address_2P.O. Box 482
 cityOrdinary
 stateVA
 full_stateVirginia
 countryUSA
 marketGloucester, Chesapeake Bay's Middle Peninsula Region
 market_2
 postal_code23131
 phone(804) 642-6126
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJeanne Hockaday
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident/Principal Broker
 contact_dre_num
 contact_quoteI invite you to contact me personally about Chesapeake Bay's Middle Peninsula Region.
 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_filename172.jpg
 logo_filename172.jpg
 contact_image_filename172.JPG
 all_properties_link_image_filename172.JPG
 all_properties_linkhttp://virginiacountryrealestate.com/listings
 video_embed_code
 contact_video_embed_code
 meta_titleChesapeake Bay's Middle Peninsula Real Estate⎜Virginia Country Real Estate, Inc.⎜Leverage Global Partners
 meta_descriptionVirginia Country Real Estate, Inc. is the exclusive representative for Leverage Global Partners in Gloucester County, VA, USA.
 meta_keywordsVirginia Country Real Estate, Inc., Jeanne Hockaday, Gloucester County Real Estate, Leverage Global Partners, Mathews County Real Estate, Middlesex County Real Estate, Gloucester Courthouse Real Estate, Mathews Courthouse Real Estate, Gloucester Point Real Estate, Hayes Real Estate, Ordinary Real Estate, Gwynns Island Real Estate, Cobbs Creek Real Estate, North Real Estate, Moon Real Estate, Urbanna Real Estate, Deltaville Real Estate, Hartfield Real Estate, Middle Peninsula of Chesapeake Bay Real Estate, Virginia 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-11-03 09:43:08
 modified2016-04-08 16:34:20
 dre_num012345
 uri/brokerage-detail/172/virginia-country-real-estate-inc
 website_shortvirginiacountryrealestate.com
 name_with_locationVirginia Country Real Estate, Inc. - Gloucester, Chesapeake Bay, VA
 AccountExecutive(array)
 id235
 typeAccountExecutive
 brokerage_id0
 email[email protected]
 passworde5cc5a96287695cf8b7cace1463b1699895dcf92
 recover_hash
 first_nameAlec
 last_nameMegerdichian
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2020-12-23 09:21:42
 created2016-04-14 15:40:35
 notified(false)
 full_nameAlec Megerdichian
 uri/agent-detail/235/alec-megerdichian
 profile_complete(true)
 Logo(array)
 id2746
 modelBrokerage
 model_id172
 tagLogo
 name172.jpg
 typeimage/jpg
 size232207
 uri/assets/2746.jpg
 order0
 created2016-03-30 11:43:26
 modified2016-03-30 11:43:26
 MainImage(array)
 id2745
 modelBrokerage
 model_id172
 tagMainImage
 name172.jpg
 typeimage/jpg
 size3038431
 uri/assets/2745.jpg
 order0
 created2016-03-30 11:43:25
 modified2016-03-30 11:43:25
 ContactImage(array)
 id2747
 modelBrokerage
 model_id172
 tagContactImage
 name172.JPG
 typeimage/JPG
 size3290992
 uri/assets/2747.JPG
 order0
 created2016-03-30 11:43:26
 modified2016-03-30 11:43:26
 ContactImage2(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 ContactImage3(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 BrokerOfRecordLogo(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 MainArticle(array)
 id(null)
 model(null)
 model_id(null)
 archived(null)
 medium_featured(null)
 large_featured(null)
 title(null)
 author(null)
 date(null)
 lead_in(null)
 body(null)
 vimeo_id(null)
 created(null)
 modified(null)
 FeaturedImage(empty)
 Location(array)
 0(array)
 id179
 parent_id8
 brokerage_id172
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameGloucester, Chesapeake Bay, VA
 short_nameGloucester, Chesapeake Bay, VA
 group_index
 latitude37.468655
 longitude-76.601852
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 19:15:27
 modified2016-04-12 19:16:33
 timezoneAmerica/New_York
 population0
 uri/locations/view/179/gloucester-chesapeake-bay-va
 tile_nameGloucester, Chesapeake Bay, VA
 User(array)
 0(array)
 id164
 typeBrokerageAdmin
 brokerage_id172
 email[email protected]
 password84b9dfec8ae16d163a095a6a2238dad66090eea2
 recover_hash
 first_nameJeanne
 last_nameHockaday
 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:29:46
 created2016-04-08 16:34:20
 notified(true)
 full_nameJeanne Hockaday
 uri/agent-detail/164/jeanne-hockaday
 profile_complete(true)
 1(array)
 id387
 typeAgent
 brokerage_id172
 email[email protected]
 passworda9e33a598c47a9e6e4ebcbb9c68513352df6892b
 recover_hash
 first_nameJeanne
 last_nameHockaday
 title
 dre_num
 phone804-815-0097
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:54
 created2017-08-07 15:22:54
 notified(false)
 full_nameJeanne Hockaday
 uri/agent-detail/387/jeanne-hockaday
 profile_complete(true)
 2(array)
 id388
 typeAgent
 brokerage_id172
 email[email protected]
 passworda34830611ae736cb80db9d41164091e028b1f346
 recover_hash
 first_nameFrank
 last_nameWingfield
 title
 dre_num
 phone804-815-0917
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:54
 created2017-08-07 15:22:54
 notified(false)
 full_nameFrank Wingfield
 uri/agent-detail/388/frank-wingfield
 profile_complete(true)
 3(array)
 id389
 typeAgent
 brokerage_id172
 email[email protected]
 password57cf6441d8e26d5186cc278832ef95ebb2a5fbca
 recover_hash
 first_nameDebbie
 last_nameMartin
 title
 dre_num
 phone757-876-2314
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:54
 created2017-08-07 15:22:54
 notified(false)
 full_nameDebbie Martin
 uri/agent-detail/389/debbie-martin
 profile_complete(true)
 4(array)
 id808
 typeAgent
 brokerage_id172
 email[email protected]
 passworda16fac68b1846906389cc9bdf6cdd931854bc659
 recover_hash
 first_nameRodney
 last_nameHockaday
 title
 dre_num
 phone757-592-0265
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:24
 created2017-08-07 15:23:24
 notified(false)
 full_nameRodney Hockaday
 uri/agent-detail/808/rodney-hockaday
 profile_complete(true)
- location(array)
 Location(array)
 id179
 parent_id8
 brokerage_id172
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameGloucester, Chesapeake Bay, VA
 short_nameGloucester, Chesapeake Bay, VA
 group_index
 latitude37.468655
 longitude-76.601852
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 19:15:27
 modified2016-04-12 19:16:33
 timezoneAmerica/New_York
 population0
 uri/locations/view/179/gloucester-chesapeake-bay-va
 tile_nameGloucester, Chesapeake Bay, VA
 Image(array)
 id20755
 modelLocation
 model_id179
 tagImage
 nameScreen Shot 2016-04-12 at 7.16.00 PM.png
 typeimage/png
 size1150116
 uri/assets/20755.png
 order0
 created2016-04-12 19:16:28
 modified2016-04-12 19:16:33
- 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/179/gloucester-chesapeake-bay-va
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/locations/view/179/gloucester-chesapeake-bay-va
Remote Port	14534
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	162.159.115.42
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http Cf Ray	a09d8533fd6234fc-CMH
Http Accept Encoding	gzip, br
Http Cookie	CAKEPHP=3u9vmbm7vk0q766jnlu7et61er
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	aiorIa5NyR0g7NUomEw-hQAAAYI
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	aiorIa5NyR0g7NUomEw-hQAAAYI
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781148449.9397
Request Time	1781148449

====

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

Gloucester, Chesapeake Bay, VA

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: 20 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: 20 ms
Total Queries: 19 queries