Location: Malibu

LeverageRE

With the ocean, mountains, sun and sky, discover California dreamin' in the beautiful beach town of Malibu. Breathtaking sunsets and perfect, year-round climate, rugged beaches, numerous hiking trails, and plenty of Hollywood's beautiful people make Malibu an iconic destination.

Make a reservation to try one of Chef Nobu Matsuhisa's signature dishes, such as Tiradito, Yellowtail Sashimi with Jalapeño, and Black Cod Miso at his beachside restaurant Nobu. Then take the scenic Pacific Coast Highway to Westward Rock, where you can catch the sunset.

Rent a board from Malibu Surf Shack and catch a wave or paddleboard Malibu's famous Surfrider Beach. More than just a rental shop, the Surf Shack offers surfing, stand-up paddleboard, and kayak lessons, as well as tours of the coast.

Visit Crosscreek Road at Malibu Country Mart, California's premier location for shopping, dining, and relaxing. Unlike more typical stores, Malibu Country Mart goes beyond the usual cookie-cutter consumerism, offering its own unique and upscale boutiques, art galleries, and sculpture gardens.

Say hi to George, owner of Zuma Canyon Orchids, and pick up one of his orchids, most of which can only be described as "outrageous."

Wake up early to grab a fried-egg sandwich at Malibu Farm Pier Cafe. Located at the beginning and end of the pier, the cafe sources all of its organic ingredients and produce locally-some of the eggs even come from the chickens in the owner's backyard.

Photos courtesy of: Nobu, Malibu Surf Shack,
Malibu Farm Facebook, Malibu Country Mart

Share

• Topics:
• Beach

• Location:
• Malibu, CA, USA

Recent Articles

Location: Kiawah Island

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

Celebrity Spotlight: Meridith Baer

A creative storage solution for her plants was all Meridith Baer was looking for when she...

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] => 488
            [model] => Location
            [model_id] => 28
            [archived] => 
            [medium_featured] => 
            [large_featured] => 1
            [title] => Location: Malibu
            [author] => LeverageRE
            [date] => 2016-03-30
            [lead_in] => With the ocean, mountains, sun and sky, discover California dreamin' in the beautiful beach town of Malibu. Breathtaking sunsets and perfect, year-round climate, rugged beaches, numerous hiking trails, and plenty of Hollywood's beautiful people make Malibu an iconic destination.
            [body] => 
Make a reservation to try one of Chef Nobu Matsuhisa's signature dishes, such as Tiradito, Yellowtail Sashimi with Jalapeño, and Black Cod Miso at his beachside restaurant Nobu. Then take the scenic Pacific Coast Highway to Westward Rock, where you can catch the sunset.



Rent a board from Malibu Surf Shack and catch a wave or paddleboard Malibu's famous Surfrider Beach. More than just a rental shop, the Surf Shack offers surfing, stand-up paddleboard, and kayak lessons, as well as tours of the coast.



Visit Crosscreek Road at Malibu Country Mart, California's premier location for shopping, dining, and relaxing. Unlike more typical stores, Malibu Country Mart goes beyond the usual cookie-cutter consumerism, offering its own unique and upscale boutiques, art galleries, and sculpture gardens.



Say hi to George, owner of Zuma Canyon Orchids, and pick up one of his orchids, most of which can only be described as "outrageous."

Wake up early to grab a fried-egg sandwich at Malibu Farm Pier Cafe. Located at the beginning and end of the pier, the cafe sources all of its organic ingredients and produce locally-some of the eggs even come from the chickens in the owner's backyard.



Photos courtesy of: Nobu, Malibu Surf Shack,

Malibu Farm Facebook, Malibu Country Mart

            [vimeo_id] => 
            [created] => 2016-04-05 14:35:21
            [modified] => 2016-04-11 16:59:36
            [uri] => /articles/view/488/location-malibu
            [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] => 28
            [parent_id] => 9
            [brokerage_id] => 142
            [type] => Exclusive
            [archived] => 
            [use_as_topic] => 
            [name] => Malibu, CA, USA
            [short_name] => Malibu, CA, USA
            [group_index] => 
            [latitude] => 34.025921
            [longitude] => -118.779755
            [country_code] => 
            [north] => 53.700001
            [south] => 19.700001
            [east] => -52.599998
            [west] => -146.600006
            [zoom] => 0
            [short_description] => Famed for its beaches and cool surfer style, Malibu’s beauty is in a class by itself. 
            [long_description] => This idyllic beach community with 27 miles of scenic coastline beckons visitors from around the world and its wooded hills and canyons offer a chance to reconnect with nature. Despite its worldwide renown, Malibu still offers the feel of a small town where people know and care about each other. Known locally as the 'Bu, much of Malibu is arrayed along a long curving stretch of Pacific Coast Highway. 

Malibu real estate is all about the beach. Many of the area's most expensive properties sit directly on the beach with Carbon Beach being especially known for beautiful and very expensive real estate. Malibu real estate also extends into the surrounding hills and canyons where properties often have larger lots and feature ocean views.
            [created] => 2016-04-04 11:50:57
            [modified] => 2016-04-12 16:13:24
            [timezone] => America/Los_Angeles
            [population] => 12800
            [uri] => /locations/view/28/malibu-ca-usa
            [tile_name] => Malibu, CA, USA
        )

    [Image] => Array
        (
            [0] => Array
                (
                    [id] => 3354
                    [model] => Article
                    [model_id] => 488
                    [tag] => Image
                    [name] => Screen-Shot-2016-03-28-at-7.01.41-PM.png
                    [type] => image/png
                    [size] => 2266902
                    [uri] => /assets/3354.png
                    [order] => 0
                    [created] => 2016-04-05 14:35:22
                    [modified] => 2016-04-11 16:59:36
                )

        )

    [Brokerage] => Array
        (
            [0] => Array
                (
                    [id] => 5
                    [account_executive_id] => 236
                    [archived] => 
                    [type] => brokerage
                    [hide_from_frontend] => 
                    [agent_brokerage_data_override] => 
                    [featured_development] => 
                    [membership_type] => Premium
                    [max_properties] => 12
                    [max_homepage_featured_by_member_properties] => 0
                    [featured_properties_sort_method] => manual
                    [lux_feed_mode] => StripeSubscription
                    [max_luxury_feed_properties] => 2
                    [membership_luxury_feed_properties] => 0
                    [can_participate_in_lux_feed_while_archived] => 
                    [full_training_video_access] => 1
                    [country_id] => 1
                    [WOEID] => 2468964
                    [timezone] => US/Pacific
                    [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] => Partners Trust Real Estate Brokerage and Acquisitions
                    [broker_of_record_name] => 
                    [short_name] => Partners Trust Real Estate
                    [username] => PartnersTrustPas
                    [password] => 5b28522e46f56278664573d82c2b0f03520519d0
                    [password_reset_hash] => 
                    [monthly_invoice_amount] => 
                    [monthly_invoice_start_date] => 0000-00-00
                    [monthly_invoice_end_date] => 0000-00-00
                    [contract_filename] => 
                    [active] => 1
                    [lead_in] => 
                    [short_description] => 
                    [description] => 
Partners Trust is the exclusive representative for Leverage Global Partners in Pasadena and La Cañada Flintridge, California, USA.

At Partners Trust, we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market, presenting our clients with the most professional, successful and ethical real estate associates in the business. We represent our clients with care, confidentiality and the utmost attention to service.

Pasadena is a harmonious blend of past and present. Experience the nationally-televised Rose Parade, catch an exciting football game at the Rose Bowl, get smart at Caltech, or revel in the Jet Propulsion Laboratory.

The community is renowned for its charming and diverse neighborhoods whose residents honor and preserve the splendor of early California architecture. Opportunities abound to experience Pasadena’s sophisticated culture with the diversified entertainment at the Pasadena Playhouse, the Norton Simon Museum, the Huntington Library and Botanical Gardens and even by walking along the vibrant, historic district of Colorado Boulevard.

Partners Trust associates are proud to represent a wide variety of historic and architecturally diverse homes, including the Craftsman-style home. We understand our clients discerning needs, and provide a high level of service and local area knowledge.

Partners Trust has additional office locations in Beverly Hills, Los Angeles, Santa Monica, Malibu, and Shanghai.

                    [communities] => Pasadena 
La Canada 
Flintridge 
San Marino 
La Canada Flintridge
                    [website] => http://www.thepartnerstrust.com
                    [address] => 594 E. Colorado Boulevard
                    [address_2] => 
                    [city] => Pasadena
                    [state] => CA
                    [full_state] => California
                    [country] => USA
                    [market] => Pasadena
                    [market_2] => 
                    [postal_code] => 91101
                    [phone] => (626) 696-4802
                    [phone_2] => 
                    [phone_3] => 
                    [wide_contact_image] => 
                    [contact_name] => Scott Brown
                    [contact_profile_link] => 
                    [contact_big_profile_link] => http://www.leveragere.com/blog/meet-scott-brown-managing-director-partners-trust-pasadena/
                    [contact_big_profile_link_text] => 
                    [contact_title] => Managing Director
                    [contact_dre_num] => 
                    [contact_quote] => 
                    [contact_email] => [email protected]
                    [contact_facebook] => 
                    [contact_twitter] => 
                    [contact_instagram] => 
                    [contact_pinterest] => 
                    [contact_linkedin] => 
                    [contact_youtube] => 
                    [contact_phone] => 
                    [contact_email_2] => 
                    [contact_2_facebook] => 
                    [contact_2_twitter] => 
                    [contact_2_instagram] => 
                    [contact_2_pinterest] => 
                    [contact_2_linkedin] => 
                    [contact_2_youtube] => 
                    [contact_phone_2] => 
                    [contact_website] => 
                    [contact_name_2] => Nick Segal
                    [contact_profile_link_2] => http://www.leveragere.com/brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions
                    [contact_big_profile_link_2] => 
                    [contact_big_profile_link_text_2] => 
                    [contact_title_2] => President/Co-Founder
                    [contact_dre_num_2] => 
                    [contact_email_3] => 
                    [contact_name_3] => 
                    [contact_title_3] => 
                    [contact_dre_num_3] => 
                    [contact_phone_3] => 
                    [contact_3_facebook] => 
                    [contact_3_twitter] => 
                    [contact_3_instagram] => 
                    [contact_3_pinterest] => 
                    [contact_3_linkedin] => 
                    [contact_3_youtube] => 
                    [image_filename] => 5.jpg
                    [logo_filename] => 5.png
                    [contact_image_filename] => 5.jpg
                    [all_properties_link_image_filename] => 5.jpg
                    [all_properties_link] => http://www.thepartnerstrust.com/properties
                    [video_embed_code] => 
                    [contact_video_embed_code] => 
                    [meta_title] => Pasadena Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
                    [meta_description] => Partners Trust Real Estate Brokerage and Acquisitions in Pasadena, CA is a premier boutique Pasadena real estate brokerage and the exclusive Pasadena representative for Leverage Global Partners.
                    [meta_keywords] => partners trust, partners trust real estate, pasadena real estate, leverage global partners, pasadena homes for sale, scott brown
                    [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] => 2013-03-18 16:08:06
                    [modified] => 2016-04-08 16:33:22
                    [dre_num] => 012345
                    [uri] => /brokerage-detail/5/partners-trust-real-estate-brokerage-and-acquisitions
                    [website_short] => www.thepartnerstrust.com
                    [name_with_location] => Partners Trust Real Estate Brokerage and Acquisitions
                    [ArticlesBrokerage] => Array
                        (
                            [id] => 47
                            [article_id] => 488
                            [brokerage_id] => 5
                        )

                )

        )

    [Location] => Array
        (
            [0] => Array
                (
                    [id] => 28
                    [parent_id] => 9
                    [brokerage_id] => 142
                    [type] => Exclusive
                    [archived] => 
                    [use_as_topic] => 
                    [name] => Malibu, CA, USA
                    [short_name] => Malibu, CA, USA
                    [group_index] => 
                    [latitude] => 34.025921
                    [longitude] => -118.779755
                    [country_code] => 
                    [north] => 53.700001
                    [south] => 19.700001
                    [east] => -52.599998
                    [west] => -146.600006
                    [zoom] => 0
                    [short_description] => Famed for its beaches and cool surfer style, Malibu’s beauty is in a class by itself. 
                    [long_description] => This idyllic beach community with 27 miles of scenic coastline beckons visitors from around the world and its wooded hills and canyons offer a chance to reconnect with nature. Despite its worldwide renown, Malibu still offers the feel of a small town where people know and care about each other. Known locally as the 'Bu, much of Malibu is arrayed along a long curving stretch of Pacific Coast Highway. 

Malibu real estate is all about the beach. Many of the area's most expensive properties sit directly on the beach with Carbon Beach being especially known for beautiful and very expensive real estate. Malibu real estate also extends into the surrounding hills and canyons where properties often have larger lots and feature ocean views.
                    [created] => 2016-04-04 11:50:57
                    [modified] => 2016-04-12 16:13:24
                    [timezone] => America/Los_Angeles
                    [population] => 12800
                    [uri] => /locations/view/28/malibu-ca-usa
                    [tile_name] => Malibu, CA, USA
                    [ArticlesLocation] => Array
                        (
                            [id] => 34
                            [article_id] => 488
                            [location_id] => 28
                        )

                )

        )

    [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] => 336
                            [article_id] => 488
                            [topic_id] => 8
                        )

                )

        )

)

