Properties /

Stunning Contemporary

90 Ide Road | Williamstown, MA 01267, USA | $979,000 | MLS ID: 211001

4 Beds
4 Baths
1 Half Ba
Views

This energy efficient home was built in 1986 by John Hamman and doubled in size in 2000 by Bob Smith. The original home offers an entry hall with vaulted ceiling and skylight, living room with large casement windows, dining room with southwestern exposure, gourmet kitchen with granite countertops and cherry cabinets, and study with a TESS fireplace. The main level addition features a stunning great room with floor-to-ceiling Fieldstone fireplace and beautiful woodwork. An open staircase leads to the loft overlooking the great room and master suite with luxury bath. There are three additional bedrooms downstairs, plus a finished lower level with a bar/pool room. Located on desirable Ide Road, the residence also boasts perennial beds, stone walls and patios by Bart van Luling, and gorgeous mountain views.

Represented By: Alton & Westall Real Estate Agency

altonwestall.com | License #: 012345

Shari Collins
413-458-8366
Email

Main Office: 77 Water Street
Williamstown, MA 01267
USA

More About Shari

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

Highlighted Properties

Beautiful Townhouse Condominium

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

The Nehemiah Smedley House

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

Represented By

Agent Contacts: Shari Collins 413-458-8366 | Email; 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

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)
  0956
  190-ide-road-williamstown-ma-01267-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: 37 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` = 956 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` = (956) ORDER BY `Image`.`order` ASC	9	9	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` = 956 AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	2	2	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 `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` = 336 AND `Image`.`model` = 'User' AND `Image`.`tag` = 'Image'	0	0	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` = 336 AND `BrokerageLogoOverride`.`model` = 'User' AND `BrokerageLogoOverride`.`tag` = 'BrokerageLogoOverride'	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` = 956 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` = 956 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` = 956 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` != 956 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 (3620, 3276) 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 (3620, 3276) 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 (3620, 3276) 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 (3620, 3276) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	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` IN (3620, 3276) 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 (956, 2264, 1302, 3622) ORDER BY `Image`.`order` ASC	37	37	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 (956, 2264, 1302, 3622) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	6	6	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 (956, 2264, 1302, 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` IN (956, 2264, 1302, 3622) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	6	6	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 (956, 2264, 1302, 3622) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	0

1 duplicate queries run.

Query Explain:

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

====

Timer

Memory

Peak Memory Use 13.83 MB

Message	Memory use
Component initialization	3.07 MB
Controller action start	4.01 MB
Controller render start	6.79 MB
View render complete	7.31 MB

Timers

