Properties /

South Las Olas Isles

444 Royal Plaza Drive | Fort Lauderdale, FL 33301, USA | $1,975,000

3 Beds
3 Baths
1 Half Ba
Waterfront
Views
Balcony/Terrace
Swimming Pool
Dock

Some lucky buyer has a great opportunity to make a good investment and have an excellent home on 100 feet of waterfront close to Port Everglades for easy ocean access. Located on one of the finest Las Olas Islands with east facing very large yard and waterfront for entertaining and fun! Very livable, bright and charming 3 bedroom, 3½ bath updated home with a 2-car garage and front and back porches. It even has comfortable twin window seats for relaxing or reading in the master bedroom. Also close to the airport, beaches, restaurants and shopping.

Represented By: Intercoastal Realty

www.intercoastalrealty.com | License #: 012345

John Beauchamp
954-801-0336
Email

Main Office: 1500 East Las Olas Boulevard
Fort Lauderdale, FL 33301
USA

More About John

View On Map Property Website

Highlighted Properties

Coral Ridge Country Club

3031 NE 39th Street | Fort Lauderdale, FL 33308
$1,798,000

Five Acres of Privacy

17800 SW 63rd Manor | Southwest Ranches, FL 33331
$4,895,000

Represented By

Agent Contacts: John Beauchamp 954-801-0336 | Email

Featured Location

Fort Lauderdale, FL, USA

Looking for sunshine, water, yachting and comfortable easy living? Welcome to Fort Lauderdale!

Related Property Listings

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

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

Cake Params
- plugin(null)
- controllerproperties
- actionview
- named(empty)
- pass(array)
  03202
  1444-royal-plaza-drive-fort-lauderdale-fl-33301-usa
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys(empty)
- options(empty)
- defaults(array)
  controllerproperties
  actionview
  plugin(null)
