Properties /

Mountain Castle

3671 Buttercup Rd | Hailey, ID 83333, USA | $5,000,000

11 Beds
12 Baths
4 Half Ba
8.00 Acres
Media Room
Gym
Wine Cellar

This Log Lodge on 8.5 acres is perfect for large gatherings or corporate retreats. Comfortable separate living spaces can accommodate up to 30 people in luxury. RAmenities include 3 offices, huge spa/gym, wine cellar,gun room, spacious yard, horse facilities. The Valley Club is across the street, skiing just 8 minutes away.

Represented By: Sun Valley Real Estate, LLC

View On Map

Highlighted Properties

Summit Estate on 214 acres

89 Gimlet Road | Ketchum , ID 83340
$10,000,000

Serenity Lodge

140 Telemark | Ketchum, ID 83340
$16,900,000

Represented By

Featured Location

Sun Valley, ID, USA

Related Property Listings

Serenity Lodge

140 Telemark
Ketchum, ID 83340
$16,900,000

Mountain Castle

3671 Buttercup Rd
Hailey, ID 83333
$5,000,000

Sutton

102 Sutton Place
Ketchum , ID 83340
$4,190,000

Historic Victorian Ranch on the River

11038 State Highway 75
Bellevue, ID 83313
$4,250,000

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

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

Cake Params
- plugin(null)
- controllerproperties
- actionview
- named(empty)
- pass(array)
  03117
  13671-buttercup-rd-hailey-id-83333-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: 18 ms
Total Queries: 33 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` = 3117 AND `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`incomplete` = '0' LIMIT 1	1	1	2	maybe slow
SELECT `AccountExecutive`.`id`, `AccountExecutive`.`type`, `AccountExecutive`.`brokerage_id`, `AccountExecutive`.`email`, `AccountExecutive`.`password`, `AccountExecutive`.`recover_hash`, `AccountExecutive`.`first_name`, `AccountExecutive`.`last_name`, `AccountExecutive`.`title`, `AccountExecutive`.`dre_num`, `AccountExecutive`.`phone`, `AccountExecutive`.`max_luxury_feed_properties`, `AccountExecutive`.`headshot_filename`, `AccountExecutive`.`bio`, `AccountExecutive`.`brokerage_name_override`, `AccountExecutive`.`stripe_customer_id`, `AccountExecutive`.`digital_ad_first_free_month_coupon`, `AccountExecutive`.`modified`, `AccountExecutive`.`created`, `AccountExecutive`.`notified`, (CONCAT(`AccountExecutive`.`first_name`, " ", `AccountExecutive`.`last_name`)) AS `AccountExecutive__full_name` FROM `leveragere_staging2`.`users` AS `AccountExecutive` WHERE `AccountExecutive`.`id` = 235	1	1	0
SELECT `Logo`.`id`, `Logo`.`model`, `Logo`.`model_id`, `Logo`.`tag`, `Logo`.`name`, `Logo`.`type`, `Logo`.`size`, `Logo`.`uri`, `Logo`.`order`, `Logo`.`created`, `Logo`.`modified` FROM `leveragere_staging2`.`assets` AS `Logo` WHERE `Logo`.`model_id` = 204 AND `Logo`.`model` = 'Brokerage' AND `Logo`.`tag` = 'Logo'	1	1	1
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` = 204 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` = 204 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` = 204 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` = 204 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` = 204 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` = 204 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` = (204) 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` = (204)	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` = (204)	3	3	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` = (3117) ORDER BY `Image`.`order` ASC	10	10	0
SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` = 3117 AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	0	0	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` = 3117 AND `PropertiesSecondaryPropertyCategory`.`property_category_id` = `SecondaryPropertyCategory`.`id`)	0	0	3	maybe slow
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` = 3117 AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	3	3	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` = 8 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	0
SELECT `Icon`.`id`, `Icon`.`model`, `Icon`.`model_id`, `Icon`.`tag`, `Icon`.`name`, `Icon`.`type`, `Icon`.`size`, `Icon`.`uri`, `Icon`.`order`, `Icon`.`created`, `Icon`.`modified` FROM `leveragere_staging2`.`assets` AS `Icon` WHERE `Icon`.`model_id` = 6 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	0
SELECT `Icon`.`id`, `Icon`.`model`, `Icon`.`model_id`, `Icon`.`tag`, `Icon`.`name`, `Icon`.`type`, `Icon`.`size`, `Icon`.`uri`, `Icon`.`order`, `Icon`.`created`, `Icon`.`modified` FROM `leveragere_staging2`.`assets` AS `Icon` WHERE `Icon`.`model_id` = 18 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` = 3117 AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	3	maybe slow
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` != 3117 AND `Property`.`brokerage_id` = 204 AND `Property`.`status` != 'Sold' AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 2	2	2	3	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 (2309, 2253) ORDER BY `Image`.`order` ASC	20	20	1	maybe slow
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 (2309, 2253) 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 (2309, 2253) 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 (2309, 2253) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	8	8	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (2309, 2253) 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` = 204 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` = 204 AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	3	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 (2253, 3117, 2965, 3118) ORDER BY `Image`.`order` ASC	33	33	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 (2253, 3117, 2965, 3118) 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 (2253, 3117, 2965, 3118) 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 (2253, 3117, 2965, 3118) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	15	15	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 (2253, 3117, 2965, 3118) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 10.23 MB

Message	Memory use
Component initialization	3.07 MB
Controller action start	4.01 MB
Controller render start	6.71 MB
View render complete	7.23 MB

Timers

