Locations / Cape Coral, FL, USA

Cape Coral, FL, USA

More information coming soon!

Location Represented By

License #: 012345

12:42am local time

Partner Search

Find partners with a map-based search

Related Locations

Saddle River, NJ, USA

Servicing Northern New Jersey directly outside of New York City.

Atlanta, GA, USA

Savannah, GA, USA

Historic Homes, Live Oaks draped in Moss, Oceanfront, Marshfront, Savannah has it all!

Rhinebeck, NY, USA

Related Partners

Turnberry International Realty

(305) 935-0300 | Email
License #: 012345

Plantación Properties

Office: 1 (506) 2654-4004 | Email
License #: 012345

J. Rockcliff Realtors

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

Kerwin & Associates

(650) 473-1500 | Email
License #: 012345

Recent Property Listings

Over 100 ft of Riverfront with Sandy Beach

9853 S Dike Rd
Mohave Valley, AZ 86440
$1,750,000

Artful Spaces

4421 Ridge Street
Chevy Chase, MD 20815
$2,200,000

Modern, Updated Ranch Home with Mesmerizing Ocean Views

545 Catalonia Avenue
Pacific Palisades, CA 90272
$2,995,000

Classic, Detailed Colonial With Endless Possibilities

1795 Warwick Road
San Marino, CA 91108
$2,198,000

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

Array
(
)

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

Cake Params
- plugin(null)
- controllerlocations
- actionview
- named(empty)
- pass(array)
  0177
  1cape-coral-fl-usa
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

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

Sql Log

Sql Logs

default

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

Query Explain:

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

====

Timer

Memory

Peak Memory Use 12.10 MB

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

Timers