• 
• History
  +

  Request History

  4 previous requests available

  • Restore to current request
  • articles/view/466/location-lisbon
  • articles/view/464/location-austin
  • locations/view/58/berkeley-ca-usa
  • articles/view/451/location-bel-air

  ====
• Session
  +

  Session

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

  ====
• Request
  +

  Request

  Cake Params

  • plugin(null)
  • controllerarticles
  • actionview
  • named(empty)
  • pass(array)
    • 0488
    • 1location-malibu
  • 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: 15 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` = 488 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` = (488) 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` = 488 AND `ArticlesBrokerage`.`brokerage_id` = `Brokerage`.`id`)	1	1	0
  SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `ArticlesLocation`.`id`, `ArticlesLocation`.`article_id`, `ArticlesLocation`.`location_id` FROM `leveragere_staging2`.`locations` AS `Location` JOIN `leveragere_staging2`.`articles_locations` AS `ArticlesLocation` ON (`ArticlesLocation`.`article_id` = 488 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` = 488 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` = 488 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	1	maybe slow
  SELECT `Article`.`id`, `Article`.`model`, `Article`.`model_id`, `Article`.`archived`, `Article`.`medium_featured`, `Article`.`large_featured`, `Article`.`title`, `Article`.`author`, `Article`.`date`, `Article`.`lead_in`, `Article`.`body`, `Article`.`vimeo_id`, `Article`.`created`, `Article`.`modified` FROM `leveragere_staging2`.`articles` AS `Article` WHERE `Article`.`id` IN (499, 486, 488, 487, 436, 476, 437, 477, 481, 479) ORDER BY RAND() ASC LIMIT 2	2	2	1	maybe slow
  SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (487, 481) 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	0
  SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`locations` AS `Location` LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Location`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`assets` AS `Image` ON (`Image`.`model_id` = `Location`.`id` AND `Image`.`model` = 'Location' AND `Image`.`tag` = 'Image') WHERE `Location`.`use_as_topic` = '1' AND NOT (`Location`.`id` IS NULL) ORDER BY RAND() ASC LIMIT 1	1	1	1
  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` = 488 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` = (488) 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` = 488 AND `ArticlesBrokerage`.`brokerage_id` = `Brokerage`.`id`)	1	1	0
  SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `ArticlesLocation`.`id`, `ArticlesLocation`.`article_id`, `ArticlesLocation`.`location_id` FROM `leveragere_staging2`.`locations` AS `Location` JOIN `leveragere_staging2`.`articles_locations` AS `ArticlesLocation` ON (`ArticlesLocation`.`article_id` = 488 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` = 488 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` = 488 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` != 488 AND `Article`.`model` != 'News' AND `Article`.`archived` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	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 (245, 442, 206, 449) 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 (245, 442, 206, 449) AND `ArticlesBrokerage`.`brokerage_id` = `Brokerage`.`id`)	1	1	0
  SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `ArticlesLocation`.`id`, `ArticlesLocation`.`article_id`, `ArticlesLocation`.`location_id` FROM `leveragere_staging2`.`locations` AS `Location` JOIN `leveragere_staging2`.`articles_locations` AS `ArticlesLocation` ON (`ArticlesLocation`.`article_id` IN (245, 442, 206, 449) AND `ArticlesLocation`.`location_id` = `Location`.`id`)	0	0	0
  SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created`, `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 (245, 442, 206, 449) 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 (245, 442, 206, 449) AND `ArticlesTopic`.`topic_id` = `Topic`.`id`)	8	8	0
  SELECT `Property`.`id` FROM `leveragere_staging2`.`properties` AS `Property` WHERE `Property`.`archived` = '0' AND `Property`.`incomplete` = '0' ORDER BY `Property`.`created` DESC LIMIT 50	50	50	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	5	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 (3730, 3758, 3736, 3727) ORDER BY `Image`.`order` ASC	15	15	0
  SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (3730, 3758, 3736, 3727) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	2	2	0
  SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (3730, 3758, 3736, 3727) 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 (3730, 3758, 3736, 3727) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	4	4	0
  SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (3730, 3758, 3736, 3727) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	1	1	0

  6 duplicate queries run.

  Query Explain:

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

  ====