Total Request Time: 298 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	40.78
Event: Controller.initialize	5.37
Event: Controller.startup	3.07
Controller action	109.97
Event: Controller.beforeRender	6.07
» Processing toolbar data	5.97
Rendering View	89.54
» Event: View.beforeRender	0.41
» Rendering APP/View/Properties/view.ctp	3.49
» » Rendering APP/View/Elements/static_property_price.ctp	0.48
» » Rendering APP/View/Elements/property_features.ctp	0.25
» » Rendering APP/View/Elements/static_property_price.ctp #2	0.15
» » Rendering APP/View/Elements/static_property_price.ctp #3	0.15
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.15
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.05
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #5	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #6	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #7	0.15
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.20
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	84.76
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)
 id2253
 brokerage_id204
 created_by_user_id0
 order1
 multi_unit(false)
 agent_1_id645
 agent_2_id0
 agent_3_id0
 nameSerenity Lodge
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionSerenity Lodge in Sun Valley Idaho provides a quiet retreat moments from downtown Ketchum. Located in the hills just north of Ketchum this elevated property boasts 360 degree mountain views. Constructed with an unrivaled level of luxury, the residence spans three levels of intimate spaces featuring beamed ceilings; custom millwork and cabinetry; reclaimed oak floors; a Schindler elevator and Loewen windows and doors. The beautifully maintained 4.5 acre parcel features a heated paver driveway and two waterfalls that gently flow on either side of the residence. The main level includes gourmet kitchen, formal dining and living rooms, spacious master suite and two guest suites. A separate two bedroom, two bath guest or staff apartment located off the 9 car garage is entirely independent. The second floor has its own kitchen, media room, gym, 1400 bottle wine cellar, sauna, massage room and abundant secured storage.
 address140 Telemark
 address_2
 cityKetchum
 stateID
 postal_code83340
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price16900000
 price_20
 price_usd16900000
 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
 bathrooms8
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1views
 icon_2garage
 icon_3guest-house
 icon_4cellar
 icon_5balcony-terrace
 icon_6
 websitehttp://www.suzannewilliams.com/property/serenity-lodge/
 meta_titleSerenity Lodge | Ketchum Real Estate | Sun Valley Real Estate, LLC
 meta_description140 Telemark is a property offered for sale in Ketchum, ID, USA, presented by Sun Valley Real Estate, LLC
 meta_keywords
 bathrooms_partial2
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tourhttps://youtu.be/Y4JQUsaGhg8
 digital_brochure
 video_tour_embed_code<iframe width="560" height="315" src="https://www.youtube.com/embed/Y4JQUsaGhg8?controls=0&showinfo=0" frameborder="0" allowfullscreen></iframe>
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_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-03 05:58:24
 uri/property-detail/2253/140-telemark-ketchum-id-83340-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2253/140-telemark-ketchum-id-83340-usa
 address_concat140 Telemark Ketchum ID 83340 USA
 google_maps_query_string140+Telemark++Ketchum+ID+83340+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 16,900,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty8
 bathrooms_partial_pretty2
 bathrooms_3_4_pretty0
 feed_full_bathrooms8
 date_listed2015-06-03
 overridden_brokerage_nameSun Valley Real Estate, LLC
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id204
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2501907
 timezoneUS/Mountain
 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
 nameSun Valley Real Estate, LLC
 broker_of_record_name
 short_nameSun Valley Real Estate, LLC
 usernameSunValleyRE
 passwordc6f87f8b4bf4831cf667fad365f356cab2e29afc
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionSun Valley Real Estate, LLC is the exclusive representative for Leverage Global Partners in Sun Valley and Ketchum, Idaho, USA. Sun Valley Real Estate, LLC/Christie’s International Real Estate is an independently owned brokerage with fifteen brokers and agents dedicated to providing the highest level of professional real estate service to their clients. Agents are experts in Wood River Valley real estate and represent both Buyers and Sellers with complete market knowledge. As the Exclusive Affiliate of Christie’s International Real Estate, Sun Valley Real Estate enjoys access to a global network that is supported by the esteemed auction house. Our network offers exclusive homes to buyers worldwide, and by focusing on luxury residential real estate, we know best how to reach and serve a discerning clientele. The Christie’s brand is instantly recognizable and distinguishes our properties from others.
 communitiesSun Valley Ketchum
 websitehttp://www.sunvalleyrealestate.com/
 address300 North Main Street
 address_2
 cityKetchum
 stateID
 full_stateIdaho
 countryUSA
 marketSun Valley
 market_2
 postal_code83340
 phone(208) 726 6000
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameThe Team at Sun Valley Real Estate, LLC
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwners and Real Estate Professionals
 contact_dre_num
 contact_quoteWe invite you to contact us about Sun Valley real estate
 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_filename204.jpg
 logo_filename204.jpg
 contact_image_filename204.jpeg
 all_properties_link_image_filename204.jpg
 all_properties_linkhttp://www.christiesrealestate.com/eng/sales/ketchum-id-usa
 video_embed_code
 contact_video_embed_code
 meta_titleSun Valley Real Estate | Sun Valley Real Estate, LLC | Leverage Global Partners
 meta_descriptionSun Valley Real Estate, LLC is the exclusive representative for Leverage Global Partners in Sun Valley and Ketchum, Idaho, USA
 meta_keywordsSun Valley Real Estate, LLC, Leverage Global Partners, Sun Valley Real Estate, Ketchum Real Estate, Idaho Real Estate, Suzanne Williams
 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)
 created2015-05-22 10:48:20
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/204/sun-valley-real-estate-llc
 website_shortwww.sunvalleyrealestate.com
 name_with_locationSun Valley Real Estate, LLC
 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)
 id15020
 modelProperty
 model_id2253
 tagImage
 name20821.jpg
 typeimage/jpg
 size619274
 uri/assets/15020.jpg
 order0
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 1(array)
 id15012
 modelProperty
 model_id2253
 tagImage
 name20813.jpg
 typeimage/jpg
 size770721
 uri/assets/15012.jpg
 order1
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 2(array)
 id15013
 modelProperty
 model_id2253
 tagImage
 name20814.jpg
 typeimage/jpg
 size417218
 uri/assets/15013.jpg
 order2
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 3(array)
 id15014
 modelProperty
 model_id2253
 tagImage
 name20815.jpg
 typeimage/jpg
 size578171
 uri/assets/15014.jpg
 order3
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 4(array)
 id15021
 modelProperty
 model_id2253
 tagImage
 name20822.jpg
 typeimage/jpg
 size456983
 uri/assets/15021.jpg
 order4
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 5(array)
 id15016
 modelProperty
 model_id2253
 tagImage
 name20817.jpg
 typeimage/jpg
 size454691
 uri/assets/15016.jpg
 order5
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 6(array)
 id15018
 modelProperty
 model_id2253
 tagImage
 name20819.jpg
 typeimage/jpg
 size396654
 uri/assets/15018.jpg
 order6
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 7(array)
 id15019
 modelProperty
 model_id2253
 tagImage
 name20820.jpg
 typeimage/jpg
 size385350
 uri/assets/15019.jpg
 order7
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 8(array)
 id15017
 modelProperty
 model_id2253
 tagImage
 name20818.jpg
 typeimage/jpg
 size509655
 uri/assets/15017.jpg
 order8
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 9(array)
 id15015
 modelProperty
 model_id2253
 tagImage
 name20816.jpg
 typeimage/jpg
 size262280
 uri/assets/15015.jpg
 order9
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 User(array)
 0(array)
 id842
 typeAgent
 brokerage_id204
 email[email protected]
 passwordf3f948148dbef39a47d40eadb3ed23e05f99b0c1
 recover_hash
 first_nameSuzanne
 last_nameWilliams
 title
 dre_num
 phone208 720 3951
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:40
 created2017-08-07 15:23:40
 notified(false)
 full_nameSuzanne Williams
 uri/agent-detail/842/suzanne-williams
 profile_complete(true)
 UsersProperty(array)
 id597
 user_id842
 property_id2253
 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)
 id3022
 property_id2253
 property_feature_id14
 1(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id3023
 property_id2253
 property_feature_id4
 2(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id3024
 property_id2253
 property_feature_id5
 3(array)
 id18
 nameWine Cellar
 additional(false)
 created2016-04-07 14:06:17
 modified2016-04-07 14:06:17
 PropertiesPropertyFeature(array)
 id3025
 property_id2253
 property_feature_id18
 4(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id3026
 property_id2253
 property_feature_id1
 Topic(empty)
 1(array)
 Property(array)
 id3117
 brokerage_id204
 created_by_user_id0
 order4
 multi_unit(false)
 agent_1_id928
 agent_2_id0
 agent_3_id0
 nameMountain Castle
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionThis Log Lodge on 8.5 acres is perfect for large gatherings or corporate retreats. Comfortable separate living spaces can accommodate up to 30 people in luxury. RAmenities include 3 offices, huge spa/gym, wine cellar,gun room, spacious yard, horse facilities. The Valley Club is across the street, skiing just 8 minutes away.
 address 3671 Buttercup Rd
 address_2
 cityHailey
 stateID
 postal_code83333
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price5000000
 price_20
 price_usd5000000
 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)
 bedrooms11
 bedrooms_20
 bathrooms12
 bathrooms_20
 no_beds_baths(false)
 square_feet15000
 square_meters
 acres8
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size8
 icon_1sq-ft
 icon_2media-room
 icon_3gym
 icon_4library
 icon_5cellar
 icon_6
 website
 meta_titleMountain Castle | Hailey Real Estate | Sun Valley Real Estate, LLC
 meta_description 3671 Buttercup Rd is a property offered for sale in Hailey, ID, USA, presented by Sun Valley Real Estate, LLC
 meta_keywords
 bathrooms_partial4
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_meters, hectares, year_built, virtual_tour, video_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2015-11-19 20:50:53
 uri/property-detail/3117/3671-buttercup-rd-hailey-id-83333-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3117/3671-buttercup-rd-hailey-id-83333-usa
 address_concat 3671 Buttercup Rd Hailey ID 83333 USA
 google_maps_query_string+3671+Buttercup+Rd++Hailey+ID+83333+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 5,000,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty11
 bathrooms_pretty12
 bathrooms_partial_pretty4
 bathrooms_3_4_pretty0
 feed_full_bathrooms12
 date_listed2015-11-19
 overridden_brokerage_nameSun Valley Real Estate, LLC
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id204
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2501907
 timezoneUS/Mountain
 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
 nameSun Valley Real Estate, LLC
 broker_of_record_name
 short_nameSun Valley Real Estate, LLC
 usernameSunValleyRE
 passwordc6f87f8b4bf4831cf667fad365f356cab2e29afc
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionSun Valley Real Estate, LLC is the exclusive representative for Leverage Global Partners in Sun Valley and Ketchum, Idaho, USA. Sun Valley Real Estate, LLC/Christie’s International Real Estate is an independently owned brokerage with fifteen brokers and agents dedicated to providing the highest level of professional real estate service to their clients. Agents are experts in Wood River Valley real estate and represent both Buyers and Sellers with complete market knowledge. As the Exclusive Affiliate of Christie’s International Real Estate, Sun Valley Real Estate enjoys access to a global network that is supported by the esteemed auction house. Our network offers exclusive homes to buyers worldwide, and by focusing on luxury residential real estate, we know best how to reach and serve a discerning clientele. The Christie’s brand is instantly recognizable and distinguishes our properties from others.
 communitiesSun Valley Ketchum
 websitehttp://www.sunvalleyrealestate.com/
 address300 North Main Street
 address_2
 cityKetchum
 stateID
 full_stateIdaho
 countryUSA
 marketSun Valley
 market_2
 postal_code83340
 phone(208) 726 6000
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameThe Team at Sun Valley Real Estate, LLC
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwners and Real Estate Professionals
 contact_dre_num
 contact_quoteWe invite you to contact us about Sun Valley real estate
 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_filename204.jpg
 logo_filename204.jpg
 contact_image_filename204.jpeg
 all_properties_link_image_filename204.jpg
 all_properties_linkhttp://www.christiesrealestate.com/eng/sales/ketchum-id-usa
 video_embed_code
 contact_video_embed_code
 meta_titleSun Valley Real Estate | Sun Valley Real Estate, LLC | Leverage Global Partners
 meta_descriptionSun Valley Real Estate, LLC is the exclusive representative for Leverage Global Partners in Sun Valley and Ketchum, Idaho, USA
 meta_keywordsSun Valley Real Estate, LLC, Leverage Global Partners, Sun Valley Real Estate, Ketchum Real Estate, Idaho Real Estate, Suzanne Williams
 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)
 created2015-05-22 10:48:20
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/204/sun-valley-real-estate-llc
 website_shortwww.sunvalleyrealestate.com
 name_with_locationSun Valley Real Estate, LLC
 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)
 id18167
 modelProperty
 model_id3117
 tagImage
 name29941.jpg
 typeimage/jpg
 size741991
 uri/assets/18167.jpg
 order0
 created2016-04-07 17:08:07
 modified2016-04-07 17:08:07
 1(array)
 id18168
 modelProperty
 model_id3117
 tagImage
 name29945.jpg
 typeimage/jpg
 size1732465
 uri/assets/18168.jpg
 order1
 created2016-04-07 17:08:07
 modified2016-04-07 17:08:07
 2(array)
 id18172
 modelProperty
 model_id3117
 tagImage
 name29946.jpg
 typeimage/jpg
 size1635762
 uri/assets/18172.jpg
 order2
 created2016-04-07 17:08:07
 modified2016-04-07 17:08:07
 3(array)
 id18171
 modelProperty
 model_id3117
 tagImage
 name29944.jpg
 typeimage/jpg
 size1601409
 uri/assets/18171.jpg
 order3
 created2016-04-07 17:08:07
 modified2016-04-07 17:08:07
 4(array)
 id18174
 modelProperty
 model_id3117
 tagImage
 name29948.jpg
 typeimage/jpg
 size1958318
 uri/assets/18174.jpg
 order4
 created2016-04-07 17:08:07
 modified2016-04-07 17:08:08
 5(array)
 id18173
 modelProperty
 model_id3117
 tagImage
 name29947.jpg
 typeimage/jpg
 size1499655
 uri/assets/18173.jpg
 order5
 created2016-04-07 17:08:07
 modified2016-04-07 17:08:07
 6(array)
 id18170
 modelProperty
 model_id3117
 tagImage
 name29943.jpg
 typeimage/jpg
 size1577161
 uri/assets/18170.jpg
 order6
 created2016-04-07 17:08:07
 modified2016-04-07 17:08:07
 7(array)
 id18175
 modelProperty
 model_id3117
 tagImage
 name29949.jpg
 typeimage/jpg
 size1681192
 uri/assets/18175.jpg
 order7
 created2016-04-07 17:08:08
 modified2016-04-07 17:08:08
 8(array)
 id18176
 modelProperty
 model_id3117
 tagImage
 name29950.jpg
 typeimage/jpg
 size1677208
 uri/assets/18176.jpg
 order8
 created2016-04-07 17:08:08
 modified2016-04-07 17:08:08
 9(array)
 id18169
 modelProperty
 model_id3117
 tagImage
 name29942.jpg
 typeimage/jpg
 size1580428
 uri/assets/18169.jpg
 order9
 created2016-04-07 17:08:07
 modified2016-04-07 17:08:07
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id8
 nameMedia Room
 additional(false)
 created2016-04-07 14:03:04
 modified2016-04-07 14:03:04
 PropertiesPropertyFeature(array)
 id3830
 property_id3117
 property_feature_id8
 1(array)
 id6
 nameGym
 additional(false)
 created2016-04-07 14:02:29
 modified2016-04-07 14:02:29
 PropertiesPropertyFeature(array)
 id3831
 property_id3117
 property_feature_id6
 2(array)
 id18
 nameWine Cellar
 additional(false)
 created2016-04-07 14:06:17
 modified2016-04-07 14:06:17
 PropertiesPropertyFeature(array)
 id3832
 property_id3117
 property_feature_id18
 Topic(empty)
 2(array)
 Property(array)
 id2965
 brokerage_id204
 created_by_user_id0
 order6
 multi_unit(false)
 agent_1_id980
 agent_2_id0
 agent_3_id0
 nameSutton
 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)
 descriptionCreated on 2.17 acres, this estate features a main home, guest cottage, horse facility, park-like gardens with pond, sandy beach, zip line and tree house. All just minutes from skiing, golf and resort amenities in world-famous Sun Valley, Idaho. Award winning Dale Bates architectural elements and ''Healthy Homes'' fit and finish by Craig Johnson Construction define this one of a kind retreat.
 address102 Sutton Place
 address_2
 cityKetchum
 stateID
 postal_code83340
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price4190000
 price_20
 price_usd4190000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms6
 bedrooms_20
 bathrooms6
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres2
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size2
 icon_1acreage
 icon_2guest-house
 icon_3office
 icon_4media-room
 icon_5
 icon_6
 website
 meta_titleSutton | Ketchum Real Estate | Sun Valley Real Estate, LLC
 meta_description102 Sutton Place is a property offered for sale in Ketchum , ID, USA, presented by Sun Valley Real Estate, LLC
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, bathrooms_partial, square_feet, square_meters, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-10-26 13:54:56
 uri/property-detail/2965/102-sutton-place-ketchum-id-83340-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2965/102-sutton-place-ketchum-id-83340-usa
 address_concat102 Sutton Place Ketchum ID 83340 USA
 google_maps_query_string102+Sutton+Place++Ketchum++ID+83340+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 4,190,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty6
 bathrooms_pretty6
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms6
 date_listed2015-10-26
 overridden_brokerage_nameSun Valley Real Estate, LLC
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id204
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2501907
 timezoneUS/Mountain
 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
 nameSun Valley Real Estate, LLC
 broker_of_record_name
 short_nameSun Valley Real Estate, LLC
 usernameSunValleyRE
 passwordc6f87f8b4bf4831cf667fad365f356cab2e29afc
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionSun Valley Real Estate, LLC is the exclusive representative for Leverage Global Partners in Sun Valley and Ketchum, Idaho, USA. Sun Valley Real Estate, LLC/Christie’s International Real Estate is an independently owned brokerage with fifteen brokers and agents dedicated to providing the highest level of professional real estate service to their clients. Agents are experts in Wood River Valley real estate and represent both Buyers and Sellers with complete market knowledge. As the Exclusive Affiliate of Christie’s International Real Estate, Sun Valley Real Estate enjoys access to a global network that is supported by the esteemed auction house. Our network offers exclusive homes to buyers worldwide, and by focusing on luxury residential real estate, we know best how to reach and serve a discerning clientele. The Christie’s brand is instantly recognizable and distinguishes our properties from others.
 communitiesSun Valley Ketchum
 websitehttp://www.sunvalleyrealestate.com/
 address300 North Main Street
 address_2
 cityKetchum
 stateID
 full_stateIdaho
 countryUSA
 marketSun Valley
 market_2
 postal_code83340
 phone(208) 726 6000
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameThe Team at Sun Valley Real Estate, LLC
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwners and Real Estate Professionals
 contact_dre_num
 contact_quoteWe invite you to contact us about Sun Valley real estate
 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_filename204.jpg
 logo_filename204.jpg
 contact_image_filename204.jpeg
 all_properties_link_image_filename204.jpg
 all_properties_linkhttp://www.christiesrealestate.com/eng/sales/ketchum-id-usa
 video_embed_code
 contact_video_embed_code
 meta_titleSun Valley Real Estate | Sun Valley Real Estate, LLC | Leverage Global Partners
 meta_descriptionSun Valley Real Estate, LLC is the exclusive representative for Leverage Global Partners in Sun Valley and Ketchum, Idaho, USA
 meta_keywordsSun Valley Real Estate, LLC, Leverage Global Partners, Sun Valley Real Estate, Ketchum Real Estate, Idaho Real Estate, Suzanne Williams
 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)
 created2015-05-22 10:48:20
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/204/sun-valley-real-estate-llc
 website_shortwww.sunvalleyrealestate.com
 name_with_locationSun Valley Real Estate, LLC
 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)
 id17586
 modelProperty
 model_id2965
 tagImage
 name28396.png
 typeimage/png
 size3967940
 uri/assets/17586.png
 order0
 created2016-04-07 17:05:03
 modified2016-04-07 17:05:04
 1(array)
 id17585
 modelProperty
 model_id2965
 tagImage
 name29774.jpg
 typeimage/jpg
 size747326
 uri/assets/17585.jpg
 order1
 created2016-04-07 17:05:03
 modified2016-04-07 17:05:03
 2(array)
 id17587
 modelProperty
 model_id2965
 tagImage
 name28397.png
 typeimage/png
 size3042837
 uri/assets/17587.png
 order2
 created2016-04-07 17:05:07
 modified2016-04-07 17:05:07
 User(array)
 0(array)
 id1124
 typeAgent
 brokerage_id204
 email[email protected]
 password1e425e7b4d20532b4e89bf88dbb217911822d4df
 recover_hash
 first_nameBrad
 last_nameDufur
 title
 dre_num
 phone208 726 6000
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:55
 created2017-08-07 15:23:55
 notified(false)
 full_nameBrad Dufur
 uri/agent-detail/1124/brad-dufur
 profile_complete(true)
 UsersProperty(array)
 id898
 user_id1124
 property_id2965
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id3684
 property_id2965
 property_feature_id5
 1(array)
 id9
 nameOffice
 additional(false)
 created2016-04-07 14:03:21
 modified2016-04-07 14:03:21
 PropertiesPropertyFeature(array)
 id3685
 property_id2965
 property_feature_id9
 2(array)
 id8
 nameMedia Room
 additional(false)
 created2016-04-07 14:03:04
 modified2016-04-07 14:03:04
 PropertiesPropertyFeature(array)
 id3686
 property_id2965
 property_feature_id8
 Topic(empty)
 3(array)
 Property(array)
 id3118
 brokerage_id204
 created_by_user_id0
 order5
 multi_unit(false)
 agent_1_id928
 agent_2_id0
 agent_3_id0
 nameHistoric Victorian Ranch on the River
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionThis iconic property is an authentic part of the history of the Wood River Valley. The lovingly restored Queen Anne Victorian Minnie Moor Mine Mansion was built by a silver mining baron, Henry Miller, in 1880 as a wedding gift for his bride, Annie. Originally built in Bellevue, it was moved South of town to its present 52 acre site on the Bigwood River in 1911. The ranch now includes the magnificent stone and timber barn with riding arenas, a two bedroom guest house, and most recently the garage building with a magnificent studio loft, entertainment kitchen, and a veranda with views across the property towards the river and mountain sunsets. Fishing on the Bigwood is a private experience as the ranch flanks both sides of the river, and Hemingways hunting and fishing paradise, Silver Creek, is only 15 minutes from the property. The property is further subdivide-able offering the opportunity for expanded residential buildings for a family compound or unique retreat. There is nothing like this property in all of Blaine County. 
 address 11038 State Highway 75
 address_2
 cityBellevue
 stateID
 postal_code83313
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price4250000
 price_20
 price_usd4250000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms7
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres52
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size52
 icon_1acreage
 icon_2waterfront
 icon_3guest-house
 icon_4library
 icon_5balcony-terrace
 icon_6media-room
 website
 meta_titleHistoric Victorian Ranch on the River | Bellevue Real Estate | Sun Valley Real Estate, LLC
 meta_description 11038 State Highway 75 is a property offered for sale in Bellevue, ID, USA, presented by Sun Valley Real Estate, LLC
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, hectares, bathrooms_partial, year_built, virtual_tour, video_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2015-11-19 21:11:29
 uri/property-detail/3118/11038-state-highway-75-bellevue-id-83313-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3118/11038-state-highway-75-bellevue-id-83313-usa
 address_concat 11038 State Highway 75 Bellevue ID 83313 USA
 google_maps_query_string+11038+State+Highway+75++Bellevue+ID+83313+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 4,250,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty7
 bathrooms_pretty4
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2015-11-19
 overridden_brokerage_nameSun Valley Real Estate, LLC
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id204
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2501907
 timezoneUS/Mountain
 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
 nameSun Valley Real Estate, LLC
 broker_of_record_name
 short_nameSun Valley Real Estate, LLC
 usernameSunValleyRE
 passwordc6f87f8b4bf4831cf667fad365f356cab2e29afc
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionSun Valley Real Estate, LLC is the exclusive representative for Leverage Global Partners in Sun Valley and Ketchum, Idaho, USA. Sun Valley Real Estate, LLC/Christie’s International Real Estate is an independently owned brokerage with fifteen brokers and agents dedicated to providing the highest level of professional real estate service to their clients. Agents are experts in Wood River Valley real estate and represent both Buyers and Sellers with complete market knowledge. As the Exclusive Affiliate of Christie’s International Real Estate, Sun Valley Real Estate enjoys access to a global network that is supported by the esteemed auction house. Our network offers exclusive homes to buyers worldwide, and by focusing on luxury residential real estate, we know best how to reach and serve a discerning clientele. The Christie’s brand is instantly recognizable and distinguishes our properties from others.
 communitiesSun Valley Ketchum
 websitehttp://www.sunvalleyrealestate.com/
 address300 North Main Street
 address_2
 cityKetchum
 stateID
 full_stateIdaho
 countryUSA
 marketSun Valley
 market_2
 postal_code83340
 phone(208) 726 6000
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameThe Team at Sun Valley Real Estate, LLC
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwners and Real Estate Professionals
 contact_dre_num
 contact_quoteWe invite you to contact us about Sun Valley real estate
 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_filename204.jpg
 logo_filename204.jpg
 contact_image_filename204.jpeg
 all_properties_link_image_filename204.jpg
 all_properties_linkhttp://www.christiesrealestate.com/eng/sales/ketchum-id-usa
 video_embed_code
 contact_video_embed_code
 meta_titleSun Valley Real Estate | Sun Valley Real Estate, LLC | Leverage Global Partners
 meta_descriptionSun Valley Real Estate, LLC is the exclusive representative for Leverage Global Partners in Sun Valley and Ketchum, Idaho, USA
 meta_keywordsSun Valley Real Estate, LLC, Leverage Global Partners, Sun Valley Real Estate, Ketchum Real Estate, Idaho Real Estate, Suzanne Williams
 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)
 created2015-05-22 10:48:20
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/204/sun-valley-real-estate-llc
 website_shortwww.sunvalleyrealestate.com
 name_with_locationSun Valley Real Estate, LLC
 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)
 id18177
 modelProperty
 model_id3118
 tagImage
 name29951.jpg
 typeimage/jpg
 size737265
 uri/assets/18177.jpg
 order0
 created2016-04-07 17:08:08
 modified2016-04-07 17:08:08
 1(array)
 id18184
 modelProperty
 model_id3118
 tagImage
 name29958.jpg
 typeimage/jpg
 size511714
 uri/assets/18184.jpg
 order1
 created2016-04-07 17:08:08
 modified2016-04-07 17:08:08
 2(array)
 id18183
 modelProperty
 model_id3118
 tagImage
 name29960.jpg
 typeimage/jpg
 size536165
 uri/assets/18183.jpg
 order2
 created2016-04-07 17:08:08
 modified2016-04-07 17:08:08
 3(array)
 id18185
 modelProperty
 model_id3118
 tagImage
 name29959.jpg
 typeimage/jpg
 size488296
 uri/assets/18185.jpg
 order3
 created2016-04-07 17:08:08
 modified2016-04-07 17:08:08
 4(array)
 id18178
 modelProperty
 model_id3118
 tagImage
 name29952.jpg
 typeimage/jpg
 size525990
 uri/assets/18178.jpg
 order4
 created2016-04-07 17:08:08
 modified2016-04-07 17:08:08
 5(array)
 id18181
 modelProperty
 model_id3118
 tagImage
 name29961.jpg
 typeimage/jpg
 size524941
 uri/assets/18181.jpg
 order5
 created2016-04-07 17:08:08
 modified2016-04-07 17:08:08
 6(array)
 id18179
 modelProperty
 model_id3118
 tagImage
 name29953.jpg
 typeimage/jpg
 size429215
 uri/assets/18179.jpg
 order6
 created2016-04-07 17:08:08
 modified2016-04-07 17:08:08
 7(array)
 id18186
 modelProperty
 model_id3118
 tagImage
 name29962.jpg
 typeimage/jpg
 size520641
 uri/assets/18186.jpg
 order7
 created2016-04-07 17:08:08
 modified2016-04-07 17:08:08
 8(array)
 id18180
 modelProperty
 model_id3118
 tagImage
 name29954.jpg
 typeimage/jpg
 size512306
 uri/assets/18180.jpg
 order8
 created2016-04-07 17:08:08
 modified2016-04-07 17:08:08
 9(array)
 id18182
 modelProperty
 model_id3118
 tagImage
 name29956.jpg
 typeimage/jpg
 size563674
 uri/assets/18182.jpg
 order9
 created2016-04-07 17:08:08
 modified2016-04-07 17:08:08
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id17
 nameWaterfront
 additional(false)
 created2016-04-07 14:06:00
 modified2016-04-07 14:06:00
 PropertiesPropertyFeature(array)
 id3833
 property_id3118
 property_feature_id17
 1(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id3834
 property_id3118
 property_feature_id5
 2(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id3835
 property_id3118
 property_feature_id1
 3(array)
 id8
 nameMedia Room
 additional(false)
 created2016-04-07 14:03:04
 modified2016-04-07 14:03:04
 PropertiesPropertyFeature(array)
 id3836
 property_id3118
 property_feature_id8
 Topic(empty)
- sidebar_locations(array)
 0(array)
 Location(array)
 id44
 parent_id9
 brokerage_id204
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameSun Valley, ID, USA
 short_nameSun Valley, ID, USA
 group_index
 latitude43.697128
 longitude-114.351715
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 12:46:21
 modified2016-04-04 12:46:21
 timezoneAmerica/Boise
 population1500
 uri/locations/view/44/sun-valley-id-usa
 tile_nameSun Valley, ID, USA
 Brokerage(array)
 id204
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2501907
 timezoneUS/Mountain
 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
 nameSun Valley Real Estate, LLC
 broker_of_record_name
 short_nameSun Valley Real Estate, LLC
 usernameSunValleyRE
 passwordc6f87f8b4bf4831cf667fad365f356cab2e29afc
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionSun Valley Real Estate, LLC is the exclusive representative for Leverage Global Partners in Sun Valley and Ketchum, Idaho, USA. Sun Valley Real Estate, LLC/Christie’s International Real Estate is an independently owned brokerage with fifteen brokers and agents dedicated to providing the highest level of professional real estate service to their clients. Agents are experts in Wood River Valley real estate and represent both Buyers and Sellers with complete market knowledge. As the Exclusive Affiliate of Christie’s International Real Estate, Sun Valley Real Estate enjoys access to a global network that is supported by the esteemed auction house. Our network offers exclusive homes to buyers worldwide, and by focusing on luxury residential real estate, we know best how to reach and serve a discerning clientele. The Christie’s brand is instantly recognizable and distinguishes our properties from others.
 communitiesSun Valley Ketchum
 websitehttp://www.sunvalleyrealestate.com/
 address300 North Main Street
 address_2
 cityKetchum
 stateID
 full_stateIdaho
 countryUSA
 marketSun Valley
 market_2
 postal_code83340
 phone(208) 726 6000
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameThe Team at Sun Valley Real Estate, LLC
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwners and Real Estate Professionals
 contact_dre_num
 contact_quoteWe invite you to contact us about Sun Valley real estate
 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_filename204.jpg
 logo_filename204.jpg
 contact_image_filename204.jpeg
 all_properties_link_image_filename204.jpg
 all_properties_linkhttp://www.christiesrealestate.com/eng/sales/ketchum-id-usa
 video_embed_code
 contact_video_embed_code
 meta_titleSun Valley Real Estate | Sun Valley Real Estate, LLC | Leverage Global Partners
 meta_descriptionSun Valley Real Estate, LLC is the exclusive representative for Leverage Global Partners in Sun Valley and Ketchum, Idaho, USA
 meta_keywordsSun Valley Real Estate, LLC, Leverage Global Partners, Sun Valley Real Estate, Ketchum Real Estate, Idaho Real Estate, Suzanne Williams
 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)
 created2015-05-22 10:48:20
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/204/sun-valley-real-estate-llc
 website_shortwww.sunvalleyrealestate.com
 name_with_locationSun Valley Real Estate, LLC
 Image(array)
 id2973
 modelLocation
 model_id44
 tagImage
 nameSun Valley.jpg
 typeimage/jpeg
 size292013
 uri/assets/2973.jpg
 order0
 created2016-04-04 12:46:15
 modified2016-04-04 12:46:21
- highlighted_properties(array)
 0(array)
 Property(array)
 id2309
 brokerage_id204
 created_by_user_id0
 order2
 multi_unit(false)
 agent_1_id645
 agent_2_id0
 agent_3_id0
 nameSummit Estate on 214 acres
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(true)
 large_featured(true)
 detail_page(true)
 descriptionThe community of Sun Valley, at an altitude of 5,750 feet, has been considered one of the most highly regarded alpine ski resorts in America since 1936, when the first ski lift in North America was built there. Located above the exclusive neighborhood of Gimlet, just a few minutes south of Ketchum, this expansive 214-acre estate sits atop a mountain, overlooking gorgeous Bald Mountain and beyond. This one-of-a-kind private sanctuary is Sun Valley's most exclusive property and is ideal for the ski enthusiast and nature lover, with miles of private hiking trails and abundant native wildlife. This magnificent home includes, among other amenities, a spacious and welcoming main house, a large two-bedroom detached guesthouse, a separate caretaker's quarters, and a heated driveway. The estate is notable because it is completely sheltered from neighboring properties for ultimate privacy and solitude, and its guest facilities and ample bedrooms make it ideal for entertaining year-round. Only a 10-minute drive to the ski resort, the estate is also close to the thriving community of Sun Valley and its host of galleries, shops, film festivals, and concerts. Modern construction and multiple outdoor patio areas enhance the home's livability in both winter and summer seasons. 10,072-square-foot residence on 214 acres. Six bedrooms and seven and a half bathrooms. Paver patios off dining room, den and living rooms. Large heated paver driveway. Three-car garage at main house and two-car garage at guesthouse. $10,000,000 Call Suzanne Williams 208 720 3951 Sun Valley Real Estate LLC Christie's International Real Estate 300 N. Main St Ketchum Idaho 83340
 address89 Gimlet Road
 address_2
 cityKetchum
 stateID
 postal_code83340
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price10000000
 price_20
 price_usd10000000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms7
 bedrooms_20
 bathrooms7
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres214
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size214
 icon_1acreage
 icon_2views
 icon_3guest-house
 icon_4office
 icon_5library
 icon_6
 websitehttp://www.suzannewilliams.com
 meta_titleSummit Estate on 214 acres | Ketchum Real Estate | Sun Valley Real Estate, LLC
 meta_description89 Gimlet Road is a property offered for sale in Ketchum , ID, USA, presented by Sun Valley Real Estate, LLC
 meta_keywords
 bathrooms_partial2
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttps://www.youtube.com/watch?v=NZKiy_TX1Ac
 video_tourhttps://www.youtube.com/watch?v=NZKiy_TX1Ac
 digital_brochure
 video_tour_embed_code<iframe width="560" height="315" src="https://www.youtube.com/embed/NZKiy_TX1Ac?controls=0&showinfo=0" frameborder="0" allowfullscreen></iframe>
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldsagent_name_1, agent_email_1, latitude, longitude
 invalid_optional_fieldssquare_feet, square_meters, hectares, agent_phone_1, agent_name_2, agent_email_2, agent_phone_2, year_built, wsj_property_type, nyt_property_type
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-06-15 08:35:55
 uri/property-detail/2309/89-gimlet-road-ketchum-id-83340-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2309/89-gimlet-road-ketchum-id-83340-usa
 address_concat89 Gimlet Road Ketchum ID 83340 USA
 google_maps_query_string89+Gimlet+Road++Ketchum++ID+83340+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 10,000,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty7
 bathrooms_pretty7
 bathrooms_partial_pretty2
 bathrooms_3_4_pretty0
 feed_full_bathrooms7
 date_listed2015-06-15
 overridden_brokerage_nameSun Valley Real Estate, LLC
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id204
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2501907
 timezoneUS/Mountain
 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
 nameSun Valley Real Estate, LLC
 broker_of_record_name
 short_nameSun Valley Real Estate, LLC
 usernameSunValleyRE
 passwordc6f87f8b4bf4831cf667fad365f356cab2e29afc
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionSun Valley Real Estate, LLC is the exclusive representative for Leverage Global Partners in Sun Valley and Ketchum, Idaho, USA. Sun Valley Real Estate, LLC/Christie’s International Real Estate is an independently owned brokerage with fifteen brokers and agents dedicated to providing the highest level of professional real estate service to their clients. Agents are experts in Wood River Valley real estate and represent both Buyers and Sellers with complete market knowledge. As the Exclusive Affiliate of Christie’s International Real Estate, Sun Valley Real Estate enjoys access to a global network that is supported by the esteemed auction house. Our network offers exclusive homes to buyers worldwide, and by focusing on luxury residential real estate, we know best how to reach and serve a discerning clientele. The Christie’s brand is instantly recognizable and distinguishes our properties from others.
 communitiesSun Valley Ketchum
 websitehttp://www.sunvalleyrealestate.com/
 address300 North Main Street
 address_2
 cityKetchum
 stateID
 full_stateIdaho
 countryUSA
 marketSun Valley
 market_2
 postal_code83340
 phone(208) 726 6000
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameThe Team at Sun Valley Real Estate, LLC
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwners and Real Estate Professionals
 contact_dre_num
 contact_quoteWe invite you to contact us about Sun Valley real estate
 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_filename204.jpg
 logo_filename204.jpg
 contact_image_filename204.jpeg
 all_properties_link_image_filename204.jpg
 all_properties_linkhttp://www.christiesrealestate.com/eng/sales/ketchum-id-usa
 video_embed_code
 contact_video_embed_code
 meta_titleSun Valley Real Estate | Sun Valley Real Estate, LLC | Leverage Global Partners
 meta_descriptionSun Valley Real Estate, LLC is the exclusive representative for Leverage Global Partners in Sun Valley and Ketchum, Idaho, USA
 meta_keywordsSun Valley Real Estate, LLC, Leverage Global Partners, Sun Valley Real Estate, Ketchum Real Estate, Idaho Real Estate, Suzanne Williams
 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)
 created2015-05-22 10:48:20
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/204/sun-valley-real-estate-llc
 website_shortwww.sunvalleyrealestate.com
 name_with_locationSun Valley Real Estate, LLC
 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)
 id15184
 modelProperty
 model_id2309
 tagImage
 name21392.jpg
 typeimage/jpg
 size619562
 uri/assets/15184.jpg
 order0
 created2016-04-07 16:50:08
 modified2016-04-07 16:50:08
 1(array)
 id15185
 modelProperty
 model_id2309
 tagImage
 name21393.jpg
 typeimage/jpg
 size557111
 uri/assets/15185.jpg
 order1
 created2016-04-07 16:50:08
 modified2016-04-07 16:50:08
 2(array)
 id15186
 modelProperty
 model_id2309
 tagImage
 name21394.jpg
 typeimage/jpg
 size427342
 uri/assets/15186.jpg
 order2
 created2016-04-07 16:50:08
 modified2016-04-07 16:50:08
 3(array)
 id15187
 modelProperty
 model_id2309
 tagImage
 name21395.jpg
 typeimage/jpg
 size402218
 uri/assets/15187.jpg
 order3
 created2016-04-07 16:50:08
 modified2016-04-07 16:50:08
 4(array)
 id15188
 modelProperty
 model_id2309
 tagImage
 name21396.jpg
 typeimage/jpg
 size413706
 uri/assets/15188.jpg
 order4
 created2016-04-07 16:50:08
 modified2016-04-07 16:50:08
 5(array)
 id15189
 modelProperty
 model_id2309
 tagImage
 name21397.jpg
 typeimage/jpg
 size371504
 uri/assets/15189.jpg
 order5
 created2016-04-07 16:50:08
 modified2016-04-07 16:50:08
 6(array)
 id15191
 modelProperty
 model_id2309
 tagImage
 name21399.jpg
 typeimage/jpg
 size381337
 uri/assets/15191.jpg
 order6
 created2016-04-07 16:50:08
 modified2016-04-07 16:50:08
 7(array)
 id15190
 modelProperty
 model_id2309
 tagImage
 name21398.jpg
 typeimage/jpg
 size231280
 uri/assets/15190.jpg
 order7
 created2016-04-07 16:50:08
 modified2016-04-07 16:50:08
 8(array)
 id15192
 modelProperty
 model_id2309
 tagImage
 name21400.jpg
 typeimage/jpg
 size563913
 uri/assets/15192.jpg
 order8
 created2016-04-07 16:50:08
 modified2016-04-07 16:50:08
 9(array)
 id15193
 modelProperty
 model_id2309
 tagImage
 name21401.jpg
 typeimage/jpg
 size639489
 uri/assets/15193.jpg
 order9
 created2016-04-07 16:50:08
 modified2016-04-07 16:50:08
 User(array)
 0(array)
 id842
 typeAgent
 brokerage_id204
 email[email protected]
 passwordf3f948148dbef39a47d40eadb3ed23e05f99b0c1
 recover_hash
 first_nameSuzanne
 last_nameWilliams
 title
 dre_num
 phone208 720 3951
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:40
 created2017-08-07 15:23:40
 notified(false)
 full_nameSuzanne Williams
 uri/agent-detail/842/suzanne-williams
 profile_complete(true)
 UsersProperty(array)
 id598
 user_id842
 property_id2309
 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)
 id3074
 property_id2309
 property_feature_id14
 1(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id3075
 property_id2309
 property_feature_id5
 2(array)
 id9
 nameOffice
 additional(false)
 created2016-04-07 14:03:21
 modified2016-04-07 14:03:21
 PropertiesPropertyFeature(array)
 id3076
 property_id2309
 property_feature_id9
 Topic(empty)
 1(array)
 Property(array)
 id2253
 brokerage_id204
 created_by_user_id0
 order1
 multi_unit(false)
 agent_1_id645
 agent_2_id0
 agent_3_id0
 nameSerenity Lodge
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionSerenity Lodge in Sun Valley Idaho provides a quiet retreat moments from downtown Ketchum. Located in the hills just north of Ketchum this elevated property boasts 360 degree mountain views. Constructed with an unrivaled level of luxury, the residence spans three levels of intimate spaces featuring beamed ceilings; custom millwork and cabinetry; reclaimed oak floors; a Schindler elevator and Loewen windows and doors. The beautifully maintained 4.5 acre parcel features a heated paver driveway and two waterfalls that gently flow on either side of the residence. The main level includes gourmet kitchen, formal dining and living rooms, spacious master suite and two guest suites. A separate two bedroom, two bath guest or staff apartment located off the 9 car garage is entirely independent. The second floor has its own kitchen, media room, gym, 1400 bottle wine cellar, sauna, massage room and abundant secured storage.
 address140 Telemark
 address_2
 cityKetchum
 stateID
 postal_code83340
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price16900000
 price_20
 price_usd16900000
 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
 bathrooms8
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1views
 icon_2garage
 icon_3guest-house
 icon_4cellar
 icon_5balcony-terrace
 icon_6
 websitehttp://www.suzannewilliams.com/property/serenity-lodge/
 meta_titleSerenity Lodge | Ketchum Real Estate | Sun Valley Real Estate, LLC
 meta_description140 Telemark is a property offered for sale in Ketchum, ID, USA, presented by Sun Valley Real Estate, LLC
 meta_keywords
 bathrooms_partial2
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tourhttps://youtu.be/Y4JQUsaGhg8
 digital_brochure
 video_tour_embed_code<iframe width="560" height="315" src="https://www.youtube.com/embed/Y4JQUsaGhg8?controls=0&showinfo=0" frameborder="0" allowfullscreen></iframe>
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_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-03 05:58:24
 uri/property-detail/2253/140-telemark-ketchum-id-83340-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2253/140-telemark-ketchum-id-83340-usa
 address_concat140 Telemark Ketchum ID 83340 USA
 google_maps_query_string140+Telemark++Ketchum+ID+83340+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 16,900,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty8
 bathrooms_partial_pretty2
 bathrooms_3_4_pretty0
 feed_full_bathrooms8
 date_listed2015-06-03
 overridden_brokerage_nameSun Valley Real Estate, LLC
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id204
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2501907
 timezoneUS/Mountain
 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
 nameSun Valley Real Estate, LLC
 broker_of_record_name
 short_nameSun Valley Real Estate, LLC
 usernameSunValleyRE
 passwordc6f87f8b4bf4831cf667fad365f356cab2e29afc
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionSun Valley Real Estate, LLC is the exclusive representative for Leverage Global Partners in Sun Valley and Ketchum, Idaho, USA. Sun Valley Real Estate, LLC/Christie’s International Real Estate is an independently owned brokerage with fifteen brokers and agents dedicated to providing the highest level of professional real estate service to their clients. Agents are experts in Wood River Valley real estate and represent both Buyers and Sellers with complete market knowledge. As the Exclusive Affiliate of Christie’s International Real Estate, Sun Valley Real Estate enjoys access to a global network that is supported by the esteemed auction house. Our network offers exclusive homes to buyers worldwide, and by focusing on luxury residential real estate, we know best how to reach and serve a discerning clientele. The Christie’s brand is instantly recognizable and distinguishes our properties from others.
 communitiesSun Valley Ketchum
 websitehttp://www.sunvalleyrealestate.com/
 address300 North Main Street
 address_2
 cityKetchum
 stateID
 full_stateIdaho
 countryUSA
 marketSun Valley
 market_2
 postal_code83340
 phone(208) 726 6000
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameThe Team at Sun Valley Real Estate, LLC
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwners and Real Estate Professionals
 contact_dre_num
 contact_quoteWe invite you to contact us about Sun Valley real estate
 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_filename204.jpg
 logo_filename204.jpg
 contact_image_filename204.jpeg
 all_properties_link_image_filename204.jpg
 all_properties_linkhttp://www.christiesrealestate.com/eng/sales/ketchum-id-usa
 video_embed_code
 contact_video_embed_code
 meta_titleSun Valley Real Estate | Sun Valley Real Estate, LLC | Leverage Global Partners
 meta_descriptionSun Valley Real Estate, LLC is the exclusive representative for Leverage Global Partners in Sun Valley and Ketchum, Idaho, USA
 meta_keywordsSun Valley Real Estate, LLC, Leverage Global Partners, Sun Valley Real Estate, Ketchum Real Estate, Idaho Real Estate, Suzanne Williams
 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)
 created2015-05-22 10:48:20
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/204/sun-valley-real-estate-llc
 website_shortwww.sunvalleyrealestate.com
 name_with_locationSun Valley Real Estate, LLC
 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)
 id15020
 modelProperty
 model_id2253
 tagImage
 name20821.jpg
 typeimage/jpg
 size619274
 uri/assets/15020.jpg
 order0
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 1(array)
 id15012
 modelProperty
 model_id2253
 tagImage
 name20813.jpg
 typeimage/jpg
 size770721
 uri/assets/15012.jpg
 order1
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 2(array)
 id15013
 modelProperty
 model_id2253
 tagImage
 name20814.jpg
 typeimage/jpg
 size417218
 uri/assets/15013.jpg
 order2
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 3(array)
 id15014
 modelProperty
 model_id2253
 tagImage
 name20815.jpg
 typeimage/jpg
 size578171
 uri/assets/15014.jpg
 order3
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 4(array)
 id15021
 modelProperty
 model_id2253
 tagImage
 name20822.jpg
 typeimage/jpg
 size456983
 uri/assets/15021.jpg
 order4
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 5(array)
 id15016
 modelProperty
 model_id2253
 tagImage
 name20817.jpg
 typeimage/jpg
 size454691
 uri/assets/15016.jpg
 order5
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 6(array)
 id15018
 modelProperty
 model_id2253
 tagImage
 name20819.jpg
 typeimage/jpg
 size396654
 uri/assets/15018.jpg
 order6
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 7(array)
 id15019
 modelProperty
 model_id2253
 tagImage
 name20820.jpg
 typeimage/jpg
 size385350
 uri/assets/15019.jpg
 order7
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 8(array)
 id15017
 modelProperty
 model_id2253
 tagImage
 name20818.jpg
 typeimage/jpg
 size509655
 uri/assets/15017.jpg
 order8
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 9(array)
 id15015
 modelProperty
 model_id2253
 tagImage
 name20816.jpg
 typeimage/jpg
 size262280
 uri/assets/15015.jpg
 order9
 created2016-04-07 16:49:04
 modified2016-04-07 16:49:04
 User(array)
 0(array)
 id842
 typeAgent
 brokerage_id204
 email[email protected]
 passwordf3f948148dbef39a47d40eadb3ed23e05f99b0c1
 recover_hash
 first_nameSuzanne
 last_nameWilliams
 title
 dre_num
 phone208 720 3951
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:40
 created2017-08-07 15:23:40
 notified(false)
 full_nameSuzanne Williams
 uri/agent-detail/842/suzanne-williams
 profile_complete(true)
 UsersProperty(array)
 id597
 user_id842
 property_id2253
 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)
 id3022
 property_id2253
 property_feature_id14
 1(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id3023
 property_id2253
 property_feature_id4
 2(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id3024
 property_id2253
 property_feature_id5
 3(array)
 id18
 nameWine Cellar
 additional(false)
 created2016-04-07 14:06:17
 modified2016-04-07 14:06:17
 PropertiesPropertyFeature(array)
 id3025
 property_id2253
 property_feature_id18
 4(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id3026
 property_id2253
 property_feature_id1
 Topic(empty)
- custom_ga_event_properties(array)
 brokerageSun Valley Real Estate, LLC, Ketchum
- property(array)
 Property(array)
 id3117
 brokerage_id204
 created_by_user_id0
 order4
 multi_unit(false)
 agent_1_id928
 agent_2_id0
 agent_3_id0
 nameMountain Castle
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionThis Log Lodge on 8.5 acres is perfect for large gatherings or corporate retreats. Comfortable separate living spaces can accommodate up to 30 people in luxury. RAmenities include 3 offices, huge spa/gym, wine cellar,gun room, spacious yard, horse facilities. The Valley Club is across the street, skiing just 8 minutes away.
 address 3671 Buttercup Rd
 address_2
 cityHailey
 stateID
 postal_code83333
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price5000000
 price_20
 price_usd5000000
 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)
 bedrooms11
 bedrooms_20
 bathrooms12
 bathrooms_20
 no_beds_baths(false)
 square_feet15000
 square_meters
 acres8
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size8
 icon_1sq-ft
 icon_2media-room
 icon_3gym
 icon_4library
 icon_5cellar
 icon_6
 website
 meta_titleMountain Castle | Hailey Real Estate | Sun Valley Real Estate, LLC
 meta_description 3671 Buttercup Rd is a property offered for sale in Hailey, ID, USA, presented by Sun Valley Real Estate, LLC
 meta_keywords
 bathrooms_partial4
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_meters, hectares, year_built, virtual_tour, video_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2015-11-19 20:50:53
 uri/property-detail/3117/3671-buttercup-rd-hailey-id-83333-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3117/3671-buttercup-rd-hailey-id-83333-usa
 address_concat 3671 Buttercup Rd Hailey ID 83333 USA
 google_maps_query_string+3671+Buttercup+Rd++Hailey+ID+83333+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 5,000,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty11
 bathrooms_pretty12
 bathrooms_partial_pretty4
 bathrooms_3_4_pretty0
 feed_full_bathrooms12
 date_listed2015-11-19
 overridden_brokerage_nameSun Valley Real Estate, LLC
 overridden_brokerage_logo_uri/assets/2317.jpg
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id204
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2501907
 timezoneUS/Mountain
 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
 nameSun Valley Real Estate, LLC
 broker_of_record_name
 short_nameSun Valley Real Estate, LLC
 usernameSunValleyRE
 passwordc6f87f8b4bf4831cf667fad365f356cab2e29afc
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionSun Valley Real Estate, LLC is the exclusive representative for Leverage Global Partners in Sun Valley and Ketchum, Idaho, USA. Sun Valley Real Estate, LLC/Christie’s International Real Estate is an independently owned brokerage with fifteen brokers and agents dedicated to providing the highest level of professional real estate service to their clients. Agents are experts in Wood River Valley real estate and represent both Buyers and Sellers with complete market knowledge. As the Exclusive Affiliate of Christie’s International Real Estate, Sun Valley Real Estate enjoys access to a global network that is supported by the esteemed auction house. Our network offers exclusive homes to buyers worldwide, and by focusing on luxury residential real estate, we know best how to reach and serve a discerning clientele. The Christie’s brand is instantly recognizable and distinguishes our properties from others.
 communitiesSun Valley Ketchum
 websitehttp://www.sunvalleyrealestate.com/
 address300 North Main Street
 address_2
 cityKetchum
 stateID
 full_stateIdaho
 countryUSA
 marketSun Valley
 market_2
 postal_code83340
 phone(208) 726 6000
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameThe Team at Sun Valley Real Estate, LLC
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwners and Real Estate Professionals
 contact_dre_num
 contact_quoteWe invite you to contact us about Sun Valley real estate
 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_filename204.jpg
 logo_filename204.jpg
 contact_image_filename204.jpeg
 all_properties_link_image_filename204.jpg
 all_properties_linkhttp://www.christiesrealestate.com/eng/sales/ketchum-id-usa
 video_embed_code
 contact_video_embed_code
 meta_titleSun Valley Real Estate | Sun Valley Real Estate, LLC | Leverage Global Partners
 meta_descriptionSun Valley Real Estate, LLC is the exclusive representative for Leverage Global Partners in Sun Valley and Ketchum, Idaho, USA
 meta_keywordsSun Valley Real Estate, LLC, Leverage Global Partners, Sun Valley Real Estate, Ketchum Real Estate, Idaho Real Estate, Suzanne Williams
 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)
 created2015-05-22 10:48:20
 modified2016-04-08 16:33:22
 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)
 id2317
 modelBrokerage
 model_id204
 tagLogo
 name204.jpg
 typeimage/jpg
 size315652
 uri/assets/2317.jpg
 order0
 created2016-03-30 11:37:34
 modified2016-03-30 11:37:34
 MainImage(array)
 id2316
 modelBrokerage
 model_id204
 tagMainImage
 name204.jpg
 typeimage/jpg
 size14304678
 uri/assets/2316.jpg
 order0
 created2016-03-30 11:37:32
 modified2016-03-30 11:37:32
 ContactImage(array)
 id2318
 modelBrokerage
 model_id204
 tagContactImage
 name204.jpeg
 typeimage/jpeg
 size138813
 uri/assets/2318.jpeg
 order0
 created2016-03-30 11:37:34
 modified2016-03-30 11:37:34
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 FeaturedImage(empty)
 Location(array)
 0(array)
 id44
 parent_id9
 brokerage_id204
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameSun Valley, ID, USA
 short_nameSun Valley, ID, USA
 group_index
 latitude43.697128
 longitude-114.351715
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 12:46:21
 modified2016-04-04 12:46:21
 timezoneAmerica/Boise
 population1500
 uri/locations/view/44/sun-valley-id-usa
 tile_nameSun Valley, ID, USA
 User(array)
 0(array)
 id80
 typeBrokerageAdmin
 brokerage_id204
 email[email protected]
 passwordc6f87f8b4bf4831cf667fad365f356cab2e29afc
 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:26:07
 created2016-04-08 16:33:22
 notified(true)
 full_name
 uri/agent-detail/80/
 profile_complete(false)
 1(array)
 id842
 typeAgent
 brokerage_id204
 email[email protected]
 passwordf3f948148dbef39a47d40eadb3ed23e05f99b0c1
 recover_hash
 first_nameSuzanne
 last_nameWilliams
 title
 dre_num
 phone208 720 3951
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:40
 created2017-08-07 15:23:40
 notified(false)
 full_nameSuzanne Williams
 uri/agent-detail/842/suzanne-williams
 profile_complete(true)
 2(array)
 id1124
 typeAgent
 brokerage_id204
 email[email protected]
 password1e425e7b4d20532b4e89bf88dbb217911822d4df
 recover_hash
 first_nameBrad
 last_nameDufur
 title
 dre_num
 phone208 726 6000
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:55
 created2017-08-07 15:23:55
 notified(false)
 full_nameBrad Dufur
 uri/agent-detail/1124/brad-dufur
 profile_complete(true)
 uri/brokerage-detail/204/sun-valley-real-estate-llc
 website_shortwww.sunvalleyrealestate.com
 name_with_locationSun Valley Real Estate, LLC - Sun Valley, ID, 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)
 id18167
 modelProperty
 model_id3117
 tagImage
 name29941.jpg
 typeimage/jpg
 size741991
 uri/assets/18167.jpg
 order0
 created2016-04-07 17:08:07
 modified2016-04-07 17:08:07
 1(array)
 id18168
 modelProperty
 model_id3117
 tagImage
 name29945.jpg
 typeimage/jpg
 size1732465
 uri/assets/18168.jpg
 order1
 created2016-04-07 17:08:07
 modified2016-04-07 17:08:07
 2(array)
 id18172
 modelProperty
 model_id3117
 tagImage
 name29946.jpg
 typeimage/jpg
 size1635762
 uri/assets/18172.jpg
 order2
 created2016-04-07 17:08:07
 modified2016-04-07 17:08:07
 3(array)
 id18171
 modelProperty
 model_id3117
 tagImage
 name29944.jpg
 typeimage/jpg
 size1601409
 uri/assets/18171.jpg
 order3
 created2016-04-07 17:08:07
 modified2016-04-07 17:08:07
 4(array)
 id18174
 modelProperty
 model_id3117
 tagImage
 name29948.jpg
 typeimage/jpg
 size1958318
 uri/assets/18174.jpg
 order4
 created2016-04-07 17:08:07
 modified2016-04-07 17:08:08
 5(array)
 id18173
 modelProperty
 model_id3117
 tagImage
 name29947.jpg
 typeimage/jpg
 size1499655
 uri/assets/18173.jpg
 order5
 created2016-04-07 17:08:07
 modified2016-04-07 17:08:07
 6(array)
 id18170
 modelProperty
 model_id3117
 tagImage
 name29943.jpg
 typeimage/jpg
 size1577161
 uri/assets/18170.jpg
 order6
 created2016-04-07 17:08:07
 modified2016-04-07 17:08:07
 7(array)
 id18175
 modelProperty
 model_id3117
 tagImage
 name29949.jpg
 typeimage/jpg
 size1681192
 uri/assets/18175.jpg
 order7
 created2016-04-07 17:08:08
 modified2016-04-07 17:08:08
 8(array)
 id18176
 modelProperty
 model_id3117
 tagImage
 name29950.jpg
 typeimage/jpg
 size1677208
 uri/assets/18176.jpg
 order8
 created2016-04-07 17:08:08
 modified2016-04-07 17:08:08
 9(array)
 id18169
 modelProperty
 model_id3117
 tagImage
 name29942.jpg
 typeimage/jpg
 size1580428
 uri/assets/18169.jpg
 order9
 created2016-04-07 17:08:07
 modified2016-04-07 17:08:07
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id8
 nameMedia Room
 additional(false)
 created2016-04-07 14:03:04
 modified2016-04-07 14:03:04
 PropertiesPropertyFeature(array)
 id3830
 property_id3117
 property_feature_id8
 Icon(array)
 id3557
 modelPropertyFeature
 model_id8
 tagIcon
 name136.png
 typeimage/png
 size3481
 uri/assets/3557.png
 order0
 created2016-04-07 14:03:03
 modified2016-04-07 14:03:04
 1(array)
 id6
 nameGym
 additional(false)
 created2016-04-07 14:02:29
 modified2016-04-07 14:02:29
 PropertiesPropertyFeature(array)
 id3831
 property_id3117
 property_feature_id6
 Icon(array)
 id3555
 modelPropertyFeature
 model_id6
 tagIcon
 name134.png
 typeimage/png
 size2249
 uri/assets/3555.png
 order0
 created2016-04-07 14:02:28
 modified2016-04-07 14:02:29
 2(array)
 id18
 nameWine Cellar
 additional(false)
 created2016-04-07 14:06:17
 modified2016-04-07 14:06:17
 PropertiesPropertyFeature(array)
 id3832
 property_id3117
 property_feature_id18
 Icon(array)
 id3567
 modelPropertyFeature
 model_id18
 tagIcon
 name146.png
 typeimage/png
 size1944
 uri/assets/3567.png
 order0
 created2016-04-07 14:06:14
 modified2016-04-07 14:06:17
 Topic(empty)
