Lakefront

1780 North Lake Boulevard | Tahoe City, CA 96145, USA | $8,495,000 | MLS ID: 20160046

7 Beds
7 Baths

Tahoe itself is a Washoe name meaning "Big Waters”. Cedar Shores exemplifies the meaning perfectly. This is the quintessential family retreat featuring one of the most pristine settings on the N Shore of Lake Tahoe. Sitting on over 1 acre with over 100 ft. of lake frontage, a main family compound + guest home comprising 8,900 sq. ft. 7+ BR, 7+ BA, office, den, gourmet kitchen, full bar, home theater, sauna, Turkish Bath, wine cellar & so much more. Create a legacy of priceless family traditions and memories.

Represented By: Tahoe Mountain Realty

www.tmrrealestate.com | License #: 012345

Steve Kegel
5305502023
Email

Main Office: 3001 Northstar Drive Suite 100 ,
PO Box 3757
Truckee, CA 96160
USA

More About Steve

View On Map Property Website Video Tour

Highlighted Properties

Martis Camp Ski in/out

9486 Clermont Court | Truckee, CA 96161
Price Upon Request

Northstar

1938 Gray Wolf | Truckee, CA 96161
$2,995,000

Represented By

Agent Contacts: Steve Kegel 5305502023 | Email

Featured Location

Truckee, Lake Tahoe, CA, 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)
  03344
  11780-north-lake-boulevard-tahoe-city-ca-96145-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: 6 ms
Total Queries: 33 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created`, `PrimaryPropertyCategory`.`id`, `PrimaryPropertyCategory`.`name`, `PrimaryPropertyCategory`.`created`, `PrimaryPropertyCategory`.`modified`, `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `StripeSubscription`.`id`, `StripeSubscription`.`brokerage_id`, `StripeSubscription`.`user_id`, `StripeSubscription`.`property_id`, `StripeSubscription`.`type`, `StripeSubscription`.`stripe_id`, `StripeSubscription`.`stripe_customer_id`, `StripeSubscription`.`stripe_checkout_email`, `StripeSubscription`.`stripe_promotion_code`, `StripeSubscription`.`stripe_promotion_code_id`, `StripeSubscription`.`stripe_coupon_code_id`, `StripeSubscription`.`status`, `StripeSubscription`.`current_period_end`, `StripeSubscription`.`cancel_at_period_end`, `StripeSubscription`.`ended`, `StripeSubscription`.`last_change`, `StripeSubscription`.`last_activity_email_sent`, `StripeSubscription`.`created`, `StripeSubscription`.`modified`, `GlobalReachReport`.`id`, `GlobalReachReport`.`property_id`, `GlobalReachReport`.`wsj_desktop`, `GlobalReachReport`.`wsj_mobile`, `GlobalReachReport`.`wsj_expires`, `GlobalReachReport`.`wsj_capture_started`, `GlobalReachReport`.`mg_desktop`, `GlobalReachReport`.`mg_mobile`, `GlobalReachReport`.`mg_expires`, `GlobalReachReport`.`mg_capture_started`, `GlobalReachReport`.`bp_desktop`, `GlobalReachReport`.`bp_mobile`, `GlobalReachReport`.`bp_expires`, `GlobalReachReport`.`gp_capture_started`, `GlobalReachReport`.`mw_desktop`, `GlobalReachReport`.`mw_mobile`, `GlobalReachReport`.`mw_expires`, `GlobalReachReport`.`mw_capture_started`, `GlobalReachReport`.`ft_desktop`, `GlobalReachReport`.`ft_mobile`, `GlobalReachReport`.`ft_expires`, `GlobalReachReport`.`ft_capture_started`, `GlobalReachReport`.`nikkei_desktop`, `GlobalReachReport`.`nikkei_mobile`, `GlobalReachReport`.`nikkei_expires`, `GlobalReachReport`.`nikkei_capture_started`, `GlobalReachReport`.`pgl_desktop`, `GlobalReachReport`.`pgl_mobile`, `GlobalReachReport`.`pgl_expires`, `GlobalReachReport`.`pgl_capture_started`, `GlobalReachReport`.`robb_desktop`, `GlobalReachReport`.`robb_mobile`, `GlobalReachReport`.`robb_expires`, `GlobalReachReport`.`robb_capture_started`, `GlobalReachReport`.`juwai_desktop`, `GlobalReachReport`.`juwai_mobile`, `GlobalReachReport`.`juwai_expires`, `GlobalReachReport`.`juwai_capture_started`, `GlobalReachReport`.`leverage_desktop`, `GlobalReachReport`.`leverage_mobile`, `GlobalReachReport`.`leverage_expires`, `GlobalReachReport`.`leverage_capture_started`, `GlobalReachReport`.`created`, `GlobalReachReport`.`modified` FROM `leveragere_staging2`.`properties` AS `Property` LEFT JOIN `leveragere_staging2`.`property_categories` AS `PrimaryPropertyCategory` ON (`Property`.`primary_property_category_id` = `PrimaryPropertyCategory`.`id`) LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Property`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`stripe_subscriptions` AS `StripeSubscription` ON (`StripeSubscription`.`property_id` = `Property`.`id` AND `StripeSubscription`.`status` = 'active') LEFT JOIN `leveragere_staging2`.`global_reach_reports` AS `GlobalReachReport` ON (`GlobalReachReport`.`property_id` = `Property`.`id`) WHERE `Property`.`id` = 3344 AND `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`incomplete` = '0' LIMIT 1	1	1	1
SELECT `AccountExecutive`.`id`, `AccountExecutive`.`type`, `AccountExecutive`.`brokerage_id`, `AccountExecutive`.`email`, `AccountExecutive`.`password`, `AccountExecutive`.`recover_hash`, `AccountExecutive`.`first_name`, `AccountExecutive`.`last_name`, `AccountExecutive`.`title`, `AccountExecutive`.`dre_num`, `AccountExecutive`.`phone`, `AccountExecutive`.`max_luxury_feed_properties`, `AccountExecutive`.`headshot_filename`, `AccountExecutive`.`bio`, `AccountExecutive`.`brokerage_name_override`, `AccountExecutive`.`stripe_customer_id`, `AccountExecutive`.`digital_ad_first_free_month_coupon`, `AccountExecutive`.`modified`, `AccountExecutive`.`created`, `AccountExecutive`.`notified`, (CONCAT(`AccountExecutive`.`first_name`, " ", `AccountExecutive`.`last_name`)) AS `AccountExecutive__full_name` FROM `leveragere_staging2`.`users` AS `AccountExecutive` WHERE `AccountExecutive`.`id` = 235	1	1	0
SELECT `Logo`.`id`, `Logo`.`model`, `Logo`.`model_id`, `Logo`.`tag`, `Logo`.`name`, `Logo`.`type`, `Logo`.`size`, `Logo`.`uri`, `Logo`.`order`, `Logo`.`created`, `Logo`.`modified` FROM `leveragere_staging2`.`assets` AS `Logo` WHERE `Logo`.`model_id` = 214 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` = 214 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` = 214 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` = 214 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` = 214 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` = 214 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` = 214 AND `MainArticle`.`model` = 'Brokerage'	1	1	0
SELECT `FeaturedImage`.`id`, `FeaturedImage`.`model`, `FeaturedImage`.`model_id`, `FeaturedImage`.`tag`, `FeaturedImage`.`name`, `FeaturedImage`.`type`, `FeaturedImage`.`size`, `FeaturedImage`.`uri`, `FeaturedImage`.`order`, `FeaturedImage`.`created`, `FeaturedImage`.`modified` FROM `leveragere_staging2`.`assets` AS `FeaturedImage` WHERE `FeaturedImage`.`model` = 'Brokerage' AND `FeaturedImage`.`tag` = 'FeaturedImage' AND `FeaturedImage`.`model_id` = (214) 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` = (214)	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` = (214)	6	6	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` = (3344) ORDER BY `Image`.`order` ASC	3	3	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` = 3344 AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	1	1	0
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` WHERE `Brokerage`.`id` = 214	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` = 976 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` = 976 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` = 3344 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` = 3344 AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	0	0	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` = 3344 AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	0
SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created`, `PrimaryPropertyCategory`.`id`, `PrimaryPropertyCategory`.`name`, `PrimaryPropertyCategory`.`created`, `PrimaryPropertyCategory`.`modified`, `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `StripeSubscription`.`id`, `StripeSubscription`.`brokerage_id`, `StripeSubscription`.`user_id`, `StripeSubscription`.`property_id`, `StripeSubscription`.`type`, `StripeSubscription`.`stripe_id`, `StripeSubscription`.`stripe_customer_id`, `StripeSubscription`.`stripe_checkout_email`, `StripeSubscription`.`stripe_promotion_code`, `StripeSubscription`.`stripe_promotion_code_id`, `StripeSubscription`.`stripe_coupon_code_id`, `StripeSubscription`.`status`, `StripeSubscription`.`current_period_end`, `StripeSubscription`.`cancel_at_period_end`, `StripeSubscription`.`ended`, `StripeSubscription`.`last_change`, `StripeSubscription`.`last_activity_email_sent`, `StripeSubscription`.`created`, `StripeSubscription`.`modified`, `GlobalReachReport`.`id`, `GlobalReachReport`.`property_id`, `GlobalReachReport`.`wsj_desktop`, `GlobalReachReport`.`wsj_mobile`, `GlobalReachReport`.`wsj_expires`, `GlobalReachReport`.`wsj_capture_started`, `GlobalReachReport`.`mg_desktop`, `GlobalReachReport`.`mg_mobile`, `GlobalReachReport`.`mg_expires`, `GlobalReachReport`.`mg_capture_started`, `GlobalReachReport`.`bp_desktop`, `GlobalReachReport`.`bp_mobile`, `GlobalReachReport`.`bp_expires`, `GlobalReachReport`.`gp_capture_started`, `GlobalReachReport`.`mw_desktop`, `GlobalReachReport`.`mw_mobile`, `GlobalReachReport`.`mw_expires`, `GlobalReachReport`.`mw_capture_started`, `GlobalReachReport`.`ft_desktop`, `GlobalReachReport`.`ft_mobile`, `GlobalReachReport`.`ft_expires`, `GlobalReachReport`.`ft_capture_started`, `GlobalReachReport`.`nikkei_desktop`, `GlobalReachReport`.`nikkei_mobile`, `GlobalReachReport`.`nikkei_expires`, `GlobalReachReport`.`nikkei_capture_started`, `GlobalReachReport`.`pgl_desktop`, `GlobalReachReport`.`pgl_mobile`, `GlobalReachReport`.`pgl_expires`, `GlobalReachReport`.`pgl_capture_started`, `GlobalReachReport`.`robb_desktop`, `GlobalReachReport`.`robb_mobile`, `GlobalReachReport`.`robb_expires`, `GlobalReachReport`.`robb_capture_started`, `GlobalReachReport`.`juwai_desktop`, `GlobalReachReport`.`juwai_mobile`, `GlobalReachReport`.`juwai_expires`, `GlobalReachReport`.`juwai_capture_started`, `GlobalReachReport`.`leverage_desktop`, `GlobalReachReport`.`leverage_mobile`, `GlobalReachReport`.`leverage_expires`, `GlobalReachReport`.`leverage_capture_started`, `GlobalReachReport`.`created`, `GlobalReachReport`.`modified` FROM `leveragere_staging2`.`properties` AS `Property` LEFT JOIN `leveragere_staging2`.`property_categories` AS `PrimaryPropertyCategory` ON (`Property`.`primary_property_category_id` = `PrimaryPropertyCategory`.`id`) LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Property`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`stripe_subscriptions` AS `StripeSubscription` ON (`StripeSubscription`.`property_id` = `Property`.`id` AND `StripeSubscription`.`status` = 'active') LEFT JOIN `leveragere_staging2`.`global_reach_reports` AS `GlobalReachReport` ON (`GlobalReachReport`.`property_id` = `Property`.`id`) WHERE `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`id` != 3344 AND `Property`.`brokerage_id` = 214 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 (3517, 3342) ORDER BY `Image`.`order` ASC	4	4	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 (3517, 3342) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	1	1	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 (3517, 3342) 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 (3517, 3342) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	0	0	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 (3517, 3342) 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` = 214 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` = 214 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 (3346, 3546, 2581, 2566) ORDER BY `Image`.`order` ASC	11	11	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 (3346, 3546, 2581, 2566) 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 (3346, 3546, 2581, 2566) 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 (3346, 3546, 2581, 2566) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	6	6	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (3346, 3546, 2581, 2566) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 14.29 MB

