Location: Charleston

LeverageRE

Home of Leverage Partner dunes properties, Charleston is renowned for its Southern hospitality and historic charm. Walk along cobblestone streets lined with Spanish moss-draped trees, embrace the beautiful, centuries-old mansions and majestically preserved plantations and churches.

No matter where you turn, Charleston emanates a true historic feel, yet boasts a sense of modernism with its restaurants, shops and art galleries.

INDULGE. The Peninsula Grill inside the historic Planters Inn is home to the decadent Ultimate Coconut Cake. The 12-layer, cream-fi dessert is sold by the slice for diners or shipped whole across the country.

FIND. Since 1922, George C. Birlant & Co. has been offering period furniture, silver, and accessories, as well as handcrafted reproductions of the famous Charleston Battery Bench that dots the city's sidewalks and parks

ADORN. Croghan's Jewel Box has enchanted generations of Charlestonians with a brilliant selection of jew- els and gifts. The family-run business has occupied the same 18th-century Charleston Single House on King Street since William Joseph Croghan opened shop over 100 years ago.

SCREAM. Bulldog walking tours offer a glimpse at the haunted sites through- out town, but for a real fright, explore pre–Revolutionary War prisons during the dark of night.

Share

• Topics:
• Voice from the Street

• Location:
• Charleston, SC, USA

Recent Articles

Home Improvement: Take It Outside

French for "under my tree," Sous Mon Arbre is an indoor/outdoor garden lamp ($665) equipped with...

The Smith & Berg Story

Lorem ipsum

Property Search

Bedrooms Any 1+ 2+ 3+ 4+ 5+ 6+ 7+ 8+ 9+ 10+

Baths Any 1+ 2+ 3+ 4+ 5+ 6+ 7+ 8+ 9+ 10+

Minimum Price Any $250,000 $500,000 $750,000 $1,000,000 $1,250,000 $1,500,000 $1,750,000 $2,000,000 $2,250,000 $2,500,000 $2,750,000 $3,000,000 $3,250,000 $3,500,000 $3,750,000 $4,000,000 $4,250,000 $4,500,000 $4,750,000 $5,000,000

Maximum Price Any $250,000 $500,000 $750,000 $1,000,000 $1,250,000 $1,500,000 $1,750,000 $2,000,000 $2,250,000 $2,500,000 $2,750,000 $3,000,000 $3,250,000 $3,500,000 $3,750,000 $4,000,000 $4,250,000 $4,500,000 $4,750,000 $5,000,000

Search

Array
(
    [Article] => Array
        (
            [id] => 441
            [model] => Location
            [model_id] => 15
            [archived] => 
            [medium_featured] => 1
            [large_featured] => 
            [title] => Location: Charleston
            [author] => LeverageRE
            [date] => 2016-03-28
            [lead_in] => Home of Leverage Partner dunes properties, Charleston is renowned for its Southern hospitality and historic charm. Walk along cobblestone streets lined with Spanish moss-draped trees, embrace the beautiful, centuries-old mansions and majestically preserved plantations and churches.
            [body] => 
No matter where you turn, Charleston emanates a true historic feel, yet boasts a sense of modernism with its restaurants, shops and art galleries.



INDULGE. The Peninsula Grill inside the historic Planters Inn is home to the decadent Ultimate Coconut Cake. The 12-layer, cream-fi dessert is sold by the slice for diners or shipped whole across the country.



FIND. Since 1922, George C. Birlant & Co. has been offering period furniture, silver, and accessories, as well as handcrafted reproductions of the famous Charleston Battery Bench that dots the city's sidewalks and parks

ADORN. Croghan's Jewel Box has enchanted generations of Charlestonians with a brilliant selection of jew- els and gifts. The family-run business has occupied the same 18th-century Charleston Single House on King Street since William Joseph Croghan opened shop over 100 years ago.



SCREAM. Bulldog walking tours offer a glimpse at the haunted sites through- out town, but for a real fright, explore pre–Revolutionary War prisons during the dark of night.



            [vimeo_id] => 
            [created] => 2016-04-05 14:30:24
            [modified] => 2016-04-11 17:04:52
            [uri] => /articles/view/441/location-charleston
            [flattened_topics] => Array
                (
                    [0] => Voice from the Street
                )

        )

    [ParentBrokerage] => Array
        (
            [id] => 
            [account_executive_id] => 
            [archived] => 
            [type] => 
            [hide_from_frontend] => 
            [agent_brokerage_data_override] => 
            [featured_development] => 
            [membership_type] => 
            [max_properties] => 
            [max_homepage_featured_by_member_properties] => 
            [featured_properties_sort_method] => 
            [lux_feed_mode] => 
            [max_luxury_feed_properties] => 
            [membership_luxury_feed_properties] => 
            [can_participate_in_lux_feed_while_archived] => 
            [full_training_video_access] => 
            [country_id] => 
            [WOEID] => 
            [timezone] => 
            [luxury_feed_enrollment_mode] => 
            [luxury_feed_include_mlsidx_minimum_price] => 
            [luxury_feed_include_leverage_minimum_price] => 
            [digital_ad_contacts] => 
            [add_agents_to_grr_auto_recipients] => 
            [mlsidx_id] => 
            [mlsidx_lux_autofeed] => 
            [mlsidx_lux_autofeed_minimum_price] => 
            [mlsidx_logo_url] => 
            [mlsidx_disclaimer] => 
            [name] => 
            [broker_of_record_name] => 
            [short_name] => 
            [username] => 
            [password] => 
            [password_reset_hash] => 
            [monthly_invoice_amount] => 
            [monthly_invoice_start_date] => 
            [monthly_invoice_end_date] => 
            [contract_filename] => 
            [active] => 
            [lead_in] => 
            [short_description] => 
            [description] => 
            [communities] => 
            [website] => 
            [address] => 
            [address_2] => 
            [city] => 
            [state] => 
            [full_state] => 
            [country] => 
            [market] => 
            [market_2] => 
            [postal_code] => 
            [phone] => 
            [phone_2] => 
            [phone_3] => 
            [wide_contact_image] => 
            [contact_name] => 
            [contact_profile_link] => 
            [contact_big_profile_link] => 
            [contact_big_profile_link_text] => 
            [contact_title] => 
            [contact_dre_num] => 
            [contact_quote] => 
            [contact_email] => 
            [contact_facebook] => 
            [contact_twitter] => 
            [contact_instagram] => 
            [contact_pinterest] => 
            [contact_linkedin] => 
            [contact_youtube] => 
            [contact_phone] => 
            [contact_email_2] => 
            [contact_2_facebook] => 
            [contact_2_twitter] => 
            [contact_2_instagram] => 
            [contact_2_pinterest] => 
            [contact_2_linkedin] => 
            [contact_2_youtube] => 
            [contact_phone_2] => 
            [contact_website] => 
            [contact_name_2] => 
            [contact_profile_link_2] => 
            [contact_big_profile_link_2] => 
            [contact_big_profile_link_text_2] => 
            [contact_title_2] => 
            [contact_dre_num_2] => 
            [contact_email_3] => 
            [contact_name_3] => 
            [contact_title_3] => 
            [contact_dre_num_3] => 
            [contact_phone_3] => 
            [contact_3_facebook] => 
            [contact_3_twitter] => 
            [contact_3_instagram] => 
            [contact_3_pinterest] => 
            [contact_3_linkedin] => 
            [contact_3_youtube] => 
            [image_filename] => 
            [logo_filename] => 
            [contact_image_filename] => 
            [all_properties_link_image_filename] => 
            [all_properties_link] => 
            [video_embed_code] => 
            [contact_video_embed_code] => 
            [meta_title] => 
            [meta_description] => 
            [meta_keywords] => 
            [login_message_counter] => 
            [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_sent] => 
            [converted] => 
            [created] => 
            [modified] => 
            [dre_num] => 
            [name_with_location] => 
        )

    [ParentLocation] => Array
        (
            [id] => 15
            [parent_id] => 8
            [brokerage_id] => 219
            [type] => Exclusive
            [archived] => 
            [use_as_topic] => 
            [name] => Charleston, SC, USA
            [short_name] => Charleston, SC, USA
            [group_index] => 
            [latitude] => 32.779144
            [longitude] => -79.924866
            [country_code] => 
            [north] => 53.700001
            [south] => 19.700001
            [east] => -52.599998
            [west] => -146.600006
            [zoom] => 0
            [short_description] => Charleston thrives with a perfect blend of modern commerce and historical significance.  
            [long_description] => Whether you dream of historic charm, oceanfront majesty, secluded islands, an urban oasis, friendly suburbia, or a quiet rural getaway- Charleston and its coastal communities have a place for you. Golf, summer's Spoleto Festival which brings a world of entertainment to the city, fishing, water sports, plantation gardens, hiking trails, museums, there is truly something for everyone. Charleston is thriving with the perfect blend of modern day commerce and historical significance. Charleston is — well, Charleston. One of the world’s great cities, she preserves the best of the old and seems to constantly remake herself. Always relevant, yet obliging, we think she’s is grander than ever. Charleston has received many accolades over the year- friendliest city, best city in the world, best city in the US, best destination from Condé Nast readers. And with companies like Volvo and Boeing bringing even more opportunities to the Charleston area, we are looking forward to a prosperous future.  
            [created] => 2016-04-04 10:21:12
            [modified] => 2016-04-04 10:46:05
            [timezone] => America/New_York
            [population] => 372000
            [uri] => /locations/view/15/charleston-sc-usa
            [tile_name] => Charleston, SC, USA
        )

    [Image] => Array
        (
            [0] => Array
                (
                    [id] => 3077
                    [model] => Article
                    [model_id] => 441
                    [tag] => Image
                    [name] => Charleston.jpg
                    [type] => image/jpg
                    [size] => 697645
                    [uri] => /assets/3077.jpg
                    [order] => 0
                    [created] => 2016-04-05 14:30:25
                    [modified] => 2016-04-11 17:04:52
                )

        )

    [Brokerage] => Array
        (
            [0] => Array
                (
                    [id] => 219
                    [account_executive_id] => 236
                    [archived] => 
                    [type] => brokerage
                    [hide_from_frontend] => 
                    [agent_brokerage_data_override] => 
                    [featured_development] => 
                    [membership_type] => Basic
                    [max_properties] => 8
                    [max_homepage_featured_by_member_properties] => 0
                    [featured_properties_sort_method] => manual
                    [lux_feed_mode] => StripeSubscription
                    [max_luxury_feed_properties] => 0
                    [membership_luxury_feed_properties] => 0
                    [can_participate_in_lux_feed_while_archived] => 
                    [full_training_video_access] => 
                    [country_id] => 0
                    [WOEID] => 2378319
                    [timezone] => US/Eastern
                    [luxury_feed_enrollment_mode] => manual
                    [luxury_feed_include_mlsidx_minimum_price] => 0
                    [luxury_feed_include_leverage_minimum_price] => 0
                    [digital_ad_contacts] => 
                    [add_agents_to_grr_auto_recipients] => 1
                    [mlsidx_id] => 
                    [mlsidx_lux_autofeed] => 
                    [mlsidx_lux_autofeed_minimum_price] => 0
                    [mlsidx_logo_url] => 
                    [mlsidx_disclaimer] => 
                    [name] => dunes properties
                    [broker_of_record_name] => 
                    [short_name] => dunes properties
                    [username] => dunesproperties
                    [password] => b76f3dcf9a00c689036232225e96f54a1b389b83
                    [password_reset_hash] => 
                    [monthly_invoice_amount] => 
                    [monthly_invoice_start_date] => 
                    [monthly_invoice_end_date] => 
                    [contract_filename] => 
                    [active] => 1
                    [lead_in] => 
                    [short_description] => 
                    [description] => 
dunes properties is the exclusive representative for Leverage Global Partners in Charleston, Mount Pleasant, Isle of Palms, West Ashley, James Island, Folly Beach, Sullivan's Island, Dewee's Island, SC, USA.
dunes properties is a boutique real estate, vacation rental, and property management company serving the Charleston area. We began with a single office and three employees in 1989. Today, we represent the Lowcountry with over 50 professional, experienced real estate agents in four full-service offices.
Nobody knows the Charleston Coast better®
                    [communities] => Charleston
Mount Pleasant
Isle of Palms
West Ashley
James Island
Folly Beach
Sullivan's Island
Dewee's Island 
                    [website] => http://dunesproperties.com/
                    [address] => 214 King Street
                    [address_2] => 
                    [city] => Charleston
                    [state] => SC
                    [full_state] => South Carolina
                    [country] => USA
                    [market] => Charleston
                    [market_2] => 
                    [postal_code] => 29401
                    [phone] => Cell: (843) 270-1698
                    [phone_2] => Office: (843) 886-5600
                    [phone_3] => 
                    [wide_contact_image] => 
                    [contact_name] => Randy Walker
                    [contact_profile_link] => 
                    [contact_big_profile_link] => 
                    [contact_big_profile_link_text] => 
                    [contact_title] => Broker/Owner
                    [contact_dre_num] => 
                    [contact_quote] => 
                    [contact_email] => [email protected]
                    [contact_facebook] => 
                    [contact_twitter] => 
                    [contact_instagram] => 
                    [contact_pinterest] => 
                    [contact_linkedin] => 
                    [contact_youtube] => 
                    [contact_phone] => 
                    [contact_email_2] => 
                    [contact_2_facebook] => 
                    [contact_2_twitter] => 
                    [contact_2_instagram] => 
                    [contact_2_pinterest] => 
                    [contact_2_linkedin] => 
                    [contact_2_youtube] => 
                    [contact_phone_2] => 
                    [contact_website] => 
                    [contact_name_2] => 
                    [contact_profile_link_2] => 
                    [contact_big_profile_link_2] => 
                    [contact_big_profile_link_text_2] => 
                    [contact_title_2] => 
                    [contact_dre_num_2] => 
                    [contact_email_3] => 
                    [contact_name_3] => 
                    [contact_title_3] => 
                    [contact_dre_num_3] => 
                    [contact_phone_3] => 
                    [contact_3_facebook] => 
                    [contact_3_twitter] => 
                    [contact_3_instagram] => 
                    [contact_3_pinterest] => 
                    [contact_3_linkedin] => 
                    [contact_3_youtube] => 
                    [image_filename] => 219.png
                    [logo_filename] => 219.jpg
                    [contact_image_filename] => 219.png
                    [all_properties_link_image_filename] => 219.png
                    [all_properties_link] => http://idx.diversesolutions.com/link/220431
                    [video_embed_code] => 
                    [contact_video_embed_code] => 
                    [meta_title] => Charleston Real Estate | Dune Properties | Leverage Global Partners
                    [meta_description] => dunes properties is the exclusive representative for Leverage Global Partners in Charleston, Mount Pleasant, Isle of Palms, West Ashley, James Island, Folly Beach, Sullivan's Island, Dewee's Island, SC, USA. 
                    [meta_keywords] => Dunes Properties, Randy Walker, Charleston Real Estate, Mount Pleasant Real Estate, Isle of Palms Real Estate, West Ashley Real Estate, James Island Real Estate, Folly Beach Real Estate, Sullivan's Island Real Estate, Dewee's Island Real Estate, South Carolina Real Estate
                    [login_message_counter] => 3
                    [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_sent] => 0000-00-00 00:00:00
                    [converted] => 1
                    [created] => 2015-08-24 13:29:47
                    [modified] => 2016-04-08 16:34:26
                    [dre_num] => 012345
                    [uri] => /brokerage-detail/219/dunes-properties
                    [website_short] => dunesproperties.com
                    [name_with_location] => dunes properties
                    [ArticlesBrokerage] => Array
                        (
                            [id] => 56
                            [article_id] => 441
                            [brokerage_id] => 219
                        )

                )

        )

    [Location] => Array
        (
            [0] => Array
                (
                    [id] => 15
                    [parent_id] => 8
                    [brokerage_id] => 219
                    [type] => Exclusive
                    [archived] => 
                    [use_as_topic] => 
                    [name] => Charleston, SC, USA
                    [short_name] => Charleston, SC, USA
                    [group_index] => 
                    [latitude] => 32.779144
                    [longitude] => -79.924866
                    [country_code] => 
                    [north] => 53.700001
                    [south] => 19.700001
                    [east] => -52.599998
                    [west] => -146.600006
                    [zoom] => 0
                    [short_description] => Charleston thrives with a perfect blend of modern commerce and historical significance.  
                    [long_description] => Whether you dream of historic charm, oceanfront majesty, secluded islands, an urban oasis, friendly suburbia, or a quiet rural getaway- Charleston and its coastal communities have a place for you. Golf, summer's Spoleto Festival which brings a world of entertainment to the city, fishing, water sports, plantation gardens, hiking trails, museums, there is truly something for everyone. Charleston is thriving with the perfect blend of modern day commerce and historical significance. Charleston is — well, Charleston. One of the world’s great cities, she preserves the best of the old and seems to constantly remake herself. Always relevant, yet obliging, we think she’s is grander than ever. Charleston has received many accolades over the year- friendliest city, best city in the world, best city in the US, best destination from Condé Nast readers. And with companies like Volvo and Boeing bringing even more opportunities to the Charleston area, we are looking forward to a prosperous future.  
                    [created] => 2016-04-04 10:21:12
                    [modified] => 2016-04-04 10:46:05
                    [timezone] => America/New_York
                    [population] => 372000
                    [uri] => /locations/view/15/charleston-sc-usa
                    [tile_name] => Charleston, SC, USA
                    [ArticlesLocation] => Array
                        (
                            [id] => 38
                            [article_id] => 441
                            [location_id] => 15
                        )

                )

        )

    [Property] => Array
        (
        )

    [Topic] => Array
        (
            [0] => Array
                (
                    [id] => 24
                    [name] => Voice from the Street
                    [created] => 2016-02-25 11:38:06
                    [modified] => 2016-02-25 11:38:06
                    [tile_name] => Voice from the Street
                    [ArticlesTopic] => Array
                        (
                            [id] => 351
                            [article_id] => 441
                            [topic_id] => 24
                        )

                )

        )

)

• 
• History
  +

  Request History

  4 previous requests available

  • Restore to current request
  • agent-detail/290/ryan-klusmeyer
  • agent-detail/822/pat-lore
  • brokerage-detail/248/jloop
  • articles/view/445/location-dallas

  ====
• Session
  +

  Session

  • Config(array)
    • userAgentcc2d3fd23c5dd98eb73e42c141648c0a
    • time1781167227
    • countdown10
  • Explore(array)
    • rejected_tiles(array)
      • rejected_topics(empty)
      • rejected_locations(empty)

  ====
