Locations / Greenville, SC, USA

Greenville, SC, USA

More information coming soon!

Location Represented By

License #: 012345

1:42am local time
62 thousand population

Partner Search

Find partners with a map-based search

Related Locations

Lake Arrowhead, CA, USA

Lake Arrowhead - the best kept secret on the West Coast

Telluride, CO, USA

Everyone loves Telluride - the lifestyle is the best!

Melbourne, FL, USA

San Francisco, CA, USA

Considered by millions as the Best City in America.

Related Partners

SaraBay Real Estate, Inc.

Cell: (941) 348-3448 | Email
License #: 012345

Real Estate Associates

Office: (508) 563-7173 | Email
License #: 012345

Property BVI Realtors

(284) 494 0101 | Email
License #: 012345

Boris Mannsfeld & Associates

(303) 495-5536 | Email
License #: 012345

Recent Property Listings

South Las Olas Isles Best Buy

340 San Marco Drive
Fort Lauderdale, FL 33301
$1,595,000

123

123
Orlando, FL 30434
$0

Modern and Contemporary Private Oasis

7938 Hawaii Kai Drive
Honolulu, Hawaii 96825
$2,150,000

Winding Creek

170 Winding Creek Drive
Pawleys Island, SC 29585
$297,400

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)
  090
  1greenville-sc-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: 20 ms
Total Queries: 19 queries

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

Message	Memory use
Component initialization	2.88 MB
Controller action start	3.80 MB
Controller render start	6.64 MB
View render complete	7.19 MB

Timers

