901 McDowell Drice

901 McDowell Drive | Greensboro, NC 27408, USA | $798,000

4 Beds
4 Baths
1 Half Ba
Garage
Office

What an exceptional home! Next to the entrance to the Bog Garden and walk to Friendly Center! Fine luxury living with every attention to detail. Immaculate like new condition in this "no shoe" house. Fabulous gourmet kitchen with keeping room. Master suite on main level feels like a retreat! English pub "man cave" in the basement...This is a WOW house

Represented By: Tyler Redhead & McAlister Real Estate

Tyler Redhead & McAlister Real Estate

www.trmrealestate.com | License #: 012345

Karen Jobe
336-430-6552
Email

Main Office: 1401 Sunset Drive, Suite 100
Greensboro, NC 27408
USA

More About Karen

View On Map Property Website

Highlighted Properties

1907 Lafayette Avenue, Greensboro, N.C.

1907 Lafayette Avenue, Greensboro, N.C.

1907 Lafayette Ave | Greensboro, NC 27408
$925,000

900 Rockford Road, High Point, N.C.

900 Rockford Road, High Point, N.C.

900 Rockford Rd | High Point, NC 27262
$3,750,000

Represented By

Tyler Redhead & McAlister Real Estate

Agent Contacts: Karen Jobe 336-430-6552 | Email

Featured Location

Greensboro, NC, USA

Greensboro, NC, USA

Related Property Listings

901 McDowell Drice

901 McDowell Drice

901 McDowell Drive
Greensboro, NC 27408
$798,000

5 Wynnewood Court

5 Wynnewood Court

5 Wynnewood Court
Greensboro, NC 27408
$899,800

340 Air Harbor Road

340 Air Harbor Road

340 Air Harbor Road
Greensboro, NC 27455
$800,000

415 Sunset Drive

415 Sunset Drive

415 Subset Drive
Greensboro, NC 27408
$1,975,000

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

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

Cake Params
- plugin(null)
- controllerproperties
- actionview
- named(empty)
- pass(array)
  03607
  1901-mcdowell-drive-greensboro-nc-27408-usa
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys(empty)
- options(empty)
- defaults(array)
  controllerproperties
  actionview
  plugin(null)