Total Request Time: 532 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	360.63
Event: Controller.initialize	3.81
Event: Controller.startup	1.13
Controller action	49.49
Event: Controller.beforeRender	8.78
» Processing toolbar data	8.68
Rendering View	85.11
» Event: View.beforeRender	0.25
» Rendering APP/View/Locations/view.ctp	2.54
» » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.14
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.15
» » Rendering APP/View/Elements/sidebar/brokerage_list.ctp	0.15
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.24
» » » Rendering APP/View/Elements/static_property_price.ctp	0.36
» » » Rendering APP/View/Elements/static_property_price.ctp #2	0.16
» » » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.15
» » 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.62
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)
 id3726
 brokerage_id192
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameOver 100 ft of Riverfront with Sandy Beach
 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)
 descriptionMain house includes 6 BDR and 7 Baths. Master suite located on main floor with jet tub, walk in shower and sweeping views of the Colorado River. 2 additional bdr suites on main floor as well. Dramatic entry with dynamic views of the river from 2 story entry faced with wall of windows. Plenty of room for sit down dinner or quick snack at the breakfast bar. Dream kitchen with granite counters, Dacon appliances, Sub Zero Refrigerator, gas cook top and views to the river. Upstairs you'll find spacious family room with 1/2 bath and closet with access to sundeck and 2 bedroom suites. Guests feel special in the mini master complete with private deck and views of the river. Catwalk connects family room and bedrooms with gorgeous views of the river, sandy beach and front yard compound. Short walk to guest house with over 750 sq ft. Over 100 ft of riverfront with sandy beach, private boat launch and dock. Electric gate entry, fully fenced acreage makes living on the river a true private vacation destination. Outdoor kitchen and covered patios! Sand between the toes and a bit of shade under the palapa as living on the river doesn't get any better than this.
 address9853 S Dike Rd
 address_2
 cityMohave Valley
 stateAZ
 postal_code86440
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1750000
 price_20
 price_usd1750000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms7
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet5249
 square_meters
 acres52391
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size52391
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://search.ussw.net/listing/912084
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial4
 bathrooms_partial_20
 bathrooms_3_41
 bathrooms_3_4_20
 year_built1998
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num912084
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude37.090240
 longitude-95.712891
 invalid_required_fields
 invalid_optional_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 05:33:03
 created2016-04-13 10:23:58
 uri/property-detail/3726/9853-s-dike-rd-mohave-valley-az-86440-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3726/9853-s-dike-rd-mohave-valley-az-86440-usa
 address_concat9853 S Dike Rd Mohave Valley AZ 86440 USA
 google_maps_query_string9853+S+Dike+Rd++Mohave+Valley+AZ+86440+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,750,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty7
 bathrooms_pretty3
 bathrooms_partial_pretty4
 bathrooms_3_4_pretty1
 feed_full_bathrooms4
 date_listed2016-04-13
 overridden_brokerage_nameUS Southwest
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id192
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2371675
 timezoneUS/Mountain
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameUS Southwest
 broker_of_record_name
 short_nameUS Southwest
 usernameUSSouthwestLLC
 passwordaca3f804a48f1447c4a6fd356b1f302279862050
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, Mohave Valley, Fort Mohave AZ, USA. US Southwest is a boutique real estate company comprised of like minded pro-fessionals whose mission is to provide the best professional service so their clients can make informed decisions to achieve their goals. The talent and depth within the company is unmatched in Mohave County. Several of the key players at US Southwest have managed a business or owned their own busi- ness. The combined talents provide a unique business platform in which diversity, collaboration, team work, and professionalism, foster a business perspective and environment that generates creativity and productivity, and ultimately, successful results for clients. US Southwest has the capability, expertise and area relationships to assist its clients in any type of real estate endeavor. Its founders, Ann L. Pettit and Ray W. Jackson III, have worked in every kind of real estate enterprise for over 30 years in Northwestern Arizona and are perceived as innovative leaders and pioneers of the industry. They have a relationship building philosophy and their motto is - Your Success is Our Success.
 communitiesBullhead City Fort Mohave Mohave Valley
 websitehttp://ussw.net/
 address3767 Highway 95
 address_2
 cityBullhead City
 stateAZ
 full_stateArizona
 countryUSA
 market
 market_2
 postal_code86442
 phone(928) 763-2288
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameAnn Pettit
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename192.jpg
 logo_filename192.jpg
 contact_image_filename192.png
 all_properties_link_image_filename192.jpg
 all_properties_linkhttp://ussw.net/wolfnet-properties
 video_embed_code
 contact_video_embed_code
 meta_titleBullhead City Real Estate | US Southwest | Leverage Global Partners
 meta_descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, AZ, USA.
 meta_keywordsUS Southwest LLC, Bullhead city real estate, arizona real estate, ann pettit, bullhead city, leverage global partners, Fort Mohave, Mohave Valley
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-02-13 10:18:22
 modified2016-04-08 16:34:20
 dre_num012345
 uri/brokerage-detail/192/us-southwest
 website_shortussw.net
 name_with_locationUS Southwest
 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)
 id20809
 modelProperty
 model_id3726
 tagImage
 name9853_Dike (1).jpg
 typeimage/jpeg
 size1946014
 uri/assets/20809.jpg
 order0
 created2016-04-13 10:23:45
 modified2016-04-13 10:23:59
 1(array)
 id20805
 modelProperty
 model_id3726
 tagImage
 name9853DikeRd_60.jpg
 typeimage/jpeg
 size464564
 uri/assets/20805.jpg
 order1
 created2016-04-13 10:23:43
 modified2016-04-13 10:23:59
 2(array)
 id20806
 modelProperty
 model_id3726
 tagImage
 name9853DikeRd_19.jpg
 typeimage/jpeg
 size270202
 uri/assets/20806.jpg
 order2
 created2016-04-13 10:23:43
 modified2016-04-13 10:23:59
 3(array)
 id20807
 modelProperty
 model_id3726
 tagImage
 name9853DikeRd_70.jpg
 typeimage/jpeg
 size288097
 uri/assets/20807.jpg
 order3
 created2016-04-13 10:23:44
 modified2016-04-13 10:23:59
 4(array)
 id20808
 modelProperty
 model_id3726
 tagImage
 name9853DikeRd_69.jpg
 typeimage/jpeg
 size444920
 uri/assets/20808.jpg
 order4
 created2016-04-13 10:23:44
 modified2016-04-13 10:23:59
 5(array)
 id20810
 modelProperty
 model_id3726
 tagImage
 name9853DikeRd_76.jpg
 typeimage/jpeg
 size404572
 uri/assets/20810.jpg
 order5
 created2016-04-13 10:23:53
 modified2016-04-13 10:23:59
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id4387
 property_id3726
 property_feature_id1
 1(array)
 id2
 nameBeach Access
 additional(false)
 created2016-04-07 14:00:52
 modified2016-04-07 14:00:52
 PropertiesPropertyFeature(array)
 id4388
 property_id3726
 property_feature_id2
 2(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id4389
 property_id3726
 property_feature_id4
 3(array)
 id10
 nameOn The Sand
 additional(false)
 created2016-04-07 14:03:36
 modified2016-04-07 14:03:36
 PropertiesPropertyFeature(array)
 id4390
 property_id3726
 property_feature_id10
 4(array)
 id11
 nameSki In/Ski Out
 additional(false)
 created2016-04-07 14:03:53
 modified2016-04-07 14:03:53
 PropertiesPropertyFeature(array)
 id4391
 property_id3726
 property_feature_id11
 5(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id4392
 property_id3726
 property_feature_id14
 6(array)
 id17
 nameWaterfront
 additional(false)
 created2016-04-07 14:06:00
 modified2016-04-07 14:06:00
 PropertiesPropertyFeature(array)
 id4393
 property_id3726
 property_feature_id17
 Topic(array)
 0(array)
 id8
 nameBeach
 created2016-02-25 11:25:00
 modified2016-02-25 11:30:26
 tile_nameBeach
 PropertiesTopic(array)
 id23
 property_id3726
 topic_id8
 1(array)
 id20
 nameUltra Lux
 created2016-02-25 11:25:00
 modified2016-02-25 11:35:37
 tile_nameUltra Lux
 PropertiesTopic(array)
 id24
 property_id3726
 topic_id20
 1(array)
 Property(array)
 id3704
 brokerage_id81
 created_by_user_id0
 order2
 multi_unit(false)
 agent_1_id150
 agent_2_id0
 agent_3_id0
 nameArtful Spaces
 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)
 descriptionDramatic new home by PKK Builders & design by GTM Architects. Exceptional quality throughout. Stunning design. Beautiful scale. Unbeatable location,-talk about a great lifestyle!!! Completion early 2016. This is a great time to pick finishes and customize. Walk to downtown Bethesda, metro, shopping, restaurant district, entertainment & more! Comprehensive resident services by Town of Ch Chase!
 address4421 Ridge Street
 address_2
 cityChevy Chase
 stateMD
 postal_code20815
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2200000
 price_20
 price_usd2200000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms5
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://www.eversco.com/homes-for-sale-details/4421-RIDGE-STREET-CHEVY-CHASE-MD-20815/MC9503168/30/
 meta_titleArtful Spaces | Chevy Chase Real Estate | Evers & Co. Real Estate
 meta_description4421 Ridge Street is a property offered for sale in Chevy Chase, MD, USA, presented by Evers & Co. Real Estate
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://slideshow.mris.com/slideshow/slideshow.htm?ListingKey=99076375432
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2016-04-06 11:36:57
 uri/property-detail/3704/4421-ridge-street-chevy-chase-md-20815-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3704/4421-ridge-street-chevy-chase-md-20815-usa
 address_concat4421 Ridge Street Chevy Chase MD 20815 USA
 google_maps_query_string4421+Ridge+Street++Chevy+Chase+MD+20815+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,200,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty4
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2016-04-06
 overridden_brokerage_nameEvers & Co. Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id81
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2379523
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameEvers & Co. Real Estate
 broker_of_record_name
 short_nameEvers & Co. Real Estate
 usernameEversCoRealEstateCC
 password440e06f17502b0b97a9e4aa2f069e898691a3b4c
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionEvers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Chevy Chase, MD, and <a href="../../../brokerage-detail/80/Evers-&-Co.-Real-Estate">Washington, D.C</a>, USA., We are 100+ salespeople who offer our clients a level of service that is unmatched in today’s real estate marketplace, and we deliver this extraordinary service with courtesy and integrity to everyone involved in each transaction. We are enthusiastic about the neighborhoods where we live and work, from Chevy Chase to Capitol Hill, from Dupont Circle to Arlington, and everywhere in between. The highly visible storefront offices of Evers & Co. in Downtown Washington, Friendship Heights in Upper Northwest, downtown Bethesda-Chevy Chase and in Bluemont in the Virginia Wine Country are bustling with the entrepreneurial energy of agents who have in-depth knowledge of local history, architecture and construction techniques as well as expert skills in marketing and negotiating, all of which adds value to our service and your investment. This spectrum of knowledge and our commitment to serving our clientele and fellow real estate associates with the highest level of integrity has made us the premier independent brokerage in the Metropolitan Washington area. Donna Evers and the agents of Evers & Co. invite you to join our growing community of buyers and sellers, who have been the source of 90% of our business for the past thirty years.
 communitiesBethesda Chevy Chase Village Town of Chevy Chase Somerset Edgemoor Kenwood Kenwood Park Burning Tree Avenel Silver Spring
 websitehttp://www.eversco.com/
 address7032 Wisconsin Avenue
 address_2
 cityChevy Chase
 stateMD
 full_stateMaryland
 countryUSA
 marketChevy Chase
 market_2
 postal_code20815
 phoneOffice: (301) 656-1800
 phone_2Cell: (202) 255-5009
 phone_3
 wide_contact_image(false)
 contact_nameDonna Evers
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident & Founder
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename81.jpg
 logo_filename81.jpg
 contact_image_filename81.jpg
 all_properties_link_image_filename81.JPG
 all_properties_linkhttp://eversco.idxre.com/featured/40484?CFID=10711248&CFTOKEN=99152164
 video_embed_code
 contact_video_embed_code
 meta_titleChevy Chase Real Estate | Evers & Co. Real Estate | Leverage Global Partners
 meta_descriptionEvers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Bethesda, Chevy Chase Village, Town of Chevy Chase, Somerset, Edgemoor, Kenwood, Kenwood Park, Burning Tree, Avenel, and Silver Spring, MD.
 meta_keywordsChevy Chase Real Estate, Evers & Co. Real Estate, Leverage Global Partners, Bethesda real estate, Chevy Chase Village real estate, Town of Chevy Chase real estate, Somerset real estate, Edgemoor real estate, Kenwood real estate, Kenwood Park real estate, Burning Tree real estate, Avenel real estate, and Silver Spring real estate, MD.
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-01-10 16:43:02
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/81/evers-co-real-estate
 website_shortwww.eversco.com
 name_with_locationEvers & Co. Real Estate
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id12970
 modelProperty
 model_id3704
 tagImage
 name36008.jpg
 typeimage/jpg
 size1341879
 uri/assets/12970.jpg
 order0
 created2016-04-07 16:36:06
 modified2016-04-07 16:36:06
 User(array)
 0(array)
 id373
 typeAgent
 brokerage_id81
 email[email protected]
 passwordb55b12a59c129a72a8f1b8e192578b4ea7cdc2a3
 recover_hash
 first_nameEric
 last_nameMurtagh
 title
 dre_num
 phone301-412-9066
 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_nameEric Murtagh
 uri/agent-detail/373/eric-murtagh
 profile_complete(true)
 UsersProperty(array)
 id169
 user_id373
 property_id3704
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 2(array)
 Property(array)
 id3741
 brokerage_id3
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameModern, Updated Ranch Home with Mesmerizing Ocean Views
 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)
 descriptionPalisades modern ranch with mesmerizing ocean views by renowned architect, David Kellen. A special updated home, perched on a promontory above the street on a 16,000 ft. lot with abundant natural light and bright, open spaces. Enter into an open living, dining, and music room, which leads seamlessly to the large grassy backyard area with pool. Sleek and simple modern kitchen with breakfast nook. Two bedroom suites (including a junior master) and a den downstairs, all opening to the lovely outdoors. Upstairs is a breathtaking master suite with open loft style walls with oversized windows and sweeping ocean, city and canyon views. Additional bedroom suite upstairs.
 address545 Catalonia Avenue
 address_2
 cityPacific Palisades
 stateCA
 postal_code90272
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2995000
 price_20
 price_usd2995000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms5
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://545cataloniaavenue.thepartnerstrust.com/
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1955
 virtual_tour
 video_tourhttp://www.onvedeo.com/properties/755499/embed
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num16112996
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style33
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude34.047157
 longitude34.047157
 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)
 modified2024-10-24 08:39:37
 created2016-04-18 09:57:58
 uri/property-detail/3741/545-catalonia-avenue-pacific-palisades-ca-90272-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3741/545-catalonia-avenue-pacific-palisades-ca-90272-usa
 address_concat545 Catalonia Avenue Pacific Palisades CA 90272 USA
 google_maps_query_string545+Catalonia+Avenue++Pacific+Palisades+CA+90272+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,995,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty5
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2016-04-18
 overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 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)
 id20971
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_LoRes_(1_of_33).jpg.jpg
 typeimage/jpeg
 size449059
 uri/assets/20971.jpg
 order0
 created2016-04-18 09:57:16
 modified2024-10-24 08:39:26
 1(array)
 id20968
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_HiRes_(6_of_33).jpg.jpg
 typeimage/jpeg
 size273879
 uri/assets/20968.jpg
 order1
 created2016-04-18 09:57:16
 modified2024-10-24 08:39:26
 2(array)
 id20970
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_LoRes_(5_of_33).jpg.jpg
 typeimage/jpeg
 size360705
 uri/assets/20970.jpg
 order2
 created2016-04-18 09:57:16
 modified2024-10-24 08:39:26
 3(array)
 id20964
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_HiRes_(11_of_33).jpg.jpg
 typeimage/jpeg
 size210712
 uri/assets/20964.jpg
 order3
 created2016-04-18 09:57:15
 modified2024-10-24 08:39:26
 4(array)
 id20963
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_HiRes_(22_of_33).jpg.jpg
 typeimage/jpeg
 size155986
 uri/assets/20963.jpg
 order4
 created2016-04-18 09:57:15
 modified2024-10-24 08:39:26
 5(array)
 id20966
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_HiRes_(16_of_33).jpg.jpg
 typeimage/jpeg
 size310096
 uri/assets/20966.jpg
 order5
 created2016-04-18 09:57:15
 modified2024-10-24 08:39:26
 6(array)
 id20965
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_HiRes_(13_of_33).jpg.jpg
 typeimage/jpeg
 size291598
 uri/assets/20965.jpg
 order6
 created2016-04-18 09:57:15
 modified2024-10-24 08:39:26
 7(array)
 id20969
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_HiRes_(18_of_33).jpg.jpg
 typeimage/jpeg
 size255914
 uri/assets/20969.jpg
 order7
 created2016-04-18 09:57:16
 modified2024-10-24 08:39:26
 8(array)
 id20967
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_HiRes_(3_of_33).jpg.jpg
 typeimage/jpeg
 size301571
 uri/assets/20967.jpg
 order8
 created2016-04-18 09:57:16
 modified2024-10-24 08:39:26
 9(array)
 id20972
 modelProperty
 model_id3741
 tagImage
 name545Catalonia_LoRes_(30_of_33).jpg.jpg
 typeimage/jpeg
 size493336
 uri/assets/20972.jpg
 order9
 created2016-04-18 09:57:16
 modified2024-10-24 08:39:26
 User(array)
 0(array)
 id1173
 typeAgent
 brokerage_id3
 email[email protected]
 passwordba579c44380627d37c115b910cd6401d0a7a4a71
 recover_hash
 first_nameRichard
 last_nameStearns
 title
 dre_num
 phone310.850.9284
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:56
 created2017-08-07 15:23:56
 notified(false)
 full_nameRichard Stearns
 uri/agent-detail/1173/richard-stearns
 profile_complete(true)
 UsersProperty(array)
 id1130
 user_id1173
 property_id3741
 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)
 id4753
 property_id3741
 property_feature_id14
 1(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id4752
 property_id3741
 property_feature_id12
 Topic(array)
 0(array)
 id12
 nameModern Architecture
 created2016-02-25 11:25:00
 modified2016-02-25 11:33:26
 tile_nameModern Architecture
 PropertiesTopic(array)
 id58
 property_id3741
 topic_id12
 1(array)
 id4
 nameKiller Views
 created2016-02-25 11:25:00
 modified2016-02-25 11:33:10
 tile_nameKiller Views
 PropertiesTopic(array)
 id57
 property_id3741
 topic_id4
 3(array)
 Property(array)
 id3733
 brokerage_id5
 created_by_user_id0
 order6
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameClassic, Detailed Colonial With Endless Possibilities
 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 classic shingled Colonial located close to Valentine School in San Marino abounds in character and fine workmanship. The classic formal entry is flanked by an elegant living room with fireplace and the formal dining room. The kitchen is adjoined by a cozy paneled breakfast room. There is one bedroom and bath downstairs and 3 bedrooms upstairs. The master suite opens with french doors to a gracious deck. Details include exquisite moldings and paneling, wainscoting and many french doors. The large lot has mature trees, a 3 car garage and endless possibilities.
 address1795 Warwick Road
 address_2
 citySan Marino
 stateCA
 postal_code91108
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2198000
 price_20
 price_usd2198000
 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
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet2321
 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://1795warwickroad.thepartnerstrust.com/
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1936
 virtual_tour
 video_tourhttp://www.onvedeo.com/properties/762172/embed
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num316003233
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style10
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude34.115185
 longitude-118.118011
 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:52
 uri/property-detail/3733/1795-warwick-road-san-marino-ca-91108-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3733/1795-warwick-road-san-marino-ca-91108-usa
 address_concat1795 Warwick Road San Marino CA 91108 USA
 google_maps_query_string1795+Warwick+Road++San+Marino+CA+91108+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,198,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty3
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-04-15
 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)
 id5
 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
 WOEID2468964
 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
 usernamePartnersTrustPas
 password5b28522e46f56278664573d82c2b0f03520519d0
 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 Pasadena and La Cañada Flintridge, California, USA. At Partners Trust, we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market, presenting our clients with the most professional, successful and ethical real estate associates in the business. We represent our clients with care, confidentiality and the utmost attention to service. Pasadena is a harmonious blend of past and present. Experience the nationally-televised Rose Parade, catch an exciting football game at the Rose Bowl, get smart at Caltech, or revel in the Jet Propulsion Laboratory. The community is renowned for its charming and diverse neighborhoods whose residents honor and preserve the splendor of early California architecture. Opportunities abound to experience Pasadena’s sophisticated culture with the diversified entertainment at the Pasadena Playhouse, the Norton Simon Museum, the Huntington Library and Botanical Gardens and even by walking along the vibrant, historic district of Colorado Boulevard. Partners Trust associates are proud to represent a wide variety of historic and architecturally diverse homes, including the Craftsman-style home. We understand our clients discerning needs, and provide a high level of service and local area knowledge. 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/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/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>
 communitiesPasadena La Canada Flintridge San Marino La Canada Flintridge
 websitehttp://www.thepartnerstrust.com
 address594 E. Colorado Boulevard
 address_2
 cityPasadena
 stateCA
 full_stateCalifornia
 countryUSA
 marketPasadena
 market_2
 postal_code91101
 phone(626) 696-4802
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameScott Brown
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-scott-brown-managing-director-partners-trust-pasadena/
 contact_big_profile_link_text
 contact_titleManaging Director
 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_2Nick Segal
 contact_profile_link_2http://www.leveragere.com/brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2President/Co-Founder
 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_filename5.jpg
 logo_filename5.png
 contact_image_filename5.jpg
 all_properties_link_image_filename5.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_titlePasadena Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
 meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Pasadena, CA is a premier boutique Pasadena real estate brokerage and the exclusive Pasadena representative for Leverage Global Partners.
 meta_keywordspartners trust, partners trust real estate, pasadena real estate, leverage global partners, pasadena homes for sale, scott brown
 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-03-18 16:08:06
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/5/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortwww.thepartnerstrust.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)
 id20874
 modelProperty
 model_id3733
 tagImage
 name1.jpg
 typeimage/jpeg
 size11605128
 uri/assets/20874.jpg
 order0
 created2016-04-15 16:16:05
 modified2016-04-15 16:24:47
 1(array)
 id20870
 modelProperty
 model_id3733
 tagImage
 name5.jpg
 typeimage/jpeg
 size5791865
 uri/assets/20870.jpg
 order1
 created2016-04-15 16:15:59
 modified2016-04-15 16:24:47
 2(array)
 id20868
 modelProperty
 model_id3733
 tagImage
 name10.jpg
 typeimage/jpeg
 size5088423
 uri/assets/20868.jpg
 order2
 created2016-04-15 16:15:57
 modified2016-04-15 16:24:47
 3(array)
 id20867
 modelProperty
 model_id3733
 tagImage
 name8.jpg
 typeimage/jpeg
 size4967444
 uri/assets/20867.jpg
 order3
 created2016-04-15 16:15:56
 modified2016-04-15 16:24:47
 4(array)
 id20869
 modelProperty
 model_id3733
 tagImage
 name12.jpg
 typeimage/jpeg
 size4731499
 uri/assets/20869.jpg
 order4
 created2016-04-15 16:15:58
 modified2016-04-15 16:24:47
 5(array)
 id20865
 modelProperty
 model_id3733
 tagImage
 name16.jpg
 typeimage/jpeg
 size3907702
 uri/assets/20865.jpg
 order5
 created2016-04-15 16:15:54
 modified2016-04-15 16:24:47
 6(array)
 id20866
 modelProperty
 model_id3733
 tagImage
 name22.jpg
 typeimage/jpeg
 size3946374
 uri/assets/20866.jpg
 order6
 created2016-04-15 16:15:55
 modified2016-04-15 16:24:47
 7(array)
 id20873
 modelProperty
 model_id3733
 tagImage
 name15.jpg
 typeimage/jpeg
 size6695297
 uri/assets/20873.jpg
 order7
 created2016-04-15 16:16:03
 modified2016-04-15 16:24:47
 8(array)
 id20871
 modelProperty
 model_id3733
 tagImage
 name28.jpg
 typeimage/jpeg
 size6515193
 uri/assets/20871.jpg
 order8
 created2016-04-15 16:16:00
 modified2016-04-15 16:24:47
 9(array)
 id20872
 modelProperty
 model_id3733
 tagImage
 name26.jpg
 typeimage/jpeg
 size7551017
 uri/assets/20872.jpg
 order9
 created2016-04-15 16:16:02
 modified2016-04-15 16:24:47
 User(array)
 0(array)
 id940
 typeAgent
 brokerage_id5
 email[email protected]
 passwordcb48b7281adb1166af7c1c68a117a685c757de42
 recover_hash
 first_nameFran
 last_nameBenuska
 title
 dre_num
 phone626.253.0029
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:45
 created2017-08-07 15:23:45
 notified(false)
 full_nameFran Benuska
 uri/agent-detail/940/fran-benuska
 profile_complete(true)
 UsersProperty(array)
 id702
 user_id940
 property_id3733
 sort_order0
 1(array)
 id941
 typeAgent
 brokerage_id5
 email[email protected]
 passwordabc682447210f48fc403bf8f71bbb0b2b3a0e6a1
 recover_hash
 first_nameLeann
 last_nameHealy
 title
 dre_num
 phone626.696.4770
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:45
 created2017-08-07 15:23:45
 notified(false)
 full_nameLeann Healy
 uri/agent-detail/941/leann-healy
 profile_complete(true)
 UsersProperty(array)
 id704
 user_id941
 property_id3733
 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)
 id4400
 property_id3733
 property_feature_id4
 Topic(empty)