Total Request Time: 253 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	38.10
Event: Controller.initialize	5.22
Event: Controller.startup	2.74
Controller action	69.03
Event: Controller.beforeRender	12.83
» Processing toolbar data	12.74
Rendering View	92.46
» Event: View.beforeRender	0.40
» Rendering APP/View/Properties/view.ctp	3.47
» » Rendering APP/View/Elements/static_property_price.ctp	0.44
» » Rendering APP/View/Elements/property_features.ctp	0.23
» » Rendering APP/View/Elements/static_property_price.ctp #2	0.17
» » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.15
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.06
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.17
» » » Rendering APP/View/Elements/static_property_price.ctp #5	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #6	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #7	0.14
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.22
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	87.77
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)
 id956
 brokerage_id145
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id931
 agent_2_id108
 agent_3_id0
 nameStunning Contemporary
 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)
 descriptionThis energy efficient home was built in 1986 by John Hamman and doubled in size in 2000 by Bob Smith. The original home offers an entry hall with vaulted ceiling and skylight, living room with large casement windows, dining room with southwestern exposure, gourmet kitchen with granite countertops and cherry cabinets, and study with a TESS fireplace. The main level addition features a stunning great room with floor-to-ceiling Fieldstone fireplace and beautiful woodwork. An open staircase leads to the loft overlooking the great room and master suite with luxury bath. There are three additional bedrooms downstairs, plus a finished lower level with a bar/pool room. Located on desirable Ide Road, the residence also boasts perennial beds, stone walls and patios by Bart van Luling, and gorgeous mountain views.
 address90 Ide Road
 address_2
 cityWilliamstown
 stateMA
 postal_code01267
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price979000
 price_20
 price_usd979000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1views
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_titleStunning Contemporary | Williamstown Real Estate | Alton & Westall Real Estate Agency
 meta_description90 Ide Road is a property offered for sale in Williamstown, MA, USA, presented by Alton & Westall Real Estate Agency
 meta_keywords90 Ide Road, Spectacular Contemporary, Leverage Global Partners, Berkshire County Real Estate, Massachusetts Real Estate, Alton & Westall Real Estate Agency
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1986 and 2001
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num211001
 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.697624
 longitude-73.203178
 invalid_required_fields
 invalid_optional_fieldssquare_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
 created2014-07-31 11:47:43
 uri/property-detail/956/90-ide-road-williamstown-ma-01267-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/956/90-ide-road-williamstown-ma-01267-usa
 address_concat90 Ide Road Williamstown MA 01267 USA
 google_maps_query_string90+Ide+Road++Williamstown+MA+01267+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 979,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty4
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2014-07-31
 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)
 id10765
 modelProperty
 model_id956
 tagImage
 name8121.jpg
 typeimage/jpg
 size601502
 uri/assets/10765.jpg
 order0
 created2016-04-07 16:23:04
 modified2016-04-07 16:23:04
 1(array)
 id10758
 modelProperty
 model_id956
 tagImage
 name8113.jpg
 typeimage/jpg
 size294037
 uri/assets/10758.jpg
 order1
 created2016-04-07 16:23:04
 modified2016-04-07 16:23:04
 2(array)
 id10757
 modelProperty
 model_id956
 tagImage
 name8112.jpg
 typeimage/jpg
 size640487
 uri/assets/10757.jpg
 order2
 created2016-04-07 16:23:04
 modified2016-04-07 16:23:04
 3(array)
 id10759
 modelProperty
 model_id956
 tagImage
 name8115.jpg
 typeimage/jpg
 size309986
 uri/assets/10759.jpg
 order4
 created2016-04-07 16:23:04
 modified2016-04-07 16:23:04
 4(array)
 id10760
 modelProperty
 model_id956
 tagImage
 name8116.jpg
 typeimage/jpg
 size344173
 uri/assets/10760.jpg
 order5
 created2016-04-07 16:23:04
 modified2016-04-07 16:23:04
 5(array)
 id10761
 modelProperty
 model_id956
 tagImage
 name8117.jpg
 typeimage/jpg
 size252330
 uri/assets/10761.jpg
 order6
 created2016-04-07 16:23:04
 modified2016-04-07 16:23:04
 6(array)
 id10762
 modelProperty
 model_id956
 tagImage
 name8118.jpg
 typeimage/jpg
 size351540
 uri/assets/10762.jpg
 order7
 created2016-04-07 16:23:04
 modified2016-04-07 16:23:04
 7(array)
 id10763
 modelProperty
 model_id956
 tagImage
 name8119.jpg
 typeimage/jpg
 size215064
 uri/assets/10763.jpg
 order8
 created2016-04-07 16:23:04
 modified2016-04-07 16:23:04
 8(array)
 id10764
 modelProperty
 model_id956
 tagImage
 name8120.jpg
 typeimage/jpg
 size351226
 uri/assets/10764.jpg
 order9
 created2016-04-07 16:23:04
 modified2016-04-07 16:23:04
 User(array)
 0(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)
 UsersProperty(array)
 id125
 user_id336
 property_id956
 sort_order0
 1(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)
 id856
 user_id1095
 property_id956
 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)
 id1891
 property_id956
 property_feature_id14
 Topic(empty)
 1(array)
 Property(array)
 id2264
 brokerage_id145
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id651
 agent_2_id0
 agent_3_id0
 nameUnparalleled Views
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(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)
 descriptionSet on 56+ acres in absolute privacy, this magnificent Georgian/Federal home has all the elegance and charm of yesteryear, but was thoughtfully built for a modern lifestyle. With unparalleled views of Mount Greylock, this classic center hall home features a chef’s kitchen with a 12 foot center island, La Cornue range and open floor plan to family room, an elegant foyer with a three story central staircase, living room with artist’s mural, dining room with Royal Delft tile fireplace surround, gorgeous Master Suite, four additional bedrooms, four and one-half baths, four wood burning fireplaces on the 1st floor, three gas fireplaces on the 2nd floor and a generous mudroom with built-in storage cubbies and Sheldon slate floor. Based on the Wentworth Gardner House in Portsmouth, NH this jaw dropping, one of a kind property was built in 2010 with museum quality attention to detail.
 address885 Hancock Road
 address_2
 cityWilliamstown
 stateMA
 postal_code01267
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1875000
 price_20
 price_usd1875000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms5
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres56
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size56
 icon_1views
 icon_2acreage
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_titleUnparalleled Views | Williamstown Real Estate | Alton & Westall Real Estate Agency
 meta_description885 Hancock 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_built2010
 virtual_tourhttp://tours.vestaphotostudio.com/public/vtour/display/421963
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num210920
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style24
 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.648495
 longitude-73.266953
 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-06-04 08:59:50
 uri/property-detail/2264/885-hancock-road-williamstown-ma-01267-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2264/885-hancock-road-williamstown-ma-01267-usa
 address_concat885 Hancock Road Williamstown MA 01267 USA
 google_maps_query_string885+Hancock+Road++Williamstown+MA+01267+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 1,875,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty4
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2015-06-04
 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)
 id15055
 modelProperty
 model_id2264
 tagImage
 name28088.jpg
 typeimage/jpg
 size311141
 uri/assets/15055.jpg
 order0
 created2016-04-07 16:49:05
 modified2016-04-07 16:49:05
 1(array)
 id15057
 modelProperty
 model_id2264
 tagImage
 name28090.jpg
 typeimage/jpg
 size248336
 uri/assets/15057.jpg
 order1
 created2016-04-07 16:49:05
 modified2016-04-07 16:49:05
 2(array)
 id15058
 modelProperty
 model_id2264
 tagImage
 name28091.jpg
 typeimage/jpg
 size215225
 uri/assets/15058.jpg
 order2
 created2016-04-07 16:49:05
 modified2016-04-07 16:49:05
 3(array)
 id15062
 modelProperty
 model_id2264
 tagImage
 name28097.jpg
 typeimage/jpg
 size253970
 uri/assets/15062.jpg
 order3
 created2016-04-07 16:49:05
 modified2016-04-07 16:49:05
 4(array)
 id15059
 modelProperty
 model_id2264
 tagImage
 name28092.jpg
 typeimage/jpg
 size288425
 uri/assets/15059.jpg
 order4
 created2016-04-07 16:49:05
 modified2016-04-07 16:49:05
 5(array)
 id15060
 modelProperty
 model_id2264
 tagImage
 name28093.jpg
 typeimage/jpg
 size266628
 uri/assets/15060.jpg
 order5
 created2016-04-07 16:49:05
 modified2016-04-07 16:49:05
 6(array)
 id15063
 modelProperty
 model_id2264
 tagImage
 name28098.jpg
 typeimage/jpg
 size289982
 uri/assets/15063.jpg
 order6
 created2016-04-07 16:49:05
 modified2016-04-07 16:49:05
 7(array)
 id15061
 modelProperty
 model_id2264
 tagImage
 name28094.jpg
 typeimage/jpg
 size246959
 uri/assets/15061.jpg
 order7
 created2016-04-07 16:49:05
 modified2016-04-07 16:49:05
 8(array)
 id15064
 modelProperty
 model_id2264
 tagImage
 name28096.jpg
 typeimage/jpg
 size418927
 uri/assets/15064.jpg
 order8
 created2016-04-07 16:49:05
 modified2016-04-07 16:49:05
 9(array)
 id15056
 modelProperty
 model_id2264
 tagImage
 name20894.jpg
 typeimage/jpg
 size304165
 uri/assets/15056.jpg
 order9
 created2016-04-07 16:49:05
 modified2016-04-07 16:49:05
 User(array)
 0(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)
 UsersProperty(array)
 id605
 user_id848
 property_id2264
 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)
 id3036
 property_id2264
 property_feature_id14
 Topic(empty)
 2(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)
 3(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
 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)
 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
 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
 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)
 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)
 1(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)
