Location: Maui

LeverageRE

Remarkable 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.

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:

REJUVENATE.  Get pampered at the new Andaz Maui at Wailea's ‘Awili Spa and Salon with treatments featuring custom-blended products from the apothecary bar.

SWING.  Soak up the ocean views on the rugged terrain of the Wailea Golf Club's Gold Course or the more player-friendly Emerald Course.

DINE.  Tap into the island's Polynesian roots with a visit to the famed Mama's Fish House restaurant,a local legend since 1973. Savor traditional fresh fare caught by local fi  against the backdrop of a secluded white-sand beach.

DRESS.  The Four Seasons Resort Maui at Wailea 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.

SPLASH.  With locations in Kihei and Lahaina, the pros at Maui Wave Riders school have aspiring surfers and stand-up paddlers covered.

Share

• Topics:
• Voice from the Street
• Travel
• Beach

• Location:
• Maui, HI, USA

Recent Articles

Location: Kiawah Island

A resort community and full-time resident population, Kiawah Island is known for its abundance...

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] => 478
            [model] => Location
            [model_id] => 92
            [archived] => 
            [medium_featured] => 
            [large_featured] => 1
            [title] => Location: Maui
            [author] => LeverageRE
            [date] => 2016-03-29
            [lead_in] => Remarkable 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] => 
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:



REJUVENATE.  Get pampered at the new Andaz Maui at Wailea's ‘Awili Spa and Salon with treatments featuring custom-blended products from the apothecary bar.



SWING.  Soak up the ocean views on the rugged terrain of the Wailea Golf Club's Gold Course or the more player-friendly Emerald Course.



DINE.  Tap into the island's Polynesian roots with a visit to the famed Mama's Fish House restaurant,a local legend since 1973. Savor traditional fresh fare caught by local fi  against the backdrop of a secluded white-sand beach.

DRESS.  The Four Seasons Resort Maui at Wailea 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.



SPLASH.  With locations in Kihei and Lahaina, the pros at Maui Wave Riders school have aspiring surfers and stand-up paddlers covered.



            [vimeo_id] => 
            [created] => 2016-04-05 14:34:57
            [modified] => 2016-04-14 12:19:38
            [uri] => /articles/view/478/location-maui
            [flattened_topics] => Array
                (
                    [0] => Voice from the Street
                    [1] => Travel
                    [2] => Beach
                )

        )

    [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] => 92
            [parent_id] => 9
            [brokerage_id] => 62
            [type] => Exclusive
            [archived] => 
            [use_as_topic] => 
            [name] => Maui, HI, USA
            [short_name] => Maui, HI, USA
            [group_index] => 
            [latitude] => 20.798363
            [longitude] => -156.331924
            [country_code] => 
            [north] => 53.700001
            [south] => 19.700001
            [east] => -52.599998
            [west] => -146.600006
            [zoom] => 0
            [short_description] => 
            [long_description] => More information coming soon!
            [created] => 2016-04-05 11:22:53
            [modified] => 2016-04-05 11:22:53
            [timezone] => Pacific/Honolulu
            [population] => 145000
            [uri] => /locations/view/92/maui-hi-usa
            [tile_name] => Maui, HI, USA
        )

    [Image] => Array
        (
            [0] => Array
                (
                    [id] => 3299
                    [model] => Article
                    [model_id] => 478
                    [tag] => Image
                    [name] => Screen-Shot-2016-03-28-at-7.16.19-PM.png
                    [type] => image/png
                    [size] => 1869697
                    [uri] => /assets/3299.png
                    [order] => 0
                    [created] => 2016-04-05 14:34:58
                    [modified] => 2016-04-14 12:19:38
                )

        )

    [Brokerage] => Array
        (
            [0] => Array
                (
                    [id] => 62
                    [account_executive_id] => 236
                    [archived] => 
                    [type] => brokerage
                    [hide_from_frontend] => 
                    [agent_brokerage_data_override] => 
                    [featured_development] => 
                    [membership_type] => Premium
                    [max_properties] => 8
                    [max_homepage_featured_by_member_properties] => 0
                    [featured_properties_sort_method] => manual
                    [lux_feed_mode] => StripeSubscription
                    [max_luxury_feed_properties] => -1
                    [membership_luxury_feed_properties] => 0
                    [can_participate_in_lux_feed_while_archived] => 
                    [full_training_video_access] => 
                    [country_id] => 1
                    [WOEID] => 12588033
                    [timezone] => US/Hawaii
                    [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] => The Wailea Group
                    [broker_of_record_name] => 
                    [short_name] => The Wailea Group
                    [username] => WaileaGroup
                    [password] => 96cbf310f1191af607d1a68cb3d3240778537715
                    [password_reset_hash] => 
                    [monthly_invoice_amount] => 
                    [monthly_invoice_start_date] => 0000-00-00
                    [monthly_invoice_end_date] => 0000-00-00
                    [contract_filename] => 
                    [active] => 1
                    [lead_in] => 
                    [short_description] => 
                    [description] => 
The Wailea Group is the exclusive representative for Leverage Global Partners in Maui, Lanai, and Moloka'i, Hawaii, USA.

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.

Visit Makali’i at Wailea

                    [communities] => Maui
Lanai
Moloka'i
                    [website] => http://www.thewaileagroup.com/HomeMain.aspx
                    [address] => 3750 Wailea Alanui
                    [address_2] => Suite 5EW
                    [city] => Wailea
                    [state] => HI
                    [full_state] => Hawaii
                    [country] => USA
                    [market] => Maui
                    [market_2] => 
                    [postal_code] => 96753
                    [phone] => Main: (808) 875-6911
                    [phone_2] => 
                    [phone_3] => 
                    [wide_contact_image] => 
                    [contact_name] => Scott Nelson
                    [contact_profile_link] => 
                    [contact_big_profile_link] => 
                    [contact_big_profile_link_text] => 
                    [contact_title] => Principal 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_filename] => 62.jpg
                    [logo_filename] => 62.gif
                    [contact_image_filename] => 62.jpg
                    [all_properties_link_image_filename] => 62.jpg
                    [all_properties_link] => http://www.thewaileagroup.com/Exclusive.aspx
                    [video_embed_code] => 
                    [contact_video_embed_code] => 
                    [meta_title] => Maui Real Estate | The Wailea Group | Leverage Global Partners
                    [meta_description] => The Wailea Group is the exclusive representative for Leverage Global Partners in Maui, HI, USA.
                    [meta_keywords] => The Wailea Group, maui real estate, hawaii real estate, rene sand, leverage global partners
                    [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] => 2013-10-09 12:08:12
                    [modified] => 2016-04-08 16:33:30
                    [dre_num] => 012345
                    [uri] => /brokerage-detail/62/the-wailea-group
                    [website_short] => www.thewaileagroup.com/HomeMain.aspx
                    [name_with_location] => The Wailea Group
                    [ArticlesBrokerage] => Array
                        (
                            [id] => 83
                            [article_id] => 478
                            [brokerage_id] => 62
                        )

                )

        )

    [Location] => Array
        (
            [0] => Array
                (
                    [id] => 92
                    [parent_id] => 9
                    [brokerage_id] => 62
                    [type] => Exclusive
                    [archived] => 
                    [use_as_topic] => 
                    [name] => Maui, HI, USA
                    [short_name] => Maui, HI, USA
                    [group_index] => 
                    [latitude] => 20.798363
                    [longitude] => -156.331924
                    [country_code] => 
                    [north] => 53.700001
                    [south] => 19.700001
                    [east] => -52.599998
                    [west] => -146.600006
                    [zoom] => 0
                    [short_description] => 
                    [long_description] => More information coming soon!
                    [created] => 2016-04-05 11:22:53
                    [modified] => 2016-04-05 11:22:53
                    [timezone] => Pacific/Honolulu
                    [population] => 145000
                    [uri] => /locations/view/92/maui-hi-usa
                    [tile_name] => Maui, HI, USA
                    [ArticlesLocation] => Array
                        (
                            [id] => 59
                            [article_id] => 478
                            [location_id] => 92
                        )

                )

        )

    [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] => 439
                            [article_id] => 478
                            [topic_id] => 24
                        )

                )

            [1] => Array
                (
                    [id] => 10
                    [name] => Travel
                    [created] => 2016-02-25 11:25:00
                    [modified] => 2016-02-25 11:35:10
                    [tile_name] => Travel
                    [ArticlesTopic] => Array
                        (
                            [id] => 438
                            [article_id] => 478
                            [topic_id] => 10
                        )

                )

            [2] => Array
                (
                    [id] => 8
                    [name] => Beach
                    [created] => 2016-02-25 11:25:00
                    [modified] => 2016-02-25 11:30:26
                    [tile_name] => Beach
                    [ArticlesTopic] => Array
                        (
                            [id] => 437
                            [article_id] => 478
                            [topic_id] => 8
                        )

                )

        )

)

• 
• History
  +

  Request History

  4 previous requests available

  • Restore to current request
  • jloop
  • locations
  • juwai
  • testimonials/2

  ====
• Session
  +

  Session

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

  ====
