Location: Kiawah Island

LeverageRE

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

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

Be sure to stop at the nearby Johns Island Farmers Market 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.

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. The Roy Barth Tennis Center was ranked number three in the United States by Tennis magazine.

After a full day of activities, visit the Sushi Lounge at the Atlantic Room 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.

Photos courtesy of: Kiawah Island, Kiawah Resort

Share

• Topics:
• Beach

• Location:
• Kiawah Island, SC, USA

Recent Articles

Partners Trust Sells Vince Vaughn's La Canada Home

Leverage Partner Partners Trust has sold Vince Vaughn's La Cañada home for $4.8...

Home Improvement: Take It Outside

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

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] => 487
            [model] => Location
            [model_id] => 137
            [archived] => 
            [medium_featured] => 1
            [large_featured] => 
            [title] => Location: Kiawah Island
            [author] => LeverageRE
            [date] => 2016-03-30
            [lead_in] => A 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] => 
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. Surfscooter 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.











Be sure to stop at the nearby Johns Island Farmers Market 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.

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. The Roy Barth Tennis Center was ranked number three in the United States by Tennis magazine.



After a full day of activities, visit the Sushi Lounge at the Atlantic Room 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.





Photos courtesy of: Kiawah Island, Kiawah Resort







            [vimeo_id] => 
            [created] => 2016-04-05 14:35:21
            [modified] => 2016-04-11 17:08:39
            [uri] => /articles/view/487/location-kiawah-island
            [flattened_topics] => Array
                (
                    [0] => 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] => 137
            [parent_id] => 8
            [brokerage_id] => 92
            [type] => Exclusive
            [archived] => 
            [use_as_topic] => 
            [name] => Kiawah Island, SC, USA
            [short_name] => Kiawah Island, SC, USA
            [group_index] => 
            [latitude] => 32.608238
            [longitude] => -80.084816
            [country_code] => 
            [north] => 53.700001
            [south] => 19.700001
            [east] => -52.599998
            [west] => -146.600006
            [zoom] => 0
            [short_description] => Kiawah and Seabrook Islands – luxury accommodations amidst championship golf courses and pristine beaches.
            [long_description] => Both Kiawah and Seabrook Islands, just 21 miles south of historic downtown Charleston, offer a unique, rural flavor that attracts nature-lovers, sports enthusiasts and vacation seekers from all over the world.  Guests and residents alike enjoy access to miles of unspoiled beach, seven championship golf courses, tennis, biking, boating, wildlife and so much more.  Local farms provide an abundance of fresh produce, while surrounding creeks and rivers offer fresh “catch of the day”.  Whether you seek views of the ocean, championship fairways, maritime forests or lush marshes, here, you will find your special place.
            [created] => 2016-04-07 15:25:59
            [modified] => 2016-04-07 15:25:59
            [timezone] => America/New_York
            [population] => 1700
            [uri] => /locations/view/137/kiawah-island-sc-usa
            [tile_name] => Kiawah Island, SC, USA
        )

    [Image] => Array
        (
            [0] => Array
                (
                    [id] => 3349
                    [model] => Article
                    [model_id] => 487
                    [tag] => Image
                    [name] => Kiawah-Island.jpg
                    [type] => image/jpg
                    [size] => 904980
                    [uri] => /assets/3349.jpg
                    [order] => 0
                    [created] => 2016-04-05 14:35:21
                    [modified] => 2016-04-11 17:08:39
                )

        )

    [Brokerage] => Array
        (
            [0] => Array
                (
                    [id] => 92
                    [account_executive_id] => 236
                    [archived] => 
                    [type] => development
                    [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] => 0
                    [membership_luxury_feed_properties] => 0
                    [can_participate_in_lux_feed_while_archived] => 
                    [full_training_video_access] => 
                    [country_id] => 0
                    [WOEID] => 2432153
                    [timezone] => 
                    [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] => Pam Harrington Exclusives
                    [broker_of_record_name] => 
                    [short_name] => Pam Harrington Exclusives
                    [username] => PamHarringtonExclusives
                    [password] => d9957a95a4927b3d3325d107e05944a461d55de6
                    [password_reset_hash] => 
                    [monthly_invoice_amount] => 0.00
                    [monthly_invoice_start_date] => 
                    [monthly_invoice_end_date] => 
                    [contract_filename] => 92.pdf
                    [active] => 1
                    [lead_in] => 
                    [short_description] => 
                    [description] => 
Pam Harrington Exclusives is the exclusive representative for Leverage Global Partners in Wadmalaw Island, Seabrook Island, Johns Island, Kiawah Island, South Carolina, USA.

In 1987, Pam Harrington Exclusives began as a small, independent firm amid a sea of large, corporate realty companies and developers competing for business on Kiawah and Seabrook Island. The Pam Harrington Exclusives team quickly established relationships with discerning island homeowners who sought to rent their properties during peak season. Those early relationships continued to grow and served as the foundation upon which our small firm blossomed into the renowned full service real estate company we are today.

With over 30 years of experience in island realty, we enjoy sharing our surroundings. If you're looking for oceanfront, fairway, deep water or secluded marshlands, we'll find it on the islands of Kiawah, Seabrook, Johns or Wadmalaw. If the city suits your fancy, we are equally at home in Charleston. We’ve had the pleasure of helping families get to know Seabrook and Kiawah Island through our seasonal rentals – and the honor of seeing them fall in love with these islands and helping them become permanent members of our community.

As an independent firm, we are free of corporate demands and able to focus on what’s most important – helping our clients find happiness in the beautiful places we are lucky to call home. Distinguished by profound personal attention, Pam Harrington Exclusives has closed over one billion dollars in sales, one transaction at a time.

If you're interested in buying or selling a home or property on Kiawah, Seabrook or the adjacent islands, look no further. We’re proud to represent the beloved island communities whose beauty, value and legacy endure

                    [communities] => Wadmalaw Island 
Seabrook Island
Johns Island
Kiawah Island
                    [website] => http://www.pamharringtonexclusives.com/
                    [address] => 4343 Betsy Kerrison Pkwy
                    [address_2] => 
                    [city] => Johns Island
                    [state] => SC
                    [full_state] => South Carolina
                    [country] => USA
                    [market] => Kiawah Island
                    [market_2] => 
                    [postal_code] => 29455
                    [phone] => Office: (843) 768-3635 
                    [phone_2] => 
                    [phone_3] => 
                    [wide_contact_image] => 
                    [contact_name] => Pam Harrington
                    [contact_profile_link] => 
                    [contact_big_profile_link] => 
                    [contact_big_profile_link_text] => 
                    [contact_title] => President
                    [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] => 92.jpg
                    [logo_filename] => 92.jpg
                    [contact_image_filename] => 92.jpg
                    [all_properties_link_image_filename] => 92.JPG
                    [all_properties_link] => http://www.pamharringtonexclusives.com/real-estate/kiawah-real-estate
                    [video_embed_code] => 
                    [contact_video_embed_code] => 
                    [meta_title] => Kiawah Island Real Estate | Pam Harrington Exclusives | Leverage Global Partners
                    [meta_description] => Pam Harrington Exclusives is the exclusive representative for Leverage Global Partners in Kiawah Island, South Carolina, USA.
                    [meta_keywords] => Kiawah Island Real Estate, Pam Harrington Exclusives, Leverage Global Partners, Wadmalaw Island Real Estate, Seabrook Island Real Estate, Johns Island Real Estate
                    [login_message_counter] => 1
                    [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] => 2014-01-31 18:29:33
                    [modified] => 2019-09-09 11:37:58
                    [dre_num] => 012345
                    [uri] => /development-detail/92/pam-harrington-exclusives
                    [website_short] => www.pamharringtonexclusives.com
                    [name_with_location] => Pam Harrington Exclusives
                    [ArticlesBrokerage] => Array
                        (
                            [id] => 62
                            [article_id] => 487
                            [brokerage_id] => 92
                        )

                )

        )

    [Location] => Array
        (
            [0] => Array
                (
                    [id] => 137
                    [parent_id] => 8
                    [brokerage_id] => 92
                    [type] => Exclusive
                    [archived] => 
                    [use_as_topic] => 
                    [name] => Kiawah Island, SC, USA
                    [short_name] => Kiawah Island, SC, USA
                    [group_index] => 
                    [latitude] => 32.608238
                    [longitude] => -80.084816
                    [country_code] => 
                    [north] => 53.700001
                    [south] => 19.700001
                    [east] => -52.599998
                    [west] => -146.600006
                    [zoom] => 0
                    [short_description] => Kiawah and Seabrook Islands – luxury accommodations amidst championship golf courses and pristine beaches.
                    [long_description] => Both Kiawah and Seabrook Islands, just 21 miles south of historic downtown Charleston, offer a unique, rural flavor that attracts nature-lovers, sports enthusiasts and vacation seekers from all over the world.  Guests and residents alike enjoy access to miles of unspoiled beach, seven championship golf courses, tennis, biking, boating, wildlife and so much more.  Local farms provide an abundance of fresh produce, while surrounding creeks and rivers offer fresh “catch of the day”.  Whether you seek views of the ocean, championship fairways, maritime forests or lush marshes, here, you will find your special place.
                    [created] => 2016-04-07 15:25:59
                    [modified] => 2016-04-07 15:25:59
                    [timezone] => America/New_York
                    [population] => 1700
                    [uri] => /locations/view/137/kiawah-island-sc-usa
                    [tile_name] => Kiawah Island, SC, USA
                    [ArticlesLocation] => Array
                        (
                            [id] => 43
                            [article_id] => 487
                            [location_id] => 137
                        )

                )

        )

    [Property] => Array
        (
        )

    [Topic] => Array
        (
            [0] => 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] => 375
                            [article_id] => 487
                            [topic_id] => 8
                        )

                )

        )

)

• 
• History
  +

  Request History

  4 previous requests available

  • Restore to current request
  • locations/view/87/crested-butte-co-usa
  • locations/view/126/columbia-sc-usa
  • articles/view/450/close-up-surfing-maui
  • contacts/ajax_form?agent_id=330

  ====
• Session
  +

  Session

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

  ====