Total Request Time: 212 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	30.02
Event: Controller.initialize	4.56
Event: Controller.startup	1.13
Controller action	47.29
Event: Controller.beforeRender	15.40
» Processing toolbar data	15.31
Rendering View	85.11
» Event: View.beforeRender	0.28
» Rendering APP/View/Locations/view.ctp	2.60
» » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.14
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.18
» » Rendering APP/View/Elements/sidebar/brokerage_list.ctp	0.16
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.24
» » » Rendering APP/View/Elements/static_property_price.ctp	0.37
» » » Rendering APP/View/Elements/static_property_price.ctp #2	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.13
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.19
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	81.47
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)
 id3716
 brokerage_id39
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id143
 agent_2_id0
 agent_3_id0
 nameSouth Las Olas Isles Best Buy
 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)
 description100 feet of waterfront is ideally situated on the east side of a south Las Olas Isle and only minutes to the Atlantic Ocean. There are 2 large bedrooms and 2 baths in the main house, and 1 bedroom and 1 bath in the “guest quarters”. The house has new designer tile floors, impact windows and a whole house generator. Lush, verdant landscaping creates private living plus a lagoon style pool finished with real cut coral feels like a tropical resort. This home is perfect for the boater looking for backyard dockage.
 address340 San Marco Drive
 address_2
 cityFort Lauderdale
 stateFL
 postal_code33301
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1595000
 price_20
 price_usd1595000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms3
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1waterfront
 icon_2dock
 icon_3pool
 icon_4views
 icon_5
 icon_6
 websitehttp://www.intercoastalrealty.com/broward-county-county/fort-lauderdale-homes-for-sale/340-san-marco-dr-f1382190
 meta_titleSouth Las Olas Isles Best Buy | Fort Lauderdale Real Estate | Intercoastal Realty
 meta_description340 San Marco Drive is a property offered for sale in Fort Lauderdale, FL, USA, presented by Intercoastal Realty
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude26.118616
 longitude-80.119232
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, bathrooms_partial, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-04-08 13:19:41
 uri/property-detail/3716/340-san-marco-drive-fort-lauderdale-fl-33301-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3716/340-san-marco-drive-fort-lauderdale-fl-33301-usa
 address_concat340 San Marco Drive Fort Lauderdale FL 33301 USA
 google_maps_query_string340+San+Marco+Drive++Fort+Lauderdale+FL+33301+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,595,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-08
 overridden_brokerage_nameIntercoastal Realty
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id39
 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
 WOEID2405797
 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
 nameIntercoastal Realty
 broker_of_record_name
 short_nameIntercoastal Realty
 usernameIntercoastalRealty
 password9c8b255daf1d29accdc3643af0c35f4bd571b4f5
 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
 descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Broward County, Florida, USA. Intercoastal Realty is as unique as the customers and homes that we represent. Founded by Beth Beauchamp more than 30 years ago, Intercoastal Realty originally sold only waterfront homes. Over the years, Beth grew a two person office into the dominant real estate company in waterfront neighborhoods of Southeast Fort Lauderdale. This growth came from her focus on market knowledge and personal service which she continues to use to help educate her clients and friends. Beth has also imparted this focus to the real estate professionals of Intercoastal Realty who have helped make her so successful. With changes in the market and demands from clients, Intercoastal Realty has now expanded to represent all types of residential properties, but we still remain the only true waterfront experts. Although our market has changed, our goals remain the same. Intercoastal Realty exclusively represents and promotes the best homes for the finest clients. With hundreds of years of combined local experience, Intercoastal Realty’s team of knowledgeable, professional Realtor associates provide both buyers and sellers the facts and opportunities for success in our one-of-a kind real estate market. Our team approach means we work together and with the entire real estate community to bring buyers and sellers together. Our unmatched knowledge and experience combined with our network of local, regional, national and international real estate affiliates gives us the ability to locate a buyer across the street or around the globe! Joining with Leverage Global Partners expands this national and international reach and provides our clients with even more market knowledge and strength. New Website now available! 2015 WaterWays Magazine - <a href="http://www.waterways.flmag.com/" target="_blank">http://www.waterways.flmag.com/</a>
 communitiesFort Lauderdale Ft Lauderdale Broward County
 websitehttp://www.intercoastalrealty.com
 address1500 East Las Olas Boulevard
 address_2
 cityFort Lauderdale
 stateFL
 full_stateFlorida
 countryUSA
 marketFort Lauderdale
 market_2
 postal_code33301
 phone(954) 467-1448
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJohn Beauchamp
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-john-beauchamp-president-intercoastal-realty/
 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_filename39.jpg
 logo_filename39.png
 contact_image_filename39.jpg
 all_properties_link_image_filename39.jpg
 all_properties_linkhttp://www.intercoastalrealty.com/exclusive
 video_embed_code
 contact_video_embed_code
 meta_titleFort Lauderdale Real Estate | Intercoastal Realty | Leverage Global Partners
 meta_descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Fort Lauderdale, FL, USA.
 meta_keywordsIntercoastal Realty, fort lauderdale real estate, John Beauchamp, leverage global partners
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-07-29 17:01:16
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/39/intercoastal-realty
 website_shortwww.intercoastalrealty.com
 name_with_locationIntercoastal Realty
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id20617
 modelProperty
 model_id3716
 tagImage
 name36079.jpg
 typeimage/jpeg
 size1098229
 uri/assets/20617.jpg
 order0
 created2016-04-11 18:14:52
 modified2016-04-11 18:15:52
 1(array)
 id20620
 modelProperty
 model_id3716
 tagImage
 name36085.jpg
 typeimage/jpeg
 size1036216
 uri/assets/20620.jpg
 order1
 created2016-04-11 18:14:53
 modified2016-04-11 18:15:52
 2(array)
 id20616
 modelProperty
 model_id3716
 tagImage
 name36082.jpg
 typeimage/jpeg
 size905322
 uri/assets/20616.jpg
 order2
 created2016-04-11 18:14:52
 modified2016-04-11 18:15:52
 3(array)
 id20615
 modelProperty
 model_id3716
 tagImage
 name36080.jpg
 typeimage/jpeg
 size1040482
 uri/assets/20615.jpg
 order3
 created2016-04-11 18:14:51
 modified2016-04-11 18:15:52
 4(array)
 id20619
 modelProperty
 model_id3716
 tagImage
 name36083.jpg
 typeimage/jpeg
 size840590
 uri/assets/20619.jpg
 order4
 created2016-04-11 18:14:52
 modified2016-04-11 18:15:52
 5(array)
 id20618
 modelProperty
 model_id3716
 tagImage
 name36081.jpg
 typeimage/jpeg
 size902269
 uri/assets/20618.jpg
 order5
 created2016-04-11 18:14:52
 modified2016-04-11 18:15:52
 6(array)
 id20621
 modelProperty
 model_id3716
 tagImage
 name36084.jpg
 typeimage/jpeg
 size758833
 uri/assets/20621.jpg
 order6
 created2016-04-11 18:14:55
 modified2016-04-11 18:15:52
 7(array)
 id20622
 modelProperty
 model_id3716
 tagImage
 name36078.jpg
 typeimage/jpeg
 size714243
 uri/assets/20622.jpg
 order7
 created2016-04-11 18:15:11
 modified2016-04-11 18:15:52
 User(array)
 0(array)
 id366
 typeAgent
 brokerage_id39
 email[email protected]
 password504c74d6c830cb31c34de49f69ae1390fe76088c
 recover_hash
 first_nameJohn
 last_nameBeauchamp
 title
 dre_num
 phone954-801-0336
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:49
 created2017-08-07 15:22:49
 notified(false)
 full_nameJohn Beauchamp
 uri/agent-detail/366/john-beauchamp
 profile_complete(true)
 UsersProperty(array)
 id163
 user_id366
 property_id3716
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id4360
 property_id3716
 property_feature_id14
 1(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id4359
 property_id3716
 property_feature_id12
 2(array)
 id3
 nameDock
 additional(false)
 created2016-04-07 14:01:13
 modified2016-04-07 14:01:13
 PropertiesPropertyFeature(array)
 id4358
 property_id3716
 property_feature_id3
 3(array)
 id17
 nameWaterfront
 additional(false)
 created2016-04-07 14:06:00
 modified2016-04-07 14:06:00
 PropertiesPropertyFeature(array)
 id4357
 property_id3716
 property_feature_id17
 Topic(empty)
 1(array)
 Property(array)
 id3758
 brokerage_id3
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 name123
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(false)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(false)
 description123
 address123
 address_2
 cityOrlando
 stateFL
 postal_code30434
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price0
 price_20
 price_usd0
 price_usd_20
 statusFor Sale
 status_last_changed2024-10-24 10:10:36
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms0
 bedrooms_20
 bathrooms0
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude28.538383
 longitude-81.378929
 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)
 modified2024-10-24 10:10:36
 created2024-10-24 10:09:32
 uri/property-detail/3758/123-orlando-fl-30434-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3758/123-orlando-fl-30434-usa
 address_concat123 Orlando FL 30434 USA
 google_maps_query_string123++Orlando+FL+30434+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 0
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty0
 bathrooms_pretty0
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms0
 date_listed2024-10-24
 overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id3
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties12
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties2
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id1
 WOEID2442047
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePartners Trust Real Estate Brokerage and Acquisitions
 broker_of_record_name
 short_namePartners Trust Real Estate
 usernamePartnersTrustLA
 password165bb7b526009554e197bcf82dabaa84ae727155
 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
 descriptionPartners Trust is the exclusive representative for Leverage Global Partners in Los Angeles, California, USA. At Partners Trust, our real estate associates are the most professional, successful and ethical in the business, representing each of our clients with care, confidentiality and the utmost attention to service. As a company, we offer our associates and clients a level of technology and communication unmatched in today’s real estate market. Los Angeles provides the ideal canvas to make your dream become a reality. We live, work, and entertain everywhere, from our beautiful beaches and the vibrant, newly revitalized downtown to the expansive mountain ranges overlooking the serene desert landscapes. With a culture that attracts celebrities, sports figures and entrepreneurs, the Southern California lifestyle is in high demand. Great representation in this real estate market is essential. Our associates proudly handle all types of homes, ranging from the architectural estate to the contemporary condominium to the historic, traditional home. Each property and client is represented with the highest quality of presentation and service, leading to unparalleled success. Partners Trust has additional office locations in <a href="../../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/5/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Pasadena</a>, <a href="../../../brokerage-detail/142/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Malibu</a>, and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a>
 communitiesLos Angeles Brentwood West Los Angeles
 websitehttp://thepartnerstrust.com
 address11726 San Vicente Blvd
 address_2Suite 350
 cityLos Angeles
 stateCA
 full_stateCalifornia
 countryUSA
 marketLos Angeles
 market_2
 postal_code90049
 phone(310) 500-1388
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameNick Segal
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/presidential-profile-partners-trust-real-estate-brokerage-aquisitions-nick-segal/
 contact_big_profile_link_text
 contact_titlePresident/Co-Founder
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename3.jpg
 logo_filename3.png
 contact_image_filename3.jpg
 all_properties_link_image_filename3.jpg
 all_properties_linkhttp://www.thepartnerstrust.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleLos Angeles Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
 meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Los Angeles, CA is a premier boutique real estate brokerage, serving home buyers and sellers in the Los Angeles real estate market.
 meta_keywordspartners trust, Partners Trust Real Estate, los angeles real estate, nick segal, leverage global partners
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-03-18 15:09:20
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/3/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortthepartnerstrust.com
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id23108
 modelProperty
 model_id3758
 tagImage
 name2-Westridge-MLS-Exterior-2-1390x580.jpg
 typeimage/jpeg
 size269041
 uri/assets/23108.jpg
 order0
 created2024-10-24 10:09:30
 modified2024-10-24 10:09:32
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 2(array)
 Property(array)
 id3732
 brokerage_id28
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameModern and Contemporary Private Oasis
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(false)
 descriptionThis contemporary home impresses at every turn. With Koko Crater views, it is quiet, private and feels like you are on a retreat! Designed for entertaining and relaxation, with seamless transition to bring the outdoors in and create a chic, integrated living experience. This modern Masterpiece by architect Jim Schmidt offers a luxurious floor plan that boasts a Zen rock garden, spacious kitchen with huge granite island, full size walk-in pantry, Subzero refrigerator and a spacious family room. Ample laundry room w/sink, front load washer/dryer, granite counter top and new cabinets for storage. Main level master en suite with free standing tub and a generous sized shower. Big walk-in closet with a custom shoe cabinet! Loft and guestroom suite on upper level. Newly finished yoga studio/guest/maid quarters with a kitchenette/half bath with a separate entrance. Every corner of this luxurious home has been carefully designed. A place for your soul to recharge. An oasis for peace and energy!
 address7938 Hawaii Kai Drive
 address_2
 cityHonolulu
 stateHawaii
 postal_code96825
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2150000
 price_20
 price_usd2150000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet3958
 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.eastoahu.com/listing/141232635-150082085/7938-hawaii-kai-drive-honolulu-hi-96825/
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude21.293854
 longitude21.293854
 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-15 16:17:51
 uri/property-detail/3732/7938-hawaii-kai-drive-honolulu-hawaii-96825-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3732/7938-hawaii-kai-drive-honolulu-hawaii-96825-usa
 address_concat7938 Hawaii Kai Drive Honolulu Hawaii 96825 USA
 google_maps_query_string7938+Hawaii+Kai+Drive++Honolulu+Hawaii+96825+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,150,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty4
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2016-04-15
 overridden_brokerage_nameEast Oahu Realty, RB-16090
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id28
 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
 WOEID12485533
 timezoneUS/Hawaii
 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
 nameEast Oahu Realty, RB-16090
 broker_of_record_name
 short_nameEast Oahu Realty
 usernameEastOahu
 password184254dea91b6c8586489ec50b8219bece099e54
 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
 descriptionEast Oahu Realty is the exclusive representative for Leverage Global Partners in Honolulu, Oahu, Hawaii, USA. In 1992, Jack Leslein, President & Founder of East Oahu Realty, Inc., ventured forward with his dream of creating a real estate company of Realtors that would make a difference. Our mission is to be a pacesetter in real estate services by sharing our knowledge and skillfully guiding our clients beyond their expectations. Specializing in helping clients achieve their real estate objectives and focusing on personalized service and attention, East Oahu Realty became the home of trained and experienced Realtors, state of the art technology and dedicated support staff. East Oahu Realty is able to provide the utmost in professional real estate service. As a locally owned, Kama’aina company, we respect and value our island heritage. We are committed to enhancing the lives of those who reside here by providing the utmost in service and community support. We know our market as well as the economic and social factors that shape it. Our knowledge, combined with our broad base of experience, assures you have the information you need to make an informed decision. We are committed to your success, and we are leaders in our industry and our community. We take an active role in shaping the future of both. We are committed to maintaining our reputation of integrity and honesty. We represent our clients enthusiastically and fairly and have done so since 1992. Choosing can make all the difference. What Our Clients Can Expect: <ul> <li>Premier Market Presence</li> <li>Select Team of Successful Real Estate Professionals</li> <li>Global Networking and Exposure</li> <li>Comprehensive Market Analysis & Plans</li> <li>Member of Luxury Real Estate</li> <li>State of the Art Technology</li> <li>Multi-Lingual Realtors</li> <li>Mortgage Services On-Site</li> </ul>
 communitiesHonolulu Hawaii HI USA Oahu Hawaii HI USA
 websitehttp://www.eastoahu.com/
 address6600 Kalanianaole Hwy # 114
 address_2
 cityHonolulu, Oahu
 stateHI
 full_stateHawaii
 countryUSA
 market
 market_2
 postal_code96825
 phone(808) 791-2216
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameCherie Tsukamoto
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal Broker, RB - 14911
 contact_dre_num
 contact_quoteI invite you to contact me personally regarding East Oahu Realty.
 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_filename28.jpg
 logo_filename28.jpg
 contact_image_filename28.jpg
 all_properties_link_image_filename28.jpg
 all_properties_linkhttp://www.eastoahu.com/search/FeaturedListings.aspx
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/4U1wTm0Z-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleHonolulu, Oahu Real Estate | East Oahu Realty | Leverage Global Partners
 meta_descriptionEast Oahu Realty is the exclusive representative for Leverage Global Partners in Oahu, Hawaii, USA.
 meta_keywordseast oahu realty, oahu real estate, honolulu real estate, oahu hawaii, jack leslein, 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-10 18:19:12
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/28/east-oahu-realty-rb-16090
 website_shortwww.eastoahu.com
 name_with_locationEast Oahu Realty, RB-16090
 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)
 id20884
 modelProperty
 model_id3732
 tagImage
 nameleverage 1.jpg
 typeimage/jpeg
 size52421
 uri/assets/20884.jpg
 order0
 created2016-04-15 16:47:48
 modified2016-04-15 16:47:53
 1(array)
 id20885
 modelProperty
 model_id3732
 tagImage
 nameleverage 2.jpg
 typeimage/jpeg
 size50981
 uri/assets/20885.jpg
 order1
 created2016-04-15 16:47:48
 modified2016-04-15 16:47:53
 2(array)
 id20886
 modelProperty
 model_id3732
 tagImage
 nameleverage 3.jpg
 typeimage/jpeg
 size59263
 uri/assets/20886.jpg
 order2
 created2016-04-15 16:47:48
 modified2016-04-15 16:47:53
 3(array)
 id20887
 modelProperty
 model_id3732
 tagImage
 nameleverage 5.jpg
 typeimage/jpeg
 size59957
 uri/assets/20887.jpg
 order3
 created2016-04-15 16:47:48
 modified2016-04-15 16:47:53
 4(array)
 id20888
 modelProperty
 model_id3732
 tagImage
 nameleverage 6.jpg
 typeimage/jpeg
 size51221
 uri/assets/20888.jpg
 order4
 created2016-04-15 16:47:48
 modified2016-04-15 16:47:53
 5(array)
 id20889
 modelProperty
 model_id3732
 tagImage
 nameleverage 4.jpg
 typeimage/jpeg
 size72224
 uri/assets/20889.jpg
 order5
 created2016-04-15 16:47:48
 modified2016-04-15 16:47:53
 6(array)
 id20891
 modelProperty
 model_id3732
 tagImage
 nameleverage 8.jpg
 typeimage/jpeg
 size72084
 uri/assets/20891.jpg
 order6
 created2016-04-15 16:47:49
 modified2016-04-15 16:47:53
 7(array)
 id20892
 modelProperty
 model_id3732
 tagImage
 nameleverage 9.jpg
 typeimage/jpeg
 size54571
 uri/assets/20892.jpg
 order7
 created2016-04-15 16:47:49
 modified2016-04-15 16:47:53
 8(array)
 id20893
 modelProperty
 model_id3732
 tagImage
 nameleverage 7.jpg
 typeimage/jpeg
 size63051
 uri/assets/20893.jpg
 order8
 created2016-04-15 16:47:50
 modified2016-04-15 16:47:53
 User(array)
 0(array)
 id1276
 typeAgent
 brokerage_id28
 email[email protected]
 passworda992f8ca84fdd6442933402b26af8813256403e7
 recover_hash
 first_nameSakina
 last_nameClaytor
 title
 dre_num
 phone808-594-9044
 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_nameSakina Claytor
 uri/agent-detail/1276/sakina-claytor
 profile_complete(true)
 UsersProperty(array)
 id1102
 user_id1276
 property_id3732
 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)
 id4401
 property_id3732
 property_feature_id4
 Topic(array)
 0(array)
 id12
 nameModern Architecture
 created2016-02-25 11:25:00
 modified2016-02-25 11:33:26
 tile_nameModern Architecture
 PropertiesTopic(array)
 id39
 property_id3732
 topic_id12
 3(array)
 Property(array)
 id3745
 brokerage_id70
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameWinding Creek
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(false)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(false)
 descriptionClaim Your Own Slice Of Heaven In Pawleys Island; South Carolina'S Oldest Seaside Community! Build Your Dream Home On This Gorgeous One-acre Homesite In A Great Community With No Hoa Fees! This Lot Is Home To Many Hundred-year-old Live Oaks, Draped In Beautiful Spanish Moss. Surrounded By Natural Habitat With A Never-to-be-developed Nature Preserve, This Lot Is Nestled Right Between The Intracoastal Waterway And Waverly Creek. With It'S Unique Footprint, This Homesite Lends Itself To Face Either Of The Two Border Streets, Winding Creek Drive Or Angel Oak Drive. This Sought-after Neighborhood Leads Directly Onto Bike Paths To Shopping And Dining In Downtown Pawleys And Murrells Inlet. located Just Minutes Away From Multiple Public Beach Accesses And Everything You Need, You Will Feel Like You'Re A Million Miles Away From Any Hustle And Bustle. one More Added Feature To His Lot That Completes The Package Is It'S Access To A Neighborhood Boat Landing Less Than A Block Away. Within Minutes You Can Be In The Waverly Creek Winding And Unwinding Your Way To The Intracoastal Waterway. Take A Left And You Are 30 Minutes To A Sunset Cruise To Georgetown For A Lovely Lunch Or Dinner. Take A Right And You Are Minutes Away From Wachessaw Marina For A Delicious Brunch On Sunday Any Lunch And Dinner Any Day Of The Week. This Is Your Opportunity To Embrace The Traditional Pawleys Lifestyle; Shoeless, Carefree And Laid-back. Beautiful Lot, Great Neighborhood, Central Location And Priced Right To Sell.
 address170 Winding Creek Drive
 address_2
 cityPawleys Island
 stateSC
 postal_code29585
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price297400
 price_20
 price_usd0
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms0
 bedrooms_20
 bathrooms0
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude33.465752
 longitude-79.144562
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(false)
 invalid(false)
 mlsidx_full_address170 Winding Creek Drive Pawleys Island SC
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2018-04-25 13:18:34
 created2018-04-25 13:18:10
 uri/property-detail/3745/170-winding-creek-drive-pawleys-island-sc-29585-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3745/170-winding-creek-drive-pawleys-island-sc-29585-usa
 address_concat170 Winding Creek Drive Pawleys Island SC 29585 USA
 google_maps_query_string170+Winding+Creek+Drive++Pawleys+Island+SC+29585+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 297,400
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty0
 bathrooms_pretty0
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms0
 date_listed2018-04-25
 overridden_brokerage_nameQuinta Properties
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id70
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties3
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id13
 WOEID23706483
 timezoneEurope/Lisbon
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id9
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameQuinta Properties
 broker_of_record_name
 short_nameQuinta Properties
 usernameQuintaProperties
 passwordbfa20d0f7d557565a3e9f0589db0a06e4c9546f3
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionQuinta Properties is the exclusive representative for Leverage Global Partners in the Algarve, Portugal. Quinta Properties deal with some of the most exclusive luxury villas and exciting property in and around Quinta do Lago. As the chosen associates of Savills, they offer in-depth knowledge and experience to meet your real estate needs. Anyone who knows Quinta Properties and has dealt with Alison, Kerstin, and their team will know they are passionate about property. Their wide experience in the local property market enables them to recommend legal, architectural, financial and construction professionals who understand the needs of prospective buyers in the locality. Quinta Properties are registered with the Portuguese authorities as licensed agents, meeting stringent standards. Their staff are fluent in English, German, French, and Portuguese. "We make it our business to support you, to explain all the options, procedures and pitfalls and to carefully guide you through the entire process from purchasing to sellingluxury Quinta do Lago villas and other fine properties in the Quinta do Lago and the whole Algarve area." --Alison Buechner Hojbjerg and Kerstin Buechner
 communitiesalgarve the algarve quinta do lago
 websitehttp://www.quintaproperty.com/
 addressAvenida da Gondra
 address_2Quinta do Lago
 cityAlmancil
 state
 full_state
 countryPortugal
 marketAlgarve
 market_2
 postal_code8135-162
 phone+351 289 396 073
 phone_2+351 289 398086 (Fax)
 phone_3
 wide_contact_image(false)
 contact_nameAlison Buechner Hojbjerg and Kerstin Buechner
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleDirectors
 contact_dre_num
 contact_quoteWe invite you to contact us about real estate in the Algarve
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename70.jpg
 logo_filename70.jpg
 contact_image_filename70.jpg
 all_properties_link_image_filename70.jpg
 all_properties_linkhttp://www.quintaproperty.com/algarve/
 video_embed_code
 contact_video_embed_code
 meta_titleAlgarve Real Estate | Quinta Properties | Leverage Global Partners
 meta_descriptionQuinta Properties is the exclusive representative for Leverage Global Partners in the Algarve, Portugal.
 meta_keywordsQuinta Properties, Algarve Real Estate, Leverage Global Partners, Alison Buechner Hojbjerg
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-11-15 11:23:29
 modified2020-11-20 12:05:11
 dre_num012345
 uri/brokerage-detail/70/quinta-properties
 website_shortwww.quintaproperty.com
 name_with_locationQuinta Properties
 mlsidx_id_array(array)
 09
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id22804
 modelProperty
 model_id3745
 tagImage
 name1713677-1.jpg
 typeimage/jpeg
 size180892
 uri/assets/22804.jpg
 order0
 created2018-04-25 13:18:10
 modified2018-04-25 13:18:31
 1(array)
 id22805
 modelProperty
 model_id3745
 tagImage
 name1713677-2.jpg
 typeimage/jpeg
 size140119
 uri/assets/22805.jpg
 order1
 created2018-04-25 13:18:10
 modified2018-04-25 13:18:31
 2(array)
 id22806
 modelProperty
 model_id3745
 tagImage
 name1713677-3.jpg
 typeimage/jpeg
 size184653
 uri/assets/22806.jpg
 order2
 created2018-04-25 13:18:10
 modified2018-04-25 13:18:31
 3(array)
 id22807
 modelProperty
 model_id3745
 tagImage
 name1713677-4.jpg
 typeimage/jpeg
 size123842
 uri/assets/22807.jpg
 order3
 created2018-04-25 13:18:10
 modified2018-04-25 13:18:31
 4(array)
 id22808
 modelProperty
 model_id3745
 tagImage
 name1713677-5.jpg
 typeimage/jpeg
 size123918
 uri/assets/22808.jpg
 order4
 created2018-04-25 13:18:10
 modified2018-04-25 13:18:31
 5(array)
 id22809
 modelProperty
 model_id3745
 tagImage
 name1713677-6.jpg
 typeimage/jpeg
 size120089
 uri/assets/22809.jpg
 order5
 created2018-04-25 13:18:10
 modified2018-04-25 13:18:31
 6(array)
 id22810
 modelProperty
 model_id3745
 tagImage
 name1713677-7.jpg
 typeimage/jpeg
 size147644
 uri/assets/22810.jpg
 order6
 created2018-04-25 13:18:10
 modified2018-04-25 13:18:31
 7(array)
 id22811
 modelProperty
 model_id3745
 tagImage
 name1713677-8.jpg
 typeimage/jpeg
 size161028
 uri/assets/22811.jpg
 order7
 created2018-04-25 13:18:10
 modified2018-04-25 13:18:31
 8(array)
 id22812
 modelProperty
 model_id3745
 tagImage
 name1713677-9.jpg
 typeimage/jpeg
 size121445
 uri/assets/22812.jpg
 order8
 created2018-04-25 13:18:10
 modified2018-04-25 13:18:31
 9(array)
 id22813
 modelProperty
 model_id3745
 tagImage
 name1713677-10.jpg
 typeimage/jpeg
 size221431
 uri/assets/22813.jpg
 order9
 created2018-04-25 13:18:11
 modified2018-04-25 13:18:31
 10(array)
 id22814
 modelProperty
 model_id3745
 tagImage
 name1713677-11.jpg
 typeimage/jpeg
 size122091
 uri/assets/22814.jpg
 order10
 created2018-04-25 13:18:11
 modified2018-04-25 13:18:31
 11(array)
 id22815
 modelProperty
 model_id3745
 tagImage
 name1713677-12.jpg
 typeimage/jpeg
 size117188
 uri/assets/22815.jpg
 order11
 created2018-04-25 13:18:11
 modified2018-04-25 13:18:31
 12(array)
 id22816
 modelProperty
 model_id3745
 tagImage
 name1713677-13.jpg
 typeimage/jpeg
 size138741
 uri/assets/22816.jpg
 order12
 created2018-04-25 13:18:11
 modified2018-04-25 13:18:31
 13(array)
 id22817
 modelProperty
 model_id3745
 tagImage
 name1713677-14.jpg
 typeimage/jpeg
 size136858
 uri/assets/22817.jpg
 order13
 created2018-04-25 13:18:11
 modified2018-04-25 13:18:31
 14(array)
 id22818
 modelProperty
 model_id3745
 tagImage
 name1713677-15.jpg
 typeimage/jpeg
 size140747
 uri/assets/22818.jpg
 order14
 created2018-04-25 13:18:11
 modified2018-04-25 13:18:31
 User(array)
 0(array)
 id1279
 typeAgent
 brokerage_id70
 email[email protected]
 password6e83e74e5aad7dc2404b41f4dad53b857b4a34ae
 recover_hash
 first_nameChristy
 last_nameWhitlock
 title
 dre_num
 phone8888888888
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2018-04-25 13:16:25
 created2018-04-25 13:16:25
 notified(false)
 full_nameChristy Whitlock
 uri/agent-detail/1279/christy-whitlock
 profile_complete(true)
 UsersProperty(array)
 id1105
 user_id1279
 property_id3745
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
- sidebar_brokerages(array)
 0(array)
 Brokerage(array)
 id226
 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(true)
 country_id0
 WOEID2489025
 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
 nameSaraBay Real Estate, Inc.
 broker_of_record_name
 short_nameSaraBay Real Estate, Inc.
 usernameSaraBayRE
 password9c132b442137deb2cc4f5844ca409d070fd64b83
 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
 descriptionSaraBay Real Estate Inc. is the exclusive representative for Leverage Global Partners in Sarasota, Bradenton, Lakewood Ranch, Longboat Key, Palmetto, and Myakka City, FL, USA. About SaraBay… SaraBay Real Estate is a locally owned and operated luxury boutique real estate company consisting of an exclusive group of experienced real estate professionals. Every SaraBay agent is a real estate professional you can trust, with a history of success and integrity that you can depend on. Each is an experienced negotiator with expert knowledge of the local market. SaraBay’s commitment to Buyers is that we will get you the best price on a home that is perfectly suited to your needs and lifestyle – not just today, but for years to come. The commitment to Sellers is that we will use our knowledge and expertise to price your home competitively, to market it aggressively, and help you reach your real estate goals in as little time as possible. Choosing a real estate agent who has the tools, skills and experience to make dreams come true can be as challenging as the buying or selling process itself. Let us make it simple… at SaraBay, our real estate professionals have the knowledge, the expertise and desire to work with you and help your move be as seamless as possible.
 communitiesSarasota Bradenton Lakewood Ranch Longboat Key Palmetto Myakka City
 websitehttp://www.sarabay.com/
 address7333 North Tamiami Trail
 address_2
 citySarasota
 stateFL
 full_stateFlorida
 countryUSA
 market
 market_2
 postal_code34243
 phoneCell: (941) 348-3448
 phone_2Office: (941) 355-7696
 phone_3
 wide_contact_image(false)
 contact_nameMichael Holderness, Jr., Mike Holderness, Sr.
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwners/ Agents
 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_filename226.jpg
 logo_filename226.png
 contact_image_filename226.jpg
 all_properties_link_image_filename226.jpg
 all_properties_linkhttp://www.sarabay.com/rets/
 video_embed_code
 contact_video_embed_code
 meta_titleSarasota Real Estate | SaraBay Real Estate, Inc. | Leverage Global Partners
 meta_descriptionSaraBay Real Estate Inc. is the exclusive representative for Leverage Global Partners in Sarasota, Bradenton, Lakewood Ranch, Longboat Key, Palmetto, and Myakka City, FL, USA.
 meta_keywordsSaraBay Real Estate Inc., Leverage Global Partners, Sarasota Real Estate, Bradenton Real Estate, Lakewood Ranch Real Estate, Longboat Key Real Estate, Palmetto Real Estate, Myakka City Real Estate, Florida Real Estate, USA 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)
 created2015-09-29 14:14:10
 modified2016-04-08 16:34:31
 dre_num012345
 uri/brokerage-detail/226/sarabay-real-estate-inc
 website_shortwww.sarabay.com
 name_with_locationSaraBay Real Estate, Inc.
 Logo(array)
 id2893
 modelBrokerage
 model_id226
 tagLogo
 name226.png
 typeimage/png
 size124589
 uri/assets/2893.png
 order0
 created2016-03-30 11:45:12
 modified2016-03-30 11:45:12
 1(array)
 Brokerage(array)
 id166
 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
 WOEID23511751
 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
 nameReal Estate Associates
 broker_of_record_name
 short_nameReal Estate Associates
 usernameRealEstateAssociates
 password348ba8892d60aa5fae48db2e4569b307d30c88c6
 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
 descriptionReal Estate Associates is the exclusive representative for Leverage Global Partners on the Upper Cape, Cape Cod; Bourne and the villages of Pocasset, Cataumet, Monument Beach, Bourne, Gray Gables, Buzzards Bay, Bournedale, Sagamore, Sagamore Beach, Sagamore Highlands. Mashpee and the villages of New Seabury, South Mashpee, Popponesset. Falmouth and the villages of Megansett, Silver Beach, North Falmouth, Hatchville, Falmouth, East Falmouth, West Falmouth, Waquoit, Sippewissett, Quissett, Woods Hole, Falmouth Heights, Maravista, Teaticket, Davisville, Massachusetts, USA. Real Estate Associates of Cape Cod is the Upper Cape's premier real estate agency for the high-end buyer. Proudly listing fine waterfront homes and estates in the towns of Falmouth, Bourne, and Mashpee, Real Estate Associates has a 40 year tradition of excellence representing buyers and sellers. Employing only the leading experts in the Cape Cod lifestyle, our agents match discerning homebuyers with the right home in the right neighborhood at the right price. Whether your buyer is looking for a deep water dock to pursue their boating passion, or quiet home overlooking a private beach and blazing sunsets, we have the home for your buyer and the knowledge to ensure a smooth sale. For those seeking to build their dream home, our agents can help them navigate the Cape's construction processes, even from a distance. With our combination of knowledgable agents, expert marketing techniques and investments in the latest real estate technology, Real Estate Associates provides the highest level of service imaginable.
 communitiesUpper Cape Cod Bourne Pocasset Cataumet Monument Beach Bourne Gray Gables Buzzards Bay Bournedale Sagamore Sagamore Beach Sagamore Highlands Mashpee New Seabury South Mashpee Popponesset Falmouth Megansett Silver Beach North Falmouth Hatchville Falmouth East Falmouth West Falmouth Waquoit Sippewissett Quissett Woods Hole Falmouth Heights Maravista Teaticket Davisville
 websitehttp://www.capecodhouses.com/
 address563 N. Falmouth Highway
 address_2
 cityNorth Falmouth
 stateMA
 full_stateMassachusetts
 countryUSA
 marketUpper Cape Cod
 market_2
 postal_code02556
 phoneOffice: (508) 563-7173
 phone_2Cell: (508) 264-1952
 phone_3
 wide_contact_image(false)
 contact_nameLynette Helms
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-real-estate-associates/
 contact_big_profile_link_textMeet Real Estate Associates
 contact_titleCEO
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename166.jpg
 logo_filename166.jpg
 contact_image_filename166.jpg
 all_properties_link_image_filename166.jpg
 all_properties_linkhttp://www.capecodhouses.com/app/snapshot/terabitzShare.php?key=VjMEYVEyWDVWYw==
 video_embed_code
 contact_video_embed_code
 meta_titleUpper Cape Cod Real Estate⎜Real Estate Associates⎜Leverage Global Partners
 meta_descriptionReal Estate Associates is the exclusive representative for Leverage Global Partners in Upper Cape Cod, MA, USA
 meta_keywordsReal Estate Associates, Upper Cape Cod Real Estate, Lynette Helms, Upper Cape Cod Real Estate, Bourne Real Estate, Pocasset Real Estate, Cataumet Real Estate, Monument Beach Real Estate, Bourne Real Estate, Gray Gables Real Estate, Buzzards Bay Real Estate, Bournedale Real Estate, Sagamore Real Estate, Sagamore Beach Real Estate, Sagamore Highlands Real Estate, Mashpee Real Estate, New Seabury Real Estate, South Mashpee Real Estate, Popponesset Real Estate, Falmouth Real Estate, Megansett Real Estate, Silver Beach Real Estate, North Falmouth Real Estate, Hatchville Real Estate, Falmouth Real Estate, East Falmouth Real Estate, West Falmouth Real Estate, Waquoit Real Estate, Sippewissett Real Estate, Quissett Real Estate, Woods Hole Real Estate, Falmouth Heights Real Estate, Maravista Real Estate, Teaticket Real Estate, Davisville Real Estate, Massachusetts, Leverage Global Partners
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-10-03 09:21:53
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/166/real-estate-associates
 website_shortwww.capecodhouses.com
 name_with_locationReal Estate Associates
 Logo(array)
 id2728
 modelBrokerage
 model_id166
 tagLogo
 name166.jpg
 typeimage/jpg
 size74355
 uri/assets/2728.jpg
 order0
 created2016-03-30 11:43:14
 modified2016-03-30 11:43:14
 2(array)
 Brokerage(array)
 id212
 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
 WOEID12485816
 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
 nameProperty BVI Realtors
 broker_of_record_name
 short_nameProperty BVI Realtors
 usernamePropertyBVIRealtors
 password70ff72a576e6d71935d223c42ca432d02da706ab
 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
 descriptionProperty BVI Realtors is the exclusive representative for Leverage Global Partners in the British Virgin Islands, including Islands of Tortola, Virgin Gorda, Anegada, and Jost Van Dyke. <a href="http://www.bvipropertyyacht.com/vi-bvi/readers-choice-2/" target="_blank">Best Real Estate in the BVI</a>
 communitiesBritish Virgin Islands Islands of Tortola Virgin Gorda Anegada Jost Van Dyke
 websitehttp://www.propertybvi.com/PropBVI/pages/home.xhtml
 address19 Waterfront Drive
 address_2
 cityRoad Town, Tortola
 state
 full_state
 countryCaribbean
 marketBritish Virgin Islands
 market_2
 postal_code
 phone(284) 494 0101
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameGreg George
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleFounder/CEO
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename212.jpg
 logo_filename212.png
 contact_image_filename212.png
 all_properties_link_image_filename212.jpg
 all_properties_linkhttp://www.propertybvi.com/PropBVI/pages/home.xhtml?faces-redirect=true
 video_embed_code
 contact_video_embed_code
 meta_titleBritish Virgin Islands Real Estate⎜Property BVI Realtors⎜Leverage Global Partners
 meta_descriptionProperty BVI Realtors is the exclusive representative for Leverage Global Partners in the British Virgin Islands.
 meta_keywordsProperty BVI Realtors, British Virgin Islands Real Estate, Tortola Real Estate, Road Town Real Estate, Islands of Tortola Real Estate, Virgin Gorda Real Estate, Anegada Real Estate, Jost Van Dyke Real Estate, Greg George, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-07-06 20:53:31
 modified2016-04-08 16:34:20
 dre_num012345
 uri/brokerage-detail/212/property-bvi-realtors
 website_shortwww.propertybvi.com/PropBVI/pages/home.xhtml
 name_with_locationProperty BVI Realtors
 Logo(array)
 id2764
 modelBrokerage
 model_id212
 tagLogo
 name212.png
 typeimage/png
 size58564
 uri/assets/2764.png
 order0
 created2016-03-30 11:43:39
 modified2016-03-30 11:43:39
 3(array)
 Brokerage(array)
 id184
 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_properties1
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID23424760
 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
 nameBoris Mannsfeld & Associates
 broker_of_record_name
 short_nameBoris Mannsfeld & Associates
 usernameBorisMannsfeld
 passwordfdddb06bee50f8c891dc0fc9de6dc15c95fa063b
 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
 descriptionBoris Mannsfeld & Associates is the exclusive representative for Leverage Global Partners in Placencia, Belize. Welcome to Boris Mannsfeld & Associates Belize Real Estate and beautiful Belize. Our loyalty to our client’s best interest has established us as the top real set firm in the region. Our expert team is ready and excited to guide you step–by–step in finding the perfect property or securing a successful sale or investment. Belize truly is a jewel and it’s no secret that Placencia is THE place to be, rich in both tropical beauty, lifestyle and endless real estate and investment opportunities with great rewards. Founder Boris Mannsfeld successfully developed and sold property in Denver Colorado for many years before transitioning his efforts to Belize. Boris fell in love with the country of Belize upon his first trip in 1992. Besides running the top brokerage firm in Placencia, Boris is heavily invested in the real estate and hospitality markets here owning various businesses, including development projects and resorts. Boris is always excited to share his experience, contacts, knowledge and tourism tips with anyone interested in Belize. His partner Frik De Meyere, originally from Brussels, Belgium fell in love with Barefoot Paradise in 2004. He decided to move with his family to Belize and has since been buying and investing in properties in Placencia, set up a concrete company and spearheaded the start of the Placencia private school. Frik possesses extensive experience in a variety of international real estate projects, and has spearheaded many business development projects and start up companies. If you or your customers are seeking exceptional service, proven experience, professionalism, and the know-how and determination to get things done then look no further. We ARE your experts and your life-time partners here in Placencia, Belize. Even though we specialize in the Placencia peninsula, we have a reliable network of real estate firms and developers throughout Belize with whom we can collaborate to provide you with real estate options across this beautiful country. We look forward to working with you and to welcome you to our amazing lifestyle.
 communitiesPlancencia Belize
 websitehttps://realestateplacencia.com/
 addressMain Street
 address_2
 cityPlacencia, Stann Creek
 state
 full_state
 countryBelize
 marketPlacencia
 market_2
 postal_code
 phone(303) 495-5536
 phone_2
 phone_3
 wide_contact_image(true)
 contact_nameBoris Mannsfeld & Frik De Meyere
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleManager & Sales: Sales & Business Development
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename184.jpg
 logo_filename184.jpg
 contact_image_filename184.jpg
 all_properties_link_image_filename184.jpg
 all_properties_linkhttps://realestateplacencia.com/listings/all-listings/
 video_embed_code
 contact_video_embed_code
 meta_titlePlacencia Real Estate⎜Boris Mannsfeld & Associates⎜Leverage Global Partners
 meta_descriptionBoris Mannsfeld & Associates is the exclusive member for Leverage Global Partners in Placencia, Belize.
 meta_keywordsBoris Mannsfeld & Associates, Leverage Global Partners, Boris Mannsfeld, Frik De Meyere, Placencia Real Estate, Belize 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-01-26 09:16:56
 modified2016-04-15 17:17:50
 dre_num012345
 uri/brokerage-detail/184/boris-mannsfeld-associates
 website_shortrealestateplacencia.com
 name_with_locationBoris Mannsfeld & Associates
 Logo(array)
 id2755
 modelBrokerage
 model_id184
 tagLogo
 name184.jpg
 typeimage/jpg
 size798470
 uri/assets/2755.jpg
 order0
 created2016-03-30 11:43:37
 modified2016-04-15 17:17:50