• Timer
  +

  Memory

  Peak Memory Use 14.81 MB

  Message	Memory use
  Component initialization	2.91 MB
  Controller action start	3.85 MB
  Controller render start	6.69 MB
  View render complete	7.26 MB

  Timers

  Total Request Time: 1014 (ms)

  Message	Time in ms	Graph
  Core Processing (Derived from $_SERVER["REQUEST_TIME"])	827.57
  Event: Controller.initialize	3.91
  Event: Controller.startup	1.17
  Controller action	46.49
  Event: Controller.beforeRender	12.82
  » Processing toolbar data	12.72
  Rendering View	86.13
  » Event: View.beforeRender	0.27
  » Rendering APP/View/Articles/view.ctp	3.69
  » » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.16
  » » Rendering APP/View/Elements/sidebar/explore.ctp	0.87
  » » » Rendering APP/View/Elements/explore_tile_small.ctp	0.13
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #2	0.12
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #3	0.12
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #4	0.13
  » » Rendering APP/View/Elements/sidebar/article_list.ctp	0.18
  » » Rendering APP/View/Elements/sidebar/property_search.ctp	0.19
  » » Rendering APP/View/Elements/sidebar/property_list.ctp	1.23
  » » » Rendering APP/View/Elements/static_property_price.ctp	0.37
  » » » Rendering APP/View/Elements/static_property_price.ctp #2	0.15
  » » » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
  » » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
  » Event: View.afterRender	0.01
  » Event: View.beforeLayout	0.01
  » Rendering APP/View/Layouts/front.ctp	81.50
  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)
        • id3730
        • brokerage_id207
        • created_by_user_id0
        • order0
        • multi_unit(true)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameIT’S ALL ABOUT THE 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(true)
        • requested_homepage_featured_by_member(false)
        • homepage_featured_by_member(false)
        • dot_luxury_featured(false)
        • luxury_feed_featured(true)
        • force_luxury_feed_featured(false)
        • luxury_autofeed_imported(false)
        • luxury_feed_last_added_time0000-00-00 00:00:00
        • luxury_feed_agent_user_id0
        • luxury_feed_locked_to_subscription_id0
        • luxury_feed_agent_purchase_date0000-00-00
        • luxury_feed_agent_expiration_date0000-00-00
        • digital_ad_summary_email_last_sent0000-00-00 00:00:00
        • digital_ad_summary_price_changed(false)
        • wsj_detail_url
        • ft_detail_url
        • nyt_detail_url
        • juwai_detail_url
        • pgl_detail_url
        • mg_detail_url
        • mg_c_detail_url
        • mg_s_detail_url
        • bp_detail_url
        • mw_detail_url
        • nikkei_detail_url
        • wapo_detail_url
        • robb_detail_url
        • medium_featured(false)
        • large_featured(false)
        • detail_page(false)
        • description<p>Luxury of Privacy! 5 minutes to everything with sweeping ocean views! Elegant floor plan with full dining, living, office, family room and luxurious Master Suite. Each room is gracious with high ceilings and views. Three fireplaces, hardwood floors, crown molding. This is a special home in a rare location. patio and decking, pizza oven, the grounds done by a master with abundant flowers, speciman trees, and patios to enjoy both the yard and the view. 2.76 gently sloping ares allow for many possiblities. There are plans and permits for an additional 3-car garage and 850 square foot gues home.</p>
        • address647 Quail Run Rd
        • address_2
        • cityAptos
        • stateCA
        • postal_code95003
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price2895000
        • price_20
        • price_usd2895000
        • price_usd_20
        • statusFor Sale
        • status_last_changed0000-00-00 00:00:00
        • status_last_changed_price_only0000-00-00 00:00:00
        • lease_period
        • price_upon_request(false)
        • bedrooms4
        • bedrooms_20
        • bathrooms3
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet4500
        • square_meters
        • acres276
        • interior_unitsq_ft
        • interior_size0
        • lot_unitacres
        • lot_size276
        • icon_1
        • icon_2
        • icon_3
        • icon_4
        • icon_5
        • icon_6
        • websitehttp://www.sites.e-agents.com/jhickey/647-Quail-Run-RD-Aptos-CA~l45$81578651$RES
        • meta_title
        • meta_description
        • meta_keywords
        • bathrooms_partial1
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built1963
        • virtual_tour
        • video_tour
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_numML81578651
        • wsj_property_typesingle family
        • nyt_property_type1
        • nyt_popular_features
        • propgolux_property_type9
        • juwai_property_type
        • juwai_category
        • propgolux_property_style21
        • 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
        • latitude36.986786
        • longitude-121.894623
        • 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 05:33:03
        • created2016-04-14 15:50:30
        • uri/property-detail/3730/647-quail-run-rd-aptos-ca-95003-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3730/647-quail-run-rd-aptos-ca-95003-usa
        • address_concat647 Quail Run Rd Aptos CA 95003 USA
        • google_maps_query_string647+Quail+Run+Rd++Aptos+CA+95003+USA
        • luxury_ad_enrolled_prettyYES
        • price_prettyUSD 2,895,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty4
        • bathrooms_pretty3
        • bathrooms_partial_pretty1
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms3
        • date_listed2016-04-14
        • overridden_brokerage_nameMonterey Bay Properties
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id207
        • account_executive_id235
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typeBasic
        • max_properties8
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties1
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id0
        • WOEID2488853
        • 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
        • nameMonterey Bay Properties
        • broker_of_record_name
        • short_nameMonterey Bay Properties
        • usernameMontereyBayProperties
        • passwordac1103d6b00baf65680912c82989db7b7243bcf0
        • password_reset_hash
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>Monterey Bay Properties is the exclusive representative for Leverage Global Partners in Santa Cruz County including Capitola, Santa Cruz, Aptos, La Selva Beach, Soquel, Rio Del Mar, Corralitos, Day Valley, Watsonville, Boulder Creek, Brookdale, Ben Lomond, Lompico, Scotts Valley, CA, USA.</p> <p>More information coming soon!</p>
        • communitiesSanta Cruz County Capitola, Santa Cruz Aptos La Selva Beach Soquel Rio Del Mar Corralitos Day Valley, Watsonville Boulder Creek Brookdale Ben Lomond Lompico Scotts Valley
        • websitehttp://www.montereybayproperties.net
        • address620 Capitola Avenue
        • address_2
        • cityCapitola
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • marketSanta Cruz
        • market_2
        • postal_code95010
        • phoneDirect: (831) 464-5212
        • phone_2Cell: (831) 239-3353
        • phone_3
        • wide_contact_image(false)
        • contact_nameJohn Hickey
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titleBroker/Owner
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename207.jpg
        • logo_filename207.png
        • contact_image_filename207.jpg
        • all_properties_link_image_filename207.jpg
        • all_properties_linkhttp://www.sites.e-agents.com/jhickey/Office-Listings#g=b4e2794c-20ff-42c9-9652-bc4be2e3377a
        • video_embed_code
        • contact_video_embed_code
        • meta_titleSanta Cruz Real Estate⎜Monterey Bay Properties⎜Leverage Global Partners
        • meta_descriptionMonterey Bay Properties is the exclusive representative for Leverage Global Partners in Santa Cruz, CA, USA.
        • meta_keywordsSanta Cruz County Real Estate, Capitola Real Estate, Santa Cruz Real Estate, Aptos Real Estate, La Selva Beach Real Estate, Soquel Real Estate, Rio Del Mar Real Estate, Corralitos Real Estate, Day Valley Real Estate, Watsonville Real Estate, Boulder Creek Real Estate, Brookdale Real Estate, Ben Lomond Real Estate, Lompico Real Estate, Scotts Valley Real Estate, California 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)
        • created2015-06-22 11:39:43
        • modified2016-04-08 16:34:26
        • dre_num012345
        • uri/brokerage-detail/207/monterey-bay-properties
        • website_shortwww.montereybayproperties.net
        • name_with_locationMonterey Bay Properties
      • StripeSubscription(array)
        • id(null)
        • brokerage_id(null)
        • user_id(null)
        • property_id(null)
        • type(null)
        • stripe_id(null)
        • stripe_customer_id(null)
        • stripe_checkout_email(null)
        • stripe_promotion_code(null)
        • stripe_promotion_code_id(null)
        • stripe_coupon_code_id(null)
        • status(null)
        • current_period_end(null)
        • cancel_at_period_end(null)
        • ended(null)
        • last_change(null)
        • last_activity_email_sent(null)
        • created(null)
        • modified(null)
      • GlobalReachReport(array)
        • id(null)
        • property_id(null)
        • wsj_desktop(null)
        • wsj_mobile(null)
        • wsj_expires(null)
        • wsj_capture_started(null)
        • mg_desktop(null)
        • mg_mobile(null)
        • mg_expires(null)
        • mg_capture_started(null)
        • bp_desktop(null)
        • bp_mobile(null)
        • bp_expires(null)
        • gp_capture_started(null)
        • mw_desktop(null)
        • mw_mobile(null)
        • mw_expires(null)
        • mw_capture_started(null)
        • ft_desktop(null)
        • ft_mobile(null)
        • ft_expires(null)
        • ft_capture_started(null)
        • nikkei_desktop(null)
        • nikkei_mobile(null)
        • nikkei_expires(null)
        • nikkei_capture_started(null)
        • pgl_desktop(null)
        • pgl_mobile(null)
        • pgl_expires(null)
        • pgl_capture_started(null)
        • robb_desktop(null)
        • robb_mobile(null)
        • robb_expires(null)
        • robb_capture_started(null)
        • juwai_desktop(null)
        • juwai_mobile(null)
        • juwai_expires(null)
        • juwai_capture_started(null)
        • leverage_desktop(null)
        • leverage_mobile(null)
        • leverage_expires(null)
        • leverage_capture_started(null)
        • created(null)
        • modified(null)
        • wsj_available(false)
        • wsj_expired(true)
        • wsj_desktop_proxy_screenshot(null)
        • wsj_mobile_proxy_screenshot(null)
        • mg_available(false)
        • mg_expired(true)
        • mg_desktop_proxy_screenshot(null)
        • mg_mobile_proxy_screenshot(null)
        • bp_available(false)
        • bp_expired(true)
        • bp_desktop_proxy_screenshot(null)
        • bp_mobile_proxy_screenshot(null)
        • mw_available(false)
        • mw_expired(true)
        • mw_desktop_proxy_screenshot(null)
        • mw_mobile_proxy_screenshot(null)
        • nikkei_available(false)
        • nikkei_expired(true)
        • nikkei_desktop_proxy_screenshot(null)
        • nikkei_mobile_proxy_screenshot(null)
        • pgl_available(false)
        • pgl_expired(true)
        • pgl_desktop_proxy_screenshot(null)
        • pgl_mobile_proxy_screenshot(null)
        • robb_available(false)
        • robb_expired(true)
        • robb_desktop_proxy_screenshot(null)
        • robb_mobile_proxy_screenshot(null)
        • juwai_available(false)
        • juwai_expired(true)
        • juwai_desktop_proxy_screenshot(null)
        • juwai_mobile_proxy_screenshot(null)
        • capture_processing(false)
        • capture_error(empty)
      • Image(array)
        • 0(array)
          • id20832
          • modelProperty
          • model_id3730
          • tagImage
          • name645_quail_run_rd_ext5.jpg
          • typeimage/jpeg
          • size379238
          • uri/assets/20832.jpg
          • order0
          • created2016-04-14 15:47:02
          • modified2016-04-14 15:58:03
        • 1(array)
          • id20833
          • modelProperty
          • model_id3730
          • tagImage
          • name645_quail_run_rd_vw4.jpg
          • typeimage/jpeg
          • size266668
          • uri/assets/20833.jpg
          • order1
          • created2016-04-14 15:47:49
          • modified2016-04-14 15:58:03
        • 2(array)
          • id20837
          • modelProperty
          • model_id3730
          • tagImage
          • name645_quail_run_rd_dr1.jpg
          • typeimage/jpeg
          • size244413
          • uri/assets/20837.jpg
          • order2
          • created2016-04-14 15:49:25
          • modified2016-04-14 15:58:03
        • 3(array)
          • id20834
          • modelProperty
          • model_id3730
          • tagImage
          • name645_quail_run_rd_lr2.jpg
          • typeimage/jpeg
          • size265367
          • uri/assets/20834.jpg
          • order3
          • created2016-04-14 15:48:15
          • modified2016-04-14 15:58:03
        • 4(array)
          • id20838
          • modelProperty
          • model_id3730
          • tagImage
          • name645_quail_run_rd_ent1.jpg
          • typeimage/jpeg
          • size239561
          • uri/assets/20838.jpg
          • order4
          • created2016-04-14 15:49:50
          • modified2016-04-14 15:58:03
        • 5(array)
          • id20836
          • modelProperty
          • model_id3730
          • tagImage
          • name645_quail_run_rd_patio3.jpg
          • typeimage/jpeg
          • size377053
          • uri/assets/20836.jpg
          • order5
          • created2016-04-14 15:48:59
          • modified2016-04-14 15:58:03
        • 6(array)
          • id20835
          • modelProperty
          • model_id3730
          • tagImage
          • name645_quail_run_rd_dk1.jpg
          • typeimage/jpeg
          • size301274
          • uri/assets/20835.jpg
          • order6
          • created2016-04-14 15:48:27
          • modified2016-04-14 15:58:03
        • 7(array)
          • id20839
          • modelProperty
          • model_id3730
          • tagImage
          • name645_quail_run_rd_vw1.jpg
          • typeimage/jpeg
          • size387794
          • uri/assets/20839.jpg
          • order7
          • created2016-04-14 15:50:27
          • modified2016-04-14 15:58:03
      • User(array)
        • 0(array)
          • id908
          • typeAgent
          • brokerage_id207
          • email[email protected]
          • password5dae6f906104b1749fa29782b9f9e5f30769b81d
          • recover_hash
          • first_nameKaty
          • last_nameKing
          • title
          • dre_num
          • phone831-464.5203
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2017-08-07 15:23:44
          • created2017-08-07 15:23:44
          • notified(false)
          • full_nameKaty King
          • uri/agent-detail/908/katy-king
          • profile_complete(true)
          • UsersProperty(array)
            • id681
            • user_id908
            • property_id3730
            • 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)
            • id4397
            • property_id3730
            • property_feature_id14
        • 1(array)
          • id9
          • nameOffice
          • additional(false)
          • created2016-04-07 14:03:21
          • modified2016-04-07 14:03:21
          • PropertiesPropertyFeature(array)
            • id4396
            • property_id3730
            • property_feature_id9
        • 2(array)
          • id7
          • nameLibrary
          • additional(false)
          • created2016-04-07 14:02:46
          • modified2016-04-07 14:02:46
          • PropertiesPropertyFeature(array)
            • id4395
            • property_id3730
            • property_feature_id7
        • 3(array)
          • id1
          • nameBalcony/Terrace
          • additional(false)
          • created2016-04-07 14:00:26
          • modified2016-04-07 14:00:26
          • PropertiesPropertyFeature(array)
            • id4394
            • property_id3730
            • property_feature_id1
      • Topic(array)
        • 0(array)
          • id4
          • nameKiller Views
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:33:10
          • tile_nameKiller Views
          • PropertiesTopic(array)
            • id27
            • property_id3730
            • topic_id4
    • 1(array)
      • Property(array)
        • id3758
        • brokerage_id3
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • name123
        • 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>123</p>
        • address123
        • address_2
        • cityOrlando
        • stateFL
        • postal_code30434
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price0
        • price_20
        • price_usd0
        • price_usd_20
        • statusFor Sale
        • status_last_changed2024-10-24 10:10:36
        • 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
        • latitude28.538383
        • longitude-81.378929
        • 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)
        • modified2024-10-24 10:10:36
        • created2024-10-24 10:09:32
        • uri/property-detail/3758/123-orlando-fl-30434-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3758/123-orlando-fl-30434-usa
        • address_concat123 Orlando FL 30434 USA
        • google_maps_query_string123++Orlando+FL+30434+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 0
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty0
        • bathrooms_pretty0
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms0
        • date_listed2024-10-24
        • 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)
          • id23108
          • modelProperty
          • model_id3758
          • tagImage
          • name2-Westridge-MLS-Exterior-2-1390x580.jpg
          • typeimage/jpeg
          • size269041
          • uri/assets/23108.jpg
          • order0
          • created2024-10-24 10:09:30
          • modified2024-10-24 10:09:32
      • User(empty)
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(empty)
      • Topic(empty)
    • 2(array)
      • Property(array)
        • id3736
        • brokerage_id36
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameLIGHT, LOCATION & LIFESTYLE
        • 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>Once you stroll down the private driveway, you will be impressed with this adorable family home which is set amongst an abundance of colour and private gardens.</p> <ul> <li>3 spacious bedrooms (with built-ins) master complete with ensuite</li> <li>Elegant formal lounge dining room perfect for the entertainer</li> <li>Fabulous eat in kitchen with an amazing family room adjoining</li> <li>Casual living area opens onto private sundrenched courtyard</li> <li>Superb level garden and very low maintenance</li> <li>R/C airconditioning, double lock up garage with an abundance of storage</li> </ul> <p>All located within a short stroll to rail, shops and schools</p> <p>FOR SALE BY EXPRESSIONS OF INTEREST CLOSING 6th May 2016 @ 4:00pm</p>
        • address8A Fulbourne Avenue
        • address_2Pennant Hills
        • citySydney
        • stateNSW
        • postal_code2120
        • countryAustralia
        • use_lat_lng_for_google_map(false)
        • currencyAUD
        • price0
        • price_20
        • price_usd0
        • price_usd_20
        • statusFor Sale
        • status_last_changed0000-00-00 00:00:00
        • status_last_changed_price_only0000-00-00 00:00:00
        • lease_period
        • price_upon_request(false)
        • bedrooms3
        • bedrooms_20
        • bathrooms2
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet0
        • square_meters
        • acres0
        • interior_unitsq_ft
        • interior_size0
        • lot_unitacres
        • lot_size0
        • icon_1
        • icon_2
        • icon_3
        • icon_4
        • icon_5
        • icon_6
        • websiteburnsandburns.com.au
        • 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
        • latitude-33.733246
        • longitude-33.733246
        • 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-17 23:54:43
        • created2016-04-17 22:42:58
        • uri/property-detail/3736/8a-fulbourne-avenue-pennant-hills-sydney-nsw-2120-australia
        • absolute_urihttps://staging2.leveragere.com/property-detail/3736/8a-fulbourne-avenue-pennant-hills-sydney-nsw-2120-australia
        • address_concat8A Fulbourne Avenue Pennant Hills Sydney NSW 2120 Australia
        • google_maps_query_string8A+Fulbourne+Avenue+Pennant+Hills+Sydney+NSW+2120+Australia
        • luxury_ad_enrolled_prettyNO
        • price_prettyAUD 0
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty3
        • bathrooms_pretty2
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms2
        • date_listed2016-04-17
        • overridden_brokerage_nameBurns and Burns
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id36
        • 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_id10
        • WOEID1105779
        • timezoneAustralia/Sydney
        • 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
        • nameBurns and Burns
        • broker_of_record_name
        • short_nameBurns and Burns
        • usernameBurnsandBurns
        • passwordbe51d1b789bbecb96033435959b9b44ba880003f
        • 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>Burns and Burns is the exclusive representative for Leverage Global Partners on the North Shore and Upper North Shore of Sydney, Australia.</p> <p>Burns & Burns is a family business established for nearly 30 years and is one of the oldest continuing running real estate companies on the North Shore. Founded by Julia Burns, with husband Richard, son Andrew and daughter-in-law Catherine, the family concern has been blessed by long-term staff in both sales and support roles. This is shown by the strong work ethic and customer service, which results in 70% of the clients utilising Burns & Burns services being either repeat or referral customers. Julia and Andrew Burns have dominated the prestige market for over 30 years and, as such, have a track record and network unequalled on the North Shore. Indeed, it is no surprise that the highest sales records for the Upper North Shore are held by Burns & Burns in Pymble and Wahroonga. Knox Grammar School and other institutions have repeatedly used the trusted service of Burns & Burns over the last 30 years being the highest recommendation and of which the family are very proud. However, Burns & Burns deal in ALL price ranges and many of our staff have ‘grown-up’ with their clients, as they move from property to property which is the backbone of the firm and will continue to be so.</p>
        • communitiesUpper North Shore of Sydney, Australia North Shore of Sydney, Australia
        • websitehttp://burnsandburns.com.au/home
        • address1051 Pacific Highway
        • address_2
        • cityPymble
        • state
        • full_state
        • countryAustralia
        • marketSydney North Shore
        • market_2
        • postal_codeNSW 2073
        • phone(+) 61 (0) 2 9449 9211
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameAndrew Burns
        • contact_profile_link
        • contact_big_profile_linkhttp://www.leveragere.com/blog/meet-andrew-burns-director-of-burns-and-burns/
        • contact_big_profile_link_text
        • contact_titleDirector
        • 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_filename36.jpg
        • logo_filename36.jpg
        • contact_image_filename36.jpg
        • all_properties_link_image_filename36.jpg
        • all_properties_linkhttp://burnsandburns.com.au/listings/ressale
        • video_embed_code
        • contact_video_embed_code
        • meta_titleSydney North Shore Real Estate | Burns and Burns | Leverage Global Partners
        • meta_descriptionBurns and Burns is the exclusive representative for Leverage Global Partners in North Shore Sydney, Australia.
        • meta_keywordsBurns & Burns, Burns & Burns real estate, North Shore Sydney real estate, Sydney Australia, Andrew Burns, 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-06-19 10:54:50
        • modified2016-04-08 16:33:30
        • dre_num012345
        • uri/brokerage-detail/36/burns-and-burns
        • website_shortburnsandburns.com.au/home
        • name_with_locationBurns and Burns
      • 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)
          • id20905
          • modelProperty
          • model_id3736
          • tagImage
          • name1.jpg
          • typeimage/jpeg
          • size5373805
          • uri/assets/20905.jpg
          • order0
          • created2016-04-17 22:41:47
          • modified2016-04-17 23:54:07
        • 1(array)
          • id20906
          • modelProperty
          • model_id3736
          • tagImage
          • name4.jpg
          • typeimage/jpeg
          • size5572872
          • uri/assets/20906.jpg
          • order1
          • created2016-04-17 22:42:03
          • modified2016-04-17 23:54:07
        • 2(array)
          • id20910
          • modelProperty
          • model_id3736
          • tagImage
          • name5.jpg
          • typeimage/jpeg
          • size6065798
          • uri/assets/20910.jpg
          • order2
          • created2016-04-17 22:42:52
          • modified2016-04-17 23:54:07
      • User(array)
        • 0(array)
          • id449
          • typeAgent
          • brokerage_id36
          • email[email protected]
          • password39b6d71111583a7407ade4068d52e9cecb5f7334
          • recover_hash
          • first_nameLee
          • last_nameBurrows
          • title
          • dre_num
          • phone612 9449 9211
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2017-08-07 15:22:58
          • created2017-08-07 15:22:58
          • notified(false)
          • full_nameLee Burrows
          • uri/agent-detail/449/lee-burrows
          • profile_complete(true)
          • UsersProperty(array)
            • id282
            • user_id449
            • property_id3736
            • sort_order0
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(empty)
      • Topic(empty)
    • 3(array)
      • Property(array)
        • id3727
        • brokerage_id34
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameHistoric Home In The Estate Section
        • 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>Historic Traditional Designed & Built For 4 Time Ny Governor & Presidential Candidate Alfred E. Smith; 6 Bdrms, 4.5 Baths, Gourmet Kitchen, Formal Living & Dining Rooms, Sun Room, Media Room, Private Loft/Office & Conference Room. Over An Acre W/ Lush Landscaping, Beautiful Specimen Trees, In Ground Pool, Pool House & All Weather Tennis Court. Truly Your Own Summer Resort!</p>
        • address14 Halsey Avenue
        • address_2
        • cityWesthampton Beach
        • stateNY
        • postal_code11978
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price3399000
        • price_20
        • price_usd3399000
        • 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
        • latitude40.805931
        • longitude-72.658035
        • 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 05:33:03
        • created2016-04-14 13:41:32
        • uri/property-detail/3727/14-halsey-avenue-westhampton-beach-ny-11978-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3727/14-halsey-avenue-westhampton-beach-ny-11978-usa
        • address_concat14 Halsey Avenue Westhampton Beach NY 11978 USA
        • google_maps_query_string14+Halsey+Avenue++Westhampton+Beach+NY+11978+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 3,399,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty0
        • bathrooms_pretty0
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms0
        • date_listed2016-04-14
        • overridden_brokerage_nameFirst Hampton International Realty
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id34
        • account_executive_id235
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties8
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties0
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id1
        • WOEID2518253
        • timezoneUS/Eastern
        • luxury_feed_enrollment_modemanual
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id
        • mlsidx_lux_autofeed(false)
        • mlsidx_lux_autofeed_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • nameFirst Hampton International Realty
        • broker_of_record_name
        • short_nameFirst Hampton International Realty
        • usernameFirstHampton
        • passwordc6d7951ad2b1432ff444a7a5acca6784d6573bb9
        • password_reset_hash
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date0000-00-00
        • monthly_invoice_end_date0000-00-00
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>First Hampton International Realty is the exclusive representative for Leverage Global Partners in The Hamptons, New York, USA.</p> <p>Lawrence Citarelli Jr. is a successful, former finance/ economics executive of 14 years and possesses over 17 years of real estate investment and development experience. Mr. Citarelli has forged the Lawrence III Group, The group is comprised of a multi award winning design/construction management firm, Westhampton Partners, a development and acquisition arm and First Hampton International Realty, a global real estate entity. Through the vertical integration of these three entities clients and customers are provided with an experience and service model that is unrivaled in the industry. Mr. Citarelli is also a consummate humanitarian and is aligned with various noteworthy athletes, entertainers and celebrities. He has recently been awarded a congressional award for his international business dealings which are specifically tied to helping the less fortunate children and the communities where he is active.</p>
        • communitiesWesthampton Beach Westhampton Quogue Remsenburg hamptons southampton east hampton
        • websitehttp://www.firsthamptonrealty.com
        • address50 Main Street
        • address_2
        • cityWesthampton Beach
        • stateNY
        • full_stateNew York
        • countryUSA
        • marketHamptons
        • market_2
        • postal_code11978
        • phone(631) 872-0280
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameLawrence Citarelli
        • contact_profile_link
        • contact_big_profile_linkhttp://www.leveragere.com/blog/meet-lawrence-citarelli-principal-first-hampton-realty/
        • contact_big_profile_link_text
        • contact_titlePrincipal
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename34.jpg
        • logo_filename34.jpg
        • contact_image_filename34.jpg
        • all_properties_link_image_filename34.jpg
        • all_properties_linkhttp://www.firsthamptonrealty.com/featured
        • video_embed_code
        • contact_video_embed_code
        • meta_titleThe Hamptons Real Estate | First Hampton International Realty | Leverage Global Partners
        • meta_descriptionFirst Hampton International Realty is Leverage Global Partners' exclusive representative in the Hamptons, New York, USA.
        • meta_keywordsFirst Hampton International Realty, The Hamptons Real Estate, Westhampton beach real estate, Lawrence Citarelli, Leverage Global Partners
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-06-07 11:03:46
        • modified2016-04-08 16:33:30
        • dre_num012345
        • uri/brokerage-detail/34/first-hampton-international-realty
        • website_shortwww.firsthamptonrealty.com
        • name_with_locationFirst Hampton International Realty
      • 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)
          • id20816
          • modelProperty
          • model_id3727
          • tagImage
          • nameHalsey-TREE.jpg
          • typeimage/jpeg
          • size2357806
          • uri/assets/20816.jpg
          • order0
          • created2016-04-14 13:40:50
          • modified2016-04-14 13:41:32
        • 1(array)
          • id20817
          • modelProperty
          • model_id3727
          • tagImage
          • nameWAR-ROOM-1.jpg
          • typeimage/jpeg
          • size1735454
          • uri/assets/20817.jpg
          • order1
          • created2016-04-14 13:41:14
          • modified2016-04-14 13:41:32
        • 2(array)
          • id20818
          • modelProperty
          • model_id3727
          • tagImage
          • namePOOL.jpg
          • typeimage/jpeg
          • size2027846
          • uri/assets/20818.jpg
          • order2
          • created2016-04-14 13:41:27
          • modified2016-04-14 13:41:32
      • User(empty)
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(empty)
      • Topic(empty)
  • sidebar_articles(array)
    • 0(array)
      • Article(array)
        • id245
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(false)
        • large_featured(false)
        • titleIn Search of... The Most Fabulous Beaches in the World
        • authorLeverageRE
        • date2014-06-17
        • lead_inSummer vacation plans in the works? Dreaming of the soft sand between your toes? For many, there is nothing better than a trip to the beach to find that true feeling of getting away from it all. Here are some of the most fabulous beaches in the world, some better known than others, but all offering the ideal setting for both relaxing, fun-in-the-sun activities and all-out entertaining. Let’s wander the globe to see what stunning spots we find...
        • body <h1><strong>Saint Tropez, France</strong></h1> <p><img src="/assets/870.png" class="pure-img"></p> <p>Tahiti Beach in Saint Tropez, France is one of the area’s most famous private beaches. Situated on the idyllic French Riviera, Tahiti plays host to an elite clientele and offers luxury amenities and the chance to sunbathe without getting tan lines, if you know what we mean.</p> <h1><strong>Algarve, Portugal</strong></h1> <p><img src="/assets/871.jpg" class="pure-img"></p> <p>The Algarve, the southern most region of Portugal, offers spectacular beaches including the world famous Marinha Beach (Praia de Marinha).</p> <h1><strong>Mallorca, Spain</strong></h1> <p><img src="/assets/872.jpg" class="pure-img">Mallorca, Spain is a dream vacation destination with incredible beaches such as the stunning and sandy Cala Agulla, with clear, shallow water and a beautiful backdrop of pine forests.</p> <h1><strong>Puerto Vallarta, Mexico</strong></h1> <p><img src="/assets/873.jpg" class="pure-img"></p> <p>Puerto Vallarta in Mexico is a popular travel destination with over 40 beautiful beaches such as the ominous sounding, yet surprisingly lively Los Muertos Beach and Playa de Oro, known for its great watersports.</p> <h1><strong>San Jose, Costa Rica</strong></h1> <p><img src="/assets/874.jpg" class="pure-img"></p> <p>Though the city is landlocked, there are many beaches in close proximity to San Jose, Costa Rica and well worth the trip, including the aptly named Playa Hermosa, a truly beautiful beach in Guanacaste, providing great vacation amenities, such as snorkeling in the bay.</p> <h1><strong>Cabrera, Dominican Republic</strong></h1> <p><img src="/assets/875.jpg" class="pure-img"></p> <p>Playa Grande is a popular and amazing spot in Cabrera, Dominican Republic, with crystal blue water, fabulous sandy beaches and fine dining options.</p> <h1><strong>The Big Island, Hawaii</strong></h1> <p><img src="/assets/876.jpg" class="pure-img"></p> <p>Vacationers flock to The Big Island of Hawaii, which is known for its gorgeous, pristine beaches. Punalu'u Beach, with its breathtaking jet-black sand, is home to the majestic, endangered green sea turtles.</p> <h1><strong>Rivas, Nicaragua</strong></h1> <p><img src="/assets/877.jpg" class="pure-img"></p> <p>The beaches of Rivas are the most well-known and beloved in Nicaragua, featuring strong waves for incredible surfing.</p> <h1><strong>Mykonos, Greece</strong></h1> <p><img src="/assets/878.jpg" class="pure-img"></p> <p>Mykonos, Greece is a high-end destination with many beautiful beaches offering a variety of vibes including Paradise Beach and Super Paradise Beach, known for their wild parties, and the more secluded and tranquil Agia Anna Beach.</p> <h1><strong>Koh Samet Island, Thailand</strong></h1> <p><img src="/assets/879.jpg" class="pure-img"></p> <p>The most popular island in the Gulf of Thailand, Koh Samet Island is a stunning travel destination with superb beaches including the popular spots Chaweng Beach and Lamai Beach, with white sand, gorgeous views and resort amenities.</p> <p>What is your favorite beach? Which of these dreamy beaches would you most like to visit? Please share your thoughts and leave your comments below.</p> <p><em>Photos courtesy of Leverage Global Partners, Wikipedia, <a href="http://www.visitmexico.com/en/extreme-sports-in-puerto-vallarta" target="_blank" title="Visit Mexico">Visit Mexico</a>,<br><a href="http://www.southerncostarica.biz/" target="_blank">SouthernCostaRica.biz</a>, </em><em><a href="http://www.playagrande.com/#gallery" target="_blank" title="Playa Grande">Playa Grande</a> (DR), <a href="http://www.atripsouth.com/" target="_blank">A Trip South</a> (Nicaragua),  <a href="http://www.kosamui.com/lamai-beach/" target="_blank" title="Ko Samui">Ko Samui</a></em></p>
        • vimeo_id
        • created2016-02-25 14:11:26
        • modified2016-04-05 14:41:07
        • uri/articles/view/245/in-search-of-the-most-fabulous-beaches-in-the-world
        • flattened_topics(array)
          • 0Beach
          • 1Travel
      • 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)
          • id880
          • modelArticle
          • model_id245
          • tagImage
          • nameDR.jpg
          • typeimage/jpg
          • size165929
          • uri/assets/880.jpg
          • order0
          • created2016-02-25 14:11:27
          • modified2016-03-15 16:30:29
      • Brokerage(empty)
      • Location(empty)
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id8
          • nameBeach
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:30:26
          • tile_nameBeach
          • ArticlesTopic(array)
            • id159
            • article_id245
            • topic_id8
        • 1(array)
          • id10
          • nameTravel
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:35:10
          • tile_nameTravel
          • ArticlesTopic(array)
            • id160
            • article_id245
            • topic_id10
    • 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)
        • id206
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(false)
        • large_featured(false)
        • titleTop 10 Luxury Waterfront Properties
        • authorLeverageRE
        • date2014-05-15
        • lead_inFor some, living by the water is undeniably calming. Maybe it's the stillness, or the breeze making gentle ripples on the surface, or maybe it's the quiet majesty of it all.
        • body <p>Take a look at this week's Top 10: Luxe waterfront living, presented for your viewing pleasure, by our Leverage Global Partners from around the world.</p> <h1> <strong>1. Westhampton, NY</strong><br> Represented by First Hampton International Realty</h1> <h6> </h6> <p><img src="/assets/616.jpg" class="pure-img"></p> <p>Located in the elite Westhampton Beach community of New York, this waterfront estate offers a private canal for boats and watercraft.</p> <h1> <strong>2. Vancouver, British Columbia</strong><br> Represented by Angell Hasman & Associates</h1> <p><img src="/assets/617.jpg" class="pure-img"></p> <p>This penthouse in the Ocean Tower Apartments in Vancouver, British Columbia is located on the beach of English Bay and offers 360 degree waterfront views.</p> <h1> <strong>3. Richmond Hills, Georgia</strong><br> Represented by Three Oaks Realty Co.</h1> <p><img src="/assets/618.jpg" class="pure-img"></p> <p>This beautiful home in Richmond Hills, Georgia sits on a bluff along the Ogeechee River with a private boat dock.</p> <h1> <strong>4. Puerto Vallarta, Mexico</strong><br> Represented by Timothy Real Estate Group</h1> <p><img src="/assets/619.jpg" class="pure-img"></p> <p>This stunning estate in Puerto Vallarta offers beautiful beachfront contemporary design surrounded by a lush jungle setting.</p> <h1> <strong>5. Lake Mary, Florida</strong><br> Represented by Fusilier Realty Group</h1> <h6> </h6> <p><img src="/assets/620.jpg" class="pure-img"></p> <p>Situated on beautiful Lake Mary in Florida, this charming waterfront home is located on an exclusive peninsula and features a private lakefront beach and dock.</p> <h1> <strong>6. Austin, Texas</strong><br> Represented by Amelia Bullock Realtors</h1> <p><img src="/assets/621.jpg" class="pure-img"></p> <p>This spectacular <a href="http://www.ameliabullock.com/property/23185326/211-Bella-Riva-DR-Austin-TX-78734" target="_blank" title="Lake Travis estate">Lake Travis estate</a>, located in Austin, Texas, features access to the lake’s shore and an enclosed boat dock.</p> <h1> <strong>7. Tahoe City, California</strong><br> Represented by Boice O’Neal Realty</h1> <h6> </h6> <p><img src="/assets/622.jpg" class="pure-img"></p> <p>On 1.7 acres of pristine lakefront land in Tahoe City, California, this property offers an incredible building opportunity.</p> <h1> <strong>8. Fort Lauderdale, Florida</strong><br> Represented by Intercoastal Realty</h1> <h6> </h6> <p><img src="/assets/623.jpg" class="pure-img"></p> <p>This double lot on premier South Los Olas Isles is a gorgeous waterfront estate in Fort Lauderdale, Florida located five minutes from the Port Everglades inlet to the Atlantic.</p> <h1> <strong>9. Lexington, South Carolina</strong><br> Represented by The Lachicotte Company</h1> <h6> </h6> <p><img src="/assets/624.jpg" class="pure-img"></p> <p>This sanctuary on Lake Murray in Lexington, South Carolina is situated on 1.75 acres on a private waterfront peninsula with a lakefront pool and boat dock.</p> <h1> <strong>10. Kamuela, Hawaii</strong><br> Represented by Mauna Kea Realty</h1> <h6> </h6> <p><img src="/assets/625.jpg" class="pure-img"></p> <p>A wonderful beachfront home in Kamuela, Hawaii offers 1,500 feet of ocean frontage and 400 feet of pristine white sand.</p> <p>Do you dream of living by the water?  Where would you most like to live? Please share your ideas below.</p>
        • vimeo_id
        • created2016-02-25 14:10:53
        • modified2016-04-05 14:41:06
        • uri/articles/view/206/top-10-luxury-waterfront-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)
          • id626
          • modelArticle
          • model_id206
          • tagImage
          • nameTimothy-Outdoor-Oases.jpg
          • typeimage/jpg
          • size382554
          • uri/assets/626.jpg
          • order0
          • created2016-02-25 14:10:54
          • modified2016-03-15 16:38:57
      • 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)
            • id188
            • article_id206
            • topic_id4
        • 1(array)
          • id8
          • nameBeach
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:30:26
          • tile_nameBeach
          • ArticlesTopic(array)
            • id189
            • article_id206
            • topic_id8
    • 3(array)
      • Article(array)
        • id449
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(true)
        • large_featured(false)
        • titleSaturday In The Neighborhood: Koh Samui, Thailand
        • authorLeverageRE
        • date2016-03-24
        • lead_inBASK.  The island's beaches are an embarrassment of riches. The livelier party crowd hangs at Chaweng Beach, with surf shops and bar crawls along the Green Mango strip. Families gravitate toward lower-key Lamai Beach (less bustling, but still near shopping and restaurants) and Bophut (with its Chinese wooden shop-houses). Backpackers and others who really want to chill head straight to Maenam Beach.
        • body<p><img class="wp-image-12780 aligncenter pure-img" src="/assets/3120.jpg" /></p> <p><strong>UNWIND.</strong>  <a href="http://www.tamarindsprings.com/" target="_blank">Tamarind Springs</a>, between Lamai and Chaweng, is renowned for its creative "forest spa" concept, which includes a steam cave and a rock plunge pool.</p> <p><img class="aligncenter wp-image-12777 pure-img" src="/assets/3121.png" /></p> <p><strong>CONTEMPLATE.  </strong>The majority of the island's residents are Buddhist, so beautiful temples abound: Wat Phra Yai, known for its golden, nearly 40-foot Big Buddha; Wat Plai Laem (one of the most colorful complexes); Wat Laem Sor (known for its golden chedi, or pagoda, by the sea) and many <a href="http://samui.sawadee.com/temples/" target="_blank">more</a>.</p> <p><img class="aligncenter wp-image-12775 pure-img" src="/assets/3122.png" /></p> <p><strong>DINE.  </strong>The island possesses prodigious culinary delights. Among the leaders is <a href="http://www.hansarhotels.com/hotels/samui/facilities/h-bistro/" target="_blank">H-Bistro</a> in Bophut, which has frequently wound up on "Best of" lists.</p> <p><img class="aligncenter wp-image-12781 pure-img" src="/assets/3123.png" /></p> <p><strong>DIVE.</strong>  Charter a boat for a day trip exploring <a href="http://www.kosamui.com/ang-thong.htm" target="_blank">Ang Thong National Marine Park</a>, a string of 42 pristine jungle islands offering some of the best kayaking, snorkeling, and diving in the world. Langur monkeys, otters, reef egrets, Hawksbill turtles-they thrive on land and in the secluded bays and lagoons. A major marine spawning ground, it's also home to majestic whale sharks.</p> <p><img class="aligncenter wp-image-12779 pure-img" src="/assets/3124.png" /></p>
        • vimeo_id
        • created2016-04-05 14:30:43
        • modified2016-04-11 17:08:21
        • uri/articles/view/449/saturday-in-the-neighborhood-koh-samui-thailand
        • flattened_topics(array)
          • 0Travel
          • 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)
          • id3125
          • modelArticle
          • model_id449
          • tagImage
          • nameThai-Cover.jpg
          • typeimage/jpg
          • size1292409
          • uri/assets/3125.jpg
          • order0
          • created2016-04-05 14:30:44
          • modified2016-04-11 17:08:21
      • Brokerage(empty)
      • Location(empty)
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id10
          • nameTravel
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:35:10
          • tile_nameTravel
          • ArticlesTopic(array)
            • id372
            • article_id449
            • topic_id10
        • 1(array)
          • id8
          • nameBeach
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:30:26
          • tile_nameBeach
          • ArticlesTopic(array)
            • id371
            • article_id449
            • 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)
        • id13
        • nameTraditional Architecture
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:34:46
        • tile_nameTraditional Architecture
      • Image(array)
        • id20
        • modelTopic
        • model_id13
        • tagImage
        • nameTraditional Architecture.jpg
        • typeimage/jpeg
        • size3416227
        • uri/assets/20.jpg
        • order0
        • created2016-02-25 11:34:43
        • modified2016-02-25 11:34:46
      • 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)
        • id18
        • nameCulinary
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:31:19
        • tile_nameCulinary
      • Image(array)
        • id5
        • modelTopic
        • model_id18
        • tagImage
        • nameCulinary.jpg
        • typeimage/jpeg
        • size4965451
        • uri/assets/5.jpg
        • order0
        • created2016-02-25 11:31:16
        • modified2016-02-25 11:31:19
      • modelTopic
  • recent_articles(array)
    • 0(array)
      • Article(array)
        • id487
        • modelLocation
        • model_id137
        • archived(false)
        • medium_featured(true)
        • large_featured(false)
        • titleLocation: Kiawah Island
        • authorLeverageRE
        • date2016-03-30
        • lead_inA resort community and full-time resident population, Kiawah Island is known for its abundance of wildlife. Explore Mother Nature's beauty on land or in the water, and experience the aquatic life and vegetation that surround this 10-mile stretch of beach.
        • body<p>Experience Kiawah's natural habitat by taking a morning bike ride on one of the island's 30 miles of paved trails or 10 miles of flat beach. <strong>Surfscooter</strong> will deliver your bicycle to your front doorstep, or you might choose from the variety of bike trailers, chariots, and tag-a-longs if you want to adventure around Kiawah with your family in tow.</p> <p><img class="aligncenter wp-image-13087 pure-img" src="/assets/3346.jpg" /></p> <div> <div> <div> <div> <div> <div> <div> <div> <p>Be sure to stop at the nearby <strong>Johns Island Farmers Market</strong> on Saturday morning. In addition to locally sourced produce, the market also offers sustainable educational classes, demonstrations, and interactive opportunities to learn about making sustainable life choices.</p> <p>Endorphin-fueled vacationers will find no lack of sporting activities around the island. Go for a run, kayak in the tidal pools around the island, or enjoy a game of tennis or a round of golf at the Kiawah Island Golf Club. <strong>The Roy Barth Tennis Center </strong>was ranked number three in the United States by Tennis magazine.</p> <p><img class="aligncenter wp-image-13088 pure-img" src="/assets/3347.jpg" /></p> <p>After a full day of activities, visit the <strong>Sushi Lounge at the Atlantic Room</strong> in the Ocean Course Clubhouse to enjoy the freshest locally sourced produce and seafood in the Low country, as well as small plates, cocktails, and fine wines.</p> <p><img class="aligncenter wp-image-13070 pure-img" src="/assets/3348.jpg" /></p> </div> </div> <h6><em>Photos courtesy of: <a href="http://www.kiawahresort.com/blog/kiawah-golf/" target="_blank">Kiawah Island</a>, <a href="http://www.kiawahresort.com/blog/kiawah-island/2014/06/24/bike-around-kiawah-island/" target="_blank">Kiawah Resort</a></em></h6> </div> </div> </div> </div> </div> </div>
        • vimeo_id
        • created2016-04-05 14:35:21
        • modified2016-04-11 17:08:39
        • uri/articles/view/487/location-kiawah-island
      • Image(array)
        • 0(array)
          • id3349
          • modelArticle
          • model_id487
          • tagImage
          • nameKiawah-Island.jpg
          • typeimage/jpg
          • size904980
          • uri/assets/3349.jpg
          • order0
          • created2016-04-05 14:35:21
          • modified2016-04-11 17:08:39
    • 1(array)
      • Article(array)
        • id481
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(true)
        • large_featured(true)
        • titleCelebrity Spotlight: Meridith Baer
        • authorLeverageRE
        • date2016-03-29
        • lead_inA creative storage solution for her plants was all Meridith Baer was looking for when she undertook her first home staging project. The former screenwriter and star of HGTV's Staged to Perfection had 250 potted plants in her rental home in Los Angeles when the landlord said he was ready to sell the property. So she called a friend and convinced him to let her bring the plants and a few pieces of her furniture into the vacant home he was trying to sell. And just like that, it sold- in a bidding war, no less. Now, when celebrities are ready to sell their homes for top dollar, they call Baer.
        • body<p><img class="aligncenter wp-image-12988 pure-img" src="/assets/3312.png" /></p> <p>As founder and CEO of Meridith Baer Home (MBH), she blends luxury with a refined sensibility to help sell homes for top dollar. With a celebrity clientele including Beyoncé, Brad Pitt, and Elon Musk (just to name a few), Baer is now expanding the MBH brand to include a San Francisco office and her own furniture line.</p> <p><img class="aligncenter wp-image-12985 pure-img" src="/assets/3313.png" /></p> <h4><em><strong>How has your vision of the MBH brand expanded from when you first started</strong></em>?</h4> <p>In the beginning I decorated homes for people to help them get top dollar. I did it because it was fun. I never believed I would have a business doing this, let alone a brand. Now we've expanded into seven cities and even staged internationally.</p> <h4><em><strong>At what point did you realized the growth potential (and your potential) in the staging business?</strong></em></h4> <p>After about six months, my phone started ringing off the hook and I started to hire anyone I bumped into that could speak full sentences or had the brawn to lift heavy furniture.</p> <p><img class="aligncenter wp-image-12984 pure-img" src="/assets/3314.png" /></p> <h4><em><strong>What are some of your current projects to diversify within the industry? </strong></em></h4> <p>Currently we have over 500 homes installed in Southern California, Northern California, Florida, Manhattan, the Hamptons, and Connecticut. We are installing about 400 projects a quarter.</p> <p>Besides staging, we are working on everything from resort condominiums in Cabo, to hotels, luxury rental furnishings for clients to live with (not staging), multi-million-dollar interior design projects, furniture, and accessory manufacturing. We are working on charity projects to give back in 2015.</p> <p><img class="aligncenter wp-image-12982 pure-img" src="/assets/3315.png" /></p> <h4><em><strong>What goes into developing a furniture line? How did you identify that need in the market? </strong></em></h4> <p>We got into manufacturing because we couldn't find all of the new and exciting pieces we were looking for. Joe Asher and Heide Zeiker from our company said, "Let's just make them ourselves!" We aim to keep our look basic but fresh and exciting by staying ahead of the trends and introducing unique new pieces. We get our inspiration from history, our travels, and everything we see and do.</p> <h4><strong><em>Where do you see MBH in the next five years? </em></strong></h4> <p>Given the brilliant and talented group we have become, I don't know where we will end up in the next five years. Mars? I am certain Martians want to live beautifully, too. Kidding aside, I believe we will expand to other key cities, including Houston, Washington, D.C., Atlanta, Las Vegas, and resort communities like Aspen and Sun Valley. Maybe even London and Paris. I'd also like to see our manufacturing double or triple, since designing the furniture line has been a highlight of mine this year.</p> <p><img class="aligncenter wp-image-12986 pure-img" src="/assets/3316.png" /></p> <h4><em><strong>What are you excited about right now outside of business?</strong> </em></h4> <p>Life outside of business . . . what's that? I have not had much of a personal life in the last 18 years, and would love to do something about that. As always, I am excited by design and designers all over the world. Everyone in our group wants to find ways to give back to the communities we work in. We are currently working with this amazing charity, A Sense of Home, that I'm thrilled about. Their organization changes the lives of foster youth who've "aged out" of the foster care system by creating homes for them. Using furniture and housewares from our collection, we're working with their team of volunteers to help these youth start their life with a place to call home and help them achieve self-sufficiency. It's been a heartwarming and uplifting experience.</p> <p><img class="aligncenter wp-image-12981 pure-img" src="/assets/3317.png" /></p> <h2><strong>TIPS FROM MERIDITH</strong></h2> <p><strong>My philosophy is,</strong> start with a very quiet palette and bring the personality and color onto that palette, as if the furniture were a blank canvas.</p> <p><strong>What brings the luxury</strong> to the room are things like rugs, cashmere throws, and beautiful décor pillows. To [make it feel lived in], we have little vignettes around the home that show where the kids would probably play, where you put your glasses beside the bed, a cookbook open in the kitchen, hints of clothing in the closet, and tons of fluffy white towels in the bathroom-different things that are attractive, but still tell the story.</p> <p><strong>When it comes to staging a home,</strong> the key is showing prospective buyers the ideal lifestyle that they can have in the space. We sort of make it easy for them. We really show them what their home could look like if they buy it.</p> <p><img class="aligncenter wp-image-12987 pure-img" src="/assets/3318.png" /></p> <h6><em>Photos courtesy of <a href="http://meridithbaer.com/" target="_blank">Meridith Baer Home</a></em></h6>
        • vimeo_id
        • created2016-04-05 14:35:01
        • modified2016-04-11 16:56:53
        • uri/articles/view/481/celebrity-spotlight-meridith-baer
      • Image(array)
        • 0(array)
          • id3319
          • modelArticle
          • model_id481
          • tagImage
          • nameScreen-Shot-2016-03-29-at-1.54.46-PM.png
          • typeimage/png
          • size1184066
          • uri/assets/3319.png
          • order0
          • created2016-04-05 14:35:04
          • modified2016-04-11 16:56:53
  • article_model_overrideLocation
  • article(array)
    • Article(array)
      • id488
      • modelLocation
      • model_id28
      • archived(false)
      • medium_featured(false)
      • large_featured(true)
      • titleLocation: Malibu
      • authorLeverageRE
      • date2016-03-30
      • lead_inWith the ocean, mountains, sun and sky, discover California dreamin' in the beautiful beach town of Malibu. Breathtaking sunsets and perfect, year-round climate, rugged beaches, numerous hiking trails, and plenty of Hollywood's beautiful people make Malibu an iconic destination.
      • body<p>Make a reservation to try one of Chef Nobu Matsuhisa's signature dishes, such as Tiradito, Yellowtail Sashimi with Jalapeño, and Black Cod Miso at his beachside restaurant <strong>Nobu</strong>. Then take the scenic Pacific Coast Highway to <strong>Westward Rock</strong>, where you can catch the sunset.</p> <p><img class="aligncenter wp-image-13084 pure-img" src="/assets/3350.png" /></p> <p>Rent a board from <strong>Malibu Surf Shack</strong> and catch a wave or paddleboard Malibu's famous Surfrider Beach. More than just a rental shop, the Surf Shack offers surfing, stand-up paddleboard, and kayak lessons, as well as tours of the coast.</p> <p><img class="aligncenter size-full wp-image-13083 pure-img" src="/assets/3351.jpg" /></p> <p>Visit Crosscreek Road at <strong>Malibu Country Mart</strong>, California's premier location for shopping, dining, and relaxing. Unlike more typical stores, Malibu Country Mart goes beyond the usual cookie-cutter consumerism, offering its own unique and upscale boutiques, art galleries, and sculpture gardens.</p> <p><img class="aligncenter wp-image-13056 pure-img" src="/assets/3352.png" /></p> <p>Say hi to George, owner of <strong>Zuma Canyon Orchids</strong>, and pick up one of his orchids, most of which can only be described as "outrageous."</p> <p>Wake up early to grab a fried-egg sandwich at <strong>Malibu Farm Pier Cafe</strong>. Located at the beginning and end of the pier, the cafe sources all of its organic ingredients and produce locally-some of the eggs even come from the chickens in the owner's backyard.</p> <p><img class="aligncenter wp-image-13052 pure-img" src="/assets/3353.jpg" /></p> <h6><em>Photos courtesy of: <a href="http://www.noburestaurants.com/malibu/experience/" target="_blank">Nobu</a>, <a href="http://malibusurfshack.com/" target="_blank">Malibu Surf Shack</a>,<br /> <a href="https://www.facebook.com/malibufarm/photos_stream?tab=photos_stream" target="_blank">Malibu Farm Facebook</a>, <a href="http://www.malibucountrymart.com/" target="_blank">Malibu Country Mart</a></em></h6>
      • vimeo_id
      • created2016-04-05 14:35:21
      • modified2016-04-11 16:59:36
      • uri/articles/view/488/location-malibu
      • 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)
      • id28
      • parent_id9
      • brokerage_id142
      • typeExclusive
      • archived(false)
      • use_as_topic(false)
      • nameMalibu, CA, USA
      • short_nameMalibu, CA, USA
      • group_index
      • latitude34.025921
      • longitude-118.779755
      • country_code
      • north53.700001
      • south19.700001
      • east-52.599998
      • west-146.600006
      • zoom0
      • short_descriptionFamed for its beaches and cool surfer style, Malibu’s beauty is in a class by itself.
      • long_descriptionThis idyllic beach community with 27 miles of scenic coastline beckons visitors from around the world and its wooded hills and canyons offer a chance to reconnect with nature. Despite its worldwide renown, Malibu still offers the feel of a small town where people know and care about each other. Known locally as the 'Bu, much of Malibu is arrayed along a long curving stretch of Pacific Coast Highway. Malibu real estate is all about the beach. Many of the area's most expensive properties sit directly on the beach with Carbon Beach being especially known for beautiful and very expensive real estate. Malibu real estate also extends into the surrounding hills and canyons where properties often have larger lots and feature ocean views.
      • created2016-04-04 11:50:57
      • modified2016-04-12 16:13:24
      • timezoneAmerica/Los_Angeles
      • population12800
      • uri/locations/view/28/malibu-ca-usa
      • tile_nameMalibu, CA, USA
    • Image(array)
      • 0(array)
        • id3354
        • modelArticle
        • model_id488
        • tagImage
        • nameScreen-Shot-2016-03-28-at-7.01.41-PM.png
        • typeimage/png
        • size2266902
        • uri/assets/3354.png
        • order0
        • created2016-04-05 14:35:22
        • modified2016-04-11 16:59:36
    • Brokerage(array)
      • 0(array)
        • id5
        • account_executive_id236
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties12
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties2
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(true)
        • country_id1
        • WOEID2468964
        • timezoneUS/Pacific
        • luxury_feed_enrollment_modemanual
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id
        • mlsidx_lux_autofeed(false)
        • mlsidx_lux_autofeed_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • namePartners Trust Real Estate Brokerage and Acquisitions
        • broker_of_record_name
        • short_namePartners Trust Real Estate
        • usernamePartnersTrustPas
        • password5b28522e46f56278664573d82c2b0f03520519d0
        • password_reset_hash
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date0000-00-00
        • monthly_invoice_end_date0000-00-00
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>Partners Trust is the exclusive representative for Leverage Global Partners in Pasadena and La Cañada Flintridge, California, USA.</p> <p>At Partners Trust, we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market, presenting our clients with the most professional, successful and ethical real estate associates in the business. We represent our clients with care, confidentiality and the utmost attention to service.</p> <p>Pasadena is a harmonious blend of past and present. Experience the nationally-televised Rose Parade, catch an exciting football game at the Rose Bowl, get smart at Caltech, or revel in the Jet Propulsion Laboratory.</p> <p>The community is renowned for its charming and diverse neighborhoods whose residents honor and preserve the splendor of early California architecture. Opportunities abound to experience Pasadena’s sophisticated culture with the diversified entertainment at the Pasadena Playhouse, the Norton Simon Museum, the Huntington Library and Botanical Gardens and even by walking along the vibrant, historic district of Colorado Boulevard.</p> <p>Partners Trust associates are proud to represent a wide variety of historic and architecturally diverse homes, including the Craftsman-style home. We understand our clients discerning needs, and provide a high level of service and local area knowledge.</p> <p>Partners Trust has additional office locations in <a href="../../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/142/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Malibu</a>, and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a></p>
        • communitiesPasadena La Canada Flintridge San Marino La Canada Flintridge
        • websitehttp://www.thepartnerstrust.com
        • address594 E. Colorado Boulevard
        • address_2
        • cityPasadena
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • marketPasadena
        • market_2
        • postal_code91101
        • phone(626) 696-4802
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameScott Brown
        • contact_profile_link
        • contact_big_profile_linkhttp://www.leveragere.com/blog/meet-scott-brown-managing-director-partners-trust-pasadena/
        • contact_big_profile_link_text
        • contact_titleManaging Director
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2Nick Segal
        • contact_profile_link_2http://www.leveragere.com/brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2President/Co-Founder
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename5.jpg
        • logo_filename5.png
        • contact_image_filename5.jpg
        • all_properties_link_image_filename5.jpg
        • all_properties_linkhttp://www.thepartnerstrust.com/properties
        • video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
        • contact_video_embed_code
        • meta_titlePasadena Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
        • meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Pasadena, CA is a premier boutique Pasadena real estate brokerage and the exclusive Pasadena representative for Leverage Global Partners.
        • meta_keywordspartners trust, partners trust real estate, pasadena real estate, leverage global partners, pasadena homes for sale, scott brown
        • login_message_counter1
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-03-18 16:08:06
        • modified2016-04-08 16:33:22
        • dre_num012345
        • uri/brokerage-detail/5/partners-trust-real-estate-brokerage-and-acquisitions
        • website_shortwww.thepartnerstrust.com
        • name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
        • ArticlesBrokerage(array)
          • id47
          • article_id488
          • brokerage_id5
    • Location(array)
      • 0(array)
        • id28
        • parent_id9
        • brokerage_id142
        • typeExclusive
        • archived(false)
        • use_as_topic(false)
        • nameMalibu, CA, USA
        • short_nameMalibu, CA, USA
        • group_index
        • latitude34.025921
        • longitude-118.779755
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_descriptionFamed for its beaches and cool surfer style, Malibu’s beauty is in a class by itself.
        • long_descriptionThis idyllic beach community with 27 miles of scenic coastline beckons visitors from around the world and its wooded hills and canyons offer a chance to reconnect with nature. Despite its worldwide renown, Malibu still offers the feel of a small town where people know and care about each other. Known locally as the 'Bu, much of Malibu is arrayed along a long curving stretch of Pacific Coast Highway. Malibu real estate is all about the beach. Many of the area's most expensive properties sit directly on the beach with Carbon Beach being especially known for beautiful and very expensive real estate. Malibu real estate also extends into the surrounding hills and canyons where properties often have larger lots and feature ocean views.
        • created2016-04-04 11:50:57
        • modified2016-04-12 16:13:24
        • timezoneAmerica/Los_Angeles
        • population12800
        • uri/locations/view/28/malibu-ca-usa
        • tile_nameMalibu, CA, USA
        • ArticlesLocation(array)
          • id34
          • article_id488
          • location_id28
    • Property(empty)
    • Topic(array)
      • 0(array)
        • id8
        • nameBeach
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:30:26
        • tile_nameBeach
        • ArticlesTopic(array)
          • id336
          • article_id488
          • 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/488/location-malibu
  Query String
  Request Method	GET
  Server Protocol	HTTP/1.1
  Gateway Interface	CGI/1.1
  Redirect Url	/articles/view/488/location-malibu
  Remote Port	15232
  Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
  Server Admin	root@localhost
  Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
  Context Prefix
  Request Scheme	https
  Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
  Remote Addr	162.159.115.42
  Server Port	443
  Server Addr	172.24.32.44
  Server Name	staging2.leveragere.com
  Server Software	Apache
  Server Signature
  Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
  Http Host	staging2.leveragere.com
  Http Connection	Keep-Alive
  Http X Forwarded Proto	https
  Http Cf Visitor	{"scheme":"https"}
  Http Cf Ipcountry	US
  Http Cf Connecting Ip	216.73.216.172
  Http Cdn Loop	cloudflare; loops=1
  Http Cf Ray	a09da600fda21cc4-CMH
  Http Accept Encoding	gzip, br
  Http Cookie	CAKEPHP=1aimmaq12r9s13gpdbdnr8q8cg
  Http Accept	*/*
  Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
  Http X Forwarded For	216.73.216.172
  Proxy-nokeepalive	1
  Ssl Tls Sni	staging2.leveragere.com
  Https	on
  Passenger Download Native Support Binary	0
  Passenger Compile Native Support Binary	0
  Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
  Unique Id	aiowYe8a9lJ8yShPtH272wAAAsA
  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	aiowYe8a9lJ8yShPtH272wAAAsA
  Fcgi Role	RESPONDER
  Php Self	/index.php
  Request Time Float	1781149793.4554
  Request Time	1781149793

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

  ====