Properties /

Sold

Classic Cottage

5 Hedgebury Lane | Nantucket, MA 02554, USA | $2,745,000

4 Beds
3 Baths
Swimming Pool

Fabulous opportunity to create your dream property. Custom build your main home on the lower portion of this lot which has approximately 1500+ sf of ground cover remaining. A four bedroom, three bath cottage currently exists high atop this .48 acre lot and overlooks the 16 x 32 Gunite pool and patio. Great outdoor space for entertaining. Conveniently located on the bike path and close to the heart of Town.

Represented By: Congdon & Coleman Real Estate

www.congdonandcoleman.com | License #: 012345

Matt Payne
508-325-5023
Email

Main Office: 57 Main Street
Nantucket, MA 02554
USA

More About Matt

View On Map

Highlighted Properties

Estate with Vistas

13 North Pasture Lane | Nantucket, MA 02554
$3,995,000

Privacy in Pocomo

29-31 Pocomo Road | Nantucket, 02554
Price Upon Request

Represented By

Agent Contacts: Matt Payne 508-325-5023 | Email

Featured Location

Nantucket, MA, USA

Related Property Listings

Stunning Compound

34 Pocomo Road
Nantucket, MA 02554
$4,695,000

Beautiful Custom Built Colonial Home

28 West Chester Street
Nantucket, MA 02554
$2,990,000

Estate with Vistas

13 North Pasture Lane
Nantucket, MA 02554
$3,995,000

Classic Cottage

5 Hedgebury Lane
Nantucket, MA 02554
$2,745,000

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)
  02371
  15-hedgebury-lane-nantucket-ma-02554-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` = 2371 AND `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`incomplete` = '0' LIMIT 1	1	1	1
SELECT `AccountExecutive`.`id`, `AccountExecutive`.`type`, `AccountExecutive`.`brokerage_id`, `AccountExecutive`.`email`, `AccountExecutive`.`password`, `AccountExecutive`.`recover_hash`, `AccountExecutive`.`first_name`, `AccountExecutive`.`last_name`, `AccountExecutive`.`title`, `AccountExecutive`.`dre_num`, `AccountExecutive`.`phone`, `AccountExecutive`.`max_luxury_feed_properties`, `AccountExecutive`.`headshot_filename`, `AccountExecutive`.`bio`, `AccountExecutive`.`brokerage_name_override`, `AccountExecutive`.`stripe_customer_id`, `AccountExecutive`.`digital_ad_first_free_month_coupon`, `AccountExecutive`.`modified`, `AccountExecutive`.`created`, `AccountExecutive`.`notified`, (CONCAT(`AccountExecutive`.`first_name`, " ", `AccountExecutive`.`last_name`)) AS `AccountExecutive__full_name` FROM `leveragere_staging2`.`users` AS `AccountExecutive` WHERE `AccountExecutive`.`id` = 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` = 37 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` = 37 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` = 37 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` = 37 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` = 37 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` = 37 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` = 37 AND `MainArticle`.`model` = 'Brokerage'	1	1	0
SELECT `FeaturedImage`.`id`, `FeaturedImage`.`model`, `FeaturedImage`.`model_id`, `FeaturedImage`.`tag`, `FeaturedImage`.`name`, `FeaturedImage`.`type`, `FeaturedImage`.`size`, `FeaturedImage`.`uri`, `FeaturedImage`.`order`, `FeaturedImage`.`created`, `FeaturedImage`.`modified` FROM `leveragere_staging2`.`assets` AS `FeaturedImage` WHERE `FeaturedImage`.`model` = 'Brokerage' AND `FeaturedImage`.`tag` = 'FeaturedImage' AND `FeaturedImage`.`model_id` = (37) 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` = (37)	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` = (37)	5	5	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` = (2371) ORDER BY `Image`.`order` ASC	6	6	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` = 2371 AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	1	1	0
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` WHERE `Brokerage`.`id` = 37	1	1	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_id` = 839 AND `Image`.`model` = 'User' AND `Image`.`tag` = 'Image'	0	0	0
SELECT `BrokerageLogoOverride`.`id`, `BrokerageLogoOverride`.`model`, `BrokerageLogoOverride`.`model_id`, `BrokerageLogoOverride`.`tag`, `BrokerageLogoOverride`.`name`, `BrokerageLogoOverride`.`type`, `BrokerageLogoOverride`.`size`, `BrokerageLogoOverride`.`uri`, `BrokerageLogoOverride`.`order`, `BrokerageLogoOverride`.`created`, `BrokerageLogoOverride`.`modified` FROM `leveragere_staging2`.`assets` AS `BrokerageLogoOverride` WHERE `BrokerageLogoOverride`.`model_id` = 839 AND `BrokerageLogoOverride`.`model` = 'User' AND `BrokerageLogoOverride`.`tag` = 'BrokerageLogoOverride'	0	0	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` = 2371 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` = 2371 AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	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 `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` = 2371 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` != 2371 AND `Property`.`brokerage_id` = 37 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 (2248, 2250) ORDER BY `Image`.`order` ASC	10	10	0
SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (2248, 2250) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	2	2	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (2248, 2250) 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 (2248, 2250) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	8	8	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 (2248, 2250) 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` = 37 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` = 37 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 (1193, 995, 2248, 2371) ORDER BY `Image`.`order` ASC	36	36	1
SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (1193, 995, 2248, 2371) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	4	4	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (1193, 995, 2248, 2371) 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 (1193, 995, 2248, 2371) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	9	9	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (1193, 995, 2248, 2371) 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 14.36 MB

Message	Memory use
Component initialization	3.07 MB
Controller action start	4.01 MB
Controller render start	6.76 MB
View render complete	7.28 MB

Timers

