Locations / Grand Haven, MI, USA

Grand Haven, MI, USA

Welcome to Grand Haven, one of Michigan's featured Beachtowns and a renaissance city that has become a beacon for those looking for simplicity in a scene of natural beauty. From its roots as a highly commercial port-of-call for ferries and passenger liners, Grand Haven has evolved to become a place of serene, family enjoyment, hosting lively outdoor recreation, a thriving downtown, history, culture, world's largest musical fountain, boardwalk, beautiful beaches, lighthouses, historic downtown, and more. USA Today recently voted Grand Haven State Park’s 48 acres of sand as one of the country’s best freshwater beaches, which, on a hot summer’s day is a dream dip in the clear and cool waters of Lake Michigan. It’s a popular place for retirees who split their time between two regions, as West Michigan is best in summer when it’s warm, the days are long, and the charming downtown streets are alive with summer festivals!

Location Represented By

License #: 012345

11:27pm local time
10.5 thousand population

Partner Search

Find partners with a map-based search

Related Locations

Related Partners

Recent Property Listings

Spectacular Waterview Residence in Remsenburg

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)
  017
  1grand-haven-mi-usa
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

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

Sql Log

Sql Logs

default

Total Time: 23 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` = 17 AND `Location`.`archived` = '0' LIMIT 1	1	1	3	maybe slow
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`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` = 189 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` = (189) 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` = (189)	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` = (189)	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` = 17 LIMIT 1	0	0	1	maybe slow
SELECT `Location`.`id`, `Location`.`name`, `Location`.`parent_id` FROM `leveragere_staging2`.`locations` AS `Location` WHERE `Location`.`id` = 17 AND `Location`.`archived` = '0' LIMIT 1	1	1	0
SELECT `Location`.`id`, `Location`.`name` FROM `leveragere_staging2`.`locations` AS `Location` WHERE `Location`.`parent_id` = 17	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 (3728, 3714, 3723, 3752) ORDER BY `Image`.`order` ASC	60	60	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 (3728, 3714, 3723, 3752) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	2	2	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (3728, 3714, 3723, 3752) 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 (3728, 3714, 3723, 3752) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	1	1	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 (3728, 3714, 3723, 3752) 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 11.69 MB

Message	Memory use
Component initialization	2.88 MB
Controller action start	3.81 MB
Controller render start	6.69 MB
View render complete	7.25 MB

Timers

Total Request Time: 234 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	29.60
Event: Controller.initialize	3.87
Event: Controller.startup	1.18
Controller action	53.36
Event: Controller.beforeRender	10.36
» Processing toolbar data	10.25
Rendering View	85.96
» Event: View.beforeRender	0.29
» Rendering APP/View/Locations/view.ctp	2.84
» » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.14
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.15
» » Rendering APP/View/Elements/sidebar/brokerage_list.ctp	0.17
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.47
» » » Rendering APP/View/Elements/static_property_price.ctp	0.41
» » » Rendering APP/View/Elements/static_property_price.ctp #2	0.16
» » » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.20
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	81.94
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)
 id3728
 brokerage_id34
 created_by_user_id0
 order1
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameSpectacular Waterview Residence in Remsenburg
 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)
 descriptionThis Custom Everything 5 Bed, 5.5 Bath Including Separate Studio with Full Bath Is Located On 1.25 Preserved Waterfront Acres. The Generous Open Floor Plane With Custom Kitchen, Dining Room, Living Room, Great Room Offer A Sunlight Filled, Nature Embodied Feel And Lifestyle. Grand Vaulted/Custom Paneled Foyer, Wet Bar, Screen Porch & Immense Upper Deck Offer An Amazing Experience. Geo Therm, Leed Cert.
 address10 Godfrey Lane
 address_2
 cityRemsenburg
 stateNY
 postal_code11960
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2095000
 price_20
 price_usd2095000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms0
 bedrooms_20
 bathrooms0
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude40.803612
 longitude-72.702446
 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_id2
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2019-08-22 10:12:57
 created2016-04-14 13:54:20
 uri/property-detail/3728/10-godfrey-lane-remsenburg-ny-11960-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3728/10-godfrey-lane-remsenburg-ny-11960-usa
 address_concat10 Godfrey Lane Remsenburg NY 11960 USA
 google_maps_query_string10+Godfrey+Lane++Remsenburg+NY+11960+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,095,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty0
 bathrooms_pretty0
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms0
 date_listed2016-04-14
 overridden_brokerage_nameFirst Hampton International Realty
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id2
 nameVacation Homes
 created2019-08-22 10:07:58
 modified2019-08-29 09:59:17
 uri/category-detail/2/vacation-homes
 Brokerage(array)
 id34
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2518253
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameFirst Hampton International Realty
 broker_of_record_name
 short_nameFirst Hampton International Realty
 usernameFirstHampton
 passwordc6d7951ad2b1432ff444a7a5acca6784d6573bb9
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionFirst Hampton International Realty is the exclusive representative for Leverage Global Partners in The Hamptons, New York, USA. Lawrence Citarelli Jr. is a successful, former finance/ economics executive of 14 years and possesses over 17 years of real estate investment and development experience. Mr. Citarelli has forged the Lawrence III Group, The group is comprised of a multi award winning design/construction management firm, Westhampton Partners, a development and acquisition arm and First Hampton International Realty, a global real estate entity. Through the vertical integration of these three entities clients and customers are provided with an experience and service model that is unrivaled in the industry. Mr. Citarelli is also a consummate humanitarian and is aligned with various noteworthy athletes, entertainers and celebrities. He has recently been awarded a congressional award for his international business dealings which are specifically tied to helping the less fortunate children and the communities where he is active.
 communitiesWesthampton Beach Westhampton Quogue Remsenburg hamptons southampton east hampton
 websitehttp://www.firsthamptonrealty.com
 address50 Main Street
 address_2
 cityWesthampton Beach
 stateNY
 full_stateNew York
 countryUSA
 marketHamptons
 market_2
 postal_code11978
 phone(631) 872-0280
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameLawrence Citarelli
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-lawrence-citarelli-principal-first-hampton-realty/
 contact_big_profile_link_text
 contact_titlePrincipal
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename34.jpg
 logo_filename34.jpg
 contact_image_filename34.jpg
 all_properties_link_image_filename34.jpg
 all_properties_linkhttp://www.firsthamptonrealty.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleThe Hamptons Real Estate | First Hampton International Realty | Leverage Global Partners
 meta_descriptionFirst Hampton International Realty is Leverage Global Partners' exclusive representative in the Hamptons, New York, USA.
 meta_keywordsFirst Hampton International Realty, The Hamptons Real Estate, Westhampton beach real estate, Lawrence Citarelli, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-06-07 11:03:46
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/34/first-hampton-international-realty
 website_shortwww.firsthamptonrealty.com
 name_with_locationFirst Hampton International Realty
 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)
 id20819
 modelProperty
 model_id3728
 tagImage
 nameGodfrey-GOOD-FRONT.jpg
 typeimage/jpeg
 size1188933
 uri/assets/20819.jpg
 order0
 created2016-04-14 13:52:42
 modified2016-04-14 13:54:20
 1(array)
 id20820
 modelProperty
 model_id3728
 tagImage
 nameGODFREY-BACK.jpg
 typeimage/jpeg
 size1885785
 uri/assets/20820.jpg
 order1
 created2016-04-14 13:52:57
 modified2016-04-14 13:54:20
 2(array)
 id20821
 modelProperty
 model_id3728
 tagImage
 nameKitchen-2.jpg
 typeimage/jpeg
 size173504
 uri/assets/20821.jpg
 order2
 created2016-04-14 13:53:55
 modified2016-04-14 13:54:20
 3(array)
 id20822
 modelProperty
 model_id3728
 tagImage
 nameStaircase-2.jpg
 typeimage/jpeg
 size149585
 uri/assets/20822.jpg
 order3
 created2016-04-14 13:54:18
 modified2016-04-14 13:54:20
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 1(array)
 Property(array)
 id3714
 brokerage_id76
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id783
 agent_2_id0
 agent_3_id0
 nameCozy Cabin Mountain Get-Away
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionCozy cabin with a great big panoramic view. Enjoy this view on the spacious deck or from the wall of windows in the living room. Open beamed ceilings, knotty pine through out. Bedrooms are on the lower level. Full bath is on the main. Level parking and entry. Lake Gregory, the park and Crestline village are only a couple minuets away by car. Hurry! Don’t miss out on this cabin in the mountains and all the summer fun you can have! - See more at: http://www.therealestateplace.com/property/cozy-cabin-with-a-giant-view/#sthash.ZnUX3nkP.dpuf
 address340 Donner Dr
 address_2
 cityLake Arrowhead
 stateCA
 postal_code92352
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price175000
 price_20
 price_usd175000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms2
 bedrooms_20
 bathrooms1
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1views
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://www.therealestateplace.com/property/cozy-cabin-with-a-giant-view/
 meta_titleCozy Cabin Mountain Get-Away | Lake Arrowhead Real Estate | Prime Properties
 meta_description340 Donner Dr is a property offered for sale in Lake Arrowhead, CA, USA, presented by Prime Properties
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://www.tourfactory.com/1523656
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, year_built, video_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(true)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-04-07 11:14:42
 uri/property-detail/3714/340-donner-dr-lake-arrowhead-ca-92352-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3714/340-donner-dr-lake-arrowhead-ca-92352-usa
 address_concat340 Donner Dr Lake Arrowhead CA 92352 USA
 google_maps_query_string340+Donner+Dr++Lake+Arrowhead+CA+92352+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 175,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty2
 bathrooms_pretty1
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms1
 date_listed2016-04-07
 overridden_brokerage_namePrime Properties
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id76
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2434729
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePrime Properties
 broker_of_record_name
 short_namePrime Properties
 usernamePrimeProperties
 password4b7dee5c791770c42ce3df75d5b8fb072b481b38
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPrime Properties is the exclusive representative for Leverage Global Partners in Lake Arrowhead, California, USA. “Different isn’t always better, but better is always different,” has been founder, and president, Jeff Perlis’ motto for providing outstanding service to his clients for almost 25 years. Jeff created Prime Properties as a boutique real estate company that provides Nordstrom-quality customer service to its clients. The Prime Properties Team purposes to continually show community support. Such support can be exemplified by their sweeping transformation of its current office location. The office’s strategic location, houses the Arrowhead Welcome Center, Jeff’s vision for providing a warm and inviting first-stop for Lake Arrowhead visitors and clients. The Prime Properties Team includes, Arrowhead Rental Agency, the full-time rental department. Lake Arrowhead is a four season resort community centered around the uniqueness of a private lake. Located in an altitude of 5,100 feet, Lake Arrowhead has been described as the “Jewel of Southern California,” known as “Little Switzerland.” Close to local ski resorts and National Forest trails, Lake Arrowhead is less than a two-hour drive from Los Angeles, San Diego, or Palm Springs.
 communitieslake arrowhead
 websitehttp://www.therealestateplace.com/
 address26816 Highway 189
 address_2
 cityLake Arrowhead
 stateCA
 full_stateCalifornia
 countryUSA
 marketLake Arrowhead
 market_2
 postal_code92352
 phone(909) 337-7653
 phone_2(909) 224-5631
 phone_3
 wide_contact_image(false)
 contact_nameJeff Perlis
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner/Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_websitehttp://www.JeffPerlis.com
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename76.jpg
 logo_filename76.jpg
 contact_image_filename76.jpg
 all_properties_link_image_filename76.jpg
 all_properties_linkhttp://www.therealestateplace.com/properties
 video_embed_code
 contact_video_embed_code
 meta_titleLake Arrowhead Real Estate | Prime Properties | Leverage Global Partners
 meta_descriptionPrime Properties is the exclusive representative for Leverage Global Partners in Lake Arrowhead, California, USA.
 meta_keywordsLake Arrowhead Real Estate, Prime Properties, Leverage Global Partners, Jeff Perlis
 login_message_counter2
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-12-09 16:21:37
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/76/prime-properties
 website_shortwww.therealestateplace.com
 name_with_locationPrime Properties
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id20576
 modelProperty
 model_id3714
 tagImage
 name36057.jpg
 typeimage/jpg
 size4491599
 uri/assets/20576.jpg
 order2895
 created2016-04-07 17:34:23
 modified2016-04-07 17:34:23
 1(array)
 id20577
 modelProperty
 model_id3714
 tagImage
 name36058.jpg
 typeimage/jpg
 size3978667
 uri/assets/20577.jpg
 order2896
 created2016-04-07 17:34:25
 modified2016-04-07 17:34:25
 2(array)
 id20578
 modelProperty
 model_id3714
 tagImage
 name36059.jpg
 typeimage/jpg
 size2333726
 uri/assets/20578.jpg
 order2897
 created2016-04-07 17:34:26
 modified2016-04-07 17:34:26
 3(array)
 id20579
 modelProperty
 model_id3714
 tagImage
 name36060.jpg
 typeimage/jpg
 size2771257
 uri/assets/20579.jpg
 order2898
 created2016-04-07 17:34:28
 modified2016-04-07 17:34:28
 4(array)
 id20580
 modelProperty
 model_id3714
 tagImage
 name36061.jpg
 typeimage/jpg
 size3063397
 uri/assets/20580.jpg
 order2899
 created2016-04-07 17:34:30
 modified2016-04-07 17:34:30
 5(array)
 id20581
 modelProperty
 model_id3714
 tagImage
 name36062.jpg
 typeimage/jpg
 size3961632
 uri/assets/20581.jpg
 order2900
 created2016-04-07 17:34:31
 modified2016-04-07 17:34:31
 6(array)
 id20582
 modelProperty
 model_id3714
 tagImage
 name36063.jpg
 typeimage/jpg
 size3586973
 uri/assets/20582.jpg
 order2901
 created2016-04-07 17:34:33
 modified2016-04-07 17:34:33
 7(array)
 id20583
 modelProperty
 model_id3714
 tagImage
 name36064.jpg
 typeimage/jpg
 size4205847
 uri/assets/20583.jpg
 order2902
 created2016-04-07 17:34:34
 modified2016-04-07 17:34:34
 8(array)
 id20584
 modelProperty
 model_id3714
 tagImage
 name36065.jpg
 typeimage/jpg
 size4187920
 uri/assets/20584.jpg
 order2903
 created2016-04-07 17:34:36
 modified2016-04-07 17:34:36
 9(array)
 id20585
 modelProperty
 model_id3714
 tagImage
 name36066.jpg
 typeimage/jpg
 size5185756
 uri/assets/20585.jpg
 order2904
 created2016-04-07 17:34:37
 modified2016-04-07 17:34:37
 User(array)
 0(array)
 id975
 typeAgent
 brokerage_id76
 email[email protected]
 passwordc6c6dec5d7e005197be3010c5570953a73f47b96
 recover_hash
 first_nameKerry
 last_nameJenkins
 title
 dre_num
 phone909-553-7087
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:46
 created2017-08-07 15:23:46
 notified(false)
 full_nameKerry Jenkins
 uri/agent-detail/975/kerry-jenkins
 profile_complete(true)
 UsersProperty(array)
 id732
 user_id975
 property_id3714
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id4355
 property_id3714
 property_feature_id14
 Topic(empty)
 2(array)
 Property(array)
 id3723
 brokerage_id157
 created_by_user_id0
 order2
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameRenovated 2 story expanded ranch
 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)
 descriptionRenovated 2 story expanded ranch features a chefs kit w/adjoining family room, spacious living room & dining room with a wall of windows and French doors that lead to the incredible backyard setting that is wonderful to bbq, dine and entertain. There is a first floor luxurious master bedroom suite while the second floor includes three additional bedrooms plus an en-suite. The walk-out lower level boasts a recreation room, office, exercise room, art room, two full baths and loads of storage. Close-by to the #1 Deerfield elementary school, children are bused to the highly rated Millburn Middle School and Millburn High School.
 address90 Troy Drive
 address_2
 cityShort Hills
 stateNJ
 postal_code07078
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1595000
 price_20
 price_usd1595000
 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
 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
 websitewww.90TroyDr.com
 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
 latitude40.754322
 longitude-74.312920
 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 00:33:02
 created2016-04-13 07:00:07
 uri/property-detail/3723/90-troy-drive-short-hills-nj-07078-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3723/90-troy-drive-short-hills-nj-07078-usa
 address_concat90 Troy Drive Short Hills NJ 07078 USA
 google_maps_query_string90+Troy+Drive++Short+Hills+NJ+07078+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,595,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty5
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2016-04-13
 overridden_brokerage_nameTowne Realty Group
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id157
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2493140
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameTowne Realty Group
 broker_of_record_name
 short_nameTowne Realty Group
 usernameTowneRealtyGroup
 passworda4249a6dfad6cc2af05068e244f79544fefc464e
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionTowne Realty Group is the exclusive representative for Leverage Global Partners in Short Hills, Essex County, Morris County, Union County, New Jersey, USA. Towne Realty Group, LLC, is a real estate boutique in Short Hills, NJ, with unparalleled real estate market knowledge and experience. Our agents are tenacious advocates for your interests and we are a paperless company – all of our business is conducted electronically in the cloud. Our team of 25 professionals are all full-time pros, unmatched in the industry for their attention to detail. Our powerful marketing and advertising programs across dozens of websites and social media platforms, will help sell your home, and our deep roots in our local communities will serve you well as a buyer. We have transacted over $1 Billion in sales since we opened our doors in 2006. Our agents know the local markets in New Jersey - if it happens in Millburn, Short Hills, Maplewood, South Orange, West Orange, Summit, Livingston, Chatham, Madison, Florham Park, New Providence, Springfield, Montclair, Westfield, Cranford or surrounding towns in Essex, Morris, and Union, our agents know about it. We welcome the opportunity to assist you with any questions in our local real estate market.
 communitiesShort Hills Essex County Morris County Union County Somerset County
 websitehttp://www.trghome.com/
 address511 Millburn Avenue
 address_2
 cityShort Hills
 stateNJ
 full_stateNew Jersey
 countryUSA
 market
 market_2
 postal_code
 phoneKaren Mobile: (201) 417-1600
 phone_2Daniel Mobile: (973) 865-4144
 phone_3Barbara's Mobile: (908) 347-6945
 wide_contact_image(false)
 contact_nameKaren Bigos, Barbara Birkitt, Daniel Cannizzo
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-karen-biggs-daniel-cannizzo-towne-realty-group/
 contact_big_profile_link_textMeet Karen Bigos, Barbara Birkitt, Daniel Cannizzo
 contact_titleOwner/Managing Partner, Sales Manager/Broker of Record, Owner/Managing Partner
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Short Hills & Summit, NJ real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3[email protected]
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename157.jpg
 logo_filename157.JPG
 contact_image_filename157.jpg
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_titleShort Hills Real Estate | Towne Realty Group | Leverage Global Partners
 meta_description Towne Realty Group is the exclusive representative for Leverage Global Partners in Short Hills, New Jersey, USA.
 meta_keywordsTowne Realty Group, Short Hills Realty Group, Karen Bigos, Short Hills Real Estate, Essex County Real Estate, Morris County Real Estate, Union County Real Estate, Somerset County Real Estate, New Jersey Real Estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-09-02 15:10:33
 modified2021-07-18 10:38:47
 dre_num012345
 uri/brokerage-detail/157/towne-realty-group
 website_shortwww.trghome.com
 name_with_locationTowne Realty Group
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id20756
 modelProperty
 model_id3723
 tagImage
 namefront.jpg
 typeimage/jpeg
 size2812943
 uri/assets/20756.jpg
 order0
 created2016-04-13 06:58:25
 modified2016-04-13 07:00:07
 1(array)
 id20761
 modelProperty
 model_id3723
 tagImage
 namelv.jpg
 typeimage/jpeg
 size1636475
 uri/assets/20761.jpg
 order1
 created2016-04-13 06:59:08
 modified2016-04-13 07:00:07
 2(array)
 id20763
 modelProperty
 model_id3723
 tagImage
 namekitchen-2.jpg
 typeimage/jpeg
 size1630226
 uri/assets/20763.jpg
 order2
 created2016-04-13 06:59:10
 modified2016-04-13 07:00:07
 3(array)
 id20764
 modelProperty
 model_id3723
 tagImage
 namedining.jpg
 typeimage/jpeg
 size1980966
 uri/assets/20764.jpg
 order3
 created2016-04-13 06:59:10
 modified2016-04-13 07:00:07
 4(array)
 id20765
 modelProperty
 model_id3723
 tagImage
 namefam.jpg
 typeimage/jpeg
 size1760572
 uri/assets/20765.jpg
 order4
 created2016-04-13 06:59:11
 modified2016-04-13 07:00:07
 5(array)
 id20760
 modelProperty
 model_id3723
 tagImage
 namemaster-2.jpg
 typeimage/jpeg
 size1430080
 uri/assets/20760.jpg
 order5
 created2016-04-13 06:59:08
 modified2016-04-13 07:00:07
 6(array)
 id20762
 modelProperty
 model_id3723
 tagImage
 namemaster-bath.jpg
 typeimage/jpeg
 size2001914
 uri/assets/20762.jpg
 order6
 created2016-04-13 06:59:09
 modified2016-04-13 07:00:07
 7(array)
 id20759
 modelProperty
 model_id3723
 tagImage
 nameback-2.jpg
 typeimage/jpeg
 size2933204
 uri/assets/20759.jpg
 order7
 created2016-04-13 06:58:28
 modified2016-04-13 07:00:07
 8(array)
 id20757
 modelProperty
 model_id3723
 tagImage
 nameback-5.jpg
 typeimage/jpeg
 size3078942
 uri/assets/20757.jpg
 order8
 created2016-04-13 06:58:26
 modified2016-04-13 07:00:07
 9(array)
 id20758
 modelProperty
 model_id3723
 tagImage
 nameback.jpg
 typeimage/jpeg
 size3265128
 uri/assets/20758.jpg
 order9
 created2016-04-13 06:58:27
 modified2016-04-13 07:00:07
 User(array)
 0(array)
 id1273
 typeAgent
 brokerage_id157
 email[email protected]
 passworde12a1c18f923d356c3701925712f3ec758f9f791
 recover_hash
 first_nameDonna
 last_nameShaw
 title
 dre_num
 phone973-879-3128
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:24:02
 created2017-08-07 15:24:02
 notified(false)
 full_nameDonna Shaw
 uri/agent-detail/1273/donna-shaw
 profile_complete(true)
 UsersProperty(array)
 id1101
 user_id1273
 property_id3723
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 3(array)
 Property(array)
 id3752
 brokerage_id70
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameMy Imported Property
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(false)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(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)
 descriptionElegantly Situated On The Shores Of The Atlantic, This Breathtaking Home Spans 250 Feet Of Ocean Front In The Private, 2700 Acre, Gated Community Of Debordieu Colony. This 7 Bedroom, Luxurious Home, Opens To An Expansive Great Room Which Highlights The Home’S Seamless Design With A Superb See Through, Floor To Ceiling Fireplace And Dining Area Featuring A Beautiful Mirrored Wall And Endless Ocean Views. Tranquility Abounds In The Comfortable Living Spaces Tucked Throughout. Relax In The Architecturally Interesting Kitchen With The Ultimate In Space Planning Featuring A Comfortable Resting Area Complete With Fireplace. Hints Of Blue Décor, Provide A Pleasing Palette To The Neutral Understated Sand Color Of Cabinetry And Islands. A Chef’S Delight, This Kitchen Is Designed For Both Intimate Informal Or Extravagant Formal Entertaining. Also, Included On This Main Floor An En-Suite Guest Bedroom, Laundry Room A Lavish Wet Bar With Boundless Finesse, Powder Room & Media Room. An Abundance Of Natural Light Breathes Life Into The Master Suite With A Serene Sitting Area In A Domed Turret – Perfect For Sunrise Mornings Or Afternoon Quite Reading. Not To Be Outdone, The Second Floor, Accessed By A Spectacular Foyer With Soaring Ceilings And Dual Staircases, Overlooks And Captures The Essence Of The Home From The Balcony Taking In The Floor To Ceiling Windows Showcasing The Natural Beauty Of The Homes Setting. 4 Bedrooms On This Floor, Two En-Suite, Are Exquisitely Designed With Access To Ocean Terraces And Endless Views. Debordieu Is Truly A Resort Oasis With The Pete Dye Championship Designed Golf Course, 2 Swimming Pools, An Ocean Front Gazebo, Exceptional Tennis Courts, A New State Of The Art Fitness Center And 2 Restaurants. Experience A 2 Mile Beach Offering Peace And Tranquility, Enjoy Bike Paths, Walking Trails, And The Finest Fishing In The Area.
 address51 Cheraw Way
 address_2
 cityGeorgetown
 stateSC
 postal_code29440
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price3500000
 price_20
 price_usd0
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms7
 bedrooms_20
 bathrooms5
 bathrooms_20
 no_beds_baths(false)
 square_feet6901
 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_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
 latitude33.358505
 longitude-79.152374
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(false)
 invalid(false)
 mlsidx_full_address51 Cheraw Way Georgetown SC
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2018-08-13 10:57:03
 created2018-08-13 10:55:44
 uri/property-detail/3752/51-cheraw-way-georgetown-sc-29440-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3752/51-cheraw-way-georgetown-sc-29440-usa
 address_concat51 Cheraw Way Georgetown SC 29440 USA
 google_maps_query_string51+Cheraw+Way++Georgetown+SC+29440+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 3,500,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty7
 bathrooms_pretty5
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2018-08-13
 overridden_brokerage_nameQuinta Properties
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id70
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties3
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id13
 WOEID23706483
 timezoneEurope/Lisbon
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id9
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameQuinta Properties
 broker_of_record_name
 short_nameQuinta Properties
 usernameQuintaProperties
 passwordbfa20d0f7d557565a3e9f0589db0a06e4c9546f3
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionQuinta Properties is the exclusive representative for Leverage Global Partners in the Algarve, Portugal. Quinta Properties deal with some of the most exclusive luxury villas and exciting property in and around Quinta do Lago. As the chosen associates of Savills, they offer in-depth knowledge and experience to meet your real estate needs. Anyone who knows Quinta Properties and has dealt with Alison, Kerstin, and their team will know they are passionate about property. Their wide experience in the local property market enables them to recommend legal, architectural, financial and construction professionals who understand the needs of prospective buyers in the locality. Quinta Properties are registered with the Portuguese authorities as licensed agents, meeting stringent standards. Their staff are fluent in English, German, French, and Portuguese. "We make it our business to support you, to explain all the options, procedures and pitfalls and to carefully guide you through the entire process from purchasing to sellingluxury Quinta do Lago villas and other fine properties in the Quinta do Lago and the whole Algarve area." --Alison Buechner Hojbjerg and Kerstin Buechner
 communitiesalgarve the algarve quinta do lago
 websitehttp://www.quintaproperty.com/
 addressAvenida da Gondra
 address_2Quinta do Lago
 cityAlmancil
 state
 full_state
 countryPortugal
 marketAlgarve
 market_2
 postal_code8135-162
 phone+351 289 396 073
 phone_2+351 289 398086 (Fax)
 phone_3
 wide_contact_image(false)
 contact_nameAlison Buechner Hojbjerg and Kerstin Buechner
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleDirectors
 contact_dre_num
 contact_quoteWe invite you to contact us about real estate in the Algarve
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename70.jpg
 logo_filename70.jpg
 contact_image_filename70.jpg
 all_properties_link_image_filename70.jpg
 all_properties_linkhttp://www.quintaproperty.com/algarve/
 video_embed_code
 contact_video_embed_code
 meta_titleAlgarve Real Estate | Quinta Properties | Leverage Global Partners
 meta_descriptionQuinta Properties is the exclusive representative for Leverage Global Partners in the Algarve, Portugal.
 meta_keywordsQuinta Properties, Algarve Real Estate, Leverage Global Partners, Alison Buechner Hojbjerg
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-11-15 11:23:29
 modified2020-11-20 12:05:11
 dre_num012345
 uri/brokerage-detail/70/quinta-properties
 website_shortwww.quintaproperty.com
 name_with_locationQuinta Properties
 mlsidx_id_array(array)
 09
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id22957
 modelProperty
 model_id3752
 tagImage
 name1809067-1.jpg
 typeimage/jpeg
 size119021
 uri/assets/22957.jpg
 order0
 created2018-08-13 10:55:44
 modified2018-08-13 10:57:03
 1(array)
 id22958
 modelProperty
 model_id3752
 tagImage
 name1809067-2.jpg
 typeimage/jpeg
 size128372
 uri/assets/22958.jpg
 order1
 created2018-08-13 10:55:44
 modified2018-08-13 10:57:03
 2(array)
 id22959
 modelProperty
 model_id3752
 tagImage
 name1809067-3.jpg
 typeimage/jpeg
 size147897
 uri/assets/22959.jpg
 order2
 created2018-08-13 10:55:45
 modified2018-08-13 10:57:03
 3(array)
 id22960
 modelProperty
 model_id3752
 tagImage
 name1809067-4.jpg
 typeimage/jpeg
 size146754
 uri/assets/22960.jpg
 order3
 created2018-08-13 10:55:45
 modified2018-08-13 10:57:03
 4(array)
 id22961
 modelProperty
 model_id3752
 tagImage
 name1809067-5.jpg
 typeimage/jpeg
 size147683
 uri/assets/22961.jpg
 order4
 created2018-08-13 10:55:45
 modified2018-08-13 10:57:03
 5(array)
 id22962
 modelProperty
 model_id3752
 tagImage
 name1809067-6.jpg
 typeimage/jpeg
 size120398
 uri/assets/22962.jpg
 order5
 created2018-08-13 10:55:45
 modified2018-08-13 10:57:03
 6(array)
 id22963
 modelProperty
 model_id3752
 tagImage
 name1809067-7.jpg
 typeimage/jpeg
 size154334
 uri/assets/22963.jpg
 order6
 created2018-08-13 10:55:45
 modified2018-08-13 10:57:03
 7(array)
 id22964
 modelProperty
 model_id3752
 tagImage
 name1809067-8.jpg
 typeimage/jpeg
 size97359
 uri/assets/22964.jpg
 order7
 created2018-08-13 10:55:45
 modified2018-08-13 10:57:03
 8(array)
 id22965
 modelProperty
 model_id3752
 tagImage
 name1809067-9.jpg
 typeimage/jpeg
 size115060
 uri/assets/22965.jpg
 order8
 created2018-08-13 10:55:45
 modified2018-08-13 10:57:03
 9(array)
 id22966
 modelProperty
 model_id3752
 tagImage
 name1809067-10.jpg
 typeimage/jpeg
 size98295
 uri/assets/22966.jpg
 order9
 created2018-08-13 10:55:45
 modified2018-08-13 10:57:03
 10(array)
 id22967
 modelProperty
 model_id3752
 tagImage
 name1809067-11.jpg
 typeimage/jpeg
 size113371
 uri/assets/22967.jpg
 order10
 created2018-08-13 10:55:45
 modified2018-08-13 10:57:03
 11(array)
 id22968
 modelProperty
 model_id3752
 tagImage
 name1809067-12.jpg
 typeimage/jpeg
 size113634
 uri/assets/22968.jpg
 order11
 created2018-08-13 10:55:45
 modified2018-08-13 10:57:03
 12(array)
 id22969
 modelProperty
 model_id3752
 tagImage
 name1809067-13.jpg
 typeimage/jpeg
 size150038
 uri/assets/22969.jpg
 order12
 created2018-08-13 10:55:45
 modified2018-08-13 10:57:03
 13(array)
 id22970
 modelProperty
 model_id3752
 tagImage
 name1809067-14.jpg
 typeimage/jpeg
 size115497
 uri/assets/22970.jpg
 order13
 created2018-08-13 10:55:45
 modified2018-08-13 10:57:03
 14(array)
 id22971
 modelProperty
 model_id3752
 tagImage
 name1809067-15.jpg
 typeimage/jpeg
 size114789
 uri/assets/22971.jpg
 order14
 created2018-08-13 10:55:45
 modified2018-08-13 10:57:03
 15(array)
 id22972
 modelProperty
 model_id3752
 tagImage
 name1809067-16.jpg
 typeimage/jpeg
 size116117
 uri/assets/22972.jpg
 order15
 created2018-08-13 10:55:45
 modified2018-08-13 10:57:03
 16(array)
 id22973
 modelProperty
 model_id3752
 tagImage
 name1809067-17.jpg
 typeimage/jpeg
 size124442
 uri/assets/22973.jpg
 order16
 created2018-08-13 10:55:45
 modified2018-08-13 10:57:03
 17(array)
 id22974
 modelProperty
 model_id3752
 tagImage
 name1809067-18.jpg
 typeimage/jpeg
 size124761
 uri/assets/22974.jpg
 order17
 created2018-08-13 10:55:45
 modified2018-08-13 10:57:03
 18(array)
 id22975
 modelProperty
 model_id3752
 tagImage
 name1809067-19.jpg
 typeimage/jpeg
 size58946
 uri/assets/22975.jpg
 order18
 created2018-08-13 10:55:45
 modified2018-08-13 10:57:03
 19(array)
 id22976
 modelProperty
 model_id3752
 tagImage
 name1809067-20.jpg
 typeimage/jpeg
 size100601
 uri/assets/22976.jpg
 order19
 created2018-08-13 10:55:45
 modified2018-08-13 10:57:03
 20(array)
 id22977
 modelProperty
 model_id3752
 tagImage
 name1809067-21.jpg
 typeimage/jpeg
 size99367
 uri/assets/22977.jpg
 order20
 created2018-08-13 10:55:45
 modified2018-08-13 10:57:03
 21(array)
 id22978
 modelProperty
 model_id3752
 tagImage
 name1809067-22.jpg
 typeimage/jpeg
 size92005
 uri/assets/22978.jpg
 order21
 created2018-08-13 10:55:45
 modified2018-08-13 10:57:03
 22(array)
 id22979
 modelProperty
 model_id3752
 tagImage
 name1809067-23.jpg
 typeimage/jpeg
 size124761
 uri/assets/22979.jpg
 order22
 created2018-08-13 10:55:45
 modified2018-08-13 10:57:03
 23(array)
 id22980
 modelProperty
 model_id3752
 tagImage
 name1809067-24.jpg
 typeimage/jpeg
 size78933
 uri/assets/22980.jpg
 order23
 created2018-08-13 10:55:46
 modified2018-08-13 10:57:03
 24(array)
 id22981
 modelProperty
 model_id3752
 tagImage
 name1809067-25.jpg
 typeimage/jpeg
 size86635
 uri/assets/22981.jpg
 order24
 created2018-08-13 10:55:46
 modified2018-08-13 10:57:03
 25(array)
 id22982
 modelProperty
 model_id3752
 tagImage
 name1809067-26.jpg
 typeimage/jpeg
 size98622
 uri/assets/22982.jpg
 order25
 created2018-08-13 10:55:46
 modified2018-08-13 10:57:03
 26(array)
 id22983
 modelProperty
 model_id3752
 tagImage
 name1809067-27.jpg
 typeimage/jpeg
 size106378
 uri/assets/22983.jpg
 order26
 created2018-08-13 10:55:46
 modified2018-08-13 10:57:03
 27(array)
 id22984
 modelProperty
 model_id3752
 tagImage
 name1809067-28.jpg
 typeimage/jpeg
 size98908
 uri/assets/22984.jpg
 order27
 created2018-08-13 10:55:46
 modified2018-08-13 10:57:03
 28(array)
 id22985
 modelProperty
 model_id3752
 tagImage
 name1809067-29.jpg
 typeimage/jpeg
 size80155
 uri/assets/22985.jpg
 order28
 created2018-08-13 10:55:46
 modified2018-08-13 10:57:03
 29(array)
 id22986
 modelProperty
 model_id3752
 tagImage
 name1809067-30.jpg
 typeimage/jpeg
 size111729
 uri/assets/22986.jpg
 order29
 created2018-08-13 10:55:46
 modified2018-08-13 10:57:03
 30(array)
 id22987
 modelProperty
 model_id3752
 tagImage
 name1809067-31.jpg
 typeimage/jpeg
 size93568
 uri/assets/22987.jpg
 order30
 created2018-08-13 10:55:46
 modified2018-08-13 10:57:03
 31(array)
 id22988
 modelProperty
 model_id3752
 tagImage
 name1809067-32.jpg
 typeimage/jpeg
 size141620
 uri/assets/22988.jpg
 order31
 created2018-08-13 10:55:46
 modified2018-08-13 10:57:03
 32(array)
 id22989
 modelProperty
 model_id3752
 tagImage
 name1809067-33.jpg
 typeimage/jpeg
 size95750
 uri/assets/22989.jpg
 order32
 created2018-08-13 10:55:46
 modified2018-08-13 10:57:03
 33(array)
 id22990
 modelProperty
 model_id3752
 tagImage
 name1809067-34.jpg
 typeimage/jpeg
 size82211
 uri/assets/22990.jpg
 order33
 created2018-08-13 10:55:46
 modified2018-08-13 10:57:03
 34(array)
 id22991
 modelProperty
 model_id3752
 tagImage
 name1809067-35.jpg
 typeimage/jpeg
 size70930
 uri/assets/22991.jpg
 order34
 created2018-08-13 10:55:46
 modified2018-08-13 10:57:03
 35(array)
 id22992
 modelProperty
 model_id3752
 tagImage
 name1809067-36.jpg
 typeimage/jpeg
 size77628
 uri/assets/22992.jpg
 order35
 created2018-08-13 10:55:46
 modified2018-08-13 10:57:03
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
- sidebar_brokerages(array)
 0(array)
 Brokerage(array)
 id46
 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
 WOEID2495775
 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
 usernameVanguardSonoma
 passworde8045814d4cc920c82b1497cdc9288d62d2c8c16
 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
 descriptionVanguard Properties is the exclusive representative for Leverage Global Partners in Sonoma, California, USA. For close to 30 years, Vanguard Properties has offered impeccable service to buyers and sellers throughout the Bay Area. Vanguard Properties Sonoma specializes in offering its clients service beyond their expectations whether buying or selling. Vanguard Properties represents many of the most prominent homes in the beautiful California wine country region of Sonoma County. Whether looking for an expansive luxury estate to a wonderful country farm house to vineyard land to produce estate grown grapes and perhaps build your dream home, Vanguard Properties Sonoma is your resource for quality Real Estate services to ensure a smooth transaction. In addition if you are looking to sell any of the aforementioned types of properties Vanguard Properties Sonoma has the expertise, the knowledge and the marketing savvy to expose your property to a worldwide network of realtors. Many Sonoma County home buyers are from San Francisco. That being said the Bay Area owned and operated <a href="../../../brokerage-detail/18/Vanguard-Properties" target="_blank">Vanguard Properties San Francisco</a> gives you the extra added value of being showcased not only in Sonoma County but in San Francisco, as well. 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 Vanguard 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.
 communitiessonoma sebastopol healdsburg
 websitehttp://vanguardsf.com/
 address978 Gravenstein Highway South
 address_2
 citySebastopol
 stateCA
 full_stateCalifornia
 countryUSA
 marketSonoma
 market_2
 postal_code95472
 phone(415) 321-7007
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJames Nunemacher
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-james-nunemacher-principal-vanguard-properties/
 contact_big_profile_link_text
 contact_titleCEO
 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_filename46.jpg
 logo_filename46.jpg
 contact_image_filename46.jpg
 all_properties_link_image_filename46.jpg
 all_properties_linkhttp://vanguardsf.com/VGlistings.php
 video_embed_code
 contact_video_embed_code
 meta_titleSonoma Real Estate | Vanguard Properties| Leverage Global Partners
 meta_descriptionVanguard Properties is the exclusive representative for Leverage Global Partners in Sonoma, CA, USA.
 meta_keywordsVanguard Properties, sonoma real estate, James Nunemacher, leverage global partners
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-09-11 10:43:00
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/46/vanguard-properties
 website_shortvanguardsf.com
 name_with_locationVanguard Properties
 Logo(array)
 id2374
 modelBrokerage
 model_id46
 tagLogo
 name46.jpg
 typeimage/jpg
 size19631
 uri/assets/2374.jpg
 order0
 created2016-03-30 11:38:55
 modified2016-03-30 11:38:55
 1(array)
 Brokerage(array)
 id210
 account_executive_id0
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID8676
 timezoneAmerica/Edmonton
 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
 nameLiv Real Estate
 broker_of_record_name
 short_nameLiv Real Estate
 usernameLivRealEstate
 password043b3ff63be4366b17c1e79d5a02160f148729ec
 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
 descriptionLiv Real Estate is the exclusive representative for Leverage Global Partners in Edmonton, Spruce Grove, St. Albert, Sherwood Park, Devon, Stony Plain, Leduc, Beaumont, and Fort Saskatchewan, Alberta, Canada. Selling your home is about you, and should feel as familiar and safe as your backyard. We believe in making our clients savvy, so they are part of the conversation when it comes to aligning big decisions with the best move. Liv offers a fresh perspective to real estate with a new outlook on dotted lines and traditional relationships between agents and homeowners. We take the artifice out of the transaction and the bus bench out of the relationship. We are homeowners too, and we stand behind a transparent process. When it’s time to give up the growth charts notched into your walls, or find familiar creaky floorboards in new surroundings, Liv is ready for you. We don’t want to be famous, we just want you to Love Where You Liv, and help you make sense of moving in, or moving on. This is how real estate really is.
 communitiesEdmonton Spruce Grove St. Albert Sherwood Park Devon Stony Plain Leduc Beaumont Fort Saskatchewan
 websitehttp://www.livrealestate.ca/
 address18831 111 Ave.
 address_2
 cityEdmonton
 stateAB
 full_stateAlberta
 countryCanada
 marketEdmonton
 market_2
 postal_codeT5S 2X4
 phoneDirect: (780) 486-8655
 phone_2Cell: (780) 441-5576
 phone_3
 wide_contact_image(false)
 contact_nameSheldon Johnston
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBroker/Owner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename210.jpg
 logo_filename210.jpg
 contact_image_filename210.jpg
 all_properties_link_image_filename210.jpg
 all_properties_linkhttp://www.livrealestate.ca/our-listings/
 video_embed_code
 contact_video_embed_code
 meta_titleEdmonton Real Estate⎜LIV Real Estate⎜Leverage Global Partners
 meta_descriptionLIV Real Estate is the exclusive representative for Leverage Global Partners in Edmonton, AB, Canada.
 meta_keywordsLIV Real Estate, Edmonton Real Estate, Spruce Grove Real Estate, St. Albert Real Estate, Sherwood Park Real Estate, Devon Real Estate, Stony Plain Real Estate, Leduc Real Estate, Beaumont Real Estate, Fort Saskatchewan Real Estate, Alberta Real Estate, Sheldon Johnston, Leverage Global Partners
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-06-25 09:59:11
 modified2016-04-14 10:57:52
 dre_num012345
 uri/brokerage-detail/210/liv-real-estate
 website_shortwww.livrealestate.ca
 name_with_locationLiv Real Estate
 Logo(array)
 id2851
 modelBrokerage
 model_id210
 tagLogo
 name210.jpg
 typeimage/jpg
 size211602
 uri/assets/2851.jpg
 order0
 created2016-03-30 11:44:44
 modified2016-04-14 10:57:52
 2(array)
 Brokerage(array)
 id219
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2378319
 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
 namedunes properties
 broker_of_record_name
 short_namedunes properties
 usernamedunesproperties
 passwordb76f3dcf9a00c689036232225e96f54a1b389b83
 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
 descriptiondunes properties is the exclusive representative for Leverage Global Partners in Charleston, Mount Pleasant, Isle of Palms, West Ashley, James Island, Folly Beach, Sullivan's Island, Dewee's Island, SC, USA. dunes properties is a boutique real estate, vacation rental, and property management company serving the Charleston area. We began with a single office and three employees in 1989. Today, we represent the Lowcountry with over 50 professional, experienced real estate agents in four full-service offices. Nobody knows the Charleston Coast better®
 communitiesCharleston Mount Pleasant Isle of Palms West Ashley James Island Folly Beach Sullivan's Island Dewee's Island
 websitehttp://dunesproperties.com/
 address214 King Street
 address_2
 cityCharleston
 stateSC
 full_stateSouth Carolina
 countryUSA
 marketCharleston
 market_2
 postal_code29401
 phoneCell: (843) 270-1698
 phone_2Office: (843) 886-5600
 phone_3
 wide_contact_image(false)
 contact_nameRandy Walker
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBroker/Owner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename219.png
 logo_filename219.jpg
 contact_image_filename219.png
 all_properties_link_image_filename219.png
 all_properties_linkhttp://idx.diversesolutions.com/link/220431
 video_embed_code
 contact_video_embed_code
 meta_titleCharleston Real Estate | Dune Properties | Leverage Global Partners
 meta_descriptiondunes properties is the exclusive representative for Leverage Global Partners in Charleston, Mount Pleasant, Isle of Palms, West Ashley, James Island, Folly Beach, Sullivan's Island, Dewee's Island, SC, USA.
 meta_keywordsDunes Properties, Randy Walker, Charleston Real Estate, Mount Pleasant Real Estate, Isle of Palms Real Estate, West Ashley Real Estate, James Island Real Estate, Folly Beach Real Estate, Sullivan's Island Real Estate, Dewee's Island Real Estate, South Carolina Real Estate
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-08-24 13:29:47
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/219/dunes-properties
 website_shortdunesproperties.com
 name_with_locationdunes properties
 Logo(array)
 id2875
 modelBrokerage
 model_id219
 tagLogo
 name219.jpg
 typeimage/jpg
 size352394
 uri/assets/2875.jpg
 order0
 created2016-03-30 11:44:53
 modified2016-03-30 11:44:53
 3(array)
 Brokerage(array)
 id133
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2381475
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameStouffer Realty Inc
 broker_of_record_name
 short_nameStouffer Realty Inc
 usernameStoufferRealty
 password90e3506a4fa22fac2c3589ef68513c472431da13
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionGary Stouffer, Owner and Founder of Stouffer Realty, began specializing in upscale real estate and large tracts of land in his hometown of Bath, Ohio 33 years ago. His outstanding sales record and reputation in the area inspired him to get his Broker’s license and open Stouffer Realty. The legacy of Stouffer Realty took root, tripling their sales force within three years. This phenomenal rate of growth continues at Stouffer Realty, making it one of the foremost Real Estate brokerages in Northeast Ohio and your best choice for locating and selling Exquisite Homes across this region. Stouffer Realty’s agents share a unique spirit of cooperation, which are both our strongest asset as well as the foundation of the company’s exceptional service. Our dedicated agents work together as a team by always putting the needs of the client first. Our satisfied buyers and sellers are our best form of advertisement. Stouffer agents represent the top realtors in the area, many of which are multi-million dollar producers who specialize in selling exquisite residential and commercial properties at the best possible price. Hundreds of clients have discovered or built their dream property with Stouffer Realty. All Stouffer Realty professionals live in and support the communities they serve. They have first-hand knowledge of area property values, school systems, neighborhoods and finance options. As a result, they are able to negotiate from a position of understanding, integrity, experience and strength in the marketplace. Stouffer realty, Inc. is a leading real estate company in Northeast Ohio, built on a reputation of integrity and exceptional service. Locally owned and operated since 1997, Stouffer Realty has more than 160 agents and specialists in offices serving Akron/Fairlawn, Brecksville/Broadview Heights, Chagrin Falls/Solon, Green/Canton, Kent/Brimfield, Stow/Hudson/Cuyahoga Falls, Strongsville/Brunswick, Medina County and surrounding communities
 communitiesCleveland Hudson Solon Akron Fairlawn Bath Copley Richfield Medina Green Canton Cuyahoga Falls Stow Brimfield Kent Chagrin Valley Summit Wayne Stark Portage Geauga Cuyahoga Counties
 websitehttp://www.stoufferrealty.com/Exquisite-Homes/
 address130 North Miller Road
 address_2
 cityFairlawn
 stateOH
 full_stateOhio
 countryUSA
 marketCleveland
 market_2
 postal_code44333
 phone(330) 835-4900
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJim Fox
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBroker - Vice President of Sales & Operations
 contact_dre_num
 contact_quoteI invite you to contact me personally about Northeast Ohio real estate
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename133.jpg
 logo_filename133.jpg
 contact_image_filename133.jpg
 all_properties_link_image_filename133.JPG
 all_properties_linkhttp://www.stoufferrealty.com/listings/query.php?property_category=1&state=39&&pricemin=%24+750%2C000&cidonly=1&
 video_embed_code
 contact_video_embed_code
 meta_titleCleveland Real Estate | Stouffer Realty Inc | Leverage Global Partners
 meta_descriptionStouffer Realty Inc. is the exclusive representative for Leverage Global Partners in Cleveland, OH, USA.
 meta_keywordsStouffer Realty, Cleveland Real Estate, Jim Fox, Hudson real estate, Solon real estate, akron real estate, fairlawn real estate, bath real estate, copley real estate, richfield real estate, medina real estate, green real estate, canton real estate, cuyahoga falls real estate, stow real estate, brimfield real estate, kent real estate, summit real estate, chagrin valley real estate, wayne real estate, stark real estate, portage real estate, geauga real estate, cuyahoga real estate, ohio real estate, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-06-24 09:40:22
 modified2016-04-08 16:34:09
 dre_num012345
 uri/brokerage-detail/133/stouffer-realty-inc
 website_shortwww.stoufferrealty.com/Exquisite-Homes
 name_with_locationStouffer Realty Inc
 Logo(array)
 id2638
 modelBrokerage
 model_id133
 tagLogo
 name133.jpg
 typeimage/jpg
 size750656
 uri/assets/2638.jpg
 order0
 created2016-03-30 11:41:50
 modified2016-03-30 11:41:50
- sidebar_locations(array)
 0(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
 1(array)
 Location(array)
 id27
 parent_id9
 brokerage_id130
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameBend, OR, USA
 short_nameBend, OR, USA
 group_index
 latitude43.965721
 longitude-121.219643
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionDubbed the "outdoor playground of the West" for a thousand good reasons, Central Oregon is world famous for both its outdoor activities and majestic, snow-capped mountain peaks along the high-desert skyline.
 long_descriptionIn the high-desert of Central Oregon just east of the Cascade Range and nestled at the base of the Deschutes National Forest, Bend is to Oregon as Aspen is to Colorado or Truckee is to California. Bend has been growing rapidly over the years making it into the news as one of the best places to move and capturing the attention of retirees, young people, families, and small business entrepreneurs. For many who move to Bend, they are in search of a lifestyle change away from city living and are attracted to the year round ability of playing outside.
 created2016-04-04 11:36:16
 modified2016-04-04 11:36:16
 timezoneAmerica/Los_Angeles
 population200000
 uri/locations/view/27/bend-or-usa
 tile_nameBend, OR, USA
 Brokerage(array)
 id130
 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
 WOEID12798773
 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
 nameTotal Property Resources
 broker_of_record_name
 short_nameTotal Property Resources
 usernameTotalPropertyResource
 password141eb89e9f854e36925435c1cbd9632bbba8132f
 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
 descriptionTotal Property Resources is the exclusive representative for Leverage Global Partners in Bend, Sunriver, Redmond, Sisters, La Pine, Prineville, Tumalo, Crosswater, Pronghorn, Black Butte, Terrebonne, Madras, Powell Butte, Brasada, Culver and surrounding communities in Deschutes, Jefferson and Crook Counties, Oregon, USA. More information coming soon!
 communitiesSunriver Redmond Sisters La Pine Prineville Tumalo Crosswater Pronghorn Black Butte Terrebonne Madras Powell Butte Brasada Culver Deschutes Jefferson Crook
 websitehttp://totalbendrealestate.com/
 address547 SW 13th Street
 address_2Suite 201
 cityBend
 stateOR
 full_stateOregon
 countryUSA
 marketBend
 market_2
 postal_code97702
 phoneOffice: (503) 467-7237
 phone_2Cell: (503) 804-3927
 phone_3
 wide_contact_image(false)
 contact_nameJanis Alexander
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident and CEO
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename130.jpg
 logo_filename130.png
 contact_image_filename130.JPG
 all_properties_link_image_filename130.jpg
 all_properties_linkhttp://totalbendrealestate.com/top-picks/
 video_embed_code
 contact_video_embed_code
 meta_titleBend Real Estate | Total Property Resources | Leverage Global Partners
 meta_descriptionTotal Property Resources is the exclusive representative for Leverage Global Partners in the Bend, Oregon, USA.
 meta_keywordsTotal Property Resources, Bend Real Estate, Janis Alexander, Sunriver Real Estate, Redmond Real Estate, Sisters Real Estate, La Pine Real Estate, Prineville Real Estate, Tumalo Real Estate, Crosswater Real Estate, Pronghorn Real Estate, Black Butte Real Estate, Terrebonne Real Estate, Madras Real Estate, Powell Butte Real Estate, Brasada Real Estate, Culver Real Estate
 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-06-06 16:10:01
 modified2016-04-08 16:34:09
 dre_num012345
 uri/brokerage-detail/130/total-property-resources
 website_shorttotalbendrealestate.com
 name_with_locationTotal Property Resources
 Image(array)
 id2955
 modelLocation
 model_id27
 tagImage
 name39922990_tm814.jpg
 typeimage/jpeg
 size676078
 uri/assets/2955.jpg
 order0
 created2016-04-04 11:35:36
 modified2016-04-04 11:36:16
 2(array)
 Location(array)
 id176
 parent_id9
 brokerage_id116
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameSan Diego - Central Inland
 short_nameSan Diego - Central Inland
 group_index
 latitude32.715736
 longitude-117.161087
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_description
 created2016-04-12 19:02:49
 modified2016-04-12 19:02:49
 timezoneAmerica/Los_Angeles
 population0
 uri/locations/view/176/san-diego-central-inland
 tile_nameSan Diego - Central Inland
 Brokerage(array)
 id116
 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_properties1
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2487889
 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
 nameAscent Real Estate
 broker_of_record_name
 short_nameAscent Real Estate
 usernameAscentSDCentral
 password847ba57e0102581b0d6aaa7f2a3e234bbcb6e1f9
 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
 descriptionAscent Real Estate is the exclusive representative for Leverage Global Partners in Central Inland, Downtown, Mission Hills, Hillcrest, North Park, Kensington, University Heights, Normal Heights, Talmadge, Golden Hill, South Park, Carmel Valley, Poway, Mira Mesa and Central Inland San Diego, California, USA. At Ascent Real Estate, our Mission is to hire, develop, and retain the real estate industry’s most respected agents; cultivating a work environment that is cutting edge, diverse, ethical, compassionate, and strong in its convictions. Ascent Real Estate, established in 2005, is a privately held company that is owned and operated in San Diego, California. It was founded by Penny Nathan and Ken Pecus, two leading agents in the competitive San Diego marketplace. The partners share a combined experience of over 27 years as agents, and each has a diverse range of entrepreneurial experience. They created Ascent Real Estate to fill the customer service vacuum formed by the multi-national real estate monoliths as they expanded during the favorable market cycle. Ascent Real Estate is comprised of a talented and highly motivated team with extensive training and experience in all phases of real estate transactions. The company maintains excellent relationships with key players across the residential real estate industry including brokers, homebuilders, and financial partners. The Ascent Real Estate team is experienced in property sales and acquisitions ranging from expansive estates to single-family homes and condominiums. Ascent Real Estate embodies an enviable combination of entrepreneurial energy, comprehensive industry experience, and local market knowledge. This mix lets Ascent “out national” its local competition thanks to its exceptional professional team and world-class infrastructure, and “out local” the national competition thanks to its laser-like focus on the specific markets in which it operates. Now, with our alliance with Leverage Global Partners, we are able to connect our local communities with others around the world. Our local area experts welcome you, our global neighbors, to sunny San Diego. In addition Ascent Real Estate also has locations in <a href="../../../brokerage-detail/115/Ascent-Real-Estate">North Inland</a>, <a href="../../../brokerage-detail/117/Ascent-Real-Estate">South/East</a>, and <a href="../../../brokerage-detail/25/Ascent-Real-Estate">Coastal San Diego</a>, CA. 
 communitiesCentral Inland Downtown Mission Hills Hillcrest North Park Kensington University Heights Normal Heights Talmadge Golden Hill South Park Carmel Valley Poway Mira Mesa
 websitehttp://www.ascentrealestate.net/
 address410 Kalmia Street
 address_2
 citySan Diego
 stateCA
 full_stateCalifornia
 countryUSA
 marketSan Diego - Central Inland
 market_2
 postal_code92101
 phone(619) 325-4100
 phone_2
 phone_3
 wide_contact_image(false)
 contact_namePenny Nathan
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-penny-nathan-president-at-ascent-real-estate-san-diego/
 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_filename116.jpg
 logo_filename116.jpg
 contact_image_filename116.jpg
 all_properties_link_image_filename116.jpg
 all_properties_linkhttp://www.ascentrealestate.net/featured-properties
 video_embed_code
 contact_video_embed_code
 meta_titleSan Diego Real Estate | Ascent Real Estate | Leverage Global Partners
 meta_descriptionAscent Real Estate is the exclusive representative for Leverage Global Partners in San Diego, California, USA.
 meta_keywordsascent real estate, san diego real estate, san diego california, penny nathan, leverage global partners
 login_message_counter2
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-04-28 15:38:06
 modified2016-04-08 16:34:09
 dre_num012345
 uri/brokerage-detail/116/ascent-real-estate
 website_shortwww.ascentrealestate.net
 name_with_locationAscent Real Estate
 Image(array)
 id20748
 modelLocation
 model_id176
 tagImage
 nameScreen Shot 2016-04-12 at 7.00.13 PM.png
 typeimage/png
 size825097
 uri/assets/20748.png
 order0
 created2016-04-12 19:01:08
 modified2016-04-12 19:02:49
 3(array)
 Location(array)
 id163
 parent_id9
 brokerage_id224
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameRedondo Beach, CA, USA
 short_nameRedondo Beach, CA, USA
 group_index
 latitude33.849182
 longitude-118.388405
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 16:50:59
 modified2016-04-18 09:59:47
 timezoneAmerica/Los_Angeles
 population0
 uri/locations/view/163/redondo-beach-ca-usa
 tile_nameRedondo Beach, CA, USA
 Brokerage(array)
 id224
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties12
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2479664
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePartners Trust Real Estate Brokerage and Acquisitions
 broker_of_record_name
 short_namePartners Trust Real Estate
 usernamePartnersTrustRedondo
 passwordbd14f6ea444daa213da72e610c4f769298079632
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPartners Trust is the exclusive representative for Leverage Global Partners in Redondo Beach, CA, USA. We are also the exclusive representative for Leverage Global Partners in <a href="../../../brokerage-detail/223/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Manhattan Beach and Hermosa Beach, CA</a>. More information coming soon!
 communitiesRedondo Beach
 websitehttp://www.thepartnerstrust.com/
 address1219 Morningside Drive, Suite 202
 address_2
 cityManhattan Beach
 stateCA
 full_stateCalifornia
 countryUSA
 marketRedondo Beach
 market_2
 postal_code90266
 phoneCell: (310) 689-8779
 phone_2Office: (310) 500-3971
 phone_3
 wide_contact_image(false)
 contact_nameJan Rhees
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_title Founding Partner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename224.jpg
 logo_filename224.png
 contact_image_filename224.jpg
 all_properties_link_image_filename
 all_properties_linkhttp://www.thepartnerstrust.com/properties
 video_embed_code
 contact_video_embed_code
 meta_titleRedondo Beach Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
 meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions is an award-winning real estate brokerage representing Leverage Global Partners in Redondo Beach, CA, USA.
 meta_keywordspartners trust, partners trust real estate, Redondo Beach real estate, Redondo Beach real estate agents, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-09-18 17:02:43
 modified2016-04-15 10:29:17
 dre_num012345
 uri/brokerage-detail/224/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortwww.thepartnerstrust.com
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 Image(array)
 id20722
 modelLocation
 model_id163
 tagImage
 nameScreen Shot 2016-04-12 at 4.51.33 PM.png
 typeimage/png
 size947059
 uri/assets/20722.png
 order0
 created2016-04-12 16:51:54
 modified2016-04-18 09:59:47
- location_properties(empty)
- main_article(empty)
- brokerage(array)
 Brokerage(array)
 id189
 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
 WOEID2412843
 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
 name@Home Realty
 broker_of_record_name
 short_name@Home Realty
 username@HomeHolland
 passwordd1cebf5ac533384fa3a89067e00c53c6ae0e7aec
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 description@Home Realty is the exclusive representative for Leverage Global Partners in all of Ottawa, Muskegon and Kent Counties, including Grand Haven, Spring Lake, Norton Shores, Holland, Zeeland, Hudsonville and Greater Grand Rapids. Life is good @Home. We are proud to be a local company. We live here. We work here. We play here. We give here. Our focus on family and community sets us apart in providing a positive, refreshing and expert approach to your real estate needs. We are able to give you unparalleled service because of our partnerships with local companies, our command of the latest technology and marketing strategies, and our real estate industry expertise. Our expertise lies in our years of experience, our confidence gained from that experience and our love of this West Michigan community.
 communitiesKent County Ada Forest Hills Grand Rapids Rockford Grandville Holland Michigan
 websitehttp://www.homewestmichigan.com/
 address11539 E Lakewood Blvd
 address_2#70
 cityHolland
 stateMI
 full_stateMichigan
 countryUSA
 market
 market_2
 postal_code49424
 phoneDirect: (616) 935-9001
 phone_2Cell: (616) 250-1412
 phone_3
 wide_contact_image(false)
 contact_nameJake Hogeboom
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCEO/Broker
 contact_dre_num
 contact_quoteI invite you to contact me personally about West Michigan 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_filename189.JPG
 logo_filename189.png
 contact_image_filename189.jpg
 all_properties_link_image_filename189.jpg
 all_properties_linkhttp://search.homewestmichigan.com/idx/featured
 video_embed_code
 contact_video_embed_code
 meta_titleHolland Real Estate⎜@Home Realty⎜Leverage Global Partners
 meta_description@Home Realty is the exclusive representative for Leverage Global Partners in all of Kent County, MI, including Ada, Forest Hills, Grand Rapids, Rockford, Grandville, Holland, Michigan, USA.
 meta_keywords@Home Realty, Jake Hogeboom, Leverage Global Partners, Kent County Real Estate, Grand Rapids Real Estate, Michigan Real Estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-02-09 13:13:52
 modified2016-04-08 16:34:20
 dre_num012345
 uri/brokerage-detail/189/home-realty
 website_shortwww.homewestmichigan.com
 name_with_location@Home Realty - Grand Haven, MI, USA
 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)
 id2803
 modelBrokerage
 model_id189
 tagLogo
 name189.png
 typeimage/png
 size27323
 uri/assets/2803.png
 order0
 created2016-03-30 11:44:09
 modified2016-03-30 11:44:09
 MainImage(array)
 id2802
 modelBrokerage
 model_id189
 tagMainImage
 name189.JPG
 typeimage/JPG
 size10090711
 uri/assets/2802.JPG
 order0
 created2016-03-30 11:44:07
 modified2016-03-30 11:44:07
 ContactImage(array)
 id2804
 modelBrokerage
 model_id189
 tagContactImage
 name189.jpg
 typeimage/jpg
 size238375
 uri/assets/2804.jpg
 order0
 created2016-03-30 11:44:09
 modified2016-03-30 11:44:09
 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)
 id17
 parent_id9
 brokerage_id189
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameGrand Haven, MI, USA
 short_nameGrand Haven, MI, USA
 group_index
 latitude43.014702
 longitude-86.195518
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionLovers of the outdoors will feel right at home in Grand Haven, as the port community boasts plenty of opportunities to enjoy different activities such as boating, fishing, hiking, skating, biking, camping, and much, much more.
 long_descriptionWelcome to Grand Haven, one of Michigan's featured Beachtowns and a renaissance city that has become a beacon for those looking for simplicity in a scene of natural beauty. From its roots as a highly commercial port-of-call for ferries and passenger liners, Grand Haven has evolved to become a place of serene, family enjoyment, hosting lively outdoor recreation, a thriving downtown, history, culture, world's largest musical fountain, boardwalk, beautiful beaches, lighthouses, historic downtown, and more. USA Today recently voted Grand Haven State Park’s 48 acres of sand as one of the country’s best freshwater beaches, which, on a hot summer’s day is a dream dip in the clear and cool waters of Lake Michigan. It’s a popular place for retirees who split their time between two regions, as West Michigan is best in summer when it’s warm, the days are long, and the charming downtown streets are alive with summer festivals!
 created2016-04-04 10:38:42
 modified2016-04-04 11:07:07
 timezoneAmerica/Detroit
 population10500
 uri/locations/view/17/grand-haven-mi-usa
 tile_nameGrand Haven, MI, USA
 User(array)
 0(array)
 id179
 typeBrokerageAdmin
 brokerage_id189
 email[email protected]
 passwordd1cebf5ac533384fa3a89067e00c53c6ae0e7aec
 recover_hash
 first_nameJake
 last_nameHogeboom
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2016-04-12 08:30:20
 created2016-04-08 16:34:20
 notified(true)
 full_nameJake Hogeboom
 uri/agent-detail/179/jake-hogeboom
 profile_complete(true)
 1(array)
 id481
 typeAgent
 brokerage_id189
 email[email protected]
 password649bd674c514a63d32b011ce8fd01ba0ddb76195
 recover_hash
 first_nameLuke
 last_nameBouman
 title
 dre_num
 phone(616) 502-8897
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:59
 created2017-08-07 15:22:59
 notified(false)
 full_nameLuke Bouman
 uri/agent-detail/481/luke-bouman
 profile_complete(true)
 2(array)
 id769
 typeAgent
 brokerage_id189
 email[email protected]
 password9ad8425986f080f539e1ba3d0dcebfde02ec0a57
 recover_hash
 first_nameTodd
 last_nameWalters
 title
 dre_num
 phone(616) 836-1210
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:21
 created2017-08-07 15:23:21
 notified(false)
 full_nameTodd Walters
 uri/agent-detail/769/todd-walters
 profile_complete(true)
 3(array)
 id886
 typeAgent
 brokerage_id189
 email[email protected]
 passwordb605e8cd5fdfd6d466c798d8812cbf3da3c1eb6e
 recover_hash
 first_nameSean
 last_nameTerpstra
 title
 dre_num
 phone(616) 886-9839
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:43
 created2017-08-07 15:23:43
 notified(false)
 full_nameSean Terpstra
 uri/agent-detail/886/sean-terpstra
 profile_complete(true)
 4(array)
 id1196
 typeAgent
 brokerage_id189
 email[email protected]
 password3473f84fbc48c741fd56aafcd9590ea6474fb0d5
 recover_hash
 first_nameRebecca
 last_namePerkins
 title
 dre_num
 phone(616) 218-6161
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:58
 created2017-08-07 15:23:58
 notified(false)
 full_nameRebecca Perkins
 uri/agent-detail/1196/rebecca-perkins
 profile_complete(true)
- location(array)
 Location(array)
 id17
 parent_id9
 brokerage_id189
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameGrand Haven, MI, USA
 short_nameGrand Haven, MI, USA
 group_index
 latitude43.014702
 longitude-86.195518
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionLovers of the outdoors will feel right at home in Grand Haven, as the port community boasts plenty of opportunities to enjoy different activities such as boating, fishing, hiking, skating, biking, camping, and much, much more.
 long_descriptionWelcome to Grand Haven, one of Michigan's featured Beachtowns and a renaissance city that has become a beacon for those looking for simplicity in a scene of natural beauty. From its roots as a highly commercial port-of-call for ferries and passenger liners, Grand Haven has evolved to become a place of serene, family enjoyment, hosting lively outdoor recreation, a thriving downtown, history, culture, world's largest musical fountain, boardwalk, beautiful beaches, lighthouses, historic downtown, and more. USA Today recently voted Grand Haven State Park’s 48 acres of sand as one of the country’s best freshwater beaches, which, on a hot summer’s day is a dream dip in the clear and cool waters of Lake Michigan. It’s a popular place for retirees who split their time between two regions, as West Michigan is best in summer when it’s warm, the days are long, and the charming downtown streets are alive with summer festivals!
 created2016-04-04 10:38:42
 modified2016-04-04 11:07:07
 timezoneAmerica/Detroit
 population10500
 uri/locations/view/17/grand-haven-mi-usa
 tile_nameGrand Haven, MI, USA
 Image(array)
 id2944
 modelLocation
 model_id17
 tagImage
 name@home2222.jpg
 typeimage/jpeg
 size12765849
 uri/assets/2944.jpg
 order0
 created2016-04-04 10:36:13
 modified2016-04-04 11:07:07
- 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/17/grand-haven-mi-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/locations/view/17/grand-haven-mi-usa
Remote Port	14542
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	a09d85303e9334fc-CMH
Http Accept Encoding	gzip, br
Http Cookie	CAKEPHP=q5ulgl3qbim1p2tbofjktjnfk6
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	aiorIfK8CRJnCvkkTtrr1wAAAMU
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	aiorIfK8CRJnCvkkTtrr1wAAAMU
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781148449.3346
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
====

Grand Haven, MI, USA

Location Represented By

Related Articles

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

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