- sidebar_brokerages(array)
 0(array)
 Brokerage(array)
 id138
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2450022
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameTurnberry International Realty
 broker_of_record_name
 short_nameTurnberry International Realty
 usernameTurnberryInternationalRealty
 passworde1eb47a424b568eef641b057438522f0c3a18c60
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionTurnberry International Realty is the exclusive representative for Leverage Global Partners in Miami - North, Aventura, Bal Harbour, South Beach, Fisher Island, Sunny Isles, Hollywood, Indian Creek, Miami Beach, Star Island, Golden Beach, and Hallandale Beach, Florida, USA. Turnberry International Realty is a premier boutique Real Estate company specializing in the South Florida area. At Turnberry International Realty we strive for excellence in all aspects of our business. Staying informed of the evolving real estate market allows our sales associates to provide outstanding service to each and every client. With offices in two locations including Aventura and Bay Harbor Islands, our agents specialize in properties throughout the South Florida region. The Turnberry International Realty kiosk, located in the Aventura Mall, offers a unique marketing opportunity to all of our clients, exposing our listings to millions of potential buyers who visit the Aventura Mall each year. The Turnberry name is associated with luxury real estate throughout the world and we are dedicated to maintaining its ongoing reputation for excellence.
 communitiesMiami Aventura Bal Harbour South Beach Fisher Island Sunny Isles Hollywood Indian Creek Miami Beach Star Island Golden Beach Hallandale Beach
 websitehttp://www.turnberryrealty.com/
 address20445 Biscayne Blvd
 address_2Suite #8
 cityAventura
 stateFL
 full_stateFlorida
 countryUSA
 marketMiami - North
 market_2
 postal_code
 phone(305) 935-0300
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameSeth Kaufman
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBroker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename138.jpg
 logo_filename138.jpg
 contact_image_filename138.jpg
 all_properties_link_image_filename138.JPG
 all_properties_linkhttp://www.turnberryrealty.com/exclusive-listings.html
 video_embed_code
 contact_video_embed_code
 meta_titleMiami - North Real Estate | Turnberry International Realty | Leverage Global Partners
 meta_descriptionTurnberry International Realty is the exclusive representative for Leverage Global Partners in Miami - North, Florida, USA.
 meta_keywordsTurnberry International Realty, Miami Real Estate, Seth Kaufman, Miami Real Estate, Aventura Real Estate, Bal Harbour Real Estate, South Beach Real Estate, Fisher Island Real Estate, Sunny Isles Real Estate, Hollywood Real Estate, Indian Creek Real Estate, Miami Beach Real Estate, Star Island Real Estate, Golden Beach Real Estate,Hallandale Beach Real Estate, Florida, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-07-01 11:14:16
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/138/turnberry-international-realty
 website_shortwww.turnberryrealty.com
 name_with_locationTurnberry International Realty
 Logo(array)
 id2467
 modelBrokerage
 model_id138
 tagLogo
 name138.jpg
 typeimage/jpg
 size132715
 uri/assets/2467.jpg
 order0
 created2016-03-30 11:39:55
 modified2016-03-30 11:39:55
 1(array)
 Brokerage(array)
 id85
 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_id15
 WOEID2345088
 timezoneUS/Central
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePlantación Properties
 broker_of_record_name
 short_namePlantación Properties
 usernamePlantacionProperties
 password627b03b998ea7a1eb8df187fba6f4890eef328be
 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
 descriptionPlantación Properties is the exclusive representative for Leverage Global Partners in Costa Rica, to include San Jose, Playa Flamingo, Tamarindo, Mal Pais, Santa Teresa, Arenal, Heradura, Manuel Antonio, Osa, Jaco, and Arenal. Plantación Properties, offers to buyers and sellers access to an amplified market of luxury properties in Costa Rica, such as beach front, ocean view, mountain view, estates, land parcels, luxury city homes and condominiums. Through Plantación Properties, buyers and sellers of distinctive levels of quality have access to the amplified marketing efforts of our over 25 years of professional service to the discerning international real estate market. The combined marketing efforts of Plantación Properties and its global partners will provide far reaching exposure to a qualified audience of homeowners and homebuyers for exclusive properties in Costa Rica and beyond.
 communitiesPlaya Flamingo San Jose Flamingo Tamarindo Mal Pais Santa Teresa Arenal Heradura Manuel Antonio Osa Jaco Guanacaste
 websitehttp://www.plantacionpropertiescr.com/
 addressSan Jose
 address_2
 cityCosta Rica
 state
 full_state
 countryCosta Rica
 marketSan Jose
 market_2
 postal_code
 phoneOffice: 1 (506) 2654-4004
 phone_2Toll Free: 1 (877) 661-2060
 phone_3
 wide_contact_image(false)
 contact_nameRobert Davey
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-robert-davey-plantacion-properties/
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quoteI invite you to contact me personally about Costa Rica Real Estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename85.jpg
 logo_filename85.png
 contact_image_filename85.JPG
 all_properties_link_image_filename85.jpg
 all_properties_linkhttp://www.plantacionpropertiescr.com/
 video_embed_code
 contact_video_embed_code
 meta_titleCosta Rica Real Estate | Plantación Properties | Leverage Global Partners
 meta_descriptionPlantación Properties is the exclusive representative for Leverage Global Partners in Costa Rica.
 meta_keywordsPlantación Properties, Leverage Global Partners, Robert Davey, Playa Flamingo Real Estate, San Jose Real Estate, Flamingo Real Estate, Tamarindo Real Estate, Mal Pais Real Estate, Santa Teresa Real Estate, Arenal Real Estate, Heradura Real Estate, Manuel Antonio Real Estate, Osa Real Estate, Jaco Real Estate, Guanacaste Real Estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-01-22 11:37:46
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/85/plantaci-n-properties
 website_shortwww.plantacionpropertiescr.com
 name_with_locationPlantación Properties
 Logo(array)
 id2494
 modelBrokerage
 model_id85
 tagLogo
 name85.png
 typeimage/png
 size65832
 uri/assets/2494.png
 order0
 created2016-03-30 11:40:19
 modified2016-03-30 11:40:19
 2(array)
 Brokerage(array)
 id56
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2513768
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameJ. Rockcliff Realtors
 broker_of_record_name
 short_nameJ Rockcliff Realtors
 usernameJRockcliffWC
 password14a01d92dcd7b0cd5ad6f01dca84a3e626414a24
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionJ. Rockcliff Realtors is the exclusive representative for Leverage Global Partners in Walnut Creek, Concord, Pleasant Hill, Martinez, Alamo, Diablo and Clayton, California. J. Rockcliff Realtors is one of the fastest growing real estate companies in California and has distinguished itself as The East Bay’s Premier Real Estate Company. With offices located in <a href="../../../brokerage-detail/55/J.-Rockcliff-Realtors">LaMorinda</a> (Lafayette, Moraga, Orinda), <a href="../../../brokerage-detail/56/J.-Rockcliff-Realtors">Walnut Creek</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Danville</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Blackhawk</a>, and <a href="../../../brokerage-detail/57/J.-Rockcliff-Realtors">Pleasanton/Dublin/Livermore</a>, experienced Realtors can assist with your home buying or home selling needs in any real estate market. Looking for bank owned properties? We can help. J. Rockcliff Realtors’ Relocation Department provides home buying or home selling assistance around the corner or around the world. As members of Worldwide ERC (Employee Relocation Council), J. Rockcliff handles many corporate relocation moves as well. When listing or selling your home, you can rest assured that J. Rockcliff Realtors can provide the best real estate agents (Realtors) to help you buy or sell your home using the most innovative tools available, including; the finest marketing, the most advanced technology and resources unmatched by any other firm. J. Rockcliff Realtors is strategically positioned to be the company of choice now and in the future. J. Rockcliff Realtors is proudly licensed with the California Bureau of Real Estate - License #01793729. J.Rockcliff also has offices in <a href="../../../brokerage-detail/55/J.-Rockcliff-Realtors">Lafayette</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Danville</a>, and <a href="../../../brokerage-detail/57/J.-Rockcliff-Realtors">Pleasanton</a>.
 communitiesWalnut Creek Concord Pleasant Hill Martinez Clayton Alamo Diablo
 websitehttp://www.rockcliff.com/
 address1700 N. Main Street
 address_2
 cityWalnut Creek
 stateCA
 full_stateCalifornia
 countryUSA
 marketWalnut Creek
 market_2
 postal_code94596
 phone(925) 280-8500
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJeff Sposito
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename56.jpg
 logo_filename56.jpg
 contact_image_filename56.jpg
 all_properties_link_image_filename56.jpg
 all_properties_linkhttp://www.rockcliff.com/Rockcliff-Listings#g=2a4505b8-af60-49e2-b0c4-b980136a5da0
 video_embed_code
 contact_video_embed_code
 meta_titleWalnut Creek Real Estate | J. Rockcliff Realtors | Leverage Global Partners
 meta_descriptionJ. Rockcliff Realtors is the exclusive representative for Leverage Global Partners in Walnut Creek, CA, USA.
 meta_keywordsJ. Rockcliff Realtors, Walnut Creek Real Estate, Leverage Global Partners, Jeff Sposito
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-09-26 14:52:34
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/56/j-rockcliff-realtors
 website_shortwww.rockcliff.com
 name_with_locationJ. Rockcliff Realtors
 Logo(array)
 id2398
 modelBrokerage
 model_id56
 tagLogo
 name56.jpg
 typeimage/jpg
 size659806
 uri/assets/2398.jpg
 order0
 created2016-03-30 11:39:04
 modified2016-03-30 11:39:04
 3(array)
 Brokerage(array)
 id232
 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(true)
 country_id0
 WOEID2449435
 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
 nameKerwin & Associates
 broker_of_record_name
 short_nameKerwin & Associates
 usernamekerwinassociates
 passwordfdfee2c837ca0afd3f1b1218abc68713af252711
 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
 descriptionKerwin & Associates is the exclusive representative for Leverage Global Partners in Atherton, Palo Alto, Menlo Park, and Woodside, CA, USA. Kerwin & Associates, Silicon Valley The most celebrated properties in Silicon Valley’s prestige neighborhoods—Atherton, Woodside, Menlo Park, Palo Alto—rarely get listed. In fact, more than 35% of our transactions are private, off-market sales. This area is unique, and its elite roster of buyers and sellers value discretion, integrity and privacy. So that is what we provide. Kerwin & Associates is the preferred agent among Silicon Valley’s demanding executive residents for many reasons: highly customized and personal service, a vast support network, meticulous attention to detail, fierce negotiation and, of course, an encyclopedic knowledge of every neighborhood, street and address we serve. If you want to know about the finest properties in Silicon Valley’s best neighborhoods, don’t bother with listings. Just call us. Terri Kerwin Terri was recently named one of Wall Street Journal’s Top Realtors Nationwide. Although she comes from a distinguished real estate lineage, she did not begin her career as an agent. Instead, she started with the renowned Xerox sales training program. Since then, she has emerged as a leader in the local market and the preferred broker for Silicon Valley’s most-demanding clientele. She has also built 10 custom homes from the ground up, cementing her expertise in determining high-end property value and investment potential. When she isn’t helping clients find their dream homes and estates, she loves having family and friends over to spend time in the backyard overlooking the natural beauty that Portola Valley offers.
 communitiesAtherton Palo Alto Menlo Park Woodside
 websitehttp://www.kerwinassociates.com/
 address201 El Camino Real
 address_2
 cityMenlo Park
 stateCA
 full_stateCalifornia
 countryUSA
 marketAtherton
 market_2
 postal_code94025
 phone(650) 473-1500
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTerri Kerwin
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename232.jpg
 logo_filename232.jpg
 contact_image_filename232.jpg
 all_properties_link_image_filename232.jpg
 all_properties_linkhttp://www.kerwinassociates.com/Our-Featured-Listings
 video_embed_code
 contact_video_embed_code
 meta_titleAtherton Real Estate | Kerwin & Associates | Leverage Global Partners
 meta_descriptionKerwin & Associates is the exclusive representative for Leverage Global Partners in Atherton, Palo Alto, Menlo Park, Woodside, Redwood City, and San Carlos, CA, USA.
 meta_keywordsKerwin & Associates, Leverage Global Partners, Atherton real estate, Palo Alto real estate, Menlo Park real estate, Woodside real estate, Redwood City real estate, San Carlos real estate, California real estate, Silicon valley
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-10-26 16:05:26
 modified2016-04-18 11:56:15
 dre_num012345
 uri/brokerage-detail/232/kerwin-associates
 website_shortwww.kerwinassociates.com
 name_with_locationKerwin & Associates
 Logo(array)
 id2908
 modelBrokerage
 model_id232
 tagLogo
 name232.jpg
 typeimage/jpg
 size35751
 uri/assets/2908.jpg
 order0
 created2016-03-30 11:45:30
 modified2016-04-18 11:56:15
