Location: Washington D.C.

LeverageRE

With nearly 30 percent of D.C.'s population employed by the federal government and an incredibly strong tourism industry, the District seems almost immune to economic downturn. Even during the height of the global recession in 2008–2009, D.C.'s top-notch hotels remained sold out, its exclusive restaurants and bars fi led to capacity, and the city's landmarks grew busier than ever.

The overall cityscape of today's Washington, D.C., is largely the result of French master urban planner Pierre Charles L'Enfant. The district is divided into four quadrants, stemming from a central point: the U.S.  Capitol Building. Within these dissimilar regions of NW, NE, SW, and SE lie varying combinations of grand Victorian homes, history-steeped single-family homes in varying gothic, Georgian, neoclassical, and contemporary architectural styles; cherry-blossom-lined streets separated by bustling squares and circles; and hodgepodges of low-rise buildings (mandated by law to be no taller than 20 feet plus the width of the bordering street).

Every year D.C. embraces its evolution as a one-of-a-kind metropolis, incorporating modernity while successfully keeping his- tory in style. Outside the very public and controversial world of donkeys and elephants, here are a few reasons to fall in love with America's capital:

P.O.V.

This rooftop bar at the W Washington D.C. offers a bird's-eye-view of the White House. Artisanal cocktails and tapas make it all the more compelling.

SMITHSONIAN MUSEUMS

The Smithsonian Institution operates 17 museums and galleries in the D.C. Metro area, all of which offer entrance free of charge.

BEN'S CHILI BOWL

This hole-in-the-wall is a D.C. legend. Regulars line up for the Original Chili Half-Smoke, a pork/beef sausage with mustard, onions, and spicy chili sauce.

NATIONAL ZOO

This 163-acre zoological park houses nearly 400 different species. The most popular: the Giant Pandas, who recently welcomed baby Bao Bao.

MANDARIN ORIENTAL, WASHINGTON D.C.

This ultra-luxurious 400-room and suite hotel marries D.C. decadence with Asian sophistication.

 

Share

• Topics:
• Voice from the Street
• Arts & Culture

• Location:
• Washington, D.C, USA

Recent Articles

Partners Trust Sells Vince Vaughn's La Canada Home

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

Location: Kiawah Island

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

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] => 439
            [model] => Location
            [model_id] => 105
            [archived] => 
            [medium_featured] => 1
            [large_featured] => 
            [title] => Location: Washington D.C.
            [author] => LeverageRE
            [date] => 2016-03-28
            [lead_in] => With nearly 30 percent of D.C.'s population employed by the federal government and an incredibly strong tourism industry, the District seems almost immune to economic downturn. Even during the height of the global recession in 2008–2009, D.C.'s top-notch hotels remained sold out, its exclusive restaurants and bars fi led to capacity, and the city's landmarks grew busier than ever.
            [body] => 
The overall cityscape of today's Washington, D.C., is largely the result of French master urban planner Pierre Charles L'Enfant. The district is divided into four quadrants, stemming from a central point: the U.S.  Capitol Building. Within these dissimilar regions of NW, NE, SW, and SE lie varying combinations of grand Victorian homes, history-steeped single-family homes in varying gothic, Georgian, neoclassical, and contemporary architectural styles; cherry-blossom-lined streets separated by bustling squares and circles; and hodgepodges of low-rise buildings (mandated by law to be no taller than 20 feet plus the width of the bordering street).



Every year D.C. embraces its evolution as a one-of-a-kind metropolis, incorporating modernity while successfully keeping his- tory in style. Outside the very public and controversial world of donkeys and elephants, here are a few reasons to fall in love with America's capital:

P.O.V.

This rooftop bar at the W Washington D.C. offers a bird's-eye-view of the White House. Artisanal cocktails and tapas make it all the more compelling.



SMITHSONIAN MUSEUMS

The Smithsonian Institution operates 17 museums and galleries in the D.C. Metro area, all of which offer entrance free of charge.



BEN'S CHILI BOWL

This hole-in-the-wall is a D.C. legend. Regulars line up for the Original Chili Half-Smoke, a pork/beef sausage with mustard, onions, and spicy chili sauce.



NATIONAL ZOO

This 163-acre zoological park houses nearly 400 different species. The most popular: the Giant Pandas, who recently welcomed baby Bao Bao.



MANDARIN ORIENTAL, WASHINGTON D.C.

This ultra-luxurious 400-room and suite hotel marries D.C. decadence with Asian sophistication.



 



            [vimeo_id] => 
            [created] => 2016-04-05 14:30:22
            [modified] => 2016-04-11 17:32:14
            [uri] => /articles/view/439/location-washington-d-c
            [flattened_topics] => Array
                (
                    [0] => Voice from the Street
                    [1] => Arts & Culture
                )

        )

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

    [ParentLocation] => Array
        (
            [id] => 105
            [parent_id] => 7
            [brokerage_id] => 80
            [type] => Exclusive
            [archived] => 
            [use_as_topic] => 
            [name] => Washington, D.C, USA
            [short_name] => Washington, D.C, USA
            [group_index] => 
            [latitude] => 38.907192
            [longitude] => -77.036873
            [country_code] => 
            [north] => 53.700001
            [south] => 19.700001
            [east] => -52.599998
            [west] => -146.600006
            [zoom] => 0
            [short_description] => 
            [long_description] => More information coming soon!
            [created] => 2016-04-05 13:36:56
            [modified] => 2016-04-14 10:44:02
            [timezone] => America/New_York
            [population] => 660000
            [uri] => /locations/view/105/washington-d-c-usa
            [tile_name] => Washington, D.C, USA
        )

    [Image] => Array
        (
            [0] => Array
                (
                    [id] => 3067
                    [model] => Article
                    [model_id] => 439
                    [tag] => Image
                    [name] => Screen-Shot-2016-03-28-at-7.44.50-PM.png
                    [type] => image/png
                    [size] => 2392702
                    [uri] => /assets/3067.png
                    [order] => 0
                    [created] => 2016-04-05 14:30:23
                    [modified] => 2016-04-11 17:32:14
                )

        )

    [Brokerage] => Array
        (
            [0] => Array
                (
                    [id] => 81
                    [account_executive_id] => 235
                    [archived] => 
                    [type] => brokerage
                    [hide_from_frontend] => 
                    [agent_brokerage_data_override] => 
                    [featured_development] => 
                    [membership_type] => Premium
                    [max_properties] => 8
                    [max_homepage_featured_by_member_properties] => 0
                    [featured_properties_sort_method] => manual
                    [lux_feed_mode] => StripeSubscription
                    [max_luxury_feed_properties] => 0
                    [membership_luxury_feed_properties] => 0
                    [can_participate_in_lux_feed_while_archived] => 
                    [full_training_video_access] => 
                    [country_id] => 1
                    [WOEID] => 2379523
                    [timezone] => US/Eastern
                    [luxury_feed_enrollment_mode] => manual
                    [luxury_feed_include_mlsidx_minimum_price] => 0
                    [luxury_feed_include_leverage_minimum_price] => 0
                    [digital_ad_contacts] => 
                    [add_agents_to_grr_auto_recipients] => 1
                    [mlsidx_id] => 
                    [mlsidx_lux_autofeed] => 
                    [mlsidx_lux_autofeed_minimum_price] => 0
                    [mlsidx_logo_url] => 
                    [mlsidx_disclaimer] => 
                    [name] => Evers & Co. Real Estate
                    [broker_of_record_name] => 
                    [short_name] => Evers & Co. Real Estate
                    [username] => EversCoRealEstateCC
                    [password] => 440e06f17502b0b97a9e4aa2f069e898691a3b4c
                    [password_reset_hash] => 
                    [monthly_invoice_amount] => 0.00
                    [monthly_invoice_start_date] => 0000-00-00
                    [monthly_invoice_end_date] => 0000-00-00
                    [contract_filename] => 
                    [active] => 1
                    [lead_in] => 
                    [short_description] => 
                    [description] => 
Evers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Chevy Chase, MD, and Washington, D.C, USA.,

We are 100+ salespeople who offer our clients a level of service that is unmatched in today’s real estate marketplace, and we deliver this extraordinary service with courtesy and integrity to everyone involved in each transaction.

We are enthusiastic about the neighborhoods where we live and work, from Chevy Chase to Capitol Hill, from Dupont Circle to Arlington, and everywhere in between. The highly visible storefront offices of Evers & Co. in Downtown Washington, Friendship Heights in Upper Northwest, downtown Bethesda-Chevy Chase and in Bluemont in the Virginia Wine Country are bustling with the entrepreneurial energy of agents who have in-depth knowledge of local history, architecture and construction techniques as well as expert skills in marketing and negotiating, all of which adds value to our service and your investment.

This spectrum of knowledge and our commitment to serving our clientele and fellow real estate associates with the highest level of integrity has made us the premier independent brokerage in the Metropolitan Washington area.

Donna Evers and the agents of Evers & Co. invite you to join our growing community of buyers and sellers, who have been the source of 90% of our business for the past thirty years.

                    [communities] => Bethesda
Chevy Chase Village
Town of Chevy Chase
Somerset
Edgemoor
Kenwood
Kenwood Park
Burning Tree
Avenel
Silver Spring
                    [website] => http://www.eversco.com/
                    [address] => 7032 Wisconsin Avenue
                    [address_2] => 
                    [city] => Chevy Chase
                    [state] => MD
                    [full_state] => Maryland
                    [country] => USA
                    [market] => Chevy Chase
                    [market_2] => 
                    [postal_code] => 20815
                    [phone] => Office: (301) 656-1800
                    [phone_2] => Cell: (202) 255-5009
                    [phone_3] => 
                    [wide_contact_image] => 
                    [contact_name] => Donna Evers
                    [contact_profile_link] => 
                    [contact_big_profile_link] => 
                    [contact_big_profile_link_text] => 
                    [contact_title] => President & Founder
                    [contact_dre_num] => 
                    [contact_quote] => 
                    [contact_email] => [email protected]
                    [contact_facebook] => 
                    [contact_twitter] => 
                    [contact_instagram] => 
                    [contact_pinterest] => 
                    [contact_linkedin] => 
                    [contact_youtube] => 
                    [contact_phone] => 
                    [contact_email_2] => 
                    [contact_2_facebook] => 
                    [contact_2_twitter] => 
                    [contact_2_instagram] => 
                    [contact_2_pinterest] => 
                    [contact_2_linkedin] => 
                    [contact_2_youtube] => 
                    [contact_phone_2] => 
                    [contact_website] => 
                    [contact_name_2] => 
                    [contact_profile_link_2] => 
                    [contact_big_profile_link_2] => 
                    [contact_big_profile_link_text_2] => 
                    [contact_title_2] => 
                    [contact_dre_num_2] => 
                    [contact_email_3] => 
                    [contact_name_3] => 
                    [contact_title_3] => 
                    [contact_dre_num_3] => 
                    [contact_phone_3] => 
                    [contact_3_facebook] => 
                    [contact_3_twitter] => 
                    [contact_3_instagram] => 
                    [contact_3_pinterest] => 
                    [contact_3_linkedin] => 
                    [contact_3_youtube] => 
                    [image_filename] => 81.jpg
                    [logo_filename] => 81.jpg
                    [contact_image_filename] => 81.jpg
                    [all_properties_link_image_filename] => 81.JPG
                    [all_properties_link] => http://eversco.idxre.com/featured/40484?CFID=10711248&CFTOKEN=99152164
                    [video_embed_code] => 
                    [contact_video_embed_code] => 
                    [meta_title] => Chevy Chase Real Estate | Evers & Co. Real Estate | Leverage Global Partners
                    [meta_description] => Evers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Bethesda, Chevy Chase Village, Town of Chevy Chase, Somerset, Edgemoor, Kenwood, Kenwood Park, Burning Tree, Avenel, and Silver Spring, MD.
                    [meta_keywords] => Chevy Chase Real Estate, Evers & Co. Real Estate, Leverage Global Partners,  Bethesda real estate, Chevy Chase Village real estate, Town of Chevy Chase real estate, Somerset real estate, Edgemoor real estate, Kenwood real estate, Kenwood Park real estate, Burning Tree real estate, Avenel real estate, and Silver Spring real estate, MD.
                    [login_message_counter] => 0
                    [stats_module_1_type] => 
                    [stats_module_1_value] => 
                    [stats_module_2_type] => 
                    [stats_module_2_value] => 
                    [stats_module_3_type] => 
                    [stats_module_3_value] => 
                    [last_activity_email_sent] => 0000-00-00 00:00:00
                    [converted] => 1
                    [created] => 2014-01-10 16:43:02
                    [modified] => 2016-04-08 16:34:01
                    [dre_num] => 012345
                    [uri] => /brokerage-detail/81/evers-co-real-estate
                    [website_short] => www.eversco.com
                    [name_with_location] => Evers & Co. Real Estate
                    [ArticlesBrokerage] => Array
                        (
                            [id] => 74
                            [article_id] => 439
                            [brokerage_id] => 81
                        )

                )

        )

    [Location] => Array
        (
            [0] => Array
                (
                    [id] => 105
                    [parent_id] => 7
                    [brokerage_id] => 80
                    [type] => Exclusive
                    [archived] => 
                    [use_as_topic] => 
                    [name] => Washington, D.C, USA
                    [short_name] => Washington, D.C, USA
                    [group_index] => 
                    [latitude] => 38.907192
                    [longitude] => -77.036873
                    [country_code] => 
                    [north] => 53.700001
                    [south] => 19.700001
                    [east] => -52.599998
                    [west] => -146.600006
                    [zoom] => 0
                    [short_description] => 
                    [long_description] => More information coming soon!
                    [created] => 2016-04-05 13:36:56
                    [modified] => 2016-04-14 10:44:02
                    [timezone] => America/New_York
                    [population] => 660000
                    [uri] => /locations/view/105/washington-d-c-usa
                    [tile_name] => Washington, D.C, USA
                    [ArticlesLocation] => Array
                        (
                            [id] => 50
                            [article_id] => 439
                            [location_id] => 105
                        )

                )

        )

    [Property] => Array
        (
        )

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

                )

            [1] => Array
                (
                    [id] => 1
                    [name] => Arts & Culture
                    [created] => 2016-02-25 11:25:00
                    [modified] => 2016-02-25 11:29:58
                    [tile_name] => Arts & Culture
                    [ArticlesTopic] => Array
                        (
                            [id] => 416
                            [article_id] => 439
                            [topic_id] => 1
                        )

                )

        )

)

• 
• History
  +

  Request History

  4 previous requests available

  • Restore to current request
  • agent-detail/1086/margo-flaherty
  • agent-detail/456/troy-hoidal
  • agent-detail/1273/donna-shaw
  • agent-detail/985/julie-bernauer

  ====
• Session
  +

  Session

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

  ====
• Request
  +

  Request

  Cake Params

  • plugin(null)
  • controllerarticles
  • actionview
  • named(empty)
  • pass(array)
    • 0439
    • 1location-washington-d-c
  • isAjax(false)

  Post data

  No post data.

  Query string

  No querystring data.

  Cookie

  • 0(empty)

  Current Route

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

  ====
• Sql Log
  +

  Sql Logs

  default

  Total Time: 15 ms
  Total Queries: 31 queries

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

  6 duplicate queries run.

  Query Explain:

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

  ====
