Properties /

Valentine Farm

1789 44Z S | Norwood, CO 81423, USA | $4,375,000 | MLS ID: 33037

7 Beds
7 Baths
1 Half Ba
120.00 Acres
Guest House
Waterfront
Garage

Certain properties exude excellence the minute you step foot on them. Valentine Farm defines itself as such a ranch. Comprised of a meticulously renovated turn-of-the-century barn, two remodeled turn-of-the-century cabins and separate 6-car garage, this idyllic compound overlooks 120 verdant acres including a magnificent 10 stall equestrian center with caretaker residence. Two generous sized ponds and prolific irrigation create a lush setting and provide perfect conditions for significant hay production. The highest quality hardware, Waterworks bath fixtures, reclaimed, historic hardwood floors, exterior stone quarried onsite and perfect choices of limestone and travertine in baths and kitchen, create an unrivaled sense of warmth and intimacy. Valentine Farm is a model of perfection.

Represented By: Telluride Properties

View On Map

Highlighted Properties

Log Ski Retreat

438 Benchmark Drive | Telluride, CO 81435
$8,950,000

The Auberge Residences at Element 52

398 South Davis Street | Telluride, CO 81435
$2,995,000

Represented By

Featured Location

Telluride, CO, USA

Everyone loves Telluride - the lifestyle is the best!

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)
  02786
  11789-44z-s-norwood-co-81423-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: 8 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` = 2786 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` = 236	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` = 41 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` = 41 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` = 41 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` = 41 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` = 41 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` = 41 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` = 41 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` = (41) 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` = (41)	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` = (41)	4	4	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` = (2786) ORDER BY `Image`.`order` ASC	10	10	0
SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` = 2786 AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	0	0	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` = 2786 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` = 2786 AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	3	3	0
SELECT `Icon`.`id`, `Icon`.`model`, `Icon`.`model_id`, `Icon`.`tag`, `Icon`.`name`, `Icon`.`type`, `Icon`.`size`, `Icon`.`uri`, `Icon`.`order`, `Icon`.`created`, `Icon`.`modified` FROM `leveragere_staging2`.`assets` AS `Icon` WHERE `Icon`.`model_id` = 5 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	0
SELECT `Icon`.`id`, `Icon`.`model`, `Icon`.`model_id`, `Icon`.`tag`, `Icon`.`name`, `Icon`.`type`, `Icon`.`size`, `Icon`.`uri`, `Icon`.`order`, `Icon`.`created`, `Icon`.`modified` FROM `leveragere_staging2`.`assets` AS `Icon` WHERE `Icon`.`model_id` = 17 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	0
SELECT `Icon`.`id`, `Icon`.`model`, `Icon`.`model_id`, `Icon`.`tag`, `Icon`.`name`, `Icon`.`type`, `Icon`.`size`, `Icon`.`uri`, `Icon`.`order`, `Icon`.`created`, `Icon`.`modified` FROM `leveragere_staging2`.`assets` AS `Icon` WHERE `Icon`.`model_id` = 4 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` = 2786 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` != 2786 AND `Property`.`brokerage_id` = 41 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 (1676, 2387) ORDER BY `Image`.`order` ASC	19	19	1	maybe slow
SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (1676, 2387) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	0	0	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (1676, 2387) 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 (1676, 2387) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	7	7	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (1676, 2387) 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` = 41 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` = 41 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 (1513, 2786, 183, 2387) ORDER BY `Image`.`order` ASC	39	39	1
SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (1513, 2786, 183, 2387) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	0	0	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (1513, 2786, 183, 2387) 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 (1513, 2786, 183, 2387) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	13	13	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (1513, 2786, 183, 2387) 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 13.94 MB

Message	Memory use
Component initialization	3.07 MB
Controller action start	4.01 MB
Controller render start	6.74 MB
View render complete	7.25 MB

Timers

