Properties /

Infinite Possibilities

848 Montgomery Road | Pownal, VT 05261, USA | $450,000 | MLS ID: 210929

2 Beds
1 Bath
129.00 Acres
Views

Build your dream home! Spectacular 129 acre parcel with 180 degree views bordering Hopkins Forest. Includes a 49acre +/- building site with stunning views and subdivision potential, plus 80 acres of recreational woodland above the build zone and $100,000 of timber value. Site also includes a small dwelling with two bedrooms and one bath on a separate 2.7 acre parcel. Private setting.

Represented By: Alton & Westall Real Estate Agency

altonwestall.com | License #: 012345

Ann Greenwood
413-458-8366
Email

Main Office: 77 Water Street
Williamstown, MA 01267
USA

More About Ann

View On Map Property Website

Highlighted Properties

The Nehemiah Smedley House

530 Main Street | Williamstown, MA 01267
$685,000

Absolute Privacy

839 Green River Road | Williamstown, MA 01267
$995,000

Represented By

Agent Contacts: Ann Greenwood 413-458-8366 | Email

Featured Location

Berkshire County, MA, USA

Williamstown is a vibrant, four-seasons cultural and outdoors destination.

Related Property Listings

Splendid Retreat

222 Ide Road
Williamstown, MA 01267
$3,100,000

Absolute Privacy

839 Green River Road
Williamstown, MA 01267
$995,000

Iconic Victorian

148 South Street
Williamstown, MA 01267
$770,000

Beautiful Townhouse Condominium

32 Holden Street
North Adams, MA 01247
$249,500

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)
  03622
  1848-montgomery-road-pownal-vt-05261-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` = 3622 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` = 145 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` = 145 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` = 145 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` = 145 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` = 145 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` = 145 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` = 145 AND `MainArticle`.`model` = 'Brokerage'	0	0	0
SELECT `FeaturedImage`.`id`, `FeaturedImage`.`model`, `FeaturedImage`.`model_id`, `FeaturedImage`.`tag`, `FeaturedImage`.`name`, `FeaturedImage`.`type`, `FeaturedImage`.`size`, `FeaturedImage`.`uri`, `FeaturedImage`.`order`, `FeaturedImage`.`created`, `FeaturedImage`.`modified` FROM `leveragere_staging2`.`assets` AS `FeaturedImage` WHERE `FeaturedImage`.`model` = 'Brokerage' AND `FeaturedImage`.`tag` = 'FeaturedImage' AND `FeaturedImage`.`model_id` = (145) 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` = (145)	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` = (145)	10	10	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` = (3622) ORDER BY `Image`.`order` ASC	8	8	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` = 3622 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` = 145	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` = 1095 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` = 1095 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` = 3622 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` = 3622 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` = 14 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` = 3622 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` != 3622 AND `Property`.`brokerage_id` = 145 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 (3276, 2897) ORDER BY `Image`.`order` ASC	20	20	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 (3276, 2897) 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 (3276, 2897) 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 (3276, 2897) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	4	4	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 (3276, 2897) 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` = 145 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` = 145 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 (1302, 2897, 2816, 3620) ORDER BY `Image`.`order` ASC	40	40	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 (1302, 2897, 2816, 3620) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	5	5	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 (1302, 2897, 2816, 3620) 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 (1302, 2897, 2816, 3620) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	7	7	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 (1302, 2897, 2816, 3620) 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.66 MB

Message	Memory use
Component initialization	3.09 MB
Controller action start	4.02 MB
Controller render start	6.83 MB
View render complete	7.34 MB

Timers