- sidebar_locations(array)
 0(array)
 Location(array)
 id25
 parent_id7
 brokerage_id206
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameSaddle River, NJ, USA
 short_nameSaddle River, NJ, USA
 group_index
 latitude41.041969
 longitude-74.094627
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionServicing Northern New Jersey directly outside of New York City.
 long_descriptionKnown as the Beverly Hills of Northern New Jersey, Saddle River, Alpine, Franklin Lakes, Upper Saddle River, Mahwah, and Ridgewood are known for their beauty, estate properties and architectural masterpieces. Numerous celebrities, athletes, entrepreneurs, CEO's and politicians live throughout this sought after area which is right outside of New York City. Wonderful shopping, schools, sports facilities and top city level restaurants all throughout the entire area.
 created2016-04-04 11:23:53
 modified2016-04-04 11:23:53
 timezoneAmerica/New_York
 population150000
 uri/locations/view/25/saddle-river-nj-usa
 tile_nameSaddle River, NJ, USA
 Brokerage(array)
 id206
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2486435
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameSpecial Properties
 broker_of_record_name
 short_nameSpecial Properties
 usernameSpecialProperties
 password80bff9ecdfafd4cb525f795d439c9f6d73b691dd
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionSpecial Properties is the exclusive representative for Leverage Global Partners in Allendale, Alpine, Cliffside Park, Cresskill, Demarest, Edgewater, Englewood, Englewood Cliffs, Fort Lee, Franklin Lakes, Ho Ho Kus, Mahwah, Oakland, Old Tappan, Ramsey, Ridgewood, Saddle River, Tenafly, Upper Saddle River, Woodcliff Lake, Wyckoff, NJ USA. Special Properties, Division of Brook Hollow Group, Inc. Realtors is a Real Estate brokerage firm located in Saddle River, NJ, serving New Jersey and New York. Established in 1992, we specialize in the marketing and selling of luxury properties. We market at the highest level and offer a full range of real estate services. Our Realtor Associates and our staff are highly experienced and operate at an unparalleled level. We are pleased to announce the opening of 2 new offices in Mahwah and Franklin Lakes, New Jersey. Please contact us to find out more information regarding Special Properties Real Estate Services, LLC. Our exclusive affiliation with Christie’s International Real Estate for Northwest Bergen County offers us the ability to relocate our clients anywhere in the world at the same high standard they expect in doing business with us. Our newest affiliation with Leverage Global Partners is adding to our network of affiliates who have the same high level of marketing and service standards that we do. We are very excited about this new relationship. We have exclusive affiliations with several magazine publications which are national as well as New York City/Metropolitan area based. Contact us for additional information about our extensive marketing program, our exclusive listings as well as all multiple listed properties on our website.
 communitiesSaddle River Bergen County Allendale Alpine Cliffside Park Cresskill Demarest Edgewater Englewood Englewood Cliffs Fort Lee Franklin Lakes Ho Ho Kus Mahwah Oakland Old Tappan Ramsey Ridgewood Saddle River Tenafly Upper Saddle River Woodcliff Lake Wyckoff
 websitehttp://www.specialproperties.com/
 address158 West Saddle River Road
 address_2
 citySaddle River
 stateNJ
 full_stateNew Jersey
 countryUSA
 market
 market_2
 postal_code07458
 phoneOffice: (201) 934-7111
 phone_2Cell: (201) 390-5880
 phone_3
 wide_contact_image(false)
 contact_nameVicki Gaily
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCo Owner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename206.jpg
 logo_filename206.jpg
 contact_image_filename206.jpg
 all_properties_link_image_filename206.jpg
 all_properties_linkhttp://www.specialproperties.com/sales/usa/broker-listings-dstype
 video_embed_code
 contact_video_embed_code
 meta_titleSaddle River Real Estate | Special Properties | Leverage Global Partners
 meta_descriptionSpecial Properties is the exclusive representative for Leverage Global Partners in Saddle River including all of Bergen County, NJ USA.
 meta_keywordsSpecial Properties, Saddle River real estate, Bergen County real estate, North Jersey real estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-06-18 09:41:48
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/206/special-properties
 website_shortwww.specialproperties.com
 name_with_locationSpecial Properties
 Image(array)
 id2952
 modelLocation
 model_id25
 tagImage
 namespecial props.jpg
 typeimage/jpeg
 size163035
 uri/assets/2952.jpg
 order0
 created2016-04-04 11:23:27
 modified2016-04-04 11:23:53
 1(array)
 Location(array)
 id70
 parent_id8
 brokerage_id202
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameAtlanta, GA, USA
 short_nameAtlanta, GA, USA
 group_index
 latitude33.748997
 longitude-84.387985
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 17:43:26
 modified2016-04-04 17:43:26
 timezoneAmerica/New_York
 population450000
 uri/locations/view/70/atlanta-ga-usa
 tile_nameAtlanta, GA, USA
 Brokerage(array)
 id202
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2357024
 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
 nameAtlanta Intown Real Estate
 broker_of_record_name
 short_nameAtlanta Intown Real Estate
 usernameAtlantaInTown
 password510e50329239d9df109adba3bf3f25d55858485c
 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
 descriptionAtlanta Intown Real Estate is the exclusive representative for Leverage Global Partners in Dekalb and Fulton County including Atlanta, Brookhaven, Decatur, Sandy Springs, John's Creek, Belvedere Park, Redan, Lithonia, Tucker, Chamblee, Clarkston, Druid Hills, Panthersville, Stone Mountain, Candler, McAfee, College Park, Union City, Fairburn, Palmetto, GA, USA. Atlanta Intown Real Estate Services was founded in 1996 as one of Atlanta’s premier boutique real estate firms. Atlanta Intown provides the full scope of brokerage services. Their agents have in-depth knowledge of neighborhoods throughout the entire metropolitan area. Through vigorous networking and active participation in the communities they serve, they are tapped in to the pulse of the city’s diverse residential real estate market. What truly sets Atlanta Intown apart is their personal approach. They maintain a strong one-on-one relationship with each client. Their knowledge, professionalism and integrity are entirely focused on putting the client first. They have earned a well deserved reputation, even among the most discriminating clients, for ensuring a positive, well managed real estate experience and delivering fast, sure results.
 communitiesDekalb County Fulton County Atlanta Brookhaven Decatur Sandy Springs John's Creek Belvedere Park Redan Lithonia Tucker Chamblee Clarkston Druid Hills Panthersville Stone Mountain Candler McAfee College Park Union City Fairburn Palmetto
 websitehttp://www.atlantaintown.com/
 address181 10th St. NE
 address_2
 cityAtlanta
 stateGA
 full_stateGeorgia
 countryUSA
 market
 market_2
 postal_code30309
 phone(404) 881-1810
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameRandal Lautzenheiser
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleManaging Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename202.jpg
 logo_filename202.JPG
 contact_image_filename202.jpg
 all_properties_link_image_filename202.jpg
 all_properties_linkhttp://www.atlantaintown.com/featured
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/elOpQJlw-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleAtlanta Real Estate | Atlanta Intown Real Estate | Leverage Global Partners
 meta_descriptionAtlanta Intown Real Estate is the exclusive representative for Leverage Global Partners in Dekalb and Fulton County including Atlanta, Brookhaven, Decatur, Sandy Springs, John's Creek, Belvedere Park, Redan, Lithonia, Tucker, Chamblee, Clarkston, Druid Hills, Panthersville, Stone Mountain, Candler, McAfee, College Park, Union City, Fairburn, Palmetto, GA, USA.
 meta_keywordsAtlanta Intown Real Estate, Leverage Global Partners, Dekalb County Real Estate, Fulton County Real Estate, Atlanta Real Estate, Brookhaven Real Estate, Decatur Real Estate, Sandy Springs Real Estate, John's Creek Real Estate, Belvedere Park Real Estate, Redan Real Estate, Lithonia Real Estate, Tucker Real Estate, Chamblee Real Estate, Clarkston Real Estate, Druid Hills Real Estate, Panthersville Real Estate, Stone Mountain Real Estate, Candler Real Estate, McAfee Real Estate, College Park Real Estate, Union City Real Estate, Fairburn Real Estate, Palmetto Real Estate, Georgia Real Estate, Randal Lautzenheiser
 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-04-21 10:47:33
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/202/atlanta-intown-real-estate
 website_shortwww.atlantaintown.com
 name_with_locationAtlanta Intown Real Estate
 Image(array)
 id3002
 modelLocation
 model_id70
 tagImage
 nameAtlanta.jpg
 typeimage/jpeg
 size196216
 uri/assets/3002.jpg
 order0
 created2016-04-04 17:43:12
 modified2016-04-04 17:43:26
 2(array)
 Location(array)
 id62
 parent_id8
 brokerage_id101
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameSavannah, GA, USA
 short_nameSavannah, GA, USA
 group_index
 latitude32.081261
 longitude-81.080986
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionHistoric Homes, Live Oaks draped in Moss, Oceanfront, Marshfront, Savannah has it all!
 long_descriptionSavannah has so much to offer…from the beaches at Tybee Island, the interior islands with miles of marsh and spectacular views of the intracoastal, to the The National Historic Landmark District, the largest National Historic Landmark District in the United States. Its cobblestone streets, manicured gardens and live oak-shaded squares make it one of the most beautiful cities in the world! It is a very walkable city, thanks to the urban plan laid by General Oglethorpe - you can even take your cocktails to go as you stroll through the neighborhood and visit the shops, cafes, art galleries and museums! You will find a good mix of historic homes in need of a little TLC, fully restored homes and new construction in the in the form of town homes and condominiums.
 created2016-04-04 16:41:48
 modified2016-04-04 16:41:48
 timezoneAmerica/New_York
 population375000
 uri/locations/view/62/savannah-ga-usa
 tile_nameSavannah, GA, USA
 Brokerage(array)
 id101
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2489314
 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
 nameThree Oaks Realty Co.
 broker_of_record_name
 short_nameThree Oaks Realty Co.
 usernameThreeOaksRealty
 password2e25ea6416fb35cb0184a531b476e7a8d1233cf9
 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
 descriptionThree Oaks Realty Co. is the exclusive representative for Leverage Global Partners in Historic Savannah, Tybee Island, Wilmington Island, Whitemarsh Island, Isle of Hope, Skidaway Island, Pooler, Rincon, Richmond Hill, Garden City, Hutchinson Island and Savannah, Georgia, USA. We founded Three Oaks Realty Company on the idea that you should love what you do, do it better than anyone else, and attract others that appreciate those two principles. Our company culture is not only extraordinarily customer centric, but it is built on a foundation of mutual respect for one another, our colleagues and vendors. This bond transcends everything we do. We’re also really fun people, so if you’re ever in the neighborhood- stop by and say hi. Why Three Oaks? At Three Oaks Realty, we have a vast amount of experience selling Savannah and the Low Country. We decided to start our company because we believe in a different approach to real estate, and we are eager to share our experience and our approach with you. We believe that you should be the center of everything we do. Not a fancy brand or a complex process. Life is busy, we get that, and our goal is to make your transaction smooth, efficient, satisfying and above all, enjoyable. We chose our name, Three Oaks Realty Company, not only because the oak tree stands as one of our area’s most distinctive landmarks, but because its unique stature embodies everything we love about living and working in the low country. The enchanting, understated, natural beauty captures the unique allure that makes Savannah the perfect place to call home. Part of what makes our Southern Live Oak trees so iconic is the presence of Spanish moss- a bit like a natural partnership. We believe that real estate should embody this same principal. It should be collaborative- between realtors, clients, vendors and community partners. When all of these things are working together- it has the power to turn real estate dreams into reality. No two oaks are the same, but they are unified in their strong roots and the foundation from which they grow. That mirrors how we feel about our partnership at Three Oaks Realty Company. We all bring different perspectives and different strengths to the table, but we have the same core beliefs. It’s these beliefs that represent the roots of this company and everything we do. Simply, love what you do, and do it better than anyone else.
 communitiesSkidaway Island Isle of Hope Tybee Island Pooler, Rincon Richmond Hill Garden City Whitemarsh Island Wilmington Island Hutchinson Island Historic district Historic Savannah
 websitehttp://www.threeoaksrealtycompany.com/
 address509 Barnard Street
 address_2
 citySavannah
 stateGA
 full_stateGeorgia
 countryUSA
 marketSavannah
 market_2
 postal_code
 phoneOffice: (912) 777-4560
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameCliff Murse, Stephanie Wilson-Evans, Tommy Reese
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePartners
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Savannah real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3[email protected]
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename101.jpg
 logo_filename101.jpeg
 contact_image_filename101.jpeg
 all_properties_link_image_filename101.jpg
 all_properties_linkhttp://www.threeoaksrealtycompany.com/category/featured-property/
 video_embed_code
 contact_video_embed_code
 meta_titleSavannah Real Estate | Three Oaks Realty Co. | Leverage Global Partners
 meta_descriptionThree Oaks Realty Co. is the exclusive representative for Leverage Global Partners in Savannah, Georgia, USA.
 meta_keywordsSavannah Real Estate, Three Oaks Realty Co., Leverage Global Partners, Cliff Murse, Historic District, Historic Savannah
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-02-27 16:38:01
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/101/three-oaks-realty-co
 website_shortwww.threeoaksrealtycompany.com
 name_with_locationThree Oaks Realty Co.
 Image(array)
 id2994
 modelLocation
 model_id62
 tagImage
 name39922990_savannah_ga.jpg
 typeimage/jpeg
 size5427412
 uri/assets/2994.jpg
 order0
 created2016-04-04 16:38:34
 modified2016-04-04 16:41:48
 3(array)
 Location(array)
 id43
 parent_id7
 brokerage_id208
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameRhinebeck, NY, USA
 short_nameRhinebeck, NY, USA
 group_index
 latitude41.931828
 longitude-73.907440
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 12:41:59
 modified2016-04-04 12:41:59
 timezoneAmerica/New_York
 population7500
 uri/locations/view/43/rhinebeck-ny-usa
 tile_nameRhinebeck, NY, USA
 Brokerage(array)
 id208
 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_properties-1
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2480530
 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
 namePaula Redmond Real Estate, Inc.
 broker_of_record_name
 short_namePaula Redmond Real Estate, Inc.
 usernamePaulaRedmondRealEstate
 password29a89eac6d0f50da87d07a0b203bce849a95b865
 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
 descriptionPaula Redmond Real Estate, Inc. is the exclusive representative for Leverage Global Partners in Rhinebeck, Millbrook, Hudson, Poughkeepsie, Hyde Park, Pine Planes, Red Hook, Amenia, Copake, Copake Lake, Gallatin, Livingston, NY, USA. A Decade of Success In just over 10 years we have taken a commanding position in Dutchess County real estate sales; an extraordinary position for our independently owned and operated team of 12 full-time REALTORS®. Without the bureaucracy required in corporate owned or franchised brokerages, we are able to provide a more personal experience while you carry out one of the larger financial transactions of your life. We offer superior local knowledge, comprehensive yet personal service and marketing expertise unmatched in the area. Our success is also based on unwavering principle of ethical conduct, professional behavior and personal service. Our experience in buying and selling properties, our reputation, and our performance have brought us success and a long list of satisfied clients. Mid-Hudson Valley Specialists Paula Redmond has been in the real estate business since 1984. She established Paula Redmond Real Estate in 2003. Conveniently based in both Millbrook and Rhinebeck, we sell properties throughout the Mid-Hudson Valley Region in New York State. We are members of 3 multiple listing services: Mid Hudson, Columbia Greene Northern Dutchess and Ulster County. Our relationship with the many other REALTORS® in the area brings added exposure to your property. In today’s electronic world, every virtual visit to your property is really a showing. With our many years of combined experience, our REALTORS® are experts in helping you get your property beautifully presented and ready to be shown. We then make sure that qualified customers are ready and eager to see it.
 communitiesRhinebeck Millbrook Hudson Poughkeepsie Hyde Park Pine Planes Red Hook Amenia Copake Copake Lake Gallatin Livingston
 websitehttp://www.paularedmond.com/index.php
 address10 Front Street
 address_2
 cityMillbrook
 stateNY
 full_stateNew York
 countryUSA
 marketRhinebeck
 market_2
 postal_code12545
 phoneDirect: (845) 677-0505
 phone_2Cell: (914) 456-9154
 phone_3
 wide_contact_image(false)
 contact_namePaula Redmond
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename208.jpg
 logo_filename208.png
 contact_image_filename208.jpeg
 all_properties_link_image_filename208.jpeg
 all_properties_linkhttp://www.paularedmond.com/featured/
 video_embed_code
 contact_video_embed_code
 meta_titleRhinebeck Real Estate | Paula Redmond Real Estate, Inc. | Leverage Global Partners
 meta_descriptionPaula Redmond Real Estate, Inc. is the exclusive representative for Leverage Global Partners in Rhinebeck, NY, USA.
 meta_keywordsPaula Redmond Real Estate, Inc., Rhinebeck Real Estate, Millbrook Real Estate, Hudson Real Estate, Poughkeepsie Real Estate, Hyde Park Real Estate, Pine Planes Real Estate, Red Hook Real Estate, Amenia Real Estate, Copake Real Estate, Copake Lake Real Estate, Gallatin Real Estate, Livingston Real Estate, New York Real Estate, Paula Redmond, 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)
 created2015-06-23 10:34:53
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/208/paula-redmond-real-estate-inc
 website_shortwww.paularedmond.com/index.php
 name_with_locationPaula Redmond Real Estate, Inc.
 Image(array)
 id2971
 modelLocation
 model_id43
 tagImage
 namerhinebeck.jpg
 typeimage/jpeg
 size202109
 uri/assets/2971.jpg
 order0
 created2016-04-04 12:41:53
 modified2016-04-04 12:41:59
