Properties /

MAGNIFICENT MOUNTAIN RESORT

291 Whitewater Drive | Tamarack, Idaho 83615, USA | $2,390,000

5 Beds
6 Baths
1 Half Ba
Guest House
Office
Views
Ski In/Ski Out
Balcony/Terrace

Located at Tamarack Resort, this Majestic Mountain Masterpiece has a total of 4 bedrooms and 5.5 baths and allows plenty of room for a large group. With panoramic views from every room and immediate access to ski out and ski in trails, this home is ideal for elegant family living or a corporate retreat. The dramatic hardwood entry leads to the main living area with towering windows overlooking the resort. The elevated kitchen is a Chef’s dreams with stunning adjoining native stonewall centerpiece and spacious dining area. Elegant lighting fixtures and finishes throughout. The main home has four luxurious bedroom suites each with private bath and built in hardwood cabinets and custom granite. The lower level great room with radiant floor heat and large custom stone fireplace has additional areas for game room or wine storage. A covered walk leads to the elegantly appointed 1 bedroom, 1 bath, full kitchen and living room guest apartment over the triple car garage.

Represented By: Community Real Estate Company

community-realestate.com | License #: 012345

Margo Flaherty
208-271-6150
Email

Main Office: 401 S. 3rd Street
McCall, ID 83638
USA

More About Margo

community-realestate.com | License #: 012345

Becky Martinson
208-315-0656
Email

Main Office: 401 S. 3rd Street
McCall, ID 83638
USA

More About Becky

View On Map

Highlighted Properties

One of a Kind Lake Access Property

1519 McCall Ave. | McCall, Idaho 83638
$1,200,000

Kings Pines III 360 Degree Views

1423 Club Hill Blvd | McCall, Idaho 83638
$2,400,000

Represented By

Agent Contacts: Margo Flaherty 208-271-6150 | Email; Becky Martinson 208-315-0656 | Email

Featured Location

McCall, ID, USA

Related Property Listings

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

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

Cake Params
- plugin(null)
- controllerproperties
- actionview
- named(empty)
- pass(array)
  02809
  1291-whitewater-drive-tamarack-idaho-83615-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: 14 ms