- membership_subscription_temp_allowed_login(null)
- newsletter_member_types(array)
 Leverage Member: AgentLeverage Member: Agent
 Leverage Member: Broker or ManagementLeverage Member: Broker or Management
 Non-MemberNon-Member
- $request->data(empty)
- $this->validationErrors(array)
 Subscription(empty)
 Property(empty)
 User(empty)
 PropertyFeature(empty)
 SecondaryPropertyCategory(empty)
 Topic(empty)
 PrimaryPropertyCategory(empty)
 Brokerage(empty)
 StripeSubscription(empty)
 GlobalReachReport(empty)
 AccountExecutive(empty)
 Logo(empty)
 MainImage(empty)
 ContactImage(empty)
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 Location(empty)
 FeaturedImage(empty)
 Image(empty)
 UsersProperty(empty)
 PropertiesSecondaryPropertyCategory(empty)
 PropertiesPropertyFeature(empty)
 Icon(empty)
 PropertiesTopic(empty)
- Loaded Helpers(array)
 0Permission
 1Number
 2SimpleGraph
 3DebugTimer
 4Toolbar
 5Session
 6Text
 7Flash
 8HtmlToolbar
 9Html
 10Form
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	7.4.33
User	leveragere
Home	/var/www/vhosts/leveragere.com
Script Name	/index.php
Request Uri	/property-detail/3117/3671-buttercup-rd-hailey-id-83333-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/property-detail/3117/3671-buttercup-rd-hailey-id-83333-usa
Remote Port	20610
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.115
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	a09db51cac1a2a9c-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	aioyzO8a9lJ8yShPtH3GEwAAAtc
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	aioyzO8a9lJ8yShPtH3GEwAAAtc
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781150412.368
Request Time	1781150412

====

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

Mountain Castle

Represented By: Sun Valley Real Estate, LLC

Highlighted Properties

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 18 ms Total Queries: 33 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 18 ms
Total Queries: 33 queries