Message	Memory use
Component initialization	3.09 MB
Controller action start	4.02 MB
Controller render start	6.75 MB
View render complete	7.26 MB

Timers

Total Request Time: 234 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	29.46
Event: Controller.initialize	3.87
Event: Controller.startup	1.51
Controller action	37.75
Event: Controller.beforeRender	14.41
» Processing toolbar data	14.32
Rendering View	116.92
» Event: View.beforeRender	0.28
» Rendering APP/View/Properties/view.ctp	3.23
» » Rendering APP/View/Elements/static_property_price.ctp	0.41
» » Rendering APP/View/Elements/property_features.ctp	0.23
» » Rendering APP/View/Elements/static_property_price.ctp #2	0.15
» » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.16
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.01
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #5	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #6	0.15
» » » 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	112.72
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)
 id3346
 brokerage_id214
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id1117
 agent_2_id0
 agent_3_id0
 nameConstellation at Northstar
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionConstellation Residences at Northstar Phase I - Closeout. Beautifully appointed. Fully furnished. Directly attached to The Ritz-Carlton, Lake Tahoe and, a quick stroll from the ski way, trails, and gondola for ultimate winter and summer adventures. This special layout features a large den currently set up as a bunk room and separate space as an office or family game area. Ownership offers an elevated level of services and amenities including access to pools, spa, concierge, ski valet, and much more.
 address13051 Ritz Carlton Highlands Court
 address_2
 cityTruckee
 stateCA
 postal_code96161
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1215500
 price_20
 price_usd1215500
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms2
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1pool
 icon_2gym
 icon_3views
 icon_4
 icon_5
 icon_6
 websitehttp://tahoemountainrealty.idxbroker.com/idx/details/listing/b228/20153280/13051-Ritz-Carlton-Highlands-Ct
 meta_titleConstellation at Northstar | Truckee Real Estate | Tahoe Mountain Realty
 meta_description13051 Ritz Carlton Highlands Court is a property offered for sale in Truckee, CA, USA, presented by Tahoe Mountain Realty
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built2009
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num20153280
 wsj_property_typecondominium
 nyt_property_type5
 nyt_popular_features
 propgolux_property_type6
 juwai_property_type
 juwai_category
 propgolux_property_style16
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude39.267342
 longitude-120.129440
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-01-27 16:26:29
 uri/property-detail/3346/13051-ritz-carlton-highlands-court-truckee-ca-96161-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3346/13051-ritz-carlton-highlands-court-truckee-ca-96161-usa
 address_concat13051 Ritz Carlton Highlands Court Truckee CA 96161 USA
 google_maps_query_string13051+Ritz+Carlton+Highlands+Court++Truckee+CA+96161+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,215,500
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty2
 bathrooms_pretty2
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2016-01-27
 overridden_brokerage_nameTahoe Mountain Realty
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id214
 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_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2508245
 timezoneUS/Pacific
 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
 nameTahoe Mountain Realty
 broker_of_record_name
 short_nameTahoe Mountain Realty
 usernameTahoeMountainRealty
 password4cef6eba416704066d3a8b841f2c8f2c4c322fea
 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
 descriptionTahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, Northstar, Mountainside at Northstar, Lahontan, Schaffer's Mill, Old Greenwood, and Gray's Crossing, CA, USA. They are the leading brokerage for high end boutique luxury real estate with expertise in the most sought after resort communities and Tahoe lakefront properties in the North Tahoe region. TAHOE MARKET EXPERTS With a team of over 20 real estate professionals who love living the Tahoe life and enjoy helping others find their Tahoe dream, TMR is pleased to help you and your family with all your Tahoe real estate needs. Our successful sales history begins with our absolute focus on client service and includes many market advantages, such as, our high-traffic sales galleries in The Village at Northstar, The Ritz-Carlton, Gray's Crossing and Old Greenwood, the area’s largest and most productive database of prospective buyers and data driven marketing programs.
 communitiesTruckee Northstar Mountainside at Northstar Lahontan Schaffer's Mill Old Greenwood Gray's Crossing
 websitehttp://www.tmrrealestate.com/
 address3001 Northstar Drive Suite 100
 address_2PO Box 3757
 cityTruckee
 stateCA
 full_stateCalifornia
 countryUSA
 marketTruckee, Lake Tahoe
 market_2
 postal_code96160
 phone(530) 550-2000
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTahoe Market Experts
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-tahoe-mountain-realty/
 contact_big_profile_link_textMeet The Team at Tahoe Mountain Realty
 contact_titleLuxury Real Estate Professionals
 contact_dre_num
 contact_quoteWe invite you to contact us about Truckee, Lake Tahoe real estate
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename214.jpg
 logo_filename214.png
 contact_image_filename214.jpg
 all_properties_link_image_filename214.jpg
 all_properties_linkhttp://tahoemountainrealty.idxbroker.com/idx/featured
 video_embed_code
 contact_video_embed_code
 meta_titleTruckee Real Estate⎜Tahoe Mountain Realty⎜Leverage Global Partners
 meta_descriptionTahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, CA, USA.
 meta_keywordsTahoe Mountain Realty, Truckee Real Estate, Northstar Real Estate, Mountainside at Northstar Real Estate, Lahontan Real Estate, Schaffer's Mill Real Estate, Old Greenwood Real Estate, Gray's Crossing Real Estate, California Real Estate, Leverage Global Partners, Jeff Brown
 login_message_counter1
 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-07-21 10:20:40
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/214/tahoe-mountain-realty
 website_shortwww.tmrrealestate.com
 name_with_locationTahoe Mountain Realty
 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)
 id18935
 modelProperty
 model_id3346
 tagImage
 name32447.jpg
 typeimage/jpg
 size951685
 uri/assets/18935.jpg
 order0
 created2016-04-07 17:13:02
 modified2016-04-07 17:13:02
 1(array)
 id18936
 modelProperty
 model_id3346
 tagImage
 name32448.jpg
 typeimage/jpg
 size1790181
 uri/assets/18936.jpg
 order1
 created2016-04-07 17:13:02
 modified2016-04-07 17:13:03
 User(array)
 0(array)
 id1201
 typeAgent
 brokerage_id214
 email[email protected]
 passworde76e28f9b398a9866de0e18154dab41547af04e6
 recover_hash
 first_nameRidge
 last_nameCowee
 title
 dre_num
 phone5305502000
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:58
 created2017-08-07 15:23:58
 notified(false)
 full_nameRidge Cowee
 uri/agent-detail/1201/ridge-cowee
 profile_complete(true)
 UsersProperty(array)
 id1009
 user_id1201
 property_id3346
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id4024
 property_id3346
 property_feature_id12
 1(array)
 id6
 nameGym
 additional(false)
 created2016-04-07 14:02:29
 modified2016-04-07 14:02:29
 PropertiesPropertyFeature(array)
 id4025
 property_id3346
 property_feature_id6
 2(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id4026
 property_id3346
 property_feature_id14
 Topic(empty)
 1(array)
 Property(array)
 id3546
 brokerage_id214
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id1118
 agent_2_id0
 agent_3_id0
 nameNorthstar Penthouse
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionIconic Great Bear Lodge top floor furnished penthouse with high ceilings & a great room perfect for all family gatherings. The kitchen is the center of attention, the chef is never left out of the fun. All four bedrooms are en-suite. This is the Best of the Best in the Village at Northstar. Walk just steps to the gondola and ski home at the end of the day. Restaurant options just at the bottom of your elevator. Watch the kids on the ice rink and have the best view in the house for New Year's Eve fireworks!
 address5001 Northstar Drive Unit#507
 address_2
 cityTruckee
 stateCA
 postal_code96161
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2295000
 price_20
 price_usd2295000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet2780
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1sq-ft
 icon_2balcony-terrace
 icon_3garage
 icon_4office
 icon_5
 icon_6
 websitehttp://tahoemountainrealty.idxbroker.com/idx/details/listing/b228/20160427/5001-Northstar-Drive
 meta_titleNorthstar Penthouse | Truckee Real Estate | Tahoe Mountain Realty
 meta_description5001 Northstar Drive Unit#507 is a property offered for sale in Truckee, CA, USA, presented by Tahoe Mountain Realty
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built2005
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num20160427
 wsj_property_typecondominium
 nyt_property_type5
 nyt_popular_features
 propgolux_property_type2
 juwai_property_type
 juwai_category
 propgolux_property_style16
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude39.274971
 longitude-120.120796
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2016-03-03 13:49:00
 uri/property-detail/3546/5001-northstar-drive-unit-507-truckee-ca-96161-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3546/5001-northstar-drive-unit-507-truckee-ca-96161-usa
 address_concat5001 Northstar Drive Unit#507 Truckee CA 96161 USA
 google_maps_query_string5001+Northstar+Drive++Unit%23507++Truckee+CA+96161+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 2,295,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty4
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2016-03-03
 overridden_brokerage_nameTahoe Mountain Realty
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id214
 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_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2508245
 timezoneUS/Pacific
 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
 nameTahoe Mountain Realty
 broker_of_record_name
 short_nameTahoe Mountain Realty
 usernameTahoeMountainRealty
 password4cef6eba416704066d3a8b841f2c8f2c4c322fea
 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
 descriptionTahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, Northstar, Mountainside at Northstar, Lahontan, Schaffer's Mill, Old Greenwood, and Gray's Crossing, CA, USA. They are the leading brokerage for high end boutique luxury real estate with expertise in the most sought after resort communities and Tahoe lakefront properties in the North Tahoe region. TAHOE MARKET EXPERTS With a team of over 20 real estate professionals who love living the Tahoe life and enjoy helping others find their Tahoe dream, TMR is pleased to help you and your family with all your Tahoe real estate needs. Our successful sales history begins with our absolute focus on client service and includes many market advantages, such as, our high-traffic sales galleries in The Village at Northstar, The Ritz-Carlton, Gray's Crossing and Old Greenwood, the area’s largest and most productive database of prospective buyers and data driven marketing programs.
 communitiesTruckee Northstar Mountainside at Northstar Lahontan Schaffer's Mill Old Greenwood Gray's Crossing
 websitehttp://www.tmrrealestate.com/
 address3001 Northstar Drive Suite 100
 address_2PO Box 3757
 cityTruckee
 stateCA
 full_stateCalifornia
 countryUSA
 marketTruckee, Lake Tahoe
 market_2
 postal_code96160
 phone(530) 550-2000
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTahoe Market Experts
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-tahoe-mountain-realty/
 contact_big_profile_link_textMeet The Team at Tahoe Mountain Realty
 contact_titleLuxury Real Estate Professionals
 contact_dre_num
 contact_quoteWe invite you to contact us about Truckee, Lake Tahoe real estate
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename214.jpg
 logo_filename214.png
 contact_image_filename214.jpg
 all_properties_link_image_filename214.jpg
 all_properties_linkhttp://tahoemountainrealty.idxbroker.com/idx/featured
 video_embed_code
 contact_video_embed_code
 meta_titleTruckee Real Estate⎜Tahoe Mountain Realty⎜Leverage Global Partners
 meta_descriptionTahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, CA, USA.
 meta_keywordsTahoe Mountain Realty, Truckee Real Estate, Northstar Real Estate, Mountainside at Northstar Real Estate, Lahontan Real Estate, Schaffer's Mill Real Estate, Old Greenwood Real Estate, Gray's Crossing Real Estate, California Real Estate, Leverage Global Partners, Jeff Brown
 login_message_counter1
 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-07-21 10:20:40
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/214/tahoe-mountain-realty
 website_shortwww.tmrrealestate.com
 name_with_locationTahoe Mountain Realty
 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)
 id16861
 modelProperty
 model_id3546
 tagImage
 name34481.jpg
 typeimage/jpg
 size650092
 uri/assets/16861.jpg
 order1
 created2016-04-07 17:00:13
 modified2016-04-07 17:00:13
 1(array)
 id16862
 modelProperty
 model_id3546
 tagImage
 name34482.jpg
 typeimage/jpg
 size737233
 uri/assets/16862.jpg
 order2
 created2016-04-07 17:00:14
 modified2016-04-07 17:00:14
 2(array)
 id16863
 modelProperty
 model_id3546
 tagImage
 name34483.jpg
 typeimage/jpg
 size486321
 uri/assets/16863.jpg
 order3
 created2016-04-07 17:00:14
 modified2016-04-07 17:00:14
 3(array)
 id16864
 modelProperty
 model_id3546
 tagImage
 name34484.jpg
 typeimage/jpg
 size424150
 uri/assets/16864.jpg
 order4
 created2016-04-07 17:00:14
 modified2016-04-07 17:00:14
 4(array)
 id16860
 modelProperty
 model_id3546
 tagImage
 name34480.jpg
 typeimage/jpg
 size505933
 uri/assets/16860.jpg
 order2738
 created2016-04-07 17:00:13
 modified2016-04-07 17:00:13
 User(array)
 0(array)
 id1202
 typeAgent
 brokerage_id214
 email[email protected]
 password087466087302401c0a5b7ab19ed837ac635ff77d
 recover_hash
 first_nameDoug
 last_nameFlynn
 title
 dre_num
 phone5305502000
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:58
 created2017-08-07 15:23:58
 notified(false)
 full_nameDoug Flynn
 uri/agent-detail/1202/doug-flynn
 profile_complete(true)
 UsersProperty(array)
 id1010
 user_id1202
 property_id3546
 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)
 id3510
 property_id3546
 property_feature_id1
 1(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id3511
 property_id3546
 property_feature_id4
 2(array)
 id9
 nameOffice
 additional(false)
 created2016-04-07 14:03:21
 modified2016-04-07 14:03:21
 PropertiesPropertyFeature(array)
 id3512
 property_id3546
 property_feature_id9
 Topic(empty)
 2(array)
 Property(array)
 id2581
 brokerage_id214
 created_by_user_id0
 order5
 multi_unit(false)
 agent_1_id794
 agent_2_id0
 agent_3_id0
 nameNorthstar Village Walk
 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)
 descriptionNorthstar luxury 4-br townhome is mountain sophistication at its best. Northstar's ski mountain & vibrant Village are within steps of your home. Walk to the gondola to go up the mountain & the Ritz-Carlton where you begin the ski day, dine or pamper yourself at the spa. Enjoy mountain views from your private deck. Fenced backyard for your four-legged family members. Relax in your private hot tub, BBQ, walk to Starbucks or enjoy your swim & fitness center. Ultimate convenience & luxury awaits!
 address7243 Larkspur Lane
 address_2Residence 11
 cityTruckee
 stateCalifornia
 postal_code96161
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1695000
 price_20
 price_usd1695000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet2640
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1sq-ft
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://tahoemountainrealty.idxbroker.com/idx/details/listing/b228/20151725/7243-Larkspur-Lane
 meta_titleNorthstar Village Walk | Truckee Real Estate | Tahoe Mountain Realty
 meta_description7243 Larkspur Lane Residence 11 is a property offered for sale in Truckee, California, USA, presented by Tahoe Mountain Realty
 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_meters, acres, hectares, year_built, virtual_tour, video_tour, wsj_property_type, nyt_property_type
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-08-04 09:47:49
 uri/property-detail/2581/7243-larkspur-lane-residence-11-truckee-california-96161-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2581/7243-larkspur-lane-residence-11-truckee-california-96161-usa
 address_concat7243 Larkspur Lane Residence 11 Truckee California 96161 USA
 google_maps_query_string7243+Larkspur+Lane++Residence+11++Truckee+California+96161++USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,695,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty4
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2015-08-04
 overridden_brokerage_nameTahoe Mountain Realty
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id214
 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_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2508245
 timezoneUS/Pacific
 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
 nameTahoe Mountain Realty
 broker_of_record_name
 short_nameTahoe Mountain Realty
 usernameTahoeMountainRealty
 password4cef6eba416704066d3a8b841f2c8f2c4c322fea
 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
 descriptionTahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, Northstar, Mountainside at Northstar, Lahontan, Schaffer's Mill, Old Greenwood, and Gray's Crossing, CA, USA. They are the leading brokerage for high end boutique luxury real estate with expertise in the most sought after resort communities and Tahoe lakefront properties in the North Tahoe region. TAHOE MARKET EXPERTS With a team of over 20 real estate professionals who love living the Tahoe life and enjoy helping others find their Tahoe dream, TMR is pleased to help you and your family with all your Tahoe real estate needs. Our successful sales history begins with our absolute focus on client service and includes many market advantages, such as, our high-traffic sales galleries in The Village at Northstar, The Ritz-Carlton, Gray's Crossing and Old Greenwood, the area’s largest and most productive database of prospective buyers and data driven marketing programs.
 communitiesTruckee Northstar Mountainside at Northstar Lahontan Schaffer's Mill Old Greenwood Gray's Crossing
 websitehttp://www.tmrrealestate.com/
 address3001 Northstar Drive Suite 100
 address_2PO Box 3757
 cityTruckee
 stateCA
 full_stateCalifornia
 countryUSA
 marketTruckee, Lake Tahoe
 market_2
 postal_code96160
 phone(530) 550-2000
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTahoe Market Experts
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-tahoe-mountain-realty/
 contact_big_profile_link_textMeet The Team at Tahoe Mountain Realty
 contact_titleLuxury Real Estate Professionals
 contact_dre_num
 contact_quoteWe invite you to contact us about Truckee, Lake Tahoe real estate
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename214.jpg
 logo_filename214.png
 contact_image_filename214.jpg
 all_properties_link_image_filename214.jpg
 all_properties_linkhttp://tahoemountainrealty.idxbroker.com/idx/featured
 video_embed_code
 contact_video_embed_code
 meta_titleTruckee Real Estate⎜Tahoe Mountain Realty⎜Leverage Global Partners
 meta_descriptionTahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, CA, USA.
 meta_keywordsTahoe Mountain Realty, Truckee Real Estate, Northstar Real Estate, Mountainside at Northstar Real Estate, Lahontan Real Estate, Schaffer's Mill Real Estate, Old Greenwood Real Estate, Gray's Crossing Real Estate, California Real Estate, Leverage Global Partners, Jeff Brown
 login_message_counter1
 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-07-21 10:20:40
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/214/tahoe-mountain-realty
 website_shortwww.tmrrealestate.com
 name_with_locationTahoe Mountain Realty
 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)
 id16035
 modelProperty
 model_id2581
 tagImage
 name24146.jpg
 typeimage/jpg
 size506683
 uri/assets/16035.jpg
 order0
 created2016-04-07 16:56:02
 modified2016-04-07 16:56:02
 User(array)
 0(array)
 id983
 typeAgent
 brokerage_id214
 email[email protected]
 passwordec5df3a5649460f62cff47db541395ec25abebf8
 recover_hash
 first_nameLiza
 last_nameKillen
 title
 dre_num
 phone530-448-5111
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:46
 created2017-08-07 15:23:46
 notified(false)
 full_nameLiza Killen
 uri/agent-detail/983/liza-killen
 profile_complete(true)
 UsersProperty(array)
 id737
 user_id983
 property_id2581
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 3(array)
 Property(array)
 id2566
 brokerage_id214
 created_by_user_id0
 order3
 multi_unit(false)
 agent_1_id784
 agent_2_id0
 agent_3_id0
 nameMartis Camp
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionA distinctive cabin in Martis Camp that lives like an estate home with all the benefits of a prime amenity core location. The trail system, Putting Park and Family Barn are all steps away. Enjoy the Tahoe air with over 1,500 sf of outdoor living spaces. Flexibility in design gives you options to customize with a reading room (4th bedroom), media room, and an office. The refreshing architecture and clean presentation make this retreat a perfect combination of everything you are looking for in Martis Camp.
 address8670 Huntington Court
 address_2
 cityTruckee
 stateCA
 postal_code96161
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price3375000
 price_20
 price_usd3375000
 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)
 bedrooms3
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet3247
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1sq-ft
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://tahoemountainrealty.idxbroker.com/idx/details/listing/b228/20153005/8670-Huntington-Court
 meta_titleMartis Camp | Truckee Real Estate | Tahoe Mountain Realty
 meta_description8670 Huntington Court is a property offered for sale in Truckee, CA, USA, presented by Tahoe Mountain Realty
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built2013
 virtual_tour
 video_tourhttps://vimeo.com/157192354
 digital_brochure
 video_tour_embed_code<iframe src="https://player.vimeo.com/video/133725809?color=ffffff&title=0&byline=0&portrait=0" width="500" height="281" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>
 digital_brochure_embed_code
 mls_num20153005
 wsj_property_typesingle family
 nyt_property_type1
 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
 latitude39.288792
 longitude-120.165428
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, bathrooms_partial, square_meters, acres, hectares, virtual_tour, 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-07-28 14:03:39
 uri/property-detail/2566/8670-huntington-court-truckee-ca-96161-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2566/8670-huntington-court-truckee-ca-96161-usa
 address_concat8670 Huntington Court Truckee CA 96161 USA
 google_maps_query_string8670+Huntington+Court++Truckee+CA+96161+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 3,375,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty4
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2015-07-28
 overridden_brokerage_nameTahoe Mountain Realty
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id214
 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_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2508245
 timezoneUS/Pacific
 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
 nameTahoe Mountain Realty
 broker_of_record_name
 short_nameTahoe Mountain Realty
 usernameTahoeMountainRealty
 password4cef6eba416704066d3a8b841f2c8f2c4c322fea
 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
 descriptionTahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, Northstar, Mountainside at Northstar, Lahontan, Schaffer's Mill, Old Greenwood, and Gray's Crossing, CA, USA. They are the leading brokerage for high end boutique luxury real estate with expertise in the most sought after resort communities and Tahoe lakefront properties in the North Tahoe region. TAHOE MARKET EXPERTS With a team of over 20 real estate professionals who love living the Tahoe life and enjoy helping others find their Tahoe dream, TMR is pleased to help you and your family with all your Tahoe real estate needs. Our successful sales history begins with our absolute focus on client service and includes many market advantages, such as, our high-traffic sales galleries in The Village at Northstar, The Ritz-Carlton, Gray's Crossing and Old Greenwood, the area’s largest and most productive database of prospective buyers and data driven marketing programs.
 communitiesTruckee Northstar Mountainside at Northstar Lahontan Schaffer's Mill Old Greenwood Gray's Crossing
 websitehttp://www.tmrrealestate.com/
 address3001 Northstar Drive Suite 100
 address_2PO Box 3757
 cityTruckee
 stateCA
 full_stateCalifornia
 countryUSA
 marketTruckee, Lake Tahoe
 market_2
 postal_code96160
 phone(530) 550-2000
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTahoe Market Experts
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-tahoe-mountain-realty/
 contact_big_profile_link_textMeet The Team at Tahoe Mountain Realty
 contact_titleLuxury Real Estate Professionals
 contact_dre_num
 contact_quoteWe invite you to contact us about Truckee, Lake Tahoe real estate
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename214.jpg
 logo_filename214.png
 contact_image_filename214.jpg
 all_properties_link_image_filename214.jpg
 all_properties_linkhttp://tahoemountainrealty.idxbroker.com/idx/featured
 video_embed_code
 contact_video_embed_code
 meta_titleTruckee Real Estate⎜Tahoe Mountain Realty⎜Leverage Global Partners
 meta_descriptionTahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, CA, USA.
 meta_keywordsTahoe Mountain Realty, Truckee Real Estate, Northstar Real Estate, Mountainside at Northstar Real Estate, Lahontan Real Estate, Schaffer's Mill Real Estate, Old Greenwood Real Estate, Gray's Crossing Real Estate, California Real Estate, Leverage Global Partners, Jeff Brown
 login_message_counter1
 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-07-21 10:20:40
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/214/tahoe-mountain-realty
 website_shortwww.tmrrealestate.com
 name_with_locationTahoe Mountain Realty
 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)
 id16003
 modelProperty
 model_id2566
 tagImage
 name23997.jpg
 typeimage/jpg
 size1763469
 uri/assets/16003.jpg
 order0
 created2016-04-07 16:55:08
 modified2016-04-07 16:55:08
 1(array)
 id16002
 modelProperty
 model_id2566
 tagImage
 name23998.jpg
 typeimage/jpg
 size1022894
 uri/assets/16002.jpg
 order1
 created2016-04-07 16:55:08
 modified2016-04-07 16:55:08
 2(array)
 id16004
 modelProperty
 model_id2566
 tagImage
 name23999.jpg
 typeimage/jpg
 size1170001
 uri/assets/16004.jpg
 order2
 created2016-04-07 16:55:08
 modified2016-04-07 16:55:08
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
- sidebar_locations(array)
 0(array)
 Location(array)
 id45
 parent_id9
 brokerage_id214
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameTruckee, Lake Tahoe, CA, USA
 short_nameTruckee, Lake Tahoe, CA, USA
 group_index
 latitude39.327961
 longitude-120.183250
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 12:48:14
 modified2016-04-04 12:48:14
 timezoneAmerica/Los_Angeles
 population16000
 uri/locations/view/45/truckee-lake-tahoe-ca-usa
 tile_nameTruckee, Lake Tahoe, CA, USA
 Brokerage(array)
 id214
 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_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2508245
 timezoneUS/Pacific
 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
 nameTahoe Mountain Realty
 broker_of_record_name
 short_nameTahoe Mountain Realty
 usernameTahoeMountainRealty
 password4cef6eba416704066d3a8b841f2c8f2c4c322fea
 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
 descriptionTahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, Northstar, Mountainside at Northstar, Lahontan, Schaffer's Mill, Old Greenwood, and Gray's Crossing, CA, USA. They are the leading brokerage for high end boutique luxury real estate with expertise in the most sought after resort communities and Tahoe lakefront properties in the North Tahoe region. TAHOE MARKET EXPERTS With a team of over 20 real estate professionals who love living the Tahoe life and enjoy helping others find their Tahoe dream, TMR is pleased to help you and your family with all your Tahoe real estate needs. Our successful sales history begins with our absolute focus on client service and includes many market advantages, such as, our high-traffic sales galleries in The Village at Northstar, The Ritz-Carlton, Gray's Crossing and Old Greenwood, the area’s largest and most productive database of prospective buyers and data driven marketing programs.
 communitiesTruckee Northstar Mountainside at Northstar Lahontan Schaffer's Mill Old Greenwood Gray's Crossing
 websitehttp://www.tmrrealestate.com/
 address3001 Northstar Drive Suite 100
 address_2PO Box 3757
 cityTruckee
 stateCA
 full_stateCalifornia
 countryUSA
 marketTruckee, Lake Tahoe
 market_2
 postal_code96160
 phone(530) 550-2000
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTahoe Market Experts
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-tahoe-mountain-realty/
 contact_big_profile_link_textMeet The Team at Tahoe Mountain Realty
 contact_titleLuxury Real Estate Professionals
 contact_dre_num
 contact_quoteWe invite you to contact us about Truckee, Lake Tahoe real estate
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename214.jpg
 logo_filename214.png
 contact_image_filename214.jpg
 all_properties_link_image_filename214.jpg
 all_properties_linkhttp://tahoemountainrealty.idxbroker.com/idx/featured
 video_embed_code
 contact_video_embed_code
 meta_titleTruckee Real Estate⎜Tahoe Mountain Realty⎜Leverage Global Partners
 meta_descriptionTahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, CA, USA.
 meta_keywordsTahoe Mountain Realty, Truckee Real Estate, Northstar Real Estate, Mountainside at Northstar Real Estate, Lahontan Real Estate, Schaffer's Mill Real Estate, Old Greenwood Real Estate, Gray's Crossing Real Estate, California Real Estate, Leverage Global Partners, Jeff Brown
 login_message_counter1
 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-07-21 10:20:40
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/214/tahoe-mountain-realty
 website_shortwww.tmrrealestate.com
 name_with_locationTahoe Mountain Realty
 Image(array)
 id2974
 modelLocation
 model_id45
 tagImage
 nameTruckee.jpg
 typeimage/jpeg
 size132695
 uri/assets/2974.jpg
 order0
 created2016-04-04 12:48:06
 modified2016-04-04 12:48:14