• Request
  +

  Request

  Cake Params

  • plugin(null)
  • controllerarticles
  • actionview
  • named(empty)
  • pass(array)
    • 0441
    • 1location-charleston
  • isAjax(false)

  Post data

  No post data.

  Query string

  No querystring data.

  Cookie

  • 0(empty)

  Current Route

  • keys(array)
    • 0controller
    • 1action
  • options(array)
    • defaultRoute(true)
  • defaults(array)
    • plugin(null)
  • template/:controller/:action/*

  ====
• Sql Log
  +

  Sql Logs

  default

  Total Time: 43 ms
  Total Queries: 31 queries

  Query	Affected	Num. rows	Took (ms)	Actions
  SELECT `Article`.`id`, `Article`.`model`, `Article`.`model_id`, `Article`.`archived`, `Article`.`medium_featured`, `Article`.`large_featured`, `Article`.`title`, `Article`.`author`, `Article`.`date`, `Article`.`lead_in`, `Article`.`body`, `Article`.`vimeo_id`, `Article`.`created`, `Article`.`modified`, `ParentBrokerage`.`id`, `ParentBrokerage`.`account_executive_id`, `ParentBrokerage`.`archived`, `ParentBrokerage`.`type`, `ParentBrokerage`.`hide_from_frontend`, `ParentBrokerage`.`agent_brokerage_data_override`, `ParentBrokerage`.`featured_development`, `ParentBrokerage`.`membership_type`, `ParentBrokerage`.`max_properties`, `ParentBrokerage`.`max_homepage_featured_by_member_properties`, `ParentBrokerage`.`featured_properties_sort_method`, `ParentBrokerage`.`lux_feed_mode`, `ParentBrokerage`.`max_luxury_feed_properties`, `ParentBrokerage`.`membership_luxury_feed_properties`, `ParentBrokerage`.`can_participate_in_lux_feed_while_archived`, `ParentBrokerage`.`full_training_video_access`, `ParentBrokerage`.`country_id`, `ParentBrokerage`.`WOEID`, `ParentBrokerage`.`timezone`, `ParentBrokerage`.`luxury_feed_enrollment_mode`, `ParentBrokerage`.`luxury_feed_include_mlsidx_minimum_price`, `ParentBrokerage`.`luxury_feed_include_leverage_minimum_price`, `ParentBrokerage`.`digital_ad_contacts`, `ParentBrokerage`.`add_agents_to_grr_auto_recipients`, `ParentBrokerage`.`mlsidx_id`, `ParentBrokerage`.`mlsidx_lux_autofeed`, `ParentBrokerage`.`mlsidx_lux_autofeed_minimum_price`, `ParentBrokerage`.`mlsidx_logo_url`, `ParentBrokerage`.`mlsidx_disclaimer`, `ParentBrokerage`.`name`, `ParentBrokerage`.`broker_of_record_name`, `ParentBrokerage`.`short_name`, `ParentBrokerage`.`username`, `ParentBrokerage`.`password`, `ParentBrokerage`.`password_reset_hash`, `ParentBrokerage`.`monthly_invoice_amount`, `ParentBrokerage`.`monthly_invoice_start_date`, `ParentBrokerage`.`monthly_invoice_end_date`, `ParentBrokerage`.`contract_filename`, `ParentBrokerage`.`active`, `ParentBrokerage`.`lead_in`, `ParentBrokerage`.`short_description`, `ParentBrokerage`.`description`, `ParentBrokerage`.`communities`, `ParentBrokerage`.`website`, `ParentBrokerage`.`address`, `ParentBrokerage`.`address_2`, `ParentBrokerage`.`city`, `ParentBrokerage`.`state`, `ParentBrokerage`.`full_state`, `ParentBrokerage`.`country`, `ParentBrokerage`.`market`, `ParentBrokerage`.`market_2`, `ParentBrokerage`.`postal_code`, `ParentBrokerage`.`phone`, `ParentBrokerage`.`phone_2`, `ParentBrokerage`.`phone_3`, `ParentBrokerage`.`wide_contact_image`, `ParentBrokerage`.`contact_name`, `ParentBrokerage`.`contact_profile_link`, `ParentBrokerage`.`contact_big_profile_link`, `ParentBrokerage`.`contact_big_profile_link_text`, `ParentBrokerage`.`contact_title`, `ParentBrokerage`.`contact_dre_num`, `ParentBrokerage`.`contact_quote`, `ParentBrokerage`.`contact_email`, `ParentBrokerage`.`contact_facebook`, `ParentBrokerage`.`contact_twitter`, `ParentBrokerage`.`contact_instagram`, `ParentBrokerage`.`contact_pinterest`, `ParentBrokerage`.`contact_linkedin`, `ParentBrokerage`.`contact_youtube`, `ParentBrokerage`.`contact_phone`, `ParentBrokerage`.`contact_email_2`, `ParentBrokerage`.`contact_2_facebook`, `ParentBrokerage`.`contact_2_twitter`, `ParentBrokerage`.`contact_2_instagram`, `ParentBrokerage`.`contact_2_pinterest`, `ParentBrokerage`.`contact_2_linkedin`, `ParentBrokerage`.`contact_2_youtube`, `ParentBrokerage`.`contact_phone_2`, `ParentBrokerage`.`contact_website`, `ParentBrokerage`.`contact_name_2`, `ParentBrokerage`.`contact_profile_link_2`, `ParentBrokerage`.`contact_big_profile_link_2`, `ParentBrokerage`.`contact_big_profile_link_text_2`, `ParentBrokerage`.`contact_title_2`, `ParentBrokerage`.`contact_dre_num_2`, `ParentBrokerage`.`contact_email_3`, `ParentBrokerage`.`contact_name_3`, `ParentBrokerage`.`contact_title_3`, `ParentBrokerage`.`contact_dre_num_3`, `ParentBrokerage`.`contact_phone_3`, `ParentBrokerage`.`contact_3_facebook`, `ParentBrokerage`.`contact_3_twitter`, `ParentBrokerage`.`contact_3_instagram`, `ParentBrokerage`.`contact_3_pinterest`, `ParentBrokerage`.`contact_3_linkedin`, `ParentBrokerage`.`contact_3_youtube`, `ParentBrokerage`.`image_filename`, `ParentBrokerage`.`logo_filename`, `ParentBrokerage`.`contact_image_filename`, `ParentBrokerage`.`all_properties_link_image_filename`, `ParentBrokerage`.`all_properties_link`, `ParentBrokerage`.`video_embed_code`, `ParentBrokerage`.`contact_video_embed_code`, `ParentBrokerage`.`meta_title`, `ParentBrokerage`.`meta_description`, `ParentBrokerage`.`meta_keywords`, `ParentBrokerage`.`login_message_counter`, `ParentBrokerage`.`stats_module_1_type`, `ParentBrokerage`.`stats_module_1_value`, `ParentBrokerage`.`stats_module_2_type`, `ParentBrokerage`.`stats_module_2_value`, `ParentBrokerage`.`stats_module_3_type`, `ParentBrokerage`.`stats_module_3_value`, `ParentBrokerage`.`last_activity_email_sent`, `ParentBrokerage`.`converted`, `ParentBrokerage`.`created`, `ParentBrokerage`.`modified`, `ParentBrokerage`.`dre_num`, `ParentLocation`.`id`, `ParentLocation`.`parent_id`, `ParentLocation`.`brokerage_id`, `ParentLocation`.`type`, `ParentLocation`.`archived`, `ParentLocation`.`use_as_topic`, `ParentLocation`.`name`, `ParentLocation`.`short_name`, `ParentLocation`.`group_index`, `ParentLocation`.`latitude`, `ParentLocation`.`longitude`, `ParentLocation`.`country_code`, `ParentLocation`.`north`, `ParentLocation`.`south`, `ParentLocation`.`east`, `ParentLocation`.`west`, `ParentLocation`.`zoom`, `ParentLocation`.`short_description`, `ParentLocation`.`long_description`, `ParentLocation`.`created`, `ParentLocation`.`modified`, `ParentLocation`.`timezone`, `ParentLocation`.`population` FROM `leveragere_staging2`.`articles` AS `Article` LEFT JOIN `leveragere_staging2`.`brokerages` AS `ParentBrokerage` ON (`Article`.`model_id` = `ParentBrokerage`.`id` AND `Article`.`model` = 'Brokerage') LEFT JOIN `leveragere_staging2`.`locations` AS `ParentLocation` ON (`Article`.`model_id` = `ParentLocation`.`id` AND `Article`.`model` = 'Location') WHERE `Article`.`id` = 441 LIMIT 1	1	1	1
  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` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` = (441) ORDER BY `Image`.`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`, `ArticlesBrokerage`.`id`, `ArticlesBrokerage`.`article_id`, `ArticlesBrokerage`.`brokerage_id` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` JOIN `leveragere_staging2`.`articles_brokerages` AS `ArticlesBrokerage` ON (`ArticlesBrokerage`.`article_id` = 441 AND `ArticlesBrokerage`.`brokerage_id` = `Brokerage`.`id`)	1	1	2	maybe slow
  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`, `ArticlesLocation`.`id`, `ArticlesLocation`.`article_id`, `ArticlesLocation`.`location_id` FROM `leveragere_staging2`.`locations` AS `Location` JOIN `leveragere_staging2`.`articles_locations` AS `ArticlesLocation` ON (`ArticlesLocation`.`article_id` = 441 AND `ArticlesLocation`.`location_id` = `Location`.`id`)	1	1	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`, `ArticlesProperty`.`id`, `ArticlesProperty`.`article_id`, `ArticlesProperty`.`property_id` FROM `leveragere_staging2`.`properties` AS `Property` JOIN `leveragere_staging2`.`articles_properties` AS `ArticlesProperty` ON (`ArticlesProperty`.`article_id` = 441 AND `ArticlesProperty`.`property_id` = `Property`.`id`)	0	0	1	maybe slow
  SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `ArticlesTopic`.`id`, `ArticlesTopic`.`article_id`, `ArticlesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`articles_topics` AS `ArticlesTopic` ON (`ArticlesTopic`.`article_id` = 441 AND `ArticlesTopic`.`topic_id` = `Topic`.`id`)	1	1	0
  SELECT `Article`.`id` FROM `leveragere_staging2`.`articles` AS `Article` WHERE `Article`.`archived` = '0' AND NOT (`Article`.`model` = ('News')) ORDER BY `Article`.`date` DESC LIMIT 10	10	10	2	maybe slow
  SELECT `Article`.`id`, `Article`.`model`, `Article`.`model_id`, `Article`.`archived`, `Article`.`medium_featured`, `Article`.`large_featured`, `Article`.`title`, `Article`.`author`, `Article`.`date`, `Article`.`lead_in`, `Article`.`body`, `Article`.`vimeo_id`, `Article`.`created`, `Article`.`modified` FROM `leveragere_staging2`.`articles` AS `Article` WHERE `Article`.`id` IN (499, 486, 488, 487, 436, 476, 437, 477, 481, 479) ORDER BY RAND() ASC LIMIT 2	2	2	1	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` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (436, 499) ORDER BY `Image`.`order` ASC	2	2	0
  SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `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`.`topics` AS `Topic` LEFT JOIN `leveragere_staging2`.`assets` AS `Image` ON (`Image`.`model_id` = `Topic`.`id` AND `Image`.`model` = 'Topic' AND `Image`.`tag` = 'Image') WHERE NOT (`Topic`.`id` IS NULL) ORDER BY RAND() ASC LIMIT 3	3	3	1	maybe slow
  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`.`use_as_topic` = '1' AND NOT (`Location`.`id` IS NULL) ORDER BY RAND() ASC LIMIT 1	1	1	2	maybe slow
  SELECT `Article`.`id`, `Article`.`model`, `Article`.`model_id`, `Article`.`archived`, `Article`.`medium_featured`, `Article`.`large_featured`, `Article`.`title`, `Article`.`author`, `Article`.`date`, `Article`.`lead_in`, `Article`.`body`, `Article`.`vimeo_id`, `Article`.`created`, `Article`.`modified`, `ParentBrokerage`.`id`, `ParentBrokerage`.`account_executive_id`, `ParentBrokerage`.`archived`, `ParentBrokerage`.`type`, `ParentBrokerage`.`hide_from_frontend`, `ParentBrokerage`.`agent_brokerage_data_override`, `ParentBrokerage`.`featured_development`, `ParentBrokerage`.`membership_type`, `ParentBrokerage`.`max_properties`, `ParentBrokerage`.`max_homepage_featured_by_member_properties`, `ParentBrokerage`.`featured_properties_sort_method`, `ParentBrokerage`.`lux_feed_mode`, `ParentBrokerage`.`max_luxury_feed_properties`, `ParentBrokerage`.`membership_luxury_feed_properties`, `ParentBrokerage`.`can_participate_in_lux_feed_while_archived`, `ParentBrokerage`.`full_training_video_access`, `ParentBrokerage`.`country_id`, `ParentBrokerage`.`WOEID`, `ParentBrokerage`.`timezone`, `ParentBrokerage`.`luxury_feed_enrollment_mode`, `ParentBrokerage`.`luxury_feed_include_mlsidx_minimum_price`, `ParentBrokerage`.`luxury_feed_include_leverage_minimum_price`, `ParentBrokerage`.`digital_ad_contacts`, `ParentBrokerage`.`add_agents_to_grr_auto_recipients`, `ParentBrokerage`.`mlsidx_id`, `ParentBrokerage`.`mlsidx_lux_autofeed`, `ParentBrokerage`.`mlsidx_lux_autofeed_minimum_price`, `ParentBrokerage`.`mlsidx_logo_url`, `ParentBrokerage`.`mlsidx_disclaimer`, `ParentBrokerage`.`name`, `ParentBrokerage`.`broker_of_record_name`, `ParentBrokerage`.`short_name`, `ParentBrokerage`.`username`, `ParentBrokerage`.`password`, `ParentBrokerage`.`password_reset_hash`, `ParentBrokerage`.`monthly_invoice_amount`, `ParentBrokerage`.`monthly_invoice_start_date`, `ParentBrokerage`.`monthly_invoice_end_date`, `ParentBrokerage`.`contract_filename`, `ParentBrokerage`.`active`, `ParentBrokerage`.`lead_in`, `ParentBrokerage`.`short_description`, `ParentBrokerage`.`description`, `ParentBrokerage`.`communities`, `ParentBrokerage`.`website`, `ParentBrokerage`.`address`, `ParentBrokerage`.`address_2`, `ParentBrokerage`.`city`, `ParentBrokerage`.`state`, `ParentBrokerage`.`full_state`, `ParentBrokerage`.`country`, `ParentBrokerage`.`market`, `ParentBrokerage`.`market_2`, `ParentBrokerage`.`postal_code`, `ParentBrokerage`.`phone`, `ParentBrokerage`.`phone_2`, `ParentBrokerage`.`phone_3`, `ParentBrokerage`.`wide_contact_image`, `ParentBrokerage`.`contact_name`, `ParentBrokerage`.`contact_profile_link`, `ParentBrokerage`.`contact_big_profile_link`, `ParentBrokerage`.`contact_big_profile_link_text`, `ParentBrokerage`.`contact_title`, `ParentBrokerage`.`contact_dre_num`, `ParentBrokerage`.`contact_quote`, `ParentBrokerage`.`contact_email`, `ParentBrokerage`.`contact_facebook`, `ParentBrokerage`.`contact_twitter`, `ParentBrokerage`.`contact_instagram`, `ParentBrokerage`.`contact_pinterest`, `ParentBrokerage`.`contact_linkedin`, `ParentBrokerage`.`contact_youtube`, `ParentBrokerage`.`contact_phone`, `ParentBrokerage`.`contact_email_2`, `ParentBrokerage`.`contact_2_facebook`, `ParentBrokerage`.`contact_2_twitter`, `ParentBrokerage`.`contact_2_instagram`, `ParentBrokerage`.`contact_2_pinterest`, `ParentBrokerage`.`contact_2_linkedin`, `ParentBrokerage`.`contact_2_youtube`, `ParentBrokerage`.`contact_phone_2`, `ParentBrokerage`.`contact_website`, `ParentBrokerage`.`contact_name_2`, `ParentBrokerage`.`contact_profile_link_2`, `ParentBrokerage`.`contact_big_profile_link_2`, `ParentBrokerage`.`contact_big_profile_link_text_2`, `ParentBrokerage`.`contact_title_2`, `ParentBrokerage`.`contact_dre_num_2`, `ParentBrokerage`.`contact_email_3`, `ParentBrokerage`.`contact_name_3`, `ParentBrokerage`.`contact_title_3`, `ParentBrokerage`.`contact_dre_num_3`, `ParentBrokerage`.`contact_phone_3`, `ParentBrokerage`.`contact_3_facebook`, `ParentBrokerage`.`contact_3_twitter`, `ParentBrokerage`.`contact_3_instagram`, `ParentBrokerage`.`contact_3_pinterest`, `ParentBrokerage`.`contact_3_linkedin`, `ParentBrokerage`.`contact_3_youtube`, `ParentBrokerage`.`image_filename`, `ParentBrokerage`.`logo_filename`, `ParentBrokerage`.`contact_image_filename`, `ParentBrokerage`.`all_properties_link_image_filename`, `ParentBrokerage`.`all_properties_link`, `ParentBrokerage`.`video_embed_code`, `ParentBrokerage`.`contact_video_embed_code`, `ParentBrokerage`.`meta_title`, `ParentBrokerage`.`meta_description`, `ParentBrokerage`.`meta_keywords`, `ParentBrokerage`.`login_message_counter`, `ParentBrokerage`.`stats_module_1_type`, `ParentBrokerage`.`stats_module_1_value`, `ParentBrokerage`.`stats_module_2_type`, `ParentBrokerage`.`stats_module_2_value`, `ParentBrokerage`.`stats_module_3_type`, `ParentBrokerage`.`stats_module_3_value`, `ParentBrokerage`.`last_activity_email_sent`, `ParentBrokerage`.`converted`, `ParentBrokerage`.`created`, `ParentBrokerage`.`modified`, `ParentBrokerage`.`dre_num`, `ParentLocation`.`id`, `ParentLocation`.`parent_id`, `ParentLocation`.`brokerage_id`, `ParentLocation`.`type`, `ParentLocation`.`archived`, `ParentLocation`.`use_as_topic`, `ParentLocation`.`name`, `ParentLocation`.`short_name`, `ParentLocation`.`group_index`, `ParentLocation`.`latitude`, `ParentLocation`.`longitude`, `ParentLocation`.`country_code`, `ParentLocation`.`north`, `ParentLocation`.`south`, `ParentLocation`.`east`, `ParentLocation`.`west`, `ParentLocation`.`zoom`, `ParentLocation`.`short_description`, `ParentLocation`.`long_description`, `ParentLocation`.`created`, `ParentLocation`.`modified`, `ParentLocation`.`timezone`, `ParentLocation`.`population` FROM `leveragere_staging2`.`articles` AS `Article` LEFT JOIN `leveragere_staging2`.`brokerages` AS `ParentBrokerage` ON (`Article`.`model_id` = `ParentBrokerage`.`id` AND `Article`.`model` = 'Brokerage') LEFT JOIN `leveragere_staging2`.`locations` AS `ParentLocation` ON (`Article`.`model_id` = `ParentLocation`.`id` AND `Article`.`model` = 'Location') WHERE `Article`.`id` = 441 LIMIT 1	1	1	1
  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` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` = (441) ORDER BY `Image`.`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`, `ArticlesBrokerage`.`id`, `ArticlesBrokerage`.`article_id`, `ArticlesBrokerage`.`brokerage_id` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` JOIN `leveragere_staging2`.`articles_brokerages` AS `ArticlesBrokerage` ON (`ArticlesBrokerage`.`article_id` = 441 AND `ArticlesBrokerage`.`brokerage_id` = `Brokerage`.`id`)	1	1	1
  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`, `ArticlesLocation`.`id`, `ArticlesLocation`.`article_id`, `ArticlesLocation`.`location_id` FROM `leveragere_staging2`.`locations` AS `Location` JOIN `leveragere_staging2`.`articles_locations` AS `ArticlesLocation` ON (`ArticlesLocation`.`article_id` = 441 AND `ArticlesLocation`.`location_id` = `Location`.`id`)	1	1	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`, `ArticlesProperty`.`id`, `ArticlesProperty`.`article_id`, `ArticlesProperty`.`property_id` FROM `leveragere_staging2`.`properties` AS `Property` JOIN `leveragere_staging2`.`articles_properties` AS `ArticlesProperty` ON (`ArticlesProperty`.`article_id` = 441 AND `ArticlesProperty`.`property_id` = `Property`.`id`)	0	0	1	maybe slow
  SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `ArticlesTopic`.`id`, `ArticlesTopic`.`article_id`, `ArticlesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`articles_topics` AS `ArticlesTopic` ON (`ArticlesTopic`.`article_id` = 441 AND `ArticlesTopic`.`topic_id` = `Topic`.`id`)	1	1	0
  SELECT `ArticlesTopic`.`id`, `ArticlesTopic`.`article_id` FROM `leveragere_staging2`.`articles_topics` AS `ArticlesTopic` WHERE `ArticlesTopic`.`topic_id` = (24)	12	12	0
  SELECT `Article`.`id`, `Article`.`model`, `Article`.`model_id`, `Article`.`archived`, `Article`.`medium_featured`, `Article`.`large_featured`, `Article`.`title`, `Article`.`author`, `Article`.`date`, `Article`.`lead_in`, `Article`.`body`, `Article`.`vimeo_id`, `Article`.`created`, `Article`.`modified`, `ParentBrokerage`.`id`, `ParentBrokerage`.`account_executive_id`, `ParentBrokerage`.`archived`, `ParentBrokerage`.`type`, `ParentBrokerage`.`hide_from_frontend`, `ParentBrokerage`.`agent_brokerage_data_override`, `ParentBrokerage`.`featured_development`, `ParentBrokerage`.`membership_type`, `ParentBrokerage`.`max_properties`, `ParentBrokerage`.`max_homepage_featured_by_member_properties`, `ParentBrokerage`.`featured_properties_sort_method`, `ParentBrokerage`.`lux_feed_mode`, `ParentBrokerage`.`max_luxury_feed_properties`, `ParentBrokerage`.`membership_luxury_feed_properties`, `ParentBrokerage`.`can_participate_in_lux_feed_while_archived`, `ParentBrokerage`.`full_training_video_access`, `ParentBrokerage`.`country_id`, `ParentBrokerage`.`WOEID`, `ParentBrokerage`.`timezone`, `ParentBrokerage`.`luxury_feed_enrollment_mode`, `ParentBrokerage`.`luxury_feed_include_mlsidx_minimum_price`, `ParentBrokerage`.`luxury_feed_include_leverage_minimum_price`, `ParentBrokerage`.`digital_ad_contacts`, `ParentBrokerage`.`add_agents_to_grr_auto_recipients`, `ParentBrokerage`.`mlsidx_id`, `ParentBrokerage`.`mlsidx_lux_autofeed`, `ParentBrokerage`.`mlsidx_lux_autofeed_minimum_price`, `ParentBrokerage`.`mlsidx_logo_url`, `ParentBrokerage`.`mlsidx_disclaimer`, `ParentBrokerage`.`name`, `ParentBrokerage`.`broker_of_record_name`, `ParentBrokerage`.`short_name`, `ParentBrokerage`.`username`, `ParentBrokerage`.`password`, `ParentBrokerage`.`password_reset_hash`, `ParentBrokerage`.`monthly_invoice_amount`, `ParentBrokerage`.`monthly_invoice_start_date`, `ParentBrokerage`.`monthly_invoice_end_date`, `ParentBrokerage`.`contract_filename`, `ParentBrokerage`.`active`, `ParentBrokerage`.`lead_in`, `ParentBrokerage`.`short_description`, `ParentBrokerage`.`description`, `ParentBrokerage`.`communities`, `ParentBrokerage`.`website`, `ParentBrokerage`.`address`, `ParentBrokerage`.`address_2`, `ParentBrokerage`.`city`, `ParentBrokerage`.`state`, `ParentBrokerage`.`full_state`, `ParentBrokerage`.`country`, `ParentBrokerage`.`market`, `ParentBrokerage`.`market_2`, `ParentBrokerage`.`postal_code`, `ParentBrokerage`.`phone`, `ParentBrokerage`.`phone_2`, `ParentBrokerage`.`phone_3`, `ParentBrokerage`.`wide_contact_image`, `ParentBrokerage`.`contact_name`, `ParentBrokerage`.`contact_profile_link`, `ParentBrokerage`.`contact_big_profile_link`, `ParentBrokerage`.`contact_big_profile_link_text`, `ParentBrokerage`.`contact_title`, `ParentBrokerage`.`contact_dre_num`, `ParentBrokerage`.`contact_quote`, `ParentBrokerage`.`contact_email`, `ParentBrokerage`.`contact_facebook`, `ParentBrokerage`.`contact_twitter`, `ParentBrokerage`.`contact_instagram`, `ParentBrokerage`.`contact_pinterest`, `ParentBrokerage`.`contact_linkedin`, `ParentBrokerage`.`contact_youtube`, `ParentBrokerage`.`contact_phone`, `ParentBrokerage`.`contact_email_2`, `ParentBrokerage`.`contact_2_facebook`, `ParentBrokerage`.`contact_2_twitter`, `ParentBrokerage`.`contact_2_instagram`, `ParentBrokerage`.`contact_2_pinterest`, `ParentBrokerage`.`contact_2_linkedin`, `ParentBrokerage`.`contact_2_youtube`, `ParentBrokerage`.`contact_phone_2`, `ParentBrokerage`.`contact_website`, `ParentBrokerage`.`contact_name_2`, `ParentBrokerage`.`contact_profile_link_2`, `ParentBrokerage`.`contact_big_profile_link_2`, `ParentBrokerage`.`contact_big_profile_link_text_2`, `ParentBrokerage`.`contact_title_2`, `ParentBrokerage`.`contact_dre_num_2`, `ParentBrokerage`.`contact_email_3`, `ParentBrokerage`.`contact_name_3`, `ParentBrokerage`.`contact_title_3`, `ParentBrokerage`.`contact_dre_num_3`, `ParentBrokerage`.`contact_phone_3`, `ParentBrokerage`.`contact_3_facebook`, `ParentBrokerage`.`contact_3_twitter`, `ParentBrokerage`.`contact_3_instagram`, `ParentBrokerage`.`contact_3_pinterest`, `ParentBrokerage`.`contact_3_linkedin`, `ParentBrokerage`.`contact_3_youtube`, `ParentBrokerage`.`image_filename`, `ParentBrokerage`.`logo_filename`, `ParentBrokerage`.`contact_image_filename`, `ParentBrokerage`.`all_properties_link_image_filename`, `ParentBrokerage`.`all_properties_link`, `ParentBrokerage`.`video_embed_code`, `ParentBrokerage`.`contact_video_embed_code`, `ParentBrokerage`.`meta_title`, `ParentBrokerage`.`meta_description`, `ParentBrokerage`.`meta_keywords`, `ParentBrokerage`.`login_message_counter`, `ParentBrokerage`.`stats_module_1_type`, `ParentBrokerage`.`stats_module_1_value`, `ParentBrokerage`.`stats_module_2_type`, `ParentBrokerage`.`stats_module_2_value`, `ParentBrokerage`.`stats_module_3_type`, `ParentBrokerage`.`stats_module_3_value`, `ParentBrokerage`.`last_activity_email_sent`, `ParentBrokerage`.`converted`, `ParentBrokerage`.`created`, `ParentBrokerage`.`modified`, `ParentBrokerage`.`dre_num`, `ParentLocation`.`id`, `ParentLocation`.`parent_id`, `ParentLocation`.`brokerage_id`, `ParentLocation`.`type`, `ParentLocation`.`archived`, `ParentLocation`.`use_as_topic`, `ParentLocation`.`name`, `ParentLocation`.`short_name`, `ParentLocation`.`group_index`, `ParentLocation`.`latitude`, `ParentLocation`.`longitude`, `ParentLocation`.`country_code`, `ParentLocation`.`north`, `ParentLocation`.`south`, `ParentLocation`.`east`, `ParentLocation`.`west`, `ParentLocation`.`zoom`, `ParentLocation`.`short_description`, `ParentLocation`.`long_description`, `ParentLocation`.`created`, `ParentLocation`.`modified`, `ParentLocation`.`timezone`, `ParentLocation`.`population` FROM `leveragere_staging2`.`articles` AS `Article` LEFT JOIN `leveragere_staging2`.`brokerages` AS `ParentBrokerage` ON (`Article`.`model_id` = `ParentBrokerage`.`id` AND `Article`.`model` = 'Brokerage') LEFT JOIN `leveragere_staging2`.`locations` AS `ParentLocation` ON (`Article`.`model_id` = `ParentLocation`.`id` AND `Article`.`model` = 'Location') WHERE `Article`.`id` IN (439, 440, 441, 442, 445, 446, 447, 448, 451, 464, 478, 479) AND `Article`.`id` != 441 AND `Article`.`model` != 'News' AND `Article`.`archived` = '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` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (445, 478, 446, 479) ORDER BY `Image`.`order` ASC	4	4	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`, `ArticlesBrokerage`.`id`, `ArticlesBrokerage`.`article_id`, `ArticlesBrokerage`.`brokerage_id` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` JOIN `leveragere_staging2`.`articles_brokerages` AS `ArticlesBrokerage` ON (`ArticlesBrokerage`.`article_id` IN (445, 478, 446, 479) AND `ArticlesBrokerage`.`brokerage_id` = `Brokerage`.`id`)	4	4	1	maybe slow
  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`, `ArticlesLocation`.`id`, `ArticlesLocation`.`article_id`, `ArticlesLocation`.`location_id` FROM `leveragere_staging2`.`locations` AS `Location` JOIN `leveragere_staging2`.`articles_locations` AS `ArticlesLocation` ON (`ArticlesLocation`.`article_id` IN (445, 478, 446, 479) AND `ArticlesLocation`.`location_id` = `Location`.`id`)	4	4	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`, `ArticlesProperty`.`id`, `ArticlesProperty`.`article_id`, `ArticlesProperty`.`property_id` FROM `leveragere_staging2`.`properties` AS `Property` JOIN `leveragere_staging2`.`articles_properties` AS `ArticlesProperty` ON (`ArticlesProperty`.`article_id` IN (445, 478, 446, 479) AND `ArticlesProperty`.`property_id` = `Property`.`id`)	0	0	1	maybe slow
  SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `ArticlesTopic`.`id`, `ArticlesTopic`.`article_id`, `ArticlesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`articles_topics` AS `ArticlesTopic` ON (`ArticlesTopic`.`article_id` IN (445, 478, 446, 479) AND `ArticlesTopic`.`topic_id` = `Topic`.`id`)	10	10	0
  SELECT `Property`.`id` FROM `leveragere_staging2`.`properties` AS `Property` WHERE `Property`.`archived` = '0' AND `Property`.`incomplete` = '0' ORDER BY `Property`.`created` DESC LIMIT 50	50	50	5	maybe slow
  SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created`, `PrimaryPropertyCategory`.`id`, `PrimaryPropertyCategory`.`name`, `PrimaryPropertyCategory`.`created`, `PrimaryPropertyCategory`.`modified`, `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `StripeSubscription`.`id`, `StripeSubscription`.`brokerage_id`, `StripeSubscription`.`user_id`, `StripeSubscription`.`property_id`, `StripeSubscription`.`type`, `StripeSubscription`.`stripe_id`, `StripeSubscription`.`stripe_customer_id`, `StripeSubscription`.`stripe_checkout_email`, `StripeSubscription`.`stripe_promotion_code`, `StripeSubscription`.`stripe_promotion_code_id`, `StripeSubscription`.`stripe_coupon_code_id`, `StripeSubscription`.`status`, `StripeSubscription`.`current_period_end`, `StripeSubscription`.`cancel_at_period_end`, `StripeSubscription`.`ended`, `StripeSubscription`.`last_change`, `StripeSubscription`.`last_activity_email_sent`, `StripeSubscription`.`created`, `StripeSubscription`.`modified`, `GlobalReachReport`.`id`, `GlobalReachReport`.`property_id`, `GlobalReachReport`.`wsj_desktop`, `GlobalReachReport`.`wsj_mobile`, `GlobalReachReport`.`wsj_expires`, `GlobalReachReport`.`wsj_capture_started`, `GlobalReachReport`.`mg_desktop`, `GlobalReachReport`.`mg_mobile`, `GlobalReachReport`.`mg_expires`, `GlobalReachReport`.`mg_capture_started`, `GlobalReachReport`.`bp_desktop`, `GlobalReachReport`.`bp_mobile`, `GlobalReachReport`.`bp_expires`, `GlobalReachReport`.`gp_capture_started`, `GlobalReachReport`.`mw_desktop`, `GlobalReachReport`.`mw_mobile`, `GlobalReachReport`.`mw_expires`, `GlobalReachReport`.`mw_capture_started`, `GlobalReachReport`.`ft_desktop`, `GlobalReachReport`.`ft_mobile`, `GlobalReachReport`.`ft_expires`, `GlobalReachReport`.`ft_capture_started`, `GlobalReachReport`.`nikkei_desktop`, `GlobalReachReport`.`nikkei_mobile`, `GlobalReachReport`.`nikkei_expires`, `GlobalReachReport`.`nikkei_capture_started`, `GlobalReachReport`.`pgl_desktop`, `GlobalReachReport`.`pgl_mobile`, `GlobalReachReport`.`pgl_expires`, `GlobalReachReport`.`pgl_capture_started`, `GlobalReachReport`.`robb_desktop`, `GlobalReachReport`.`robb_mobile`, `GlobalReachReport`.`robb_expires`, `GlobalReachReport`.`robb_capture_started`, `GlobalReachReport`.`juwai_desktop`, `GlobalReachReport`.`juwai_mobile`, `GlobalReachReport`.`juwai_expires`, `GlobalReachReport`.`juwai_capture_started`, `GlobalReachReport`.`leverage_desktop`, `GlobalReachReport`.`leverage_mobile`, `GlobalReachReport`.`leverage_expires`, `GlobalReachReport`.`leverage_capture_started`, `GlobalReachReport`.`created`, `GlobalReachReport`.`modified` FROM `leveragere_staging2`.`properties` AS `Property` LEFT JOIN `leveragere_staging2`.`property_categories` AS `PrimaryPropertyCategory` ON (`Property`.`primary_property_category_id` = `PrimaryPropertyCategory`.`id`) LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Property`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`stripe_subscriptions` AS `StripeSubscription` ON (`StripeSubscription`.`property_id` = `Property`.`id` AND `StripeSubscription`.`status` = 'active') LEFT JOIN `leveragere_staging2`.`global_reach_reports` AS `GlobalReachReport` ON (`GlobalReachReport`.`property_id` = `Property`.`id`) WHERE `Property`.`id` IN (3762, 3761, 3760, 3759, 3758, 3757, 3756, 3755, 3754, 3753, 3752, 3749, 3747, 3745, 3743, 3742, 3741, 3740, 3739, 3738, 3736, 3734, 3733, 3732, 3731, 3730, 3729, 3728, 3727, 3726, 3724, 3723, 3722, 3721, 3719, 3718, 3717, 3716, 3715, 3714, 3713, 3712, 3711, 3710, 3708, 3707, 3706, 3705, 3704, 3703) AND `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	7	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 (3761, 3734, 3738, 3704) ORDER BY `Image`.`order` ASC	22	22	13	maybe slow
  SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (3761, 3734, 3738, 3704) 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 (3761, 3734, 3738, 3704) 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 (3761, 3734, 3738, 3704) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	5	5	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 (3761, 3734, 3738, 3704) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	1	1	1

  6 duplicate queries run.

  Query Explain:

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

  ====
• Timer
  +

  Memory

  Peak Memory Use 11.39 MB

  Message	Memory use
  Component initialization	2.91 MB
  Controller action start	3.84 MB
  Controller render start	6.71 MB
  View render complete	7.27 MB

  Timers

  Total Request Time: 260 (ms)

  Message	Time in ms	Graph
  Core Processing (Derived from $_SERVER["REQUEST_TIME"])	26.74
  Event: Controller.initialize	3.84
  Event: Controller.startup	1.13
  Controller action	115.37
  Event: Controller.beforeRender	8.53
  » Processing toolbar data	8.42
  Rendering View	79.16
  » Event: View.beforeRender	0.28
  » Rendering APP/View/Articles/view.ctp	3.72
  » » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.16
  » » Rendering APP/View/Elements/sidebar/explore.ctp	0.88
  » » » Rendering APP/View/Elements/explore_tile_small.ctp	0.13
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #2	0.13
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #3	0.12
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #4	0.13
  » » Rendering APP/View/Elements/sidebar/article_list.ctp	0.18
  » » Rendering APP/View/Elements/sidebar/property_search.ctp	0.19
  » » Rendering APP/View/Elements/sidebar/property_list.ctp	1.24
  » » » Rendering APP/View/Elements/static_property_price.ctp	0.38
  » » » Rendering APP/View/Elements/static_property_price.ctp #2	0.15
  » » » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
  » » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
  » Event: View.afterRender	0.01
  » Event: View.beforeLayout	0.01
  » Rendering APP/View/Layouts/front.ctp	74.46
  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)
        • id3761
        • brokerage_id253
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameLocal Homes Demo Property
        • incomplete(false)
        • archived(false)
        • last_archived0000-00-00 00:00:00
        • auto_archived_from_mlsidx(false)
        • paid_featured(false)
        • featured(false)
        • 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(true)
        • 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(false)
        • description<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse purus nunc, congue id dolor a, hendrerit ultrices augue. Nulla pretium ultricies enim sed finibus. Morbi non erat congue, elementum magna quis, efficitur justo. Etiam eget est interdum, vulputate ex a, gravida sapien. Etiam rutrum risus dui, in viverra lacus suscipit sodales. Curabitur vulputate eros sit amet sollicitudin eleifend. Nullam vestibulum blandit massa ut vestibulum.</p> <p>Proin sollicitudin, libero at placerat vehicula, leo urna feugiat orci, eget aliquam nisl est ac arcu. Etiam bibendum mauris non tellus venenatis tincidunt. Aenean tellus metus, tempus eget efficitur tempor, ornare non diam. Nunc aliquam dui tellus. Maecenas lectus purus, facilisis tempus euismod sed, tincidunt venenatis est. Ut eu sollicitudin felis. Phasellus faucibus erat ultricies est consectetur euismod.</p>
        • address425 E. 4th Street
        • address_2Suite C
        • cityLong Beach
        • stateCA
        • postal_code90802
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price750000
        • price_20
        • price_usd750000
        • price_usd_20
        • statusFor Sale
        • status_last_changed2025-07-30 16:54:25
        • status_last_changed_price_only2025-07-30 16:54:25
        • lease_period
        • price_upon_request(false)
        • bedrooms3
        • bedrooms_20
        • bathrooms2
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet1800
        • square_meters
        • acres0
        • interior_unitsq_ft
        • interior_size1800
        • lot_unitacres
        • lot_size0
        • icon_1
        • icon_2
        • icon_3
        • icon_4
        • icon_5
        • icon_6
        • website
        • meta_title
        • meta_description
        • meta_keywords
        • bathrooms_partial0
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built
        • virtual_tour
        • video_tour
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num
        • wsj_property_type
        • nyt_property_type
        • nyt_popular_features
        • propgolux_property_type
        • juwai_property_type
        • juwai_category
        • propgolux_property_style
        • wapo_property_type
        • robb_property_type
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude33.772030
        • longitude-118.186775
        • invalid_required_fields
        • invalid_optional_fields
        • went_live_today(false)
        • converted(false)
        • 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)
        • modified2025-07-30 16:54:51
        • created2025-07-30 16:54:17
        • uri/property-detail/3761/425-e-4th-street-suite-c-long-beach-ca-90802-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3761/425-e-4th-street-suite-c-long-beach-ca-90802-usa
        • address_concat425 E. 4th Street Suite C Long Beach CA 90802 USA
        • google_maps_query_string425+E.+4th+Street+Suite+C+Long+Beach+CA+90802+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 750,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty3
        • bathrooms_pretty2
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms2
        • date_listed2025-07-30
        • brokerage_name_was_overridden(true)
        • overridden_brokerage_nameWayne Enterprises
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id253
        • account_executive_id0
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(true)
        • featured_development(false)
        • membership_typeBasic
        • max_properties4
        • 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
        • WOEID(null)
        • timezone
        • 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_id137,138
        • mlsidx_lux_autofeed(false)
        • mlsidx_lux_autofeed_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • nameLocal Homes
        • broker_of_record_name
        • short_nameLocal Homes
        • username
        • password
        • password_reset_hash
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>Lorem ipsum</p>
        • communities
        • websitehttps://jloop.com
        • address425 E. 4th Street
        • address_2Suite C
        • cityLong Beach
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • market
        • market_2
        • postal_code90802
        • phone888-888-8888
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameChris Stevens
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titleDeveloper
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename
        • logo_filename
        • contact_image_filename
        • all_properties_link_image_filename
        • all_properties_link
        • video_embed_code
        • contact_video_embed_code
        • meta_title
        • meta_description
        • meta_keywords
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(false)
        • created2025-07-24 10:37:44
        • modified2025-07-30 16:55:18
        • dre_num
        • uri/brokerage-detail/253/local-homes
        • website_shortjloop.com
        • name_with_locationLocal Homes
        • mlsidx_id_array(array)
          • 0137
          • 1138
      • 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)
          • id23136
          • modelProperty
          • model_id3761
          • tagImage
          • nameScreenshot 2025-07-30 at 4.54.04 PM.png
          • typeimage/png
          • size2029923
          • uri/assets/23136.png
          • order0
          • created2025-07-30 16:54:15
          • modified2025-07-30 16:54:17
      • User(array)
        • 0(array)
          • id1298
          • typeAgent
          • brokerage_id253
          • email[email protected]
          • password6e83e74e5aad7dc2404b41f4dad53b857b4a34ae
          • recover_hash
          • first_nameLocalhomes
          • last_nameDemoagent
          • title
          • dre_num
          • phone888-888-8888
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_overrideWayne Enterprises
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2025-07-30 16:59:22
          • created2025-07-30 16:50:04
          • notified(false)
          • full_nameLocalhomes Demoagent
          • uri/agent-detail/1298/localhomes-demoagent
          • profile_complete(true)
          • UsersProperty(array)
            • id1140
            • user_id1298
            • property_id3761
            • sort_order0
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(empty)
      • Topic(empty)
    • 1(array)
      • Property(array)
        • id3734
        • brokerage_id5
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameLovely & Detailed Remodel in South Pasadena
        • incomplete(false)
        • archived(false)
        • last_archived0000-00-00 00:00:00
        • auto_archived_from_mlsidx(false)
        • paid_featured(false)
        • featured(false)
        • 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(false)
        • description<p>Lovely and creatively remodeled home w/ a 2nd story in 2002 while preserving the 1925 integrity of the estate. Grand foyer w/ custom stairwell & impressive chandelier offers a stately entrance to this impeccable home loaded w/ an abundance of charm & character. There are impressive intricate details throughout. Adjacent to the foyer is a formal living room offering natural light by day & a cozy romantic fireplace by night. Gourmet kitchen is a chef's dream w/ center island, double ovens, stove top & opens to the family room. Luxurious master suite is located on the 2nd level w/ inspiring views of the rear gardens. Master bath offers dual sinks, soaking tub & oversized shower w/ bench. Backyard is ideal for entertaining under the grandiose pergola or simply relaxing & enjoying the vistas of the grassy area & mature trees. This a special South Pasadena home that has been lovingly maintained for the past 21 years by the current owners. Thank you for sharing in the joy of viewing this home.</p>
        • address1817 Spruce Street
        • address_2
        • citySouth Pasadena
        • stateCA
        • postal_code91030
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price1780000
        • price_20
        • price_usd1780000
        • 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
        • bathrooms2
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet2846
        • square_meters
        • acres0
        • interior_unitsq_ft
        • interior_size0
        • lot_unitacres
        • lot_size0
        • icon_1
        • icon_2
        • icon_3
        • icon_4
        • icon_5
        • icon_6
        • websitehttp://1817sprucestreetstreet.thepartnerstrust.com/
        • meta_title
        • meta_description
        • meta_keywords
        • bathrooms_partial2
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built1925
        • virtual_tour
        • video_tourhttp://www.onvedeo.com/properties/759797/embed
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num316002835
        • wsj_property_typesingle family
        • nyt_property_type1
        • nyt_popular_features
        • propgolux_property_type9
        • juwai_property_type
        • juwai_category
        • propgolux_property_style42
        • 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
        • latitude34.105072
        • longitude-118.145790
        • invalid_required_fields
        • invalid_optional_fields
        • 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 00:33:02
        • created2016-04-15 16:49:02
        • uri/property-detail/3734/1817-spruce-street-south-pasadena-ca-91030-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3734/1817-spruce-street-south-pasadena-ca-91030-usa
        • address_concat1817 Spruce Street South Pasadena CA 91030 USA
        • google_maps_query_string1817+Spruce+Street++South+Pasadena+CA+91030+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 1,780,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty4
        • bathrooms_pretty2
        • bathrooms_partial_pretty2
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms2
        • date_listed2016-04-15
        • overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id5
        • account_executive_id236
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties12
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties2
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(true)
        • country_id1
        • WOEID2468964
        • timezoneUS/Pacific
        • luxury_feed_enrollment_modemanual
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id
        • mlsidx_lux_autofeed(false)
        • mlsidx_lux_autofeed_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • namePartners Trust Real Estate Brokerage and Acquisitions
        • broker_of_record_name
        • short_namePartners Trust Real Estate
        • usernamePartnersTrustPas
        • password5b28522e46f56278664573d82c2b0f03520519d0
        • password_reset_hash
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date0000-00-00
        • monthly_invoice_end_date0000-00-00
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>Partners Trust is the exclusive representative for Leverage Global Partners in Pasadena and La Cañada Flintridge, California, USA.</p> <p>At Partners Trust, we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market, presenting our clients with the most professional, successful and ethical real estate associates in the business. We represent our clients with care, confidentiality and the utmost attention to service.</p> <p>Pasadena is a harmonious blend of past and present. Experience the nationally-televised Rose Parade, catch an exciting football game at the Rose Bowl, get smart at Caltech, or revel in the Jet Propulsion Laboratory.</p> <p>The community is renowned for its charming and diverse neighborhoods whose residents honor and preserve the splendor of early California architecture. Opportunities abound to experience Pasadena’s sophisticated culture with the diversified entertainment at the Pasadena Playhouse, the Norton Simon Museum, the Huntington Library and Botanical Gardens and even by walking along the vibrant, historic district of Colorado Boulevard.</p> <p>Partners Trust associates are proud to represent a wide variety of historic and architecturally diverse homes, including the Craftsman-style home. We understand our clients discerning needs, and provide a high level of service and local area knowledge.</p> <p>Partners Trust has additional office locations in <a href="../../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/142/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Malibu</a>, and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a></p>
        • communitiesPasadena La Canada Flintridge San Marino La Canada Flintridge
        • websitehttp://www.thepartnerstrust.com
        • address594 E. Colorado Boulevard
        • address_2
        • cityPasadena
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • marketPasadena
        • market_2
        • postal_code91101
        • phone(626) 696-4802
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameScott Brown
        • contact_profile_link
        • contact_big_profile_linkhttp://www.leveragere.com/blog/meet-scott-brown-managing-director-partners-trust-pasadena/
        • contact_big_profile_link_text
        • contact_titleManaging Director
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2Nick Segal
        • contact_profile_link_2http://www.leveragere.com/brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2President/Co-Founder
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename5.jpg
        • logo_filename5.png
        • contact_image_filename5.jpg
        • all_properties_link_image_filename5.jpg
        • all_properties_linkhttp://www.thepartnerstrust.com/properties
        • video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
        • contact_video_embed_code
        • meta_titlePasadena Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
        • meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Pasadena, CA is a premier boutique Pasadena real estate brokerage and the exclusive Pasadena representative for Leverage Global Partners.
        • meta_keywordspartners trust, partners trust real estate, pasadena real estate, leverage global partners, pasadena homes for sale, scott brown
        • login_message_counter1
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-03-18 16:08:06
        • modified2016-04-08 16:33:22
        • dre_num012345
        • uri/brokerage-detail/5/partners-trust-real-estate-brokerage-and-acquisitions
        • website_shortwww.thepartnerstrust.com
        • name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
      • 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)
          • id20890
          • modelProperty
          • model_id3734
          • tagImage
          • nameegpimaging_1817Spruce_001_HIGHRES.jpg
          • typeimage/jpeg
          • size10361514
          • uri/assets/20890.jpg
          • order0
          • created2016-04-15 16:47:48
          • modified2016-04-15 16:49:02
        • 1(array)
          • id20879
          • modelProperty
          • model_id3734
          • tagImage
          • nameegpimaging_1817Spruce_008_HIGHRES.jpg
          • typeimage/jpeg
          • size6804950
          • uri/assets/20879.jpg
          • order1
          • created2016-04-15 16:47:42
          • modified2016-04-15 16:49:02
        • 2(array)
          • id20877
          • modelProperty
          • model_id3734
          • tagImage
          • nameegpimaging_1817Spruce_017_HIGHRES.jpg
          • typeimage/jpeg
          • size5626562
          • uri/assets/20877.jpg
          • order2
          • created2016-04-15 16:47:39
          • modified2016-04-15 16:49:02
        • 3(array)
          • id20876
          • modelProperty
          • model_id3734
          • tagImage
          • nameegpimaging_1817Spruce_022_HIGHRES.jpg
          • typeimage/jpeg
          • size5719147
          • uri/assets/20876.jpg
          • order3
          • created2016-04-15 16:47:38
          • modified2016-04-15 16:49:02
        • 4(array)
          • id20878
          • modelProperty
          • model_id3734
          • tagImage
          • nameegpimaging_1817Spruce_014_HIGHRES.jpg
          • typeimage/jpeg
          • size5358186
          • uri/assets/20878.jpg
          • order4
          • created2016-04-15 16:47:40
          • modified2016-04-15 16:49:02
        • 5(array)
          • id20882
          • modelProperty
          • model_id3734
          • tagImage
          • nameegpimaging_1817Spruce_009_HIGHRES.jpg
          • typeimage/jpeg
          • size6157612
          • uri/assets/20882.jpg
          • order5
          • created2016-04-15 16:47:46
          • modified2016-04-15 16:49:02
        • 6(array)
          • id20881
          • modelProperty
          • model_id3734
          • tagImage
          • nameegpimaging_1817Spruce_038_HIGHRES.jpg
          • typeimage/jpeg
          • size9795680
          • uri/assets/20881.jpg
          • order6
          • created2016-04-15 16:47:44
          • modified2016-04-15 16:49:02
        • 7(array)
          • id20894
          • modelProperty
          • model_id3734
          • tagImage
          • nameegpimaging_1817Spruce_044_HIGHRES.jpg
          • typeimage/jpeg
          • size11888212
          • uri/assets/20894.jpg
          • order7
          • created2016-04-15 16:47:50
          • modified2016-04-15 16:49:02
        • 8(array)
          • id20883
          • modelProperty
          • model_id3734
          • tagImage
          • nameegpimaging_1817Spruce_035_HIGHRES.jpg
          • typeimage/jpeg
          • size10217742
          • uri/assets/20883.jpg
          • order8
          • created2016-04-15 16:47:47
          • modified2016-04-15 16:49:02
        • 9(array)
          • id20880
          • modelProperty
          • model_id3734
          • tagImage
          • nameegpimaging_1817Spruce_040_HIGHRES.jpg
          • typeimage/jpeg
          • size10614464
          • uri/assets/20880.jpg
          • order9
          • created2016-04-15 16:47:43
          • modified2016-04-15 16:49:02
      • User(empty)
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(array)
        • 0(array)
          • id9
          • nameOffice
          • additional(false)
          • created2016-04-07 14:03:21
          • modified2016-04-07 14:03:21
          • PropertiesPropertyFeature(array)
            • id4405
            • property_id3734
            • property_feature_id9
        • 1(array)
          • id4
          • nameGarage
          • additional(false)
          • created2016-04-07 14:01:52
          • modified2016-04-07 14:01:52
          • PropertiesPropertyFeature(array)
            • id4404
            • property_id3734
            • property_feature_id4
      • Topic(empty)
    • 2(array)
      • Property(array)
        • id3738
        • brokerage_id1
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameTastefully Updated and Maintained Deluxe Condo in a Phenomenal Location
        • incomplete(false)
        • archived(false)
        • last_archived0000-00-00 00:00:00
        • auto_archived_from_mlsidx(false)
        • paid_featured(false)
        • featured(false)
        • homepage_featured(false)
        • brokerage_page_featured(false)
        • requested_homepage_featured_by_member(false)
        • homepage_featured_by_member(false)
        • dot_luxury_featured(false)
        • luxury_feed_featured(true)
        • force_luxury_feed_featured(false)
        • luxury_autofeed_imported(false)
        • luxury_feed_last_added_time0000-00-00 00:00:00
        • luxury_feed_agent_user_id0
        • luxury_feed_locked_to_subscription_id0
        • luxury_feed_agent_purchase_date0000-00-00
        • luxury_feed_agent_expiration_date0000-00-00
        • digital_ad_summary_email_last_sent0000-00-00 00:00:00
        • digital_ad_summary_price_changed(false)
        • wsj_detail_url
        • ft_detail_url
        • nyt_detail_url
        • juwai_detail_url
        • pgl_detail_url
        • mg_detail_url
        • mg_c_detail_url
        • mg_s_detail_url
        • bp_detail_url
        • mw_detail_url
        • nikkei_detail_url
        • wapo_detail_url
        • robb_detail_url
        • medium_featured(false)
        • large_featured(false)
        • detail_page(false)
        • description<p>Tastefully updated and impeccably maintained top floor deluxe condominium with dazzling city & mountain views! Owner spared no expense remodeling this bright and spacious home. Amazing open kitchen with GE profile appliances, custom cabinetry, tumbled stone backsplash, granite countertops, & 46 bottle wine fridge. Both bathrooms are renovated with travertine and have skylights. Newer AC with wireless thermostat. Floor to ceiling windows bring in lots of light and VIEWS. Other features include LED energy efficient recessed lights with dimmers, surround sound speakers, newer doors, huge secluded balcony, huge bedroom with views & en-suite closet, & much more. Building has EQ insurance, pool, spa, courtyard, guest parking, copper plumbing, renovated elevator & hallways, and low HOA dues. Phenomenal location moments from Runyon Canyon Park, Hollywood & Highland, the Metro-Rail Subway, Rock & Roll Ralph's, and West Hollywood. This unit is immaculate & pristine. Please see private remarks.</p>
        • address7270 Hillside Avenue
        • address_2Unit 307
        • cityLos Angeles
        • stateCA
        • postal_code90046
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price529000
        • price_20
        • price_usd529000
        • 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)
        • bedrooms1
        • bedrooms_20
        • bathrooms2
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet929
        • square_meters
        • acres0
        • interior_unitsq_ft
        • interior_size0
        • lot_unitacres
        • lot_size0
        • icon_1
        • icon_2
        • icon_3
        • icon_4
        • icon_5
        • icon_6
        • websitehttp://7270hillsideavenue307.thepartnerstrust.com/
        • meta_title
        • meta_description
        • meta_keywords
        • bathrooms_partial0
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built1965
        • virtual_tour
        • video_tourhttp://www.onvedeo.com/properties/759796/embed
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num16114060
        • wsj_property_typecondominium
        • nyt_property_type5
        • nyt_popular_features
        • propgolux_property_type2
        • juwai_property_type
        • juwai_category
        • propgolux_property_style16
        • wapo_property_type
        • robb_property_type
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude34.104309
        • longitude-118.348297
        • invalid_required_fields
        • invalid_optional_fields
        • went_live_today(false)
        • converted(true)
        • invalid(false)
        • mlsidx_full_address
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id3
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2019-08-22 10:12:40
        • created2016-04-18 08:50:12
        • uri/property-detail/3738/7270-hillside-avenue-unit-307-los-angeles-ca-90046-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3738/7270-hillside-avenue-unit-307-los-angeles-ca-90046-usa
        • address_concat7270 Hillside Avenue Unit 307 Los Angeles CA 90046 USA
        • google_maps_query_string7270+Hillside+Avenue+Unit+307+Los+Angeles+CA+90046+USA
        • luxury_ad_enrolled_prettyYES
        • price_prettyUSD 529,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty1
        • bathrooms_pretty2
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms2
        • date_listed2016-04-18
        • overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id3
        • nameUnder $1 Million
        • created2019-08-22 10:08:27
        • modified2019-08-29 09:59:08
        • uri/category-detail/3/under-1-million
      • Brokerage(array)
        • id1
        • account_executive_id236
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties12
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties1
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(true)
        • country_id1
        • WOEID2363796
        • timezoneUS/Pacific
        • luxury_feed_enrollment_modemanual
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id
        • mlsidx_lux_autofeed(false)
        • mlsidx_lux_autofeed_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • namePartners Trust Real Estate Brokerage and Acquisitions
        • broker_of_record_name
        • short_namePartners Trust Real Estate
        • usernamePartnersTrustBH
        • password2a77eb13ee7deac93b310ba1431a4982bfdbddeb
        • password_reset_hash
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date0000-00-00
        • monthly_invoice_end_date0000-00-00
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<h2> </h2> <p>Partners Trust is the exclusive representative for Leverage Global Partners in Beverly Hills, California, USA.</p> <p>We are dedicated to being the finest real estate brokerage in Los Angeles.</p> <p>At Partners Trust, our objective is to present our clients with the most professional, successful and ethical real estate associates in the business and to represent our clients with care, confidentiality and the utmost attention to service. We believe we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market.</p> <p>We begin with a commodity that is hard-earned and easily lost: TRUST.</p> <p>Without the daily demonstration and commitment to uphold principles, a company’s mission statement is simply words on a page and nothing more. Partners Trust has adopted a mission statement that each Associate and staff member must sign to in order to participate with the Company, which articulates the core philosophy and culture of the Company.</p> <p>The Partners Trust founders utilized their extensive experience and resources to create a Company that is both unique and beneficial for those willing to commit to the rigorous standards that have been set forth. The Company’s intention is to empower each member of its sales force each and every step of the way.</p> <p>Partners Trust has additional office locations in <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/5/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Pasadena</a>, <a href="../../../brokerage-detail/142/Partners-Trust" target="_blank">Malibu</a> and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a></p>
        • communitiesBeverly Hills Bel Air Century City Westwood West Hollywood
        • websitehttp://thepartnerstrust.com
        • address9378 Wilshire Boulevard
        • address_2Suite 200
        • cityBeverly Hills
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • marketBeverly Hills
        • market_2
        • postal_code90212
        • phone(310) 500-1388
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameNick Segal
        • contact_profile_link
        • contact_big_profile_linkhttp://www.leveragere.com/blog/presidential-profile-partners-trust-real-estate-brokerage-aquisitions-nick-segal/
        • contact_big_profile_link_text
        • contact_titlePresident/Co-Founder
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename1.jpg
        • logo_filename1.png
        • contact_image_filename1.jpg
        • all_properties_link_image_filename1.jpg
        • all_properties_linkhttp://www.thepartnerstrust.com/properties
        • video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
        • contact_video_embed_code
        • meta_titleBeverly Hills Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
        • meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions is an award-winning real estate brokerage representing Leverage Global Partners in Beverly Hills, CA, USA.
        • meta_keywordspartners trust, partners trust real estate, beverly hills real estate, beverly hills real estate agents, leverage global partners
        • login_message_counter2
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-02-21 13:57:13
        • modified2016-04-08 16:33:22
        • dre_num012345
        • uri/brokerage-detail/1/partners-trust-real-estate-brokerage-and-acquisitions
        • website_shortthepartnerstrust.com
        • name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
      • 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)
          • id20942
          • modelProperty
          • model_id3738
          • tagImage
          • name1.jpg
          • typeimage/jpeg
          • size508290
          • uri/assets/20942.jpg
          • order0
          • created2016-04-18 08:49:08
          • modified2019-08-22 10:12:34
        • 1(array)
          • id20935
          • modelProperty
          • model_id3738
          • tagImage
          • name4.jpg
          • typeimage/jpeg
          • size309359
          • uri/assets/20935.jpg
          • order1
          • created2016-04-18 08:49:08
          • modified2019-08-22 10:12:34
        • 2(array)
          • id20934
          • modelProperty
          • model_id3738
          • tagImage
          • name22.jpg
          • typeimage/jpeg
          • size298555
          • uri/assets/20934.jpg
          • order2
          • created2016-04-18 08:49:08
          • modified2019-08-22 10:12:34
        • 3(array)
          • id20940
          • modelProperty
          • model_id3738
          • tagImage
          • name16.jpg
          • typeimage/jpeg
          • size376361
          • uri/assets/20940.jpg
          • order3
          • created2016-04-18 08:49:08
          • modified2019-08-22 10:12:34
        • 4(array)
          • id20937
          • modelProperty
          • model_id3738
          • tagImage
          • name23.jpg
          • typeimage/jpeg
          • size288132
          • uri/assets/20937.jpg
          • order4
          • created2016-04-18 08:49:08
          • modified2019-08-22 10:12:34
        • 5(array)
          • id20933
          • modelProperty
          • model_id3738
          • tagImage
          • name25.jpg
          • typeimage/jpeg
          • size272129
          • uri/assets/20933.jpg
          • order5
          • created2016-04-18 08:49:08
          • modified2019-08-22 10:12:34
        • 6(array)
          • id20936
          • modelProperty
          • model_id3738
          • tagImage
          • name26.jpg
          • typeimage/jpeg
          • size292700
          • uri/assets/20936.jpg
          • order6
          • created2016-04-18 08:49:08
          • modified2019-08-22 10:12:34
        • 7(array)
          • id20939
          • modelProperty
          • model_id3738
          • tagImage
          • name8.jpg
          • typeimage/jpeg
          • size420302
          • uri/assets/20939.jpg
          • order7
          • created2016-04-18 08:49:08
          • modified2019-08-22 10:12:34
        • 8(array)
          • id20938
          • modelProperty
          • model_id3738
          • tagImage
          • name27.jpg
          • typeimage/jpeg
          • size402446
          • uri/assets/20938.jpg
          • order8
          • created2016-04-18 08:49:08
          • modified2019-08-22 10:12:34
        • 9(array)
          • id20941
          • modelProperty
          • model_id3738
          • tagImage
          • name30.jpg
          • typeimage/jpeg
          • size524194
          • uri/assets/20941.jpg
          • order9
          • created2016-04-18 08:49:08
          • modified2019-08-22 10:12:34
      • User(array)
        • 0(array)
          • id1277
          • typeAgent
          • brokerage_id1
          • email[email protected]
          • password8e8b5fcac6e3ab69670f2940cd8f2f3461040a84
          • recover_hash
          • first_nameJimmy
          • last_nameMartinez
          • title
          • dre_num
          • phone323.377.0548
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2017-08-07 15:24:02
          • created2017-08-07 15:24:02
          • notified(false)
          • full_nameJimmy Martinez
          • uri/agent-detail/1277/jimmy-martinez
          • profile_complete(true)
          • UsersProperty(array)
            • id1103
            • user_id1277
            • property_id3738
            • sort_order0
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(array)
        • 0(array)
          • id14
          • nameViews
          • additional(false)
          • created2016-04-07 14:04:55
          • modified2016-04-07 14:04:55
          • PropertiesPropertyFeature(array)
            • id4724
            • property_id3738
            • property_feature_id14
        • 1(array)
          • id4
          • nameGarage
          • additional(false)
          • created2016-04-07 14:01:52
          • modified2016-04-07 14:01:52
          • PropertiesPropertyFeature(array)
            • id4723
            • property_id3738
            • property_feature_id4
        • 2(array)
          • id1
          • nameBalcony/Terrace
          • additional(false)
          • created2016-04-07 14:00:26
          • modified2016-04-07 14:00:26
          • PropertiesPropertyFeature(array)
            • id4722
            • property_id3738
            • property_feature_id1
      • Topic(array)
        • 0(array)
          • id4
          • nameKiller Views
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:33:10
          • tile_nameKiller Views
          • PropertiesTopic(array)
            • id51
            • property_id3738
            • topic_id4
    • 3(array)
      • Property(array)
        • id3704
        • brokerage_id81
        • created_by_user_id0
        • order2
        • multi_unit(false)
        • agent_1_id150
        • agent_2_id0
        • agent_3_id0
        • nameArtful Spaces
        • 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>Dramatic new home by PKK Builders & design by GTM Architects. Exceptional quality throughout. Stunning design. Beautiful scale. Unbeatable location,-talk about a great lifestyle!!! Completion early 2016. This is a great time to pick finishes and customize. Walk to downtown Bethesda, metro, shopping, restaurant district, entertainment & more! Comprehensive resident services by Town of Ch Chase!</p>
        • address4421 Ridge Street
        • address_2
        • cityChevy Chase
        • stateMD
        • postal_code20815
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price2200000
        • price_20
        • price_usd2200000
        • 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
        • bathrooms4
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet0
        • square_meters
        • acres0
        • interior_unitsq_ft
        • interior_size0
        • lot_unitacres
        • lot_size0
        • icon_1
        • icon_2
        • icon_3
        • icon_4
        • icon_5
        • icon_6
        • websitehttp://www.eversco.com/homes-for-sale-details/4421-RIDGE-STREET-CHEVY-CHASE-MD-20815/MC9503168/30/
        • meta_titleArtful Spaces | Chevy Chase Real Estate | Evers & Co. Real Estate
        • meta_description4421 Ridge Street is a property offered for sale in Chevy Chase, MD, USA, presented by Evers & Co. Real Estate
        • meta_keywords
        • bathrooms_partial1
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built
        • virtual_tourhttp://slideshow.mris.com/slideshow/slideshow.htm?ListingKey=99076375432
        • 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, video_tour
        • went_live_today(false)
        • converted(true)
        • invalid(false)
        • mlsidx_full_address
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2016-04-18 05:33:02
        • created2016-04-06 11:36:57
        • uri/property-detail/3704/4421-ridge-street-chevy-chase-md-20815-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3704/4421-ridge-street-chevy-chase-md-20815-usa
        • address_concat4421 Ridge Street Chevy Chase MD 20815 USA
        • google_maps_query_string4421+Ridge+Street++Chevy+Chase+MD+20815+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 2,200,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty5
        • bathrooms_pretty4
        • bathrooms_partial_pretty1
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms4
        • date_listed2016-04-06
        • overridden_brokerage_nameEvers & Co. Real Estate
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id81
        • account_executive_id235
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties8
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties0
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id1
        • WOEID2379523
        • 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
        • nameEvers & Co. Real Estate
        • broker_of_record_name
        • short_nameEvers & Co. Real Estate
        • usernameEversCoRealEstateCC
        • password440e06f17502b0b97a9e4aa2f069e898691a3b4c
        • password_reset_hash
        • monthly_invoice_amount0.00
        • monthly_invoice_start_date0000-00-00
        • monthly_invoice_end_date0000-00-00
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>Evers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Chevy Chase, MD, and <a href="../../../brokerage-detail/80/Evers-&-Co.-Real-Estate">Washington, D.C</a>, USA.,</p> <p>We are 100+ salespeople who offer our clients a level of service that is unmatched in today’s real estate marketplace, and we deliver this extraordinary service with courtesy and integrity to everyone involved in each transaction.</p> <p>We are enthusiastic about the neighborhoods where we live and work, from Chevy Chase to Capitol Hill, from Dupont Circle to Arlington, and everywhere in between. The highly visible storefront offices of Evers & Co. in Downtown Washington, Friendship Heights in Upper Northwest, downtown Bethesda-Chevy Chase and in Bluemont in the Virginia Wine Country are bustling with the entrepreneurial energy of agents who have in-depth knowledge of local history, architecture and construction techniques as well as expert skills in marketing and negotiating, all of which adds value to our service and your investment.</p> <p>This spectrum of knowledge and our commitment to serving our clientele and fellow real estate associates with the highest level of integrity has made us the premier independent brokerage in the Metropolitan Washington area.</p> <p>Donna Evers and the agents of Evers & Co. invite you to join our growing community of buyers and sellers, who have been the source of 90% of our business for the past thirty years.</p>
        • communitiesBethesda Chevy Chase Village Town of Chevy Chase Somerset Edgemoor Kenwood Kenwood Park Burning Tree Avenel Silver Spring
        • websitehttp://www.eversco.com/
        • address7032 Wisconsin Avenue
        • address_2
        • cityChevy Chase
        • stateMD
        • full_stateMaryland
        • countryUSA
        • marketChevy Chase
        • market_2
        • postal_code20815
        • phoneOffice: (301) 656-1800
        • phone_2Cell: (202) 255-5009
        • phone_3
        • wide_contact_image(false)
        • contact_nameDonna Evers
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titlePresident & Founder
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename81.jpg
        • logo_filename81.jpg
        • contact_image_filename81.jpg
        • all_properties_link_image_filename81.JPG
        • all_properties_linkhttp://eversco.idxre.com/featured/40484?CFID=10711248&CFTOKEN=99152164
        • video_embed_code
        • contact_video_embed_code
        • meta_titleChevy Chase Real Estate | Evers & Co. Real Estate | Leverage Global Partners
        • meta_descriptionEvers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Bethesda, Chevy Chase Village, Town of Chevy Chase, Somerset, Edgemoor, Kenwood, Kenwood Park, Burning Tree, Avenel, and Silver Spring, MD.
        • meta_keywordsChevy Chase Real Estate, Evers & Co. Real Estate, Leverage Global Partners, Bethesda real estate, Chevy Chase Village real estate, Town of Chevy Chase real estate, Somerset real estate, Edgemoor real estate, Kenwood real estate, Kenwood Park real estate, Burning Tree real estate, Avenel real estate, and Silver Spring real estate, MD.
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2014-01-10 16:43:02
        • modified2016-04-08 16:34:01
        • dre_num012345
        • uri/brokerage-detail/81/evers-co-real-estate
        • website_shortwww.eversco.com
        • name_with_locationEvers & Co. 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)
          • id12970
          • modelProperty
          • model_id3704
          • tagImage
          • name36008.jpg
          • typeimage/jpg
          • size1341879
          • uri/assets/12970.jpg
          • order0
          • created2016-04-07 16:36:06
          • modified2016-04-07 16:36:06
      • User(array)
        • 0(array)
          • id373
          • typeAgent
          • brokerage_id81
          • email[email protected]
          • passwordb55b12a59c129a72a8f1b8e192578b4ea7cdc2a3
          • recover_hash
          • first_nameEric
          • last_nameMurtagh
          • title
          • dre_num
          • phone301-412-9066
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2017-08-07 15:22:49
          • created2017-08-07 15:22:49
          • notified(false)
          • full_nameEric Murtagh
          • uri/agent-detail/373/eric-murtagh
          • profile_complete(true)
          • UsersProperty(array)
            • id169
            • user_id373
            • property_id3704
            • sort_order0
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(empty)
      • Topic(empty)
  • sidebar_articles(array)
    • 0(array)
      • Article(array)
        • id445
        • modelLocation
        • model_id76
        • archived(false)
        • medium_featured(true)
        • large_featured(false)
        • titleLocation: Dallas
        • authorLeverageRE
        • date2016-03-24
        • lead_inEverything’s bigger in Texas! Home of Leverage Partner Nathan Grace Real Estate, Dallas is a hub for technology, cattle, oil and telecom, making it a dynamic metropolis. A culinary utopia, Dallas is known for its barbecue, and authentic Mexican/Tex-Mex cuisine; with more restaurants per capita than New York City, everyone can find something to please their palate!
        • body<p>In addition to being a culinary destination, Dallas is home to six major league sports teams: the Dallas Cowboys, the Dallas Mavericks, Texas Rangers, Dallas Stars, FC Dallas and the Dallas Wings. After you finishing eating and enjoying the game, make your way downtown to the largest urban arts district in the United States, where you will discover a wide variety of artwork reflecting the city’s culture.  Here are a few more reasons to love this energetic city:</p> <p><strong>NOSH.</strong>  <a href="http://www.casarubiadallas.com/" target="_blank"><strong>Casa</strong> <strong>Rubia</strong></a> at Trinity Groves was awarded a James Beard nod as one of the country’s best new restaurants; it’s the go-to for modern tapas and paellas.</p> <p><img class="aligncenter size-full wp-image-12874 pure-img" src="/assets/3101.png" /></p> <p><strong>NES</strong><strong>T.</strong>  In the Dallas Design District, <a href="http://www.ceylonetcie.com/" target="_blank"><strong>Ceylon</strong> <strong>et</strong> <strong>Cie</strong></a> is a design trove filled with eclectic finds from around the world.</p> <p><strong>W</strong><strong>ALK.</strong>  While White Rock Lake is across the street from Mount Vernon's gates, many stroll seekers like the <a href="http://www.dallasparks.org/downloads/trails/katy.pdf" target="_blank"><strong>Katy</strong> <strong>Trail</strong></a>, a jogging and bicycle path that follows the old Missouri-Kansas-Texas Railroad.</p> <p><img class="aligncenter size-full wp-image-12873 pure-img" src="/assets/3102.png" /></p> <p><strong>DRESS.</strong>  <a href="http://www.vodboutique.com/" target="_blank"><strong>V.O.D.</strong></a> is what you get when a former fashion journalist and seasoned women's buyer open a boutique. Jackie Bolin and Liz Thompson bring hard-to-find lines and exquisite vintage pieces to Dallas's Victory Park location.</p> <p><strong>VIEW. </strong> <a href="http://www.perotmuseum.org/" target="_blank"><strong>The</strong> <strong>Perot</strong> <strong>Museum</strong> <strong>of</strong> <strong>Nature and Science</strong></a> opened to much fanfare last year. Designed by Pritzker Architecture Prize Laureate Thom Mayne, the 180,000-square-foot facility received the highest possible Green Globes rating for its sustainable design.</p> <p><img class="aligncenter size-full wp-image-12872 pure-img" src="/assets/3103.png" /></p> <p> </p>
        • vimeo_id
        • created2016-04-05 14:30:29
        • modified2016-04-14 11:25:05
        • uri/articles/view/445/location-dallas
        • flattened_topics(array)
          • 0Voice from the Street
          • 1Urban Life
      • ParentBrokerage(array)
        • id(null)
        • account_executive_id(null)
        • archived(null)
        • type(null)
        • hide_from_frontend(null)
        • agent_brokerage_data_override(null)
        • featured_development(null)
        • membership_type(null)
        • max_properties(null)
        • max_homepage_featured_by_member_properties(null)
        • featured_properties_sort_method(null)
        • lux_feed_mode(null)
        • max_luxury_feed_properties(null)
        • membership_luxury_feed_properties(null)
        • can_participate_in_lux_feed_while_archived(null)
        • full_training_video_access(null)
        • country_id(null)
        • WOEID(null)
        • timezone(null)
        • luxury_feed_enrollment_mode(null)
        • luxury_feed_include_mlsidx_minimum_price(null)
        • luxury_feed_include_leverage_minimum_price(null)
        • digital_ad_contacts(null)
        • add_agents_to_grr_auto_recipients(null)
        • mlsidx_id(null)
        • mlsidx_lux_autofeed(null)
        • mlsidx_lux_autofeed_minimum_price(null)
        • mlsidx_logo_url(null)
        • mlsidx_disclaimer(null)
        • name(null)
        • broker_of_record_name(null)
        • short_name(null)
        • username(null)
        • password(null)
        • password_reset_hash(null)
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename(null)
        • active(null)
        • lead_in(null)
        • short_description(null)
        • description(null)
        • communities(null)
        • website(null)
        • address(null)
        • address_2(null)
        • city(null)
        • state(null)
        • full_state(null)
        • country(null)
        • market(null)
        • market_2(null)
        • postal_code(null)
        • phone(null)
        • phone_2(null)
        • phone_3(null)
        • wide_contact_image(null)
        • contact_name(null)
        • contact_profile_link(null)
        • contact_big_profile_link(null)
        • contact_big_profile_link_text(null)
        • contact_title(null)
        • contact_dre_num(null)
        • contact_quote(null)
        • contact_email(null)
        • contact_facebook(null)
        • contact_twitter(null)
        • contact_instagram(null)
        • contact_pinterest(null)
        • contact_linkedin(null)
        • contact_youtube(null)
        • contact_phone(null)
        • contact_email_2(null)
        • contact_2_facebook(null)
        • contact_2_twitter(null)
        • contact_2_instagram(null)
        • contact_2_pinterest(null)
        • contact_2_linkedin(null)
        • contact_2_youtube(null)
        • contact_phone_2(null)
        • contact_website(null)
        • contact_name_2(null)
        • contact_profile_link_2(null)
        • contact_big_profile_link_2(null)
        • contact_big_profile_link_text_2(null)
        • contact_title_2(null)
        • contact_dre_num_2(null)
        • contact_email_3(null)
        • contact_name_3(null)
        • contact_title_3(null)
        • contact_dre_num_3(null)
        • contact_phone_3(null)
        • contact_3_facebook(null)
        • contact_3_twitter(null)
        • contact_3_instagram(null)
        • contact_3_pinterest(null)
        • contact_3_linkedin(null)
        • contact_3_youtube(null)
        • image_filename(null)
        • logo_filename(null)
        • contact_image_filename(null)
        • all_properties_link_image_filename(null)
        • all_properties_link(null)
        • video_embed_code(null)
        • contact_video_embed_code(null)
        • meta_title(null)
        • meta_description(null)
        • meta_keywords(null)
        • login_message_counter(null)
        • stats_module_1_type(null)
        • stats_module_1_value(null)
        • stats_module_2_type(null)
        • stats_module_2_value(null)
        • stats_module_3_type(null)
        • stats_module_3_value(null)
        • last_activity_email_sent(null)
        • converted(null)
        • created(null)
        • modified(null)
        • dre_num(null)
        • name_with_location
      • ParentLocation(array)
        • id76
        • parent_id8
        • brokerage_id236
        • typeExclusive
        • archived(false)
        • use_as_topic(false)
        • nameDallas, TX, USA
        • short_nameDallas, TX, USA
        • group_index
        • latitude37.090240
        • longitude-95.712891
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_descriptionBigger and Better than you can ever imagine…Dallas!
        • long_descriptionLocated in North Texas, Dallas is the hub of the largest metropolitan area in the South and the largest inland metropolitan area in the US. Dallas is made up of many unique and amazing districts and neighborhoods that each have their own personality, architectural styles, sports, arts, education, shopping and dining. From the Bishop Arts District to Deep Ellum to East Dallas to Uptown / Oaklawn to Park Cities to Far North Dallas, everyone will find something they love.
        • created2016-04-05 09:15:45
        • modified2016-04-05 09:15:45
        • timezone
        • population1258000
        • uri/locations/view/76/dallas-tx-usa
        • tile_nameDallas, TX, USA
      • Image(array)
        • 0(array)
          • id20813
          • modelArticle
          • model_id445
          • tagImage
          • nameDallas.jpg
          • typeimage/jpeg
          • size1669741
          • uri/assets/20813.jpg
          • order0
          • created2016-04-14 11:25:00
          • modified2016-04-14 11:25:05
      • Brokerage(array)
        • 0(array)
          • id236
          • account_executive_id236
          • archived(false)
          • typebrokerage
          • hide_from_frontend(false)
          • agent_brokerage_data_override(false)
          • featured_development(false)
          • membership_typeBasic
          • max_properties8
          • max_homepage_featured_by_member_properties0
          • featured_properties_sort_methodmanual
          • lux_feed_modeStripeSubscription
          • max_luxury_feed_properties0
          • membership_luxury_feed_properties0
          • can_participate_in_lux_feed_while_archived(false)
          • full_training_video_access(true)
          • country_id0
          • WOEID2473475
          • timezoneUS/Central
          • 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
          • nameNathan Grace Real Estate
          • broker_of_record_name
          • short_nameNathan Grace Real Estate
          • usernameNathanGraceREcollin
          • passwordd651c364db6b22a62aead6006aa3c4dc078158e9
          • password_reset_hash
          • monthly_invoice_amount(null)
          • monthly_invoice_start_date(null)
          • monthly_invoice_end_date(null)
          • contract_filename
          • active(true)
          • lead_in
          • short_description
          • description<p>Nathan Grace Real Estate is the exclusive representative for Leverage Global Partners in Collin County, representing Frisco, Plano, McKinney, Allen, Prosper and the surrounding communities.</p> <p>We are also the exclusive representative for Leverage Global Partners in <a href="../../../brokerage-detail/235/Nathan-Grace-Real-Estate" target="_blank">Dallas</a>.</p> <p>Nathan Grace Real Estate is a boutique real estate company dedicated to the client, community and industry. As a business and as individuals we strive to act with integrity and personal excellence in all we do. Our core values inspire our actions and decisions. We live these values every day:</p> <p>Inspire Trust, Act Responsibly, Embrace Diversity, Pursue Growth and Learning, Support Our Communities, Communicate with Honesty, Participate in Forward Thinking and Celebrate the Fun in Life.</p> <p>Nathan Grace is committed to giving back to the communities and industry we serve. As an organization and as individuals we donate time, material goods and money to a variety of organizations.</p>
          • communitiesCollin County Dallas Dallas County Plano Frisco McKinney Allen Prosper
          • websitehttp://www.nathangracerealestate.com/
          • address6225 Frisco Square Blvd Suite 100
          • address_2
          • cityFrisco
          • stateTX
          • full_stateTexas
          • countryUSA
          • marketCollin County
          • market_2
          • postal_code75034
          • phoneCell: (972) 670-3437
          • phone_2Office: (214) 765-0601
          • phone_3
          • wide_contact_image(false)
          • contact_nameVickie Parker
          • contact_profile_link
          • contact_big_profile_link
          • contact_big_profile_link_text
          • contact_titlePresident
          • contact_dre_num
          • contact_quoteWe invite you to contact us personally about Collin County real estate!
          • contact_email[email protected]
          • contact_facebook
          • contact_twitter
          • contact_instagram
          • contact_pinterest
          • contact_linkedin
          • contact_youtube
          • contact_phone
          • contact_email_2
          • contact_2_facebook
          • contact_2_twitter
          • contact_2_instagram
          • contact_2_pinterest
          • contact_2_linkedin
          • contact_2_youtube
          • contact_phone_2
          • contact_website
          • contact_name_2
          • contact_profile_link_2
          • contact_big_profile_link_2
          • contact_big_profile_link_text_2
          • contact_title_2
          • contact_dre_num_2
          • contact_email_3
          • contact_name_3
          • contact_title_3
          • contact_dre_num_3
          • contact_phone_3
          • contact_3_facebook
          • contact_3_twitter
          • contact_3_instagram
          • contact_3_pinterest
          • contact_3_linkedin
          • contact_3_youtube
          • image_filename236.jpg
          • logo_filename236.jpg
          • contact_image_filename236.jpg
          • all_properties_link_image_filename236.jpg
          • all_properties_linkhttp://www.nathangracerealestate.com/pages/nathangrace-content/Featured_listings/
          • video_embed_code
          • contact_video_embed_code
          • meta_titleCollin County Real Estate | Nathan Grace Real Estate | Leverage Global Partners
          • meta_descriptionNathan Grace Real Estate is the exclusive representative for Leverage Global Partners in Collin County, representing Frisco, Plano, McKinney, Allen, Prosper and the surrounding communities.
          • meta_keywordsNathan Grace Real Estate, Leverage Global Partners, Plano Real Estate, Collin County real estate, Texas Real Estate, Frisco Real Estate, McKinney Real Estate, Allen Real Estate, Prosper Real Estate
          • login_message_counter2
          • stats_module_1_type
          • stats_module_1_value
          • stats_module_2_type
          • stats_module_2_value
          • stats_module_3_type
          • stats_module_3_value
          • last_activity_email_sent0000-00-00 00:00:00
          • converted(true)
          • created2015-11-23 10:57:24
          • modified2016-04-08 16:34:31
          • dre_num012345
          • uri/brokerage-detail/236/nathan-grace-real-estate
          • website_shortwww.nathangracerealestate.com
          • name_with_locationNathan Grace Real Estate
          • ArticlesBrokerage(array)
            • id81
            • article_id445
            • brokerage_id236
      • Location(array)
        • 0(array)
          • id76
          • parent_id8
          • brokerage_id236
          • typeExclusive
          • archived(false)
          • use_as_topic(false)
          • nameDallas, TX, USA
          • short_nameDallas, TX, USA
          • group_index
          • latitude37.090240
          • longitude-95.712891
          • country_code
          • north53.700001
          • south19.700001
          • east-52.599998
          • west-146.600006
          • zoom0
          • short_descriptionBigger and Better than you can ever imagine…Dallas!
          • long_descriptionLocated in North Texas, Dallas is the hub of the largest metropolitan area in the South and the largest inland metropolitan area in the US. Dallas is made up of many unique and amazing districts and neighborhoods that each have their own personality, architectural styles, sports, arts, education, shopping and dining. From the Bishop Arts District to Deep Ellum to East Dallas to Uptown / Oaklawn to Park Cities to Far North Dallas, everyone will find something they love.
          • created2016-04-05 09:15:45
          • modified2016-04-05 09:15:45
          • timezone
          • population1258000
          • uri/locations/view/76/dallas-tx-usa
          • tile_nameDallas, TX, USA
          • ArticlesLocation(array)
            • id57
            • article_id445
            • location_id76
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id24
          • nameVoice from the Street
          • created2016-02-25 11:38:06
          • modified2016-02-25 11:38:06
          • tile_nameVoice from the Street
          • ArticlesTopic(array)
            • id433
            • article_id445
            • topic_id24
        • 1(array)
          • id5
          • nameUrban Life
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:36:03
          • tile_nameUrban Life
          • ArticlesTopic(array)
            • id432
            • article_id445
            • topic_id5
    • 1(array)
      • Article(array)
        • id478
        • modelLocation
        • model_id92
        • archived(false)
        • medium_featured(false)
        • large_featured(true)
        • titleLocation: Maui
        • authorLeverageRE
        • date2016-03-29
        • lead_inRemarkable beaches, magnificent waterfalls and breathtaking views, Maui radiates natural beauty. Settled between two mountains, Maui is referred to as the “Valley Isle,” and is the second largest Hawaiian island and home to Leverage Partner The Wailea Group.
        • body<p>It is also home to more than 80 beaches, exhibiting black, white or red sand along its 120 miles of shoreline. Grab your camera and take one of the most scenic drives in the world on the Road to Hana, with over 60 curves and 54 bridges. In the mood for dining or shopping? Then Lahaina, once a thriving whaling port in the mid 1800’s, is the destination for you. Snorkeling, surfing, kiteboarding, and even whale watching are among the many activities to experience on Maui. Countless activities to be had on a little piece of paradise:</p> <p><img class="aligncenter wp-image-12905 pure-img" src="/assets/3294.png" /></p> <p><strong>REJUVENATE. </strong> Get pampered at the new Andaz Maui at Wailea's <a href="http://maui.andaz.hyatt.com/hyatt/pure/spas/" target="_blank">‘Awili Spa and Salon</a> with treatments featuring custom-blended products from the apothecary bar.</p> <p><img class="aligncenter wp-image-12900 pure-img" src="/assets/3295.png" /></p> <p><strong>SWING</strong>.  Soak up the ocean views on the rugged terrain of the <a href="http://www.waileagolf.com/index.php?linksid=4" target="_blank">Wailea Golf Club's Gold Course</a> or the more player-friendly <a href="http://www.waileagolf.com/index.php?linksid=13" target="_blank">Emerald Course</a>.</p> <p><img class="aligncenter wp-image-12902 pure-img" src="/assets/3296.png" /></p> <p><strong>DINE.</strong>  Tap into the island's Polynesian roots with a visit to the famed <a href="http://www.mamasfishhouse.com/" target="_blank">Mama's Fish House</a> restaurant,a local legend since 1973. Savor traditional fresh fare caught by local fi  against the backdrop of a secluded white-sand beach.</p> <p><strong>DRESS.</strong>  The <a href="http://www.fourseasons.com/maui/services_and_amenities/other_facilities_and_services/shopping_boutiques/" target="_blank">Four Seasons Resort Maui at Wailea</a> has earned its stripes not only as one of the island's premiere hotels, but as a shopping destination, too. Overseen by retail experts Seaside Luxe, three distinct boutiques on the property offer everything from branded resort wear to designer apparel from Tory Burch and Stella McCartney.</p> <p><img class="aligncenter wp-image-12901 pure-img" src="/assets/3297.png" /></p> <p><strong>SPLASH.</strong>  With locations in Kihei and Lahaina, the pros at <a href="http://www.mauiwaveriders.com/" target="_blank">Maui Wave Riders</a> school have aspiring surfers and stand-up paddlers covered.</p> <p><img class="aligncenter wp-image-12906 pure-img" src="/assets/3298.png" /></p>
        • vimeo_id
        • created2016-04-05 14:34:57
        • modified2016-04-14 12:19:38
        • uri/articles/view/478/location-maui
        • flattened_topics(array)
          • 0Voice from the Street
          • 1Travel
          • 2Beach
      • ParentBrokerage(array)
        • id(null)
        • account_executive_id(null)
        • archived(null)
        • type(null)
        • hide_from_frontend(null)
        • agent_brokerage_data_override(null)
        • featured_development(null)
        • membership_type(null)
        • max_properties(null)
        • max_homepage_featured_by_member_properties(null)
        • featured_properties_sort_method(null)
        • lux_feed_mode(null)
        • max_luxury_feed_properties(null)
        • membership_luxury_feed_properties(null)
        • can_participate_in_lux_feed_while_archived(null)
        • full_training_video_access(null)
        • country_id(null)
        • WOEID(null)
        • timezone(null)
        • luxury_feed_enrollment_mode(null)
        • luxury_feed_include_mlsidx_minimum_price(null)
        • luxury_feed_include_leverage_minimum_price(null)
        • digital_ad_contacts(null)
        • add_agents_to_grr_auto_recipients(null)
        • mlsidx_id(null)
        • mlsidx_lux_autofeed(null)
        • mlsidx_lux_autofeed_minimum_price(null)
        • mlsidx_logo_url(null)
        • mlsidx_disclaimer(null)
        • name(null)
        • broker_of_record_name(null)
        • short_name(null)
        • username(null)
        • password(null)
        • password_reset_hash(null)
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename(null)
        • active(null)
        • lead_in(null)
        • short_description(null)
        • description(null)
        • communities(null)
        • website(null)
        • address(null)
        • address_2(null)
        • city(null)
        • state(null)
        • full_state(null)
        • country(null)
        • market(null)
        • market_2(null)
        • postal_code(null)
        • phone(null)
        • phone_2(null)
        • phone_3(null)
        • wide_contact_image(null)
        • contact_name(null)
        • contact_profile_link(null)
        • contact_big_profile_link(null)
        • contact_big_profile_link_text(null)
        • contact_title(null)
        • contact_dre_num(null)
        • contact_quote(null)
        • contact_email(null)
        • contact_facebook(null)
        • contact_twitter(null)
        • contact_instagram(null)
        • contact_pinterest(null)
        • contact_linkedin(null)
        • contact_youtube(null)
        • contact_phone(null)
        • contact_email_2(null)
        • contact_2_facebook(null)
        • contact_2_twitter(null)
        • contact_2_instagram(null)
        • contact_2_pinterest(null)
        • contact_2_linkedin(null)
        • contact_2_youtube(null)
        • contact_phone_2(null)
        • contact_website(null)
        • contact_name_2(null)
        • contact_profile_link_2(null)
        • contact_big_profile_link_2(null)
        • contact_big_profile_link_text_2(null)
        • contact_title_2(null)
        • contact_dre_num_2(null)
        • contact_email_3(null)
        • contact_name_3(null)
        • contact_title_3(null)
        • contact_dre_num_3(null)
        • contact_phone_3(null)
        • contact_3_facebook(null)
        • contact_3_twitter(null)
        • contact_3_instagram(null)
        • contact_3_pinterest(null)
        • contact_3_linkedin(null)
        • contact_3_youtube(null)
        • image_filename(null)
        • logo_filename(null)
        • contact_image_filename(null)
        • all_properties_link_image_filename(null)
        • all_properties_link(null)
        • video_embed_code(null)
        • contact_video_embed_code(null)
        • meta_title(null)
        • meta_description(null)
        • meta_keywords(null)
        • login_message_counter(null)
        • stats_module_1_type(null)
        • stats_module_1_value(null)
        • stats_module_2_type(null)
        • stats_module_2_value(null)
        • stats_module_3_type(null)
        • stats_module_3_value(null)
        • last_activity_email_sent(null)
        • converted(null)
        • created(null)
        • modified(null)
        • dre_num(null)
        • name_with_location
      • ParentLocation(array)
        • id92
        • parent_id9
        • brokerage_id62
        • typeExclusive
        • archived(false)
        • use_as_topic(false)
        • nameMaui, HI, USA
        • short_nameMaui, HI, USA
        • group_index
        • latitude20.798363
        • longitude-156.331924
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_description
        • long_descriptionMore information coming soon!
        • created2016-04-05 11:22:53
        • modified2016-04-05 11:22:53
        • timezonePacific/Honolulu
        • population145000
        • uri/locations/view/92/maui-hi-usa
        • tile_nameMaui, HI, USA
      • Image(array)
        • 0(array)
          • id3299
          • modelArticle
          • model_id478
          • tagImage
          • nameScreen-Shot-2016-03-28-at-7.16.19-PM.png
          • typeimage/png
          • size1869697
          • uri/assets/3299.png
          • order0
          • created2016-04-05 14:34:58
          • modified2016-04-14 12:19:38
      • Brokerage(array)
        • 0(array)
          • id62
          • account_executive_id236
          • archived(false)
          • typebrokerage
          • hide_from_frontend(false)
          • agent_brokerage_data_override(false)
          • featured_development(false)
          • membership_typePremium
          • max_properties8
          • max_homepage_featured_by_member_properties0
          • featured_properties_sort_methodmanual
          • lux_feed_modeStripeSubscription
          • max_luxury_feed_properties-1
          • membership_luxury_feed_properties0
          • can_participate_in_lux_feed_while_archived(false)
          • full_training_video_access(false)
          • country_id1
          • WOEID12588033
          • timezoneUS/Hawaii
          • 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
          • nameThe Wailea Group
          • broker_of_record_name
          • short_nameThe Wailea Group
          • usernameWaileaGroup
          • password96cbf310f1191af607d1a68cb3d3240778537715
          • password_reset_hash
          • monthly_invoice_amount(null)
          • monthly_invoice_start_date0000-00-00
          • monthly_invoice_end_date0000-00-00
          • contract_filename
          • active(true)
          • lead_in
          • short_description
          • description<p>The Wailea Group is the exclusive representative for Leverage Global Partners in Maui, Lanai, and Moloka'i, Hawaii, USA.</p> <p>The Wailea Group is a collaboration of sales and marketing professionals with deep respect for Wailea-Makena’s past, present and future. Wailea-Makena will continue to grow, this is a certainty. But equally certain is the control of that growth ensuring an unparalleled quality of life on Maui. We have already exclusively represented new development projects valued at over $2 billion, a tribute to the vision and integrity of our founders and our unique marketing insights and strategies. Wailea Beach Villas, Ho’olei and Papali were all represented by us and we’re now exclusively representing the Andaz. Our inventory of existing homes and condos and our knowledge of future development make us not only the logical choice among buyers and sellers but also the smart choice.</p> <p><a href="http://www.leveragere.com/project-detail/24/Makali'i-at-Wailea,-Maui,-Hawaii" target="_blank">Visit Makali’i at Wailea</a></p>
          • communitiesMaui Lanai Moloka'i
          • websitehttp://www.thewaileagroup.com/HomeMain.aspx
          • address3750 Wailea Alanui
          • address_2Suite 5EW
          • cityWailea
          • stateHI
          • full_stateHawaii
          • countryUSA
          • marketMaui
          • market_2
          • postal_code96753
          • phoneMain: (808) 875-6911
          • phone_2
          • phone_3
          • wide_contact_image(false)
          • contact_nameScott Nelson
          • contact_profile_link
          • contact_big_profile_link
          • contact_big_profile_link_text
          • contact_titlePrincipal Broker
          • contact_dre_num
          • contact_quote
          • contact_email[email protected]
          • contact_facebook
          • contact_twitter
          • contact_instagram
          • contact_pinterest
          • contact_linkedin
          • contact_youtube
          • contact_phone
          • contact_email_2
          • contact_2_facebook
          • contact_2_twitter
          • contact_2_instagram
          • contact_2_pinterest
          • contact_2_linkedin
          • contact_2_youtube
          • contact_phone_2
          • contact_website
          • contact_name_2
          • contact_profile_link_2
          • contact_big_profile_link_2
          • contact_big_profile_link_text_2
          • contact_title_2
          • contact_dre_num_2
          • contact_email_3
          • contact_name_3
          • contact_title_3
          • contact_dre_num_3
          • contact_phone_3
          • contact_3_facebook
          • contact_3_twitter
          • contact_3_instagram
          • contact_3_pinterest
          • contact_3_linkedin
          • contact_3_youtube
          • image_filename62.jpg
          • logo_filename62.gif
          • contact_image_filename62.jpg
          • all_properties_link_image_filename62.jpg
          • all_properties_linkhttp://www.thewaileagroup.com/Exclusive.aspx
          • video_embed_code
          • contact_video_embed_code
          • meta_titleMaui Real Estate | The Wailea Group | Leverage Global Partners
          • meta_descriptionThe Wailea Group is the exclusive representative for Leverage Global Partners in Maui, HI, USA.
          • meta_keywordsThe Wailea Group, maui real estate, hawaii real estate, rene sand, leverage global partners
          • 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)
          • created2013-10-09 12:08:12
          • modified2016-04-08 16:33:30
          • dre_num012345
          • uri/brokerage-detail/62/the-wailea-group
          • website_shortwww.thewaileagroup.com/HomeMain.aspx
          • name_with_locationThe Wailea Group
          • ArticlesBrokerage(array)
            • id83
            • article_id478
            • brokerage_id62
      • Location(array)
        • 0(array)
          • id92
          • parent_id9
          • brokerage_id62
          • typeExclusive
          • archived(false)
          • use_as_topic(false)
          • nameMaui, HI, USA
          • short_nameMaui, HI, USA
          • group_index
          • latitude20.798363
          • longitude-156.331924
          • country_code
          • north53.700001
          • south19.700001
          • east-52.599998
          • west-146.600006
          • zoom0
          • short_description
          • long_descriptionMore information coming soon!
          • created2016-04-05 11:22:53
          • modified2016-04-05 11:22:53
          • timezonePacific/Honolulu
          • population145000
          • uri/locations/view/92/maui-hi-usa
          • tile_nameMaui, HI, USA
          • ArticlesLocation(array)
            • id59
            • article_id478
            • location_id92
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id24
          • nameVoice from the Street
          • created2016-02-25 11:38:06
          • modified2016-02-25 11:38:06
          • tile_nameVoice from the Street
          • ArticlesTopic(array)
            • id439
            • article_id478
            • topic_id24
        • 1(array)
          • id10
          • nameTravel
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:35:10
          • tile_nameTravel
          • ArticlesTopic(array)
            • id438
            • article_id478
            • topic_id10
        • 2(array)
          • id8
          • nameBeach
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:30:26
          • tile_nameBeach
          • ArticlesTopic(array)
            • id437
            • article_id478
            • topic_id8
    • 2(array)
      • Article(array)
        • id446
        • modelLocation
        • model_id151
        • archived(false)
        • medium_featured(false)
        • large_featured(true)
        • titleLocation: Manhattan
        • authorLeverageRE
        • date2016-03-24
        • lead_inMade up of five boroughs, New York City has a population of 8.1 million people, making it the largest city in the United States. Often called "the city," Manhattan is the most densely populated borough, and on business days, the population reaches a whopping 5.28 million people. It is home to the financial capital of the world with the NASDAQ, New York Stock Exchange and United Nations.
        • body<p>A major benefit to living in "the city" is having access to virtually everything at any hour of the day. With attractions from dining and drinking to theater shows and live music, Manhattan is at the center of the action in New York City.</p> <p><strong>WALK.</strong>  <a href="http://www.madisonsquarepark.org/" target="_blank">Madison Square Park,</a> landscaped by Ignatz Pilat, a disciple of William Grant and Frederick Law Olmstead, offers people-watching benches, shady strolls through verdant plantings, a dog run, and elegant public monuments.</p> <p><img class="aligncenter wp-image-12804 pure-img" src="/assets/3105.png" /></p> <p><strong>DRESS.  </strong>Ann Taylor, Armani Exchange, Kate Spade, Club Monaco, and many more are only steps away.</p> <p><strong>EAT.  </strong>The Flatiron District is the epicenter of Danny Meyer's restaurant empire, with one of his eateries just a short walk in almost any direction: <a href="http://www.maialinonyc.com/" target="_blank">Maialino</a> (Italian), <a href="http://www.bluesmoke.com/" target="_blank">Blue Smoke</a> (BBQ and jazz), <a href="http://www.gramercytavern.com/" target="_blank">Gramercy Tavern</a> (classic American), <a href="http://unionsquarecafe.com/" target="_blank">Union Square Caf</a><a href="http://unionsquarecafe.com/">é</a> (American-Italian), or <a href="http://www.shakeshack.com/" target="_blank">Shake Shack</a> (burger-and- shake stand).</p> <p><img class="aligncenter wp-image-12806 pure-img" src="/assets/3106.png" /></p> <p><strong>INDULGE.  </strong><a href="http://eisenbergsnyc.com/" target="_blank">Eisenberg's Sandwich Shop</a> has been "raising New York's cholesterol since 1929" with its old-fashioned tuna melts, diner breakfasts, and Jewish classics like pastrami Rueben’s and tongue-on-rye.</p> <p><strong>NEST.  </strong>You're a stone's throw from <a href="http://www.restorationhardware.com/" target="_blank">Restoration Hardware</a>, <a href="http://www.boconcept.com/en-us/" target="_blank">BoConcept</a>, <a href="https://www.abchome.com/" target="_blank">ABC Carpet & Home</a>, <a href="http://www.lillianaugust.com/locations#nyc" target="_blank">Lillian August</a>, and other design shrines.</p> <p><img class="aligncenter wp-image-12803 pure-img" src="/assets/3107.png" /></p>
        • vimeo_id
        • created2016-04-05 14:30:39
        • modified2016-04-14 10:47:35
        • uri/articles/view/446/location-manhattan
        • flattened_topics(array)
          • 0Voice from the Street
          • 1Urban Life
      • ParentBrokerage(array)
        • id(null)
        • account_executive_id(null)
        • archived(null)
        • type(null)
        • hide_from_frontend(null)
        • agent_brokerage_data_override(null)
        • featured_development(null)
        • membership_type(null)
        • max_properties(null)
        • max_homepage_featured_by_member_properties(null)
        • featured_properties_sort_method(null)
        • lux_feed_mode(null)
        • max_luxury_feed_properties(null)
        • membership_luxury_feed_properties(null)
        • can_participate_in_lux_feed_while_archived(null)
        • full_training_video_access(null)
        • country_id(null)
        • WOEID(null)
        • timezone(null)
        • luxury_feed_enrollment_mode(null)
        • luxury_feed_include_mlsidx_minimum_price(null)
        • luxury_feed_include_leverage_minimum_price(null)
        • digital_ad_contacts(null)
        • add_agents_to_grr_auto_recipients(null)
        • mlsidx_id(null)
        • mlsidx_lux_autofeed(null)
        • mlsidx_lux_autofeed_minimum_price(null)
        • mlsidx_logo_url(null)
        • mlsidx_disclaimer(null)
        • name(null)
        • broker_of_record_name(null)
        • short_name(null)
        • username(null)
        • password(null)
        • password_reset_hash(null)
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename(null)
        • active(null)
        • lead_in(null)
        • short_description(null)
        • description(null)
        • communities(null)
        • website(null)
        • address(null)
        • address_2(null)
        • city(null)
        • state(null)
        • full_state(null)
        • country(null)
        • market(null)
        • market_2(null)
        • postal_code(null)
        • phone(null)
        • phone_2(null)
        • phone_3(null)
        • wide_contact_image(null)
        • contact_name(null)
        • contact_profile_link(null)
        • contact_big_profile_link(null)
        • contact_big_profile_link_text(null)
        • contact_title(null)
        • contact_dre_num(null)
        • contact_quote(null)
        • contact_email(null)
        • contact_facebook(null)
        • contact_twitter(null)
        • contact_instagram(null)
        • contact_pinterest(null)
        • contact_linkedin(null)
        • contact_youtube(null)
        • contact_phone(null)
        • contact_email_2(null)
        • contact_2_facebook(null)
        • contact_2_twitter(null)
        • contact_2_instagram(null)
        • contact_2_pinterest(null)
        • contact_2_linkedin(null)
        • contact_2_youtube(null)
        • contact_phone_2(null)
        • contact_website(null)
        • contact_name_2(null)
        • contact_profile_link_2(null)
        • contact_big_profile_link_2(null)
        • contact_big_profile_link_text_2(null)
        • contact_title_2(null)
        • contact_dre_num_2(null)
        • contact_email_3(null)
        • contact_name_3(null)
        • contact_title_3(null)
        • contact_dre_num_3(null)
        • contact_phone_3(null)
        • contact_3_facebook(null)
        • contact_3_twitter(null)
        • contact_3_instagram(null)
        • contact_3_pinterest(null)
        • contact_3_linkedin(null)
        • contact_3_youtube(null)
        • image_filename(null)
        • logo_filename(null)
        • contact_image_filename(null)
        • all_properties_link_image_filename(null)
        • all_properties_link(null)
        • video_embed_code(null)
        • contact_video_embed_code(null)
        • meta_title(null)
        • meta_description(null)
        • meta_keywords(null)
        • login_message_counter(null)
        • stats_module_1_type(null)
        • stats_module_1_value(null)
        • stats_module_2_type(null)
        • stats_module_2_value(null)
        • stats_module_3_type(null)
        • stats_module_3_value(null)
        • last_activity_email_sent(null)
        • converted(null)
        • created(null)
        • modified(null)
        • dre_num(null)
        • name_with_location
      • ParentLocation(array)
        • id151
        • parent_id7
        • brokerage_id0
        • typeOrganizational
        • archived(false)
        • use_as_topic(true)
        • nameManhattan
        • short_nameManhattan
        • group_index
        • latitude40.783058
        • longitude-73.971252
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_description
        • long_description
        • created2016-04-12 11:14:03
        • modified2016-04-14 10:47:50
        • timezoneAmerica/New_York
        • population1644518
        • uri/locations/view/151/manhattan
        • tile_nameManhattan
      • Image(array)
        • 0(array)
          • id3108
          • modelArticle
          • model_id446
          • tagImage
          • nameNYC-2.jpg
          • typeimage/jpg
          • size690658
          • uri/assets/3108.jpg
          • order0
          • created2016-04-05 14:30:40
          • modified2016-04-14 10:47:35
      • Brokerage(array)
        • 0(array)
          • id16
          • account_executive_id235
          • archived(false)
          • typebrokerage
          • hide_from_frontend(false)
          • agent_brokerage_data_override(false)
          • featured_development(false)
          • membership_typePremium
          • max_properties20
          • 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_id1
          • WOEID12589342
          • timezone
          • 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
          • nameCORE
          • broker_of_record_name
          • short_nameCORE
          • usernameCORENYC
          • password6bbc31e8f00594b7e3433f0a9c0cd7334bff73ae
          • password_reset_hash
          • monthly_invoice_amount(null)
          • monthly_invoice_start_date0000-00-00
          • monthly_invoice_end_date0000-00-00
          • contract_filename
          • active(true)
          • lead_in
          • short_description
          • description<p>CORE is the exclusive representative for Leverage Global Partners in New York City, New York, USA.</p> <p>CORE is the leading, full-service, boutique real estate brokerage specializing in the marketing of premiere residential properties. Headquartered in New York City, CORE was founded by CEO Shaun Osher and Jack Cayre, who envisioned a dynamic boutique brokerage based on integrity, informed by expertise and driven by innovation.</p> <p>CORE offers comprehensive real estate solutions for buyers, sellers, landlords, investors and developers. The firm is powered by an integrated team of accomplished professionals with extensive expertise in all aspects of real estate transactions.</p> <p>Thanks to a unique marketing approach, CORE ensures that its clients earn the highest market-driven prices. Our agents educate and shepherd buyers, sellers and landlords through the sales or leasing process. And we partner closely with developers, from the earliest stages of a project through closing; partnerships, which boast a proven, profitable track record. Within the past 8 years, CORE has marketed more than 30 new development properties and is the #1 brokerage in its class.</p>
          • communitiesManhattan Chelsea New York City Tribeca Midtown
          • websitehttp://corenyc.com/
          • address104 Fifth Avenue
          • address_2
          • cityNew York
          • stateNY
          • full_stateNew York
          • countryUSA
          • marketNew York
          • market_2
          • postal_code10011
          • phone(212) 726-0778
          • phone_2
          • phone_3
          • wide_contact_image(false)
          • contact_nameShaun Osher
          • contact_profile_link
          • contact_big_profile_linkhttp://www.leveragere.com/blog/meet-shaun-osher-founder-and-ceo-of-core/
          • contact_big_profile_link_text
          • contact_titleFounder and CEO
          • contact_dre_num
          • contact_quoteI invite you to contact me personally about New York City real estate.
          • contact_email[email protected]
          • contact_facebook
          • contact_twitter
          • contact_instagram
          • contact_pinterest
          • contact_linkedin
          • contact_youtube
          • contact_phone
          • contact_email_2
          • contact_2_facebook
          • contact_2_twitter
          • contact_2_instagram
          • contact_2_pinterest
          • contact_2_linkedin
          • contact_2_youtube
          • contact_phone_2
          • contact_website
          • contact_name_2
          • contact_profile_link_2
          • contact_big_profile_link_2
          • contact_big_profile_link_text_2
          • contact_title_2
          • contact_dre_num_2
          • contact_email_3
          • contact_name_3
          • contact_title_3
          • contact_dre_num_3
          • contact_phone_3
          • contact_3_facebook
          • contact_3_twitter
          • contact_3_instagram
          • contact_3_pinterest
          • contact_3_linkedin
          • contact_3_youtube
          • image_filename16.jpg
          • logo_filename16.jpg
          • contact_image_filename16.jpg
          • all_properties_link_image_filename16.jpg
          • all_properties_linkhttp://corenyc.com/listings
          • video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/cxxGtpBt-qzxAOUo0.js"></script>
          • contact_video_embed_code
          • meta_titleNew York City Real Estate | CORE | Leverage Global Partners
          • meta_descriptionCORE is Leverage Global Partners' exclusive representative in New York City, NY, USA.
          • meta_keywordsnew york city real estate, manhattan real estate, shaun osher, CORE, leverage global partners
          • login_message_counter0
          • stats_module_1_type
          • stats_module_1_value
          • stats_module_2_type
          • stats_module_2_value
          • stats_module_3_type
          • stats_module_3_value
          • last_activity_email_sent0000-00-00 00:00:00
          • converted(true)
          • created2013-04-01 15:35:47
          • modified2019-10-29 20:06:57
          • dre_num012345
          • uri/brokerage-detail/16/core
          • website_shortcorenyc.com
          • name_with_locationCORE
          • ArticlesBrokerage(array)
            • id80
            • article_id446
            • brokerage_id16
      • Location(array)
        • 0(array)
          • id7
          • parent_id1
          • brokerage_id0
          • typeRegion
          • archived(false)
          • use_as_topic(false)
          • nameNortheast
          • short_nameNortheast
          • group_index120
          • latitude42.617790
          • longitude-73.300781
          • country_code
          • north48.111145
          • south38.251553
          • east-64.992577
          • west-81.473045
          • zoom0
          • short_description
          • long_description
          • created2016-03-30 11:09:47
          • modified2016-03-30 11:09:47
          • timezoneAmerica/New_York
          • population0
          • uri/locations/view/7/northeast
          • tile_nameNortheast
          • ArticlesLocation(array)
            • id56
            • article_id446
            • location_id7
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id24
          • nameVoice from the Street
          • created2016-02-25 11:38:06
          • modified2016-02-25 11:38:06
          • tile_nameVoice from the Street
          • ArticlesTopic(array)
            • id431
            • article_id446
            • topic_id24
        • 1(array)
          • id5
          • nameUrban Life
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:36:03
          • tile_nameUrban Life
          • ArticlesTopic(array)
            • id430
            • article_id446
            • topic_id5
    • 3(array)
      • Article(array)
        • id479
        • modelLocation
        • model_id21
        • archived(false)
        • medium_featured(false)
        • large_featured(true)
        • titleLocation: London
        • authorLeverageRE
        • date2016-03-29
        • lead_inLondon Calling! Synonymous with Big Ben, Westminster Abbey, double-decker buses, and the Royal Family, London is undoubtedly the most fascinating city in the United Kingdom. Home of Leverage Partner Beauchamp Estates, London is also the political, economic and cultural capital of England, offering thousands of historical and modern-day attractions.
        • body<p>It is one of the world’s most visited cities, as well as being a global city steeped in arts, entertainment, media, fashion and finance. It boasts some 43 universities, and is culturally diverse, with more than 300 languages spoken in Greater London. The depth and array of what London has to offer is virtually unparalleled anywhere in the world!</p> <p><img src="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-28-at-7.35.29-PM.png" /></p> <p><strong>BA</strong><strong>T.</strong>  The Marylebone Cricket Club was founded in St. John's Wood in 1787, launching England's national sport. There's no better place to learn about wickets and donkey drops than <a href="http://www.lords.org/" target="_blank"><strong>Lord's</strong> <strong>Cricket</strong> <strong>Ground</strong></a>, which has a museum and hosts regular tours.</p> <p><img class="aligncenter wp-image-12911 pure-img" src="/assets/3301.png" /></p> <p><strong>LET</strong> <strong>IT</strong> <strong>BE.</strong>  <a href="http://www.abbeyroad.com/" target="_blank"><strong>Abbey</strong> <strong>Road</strong> <strong>Studios</strong></a> was immortalized by the Beatles, but Paul Robeson recorded there as far back as 1931. Fab Four pilgrims can't tour inside, but they can take a picture at the famous zebra crossing that graced the Beatles album and post it on the live "Crossing Cam," or write their name on the wall in front of the building.</p> <p><strong>PREEN.</strong>  The High Street area is chocka-block with cool boutiques: hip French labels like <a href="http://www.thekooples.com/" target="_blank"><strong>The</strong> <strong>Kooples</strong></a> and prêt-à-porter pioneer <a href="http://www.georges-rech.fr/" target="_blank"><strong>Georges</strong> <strong>Rech</strong></a>, the designer brand retailer <a href="http://www.joseph-fashion.com/" target="_blank"><strong>Joseph</strong></a> and one outpost of Nicky Kinnaird's beauty products empire, <a href="http://www.spacenk.com/" target="_blank"><strong>SpaceNK</strong></a>.</p> <p><img class="aligncenter wp-image-12910 pure-img" src="/assets/3302.png" /></p> <p><strong>STROLL.  </strong>Primrose Hill Park is where the locals hang. Its views of London are un-paralleled, and the bucolic quietude of this green space distills the reason why people live here.</p> <p><img class="aligncenter wp-image-12909 pure-img" src="/assets/3303.png" /></p> <p> </p>
        • vimeo_id
        • created2016-04-05 14:34:59
        • modified2016-04-11 16:51:49
        • uri/articles/view/479/location-london
        • flattened_topics(array)
          • 0Voice from the Street
          • 1Travel
          • 2Urban Life
      • ParentBrokerage(array)
        • id(null)
        • account_executive_id(null)
        • archived(null)
        • type(null)
        • hide_from_frontend(null)
        • agent_brokerage_data_override(null)
        • featured_development(null)
        • membership_type(null)
        • max_properties(null)
        • max_homepage_featured_by_member_properties(null)
        • featured_properties_sort_method(null)
        • lux_feed_mode(null)
        • max_luxury_feed_properties(null)
        • membership_luxury_feed_properties(null)
        • can_participate_in_lux_feed_while_archived(null)
        • full_training_video_access(null)
        • country_id(null)
        • WOEID(null)
        • timezone(null)
        • luxury_feed_enrollment_mode(null)
        • luxury_feed_include_mlsidx_minimum_price(null)
        • luxury_feed_include_leverage_minimum_price(null)
        • digital_ad_contacts(null)
        • add_agents_to_grr_auto_recipients(null)
        • mlsidx_id(null)
        • mlsidx_lux_autofeed(null)
        • mlsidx_lux_autofeed_minimum_price(null)
        • mlsidx_logo_url(null)
        • mlsidx_disclaimer(null)
        • name(null)
        • broker_of_record_name(null)
        • short_name(null)
        • username(null)
        • password(null)
        • password_reset_hash(null)
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename(null)
        • active(null)
        • lead_in(null)
        • short_description(null)
        • description(null)
        • communities(null)
        • website(null)
        • address(null)
        • address_2(null)
        • city(null)
        • state(null)
        • full_state(null)
        • country(null)
        • market(null)
        • market_2(null)
        • postal_code(null)
        • phone(null)
        • phone_2(null)
        • phone_3(null)
        • wide_contact_image(null)
        • contact_name(null)
        • contact_profile_link(null)
        • contact_big_profile_link(null)
        • contact_big_profile_link_text(null)
        • contact_title(null)
        • contact_dre_num(null)
        • contact_quote(null)
        • contact_email(null)
        • contact_facebook(null)
        • contact_twitter(null)
        • contact_instagram(null)
        • contact_pinterest(null)
        • contact_linkedin(null)
        • contact_youtube(null)
        • contact_phone(null)
        • contact_email_2(null)
        • contact_2_facebook(null)
        • contact_2_twitter(null)
        • contact_2_instagram(null)
        • contact_2_pinterest(null)
        • contact_2_linkedin(null)
        • contact_2_youtube(null)
        • contact_phone_2(null)
        • contact_website(null)
        • contact_name_2(null)
        • contact_profile_link_2(null)
        • contact_big_profile_link_2(null)
        • contact_big_profile_link_text_2(null)
        • contact_title_2(null)
        • contact_dre_num_2(null)
        • contact_email_3(null)
        • contact_name_3(null)
        • contact_title_3(null)
        • contact_dre_num_3(null)
        • contact_phone_3(null)
        • contact_3_facebook(null)
        • contact_3_twitter(null)
        • contact_3_instagram(null)
        • contact_3_pinterest(null)
        • contact_3_linkedin(null)
        • contact_3_youtube(null)
        • image_filename(null)
        • logo_filename(null)
        • contact_image_filename(null)
        • all_properties_link_image_filename(null)
        • all_properties_link(null)
        • video_embed_code(null)
        • contact_video_embed_code(null)
        • meta_title(null)
        • meta_description(null)
        • meta_keywords(null)
        • login_message_counter(null)
        • stats_module_1_type(null)
        • stats_module_1_value(null)
        • stats_module_2_type(null)
        • stats_module_2_value(null)
        • stats_module_3_type(null)
        • stats_module_3_value(null)
        • last_activity_email_sent(null)
        • converted(null)
        • created(null)
        • modified(null)
        • dre_num(null)
        • name_with_location
      • ParentLocation(array)
        • id21
        • parent_id4
        • brokerage_id7
        • typeExclusive
        • archived(false)
        • use_as_topic(false)
        • nameLondon, United Kingdom
        • short_nameLondon, United Kingdom
        • group_index
        • latitude51.507351
        • longitude-0.127758
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_descriptionStylish London offers something for everyone at any time of the year.
        • long_descriptionLondon has some of the world’s most stunning architecture and more history than imaginable. From grand period buildings and townhouses, elegant apartments and modern penthouses there is a style of property for every taste. A secure city made up of a series of small districts, London has world-famous shopping areas with exclusive luxury brand designer stores and each of these charming neighbourhoods in this diverse city offers a wealth of cafes, bars and restaurants for residents and visitors to choose from. And with nearly 40% of space taken up with public parks and gardens, London is one of the greenest cities in the world eclipsing many other global cities including Paris, New York and Tokyo.
        • created2016-04-04 10:56:57
        • modified2016-04-14 15:00:04
        • timezoneEurope/London
        • population8000000
        • uri/locations/view/21/london-united-kingdom
        • tile_nameLondon, United Kingdom
      • Image(array)
        • 0(array)
          • id3304
          • modelArticle
          • model_id479
          • tagImage
          • nameScreen-Shot-2016-03-28-at-7.36.18-PM.png
          • typeimage/png
          • size1989440
          • uri/assets/3304.png
          • order0
          • created2016-04-05 14:35:00
          • modified2016-04-11 16:51:49
      • Brokerage(array)
        • 0(array)
          • id10
          • 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_id6
          • WOEID957831
          • timezoneEurope/Athens
          • 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
          • nameBeauchamp Estates
          • broker_of_record_name
          • short_nameBeauchamp Estates
          • usernameBeauchampMykonos
          • passwordba8b6054115d97d03e74e079d6a6feeb65ddff58
          • password_reset_hash
          • monthly_invoice_amount(null)
          • monthly_invoice_start_date0000-00-00
          • monthly_invoice_end_date0000-00-00
          • contract_filename
          • active(true)
          • lead_in
          • short_description
          • description<p>Beauchamp Estates is the exclusive representative for Leverage Global Partners in Mykonos, Greece.</p> <p>Following on from the successful opening of the office in Cannes, this is Beauchamp Estates’ newest addition to its overseas office portfolio.</p> <p>Mykonos, recognized as one of the world's most cosmopolitan destinations, with an increasingly wealthy and exclusive clientele, has some of the most upmarket, and expensive real estate available in Greece.</p> <p>Beauchamp Estates Mykonos specializes in residential sales at the very top end of the market, handles commercial investments, potential sites, new developments and luxury villa rentals. They offer an all around package and frequently earn repeat business from clients.</p> <p>With an established international client base, Beauchamp Estates has additional offices in <a href="../../../brokerage-detail/7/Beauchamp-Estates" target="_blank">London, England</a>, <a href="../../../brokerage-detail/11/Beauchamp-Estates" target="_blank">Cannes in the South of France</a>, and <a href="../../../brokerage-detail/12/Beauchamp-Estates" target="_blank">Florence, Italy</a>.</p>
          • communitiesMykonos Greece GR
          • websitehttp://www.beauchamp.com/
          • addressRohari
          • address_2
          • cityMykonos
          • state
          • full_state
          • countryGreece
          • marketMykonos
          • market_2
          • postal_code84600
          • phone+3022890 24797
          • phone_2
          • phone_3
          • wide_contact_image(false)
          • contact_nameRoi Deldimou
          • contact_profile_link
          • contact_big_profile_linkhttp://www.leveragere.com/blog/meet-roi-deldimou-beauchamp-estates-mykonos-greece/
          • contact_big_profile_link_text
          • contact_titleBeauchamp Estates
          • contact_dre_num
          • contact_quote
          • contact_email[email protected]
          • contact_facebook
          • contact_twitter
          • contact_instagram
          • contact_pinterest
          • contact_linkedin
          • contact_youtube
          • contact_phone
          • contact_email_2
          • contact_2_facebook
          • contact_2_twitter
          • contact_2_instagram
          • contact_2_pinterest
          • contact_2_linkedin
          • contact_2_youtube
          • contact_phone_2
          • contact_website
          • contact_name_2
          • contact_profile_link_2
          • contact_big_profile_link_2
          • contact_big_profile_link_text_2
          • contact_title_2
          • contact_dre_num_2
          • contact_email_3
          • contact_name_3
          • contact_title_3
          • contact_dre_num_3
          • contact_phone_3
          • contact_3_facebook
          • contact_3_twitter
          • contact_3_instagram
          • contact_3_pinterest
          • contact_3_linkedin
          • contact_3_youtube
          • image_filename10.jpg
          • logo_filename10.jpg
          • contact_image_filename10.jpeg
          • all_properties_link_image_filename10.jpg
          • all_properties_linkhttp://www.beauchamp.gr/index.php?act=viewCat&catId=64
          • video_embed_code
          • contact_video_embed_code
          • meta_titleMykonos Real Estate | Beauchamp Estates Mykonos | Leverage Global Partners
          • meta_descriptionBeauchamp Estates is the exclusive real estate representative for Leverage Global Partners in Mykonos, Greece.
          • meta_keywordsmykonos real estate, beauchamp estates, beauchamp estates mykonos, leverage global partners, gary hersham
          • login_message_counter0
          • stats_module_1_type
          • stats_module_1_value
          • stats_module_2_type
          • stats_module_2_value
          • stats_module_3_type
          • stats_module_3_value
          • last_activity_email_sent0000-00-00 00:00:00
          • converted(true)
          • created2013-03-19 17:01:23
          • modified2016-04-08 16:33:22
          • dre_num012345
          • uri/brokerage-detail/10/beauchamp-estates
          • website_shortwww.beauchamp.com
          • name_with_locationBeauchamp Estates
          • ArticlesBrokerage(array)
            • id45
            • article_id479
            • brokerage_id10
      • Location(array)
        • 0(array)
          • id21
          • parent_id4
          • brokerage_id7
          • typeExclusive
          • archived(false)
          • use_as_topic(false)
          • nameLondon, United Kingdom
          • short_nameLondon, United Kingdom
          • group_index
          • latitude51.507351
          • longitude-0.127758
          • country_code
          • north53.700001
          • south19.700001
          • east-52.599998
          • west-146.600006
          • zoom0
          • short_descriptionStylish London offers something for everyone at any time of the year.
          • long_descriptionLondon has some of the world’s most stunning architecture and more history than imaginable. From grand period buildings and townhouses, elegant apartments and modern penthouses there is a style of property for every taste. A secure city made up of a series of small districts, London has world-famous shopping areas with exclusive luxury brand designer stores and each of these charming neighbourhoods in this diverse city offers a wealth of cafes, bars and restaurants for residents and visitors to choose from. And with nearly 40% of space taken up with public parks and gardens, London is one of the greenest cities in the world eclipsing many other global cities including Paris, New York and Tokyo.
          • created2016-04-04 10:56:57
          • modified2016-04-14 15:00:04
          • timezoneEurope/London
          • population8000000
          • uri/locations/view/21/london-united-kingdom
          • tile_nameLondon, United Kingdom
          • ArticlesLocation(array)
            • id32
            • article_id479
            • location_id21
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id24
          • nameVoice from the Street
          • created2016-02-25 11:38:06
          • modified2016-02-25 11:38:06
          • tile_nameVoice from the Street
          • ArticlesTopic(array)
            • id322
            • article_id479
            • topic_id24
        • 1(array)
          • id10
          • nameTravel
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:35:10
          • tile_nameTravel
          • ArticlesTopic(array)
            • id321
            • article_id479
            • topic_id10
        • 2(array)
          • id5
          • nameUrban Life
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:36:03
          • tile_nameUrban Life
          • ArticlesTopic(array)
            • id320
            • article_id479
            • topic_id5
  • sidebar_tiles(array)
    • 0(array)
      • Topic(array)
        • id22
        • nameTrends
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:35:25
        • tile_nameTrends
      • Image(array)
        • id22
        • modelTopic
        • model_id22
        • tagImage
        • nameTrends.jpg
        • typeimage/jpeg
        • size9876100
        • uri/assets/22.jpg
        • order0
        • created2016-02-25 11:35:22
        • modified2016-02-25 11:35:25
      • modelTopic
    • 1(array)
      • Topic(array)
        • id21
        • nameSeasonal
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:33:39
        • tile_nameSeasonal
      • Image(array)
        • id15
        • modelTopic
        • model_id21
        • tagImage
        • nameSeasonal.jpg
        • typeimage/jpeg
        • size8402719
        • uri/assets/15.jpg
        • order0
        • created2016-02-25 11:33:37
        • modified2016-02-25 11:33:39
      • modelTopic
    • 2(array)
      • Location(array)
        • id143
        • parent_id7
        • brokerage_id34
        • typeExclusive
        • archived(false)
        • use_as_topic(true)
        • nameHamptons, NY, USA
        • short_nameHamptons, NY, USA
        • group_index
        • latitude40.924618
        • longitude-72.354790
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_description The Hamptons, the world's playground for the rich and famous.
        • long_descriptionThe absolute bastion of luxury and real estate opulence. The Hamptons has been the home of America's most expensive and resilient real estate since the turn of the 20th Century. Located just 90 miles from the financial center of the world, New York City, the East End is the preferred resort community for businessmen and celebrities alike. A collection of small, unique towns and hamlets, the area is home to world renown restaurants, designer boutiques, unparalleled entertainment and of course the east coast's most beautiful ocean beaches. A true paradise and one of the most sought after real estate markets.
        • created2016-04-07 16:14:57
        • modified2016-04-14 10:51:05
        • timezoneAmerica/New_York
        • population15000
        • uri/locations/view/143/hamptons-ny-usa
        • tile_nameHamptons, NY, USA
      • Brokerage(array)
        • id34
        • account_executive_id235
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties8
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties0
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id1
        • WOEID2518253
        • 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
        • nameFirst Hampton International Realty
        • broker_of_record_name
        • short_nameFirst Hampton International Realty
        • usernameFirstHampton
        • passwordc6d7951ad2b1432ff444a7a5acca6784d6573bb9
        • password_reset_hash
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date0000-00-00
        • monthly_invoice_end_date0000-00-00
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>First Hampton International Realty is the exclusive representative for Leverage Global Partners in The Hamptons, New York, USA.</p> <p>Lawrence Citarelli Jr. is a successful, former finance/ economics executive of 14 years and possesses over 17 years of real estate investment and development experience. Mr. Citarelli has forged the Lawrence III Group, The group is comprised of a multi award winning design/construction management firm, Westhampton Partners, a development and acquisition arm and First Hampton International Realty, a global real estate entity. Through the vertical integration of these three entities clients and customers are provided with an experience and service model that is unrivaled in the industry. Mr. Citarelli is also a consummate humanitarian and is aligned with various noteworthy athletes, entertainers and celebrities. He has recently been awarded a congressional award for his international business dealings which are specifically tied to helping the less fortunate children and the communities where he is active.</p>
        • communitiesWesthampton Beach Westhampton Quogue Remsenburg hamptons southampton east hampton
        • websitehttp://www.firsthamptonrealty.com
        • address50 Main Street
        • address_2
        • cityWesthampton Beach
        • stateNY
        • full_stateNew York
        • countryUSA
        • marketHamptons
        • market_2
        • postal_code11978
        • phone(631) 872-0280
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameLawrence Citarelli
        • contact_profile_link
        • contact_big_profile_linkhttp://www.leveragere.com/blog/meet-lawrence-citarelli-principal-first-hampton-realty/
        • contact_big_profile_link_text
        • contact_titlePrincipal
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename34.jpg
        • logo_filename34.jpg
        • contact_image_filename34.jpg
        • all_properties_link_image_filename34.jpg
        • all_properties_linkhttp://www.firsthamptonrealty.com/featured
        • video_embed_code
        • contact_video_embed_code
        • meta_titleThe Hamptons Real Estate | First Hampton International Realty | Leverage Global Partners
        • meta_descriptionFirst Hampton International Realty is Leverage Global Partners' exclusive representative in the Hamptons, New York, USA.
        • meta_keywordsFirst Hampton International Realty, The Hamptons Real Estate, Westhampton beach real estate, Lawrence Citarelli, Leverage Global Partners
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-06-07 11:03:46
        • modified2016-04-08 16:33:30
        • dre_num012345
        • uri/brokerage-detail/34/first-hampton-international-realty
        • website_shortwww.firsthamptonrealty.com
        • name_with_locationFirst Hampton International Realty
      • Image(array)
        • id9030
        • modelLocation
        • model_id143
        • tagImage
        • nameHamptons.jpg
        • typeimage/jpeg
        • size240646
        • uri/assets/9030.jpg
        • order0
        • created2016-04-07 16:12:57
        • modified2016-04-14 10:51:05
      • modelLocation
    • 3(array)
      • Topic(array)
        • id1
        • nameArts & Culture
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:29:58
        • tile_nameArts & Culture
      • Image(array)
        • id1
        • modelTopic
        • model_id1
        • tagImage
        • nameArts & Culture.jpg
        • typeimage/jpeg
        • size9923515
        • uri/assets/1.jpg
        • order0
        • created2016-02-25 11:29:53
        • modified2016-02-25 11:29:58
      • modelTopic
  • recent_articles(array)
    • 0(array)
      • Article(array)
        • id436
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(true)
        • large_featured(true)
        • titleHome Improvement: Take It Outside
        • authorLeverageRE
        • date2016-03-29
        • lead_inFrench for "under my tree," Sous Mon Arbre is an indoor/outdoor garden lamp ($665) equipped with a metal hook that can be used to hang the fixture on the branch of a tree. It can also be suspended from a wall or rest freely on a table or ground surface. Designed by Paris-based Florian Brillet and introduced last fall by Ligne Roset, the lamp features an ash wood handle and a shade of rustproof aluminum with a silk white lacquer finish.
        • body<h3><em><strong>This season's blue skies mean spending more time on green lawns. Spruce up outdoor spaces with these products designed to make the backyard a haven for summer relaxation.</strong></em></h3> <h3><strong><a href="http://www.ligne-roset-usa.com/Products/lighting/default.aspx" target="_blank">Ligne Roset Sous Mon Arbre Outdoor Lamp</a></strong></h3> <p><a href="http://www.ligne-roset-usa.com/Products/lighting/default.aspx" target="_blank"><img class="aligncenter wp-image-12942 pure-img" src="/assets/3046.png" /></a></p> <h3><strong><a href="http://www.frontgate.com/" target="_blank">Frontgate 40-Liter European Outdoor Solar Shower</a></strong></h3> <p>This solar-powered shower ($1,599) simply attaches to a garden hose and uses the sun's energy to heat the water-no plumbing required. The curved design, which holds a 40-liter tank, features a hot-cold mixer that allows the user to adjust the water to a desired temperature. The shower, available in five colors (shown in cherry), is made of a corrosion-resistant aluminum that can withstand marine environments.</p> <p><a href="http://www.frontgate.com/" target="_blank"><img class="aligncenter wp-image-12943 pure-img" src="/assets/3047.png" /></a></p> <h3><strong><a href="http://store.johntunger.com/products/big-bowl-o-zen-sculptural-firebowl" target="_blank">John T. Unger Studio Big Bowl O' Zen Sculptural Fire Bowl</a></strong></h3> <p>According to artist John T. Unger, every home needs a center of serenity. His <a href="http://store.johntunger.com/products/big-bowl-o-zen-37-inch-sculptural-firebowl" target="_blank">Big Bowl O' Zen</a> ($1,500) brings balance to any landscape and provides abundant warmth on a chilly evening. Hand-cut from heavy-duty, recycled cold-rolled steel, the 145-pound fire bowl is 37 inches in diameter and rests on a slim base. It is suitable for wood burning and ships ready-to-fit for clean-burning propane or natural gas.</p> <p><a href="http://store.johntunger.com/products/big-bowl-o-zen-sculptural-firebowl" target="_blank"><img class="aligncenter wp-image-12944 pure-img" src="/assets/3048.png" /></a></p>
        • vimeo_id
        • created2016-04-05 14:30:20
        • modified2016-04-11 17:05:22
        • uri/articles/view/436/home-improvement-take-it-outside
      • Image(array)
        • 0(array)
          • id3049
          • modelArticle
          • model_id436
          • tagImage
          • nameScreen-Shot-2016-04-02-at-2.02.59-PM.png
          • typeimage/png
          • size2530827
          • uri/assets/3049.png
          • order0
          • created2016-04-05 14:30:21
          • modified2016-04-11 17:05:22
    • 1(array)
      • Article(array)
        • id499
        • modelBrokerage
        • model_id244
        • archived(false)
        • medium_featured(false)
        • large_featured(false)
        • titleThe Smith & Berg Story
        • authorTodd Pastell
        • date2019-10-31
        • lead_inLorem ipsum
        • body<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed et est ut dui hendrerit auctor sit amet ut lorem. Proin eleifend tristique felis. Curabitur bibendum enim mauris, nec volutpat lectus aliquam a. Vestibulum laoreet tellus ac porta consectetur. Quisque quam tellus, tempus vel sollicitudin id, convallis ut erat. Nullam laoreet aliquet sapien non porttitor. Curabitur eu commodo quam, in pellentesque nibh. Etiam non dolor fermentum velit commodo feugiat a ut augue. Sed faucibus tincidunt vestibulum. Pellentesque tincidunt sed lorem at efficitur. Suspendisse maximus arcu eget fermentum pharetra. Praesent dapibus justo sit amet vestibulum molestie.</p> <p>Nullam eu faucibus nisi, sed lacinia eros. Quisque finibus nec ante eu scelerisque. In hac habitasse platea dictumst. Nam turpis augue, ornare sed odio a, placerat vestibulum augue. Curabitur posuere turpis sed nisl tempus, id feugiat ipsum dictum. Praesent venenatis pharetra nunc at tincidunt. Ut sollicitudin quam sit amet tortor molestie, at bibendum diam cursus. Cras ac metus vitae sapien condimentum consequat sit amet eget metus. Vestibulum et venenatis purus. Donec tincidunt pharetra ex quis tempor. Vivamus non sapien eget elit auctor ultrices at eget turpis. Nulla volutpat ut nibh eget placerat.</p>
        • vimeo_id
        • created2019-10-31 00:12:31
        • modified2019-10-31 00:12:31
        • uri/articles/view/499/the-smith-berg-story
      • Image(array)
        • 0(array)
          • id23087
          • modelArticle
          • model_id499
          • tagImage
          • nameIMG_4617.jpg
          • typeimage/jpeg
          • size3435286
          • uri/assets/23087.jpg
          • order0
          • created2019-10-31 00:12:19
          • modified2019-10-31 00:12:31
  • article_model_overrideLocation
  • article(array)
    • Article(array)
      • id441
      • modelLocation
      • model_id15
      • archived(false)
      • medium_featured(true)
      • large_featured(false)
      • titleLocation: Charleston
      • authorLeverageRE
      • date2016-03-28
      • lead_inHome of Leverage Partner dunes properties, Charleston is renowned for its Southern hospitality and historic charm. Walk along cobblestone streets lined with Spanish moss-draped trees, embrace the beautiful, centuries-old mansions and majestically preserved plantations and churches.
      • body<p>No matter where you turn, Charleston emanates a true historic feel, yet boasts a sense of modernism with its restaurants, shops and art galleries.</p> <p><img src="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-28-at-6.30.46-PM.png" /></p> <p><strong>INDULGE</strong>. <a href="http://www.plantersinn.com/peninsula-grill.htm#cake" target="_blank">The Peninsula Grill </a>inside the historic Planters Inn is home to the decadent Ultimate Coconut Cake. The 12-layer, cream-fi dessert is sold by the slice for diners or shipped whole across the country.</p> <p><img class="aligncenter wp-image-12880 pure-img" src="/assets/3074.png" /></p> <p><strong>FIND.</strong> Since 1922, <a href="http://birlant.com/" target="_blank">George C. Birlant & Co.</a> has been offering period furniture, silver, and accessories, as well as handcrafted reproductions of the famous Charleston Battery Bench that dots the city's sidewalks and parks</p> <p><strong>ADORN.</strong> <a href="http://croghansjewelbox.com/" target="_blank"><strong>Croghan's</strong> <strong>Jewel</strong> <strong>Box</strong></a> has enchanted generations of Charlestonians with a brilliant selection of jew- els and gifts. The family-run business has occupied the same 18th-century Charleston Single House on King Street since William Joseph Croghan opened shop over 100 years ago.</p> <p><img class="aligncenter wp-image-12878 pure-img" src="/assets/3075.png" /></p> <p><strong>SCREAM.</strong> <a href="http://bulldogtours.com/charleston-ghost-dungeon-walking-tour/" target="_blank">Bulldog</a> walking tours offer a glimpse at the haunted sites through- out town, but for a real fright, explore pre–Revolutionary War prisons during the dark of night.</p> <p><img class="aligncenter wp-image-12881 pure-img" src="/assets/3076.png" /></p>
      • vimeo_id
      • created2016-04-05 14:30:24
      • modified2016-04-11 17:04:52
      • uri/articles/view/441/location-charleston
      • flattened_topics(array)
        • 0Voice from the Street
    • ParentBrokerage(array)
      • id(null)
      • account_executive_id(null)
      • archived(null)
      • type(null)
      • hide_from_frontend(null)
      • agent_brokerage_data_override(null)
      • featured_development(null)
      • membership_type(null)
      • max_properties(null)
      • max_homepage_featured_by_member_properties(null)
      • featured_properties_sort_method(null)
      • lux_feed_mode(null)
      • max_luxury_feed_properties(null)
      • membership_luxury_feed_properties(null)
      • can_participate_in_lux_feed_while_archived(null)
      • full_training_video_access(null)
      • country_id(null)
      • WOEID(null)
      • timezone(null)
      • luxury_feed_enrollment_mode(null)
      • luxury_feed_include_mlsidx_minimum_price(null)
      • luxury_feed_include_leverage_minimum_price(null)
      • digital_ad_contacts(null)
      • add_agents_to_grr_auto_recipients(null)
      • mlsidx_id(null)
      • mlsidx_lux_autofeed(null)
      • mlsidx_lux_autofeed_minimum_price(null)
      • mlsidx_logo_url(null)
      • mlsidx_disclaimer(null)
      • name(null)
      • broker_of_record_name(null)
      • short_name(null)
      • username(null)
      • password(null)
      • password_reset_hash(null)
      • monthly_invoice_amount(null)
      • monthly_invoice_start_date(null)
      • monthly_invoice_end_date(null)
      • contract_filename(null)
      • active(null)
      • lead_in(null)
      • short_description(null)
      • description(null)
      • communities(null)
      • website(null)
      • address(null)
      • address_2(null)
      • city(null)
      • state(null)
      • full_state(null)
      • country(null)
      • market(null)
      • market_2(null)
      • postal_code(null)
      • phone(null)
      • phone_2(null)
      • phone_3(null)
      • wide_contact_image(null)
      • contact_name(null)
      • contact_profile_link(null)
      • contact_big_profile_link(null)
      • contact_big_profile_link_text(null)
      • contact_title(null)
      • contact_dre_num(null)
      • contact_quote(null)
      • contact_email(null)
      • contact_facebook(null)
      • contact_twitter(null)
      • contact_instagram(null)
      • contact_pinterest(null)
      • contact_linkedin(null)
      • contact_youtube(null)
      • contact_phone(null)
      • contact_email_2(null)
      • contact_2_facebook(null)
      • contact_2_twitter(null)
      • contact_2_instagram(null)
      • contact_2_pinterest(null)
      • contact_2_linkedin(null)
      • contact_2_youtube(null)
      • contact_phone_2(null)
      • contact_website(null)
      • contact_name_2(null)
      • contact_profile_link_2(null)
      • contact_big_profile_link_2(null)
      • contact_big_profile_link_text_2(null)
      • contact_title_2(null)
      • contact_dre_num_2(null)
      • contact_email_3(null)
      • contact_name_3(null)
      • contact_title_3(null)
      • contact_dre_num_3(null)
      • contact_phone_3(null)
      • contact_3_facebook(null)
      • contact_3_twitter(null)
      • contact_3_instagram(null)
      • contact_3_pinterest(null)
      • contact_3_linkedin(null)
      • contact_3_youtube(null)
      • image_filename(null)
      • logo_filename(null)
      • contact_image_filename(null)
      • all_properties_link_image_filename(null)
      • all_properties_link(null)
      • video_embed_code(null)
      • contact_video_embed_code(null)
      • meta_title(null)
      • meta_description(null)
      • meta_keywords(null)
      • login_message_counter(null)
      • stats_module_1_type(null)
      • stats_module_1_value(null)
      • stats_module_2_type(null)
      • stats_module_2_value(null)
      • stats_module_3_type(null)
      • stats_module_3_value(null)
      • last_activity_email_sent(null)
      • converted(null)
      • created(null)
      • modified(null)
      • dre_num(null)
      • name_with_location
    • ParentLocation(array)
      • id15
      • parent_id8
      • brokerage_id219
      • typeExclusive
      • archived(false)
      • use_as_topic(false)
      • nameCharleston, SC, USA
      • short_nameCharleston, SC, USA
      • group_index
      • latitude32.779144
      • longitude-79.924866
      • country_code
      • north53.700001
      • south19.700001
      • east-52.599998
      • west-146.600006
      • zoom0
      • short_descriptionCharleston thrives with a perfect blend of modern commerce and historical significance.
      • long_descriptionWhether you dream of historic charm, oceanfront majesty, secluded islands, an urban oasis, friendly suburbia, or a quiet rural getaway- Charleston and its coastal communities have a place for you. Golf, summer's Spoleto Festival which brings a world of entertainment to the city, fishing, water sports, plantation gardens, hiking trails, museums, there is truly something for everyone. Charleston is thriving with the perfect blend of modern day commerce and historical significance. Charleston is — well, Charleston. One of the world’s great cities, she preserves the best of the old and seems to constantly remake herself. Always relevant, yet obliging, we think she’s is grander than ever. Charleston has received many accolades over the year- friendliest city, best city in the world, best city in the US, best destination from Condé Nast readers. And with companies like Volvo and Boeing bringing even more opportunities to the Charleston area, we are looking forward to a prosperous future.
      • created2016-04-04 10:21:12
      • modified2016-04-04 10:46:05
      • timezoneAmerica/New_York
      • population372000
      • uri/locations/view/15/charleston-sc-usa
      • tile_nameCharleston, SC, USA
    • Image(array)
      • 0(array)
        • id3077
        • modelArticle
        • model_id441
        • tagImage
        • nameCharleston.jpg
        • typeimage/jpg
        • size697645
        • uri/assets/3077.jpg
        • order0
        • created2016-04-05 14:30:25
        • modified2016-04-11 17:04:52
    • Brokerage(array)
      • 0(array)
        • id219
        • account_executive_id236
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typeBasic
        • max_properties8
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties0
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id0
        • WOEID2378319
        • 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
        • namedunes properties
        • broker_of_record_name
        • short_namedunes properties
        • usernamedunesproperties
        • passwordb76f3dcf9a00c689036232225e96f54a1b389b83
        • password_reset_hash
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>dunes properties is the exclusive representative for Leverage Global Partners in Charleston, Mount Pleasant, Isle of Palms, West Ashley, James Island, Folly Beach, Sullivan's Island, Dewee's Island, SC, USA.</p> <p><em><strong>dunes properties</strong></em> is a boutique real estate, vacation rental, and property management company serving the Charleston area. We began with a single office and three employees in 1989. Today, we represent the Lowcountry with over 50 professional, experienced real estate agents in four full-service offices.</p> <p>Nobody knows the Charleston Coast better®</p>
        • communitiesCharleston Mount Pleasant Isle of Palms West Ashley James Island Folly Beach Sullivan's Island Dewee's Island
        • websitehttp://dunesproperties.com/
        • address214 King Street
        • address_2
        • cityCharleston
        • stateSC
        • full_stateSouth Carolina
        • countryUSA
        • marketCharleston
        • market_2
        • postal_code29401
        • phoneCell: (843) 270-1698
        • phone_2Office: (843) 886-5600
        • phone_3
        • wide_contact_image(false)
        • contact_nameRandy Walker
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titleBroker/Owner
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename219.png
        • logo_filename219.jpg
        • contact_image_filename219.png
        • all_properties_link_image_filename219.png
        • all_properties_linkhttp://idx.diversesolutions.com/link/220431
        • video_embed_code
        • contact_video_embed_code
        • meta_titleCharleston Real Estate | Dune Properties | Leverage Global Partners
        • meta_descriptiondunes properties is the exclusive representative for Leverage Global Partners in Charleston, Mount Pleasant, Isle of Palms, West Ashley, James Island, Folly Beach, Sullivan's Island, Dewee's Island, SC, USA.
        • meta_keywordsDunes Properties, Randy Walker, Charleston Real Estate, Mount Pleasant Real Estate, Isle of Palms Real Estate, West Ashley Real Estate, James Island Real Estate, Folly Beach Real Estate, Sullivan's Island Real Estate, Dewee's Island Real Estate, South Carolina Real Estate
        • login_message_counter3
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2015-08-24 13:29:47
        • modified2016-04-08 16:34:26
        • dre_num012345
        • uri/brokerage-detail/219/dunes-properties
        • website_shortdunesproperties.com
        • name_with_locationdunes properties
        • ArticlesBrokerage(array)
          • id56
          • article_id441
          • brokerage_id219
    • Location(array)
      • 0(array)
        • id15
        • parent_id8
        • brokerage_id219
        • typeExclusive
        • archived(false)
        • use_as_topic(false)
        • nameCharleston, SC, USA
        • short_nameCharleston, SC, USA
        • group_index
        • latitude32.779144
        • longitude-79.924866
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_descriptionCharleston thrives with a perfect blend of modern commerce and historical significance.
        • long_descriptionWhether you dream of historic charm, oceanfront majesty, secluded islands, an urban oasis, friendly suburbia, or a quiet rural getaway- Charleston and its coastal communities have a place for you. Golf, summer's Spoleto Festival which brings a world of entertainment to the city, fishing, water sports, plantation gardens, hiking trails, museums, there is truly something for everyone. Charleston is thriving with the perfect blend of modern day commerce and historical significance. Charleston is — well, Charleston. One of the world’s great cities, she preserves the best of the old and seems to constantly remake herself. Always relevant, yet obliging, we think she’s is grander than ever. Charleston has received many accolades over the year- friendliest city, best city in the world, best city in the US, best destination from Condé Nast readers. And with companies like Volvo and Boeing bringing even more opportunities to the Charleston area, we are looking forward to a prosperous future.
        • created2016-04-04 10:21:12
        • modified2016-04-04 10:46:05
        • timezoneAmerica/New_York
        • population372000
        • uri/locations/view/15/charleston-sc-usa
        • tile_nameCharleston, SC, USA
        • ArticlesLocation(array)
          • id38
          • article_id441
          • location_id15
    • Property(empty)
    • Topic(array)
      • 0(array)
        • id24
        • nameVoice from the Street
        • created2016-02-25 11:38:06
        • modified2016-02-25 11:38:06
        • tile_nameVoice from the Street
        • ArticlesTopic(array)
          • id351
          • article_id441
          • topic_id24
  • 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)
    • Article(empty)
    • Brokerage(empty)
    • Location(empty)
    • Property(empty)
    • User(empty)
    • PropertyFeature(empty)
    • SecondaryPropertyCategory(empty)
    • Topic(empty)
    • ParentBrokerage(empty)
    • ParentLocation(empty)
    • Image(empty)
    • ArticlesBrokerage(empty)
    • ArticlesLocation(empty)
    • ArticlesProperty(empty)
    • ArticlesTopic(empty)
    • PrimaryPropertyCategory(empty)
    • StripeSubscription(empty)
    • GlobalReachReport(empty)
    • UsersProperty(empty)
    • PropertiesSecondaryPropertyCategory(empty)
    • PropertiesPropertyFeature(empty)
    • PropertiesTopic(empty)
  • Loaded Helpers(array)
    • 0Permission
    • 1Number
    • 2SimpleGraph
    • 3DebugTimer
    • 4Toolbar
    • 5Session
    • 6Text
    • 7Flash
    • 8HtmlToolbar
    • 9Html
    • 10Form

  ====
• Environment
  +

  App Constants

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

  CakePHP Constants

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

  PHP Environment

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

  ====
• 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/LocationSearchComponent.php
    • Config(array)
      • 0APP/Config/core.php
      • 1APP/Config/bootstrap.php
      • 2APP/Config/routes.php
      • 3APP/Config/database.php
    • Controller(array)
      • 0APP/Controller/ArticlesController.php
      • 1APP/Controller/AppController.php
    • Model(array)
      • 0APP/Model/Subscription.php
      • 1APP/Model/AppModel.php
      • 2APP/Model/Article.php
      • 3APP/Model/Brokerage.php
      • 4APP/Model/Location.php
      • 5APP/Model/Property.php
      • 6APP/Model/User.php
      • 7APP/Model/PropertyFeature.php
      • 8APP/Model/PropertyCategory.php
      • 9APP/Model/Topic.php
      • 10APP/Model/Asset.php
      • 11APP/Model/StripeSubscription.php
      • 12APP/Model/GlobalReachReport.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

  ====