Total Request Time: 222 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	38.21
Event: Controller.initialize	5.03
Event: Controller.startup	1.57
Controller action	43.50
Event: Controller.beforeRender	13.31
» Processing toolbar data	13.23
Rendering View	86.87
» Event: View.beforeRender	0.40
» Rendering APP/View/Properties/view.ctp	3.17
» » Rendering APP/View/Elements/static_property_price.ctp	0.42
» » Rendering APP/View/Elements/property_features.ctp	0.22
» » Rendering APP/View/Elements/static_property_price.ctp #2	0.15
» » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.14
» » Rendering APP/View/Elements/sidebar/property_list.ctp	0.97
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #5	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #6	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #7	0.13
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.19
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	82.53
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)
  id1513
  brokerage_id41
  created_by_user_id0
  order0
  multi_unit(false)
  agent_1_id130
  agent_2_id0
  agent_3_id0
  nameLuxury with sweeping views
  incomplete(false)
  archived(false)
  last_archived0000-00-00 00:00:00
  auto_archived_from_mlsidx(false)
  paid_featured(false)
  featured(true)
  homepage_featured(true)
  brokerage_page_featured(true)
  requested_homepage_featured_by_member(false)
  homepage_featured_by_member(false)
  dot_luxury_featured(false)
  luxury_feed_featured(true)
  force_luxury_feed_featured(false)
  luxury_autofeed_imported(false)
  luxury_feed_last_added_time0000-00-00 00:00:00
  luxury_feed_agent_user_id0
  luxury_feed_locked_to_subscription_id0
  luxury_feed_agent_purchase_date0000-00-00
  luxury_feed_agent_expiration_date0000-00-00
  digital_ad_summary_email_last_sent0000-00-00 00:00:00
  digital_ad_summary_price_changed(false)
  wsj_detail_url
  ft_detail_url
  nyt_detail_url
  juwai_detail_url
  pgl_detail_url
  mg_detail_url
  mg_c_detail_url
  mg_s_detail_url
  bp_detail_url
  mw_detail_url
  nikkei_detail_url
  wapo_detail_url
  robb_detail_url
  medium_featured(false)
  large_featured(false)
  detail_page(true)
  description<p class="p1">Overlooking the prominent, verdant ranch land known as Pleasant Valley, R & R Ranch represents one of the most unique offerings in Southwest Colorado. Comprised of 13,067 square feet of remarkable craftsmanship, the 4 bedroom 8 bathroom main residence features reclaimed chestnut floors, custom wrought iron details, mesquite cabinets, air conditioning, smart home technology, a magnificent spa facility and lavish media room. Situated on a private 28-acre parcel affording breathtaking 270° views at the comfortable elevation of 7,700 feet, this rare compound with a 5,600 s.f. two bedroom guest house and an oversized garage, will be sure to satisfy the most discriminating tastes.</p>
  address678 Catamount
  address_2
  cityTelluride
  stateCO
  postal_code81435
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price6950000
  price_20
  price_usd6950000
  price_usd_20
  statusFor Sale
  status_last_changed0000-00-00 00:00:00
  status_last_changed_price_only0000-00-00 00:00:00
  lease_period
  price_upon_request(false)
  bedrooms6
  bedrooms_20
  bathrooms7
  bathrooms_20
  no_beds_baths(false)
  square_feet13067
  square_meters
  acres28
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size28
  icon_1acreage
  icon_2sq-ft
  icon_3guest-house
  icon_4views
  icon_5garage
  icon_6
  websitehttp://stevec.searchtelluriderealestate.com/homes/678-Catamount/Ridgway/CO/81432/44802317/
  meta_titleLuxury with sweeping views | Telluride Real Estate | Telluride Properties
  meta_description678 Catamount is a property offered for sale in Telluride, CO, USA, presented by Telluride Properties
  meta_keywords
  bathrooms_partial4
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built2007
  virtual_tour
  video_tourhttps://youtu.be/KL_Aiv7otgE
  digital_brochure
  video_tour_embed_code<iframe width="560" height="315" src="https://www.youtube.com/embed/KL_Aiv7otgE?controls=0&showinfo=0" frameborder="0" allowfullscreen></iframe>
  digital_brochure_embed_code
  mls_num31923
  wsj_property_typesingle family
  nyt_property_type1
  nyt_popular_features
  propgolux_property_type9
  juwai_property_type
  juwai_category
  propgolux_property_style22
  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
  latitude38.161575
  longitude-107.841133
  invalid_required_fields
  invalid_optional_fieldsagent_2_id, square_meters, hectares, virtual_tour
  went_live_today(false)
  converted(true)
  invalid(false)
  mlsidx_full_address
  mlsidx_date_listed0000-00-00
  mls_market
  primary_property_category_id0
  realstaq_initial_image_sync(false)
  digital_ad_listing_urls_automated(null)
  modified2016-04-18 05:33:02
  created2015-02-02 11:34:15
  uri/property-detail/1513/678-catamount-telluride-co-81435-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/1513/678-catamount-telluride-co-81435-usa
  address_concat678 Catamount Telluride CO 81435 USA
  google_maps_query_string678+Catamount++Telluride+CO+81435+USA
  luxury_ad_enrolled_prettyYES
  price_prettyUSD 6,950,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty6
  bathrooms_pretty7
  bathrooms_partial_pretty4
  bathrooms_3_4_pretty0
  feed_full_bathrooms7
  date_listed2015-02-02
  overridden_brokerage_nameTelluride Properties
  overridden_brokerage_logo_uri
  lux_ad_auto_enrolled(false)
  PrimaryPropertyCategory(array)
  id(null)
  name(null)
  created(null)
  modified(null)
  Brokerage(array)
  id41
  account_executive_id236
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties8
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties-1
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id1
  WOEID2504615
  timezoneUS/Mountain
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameTelluride Properties
  broker_of_record_name
  short_nameTelluride Properties
  usernameTelllurideProperties
  passworddf9e1cb9ed6ee8ffbaeb602e5a977dba189b7205
  password_reset_hash
  monthly_invoice_amount(null)
  monthly_invoice_start_date0000-00-00
  monthly_invoice_end_date0000-00-00
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Telluride Properties is the exclusive representative for Leverage Global Partners in Telluride, Colorado, USA.</p> <p>Telluride Properties has earned a reputation as the premier Telluride real estate firm, bringing buyers and sellers together since 1986. We understand every aspect of the Telluride real estate market, including ski homes and condominiums, Telluride’s historic Victorian residences, developments, ranches, short sale & bank owned properties, vacation homes and year-round residences. Telluride Properties’ success is based on yours. We provide the tools and proactive guidance it takes to reach our clients’ goals. Our attention to details that matter most to you are hallmarks that significantly enhance the experience you deserve. Telluride Properties has a proven team of skilled real estate brokers ready to assist you with your Telluride real estate assets.</p>
  communitiesTelluride
  websitehttp://www.tellurideproperties.com
  address237 S. Oak Street
  address_2PO Box 37
  cityTelluride
  stateCO
  full_stateColorado
  countryUSA
  marketTelluride
  market_2
  postal_code81435
  phone(970) 708-5527
  phone_2
  phone_3
  wide_contact_image(false)
  contact_nameAlbert Roer
  contact_profile_link
  contact_big_profile_linkhttp://www.leveragere.com/blog/meet-albert-roer-managing-partner-telluride-properties/
  contact_big_profile_link_text
  contact_titleManaging Partner
  contact_dre_num
  contact_quote
  contact_email[email protected]
  contact_facebook
  contact_twitter
  contact_instagram
  contact_pinterest
  contact_linkedin
  contact_youtube
  contact_phone
  contact_email_2
  contact_2_facebook
  contact_2_twitter
  contact_2_instagram
  contact_2_pinterest
  contact_2_linkedin
  contact_2_youtube
  contact_phone_2
  contact_website
  contact_name_2
  contact_profile_link_2
  contact_big_profile_link_2
  contact_big_profile_link_text_2
  contact_title_2
  contact_dre_num_2
  contact_email_3
  contact_name_3
  contact_title_3
  contact_dre_num_3
  contact_phone_3
  contact_3_facebook
  contact_3_twitter
  contact_3_instagram
  contact_3_pinterest
  contact_3_linkedin
  contact_3_youtube
  image_filename41.jpg
  logo_filename41.jpg
  contact_image_filename41.jpg
  all_properties_link_image_filename41.jpg
  all_properties_linkhttp://www.searchtelluriderealestate.com/results/?UserID=all
  video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/klILER0J-qzxAOUo0.js"></script>
  contact_video_embed_code
  meta_titleTelluride Real Estate | Telluride Properties | Leverage Global Partners
  meta_descriptionTelluride Properties is the exclusive representative for Leverage Global Partners in Telluride, Colorado, USA.
  meta_keywordsTelluride real estate, Telluride Properties, Albert Roer, Telluride Colorado, leverage global partners
  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)
  created2013-08-09 12:10:53
  modified2016-04-08 16:33:30
  dre_num012345
  uri/brokerage-detail/41/telluride-properties
  website_shortwww.tellurideproperties.com
  name_with_locationTelluride Properties
  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)
  id12058
  modelProperty
  model_id1513
  tagImage
  name13312.jpg
  typeimage/jpg
  size629584
  uri/assets/12058.jpg
  order0
  created2016-04-07 16:31:02
  modified2016-04-07 16:31:02
  1(array)
  id12066
  modelProperty
  model_id1513
  tagImage
  name22899.jpg
  typeimage/jpg
  size372002
  uri/assets/12066.jpg
  order1
  created2016-04-07 16:31:02
  modified2016-04-07 16:31:02
  2(array)
  id12067
  modelProperty
  model_id1513
  tagImage
  name22900.jpg
  typeimage/jpg
  size618075
  uri/assets/12067.jpg
  order2
  created2016-04-07 16:31:02
  modified2016-04-07 16:31:02
  3(array)
  id12063
  modelProperty
  model_id1513
  tagImage
  name22896.jpg
  typeimage/jpg
  size496269
  uri/assets/12063.jpg
  order3
  created2016-04-07 16:31:02
  modified2016-04-07 16:31:02
  4(array)
  id12064
  modelProperty
  model_id1513
  tagImage
  name22897.jpg
  typeimage/jpg
  size509099
  uri/assets/12064.jpg
  order4
  created2016-04-07 16:31:02
  modified2016-04-07 16:31:02
  5(array)
  id12059
  modelProperty
  model_id1513
  tagImage
  name22892.jpg
  typeimage/jpg
  size320719
  uri/assets/12059.jpg
  order5
  created2016-04-07 16:31:02
  modified2016-04-07 16:31:02
  6(array)
  id12061
  modelProperty
  model_id1513
  tagImage
  name22894.jpg
  typeimage/jpg
  size423470
  uri/assets/12061.jpg
  order6
  created2016-04-07 16:31:02
  modified2016-04-07 16:31:02
  7(array)
  id12062
  modelProperty
  model_id1513
  tagImage
  name22895.jpg
  typeimage/jpg
  size490268
  uri/assets/12062.jpg
  order7
  created2016-04-07 16:31:02
  modified2016-04-07 16:31:02
  8(array)
  id12060
  modelProperty
  model_id1513
  tagImage
  name22893.jpg
  typeimage/jpg
  size372100
  uri/assets/12060.jpg
  order8
  created2016-04-07 16:31:02
  modified2016-04-07 16:31:02
  9(array)
  id12065
  modelProperty
  model_id1513
  tagImage
  name22898.jpg
  typeimage/jpg
  size448024
  uri/assets/12065.jpg
  order9
  created2016-04-07 16:31:02
  modified2016-04-07 16:31:02
  User(empty)
  SecondaryPropertyCategory(empty)
  PropertyFeature(array)
  0(array)
  id5
  nameGuest House
  additional(false)
  created2016-04-07 14:02:13
  modified2016-04-07 14:02:13
  PropertiesPropertyFeature(array)
  id2212
  property_id1513
  property_feature_id5
  1(array)
  id14
  nameViews
  additional(false)
  created2016-04-07 14:04:55
  modified2016-04-07 14:04:55
  PropertiesPropertyFeature(array)
  id2213
  property_id1513
  property_feature_id14
  2(array)
  id4
  nameGarage
  additional(false)
  created2016-04-07 14:01:52
  modified2016-04-07 14:01:52
  PropertiesPropertyFeature(array)
  id2214
  property_id1513
  property_feature_id4
  Topic(empty)
  1(array)
  Property(array)
  id2786
  brokerage_id41
  created_by_user_id0
  order0
  multi_unit(false)
  agent_1_id130
  agent_2_id0
  agent_3_id0
  nameValentine Farm
  incomplete(false)
  archived(false)
  last_archived0000-00-00 00:00:00
  auto_archived_from_mlsidx(false)
  paid_featured(false)
  featured(true)
  homepage_featured(true)
  brokerage_page_featured(true)
  requested_homepage_featured_by_member(false)
  homepage_featured_by_member(false)
  dot_luxury_featured(false)
  luxury_feed_featured(false)
  force_luxury_feed_featured(false)
  luxury_autofeed_imported(false)
  luxury_feed_last_added_time0000-00-00 00:00:00
  luxury_feed_agent_user_id0
  luxury_feed_locked_to_subscription_id0
  luxury_feed_agent_purchase_date0000-00-00
  luxury_feed_agent_expiration_date0000-00-00
  digital_ad_summary_email_last_sent0000-00-00 00:00:00
  digital_ad_summary_price_changed(false)
  wsj_detail_url
  ft_detail_url
  nyt_detail_url
  juwai_detail_url
  pgl_detail_url
  mg_detail_url
  mg_c_detail_url
  mg_s_detail_url
  bp_detail_url
  mw_detail_url
  nikkei_detail_url
  wapo_detail_url
  robb_detail_url
  medium_featured(false)
  large_featured(false)
  detail_page(true)
  description<p><span>Certain properties exude excellence the minute you step foot on them. Valentine Farm defines itself as such a ranch. Comprised of a meticulously renovated turn-of-the-century barn, two remodeled turn-of-the-century cabins and separate 6-car garage, this idyllic compound overlooks 120 verdant acres including a magnificent 10 stall equestrian center with caretaker residence. Two generous sized ponds and prolific irrigation create a lush setting and provide perfect conditions for significant hay production. The highest quality hardware, Waterworks bath fixtures, reclaimed, historic hardwood floors, exterior stone quarried onsite and perfect choices of limestone and travertine in baths and kitchen, create an unrivaled sense of warmth and intimacy. Valentine Farm is a model of perfection.</span></p>
  address1789 44Z S
  address_2
  cityNorwood
  stateCO
  postal_code81423
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price4375000
  price_20
  price_usd4375000
  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_feet3739
  square_meters
  acres120
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size120
  icon_1acreage
  icon_2guest-house
  icon_3sq-ft
  icon_4waterfront
  icon_5garage
  icon_6
  website
  meta_titleValentine Farm | Norwood Real Estate | Telluride Properties
  meta_description1789 44Z S is a property offered for sale in Norwood, CO, USA, presented by Telluride Properties
  meta_keywords
  bathrooms_partial1
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built1890/2010
  virtual_tour
  video_tour
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_num33037
  wsj_property_typeranch
  nyt_property_type1
  nyt_popular_features
  propgolux_property_type3
  juwai_property_type
  juwai_category
  propgolux_property_style56
  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
  latitude38.022720
  longitude-108.261963
  invalid_required_fields
  invalid_optional_fieldsagent_2_id, square_meters, hectares, virtual_tour, video_tour
  went_live_today(false)
  converted(true)
  invalid(false)
  mlsidx_full_address
  mlsidx_date_listed0000-00-00
  mls_market
  primary_property_category_id0
  realstaq_initial_image_sync(false)
  digital_ad_listing_urls_automated(null)
  modified2016-04-18 05:33:02
  created2015-09-17 09:25:10
  uri/property-detail/2786/1789-44z-s-norwood-co-81423-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/2786/1789-44z-s-norwood-co-81423-usa
  address_concat1789 44Z S Norwood CO 81423 USA
  google_maps_query_string1789+44Z+S++Norwood+CO+81423+USA
  luxury_ad_enrolled_prettyNO
  price_prettyUSD 4,375,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty7
  bathrooms_pretty7
  bathrooms_partial_pretty1
  bathrooms_3_4_pretty0
  feed_full_bathrooms7
  date_listed2015-09-17
  overridden_brokerage_nameTelluride Properties
  overridden_brokerage_logo_uri
  lux_ad_auto_enrolled(false)
  PrimaryPropertyCategory(array)
  id(null)
  name(null)
  created(null)
  modified(null)
  Brokerage(array)
  id41
  account_executive_id236
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties8
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties-1
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id1
  WOEID2504615
  timezoneUS/Mountain
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameTelluride Properties
  broker_of_record_name
  short_nameTelluride Properties
  usernameTelllurideProperties
  passworddf9e1cb9ed6ee8ffbaeb602e5a977dba189b7205
  password_reset_hash
  monthly_invoice_amount(null)
  monthly_invoice_start_date0000-00-00
  monthly_invoice_end_date0000-00-00
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Telluride Properties is the exclusive representative for Leverage Global Partners in Telluride, Colorado, USA.</p> <p>Telluride Properties has earned a reputation as the premier Telluride real estate firm, bringing buyers and sellers together since 1986. We understand every aspect of the Telluride real estate market, including ski homes and condominiums, Telluride’s historic Victorian residences, developments, ranches, short sale & bank owned properties, vacation homes and year-round residences. Telluride Properties’ success is based on yours. We provide the tools and proactive guidance it takes to reach our clients’ goals. Our attention to details that matter most to you are hallmarks that significantly enhance the experience you deserve. Telluride Properties has a proven team of skilled real estate brokers ready to assist you with your Telluride real estate assets.</p>
  communitiesTelluride
  websitehttp://www.tellurideproperties.com
  address237 S. Oak Street
  address_2PO Box 37
  cityTelluride
  stateCO
  full_stateColorado
  countryUSA
  marketTelluride
  market_2
  postal_code81435
  phone(970) 708-5527
  phone_2
  phone_3
  wide_contact_image(false)
  contact_nameAlbert Roer
  contact_profile_link
  contact_big_profile_linkhttp://www.leveragere.com/blog/meet-albert-roer-managing-partner-telluride-properties/
  contact_big_profile_link_text
  contact_titleManaging Partner
  contact_dre_num
  contact_quote
  contact_email[email protected]
  contact_facebook
  contact_twitter
  contact_instagram
  contact_pinterest
  contact_linkedin
  contact_youtube
  contact_phone
  contact_email_2
  contact_2_facebook
  contact_2_twitter
  contact_2_instagram
  contact_2_pinterest
  contact_2_linkedin
  contact_2_youtube
  contact_phone_2
  contact_website
  contact_name_2
  contact_profile_link_2
  contact_big_profile_link_2
  contact_big_profile_link_text_2
  contact_title_2
  contact_dre_num_2
  contact_email_3
  contact_name_3
  contact_title_3
  contact_dre_num_3
  contact_phone_3
  contact_3_facebook
  contact_3_twitter
  contact_3_instagram
  contact_3_pinterest
  contact_3_linkedin
  contact_3_youtube
  image_filename41.jpg
  logo_filename41.jpg
  contact_image_filename41.jpg
  all_properties_link_image_filename41.jpg
  all_properties_linkhttp://www.searchtelluriderealestate.com/results/?UserID=all
  video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/klILER0J-qzxAOUo0.js"></script>
  contact_video_embed_code
  meta_titleTelluride Real Estate | Telluride Properties | Leverage Global Partners
  meta_descriptionTelluride Properties is the exclusive representative for Leverage Global Partners in Telluride, Colorado, USA.
  meta_keywordsTelluride real estate, Telluride Properties, Albert Roer, Telluride Colorado, leverage global partners
  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)
  created2013-08-09 12:10:53
  modified2016-04-08 16:33:30
  dre_num012345
  uri/brokerage-detail/41/telluride-properties
  website_shortwww.tellurideproperties.com
  name_with_locationTelluride Properties
  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)
  id16812
  modelProperty
  model_id2786
  tagImage
  name26455.jpg
  typeimage/jpg
  size500296
  uri/assets/16812.jpg
  order0
  created2016-04-07 17:00:11
  modified2016-04-07 17:00:11
  1(array)
  id16813
  modelProperty
  model_id2786
  tagImage
  name26572.jpg
  typeimage/jpg
  size673936
  uri/assets/16813.jpg
  order1
  created2016-04-07 17:00:11
  modified2016-04-07 17:00:11
  2(array)
  id16814
  modelProperty
  model_id2786
  tagImage
  name26573.jpg
  typeimage/jpg
  size580750
  uri/assets/16814.jpg
  order2
  created2016-04-07 17:00:11
  modified2016-04-07 17:00:11
  3(array)
  id16819
  modelProperty
  model_id2786
  tagImage
  name26578.jpg
  typeimage/jpg
  size572918
  uri/assets/16819.jpg
  order3
  created2016-04-07 17:00:11
  modified2016-04-07 17:00:11
  4(array)
  id16816
  modelProperty
  model_id2786
  tagImage
  name26575.jpg
  typeimage/jpg
  size660964
  uri/assets/16816.jpg
  order4
  created2016-04-07 17:00:11
  modified2016-04-07 17:00:11
  5(array)
  id16818
  modelProperty
  model_id2786
  tagImage
  name26577.jpg
  typeimage/jpg
  size537058
  uri/assets/16818.jpg
  order5
  created2016-04-07 17:00:11
  modified2016-04-07 17:00:11
  6(array)
  id16817
  modelProperty
  model_id2786
  tagImage
  name26576.jpg
  typeimage/jpg
  size1766293
  uri/assets/16817.jpg
  order6
  created2016-04-07 17:00:11
  modified2016-04-07 17:00:11
  7(array)
  id16821
  modelProperty
  model_id2786
  tagImage
  name26580.jpg
  typeimage/jpg
  size670342
  uri/assets/16821.jpg
  order7
  created2016-04-07 17:00:11
  modified2016-04-07 17:00:11
  8(array)
  id16820
  modelProperty
  model_id2786
  tagImage
  name26579.jpg
  typeimage/jpg
  size588743
  uri/assets/16820.jpg
  order8
  created2016-04-07 17:00:11
  modified2016-04-07 17:00:11
  9(array)
  id16815
  modelProperty
  model_id2786
  tagImage
  name26574.jpg
  typeimage/jpg
  size616456
  uri/assets/16815.jpg
  order9
  created2016-04-07 17:00:11
  modified2016-04-07 17:00:11
  User(empty)
  SecondaryPropertyCategory(empty)
  PropertyFeature(array)
  0(array)
  id5
  nameGuest House
  additional(false)
  created2016-04-07 14:02:13
  modified2016-04-07 14:02:13
  PropertiesPropertyFeature(array)
  id3499
  property_id2786
  property_feature_id5
  1(array)
  id17
  nameWaterfront
  additional(false)
  created2016-04-07 14:06:00
  modified2016-04-07 14:06:00
  PropertiesPropertyFeature(array)
  id3500
  property_id2786
  property_feature_id17
  2(array)
  id4
  nameGarage
  additional(false)
  created2016-04-07 14:01:52
  modified2016-04-07 14:01:52
  PropertiesPropertyFeature(array)
  id3501
  property_id2786
  property_feature_id4
  Topic(empty)
  2(array)
  Property(array)
  id183
  brokerage_id41
  created_by_user_id0
  order0
  multi_unit(false)
  agent_1_id130
  agent_2_id0
  agent_3_id0
  nameSophisticated Mountain Home
  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)
  description<p>Tucked in majestic spruce and aspen at the end of secluded Victoria Drive resides Knightsbridge, one of the most impressive homes ever constructed in Mountain Village. Capturing dramatic views of the Sneffels Range, this elegant 7 bedroom, 11,359 SF residence leaves no stone unturned. Ceiling to floor windows in the great room bring the stunning outdoors in and the master suite provides a lavish living experience with his and her baths plus a one-of-a-kind lower level dressing room sure to exceed your expectations. Uniquely styled bedrooms each with a bath, warmly accommodate family and guests. Hand-crafted metal work, clerestory trusses, walnut floors and trim plus exquisite European alpine design touches add an element of sophistication, unmatched in today's market place.</p>
  address133 Victoria Drive
  address_2
  cityTelluride
  stateCO
  postal_code81435
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price7295000
  price_20
  price_usd7295000
  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
  bathrooms8
  bathrooms_20
  no_beds_baths(false)
  square_feet11359
  square_meters
  acres1
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size1
  icon_1views
  icon_2cellar
  icon_3sq-ft
  icon_4media-room
  icon_5acreage
  icon_6
  website
  meta_titleSophisticated Mountain Home | Telluride Real Estate | Telluride Properties
  meta_description133 Victoria Drive is a property offered for sale in Telluride, CO, USA, presented by Telluride Properties
  meta_keywordsTelluride Properties, 133 Victoria Drive, Telluride Real Estate, leverage global partners
  bathrooms_partial3
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built2007
  virtual_tour
  video_tour
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_num25883
  wsj_property_typesingle family
  nyt_property_type1
  nyt_popular_features
  propgolux_property_type9
  juwai_property_type
  juwai_category
  propgolux_property_style22
  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
  latitude37.936077
  longitude-107.856682
  invalid_required_fields
  invalid_optional_fieldsagent_2_id, square_meters, hectares, virtual_tour, video_tour
  went_live_today(false)
  converted(true)
  invalid(false)
  mlsidx_full_address
  mlsidx_date_listed0000-00-00
  mls_market
  primary_property_category_id0
  realstaq_initial_image_sync(false)
  digital_ad_listing_urls_automated(null)
  modified2016-04-18 05:33:02
  created2013-08-09 12:37:09
  uri/property-detail/183/133-victoria-drive-telluride-co-81435-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/183/133-victoria-drive-telluride-co-81435-usa
  address_concat133 Victoria Drive Telluride CO 81435 USA
  google_maps_query_string133+Victoria+Drive++Telluride+CO+81435+USA
  luxury_ad_enrolled_prettyYES
  price_prettyUSD 7,295,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty7
  bathrooms_pretty8
  bathrooms_partial_pretty3
  bathrooms_3_4_pretty0
  feed_full_bathrooms8
  date_listed2013-08-09
  overridden_brokerage_nameTelluride Properties
  overridden_brokerage_logo_uri
  lux_ad_auto_enrolled(false)
  PrimaryPropertyCategory(array)
  id(null)
  name(null)
  created(null)
  modified(null)
  Brokerage(array)
  id41
  account_executive_id236
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties8
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties-1
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id1
  WOEID2504615
  timezoneUS/Mountain
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameTelluride Properties
  broker_of_record_name
  short_nameTelluride Properties
  usernameTelllurideProperties
  passworddf9e1cb9ed6ee8ffbaeb602e5a977dba189b7205
  password_reset_hash
  monthly_invoice_amount(null)
  monthly_invoice_start_date0000-00-00
  monthly_invoice_end_date0000-00-00
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Telluride Properties is the exclusive representative for Leverage Global Partners in Telluride, Colorado, USA.</p> <p>Telluride Properties has earned a reputation as the premier Telluride real estate firm, bringing buyers and sellers together since 1986. We understand every aspect of the Telluride real estate market, including ski homes and condominiums, Telluride’s historic Victorian residences, developments, ranches, short sale & bank owned properties, vacation homes and year-round residences. Telluride Properties’ success is based on yours. We provide the tools and proactive guidance it takes to reach our clients’ goals. Our attention to details that matter most to you are hallmarks that significantly enhance the experience you deserve. Telluride Properties has a proven team of skilled real estate brokers ready to assist you with your Telluride real estate assets.</p>
  communitiesTelluride
  websitehttp://www.tellurideproperties.com
  address237 S. Oak Street
  address_2PO Box 37
  cityTelluride
  stateCO
  full_stateColorado
  countryUSA
  marketTelluride
  market_2
  postal_code81435
  phone(970) 708-5527
  phone_2
  phone_3
  wide_contact_image(false)
  contact_nameAlbert Roer
  contact_profile_link
  contact_big_profile_linkhttp://www.leveragere.com/blog/meet-albert-roer-managing-partner-telluride-properties/
  contact_big_profile_link_text
  contact_titleManaging Partner
  contact_dre_num
  contact_quote
  contact_email[email protected]
  contact_facebook
  contact_twitter
  contact_instagram
  contact_pinterest
  contact_linkedin
  contact_youtube
  contact_phone
  contact_email_2
  contact_2_facebook
  contact_2_twitter
  contact_2_instagram
  contact_2_pinterest
  contact_2_linkedin
  contact_2_youtube
  contact_phone_2
  contact_website
  contact_name_2
  contact_profile_link_2
  contact_big_profile_link_2
  contact_big_profile_link_text_2
  contact_title_2
  contact_dre_num_2
  contact_email_3
  contact_name_3
  contact_title_3
  contact_dre_num_3
  contact_phone_3
  contact_3_facebook
  contact_3_twitter
  contact_3_instagram
  contact_3_pinterest
  contact_3_linkedin
  contact_3_youtube
  image_filename41.jpg
  logo_filename41.jpg
  contact_image_filename41.jpg
  all_properties_link_image_filename41.jpg
  all_properties_linkhttp://www.searchtelluriderealestate.com/results/?UserID=all
  video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/klILER0J-qzxAOUo0.js"></script>
  contact_video_embed_code
  meta_titleTelluride Real Estate | Telluride Properties | Leverage Global Partners
  meta_descriptionTelluride Properties is the exclusive representative for Leverage Global Partners in Telluride, Colorado, USA.
  meta_keywordsTelluride real estate, Telluride Properties, Albert Roer, Telluride Colorado, leverage global partners
  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)
  created2013-08-09 12:10:53
  modified2016-04-08 16:33:30
  dre_num012345
  uri/brokerage-detail/41/telluride-properties
  website_shortwww.tellurideproperties.com
  name_with_locationTelluride Properties
  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)
  id5517
  modelProperty
  model_id183
  tagImage
  name22326.jpg
  typeimage/jpg
  size854852
  uri/assets/5517.jpg
  order0
  created2016-04-07 15:46:55
  modified2016-04-07 15:46:55
  1(array)
  id5512
  modelProperty
  model_id183
  tagImage
  name22328.jpg
  typeimage/jpg
  size424872
  uri/assets/5512.jpg
  order1
  created2016-04-07 15:46:55
  modified2016-04-07 15:46:55
  2(array)
  id5516
  modelProperty
  model_id183
  tagImage
  name22329.jpg
  typeimage/jpg
  size432649
  uri/assets/5516.jpg
  order2
  created2016-04-07 15:46:55
  modified2016-04-07 15:46:55
  3(array)
  id5515
  modelProperty
  model_id183
  tagImage
  name24269.jpg
  typeimage/jpg
  size448525
  uri/assets/5515.jpg
  order3
  created2016-04-07 15:46:55
  modified2016-04-07 15:46:55
  4(array)
  id5509
  modelProperty
  model_id183
  tagImage
  name24273.jpg
  typeimage/jpg
  size421105
  uri/assets/5509.jpg
  order4
  created2016-04-07 15:46:54
  modified2016-04-07 15:46:54
  5(array)
  id5510
  modelProperty
  model_id183
  tagImage
  name24272.jpg
  typeimage/jpg
  size315378
  uri/assets/5510.jpg
  order5
  created2016-04-07 15:46:54
  modified2016-04-07 15:46:54
  6(array)
  id5514
  modelProperty
  model_id183
  tagImage
  name24270.jpg
  typeimage/jpg
  size520053
  uri/assets/5514.jpg
  order6
  created2016-04-07 15:46:55
  modified2016-04-07 15:46:55
  7(array)
  id5513
  modelProperty
  model_id183
  tagImage
  name24271.jpg
  typeimage/jpg
  size368510
  uri/assets/5513.jpg
  order7
  created2016-04-07 15:46:55
  modified2016-04-07 15:46:55
  8(array)
  id5508
  modelProperty
  model_id183
  tagImage
  name24274.jpg
  typeimage/jpg
  size474715
  uri/assets/5508.jpg
  order8
  created2016-04-07 15:46:54
  modified2016-04-07 15:46:54
  9(array)
  id5511
  modelProperty
  model_id183
  tagImage
  name1373.jpg
  typeimage/jpg
  size494728
  uri/assets/5511.jpg
  order9
  created2016-04-07 15:46:54
  modified2016-04-07 15:46:55
  User(empty)
  SecondaryPropertyCategory(empty)
  PropertyFeature(array)
  0(array)
  id8
  nameMedia Room
  additional(false)
  created2016-04-07 14:03:04
  modified2016-04-07 14:03:04
  PropertiesPropertyFeature(array)
  id558
  property_id183
  property_feature_id8
  1(array)
  id18
  nameWine Cellar
  additional(false)
  created2016-04-07 14:06:17
  modified2016-04-07 14:06:17
  PropertiesPropertyFeature(array)
  id557
  property_id183
  property_feature_id18
  2(array)
  id14
  nameViews
  additional(false)
  created2016-04-07 14:04:55
  modified2016-04-07 14:04:55
  PropertiesPropertyFeature(array)
  id556
  property_id183
  property_feature_id14
  Topic(empty)
  3(array)
  Property(array)
  id2387
  brokerage_id41
  created_by_user_id0
  order0
  multi_unit(false)
  agent_1_id131
  agent_2_id132
  agent_3_id0
  nameThe Auberge Residences at Element 52
  incomplete(false)
  archived(false)
  last_archived0000-00-00 00:00:00
  auto_archived_from_mlsidx(false)
  paid_featured(false)
  featured(true)
  homepage_featured(true)
  brokerage_page_featured(true)
  requested_homepage_featured_by_member(false)
  homepage_featured_by_member(false)
  dot_luxury_featured(false)
  luxury_feed_featured(false)
  force_luxury_feed_featured(false)
  luxury_autofeed_imported(false)
  luxury_feed_last_added_time0000-00-00 00:00:00
  luxury_feed_agent_user_id0
  luxury_feed_locked_to_subscription_id0
  luxury_feed_agent_purchase_date0000-00-00
  luxury_feed_agent_expiration_date0000-00-00
  digital_ad_summary_email_last_sent0000-00-00 00:00:00
  digital_ad_summary_price_changed(false)
  wsj_detail_url
  ft_detail_url
  nyt_detail_url
  juwai_detail_url
  pgl_detail_url
  mg_detail_url
  mg_c_detail_url
  mg_s_detail_url
  bp_detail_url
  mw_detail_url
  nikkei_detail_url
  wapo_detail_url
  robb_detail_url
  medium_featured(false)
  large_featured(false)
  detail_page(true)
  description<p class="p1"><strong>Two to Five Bedroom Residences offered from $1,300,000 to $5,231,800.</strong></p> <p class="p1">The Auberge Residences at Element 52 are a unique enclave of luxury townhomes and flats offering owners and guests full turn-key services and amenities, location, and a design that sets it apart within the world-class resort town of Telluride, Colorado. Expansive decks, gourmet kitchens, formal dining areas and multiple guest suites will satisfy the most discriminating buyers. Jump on the property’s private ski lift that transports you seamlessly to the groomed Telluride Trail with uninterrupted ski access to the gondola and Chairlifts 7 and 8. At the end of the day, return to the owner’s ski lounge offeng private lockers, boot-dryers, along with ski rental and tuning services. Two heated, soaking pools are situated in the inner courtyard. Just steps away is the Spa at Element 52, an intimate retreat for restoration and rejuvenation within its three separate treatment rooms and club facilities. At the disposal of owners and guests is Gray Head, a private 900-acre wilderness preserve and year-round recreational paradise. Only 15 minutes from Telluride. The Auberge Residences at Element 52 are the epitome of service, comfort, and luxury with an unrivaled location within the town of Telluride. Ownership also includes reciprocity with other properties within the Auberge Collection, as well as Elite Alliance and 3rd Home.</p> <p class="p1">Simply the best.</p>
  address398 South Davis Street
  address_2
  cityTelluride
  stateCO
  postal_code81435
  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)
  bedrooms3
  bedrooms_20
  bathrooms3
  bathrooms_20
  no_beds_baths(false)
  square_feet2797
  square_meters
  acres0
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size0
  icon_1gym
  icon_2ski
  icon_3pool
  icon_4views
  icon_5sq-ft
  icon_6
  websitehttps://element52.aubergeresorts.com/
  meta_titleThe Auberge Residences at Element 52 | Telluride Real Estate | Telluride Properties
  meta_description398 South Davis Street is a property offered for sale in Telluride, CO, USA, presented by Telluride Properties
  meta_keywords
  bathrooms_partial1
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built2011
  virtual_tour
  video_tourhttps://player.vimeo.com/video/21609964
  digital_brochure
  video_tour_embed_code<iframe src="https://player.vimeo.com/video/21609964?title=0&byline=0&portrait=0" width="500" height="281" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>
  digital_brochure_embed_code
  mls_num29276
  wsj_property_typenew development
  nyt_property_type5
  nyt_popular_features
  propgolux_property_type2
  juwai_property_type
  juwai_category
  propgolux_property_style15
  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
  latitude37.938042
  longitude-107.817787
  invalid_required_fields
  invalid_optional_fieldssquare_meters, acres, hectares, virtual_tour
  went_live_today(false)
  converted(true)
  invalid(false)
  mlsidx_full_address
  mlsidx_date_listed0000-00-00
  mls_market
  primary_property_category_id0
  realstaq_initial_image_sync(false)
  digital_ad_listing_urls_automated(null)
  modified2016-04-18 05:33:02
  created2015-06-30 13:02:49
  uri/property-detail/2387/398-south-davis-street-telluride-co-81435-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/2387/398-south-davis-street-telluride-co-81435-usa
  address_concat398 South Davis Street Telluride CO 81435 USA
  google_maps_query_string398+South+Davis+Street++Telluride+CO+81435+USA
  luxury_ad_enrolled_prettyNO
  price_prettyUSD 2,995,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty3
  bathrooms_pretty3
  bathrooms_partial_pretty1
  bathrooms_3_4_pretty0
  feed_full_bathrooms3
  date_listed2015-06-30
  overridden_brokerage_nameTelluride Properties
  overridden_brokerage_logo_uri
  lux_ad_auto_enrolled(false)
  PrimaryPropertyCategory(array)
  id(null)
  name(null)
  created(null)
  modified(null)
  Brokerage(array)
  id41
  account_executive_id236
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties8
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties-1
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id1
  WOEID2504615
  timezoneUS/Mountain
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameTelluride Properties
  broker_of_record_name
  short_nameTelluride Properties
  usernameTelllurideProperties
  passworddf9e1cb9ed6ee8ffbaeb602e5a977dba189b7205
  password_reset_hash
  monthly_invoice_amount(null)
  monthly_invoice_start_date0000-00-00
  monthly_invoice_end_date0000-00-00
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Telluride Properties is the exclusive representative for Leverage Global Partners in Telluride, Colorado, USA.</p> <p>Telluride Properties has earned a reputation as the premier Telluride real estate firm, bringing buyers and sellers together since 1986. We understand every aspect of the Telluride real estate market, including ski homes and condominiums, Telluride’s historic Victorian residences, developments, ranches, short sale & bank owned properties, vacation homes and year-round residences. Telluride Properties’ success is based on yours. We provide the tools and proactive guidance it takes to reach our clients’ goals. Our attention to details that matter most to you are hallmarks that significantly enhance the experience you deserve. Telluride Properties has a proven team of skilled real estate brokers ready to assist you with your Telluride real estate assets.</p>
  communitiesTelluride
  websitehttp://www.tellurideproperties.com
  address237 S. Oak Street
  address_2PO Box 37
  cityTelluride
  stateCO
  full_stateColorado
  countryUSA
  marketTelluride
  market_2
  postal_code81435
  phone(970) 708-5527
  phone_2
  phone_3
  wide_contact_image(false)
  contact_nameAlbert Roer
  contact_profile_link
  contact_big_profile_linkhttp://www.leveragere.com/blog/meet-albert-roer-managing-partner-telluride-properties/
  contact_big_profile_link_text
  contact_titleManaging Partner
  contact_dre_num
  contact_quote
  contact_email[email protected]
  contact_facebook
  contact_twitter
  contact_instagram
  contact_pinterest
  contact_linkedin
  contact_youtube
  contact_phone
  contact_email_2
  contact_2_facebook
  contact_2_twitter
  contact_2_instagram
  contact_2_pinterest
  contact_2_linkedin
  contact_2_youtube
  contact_phone_2
  contact_website
  contact_name_2
  contact_profile_link_2
  contact_big_profile_link_2
  contact_big_profile_link_text_2
  contact_title_2
  contact_dre_num_2
  contact_email_3
  contact_name_3
  contact_title_3
  contact_dre_num_3
  contact_phone_3
  contact_3_facebook
  contact_3_twitter
  contact_3_instagram
  contact_3_pinterest
  contact_3_linkedin
  contact_3_youtube
  image_filename41.jpg
  logo_filename41.jpg
  contact_image_filename41.jpg
  all_properties_link_image_filename41.jpg
  all_properties_linkhttp://www.searchtelluriderealestate.com/results/?UserID=all
  video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/klILER0J-qzxAOUo0.js"></script>
  contact_video_embed_code
  meta_titleTelluride Real Estate | Telluride Properties | Leverage Global Partners
  meta_descriptionTelluride Properties is the exclusive representative for Leverage Global Partners in Telluride, Colorado, USA.
  meta_keywordsTelluride real estate, Telluride Properties, Albert Roer, Telluride Colorado, leverage global partners
  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)
  created2013-08-09 12:10:53
  modified2016-04-08 16:33:30
  dre_num012345
  uri/brokerage-detail/41/telluride-properties
  website_shortwww.tellurideproperties.com
  name_with_locationTelluride Properties
  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)
  id15423
  modelProperty
  model_id2387
  tagImage
  name22324.jpg
  typeimage/jpg
  size661746
  uri/assets/15423.jpg
  order0
  created2016-04-07 16:52:03
  modified2016-04-07 16:52:03
  1(array)
  id15424
  modelProperty
  model_id2387
  tagImage
  name22318.jpg
  typeimage/jpg
  size589086
  uri/assets/15424.jpg
  order1
  created2016-04-07 16:52:03
  modified2016-04-07 16:52:03
  2(array)
  id15419
  modelProperty
  model_id2387
  tagImage
  name22322.jpg
  typeimage/jpg
  size499280
  uri/assets/15419.jpg
  order2
  created2016-04-07 16:52:03
  modified2016-04-07 16:52:03
  3(array)
  id15422
  modelProperty
  model_id2387
  tagImage
  name22316.jpg
  typeimage/jpg
  size382117
  uri/assets/15422.jpg
  order3
  created2016-04-07 16:52:03
  modified2016-04-07 16:52:03
  4(array)
  id15425
  modelProperty
  model_id2387
  tagImage
  name22319.jpg
  typeimage/jpg
  size464983
  uri/assets/15425.jpg
  order4
  created2016-04-07 16:52:03
  modified2016-04-07 16:52:03
  5(array)
  id15420
  modelProperty
  model_id2387
  tagImage
  name22325.jpg
  typeimage/jpg
  size423371
  uri/assets/15420.jpg
  order5
  created2016-04-07 16:52:03
  modified2016-04-07 16:52:03
  6(array)
  id15427
  modelProperty
  model_id2387
  tagImage
  name22323.jpg
  typeimage/jpg
  size694108
  uri/assets/15427.jpg
  order6
  created2016-04-07 16:52:03
  modified2016-04-07 16:52:03
  7(array)
  id15426
  modelProperty
  model_id2387
  tagImage
  name22320.jpg
  typeimage/jpg
  size266689
  uri/assets/15426.jpg
  order7
  created2016-04-07 16:52:03
  modified2016-04-07 16:52:03
  8(array)
  id15421
  modelProperty
  model_id2387
  tagImage
  name22315.jpg
  typeimage/jpg
  size254993
  uri/assets/15421.jpg
  order8
  created2016-04-07 16:52:03
  modified2016-04-07 16:52:03
  User(empty)
  SecondaryPropertyCategory(empty)
  PropertyFeature(array)
  0(array)
  id6
  nameGym
  additional(false)
  created2016-04-07 14:02:29
  modified2016-04-07 14:02:29
  PropertiesPropertyFeature(array)
  id3151
  property_id2387
  property_feature_id6
  1(array)
  id11
  nameSki In/Ski Out
  additional(false)
  created2016-04-07 14:03:53
  modified2016-04-07 14:03:53
  PropertiesPropertyFeature(array)
  id3152
  property_id2387
  property_feature_id11
  2(array)
  id12
  nameSwimming Pool
  additional(false)
  created2016-04-07 14:04:12
  modified2016-04-07 14:04:12
  PropertiesPropertyFeature(array)
  id3153
  property_id2387
  property_feature_id12
  3(array)
  id14
  nameViews
  additional(false)
  created2016-04-07 14:04:55
  modified2016-04-07 14:04:55
  PropertiesPropertyFeature(array)
  id3154
  property_id2387
  property_feature_id14
  Topic(empty)