Total Request Time: 213 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	31.25
Event: Controller.initialize	3.76
Event: Controller.startup	1.08
Controller action	39.99
Event: Controller.beforeRender	16.49
» Processing toolbar data	16.37
Rendering View	84.91
» Event: View.beforeRender	0.28
» Rendering APP/View/Properties/view.ctp	3.24
» » Rendering APP/View/Elements/static_property_price.ctp	0.40
» » Rendering APP/View/Elements/property_features.ctp	0.22
» » Rendering APP/View/Elements/static_property_price.ctp #2	0.16
» » 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.02
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #5	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #6	0.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	80.69
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)
 id1302
 brokerage_id145
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id104
 agent_2_id106
 agent_3_id0
 nameSplendid Retreat
 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(true)
 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)
 descriptionElegant simplicity is the trademark of this American Craftsman-style residence. Sited on 2.775 acres, this magnificent country home is well-suited to large-scale entertaining with a total of eight bedrooms, seven and one-half baths, and over seven thousand square feet of living space. Classic grooved paneling, gleaming hardwood flooring, French doors and five fireplaces enhance the living areas, which include a formal living room, dining room, library, and kitchen open to dining area and family room. The property also features an attached guest house and a separate garage with second floor living suite. Mature trees, stone walls, beautiful gardens, an in-ground pool and picturesque mountain views complete this rare offering.
 address222 Ide Road
 address_2
 cityWilliamstown
 stateMA
 postal_code01267
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price3100000
 price_20
 price_usd3100000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms8
 bedrooms_20
 bathrooms7
 bathrooms_20
 no_beds_baths(false)
 square_feet7215
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1pool
 icon_2sq-ft
 icon_3views
 icon_4guest-house
 icon_5
 icon_6
 websitehttp://www.altonwestall.com/listing/202873/williamstown-ma-01267/
 meta_titleSplendid Retreat | Williamstown Real Estate | Alton & Westall Real Estate Agency
 meta_description222 Ide Road is a property offered for sale in Williamstown, MA, USA, presented by Alton & Westall Real Estate Agency
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1911
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num202873
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style20
 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
 latitude42.698605
 longitude-73.207275
 invalid_required_fields
 invalid_optional_fieldssquare_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
 created2014-11-11 14:44:09
 uri/property-detail/1302/222-ide-road-williamstown-ma-01267-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/1302/222-ide-road-williamstown-ma-01267-usa
 address_concat222 Ide Road Williamstown MA 01267 USA
 google_maps_query_string222+Ide+Road++Williamstown+MA+01267+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 3,100,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty8
 bathrooms_pretty7
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms7
 date_listed2014-11-11
 overridden_brokerage_nameAlton & Westall Real Estate Agency
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id145
 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_properties8
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID12758413
 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
 nameAlton & Westall Real Estate Agency
 broker_of_record_name
 short_nameAlton & Westall Real Estate Agency
 usernameAltonWestallRealEstate
 passwordd866aafebe077fad3e92c6ce0d311a3d9d8955d2
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionAlton & Westall Real Estate Agency is the exclusive representative for Leverage Global Partners in Berkshire County, Williamstown, North Adams, Adams, Richmond, Otis, Becket, Alford, Lanesborough, Lee, Dalton, Pittsfield, Lenox, West Stockbridge, Great Barrington, Massachusetts, USA. With more than 40 years of experience, the agency was founded in 1971 by Philip M. Alton and later joined by Donald J. Westall in 1984. The Alton & Westall Agency has made its home in Northern Berkshire County in the historic town of Williamstown, Massachusetts. Alton & Westall Agency is a full service firm that specializes in the listing and selling of fine real estate, including homes, acreage, and commercial property in and around Williamstown, Massachusetts, Berkshire County and Southwest Vermont. The Agency is licensed in Massachusetts and Vermont and all of its associates are members of the Berkshire County Board of REALTORS®. Alton & Westall and its team are active in the community and are committed to preserving the quality of life here in Williamstown and in the greater Berkshire County area.
 communitiesBerkshire County Williamstown North Adams Adams Richmond Otis Becket Alford Lanesborough Lee Dalton Pittsfield Lenox West Stockbridge Great Barrington
 websitehttp://altonwestall.com/
 address77 Water Street
 address_2
 cityWilliamstown
 stateMA
 full_stateMassachusetts
 countryUSA
 marketBerkshire County
 market_2
 postal_code01267
 phoneOffice: (413) 458-8366
 phone_2Cell: (413) 822-4337
 phone_3
 wide_contact_image(false)
 contact_nameDaniel J. Trombley
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename145.jpg
 logo_filename145.jpg
 contact_image_filename145.jpg
 all_properties_link_image_filename145.jpg
 all_properties_linkhttp://www.altonwestall.com/real-estate/our-listings/
 video_embed_code
 contact_video_embed_code
 meta_titleBerkshire County Real Estate | Alton & Westall Real Estate Agency | Leverage Global Partners
 meta_descriptionAlton & Westall Real Estate Agency is the exclusive representative for Leverage Global Partners in Berkshire County, Massachusetts, USA.
 meta_keywordsAlton & Westall Real Estate Agency, Berkshire County, Dan Trombley, Berkshire County Real Estate, Williamstown Real Estate, North Adams Real Estate, Adams Real Estate, Richmond Real Estate, Otis Real Estate, Becket Real Estate, Alford Real Estate, Lanesborough Real Estate, Lee Real Estate, Dalton Real Estate, Pittsfield Real Estate, Lenox Real Estate, West Stockbridge Real Estate, Great Barrington Real Estate, Massachusetts Real Estate, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-07-22 17:09:11
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/145/alton-westall-real-estate-agency
 website_shortaltonwestall.com
 name_with_locationAlton & Westall Real Estate Agency
 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)
 id12619
 modelProperty
 model_id1302
 tagImage
 name11216.jpg
 typeimage/jpg
 size633420
 uri/assets/12619.jpg
 order0
 created2016-04-07 16:34:04
 modified2016-04-07 16:34:04
 1(array)
 id12620
 modelProperty
 model_id1302
 tagImage
 name11217.jpg
 typeimage/jpg
 size440698
 uri/assets/12620.jpg
 order1
 created2016-04-07 16:34:04
 modified2016-04-07 16:34:04
 2(array)
 id12621
 modelProperty
 model_id1302
 tagImage
 name11218.jpg
 typeimage/jpg
 size288459
 uri/assets/12621.jpg
 order2
 created2016-04-07 16:34:04
 modified2016-04-07 16:34:04
 3(array)
 id12622
 modelProperty
 model_id1302
 tagImage
 name11219.jpg
 typeimage/jpg
 size278278
 uri/assets/12622.jpg
 order3
 created2016-04-07 16:34:04
 modified2016-04-07 16:34:04
 4(array)
 id12623
 modelProperty
 model_id1302
 tagImage
 name11220.jpg
 typeimage/jpg
 size579996
 uri/assets/12623.jpg
 order4
 created2016-04-07 16:34:04
 modified2016-04-07 16:34:04
 5(array)
 id12624
 modelProperty
 model_id1302
 tagImage
 name11221.jpg
 typeimage/jpg
 size302145
 uri/assets/12624.jpg
 order5
 created2016-04-07 16:34:04
 modified2016-04-07 16:34:04
 6(array)
 id12625
 modelProperty
 model_id1302
 tagImage
 name11222.jpg
 typeimage/jpg
 size643344
 uri/assets/12625.jpg
 order6
 created2016-04-07 16:34:04
 modified2016-04-07 16:34:04
 7(array)
 id12626
 modelProperty
 model_id1302
 tagImage
 name11223.jpg
 typeimage/jpg
 size725034
 uri/assets/12626.jpg
 order7
 created2016-04-07 16:34:04
 modified2016-04-07 16:34:04
 8(array)
 id12627
 modelProperty
 model_id1302
 tagImage
 name11224.jpg
 typeimage/jpg
 size473732
 uri/assets/12627.jpg
 order8
 created2016-04-07 16:34:04
 modified2016-04-07 16:34:04
 9(array)
 id12628
 modelProperty
 model_id1302
 tagImage
 name11225.jpg
 typeimage/jpg
 size544471
 uri/assets/12628.jpg
 order9
 created2016-04-07 16:34:04
 modified2016-04-07 16:34:04
 User(array)
 0(array)
 id333
 typeAgent
 brokerage_id145
 email[email protected]
 password05f9fdb61eaf059941799df7972af8bad81cd833
 recover_hash
 first_nameMaureen
 last_nameDietze
 title
 dre_num
 phone413-458-8366
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:47
 created2017-08-07 15:22:47
 notified(false)
 full_nameMaureen Dietze
 uri/agent-detail/333/maureen-dietze
 profile_complete(true)
 UsersProperty(array)
 id119
 user_id333
 property_id1302
 sort_order0
 1(array)
 id335
 typeAgent
 brokerage_id145
 email[email protected]
 passwordf4c7dc60ec240171ade7c8cf4e9be2dcff88b573
 recover_hash
 first_nameCheryl
 last_nameWestall
 title
 dre_num
 phone413-458-8366
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:47
 created2017-08-07 15:22:47
 notified(false)
 full_nameCheryl Westall
 uri/agent-detail/335/cheryl-westall
 profile_complete(true)
 UsersProperty(array)
 id124
 user_id335
 property_id1302
 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)
 id2363
 property_id1302
 property_feature_id12
 1(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id2364
 property_id1302
 property_feature_id14
 2(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id2365
 property_id1302
 property_feature_id5
 Topic(empty)
 1(array)
 Property(array)
 id2897
 brokerage_id145
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id104
 agent_2_id0
 agent_3_id0
 nameAbsolute Privacy
 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(true)
 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)
 descriptionEncompassing over 10 acres of meadows and woodlands, including a small wildlife pond, this stunning estate, offering gorgeous mountain views, assures total privacy for its owner. Lovely brick patios, stone walls, and country-style landscaping provide a perfect setting for the expansive residence, designed by David Todd & Associates in the late 1960’s, and constructed with the finest materials available, including silver grey stained cedar inside and out, granite mantels, hearths and stairs, and smooth-finished deep red/brown brick in the entry foyer and Grand Hall. Large windows, clerestory windows and sliding doors allow abundant natural light to bath the interior by day, while by night upturned wall sconces create a most dramatic ambiance. With understated elegance, this property is timelessly appropriate here in the Berkshires.
 address839 Green River Road
 address_2
 cityWilliamstown
 stateMA
 postal_code01267
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price995000
 price_20
 price_usd995000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres10
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size10
 icon_1views
 icon_2acreage
 icon_3pool
 icon_4garage
 icon_5
 icon_6
 website
 meta_titleAbsolute Privacy | Williamstown Real Estate | Alton & Westall Real Estate Agency
 meta_description839 Green River Road is a property offered for sale in Williamstown, MA, USA, presented by Alton & Westall Real Estate Agency
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1970
 virtual_tourhttp://tours.vestaphotostudio.com/public/vtour/display/378450
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num211312
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style17
 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
 latitude42.692318
 longitude-73.201050
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, hectares, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-10-14 12:17:45
 uri/property-detail/2897/839-green-river-road-williamstown-ma-01267-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2897/839-green-river-road-williamstown-ma-01267-usa
 address_concat839 Green River Road Williamstown MA 01267 USA
 google_maps_query_string839+Green+River+Road++Williamstown+MA+01267+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 995,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty3
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2015-10-14
 overridden_brokerage_nameAlton & Westall Real Estate Agency
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id145
 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_properties8
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID12758413
 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
 nameAlton & Westall Real Estate Agency
 broker_of_record_name
 short_nameAlton & Westall Real Estate Agency
 usernameAltonWestallRealEstate
 passwordd866aafebe077fad3e92c6ce0d311a3d9d8955d2
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionAlton & Westall Real Estate Agency is the exclusive representative for Leverage Global Partners in Berkshire County, Williamstown, North Adams, Adams, Richmond, Otis, Becket, Alford, Lanesborough, Lee, Dalton, Pittsfield, Lenox, West Stockbridge, Great Barrington, Massachusetts, USA. With more than 40 years of experience, the agency was founded in 1971 by Philip M. Alton and later joined by Donald J. Westall in 1984. The Alton & Westall Agency has made its home in Northern Berkshire County in the historic town of Williamstown, Massachusetts. Alton & Westall Agency is a full service firm that specializes in the listing and selling of fine real estate, including homes, acreage, and commercial property in and around Williamstown, Massachusetts, Berkshire County and Southwest Vermont. The Agency is licensed in Massachusetts and Vermont and all of its associates are members of the Berkshire County Board of REALTORS®. Alton & Westall and its team are active in the community and are committed to preserving the quality of life here in Williamstown and in the greater Berkshire County area.
 communitiesBerkshire County Williamstown North Adams Adams Richmond Otis Becket Alford Lanesborough Lee Dalton Pittsfield Lenox West Stockbridge Great Barrington
 websitehttp://altonwestall.com/
 address77 Water Street
 address_2
 cityWilliamstown
 stateMA
 full_stateMassachusetts
 countryUSA
 marketBerkshire County
 market_2
 postal_code01267
 phoneOffice: (413) 458-8366
 phone_2Cell: (413) 822-4337
 phone_3
 wide_contact_image(false)
 contact_nameDaniel J. Trombley
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename145.jpg
 logo_filename145.jpg
 contact_image_filename145.jpg
 all_properties_link_image_filename145.jpg
 all_properties_linkhttp://www.altonwestall.com/real-estate/our-listings/
 video_embed_code
 contact_video_embed_code
 meta_titleBerkshire County Real Estate | Alton & Westall Real Estate Agency | Leverage Global Partners
 meta_descriptionAlton & Westall Real Estate Agency is the exclusive representative for Leverage Global Partners in Berkshire County, Massachusetts, USA.
 meta_keywordsAlton & Westall Real Estate Agency, Berkshire County, Dan Trombley, Berkshire County Real Estate, Williamstown Real Estate, North Adams Real Estate, Adams Real Estate, Richmond Real Estate, Otis Real Estate, Becket Real Estate, Alford Real Estate, Lanesborough Real Estate, Lee Real Estate, Dalton Real Estate, Pittsfield Real Estate, Lenox Real Estate, West Stockbridge Real Estate, Great Barrington Real Estate, Massachusetts Real Estate, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-07-22 17:09:11
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/145/alton-westall-real-estate-agency
 website_shortaltonwestall.com
 name_with_locationAlton & Westall Real Estate Agency
 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)
 id17260
 modelProperty
 model_id2897
 tagImage
 name27709.jpg
 typeimage/jpg
 size310121
 uri/assets/17260.jpg
 order0
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 1(array)
 id17261
 modelProperty
 model_id2897
 tagImage
 name27710.jpg
 typeimage/jpg
 size240581
 uri/assets/17261.jpg
 order1
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 2(array)
 id17262
 modelProperty
 model_id2897
 tagImage
 name27711.jpg
 typeimage/jpg
 size283192
 uri/assets/17262.jpg
 order2
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 3(array)
 id17265
 modelProperty
 model_id2897
 tagImage
 name27714.jpg
 typeimage/jpg
 size265870
 uri/assets/17265.jpg
 order3
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 4(array)
 id17264
 modelProperty
 model_id2897
 tagImage
 name27713.jpg
 typeimage/jpg
 size264173
 uri/assets/17264.jpg
 order4
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 5(array)
 id17266
 modelProperty
 model_id2897
 tagImage
 name27715.jpg
 typeimage/jpg
 size279939
 uri/assets/17266.jpg
 order5
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 6(array)
 id17263
 modelProperty
 model_id2897
 tagImage
 name27712.jpg
 typeimage/jpg
 size330325
 uri/assets/17263.jpg
 order6
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 7(array)
 id17267
 modelProperty
 model_id2897
 tagImage
 name27716.jpg
 typeimage/jpg
 size396342
 uri/assets/17267.jpg
 order7
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 8(array)
 id17268
 modelProperty
 model_id2897
 tagImage
 name27717.jpg
 typeimage/jpg
 size291044
 uri/assets/17268.jpg
 order8
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 9(array)
 id17269
 modelProperty
 model_id2897
 tagImage
 name27718.jpg
 typeimage/jpg
 size361935
 uri/assets/17269.jpg
 order9
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 User(array)
 0(array)
 id333
 typeAgent
 brokerage_id145
 email[email protected]
 password05f9fdb61eaf059941799df7972af8bad81cd833
 recover_hash
 first_nameMaureen
 last_nameDietze
 title
 dre_num
 phone413-458-8366
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:47
 created2017-08-07 15:22:47
 notified(false)
 full_nameMaureen Dietze
 uri/agent-detail/333/maureen-dietze
 profile_complete(true)
 UsersProperty(array)
 id121
 user_id333
 property_id2897
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id3617
 property_id2897
 property_feature_id14
 1(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id3618
 property_id2897
 property_feature_id12
 2(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id3619
 property_id2897
 property_feature_id4
 Topic(empty)
 2(array)
 Property(array)
 id2816
 brokerage_id145
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id104
 agent_2_id0
 agent_3_id0
 nameIconic Victorian
 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(true)
 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)
 descriptionBuilt in 1888 by Archibald Hopkins, son of Williams College President Mark Hopkins, this superbly located and stunning Victorian is one of Williamstown’s premier properties. Just minutes from the prestigious Clark Art Institute, the incomparable residence shares a spacious two thirds of an acre with wonderful gardens, gorgeous Goshen stone walls and two lovely pergolas. The gracious entry hall, distinguished by a dramatic stairway with soaring leaded glass windows, leads to elegant living and dining rooms, and a warm bookshelf-lined library. All have French doors opening to an inviting covered porch and open terrace overlooking the enchanting landscape beyond. With five bedrooms and three full and two half baths, this beautiful home, brimming with fine architectural details, provides ample room for family and guests. Close proximity to Williams College, the Williamstown Theater Festival and all in-town attractions.
 address148 South Street
 address_2
 cityWilliamstown
 stateMA
 postal_code01267
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price770000
 price_20
 price_usd770000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms5
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1garage
 icon_2library
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_titleIconic Victorian | Williamstown Real Estate | Alton & Westall Real Estate Agency
 meta_description148 South Street is a property offered for sale in Williamstown, MA, USA, presented by Alton & Westall Real Estate Agency
 meta_keywords
 bathrooms_partial2
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1888
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num210871
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style45
 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
 latitude42.709301
 longitude-73.211113
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-09-25 13:00:47
 uri/property-detail/2816/148-south-street-williamstown-ma-01267-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2816/148-south-street-williamstown-ma-01267-usa
 address_concat148 South Street Williamstown MA 01267 USA
 google_maps_query_string148+South+Street++Williamstown+MA+01267+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 770,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty3
 bathrooms_partial_pretty2
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2015-09-25
 overridden_brokerage_nameAlton & Westall Real Estate Agency
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id145
 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_properties8
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID12758413
 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
 nameAlton & Westall Real Estate Agency
 broker_of_record_name
 short_nameAlton & Westall Real Estate Agency
 usernameAltonWestallRealEstate
 passwordd866aafebe077fad3e92c6ce0d311a3d9d8955d2
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionAlton & Westall Real Estate Agency is the exclusive representative for Leverage Global Partners in Berkshire County, Williamstown, North Adams, Adams, Richmond, Otis, Becket, Alford, Lanesborough, Lee, Dalton, Pittsfield, Lenox, West Stockbridge, Great Barrington, Massachusetts, USA. With more than 40 years of experience, the agency was founded in 1971 by Philip M. Alton and later joined by Donald J. Westall in 1984. The Alton & Westall Agency has made its home in Northern Berkshire County in the historic town of Williamstown, Massachusetts. Alton & Westall Agency is a full service firm that specializes in the listing and selling of fine real estate, including homes, acreage, and commercial property in and around Williamstown, Massachusetts, Berkshire County and Southwest Vermont. The Agency is licensed in Massachusetts and Vermont and all of its associates are members of the Berkshire County Board of REALTORS®. Alton & Westall and its team are active in the community and are committed to preserving the quality of life here in Williamstown and in the greater Berkshire County area.
 communitiesBerkshire County Williamstown North Adams Adams Richmond Otis Becket Alford Lanesborough Lee Dalton Pittsfield Lenox West Stockbridge Great Barrington
 websitehttp://altonwestall.com/
 address77 Water Street
 address_2
 cityWilliamstown
 stateMA
 full_stateMassachusetts
 countryUSA
 marketBerkshire County
 market_2
 postal_code01267
 phoneOffice: (413) 458-8366
 phone_2Cell: (413) 822-4337
 phone_3
 wide_contact_image(false)
 contact_nameDaniel J. Trombley
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename145.jpg
 logo_filename145.jpg
 contact_image_filename145.jpg
 all_properties_link_image_filename145.jpg
 all_properties_linkhttp://www.altonwestall.com/real-estate/our-listings/
 video_embed_code
 contact_video_embed_code
 meta_titleBerkshire County Real Estate | Alton & Westall Real Estate Agency | Leverage Global Partners
 meta_descriptionAlton & Westall Real Estate Agency is the exclusive representative for Leverage Global Partners in Berkshire County, Massachusetts, USA.
 meta_keywordsAlton & Westall Real Estate Agency, Berkshire County, Dan Trombley, Berkshire County Real Estate, Williamstown Real Estate, North Adams Real Estate, Adams Real Estate, Richmond Real Estate, Otis Real Estate, Becket Real Estate, Alford Real Estate, Lanesborough Real Estate, Lee Real Estate, Dalton Real Estate, Pittsfield Real Estate, Lenox Real Estate, West Stockbridge Real Estate, Great Barrington Real Estate, Massachusetts Real Estate, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-07-22 17:09:11
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/145/alton-westall-real-estate-agency
 website_shortaltonwestall.com
 name_with_locationAlton & Westall Real Estate Agency
 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)
 id16731
 modelProperty
 model_id2816
 tagImage
 name26837.jpg
 typeimage/jpg
 size488265
 uri/assets/16731.jpg
 order0
 created2016-04-07 17:00:05
 modified2016-04-07 17:00:05
 1(array)
 id16734
 modelProperty
 model_id2816
 tagImage
 name26840.jpg
 typeimage/jpg
 size654256
 uri/assets/16734.jpg
 order1
 created2016-04-07 17:00:06
 modified2016-04-07 17:00:06
 2(array)
 id16732
 modelProperty
 model_id2816
 tagImage
 name26838.jpg
 typeimage/jpg
 size543978
 uri/assets/16732.jpg
 order2
 created2016-04-07 17:00:05
 modified2016-04-07 17:00:05
 3(array)
 id16733
 modelProperty
 model_id2816
 tagImage
 name26839.jpg
 typeimage/jpg
 size617571
 uri/assets/16733.jpg
 order3
 created2016-04-07 17:00:05
 modified2016-04-07 17:00:06
 4(array)
 id16735
 modelProperty
 model_id2816
 tagImage
 name26841.jpg
 typeimage/jpg
 size598706
 uri/assets/16735.jpg
 order4
 created2016-04-07 17:00:06
 modified2016-04-07 17:00:06
 5(array)
 id16738
 modelProperty
 model_id2816
 tagImage
 name26844.jpg
 typeimage/jpg
 size632670
 uri/assets/16738.jpg
 order5
 created2016-04-07 17:00:06
 modified2016-04-07 17:00:06
 6(array)
 id16736
 modelProperty
 model_id2816
 tagImage
 name26842.jpg
 typeimage/jpg
 size695512
 uri/assets/16736.jpg
 order6
 created2016-04-07 17:00:06
 modified2016-04-07 17:00:06
 7(array)
 id16737
 modelProperty
 model_id2816
 tagImage
 name26843.jpg
 typeimage/jpg
 size558883
 uri/assets/16737.jpg
 order7
 created2016-04-07 17:00:06
 modified2016-04-07 17:00:06
 8(array)
 id16740
 modelProperty
 model_id2816
 tagImage
 name26846.jpg
 typeimage/jpg
 size852828
 uri/assets/16740.jpg
 order8
 created2016-04-07 17:00:06
 modified2016-04-07 17:00:06
 9(array)
 id16739
 modelProperty
 model_id2816
 tagImage
 name26845.jpg
 typeimage/jpg
 size1303089
 uri/assets/16739.jpg
 order9
 created2016-04-07 17:00:06
 modified2016-04-07 17:00:06
 User(array)
 0(array)
 id333
 typeAgent
 brokerage_id145
 email[email protected]
 password05f9fdb61eaf059941799df7972af8bad81cd833
 recover_hash
 first_nameMaureen
 last_nameDietze
 title
 dre_num
 phone413-458-8366
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:47
 created2017-08-07 15:22:47
 notified(false)
 full_nameMaureen Dietze
 uri/agent-detail/333/maureen-dietze
 profile_complete(true)
 UsersProperty(array)
 id120
 user_id333
 property_id2816
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id3484
 property_id2816
 property_feature_id4
 Topic(empty)
 3(array)
 Property(array)
 id3620
 brokerage_id145
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id1194
 agent_2_id0
 agent_3_id0
 nameBeautiful Townhouse Condominium
 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)
 descriptionLocated in historic downtown North Adams, an up-and-coming artist’s community, this spacious townhouse condominium is within walking distance to MASS MoCA, Main Street, shops, restaurants, and galleries. This four bedroom, two and one-half bath unit offers a combination of modern conveniences and careful preservation of some of the original features of the 1873 landmark. High ceilings, large rooms, lots of closet space, and heat included in the monthly condo fee are just some of the features. Private front and rear entrances. Beautiful mountain and cityscape views. This low maintenance condo in the heart of the Berkshires is priced to sell!
 address32 Holden Street
 address_2
 cityNorth Adams
 stateMA
 postal_code01247
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price249500
 price_20
 price_usd249500
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://www.altonwestall.com/listing/214457/32-holden-north-adams-ma-01247/
 meta_titleBeautiful Townhouse Condominium | North Adams Real Estate | Alton & Westall Real Estate Agency
 meta_description32 Holden Street is a property offered for sale in North Adams, MA, USA, presented by Alton & Westall Real Estate Agency
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1873
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num214457
 wsj_property_typecondominium
 nyt_property_type2
 nyt_popular_features
 propgolux_property_type2
 juwai_property_type
 juwai_category
 propgolux_property_style16
 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
 latitude42.700134
 longitude-73.111893
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-03-18 13:02:39
 uri/property-detail/3620/32-holden-street-north-adams-ma-01247-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3620/32-holden-street-north-adams-ma-01247-usa
 address_concat32 Holden Street North Adams MA 01247 USA
 google_maps_query_string32+Holden+Street++North+Adams+MA+01247+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 249,500
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty2
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2016-03-18
 overridden_brokerage_nameAlton & Westall Real Estate Agency
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id145
 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_properties8
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID12758413
 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
 nameAlton & Westall Real Estate Agency
 broker_of_record_name
 short_nameAlton & Westall Real Estate Agency
 usernameAltonWestallRealEstate
 passwordd866aafebe077fad3e92c6ce0d311a3d9d8955d2
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionAlton & Westall Real Estate Agency is the exclusive representative for Leverage Global Partners in Berkshire County, Williamstown, North Adams, Adams, Richmond, Otis, Becket, Alford, Lanesborough, Lee, Dalton, Pittsfield, Lenox, West Stockbridge, Great Barrington, Massachusetts, USA. With more than 40 years of experience, the agency was founded in 1971 by Philip M. Alton and later joined by Donald J. Westall in 1984. The Alton & Westall Agency has made its home in Northern Berkshire County in the historic town of Williamstown, Massachusetts. Alton & Westall Agency is a full service firm that specializes in the listing and selling of fine real estate, including homes, acreage, and commercial property in and around Williamstown, Massachusetts, Berkshire County and Southwest Vermont. The Agency is licensed in Massachusetts and Vermont and all of its associates are members of the Berkshire County Board of REALTORS®. Alton & Westall and its team are active in the community and are committed to preserving the quality of life here in Williamstown and in the greater Berkshire County area.
 communitiesBerkshire County Williamstown North Adams Adams Richmond Otis Becket Alford Lanesborough Lee Dalton Pittsfield Lenox West Stockbridge Great Barrington
 websitehttp://altonwestall.com/
 address77 Water Street
 address_2
 cityWilliamstown
 stateMA
 full_stateMassachusetts
 countryUSA
 marketBerkshire County
 market_2
 postal_code01267
 phoneOffice: (413) 458-8366
 phone_2Cell: (413) 822-4337
 phone_3
 wide_contact_image(false)
 contact_nameDaniel J. Trombley
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename145.jpg
 logo_filename145.jpg
 contact_image_filename145.jpg
 all_properties_link_image_filename145.jpg
 all_properties_linkhttp://www.altonwestall.com/real-estate/our-listings/
 video_embed_code
 contact_video_embed_code
 meta_titleBerkshire County Real Estate | Alton & Westall Real Estate Agency | Leverage Global Partners
 meta_descriptionAlton & Westall Real Estate Agency is the exclusive representative for Leverage Global Partners in Berkshire County, Massachusetts, USA.
 meta_keywordsAlton & Westall Real Estate Agency, Berkshire County, Dan Trombley, Berkshire County Real Estate, Williamstown Real Estate, North Adams Real Estate, Adams Real Estate, Richmond Real Estate, Otis Real Estate, Becket Real Estate, Alford Real Estate, Lanesborough Real Estate, Lee Real Estate, Dalton Real Estate, Pittsfield Real Estate, Lenox Real Estate, West Stockbridge Real Estate, Great Barrington Real Estate, Massachusetts Real Estate, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-07-22 17:09:11
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/145/alton-westall-real-estate-agency
 website_shortaltonwestall.com
 name_with_locationAlton & Westall Real Estate Agency
 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)
 id20110
 modelProperty
 model_id3620
 tagImage
 name35178.jpg
 typeimage/jpg
 size534164
 uri/assets/20110.jpg
 order0
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 1(array)
 id20117
 modelProperty
 model_id3620
 tagImage
 name35186.jpg
 typeimage/jpg
 size352444
 uri/assets/20117.jpg
 order1
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 2(array)
 id20116
 modelProperty
 model_id3620
 tagImage
 name35185.jpg
 typeimage/jpg
 size856499
 uri/assets/20116.jpg
 order2
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 3(array)
 id20115
 modelProperty
 model_id3620
 tagImage
 name35184.jpg
 typeimage/jpg
 size756826
 uri/assets/20115.jpg
 order3
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 4(array)
 id20111
 modelProperty
 model_id3620
 tagImage
 name35182.jpg
 typeimage/jpg
 size555707
 uri/assets/20111.jpg
 order4
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 5(array)
 id20114
 modelProperty
 model_id3620
 tagImage
 name35183.jpg
 typeimage/jpg
 size217628
 uri/assets/20114.jpg
 order5
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 6(array)
 id20119
 modelProperty
 model_id3620
 tagImage
 name35188.jpg
 typeimage/jpg
 size244847
 uri/assets/20119.jpg
 order6
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 7(array)
 id20118
 modelProperty
 model_id3620
 tagImage
 name35187.jpg
 typeimage/jpg
 size329250
 uri/assets/20118.jpg
 order7
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 8(array)
 id20113
 modelProperty
 model_id3620
 tagImage
 name35181.jpg
 typeimage/jpg
 size255481
 uri/assets/20113.jpg
 order8
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 9(array)
 id20112
 modelProperty
 model_id3620
 tagImage
 name35180.jpg
 typeimage/jpg
 size855111
 uri/assets/20112.jpg
 order9
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 User(array)
 0(array)
 id1253
 typeAgent
 brokerage_id145
 email[email protected]
 passworda90916b0ba07aa5626ce9de61b9b04d36781bccb
 recover_hash
 first_nameCindy
 last_namePoulin
 title
 dre_num
 phone413-458-8366
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:24:00
 created2017-08-07 15:24:00
 notified(false)
 full_nameCindy Poulin
 uri/agent-detail/1253/cindy-poulin
 profile_complete(true)
 UsersProperty(array)
 id1082
 user_id1253
 property_id3620
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
- sidebar_locations(array)
 0(array)
 Location(array)
 id140
 parent_id7
 brokerage_id145
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameBerkshire County, MA, USA
 short_nameBerkshire County, MA, USA
 group_index
 latitude42.311783
 longitude-73.182159
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionWilliamstown is a vibrant, four-seasons cultural and outdoors destination.
 long_descriptionLocated in beautiful Berkshire County, Williamstown has long been recognized as a principal cultural center in Western Massachusetts. Home to Williams College, the Clark Art Institute, and the Williamstown Theatre Festival, the town is vibrant with arts and theater year-round. The culture here is relaxed and friendly, and the communities are united by a common appreciation for the beautiful surroundings. For outdoor enthusiasts there are excellent hiking trails, exquisite golf courses and superb skiing. At Alton & Westall Real Estate Agency, we are passionate about helping people discover this spectacular region.
 created2016-04-07 15:50:35
 modified2016-04-07 15:50:35
 timezoneAmerica/New_York
 population130000
 uri/locations/view/140/berkshire-county-ma-usa
 tile_nameBerkshire County, MA, USA
 Brokerage(array)
 id145
 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_properties8
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID12758413
 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
 nameAlton & Westall Real Estate Agency
 broker_of_record_name
 short_nameAlton & Westall Real Estate Agency
 usernameAltonWestallRealEstate
 passwordd866aafebe077fad3e92c6ce0d311a3d9d8955d2
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionAlton & Westall Real Estate Agency is the exclusive representative for Leverage Global Partners in Berkshire County, Williamstown, North Adams, Adams, Richmond, Otis, Becket, Alford, Lanesborough, Lee, Dalton, Pittsfield, Lenox, West Stockbridge, Great Barrington, Massachusetts, USA. With more than 40 years of experience, the agency was founded in 1971 by Philip M. Alton and later joined by Donald J. Westall in 1984. The Alton & Westall Agency has made its home in Northern Berkshire County in the historic town of Williamstown, Massachusetts. Alton & Westall Agency is a full service firm that specializes in the listing and selling of fine real estate, including homes, acreage, and commercial property in and around Williamstown, Massachusetts, Berkshire County and Southwest Vermont. The Agency is licensed in Massachusetts and Vermont and all of its associates are members of the Berkshire County Board of REALTORS®. Alton & Westall and its team are active in the community and are committed to preserving the quality of life here in Williamstown and in the greater Berkshire County area.
 communitiesBerkshire County Williamstown North Adams Adams Richmond Otis Becket Alford Lanesborough Lee Dalton Pittsfield Lenox West Stockbridge Great Barrington
 websitehttp://altonwestall.com/
 address77 Water Street
 address_2
 cityWilliamstown
 stateMA
 full_stateMassachusetts
 countryUSA
 marketBerkshire County
 market_2
 postal_code01267
 phoneOffice: (413) 458-8366
 phone_2Cell: (413) 822-4337
 phone_3
 wide_contact_image(false)
 contact_nameDaniel J. Trombley
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename145.jpg
 logo_filename145.jpg
 contact_image_filename145.jpg
 all_properties_link_image_filename145.jpg
 all_properties_linkhttp://www.altonwestall.com/real-estate/our-listings/
 video_embed_code
 contact_video_embed_code
 meta_titleBerkshire County Real Estate | Alton & Westall Real Estate Agency | Leverage Global Partners
 meta_descriptionAlton & Westall Real Estate Agency is the exclusive representative for Leverage Global Partners in Berkshire County, Massachusetts, USA.
 meta_keywordsAlton & Westall Real Estate Agency, Berkshire County, Dan Trombley, Berkshire County Real Estate, Williamstown Real Estate, North Adams Real Estate, Adams Real Estate, Richmond Real Estate, Otis Real Estate, Becket Real Estate, Alford Real Estate, Lanesborough Real Estate, Lee Real Estate, Dalton Real Estate, Pittsfield Real Estate, Lenox Real Estate, West Stockbridge Real Estate, Great Barrington Real Estate, Massachusetts Real Estate, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-07-22 17:09:11
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/145/alton-westall-real-estate-agency
 website_shortaltonwestall.com
 name_with_locationAlton & Westall Real Estate Agency
 Image(array)
 id5326
 modelLocation
 model_id140
 tagImage
 nameAlton.jpg
 typeimage/jpeg
 size134150
 uri/assets/5326.jpg
 order0
 created2016-04-07 15:46:09
 modified2016-04-07 15:50:35