- sidebar_locations(array)
 0(array)
 Location(array)
 id115
 parent_id9
 brokerage_id76
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameLake Arrowhead, CA, USA
 short_nameLake Arrowhead, CA, USA
 group_index
 latitude34.269379
 longitude-117.208817
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionLake Arrowhead - the best kept secret on the West Coast
 long_descriptionDo you want to know a secret? Lake Arrowhead is one of the best-kept secrets referred to as the “Jewel of Southern California.” Lake Arrowhead has a long history for being the four-season, mountain retreat for the Hollywood elite. This area has been described as “Little Switzerland” for its stunningly beautiful, cozy and quaint reconnection to nature. Imagine leaving the congestion of the city and escaping to solitude and fresh air within a 90-minute drive from Los Angeles, San Diego, or Palm Springs. You’re closer than you think to hiking, golfing, bicycling, water and snow skiing, fishing and much more.
 created2016-04-05 17:25:36
 modified2016-04-14 11:04:12
 timezoneAmerica/Los_Angeles
 population25000
 uri/locations/view/115/lake-arrowhead-ca-usa
 tile_nameLake Arrowhead, CA, USA
 Brokerage(array)
 id76
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2434729
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePrime Properties
 broker_of_record_name
 short_namePrime Properties
 usernamePrimeProperties
 password4b7dee5c791770c42ce3df75d5b8fb072b481b38
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPrime Properties is the exclusive representative for Leverage Global Partners in Lake Arrowhead, California, USA. “Different isn’t always better, but better is always different,” has been founder, and president, Jeff Perlis’ motto for providing outstanding service to his clients for almost 25 years. Jeff created Prime Properties as a boutique real estate company that provides Nordstrom-quality customer service to its clients. The Prime Properties Team purposes to continually show community support. Such support can be exemplified by their sweeping transformation of its current office location. The office’s strategic location, houses the Arrowhead Welcome Center, Jeff’s vision for providing a warm and inviting first-stop for Lake Arrowhead visitors and clients. The Prime Properties Team includes, Arrowhead Rental Agency, the full-time rental department. Lake Arrowhead is a four season resort community centered around the uniqueness of a private lake. Located in an altitude of 5,100 feet, Lake Arrowhead has been described as the “Jewel of Southern California,” known as “Little Switzerland.” Close to local ski resorts and National Forest trails, Lake Arrowhead is less than a two-hour drive from Los Angeles, San Diego, or Palm Springs.
 communitieslake arrowhead
 websitehttp://www.therealestateplace.com/
 address26816 Highway 189
 address_2
 cityLake Arrowhead
 stateCA
 full_stateCalifornia
 countryUSA
 marketLake Arrowhead
 market_2
 postal_code92352
 phone(909) 337-7653
 phone_2(909) 224-5631
 phone_3
 wide_contact_image(false)
 contact_nameJeff Perlis
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner/Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_websitehttp://www.JeffPerlis.com
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename76.jpg
 logo_filename76.jpg
 contact_image_filename76.jpg
 all_properties_link_image_filename76.jpg
 all_properties_linkhttp://www.therealestateplace.com/properties
 video_embed_code
 contact_video_embed_code
 meta_titleLake Arrowhead Real Estate | Prime Properties | Leverage Global Partners
 meta_descriptionPrime Properties is the exclusive representative for Leverage Global Partners in Lake Arrowhead, California, USA.
 meta_keywordsLake Arrowhead Real Estate, Prime Properties, Leverage Global Partners, Jeff Perlis
 login_message_counter2
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-12-09 16:21:37
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/76/prime-properties
 website_shortwww.therealestateplace.com
 name_with_locationPrime Properties
 Image(array)
 id3378
 modelLocation
 model_id115
 tagImage
 name76.jpg
 typeimage/jpeg
 size199889
 uri/assets/3378.jpg
 order0
 created2016-04-05 17:24:13
 modified2016-04-14 11:04:12
 1(array)
 Location(array)
 id112
 parent_id9
 brokerage_id41
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameTelluride, CO, USA
 short_nameTelluride, CO, USA
 group_index
 latitude37.957722
 longitude-107.882080
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionEveryone loves Telluride - the lifestyle is the best!
 long_descriptionVisitors are immediately enchanted with the breathtaking setting of the historic Town of Telluride. The grand snowcapped mountain peaks ensnare the senses, while the warm embrace of the Telluride community welcomes them to paradise. Each summer the town plays host to such world-renowned events as the Telluride Bluegrass Festival, Telluride Film Festival, and Telluride Blues & Brews Festival. Telluride, Mountain Village and their surrounding areas boast a desirable array of high-end luxury and value-oriented properties. Unlike other high profile resorts, Telluride and Mountain Village both offer true ski-in/out condos & homes with grand views and sumptuous amenities.
 created2016-04-05 16:30:17
 modified2016-04-05 16:30:17
 timezoneAmerica/Boise
 population3686
 uri/locations/view/112/telluride-co-usa
 tile_nameTelluride, CO, USA
 Brokerage(array)
 id41
 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_properties-1
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2504615
 timezoneUS/Mountain
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameTelluride Properties
 broker_of_record_name
 short_nameTelluride Properties
 usernameTelllurideProperties
 passworddf9e1cb9ed6ee8ffbaeb602e5a977dba189b7205
 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
 descriptionTelluride Properties is the exclusive representative for Leverage Global Partners in Telluride, Colorado, USA. Telluride Properties has earned a reputation as the premier Telluride real estate firm, bringing buyers and sellers together since 1986. We understand every aspect of the Telluride real estate market, including ski homes and condominiums, Telluride’s historic Victorian residences, developments, ranches, short sale & bank owned properties, vacation homes and year-round residences. Telluride Properties’ success is based on yours. We provide the tools and proactive guidance it takes to reach our clients’ goals. Our attention to details that matter most to you are hallmarks that significantly enhance the experience you deserve. Telluride Properties has a proven team of skilled real estate brokers ready to assist you with your Telluride real estate assets.
 communitiesTelluride
 websitehttp://www.tellurideproperties.com
 address237 S. Oak Street
 address_2PO Box 37
 cityTelluride
 stateCO
 full_stateColorado
 countryUSA
 marketTelluride
 market_2
 postal_code81435
 phone(970) 708-5527
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameAlbert Roer
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-albert-roer-managing-partner-telluride-properties/
 contact_big_profile_link_text
 contact_titleManaging Partner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename41.jpg
 logo_filename41.jpg
 contact_image_filename41.jpg
 all_properties_link_image_filename41.jpg
 all_properties_linkhttp://www.searchtelluriderealestate.com/results/?UserID=all
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/klILER0J-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleTelluride Real Estate | Telluride Properties | Leverage Global Partners
 meta_descriptionTelluride Properties is the exclusive representative for Leverage Global Partners in Telluride, Colorado, USA.
 meta_keywordsTelluride real estate, Telluride Properties, Albert Roer, Telluride Colorado, leverage global partners
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-08-09 12:10:53
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/41/telluride-properties
 website_shortwww.tellurideproperties.com
 name_with_locationTelluride Properties
 Image(array)
 id3375
 modelLocation
 model_id112
 tagImage
 name39922990_telluride_town_shot.jpg
 typeimage/jpeg
 size8168766
 uri/assets/3375.jpg
 order0
 created2016-04-05 16:17:35
 modified2016-04-05 16:30:17
 2(array)
 Location(array)
 id71
 parent_id8
 brokerage_id229
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameMelbourne, FL, USA
 short_nameMelbourne, FL, USA
 group_index
 latitude28.083628
 longitude-80.608109
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 17:58:51
 modified2016-04-04 17:58:51
 timezoneAmerica/New_York
 population77500
 uri/locations/view/71/melbourne-fl-usa
 tile_nameMelbourne, FL, USA
 Brokerage(array)
 id229
 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(true)
 country_id0
 WOEID2449097
 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
 nameCurri Properties
 broker_of_record_name
 short_nameCurri Properties
 usernamecurriproperties
 password9e8524ed8ef59b0e785808fcccc169873ee3c9dd
 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
 descriptionCurri Properties is the exclusive representative for Leverage Global Partners in all of Brevard County, including Melbourne, FL, USA. Curri Properties was established in late 2003 after realizing there was a void in Brevard County, Fl for a local, professional boutique real estate brokerage firm, that specialized in Waterfront, Luxury & Commercial property sales. Consisting of just over 20 associates, we pride ourselves on dynamic marketing skills that allows for greater global exposure. This is achieved by marketing our properties through our internet affiliates, and within our company website, which is top ranked amongst Google’s search engine. <a title="www.CurriProperties.com" href="http://www.CurriProperties.com" target="_blank">www.CurriProperties.com</a> Selling luxury & waterfront real estate is not only a career, but a passion we portray in all aspects of what we do. We focus on the basics of what any and all small business relies on, community involvement and building lifelong relationships. In handling the sale or purchase of a home, it not only is a desire, or a dream, but a financial commitment which is generally a family’s largest investment. We are here to insure our client’s best interest each and every time, while giving you five star service along the way. Our service will never be compromised, as we continue to stay focused on our motto. Professionalism, Integrity, Building Relationships.
 communitiesMelbourne Brevard County
 websitehttp://www.curriproperties.net/
 address2893 N. Harbor City Blvd.
 address_2
 cityMelbourne
 stateFL
 full_stateFlorida
 countryUSA
 market
 market_2
 postal_code32935
 phoneCell: (321) 961-4487
 phone_2Office: (888) 638-3832
 phone_3
 wide_contact_image(false)
 contact_nameJohn Curri
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner/CEO
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename229.jpg
 logo_filename229.JPG
 contact_image_filename229.png
 all_properties_link_image_filename229.jpg
 all_properties_linkhttp://www.curriproperties.net/Exclusive-Listings-6-269.html
 video_embed_code
 contact_video_embed_code
 meta_titleMelbourne Real Estate | Curri Properties | Leverage Global Partners
 meta_descriptionCurri Properties is the exclusive representative for Leverage Global Partners in all of Brevard County, including Melbourne, FL, USA.
 meta_keywordscurri properties, melbourne real estate, brevard county real estate, leverage global partners, florida real estate
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-10-07 16:02:52
 modified2016-04-08 16:34:31
 dre_num012345
 uri/brokerage-detail/229/curri-properties
 website_shortwww.curriproperties.net
 name_with_locationCurri Properties
 Image(array)
 id3003
 modelLocation
 model_id71
 tagImage
 nameCurri Properties.jpg
 typeimage/jpeg
 size229870
 uri/assets/3003.jpg
 order0
 created2016-04-04 17:57:58
 modified2016-04-04 17:58:51
 3(array)
 Location(array)
 id96
 parent_id9
 brokerage_id18
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameSan Francisco, CA, USA
 short_nameSan Francisco, CA, USA
 group_index
 latitude37.774929
 longitude-122.419418
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionConsidered by millions as the Best City in America.
 long_descriptionWith San Francisco’s sweeping vistas, charming neighborhoods, beautiful beaches, world-class cultural and sports activities -- not to mention some of the best food, architecture, music and art in the U.S., it's easy to see why so many are lured to this spectacular City by the Bay. Besides being one of the most visually stunning places on earth, San Francisco has a proud history of attracting pioneers, entrepreneurs and forward thinking innovators in business, technology, government, science, the arts, food & wine, healthy living and so much more. It’s no wonder that its residents and millions of annual visitors alike consider it the Best City in America.
 created2016-04-05 11:33:25
 modified2016-04-14 13:33:16
 timezoneAmerica/Los_Angeles
 population852469
 uri/locations/view/96/san-francisco-ca-usa
 tile_nameSan Francisco, CA, USA
 Brokerage(array)
 id18
 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_properties5
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2487956
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameVanguard Properties
 broker_of_record_name
 short_nameVanguard Properties
 usernameVanguardSF
 passworde8045814d4cc920c82b1497cdc9288d62d2c8c16
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionVanguard Properties is the exclusive representative for Leverage Global Partners in San Francisco, California, USA. For close to 30 years, Vanguard Properties has offered impeccable service to buyers and sellers in San Francisco. We are proud of our team of professionals, who are service-driven and passionately share in your goal to find the home that’s right for you in the manner that fits your lifestyle. COMMITMENT At Vanguard, we stake our reputation on every relationship we create. Your unique client experience will be built on the high degree of professionalism and on our commitment to delivering service tailored to your individual needs, at every point of contact. With Vanguard by your side, you can feel confident that all aspects of your development are in good hands. We are proud to have provided developers with expert service for over twenty years now, including buyer insights that come by working with discerning buyers in highly dynamic markets. But we are only as good as the service we offer to the valued clients we work with today. They demand nothing but the best. Fortunately, we're in a position to deliver. DISTINCTION Vanguard brings exceptional homes to market, consistently and with outstanding results, under the guidance of some of the most respected professionals in the business. Our founder, James Nunemacher, is within the top 1% of real estate sales in the nation, and an acknowledged expert in the market. His exacting standards set the tone for everything we do. Simply put, no one is more qualified than Vanguard. This was true when we opened for business selling residential real estate. It has never been truer today, as our services have grown to encompass every aspect of the process of developing and marketing the most sought-after homes and developments in one of the most competitive markets. SERVICE Vanguard understands what discerning buyers and sellers are looking for, and equally importantly, what they are not. As your trusted partner, we will review and advise on every aspect of your home, from floor plans to finishing touches. Our instinct for detail may result in suggestions that surprise you. MARKETING Quality homes may be timeless. Marketing, however, demands the ability to match the leading-edge of customer expectations and stay several steps ahead of your competition. Vanguard's leadership is no more obvious than in the field of marketing. We will develop fresh, innovative strategies for you, incorporating a keen sense of brand-identity and integrating the technology that drives the housing market today. Your home is much more than simply brick and mortar. It is an investment upon which you expect the highest returns. With Vanguard's marketing acumen you can be confident that your home-buying audience is appropriately targeted and your return on investment is fully realized. Vanguard Properties also has locations in the beautiful California wine country region of <a href="../../../brokerage-detail/46/Vanguard-Properties" target="_blank">Sonoma County</a>. 
 communitiesSan Francisco
 websitehttp://vanguardsf.com/
 address2501 Mission Street
 address_2
 citySan Francisco
 stateCA
 full_stateCalifornia
 countryUSA
 marketSan Francisco
 market_2
 postal_code94110
 phone(415) 321-7007
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJames Nunemacher
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-james-nunemacher-principal-vanguard-properties/
 contact_big_profile_link_text
 contact_titleCEO
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename18.jpg
 logo_filename18.jpg
 contact_image_filename18.jpg
 all_properties_link_image_filename18.jpg
 all_properties_linkhttp://vanguardsf.com/VGlistings.php
 video_embed_code
 contact_video_embed_code
 meta_titleSan Francisco Real Estate | Vanguard Properties | Leverage Global Partners
 meta_descriptionVanguard Properties is the exclusive representative for Leverage Global Partners in San Francisco, California, USA.
 meta_keywordsSan Francisco Real Estate, Leverage Global Partners, vanguard properties, james nunemacher
 login_message_counter2
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-04-01 17:26:09
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/18/vanguard-properties
 website_shortvanguardsf.com
 name_with_locationVanguard Properties
 Image(array)
 id3030
 modelLocation
 model_id96
 tagImage
 name18.jpg
 typeimage/jpeg
 size204183
 uri/assets/3030.jpg
 order0
 created2016-04-05 11:31:23
 modified2016-04-14 13:33:16