- sidebar_locations(array)
  0(array)
  Location(array)
  id112
  parent_id9
  brokerage_id41
  typeExclusive
  archived(false)
  use_as_topic(false)
  nameTelluride, CO, USA
  short_nameTelluride, CO, USA
  group_index
  latitude37.957722
  longitude-107.882080
  country_code
  north53.700001
  south19.700001
  east-52.599998
  west-146.600006
  zoom0
  short_descriptionEveryone loves Telluride - the lifestyle is the best!
  long_descriptionVisitors are immediately enchanted with the breathtaking setting of the historic Town of Telluride. The grand snowcapped mountain peaks ensnare the senses, while the warm embrace of the Telluride community welcomes them to paradise. Each summer the town plays host to such world-renowned events as the Telluride Bluegrass Festival, Telluride Film Festival, and Telluride Blues & Brews Festival. Telluride, Mountain Village and their surrounding areas boast a desirable array of high-end luxury and value-oriented properties. Unlike other high profile resorts, Telluride and Mountain Village both offer true ski-in/out condos & homes with grand views and sumptuous amenities.
  created2016-04-05 16:30:17
  modified2016-04-05 16:30:17
  timezoneAmerica/Boise
  population3686
  uri/locations/view/112/telluride-co-usa
  tile_nameTelluride, CO, USA
  Brokerage(array)
  id41
  account_executive_id236
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties8
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties-1
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id1
  WOEID2504615
  timezoneUS/Mountain
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameTelluride Properties
  broker_of_record_name
  short_nameTelluride Properties
  usernameTelllurideProperties
  passworddf9e1cb9ed6ee8ffbaeb602e5a977dba189b7205
  password_reset_hash
  monthly_invoice_amount(null)
  monthly_invoice_start_date0000-00-00
  monthly_invoice_end_date0000-00-00
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Telluride Properties is the exclusive representative for Leverage Global Partners in Telluride, Colorado, USA.</p> <p>Telluride Properties has earned a reputation as the premier Telluride real estate firm, bringing buyers and sellers together since 1986. We understand every aspect of the Telluride real estate market, including ski homes and condominiums, Telluride’s historic Victorian residences, developments, ranches, short sale & bank owned properties, vacation homes and year-round residences. Telluride Properties’ success is based on yours. We provide the tools and proactive guidance it takes to reach our clients’ goals. Our attention to details that matter most to you are hallmarks that significantly enhance the experience you deserve. Telluride Properties has a proven team of skilled real estate brokers ready to assist you with your Telluride real estate assets.</p>
  communitiesTelluride
  websitehttp://www.tellurideproperties.com
  address237 S. Oak Street
  address_2PO Box 37
  cityTelluride
  stateCO
  full_stateColorado
  countryUSA
  marketTelluride
  market_2
  postal_code81435
  phone(970) 708-5527
  phone_2
  phone_3
  wide_contact_image(false)
  contact_nameAlbert Roer
  contact_profile_link
  contact_big_profile_linkhttp://www.leveragere.com/blog/meet-albert-roer-managing-partner-telluride-properties/
  contact_big_profile_link_text
  contact_titleManaging Partner
  contact_dre_num
  contact_quote
  contact_email[email protected]
  contact_facebook
  contact_twitter
  contact_instagram
  contact_pinterest
  contact_linkedin
  contact_youtube
  contact_phone
  contact_email_2
  contact_2_facebook
  contact_2_twitter
  contact_2_instagram
  contact_2_pinterest
  contact_2_linkedin
  contact_2_youtube
  contact_phone_2
  contact_website
  contact_name_2
  contact_profile_link_2
  contact_big_profile_link_2
  contact_big_profile_link_text_2
  contact_title_2
  contact_dre_num_2
  contact_email_3
  contact_name_3
  contact_title_3
  contact_dre_num_3
  contact_phone_3
  contact_3_facebook
  contact_3_twitter
  contact_3_instagram
  contact_3_pinterest
  contact_3_linkedin
  contact_3_youtube
  image_filename41.jpg
  logo_filename41.jpg
  contact_image_filename41.jpg
  all_properties_link_image_filename41.jpg
  all_properties_linkhttp://www.searchtelluriderealestate.com/results/?UserID=all
  video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/klILER0J-qzxAOUo0.js"></script>
  contact_video_embed_code
  meta_titleTelluride Real Estate | Telluride Properties | Leverage Global Partners
  meta_descriptionTelluride Properties is the exclusive representative for Leverage Global Partners in Telluride, Colorado, USA.
  meta_keywordsTelluride real estate, Telluride Properties, Albert Roer, Telluride Colorado, leverage global partners
  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)
  created2013-08-09 12:10:53
  modified2016-04-08 16:33:30
  dre_num012345
  uri/brokerage-detail/41/telluride-properties
  website_shortwww.tellurideproperties.com
  name_with_locationTelluride Properties
  Image(array)
  id3375
  modelLocation
  model_id112
  tagImage
  name39922990_telluride_town_shot.jpg
  typeimage/jpeg
  size8168766
  uri/assets/3375.jpg
  order0
  created2016-04-05 16:17:35
  modified2016-04-05 16:30:17
