One of a Kind Waterfront Estate

4 Hampton Close | Westhampton Beach, NY 11978, USA | $5,999,000

6 Beds
6 Baths
1 Half Ba
2.00 Acres
Views
Tennis Court
Swimming Pool
Guest House

This spectacular residence is truly the last of its kind and can never be duplicated. Opportunity abounds to recreate this spectacular waterfront views, endless bulk heading and a private canal for boats and watercraft that is literally one step from the house. The compound features a spectacular main house replete with 6 bedrooms and 6.5 baths and endless amenities, uniquely designed with water views from every room. The pool house features a living room with fireplace, kitchen and waterfront office, steam room and sauna. All just steps from the Koi pond, all surface basketball court and of course, a Har Tru tennis court. On the bayside you will find an enormous bluestone patio with built in barbecue, and heated inground waterfront pool with hot tub and waterfall. The 2 car garage also boasts a guest quarters and fully stocked game room. The property is magnificently landscaped, gated and exceptionally private. This property is shown only by appointment - contact Lawrence Citarelli for information and an appointment.

Represented By: First Hampton International Realty

View On Map Property Website

Highlighted Properties

Spectacular Waterview Residence in Remsenburg

10 Godfrey Lane | Remsenburg, NY 11960
$2,095,000

Designer Penthouse with Sweeping Views

Penthouse | Telluride, CO
$18,000,000

Represented By

Featured Location

Hamptons, NY, USA

The Hamptons, the world's playground for the rich and famous.

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)
  0137
  14-hampton-close-westhampton-beach-ny-11978-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: 7 ms