• Request
  +

  Request

  Cake Params

  • plugin(null)
  • controllerarticles
  • actionview
  • named(empty)
  • pass(array)
    • 0487
    • 1location-kiawah-island
  • 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: 46 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` = 487 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` = (487) 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` = 487 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` = 487 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` = 487 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` = 487 AND `ArticlesTopic`.`topic_id` = `Topic`.`id`)	1	1	0
  SELECT `Article`.`id` FROM `leveragere_staging2`.`articles` AS `Article` WHERE `Article`.`archived` = '0' AND NOT (`Article`.`model` = ('News')) ORDER BY `Article`.`date` DESC LIMIT 10	10	10	2	maybe slow
  SELECT `Article`.`id`, `Article`.`model`, `Article`.`model_id`, `Article`.`archived`, `Article`.`medium_featured`, `Article`.`large_featured`, `Article`.`title`, `Article`.`author`, `Article`.`date`, `Article`.`lead_in`, `Article`.`body`, `Article`.`vimeo_id`, `Article`.`created`, `Article`.`modified` FROM `leveragere_staging2`.`articles` AS `Article` WHERE `Article`.`id` IN (499, 486, 488, 487, 436, 476, 437, 477, 481, 479) ORDER BY RAND() ASC LIMIT 2	2	2	1	maybe slow
  SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (477, 436) 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	2	maybe slow
  SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `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` = 487 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` = (487) 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` = 487 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` = 487 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` = 487 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` = 487 AND `ArticlesTopic`.`topic_id` = `Topic`.`id`)	1	1	0
  SELECT `ArticlesTopic`.`id`, `ArticlesTopic`.`article_id` FROM `leveragere_staging2`.`articles_topics` AS `ArticlesTopic` WHERE `ArticlesTopic`.`topic_id` = (8)	15	15	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 (401, 347, 264, 245, 206, 176, 442, 449, 450, 455, 465, 469, 478, 488, 487) AND `Article`.`id` != 487 AND `Article`.`model` != 'News' AND `Article`.`archived` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	2	maybe slow
  SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (264, 442, 347, 478) ORDER BY `Image`.`order` ASC	4	4	0
  SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `ArticlesBrokerage`.`id`, `ArticlesBrokerage`.`article_id`, `ArticlesBrokerage`.`brokerage_id` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` JOIN `leveragere_staging2`.`articles_brokerages` AS `ArticlesBrokerage` ON (`ArticlesBrokerage`.`article_id` IN (264, 442, 347, 478) 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 (264, 442, 347, 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` IN (264, 442, 347, 478) AND `ArticlesProperty`.`property_id` = `Property`.`id`)	0	0	0
  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 (264, 442, 347, 478) AND `ArticlesTopic`.`topic_id` = `Topic`.`id`)	9	9	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	3	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	13	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 (3732, 3755, 3741, 3756) ORDER BY `Image`.`order` ASC	21	21	12	maybe slow
  SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (3732, 3755, 3741, 3756) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	3	3	0
  SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (3732, 3755, 3741, 3756) AND `PropertiesSecondaryPropertyCategory`.`property_category_id` = `SecondaryPropertyCategory`.`id`)	0	0	0
  SELECT `PropertyFeature`.`id`, `PropertyFeature`.`name`, `PropertyFeature`.`additional`, `PropertyFeature`.`created`, `PropertyFeature`.`modified`, `PropertiesPropertyFeature`.`id`, `PropertiesPropertyFeature`.`property_id`, `PropertiesPropertyFeature`.`property_feature_id` FROM `leveragere_staging2`.`property_features` AS `PropertyFeature` JOIN `leveragere_staging2`.`properties_property_features` AS `PropertiesPropertyFeature` ON (`PropertiesPropertyFeature`.`property_id` IN (3732, 3755, 3741, 3756) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	3	3	1	maybe slow
  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 (3732, 3755, 3741, 3756) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	3	3	1	maybe slow

  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.89 MB
  Controller action start	3.84 MB
  Controller render start	6.63 MB
  View render complete	7.19 MB

  Timers

  Total Request Time: 308 (ms)

  Message	Time in ms	Graph
  Core Processing (Derived from $_SERVER["REQUEST_TIME"])	45.68
  Event: Controller.initialize	5.35
  Event: Controller.startup	1.85
  Controller action	97.88
  Event: Controller.beforeRender	27.75
  » Processing toolbar data	27.64
  Rendering View	98.13
  » Event: View.beforeRender	0.48
  » Rendering APP/View/Articles/view.ctp	4.26
  » » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.15
  » » Rendering APP/View/Elements/sidebar/explore.ctp	0.89
  » » » Rendering APP/View/Elements/explore_tile_small.ctp	0.13
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #2	0.14
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #3	0.12
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #4	0.12
  » » Rendering APP/View/Elements/sidebar/article_list.ctp	0.18
  » » Rendering APP/View/Elements/sidebar/property_search.ctp	0.19
  » » Rendering APP/View/Elements/sidebar/property_list.ctp	1.29
  » » » Rendering APP/View/Elements/static_property_price.ctp	0.40
  » » » Rendering APP/View/Elements/static_property_price.ctp #2	0.15
  » » » Rendering APP/View/Elements/static_property_price.ctp #3	0.16
  » » » Rendering APP/View/Elements/static_property_price.ctp #4	0.15
  » Event: View.afterRender	0.01
  » Event: View.beforeLayout	0.01
  » Rendering APP/View/Layouts/front.ctp	92.57
  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)
        • id3732
        • brokerage_id28
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameModern and Contemporary Private Oasis
        • 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>This contemporary home impresses at every turn. With Koko Crater views, it is quiet, private and feels like you are on a retreat! Designed for entertaining and relaxation, with seamless transition to bring the outdoors in and create a chic, integrated living experience. This modern Masterpiece by architect Jim Schmidt offers a luxurious floor plan that boasts a Zen rock garden, spacious kitchen with huge granite island, full size walk-in pantry, Subzero refrigerator and a spacious family room. Ample laundry room w/sink, front load washer/dryer, granite counter top and new cabinets for storage. Main level master en suite with free standing tub and a generous sized shower. Big walk-in closet with a custom shoe cabinet! Loft and guestroom suite on upper level. Newly finished yoga studio/guest/maid quarters with a kitchenette/half bath with a separate entrance. Every corner of this luxurious home has been carefully designed. A place for your soul to recharge. An oasis for peace and energy!</p>
        • address7938 Hawaii Kai Drive
        • address_2
        • cityHonolulu
        • stateHawaii
        • postal_code96825
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price2150000
        • price_20
        • price_usd2150000
        • price_usd_20
        • statusFor Sale
        • status_last_changed0000-00-00 00:00:00
        • status_last_changed_price_only0000-00-00 00:00:00
        • lease_period
        • price_upon_request(false)
        • bedrooms4
        • bedrooms_20
        • bathrooms4
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet3958
        • 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.eastoahu.com/listing/141232635-150082085/7938-hawaii-kai-drive-honolulu-hi-96825/
        • meta_title
        • meta_description
        • meta_keywords
        • bathrooms_partial1
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built
        • virtual_tour
        • video_tour
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num
        • wsj_property_type
        • nyt_property_type
        • nyt_popular_features
        • propgolux_property_type
        • juwai_property_type
        • juwai_category
        • propgolux_property_style
        • wapo_property_type
        • robb_property_type
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude21.293854
        • longitude21.293854
        • invalid_required_fields
        • invalid_optional_fields
        • went_live_today(false)
        • converted(true)
        • invalid(false)
        • mlsidx_full_address
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2016-04-18 00:33:02
        • created2016-04-15 16:17:51
        • uri/property-detail/3732/7938-hawaii-kai-drive-honolulu-hawaii-96825-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3732/7938-hawaii-kai-drive-honolulu-hawaii-96825-usa
        • address_concat7938 Hawaii Kai Drive Honolulu Hawaii 96825 USA
        • google_maps_query_string7938+Hawaii+Kai+Drive++Honolulu+Hawaii+96825+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 2,150,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty4
        • bathrooms_pretty4
        • bathrooms_partial_pretty1
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms4
        • date_listed2016-04-15
        • overridden_brokerage_nameEast Oahu Realty, RB-16090
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id28
        • account_executive_id236
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties8
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties0
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id1
        • WOEID12485533
        • 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
        • nameEast Oahu Realty, RB-16090
        • broker_of_record_name
        • short_nameEast Oahu Realty
        • usernameEastOahu
        • password184254dea91b6c8586489ec50b8219bece099e54
        • 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>East Oahu Realty is the exclusive representative for Leverage Global Partners in Honolulu, Oahu, Hawaii, USA.</p> <p>In 1992, Jack Leslein, President & Founder of East Oahu Realty, Inc., ventured forward with his dream of creating a real estate company of Realtors that would make a difference. Our mission is to be a pacesetter in real estate services by sharing our knowledge and skillfully guiding our clients beyond their expectations.</p> <p>Specializing in helping clients achieve their real estate objectives and focusing on personalized service and attention, East Oahu Realty became the home of trained and experienced Realtors, state of the art technology and dedicated support staff. East Oahu Realty is able to provide the utmost in professional real estate service.</p> <p>As a locally owned, Kama’aina company, we respect and value our island heritage. We are committed to enhancing the lives of those who reside here by providing the utmost in service and community support. We know our market as well as the economic and social factors that shape it. Our knowledge, combined with our broad base of experience, assures you have the information you need to make an informed decision.</p> <p>We are committed to your success, and we are leaders in our industry and our community. We take an active role in shaping the future of both. We are committed to maintaining our reputation of integrity and honesty.</p> <p>We represent our clients enthusiastically and fairly and have done so since 1992. Choosing can make all the difference.</p> <p>What Our Clients Can Expect:</p> <ul> <li>Premier Market Presence</li> <li>Select Team of Successful Real Estate Professionals</li> <li>Global Networking and Exposure</li> <li>Comprehensive Market Analysis & Plans</li> <li>Member of Luxury Real Estate</li> <li>State of the Art Technology</li> <li>Multi-Lingual Realtors</li> <li>Mortgage Services On-Site</li> </ul>
        • communitiesHonolulu Hawaii HI USA Oahu Hawaii HI USA
        • websitehttp://www.eastoahu.com/
        • address6600 Kalanianaole Hwy # 114
        • address_2
        • cityHonolulu, Oahu
        • stateHI
        • full_stateHawaii
        • countryUSA
        • market
        • market_2
        • postal_code96825
        • phone(808) 791-2216
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameCherie Tsukamoto
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titlePrincipal Broker, RB - 14911
        • contact_dre_num
        • contact_quoteI invite you to contact me personally regarding East Oahu Realty.
        • 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_filename28.jpg
        • logo_filename28.jpg
        • contact_image_filename28.jpg
        • all_properties_link_image_filename28.jpg
        • all_properties_linkhttp://www.eastoahu.com/search/FeaturedListings.aspx
        • video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/4U1wTm0Z-qzxAOUo0.js"></script>
        • contact_video_embed_code
        • meta_titleHonolulu, Oahu Real Estate | East Oahu Realty | Leverage Global Partners
        • meta_descriptionEast Oahu Realty is the exclusive representative for Leverage Global Partners in Oahu, Hawaii, USA.
        • meta_keywordseast oahu realty, oahu real estate, honolulu real estate, oahu hawaii, jack leslein, leverage global partners
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-05-10 18:19:12
        • modified2016-04-08 16:33:22
        • dre_num012345
        • uri/brokerage-detail/28/east-oahu-realty-rb-16090
        • website_shortwww.eastoahu.com
        • name_with_locationEast Oahu Realty, RB-16090
      • 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)
          • id20884
          • modelProperty
          • model_id3732
          • tagImage
          • nameleverage 1.jpg
          • typeimage/jpeg
          • size52421
          • uri/assets/20884.jpg
          • order0
          • created2016-04-15 16:47:48
          • modified2016-04-15 16:47:53
        • 1(array)
          • id20885
          • modelProperty
          • model_id3732
          • tagImage
          • nameleverage 2.jpg
          • typeimage/jpeg
          • size50981
          • uri/assets/20885.jpg
          • order1
          • created2016-04-15 16:47:48
          • modified2016-04-15 16:47:53
        • 2(array)
          • id20886
          • modelProperty
          • model_id3732
          • tagImage
          • nameleverage 3.jpg
          • typeimage/jpeg
          • size59263
          • uri/assets/20886.jpg
          • order2
          • created2016-04-15 16:47:48
          • modified2016-04-15 16:47:53
        • 3(array)
          • id20887
          • modelProperty
          • model_id3732
          • tagImage
          • nameleverage 5.jpg
          • typeimage/jpeg
          • size59957
          • uri/assets/20887.jpg
          • order3
          • created2016-04-15 16:47:48
          • modified2016-04-15 16:47:53
        • 4(array)
          • id20888
          • modelProperty
          • model_id3732
          • tagImage
          • nameleverage 6.jpg
          • typeimage/jpeg
          • size51221
          • uri/assets/20888.jpg
          • order4
          • created2016-04-15 16:47:48
          • modified2016-04-15 16:47:53
        • 5(array)
          • id20889
          • modelProperty
          • model_id3732
          • tagImage
          • nameleverage 4.jpg
          • typeimage/jpeg
          • size72224
          • uri/assets/20889.jpg
          • order5
          • created2016-04-15 16:47:48
          • modified2016-04-15 16:47:53
        • 6(array)
          • id20891
          • modelProperty
          • model_id3732
          • tagImage
          • nameleverage 8.jpg
          • typeimage/jpeg
          • size72084
          • uri/assets/20891.jpg
          • order6
          • created2016-04-15 16:47:49
          • modified2016-04-15 16:47:53
        • 7(array)
          • id20892
          • modelProperty
          • model_id3732
          • tagImage
          • nameleverage 9.jpg
          • typeimage/jpeg
          • size54571
          • uri/assets/20892.jpg
          • order7
          • created2016-04-15 16:47:49
          • modified2016-04-15 16:47:53
        • 8(array)
          • id20893
          • modelProperty
          • model_id3732
          • tagImage
          • nameleverage 7.jpg
          • typeimage/jpeg
          • size63051
          • uri/assets/20893.jpg
          • order8
          • created2016-04-15 16:47:50
          • modified2016-04-15 16:47:53
      • User(array)
        • 0(array)
          • id1276
          • typeAgent
          • brokerage_id28
          • email[email protected]
          • passworda992f8ca84fdd6442933402b26af8813256403e7
          • recover_hash
          • first_nameSakina
          • last_nameClaytor
          • title
          • dre_num
          • phone808-594-9044
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2017-08-07 15:24:02
          • created2017-08-07 15:24:02
          • notified(false)
          • full_nameSakina Claytor
          • uri/agent-detail/1276/sakina-claytor
          • profile_complete(true)
          • UsersProperty(array)
            • id1102
            • user_id1276
            • property_id3732
            • sort_order0
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(array)
        • 0(array)
          • id4
          • nameGarage
          • additional(false)
          • created2016-04-07 14:01:52
          • modified2016-04-07 14:01:52
          • PropertiesPropertyFeature(array)
            • id4401
            • property_id3732
            • property_feature_id4
      • Topic(array)
        • 0(array)
          • id12
          • nameModern Architecture
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:33:26
          • tile_nameModern Architecture
          • PropertiesTopic(array)
            • id39
            • property_id3732
            • topic_id12
    • 1(array)
      • Property(array)
        • id3755
        • brokerage_id244
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameSunset Strip Complex
        • incomplete(false)
        • archived(false)
        • last_archived0000-00-00 00:00:00
        • auto_archived_from_mlsidx(false)
        • paid_featured(false)
        • featured(false)
        • homepage_featured(false)
        • brokerage_page_featured(true)
        • requested_homepage_featured_by_member(false)
        • homepage_featured_by_member(false)
        • dot_luxury_featured(false)
        • luxury_feed_featured(false)
        • force_luxury_feed_featured(false)
        • luxury_autofeed_imported(false)
        • luxury_feed_last_added_time0000-00-00 00:00:00
        • luxury_feed_agent_user_id0
        • luxury_feed_locked_to_subscription_id0
        • luxury_feed_agent_purchase_date0000-00-00
        • luxury_feed_agent_expiration_date0000-00-00
        • digital_ad_summary_email_last_sent0000-00-00 00:00:00
        • digital_ad_summary_price_changed(true)
        • wsj_detail_url
        • ft_detail_url
        • nyt_detail_url
        • juwai_detail_url
        • pgl_detail_url
        • mg_detail_url
        • mg_c_detail_url
        • mg_s_detail_url
        • bp_detail_url
        • mw_detail_url
        • nikkei_detail_url
        • wapo_detail_url
        • robb_detail_url
        • medium_featured(false)
        • large_featured(false)
        • detail_page(false)
        • description<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris ut gravida metus, sit amet ornare nisl. In sed velit magna. Vestibulum convallis, lectus eu luctus aliquam, velit mi suscipit nibh, eget ullamcorper nunc turpis vehicula dolor. Quisque aliquet eros nec nibh accumsan, sed suscipit risus pharetra. Curabitur condimentum porta dolor, eget porta erat placerat id. Curabitur eget mollis leo, et ornare dolor. Mauris eget dui libero. Interdum et malesuada fames ac ante ipsum primis in faucibus. Phasellus consequat diam et magna molestie, at condimentum ipsum consequat.</p>
        • address9255 Swallow Drive
        • address_2
        • cityLos Angeles
        • stateCA
        • postal_code90069
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price12000000
        • price_20
        • price_usd12000000
        • 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)
        • bedrooms0
        • bedrooms_20
        • bathrooms0
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet0
        • square_meters
        • acres0
        • interior_unitsq_ft
        • interior_size0
        • lot_unitacres
        • lot_size0
        • icon_1
        • icon_2
        • icon_3
        • icon_4
        • icon_5
        • icon_6
        • website
        • meta_title
        • meta_description
        • meta_keywords
        • bathrooms_partial0
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built
        • virtual_tour
        • video_tour
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num
        • wsj_property_type
        • nyt_property_type
        • nyt_popular_features
        • propgolux_property_type
        • juwai_property_type
        • juwai_category
        • propgolux_property_style
        • wapo_property_type
        • robb_property_type
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude34.104874
        • longitude-118.389793
        • invalid_required_fields
        • invalid_optional_fields
        • went_live_today(false)
        • converted(false)
        • invalid(false)
        • mlsidx_full_address
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2019-10-31 00:13:54
        • created2019-10-31 00:13:45
        • uri/property-detail/3755/9255-swallow-drive-los-angeles-ca-90069-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3755/9255-swallow-drive-los-angeles-ca-90069-usa
        • address_concat9255 Swallow Drive Los Angeles CA 90069 USA
        • google_maps_query_string9255+Swallow+Drive++Los+Angeles+CA+90069+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 12,000,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty0
        • bathrooms_pretty0
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms0
        • date_listed2019-10-31
        • overridden_brokerage_nameSmith & Berg
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id244
        • account_executive_id0
        • archived(false)
        • typeteam
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typeBasic
        • max_properties10
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties0
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id0
        • WOEID(null)
        • timezoneAmerica/Los_Angeles
        • 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
        • nameSmith & Berg
        • broker_of_record_nameCompass
        • short_nameSmith & Berg
        • username
        • password
        • password_reset_hash
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename
        • active(true)
        • lead_inYou've tried the rest, now try the best
        • short_description
        • description<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>
        • communitiesLos Angeles
        • websitehttps://compass.com
        • address680 E. Colorado Blvd
        • address_2Suite 150
        • cityPasadena
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • market
        • market_2
        • postal_code91101
        • phone8888888888
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameF. Ron Smith
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titlePrincipal
        • contact_dre_num11624555
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone565-135-7745
        • 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_2878-829-1672
        • contact_website
        • contact_name_2Chris Stephonovich
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2Associate Realtor
        • contact_dre_num_241768321
        • contact_email_3[email protected]
        • contact_name_3Courtney P. Wolpertinger
        • contact_title_3Associate Realtor
        • contact_dre_num_384919983
        • contact_phone_3158-646-8246
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename
        • logo_filename
        • contact_image_filename
        • all_properties_link_image_filename
        • all_properties_link
        • video_embed_code
        • contact_video_embed_code
        • meta_title
        • meta_description
        • meta_keywords
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(false)
        • created2019-10-31 00:07:13
        • modified2021-07-18 10:40:16
        • dre_num012345
        • uri/team-detail/244/smith-berg
        • website_shortcompass.com
        • name_with_locationSmith & Berg
      • 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)
          • id23088
          • modelProperty
          • model_id3755
          • tagImage
          • name7ab079e6d3fcc3f540f780f5080587df8beb7d73.jpeg
          • typeimage/jpeg
          • size520160
          • uri/assets/23088.jpeg
          • order0
          • created2019-10-31 00:13:42
          • modified2019-10-31 00:13:45
      • User(empty)
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(empty)
      • Topic(empty)
    • 2(array)
      • Property(array)
        • id3741
        • brokerage_id3
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameModern, Updated Ranch Home with Mesmerizing Ocean Views
        • incomplete(false)
        • archived(false)
        • last_archived0000-00-00 00:00:00
        • auto_archived_from_mlsidx(false)
        • paid_featured(false)
        • featured(false)
        • homepage_featured(false)
        • brokerage_page_featured(false)
        • requested_homepage_featured_by_member(false)
        • homepage_featured_by_member(false)
        • dot_luxury_featured(false)
        • luxury_feed_featured(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>Palisades modern ranch with mesmerizing ocean views by renowned architect, David Kellen. A special updated home, perched on a promontory above the street on a 16,000 ft. lot with abundant natural light and bright, open spaces. Enter into an open living, dining, and music room, which leads seamlessly to the large grassy backyard area with pool. Sleek and simple modern kitchen with breakfast nook. Two bedroom suites (including a junior master) and a den downstairs, all opening to the lovely outdoors. Upstairs is a breathtaking master suite with open loft style walls with oversized windows and sweeping ocean, city and canyon views. Additional bedroom suite upstairs.</p>
        • address545 Catalonia Avenue
        • address_2
        • cityPacific Palisades
        • stateCA
        • postal_code90272
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price2995000
        • price_20
        • price_usd2995000
        • price_usd_20
        • statusFor Sale
        • status_last_changed0000-00-00 00:00:00
        • status_last_changed_price_only0000-00-00 00:00:00
        • lease_period
        • price_upon_request(false)
        • bedrooms4
        • bedrooms_20
        • bathrooms5
        • 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://545cataloniaavenue.thepartnerstrust.com/
        • meta_title
        • meta_description
        • meta_keywords
        • bathrooms_partial0
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built1955
        • virtual_tour
        • video_tourhttp://www.onvedeo.com/properties/755499/embed
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num16112996
        • 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.047157
        • longitude34.047157
        • 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)
        • modified2024-10-24 08:39:37
        • created2016-04-18 09:57:58
        • uri/property-detail/3741/545-catalonia-avenue-pacific-palisades-ca-90272-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3741/545-catalonia-avenue-pacific-palisades-ca-90272-usa
        • address_concat545 Catalonia Avenue Pacific Palisades CA 90272 USA
        • google_maps_query_string545+Catalonia+Avenue++Pacific+Palisades+CA+90272+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 2,995,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty4
        • bathrooms_pretty5
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms5
        • 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)
        • id3
        • account_executive_id236
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties12
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties2
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(true)
        • country_id1
        • WOEID2442047
        • 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
        • usernamePartnersTrustLA
        • password165bb7b526009554e197bcf82dabaa84ae727155
        • 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 Los Angeles, 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.</p> <p>As a company, we offer our associates and clients a level of technology and communication unmatched in today’s real estate market. Los Angeles provides the ideal canvas to make your dream become a reality.</p> <p>We live, work, and entertain everywhere, from our beautiful beaches and the vibrant, newly revitalized downtown to the expansive mountain ranges overlooking the serene desert landscapes. With a culture that attracts celebrities, sports figures and entrepreneurs, the Southern California lifestyle is in high demand. Great representation in this real estate market is essential.</p> <p>Our associates proudly handle all types of homes, ranging from the architectural estate to the contemporary condominium to the historic, traditional home. Each property and client is represented with the highest quality of presentation and service, leading to unparalleled success.</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/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/5/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Pasadena</a>, <a href="../../../brokerage-detail/142/Partners-Trust-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>
        • communitiesLos Angeles Brentwood West Los Angeles
        • websitehttp://thepartnerstrust.com
        • address11726 San Vicente Blvd
        • address_2Suite 350
        • cityLos Angeles
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • marketLos Angeles
        • market_2
        • postal_code90049
        • phone(310) 500-1388
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameNick Segal
        • contact_profile_link
        • contact_big_profile_linkhttp://www.leveragere.com/blog/presidential-profile-partners-trust-real-estate-brokerage-aquisitions-nick-segal/
        • contact_big_profile_link_text
        • contact_titlePresident/Co-Founder
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename3.jpg
        • logo_filename3.png
        • contact_image_filename3.jpg
        • all_properties_link_image_filename3.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_titleLos Angeles Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
        • meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Los Angeles, CA is a premier boutique real estate brokerage, serving home buyers and sellers in the Los Angeles real estate market.
        • meta_keywordspartners trust, Partners Trust Real Estate, los angeles real estate, nick segal, 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:09:20
        • modified2016-04-08 16:33:22
        • dre_num012345
        • uri/brokerage-detail/3/partners-trust-real-estate-brokerage-and-acquisitions
        • website_shortthepartnerstrust.com
        • name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
      • StripeSubscription(array)
        • id(null)
        • brokerage_id(null)
        • user_id(null)
        • property_id(null)
        • type(null)
        • stripe_id(null)
        • stripe_customer_id(null)
        • stripe_checkout_email(null)
        • stripe_promotion_code(null)
        • stripe_promotion_code_id(null)
        • stripe_coupon_code_id(null)
        • status(null)
        • current_period_end(null)
        • cancel_at_period_end(null)
        • ended(null)
        • last_change(null)
        • last_activity_email_sent(null)
        • created(null)
        • modified(null)
      • GlobalReachReport(array)
        • id(null)
        • property_id(null)
        • wsj_desktop(null)
        • wsj_mobile(null)
        • wsj_expires(null)
        • wsj_capture_started(null)
        • mg_desktop(null)
        • mg_mobile(null)
        • mg_expires(null)
        • mg_capture_started(null)
        • bp_desktop(null)
        • bp_mobile(null)
        • bp_expires(null)
        • gp_capture_started(null)
        • mw_desktop(null)
        • mw_mobile(null)
        • mw_expires(null)
        • mw_capture_started(null)
        • ft_desktop(null)
        • ft_mobile(null)
        • ft_expires(null)
        • ft_capture_started(null)
        • nikkei_desktop(null)
        • nikkei_mobile(null)
        • nikkei_expires(null)
        • nikkei_capture_started(null)
        • pgl_desktop(null)
        • pgl_mobile(null)
        • pgl_expires(null)
        • pgl_capture_started(null)
        • robb_desktop(null)
        • robb_mobile(null)
        • robb_expires(null)
        • robb_capture_started(null)
        • juwai_desktop(null)
        • juwai_mobile(null)
        • juwai_expires(null)
        • juwai_capture_started(null)
        • leverage_desktop(null)
        • leverage_mobile(null)
        • leverage_expires(null)
        • leverage_capture_started(null)
        • created(null)
        • modified(null)
        • wsj_available(false)
        • wsj_expired(true)
        • wsj_desktop_proxy_screenshot(null)
        • wsj_mobile_proxy_screenshot(null)
        • mg_available(false)
        • mg_expired(true)
        • mg_desktop_proxy_screenshot(null)
        • mg_mobile_proxy_screenshot(null)
        • bp_available(false)
        • bp_expired(true)
        • bp_desktop_proxy_screenshot(null)
        • bp_mobile_proxy_screenshot(null)
        • mw_available(false)
        • mw_expired(true)
        • mw_desktop_proxy_screenshot(null)
        • mw_mobile_proxy_screenshot(null)
        • nikkei_available(false)
        • nikkei_expired(true)
        • nikkei_desktop_proxy_screenshot(null)
        • nikkei_mobile_proxy_screenshot(null)
        • pgl_available(false)
        • pgl_expired(true)
        • pgl_desktop_proxy_screenshot(null)
        • pgl_mobile_proxy_screenshot(null)
        • robb_available(false)
        • robb_expired(true)
        • robb_desktop_proxy_screenshot(null)
        • robb_mobile_proxy_screenshot(null)
        • juwai_available(false)
        • juwai_expired(true)
        • juwai_desktop_proxy_screenshot(null)
        • juwai_mobile_proxy_screenshot(null)
        • capture_processing(false)
        • capture_error(empty)
      • Image(array)
        • 0(array)
          • id20971
          • modelProperty
          • model_id3741
          • tagImage
          • name545Catalonia_LoRes_(1_of_33).jpg.jpg
          • typeimage/jpeg
          • size449059
          • uri/assets/20971.jpg
          • order0
          • created2016-04-18 09:57:16
          • modified2024-10-24 08:39:26
        • 1(array)
          • id20968
          • modelProperty
          • model_id3741
          • tagImage
          • name545Catalonia_HiRes_(6_of_33).jpg.jpg
          • typeimage/jpeg
          • size273879
          • uri/assets/20968.jpg
          • order1
          • created2016-04-18 09:57:16
          • modified2024-10-24 08:39:26
        • 2(array)
          • id20970
          • modelProperty
          • model_id3741
          • tagImage
          • name545Catalonia_LoRes_(5_of_33).jpg.jpg
          • typeimage/jpeg
          • size360705
          • uri/assets/20970.jpg
          • order2
          • created2016-04-18 09:57:16
          • modified2024-10-24 08:39:26
        • 3(array)
          • id20964
          • modelProperty
          • model_id3741
          • tagImage
          • name545Catalonia_HiRes_(11_of_33).jpg.jpg
          • typeimage/jpeg
          • size210712
          • uri/assets/20964.jpg
          • order3
          • created2016-04-18 09:57:15
          • modified2024-10-24 08:39:26
        • 4(array)
          • id20963
          • modelProperty
          • model_id3741
          • tagImage
          • name545Catalonia_HiRes_(22_of_33).jpg.jpg
          • typeimage/jpeg
          • size155986
          • uri/assets/20963.jpg
          • order4
          • created2016-04-18 09:57:15
          • modified2024-10-24 08:39:26
        • 5(array)
          • id20966
          • modelProperty
          • model_id3741
          • tagImage
          • name545Catalonia_HiRes_(16_of_33).jpg.jpg
          • typeimage/jpeg
          • size310096
          • uri/assets/20966.jpg
          • order5
          • created2016-04-18 09:57:15
          • modified2024-10-24 08:39:26
        • 6(array)
          • id20965
          • modelProperty
          • model_id3741
          • tagImage
          • name545Catalonia_HiRes_(13_of_33).jpg.jpg
          • typeimage/jpeg
          • size291598
          • uri/assets/20965.jpg
          • order6
          • created2016-04-18 09:57:15
          • modified2024-10-24 08:39:26
        • 7(array)
          • id20969
          • modelProperty
          • model_id3741
          • tagImage
          • name545Catalonia_HiRes_(18_of_33).jpg.jpg
          • typeimage/jpeg
          • size255914
          • uri/assets/20969.jpg
          • order7
          • created2016-04-18 09:57:16
          • modified2024-10-24 08:39:26
        • 8(array)
          • id20967
          • modelProperty
          • model_id3741
          • tagImage
          • name545Catalonia_HiRes_(3_of_33).jpg.jpg
          • typeimage/jpeg
          • size301571
          • uri/assets/20967.jpg
          • order8
          • created2016-04-18 09:57:16
          • modified2024-10-24 08:39:26
        • 9(array)
          • id20972
          • modelProperty
          • model_id3741
          • tagImage
          • name545Catalonia_LoRes_(30_of_33).jpg.jpg
          • typeimage/jpeg
          • size493336
          • uri/assets/20972.jpg
          • order9
          • created2016-04-18 09:57:16
          • modified2024-10-24 08:39:26
      • User(array)
        • 0(array)
          • id1173
          • typeAgent
          • brokerage_id3
          • email[email protected]
          • passwordba579c44380627d37c115b910cd6401d0a7a4a71
          • recover_hash
          • first_nameRichard
          • last_nameStearns
          • title
          • dre_num
          • phone310.850.9284
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2017-08-07 15:23:56
          • created2017-08-07 15:23:56
          • notified(false)
          • full_nameRichard Stearns
          • uri/agent-detail/1173/richard-stearns
          • profile_complete(true)
          • UsersProperty(array)
            • id1130
            • user_id1173
            • property_id3741
            • sort_order0
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(array)
        • 0(array)
          • id14
          • nameViews
          • additional(false)
          • created2016-04-07 14:04:55
          • modified2016-04-07 14:04:55
          • PropertiesPropertyFeature(array)
            • id4753
            • property_id3741
            • property_feature_id14
        • 1(array)
          • id12
          • nameSwimming Pool
          • additional(false)
          • created2016-04-07 14:04:12
          • modified2016-04-07 14:04:12
          • PropertiesPropertyFeature(array)
            • id4752
            • property_id3741
            • property_feature_id12
      • Topic(array)
        • 0(array)
          • id12
          • nameModern Architecture
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:33:26
          • tile_nameModern Architecture
          • PropertiesTopic(array)
            • id58
            • property_id3741
            • topic_id12
        • 1(array)
          • id4
          • nameKiller Views
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:33:10
          • tile_nameKiller Views
          • PropertiesTopic(array)
            • id57
            • property_id3741
            • topic_id4
    • 3(array)
      • Property(array)
        • id3756
        • brokerage_id244
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameHistoric landmark estate in Langham area of Pasadena
        • incomplete(false)
        • archived(false)
        • last_archived0000-00-00 00:00:00
        • auto_archived_from_mlsidx(false)
        • paid_featured(false)
        • featured(false)
        • homepage_featured(false)
        • brokerage_page_featured(true)
        • requested_homepage_featured_by_member(false)
        • homepage_featured_by_member(false)
        • dot_luxury_featured(false)
        • luxury_feed_featured(false)
        • force_luxury_feed_featured(false)
        • luxury_autofeed_imported(false)
        • luxury_feed_last_added_time0000-00-00 00:00:00
        • luxury_feed_agent_user_id0
        • luxury_feed_locked_to_subscription_id0
        • luxury_feed_agent_purchase_date0000-00-00
        • luxury_feed_agent_expiration_date0000-00-00
        • digital_ad_summary_email_last_sent0000-00-00 00:00:00
        • digital_ad_summary_price_changed(true)
        • wsj_detail_url
        • ft_detail_url
        • nyt_detail_url
        • juwai_detail_url
        • pgl_detail_url
        • mg_detail_url
        • mg_c_detail_url
        • mg_s_detail_url
        • bp_detail_url
        • mw_detail_url
        • nikkei_detail_url
        • wapo_detail_url
        • robb_detail_url
        • medium_featured(false)
        • large_featured(false)
        • detail_page(false)
        • description<p>Designed by well known Arts and Crafts movement architects Arthur and Alfred Heineman. In addition to the main house there is a 1,000 sq ft guest house and a 1,476 sq ft finished basement. This home is under The Mills Act which offers reduced property tax.</p>
        • address1330 Hillcrest Avenue
        • address_2
        • cityPasadena
        • stateCA
        • postal_code91106
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price6500000
        • price_20
        • price_usd6500000
        • 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)
        • bedrooms0
        • bedrooms_20
        • bathrooms0
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet10764
        • square_meters
        • acres0.459137
        • interior_unitsq_m
        • interior_size1000
        • lot_unitsq_ft
        • lot_size20000
        • icon_1
        • icon_2
        • icon_3
        • icon_4
        • icon_5
        • icon_6
        • website
        • meta_title
        • meta_description
        • meta_keywords
        • bathrooms_partial0
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built
        • virtual_tour
        • video_tour
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num
        • wsj_property_type
        • nyt_property_type
        • nyt_popular_features
        • propgolux_property_type
        • juwai_property_type
        • juwai_category
        • propgolux_property_style
        • wapo_property_type
        • robb_property_type
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude34.124477
        • longitude-118.131401
        • invalid_required_fields
        • invalid_optional_fields
        • went_live_today(false)
        • converted(false)
        • invalid(false)
        • mlsidx_full_address
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2021-10-20 14:10:15
        • created2019-10-31 00:14:48
        • uri/property-detail/3756/1330-hillcrest-avenue-pasadena-ca-91106-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3756/1330-hillcrest-avenue-pasadena-ca-91106-usa
        • address_concat1330 Hillcrest Avenue Pasadena CA 91106 USA
        • google_maps_query_string1330+Hillcrest+Avenue++Pasadena+CA+91106+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 6,500,000
        • interior_unit_prettySq. M.
        • lot_unit_prettySq. Ft.
        • bedrooms_pretty0
        • bathrooms_pretty0
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms0
        • date_listed2019-10-31
        • overridden_brokerage_nameSmith & Berg
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id244
        • account_executive_id0
        • archived(false)
        • typeteam
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typeBasic
        • max_properties10
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties0
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id0
        • WOEID(null)
        • timezoneAmerica/Los_Angeles
        • 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
        • nameSmith & Berg
        • broker_of_record_nameCompass
        • short_nameSmith & Berg
        • username
        • password
        • password_reset_hash
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename
        • active(true)
        • lead_inYou've tried the rest, now try the best
        • short_description
        • description<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>
        • communitiesLos Angeles
        • websitehttps://compass.com
        • address680 E. Colorado Blvd
        • address_2Suite 150
        • cityPasadena
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • market
        • market_2
        • postal_code91101
        • phone8888888888
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameF. Ron Smith
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titlePrincipal
        • contact_dre_num11624555
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone565-135-7745
        • 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_2878-829-1672
        • contact_website
        • contact_name_2Chris Stephonovich
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2Associate Realtor
        • contact_dre_num_241768321
        • contact_email_3[email protected]
        • contact_name_3Courtney P. Wolpertinger
        • contact_title_3Associate Realtor
        • contact_dre_num_384919983
        • contact_phone_3158-646-8246
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename
        • logo_filename
        • contact_image_filename
        • all_properties_link_image_filename
        • all_properties_link
        • video_embed_code
        • contact_video_embed_code
        • meta_title
        • meta_description
        • meta_keywords
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(false)
        • created2019-10-31 00:07:13
        • modified2021-07-18 10:40:16
        • dre_num012345
        • uri/team-detail/244/smith-berg
        • website_shortcompass.com
        • name_with_locationSmith & Berg
      • 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)
          • id23089
          • modelProperty
          • model_id3756
          • tagImage
          • name8d7f54a999bc95b7b618e15d75d5f37072fe28cd.jpeg
          • typeimage/jpeg
          • size460522
          • uri/assets/23089.jpeg
          • order0
          • created2019-10-31 00:14:45
          • modified2021-10-20 14:10:05
      • User(array)
        • 0(array)
          • id1286
          • typeAgent
          • brokerage_id244
          • email[email protected]
          • passwordb04bb448b10ef979db88d5bbb12f5dca893bbf65
          • recover_hash
          • first_nameSmithberg
          • last_nameTester
          • title
          • dre_num123654
          • phone8888888888
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2020-06-09 13:36:25
          • created2020-06-09 13:36:25
          • notified(false)
          • full_nameSmithberg Tester
          • uri/agent-detail/1286/smithberg-tester
          • profile_complete(true)
          • UsersProperty(array)
            • id1118
            • user_id1286
            • property_id3756
            • sort_order0
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(empty)
      • Topic(empty)
  • sidebar_articles(array)
    • 0(array)
      • Article(array)
        • id264
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(false)
        • large_featured(false)
        • titleTop 10 Ocean View Properties
        • authorLeverageRE
        • date2014-08-05
        • lead_inEnjoy the pure, natural splendor of the ocean by living close to the beach, waking up and going to sleep each evening with the calming sound of the waves as they crash onto the shore. This dream can be yours if you lived here.
        • body <p>Open the door to these spectacular properties with incredible ocean views from some of our Leverage Global Partners:</p> <h1> <strong>1. The Pier House</strong><br> Represented by Partners Trust Real Estate Brokerage & Acquisitions</h1> <p><img src="/assets/1022.jpg" class="pure-img"></p> <p>This spectacular contemporary Malibu home features walls of glass that look out onto the sparkling Pacific Ocean.</p> <h1> <strong>2. Secluded Bayfront Residence</strong><br> Represented by Moorings Realty Inc.</h1> <p><img src="/assets/1023.jpg" class="pure-img"></p> <p>Located in a private enclave of Key Largo, this secluded Florida residence offers gorgeous views of the Keys.</p> <h1> <strong>3. Villa Kismet</strong><br> Represented by Timothy Real Estate Group</h1> <p><img src="/assets/1024.jpg" class="pure-img"></p> <p>Villa Kismet is a spectacular beachfront home with breathtaking views of the Pacific and Zen-like oceanfront gardens.</p> <h1> <strong>4. Puako Oceanfront</strong><br> Represented by Mauna Kea Realty</h1> <p><img src="/assets/1025.jpg" class="pure-img"></p> <p>Situated in idyllic Kamuela, Hawaii, this custom oceanfront home features views of the beautiful Pacific Ocean.</p> <h1> <strong>5. Hawaiian Style Waterfront Home</strong><br> Represented by East Oahu Realty</h1> <p><img src="/assets/1026.jpg" class="pure-img"></p> <p>This Hawaiian style home in Honolulu offers stunning ocean views and your own private beach.</p> <h1> <strong>6. Bandon Ocean View Executive Retreat</strong><br> Represented by Bandon Property</h1> <p><img src="/assets/1027.jpg" class="pure-img"></p> <p>This chic retreat in Bandon, Oregon has a stunning great room with views of the Pacific Ocean and the Offshore Islands Wildlife Refuge.</p> <h1> <strong>7. Historical Beachfront Home</strong><br> Represented by Pam Harrington Exclusives</h1> <p><img src="/assets/1028.jpg" class="pure-img"></p> <p>A fabulous beachfront home in Johns Island offers a private boardwalk to the beach and panoramic ocean views.</p> <h1> <strong>8. Atlântico Estoril Residence Condominium</strong><br> Represented by Porta da Frente</h1> <p><img src="/assets/1029.jpg" class="pure-img"></p> <p>Enjoy resort style living in these ultra luxurious condominiums in Lisbon, Portugal with ocean views from the large verandas and terraces.</p> <h1> <strong>9. Fort Lauderdale Beach</strong><br> Represented by Intercoastal Realty</h1> <p><img src="/assets/1030.jpg" class="pure-img"></p> <p>A luxxe penthouse in Fort Lauderdale has custom high-end features and finishes and offers unobstructed ocean views.</p> <h1> <strong>10. Contemporary Oceanside Retreat</strong><br> Represented by Pack Maynard & Associates</h1> <p><img src="/assets/1031.jpg" class="pure-img"></p> <p>This contemporary oceanside property in Kennebunkport, Maine offers serene 180-degree vistas of the Atlantic Ocean.</p> <p>Do you dream of an ocean view? Please share your thoughts by leaving your comments below.</p>
        • vimeo_id
        • created2016-02-25 14:11:43
        • modified2016-04-05 14:41:07
        • uri/articles/view/264/top-10-ocean-view-properties
        • flattened_topics(array)
          • 0Killer Views
          • 1Beach
      • 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)
          • id1032
          • modelArticle
          • model_id264
          • tagImage
          • nameOcean-View-Thumb.jpg
          • typeimage/jpg
          • size347407
          • uri/assets/1032.jpg
          • order0
          • created2016-02-25 14:11:44
          • modified2016-03-15 16:23:51
      • Brokerage(empty)
      • Location(empty)
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id4
          • nameKiller Views
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:33:10
          • tile_nameKiller Views
          • ArticlesTopic(array)
            • id138
            • article_id264
            • topic_id4
        • 1(array)
          • id8
          • nameBeach
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:30:26
          • tile_nameBeach
          • ArticlesTopic(array)
            • id139
            • article_id264
            • topic_id8
    • 1(array)
      • Article(array)
        • id442
        • modelLocation
        • model_id146
        • archived(false)
        • medium_featured(true)
        • large_featured(false)
        • titleLocation: Costa Rica
        • authorLeverageRE
        • date2016-03-28
        • lead_inPura vida isn't as much a mantra in Costa Rica as it is the thing that softly lures you back to this easygoing coastal country time after time. The "pure life" here revolves around happiness and living life to the fullest. Nowhere does that seem easier to do than in this well-rounded Central American state, which is filled with leafy rain forests, smoking volcanoes, and white-sand beaches. With about 4.8 million residents, Costa Rica is home to ample coastal area, and includes four distinctive regions: San José, Guanacaste, Puntarenas, and Alajuela.
        • body<p><img class="aligncenter wp-image-12870 pure-img" src="/assets/3078.png" /></p> <p>Leverage Partner <a href="http://www.leveragere.com/brokerage-detail/85/Plantaci%C3%B3n-Properties">Plantación Properties</a> has recognized each for unique, defining characteristics: San José, the capital; Guanacaste, with its ultra-blue waters; Puntarenas, a small, compact island; and the historic, stately city of Alajuela. San José showcases a mix of Victorian structures and more modern concrete buildings. The small but mighty Pre-Columbian Gold Museum, for instance, displays lavish trinkets from history, while nightclubs and dancehalls offer evening entertainment throughout the city. It's this juxtaposition of modernity and history, however, and the locals' ability to find pura vida that makes Costa Rica's capital stand out. Meanwhile, the Guanacaste region, home to striking marine waters and ultra-green landscapes, is more travel-friendly. Our favorite beaches, restaurants, and ways to while away the hours in each region follow here:</p> <p><strong>LOS ALTOS DE EROS BOUTIQUE HOTEL & SPA</strong>  This unrivaled Costa Rica Spa invites you to embark on the most pleasurable journey of your life. Unlike any other, Spa de Eros is composed of five private treatment rooms overlooking awe-inspiring views of the tropical forest and Pacific Ocean. Spa de Eros offers a range of rejuvenating treatments performed by highly qualified massage therapists. Services include everything from deep tissue massage and body scrubs to a soak in an ocean-view Indonesian tub.</p> <p><img class="aligncenter wp-image-12867 pure-img" src="/assets/3079.jpg" /></p> <p><strong>DRAKE BAY</strong>  Named for Sir Francis Drake, who was believed to have traveled here in the 16th century, Drake Bay is the place for thrill lovers who, like Drake himself, delight in exploring the land.</p> <p><img class="aligncenter wp-image-12862 pure-img" src="/assets/3080.png" /></p> <p><strong>ESCAZU</strong>  In the San José region, Avenida Escazu offers an updated, modern view of Costa Rican life.</p> <p><strong>PLAYAS DEL COCO</strong>  This beach town enjoys its status as a tourist hub. It recently opened a spectacular Hard Rock Cafe.</p> <p><img class="aligncenter wp-image-12863 pure-img" src="/assets/3081.png" /></p> <p><strong>GRECIA</strong>  With beautiful parks and a stunning red cathedral, this traditional Costa Rican town is worth exploring.</p> <p><strong>OSO PENINSULA</strong>  If you came to Costa Rica in search of the rain forest, look no further. This area boasts some of the leafiest landscapes in the world-plus it holds 2.5 percent of the world's biodiversity.</p> <p><img class="aligncenter wp-image-12864 pure-img" src="/assets/3082.png" /></p> <p><strong>EL LAGARTO</strong>  We love this restaurant as much for its tasty barbecue as for its stunning sunset views.</p> <p><strong>CORCOVADO NATIONAL PARK</strong>  Within the limits of this national park, you'll find 13 ecosystems that support all manner of wildlife and vegetation.</p> <p><img class="aligncenter wp-image-12865 pure-img" src="/assets/3083.png" /></p> <p><strong>MUSEO NACIONAL DE COSTA RICA</strong>  Originally a military barracks, this museum opened its doors in 1950 and houses important artifacts from Costa Rican history.</p> <p><strong>PLAYA DANTA</strong>  This popular beach in Las Cantinas is also home to plenty of great restaurants, like La Limonada.</p> <p><img class="aligncenter wp-image-12866 pure-img" src="/assets/3084.png" /></p> <p><strong>COCO LOCO</strong>  While we wouldn't exactly classify it as "Margaritaville," there's a certain je ne sais quoi about this beachfront bar. Order a round of drinks and watch the sun dip into the marine waters.</p> <p><img class="aligncenter wp-image-12861 pure-img" src="/assets/3085.png" /></p>
        • vimeo_id
        • created2016-04-05 14:30:25
        • modified2016-04-11 17:06:15
        • uri/articles/view/442/location-costa-rica
        • flattened_topics(array)
          • 0Voice from the Street
          • 1Beach
      • 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)
        • id146
        • parent_id3
        • brokerage_id85
        • typeExclusive
        • archived(false)
        • use_as_topic(true)
        • name San Jose, Costa Rica
        • short_name San Jose, Costa Rica
        • group_index
        • latitude9.928069
        • longitude-84.090729
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_descriptionA unique, happy and caring nation with an international culture.
        • long_descriptionCosta Rica is ranked as one of the most visited international destinations. It is a democratic and peaceful and has not had an army since 1949. The secret still isn’t out that investors have a jewel to discover. Buyers from hot markets like California and Florida see Costa Rica as offering great value in comparison to similar beach real estate in the United States, the Caribbean and Hawaii. Offering an action packed city life, world class beach destinations, surfing, sport fishing, sailing, volcanoes, waterfalls, national parks and over 2% of the world’s biodiversity, Costa Rica has it all.
        • created2016-04-08 14:44:15
        • modified2016-04-14 10:40:03
        • timezoneAmerica/Mexico_City
        • population288054
        • uri/locations/view/146/san-jose-costa-rica
        • tile_name San Jose, Costa Rica
      • Image(array)
        • 0(array)
          • id3086
          • modelArticle
          • model_id442
          • tagImage
          • nameCosta-Rica-1.jpg
          • typeimage/jpg
          • size717936
          • uri/assets/3086.jpg
          • order0
          • created2016-04-05 14:30:27
          • modified2016-04-11 17:06:15
      • Brokerage(array)
        • 0(array)
          • id85
          • 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_id15
          • WOEID2345088
          • 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
          • namePlantación Properties
          • broker_of_record_name
          • short_namePlantación Properties
          • usernamePlantacionProperties
          • password627b03b998ea7a1eb8df187fba6f4890eef328be
          • 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>Plantación Properties is the exclusive representative for Leverage Global Partners in Costa Rica, to include San Jose, Playa Flamingo, Tamarindo, Mal Pais, Santa Teresa, Arenal, Heradura, Manuel Antonio, Osa, Jaco, and Arenal.</p> <p>Plantación Properties, offers to buyers and sellers access to an amplified market of luxury properties in Costa Rica, such as beach front, ocean view, mountain view, estates, land parcels, luxury city homes and condominiums.</p> <p>Through Plantación Properties, buyers and sellers of distinctive levels of quality have access to the amplified marketing efforts of our over 25 years of professional service to the discerning international real estate market.</p> <p>The combined marketing efforts of Plantación Properties and its global partners will provide far reaching exposure to a qualified audience of homeowners and homebuyers for exclusive properties in Costa Rica and beyond.</p>
          • communitiesPlaya Flamingo San Jose Flamingo Tamarindo Mal Pais Santa Teresa Arenal Heradura Manuel Antonio Osa Jaco Guanacaste
          • websitehttp://www.plantacionpropertiescr.com/
          • addressSan Jose
          • address_2
          • cityCosta Rica
          • state
          • full_state
          • countryCosta Rica
          • marketSan Jose
          • market_2
          • postal_code
          • phoneOffice: 1 (506) 2654-4004
          • phone_2Toll Free: 1 (877) 661-2060
          • phone_3
          • wide_contact_image(false)
          • contact_nameRobert Davey
          • contact_profile_link
          • contact_big_profile_linkhttp://www.leveragere.com/blog/meet-robert-davey-plantacion-properties/
          • contact_big_profile_link_text
          • contact_titlePresident
          • contact_dre_num
          • contact_quoteI invite you to contact me personally about Costa Rica 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_filename85.jpg
          • logo_filename85.png
          • contact_image_filename85.JPG
          • all_properties_link_image_filename85.jpg
          • all_properties_linkhttp://www.plantacionpropertiescr.com/
          • video_embed_code
          • contact_video_embed_code
          • meta_titleCosta Rica Real Estate | Plantación Properties | Leverage Global Partners
          • meta_descriptionPlantación Properties is the exclusive representative for Leverage Global Partners in Costa Rica.
          • meta_keywordsPlantación Properties, Leverage Global Partners, Robert Davey, Playa Flamingo Real Estate, San Jose Real Estate, Flamingo Real Estate, Tamarindo Real Estate, Mal Pais Real Estate, Santa Teresa Real Estate, Arenal Real Estate, Heradura Real Estate, Manuel Antonio Real Estate, Osa Real Estate, Jaco Real Estate, Guanacaste 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-01-22 11:37:46
          • modified2016-04-08 16:34:01
          • dre_num012345
          • uri/brokerage-detail/85/plantaci-n-properties
          • website_shortwww.plantacionpropertiescr.com
          • name_with_locationPlantación Properties
          • ArticlesBrokerage(array)
            • id59
            • article_id442
            • brokerage_id85
      • Location(empty)
      • 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)
            • id359
            • article_id442
            • topic_id24
        • 1(array)
          • id8
          • nameBeach
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:30:26
          • tile_nameBeach
          • ArticlesTopic(array)
            • id358
            • article_id442
            • topic_id8
    • 2(array)
      • Article(array)
        • id347
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(false)
        • large_featured(false)
        • titleWonderful Waterfront Homes Under $1 Million
        • authorLeverageRE
        • date2015-03-05
        • lead_inDo you dream of living in a charming beach house next to the ocean, or watching a lakefront sunrise while sipping coffee from your balcony? These dreams can be a reality, without a colossal price tag.
        • body <p>These luxurious waterfront homes from some of our Leverage Partners offer all the amenities of a multi-million dollar estate, without breaking the bank:</p> <h1> <strong>Bandon Ocean View Executive Retreat</strong><br> Represented by Bandon Property</h1> <p><img src="/assets/1549.jpg" class="pure-img"></p> <p><img src="/assets/1550.jpg" class="pure-img"></p> <p>Overlooking the Pacific Ocean, this meticulously planned Oregon home highlights spectacular, pristine shoreline and scenery from its front door.</p> <h1> <strong>Waterfront Oasis</strong><br> Represented by The Lachicotte Company</h1> <p><img src="/assets/1551.jpg" class="pure-img"></p> <p><img src="/assets/1552.jpg" class="pure-img"></p> <p>Remarkable views are abundant from this South Carolina creek front home, with a floating dock that offers direct access to the ocean.</p> <h1> <strong>Jewel On the York River</strong><br> Represented by Virginia Country Real Estate, Inc.</h1> <p><img src="/assets/1553.jpg" class="pure-img"></p> <p><img src="/assets/1554.jpg" class="pure-img"></p> <p> Enjoy a “Southern Living” style home in Virginia, custom built and designed to capture fantastic river views and accommodate many guests.</p> <h1> <strong>Custom Lakefront Home</strong><br> Represented by Lake James Real Estate</h1> <p><img src="/assets/1555.jpg" class="pure-img"></p> <p><img src="/assets/1556.jpg" class="pure-img"></p> <p>Nestled in its natural waterfront, this immaculately maintained custom built home in North Carolina exemplifies lakefront living at its finest.</p> <h1> <strong>The Villas at Cocoplum</strong><br> Represented by Boris Mannsfeld & Associates</h1> <p><img src="/assets/1557.jpg" class="pure-img"></p> <p><img src="/assets/1558.jpg" class="pure-img"></p> <p> Enjoy the premier condominium resort on the Placencia Peninsula, boasting privacy and tranquility like nowhere else in Belize.</p> <h1> <strong>Great Vacation Getaway</strong><br> Represented by US Southwest</h1> <p><img src="/assets/1559.jpg" class="pure-img"></p> <p><img src="/assets/1560.jpg" class="pure-img"></p> <p> Entertain family and friends on the sprawling upper deck of this beautiful Arizona home while taking in sweeping views of the Colorado River.</p> <h1> <strong>West Indies Style Beach Home</strong><br> Represented by Blue Heron Realty Co.</h1> <p><img src="/assets/1561.jpg" class="pure-img"></p> <p><img src="/assets/1562.jpg" class="pure-img"></p> <p>  With a dramatic wall of windows offering breathtaking views of the Chesapeake Bay, this Cape Charles home can be your dream come true.</p> <h1> <strong>Beautiful Home on Private 120 Acre Lake</strong><br> Represented by Ray & Poynor Properties</h1> <p><img src="/assets/1563.jpg" class="pure-img"></p> <p><img src="/assets/1564.jpg" class="pure-img"></p> <p> Crafted with antique beams and floors, this rustic Alabama lake house features a large screened porch with a stone fireplace and glorious sunset views.</p> <p>Which of these wonderful waterfront retreats would you like to call home? Please share your ideas and leave your comments below.</p>
        • vimeo_id
        • created2016-02-25 14:13:08
        • modified2016-04-05 14:41:07
        • uri/articles/view/347/wonderful-waterfront-homes-under-1-million
        • flattened_topics(array)
          • 0Killer Views
          • 1Beach
      • 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)
          • id1565
          • modelArticle
          • model_id347
          • tagImage
          • nameBlueHeron_front-copy.jpg
          • typeimage/jpg
          • size518681
          • uri/assets/1565.jpg
          • order0
          • created2016-02-25 14:13:10
          • modified2016-03-14 16:00:45
      • Brokerage(empty)
      • Location(empty)
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id4
          • nameKiller Views
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:33:10
          • tile_nameKiller Views
          • ArticlesTopic(array)
            • id83
            • article_id347
            • topic_id4
        • 1(array)
          • id8
          • nameBeach
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:30:26
          • tile_nameBeach
          • ArticlesTopic(array)
            • id84
            • article_id347
            • topic_id8
    • 3(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
  • sidebar_tiles(array)
    • 0(array)
      • Topic(array)
        • id5
        • nameUrban Life
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:36:03
        • tile_nameUrban Life
      • Image(array)
        • id24
        • modelTopic
        • model_id5
        • tagImage
        • nameUrban Life.jpg
        • typeimage/jpeg
        • size18168616
        • uri/assets/24.jpg
        • order0
        • created2016-02-25 11:35:58
        • modified2016-02-25 11:36:03
      • modelTopic
    • 1(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
    • 2(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
    • 3(array)
      • Topic(array)
        • id6
        • nameCountry Living
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:31:07
        • tile_nameCountry Living
      • Image(array)
        • id4
        • modelTopic
        • model_id6
        • tagImage
        • nameCountry Living.jpg
        • typeimage/jpeg
        • size597489
        • uri/assets/4.jpg
        • order0
        • created2016-02-25 11:31:04
        • modified2016-02-25 11:31:07
      • modelTopic
  • recent_articles(array)
    • 0(array)
      • Article(array)
        • id477
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(false)
        • large_featured(false)
        • titlePartners Trust Sells Vince Vaughn's La Canada Home
        • authorLeverageRE
        • date2016-03-29
        • lead_inLeverage Partner Partners Trust has sold Vince Vaughn's La Cañada home for $4.8 million. Christine Navarro of Partners Trust handled the transaction.
        • body<div> <p>As the <a href="http://www.latimes.com/business/realestate/hot-property/la-fi-hotprop-vince-vaughn-20160309-story.html" target="_blank">L.A. Times reported</a>, he purchased the home three years ago. The neoclassical home, built in 2000, has a timeless appearance with a grand columned porch, lush landscaping, and exquisitely crafted traditional touches.</p> <p><img class="aligncenter size-full wp-image-13005 pure-img" src="/assets/3291.jpg" /></p> <p>The five-bedroom home sits on approximately 3/4 of an acre. A gracious two-story entry with sweeping staircase leads to the living room and formal dining room which feature large windows and finely detailed moldings.</p> <p>The gourmet kitchen has a butler's pantry and adjoins the light filled family room. The family room opens out to a covered brick patio, salt water pool, lawn and sport court.</p> <p><img class="aligncenter size-full wp-image-13006 pure-img" src="/assets/3292.jpg" /></p> <p>A rich paneled library, guest room or office, laundry room and powder room complete the first floor. The master suite features a large closet, spectacular bath with soaking tub, steam shower, and views of the yard. This home also has an attached three car garage with plenty of storage.</p> </div> <h6><em>Article originally appeared on <a href="http://www.thepartnerstrust.com/blog/2016/03/partners-trust-sells-vince-vaughns-la-canada-home/" target="_blank">Partners Trust Blog</a></em></h6>
        • vimeo_id
        • created2016-04-05 14:34:56
        • modified2016-04-08 09:57:59
        • uri/articles/view/477/partners-trust-sells-vince-vaughn-s-la-canada-home
      • Image(array)
        • 0(array)
          • id3293
          • modelArticle
          • model_id477
          • tagImage
          • nameScreen-Shot-2016-03-29-at-2.49.30-PM.png
          • typeimage/png
          • size3168691
          • uri/assets/3293.png
          • order0
          • created2016-04-05 14:34:56
          • modified2016-04-08 09:57:59
    • 1(array)
      • Article(array)
        • id436
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(true)
        • large_featured(true)
        • titleHome Improvement: Take It Outside
        • authorLeverageRE
        • date2016-03-29
        • lead_inFrench for "under my tree," Sous Mon Arbre is an indoor/outdoor garden lamp ($665) equipped with a metal hook that can be used to hang the fixture on the branch of a tree. It can also be suspended from a wall or rest freely on a table or ground surface. Designed by Paris-based Florian Brillet and introduced last fall by Ligne Roset, the lamp features an ash wood handle and a shade of rustproof aluminum with a silk white lacquer finish.
        • body<h3><em><strong>This season's blue skies mean spending more time on green lawns. Spruce up outdoor spaces with these products designed to make the backyard a haven for summer relaxation.</strong></em></h3> <h3><strong><a href="http://www.ligne-roset-usa.com/Products/lighting/default.aspx" target="_blank">Ligne Roset Sous Mon Arbre Outdoor Lamp</a></strong></h3> <p><a href="http://www.ligne-roset-usa.com/Products/lighting/default.aspx" target="_blank"><img class="aligncenter wp-image-12942 pure-img" src="/assets/3046.png" /></a></p> <h3><strong><a href="http://www.frontgate.com/" target="_blank">Frontgate 40-Liter European Outdoor Solar Shower</a></strong></h3> <p>This solar-powered shower ($1,599) simply attaches to a garden hose and uses the sun's energy to heat the water-no plumbing required. The curved design, which holds a 40-liter tank, features a hot-cold mixer that allows the user to adjust the water to a desired temperature. The shower, available in five colors (shown in cherry), is made of a corrosion-resistant aluminum that can withstand marine environments.</p> <p><a href="http://www.frontgate.com/" target="_blank"><img class="aligncenter wp-image-12943 pure-img" src="/assets/3047.png" /></a></p> <h3><strong><a href="http://store.johntunger.com/products/big-bowl-o-zen-sculptural-firebowl" target="_blank">John T. Unger Studio Big Bowl O' Zen Sculptural Fire Bowl</a></strong></h3> <p>According to artist John T. Unger, every home needs a center of serenity. His <a href="http://store.johntunger.com/products/big-bowl-o-zen-37-inch-sculptural-firebowl" target="_blank">Big Bowl O' Zen</a> ($1,500) brings balance to any landscape and provides abundant warmth on a chilly evening. Hand-cut from heavy-duty, recycled cold-rolled steel, the 145-pound fire bowl is 37 inches in diameter and rests on a slim base. It is suitable for wood burning and ships ready-to-fit for clean-burning propane or natural gas.</p> <p><a href="http://store.johntunger.com/products/big-bowl-o-zen-sculptural-firebowl" target="_blank"><img class="aligncenter wp-image-12944 pure-img" src="/assets/3048.png" /></a></p>
        • vimeo_id
        • created2016-04-05 14:30:20
        • modified2016-04-11 17:05:22
        • uri/articles/view/436/home-improvement-take-it-outside
      • Image(array)
        • 0(array)
          • id3049
          • modelArticle
          • model_id436
          • tagImage
          • nameScreen-Shot-2016-04-02-at-2.02.59-PM.png
          • typeimage/png
          • size2530827
          • uri/assets/3049.png
          • order0
          • created2016-04-05 14:30:21
          • modified2016-04-11 17:05:22
  • article_model_overrideLocation
  • article(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
      • flattened_topics(array)
        • 0Beach
    • 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)
      • id137
      • parent_id8
      • brokerage_id92
      • typeExclusive
      • archived(false)
      • use_as_topic(false)
      • nameKiawah Island, SC, USA
      • short_nameKiawah Island, SC, USA
      • group_index
      • latitude32.608238
      • longitude-80.084816
      • country_code
      • north53.700001
      • south19.700001
      • east-52.599998
      • west-146.600006
      • zoom0
      • short_descriptionKiawah and Seabrook Islands – luxury accommodations amidst championship golf courses and pristine beaches.
      • long_descriptionBoth Kiawah and Seabrook Islands, just 21 miles south of historic downtown Charleston, offer a unique, rural flavor that attracts nature-lovers, sports enthusiasts and vacation seekers from all over the world. Guests and residents alike enjoy access to miles of unspoiled beach, seven championship golf courses, tennis, biking, boating, wildlife and so much more. Local farms provide an abundance of fresh produce, while surrounding creeks and rivers offer fresh “catch of the day”. Whether you seek views of the ocean, championship fairways, maritime forests or lush marshes, here, you will find your special place.
      • created2016-04-07 15:25:59
      • modified2016-04-07 15:25:59
      • timezoneAmerica/New_York
      • population1700
      • uri/locations/view/137/kiawah-island-sc-usa
      • tile_nameKiawah Island, SC, USA
    • 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
    • Brokerage(array)
      • 0(array)
        • id92
        • account_executive_id236
        • archived(false)
        • typedevelopment
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties8
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties0
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id0
        • WOEID2432153
        • 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
        • namePam Harrington Exclusives
        • broker_of_record_name
        • short_namePam Harrington Exclusives
        • usernamePamHarringtonExclusives
        • passwordd9957a95a4927b3d3325d107e05944a461d55de6
        • password_reset_hash
        • monthly_invoice_amount0.00
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename92.pdf
        • active(true)
        • lead_in
        • short_description
        • description<p>Pam Harrington Exclusives is the exclusive representative for Leverage Global Partners in Wadmalaw Island, Seabrook Island, Johns Island, Kiawah Island, South Carolina, USA.</p> <p>In 1987, Pam Harrington Exclusives began as a small, independent firm amid a sea of large, corporate realty companies and developers competing for business on Kiawah and Seabrook Island. The Pam Harrington Exclusives team quickly established relationships with discerning island homeowners who sought to rent their properties during peak season. Those early relationships continued to grow and served as the foundation upon which our small firm blossomed into the renowned full service real estate company we are today.</p> <p>With over 30 years of experience in island realty, we enjoy sharing our surroundings. If you're looking for oceanfront, fairway, deep water or secluded marshlands, we'll find it on the islands of Kiawah, Seabrook, Johns or Wadmalaw. If the city suits your fancy, we are equally at home in Charleston. We’ve had the pleasure of helping families get to know Seabrook and Kiawah Island through our seasonal rentals – and the honor of seeing them fall in love with these islands and helping them become permanent members of our community.</p> <p>As an independent firm, we are free of corporate demands and able to focus on what’s most important – helping our clients find happiness in the beautiful places we are lucky to call home. Distinguished by profound personal attention, Pam Harrington Exclusives has closed over one billion dollars in sales, one transaction at a time.</p> <p>If you're interested in buying or selling a home or property on Kiawah, Seabrook or the adjacent islands, look no further. We’re proud to represent the beloved island communities whose beauty, value and legacy endure</p>
        • communitiesWadmalaw Island Seabrook Island Johns Island Kiawah Island
        • websitehttp://www.pamharringtonexclusives.com/
        • address4343 Betsy Kerrison Pkwy
        • address_2
        • cityJohns Island
        • stateSC
        • full_stateSouth Carolina
        • countryUSA
        • marketKiawah Island
        • market_2
        • postal_code29455
        • phoneOffice: (843) 768-3635
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_namePam Harrington
        • contact_profile_link
        • contact_big_profile_link
        • 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_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_filename92.jpg
        • logo_filename92.jpg
        • contact_image_filename92.jpg
        • all_properties_link_image_filename92.JPG
        • all_properties_linkhttp://www.pamharringtonexclusives.com/real-estate/kiawah-real-estate
        • video_embed_code
        • contact_video_embed_code
        • meta_titleKiawah Island Real Estate | Pam Harrington Exclusives | Leverage Global Partners
        • meta_descriptionPam Harrington Exclusives is the exclusive representative for Leverage Global Partners in Kiawah Island, South Carolina, USA.
        • meta_keywordsKiawah Island Real Estate, Pam Harrington Exclusives, Leverage Global Partners, Wadmalaw Island Real Estate, Seabrook Island Real Estate, Johns Island Real Estate
        • 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)
        • created2014-01-31 18:29:33
        • modified2019-09-09 11:37:58
        • dre_num012345
        • uri/development-detail/92/pam-harrington-exclusives
        • website_shortwww.pamharringtonexclusives.com
        • name_with_locationPam Harrington Exclusives
        • ArticlesBrokerage(array)
          • id62
          • article_id487
          • brokerage_id92
    • Location(array)
      • 0(array)
        • id137
        • parent_id8
        • brokerage_id92
        • typeExclusive
        • archived(false)
        • use_as_topic(false)
        • nameKiawah Island, SC, USA
        • short_nameKiawah Island, SC, USA
        • group_index
        • latitude32.608238
        • longitude-80.084816
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_descriptionKiawah and Seabrook Islands – luxury accommodations amidst championship golf courses and pristine beaches.
        • long_descriptionBoth Kiawah and Seabrook Islands, just 21 miles south of historic downtown Charleston, offer a unique, rural flavor that attracts nature-lovers, sports enthusiasts and vacation seekers from all over the world. Guests and residents alike enjoy access to miles of unspoiled beach, seven championship golf courses, tennis, biking, boating, wildlife and so much more. Local farms provide an abundance of fresh produce, while surrounding creeks and rivers offer fresh “catch of the day”. Whether you seek views of the ocean, championship fairways, maritime forests or lush marshes, here, you will find your special place.
        • created2016-04-07 15:25:59
        • modified2016-04-07 15:25:59
        • timezoneAmerica/New_York
        • population1700
        • uri/locations/view/137/kiawah-island-sc-usa
        • tile_nameKiawah Island, SC, USA
        • ArticlesLocation(array)
          • id43
          • article_id487
          • location_id137
    • Property(empty)
    • Topic(array)
      • 0(array)
        • id8
        • nameBeach
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:30:26
        • tile_nameBeach
        • ArticlesTopic(array)
          • id375
          • article_id487
          • 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/487/location-kiawah-island
  Query String
  Request Method	GET
  Server Protocol	HTTP/1.1
  Gateway Interface	CGI/1.1
  Redirect Url	/articles/view/487/location-kiawah-island
  Remote Port	17157
  Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
  Server Admin	root@localhost
  Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
  Context Prefix
  Request Scheme	https
  Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
  Remote Addr	104.23.197.115
  Server Port	443
  Server Addr	172.24.32.44
  Server Name	staging2.leveragere.com
  Server Software	Apache
  Server Signature
  Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
  Http Host	staging2.leveragere.com
  Http Connection	Keep-Alive
  Http X Forwarded Proto	https
  Http Cf Visitor	{"scheme":"https"}
  Http Cf Ipcountry	US
  Http Cf Connecting Ip	216.73.216.172
  Http Cdn Loop	cloudflare; loops=1
  Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
  Http Accept Encoding	gzip, br
  Http Accept	*/*
  Http Cf Ray	a09d851508b7cf52-CMH
  Http X Forwarded For	216.73.216.172
  Proxy-nokeepalive	1
  Ssl Tls Sni	staging2.leveragere.com
  Https	on
  Passenger Download Native Support Binary	0
  Passenger Compile Native Support Binary	0
  Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
  Unique Id	aiorHfK8CRJnCvkkTtrrqwAAAME
  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	aiorHfK8CRJnCvkkTtrrqwAAAME
  Fcgi Role	RESPONDER
  Php Self	/index.php
  Request Time Float	1781148445.2225
  Request Time	1781148445

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

  ====