- template/property-detail/*
====

Sql Log

+

Sql Logs

default

Total Time: 7 ms
Total Queries: 35 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` = 3607 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` = 122 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` = 122 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` = 122 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` = 122 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` = 122 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` = 122 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` = 122 AND `MainArticle`.`model` = 'Brokerage'	0	0	0
SELECT `FeaturedImage`.`id`, `FeaturedImage`.`model`, `FeaturedImage`.`model_id`, `FeaturedImage`.`tag`, `FeaturedImage`.`name`, `FeaturedImage`.`type`, `FeaturedImage`.`size`, `FeaturedImage`.`uri`, `FeaturedImage`.`order`, `FeaturedImage`.`created`, `FeaturedImage`.`modified` FROM `leveragere_staging2`.`assets` AS `FeaturedImage` WHERE `FeaturedImage`.`model` = 'Brokerage' AND `FeaturedImage`.`tag` = 'FeaturedImage' AND `FeaturedImage`.`model_id` = (122) 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` = (122)	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` = (122)	7	7	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` = (3607) 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` = 3607 AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	1	1	0
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` WHERE `Brokerage`.`id` = 122	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model_id` = 410 AND `Image`.`model` = 'User' AND `Image`.`tag` = 'Image'	0	0	0
SELECT `BrokerageLogoOverride`.`id`, `BrokerageLogoOverride`.`model`, `BrokerageLogoOverride`.`model_id`, `BrokerageLogoOverride`.`tag`, `BrokerageLogoOverride`.`name`, `BrokerageLogoOverride`.`type`, `BrokerageLogoOverride`.`size`, `BrokerageLogoOverride`.`uri`, `BrokerageLogoOverride`.`order`, `BrokerageLogoOverride`.`created`, `BrokerageLogoOverride`.`modified` FROM `leveragere_staging2`.`assets` AS `BrokerageLogoOverride` WHERE `BrokerageLogoOverride`.`model_id` = 410 AND `BrokerageLogoOverride`.`model` = 'User' AND `BrokerageLogoOverride`.`tag` = 'BrokerageLogoOverride'	0	0	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` = 3607 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` = 3607 AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	2	2	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 `Icon`.`id`, `Icon`.`model`, `Icon`.`model_id`, `Icon`.`tag`, `Icon`.`name`, `Icon`.`type`, `Icon`.`size`, `Icon`.`uri`, `Icon`.`order`, `Icon`.`created`, `Icon`.`modified` FROM `leveragere_staging2`.`assets` AS `Icon` WHERE `Icon`.`model_id` = 9 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	0
SELECT `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` = 3607 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` != 3607 AND `Property`.`brokerage_id` = 122 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 (1313, 863) ORDER BY `Image`.`order` ASC	16	16	0
SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (1313, 863) 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 (1313, 863) 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 (1313, 863) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	1	1	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (1313, 863) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	1	1	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` = 122 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` = 122 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 (3607, 3604, 3606, 3096) ORDER BY `Image`.`order` ASC	40	40	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 (3607, 3604, 3606, 3096) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	3	3	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (3607, 3604, 3606, 3096) 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 (3607, 3604, 3606, 3096) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	8	8	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (3607, 3604, 3606, 3096) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	0

Query Explain:

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

====

Timer

+

Memory

Peak Memory Use 14.78 MB

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

Timers

Total Request Time: 252 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	38.36
Event: Controller.initialize	4.98
Event: Controller.startup	2.60
Controller action	64.41
Event: Controller.beforeRender	17.63
» Processing toolbar data	17.54
Rendering View	88.46
» Event: View.beforeRender	0.41
» Rendering APP/View/Properties/view.ctp	3.18
» » Rendering APP/View/Elements/static_property_price.ctp	0.42
» » Rendering APP/View/Elements/property_features.ctp	0.21
» » Rendering APP/View/Elements/static_property_price.ctp #2	0.15
» » Rendering APP/View/Elements/static_property_price.ctp #3	0.16
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.14
» » Rendering APP/View/Elements/sidebar/property_list.ctp	0.99
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #5	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #6	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #7	0.14
» » 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	84.08
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)
  id3607
  brokerage_id122
  created_by_user_id0
  order0
  multi_unit(false)
  agent_1_id191
  agent_2_id0
  agent_3_id0
  name901 McDowell Drice
  incomplete(false)
  archived(false)
  last_archived0000-00-00 00:00:00
  auto_archived_from_mlsidx(false)
  paid_featured(false)
  featured(true)
  homepage_featured(false)
  brokerage_page_featured(true)
  requested_homepage_featured_by_member(false)
  homepage_featured_by_member(false)
  dot_luxury_featured(false)
  luxury_feed_featured(false)
  force_luxury_feed_featured(false)
  luxury_autofeed_imported(false)
  luxury_feed_last_added_time0000-00-00 00:00:00
  luxury_feed_agent_user_id0
  luxury_feed_locked_to_subscription_id0
  luxury_feed_agent_purchase_date0000-00-00
  luxury_feed_agent_expiration_date0000-00-00
  digital_ad_summary_email_last_sent0000-00-00 00:00:00
  digital_ad_summary_price_changed(false)
  wsj_detail_url
  ft_detail_url
  nyt_detail_url
  juwai_detail_url
  pgl_detail_url
  mg_detail_url
  mg_c_detail_url
  mg_s_detail_url
  bp_detail_url
  mw_detail_url
  nikkei_detail_url
  wapo_detail_url
  robb_detail_url
  medium_featured(false)
  large_featured(false)
  detail_page(true)
  description<p>What an exceptional home! Next to the entrance to the Bog Garden and walk to Friendly Center! Fine luxury living with every attention to detail. Immaculate like new condition in this "no shoe" house. Fabulous gourmet kitchen with keeping room. Master suite on main level feels like a retreat! English pub "man cave" in the basement...This is a WOW house</p>
  address901 McDowell Drive
  address_2
  cityGreensboro
  stateNC
  postal_code27408
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price798000
  price_20
  price_usd798000
  price_usd_20
  statusFor Sale
  status_last_changed0000-00-00 00:00:00
  status_last_changed_price_only0000-00-00 00:00:00
  lease_period
  price_upon_request(false)
  bedrooms4
  bedrooms_20
  bathrooms4
  bathrooms_20
  no_beds_baths(false)
  square_feet0
  square_meters
  acres0
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size0
  icon_1garage
  icon_2office
  icon_3
  icon_4
  icon_5
  icon_6
  websitehttp://www.trmrealestate.com/detail/901-mcdowell-drive-greensboro-nc-27408
  meta_title901 McDowell Drice | Greensboro Real Estate | Tyler Redhead & McAlister Real Estate
  meta_description901 McDowell Drive is a property offered for sale in Greensboro, NC, USA, presented by Tyler Redhead & McAlister Real Estate
  meta_keywords
  bathrooms_partial1
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built
  virtual_tour
  video_tour
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_num
  wsj_property_type
  nyt_property_type
  nyt_popular_features
  propgolux_property_type
  juwai_property_type
  juwai_category
  propgolux_property_style
  wapo_property_type
  robb_property_type
  propgolux_location_id_override
  open_house_1_start0000-00-00 00:00:00
  open_house_1_end_time00:00:00
  latitude0.000000
  longitude0.000000
  invalid_required_fields
  invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
  went_live_today(false)
  converted(true)
  invalid(false)
  mlsidx_full_address
  mlsidx_date_listed0000-00-00
  mls_market
  primary_property_category_id0
  realstaq_initial_image_sync(false)
  digital_ad_listing_urls_automated(null)
  modified2016-04-18 05:33:03
  created2016-03-17 10:10:18
  uri/property-detail/3607/901-mcdowell-drive-greensboro-nc-27408-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/3607/901-mcdowell-drive-greensboro-nc-27408-usa
  address_concat901 McDowell Drive Greensboro NC 27408 USA
  google_maps_query_string901+McDowell+Drive++Greensboro+NC+27408+USA
  luxury_ad_enrolled_prettyNO
  price_prettyUSD 798,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty4
  bathrooms_pretty4
  bathrooms_partial_pretty1
  bathrooms_3_4_pretty0
  feed_full_bathrooms4
  date_listed2016-03-17
  overridden_brokerage_nameTyler Redhead & McAlister Real Estate
  overridden_brokerage_logo_uri
  lux_ad_auto_enrolled(false)
  PrimaryPropertyCategory(array)
  id(null)
  name(null)
  created(null)
  modified(null)
  Brokerage(array)
  id122
  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_properties0
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id0
  WOEID2414469
  timezoneUS/Eastern
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameTyler Redhead & McAlister Real Estate
  broker_of_record_name
  short_nameTyler Redhead & McAlister Real Estate
  usernameTylerRedheadMcAlister
  passwordd9a1873a0974fea384d9263a2659236f46149e30
  password_reset_hash
  monthly_invoice_amount0.00
  monthly_invoice_start_date(null)
  monthly_invoice_end_date(null)
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Tyler Redhead & McAlister Real Estate is the exclusive representative for Leverage Global Partners in Greensboro, Winston Salem, High Point, Summerfield, Oak Ridge, Kernersville, and Jamestown, North Carolina, USA.</p> <p>More information coming soon!</p>
  communitiesGreensboro Winston Salem High Point Summerfield Oak Ridge Kernersville Jamestown
  websitehttp://www.trmrealestate.com/
  address1401 Sunset Drive, Suite 100
  address_2
  cityGreensboro
  stateNC
  full_stateNorth Carolina
  countryUSA
  marketGreensboro
  market_2
  postal_code27408
  phone(336) 274-1717
  phone_2
  phone_3
  wide_contact_image(false)
  contact_nameMarti Tyler, Alec McAlister & Katie Redhead
  contact_profile_link
  contact_big_profile_link
  contact_big_profile_link_text
  contact_titlePartners
  contact_dre_num
  contact_quoteWe invite you to contact us personally about Greensboro real estate.
  contact_email[email protected]
  contact_facebook
  contact_twitter
  contact_instagram
  contact_pinterest
  contact_linkedin
  contact_youtube
  contact_phone
  contact_email_2[email protected]
  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[email protected]
  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_filename122.jpg
  logo_filename122.jpg
  contact_image_filename122.jpg
  all_properties_link_image_filename122.jpg
  all_properties_linkhttp://www.trmrealestate.com/listings
  video_embed_code
  contact_video_embed_code
  meta_titleGreensboro Real Estate | Tyler Redhead & McAlister Real Estate | Leverage Global Partners
  meta_descriptionTyler Redhead & McAlister Real Estate is the exclusive representative for Leverage Global Partners in Greensboro, North Carolina, USA.
  meta_keywordsGreensboro Real Estate, Tyler Redhead & McAlister Real Estate, Leverage Global Partners, Alec McAlister
  login_message_counter3
  stats_module_1_type
  stats_module_1_value
  stats_module_2_type
  stats_module_2_value
  stats_module_3_type
  stats_module_3_value
  last_activity_email_sent0000-00-00 00:00:00
  converted(true)
  created2014-05-19 09:02:14
  modified2016-04-08 16:34:09
  dre_num012345
  uri/brokerage-detail/122/tyler-redhead-mcalister-real-estate
  website_shortwww.trmrealestate.com
  name_with_locationTyler Redhead & McAlister Real Estate
  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)
  id20050
  modelProperty
  model_id3607
  tagImage
  name35058.jpg
  typeimage/jpg
  size759651
  uri/assets/20050.jpg
  order0
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  1(array)
  id20052
  modelProperty
  model_id3607
  tagImage
  name35060.jpg
  typeimage/jpg
  size515653
  uri/assets/20052.jpg
  order1
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  2(array)
  id20053
  modelProperty
  model_id3607
  tagImage
  name35061.jpg
  typeimage/jpg
  size455030
  uri/assets/20053.jpg
  order2
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  3(array)
  id20054
  modelProperty
  model_id3607
  tagImage
  name35062.jpg
  typeimage/jpg
  size463442
  uri/assets/20054.jpg
  order3
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  4(array)
  id20055
  modelProperty
  model_id3607
  tagImage
  name35063.jpg
  typeimage/jpg
  size458491
  uri/assets/20055.jpg
  order4
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  5(array)
  id20056
  modelProperty
  model_id3607
  tagImage
  name35064.jpg
  typeimage/jpg
  size486605
  uri/assets/20056.jpg
  order5
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  6(array)
  id20057
  modelProperty
  model_id3607
  tagImage
  name35065.jpg
  typeimage/jpg
  size564254
  uri/assets/20057.jpg
  order6
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  7(array)
  id20059
  modelProperty
  model_id3607
  tagImage
  name35067.jpg
  typeimage/jpg
  size573758
  uri/assets/20059.jpg
  order7
  created2016-04-07 17:25:38
  modified2016-04-07 17:25:38
  8(array)
  id20058
  modelProperty
  model_id3607
  tagImage
  name35066.jpg
  typeimage/jpg
  size697526
  uri/assets/20058.jpg
  order8
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:38
  9(array)
  id20051
  modelProperty
  model_id3607
  tagImage
  name35059.jpg
  typeimage/jpg
  size1084914
  uri/assets/20051.jpg
  order9
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  User(array)
  0(array)
  id410
  typeAgent
  brokerage_id122
  email[email protected]
  password35fc324eef3a64a1b8fff1b76b451e5c2b591781
  recover_hash
  first_nameKaren
  last_nameJobe
  title
  dre_num
  phone336-430-6552
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:55
  created2017-08-07 15:22:55
  notified(false)
  full_nameKaren Jobe
  uri/agent-detail/410/karen-jobe
  profile_complete(true)
  UsersProperty(array)
  id244
  user_id410
  property_id3607
  sort_order0
  SecondaryPropertyCategory(empty)
  PropertyFeature(array)
  0(array)
  id4
  nameGarage
  additional(false)
  created2016-04-07 14:01:52
  modified2016-04-07 14:01:52
  PropertiesPropertyFeature(array)
  id4246
  property_id3607
  property_feature_id4
  1(array)
  id9
  nameOffice
  additional(false)
  created2016-04-07 14:03:21
  modified2016-04-07 14:03:21
  PropertiesPropertyFeature(array)
  id4247
  property_id3607
  property_feature_id9
  Topic(empty)
  1(array)
  Property(array)
  id3604
  brokerage_id122
  created_by_user_id0
  order0
  multi_unit(false)
  agent_1_id194
  agent_2_id0
  agent_3_id0
  name5 Wynnewood Court
  incomplete(false)
  archived(false)
  last_archived0000-00-00 00:00:00
  auto_archived_from_mlsidx(false)
  paid_featured(false)
  featured(true)
  homepage_featured(false)
  brokerage_page_featured(true)
  requested_homepage_featured_by_member(false)
  homepage_featured_by_member(false)
  dot_luxury_featured(false)
  luxury_feed_featured(false)
  force_luxury_feed_featured(false)
  luxury_autofeed_imported(false)
  luxury_feed_last_added_time0000-00-00 00:00:00
  luxury_feed_agent_user_id0
  luxury_feed_locked_to_subscription_id0
  luxury_feed_agent_purchase_date0000-00-00
  luxury_feed_agent_expiration_date0000-00-00
  digital_ad_summary_email_last_sent0000-00-00 00:00:00
  digital_ad_summary_price_changed(false)
  wsj_detail_url
  ft_detail_url
  nyt_detail_url
  juwai_detail_url
  pgl_detail_url
  mg_detail_url
  mg_c_detail_url
  mg_s_detail_url
  bp_detail_url
  mw_detail_url
  nikkei_detail_url
  wapo_detail_url
  robb_detail_url
  medium_featured(false)
  large_featured(false)
  detail_page(true)
  description<p>The moment you open the custom made iron front door you'll appreciate the attention to detail in this cul-de-sac home. From antique newel posts to cast stone mantels, from 150+ bottle wine nook to gourmet kitchen complete with Viking professional double oven & KitchenAid built in fridge. Home boasts 10' ceilings on main, surround sound, cinema room with 106" screen, blue stone patio with grill, 5 cubby drop zone, landing work station, large bonus room, large master closet with separate exercise room, screened porch & more!!!</p>
  address5 Wynnewood Court
  address_2
  cityGreensboro
  stateNC
  postal_code27408
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price899800
  price_20
  price_usd899800
  price_usd_20
  statusFor Sale
  status_last_changed0000-00-00 00:00:00
  status_last_changed_price_only0000-00-00 00:00:00
  lease_period
  price_upon_request(false)
  bedrooms4
  bedrooms_20
  bathrooms3
  bathrooms_20
  no_beds_baths(false)
  square_feet0
  square_meters
  acres0
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size0
  icon_1garage
  icon_2media-room
  icon_3cellar
  icon_4gym
  icon_5
  icon_6
  websitehttp://www.trmrealestate.com/detail/5-wynnewood-court-greensboro-nc-27408
  meta_title5 Wynnewood Court | Greensboro Real Estate | Tyler Redhead & McAlister Real Estate
  meta_description5 Wynnewood Court is a property offered for sale in Greensboro, NC, USA, presented by Tyler Redhead & McAlister Real Estate
  meta_keywords
  bathrooms_partial2
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built
  virtual_tour
  video_tour
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_num
  wsj_property_type
  nyt_property_type
  nyt_popular_features
  propgolux_property_type
  juwai_property_type
  juwai_category
  propgolux_property_style
  wapo_property_type
  robb_property_type
  propgolux_location_id_override
  open_house_1_start0000-00-00 00:00:00
  open_house_1_end_time00:00:00
  latitude0.000000
  longitude0.000000
  invalid_required_fields
  invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
  went_live_today(false)
  converted(true)
  invalid(false)
  mlsidx_full_address
  mlsidx_date_listed0000-00-00
  mls_market
  primary_property_category_id0
  realstaq_initial_image_sync(false)
  digital_ad_listing_urls_automated(null)
  modified2016-04-18 05:33:03
  created2016-03-17 09:49:28
  uri/property-detail/3604/5-wynnewood-court-greensboro-nc-27408-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/3604/5-wynnewood-court-greensboro-nc-27408-usa
  address_concat5 Wynnewood Court Greensboro NC 27408 USA
  google_maps_query_string5+Wynnewood+Court++Greensboro+NC+27408+USA
  luxury_ad_enrolled_prettyNO
  price_prettyUSD 899,800
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty4
  bathrooms_pretty3
  bathrooms_partial_pretty2
  bathrooms_3_4_pretty0
  feed_full_bathrooms3
  date_listed2016-03-17
  overridden_brokerage_nameTyler Redhead & McAlister Real Estate
  overridden_brokerage_logo_uri
  lux_ad_auto_enrolled(false)
  PrimaryPropertyCategory(array)
  id(null)
  name(null)
  created(null)
  modified(null)
  Brokerage(array)
  id122
  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_properties0
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id0
  WOEID2414469
  timezoneUS/Eastern
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameTyler Redhead & McAlister Real Estate
  broker_of_record_name
  short_nameTyler Redhead & McAlister Real Estate
  usernameTylerRedheadMcAlister
  passwordd9a1873a0974fea384d9263a2659236f46149e30
  password_reset_hash
  monthly_invoice_amount0.00
  monthly_invoice_start_date(null)
  monthly_invoice_end_date(null)
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Tyler Redhead & McAlister Real Estate is the exclusive representative for Leverage Global Partners in Greensboro, Winston Salem, High Point, Summerfield, Oak Ridge, Kernersville, and Jamestown, North Carolina, USA.</p> <p>More information coming soon!</p>
  communitiesGreensboro Winston Salem High Point Summerfield Oak Ridge Kernersville Jamestown
  websitehttp://www.trmrealestate.com/
  address1401 Sunset Drive, Suite 100
  address_2
  cityGreensboro
  stateNC
  full_stateNorth Carolina
  countryUSA
  marketGreensboro
  market_2
  postal_code27408
  phone(336) 274-1717
  phone_2
  phone_3
  wide_contact_image(false)
  contact_nameMarti Tyler, Alec McAlister & Katie Redhead
  contact_profile_link
  contact_big_profile_link
  contact_big_profile_link_text
  contact_titlePartners
  contact_dre_num
  contact_quoteWe invite you to contact us personally about Greensboro real estate.
  contact_email[email protected]
  contact_facebook
  contact_twitter
  contact_instagram
  contact_pinterest
  contact_linkedin
  contact_youtube
  contact_phone
  contact_email_2[email protected]
  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[email protected]
  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_filename122.jpg
  logo_filename122.jpg
  contact_image_filename122.jpg
  all_properties_link_image_filename122.jpg
  all_properties_linkhttp://www.trmrealestate.com/listings
  video_embed_code
  contact_video_embed_code
  meta_titleGreensboro Real Estate | Tyler Redhead & McAlister Real Estate | Leverage Global Partners
  meta_descriptionTyler Redhead & McAlister Real Estate is the exclusive representative for Leverage Global Partners in Greensboro, North Carolina, USA.
  meta_keywordsGreensboro Real Estate, Tyler Redhead & McAlister Real Estate, Leverage Global Partners, Alec McAlister
  login_message_counter3
  stats_module_1_type
  stats_module_1_value
  stats_module_2_type
  stats_module_2_value
  stats_module_3_type
  stats_module_3_value
  last_activity_email_sent0000-00-00 00:00:00
  converted(true)
  created2014-05-19 09:02:14
  modified2016-04-08 16:34:09
  dre_num012345
  uri/brokerage-detail/122/tyler-redhead-mcalister-real-estate
  website_shortwww.trmrealestate.com
  name_with_locationTyler Redhead & McAlister Real Estate
  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)
  id20022
  modelProperty
  model_id3604
  tagImage
  name35020.jpg
  typeimage/jpg
  size675022
  uri/assets/20022.jpg
  order0
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  1(array)
  id20030
  modelProperty
  model_id3604
  tagImage
  name35028.jpg
  typeimage/jpg
  size389291
  uri/assets/20030.jpg
  order1
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  2(array)
  id20029
  modelProperty
  model_id3604
  tagImage
  name35027.jpg
  typeimage/jpg
  size411838
  uri/assets/20029.jpg
  order2
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  3(array)
  id20024
  modelProperty
  model_id3604
  tagImage
  name35022.jpg
  typeimage/jpg
  size481021
  uri/assets/20024.jpg
  order3
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  4(array)
  id20027
  modelProperty
  model_id3604
  tagImage
  name35025.jpg
  typeimage/jpg
  size446696
  uri/assets/20027.jpg
  order4
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  5(array)
  id20028
  modelProperty
  model_id3604
  tagImage
  name35026.jpg
  typeimage/jpg
  size451094
  uri/assets/20028.jpg
  order5
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  6(array)
  id20025
  modelProperty
  model_id3604
  tagImage
  name35023.jpg
  typeimage/jpg
  size464040
  uri/assets/20025.jpg
  order6
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  7(array)
  id20026
  modelProperty
  model_id3604
  tagImage
  name35024.jpg
  typeimage/jpg
  size364567
  uri/assets/20026.jpg
  order7
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  8(array)
  id20031
  modelProperty
  model_id3604
  tagImage
  name35029.jpg
  typeimage/jpg
  size376604
  uri/assets/20031.jpg
  order8
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  9(array)
  id20023
  modelProperty
  model_id3604
  tagImage
  name35021.jpg
  typeimage/jpg
  size631946
  uri/assets/20023.jpg
  order9
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  User(array)
  0(array)
  id412
  typeAgent
  brokerage_id122
  email[email protected]
  password5ac98875c9bae5809f67faaf0851243fbbac74b8
  recover_hash
  first_nameAlec
  last_nameMcAlister
  title
  dre_num
  phone336-707-0463
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:55
  created2017-08-07 15:22:55
  notified(false)
  full_nameAlec McAlister
  uri/agent-detail/412/alec-mcalister
  profile_complete(true)
  UsersProperty(array)
  id245
  user_id412
  property_id3604
  sort_order0
  SecondaryPropertyCategory(empty)
  PropertyFeature(array)
  0(array)
  id4
  nameGarage
  additional(false)
  created2016-04-07 14:01:52
  modified2016-04-07 14:01:52
  PropertiesPropertyFeature(array)
  id4239
  property_id3604
  property_feature_id4
  1(array)
  id8
  nameMedia Room
  additional(false)
  created2016-04-07 14:03:04
  modified2016-04-07 14:03:04
  PropertiesPropertyFeature(array)
  id4240
  property_id3604
  property_feature_id8
  2(array)
  id18
  nameWine Cellar
  additional(false)
  created2016-04-07 14:06:17
  modified2016-04-07 14:06:17
  PropertiesPropertyFeature(array)
  id4241
  property_id3604
  property_feature_id18
  3(array)
  id6
  nameGym
  additional(false)
  created2016-04-07 14:02:29
  modified2016-04-07 14:02:29
  PropertiesPropertyFeature(array)
  id4242
  property_id3604
  property_feature_id6
  Topic(empty)
  2(array)
  Property(array)
  id3606
  brokerage_id122
  created_by_user_id0
  order0
  multi_unit(false)
  agent_1_id191
  agent_2_id0
  agent_3_id0
  name340 Air Harbor Road
  incomplete(false)
  archived(false)
  last_archived0000-00-00 00:00:00
  auto_archived_from_mlsidx(false)
  paid_featured(false)
  featured(true)
  homepage_featured(false)
  brokerage_page_featured(true)
  requested_homepage_featured_by_member(false)
  homepage_featured_by_member(false)
  dot_luxury_featured(false)
  luxury_feed_featured(false)
  force_luxury_feed_featured(false)
  luxury_autofeed_imported(false)
  luxury_feed_last_added_time0000-00-00 00:00:00
  luxury_feed_agent_user_id0
  luxury_feed_locked_to_subscription_id0
  luxury_feed_agent_purchase_date0000-00-00
  luxury_feed_agent_expiration_date0000-00-00
  digital_ad_summary_email_last_sent0000-00-00 00:00:00
  digital_ad_summary_price_changed(false)
  wsj_detail_url
  ft_detail_url
  nyt_detail_url
  juwai_detail_url
  pgl_detail_url
  mg_detail_url
  mg_c_detail_url
  mg_s_detail_url
  bp_detail_url
  mw_detail_url
  nikkei_detail_url
  wapo_detail_url
  robb_detail_url
  medium_featured(false)
  large_featured(false)
  detail_page(true)
  description<p>Amazing Otey Construction will exceed your expectations on this 3.22 acre estate lot. Like a retreat on the hip of Northern Estates. County taxes in a convenient location. 10' ceilings on the master, fabulous kitchen with commercial appliances. Inviting outdoor living areas with fireplace. Sodded yard with irrigation. Master on the main level with 3BR plus a bonus and office on level 2.</p>
  address340 Air Harbor Road
  address_2
  cityGreensboro
  stateNC
  postal_code27455
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price800000
  price_20
  price_usd800000
  price_usd_20
  statusFor Sale
  status_last_changed0000-00-00 00:00:00
  status_last_changed_price_only0000-00-00 00:00:00
  lease_period
  price_upon_request(false)
  bedrooms4
  bedrooms_20
  bathrooms3
  bathrooms_20
  no_beds_baths(false)
  square_feet0
  square_meters
  acres3
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size3
  icon_1acreage
  icon_2garage
  icon_3
  icon_4
  icon_5
  icon_6
  websitehttp://www.trmrealestate.com/detail/340-air-harbor-road-greensboro-nc-27455
  meta_title340 Air Harbor Road | Greensboro Real Estate | Tyler Redhead & McAlister Real Estate
  meta_description340 Air Harbor Road is a property offered for sale in Greensboro, NC, USA, presented by Tyler Redhead & McAlister Real Estate
  meta_keywords
  bathrooms_partial1
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built
  virtual_tour
  video_tour
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_num
  wsj_property_type
  nyt_property_type
  nyt_popular_features
  propgolux_property_type
  juwai_property_type
  juwai_category
  propgolux_property_style
  wapo_property_type
  robb_property_type
  propgolux_location_id_override
  open_house_1_start0000-00-00 00:00:00
  open_house_1_end_time00:00:00
  latitude0.000000
  longitude0.000000
  invalid_required_fields
  invalid_optional_fieldsagent_2_id, square_feet, square_meters, hectares, virtual_tour, video_tour
  went_live_today(false)
  converted(true)
  invalid(false)
  mlsidx_full_address
  mlsidx_date_listed0000-00-00
  mls_market
  primary_property_category_id0
  realstaq_initial_image_sync(false)
  digital_ad_listing_urls_automated(null)
  modified2016-04-18 05:33:03
  created2016-03-17 09:58:47
  uri/property-detail/3606/340-air-harbor-road-greensboro-nc-27455-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/3606/340-air-harbor-road-greensboro-nc-27455-usa
  address_concat340 Air Harbor Road Greensboro NC 27455 USA
  google_maps_query_string340+Air+Harbor+Road++Greensboro+NC+27455+USA
  luxury_ad_enrolled_prettyNO
  price_prettyUSD 800,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty4
  bathrooms_pretty3
  bathrooms_partial_pretty1
  bathrooms_3_4_pretty0
  feed_full_bathrooms3
  date_listed2016-03-17
  overridden_brokerage_nameTyler Redhead & McAlister Real Estate
  overridden_brokerage_logo_uri
  lux_ad_auto_enrolled(false)
  PrimaryPropertyCategory(array)
  id(null)
  name(null)
  created(null)
  modified(null)
  Brokerage(array)
  id122
  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_properties0
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id0
  WOEID2414469
  timezoneUS/Eastern
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameTyler Redhead & McAlister Real Estate
  broker_of_record_name
  short_nameTyler Redhead & McAlister Real Estate
  usernameTylerRedheadMcAlister
  passwordd9a1873a0974fea384d9263a2659236f46149e30
  password_reset_hash
  monthly_invoice_amount0.00
  monthly_invoice_start_date(null)
  monthly_invoice_end_date(null)
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Tyler Redhead & McAlister Real Estate is the exclusive representative for Leverage Global Partners in Greensboro, Winston Salem, High Point, Summerfield, Oak Ridge, Kernersville, and Jamestown, North Carolina, USA.</p> <p>More information coming soon!</p>
  communitiesGreensboro Winston Salem High Point Summerfield Oak Ridge Kernersville Jamestown
  websitehttp://www.trmrealestate.com/
  address1401 Sunset Drive, Suite 100
  address_2
  cityGreensboro
  stateNC
  full_stateNorth Carolina
  countryUSA
  marketGreensboro
  market_2
  postal_code27408
  phone(336) 274-1717
  phone_2
  phone_3
  wide_contact_image(false)
  contact_nameMarti Tyler, Alec McAlister & Katie Redhead
  contact_profile_link
  contact_big_profile_link
  contact_big_profile_link_text
  contact_titlePartners
  contact_dre_num
  contact_quoteWe invite you to contact us personally about Greensboro real estate.
  contact_email[email protected]
  contact_facebook
  contact_twitter
  contact_instagram
  contact_pinterest
  contact_linkedin
  contact_youtube
  contact_phone
  contact_email_2[email protected]
  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[email protected]
  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_filename122.jpg
  logo_filename122.jpg
  contact_image_filename122.jpg
  all_properties_link_image_filename122.jpg
  all_properties_linkhttp://www.trmrealestate.com/listings
  video_embed_code
  contact_video_embed_code
  meta_titleGreensboro Real Estate | Tyler Redhead & McAlister Real Estate | Leverage Global Partners
  meta_descriptionTyler Redhead & McAlister Real Estate is the exclusive representative for Leverage Global Partners in Greensboro, North Carolina, USA.
  meta_keywordsGreensboro Real Estate, Tyler Redhead & McAlister Real Estate, Leverage Global Partners, Alec McAlister
  login_message_counter3
  stats_module_1_type
  stats_module_1_value
  stats_module_2_type
  stats_module_2_value
  stats_module_3_type
  stats_module_3_value
  last_activity_email_sent0000-00-00 00:00:00
  converted(true)
  created2014-05-19 09:02:14
  modified2016-04-08 16:34:09
  dre_num012345
  uri/brokerage-detail/122/tyler-redhead-mcalister-real-estate
  website_shortwww.trmrealestate.com
  name_with_locationTyler Redhead & McAlister Real Estate
  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)
  id20040
  modelProperty
  model_id3606
  tagImage
  name35038.jpg
  typeimage/jpg
  size949897
  uri/assets/20040.jpg
  order0
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  1(array)
  id20042
  modelProperty
  model_id3606
  tagImage
  name35040.jpg
  typeimage/jpg
  size288283
  uri/assets/20042.jpg
  order1
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  2(array)
  id20044
  modelProperty
  model_id3606
  tagImage
  name35042.jpg
  typeimage/jpg
  size246006
  uri/assets/20044.jpg
  order2
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  3(array)
  id20043
  modelProperty
  model_id3606
  tagImage
  name35041.jpg
  typeimage/jpg
  size287138
  uri/assets/20043.jpg
  order3
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  4(array)
  id20045
  modelProperty
  model_id3606
  tagImage
  name35043.jpg
  typeimage/jpg
  size275672
  uri/assets/20045.jpg
  order4
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  5(array)
  id20046
  modelProperty
  model_id3606
  tagImage
  name35044.jpg
  typeimage/jpg
  size295144
  uri/assets/20046.jpg
  order5
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  6(array)
  id20047
  modelProperty
  model_id3606
  tagImage
  name35045.jpg
  typeimage/jpg
  size327744
  uri/assets/20047.jpg
  order6
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  7(array)
  id20049
  modelProperty
  model_id3606
  tagImage
  name35047.jpg
  typeimage/jpg
  size348733
  uri/assets/20049.jpg
  order7
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  8(array)
  id20048
  modelProperty
  model_id3606
  tagImage
  name35046.jpg
  typeimage/jpg
  size789109
  uri/assets/20048.jpg
  order8
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  9(array)
  id20041
  modelProperty
  model_id3606
  tagImage
  name35039.jpg
  typeimage/jpg
  size618715
  uri/assets/20041.jpg
  order9
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  User(array)
  0(array)
  id410
  typeAgent
  brokerage_id122
  email[email protected]
  password35fc324eef3a64a1b8fff1b76b451e5c2b591781
  recover_hash
  first_nameKaren
  last_nameJobe
  title
  dre_num
  phone336-430-6552
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:55
  created2017-08-07 15:22:55
  notified(false)
  full_nameKaren Jobe
  uri/agent-detail/410/karen-jobe
  profile_complete(true)
  UsersProperty(array)
  id243
  user_id410
  property_id3606
  sort_order0
  SecondaryPropertyCategory(empty)
  PropertyFeature(array)
  0(array)
  id4
  nameGarage
  additional(false)
  created2016-04-07 14:01:52
  modified2016-04-07 14:01:52
  PropertiesPropertyFeature(array)
  id4245
  property_id3606
  property_feature_id4
  Topic(empty)
  3(array)
  Property(array)
  id3096
  brokerage_id122
  created_by_user_id0
  order4
  multi_unit(false)
  agent_1_id192
  agent_2_id0
  agent_3_id0
  name415 Sunset Drive
  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 class="wrapped-field">Situated on park-like grounds overlooking Greensboro Country Club's golf course. Custom-made & laid Italian marble veined floors, generous room sizes, extraordinary amenities & appointments, formal entry with curved stairway, back service stairs to butler's pantry & kitchen area, connoisseur's wine cellar (800 bottle), private terraces, main-level guest suite, detached garage with additional quarters. Open kitchen, breakfast, & family rooms. Stunning home & grounds, one of Old Irving Park's gems. </span></p>
  address415 Subset Drive
  address_2
  cityGreensboro
  stateNC
  postal_code27408
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price1975000
  price_20
  price_usd1975000
  price_usd_20
  statusFor Sale
  status_last_changed0000-00-00 00:00:00
  status_last_changed_price_only0000-00-00 00:00:00
  lease_period
  price_upon_request(false)
  bedrooms5
  bedrooms_20
  bathrooms5
  bathrooms_20
  no_beds_baths(false)
  square_feet0
  square_meters
  acres0
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size0
  icon_1library
  icon_2cellar
  icon_3
  icon_4
  icon_5
  icon_6
  websitehttp://www.trmrealestate.com/detail/415-sunset-drive-greensboro-nc-27408
  meta_title415 Sunset Drive | Greensboro Real Estate | Tyler Redhead & McAlister Real Estate
  meta_description415 Subset Drive is a property offered for sale in Greensboro, NC, USA, presented by Tyler Redhead & McAlister Real Estate
  meta_keywords
  bathrooms_partial2
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built
  virtual_tour
  video_tour
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_num
  wsj_property_type
  nyt_property_type
  nyt_popular_features
  propgolux_property_type
  juwai_property_type
  juwai_category
  propgolux_property_style
  wapo_property_type
  robb_property_type
  propgolux_location_id_override
  open_house_1_start0000-00-00 00:00:00
  open_house_1_end_time00:00:00
  latitude0.000000
  longitude0.000000
  invalid_required_fieldslatitude, longitude
  invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, year_built, virtual_tour, video_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
  went_live_today(false)
  converted(true)
  invalid(false)
  mlsidx_full_address
  mlsidx_date_listed0000-00-00
  mls_market
  primary_property_category_id0
  realstaq_initial_image_sync(false)
  digital_ad_listing_urls_automated(null)
  modified2016-04-18 05:33:03
  created2015-11-16 08:11:03
  uri/property-detail/3096/415-subset-drive-greensboro-nc-27408-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/3096/415-subset-drive-greensboro-nc-27408-usa
  address_concat415 Subset Drive Greensboro NC 27408 USA
  google_maps_query_string415+Subset+Drive++Greensboro+NC+27408+USA
  luxury_ad_enrolled_prettyNO
  price_prettyUSD 1,975,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty5
  bathrooms_pretty5
  bathrooms_partial_pretty2
  bathrooms_3_4_pretty0
  feed_full_bathrooms5
  date_listed2015-11-16
  overridden_brokerage_nameTyler Redhead & McAlister Real Estate
  overridden_brokerage_logo_uri
  lux_ad_auto_enrolled(false)
  PrimaryPropertyCategory(array)
  id(null)
  name(null)
  created(null)
  modified(null)
  Brokerage(array)
  id122
  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_properties0
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id0
  WOEID2414469
  timezoneUS/Eastern
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameTyler Redhead & McAlister Real Estate
  broker_of_record_name
  short_nameTyler Redhead & McAlister Real Estate
  usernameTylerRedheadMcAlister
  passwordd9a1873a0974fea384d9263a2659236f46149e30
  password_reset_hash
  monthly_invoice_amount0.00
  monthly_invoice_start_date(null)
  monthly_invoice_end_date(null)
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Tyler Redhead & McAlister Real Estate is the exclusive representative for Leverage Global Partners in Greensboro, Winston Salem, High Point, Summerfield, Oak Ridge, Kernersville, and Jamestown, North Carolina, USA.</p> <p>More information coming soon!</p>
  communitiesGreensboro Winston Salem High Point Summerfield Oak Ridge Kernersville Jamestown
  websitehttp://www.trmrealestate.com/
  address1401 Sunset Drive, Suite 100
  address_2
  cityGreensboro
  stateNC
  full_stateNorth Carolina
  countryUSA
  marketGreensboro
  market_2
  postal_code27408
  phone(336) 274-1717
  phone_2
  phone_3
  wide_contact_image(false)
  contact_nameMarti Tyler, Alec McAlister & Katie Redhead
  contact_profile_link
  contact_big_profile_link
  contact_big_profile_link_text
  contact_titlePartners
  contact_dre_num
  contact_quoteWe invite you to contact us personally about Greensboro real estate.
  contact_email[email protected]
  contact_facebook
  contact_twitter
  contact_instagram
  contact_pinterest
  contact_linkedin
  contact_youtube
  contact_phone
  contact_email_2[email protected]
  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[email protected]
  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_filename122.jpg
  logo_filename122.jpg
  contact_image_filename122.jpg
  all_properties_link_image_filename122.jpg
  all_properties_linkhttp://www.trmrealestate.com/listings
  video_embed_code
  contact_video_embed_code
  meta_titleGreensboro Real Estate | Tyler Redhead & McAlister Real Estate | Leverage Global Partners
  meta_descriptionTyler Redhead & McAlister Real Estate is the exclusive representative for Leverage Global Partners in Greensboro, North Carolina, USA.
  meta_keywordsGreensboro Real Estate, Tyler Redhead & McAlister Real Estate, Leverage Global Partners, Alec McAlister
  login_message_counter3
  stats_module_1_type
  stats_module_1_value
  stats_module_2_type
  stats_module_2_value
  stats_module_3_type
  stats_module_3_value
  last_activity_email_sent0000-00-00 00:00:00
  converted(true)
  created2014-05-19 09:02:14
  modified2016-04-08 16:34:09
  dre_num012345
  uri/brokerage-detail/122/tyler-redhead-mcalister-real-estate
  website_shortwww.trmrealestate.com
  name_with_locationTyler Redhead & McAlister Real Estate
  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)
  id18085
  modelProperty
  model_id3096
  tagImage
  name29737.jpg
  typeimage/jpg
  size1463098
  uri/assets/18085.jpg
  order0
  created2016-04-07 17:08:02
  modified2016-04-07 17:08:02
  1(array)
  id18078
  modelProperty
  model_id3096
  tagImage
  name29730.jpg
  typeimage/jpg
  size352814
  uri/assets/18078.jpg
  order1
  created2016-04-07 17:08:02
  modified2016-04-07 17:08:02
  2(array)
  id18082
  modelProperty
  model_id3096
  tagImage
  name29734.jpg
  typeimage/jpg
  size316633
  uri/assets/18082.jpg
  order2
  created2016-04-07 17:08:02
  modified2016-04-07 17:08:02
  3(array)
  id18081
  modelProperty
  model_id3096
  tagImage
  name29733.jpg
  typeimage/jpg
  size385280
  uri/assets/18081.jpg
  order3
  created2016-04-07 17:08:02
  modified2016-04-07 17:08:02
  4(array)
  id18084
  modelProperty
  model_id3096
  tagImage
  name29736.jpg
  typeimage/jpg
  size423549
  uri/assets/18084.jpg
  order4
  created2016-04-07 17:08:02
  modified2016-04-07 17:08:02
  5(array)
  id18079
  modelProperty
  model_id3096
  tagImage
  name29731.jpg
  typeimage/jpg
  size481112
  uri/assets/18079.jpg
  order5
  created2016-04-07 17:08:02
  modified2016-04-07 17:08:02
  6(array)
  id18077
  modelProperty
  model_id3096
  tagImage
  name29729.jpg
  typeimage/jpg
  size377785
  uri/assets/18077.jpg
  order6
  created2016-04-07 17:08:02
  modified2016-04-07 17:08:02
  7(array)
  id18076
  modelProperty
  model_id3096
  tagImage
  name29728.jpg
  typeimage/jpg
  size398759
  uri/assets/18076.jpg
  order7
  created2016-04-07 17:08:02
  modified2016-04-07 17:08:02
  8(array)
  id18080
  modelProperty
  model_id3096
  tagImage
  name29732.jpg
  typeimage/jpg
  size482801
  uri/assets/18080.jpg
  order8
  created2016-04-07 17:08:02
  modified2016-04-07 17:08:02
  9(array)
  id18083
  modelProperty
  model_id3096
  tagImage
  name29735.jpg
  typeimage/jpg
  size381825
  uri/assets/18083.jpg
  order9
  created2016-04-07 17:08:02
  modified2016-04-07 17:08:02
  User(empty)
  SecondaryPropertyCategory(empty)
  PropertyFeature(array)
  0(array)
  id18
  nameWine Cellar
  additional(false)
  created2016-04-07 14:06:17
  modified2016-04-07 14:06:17
  PropertiesPropertyFeature(array)
  id3813
  property_id3096
  property_feature_id18
  Topic(empty)
- sidebar_locations(array)
  0(array)
  Location(array)
  id93
  parent_id8
  brokerage_id122
  typeExclusive
  archived(false)
  use_as_topic(false)
  nameGreensboro, NC, USA
  short_nameGreensboro, NC, USA
  group_index
  latitude36.072636
  longitude-79.791977
  country_code
  north53.700001
  south19.700001
  east-52.599998
  west-146.600006
  zoom0
  short_description
  long_descriptionMore information coming soon!
  created2016-04-05 11:25:13
  modified2016-04-05 11:25:13
  timezoneAmerica/New_York
  population280000
  uri/locations/view/93/greensboro-nc-usa
  tile_nameGreensboro, NC, USA
  Brokerage(array)
  id122
  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_properties0
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id0
  WOEID2414469
  timezoneUS/Eastern
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameTyler Redhead & McAlister Real Estate
  broker_of_record_name
  short_nameTyler Redhead & McAlister Real Estate
  usernameTylerRedheadMcAlister
  passwordd9a1873a0974fea384d9263a2659236f46149e30
  password_reset_hash
  monthly_invoice_amount0.00
  monthly_invoice_start_date(null)
  monthly_invoice_end_date(null)
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Tyler Redhead & McAlister Real Estate is the exclusive representative for Leverage Global Partners in Greensboro, Winston Salem, High Point, Summerfield, Oak Ridge, Kernersville, and Jamestown, North Carolina, USA.</p> <p>More information coming soon!</p>
  communitiesGreensboro Winston Salem High Point Summerfield Oak Ridge Kernersville Jamestown
  websitehttp://www.trmrealestate.com/
  address1401 Sunset Drive, Suite 100
  address_2
  cityGreensboro
  stateNC
  full_stateNorth Carolina
  countryUSA
  marketGreensboro
  market_2
  postal_code27408
  phone(336) 274-1717
  phone_2
  phone_3
  wide_contact_image(false)
  contact_nameMarti Tyler, Alec McAlister & Katie Redhead
  contact_profile_link
  contact_big_profile_link
  contact_big_profile_link_text
  contact_titlePartners
  contact_dre_num
  contact_quoteWe invite you to contact us personally about Greensboro real estate.
  contact_email[email protected]
  contact_facebook
  contact_twitter
  contact_instagram
  contact_pinterest
  contact_linkedin
  contact_youtube
  contact_phone
  contact_email_2[email protected]
  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[email protected]
  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_filename122.jpg
  logo_filename122.jpg
  contact_image_filename122.jpg
  all_properties_link_image_filename122.jpg
  all_properties_linkhttp://www.trmrealestate.com/listings
  video_embed_code
  contact_video_embed_code
  meta_titleGreensboro Real Estate | Tyler Redhead & McAlister Real Estate | Leverage Global Partners
  meta_descriptionTyler Redhead & McAlister Real Estate is the exclusive representative for Leverage Global Partners in Greensboro, North Carolina, USA.
  meta_keywordsGreensboro Real Estate, Tyler Redhead & McAlister Real Estate, Leverage Global Partners, Alec McAlister
  login_message_counter3
  stats_module_1_type
  stats_module_1_value
  stats_module_2_type
  stats_module_2_value
  stats_module_3_type
  stats_module_3_value
  last_activity_email_sent0000-00-00 00:00:00
  converted(true)
  created2014-05-19 09:02:14
  modified2016-04-08 16:34:09
  dre_num012345
  uri/brokerage-detail/122/tyler-redhead-mcalister-real-estate
  website_shortwww.trmrealestate.com
  name_with_locationTyler Redhead & McAlister Real Estate
  Image(array)
  id3027
  modelLocation
  model_id93
  tagImage
  namegreensboro.jpg
  typeimage/jpeg
  size145338
  uri/assets/3027.jpg
  order0
  created2016-04-05 11:25:06
  modified2016-04-05 11:25:13
- highlighted_properties(array)
  0(array)
  Property(array)
  id1313
  brokerage_id122
  created_by_user_id0
  order2
  multi_unit(false)
  agent_1_id198
  agent_2_id0
  agent_3_id0
  name1907 Lafayette Avenue, Greensboro, N.C.
  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>Zenke designed custom home on #5 Fairway of the Greensboro Country Club. This home of distinction will capture your breath the moment you enter the gracious foyer. 10' ceilings, extensive molding, custom cabinetry and oversized rooms are just a few of the features this home boasts. Master Suite has his/her baths and closets, a coffee bar, and sitting room with French doors opening to the terrace. Basement has full kitchen with bedroom/office & bathroom. Outside entertaining is at its best with a complete kitchen. Extensive landscaping and fenced yard on a cul-d-sac!</p>
  address1907 Lafayette Ave
  address_2
  cityGreensboro
  stateNC
  postal_code27408
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price925000
  price_20
  price_usd925000
  price_usd_20
  statusFor Sale
  status_last_changed0000-00-00 00:00:00
  status_last_changed_price_only0000-00-00 00:00:00
  lease_period
  price_upon_request(false)
  bedrooms4
  bedrooms_20
  bathrooms5
  bathrooms_20
  no_beds_baths(false)
  square_feet0
  square_meters
  acres0
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size0
  icon_1balcony-terrace
  icon_2
  icon_3
  icon_4
  icon_5
  icon_6
  websitehttp://www.trmrealestate.com/detail/1907-lafayette-greensboro-nc-27408
  meta_title1907 Lafayette Avenue, Greensboro, N.C. | Greensboro Real Estate | Tyler Redhead & McAlister Real Estate
  meta_description1907 Lafayette Ave is a property offered for sale in Greensboro, NC, USA, presented by Tyler Redhead & McAlister Real Estate
  meta_keywords
  bathrooms_partial0
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built
  virtual_tour
  video_tourhttp://www.tourfactory.com/yt1235715
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_num
  wsj_property_type
  nyt_property_type
  nyt_popular_features
  propgolux_property_type
  juwai_property_type
  juwai_category
  propgolux_property_style
  wapo_property_type
  robb_property_type
  propgolux_location_id_override
  open_house_1_start0000-00-00 00:00:00
  open_house_1_end_time00:00:00
  latitude0.000000
  longitude0.000000
  invalid_required_fields
  invalid_optional_fieldsagent_2_id, bathrooms_partial, square_feet, square_meters, 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
  created2014-11-17 10:22:58
  uri/property-detail/1313/1907-lafayette-ave-greensboro-nc-27408-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/1313/1907-lafayette-ave-greensboro-nc-27408-usa
  address_concat1907 Lafayette Ave Greensboro NC 27408 USA
  google_maps_query_string1907+Lafayette+Ave++Greensboro+NC+27408+USA
  luxury_ad_enrolled_prettyNO
  price_prettyUSD 925,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty4
  bathrooms_pretty5
  bathrooms_partial_pretty0
  bathrooms_3_4_pretty0
  feed_full_bathrooms5
  date_listed2014-11-17
  overridden_brokerage_nameTyler Redhead & McAlister Real Estate
  overridden_brokerage_logo_uri
  lux_ad_auto_enrolled(false)
  PrimaryPropertyCategory(array)
  id(null)
  name(null)
  created(null)
  modified(null)
  Brokerage(array)
  id122
  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_properties0
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id0
  WOEID2414469
  timezoneUS/Eastern
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameTyler Redhead & McAlister Real Estate
  broker_of_record_name
  short_nameTyler Redhead & McAlister Real Estate
  usernameTylerRedheadMcAlister
  passwordd9a1873a0974fea384d9263a2659236f46149e30
  password_reset_hash
  monthly_invoice_amount0.00
  monthly_invoice_start_date(null)
  monthly_invoice_end_date(null)
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Tyler Redhead & McAlister Real Estate is the exclusive representative for Leverage Global Partners in Greensboro, Winston Salem, High Point, Summerfield, Oak Ridge, Kernersville, and Jamestown, North Carolina, USA.</p> <p>More information coming soon!</p>
  communitiesGreensboro Winston Salem High Point Summerfield Oak Ridge Kernersville Jamestown
  websitehttp://www.trmrealestate.com/
  address1401 Sunset Drive, Suite 100
  address_2
  cityGreensboro
  stateNC
  full_stateNorth Carolina
  countryUSA
  marketGreensboro
  market_2
  postal_code27408
  phone(336) 274-1717
  phone_2
  phone_3
  wide_contact_image(false)
  contact_nameMarti Tyler, Alec McAlister & Katie Redhead
  contact_profile_link
  contact_big_profile_link
  contact_big_profile_link_text
  contact_titlePartners
  contact_dre_num
  contact_quoteWe invite you to contact us personally about Greensboro real estate.
  contact_email[email protected]
  contact_facebook
  contact_twitter
  contact_instagram
  contact_pinterest
  contact_linkedin
  contact_youtube
  contact_phone
  contact_email_2[email protected]
  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[email protected]
  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_filename122.jpg
  logo_filename122.jpg
  contact_image_filename122.jpg
  all_properties_link_image_filename122.jpg
  all_properties_linkhttp://www.trmrealestate.com/listings
  video_embed_code
  contact_video_embed_code
  meta_titleGreensboro Real Estate | Tyler Redhead & McAlister Real Estate | Leverage Global Partners
  meta_descriptionTyler Redhead & McAlister Real Estate is the exclusive representative for Leverage Global Partners in Greensboro, North Carolina, USA.
  meta_keywordsGreensboro Real Estate, Tyler Redhead & McAlister Real Estate, Leverage Global Partners, Alec McAlister
  login_message_counter3
  stats_module_1_type
  stats_module_1_value
  stats_module_2_type
  stats_module_2_value
  stats_module_3_type
  stats_module_3_value
  last_activity_email_sent0000-00-00 00:00:00
  converted(true)
  created2014-05-19 09:02:14
  modified2016-04-08 16:34:09
  dre_num012345
  uri/brokerage-detail/122/tyler-redhead-mcalister-real-estate
  website_shortwww.trmrealestate.com
  name_with_locationTyler Redhead & McAlister Real Estate
  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)
  id12709
  modelProperty
  model_id1313
  tagImage
  name11316.jpg
  typeimage/jpg
  size889128
  uri/assets/12709.jpg
  order0
  created2016-04-07 16:35:03
  modified2016-04-07 16:35:04
  1(array)
  id12710
  modelProperty
  model_id1313
  tagImage
  name11317.jpg
  typeimage/jpg
  size420970
  uri/assets/12710.jpg
  order1
  created2016-04-07 16:35:04
  modified2016-04-07 16:35:04
  2(array)
  id12711
  modelProperty
  model_id1313
  tagImage
  name11318.jpg
  typeimage/jpg
  size440960
  uri/assets/12711.jpg
  order2
  created2016-04-07 16:35:04
  modified2016-04-07 16:35:04
  3(array)
  id12712
  modelProperty
  model_id1313
  tagImage
  name11319.jpg
  typeimage/jpg
  size319412
  uri/assets/12712.jpg
  order3
  created2016-04-07 16:35:04
  modified2016-04-07 16:35:04
  4(array)
  id12713
  modelProperty
  model_id1313
  tagImage
  name11320.jpg
  typeimage/jpg
  size462590
  uri/assets/12713.jpg
  order4
  created2016-04-07 16:35:04
  modified2016-04-07 16:35:04
  5(array)
  id12714
  modelProperty
  model_id1313
  tagImage
  name11321.jpg
  typeimage/jpg
  size411470
  uri/assets/12714.jpg
  order5
  created2016-04-07 16:35:04
  modified2016-04-07 16:35:04
  6(array)
  id12715
  modelProperty
  model_id1313
  tagImage
  name11322.jpg
  typeimage/jpg
  size306291
  uri/assets/12715.jpg
  order6
  created2016-04-07 16:35:04
  modified2016-04-07 16:35:04
  7(array)
  id12716
  modelProperty
  model_id1313
  tagImage
  name11323.jpg
  typeimage/jpg
  size860118
  uri/assets/12716.jpg
  order7
  created2016-04-07 16:35:04
  modified2016-04-07 16:35:04
  8(array)
  id12717
  modelProperty
  model_id1313
  tagImage
  name11324.jpg
  typeimage/jpg
  size801728
  uri/assets/12717.jpg
  order8
  created2016-04-07 16:35:04
  modified2016-04-07 16:35:04
  9(array)
  id12718
  modelProperty
  model_id1313
  tagImage
  name11325.jpg
  typeimage/jpg
  size1093163
  uri/assets/12718.jpg
  order9
  created2016-04-07 16:35:04
  modified2016-04-07 16:35:04
  User(empty)
  SecondaryPropertyCategory(empty)
  PropertyFeature(array)
  0(array)
  id1
  nameBalcony/Terrace
  additional(false)
  created2016-04-07 14:00:26
  modified2016-04-07 14:00:26
  PropertiesPropertyFeature(array)
  id2386
  property_id1313
  property_feature_id1
  Topic(empty)
  1(array)
  Property(array)
  id863
  brokerage_id122
  created_by_user_id0
  order5
  multi_unit(false)
  agent_1_id192
  agent_2_id0
  agent_3_id0
  name900 Rockford Road, High Point, N.C.
  incomplete(false)
  archived(false)
  last_archived0000-00-00 00:00:00
  auto_archived_from_mlsidx(false)
  paid_featured(false)
  featured(true)
  homepage_featured(false)
  brokerage_page_featured(true)
  requested_homepage_featured_by_member(false)
  homepage_featured_by_member(false)
  dot_luxury_featured(false)
  luxury_feed_featured(false)
  force_luxury_feed_featured(false)
  luxury_autofeed_imported(false)
  luxury_feed_last_added_time0000-00-00 00:00:00
  luxury_feed_agent_user_id0
  luxury_feed_locked_to_subscription_id0
  luxury_feed_agent_purchase_date0000-00-00
  luxury_feed_agent_expiration_date0000-00-00
  digital_ad_summary_email_last_sent0000-00-00 00:00:00
  digital_ad_summary_price_changed(false)
  wsj_detail_url
  ft_detail_url
  nyt_detail_url
  juwai_detail_url
  pgl_detail_url
  mg_detail_url
  mg_c_detail_url
  mg_s_detail_url
  bp_detail_url
  mw_detail_url
  nikkei_detail_url
  wapo_detail_url
  robb_detail_url
  medium_featured(false)
  large_featured(true)
  detail_page(true)
  description<p>Built for textile baron Comer Covington in 1930, Hillbrook is considered one of renowned architect Luther Lashmit’s preeminent works. Lashmit, best-known for Graylyn Mansion, placed this Norman Tudor jewel on 5+ acres in the heart of Emerywood.</p> <p>Well cared for over the years, Hillbrook has just gone through an extensive renovation. Employing authentic, old-world techniques all 4 stories were restored to like-new. Modernizing the home while maintaining the charm, the mechanics of the home were replaced with up-to-date systems yet maintaining the grandeur of the original design. Hillbrook once again is the jewel of High Point with breathtaking landscaping as well.</p>
  address900 Rockford Rd
  address_2
  cityHigh Point
  stateNC
  postal_code27262
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price3750000
  price_20
  price_usd3750000
  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_feet9400
  square_meters
  acres5
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size5
  icon_1sq-ft
  icon_2acreage
  icon_3library
  icon_4
  icon_5
  icon_6
  websitehttp://www.trmrealestate.com/detail/900-rockford-high-point-nc-27262
  meta_title900 Rockford Road, High Point, N.C. | High Point Real Estate | Tyler Redhead & McAlister Real Estate
  meta_description900 Rockford Rd is a property offered for sale in High Point, NC, USA, presented by Tyler Redhead & McAlister Real Estate
  meta_keywords900 Rockford Rd, Hillbrook, Tyler Redhead & McAlister Real Estate, Greensboro Real Estate, Greensboro North Carolina Real Estate, Leverage Global Partners
  bathrooms_partial3
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built
  virtual_tour
  video_tour<table><tr><td><iframe width="560" height="315" src="http://www.tourfactory.com/yt1259883/ap_0" allowfullscreen="allowfullscreen"></iframe></td></tr><tr><td style="text-align: right;"><a href="http://www.tourfactory.com/1259883">View the Tour</a></td></tr
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_num
  wsj_property_type
  nyt_property_type
  nyt_popular_features
  propgolux_property_type
  juwai_property_type
  juwai_category
  propgolux_property_style
  wapo_property_type
  robb_property_type
  propgolux_location_id_override
  open_house_1_start0000-00-00 00:00:00
  open_house_1_end_time00:00:00
  latitude0.000000
  longitude0.000000
  invalid_required_fields
  invalid_optional_fieldssquare_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 11:17:47
  created2014-07-07 13:56:17
  uri/property-detail/863/900-rockford-rd-high-point-nc-27262-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/863/900-rockford-rd-high-point-nc-27262-usa
  address_concat900 Rockford Rd High Point NC 27262 USA
  google_maps_query_string900+Rockford+Rd++High+Point+NC+27262+USA
  luxury_ad_enrolled_prettyNO
  price_prettyUSD 3,750,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty6
  bathrooms_pretty7
  bathrooms_partial_pretty3
  bathrooms_3_4_pretty0
  feed_full_bathrooms7
  date_listed2014-07-07
  overridden_brokerage_nameTyler Redhead & McAlister Real Estate
  overridden_brokerage_logo_uri
  lux_ad_auto_enrolled(false)
  PrimaryPropertyCategory(array)
  id(null)
  name(null)
  created(null)
  modified(null)
  Brokerage(array)
  id122
  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_properties0
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id0
  WOEID2414469
  timezoneUS/Eastern
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameTyler Redhead & McAlister Real Estate
  broker_of_record_name
  short_nameTyler Redhead & McAlister Real Estate
  usernameTylerRedheadMcAlister
  passwordd9a1873a0974fea384d9263a2659236f46149e30
  password_reset_hash
  monthly_invoice_amount0.00
  monthly_invoice_start_date(null)
  monthly_invoice_end_date(null)
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Tyler Redhead & McAlister Real Estate is the exclusive representative for Leverage Global Partners in Greensboro, Winston Salem, High Point, Summerfield, Oak Ridge, Kernersville, and Jamestown, North Carolina, USA.</p> <p>More information coming soon!</p>
  communitiesGreensboro Winston Salem High Point Summerfield Oak Ridge Kernersville Jamestown
  websitehttp://www.trmrealestate.com/
  address1401 Sunset Drive, Suite 100
  address_2
  cityGreensboro
  stateNC
  full_stateNorth Carolina
  countryUSA
  marketGreensboro
  market_2
  postal_code27408
  phone(336) 274-1717
  phone_2
  phone_3
  wide_contact_image(false)
  contact_nameMarti Tyler, Alec McAlister & Katie Redhead
  contact_profile_link
  contact_big_profile_link
  contact_big_profile_link_text
  contact_titlePartners
  contact_dre_num
  contact_quoteWe invite you to contact us personally about Greensboro real estate.
  contact_email[email protected]
  contact_facebook
  contact_twitter
  contact_instagram
  contact_pinterest
  contact_linkedin
  contact_youtube
  contact_phone
  contact_email_2[email protected]
  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[email protected]
  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_filename122.jpg
  logo_filename122.jpg
  contact_image_filename122.jpg
  all_properties_link_image_filename122.jpg
  all_properties_linkhttp://www.trmrealestate.com/listings
  video_embed_code
  contact_video_embed_code
  meta_titleGreensboro Real Estate | Tyler Redhead & McAlister Real Estate | Leverage Global Partners
  meta_descriptionTyler Redhead & McAlister Real Estate is the exclusive representative for Leverage Global Partners in Greensboro, North Carolina, USA.
  meta_keywordsGreensboro Real Estate, Tyler Redhead & McAlister Real Estate, Leverage Global Partners, Alec McAlister
  login_message_counter3
  stats_module_1_type
  stats_module_1_value
  stats_module_2_type
  stats_module_2_value
  stats_module_3_type
  stats_module_3_value
  last_activity_email_sent0000-00-00 00:00:00
  converted(true)
  created2014-05-19 09:02:14
  modified2016-04-08 16:34:09
  dre_num012345
  uri/brokerage-detail/122/tyler-redhead-mcalister-real-estate
  website_shortwww.trmrealestate.com
  name_with_locationTyler Redhead & McAlister Real Estate
  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)
  id10094
  modelProperty
  model_id863
  tagImage
  name7212.jpg
  typeimage/jpg
  size579668
  uri/assets/10094.jpg
  order0
  created2016-04-07 16:19:07
  modified2016-04-07 16:19:07
  1(array)
  id10091
  modelProperty
  model_id863
  tagImage
  name7209.jpg
  typeimage/jpg
  size551640
  uri/assets/10091.jpg
  order1
  created2016-04-07 16:19:07
  modified2016-04-07 16:19:07
  2(array)
  id10092
  modelProperty
  model_id863
  tagImage
  name7210.jpg
  typeimage/jpg
  size505256
  uri/assets/10092.jpg
  order2
  created2016-04-07 16:19:07
  modified2016-04-07 16:19:07
  3(array)
  id10093
  modelProperty
  model_id863
  tagImage
  name7211.jpg
  typeimage/jpg
  size506825
  uri/assets/10093.jpg
  order3
  created2016-04-07 16:19:07
  modified2016-04-07 16:19:07
  4(array)
  id10095
  modelProperty
  model_id863
  tagImage
  name7213.jpg
  typeimage/jpg
  size472034
  uri/assets/10095.jpg
  order4
  created2016-04-07 16:19:07
  modified2016-04-07 16:19:07
  5(array)
  id10096
  modelProperty
  model_id863
  tagImage
  name7214.jpg
  typeimage/jpg
  size583278
  uri/assets/10096.jpg
  order5
  created2016-04-07 16:19:07
  modified2016-04-07 16:19:07
  User(empty)
  SecondaryPropertyCategory(empty)
  PropertyFeature(empty)
  Topic(array)
  0(array)
  id20
  nameUltra Lux
  created2016-02-25 11:25:00
  modified2016-02-25 11:35:37
  tile_nameUltra Lux
  PropertiesTopic(array)
  id48
  property_id863
  topic_id20
- custom_ga_event_properties(array)
  brokerageTyler Redhead & McAlister Real Estate, Greensboro
- property(array)
  Property(array)
  id3607
  brokerage_id122
  created_by_user_id0
  order0
  multi_unit(false)
  agent_1_id191
  agent_2_id0
  agent_3_id0
  name901 McDowell Drice
  incomplete(false)
  archived(false)
  last_archived0000-00-00 00:00:00
  auto_archived_from_mlsidx(false)
  paid_featured(false)
  featured(true)
  homepage_featured(false)
  brokerage_page_featured(true)
  requested_homepage_featured_by_member(false)
  homepage_featured_by_member(false)
  dot_luxury_featured(false)
  luxury_feed_featured(false)
  force_luxury_feed_featured(false)
  luxury_autofeed_imported(false)
  luxury_feed_last_added_time0000-00-00 00:00:00
  luxury_feed_agent_user_id0
  luxury_feed_locked_to_subscription_id0
  luxury_feed_agent_purchase_date0000-00-00
  luxury_feed_agent_expiration_date0000-00-00
  digital_ad_summary_email_last_sent0000-00-00 00:00:00
  digital_ad_summary_price_changed(false)
  wsj_detail_url
  ft_detail_url
  nyt_detail_url
  juwai_detail_url
  pgl_detail_url
  mg_detail_url
  mg_c_detail_url
  mg_s_detail_url
  bp_detail_url
  mw_detail_url
  nikkei_detail_url
  wapo_detail_url
  robb_detail_url
  medium_featured(false)
  large_featured(false)
  detail_page(true)
  description<p>What an exceptional home! Next to the entrance to the Bog Garden and walk to Friendly Center! Fine luxury living with every attention to detail. Immaculate like new condition in this "no shoe" house. Fabulous gourmet kitchen with keeping room. Master suite on main level feels like a retreat! English pub "man cave" in the basement...This is a WOW house</p>
  address901 McDowell Drive
  address_2
  cityGreensboro
  stateNC
  postal_code27408
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price798000
  price_20
  price_usd798000
  price_usd_20
  statusFor Sale
  status_last_changed0000-00-00 00:00:00
  status_last_changed_price_only0000-00-00 00:00:00
  lease_period
  price_upon_request(false)
  bedrooms4
  bedrooms_20
  bathrooms4
  bathrooms_20
  no_beds_baths(false)
  square_feet0
  square_meters
  acres0
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size0
  icon_1garage
  icon_2office
  icon_3
  icon_4
  icon_5
  icon_6
  websitehttp://www.trmrealestate.com/detail/901-mcdowell-drive-greensboro-nc-27408
  meta_title901 McDowell Drice | Greensboro Real Estate | Tyler Redhead & McAlister Real Estate
  meta_description901 McDowell Drive is a property offered for sale in Greensboro, NC, USA, presented by Tyler Redhead & McAlister Real Estate
  meta_keywords
  bathrooms_partial1
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built
  virtual_tour
  video_tour
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_num
  wsj_property_type
  nyt_property_type
  nyt_popular_features
  propgolux_property_type
  juwai_property_type
  juwai_category
  propgolux_property_style
  wapo_property_type
  robb_property_type
  propgolux_location_id_override
  open_house_1_start0000-00-00 00:00:00
  open_house_1_end_time00:00:00
  latitude0.000000
  longitude0.000000
  invalid_required_fields
  invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
  went_live_today(false)
  converted(true)
  invalid(false)
  mlsidx_full_address
  mlsidx_date_listed0000-00-00
  mls_market
  primary_property_category_id0
  realstaq_initial_image_sync(false)
  digital_ad_listing_urls_automated(null)
  modified2016-04-18 05:33:03
  created2016-03-17 10:10:18
  uri/property-detail/3607/901-mcdowell-drive-greensboro-nc-27408-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/3607/901-mcdowell-drive-greensboro-nc-27408-usa
  address_concat901 McDowell Drive Greensboro NC 27408 USA
  google_maps_query_string901+McDowell+Drive++Greensboro+NC+27408+USA
  luxury_ad_enrolled_prettyNO
  price_prettyUSD 798,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty4
  bathrooms_pretty4
  bathrooms_partial_pretty1
  bathrooms_3_4_pretty0
  feed_full_bathrooms4
  date_listed2016-03-17
  overridden_brokerage_nameTyler Redhead & McAlister Real Estate
  overridden_brokerage_logo_uri/assets/2605.jpg
  lux_ad_auto_enrolled(false)
  PrimaryPropertyCategory(array)
  id(null)
  name(null)
  created(null)
  modified(null)
  Brokerage(array)
  id122
  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_properties0
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id0
  WOEID2414469
  timezoneUS/Eastern
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameTyler Redhead & McAlister Real Estate
  broker_of_record_name
  short_nameTyler Redhead & McAlister Real Estate
  usernameTylerRedheadMcAlister
  passwordd9a1873a0974fea384d9263a2659236f46149e30
  password_reset_hash
  monthly_invoice_amount0.00
  monthly_invoice_start_date(null)
  monthly_invoice_end_date(null)
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Tyler Redhead & McAlister Real Estate is the exclusive representative for Leverage Global Partners in Greensboro, Winston Salem, High Point, Summerfield, Oak Ridge, Kernersville, and Jamestown, North Carolina, USA.</p> <p>More information coming soon!</p>
  communitiesGreensboro Winston Salem High Point Summerfield Oak Ridge Kernersville Jamestown
  websitehttp://www.trmrealestate.com/
  address1401 Sunset Drive, Suite 100
  address_2
  cityGreensboro
  stateNC
  full_stateNorth Carolina
  countryUSA
  marketGreensboro
  market_2
  postal_code27408
  phone(336) 274-1717
  phone_2
  phone_3
  wide_contact_image(false)
  contact_nameMarti Tyler, Alec McAlister & Katie Redhead
  contact_profile_link
  contact_big_profile_link
  contact_big_profile_link_text
  contact_titlePartners
  contact_dre_num
  contact_quoteWe invite you to contact us personally about Greensboro real estate.
  contact_email[email protected]
  contact_facebook
  contact_twitter
  contact_instagram
  contact_pinterest
  contact_linkedin
  contact_youtube
  contact_phone
  contact_email_2[email protected]
  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[email protected]
  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_filename122.jpg
  logo_filename122.jpg
  contact_image_filename122.jpg
  all_properties_link_image_filename122.jpg
  all_properties_linkhttp://www.trmrealestate.com/listings
  video_embed_code
  contact_video_embed_code
  meta_titleGreensboro Real Estate | Tyler Redhead & McAlister Real Estate | Leverage Global Partners
  meta_descriptionTyler Redhead & McAlister Real Estate is the exclusive representative for Leverage Global Partners in Greensboro, North Carolina, USA.
  meta_keywordsGreensboro Real Estate, Tyler Redhead & McAlister Real Estate, Leverage Global Partners, Alec McAlister
  login_message_counter3
  stats_module_1_type
  stats_module_1_value
  stats_module_2_type
  stats_module_2_value
  stats_module_3_type
  stats_module_3_value
  last_activity_email_sent0000-00-00 00:00:00
  converted(true)
  created2014-05-19 09:02:14
  modified2016-04-08 16:34:09
  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)
  id2605
  modelBrokerage
  model_id122
  tagLogo
  name122.jpg
  typeimage/jpg
  size199589
  uri/assets/2605.jpg
  order0
  created2016-03-30 11:41:38
  modified2016-03-30 11:41:38
  MainImage(array)
  id2604
  modelBrokerage
  model_id122
  tagMainImage
  name122.jpg
  typeimage/jpg
  size692785
  uri/assets/2604.jpg
  order0
  created2016-03-30 11:41:38
  modified2016-03-30 11:41:38
  ContactImage(array)
  id2606
  modelBrokerage
  model_id122
  tagContactImage
  name122.jpg
  typeimage/jpg
  size383563
  uri/assets/2606.jpg
  order0
  created2016-03-30 11:41:38
  modified2016-03-30 11:41:38
  ContactImage2(empty)
  ContactImage3(empty)
  BrokerOfRecordLogo(empty)
  MainArticle(empty)
  FeaturedImage(empty)
  Location(array)
  0(array)
  id93
  parent_id8
  brokerage_id122
  typeExclusive
  archived(false)
  use_as_topic(false)
  nameGreensboro, NC, USA
  short_nameGreensboro, NC, USA
  group_index
  latitude36.072636
  longitude-79.791977
  country_code
  north53.700001
  south19.700001
  east-52.599998
  west-146.600006
  zoom0
  short_description
  long_descriptionMore information coming soon!
  created2016-04-05 11:25:13
  modified2016-04-05 11:25:13
  timezoneAmerica/New_York
  population280000
  uri/locations/view/93/greensboro-nc-usa
  tile_nameGreensboro, NC, USA
  User(array)
  0(array)
  id136
  typeBrokerageAdmin
  brokerage_id122
  email[email protected]
  passwordd9a1873a0974fea384d9263a2659236f46149e30
  recover_hash
  first_name
  last_name
  title
  dre_num
  phone
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2016-04-12 08:28:19
  created2016-04-08 16:34:09
  notified(true)
  full_name
  uri/agent-detail/136/
  profile_complete(false)
  1(array)
  id410
  typeAgent
  brokerage_id122
  email[email protected]
  password35fc324eef3a64a1b8fff1b76b451e5c2b591781
  recover_hash
  first_nameKaren
  last_nameJobe
  title
  dre_num
  phone336-430-6552
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:55
  created2017-08-07 15:22:55
  notified(false)
  full_nameKaren Jobe
  uri/agent-detail/410/karen-jobe
  profile_complete(true)
  2(array)
  id411
  typeAgent
  brokerage_id122
  email[email protected]
  passworda1f3eaed5d1ff9f702b93004a32b28b1d36aa649
  recover_hash
  first_nameJill
  last_nameOakley
  title
  dre_num
  phone336-456-6077
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:55
  created2017-08-07 15:22:55
  notified(false)
  full_nameJill Oakley
  uri/agent-detail/411/jill-oakley
  profile_complete(true)
  3(array)
  id412
  typeAgent
  brokerage_id122
  email[email protected]
  password5ac98875c9bae5809f67faaf0851243fbbac74b8
  recover_hash
  first_nameAlec
  last_nameMcAlister
  title
  dre_num
  phone336-707-0463
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:55
  created2017-08-07 15:22:55
  notified(false)
  full_nameAlec McAlister
  uri/agent-detail/412/alec-mcalister
  profile_complete(true)
  4(array)
  id414
  typeAgent
  brokerage_id122
  email[email protected]
  passwordf44a9a1fa8dcbf19fefc3080e8b83c8e98a7dd5d
  recover_hash
  first_nameWendi
  last_nameHuffman
  title
  dre_num
  phone336254-4122
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:55
  created2017-08-07 15:22:55
  notified(false)
  full_nameWendi Huffman
  uri/agent-detail/414/wendi-huffman
  profile_complete(true)
  5(array)
  id415
  typeAgent
  brokerage_id122
  email[email protected]
  passwordbe9961a3078a6b1681ec1ff2dc8ae64750494f28
  recover_hash
  first_nameCharlotte
  last_nameDavidson
  title
  dre_num
  phone336-314-4105
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:55
  created2017-08-07 15:22:55
  notified(false)
  full_nameCharlotte Davidson
  uri/agent-detail/415/charlotte-davidson
  profile_complete(true)
  6(array)
  id702
  typeAgent
  brokerage_id122
  email[email protected]
  passwordc9d4a524b6e4b6802c5b581053e179a581ee7266
  recover_hash
  first_nameStacey
  last_nameOfsanko
  title
  dre_num
  phone336-404-6342
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:23:16
  created2017-08-07 15:23:16
  notified(false)
  full_nameStacey Ofsanko
  uri/agent-detail/702/stacey-ofsanko
  profile_complete(true)
  uri/brokerage-detail/122/tyler-redhead-mcalister-real-estate
  website_shortwww.trmrealestate.com
  name_with_locationTyler Redhead & McAlister Real Estate - Greensboro, NC, 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)
  id20050
  modelProperty
  model_id3607
  tagImage
  name35058.jpg
  typeimage/jpg
  size759651
  uri/assets/20050.jpg
  order0
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  1(array)
  id20052
  modelProperty
  model_id3607
  tagImage
  name35060.jpg
  typeimage/jpg
  size515653
  uri/assets/20052.jpg
  order1
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  2(array)
  id20053
  modelProperty
  model_id3607
  tagImage
  name35061.jpg
  typeimage/jpg
  size455030
  uri/assets/20053.jpg
  order2
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  3(array)
  id20054
  modelProperty
  model_id3607
  tagImage
  name35062.jpg
  typeimage/jpg
  size463442
  uri/assets/20054.jpg
  order3
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  4(array)
  id20055
  modelProperty
  model_id3607
  tagImage
  name35063.jpg
  typeimage/jpg
  size458491
  uri/assets/20055.jpg
  order4
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  5(array)
  id20056
  modelProperty
  model_id3607
  tagImage
  name35064.jpg
  typeimage/jpg
  size486605
  uri/assets/20056.jpg
  order5
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  6(array)
  id20057
  modelProperty
  model_id3607
  tagImage
  name35065.jpg
  typeimage/jpg
  size564254
  uri/assets/20057.jpg
  order6
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  7(array)
  id20059
  modelProperty
  model_id3607
  tagImage
  name35067.jpg
  typeimage/jpg
  size573758
  uri/assets/20059.jpg
  order7
  created2016-04-07 17:25:38
  modified2016-04-07 17:25:38
  8(array)
  id20058
  modelProperty
  model_id3607
  tagImage
  name35066.jpg
  typeimage/jpg
  size697526
  uri/assets/20058.jpg
  order8
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:38
  9(array)
  id20051
  modelProperty
  model_id3607
  tagImage
  name35059.jpg
  typeimage/jpg
  size1084914
  uri/assets/20051.jpg
  order9
  created2016-04-07 17:25:37
  modified2016-04-07 17:25:37
  User(array)
  0(array)
  id410
  typeAgent
  brokerage_id122
  email[email protected]
  password35fc324eef3a64a1b8fff1b76b451e5c2b591781
  recover_hash
  first_nameKaren
  last_nameJobe
  title
  dre_num
  phone336-430-6552
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2017-08-07 15:22:55
  created2017-08-07 15:22:55
  notified(false)
  full_nameKaren Jobe
  uri/agent-detail/410/karen-jobe
  profile_complete(true)
  UsersProperty(array)
  id244
  user_id410
  property_id3607
  sort_order0
  Brokerage(array)
  id122
  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_properties0
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id0
  WOEID2414469
  timezoneUS/Eastern
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameTyler Redhead & McAlister Real Estate
  broker_of_record_name
  short_nameTyler Redhead & McAlister Real Estate
  usernameTylerRedheadMcAlister
  passwordd9a1873a0974fea384d9263a2659236f46149e30
  password_reset_hash
  monthly_invoice_amount0.00
  monthly_invoice_start_date(null)
  monthly_invoice_end_date(null)
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Tyler Redhead & McAlister Real Estate is the exclusive representative for Leverage Global Partners in Greensboro, Winston Salem, High Point, Summerfield, Oak Ridge, Kernersville, and Jamestown, North Carolina, USA.</p> <p>More information coming soon!</p>
  communitiesGreensboro Winston Salem High Point Summerfield Oak Ridge Kernersville Jamestown
  websitehttp://www.trmrealestate.com/
  address1401 Sunset Drive, Suite 100
  address_2
  cityGreensboro
  stateNC
  full_stateNorth Carolina
  countryUSA
  marketGreensboro
  market_2
  postal_code27408
  phone(336) 274-1717
  phone_2
  phone_3
  wide_contact_image(false)
  contact_nameMarti Tyler, Alec McAlister & Katie Redhead
  contact_profile_link
  contact_big_profile_link
  contact_big_profile_link_text
  contact_titlePartners
  contact_dre_num
  contact_quoteWe invite you to contact us personally about Greensboro real estate.
  contact_email[email protected]
  contact_facebook
  contact_twitter
  contact_instagram
  contact_pinterest
  contact_linkedin
  contact_youtube
  contact_phone
  contact_email_2[email protected]
  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[email protected]
  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_filename122.jpg
  logo_filename122.jpg
  contact_image_filename122.jpg
  all_properties_link_image_filename122.jpg
  all_properties_linkhttp://www.trmrealestate.com/listings
  video_embed_code
  contact_video_embed_code
  meta_titleGreensboro Real Estate | Tyler Redhead & McAlister Real Estate | Leverage Global Partners
  meta_descriptionTyler Redhead & McAlister Real Estate is the exclusive representative for Leverage Global Partners in Greensboro, North Carolina, USA.
  meta_keywordsGreensboro Real Estate, Tyler Redhead & McAlister Real Estate, Leverage Global Partners, Alec McAlister
  login_message_counter3
  stats_module_1_type
  stats_module_1_value
  stats_module_2_type
  stats_module_2_value
  stats_module_3_type
  stats_module_3_value
  last_activity_email_sent0000-00-00 00:00:00
  converted(true)
  created2014-05-19 09:02:14
  modified2016-04-08 16:34:09
  dre_num012345
  uri/brokerage-detail/122/tyler-redhead-mcalister-real-estate
  website_shortwww.trmrealestate.com
  name_with_locationTyler Redhead & McAlister Real Estate
  Image(empty)
  BrokerageLogoOverride(empty)
  SecondaryPropertyCategory(empty)
  PropertyFeature(array)
  0(array)
  id4
  nameGarage
  additional(false)
  created2016-04-07 14:01:52
  modified2016-04-07 14:01:52
  PropertiesPropertyFeature(array)
  id4246
  property_id3607
  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
  1(array)
  id9
  nameOffice
  additional(false)
  created2016-04-07 14:03:21
  modified2016-04-07 14:03:21
  PropertiesPropertyFeature(array)
  id4247
  property_id3607
  property_feature_id9
  Icon(array)
  id3558
  modelPropertyFeature
  model_id9
  tagIcon
  name137.png
  typeimage/png
  size2009
  uri/assets/3558.png
  order0
  created2016-04-07 14:03:19
  modified2016-04-07 14:03:21
  Topic(empty)
- membership_subscription_temp_allowed_login(null)
- newsletter_member_types(array)
  Leverage Member: AgentLeverage Member: Agent
  Leverage Member: Broker or ManagementLeverage Member: Broker or Management
  Non-MemberNon-Member
- $request->data(empty)
- $this->validationErrors(array)
  Subscription(empty)
  Property(empty)
  User(empty)
  PropertyFeature(empty)
  SecondaryPropertyCategory(empty)
  Topic(empty)
  PrimaryPropertyCategory(empty)
  Brokerage(empty)
  StripeSubscription(empty)
  GlobalReachReport(empty)
  AccountExecutive(empty)
  Logo(empty)
  MainImage(empty)
  ContactImage(empty)
  ContactImage2(empty)
  ContactImage3(empty)
  BrokerOfRecordLogo(empty)
  MainArticle(empty)
  Location(empty)
  FeaturedImage(empty)
  Image(empty)
  UsersProperty(empty)
  BrokerageLogoOverride(empty)
  PropertiesSecondaryPropertyCategory(empty)
  PropertiesPropertyFeature(empty)
  Icon(empty)
  PropertiesTopic(empty)
- Loaded Helpers(array)
  0Permission
  1Number
  2SimpleGraph
  3DebugTimer
  4Toolbar
  5Session
  6Text
  7Flash
  8HtmlToolbar
  9Html
  10Form
====

+

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/3607/901-mcdowell-drive-greensboro-nc-27408-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/property-detail/3607/901-mcdowell-drive-greensboro-nc-27408-usa
Remote Port	14541
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	a09d3582995b5a3a-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	aioeYXqyy0zNfauLVoLDrQAAAQs
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	aioeYXqyy0zNfauLVoLDrQAAAQs
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781145185.7935
Request Time	1781145185

====

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