Total Queries: 34 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` = 137 AND `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`incomplete` = '0' LIMIT 1	1	1	2	maybe slow
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` = 235	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` = 34 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` = 34 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` = 34 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` = 34 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` = 34 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` = 34 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` = 34 AND `MainArticle`.`model` = 'Brokerage'	0	0	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` = (34) 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` = (34)	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` = (34)	2	2	0
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` = (137) ORDER BY `Image`.`order` ASC	3	3	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` = 137 AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	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` = 137 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` = 137 AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	4	4	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` = 14 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	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` = 13 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	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` = 12 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	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` = 5 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` = 137 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` != 137 AND `Property`.`brokerage_id` = 34 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 (3728, 154) ORDER BY `Image`.`order` ASC	15	15	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 (3728, 154) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	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` IN (3728, 154) AND `PropertiesSecondaryPropertyCategory`.`property_category_id` = `SecondaryPropertyCategory`.`id`)	0	0	0
SELECT `PropertyFeature`.`id`, `PropertyFeature`.`name`, `PropertyFeature`.`additional`, `PropertyFeature`.`created`, `PropertyFeature`.`modified`, `PropertiesPropertyFeature`.`id`, `PropertiesPropertyFeature`.`property_id`, `PropertiesPropertyFeature`.`property_feature_id` FROM `leveragere_staging2`.`property_features` AS `PropertyFeature` JOIN `leveragere_staging2`.`properties_property_features` AS `PropertiesPropertyFeature` ON (`PropertiesPropertyFeature`.`property_id` IN (3728, 154) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	3	3	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (3728, 154) 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` = 34 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` = 34 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 (154, 137, 136, 3727) ORDER BY `Image`.`order` ASC	23	23	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 (154, 137, 136, 3727) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	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` IN (154, 137, 136, 3727) 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 (154, 137, 136, 3727) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	10	10	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (154, 137, 136, 3727) 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 12.95 MB

Message	Memory use
Component initialization	3.09 MB
Controller action start	4.02 MB
Controller render start	6.81 MB
View render complete	7.33 MB

Timers

Total Request Time: 236 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	26.89
Event: Controller.initialize	3.88
Event: Controller.startup	1.26
Controller action	47.29
Event: Controller.beforeRender	17.44
» Processing toolbar data	17.30
Rendering View	89.06
» Event: View.beforeRender	0.44
» Rendering APP/View/Properties/view.ctp	5.36
» » Rendering APP/View/Elements/static_property_price.ctp	0.62
» » Rendering APP/View/Elements/property_features.ctp	0.38
» » Rendering APP/View/Elements/static_property_price.ctp #2	0.25
» » Rendering APP/View/Elements/static_property_price.ctp #3	0.26
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.25
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.72
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.26
» » » Rendering APP/View/Elements/static_property_price.ctp #5	0.24
» » » Rendering APP/View/Elements/static_property_price.ctp #6	0.24
» » » Rendering APP/View/Elements/static_property_price.ctp #7	0.26
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.33
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	82.18
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)
 id154
 brokerage_id34
 created_by_user_id0
 order2
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameDesigner Penthouse with Sweeping Views
 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(true)
 large_featured(true)
 detail_page(true)
 descriptionPerched over the charming, historic town of Telluride, Colorado, this peerless 4-bedroom penthouse boasts sweeping 360-degree views of arguably the world’s most magnificent box canyon. Conceived by renowned New York architect and designer Alan Wanzenberg, and built by Telluride’s Fortenberry Construction, this 6,000 plus-sq-ft property encompasses the building’s entire top floor. The quality, design, and location are second to none — humbled only, if at all, by the majesty of the mountain peaks that fill its vistas. There’s simply no other place like it.
 addressPenthouse
 address_2
 cityTelluride
 stateCO
 postal_code
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price18000000
 price_20
 price_usd18000000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet6235
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1views
 icon_2media-room
 icon_3sq-ft
 icon_4balcony-terrace
 icon_5
 icon_6
 website
 meta_titleDesigner Penthouse with Sweeping Views | First Hampton International Realty
 meta_descriptionPenthouse is a property offered for sale in Telluride, CO, USA, presented by First Hampton International Realty
 meta_keywordstelluride real estate, designer penthouse, first hampton international realty, telluride colorado
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldspostal_code, agent_name_1, agent_email_1, latitude, longitude
 invalid_optional_fieldssquare_meters, acres, hectares, agent_phone_1, agent_name_2, agent_email_2, agent_phone_2, bathrooms_partial, year_built, virtual_tour, video_tour, wsj_property_type, nyt_property_type
 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
 created2013-07-21 20:13:46
 uri/property-detail/154/penthouse-telluride-co-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/154/penthouse-telluride-co-usa
 address_concatPenthouse Telluride CO USA
 google_maps_query_stringPenthouse++Telluride+CO++USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 18,000,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty4
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2013-07-21
 overridden_brokerage_nameFirst Hampton International Realty
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id34
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2518253
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameFirst Hampton International Realty
 broker_of_record_name
 short_nameFirst Hampton International Realty
 usernameFirstHampton
 passwordc6d7951ad2b1432ff444a7a5acca6784d6573bb9
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionFirst Hampton International Realty is the exclusive representative for Leverage Global Partners in The Hamptons, New York, USA. Lawrence Citarelli Jr. is a successful, former finance/ economics executive of 14 years and possesses over 17 years of real estate investment and development experience. Mr. Citarelli has forged the Lawrence III Group, The group is comprised of a multi award winning design/construction management firm, Westhampton Partners, a development and acquisition arm and First Hampton International Realty, a global real estate entity. Through the vertical integration of these three entities clients and customers are provided with an experience and service model that is unrivaled in the industry. Mr. Citarelli is also a consummate humanitarian and is aligned with various noteworthy athletes, entertainers and celebrities. He has recently been awarded a congressional award for his international business dealings which are specifically tied to helping the less fortunate children and the communities where he is active.
 communitiesWesthampton Beach Westhampton Quogue Remsenburg hamptons southampton east hampton
 websitehttp://www.firsthamptonrealty.com
 address50 Main Street
 address_2
 cityWesthampton Beach
 stateNY
 full_stateNew York
 countryUSA
 marketHamptons
 market_2
 postal_code11978
 phone(631) 872-0280
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameLawrence Citarelli
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-lawrence-citarelli-principal-first-hampton-realty/
 contact_big_profile_link_text
 contact_titlePrincipal
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename34.jpg
 logo_filename34.jpg
 contact_image_filename34.jpg
 all_properties_link_image_filename34.jpg
 all_properties_linkhttp://www.firsthamptonrealty.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleThe Hamptons Real Estate | First Hampton International Realty | Leverage Global Partners
 meta_descriptionFirst Hampton International Realty is Leverage Global Partners' exclusive representative in the Hamptons, New York, USA.
 meta_keywordsFirst Hampton International Realty, The Hamptons Real Estate, Westhampton beach real estate, Lawrence Citarelli, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-06-07 11:03:46
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/34/first-hampton-international-realty
 website_shortwww.firsthamptonrealty.com
 name_with_locationFirst Hampton International Realty
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id5343
 modelProperty
 model_id154
 tagImage
 name1209.jpg
 typeimage/jpg
 size378215
 uri/assets/5343.jpg
 order0
 created2016-04-07 15:46:25
 modified2016-04-07 15:46:26
 1(array)
 id5344
 modelProperty
 model_id154
 tagImage
 name1210.jpg
 typeimage/jpg
 size466374
 uri/assets/5344.jpg
 order1
 created2016-04-07 15:46:26
 modified2016-04-07 15:46:26
 2(array)
 id5345
 modelProperty
 model_id154
 tagImage
 name1211.jpg
 typeimage/jpg
 size465756
 uri/assets/5345.jpg
 order2
 created2016-04-07 15:46:26
 modified2016-04-07 15:46:26
 3(array)
 id5346
 modelProperty
 model_id154
 tagImage
 name1212.jpg
 typeimage/jpg
 size425262
 uri/assets/5346.jpg
 order3
 created2016-04-07 15:46:26
 modified2016-04-07 15:46:26
 4(array)
 id5347
 modelProperty
 model_id154
 tagImage
 name1213.jpg
 typeimage/jpg
 size355909
 uri/assets/5347.jpg
 order4
 created2016-04-07 15:46:26
 modified2016-04-07 15:46:26
 5(array)
 id5337
 modelProperty
 model_id154
 tagImage
 name1201.jpg
 typeimage/jpg
 size393614
 uri/assets/5337.jpg
 order5
 created2016-04-07 15:46:25
 modified2016-04-07 15:46:25
 6(array)
 id5338
 modelProperty
 model_id154
 tagImage
 name1202.jpg
 typeimage/jpg
 size543776
 uri/assets/5338.jpg
 order6
 created2016-04-07 15:46:25
 modified2016-04-07 15:46:25
 7(array)
 id5339
 modelProperty
 model_id154
 tagImage
 name1203.jpg
 typeimage/jpg
 size369297
 uri/assets/5339.jpg
 order7
 created2016-04-07 15:46:25
 modified2016-04-07 15:46:25
 8(array)
 id5340
 modelProperty
 model_id154
 tagImage
 name1204.jpg
 typeimage/jpg
 size420390
 uri/assets/5340.jpg
 order8
 created2016-04-07 15:46:25
 modified2016-04-07 15:46:25
 9(array)
 id5341
 modelProperty
 model_id154
 tagImage
 name1205.jpg
 typeimage/jpg
 size422965
 uri/assets/5341.jpg
 order9
 created2016-04-07 15:46:25
 modified2016-04-07 15:46:25
 10(array)
 id5342
 modelProperty
 model_id154
 tagImage
 name1207.jpg
 typeimage/jpg
 size519436
 uri/assets/5342.jpg
 order11
 created2016-04-07 15:46:25
 modified2016-04-07 15:46:25
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id505
 property_id154
 property_feature_id1
 1(array)
 id8
 nameMedia Room
 additional(false)
 created2016-04-07 14:03:04
 modified2016-04-07 14:03:04
 PropertiesPropertyFeature(array)
 id504
 property_id154
 property_feature_id8
 2(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id503
 property_id154
 property_feature_id14
 Topic(empty)
 1(array)
 Property(array)
 id137
 brokerage_id34
 created_by_user_id0
 order5
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameOne of a Kind Waterfront Estate
 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)
 descriptionThis spectacular residence is truly the last of its kind and can never be duplicated. Opportunity abounds to recreate this spectacular waterfront views, endless bulk heading and a private canal for boats and watercraft that is literally one step from the house. The compound features a spectacular main house replete with 6 bedrooms and 6.5 baths and endless amenities, uniquely designed with water views from every room. The pool house features a living room with fireplace, kitchen and waterfront office, steam room and sauna. All just steps from the Koi pond, all surface basketball court and of course, a Har Tru tennis court. On the bayside you will find an enormous bluestone patio with built in barbecue, and heated inground waterfront pool with hot tub and waterfall. The 2 car garage also boasts a guest quarters and fully stocked game room. The property is magnificently landscaped, gated and exceptionally private. This property is shown only by appointment - contact Lawrence Citarelli for information and an appointment.
 address4 Hampton Close
 address_2
 cityWesthampton Beach
 stateNY
 postal_code11978
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price5999000
 price_20
 price_usd5999000
 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)
 bedrooms6
 bedrooms_20
 bathrooms6
 bathrooms_20
 no_beds_baths(false)
 square_feet5600
 square_meters
 acres2
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size2
 icon_1views
 icon_2tennis
 icon_3pool
 icon_4guest-house
 icon_5
 icon_6
 websitehttp://www.hreo.com/html/out_large.jsp?bts=0&innum=19653&inlist=19653&searchType=home&sortOrder=1&vtsort=&limit=4&styles=
 meta_titleThe Hamptons Real Estate | 4 Hampton Close | First Hampton International Realty
 meta_description4 Hampton Close is a property offered for sale in Westhampton Beach, NY, USA, presented by First Hampton International Realty
 meta_keywordsThe Hamptons Real Estate, 4 Hampton Close, First Hampton International Realty, Leverage Global Partners, ONE OF A KIND WATERFRONT ON WESTHAMPTON BEACH
 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_fieldsagent_1_id, latitude, longitude
 invalid_optional_fieldsagent_2_id, square_meters, hectares, year_built, virtual_tour, video_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
 created2013-06-19 10:25:56
 uri/property-detail/137/4-hampton-close-westhampton-beach-ny-11978-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/137/4-hampton-close-westhampton-beach-ny-11978-usa
 address_concat4 Hampton Close Westhampton Beach NY 11978 USA
 google_maps_query_string4+Hampton+Close++Westhampton+Beach+NY+11978+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 5,999,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty6
 bathrooms_pretty6
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms6
 date_listed2013-06-19
 overridden_brokerage_nameFirst Hampton International Realty
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id34
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2518253
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameFirst Hampton International Realty
 broker_of_record_name
 short_nameFirst Hampton International Realty
 usernameFirstHampton
 passwordc6d7951ad2b1432ff444a7a5acca6784d6573bb9
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionFirst Hampton International Realty is the exclusive representative for Leverage Global Partners in The Hamptons, New York, USA. Lawrence Citarelli Jr. is a successful, former finance/ economics executive of 14 years and possesses over 17 years of real estate investment and development experience. Mr. Citarelli has forged the Lawrence III Group, The group is comprised of a multi award winning design/construction management firm, Westhampton Partners, a development and acquisition arm and First Hampton International Realty, a global real estate entity. Through the vertical integration of these three entities clients and customers are provided with an experience and service model that is unrivaled in the industry. Mr. Citarelli is also a consummate humanitarian and is aligned with various noteworthy athletes, entertainers and celebrities. He has recently been awarded a congressional award for his international business dealings which are specifically tied to helping the less fortunate children and the communities where he is active.
 communitiesWesthampton Beach Westhampton Quogue Remsenburg hamptons southampton east hampton
 websitehttp://www.firsthamptonrealty.com
 address50 Main Street
 address_2
 cityWesthampton Beach
 stateNY
 full_stateNew York
 countryUSA
 marketHamptons
 market_2
 postal_code11978
 phone(631) 872-0280
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameLawrence Citarelli
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-lawrence-citarelli-principal-first-hampton-realty/
 contact_big_profile_link_text
 contact_titlePrincipal
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename34.jpg
 logo_filename34.jpg
 contact_image_filename34.jpg
 all_properties_link_image_filename34.jpg
 all_properties_linkhttp://www.firsthamptonrealty.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleThe Hamptons Real Estate | First Hampton International Realty | Leverage Global Partners
 meta_descriptionFirst Hampton International Realty is Leverage Global Partners' exclusive representative in the Hamptons, New York, USA.
 meta_keywordsFirst Hampton International Realty, The Hamptons Real Estate, Westhampton beach real estate, Lawrence Citarelli, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-06-07 11:03:46
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/34/first-hampton-international-realty
 website_shortwww.firsthamptonrealty.com
 name_with_locationFirst Hampton International Realty
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id4563
 modelProperty
 model_id137
 tagImage
 name1042.jpg
 typeimage/jpg
 size747928
 uri/assets/4563.jpg
 order0
 created2016-04-07 15:01:10
 modified2016-04-07 15:01:10
 1(array)
 id4564
 modelProperty
 model_id137
 tagImage
 name1043.jpg
 typeimage/jpg
 size385581
 uri/assets/4564.jpg
 order1
 created2016-04-07 15:01:10
 modified2016-04-07 15:01:10
 2(array)
 id4565
 modelProperty
 model_id137
 tagImage
 name1044.jpg
 typeimage/jpg
 size794334
 uri/assets/4565.jpg
 order2
 created2016-04-07 15:01:10
 modified2016-04-07 15:01:10
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id300
 property_id137
 property_feature_id14
 1(array)
 id13
 nameTennis Court
 additional(false)
 created2016-04-07 14:04:41
 modified2016-04-07 14:04:41
 PropertiesPropertyFeature(array)
 id301
 property_id137
 property_feature_id13
 2(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id302
 property_id137
 property_feature_id12
 3(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id303
 property_id137
 property_feature_id5
 Topic(empty)
 2(array)
 Property(array)
 id136
 brokerage_id34
 created_by_user_id0
 order4
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameLast of the Large Remsenburg Estates
 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)
 descriptionA long gated driveway surrounded by a meticulously manicured landscaping leads to one of the East Ends most spectacular waterfront estates. Situated on 4.4 park like acres, the main house offers 10,000 square feet of unparalleled luxury. This home features a 2 story living room, formal dining room and a large country kitchen with walk in pantry. There is an oak paneled office with bath, library and a garden room leading to the patio and hot tub. The master suite is extraordinary with domed ceiling, fireplace, exercise room, bathroom with jacuzzi, heated limestone floors and a steam shower. In addition, there is a junior master on the first floor and 3 additional guest suites. The rest of the property is unequaled featuring a heated gunite swimming pool, all weather tennis court, three beautiful ponds, extensive patios and walkways, yoga/exercise studio and a guest house with a sitting room, bedroom, bath and 2 car garage. Finally, there is a deep water dock that offers ample room for multiple boats.
 addressEast End
 address_2
 cityRemsenburg
 stateNY
 postal_code11960
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price3999000
 price_20
 price_usd3999000
 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)
 bedrooms6
 bedrooms_20
 bathrooms6
 bathrooms_20
 no_beds_baths(false)
 square_feet10000
 square_meters
 acres4
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size4
 icon_1acreage
 icon_2pool
 icon_3dock
 icon_4guest-house
 icon_5
 icon_6
 website
 meta_titleThe Hamptons Real Estate | Remsenburg Estates | First Hampton International Realty
 meta_descriptionEast End is a property offered for sale in Remsenburg, NY, USA, presented by First Hampton International Realty
 meta_keywordsThe Hamptons Real Estate, Remsenburg Estates, First Hampton International Realty, Leverage Global Partners, LAST OF THE LARGE REMSENBURG ESTATES ON 4.4 ACRES
 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_fieldsagent_1_id, latitude, longitude
 invalid_optional_fieldsagent_2_id, square_meters, hectares, year_built, virtual_tour, video_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
 created2013-06-19 10:20:02
 uri/property-detail/136/east-end-remsenburg-ny-11960-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/136/east-end-remsenburg-ny-11960-usa
 address_concatEast End Remsenburg NY 11960 USA
 google_maps_query_stringEast+End++Remsenburg+NY+11960+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 3,999,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty6
 bathrooms_pretty6
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms6
 date_listed2013-06-19
 overridden_brokerage_nameFirst Hampton International Realty
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id34
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2518253
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameFirst Hampton International Realty
 broker_of_record_name
 short_nameFirst Hampton International Realty
 usernameFirstHampton
 passwordc6d7951ad2b1432ff444a7a5acca6784d6573bb9
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionFirst Hampton International Realty is the exclusive representative for Leverage Global Partners in The Hamptons, New York, USA. Lawrence Citarelli Jr. is a successful, former finance/ economics executive of 14 years and possesses over 17 years of real estate investment and development experience. Mr. Citarelli has forged the Lawrence III Group, The group is comprised of a multi award winning design/construction management firm, Westhampton Partners, a development and acquisition arm and First Hampton International Realty, a global real estate entity. Through the vertical integration of these three entities clients and customers are provided with an experience and service model that is unrivaled in the industry. Mr. Citarelli is also a consummate humanitarian and is aligned with various noteworthy athletes, entertainers and celebrities. He has recently been awarded a congressional award for his international business dealings which are specifically tied to helping the less fortunate children and the communities where he is active.
 communitiesWesthampton Beach Westhampton Quogue Remsenburg hamptons southampton east hampton
 websitehttp://www.firsthamptonrealty.com
 address50 Main Street
 address_2
 cityWesthampton Beach
 stateNY
 full_stateNew York
 countryUSA
 marketHamptons
 market_2
 postal_code11978
 phone(631) 872-0280
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameLawrence Citarelli
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-lawrence-citarelli-principal-first-hampton-realty/
 contact_big_profile_link_text
 contact_titlePrincipal
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename34.jpg
 logo_filename34.jpg
 contact_image_filename34.jpg
 all_properties_link_image_filename34.jpg
 all_properties_linkhttp://www.firsthamptonrealty.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleThe Hamptons Real Estate | First Hampton International Realty | Leverage Global Partners
 meta_descriptionFirst Hampton International Realty is Leverage Global Partners' exclusive representative in the Hamptons, New York, USA.
 meta_keywordsFirst Hampton International Realty, The Hamptons Real Estate, Westhampton beach real estate, Lawrence Citarelli, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-06-07 11:03:46
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/34/first-hampton-international-realty
 website_shortwww.firsthamptonrealty.com
 name_with_locationFirst Hampton International Realty
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id4561
 modelProperty
 model_id136
 tagImage
 name1041.jpg
 typeimage/jpg
 size1541532
 uri/assets/4561.jpg
 order0
 created2016-04-07 15:01:10
 modified2016-04-07 15:01:10
 1(array)
 id4562
 modelProperty
 model_id136
 tagImage
 name1045.jpg
 typeimage/jpg
 size1197633
 uri/assets/4562.jpg
 order1
 created2016-04-07 15:01:10
 modified2016-04-07 15:01:10
 2(array)
 id4557
 modelProperty
 model_id136
 tagImage
 name1036.jpg
 typeimage/jpg
 size1257840
 uri/assets/4557.jpg
 order2
 created2016-04-07 15:01:10
 modified2016-04-07 15:01:10
 3(array)
 id4558
 modelProperty
 model_id136
 tagImage
 name1037.jpg
 typeimage/jpg
 size1284555
 uri/assets/4558.jpg
 order3
 created2016-04-07 15:01:10
 modified2016-04-07 15:01:10
 4(array)
 id4559
 modelProperty
 model_id136
 tagImage
 name1038.jpg
 typeimage/jpg
 size1403912
 uri/assets/4559.jpg
 order4
 created2016-04-07 15:01:10
 modified2016-04-07 15:01:10
 5(array)
 id4560
 modelProperty
 model_id136
 tagImage
 name1040.jpg
 typeimage/jpg
 size504710
 uri/assets/4560.jpg
 order5
 created2016-04-07 15:01:10
 modified2016-04-07 15:01:10
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id297
 property_id136
 property_feature_id12
 1(array)
 id3
 nameDock
 additional(false)
 created2016-04-07 14:01:13
 modified2016-04-07 14:01:13
 PropertiesPropertyFeature(array)
 id298
 property_id136
 property_feature_id3
 2(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id299
 property_id136
 property_feature_id5
 Topic(empty)
 3(array)
 Property(array)
 id3727
 brokerage_id34
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameHistoric Home In The Estate Section
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(false)
 descriptionHistoric Traditional Designed & Built For 4 Time Ny Governor & Presidential Candidate Alfred E. Smith; 6 Bdrms, 4.5 Baths, Gourmet Kitchen, Formal Living & Dining Rooms, Sun Room, Media Room, Private Loft/Office & Conference Room. Over An Acre W/ Lush Landscaping, Beautiful Specimen Trees, In Ground Pool, Pool House & All Weather Tennis Court. Truly Your Own Summer Resort!
 address14 Halsey Avenue
 address_2
 cityWesthampton Beach
 stateNY
 postal_code11978
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price3399000
 price_20
 price_usd3399000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms0
 bedrooms_20
 bathrooms0
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude40.805931
 longitude-72.658035
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-04-14 13:41:32
 uri/property-detail/3727/14-halsey-avenue-westhampton-beach-ny-11978-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3727/14-halsey-avenue-westhampton-beach-ny-11978-usa
 address_concat14 Halsey Avenue Westhampton Beach NY 11978 USA
 google_maps_query_string14+Halsey+Avenue++Westhampton+Beach+NY+11978+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 3,399,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty0
 bathrooms_pretty0
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms0
 date_listed2016-04-14
 overridden_brokerage_nameFirst Hampton International Realty
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id34
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2518253
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameFirst Hampton International Realty
 broker_of_record_name
 short_nameFirst Hampton International Realty
 usernameFirstHampton
 passwordc6d7951ad2b1432ff444a7a5acca6784d6573bb9
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionFirst Hampton International Realty is the exclusive representative for Leverage Global Partners in The Hamptons, New York, USA. Lawrence Citarelli Jr. is a successful, former finance/ economics executive of 14 years and possesses over 17 years of real estate investment and development experience. Mr. Citarelli has forged the Lawrence III Group, The group is comprised of a multi award winning design/construction management firm, Westhampton Partners, a development and acquisition arm and First Hampton International Realty, a global real estate entity. Through the vertical integration of these three entities clients and customers are provided with an experience and service model that is unrivaled in the industry. Mr. Citarelli is also a consummate humanitarian and is aligned with various noteworthy athletes, entertainers and celebrities. He has recently been awarded a congressional award for his international business dealings which are specifically tied to helping the less fortunate children and the communities where he is active.
 communitiesWesthampton Beach Westhampton Quogue Remsenburg hamptons southampton east hampton
 websitehttp://www.firsthamptonrealty.com
 address50 Main Street
 address_2
 cityWesthampton Beach
 stateNY
 full_stateNew York
 countryUSA
 marketHamptons
 market_2
 postal_code11978
 phone(631) 872-0280
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameLawrence Citarelli
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-lawrence-citarelli-principal-first-hampton-realty/
 contact_big_profile_link_text
 contact_titlePrincipal
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename34.jpg
 logo_filename34.jpg
 contact_image_filename34.jpg
 all_properties_link_image_filename34.jpg
 all_properties_linkhttp://www.firsthamptonrealty.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleThe Hamptons Real Estate | First Hampton International Realty | Leverage Global Partners
 meta_descriptionFirst Hampton International Realty is Leverage Global Partners' exclusive representative in the Hamptons, New York, USA.
 meta_keywordsFirst Hampton International Realty, The Hamptons Real Estate, Westhampton beach real estate, Lawrence Citarelli, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-06-07 11:03:46
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/34/first-hampton-international-realty
 website_shortwww.firsthamptonrealty.com
 name_with_locationFirst Hampton International Realty
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id20816
 modelProperty
 model_id3727
 tagImage
 nameHalsey-TREE.jpg
 typeimage/jpeg
 size2357806
 uri/assets/20816.jpg
 order0
 created2016-04-14 13:40:50
 modified2016-04-14 13:41:32
 1(array)
 id20817
 modelProperty
 model_id3727
 tagImage
 nameWAR-ROOM-1.jpg
 typeimage/jpeg
 size1735454
 uri/assets/20817.jpg
 order1
 created2016-04-14 13:41:14
 modified2016-04-14 13:41:32
 2(array)
 id20818
 modelProperty
 model_id3727
 tagImage
 namePOOL.jpg
 typeimage/jpeg
 size2027846
 uri/assets/20818.jpg
 order2
 created2016-04-14 13:41:27
 modified2016-04-14 13:41:32
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
- sidebar_locations(array)
 0(array)
 Location(array)
 id143
 parent_id7
 brokerage_id34
 typeExclusive
 archived(false)
 use_as_topic(true)
 nameHamptons, NY, USA
 short_nameHamptons, NY, USA
 group_index
 latitude40.924618
 longitude-72.354790
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description The Hamptons, the world's playground for the rich and famous.
 long_descriptionThe absolute bastion of luxury and real estate opulence. The Hamptons has been the home of America's most expensive and resilient real estate since the turn of the 20th Century. Located just 90 miles from the financial center of the world, New York City, the East End is the preferred resort community for businessmen and celebrities alike. A collection of small, unique towns and hamlets, the area is home to world renown restaurants, designer boutiques, unparalleled entertainment and of course the east coast's most beautiful ocean beaches. A true paradise and one of the most sought after real estate markets.
 created2016-04-07 16:14:57
 modified2016-04-14 10:51:05
 timezoneAmerica/New_York
 population15000
 uri/locations/view/143/hamptons-ny-usa
 tile_nameHamptons, NY, USA
 Brokerage(array)
 id34
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2518253
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameFirst Hampton International Realty
 broker_of_record_name
 short_nameFirst Hampton International Realty
 usernameFirstHampton
 passwordc6d7951ad2b1432ff444a7a5acca6784d6573bb9
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionFirst Hampton International Realty is the exclusive representative for Leverage Global Partners in The Hamptons, New York, USA. Lawrence Citarelli Jr. is a successful, former finance/ economics executive of 14 years and possesses over 17 years of real estate investment and development experience. Mr. Citarelli has forged the Lawrence III Group, The group is comprised of a multi award winning design/construction management firm, Westhampton Partners, a development and acquisition arm and First Hampton International Realty, a global real estate entity. Through the vertical integration of these three entities clients and customers are provided with an experience and service model that is unrivaled in the industry. Mr. Citarelli is also a consummate humanitarian and is aligned with various noteworthy athletes, entertainers and celebrities. He has recently been awarded a congressional award for his international business dealings which are specifically tied to helping the less fortunate children and the communities where he is active.
 communitiesWesthampton Beach Westhampton Quogue Remsenburg hamptons southampton east hampton
 websitehttp://www.firsthamptonrealty.com
 address50 Main Street
 address_2
 cityWesthampton Beach
 stateNY
 full_stateNew York
 countryUSA
 marketHamptons
 market_2
 postal_code11978
 phone(631) 872-0280
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameLawrence Citarelli
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-lawrence-citarelli-principal-first-hampton-realty/
 contact_big_profile_link_text
 contact_titlePrincipal
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename34.jpg
 logo_filename34.jpg
 contact_image_filename34.jpg
 all_properties_link_image_filename34.jpg
 all_properties_linkhttp://www.firsthamptonrealty.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleThe Hamptons Real Estate | First Hampton International Realty | Leverage Global Partners
 meta_descriptionFirst Hampton International Realty is Leverage Global Partners' exclusive representative in the Hamptons, New York, USA.
 meta_keywordsFirst Hampton International Realty, The Hamptons Real Estate, Westhampton beach real estate, Lawrence Citarelli, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-06-07 11:03:46
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/34/first-hampton-international-realty
 website_shortwww.firsthamptonrealty.com
 name_with_locationFirst Hampton International Realty
 Image(array)
 id9030
 modelLocation
 model_id143
 tagImage
 nameHamptons.jpg
 typeimage/jpeg
 size240646
 uri/assets/9030.jpg
 order0
 created2016-04-07 16:12:57
 modified2016-04-14 10:51:05
- highlighted_properties(array)
 0(array)
 Property(array)
 id3728
 brokerage_id34
 created_by_user_id0
 order1
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameSpectacular Waterview Residence in Remsenburg
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(false)
 descriptionThis Custom Everything 5 Bed, 5.5 Bath Including Separate Studio with Full Bath Is Located On 1.25 Preserved Waterfront Acres. The Generous Open Floor Plane With Custom Kitchen, Dining Room, Living Room, Great Room Offer A Sunlight Filled, Nature Embodied Feel And Lifestyle. Grand Vaulted/Custom Paneled Foyer, Wet Bar, Screen Porch & Immense Upper Deck Offer An Amazing Experience. Geo Therm, Leed Cert.
 address10 Godfrey Lane
 address_2
 cityRemsenburg
 stateNY
 postal_code11960
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2095000
 price_20
 price_usd2095000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms0
 bedrooms_20
 bathrooms0
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude40.803612
 longitude-72.702446
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id2
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2019-08-22 10:12:57
 created2016-04-14 13:54:20
 uri/property-detail/3728/10-godfrey-lane-remsenburg-ny-11960-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3728/10-godfrey-lane-remsenburg-ny-11960-usa
 address_concat10 Godfrey Lane Remsenburg NY 11960 USA
 google_maps_query_string10+Godfrey+Lane++Remsenburg+NY+11960+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,095,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty0
 bathrooms_pretty0
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms0
 date_listed2016-04-14
 overridden_brokerage_nameFirst Hampton International Realty
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id2
 nameVacation Homes
 created2019-08-22 10:07:58
 modified2019-08-29 09:59:17
 uri/category-detail/2/vacation-homes
 Brokerage(array)
 id34
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2518253
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameFirst Hampton International Realty
 broker_of_record_name
 short_nameFirst Hampton International Realty
 usernameFirstHampton
 passwordc6d7951ad2b1432ff444a7a5acca6784d6573bb9
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionFirst Hampton International Realty is the exclusive representative for Leverage Global Partners in The Hamptons, New York, USA. Lawrence Citarelli Jr. is a successful, former finance/ economics executive of 14 years and possesses over 17 years of real estate investment and development experience. Mr. Citarelli has forged the Lawrence III Group, The group is comprised of a multi award winning design/construction management firm, Westhampton Partners, a development and acquisition arm and First Hampton International Realty, a global real estate entity. Through the vertical integration of these three entities clients and customers are provided with an experience and service model that is unrivaled in the industry. Mr. Citarelli is also a consummate humanitarian and is aligned with various noteworthy athletes, entertainers and celebrities. He has recently been awarded a congressional award for his international business dealings which are specifically tied to helping the less fortunate children and the communities where he is active.
 communitiesWesthampton Beach Westhampton Quogue Remsenburg hamptons southampton east hampton
 websitehttp://www.firsthamptonrealty.com
 address50 Main Street
 address_2
 cityWesthampton Beach
 stateNY
 full_stateNew York
 countryUSA
 marketHamptons
 market_2
 postal_code11978
 phone(631) 872-0280
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameLawrence Citarelli
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-lawrence-citarelli-principal-first-hampton-realty/
 contact_big_profile_link_text
 contact_titlePrincipal
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename34.jpg
 logo_filename34.jpg
 contact_image_filename34.jpg
 all_properties_link_image_filename34.jpg
 all_properties_linkhttp://www.firsthamptonrealty.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleThe Hamptons Real Estate | First Hampton International Realty | Leverage Global Partners
 meta_descriptionFirst Hampton International Realty is Leverage Global Partners' exclusive representative in the Hamptons, New York, USA.
 meta_keywordsFirst Hampton International Realty, The Hamptons Real Estate, Westhampton beach real estate, Lawrence Citarelli, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-06-07 11:03:46
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/34/first-hampton-international-realty
 website_shortwww.firsthamptonrealty.com
 name_with_locationFirst Hampton International Realty
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id20819
 modelProperty
 model_id3728
 tagImage
 nameGodfrey-GOOD-FRONT.jpg
 typeimage/jpeg
 size1188933
 uri/assets/20819.jpg
 order0
 created2016-04-14 13:52:42
 modified2016-04-14 13:54:20
 1(array)
 id20820
 modelProperty
 model_id3728
 tagImage
 nameGODFREY-BACK.jpg
 typeimage/jpeg
 size1885785
 uri/assets/20820.jpg
 order1
 created2016-04-14 13:52:57
 modified2016-04-14 13:54:20
 2(array)
 id20821
 modelProperty
 model_id3728
 tagImage
 nameKitchen-2.jpg
 typeimage/jpeg
 size173504
 uri/assets/20821.jpg
 order2
 created2016-04-14 13:53:55
 modified2016-04-14 13:54:20
 3(array)
 id20822
 modelProperty
 model_id3728
 tagImage
 nameStaircase-2.jpg
 typeimage/jpeg
 size149585
 uri/assets/20822.jpg
 order3
 created2016-04-14 13:54:18
 modified2016-04-14 13:54:20
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 1(array)
 Property(array)
 id154
 brokerage_id34
 created_by_user_id0
 order2
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameDesigner Penthouse with Sweeping Views
 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(true)
 large_featured(true)
 detail_page(true)
 descriptionPerched over the charming, historic town of Telluride, Colorado, this peerless 4-bedroom penthouse boasts sweeping 360-degree views of arguably the world’s most magnificent box canyon. Conceived by renowned New York architect and designer Alan Wanzenberg, and built by Telluride’s Fortenberry Construction, this 6,000 plus-sq-ft property encompasses the building’s entire top floor. The quality, design, and location are second to none — humbled only, if at all, by the majesty of the mountain peaks that fill its vistas. There’s simply no other place like it.
 addressPenthouse
 address_2
 cityTelluride
 stateCO
 postal_code
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price18000000
 price_20
 price_usd18000000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet6235
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1views
 icon_2media-room
 icon_3sq-ft
 icon_4balcony-terrace
 icon_5
 icon_6
 website
 meta_titleDesigner Penthouse with Sweeping Views | First Hampton International Realty
 meta_descriptionPenthouse is a property offered for sale in Telluride, CO, USA, presented by First Hampton International Realty
 meta_keywordstelluride real estate, designer penthouse, first hampton international realty, telluride colorado
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldspostal_code, agent_name_1, agent_email_1, latitude, longitude
 invalid_optional_fieldssquare_meters, acres, hectares, agent_phone_1, agent_name_2, agent_email_2, agent_phone_2, bathrooms_partial, year_built, virtual_tour, video_tour, wsj_property_type, nyt_property_type
 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
 created2013-07-21 20:13:46
 uri/property-detail/154/penthouse-telluride-co-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/154/penthouse-telluride-co-usa
 address_concatPenthouse Telluride CO USA
 google_maps_query_stringPenthouse++Telluride+CO++USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 18,000,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty4
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2013-07-21
 overridden_brokerage_nameFirst Hampton International Realty
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id34
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2518253
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameFirst Hampton International Realty
 broker_of_record_name
 short_nameFirst Hampton International Realty
 usernameFirstHampton
 passwordc6d7951ad2b1432ff444a7a5acca6784d6573bb9
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionFirst Hampton International Realty is the exclusive representative for Leverage Global Partners in The Hamptons, New York, USA. Lawrence Citarelli Jr. is a successful, former finance/ economics executive of 14 years and possesses over 17 years of real estate investment and development experience. Mr. Citarelli has forged the Lawrence III Group, The group is comprised of a multi award winning design/construction management firm, Westhampton Partners, a development and acquisition arm and First Hampton International Realty, a global real estate entity. Through the vertical integration of these three entities clients and customers are provided with an experience and service model that is unrivaled in the industry. Mr. Citarelli is also a consummate humanitarian and is aligned with various noteworthy athletes, entertainers and celebrities. He has recently been awarded a congressional award for his international business dealings which are specifically tied to helping the less fortunate children and the communities where he is active.
 communitiesWesthampton Beach Westhampton Quogue Remsenburg hamptons southampton east hampton
 websitehttp://www.firsthamptonrealty.com
 address50 Main Street
 address_2
 cityWesthampton Beach
 stateNY
 full_stateNew York
 countryUSA
 marketHamptons
 market_2
 postal_code11978
 phone(631) 872-0280
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameLawrence Citarelli
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-lawrence-citarelli-principal-first-hampton-realty/
 contact_big_profile_link_text
 contact_titlePrincipal
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename34.jpg
 logo_filename34.jpg
 contact_image_filename34.jpg
 all_properties_link_image_filename34.jpg
 all_properties_linkhttp://www.firsthamptonrealty.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleThe Hamptons Real Estate | First Hampton International Realty | Leverage Global Partners
 meta_descriptionFirst Hampton International Realty is Leverage Global Partners' exclusive representative in the Hamptons, New York, USA.
 meta_keywordsFirst Hampton International Realty, The Hamptons Real Estate, Westhampton beach real estate, Lawrence Citarelli, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-06-07 11:03:46
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/34/first-hampton-international-realty
 website_shortwww.firsthamptonrealty.com
 name_with_locationFirst Hampton International Realty
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id5343
 modelProperty
 model_id154
 tagImage
 name1209.jpg
 typeimage/jpg
 size378215
 uri/assets/5343.jpg
 order0
 created2016-04-07 15:46:25
 modified2016-04-07 15:46:26
 1(array)
 id5344
 modelProperty
 model_id154
 tagImage
 name1210.jpg
 typeimage/jpg
 size466374
 uri/assets/5344.jpg
 order1
 created2016-04-07 15:46:26
 modified2016-04-07 15:46:26
 2(array)
 id5345
 modelProperty
 model_id154
 tagImage
 name1211.jpg
 typeimage/jpg
 size465756
 uri/assets/5345.jpg
 order2
 created2016-04-07 15:46:26
 modified2016-04-07 15:46:26
 3(array)
 id5346
 modelProperty
 model_id154
 tagImage
 name1212.jpg
 typeimage/jpg
 size425262
 uri/assets/5346.jpg
 order3
 created2016-04-07 15:46:26
 modified2016-04-07 15:46:26
 4(array)
 id5347
 modelProperty
 model_id154
 tagImage
 name1213.jpg
 typeimage/jpg
 size355909
 uri/assets/5347.jpg
 order4
 created2016-04-07 15:46:26
 modified2016-04-07 15:46:26
 5(array)
 id5337
 modelProperty
 model_id154
 tagImage
 name1201.jpg
 typeimage/jpg
 size393614
 uri/assets/5337.jpg
 order5
 created2016-04-07 15:46:25
 modified2016-04-07 15:46:25
 6(array)
 id5338
 modelProperty
 model_id154
 tagImage
 name1202.jpg
 typeimage/jpg
 size543776
 uri/assets/5338.jpg
 order6
 created2016-04-07 15:46:25
 modified2016-04-07 15:46:25
 7(array)
 id5339
 modelProperty
 model_id154
 tagImage
 name1203.jpg
 typeimage/jpg
 size369297
 uri/assets/5339.jpg
 order7
 created2016-04-07 15:46:25
 modified2016-04-07 15:46:25
 8(array)
 id5340
 modelProperty
 model_id154
 tagImage
 name1204.jpg
 typeimage/jpg
 size420390
 uri/assets/5340.jpg
 order8
 created2016-04-07 15:46:25
 modified2016-04-07 15:46:25
 9(array)
 id5341
 modelProperty
 model_id154
 tagImage
 name1205.jpg
 typeimage/jpg
 size422965
 uri/assets/5341.jpg
 order9
 created2016-04-07 15:46:25
 modified2016-04-07 15:46:25
 10(array)
 id5342
 modelProperty
 model_id154
 tagImage
 name1207.jpg
 typeimage/jpg
 size519436
 uri/assets/5342.jpg
 order11
 created2016-04-07 15:46:25
 modified2016-04-07 15:46:25
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id505
 property_id154
 property_feature_id1
 1(array)
 id8
 nameMedia Room
 additional(false)
 created2016-04-07 14:03:04
 modified2016-04-07 14:03:04
 PropertiesPropertyFeature(array)
 id504
 property_id154
 property_feature_id8
 2(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id503
 property_id154
 property_feature_id14
 Topic(empty)
- custom_ga_event_properties(array)
 brokerageFirst Hampton International Realty, Westhampton Beach
- property(array)
 Property(array)
 id137
 brokerage_id34
 created_by_user_id0
 order5
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameOne of a Kind Waterfront Estate
 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)
 descriptionThis spectacular residence is truly the last of its kind and can never be duplicated. Opportunity abounds to recreate this spectacular waterfront views, endless bulk heading and a private canal for boats and watercraft that is literally one step from the house. The compound features a spectacular main house replete with 6 bedrooms and 6.5 baths and endless amenities, uniquely designed with water views from every room. The pool house features a living room with fireplace, kitchen and waterfront office, steam room and sauna. All just steps from the Koi pond, all surface basketball court and of course, a Har Tru tennis court. On the bayside you will find an enormous bluestone patio with built in barbecue, and heated inground waterfront pool with hot tub and waterfall. The 2 car garage also boasts a guest quarters and fully stocked game room. The property is magnificently landscaped, gated and exceptionally private. This property is shown only by appointment - contact Lawrence Citarelli for information and an appointment.
 address4 Hampton Close
 address_2
 cityWesthampton Beach
 stateNY
 postal_code11978
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price5999000
 price_20
 price_usd5999000
 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)
 bedrooms6
 bedrooms_20
 bathrooms6
 bathrooms_20
 no_beds_baths(false)
 square_feet5600
 square_meters
 acres2
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size2
 icon_1views
 icon_2tennis
 icon_3pool
 icon_4guest-house
 icon_5
 icon_6
 websitehttp://www.hreo.com/html/out_large.jsp?bts=0&innum=19653&inlist=19653&searchType=home&sortOrder=1&vtsort=&limit=4&styles=
 meta_titleThe Hamptons Real Estate | 4 Hampton Close | First Hampton International Realty
 meta_description4 Hampton Close is a property offered for sale in Westhampton Beach, NY, USA, presented by First Hampton International Realty
 meta_keywordsThe Hamptons Real Estate, 4 Hampton Close, First Hampton International Realty, Leverage Global Partners, ONE OF A KIND WATERFRONT ON WESTHAMPTON BEACH
 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_fieldsagent_1_id, latitude, longitude
 invalid_optional_fieldsagent_2_id, square_meters, hectares, year_built, virtual_tour, video_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
 created2013-06-19 10:25:56
 uri/property-detail/137/4-hampton-close-westhampton-beach-ny-11978-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/137/4-hampton-close-westhampton-beach-ny-11978-usa
 address_concat4 Hampton Close Westhampton Beach NY 11978 USA
 google_maps_query_string4+Hampton+Close++Westhampton+Beach+NY+11978+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 5,999,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty6
 bathrooms_pretty6
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms6
 date_listed2013-06-19
 overridden_brokerage_nameFirst Hampton International Realty
 overridden_brokerage_logo_uri/assets/2338.jpg
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id34
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2518253
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameFirst Hampton International Realty
 broker_of_record_name
 short_nameFirst Hampton International Realty
 usernameFirstHampton
 passwordc6d7951ad2b1432ff444a7a5acca6784d6573bb9
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionFirst Hampton International Realty is the exclusive representative for Leverage Global Partners in The Hamptons, New York, USA. Lawrence Citarelli Jr. is a successful, former finance/ economics executive of 14 years and possesses over 17 years of real estate investment and development experience. Mr. Citarelli has forged the Lawrence III Group, The group is comprised of a multi award winning design/construction management firm, Westhampton Partners, a development and acquisition arm and First Hampton International Realty, a global real estate entity. Through the vertical integration of these three entities clients and customers are provided with an experience and service model that is unrivaled in the industry. Mr. Citarelli is also a consummate humanitarian and is aligned with various noteworthy athletes, entertainers and celebrities. He has recently been awarded a congressional award for his international business dealings which are specifically tied to helping the less fortunate children and the communities where he is active.
 communitiesWesthampton Beach Westhampton Quogue Remsenburg hamptons southampton east hampton
 websitehttp://www.firsthamptonrealty.com
 address50 Main Street
 address_2
 cityWesthampton Beach
 stateNY
 full_stateNew York
 countryUSA
 marketHamptons
 market_2
 postal_code11978
 phone(631) 872-0280
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameLawrence Citarelli
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-lawrence-citarelli-principal-first-hampton-realty/
 contact_big_profile_link_text
 contact_titlePrincipal
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename34.jpg
 logo_filename34.jpg
 contact_image_filename34.jpg
 all_properties_link_image_filename34.jpg
 all_properties_linkhttp://www.firsthamptonrealty.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleThe Hamptons Real Estate | First Hampton International Realty | Leverage Global Partners
 meta_descriptionFirst Hampton International Realty is Leverage Global Partners' exclusive representative in the Hamptons, New York, USA.
 meta_keywordsFirst Hampton International Realty, The Hamptons Real Estate, Westhampton beach real estate, Lawrence Citarelli, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-06-07 11:03:46
 modified2016-04-08 16:33:30
 dre_num012345
 AccountExecutive(array)
 id235
 typeAccountExecutive
 brokerage_id0
 email[email protected]
 passworde5cc5a96287695cf8b7cace1463b1699895dcf92
 recover_hash
 first_nameAlec
 last_nameMegerdichian
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2020-12-23 09:21:42
 created2016-04-14 15:40:35
 notified(false)
 full_nameAlec Megerdichian
 uri/agent-detail/235/alec-megerdichian
 profile_complete(true)
 Logo(array)
 id2338
 modelBrokerage
 model_id34
 tagLogo
 name34.jpg
 typeimage/jpg
 size873549
 uri/assets/2338.jpg
 order0
 created2016-03-30 11:37:46
 modified2016-03-30 11:37:46
 MainImage(array)
 id2337
 modelBrokerage
 model_id34
 tagMainImage
 name34.jpg
 typeimage/jpg
 size4480438
 uri/assets/2337.jpg
 order0
 created2016-03-30 11:37:45
 modified2016-03-30 11:37:45
 ContactImage(array)
 id2339
 modelBrokerage
 model_id34
 tagContactImage
 name34.jpg
 typeimage/jpg
 size1290384
 uri/assets/2339.jpg
 order0
 created2016-03-30 11:37:46
 modified2016-03-30 11:37:46
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 FeaturedImage(empty)
 Location(array)
 0(array)
 id143
 parent_id7
 brokerage_id34
 typeExclusive
 archived(false)
 use_as_topic(true)
 nameHamptons, NY, USA
 short_nameHamptons, NY, USA
 group_index
 latitude40.924618
 longitude-72.354790
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description The Hamptons, the world's playground for the rich and famous.
 long_descriptionThe absolute bastion of luxury and real estate opulence. The Hamptons has been the home of America's most expensive and resilient real estate since the turn of the 20th Century. Located just 90 miles from the financial center of the world, New York City, the East End is the preferred resort community for businessmen and celebrities alike. A collection of small, unique towns and hamlets, the area is home to world renown restaurants, designer boutiques, unparalleled entertainment and of course the east coast's most beautiful ocean beaches. A true paradise and one of the most sought after real estate markets.
 created2016-04-07 16:14:57
 modified2016-04-14 10:51:05
 timezoneAmerica/New_York
 population15000
 uri/locations/view/143/hamptons-ny-usa
 tile_nameHamptons, NY, USA
 User(array)
 0(array)
 id84
 typeBrokerageAdmin
 brokerage_id34
 email[email protected]
 passwordea8abc7b5ae88e45a49a00314f721f1e92965fdc
 recover_hash
 first_nameLawrence
 last_nameCitarelli
 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 11:15:47
 created2016-04-08 16:33:30
 notified(true)
 full_nameLawrence Citarelli
 uri/agent-detail/84/lawrence-citarelli
 profile_complete(true)
 1(array)
 id231
 typeBrokerageAdmin
 brokerage_id34
 email[email protected]
 passwordea8abc7b5ae88e45a49a00314f721f1e92965fdc
 recover_hash
 first_nameJohn
 last_nameBarbella
 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 11:19:41
 created2016-04-14 11:19:41
 notified(false)
 full_nameJohn Barbella
 uri/agent-detail/231/john-barbella
 profile_complete(true)
 uri/brokerage-detail/34/first-hampton-international-realty
 website_shortwww.firsthamptonrealty.com
 name_with_locationFirst Hampton International Realty - Hamptons, NY, 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)
 id4563
 modelProperty
 model_id137
 tagImage
 name1042.jpg
 typeimage/jpg
 size747928
 uri/assets/4563.jpg
 order0
 created2016-04-07 15:01:10
 modified2016-04-07 15:01:10
 1(array)
 id4564
 modelProperty
 model_id137
 tagImage
 name1043.jpg
 typeimage/jpg
 size385581
 uri/assets/4564.jpg
 order1
 created2016-04-07 15:01:10
 modified2016-04-07 15:01:10
 2(array)
 id4565
 modelProperty
 model_id137
 tagImage
 name1044.jpg
 typeimage/jpg
 size794334
 uri/assets/4565.jpg
 order2
 created2016-04-07 15:01:10
 modified2016-04-07 15:01:10
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id300
 property_id137
 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
 1(array)
 id13
 nameTennis Court
 additional(false)
 created2016-04-07 14:04:41
 modified2016-04-07 14:04:41
 PropertiesPropertyFeature(array)
 id301
 property_id137
 property_feature_id13
 Icon(array)
 id3562
 modelPropertyFeature
 model_id13
 tagIcon
 name141.png
 typeimage/png
 size2373
 uri/assets/3562.png
 order0
 created2016-04-07 14:04:39
 modified2016-04-07 14:04:41
 2(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id302
 property_id137
 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
 3(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id303
 property_id137
 property_feature_id5
 Icon(array)
 id3554
 modelPropertyFeature
 model_id5
 tagIcon
 name133.png
 typeimage/png
 size1953
 uri/assets/3554.png
 order0
 created2016-04-07 14:02:11
 modified2016-04-07 14:02: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)
 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/137/4-hampton-close-westhampton-beach-ny-11978-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/property-detail/137/4-hampton-close-westhampton-beach-ny-11978-usa
Remote Port	17215
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.41
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	a09d2115e8e02308-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	aiobHagWUmgYuyi40B7xugAAAVA
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	aiobHagWUmgYuyi40B7xugAAAVA
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781144349.1284
Request Time	1781144349

====

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

One of a Kind Waterfront Estate

Represented By: First Hampton International Realty

Highlighted Properties

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 7 ms Total Queries: 34 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 7 ms
Total Queries: 34 queries