• Request
  +

  Request

  Cake Params

  • plugin(null)
  • controllerarticles
  • actionview
  • named(empty)
  • pass(array)
    • 0478
    • 1location-maui
  • 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: 34 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` = 478 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` = (478) 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` = 478 AND `ArticlesBrokerage`.`brokerage_id` = `Brokerage`.`id`)	1	1	0
  SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `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` = 478 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` = 478 AND `ArticlesProperty`.`property_id` = `Property`.`id`)	0	0	3	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` = 478 AND `ArticlesTopic`.`topic_id` = `Topic`.`id`)	3	3	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 (487, 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` = 478 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` = (478) 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` = 478 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` = 478 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` = 478 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` = 478 AND `ArticlesTopic`.`topic_id` = `Topic`.`id`)	3	3	0
  SELECT `ArticlesTopic`.`id`, `ArticlesTopic`.`article_id` FROM `leveragere_staging2`.`articles_topics` AS `ArticlesTopic` WHERE `ArticlesTopic`.`topic_id` IN (24, 10, 8)	59	59	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 (426, 412, 401, 401, 398, 397, 382, 338, 339, 354, 347, 332, 272, 264, 263, 260, 251, 245, 245, 236, 216, 206, 205, 189, 188, 176, 176, 170, 32, 3, 439, 440, 441, 442, 442, 445, 446, 447, 448, 449, 449, 450, 450, 451, 455, 455, 464, 465, 465, 466, 467, 469, 478, 478, 478, 479, 479, 488, 487) AND `Article`.`id` != 478 AND `Article`.`model` != 'News' AND `Article`.`archived` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	3	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, 188, 448, 216) ORDER BY `Image`.`order` ASC	4	4	1	maybe slow
  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, 188, 448, 216) AND `ArticlesBrokerage`.`brokerage_id` = `Brokerage`.`id`)	2	2	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, 188, 448, 216) AND `ArticlesLocation`.`location_id` = `Location`.`id`)	2	2	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, 188, 448, 216) 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, 188, 448, 216) AND `ArticlesTopic`.`topic_id` = `Topic`.`id`)	8	8	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 (3710, 3742, 3703, 3706) ORDER BY `Image`.`order` ASC	31	31	1
  SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (3710, 3742, 3703, 3706) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	2	2	0
  SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (3710, 3742, 3703, 3706) AND `PropertiesSecondaryPropertyCategory`.`property_category_id` = `SecondaryPropertyCategory`.`id`)	0	0	2	maybe slow
  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 (3710, 3742, 3703, 3706) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	10	10	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 (3710, 3742, 3703, 3706) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	2	2	0

  6 duplicate queries run.

  Query Explain:

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

  ====
• Timer
  +

  Memory

  Peak Memory Use 12.21 MB

  Message	Memory use
  Component initialization	2.91 MB
  Controller action start	3.85 MB
  Controller render start	6.75 MB
  View render complete	7.31 MB

  Timers

  Total Request Time: 228 (ms)

  Message	Time in ms	Graph
  Core Processing (Derived from $_SERVER["REQUEST_TIME"])	26.79
  Event: Controller.initialize	4.13
  Event: Controller.startup	1.25
  Controller action	63.46
  Event: Controller.beforeRender	10.68
  » Processing toolbar data	10.55
  Rendering View	93.20
  » Event: View.beforeRender	0.41
  » Rendering APP/View/Articles/view.ctp	5.86
  » » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.23
  » » Rendering APP/View/Elements/sidebar/explore.ctp	1.45
  » » » Rendering APP/View/Elements/explore_tile_small.ctp	0.22
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #2	0.23
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #3	0.16
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #4	0.20
  » » Rendering APP/View/Elements/sidebar/article_list.ctp	0.29
  » » Rendering APP/View/Elements/sidebar/property_search.ctp	0.32
  » » Rendering APP/View/Elements/sidebar/property_list.ctp	1.91
  » » » Rendering APP/View/Elements/static_property_price.ctp	0.54
  » » » Rendering APP/View/Elements/static_property_price.ctp #2	0.20
  » » » Rendering APP/View/Elements/static_property_price.ctp #3	0.23
  » » » Rendering APP/View/Elements/static_property_price.ctp #4	0.23
  » Event: View.afterRender	0.01
  » Event: View.beforeLayout	0.01
  » Rendering APP/View/Layouts/front.ctp	85.90
  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)
        • id3710
        • brokerage_id155
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id981
        • agent_2_id0
        • agent_3_id0
        • name1853 W Grace St - In the Fan!
        • incomplete(false)
        • archived(false)
        • last_archived0000-00-00 00:00:00
        • auto_archived_from_mlsidx(false)
        • paid_featured(false)
        • featured(true)
        • homepage_featured(false)
        • brokerage_page_featured(true)
        • requested_homepage_featured_by_member(false)
        • homepage_featured_by_member(false)
        • dot_luxury_featured(false)
        • luxury_feed_featured(true)
        • force_luxury_feed_featured(false)
        • luxury_autofeed_imported(false)
        • luxury_feed_last_added_time0000-00-00 00:00:00
        • luxury_feed_agent_user_id0
        • luxury_feed_locked_to_subscription_id0
        • luxury_feed_agent_purchase_date0000-00-00
        • luxury_feed_agent_expiration_date0000-00-00
        • digital_ad_summary_email_last_sent0000-00-00 00:00:00
        • digital_ad_summary_price_changed(false)
        • wsj_detail_url
        • ft_detail_url
        • nyt_detail_url
        • juwai_detail_url
        • pgl_detail_url
        • mg_detail_url
        • mg_c_detail_url
        • mg_s_detail_url
        • bp_detail_url
        • mw_detail_url
        • nikkei_detail_url
        • wapo_detail_url
        • robb_detail_url
        • medium_featured(true)
        • large_featured(false)
        • detail_page(true)
        • description<p>Welcome to 1853 W Grace Street c. 1910, a Historic National Landmark & Richmond treasure has been lovingly restored with all the grand details preserved. The large center hall welcomes you & highlights the 12' ceilings, plaster moldings, rich detailing and original light fixtures that grace all the formal rooms. The dining room with its original chandelier & curved bay with 3 windows is one of the highlights of the house. A conservatory spilling out to a private walled garden, terrace, and salt water swimming pool make this house ideal for entertaining inside or out! There is a butlers pantry and large kitchen with commercial appliances. Plenty of bedrooms & bathrooms, a large master suite upstairs that has it's own bath, dressing room & a private balcony where you can enjoy the view overlooking the pool and gardens. In the heart of the Fan district and the Historic Grace Street district, this unique home offers hard to find grand scale living with city convenience. There is off street parking for 4 cars and garage offers parking with guest quarters (perfect "nanny" quarters) up. The property has been run as The Grace Manor Inn and can continue to be run as a B&B is desired.</p>
        • address1853 W Grace Street,
        • address_2
        • cityRichmond
        • stateVA
        • postal_code23220
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price1147000
        • price_20
        • price_usd1147000
        • 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)
        • bedrooms10
        • bedrooms_20
        • bathrooms6
        • 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
        • website
        • meta_title1853 W Grace St - In the Fan! | Richmond Real Estate | Small & Associates Real Estate
        • meta_description1853 W Grace Street, is a property offered for sale in Richmond, VA, USA, presented by Small & Associates Real Estate
        • meta_keywords
        • bathrooms_partial0
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built1906
        • virtual_tour
        • video_tour
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num1609528
        • wsj_property_typesingle family
        • nyt_property_type1
        • nyt_popular_features
        • propgolux_property_type9
        • juwai_property_type
        • juwai_category
        • propgolux_property_style48
        • wapo_property_type
        • robb_property_type
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude37.555672
        • longitude-77.461388
        • invalid_required_fields
        • invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
        • went_live_today(false)
        • converted(true)
        • invalid(false)
        • mlsidx_full_address
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2016-04-18 05:33:02
        • created2016-04-06 15:04:52
        • uri/property-detail/3710/1853-w-grace-street-richmond-va-23220-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3710/1853-w-grace-street-richmond-va-23220-usa
        • address_concat1853 W Grace Street, Richmond VA 23220 USA
        • google_maps_query_string1853+W+Grace+Street%2C++Richmond+VA+23220+USA
        • luxury_ad_enrolled_prettyYES
        • price_prettyUSD 1,147,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty10
        • bathrooms_pretty6
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms6
        • date_listed2016-04-06
        • overridden_brokerage_nameSmall & Associates Real Estate
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id155
        • 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_properties1
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id0
        • WOEID2480894
        • 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
        • nameSmall & Associates Real Estate
        • broker_of_record_name
        • short_nameSmall & Associates Real Estate
        • usernameSmallAssociatesRealEstate
        • passwordd16e623ad2ac5d8c1266af342ea6f1394f860fb3
        • password_reset_hash
        • monthly_invoice_amount0.00
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>Small & Associates Real Estate is the exclusive representative for Leverage Global Partners in Richmond, Chesterfield County, Goochland County, Henrico County, Hanover County, Virginia, USA.</p> <p>When Chris Small named his real estate company Small & Associates, it wasn’t because of his surname. It was also because of his vision – a vision for a close-knit “family” of real estate professionals bonded by a commitment to always making the customer’s needs their first priority. </p> <p>Chris soon found that his “quality over quantity” approach was appreciated not only by the company’s elite clientele, but also by many of the best agents Richmond has to offer. One by one they joined Small & Associates, along the way building an unsurpassed reputation for outstanding real estate services. So the next time you’re buying or selling a home or a property, <em>For Big Result, Think Small.</em></p> <p>When it comes to Richmond real estate, size does matter. At Small & Associates Real Estate, owner and founder Chris Small never desired to create another large, faceless real estate behemoth. Instead he set out to develop a small, tight-knit company that put quality over quantity and took pride in providing an elevated level of personal service to fellow Richmond residents.</p> <p><!--[if gte mso 9]><xml> <o:DocumentProperties> <o:Revision>0</o:Revision> <o:TotalTime>0</o:TotalTime> <o:Pages>1</o:Pages> <o:Words>202</o:Words> <o:Characters>1152</o:Characters> <o:Company>Leverage Global Partners</o:Company> <o:Lines>9</o:Lines> <o:Paragraphs>2</o:Paragraphs> <o:CharactersWithSpaces>1352</o:CharactersWithSpaces> <o:Version>14.0</o:Version> </o:DocumentProperties> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>JA</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:EnableOpenTypeKerning/> <w:DontFlipMirrorIndents/> <w:OverrideTableStyleHps/> <w:UseFELayout/> </w:Compatibility> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="276"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin;} </style> <![endif]--><!--StartFragment--><!--EndFragment--></p> <p>That was in 1982. Today, Small & Associates has earned a sterling reputation throughout the region for living up to Chris’s lofty ideals. The company’s strong local connections and independent ownership provide a superior alternative to the franchises and huge, corporate-owned companies.</p>
        • communitiesRichmond Chesterfield County Goochland County Henrico County Hanover County
        • websitehttp://www.smallrealestate.com/#&panel1-1
        • address5413 Patterson Avenue
        • address_2Suite 200
        • cityRichmond
        • stateVA
        • full_stateVirginia
        • countryUSA
        • market
        • market_2
        • postal_code23226
        • phoneOffice: (804) 343-6860
        • phone_2Mobile: (804) 350-0879
        • phone_3
        • wide_contact_image(false)
        • contact_nameChris Small
        • 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_filename155.jpg
        • logo_filename155.jpg
        • contact_image_filename155.jpg
        • all_properties_link_image_filename155.jpg
        • all_properties_linkhttp://smallrealestate.com/main/homes?isfeatured=1&isnew
        • video_embed_code
        • contact_video_embed_code
        • meta_titleRichmond Real Estate | Small & Associates Real Estate | Leverage Global Partners
        • meta_descriptionSmall & Associates Real Estate is the exclusive representative for Leverage Global Partners in Richmond, Virginia, USA.
        • meta_keywordsSmall & Associates Real Estate, Richmond Real Estate, Chesterfield County Real Estate, Goochland County Real Estate, Henrico County Real Estate, Real Estate Hanover County
        • login_message_counter3
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2014-08-26 18:10:55
        • modified2016-04-08 16:34:15
        • dre_num012345
        • uri/brokerage-detail/155/small-associates-real-estate
        • website_shortwww.smallrealestate.com/#&panel1-1
        • name_with_locationSmall & Associates 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)
          • id12202
          • modelProperty
          • model_id3710
          • tagImage
          • name36016.jpg
          • typeimage/jpg
          • size968952
          • uri/assets/12202.jpg
          • order0
          • created2016-04-07 16:31:06
          • modified2016-04-07 16:31:06
        • 1(array)
          • id12201
          • modelProperty
          • model_id3710
          • tagImage
          • name36023.jpg
          • typeimage/jpg
          • size1021773
          • uri/assets/12201.jpg
          • order1
          • created2016-04-07 16:31:06
          • modified2016-04-07 16:31:06
        • 2(array)
          • id12197
          • modelProperty
          • model_id3710
          • tagImage
          • name36024.jpg
          • typeimage/jpg
          • size1054408
          • uri/assets/12197.jpg
          • order2
          • created2016-04-07 16:31:06
          • modified2016-04-07 16:31:06
        • 3(array)
          • id12203
          • modelProperty
          • model_id3710
          • tagImage
          • name36022.jpg
          • typeimage/jpg
          • size1155112
          • uri/assets/12203.jpg
          • order3
          • created2016-04-07 16:31:06
          • modified2016-04-07 16:31:06
        • 4(array)
          • id12205
          • modelProperty
          • model_id3710
          • tagImage
          • name36015.jpg
          • typeimage/jpg
          • size1085631
          • uri/assets/12205.jpg
          • order4
          • created2016-04-07 16:31:06
          • modified2016-04-07 16:31:06
        • 5(array)
          • id12200
          • modelProperty
          • model_id3710
          • tagImage
          • name36018.jpg
          • typeimage/jpg
          • size1032962
          • uri/assets/12200.jpg
          • order5
          • created2016-04-07 16:31:06
          • modified2016-04-07 16:31:06
        • 6(array)
          • id12199
          • modelProperty
          • model_id3710
          • tagImage
          • name36020.jpg
          • typeimage/jpg
          • size1149075
          • uri/assets/12199.jpg
          • order6
          • created2016-04-07 16:31:06
          • modified2016-04-07 16:31:06
        • 7(array)
          • id12198
          • modelProperty
          • model_id3710
          • tagImage
          • name36021.jpg
          • typeimage/jpg
          • size918078
          • uri/assets/12198.jpg
          • order7
          • created2016-04-07 16:31:06
          • modified2016-04-07 16:31:06
        • 8(array)
          • id12204
          • modelProperty
          • model_id3710
          • tagImage
          • name36014.jpg
          • typeimage/jpg
          • size1060533
          • uri/assets/12204.jpg
          • order8
          • created2016-04-07 16:31:06
          • modified2016-04-07 16:31:06
        • 9(array)
          • id12196
          • modelProperty
          • model_id3710
          • tagImage
          • name36025.jpg
          • typeimage/jpg
          • size898562
          • uri/assets/12196.jpg
          • order9
          • created2016-04-07 16:31:06
          • modified2016-04-07 16:31:06
      • User(empty)
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(empty)
      • Topic(empty)
    • 1(array)
      • Property(array)
        • id3742
        • brokerage_id4
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameStunning & Elegant Home in Santa Monica Canyon
        • 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>Stunning four-bedroom five bathroom home in sought after Santa Monica Canyon. Featured in Architectural Digest, this light filled house was created by Melinda Gray, AIA with understated elegant interiors by Schuyler Samperton. The movable walls of glass offer a seamless indoor/outdoor flow to the pool and gardens. The main floor is divided by a sculptured staircase and features a state of the art kitchen, family, dining and entertaining areas. Second level offers the sumptuous and secluded master suite plus two additional bedrooms or office. The upper floor has a loft/library, a large office/studio/or bedroom with a bath. A spacious screening room, gym and bonus playroom with bath complete this special home.</p>
        • address562 Stassi Lane
        • address_2
        • citySanta Monica
        • stateCA
        • postal_code90402
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price5995000
        • price_20
        • price_usd5995000
        • 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
        • bathrooms1
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet4131
        • 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://562stassilane.thepartnerstrust.com/
        • meta_title
        • meta_description
        • meta_keywords
        • bathrooms_partial1
        • bathrooms_partial_20
        • bathrooms_3_41
        • bathrooms_3_4_20
        • year_built2006
        • virtual_tour
        • video_tourhttp://www.onvedeo.com/properties/767538/embed
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num16115452
        • wsj_property_typesingle family
        • nyt_property_type1
        • nyt_popular_features
        • propgolux_property_type9
        • juwai_property_type
        • juwai_category
        • propgolux_property_style33
        • 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.033543
        • longitude-118.509285
        • 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 10:43:20
        • created2016-04-18 10:37:39
        • uri/property-detail/3742/562-stassi-lane-santa-monica-ca-90402-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3742/562-stassi-lane-santa-monica-ca-90402-usa
        • address_concat562 Stassi Lane Santa Monica CA 90402 USA
        • google_maps_query_string562+Stassi+Lane++Santa+Monica+CA+90402+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 5,995,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty4
        • bathrooms_pretty1
        • bathrooms_partial_pretty1
        • bathrooms_3_4_pretty1
        • 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)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id4
        • 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
        • WOEID2488892
        • 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
        • usernamePartnersTrustSM
        • password74c7d5ff6cf0a7cb1e382c45ff916c0d15196817
        • 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 Santa Monica, California, USA.</p> <p>At Partners Trust, our real estate associates are the most professional, successful and ethical in the business, representing each of our clients with care, confidentiality and the utmost attention to service. As a company, we offer our associates and clients a level of technology and communication unmatched in today’s real estate market.</p> <p>Situated on the Pacific coast, Santa Monica’s excellent weather, proximity to the beach and its pedestrian and bike-friendly topography makes it one of the most desirable communities to call home in the country. Santa Monica offers an eclectic and rich mixture of commerce, affluent, single-family neighborhoods, renters, young professionals, and students.</p> <p>Our associates proudly represent a wide array of homes, ranging from a beachfront property or classic traditional, to the hillside contemporary estate. Whether our clients are homeowners or builders or international investors, Partners Trust associates understand their discerning needs and provide impeccable service with a high level of local area expertise.</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/5/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Pasadena</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>
        • communitiesSanta Monica Marina Del Rey Venice Mar Vista Pacific Palisades
        • websitehttp://www.thepartnerstrust.com
        • address1333 Montana Avenue
        • address_2
        • citySanta Monica
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • marketSanta Monica
        • market_2
        • postal_code90403
        • phone(310) 500-1307
        • phone_2(310) 505-9420
        • phone_3
        • wide_contact_image(false)
        • contact_nameScott Carmody
        • contact_profile_link
        • contact_big_profile_linkhttp://www.leveragere.com/blog/meet-scott-carmody-managing-director-partners-trust-santa-monica/
        • 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_filename4.jpg
        • logo_filename4.png
        • contact_image_filename4.JPG
        • all_properties_link_image_filename4.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_titleSanta Monica Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
        • meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Santa Monica, CA is a boutique real estate brokerage, focused on providing the highest level of service to home buyers and sellers in the Santa Monica real estate market.
        • meta_keywordspartners trust, partners trust real estate, santa monica real estate, santa monica real estate agents, scott carmody, 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-03-18 15:36:48
        • modified2016-04-08 16:33:22
        • dre_num012345
        • uri/brokerage-detail/4/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)
          • id20980
          • modelProperty
          • model_id3742
          • tagImage
          • name1.JPG.jpg
          • typeimage/jpeg
          • size325603
          • uri/assets/20980.jpg
          • order0
          • created2016-04-18 10:36:47
          • modified2016-04-18 10:37:39
        • 1(array)
          • id20985
          • modelProperty
          • model_id3742
          • tagImage
          • name3.jpg.jpg
          • typeimage/jpeg
          • size388035
          • uri/assets/20985.jpg
          • order1
          • created2016-04-18 10:36:48
          • modified2016-04-18 10:37:39
        • 2(array)
          • id20978
          • modelProperty
          • model_id3742
          • tagImage
          • name6.jpg.jpg
          • typeimage/jpeg
          • size310858
          • uri/assets/20978.jpg
          • order2
          • created2016-04-18 10:36:47
          • modified2016-04-18 10:37:39
        • 3(array)
          • id20986
          • modelProperty
          • model_id3742
          • tagImage
          • name12.jpg.jpg
          • typeimage/jpeg
          • size365753
          • uri/assets/20986.jpg
          • order3
          • created2016-04-18 10:36:48
          • modified2016-04-18 10:37:39
        • 4(array)
          • id20984
          • modelProperty
          • model_id3742
          • tagImage
          • name17.jpg.jpg
          • typeimage/jpeg
          • size333654
          • uri/assets/20984.jpg
          • order4
          • created2016-04-18 10:36:48
          • modified2016-04-18 10:37:39
        • 5(array)
          • id20982
          • modelProperty
          • model_id3742
          • tagImage
          • name29.jpg.jpg
          • typeimage/jpeg
          • size383641
          • uri/assets/20982.jpg
          • order5
          • created2016-04-18 10:36:47
          • modified2016-04-18 10:37:39
        • 6(array)
          • id20983
          • modelProperty
          • model_id3742
          • tagImage
          • name25.jpg.jpg
          • typeimage/jpeg
          • size370866
          • uri/assets/20983.jpg
          • order6
          • created2016-04-18 10:36:47
          • modified2016-04-18 10:37:39
        • 7(array)
          • id20981
          • modelProperty
          • model_id3742
          • tagImage
          • name28.jpg.jpg
          • typeimage/jpeg
          • size315046
          • uri/assets/20981.jpg
          • order7
          • created2016-04-18 10:36:47
          • modified2016-04-18 10:37:39
        • 8(array)
          • id20979
          • modelProperty
          • model_id3742
          • tagImage
          • name30.jpg.jpg
          • typeimage/jpeg
          • size293771
          • uri/assets/20979.jpg
          • order8
          • created2016-04-18 10:36:47
          • modified2016-04-18 10:37:39
        • 9(array)
          • id20987
          • modelProperty
          • model_id3742
          • tagImage
          • name34.JPG.jpg
          • typeimage/jpeg
          • size534075
          • uri/assets/20987.jpg
          • order9
          • created2016-04-18 10:36:48
          • modified2016-04-18 10:37:39
      • User(array)
        • 0(array)
          • id686
          • typeAgent
          • brokerage_id4
          • email[email protected]
          • password61056e4fd7a4679162664084fd33761aea85fa6e
          • recover_hash
          • first_nameMelanie
          • last_nameSommers
          • title
          • dre_num
          • phone310.500.1291
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2017-08-07 15:23:16
          • created2017-08-07 15:23:16
          • notified(false)
          • full_nameMelanie Sommers
          • uri/agent-detail/686/melanie-sommers
          • profile_complete(true)
          • UsersProperty(array)
            • id471
            • user_id686
            • property_id3742
            • sort_order0
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(array)
        • 0(array)
          • id1
          • nameBalcony/Terrace
          • additional(false)
          • created2016-04-07 14:00:26
          • modified2016-04-07 14:00:26
          • PropertiesPropertyFeature(array)
            • id4414
            • property_id3742
            • property_feature_id1
        • 1(array)
          • id4
          • nameGarage
          • additional(false)
          • created2016-04-07 14:01:52
          • modified2016-04-07 14:01:52
          • PropertiesPropertyFeature(array)
            • id4415
            • property_id3742
            • property_feature_id4
        • 2(array)
          • id6
          • nameGym
          • additional(false)
          • created2016-04-07 14:02:29
          • modified2016-04-07 14:02:29
          • PropertiesPropertyFeature(array)
            • id4416
            • property_id3742
            • property_feature_id6
        • 3(array)
          • id8
          • nameMedia Room
          • additional(false)
          • created2016-04-07 14:03:04
          • modified2016-04-07 14:03:04
          • PropertiesPropertyFeature(array)
            • id4417
            • property_id3742
            • property_feature_id8
        • 4(array)
          • id9
          • nameOffice
          • additional(false)
          • created2016-04-07 14:03:21
          • modified2016-04-07 14:03:21
          • PropertiesPropertyFeature(array)
            • id4418
            • property_id3742
            • property_feature_id9
        • 5(array)
          • id12
          • nameSwimming Pool
          • additional(false)
          • created2016-04-07 14:04:12
          • modified2016-04-07 14:04:12
          • PropertiesPropertyFeature(array)
            • id4419
            • property_id3742
            • property_feature_id12
        • 6(array)
          • id14
          • nameViews
          • additional(false)
          • created2016-04-07 14:04:55
          • modified2016-04-07 14:04:55
          • PropertiesPropertyFeature(array)
            • id4420
            • property_id3742
            • property_feature_id14
      • Topic(array)
        • 0(array)
          • id12
          • nameModern Architecture
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:33:26
          • tile_nameModern Architecture
          • PropertiesTopic(array)
            • id46
            • property_id3742
            • topic_id12
        • 1(array)
          • id16
          • nameInterior Design
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:32:53
          • tile_nameInterior Design
          • PropertiesTopic(array)
            • id47
            • property_id3742
            • topic_id16
    • 2(array)
      • Property(array)
        • id3703
        • brokerage_id95
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id1223
        • agent_2_id0
        • agent_3_id0
        • nameBeautiful Colonial in Legacy Woods
        • incomplete(false)
        • archived(false)
        • last_archived0000-00-00 00:00:00
        • auto_archived_from_mlsidx(false)
        • paid_featured(false)
        • featured(true)
        • homepage_featured(false)
        • brokerage_page_featured(true)
        • requested_homepage_featured_by_member(false)
        • homepage_featured_by_member(false)
        • dot_luxury_featured(false)
        • luxury_feed_featured(true)
        • force_luxury_feed_featured(false)
        • luxury_autofeed_imported(false)
        • luxury_feed_last_added_time0000-00-00 00:00:00
        • luxury_feed_agent_user_id0
        • luxury_feed_locked_to_subscription_id0
        • luxury_feed_agent_purchase_date0000-00-00
        • luxury_feed_agent_expiration_date0000-00-00
        • digital_ad_summary_email_last_sent0000-00-00 00:00:00
        • digital_ad_summary_price_changed(false)
        • wsj_detail_url
        • ft_detail_url
        • nyt_detail_url
        • juwai_detail_url
        • pgl_detail_url
        • mg_detail_url
        • mg_c_detail_url
        • mg_s_detail_url
        • bp_detail_url
        • mw_detail_url
        • nikkei_detail_url
        • wapo_detail_url
        • robb_detail_url
        • medium_featured(false)
        • large_featured(false)
        • detail_page(true)
        • description<p>Beautiful Colonial in sought after neighborhood, Gourmet kitchen, Huge master bed room with master bath,finished basement great for entertaining. Gorgeous inground pool with outdoor hot tub and beautiful stone patio. A must see!!</p>
        • address15 Shadowbrook Crossing
        • address_2
        • cityEast Greenwich
        • stateRI
        • postal_code02818
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price1300000
        • price_20
        • price_usd1300000
        • price_usd_20
        • statusFor Sale
        • status_last_changed0000-00-00 00:00:00
        • status_last_changed_price_only0000-00-00 00:00:00
        • lease_period
        • price_upon_request(false)
        • bedrooms3
        • bedrooms_20
        • bathrooms4
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet0
        • square_meters
        • acres0
        • interior_unitsq_ft
        • interior_size0
        • lot_unitacres
        • lot_size0
        • icon_1pool
        • icon_2media-room
        • icon_3garage
        • icon_4
        • icon_5
        • icon_6
        • website
        • meta_titleBeautiful Colonial in Legacy Woods | East Greenwich Real Estate | Coleman Realtors
        • meta_description15 Shadowbrook Crossing is a property offered for sale in East Greenwich, RI, USA, presented by Coleman Realtors
        • meta_keywords
        • bathrooms_partial1
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built2004
        • virtual_tour
        • video_tour
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num1118980
        • wsj_property_typesingle family
        • nyt_property_type1
        • nyt_popular_features
        • propgolux_property_type9
        • juwai_property_type
        • juwai_category
        • propgolux_property_style10
        • 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
        • latitude41.648308
        • longitude-71.524071
        • invalid_required_fields
        • invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
        • went_live_today(false)
        • converted(true)
        • invalid(false)
        • mlsidx_full_address
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2016-04-18 05:33:02
        • created2016-04-06 07:17:36
        • uri/property-detail/3703/15-shadowbrook-crossing-east-greenwich-ri-02818-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3703/15-shadowbrook-crossing-east-greenwich-ri-02818-usa
        • address_concat15 Shadowbrook Crossing East Greenwich RI 02818 USA
        • google_maps_query_string15+Shadowbrook+Crossing++East+Greenwich+RI+02818+USA
        • luxury_ad_enrolled_prettyYES
        • price_prettyUSD 1,300,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty3
        • bathrooms_pretty4
        • bathrooms_partial_pretty1
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms4
        • date_listed2016-04-06
        • overridden_brokerage_nameColeman Realtors
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id95
        • 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_properties4
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id0
        • WOEID2477058
        • 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
        • nameColeman Realtors
        • broker_of_record_name
        • short_nameColeman Realtors
        • usernameColemanRealtors
        • passwordc19a88afe4dbd7329004555ea008b2340aa6342b
        • password_reset_hash
        • monthly_invoice_amount0.00
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>Coleman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill.</p> <p>Local knowledge, world-class expertise.</p> <p>Rhode Islanders pride themselves on their independence. So do we: we're an independent, third-generation residential real estate company, not a franchise. That means we're totally focused on you and your needs. We've helped thousands of clients buy, sell, and rent since we opened our doors in 1929. Today our clients rely on our team of over 100 experienced professionals for our local knowledge and expertise: we know the neighborhoods, the towns and the people. With offices in Barrington, East Greenwich, Providence and Watch Hill, we're nearby too. So no matter your challenge, we'll bring you a wealth of experience, ideas and relationships - all geared toward producing results.</p>
        • communitiesBarrington, RI Providence, RI Watch Hill, RI Newport, RI Jamestown, RI Bristol, RI Charlestown, RI Narragansett, RI South Kingstown, RI East Greenwich, RI
        • websitehttp://www.colemanrealtors.com/
        • address135 Elmgrove Avenue
        • address_2
        • cityProvidence
        • stateRI
        • full_stateRhode Island
        • countryUSA
        • marketProvidence
        • market_2
        • postal_code02906
        • phoneDavid Coleman: (401) 245-3050
        • phone_2Michael Young: (401) 274-3636
        • phone_3
        • wide_contact_image(false)
        • contact_nameDavid Coleman & Michael Young
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titleCo-Owners
        • contact_dre_num
        • contact_quoteWe invite you to contact us personally about Providence real estate.
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2[email protected]
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • 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_filename95.jpg
        • logo_filename95.png
        • contact_image_filename95.jpg
        • all_properties_link_image_filename95.jpg
        • all_properties_linkhttp://www.colemanrealtors.com/featured
        • video_embed_code
        • contact_video_embed_code
        • meta_titleProvidence Real Estate | Coleman Realtors | Leverage Global Partners
        • meta_descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Providence, Rhode Island, USA.
        • meta_keywordsColeman Realtors, Providence Real Estate, Leverage Global Partners, Providence Rhode Island Real Estate, Barrington Real Estate, East Greenwich Real Estate, Providence Real Estate, Watch Hill Real Estate
        • 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-02-11 18:09:34
        • modified2016-04-08 16:34:01
        • dre_num012345
        • uri/brokerage-detail/95/coleman-realtors
        • website_shortwww.colemanrealtors.com
        • name_with_locationColeman Realtors
      • 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)
          • id8805
          • modelProperty
          • model_id3703
          • tagImage
          • name36006.jpg
          • typeimage/jpg
          • size3406385
          • uri/assets/8805.jpg
          • order0
          • created2016-04-07 16:11:05
          • modified2016-04-07 16:11:05
        • 1(array)
          • id8802
          • modelProperty
          • model_id3703
          • tagImage
          • name35998.jpg
          • typeimage/jpg
          • size1515170
          • uri/assets/8802.jpg
          • order1
          • created2016-04-07 16:11:04
          • modified2016-04-07 16:11:04
        • 2(array)
          • id8801
          • modelProperty
          • model_id3703
          • tagImage
          • name35999.jpg
          • typeimage/jpg
          • size1752454
          • uri/assets/8801.jpg
          • order2
          • created2016-04-07 16:11:04
          • modified2016-04-07 16:11:04
        • 3(array)
          • id8800
          • modelProperty
          • model_id3703
          • tagImage
          • name36000.jpg
          • typeimage/jpg
          • size1477593
          • uri/assets/8800.jpg
          • order3
          • created2016-04-07 16:11:04
          • modified2016-04-07 16:11:04
        • 4(array)
          • id8799
          • modelProperty
          • model_id3703
          • tagImage
          • name36001.jpg
          • typeimage/jpg
          • size1673188
          • uri/assets/8799.jpg
          • order4
          • created2016-04-07 16:11:04
          • modified2016-04-07 16:11:04
        • 5(array)
          • id8798
          • modelProperty
          • model_id3703
          • tagImage
          • name36002.jpg
          • typeimage/jpg
          • size1470683
          • uri/assets/8798.jpg
          • order5
          • created2016-04-07 16:11:03
          • modified2016-04-07 16:11:04
        • 6(array)
          • id8797
          • modelProperty
          • model_id3703
          • tagImage
          • name36003.jpg
          • typeimage/jpg
          • size1828645
          • uri/assets/8797.jpg
          • order6
          • created2016-04-07 16:11:03
          • modified2016-04-07 16:11:03
        • 7(array)
          • id8803
          • modelProperty
          • model_id3703
          • tagImage
          • name36004.jpg
          • typeimage/jpg
          • size1765406
          • uri/assets/8803.jpg
          • order7
          • created2016-04-07 16:11:04
          • modified2016-04-07 16:11:04
        • 8(array)
          • id8804
          • modelProperty
          • model_id3703
          • tagImage
          • name36005.jpg
          • typeimage/jpg
          • size3513723
          • uri/assets/8804.jpg
          • order8
          • created2016-04-07 16:11:04
          • modified2016-04-07 16:11:04
        • 9(array)
          • id8806
          • modelProperty
          • model_id3703
          • tagImage
          • name36007.jpg
          • typeimage/jpg
          • size3107628
          • uri/assets/8806.jpg
          • order9
          • created2016-04-07 16:11:05
          • modified2016-04-07 16:11:06
      • User(empty)
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(array)
        • 0(array)
          • id12
          • nameSwimming Pool
          • additional(false)
          • created2016-04-07 14:04:12
          • modified2016-04-07 14:04:12
          • PropertiesPropertyFeature(array)
            • id1418
            • property_id3703
            • property_feature_id12
        • 1(array)
          • id8
          • nameMedia Room
          • additional(false)
          • created2016-04-07 14:03:04
          • modified2016-04-07 14:03:04
          • PropertiesPropertyFeature(array)
            • id1419
            • property_id3703
            • property_feature_id8
        • 2(array)
          • id4
          • nameGarage
          • additional(false)
          • created2016-04-07 14:01:52
          • modified2016-04-07 14:01:52
          • PropertiesPropertyFeature(array)
            • id1420
            • property_id3703
            • property_feature_id4
      • Topic(empty)
    • 3(array)
      • Property(array)
        • id3706
        • brokerage_id81
        • created_by_user_id0
        • order6
        • multi_unit(false)
        • agent_1_id150
        • agent_2_id0
        • agent_3_id0
        • nameTudor Accents
        • 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>As good as it gets! This picturesque block of Oakridge Avenue is spectacular! It's peaceful, scenic & so convenient with its access to downtown Bethesda (via Thornapple Path!) These long-time, caring owners have taken wonderful care of this classic Chevy Chase residence. The dramatic family room addition with due east exposure & soaring ceilings is amazing! *Loft retreat with bedroom & office*</p>
        • address6907 Oakridge Avenue
        • address_2
        • cityChevy Chase
        • stateMD
        • postal_code20815
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price1395000
        • price_20
        • price_usd1395000
        • 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_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/6907-OAKRIDGE-AVENUE-CHEVY-CHASE-MD-20815/MC9581947/30/
        • meta_titleTudor Accents | Chevy Chase Real Estate | Evers & Co. Real Estate
        • meta_description6907 Oakridge Avenue is a property offered for sale in Chevy Chase, MD, USA, presented by Evers & Co. Real Estate
        • meta_keywords
        • bathrooms_partial2
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built
        • virtual_tourhttp://slideshow.mris.com/slideshow/slideshow.htm?ListingKey=300027450487
        • 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:03
        • created2016-04-06 12:20:13
        • uri/property-detail/3706/6907-oakridge-avenue-chevy-chase-md-20815-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3706/6907-oakridge-avenue-chevy-chase-md-20815-usa
        • address_concat6907 Oakridge Avenue Chevy Chase MD 20815 USA
        • google_maps_query_string6907+Oakridge+Avenue++Chevy+Chase+MD+20815+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 1,395,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-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)
          • id20563
          • modelProperty
          • model_id3706
          • tagImage
          • name36010.jpg
          • typeimage/jpg
          • size5169715
          • uri/assets/20563.jpg
          • order2894
          • created2016-04-07 17:34:08
          • modified2016-04-07 17:34:08
      • 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)
            • id175
            • user_id373
            • property_id3706
            • 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)
        • id188
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(false)
        • large_featured(false)
        • titleIn Search of: The Best Day Spas in the US
        • authorLeverageRE
        • date2014-04-03
        • lead_inBetween work and home responsibilities, schedules can get pretty full, pretty fast. It’s important to make time for yourself, to embrace the benefits of some good, clean R&R.
        • body <p>When it comes to pure relaxation, there may be no better activity than a day at the spa. Whether you chose to fly solo or bring your besties, <strong>a spa day is a day devoted to y-o-u</strong>. With a full menu of services, luxury day spas offer an escape from everyday life, a serene retreat where you will be treated like royalty. Say ahhhhh...</p> <p>To make the experience even more stress-free, we’ve previewed some of the best day spas (with multiple locations) in the US. <strong>Here are a few standouts:</strong></p> <p><strong><a href="http://www.mandarinoriental.com/newyork/luxury-spa/" target="_blank" title="Mandarin Oriental">Spa at Mandarin Oriental</a> in NYC</strong>: This luxury boutique hotel, with locations worldwide including London and Paris, offers the highest quality amenities including its award winning spa; a celebrity favored city oasis, well known for its ancient and contemporary therapies customized to fit your specific needs. The massages are spectacular and guests are offered guidance on nutrition and exercise.</p> <p><img src="/assets/525.jpeg" class="pure-img"></p> <p><a href="http://www.fourseasons.com/newyork/spa/" target="_blank" title="Four Seasons Spa"><strong>Four Seasons Spa</strong></a>, with city locations like LA and New York as well as vacation destinations like Jackson Hole, Vail, and Whistler, offers a five-star sanctuary with unique treatments in each location; the Brew and Renew treatment in Vail, Colorado features a foot bath filled with Crazy Mountain Brewery’s Amber Ale.</p> <p><img src="/assets/526.jpeg" class="pure-img"></p> <p><a href="http://www.burkewilliamsspa.com" target="_blank" title="Burke Williams"><strong>Burke Williams Spa</strong></a>, with locations throughout California including 5 in Los Angeles, is an incredible day spa offering luxury ambiance, with water falls and oil aromas to go with their world-class treatments, including their signature Anti-Aging facial, which utilizes stem cells to revitalize the skin.</p> <p><img src="/assets/527.jpg" class="pure-img"></p> <p><a href="http://www.blissworld.com/spa/" target="_blank" title="Bliss Spa"><strong>Bliss Spa</strong></a>, with locations all over the world, including LA, Chicago, Dallas and Scottsdale, offers high-end, effective services, including facials, waxing and massage, with an array of some seriously hard working products, like their body-toning FatGirlSlim and their age-fighting Youth As We Know It.</p> <p><img src="/assets/528.jpg" class="pure-img"></p> <p>Whatever your pampering preferences, there are day spas throughout the US that will cater to your every need. From an hour to an entire day, it just may be the break you need to recharge and rejuvenate.</p> <p>Do you have a go-to spa in your neighborhood? What’s your favorite treatment? Please share your ideas and leave your comments below.</p> <p><em>Photos courtesy of <a href="http://www.mandarinoriental.com/newyork/luxury-spa/" target="_blank" title="Mandarin Oriental">Mandarin Oriental</a>, <a href="http://www.fourseasons.com/newyork/spa/" target="_blank" title="Four Seasons">Four Seasons</a>, <a href="http://www.burkewilliamsspa.com" target="_blank" title="Burke Williams">Burke Williams</a> and <a href="http://www.blissworld.com/spa/" target="_blank" title="Bliss Spa">Bliss Spa</a></em></p>
        • vimeo_id
        • created2016-02-25 14:10:39
        • modified2016-04-05 14:41:06
        • uri/articles/view/188/in-search-of-the-best-day-spas-in-the-us
        • flattened_topics(array)
          • 0Travel
      • 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)
        • id(null)
        • parent_id(null)
        • brokerage_id(null)
        • type(null)
        • archived(null)
        • use_as_topic(null)
        • name(null)
        • short_name(null)
        • group_index(null)
        • latitude(null)
        • longitude(null)
        • country_code(null)
        • north(null)
        • south(null)
        • east(null)
        • west(null)
        • zoom(null)
        • short_description(null)
        • long_description(null)
        • created(null)
        • modified(null)
        • timezone(null)
        • population(null)
      • Image(array)
        • 0(array)
          • id529
          • modelArticle
          • model_id188
          • tagImage
          • nameBlissSap.jpg
          • typeimage/jpg
          • size183180
          • uri/assets/529.jpg
          • order0
          • created2016-02-25 14:10:40
          • modified2016-03-15 16:42:16
      • Brokerage(empty)
      • Location(empty)
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id10
          • nameTravel
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:35:10
          • tile_nameTravel
          • ArticlesTopic(array)
            • id203
            • article_id188
            • topic_id10
    • 2(array)
      • Article(array)
        • id448
        • modelLocation
        • model_id74
        • archived(false)
        • medium_featured(true)
        • large_featured(true)
        • titleLocation: Vail
        • authorLeverageRE
        • date2016-03-24
        • lead_inThough a year-round destination, Vail was predominately created by and for skiing. As popular as skiing is in the winter, activities such as hiking, cycling and golfing fill the void in the summer.
        • body<p>The small town offers signature, year-round events, dozens of nightlife hotspots, diverse dining, luxurious spas and hundreds of shops. Whether you're looking for outdoor adventure or some much needed R&R, there's an activity for everyone to enjoy while in Vail:</p> <p><strong>INDULGE.</strong> Nothing repairs sore ski muscles like the Hot Toddy for the Body treatment at the spa at the <a href="http://www.ritzcarlton.com/en/hotels/colorado/bachelor-gulch" target="_blank">Ritz-Carlton, Bachelor Gulch</a>, where a scrub containing sweet almond oil, jojoba beads, and shea butter scented with cinnamon and nutmeg is massaged into the skin to eliminate dry patches and relax muscles.</p> <p><img class="aligncenter wp-image-12787 pure-img" src="/assets/3115.png" /></p> <p><strong>SOCIALIZE.</strong> Stop in après ski or post-hike at <a href="http://www.larkspurvail.com/" target="_blank">Larkspur</a> in Edwards and join locals for a classic Larkburger paired with parmesan truffle fries and a local brew.</p> <p><img class="aligncenter wp-image-12788 pure-img" src="/assets/3116.png" /></p> <p><strong>CHALLENGE.</strong> The <a href="http://www.beavercreek.com/events-and-activities/world-cup.aspx" target="_blank">Birds of Prey</a> down-hill course at Beaver Creek is one of the most difficult downhill courses in the world, featuring a vertical drop of 2,484 feet loaded with steep pitches and sharp turns.</p> <p><img class="aligncenter wp-image-12786 pure-img" src="/assets/3117.png" /></p> <p><strong>SHOP</strong><strong>.</strong> The <a href="http://vailfarmersmarket.com/" target="_blank">Vail Farmer's Market</a> is the largest in Colorado. Stock up on everything from organic, locally grown produce and meats to wine from Colorado's Bookcliff Vineyards and goat cheese from Jumpin' Good Goat Dairy.</p> <p><strong>EXPLORE.</strong> Spend the day with <a href="http://www.vailvalleyanglers.com/" target="_blank">Vail Valley Anglers</a> and experience fishing for brown, rainbow, cutthroat, and brook trout paired with hiking and wildlife spotting.</p> <p><img class="aligncenter wp-image-12789 pure-img" src="/assets/3118.png" /></p> <p><strong>DINE.</strong> A Vail Village classic, <a href="https://sweetbasilvail.com/" target="_blank">Sweet Basil</a> is headed by executive chef Paul Anders, who continues to produce a creative menu of modern American cuisine.</p>
        • vimeo_id
        • created2016-04-05 14:30:41
        • modified2016-04-11 17:03:53
        • uri/articles/view/448/location-vail
        • flattened_topics(array)
          • 0Voice from the Street
          • 1Ski
      • 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)
        • id74
        • parent_id9
        • brokerage_id6
        • typeExclusive
        • archived(false)
        • use_as_topic(false)
        • nameVail, CO, USA
        • short_nameVail, CO, USA
        • group_index
        • latitude39.640263
        • longitude-106.374191
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_description
        • long_descriptionMore information coming soon!
        • created2016-04-04 18:08:26
        • modified2016-04-04 18:08:26
        • timezoneAmerica/Denver
        • population5300
        • uri/locations/view/74/vail-co-usa
        • tile_nameVail, CO, USA
      • Image(array)
        • 0(array)
          • id3119
          • modelArticle
          • model_id448
          • tagImage
          • nameVail.jpg
          • typeimage/jpg
          • size782803
          • uri/assets/3119.jpg
          • order0
          • created2016-04-05 14:30:42
          • modified2016-04-11 17:03:53
      • Brokerage(array)
        • 0(array)
          • id6
          • 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_properties4
          • membership_luxury_feed_properties0
          • can_participate_in_lux_feed_while_archived(false)
          • full_training_video_access(false)
          • country_id1
          • WOEID2510611
          • 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
          • nameGateway Land and Development Real Estate
          • broker_of_record_name
          • short_nameGateway Land and Development
          • usernameGatewayLand
          • passwordb17782d097733f59e365f87cad485736c79b54f3
          • password_reset_hash
          • monthly_invoice_amount500.00
          • monthly_invoice_start_date(null)
          • monthly_invoice_end_date(null)
          • contract_filename6.pdf
          • active(true)
          • lead_in
          • short_description
          • description<p>Gateway Land & Development is the exclusive representative for Leverage Global Partners in Eagle County, Colorado, USA.</p> <p>Gateway Land and Development Real Estate was established in 1993 in Edwards, Colorado and is owned and operated by Suzi Apple, a 40-year Vail Valley resident.</p> <p>Much like the area it serves, Gateway is without peer. From exceptional ski homes to spectacular ranch properties, unique commercial endeavors to new developments, no real estate opportunity is outside of Gateway’s expertise. Gateway was founded upon the conviction that relationships are to be coveted and honored.</p> <p>These same values continue to be the cornerstone of our business and are evidenced by the fact that the majority of our business continues to originate from referrals and repeat customers. Conveniently located in the heart of Vail Village and in downtown Edwards, Let Gateway Lead You Home.</p>
          • communitiesVail Valley USA United States of America Eagle United States USA United States of America Beaver Creek USA United States of America Vail USA United States of America Cordillera USA United States of America Edwards USA United States of America Colorado USA United States of America Eagle County USA United States of America Colorado
          • websitehttp://www.gatewaytovail.com/
          • address183 Gore Creek Trail
          • address_2
          • cityVail
          • stateCO
          • full_stateColorado
          • countryUSA
          • marketVail
          • market_2
          • postal_code81658
          • phone970.376.5417
          • phone_2
          • phone_3
          • wide_contact_image(false)
          • contact_nameSuzi Apple
          • contact_profile_link
          • contact_big_profile_linkhttp://www.leveragere.com/blog/suzi-apple-gateway-lands-president-loves-living-and-working-in-vail/
          • contact_big_profile_link_text
          • contact_titlePresident
          • 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_websitehttp://www.suziapple.com
          • 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_filename6.jpg
          • logo_filename6.jpg
          • contact_image_filename6.jpg
          • all_properties_link_image_filename6.jpg
          • all_properties_linkhttp://gatewayland.com/search-properties/exclusive-to-gateway
          • video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/EAp4pAeV-qzxAOUo0.js"></script>
          • contact_video_embed_code
          • meta_titleVail Real Estate | Gateway Land and Development Real Estate | Leverage Global Partners
          • meta_descriptionGateway Land and Development Real Estate is the exclusive representative for Leverage Global Partners in Vail, Colorado, USA.
          • meta_keywordsgateway land and development real estate, gateway land, vail real estate, leverage global partners, suzi apple
          • 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-18 18:33:20
          • modified2016-04-18 10:40:09
          • dre_num012345
          • uri/brokerage-detail/6/gateway-land-and-development-real-estate
          • website_shortwww.gatewaytovail.com
          • name_with_locationGateway Land and Development Real Estate
          • ArticlesBrokerage(array)
            • id55
            • article_id448
            • brokerage_id6
      • Location(array)
        • 0(array)
          • id74
          • parent_id9
          • brokerage_id6
          • typeExclusive
          • archived(false)
          • use_as_topic(false)
          • nameVail, CO, USA
          • short_nameVail, CO, USA
          • group_index
          • latitude39.640263
          • longitude-106.374191
          • country_code
          • north53.700001
          • south19.700001
          • east-52.599998
          • west-146.600006
          • zoom0
          • short_description
          • long_descriptionMore information coming soon!
          • created2016-04-04 18:08:26
          • modified2016-04-04 18:08:26
          • timezoneAmerica/Denver
          • population5300
          • uri/locations/view/74/vail-co-usa
          • tile_nameVail, CO, USA
          • ArticlesLocation(array)
            • id37
            • article_id448
            • location_id74
      • 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)
            • id349
            • article_id448
            • topic_id24
        • 1(array)
          • id9
          • nameSki
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:33:52
          • tile_nameSki
          • ArticlesTopic(array)
            • id348
            • article_id448
            • topic_id9
    • 3(array)
      • Article(array)
        • id216
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(false)
        • large_featured(false)
        • titleVilla in the City: Leverage Lookbook London Open House
        • authorLeverageRE
        • date2014-06-02
        • lead_inThis Hamilton Terrace home offers contemporary comforts while maintaining its traditional heritage...
        • body <p><em>View the full article in <a href="http://issuu.com/leveragere/docs/final_s2014lookbook/22" target="_blank">Leverage Lookbook Open House: Villa in the City</a></em></p> <p>In 1809, the area located north of London's Hyde Park, known as St. John's Wood, became an urban experiment for a new kind of residential building, when terraced housing-identical row houses with shared walls-was abandoned in favor of the semi-detached villa.</p> <p>This, combined with the ample gardens planned into the development (the area originated as the 16th-century private hunting grounds of Henry VIII) and the neighborhood's adjacent parks (Regent's Park and Primrose Hill), helped the area retain a rural character, while the city's other prestigious enclaves, such as Belgravia and Knightsbridge, became more urban.</p> <p><a href="http://issuu.com/leveragere/docs/final_s2014lookbook/22" target="_blank"><img src="/assets/685.jpg" class="pure-img"></a></p> <p>Since then, the boldface names who have called St. John's Wood home have been as diverse as artist Lucien Freud, socialite Daphne Guinness, former Prime Minister John Major, rock star Keith Richards, entrepreneur Sir Richard Branson, model Kate Moss, and actors such as Damien Lewis, Ewan McGregor, Jude Law, and Sienna Miller. The latter two reportedly still have residences here, as does Sir Paul McCartney.</p> <p>One of the earliest homes built was this residence on Hamilton Terrace, currently on the market for £37 million (about $61.5million) through <a href="http://www.beauchamp.co.uk/property/details/1001002943-hamilton-terrace-london-nw8#6" target="_blank">Beauchamp Estates</a>. Originally built in 1810, it exemplifies everything that makes St. John's Wood such a desirable place to live, starting with the wide double doors and bay windows in front to the tree-lined garden and deck out back. Sandwiched in between these lie 11,140 square feet of interior space, accommodating seven bedrooms, six baths, and four reception rooms.</p> <p><a href="http://issuu.com/leveragere/docs/final_s2014lookbook/22" target="_blank"><img src="/assets/686.jpg" class="pure-img"></a></p> <p>The residence was most recently remodeled entirely in 2010 by its current owners, who hired local interior designer <a href="http://www.bbdesign.co.uk/" target="_blank">Bill Bennette</a> to give the home a timeless, Hollywood-type glamour while maintaining its English roots. At a structural level, that meant excavating a new basement and reconfiguring the layout, while more aesthetic changes included adding cornices and architectural trim.</p> <p>For the interiors, Bennette conjured a mix that spans design eras, imparting a timeless elegance that is impossible to peg to a single genre. A largely black-and-white palette suggests the silver-screen sophistication of a Jean Harlow–William Powell musical. Deco-inspired lighting and curvaceous silhouettes-bow-fronted chests on either side of the living room fireplace, swoop- armed sofas, oval tables-certainly emphasize this look. Yet mirrored touches, such as the living room's coffee table or the dining table lend a 1970s chic to formal reception areas.</p> <p><a href="http://issuu.com/leveragere/docs/final_s2014lookbook/22" target="_blank"><img src="/assets/687.jpg" class="pure-img"></a></p> <p>In the library, handsome millwork painted a moody charcoal gray evokes the grand style of historical universities like Oxford and Cambridge. However, the furniture forms are clean and tailored, and the ceiling and fireplace wall are mirrored to carry through the 1940s feel of other rooms.</p> <p><a href="http://issuu.com/leveragere/docs/final_s2014lookbook/22" target="_blank"><img src="/assets/688.jpg" class="pure-img"></a></p> <p>The master suite occupies an entire floor. Its upholstered headboard and chandelier continue the Moderne, platinum-blonde thread. But the bath, with its glass shower and large-format tiles, feels of-the-moment. Likewise, the ground-floor kitchen leaps into the present with state-of-the-art appliances, minimalist lines, and sleek Italian cabinetry by <a href="http://www.minotticucine.it/" target="_blank">Minotti Cucine</a>.</p> <p><a href="http://issuu.com/leveragere/docs/final_s2014lookbook/22" target="_blank"><img src="/assets/689.jpg" class="pure-img"></a></p> <p>There is also an extensive leisure complex in the basement. And outside, the internationally renowned, award-winning landscape designer <a href="http://www.lucianogiubbilei.com/" target="_blank">Luciano Giubbilei</a> created a graceful garden that seems at once classical and contemporary. Toward the rear of Giubbilei's grand lawn is a three-bedroom mews house, accessed through a private entrance on Northwick Mews.</p> <p><a href="http://issuu.com/leveragere/docs/final_s2014lookbook/22" target="_blank"><img src="/assets/690.jpg" class="pure-img"></a></p> <p><a href="http://issuu.com/leveragere/docs/final_s2014lookbook/22" target="_blank">Read more in Leverage Lookbook Open House: Villa in the City // by Jorge S. Arango</a></p> <p><a href="http://issuu.com/leveragere/docs/final_s2014lookbook/22" target="_blank"><img src="/assets/691.jpg" class="pure-img"></a></p>
        • vimeo_id
        • created2016-02-25 14:11:00
        • modified2016-04-05 14:39:22
        • uri/articles/view/216/villa-in-the-city-leverage-lookbook-london-open-house
        • flattened_topics(array)
          • 0Travel
          • 1Traditional Architecture
          • 2Ultra Lux
      • 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)
        • id(null)
        • parent_id(null)
        • brokerage_id(null)
        • type(null)
        • archived(null)
        • use_as_topic(null)
        • name(null)
        • short_name(null)
        • group_index(null)
        • latitude(null)
        • longitude(null)
        • country_code(null)
        • north(null)
        • south(null)
        • east(null)
        • west(null)
        • zoom(null)
        • short_description(null)
        • long_description(null)
        • created(null)
        • modified(null)
        • timezone(null)
        • population(null)
      • Image(array)
        • 0(array)
          • id692
          • modelArticle
          • model_id216
          • tagImage
          • nameVilla-in-the-City.jpg
          • typeimage/jpg
          • size510849
          • uri/assets/692.jpg
          • order0
          • created2016-02-25 14:11:01
          • modified2016-03-15 16:37:00
      • Brokerage(empty)
      • Location(empty)
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id10
          • nameTravel
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:35:10
          • tile_nameTravel
          • ArticlesTopic(array)
            • id180
            • article_id216
            • topic_id10
        • 1(array)
          • id13
          • nameTraditional Architecture
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:34:46
          • tile_nameTraditional Architecture
          • ArticlesTopic(array)
            • id181
            • article_id216
            • topic_id13
        • 2(array)
          • id20
          • nameUltra Lux
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:35:37
          • tile_nameUltra Lux
          • ArticlesTopic(array)
            • id182
            • article_id216
            • topic_id20
  • sidebar_tiles(array)
    • 0(array)
      • Topic(array)
        • id15
        • nameTechnology
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:34:35
        • tile_nameTechnology
      • Image(array)
        • id19
        • modelTopic
        • model_id15
        • tagImage
        • nameTechnology.jpg
        • typeimage/jpeg
        • size5994533
        • uri/assets/19.jpg
        • order0
        • created2016-02-25 11:34:31
        • modified2016-02-25 11:34:35
      • modelTopic
    • 1(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
    • 2(array)
      • Topic(array)
        • id16
        • nameInterior Design
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:32:53
        • tile_nameInterior Design
      • Image(array)
        • id12
        • modelTopic
        • model_id16
        • tagImage
        • nameInterior Design.jpg
        • typeimage/jpeg
        • size22577089
        • uri/assets/12.jpg
        • order0
        • created2016-02-25 11:32:48
        • modified2016-02-25 11:32:53
      • modelTopic
    • 3(array)
      • Location(array)
        • id91
        • parent_id9
        • brokerage_id46
        • typeExclusive
        • archived(false)
        • use_as_topic(true)
        • nameSonoma, CA, USA
        • short_nameSonoma, CA, USA
        • group_index
        • latitude38.406742
        • longitude-122.876129
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_descriptionAn extraordinary quality of life just north of San Francisco.
        • long_descriptionJust an hour north of San Francisco, the renowned Wine Country of Sonoma County offers an extraordinary quality of life. Distinctly unique small towns dot the rolling hillsides, lush vineyards, towering redwood forests and breathtaking coastline. Sonoma County’s world-class wineries easily rival those of its well-known neighbor, Napa County, just to the east. Wherever you go in Sonoma County there's a great sense of community. While each town and area retains its own style and pace, they all offer safe neighborhoods, bountiful Farmers Markets, good schools, open spaces, vineyards, orchards, festivals for every season, beautiful old farm houses...the list goes on and on.
        • created2016-04-05 11:20:44
        • modified2016-04-14 13:32:23
        • timezoneAmerica/Los_Angeles
        • population500292
        • uri/locations/view/91/sonoma-ca-usa
        • tile_nameSonoma, CA, USA
      • Brokerage(array)
        • id46
        • 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_properties4
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id1
        • WOEID2495775
        • 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
        • nameVanguard Properties
        • broker_of_record_name
        • short_nameVanguard Properties
        • usernameVanguardSonoma
        • passworde8045814d4cc920c82b1497cdc9288d62d2c8c16
        • 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>Vanguard Properties is the exclusive representative for Leverage Global Partners in Sonoma, California, USA.</p> <p>For close to 30 years, Vanguard Properties has offered impeccable service to buyers and sellers throughout the Bay Area. Vanguard Properties Sonoma specializes in offering its clients service beyond their expectations whether buying or selling. Vanguard Properties represents many of the most prominent homes in the beautiful California wine country region of Sonoma County.</p> <p>Whether looking for an expansive luxury estate to a wonderful country farm house to vineyard land to produce estate grown grapes and perhaps build your dream home, Vanguard Properties Sonoma is your resource for quality Real Estate services to ensure a smooth transaction.</p> <p>In addition if you are looking to sell any of the aforementioned types of properties Vanguard Properties Sonoma has the expertise, the knowledge and the marketing savvy to expose your property to a worldwide network of realtors. Many Sonoma County home buyers are from San Francisco. That being said the Bay Area owned and operated <a href="../../../brokerage-detail/18/Vanguard-Properties" target="_blank">Vanguard Properties San Francisco</a> gives you the extra added value of being showcased not only in Sonoma County but in San Francisco, as well.</p> <p>We are proud of our team of professionals, who are service-driven and passionately share in your goal to find the home that’s right for you in the manner that fits your lifestyle.</p> <p>COMMITMENT</p> <p>At Vanguard, we stake our reputation on every relationship we create. Your unique client experience will be built on the high degree of professionalism and on our commitment to delivering service tailored to your individual needs, at every point of contact. With Vanguard by your side, you can feel confident that all aspects of your development are in good hands. We are proud to have provided developers with expert service for over twenty years now, including buyer insights that come by working with discerning buyers in highly dynamic markets. But we are only as good as the service we offer to the valued clients we work with today. They demand nothing but the best. Fortunately, we're in a position to deliver.</p> <p>DISTINCTION</p> <p>Vanguard brings exceptional homes to market, consistently and with outstanding results, under the guidance of some of the most respected professionals in the business. Our founder, James Nunemacher, is within the top 1% of real estate sales in the nation, and an acknowledged expert in the market. His exacting standards set the tone for everything we do. Simply put, no one is more qualified than Vanguard. This was true when we opened for business selling residential real estate. It has never been truer today, as our services have grown to encompass every aspect of the process of developing and marketing the most sought-after homes and developments in one of the most competitive markets.</p> <p>SERVICE</p> <p>Vanguard understands what discerning buyers and sellers are looking for, and equally importantly, what they are not. As your trusted partner, we will review and advise on every aspect of your home, from floor plans to finishing touches. Our instinct for detail may result in suggestions that surprise you.</p> <p>MARKETING</p> <p>Quality homes may be timeless. Marketing, however, demands the ability to match the leading-edge of customer expectations and stay several steps ahead of your competition. Vanguard's leadership is no more obvious than in the field of marketing. We will develop fresh, innovative strategies for you, incorporating a keen sense of brand-identity and integrating the technology that drives the housing market today. Your home is much more than simply brick and mortar. It is an investment upon which you expect the highest returns. With Vanguard's marketing acumen you can be confident that your home-buying audience is appropriately targeted and your return on investment is fully realized.</p>
        • communitiessonoma sebastopol healdsburg
        • websitehttp://vanguardsf.com/
        • address978 Gravenstein Highway South
        • address_2
        • citySebastopol
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • marketSonoma
        • market_2
        • postal_code95472
        • phone(415) 321-7007
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameJames Nunemacher
        • contact_profile_link
        • contact_big_profile_linkhttp://www.leveragere.com/blog/meet-james-nunemacher-principal-vanguard-properties/
        • contact_big_profile_link_text
        • contact_titleCEO
        • 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_filename46.jpg
        • logo_filename46.jpg
        • contact_image_filename46.jpg
        • all_properties_link_image_filename46.jpg
        • all_properties_linkhttp://vanguardsf.com/VGlistings.php
        • video_embed_code
        • contact_video_embed_code
        • meta_titleSonoma Real Estate | Vanguard Properties| Leverage Global Partners
        • meta_descriptionVanguard Properties is the exclusive representative for Leverage Global Partners in Sonoma, CA, USA.
        • meta_keywordsVanguard Properties, sonoma real estate, James Nunemacher, leverage global partners
        • login_message_counter1
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-09-11 10:43:00
        • modified2016-04-08 16:33:30
        • dre_num012345
        • uri/brokerage-detail/46/vanguard-properties
        • website_shortvanguardsf.com
        • name_with_locationVanguard Properties
      • Image(array)
        • id3025
        • modelLocation
        • model_id91
        • tagImage
        • name46.jpg
        • typeimage/jpeg
        • size190364
        • uri/assets/3025.jpg
        • order0
        • created2016-04-05 11:20:35
        • modified2016-04-14 13:32:23
      • modelLocation
  • recent_articles(array)
    • 0(array)
      • Article(array)
        • id487
        • modelLocation
        • model_id137
        • archived(false)
        • medium_featured(true)
        • large_featured(false)
        • titleLocation: Kiawah Island
        • authorLeverageRE
        • date2016-03-30
        • lead_inA resort community and full-time resident population, Kiawah Island is known for its abundance of wildlife. Explore Mother Nature's beauty on land or in the water, and experience the aquatic life and vegetation that surround this 10-mile stretch of beach.
        • body<p>Experience Kiawah's natural habitat by taking a morning bike ride on one of the island's 30 miles of paved trails or 10 miles of flat beach. <strong>Surfscooter</strong> will deliver your bicycle to your front doorstep, or you might choose from the variety of bike trailers, chariots, and tag-a-longs if you want to adventure around Kiawah with your family in tow.</p> <p><img class="aligncenter wp-image-13087 pure-img" src="/assets/3346.jpg" /></p> <div> <div> <div> <div> <div> <div> <div> <div> <p>Be sure to stop at the nearby <strong>Johns Island Farmers Market</strong> on Saturday morning. In addition to locally sourced produce, the market also offers sustainable educational classes, demonstrations, and interactive opportunities to learn about making sustainable life choices.</p> <p>Endorphin-fueled vacationers will find no lack of sporting activities around the island. Go for a run, kayak in the tidal pools around the island, or enjoy a game of tennis or a round of golf at the Kiawah Island Golf Club. <strong>The Roy Barth Tennis Center </strong>was ranked number three in the United States by Tennis magazine.</p> <p><img class="aligncenter wp-image-13088 pure-img" src="/assets/3347.jpg" /></p> <p>After a full day of activities, visit the <strong>Sushi Lounge at the Atlantic Room</strong> in the Ocean Course Clubhouse to enjoy the freshest locally sourced produce and seafood in the Low country, as well as small plates, cocktails, and fine wines.</p> <p><img class="aligncenter wp-image-13070 pure-img" src="/assets/3348.jpg" /></p> </div> </div> <h6><em>Photos courtesy of: <a href="http://www.kiawahresort.com/blog/kiawah-golf/" target="_blank">Kiawah Island</a>, <a href="http://www.kiawahresort.com/blog/kiawah-island/2014/06/24/bike-around-kiawah-island/" target="_blank">Kiawah Resort</a></em></h6> </div> </div> </div> </div> </div> </div>
        • vimeo_id
        • created2016-04-05 14:35:21
        • modified2016-04-11 17:08:39
        • uri/articles/view/487/location-kiawah-island
      • Image(array)
        • 0(array)
          • id3349
          • modelArticle
          • model_id487
          • tagImage
          • nameKiawah-Island.jpg
          • typeimage/jpg
          • size904980
          • uri/assets/3349.jpg
          • order0
          • created2016-04-05 14:35:21
          • modified2016-04-11 17:08:39
    • 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)
      • 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
  • 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/478/location-maui
  Query String
  Request Method	GET
  Server Protocol	HTTP/1.1
  Gateway Interface	CGI/1.1
  Redirect Url	/articles/view/478/location-maui
  Remote Port	15846
  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 Cf Ray	a09d8360ad14d287-CMH
  Http Accept Encoding	gzip, br
  Http Cookie	CAKEPHP=0amivkavdif2dpjq18lmp5ot0l
  Http Accept	*/*
  Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
  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	aioq1_K8CRJnCvkkTtrp-gAAAMI
  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	aioq1_K8CRJnCvkkTtrp-gAAAMI
  Fcgi Role	RESPONDER
  Php Self	/index.php
  Request Time Float	1781148375.1642
  Request Time	1781148375

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

  ====