- highlighted_properties(array)
  0(array)
  Property(array)
  id1676
  brokerage_id41
  created_by_user_id0
  order0
  multi_unit(false)
  agent_1_id130
  agent_2_id0
  agent_3_id0
  nameLog Ski Retreat
  incomplete(false)
  archived(false)
  last_archived0000-00-00 00:00:00
  auto_archived_from_mlsidx(false)
  paid_featured(false)
  featured(true)
  homepage_featured(true)
  brokerage_page_featured(true)
  requested_homepage_featured_by_member(false)
  homepage_featured_by_member(false)
  dot_luxury_featured(false)
  luxury_feed_featured(false)
  force_luxury_feed_featured(false)
  luxury_autofeed_imported(false)
  luxury_feed_last_added_time0000-00-00 00:00:00
  luxury_feed_agent_user_id0
  luxury_feed_locked_to_subscription_id0
  luxury_feed_agent_purchase_date0000-00-00
  luxury_feed_agent_expiration_date0000-00-00
  digital_ad_summary_email_last_sent0000-00-00 00:00:00
  digital_ad_summary_price_changed(false)
  wsj_detail_url
  ft_detail_url
  nyt_detail_url
  juwai_detail_url
  pgl_detail_url
  mg_detail_url
  mg_c_detail_url
  mg_s_detail_url
  bp_detail_url
  mw_detail_url
  nikkei_detail_url
  wapo_detail_url
  robb_detail_url
  medium_featured(true)
  large_featured(true)
  detail_page(true)
  description<p><span>Immediate ski access, craftsmanship, elegance, and privacy define this magnificent residence and guest house, nestled directly slope side on Galloping Goose ski trail. Impeccably furnished with details such as aspen chinking between logs and inviting dry-stack stone with battered columns, your senses will be immediately stimulated when you walk through the front door. Meticulously maintained, the main house and guesthouse epitomize perfect scale, cozy for two or ideal to host extended family over the holidays. Situated on a generous 1.8-acre lot comprised of aspen, fir and spruce, the five bedroom, eight bath main residence is beautifully intertwined by heated walkway to an idyllic two bedroom, three bath guest house and generous three car garage with caretaker apartment above.</span></p>
  address438 Benchmark Drive
  address_2
  cityTelluride
  stateCO
  postal_code81435
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price8950000
  price_20
  price_usd8950000
  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
  bathrooms9
  bathrooms_20
  no_beds_baths(false)
  square_feet10469
  square_meters
  acres1
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size1
  icon_1guest-house
  icon_2ski
  icon_3acreage
  icon_4sq-ft
  icon_5gym
  icon_6
  websitehttp://stevec.searchtelluriderealestate.com/homes/438-Benchmark/Mountain-Village/CO/81435/46365009/
  meta_titleLog Ski Retreat | Telluride Real Estate | Telluride Properties
  meta_description438 Benchmark Drive is a property offered for sale in Telluride, CO, USA, presented by Telluride Properties
  meta_keywords
  bathrooms_partial2
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built1998
  virtual_tour
  video_tour
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_num32058
  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
  latitude37.923603
  longitude-107.857635
  invalid_required_fields
  invalid_optional_fieldsagent_2_id, square_meters, hectares, virtual_tour, video_tour
  went_live_today(false)
  converted(true)
  invalid(false)
  mlsidx_full_address
  mlsidx_date_listed0000-00-00
  mls_market
  primary_property_category_id0
  realstaq_initial_image_sync(false)
  digital_ad_listing_urls_automated(null)
  modified2016-04-18 05:33:02
  created2015-02-25 10:49:30
  uri/property-detail/1676/438-benchmark-drive-telluride-co-81435-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/1676/438-benchmark-drive-telluride-co-81435-usa
  address_concat438 Benchmark Drive Telluride CO 81435 USA
  google_maps_query_string438+Benchmark+Drive++Telluride+CO+81435+USA
  luxury_ad_enrolled_prettyNO
  price_prettyUSD 8,950,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty7
  bathrooms_pretty9
  bathrooms_partial_pretty2
  bathrooms_3_4_pretty0
  feed_full_bathrooms9
  date_listed2015-02-25
  overridden_brokerage_nameTelluride Properties
  overridden_brokerage_logo_uri
  lux_ad_auto_enrolled(false)
  PrimaryPropertyCategory(array)
  id(null)
  name(null)
  created(null)
  modified(null)
  Brokerage(array)
  id41
  account_executive_id236
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties8
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties-1
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id1
  WOEID2504615
  timezoneUS/Mountain
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameTelluride Properties
  broker_of_record_name
  short_nameTelluride Properties
  usernameTelllurideProperties
  passworddf9e1cb9ed6ee8ffbaeb602e5a977dba189b7205
  password_reset_hash
  monthly_invoice_amount(null)
  monthly_invoice_start_date0000-00-00
  monthly_invoice_end_date0000-00-00
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Telluride Properties is the exclusive representative for Leverage Global Partners in Telluride, Colorado, USA.</p> <p>Telluride Properties has earned a reputation as the premier Telluride real estate firm, bringing buyers and sellers together since 1986. We understand every aspect of the Telluride real estate market, including ski homes and condominiums, Telluride’s historic Victorian residences, developments, ranches, short sale & bank owned properties, vacation homes and year-round residences. Telluride Properties’ success is based on yours. We provide the tools and proactive guidance it takes to reach our clients’ goals. Our attention to details that matter most to you are hallmarks that significantly enhance the experience you deserve. Telluride Properties has a proven team of skilled real estate brokers ready to assist you with your Telluride real estate assets.</p>
  communitiesTelluride
  websitehttp://www.tellurideproperties.com
  address237 S. Oak Street
  address_2PO Box 37
  cityTelluride
  stateCO
  full_stateColorado
  countryUSA
  marketTelluride
  market_2
  postal_code81435
  phone(970) 708-5527
  phone_2
  phone_3
  wide_contact_image(false)
  contact_nameAlbert Roer
  contact_profile_link
  contact_big_profile_linkhttp://www.leveragere.com/blog/meet-albert-roer-managing-partner-telluride-properties/
  contact_big_profile_link_text
  contact_titleManaging Partner
  contact_dre_num
  contact_quote
  contact_email[email protected]
  contact_facebook
  contact_twitter
  contact_instagram
  contact_pinterest
  contact_linkedin
  contact_youtube
  contact_phone
  contact_email_2
  contact_2_facebook
  contact_2_twitter
  contact_2_instagram
  contact_2_pinterest
  contact_2_linkedin
  contact_2_youtube
  contact_phone_2
  contact_website
  contact_name_2
  contact_profile_link_2
  contact_big_profile_link_2
  contact_big_profile_link_text_2
  contact_title_2
  contact_dre_num_2
  contact_email_3
  contact_name_3
  contact_title_3
  contact_dre_num_3
  contact_phone_3
  contact_3_facebook
  contact_3_twitter
  contact_3_instagram
  contact_3_pinterest
  contact_3_linkedin
  contact_3_youtube
  image_filename41.jpg
  logo_filename41.jpg
  contact_image_filename41.jpg
  all_properties_link_image_filename41.jpg
  all_properties_linkhttp://www.searchtelluriderealestate.com/results/?UserID=all
  video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/klILER0J-qzxAOUo0.js"></script>
  contact_video_embed_code
  meta_titleTelluride Real Estate | Telluride Properties | Leverage Global Partners
  meta_descriptionTelluride Properties is the exclusive representative for Leverage Global Partners in Telluride, Colorado, USA.
  meta_keywordsTelluride real estate, Telluride Properties, Albert Roer, Telluride Colorado, leverage global partners
  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)
  created2013-08-09 12:10:53
  modified2016-04-08 16:33:30
  dre_num012345
  uri/brokerage-detail/41/telluride-properties
  website_shortwww.tellurideproperties.com
  name_with_locationTelluride Properties
  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)
  id12039
  modelProperty
  model_id1676
  tagImage
  name22961.jpg
  typeimage/jpg
  size699359
  uri/assets/12039.jpg
  order0
  created2016-04-07 16:31:01
  modified2016-04-07 16:31:01
  1(array)
  id12040
  modelProperty
  model_id1676
  tagImage
  name22962.jpg
  typeimage/jpg
  size898979
  uri/assets/12040.jpg
  order1
  created2016-04-07 16:31:01
  modified2016-04-07 16:31:01
  2(array)
  id12041
  modelProperty
  model_id1676
  tagImage
  name22963.jpg
  typeimage/jpg
  size522788
  uri/assets/12041.jpg
  order2
  created2016-04-07 16:31:01
  modified2016-04-07 16:31:01
  3(array)
  id12038
  modelProperty
  model_id1676
  tagImage
  name22960.jpg
  typeimage/jpg
  size638797
  uri/assets/12038.jpg
  order3
  created2016-04-07 16:31:01
  modified2016-04-07 16:31:01
  4(array)
  id12045
  modelProperty
  model_id1676
  tagImage
  name22967.jpg
  typeimage/jpg
  size563611
  uri/assets/12045.jpg
  order4
  created2016-04-07 16:31:02
  modified2016-04-07 16:31:02
  5(array)
  id12043
  modelProperty
  model_id1676
  tagImage
  name22965.jpg
  typeimage/jpg
  size469790
  uri/assets/12043.jpg
  order5
  created2016-04-07 16:31:02
  modified2016-04-07 16:31:02
  6(array)
  id12042
  modelProperty
  model_id1676
  tagImage
  name22964.jpg
  typeimage/jpg
  size506665
  uri/assets/12042.jpg
  order6
  created2016-04-07 16:31:01
  modified2016-04-07 16:31:01
  7(array)
  id12044
  modelProperty
  model_id1676
  tagImage
  name22966.jpg
  typeimage/jpg
  size383304
  uri/assets/12044.jpg
  order7
  created2016-04-07 16:31:02
  modified2016-04-07 16:31:02
  8(array)
  id12046
  modelProperty
  model_id1676
  tagImage
  name22973.jpg
  typeimage/jpg
  size351286
  uri/assets/12046.jpg
  order8
  created2016-04-07 16:31:02
  modified2016-04-07 16:31:02
  9(array)
  id12047
  modelProperty
  model_id1676
  tagImage
  name22976.jpg
  typeimage/jpg
  size598857
  uri/assets/12047.jpg
  order9
  created2016-04-07 16:31:02
  modified2016-04-07 16:31:02
  User(empty)
  SecondaryPropertyCategory(empty)
  PropertyFeature(array)
  0(array)
  id5
  nameGuest House
  additional(false)
  created2016-04-07 14:02:13
  modified2016-04-07 14:02:13
  PropertiesPropertyFeature(array)
  id2207
  property_id1676
  property_feature_id5
  1(array)
  id11
  nameSki In/Ski Out
  additional(false)
  created2016-04-07 14:03:53
  modified2016-04-07 14:03:53
  PropertiesPropertyFeature(array)
  id2208
  property_id1676
  property_feature_id11
  2(array)
  id6
  nameGym
  additional(false)
  created2016-04-07 14:02:29
  modified2016-04-07 14:02:29
  PropertiesPropertyFeature(array)
  id2209
  property_id1676
  property_feature_id6
  Topic(empty)
  1(array)
  Property(array)
  id2387
  brokerage_id41
  created_by_user_id0
  order0
  multi_unit(false)
  agent_1_id131
  agent_2_id132
  agent_3_id0
  nameThe Auberge Residences at Element 52
  incomplete(false)
  archived(false)
  last_archived0000-00-00 00:00:00
  auto_archived_from_mlsidx(false)
  paid_featured(false)
  featured(true)
  homepage_featured(true)
  brokerage_page_featured(true)
  requested_homepage_featured_by_member(false)
  homepage_featured_by_member(false)
  dot_luxury_featured(false)
  luxury_feed_featured(false)
  force_luxury_feed_featured(false)
  luxury_autofeed_imported(false)
  luxury_feed_last_added_time0000-00-00 00:00:00
  luxury_feed_agent_user_id0
  luxury_feed_locked_to_subscription_id0
  luxury_feed_agent_purchase_date0000-00-00
  luxury_feed_agent_expiration_date0000-00-00
  digital_ad_summary_email_last_sent0000-00-00 00:00:00
  digital_ad_summary_price_changed(false)
  wsj_detail_url
  ft_detail_url
  nyt_detail_url
  juwai_detail_url
  pgl_detail_url
  mg_detail_url
  mg_c_detail_url
  mg_s_detail_url
  bp_detail_url
  mw_detail_url
  nikkei_detail_url
  wapo_detail_url
  robb_detail_url
  medium_featured(false)
  large_featured(false)
  detail_page(true)
  description<p class="p1"><strong>Two to Five Bedroom Residences offered from $1,300,000 to $5,231,800.</strong></p> <p class="p1">The Auberge Residences at Element 52 are a unique enclave of luxury townhomes and flats offering owners and guests full turn-key services and amenities, location, and a design that sets it apart within the world-class resort town of Telluride, Colorado. Expansive decks, gourmet kitchens, formal dining areas and multiple guest suites will satisfy the most discriminating buyers. Jump on the property’s private ski lift that transports you seamlessly to the groomed Telluride Trail with uninterrupted ski access to the gondola and Chairlifts 7 and 8. At the end of the day, return to the owner’s ski lounge offeng private lockers, boot-dryers, along with ski rental and tuning services. Two heated, soaking pools are situated in the inner courtyard. Just steps away is the Spa at Element 52, an intimate retreat for restoration and rejuvenation within its three separate treatment rooms and club facilities. At the disposal of owners and guests is Gray Head, a private 900-acre wilderness preserve and year-round recreational paradise. Only 15 minutes from Telluride. The Auberge Residences at Element 52 are the epitome of service, comfort, and luxury with an unrivaled location within the town of Telluride. Ownership also includes reciprocity with other properties within the Auberge Collection, as well as Elite Alliance and 3rd Home.</p> <p class="p1">Simply the best.</p>
  address398 South Davis Street
  address_2
  cityTelluride
  stateCO
  postal_code81435
  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)
  bedrooms3
  bedrooms_20
  bathrooms3
  bathrooms_20
  no_beds_baths(false)
  square_feet2797
  square_meters
  acres0
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size0
  icon_1gym
  icon_2ski
  icon_3pool
  icon_4views
  icon_5sq-ft
  icon_6
  websitehttps://element52.aubergeresorts.com/
  meta_titleThe Auberge Residences at Element 52 | Telluride Real Estate | Telluride Properties
  meta_description398 South Davis Street is a property offered for sale in Telluride, CO, USA, presented by Telluride Properties
  meta_keywords
  bathrooms_partial1
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built2011
  virtual_tour
  video_tourhttps://player.vimeo.com/video/21609964
  digital_brochure
  video_tour_embed_code<iframe src="https://player.vimeo.com/video/21609964?title=0&byline=0&portrait=0" width="500" height="281" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>
  digital_brochure_embed_code
  mls_num29276
  wsj_property_typenew development
  nyt_property_type5
  nyt_popular_features
  propgolux_property_type2
  juwai_property_type
  juwai_category
  propgolux_property_style15
  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
  latitude37.938042
  longitude-107.817787
  invalid_required_fields
  invalid_optional_fieldssquare_meters, acres, hectares, virtual_tour
  went_live_today(false)
  converted(true)
  invalid(false)
  mlsidx_full_address
  mlsidx_date_listed0000-00-00
  mls_market
  primary_property_category_id0
  realstaq_initial_image_sync(false)
  digital_ad_listing_urls_automated(null)
  modified2016-04-18 05:33:02
  created2015-06-30 13:02:49
  uri/property-detail/2387/398-south-davis-street-telluride-co-81435-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/2387/398-south-davis-street-telluride-co-81435-usa
  address_concat398 South Davis Street Telluride CO 81435 USA
  google_maps_query_string398+South+Davis+Street++Telluride+CO+81435+USA
  luxury_ad_enrolled_prettyNO
  price_prettyUSD 2,995,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty3
  bathrooms_pretty3
  bathrooms_partial_pretty1
  bathrooms_3_4_pretty0
  feed_full_bathrooms3
  date_listed2015-06-30
  overridden_brokerage_nameTelluride Properties
  overridden_brokerage_logo_uri
  lux_ad_auto_enrolled(false)
  PrimaryPropertyCategory(array)
  id(null)
  name(null)
  created(null)
  modified(null)
  Brokerage(array)
  id41
  account_executive_id236
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties8
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties-1
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id1
  WOEID2504615
  timezoneUS/Mountain
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameTelluride Properties
  broker_of_record_name
  short_nameTelluride Properties
  usernameTelllurideProperties
  passworddf9e1cb9ed6ee8ffbaeb602e5a977dba189b7205
  password_reset_hash
  monthly_invoice_amount(null)
  monthly_invoice_start_date0000-00-00
  monthly_invoice_end_date0000-00-00
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Telluride Properties is the exclusive representative for Leverage Global Partners in Telluride, Colorado, USA.</p> <p>Telluride Properties has earned a reputation as the premier Telluride real estate firm, bringing buyers and sellers together since 1986. We understand every aspect of the Telluride real estate market, including ski homes and condominiums, Telluride’s historic Victorian residences, developments, ranches, short sale & bank owned properties, vacation homes and year-round residences. Telluride Properties’ success is based on yours. We provide the tools and proactive guidance it takes to reach our clients’ goals. Our attention to details that matter most to you are hallmarks that significantly enhance the experience you deserve. Telluride Properties has a proven team of skilled real estate brokers ready to assist you with your Telluride real estate assets.</p>
  communitiesTelluride
  websitehttp://www.tellurideproperties.com
  address237 S. Oak Street
  address_2PO Box 37
  cityTelluride
  stateCO
  full_stateColorado
  countryUSA
  marketTelluride
  market_2
  postal_code81435
  phone(970) 708-5527
  phone_2
  phone_3
  wide_contact_image(false)
  contact_nameAlbert Roer
  contact_profile_link
  contact_big_profile_linkhttp://www.leveragere.com/blog/meet-albert-roer-managing-partner-telluride-properties/
  contact_big_profile_link_text
  contact_titleManaging Partner
  contact_dre_num
  contact_quote
  contact_email[email protected]
  contact_facebook
  contact_twitter
  contact_instagram
  contact_pinterest
  contact_linkedin
  contact_youtube
  contact_phone
  contact_email_2
  contact_2_facebook
  contact_2_twitter
  contact_2_instagram
  contact_2_pinterest
  contact_2_linkedin
  contact_2_youtube
  contact_phone_2
  contact_website
  contact_name_2
  contact_profile_link_2
  contact_big_profile_link_2
  contact_big_profile_link_text_2
  contact_title_2
  contact_dre_num_2
  contact_email_3
  contact_name_3
  contact_title_3
  contact_dre_num_3
  contact_phone_3
  contact_3_facebook
  contact_3_twitter
  contact_3_instagram
  contact_3_pinterest
  contact_3_linkedin
  contact_3_youtube
  image_filename41.jpg
  logo_filename41.jpg
  contact_image_filename41.jpg
  all_properties_link_image_filename41.jpg
  all_properties_linkhttp://www.searchtelluriderealestate.com/results/?UserID=all
  video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/klILER0J-qzxAOUo0.js"></script>
  contact_video_embed_code
  meta_titleTelluride Real Estate | Telluride Properties | Leverage Global Partners
  meta_descriptionTelluride Properties is the exclusive representative for Leverage Global Partners in Telluride, Colorado, USA.
  meta_keywordsTelluride real estate, Telluride Properties, Albert Roer, Telluride Colorado, leverage global partners
  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)
  created2013-08-09 12:10:53
  modified2016-04-08 16:33:30
  dre_num012345
  uri/brokerage-detail/41/telluride-properties
  website_shortwww.tellurideproperties.com
  name_with_locationTelluride Properties
  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)
  id15423
  modelProperty
  model_id2387
  tagImage
  name22324.jpg
  typeimage/jpg
  size661746
  uri/assets/15423.jpg
  order0
  created2016-04-07 16:52:03
  modified2016-04-07 16:52:03
  1(array)
  id15424
  modelProperty
  model_id2387
  tagImage
  name22318.jpg
  typeimage/jpg
  size589086
  uri/assets/15424.jpg
  order1
  created2016-04-07 16:52:03
  modified2016-04-07 16:52:03
  2(array)
  id15419
  modelProperty
  model_id2387
  tagImage
  name22322.jpg
  typeimage/jpg
  size499280
  uri/assets/15419.jpg
  order2
  created2016-04-07 16:52:03
  modified2016-04-07 16:52:03
  3(array)
  id15422
  modelProperty
  model_id2387
  tagImage
  name22316.jpg
  typeimage/jpg
  size382117
  uri/assets/15422.jpg
  order3
  created2016-04-07 16:52:03
  modified2016-04-07 16:52:03
  4(array)
  id15425
  modelProperty
  model_id2387
  tagImage
  name22319.jpg
  typeimage/jpg
  size464983
  uri/assets/15425.jpg
  order4
  created2016-04-07 16:52:03
  modified2016-04-07 16:52:03
  5(array)
  id15420
  modelProperty
  model_id2387
  tagImage
  name22325.jpg
  typeimage/jpg
  size423371
  uri/assets/15420.jpg
  order5
  created2016-04-07 16:52:03
  modified2016-04-07 16:52:03
  6(array)
  id15427
  modelProperty
  model_id2387
  tagImage
  name22323.jpg
  typeimage/jpg
  size694108
  uri/assets/15427.jpg
  order6
  created2016-04-07 16:52:03
  modified2016-04-07 16:52:03
  7(array)
  id15426
  modelProperty
  model_id2387
  tagImage
  name22320.jpg
  typeimage/jpg
  size266689
  uri/assets/15426.jpg
  order7
  created2016-04-07 16:52:03
  modified2016-04-07 16:52:03
  8(array)
  id15421
  modelProperty
  model_id2387
  tagImage
  name22315.jpg
  typeimage/jpg
  size254993
  uri/assets/15421.jpg
  order8
  created2016-04-07 16:52:03
  modified2016-04-07 16:52:03
  User(empty)
  SecondaryPropertyCategory(empty)
  PropertyFeature(array)
  0(array)
  id6
  nameGym
  additional(false)
  created2016-04-07 14:02:29
  modified2016-04-07 14:02:29
  PropertiesPropertyFeature(array)
  id3151
  property_id2387
  property_feature_id6
  1(array)
  id11
  nameSki In/Ski Out
  additional(false)
  created2016-04-07 14:03:53
  modified2016-04-07 14:03:53
  PropertiesPropertyFeature(array)
  id3152
  property_id2387
  property_feature_id11
  2(array)
  id12
  nameSwimming Pool
  additional(false)
  created2016-04-07 14:04:12
  modified2016-04-07 14:04:12
  PropertiesPropertyFeature(array)
  id3153
  property_id2387
  property_feature_id12
  3(array)
  id14
  nameViews
  additional(false)
  created2016-04-07 14:04:55
  modified2016-04-07 14:04:55
  PropertiesPropertyFeature(array)
  id3154
  property_id2387
  property_feature_id14
  Topic(empty)