- highlighted_properties(array)
 0(array)
 Property(array)
 id3517
 brokerage_id214
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id786
 agent_2_id0
 agent_3_id0
 nameMartis Camp Ski in/out
 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)
 descriptionLike having your own private Ski Resort. Skiing/riding doesn’t get more luxurious than skiing directly in and out of your private 1+ acre estate directly adjacent to the Washoe and Martis Ski Run and is also just footsteps form the Martis Camp Ski Lodge. This phenomenal location is on a private cul-de-sac, southern exposure, over 180 degree panoramic views. This is a rare opportunity to own perhaps the very best Ski-In/Ski-Out property in MC. Build your dream resort home now, a legacy of lifetime memories.
 address9486 Clermont Court
 address_2
 cityTruckee
 stateCA
 postal_code96161
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2495000
 price_20
 price_usd2495000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(true)
 bedrooms0
 bedrooms_20
 bathrooms0
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://tahoemountainrealty.idxbroker.com/idx/details/listing/b228/20160070/9486-Clermont-Court
 meta_titleMartis Camp Ski in/out | Truckee Real Estate | Tahoe Mountain Realty
 meta_description9486 Clermont Court is a property offered for sale in Truckee, CA, USA, presented by Tahoe Mountain Realty
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tourhttps://vimeo.com/157192354
 digital_brochure
 video_tour_embed_code<iframe src="https://player.vimeo.com/video/157192354?title=0&byline=0&portrait=0" width="500" height="281" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>
 digital_brochure_embed_code
 mls_num20160070
 wsj_property_typelot
 nyt_property_type8
 nyt_popular_features
 propgolux_property_type8
 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
 latitude39.277077
 longitude-120.144371
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, bathrooms_partial, square_feet, square_meters, acres, hectares, year_built, virtual_tour, 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
 created2016-02-29 12:31:49
 uri/property-detail/3517/9486-clermont-court-truckee-ca-96161-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3517/9486-clermont-court-truckee-ca-96161-usa
 address_concat9486 Clermont Court Truckee CA 96161 USA
 google_maps_query_string9486+Clermont+Court++Truckee+CA+96161+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,495,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty0
 bathrooms_pretty0
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms0
 date_listed2016-02-29
 overridden_brokerage_nameTahoe Mountain Realty
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id214
 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_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2508245
 timezoneUS/Pacific
 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
 nameTahoe Mountain Realty
 broker_of_record_name
 short_nameTahoe Mountain Realty
 usernameTahoeMountainRealty
 password4cef6eba416704066d3a8b841f2c8f2c4c322fea
 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
 descriptionTahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, Northstar, Mountainside at Northstar, Lahontan, Schaffer's Mill, Old Greenwood, and Gray's Crossing, CA, USA. They are the leading brokerage for high end boutique luxury real estate with expertise in the most sought after resort communities and Tahoe lakefront properties in the North Tahoe region. TAHOE MARKET EXPERTS With a team of over 20 real estate professionals who love living the Tahoe life and enjoy helping others find their Tahoe dream, TMR is pleased to help you and your family with all your Tahoe real estate needs. Our successful sales history begins with our absolute focus on client service and includes many market advantages, such as, our high-traffic sales galleries in The Village at Northstar, The Ritz-Carlton, Gray's Crossing and Old Greenwood, the area’s largest and most productive database of prospective buyers and data driven marketing programs.
 communitiesTruckee Northstar Mountainside at Northstar Lahontan Schaffer's Mill Old Greenwood Gray's Crossing
 websitehttp://www.tmrrealestate.com/
 address3001 Northstar Drive Suite 100
 address_2PO Box 3757
 cityTruckee
 stateCA
 full_stateCalifornia
 countryUSA
 marketTruckee, Lake Tahoe
 market_2
 postal_code96160
 phone(530) 550-2000
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTahoe Market Experts
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-tahoe-mountain-realty/
 contact_big_profile_link_textMeet The Team at Tahoe Mountain Realty
 contact_titleLuxury Real Estate Professionals
 contact_dre_num
 contact_quoteWe invite you to contact us about Truckee, Lake Tahoe real estate
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename214.jpg
 logo_filename214.png
 contact_image_filename214.jpg
 all_properties_link_image_filename214.jpg
 all_properties_linkhttp://tahoemountainrealty.idxbroker.com/idx/featured
 video_embed_code
 contact_video_embed_code
 meta_titleTruckee Real Estate⎜Tahoe Mountain Realty⎜Leverage Global Partners
 meta_descriptionTahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, CA, USA.
 meta_keywordsTahoe Mountain Realty, Truckee Real Estate, Northstar Real Estate, Mountainside at Northstar Real Estate, Lahontan Real Estate, Schaffer's Mill Real Estate, Old Greenwood Real Estate, Gray's Crossing Real Estate, California Real Estate, Leverage Global Partners, Jeff Brown
 login_message_counter1
 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-07-21 10:20:40
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/214/tahoe-mountain-realty
 website_shortwww.tmrrealestate.com
 name_with_locationTahoe Mountain Realty
 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)
 id15282
 modelProperty
 model_id3517
 tagImage
 name34199.jpg
 typeimage/jpg
 size1376950
 uri/assets/15282.jpg
 order1
 created2016-04-07 16:51:03
 modified2016-04-07 16:51:03
 1(array)
 id15281
 modelProperty
 model_id3517
 tagImage
 name34198.jpg
 typeimage/jpg
 size1384093
 uri/assets/15281.jpg
 order2728
 created2016-04-07 16:51:03
 modified2016-04-07 16:51:03
 User(array)
 0(array)
 id976
 typeAgent
 brokerage_id214
 email[email protected]
 password8d48dd4d6f91e079f9baba504a57c8092dc3b200
 recover_hash
 first_nameSteve
 last_nameKegel
 title
 dre_num
 phone5305502023
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:46
 created2017-08-07 15:23:46
 notified(false)
 full_nameSteve Kegel
 uri/agent-detail/976/steve-kegel
 profile_complete(true)
 UsersProperty(array)
 id733
 user_id976
 property_id3517
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 1(array)
 Property(array)
 id3342
 brokerage_id214
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id784
 agent_2_id0
 agent_3_id0
 nameNorthstar
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(true)
 large_featured(true)
 detail_page(true)
 descriptionWelcome to a timeless retreat of the West, crafted with hand-picked native materials. A thoughtful design with an easy flow, the open kitchen and gathering spaces are connected encouraging lively parties and quiet moments alike. Each of the 4 bedrooms has its own bath and living space, enhancing privacy for family or guests. Wrap around outdoor living captures the sun and mountain vistas during all times of the day. Northstar ski and hiking trails are steps from the door. Your Tahoe story begins here.
 address1938 Gray Wolf
 address_2
 cityTruckee
 stateCA
 postal_code96161
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2995000
 price_20
 price_usd2995000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://tahoemountainrealty.idxbroker.com/idx/details/listing/b228/20160054/1938-Gray-Wolf
 meta_titleNorthstar | Truckee Real Estate | Tahoe Mountain Realty
 meta_description1938 Gray Wolf is a property offered for sale in Truckee, CA, USA, presented by Tahoe Mountain Realty
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1999
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num20160054
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style32
 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
 latitude39.279228
 longitude-120.129364
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-01-27 13:47:05
 uri/property-detail/3342/1938-gray-wolf-truckee-ca-96161-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3342/1938-gray-wolf-truckee-ca-96161-usa
 address_concat1938 Gray Wolf Truckee CA 96161 USA
 google_maps_query_string1938+Gray+Wolf++Truckee+CA+96161+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 2,995,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty4
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2016-01-27
 overridden_brokerage_nameTahoe Mountain Realty
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id214
 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_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2508245
 timezoneUS/Pacific
 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
 nameTahoe Mountain Realty
 broker_of_record_name
 short_nameTahoe Mountain Realty
 usernameTahoeMountainRealty
 password4cef6eba416704066d3a8b841f2c8f2c4c322fea
 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
 descriptionTahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, Northstar, Mountainside at Northstar, Lahontan, Schaffer's Mill, Old Greenwood, and Gray's Crossing, CA, USA. They are the leading brokerage for high end boutique luxury real estate with expertise in the most sought after resort communities and Tahoe lakefront properties in the North Tahoe region. TAHOE MARKET EXPERTS With a team of over 20 real estate professionals who love living the Tahoe life and enjoy helping others find their Tahoe dream, TMR is pleased to help you and your family with all your Tahoe real estate needs. Our successful sales history begins with our absolute focus on client service and includes many market advantages, such as, our high-traffic sales galleries in The Village at Northstar, The Ritz-Carlton, Gray's Crossing and Old Greenwood, the area’s largest and most productive database of prospective buyers and data driven marketing programs.
 communitiesTruckee Northstar Mountainside at Northstar Lahontan Schaffer's Mill Old Greenwood Gray's Crossing
 websitehttp://www.tmrrealestate.com/
 address3001 Northstar Drive Suite 100
 address_2PO Box 3757
 cityTruckee
 stateCA
 full_stateCalifornia
 countryUSA
 marketTruckee, Lake Tahoe
 market_2
 postal_code96160
 phone(530) 550-2000
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTahoe Market Experts
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-tahoe-mountain-realty/
 contact_big_profile_link_textMeet The Team at Tahoe Mountain Realty
 contact_titleLuxury Real Estate Professionals
 contact_dre_num
 contact_quoteWe invite you to contact us about Truckee, Lake Tahoe real estate
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename214.jpg
 logo_filename214.png
 contact_image_filename214.jpg
 all_properties_link_image_filename214.jpg
 all_properties_linkhttp://tahoemountainrealty.idxbroker.com/idx/featured
 video_embed_code
 contact_video_embed_code
 meta_titleTruckee Real Estate⎜Tahoe Mountain Realty⎜Leverage Global Partners
 meta_descriptionTahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, CA, USA.
 meta_keywordsTahoe Mountain Realty, Truckee Real Estate, Northstar Real Estate, Mountainside at Northstar Real Estate, Lahontan Real Estate, Schaffer's Mill Real Estate, Old Greenwood Real Estate, Gray's Crossing Real Estate, California Real Estate, Leverage Global Partners, Jeff Brown
 login_message_counter1
 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-07-21 10:20:40
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/214/tahoe-mountain-realty
 website_shortwww.tmrrealestate.com
 name_with_locationTahoe Mountain Realty
 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)
 id18914
 modelProperty
 model_id3342
 tagImage
 name32458.jpg
 typeimage/jpg
 size1229339
 uri/assets/18914.jpg
 order1
 created2016-04-07 17:12:06
 modified2016-04-07 17:12:06
 1(array)
 id18913
 modelProperty
 model_id3342
 tagImage
 name32415.jpg
 typeimage/jpg
 size1241827
 uri/assets/18913.jpg
 order2568
 created2016-04-07 17:12:06
 modified2016-04-07 17:12:06
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
- custom_ga_event_properties(array)
 brokerageTahoe Mountain Realty, Truckee