- location_properties(empty)
- main_article(empty)
- brokerage(array)
 Brokerage(array)
 id137
 account_executive_id236
 archived(false)
 typedevelopment
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties1
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2414583
 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
 nameThe Marchant Company, Inc.
 broker_of_record_name
 short_nameThe Marchant Company, Inc.
 usernameMarchantCompany
 password6b21dd1cd4314d8aa44643c451d87aa74a809a21
 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
 descriptionThe Marchant Company, Inc. is the exclusive representative for Leverage Global Partners in the Greater Greenville Area, Taylors, Mauldin, Travelers Rest, Greer, Fountain Inn, Easley, and Simpsonville, South Carolina, USA. Makings of the Marchant Company After working in the Greenville real estate market for twenty-five years, Seabrook Marchant founded the Marchant Company in 1993 as a new home sales and subdivision development company. After two years of exclusively representing builders and new home communities, the Marchant Company entered the general real estate and property management business. Beginning with one client, two employees and an in-home office, the Marchant Company has grown to twenty-four agents with two office locations in the Upstate. Celebrating 20 Years of History Over its twenty year history, the Marchant Company has been recognized as the Small Business of the Month and nominated for Small Business of the Year in 2002 by the Greenville Chamber of Commerce. Other accomplishments include being named the exclusive marketing company for Montebello luxury subdivision in 1997, receiving a license to do business in North Carolina in 2004 and forming Marchant Property Management, LLC in 2009 to provide tenants, homeowners and investors across the Upstate a variety of property management services. In the same year, the Marchant Company founder, Seabrook Marchant, was awarded “Realtor Emeritus” status by the National Association of Realtors honoring his 40 plus years of work as a Realtor. Family Foundations Seabrook Marchant graduated from Clemson University in 1964 with a Bachelor of Science Degree. He is a Certified Real Estate Brokerage Manager (CRB), a Graduate of the REALTOR® Institute (GRI), and a Certified New Home Marketing Professional (CMP). He works alongside three of his family members at the Marchant Company and is a dedicated Greenville community volunteer. He serves as chairman of Faith Memorial Chapel, Board of Trustees in Cedar Mountain, NC, is a Meals on Wheels volunteer and a board member of Greenville Home Builders Association and Secretary of Connector 2000 Association (Southern Connector). He previously served as President of both the Greater Greenville Association of Realtors and the Greenville Multiple Listings Service. Decades of Trust. Confidence in the Future. The Marchant Company covers a broad range of real estate to meet the demands of the everchanging market: • Residential Real Estate • Commercial Real Estate • New Home Communities • Property Management (currently managing approx. 400 properties) • Foreclosed & Distressed Properties • Land & Acreage – Mountain Properties 
 communitiesGreater Greenville Area Taylors Mauldin Travelers Rest Greer Fountain Inn Easley Simpsonville
 websitehttp://www.marchantco.com/
 address100 West Stone Avenue
 address_2
 cityGreenville
 stateSC
 full_stateSouth Carolina
 countryUSA
 market
 market_2
 postal_code29609
 phone(864) 467-0085
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameSeabrook Marchant
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-seabrook-marchant/
 contact_big_profile_link_text
 contact_titlePresident / Broker in Charge
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename137.jpg
 logo_filename137.png
 contact_image_filename137.JPG
 all_properties_link_image_filename137.jpg
 all_properties_linkhttp://www.marchantco.com/view-our-properties/residential-real-estate/
 video_embed_code
 contact_video_embed_code
 meta_titleGreenville Real Estate | The Marchant Company, Inc. | Leverage Global Partners
 meta_descriptionThe Marchant Company, Inc. is the exclusive representative for Leverage Global Partners in Greenville, South Carolina, USA.
 meta_keywordsThe Marchant Company, Inc., Greenville Real Estate, Seabrook Marchant, Greater Greenville Area Real Estate, Taylors Real Estate, Mauldin Real Estate, Travelers Rest Real Estate, Greer Real Estate, Fountain Inn Real Estate, Easley Real Estate, Simpsonville Real Estate, South Carolina, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-06-30 16:39:09
 modified2019-09-09 11:38:32
 dre_num012345
 uri/development-detail/137/the-marchant-company-inc
 website_shortwww.marchantco.com
 name_with_locationThe Marchant Company, Inc. - Greenville, SC, 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)
 id2650
 modelBrokerage
 model_id137
 tagLogo
 name137.png
 typeimage/png
 size19174
 uri/assets/2650.png
 order0
 created2016-03-30 11:42:02
 modified2019-09-09 11:38:32
 MainImage(array)
 id2649
 modelBrokerage
 model_id137
 tagMainImage
 name137.jpg
 typeimage/jpg
 size3462266
 uri/assets/2649.jpg
 order0
 created2016-03-30 11:42:01
 modified2019-09-09 11:38:32
 ContactImage(array)
 id2651
 modelBrokerage
 model_id137
 tagContactImage
 name137.JPG
 typeimage/JPG
 size6476628
 uri/assets/2651.JPG
 order0
 created2016-03-30 11:42:02
 modified2019-09-09 11:38:32
 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)
 id274
 modelBrokerage
 model_id137
 archived(false)
 medium_featured(false)
 large_featured(false)
 titleMeet SEABROOK MARCHANT: President, THE MARCHANT COMPANY, Greenville, SC
 authorLeverageRE
 date2014-09-09
 lead_inGet to know Seabrook Marchant, President / Broker-in-Charge of Leverage Partner The Marchant Company, Inc. in Greenville, South Carolina, USA.
 body <h4>What was your vision in founding/stepping into leadership at The Marchant Company, Inc.?</h4> Encouraged by my father, I have always had an entrepreneurial spirit and felt after working 25 years for another company that the time was right (1993) for me to step out on my own. At that time I sensed that there was a void in the Greenville market for a company that specialized in new home sales and subdivision development. And that is the way The Marchant Company started. <img class="aligncenter wp-image-6312 pure-img" src="/assets/1092.jpg" alt="Partner Profile: Seabrook Marchant" width="578" height="385" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Seabrook-3-300x200.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Seabrook-3-585x390.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Seabrook-3-360x240.jpg 360w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Seabrook-3-600x400.jpg 600w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Seabrook-3.jpg 960w" sizes="(max-width: 578px) 100vw, 578px"> <h4>Can you describe a significant turning point in your career?</h4> No particular "single" thing, just a burning desire to do my own thing and be my own boss. <h4>How has technology, social media and online marketing changed and/or impacted your approach to business?</h4> It's truly amazing to me how these factors have changed our approach to business. We pay much attention to all and are constantly looking for new ways to improve our business by the implementation of all three. <img class="aligncenter wp-image-6316 pure-img" src="/assets/1093.jpg" alt="Partner Profile: Seabrook Marchant" width="599" height="399" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Seabrook-grandkids-300x200.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Seabrook-grandkids-585x390.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Seabrook-grandkids-360x240.jpg 360w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Seabrook-grandkids-600x400.jpg 600w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Seabrook-grandkids.jpg 960w" sizes="(max-width: 599px) 100vw, 599px"> <h4>What do you love most about working and living in Greenville?</h4> I was born and raised in Greenville and never desired to live anywhere else. The people here are wonderful and Greenville is truly a unique city with so much to offer. <h4>How do you like to spend your free time?</h4> We have a mountain home not far from Greenville and I love to spend time there. I also enjoy going to athletic events especially anything involving my Clemson Tigers, but the one thing I enjoy most is spending time with my seven grandchildren. <img class="aligncenter wp-image-6317 pure-img" src="/assets/1094.jpg" alt="Partner Profile: Seabrook Marchant" width="611" height="390" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Seabrook-golf-cart-300x191.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Seabrook-golf-cart-585x373.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Seabrook-golf-cart.jpg 960w" sizes="(max-width: 611px) 100vw, 611px"> <h4>How do you think your colleagues would describe you?</h4> I would hope they would say they enjoy working for us, that I'm a good listener and that I want to see them succeed. <h4>What is your daily "must-do"?</h4> I try to start each day with a brief devotional followed by an hour or so of exercise. <h4>Name one thing we might not know about you.</h4> I have a huge respect for men and women in the armed forces, all veterans and all others who serve our community. I briefly considered a career in the Army while on active duty. Leverage Global Partners is proud to have Seabrook Marchant and the team at The Marchant Company, Inc. as our partners in the network. <img class="aligncenter wp-image-6318 pure-img" src="/assets/1095.jpg" alt="Partner Profile: Seabrook Marchant" width="564" height="580" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Seabrook-2-585x601.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Seabrook-2.jpg 960w" sizes="(max-width: 564px) 100vw, 564px">
 vimeo_id
 created2016-02-25 14:11:50
 modified2016-04-05 14:41:07
 uri/articles/view/274/meet-seabrook-marchant-president-the-marchant-company-greenville-sc
 FeaturedImage(array)
 0(array)
 id23044
 modelBrokerage
 model_id137
 tagFeaturedImage
 nameapartment-architectural-design-architecture-1436190.jpg
 typeimage/jpeg
 size818644
 uri/assets/23044.jpg
 order0
 created2019-09-09 11:38:18
 modified2019-09-09 11:38:32
 1(array)
 id23048
 modelBrokerage
 model_id137
 tagFeaturedImage
 namebackyard-lights-mansion-32870.jpg
 typeimage/jpeg
 size353456
 uri/assets/23048.jpg
 order1
 created2019-09-09 11:38:19
 modified2019-09-09 11:38:32
 2(array)
 id23042
 modelBrokerage
 model_id137
 tagFeaturedImage
 nameapartment-architectural-design-architecture-323780.jpg
 typeimage/jpeg
 size332829
 uri/assets/23042.jpg
 order2
 created2019-09-09 11:38:18
 modified2019-09-09 11:38:32
 3(array)
 id23043
 modelBrokerage
 model_id137
 tagFeaturedImage
 namearchitectural-design-architecture-blue-sky-462358.jpg
 typeimage/jpeg
 size382238
 uri/assets/23043.jpg
 order3
 created2019-09-09 11:38:18
 modified2019-09-09 11:38:32
 4(array)
 id23045
 modelBrokerage
 model_id137
 tagFeaturedImage
 nameaerial-aerial-shot-architecture-1642125.jpg
 typeimage/jpeg
 size743664
 uri/assets/23045.jpg
 order4
 created2019-09-09 11:38:19
 modified2019-09-09 11:38:32
 5(array)
 id23040
 modelBrokerage
 model_id137
 tagFeaturedImage
 nameaerial-photography-architecture-building-1546168.jpg
 typeimage/jpeg
 size356213
 uri/assets/23040.jpg
 order5
 created2019-09-09 11:38:17
 modified2019-09-09 11:38:32
 6(array)
 id23046
 modelBrokerage
 model_id137
 tagFeaturedImage
 namearchitectural-design-architecture-clouds-1732414.jpg
 typeimage/jpeg
 size363725
 uri/assets/23046.jpg
 order6
 created2019-09-09 11:38:19
 modified2019-09-09 11:38:32
 7(array)
 id23047
 modelBrokerage
 model_id137
 tagFeaturedImage
 namearchitecture-bird-s-eye-view-buildings-1587947.jpg
 typeimage/jpeg
 size980979
 uri/assets/23047.jpg
 order7
 created2019-09-09 11:38:19
 modified2019-09-09 11:38:32
 8(array)
 id23049
 modelBrokerage
 model_id137
 tagFeaturedImage
 namearchitectural-design-architecture-blue-sky-1838640.jpg
 typeimage/jpeg
 size895148
 uri/assets/23049.jpg
 order8
 created2019-09-09 11:38:19
 modified2019-09-09 11:38:32
 9(array)
 id23041
 modelBrokerage
 model_id137
 tagFeaturedImage
 nameappartment-building-appartments-architecture-87223.jpg
 typeimage/jpeg
 size309517
 uri/assets/23041.jpg
 order9
 created2019-09-09 11:38:17
 modified2019-09-09 11:38:32
 Location(array)
 0(array)
 id90
 parent_id8
 brokerage_id137
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameGreenville, SC, USA
 short_nameGreenville, SC, USA
 group_index
 latitude34.852619
 longitude-82.394012
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-05 11:19:14
 modified2016-04-05 11:19:14
 timezoneAmerica/New_York
 population62000
 uri/locations/view/90/greenville-sc-usa
 tile_nameGreenville, SC, USA
 User(array)
 0(array)
 id142
 typeBrokerageAdmin
 brokerage_id137
 email[email protected]
 password6b21dd1cd4314d8aa44643c451d87aa74a809a21
 recover_hash
 first_nameSeabrook
 last_nameMarchant
 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:25
 created2016-04-08 16:34:09
 notified(true)
 full_nameSeabrook Marchant
 uri/agent-detail/142/seabrook-marchant
 profile_complete(true)
 1(array)
 id249
 typeAgent
 brokerage_id137
 email[email protected]
 password9b8c151abaff26ab40b611487d484bad300f03f9
 recover_hash
 first_nameAnne
 last_nameMarchant
 title
 dre_num
 phone864.420.0009
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:37
 created2017-08-07 15:22:37
 notified(false)
 full_nameAnne Marchant
 uri/agent-detail/249/anne-marchant
 profile_complete(true)
 2(array)
 id250
 typeAgent
 brokerage_id137
 email[email protected]
 passwordb8b29b178cdde15fbb104fdf9461a11e331186d2
 recover_hash
 first_nameJolene
 last_nameWimberly
 title
 dre_num
 phone864.414.1688
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:37
 created2017-08-07 15:22:37
 notified(false)
 full_nameJolene Wimberly
 uri/agent-detail/250/jolene-wimberly
 profile_complete(true)
 3(array)
 id251
 typeAgent
 brokerage_id137
 email[email protected]
 password52cbbb6bfe7cc48a58e120646084fcbc1947d7ab
 recover_hash
 first_nameGordon D.
 last_nameSeay
 title
 dre_num
 phone864.444.4359
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:37
 created2017-08-07 15:22:37
 notified(false)
 full_nameGordon D. Seay
 uri/agent-detail/251/gordon-d-seay
 profile_complete(true)
 4(array)
 id253
 typeAgent
 brokerage_id137
 email[email protected]
 passworddfa962f8b14ee2a238e9abf53b8f15798565a612
 recover_hash
 first_nameValerie
 last_nameMiller
 title
 dre_num
 phone864.430.6602
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:37
 created2017-08-07 15:22:37
 notified(false)
 full_nameValerie Miller
 uri/agent-detail/253/valerie-miller
 profile_complete(true)
 5(array)
 id706
 typeAgent
 brokerage_id137
 email[email protected]
 password9fd824a040a97a67f5ba1c3756978886f4b4e819
 recover_hash
 first_nameBrian
 last_nameMarchant
 title
 dre_num
 phone864.631.5858
 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_nameBrian Marchant
 uri/agent-detail/706/brian-marchant
 profile_complete(true)
 6(array)
 id707
 typeAgent
 brokerage_id137
 email[email protected]
 passwordfcdba698227d36e0ee364a56704cf05a9be0d5af
 recover_hash
 first_nameLydia
 last_nameJohnson
 title
 dre_num
 phone864.918.9663
 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_nameLydia Johnson
 uri/agent-detail/707/lydia-johnson
 profile_complete(true)
 7(array)
 id708
 typeAgent
 brokerage_id137
 email[email protected]
 password06c5e3445326ae19878d6595ce21c1d28fc9b182
 recover_hash
 first_nameMikel-Ann
 last_nameScott
 title
 dre_num
 phone864.630.2474
 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_nameMikel-Ann Scott
 uri/agent-detail/708/mikel-ann-scott
 profile_complete(true)
 8(array)
 id825
 typeAgent
 brokerage_id137
 email[email protected]
 password02cd22ddfd599cd0912d57443920fb59d16cf959
 recover_hash
 first_nameNancy
 last_nameMcCrory
 title
 dre_num
 phone864.505.8367
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:40
 created2017-08-07 15:23:40
 notified(false)
 full_nameNancy McCrory
 uri/agent-detail/825/nancy-mccrory
 profile_complete(true)
 9(array)
 id826
 typeAgent
 brokerage_id137
 email[email protected]
 password6993de01b5ea98f5703d4f87636aaf5be6fdf6b1
 recover_hash
 first_nameKaren
 last_nameTurpin
 title
 dre_num
 phone864.230.5176
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:40
 created2017-08-07 15:23:40
 notified(false)
 full_nameKaren Turpin
 uri/agent-detail/826/karen-turpin
 profile_complete(true)
- location(array)
 Location(array)
 id90
 parent_id8
 brokerage_id137
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameGreenville, SC, USA
 short_nameGreenville, SC, USA
 group_index
 latitude34.852619
 longitude-82.394012
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-05 11:19:14
 modified2016-04-05 11:19:14
 timezoneAmerica/New_York
 population62000
 uri/locations/view/90/greenville-sc-usa
 tile_nameGreenville, SC, USA
 Image(array)
 id3024
 modelLocation
 model_id90
 tagImage
 namemarchant.jpg
 typeimage/jpeg
 size122157
 uri/assets/3024.jpg
 order0
 created2016-04-05 11:19:04
 modified2016-04-05 11:19:14
- 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/90/greenville-sc-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/locations/view/90/greenville-sc-usa
Remote Port	15965
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	162.159.115.42
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http 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	a09e4a851edbdafe-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	aipKtDpysHdOfAmunox3KgAAAE0
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	aipKtDpysHdOfAmunox3KgAAAE0
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781156532.0305
Request Time	1781156532

====

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

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

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 20 ms
Total Queries: 19 queries