Meet LIV REAL ESTATE: Edmonton, AB, Canada

LeverageRE

Get to know Liv Real Estate, the exclusive representative for Leverage Global Partners in Edmonton, Spruce Grove, St. Albert, Sherwood Park, Devon, Stony Plain, Leduc, Beaumont, and Fort Saskatchewan, Alberta, Canada.

We wanted to have a brand that represented our values. One that was focused on how we would want to be treated as a customer and as an agent. We wanted to bring together a fun, collaborative, professional group of agents that get results by working hard, and doing it right. We are very committed to providing excellent customer service and to prove it we don’t have any sales awards, we only recognize exceptional customer service, leadership and community involvement. 

Sheldon Johnston: Early in my career I was motivated by numbers; every year I chased awards and achieved my goals, becoming one of the top producing agents in Canada. When I realized that my past clients weren’t coming back to me, I also realized that I needed to shift my focus; just because my numbers said I was awesome, didn’t mean that I was. From that point on my focus has been on my clients, and we only select agents to work at Liv that put their clients first.

Sara MacLennan: After five years at the Canadian head office for Coldwell Banker, showing agents and brokers how to use the power of the internet to grow their businesses, I decided to take my skills to the street and found my true calling running the brokerage with Sheldon. At Liv Real Estate, I focus on marketing (although I'm licensed to sell real estate) and business development for our brokerage. Today our small brokerage has some of the most visited real estate web sites in Edmonton, getting over 225,000 sessions and 3.5 million page views/month! It was the scariest and best decision I ever made.

Online marketing is the core of our success. Our dominant position in search engine results has levelled the playing field between us and the big guys. Through inbound marketing we reach buyers and sellers when they are actually thinking about buying or selling a home. Being found is a huge asset to us in driving business to our agents and it allows us the pick of the best agents that fit our values.

Edmonton is an amazing city; there is so much going on here. Our incredible River Valley, which runs right through the city, is the largest urban park in North America (22 times bigger than Central Park in New York). We love hitting the trails in the River Valley on our mountain bikes – there’s over 1300 km of trails in Edmonton so you never run out of places to ride. Edmonton is big on festivals, we have about 300 every year including the largest and oldest “Fringe Festival” in North America, and an amazing Folk Festival held in the river valley with our city skyline as a backdrop. And then of course there is the “Ice District” a new downtown 25 acre sports and entertainment development centred around a new hockey arena (yes, hockey is a VERY big deal here). 

Leverage Global Partners is proud to have Sheldon Johnston, Sara MacLennan, and the team at Liv Real Estate as our partners in the network.

Share

• Partner:
• Liv Real Estate

Recent Articles

Home Improvement: Take It Outside

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

How to Plan and Plant Your Own Vegetable Garden

Deciding to plant your own vegetable garden is a healthy plan and rewarding in many ways, but...

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] => 424
            [model] => Brokerage
            [model_id] => 210
            [archived] => 
            [medium_featured] => 1
            [large_featured] => 1
            [title] => Meet LIV REAL ESTATE: Edmonton, AB, Canada
            [author] => LeverageRE
            [date] => 2015-11-13
            [lead_in] => Get to know Liv Real Estate, the exclusive representative for Leverage Global Partners in Edmonton, Spruce Grove, St. Albert, Sherwood Park, Devon, Stony Plain, Leduc, Beaumont, and Fort Saskatchewan, Alberta, Canada.
            [body] => 


We wanted to have a brand that represented our values. One that was focused on how we would want to be treated as a customer and as an agent. We wanted to bring together a fun, collaborative, professional group of agents that get results by working hard, and doing it right. We are very committed to providing excellent customer service and to prove it we don’t have any sales awards, we only recognize exceptional customer service, leadership and community involvement. 
Sheldon Johnston: Early in my career I was motivated by numbers; every year I chased awards and achieved my goals, becoming one of the top producing agents in Canada. When I realized that my past clients weren’t coming back to me, I also realized that I needed to shift my focus; just because my numbers said I was awesome, didn’t mean that I was. From that point on my focus has been on my clients, and we only select agents to work at Liv that put their clients first.

Sara MacLennan: After five years at the Canadian head office for Coldwell Banker, showing agents and brokers how to use the power of the internet to grow their businesses, I decided to take my skills to the street and found my true calling running the brokerage with Sheldon. At Liv Real Estate, I focus on marketing (although I'm licensed to sell real estate) and business development for our brokerage. Today our small brokerage has some of the most visited real estate web sites in Edmonton, getting over 225,000 sessions and 3.5 million page views/month! It was the scariest and best decision I ever made.
Online marketing is the core of our success. Our dominant position in search engine results has levelled the playing field between us and the big guys. Through inbound marketing we reach buyers and sellers when they are actually thinking about buying or selling a home. Being found is a huge asset to us in driving business to our agents and it allows us the pick of the best agents that fit our values.

Edmonton is an amazing city; there is so much going on here. Our incredible River Valley, which runs right through the city, is the largest urban park in North America (22 times bigger than Central Park in New York). We love hitting the trails in the River Valley on our mountain bikes – there’s over 1300 km of trails in Edmonton so you never run out of places to ride. Edmonton is big on festivals, we have about 300 every year including the largest and oldest “Fringe Festival” in North America, and an amazing Folk Festival held in the river valley with our city skyline as a backdrop. And then of course there is the “Ice District” a new downtown 25 acre sports and entertainment development centred around a new hockey arena (yes, hockey is a VERY big deal here). 

Leverage Global Partners is proud to have Sheldon Johnston, Sara MacLennan, and the team at Liv Real Estate as our partners in the network.

            [vimeo_id] => 
            [created] => 2016-02-25 14:14:31
            [modified] => 2016-04-05 14:41:07
            [uri] => /articles/view/424/meet-liv-real-estate-edmonton-ab-canada
            [flattened_topics] => Array
                (
                )

        )

    [ParentBrokerage] => Array
        (
            [id] => 210
            [account_executive_id] => 0
            [archived] => 
            [type] => brokerage
            [hide_from_frontend] => 
            [agent_brokerage_data_override] => 
            [featured_development] => 
            [membership_type] => Basic
            [max_properties] => 8
            [max_homepage_featured_by_member_properties] => 0
            [featured_properties_sort_method] => manual
            [lux_feed_mode] => StripeSubscription
            [max_luxury_feed_properties] => 0
            [membership_luxury_feed_properties] => 0
            [can_participate_in_lux_feed_while_archived] => 
            [full_training_video_access] => 
            [country_id] => 0
            [WOEID] => 8676
            [timezone] => America/Edmonton
            [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] => Liv Real Estate
            [broker_of_record_name] => 
            [short_name] => Liv Real Estate
            [username] => LivRealEstate
            [password] => 043b3ff63be4366b17c1e79d5a02160f148729ec
            [password_reset_hash] => 
            [monthly_invoice_amount] => 
            [monthly_invoice_start_date] => 
            [monthly_invoice_end_date] => 
            [contract_filename] => 
            [active] => 1
            [lead_in] => 
            [short_description] => 
            [description] => 
Liv Real Estate is the exclusive representative for Leverage Global Partners in Edmonton, Spruce Grove, St. Albert, Sherwood Park, Devon, Stony Plain, Leduc, Beaumont, and Fort Saskatchewan, Alberta, Canada.

Selling your home is about you, and should feel as familiar and safe as your backyard. We believe in making our clients savvy, so they are part of the conversation when it comes to aligning big decisions with the best move.

Liv offers a fresh perspective to real estate with a new outlook on dotted lines and traditional relationships between agents and homeowners. We take the artifice out of the transaction and the bus bench out of the relationship. We are homeowners too, and we stand behind a transparent process.

When it’s time to give up the growth charts notched into your walls, or find familiar creaky floorboards in new surroundings, Liv is ready for you. We don’t want to be famous, we just want you to Love Where You Liv, and help you make sense of moving in, or moving on.

This is how real estate really is.

            [communities] => Edmonton
Spruce Grove
St. Albert
Sherwood Park
Devon
Stony Plain
Leduc
Beaumont
Fort Saskatchewan
            [website] => http://www.livrealestate.ca/
            [address] => 18831 111 Ave.
            [address_2] => 
            [city] => Edmonton
            [state] => AB
            [full_state] => Alberta
            [country] => Canada
            [market] => Edmonton
            [market_2] => 
            [postal_code] => T5S 2X4
            [phone] => Direct: (780) 486-8655
            [phone_2] => Cell: (780) 441-5576
            [phone_3] => 
            [wide_contact_image] => 
            [contact_name] => Sheldon Johnston
            [contact_profile_link] => 
            [contact_big_profile_link] => 
            [contact_big_profile_link_text] => 
            [contact_title] => Broker/Owner
            [contact_dre_num] => 
            [contact_quote] => 
            [contact_email] => [email protected]
            [contact_facebook] => 
            [contact_twitter] => 
            [contact_instagram] => 
            [contact_pinterest] => 
            [contact_linkedin] => 
            [contact_youtube] => 
            [contact_phone] => 
            [contact_email_2] => 
            [contact_2_facebook] => 
            [contact_2_twitter] => 
            [contact_2_instagram] => 
            [contact_2_pinterest] => 
            [contact_2_linkedin] => 
            [contact_2_youtube] => 
            [contact_phone_2] => 
            [contact_website] => 
            [contact_name_2] => 
            [contact_profile_link_2] => 
            [contact_big_profile_link_2] => 
            [contact_big_profile_link_text_2] => 
            [contact_title_2] => 
            [contact_dre_num_2] => 
            [contact_email_3] => 
            [contact_name_3] => 
            [contact_title_3] => 
            [contact_dre_num_3] => 
            [contact_phone_3] => 
            [contact_3_facebook] => 
            [contact_3_twitter] => 
            [contact_3_instagram] => 
            [contact_3_pinterest] => 
            [contact_3_linkedin] => 
            [contact_3_youtube] => 
            [image_filename] => 210.jpg
            [logo_filename] => 210.jpg
            [contact_image_filename] => 210.jpg
            [all_properties_link_image_filename] => 210.jpg
            [all_properties_link] => http://www.livrealestate.ca/our-listings/
            [video_embed_code] => 
            [contact_video_embed_code] => 
            [meta_title] => Edmonton Real Estate⎜LIV Real Estate⎜Leverage Global Partners
            [meta_description] => LIV Real Estate is the exclusive representative for Leverage Global Partners in Edmonton, AB, Canada.
            [meta_keywords] => LIV Real Estate, Edmonton Real Estate, Spruce Grove Real Estate, St. Albert Real Estate, Sherwood Park Real Estate, Devon Real Estate, Stony Plain Real Estate, Leduc Real Estate, Beaumont Real Estate, Fort Saskatchewan Real Estate, Alberta Real Estate, Sheldon Johnston, Leverage Global Partners
            [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] => 2015-06-25 09:59:11
            [modified] => 2016-04-14 10:57:52
            [dre_num] => 012345
            [uri] => /brokerage-detail/210/liv-real-estate
            [website_short] => www.livrealestate.ca
            [name_with_location] => Liv Real Estate
        )

    [ParentLocation] => Array
        (
            [id] => 
            [parent_id] => 
            [brokerage_id] => 
            [type] => 
            [archived] => 
            [use_as_topic] => 
            [name] => 
            [short_name] => 
            [group_index] => 
            [latitude] => 
            [longitude] => 
            [country_code] => 
            [north] => 
            [south] => 
            [east] => 
            [west] => 
            [zoom] => 
            [short_description] => 
            [long_description] => 
            [created] => 
            [modified] => 
            [timezone] => 
            [population] => 
        )

    [Image] => Array
        (
            [0] => Array
                (
                    [id] => 2177
                    [model] => Article
                    [model_id] => 424
                    [tag] => Image
                    [name] => PPSS-28.jpg
                    [type] => image/jpg
                    [size] => 267876
                    [uri] => /assets/2177.jpg
                    [order] => 0
                    [created] => 2016-02-25 14:14:31
                    [modified] => 2016-02-25 14:14:31
                )

        )

    [Brokerage] => Array
        (
        )

    [Location] => Array
        (
        )

    [Property] => Array
        (
        )

    [Topic] => Array
        (
        )

)

• 
• History
  +

  Request History

  4 previous requests available

  • Restore to current request
  • articles/view/254/how-to-summer-entertaining-in-style
  • articles/view/189/from-the-lookbook-location-location-paris
  • articles/view/267/meet-vanessa-bergmark-red-oak-realty-berkeley-ca
  • agent-detail/513/andy-alexander

  ====
• Session
  +

  Session

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

  ====
