Locations / Vero Beach, FL, USA

Vero Beach, FL, USA

Known as “The Hamptons of Florida”, the charming, seaside community of Vero Beach is one of the most coveted destinations on Florida’s east coast. Refined yet unpretentious, the town hosts boutique shops, fine dining, a sophisticated and diverse cultural arts scene, and an affluent social and corporate elite that prefers the peaceful atmosphere. The casual chic village is also known for its varied and unique ecological and recreational options featuring numerous parks and wildlife refuges, miles of beautiful, uncrowded beaches, and surfing competitions to polo matches. Whether seeking primary residency or a vacation escape, Vero is an undiscovered coastal gem.

Location Represented By

License #: 012345

11:27pm local time
16 thousand population

Partner Search

Find partners with a map-based search

Related Locations

Related Partners

Recent Property Listings

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

Array
(
)

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

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

No post data.

Query string

No querystring data.

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

Sql Log

Sql Logs

default

Total Time: 49 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` = 129 AND `Location`.`archived` = '0' LIMIT 1	1	1	0
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `AccountExecutive`.`id`, `AccountExecutive`.`type`, `AccountExecutive`.`brokerage_id`, `AccountExecutive`.`email`, `AccountExecutive`.`password`, `AccountExecutive`.`recover_hash`, `AccountExecutive`.`first_name`, `AccountExecutive`.`last_name`, `AccountExecutive`.`title`, `AccountExecutive`.`dre_num`, `AccountExecutive`.`phone`, `AccountExecutive`.`max_luxury_feed_properties`, `AccountExecutive`.`headshot_filename`, `AccountExecutive`.`bio`, `AccountExecutive`.`brokerage_name_override`, `AccountExecutive`.`stripe_customer_id`, `AccountExecutive`.`digital_ad_first_free_month_coupon`, `AccountExecutive`.`modified`, `AccountExecutive`.`created`, `AccountExecutive`.`notified`, (CONCAT(`AccountExecutive`.`first_name`, " ", `AccountExecutive`.`last_name`)) AS `AccountExecutive__full_name`, `Logo`.`id`, `Logo`.`model`, `Logo`.`model_id`, `Logo`.`tag`, `Logo`.`name`, `Logo`.`type`, `Logo`.`size`, `Logo`.`uri`, `Logo`.`order`, `Logo`.`created`, `Logo`.`modified`, `MainImage`.`id`, `MainImage`.`model`, `MainImage`.`model_id`, `MainImage`.`tag`, `MainImage`.`name`, `MainImage`.`type`, `MainImage`.`size`, `MainImage`.`uri`, `MainImage`.`order`, `MainImage`.`created`, `MainImage`.`modified`, `ContactImage`.`id`, `ContactImage`.`model`, `ContactImage`.`model_id`, `ContactImage`.`tag`, `ContactImage`.`name`, `ContactImage`.`type`, `ContactImage`.`size`, `ContactImage`.`uri`, `ContactImage`.`order`, `ContactImage`.`created`, `ContactImage`.`modified`, `ContactImage2`.`id`, `ContactImage2`.`model`, `ContactImage2`.`model_id`, `ContactImage2`.`tag`, `ContactImage2`.`name`, `ContactImage2`.`type`, `ContactImage2`.`size`, `ContactImage2`.`uri`, `ContactImage2`.`order`, `ContactImage2`.`created`, `ContactImage2`.`modified`, `ContactImage3`.`id`, `ContactImage3`.`model`, `ContactImage3`.`model_id`, `ContactImage3`.`tag`, `ContactImage3`.`name`, `ContactImage3`.`type`, `ContactImage3`.`size`, `ContactImage3`.`uri`, `ContactImage3`.`order`, `ContactImage3`.`created`, `ContactImage3`.`modified`, `BrokerOfRecordLogo`.`id`, `BrokerOfRecordLogo`.`model`, `BrokerOfRecordLogo`.`model_id`, `BrokerOfRecordLogo`.`tag`, `BrokerOfRecordLogo`.`name`, `BrokerOfRecordLogo`.`type`, `BrokerOfRecordLogo`.`size`, `BrokerOfRecordLogo`.`uri`, `BrokerOfRecordLogo`.`order`, `BrokerOfRecordLogo`.`created`, `BrokerOfRecordLogo`.`modified`, `MainArticle`.`id`, `MainArticle`.`model`, `MainArticle`.`model_id`, `MainArticle`.`archived`, `MainArticle`.`medium_featured`, `MainArticle`.`large_featured`, `MainArticle`.`title`, `MainArticle`.`author`, `MainArticle`.`date`, `MainArticle`.`lead_in`, `MainArticle`.`body`, `MainArticle`.`vimeo_id`, `MainArticle`.`created`, `MainArticle`.`modified` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` LEFT JOIN `leveragere_staging2`.`users` AS `AccountExecutive` ON (`Brokerage`.`account_executive_id` = `AccountExecutive`.`id`) LEFT JOIN `leveragere_staging2`.`assets` AS `Logo` ON (`Logo`.`model_id` = `Brokerage`.`id` AND `Logo`.`model` = 'Brokerage' AND `Logo`.`tag` = 'Logo') LEFT JOIN `leveragere_staging2`.`assets` AS `MainImage` ON (`MainImage`.`model_id` = `Brokerage`.`id` AND `MainImage`.`model` = 'Brokerage' AND `MainImage`.`tag` = 'MainImage') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage` ON (`ContactImage`.`model_id` = `Brokerage`.`id` AND `ContactImage`.`model` = 'Brokerage' AND `ContactImage`.`tag` = 'ContactImage') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage2` ON (`ContactImage2`.`model_id` = `Brokerage`.`id` AND `ContactImage2`.`model` = 'Brokerage' AND `ContactImage2`.`tag` = 'ContactImage2') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage3` ON (`ContactImage3`.`model_id` = `Brokerage`.`id` AND `ContactImage3`.`model` = 'Brokerage' AND `ContactImage3`.`tag` = 'ContactImage3') LEFT JOIN `leveragere_staging2`.`assets` AS `BrokerOfRecordLogo` ON (`BrokerOfRecordLogo`.`model_id` = `Brokerage`.`id` AND `BrokerOfRecordLogo`.`model` = 'Brokerage' AND `BrokerOfRecordLogo`.`tag` = 'BrokerOfRecordLogo') LEFT JOIN `leveragere_staging2`.`articles` AS `MainArticle` ON (`MainArticle`.`model_id` = `Brokerage`.`id` AND `MainArticle`.`model` = 'Brokerage') WHERE `Brokerage`.`id` = 147 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` = (147) ORDER BY `FeaturedImage`.`order` ASC	3	3	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` = (147)	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` = (147)	12	12	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` = 129 LIMIT 1	0	0	1	maybe slow
SELECT `Location`.`id`, `Location`.`name`, `Location`.`parent_id` FROM `leveragere_staging2`.`locations` AS `Location` WHERE `Location`.`id` = 129 AND `Location`.`archived` = '0' LIMIT 1	1	1	2	maybe slow
SELECT `Location`.`id`, `Location`.`name` FROM `leveragere_staging2`.`locations` AS `Location` WHERE `Location`.`parent_id` = 129	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	11	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	9	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`, `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	8	maybe slow
SELECT `Property`.`id` FROM `leveragere_staging2`.`properties` AS `Property` WHERE `Property`.`archived` = '0' AND `Property`.`incomplete` = '0' ORDER BY `Property`.`created` DESC LIMIT 50	50	50	5	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	9	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 (3708, 3722, 3754, 3715) ORDER BY `Image`.`order` ASC	40	40	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 (3708, 3722, 3754, 3715) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	5	5	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (3708, 3722, 3754, 3715) 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 (3708, 3722, 3754, 3715) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	5	5	2	maybe slow
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 (3708, 3722, 3754, 3715) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	1	1	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 11.67 MB

Message	Memory use
Component initialization	2.88 MB
Controller action start	3.80 MB
Controller render start	6.65 MB
View render complete	7.21 MB

Timers

Total Request Time: 277 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	28.46
Event: Controller.initialize	3.90
Event: Controller.startup	1.15
Controller action	86.84
Event: Controller.beforeRender	24.12
» Processing toolbar data	23.99
Rendering View	98.09
» Event: View.beforeRender	0.30
» Rendering APP/View/Locations/view.ctp	2.65
» » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.14
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.16
» » Rendering APP/View/Elements/sidebar/brokerage_list.ctp	0.18
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.28
» » » Rendering APP/View/Elements/static_property_price.ctp	0.38
» » » 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	94.41
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)
 id3708
 brokerage_id80
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id1224
 agent_2_id1225
 agent_3_id0
 nameDowntown Dupont Luxury
 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)
 descriptionConstructed in 2013, be the first to own this stunning contemporary light-filled duplex. Open living space flanked by floor-to-ceiling windows; balconies, roof deck and finishing details meld beautifully with this historic building's exterior in this prime Dupont location, only two blocks from Metro's Red Line. Main Entrance: Foyer Interior Style: Floor Plan-Open Dining/Kitchen: Gourmet, Kit-Island, Kit-Dining Combo, Liv-Din Combo Appliances: Oven / Range - Gas, Six Burner Stove, Refrigerator, Icemaker, Exhaust Fan, Dishwasher, Disposal, Dryer - Front Loading, Washer - Front Loading, Water Heater - High-Efficiency Amenities: Attached Master Bathroom, Bathroom(s) - Ceramic Tile, Bedroom - Entry Level, Built-in Bookcases, Closet - Master Bedroom Walk-in, Countertop(s) - Granite, Elevator, Vanities - Double, Whirlpool Jets, Wood Floors, Shades / Blinds, Master Bathroom - Separate Shower, High Efficiency Toilet(s), Closet(s) - Walk-in, Tub - Soaking Security: Fire Detect Sys, Main Entrance Lock, Spkler Sys-indoor Windows/Doors: Double Pane Windows, Recessed Lighting, Sliding Glass Door Walls/Ceilings: 9'+ Ceilings, Dry Wall, Plaster Walls
 address1737 Connecticut Avenue, NW, #502
 address_2
 cityWashington
 stateDC
 postal_code20009
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1575000
 price_20
 price_usd1575000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms2
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://www.eversco.com/homes-for-sale-details/1737-CONNECTICUT-AVENUE-NORTHWEST-502-WASHINGTON-DC-20009/DC9599732/30/
 meta_titleDowntown Dupont Luxury | Washington Real Estate | Evers & Co. Real Estate
 meta_description1737 Connecticut Avenue, NW, #502 is a property offered for sale in Washington, DC, USA, presented by Evers & Co. Real Estate
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://slideshow.mris.com/slideshow/slideshow.htm?ListingKey=300033619913
 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_fields
 invalid_optional_fieldssquare_feet, square_meters, acres, hectares, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-04-06 14:18:15
 uri/property-detail/3708/1737-connecticut-avenue-nw-502-washington-dc-20009-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3708/1737-connecticut-avenue-nw-502-washington-dc-20009-usa
 address_concat1737 Connecticut Avenue, NW, #502 Washington DC 20009 USA
 google_maps_query_string1737+Connecticut+Avenue%2C+NW%2C+%23502++Washington+DC+20009+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,575,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty2
 bathrooms_pretty2
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2016-04-06
 overridden_brokerage_nameEvers & Co. Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id80
 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
 WOEID2514815
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameEvers & Co. Real Estate
 broker_of_record_name
 short_nameEvers & Co. Real Estate
 usernameEversCoRealEstateDC
 password8c94cd238914e1ba6f88d53a1a78f02c47944eeb
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionEvers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Washington, DC and <a href="../../../brokerage-detail/81/Evers-&-Co.-Real-Estate">Chevy Chase</a>, MD, USA. We are 100+ salespeople who offer our clients a level of service that is unmatched in today’s real estate marketplace, and we deliver this extraordinary service with courtesy and integrity to everyone involved in each transaction. We are enthusiastic about the neighborhoods where we live and work, from Chevy Chase to Capitol Hill, from Dupont Circle to Arlington, and everywhere in between. The highly visible storefront offices of Evers & Co. in Downtown Washington, Friendship Heights in Upper Northwest, downtown Bethesda-Chevy Chase and in Bluemont in the Virginia Wine Country are bustling with the entrepreneurial energy of agents who have in-depth knowledge of local history, architecture and construction techniques as well as expert skills in marketing and negotiating, all of which adds value to our service and your investment. This spectrum of knowledge and our commitment to serving our clientele and fellow real estate associates with the highest level of integrity has made us the premier independent brokerage in the Metropolitan Washington area. Donna Evers and the agents of Evers & Co. invite you to join our growing community of buyers and sellers, who have been the source of 90% of our business for the past thirty years.
 communitieswashington, DC chevy chase dupont kalorama georgetown american university park cleveland park Palisades logan circle capitol hill forest hills
 websitehttp://www.eversco.com/
 address4400 Jenifer Street, NW
 address_2
 cityWashington, D.C
 state
 full_state
 countryUSA
 marketWashington, D.C
 market_2
 postal_code20015
 phoneOffice: (202) 364-1700
 phone_2Cell: (202) 255-5009
 phone_3
 wide_contact_image(false)
 contact_nameDonna Evers
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident & Founder
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename80.jpg
 logo_filename80.jpg
 contact_image_filename80.jpg
 all_properties_link_image_filename80.JPG
 all_properties_linkhttp://eversco.idxre.com/featured/40484?CFID=10711248&CFTOKEN=99152164
 video_embed_code
 contact_video_embed_code
 meta_titleWashington DC Real Estate | Evers & Co. Real Estate | Leverage Global Partners
 meta_descriptionEvers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Washington, DC , Chevy Chase, Dupont, Kalorama, Georgetown, American University Park, Cleveland Park, Palisades, Logan Circle, Capitol Hill, and Forest Hills.
 meta_keywordsWashington DC Real Estate, Evers & Co. Real Estate, Leverage Global Partners, chevy chase real estate, dupont real estate, kalorama real estate, georgetown, american university park real estate, cleveland park real estate, Palisades real estate, logan circle real estate, capitol hill real estate, forest hills real estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-01-10 16:30:33
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/80/evers-co-real-estate
 website_shortwww.eversco.com
 name_with_locationEvers & Co. Real Estate
 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)
 id20565
 modelProperty
 model_id3708
 tagImage
 name36012.jpg
 typeimage/jpg
 size5032972
 uri/assets/20565.jpg
 order2894
 created2016-04-07 17:34:09
 modified2016-04-07 17:34:09
 User(array)
 0(array)
 id1267
 typeAgent
 brokerage_id80
 email[email protected]
 password64ae12b776051115a6c20b7eb8f0d36df7c5c187
 recover_hash
 first_nameBren
 last_nameLizzio
 title
 dre_num
 phone2026694999
 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_nameBren Lizzio
 uri/agent-detail/1267/bren-lizzio
 profile_complete(true)
 UsersProperty(array)
 id1096
 user_id1267
 property_id3708
 sort_order0
 1(array)
 id1268
 typeAgent
 brokerage_id80
 email[email protected]
 password72ce72c1db831d3b7e5697bf25ee0217b3739349
 recover_hash
 first_nameAndrea
 last_nameEvers
 title
 dre_num
 phone2025508934
 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_nameAndrea Evers
 uri/agent-detail/1268/andrea-evers
 profile_complete(true)
 UsersProperty(array)
 id1097
 user_id1268
 property_id3708
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 1(array)
 Property(array)
 id3722
 brokerage_id169
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameBeautiful Riders Retreat Next To Vineyards
 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)
 descriptionNestled in the Santa Ynez Valley is this Craftsman style beauty. Rural Setting adjacent to a vineyard overlooks the beautiful mountain ranges providing breathtaking views. Situated on one acre, this custom-built home comes with a converted barn permitted as a second residence. Master bedroom is on the downstairs level in this 3 bedroom 3 bath home. 
 address780 Carriage Drive
 address_2
 citySolvang
 stateCA
 postal_code93463
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1280000
 price_20
 price_usd1280000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms3
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet2254
 square_meters
 acres1
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size1
 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_built2007
 virtual_tourhttp://tours.tourfactory.com/tours/tour.asp?t=1532559&idx=1
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num1065537
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude34.603176
 longitude34.603176
 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-12 14:38:17
 uri/property-detail/3722/780-carriage-drive-solvang-ca-93463-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3722/780-carriage-drive-solvang-ca-93463-usa
 address_concat780 Carriage Drive Solvang CA 93463 USA
 google_maps_query_string780+Carriage+Drive++Solvang+CA+93463+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,280,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty3
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-04-12
 overridden_brokerage_nameCentral Coast Realty Group
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id169
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2469027
 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
 nameCentral Coast Realty Group
 broker_of_record_name
 short_nameCentral Coast Realty Group
 usernameCentralCoastRealtyGroup
 passwordc3fb4d7011e0e75ebb30dab389ea3ffbc5c48040
 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
 descriptionCentral Coast Realty Group (CCRG) is the exclusive representative for Leverage Global Partners here on the Central Coast of California which encompasses the areas of San Luis Obispo, Paso Robles, Cambria, Morro Bay, Cayucos, Baywood-Los Osos, Templeton, Atascadero, Santa Margarita, Avila Beach, Shell Beach, Pismo Beach, Arroyo Grande, Nipomo, Santa Maria, Orcutt and Lompoc valley. Central Coast Realty Group (CCRG) is a leading boutique real estate agency with multiple locations across California’s Central Coast. We are truly dedicated to our first priority: our customers. When you choose CCRG, you obtain a trusted group of experts with innovative visions and a commitment to our community. We provide the highest level of quality resources, support and services using our management team with over 30 years of experience. We prudently developed a diverse group of dedicated, enthusiastic professionals -- and only continue to grow. All of our agents have extensive knowledge and are proud to represent the areas on the California Central Coast. We believe our customer-focused approach to real estate enables strong relationships with valued clients and reinforces our reputation of integrity, reliability and most importantly, trust. CCRG ensures that every step of a transaction will have a personal touch. For further information about our company and services, feel free to contact Erny (805-994-2009) or Eric (805-782-6005). Central Coast Realty Group is licensed with the California Bureau of Real Estate – License #01854124. Learn more about CCRG by visiting our website: <a href="http://www.theccrg.com" target="_blank">www.theccrg.com</a>
 communitiesSan Luis Obispo Paso Robles Cambria Morro Bay Cayucos Baywood-Los Osos Templeton Atascadero Santa Margarita Avila Beach Shell Beach Pismo Beach Arroyo Grande Nipomo Santa Maria Orcutt Lompoc Los Alamos Santa Ynez CCRG
 websitehttp://www.theccrg.com/
 addressRepresenting the Central Coast
 address_2
 citySan Luis Obispo
 stateCA
 full_stateCalifornia
 countryUSA
 marketSan Luis Obispo
 market_2
 postal_code93401
 phone805-994-2097
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameErny Pinckert, Eric Pinckert
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCo-Owners
 contact_dre_num
 contact_quoteWe invite you to contact us about real estate on the Central Coast.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename169.jpg
 logo_filename169.jpg
 contact_image_filename169.JPG
 all_properties_link_image_filename169.jpg
 all_properties_linkhttp://www.theccrg.com/view-our-current-listings.aspx
 video_embed_code
 contact_video_embed_code
 meta_titleSan Luis Obispo Real Estate⎜Central Coast Realty Group⎜Leverage Global Partners
 meta_descriptionCentral Coast Realty Group is the exclusive representative for Leverage Global Partners in San Luis Obispo, CA, USA.
 meta_keywordsCentral Coast Realty Group, San Luis Obispo Real Estate, Paso Robles Real Estate, Cambria Real Estate, Morro Bay Real Estate, Cayucos Real Estate, Baywood-Los Osos Real Estate, Templeton Real Estate, Atascadero Real Estate, Santa Margarita Real Estate, Avila Beach Real Estate, Shell Beach Real Estate, Pismo Beach Real Estate, Arroyo Grande Real Estate, Nipomo Real Estate, Santa Maria Real Estate, Orcutt Real Estate, Lompoc 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-10-30 13:20:55
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/169/central-coast-realty-group
 website_shortwww.theccrg.com
 name_with_locationCentral Coast 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)
 id20704
 modelProperty
 model_id3722
 tagImage
 nameHD front.jpg
 typeimage/jpeg
 size3367728
 uri/assets/20704.jpg
 order0
 created2016-04-12 14:33:43
 modified2016-04-12 14:53:28
 1(array)
 id20706
 modelProperty
 model_id3722
 tagImage
 nameHD ariel view.jpg
 typeimage/jpeg
 size3498585
 uri/assets/20706.jpg
 order1
 created2016-04-12 14:34:54
 modified2016-04-12 14:53:28
 2(array)
 id20700
 modelProperty
 model_id3722
 tagImage
 namevineyard.jpg
 typeimage/jpeg
 size141799
 uri/assets/20700.jpg
 order2
 created2016-04-12 14:33:28
 modified2016-04-12 14:53:28
 3(array)
 id20707
 modelProperty
 model_id3722
 tagImage
 nameHD living room w fireplace.jpg
 typeimage/jpeg
 size1984485
 uri/assets/20707.jpg
 order3
 created2016-04-12 14:35:37
 modified2016-04-12 14:53:28
 4(array)
 id20703
 modelProperty
 model_id3722
 tagImage
 nameHD office.jpg
 typeimage/jpeg
 size2126202
 uri/assets/20703.jpg
 order4
 created2016-04-12 14:33:40
 modified2016-04-12 14:53:28
 5(array)
 id20699
 modelProperty
 model_id3722
 tagImage
 namekitchen.jpg
 typeimage/jpeg
 size108649
 uri/assets/20699.jpg
 order5
 created2016-04-12 14:33:28
 modified2016-04-12 14:53:28
 6(array)
 id20705
 modelProperty
 model_id3722
 tagImage
 nameHD guest house.jpg
 typeimage/jpeg
 size4021855
 uri/assets/20705.jpg
 order6
 created2016-04-12 14:33:44
 modified2016-04-12 14:53:28
 7(array)
 id20698
 modelProperty
 model_id3722
 tagImage
 namevault ceiling.jpg
 typeimage/jpeg
 size99804
 uri/assets/20698.jpg
 order7
 created2016-04-12 14:33:28
 modified2016-04-12 14:53:28
 8(array)
 id20708
 modelProperty
 model_id3722
 tagImage
 namedining with views.jpg
 typeimage/jpeg
 size120841
 uri/assets/20708.jpg
 order8
 created2016-04-12 14:36:05
 modified2016-04-12 14:53:28
 9(array)
 id20709
 modelProperty
 model_id3722
 tagImage
 nameHD guest living.jpg
 typeimage/jpeg
 size1669910
 uri/assets/20709.jpg
 order9
 created2016-04-12 14:36:17
 modified2016-04-12 14:53:28
 User(array)
 0(array)
 id661
 typeAgent
 brokerage_id169
 email[email protected]
 password195ec6407fe1350e0b2aff7bb373c13214b0ff2d
 recover_hash
 first_nameDebbie
 last_nameMcComb
 title
 dre_num
 phone805-757-7700
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:13
 created2017-08-07 15:23:13
 notified(false)
 full_nameDebbie McComb
 uri/agent-detail/661/debbie-mccomb
 profile_complete(true)
 UsersProperty(array)
 id458
 user_id661
 property_id3722
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id15
 nameVineyard
 additional(false)
 created2016-04-07 14:05:15
 modified2016-04-07 14:05:15
 PropertiesPropertyFeature(array)
 id4382
 property_id3722
 property_feature_id15
 1(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id4381
 property_id3722
 property_feature_id14
 2(array)
 id9
 nameOffice
 additional(false)
 created2016-04-07 14:03:21
 modified2016-04-07 14:03:21
 PropertiesPropertyFeature(array)
 id4380
 property_id3722
 property_feature_id9
 3(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id4379
 property_id3722
 property_feature_id5
 Topic(array)
 0(array)
 id7
 nameEquestrian
 created2016-02-25 11:25:00
 modified2016-02-25 11:31:54
 tile_nameEquestrian
 PropertiesTopic(array)
 id19
 property_id3722
 topic_id7
 2(array)
 Property(array)
 id3754
 brokerage_id16
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameBoutique State-of-the-Art Condo in the West Village
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(false)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time2019-10-29 20:09:29
 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_sent2019-10-31 20:45:16
 digital_ad_summary_price_changed(false)
 wsj_detail_urlhttps://realestate.wsj.com/newyork/2204846-385-west-12th-street-10014?mod=search&pos=7&page=1&
 ft_detail_urlhttps://propertylistings.ft.com/homes/2755194
 nyt_detail_urlhttps://www.nytimes.com/real-estate/usa/ny/new-york/west-village/homes-for-sale/385-west-12th-street/1106-PRCH-2762625
 juwai_detail_urlhttps://www.juwai.com/50318262.htm
 pgl_detail_urlhttps://www.propgoluxury.com/en/homes/2755194
 mg_detail_urlhttps://www.mansionglobal.com/newyork/2204846-385-west-12th-street-10014?mod=search&pos=6&page=1&&region=na,us
 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)
 description385 West 12th Street, a boutique and state-of-the-art condominium in the West Village, boasts this magnificent 3-bedroom, 2.5-bathroom apartment. It is meticulously designed to the highest standard and spans 2,711SF. A private elevator landing opens to the heart of the home. Upon entering, the thoughtful layout leads left to the living areas and additional bedrooms, ensuring privacy to the master suite which is to the right. A powder room is cleverly tucked opposite the landing, perfect for guests. The sitting room is anchored by a gas fireplace and leads to the light-filled living room. Separating the living and dining areas is discreet storage. Treetops and the cobblestoned street can be seen through the massive, floor-to-ceiling window that frames the dining room. Overlooking the dining room is an oversized chefâs kitchen; ideal for both large events, and intimate, countertop eating. It boasts custom white lacquered oak cabinetry complimented by the marble countertops and backsplash. Itâs equipped with top-of-the-line Miele and Gaggenau appliances, Franke sinks/faucets and wine fridge. The spacious master suite features a generous terrace, walk-in closet and stunning five-piece bathroom. The bathroom is outfitted in Italian marble with a deep-soaking tub, glass-enclosed shower, and radiant floor heating. A media room, home office, two additional bedrooms, an additional full bathroom and washer/dryer complete the home. Additional features include Control 4- fully integrated home automation. Completed in 2010, 385 West 12th Street is a boutique condominium with only 12 units among 7 stories. Amenities offer the perfect balance of leisure and entertainment and feature a recently renovated and beautifully landscaped rooftop with a 55-foot swimming pool, Jacuzzi, outdoor shower, two gas grills and dining space. Direct views of the Hudson River, the West Village, and Empire State Building, with views to the north crown the rooftop. Additional building amenities include a 24-hour doorman/concierge, millwork club locker in the lobby, bike storage, and cellar storage room.
 address385 West 12th Street
 address_23WEST
 cityNew York
 stateNY
 postal_code10014
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price5000000
 price_20
 price_usd5000000
 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_built2004
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num123456
 wsj_property_typecondominium
 nyt_property_type5
 nyt_popular_features
 propgolux_property_type2
 juwai_property_typeApartments/Condo
 juwai_categoryresidential
 propgolux_property_style25
 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.737713
 longitude-74.008759
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(false)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2019-10-31 20:45:16
 created2019-10-29 20:06:20
 uri/property-detail/3754/385-west-12th-street-3west-new-york-ny-10014-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3754/385-west-12th-street-3west-new-york-ny-10014-usa
 address_concat385 West 12th Street 3WEST New York NY 10014 USA
 google_maps_query_string385+West+12th+Street+3WEST+New+York+NY+10014+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 5,000,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty0
 bathrooms_pretty0
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms0
 date_listed2019-10-29
 overridden_brokerage_nameCORE
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id16
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties20
 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
 WOEID12589342
 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
 nameCORE
 broker_of_record_name
 short_nameCORE
 usernameCORENYC
 password6bbc31e8f00594b7e3433f0a9c0cd7334bff73ae
 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
 descriptionCORE is the exclusive representative for Leverage Global Partners in New York City, New York, USA. CORE is the leading, full-service, boutique real estate brokerage specializing in the marketing of premiere residential properties. Headquartered in New York City, CORE was founded by CEO Shaun Osher and Jack Cayre, who envisioned a dynamic boutique brokerage based on integrity, informed by expertise and driven by innovation. CORE offers comprehensive real estate solutions for buyers, sellers, landlords, investors and developers. The firm is powered by an integrated team of accomplished professionals with extensive expertise in all aspects of real estate transactions. Thanks to a unique marketing approach, CORE ensures that its clients earn the highest market-driven prices. Our agents educate and shepherd buyers, sellers and landlords through the sales or leasing process. And we partner closely with developers, from the earliest stages of a project through closing; partnerships, which boast a proven, profitable track record. Within the past 8 years, CORE has marketed more than 30 new development properties and is the #1 brokerage in its class.
 communitiesManhattan Chelsea New York City Tribeca Midtown
 websitehttp://corenyc.com/
 address104 Fifth Avenue
 address_2
 cityNew York
 stateNY
 full_stateNew York
 countryUSA
 marketNew York
 market_2
 postal_code10011
 phone(212) 726-0778
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameShaun Osher
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-shaun-osher-founder-and-ceo-of-core/
 contact_big_profile_link_text
 contact_titleFounder and CEO
 contact_dre_num
 contact_quoteI invite you to contact me personally about New York City 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_filename16.jpg
 logo_filename16.jpg
 contact_image_filename16.jpg
 all_properties_link_image_filename16.jpg
 all_properties_linkhttp://corenyc.com/listings
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/cxxGtpBt-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNew York City Real Estate | CORE | Leverage Global Partners
 meta_descriptionCORE is Leverage Global Partners' exclusive representative in New York City, NY, USA.
 meta_keywordsnew york city real estate, manhattan real estate, shaun osher, CORE, 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-04-01 15:35:47
 modified2019-10-29 20:06:57
 dre_num012345
 uri/brokerage-detail/16/core
 website_shortcorenyc.com
 name_with_locationCORE
 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)
 id23063
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv6b4i17.jpg
 typeimage/jpeg
 size1392149
 uri/assets/23063.jpg
 order0
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 1(array)
 id23071
 modelProperty
 model_id3754
 tagImage
 namePI-1tia0th4t2.jpg
 typeimage/jpeg
 size745950
 uri/assets/23071.jpg
 order1
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 2(array)
 id23061
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv6ad5r0.jpg
 typeimage/jpeg
 size953561
 uri/assets/23061.jpg
 order2
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 3(array)
 id23062
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv5v65vv.jpg
 typeimage/jpeg
 size1120705
 uri/assets/23062.jpg
 order3
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 4(array)
 id23064
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv5ud7qf.jpg
 typeimage/jpeg
 size819805
 uri/assets/23064.jpg
 order4
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 5(array)
 id23065
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv5u6hao.jpg
 typeimage/jpeg
 size1354457
 uri/assets/23065.jpg
 order5
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 6(array)
 id23066
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv6c8c2k.jpg
 typeimage/jpeg
 size667117
 uri/assets/23066.jpg
 order6
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 7(array)
 id23067
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv62hm1n.jpg
 typeimage/jpeg
 size1142542
 uri/assets/23067.jpg
 order7
 created2019-10-29 20:06:01
 modified2019-10-29 20:06:20
 8(array)
 id23068
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv60kn0g.jpg
 typeimage/jpeg
 size900053
 uri/assets/23068.jpg
 order8
 created2019-10-29 20:06:01
 modified2019-10-29 20:06:20
 9(array)
 id23069
 modelProperty
 model_id3754
 tagImage
 namePI-1tia0rna64.jpg
 typeimage/jpeg
 size667255
 uri/assets/23069.jpg
 order9
 created2019-10-29 20:06:01
 modified2019-10-29 20:06:20
 10(array)
 id23070
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv64a3ih.jpg
 typeimage/jpeg
 size1295530
 uri/assets/23070.jpg
 order10
 created2019-10-29 20:06:01
 modified2019-10-29 20:06:20
 11(array)
 id23072
 modelProperty
 model_id3754
 tagImage
 namePI-1tia0uv5i1.jpg
 typeimage/jpeg
 size816357
 uri/assets/23072.jpg
 order11
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 12(array)
 id23073
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv64q2c3.jpg
 typeimage/jpeg
 size1246171
 uri/assets/23073.jpg
 order12
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 13(array)
 id23074
 modelProperty
 model_id3754
 tagImage
 namePI-1tlejtukfi.jpg
 typeimage/jpeg
 size1296375
 uri/assets/23074.jpg
 order13
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 14(array)
 id23075
 modelProperty
 model_id3754
 tagImage
 namePI-1tlek8ckib.jpg
 typeimage/jpeg
 size821336
 uri/assets/23075.jpg
 order14
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 15(array)
 id23076
 modelProperty
 model_id3754
 tagImage
 namePI-1tlek3e9dr.jpg
 typeimage/jpeg
 size1122053
 uri/assets/23076.jpg
 order15
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 16(array)
 id23077
 modelProperty
 model_id3754
 tagImage
 namePI-1tlek0qvrl.jpg
 typeimage/jpeg
 size1277836
 uri/assets/23077.jpg
 order16
 created2019-10-29 20:06:03
 modified2019-10-29 20:06:20
 17(array)
 id23078
 modelProperty
 model_id3754
 tagImage
 namePI-1tlek8f4uk.jpg
 typeimage/jpeg
 size955578
 uri/assets/23078.jpg
 order17
 created2019-10-29 20:06:03
 modified2019-10-29 20:06:20
 18(array)
 id23079
 modelProperty
 model_id3754
 tagImage
 namePI-1tlek8p84e.jpg
 typeimage/jpeg
 size900653
 uri/assets/23079.jpg
 order18
 created2019-10-29 20:06:03
 modified2019-10-29 20:06:20
 19(array)
 id23080
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv5smv25.jpg
 typeimage/jpeg
 size1276220
 uri/assets/23080.jpg
 order19
 created2019-10-29 20:06:10
 modified2019-10-29 20:06:20
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 3(array)
 Property(array)
 id3715
 brokerage_id157
 created_by_user_id0
 order1
 multi_unit(false)
 agent_1_id283
 agent_2_id284
 agent_3_id0
 nameHandsome English Tudor
 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)
 descriptionHandsome 5 Bedroom, 3 full and 2 half bath, English Tudor in Old Short Hills. An easy walk to downtown Millburn and close to the Midtown Direct train. Located in a picturesque neighborhood in the Hartshorn School District with exquisite landscaping and a private back yard. Impressive curb appeal with a beautiful multi-colored slate roof, all copper gutters and leaders, decorative stained and leaded glass windows and unique architectural details throughout. A 2-story stained glass bay window greets you in the entry foyer and grand staircase. A fireplace, bay window seat and leaded glass bar add special appeal to the grand living room that opens to a sun room or office which leads to a stone patio, surrounded by flowering gardens. The dining room seats 12 comfortably with 2 corner leaded glass cabinets offering ample storage for dishes and stemware. Just off the modern kitchen are a sunny breakfast room, the laundry closet and a cozy nanny's bedroom and bath en-suite. Right outside there is a small open porch, with wood storage below, that leads to an upper patio, driveway that is perfect for trikes and basketball, and a grassy yard for relaxing and entertaining. Upstairs are 4 bedrooms, 2 bathrooms, a lovely landing area to cozy up with a book, and one bedroom has an extra room that can be used as a dressing room. The over-sized master bedroom has 2 walk-in closets and wonderful views from many windows. The storage attic runs the entire width of the house and there is also a ground level basement. The recreation room features a stone fireplace, a half bath, lots of storage, a work shop, access to the 2 car garage and plenty of natural light from big windows and a door to the yard. 
 address38 Sherwood Road
 address_2
 cityShort Hills
 stateNJ
 postal_code07078
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1500000
 price_20
 price_usd1500000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms5
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1garage
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://www.38Sherwood.com
 meta_titleHandsome English Tudor | Short Hills Real Estate | Towne Realty Group
 meta_description38 Sherwood Road is a property offered for sale in Short Hills, NJ, USA, presented by Towne Realty Group
 meta_keywords
 bathrooms_partial2
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://www.seetheproperty.com/196342
 video_tourhttp://seetheproperty.com/196342/video
 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
 latitude37.090240
 longitude-95.712891
 invalid_required_fields
 invalid_optional_fieldssquare_feet, square_meters, acres, hectares
 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-08 09:12:57
 uri/property-detail/3715/38-sherwood-road-short-hills-nj-07078-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3715/38-sherwood-road-short-hills-nj-07078-usa
 address_concat38 Sherwood Road Short Hills NJ 07078 USA
 google_maps_query_string38+Sherwood+Road++Short+Hills+NJ+07078+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,500,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty3
 bathrooms_partial_pretty2
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-04-08
 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)
 id20606
 modelProperty
 model_id3715
 tagImage
 name36067.jpg
 typeimage/jpeg
 size8450952
 uri/assets/20606.jpg
 order0
 created2016-04-11 18:10:59
 modified2016-04-11 18:12:53
 1(array)
 id20608
 modelProperty
 model_id3715
 tagImage
 name36070.jpg
 typeimage/jpeg
 size11188714
 uri/assets/20608.jpg
 order1
 created2016-04-11 18:11:03
 modified2016-04-11 18:12:53
 2(array)
 id20607
 modelProperty
 model_id3715
 tagImage
 name36069.jpg
 typeimage/jpeg
 size13230811
 uri/assets/20607.jpg
 order2
 created2016-04-11 18:11:01
 modified2016-04-11 18:12:53
 3(array)
 id20612
 modelProperty
 model_id3715
 tagImage
 name36071.jpg
 typeimage/jpeg
 size8029109
 uri/assets/20612.jpg
 order3
 created2016-04-11 18:11:09
 modified2016-04-11 18:12:53
 4(array)
 id20613
 modelProperty
 model_id3715
 tagImage
 name36072.jpg
 typeimage/jpeg
 size7617858
 uri/assets/20613.jpg
 order4
 created2016-04-11 18:12:21
 modified2016-04-11 18:12:53
 5(array)
 id20609
 modelProperty
 model_id3715
 tagImage
 name36073.jpg
 typeimage/jpeg
 size8253500
 uri/assets/20609.jpg
 order5
 created2016-04-11 18:11:04
 modified2016-04-11 18:12:53
 6(array)
 id20605
 modelProperty
 model_id3715
 tagImage
 name36068.jpg
 typeimage/jpeg
 size9278928
 uri/assets/20605.jpg
 order6
 created2016-04-11 18:10:57
 modified2016-04-11 18:12:53
 7(array)
 id20610
 modelProperty
 model_id3715
 tagImage
 name36074.jpg
 typeimage/jpeg
 size8414125
 uri/assets/20610.jpg
 order7
 created2016-04-11 18:11:06
 modified2016-04-11 18:12:53
 8(array)
 id20611
 modelProperty
 model_id3715
 tagImage
 name36075.jpg
 typeimage/jpeg
 size7708807
 uri/assets/20611.jpg
 order8
 created2016-04-11 18:11:07
 modified2016-04-11 18:12:53
 User(array)
 0(array)
 id496
 typeAgent
 brokerage_id157
 email[email protected]
 passwordc80aef26fd457ef0cffd6a16e16dde7ddf08bb12
 recover_hash
 first_nameKaren
 last_nameBigos
 title
 dre_num
 phone201-417-1600
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:01
 created2017-08-07 15:23:01
 notified(false)
 full_nameKaren Bigos
 uri/agent-detail/496/karen-bigos
 profile_complete(true)
 UsersProperty(array)
 id319
 user_id496
 property_id3715
 sort_order0
 1(array)
 id497
 typeAgent
 brokerage_id157
 email[email protected]
 passwordb0e054b97f20dd600a8a6a7e55c2c1338afb9fcc
 recover_hash
 first_nameDaniel
 last_nameCannizzo
 title
 dre_num
 phone973-865-4144
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:01
 created2017-08-07 15:23:01
 notified(false)
 full_nameDaniel Cannizzo
 uri/agent-detail/497/daniel-cannizzo
 profile_complete(true)
 UsersProperty(array)
 id327
 user_id497
 property_id3715
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id4356
 property_id3715
 property_feature_id4
 Topic(empty)
- sidebar_brokerages(array)
 0(array)
 Brokerage(array)
 id239
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2347676
 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
 nameReal Grenadines
 broker_of_record_name
 short_nameReal Grenadines
 usernameRealGrenadines
 password4f93900a086575cc9cf6d0aa02b3907a1bc3f18b
 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
 descriptionReal Grenadines is the exclusive representative for Leverage Global Partners in St. Vincent & the Grenadines, including Bequia, Isle a Quatre, Baliceaux, Battowia, Mustique, Petit Mustique, Canouan, Mayreau, Union Island, and Palm Island. Otmar and Sonja Schaedle sailed into Bequia for the first time on Christmas Eve in 1978. They had sailed down from the island Guadeloupe, which is part of the French Antilles, where they arrived from their Atlantic crossing on a French three master called the Belle Espoir. They immediately fell in love with Bequia and decided to spend a few weeks. While exploring the island, they stumbled upon a lonely spot above the sea, a place with a glorious view overlooking The Grenadines. Formidable walls, ancient water cisterns and heavy foundations - all abandoned! The discovery haunted them. After returning to Bequia the following year they managed to purchase the estate and set off re-building the ruin, which they believed was a former sugar plantation. These rebuilt structures became known as the Old Fort, Boutique Hotel and Estate, which up to this day accommodates a variety of guests and visitors. Although the Schaedle family has been involved in real estate endeavours for decades, it's only in 2003 that we have become more involved where commercial real estate and development is concerned. It started with our own development, Old Fort Estate in Mt. Pleasant, where we developed a part of our estate. Through the increased demand of foreigners and friends wanting to invest in Bequia, we gradually became more involved in the real estate business, offering more and more properties around Bequia and St. Vincent and the Grenadines on a whole. Originally our real estate company was named Old Fort Estates, which was created by Quirin Schaedle, Sonja's and Otmar's son, however it was later renamed to Real Grenadines. Quirin, who grew up on Bequia, lived numerous years in Europe in countries such as Holland, Germany and the United Kingdom, where he also studied at the London Metropolitan University. Quirin is now the sole operator and owner of the company. Today we have an impressive portfolio of investment land and properties in this quiet, but soon-to-be-discovered, part of the Caribbean. Bear in mind however, that the properties shown on this site, can provide only a snapshot of the opportunities that can be explored by combining our knowledge of the region and our network of local contacts. We would highly recommend meeting in person, whereas we would then happily assist and discuss the possibilities, which we and St. Vincent and the Grenadines can offer to you. Feel free to contact us anytime and we will get back in touch with you as soon as possible.
 communitiesSt. Vincent The Grenadines Bequia Isle a Quatre Baliceaux Battowia Mustique Petit Mustique Canouan Mayreau Union Island Palm Island
 websitehttp://www.realgrenadines.com/
 addressBequia
 address_2
 citySt. Vincent & the Grenadines
 state
 full_state
 countryCaribbean
 market
 market_2
 postal_code
 phone+1 784 533 1122
 phone_2+1 784 485 8888
 phone_3
 wide_contact_image(false)
 contact_nameQuirin Schaedle
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone+1 784 533 1122 & +1 784 485 8888
 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_filename239.jpg
 logo_filename239.jpg
 contact_image_filename239.jpg
 all_properties_link_image_filename239.jpg
 all_properties_linkhttp://www.realgrenadines.com/index.php?action=searchresults
 video_embed_code<iframe width="560" height="315" src="https://www.youtube.com/embed/STf3vGb7CT0?controls=0&showinfo=0" frameborder="0" allowfullscreen></iframe>
 contact_video_embed_code
 meta_titleSt. Vincent & The Grenades Real Estate | Real Grenadines | Leverage Global Partners
 meta_descriptionReal Grenadines is the exclusive representative for Leverage Global Partners in St. Vincent & the Grenadines.
 meta_keywordsReal Grenadines, St. Vincent Real Estate, The Grenadines Real Estate, Bequia Real Estate, Isle a Quatre Real Estate, Baliceaux Real Estate, Battowia Real Estate, Mustique Real Estate, Petit Mustique Real Estate, Canouan Real Estate, Mayreau Real Estate, Union Island Real Estate, Palm Island Real Estate, Leverage Global Partners, Quirin Schaedle
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2016-01-21 16:35:58
 modified2016-04-18 10:31:47
 dre_num012345
 uri/brokerage-detail/239/real-grenadines
 website_shortwww.realgrenadines.com
 name_with_locationReal Grenadines
 Logo(array)
 id2929
 modelBrokerage
 model_id239
 tagLogo
 name239.jpg
 typeimage/jpg
 size158520
 uri/assets/2929.jpg
 order0
 created2016-03-30 11:45:46
 modified2016-04-18 10:31:47
 1(array)
 Brokerage(array)
 id246
 account_executive_id0
 archived(false)
 typebrokerage
 hide_from_frontend(true)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeSelect
 max_properties0
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID(null)
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameEric B Test
 broker_of_record_name
 short_nameEric B Test
 username
 password
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 description
 communities
 websitehttp://LeverageRE.com
 address111 Main
 address_2
 cityNew York
 stateMV
 full_state
 countryUSA
 market
 market_2
 postal_code10016
 phone3076992337
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameEric Test
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_title
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename
 logo_filename
 contact_image_filename
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_title
 meta_description
 meta_keywords
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(false)
 created2024-12-18 22:38:09
 modified2024-12-18 23:03:27
 dre_num
 uri/brokerage-detail/246/eric-b-test
 website_shortLeverageRE.com
 name_with_locationEric B Test
 Logo(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 2(array)
 Brokerage(array)
 id160
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2382596
 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
 nameDean & Hamilton REALTORS®
 broker_of_record_name
 short_nameDean & Hamilton REALTORS®
 usernameDeanHamiltonRealtors
 password84e65b1ec95290f7745ace850e69e6fe56088701
 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
 descriptionDean & Hamilton REALTORS® is the exclusive representative for Leverage Global Partners in Cohasset, Hingham, Scituate, Norwell, Hull, Marshfield, Duxbury, Massachusetts, USA. Dean & Hamilton is located just 20 miles south of Boston in the beautiful seaside town of Cohasset. We are a home town office of highly trained, experienced professional agents who know the Boston South Shore properties inside and out. We can show you all the properties for sale from Hingham to Duxbury and provide information about the communities, schools, transportation and cultural activities. We invite you to view our properties for sale and explore the other information we have provided. We look forward to hearing from you and hope you enjoy our site!
 communitiesCohasset Hingham Scituate Norwell Hull Marshfield Duxbury
 websitehttp://www.deanandhamilton.com
 address18 Elm Street
 address_2
 cityCohasset
 stateMA
 full_stateMassachusetts
 countryUSA
 market
 market_2
 postal_code02025
 phoneCell: (401) 965-2981
 phone_2Office: (781) 383-6010
 phone_3
 wide_contact_image(false)
 contact_nameTom Hamilton
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleFounder
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename160.jpg
 logo_filename160.jpg
 contact_image_filename160.jpg
 all_properties_link_image_filename160.jpg
 all_properties_linkhttp://www.deanandhamilton.com/property/viewprop.htm
 video_embed_code
 contact_video_embed_code
 meta_titleCohasset Real Estate | Dean & Hamilton REALTORS® | Leverage Global Partners
 meta_descriptionDean & Hamilton REALTORS® is the exclusive representative for Leverage Global Partners in Cohasset, Massachusetts, USA.
 meta_keywordsDean & Hamilton REALTORS®, Cohasset Real Estate, Tom Hamilton, Cohasset Real Estate, Hingham Real Estate, Scituate Real Estate, Norwell Real Estate, Hull Real Estate, Marshfield Real Estate, Duxbury 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-08 16:06:10
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/160/dean-hamilton-realtors
 website_shortwww.deanandhamilton.com
 name_with_locationDean & Hamilton REALTORS®
 Logo(array)
 id2716
 modelBrokerage
 model_id160
 tagLogo
 name160.jpg
 typeimage/jpg
 size74717
 uri/assets/2716.jpg
 order0
 created2016-03-30 11:43:09
 modified2016-03-30 11:43:09
 3(array)
 Brokerage(array)
 id221
 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
 WOEID2383552
 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
 nameThe ART of Real Estate
 broker_of_record_name
 short_nameThe ART of Real Estate
 usernameTheArtofRealEstate
 passwordebea74ae0c1d53256d82e91cf26fada8575d8420
 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
 descriptionThe ART of Real Estate is the exclusive representative for Leverage Global Partners in Columbia, Blythewood, Forest Acres, Pontiac, Lexington, Gaston, Cayce, Lake Murray, Irmo, Pine Ridge, Chapin, and Elgin, SC, USA. More Information coming soon!
 communitiesColumbia Blythewood Forest Acres Pontiac Lexington Gaston Cayce Lake Murray Irmo Pine Ridge Chapin Elgin
 websitehttp://theartteam.net/
 address2903 Millwood Avenue
 address_2
 cityColumbia
 stateSC
 full_stateSouth Carolina
 countryUSA
 market
 market_2
 postal_code29205
 phoneOffice: (803) 760-9106
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameMary Lane Sloan, Brad Allen
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePartners
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Columbia real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename221.JPG
 logo_filename221.jpg
 contact_image_filename221.jpg
 all_properties_link_image_filename221.JPG
 all_properties_linkhttp://theartteam.net/idx/listings/featured-listings/?idx-d-SortOrders%3C0%3E-Column=Price&idx-d-SortOrders%3C0%3E-Direction=DESC
 video_embed_code
 contact_video_embed_code
 meta_titleColumbia Real Estate | The ART of Real Estate | Leverage Global Partners
 meta_descriptionThe ART of Real Estate is the exclusive representative for Leverage Global Partners in Columbia, Blythewood, Forest Acres, Pontiac, Lexington, Gaston, Cayce, Lake Murray, Irmo, Pine Ridge, Chapin, and Elgin, SC, USA.
 meta_keywordsThe ART of Real Estate, Leverage Global Partners, Columbia Real Estate, Blythewood Real Estate, Forest Acres Real Estate, Pontiac Real Estate, Lexington Real Estate, Gaston Real Estate, Cayce Real Estate, Lake Murray Real Estate, Irmo Real Estate, Pine Ridge Real Estate, Chapin Real Estate, Elgin Real Estate, South Carolina Real Estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-08-31 11:31:02
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/221/the-art-of-real-estate
 website_shorttheartteam.net
 name_with_locationThe ART of Real Estate
 Logo(array)
 id2881
 modelBrokerage
 model_id221
 tagLogo
 name221.jpg
 typeimage/jpg
 size28606
 uri/assets/2881.jpg
 order0
 created2016-03-30 11:44:56
 modified2016-03-30 11:44:56
- sidebar_locations(array)
 0(array)
 Location(array)
 id167
 parent_id8
 brokerage_id180
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameThe Woodlands, TX, USA
 short_nameThe Woodlands, TX, USA
 group_index
 latitude30.165821
 longitude-95.461266
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 18:26:27
 modified2016-04-12 18:27:57
 timezoneAmerica/Chicago
 population0
 uri/locations/view/167/the-woodlands-tx-usa
 tile_nameThe Woodlands, TX, USA
 Brokerage(array)
 id180
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2505522
 timezoneUS/Central
 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
 nameBoulevard Realty
 broker_of_record_name
 short_nameBoulevard Realty
 usernameBoulevardRealtyWoodlands
 passwordf8d7d11713441aeab11120162508f3d4817d8acb
 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
 descriptionBoulevard Realty is the exclusive representative for Leverage Global Partners in The Woodlands, Shenandoah, Grogan's Mill, Sterling Ridge, Alden Bridge, Vision Park, College Park, Panther Creek, Cochran's Crossing, Indian Springs, and Creekside Park, Texas, USA. Boulevard Realty is also the exclusive representative for Leverage Global Partners in <a href="../../brokerage-detail/161/Boulevard-Realty" target="_blank">Houston</a>, TX, USA. Boulevard Realty is a top grossing boutique real estate firm in Houston with more than 65 independent agents, 15 staff persons, and more than $200 million in sales in 2014. The company’s broker/owner, Bill Baldwin, consistently rates as one of the Top 25 Residential Realtors in Houston. But we’re more than our sheer numbers. We are a close-knit family of urban enthusiasts who live, work, and play in Houston’s most desired neighborhoods and cultural centers. We consider buying and selling real estate to be just the start of a long conversation about how we can improve the world around us, at the neighborhood, civic, and regional levels...and far beyond. We’re so proud to serve Houston, one of the strongest economies in the nation and with unparalleled cultural and ethnic diversity. There is truly something for everyone in Houston: the right job, the right home, the right neighborhood. Our firm’s name is reflective of its reputation for neighborhood-centric niche marketing and representation of the city’s premier living areas that offer a connection to the past, involvement in urban transformation, and provide a strong sense of community.
 communitiesThe Woodlands Shenandoah Grogan's Mill Sterling Ridge Alden Bridge Vision Park College Park Panther Creek Cochran's Crossing Indian Springs Creekside Park
 websitehttp://www.yourblvd.com/
 address1545 Heights Boulevard
 address_2
 cityHouston
 stateTX
 full_stateTexas
 countryUSA
 marketThe Woodlands
 market_2
 postal_code77008
 phoneOffice: (713) 862-1600
 phone_2Cell: (281) 850-6862
 phone_3
 wide_contact_image(false)
 contact_nameBill Baldwin
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename180.jpg
 logo_filename180.png
 contact_image_filename180.jpg
 all_properties_link_image_filename180.jpg
 all_properties_linkhttp://www.yourblvd.com/our-listings/
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/YshovAEs-qzxAOUo0.js"></script>
 contact_video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/sPPnF1Ck-Mwvk3CWK.js"></script>
 meta_titleThe Woodlands Real Estate | Boulevard Realty | Leverage Global Partners
 meta_descriptionBoulevard Realty is the exclusive partner for Leverage Global Partners in The Woodlands, TX, USA.
 meta_keywordsBoulevard Realty, The Woodlands Real Estate, Texas Real Estate, Bill Baldwin, Leverage Global Partners, Shenandoah Real Estate, Grogan's Mill Real Estate, Sterling Ridge Real Estate, Alden Bridge Real Estate, Vision Park Real Estate, College Park Real Estate, Panther Creek Real Estate, Cochran's Crossing Real Estate, Indian Springs Real Estate, Creekside Park 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-12-12 15:02:35
 modified2016-04-08 16:34:20
 dre_num012345
 uri/brokerage-detail/180/boulevard-realty
 website_shortwww.yourblvd.com
 name_with_locationBoulevard Realty
 Image(array)
 id20730
 modelLocation
 model_id167
 tagImage
 nameScreen Shot 2016-04-12 at 6.27.07 PM.png
 typeimage/png
 size1138452
 uri/assets/20730.png
 order0
 created2016-04-12 18:27:47
 modified2016-04-12 18:27:57
 1(array)
 Location(array)
 id38
 parent_id8
 brokerage_id138
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameMiami - North, FL, USA
 short_nameMiami - North, FL, USA
 group_index
 latitude25.958143
 longitude-80.137276
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionMiami is far more than just beautiful weather and beaches, it's a lifestyle.
 long_descriptionTraditionally known for sunny weather and beautiful beaches has evolved into one of the world's most desirable locations with its renaissance of art, dining and shopping. Miami will continue to attract the worlds elite. Miami was ranked the 6th most important city in the world in 2015 to ultra high net worth individuals (30 million + net worth). It is the only other U.S. city behind New York City in the top 10.
 created2016-04-04 12:25:34
 modified2016-04-04 12:38:32
 timezoneAmerica/New_York
 population5760000
 uri/locations/view/38/miami-north-fl-usa
 tile_nameMiami - North, FL, USA
 Brokerage(array)
 id138
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2450022
 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
 nameTurnberry International Realty
 broker_of_record_name
 short_nameTurnberry International Realty
 usernameTurnberryInternationalRealty
 passworde1eb47a424b568eef641b057438522f0c3a18c60
 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
 descriptionTurnberry International Realty is the exclusive representative for Leverage Global Partners in Miami - North, Aventura, Bal Harbour, South Beach, Fisher Island, Sunny Isles, Hollywood, Indian Creek, Miami Beach, Star Island, Golden Beach, and Hallandale Beach, Florida, USA. Turnberry International Realty is a premier boutique Real Estate company specializing in the South Florida area. At Turnberry International Realty we strive for excellence in all aspects of our business. Staying informed of the evolving real estate market allows our sales associates to provide outstanding service to each and every client. With offices in two locations including Aventura and Bay Harbor Islands, our agents specialize in properties throughout the South Florida region. The Turnberry International Realty kiosk, located in the Aventura Mall, offers a unique marketing opportunity to all of our clients, exposing our listings to millions of potential buyers who visit the Aventura Mall each year. The Turnberry name is associated with luxury real estate throughout the world and we are dedicated to maintaining its ongoing reputation for excellence.
 communitiesMiami Aventura Bal Harbour South Beach Fisher Island Sunny Isles Hollywood Indian Creek Miami Beach Star Island Golden Beach Hallandale Beach
 websitehttp://www.turnberryrealty.com/
 address20445 Biscayne Blvd
 address_2Suite #8
 cityAventura
 stateFL
 full_stateFlorida
 countryUSA
 marketMiami - North
 market_2
 postal_code
 phone(305) 935-0300
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameSeth Kaufman
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBroker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_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_filename138.jpg
 logo_filename138.jpg
 contact_image_filename138.jpg
 all_properties_link_image_filename138.JPG
 all_properties_linkhttp://www.turnberryrealty.com/exclusive-listings.html
 video_embed_code
 contact_video_embed_code
 meta_titleMiami - North Real Estate | Turnberry International Realty | Leverage Global Partners
 meta_descriptionTurnberry International Realty is the exclusive representative for Leverage Global Partners in Miami - North, Florida, USA.
 meta_keywordsTurnberry International Realty, Miami Real Estate, Seth Kaufman, Miami Real Estate, Aventura Real Estate, Bal Harbour Real Estate, South Beach Real Estate, Fisher Island Real Estate, Sunny Isles Real Estate, Hollywood Real Estate, Indian Creek Real Estate, Miami Beach Real Estate, Star Island Real Estate, Golden Beach Real Estate,Hallandale Beach Real Estate, Florida, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-07-01 11:14:16
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/138/turnberry-international-realty
 website_shortwww.turnberryrealty.com
 name_with_locationTurnberry International Realty
 Image(array)
 id2963
 modelLocation
 model_id38
 tagImage
 nameturnberry.jpg
 typeimage/jpeg
 size219628
 uri/assets/2963.jpg
 order0
 created2016-04-04 12:16:25
 modified2016-04-04 12:38:32
 2(array)
 Location(array)
 id110
 parent_id9
 brokerage_id133
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameCleveland, OH, USA
 short_nameCleveland, OH, USA
 group_index
 latitude41.499321
 longitude-81.694359
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionExperience life on other Coastal State, the Northeast Ohio Great Lakes!
 long_descriptionNortheast Ohio offers a lifestyle for every person with an affordability that enriches all. We enjoy the four seasons, the Cuyahoga Metro Park’s Emerald Necklace, life along the shores of Lake Erie and its arteries of rivers and canals that meander through Cleveland and the Akron/Canton suburbs. Great entertainment abounds with the arts, sporting, gaming, Rock and Roll and Football Halls of Fame, as well as other museums and sites of interest. We are home to world renowned health care & hospitals. Our market features housing stock from the early 1900’s to present and revitalized downtown living.
 created2016-04-05 14:05:18
 modified2016-04-05 14:05:18
 timezoneAmerica/New_York
 population390000
 uri/locations/view/110/cleveland-oh-usa
 tile_nameCleveland, OH, USA
 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
 Image(array)
 id3044
 modelLocation
 model_id110
 tagImage
 namecleveland.jpg
 typeimage/jpeg
 size177465
 uri/assets/3044.jpg
 order0
 created2016-04-05 14:04:42
 modified2016-04-05 14:05:18
 3(array)
 Location(array)
 id132
 parent_id8
 brokerage_id29
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameCharlotte, NC, USA
 short_nameCharlotte, NC, USA
 group_index
 latitude35.227085
 longitude-80.843124
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionKnown as the Queen City, Charlotte, North Carolina, is one of the fastest growing cities in the United States.
 long_descriptionKnown as the “Queen City”, Charlotte is situated in the Piedmont region of the Carolinas which is two hours east of the Blue Ridge Mountains, three hours west of the North Carolina coast, and is centrally located between Maine and Florida. Charlotte has been consistently voted one of the Best Places to Live and remains one of the fastest growing cities in the U.S. because of its superb quality of life, low cost of living, mild year-round climate, nationally renowed healthcare, and its abundant educational, cultural and recreational opportunities. In addition, the Charlotte region has a tremendous pro-business environment and has become a financial, distribution and transportation center for the entire area and is headquarters to many national and international companies. Charlotte is also home to the NFL’s Carolina Panthers, the NBA’s Charlotte Hornets, and minor league hockey, baseball and soccer teams. Each spring, golf fans enjoy the PGA’s Wells Fargo Championship and we are also proud to have the U.S. National Whitewater Center, a world-class training and sports adventure center. Another popular sport is stock car racing and Charlotte is home to the NASCAR Hall of Fame and Museum as well as the Charlotte Motor Speedway, which is the largest sports facility in the southeast. With a population of over 800,000 in Charlotte and more than 2.4 million in the metro area, the Charlotte region offers residents all the amenities of a major urban city while maintaining its Southern charm and small town feel.
 created2016-04-07 14:23:08
 modified2016-04-07 14:23:08
 timezoneAmerica/New_York
 population800000
 uri/locations/view/132/charlotte-nc-usa
 tile_nameCharlotte, NC, USA
 Brokerage(array)
 id29
 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
 WOEID2378426
 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
 nameHM Properties
 broker_of_record_name
 short_nameHM Properties
 usernameHMProperties
 password3d70a6783edaaeded5ee1f3d9bbedd1789cdd676
 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
 descriptionHM Properties is the exclusive representative for Leverage Global Partners in Mecklenburg County, Cabarrus County, Gaston County, Iredell County, Lincoln County, and Union County in Charlotte, North Carolina and Lancaster County and York County in South Carolina, USA. HM Properties is a full-service residential real estate firm licensed in North and South Carolina, and serves the Charlotte region including upstate South Carolina. We also specialize in corporate relocation moves for individuals, businesses and relocation companies. Founded in 2006 as a boutique real estate agency, HM Properties has quickly become one of the leading real estate companies in the Charlotte metro region. Our office is centrally located in the SouthPark area within Piedmont Town Center with over 55 top brokers and seven full-time employees including in-house Relocation and Marketing departments. Valerie Mitchener, owner and Broker-in-Charge, has hand-picked top brokers in the region who possess exceptional customer service skills, experience and knowledge of our market, and a strong work ethic. "The success of HM Properties is due, in large part, because of our team concept which enables us to match each client with the agent(s) best qualified to assist them," states Mitchener. Our goal is to keep clients for life, so our commitment to you begins when we meet and never ends. HM Properties specializes in the communities within Mecklenburg County, Cabarrus County, Gaston County, Iredell County, Lincoln County, and Union County in North Carolina; and Lancaster County and York County in South Carolina, including the areas of Lake Norman, Mountain Island Lake, and Lake Wylie. Skyline Photo: Charlotte Photo
 communitiesCharlotte North Carolina NC Mecklenburg County North Carolina NC Cabarrus County North Carolina NC Gaston County North Carolina NC Iredell County North Carolina NC Lincoln County North Carolina NC Union County North Carolina NC Lancaster County South Carolina SC York County South Carolina SC
 websitehttp://www.hmproperties.com/index.html
 address6857 Fairview Road
 address_2
 cityCharlotte
 stateNC
 full_stateNorth Carolina
 countryUSA
 marketCharlotte
 market_2
 postal_code28210
 phone(704) 552-9292
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameValerie Mitchener
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-valerie-mitchener-president-of-hm-properties-charlotte-nc/
 contact_big_profile_link_text
 contact_titleBroker-in-Charge/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_filename29.jpg
 logo_filename29.jpg
 contact_image_filename29.jpg
 all_properties_link_image_filename29.jpg
 all_properties_linkhttp://www.hmproperties.com/charlotte-nc-homes-search-results.html
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/3LwgmnCn-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleCharlotte Real Estate | HM Properties | Leverage Global Partners
 meta_descriptionHM Properties is the exclusive representative for Leverage Global Partners in the Charlotte Region, North Carolina, USA.
 meta_keywordshm properties, charlotte real estate, valerie mitchener, 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-05-23 15:42:36
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/29/hm-properties
 website_shortwww.hmproperties.com/index.html
 name_with_locationHM Properties
 Image(array)
 id3664
 modelLocation
 model_id132
 tagImage
 nameCharlotte.jpg
 typeimage/jpeg
 size105553
 uri/assets/3664.jpg
 order0
 created2016-04-07 14:23:01
 modified2016-04-07 14:23:08
- location_properties(empty)
- main_article(empty)
- brokerage(array)
 Brokerage(array)
 id147
 account_executive_id236
 archived(false)
 typedevelopment
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(true)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2511861
 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
 nameAlex MacWilliam Inc.
 broker_of_record_name
 short_nameAlex MacWilliam Inc.
 usernameAlexMacWilliamInc
 password7e31636eaac82d1fe8959758b47b74f6a28aab9c
 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
 descriptionAlex MacWilliam Inc. is the exclusive representative for Leverage Global Partners in Vero Beach, FL, USA. Alex MacWilliam Real Estate has long been the company buyers and sellers have turned to for Vero Beach, FL real estate. The MacWilliam family has a deep-rooted history in Vero Beach, beginning in the 1920s when Alex MacWilliam Sr. moved to oversee the construction of what is now Riomar and later served as mayor for a 20-year tenure. Alex MacWilliam Real Estate opened for business in 1949 by Alex MacWilliam, Jr. as one of only four realty firms in all of Indian River County. This long history gives the company a unique perspective and expertise on the local real estate market. They are proud to have been recognized as one of the top real estate companies in Vero Beach and Indian River County, Florida. At Alex MacWilliam Real Estate, the mission has always been to provide only the finest service with a philosophy based on integrity and respect for their clients. Alex MacWilliam Real Estate has been able to maintain their small, family business feel while consistently expanding and keeping up with new technology and trends. Now under the leadership of Alex “Buzz” MacWilliam III and brother-in-law Joe Beasock, Alex MacWilliam Real Estate has grown to over 70 agents and has recently opened a branch office to better serve the Grand Harbor and Oak Harbor communities. Although, Alex MacWilliam Real Estate is known for specializing in the sale of single family homes and condominiums, the experienced real estate agents sell in all facets of the marketplace. Whether it is lifestyle communities, oceanfront, riverfront or golf course properties, affordable homes or foreclosures and short sales, the professionals at Alex MacWilliam Real Estate can do it all, while upholding Alex MacWilliam Real Estate’s reputation of integrity, service, professionalism and results.
 communitiesVero Beach
 websitehttp://alexmacwilliam.com/
 address2901 Ocean Drive
 address_2
 cityVero Beach
 stateFL
 full_stateFlorida
 countryUSA
 market
 market_2
 postal_code32963
 phone(772) 231-6509
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameBuzz MacWilliam
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-buzz-macwilliam/
 contact_big_profile_link_text
 contact_titleCo-Founder
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename147.jpg
 logo_filename147.jpg
 contact_image_filename147.jpg
 all_properties_link_image_filename147.jpg
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_titleVero Beach Real Estate | Alex MacWilliam Inc. | Leverage Global Partners
 meta_descriptionAlex MacWilliam Inc. is the exclusive representative for Leverage Global Partners in Vero Beach, FL, USA.
 meta_keywordsAlex MacWilliam Inc., Vero Beach real estate, Alex MacWilliam, Buzz MacWilliam, Florida 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-07-28 09:04:02
 modified2021-07-18 10:42:36
 dre_num012345
 uri/development-detail/147/alex-macwilliam-inc
 website_shortalexmacwilliam.com
 name_with_locationAlex MacWilliam Inc. - Vero Beach, FL, USA
 AccountExecutive(array)
 id236
 typeAccountExecutive
 brokerage_id0
 email[email protected]
 passworde5cc5a96287695cf8b7cace1463b1699895dcf92
 recover_hash
 first_nameLauren
 last_namePena
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2020-12-23 09:21:16
 created2016-04-14 15:43:52
 notified(false)
 full_nameLauren Pena
 uri/agent-detail/236/lauren-pena
 profile_complete(true)
 Logo(array)
 id2677
 modelBrokerage
 model_id147
 tagLogo
 name147.jpg
 typeimage/jpg
 size88176
 uri/assets/2677.jpg
 order0
 created2016-03-30 11:42:22
 modified2021-07-18 10:42:36
 MainImage(array)
 id2676
 modelBrokerage
 model_id147
 tagMainImage
 name147.jpg
 typeimage/jpg
 size3075211
 uri/assets/2676.jpg
 order0
 created2016-03-30 11:42:21
 modified2021-07-18 10:42:36
 ContactImage(array)
 id2678
 modelBrokerage
 model_id147
 tagContactImage
 name147.jpg
 typeimage/jpg
 size681217
 uri/assets/2678.jpg
 order0
 created2016-03-30 11:42:22
 modified2021-07-18 10:42:36
 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)
 id261
 modelBrokerage
 model_id147
 archived(false)
 medium_featured(false)
 large_featured(false)
 titleMeet BUZZ MACWILLIAM: Co-Founder, ALEX MACWILLIAM INC., Vero Beach, FL
 authorLeverageRE
 date2014-08-19
 lead_inGet to know Alex “Buzz” MacWilliam III, Co-Founder of Leverage Partner Alex MacWilliam Inc. in Vero Beach, Florida.
 body <h4>What is your vision for Alex MacWilliam Inc., and were there any struggles or obstacles you had to initially overcome?</h4> Alex MacWilliam, Inc. Real Estate has been serving the needs of Vero Beach and Indian River County, Florida since 1949. We are a diversified real estate brokerage with 65 sales associates. Last year alone we sold homes valued from $30,000 to $19.6 million. I expect Leverage Global Partners will assist my vision of enhancing our market share in the high end luxury market of homes over $1 million. One of my philosophies is we don’t have to be the biggest with the highest market share, but we do want to be #1 in customer service. Last year 2013, we finished number 2 in the market share for our MLS. For years Avis car rental was number 2 behind hertz and they had the slogan “We Try Harder”. That is us. <img class="aligncenter wp-image-6142 size-large pure-img" src="/assets/992.jpg" alt="Buzz MacWilliam" width="585" height="438" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Buzz-partner-p-300x225.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Buzz-partner-p-585x438.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Buzz-partner-p-80x60.jpg 80w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Buzz-partner-p.jpg 960w" sizes="(max-width: 585px) 100vw, 585px"> <h4>Who are your mentors in your business career?</h4> That is an easy one. My father Alex MacWilliam Jr.I graduated college in 1980 thinking that I would become a lawyer. Before I enrolled in law school, my father asked me if I would be interested in joining him in his real estate business. I took just 24 hours to say yes. I had the pleasure of working side by side with my father, 5 days a week for 33 years and we never had a disagreement. That is an experience most fathers and sons never have. The first thing my father taught me about business was the importance of your reputation. He said you must deal with honesty, integrity and fairness to all. You can’t place your personal interest above your client’s or sales team. My brother-in-law and I operate the business and I am proud to say that our sons have now joined us and we are teaching them those same values. <img class="aligncenter wp-image-6143 pure-img" src="/assets/993.jpg" alt="Buzz MacWilliam & Family" width="410" height="549" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/buzz-partner-p-4-224x300.jpg 224w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/buzz-partner-p-4-585x783.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/buzz-partner-p-4.jpg 717w" sizes="(max-width: 410px) 100vw, 410px"> <h4>How has technology changed and impacted your approach to business?</h4> The changes in technology have streamlined our business tremendously. Gone are my father’s days of multiple listing books, driving around town to pick up keys and writing sales contracts on the hood of your car. Today with personal computers, smartphones, contract software and electronic lockboxes, we can do everything in a fraction of the time. <h4>What do you love most about the area you live and work in? </h4> Love most about my area-I tell people that I was “born lucky” having been born and raised in Vero Beach, Fl. Both my parents were born in Vero Beach and my Grandfather, Alex Sr. served as city Mayor of Vero Beach for 24 years. We have deep family roots here. Vero Beach is on the Atlantic Ocean about 100 miles north of Miami and 90 minutes southeast of Orlando. I have travelled all over the continental United States, Hawaii, Central America, the Caribbean and Europe. Every time I return home and drive over the bridge that connects our mainland to the barrier island where I live and work, I say to myself “There’s no place like home”. <img class="aligncenter wp-image-6144 size-large pure-img" src="/assets/994.jpg" alt="Buzz MacWilliam Hunting" width="585" height="436" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Alex-MacWilliams-2-300x223.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Alex-MacWilliams-2-585x436.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Alex-MacWilliams-2.jpg 960w" sizes="(max-width: 585px) 100vw, 585px"> <h4>What are some of your outside interests? </h4> Living the quintessential Florida lifestyle, I enjoy golf, surfing, saltwater fishing and hunting. When I’m not outdoors I enjoy reading and cooking. My family are big college football fans and attend several games a year. I am a Florida Gator Alumni, my wife graduated from Ohio State, my son from Ole Miss and my daughter is a senior at the University of Alabama. We are huge SEC football fans. We don’t always care who wins as long as we are tailgating. <h4>How do you think your colleagues would describe you?</h4> I am known as a peacemaker. I am very approachable and my door is always open. Many of our local competing brokers call me to discuss issues and ask for advice, even though my company may not be involved in the matter. One of my colleagues said she gave up trying to recruit my agents, because they are always happy and never want to move. That is because of my father’s lesson: treat everyone with honesty, integrity and respect. I treat everyone equally. Leverage Global Partners is proud to have Buzz MacWilliam and the team at Alex MacWilliam, Inc. as our partners in the network. 
 vimeo_id
 created2016-02-25 14:11:40
 modified2016-04-05 15:04:18
 uri/articles/view/261/meet-buzz-macwilliam-co-founder-alex-macwilliam-inc-vero-beach-fl
 FeaturedImage(array)
 0(array)
 id23004
 modelBrokerage
 model_id147
 tagFeaturedImage
 nameP1020018.jpg
 typeimage/jpeg
 size1225515
 uri/assets/23004.jpg
 order0
 created2019-08-29 09:50:19
 modified2021-07-18 10:42:36
 1(array)
 id23005
 modelBrokerage
 model_id147
 tagFeaturedImage
 nameP1010976.jpg
 typeimage/jpeg
 size2106472
 uri/assets/23005.jpg
 order1
 created2019-08-29 09:50:33
 modified2021-07-18 10:42:36
 2(array)
 id23006
 modelBrokerage
 model_id147
 tagFeaturedImage
 nameIMG_2216.JPG
 typeimage/jpeg
 size1623860
 uri/assets/23006.JPG
 order2
 created2019-08-29 09:51:52
 modified2021-07-18 10:42:36
 Location(array)
 0(array)
 id129
 parent_id8
 brokerage_id147
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameVero Beach, FL, USA
 short_nameVero Beach, FL, USA
 group_index
 latitude27.638643
 longitude-80.397270
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionKnown as “The Hamptons of Florida”, Vero Beach is coveted.
 long_descriptionKnown as “The Hamptons of Florida”, the charming, seaside community of Vero Beach is one of the most coveted destinations on Florida’s east coast. Refined yet unpretentious, the town hosts boutique shops, fine dining, a sophisticated and diverse cultural arts scene, and an affluent social and corporate elite that prefers the peaceful atmosphere. The casual chic village is also known for its varied and unique ecological and recreational options featuring numerous parks and wildlife refuges, miles of beautiful, uncrowded beaches, and surfing competitions to polo matches. Whether seeking primary residency or a vacation escape, Vero is an undiscovered coastal gem.
 created2016-04-07 14:15:45
 modified2016-04-07 14:15:45
 timezoneAmerica/New_York
 population16000
 uri/locations/view/129/vero-beach-fl-usa
 tile_nameVero Beach, FL, USA
 User(array)
 0(array)
 id147
 typeBrokerageAdmin
 brokerage_id147
 email[email protected]
 password7e31636eaac82d1fe8959758b47b74f6a28aab9c
 recover_hash
 first_nameBuzz
 last_nameMacWilliam
 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:28:49
 created2016-04-08 16:34:15
 notified(true)
 full_nameBuzz MacWilliam
 uri/agent-detail/147/buzz-macwilliam
 profile_complete(true)
 1(array)
 id596
 typeAgent
 brokerage_id147
 email[email protected]
 password36f6589197300b96ac6ab81bd84176d0a97b5d08
 recover_hash
 first_nameCharlotte
 last_nameTerry
 title
 dre_num
 phone772-538-2388
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:10
 created2017-08-07 15:23:10
 notified(false)
 full_nameCharlotte Terry
 uri/agent-detail/596/charlotte-terry
 profile_complete(true)
 2(array)
 id597
 typeAgent
 brokerage_id147
 email[email protected]
 password0ebecda0a3e5afe29cfba5ac49de0954e54d7f96
 recover_hash
 first_nameJim
 last_nameKnapp
 title
 dre_num
 phone772-913-0395
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:10
 created2017-08-07 15:23:10
 notified(false)
 full_nameJim Knapp
 uri/agent-detail/597/jim-knapp
 profile_complete(true)
 3(array)
 id598
 typeAgent
 brokerage_id147
 email[email protected]
 password2b300c2c5faca5dde6eafce13dea18ebeb006ed7
 recover_hash
 first_nameStacey
 last_nameClawson
 title
 dre_num
 phone772-559-7984
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:10
 created2017-08-07 15:23:10
 notified(false)
 full_nameStacey Clawson
 uri/agent-detail/598/stacey-clawson
 profile_complete(true)
 4(array)
 id618
 typeAgent
 brokerage_id147
 email[email protected]
 passwordd95ccd47d5c2e502eaca9ebc688b601bf9282d0f
 recover_hash
 first_nameRoger
 last_nameSmith
 title
 dre_num
 phone772-473-0086
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:11
 created2017-08-07 15:23:11
 notified(false)
 full_nameRoger Smith
 uri/agent-detail/618/roger-smith
 profile_complete(true)
 5(array)
 id696
 typeAgent
 brokerage_id147
 email[email protected]
 passwordcdef986c0c4bbcd448d022d042357d9665f06e40
 recover_hash
 first_nameAlex "Buzz"
 last_nameMacWilliam, III
 title
 dre_num
 phone772-231-6509
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:16
 created2017-08-07 15:23:16
 notified(false)
 full_nameAlex "Buzz" MacWilliam, III
 uri/agent-detail/696/alex-buzz-macwilliam-iii
 profile_complete(true)
 6(array)
 id697
 typeAgent
 brokerage_id147
 email[email protected]
 password69019496f7c65c1939f74120e9b54e1aefa91ca2
 recover_hash
 first_nameLarry
 last_nameLarson
 title
 dre_num
 phone772-559-7286
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:16
 created2017-08-07 15:23:16
 notified(false)
 full_nameLarry Larson
 uri/agent-detail/697/larry-larson
 profile_complete(true)
 7(array)
 id698
 typeAgent
 brokerage_id147
 email[email protected]
 passwordce001d994df6f64aafb2dcf2f7819933b0aca125
 recover_hash
 first_nameStacey
 last_nameMiller
 title
 dre_num
 phone772-538-1900
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:16
 created2017-08-07 15:23:16
 notified(false)
 full_nameStacey Miller
 uri/agent-detail/698/stacey-miller
 profile_complete(true)
 8(array)
 id711
 typeAgent
 brokerage_id147
 email[email protected]
 passwordd9455b09eeedb8dafbf0519e372183b19338d5b4
 recover_hash
 first_nameBarbara
 last_nameParent
 title
 dre_num
 phone772-633-3027
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:17
 created2017-08-07 15:23:17
 notified(false)
 full_nameBarbara Parent
 uri/agent-detail/711/barbara-parent
 profile_complete(true)
 9(array)
 id939
 typeAgent
 brokerage_id147
 email[email protected]
 password3ccaf41888adaabda24df69bd3dc44e6786d4248
 recover_hash
 first_nameGene
 last_nameKane
 title
 dre_num
 phone772-539-2685
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:45
 created2017-08-07 15:23:45
 notified(false)
 full_nameGene Kane
 uri/agent-detail/939/gene-kane
 profile_complete(true)
 10(array)
 id1037
 typeAgent
 brokerage_id147
 email[email protected]
 passworddd87d89697f72aac118089f84a0c093144c9de71
 recover_hash
 first_nameMichele
 last_nameRitchie
 title
 dre_num
 phone772-532-7288
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:50
 created2017-08-07 15:23:50
 notified(false)
 full_nameMichele Ritchie
 uri/agent-detail/1037/michele-ritchie
 profile_complete(true)
 11(array)
 id1283
 typeBrokerageAdmin
 brokerage_id147
 email[email protected]
 password9a06018ef33484683220fdcf7a38eb15c5aed35b
 recover_hash
 first_nameAlexBroker
 last_nameTester
 title
 dre_num
 phone8888888888
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2019-03-07 09:53:04
 created2019-03-07 09:53:04
 notified(false)
 full_nameAlexBroker Tester
 uri/agent-detail/1283/alexbroker-tester
 profile_complete(true)
- location(array)
 Location(array)
 id129
 parent_id8
 brokerage_id147
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameVero Beach, FL, USA
 short_nameVero Beach, FL, USA
 group_index
 latitude27.638643
 longitude-80.397270
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionKnown as “The Hamptons of Florida”, Vero Beach is coveted.
 long_descriptionKnown as “The Hamptons of Florida”, the charming, seaside community of Vero Beach is one of the most coveted destinations on Florida’s east coast. Refined yet unpretentious, the town hosts boutique shops, fine dining, a sophisticated and diverse cultural arts scene, and an affluent social and corporate elite that prefers the peaceful atmosphere. The casual chic village is also known for its varied and unique ecological and recreational options featuring numerous parks and wildlife refuges, miles of beautiful, uncrowded beaches, and surfing competitions to polo matches. Whether seeking primary residency or a vacation escape, Vero is an undiscovered coastal gem.
 created2016-04-07 14:15:45
 modified2016-04-07 14:15:45
 timezoneAmerica/New_York
 population16000
 uri/locations/view/129/vero-beach-fl-usa
 tile_nameVero Beach, FL, USA
 Image(array)
 id3661
 modelLocation
 model_id129
 tagImage
 name39922990_verobeachfl.jpg
 typeimage/jpeg
 size4124766
 uri/assets/3661.jpg
 order0
 created2016-04-07 14:14:42
 modified2016-04-07 14:15:45
- 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/129/vero-beach-fl-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/locations/view/129/vero-beach-fl-usa
Remote Port	17169
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	104.23.197.115
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
Http Accept Encoding	gzip, br
Http Accept	/
Http Cf Ray	a09d85174a10cf52-CMH
Http X Forwarded For	216.73.216.172
Proxy-nokeepalive	1
Ssl Tls Sni	staging2.leveragere.com
Https	on
Passenger Download Native Support Binary	0
Passenger Compile Native Support Binary	0
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Unique Id	aiorHa5NyR0g7NUomEw-cQAAAZA
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	aiorHa5NyR0g7NUomEw-cQAAAZA
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781148445.5007
Request Time	1781148445

====

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

Vero Beach, FL, USA

Location Represented By

Related Articles

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

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