- custom_ga_event_properties(array)
  brokerageTelluride Properties, Telluride
- property(array)
  Property(array)
  id2786
  brokerage_id41
  created_by_user_id0
  order0
  multi_unit(false)
  agent_1_id130
  agent_2_id0
  agent_3_id0
  nameValentine Farm
  incomplete(false)
  archived(false)
  last_archived0000-00-00 00:00:00
  auto_archived_from_mlsidx(false)
  paid_featured(false)
  featured(true)
  homepage_featured(true)
  brokerage_page_featured(true)
  requested_homepage_featured_by_member(false)
  homepage_featured_by_member(false)
  dot_luxury_featured(false)
  luxury_feed_featured(false)
  force_luxury_feed_featured(false)
  luxury_autofeed_imported(false)
  luxury_feed_last_added_time0000-00-00 00:00:00
  luxury_feed_agent_user_id0
  luxury_feed_locked_to_subscription_id0
  luxury_feed_agent_purchase_date0000-00-00
  luxury_feed_agent_expiration_date0000-00-00
  digital_ad_summary_email_last_sent0000-00-00 00:00:00
  digital_ad_summary_price_changed(false)
  wsj_detail_url
  ft_detail_url
  nyt_detail_url
  juwai_detail_url
  pgl_detail_url
  mg_detail_url
  mg_c_detail_url
  mg_s_detail_url
  bp_detail_url
  mw_detail_url
  nikkei_detail_url
  wapo_detail_url
  robb_detail_url
  medium_featured(false)
  large_featured(false)
  detail_page(true)
  description<p><span>Certain properties exude excellence the minute you step foot on them. Valentine Farm defines itself as such a ranch. Comprised of a meticulously renovated turn-of-the-century barn, two remodeled turn-of-the-century cabins and separate 6-car garage, this idyllic compound overlooks 120 verdant acres including a magnificent 10 stall equestrian center with caretaker residence. Two generous sized ponds and prolific irrigation create a lush setting and provide perfect conditions for significant hay production. The highest quality hardware, Waterworks bath fixtures, reclaimed, historic hardwood floors, exterior stone quarried onsite and perfect choices of limestone and travertine in baths and kitchen, create an unrivaled sense of warmth and intimacy. Valentine Farm is a model of perfection.</span></p>
  address1789 44Z S
  address_2
  cityNorwood
  stateCO
  postal_code81423
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price4375000
  price_20
  price_usd4375000
  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_feet3739
  square_meters
  acres120
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size120
  icon_1acreage
  icon_2guest-house
  icon_3sq-ft
  icon_4waterfront
  icon_5garage
  icon_6
  website
  meta_titleValentine Farm | Norwood Real Estate | Telluride Properties
  meta_description1789 44Z S is a property offered for sale in Norwood, CO, USA, presented by Telluride Properties
  meta_keywords
  bathrooms_partial1
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built1890/2010
  virtual_tour
  video_tour
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_num33037
  wsj_property_typeranch
  nyt_property_type1
  nyt_popular_features
  propgolux_property_type3
  juwai_property_type
  juwai_category
  propgolux_property_style56
  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
  latitude38.022720
  longitude-108.261963
  invalid_required_fields
  invalid_optional_fieldsagent_2_id, square_meters, hectares, virtual_tour, video_tour
  went_live_today(false)
  converted(true)
  invalid(false)
  mlsidx_full_address
  mlsidx_date_listed0000-00-00
  mls_market
  primary_property_category_id0
  realstaq_initial_image_sync(false)
  digital_ad_listing_urls_automated(null)
  modified2016-04-18 05:33:02
  created2015-09-17 09:25:10
  uri/property-detail/2786/1789-44z-s-norwood-co-81423-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/2786/1789-44z-s-norwood-co-81423-usa
  address_concat1789 44Z S Norwood CO 81423 USA
  google_maps_query_string1789+44Z+S++Norwood+CO+81423+USA
  luxury_ad_enrolled_prettyNO
  price_prettyUSD 4,375,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty7
  bathrooms_pretty7
  bathrooms_partial_pretty1
  bathrooms_3_4_pretty0
  feed_full_bathrooms7
  date_listed2015-09-17
  overridden_brokerage_nameTelluride Properties
  overridden_brokerage_logo_uri/assets/2356.jpg
  lux_ad_auto_enrolled(false)
  PrimaryPropertyCategory(array)
  id(null)
  name(null)
  created(null)
  modified(null)
  Brokerage(array)
  id41
  account_executive_id236
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties8
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties-1
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id1
  WOEID2504615
  timezoneUS/Mountain
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameTelluride Properties
  broker_of_record_name
  short_nameTelluride Properties
  usernameTelllurideProperties
  passworddf9e1cb9ed6ee8ffbaeb602e5a977dba189b7205
  password_reset_hash
  monthly_invoice_amount(null)
  monthly_invoice_start_date0000-00-00
  monthly_invoice_end_date0000-00-00
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Telluride Properties is the exclusive representative for Leverage Global Partners in Telluride, Colorado, USA.</p> <p>Telluride Properties has earned a reputation as the premier Telluride real estate firm, bringing buyers and sellers together since 1986. We understand every aspect of the Telluride real estate market, including ski homes and condominiums, Telluride’s historic Victorian residences, developments, ranches, short sale & bank owned properties, vacation homes and year-round residences. Telluride Properties’ success is based on yours. We provide the tools and proactive guidance it takes to reach our clients’ goals. Our attention to details that matter most to you are hallmarks that significantly enhance the experience you deserve. Telluride Properties has a proven team of skilled real estate brokers ready to assist you with your Telluride real estate assets.</p>
  communitiesTelluride
  websitehttp://www.tellurideproperties.com
  address237 S. Oak Street
  address_2PO Box 37
  cityTelluride
  stateCO
  full_stateColorado
  countryUSA
  marketTelluride
  market_2
  postal_code81435
  phone(970) 708-5527
  phone_2
  phone_3
  wide_contact_image(false)
  contact_nameAlbert Roer
  contact_profile_link
  contact_big_profile_linkhttp://www.leveragere.com/blog/meet-albert-roer-managing-partner-telluride-properties/
  contact_big_profile_link_text
  contact_titleManaging Partner
  contact_dre_num
  contact_quote
  contact_email[email protected]
  contact_facebook
  contact_twitter
  contact_instagram
  contact_pinterest
  contact_linkedin
  contact_youtube
  contact_phone
  contact_email_2
  contact_2_facebook
  contact_2_twitter
  contact_2_instagram
  contact_2_pinterest
  contact_2_linkedin
  contact_2_youtube
  contact_phone_2
  contact_website
  contact_name_2
  contact_profile_link_2
  contact_big_profile_link_2
  contact_big_profile_link_text_2
  contact_title_2
  contact_dre_num_2
  contact_email_3
  contact_name_3
  contact_title_3
  contact_dre_num_3
  contact_phone_3
  contact_3_facebook
  contact_3_twitter
  contact_3_instagram
  contact_3_pinterest
  contact_3_linkedin
  contact_3_youtube
  image_filename41.jpg
  logo_filename41.jpg
  contact_image_filename41.jpg
  all_properties_link_image_filename41.jpg
  all_properties_linkhttp://www.searchtelluriderealestate.com/results/?UserID=all
  video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/klILER0J-qzxAOUo0.js"></script>
  contact_video_embed_code
  meta_titleTelluride Real Estate | Telluride Properties | Leverage Global Partners
  meta_descriptionTelluride Properties is the exclusive representative for Leverage Global Partners in Telluride, Colorado, USA.
  meta_keywordsTelluride real estate, Telluride Properties, Albert Roer, Telluride Colorado, leverage global partners
  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)
  created2013-08-09 12:10:53
  modified2016-04-08 16:33:30
  dre_num012345
  AccountExecutive(array)
  id236
  typeAccountExecutive
  brokerage_id0
  email[email protected]
  passworde5cc5a96287695cf8b7cace1463b1699895dcf92
  recover_hash
  first_nameLauren
  last_namePena
  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:16
  created2016-04-14 15:43:52
  notified(false)
  full_nameLauren Pena
  uri/agent-detail/236/lauren-pena
  profile_complete(true)
  Logo(array)
  id2356
  modelBrokerage
  model_id41
  tagLogo
  name41.jpg
  typeimage/jpg
  size643358
  uri/assets/2356.jpg
  order0
  created2016-03-30 11:38:48
  modified2016-03-30 11:38:48
  MainImage(array)
  id2355
  modelBrokerage
  model_id41
  tagMainImage
  name41.jpg
  typeimage/jpg
  size4943083
  uri/assets/2355.jpg
  order0
  created2016-03-30 11:38:48
  modified2016-03-30 11:38:48
  ContactImage(array)
  id2357
  modelBrokerage
  model_id41
  tagContactImage
  name41.jpg
  typeimage/jpg
  size543561
  uri/assets/2357.jpg
  order0
  created2016-03-30 11:38:48
  modified2016-03-30 11:38:48
  ContactImage2(empty)
  ContactImage3(empty)
  BrokerOfRecordLogo(empty)
  MainArticle(array)
  id103
  modelBrokerage
  model_id41
  archived(false)
  medium_featured(false)
  large_featured(false)
  titleMeet Albert Roer: Managing Partner, Telluride Properties
  authorLeverageRE
  date2013-08-29
  lead_in"We sell lifestyle. We have the most amazing, dramatic views of any ski resort," explains Albert Roer, Managing Partner of Telluride Properties. "We all love living here and we are excited to share it with people."
  body <p>Working in Telluride, just five steps from the chair lift and gondola to the Mountain Village, in a beautiful office that is set up like a living room, located on the busiest foot traffic corner in town, may be the most ideal place to conduct real estate deals. "People come by all day, to drop their stuff off or hang out, before heading to the mountain. We are the only office in town with floor duty 9-9, seven days a week."</p> <p><img class="aligncenter wp-image-1529 size-large pure-img" src="/assets/253.jpg" alt="Meet Albert Roer: Managing Partner, Telluride Properties" width="585" height="438" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/tellurideproperties2-300x225.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/tellurideproperties2-585x438.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/tellurideproperties2-80x60.jpg 80w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/tellurideproperties2.jpg 1500w" sizes="(max-width: 585px) 100vw, 585px"></p> <p>Albert sets the tone for the cooperative work environment of Telluride Properties. <strong>"We only hire people we could spend a week on a sailboat with,"</strong> he says. This atmosphere of living and working without a line in between is a template for the <strong>office's highly successful brokers to provide an exceptional level of service to their clients and first-hand expertise</strong> in Telluride lifestyle.</p> <h4>Tell us about how Telluride Properties uses social media and technology.</h4> <blockquote><p><strong>Albert:</strong> We have invested a tremendous amount on our online presence. Our websites — including <a title="Telluride Properties | Alber Roer" href="http://tellurideproperties.com" target="_blank">tellurideproperties.com</a>, <a href="http://searchtelluriderealestate.com" target="_blank">searchtelluriderealestate.com</a> and our digital magazine <a href="http://trulytelluride.com" target="_blank">trulytelluride.com</a> — are strong compliments to our agent's face-to-face interaction with our clients.</p></blockquote> <p><img class="aligncenter wp-image-1573 size-large pure-img" src="/assets/254.jpg" alt="Meet Albert Roer: Managing Partner, Telluride Properties" width="585" height="780" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/albertroerrockclimbing-225x300.jpg 225w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/albertroerrockclimbing-585x780.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/albertroerrockclimbing.jpg 1125w" sizes="(max-width: 585px) 100vw, 585px"></p> <h4>What is summer like in Telluride?</h4> <blockquote><p><strong>Albert:</strong> The old adage is "I came to ski, but stay for the summers." Telluride is the festival capital of the Rockies, with a festival of note every weekend. Everything from the famous Telluride Film Festival to food, wine, yoga and fitness festivals, make Telluride a summer destination.</p></blockquote> <p><img class="aligncenter wp-image-1531 size-large pure-img" src="/assets/255.jpg" alt="Meet Albert Roer: Managing Partner, Telluride Properties" width="585" height="389" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/tellurideproperties1-300x200.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/tellurideproperties1-585x389.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/tellurideproperties1-360x240.jpg 360w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/tellurideproperties1-600x400.jpg 600w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/tellurideproperties1.jpg 812w" sizes="(max-width: 585px) 100vw, 585px"></p> <h4>We asked Wendy McKeever, office manager of Telluride Properties to describe Albert as a colleague.</h4> <blockquote><p><strong>Wendy:</strong> Albert is truly the glue that binds our company, the heart and soul. His huge grin is always plastered across his face, and whenever you ask how he’s doing, you get the same answer: “Fabulous. Best day of my life.” <strong>He has a contagious spirit that affects all around him and that is the guiding force in the mission of our company.</strong> He is a huge part of the success of Telluride Properties, nurturing our brokers and developing a <strong>family-centric work environment that extends to our clients and keeps them coming back again and again.</strong></p></blockquote> <p>Leverage Global Partners is proud to have Albert Roer and Telluride Properties as a valued member of the network.</p>
  vimeo_id
  created2016-02-25 14:09:02
  modified2016-04-05 14:41:06
  uri/articles/view/103/meet-albert-roer-managing-partner-telluride-properties
  FeaturedImage(empty)
  Location(array)
  0(array)
  id112
  parent_id9
  brokerage_id41
  typeExclusive
  archived(false)
  use_as_topic(false)
  nameTelluride, CO, USA
  short_nameTelluride, CO, USA
  group_index
  latitude37.957722
  longitude-107.882080
  country_code
  north53.700001
  south19.700001
  east-52.599998
  west-146.600006
  zoom0
  short_descriptionEveryone loves Telluride - the lifestyle is the best!
  long_descriptionVisitors are immediately enchanted with the breathtaking setting of the historic Town of Telluride. The grand snowcapped mountain peaks ensnare the senses, while the warm embrace of the Telluride community welcomes them to paradise. Each summer the town plays host to such world-renowned events as the Telluride Bluegrass Festival, Telluride Film Festival, and Telluride Blues & Brews Festival. Telluride, Mountain Village and their surrounding areas boast a desirable array of high-end luxury and value-oriented properties. Unlike other high profile resorts, Telluride and Mountain Village both offer true ski-in/out condos & homes with grand views and sumptuous amenities.
  created2016-04-05 16:30:17
  modified2016-04-05 16:30:17
  timezoneAmerica/Boise
  population3686
  uri/locations/view/112/telluride-co-usa
  tile_nameTelluride, CO, USA
  User(array)
  0(array)
  id88
  typeBrokerageAdmin
  brokerage_id41
  email[email protected]
  passworddf9e1cb9ed6ee8ffbaeb602e5a977dba189b7205
  recover_hash
  first_nameAlbert
  last_nameRoer
  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:25:42
  created2016-04-08 16:33:30
  notified(true)
  full_nameAlbert Roer
  uri/agent-detail/88/albert-roer
  profile_complete(true)
  1(array)
  id358
  typeAgent
  brokerage_id41
  email[email protected]
  password770ed8166eac5c52ad87701032a7305ce83908ed
  recover_hash
  first_namePolly
  last_nameLeach-Lychee
  title
  dre_num
  phone970.369.5333
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:48
  created2017-08-07 15:22:48
  notified(false)
  full_namePolly Leach-Lychee
  uri/agent-detail/358/polly-leach-lychee
  profile_complete(true)
  2(array)
  id360
  typeAgent
  brokerage_id41
  email[email protected]
  password4b3a7daa651cf0ae456428500d26cf9c2f8e45e4
  recover_hash
  first_nameDamon
  last_nameDemas
  title
  dre_num
  phone970.708.2148
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:48
  created2017-08-07 15:22:48
  notified(false)
  full_nameDamon Demas
  uri/agent-detail/360/damon-demas
  profile_complete(true)
  3(array)
  id362
  typeAgent
  brokerage_id41
  email[email protected]
  password34af86c400e255930c7ee11808a70ea681532051
  recover_hash
  first_nameMike
  last_nameShimkonis
  title
  dre_num
  phone970-708-2157
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:48
  created2017-08-07 15:22:48
  notified(false)
  full_nameMike Shimkonis
  uri/agent-detail/362/mike-shimkonis
  profile_complete(true)
  uri/brokerage-detail/41/telluride-properties
  website_shortwww.tellurideproperties.com
  name_with_locationTelluride Properties - Telluride, CO, 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)
  id16812
  modelProperty
  model_id2786
  tagImage
  name26455.jpg
  typeimage/jpg
  size500296
  uri/assets/16812.jpg
  order0
  created2016-04-07 17:00:11
  modified2016-04-07 17:00:11
  1(array)
  id16813
  modelProperty
  model_id2786
  tagImage
  name26572.jpg
  typeimage/jpg
  size673936
  uri/assets/16813.jpg
  order1
  created2016-04-07 17:00:11
  modified2016-04-07 17:00:11
  2(array)
  id16814
  modelProperty
  model_id2786
  tagImage
  name26573.jpg
  typeimage/jpg
  size580750
  uri/assets/16814.jpg
  order2
  created2016-04-07 17:00:11
  modified2016-04-07 17:00:11
  3(array)
  id16819
  modelProperty
  model_id2786
  tagImage
  name26578.jpg
  typeimage/jpg
  size572918
  uri/assets/16819.jpg
  order3
  created2016-04-07 17:00:11
  modified2016-04-07 17:00:11
  4(array)
  id16816
  modelProperty
  model_id2786
  tagImage
  name26575.jpg
  typeimage/jpg
  size660964
  uri/assets/16816.jpg
  order4
  created2016-04-07 17:00:11
  modified2016-04-07 17:00:11
  5(array)
  id16818
  modelProperty
  model_id2786
  tagImage
  name26577.jpg
  typeimage/jpg
  size537058
  uri/assets/16818.jpg
  order5
  created2016-04-07 17:00:11
  modified2016-04-07 17:00:11
  6(array)
  id16817
  modelProperty
  model_id2786
  tagImage
  name26576.jpg
  typeimage/jpg
  size1766293
  uri/assets/16817.jpg
  order6
  created2016-04-07 17:00:11
  modified2016-04-07 17:00:11
  7(array)
  id16821
  modelProperty
  model_id2786
  tagImage
  name26580.jpg
  typeimage/jpg
  size670342
  uri/assets/16821.jpg
  order7
  created2016-04-07 17:00:11
  modified2016-04-07 17:00:11
  8(array)
  id16820
  modelProperty
  model_id2786
  tagImage
  name26579.jpg
  typeimage/jpg
  size588743
  uri/assets/16820.jpg
  order8
  created2016-04-07 17:00:11
  modified2016-04-07 17:00:11
  9(array)
  id16815
  modelProperty
  model_id2786
  tagImage
  name26574.jpg
  typeimage/jpg
  size616456
  uri/assets/16815.jpg
  order9
  created2016-04-07 17:00:11
  modified2016-04-07 17:00:11
  User(empty)
  SecondaryPropertyCategory(empty)
  PropertyFeature(array)
  0(array)
  id5
  nameGuest House
  additional(false)
  created2016-04-07 14:02:13
  modified2016-04-07 14:02:13
  PropertiesPropertyFeature(array)
  id3499
  property_id2786
  property_feature_id5
  Icon(array)
  id3554
  modelPropertyFeature
  model_id5
  tagIcon
  name133.png
  typeimage/png
  size1953
  uri/assets/3554.png
  order0
  created2016-04-07 14:02:11
  modified2016-04-07 14:02:13
  1(array)
  id17
  nameWaterfront
  additional(false)
  created2016-04-07 14:06:00
  modified2016-04-07 14:06:00
  PropertiesPropertyFeature(array)
  id3500
  property_id2786
  property_feature_id17
  Icon(array)
  id3566
  modelPropertyFeature
  model_id17
  tagIcon
  name145.png
  typeimage/png
  size2066
  uri/assets/3566.png
  order0
  created2016-04-07 14:05:58
  modified2016-04-07 14:06:00
  2(array)
  id4
  nameGarage
  additional(false)
  created2016-04-07 14:01:52
  modified2016-04-07 14:01:52
  PropertiesPropertyFeature(array)
  id3501
  property_id2786
  property_feature_id4
  Icon(array)
  id3553
  modelPropertyFeature
  model_id4
  tagIcon
  name132.png
  typeimage/png
  size2141
  uri/assets/3553.png
  order0
  created2016-04-07 14:01:51
  modified2016-04-07 14:01:52
  Topic(empty)