Total Request Time: 235 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	37.39
Event: Controller.initialize	5.17
Event: Controller.startup	1.65
Controller action	45.85
Event: Controller.beforeRender	16.65
» Processing toolbar data	16.56
Rendering View	93.96
» Event: View.beforeRender	0.42
» Rendering APP/View/Properties/view.ctp	3.27
» » Rendering APP/View/Elements/static_property_price.ctp	0.44
» » Rendering APP/View/Elements/property_features.ctp	0.23
» » Rendering APP/View/Elements/static_property_price.ctp #2	0.15
» » Rendering APP/View/Elements/static_property_price.ctp #3	0.15
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.15
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.01
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #5	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #6	0.16
» » » Rendering APP/View/Elements/static_property_price.ctp #7	0.14
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.20
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	89.48
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)
 id1193
 brokerage_id37
 created_by_user_id0
 order5
 multi_unit(false)
 agent_1_id642
 agent_2_id0
 agent_3_id0
 nameStunning Compound
 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)
 descriptionThis stunning property includes an amazing four bedroom main house, spacious two bedroom cottage, separate two car garage with studio apartment and a swimming pool. All three dwellings are extremely well situated on an exceptionally private 2.9 acre lot. Marvelous details and craftsmanship throughout!
 address34 Pocomo Road
 address_2
 cityNantucket
 stateMA
 postal_code02554
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price4695000
 price_20
 price_usd4695000
 price_usd_20
 statusSold
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms7
 bedrooms_20
 bathrooms5
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres2
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size2
 icon_1acreage
 icon_2guest-house
 icon_3pool
 icon_4views
 icon_5
 icon_6
 website
 meta_titleStunning Compound | Nantucket Real Estate | Congdon & Coleman Real Estate
 meta_description34 Pocomo Road is a property offered sold in Nantucket, MA, USA, presented by Congdon & Coleman Real Estate
 meta_keywords34 Pocomo Road, Stunning Property with Marvelous Features, Leverage Global Partners, Nantucket Real Estate, Massachusetts Real Estate, Congdon & Coleman
 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_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_feet, 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
 created2014-10-09 16:05:13
 uri/property-detail/1193/34-pocomo-road-nantucket-ma-02554-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/1193/34-pocomo-road-nantucket-ma-02554-usa
 address_concat34 Pocomo Road Nantucket MA 02554 USA
 google_maps_query_string34+Pocomo+Road++Nantucket+MA+02554+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 4,695,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty7
 bathrooms_pretty5
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2014-10-09
 overridden_brokerage_nameCongdon & Coleman Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id37
 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
 WOEID2456968
 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
 nameCongdon & Coleman Real Estate
 broker_of_record_name
 short_nameCongdon & Coleman
 usernameCongdonColeman
 passwordf9492e65b683bc67dda66f994a01ecfb704a5f81
 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
 descriptionCongdon & Coleman Real Estate is the exclusive representative for Leverage Global Partners in Nantucket, Massachusetts, USA. Resident Experts: Nantucket Real Estate & Summer Rentals Congdon & Coleman Real Estate, founded in 1931, is a fourth generation Nantucket business. It is the only combined Nantucket real estate and insurance company on island. Our real estate agents are all Nantucket island residents who are active in the community and committed to preserving the quality of life here. If you choose to invest in Nantucket real estate, rely on the people who know it best. Congdon & Coleman Real Estate is a full service firm handling listing, selling and rentals. Each of our agents is a Realtor and a member of the Cape Cod & Islands Association of Realtors. We are also members of the Nantucket Association of Real Estate Brokers, which gives us accurate, current information on all properties for sale on Nantucket. When you list your property with Congdon & Coleman, inclusion with this service ensures that your property receives maximum exposure to all agents on Nantucket. Simply put, our brokers can show you any Nantucket real estate for sale on the island.
 communitiesNantucket
 websitehttp://www.congdonandcoleman.com
 address57 Main Street
 address_2
 cityNantucket
 stateMA
 full_stateMassachusetts
 countryUSA
 marketNantucket
 market_2
 postal_code02554
 phone(508) 325-5016
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTom Kennelly
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-tom-kennelly-president-congdon-and-coleman-real-estate/
 contact_big_profile_link_text
 contact_titlePresident, Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename37.jpg
 logo_filename37.png
 contact_image_filename37.jpg
 all_properties_link_image_filename37.jpg
 all_properties_linkhttp://www.congdonandcoleman.com/nantucket-sales/homes.asp
 video_embed_code
 contact_video_embed_code
 meta_titleNantucket Real Estate | Congdon & Coleman Real Estate | Leverage Global Partners
 meta_descriptionCongdon & Coleman Real Estate is Leverage Global Partners' exclusive representative in Nantucket, MA, USA.
 meta_keywordsNantucket real estate, Massachusetts real estate, Tom Kennelly, Congdon & Coleman, 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-07-24 14:33:33
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/37/congdon-coleman-real-estate
 website_shortwww.congdonandcoleman.com
 name_with_locationCongdon & Coleman Real Estate
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id12138
 modelProperty
 model_id1193
 tagImage
 name10317.jpg
 typeimage/jpg
 size533467
 uri/assets/12138.jpg
 order0
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 1(array)
 id12139
 modelProperty
 model_id1193
 tagImage
 name10514.jpg
 typeimage/jpg
 size425249
 uri/assets/12139.jpg
 order1
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 2(array)
 id12140
 modelProperty
 model_id1193
 tagImage
 name10515.jpg
 typeimage/jpg
 size220530
 uri/assets/12140.jpg
 order2
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 3(array)
 id12141
 modelProperty
 model_id1193
 tagImage
 name10516.jpg
 typeimage/jpg
 size277419
 uri/assets/12141.jpg
 order3
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 4(array)
 id12142
 modelProperty
 model_id1193
 tagImage
 name10517.jpg
 typeimage/jpg
 size190363
 uri/assets/12142.jpg
 order4
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 5(array)
 id12143
 modelProperty
 model_id1193
 tagImage
 name10518.jpg
 typeimage/jpg
 size263974
 uri/assets/12143.jpg
 order5
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 6(array)
 id12144
 modelProperty
 model_id1193
 tagImage
 name10519.jpg
 typeimage/jpg
 size292123
 uri/assets/12144.jpg
 order6
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 7(array)
 id12145
 modelProperty
 model_id1193
 tagImage
 name10520.jpg
 typeimage/jpg
 size529803
 uri/assets/12145.jpg
 order7
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 8(array)
 id12146
 modelProperty
 model_id1193
 tagImage
 name10521.jpg
 typeimage/jpg
 size318275
 uri/assets/12146.jpg
 order8
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 9(array)
 id12147
 modelProperty
 model_id1193
 tagImage
 name10522.jpg
 typeimage/jpg
 size481040
 uri/assets/12147.jpg
 order9
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 User(array)
 0(array)
 id839
 typeAgent
 brokerage_id37
 email[email protected]
 password9f98fcf000bd9fe90cbeec2b8ade5e7ff3b9a379
 recover_hash
 first_nameMatt
 last_namePayne
 title
 dre_num
 phone508-325-5023
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:40
 created2017-08-07 15:23:40
 notified(false)
 full_nameMatt Payne
 uri/agent-detail/839/matt-payne
 profile_complete(true)
 UsersProperty(array)
 id591
 user_id839
 property_id1193
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id2231
 property_id1193
 property_feature_id5
 1(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id2232
 property_id1193
 property_feature_id12
 2(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id2233
 property_id1193
 property_feature_id14
 Topic(empty)
 1(array)
 Property(array)
 id995
 brokerage_id37
 created_by_user_id0
 order3
 multi_unit(false)
 agent_1_id0
 agent_2_id643
 agent_3_id0
 nameBeautiful Custom Built Colonial Home
 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)
 descriptionBeautiful, custom built colonial home just minutes from the center of Town. Amenities abound in this classic home; 4 fireplaces, a beautiful kitchen, 3 distinct living areas, 7 bedrooms and 5 1/2 baths, deck for outdoor entertaining, tastefully finished basement with a second master suite, TV room/den that opens to a brick patio and the gorgeous perennial gardens. 3 off-street parking spaces off Wesco Lane.
 address28 West Chester Street
 address_2
 cityNantucket
 stateMA
 postal_code02554
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2990000
 price_20
 price_usd2990000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms7
 bedrooms_20
 bathrooms5
 bathrooms_20
 no_beds_baths(false)
 square_feet3635
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1balcony-terrace
 icon_2sq-ft
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://my.linknantucket.com/PropertyListing.aspx?mlid=E728DB20-CADB-4509-B442-40D6F5720794
 meta_titleBeautiful Custom Built Colonial Home | Nantucket Real Estate | Congdon & Coleman Real Estate
 meta_description28 West Chester Street is a property offered for sale in Nantucket, MA, USA, presented by Congdon & Coleman Real Estate
 meta_keywords28 West Chester Street, Beautiful Custom Built Colonial Home, Leverage Global Partners, Nantucket Real Estate, Massachusetts Real Estate, Congdon & Coleman
 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_fieldssquare_meters, acres, 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
 created2014-08-15 13:25:21
 uri/property-detail/995/28-west-chester-street-nantucket-ma-02554-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/995/28-west-chester-street-nantucket-ma-02554-usa
 address_concat28 West Chester Street Nantucket MA 02554 USA
 google_maps_query_string28+West+Chester+Street++Nantucket+MA+02554+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,990,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty7
 bathrooms_pretty5
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2014-08-15
 overridden_brokerage_nameCongdon & Coleman Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id37
 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
 WOEID2456968
 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
 nameCongdon & Coleman Real Estate
 broker_of_record_name
 short_nameCongdon & Coleman
 usernameCongdonColeman
 passwordf9492e65b683bc67dda66f994a01ecfb704a5f81
 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
 descriptionCongdon & Coleman Real Estate is the exclusive representative for Leverage Global Partners in Nantucket, Massachusetts, USA. Resident Experts: Nantucket Real Estate & Summer Rentals Congdon & Coleman Real Estate, founded in 1931, is a fourth generation Nantucket business. It is the only combined Nantucket real estate and insurance company on island. Our real estate agents are all Nantucket island residents who are active in the community and committed to preserving the quality of life here. If you choose to invest in Nantucket real estate, rely on the people who know it best. Congdon & Coleman Real Estate is a full service firm handling listing, selling and rentals. Each of our agents is a Realtor and a member of the Cape Cod & Islands Association of Realtors. We are also members of the Nantucket Association of Real Estate Brokers, which gives us accurate, current information on all properties for sale on Nantucket. When you list your property with Congdon & Coleman, inclusion with this service ensures that your property receives maximum exposure to all agents on Nantucket. Simply put, our brokers can show you any Nantucket real estate for sale on the island.
 communitiesNantucket
 websitehttp://www.congdonandcoleman.com
 address57 Main Street
 address_2
 cityNantucket
 stateMA
 full_stateMassachusetts
 countryUSA
 marketNantucket
 market_2
 postal_code02554
 phone(508) 325-5016
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTom Kennelly
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-tom-kennelly-president-congdon-and-coleman-real-estate/
 contact_big_profile_link_text
 contact_titlePresident, Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename37.jpg
 logo_filename37.png
 contact_image_filename37.jpg
 all_properties_link_image_filename37.jpg
 all_properties_linkhttp://www.congdonandcoleman.com/nantucket-sales/homes.asp
 video_embed_code
 contact_video_embed_code
 meta_titleNantucket Real Estate | Congdon & Coleman Real Estate | Leverage Global Partners
 meta_descriptionCongdon & Coleman Real Estate is Leverage Global Partners' exclusive representative in Nantucket, MA, USA.
 meta_keywordsNantucket real estate, Massachusetts real estate, Tom Kennelly, Congdon & Coleman, 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-07-24 14:33:33
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/37/congdon-coleman-real-estate
 website_shortwww.congdonandcoleman.com
 name_with_locationCongdon & Coleman Real Estate
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id10964
 modelProperty
 model_id995
 tagImage
 name8442.jpg
 typeimage/jpg
 size623702
 uri/assets/10964.jpg
 order0
 created2016-04-07 16:24:06
 modified2016-04-07 16:24:06
 1(array)
 id10960
 modelProperty
 model_id995
 tagImage
 name8438.jpg
 typeimage/jpg
 size393625
 uri/assets/10960.jpg
 order1
 created2016-04-07 16:24:05
 modified2016-04-07 16:24:05
 2(array)
 id10961
 modelProperty
 model_id995
 tagImage
 name8439.jpg
 typeimage/jpg
 size340177
 uri/assets/10961.jpg
 order2
 created2016-04-07 16:24:05
 modified2016-04-07 16:24:05
 3(array)
 id10962
 modelProperty
 model_id995
 tagImage
 name8440.jpg
 typeimage/jpg
 size389907
 uri/assets/10962.jpg
 order3
 created2016-04-07 16:24:05
 modified2016-04-07 16:24:06
 4(array)
 id10965
 modelProperty
 model_id995
 tagImage
 name8443.jpg
 typeimage/jpg
 size327948
 uri/assets/10965.jpg
 order4
 created2016-04-07 16:24:06
 modified2016-04-07 16:24:06
 5(array)
 id10966
 modelProperty
 model_id995
 tagImage
 name8444.jpg
 typeimage/jpg
 size422086
 uri/assets/10966.jpg
 order5
 created2016-04-07 16:24:06
 modified2016-04-07 16:24:06
 6(array)
 id10967
 modelProperty
 model_id995
 tagImage
 name8445.jpg
 typeimage/jpg
 size381071
 uri/assets/10967.jpg
 order6
 created2016-04-07 16:24:06
 modified2016-04-07 16:24:06
 7(array)
 id10968
 modelProperty
 model_id995
 tagImage
 name8446.jpg
 typeimage/jpg
 size396298
 uri/assets/10968.jpg
 order7
 created2016-04-07 16:24:06
 modified2016-04-07 16:24:06
 8(array)
 id10969
 modelProperty
 model_id995
 tagImage
 name8447.jpg
 typeimage/jpg
 size321423
 uri/assets/10969.jpg
 order8
 created2016-04-07 16:24:06
 modified2016-04-07 16:24:06
 9(array)
 id10970
 modelProperty
 model_id995
 tagImage
 name8448.jpg
 typeimage/jpg
 size400497
 uri/assets/10970.jpg
 order9
 created2016-04-07 16:24:06
 modified2016-04-07 16:24:06
 10(array)
 id10971
 modelProperty
 model_id995
 tagImage
 name8449.jpg
 typeimage/jpg
 size373541
 uri/assets/10971.jpg
 order10
 created2016-04-07 16:24:06
 modified2016-04-07 16:24:06
 11(array)
 id10963
 modelProperty
 model_id995
 tagImage
 name8441.jpg
 typeimage/jpg
 size330912
 uri/assets/10963.jpg
 order11
 created2016-04-07 16:24:06
 modified2016-04-07 16:24:06
 User(array)
 0(array)
 id840
 typeAgent
 brokerage_id37
 email[email protected]
 password402b73a0770d26060597ee63a9728d66a26906ed
 recover_hash
 first_nameTom
 last_nameWeinstock
 title
 dre_num
 phone508-325-5022
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:40
 created2017-08-07 15:23:40
 notified(false)
 full_nameTom Weinstock
 uri/agent-detail/840/tom-weinstock
 profile_complete(true)
 UsersProperty(array)
 id594
 user_id840
 property_id995
 sort_order0
 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)
 id1941
 property_id995
 property_feature_id1
 Topic(empty)
 2(array)
 Property(array)
 id2248
 brokerage_id37
 created_by_user_id0
 order2
 multi_unit(false)
 agent_1_id642
 agent_2_id0
 agent_3_id0
 nameEstate with Vistas
 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)
 descriptionAn original Lyman Perry design, this light and bright post and beam estate is thoughtfully situated high on the hill of North Pasture Lane. Enjoy vistas to town, the harbor, or overlook the natural beauty of the moors from the main house, cottage or garage apartment. Seclusion, privacy and views are relished from the many decks and porches this compound has to offer.
 address13 North Pasture Lane
 address_2
 cityNantucket
 stateMA
 postal_code02554
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price3995000
 price_20
 price_usd3995000
 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
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres2
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size2
 icon_1acreage
 icon_2balcony-terrace
 icon_3guest-house
 icon_4views
 icon_5garage
 icon_6
 website
 meta_titleEstate with Vistas | Nantucket Real Estate | Congdon & Coleman Real Estate
 meta_description13 North Pasture Lane is a property offered for sale in Nantucket, MA, USA, presented by Congdon & Coleman Real Estate
 meta_keywords
 bathrooms_partial2
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldssquare_feet, square_meters, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-06-02 09:01:53
 uri/property-detail/2248/13-north-pasture-lane-nantucket-ma-02554-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2248/13-north-pasture-lane-nantucket-ma-02554-usa
 address_concat13 North Pasture Lane Nantucket MA 02554 USA
 google_maps_query_string13+North+Pasture+Lane++Nantucket+MA+02554+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 3,995,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty6
 bathrooms_pretty4
 bathrooms_partial_pretty2
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2015-06-02
 overridden_brokerage_nameCongdon & Coleman Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id37
 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
 WOEID2456968
 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
 nameCongdon & Coleman Real Estate
 broker_of_record_name
 short_nameCongdon & Coleman
 usernameCongdonColeman
 passwordf9492e65b683bc67dda66f994a01ecfb704a5f81
 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
 descriptionCongdon & Coleman Real Estate is the exclusive representative for Leverage Global Partners in Nantucket, Massachusetts, USA. Resident Experts: Nantucket Real Estate & Summer Rentals Congdon & Coleman Real Estate, founded in 1931, is a fourth generation Nantucket business. It is the only combined Nantucket real estate and insurance company on island. Our real estate agents are all Nantucket island residents who are active in the community and committed to preserving the quality of life here. If you choose to invest in Nantucket real estate, rely on the people who know it best. Congdon & Coleman Real Estate is a full service firm handling listing, selling and rentals. Each of our agents is a Realtor and a member of the Cape Cod & Islands Association of Realtors. We are also members of the Nantucket Association of Real Estate Brokers, which gives us accurate, current information on all properties for sale on Nantucket. When you list your property with Congdon & Coleman, inclusion with this service ensures that your property receives maximum exposure to all agents on Nantucket. Simply put, our brokers can show you any Nantucket real estate for sale on the island.
 communitiesNantucket
 websitehttp://www.congdonandcoleman.com
 address57 Main Street
 address_2
 cityNantucket
 stateMA
 full_stateMassachusetts
 countryUSA
 marketNantucket
 market_2
 postal_code02554
 phone(508) 325-5016
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTom Kennelly
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-tom-kennelly-president-congdon-and-coleman-real-estate/
 contact_big_profile_link_text
 contact_titlePresident, Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename37.jpg
 logo_filename37.png
 contact_image_filename37.jpg
 all_properties_link_image_filename37.jpg
 all_properties_linkhttp://www.congdonandcoleman.com/nantucket-sales/homes.asp
 video_embed_code
 contact_video_embed_code
 meta_titleNantucket Real Estate | Congdon & Coleman Real Estate | Leverage Global Partners
 meta_descriptionCongdon & Coleman Real Estate is Leverage Global Partners' exclusive representative in Nantucket, MA, USA.
 meta_keywordsNantucket real estate, Massachusetts real estate, Tom Kennelly, Congdon & Coleman, 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-07-24 14:33:33
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/37/congdon-coleman-real-estate
 website_shortwww.congdonandcoleman.com
 name_with_locationCongdon & Coleman Real Estate
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id12148
 modelProperty
 model_id2248
 tagImage
 name20772.jpg
 typeimage/jpg
 size617370
 uri/assets/12148.jpg
 order0
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 1(array)
 id12151
 modelProperty
 model_id2248
 tagImage
 name23020.jpg
 typeimage/jpg
 size636852
 uri/assets/12151.jpg
 order1
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 2(array)
 id12149
 modelProperty
 model_id2248
 tagImage
 name23018.jpg
 typeimage/jpg
 size734072
 uri/assets/12149.jpg
 order2
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 3(array)
 id12150
 modelProperty
 model_id2248
 tagImage
 name23019.jpg
 typeimage/jpg
 size508753
 uri/assets/12150.jpg
 order3
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 4(array)
 id12153
 modelProperty
 model_id2248
 tagImage
 name23022.jpg
 typeimage/jpg
 size252045
 uri/assets/12153.jpg
 order5
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 5(array)
 id12154
 modelProperty
 model_id2248
 tagImage
 name23023.jpg
 typeimage/jpg
 size320288
 uri/assets/12154.jpg
 order6
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 6(array)
 id12152
 modelProperty
 model_id2248
 tagImage
 name23025.jpg
 typeimage/jpg
 size406784
 uri/assets/12152.jpg
 order7
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 7(array)
 id12155
 modelProperty
 model_id2248
 tagImage
 name23024.jpg
 typeimage/jpg
 size322022
 uri/assets/12155.jpg
 order7
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 User(array)
 0(array)
 id839
 typeAgent
 brokerage_id37
 email[email protected]
 password9f98fcf000bd9fe90cbeec2b8ade5e7ff3b9a379
 recover_hash
 first_nameMatt
 last_namePayne
 title
 dre_num
 phone508-325-5023
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:40
 created2017-08-07 15:23:40
 notified(false)
 full_nameMatt Payne
 uri/agent-detail/839/matt-payne
 profile_complete(true)
 UsersProperty(array)
 id592
 user_id839
 property_id2248
 sort_order0
 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)
 id2234
 property_id2248
 property_feature_id1
 1(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id2235
 property_id2248
 property_feature_id5
 2(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id2236
 property_id2248
 property_feature_id14
 3(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id2237
 property_id2248
 property_feature_id4
 Topic(empty)
 3(array)
 Property(array)
 id2371
 brokerage_id37
 created_by_user_id0
 order4
 multi_unit(false)
 agent_1_id642
 agent_2_id0
 agent_3_id0
 nameClassic Cottage
 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)
 descriptionFabulous opportunity to create your dream property. Custom build your main home on the lower portion of this lot which has approximately 1500+ sf of ground cover remaining. A four bedroom, three bath cottage currently exists high atop this .48 acre lot and overlooks the 16 x 32 Gunite pool and patio. Great outdoor space for entertaining. Conveniently located on the bike path and close to the heart of Town.
 address5 Hedgebury Lane
 address_2
 cityNantucket
 stateMA
 postal_code02554
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2745000
 price_20
 price_usd2745000
 price_usd_20
 statusSold
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1pool
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_titleClassic Cottage | Nantucket Real Estate | Congdon & Coleman Real Estate
 meta_description5 Hedgebury Lane is a property offered sold in Nantucket, MA, USA, presented by Congdon & Coleman Real Estate
 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
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, bathrooms_partial, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-06-27 09:45:19
 uri/property-detail/2371/5-hedgebury-lane-nantucket-ma-02554-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2371/5-hedgebury-lane-nantucket-ma-02554-usa
 address_concat5 Hedgebury Lane Nantucket MA 02554 USA
 google_maps_query_string5+Hedgebury+Lane++Nantucket+MA+02554+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,745,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty3
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2015-06-27
 overridden_brokerage_nameCongdon & Coleman Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id37
 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
 WOEID2456968
 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
 nameCongdon & Coleman Real Estate
 broker_of_record_name
 short_nameCongdon & Coleman
 usernameCongdonColeman
 passwordf9492e65b683bc67dda66f994a01ecfb704a5f81
 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
 descriptionCongdon & Coleman Real Estate is the exclusive representative for Leverage Global Partners in Nantucket, Massachusetts, USA. Resident Experts: Nantucket Real Estate & Summer Rentals Congdon & Coleman Real Estate, founded in 1931, is a fourth generation Nantucket business. It is the only combined Nantucket real estate and insurance company on island. Our real estate agents are all Nantucket island residents who are active in the community and committed to preserving the quality of life here. If you choose to invest in Nantucket real estate, rely on the people who know it best. Congdon & Coleman Real Estate is a full service firm handling listing, selling and rentals. Each of our agents is a Realtor and a member of the Cape Cod & Islands Association of Realtors. We are also members of the Nantucket Association of Real Estate Brokers, which gives us accurate, current information on all properties for sale on Nantucket. When you list your property with Congdon & Coleman, inclusion with this service ensures that your property receives maximum exposure to all agents on Nantucket. Simply put, our brokers can show you any Nantucket real estate for sale on the island.
 communitiesNantucket
 websitehttp://www.congdonandcoleman.com
 address57 Main Street
 address_2
 cityNantucket
 stateMA
 full_stateMassachusetts
 countryUSA
 marketNantucket
 market_2
 postal_code02554
 phone(508) 325-5016
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTom Kennelly
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-tom-kennelly-president-congdon-and-coleman-real-estate/
 contact_big_profile_link_text
 contact_titlePresident, Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename37.jpg
 logo_filename37.png
 contact_image_filename37.jpg
 all_properties_link_image_filename37.jpg
 all_properties_linkhttp://www.congdonandcoleman.com/nantucket-sales/homes.asp
 video_embed_code
 contact_video_embed_code
 meta_titleNantucket Real Estate | Congdon & Coleman Real Estate | Leverage Global Partners
 meta_descriptionCongdon & Coleman Real Estate is Leverage Global Partners' exclusive representative in Nantucket, MA, USA.
 meta_keywordsNantucket real estate, Massachusetts real estate, Tom Kennelly, Congdon & Coleman, 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-07-24 14:33:33
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/37/congdon-coleman-real-estate
 website_shortwww.congdonandcoleman.com
 name_with_locationCongdon & Coleman Real Estate
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id15383
 modelProperty
 model_id2371
 tagImage
 name22105.jpg
 typeimage/jpg
 size703684
 uri/assets/15383.jpg
 order0
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:02
 1(array)
 id15384
 modelProperty
 model_id2371
 tagImage
 name22106.jpg
 typeimage/jpg
 size397831
 uri/assets/15384.jpg
 order1
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:02
 2(array)
 id15385
 modelProperty
 model_id2371
 tagImage
 name22107.jpg
 typeimage/jpg
 size338060
 uri/assets/15385.jpg
 order2
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:02
 3(array)
 id15386
 modelProperty
 model_id2371
 tagImage
 name22108.jpg
 typeimage/jpg
 size272294
 uri/assets/15386.jpg
 order3
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:02
 4(array)
 id15387
 modelProperty
 model_id2371
 tagImage
 name22109.jpg
 typeimage/jpg
 size296023
 uri/assets/15387.jpg
 order4
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:02
 5(array)
 id15388
 modelProperty
 model_id2371
 tagImage
 name22110.jpg
 typeimage/jpg
 size751307
 uri/assets/15388.jpg
 order5
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:02
 User(array)
 0(array)
 id839
 typeAgent
 brokerage_id37
 email[email protected]
 password9f98fcf000bd9fe90cbeec2b8ade5e7ff3b9a379
 recover_hash
 first_nameMatt
 last_namePayne
 title
 dre_num
 phone508-325-5023
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:40
 created2017-08-07 15:23:40
 notified(false)
 full_nameMatt Payne
 uri/agent-detail/839/matt-payne
 profile_complete(true)
 UsersProperty(array)
 id593
 user_id839
 property_id2371
 sort_order0
 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)
 id3143
 property_id2371
 property_feature_id12
 Topic(empty)
- sidebar_locations(array)
 0(array)
 Location(array)
 id156
 parent_id7
 brokerage_id37
 typeExclusive
 archived(false)
 use_as_topic(true)
 nameNantucket, MA, USA
 short_nameNantucket, MA, USA
 group_index
 latitude41.283470
 longitude-70.099449
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 15:41:00
 modified2016-04-14 10:55:17
 timezoneAmerica/New_York
 population10500
 uri/locations/view/156/nantucket-ma-usa
 tile_nameNantucket, MA, USA
 Brokerage(array)
 id37
 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
 WOEID2456968
 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
 nameCongdon & Coleman Real Estate
 broker_of_record_name
 short_nameCongdon & Coleman
 usernameCongdonColeman
 passwordf9492e65b683bc67dda66f994a01ecfb704a5f81
 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
 descriptionCongdon & Coleman Real Estate is the exclusive representative for Leverage Global Partners in Nantucket, Massachusetts, USA. Resident Experts: Nantucket Real Estate & Summer Rentals Congdon & Coleman Real Estate, founded in 1931, is a fourth generation Nantucket business. It is the only combined Nantucket real estate and insurance company on island. Our real estate agents are all Nantucket island residents who are active in the community and committed to preserving the quality of life here. If you choose to invest in Nantucket real estate, rely on the people who know it best. Congdon & Coleman Real Estate is a full service firm handling listing, selling and rentals. Each of our agents is a Realtor and a member of the Cape Cod & Islands Association of Realtors. We are also members of the Nantucket Association of Real Estate Brokers, which gives us accurate, current information on all properties for sale on Nantucket. When you list your property with Congdon & Coleman, inclusion with this service ensures that your property receives maximum exposure to all agents on Nantucket. Simply put, our brokers can show you any Nantucket real estate for sale on the island.
 communitiesNantucket
 websitehttp://www.congdonandcoleman.com
 address57 Main Street
 address_2
 cityNantucket
 stateMA
 full_stateMassachusetts
 countryUSA
 marketNantucket
 market_2
 postal_code02554
 phone(508) 325-5016
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTom Kennelly
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-tom-kennelly-president-congdon-and-coleman-real-estate/
 contact_big_profile_link_text
 contact_titlePresident, Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename37.jpg
 logo_filename37.png
 contact_image_filename37.jpg
 all_properties_link_image_filename37.jpg
 all_properties_linkhttp://www.congdonandcoleman.com/nantucket-sales/homes.asp
 video_embed_code
 contact_video_embed_code
 meta_titleNantucket Real Estate | Congdon & Coleman Real Estate | Leverage Global Partners
 meta_descriptionCongdon & Coleman Real Estate is Leverage Global Partners' exclusive representative in Nantucket, MA, USA.
 meta_keywordsNantucket real estate, Massachusetts real estate, Tom Kennelly, Congdon & Coleman, 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-07-24 14:33:33
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/37/congdon-coleman-real-estate
 website_shortwww.congdonandcoleman.com
 name_with_locationCongdon & Coleman Real Estate
 Image(array)
 id20713
 modelLocation
 model_id156
 tagImage
 nameScreen Shot 2016-04-12 at 3.40.28 PM.png
 typeimage/png
 size457517
 uri/assets/20713.png
 order0
 created2016-04-12 15:40:48
 modified2016-04-14 10:55:17
- highlighted_properties(array)
 0(array)
 Property(array)
 id2248
 brokerage_id37
 created_by_user_id0
 order2
 multi_unit(false)
 agent_1_id642
 agent_2_id0
 agent_3_id0
 nameEstate with Vistas
 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)
 descriptionAn original Lyman Perry design, this light and bright post and beam estate is thoughtfully situated high on the hill of North Pasture Lane. Enjoy vistas to town, the harbor, or overlook the natural beauty of the moors from the main house, cottage or garage apartment. Seclusion, privacy and views are relished from the many decks and porches this compound has to offer.
 address13 North Pasture Lane
 address_2
 cityNantucket
 stateMA
 postal_code02554
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price3995000
 price_20
 price_usd3995000
 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
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres2
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size2
 icon_1acreage
 icon_2balcony-terrace
 icon_3guest-house
 icon_4views
 icon_5garage
 icon_6
 website
 meta_titleEstate with Vistas | Nantucket Real Estate | Congdon & Coleman Real Estate
 meta_description13 North Pasture Lane is a property offered for sale in Nantucket, MA, USA, presented by Congdon & Coleman Real Estate
 meta_keywords
 bathrooms_partial2
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldssquare_feet, square_meters, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-06-02 09:01:53
 uri/property-detail/2248/13-north-pasture-lane-nantucket-ma-02554-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2248/13-north-pasture-lane-nantucket-ma-02554-usa
 address_concat13 North Pasture Lane Nantucket MA 02554 USA
 google_maps_query_string13+North+Pasture+Lane++Nantucket+MA+02554+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 3,995,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty6
 bathrooms_pretty4
 bathrooms_partial_pretty2
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2015-06-02
 overridden_brokerage_nameCongdon & Coleman Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id37
 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
 WOEID2456968
 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
 nameCongdon & Coleman Real Estate
 broker_of_record_name
 short_nameCongdon & Coleman
 usernameCongdonColeman
 passwordf9492e65b683bc67dda66f994a01ecfb704a5f81
 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
 descriptionCongdon & Coleman Real Estate is the exclusive representative for Leverage Global Partners in Nantucket, Massachusetts, USA. Resident Experts: Nantucket Real Estate & Summer Rentals Congdon & Coleman Real Estate, founded in 1931, is a fourth generation Nantucket business. It is the only combined Nantucket real estate and insurance company on island. Our real estate agents are all Nantucket island residents who are active in the community and committed to preserving the quality of life here. If you choose to invest in Nantucket real estate, rely on the people who know it best. Congdon & Coleman Real Estate is a full service firm handling listing, selling and rentals. Each of our agents is a Realtor and a member of the Cape Cod & Islands Association of Realtors. We are also members of the Nantucket Association of Real Estate Brokers, which gives us accurate, current information on all properties for sale on Nantucket. When you list your property with Congdon & Coleman, inclusion with this service ensures that your property receives maximum exposure to all agents on Nantucket. Simply put, our brokers can show you any Nantucket real estate for sale on the island.
 communitiesNantucket
 websitehttp://www.congdonandcoleman.com
 address57 Main Street
 address_2
 cityNantucket
 stateMA
 full_stateMassachusetts
 countryUSA
 marketNantucket
 market_2
 postal_code02554
 phone(508) 325-5016
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTom Kennelly
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-tom-kennelly-president-congdon-and-coleman-real-estate/
 contact_big_profile_link_text
 contact_titlePresident, Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename37.jpg
 logo_filename37.png
 contact_image_filename37.jpg
 all_properties_link_image_filename37.jpg
 all_properties_linkhttp://www.congdonandcoleman.com/nantucket-sales/homes.asp
 video_embed_code
 contact_video_embed_code
 meta_titleNantucket Real Estate | Congdon & Coleman Real Estate | Leverage Global Partners
 meta_descriptionCongdon & Coleman Real Estate is Leverage Global Partners' exclusive representative in Nantucket, MA, USA.
 meta_keywordsNantucket real estate, Massachusetts real estate, Tom Kennelly, Congdon & Coleman, 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-07-24 14:33:33
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/37/congdon-coleman-real-estate
 website_shortwww.congdonandcoleman.com
 name_with_locationCongdon & Coleman Real Estate
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id12148
 modelProperty
 model_id2248
 tagImage
 name20772.jpg
 typeimage/jpg
 size617370
 uri/assets/12148.jpg
 order0
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 1(array)
 id12151
 modelProperty
 model_id2248
 tagImage
 name23020.jpg
 typeimage/jpg
 size636852
 uri/assets/12151.jpg
 order1
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 2(array)
 id12149
 modelProperty
 model_id2248
 tagImage
 name23018.jpg
 typeimage/jpg
 size734072
 uri/assets/12149.jpg
 order2
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 3(array)
 id12150
 modelProperty
 model_id2248
 tagImage
 name23019.jpg
 typeimage/jpg
 size508753
 uri/assets/12150.jpg
 order3
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 4(array)
 id12153
 modelProperty
 model_id2248
 tagImage
 name23022.jpg
 typeimage/jpg
 size252045
 uri/assets/12153.jpg
 order5
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 5(array)
 id12154
 modelProperty
 model_id2248
 tagImage
 name23023.jpg
 typeimage/jpg
 size320288
 uri/assets/12154.jpg
 order6
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 6(array)
 id12152
 modelProperty
 model_id2248
 tagImage
 name23025.jpg
 typeimage/jpg
 size406784
 uri/assets/12152.jpg
 order7
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 7(array)
 id12155
 modelProperty
 model_id2248
 tagImage
 name23024.jpg
 typeimage/jpg
 size322022
 uri/assets/12155.jpg
 order7
 created2016-04-07 16:31:05
 modified2016-04-07 16:31:05
 User(array)
 0(array)
 id839
 typeAgent
 brokerage_id37
 email[email protected]
 password9f98fcf000bd9fe90cbeec2b8ade5e7ff3b9a379
 recover_hash
 first_nameMatt
 last_namePayne
 title
 dre_num
 phone508-325-5023
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:40
 created2017-08-07 15:23:40
 notified(false)
 full_nameMatt Payne
 uri/agent-detail/839/matt-payne
 profile_complete(true)
 UsersProperty(array)
 id592
 user_id839
 property_id2248
 sort_order0
 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)
 id2234
 property_id2248
 property_feature_id1
 1(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id2235
 property_id2248
 property_feature_id5
 2(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id2236
 property_id2248
 property_feature_id14
 3(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id2237
 property_id2248
 property_feature_id4
 Topic(empty)
 1(array)
 Property(array)
 id2250
 brokerage_id37
 created_by_user_id0
 order1
 multi_unit(false)
 agent_1_id644
 agent_2_id0
 agent_3_id0
 namePrivacy in Pocomo
 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)
 descriptionFirst Time Offered ! Private Waterfront Family Compound sold in entirety consisting of 5 parcels totaling 5.29 acres. Easy beach access by a level path. Also, there is a small cottage and separate garage located on one parcel. Property is Being sold "as is".
 address29-31 Pocomo Road
 address_2
 cityNantucket
 state
 postal_code02554
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price8700000
 price_20
 price_usd8700000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(true)
 bedrooms2
 bedrooms_20
 bathrooms1
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres5
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size5
 icon_1beach-access
 icon_2acreage
 icon_3waterfront
 icon_4garage
 icon_5views
 icon_6
 website
 meta_titlePrivacy in Pocomo | Nantucket Real Estate | Congdon & Coleman Real Estate
 meta_description29-31 Pocomo Road is a property offered for sale in Nantucket, USA, presented by Congdon & Coleman Real Estate
 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
 latitude0.000000
 longitude0.000000
 invalid_required_fieldsstate
 invalid_optional_fieldsbathrooms_partial, square_feet, square_meters, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-06-02 13:41:36
 uri/property-detail/2250/29-31-pocomo-road-nantucket-02554-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2250/29-31-pocomo-road-nantucket-02554-usa
 address_concat29-31 Pocomo Road Nantucket 02554 USA
 google_maps_query_string29-31+Pocomo+Road++Nantucket++02554+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 8,700,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty2
 bathrooms_pretty1
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms1
 date_listed2015-06-02
 overridden_brokerage_nameCongdon & Coleman Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id37
 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
 WOEID2456968
 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
 nameCongdon & Coleman Real Estate
 broker_of_record_name
 short_nameCongdon & Coleman
 usernameCongdonColeman
 passwordf9492e65b683bc67dda66f994a01ecfb704a5f81
 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
 descriptionCongdon & Coleman Real Estate is the exclusive representative for Leverage Global Partners in Nantucket, Massachusetts, USA. Resident Experts: Nantucket Real Estate & Summer Rentals Congdon & Coleman Real Estate, founded in 1931, is a fourth generation Nantucket business. It is the only combined Nantucket real estate and insurance company on island. Our real estate agents are all Nantucket island residents who are active in the community and committed to preserving the quality of life here. If you choose to invest in Nantucket real estate, rely on the people who know it best. Congdon & Coleman Real Estate is a full service firm handling listing, selling and rentals. Each of our agents is a Realtor and a member of the Cape Cod & Islands Association of Realtors. We are also members of the Nantucket Association of Real Estate Brokers, which gives us accurate, current information on all properties for sale on Nantucket. When you list your property with Congdon & Coleman, inclusion with this service ensures that your property receives maximum exposure to all agents on Nantucket. Simply put, our brokers can show you any Nantucket real estate for sale on the island.
 communitiesNantucket
 websitehttp://www.congdonandcoleman.com
 address57 Main Street
 address_2
 cityNantucket
 stateMA
 full_stateMassachusetts
 countryUSA
 marketNantucket
 market_2
 postal_code02554
 phone(508) 325-5016
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTom Kennelly
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-tom-kennelly-president-congdon-and-coleman-real-estate/
 contact_big_profile_link_text
 contact_titlePresident, Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename37.jpg
 logo_filename37.png
 contact_image_filename37.jpg
 all_properties_link_image_filename37.jpg
 all_properties_linkhttp://www.congdonandcoleman.com/nantucket-sales/homes.asp
 video_embed_code
 contact_video_embed_code
 meta_titleNantucket Real Estate | Congdon & Coleman Real Estate | Leverage Global Partners
 meta_descriptionCongdon & Coleman Real Estate is Leverage Global Partners' exclusive representative in Nantucket, MA, USA.
 meta_keywordsNantucket real estate, Massachusetts real estate, Tom Kennelly, Congdon & Coleman, 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-07-24 14:33:33
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/37/congdon-coleman-real-estate
 website_shortwww.congdonandcoleman.com
 name_with_locationCongdon & Coleman Real Estate
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id15010
 modelProperty
 model_id2250
 tagImage
 name20778.jpg
 typeimage/jpg
 size828014
 uri/assets/15010.jpg
 order0
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 1(array)
 id15011
 modelProperty
 model_id2250
 tagImage
 name20787.jpg
 typeimage/jpg
 size962522
 uri/assets/15011.jpg
 order1
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 User(array)
 0(array)
 id841
 typeAgent
 brokerage_id37
 email[email protected]
 password33a66f30695b51cebb19decd4c88a3b5bfbfcc37
 recover_hash
 first_nameJoyce
 last_nameMontalbano
 title
 dre_num
 phone508-325-5015
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:40
 created2017-08-07 15:23:40
 notified(false)
 full_nameJoyce Montalbano
 uri/agent-detail/841/joyce-montalbano
 profile_complete(true)
 UsersProperty(array)
 id595
 user_id841
 property_id2250
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id2
 nameBeach Access
 additional(false)
 created2016-04-07 14:00:52
 modified2016-04-07 14:00:52
 PropertiesPropertyFeature(array)
 id3018
 property_id2250
 property_feature_id2
 1(array)
 id17
 nameWaterfront
 additional(false)
 created2016-04-07 14:06:00
 modified2016-04-07 14:06:00
 PropertiesPropertyFeature(array)
 id3019
 property_id2250
 property_feature_id17
 2(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id3020
 property_id2250
 property_feature_id4
 3(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id3021
 property_id2250
 property_feature_id14
 Topic(empty)
- custom_ga_event_properties(array)
 brokerageCongdon & Coleman Real Estate, Nantucket
- property(array)
 Property(array)
 id2371
 brokerage_id37
 created_by_user_id0
 order4
 multi_unit(false)
 agent_1_id642
 agent_2_id0
 agent_3_id0
 nameClassic Cottage
 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)
 descriptionFabulous opportunity to create your dream property. Custom build your main home on the lower portion of this lot which has approximately 1500+ sf of ground cover remaining. A four bedroom, three bath cottage currently exists high atop this .48 acre lot and overlooks the 16 x 32 Gunite pool and patio. Great outdoor space for entertaining. Conveniently located on the bike path and close to the heart of Town.
 address5 Hedgebury Lane
 address_2
 cityNantucket
 stateMA
 postal_code02554
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2745000
 price_20
 price_usd2745000
 price_usd_20
 statusSold
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1pool
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_titleClassic Cottage | Nantucket Real Estate | Congdon & Coleman Real Estate
 meta_description5 Hedgebury Lane is a property offered sold in Nantucket, MA, USA, presented by Congdon & Coleman Real Estate
 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
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, bathrooms_partial, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-06-27 09:45:19
 uri/property-detail/2371/5-hedgebury-lane-nantucket-ma-02554-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2371/5-hedgebury-lane-nantucket-ma-02554-usa
 address_concat5 Hedgebury Lane Nantucket MA 02554 USA
 google_maps_query_string5+Hedgebury+Lane++Nantucket+MA+02554+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,745,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty3
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2015-06-27
 overridden_brokerage_nameCongdon & Coleman Real Estate
 overridden_brokerage_logo_uri/assets/2347.png
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id37
 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
 WOEID2456968
 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
 nameCongdon & Coleman Real Estate
 broker_of_record_name
 short_nameCongdon & Coleman
 usernameCongdonColeman
 passwordf9492e65b683bc67dda66f994a01ecfb704a5f81
 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
 descriptionCongdon & Coleman Real Estate is the exclusive representative for Leverage Global Partners in Nantucket, Massachusetts, USA. Resident Experts: Nantucket Real Estate & Summer Rentals Congdon & Coleman Real Estate, founded in 1931, is a fourth generation Nantucket business. It is the only combined Nantucket real estate and insurance company on island. Our real estate agents are all Nantucket island residents who are active in the community and committed to preserving the quality of life here. If you choose to invest in Nantucket real estate, rely on the people who know it best. Congdon & Coleman Real Estate is a full service firm handling listing, selling and rentals. Each of our agents is a Realtor and a member of the Cape Cod & Islands Association of Realtors. We are also members of the Nantucket Association of Real Estate Brokers, which gives us accurate, current information on all properties for sale on Nantucket. When you list your property with Congdon & Coleman, inclusion with this service ensures that your property receives maximum exposure to all agents on Nantucket. Simply put, our brokers can show you any Nantucket real estate for sale on the island.
 communitiesNantucket
 websitehttp://www.congdonandcoleman.com
 address57 Main Street
 address_2
 cityNantucket
 stateMA
 full_stateMassachusetts
 countryUSA
 marketNantucket
 market_2
 postal_code02554
 phone(508) 325-5016
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTom Kennelly
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-tom-kennelly-president-congdon-and-coleman-real-estate/
 contact_big_profile_link_text
 contact_titlePresident, Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename37.jpg
 logo_filename37.png
 contact_image_filename37.jpg
 all_properties_link_image_filename37.jpg
 all_properties_linkhttp://www.congdonandcoleman.com/nantucket-sales/homes.asp
 video_embed_code
 contact_video_embed_code
 meta_titleNantucket Real Estate | Congdon & Coleman Real Estate | Leverage Global Partners
 meta_descriptionCongdon & Coleman Real Estate is Leverage Global Partners' exclusive representative in Nantucket, MA, USA.
 meta_keywordsNantucket real estate, Massachusetts real estate, Tom Kennelly, Congdon & Coleman, 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-07-24 14:33:33
 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)
 id2347
 modelBrokerage
 model_id37
 tagLogo
 name37.png
 typeimage/png
 size8160
 uri/assets/2347.png
 order0
 created2016-03-30 11:37:49
 modified2016-03-30 11:37:49
 MainImage(array)
 id2346
 modelBrokerage
 model_id37
 tagMainImage
 name37.jpg
 typeimage/jpg
 size475042
 uri/assets/2346.jpg
 order0
 created2016-03-30 11:37:49
 modified2016-03-30 11:37:49
 ContactImage(array)
 id2348
 modelBrokerage
 model_id37
 tagContactImage
 name37.jpg
 typeimage/jpg
 size1509054
 uri/assets/2348.jpg
 order0
 created2016-03-30 11:37:49
 modified2016-03-30 11:37:49
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(array)
 id102
 modelBrokerage
 model_id37
 archived(false)
 medium_featured(false)
 large_featured(false)
 titleMeet Tom Kennelly: President, Congdon and Coleman Real Estate
 authorLeverageRE
 date2013-08-31
 lead_in"When people arrive on Nantucket Island off the boat or plane, they feel as if they have taken a step back in time,” explains Tom Kennelly, President of Congdon and Coleman Real Estate. "The island has the feel of a summer camp for families. Take a walk on the moors, the miles of public beaches, communicate with nature, and embrace it. "
 body <img class="aligncenter size-large wp-image-1588 pure-img" src="/assets/247.jpg" alt="Aerial_of_harbor_(KN)_-(ZF-0683-92932-1-001)" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Aerial_of_harbor_KN_-ZF-0683-92932-1-001-585x381.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Aerial_of_harbor_KN_-ZF-0683-92932-1-001.jpg 1024w" sizes="(max-width: 1024px) 100vw, 1024px"> Tom and his team of agents at Congdon and Coleman Real Estate are Nantucket residents and appreciate all that life there has to offer. The preservation of homes dating back to the 1800s and a lifestyle of water, beaches, golf, sailing and fishing is of utmost importance. Tom expresses great pride when noting that over half of Nantucket Island is strictly protected and preserved for conservation. <img class="aligncenter size-large wp-image-1587 pure-img" src="/assets/248.jpg" alt="Hazlegrove-1763-(ZF-0683-92932-1-003)" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Hazlegrove-1763-ZF-0683-92932-1-003-585x389.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Hazlegrove-1763-ZF-0683-92932-1-003-300x200.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Hazlegrove-1763-ZF-0683-92932-1-003-360x240.jpg 360w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Hazlegrove-1763-ZF-0683-92932-1-003-600x400.jpg 600w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Hazlegrove-1763-ZF-0683-92932-1-003.jpg 1024w" sizes="(max-width: 1024px) 100vw, 1024px"> With a background in renovating Nantucket homes, Tom appreciates "the story of the home," that may even lie hidden under the floorboards. Described by his colleagues as "amusing," "generous to a fault" and a "supportive team player," Tom's knowledge and expertise in the field of real estate is rivaled only by his passion and respect for the "value of the island's historic heritage." <img class="aligncenter size-large wp-image-1586 pure-img" src="/assets/249.jpg" alt="Kayaking_at_Coskata_(KN)-2-(ZF-0683-92932-1-005)" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Kayaking_at_Coskata_KN-2-ZF-0683-92932-1-005-585x385.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Kayaking_at_Coskata_KN-2-ZF-0683-92932-1-005.jpg 1024w" sizes="(max-width: 1024px) 100vw, 1024px"> <h4>What was your vision when stepping into your leadership role at Congdon and Coleman and what accomplishments are you most proud of?</h4> <blockquote>Tom: Congdon and Coleman has existed since 1931, so when I took it over in 1985, I was most interested in carrying on the founders’ legacy. They had a real affection for this island. After almost 30 years of introducing families to the wonders of Nantucket, I am most pleased that many have become life-long friends over many generations.</blockquote> <h4>What do you love most about living and working in Nantucket?</h4> <blockquote>Tom: Aside from the fact that the island is a world-class resort destination during the spring, summer and fall, the real soul of the community is best appreciated in the off-season when we relax into the joys of small town living. My children were born here; my son, Mason, works beside me, as does my nephew, Matt Payne.</blockquote> <img class="aligncenter size-large wp-image-1585 pure-img" src="/assets/250.jpg" alt="Main_Street_Morning_(GH)-(ZF-0683-92932-1-002)" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Main_Street_Morning_GH-ZF-0683-92932-1-002-300x200.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Main_Street_Morning_GH-ZF-0683-92932-1-002-585x389.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Main_Street_Morning_GH-ZF-0683-92932-1-002-360x240.jpg 360w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Main_Street_Morning_GH-ZF-0683-92932-1-002-600x400.jpg 600w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Main_Street_Morning_GH-ZF-0683-92932-1-002.jpg 1024w" sizes="(max-width: 1024px) 100vw, 1024px"> <h4>How has technology, social media and online marketing changed your approach to business?</h4> <blockquote>Tom: I can still remember when we bought our first computer. We have fully embraced all that technology has to offer, working to stay in constant contact via smart phones and iPads. We have a professional SEO team to maximize our web presence. Our association with Leverage Global Partners is the latest example.</blockquote> <img class="aligncenter size-large wp-image-1584 pure-img" src="/assets/251.jpg" alt="Paddleboarder_(GH)-(ZF-0683-92932-1-004)" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Paddleboarder_GH-ZF-0683-92932-1-004-585x329.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Paddleboarder_GH-ZF-0683-92932-1-004.jpg 1024w" sizes="(max-width: 1024px) 100vw, 1024px"> When not at the helm of the office, Tom can be found sailing a Swan 46 around New England and the Caribbean or golfing at the Sankaty Golf Club where his game "continues to humble me!" Leverage Global Partners is honored to have Tom Kennelly and Congdon and Coleman Real Estate as members of the network.
 vimeo_id
 created2016-02-25 14:09:01
 modified2016-04-05 14:41:06
 uri/articles/view/102/meet-tom-kennelly-president-congdon-and-coleman-real-estate
 FeaturedImage(empty)
 Location(array)
 0(array)
 id156
 parent_id7
 brokerage_id37
 typeExclusive
 archived(false)
 use_as_topic(true)
 nameNantucket, MA, USA
 short_nameNantucket, MA, USA
 group_index
 latitude41.283470
 longitude-70.099449
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 15:41:00
 modified2016-04-14 10:55:17
 timezoneAmerica/New_York
 population10500
 uri/locations/view/156/nantucket-ma-usa
 tile_nameNantucket, MA, USA
 User(array)
 0(array)
 id86
 typeBrokerageAdmin
 brokerage_id37
 email[email protected]
 passwordf9492e65b683bc67dda66f994a01ecfb704a5f81
 recover_hash
 first_nameTom
 last_nameKennelly
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2016-04-12 08:25:45
 created2016-04-08 16:33:30
 notified(true)
 full_nameTom Kennelly
 uri/agent-detail/86/tom-kennelly
 profile_complete(true)
 1(array)
 id839
 typeAgent
 brokerage_id37
 email[email protected]
 password9f98fcf000bd9fe90cbeec2b8ade5e7ff3b9a379
 recover_hash
 first_nameMatt
 last_namePayne
 title
 dre_num
 phone508-325-5023
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:40
 created2017-08-07 15:23:40
 notified(false)
 full_nameMatt Payne
 uri/agent-detail/839/matt-payne
 profile_complete(true)
 2(array)
 id840
 typeAgent
 brokerage_id37
 email[email protected]
 password402b73a0770d26060597ee63a9728d66a26906ed
 recover_hash
 first_nameTom
 last_nameWeinstock
 title
 dre_num
 phone508-325-5022
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:40
 created2017-08-07 15:23:40
 notified(false)
 full_nameTom Weinstock
 uri/agent-detail/840/tom-weinstock
 profile_complete(true)
 3(array)
 id841
 typeAgent
 brokerage_id37
 email[email protected]
 password33a66f30695b51cebb19decd4c88a3b5bfbfcc37
 recover_hash
 first_nameJoyce
 last_nameMontalbano
 title
 dre_num
 phone508-325-5015
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:40
 created2017-08-07 15:23:40
 notified(false)
 full_nameJoyce Montalbano
 uri/agent-detail/841/joyce-montalbano
 profile_complete(true)
 4(array)
 id992
 typeAgent
 brokerage_id37
 email[email protected]
 password5baeaf88d43aa4052b6e23b3052599692fa93cf9
 recover_hash
 first_nameAnne
 last_nameGifford
 title
 dre_num
 phone508-221-0388
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:47
 created2017-08-07 15:23:47
 notified(false)
 full_nameAnne Gifford
 uri/agent-detail/992/anne-gifford
 profile_complete(true)
 uri/brokerage-detail/37/congdon-coleman-real-estate
 website_shortwww.congdonandcoleman.com
 name_with_locationCongdon & Coleman Real Estate - Nantucket, MA, 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)
 id15383
 modelProperty
 model_id2371
 tagImage
 name22105.jpg
 typeimage/jpg
 size703684
 uri/assets/15383.jpg
 order0
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:02
 1(array)
 id15384
 modelProperty
 model_id2371
 tagImage
 name22106.jpg
 typeimage/jpg
 size397831
 uri/assets/15384.jpg
 order1
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:02
 2(array)
 id15385
 modelProperty
 model_id2371
 tagImage
 name22107.jpg
 typeimage/jpg
 size338060
 uri/assets/15385.jpg
 order2
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:02
 3(array)
 id15386
 modelProperty
 model_id2371
 tagImage
 name22108.jpg
 typeimage/jpg
 size272294
 uri/assets/15386.jpg
 order3
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:02
 4(array)
 id15387
 modelProperty
 model_id2371
 tagImage
 name22109.jpg
 typeimage/jpg
 size296023
 uri/assets/15387.jpg
 order4
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:02
 5(array)
 id15388
 modelProperty
 model_id2371
 tagImage
 name22110.jpg
 typeimage/jpg
 size751307
 uri/assets/15388.jpg
 order5
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:02
 User(array)
 0(array)
 id839
 typeAgent
 brokerage_id37
 email[email protected]
 password9f98fcf000bd9fe90cbeec2b8ade5e7ff3b9a379
 recover_hash
 first_nameMatt
 last_namePayne
 title
 dre_num
 phone508-325-5023
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:40
 created2017-08-07 15:23:40
 notified(false)
 full_nameMatt Payne
 uri/agent-detail/839/matt-payne
 profile_complete(true)
 UsersProperty(array)
 id593
 user_id839
 property_id2371
 sort_order0
 Brokerage(array)
 id37
 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
 WOEID2456968
 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
 nameCongdon & Coleman Real Estate
 broker_of_record_name
 short_nameCongdon & Coleman
 usernameCongdonColeman
 passwordf9492e65b683bc67dda66f994a01ecfb704a5f81
 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
 descriptionCongdon & Coleman Real Estate is the exclusive representative for Leverage Global Partners in Nantucket, Massachusetts, USA. Resident Experts: Nantucket Real Estate & Summer Rentals Congdon & Coleman Real Estate, founded in 1931, is a fourth generation Nantucket business. It is the only combined Nantucket real estate and insurance company on island. Our real estate agents are all Nantucket island residents who are active in the community and committed to preserving the quality of life here. If you choose to invest in Nantucket real estate, rely on the people who know it best. Congdon & Coleman Real Estate is a full service firm handling listing, selling and rentals. Each of our agents is a Realtor and a member of the Cape Cod & Islands Association of Realtors. We are also members of the Nantucket Association of Real Estate Brokers, which gives us accurate, current information on all properties for sale on Nantucket. When you list your property with Congdon & Coleman, inclusion with this service ensures that your property receives maximum exposure to all agents on Nantucket. Simply put, our brokers can show you any Nantucket real estate for sale on the island.
 communitiesNantucket
 websitehttp://www.congdonandcoleman.com
 address57 Main Street
 address_2
 cityNantucket
 stateMA
 full_stateMassachusetts
 countryUSA
 marketNantucket
 market_2
 postal_code02554
 phone(508) 325-5016
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTom Kennelly
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-tom-kennelly-president-congdon-and-coleman-real-estate/
 contact_big_profile_link_text
 contact_titlePresident, Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename37.jpg
 logo_filename37.png
 contact_image_filename37.jpg
 all_properties_link_image_filename37.jpg
 all_properties_linkhttp://www.congdonandcoleman.com/nantucket-sales/homes.asp
 video_embed_code
 contact_video_embed_code
 meta_titleNantucket Real Estate | Congdon & Coleman Real Estate | Leverage Global Partners
 meta_descriptionCongdon & Coleman Real Estate is Leverage Global Partners' exclusive representative in Nantucket, MA, USA.
 meta_keywordsNantucket real estate, Massachusetts real estate, Tom Kennelly, Congdon & Coleman, 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-07-24 14:33:33
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/37/congdon-coleman-real-estate
 website_shortwww.congdonandcoleman.com
 name_with_locationCongdon & Coleman Real Estate
 Image(empty)
 BrokerageLogoOverride(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)
 id3143
 property_id2371
 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
 Topic(empty)
- membership_subscription_temp_allowed_login(null)
- newsletter_member_types(array)
 Leverage Member: AgentLeverage Member: Agent
 Leverage Member: Broker or ManagementLeverage Member: Broker or Management
 Non-MemberNon-Member
- $request->data(empty)
- $this->validationErrors(array)
 Subscription(empty)
 Property(empty)
 User(empty)
 PropertyFeature(empty)
 SecondaryPropertyCategory(empty)
 Topic(empty)
 PrimaryPropertyCategory(empty)
 Brokerage(empty)
 StripeSubscription(empty)
 GlobalReachReport(empty)
 AccountExecutive(empty)
 Logo(empty)
 MainImage(empty)
 ContactImage(empty)
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 Location(empty)
 FeaturedImage(empty)
 Image(empty)
 UsersProperty(empty)
 BrokerageLogoOverride(empty)
 PropertiesSecondaryPropertyCategory(empty)
 PropertiesPropertyFeature(empty)
 Icon(empty)
 PropertiesTopic(empty)
- Loaded Helpers(array)
 0Permission
 1Number
 2SimpleGraph
 3DebugTimer
 4Toolbar
 5Session
 6Text
 7Flash
 8HtmlToolbar
 9Html
 10Form
====

Environment

App Constants

Constant	Value
CONFIG	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Config/
GOOGLE_MAPS_PUBLIC_API_KEY	AIzaSyCD2zmgSzOEN-7tNHYSmGXL0MyWtMlHND4
GOOGLE_MAPS_PRIVATE_API_KEY	AIzaSyCIXpqYsaZp4_suK7IWeqUTIEbS_hMkoXs
RECAPTCHA_V2_SITE_KEY	6Lfs_EoUAAAAAKe8XSwR8p7AEMOLWB96veSLjRDv
RECAPTCHA_V2_SECRET_KEY	6Lfs_EoUAAAAAIo2vzNYILL-YwBaRxvTpjuemmKZ
PROTOCOL	https://
WEB_ENV	staging2
WEB_BASE_URL	https://staging2.leveragere.com
PROP_EMAIL_RECIPIENT	[email protected]
STRIPE_ISSUES_EMAIL_RECIPIENT	[email protected]
STRIPE_ENV	test
STRIPE_PK	pk_test_fIc7eHMfMVAhnrld2Vk2DDpG
STRIPE_SK	sk_test_D4NvWbVo5Fe04IJM0AItMKIR
SHELL_LAUNCHER	/opt/plesk/php/7.4/bin/php /var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Console/cake.php

CakePHP Constants

Constant	Value
APP	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/
APP_DIR	app
APPLIBS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Lib/
CACHE	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/tmp/cache/
CAKE	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib
CORE_PATH	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib/
CAKE_VERSION	2.10.19
CSS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://staging2.leveragere.com
IMAGES	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/img/
IMAGES_URL	img/
JS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/js/
JS_URL	js/
LOGS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/tmp/logs/
ROOT	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs
TESTS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Test/
TMP	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/tmp/
VENDORS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	7.4.33
User	leveragere
Home	/var/www/vhosts/leveragere.com
Script Name	/index.php
Request Uri	/property-detail/2371/5-hedgebury-lane-nantucket-ma-02554-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/property-detail/2371/5-hedgebury-lane-nantucket-ma-02554-usa
Remote Port	20281
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	162.159.115.42
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
Http Accept Encoding	gzip, br
Http Accept	/
Http Cf Ray	a09cc3d87c42f4d4-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	aioMMiieIsN216dqNcqFJQAAARE
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	aioMMiieIsN216dqNcqFJQAAARE
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781140530.0876
Request Time	1781140530

====

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

Classic Cottage

Represented By: Congdon & Coleman Real Estate

www.congdonandcoleman.com | License #: 012345

Highlighted Properties

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

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