- custom_ga_event_properties(array)
 brokerageAlton & Westall Real Estate Agency, Williamstown
- property(array)
 Property(array)
 id956
 brokerage_id145
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id931
 agent_2_id108
 agent_3_id0
 nameStunning Contemporary
 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)
 descriptionThis energy efficient home was built in 1986 by John Hamman and doubled in size in 2000 by Bob Smith. The original home offers an entry hall with vaulted ceiling and skylight, living room with large casement windows, dining room with southwestern exposure, gourmet kitchen with granite countertops and cherry cabinets, and study with a TESS fireplace. The main level addition features a stunning great room with floor-to-ceiling Fieldstone fireplace and beautiful woodwork. An open staircase leads to the loft overlooking the great room and master suite with luxury bath. There are three additional bedrooms downstairs, plus a finished lower level with a bar/pool room. Located on desirable Ide Road, the residence also boasts perennial beds, stone walls and patios by Bart van Luling, and gorgeous mountain views.
 address90 Ide Road
 address_2
 cityWilliamstown
 stateMA
 postal_code01267
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price979000
 price_20
 price_usd979000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1views
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_titleStunning Contemporary | Williamstown Real Estate | Alton & Westall Real Estate Agency
 meta_description90 Ide Road is a property offered for sale in Williamstown, MA, USA, presented by Alton & Westall Real Estate Agency
 meta_keywords90 Ide Road, Spectacular Contemporary, Leverage Global Partners, Berkshire County Real Estate, Massachusetts Real Estate, Alton & Westall Real Estate Agency
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1986 and 2001
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num211001
 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.697624
 longitude-73.203178
 invalid_required_fields
 invalid_optional_fieldssquare_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
 created2014-07-31 11:47:43
 uri/property-detail/956/90-ide-road-williamstown-ma-01267-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/956/90-ide-road-williamstown-ma-01267-usa
 address_concat90 Ide Road Williamstown MA 01267 USA
 google_maps_query_string90+Ide+Road++Williamstown+MA+01267+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 979,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty4
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2014-07-31
 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)
 id10765
 modelProperty
 model_id956
 tagImage
 name8121.jpg
 typeimage/jpg
 size601502
 uri/assets/10765.jpg
 order0
 created2016-04-07 16:23:04
 modified2016-04-07 16:23:04
 1(array)
 id10758
 modelProperty
 model_id956
 tagImage
 name8113.jpg
 typeimage/jpg
 size294037
 uri/assets/10758.jpg
 order1
 created2016-04-07 16:23:04
 modified2016-04-07 16:23:04
 2(array)
 id10757
 modelProperty
 model_id956
 tagImage
 name8112.jpg
 typeimage/jpg
 size640487
 uri/assets/10757.jpg
 order2
 created2016-04-07 16:23:04
 modified2016-04-07 16:23:04
 3(array)
 id10759
 modelProperty
 model_id956
 tagImage
 name8115.jpg
 typeimage/jpg
 size309986
 uri/assets/10759.jpg
 order4
 created2016-04-07 16:23:04
 modified2016-04-07 16:23:04
 4(array)
 id10760
 modelProperty
 model_id956
 tagImage
 name8116.jpg
 typeimage/jpg
 size344173
 uri/assets/10760.jpg
 order5
 created2016-04-07 16:23:04
 modified2016-04-07 16:23:04
 5(array)
 id10761
 modelProperty
 model_id956
 tagImage
 name8117.jpg
 typeimage/jpg
 size252330
 uri/assets/10761.jpg
 order6
 created2016-04-07 16:23:04
 modified2016-04-07 16:23:04
 6(array)
 id10762
 modelProperty
 model_id956
 tagImage
 name8118.jpg
 typeimage/jpg
 size351540
 uri/assets/10762.jpg
 order7
 created2016-04-07 16:23:04
 modified2016-04-07 16:23:04
 7(array)
 id10763
 modelProperty
 model_id956
 tagImage
 name8119.jpg
 typeimage/jpg
 size215064
 uri/assets/10763.jpg
 order8
 created2016-04-07 16:23:04
 modified2016-04-07 16:23:04
 8(array)
 id10764
 modelProperty
 model_id956
 tagImage
 name8120.jpg
 typeimage/jpg
 size351226
 uri/assets/10764.jpg
 order9
 created2016-04-07 16:23:04
 modified2016-04-07 16:23:04
 User(array)
 0(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)
 UsersProperty(array)
 id125
 user_id336
 property_id956
 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)
 1(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)
 id856
 user_id1095
 property_id956
 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)
 id1891
 property_id956
 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/956/90-ide-road-williamstown-ma-01267-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/property-detail/956/90-ide-road-williamstown-ma-01267-usa
Remote Port	17743
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	104.23.197.114
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	a09d2efe2b1626b9-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	aiodVruUq-KEPF5ETZTvjgAAARU
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	aiodVruUq-KEPF5ETZTvjgAAARU
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781144918.8335
Request Time	1781144918

====

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

Stunning Contemporary

Represented By: Alton & Westall Real Estate Agency

altonwestall.com | License #: 012345

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: 37 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: 37 queries