- membership_subscription_temp_allowed_login(null)
- newsletter_member_types(array)
  Leverage Member: AgentLeverage Member: Agent
  Leverage Member: Broker or ManagementLeverage Member: Broker or Management
  Non-MemberNon-Member
- $request->data(empty)
- $this->validationErrors(array)
  Subscription(empty)
  Property(empty)
  User(empty)
  PropertyFeature(empty)
  SecondaryPropertyCategory(empty)
  Topic(empty)
  PrimaryPropertyCategory(empty)
  Brokerage(empty)
  StripeSubscription(empty)
  GlobalReachReport(empty)
  AccountExecutive(empty)
  Logo(empty)
  MainImage(empty)
  ContactImage(empty)
  ContactImage2(empty)
  ContactImage3(empty)
  BrokerOfRecordLogo(empty)
  MainArticle(empty)
  Location(empty)
  FeaturedImage(empty)
  Image(empty)
  UsersProperty(empty)
  PropertiesSecondaryPropertyCategory(empty)
  PropertiesPropertyFeature(empty)
  Icon(empty)
  PropertiesTopic(empty)
- Loaded Helpers(array)
  0Permission
  1Number
  2SimpleGraph
  3DebugTimer
  4Toolbar
  5Session
  6Text
  7Flash
  8HtmlToolbar
  9Html
  10Form
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	7.4.33
User	leveragere
Home	/var/www/vhosts/leveragere.com
Script Name	/index.php
Request Uri	/property-detail/2786/1789-44z-s-norwood-co-81423-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/property-detail/2786/1789-44z-s-norwood-co-81423-usa
Remote Port	20292
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	a09d3ce2fd3ce88e-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	aiofj0YxLgHaF9D4CCEgKgAAAEE
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	aiofj0YxLgHaF9D4CCEgKgAAAEE
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781145487.931
Request Time	1781145487

====

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

Valentine Farm

Represented By: Telluride Properties

Highlighted Properties

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 8 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: 8 ms
Total Queries: 33 queries