- location_properties(empty)
- main_article(empty)
- brokerage(array)
 Brokerage(array)
 id159
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2374635
 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
 nameMiloff Aubuchon Realty Group
 broker_of_record_name
 short_nameMiloff Aubuchon Realty Group
 usernameMiloffAubuchon
 password1710f8a5e4581f9f3b2398bd524ffac0dceb4c84
 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
 descriptionMiloff Aubuchon Realty Group, Inc. is the exclusive representative for Leverage Global Partners in Lee County and Collier County, including: Cape Coral, Bonita Springs, Fort Myers, Naples, and Sanibel, Florida, USA. Miloff Aubuchon Realty Group Gary Aubuchon and Jeff Miloff formed a partnership in 1998 that would later flourish and succeed beyond their expectations. Miloff Aubuchon Realty Group, the real estate division of Team Aubuchon, began in the garage of a model home with four agents and one staff member. Today, the company has grown to over 95 agents, with 4 real estate offices now open in Southwest Florida. Their success is a result of hard work, dedication to excellence in all aspects of business, and a focus on providing above and beyond customer service. Through the years, this company has helped thousands of people invest in real estate, sell their property, and find the home of their dreams. Choosing Miloff Aubuchon Realty Group means you get insight and market knowledge from the best agents in the area who are dedicated to professionalism and working in your best interest. Our team is passionate about improving the community and giving back. We support local organizations such as Ronald McDonald House Charities SWFL, Make-A-Wish Southern Florida, Builders Care, Relay for Life, and Kids With Cancer. We pride ourselves by getting in the game both financially and physically. Our support includes home renovations, volunteering on numerous committees and events, hosting events at our offices, and so much more. Our mission is to help make your vision a reality, and become one of our Raving Fans.
 communitiesCape Coral Bonita Springs Fort Myers Sanibel
 websitehttp://www.miloffaubuchonrealty.com/
 address4707 SE 9th Place
 address_2
 cityCape Coral
 stateFL
 full_stateFlorida
 countryUSA
 marketLee County
 market_2
 postal_code33904
 phone(239) 542-1075
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJeff Miloff
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleVice President
 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_filename159.jpg
 logo_filename159.gif
 contact_image_filename159.jpg
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_titleCape Coral Real Estate | Miloff Aubuchon Realty Group | Leverage Global Partners
 meta_descriptionMiloff Aubuchon Realty Group is the exclusive representative for Leverage Global Partners in Cape Coral, FL, USA.
 meta_keywordsMiloff Aubuchon Realty Group, Cape Coral real estate, Jeff Miloff, Bonita Springs real estate, Fort Myers real estate, and Sanibel 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)
 created2014-09-05 15:04:46
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/159/miloff-aubuchon-realty-group
 website_shortwww.miloffaubuchonrealty.com
 name_with_locationMiloff Aubuchon Realty Group - Cape Coral, FL, USA
 AccountExecutive(array)
 id236
 typeAccountExecutive
 brokerage_id0
 email[email protected]
 passworde5cc5a96287695cf8b7cace1463b1699895dcf92
 recover_hash
 first_nameLauren
 last_namePena
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2020-12-23 09:21:16
 created2016-04-14 15:43:52
 notified(false)
 full_nameLauren Pena
 uri/agent-detail/236/lauren-pena
 profile_complete(true)
 Logo(array)
 id2710
 modelBrokerage
 model_id159
 tagLogo
 name159.gif
 typeimage/gif
 size83648
 uri/assets/2710.gif
 order0
 created2016-03-30 11:43:09
 modified2016-03-30 11:43:09
 MainImage(array)
 id2709
 modelBrokerage
 model_id159
 tagMainImage
 name159.jpg
 typeimage/jpg
 size5691814
 uri/assets/2709.jpg
 order0
 created2016-03-30 11:43:08
 modified2016-03-30 11:43:08
 ContactImage(array)
 id2711
 modelBrokerage
 model_id159
 tagContactImage
 name159.jpg
 typeimage/jpg
 size136636
 uri/assets/2711.jpg
 order0
 created2016-03-30 11:43:09
 modified2016-03-30 11:43:09
 ContactImage2(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 ContactImage3(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 BrokerOfRecordLogo(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 MainArticle(array)
 id(null)
 model(null)
 model_id(null)
 archived(null)
 medium_featured(null)
 large_featured(null)
 title(null)
 author(null)
 date(null)
 lead_in(null)
 body(null)
 vimeo_id(null)
 created(null)
 modified(null)
 FeaturedImage(empty)
 Location(array)
 0(array)
 id177
 parent_id8
 brokerage_id159
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameCape Coral, FL, USA
 short_nameCape Coral, FL, USA
 group_index
 latitude26.562855
 longitude-81.949532
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 19:09:52
 modified2016-04-12 19:12:17
 timezoneAmerica/New_York
 population0
 uri/locations/view/177/cape-coral-fl-usa
 tile_nameCape Coral, FL, USA
 User(array)
 0(array)
 id155
 typeBrokerageAdmin
 brokerage_id159
 email[email protected]
 password1710f8a5e4581f9f3b2398bd524ffac0dceb4c84
 recover_hash
 first_nameJeff
 last_nameMiloff
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2016-04-12 08:29:19
 created2016-04-08 16:34:15
 notified(true)
 full_nameJeff Miloff
 uri/agent-detail/155/jeff-miloff
 profile_complete(true)
 1(array)
 id614
 typeAgent
 brokerage_id159
 email[email protected]
 password9e95774d53c1fb6a01d77dcccfa82748c5efdcc1
 recover_hash
 first_nameJeff
 last_nameMiloff
 title
 dre_num
 phone239.565.0831
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:11
 created2017-08-07 15:23:11
 notified(false)
 full_nameJeff Miloff
 uri/agent-detail/614/jeff-miloff
 profile_complete(true)
 2(array)
 id733
 typeAgent
 brokerage_id159
 email[email protected]
 passworddc9bef1a7de159d94a37fefd18119dde5762f642
 recover_hash
 first_nameJeff
 last_nameMarconi
 title
 dre_num
 phone239.770.3688
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:18
 created2017-08-07 15:23:18
 notified(false)
 full_nameJeff Marconi
 uri/agent-detail/733/jeff-marconi
 profile_complete(true)
 3(array)
 id734
 typeAgent
 brokerage_id159
 email[email protected]
 password042f3e888893a25c0c3a0e7e6b008fa910e1de26
 recover_hash
 first_nameJack
 last_nameMast
 title
 dre_num
 phone239.292.2673
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:18
 created2017-08-07 15:23:18
 notified(false)
 full_nameJack Mast
 uri/agent-detail/734/jack-mast
 profile_complete(true)
 4(array)
 id735
 typeAgent
 brokerage_id159
 email[email protected]
 password5fe69561c3a23f9a88006f5cdb6d3279016a8535
 recover_hash
 first_nameLynn
 last_nameHesselbach
 title
 dre_num
 phone239.985.9092
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:18
 created2017-08-07 15:23:18
 notified(false)
 full_nameLynn Hesselbach
 uri/agent-detail/735/lynn-hesselbach
 profile_complete(true)
 5(array)
 id736
 typeAgent
 brokerage_id159
 email[email protected]
 password43cf5f309621ad04411cb2dd75a00bba9a3befe8
 recover_hash
 first_nameLynn
 last_nameHesselbach
 title
 dre_num
 phone239.985.9092
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:18
 created2017-08-07 15:23:18
 notified(false)
 full_nameLynn Hesselbach
 uri/agent-detail/736/lynn-hesselbach
 profile_complete(true)
 6(array)
 id737
 typeAgent
 brokerage_id159
 email[email protected]
 passwordd40bd147c18bc089646951e3803a7dea7e81a7b0
 recover_hash
 first_namePeggy
 last_nameSenna
 title
 dre_num
 phone239.565.1065
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:18
 created2017-08-07 15:23:18
 notified(false)
 full_namePeggy Senna
 uri/agent-detail/737/peggy-senna
 profile_complete(true)
 7(array)
 id738
 typeAgent
 brokerage_id159
 email[email protected]
 password1a118ff07813ef5d7fa053f1883f94dcfde4e609
 recover_hash
 first_nameVince
 last_nameHonc
 title
 dre_num
 phone239.462.3537
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:18
 created2017-08-07 15:23:18
 notified(false)
 full_nameVince Honc
 uri/agent-detail/738/vince-honc
 profile_complete(true)
 8(array)
 id739
 typeAgent
 brokerage_id159
 email[email protected]
 password281feee0fa9661d3aeafa4c0da8d86044585b532
 recover_hash
 first_nameGerhard
 last_nameJakobeit
 title
 dre_num
 phone239.677.7057
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:18
 created2017-08-07 15:23:18
 notified(false)
 full_nameGerhard Jakobeit
 uri/agent-detail/739/gerhard-jakobeit
 profile_complete(true)
 9(array)
 id753
 typeAgent
 brokerage_id159
 email[email protected]
 password553ee2a5fc01df9f4f316d702b52cf22aa58b6f9
 recover_hash
 first_nameCaprice
 last_nameKrumsick
 title
 dre_num
 phone239.677.7141
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:19
 created2017-08-07 15:23:19
 notified(false)
 full_nameCaprice Krumsick
 uri/agent-detail/753/caprice-krumsick
 profile_complete(true)
 10(array)
 id754
 typeAgent
 brokerage_id159
 email[email protected]
 passwordae4ff7fcb970c9236f8abec72df37c82ac7b1a19
 recover_hash
 first_nameTerry
 last_nameMell
 title
 dre_num
 phone239.823.0442
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:19
 created2017-08-07 15:23:19
 notified(false)
 full_nameTerry Mell
 uri/agent-detail/754/terry-mell
 profile_complete(true)
 11(array)
 id1214
 typeAgent
 brokerage_id159
 email[email protected]
 password82c38cd8634041bd3b381b2731e5607881a83e7d
 recover_hash
 first_nameSandra
 last_nameHuber
 title
 dre_num
 phone813.340.2907
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:59
 created2017-08-07 15:23:59
 notified(false)
 full_nameSandra Huber
 uri/agent-detail/1214/sandra-huber
 profile_complete(true)
 12(array)
 id1215
 typeAgent
 brokerage_id159
 email[email protected]
 password989c680a1738995ee62694fcc2f67047406df7ae
 recover_hash
 first_nameJim
 last_namePeterson
 title
 dre_num
 phone239.470.2353
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:59
 created2017-08-07 15:23:59
 notified(false)
 full_nameJim Peterson
 uri/agent-detail/1215/jim-peterson
 profile_complete(true)
 13(array)
 id1229
 typeAgent
 brokerage_id159
 email[email protected]
 passwordc27b103d27d8a965b1acf1494fb18725792f8420
 recover_hash
 first_nameRon J.
 last_nameEck
 title
 dre_num
 phone239.849.1997
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:59
 created2017-08-07 15:23:59
 notified(false)
 full_nameRon J. Eck
 uri/agent-detail/1229/ron-j-eck
 profile_complete(true)
 14(array)
 id1243
 typeAgent
 brokerage_id159
 email[email protected]
 password1aee52bcf0dfa753fdf254b1c44aa221cf72c68d
 recover_hash
 first_nameMarilyn
 last_nameAdams
 title
 dre_num
 phone609.602.1509
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:24:00
 created2017-08-07 15:24:00
 notified(false)
 full_nameMarilyn Adams
 uri/agent-detail/1243/marilyn-adams
 profile_complete(true)
- location(array)
 Location(array)
 id177
 parent_id8
 brokerage_id159
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameCape Coral, FL, USA
 short_nameCape Coral, FL, USA
 group_index
 latitude26.562855
 longitude-81.949532
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 19:09:52
 modified2016-04-12 19:12:17
 timezoneAmerica/New_York
 population0
 uri/locations/view/177/cape-coral-fl-usa
 tile_nameCape Coral, FL, USA
 Image(array)
 id20753
 modelLocation
 model_id177
 tagImage
 nameScreen Shot 2016-04-12 at 7.11.38 PM.png
 typeimage/png
 size879601
 uri/assets/20753.png
 order0
 created2016-04-12 19:12:08
 modified2016-04-12 19:12:17
- 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/177/cape-coral-fl-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/locations/view/177/cape-coral-fl-usa
Remote Port	19676
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	104.23.197.115
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http Cf Ray	a09df3716d17cf42-CMH
Http Accept Encoding	gzip, br
Http Cookie	CAKEPHP=odoqutkjjqc1angb3m7hvis9ad
Http Accept	/
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
Http X Forwarded For	216.73.216.172
Proxy-nokeepalive	1
Ssl Tls Sni	staging2.leveragere.com
Https	on
Passenger Download Native Support Binary	0
Passenger Compile Native Support Binary	0
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Unique Id	aio8xXuCzzOiXhrOuzlJjwAAAEY
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	aio8xXuCzzOiXhrOuzlJjwAAAEY
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781152965.364
Request Time	1781152965

====

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

Cape Coral, FL, USA

Location Represented By

Related Articles

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 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