- highlighted_properties(array)
 0(array)
 Property(array)
 id3276
 brokerage_id145
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id931
 agent_2_id0
 agent_3_id0
 nameThe Nehemiah Smedley House
 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(true)
 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)
 descriptionBuilt in 1772, ''The Nehemiah Smedley house,'' is one of Williamstown's historic treasures. A complete restoration from foundation to rooftop has preserved its Colonial character and created a magical blend of old and new. This center chimney Colonial features an updated kitchen and an open living room and dining area, each with its original wood burning fireplace. The 2nd floor offers a full bath, three bedrooms and common area. The third floor is a complete master suite with two closets, cathedral ceilings, private study with wood burning fireplace and renovated master bath. "The tavern" at basement level brings history alive complete with the original massive oak beams, stone fireplace and bread oven, now re-imagined as the ultimate entertainment space. Set on 1.3 acres, with new barn and detached garage, close to the center of town.
 address530 Main Street
 address_2
 cityWilliamstown
 stateMA
 postal_code01267
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price685000
 price_20
 price_usd685000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1garage
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://www.altonwestall.com/listing/213665/401-petersburg-williamstown-ma-01267/
 meta_titleThe Nehemiah Smedley House | Williamstown Real Estate | Alton & Westall Real Estate Agency
 meta_description530 Main Street is a property offered for sale in Williamstown, MA, USA, presented by Alton & Westall Real Estate Agency
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1772
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num213752
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style10
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude42.713516
 longitude-73.209282
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2016-01-13 09:35:41
 uri/property-detail/3276/530-main-street-williamstown-ma-01267-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3276/530-main-street-williamstown-ma-01267-usa
 address_concat530 Main Street Williamstown MA 01267 USA
 google_maps_query_string530+Main+Street++Williamstown+MA+01267+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 685,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty2
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2016-01-13
 overridden_brokerage_nameAlton & Westall Real Estate Agency
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id145
 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_properties8
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID12758413
 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
 nameAlton & Westall Real Estate Agency
 broker_of_record_name
 short_nameAlton & Westall Real Estate Agency
 usernameAltonWestallRealEstate
 passwordd866aafebe077fad3e92c6ce0d311a3d9d8955d2
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionAlton & Westall Real Estate Agency is the exclusive representative for Leverage Global Partners in Berkshire County, Williamstown, North Adams, Adams, Richmond, Otis, Becket, Alford, Lanesborough, Lee, Dalton, Pittsfield, Lenox, West Stockbridge, Great Barrington, Massachusetts, USA. With more than 40 years of experience, the agency was founded in 1971 by Philip M. Alton and later joined by Donald J. Westall in 1984. The Alton & Westall Agency has made its home in Northern Berkshire County in the historic town of Williamstown, Massachusetts. Alton & Westall Agency is a full service firm that specializes in the listing and selling of fine real estate, including homes, acreage, and commercial property in and around Williamstown, Massachusetts, Berkshire County and Southwest Vermont. The Agency is licensed in Massachusetts and Vermont and all of its associates are members of the Berkshire County Board of REALTORS®. Alton & Westall and its team are active in the community and are committed to preserving the quality of life here in Williamstown and in the greater Berkshire County area.
 communitiesBerkshire County Williamstown North Adams Adams Richmond Otis Becket Alford Lanesborough Lee Dalton Pittsfield Lenox West Stockbridge Great Barrington
 websitehttp://altonwestall.com/
 address77 Water Street
 address_2
 cityWilliamstown
 stateMA
 full_stateMassachusetts
 countryUSA
 marketBerkshire County
 market_2
 postal_code01267
 phoneOffice: (413) 458-8366
 phone_2Cell: (413) 822-4337
 phone_3
 wide_contact_image(false)
 contact_nameDaniel J. Trombley
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename145.jpg
 logo_filename145.jpg
 contact_image_filename145.jpg
 all_properties_link_image_filename145.jpg
 all_properties_linkhttp://www.altonwestall.com/real-estate/our-listings/
 video_embed_code
 contact_video_embed_code
 meta_titleBerkshire County Real Estate | Alton & Westall Real Estate Agency | Leverage Global Partners
 meta_descriptionAlton & Westall Real Estate Agency is the exclusive representative for Leverage Global Partners in Berkshire County, Massachusetts, USA.
 meta_keywordsAlton & Westall Real Estate Agency, Berkshire County, Dan Trombley, Berkshire County Real Estate, Williamstown Real Estate, North Adams Real Estate, Adams Real Estate, Richmond Real Estate, Otis Real Estate, Becket Real Estate, Alford Real Estate, Lanesborough Real Estate, Lee Real Estate, Dalton Real Estate, Pittsfield Real Estate, Lenox Real Estate, West Stockbridge Real Estate, Great Barrington Real Estate, Massachusetts Real Estate, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-07-22 17:09:11
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/145/alton-westall-real-estate-agency
 website_shortaltonwestall.com
 name_with_locationAlton & Westall Real Estate Agency
 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)
 id14038
 modelProperty
 model_id3276
 tagImage
 name31646.jpg
 typeimage/jpg
 size1980031
 uri/assets/14038.jpg
 order0
 created2016-04-07 16:43:04
 modified2016-04-07 16:43:04
 1(array)
 id14039
 modelProperty
 model_id3276
 tagImage
 name31647.jpg
 typeimage/jpg
 size1262891
 uri/assets/14039.jpg
 order1
 created2016-04-07 16:43:04
 modified2016-04-07 16:43:04
 2(array)
 id14047
 modelProperty
 model_id3276
 tagImage
 name31656.jpg
 typeimage/jpg
 size338056
 uri/assets/14047.jpg
 order2
 created2016-04-07 16:43:04
 modified2016-04-07 16:43:04
 3(array)
 id14042
 modelProperty
 model_id3276
 tagImage
 name31650.jpg
 typeimage/jpg
 size368155
 uri/assets/14042.jpg
 order3
 created2016-04-07 16:43:04
 modified2016-04-07 16:43:04
 4(array)
 id14043
 modelProperty
 model_id3276
 tagImage
 name31651.jpg
 typeimage/jpg
 size1037292
 uri/assets/14043.jpg
 order4
 created2016-04-07 16:43:04
 modified2016-04-07 16:43:04
 5(array)
 id14041
 modelProperty
 model_id3276
 tagImage
 name31649.jpg
 typeimage/jpg
 size379862
 uri/assets/14041.jpg
 order5
 created2016-04-07 16:43:04
 modified2016-04-07 16:43:04
 6(array)
 id14040
 modelProperty
 model_id3276
 tagImage
 name31648.jpg
 typeimage/jpg
 size991432
 uri/assets/14040.jpg
 order6
 created2016-04-07 16:43:04
 modified2016-04-07 16:43:04
 7(array)
 id14044
 modelProperty
 model_id3276
 tagImage
 name31657.jpg
 typeimage/jpg
 size373235
 uri/assets/14044.jpg
 order7
 created2016-04-07 16:43:04
 modified2016-04-07 16:43:04
 8(array)
 id14045
 modelProperty
 model_id3276
 tagImage
 name31653.jpg
 typeimage/jpg
 size1393786
 uri/assets/14045.jpg
 order8
 created2016-04-07 16:43:04
 modified2016-04-07 16:43:04
 9(array)
 id14046
 modelProperty
 model_id3276
 tagImage
 name31654.jpg
 typeimage/jpg
 size524441
 uri/assets/14046.jpg
 order9
 created2016-04-07 16:43:04
 modified2016-04-07 16:43:04
 User(array)
 0(array)
 id1095
 typeAgent
 brokerage_id145
 email[email protected]
 passworda0677dc23c0fd265558fa6c85b4cc06466e740a4
 recover_hash
 first_nameAnn
 last_nameGreenwood
 title
 dre_num
 phone413-458-8366
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:53
 created2017-08-07 15:23:53
 notified(false)
 full_nameAnn Greenwood
 uri/agent-detail/1095/ann-greenwood
 profile_complete(true)
 UsersProperty(array)
 id857
 user_id1095
 property_id3276
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id2761
 property_id3276
 property_feature_id4
 Topic(empty)
 1(array)
 Property(array)
 id2897
 brokerage_id145
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id104
 agent_2_id0
 agent_3_id0
 nameAbsolute Privacy
 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(true)
 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)
 descriptionEncompassing over 10 acres of meadows and woodlands, including a small wildlife pond, this stunning estate, offering gorgeous mountain views, assures total privacy for its owner. Lovely brick patios, stone walls, and country-style landscaping provide a perfect setting for the expansive residence, designed by David Todd & Associates in the late 1960’s, and constructed with the finest materials available, including silver grey stained cedar inside and out, granite mantels, hearths and stairs, and smooth-finished deep red/brown brick in the entry foyer and Grand Hall. Large windows, clerestory windows and sliding doors allow abundant natural light to bath the interior by day, while by night upturned wall sconces create a most dramatic ambiance. With understated elegance, this property is timelessly appropriate here in the Berkshires.
 address839 Green River Road
 address_2
 cityWilliamstown
 stateMA
 postal_code01267
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price995000
 price_20
 price_usd995000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres10
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size10
 icon_1views
 icon_2acreage
 icon_3pool
 icon_4garage
 icon_5
 icon_6
 website
 meta_titleAbsolute Privacy | Williamstown Real Estate | Alton & Westall Real Estate Agency
 meta_description839 Green River Road is a property offered for sale in Williamstown, MA, USA, presented by Alton & Westall Real Estate Agency
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1970
 virtual_tourhttp://tours.vestaphotostudio.com/public/vtour/display/378450
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num211312
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style17
 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
 latitude42.692318
 longitude-73.201050
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, hectares, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-10-14 12:17:45
 uri/property-detail/2897/839-green-river-road-williamstown-ma-01267-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2897/839-green-river-road-williamstown-ma-01267-usa
 address_concat839 Green River Road Williamstown MA 01267 USA
 google_maps_query_string839+Green+River+Road++Williamstown+MA+01267+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 995,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty3
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2015-10-14
 overridden_brokerage_nameAlton & Westall Real Estate Agency
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id145
 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_properties8
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID12758413
 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
 nameAlton & Westall Real Estate Agency
 broker_of_record_name
 short_nameAlton & Westall Real Estate Agency
 usernameAltonWestallRealEstate
 passwordd866aafebe077fad3e92c6ce0d311a3d9d8955d2
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionAlton & Westall Real Estate Agency is the exclusive representative for Leverage Global Partners in Berkshire County, Williamstown, North Adams, Adams, Richmond, Otis, Becket, Alford, Lanesborough, Lee, Dalton, Pittsfield, Lenox, West Stockbridge, Great Barrington, Massachusetts, USA. With more than 40 years of experience, the agency was founded in 1971 by Philip M. Alton and later joined by Donald J. Westall in 1984. The Alton & Westall Agency has made its home in Northern Berkshire County in the historic town of Williamstown, Massachusetts. Alton & Westall Agency is a full service firm that specializes in the listing and selling of fine real estate, including homes, acreage, and commercial property in and around Williamstown, Massachusetts, Berkshire County and Southwest Vermont. The Agency is licensed in Massachusetts and Vermont and all of its associates are members of the Berkshire County Board of REALTORS®. Alton & Westall and its team are active in the community and are committed to preserving the quality of life here in Williamstown and in the greater Berkshire County area.
 communitiesBerkshire County Williamstown North Adams Adams Richmond Otis Becket Alford Lanesborough Lee Dalton Pittsfield Lenox West Stockbridge Great Barrington
 websitehttp://altonwestall.com/
 address77 Water Street
 address_2
 cityWilliamstown
 stateMA
 full_stateMassachusetts
 countryUSA
 marketBerkshire County
 market_2
 postal_code01267
 phoneOffice: (413) 458-8366
 phone_2Cell: (413) 822-4337
 phone_3
 wide_contact_image(false)
 contact_nameDaniel J. Trombley
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename145.jpg
 logo_filename145.jpg
 contact_image_filename145.jpg
 all_properties_link_image_filename145.jpg
 all_properties_linkhttp://www.altonwestall.com/real-estate/our-listings/
 video_embed_code
 contact_video_embed_code
 meta_titleBerkshire County Real Estate | Alton & Westall Real Estate Agency | Leverage Global Partners
 meta_descriptionAlton & Westall Real Estate Agency is the exclusive representative for Leverage Global Partners in Berkshire County, Massachusetts, USA.
 meta_keywordsAlton & Westall Real Estate Agency, Berkshire County, Dan Trombley, Berkshire County Real Estate, Williamstown Real Estate, North Adams Real Estate, Adams Real Estate, Richmond Real Estate, Otis Real Estate, Becket Real Estate, Alford Real Estate, Lanesborough Real Estate, Lee Real Estate, Dalton Real Estate, Pittsfield Real Estate, Lenox Real Estate, West Stockbridge Real Estate, Great Barrington Real Estate, Massachusetts Real Estate, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-07-22 17:09:11
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/145/alton-westall-real-estate-agency
 website_shortaltonwestall.com
 name_with_locationAlton & Westall Real Estate Agency
 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)
 id17260
 modelProperty
 model_id2897
 tagImage
 name27709.jpg
 typeimage/jpg
 size310121
 uri/assets/17260.jpg
 order0
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 1(array)
 id17261
 modelProperty
 model_id2897
 tagImage
 name27710.jpg
 typeimage/jpg
 size240581
 uri/assets/17261.jpg
 order1
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 2(array)
 id17262
 modelProperty
 model_id2897
 tagImage
 name27711.jpg
 typeimage/jpg
 size283192
 uri/assets/17262.jpg
 order2
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 3(array)
 id17265
 modelProperty
 model_id2897
 tagImage
 name27714.jpg
 typeimage/jpg
 size265870
 uri/assets/17265.jpg
 order3
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 4(array)
 id17264
 modelProperty
 model_id2897
 tagImage
 name27713.jpg
 typeimage/jpg
 size264173
 uri/assets/17264.jpg
 order4
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 5(array)
 id17266
 modelProperty
 model_id2897
 tagImage
 name27715.jpg
 typeimage/jpg
 size279939
 uri/assets/17266.jpg
 order5
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 6(array)
 id17263
 modelProperty
 model_id2897
 tagImage
 name27712.jpg
 typeimage/jpg
 size330325
 uri/assets/17263.jpg
 order6
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 7(array)
 id17267
 modelProperty
 model_id2897
 tagImage
 name27716.jpg
 typeimage/jpg
 size396342
 uri/assets/17267.jpg
 order7
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 8(array)
 id17268
 modelProperty
 model_id2897
 tagImage
 name27717.jpg
 typeimage/jpg
 size291044
 uri/assets/17268.jpg
 order8
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 9(array)
 id17269
 modelProperty
 model_id2897
 tagImage
 name27718.jpg
 typeimage/jpg
 size361935
 uri/assets/17269.jpg
 order9
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 User(array)
 0(array)
 id333
 typeAgent
 brokerage_id145
 email[email protected]
 password05f9fdb61eaf059941799df7972af8bad81cd833
 recover_hash
 first_nameMaureen
 last_nameDietze
 title
 dre_num
 phone413-458-8366
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:47
 created2017-08-07 15:22:47
 notified(false)
 full_nameMaureen Dietze
 uri/agent-detail/333/maureen-dietze
 profile_complete(true)
 UsersProperty(array)
 id121
 user_id333
 property_id2897
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id3617
 property_id2897
 property_feature_id14
 1(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id3618
 property_id2897
 property_feature_id12
 2(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id3619
 property_id2897
 property_feature_id4
 Topic(empty)
- custom_ga_event_properties(array)
 brokerageAlton & Westall Real Estate Agency, Williamstown
- property(array)
 Property(array)
 id3622
 brokerage_id145
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id931
 agent_2_id0
 agent_3_id0
 nameInfinite Possibilities
 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)
 descriptionBuild your dream home! Spectacular 129 acre parcel with 180 degree views bordering Hopkins Forest. Includes a 49acre +/- building site with stunning views and subdivision potential, plus 80 acres of recreational woodland above the build zone and $100,000 of timber value. Site also includes a small dwelling with two bedrooms and one bath on a separate 2.7 acre parcel. Private setting.
 address848 Montgomery Road
 address_2
 cityPownal
 stateVT
 postal_code05261
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price450000
 price_20
 price_usd450000
 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)
 bedrooms2
 bedrooms_20
 bathrooms1
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres129
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size129
 icon_1views
 icon_2acreage
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://www.altonwestall.com/listing/210929/848-montgomery-rd-pownal-vt-05261/
 meta_titleInfinite Possibilities | Pownal Real Estate | Alton & Westall Real Estate Agency
 meta_description848 Montgomery Road is a property offered for sale in Pownal, VT, USA, presented by Alton & Westall Real Estate Agency
 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_num210929
 wsj_property_typeland
 nyt_property_type8
 nyt_popular_features
 propgolux_property_type10
 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
 latitude42.753422
 longitude-73.251602
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, bathrooms_partial, square_feet, square_meters, hectares, virtual_tour, video_tour, year_built, 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:03
 created2016-03-18 13:44:10
 uri/property-detail/3622/848-montgomery-road-pownal-vt-05261-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3622/848-montgomery-road-pownal-vt-05261-usa
 address_concat848 Montgomery Road Pownal VT 05261 USA
 google_maps_query_string848+Montgomery+Road++Pownal+VT+05261+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 450,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty2
 bathrooms_pretty1
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms1
 date_listed2016-03-18
 overridden_brokerage_nameAlton & Westall Real Estate Agency
 overridden_brokerage_logo_uri/assets/2674.jpg
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id145
 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_properties8
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID12758413
 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
 nameAlton & Westall Real Estate Agency
 broker_of_record_name
 short_nameAlton & Westall Real Estate Agency
 usernameAltonWestallRealEstate
 passwordd866aafebe077fad3e92c6ce0d311a3d9d8955d2
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionAlton & Westall Real Estate Agency is the exclusive representative for Leverage Global Partners in Berkshire County, Williamstown, North Adams, Adams, Richmond, Otis, Becket, Alford, Lanesborough, Lee, Dalton, Pittsfield, Lenox, West Stockbridge, Great Barrington, Massachusetts, USA. With more than 40 years of experience, the agency was founded in 1971 by Philip M. Alton and later joined by Donald J. Westall in 1984. The Alton & Westall Agency has made its home in Northern Berkshire County in the historic town of Williamstown, Massachusetts. Alton & Westall Agency is a full service firm that specializes in the listing and selling of fine real estate, including homes, acreage, and commercial property in and around Williamstown, Massachusetts, Berkshire County and Southwest Vermont. The Agency is licensed in Massachusetts and Vermont and all of its associates are members of the Berkshire County Board of REALTORS®. Alton & Westall and its team are active in the community and are committed to preserving the quality of life here in Williamstown and in the greater Berkshire County area.
 communitiesBerkshire County Williamstown North Adams Adams Richmond Otis Becket Alford Lanesborough Lee Dalton Pittsfield Lenox West Stockbridge Great Barrington
 websitehttp://altonwestall.com/
 address77 Water Street
 address_2
 cityWilliamstown
 stateMA
 full_stateMassachusetts
 countryUSA
 marketBerkshire County
 market_2
 postal_code01267
 phoneOffice: (413) 458-8366
 phone_2Cell: (413) 822-4337
 phone_3
 wide_contact_image(false)
 contact_nameDaniel J. Trombley
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename145.jpg
 logo_filename145.jpg
 contact_image_filename145.jpg
 all_properties_link_image_filename145.jpg
 all_properties_linkhttp://www.altonwestall.com/real-estate/our-listings/
 video_embed_code
 contact_video_embed_code
 meta_titleBerkshire County Real Estate | Alton & Westall Real Estate Agency | Leverage Global Partners
 meta_descriptionAlton & Westall Real Estate Agency is the exclusive representative for Leverage Global Partners in Berkshire County, Massachusetts, USA.
 meta_keywordsAlton & Westall Real Estate Agency, Berkshire County, Dan Trombley, Berkshire County Real Estate, Williamstown Real Estate, North Adams Real Estate, Adams Real Estate, Richmond Real Estate, Otis Real Estate, Becket Real Estate, Alford Real Estate, Lanesborough Real Estate, Lee Real Estate, Dalton Real Estate, Pittsfield Real Estate, Lenox Real Estate, West Stockbridge Real Estate, Great Barrington Real Estate, Massachusetts Real Estate, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-07-22 17:09:11
 modified2016-04-08 16:34:15
 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)
 id2674
 modelBrokerage
 model_id145
 tagLogo
 name145.jpg
 typeimage/jpg
 size81739
 uri/assets/2674.jpg
 order0
 created2016-03-30 11:42:21
 modified2016-03-30 11:42:21
 MainImage(array)
 id2673
 modelBrokerage
 model_id145
 tagMainImage
 name145.jpg
 typeimage/jpg
 size1017237
 uri/assets/2673.jpg
 order0
 created2016-03-30 11:42:20
 modified2016-03-30 11:42:20
 ContactImage(array)
 id2675
 modelBrokerage
 model_id145
 tagContactImage
 name145.jpg
 typeimage/jpg
 size109700
 uri/assets/2675.jpg
 order0
 created2016-03-30 11:42:21
 modified2016-03-30 11:42:21
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 FeaturedImage(empty)
 Location(array)
 0(array)
 id140
 parent_id7
 brokerage_id145
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameBerkshire County, MA, USA
 short_nameBerkshire County, MA, USA
 group_index
 latitude42.311783
 longitude-73.182159
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionWilliamstown is a vibrant, four-seasons cultural and outdoors destination.
 long_descriptionLocated in beautiful Berkshire County, Williamstown has long been recognized as a principal cultural center in Western Massachusetts. Home to Williams College, the Clark Art Institute, and the Williamstown Theatre Festival, the town is vibrant with arts and theater year-round. The culture here is relaxed and friendly, and the communities are united by a common appreciation for the beautiful surroundings. For outdoor enthusiasts there are excellent hiking trails, exquisite golf courses and superb skiing. At Alton & Westall Real Estate Agency, we are passionate about helping people discover this spectacular region.
 created2016-04-07 15:50:35
 modified2016-04-07 15:50:35
 timezoneAmerica/New_York
 population130000
 uri/locations/view/140/berkshire-county-ma-usa
 tile_nameBerkshire County, MA, USA
 User(array)
 0(array)
 id146
 typeBrokerageAdmin
 brokerage_id145
 email[email protected]
 passwordd866aafebe077fad3e92c6ce0d311a3d9d8955d2
 recover_hash
 first_name
 last_name
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2016-04-12 08:28:48
 created2016-04-08 16:34:15
 notified(true)
 full_name
 uri/agent-detail/146/
 profile_complete(false)
 1(array)
 id333
 typeAgent
 brokerage_id145
 email[email protected]
 password05f9fdb61eaf059941799df7972af8bad81cd833
 recover_hash
 first_nameMaureen
 last_nameDietze
 title
 dre_num
 phone413-458-8366
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:47
 created2017-08-07 15:22:47
 notified(false)
 full_nameMaureen Dietze
 uri/agent-detail/333/maureen-dietze
 profile_complete(true)
 2(array)
 id334
 typeAgent
 brokerage_id145
 email[email protected]
 password0ca053a338c6e7a53daef3b22deab69b11b2121c
 recover_hash
 first_nameTerry
 last_nameLamb
 title
 dre_num
 phone413-458-8366
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:47
 created2017-08-07 15:22:47
 notified(false)
 full_nameTerry Lamb
 uri/agent-detail/334/terry-lamb
 profile_complete(true)
 3(array)
 id335
 typeAgent
 brokerage_id145
 email[email protected]
 passwordf4c7dc60ec240171ade7c8cf4e9be2dcff88b573
 recover_hash
 first_nameCheryl
 last_nameWestall
 title
 dre_num
 phone413-458-8366
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:47
 created2017-08-07 15:22:47
 notified(false)
 full_nameCheryl Westall
 uri/agent-detail/335/cheryl-westall
 profile_complete(true)
 4(array)
 id336
 typeAgent
 brokerage_id145
 email[email protected]
 password933591b9b134034ff7df76153d28692912b9829e
 recover_hash
 first_nameShari
 last_nameCollins
 title
 dre_num
 phone413-458-8366
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:47
 created2017-08-07 15:22:47
 notified(false)
 full_nameShari Collins
 uri/agent-detail/336/shari-collins
 profile_complete(true)
 5(array)
 id337
 typeAgent
 brokerage_id145
 email[email protected]
 password69c54227d3cfde1560f09d4189a2faf99a6498e6
 recover_hash
 first_nameAlan
 last_nameMarden
 title
 dre_num
 phone413-458-8366
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:47
 created2017-08-07 15:22:47
 notified(false)
 full_nameAlan Marden
 uri/agent-detail/337/alan-marden
 profile_complete(true)
 6(array)
 id774
 typeAgent
 brokerage_id145
 email[email protected]
 passworde889a5ab8dc0f3cd21ad043866cb77ece6a901fc
 recover_hash
 first_nameTerry
 last_nameLamb
 title
 dre_num
 phone413-458-8366
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:21
 created2017-08-07 15:23:21
 notified(false)
 full_nameTerry Lamb
 uri/agent-detail/774/terry-lamb
 profile_complete(true)
 7(array)
 id848
 typeAgent
 brokerage_id145
 email[email protected]
 password501a341ca9cff98a3122d2ca42608c89c9b04223
 recover_hash
 first_nameAlix
 last_nameCabral
 title
 dre_num
 phone413-458-8366
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:41
 created2017-08-07 15:23:41
 notified(false)
 full_nameAlix Cabral
 uri/agent-detail/848/alix-cabral
 profile_complete(true)
 8(array)
 id1095
 typeAgent
 brokerage_id145
 email[email protected]
 passworda0677dc23c0fd265558fa6c85b4cc06466e740a4
 recover_hash
 first_nameAnn
 last_nameGreenwood
 title
 dre_num
 phone413-458-8366
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:53
 created2017-08-07 15:23:53
 notified(false)
 full_nameAnn Greenwood
 uri/agent-detail/1095/ann-greenwood
 profile_complete(true)
 9(array)
 id1253
 typeAgent
 brokerage_id145
 email[email protected]
 passworda90916b0ba07aa5626ce9de61b9b04d36781bccb
 recover_hash
 first_nameCindy
 last_namePoulin
 title
 dre_num
 phone413-458-8366
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:24:00
 created2017-08-07 15:24:00
 notified(false)
 full_nameCindy Poulin
 uri/agent-detail/1253/cindy-poulin
 profile_complete(true)
 uri/brokerage-detail/145/alton-westall-real-estate-agency
 website_shortaltonwestall.com
 name_with_locationAlton & Westall Real Estate Agency - Berkshire County, 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)
 id20134
 modelProperty
 model_id3622
 tagImage
 name35193.jpg
 typeimage/jpg
 size729118
 uri/assets/20134.jpg
 order0
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 1(array)
 id20135
 modelProperty
 model_id3622
 tagImage
 name35194.jpg
 typeimage/jpg
 size975946
 uri/assets/20135.jpg
 order1
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 2(array)
 id20136
 modelProperty
 model_id3622
 tagImage
 name35195.jpg
 typeimage/jpg
 size516701
 uri/assets/20136.jpg
 order2
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 3(array)
 id20137
 modelProperty
 model_id3622
 tagImage
 name35196.jpg
 typeimage/jpg
 size1046913
 uri/assets/20137.jpg
 order3
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 4(array)
 id20131
 modelProperty
 model_id3622
 tagImage
 name35190.jpg
 typeimage/jpg
 size794654
 uri/assets/20131.jpg
 order4
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 5(array)
 id20132
 modelProperty
 model_id3622
 tagImage
 name35191.jpg
 typeimage/jpg
 size711830
 uri/assets/20132.jpg
 order5
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 6(array)
 id20133
 modelProperty
 model_id3622
 tagImage
 name35192.jpg
 typeimage/jpg
 size634920
 uri/assets/20133.jpg
 order6
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 7(array)
 id20130
 modelProperty
 model_id3622
 tagImage
 name35189.jpg
 typeimage/jpg
 size681792
 uri/assets/20130.jpg
 order7
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 User(array)
 0(array)
 id1095
 typeAgent
 brokerage_id145
 email[email protected]
 passworda0677dc23c0fd265558fa6c85b4cc06466e740a4
 recover_hash
 first_nameAnn
 last_nameGreenwood
 title
 dre_num
 phone413-458-8366
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:53
 created2017-08-07 15:23:53
 notified(false)
 full_nameAnn Greenwood
 uri/agent-detail/1095/ann-greenwood
 profile_complete(true)
 UsersProperty(array)
 id858
 user_id1095
 property_id3622
 sort_order0
 Brokerage(array)
 id145
 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_properties8
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID12758413
 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
 nameAlton & Westall Real Estate Agency
 broker_of_record_name
 short_nameAlton & Westall Real Estate Agency
 usernameAltonWestallRealEstate
 passwordd866aafebe077fad3e92c6ce0d311a3d9d8955d2
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionAlton & Westall Real Estate Agency is the exclusive representative for Leverage Global Partners in Berkshire County, Williamstown, North Adams, Adams, Richmond, Otis, Becket, Alford, Lanesborough, Lee, Dalton, Pittsfield, Lenox, West Stockbridge, Great Barrington, Massachusetts, USA. With more than 40 years of experience, the agency was founded in 1971 by Philip M. Alton and later joined by Donald J. Westall in 1984. The Alton & Westall Agency has made its home in Northern Berkshire County in the historic town of Williamstown, Massachusetts. Alton & Westall Agency is a full service firm that specializes in the listing and selling of fine real estate, including homes, acreage, and commercial property in and around Williamstown, Massachusetts, Berkshire County and Southwest Vermont. The Agency is licensed in Massachusetts and Vermont and all of its associates are members of the Berkshire County Board of REALTORS®. Alton & Westall and its team are active in the community and are committed to preserving the quality of life here in Williamstown and in the greater Berkshire County area.
 communitiesBerkshire County Williamstown North Adams Adams Richmond Otis Becket Alford Lanesborough Lee Dalton Pittsfield Lenox West Stockbridge Great Barrington
 websitehttp://altonwestall.com/
 address77 Water Street
 address_2
 cityWilliamstown
 stateMA
 full_stateMassachusetts
 countryUSA
 marketBerkshire County
 market_2
 postal_code01267
 phoneOffice: (413) 458-8366
 phone_2Cell: (413) 822-4337
 phone_3
 wide_contact_image(false)
 contact_nameDaniel J. Trombley
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename145.jpg
 logo_filename145.jpg
 contact_image_filename145.jpg
 all_properties_link_image_filename145.jpg
 all_properties_linkhttp://www.altonwestall.com/real-estate/our-listings/
 video_embed_code
 contact_video_embed_code
 meta_titleBerkshire County Real Estate | Alton & Westall Real Estate Agency | Leverage Global Partners
 meta_descriptionAlton & Westall Real Estate Agency is the exclusive representative for Leverage Global Partners in Berkshire County, Massachusetts, USA.
 meta_keywordsAlton & Westall Real Estate Agency, Berkshire County, Dan Trombley, Berkshire County Real Estate, Williamstown Real Estate, North Adams Real Estate, Adams Real Estate, Richmond Real Estate, Otis Real Estate, Becket Real Estate, Alford Real Estate, Lanesborough Real Estate, Lee Real Estate, Dalton Real Estate, Pittsfield Real Estate, Lenox Real Estate, West Stockbridge Real Estate, Great Barrington Real Estate, Massachusetts Real Estate, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-07-22 17:09:11
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/145/alton-westall-real-estate-agency
 website_shortaltonwestall.com
 name_with_locationAlton & Westall Real Estate Agency
 Image(empty)
 BrokerageLogoOverride(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id4264
 property_id3622
 property_feature_id14
 Icon(array)
 id3563
 modelPropertyFeature
 model_id14
 tagIcon
 name142.png
 typeimage/png
 size2192
 uri/assets/3563.png
 order0
 created2016-04-07 14:04:53
 modified2016-04-07 14:04:55
 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/3622/848-montgomery-road-pownal-vt-05261-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/property-detail/3622/848-montgomery-road-pownal-vt-05261-usa
Remote Port	18857
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	a09dbc1a6cdcb5b3-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	aioz6m7yC1TpDG5SpsnvxwAAAoc
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	aioz6m7yC1TpDG5SpsnvxwAAAoc
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781150698.6499
Request Time	1781150698

====

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

Infinite Possibilities

Represented By: Alton & Westall Real Estate Agency

altonwestall.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