- template/property-detail/*
====

Sql Log

Sql Logs

default

Total Time: 23 ms
Total Queries: 38 queries

Query	Affected	Num. rows	Took (ms)	Actions
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` = 3202 AND `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`incomplete` = '0' LIMIT 1	1	1	1
SELECT `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` FROM `leveragere_staging2`.`users` AS `AccountExecutive` WHERE `AccountExecutive`.`id` = 236	1	1	0
SELECT `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`.`assets` AS `Logo` WHERE `Logo`.`model_id` = 39 AND `Logo`.`model` = 'Brokerage' AND `Logo`.`tag` = 'Logo'	1	1	0
SELECT `MainImage`.`id`, `MainImage`.`model`, `MainImage`.`model_id`, `MainImage`.`tag`, `MainImage`.`name`, `MainImage`.`type`, `MainImage`.`size`, `MainImage`.`uri`, `MainImage`.`order`, `MainImage`.`created`, `MainImage`.`modified` FROM `leveragere_staging2`.`assets` AS `MainImage` WHERE `MainImage`.`model_id` = 39 AND `MainImage`.`model` = 'Brokerage' AND `MainImage`.`tag` = 'MainImage'	1	1	0
SELECT `ContactImage`.`id`, `ContactImage`.`model`, `ContactImage`.`model_id`, `ContactImage`.`tag`, `ContactImage`.`name`, `ContactImage`.`type`, `ContactImage`.`size`, `ContactImage`.`uri`, `ContactImage`.`order`, `ContactImage`.`created`, `ContactImage`.`modified` FROM `leveragere_staging2`.`assets` AS `ContactImage` WHERE `ContactImage`.`model_id` = 39 AND `ContactImage`.`model` = 'Brokerage' AND `ContactImage`.`tag` = 'ContactImage'	1	1	0
SELECT `ContactImage2`.`id`, `ContactImage2`.`model`, `ContactImage2`.`model_id`, `ContactImage2`.`tag`, `ContactImage2`.`name`, `ContactImage2`.`type`, `ContactImage2`.`size`, `ContactImage2`.`uri`, `ContactImage2`.`order`, `ContactImage2`.`created`, `ContactImage2`.`modified` FROM `leveragere_staging2`.`assets` AS `ContactImage2` WHERE `ContactImage2`.`model_id` = 39 AND `ContactImage2`.`model` = 'Brokerage' AND `ContactImage2`.`tag` = 'ContactImage2'	0	0	0
SELECT `ContactImage3`.`id`, `ContactImage3`.`model`, `ContactImage3`.`model_id`, `ContactImage3`.`tag`, `ContactImage3`.`name`, `ContactImage3`.`type`, `ContactImage3`.`size`, `ContactImage3`.`uri`, `ContactImage3`.`order`, `ContactImage3`.`created`, `ContactImage3`.`modified` FROM `leveragere_staging2`.`assets` AS `ContactImage3` WHERE `ContactImage3`.`model_id` = 39 AND `ContactImage3`.`model` = 'Brokerage' AND `ContactImage3`.`tag` = 'ContactImage3'	0	0	0
SELECT `BrokerOfRecordLogo`.`id`, `BrokerOfRecordLogo`.`model`, `BrokerOfRecordLogo`.`model_id`, `BrokerOfRecordLogo`.`tag`, `BrokerOfRecordLogo`.`name`, `BrokerOfRecordLogo`.`type`, `BrokerOfRecordLogo`.`size`, `BrokerOfRecordLogo`.`uri`, `BrokerOfRecordLogo`.`order`, `BrokerOfRecordLogo`.`created`, `BrokerOfRecordLogo`.`modified` FROM `leveragere_staging2`.`assets` AS `BrokerOfRecordLogo` WHERE `BrokerOfRecordLogo`.`model_id` = 39 AND `BrokerOfRecordLogo`.`model` = 'Brokerage' AND `BrokerOfRecordLogo`.`tag` = 'BrokerOfRecordLogo'	0	0	0
SELECT `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`.`articles` AS `MainArticle` WHERE `MainArticle`.`model_id` = 39 AND `MainArticle`.`model` = 'Brokerage'	1	1	0
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` = (39) 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` = (39)	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` = (39)	3	3	3
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` = (3202) ORDER BY `Image`.`order` ASC	10	10	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`, `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` = 3202 AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	1	1	3	maybe slow
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` WHERE `Brokerage`.`id` = 39	1	1	2	maybe slow
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model_id` = 366 AND `Image`.`model` = 'User' AND `Image`.`tag` = 'Image'	0	0	0
SELECT `BrokerageLogoOverride`.`id`, `BrokerageLogoOverride`.`model`, `BrokerageLogoOverride`.`model_id`, `BrokerageLogoOverride`.`tag`, `BrokerageLogoOverride`.`name`, `BrokerageLogoOverride`.`type`, `BrokerageLogoOverride`.`size`, `BrokerageLogoOverride`.`uri`, `BrokerageLogoOverride`.`order`, `BrokerageLogoOverride`.`created`, `BrokerageLogoOverride`.`modified` FROM `leveragere_staging2`.`assets` AS `BrokerageLogoOverride` WHERE `BrokerageLogoOverride`.`model_id` = 366 AND `BrokerageLogoOverride`.`model` = 'User' AND `BrokerageLogoOverride`.`tag` = 'BrokerageLogoOverride'	0	0	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` = 3202 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` = 3202 AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	5	5	0
SELECT `Icon`.`id`, `Icon`.`model`, `Icon`.`model_id`, `Icon`.`tag`, `Icon`.`name`, `Icon`.`type`, `Icon`.`size`, `Icon`.`uri`, `Icon`.`order`, `Icon`.`created`, `Icon`.`modified` FROM `leveragere_staging2`.`assets` AS `Icon` WHERE `Icon`.`model_id` = 17 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	1
SELECT `Icon`.`id`, `Icon`.`model`, `Icon`.`model_id`, `Icon`.`tag`, `Icon`.`name`, `Icon`.`type`, `Icon`.`size`, `Icon`.`uri`, `Icon`.`order`, `Icon`.`created`, `Icon`.`modified` FROM `leveragere_staging2`.`assets` AS `Icon` WHERE `Icon`.`model_id` = 14 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	1
SELECT `Icon`.`id`, `Icon`.`model`, `Icon`.`model_id`, `Icon`.`tag`, `Icon`.`name`, `Icon`.`type`, `Icon`.`size`, `Icon`.`uri`, `Icon`.`order`, `Icon`.`created`, `Icon`.`modified` FROM `leveragere_staging2`.`assets` AS `Icon` WHERE `Icon`.`model_id` = 1 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	1
SELECT `Icon`.`id`, `Icon`.`model`, `Icon`.`model_id`, `Icon`.`tag`, `Icon`.`name`, `Icon`.`type`, `Icon`.`size`, `Icon`.`uri`, `Icon`.`order`, `Icon`.`created`, `Icon`.`modified` FROM `leveragere_staging2`.`assets` AS `Icon` WHERE `Icon`.`model_id` = 12 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	1
SELECT `Icon`.`id`, `Icon`.`model`, `Icon`.`model_id`, `Icon`.`tag`, `Icon`.`name`, `Icon`.`type`, `Icon`.`size`, `Icon`.`uri`, `Icon`.`order`, `Icon`.`created`, `Icon`.`modified` FROM `leveragere_staging2`.`assets` AS `Icon` WHERE `Icon`.`model_id` = 3 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	4	maybe slow
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` = 3202 AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	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`.`id` != 3202 AND `Property`.`brokerage_id` = 39 AND `Property`.`status` != 'Sold' AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 2	2	2	2
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 (1900, 3500) ORDER BY `Image`.`order` ASC	21	21	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`, `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 (1900, 3500) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	2	2	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (1900, 3500) 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 (1900, 3500) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	9	9	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 (1900, 3500) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	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`, `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`.`archived` = '0' AND `Location`.`brokerage_id` = 39 LIMIT 1	1	1	1
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` = 39 AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	2	maybe slow
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (1686, 3500, 3202, 2265) ORDER BY `Image`.`order` ASC	36	36	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 (1686, 3500, 3202, 2265) 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 (1686, 3500, 3202, 2265) 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 (1686, 3500, 3202, 2265) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	19	19	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 (1686, 3500, 3202, 2265) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 13.92 MB

Message	Memory use
Component initialization	3.09 MB
Controller action start	4.02 MB
Controller render start	6.93 MB
View render complete	7.45 MB

Timers

Total Request Time: 243 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	26.93
Event: Controller.initialize	3.94
Event: Controller.startup	1.18
Controller action	55.55
Event: Controller.beforeRender	13.90
» Processing toolbar data	13.79
Rendering View	101.80
» Event: View.beforeRender	0.28
» Rendering APP/View/Properties/view.ctp	3.15
» » Rendering APP/View/Elements/static_property_price.ctp	0.38
» » Rendering APP/View/Elements/property_features.ctp	0.23
» » Rendering APP/View/Elements/static_property_price.ctp #2	0.15
» » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.14
» » Rendering APP/View/Elements/sidebar/property_list.ctp	0.97
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #5	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #6	0.13
» » » Rendering APP/View/Elements/static_property_price.ctp #7	0.13
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.21
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	97.66
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)
 id1686
 brokerage_id39
 created_by_user_id0
 order6
 multi_unit(false)
 agent_1_id143
 agent_2_id0
 agent_3_id0
 nameNEW Construction - Amazing Views
 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)
 descriptionComing soon just off Las Olas Boulevard. This classic West Indies style estate with exceptional finishes and design offers 5 bedrooms, 6 full and 2 half baths, 112 feet of deep waterfront and concrete dock that will accommodate a 92 foot yacht. A 2-story grand foyer opens to the formal living room, library and formal dining room while the gourmet kitchen with breakfast nook opens to the family room. First floor VIP suite with expansive water views. The 2nd floor consists of the master suite with his/her baths plus a private open balcony, 4 bedrooms, second living room and spacious open/covered balconies. There are also 3 interior and 1 exterior fireplaces. The expansive outdoor entertaining area with summer room, summer kitchen with bar, dining area overlooking the tropical pool/spa with gorgeous views of the Middle River - Intracoastal Waterway confluence.
 address2501 Aqua Vista Boulevard
 address_2
 cityFort Lauderdale
 stateFL
 postal_code33301
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price0
 price_20
 price_usd0
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(true)
 bedrooms5
 bedrooms_20
 bathrooms5
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1waterfront
 icon_2views
 icon_3dock
 icon_4pool
 icon_5balcony-terrace
 icon_6
 websitehttp://www.intercoastalrealty.com/broward-county-county/fort-lauderdale-homes-for-sale/2501-aqua-vista-blvd-f1322626
 meta_titleNEW Construction - Amazing Views | Fort Lauderdale Real Estate | Intercoastal Realty
 meta_description2501 Aqua Vista Boulevard is a property offered for sale in Fort Lauderdale, FL, USA, presented by Intercoastal Realty
 meta_keywords
 bathrooms_partial2
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldsprice
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-07 16:09:07
 created2015-02-26 09:54:12
 uri/property-detail/1686/2501-aqua-vista-boulevard-fort-lauderdale-fl-33301-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/1686/2501-aqua-vista-boulevard-fort-lauderdale-fl-33301-usa
 address_concat2501 Aqua Vista Boulevard Fort Lauderdale FL 33301 USA
 google_maps_query_string2501+Aqua+Vista+Boulevard++Fort+Lauderdale+FL+33301+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 0
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty5
 bathrooms_partial_pretty2
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2015-02-26
 overridden_brokerage_nameIntercoastal Realty
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id39
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2405797
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameIntercoastal Realty
 broker_of_record_name
 short_nameIntercoastal Realty
 usernameIntercoastalRealty
 password9c8b255daf1d29accdc3643af0c35f4bd571b4f5
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Broward County, Florida, USA. Intercoastal Realty is as unique as the customers and homes that we represent. Founded by Beth Beauchamp more than 30 years ago, Intercoastal Realty originally sold only waterfront homes. Over the years, Beth grew a two person office into the dominant real estate company in waterfront neighborhoods of Southeast Fort Lauderdale. This growth came from her focus on market knowledge and personal service which she continues to use to help educate her clients and friends. Beth has also imparted this focus to the real estate professionals of Intercoastal Realty who have helped make her so successful. With changes in the market and demands from clients, Intercoastal Realty has now expanded to represent all types of residential properties, but we still remain the only true waterfront experts. Although our market has changed, our goals remain the same. Intercoastal Realty exclusively represents and promotes the best homes for the finest clients. With hundreds of years of combined local experience, Intercoastal Realty’s team of knowledgeable, professional Realtor associates provide both buyers and sellers the facts and opportunities for success in our one-of-a kind real estate market. Our team approach means we work together and with the entire real estate community to bring buyers and sellers together. Our unmatched knowledge and experience combined with our network of local, regional, national and international real estate affiliates gives us the ability to locate a buyer across the street or around the globe! Joining with Leverage Global Partners expands this national and international reach and provides our clients with even more market knowledge and strength. New Website now available! 2015 WaterWays Magazine - <a href="http://www.waterways.flmag.com/" target="_blank">http://www.waterways.flmag.com/</a>
 communitiesFort Lauderdale Ft Lauderdale Broward County
 websitehttp://www.intercoastalrealty.com
 address1500 East Las Olas Boulevard
 address_2
 cityFort Lauderdale
 stateFL
 full_stateFlorida
 countryUSA
 marketFort Lauderdale
 market_2
 postal_code33301
 phone(954) 467-1448
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJohn Beauchamp
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-john-beauchamp-president-intercoastal-realty/
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename39.jpg
 logo_filename39.png
 contact_image_filename39.jpg
 all_properties_link_image_filename39.jpg
 all_properties_linkhttp://www.intercoastalrealty.com/exclusive
 video_embed_code
 contact_video_embed_code
 meta_titleFort Lauderdale Real Estate | Intercoastal Realty | Leverage Global Partners
 meta_descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Fort Lauderdale, FL, USA.
 meta_keywordsIntercoastal Realty, fort lauderdale real estate, John Beauchamp, leverage global partners
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-07-29 17:01:16
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/39/intercoastal-realty
 website_shortwww.intercoastalrealty.com
 name_with_locationIntercoastal Realty
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id8561
 modelProperty
 model_id1686
 tagImage
 name14940.jpg
 typeimage/jpg
 size727899
 uri/assets/8561.jpg
 order0
 created2016-04-07 16:09:07
 modified2016-04-07 16:09:07
 1(array)
 id8560
 modelProperty
 model_id1686
 tagImage
 name14939.jpg
 typeimage/jpg
 size1695747
 uri/assets/8560.jpg
 order1
 created2016-04-07 16:09:07
 modified2016-04-07 16:09:07
 2(array)
 id8558
 modelProperty
 model_id1686
 tagImage
 name14937.jpg
 typeimage/jpg
 size565589
 uri/assets/8558.jpg
 order2
 created2016-04-07 16:09:07
 modified2016-04-07 16:09:07
 3(array)
 id8557
 modelProperty
 model_id1686
 tagImage
 name14936.jpg
 typeimage/jpg
 size540246
 uri/assets/8557.jpg
 order3
 created2016-04-07 16:09:07
 modified2016-04-07 16:09:07
 4(array)
 id8556
 modelProperty
 model_id1686
 tagImage
 name14935.jpg
 typeimage/jpg
 size240620
 uri/assets/8556.jpg
 order4
 created2016-04-07 16:09:07
 modified2016-04-07 16:09:07
 5(array)
 id8559
 modelProperty
 model_id1686
 tagImage
 name14938.jpg
 typeimage/jpg
 size212750
 uri/assets/8559.jpg
 order5
 created2016-04-07 16:09:07
 modified2016-04-07 16:09:07
 User(array)
 0(array)
 id366
 typeAgent
 brokerage_id39
 email[email protected]
 password504c74d6c830cb31c34de49f69ae1390fe76088c
 recover_hash
 first_nameJohn
 last_nameBeauchamp
 title
 dre_num
 phone954-801-0336
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:49
 created2017-08-07 15:22:49
 notified(false)
 full_nameJohn Beauchamp
 uri/agent-detail/366/john-beauchamp
 profile_complete(true)
 UsersProperty(array)
 id157
 user_id366
 property_id1686
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id17
 nameWaterfront
 additional(false)
 created2016-04-07 14:06:00
 modified2016-04-07 14:06:00
 PropertiesPropertyFeature(array)
 id1355
 property_id1686
 property_feature_id17
 1(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id1356
 property_id1686
 property_feature_id14
 2(array)
 id3
 nameDock
 additional(false)
 created2016-04-07 14:01:13
 modified2016-04-07 14:01:13
 PropertiesPropertyFeature(array)
 id1357
 property_id1686
 property_feature_id3
 3(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id1358
 property_id1686
 property_feature_id12
 4(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id1359
 property_id1686
 property_feature_id1
 Topic(empty)
 1(array)
 Property(array)
 id3500
 brokerage_id39
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id143
 agent_2_id0
 agent_3_id0
 nameFive Acres of Privacy
 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)
 descriptionFor those seeking luxury, privacy and room for all their toys and horses too. Located on almost 5 acres of ranch land this property includes a main house, guest house, stables, pasture and huge garages. Built in 2002 there are a total of 8 bedrooms, 6 horse stalls and multiple garages for 32 cars plus room for 2 full size tour buses or large RVs. Private and secluded living for your entire family but convenient to both Miami and Fort Lauderdale International Airports. In a hurry? Land your helicopter in your backyard! Private and secluded for your entire family but convenient to both Miami and Fort lauderdale International Airports.
 address17800 SW 63rd Manor
 address_2
 citySouthwest Ranches
 stateFL
 postal_code33331
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price4895000
 price_20
 price_usd4895000
 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)
 bedrooms8
 bedrooms_20
 bathrooms7
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres5
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size5
 icon_1acreage
 icon_2views
 icon_3pool
 icon_4guest-house
 icon_5balcony-terrace
 icon_6
 websitehttp://www.intercoastalrealty.com/broward-county-county/southwest-ranches-homes-for-sale/17800-sw-63rd-mnr-f1377891
 meta_titleFive Acres of Privacy | Southwest Ranches Real Estate | Intercoastal Realty
 meta_description17800 SW 63rd Manor is a property offered for sale in Southwest Ranches, FL, USA, presented by Intercoastal Realty
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tourhttps://vimeo.com/155038140
 digital_brochure
 video_tour_embed_code<iframe src="https://player.vimeo.com/video/155038140?title=0&byline=0&portrait=0" width="500" height="281" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, hectares, year_built, virtual_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 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-02-25 10:21:23
 uri/property-detail/3500/17800-sw-63rd-manor-southwest-ranches-fl-33331-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3500/17800-sw-63rd-manor-southwest-ranches-fl-33331-usa
 address_concat17800 SW 63rd Manor Southwest Ranches FL 33331 USA
 google_maps_query_string17800+SW+63rd+Manor++Southwest+Ranches+FL+33331+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 4,895,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty8
 bathrooms_pretty7
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms7
 date_listed2016-02-25
 overridden_brokerage_nameIntercoastal Realty
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id39
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2405797
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameIntercoastal Realty
 broker_of_record_name
 short_nameIntercoastal Realty
 usernameIntercoastalRealty
 password9c8b255daf1d29accdc3643af0c35f4bd571b4f5
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Broward County, Florida, USA. Intercoastal Realty is as unique as the customers and homes that we represent. Founded by Beth Beauchamp more than 30 years ago, Intercoastal Realty originally sold only waterfront homes. Over the years, Beth grew a two person office into the dominant real estate company in waterfront neighborhoods of Southeast Fort Lauderdale. This growth came from her focus on market knowledge and personal service which she continues to use to help educate her clients and friends. Beth has also imparted this focus to the real estate professionals of Intercoastal Realty who have helped make her so successful. With changes in the market and demands from clients, Intercoastal Realty has now expanded to represent all types of residential properties, but we still remain the only true waterfront experts. Although our market has changed, our goals remain the same. Intercoastal Realty exclusively represents and promotes the best homes for the finest clients. With hundreds of years of combined local experience, Intercoastal Realty’s team of knowledgeable, professional Realtor associates provide both buyers and sellers the facts and opportunities for success in our one-of-a kind real estate market. Our team approach means we work together and with the entire real estate community to bring buyers and sellers together. Our unmatched knowledge and experience combined with our network of local, regional, national and international real estate affiliates gives us the ability to locate a buyer across the street or around the globe! Joining with Leverage Global Partners expands this national and international reach and provides our clients with even more market knowledge and strength. New Website now available! 2015 WaterWays Magazine - <a href="http://www.waterways.flmag.com/" target="_blank">http://www.waterways.flmag.com/</a>
 communitiesFort Lauderdale Ft Lauderdale Broward County
 websitehttp://www.intercoastalrealty.com
 address1500 East Las Olas Boulevard
 address_2
 cityFort Lauderdale
 stateFL
 full_stateFlorida
 countryUSA
 marketFort Lauderdale
 market_2
 postal_code33301
 phone(954) 467-1448
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJohn Beauchamp
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-john-beauchamp-president-intercoastal-realty/
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename39.jpg
 logo_filename39.png
 contact_image_filename39.jpg
 all_properties_link_image_filename39.jpg
 all_properties_linkhttp://www.intercoastalrealty.com/exclusive
 video_embed_code
 contact_video_embed_code
 meta_titleFort Lauderdale Real Estate | Intercoastal Realty | Leverage Global Partners
 meta_descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Fort Lauderdale, FL, USA.
 meta_keywordsIntercoastal Realty, fort lauderdale real estate, John Beauchamp, leverage global partners
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-07-29 17:01:16
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/39/intercoastal-realty
 website_shortwww.intercoastalrealty.com
 name_with_locationIntercoastal Realty
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id17469
 modelProperty
 model_id3500
 tagImage
 name34066.jpg
 typeimage/jpg
 size634726
 uri/assets/17469.jpg
 order0
 created2016-04-07 17:04:03
 modified2016-04-07 17:04:03
 1(array)
 id17468
 modelProperty
 model_id3500
 tagImage
 name34070.jpg
 typeimage/jpg
 size647010
 uri/assets/17468.jpg
 order1
 created2016-04-07 17:04:03
 modified2016-04-07 17:04:03
 2(array)
 id17472
 modelProperty
 model_id3500
 tagImage
 name34063.jpg
 typeimage/jpg
 size748762
 uri/assets/17472.jpg
 order2
 created2016-04-07 17:04:03
 modified2016-04-07 17:04:03
 3(array)
 id17471
 modelProperty
 model_id3500
 tagImage
 name34064.jpg
 typeimage/jpg
 size781820
 uri/assets/17471.jpg
 order3
 created2016-04-07 17:04:03
 modified2016-04-07 17:04:03
 4(array)
 id17470
 modelProperty
 model_id3500
 tagImage
 name34065.jpg
 typeimage/jpg
 size767100
 uri/assets/17470.jpg
 order4
 created2016-04-07 17:04:03
 modified2016-04-07 17:04:03
 5(array)
 id17473
 modelProperty
 model_id3500
 tagImage
 name34062.jpg
 typeimage/jpg
 size436468
 uri/assets/17473.jpg
 order5
 created2016-04-07 17:04:03
 modified2016-04-07 17:04:03
 6(array)
 id17474
 modelProperty
 model_id3500
 tagImage
 name34061.jpg
 typeimage/jpg
 size649670
 uri/assets/17474.jpg
 order6
 created2016-04-07 17:04:03
 modified2016-04-07 17:04:03
 7(array)
 id17465
 modelProperty
 model_id3500
 tagImage
 name34067.jpg
 typeimage/jpg
 size701895
 uri/assets/17465.jpg
 order7
 created2016-04-07 17:04:03
 modified2016-04-07 17:04:03
 8(array)
 id17466
 modelProperty
 model_id3500
 tagImage
 name34068.jpg
 typeimage/jpg
 size491783
 uri/assets/17466.jpg
 order8
 created2016-04-07 17:04:03
 modified2016-04-07 17:04:03
 9(array)
 id17467
 modelProperty
 model_id3500
 tagImage
 name34069.jpg
 typeimage/jpg
 size576798
 uri/assets/17467.jpg
 order9
 created2016-04-07 17:04:03
 modified2016-04-07 17:04:03
 User(array)
 0(array)
 id366
 typeAgent
 brokerage_id39
 email[email protected]
 password504c74d6c830cb31c34de49f69ae1390fe76088c
 recover_hash
 first_nameJohn
 last_nameBeauchamp
 title
 dre_num
 phone954-801-0336
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:49
 created2017-08-07 15:22:49
 notified(false)
 full_nameJohn Beauchamp
 uri/agent-detail/366/john-beauchamp
 profile_complete(true)
 UsersProperty(array)
 id160
 user_id366
 property_id3500
 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)
 id3664
 property_id3500
 property_feature_id14
 1(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id3665
 property_id3500
 property_feature_id12
 2(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id3666
 property_id3500
 property_feature_id5
 3(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id3667
 property_id3500
 property_feature_id1
 Topic(empty)
 2(array)
 Property(array)
 id3202
 brokerage_id39
 created_by_user_id0
 order2
 multi_unit(false)
 agent_1_id143
 agent_2_id0
 agent_3_id0
 nameSouth Las Olas Isles
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 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)
 descriptionSome lucky buyer has a great opportunity to make a good investment and have an excellent home on 100 feet of waterfront close to Port Everglades for easy ocean access. Located on one of the finest Las Olas Islands with east facing very large yard and waterfront for entertaining and fun! Very livable, bright and charming 3 bedroom, 3½ bath updated home with a 2-car garage and front and back porches. It even has comfortable twin window seats for relaxing or reading in the master bedroom. Also close to the airport, beaches, restaurants and shopping.
 address444 Royal Plaza Drive
 address_2
 cityFort Lauderdale
 stateFL
 postal_code33301
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1975000
 price_20
 price_usd1975000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms3
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1waterfront
 icon_2views
 icon_3balcony-terrace
 icon_4pool
 icon_5dock
 icon_6
 websitehttp://www.intercoastalrealty.com/broward-county-county/fort-lauderdale-homes-for-sale/444-royal-plaza-dr-f1361236
 meta_titleSouth Las Olas Isles | Fort Lauderdale Real Estate | Intercoastal Realty
 meta_description444 Royal Plaza Drive is a property offered for sale in Fort Lauderdale, FL, USA, presented by Intercoastal Realty
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2015-12-08 13:31:14
 uri/property-detail/3202/444-royal-plaza-drive-fort-lauderdale-fl-33301-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3202/444-royal-plaza-drive-fort-lauderdale-fl-33301-usa
 address_concat444 Royal Plaza Drive Fort Lauderdale FL 33301 USA
 google_maps_query_string444+Royal+Plaza+Drive++Fort+Lauderdale+FL+33301+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,975,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty3
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2015-12-08
 overridden_brokerage_nameIntercoastal Realty
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id39
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2405797
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameIntercoastal Realty
 broker_of_record_name
 short_nameIntercoastal Realty
 usernameIntercoastalRealty
 password9c8b255daf1d29accdc3643af0c35f4bd571b4f5
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Broward County, Florida, USA. Intercoastal Realty is as unique as the customers and homes that we represent. Founded by Beth Beauchamp more than 30 years ago, Intercoastal Realty originally sold only waterfront homes. Over the years, Beth grew a two person office into the dominant real estate company in waterfront neighborhoods of Southeast Fort Lauderdale. This growth came from her focus on market knowledge and personal service which she continues to use to help educate her clients and friends. Beth has also imparted this focus to the real estate professionals of Intercoastal Realty who have helped make her so successful. With changes in the market and demands from clients, Intercoastal Realty has now expanded to represent all types of residential properties, but we still remain the only true waterfront experts. Although our market has changed, our goals remain the same. Intercoastal Realty exclusively represents and promotes the best homes for the finest clients. With hundreds of years of combined local experience, Intercoastal Realty’s team of knowledgeable, professional Realtor associates provide both buyers and sellers the facts and opportunities for success in our one-of-a kind real estate market. Our team approach means we work together and with the entire real estate community to bring buyers and sellers together. Our unmatched knowledge and experience combined with our network of local, regional, national and international real estate affiliates gives us the ability to locate a buyer across the street or around the globe! Joining with Leverage Global Partners expands this national and international reach and provides our clients with even more market knowledge and strength. New Website now available! 2015 WaterWays Magazine - <a href="http://www.waterways.flmag.com/" target="_blank">http://www.waterways.flmag.com/</a>
 communitiesFort Lauderdale Ft Lauderdale Broward County
 websitehttp://www.intercoastalrealty.com
 address1500 East Las Olas Boulevard
 address_2
 cityFort Lauderdale
 stateFL
 full_stateFlorida
 countryUSA
 marketFort Lauderdale
 market_2
 postal_code33301
 phone(954) 467-1448
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJohn Beauchamp
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-john-beauchamp-president-intercoastal-realty/
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename39.jpg
 logo_filename39.png
 contact_image_filename39.jpg
 all_properties_link_image_filename39.jpg
 all_properties_linkhttp://www.intercoastalrealty.com/exclusive
 video_embed_code
 contact_video_embed_code
 meta_titleFort Lauderdale Real Estate | Intercoastal Realty | Leverage Global Partners
 meta_descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Fort Lauderdale, FL, USA.
 meta_keywordsIntercoastal Realty, fort lauderdale real estate, John Beauchamp, leverage global partners
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-07-29 17:01:16
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/39/intercoastal-realty
 website_shortwww.intercoastalrealty.com
 name_with_locationIntercoastal Realty
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id18431
 modelProperty
 model_id3202
 tagImage
 name30757.jpg
 typeimage/jpg
 size436805
 uri/assets/18431.jpg
 order0
 created2016-04-07 17:10:04
 modified2016-04-07 17:10:04
 1(array)
 id18425
 modelProperty
 model_id3202
 tagImage
 name30751.jpg
 typeimage/jpg
 size620991
 uri/assets/18425.jpg
 order1
 created2016-04-07 17:10:04
 modified2016-04-07 17:10:04
 2(array)
 id18426
 modelProperty
 model_id3202
 tagImage
 name30752.jpg
 typeimage/jpg
 size711581
 uri/assets/18426.jpg
 order2
 created2016-04-07 17:10:04
 modified2016-04-07 17:10:04
 3(array)
 id18432
 modelProperty
 model_id3202
 tagImage
 name30758.jpg
 typeimage/jpg
 size655629
 uri/assets/18432.jpg
 order3
 created2016-04-07 17:10:04
 modified2016-04-07 17:10:04
 4(array)
 id18429
 modelProperty
 model_id3202
 tagImage
 name30755.jpg
 typeimage/jpg
 size463519
 uri/assets/18429.jpg
 order4
 created2016-04-07 17:10:04
 modified2016-04-07 17:10:04
 5(array)
 id18428
 modelProperty
 model_id3202
 tagImage
 name30754.jpg
 typeimage/jpg
 size506207
 uri/assets/18428.jpg
 order5
 created2016-04-07 17:10:04
 modified2016-04-07 17:10:04
 6(array)
 id18430
 modelProperty
 model_id3202
 tagImage
 name30756.jpg
 typeimage/jpg
 size397493
 uri/assets/18430.jpg
 order6
 created2016-04-07 17:10:04
 modified2016-04-07 17:10:04
 7(array)
 id18433
 modelProperty
 model_id3202
 tagImage
 name30759.jpg
 typeimage/jpg
 size632615
 uri/assets/18433.jpg
 order7
 created2016-04-07 17:10:04
 modified2016-04-07 17:10:04
 8(array)
 id18427
 modelProperty
 model_id3202
 tagImage
 name30753.jpg
 typeimage/jpg
 size792173
 uri/assets/18427.jpg
 order8
 created2016-04-07 17:10:04
 modified2016-04-07 17:10:04
 9(array)
 id18434
 modelProperty
 model_id3202
 tagImage
 name30760.jpg
 typeimage/jpg
 size738874
 uri/assets/18434.jpg
 order9
 created2016-04-07 17:10:04
 modified2016-04-07 17:10:04
 User(array)
 0(array)
 id366
 typeAgent
 brokerage_id39
 email[email protected]
 password504c74d6c830cb31c34de49f69ae1390fe76088c
 recover_hash
 first_nameJohn
 last_nameBeauchamp
 title
 dre_num
 phone954-801-0336
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:49
 created2017-08-07 15:22:49
 notified(false)
 full_nameJohn Beauchamp
 uri/agent-detail/366/john-beauchamp
 profile_complete(true)
 UsersProperty(array)
 id162
 user_id366
 property_id3202
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id17
 nameWaterfront
 additional(false)
 created2016-04-07 14:06:00
 modified2016-04-07 14:06:00
 PropertiesPropertyFeature(array)
 id3887
 property_id3202
 property_feature_id17
 1(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id3888
 property_id3202
 property_feature_id14
 2(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id3889
 property_id3202
 property_feature_id1
 3(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id3890
 property_id3202
 property_feature_id12
 4(array)
 id3
 nameDock
 additional(false)
 created2016-04-07 14:01:13
 modified2016-04-07 14:01:13
 PropertiesPropertyFeature(array)
 id3891
 property_id3202
 property_feature_id3
 Topic(empty)
 3(array)
 Property(array)
 id2265
 brokerage_id39
 created_by_user_id0
 order4
 multi_unit(false)
 agent_1_id143
 agent_2_id0
 agent_3_id0
 nameHistoric and Modern
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 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)
 descriptionVintage 1937 waterfront home that has been renovated with care to retain its original classic charms and updated to meet current luxury standards. In Fort Lauderdale’s finest neighborhood, Idlewyld, this one of a kind home has 3 separate master suites, including one with a living room and separate kitchen. Entertain all your guests or just enjoy long views to the Intracoastal Waterway from the huge sun terrace, or feel the breezes in your screened porch overlooking the lap pool and waterfront patio. Only minutes to the Atlantic Ocean from your dock or a short walk just over the Las Olas Bridge to the beach.
 address419 Poinciana Drive
 address_2
 cityFort Lauderdale
 stateFL
 postal_code33301
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2395000
 price_20
 price_usd2395000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms3
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1waterfront
 icon_2dock
 icon_3balcony-terrace
 icon_4pool
 icon_5views
 icon_6
 websitehttp://www.intercoastalrealty.com/broward-county-county/fort-lauderdale-homes-for-sale/419-poinciana-dr-f1337305
 meta_titleHistoric and Modern | Fort Lauderdale Real Estate | Intercoastal Realty
 meta_description419 Poinciana Drive is a property offered for sale in Fort Lauderdale, FL, USA, presented by Intercoastal Realty
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-06-04 09:25:51
 uri/property-detail/2265/419-poinciana-drive-fort-lauderdale-fl-33301-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2265/419-poinciana-drive-fort-lauderdale-fl-33301-usa
 address_concat419 Poinciana Drive Fort Lauderdale FL 33301 USA
 google_maps_query_string419+Poinciana+Drive++Fort+Lauderdale+FL+33301+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,395,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty3
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2015-06-04
 overridden_brokerage_nameIntercoastal Realty
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id39
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2405797
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameIntercoastal Realty
 broker_of_record_name
 short_nameIntercoastal Realty
 usernameIntercoastalRealty
 password9c8b255daf1d29accdc3643af0c35f4bd571b4f5
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Broward County, Florida, USA. Intercoastal Realty is as unique as the customers and homes that we represent. Founded by Beth Beauchamp more than 30 years ago, Intercoastal Realty originally sold only waterfront homes. Over the years, Beth grew a two person office into the dominant real estate company in waterfront neighborhoods of Southeast Fort Lauderdale. This growth came from her focus on market knowledge and personal service which she continues to use to help educate her clients and friends. Beth has also imparted this focus to the real estate professionals of Intercoastal Realty who have helped make her so successful. With changes in the market and demands from clients, Intercoastal Realty has now expanded to represent all types of residential properties, but we still remain the only true waterfront experts. Although our market has changed, our goals remain the same. Intercoastal Realty exclusively represents and promotes the best homes for the finest clients. With hundreds of years of combined local experience, Intercoastal Realty’s team of knowledgeable, professional Realtor associates provide both buyers and sellers the facts and opportunities for success in our one-of-a kind real estate market. Our team approach means we work together and with the entire real estate community to bring buyers and sellers together. Our unmatched knowledge and experience combined with our network of local, regional, national and international real estate affiliates gives us the ability to locate a buyer across the street or around the globe! Joining with Leverage Global Partners expands this national and international reach and provides our clients with even more market knowledge and strength. New Website now available! 2015 WaterWays Magazine - <a href="http://www.waterways.flmag.com/" target="_blank">http://www.waterways.flmag.com/</a>
 communitiesFort Lauderdale Ft Lauderdale Broward County
 websitehttp://www.intercoastalrealty.com
 address1500 East Las Olas Boulevard
 address_2
 cityFort Lauderdale
 stateFL
 full_stateFlorida
 countryUSA
 marketFort Lauderdale
 market_2
 postal_code33301
 phone(954) 467-1448
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJohn Beauchamp
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-john-beauchamp-president-intercoastal-realty/
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename39.jpg
 logo_filename39.png
 contact_image_filename39.jpg
 all_properties_link_image_filename39.jpg
 all_properties_linkhttp://www.intercoastalrealty.com/exclusive
 video_embed_code
 contact_video_embed_code
 meta_titleFort Lauderdale Real Estate | Intercoastal Realty | Leverage Global Partners
 meta_descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Fort Lauderdale, FL, USA.
 meta_keywordsIntercoastal Realty, fort lauderdale real estate, John Beauchamp, leverage global partners
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-07-29 17:01:16
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/39/intercoastal-realty
 website_shortwww.intercoastalrealty.com
 name_with_locationIntercoastal Realty
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id15072
 modelProperty
 model_id2265
 tagImage
 name20911.jpg
 typeimage/jpg
 size634560
 uri/assets/15072.jpg
 order0
 created2016-04-07 16:50:04
 modified2016-04-07 16:50:04
 1(array)
 id15065
 modelProperty
 model_id2265
 tagImage
 name20904.jpg
 typeimage/jpg
 size1013262
 uri/assets/15065.jpg
 order1
 created2016-04-07 16:50:04
 modified2016-04-07 16:50:04
 2(array)
 id15067
 modelProperty
 model_id2265
 tagImage
 name20906.jpg
 typeimage/jpg
 size848474
 uri/assets/15067.jpg
 order2
 created2016-04-07 16:50:04
 modified2016-04-07 16:50:04
 3(array)
 id15066
 modelProperty
 model_id2265
 tagImage
 name20905.jpg
 typeimage/jpg
 size522776
 uri/assets/15066.jpg
 order3
 created2016-04-07 16:50:04
 modified2016-04-07 16:50:04
 4(array)
 id15071
 modelProperty
 model_id2265
 tagImage
 name20910.jpg
 typeimage/jpg
 size521686
 uri/assets/15071.jpg
 order4
 created2016-04-07 16:50:04
 modified2016-04-07 16:50:04
 5(array)
 id15068
 modelProperty
 model_id2265
 tagImage
 name20907.jpg
 typeimage/jpg
 size603434
 uri/assets/15068.jpg
 order5
 created2016-04-07 16:50:04
 modified2016-04-07 16:50:04
 6(array)
 id15069
 modelProperty
 model_id2265
 tagImage
 name20908.jpg
 typeimage/jpg
 size512346
 uri/assets/15069.jpg
 order6
 created2016-04-07 16:50:04
 modified2016-04-07 16:50:04
 7(array)
 id15070
 modelProperty
 model_id2265
 tagImage
 name20909.jpg
 typeimage/jpg
 size553151
 uri/assets/15070.jpg
 order7
 created2016-04-07 16:50:04
 modified2016-04-07 16:50:04
 8(array)
 id15073
 modelProperty
 model_id2265
 tagImage
 name20912.jpg
 typeimage/jpg
 size514468
 uri/assets/15073.jpg
 order8
 created2016-04-07 16:50:04
 modified2016-04-07 16:50:04
 9(array)
 id15074
 modelProperty
 model_id2265
 tagImage
 name20913.jpg
 typeimage/jpg
 size715382
 uri/assets/15074.jpg
 order9
 created2016-04-07 16:50:04
 modified2016-04-07 16:50:04
 User(array)
 0(array)
 id366
 typeAgent
 brokerage_id39
 email[email protected]
 password504c74d6c830cb31c34de49f69ae1390fe76088c
 recover_hash
 first_nameJohn
 last_nameBeauchamp
 title
 dre_num
 phone954-801-0336
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:49
 created2017-08-07 15:22:49
 notified(false)
 full_nameJohn Beauchamp
 uri/agent-detail/366/john-beauchamp
 profile_complete(true)
 UsersProperty(array)
 id159
 user_id366
 property_id2265
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id17
 nameWaterfront
 additional(false)
 created2016-04-07 14:06:00
 modified2016-04-07 14:06:00
 PropertiesPropertyFeature(array)
 id3037
 property_id2265
 property_feature_id17
 1(array)
 id3
 nameDock
 additional(false)
 created2016-04-07 14:01:13
 modified2016-04-07 14:01:13
 PropertiesPropertyFeature(array)
 id3038
 property_id2265
 property_feature_id3
 2(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id3039
 property_id2265
 property_feature_id1
 3(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id3040
 property_id2265
 property_feature_id12
 4(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id3041
 property_id2265
 property_feature_id14
 Topic(empty)
- sidebar_locations(array)
 0(array)
 Location(array)
 id122
 parent_id8
 brokerage_id39
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameFort Lauderdale, FL, USA
 short_nameFort Lauderdale, FL, USA
 group_index
 latitude26.124271
 longitude-80.128899
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionLooking for sunshine, water, yachting and comfortable easy living? Welcome to Fort Lauderdale!
 long_descriptionThis former spring break destination has grown up to become a magnet for South American, European, Canadian and Americans seeking sunshine, water, yachting and the South Florida lifestyle. Fort Lauderdale has 165 miles of beautiful, navigable waterways, 7 miles of pristine beaches, and more hours of sunshine than almost anywhere on earth! Enjoy world class amenities and services with a small town feel. Where else can you live on the water with your boat docked in your backyard, work in a vibrant downtown, walk the restaurants and boutiques of Las Olas or to the Atlantic Ocean and beach, catch an international flight or Caribbean cruise – all only minutes apart!
 created2016-04-06 10:05:21
 modified2016-04-12 18:32:43
 timezoneAmerica/New_York
 population172389
 uri/locations/view/122/fort-lauderdale-fl-usa
 tile_nameFort Lauderdale, FL, USA
 Brokerage(array)
 id39
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2405797
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameIntercoastal Realty
 broker_of_record_name
 short_nameIntercoastal Realty
 usernameIntercoastalRealty
 password9c8b255daf1d29accdc3643af0c35f4bd571b4f5
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Broward County, Florida, USA. Intercoastal Realty is as unique as the customers and homes that we represent. Founded by Beth Beauchamp more than 30 years ago, Intercoastal Realty originally sold only waterfront homes. Over the years, Beth grew a two person office into the dominant real estate company in waterfront neighborhoods of Southeast Fort Lauderdale. This growth came from her focus on market knowledge and personal service which she continues to use to help educate her clients and friends. Beth has also imparted this focus to the real estate professionals of Intercoastal Realty who have helped make her so successful. With changes in the market and demands from clients, Intercoastal Realty has now expanded to represent all types of residential properties, but we still remain the only true waterfront experts. Although our market has changed, our goals remain the same. Intercoastal Realty exclusively represents and promotes the best homes for the finest clients. With hundreds of years of combined local experience, Intercoastal Realty’s team of knowledgeable, professional Realtor associates provide both buyers and sellers the facts and opportunities for success in our one-of-a kind real estate market. Our team approach means we work together and with the entire real estate community to bring buyers and sellers together. Our unmatched knowledge and experience combined with our network of local, regional, national and international real estate affiliates gives us the ability to locate a buyer across the street or around the globe! Joining with Leverage Global Partners expands this national and international reach and provides our clients with even more market knowledge and strength. New Website now available! 2015 WaterWays Magazine - <a href="http://www.waterways.flmag.com/" target="_blank">http://www.waterways.flmag.com/</a>
 communitiesFort Lauderdale Ft Lauderdale Broward County
 websitehttp://www.intercoastalrealty.com
 address1500 East Las Olas Boulevard
 address_2
 cityFort Lauderdale
 stateFL
 full_stateFlorida
 countryUSA
 marketFort Lauderdale
 market_2
 postal_code33301
 phone(954) 467-1448
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJohn Beauchamp
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-john-beauchamp-president-intercoastal-realty/
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename39.jpg
 logo_filename39.png
 contact_image_filename39.jpg
 all_properties_link_image_filename39.jpg
 all_properties_linkhttp://www.intercoastalrealty.com/exclusive
 video_embed_code
 contact_video_embed_code
 meta_titleFort Lauderdale Real Estate | Intercoastal Realty | Leverage Global Partners
 meta_descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Fort Lauderdale, FL, USA.
 meta_keywordsIntercoastal Realty, fort lauderdale real estate, John Beauchamp, leverage global partners
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-07-29 17:01:16
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/39/intercoastal-realty
 website_shortwww.intercoastalrealty.com
 name_with_locationIntercoastal Realty
 Image(array)
 id3385
 modelLocation
 model_id122
 tagImage
 name39922990_aerial_ft_lauderdale_skyline_x.jpg
 typeimage/jpeg
 size3109337
 uri/assets/3385.jpg
 order0
 created2016-04-06 10:02:15
 modified2016-04-12 18:32:43
- highlighted_properties(array)
 0(array)
 Property(array)
 id1900
 brokerage_id39
 created_by_user_id0
 order3
 multi_unit(false)
 agent_1_id143
 agent_2_id0
 agent_3_id0
 nameCoral Ridge Country Club
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 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)
 descriptionSpectacular custom contemporary 4 bedroom, 3½ bath home in impeccable condition with beautiful water views. On 85 ft. of deep water with all new 85 ft. dock and newly redone throughout including electric, plumbing, A/C, raised high ceilings, oak floors, impact windows and doors, you will delight in the magazine quality master bath and awesome open kitchen. On top of this, you will find a 2 car garage, a walk in pantry/laundry room and built out huge master closet. This is truly a great room floor plan and outside, you will find an all new paver patio surrounding the pool and fountains adjacent to a cozy pergola for your waterside entertaining.
 address3031 NE 39th Street
 address_2
 cityFort Lauderdale
 stateFL
 postal_code33308
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1798000
 price_20
 price_usd1798000
 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_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1waterfront
 icon_2views
 icon_3pool
 icon_4dock
 icon_5garage
 icon_6
 website
 meta_titleCoral Ridge Country Club | Fort Lauderdale Real Estate | Intercoastal Realty
 meta_description3031 NE 39th Street is a property offered for sale in Fort Lauderdale, FL, USA, presented by Intercoastal Realty
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-04-02 09:28:30
 uri/property-detail/1900/3031-ne-39th-street-fort-lauderdale-fl-33308-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/1900/3031-ne-39th-street-fort-lauderdale-fl-33308-usa
 address_concat3031 NE 39th Street Fort Lauderdale FL 33308 USA
 google_maps_query_string3031+NE+39th+Street++Fort+Lauderdale+FL+33308+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,798,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty3
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2015-04-02
 overridden_brokerage_nameIntercoastal Realty
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id39
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2405797
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameIntercoastal Realty
 broker_of_record_name
 short_nameIntercoastal Realty
 usernameIntercoastalRealty
 password9c8b255daf1d29accdc3643af0c35f4bd571b4f5
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Broward County, Florida, USA. Intercoastal Realty is as unique as the customers and homes that we represent. Founded by Beth Beauchamp more than 30 years ago, Intercoastal Realty originally sold only waterfront homes. Over the years, Beth grew a two person office into the dominant real estate company in waterfront neighborhoods of Southeast Fort Lauderdale. This growth came from her focus on market knowledge and personal service which she continues to use to help educate her clients and friends. Beth has also imparted this focus to the real estate professionals of Intercoastal Realty who have helped make her so successful. With changes in the market and demands from clients, Intercoastal Realty has now expanded to represent all types of residential properties, but we still remain the only true waterfront experts. Although our market has changed, our goals remain the same. Intercoastal Realty exclusively represents and promotes the best homes for the finest clients. With hundreds of years of combined local experience, Intercoastal Realty’s team of knowledgeable, professional Realtor associates provide both buyers and sellers the facts and opportunities for success in our one-of-a kind real estate market. Our team approach means we work together and with the entire real estate community to bring buyers and sellers together. Our unmatched knowledge and experience combined with our network of local, regional, national and international real estate affiliates gives us the ability to locate a buyer across the street or around the globe! Joining with Leverage Global Partners expands this national and international reach and provides our clients with even more market knowledge and strength. New Website now available! 2015 WaterWays Magazine - <a href="http://www.waterways.flmag.com/" target="_blank">http://www.waterways.flmag.com/</a>
 communitiesFort Lauderdale Ft Lauderdale Broward County
 websitehttp://www.intercoastalrealty.com
 address1500 East Las Olas Boulevard
 address_2
 cityFort Lauderdale
 stateFL
 full_stateFlorida
 countryUSA
 marketFort Lauderdale
 market_2
 postal_code33301
 phone(954) 467-1448
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJohn Beauchamp
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-john-beauchamp-president-intercoastal-realty/
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename39.jpg
 logo_filename39.png
 contact_image_filename39.jpg
 all_properties_link_image_filename39.jpg
 all_properties_linkhttp://www.intercoastalrealty.com/exclusive
 video_embed_code
 contact_video_embed_code
 meta_titleFort Lauderdale Real Estate | Intercoastal Realty | Leverage Global Partners
 meta_descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Fort Lauderdale, FL, USA.
 meta_keywordsIntercoastal Realty, fort lauderdale real estate, John Beauchamp, leverage global partners
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-07-29 17:01:16
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/39/intercoastal-realty
 website_shortwww.intercoastalrealty.com
 name_with_locationIntercoastal Realty
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id14148
 modelProperty
 model_id1900
 tagImage
 name30748.jpg
 typeimage/jpg
 size420249
 uri/assets/14148.jpg
 order0
 created2016-04-07 16:44:03
 modified2016-04-07 16:44:03
 1(array)
 id14144
 modelProperty
 model_id1900
 tagImage
 name17182.jpg
 typeimage/jpg
 size634845
 uri/assets/14144.jpg
 order1
 created2016-04-07 16:44:03
 modified2016-04-07 16:44:03
 2(array)
 id14139
 modelProperty
 model_id1900
 tagImage
 name17177.jpg
 typeimage/jpg
 size813316
 uri/assets/14139.jpg
 order2
 created2016-04-07 16:44:03
 modified2016-04-07 16:44:03
 3(array)
 id14147
 modelProperty
 model_id1900
 tagImage
 name30749.jpg
 typeimage/jpg
 size612967
 uri/assets/14147.jpg
 order3
 created2016-04-07 16:44:03
 modified2016-04-07 16:44:03
 4(array)
 id14149
 modelProperty
 model_id1900
 tagImage
 name30750.jpg
 typeimage/jpg
 size550971
 uri/assets/14149.jpg
 order4
 created2016-04-07 16:44:03
 modified2016-04-07 16:44:03
 5(array)
 id14142
 modelProperty
 model_id1900
 tagImage
 name17180.jpg
 typeimage/jpg
 size393505
 uri/assets/14142.jpg
 order5
 created2016-04-07 16:44:03
 modified2016-04-07 16:44:03
 6(array)
 id14143
 modelProperty
 model_id1900
 tagImage
 name17181.jpg
 typeimage/jpg
 size400053
 uri/assets/14143.jpg
 order6
 created2016-04-07 16:44:03
 modified2016-04-07 16:44:03
 7(array)
 id14140
 modelProperty
 model_id1900
 tagImage
 name17178.jpg
 typeimage/jpg
 size301380
 uri/assets/14140.jpg
 order7
 created2016-04-07 16:44:03
 modified2016-04-07 16:44:03
 8(array)
 id14141
 modelProperty
 model_id1900
 tagImage
 name17179.jpg
 typeimage/jpg
 size332062
 uri/assets/14141.jpg
 order8
 created2016-04-07 16:44:03
 modified2016-04-07 16:44:03
 9(array)
 id14146
 modelProperty
 model_id1900
 tagImage
 name17184.jpg
 typeimage/jpg
 size494287
 uri/assets/14146.jpg
 order9
 created2016-04-07 16:44:03
 modified2016-04-07 16:44:03
 10(array)
 id14145
 modelProperty
 model_id1900
 tagImage
 name17183.jpg
 typeimage/jpg
 size269433
 uri/assets/14145.jpg
 order10
 created2016-04-07 16:44:03
 modified2016-04-07 16:44:03
 User(array)
 0(array)
 id366
 typeAgent
 brokerage_id39
 email[email protected]
 password504c74d6c830cb31c34de49f69ae1390fe76088c
 recover_hash
 first_nameJohn
 last_nameBeauchamp
 title
 dre_num
 phone954-801-0336
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:49
 created2017-08-07 15:22:49
 notified(false)
 full_nameJohn Beauchamp
 uri/agent-detail/366/john-beauchamp
 profile_complete(true)
 UsersProperty(array)
 id158
 user_id366
 property_id1900
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id17
 nameWaterfront
 additional(false)
 created2016-04-07 14:06:00
 modified2016-04-07 14:06:00
 PropertiesPropertyFeature(array)
 id2787
 property_id1900
 property_feature_id17
 1(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id2788
 property_id1900
 property_feature_id14
 2(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id2789
 property_id1900
 property_feature_id12
 3(array)
 id3
 nameDock
 additional(false)
 created2016-04-07 14:01:13
 modified2016-04-07 14:01:13
 PropertiesPropertyFeature(array)
 id2790
 property_id1900
 property_feature_id3
 4(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id2791
 property_id1900
 property_feature_id4
 Topic(empty)
 1(array)
 Property(array)
 id3500
 brokerage_id39
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id143
 agent_2_id0
 agent_3_id0
 nameFive Acres of Privacy
 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)
 descriptionFor those seeking luxury, privacy and room for all their toys and horses too. Located on almost 5 acres of ranch land this property includes a main house, guest house, stables, pasture and huge garages. Built in 2002 there are a total of 8 bedrooms, 6 horse stalls and multiple garages for 32 cars plus room for 2 full size tour buses or large RVs. Private and secluded living for your entire family but convenient to both Miami and Fort Lauderdale International Airports. In a hurry? Land your helicopter in your backyard! Private and secluded for your entire family but convenient to both Miami and Fort lauderdale International Airports.
 address17800 SW 63rd Manor
 address_2
 citySouthwest Ranches
 stateFL
 postal_code33331
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price4895000
 price_20
 price_usd4895000
 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)
 bedrooms8
 bedrooms_20
 bathrooms7
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres5
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size5
 icon_1acreage
 icon_2views
 icon_3pool
 icon_4guest-house
 icon_5balcony-terrace
 icon_6
 websitehttp://www.intercoastalrealty.com/broward-county-county/southwest-ranches-homes-for-sale/17800-sw-63rd-mnr-f1377891
 meta_titleFive Acres of Privacy | Southwest Ranches Real Estate | Intercoastal Realty
 meta_description17800 SW 63rd Manor is a property offered for sale in Southwest Ranches, FL, USA, presented by Intercoastal Realty
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tourhttps://vimeo.com/155038140
 digital_brochure
 video_tour_embed_code<iframe src="https://player.vimeo.com/video/155038140?title=0&byline=0&portrait=0" width="500" height="281" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, hectares, year_built, virtual_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 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-02-25 10:21:23
 uri/property-detail/3500/17800-sw-63rd-manor-southwest-ranches-fl-33331-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3500/17800-sw-63rd-manor-southwest-ranches-fl-33331-usa
 address_concat17800 SW 63rd Manor Southwest Ranches FL 33331 USA
 google_maps_query_string17800+SW+63rd+Manor++Southwest+Ranches+FL+33331+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 4,895,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty8
 bathrooms_pretty7
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms7
 date_listed2016-02-25
 overridden_brokerage_nameIntercoastal Realty
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id39
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2405797
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameIntercoastal Realty
 broker_of_record_name
 short_nameIntercoastal Realty
 usernameIntercoastalRealty
 password9c8b255daf1d29accdc3643af0c35f4bd571b4f5
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Broward County, Florida, USA. Intercoastal Realty is as unique as the customers and homes that we represent. Founded by Beth Beauchamp more than 30 years ago, Intercoastal Realty originally sold only waterfront homes. Over the years, Beth grew a two person office into the dominant real estate company in waterfront neighborhoods of Southeast Fort Lauderdale. This growth came from her focus on market knowledge and personal service which she continues to use to help educate her clients and friends. Beth has also imparted this focus to the real estate professionals of Intercoastal Realty who have helped make her so successful. With changes in the market and demands from clients, Intercoastal Realty has now expanded to represent all types of residential properties, but we still remain the only true waterfront experts. Although our market has changed, our goals remain the same. Intercoastal Realty exclusively represents and promotes the best homes for the finest clients. With hundreds of years of combined local experience, Intercoastal Realty’s team of knowledgeable, professional Realtor associates provide both buyers and sellers the facts and opportunities for success in our one-of-a kind real estate market. Our team approach means we work together and with the entire real estate community to bring buyers and sellers together. Our unmatched knowledge and experience combined with our network of local, regional, national and international real estate affiliates gives us the ability to locate a buyer across the street or around the globe! Joining with Leverage Global Partners expands this national and international reach and provides our clients with even more market knowledge and strength. New Website now available! 2015 WaterWays Magazine - <a href="http://www.waterways.flmag.com/" target="_blank">http://www.waterways.flmag.com/</a>
 communitiesFort Lauderdale Ft Lauderdale Broward County
 websitehttp://www.intercoastalrealty.com
 address1500 East Las Olas Boulevard
 address_2
 cityFort Lauderdale
 stateFL
 full_stateFlorida
 countryUSA
 marketFort Lauderdale
 market_2
 postal_code33301
 phone(954) 467-1448
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJohn Beauchamp
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-john-beauchamp-president-intercoastal-realty/
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename39.jpg
 logo_filename39.png
 contact_image_filename39.jpg
 all_properties_link_image_filename39.jpg
 all_properties_linkhttp://www.intercoastalrealty.com/exclusive
 video_embed_code
 contact_video_embed_code
 meta_titleFort Lauderdale Real Estate | Intercoastal Realty | Leverage Global Partners
 meta_descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Fort Lauderdale, FL, USA.
 meta_keywordsIntercoastal Realty, fort lauderdale real estate, John Beauchamp, leverage global partners
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-07-29 17:01:16
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/39/intercoastal-realty
 website_shortwww.intercoastalrealty.com
 name_with_locationIntercoastal Realty
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id17469
 modelProperty
 model_id3500
 tagImage
 name34066.jpg
 typeimage/jpg
 size634726
 uri/assets/17469.jpg
 order0
 created2016-04-07 17:04:03
 modified2016-04-07 17:04:03
 1(array)
 id17468
 modelProperty
 model_id3500
 tagImage
 name34070.jpg
 typeimage/jpg
 size647010
 uri/assets/17468.jpg
 order1
 created2016-04-07 17:04:03
 modified2016-04-07 17:04:03
 2(array)
 id17472
 modelProperty
 model_id3500
 tagImage
 name34063.jpg
 typeimage/jpg
 size748762
 uri/assets/17472.jpg
 order2
 created2016-04-07 17:04:03
 modified2016-04-07 17:04:03
 3(array)
 id17471
 modelProperty
 model_id3500
 tagImage
 name34064.jpg
 typeimage/jpg
 size781820
 uri/assets/17471.jpg
 order3
 created2016-04-07 17:04:03
 modified2016-04-07 17:04:03
 4(array)
 id17470
 modelProperty
 model_id3500
 tagImage
 name34065.jpg
 typeimage/jpg
 size767100
 uri/assets/17470.jpg
 order4
 created2016-04-07 17:04:03
 modified2016-04-07 17:04:03
 5(array)
 id17473
 modelProperty
 model_id3500
 tagImage
 name34062.jpg
 typeimage/jpg
 size436468
 uri/assets/17473.jpg
 order5
 created2016-04-07 17:04:03
 modified2016-04-07 17:04:03
 6(array)
 id17474
 modelProperty
 model_id3500
 tagImage
 name34061.jpg
 typeimage/jpg
 size649670
 uri/assets/17474.jpg
 order6
 created2016-04-07 17:04:03
 modified2016-04-07 17:04:03
 7(array)
 id17465
 modelProperty
 model_id3500
 tagImage
 name34067.jpg
 typeimage/jpg
 size701895
 uri/assets/17465.jpg
 order7
 created2016-04-07 17:04:03
 modified2016-04-07 17:04:03
 8(array)
 id17466
 modelProperty
 model_id3500
 tagImage
 name34068.jpg
 typeimage/jpg
 size491783
 uri/assets/17466.jpg
 order8
 created2016-04-07 17:04:03
 modified2016-04-07 17:04:03
 9(array)
 id17467
 modelProperty
 model_id3500
 tagImage
 name34069.jpg
 typeimage/jpg
 size576798
 uri/assets/17467.jpg
 order9
 created2016-04-07 17:04:03
 modified2016-04-07 17:04:03
 User(array)
 0(array)
 id366
 typeAgent
 brokerage_id39
 email[email protected]
 password504c74d6c830cb31c34de49f69ae1390fe76088c
 recover_hash
 first_nameJohn
 last_nameBeauchamp
 title
 dre_num
 phone954-801-0336
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:49
 created2017-08-07 15:22:49
 notified(false)
 full_nameJohn Beauchamp
 uri/agent-detail/366/john-beauchamp
 profile_complete(true)
 UsersProperty(array)
 id160
 user_id366
 property_id3500
 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)
 id3664
 property_id3500
 property_feature_id14
 1(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id3665
 property_id3500
 property_feature_id12
 2(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id3666
 property_id3500
 property_feature_id5
 3(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id3667
 property_id3500
 property_feature_id1
 Topic(empty)
- custom_ga_event_properties(array)
 brokerageIntercoastal Realty, Fort Lauderdale
- property(array)
 Property(array)
 id3202
 brokerage_id39
 created_by_user_id0
 order2
 multi_unit(false)
 agent_1_id143
 agent_2_id0
 agent_3_id0
 nameSouth Las Olas Isles
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 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)
 descriptionSome lucky buyer has a great opportunity to make a good investment and have an excellent home on 100 feet of waterfront close to Port Everglades for easy ocean access. Located on one of the finest Las Olas Islands with east facing very large yard and waterfront for entertaining and fun! Very livable, bright and charming 3 bedroom, 3½ bath updated home with a 2-car garage and front and back porches. It even has comfortable twin window seats for relaxing or reading in the master bedroom. Also close to the airport, beaches, restaurants and shopping.
 address444 Royal Plaza Drive
 address_2
 cityFort Lauderdale
 stateFL
 postal_code33301
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1975000
 price_20
 price_usd1975000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms3
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1waterfront
 icon_2views
 icon_3balcony-terrace
 icon_4pool
 icon_5dock
 icon_6
 websitehttp://www.intercoastalrealty.com/broward-county-county/fort-lauderdale-homes-for-sale/444-royal-plaza-dr-f1361236
 meta_titleSouth Las Olas Isles | Fort Lauderdale Real Estate | Intercoastal Realty
 meta_description444 Royal Plaza Drive is a property offered for sale in Fort Lauderdale, FL, USA, presented by Intercoastal Realty
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2015-12-08 13:31:14
 uri/property-detail/3202/444-royal-plaza-drive-fort-lauderdale-fl-33301-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3202/444-royal-plaza-drive-fort-lauderdale-fl-33301-usa
 address_concat444 Royal Plaza Drive Fort Lauderdale FL 33301 USA
 google_maps_query_string444+Royal+Plaza+Drive++Fort+Lauderdale+FL+33301+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,975,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty3
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2015-12-08
 overridden_brokerage_nameIntercoastal Realty
 overridden_brokerage_logo_uri/assets/2353.png
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id39
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2405797
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameIntercoastal Realty
 broker_of_record_name
 short_nameIntercoastal Realty
 usernameIntercoastalRealty
 password9c8b255daf1d29accdc3643af0c35f4bd571b4f5
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Broward County, Florida, USA. Intercoastal Realty is as unique as the customers and homes that we represent. Founded by Beth Beauchamp more than 30 years ago, Intercoastal Realty originally sold only waterfront homes. Over the years, Beth grew a two person office into the dominant real estate company in waterfront neighborhoods of Southeast Fort Lauderdale. This growth came from her focus on market knowledge and personal service which she continues to use to help educate her clients and friends. Beth has also imparted this focus to the real estate professionals of Intercoastal Realty who have helped make her so successful. With changes in the market and demands from clients, Intercoastal Realty has now expanded to represent all types of residential properties, but we still remain the only true waterfront experts. Although our market has changed, our goals remain the same. Intercoastal Realty exclusively represents and promotes the best homes for the finest clients. With hundreds of years of combined local experience, Intercoastal Realty’s team of knowledgeable, professional Realtor associates provide both buyers and sellers the facts and opportunities for success in our one-of-a kind real estate market. Our team approach means we work together and with the entire real estate community to bring buyers and sellers together. Our unmatched knowledge and experience combined with our network of local, regional, national and international real estate affiliates gives us the ability to locate a buyer across the street or around the globe! Joining with Leverage Global Partners expands this national and international reach and provides our clients with even more market knowledge and strength. New Website now available! 2015 WaterWays Magazine - <a href="http://www.waterways.flmag.com/" target="_blank">http://www.waterways.flmag.com/</a>
 communitiesFort Lauderdale Ft Lauderdale Broward County
 websitehttp://www.intercoastalrealty.com
 address1500 East Las Olas Boulevard
 address_2
 cityFort Lauderdale
 stateFL
 full_stateFlorida
 countryUSA
 marketFort Lauderdale
 market_2
 postal_code33301
 phone(954) 467-1448
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJohn Beauchamp
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-john-beauchamp-president-intercoastal-realty/
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename39.jpg
 logo_filename39.png
 contact_image_filename39.jpg
 all_properties_link_image_filename39.jpg
 all_properties_linkhttp://www.intercoastalrealty.com/exclusive
 video_embed_code
 contact_video_embed_code
 meta_titleFort Lauderdale Real Estate | Intercoastal Realty | Leverage Global Partners
 meta_descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Fort Lauderdale, FL, USA.
 meta_keywordsIntercoastal Realty, fort lauderdale real estate, John Beauchamp, leverage global partners
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-07-29 17:01:16
 modified2016-04-08 16:33:30
 dre_num012345
 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)
 id2353
 modelBrokerage
 model_id39
 tagLogo
 name39.png
 typeimage/png
 size21078
 uri/assets/2353.png
 order0
 created2016-03-30 11:38:46
 modified2016-03-30 11:38:46
 MainImage(array)
 id2352
 modelBrokerage
 model_id39
 tagMainImage
 name39.jpg
 typeimage/jpg
 size2792534
 uri/assets/2352.jpg
 order0
 created2016-03-30 11:38:46
 modified2016-03-30 11:38:46
 ContactImage(array)
 id2354
 modelBrokerage
 model_id39
 tagContactImage
 name39.jpg
 typeimage/jpg
 size3420902
 uri/assets/2354.jpg
 order0
 created2016-03-30 11:38:46
 modified2016-03-30 11:38:46
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(array)
 id143
 modelBrokerage
 model_id39
 archived(false)
 medium_featured(false)
 large_featured(false)
 titleMeet John Beauchamp: President, Intercoastal Realty
 authorLeverageRE
 date2013-11-15
 lead_in"My mother, Beth Beauchamp, the founder of Intercoastal Realty, went from housewife to the most successful realtor in Fort Lauderdale," explains John Beauchamp, President of the company. The family atmosphere she created, with its emphasis on providing the highest level of personal service, is still how the office is run today, with an open floor plan and constant interaction amongst the agents. John and Beth, along with his sister-in-law, Torie, make up the Beauchamp Team and are at the helm of the office of 50 real estate professionals, seven days a week.
 body <img class="aligncenter size-full wp-image-1956 pure-img" src="/assets/370.jpg" alt="johnbeauchamporiginal" width="480" height="640" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/johnbeauchamporiginal-225x300.jpg 225w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/johnbeauchamporiginal.jpg 480w" sizes="(max-width: 480px) 100vw, 480px"> The beautiful climate — especially in the winter — along with incredible waterfront property and zero-percent state and local income tax make Fort Lauderdale a huge draw for home buyers. "We are seeing a lot of dual footprints," says John, with people leaving high-tax states and establishing their tax basis in Florida. John and the real estate professionals at Intercoastal Realty are proud to be waterfront experts in the area but work with clients to serve all their real estate needs. <h4>HOW IS ON-LINE MARKETING AND SOCIAL MEDIA PLAYING A ROLE IN YOUR COMPANY?</h4> <blockquote> John: We are in the middle of revamping our corporate website. We are changing from one of the first real estate websites – a Model T, functional but without the new bells and whistles – to a state-of-the-art site that will take advantage of all of the current market trends and tools, and build in social marketing opportunities. I am personally not on Facebook or Twitter, but we do encourage our associates to promote themselves and build their business through social media and networking. Every year we produce a high-gloss, oversized coffee table book of our properties which is distributed throughout South Florida. The online digital edition goes everywhere. It is also linked to our real estate professionals' emails and to all of our online marketing and through QR codes in our print marketing. Digital pictures and words get you interested; however, a computer can't take you around and show you the true feel of a waterfront home and the subtle differences of our waterfront neighborhoods. It is our people, with their experience and knowledge that make Intercoastal Realty successful! </blockquote> <img class="aligncenter size-full wp-image-1954 pure-img" src="/assets/371.jpg" alt="johnbeauchampleverage" width="480" height="360" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/johnbeauchampleverage-300x225.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/johnbeauchampleverage-80x60.jpg 80w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/johnbeauchampleverage.jpg 480w" sizes="(max-width: 480px) 100vw, 480px"> <h4>HOW DO YOUR COLLEAGUES AT INTERCOASTAL REALTY DESCRIBE YOU AS A PARTNER?</h4> <blockquote>John: Available and responsive. When not at my desk I am always available by phone to provide answers, advice or encouragement. As a manager that also sells real estate I go through the same marketing and sales process as our associates. I emphasize the importance of our professionalism, market knowledge and experience that differentiates our people from other agents in our markets.</blockquote> <h4>WHAT DO YOU ENJOY DOING OUTSIDE OF YOUR REAL ESTATE LIFE?</h4> <blockquote>John: I love to travel. My wife and I are Francophiles and we love to rent an apartment in Paris once a year. I have my iPad and computer with me so that I can stay in touch with business.</blockquote> <img class="aligncenter size-large wp-image-1953 pure-img" src="/assets/372.jpg" alt="johnbeauchampboatshowbooth" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/johnbeauchampboatshowbooth-225x300.jpg 225w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/johnbeauchampboatshowbooth-585x780.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/johnbeauchampboatshowbooth.jpg 2448w" sizes="(max-width: 2448px) 100vw, 2448px"> In his leadership role at Intercoastal Realty, John Beauchamp runs the weekly office meetings, encouraging interaction, input and points of view from his agents. They discuss changes in the business, give advice to each other on pricing and marketing, learn from guest speakers from the banking, insurance and other real estate related industries, and promote the team concept to give their clients the absolute best representation. Leverage Global Partners is thrilled to have John Beauchamp and the team at Intercoastal Realty as our partners.
 vimeo_id
 created2016-02-25 14:09:53
 modified2016-04-05 14:41:06
 uri/articles/view/143/meet-john-beauchamp-president-intercoastal-realty
 FeaturedImage(empty)
 Location(array)
 0(array)
 id122
 parent_id8
 brokerage_id39
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameFort Lauderdale, FL, USA
 short_nameFort Lauderdale, FL, USA
 group_index
 latitude26.124271
 longitude-80.128899
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionLooking for sunshine, water, yachting and comfortable easy living? Welcome to Fort Lauderdale!
 long_descriptionThis former spring break destination has grown up to become a magnet for South American, European, Canadian and Americans seeking sunshine, water, yachting and the South Florida lifestyle. Fort Lauderdale has 165 miles of beautiful, navigable waterways, 7 miles of pristine beaches, and more hours of sunshine than almost anywhere on earth! Enjoy world class amenities and services with a small town feel. Where else can you live on the water with your boat docked in your backyard, work in a vibrant downtown, walk the restaurants and boutiques of Las Olas or to the Atlantic Ocean and beach, catch an international flight or Caribbean cruise – all only minutes apart!
 created2016-04-06 10:05:21
 modified2016-04-12 18:32:43
 timezoneAmerica/New_York
 population172389
 uri/locations/view/122/fort-lauderdale-fl-usa
 tile_nameFort Lauderdale, FL, USA
 User(array)
 0(array)
 id87
 typeBrokerageAdmin
 brokerage_id39
 email[email protected]
 password89643ce3fb5a14c231b22d2f6679c06854285065
 recover_hash
 first_nameJohn
 last_nameBeauchamp
 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-14 09:51:58
 created2016-04-08 16:33:30
 notified(true)
 full_nameJohn Beauchamp
 uri/agent-detail/87/john-beauchamp
 profile_complete(true)
 1(array)
 id224
 typeBrokerageAdmin
 brokerage_id39
 email[email protected]
 password3dd8273cc4caa1ff2b16b975718f6d6c961f0ca5
 recover_hash
 first_nameGary
 last_nameDzendzel
 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-14 09:51:05
 created2016-04-14 09:51:05
 notified(false)
 full_nameGary Dzendzel
 uri/agent-detail/224/gary-dzendzel
 profile_complete(true)
 2(array)
 id366
 typeAgent
 brokerage_id39
 email[email protected]
 password504c74d6c830cb31c34de49f69ae1390fe76088c
 recover_hash
 first_nameJohn
 last_nameBeauchamp
 title
 dre_num
 phone954-801-0336
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:49
 created2017-08-07 15:22:49
 notified(false)
 full_nameJohn Beauchamp
 uri/agent-detail/366/john-beauchamp
 profile_complete(true)
 uri/brokerage-detail/39/intercoastal-realty
 website_shortwww.intercoastalrealty.com
 name_with_locationIntercoastal Realty - Fort Lauderdale, FL, USA
 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)
 id18431
 modelProperty
 model_id3202
 tagImage
 name30757.jpg
 typeimage/jpg
 size436805
 uri/assets/18431.jpg
 order0
 created2016-04-07 17:10:04
 modified2016-04-07 17:10:04
 1(array)
 id18425
 modelProperty
 model_id3202
 tagImage
 name30751.jpg
 typeimage/jpg
 size620991
 uri/assets/18425.jpg
 order1
 created2016-04-07 17:10:04
 modified2016-04-07 17:10:04
 2(array)
 id18426
 modelProperty
 model_id3202
 tagImage
 name30752.jpg
 typeimage/jpg
 size711581
 uri/assets/18426.jpg
 order2
 created2016-04-07 17:10:04
 modified2016-04-07 17:10:04
 3(array)
 id18432
 modelProperty
 model_id3202
 tagImage
 name30758.jpg
 typeimage/jpg
 size655629
 uri/assets/18432.jpg
 order3
 created2016-04-07 17:10:04
 modified2016-04-07 17:10:04
 4(array)
 id18429
 modelProperty
 model_id3202
 tagImage
 name30755.jpg
 typeimage/jpg
 size463519
 uri/assets/18429.jpg
 order4
 created2016-04-07 17:10:04
 modified2016-04-07 17:10:04
 5(array)
 id18428
 modelProperty
 model_id3202
 tagImage
 name30754.jpg
 typeimage/jpg
 size506207
 uri/assets/18428.jpg
 order5
 created2016-04-07 17:10:04
 modified2016-04-07 17:10:04
 6(array)
 id18430
 modelProperty
 model_id3202
 tagImage
 name30756.jpg
 typeimage/jpg
 size397493
 uri/assets/18430.jpg
 order6
 created2016-04-07 17:10:04
 modified2016-04-07 17:10:04
 7(array)
 id18433
 modelProperty
 model_id3202
 tagImage
 name30759.jpg
 typeimage/jpg
 size632615
 uri/assets/18433.jpg
 order7
 created2016-04-07 17:10:04
 modified2016-04-07 17:10:04
 8(array)
 id18427
 modelProperty
 model_id3202
 tagImage
 name30753.jpg
 typeimage/jpg
 size792173
 uri/assets/18427.jpg
 order8
 created2016-04-07 17:10:04
 modified2016-04-07 17:10:04
 9(array)
 id18434
 modelProperty
 model_id3202
 tagImage
 name30760.jpg
 typeimage/jpg
 size738874
 uri/assets/18434.jpg
 order9
 created2016-04-07 17:10:04
 modified2016-04-07 17:10:04
 User(array)
 0(array)
 id366
 typeAgent
 brokerage_id39
 email[email protected]
 password504c74d6c830cb31c34de49f69ae1390fe76088c
 recover_hash
 first_nameJohn
 last_nameBeauchamp
 title
 dre_num
 phone954-801-0336
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:49
 created2017-08-07 15:22:49
 notified(false)
 full_nameJohn Beauchamp
 uri/agent-detail/366/john-beauchamp
 profile_complete(true)
 UsersProperty(array)
 id162
 user_id366
 property_id3202
 sort_order0
 Brokerage(array)
 id39
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2405797
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameIntercoastal Realty
 broker_of_record_name
 short_nameIntercoastal Realty
 usernameIntercoastalRealty
 password9c8b255daf1d29accdc3643af0c35f4bd571b4f5
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Broward County, Florida, USA. Intercoastal Realty is as unique as the customers and homes that we represent. Founded by Beth Beauchamp more than 30 years ago, Intercoastal Realty originally sold only waterfront homes. Over the years, Beth grew a two person office into the dominant real estate company in waterfront neighborhoods of Southeast Fort Lauderdale. This growth came from her focus on market knowledge and personal service which she continues to use to help educate her clients and friends. Beth has also imparted this focus to the real estate professionals of Intercoastal Realty who have helped make her so successful. With changes in the market and demands from clients, Intercoastal Realty has now expanded to represent all types of residential properties, but we still remain the only true waterfront experts. Although our market has changed, our goals remain the same. Intercoastal Realty exclusively represents and promotes the best homes for the finest clients. With hundreds of years of combined local experience, Intercoastal Realty’s team of knowledgeable, professional Realtor associates provide both buyers and sellers the facts and opportunities for success in our one-of-a kind real estate market. Our team approach means we work together and with the entire real estate community to bring buyers and sellers together. Our unmatched knowledge and experience combined with our network of local, regional, national and international real estate affiliates gives us the ability to locate a buyer across the street or around the globe! Joining with Leverage Global Partners expands this national and international reach and provides our clients with even more market knowledge and strength. New Website now available! 2015 WaterWays Magazine - <a href="http://www.waterways.flmag.com/" target="_blank">http://www.waterways.flmag.com/</a>
 communitiesFort Lauderdale Ft Lauderdale Broward County
 websitehttp://www.intercoastalrealty.com
 address1500 East Las Olas Boulevard
 address_2
 cityFort Lauderdale
 stateFL
 full_stateFlorida
 countryUSA
 marketFort Lauderdale
 market_2
 postal_code33301
 phone(954) 467-1448
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJohn Beauchamp
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-john-beauchamp-president-intercoastal-realty/
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename39.jpg
 logo_filename39.png
 contact_image_filename39.jpg
 all_properties_link_image_filename39.jpg
 all_properties_linkhttp://www.intercoastalrealty.com/exclusive
 video_embed_code
 contact_video_embed_code
 meta_titleFort Lauderdale Real Estate | Intercoastal Realty | Leverage Global Partners
 meta_descriptionIntercoastal Realty is the exclusive representative for Leverage Global Partners in Fort Lauderdale, FL, USA.
 meta_keywordsIntercoastal Realty, fort lauderdale real estate, John Beauchamp, leverage global partners
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-07-29 17:01:16
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/39/intercoastal-realty
 website_shortwww.intercoastalrealty.com
 name_with_locationIntercoastal Realty
 Image(empty)
 BrokerageLogoOverride(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id17
 nameWaterfront
 additional(false)
 created2016-04-07 14:06:00
 modified2016-04-07 14:06:00
 PropertiesPropertyFeature(array)
 id3887
 property_id3202
 property_feature_id17
 Icon(array)
 id3566
 modelPropertyFeature
 model_id17
 tagIcon
 name145.png
 typeimage/png
 size2066
 uri/assets/3566.png
 order0
 created2016-04-07 14:05:58
 modified2016-04-07 14:06:00
 1(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id3888
 property_id3202
 property_feature_id14
 Icon(array)
 id3563
 modelPropertyFeature
 model_id14
 tagIcon
 name142.png
 typeimage/png
 size2192
 uri/assets/3563.png
 order0
 created2016-04-07 14:04:53
 modified2016-04-07 14:04:55
 2(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id3889
 property_id3202
 property_feature_id1
 Icon(array)
 id3550
 modelPropertyFeature
 model_id1
 tagIcon
 name129.png
 typeimage/png
 size2147
 uri/assets/3550.png
 order0
 created2016-04-07 14:00:24
 modified2016-04-07 14:00:26
 3(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id3890
 property_id3202
 property_feature_id12
 Icon(array)
 id3561
 modelPropertyFeature
 model_id12
 tagIcon
 name140.png
 typeimage/png
 size1464
 uri/assets/3561.png
 order0
 created2016-04-07 14:04:11
 modified2016-04-07 14:04:12
 4(array)
 id3
 nameDock
 additional(false)
 created2016-04-07 14:01:13
 modified2016-04-07 14:01:13
 PropertiesPropertyFeature(array)
 id3891
 property_id3202
 property_feature_id3
 Icon(array)
 id3552
 modelPropertyFeature
 model_id3
 tagIcon
 name131.png
 typeimage/png
 size1818
 uri/assets/3552.png
 order0
 created2016-04-07 14:01:09
 modified2016-04-07 14:01:13
 Topic(empty)
- 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)
 Property(empty)
 User(empty)
 PropertyFeature(empty)
 SecondaryPropertyCategory(empty)
 Topic(empty)
 PrimaryPropertyCategory(empty)
 Brokerage(empty)
 StripeSubscription(empty)
 GlobalReachReport(empty)
 AccountExecutive(empty)
 Logo(empty)
 MainImage(empty)
 ContactImage(empty)
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 Location(empty)
 FeaturedImage(empty)
 Image(empty)
 UsersProperty(empty)
 BrokerageLogoOverride(empty)
 PropertiesSecondaryPropertyCategory(empty)
 PropertiesPropertyFeature(empty)
 Icon(empty)
 PropertiesTopic(empty)
- Loaded Helpers(array)
 0Permission
 1Number
 2SimpleGraph
 3DebugTimer
 4Toolbar
 5Session
 6Text
 7Flash
 8HtmlToolbar
 9Html
 10Form
====

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	/property-detail/3202/444-royal-plaza-drive-fort-lauderdale-fl-33301-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/property-detail/3202/444-royal-plaza-drive-fort-lauderdale-fl-33301-usa
Remote Port	21018
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	162.159.115.42
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
Http Accept Encoding	gzip, br
Http Accept	/
Http Cf Ray	a09e358e8b9d24ea-CMH
Http X Forwarded For	216.73.216.172
Proxy-nokeepalive	1
Ssl Tls Sni	staging2.leveragere.com
Https	on
Passenger Download Native Support Binary	0
Passenger Compile Native Support Binary	0
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Unique Id	aipHWUqFdFKg_eEneUuKxwAAAJc
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	aipHWUqFdFKg_eEneUuKxwAAAJc
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781155673.4697
Request Time	1781155673

====

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
  2APP/Controller/Component/PropertyEmailComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/PropertiesController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/Subscription.php
  1APP/Model/AppModel.php
  2APP/Model/Property.php
  3APP/Model/User.php
  4APP/Model/PropertyFeature.php
  5APP/Model/PropertyCategory.php
  6APP/Model/Topic.php
  7APP/Model/Brokerage.php
  8APP/Model/StripeSubscription.php
  9APP/Model/GlobalReachReport.php
  10APP/Model/Asset.php
  11APP/Model/Article.php
  12APP/Model/Location.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
====

South Las Olas Isles

Represented By: Intercoastal Realty

www.intercoastalrealty.com | License #: 012345

Highlighted Properties

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 23 ms Total Queries: 38 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 23 ms
Total Queries: 38 queries