• Request
  +

  Request

  Cake Params

  • plugin(null)
  • controllerarticles
  • actionview
  • named(empty)
  • pass(array)
    • 0424
    • 1meet-liv-real-estate-edmonton-ab-canada
  • 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: 18 ms
  Total Queries: 28 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` = 424 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` = (424) 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` = 424 AND `ArticlesBrokerage`.`brokerage_id` = `Brokerage`.`id`)	0	0	0
  SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `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` = 424 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` = 424 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` = 424 AND `ArticlesTopic`.`topic_id` = `Topic`.`id`)	0	0	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`, `AccountExecutive`.`id`, `AccountExecutive`.`type`, `AccountExecutive`.`brokerage_id`, `AccountExecutive`.`email`, `AccountExecutive`.`password`, `AccountExecutive`.`recover_hash`, `AccountExecutive`.`first_name`, `AccountExecutive`.`last_name`, `AccountExecutive`.`title`, `AccountExecutive`.`dre_num`, `AccountExecutive`.`phone`, `AccountExecutive`.`max_luxury_feed_properties`, `AccountExecutive`.`headshot_filename`, `AccountExecutive`.`bio`, `AccountExecutive`.`brokerage_name_override`, `AccountExecutive`.`stripe_customer_id`, `AccountExecutive`.`digital_ad_first_free_month_coupon`, `AccountExecutive`.`modified`, `AccountExecutive`.`created`, `AccountExecutive`.`notified`, (CONCAT(`AccountExecutive`.`first_name`, " ", `AccountExecutive`.`last_name`)) AS `AccountExecutive__full_name`, `Logo`.`id`, `Logo`.`model`, `Logo`.`model_id`, `Logo`.`tag`, `Logo`.`name`, `Logo`.`type`, `Logo`.`size`, `Logo`.`uri`, `Logo`.`order`, `Logo`.`created`, `Logo`.`modified`, `MainImage`.`id`, `MainImage`.`model`, `MainImage`.`model_id`, `MainImage`.`tag`, `MainImage`.`name`, `MainImage`.`type`, `MainImage`.`size`, `MainImage`.`uri`, `MainImage`.`order`, `MainImage`.`created`, `MainImage`.`modified`, `ContactImage`.`id`, `ContactImage`.`model`, `ContactImage`.`model_id`, `ContactImage`.`tag`, `ContactImage`.`name`, `ContactImage`.`type`, `ContactImage`.`size`, `ContactImage`.`uri`, `ContactImage`.`order`, `ContactImage`.`created`, `ContactImage`.`modified`, `ContactImage2`.`id`, `ContactImage2`.`model`, `ContactImage2`.`model_id`, `ContactImage2`.`tag`, `ContactImage2`.`name`, `ContactImage2`.`type`, `ContactImage2`.`size`, `ContactImage2`.`uri`, `ContactImage2`.`order`, `ContactImage2`.`created`, `ContactImage2`.`modified`, `ContactImage3`.`id`, `ContactImage3`.`model`, `ContactImage3`.`model_id`, `ContactImage3`.`tag`, `ContactImage3`.`name`, `ContactImage3`.`type`, `ContactImage3`.`size`, `ContactImage3`.`uri`, `ContactImage3`.`order`, `ContactImage3`.`created`, `ContactImage3`.`modified`, `BrokerOfRecordLogo`.`id`, `BrokerOfRecordLogo`.`model`, `BrokerOfRecordLogo`.`model_id`, `BrokerOfRecordLogo`.`tag`, `BrokerOfRecordLogo`.`name`, `BrokerOfRecordLogo`.`type`, `BrokerOfRecordLogo`.`size`, `BrokerOfRecordLogo`.`uri`, `BrokerOfRecordLogo`.`order`, `BrokerOfRecordLogo`.`created`, `BrokerOfRecordLogo`.`modified`, `MainArticle`.`id`, `MainArticle`.`model`, `MainArticle`.`model_id`, `MainArticle`.`archived`, `MainArticle`.`medium_featured`, `MainArticle`.`large_featured`, `MainArticle`.`title`, `MainArticle`.`author`, `MainArticle`.`date`, `MainArticle`.`lead_in`, `MainArticle`.`body`, `MainArticle`.`vimeo_id`, `MainArticle`.`created`, `MainArticle`.`modified` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` LEFT JOIN `leveragere_staging2`.`users` AS `AccountExecutive` ON (`Brokerage`.`account_executive_id` = `AccountExecutive`.`id`) LEFT JOIN `leveragere_staging2`.`assets` AS `Logo` ON (`Logo`.`model_id` = `Brokerage`.`id` AND `Logo`.`model` = 'Brokerage' AND `Logo`.`tag` = 'Logo') LEFT JOIN `leveragere_staging2`.`assets` AS `MainImage` ON (`MainImage`.`model_id` = `Brokerage`.`id` AND `MainImage`.`model` = 'Brokerage' AND `MainImage`.`tag` = 'MainImage') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage` ON (`ContactImage`.`model_id` = `Brokerage`.`id` AND `ContactImage`.`model` = 'Brokerage' AND `ContactImage`.`tag` = 'ContactImage') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage2` ON (`ContactImage2`.`model_id` = `Brokerage`.`id` AND `ContactImage2`.`model` = 'Brokerage' AND `ContactImage2`.`tag` = 'ContactImage2') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage3` ON (`ContactImage3`.`model_id` = `Brokerage`.`id` AND `ContactImage3`.`model` = 'Brokerage' AND `ContactImage3`.`tag` = 'ContactImage3') LEFT JOIN `leveragere_staging2`.`assets` AS `BrokerOfRecordLogo` ON (`BrokerOfRecordLogo`.`model_id` = `Brokerage`.`id` AND `BrokerOfRecordLogo`.`model` = 'Brokerage' AND `BrokerOfRecordLogo`.`tag` = 'BrokerOfRecordLogo') LEFT JOIN `leveragere_staging2`.`articles` AS `MainArticle` ON (`MainArticle`.`model_id` = `Brokerage`.`id` AND `MainArticle`.`model` = 'Brokerage') WHERE `Brokerage`.`id` = 210 LIMIT 1	1	1	1
  SELECT `FeaturedImage`.`id`, `FeaturedImage`.`model`, `FeaturedImage`.`model_id`, `FeaturedImage`.`tag`, `FeaturedImage`.`name`, `FeaturedImage`.`type`, `FeaturedImage`.`size`, `FeaturedImage`.`uri`, `FeaturedImage`.`order`, `FeaturedImage`.`created`, `FeaturedImage`.`modified` FROM `leveragere_staging2`.`assets` AS `FeaturedImage` WHERE `FeaturedImage`.`model` = 'Brokerage' AND `FeaturedImage`.`tag` = 'FeaturedImage' AND `FeaturedImage`.`model_id` = (210) ORDER BY `FeaturedImage`.`order` ASC	0	0	0
  SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population` FROM `leveragere_staging2`.`locations` AS `Location` WHERE `Location`.`brokerage_id` = (210)	1	1	0
  SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name` FROM `leveragere_staging2`.`users` AS `User` WHERE `User`.`brokerage_id` = (210)	9	9	0
  SELECT `Article`.`id` FROM `leveragere_staging2`.`articles` AS `Article` WHERE `Article`.`archived` = '0' AND NOT (`Article`.`model` = ('News')) ORDER BY `Article`.`date` DESC LIMIT 10	10	10	2	maybe slow
  SELECT `Article`.`id`, `Article`.`model`, `Article`.`model_id`, `Article`.`archived`, `Article`.`medium_featured`, `Article`.`large_featured`, `Article`.`title`, `Article`.`author`, `Article`.`date`, `Article`.`lead_in`, `Article`.`body`, `Article`.`vimeo_id`, `Article`.`created`, `Article`.`modified` FROM `leveragere_staging2`.`articles` AS `Article` WHERE `Article`.`id` IN (499, 486, 488, 487, 436, 476, 437, 477, 481, 479) ORDER BY RAND() ASC LIMIT 2	2	2	1	maybe slow
  SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (436, 476) ORDER BY `Image`.`order` ASC	2	2	0
  SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`topics` AS `Topic` LEFT JOIN `leveragere_staging2`.`assets` AS `Image` ON (`Image`.`model_id` = `Topic`.`id` AND `Image`.`model` = 'Topic' AND `Image`.`tag` = 'Image') WHERE NOT (`Topic`.`id` IS NULL) ORDER BY RAND() ASC LIMIT 3	3	3	1	maybe slow
  SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`locations` AS `Location` LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Location`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`assets` AS `Image` ON (`Image`.`model_id` = `Location`.`id` AND `Image`.`model` = 'Location' AND `Image`.`tag` = 'Image') WHERE `Location`.`use_as_topic` = '1' AND NOT (`Location`.`id` IS NULL) ORDER BY RAND() ASC LIMIT 1	1	1	2	maybe slow
  SELECT `Article`.`id`, `Article`.`model`, `Article`.`model_id`, `Article`.`archived`, `Article`.`medium_featured`, `Article`.`large_featured`, `Article`.`title`, `Article`.`author`, `Article`.`date`, `Article`.`lead_in`, `Article`.`body`, `Article`.`vimeo_id`, `Article`.`created`, `Article`.`modified`, `ParentBrokerage`.`id`, `ParentBrokerage`.`account_executive_id`, `ParentBrokerage`.`archived`, `ParentBrokerage`.`type`, `ParentBrokerage`.`hide_from_frontend`, `ParentBrokerage`.`agent_brokerage_data_override`, `ParentBrokerage`.`featured_development`, `ParentBrokerage`.`membership_type`, `ParentBrokerage`.`max_properties`, `ParentBrokerage`.`max_homepage_featured_by_member_properties`, `ParentBrokerage`.`featured_properties_sort_method`, `ParentBrokerage`.`lux_feed_mode`, `ParentBrokerage`.`max_luxury_feed_properties`, `ParentBrokerage`.`membership_luxury_feed_properties`, `ParentBrokerage`.`can_participate_in_lux_feed_while_archived`, `ParentBrokerage`.`full_training_video_access`, `ParentBrokerage`.`country_id`, `ParentBrokerage`.`WOEID`, `ParentBrokerage`.`timezone`, `ParentBrokerage`.`luxury_feed_enrollment_mode`, `ParentBrokerage`.`luxury_feed_include_mlsidx_minimum_price`, `ParentBrokerage`.`luxury_feed_include_leverage_minimum_price`, `ParentBrokerage`.`digital_ad_contacts`, `ParentBrokerage`.`add_agents_to_grr_auto_recipients`, `ParentBrokerage`.`mlsidx_id`, `ParentBrokerage`.`mlsidx_lux_autofeed`, `ParentBrokerage`.`mlsidx_lux_autofeed_minimum_price`, `ParentBrokerage`.`mlsidx_logo_url`, `ParentBrokerage`.`mlsidx_disclaimer`, `ParentBrokerage`.`name`, `ParentBrokerage`.`broker_of_record_name`, `ParentBrokerage`.`short_name`, `ParentBrokerage`.`username`, `ParentBrokerage`.`password`, `ParentBrokerage`.`password_reset_hash`, `ParentBrokerage`.`monthly_invoice_amount`, `ParentBrokerage`.`monthly_invoice_start_date`, `ParentBrokerage`.`monthly_invoice_end_date`, `ParentBrokerage`.`contract_filename`, `ParentBrokerage`.`active`, `ParentBrokerage`.`lead_in`, `ParentBrokerage`.`short_description`, `ParentBrokerage`.`description`, `ParentBrokerage`.`communities`, `ParentBrokerage`.`website`, `ParentBrokerage`.`address`, `ParentBrokerage`.`address_2`, `ParentBrokerage`.`city`, `ParentBrokerage`.`state`, `ParentBrokerage`.`full_state`, `ParentBrokerage`.`country`, `ParentBrokerage`.`market`, `ParentBrokerage`.`market_2`, `ParentBrokerage`.`postal_code`, `ParentBrokerage`.`phone`, `ParentBrokerage`.`phone_2`, `ParentBrokerage`.`phone_3`, `ParentBrokerage`.`wide_contact_image`, `ParentBrokerage`.`contact_name`, `ParentBrokerage`.`contact_profile_link`, `ParentBrokerage`.`contact_big_profile_link`, `ParentBrokerage`.`contact_big_profile_link_text`, `ParentBrokerage`.`contact_title`, `ParentBrokerage`.`contact_dre_num`, `ParentBrokerage`.`contact_quote`, `ParentBrokerage`.`contact_email`, `ParentBrokerage`.`contact_facebook`, `ParentBrokerage`.`contact_twitter`, `ParentBrokerage`.`contact_instagram`, `ParentBrokerage`.`contact_pinterest`, `ParentBrokerage`.`contact_linkedin`, `ParentBrokerage`.`contact_youtube`, `ParentBrokerage`.`contact_phone`, `ParentBrokerage`.`contact_email_2`, `ParentBrokerage`.`contact_2_facebook`, `ParentBrokerage`.`contact_2_twitter`, `ParentBrokerage`.`contact_2_instagram`, `ParentBrokerage`.`contact_2_pinterest`, `ParentBrokerage`.`contact_2_linkedin`, `ParentBrokerage`.`contact_2_youtube`, `ParentBrokerage`.`contact_phone_2`, `ParentBrokerage`.`contact_website`, `ParentBrokerage`.`contact_name_2`, `ParentBrokerage`.`contact_profile_link_2`, `ParentBrokerage`.`contact_big_profile_link_2`, `ParentBrokerage`.`contact_big_profile_link_text_2`, `ParentBrokerage`.`contact_title_2`, `ParentBrokerage`.`contact_dre_num_2`, `ParentBrokerage`.`contact_email_3`, `ParentBrokerage`.`contact_name_3`, `ParentBrokerage`.`contact_title_3`, `ParentBrokerage`.`contact_dre_num_3`, `ParentBrokerage`.`contact_phone_3`, `ParentBrokerage`.`contact_3_facebook`, `ParentBrokerage`.`contact_3_twitter`, `ParentBrokerage`.`contact_3_instagram`, `ParentBrokerage`.`contact_3_pinterest`, `ParentBrokerage`.`contact_3_linkedin`, `ParentBrokerage`.`contact_3_youtube`, `ParentBrokerage`.`image_filename`, `ParentBrokerage`.`logo_filename`, `ParentBrokerage`.`contact_image_filename`, `ParentBrokerage`.`all_properties_link_image_filename`, `ParentBrokerage`.`all_properties_link`, `ParentBrokerage`.`video_embed_code`, `ParentBrokerage`.`contact_video_embed_code`, `ParentBrokerage`.`meta_title`, `ParentBrokerage`.`meta_description`, `ParentBrokerage`.`meta_keywords`, `ParentBrokerage`.`login_message_counter`, `ParentBrokerage`.`stats_module_1_type`, `ParentBrokerage`.`stats_module_1_value`, `ParentBrokerage`.`stats_module_2_type`, `ParentBrokerage`.`stats_module_2_value`, `ParentBrokerage`.`stats_module_3_type`, `ParentBrokerage`.`stats_module_3_value`, `ParentBrokerage`.`last_activity_email_sent`, `ParentBrokerage`.`converted`, `ParentBrokerage`.`created`, `ParentBrokerage`.`modified`, `ParentBrokerage`.`dre_num`, `ParentLocation`.`id`, `ParentLocation`.`parent_id`, `ParentLocation`.`brokerage_id`, `ParentLocation`.`type`, `ParentLocation`.`archived`, `ParentLocation`.`use_as_topic`, `ParentLocation`.`name`, `ParentLocation`.`short_name`, `ParentLocation`.`group_index`, `ParentLocation`.`latitude`, `ParentLocation`.`longitude`, `ParentLocation`.`country_code`, `ParentLocation`.`north`, `ParentLocation`.`south`, `ParentLocation`.`east`, `ParentLocation`.`west`, `ParentLocation`.`zoom`, `ParentLocation`.`short_description`, `ParentLocation`.`long_description`, `ParentLocation`.`created`, `ParentLocation`.`modified`, `ParentLocation`.`timezone`, `ParentLocation`.`population` FROM `leveragere_staging2`.`articles` AS `Article` LEFT JOIN `leveragere_staging2`.`brokerages` AS `ParentBrokerage` ON (`Article`.`model_id` = `ParentBrokerage`.`id` AND `Article`.`model` = 'Brokerage') LEFT JOIN `leveragere_staging2`.`locations` AS `ParentLocation` ON (`Article`.`model_id` = `ParentLocation`.`id` AND `Article`.`model` = 'Location') WHERE `Article`.`id` = 424 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` = (424) 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` = 424 AND `ArticlesBrokerage`.`brokerage_id` = `Brokerage`.`id`)	0	0	0
  SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `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` = 424 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` = 424 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` = 424 AND `ArticlesTopic`.`topic_id` = `Topic`.`id`)	0	0	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 (3712, 3722, 3736, 3752) ORDER BY `Image`.`order` ASC	59	59	1
  SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (3712, 3722, 3736, 3752) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	3	3	0
  SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (3712, 3722, 3736, 3752) 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 (3712, 3722, 3736, 3752) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	7	7	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 (3712, 3722, 3736, 3752) 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 13.38 MB

  Message	Memory use
  Component initialization	2.91 MB
  Controller action start	3.84 MB
  Controller render start	6.69 MB
  View render complete	7.24 MB

  Timers

  Total Request Time: 313 (ms)

  Message	Time in ms	Graph
  Core Processing (Derived from $_SERVER["REQUEST_TIME"])	31.34
  Event: Controller.initialize	3.86
  Event: Controller.startup	2.32
  Controller action	103.62
  Event: Controller.beforeRender	23.16
  » Processing toolbar data	23.04
  Rendering View	97.24
  » Event: View.beforeRender	0.29
  » Rendering APP/View/Articles/view.ctp	3.58
  » » Rendering APP/View/Elements/sidebar/explore.ctp	0.99
  » » » Rendering APP/View/Elements/explore_tile_small.ctp	0.17
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #2	0.14
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #3	0.13
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #4	0.13
  » » Rendering APP/View/Elements/sidebar/property_search.ctp	0.21
  » » Rendering APP/View/Elements/sidebar/property_list.ctp	1.33
  » » » Rendering APP/View/Elements/static_property_price.ctp	0.38
  » » » Rendering APP/View/Elements/static_property_price.ctp #2	0.17
  » » » Rendering APP/View/Elements/static_property_price.ctp #3	0.15
  » » » 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	92.56
  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)
        • id3712
        • brokerage_id76
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id777
        • agent_2_id0
        • agent_3_id0
        • nameExtraordinary Family Home
        • incomplete(false)
        • archived(false)
        • last_archived0000-00-00 00:00:00
        • auto_archived_from_mlsidx(false)
        • paid_featured(false)
        • featured(true)
        • homepage_featured(false)
        • brokerage_page_featured(true)
        • requested_homepage_featured_by_member(false)
        • homepage_featured_by_member(false)
        • dot_luxury_featured(false)
        • luxury_feed_featured(false)
        • force_luxury_feed_featured(false)
        • luxury_autofeed_imported(false)
        • luxury_feed_last_added_time0000-00-00 00:00:00
        • luxury_feed_agent_user_id0
        • luxury_feed_locked_to_subscription_id0
        • luxury_feed_agent_purchase_date0000-00-00
        • luxury_feed_agent_expiration_date0000-00-00
        • digital_ad_summary_email_last_sent0000-00-00 00:00:00
        • digital_ad_summary_price_changed(false)
        • wsj_detail_url
        • ft_detail_url
        • nyt_detail_url
        • juwai_detail_url
        • pgl_detail_url
        • mg_detail_url
        • mg_c_detail_url
        • mg_s_detail_url
        • bp_detail_url
        • mw_detail_url
        • nikkei_detail_url
        • wapo_detail_url
        • robb_detail_url
        • medium_featured(false)
        • large_featured(false)
        • detail_page(true)
        • description<p>Extraordinary family home w/ stunning lake view! Perfect for full-time use or vacation get-away. Entertainer's dream home! 3 large decks (Trex decking) great for BBQing while looking at gorgeous Lake Arrowhead. Game room, open floor plan, beamed ceilings. 2 sliding glass doors off of family rm. open up to a beautiful view of the lake. Stunning stone fireplace w/ solid wood mantle. This is a MUST SEE home!</p>
        • address27424 Alpen
        • address_2
        • cityLake Arrowhead
        • stateCA
        • postal_code92352
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price545000
        • price_20
        • price_usd545000
        • price_usd_20
        • statusFor Sale
        • status_last_changed0000-00-00 00:00:00
        • status_last_changed_price_only0000-00-00 00:00:00
        • lease_period
        • price_upon_request(false)
        • bedrooms4
        • bedrooms_20
        • bathrooms2
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet0
        • square_meters
        • acres0
        • interior_unitsq_ft
        • interior_size0
        • lot_unitacres
        • lot_size0
        • icon_1garage
        • icon_2office
        • icon_3views
        • icon_4
        • icon_5
        • icon_6
        • websitehttp://www.therealestateplace.com/property/2326-2/
        • meta_titleExtraordinary Family Home | Lake Arrowhead Real Estate | Prime Properties
        • meta_description27424 Alpen is a property offered for sale in Lake Arrowhead, CA, USA, presented by Prime Properties
        • meta_keywords
        • bathrooms_partial1
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built
        • virtual_tour
        • video_tourhttp://www.tourfactory.com/1505216
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num
        • wsj_property_type
        • nyt_property_type
        • nyt_popular_features
        • propgolux_property_type
        • juwai_property_type
        • juwai_category
        • propgolux_property_style
        • wapo_property_type
        • robb_property_type
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude0.000000
        • longitude0.000000
        • invalid_required_fieldslatitude, longitude
        • invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, year_built, virtual_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
        • went_live_today(true)
        • converted(true)
        • invalid(false)
        • mlsidx_full_address
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2016-04-18 05:33:02
        • created2016-04-07 10:56:58
        • uri/property-detail/3712/27424-alpen-lake-arrowhead-ca-92352-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3712/27424-alpen-lake-arrowhead-ca-92352-usa
        • address_concat27424 Alpen Lake Arrowhead CA 92352 USA
        • google_maps_query_string27424+Alpen++Lake+Arrowhead+CA+92352+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 545,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty4
        • bathrooms_pretty2
        • bathrooms_partial_pretty1
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms2
        • date_listed2016-04-07
        • overridden_brokerage_namePrime Properties
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id76
        • account_executive_id236
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties8
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties0
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id1
        • WOEID2434729
        • 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
        • namePrime Properties
        • broker_of_record_name
        • short_namePrime Properties
        • usernamePrimeProperties
        • password4b7dee5c791770c42ce3df75d5b8fb072b481b38
        • 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>Prime Properties is the exclusive representative for Leverage Global Partners in Lake Arrowhead, California, USA.</p> <p>“Different isn’t always better, but better is always different,” has been founder, and president, Jeff Perlis’ motto for providing outstanding service to his clients for almost 25 years. Jeff created Prime Properties as a boutique real estate company that provides Nordstrom-quality customer service to its clients.</p> <p>The Prime Properties Team purposes to continually show community support. Such support can be exemplified by their sweeping transformation of its current office location. The office’s strategic location, houses the Arrowhead Welcome Center, Jeff’s vision for providing a warm and inviting first-stop for Lake Arrowhead visitors and clients. The Prime Properties Team includes, Arrowhead Rental Agency, the full-time rental department.</p> <p>Lake Arrowhead is a four season resort community centered around the uniqueness of a private lake. Located in an altitude of 5,100 feet, Lake Arrowhead has been described as the “Jewel of Southern California,” known as “Little Switzerland.” Close to local ski resorts and National Forest trails, Lake Arrowhead is less than a two-hour drive from Los Angeles, San Diego, or Palm Springs.</p>
        • communitieslake arrowhead
        • websitehttp://www.therealestateplace.com/
        • address26816 Highway 189
        • address_2
        • cityLake Arrowhead
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • marketLake Arrowhead
        • market_2
        • postal_code92352
        • phone(909) 337-7653
        • phone_2(909) 224-5631
        • phone_3
        • wide_contact_image(false)
        • contact_nameJeff Perlis
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titleOwner/Broker
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_websitehttp://www.JeffPerlis.com
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename76.jpg
        • logo_filename76.jpg
        • contact_image_filename76.jpg
        • all_properties_link_image_filename76.jpg
        • all_properties_linkhttp://www.therealestateplace.com/properties
        • video_embed_code
        • contact_video_embed_code
        • meta_titleLake Arrowhead Real Estate | Prime Properties | Leverage Global Partners
        • meta_descriptionPrime Properties is the exclusive representative for Leverage Global Partners in Lake Arrowhead, California, USA.
        • meta_keywordsLake Arrowhead Real Estate, Prime Properties, Leverage Global Partners, Jeff Perlis
        • login_message_counter2
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-12-09 16:21:37
        • modified2016-04-08 16:34:01
        • dre_num012345
        • uri/brokerage-detail/76/prime-properties
        • website_shortwww.therealestateplace.com
        • name_with_locationPrime 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)
          • id11165
          • modelProperty
          • model_id3712
          • tagImage
          • name36037.jpg
          • typeimage/jpg
          • size3559005
          • uri/assets/11165.jpg
          • order2895
          • created2016-04-07 16:25:28
          • modified2016-04-07 16:25:28
        • 1(array)
          • id11166
          • modelProperty
          • model_id3712
          • tagImage
          • name36038.jpg
          • typeimage/jpg
          • size2525853
          • uri/assets/11166.jpg
          • order2896
          • created2016-04-07 16:25:34
          • modified2016-04-07 16:25:34
        • 2(array)
          • id11167
          • modelProperty
          • model_id3712
          • tagImage
          • name36039.jpg
          • typeimage/jpg
          • size2800068
          • uri/assets/11167.jpg
          • order2897
          • created2016-04-07 16:25:36
          • modified2016-04-07 16:25:36
        • 3(array)
          • id11168
          • modelProperty
          • model_id3712
          • tagImage
          • name36040.jpg
          • typeimage/jpg
          • size3027894
          • uri/assets/11168.jpg
          • order2898
          • created2016-04-07 16:25:38
          • modified2016-04-07 16:25:38
        • 4(array)
          • id11169
          • modelProperty
          • model_id3712
          • tagImage
          • name36041.jpg
          • typeimage/jpg
          • size2301281
          • uri/assets/11169.jpg
          • order2899
          • created2016-04-07 16:25:40
          • modified2016-04-07 16:25:40
        • 5(array)
          • id11170
          • modelProperty
          • model_id3712
          • tagImage
          • name36042.jpg
          • typeimage/jpg
          • size2420895
          • uri/assets/11170.jpg
          • order2900
          • created2016-04-07 16:25:42
          • modified2016-04-07 16:25:42
        • 6(array)
          • id11171
          • modelProperty
          • model_id3712
          • tagImage
          • name36043.jpg
          • typeimage/jpg
          • size2423264
          • uri/assets/11171.jpg
          • order2901
          • created2016-04-07 16:25:44
          • modified2016-04-07 16:25:44
        • 7(array)
          • id11172
          • modelProperty
          • model_id3712
          • tagImage
          • name36044.jpg
          • typeimage/jpg
          • size2540978
          • uri/assets/11172.jpg
          • order2902
          • created2016-04-07 16:25:45
          • modified2016-04-07 16:25:45
        • 8(array)
          • id11173
          • modelProperty
          • model_id3712
          • tagImage
          • name36045.jpg
          • typeimage/jpg
          • size1916356
          • uri/assets/11173.jpg
          • order2903
          • created2016-04-07 16:25:49
          • modified2016-04-07 16:25:49
        • 9(array)
          • id11174
          • modelProperty
          • model_id3712
          • tagImage
          • name36046.jpg
          • typeimage/jpg
          • size4040003
          • uri/assets/11174.jpg
          • order2904
          • created2016-04-07 16:25:51
          • modified2016-04-07 16:25:51
      • User(array)
        • 0(array)
          • id969
          • typeAgent
          • brokerage_id76
          • email[email protected]
          • password576f947779f7edcccdd25932c65b363f8265be2d
          • recover_hash
          • first_nameJeff
          • last_namePerlis
          • title
          • dre_num
          • phone909-337-7653
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2017-08-07 15:23:46
          • created2017-08-07 15:23:46
          • notified(false)
          • full_nameJeff Perlis
          • uri/agent-detail/969/jeff-perlis
          • profile_complete(true)
          • UsersProperty(array)
            • id726
            • user_id969
            • property_id3712
            • sort_order0
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(array)
        • 0(array)
          • id4
          • nameGarage
          • additional(false)
          • created2016-04-07 14:01:52
          • modified2016-04-07 14:01:52
          • PropertiesPropertyFeature(array)
            • id1987
            • property_id3712
            • property_feature_id4
        • 1(array)
          • id9
          • nameOffice
          • additional(false)
          • created2016-04-07 14:03:21
          • modified2016-04-07 14:03:21
          • PropertiesPropertyFeature(array)
            • id1988
            • property_id3712
            • property_feature_id9
        • 2(array)
          • id14
          • nameViews
          • additional(false)
          • created2016-04-07 14:04:55
          • modified2016-04-07 14:04:55
          • PropertiesPropertyFeature(array)
            • id1989
            • property_id3712
            • property_feature_id14
      • Topic(empty)
    • 1(array)
      • Property(array)
        • id3722
        • brokerage_id169
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameBeautiful Riders Retreat Next To Vineyards
        • 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>Nestled in the Santa Ynez Valley is this Craftsman style beauty. Rural Setting adjacent to a vineyard overlooks the beautiful mountain ranges providing breathtaking views. Situated on one acre, this custom-built home comes with a converted barn permitted as a second residence. Master bedroom is on the downstairs level in this 3 bedroom 3 bath home.<br /> <!-- Below block has been moved on the top of MArketing Remarks --><!-- <hr id="picHR" style="visibility: hidden"> <FONT id="pictureDesc" class="mBlackText"></FONT> --></p>
        • address780 Carriage Drive
        • address_2
        • citySolvang
        • stateCA
        • postal_code93463
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price1280000
        • price_20
        • price_usd1280000
        • 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
        • bathrooms3
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet2254
        • square_meters
        • acres1
        • interior_unitsq_ft
        • interior_size0
        • lot_unitacres
        • lot_size1
        • 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_built2007
        • virtual_tourhttp://tours.tourfactory.com/tours/tour.asp?t=1532559&idx=1
        • video_tour
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num1065537
        • wsj_property_type
        • nyt_property_type
        • nyt_popular_features
        • propgolux_property_type
        • juwai_property_type
        • juwai_category
        • propgolux_property_style
        • wapo_property_type
        • robb_property_type
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude34.603176
        • longitude34.603176
        • invalid_required_fields
        • invalid_optional_fields
        • went_live_today(false)
        • converted(true)
        • invalid(false)
        • mlsidx_full_address
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2016-04-18 00:33:02
        • created2016-04-12 14:38:17
        • uri/property-detail/3722/780-carriage-drive-solvang-ca-93463-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3722/780-carriage-drive-solvang-ca-93463-usa
        • address_concat780 Carriage Drive Solvang CA 93463 USA
        • google_maps_query_string780+Carriage+Drive++Solvang+CA+93463+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 1,280,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty3
        • bathrooms_pretty3
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms3
        • date_listed2016-04-12
        • overridden_brokerage_nameCentral Coast Realty Group
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id169
        • account_executive_id236
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties8
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties0
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id0
        • WOEID2469027
        • 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
        • nameCentral Coast Realty Group
        • broker_of_record_name
        • short_nameCentral Coast Realty Group
        • usernameCentralCoastRealtyGroup
        • passwordc3fb4d7011e0e75ebb30dab389ea3ffbc5c48040
        • password_reset_hash
        • monthly_invoice_amount0.00
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>Central Coast Realty Group (CCRG) is the exclusive representative for Leverage Global Partners here on the Central Coast of California which encompasses the areas of San Luis Obispo, Paso Robles, Cambria, Morro Bay, Cayucos, Baywood-Los Osos, Templeton, Atascadero, Santa Margarita, Avila Beach, Shell Beach, Pismo Beach, Arroyo Grande, Nipomo, Santa Maria, Orcutt and Lompoc valley.</p> <p>Central Coast Realty Group (CCRG) is a leading boutique real estate agency with multiple locations across California’s Central Coast.</p> <p>We are truly dedicated to our first priority: our customers. When you choose CCRG, you obtain a trusted group of experts with innovative visions and a commitment to our community. We provide the highest level of quality resources, support and services using our management team with over 30 years of experience.</p> <p>We prudently developed a diverse group of dedicated, enthusiastic professionals -- and only continue to grow. All of our agents have extensive knowledge and are proud to represent the areas on the California Central Coast.</p> <p>We believe our customer-focused approach to real estate enables strong relationships with valued clients and reinforces our reputation of integrity, reliability and most importantly, trust. CCRG ensures that every step of a transaction will have a personal touch.</p> <p>For further information about our company and services, feel free to contact Erny (805-994-2009) or Eric (805-782-6005).</p> <p>Central Coast Realty Group is licensed with the California Bureau of Real Estate – License #01854124.</p> <p>Learn more about CCRG by visiting our website: <a href="http://www.theccrg.com" target="_blank">www.theccrg.com</a></p>
        • communitiesSan Luis Obispo Paso Robles Cambria Morro Bay Cayucos Baywood-Los Osos Templeton Atascadero Santa Margarita Avila Beach Shell Beach Pismo Beach Arroyo Grande Nipomo Santa Maria Orcutt Lompoc Los Alamos Santa Ynez CCRG
        • websitehttp://www.theccrg.com/
        • addressRepresenting the Central Coast
        • address_2
        • citySan Luis Obispo
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • marketSan Luis Obispo
        • market_2
        • postal_code93401
        • phone805-994-2097
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameErny Pinckert, Eric Pinckert
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titleCo-Owners
        • contact_dre_num
        • contact_quoteWe invite you to contact us about real estate on the Central Coast.
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2[email protected]
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename169.jpg
        • logo_filename169.jpg
        • contact_image_filename169.JPG
        • all_properties_link_image_filename169.jpg
        • all_properties_linkhttp://www.theccrg.com/view-our-current-listings.aspx
        • video_embed_code
        • contact_video_embed_code
        • meta_titleSan Luis Obispo Real Estate⎜Central Coast Realty Group⎜Leverage Global Partners
        • meta_descriptionCentral Coast Realty Group is the exclusive representative for Leverage Global Partners in San Luis Obispo, CA, USA.
        • meta_keywordsCentral Coast Realty Group, San Luis Obispo Real Estate, Paso Robles Real Estate, Cambria Real Estate, Morro Bay Real Estate, Cayucos Real Estate, Baywood-Los Osos Real Estate, Templeton Real Estate, Atascadero Real Estate, Santa Margarita Real Estate, Avila Beach Real Estate, Shell Beach Real Estate, Pismo Beach Real Estate, Arroyo Grande Real Estate, Nipomo Real Estate, Santa Maria Real Estate, Orcutt Real Estate, Lompoc Real Estate
        • login_message_counter1
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2014-10-30 13:20:55
        • modified2016-04-08 16:34:15
        • dre_num012345
        • uri/brokerage-detail/169/central-coast-realty-group
        • website_shortwww.theccrg.com
        • name_with_locationCentral Coast Realty Group
      • 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)
          • id20704
          • modelProperty
          • model_id3722
          • tagImage
          • nameHD front.jpg
          • typeimage/jpeg
          • size3367728
          • uri/assets/20704.jpg
          • order0
          • created2016-04-12 14:33:43
          • modified2016-04-12 14:53:28
        • 1(array)
          • id20706
          • modelProperty
          • model_id3722
          • tagImage
          • nameHD ariel view.jpg
          • typeimage/jpeg
          • size3498585
          • uri/assets/20706.jpg
          • order1
          • created2016-04-12 14:34:54
          • modified2016-04-12 14:53:28
        • 2(array)
          • id20700
          • modelProperty
          • model_id3722
          • tagImage
          • namevineyard.jpg
          • typeimage/jpeg
          • size141799
          • uri/assets/20700.jpg
          • order2
          • created2016-04-12 14:33:28
          • modified2016-04-12 14:53:28
        • 3(array)
          • id20707
          • modelProperty
          • model_id3722
          • tagImage
          • nameHD living room w fireplace.jpg
          • typeimage/jpeg
          • size1984485
          • uri/assets/20707.jpg
          • order3
          • created2016-04-12 14:35:37
          • modified2016-04-12 14:53:28
        • 4(array)
          • id20703
          • modelProperty
          • model_id3722
          • tagImage
          • nameHD office.jpg
          • typeimage/jpeg
          • size2126202
          • uri/assets/20703.jpg
          • order4
          • created2016-04-12 14:33:40
          • modified2016-04-12 14:53:28
        • 5(array)
          • id20699
          • modelProperty
          • model_id3722
          • tagImage
          • namekitchen.jpg
          • typeimage/jpeg
          • size108649
          • uri/assets/20699.jpg
          • order5
          • created2016-04-12 14:33:28
          • modified2016-04-12 14:53:28
        • 6(array)
          • id20705
          • modelProperty
          • model_id3722
          • tagImage
          • nameHD guest house.jpg
          • typeimage/jpeg
          • size4021855
          • uri/assets/20705.jpg
          • order6
          • created2016-04-12 14:33:44
          • modified2016-04-12 14:53:28
        • 7(array)
          • id20698
          • modelProperty
          • model_id3722
          • tagImage
          • namevault ceiling.jpg
          • typeimage/jpeg
          • size99804
          • uri/assets/20698.jpg
          • order7
          • created2016-04-12 14:33:28
          • modified2016-04-12 14:53:28
        • 8(array)
          • id20708
          • modelProperty
          • model_id3722
          • tagImage
          • namedining with views.jpg
          • typeimage/jpeg
          • size120841
          • uri/assets/20708.jpg
          • order8
          • created2016-04-12 14:36:05
          • modified2016-04-12 14:53:28
        • 9(array)
          • id20709
          • modelProperty
          • model_id3722
          • tagImage
          • nameHD guest living.jpg
          • typeimage/jpeg
          • size1669910
          • uri/assets/20709.jpg
          • order9
          • created2016-04-12 14:36:17
          • modified2016-04-12 14:53:28
      • User(array)
        • 0(array)
          • id661
          • typeAgent
          • brokerage_id169
          • email[email protected]
          • password195ec6407fe1350e0b2aff7bb373c13214b0ff2d
          • recover_hash
          • first_nameDebbie
          • last_nameMcComb
          • title
          • dre_num
          • phone805-757-7700
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2017-08-07 15:23:13
          • created2017-08-07 15:23:13
          • notified(false)
          • full_nameDebbie McComb
          • uri/agent-detail/661/debbie-mccomb
          • profile_complete(true)
          • UsersProperty(array)
            • id458
            • user_id661
            • property_id3722
            • sort_order0
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(array)
        • 0(array)
          • id15
          • nameVineyard
          • additional(false)
          • created2016-04-07 14:05:15
          • modified2016-04-07 14:05:15
          • PropertiesPropertyFeature(array)
            • id4382
            • property_id3722
            • property_feature_id15
        • 1(array)
          • id14
          • nameViews
          • additional(false)
          • created2016-04-07 14:04:55
          • modified2016-04-07 14:04:55
          • PropertiesPropertyFeature(array)
            • id4381
            • property_id3722
            • property_feature_id14
        • 2(array)
          • id9
          • nameOffice
          • additional(false)
          • created2016-04-07 14:03:21
          • modified2016-04-07 14:03:21
          • PropertiesPropertyFeature(array)
            • id4380
            • property_id3722
            • property_feature_id9
        • 3(array)
          • id5
          • nameGuest House
          • additional(false)
          • created2016-04-07 14:02:13
          • modified2016-04-07 14:02:13
          • PropertiesPropertyFeature(array)
            • id4379
            • property_id3722
            • property_feature_id5
      • Topic(array)
        • 0(array)
          • id7
          • nameEquestrian
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:31:54
          • tile_nameEquestrian
          • PropertiesTopic(array)
            • id19
            • property_id3722
            • topic_id7
    • 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)
        • id3752
        • brokerage_id70
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameMy Imported Property
        • incomplete(false)
        • archived(false)
        • last_archived0000-00-00 00:00:00
        • auto_archived_from_mlsidx(false)
        • paid_featured(false)
        • featured(false)
        • homepage_featured(false)
        • brokerage_page_featured(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>Elegantly Situated On The Shores Of The Atlantic, This Breathtaking Home Spans 250 Feet Of Ocean Front In The Private, 2700 Acre, Gated Community Of Debordieu Colony. This 7 Bedroom, Luxurious Home, Opens To An Expansive Great Room Which Highlights The Home’S Seamless Design With A Superb See Through, Floor To Ceiling Fireplace And Dining Area Featuring A Beautiful Mirrored Wall And Endless Ocean Views. Tranquility Abounds In The Comfortable Living Spaces Tucked Throughout. Relax In The Architecturally Interesting Kitchen With The Ultimate In Space Planning Featuring A Comfortable Resting Area Complete With Fireplace. Hints Of Blue Décor, Provide A Pleasing Palette To The Neutral Understated Sand Color Of Cabinetry And Islands. A Chef’S Delight, This Kitchen Is Designed For Both Intimate Informal Or Extravagant Formal Entertaining. Also, Included On This Main Floor An En-Suite Guest Bedroom, Laundry Room A Lavish Wet Bar With Boundless Finesse, Powder Room & Media Room. An Abundance Of Natural Light Breathes Life Into The Master Suite With A Serene Sitting Area In A Domed Turret – Perfect For Sunrise Mornings Or Afternoon Quite Reading. Not To Be Outdone, The Second Floor, Accessed By A Spectacular Foyer With Soaring Ceilings And Dual Staircases, Overlooks And Captures The Essence Of The Home From The Balcony Taking In The Floor To Ceiling Windows Showcasing The Natural Beauty Of The Homes Setting. 4 Bedrooms On This Floor, Two En-Suite, Are Exquisitely Designed With Access To Ocean Terraces And Endless Views. Debordieu Is Truly A Resort Oasis With The Pete Dye Championship Designed Golf Course, 2 Swimming Pools, An Ocean Front Gazebo, Exceptional Tennis Courts, A New State Of The Art Fitness Center And 2 Restaurants. Experience A 2 Mile Beach Offering Peace And Tranquility, Enjoy Bike Paths, Walking Trails, And The Finest Fishing In The Area.</p>
        • address51 Cheraw Way
        • address_2
        • cityGeorgetown
        • stateSC
        • postal_code29440
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price3500000
        • 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)
        • bedrooms7
        • bedrooms_20
        • bathrooms5
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet6901
        • 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_partial1
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built
        • virtual_tour
        • video_tour
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num
        • wsj_property_type
        • nyt_property_type
        • nyt_popular_features
        • propgolux_property_type
        • juwai_property_type
        • juwai_category
        • propgolux_property_style
        • wapo_property_type
        • robb_property_type
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude33.358505
        • longitude-79.152374
        • invalid_required_fields
        • invalid_optional_fields
        • went_live_today(false)
        • converted(false)
        • invalid(false)
        • mlsidx_full_address51 Cheraw Way Georgetown SC
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2018-08-13 10:57:03
        • created2018-08-13 10:55:44
        • uri/property-detail/3752/51-cheraw-way-georgetown-sc-29440-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3752/51-cheraw-way-georgetown-sc-29440-usa
        • address_concat51 Cheraw Way Georgetown SC 29440 USA
        • google_maps_query_string51+Cheraw+Way++Georgetown+SC+29440+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 3,500,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty7
        • bathrooms_pretty5
        • bathrooms_partial_pretty1
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms5
        • date_listed2018-08-13
        • overridden_brokerage_nameQuinta Properties
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id70
        • account_executive_id236
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties8
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties3
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id13
        • WOEID23706483
        • timezoneEurope/Lisbon
        • 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_id9
        • mlsidx_lux_autofeed(false)
        • mlsidx_lux_autofeed_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • nameQuinta Properties
        • broker_of_record_name
        • short_nameQuinta Properties
        • usernameQuintaProperties
        • passwordbfa20d0f7d557565a3e9f0589db0a06e4c9546f3
        • 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>Quinta Properties is the exclusive representative for Leverage Global Partners in the Algarve, Portugal.</p> <p>Quinta Properties deal with some of the most exclusive luxury villas and exciting property in and around Quinta do Lago. As the chosen associates of Savills, they offer in-depth knowledge and experience to meet your real estate needs.</p> <p>Anyone who knows Quinta Properties and has dealt with Alison, Kerstin, and their team will know they are passionate about property.</p> <p>Their wide experience in the local property market enables them to recommend legal, architectural, financial and construction professionals who understand the needs of prospective buyers in the locality.</p> <p>Quinta Properties are registered with the Portuguese authorities as licensed agents, meeting stringent standards. Their staff are fluent in English, German, French, and Portuguese.</p> <p>"We make it our business to support you, to explain all the options, procedures and pitfalls and to carefully guide you through the entire process from purchasing to sellingluxury Quinta do Lago villas and other fine properties in the Quinta do Lago and the whole Algarve area." <em>--Alison Buechner Hojbjerg and Kerstin Buechner</em></p>
        • communitiesalgarve the algarve quinta do lago
        • websitehttp://www.quintaproperty.com/
        • addressAvenida da Gondra
        • address_2Quinta do Lago
        • cityAlmancil
        • state
        • full_state
        • countryPortugal
        • marketAlgarve
        • market_2
        • postal_code8135-162
        • phone+351 289 396 073
        • phone_2+351 289 398086 (Fax)
        • phone_3
        • wide_contact_image(false)
        • contact_nameAlison Buechner Hojbjerg and Kerstin Buechner
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titleDirectors
        • contact_dre_num
        • contact_quoteWe invite you to contact us about real estate in the Algarve
        • 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_filename70.jpg
        • logo_filename70.jpg
        • contact_image_filename70.jpg
        • all_properties_link_image_filename70.jpg
        • all_properties_linkhttp://www.quintaproperty.com/algarve/
        • video_embed_code
        • contact_video_embed_code
        • meta_titleAlgarve Real Estate | Quinta Properties | Leverage Global Partners
        • meta_descriptionQuinta Properties is the exclusive representative for Leverage Global Partners in the Algarve, Portugal.
        • meta_keywordsQuinta Properties, Algarve Real Estate, Leverage Global Partners, Alison Buechner Hojbjerg
        • 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-11-15 11:23:29
        • modified2020-11-20 12:05:11
        • dre_num012345
        • uri/brokerage-detail/70/quinta-properties
        • website_shortwww.quintaproperty.com
        • name_with_locationQuinta Properties
        • mlsidx_id_array(array)
          • 09
      • 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)
          • id22957
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-1.jpg
          • typeimage/jpeg
          • size119021
          • uri/assets/22957.jpg
          • order0
          • created2018-08-13 10:55:44
          • modified2018-08-13 10:57:03
        • 1(array)
          • id22958
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-2.jpg
          • typeimage/jpeg
          • size128372
          • uri/assets/22958.jpg
          • order1
          • created2018-08-13 10:55:44
          • modified2018-08-13 10:57:03
        • 2(array)
          • id22959
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-3.jpg
          • typeimage/jpeg
          • size147897
          • uri/assets/22959.jpg
          • order2
          • created2018-08-13 10:55:45
          • modified2018-08-13 10:57:03
        • 3(array)
          • id22960
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-4.jpg
          • typeimage/jpeg
          • size146754
          • uri/assets/22960.jpg
          • order3
          • created2018-08-13 10:55:45
          • modified2018-08-13 10:57:03
        • 4(array)
          • id22961
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-5.jpg
          • typeimage/jpeg
          • size147683
          • uri/assets/22961.jpg
          • order4
          • created2018-08-13 10:55:45
          • modified2018-08-13 10:57:03
        • 5(array)
          • id22962
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-6.jpg
          • typeimage/jpeg
          • size120398
          • uri/assets/22962.jpg
          • order5
          • created2018-08-13 10:55:45
          • modified2018-08-13 10:57:03
        • 6(array)
          • id22963
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-7.jpg
          • typeimage/jpeg
          • size154334
          • uri/assets/22963.jpg
          • order6
          • created2018-08-13 10:55:45
          • modified2018-08-13 10:57:03
        • 7(array)
          • id22964
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-8.jpg
          • typeimage/jpeg
          • size97359
          • uri/assets/22964.jpg
          • order7
          • created2018-08-13 10:55:45
          • modified2018-08-13 10:57:03
        • 8(array)
          • id22965
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-9.jpg
          • typeimage/jpeg
          • size115060
          • uri/assets/22965.jpg
          • order8
          • created2018-08-13 10:55:45
          • modified2018-08-13 10:57:03
        • 9(array)
          • id22966
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-10.jpg
          • typeimage/jpeg
          • size98295
          • uri/assets/22966.jpg
          • order9
          • created2018-08-13 10:55:45
          • modified2018-08-13 10:57:03
        • 10(array)
          • id22967
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-11.jpg
          • typeimage/jpeg
          • size113371
          • uri/assets/22967.jpg
          • order10
          • created2018-08-13 10:55:45
          • modified2018-08-13 10:57:03
        • 11(array)
          • id22968
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-12.jpg
          • typeimage/jpeg
          • size113634
          • uri/assets/22968.jpg
          • order11
          • created2018-08-13 10:55:45
          • modified2018-08-13 10:57:03
        • 12(array)
          • id22969
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-13.jpg
          • typeimage/jpeg
          • size150038
          • uri/assets/22969.jpg
          • order12
          • created2018-08-13 10:55:45
          • modified2018-08-13 10:57:03
        • 13(array)
          • id22970
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-14.jpg
          • typeimage/jpeg
          • size115497
          • uri/assets/22970.jpg
          • order13
          • created2018-08-13 10:55:45
          • modified2018-08-13 10:57:03
        • 14(array)
          • id22971
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-15.jpg
          • typeimage/jpeg
          • size114789
          • uri/assets/22971.jpg
          • order14
          • created2018-08-13 10:55:45
          • modified2018-08-13 10:57:03
        • 15(array)
          • id22972
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-16.jpg
          • typeimage/jpeg
          • size116117
          • uri/assets/22972.jpg
          • order15
          • created2018-08-13 10:55:45
          • modified2018-08-13 10:57:03
        • 16(array)
          • id22973
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-17.jpg
          • typeimage/jpeg
          • size124442
          • uri/assets/22973.jpg
          • order16
          • created2018-08-13 10:55:45
          • modified2018-08-13 10:57:03
        • 17(array)
          • id22974
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-18.jpg
          • typeimage/jpeg
          • size124761
          • uri/assets/22974.jpg
          • order17
          • created2018-08-13 10:55:45
          • modified2018-08-13 10:57:03
        • 18(array)
          • id22975
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-19.jpg
          • typeimage/jpeg
          • size58946
          • uri/assets/22975.jpg
          • order18
          • created2018-08-13 10:55:45
          • modified2018-08-13 10:57:03
        • 19(array)
          • id22976
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-20.jpg
          • typeimage/jpeg
          • size100601
          • uri/assets/22976.jpg
          • order19
          • created2018-08-13 10:55:45
          • modified2018-08-13 10:57:03
        • 20(array)
          • id22977
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-21.jpg
          • typeimage/jpeg
          • size99367
          • uri/assets/22977.jpg
          • order20
          • created2018-08-13 10:55:45
          • modified2018-08-13 10:57:03
        • 21(array)
          • id22978
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-22.jpg
          • typeimage/jpeg
          • size92005
          • uri/assets/22978.jpg
          • order21
          • created2018-08-13 10:55:45
          • modified2018-08-13 10:57:03
        • 22(array)
          • id22979
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-23.jpg
          • typeimage/jpeg
          • size124761
          • uri/assets/22979.jpg
          • order22
          • created2018-08-13 10:55:45
          • modified2018-08-13 10:57:03
        • 23(array)
          • id22980
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-24.jpg
          • typeimage/jpeg
          • size78933
          • uri/assets/22980.jpg
          • order23
          • created2018-08-13 10:55:46
          • modified2018-08-13 10:57:03
        • 24(array)
          • id22981
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-25.jpg
          • typeimage/jpeg
          • size86635
          • uri/assets/22981.jpg
          • order24
          • created2018-08-13 10:55:46
          • modified2018-08-13 10:57:03
        • 25(array)
          • id22982
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-26.jpg
          • typeimage/jpeg
          • size98622
          • uri/assets/22982.jpg
          • order25
          • created2018-08-13 10:55:46
          • modified2018-08-13 10:57:03
        • 26(array)
          • id22983
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-27.jpg
          • typeimage/jpeg
          • size106378
          • uri/assets/22983.jpg
          • order26
          • created2018-08-13 10:55:46
          • modified2018-08-13 10:57:03
        • 27(array)
          • id22984
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-28.jpg
          • typeimage/jpeg
          • size98908
          • uri/assets/22984.jpg
          • order27
          • created2018-08-13 10:55:46
          • modified2018-08-13 10:57:03
        • 28(array)
          • id22985
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-29.jpg
          • typeimage/jpeg
          • size80155
          • uri/assets/22985.jpg
          • order28
          • created2018-08-13 10:55:46
          • modified2018-08-13 10:57:03
        • 29(array)
          • id22986
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-30.jpg
          • typeimage/jpeg
          • size111729
          • uri/assets/22986.jpg
          • order29
          • created2018-08-13 10:55:46
          • modified2018-08-13 10:57:03
        • 30(array)
          • id22987
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-31.jpg
          • typeimage/jpeg
          • size93568
          • uri/assets/22987.jpg
          • order30
          • created2018-08-13 10:55:46
          • modified2018-08-13 10:57:03
        • 31(array)
          • id22988
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-32.jpg
          • typeimage/jpeg
          • size141620
          • uri/assets/22988.jpg
          • order31
          • created2018-08-13 10:55:46
          • modified2018-08-13 10:57:03
        • 32(array)
          • id22989
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-33.jpg
          • typeimage/jpeg
          • size95750
          • uri/assets/22989.jpg
          • order32
          • created2018-08-13 10:55:46
          • modified2018-08-13 10:57:03
        • 33(array)
          • id22990
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-34.jpg
          • typeimage/jpeg
          • size82211
          • uri/assets/22990.jpg
          • order33
          • created2018-08-13 10:55:46
          • modified2018-08-13 10:57:03
        • 34(array)
          • id22991
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-35.jpg
          • typeimage/jpeg
          • size70930
          • uri/assets/22991.jpg
          • order34
          • created2018-08-13 10:55:46
          • modified2018-08-13 10:57:03
        • 35(array)
          • id22992
          • modelProperty
          • model_id3752
          • tagImage
          • name1809067-36.jpg
          • typeimage/jpeg
          • size77628
          • uri/assets/22992.jpg
          • order35
          • created2018-08-13 10:55:46
          • modified2018-08-13 10:57:03
      • User(empty)
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(empty)
      • Topic(empty)
  • sidebar_articles(empty)
  • sidebar_tiles(array)
    • 0(array)
      • Topic(array)
        • id6
        • nameCountry Living
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:31:07
        • tile_nameCountry Living
      • Image(array)
        • id4
        • modelTopic
        • model_id6
        • tagImage
        • nameCountry Living.jpg
        • typeimage/jpeg
        • size597489
        • uri/assets/4.jpg
        • order0
        • created2016-02-25 11:31:04
        • modified2016-02-25 11:31:07
      • modelTopic
    • 1(array)
      • Location(array)
        • id116
        • parent_id9
        • brokerage_id69
        • typeExclusive
        • archived(false)
        • use_as_topic(true)
        • nameJackson Hole, WY, USA
        • short_nameJackson Hole, WY, USA
        • group_index
        • latitude43.468697
        • longitude-110.672417
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_descriptionOne of the world’s most unique places; Jackson Hole is a destination unparalleled in the mountain west.
        • long_descriptionOne of the world’s most unique places; Recognized for our stunning natural beauty, diverse ecosystems, and abundant wildlife, Jackson Hole is a destination unparalleled in the mountain west. Uniquely located in the heart of 2.7 million protected acres of beautiful unspoiled mountain ranges, wilderness areas, wildlife refuges, National Parks, and rivers; 97% of our land is protected, leaving the 3% of developable property highly desirable with views that will never change. The region’s lifestyle benefits are matched only by the financial benefits of Wyoming Residency. The surreal natural beauty of the area is the perfect place to experience outdoor adventure paired with distinct western culture.
        • created2016-04-05 17:28:58
        • modified2016-04-14 10:55:04
        • timezone
        • population9577
        • uri/locations/view/116/jackson-hole-wy-usa
        • tile_nameJackson Hole, WY, USA
      • Brokerage(array)
        • id69
        • 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
        • WOEID23511794
        • timezoneUS/Mountain
        • 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
        • nameJackson Hole Real Estate Associates
        • broker_of_record_name
        • short_nameJackson Hole Real Estate Associates
        • usernameJacksonHole
        • passwordb7b28ec0650589666dc21d2965e1e78fbbd3e998
        • 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>Jackson Hole Real Estate Associates is the exclusive representative for Leverage Global Partners in Jackson Hole, WY, Star Valley, WY, and Teton Valley, Idaho, USA.</p> <p>Welcome to Jackson Hole Real Estate Associates; the region’s largest and most dynamic real estate company. Our organization is comprised of experienced, successful and dedicated real estate professionals. Our collection of properties is unsurpassed and includes some of the most unique and sought-after real estate in the world.</p> <p>Jackson Hole Real Estate Associates is committed to being the leading luxury real estate brand in the Teton region. By staying on top of market trends and continually striving to offer cutting edge marketing and advertising services we deliver extraordinary experiences to clients and exceed their expectations.</p> <p>As a market leader in Jackson Hole, we believe the success of our company is based on the value that we provide for our clients, community and agents. It is this value-driven philosophy that has helped to guide the successful growth of our organization.</p>
        • communitiesJackson Hole Star Valley Teton Valley
        • websitehttp://jhrea.com/
        • address80 W. Broadway
        • address_2PO Box 4897
        • cityJackson
        • state WY
        • full_stateWyoming
        • countryUSA
        • marketJackson Hole
        • market_2
        • postal_code83001
        • phone(307) 733-6060
        • phone_2(888) 733-6060
        • phone_3
        • wide_contact_image(false)
        • contact_nameThe Team at Jackson Hole Real Estate Associates
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titleOwners and Real Estate Professionals
        • contact_dre_num
        • contact_quoteWe invite you to contact us about Jackson Hole 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_filename69.jpg
        • logo_filename69.png
        • contact_image_filename69.jpg
        • all_properties_link_image_filename69.jpg
        • all_properties_linkhttp://search.jhrea.com/idx/featured
        • video_embed_code<iframe width="560" height="315" src="https://www.youtube.com/embed/LgDWINq8GMo?controls=0&showinfo=0" frameborder="0" allowfullscreen></iframe>
        • contact_video_embed_code
        • meta_titleJackson Hole Real Estate | Jackson Hole Real Estate Associates | Leverage Global Partners
        • meta_descriptionJackson Hole Real Estate Associates is the exclusive representative for Leverage Global Partners in Jackson Hole, WY, Star Valley, WY, and Teton Valley, Idaho.
        • meta_keywordsJackson Hole Real Estate Associates, leverage global partners, jackson hole real estate, star valley real estate, teton valley real estate, jackson real estate, Julie Faupel, Matt Faupel
        • login_message_counter2
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-11-12 13:31:18
        • modified2016-04-08 16:33:30
        • dre_num012345
        • uri/brokerage-detail/69/jackson-hole-real-estate-associates
        • website_shortjhrea.com
        • name_with_locationJackson Hole Real Estate Associates
      • Image(array)
        • id3379
        • modelLocation
        • model_id116
        • tagImage
        • name69.jpg
        • typeimage/jpeg
        • size145276
        • uri/assets/3379.jpg
        • order0
        • created2016-04-05 17:28:52
        • modified2016-04-14 10:55:04
      • modelLocation
    • 2(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
    • 3(array)
      • Topic(array)
        • id11
        • nameGorgeous Gardens
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:32:19
        • tile_nameGorgeous Gardens
      • Image(array)
        • id10
        • modelTopic
        • model_id11
        • tagImage
        • nameGorgeous Gardens.jpg
        • typeimage/jpeg
        • size5963665
        • uri/assets/10.jpg
        • order0
        • created2016-02-25 11:32:16
        • modified2016-02-25 11:32:19
      • modelTopic
  • recent_articles(array)
    • 0(array)
      • Article(array)
        • id436
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(true)
        • large_featured(true)
        • titleHome Improvement: Take It Outside
        • authorLeverageRE
        • date2016-03-29
        • lead_inFrench for "under my tree," Sous Mon Arbre is an indoor/outdoor garden lamp ($665) equipped with a metal hook that can be used to hang the fixture on the branch of a tree. It can also be suspended from a wall or rest freely on a table or ground surface. Designed by Paris-based Florian Brillet and introduced last fall by Ligne Roset, the lamp features an ash wood handle and a shade of rustproof aluminum with a silk white lacquer finish.
        • body<h3><em><strong>This season's blue skies mean spending more time on green lawns. Spruce up outdoor spaces with these products designed to make the backyard a haven for summer relaxation.</strong></em></h3> <h3><strong><a href="http://www.ligne-roset-usa.com/Products/lighting/default.aspx" target="_blank">Ligne Roset Sous Mon Arbre Outdoor Lamp</a></strong></h3> <p><a href="http://www.ligne-roset-usa.com/Products/lighting/default.aspx" target="_blank"><img class="aligncenter wp-image-12942 pure-img" src="/assets/3046.png" /></a></p> <h3><strong><a href="http://www.frontgate.com/" target="_blank">Frontgate 40-Liter European Outdoor Solar Shower</a></strong></h3> <p>This solar-powered shower ($1,599) simply attaches to a garden hose and uses the sun's energy to heat the water-no plumbing required. The curved design, which holds a 40-liter tank, features a hot-cold mixer that allows the user to adjust the water to a desired temperature. The shower, available in five colors (shown in cherry), is made of a corrosion-resistant aluminum that can withstand marine environments.</p> <p><a href="http://www.frontgate.com/" target="_blank"><img class="aligncenter wp-image-12943 pure-img" src="/assets/3047.png" /></a></p> <h3><strong><a href="http://store.johntunger.com/products/big-bowl-o-zen-sculptural-firebowl" target="_blank">John T. Unger Studio Big Bowl O' Zen Sculptural Fire Bowl</a></strong></h3> <p>According to artist John T. Unger, every home needs a center of serenity. His <a href="http://store.johntunger.com/products/big-bowl-o-zen-37-inch-sculptural-firebowl" target="_blank">Big Bowl O' Zen</a> ($1,500) brings balance to any landscape and provides abundant warmth on a chilly evening. Hand-cut from heavy-duty, recycled cold-rolled steel, the 145-pound fire bowl is 37 inches in diameter and rests on a slim base. It is suitable for wood burning and ships ready-to-fit for clean-burning propane or natural gas.</p> <p><a href="http://store.johntunger.com/products/big-bowl-o-zen-sculptural-firebowl" target="_blank"><img class="aligncenter wp-image-12944 pure-img" src="/assets/3048.png" /></a></p>
        • vimeo_id
        • created2016-04-05 14:30:20
        • modified2016-04-11 17:05:22
        • uri/articles/view/436/home-improvement-take-it-outside
      • Image(array)
        • 0(array)
          • id3049
          • modelArticle
          • model_id436
          • tagImage
          • nameScreen-Shot-2016-04-02-at-2.02.59-PM.png
          • typeimage/png
          • size2530827
          • uri/assets/3049.png
          • order0
          • created2016-04-05 14:30:21
          • modified2016-04-11 17:05:22
    • 1(array)
      • Article(array)
        • id476
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(true)
        • large_featured(false)
        • titleHow to Plan and Plant Your Own Vegetable Garden
        • authorLeverageRE
        • date2016-03-29
        • lead_inDeciding to plant your own vegetable garden is a healthy plan and rewarding in many ways, but when confronted with the actual execution and all the planning and care taking required, it can seem a little daunting.
        • body<p>Never fear! It's actually as easy as 1-2-3-4 (and some numbers in between). <strong>Check out these easy tips on how to plant your own vegetable garden this year: </strong></p> <div> <p><img class="aligncenter wp-image-13010 pure-img" src="/assets/3289.png" /></p> <ol> <li><strong>Picking out your vegetables:</strong> <ul> <li>Decide what produce you want to grow and what makes sense for your household.</li> <li>Don't get too eager and over populate your garden with produce you will waste.</li> <li><a href="http://www.eatingwell.com/food_news_origins/seasonal_local/gardening/13_easy_to_grow_vegetables_and_herbs" target="_blank" title="Easy to grow vegetables">Check out these easy to grow vegetables</a> including green beans, beets and carrots.</li> <li>Do your research to find out <a href="http://www.motherearthnews.com/organic-gardening/best-vegetable-seed-companies-zm0z11zsto.aspx" target="_blank" title="seeds">which seeds you want to buy</a>.</li> </ul> </li> <li><strong>Choosing a place for your vegetable garden: </strong> <ul> <li>Try to pick a place close to the house for easy access.</li> <li>The average vegetable garden is 400 to 600 square feet.</li> <li>Full sunlight exposure is best for vegetable gardens. 6 hours minimum of sunlight is necessary for optimum growth.</li> <li>Access to plenty of water is key so consider setting up a sprinkler system.</li> </ul> </li> <li><strong>Prepping the area:</strong> <ul> <li>Consider how you want to plant: Raw Cropping means you plant in rows versus Intensive cropping with closer spacing between the produce.</li> <li>Check the quality and drainage of the soil or you can opt to raise the beds and fill with new loam soil (<a href="http://www.thisoldhouse.com/toh/how-to/intro/0,,20258509,00.html" target="_blank" title="raise vegetable garden beds">see how to raise the vegetable garden beds here</a>).</li> <li>Plant your seeds!</li> </ul> </li> <li><strong>Caring for your vegetables:</strong> <ul> <li>Your veggies are in a safe, light filled healthy soiled place.</li> <li>Ensure the crops receive about an inch of water a week.</li> <li>Weed your garden regularly.  <a href="http://www.dummies.com/how-to/content/when-to-add-compost-to-your-garden-beds.navId-403804.html" target="_blank" title="Compost">Consider using a mulch or compost</a> to help promote healthy growth.</li> </ul> </li> </ol> <p>Even if you don't have a green thumb, you can still plant your own vegetable garden this Spring and when you're eating a delicious salad with fresh, incredible produce that you grew yourself (with the help of the Internet, of course), you will be glad that you did it!</p> <h6><em>Article originally appeared on <a href="http://www.thepartnerstrust.com/blog/2014/02/how-to-plant-your-own-vegetable-garden/" target="_blank">Partners Trust Blog</a></em></h6> </div>
        • vimeo_id
        • created2016-04-05 14:34:55
        • modified2016-04-11 17:08:13
        • uri/articles/view/476/how-to-plan-and-plant-your-own-vegetable-garden
      • Image(array)
        • 0(array)
          • id3290
          • modelArticle
          • model_id476
          • tagImage
          • nameScreen-Shot-2016-03-29-at-3.33.17-PM.png
          • typeimage/png
          • size2171199
          • uri/assets/3290.png
          • order0
          • created2016-04-05 14:34:56
          • modified2016-04-11 17:08:13
  • article_model_overrideBrokerage
  • brokerage(array)
    • Brokerage(array)
      • id210
      • account_executive_id0
      • archived(false)
      • typebrokerage
      • hide_from_frontend(false)
      • agent_brokerage_data_override(false)
      • featured_development(false)
      • membership_typeBasic
      • max_properties8
      • max_homepage_featured_by_member_properties0
      • featured_properties_sort_methodmanual
      • lux_feed_modeStripeSubscription
      • max_luxury_feed_properties0
      • membership_luxury_feed_properties0
      • can_participate_in_lux_feed_while_archived(false)
      • full_training_video_access(false)
      • country_id0
      • WOEID8676
      • timezoneAmerica/Edmonton
      • 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
      • nameLiv Real Estate
      • broker_of_record_name
      • short_nameLiv Real Estate
      • usernameLivRealEstate
      • password043b3ff63be4366b17c1e79d5a02160f148729ec
      • 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>Liv Real Estate is the exclusive representative for Leverage Global Partners in Edmonton, Spruce Grove, St. Albert, Sherwood Park, Devon, Stony Plain, Leduc, Beaumont, and Fort Saskatchewan, Alberta, Canada.</p> <p>Selling your home is about you, and should feel as familiar and safe as your backyard. We believe in making our clients savvy, so they are part of the conversation when it comes to aligning big decisions with the best move.</p> <p>Liv offers a fresh perspective to real estate with a new outlook on dotted lines and traditional relationships between agents and homeowners. We take the artifice out of the transaction and the bus bench out of the relationship. We are homeowners too, and we stand behind a transparent process.</p> <p>When it’s time to give up the growth charts notched into your walls, or find familiar creaky floorboards in new surroundings, Liv is ready for you. We don’t want to be famous, we just want you to Love Where You Liv, and help you make sense of moving in, or moving on.</p> <p>This is how real estate really is.</p>
      • communitiesEdmonton Spruce Grove St. Albert Sherwood Park Devon Stony Plain Leduc Beaumont Fort Saskatchewan
      • websitehttp://www.livrealestate.ca/
      • address18831 111 Ave.
      • address_2
      • cityEdmonton
      • stateAB
      • full_stateAlberta
      • countryCanada
      • marketEdmonton
      • market_2
      • postal_codeT5S 2X4
      • phoneDirect: (780) 486-8655
      • phone_2Cell: (780) 441-5576
      • phone_3
      • wide_contact_image(false)
      • contact_nameSheldon Johnston
      • 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_filename210.jpg
      • logo_filename210.jpg
      • contact_image_filename210.jpg
      • all_properties_link_image_filename210.jpg
      • all_properties_linkhttp://www.livrealestate.ca/our-listings/
      • video_embed_code
      • contact_video_embed_code
      • meta_titleEdmonton Real Estate⎜LIV Real Estate⎜Leverage Global Partners
      • meta_descriptionLIV Real Estate is the exclusive representative for Leverage Global Partners in Edmonton, AB, Canada.
      • meta_keywordsLIV Real Estate, Edmonton Real Estate, Spruce Grove Real Estate, St. Albert Real Estate, Sherwood Park Real Estate, Devon Real Estate, Stony Plain Real Estate, Leduc Real Estate, Beaumont Real Estate, Fort Saskatchewan Real Estate, Alberta Real Estate, Sheldon Johnston, 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)
      • created2015-06-25 09:59:11
      • modified2016-04-14 10:57:52
      • dre_num012345
      • uri/brokerage-detail/210/liv-real-estate
      • website_shortwww.livrealestate.ca
      • name_with_locationLiv Real Estate - Edmonton, AB, Canada
    • AccountExecutive(array)
      • id(null)
      • type(null)
      • brokerage_id(null)
      • email(null)
      • password(null)
      • recover_hash(null)
      • first_name(null)
      • last_name(null)
      • title(null)
      • dre_num(null)
      • phone(null)
      • max_luxury_feed_properties(null)
      • headshot_filename(null)
      • bio(null)
      • brokerage_name_override(null)
      • stripe_customer_id(null)
      • digital_ad_first_free_month_coupon(null)
      • modified(null)
      • created(null)
      • notified(null)
      • full_name(null)
      • profile_complete(false)
    • Logo(array)
      • id2851
      • modelBrokerage
      • model_id210
      • tagLogo
      • name210.jpg
      • typeimage/jpg
      • size211602
      • uri/assets/2851.jpg
      • order0
      • created2016-03-30 11:44:44
      • modified2016-04-14 10:57:52
    • MainImage(array)
      • id2850
      • modelBrokerage
      • model_id210
      • tagMainImage
      • name210.jpg
      • typeimage/jpg
      • size3570580
      • uri/assets/2850.jpg
      • order0
      • created2016-03-30 11:44:43
      • modified2016-04-14 10:57:52
    • ContactImage(array)
      • id2852
      • modelBrokerage
      • model_id210
      • tagContactImage
      • name210.jpg
      • typeimage/jpg
      • size83326
      • uri/assets/2852.jpg
      • order0
      • created2016-03-30 11:44:44
      • modified2016-04-14 10:57:52
    • ContactImage2(array)
      • id(null)
      • model(null)
      • model_id(null)
      • tag(null)
      • name(null)
      • type(null)
      • size(null)
      • uri(null)
      • order(null)
      • created(null)
      • modified(null)
    • ContactImage3(array)
      • id(null)
      • model(null)
      • model_id(null)
      • tag(null)
      • name(null)
      • type(null)
      • size(null)
      • uri(null)
      • order(null)
      • created(null)
      • modified(null)
    • BrokerOfRecordLogo(array)
      • id(null)
      • model(null)
      • model_id(null)
      • tag(null)
      • name(null)
      • type(null)
      • size(null)
      • uri(null)
      • order(null)
      • created(null)
      • modified(null)
    • MainArticle(array)
      • id424
      • modelBrokerage
      • model_id210
      • archived(false)
      • medium_featured(true)
      • large_featured(true)
      • titleMeet LIV REAL ESTATE: Edmonton, AB, Canada
      • authorLeverageRE
      • date2015-11-13
      • lead_inGet to know Liv Real Estate, the exclusive representative for Leverage Global Partners in Edmonton, Spruce Grove, St. Albert, Sherwood Park, Devon, Stony Plain, Leduc, Beaumont, and Fort Saskatchewan, Alberta, Canada.
      • body <p><img class="aligncenter wp-image-11433 pure-img" src="/assets/2173.jpg" alt="Meet LIV REAL ESTATE: Edmonton, AB, Canada" width="819" height="466" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/LivRealEstate-300x171.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/LivRealEstate-585x333.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/LivRealEstate.jpg 3264w" sizes="(max-width: 819px) 100vw, 819px"></p> <p><span style="font-family: arial, helvetica, sans-serif;">We wanted to have a brand that represented our values. One that was focused on how we would want to be treated as a customer and as an agent. We wanted to bring together a fun, collaborative, professional group of agents that get results by working hard, and doing it right. We are very committed to providing excellent customer service and to prove it we don’t have any sales awards, we only recognize exceptional customer service, leadership and community involvement. </span></p> <p><span style="font-family: arial, helvetica, sans-serif;"><strong>Sheldon Johnston:</strong> Early in my career I was motivated by numbers; every year I chased awards and achieved my goals, becoming one of the top producing agents in Canada. When I realized that my past clients weren’t coming back to me, I also realized that I needed to shift my focus; just because my numbers said I was awesome, didn’t mean that I was. From that point on my focus has been on my clients, and we only select agents to work at Liv that put their clients first.</span></p> <p><img class="aligncenter wp-image-11431 pure-img" src="/assets/2174.jpg" alt="Meet LIV REAL ESTATE: Edmonton, AB, Canada" width="776" height="582" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/P9200085-300x225.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/P9200085-585x439.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/P9200085-80x60.jpg 80w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/P9200085.jpg 1200w" sizes="(max-width: 776px) 100vw, 776px"></p> <p><span style="font-family: arial, helvetica, sans-serif;"><strong>Sara MacLennan:</strong> </span><span style="font-family: arial, helvetica, sans-serif;">After five years at the Canadian head office for Coldwell Banker, showing agents and brokers how to use the power of the internet to grow their businesses, I decided to take my skills to the street and found my true calling running the brokerage with Sheldon. At Liv Real Estate, I focus on marketing (although I'm licensed to sell real estate) and business development for our brokerage. Today our small brokerage has some of the most visited real estate web sites in Edmonton, getting over 225,000 sessions and 3.5 million page views/month! It was the scariest and best decision I ever made.</span></p> <p><span style="font-family: arial, helvetica, sans-serif;">Online marketing is the core of our success. Our dominant position in search engine results has levelled the playing field between us and the big guys. Through inbound marketing we reach buyers and sellers when they are actually thinking about buying or selling a home. Being found is a huge asset to us in driving business to our agents and it allows us the pick of the best agents that fit our values.</span></p> <p><img class="aligncenter wp-image-11430 pure-img" src="/assets/2175.jpg" alt="Meet LIV REAL ESTATE: Edmonton, AB, Canada" width="786" height="590" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/FolkFest-300x225.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/FolkFest-585x439.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/FolkFest-80x60.jpg 80w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/FolkFest.jpg 1200w" sizes="(max-width: 786px) 100vw, 786px"></p> <p><span style="font-family: arial, helvetica, sans-serif;">Edmonton is an amazing city; there is so much going on here. Our incredible River Valley, which runs right through the city, is the largest urban park in North America (22 times bigger than Central Park in New York). We love hitting the trails in the River Valley on our mountain bikes – there’s over 1300 km of trails in Edmonton so you never run out of places to ride. Edmonton is big on festivals, we have about 300 every year including the largest and oldest “Fringe Festival” in North America, and an amazing Folk Festival held in the river valley with our city skyline as a backdrop. And then of course there is the “Ice District” a new downtown 25 acre sports and entertainment development centred around a new hockey arena (yes, hockey is a VERY big deal here). </span></p> <p><img class="aligncenter wp-image-11434 pure-img" src="/assets/2176.jpg" alt="Meet LIV REAL ESTATE: Edmonton, AB, Canada" width="849" height="444" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/EREB-Awards1-300x157.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/EREB-Awards1-585x306.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/EREB-Awards1.jpg 1200w" sizes="(max-width: 849px) 100vw, 849px"></p> <p><em>Leverage Global Partners is proud to have Sheldon Johnston, Sara MacLennan, and the team at Liv Real Estate as our partners in the network.</em></p>
      • vimeo_id
      • created2016-02-25 14:14:31
      • modified2016-04-05 14:41:07
      • uri/articles/view/424/meet-liv-real-estate-edmonton-ab-canada
    • FeaturedImage(empty)
    • Location(array)
      • 0(array)
        • id144
        • parent_id9
        • brokerage_id210
        • typeExclusive
        • archived(false)
        • use_as_topic(false)
        • nameEdmonton, AB, Canada
        • short_nameEdmonton, AB, Canada
        • group_index
        • latitude53.544388
        • longitude-113.490929
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_descriptionNorth America's most northern major city will surprise you!
        • long_descriptionEdmonton, the true gateway to the North, is the most northern City in North America, with over 1 million people. It's the passage from which countless abundant resources flow; natural gas, oil, coal, minerals and diamonds. National Geographic recognized it as a top summer destination to visit in 2015. Edmonton embraces Winter with Ice castles, festivals and freezeways. This northern jewel, is regarded as an amazing place to raise a family with exceptional schools, healthcare and Universities. Be dazzled by the northern lights, endless green space and immaculate campgrounds; including quick access to the rocky mountains. Edmonton will surprise you.
        • created2016-04-07 16:22:59
        • modified2016-04-14 10:59:09
        • timezoneAmerica/Edmonton
        • population875000
        • uri/locations/view/144/edmonton-ab-canada
        • tile_nameEdmonton, AB, Canada
    • User(array)
      • 0(array)
        • id193
        • typeBrokerageAdmin
        • brokerage_id210
        • email[email protected]
        • password043b3ff63be4366b17c1e79d5a02160f148729ec
        • recover_hash
        • first_nameSheldon
        • last_nameJohnston
        • title
        • dre_num
        • phone
        • max_luxury_feed_properties0
        • headshot_filename
        • bio
        • brokerage_name_override
        • stripe_customer_id
        • digital_ad_first_free_month_couponineligible
        • modified2016-04-12 08:31:32
        • created2016-04-08 16:34:26
        • notified(true)
        • full_nameSheldon Johnston
        • uri/agent-detail/193/sheldon-johnston
        • profile_complete(true)
      • 1(array)
        • id899
        • typeAgent
        • brokerage_id210
        • email[email protected]
        • password783175273132aba0b686d81c21eb4261e01af495
        • recover_hash
        • first_nameTameka
        • last_nameRoss
        • title
        • dre_num
        • phone780 707 2664
        • max_luxury_feed_properties0
        • headshot_filename
        • bio
        • brokerage_name_override
        • stripe_customer_id
        • digital_ad_first_free_month_couponineligible
        • modified2017-08-07 15:23:43
        • created2017-08-07 15:23:43
        • notified(false)
        • full_nameTameka Ross
        • uri/agent-detail/899/tameka-ross
        • profile_complete(true)
      • 2(array)
        • id902
        • typeAgent
        • brokerage_id210
        • email[email protected]
        • passworda8dc187bca92e1871628be9ce61d942321d14d9f
        • recover_hash
        • first_nameSheldon
        • last_nameJohnston
        • title
        • dre_num
        • phone780-441-5576
        • max_luxury_feed_properties0
        • headshot_filename
        • bio
        • brokerage_name_override
        • stripe_customer_id
        • digital_ad_first_free_month_couponineligible
        • modified2017-08-07 15:23:43
        • created2017-08-07 15:23:43
        • notified(false)
        • full_nameSheldon Johnston
        • uri/agent-detail/902/sheldon-johnston
        • profile_complete(true)
      • 3(array)
        • id903
        • typeAgent
        • brokerage_id210
        • email[email protected]
        • password8f84f2b4d8602726c5dd707379c3dd327913bf75
        • recover_hash
        • first_nameBill
        • last_nameHatton
        • title
        • dre_num
        • phone(780) 233-7283
        • max_luxury_feed_properties0
        • headshot_filename
        • bio
        • brokerage_name_override
        • stripe_customer_id
        • digital_ad_first_free_month_couponineligible
        • modified2017-08-07 15:23:43
        • created2017-08-07 15:23:43
        • notified(false)
        • full_nameBill Hatton
        • uri/agent-detail/903/bill-hatton
        • profile_complete(true)
      • 4(array)
        • id1158
        • typeAgent
        • brokerage_id210
        • email[email protected]
        • passworda5be4a7c08bbf93db75d093bbdef466fc8f53aa3
        • recover_hash
        • first_nameBill
        • last_nameBhamra
        • title
        • dre_num
        • phone780-707-2673
        • max_luxury_feed_properties0
        • headshot_filename
        • bio
        • brokerage_name_override
        • stripe_customer_id
        • digital_ad_first_free_month_couponineligible
        • modified2017-08-07 15:23:56
        • created2017-08-07 15:23:56
        • notified(false)
        • full_nameBill Bhamra
        • uri/agent-detail/1158/bill-bhamra
        • profile_complete(true)
      • 5(array)
        • id1159
        • typeAgent
        • brokerage_id210
        • email[email protected]
        • password9bb1d7cb931e162da414612ef11010c501cbc96f
        • recover_hash
        • first_nameMira
        • last_nameWannous
        • title
        • dre_num
        • phone(780) 264 6472
        • max_luxury_feed_properties0
        • headshot_filename
        • bio
        • brokerage_name_override
        • stripe_customer_id
        • digital_ad_first_free_month_couponineligible
        • modified2017-08-07 15:23:56
        • created2017-08-07 15:23:56
        • notified(false)
        • full_nameMira Wannous
        • uri/agent-detail/1159/mira-wannous
        • profile_complete(true)
      • 6(array)
        • id1160
        • typeAgent
        • brokerage_id210
        • email[email protected]
        • password2001dccaf3d94c91e44aabc9ec4ac661d58ec5cd
        • recover_hash
        • first_nameDeidre
        • last_nameHarrison
        • title
        • dre_num
        • phone780-850-0929
        • max_luxury_feed_properties0
        • headshot_filename
        • bio
        • brokerage_name_override
        • stripe_customer_id
        • digital_ad_first_free_month_couponineligible
        • modified2017-08-07 15:23:56
        • created2017-08-07 15:23:56
        • notified(false)
        • full_nameDeidre Harrison
        • uri/agent-detail/1160/deidre-harrison
        • profile_complete(true)
      • 7(array)
        • id1161
        • typeAgent
        • brokerage_id210
        • email[email protected]
        • passwordee2f17824b852e081c1a54f44909630518192f37
        • recover_hash
        • first_nameTravis
        • last_nameDochuk
        • title
        • dre_num
        • phone(780) 982 3995
        • max_luxury_feed_properties0
        • headshot_filename
        • bio
        • brokerage_name_override
        • stripe_customer_id
        • digital_ad_first_free_month_couponineligible
        • modified2017-08-07 15:23:56
        • created2017-08-07 15:23:56
        • notified(false)
        • full_nameTravis Dochuk
        • uri/agent-detail/1161/travis-dochuk
        • profile_complete(true)
      • 8(array)
        • id1255
        • typeAgent
        • brokerage_id210
        • email[email protected]
        • password67bab3ba1ec8fcca302dff6e515d10ffb1b19d99
        • recover_hash
        • first_nameDavid
        • last_nameLuong
        • title
        • dre_num
        • phone780-995-6526
        • max_luxury_feed_properties0
        • headshot_filename
        • bio
        • brokerage_name_override
        • stripe_customer_id
        • digital_ad_first_free_month_couponineligible
        • modified2017-08-07 15:24:00
        • created2017-08-07 15:24:00
        • notified(false)
        • full_nameDavid Luong
        • uri/agent-detail/1255/david-luong
        • profile_complete(true)
  • article(array)
    • Article(array)
      • id424
      • modelBrokerage
      • model_id210
      • archived(false)
      • medium_featured(true)
      • large_featured(true)
      • titleMeet LIV REAL ESTATE: Edmonton, AB, Canada
      • authorLeverageRE
      • date2015-11-13
      • lead_inGet to know Liv Real Estate, the exclusive representative for Leverage Global Partners in Edmonton, Spruce Grove, St. Albert, Sherwood Park, Devon, Stony Plain, Leduc, Beaumont, and Fort Saskatchewan, Alberta, Canada.
      • body <p><img class="aligncenter wp-image-11433 pure-img" src="/assets/2173.jpg" alt="Meet LIV REAL ESTATE: Edmonton, AB, Canada" width="819" height="466" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/LivRealEstate-300x171.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/LivRealEstate-585x333.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/LivRealEstate.jpg 3264w" sizes="(max-width: 819px) 100vw, 819px"></p> <p><span style="font-family: arial, helvetica, sans-serif;">We wanted to have a brand that represented our values. One that was focused on how we would want to be treated as a customer and as an agent. We wanted to bring together a fun, collaborative, professional group of agents that get results by working hard, and doing it right. We are very committed to providing excellent customer service and to prove it we don’t have any sales awards, we only recognize exceptional customer service, leadership and community involvement. </span></p> <p><span style="font-family: arial, helvetica, sans-serif;"><strong>Sheldon Johnston:</strong> Early in my career I was motivated by numbers; every year I chased awards and achieved my goals, becoming one of the top producing agents in Canada. When I realized that my past clients weren’t coming back to me, I also realized that I needed to shift my focus; just because my numbers said I was awesome, didn’t mean that I was. From that point on my focus has been on my clients, and we only select agents to work at Liv that put their clients first.</span></p> <p><img class="aligncenter wp-image-11431 pure-img" src="/assets/2174.jpg" alt="Meet LIV REAL ESTATE: Edmonton, AB, Canada" width="776" height="582" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/P9200085-300x225.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/P9200085-585x439.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/P9200085-80x60.jpg 80w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/P9200085.jpg 1200w" sizes="(max-width: 776px) 100vw, 776px"></p> <p><span style="font-family: arial, helvetica, sans-serif;"><strong>Sara MacLennan:</strong> </span><span style="font-family: arial, helvetica, sans-serif;">After five years at the Canadian head office for Coldwell Banker, showing agents and brokers how to use the power of the internet to grow their businesses, I decided to take my skills to the street and found my true calling running the brokerage with Sheldon. At Liv Real Estate, I focus on marketing (although I'm licensed to sell real estate) and business development for our brokerage. Today our small brokerage has some of the most visited real estate web sites in Edmonton, getting over 225,000 sessions and 3.5 million page views/month! It was the scariest and best decision I ever made.</span></p> <p><span style="font-family: arial, helvetica, sans-serif;">Online marketing is the core of our success. Our dominant position in search engine results has levelled the playing field between us and the big guys. Through inbound marketing we reach buyers and sellers when they are actually thinking about buying or selling a home. Being found is a huge asset to us in driving business to our agents and it allows us the pick of the best agents that fit our values.</span></p> <p><img class="aligncenter wp-image-11430 pure-img" src="/assets/2175.jpg" alt="Meet LIV REAL ESTATE: Edmonton, AB, Canada" width="786" height="590" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/FolkFest-300x225.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/FolkFest-585x439.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/FolkFest-80x60.jpg 80w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/FolkFest.jpg 1200w" sizes="(max-width: 786px) 100vw, 786px"></p> <p><span style="font-family: arial, helvetica, sans-serif;">Edmonton is an amazing city; there is so much going on here. Our incredible River Valley, which runs right through the city, is the largest urban park in North America (22 times bigger than Central Park in New York). We love hitting the trails in the River Valley on our mountain bikes – there’s over 1300 km of trails in Edmonton so you never run out of places to ride. Edmonton is big on festivals, we have about 300 every year including the largest and oldest “Fringe Festival” in North America, and an amazing Folk Festival held in the river valley with our city skyline as a backdrop. And then of course there is the “Ice District” a new downtown 25 acre sports and entertainment development centred around a new hockey arena (yes, hockey is a VERY big deal here). </span></p> <p><img class="aligncenter wp-image-11434 pure-img" src="/assets/2176.jpg" alt="Meet LIV REAL ESTATE: Edmonton, AB, Canada" width="849" height="444" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/EREB-Awards1-300x157.jpg 300w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/EREB-Awards1-585x306.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/EREB-Awards1.jpg 1200w" sizes="(max-width: 849px) 100vw, 849px"></p> <p><em>Leverage Global Partners is proud to have Sheldon Johnston, Sara MacLennan, and the team at Liv Real Estate as our partners in the network.</em></p>
      • vimeo_id
      • created2016-02-25 14:14:31
      • modified2016-04-05 14:41:07
      • uri/articles/view/424/meet-liv-real-estate-edmonton-ab-canada
      • flattened_topics(empty)
    • ParentBrokerage(array)
      • id210
      • account_executive_id0
      • archived(false)
      • typebrokerage
      • hide_from_frontend(false)
      • agent_brokerage_data_override(false)
      • featured_development(false)
      • membership_typeBasic
      • max_properties8
      • max_homepage_featured_by_member_properties0
      • featured_properties_sort_methodmanual
      • lux_feed_modeStripeSubscription
      • max_luxury_feed_properties0
      • membership_luxury_feed_properties0
      • can_participate_in_lux_feed_while_archived(false)
      • full_training_video_access(false)
      • country_id0
      • WOEID8676
      • timezoneAmerica/Edmonton
      • 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
      • nameLiv Real Estate
      • broker_of_record_name
      • short_nameLiv Real Estate
      • usernameLivRealEstate
      • password043b3ff63be4366b17c1e79d5a02160f148729ec
      • 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>Liv Real Estate is the exclusive representative for Leverage Global Partners in Edmonton, Spruce Grove, St. Albert, Sherwood Park, Devon, Stony Plain, Leduc, Beaumont, and Fort Saskatchewan, Alberta, Canada.</p> <p>Selling your home is about you, and should feel as familiar and safe as your backyard. We believe in making our clients savvy, so they are part of the conversation when it comes to aligning big decisions with the best move.</p> <p>Liv offers a fresh perspective to real estate with a new outlook on dotted lines and traditional relationships between agents and homeowners. We take the artifice out of the transaction and the bus bench out of the relationship. We are homeowners too, and we stand behind a transparent process.</p> <p>When it’s time to give up the growth charts notched into your walls, or find familiar creaky floorboards in new surroundings, Liv is ready for you. We don’t want to be famous, we just want you to Love Where You Liv, and help you make sense of moving in, or moving on.</p> <p>This is how real estate really is.</p>
      • communitiesEdmonton Spruce Grove St. Albert Sherwood Park Devon Stony Plain Leduc Beaumont Fort Saskatchewan
      • websitehttp://www.livrealestate.ca/
      • address18831 111 Ave.
      • address_2
      • cityEdmonton
      • stateAB
      • full_stateAlberta
      • countryCanada
      • marketEdmonton
      • market_2
      • postal_codeT5S 2X4
      • phoneDirect: (780) 486-8655
      • phone_2Cell: (780) 441-5576
      • phone_3
      • wide_contact_image(false)
      • contact_nameSheldon Johnston
      • 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_filename210.jpg
      • logo_filename210.jpg
      • contact_image_filename210.jpg
      • all_properties_link_image_filename210.jpg
      • all_properties_linkhttp://www.livrealestate.ca/our-listings/
      • video_embed_code
      • contact_video_embed_code
      • meta_titleEdmonton Real Estate⎜LIV Real Estate⎜Leverage Global Partners
      • meta_descriptionLIV Real Estate is the exclusive representative for Leverage Global Partners in Edmonton, AB, Canada.
      • meta_keywordsLIV Real Estate, Edmonton Real Estate, Spruce Grove Real Estate, St. Albert Real Estate, Sherwood Park Real Estate, Devon Real Estate, Stony Plain Real Estate, Leduc Real Estate, Beaumont Real Estate, Fort Saskatchewan Real Estate, Alberta Real Estate, Sheldon Johnston, 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)
      • created2015-06-25 09:59:11
      • modified2016-04-14 10:57:52
      • dre_num012345
      • uri/brokerage-detail/210/liv-real-estate
      • website_shortwww.livrealestate.ca
      • name_with_locationLiv Real Estate
    • 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)
        • id2177
        • modelArticle
        • model_id424
        • tagImage
        • namePPSS-28.jpg
        • typeimage/jpg
        • size267876
        • uri/assets/2177.jpg
        • order0
        • created2016-02-25 14:14:31
        • modified2016-02-25 14:14:31
    • Brokerage(empty)
    • Location(empty)
    • Property(empty)
    • Topic(empty)
  • membership_subscription_temp_allowed_login(null)
  • newsletter_member_types(array)
    • Leverage Member: AgentLeverage Member: Agent
    • Leverage Member: Broker or ManagementLeverage Member: Broker or Management
    • Non-MemberNon-Member
  • $request->data(empty)
  • $this->validationErrors(array)
    • Subscription(empty)
    • 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)
    • AccountExecutive(empty)
    • Logo(empty)
    • MainImage(empty)
    • ContactImage(empty)
    • ContactImage2(empty)
    • ContactImage3(empty)
    • BrokerOfRecordLogo(empty)
    • MainArticle(empty)
    • FeaturedImage(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/424/meet-liv-real-estate-edmonton-ab-canada
  Query String
  Request Method	GET
  Server Protocol	HTTP/1.1
  Gateway Interface	CGI/1.1
  Redirect Url	/articles/view/424/meet-liv-real-estate-edmonton-ab-canada
  Remote Port	19179
  Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
  Server Admin	root@localhost
  Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
  Context Prefix
  Request Scheme	https
  Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
  Remote Addr	162.159.115.42
  Server Port	443
  Server Addr	172.24.32.44
  Server Name	staging2.leveragere.com
  Server Software	Apache
  Server Signature
  Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
  Http Host	staging2.leveragere.com
  Http Connection	Keep-Alive
  Http X Forwarded Proto	https
  Http Cf Visitor	{"scheme":"https"}
  Http Cf Ipcountry	US
  Http Cf Connecting Ip	216.73.216.172
  Http Cdn Loop	cloudflare; loops=1
  Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
  Http Accept Encoding	gzip, br
  Http Accept	*/*
  Http Cf Ray	a09e76511a47b965-CMH
  Http X Forwarded For	216.73.216.172
  Proxy-nokeepalive	1
  Ssl Tls Sni	staging2.leveragere.com
  Https	on
  Passenger Download Native Support Binary	0
  Passenger Compile Native Support Binary	0
  Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
  Unique Id	aipRtsq_rDk8TmUDj2da7QAAAJc
  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	aipRtsq_rDk8TmUDj2da7QAAAJc
  Fcgi Role	RESPONDER
  Php Self	/index.php
  Request Time Float	1781158326.0334
  Request Time	1781158326

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

  ====