- property(array)
 Property(array)
 id3344
 brokerage_id214
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id786
 agent_2_id0
 agent_3_id0
 nameLakefront
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionTahoe itself is a Washoe name meaning "Big Waters”. Cedar Shores exemplifies the meaning perfectly. This is the quintessential family retreat featuring one of the most pristine settings on the N Shore of Lake Tahoe. Sitting on over 1 acre with over 100 ft. of lake frontage, a main family compound + guest home comprising 8,900 sq. ft. 7+ BR, 7+ BA, office, den, gourmet kitchen, full bar, home theater, sauna, Turkish Bath, wine cellar & so much more. Create a legacy of priceless family traditions and memories.
 address1780 North Lake Boulevard
 address_2
 cityTahoe City
 stateCA
 postal_code96145
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price8495000
 price_20
 price_usd8495000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms7
 bedrooms_20
 bathrooms7
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://tahoemountainrealty.idxbroker.com/idx/details/listing/b228/20160046/1780-North-Lake-Boulevard
 meta_titleLakefront | Tahoe City Real Estate | Tahoe Mountain Realty
 meta_description1780 North Lake Boulevard is a property offered for sale in Tahoe City, CA, USA, presented by Tahoe Mountain Realty
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built2006
 virtual_tour
 video_tourhttps://vimeo.com/user40391142/cedar-shores
 digital_brochure
 video_tour_embed_code<iframe src="https://player.vimeo.com/video/153567964?title=0&byline=0&portrait=0" width="500" height="281" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>
 digital_brochure_embed_code
 mls_num20160046
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 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
 latitude39.180321
 longitude-120.129082
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, 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
 created2016-01-27 14:28:50
 uri/property-detail/3344/1780-north-lake-boulevard-tahoe-city-ca-96145-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3344/1780-north-lake-boulevard-tahoe-city-ca-96145-usa
 address_concat1780 North Lake Boulevard Tahoe City CA 96145 USA
 google_maps_query_string1780+North+Lake+Boulevard++Tahoe+City+CA+96145+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 8,495,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty7
 bathrooms_pretty7
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms7
 date_listed2016-01-27
 overridden_brokerage_nameTahoe Mountain Realty
 overridden_brokerage_logo_uri/assets/2860.png
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id214
 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_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2508245
 timezoneUS/Pacific
 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
 nameTahoe Mountain Realty
 broker_of_record_name
 short_nameTahoe Mountain Realty
 usernameTahoeMountainRealty
 password4cef6eba416704066d3a8b841f2c8f2c4c322fea
 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
 descriptionTahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, Northstar, Mountainside at Northstar, Lahontan, Schaffer's Mill, Old Greenwood, and Gray's Crossing, CA, USA. They are the leading brokerage for high end boutique luxury real estate with expertise in the most sought after resort communities and Tahoe lakefront properties in the North Tahoe region. TAHOE MARKET EXPERTS With a team of over 20 real estate professionals who love living the Tahoe life and enjoy helping others find their Tahoe dream, TMR is pleased to help you and your family with all your Tahoe real estate needs. Our successful sales history begins with our absolute focus on client service and includes many market advantages, such as, our high-traffic sales galleries in The Village at Northstar, The Ritz-Carlton, Gray's Crossing and Old Greenwood, the area’s largest and most productive database of prospective buyers and data driven marketing programs.
 communitiesTruckee Northstar Mountainside at Northstar Lahontan Schaffer's Mill Old Greenwood Gray's Crossing
 websitehttp://www.tmrrealestate.com/
 address3001 Northstar Drive Suite 100
 address_2PO Box 3757
 cityTruckee
 stateCA
 full_stateCalifornia
 countryUSA
 marketTruckee, Lake Tahoe
 market_2
 postal_code96160
 phone(530) 550-2000
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTahoe Market Experts
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-tahoe-mountain-realty/
 contact_big_profile_link_textMeet The Team at Tahoe Mountain Realty
 contact_titleLuxury Real Estate Professionals
 contact_dre_num
 contact_quoteWe invite you to contact us about Truckee, Lake Tahoe real estate
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename214.jpg
 logo_filename214.png
 contact_image_filename214.jpg
 all_properties_link_image_filename214.jpg
 all_properties_linkhttp://tahoemountainrealty.idxbroker.com/idx/featured
 video_embed_code
 contact_video_embed_code
 meta_titleTruckee Real Estate⎜Tahoe Mountain Realty⎜Leverage Global Partners
 meta_descriptionTahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, CA, USA.
 meta_keywordsTahoe Mountain Realty, Truckee Real Estate, Northstar Real Estate, Mountainside at Northstar Real Estate, Lahontan Real Estate, Schaffer's Mill Real Estate, Old Greenwood Real Estate, Gray's Crossing Real Estate, California Real Estate, Leverage Global Partners, Jeff Brown
 login_message_counter1
 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-07-21 10:20:40
 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)
 id2860
 modelBrokerage
 model_id214
 tagLogo
 name214.png
 typeimage/png
 size4055
 uri/assets/2860.png
 order0
 created2016-03-30 11:44:48
 modified2016-03-30 11:44:48
 MainImage(array)
 id2859
 modelBrokerage
 model_id214
 tagMainImage
 name214.jpg
 typeimage/jpg
 size4608006
 uri/assets/2859.jpg
 order0
 created2016-03-30 11:44:47
 modified2016-03-30 11:44:47
 ContactImage(array)
 id2861
 modelBrokerage
 model_id214
 tagContactImage
 name214.jpg
 typeimage/jpg
 size455995
 uri/assets/2861.jpg
 order0
 created2016-03-30 11:44:48
 modified2016-03-30 11:44:48
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(array)
 id396
 modelBrokerage
 model_id214
 archived(false)
 medium_featured(false)
 large_featured(false)
 titleMeet TAHOE MOUNTAIN REALTY: Truckee, Lake Tahoe, CA
 authorLeverageRE
 date2015-08-22
 lead_inGet to know Tahoe Mountain Realty, the exclusive representative for Leverage Global Partners in Truckee, Northstar, Mountainside at Northstar, Lahontan, Schaffer’s Mill, Old Greenwood, and Gray’s Crossing, CA, USA.
 body <h3> <img class="aligncenter wp-image-11125 size-full pure-img" src="/assets/2020.jpg" alt="Meet TAHOE MOUNTAIN REALTY: Truckee, Lake Tahoe, CA" width="340" height="263" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Tahoe-Rim-Trail_Katies-Collage-300x232.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Tahoe-Rim-Trail_Katies-Collage.jpg 340w" sizes="(max-width: 340px) 100vw, 340px">What was your vision in founding/working at Tahoe Mountain Realty? </h3> Tahoe Mountain Realty is built on the premise of doing something totally different from the standard brokerage model. Our team is made up of exceptional people from industries beyond real estate, each with a unique perspective and voice on the Lake Tahoe region. This has created a synergetic professional group focused on remarkable service combined with exceptional content; a collaborative environment where consumers want to do business. <h3><img class="aligncenter wp-image-11130 size-full pure-img" src="/assets/2021.jpg" alt="Meet TAHOE MOUNTAIN REALTY: Truckee, Lake Tahoe, CA" width="329" height="397" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Liza_Eagle-Rock-Family-249x300.jpg 249w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Liza_Eagle-Rock-Family.jpg 329w" sizes="(max-width: 329px) 100vw, 329px"></h3> <h3>How has technology, social media and online marketing changed and/or impacted your approach to business?</h3> We are fully immersed in technology whether using various platforms to share our content or working directly with the innovators of Silicon Valley to find mountain retreats for their families. Because our consumers are chiefs among these industries, they expect to find content through digital mediums. Through these channels we are able to demonstrate the mountain lifestyle inherent to living at Lake Tahoe alongside the actual properties themselves. All of which are terrific opportunities for us to stand out among the crowd. <img class="aligncenter wp-image-11127 size-full pure-img" src="/assets/2022.jpg" alt="Meet TAHOE MOUNTAIN REALTY: Truckee, Lake Tahoe, CA" width="370" height="333" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Shane_Parade-300x270.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Shane_Parade.jpg 370w" sizes="(max-width: 370px) 100vw, 370px"> <h3>What do you love most about working and living in Truckee, Lake Tahoe CA?</h3> The most exceptional thing about making a life in Tahoe is opportunity to be surrounded by the most exceptional collection of people imaginable. Very few people are "stuck" in a resort town against their will. As such, everyone is pursuing their passion in a beautiful environment. I love going to the coffee shop to watch Olympians interact with technology visionaries, venture capitalists and tradespeople all of whom are en route to a trail or a mountain to pursue wellbeing. <h3><img class="aligncenter wp-image-11128 size-full pure-img" src="/assets/2023.jpg" alt="Meet TAHOE MOUNTAIN REALTY: Truckee, Lake Tahoe, CA" width="400" height="400" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Team_Ski-Day_2015-150x150.jpg 150w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Team_Ski-Day_2015-300x300.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Team_Ski-Day_2015.jpg 400w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Team_Ski-Day_2015-125x125.jpg 125w" sizes="(max-width: 400px) 100vw, 400px"></h3> <h3>How do you like to spend your free time?</h3> We've worked hard to create a culture that fulfills the Tahoe Lifestyle. You'll find nearly everyone in our group out scaling a mountain or running in the forest on any given day. I'd stack up our fitness and passion for the outdoors against any other real estate brokerage out there. Among us we've covered the entire Tahoe Rim Trail, 2 Ironman finishes, a 100 mile endurance run, 25 marathons, 30 14,000 foot peaks, the entirety of Lake Tahoe on a paddle board, and a collection of very grounded yogis. Leverage Global Partners is proud to have the team at Tahoe Mountain Realty as our partners in the network.
 vimeo_id
 created2016-02-25 14:14:07
 modified2016-04-05 14:41:07
 uri/articles/view/396/meet-tahoe-mountain-realty-truckee-lake-tahoe-ca
 FeaturedImage(empty)
 Location(array)
 0(array)
 id45
 parent_id9
 brokerage_id214
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameTruckee, Lake Tahoe, CA, USA
 short_nameTruckee, Lake Tahoe, CA, USA
 group_index
 latitude39.327961
 longitude-120.183250
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 12:48:14
 modified2016-04-04 12:48:14
 timezoneAmerica/Los_Angeles
 population16000
 uri/locations/view/45/truckee-lake-tahoe-ca-usa
 tile_nameTruckee, Lake Tahoe, CA, USA
 User(array)
 0(array)
 id194
 typeBrokerageAdmin
 brokerage_id214
 email[email protected]
 password4cef6eba416704066d3a8b841f2c8f2c4c322fea
 recover_hash
 first_name
 last_name
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2016-04-12 08:31:40
 created2016-04-08 16:34:26
 notified(true)
 full_name
 uri/agent-detail/194/
 profile_complete(false)
 1(array)
 id976
 typeAgent
 brokerage_id214
 email[email protected]
 password8d48dd4d6f91e079f9baba504a57c8092dc3b200
 recover_hash
 first_nameSteve
 last_nameKegel
 title
 dre_num
 phone5305502023
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:46
 created2017-08-07 15:23:46
 notified(false)
 full_nameSteve Kegel
 uri/agent-detail/976/steve-kegel
 profile_complete(true)
 2(array)
 id983
 typeAgent
 brokerage_id214
 email[email protected]
 passwordec5df3a5649460f62cff47db541395ec25abebf8
 recover_hash
 first_nameLiza
 last_nameKillen
 title
 dre_num
 phone530-448-5111
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:46
 created2017-08-07 15:23:46
 notified(false)
 full_nameLiza Killen
 uri/agent-detail/983/liza-killen
 profile_complete(true)
 3(array)
 id1052
 typeAgent
 brokerage_id214
 email[email protected]
 passwordd2d4dfebe600ef112d2c6542b0b114000bce4668
 recover_hash
 first_nameTeddy
 last_nameRunge
 title
 dre_num
 phone530-541-9881
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:51
 created2017-08-07 15:23:51
 notified(false)
 full_nameTeddy Runge
 uri/agent-detail/1052/teddy-runge
 profile_complete(true)
 4(array)
 id1201
 typeAgent
 brokerage_id214
 email[email protected]
 passworde76e28f9b398a9866de0e18154dab41547af04e6
 recover_hash
 first_nameRidge
 last_nameCowee
 title
 dre_num
 phone5305502000
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:58
 created2017-08-07 15:23:58
 notified(false)
 full_nameRidge Cowee
 uri/agent-detail/1201/ridge-cowee
 profile_complete(true)
 5(array)
 id1202
 typeAgent
 brokerage_id214
 email[email protected]
 password087466087302401c0a5b7ab19ed837ac635ff77d
 recover_hash
 first_nameDoug
 last_nameFlynn
 title
 dre_num
 phone5305502000
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:58
 created2017-08-07 15:23:58
 notified(false)
 full_nameDoug Flynn
 uri/agent-detail/1202/doug-flynn
 profile_complete(true)
 uri/brokerage-detail/214/tahoe-mountain-realty
 website_shortwww.tmrrealestate.com
 name_with_locationTahoe Mountain Realty - Truckee, Lake Tahoe, CA, 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)
 id17764
 modelProperty
 model_id3344
 tagImage
 name32436.jpg
 typeimage/jpg
 size1289088
 uri/assets/17764.jpg
 order0
 created2016-04-07 17:06:04
 modified2016-04-07 17:06:04
 1(array)
 id17766
 modelProperty
 model_id3344
 tagImage
 name32460.jpg
 typeimage/jpg
 size1218754
 uri/assets/17766.jpg
 order1
 created2016-04-07 17:06:04
 modified2016-04-07 17:06:04
 2(array)
 id17765
 modelProperty
 model_id3344
 tagImage
 name32459.jpg
 typeimage/jpg
 size1347769
 uri/assets/17765.jpg
 order2
 created2016-04-07 17:06:04
 modified2016-04-07 17:06:04
 User(array)
 0(array)
 id976
 typeAgent
 brokerage_id214
 email[email protected]
 password8d48dd4d6f91e079f9baba504a57c8092dc3b200
 recover_hash
 first_nameSteve
 last_nameKegel
 title
 dre_num
 phone5305502023
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:46
 created2017-08-07 15:23:46
 notified(false)
 full_nameSteve Kegel
 uri/agent-detail/976/steve-kegel
 profile_complete(true)
 UsersProperty(array)
 id735
 user_id976
 property_id3344
 sort_order0
 Brokerage(array)
 id214
 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_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2508245
 timezoneUS/Pacific
 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
 nameTahoe Mountain Realty
 broker_of_record_name
 short_nameTahoe Mountain Realty
 usernameTahoeMountainRealty
 password4cef6eba416704066d3a8b841f2c8f2c4c322fea
 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
 descriptionTahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, Northstar, Mountainside at Northstar, Lahontan, Schaffer's Mill, Old Greenwood, and Gray's Crossing, CA, USA. They are the leading brokerage for high end boutique luxury real estate with expertise in the most sought after resort communities and Tahoe lakefront properties in the North Tahoe region. TAHOE MARKET EXPERTS With a team of over 20 real estate professionals who love living the Tahoe life and enjoy helping others find their Tahoe dream, TMR is pleased to help you and your family with all your Tahoe real estate needs. Our successful sales history begins with our absolute focus on client service and includes many market advantages, such as, our high-traffic sales galleries in The Village at Northstar, The Ritz-Carlton, Gray's Crossing and Old Greenwood, the area’s largest and most productive database of prospective buyers and data driven marketing programs.
 communitiesTruckee Northstar Mountainside at Northstar Lahontan Schaffer's Mill Old Greenwood Gray's Crossing
 websitehttp://www.tmrrealestate.com/
 address3001 Northstar Drive Suite 100
 address_2PO Box 3757
 cityTruckee
 stateCA
 full_stateCalifornia
 countryUSA
 marketTruckee, Lake Tahoe
 market_2
 postal_code96160
 phone(530) 550-2000
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameTahoe Market Experts
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-tahoe-mountain-realty/
 contact_big_profile_link_textMeet The Team at Tahoe Mountain Realty
 contact_titleLuxury Real Estate Professionals
 contact_dre_num
 contact_quoteWe invite you to contact us about Truckee, Lake Tahoe real estate
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename214.jpg
 logo_filename214.png
 contact_image_filename214.jpg
 all_properties_link_image_filename214.jpg
 all_properties_linkhttp://tahoemountainrealty.idxbroker.com/idx/featured
 video_embed_code
 contact_video_embed_code
 meta_titleTruckee Real Estate⎜Tahoe Mountain Realty⎜Leverage Global Partners
 meta_descriptionTahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, CA, USA.
 meta_keywordsTahoe Mountain Realty, Truckee Real Estate, Northstar Real Estate, Mountainside at Northstar Real Estate, Lahontan Real Estate, Schaffer's Mill Real Estate, Old Greenwood Real Estate, Gray's Crossing Real Estate, California Real Estate, Leverage Global Partners, Jeff Brown
 login_message_counter1
 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-07-21 10:20:40
 modified2016-04-08 16:34:26
 dre_num012345
 uri/brokerage-detail/214/tahoe-mountain-realty
 website_shortwww.tmrrealestate.com
 name_with_locationTahoe Mountain Realty
 Image(empty)
 BrokerageLogoOverride(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 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)
 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/3344/1780-north-lake-boulevard-tahoe-city-ca-96145-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/property-detail/3344/1780-north-lake-boulevard-tahoe-city-ca-96145-usa
Remote Port	17206
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	162.159.115.42
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
Http Accept Encoding	gzip, br
Http Accept	/
Http Cf Ray	a09d93dc1d8b2947-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	aiotelOKffiFRIUsCtX2mwAAAI0
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	aiotelOKffiFRIUsCtX2mwAAAI0
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781149050.2794
Request Time	1781149050

====

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

Lakefront

Represented By: Tahoe Mountain Realty

www.tmrrealestate.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: 6 ms Total Queries: 33 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 6 ms
Total Queries: 33 queries