Total Queries: 41 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` = 2809 AND `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`incomplete` = '0' LIMIT 1	1	1	4	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` = 222 AND `Logo`.`model` = 'Brokerage' AND `Logo`.`tag` = 'Logo'	1	1	0
SELECT `MainImage`.`id`, `MainImage`.`model`, `MainImage`.`model_id`, `MainImage`.`tag`, `MainImage`.`name`, `MainImage`.`type`, `MainImage`.`size`, `MainImage`.`uri`, `MainImage`.`order`, `MainImage`.`created`, `MainImage`.`modified` FROM `leveragere_staging2`.`assets` AS `MainImage` WHERE `MainImage`.`model_id` = 222 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` = 222 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` = 222 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` = 222 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` = 222 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` = 222 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` = (222) 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` = (222)	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` = (222)	7	7	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` = (2809) 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` = 2809 AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	2	2	2
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` WHERE `Brokerage`.`id` = 222	1	1	0
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` WHERE `Brokerage`.`id` = 222	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model_id` = 1086 AND `Image`.`model` = 'User' AND `Image`.`tag` = 'Image'	0	0	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model_id` = 1087 AND `Image`.`model` = 'User' AND `Image`.`tag` = 'Image'	0	0	0
SELECT `BrokerageLogoOverride`.`id`, `BrokerageLogoOverride`.`model`, `BrokerageLogoOverride`.`model_id`, `BrokerageLogoOverride`.`tag`, `BrokerageLogoOverride`.`name`, `BrokerageLogoOverride`.`type`, `BrokerageLogoOverride`.`size`, `BrokerageLogoOverride`.`uri`, `BrokerageLogoOverride`.`order`, `BrokerageLogoOverride`.`created`, `BrokerageLogoOverride`.`modified` FROM `leveragere_staging2`.`assets` AS `BrokerageLogoOverride` WHERE `BrokerageLogoOverride`.`model_id` = 1086 AND `BrokerageLogoOverride`.`model` = 'User' AND `BrokerageLogoOverride`.`tag` = 'BrokerageLogoOverride'	0	0	0
SELECT `BrokerageLogoOverride`.`id`, `BrokerageLogoOverride`.`model`, `BrokerageLogoOverride`.`model_id`, `BrokerageLogoOverride`.`tag`, `BrokerageLogoOverride`.`name`, `BrokerageLogoOverride`.`type`, `BrokerageLogoOverride`.`size`, `BrokerageLogoOverride`.`uri`, `BrokerageLogoOverride`.`order`, `BrokerageLogoOverride`.`created`, `BrokerageLogoOverride`.`modified` FROM `leveragere_staging2`.`assets` AS `BrokerageLogoOverride` WHERE `BrokerageLogoOverride`.`model_id` = 1087 AND `BrokerageLogoOverride`.`model` = 'User' AND `BrokerageLogoOverride`.`tag` = 'BrokerageLogoOverride'	0	0	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` = 2809 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` = 2809 AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	5	5	0
SELECT `Icon`.`id`, `Icon`.`model`, `Icon`.`model_id`, `Icon`.`tag`, `Icon`.`name`, `Icon`.`type`, `Icon`.`size`, `Icon`.`uri`, `Icon`.`order`, `Icon`.`created`, `Icon`.`modified` FROM `leveragere_staging2`.`assets` AS `Icon` WHERE `Icon`.`model_id` = 5 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	0
SELECT `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` = 9 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` = 14 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	0
SELECT `Icon`.`id`, `Icon`.`model`, `Icon`.`model_id`, `Icon`.`tag`, `Icon`.`name`, `Icon`.`type`, `Icon`.`size`, `Icon`.`uri`, `Icon`.`order`, `Icon`.`created`, `Icon`.`modified` FROM `leveragere_staging2`.`assets` AS `Icon` WHERE `Icon`.`model_id` = 11 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` = 1 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` = 2809 AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	2	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` != 2809 AND `Property`.`brokerage_id` = 222 AND `Property`.`status` != 'Sold' AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 2	2	2	2
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (3395, 2864) ORDER BY `Image`.`order` ASC	18	18	0
SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (3395, 2864) 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 (3395, 2864) 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 (3395, 2864) 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 (3395, 2864) 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` = 222 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` = 222 AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	2	maybe slow
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (2834, 2807, 3395, 2864) ORDER BY `Image`.`order` ASC	38	38	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 (2834, 2807, 3395, 2864) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	3	3	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 (2834, 2807, 3395, 2864) 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 (2834, 2807, 3395, 2864) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	13	13	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 (2834, 2807, 3395, 2864) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	0

1 duplicate queries run.

Query Explain:

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

====

Timer

Memory

Peak Memory Use 14.31 MB

Message	Memory use
Component initialization	3.09 MB
Controller action start	4.02 MB
Controller render start	6.94 MB
View render complete	7.46 MB

Timers

Total Request Time: 212 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	29.91
Event: Controller.initialize	3.86
Event: Controller.startup	1.17
Controller action	47.00
Event: Controller.beforeRender	15.41
» Processing toolbar data	15.32
Rendering View	82.03
» Event: View.beforeRender	0.27
» Rendering APP/View/Properties/view.ctp	3.16
» » Rendering APP/View/Elements/static_property_price.ctp	0.37
» » Rendering APP/View/Elements/property_features.ctp	0.22
» » Rendering APP/View/Elements/static_property_price.ctp #2	0.15
» » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.14
» » Rendering APP/View/Elements/sidebar/property_list.ctp	0.96
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #5	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #6	0.13
» » » Rendering APP/View/Elements/static_property_price.ctp #7	0.13
» » 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	77.87
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)
 id2834
 brokerage_id222
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id927
 agent_2_id0
 agent_3_id0
 nameMAGNIFICENT CUSTOM HOME
 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)
 descriptionThe open floor plan; 2 Master Suites on the main level; large south facing outdoor patio and Energy efficient features make this residence a great place for everyday living or second home. The Whitetail Development is fast becoming the Premier All Season Private Club of the Pacific Northwest offering countless amenities including Indoor/ outdoor Tennis facilities; Fish & Swim Club; private boat mooring; over 300 feet of private Payette Lake frontage accessible to Members only; State of the Art Spa facilities; Nordic ski trails..
 address361 Whitetail Drive
 address_2
 cityMcCall
 stateIdaho
 postal_code83638
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1845000
 price_20
 price_usd1845000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1library
 icon_2balcony-terrace
 icon_3pool
 icon_4
 icon_5
 icon_6
 website
 meta_titleMAGNIFICENT CUSTOM HOME | McCall Real Estate | Community Real Estate Company
 meta_description361 Whitetail Drive is a property offered for sale in McCall, Idaho, USA, presented by Community Real Estate Company
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, year_built, virtual_tour, video_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-09-30 15:29:59
 uri/property-detail/2834/361-whitetail-drive-mccall-idaho-83638-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2834/361-whitetail-drive-mccall-idaho-83638-usa
 address_concat361 Whitetail Drive McCall Idaho 83638 USA
 google_maps_query_string361+Whitetail+Drive++McCall+Idaho+83638+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,845,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty3
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2015-09-30
 overridden_brokerage_nameCommunity Real Estate Company
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id222
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 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
 WOEID2447519
 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
 nameCommunity Real Estate Company
 broker_of_record_name
 short_nameCommunity Real Estate Company
 usernamecommunityREcompany
 password5fc7818eec49c5d2c06f0a8a34561dee0b9a2d16
 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
 descriptionCommunity Real Estate Company is the exclusive representative for Leverage Global Partners in McCall, Donnelly, Cascade, Meadows, New Meadows, Lake Fork, Tamarack, and Pine Ridge, ID, USA. In our own little way Community Real Estate is turning heads in the McCall area because we know the market inside and out. We’re local. Homegrown. Honest. We are a passionate group of real estate professionals who call McCall our home. We have years & years of successful real estate experience dating back to the late 70’s and 80’s. We’re always on top of every little detail, so you can experience the peace of mind you deserve. Community Real Estate Company established in 2004 is made up of some of McCall’s top producers. Our philosophy is to provide a high quality customer service experience in an atmosphere of a boutique independent Real Estate Brokerage. Conveniently located at the entrance to McCall Idaho, our Realtors extensive knowledge of the local market and use of our all technology available will find you the best options in a consistently changing market.
 communitiesMcCall Donnelly Cascade Meadows New Meadows Lake Fork Tamarack Pine Ridge
 websitehttp://community-realestate.com/
 address401 S. 3rd Street
 address_2
 cityMcCall
 stateID
 full_stateIdaho
 countryUSA
 market
 market_2
 postal_code83638
 phoneOffice: (208) 634-7778
 phone_2Cell: (208) 630-4270
 phone_3
 wide_contact_image(false)
 contact_nameBill McMurray
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner/Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename222.JPG
 logo_filename222.jpg
 contact_image_filename222.jpg
 all_properties_link_image_filename222.JPG
 all_properties_linkhttp://www.community-realestate.idxco.com/idx/17062/featured.php
 video_embed_code
 contact_video_embed_code
 meta_titleMcCall Real Estate | Community Real Estate Company | Leverage Global Partners
 meta_descriptionCommunity Real Estate Company is the exclusive representative for Leverage Global Partners in McCall, Donnelly, Cascade, Meadows, New Meadows, Lake Fork, Tamarack, and Pine Ridge, ID, USA.
 meta_keywordsCommunity Real Estate Company, Community Real Estate, Leverage Global Partners, McCall Real Estate, Donnelly Real Estate, Cascade Real Estate, Meadows Real Estate, New Meadows Real Estate, Lake Fork Real Estate, Tamarack Real Estate, Pine Ridge Real Estate, Idaho Real Estate
 login_message_counter3
 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-08-31 14:50:11
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/222/community-real-estate-company
 website_shortcommunity-realestate.com
 name_with_locationCommunity Real Estate Company
 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)
 id17012
 modelProperty
 model_id2834
 tagImage
 name27022.jpg
 typeimage/jpg
 size847623
 uri/assets/17012.jpg
 order0
 created2016-04-07 17:01:06
 modified2016-04-07 17:01:06
 1(array)
 id17011
 modelProperty
 model_id2834
 tagImage
 name27023.jpg
 typeimage/jpg
 size548738
 uri/assets/17011.jpg
 order1
 created2016-04-07 17:01:06
 modified2016-04-07 17:01:06
 2(array)
 id17013
 modelProperty
 model_id2834
 tagImage
 name27024.jpg
 typeimage/jpg
 size521732
 uri/assets/17013.jpg
 order2
 created2016-04-07 17:01:06
 modified2016-04-07 17:01:06
 3(array)
 id17014
 modelProperty
 model_id2834
 tagImage
 name27025.jpg
 typeimage/jpg
 size530128
 uri/assets/17014.jpg
 order3
 created2016-04-07 17:01:06
 modified2016-04-07 17:01:06
 4(array)
 id17015
 modelProperty
 model_id2834
 tagImage
 name27026.jpg
 typeimage/jpg
 size445798
 uri/assets/17015.jpg
 order4
 created2016-04-07 17:01:06
 modified2016-04-07 17:01:06
 5(array)
 id17016
 modelProperty
 model_id2834
 tagImage
 name27027.jpg
 typeimage/jpg
 size388526
 uri/assets/17016.jpg
 order5
 created2016-04-07 17:01:06
 modified2016-04-07 17:01:06
 6(array)
 id17017
 modelProperty
 model_id2834
 tagImage
 name27028.jpg
 typeimage/jpg
 size416474
 uri/assets/17017.jpg
 order6
 created2016-04-07 17:01:06
 modified2016-04-07 17:01:06
 7(array)
 id17018
 modelProperty
 model_id2834
 tagImage
 name27029.jpg
 typeimage/jpg
 size509735
 uri/assets/17018.jpg
 order7
 created2016-04-07 17:01:06
 modified2016-04-07 17:01:07
 8(array)
 id17019
 modelProperty
 model_id2834
 tagImage
 name27030.jpg
 typeimage/jpg
 size388526
 uri/assets/17019.jpg
 order8
 created2016-04-07 17:01:07
 modified2016-04-07 17:01:07
 9(array)
 id17020
 modelProperty
 model_id2834
 tagImage
 name27031.jpg
 typeimage/jpg
 size834311
 uri/assets/17020.jpg
 order9
 created2016-04-07 17:01:07
 modified2016-04-07 17:01:07
 User(array)
 0(array)
 id1094
 typeAgent
 brokerage_id222
 email[email protected]
 password414cdf81917220b99cfd1d54a8fd0c57782d91a0
 recover_hash
 first_nameLolo
 last_nameNelson
 title
 dre_num
 phone208-215-1714
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:53
 created2017-08-07 15:23:53
 notified(false)
 full_nameLolo Nelson
 uri/agent-detail/1094/lolo-nelson
 profile_complete(true)
 UsersProperty(array)
 id854
 user_id1094
 property_id2834
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id3551
 property_id2834
 property_feature_id1
 1(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id3552
 property_id2834
 property_feature_id12
 Topic(empty)
 1(array)
 Property(array)
 id2807
 brokerage_id222
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id895
 agent_2_id0
 agent_3_id0
 nameGolf Course Estate Home
 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)
 description If privacy is your desire this compound might suit you well. Situated on the #4 Ladies tee box you might not know it is there. Main house has 4 bedrooms with en suit baths, great room living area with gourmet's kitchen & additional loft office. Second building is an additional 1358 sqft. studio apartment over 2 extra large garages that provides room for all the toys, totaling 4 bays plus a golf cart garage. The fenced formally landscaped yard is a summertime retreat with expansive deck, fire pit & hot tub areas designed by Laidlaw Landscape Co. Access to Payette Lake, Fish & Swim Club, Shore Lodge & the Cove Spa, Marina & tennis courts are all among the amenities of living here. Whitetail membership is a requirement for purchasing a home in Whitetail.
 address377 Whitetail Drive
 address_2
 cityMcCall
 stateIdaho
 postal_code83638
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1950000
 price_20
 price_usd1950000
 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
 bathrooms5
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1balcony-terrace
 icon_2guest-house
 icon_3tennis
 icon_4
 icon_5
 icon_6
 websitehttp://www.community-realestate.idxco.com/idx/17062/details.php?idxID=399&listingID=522471
 meta_titleGolf Course Estate Home | McCall Real Estate | Community Real Estate Company
 meta_description377 Whitetail Drive is a property offered for sale in McCall, Idaho, USA, presented by Community Real Estate Company
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, year_built, virtual_tour, video_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-09-23 11:42:33
 uri/property-detail/2807/377-whitetail-drive-mccall-idaho-83638-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2807/377-whitetail-drive-mccall-idaho-83638-usa
 address_concat377 Whitetail Drive McCall Idaho 83638 USA
 google_maps_query_string377+Whitetail+Drive++McCall+Idaho+83638+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,950,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty5
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2015-09-23
 overridden_brokerage_nameCommunity Real Estate Company
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id222
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 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
 WOEID2447519
 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
 nameCommunity Real Estate Company
 broker_of_record_name
 short_nameCommunity Real Estate Company
 usernamecommunityREcompany
 password5fc7818eec49c5d2c06f0a8a34561dee0b9a2d16
 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
 descriptionCommunity Real Estate Company is the exclusive representative for Leverage Global Partners in McCall, Donnelly, Cascade, Meadows, New Meadows, Lake Fork, Tamarack, and Pine Ridge, ID, USA. In our own little way Community Real Estate is turning heads in the McCall area because we know the market inside and out. We’re local. Homegrown. Honest. We are a passionate group of real estate professionals who call McCall our home. We have years & years of successful real estate experience dating back to the late 70’s and 80’s. We’re always on top of every little detail, so you can experience the peace of mind you deserve. Community Real Estate Company established in 2004 is made up of some of McCall’s top producers. Our philosophy is to provide a high quality customer service experience in an atmosphere of a boutique independent Real Estate Brokerage. Conveniently located at the entrance to McCall Idaho, our Realtors extensive knowledge of the local market and use of our all technology available will find you the best options in a consistently changing market.
 communitiesMcCall Donnelly Cascade Meadows New Meadows Lake Fork Tamarack Pine Ridge
 websitehttp://community-realestate.com/
 address401 S. 3rd Street
 address_2
 cityMcCall
 stateID
 full_stateIdaho
 countryUSA
 market
 market_2
 postal_code83638
 phoneOffice: (208) 634-7778
 phone_2Cell: (208) 630-4270
 phone_3
 wide_contact_image(false)
 contact_nameBill McMurray
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner/Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename222.JPG
 logo_filename222.jpg
 contact_image_filename222.jpg
 all_properties_link_image_filename222.JPG
 all_properties_linkhttp://www.community-realestate.idxco.com/idx/17062/featured.php
 video_embed_code
 contact_video_embed_code
 meta_titleMcCall Real Estate | Community Real Estate Company | Leverage Global Partners
 meta_descriptionCommunity Real Estate Company is the exclusive representative for Leverage Global Partners in McCall, Donnelly, Cascade, Meadows, New Meadows, Lake Fork, Tamarack, and Pine Ridge, ID, USA.
 meta_keywordsCommunity Real Estate Company, Community Real Estate, Leverage Global Partners, McCall Real Estate, Donnelly Real Estate, Cascade Real Estate, Meadows Real Estate, New Meadows Real Estate, Lake Fork Real Estate, Tamarack Real Estate, Pine Ridge Real Estate, Idaho Real Estate
 login_message_counter3
 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-08-31 14:50:11
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/222/community-real-estate-company
 website_shortcommunity-realestate.com
 name_with_locationCommunity Real Estate Company
 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)
 id12439
 modelProperty
 model_id2807
 tagImage
 name26852.jpg
 typeimage/jpg
 size621590
 uri/assets/12439.jpg
 order0
 created2016-04-07 16:33:04
 modified2016-04-07 16:33:04
 1(array)
 id12440
 modelProperty
 model_id2807
 tagImage
 name26727.jpg
 typeimage/jpg
 size650957
 uri/assets/12440.jpg
 order1
 created2016-04-07 16:33:04
 modified2016-04-07 16:33:04
 2(array)
 id12442
 modelProperty
 model_id2807
 tagImage
 name26729.jpg
 typeimage/jpg
 size568172
 uri/assets/12442.jpg
 order2
 created2016-04-07 16:33:04
 modified2016-04-07 16:33:04
 3(array)
 id12443
 modelProperty
 model_id2807
 tagImage
 name26730.jpg
 typeimage/jpg
 size556366
 uri/assets/12443.jpg
 order3
 created2016-04-07 16:33:04
 modified2016-04-07 16:33:04
 4(array)
 id12448
 modelProperty
 model_id2807
 tagImage
 name26756.jpg
 typeimage/jpg
 size559184
 uri/assets/12448.jpg
 order4
 created2016-04-07 16:33:04
 modified2016-04-07 16:33:04
 5(array)
 id12441
 modelProperty
 model_id2807
 tagImage
 name26849.jpg
 typeimage/jpg
 size562988
 uri/assets/12441.jpg
 order5
 created2016-04-07 16:33:04
 modified2016-04-07 16:33:04
 6(array)
 id12446
 modelProperty
 model_id2807
 tagImage
 name26757.jpg
 typeimage/jpg
 size651262
 uri/assets/12446.jpg
 order6
 created2016-04-07 16:33:04
 modified2016-04-07 16:33:04
 7(array)
 id12444
 modelProperty
 model_id2807
 tagImage
 name26758.jpg
 typeimage/jpg
 size729355
 uri/assets/12444.jpg
 order7
 created2016-04-07 16:33:04
 modified2016-04-07 16:33:04
 8(array)
 id12447
 modelProperty
 model_id2807
 tagImage
 name26734.jpg
 typeimage/jpg
 size680450
 uri/assets/12447.jpg
 order8
 created2016-04-07 16:33:04
 modified2016-04-07 16:33:04
 9(array)
 id12445
 modelProperty
 model_id2807
 tagImage
 name26851.jpg
 typeimage/jpg
 size721704
 uri/assets/12445.jpg
 order9
 created2016-04-07 16:33:04
 modified2016-04-07 16:33:04
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id2317
 property_id2807
 property_feature_id1
 1(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id2318
 property_id2807
 property_feature_id5
 2(array)
 id13
 nameTennis Court
 additional(false)
 created2016-04-07 14:04:41
 modified2016-04-07 14:04:41
 PropertiesPropertyFeature(array)
 id2319
 property_id2807
 property_feature_id13
 Topic(empty)
 2(array)
 Property(array)
 id3395
 brokerage_id222
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id927
 agent_2_id0
 agent_3_id0
 nameOne of a Kind Lake Access Property
 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 Lake Access Property has it all. Located within walking distance to the Lake, this exceptional 3700 square ft 4 bedroom; 4 bath; 5 car garage Residence with guest quarters offers a private boat slip on Payette Lake; direct access to the 200' community sandy beach; private Tennis Court access and is located just minutes away from the downtown McCall amenities. Beautifully maintained and situated on a 0.61 Acre home site, the main house (3 bedrooms + Den used as a bedroom/ 3 baths/ 3 car garage)& Guest Quarters (1 very large room/ bonus room; bath above a 2 Xtra long car Garage) offer a great floor plan; Lake view Master Suite; hardwood floors; well designed kitchen; heated tile floors; double vanities & claw tubs + showers in all full baths; Master Suite & beautiful west facing yard.
 address1519 McCall Ave.
 address_2
 cityMcCall
 stateIdaho
 postal_code83638
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1200000
 price_20
 price_usd1200000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1beach-access
 icon_2dock
 icon_3guest-house
 icon_4tennis
 icon_5views
 icon_6
 websitehttp://www.community-realestate.idxco.com/idx/17062/details.php?idxID=399&listingID=522709
 meta_titleOne of a Kind Lake Access Property | McCall Real Estate | Community Real Estate Company
 meta_description1519 McCall Ave. is a property offered for sale in McCall, Idaho, USA, presented by Community Real Estate Company
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_41
 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, bathrooms_partial, square_feet, square_meters, acres, hectares, year_built, virtual_tour, video_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-02-05 08:54:44
 uri/property-detail/3395/1519-mccall-ave-mccall-idaho-83638-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3395/1519-mccall-ave-mccall-idaho-83638-usa
 address_concat1519 McCall Ave. McCall Idaho 83638 USA
 google_maps_query_string1519+McCall+Ave.++McCall+Idaho+83638+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,200,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty3
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty1
 feed_full_bathrooms4
 date_listed2016-02-05
 overridden_brokerage_nameCommunity Real Estate Company
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id222
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 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
 WOEID2447519
 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
 nameCommunity Real Estate Company
 broker_of_record_name
 short_nameCommunity Real Estate Company
 usernamecommunityREcompany
 password5fc7818eec49c5d2c06f0a8a34561dee0b9a2d16
 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
 descriptionCommunity Real Estate Company is the exclusive representative for Leverage Global Partners in McCall, Donnelly, Cascade, Meadows, New Meadows, Lake Fork, Tamarack, and Pine Ridge, ID, USA. In our own little way Community Real Estate is turning heads in the McCall area because we know the market inside and out. We’re local. Homegrown. Honest. We are a passionate group of real estate professionals who call McCall our home. We have years & years of successful real estate experience dating back to the late 70’s and 80’s. We’re always on top of every little detail, so you can experience the peace of mind you deserve. Community Real Estate Company established in 2004 is made up of some of McCall’s top producers. Our philosophy is to provide a high quality customer service experience in an atmosphere of a boutique independent Real Estate Brokerage. Conveniently located at the entrance to McCall Idaho, our Realtors extensive knowledge of the local market and use of our all technology available will find you the best options in a consistently changing market.
 communitiesMcCall Donnelly Cascade Meadows New Meadows Lake Fork Tamarack Pine Ridge
 websitehttp://community-realestate.com/
 address401 S. 3rd Street
 address_2
 cityMcCall
 stateID
 full_stateIdaho
 countryUSA
 market
 market_2
 postal_code83638
 phoneOffice: (208) 634-7778
 phone_2Cell: (208) 630-4270
 phone_3
 wide_contact_image(false)
 contact_nameBill McMurray
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner/Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename222.JPG
 logo_filename222.jpg
 contact_image_filename222.jpg
 all_properties_link_image_filename222.JPG
 all_properties_linkhttp://www.community-realestate.idxco.com/idx/17062/featured.php
 video_embed_code
 contact_video_embed_code
 meta_titleMcCall Real Estate | Community Real Estate Company | Leverage Global Partners
 meta_descriptionCommunity Real Estate Company is the exclusive representative for Leverage Global Partners in McCall, Donnelly, Cascade, Meadows, New Meadows, Lake Fork, Tamarack, and Pine Ridge, ID, USA.
 meta_keywordsCommunity Real Estate Company, Community Real Estate, Leverage Global Partners, McCall Real Estate, Donnelly Real Estate, Cascade Real Estate, Meadows Real Estate, New Meadows Real Estate, Lake Fork Real Estate, Tamarack Real Estate, Pine Ridge Real Estate, Idaho Real Estate
 login_message_counter3
 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-08-31 14:50:11
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/222/community-real-estate-company
 website_shortcommunity-realestate.com
 name_with_locationCommunity Real Estate Company
 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)
 id19115
 modelProperty
 model_id3395
 tagImage
 name32933.jpg
 typeimage/jpg
 size637955
 uri/assets/19115.jpg
 order0
 created2016-04-07 17:14:02
 modified2016-04-07 17:14:02
 1(array)
 id19117
 modelProperty
 model_id3395
 tagImage
 name32935.jpg
 typeimage/jpg
 size424011
 uri/assets/19117.jpg
 order1
 created2016-04-07 17:14:02
 modified2016-04-07 17:14:03
 2(array)
 id19118
 modelProperty
 model_id3395
 tagImage
 name32937.jpg
 typeimage/jpg
 size529942
 uri/assets/19118.jpg
 order2
 created2016-04-07 17:14:03
 modified2016-04-07 17:14:03
 3(array)
 id19120
 modelProperty
 model_id3395
 tagImage
 name32939.jpg
 typeimage/jpg
 size513607
 uri/assets/19120.jpg
 order3
 created2016-04-07 17:14:03
 modified2016-04-07 17:14:03
 4(array)
 id19121
 modelProperty
 model_id3395
 tagImage
 name32940.jpg
 typeimage/jpg
 size403933
 uri/assets/19121.jpg
 order4
 created2016-04-07 17:14:03
 modified2016-04-07 17:14:03
 5(array)
 id19119
 modelProperty
 model_id3395
 tagImage
 name32942.jpg
 typeimage/jpg
 size325018
 uri/assets/19119.jpg
 order5
 created2016-04-07 17:14:03
 modified2016-04-07 17:14:03
 6(array)
 id19116
 modelProperty
 model_id3395
 tagImage
 name32943.jpg
 typeimage/jpg
 size369890
 uri/assets/19116.jpg
 order6
 created2016-04-07 17:14:02
 modified2016-04-07 17:14:02
 7(array)
 id19122
 modelProperty
 model_id3395
 tagImage
 name32941.jpg
 typeimage/jpg
 size438958
 uri/assets/19122.jpg
 order7
 created2016-04-07 17:14:03
 modified2016-04-07 17:14:03
 User(array)
 0(array)
 id1094
 typeAgent
 brokerage_id222
 email[email protected]
 password414cdf81917220b99cfd1d54a8fd0c57782d91a0
 recover_hash
 first_nameLolo
 last_nameNelson
 title
 dre_num
 phone208-215-1714
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:53
 created2017-08-07 15:23:53
 notified(false)
 full_nameLolo Nelson
 uri/agent-detail/1094/lolo-nelson
 profile_complete(true)
 UsersProperty(array)
 id855
 user_id1094
 property_id3395
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id2
 nameBeach Access
 additional(false)
 created2016-04-07 14:00:52
 modified2016-04-07 14:00:52
 PropertiesPropertyFeature(array)
 id4061
 property_id3395
 property_feature_id2
 1(array)
 id3
 nameDock
 additional(false)
 created2016-04-07 14:01:13
 modified2016-04-07 14:01:13
 PropertiesPropertyFeature(array)
 id4062
 property_id3395
 property_feature_id3
 2(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id4063
 property_id3395
 property_feature_id5
 3(array)
 id13
 nameTennis Court
 additional(false)
 created2016-04-07 14:04:41
 modified2016-04-07 14:04:41
 PropertiesPropertyFeature(array)
 id4064
 property_id3395
 property_feature_id13
 4(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id4065
 property_id3395
 property_feature_id14
 Topic(empty)
 3(array)
 Property(array)
 id2864
 brokerage_id222
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id943
 agent_2_id0
 agent_3_id0
 nameKings Pines III 360 Degree Views
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionThis Custom home sits a top Migratory Ridge West of McCall offering a 360 degree view of the Seven Devils and Eagle Cap Wilderness West and Jug Handle East, and includes peek views of Payette Lake. You can walk or ski to McCall's Little Ski Hill. The home has 4 bedrooms , 6 baths and 2 loft areas. This home boasts true craftsmanship, hand carved timbered beams, and vaulted ceilings with European flair that add up to offer a warm welcome. The floors host Brazilian teak, slate, stone, 20 slabs of granite, and 2 custom granite sinks. The gourmet kitchen has dual Wolf range/ovens, 2 dish washers, 2 refrigerators and a butler pantry. There are 2 laundries with washer & dryers. You can see how this can provide the perfect venue for entertaining all your family and friends. A circular drive of pavers with a porte-cochre graces the front entrance. Formal landscaping includes lawn, shrubs, aspens, auto sprinkler systems, paver patio, and a fire pit with views the mountains. Additional luxurious features include theater room, entertainment system, wine cellar, and a water conditioning system.
 address1423 Club Hill Blvd
 address_2
 cityMcCall
 stateIdaho
 postal_code83638
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2400000
 price_20
 price_usd2400000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_periodWeekly
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms6
 bathrooms_20
 no_beds_baths(false)
 square_feet5620
 square_meters
 acres2
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size2
 icon_1views
 icon_2acreage
 icon_3media-room
 icon_4cellar
 icon_5sq-ft
 icon_6
 websitehttp://www.community-realestate.idxco.com/idx/17062/details.php?idxID=399&listingID=521182
 meta_titleKings Pines III 360 Degree Views | McCall Real Estate | Community Real Estate Company
 meta_description1423 Club Hill Blvd is a property offered for sale in McCall, Idaho, USA, presented by Community Real Estate Company
 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_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:02
 created2015-10-05 16:37:17
 uri/property-detail/2864/1423-club-hill-blvd-mccall-idaho-83638-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2864/1423-club-hill-blvd-mccall-idaho-83638-usa
 address_concat1423 Club Hill Blvd McCall Idaho 83638 USA
 google_maps_query_string1423+Club+Hill+Blvd++McCall+Idaho+83638+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,400,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty6
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms6
 date_listed2015-10-05
 overridden_brokerage_nameCommunity Real Estate Company
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id222
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 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
 WOEID2447519
 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
 nameCommunity Real Estate Company
 broker_of_record_name
 short_nameCommunity Real Estate Company
 usernamecommunityREcompany
 password5fc7818eec49c5d2c06f0a8a34561dee0b9a2d16
 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
 descriptionCommunity Real Estate Company is the exclusive representative for Leverage Global Partners in McCall, Donnelly, Cascade, Meadows, New Meadows, Lake Fork, Tamarack, and Pine Ridge, ID, USA. In our own little way Community Real Estate is turning heads in the McCall area because we know the market inside and out. We’re local. Homegrown. Honest. We are a passionate group of real estate professionals who call McCall our home. We have years & years of successful real estate experience dating back to the late 70’s and 80’s. We’re always on top of every little detail, so you can experience the peace of mind you deserve. Community Real Estate Company established in 2004 is made up of some of McCall’s top producers. Our philosophy is to provide a high quality customer service experience in an atmosphere of a boutique independent Real Estate Brokerage. Conveniently located at the entrance to McCall Idaho, our Realtors extensive knowledge of the local market and use of our all technology available will find you the best options in a consistently changing market.
 communitiesMcCall Donnelly Cascade Meadows New Meadows Lake Fork Tamarack Pine Ridge
 websitehttp://community-realestate.com/
 address401 S. 3rd Street
 address_2
 cityMcCall
 stateID
 full_stateIdaho
 countryUSA
 market
 market_2
 postal_code83638
 phoneOffice: (208) 634-7778
 phone_2Cell: (208) 630-4270
 phone_3
 wide_contact_image(false)
 contact_nameBill McMurray
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner/Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename222.JPG
 logo_filename222.jpg
 contact_image_filename222.jpg
 all_properties_link_image_filename222.JPG
 all_properties_linkhttp://www.community-realestate.idxco.com/idx/17062/featured.php
 video_embed_code
 contact_video_embed_code
 meta_titleMcCall Real Estate | Community Real Estate Company | Leverage Global Partners
 meta_descriptionCommunity Real Estate Company is the exclusive representative for Leverage Global Partners in McCall, Donnelly, Cascade, Meadows, New Meadows, Lake Fork, Tamarack, and Pine Ridge, ID, USA.
 meta_keywordsCommunity Real Estate Company, Community Real Estate, Leverage Global Partners, McCall Real Estate, Donnelly Real Estate, Cascade Real Estate, Meadows Real Estate, New Meadows Real Estate, Lake Fork Real Estate, Tamarack Real Estate, Pine Ridge Real Estate, Idaho Real Estate
 login_message_counter3
 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-08-31 14:50:11
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/222/community-real-estate-company
 website_shortcommunity-realestate.com
 name_with_locationCommunity Real Estate Company
 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)
 id17125
 modelProperty
 model_id2864
 tagImage
 name27348.jpg
 typeimage/jpg
 size712685
 uri/assets/17125.jpg
 order0
 created2016-04-07 17:02:16
 modified2016-04-07 17:02:16
 1(array)
 id17126
 modelProperty
 model_id2864
 tagImage
 name27349.jpg
 typeimage/jpg
 size594717
 uri/assets/17126.jpg
 order1
 created2016-04-07 17:02:16
 modified2016-04-07 17:02:16
 2(array)
 id17127
 modelProperty
 model_id2864
 tagImage
 name27350.jpg
 typeimage/jpg
 size545259
 uri/assets/17127.jpg
 order2
 created2016-04-07 17:02:16
 modified2016-04-07 17:02:16
 3(array)
 id17129
 modelProperty
 model_id2864
 tagImage
 name27358.jpg
 typeimage/jpg
 size655684
 uri/assets/17129.jpg
 order3
 created2016-04-07 17:02:16
 modified2016-04-07 17:02:16
 4(array)
 id17128
 modelProperty
 model_id2864
 tagImage
 name27351.jpg
 typeimage/jpg
 size513788
 uri/assets/17128.jpg
 order4
 created2016-04-07 17:02:16
 modified2016-04-07 17:02:16
 5(array)
 id17130
 modelProperty
 model_id2864
 tagImage
 name27353.jpg
 typeimage/jpg
 size523996
 uri/assets/17130.jpg
 order5
 created2016-04-07 17:02:16
 modified2016-04-07 17:02:16
 6(array)
 id17131
 modelProperty
 model_id2864
 tagImage
 name27354.jpg
 typeimage/jpg
 size510000
 uri/assets/17131.jpg
 order6
 created2016-04-07 17:02:16
 modified2016-04-07 17:02:16
 7(array)
 id17132
 modelProperty
 model_id2864
 tagImage
 name27355.jpg
 typeimage/jpg
 size577207
 uri/assets/17132.jpg
 order7
 created2016-04-07 17:02:16
 modified2016-04-07 17:02:16
 8(array)
 id17133
 modelProperty
 model_id2864
 tagImage
 name27356.jpg
 typeimage/jpg
 size472163
 uri/assets/17133.jpg
 order8
 created2016-04-07 17:02:16
 modified2016-04-07 17:02:16
 9(array)
 id17134
 modelProperty
 model_id2864
 tagImage
 name27357.jpg
 typeimage/jpg
 size589388
 uri/assets/17134.jpg
 order9
 created2016-04-07 17:02:16
 modified2016-04-07 17:02:16
 User(array)
 0(array)
 id1106
 typeAgent
 brokerage_id222
 email[email protected]
 password72d69bc2ad949c6a3548fde79d57e48fdeda7ac5
 recover_hash
 first_nameLori
 last_nameMacNichol-Gregory
 title
 dre_num
 phone208 761 7918
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:54
 created2017-08-07 15:23:54
 notified(false)
 full_nameLori MacNichol-Gregory
 uri/agent-detail/1106/lori-macnichol-gregory
 profile_complete(true)
 UsersProperty(array)
 id874
 user_id1106
 property_id2864
 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)
 id3581
 property_id2864
 property_feature_id14
 1(array)
 id8
 nameMedia Room
 additional(false)
 created2016-04-07 14:03:04
 modified2016-04-07 14:03:04
 PropertiesPropertyFeature(array)
 id3582
 property_id2864
 property_feature_id8
 2(array)
 id18
 nameWine Cellar
 additional(false)
 created2016-04-07 14:06:17
 modified2016-04-07 14:06:17
 PropertiesPropertyFeature(array)
 id3583
 property_id2864
 property_feature_id18
 Topic(empty)
- sidebar_locations(array)
 0(array)
 Location(array)
 id169
 parent_id9
 brokerage_id222
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameMcCall, ID, USA
 short_nameMcCall, ID, USA
 group_index
 latitude44.911007
 longitude-116.098740
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 18:35:09
 modified2016-04-12 18:36:42
 timezoneAmerica/Denver
 population0
 uri/locations/view/169/mccall-id-usa
 tile_nameMcCall, ID, USA
 Brokerage(array)
 id222
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 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
 WOEID2447519
 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
 nameCommunity Real Estate Company
 broker_of_record_name
 short_nameCommunity Real Estate Company
 usernamecommunityREcompany
 password5fc7818eec49c5d2c06f0a8a34561dee0b9a2d16
 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
 descriptionCommunity Real Estate Company is the exclusive representative for Leverage Global Partners in McCall, Donnelly, Cascade, Meadows, New Meadows, Lake Fork, Tamarack, and Pine Ridge, ID, USA. In our own little way Community Real Estate is turning heads in the McCall area because we know the market inside and out. We’re local. Homegrown. Honest. We are a passionate group of real estate professionals who call McCall our home. We have years & years of successful real estate experience dating back to the late 70’s and 80’s. We’re always on top of every little detail, so you can experience the peace of mind you deserve. Community Real Estate Company established in 2004 is made up of some of McCall’s top producers. Our philosophy is to provide a high quality customer service experience in an atmosphere of a boutique independent Real Estate Brokerage. Conveniently located at the entrance to McCall Idaho, our Realtors extensive knowledge of the local market and use of our all technology available will find you the best options in a consistently changing market.
 communitiesMcCall Donnelly Cascade Meadows New Meadows Lake Fork Tamarack Pine Ridge
 websitehttp://community-realestate.com/
 address401 S. 3rd Street
 address_2
 cityMcCall
 stateID
 full_stateIdaho
 countryUSA
 market
 market_2
 postal_code83638
 phoneOffice: (208) 634-7778
 phone_2Cell: (208) 630-4270
 phone_3
 wide_contact_image(false)
 contact_nameBill McMurray
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner/Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename222.JPG
 logo_filename222.jpg
 contact_image_filename222.jpg
 all_properties_link_image_filename222.JPG
 all_properties_linkhttp://www.community-realestate.idxco.com/idx/17062/featured.php
 video_embed_code
 contact_video_embed_code
 meta_titleMcCall Real Estate | Community Real Estate Company | Leverage Global Partners
 meta_descriptionCommunity Real Estate Company is the exclusive representative for Leverage Global Partners in McCall, Donnelly, Cascade, Meadows, New Meadows, Lake Fork, Tamarack, and Pine Ridge, ID, USA.
 meta_keywordsCommunity Real Estate Company, Community Real Estate, Leverage Global Partners, McCall Real Estate, Donnelly Real Estate, Cascade Real Estate, Meadows Real Estate, New Meadows Real Estate, Lake Fork Real Estate, Tamarack Real Estate, Pine Ridge Real Estate, Idaho Real Estate
 login_message_counter3
 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-08-31 14:50:11
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/222/community-real-estate-company
 website_shortcommunity-realestate.com
 name_with_locationCommunity Real Estate Company
 Image(array)
 id20733
 modelLocation
 model_id169
 tagImage
 nameScreen Shot 2016-04-12 at 6.35.38 PM.png
 typeimage/png
 size901132
 uri/assets/20733.png
 order0
 created2016-04-12 18:36:12
 modified2016-04-12 18:36:42
- highlighted_properties(array)
 0(array)
 Property(array)
 id3395
 brokerage_id222
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id927
 agent_2_id0
 agent_3_id0
 nameOne of a Kind Lake Access Property
 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 Lake Access Property has it all. Located within walking distance to the Lake, this exceptional 3700 square ft 4 bedroom; 4 bath; 5 car garage Residence with guest quarters offers a private boat slip on Payette Lake; direct access to the 200' community sandy beach; private Tennis Court access and is located just minutes away from the downtown McCall amenities. Beautifully maintained and situated on a 0.61 Acre home site, the main house (3 bedrooms + Den used as a bedroom/ 3 baths/ 3 car garage)& Guest Quarters (1 very large room/ bonus room; bath above a 2 Xtra long car Garage) offer a great floor plan; Lake view Master Suite; hardwood floors; well designed kitchen; heated tile floors; double vanities & claw tubs + showers in all full baths; Master Suite & beautiful west facing yard.
 address1519 McCall Ave.
 address_2
 cityMcCall
 stateIdaho
 postal_code83638
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1200000
 price_20
 price_usd1200000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1beach-access
 icon_2dock
 icon_3guest-house
 icon_4tennis
 icon_5views
 icon_6
 websitehttp://www.community-realestate.idxco.com/idx/17062/details.php?idxID=399&listingID=522709
 meta_titleOne of a Kind Lake Access Property | McCall Real Estate | Community Real Estate Company
 meta_description1519 McCall Ave. is a property offered for sale in McCall, Idaho, USA, presented by Community Real Estate Company
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_41
 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, bathrooms_partial, square_feet, square_meters, acres, hectares, year_built, virtual_tour, video_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-02-05 08:54:44
 uri/property-detail/3395/1519-mccall-ave-mccall-idaho-83638-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3395/1519-mccall-ave-mccall-idaho-83638-usa
 address_concat1519 McCall Ave. McCall Idaho 83638 USA
 google_maps_query_string1519+McCall+Ave.++McCall+Idaho+83638+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,200,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty3
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty1
 feed_full_bathrooms4
 date_listed2016-02-05
 overridden_brokerage_nameCommunity Real Estate Company
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id222
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 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
 WOEID2447519
 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
 nameCommunity Real Estate Company
 broker_of_record_name
 short_nameCommunity Real Estate Company
 usernamecommunityREcompany
 password5fc7818eec49c5d2c06f0a8a34561dee0b9a2d16
 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
 descriptionCommunity Real Estate Company is the exclusive representative for Leverage Global Partners in McCall, Donnelly, Cascade, Meadows, New Meadows, Lake Fork, Tamarack, and Pine Ridge, ID, USA. In our own little way Community Real Estate is turning heads in the McCall area because we know the market inside and out. We’re local. Homegrown. Honest. We are a passionate group of real estate professionals who call McCall our home. We have years & years of successful real estate experience dating back to the late 70’s and 80’s. We’re always on top of every little detail, so you can experience the peace of mind you deserve. Community Real Estate Company established in 2004 is made up of some of McCall’s top producers. Our philosophy is to provide a high quality customer service experience in an atmosphere of a boutique independent Real Estate Brokerage. Conveniently located at the entrance to McCall Idaho, our Realtors extensive knowledge of the local market and use of our all technology available will find you the best options in a consistently changing market.
 communitiesMcCall Donnelly Cascade Meadows New Meadows Lake Fork Tamarack Pine Ridge
 websitehttp://community-realestate.com/
 address401 S. 3rd Street
 address_2
 cityMcCall
 stateID
 full_stateIdaho
 countryUSA
 market
 market_2
 postal_code83638
 phoneOffice: (208) 634-7778
 phone_2Cell: (208) 630-4270
 phone_3
 wide_contact_image(false)
 contact_nameBill McMurray
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner/Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename222.JPG
 logo_filename222.jpg
 contact_image_filename222.jpg
 all_properties_link_image_filename222.JPG
 all_properties_linkhttp://www.community-realestate.idxco.com/idx/17062/featured.php
 video_embed_code
 contact_video_embed_code
 meta_titleMcCall Real Estate | Community Real Estate Company | Leverage Global Partners
 meta_descriptionCommunity Real Estate Company is the exclusive representative for Leverage Global Partners in McCall, Donnelly, Cascade, Meadows, New Meadows, Lake Fork, Tamarack, and Pine Ridge, ID, USA.
 meta_keywordsCommunity Real Estate Company, Community Real Estate, Leverage Global Partners, McCall Real Estate, Donnelly Real Estate, Cascade Real Estate, Meadows Real Estate, New Meadows Real Estate, Lake Fork Real Estate, Tamarack Real Estate, Pine Ridge Real Estate, Idaho Real Estate
 login_message_counter3
 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-08-31 14:50:11
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/222/community-real-estate-company
 website_shortcommunity-realestate.com
 name_with_locationCommunity Real Estate Company
 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)
 id19115
 modelProperty
 model_id3395
 tagImage
 name32933.jpg
 typeimage/jpg
 size637955
 uri/assets/19115.jpg
 order0
 created2016-04-07 17:14:02
 modified2016-04-07 17:14:02
 1(array)
 id19117
 modelProperty
 model_id3395
 tagImage
 name32935.jpg
 typeimage/jpg
 size424011
 uri/assets/19117.jpg
 order1
 created2016-04-07 17:14:02
 modified2016-04-07 17:14:03
 2(array)
 id19118
 modelProperty
 model_id3395
 tagImage
 name32937.jpg
 typeimage/jpg
 size529942
 uri/assets/19118.jpg
 order2
 created2016-04-07 17:14:03
 modified2016-04-07 17:14:03
 3(array)
 id19120
 modelProperty
 model_id3395
 tagImage
 name32939.jpg
 typeimage/jpg
 size513607
 uri/assets/19120.jpg
 order3
 created2016-04-07 17:14:03
 modified2016-04-07 17:14:03
 4(array)
 id19121
 modelProperty
 model_id3395
 tagImage
 name32940.jpg
 typeimage/jpg
 size403933
 uri/assets/19121.jpg
 order4
 created2016-04-07 17:14:03
 modified2016-04-07 17:14:03
 5(array)
 id19119
 modelProperty
 model_id3395
 tagImage
 name32942.jpg
 typeimage/jpg
 size325018
 uri/assets/19119.jpg
 order5
 created2016-04-07 17:14:03
 modified2016-04-07 17:14:03
 6(array)
 id19116
 modelProperty
 model_id3395
 tagImage
 name32943.jpg
 typeimage/jpg
 size369890
 uri/assets/19116.jpg
 order6
 created2016-04-07 17:14:02
 modified2016-04-07 17:14:02
 7(array)
 id19122
 modelProperty
 model_id3395
 tagImage
 name32941.jpg
 typeimage/jpg
 size438958
 uri/assets/19122.jpg
 order7
 created2016-04-07 17:14:03
 modified2016-04-07 17:14:03
 User(array)
 0(array)
 id1094
 typeAgent
 brokerage_id222
 email[email protected]
 password414cdf81917220b99cfd1d54a8fd0c57782d91a0
 recover_hash
 first_nameLolo
 last_nameNelson
 title
 dre_num
 phone208-215-1714
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:53
 created2017-08-07 15:23:53
 notified(false)
 full_nameLolo Nelson
 uri/agent-detail/1094/lolo-nelson
 profile_complete(true)
 UsersProperty(array)
 id855
 user_id1094
 property_id3395
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id2
 nameBeach Access
 additional(false)
 created2016-04-07 14:00:52
 modified2016-04-07 14:00:52
 PropertiesPropertyFeature(array)
 id4061
 property_id3395
 property_feature_id2
 1(array)
 id3
 nameDock
 additional(false)
 created2016-04-07 14:01:13
 modified2016-04-07 14:01:13
 PropertiesPropertyFeature(array)
 id4062
 property_id3395
 property_feature_id3
 2(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id4063
 property_id3395
 property_feature_id5
 3(array)
 id13
 nameTennis Court
 additional(false)
 created2016-04-07 14:04:41
 modified2016-04-07 14:04:41
 PropertiesPropertyFeature(array)
 id4064
 property_id3395
 property_feature_id13
 4(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id4065
 property_id3395
 property_feature_id14
 Topic(empty)
 1(array)
 Property(array)
 id2864
 brokerage_id222
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id943
 agent_2_id0
 agent_3_id0
 nameKings Pines III 360 Degree Views
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionThis Custom home sits a top Migratory Ridge West of McCall offering a 360 degree view of the Seven Devils and Eagle Cap Wilderness West and Jug Handle East, and includes peek views of Payette Lake. You can walk or ski to McCall's Little Ski Hill. The home has 4 bedrooms , 6 baths and 2 loft areas. This home boasts true craftsmanship, hand carved timbered beams, and vaulted ceilings with European flair that add up to offer a warm welcome. The floors host Brazilian teak, slate, stone, 20 slabs of granite, and 2 custom granite sinks. The gourmet kitchen has dual Wolf range/ovens, 2 dish washers, 2 refrigerators and a butler pantry. There are 2 laundries with washer & dryers. You can see how this can provide the perfect venue for entertaining all your family and friends. A circular drive of pavers with a porte-cochre graces the front entrance. Formal landscaping includes lawn, shrubs, aspens, auto sprinkler systems, paver patio, and a fire pit with views the mountains. Additional luxurious features include theater room, entertainment system, wine cellar, and a water conditioning system.
 address1423 Club Hill Blvd
 address_2
 cityMcCall
 stateIdaho
 postal_code83638
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2400000
 price_20
 price_usd2400000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_periodWeekly
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms6
 bathrooms_20
 no_beds_baths(false)
 square_feet5620
 square_meters
 acres2
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size2
 icon_1views
 icon_2acreage
 icon_3media-room
 icon_4cellar
 icon_5sq-ft
 icon_6
 websitehttp://www.community-realestate.idxco.com/idx/17062/details.php?idxID=399&listingID=521182
 meta_titleKings Pines III 360 Degree Views | McCall Real Estate | Community Real Estate Company
 meta_description1423 Club Hill Blvd is a property offered for sale in McCall, Idaho, USA, presented by Community Real Estate Company
 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_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:02
 created2015-10-05 16:37:17
 uri/property-detail/2864/1423-club-hill-blvd-mccall-idaho-83638-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2864/1423-club-hill-blvd-mccall-idaho-83638-usa
 address_concat1423 Club Hill Blvd McCall Idaho 83638 USA
 google_maps_query_string1423+Club+Hill+Blvd++McCall+Idaho+83638+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,400,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty6
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms6
 date_listed2015-10-05
 overridden_brokerage_nameCommunity Real Estate Company
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id222
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 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
 WOEID2447519
 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
 nameCommunity Real Estate Company
 broker_of_record_name
 short_nameCommunity Real Estate Company
 usernamecommunityREcompany
 password5fc7818eec49c5d2c06f0a8a34561dee0b9a2d16
 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
 descriptionCommunity Real Estate Company is the exclusive representative for Leverage Global Partners in McCall, Donnelly, Cascade, Meadows, New Meadows, Lake Fork, Tamarack, and Pine Ridge, ID, USA. In our own little way Community Real Estate is turning heads in the McCall area because we know the market inside and out. We’re local. Homegrown. Honest. We are a passionate group of real estate professionals who call McCall our home. We have years & years of successful real estate experience dating back to the late 70’s and 80’s. We’re always on top of every little detail, so you can experience the peace of mind you deserve. Community Real Estate Company established in 2004 is made up of some of McCall’s top producers. Our philosophy is to provide a high quality customer service experience in an atmosphere of a boutique independent Real Estate Brokerage. Conveniently located at the entrance to McCall Idaho, our Realtors extensive knowledge of the local market and use of our all technology available will find you the best options in a consistently changing market.
 communitiesMcCall Donnelly Cascade Meadows New Meadows Lake Fork Tamarack Pine Ridge
 websitehttp://community-realestate.com/
 address401 S. 3rd Street
 address_2
 cityMcCall
 stateID
 full_stateIdaho
 countryUSA
 market
 market_2
 postal_code83638
 phoneOffice: (208) 634-7778
 phone_2Cell: (208) 630-4270
 phone_3
 wide_contact_image(false)
 contact_nameBill McMurray
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner/Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename222.JPG
 logo_filename222.jpg
 contact_image_filename222.jpg
 all_properties_link_image_filename222.JPG
 all_properties_linkhttp://www.community-realestate.idxco.com/idx/17062/featured.php
 video_embed_code
 contact_video_embed_code
 meta_titleMcCall Real Estate | Community Real Estate Company | Leverage Global Partners
 meta_descriptionCommunity Real Estate Company is the exclusive representative for Leverage Global Partners in McCall, Donnelly, Cascade, Meadows, New Meadows, Lake Fork, Tamarack, and Pine Ridge, ID, USA.
 meta_keywordsCommunity Real Estate Company, Community Real Estate, Leverage Global Partners, McCall Real Estate, Donnelly Real Estate, Cascade Real Estate, Meadows Real Estate, New Meadows Real Estate, Lake Fork Real Estate, Tamarack Real Estate, Pine Ridge Real Estate, Idaho Real Estate
 login_message_counter3
 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-08-31 14:50:11
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/222/community-real-estate-company
 website_shortcommunity-realestate.com
 name_with_locationCommunity Real Estate Company
 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)
 id17125
 modelProperty
 model_id2864
 tagImage
 name27348.jpg
 typeimage/jpg
 size712685
 uri/assets/17125.jpg
 order0
 created2016-04-07 17:02:16
 modified2016-04-07 17:02:16
 1(array)
 id17126
 modelProperty
 model_id2864
 tagImage
 name27349.jpg
 typeimage/jpg
 size594717
 uri/assets/17126.jpg
 order1
 created2016-04-07 17:02:16
 modified2016-04-07 17:02:16
 2(array)
 id17127
 modelProperty
 model_id2864
 tagImage
 name27350.jpg
 typeimage/jpg
 size545259
 uri/assets/17127.jpg
 order2
 created2016-04-07 17:02:16
 modified2016-04-07 17:02:16
 3(array)
 id17129
 modelProperty
 model_id2864
 tagImage
 name27358.jpg
 typeimage/jpg
 size655684
 uri/assets/17129.jpg
 order3
 created2016-04-07 17:02:16
 modified2016-04-07 17:02:16
 4(array)
 id17128
 modelProperty
 model_id2864
 tagImage
 name27351.jpg
 typeimage/jpg
 size513788
 uri/assets/17128.jpg
 order4
 created2016-04-07 17:02:16
 modified2016-04-07 17:02:16
 5(array)
 id17130
 modelProperty
 model_id2864
 tagImage
 name27353.jpg
 typeimage/jpg
 size523996
 uri/assets/17130.jpg
 order5
 created2016-04-07 17:02:16
 modified2016-04-07 17:02:16
 6(array)
 id17131
 modelProperty
 model_id2864
 tagImage
 name27354.jpg
 typeimage/jpg
 size510000
 uri/assets/17131.jpg
 order6
 created2016-04-07 17:02:16
 modified2016-04-07 17:02:16
 7(array)
 id17132
 modelProperty
 model_id2864
 tagImage
 name27355.jpg
 typeimage/jpg
 size577207
 uri/assets/17132.jpg
 order7
 created2016-04-07 17:02:16
 modified2016-04-07 17:02:16
 8(array)
 id17133
 modelProperty
 model_id2864
 tagImage
 name27356.jpg
 typeimage/jpg
 size472163
 uri/assets/17133.jpg
 order8
 created2016-04-07 17:02:16
 modified2016-04-07 17:02:16
 9(array)
 id17134
 modelProperty
 model_id2864
 tagImage
 name27357.jpg
 typeimage/jpg
 size589388
 uri/assets/17134.jpg
 order9
 created2016-04-07 17:02:16
 modified2016-04-07 17:02:16
 User(array)
 0(array)
 id1106
 typeAgent
 brokerage_id222
 email[email protected]
 password72d69bc2ad949c6a3548fde79d57e48fdeda7ac5
 recover_hash
 first_nameLori
 last_nameMacNichol-Gregory
 title
 dre_num
 phone208 761 7918
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:54
 created2017-08-07 15:23:54
 notified(false)
 full_nameLori MacNichol-Gregory
 uri/agent-detail/1106/lori-macnichol-gregory
 profile_complete(true)
 UsersProperty(array)
 id874
 user_id1106
 property_id2864
 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)
 id3581
 property_id2864
 property_feature_id14
 1(array)
 id8
 nameMedia Room
 additional(false)
 created2016-04-07 14:03:04
 modified2016-04-07 14:03:04
 PropertiesPropertyFeature(array)
 id3582
 property_id2864
 property_feature_id8
 2(array)
 id18
 nameWine Cellar
 additional(false)
 created2016-04-07 14:06:17
 modified2016-04-07 14:06:17
 PropertiesPropertyFeature(array)
 id3583
 property_id2864
 property_feature_id18
 Topic(empty)
- custom_ga_event_properties(array)
 brokerageCommunity Real Estate Company, McCall
- property(array)
 Property(array)
 id2809
 brokerage_id222
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id916
 agent_2_id917
 agent_3_id0
 nameMAGNIFICENT MOUNTAIN RESORT
 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)
 descriptionLocated at Tamarack Resort, this Majestic Mountain Masterpiece has a total of 4 bedrooms and 5.5 baths and allows plenty of room for a large group. With panoramic views from every room and immediate access to ski out and ski in trails, this home is ideal for elegant family living or a corporate retreat. The dramatic hardwood entry leads to the main living area with towering windows overlooking the resort. The elevated kitchen is a Chef’s dreams with stunning adjoining native stonewall centerpiece and spacious dining area. Elegant lighting fixtures and finishes throughout. The main home has four luxurious bedroom suites each with private bath and built in hardwood cabinets and custom granite. The lower level great room with radiant floor heat and large custom stone fireplace has additional areas for game room or wine storage. A covered walk leads to the elegantly appointed 1 bedroom, 1 bath, full kitchen and living room guest apartment over the triple car garage. 
 address291 Whitewater Drive
 address_2
 cityTamarack
 stateIdaho
 postal_code83615
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2390000
 price_20
 price_usd2390000
 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
 bathrooms6
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1guest-house
 icon_2office
 icon_3views
 icon_4ski
 icon_5balcony-terrace
 icon_6
 website
 meta_titleMAGNIFICENT MOUNTAIN RESORT | Tamarack Real Estate | Community Real Estate Company
 meta_description291 Whitewater Drive is a property offered for sale in Tamarack, Idaho, USA, presented by Community Real Estate Company
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldssquare_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-09-23 14:05:13
 uri/property-detail/2809/291-whitewater-drive-tamarack-idaho-83615-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2809/291-whitewater-drive-tamarack-idaho-83615-usa
 address_concat291 Whitewater Drive Tamarack Idaho 83615 USA
 google_maps_query_string291+Whitewater+Drive++Tamarack+Idaho+83615+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,390,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty6
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms6
 date_listed2015-09-23
 overridden_brokerage_nameCommunity Real Estate Company
 overridden_brokerage_logo_uri/assets/2884.jpg
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id222
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 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
 WOEID2447519
 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
 nameCommunity Real Estate Company
 broker_of_record_name
 short_nameCommunity Real Estate Company
 usernamecommunityREcompany
 password5fc7818eec49c5d2c06f0a8a34561dee0b9a2d16
 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
 descriptionCommunity Real Estate Company is the exclusive representative for Leverage Global Partners in McCall, Donnelly, Cascade, Meadows, New Meadows, Lake Fork, Tamarack, and Pine Ridge, ID, USA. In our own little way Community Real Estate is turning heads in the McCall area because we know the market inside and out. We’re local. Homegrown. Honest. We are a passionate group of real estate professionals who call McCall our home. We have years & years of successful real estate experience dating back to the late 70’s and 80’s. We’re always on top of every little detail, so you can experience the peace of mind you deserve. Community Real Estate Company established in 2004 is made up of some of McCall’s top producers. Our philosophy is to provide a high quality customer service experience in an atmosphere of a boutique independent Real Estate Brokerage. Conveniently located at the entrance to McCall Idaho, our Realtors extensive knowledge of the local market and use of our all technology available will find you the best options in a consistently changing market.
 communitiesMcCall Donnelly Cascade Meadows New Meadows Lake Fork Tamarack Pine Ridge
 websitehttp://community-realestate.com/
 address401 S. 3rd Street
 address_2
 cityMcCall
 stateID
 full_stateIdaho
 countryUSA
 market
 market_2
 postal_code83638
 phoneOffice: (208) 634-7778
 phone_2Cell: (208) 630-4270
 phone_3
 wide_contact_image(false)
 contact_nameBill McMurray
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner/Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename222.JPG
 logo_filename222.jpg
 contact_image_filename222.jpg
 all_properties_link_image_filename222.JPG
 all_properties_linkhttp://www.community-realestate.idxco.com/idx/17062/featured.php
 video_embed_code
 contact_video_embed_code
 meta_titleMcCall Real Estate | Community Real Estate Company | Leverage Global Partners
 meta_descriptionCommunity Real Estate Company is the exclusive representative for Leverage Global Partners in McCall, Donnelly, Cascade, Meadows, New Meadows, Lake Fork, Tamarack, and Pine Ridge, ID, USA.
 meta_keywordsCommunity Real Estate Company, Community Real Estate, Leverage Global Partners, McCall Real Estate, Donnelly Real Estate, Cascade Real Estate, Meadows Real Estate, New Meadows Real Estate, Lake Fork Real Estate, Tamarack Real Estate, Pine Ridge Real Estate, Idaho Real Estate
 login_message_counter3
 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-08-31 14:50:11
 modified2016-04-08 16:34:26
 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)
 id2884
 modelBrokerage
 model_id222
 tagLogo
 name222.jpg
 typeimage/jpg
 size136294
 uri/assets/2884.jpg
 order0
 created2016-03-30 11:45:07
 modified2016-03-30 11:45:07
 MainImage(array)
 id2883
 modelBrokerage
 model_id222
 tagMainImage
 name222.JPG
 typeimage/JPG
 size2192494
 uri/assets/2883.JPG
 order0
 created2016-03-30 11:45:05
 modified2016-03-30 11:45:05
 ContactImage(array)
 id2885
 modelBrokerage
 model_id222
 tagContactImage
 name222.jpg
 typeimage/jpg
 size3797
 uri/assets/2885.jpg
 order0
 created2016-03-30 11:45:07
 modified2016-03-30 11:45:07
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 FeaturedImage(empty)
 Location(array)
 0(array)
 id169
 parent_id9
 brokerage_id222
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameMcCall, ID, USA
 short_nameMcCall, ID, USA
 group_index
 latitude44.911007
 longitude-116.098740
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 18:35:09
 modified2016-04-12 18:36:42
 timezoneAmerica/Denver
 population0
 uri/locations/view/169/mccall-id-usa
 tile_nameMcCall, ID, USA
 User(array)
 0(array)
 id201
 typeBrokerageAdmin
 brokerage_id222
 email[email protected]
 password5fc7818eec49c5d2c06f0a8a34561dee0b9a2d16
 recover_hash
 first_nameBill
 last_nameMcMurray
 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:31:48
 created2016-04-08 16:34:26
 notified(true)
 full_nameBill McMurray
 uri/agent-detail/201/bill-mcmurray
 profile_complete(true)
 1(array)
 id1069
 typeAgent
 brokerage_id222
 email[email protected]
 password2c4ebb800338f6fb5dfd5974cadca28ec6c4a38d
 recover_hash
 first_nameAngela
 last_nameBrown
 title
 dre_num
 phone208-315-1157
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:52
 created2017-08-07 15:23:52
 notified(false)
 full_nameAngela Brown
 uri/agent-detail/1069/angela-brown
 profile_complete(true)
 2(array)
 id1078
 typeAgent
 brokerage_id222
 email[email protected]
 password76715b38dac4a5ef34550347f4a73ff4b6008b23
 recover_hash
 first_nameBill
 last_nameMcMurray
 title
 dre_num
 phone208-630-4270
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:52
 created2017-08-07 15:23:52
 notified(false)
 full_nameBill McMurray
 uri/agent-detail/1078/bill-mcmurray
 profile_complete(true)
 3(array)
 id1086
 typeAgent
 brokerage_id222
 email[email protected]
 password55d6c67ee132446a343fd1ac451db13f625f1999
 recover_hash
 first_nameMargo
 last_nameFlaherty
 title
 dre_num
 phone208-271-6150
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:53
 created2017-08-07 15:23:53
 notified(false)
 full_nameMargo Flaherty
 uri/agent-detail/1086/margo-flaherty
 profile_complete(true)
 4(array)
 id1087
 typeAgent
 brokerage_id222
 email[email protected]
 password937805521f2c62d06f2191daa1d69c647973e77a
 recover_hash
 first_nameBecky
 last_nameMartinson
 title
 dre_num
 phone208-315-0656
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:53
 created2017-08-07 15:23:53
 notified(false)
 full_nameBecky Martinson
 uri/agent-detail/1087/becky-martinson
 profile_complete(true)
 5(array)
 id1094
 typeAgent
 brokerage_id222
 email[email protected]
 password414cdf81917220b99cfd1d54a8fd0c57782d91a0
 recover_hash
 first_nameLolo
 last_nameNelson
 title
 dre_num
 phone208-215-1714
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:53
 created2017-08-07 15:23:53
 notified(false)
 full_nameLolo Nelson
 uri/agent-detail/1094/lolo-nelson
 profile_complete(true)
 6(array)
 id1106
 typeAgent
 brokerage_id222
 email[email protected]
 password72d69bc2ad949c6a3548fde79d57e48fdeda7ac5
 recover_hash
 first_nameLori
 last_nameMacNichol-Gregory
 title
 dre_num
 phone208 761 7918
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:54
 created2017-08-07 15:23:54
 notified(false)
 full_nameLori MacNichol-Gregory
 uri/agent-detail/1106/lori-macnichol-gregory
 profile_complete(true)
 uri/brokerage-detail/222/community-real-estate-company
 website_shortcommunity-realestate.com
 name_with_locationCommunity Real Estate Company - McCall, 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)
 id16607
 modelProperty
 model_id2809
 tagImage
 name28003.jpg
 typeimage/jpg
 size865028
 uri/assets/16607.jpg
 order0
 created2016-04-07 16:59:04
 modified2016-04-07 16:59:04
 1(array)
 id16601
 modelProperty
 model_id2809
 tagImage
 name26750.jpg
 typeimage/jpg
 size442557
 uri/assets/16601.jpg
 order1
 created2016-04-07 16:59:03
 modified2016-04-07 16:59:03
 2(array)
 id16602
 modelProperty
 model_id2809
 tagImage
 name26751.jpg
 typeimage/jpg
 size610352
 uri/assets/16602.jpg
 order2
 created2016-04-07 16:59:03
 modified2016-04-07 16:59:03
 3(array)
 id16600
 modelProperty
 model_id2809
 tagImage
 name26864.jpg
 typeimage/jpg
 size467952
 uri/assets/16600.jpg
 order3
 created2016-04-07 16:59:03
 modified2016-04-07 16:59:03
 4(array)
 id16603
 modelProperty
 model_id2809
 tagImage
 name26752.jpg
 typeimage/jpg
 size493926
 uri/assets/16603.jpg
 order4
 created2016-04-07 16:59:03
 modified2016-04-07 16:59:04
 5(array)
 id16599
 modelProperty
 model_id2809
 tagImage
 name26866.jpg
 typeimage/jpg
 size499572
 uri/assets/16599.jpg
 order5
 created2016-04-07 16:59:03
 modified2016-04-07 16:59:03
 6(array)
 id16604
 modelProperty
 model_id2809
 tagImage
 name26753.jpg
 typeimage/jpg
 size630641
 uri/assets/16604.jpg
 order6
 created2016-04-07 16:59:04
 modified2016-04-07 16:59:04
 7(array)
 id16605
 modelProperty
 model_id2809
 tagImage
 name26754.jpg
 typeimage/jpg
 size655745
 uri/assets/16605.jpg
 order7
 created2016-04-07 16:59:04
 modified2016-04-07 16:59:04
 8(array)
 id16606
 modelProperty
 model_id2809
 tagImage
 name26868.jpg
 typeimage/jpg
 size610352
 uri/assets/16606.jpg
 order8
 created2016-04-07 16:59:04
 modified2016-04-07 16:59:04
 9(array)
 id16598
 modelProperty
 model_id2809
 tagImage
 name26867.jpg
 typeimage/jpg
 size565450
 uri/assets/16598.jpg
 order9
 created2016-04-07 16:59:03
 modified2016-04-07 16:59:03
 User(array)
 0(array)
 id1086
 typeAgent
 brokerage_id222
 email[email protected]
 password55d6c67ee132446a343fd1ac451db13f625f1999
 recover_hash
 first_nameMargo
 last_nameFlaherty
 title
 dre_num
 phone208-271-6150
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:53
 created2017-08-07 15:23:53
 notified(false)
 full_nameMargo Flaherty
 uri/agent-detail/1086/margo-flaherty
 profile_complete(true)
 UsersProperty(array)
 id840
 user_id1086
 property_id2809
 sort_order0
 Brokerage(array)
 id222
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 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
 WOEID2447519
 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
 nameCommunity Real Estate Company
 broker_of_record_name
 short_nameCommunity Real Estate Company
 usernamecommunityREcompany
 password5fc7818eec49c5d2c06f0a8a34561dee0b9a2d16
 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
 descriptionCommunity Real Estate Company is the exclusive representative for Leverage Global Partners in McCall, Donnelly, Cascade, Meadows, New Meadows, Lake Fork, Tamarack, and Pine Ridge, ID, USA. In our own little way Community Real Estate is turning heads in the McCall area because we know the market inside and out. We’re local. Homegrown. Honest. We are a passionate group of real estate professionals who call McCall our home. We have years & years of successful real estate experience dating back to the late 70’s and 80’s. We’re always on top of every little detail, so you can experience the peace of mind you deserve. Community Real Estate Company established in 2004 is made up of some of McCall’s top producers. Our philosophy is to provide a high quality customer service experience in an atmosphere of a boutique independent Real Estate Brokerage. Conveniently located at the entrance to McCall Idaho, our Realtors extensive knowledge of the local market and use of our all technology available will find you the best options in a consistently changing market.
 communitiesMcCall Donnelly Cascade Meadows New Meadows Lake Fork Tamarack Pine Ridge
 websitehttp://community-realestate.com/
 address401 S. 3rd Street
 address_2
 cityMcCall
 stateID
 full_stateIdaho
 countryUSA
 market
 market_2
 postal_code83638
 phoneOffice: (208) 634-7778
 phone_2Cell: (208) 630-4270
 phone_3
 wide_contact_image(false)
 contact_nameBill McMurray
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner/Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename222.JPG
 logo_filename222.jpg
 contact_image_filename222.jpg
 all_properties_link_image_filename222.JPG
 all_properties_linkhttp://www.community-realestate.idxco.com/idx/17062/featured.php
 video_embed_code
 contact_video_embed_code
 meta_titleMcCall Real Estate | Community Real Estate Company | Leverage Global Partners
 meta_descriptionCommunity Real Estate Company is the exclusive representative for Leverage Global Partners in McCall, Donnelly, Cascade, Meadows, New Meadows, Lake Fork, Tamarack, and Pine Ridge, ID, USA.
 meta_keywordsCommunity Real Estate Company, Community Real Estate, Leverage Global Partners, McCall Real Estate, Donnelly Real Estate, Cascade Real Estate, Meadows Real Estate, New Meadows Real Estate, Lake Fork Real Estate, Tamarack Real Estate, Pine Ridge Real Estate, Idaho Real Estate
 login_message_counter3
 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-08-31 14:50:11
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/222/community-real-estate-company
 website_shortcommunity-realestate.com
 name_with_locationCommunity Real Estate Company
 Image(empty)
 BrokerageLogoOverride(empty)
 1(array)
 id1087
 typeAgent
 brokerage_id222
 email[email protected]
 password937805521f2c62d06f2191daa1d69c647973e77a
 recover_hash
 first_nameBecky
 last_nameMartinson
 title
 dre_num
 phone208-315-0656
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:53
 created2017-08-07 15:23:53
 notified(false)
 full_nameBecky Martinson
 uri/agent-detail/1087/becky-martinson
 profile_complete(true)
 UsersProperty(array)
 id841
 user_id1087
 property_id2809
 sort_order0
 Brokerage(array)
 id222
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 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
 WOEID2447519
 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
 nameCommunity Real Estate Company
 broker_of_record_name
 short_nameCommunity Real Estate Company
 usernamecommunityREcompany
 password5fc7818eec49c5d2c06f0a8a34561dee0b9a2d16
 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
 descriptionCommunity Real Estate Company is the exclusive representative for Leverage Global Partners in McCall, Donnelly, Cascade, Meadows, New Meadows, Lake Fork, Tamarack, and Pine Ridge, ID, USA. In our own little way Community Real Estate is turning heads in the McCall area because we know the market inside and out. We’re local. Homegrown. Honest. We are a passionate group of real estate professionals who call McCall our home. We have years & years of successful real estate experience dating back to the late 70’s and 80’s. We’re always on top of every little detail, so you can experience the peace of mind you deserve. Community Real Estate Company established in 2004 is made up of some of McCall’s top producers. Our philosophy is to provide a high quality customer service experience in an atmosphere of a boutique independent Real Estate Brokerage. Conveniently located at the entrance to McCall Idaho, our Realtors extensive knowledge of the local market and use of our all technology available will find you the best options in a consistently changing market.
 communitiesMcCall Donnelly Cascade Meadows New Meadows Lake Fork Tamarack Pine Ridge
 websitehttp://community-realestate.com/
 address401 S. 3rd Street
 address_2
 cityMcCall
 stateID
 full_stateIdaho
 countryUSA
 market
 market_2
 postal_code83638
 phoneOffice: (208) 634-7778
 phone_2Cell: (208) 630-4270
 phone_3
 wide_contact_image(false)
 contact_nameBill McMurray
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner/Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename222.JPG
 logo_filename222.jpg
 contact_image_filename222.jpg
 all_properties_link_image_filename222.JPG
 all_properties_linkhttp://www.community-realestate.idxco.com/idx/17062/featured.php
 video_embed_code
 contact_video_embed_code
 meta_titleMcCall Real Estate | Community Real Estate Company | Leverage Global Partners
 meta_descriptionCommunity Real Estate Company is the exclusive representative for Leverage Global Partners in McCall, Donnelly, Cascade, Meadows, New Meadows, Lake Fork, Tamarack, and Pine Ridge, ID, USA.
 meta_keywordsCommunity Real Estate Company, Community Real Estate, Leverage Global Partners, McCall Real Estate, Donnelly Real Estate, Cascade Real Estate, Meadows Real Estate, New Meadows Real Estate, Lake Fork Real Estate, Tamarack Real Estate, Pine Ridge Real Estate, Idaho Real Estate
 login_message_counter3
 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-08-31 14:50:11
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/222/community-real-estate-company
 website_shortcommunity-realestate.com
 name_with_locationCommunity Real Estate Company
 Image(empty)
 BrokerageLogoOverride(empty)
 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)
 id3440
 property_id2809
 property_feature_id5
 Icon(array)
 id3554
 modelPropertyFeature
 model_id5
 tagIcon
 name133.png
 typeimage/png
 size1953
 uri/assets/3554.png
 order0
 created2016-04-07 14:02:11
 modified2016-04-07 14:02:13
 1(array)
 id9
 nameOffice
 additional(false)
 created2016-04-07 14:03:21
 modified2016-04-07 14:03:21
 PropertiesPropertyFeature(array)
 id3441
 property_id2809
 property_feature_id9
 Icon(array)
 id3558
 modelPropertyFeature
 model_id9
 tagIcon
 name137.png
 typeimage/png
 size2009
 uri/assets/3558.png
 order0
 created2016-04-07 14:03:19
 modified2016-04-07 14:03:21
 2(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id3442
 property_id2809
 property_feature_id14
 Icon(array)
 id3563
 modelPropertyFeature
 model_id14
 tagIcon
 name142.png
 typeimage/png
 size2192
 uri/assets/3563.png
 order0
 created2016-04-07 14:04:53
 modified2016-04-07 14:04:55
 3(array)
 id11
 nameSki In/Ski Out
 additional(false)
 created2016-04-07 14:03:53
 modified2016-04-07 14:03:53
 PropertiesPropertyFeature(array)
 id3443
 property_id2809
 property_feature_id11
 Icon(array)
 id3560
 modelPropertyFeature
 model_id11
 tagIcon
 name139.png
 typeimage/png
 size2214
 uri/assets/3560.png
 order0
 created2016-04-07 14:03:51
 modified2016-04-07 14:03:53
 4(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id3444
 property_id2809
 property_feature_id1
 Icon(array)
 id3550
 modelPropertyFeature
 model_id1
 tagIcon
 name129.png
 typeimage/png
 size2147
 uri/assets/3550.png
 order0
 created2016-04-07 14:00:24
 modified2016-04-07 14:00:26
 Topic(empty)
- membership_subscription_temp_allowed_login(null)
- newsletter_member_types(array)
 Leverage Member: AgentLeverage Member: Agent
 Leverage Member: Broker or ManagementLeverage Member: Broker or Management
 Non-MemberNon-Member
- $request->data(empty)
- $this->validationErrors(array)
 Subscription(empty)
 Property(empty)
 User(empty)
 PropertyFeature(empty)
 SecondaryPropertyCategory(empty)
 Topic(empty)
 PrimaryPropertyCategory(empty)
 Brokerage(empty)
 StripeSubscription(empty)
 GlobalReachReport(empty)
 AccountExecutive(empty)
 Logo(empty)
 MainImage(empty)
 ContactImage(empty)
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 Location(empty)
 FeaturedImage(empty)
 Image(empty)
 UsersProperty(empty)
 BrokerageLogoOverride(empty)
 PropertiesSecondaryPropertyCategory(empty)
 PropertiesPropertyFeature(empty)
 Icon(empty)
 PropertiesTopic(empty)
- Loaded Helpers(array)
 0Permission
 1Number
 2SimpleGraph
 3DebugTimer
 4Toolbar
 5Session
 6Text
 7Flash
 8HtmlToolbar
 9Html
 10Form
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

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

====

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

MAGNIFICENT MOUNTAIN RESORT

Represented By: Community Real Estate Company

community-realestate.com | License #: 012345

community-realestate.com | License #: 012345

Highlighted Properties

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 14 ms Total Queries: 41 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 14 ms
Total Queries: 41 queries