• Timer
  +

  Memory

  Peak Memory Use 10.10 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.26 MB

  Timers

  Total Request Time: 242 (ms)

  Message	Time in ms	Graph
  Core Processing (Derived from $_SERVER["REQUEST_TIME"])	30.66
  Event: Controller.initialize	5.25
  Event: Controller.startup	1.16
  Controller action	69.33
  Event: Controller.beforeRender	5.47
  » Processing toolbar data	5.37
  Rendering View	106.20
  » Event: View.beforeRender	0.27
  » Rendering APP/View/Articles/view.ctp	3.76
  » » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.14
  » » Rendering APP/View/Elements/sidebar/explore.ctp	0.89
  » » » Rendering APP/View/Elements/explore_tile_small.ctp	0.13
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #2	0.13
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #3	0.13
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #4	0.12
  » » Rendering APP/View/Elements/sidebar/article_list.ctp	0.18
  » » Rendering APP/View/Elements/sidebar/property_search.ctp	0.20
  » » Rendering APP/View/Elements/sidebar/property_list.ctp	1.24
  » » » Rendering APP/View/Elements/static_property_price.ctp	0.37
  » » » Rendering APP/View/Elements/static_property_price.ctp #2	0.15
  » » » Rendering APP/View/Elements/static_property_price.ctp #3	0.15
  » » » Rendering APP/View/Elements/static_property_price.ctp #4	0.13
  » Event: View.afterRender	0.01
  » Event: View.beforeLayout	0.01
  » Rendering APP/View/Layouts/front.ctp	101.45
  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)
        • id3715
        • brokerage_id157
        • created_by_user_id0
        • order1
        • multi_unit(false)
        • agent_1_id283
        • agent_2_id284
        • agent_3_id0
        • nameHandsome English Tudor
        • 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>Handsome 5 Bedroom, 3 full and 2 half bath, English Tudor in Old Short Hills. An easy walk to downtown Millburn and close to the Midtown Direct train. Located in a picturesque neighborhood in the Hartshorn School District with exquisite landscaping and a private back yard. Impressive curb appeal with a beautiful multi-colored slate roof, all copper gutters and leaders, decorative stained and leaded glass windows and unique architectural details throughout.</p> <p>A 2-story stained glass bay window greets you in the entry foyer and grand staircase. A fireplace, bay window seat and leaded glass bar add special appeal to the grand living room that opens to a sun room or office which leads to a stone patio, surrounded by flowering gardens. The dining room seats 12 comfortably with 2 corner leaded glass cabinets offering ample storage for dishes and stemware. Just off the modern kitchen are a sunny breakfast room, the laundry closet and a cozy nanny's bedroom and bath en-suite. Right outside there is a small open porch, with wood storage below, that leads to an upper patio, driveway that is perfect for trikes and basketball, and a grassy yard for relaxing and entertaining. </p> <p>Upstairs are 4 bedrooms, 2 bathrooms, a lovely landing area to cozy up with a book, and one bedroom has an extra room that can be used as a dressing room. The over-sized master bedroom has 2 walk-in closets and wonderful views from many windows. The storage attic runs the entire width of the house and there is also a ground level basement. The recreation room features a stone fireplace, a half bath, lots of storage, a work shop, access to the 2 car garage and plenty of natural light from big windows and a door to the yard.  </p>
        • address38 Sherwood Road
        • address_2
        • cityShort Hills
        • stateNJ
        • postal_code07078
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price1500000
        • price_20
        • price_usd1500000
        • price_usd_20
        • statusFor Sale
        • status_last_changed0000-00-00 00:00:00
        • status_last_changed_price_only0000-00-00 00:00:00
        • lease_period
        • price_upon_request(false)
        • bedrooms5
        • bedrooms_20
        • bathrooms3
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet0
        • square_meters
        • acres0
        • interior_unitsq_ft
        • interior_size0
        • lot_unitacres
        • lot_size0
        • icon_1garage
        • icon_2
        • icon_3
        • icon_4
        • icon_5
        • icon_6
        • websitehttp://www.38Sherwood.com
        • meta_titleHandsome English Tudor | Short Hills Real Estate | Towne Realty Group
        • meta_description38 Sherwood Road is a property offered for sale in Short Hills, NJ, USA, presented by Towne Realty Group
        • meta_keywords
        • bathrooms_partial2
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built
        • virtual_tourhttp://www.seetheproperty.com/196342
        • video_tourhttp://seetheproperty.com/196342/video
        • 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
        • latitude37.090240
        • longitude-95.712891
        • invalid_required_fields
        • invalid_optional_fieldssquare_feet, square_meters, acres, hectares
        • 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-08 09:12:57
        • uri/property-detail/3715/38-sherwood-road-short-hills-nj-07078-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3715/38-sherwood-road-short-hills-nj-07078-usa
        • address_concat38 Sherwood Road Short Hills NJ 07078 USA
        • google_maps_query_string38+Sherwood+Road++Short+Hills+NJ+07078+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 1,500,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty5
        • bathrooms_pretty3
        • bathrooms_partial_pretty2
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms3
        • date_listed2016-04-08
        • overridden_brokerage_nameTowne Realty Group
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id157
        • 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_id0
        • WOEID2493140
        • timezone
        • luxury_feed_enrollment_modemanual
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id
        • mlsidx_lux_autofeed(false)
        • mlsidx_lux_autofeed_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • nameTowne Realty Group
        • broker_of_record_name
        • short_nameTowne Realty Group
        • usernameTowneRealtyGroup
        • passworda4249a6dfad6cc2af05068e244f79544fefc464e
        • 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>Towne Realty Group is the exclusive representative for Leverage Global Partners in Short Hills, Essex County, Morris County, Union County, New Jersey, USA.</p> <p>Towne Realty Group, LLC, is a real estate boutique in Short Hills, NJ, with unparalleled real estate market knowledge and experience. Our agents are tenacious advocates for your interests and we are a paperless company – all of our business is conducted electronically in the cloud.  Our team of 25 professionals are all full-time pros, unmatched in the industry for their attention to detail.  Our powerful marketing and advertising programs across dozens of websites and social media platforms, will help sell your home, and our deep roots in our local communities will serve you well as a buyer.  We have transacted over $1 Billion in sales since we opened our doors in 2006.   Our agents know the local markets in New Jersey - if it happens in Millburn, Short Hills, Maplewood, South Orange, West Orange, Summit, Livingston, Chatham, Madison, Florham Park, New Providence, Springfield,  Montclair, Westfield, Cranford or surrounding towns in Essex, Morris, and Union, our agents know about it. We welcome the opportunity to assist you with any questions in our local real estate market.</p>
        • communitiesShort Hills Essex County Morris County Union County Somerset County
        • websitehttp://www.trghome.com/
        • address511 Millburn Avenue
        • address_2
        • cityShort Hills
        • stateNJ
        • full_stateNew Jersey
        • countryUSA
        • market
        • market_2
        • postal_code
        • phoneKaren Mobile: (201) 417-1600
        • phone_2Daniel Mobile: (973) 865-4144
        • phone_3Barbara's Mobile: (908) 347-6945
        • wide_contact_image(false)
        • contact_nameKaren Bigos, Barbara Birkitt, Daniel Cannizzo
        • contact_profile_link
        • contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-karen-biggs-daniel-cannizzo-towne-realty-group/
        • contact_big_profile_link_textMeet Karen Bigos, Barbara Birkitt, Daniel Cannizzo
        • contact_titleOwner/Managing Partner, Sales Manager/Broker of Record, Owner/Managing Partner
        • contact_dre_num
        • contact_quoteWe invite you to contact us personally about Short Hills & Summit, NJ real estate.
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2[email protected]
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3[email protected]
        • 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_filename157.jpg
        • logo_filename157.JPG
        • contact_image_filename157.jpg
        • all_properties_link_image_filename
        • all_properties_link
        • video_embed_code
        • contact_video_embed_code
        • meta_titleShort Hills Real Estate | Towne Realty Group | Leverage Global Partners
        • meta_description Towne Realty Group is the exclusive representative for Leverage Global Partners in Short Hills, New Jersey, USA.
        • meta_keywordsTowne Realty Group, Short Hills Realty Group, Karen Bigos, Short Hills Real Estate, Essex County Real Estate, Morris County Real Estate, Union County Real Estate, Somerset County Real Estate, New Jersey Real Estate
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2014-09-02 15:10:33
        • modified2021-07-18 10:38:47
        • dre_num012345
        • uri/brokerage-detail/157/towne-realty-group
        • website_shortwww.trghome.com
        • name_with_locationTowne 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)
          • id20606
          • modelProperty
          • model_id3715
          • tagImage
          • name36067.jpg
          • typeimage/jpeg
          • size8450952
          • uri/assets/20606.jpg
          • order0
          • created2016-04-11 18:10:59
          • modified2016-04-11 18:12:53
        • 1(array)
          • id20608
          • modelProperty
          • model_id3715
          • tagImage
          • name36070.jpg
          • typeimage/jpeg
          • size11188714
          • uri/assets/20608.jpg
          • order1
          • created2016-04-11 18:11:03
          • modified2016-04-11 18:12:53
        • 2(array)
          • id20607
          • modelProperty
          • model_id3715
          • tagImage
          • name36069.jpg
          • typeimage/jpeg
          • size13230811
          • uri/assets/20607.jpg
          • order2
          • created2016-04-11 18:11:01
          • modified2016-04-11 18:12:53
        • 3(array)
          • id20612
          • modelProperty
          • model_id3715
          • tagImage
          • name36071.jpg
          • typeimage/jpeg
          • size8029109
          • uri/assets/20612.jpg
          • order3
          • created2016-04-11 18:11:09
          • modified2016-04-11 18:12:53
        • 4(array)
          • id20613
          • modelProperty
          • model_id3715
          • tagImage
          • name36072.jpg
          • typeimage/jpeg
          • size7617858
          • uri/assets/20613.jpg
          • order4
          • created2016-04-11 18:12:21
          • modified2016-04-11 18:12:53
        • 5(array)
          • id20609
          • modelProperty
          • model_id3715
          • tagImage
          • name36073.jpg
          • typeimage/jpeg
          • size8253500
          • uri/assets/20609.jpg
          • order5
          • created2016-04-11 18:11:04
          • modified2016-04-11 18:12:53
        • 6(array)
          • id20605
          • modelProperty
          • model_id3715
          • tagImage
          • name36068.jpg
          • typeimage/jpeg
          • size9278928
          • uri/assets/20605.jpg
          • order6
          • created2016-04-11 18:10:57
          • modified2016-04-11 18:12:53
        • 7(array)
          • id20610
          • modelProperty
          • model_id3715
          • tagImage
          • name36074.jpg
          • typeimage/jpeg
          • size8414125
          • uri/assets/20610.jpg
          • order7
          • created2016-04-11 18:11:06
          • modified2016-04-11 18:12:53
        • 8(array)
          • id20611
          • modelProperty
          • model_id3715
          • tagImage
          • name36075.jpg
          • typeimage/jpeg
          • size7708807
          • uri/assets/20611.jpg
          • order8
          • created2016-04-11 18:11:07
          • modified2016-04-11 18:12:53
      • User(array)
        • 0(array)
          • id496
          • typeAgent
          • brokerage_id157
          • email[email protected]
          • passwordc80aef26fd457ef0cffd6a16e16dde7ddf08bb12
          • recover_hash
          • first_nameKaren
          • last_nameBigos
          • title
          • dre_num
          • phone201-417-1600
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2017-08-07 15:23:01
          • created2017-08-07 15:23:01
          • notified(false)
          • full_nameKaren Bigos
          • uri/agent-detail/496/karen-bigos
          • profile_complete(true)
          • UsersProperty(array)
            • id319
            • user_id496
            • property_id3715
            • sort_order0
        • 1(array)
          • id497
          • typeAgent
          • brokerage_id157
          • email[email protected]
          • passwordb0e054b97f20dd600a8a6a7e55c2c1338afb9fcc
          • recover_hash
          • first_nameDaniel
          • last_nameCannizzo
          • title
          • dre_num
          • phone973-865-4144
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2017-08-07 15:23:01
          • created2017-08-07 15:23:01
          • notified(false)
          • full_nameDaniel Cannizzo
          • uri/agent-detail/497/daniel-cannizzo
          • profile_complete(true)
          • UsersProperty(array)
            • id327
            • user_id497
            • property_id3715
            • 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)
            • id4356
            • property_id3715
            • property_feature_id4
      • Topic(empty)
    • 1(array)
      • Property(array)
        • id3755
        • brokerage_id244
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameSunset Strip Complex
        • incomplete(false)
        • archived(false)
        • last_archived0000-00-00 00:00:00
        • auto_archived_from_mlsidx(false)
        • paid_featured(false)
        • featured(false)
        • homepage_featured(false)
        • brokerage_page_featured(true)
        • requested_homepage_featured_by_member(false)
        • homepage_featured_by_member(false)
        • dot_luxury_featured(false)
        • luxury_feed_featured(false)
        • force_luxury_feed_featured(false)
        • luxury_autofeed_imported(false)
        • luxury_feed_last_added_time0000-00-00 00:00:00
        • luxury_feed_agent_user_id0
        • luxury_feed_locked_to_subscription_id0
        • luxury_feed_agent_purchase_date0000-00-00
        • luxury_feed_agent_expiration_date0000-00-00
        • digital_ad_summary_email_last_sent0000-00-00 00:00:00
        • digital_ad_summary_price_changed(true)
        • wsj_detail_url
        • ft_detail_url
        • nyt_detail_url
        • juwai_detail_url
        • pgl_detail_url
        • mg_detail_url
        • mg_c_detail_url
        • mg_s_detail_url
        • bp_detail_url
        • mw_detail_url
        • nikkei_detail_url
        • wapo_detail_url
        • robb_detail_url
        • medium_featured(false)
        • large_featured(false)
        • detail_page(false)
        • description<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris ut gravida metus, sit amet ornare nisl. In sed velit magna. Vestibulum convallis, lectus eu luctus aliquam, velit mi suscipit nibh, eget ullamcorper nunc turpis vehicula dolor. Quisque aliquet eros nec nibh accumsan, sed suscipit risus pharetra. Curabitur condimentum porta dolor, eget porta erat placerat id. Curabitur eget mollis leo, et ornare dolor. Mauris eget dui libero. Interdum et malesuada fames ac ante ipsum primis in faucibus. Phasellus consequat diam et magna molestie, at condimentum ipsum consequat.</p>
        • address9255 Swallow Drive
        • address_2
        • cityLos Angeles
        • stateCA
        • postal_code90069
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price12000000
        • price_20
        • price_usd12000000
        • price_usd_20
        • statusFor Sale
        • status_last_changed0000-00-00 00:00:00
        • status_last_changed_price_only0000-00-00 00:00:00
        • lease_period
        • price_upon_request(false)
        • bedrooms0
        • bedrooms_20
        • bathrooms0
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet0
        • square_meters
        • acres0
        • interior_unitsq_ft
        • interior_size0
        • lot_unitacres
        • lot_size0
        • icon_1
        • icon_2
        • icon_3
        • icon_4
        • icon_5
        • icon_6
        • website
        • meta_title
        • meta_description
        • meta_keywords
        • bathrooms_partial0
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built
        • virtual_tour
        • video_tour
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num
        • wsj_property_type
        • nyt_property_type
        • nyt_popular_features
        • propgolux_property_type
        • juwai_property_type
        • juwai_category
        • propgolux_property_style
        • wapo_property_type
        • robb_property_type
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude34.104874
        • longitude-118.389793
        • invalid_required_fields
        • invalid_optional_fields
        • went_live_today(false)
        • converted(false)
        • invalid(false)
        • mlsidx_full_address
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2019-10-31 00:13:54
        • created2019-10-31 00:13:45
        • uri/property-detail/3755/9255-swallow-drive-los-angeles-ca-90069-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3755/9255-swallow-drive-los-angeles-ca-90069-usa
        • address_concat9255 Swallow Drive Los Angeles CA 90069 USA
        • google_maps_query_string9255+Swallow+Drive++Los+Angeles+CA+90069+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 12,000,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty0
        • bathrooms_pretty0
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms0
        • date_listed2019-10-31
        • overridden_brokerage_nameSmith & Berg
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id244
        • account_executive_id0
        • archived(false)
        • typeteam
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typeBasic
        • max_properties10
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties0
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id0
        • WOEID(null)
        • timezoneAmerica/Los_Angeles
        • luxury_feed_enrollment_modemanual
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id
        • mlsidx_lux_autofeed(false)
        • mlsidx_lux_autofeed_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • nameSmith & Berg
        • broker_of_record_nameCompass
        • short_nameSmith & Berg
        • username
        • password
        • password_reset_hash
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename
        • active(true)
        • lead_inYou've tried the rest, now try the best
        • short_description
        • description<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed et est ut dui hendrerit auctor sit amet ut lorem. Proin eleifend tristique felis. Curabitur bibendum enim mauris, nec volutpat lectus aliquam a. Vestibulum laoreet tellus ac porta consectetur. Quisque quam tellus, tempus vel sollicitudin id, convallis ut erat. Nullam laoreet aliquet sapien non porttitor. Curabitur eu commodo quam, in pellentesque nibh. Etiam non dolor fermentum velit commodo feugiat a ut augue. Sed faucibus tincidunt vestibulum. Pellentesque tincidunt sed lorem at efficitur. Suspendisse maximus arcu eget fermentum pharetra. Praesent dapibus justo sit amet vestibulum molestie.</p> <p>Nullam eu faucibus nisi, sed lacinia eros. Quisque finibus nec ante eu scelerisque. In hac habitasse platea dictumst. Nam turpis augue, ornare sed odio a, placerat vestibulum augue. Curabitur posuere turpis sed nisl tempus, id feugiat ipsum dictum. Praesent venenatis pharetra nunc at tincidunt. Ut sollicitudin quam sit amet tortor molestie, at bibendum diam cursus. Cras ac metus vitae sapien condimentum consequat sit amet eget metus. Vestibulum et venenatis purus. Donec tincidunt pharetra ex quis tempor. Vivamus non sapien eget elit auctor ultrices at eget turpis. Nulla volutpat ut nibh eget placerat.</p>
        • communitiesLos Angeles
        • websitehttps://compass.com
        • address680 E. Colorado Blvd
        • address_2Suite 150
        • cityPasadena
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • market
        • market_2
        • postal_code91101
        • phone8888888888
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameF. Ron Smith
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titlePrincipal
        • contact_dre_num11624555
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone565-135-7745
        • contact_email_2[email protected]
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2878-829-1672
        • contact_website
        • contact_name_2Chris Stephonovich
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2Associate Realtor
        • contact_dre_num_241768321
        • contact_email_3[email protected]
        • contact_name_3Courtney P. Wolpertinger
        • contact_title_3Associate Realtor
        • contact_dre_num_384919983
        • contact_phone_3158-646-8246
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename
        • logo_filename
        • contact_image_filename
        • all_properties_link_image_filename
        • all_properties_link
        • video_embed_code
        • contact_video_embed_code
        • meta_title
        • meta_description
        • meta_keywords
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(false)
        • created2019-10-31 00:07:13
        • modified2021-07-18 10:40:16
        • dre_num012345
        • uri/team-detail/244/smith-berg
        • website_shortcompass.com
        • name_with_locationSmith & Berg
      • StripeSubscription(array)
        • id(null)
        • brokerage_id(null)
        • user_id(null)
        • property_id(null)
        • type(null)
        • stripe_id(null)
        • stripe_customer_id(null)
        • stripe_checkout_email(null)
        • stripe_promotion_code(null)
        • stripe_promotion_code_id(null)
        • stripe_coupon_code_id(null)
        • status(null)
        • current_period_end(null)
        • cancel_at_period_end(null)
        • ended(null)
        • last_change(null)
        • last_activity_email_sent(null)
        • created(null)
        • modified(null)
      • GlobalReachReport(array)
        • id(null)
        • property_id(null)
        • wsj_desktop(null)
        • wsj_mobile(null)
        • wsj_expires(null)
        • wsj_capture_started(null)
        • mg_desktop(null)
        • mg_mobile(null)
        • mg_expires(null)
        • mg_capture_started(null)
        • bp_desktop(null)
        • bp_mobile(null)
        • bp_expires(null)
        • gp_capture_started(null)
        • mw_desktop(null)
        • mw_mobile(null)
        • mw_expires(null)
        • mw_capture_started(null)
        • ft_desktop(null)
        • ft_mobile(null)
        • ft_expires(null)
        • ft_capture_started(null)
        • nikkei_desktop(null)
        • nikkei_mobile(null)
        • nikkei_expires(null)
        • nikkei_capture_started(null)
        • pgl_desktop(null)
        • pgl_mobile(null)
        • pgl_expires(null)
        • pgl_capture_started(null)
        • robb_desktop(null)
        • robb_mobile(null)
        • robb_expires(null)
        • robb_capture_started(null)
        • juwai_desktop(null)
        • juwai_mobile(null)
        • juwai_expires(null)
        • juwai_capture_started(null)
        • leverage_desktop(null)
        • leverage_mobile(null)
        • leverage_expires(null)
        • leverage_capture_started(null)
        • created(null)
        • modified(null)
        • wsj_available(false)
        • wsj_expired(true)
        • wsj_desktop_proxy_screenshot(null)
        • wsj_mobile_proxy_screenshot(null)
        • mg_available(false)
        • mg_expired(true)
        • mg_desktop_proxy_screenshot(null)
        • mg_mobile_proxy_screenshot(null)
        • bp_available(false)
        • bp_expired(true)
        • bp_desktop_proxy_screenshot(null)
        • bp_mobile_proxy_screenshot(null)
        • mw_available(false)
        • mw_expired(true)
        • mw_desktop_proxy_screenshot(null)
        • mw_mobile_proxy_screenshot(null)
        • nikkei_available(false)
        • nikkei_expired(true)
        • nikkei_desktop_proxy_screenshot(null)
        • nikkei_mobile_proxy_screenshot(null)
        • pgl_available(false)
        • pgl_expired(true)
        • pgl_desktop_proxy_screenshot(null)
        • pgl_mobile_proxy_screenshot(null)
        • robb_available(false)
        • robb_expired(true)
        • robb_desktop_proxy_screenshot(null)
        • robb_mobile_proxy_screenshot(null)
        • juwai_available(false)
        • juwai_expired(true)
        • juwai_desktop_proxy_screenshot(null)
        • juwai_mobile_proxy_screenshot(null)
        • capture_processing(false)
        • capture_error(empty)
      • Image(array)
        • 0(array)
          • id23088
          • modelProperty
          • model_id3755
          • tagImage
          • name7ab079e6d3fcc3f540f780f5080587df8beb7d73.jpeg
          • typeimage/jpeg
          • size520160
          • uri/assets/23088.jpeg
          • order0
          • created2019-10-31 00:13:42
          • modified2019-10-31 00:13:45
      • User(empty)
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(empty)
      • Topic(empty)
    • 2(array)
      • Property(array)
        • id3726
        • brokerage_id192
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameOver 100 ft of Riverfront with Sandy Beach
        • 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>Main house includes 6 BDR and 7 Baths. Master suite located on main floor with jet tub, walk in shower and sweeping views of the Colorado River. 2 additional bdr suites on main floor as well. Dramatic entry with dynamic views of the river from 2 story entry faced with wall of windows. Plenty of room for sit down dinner or quick snack at the breakfast bar. Dream kitchen with granite counters, Dacon appliances, Sub Zero Refrigerator, gas cook top and views to the river. Upstairs you'll find spacious family room with 1/2 bath and closet with access to sundeck and 2 bedroom suites. Guests feel special in the mini master complete with private deck and views of the river. Catwalk connects family room and bedrooms with gorgeous views of the river, sandy beach and front yard compound. Short walk to guest house with over 750 sq ft. Over 100 ft of riverfront with sandy beach, private boat launch and dock. Electric gate entry, fully fenced acreage makes living on the river a true private vacation destination. Outdoor kitchen and covered patios! Sand between the toes and a bit of shade under the palapa as living on the river doesn't get any better than this.</p>
        • address9853 S Dike Rd
        • address_2
        • cityMohave Valley
        • stateAZ
        • postal_code86440
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price1750000
        • price_20
        • price_usd1750000
        • 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
        • bathrooms3
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet5249
        • square_meters
        • acres52391
        • interior_unitsq_ft
        • interior_size0
        • lot_unitacres
        • lot_size52391
        • icon_1
        • icon_2
        • icon_3
        • icon_4
        • icon_5
        • icon_6
        • websitehttp://search.ussw.net/listing/912084
        • meta_title
        • meta_description
        • meta_keywords
        • bathrooms_partial4
        • bathrooms_partial_20
        • bathrooms_3_41
        • bathrooms_3_4_20
        • year_built1998
        • virtual_tour
        • video_tour
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num912084
        • 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
        • latitude37.090240
        • longitude-95.712891
        • invalid_required_fields
        • invalid_optional_fields
        • went_live_today(false)
        • converted(true)
        • invalid(false)
        • mlsidx_full_address
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2016-04-18 05:33:03
        • created2016-04-13 10:23:58
        • uri/property-detail/3726/9853-s-dike-rd-mohave-valley-az-86440-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3726/9853-s-dike-rd-mohave-valley-az-86440-usa
        • address_concat9853 S Dike Rd Mohave Valley AZ 86440 USA
        • google_maps_query_string9853+S+Dike+Rd++Mohave+Valley+AZ+86440+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 1,750,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty7
        • bathrooms_pretty3
        • bathrooms_partial_pretty4
        • bathrooms_3_4_pretty1
        • feed_full_bathrooms4
        • date_listed2016-04-13
        • overridden_brokerage_nameUS Southwest
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id192
        • 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
        • WOEID2371675
        • 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
        • nameUS Southwest
        • broker_of_record_name
        • short_nameUS Southwest
        • usernameUSSouthwestLLC
        • passwordaca3f804a48f1447c4a6fd356b1f302279862050
        • 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>US Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, Mohave Valley, Fort Mohave AZ, USA.</p> <p>US Southwest is a boutique real estate company comprised of like minded pro-fessionals whose mission is to provide the best professional service so their clients can make informed decisions to achieve their goals. The talent and depth within the company is unmatched in Mohave County. Several of the key players at US Southwest have managed a business or owned their own busi- ness. The combined talents provide a unique business platform in which diversity, collaboration, team work, and professionalism, foster a business perspective and environment that generates creativity and productivity, and ultimately, successful results for clients.</p> <p>US Southwest has the capability, expertise and area relationships to assist its clients in any type of real estate endeavor. Its founders, Ann L. Pettit and Ray W. Jackson III, have worked in every kind of real estate enterprise for over 30 years in Northwestern Arizona and are perceived as innovative leaders and pioneers of the industry. They have a relationship building philosophy and their motto is - Your Success is Our Success.</p>
        • communitiesBullhead City Fort Mohave Mohave Valley
        • websitehttp://ussw.net/
        • address3767 Highway 95
        • address_2
        • cityBullhead City
        • stateAZ
        • full_stateArizona
        • countryUSA
        • market
        • market_2
        • postal_code86442
        • phone(928) 763-2288
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameAnn Pettit
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titleOwner
        • 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_filename192.jpg
        • logo_filename192.jpg
        • contact_image_filename192.png
        • all_properties_link_image_filename192.jpg
        • all_properties_linkhttp://ussw.net/wolfnet-properties
        • video_embed_code
        • contact_video_embed_code
        • meta_titleBullhead City Real Estate | US Southwest | Leverage Global Partners
        • meta_descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, AZ, USA.
        • meta_keywordsUS Southwest LLC, Bullhead city real estate, arizona real estate, ann pettit, bullhead city, leverage global partners, Fort Mohave, Mohave Valley
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2015-02-13 10:18:22
        • modified2016-04-08 16:34:20
        • dre_num012345
        • uri/brokerage-detail/192/us-southwest
        • website_shortussw.net
        • name_with_locationUS Southwest
      • 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)
          • id20809
          • modelProperty
          • model_id3726
          • tagImage
          • name9853_Dike (1).jpg
          • typeimage/jpeg
          • size1946014
          • uri/assets/20809.jpg
          • order0
          • created2016-04-13 10:23:45
          • modified2016-04-13 10:23:59
        • 1(array)
          • id20805
          • modelProperty
          • model_id3726
          • tagImage
          • name9853DikeRd_60.jpg
          • typeimage/jpeg
          • size464564
          • uri/assets/20805.jpg
          • order1
          • created2016-04-13 10:23:43
          • modified2016-04-13 10:23:59
        • 2(array)
          • id20806
          • modelProperty
          • model_id3726
          • tagImage
          • name9853DikeRd_19.jpg
          • typeimage/jpeg
          • size270202
          • uri/assets/20806.jpg
          • order2
          • created2016-04-13 10:23:43
          • modified2016-04-13 10:23:59
        • 3(array)
          • id20807
          • modelProperty
          • model_id3726
          • tagImage
          • name9853DikeRd_70.jpg
          • typeimage/jpeg
          • size288097
          • uri/assets/20807.jpg
          • order3
          • created2016-04-13 10:23:44
          • modified2016-04-13 10:23:59
        • 4(array)
          • id20808
          • modelProperty
          • model_id3726
          • tagImage
          • name9853DikeRd_69.jpg
          • typeimage/jpeg
          • size444920
          • uri/assets/20808.jpg
          • order4
          • created2016-04-13 10:23:44
          • modified2016-04-13 10:23:59
        • 5(array)
          • id20810
          • modelProperty
          • model_id3726
          • tagImage
          • name9853DikeRd_76.jpg
          • typeimage/jpeg
          • size404572
          • uri/assets/20810.jpg
          • order5
          • created2016-04-13 10:23:53
          • modified2016-04-13 10:23:59
      • User(empty)
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(array)
        • 0(array)
          • id1
          • nameBalcony/Terrace
          • additional(false)
          • created2016-04-07 14:00:26
          • modified2016-04-07 14:00:26
          • PropertiesPropertyFeature(array)
            • id4387
            • property_id3726
            • property_feature_id1
        • 1(array)
          • id2
          • nameBeach Access
          • additional(false)
          • created2016-04-07 14:00:52
          • modified2016-04-07 14:00:52
          • PropertiesPropertyFeature(array)
            • id4388
            • property_id3726
            • property_feature_id2
        • 2(array)
          • id4
          • nameGarage
          • additional(false)
          • created2016-04-07 14:01:52
          • modified2016-04-07 14:01:52
          • PropertiesPropertyFeature(array)
            • id4389
            • property_id3726
            • property_feature_id4
        • 3(array)
          • id10
          • nameOn The Sand
          • additional(false)
          • created2016-04-07 14:03:36
          • modified2016-04-07 14:03:36
          • PropertiesPropertyFeature(array)
            • id4390
            • property_id3726
            • property_feature_id10
        • 4(array)
          • id11
          • nameSki In/Ski Out
          • additional(false)
          • created2016-04-07 14:03:53
          • modified2016-04-07 14:03:53
          • PropertiesPropertyFeature(array)
            • id4391
            • property_id3726
            • property_feature_id11
        • 5(array)
          • id14
          • nameViews
          • additional(false)
          • created2016-04-07 14:04:55
          • modified2016-04-07 14:04:55
          • PropertiesPropertyFeature(array)
            • id4392
            • property_id3726
            • property_feature_id14
        • 6(array)
          • id17
          • nameWaterfront
          • additional(false)
          • created2016-04-07 14:06:00
          • modified2016-04-07 14:06:00
          • PropertiesPropertyFeature(array)
            • id4393
            • property_id3726
            • property_feature_id17
      • Topic(array)
        • 0(array)
          • id8
          • nameBeach
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:30:26
          • tile_nameBeach
          • PropertiesTopic(array)
            • id23
            • property_id3726
            • topic_id8
        • 1(array)
          • id20
          • nameUltra Lux
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:35:37
          • tile_nameUltra Lux
          • PropertiesTopic(array)
            • id24
            • property_id3726
            • topic_id20
    • 3(array)
      • Property(array)
        • id3706
        • brokerage_id81
        • created_by_user_id0
        • order6
        • multi_unit(false)
        • agent_1_id150
        • agent_2_id0
        • agent_3_id0
        • nameTudor Accents
        • incomplete(false)
        • archived(false)
        • last_archived0000-00-00 00:00:00
        • auto_archived_from_mlsidx(false)
        • paid_featured(false)
        • featured(true)
        • homepage_featured(false)
        • brokerage_page_featured(true)
        • requested_homepage_featured_by_member(false)
        • homepage_featured_by_member(false)
        • dot_luxury_featured(false)
        • luxury_feed_featured(false)
        • force_luxury_feed_featured(false)
        • luxury_autofeed_imported(false)
        • luxury_feed_last_added_time0000-00-00 00:00:00
        • luxury_feed_agent_user_id0
        • luxury_feed_locked_to_subscription_id0
        • luxury_feed_agent_purchase_date0000-00-00
        • luxury_feed_agent_expiration_date0000-00-00
        • digital_ad_summary_email_last_sent0000-00-00 00:00:00
        • digital_ad_summary_price_changed(false)
        • wsj_detail_url
        • ft_detail_url
        • nyt_detail_url
        • juwai_detail_url
        • pgl_detail_url
        • mg_detail_url
        • mg_c_detail_url
        • mg_s_detail_url
        • bp_detail_url
        • mw_detail_url
        • nikkei_detail_url
        • wapo_detail_url
        • robb_detail_url
        • medium_featured(false)
        • large_featured(false)
        • detail_page(true)
        • description<p>As good as it gets! This picturesque block of Oakridge Avenue is spectacular! It's peaceful, scenic & so convenient with its access to downtown Bethesda (via Thornapple Path!) These long-time, caring owners have taken wonderful care of this classic Chevy Chase residence. The dramatic family room addition with due east exposure & soaring ceilings is amazing! *Loft retreat with bedroom & office*</p>
        • address6907 Oakridge Avenue
        • address_2
        • cityChevy Chase
        • stateMD
        • postal_code20815
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price1395000
        • price_20
        • price_usd1395000
        • price_usd_20
        • statusFor Sale
        • status_last_changed0000-00-00 00:00:00
        • status_last_changed_price_only0000-00-00 00:00:00
        • lease_period
        • price_upon_request(false)
        • bedrooms4
        • bedrooms_20
        • bathrooms2
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet0
        • square_meters
        • acres0
        • interior_unitsq_ft
        • interior_size0
        • lot_unitacres
        • lot_size0
        • icon_1
        • icon_2
        • icon_3
        • icon_4
        • icon_5
        • icon_6
        • websitehttp://www.eversco.com/homes-for-sale-details/6907-OAKRIDGE-AVENUE-CHEVY-CHASE-MD-20815/MC9581947/30/
        • meta_titleTudor Accents | Chevy Chase Real Estate | Evers & Co. Real Estate
        • meta_description6907 Oakridge Avenue is a property offered for sale in Chevy Chase, MD, USA, presented by Evers & Co. Real Estate
        • meta_keywords
        • bathrooms_partial2
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built
        • virtual_tourhttp://slideshow.mris.com/slideshow/slideshow.htm?ListingKey=300027450487
        • video_tour
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num
        • wsj_property_type
        • nyt_property_type
        • nyt_popular_features
        • propgolux_property_type
        • juwai_property_type
        • juwai_category
        • propgolux_property_style
        • wapo_property_type
        • robb_property_type
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude0.000000
        • longitude0.000000
        • invalid_required_fields
        • invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, video_tour
        • went_live_today(false)
        • converted(true)
        • invalid(false)
        • mlsidx_full_address
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2016-04-18 05:33:03
        • created2016-04-06 12:20:13
        • uri/property-detail/3706/6907-oakridge-avenue-chevy-chase-md-20815-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3706/6907-oakridge-avenue-chevy-chase-md-20815-usa
        • address_concat6907 Oakridge Avenue Chevy Chase MD 20815 USA
        • google_maps_query_string6907+Oakridge+Avenue++Chevy+Chase+MD+20815+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 1,395,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty4
        • bathrooms_pretty2
        • bathrooms_partial_pretty2
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms2
        • date_listed2016-04-06
        • overridden_brokerage_nameEvers & Co. Real Estate
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id81
        • account_executive_id235
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties8
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties0
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id1
        • WOEID2379523
        • timezoneUS/Eastern
        • luxury_feed_enrollment_modemanual
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id
        • mlsidx_lux_autofeed(false)
        • mlsidx_lux_autofeed_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • nameEvers & Co. Real Estate
        • broker_of_record_name
        • short_nameEvers & Co. Real Estate
        • usernameEversCoRealEstateCC
        • password440e06f17502b0b97a9e4aa2f069e898691a3b4c
        • password_reset_hash
        • monthly_invoice_amount0.00
        • monthly_invoice_start_date0000-00-00
        • monthly_invoice_end_date0000-00-00
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>Evers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Chevy Chase, MD, and <a href="../../../brokerage-detail/80/Evers-&-Co.-Real-Estate">Washington, D.C</a>, USA.,</p> <p>We are 100+ salespeople who offer our clients a level of service that is unmatched in today’s real estate marketplace, and we deliver this extraordinary service with courtesy and integrity to everyone involved in each transaction.</p> <p>We are enthusiastic about the neighborhoods where we live and work, from Chevy Chase to Capitol Hill, from Dupont Circle to Arlington, and everywhere in between. The highly visible storefront offices of Evers & Co. in Downtown Washington, Friendship Heights in Upper Northwest, downtown Bethesda-Chevy Chase and in Bluemont in the Virginia Wine Country are bustling with the entrepreneurial energy of agents who have in-depth knowledge of local history, architecture and construction techniques as well as expert skills in marketing and negotiating, all of which adds value to our service and your investment.</p> <p>This spectrum of knowledge and our commitment to serving our clientele and fellow real estate associates with the highest level of integrity has made us the premier independent brokerage in the Metropolitan Washington area.</p> <p>Donna Evers and the agents of Evers & Co. invite you to join our growing community of buyers and sellers, who have been the source of 90% of our business for the past thirty years.</p>
        • communitiesBethesda Chevy Chase Village Town of Chevy Chase Somerset Edgemoor Kenwood Kenwood Park Burning Tree Avenel Silver Spring
        • websitehttp://www.eversco.com/
        • address7032 Wisconsin Avenue
        • address_2
        • cityChevy Chase
        • stateMD
        • full_stateMaryland
        • countryUSA
        • marketChevy Chase
        • market_2
        • postal_code20815
        • phoneOffice: (301) 656-1800
        • phone_2Cell: (202) 255-5009
        • phone_3
        • wide_contact_image(false)
        • contact_nameDonna Evers
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titlePresident & Founder
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename81.jpg
        • logo_filename81.jpg
        • contact_image_filename81.jpg
        • all_properties_link_image_filename81.JPG
        • all_properties_linkhttp://eversco.idxre.com/featured/40484?CFID=10711248&CFTOKEN=99152164
        • video_embed_code
        • contact_video_embed_code
        • meta_titleChevy Chase Real Estate | Evers & Co. Real Estate | Leverage Global Partners
        • meta_descriptionEvers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Bethesda, Chevy Chase Village, Town of Chevy Chase, Somerset, Edgemoor, Kenwood, Kenwood Park, Burning Tree, Avenel, and Silver Spring, MD.
        • meta_keywordsChevy Chase Real Estate, Evers & Co. Real Estate, Leverage Global Partners, Bethesda real estate, Chevy Chase Village real estate, Town of Chevy Chase real estate, Somerset real estate, Edgemoor real estate, Kenwood real estate, Kenwood Park real estate, Burning Tree real estate, Avenel real estate, and Silver Spring real estate, MD.
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2014-01-10 16:43:02
        • modified2016-04-08 16:34:01
        • dre_num012345
        • uri/brokerage-detail/81/evers-co-real-estate
        • website_shortwww.eversco.com
        • name_with_locationEvers & Co. Real Estate
      • StripeSubscription(array)
        • id(null)
        • brokerage_id(null)
        • user_id(null)
        • property_id(null)
        • type(null)
        • stripe_id(null)
        • stripe_customer_id(null)
        • stripe_checkout_email(null)
        • stripe_promotion_code(null)
        • stripe_promotion_code_id(null)
        • stripe_coupon_code_id(null)
        • status(null)
        • current_period_end(null)
        • cancel_at_period_end(null)
        • ended(null)
        • last_change(null)
        • last_activity_email_sent(null)
        • created(null)
        • modified(null)
      • GlobalReachReport(array)
        • id(null)
        • property_id(null)
        • wsj_desktop(null)
        • wsj_mobile(null)
        • wsj_expires(null)
        • wsj_capture_started(null)
        • mg_desktop(null)
        • mg_mobile(null)
        • mg_expires(null)
        • mg_capture_started(null)
        • bp_desktop(null)
        • bp_mobile(null)
        • bp_expires(null)
        • gp_capture_started(null)
        • mw_desktop(null)
        • mw_mobile(null)
        • mw_expires(null)
        • mw_capture_started(null)
        • ft_desktop(null)
        • ft_mobile(null)
        • ft_expires(null)
        • ft_capture_started(null)
        • nikkei_desktop(null)
        • nikkei_mobile(null)
        • nikkei_expires(null)
        • nikkei_capture_started(null)
        • pgl_desktop(null)
        • pgl_mobile(null)
        • pgl_expires(null)
        • pgl_capture_started(null)
        • robb_desktop(null)
        • robb_mobile(null)
        • robb_expires(null)
        • robb_capture_started(null)
        • juwai_desktop(null)
        • juwai_mobile(null)
        • juwai_expires(null)
        • juwai_capture_started(null)
        • leverage_desktop(null)
        • leverage_mobile(null)
        • leverage_expires(null)
        • leverage_capture_started(null)
        • created(null)
        • modified(null)
        • wsj_available(false)
        • wsj_expired(true)
        • wsj_desktop_proxy_screenshot(null)
        • wsj_mobile_proxy_screenshot(null)
        • mg_available(false)
        • mg_expired(true)
        • mg_desktop_proxy_screenshot(null)
        • mg_mobile_proxy_screenshot(null)
        • bp_available(false)
        • bp_expired(true)
        • bp_desktop_proxy_screenshot(null)
        • bp_mobile_proxy_screenshot(null)
        • mw_available(false)
        • mw_expired(true)
        • mw_desktop_proxy_screenshot(null)
        • mw_mobile_proxy_screenshot(null)
        • nikkei_available(false)
        • nikkei_expired(true)
        • nikkei_desktop_proxy_screenshot(null)
        • nikkei_mobile_proxy_screenshot(null)
        • pgl_available(false)
        • pgl_expired(true)
        • pgl_desktop_proxy_screenshot(null)
        • pgl_mobile_proxy_screenshot(null)
        • robb_available(false)
        • robb_expired(true)
        • robb_desktop_proxy_screenshot(null)
        • robb_mobile_proxy_screenshot(null)
        • juwai_available(false)
        • juwai_expired(true)
        • juwai_desktop_proxy_screenshot(null)
        • juwai_mobile_proxy_screenshot(null)
        • capture_processing(false)
        • capture_error(empty)
      • Image(array)
        • 0(array)
          • id20563
          • modelProperty
          • model_id3706
          • tagImage
          • name36010.jpg
          • typeimage/jpg
          • size5169715
          • uri/assets/20563.jpg
          • order2894
          • created2016-04-07 17:34:08
          • modified2016-04-07 17:34:08
      • User(array)
        • 0(array)
          • id373
          • typeAgent
          • brokerage_id81
          • email[email protected]
          • passwordb55b12a59c129a72a8f1b8e192578b4ea7cdc2a3
          • recover_hash
          • first_nameEric
          • last_nameMurtagh
          • title
          • dre_num
          • phone301-412-9066
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2017-08-07 15:22:49
          • created2017-08-07 15:22:49
          • notified(false)
          • full_nameEric Murtagh
          • uri/agent-detail/373/eric-murtagh
          • profile_complete(true)
          • UsersProperty(array)
            • id175
            • user_id373
            • property_id3706
            • sort_order0
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(empty)
      • Topic(empty)
  • sidebar_articles(array)
    • 0(array)
      • Article(array)
        • id441
        • modelLocation
        • model_id15
        • archived(false)
        • medium_featured(true)
        • large_featured(false)
        • titleLocation: Charleston
        • authorLeverageRE
        • date2016-03-28
        • lead_inHome of Leverage Partner dunes properties, Charleston is renowned for its Southern hospitality and historic charm. Walk along cobblestone streets lined with Spanish moss-draped trees, embrace the beautiful, centuries-old mansions and majestically preserved plantations and churches.
        • body<p>No matter where you turn, Charleston emanates a true historic feel, yet boasts a sense of modernism with its restaurants, shops and art galleries.</p> <p><img src="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-28-at-6.30.46-PM.png" /></p> <p><strong>INDULGE</strong>. <a href="http://www.plantersinn.com/peninsula-grill.htm#cake" target="_blank">The Peninsula Grill </a>inside the historic Planters Inn is home to the decadent Ultimate Coconut Cake. The 12-layer, cream-fi dessert is sold by the slice for diners or shipped whole across the country.</p> <p><img class="aligncenter wp-image-12880 pure-img" src="/assets/3074.png" /></p> <p><strong>FIND.</strong> Since 1922, <a href="http://birlant.com/" target="_blank">George C. Birlant & Co.</a> has been offering period furniture, silver, and accessories, as well as handcrafted reproductions of the famous Charleston Battery Bench that dots the city's sidewalks and parks</p> <p><strong>ADORN.</strong> <a href="http://croghansjewelbox.com/" target="_blank"><strong>Croghan's</strong> <strong>Jewel</strong> <strong>Box</strong></a> has enchanted generations of Charlestonians with a brilliant selection of jew- els and gifts. The family-run business has occupied the same 18th-century Charleston Single House on King Street since William Joseph Croghan opened shop over 100 years ago.</p> <p><img class="aligncenter wp-image-12878 pure-img" src="/assets/3075.png" /></p> <p><strong>SCREAM.</strong> <a href="http://bulldogtours.com/charleston-ghost-dungeon-walking-tour/" target="_blank">Bulldog</a> walking tours offer a glimpse at the haunted sites through- out town, but for a real fright, explore pre–Revolutionary War prisons during the dark of night.</p> <p><img class="aligncenter wp-image-12881 pure-img" src="/assets/3076.png" /></p>
        • vimeo_id
        • created2016-04-05 14:30:24
        • modified2016-04-11 17:04:52
        • uri/articles/view/441/location-charleston
        • flattened_topics(array)
          • 0Voice from the Street
      • ParentBrokerage(array)
        • id(null)
        • account_executive_id(null)
        • archived(null)
        • type(null)
        • hide_from_frontend(null)
        • agent_brokerage_data_override(null)
        • featured_development(null)
        • membership_type(null)
        • max_properties(null)
        • max_homepage_featured_by_member_properties(null)
        • featured_properties_sort_method(null)
        • lux_feed_mode(null)
        • max_luxury_feed_properties(null)
        • membership_luxury_feed_properties(null)
        • can_participate_in_lux_feed_while_archived(null)
        • full_training_video_access(null)
        • country_id(null)
        • WOEID(null)
        • timezone(null)
        • luxury_feed_enrollment_mode(null)
        • luxury_feed_include_mlsidx_minimum_price(null)
        • luxury_feed_include_leverage_minimum_price(null)
        • digital_ad_contacts(null)
        • add_agents_to_grr_auto_recipients(null)
        • mlsidx_id(null)
        • mlsidx_lux_autofeed(null)
        • mlsidx_lux_autofeed_minimum_price(null)
        • mlsidx_logo_url(null)
        • mlsidx_disclaimer(null)
        • name(null)
        • broker_of_record_name(null)
        • short_name(null)
        • username(null)
        • password(null)
        • password_reset_hash(null)
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename(null)
        • active(null)
        • lead_in(null)
        • short_description(null)
        • description(null)
        • communities(null)
        • website(null)
        • address(null)
        • address_2(null)
        • city(null)
        • state(null)
        • full_state(null)
        • country(null)
        • market(null)
        • market_2(null)
        • postal_code(null)
        • phone(null)
        • phone_2(null)
        • phone_3(null)
        • wide_contact_image(null)
        • contact_name(null)
        • contact_profile_link(null)
        • contact_big_profile_link(null)
        • contact_big_profile_link_text(null)
        • contact_title(null)
        • contact_dre_num(null)
        • contact_quote(null)
        • contact_email(null)
        • contact_facebook(null)
        • contact_twitter(null)
        • contact_instagram(null)
        • contact_pinterest(null)
        • contact_linkedin(null)
        • contact_youtube(null)
        • contact_phone(null)
        • contact_email_2(null)
        • contact_2_facebook(null)
        • contact_2_twitter(null)
        • contact_2_instagram(null)
        • contact_2_pinterest(null)
        • contact_2_linkedin(null)
        • contact_2_youtube(null)
        • contact_phone_2(null)
        • contact_website(null)
        • contact_name_2(null)
        • contact_profile_link_2(null)
        • contact_big_profile_link_2(null)
        • contact_big_profile_link_text_2(null)
        • contact_title_2(null)
        • contact_dre_num_2(null)
        • contact_email_3(null)
        • contact_name_3(null)
        • contact_title_3(null)
        • contact_dre_num_3(null)
        • contact_phone_3(null)
        • contact_3_facebook(null)
        • contact_3_twitter(null)
        • contact_3_instagram(null)
        • contact_3_pinterest(null)
        • contact_3_linkedin(null)
        • contact_3_youtube(null)
        • image_filename(null)
        • logo_filename(null)
        • contact_image_filename(null)
        • all_properties_link_image_filename(null)
        • all_properties_link(null)
        • video_embed_code(null)
        • contact_video_embed_code(null)
        • meta_title(null)
        • meta_description(null)
        • meta_keywords(null)
        • login_message_counter(null)
        • stats_module_1_type(null)
        • stats_module_1_value(null)
        • stats_module_2_type(null)
        • stats_module_2_value(null)
        • stats_module_3_type(null)
        • stats_module_3_value(null)
        • last_activity_email_sent(null)
        • converted(null)
        • created(null)
        • modified(null)
        • dre_num(null)
        • name_with_location
      • ParentLocation(array)
        • id15
        • parent_id8
        • brokerage_id219
        • typeExclusive
        • archived(false)
        • use_as_topic(false)
        • nameCharleston, SC, USA
        • short_nameCharleston, SC, USA
        • group_index
        • latitude32.779144
        • longitude-79.924866
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_descriptionCharleston thrives with a perfect blend of modern commerce and historical significance.
        • long_descriptionWhether you dream of historic charm, oceanfront majesty, secluded islands, an urban oasis, friendly suburbia, or a quiet rural getaway- Charleston and its coastal communities have a place for you. Golf, summer's Spoleto Festival which brings a world of entertainment to the city, fishing, water sports, plantation gardens, hiking trails, museums, there is truly something for everyone. Charleston is thriving with the perfect blend of modern day commerce and historical significance. Charleston is — well, Charleston. One of the world’s great cities, she preserves the best of the old and seems to constantly remake herself. Always relevant, yet obliging, we think she’s is grander than ever. Charleston has received many accolades over the year- friendliest city, best city in the world, best city in the US, best destination from Condé Nast readers. And with companies like Volvo and Boeing bringing even more opportunities to the Charleston area, we are looking forward to a prosperous future.
        • created2016-04-04 10:21:12
        • modified2016-04-04 10:46:05
        • timezoneAmerica/New_York
        • population372000
        • uri/locations/view/15/charleston-sc-usa
        • tile_nameCharleston, SC, USA
      • Image(array)
        • 0(array)
          • id3077
          • modelArticle
          • model_id441
          • tagImage
          • nameCharleston.jpg
          • typeimage/jpg
          • size697645
          • uri/assets/3077.jpg
          • order0
          • created2016-04-05 14:30:25
          • modified2016-04-11 17:04:52
      • Brokerage(array)
        • 0(array)
          • id219
          • account_executive_id236
          • archived(false)
          • typebrokerage
          • hide_from_frontend(false)
          • agent_brokerage_data_override(false)
          • featured_development(false)
          • membership_typeBasic
          • max_properties8
          • max_homepage_featured_by_member_properties0
          • featured_properties_sort_methodmanual
          • lux_feed_modeStripeSubscription
          • max_luxury_feed_properties0
          • membership_luxury_feed_properties0
          • can_participate_in_lux_feed_while_archived(false)
          • full_training_video_access(false)
          • country_id0
          • WOEID2378319
          • timezoneUS/Eastern
          • luxury_feed_enrollment_modemanual
          • luxury_feed_include_mlsidx_minimum_price0
          • luxury_feed_include_leverage_minimum_price0
          • digital_ad_contacts
          • add_agents_to_grr_auto_recipients(true)
          • mlsidx_id
          • mlsidx_lux_autofeed(false)
          • mlsidx_lux_autofeed_minimum_price0
          • mlsidx_logo_url
          • mlsidx_disclaimer
          • namedunes properties
          • broker_of_record_name
          • short_namedunes properties
          • usernamedunesproperties
          • passwordb76f3dcf9a00c689036232225e96f54a1b389b83
          • password_reset_hash
          • monthly_invoice_amount(null)
          • monthly_invoice_start_date(null)
          • monthly_invoice_end_date(null)
          • contract_filename
          • active(true)
          • lead_in
          • short_description
          • description<p>dunes properties is the exclusive representative for Leverage Global Partners in Charleston, Mount Pleasant, Isle of Palms, West Ashley, James Island, Folly Beach, Sullivan's Island, Dewee's Island, SC, USA.</p> <p><em><strong>dunes properties</strong></em> is a boutique real estate, vacation rental, and property management company serving the Charleston area. We began with a single office and three employees in 1989. Today, we represent the Lowcountry with over 50 professional, experienced real estate agents in four full-service offices.</p> <p>Nobody knows the Charleston Coast better®</p>
          • communitiesCharleston Mount Pleasant Isle of Palms West Ashley James Island Folly Beach Sullivan's Island Dewee's Island
          • websitehttp://dunesproperties.com/
          • address214 King Street
          • address_2
          • cityCharleston
          • stateSC
          • full_stateSouth Carolina
          • countryUSA
          • marketCharleston
          • market_2
          • postal_code29401
          • phoneCell: (843) 270-1698
          • phone_2Office: (843) 886-5600
          • phone_3
          • wide_contact_image(false)
          • contact_nameRandy Walker
          • contact_profile_link
          • contact_big_profile_link
          • contact_big_profile_link_text
          • contact_titleBroker/Owner
          • contact_dre_num
          • contact_quote
          • contact_email[email protected]
          • contact_facebook
          • contact_twitter
          • contact_instagram
          • contact_pinterest
          • contact_linkedin
          • contact_youtube
          • contact_phone
          • contact_email_2
          • contact_2_facebook
          • contact_2_twitter
          • contact_2_instagram
          • contact_2_pinterest
          • contact_2_linkedin
          • contact_2_youtube
          • contact_phone_2
          • contact_website
          • contact_name_2
          • contact_profile_link_2
          • contact_big_profile_link_2
          • contact_big_profile_link_text_2
          • contact_title_2
          • contact_dre_num_2
          • contact_email_3
          • contact_name_3
          • contact_title_3
          • contact_dre_num_3
          • contact_phone_3
          • contact_3_facebook
          • contact_3_twitter
          • contact_3_instagram
          • contact_3_pinterest
          • contact_3_linkedin
          • contact_3_youtube
          • image_filename219.png
          • logo_filename219.jpg
          • contact_image_filename219.png
          • all_properties_link_image_filename219.png
          • all_properties_linkhttp://idx.diversesolutions.com/link/220431
          • video_embed_code
          • contact_video_embed_code
          • meta_titleCharleston Real Estate | Dune Properties | Leverage Global Partners
          • meta_descriptiondunes properties is the exclusive representative for Leverage Global Partners in Charleston, Mount Pleasant, Isle of Palms, West Ashley, James Island, Folly Beach, Sullivan's Island, Dewee's Island, SC, USA.
          • meta_keywordsDunes Properties, Randy Walker, Charleston Real Estate, Mount Pleasant Real Estate, Isle of Palms Real Estate, West Ashley Real Estate, James Island Real Estate, Folly Beach Real Estate, Sullivan's Island Real Estate, Dewee's Island Real Estate, South Carolina Real Estate
          • login_message_counter3
          • stats_module_1_type
          • stats_module_1_value
          • stats_module_2_type
          • stats_module_2_value
          • stats_module_3_type
          • stats_module_3_value
          • last_activity_email_sent0000-00-00 00:00:00
          • converted(true)
          • created2015-08-24 13:29:47
          • modified2016-04-08 16:34:26
          • dre_num012345
          • uri/brokerage-detail/219/dunes-properties
          • website_shortdunesproperties.com
          • name_with_locationdunes properties
          • ArticlesBrokerage(array)
            • id56
            • article_id441
            • brokerage_id219
      • Location(array)
        • 0(array)
          • id15
          • parent_id8
          • brokerage_id219
          • typeExclusive
          • archived(false)
          • use_as_topic(false)
          • nameCharleston, SC, USA
          • short_nameCharleston, SC, USA
          • group_index
          • latitude32.779144
          • longitude-79.924866
          • country_code
          • north53.700001
          • south19.700001
          • east-52.599998
          • west-146.600006
          • zoom0
          • short_descriptionCharleston thrives with a perfect blend of modern commerce and historical significance.
          • long_descriptionWhether you dream of historic charm, oceanfront majesty, secluded islands, an urban oasis, friendly suburbia, or a quiet rural getaway- Charleston and its coastal communities have a place for you. Golf, summer's Spoleto Festival which brings a world of entertainment to the city, fishing, water sports, plantation gardens, hiking trails, museums, there is truly something for everyone. Charleston is thriving with the perfect blend of modern day commerce and historical significance. Charleston is — well, Charleston. One of the world’s great cities, she preserves the best of the old and seems to constantly remake herself. Always relevant, yet obliging, we think she’s is grander than ever. Charleston has received many accolades over the year- friendliest city, best city in the world, best city in the US, best destination from Condé Nast readers. And with companies like Volvo and Boeing bringing even more opportunities to the Charleston area, we are looking forward to a prosperous future.
          • created2016-04-04 10:21:12
          • modified2016-04-04 10:46:05
          • timezoneAmerica/New_York
          • population372000
          • uri/locations/view/15/charleston-sc-usa
          • tile_nameCharleston, SC, USA
          • ArticlesLocation(array)
            • id38
            • article_id441
            • location_id15
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id24
          • nameVoice from the Street
          • created2016-02-25 11:38:06
          • modified2016-02-25 11:38:06
          • tile_nameVoice from the Street
          • ArticlesTopic(array)
            • id351
            • article_id441
            • topic_id24
    • 1(array)
      • Article(array)
        • id182
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(false)
        • large_featured(false)
        • titleGlamping: Luxury Camping for Glamorous Campers
        • authorLeverageRE
        • date2014-03-04
        • lead_inWhat do you get when you mix the outdoor experience of camping with all of the luxury amenities of a 5 star hotel? Glamping. It’s glamour meets camping.
        • body <p>This international travel trend is <strong>perfect for the adventurers among us</strong>, who still like some pampering, even in the wilderness. And given the choice, who wouldn’t want a spa-like bathroom and huge, comfy bed when you’re roughing it in the great outdoors?</p> <p><img src="/assets/503.jpg" class="pure-img"></p> <p>So how does it work? Unlike your typical camping trip where you pack up the car until it’s bursting and drive to the campsite, pitch a tent, start a fire, locate a good spot for relieving yourself and then get down with your outdoorsy self, <strong>glamping pretty much only requires a reservation and the rest is taken care of for you.</strong></p> <p>There are websites, like <a href="http://glamping.com/">Glamping.com</a>, where you can search through locations and find a venue, like <a href="http://www.elcapitancanyon.com/">California</a>, <a href="http://glamping.com/usa/glamping-montana-paws-up.html">Montana</a>, <a href="http://glamping.com/asia/glamping-maldives-huvafen-fushi.html">The Maldives</a> or <a href="http://www.amanresorts.com/amanikhas/details.aspx">India</a>. The list is long. You find your spot, book your dates and then wait for your <strong>magical vacation</strong> to begin.</p> <p><img src="/assets/504.jpg" class="pure-img"></p> <p>According to <a href="http://glamping.com/">Glamping.com</a>, "whether in a tent, yurt, airstream, hut, villa or treehouse, glamping is a way to experience the great outdoors without sacrificing luxury." Each campsite is different, but what you can expect is a <strong>luxury hotel experience, set in the middle of nature.</strong></p> <p>The tents (though sometimes they’re not so much tents as they are cabins or huts) are like something out of a fantasy, complete with lux sleeping accommodations and bathrooms like no camper has seen before. Don’t worry, your dining needs are taken care of, too, with on-site chefs. S’mores are virtually a guarantee. All that in these fabulous, lush locations surrounded by trees, desert or ocean.</p> <p><strong>The great outdoors just got a little bit more glamorous.</strong></p> <p>So how about it? Is glamping something you’d be interested in? How do you camp? Please share your ideas and leave your comments below.</p> <p><em>Photos courtesy of <a href="http://glamping.com/">Glamping.com</a></em></p>
        • vimeo_id
        • created2016-02-25 14:10:30
        • modified2016-04-05 14:41:06
        • uri/articles/view/182/glamping-luxury-camping-for-glamorous-campers
        • flattened_topics(array)
          • 0Arts & Culture
      • ParentBrokerage(array)
        • id(null)
        • account_executive_id(null)
        • archived(null)
        • type(null)
        • hide_from_frontend(null)
        • agent_brokerage_data_override(null)
        • featured_development(null)
        • membership_type(null)
        • max_properties(null)
        • max_homepage_featured_by_member_properties(null)
        • featured_properties_sort_method(null)
        • lux_feed_mode(null)
        • max_luxury_feed_properties(null)
        • membership_luxury_feed_properties(null)
        • can_participate_in_lux_feed_while_archived(null)
        • full_training_video_access(null)
        • country_id(null)
        • WOEID(null)
        • timezone(null)
        • luxury_feed_enrollment_mode(null)
        • luxury_feed_include_mlsidx_minimum_price(null)
        • luxury_feed_include_leverage_minimum_price(null)
        • digital_ad_contacts(null)
        • add_agents_to_grr_auto_recipients(null)
        • mlsidx_id(null)
        • mlsidx_lux_autofeed(null)
        • mlsidx_lux_autofeed_minimum_price(null)
        • mlsidx_logo_url(null)
        • mlsidx_disclaimer(null)
        • name(null)
        • broker_of_record_name(null)
        • short_name(null)
        • username(null)
        • password(null)
        • password_reset_hash(null)
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename(null)
        • active(null)
        • lead_in(null)
        • short_description(null)
        • description(null)
        • communities(null)
        • website(null)
        • address(null)
        • address_2(null)
        • city(null)
        • state(null)
        • full_state(null)
        • country(null)
        • market(null)
        • market_2(null)
        • postal_code(null)
        • phone(null)
        • phone_2(null)
        • phone_3(null)
        • wide_contact_image(null)
        • contact_name(null)
        • contact_profile_link(null)
        • contact_big_profile_link(null)
        • contact_big_profile_link_text(null)
        • contact_title(null)
        • contact_dre_num(null)
        • contact_quote(null)
        • contact_email(null)
        • contact_facebook(null)
        • contact_twitter(null)
        • contact_instagram(null)
        • contact_pinterest(null)
        • contact_linkedin(null)
        • contact_youtube(null)
        • contact_phone(null)
        • contact_email_2(null)
        • contact_2_facebook(null)
        • contact_2_twitter(null)
        • contact_2_instagram(null)
        • contact_2_pinterest(null)
        • contact_2_linkedin(null)
        • contact_2_youtube(null)
        • contact_phone_2(null)
        • contact_website(null)
        • contact_name_2(null)
        • contact_profile_link_2(null)
        • contact_big_profile_link_2(null)
        • contact_big_profile_link_text_2(null)
        • contact_title_2(null)
        • contact_dre_num_2(null)
        • contact_email_3(null)
        • contact_name_3(null)
        • contact_title_3(null)
        • contact_dre_num_3(null)
        • contact_phone_3(null)
        • contact_3_facebook(null)
        • contact_3_twitter(null)
        • contact_3_instagram(null)
        • contact_3_pinterest(null)
        • contact_3_linkedin(null)
        • contact_3_youtube(null)
        • image_filename(null)
        • logo_filename(null)
        • contact_image_filename(null)
        • all_properties_link_image_filename(null)
        • all_properties_link(null)
        • video_embed_code(null)
        • contact_video_embed_code(null)
        • meta_title(null)
        • meta_description(null)
        • meta_keywords(null)
        • login_message_counter(null)
        • stats_module_1_type(null)
        • stats_module_1_value(null)
        • stats_module_2_type(null)
        • stats_module_2_value(null)
        • stats_module_3_type(null)
        • stats_module_3_value(null)
        • last_activity_email_sent(null)
        • converted(null)
        • created(null)
        • modified(null)
        • dre_num(null)
        • name_with_location
      • ParentLocation(array)
        • id(null)
        • parent_id(null)
        • brokerage_id(null)
        • type(null)
        • archived(null)
        • use_as_topic(null)
        • name(null)
        • short_name(null)
        • group_index(null)
        • latitude(null)
        • longitude(null)
        • country_code(null)
        • north(null)
        • south(null)
        • east(null)
        • west(null)
        • zoom(null)
        • short_description(null)
        • long_description(null)
        • created(null)
        • modified(null)
        • timezone(null)
        • population(null)
      • Image(array)
        • 0(array)
          • id505
          • modelArticle
          • model_id182
          • tagImage
          • nameindia.png
          • typeimage/png
          • size604882
          • uri/assets/505.png
          • order0
          • created2016-02-25 14:10:30
          • modified2016-03-15 16:42:54
      • Brokerage(empty)
      • Location(empty)
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id1
          • nameArts & Culture
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:29:58
          • tile_nameArts & Culture
          • ArticlesTopic(array)
            • id204
            • article_id182
            • topic_id1
    • 2(array)
      • Article(array)
        • id448
        • modelLocation
        • model_id74
        • archived(false)
        • medium_featured(true)
        • large_featured(true)
        • titleLocation: Vail
        • authorLeverageRE
        • date2016-03-24
        • lead_inThough a year-round destination, Vail was predominately created by and for skiing. As popular as skiing is in the winter, activities such as hiking, cycling and golfing fill the void in the summer.
        • body<p>The small town offers signature, year-round events, dozens of nightlife hotspots, diverse dining, luxurious spas and hundreds of shops. Whether you're looking for outdoor adventure or some much needed R&R, there's an activity for everyone to enjoy while in Vail:</p> <p><strong>INDULGE.</strong> Nothing repairs sore ski muscles like the Hot Toddy for the Body treatment at the spa at the <a href="http://www.ritzcarlton.com/en/hotels/colorado/bachelor-gulch" target="_blank">Ritz-Carlton, Bachelor Gulch</a>, where a scrub containing sweet almond oil, jojoba beads, and shea butter scented with cinnamon and nutmeg is massaged into the skin to eliminate dry patches and relax muscles.</p> <p><img class="aligncenter wp-image-12787 pure-img" src="/assets/3115.png" /></p> <p><strong>SOCIALIZE.</strong> Stop in après ski or post-hike at <a href="http://www.larkspurvail.com/" target="_blank">Larkspur</a> in Edwards and join locals for a classic Larkburger paired with parmesan truffle fries and a local brew.</p> <p><img class="aligncenter wp-image-12788 pure-img" src="/assets/3116.png" /></p> <p><strong>CHALLENGE.</strong> The <a href="http://www.beavercreek.com/events-and-activities/world-cup.aspx" target="_blank">Birds of Prey</a> down-hill course at Beaver Creek is one of the most difficult downhill courses in the world, featuring a vertical drop of 2,484 feet loaded with steep pitches and sharp turns.</p> <p><img class="aligncenter wp-image-12786 pure-img" src="/assets/3117.png" /></p> <p><strong>SHOP</strong><strong>.</strong> The <a href="http://vailfarmersmarket.com/" target="_blank">Vail Farmer's Market</a> is the largest in Colorado. Stock up on everything from organic, locally grown produce and meats to wine from Colorado's Bookcliff Vineyards and goat cheese from Jumpin' Good Goat Dairy.</p> <p><strong>EXPLORE.</strong> Spend the day with <a href="http://www.vailvalleyanglers.com/" target="_blank">Vail Valley Anglers</a> and experience fishing for brown, rainbow, cutthroat, and brook trout paired with hiking and wildlife spotting.</p> <p><img class="aligncenter wp-image-12789 pure-img" src="/assets/3118.png" /></p> <p><strong>DINE.</strong> A Vail Village classic, <a href="https://sweetbasilvail.com/" target="_blank">Sweet Basil</a> is headed by executive chef Paul Anders, who continues to produce a creative menu of modern American cuisine.</p>
        • vimeo_id
        • created2016-04-05 14:30:41
        • modified2016-04-11 17:03:53
        • uri/articles/view/448/location-vail
        • flattened_topics(array)
          • 0Voice from the Street
          • 1Ski
      • ParentBrokerage(array)
        • id(null)
        • account_executive_id(null)
        • archived(null)
        • type(null)
        • hide_from_frontend(null)
        • agent_brokerage_data_override(null)
        • featured_development(null)
        • membership_type(null)
        • max_properties(null)
        • max_homepage_featured_by_member_properties(null)
        • featured_properties_sort_method(null)
        • lux_feed_mode(null)
        • max_luxury_feed_properties(null)
        • membership_luxury_feed_properties(null)
        • can_participate_in_lux_feed_while_archived(null)
        • full_training_video_access(null)
        • country_id(null)
        • WOEID(null)
        • timezone(null)
        • luxury_feed_enrollment_mode(null)
        • luxury_feed_include_mlsidx_minimum_price(null)
        • luxury_feed_include_leverage_minimum_price(null)
        • digital_ad_contacts(null)
        • add_agents_to_grr_auto_recipients(null)
        • mlsidx_id(null)
        • mlsidx_lux_autofeed(null)
        • mlsidx_lux_autofeed_minimum_price(null)
        • mlsidx_logo_url(null)
        • mlsidx_disclaimer(null)
        • name(null)
        • broker_of_record_name(null)
        • short_name(null)
        • username(null)
        • password(null)
        • password_reset_hash(null)
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename(null)
        • active(null)
        • lead_in(null)
        • short_description(null)
        • description(null)
        • communities(null)
        • website(null)
        • address(null)
        • address_2(null)
        • city(null)
        • state(null)
        • full_state(null)
        • country(null)
        • market(null)
        • market_2(null)
        • postal_code(null)
        • phone(null)
        • phone_2(null)
        • phone_3(null)
        • wide_contact_image(null)
        • contact_name(null)
        • contact_profile_link(null)
        • contact_big_profile_link(null)
        • contact_big_profile_link_text(null)
        • contact_title(null)
        • contact_dre_num(null)
        • contact_quote(null)
        • contact_email(null)
        • contact_facebook(null)
        • contact_twitter(null)
        • contact_instagram(null)
        • contact_pinterest(null)
        • contact_linkedin(null)
        • contact_youtube(null)
        • contact_phone(null)
        • contact_email_2(null)
        • contact_2_facebook(null)
        • contact_2_twitter(null)
        • contact_2_instagram(null)
        • contact_2_pinterest(null)
        • contact_2_linkedin(null)
        • contact_2_youtube(null)
        • contact_phone_2(null)
        • contact_website(null)
        • contact_name_2(null)
        • contact_profile_link_2(null)
        • contact_big_profile_link_2(null)
        • contact_big_profile_link_text_2(null)
        • contact_title_2(null)
        • contact_dre_num_2(null)
        • contact_email_3(null)
        • contact_name_3(null)
        • contact_title_3(null)
        • contact_dre_num_3(null)
        • contact_phone_3(null)
        • contact_3_facebook(null)
        • contact_3_twitter(null)
        • contact_3_instagram(null)
        • contact_3_pinterest(null)
        • contact_3_linkedin(null)
        • contact_3_youtube(null)
        • image_filename(null)
        • logo_filename(null)
        • contact_image_filename(null)
        • all_properties_link_image_filename(null)
        • all_properties_link(null)
        • video_embed_code(null)
        • contact_video_embed_code(null)
        • meta_title(null)
        • meta_description(null)
        • meta_keywords(null)
        • login_message_counter(null)
        • stats_module_1_type(null)
        • stats_module_1_value(null)
        • stats_module_2_type(null)
        • stats_module_2_value(null)
        • stats_module_3_type(null)
        • stats_module_3_value(null)
        • last_activity_email_sent(null)
        • converted(null)
        • created(null)
        • modified(null)
        • dre_num(null)
        • name_with_location
      • ParentLocation(array)
        • id74
        • parent_id9
        • brokerage_id6
        • typeExclusive
        • archived(false)
        • use_as_topic(false)
        • nameVail, CO, USA
        • short_nameVail, CO, USA
        • group_index
        • latitude39.640263
        • longitude-106.374191
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_description
        • long_descriptionMore information coming soon!
        • created2016-04-04 18:08:26
        • modified2016-04-04 18:08:26
        • timezoneAmerica/Denver
        • population5300
        • uri/locations/view/74/vail-co-usa
        • tile_nameVail, CO, USA
      • Image(array)
        • 0(array)
          • id3119
          • modelArticle
          • model_id448
          • tagImage
          • nameVail.jpg
          • typeimage/jpg
          • size782803
          • uri/assets/3119.jpg
          • order0
          • created2016-04-05 14:30:42
          • modified2016-04-11 17:03:53
      • Brokerage(array)
        • 0(array)
          • id6
          • account_executive_id236
          • archived(false)
          • typebrokerage
          • hide_from_frontend(false)
          • agent_brokerage_data_override(false)
          • featured_development(false)
          • membership_typePremium
          • max_properties8
          • max_homepage_featured_by_member_properties0
          • featured_properties_sort_methodmanual
          • lux_feed_modeStripeSubscription
          • max_luxury_feed_properties4
          • membership_luxury_feed_properties0
          • can_participate_in_lux_feed_while_archived(false)
          • full_training_video_access(false)
          • country_id1
          • WOEID2510611
          • timezone
          • luxury_feed_enrollment_modemanual
          • luxury_feed_include_mlsidx_minimum_price0
          • luxury_feed_include_leverage_minimum_price0
          • digital_ad_contacts
          • add_agents_to_grr_auto_recipients(true)
          • mlsidx_id
          • mlsidx_lux_autofeed(false)
          • mlsidx_lux_autofeed_minimum_price0
          • mlsidx_logo_url
          • mlsidx_disclaimer
          • nameGateway Land and Development Real Estate
          • broker_of_record_name
          • short_nameGateway Land and Development
          • usernameGatewayLand
          • passwordb17782d097733f59e365f87cad485736c79b54f3
          • password_reset_hash
          • monthly_invoice_amount500.00
          • monthly_invoice_start_date(null)
          • monthly_invoice_end_date(null)
          • contract_filename6.pdf
          • active(true)
          • lead_in
          • short_description
          • description<p>Gateway Land & Development is the exclusive representative for Leverage Global Partners in Eagle County, Colorado, USA.</p> <p>Gateway Land and Development Real Estate was established in 1993 in Edwards, Colorado and is owned and operated by Suzi Apple, a 40-year Vail Valley resident.</p> <p>Much like the area it serves, Gateway is without peer. From exceptional ski homes to spectacular ranch properties, unique commercial endeavors to new developments, no real estate opportunity is outside of Gateway’s expertise. Gateway was founded upon the conviction that relationships are to be coveted and honored.</p> <p>These same values continue to be the cornerstone of our business and are evidenced by the fact that the majority of our business continues to originate from referrals and repeat customers. Conveniently located in the heart of Vail Village and in downtown Edwards, Let Gateway Lead You Home.</p>
          • communitiesVail Valley USA United States of America Eagle United States USA United States of America Beaver Creek USA United States of America Vail USA United States of America Cordillera USA United States of America Edwards USA United States of America Colorado USA United States of America Eagle County USA United States of America Colorado
          • websitehttp://www.gatewaytovail.com/
          • address183 Gore Creek Trail
          • address_2
          • cityVail
          • stateCO
          • full_stateColorado
          • countryUSA
          • marketVail
          • market_2
          • postal_code81658
          • phone970.376.5417
          • phone_2
          • phone_3
          • wide_contact_image(false)
          • contact_nameSuzi Apple
          • contact_profile_link
          • contact_big_profile_linkhttp://www.leveragere.com/blog/suzi-apple-gateway-lands-president-loves-living-and-working-in-vail/
          • contact_big_profile_link_text
          • contact_titlePresident
          • contact_dre_num
          • contact_quote
          • contact_email[email protected]
          • contact_facebook
          • contact_twitter
          • contact_instagram
          • contact_pinterest
          • contact_linkedin
          • contact_youtube
          • contact_phone
          • contact_email_2
          • contact_2_facebook
          • contact_2_twitter
          • contact_2_instagram
          • contact_2_pinterest
          • contact_2_linkedin
          • contact_2_youtube
          • contact_phone_2
          • contact_websitehttp://www.suziapple.com
          • contact_name_2
          • contact_profile_link_2
          • contact_big_profile_link_2
          • contact_big_profile_link_text_2
          • contact_title_2
          • contact_dre_num_2
          • contact_email_3
          • contact_name_3
          • contact_title_3
          • contact_dre_num_3
          • contact_phone_3
          • contact_3_facebook
          • contact_3_twitter
          • contact_3_instagram
          • contact_3_pinterest
          • contact_3_linkedin
          • contact_3_youtube
          • image_filename6.jpg
          • logo_filename6.jpg
          • contact_image_filename6.jpg
          • all_properties_link_image_filename6.jpg
          • all_properties_linkhttp://gatewayland.com/search-properties/exclusive-to-gateway
          • video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/EAp4pAeV-qzxAOUo0.js"></script>
          • contact_video_embed_code
          • meta_titleVail Real Estate | Gateway Land and Development Real Estate | Leverage Global Partners
          • meta_descriptionGateway Land and Development Real Estate is the exclusive representative for Leverage Global Partners in Vail, Colorado, USA.
          • meta_keywordsgateway land and development real estate, gateway land, vail real estate, leverage global partners, suzi apple
          • login_message_counter0
          • stats_module_1_type
          • stats_module_1_value
          • stats_module_2_type
          • stats_module_2_value
          • stats_module_3_type
          • stats_module_3_value
          • last_activity_email_sent0000-00-00 00:00:00
          • converted(true)
          • created2013-03-18 18:33:20
          • modified2016-04-18 10:40:09
          • dre_num012345
          • uri/brokerage-detail/6/gateway-land-and-development-real-estate
          • website_shortwww.gatewaytovail.com
          • name_with_locationGateway Land and Development Real Estate
          • ArticlesBrokerage(array)
            • id55
            • article_id448
            • brokerage_id6
      • Location(array)
        • 0(array)
          • id74
          • parent_id9
          • brokerage_id6
          • typeExclusive
          • archived(false)
          • use_as_topic(false)
          • nameVail, CO, USA
          • short_nameVail, CO, USA
          • group_index
          • latitude39.640263
          • longitude-106.374191
          • country_code
          • north53.700001
          • south19.700001
          • east-52.599998
          • west-146.600006
          • zoom0
          • short_description
          • long_descriptionMore information coming soon!
          • created2016-04-04 18:08:26
          • modified2016-04-04 18:08:26
          • timezoneAmerica/Denver
          • population5300
          • uri/locations/view/74/vail-co-usa
          • tile_nameVail, CO, USA
          • ArticlesLocation(array)
            • id37
            • article_id448
            • location_id74
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id24
          • nameVoice from the Street
          • created2016-02-25 11:38:06
          • modified2016-02-25 11:38:06
          • tile_nameVoice from the Street
          • ArticlesTopic(array)
            • id349
            • article_id448
            • topic_id24
        • 1(array)
          • id9
          • nameSki
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:33:52
          • tile_nameSki
          • ArticlesTopic(array)
            • id348
            • article_id448
            • topic_id9
    • 3(array)
      • Article(array)
        • id467
        • modelLocation
        • model_id153
        • archived(false)
        • medium_featured(false)
        • large_featured(false)
        • titleLocation: Paris
        • authorLeverageRE
        • date2016-03-15
        • lead_inIts nickname is the City of Lights, but you could easily swap in love, culture, or croissants. Home to nearly one-fifth of the population of France, Paris is the fifth largest city in the European Union by population and the third most visited city in the world, annually drawing 29 million visitors.
        • body<p>The hearty tourism industry has helped make Paris the sixth richest city in the world by gross domestic product. Upcoming events include contemporary interior design fair <a href="http://www.maison-objet.com/en/paris" target="_blank">Maison &</a> <a href="http://www.maison-objet.com/en/paris">Objet</a> (January), <a href="http://tradeshows.whosnext.com/" target="_blank">Fashion Week</a> (February), and international art event <a href="http://www.artparis.fr/en" target="_blank">Art Paris</a> (March). Each year, some 900 movies are filmed at the city's iconic landmarks, among them the most visited museum in the world, the <a href="http://www.louvre.fr/" target="_blank">Louvre</a>.</p> <p>However, statistics show that 60 percent of visitors are there to shop. The city is home to some of the most prestigious fashion labels in the world, and established destinations such as <a href="http://www.louisvuitton.com/front/%23/dispatch" target="_blank">Louis Vuitton</a> and <a href="http://www.colette.fr/" target="_blank">Colette</a> have recently been joined by new flagships for <a href="http://home.emiliopucci.com/news-home" target="_blank">Emilio Pucci</a> and <a href="http://www.ralphlauren.com/home/index.jsp?ab=Geo_iUS_rUS_dUS" target="_blank">Ralph Lauren</a>. This well-heeled crowd is also well-fed, with more than 70 Michelin-starred restaurants to choose from.</p> <p>City navigation is based on a clockwise spiral of 20 arrondissements-or administrative districts- each with its own mayor. Meandering through is the River Seine, where leafy parks beckon. The most famous shopping streets and exclusive real estate lies within the Triangle d'Or-the Golden Triangle-bordered by Avenues des Champs- Élysées, George V, and Montaigne.</p> <p>Besides great culture, shopping, food, and a thriving economy, here are just a few more reasons to love the city.</p> <h2><em><strong>WHERE TO EAT:</strong></em></h2> <p><img class="aligncenter wp-image-12468 pure-img" src="/assets/3239.png" /></p> <p><img class="aligncenter size-full wp-image-12469 pure-img" src="/assets/3240.png" /></p> <p><img class="aligncenter size-full wp-image-12466 pure-img" src="/assets/3241.png" /></p> <p><img class="aligncenter size-full wp-image-12467 pure-img" src="/assets/3242.png" /></p> <h2><em><strong>WHERE TO GO:</strong></em></h2> <p><img class="aligncenter size-full wp-image-12470 pure-img" src="/assets/3243.png" /></p> <p><img class="aligncenter size-full wp-image-12472 pure-img" src="/assets/3244.png" /></p> <h2><em><strong>WHERE TO STAY:</strong></em></h2> <p><img class="aligncenter size-full wp-image-12473 pure-img" src="/assets/3245.png" /><img class="aligncenter size-full wp-image-12474 pure-img" src="/assets/3246.png" /></p> <p><img class="aligncenter size-full wp-image-12489 pure-img" src="/assets/3247.png" /></p> <p><img class="aligncenter size-full wp-image-12476 pure-img" src="/assets/3248.png" /><img class="aligncenter size-full wp-image-12477 pure-img" src="/assets/3249.png" /></p>
        • vimeo_id
        • created2016-04-05 14:32:03
        • modified2016-04-08 09:52:26
        • uri/articles/view/467/location-paris
        • flattened_topics(array)
          • 0Arts & Culture
          • 1Travel
      • ParentBrokerage(array)
        • id(null)
        • account_executive_id(null)
        • archived(null)
        • type(null)
        • hide_from_frontend(null)
        • agent_brokerage_data_override(null)
        • featured_development(null)
        • membership_type(null)
        • max_properties(null)
        • max_homepage_featured_by_member_properties(null)
        • featured_properties_sort_method(null)
        • lux_feed_mode(null)
        • max_luxury_feed_properties(null)
        • membership_luxury_feed_properties(null)
        • can_participate_in_lux_feed_while_archived(null)
        • full_training_video_access(null)
        • country_id(null)
        • WOEID(null)
        • timezone(null)
        • luxury_feed_enrollment_mode(null)
        • luxury_feed_include_mlsidx_minimum_price(null)
        • luxury_feed_include_leverage_minimum_price(null)
        • digital_ad_contacts(null)
        • add_agents_to_grr_auto_recipients(null)
        • mlsidx_id(null)
        • mlsidx_lux_autofeed(null)
        • mlsidx_lux_autofeed_minimum_price(null)
        • mlsidx_logo_url(null)
        • mlsidx_disclaimer(null)
        • name(null)
        • broker_of_record_name(null)
        • short_name(null)
        • username(null)
        • password(null)
        • password_reset_hash(null)
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename(null)
        • active(null)
        • lead_in(null)
        • short_description(null)
        • description(null)
        • communities(null)
        • website(null)
        • address(null)
        • address_2(null)
        • city(null)
        • state(null)
        • full_state(null)
        • country(null)
        • market(null)
        • market_2(null)
        • postal_code(null)
        • phone(null)
        • phone_2(null)
        • phone_3(null)
        • wide_contact_image(null)
        • contact_name(null)
        • contact_profile_link(null)
        • contact_big_profile_link(null)
        • contact_big_profile_link_text(null)
        • contact_title(null)
        • contact_dre_num(null)
        • contact_quote(null)
        • contact_email(null)
        • contact_facebook(null)
        • contact_twitter(null)
        • contact_instagram(null)
        • contact_pinterest(null)
        • contact_linkedin(null)
        • contact_youtube(null)
        • contact_phone(null)
        • contact_email_2(null)
        • contact_2_facebook(null)
        • contact_2_twitter(null)
        • contact_2_instagram(null)
        • contact_2_pinterest(null)
        • contact_2_linkedin(null)
        • contact_2_youtube(null)
        • contact_phone_2(null)
        • contact_website(null)
        • contact_name_2(null)
        • contact_profile_link_2(null)
        • contact_big_profile_link_2(null)
        • contact_big_profile_link_text_2(null)
        • contact_title_2(null)
        • contact_dre_num_2(null)
        • contact_email_3(null)
        • contact_name_3(null)
        • contact_title_3(null)
        • contact_dre_num_3(null)
        • contact_phone_3(null)
        • contact_3_facebook(null)
        • contact_3_twitter(null)
        • contact_3_instagram(null)
        • contact_3_pinterest(null)
        • contact_3_linkedin(null)
        • contact_3_youtube(null)
        • image_filename(null)
        • logo_filename(null)
        • contact_image_filename(null)
        • all_properties_link_image_filename(null)
        • all_properties_link(null)
        • video_embed_code(null)
        • contact_video_embed_code(null)
        • meta_title(null)
        • meta_description(null)
        • meta_keywords(null)
        • login_message_counter(null)
        • stats_module_1_type(null)
        • stats_module_1_value(null)
        • stats_module_2_type(null)
        • stats_module_2_value(null)
        • stats_module_3_type(null)
        • stats_module_3_value(null)
        • last_activity_email_sent(null)
        • converted(null)
        • created(null)
        • modified(null)
        • dre_num(null)
        • name_with_location
      • ParentLocation(array)
        • id153
        • parent_id4
        • brokerage_id0
        • typeOrganizational
        • archived(false)
        • use_as_topic(false)
        • nameParis
        • short_nameParis
        • group_index
        • latitude48.856613
        • longitude2.352222
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_description
        • long_description
        • created2016-04-12 12:02:02
        • modified2016-04-12 12:02:02
        • timezoneEurope/Paris
        • population12341418
        • uri/locations/view/153/paris
        • tile_nameParis
      • Image(array)
        • 0(array)
          • id3250
          • modelArticle
          • model_id467
          • tagImage
          • nameScreen-Shot-2016-03-15-at-11.08.07-AM.png
          • typeimage/png
          • size2001038
          • uri/assets/3250.png
          • order0
          • created2016-04-05 14:32:04
          • modified2016-04-08 09:52:26
      • Brokerage(empty)
      • Location(empty)
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id1
          • nameArts & Culture
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:29:58
          • tile_nameArts & Culture
          • ArticlesTopic(array)
            • id292
            • article_id467
            • topic_id1
        • 1(array)
          • id10
          • nameTravel
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:35:10
          • tile_nameTravel
          • ArticlesTopic(array)
            • id293
            • article_id467
            • topic_id10
  • sidebar_tiles(array)
    • 0(array)
      • Location(array)
        • id124
        • parent_id4
        • brokerage_id70
        • typeExclusive
        • archived(false)
        • use_as_topic(true)
        • nameAlgarve, Portugal
        • short_nameAlgarve, Portugal
        • group_index
        • latitude37.017956
        • longitude-7.930834
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_descriptionExclusive luxury properties in Quinta do Lago and Vale do Lobo
        • long_descriptionThe Golden Triangle is located in central Algarve southern Portugal. We specialize in the most exclusive properties in this area catering for northern Europeans looking for a home in the sun year round. The Algarve enjoys the most sunny days in all of Europe, has many daily flight connections to major capitals and boasts some of the most beautiful UNESCO protected beaches in Europe. Quinta do Lago and Vale do Lobo are considered the premier resorts in Portugal and have world class golf courses. Villas start at around 2million Euros. Apartments and townhouses at around 200.000 euros. The new "Non Habitual Tax Regime" has encouraged a huge amount on foreign investment. (New tax residents will be taxed 0% on their worldwide income for 10 years).
        • created2016-04-06 10:14:44
        • modified2016-04-14 10:51:54
        • timezoneEurope/Lisbon
        • population31098
        • uri/locations/view/124/algarve-portugal
        • tile_nameAlgarve, Portugal
      • 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
      • Image(array)
        • id3387
        • modelLocation
        • model_id124
        • tagImage
        • name70.jpg
        • typeimage/jpeg
        • size160038
        • uri/assets/3387.jpg
        • order0
        • created2016-04-06 10:14:28
        • modified2016-04-14 10:51:54
      • modelLocation
    • 1(array)
      • Topic(array)
        • id16
        • nameInterior Design
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:32:53
        • tile_nameInterior Design
      • Image(array)
        • id12
        • modelTopic
        • model_id16
        • tagImage
        • nameInterior Design.jpg
        • typeimage/jpeg
        • size22577089
        • uri/assets/12.jpg
        • order0
        • created2016-02-25 11:32:48
        • modified2016-02-25 11:32:53
      • modelTopic
    • 2(array)
      • Topic(array)
        • id21
        • nameSeasonal
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:33:39
        • tile_nameSeasonal
      • Image(array)
        • id15
        • modelTopic
        • model_id21
        • tagImage
        • nameSeasonal.jpg
        • typeimage/jpeg
        • size8402719
        • uri/assets/15.jpg
        • order0
        • created2016-02-25 11:33:37
        • modified2016-02-25 11:33:39
      • modelTopic
    • 3(array)
      • Topic(array)
        • id10
        • nameTravel
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:35:10
        • tile_nameTravel
      • Image(array)
        • id21
        • modelTopic
        • model_id10
        • tagImage
        • nameTravel.jpg
        • typeimage/jpeg
        • size20458912
        • uri/assets/21.jpg
        • order0
        • created2016-02-25 11:35:02
        • modified2016-02-25 11:35:10
      • modelTopic
  • recent_articles(array)
    • 0(array)
      • Article(array)
        • id477
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(false)
        • large_featured(false)
        • titlePartners Trust Sells Vince Vaughn's La Canada Home
        • authorLeverageRE
        • date2016-03-29
        • lead_inLeverage Partner Partners Trust has sold Vince Vaughn's La Cañada home for $4.8 million. Christine Navarro of Partners Trust handled the transaction.
        • body<div> <p>As the <a href="http://www.latimes.com/business/realestate/hot-property/la-fi-hotprop-vince-vaughn-20160309-story.html" target="_blank">L.A. Times reported</a>, he purchased the home three years ago. The neoclassical home, built in 2000, has a timeless appearance with a grand columned porch, lush landscaping, and exquisitely crafted traditional touches.</p> <p><img class="aligncenter size-full wp-image-13005 pure-img" src="/assets/3291.jpg" /></p> <p>The five-bedroom home sits on approximately 3/4 of an acre. A gracious two-story entry with sweeping staircase leads to the living room and formal dining room which feature large windows and finely detailed moldings.</p> <p>The gourmet kitchen has a butler's pantry and adjoins the light filled family room. The family room opens out to a covered brick patio, salt water pool, lawn and sport court.</p> <p><img class="aligncenter size-full wp-image-13006 pure-img" src="/assets/3292.jpg" /></p> <p>A rich paneled library, guest room or office, laundry room and powder room complete the first floor. The master suite features a large closet, spectacular bath with soaking tub, steam shower, and views of the yard. This home also has an attached three car garage with plenty of storage.</p> </div> <h6><em>Article originally appeared on <a href="http://www.thepartnerstrust.com/blog/2016/03/partners-trust-sells-vince-vaughns-la-canada-home/" target="_blank">Partners Trust Blog</a></em></h6>
        • vimeo_id
        • created2016-04-05 14:34:56
        • modified2016-04-08 09:57:59
        • uri/articles/view/477/partners-trust-sells-vince-vaughn-s-la-canada-home
      • Image(array)
        • 0(array)
          • id3293
          • modelArticle
          • model_id477
          • tagImage
          • nameScreen-Shot-2016-03-29-at-2.49.30-PM.png
          • typeimage/png
          • size3168691
          • uri/assets/3293.png
          • order0
          • created2016-04-05 14:34:56
          • modified2016-04-08 09:57:59
    • 1(array)
      • Article(array)
        • id487
        • modelLocation
        • model_id137
        • archived(false)
        • medium_featured(true)
        • large_featured(false)
        • titleLocation: Kiawah Island
        • authorLeverageRE
        • date2016-03-30
        • lead_inA resort community and full-time resident population, Kiawah Island is known for its abundance of wildlife. Explore Mother Nature's beauty on land or in the water, and experience the aquatic life and vegetation that surround this 10-mile stretch of beach.
        • body<p>Experience Kiawah's natural habitat by taking a morning bike ride on one of the island's 30 miles of paved trails or 10 miles of flat beach. <strong>Surfscooter</strong> will deliver your bicycle to your front doorstep, or you might choose from the variety of bike trailers, chariots, and tag-a-longs if you want to adventure around Kiawah with your family in tow.</p> <p><img class="aligncenter wp-image-13087 pure-img" src="/assets/3346.jpg" /></p> <div> <div> <div> <div> <div> <div> <div> <div> <p>Be sure to stop at the nearby <strong>Johns Island Farmers Market</strong> on Saturday morning. In addition to locally sourced produce, the market also offers sustainable educational classes, demonstrations, and interactive opportunities to learn about making sustainable life choices.</p> <p>Endorphin-fueled vacationers will find no lack of sporting activities around the island. Go for a run, kayak in the tidal pools around the island, or enjoy a game of tennis or a round of golf at the Kiawah Island Golf Club. <strong>The Roy Barth Tennis Center </strong>was ranked number three in the United States by Tennis magazine.</p> <p><img class="aligncenter wp-image-13088 pure-img" src="/assets/3347.jpg" /></p> <p>After a full day of activities, visit the <strong>Sushi Lounge at the Atlantic Room</strong> in the Ocean Course Clubhouse to enjoy the freshest locally sourced produce and seafood in the Low country, as well as small plates, cocktails, and fine wines.</p> <p><img class="aligncenter wp-image-13070 pure-img" src="/assets/3348.jpg" /></p> </div> </div> <h6><em>Photos courtesy of: <a href="http://www.kiawahresort.com/blog/kiawah-golf/" target="_blank">Kiawah Island</a>, <a href="http://www.kiawahresort.com/blog/kiawah-island/2014/06/24/bike-around-kiawah-island/" target="_blank">Kiawah Resort</a></em></h6> </div> </div> </div> </div> </div> </div>
        • vimeo_id
        • created2016-04-05 14:35:21
        • modified2016-04-11 17:08:39
        • uri/articles/view/487/location-kiawah-island
      • Image(array)
        • 0(array)
          • id3349
          • modelArticle
          • model_id487
          • tagImage
          • nameKiawah-Island.jpg
          • typeimage/jpg
          • size904980
          • uri/assets/3349.jpg
          • order0
          • created2016-04-05 14:35:21
          • modified2016-04-11 17:08:39
  • article_model_overrideLocation
  • article(array)
    • Article(array)
      • id439
      • modelLocation
      • model_id105
      • archived(false)
      • medium_featured(true)
      • large_featured(false)
      • titleLocation: Washington D.C.
      • authorLeverageRE
      • date2016-03-28
      • lead_inWith nearly 30 percent of D.C.'s population employed by the federal government and an incredibly strong tourism industry, the District seems almost immune to economic downturn. Even during the height of the global recession in 2008–2009, D.C.'s top-notch hotels remained sold out, its exclusive restaurants and bars fi led to capacity, and the city's landmarks grew busier than ever.
      • body<p>The overall cityscape of today's Washington, D.C., is largely the result of French master urban planner Pierre Charles L'Enfant. The district is divided into four quadrants, stemming from a central point: the U.S.  Capitol Building. Within these dissimilar regions of NW, NE, SW, and SE lie varying combinations of grand Victorian homes, history-steeped single-family homes in varying gothic, Georgian, neoclassical, and contemporary architectural styles; cherry-blossom-lined streets separated by bustling squares and circles; and hodgepodges of low-rise buildings (mandated by law to be no taller than 20 feet plus the width of the bordering street).</p> <p><img class="aligncenter wp-image-12922 pure-img" src="/assets/3061.png" /></p> <p>Every year D.C. embraces its evolution as a one-of-a-kind metropolis, incorporating modernity while successfully keeping his- tory in style. Outside the very public and controversial world of donkeys and elephants, here are a few reasons to fall in love with America's capital:</p> <p><a href="http://www.pointofviewdc.com/" target="_blank"><strong>P.</strong><strong>O</strong><strong>.</strong><strong>V</strong><strong>.</strong></a></p> <p>This rooftop bar at the W Washington D.C. offers a bird's-eye-view of the White House. Artisanal cocktails and tapas make it all the more compelling.</p> <p><img class="aligncenter wp-image-12916 pure-img" src="/assets/3062.png" /></p> <p><a href="http://www.si.edu/Museums" target="_blank"><strong>SMITHSONIAN MUSEUMS</strong></a></p> <p>The Smithsonian Institution operates 17 museums and galleries in the D.C. Metro area, all of which offer entrance free of charge.</p> <p><img class="aligncenter wp-image-12917 pure-img" src="/assets/3063.png" /></p> <p><a href="http://benschilibowl.com/" target="_blank"><strong>BEN</strong><strong>'</strong><strong>S</strong> <strong>CHILI BOWL</strong></a></p> <p>This hole-in-the-wall is a D.C. legend. Regulars line up for the Original Chili Half-Smoke, a pork/beef sausage with mustard, onions, and spicy chili sauce.</p> <p><img class="aligncenter wp-image-12919 pure-img" src="/assets/3064.png" /></p> <p><a href="http://nationalzoo.si.edu/" target="_blank"><strong>N</strong><strong>A</strong><strong>TION</strong><strong>AL</strong><strong> ZOO</strong></a></p> <p>This 163-acre zoological park houses nearly 400 different species. The most popular: the Giant Pandas, who recently welcomed baby Bao Bao.</p> <p><img class="aligncenter wp-image-12918 pure-img" src="/assets/3065.png" /></p> <p><strong><a href="http://www.mandarinoriental.com/washington/" target="_blank">MANDARIN ORIENTAL, WASHINGTON D.C.</a></strong></p> <p>This ultra-luxurious 400-room and suite hotel marries D.C. decadence with Asian sophistication.</p> <p><img class="aligncenter wp-image-12920 pure-img" src="/assets/3066.png" /></p> <p> </p> <p></p>
      • vimeo_id
      • created2016-04-05 14:30:22
      • modified2016-04-11 17:32:14
      • uri/articles/view/439/location-washington-d-c
      • flattened_topics(array)
        • 0Voice from the Street
        • 1Arts & Culture
    • ParentBrokerage(array)
      • id(null)
      • account_executive_id(null)
      • archived(null)
      • type(null)
      • hide_from_frontend(null)
      • agent_brokerage_data_override(null)
      • featured_development(null)
      • membership_type(null)
      • max_properties(null)
      • max_homepage_featured_by_member_properties(null)
      • featured_properties_sort_method(null)
      • lux_feed_mode(null)
      • max_luxury_feed_properties(null)
      • membership_luxury_feed_properties(null)
      • can_participate_in_lux_feed_while_archived(null)
      • full_training_video_access(null)
      • country_id(null)
      • WOEID(null)
      • timezone(null)
      • luxury_feed_enrollment_mode(null)
      • luxury_feed_include_mlsidx_minimum_price(null)
      • luxury_feed_include_leverage_minimum_price(null)
      • digital_ad_contacts(null)
      • add_agents_to_grr_auto_recipients(null)
      • mlsidx_id(null)
      • mlsidx_lux_autofeed(null)
      • mlsidx_lux_autofeed_minimum_price(null)
      • mlsidx_logo_url(null)
      • mlsidx_disclaimer(null)
      • name(null)
      • broker_of_record_name(null)
      • short_name(null)
      • username(null)
      • password(null)
      • password_reset_hash(null)
      • monthly_invoice_amount(null)
      • monthly_invoice_start_date(null)
      • monthly_invoice_end_date(null)
      • contract_filename(null)
      • active(null)
      • lead_in(null)
      • short_description(null)
      • description(null)
      • communities(null)
      • website(null)
      • address(null)
      • address_2(null)
      • city(null)
      • state(null)
      • full_state(null)
      • country(null)
      • market(null)
      • market_2(null)
      • postal_code(null)
      • phone(null)
      • phone_2(null)
      • phone_3(null)
      • wide_contact_image(null)
      • contact_name(null)
      • contact_profile_link(null)
      • contact_big_profile_link(null)
      • contact_big_profile_link_text(null)
      • contact_title(null)
      • contact_dre_num(null)
      • contact_quote(null)
      • contact_email(null)
      • contact_facebook(null)
      • contact_twitter(null)
      • contact_instagram(null)
      • contact_pinterest(null)
      • contact_linkedin(null)
      • contact_youtube(null)
      • contact_phone(null)
      • contact_email_2(null)
      • contact_2_facebook(null)
      • contact_2_twitter(null)
      • contact_2_instagram(null)
      • contact_2_pinterest(null)
      • contact_2_linkedin(null)
      • contact_2_youtube(null)
      • contact_phone_2(null)
      • contact_website(null)
      • contact_name_2(null)
      • contact_profile_link_2(null)
      • contact_big_profile_link_2(null)
      • contact_big_profile_link_text_2(null)
      • contact_title_2(null)
      • contact_dre_num_2(null)
      • contact_email_3(null)
      • contact_name_3(null)
      • contact_title_3(null)
      • contact_dre_num_3(null)
      • contact_phone_3(null)
      • contact_3_facebook(null)
      • contact_3_twitter(null)
      • contact_3_instagram(null)
      • contact_3_pinterest(null)
      • contact_3_linkedin(null)
      • contact_3_youtube(null)
      • image_filename(null)
      • logo_filename(null)
      • contact_image_filename(null)
      • all_properties_link_image_filename(null)
      • all_properties_link(null)
      • video_embed_code(null)
      • contact_video_embed_code(null)
      • meta_title(null)
      • meta_description(null)
      • meta_keywords(null)
      • login_message_counter(null)
      • stats_module_1_type(null)
      • stats_module_1_value(null)
      • stats_module_2_type(null)
      • stats_module_2_value(null)
      • stats_module_3_type(null)
      • stats_module_3_value(null)
      • last_activity_email_sent(null)
      • converted(null)
      • created(null)
      • modified(null)
      • dre_num(null)
      • name_with_location
    • ParentLocation(array)
      • id105
      • parent_id7
      • brokerage_id80
      • typeExclusive
      • archived(false)
      • use_as_topic(false)
      • nameWashington, D.C, USA
      • short_nameWashington, D.C, USA
      • group_index
      • latitude38.907192
      • longitude-77.036873
      • country_code
      • north53.700001
      • south19.700001
      • east-52.599998
      • west-146.600006
      • zoom0
      • short_description
      • long_descriptionMore information coming soon!
      • created2016-04-05 13:36:56
      • modified2016-04-14 10:44:02
      • timezoneAmerica/New_York
      • population660000
      • uri/locations/view/105/washington-d-c-usa
      • tile_nameWashington, D.C, USA
    • Image(array)
      • 0(array)
        • id3067
        • modelArticle
        • model_id439
        • tagImage
        • nameScreen-Shot-2016-03-28-at-7.44.50-PM.png
        • typeimage/png
        • size2392702
        • uri/assets/3067.png
        • order0
        • created2016-04-05 14:30:23
        • modified2016-04-11 17:32:14
    • Brokerage(array)
      • 0(array)
        • id81
        • account_executive_id235
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties8
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties0
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id1
        • WOEID2379523
        • timezoneUS/Eastern
        • luxury_feed_enrollment_modemanual
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id
        • mlsidx_lux_autofeed(false)
        • mlsidx_lux_autofeed_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • nameEvers & Co. Real Estate
        • broker_of_record_name
        • short_nameEvers & Co. Real Estate
        • usernameEversCoRealEstateCC
        • password440e06f17502b0b97a9e4aa2f069e898691a3b4c
        • password_reset_hash
        • monthly_invoice_amount0.00
        • monthly_invoice_start_date0000-00-00
        • monthly_invoice_end_date0000-00-00
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>Evers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Chevy Chase, MD, and <a href="../../../brokerage-detail/80/Evers-&-Co.-Real-Estate">Washington, D.C</a>, USA.,</p> <p>We are 100+ salespeople who offer our clients a level of service that is unmatched in today’s real estate marketplace, and we deliver this extraordinary service with courtesy and integrity to everyone involved in each transaction.</p> <p>We are enthusiastic about the neighborhoods where we live and work, from Chevy Chase to Capitol Hill, from Dupont Circle to Arlington, and everywhere in between. The highly visible storefront offices of Evers & Co. in Downtown Washington, Friendship Heights in Upper Northwest, downtown Bethesda-Chevy Chase and in Bluemont in the Virginia Wine Country are bustling with the entrepreneurial energy of agents who have in-depth knowledge of local history, architecture and construction techniques as well as expert skills in marketing and negotiating, all of which adds value to our service and your investment.</p> <p>This spectrum of knowledge and our commitment to serving our clientele and fellow real estate associates with the highest level of integrity has made us the premier independent brokerage in the Metropolitan Washington area.</p> <p>Donna Evers and the agents of Evers & Co. invite you to join our growing community of buyers and sellers, who have been the source of 90% of our business for the past thirty years.</p>
        • communitiesBethesda Chevy Chase Village Town of Chevy Chase Somerset Edgemoor Kenwood Kenwood Park Burning Tree Avenel Silver Spring
        • websitehttp://www.eversco.com/
        • address7032 Wisconsin Avenue
        • address_2
        • cityChevy Chase
        • stateMD
        • full_stateMaryland
        • countryUSA
        • marketChevy Chase
        • market_2
        • postal_code20815
        • phoneOffice: (301) 656-1800
        • phone_2Cell: (202) 255-5009
        • phone_3
        • wide_contact_image(false)
        • contact_nameDonna Evers
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titlePresident & Founder
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename81.jpg
        • logo_filename81.jpg
        • contact_image_filename81.jpg
        • all_properties_link_image_filename81.JPG
        • all_properties_linkhttp://eversco.idxre.com/featured/40484?CFID=10711248&CFTOKEN=99152164
        • video_embed_code
        • contact_video_embed_code
        • meta_titleChevy Chase Real Estate | Evers & Co. Real Estate | Leverage Global Partners
        • meta_descriptionEvers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Bethesda, Chevy Chase Village, Town of Chevy Chase, Somerset, Edgemoor, Kenwood, Kenwood Park, Burning Tree, Avenel, and Silver Spring, MD.
        • meta_keywordsChevy Chase Real Estate, Evers & Co. Real Estate, Leverage Global Partners, Bethesda real estate, Chevy Chase Village real estate, Town of Chevy Chase real estate, Somerset real estate, Edgemoor real estate, Kenwood real estate, Kenwood Park real estate, Burning Tree real estate, Avenel real estate, and Silver Spring real estate, MD.
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2014-01-10 16:43:02
        • modified2016-04-08 16:34:01
        • dre_num012345
        • uri/brokerage-detail/81/evers-co-real-estate
        • website_shortwww.eversco.com
        • name_with_locationEvers & Co. Real Estate
        • ArticlesBrokerage(array)
          • id74
          • article_id439
          • brokerage_id81
    • Location(array)
      • 0(array)
        • id105
        • parent_id7
        • brokerage_id80
        • typeExclusive
        • archived(false)
        • use_as_topic(false)
        • nameWashington, D.C, USA
        • short_nameWashington, D.C, USA
        • group_index
        • latitude38.907192
        • longitude-77.036873
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_description
        • long_descriptionMore information coming soon!
        • created2016-04-05 13:36:56
        • modified2016-04-14 10:44:02
        • timezoneAmerica/New_York
        • population660000
        • uri/locations/view/105/washington-d-c-usa
        • tile_nameWashington, D.C, USA
        • ArticlesLocation(array)
          • id50
          • article_id439
          • location_id105
    • Property(empty)
    • Topic(array)
      • 0(array)
        • id24
        • nameVoice from the Street
        • created2016-02-25 11:38:06
        • modified2016-02-25 11:38:06
        • tile_nameVoice from the Street
        • ArticlesTopic(array)
          • id417
          • article_id439
          • topic_id24
      • 1(array)
        • id1
        • nameArts & Culture
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:29:58
        • tile_nameArts & Culture
        • ArticlesTopic(array)
          • id416
          • article_id439
          • topic_id1
  • membership_subscription_temp_allowed_login(null)
  • newsletter_member_types(array)
    • Leverage Member: AgentLeverage Member: Agent
    • Leverage Member: Broker or ManagementLeverage Member: Broker or Management
    • Non-MemberNon-Member
  • $request->data(empty)
  • $this->validationErrors(array)
    • Subscription(empty)
    • Article(empty)
    • Brokerage(empty)
    • Location(empty)
    • Property(empty)
    • User(empty)
    • PropertyFeature(empty)
    • SecondaryPropertyCategory(empty)
    • Topic(empty)
    • ParentBrokerage(empty)
    • ParentLocation(empty)
    • Image(empty)
    • ArticlesBrokerage(empty)
    • ArticlesLocation(empty)
    • ArticlesProperty(empty)
    • ArticlesTopic(empty)
    • PrimaryPropertyCategory(empty)
    • StripeSubscription(empty)
    • GlobalReachReport(empty)
    • UsersProperty(empty)
    • PropertiesSecondaryPropertyCategory(empty)
    • PropertiesPropertyFeature(empty)
    • PropertiesTopic(empty)
  • Loaded Helpers(array)
    • 0Permission
    • 1Number
    • 2SimpleGraph
    • 3DebugTimer
    • 4Toolbar
    • 5Session
    • 6Text
    • 7Flash
    • 8HtmlToolbar
    • 9Html
    • 10Form

  ====
• Environment
  +

  App Constants

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

  CakePHP Constants

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

  PHP Environment

  Environment Variable	Value
  Php Version	7.4.33
  User	leveragere
  Home	/var/www/vhosts/leveragere.com
  Script Name	/index.php
  Request Uri	/articles/view/439/location-washington-d-c
  Query String
  Request Method	GET
  Server Protocol	HTTP/1.1
  Gateway Interface	CGI/1.1
  Redirect Url	/articles/view/439/location-washington-d-c
  Remote Port	18847
  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	a09e01bc6c394603-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	aio_DlLEEfcqtnCHo5UuugAAAAk
  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	aio_DlLEEfcqtnCHo5UuugAAAAk
  Fcgi Role	RESPONDER
  Php Self	/index.php
  Request Time Float	1781153550.8077
  Request Time	1781153550

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

  ====