Location: Manhattan

LeverageRE

Made up of five boroughs, New York City has a population of 8.1 million people, making it the largest city in the United States. Often called "the city," Manhattan is the most densely populated borough, and on business days, the population reaches a whopping 5.28 million people. It is home to the financial capital of the world with the NASDAQ, New York Stock Exchange and United Nations.

A major benefit to living in "the city" is having access to virtually everything at any hour of the day. With attractions from dining and drinking to theater shows and live music, Manhattan is at the center of the action in New York City.

WALK.  Madison Square Park, landscaped by Ignatz Pilat, a disciple of William Grant and Frederick Law Olmstead, offers people-watching benches, shady strolls through verdant plantings, a dog run, and elegant public monuments.

DRESS.  Ann Taylor, Armani Exchange, Kate Spade, Club Monaco, and many more are only steps away.

EAT.  The Flatiron District is the epicenter of Danny Meyer's restaurant empire, with one of his eateries just a short walk in almost any direction: Maialino (Italian), Blue Smoke (BBQ and jazz), Gramercy Tavern (classic American), Union Square Café (American-Italian), or Shake Shack (burger-and- shake stand).

INDULGE.  Eisenberg's Sandwich Shop has been "raising New York's cholesterol since 1929" with its old-fashioned tuna melts, diner breakfasts, and Jewish classics like pastrami Rueben’s and tongue-on-rye.

NEST.  You're a stone's throw from Restoration Hardware, BoConcept, ABC Carpet & Home, Lillian August, and other design shrines.

Share

• Topics:
• Voice from the Street
• Urban Life

• Location:
• Manhattan

Recent Articles

Fashion Trends: Spring 2016

Ladies! It's time to do some spring-cleaning to make room for some of this year's most...

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] => 446
            [model] => Location
            [model_id] => 151
            [archived] => 
            [medium_featured] => 
            [large_featured] => 1
            [title] => Location: Manhattan
            [author] => LeverageRE
            [date] => 2016-03-24
            [lead_in] => Made up of five boroughs, New York City has a population of 8.1 million people, making it the largest city in the United States. Often called "the city," Manhattan is the most densely populated borough, and on business days, the population reaches a whopping 5.28 million people. It is home to the financial capital of the world with the NASDAQ, New York Stock Exchange and United Nations.
            [body] => 
A major benefit to living in "the city" is having access to virtually everything at any hour of the day. With attractions from dining and drinking to theater shows and live music, Manhattan is at the center of the action in New York City.

WALK.  Madison Square Park, landscaped by Ignatz Pilat, a disciple of William Grant and Frederick Law Olmstead, offers people-watching benches, shady strolls through verdant plantings, a dog run, and elegant public monuments.



DRESS.  Ann Taylor, Armani Exchange, Kate Spade, Club Monaco, and many more are only steps away.

EAT.  The Flatiron District is the epicenter of Danny Meyer's restaurant empire, with one of his eateries just a short walk in almost any direction: Maialino (Italian), Blue Smoke (BBQ and jazz), Gramercy Tavern (classic American), Union Square Café (American-Italian), or Shake Shack (burger-and- shake stand).



INDULGE.  Eisenberg's Sandwich Shop has been "raising New York's cholesterol since 1929" with its old-fashioned tuna melts, diner breakfasts, and Jewish classics like pastrami Rueben’s and tongue-on-rye.

NEST.  You're a stone's throw from Restoration Hardware, BoConcept, ABC Carpet & Home, Lillian August, and other design shrines.



            [vimeo_id] => 
            [created] => 2016-04-05 14:30:39
            [modified] => 2016-04-14 10:47:35
            [uri] => /articles/view/446/location-manhattan
            [flattened_topics] => Array
                (
                    [0] => Voice from the Street
                    [1] => Urban Life
                )

        )

    [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] => 151
            [parent_id] => 7
            [brokerage_id] => 0
            [type] => Organizational
            [archived] => 
            [use_as_topic] => 1
            [name] => Manhattan
            [short_name] => Manhattan
            [group_index] => 
            [latitude] => 40.783058
            [longitude] => -73.971252
            [country_code] => 
            [north] => 53.700001
            [south] => 19.700001
            [east] => -52.599998
            [west] => -146.600006
            [zoom] => 0
            [short_description] => 
            [long_description] => 
            [created] => 2016-04-12 11:14:03
            [modified] => 2016-04-14 10:47:50
            [timezone] => America/New_York
            [population] => 1644518
            [uri] => /locations/view/151/manhattan
            [tile_name] => Manhattan
        )

    [Image] => Array
        (
            [0] => Array
                (
                    [id] => 3108
                    [model] => Article
                    [model_id] => 446
                    [tag] => Image
                    [name] => NYC-2.jpg
                    [type] => image/jpg
                    [size] => 690658
                    [uri] => /assets/3108.jpg
                    [order] => 0
                    [created] => 2016-04-05 14:30:40
                    [modified] => 2016-04-14 10:47:35
                )

        )

    [Brokerage] => Array
        (
            [0] => Array
                (
                    [id] => 16
                    [account_executive_id] => 235
                    [archived] => 
                    [type] => brokerage
                    [hide_from_frontend] => 
                    [agent_brokerage_data_override] => 
                    [featured_development] => 
                    [membership_type] => Premium
                    [max_properties] => 20
                    [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] => 12589342
                    [timezone] => 
                    [luxury_feed_enrollment_mode] => manual
                    [luxury_feed_include_mlsidx_minimum_price] => 0
                    [luxury_feed_include_leverage_minimum_price] => 0
                    [digital_ad_contacts] => 
                    [add_agents_to_grr_auto_recipients] => 1
                    [mlsidx_id] => 
                    [mlsidx_lux_autofeed] => 
                    [mlsidx_lux_autofeed_minimum_price] => 0
                    [mlsidx_logo_url] => 
                    [mlsidx_disclaimer] => 
                    [name] => CORE
                    [broker_of_record_name] => 
                    [short_name] => CORE
                    [username] => CORENYC
                    [password] => 6bbc31e8f00594b7e3433f0a9c0cd7334bff73ae
                    [password_reset_hash] => 
                    [monthly_invoice_amount] => 
                    [monthly_invoice_start_date] => 0000-00-00
                    [monthly_invoice_end_date] => 0000-00-00
                    [contract_filename] => 
                    [active] => 1
                    [lead_in] => 
                    [short_description] => 
                    [description] => 
CORE is the exclusive representative for Leverage Global Partners in New York City, New York, USA.

CORE is the leading, full-service, boutique real estate brokerage specializing in the marketing of premiere residential properties. Headquartered in New York City, CORE was founded by CEO Shaun Osher and Jack Cayre, who envisioned a dynamic boutique brokerage based on integrity, informed by expertise and driven by innovation.

CORE offers comprehensive real estate solutions for buyers, sellers, landlords, investors and developers. The firm is powered by an integrated team of accomplished professionals with extensive expertise in all aspects of real estate transactions.

Thanks to a unique marketing approach, CORE ensures that its clients earn the highest market-driven prices. Our agents educate and shepherd buyers, sellers and landlords through the sales or leasing process. And we partner closely with developers, from the earliest stages of a project through closing; partnerships, which boast a proven, profitable track record. Within the past 8 years, CORE has marketed more than 30 new development properties and is the #1 brokerage in its class.

                    [communities] => Manhattan
Chelsea
New York City
Tribeca
Midtown
                    [website] => http://corenyc.com/
                    [address] => 104 Fifth Avenue
                    [address_2] => 
                    [city] => New York
                    [state] => NY
                    [full_state] => New York
                    [country] => USA
                    [market] => New York
                    [market_2] => 
                    [postal_code] => 10011
                    [phone] => (212) 726-0778
                    [phone_2] => 
                    [phone_3] => 
                    [wide_contact_image] => 
                    [contact_name] => Shaun Osher
                    [contact_profile_link] => 
                    [contact_big_profile_link] => http://www.leveragere.com/blog/meet-shaun-osher-founder-and-ceo-of-core/
                    [contact_big_profile_link_text] => 
                    [contact_title] => Founder and CEO
                    [contact_dre_num] => 
                    [contact_quote] => I invite you to contact me personally about New York City real estate.
                    [contact_email] => [email protected]
                    [contact_facebook] => 
                    [contact_twitter] => 
                    [contact_instagram] => 
                    [contact_pinterest] => 
                    [contact_linkedin] => 
                    [contact_youtube] => 
                    [contact_phone] => 
                    [contact_email_2] => 
                    [contact_2_facebook] => 
                    [contact_2_twitter] => 
                    [contact_2_instagram] => 
                    [contact_2_pinterest] => 
                    [contact_2_linkedin] => 
                    [contact_2_youtube] => 
                    [contact_phone_2] => 
                    [contact_website] => 
                    [contact_name_2] => 
                    [contact_profile_link_2] => 
                    [contact_big_profile_link_2] => 
                    [contact_big_profile_link_text_2] => 
                    [contact_title_2] => 
                    [contact_dre_num_2] => 
                    [contact_email_3] => 
                    [contact_name_3] => 
                    [contact_title_3] => 
                    [contact_dre_num_3] => 
                    [contact_phone_3] => 
                    [contact_3_facebook] => 
                    [contact_3_twitter] => 
                    [contact_3_instagram] => 
                    [contact_3_pinterest] => 
                    [contact_3_linkedin] => 
                    [contact_3_youtube] => 
                    [image_filename] => 16.jpg
                    [logo_filename] => 16.jpg
                    [contact_image_filename] => 16.jpg
                    [all_properties_link_image_filename] => 16.jpg
                    [all_properties_link] => http://corenyc.com/listings
                    [video_embed_code] => 
                    [contact_video_embed_code] => 
                    [meta_title] => New York City Real Estate | CORE | Leverage Global Partners
                    [meta_description] => CORE is Leverage Global Partners' exclusive representative in New York City, NY, USA.
                    [meta_keywords] => new york city real estate, manhattan real estate, shaun osher, CORE, leverage global partners
                    [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] => 2013-04-01 15:35:47
                    [modified] => 2019-10-29 20:06:57
                    [dre_num] => 012345
                    [uri] => /brokerage-detail/16/core
                    [website_short] => corenyc.com
                    [name_with_location] => CORE
                    [ArticlesBrokerage] => Array
                        (
                            [id] => 80
                            [article_id] => 446
                            [brokerage_id] => 16
                        )

                )

        )

    [Location] => Array
        (
            [0] => Array
                (
                    [id] => 7
                    [parent_id] => 1
                    [brokerage_id] => 0
                    [type] => Region
                    [archived] => 
                    [use_as_topic] => 
                    [name] => Northeast
                    [short_name] => Northeast
                    [group_index] => 120
                    [latitude] => 42.617790
                    [longitude] => -73.300781
                    [country_code] => 
                    [north] => 48.111145
                    [south] => 38.251553
                    [east] => -64.992577
                    [west] => -81.473045
                    [zoom] => 0
                    [short_description] => 
                    [long_description] => 
                    [created] => 2016-03-30 11:09:47
                    [modified] => 2016-03-30 11:09:47
                    [timezone] => America/New_York
                    [population] => 0
                    [uri] => /locations/view/7/northeast
                    [tile_name] => Northeast
                    [ArticlesLocation] => Array
                        (
                            [id] => 56
                            [article_id] => 446
                            [location_id] => 7
                        )

                )

        )

    [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] => 431
                            [article_id] => 446
                            [topic_id] => 24
                        )

                )

            [1] => Array
                (
                    [id] => 5
                    [name] => Urban Life
                    [created] => 2016-02-25 11:25:00
                    [modified] => 2016-02-25 11:36:03
                    [tile_name] => Urban Life
                    [ArticlesTopic] => Array
                        (
                            [id] => 430
                            [article_id] => 446
                            [topic_id] => 5
                        )

                )

        )

)

• 
• History
  +

  Request History

  4 previous requests available

  • Restore to current request
  • brokerage-detail/116/ascent-real-estate
  • brokerage-detail/197/red-lady-realty
  • brokerage-detail/9/housing-japan
  • brokerage-detail/120/nectar-real-estate

  ====
• Session
  +

  Session

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

  ====
• Request
  +

  Request

  Cake Params

  • plugin(null)
  • controllerarticles
  • actionview
  • named(empty)
  • pass(array)
    • 0446
    • 1location-manhattan
  • 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: 17 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` = 446 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` = (446) 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` = 446 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` = 446 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` = 446 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` = 446 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 (486, 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` = 446 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` = (446) 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` = 446 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` = 446 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` = 446 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` = 446 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, 5)	20	20	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 (414, 323, 259, 439, 440, 441, 442, 445, 445, 446, 446, 447, 448, 451, 464, 464, 466, 478, 479, 479) AND `Article`.`id` != 446 AND `Article`.`model` != 'News' AND `Article`.`archived` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	2	maybe slow
  SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (441, 442, 259, 466) 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, 442, 259, 466) AND `ArticlesBrokerage`.`brokerage_id` = `Brokerage`.`id`)	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`, `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, 442, 259, 466) 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, 442, 259, 466) 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, 442, 259, 466) AND `ArticlesTopic`.`topic_id` = `Topic`.`id`)	7	7	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 (3740, 3734, 3754, 3718) ORDER BY `Image`.`order` ASC	45	45	1
  SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (3740, 3734, 3754, 3718) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	2	2	0
  SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (3740, 3734, 3754, 3718) 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 (3740, 3734, 3754, 3718) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	4	4	0
  SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (3740, 3734, 3754, 3718) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	1	1	1

  6 duplicate queries run.

  Query Explain:

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

  ====
• Timer
  +

  Memory

  Peak Memory Use 11.56 MB

  Message	Memory use
  Component initialization	2.91 MB
  Controller action start	3.84 MB
  Controller render start	6.68 MB
  View render complete	7.25 MB

  Timers

  Total Request Time: 237 (ms)

  Message	Time in ms	Graph
  Core Processing (Derived from $_SERVER["REQUEST_TIME"])	25.72
  Event: Controller.initialize	3.77
  Event: Controller.startup	1.09
  Controller action	47.66
  Event: Controller.beforeRender	45.16
  » Processing toolbar data	45.06
  Rendering View	88.11
  » Event: View.beforeRender	0.28
  » Rendering APP/View/Articles/view.ctp	3.82
  » » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.14
  » » Rendering APP/View/Elements/sidebar/explore.ctp	0.91
  » » » 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.12
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #4	0.12
  » » Rendering APP/View/Elements/sidebar/article_list.ctp	0.18
  » » Rendering APP/View/Elements/sidebar/property_search.ctp	0.20
  » » Rendering APP/View/Elements/sidebar/property_list.ctp	1.27
  » » » Rendering APP/View/Elements/static_property_price.ctp	0.36
  » » » Rendering APP/View/Elements/static_property_price.ctp #2	0.15
  » » » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
  » » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
  » Event: View.afterRender	0.01
  » Event: View.beforeLayout	0.01
  » Rendering APP/View/Layouts/front.ctp	83.32
  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)
        • id3740
        • brokerage_id3
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameLovingly Maintained Traditional in the Heart of Westwood
        • incomplete(false)
        • archived(false)
        • last_archived0000-00-00 00:00:00
        • auto_archived_from_mlsidx(false)
        • paid_featured(false)
        • featured(false)
        • homepage_featured(false)
        • brokerage_page_featured(false)
        • requested_homepage_featured_by_member(false)
        • homepage_featured_by_member(false)
        • dot_luxury_featured(false)
        • luxury_feed_featured(false)
        • force_luxury_feed_featured(false)
        • luxury_autofeed_imported(false)
        • luxury_feed_last_added_time0000-00-00 00:00:00
        • luxury_feed_agent_user_id0
        • luxury_feed_locked_to_subscription_id0
        • luxury_feed_agent_purchase_date0000-00-00
        • luxury_feed_agent_expiration_date0000-00-00
        • digital_ad_summary_email_last_sent0000-00-00 00:00:00
        • digital_ad_summary_price_changed(false)
        • wsj_detail_url
        • ft_detail_url
        • nyt_detail_url
        • juwai_detail_url
        • pgl_detail_url
        • mg_detail_url
        • mg_c_detail_url
        • mg_s_detail_url
        • bp_detail_url
        • mw_detail_url
        • nikkei_detail_url
        • wapo_detail_url
        • robb_detail_url
        • medium_featured(false)
        • large_featured(false)
        • detail_page(false)
        • description<p>First time on the market in 60 years. Wonderful 7 bedroom plus office 2 story traditional home in the heart of Westwood. Over 3900 sq. ft.! Foyer opens to step down living room with fireplace and beamed ceiling. The kitchen has a breakfast bar that opens onto the formal dining room. Family room is complete with wet bar and French doors that lead to the backyard enhanced with pool, spa and entertainers deck. Master suite has 2 en-suite closets and full bath with double sinks. 2 car detached garage. This home which has been lovingly maintained over the years is now ready for someone to update it and customize it to fit their needs. Trust sale.</p>
        • address10479 WIlkins Avenue
        • address_2
        • cityLos Angeles
        • stateCA
        • postal_code90024
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price1995000
        • price_20
        • price_usd1995000
        • 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_feet3991
        • 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://10479wilkinsavenue.thepartnerstrust.com/
        • meta_title
        • meta_description
        • meta_keywords
        • bathrooms_partial0
        • bathrooms_partial_20
        • bathrooms_3_41
        • bathrooms_3_4_20
        • year_built1928
        • virtual_tour
        • video_tourhttp://www.onvedeo.com/properties/752301/embed
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num16112968
        • wsj_property_typesingle family
        • nyt_property_type1
        • nyt_popular_features
        • propgolux_property_type9
        • juwai_property_typeSingle Family
        • juwai_categoryresidential
        • propgolux_property_style42
        • wapo_property_type
        • robb_property_typeSingle Family Home
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude34.059605
        • longitude-118.428261
        • invalid_required_fields
        • invalid_optional_fields
        • went_live_today(false)
        • converted(true)
        • invalid(false)
        • mlsidx_full_address
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2024-10-23 06:34:56
        • created2016-04-18 09:36:52
        • uri/property-detail/3740/10479-wilkins-avenue-los-angeles-ca-90024-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3740/10479-wilkins-avenue-los-angeles-ca-90024-usa
        • address_concat10479 WIlkins Avenue Los Angeles CA 90024 USA
        • google_maps_query_string10479+WIlkins+Avenue++Los+Angeles+CA+90024+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 1,995,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty7
        • bathrooms_pretty3
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty1
        • feed_full_bathrooms4
        • date_listed2016-04-18
        • overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id3
        • account_executive_id236
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties12
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties2
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(true)
        • country_id1
        • WOEID2442047
        • timezoneUS/Pacific
        • luxury_feed_enrollment_modemanual
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id
        • mlsidx_lux_autofeed(false)
        • mlsidx_lux_autofeed_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • namePartners Trust Real Estate Brokerage and Acquisitions
        • broker_of_record_name
        • short_namePartners Trust Real Estate
        • usernamePartnersTrustLA
        • password165bb7b526009554e197bcf82dabaa84ae727155
        • password_reset_hash
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date0000-00-00
        • monthly_invoice_end_date0000-00-00
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>Partners Trust is the exclusive representative for Leverage Global Partners in Los Angeles, California, USA.</p> <p>At Partners Trust, our real estate associates are the most professional, successful and ethical in the business, representing each of our clients with care, confidentiality and the utmost attention to service.</p> <p>As a company, we offer our associates and clients a level of technology and communication unmatched in today’s real estate market. Los Angeles provides the ideal canvas to make your dream become a reality.</p> <p>We live, work, and entertain everywhere, from our beautiful beaches and the vibrant, newly revitalized downtown to the expansive mountain ranges overlooking the serene desert landscapes. With a culture that attracts celebrities, sports figures and entrepreneurs, the Southern California lifestyle is in high demand. Great representation in this real estate market is essential.</p> <p>Our associates proudly handle all types of homes, ranging from the architectural estate to the contemporary condominium to the historic, traditional home. Each property and client is represented with the highest quality of presentation and service, leading to unparalleled success.</p> <p>Partners Trust has additional office locations in <a href="../../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/5/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Pasadena</a>, <a href="../../../brokerage-detail/142/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Malibu</a>, and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a></p>
        • communitiesLos Angeles Brentwood West Los Angeles
        • websitehttp://thepartnerstrust.com
        • address11726 San Vicente Blvd
        • address_2Suite 350
        • cityLos Angeles
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • marketLos Angeles
        • market_2
        • postal_code90049
        • phone(310) 500-1388
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameNick Segal
        • contact_profile_link
        • contact_big_profile_linkhttp://www.leveragere.com/blog/presidential-profile-partners-trust-real-estate-brokerage-aquisitions-nick-segal/
        • contact_big_profile_link_text
        • contact_titlePresident/Co-Founder
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename3.jpg
        • logo_filename3.png
        • contact_image_filename3.jpg
        • all_properties_link_image_filename3.jpg
        • all_properties_linkhttp://www.thepartnerstrust.com/properties
        • video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
        • contact_video_embed_code
        • meta_titleLos Angeles Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
        • meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Los Angeles, CA is a premier boutique real estate brokerage, serving home buyers and sellers in the Los Angeles real estate market.
        • meta_keywordspartners trust, Partners Trust Real Estate, los angeles real estate, nick segal, leverage global partners
        • login_message_counter3
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-03-18 15:09:20
        • modified2016-04-08 16:33:22
        • dre_num012345
        • uri/brokerage-detail/3/partners-trust-real-estate-brokerage-and-acquisitions
        • website_shortthepartnerstrust.com
        • name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
      • StripeSubscription(array)
        • id(null)
        • brokerage_id(null)
        • user_id(null)
        • property_id(null)
        • type(null)
        • stripe_id(null)
        • stripe_customer_id(null)
        • stripe_checkout_email(null)
        • stripe_promotion_code(null)
        • stripe_promotion_code_id(null)
        • stripe_coupon_code_id(null)
        • status(null)
        • current_period_end(null)
        • cancel_at_period_end(null)
        • ended(null)
        • last_change(null)
        • last_activity_email_sent(null)
        • created(null)
        • modified(null)
      • GlobalReachReport(array)
        • id(null)
        • property_id(null)
        • wsj_desktop(null)
        • wsj_mobile(null)
        • wsj_expires(null)
        • wsj_capture_started(null)
        • mg_desktop(null)
        • mg_mobile(null)
        • mg_expires(null)
        • mg_capture_started(null)
        • bp_desktop(null)
        • bp_mobile(null)
        • bp_expires(null)
        • gp_capture_started(null)
        • mw_desktop(null)
        • mw_mobile(null)
        • mw_expires(null)
        • mw_capture_started(null)
        • ft_desktop(null)
        • ft_mobile(null)
        • ft_expires(null)
        • ft_capture_started(null)
        • nikkei_desktop(null)
        • nikkei_mobile(null)
        • nikkei_expires(null)
        • nikkei_capture_started(null)
        • pgl_desktop(null)
        • pgl_mobile(null)
        • pgl_expires(null)
        • pgl_capture_started(null)
        • robb_desktop(null)
        • robb_mobile(null)
        • robb_expires(null)
        • robb_capture_started(null)
        • juwai_desktop(null)
        • juwai_mobile(null)
        • juwai_expires(null)
        • juwai_capture_started(null)
        • leverage_desktop(null)
        • leverage_mobile(null)
        • leverage_expires(null)
        • leverage_capture_started(null)
        • created(null)
        • modified(null)
        • wsj_available(false)
        • wsj_expired(true)
        • wsj_desktop_proxy_screenshot(null)
        • wsj_mobile_proxy_screenshot(null)
        • mg_available(false)
        • mg_expired(true)
        • mg_desktop_proxy_screenshot(null)
        • mg_mobile_proxy_screenshot(null)
        • bp_available(false)
        • bp_expired(true)
        • bp_desktop_proxy_screenshot(null)
        • bp_mobile_proxy_screenshot(null)
        • mw_available(false)
        • mw_expired(true)
        • mw_desktop_proxy_screenshot(null)
        • mw_mobile_proxy_screenshot(null)
        • nikkei_available(false)
        • nikkei_expired(true)
        • nikkei_desktop_proxy_screenshot(null)
        • nikkei_mobile_proxy_screenshot(null)
        • pgl_available(false)
        • pgl_expired(true)
        • pgl_desktop_proxy_screenshot(null)
        • pgl_mobile_proxy_screenshot(null)
        • robb_available(false)
        • robb_expired(true)
        • robb_desktop_proxy_screenshot(null)
        • robb_mobile_proxy_screenshot(null)
        • juwai_available(false)
        • juwai_expired(true)
        • juwai_desktop_proxy_screenshot(null)
        • juwai_mobile_proxy_screenshot(null)
        • capture_processing(false)
        • capture_error(empty)
      • Image(array)
        • 0(array)
          • id20962
          • modelProperty
          • model_id3740
          • tagImage
          • name1.JPG
          • typeimage/jpeg
          • size4134059
          • uri/assets/20962.JPG
          • order0
          • created2016-04-18 09:34:29
          • modified2016-04-18 09:36:52
        • 1(array)
          • id20955
          • modelProperty
          • model_id3740
          • tagImage
          • name4.jpg
          • typeimage/jpeg
          • size3877849
          • uri/assets/20955.jpg
          • order1
          • created2016-04-18 09:34:14
          • modified2016-04-18 09:36:52
        • 2(array)
          • id20956
          • modelProperty
          • model_id3740
          • tagImage
          • name13.jpg
          • typeimage/jpeg
          • size4034097
          • uri/assets/20956.jpg
          • order2
          • created2016-04-18 09:34:16
          • modified2016-04-18 09:36:52
        • 3(array)
          • id20957
          • modelProperty
          • model_id3740
          • tagImage
          • name9.jpg
          • typeimage/jpeg
          • size3646767
          • uri/assets/20957.jpg
          • order3
          • created2016-04-18 09:34:18
          • modified2016-04-18 09:36:52
        • 4(array)
          • id20953
          • modelProperty
          • model_id3740
          • tagImage
          • name16.jpg
          • typeimage/jpeg
          • size2718489
          • uri/assets/20953.jpg
          • order4
          • created2016-04-18 09:34:10
          • modified2016-04-18 09:36:52
        • 5(array)
          • id20960
          • modelProperty
          • model_id3740
          • tagImage
          • name7.jpg
          • typeimage/jpeg
          • size3607236
          • uri/assets/20960.jpg
          • order5
          • created2016-04-18 09:34:25
          • modified2016-04-18 09:36:52
        • 6(array)
          • id20958
          • modelProperty
          • model_id3740
          • tagImage
          • name5.jpg
          • typeimage/jpeg
          • size4342066
          • uri/assets/20958.jpg
          • order6
          • created2016-04-18 09:34:21
          • modified2016-04-18 09:36:52
        • 7(array)
          • id20954
          • modelProperty
          • model_id3740
          • tagImage
          • name18.jpg
          • typeimage/jpeg
          • size3113194
          • uri/assets/20954.jpg
          • order7
          • created2016-04-18 09:34:12
          • modified2016-04-18 09:36:52
        • 8(array)
          • id20959
          • modelProperty
          • model_id3740
          • tagImage
          • name22.jpg
          • typeimage/jpeg
          • size4475135
          • uri/assets/20959.jpg
          • order8
          • created2016-04-18 09:34:23
          • modified2016-04-18 09:36:52
        • 9(array)
          • id20961
          • modelProperty
          • model_id3740
          • tagImage
          • name32.JPG
          • typeimage/jpeg
          • size7411937
          • uri/assets/20961.JPG
          • order9
          • created2016-04-18 09:34:27
          • modified2016-04-18 09:36:52
      • User(array)
        • 0(array)
          • id1171
          • typeAgent
          • brokerage_id3
          • email[email protected]
          • password0e2fe445c40a7d54b86c8630d7dd394b410e6e41
          • recover_hash
          • first_nameJennifer
          • last_namePinckert Tierney
          • title
          • dre_num
          • phone310-489-8292
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2017-08-07 15:23:56
          • created2017-08-07 15:23:56
          • notified(false)
          • full_nameJennifer Pinckert Tierney
          • uri/agent-detail/1171/jennifer-pinckert-tierney
          • profile_complete(true)
          • UsersProperty(array)
            • id971
            • user_id1171
            • property_id3740
            • sort_order0
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(array)
        • 0(array)
          • id12
          • nameSwimming Pool
          • additional(false)
          • created2016-04-07 14:04:12
          • modified2016-04-07 14:04:12
          • PropertiesPropertyFeature(array)
            • id4411
            • property_id3740
            • property_feature_id12
      • Topic(array)
        • 0(array)
          • id13
          • nameTraditional Architecture
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:34:46
          • tile_nameTraditional Architecture
          • PropertiesTopic(array)
            • id43
            • property_id3740
            • topic_id13
    • 1(array)
      • Property(array)
        • id3734
        • brokerage_id5
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameLovely & Detailed Remodel in South Pasadena
        • incomplete(false)
        • archived(false)
        • last_archived0000-00-00 00:00:00
        • auto_archived_from_mlsidx(false)
        • paid_featured(false)
        • featured(false)
        • homepage_featured(false)
        • brokerage_page_featured(true)
        • requested_homepage_featured_by_member(false)
        • homepage_featured_by_member(false)
        • dot_luxury_featured(false)
        • luxury_feed_featured(false)
        • force_luxury_feed_featured(false)
        • luxury_autofeed_imported(false)
        • luxury_feed_last_added_time0000-00-00 00:00:00
        • luxury_feed_agent_user_id0
        • luxury_feed_locked_to_subscription_id0
        • luxury_feed_agent_purchase_date0000-00-00
        • luxury_feed_agent_expiration_date0000-00-00
        • digital_ad_summary_email_last_sent0000-00-00 00:00:00
        • digital_ad_summary_price_changed(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>Lovely and creatively remodeled home w/ a 2nd story in 2002 while preserving the 1925 integrity of the estate. Grand foyer w/ custom stairwell & impressive chandelier offers a stately entrance to this impeccable home loaded w/ an abundance of charm & character. There are impressive intricate details throughout. Adjacent to the foyer is a formal living room offering natural light by day & a cozy romantic fireplace by night. Gourmet kitchen is a chef's dream w/ center island, double ovens, stove top & opens to the family room. Luxurious master suite is located on the 2nd level w/ inspiring views of the rear gardens. Master bath offers dual sinks, soaking tub & oversized shower w/ bench. Backyard is ideal for entertaining under the grandiose pergola or simply relaxing & enjoying the vistas of the grassy area & mature trees. This a special South Pasadena home that has been lovingly maintained for the past 21 years by the current owners. Thank you for sharing in the joy of viewing this home.</p>
        • address1817 Spruce Street
        • address_2
        • citySouth Pasadena
        • stateCA
        • postal_code91030
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price1780000
        • price_20
        • price_usd1780000
        • 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_feet2846
        • 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://1817sprucestreetstreet.thepartnerstrust.com/
        • meta_title
        • meta_description
        • meta_keywords
        • bathrooms_partial2
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built1925
        • virtual_tour
        • video_tourhttp://www.onvedeo.com/properties/759797/embed
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num316002835
        • wsj_property_typesingle family
        • nyt_property_type1
        • nyt_popular_features
        • propgolux_property_type9
        • juwai_property_type
        • juwai_category
        • propgolux_property_style42
        • 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.105072
        • longitude-118.145790
        • invalid_required_fields
        • invalid_optional_fields
        • went_live_today(false)
        • converted(true)
        • invalid(false)
        • mlsidx_full_address
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2016-04-18 00:33:02
        • created2016-04-15 16:49:02
        • uri/property-detail/3734/1817-spruce-street-south-pasadena-ca-91030-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3734/1817-spruce-street-south-pasadena-ca-91030-usa
        • address_concat1817 Spruce Street South Pasadena CA 91030 USA
        • google_maps_query_string1817+Spruce+Street++South+Pasadena+CA+91030+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 1,780,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-15
        • overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id5
        • account_executive_id236
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties12
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties2
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(true)
        • country_id1
        • WOEID2468964
        • timezoneUS/Pacific
        • luxury_feed_enrollment_modemanual
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id
        • mlsidx_lux_autofeed(false)
        • mlsidx_lux_autofeed_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • namePartners Trust Real Estate Brokerage and Acquisitions
        • broker_of_record_name
        • short_namePartners Trust Real Estate
        • usernamePartnersTrustPas
        • password5b28522e46f56278664573d82c2b0f03520519d0
        • password_reset_hash
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date0000-00-00
        • monthly_invoice_end_date0000-00-00
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>Partners Trust is the exclusive representative for Leverage Global Partners in Pasadena and La Cañada Flintridge, California, USA.</p> <p>At Partners Trust, we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market, presenting our clients with the most professional, successful and ethical real estate associates in the business. We represent our clients with care, confidentiality and the utmost attention to service.</p> <p>Pasadena is a harmonious blend of past and present. Experience the nationally-televised Rose Parade, catch an exciting football game at the Rose Bowl, get smart at Caltech, or revel in the Jet Propulsion Laboratory.</p> <p>The community is renowned for its charming and diverse neighborhoods whose residents honor and preserve the splendor of early California architecture. Opportunities abound to experience Pasadena’s sophisticated culture with the diversified entertainment at the Pasadena Playhouse, the Norton Simon Museum, the Huntington Library and Botanical Gardens and even by walking along the vibrant, historic district of Colorado Boulevard.</p> <p>Partners Trust associates are proud to represent a wide variety of historic and architecturally diverse homes, including the Craftsman-style home. We understand our clients discerning needs, and provide a high level of service and local area knowledge.</p> <p>Partners Trust has additional office locations in <a href="../../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../../brokerage-detail/142/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Malibu</a>, and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai.</a></p>
        • communitiesPasadena La Canada Flintridge San Marino La Canada Flintridge
        • websitehttp://www.thepartnerstrust.com
        • address594 E. Colorado Boulevard
        • address_2
        • cityPasadena
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • marketPasadena
        • market_2
        • postal_code91101
        • phone(626) 696-4802
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameScott Brown
        • contact_profile_link
        • contact_big_profile_linkhttp://www.leveragere.com/blog/meet-scott-brown-managing-director-partners-trust-pasadena/
        • contact_big_profile_link_text
        • contact_titleManaging Director
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2Nick Segal
        • contact_profile_link_2http://www.leveragere.com/brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2President/Co-Founder
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename5.jpg
        • logo_filename5.png
        • contact_image_filename5.jpg
        • all_properties_link_image_filename5.jpg
        • all_properties_linkhttp://www.thepartnerstrust.com/properties
        • video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
        • contact_video_embed_code
        • meta_titlePasadena Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
        • meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Pasadena, CA is a premier boutique Pasadena real estate brokerage and the exclusive Pasadena representative for Leverage Global Partners.
        • meta_keywordspartners trust, partners trust real estate, pasadena real estate, leverage global partners, pasadena homes for sale, scott brown
        • login_message_counter1
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-03-18 16:08:06
        • modified2016-04-08 16:33:22
        • dre_num012345
        • uri/brokerage-detail/5/partners-trust-real-estate-brokerage-and-acquisitions
        • website_shortwww.thepartnerstrust.com
        • name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
      • 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)
          • id20890
          • modelProperty
          • model_id3734
          • tagImage
          • nameegpimaging_1817Spruce_001_HIGHRES.jpg
          • typeimage/jpeg
          • size10361514
          • uri/assets/20890.jpg
          • order0
          • created2016-04-15 16:47:48
          • modified2016-04-15 16:49:02
        • 1(array)
          • id20879
          • modelProperty
          • model_id3734
          • tagImage
          • nameegpimaging_1817Spruce_008_HIGHRES.jpg
          • typeimage/jpeg
          • size6804950
          • uri/assets/20879.jpg
          • order1
          • created2016-04-15 16:47:42
          • modified2016-04-15 16:49:02
        • 2(array)
          • id20877
          • modelProperty
          • model_id3734
          • tagImage
          • nameegpimaging_1817Spruce_017_HIGHRES.jpg
          • typeimage/jpeg
          • size5626562
          • uri/assets/20877.jpg
          • order2
          • created2016-04-15 16:47:39
          • modified2016-04-15 16:49:02
        • 3(array)
          • id20876
          • modelProperty
          • model_id3734
          • tagImage
          • nameegpimaging_1817Spruce_022_HIGHRES.jpg
          • typeimage/jpeg
          • size5719147
          • uri/assets/20876.jpg
          • order3
          • created2016-04-15 16:47:38
          • modified2016-04-15 16:49:02
        • 4(array)
          • id20878
          • modelProperty
          • model_id3734
          • tagImage
          • nameegpimaging_1817Spruce_014_HIGHRES.jpg
          • typeimage/jpeg
          • size5358186
          • uri/assets/20878.jpg
          • order4
          • created2016-04-15 16:47:40
          • modified2016-04-15 16:49:02
        • 5(array)
          • id20882
          • modelProperty
          • model_id3734
          • tagImage
          • nameegpimaging_1817Spruce_009_HIGHRES.jpg
          • typeimage/jpeg
          • size6157612
          • uri/assets/20882.jpg
          • order5
          • created2016-04-15 16:47:46
          • modified2016-04-15 16:49:02
        • 6(array)
          • id20881
          • modelProperty
          • model_id3734
          • tagImage
          • nameegpimaging_1817Spruce_038_HIGHRES.jpg
          • typeimage/jpeg
          • size9795680
          • uri/assets/20881.jpg
          • order6
          • created2016-04-15 16:47:44
          • modified2016-04-15 16:49:02
        • 7(array)
          • id20894
          • modelProperty
          • model_id3734
          • tagImage
          • nameegpimaging_1817Spruce_044_HIGHRES.jpg
          • typeimage/jpeg
          • size11888212
          • uri/assets/20894.jpg
          • order7
          • created2016-04-15 16:47:50
          • modified2016-04-15 16:49:02
        • 8(array)
          • id20883
          • modelProperty
          • model_id3734
          • tagImage
          • nameegpimaging_1817Spruce_035_HIGHRES.jpg
          • typeimage/jpeg
          • size10217742
          • uri/assets/20883.jpg
          • order8
          • created2016-04-15 16:47:47
          • modified2016-04-15 16:49:02
        • 9(array)
          • id20880
          • modelProperty
          • model_id3734
          • tagImage
          • nameegpimaging_1817Spruce_040_HIGHRES.jpg
          • typeimage/jpeg
          • size10614464
          • uri/assets/20880.jpg
          • order9
          • created2016-04-15 16:47:43
          • modified2016-04-15 16:49:02
      • User(empty)
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(array)
        • 0(array)
          • id9
          • nameOffice
          • additional(false)
          • created2016-04-07 14:03:21
          • modified2016-04-07 14:03:21
          • PropertiesPropertyFeature(array)
            • id4405
            • property_id3734
            • property_feature_id9
        • 1(array)
          • id4
          • nameGarage
          • additional(false)
          • created2016-04-07 14:01:52
          • modified2016-04-07 14:01:52
          • PropertiesPropertyFeature(array)
            • id4404
            • property_id3734
            • property_feature_id4
      • Topic(empty)
    • 2(array)
      • Property(array)
        • id3754
        • brokerage_id16
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameBoutique State-of-the-Art Condo in the West Village
        • incomplete(false)
        • archived(false)
        • last_archived0000-00-00 00:00:00
        • auto_archived_from_mlsidx(false)
        • paid_featured(false)
        • featured(false)
        • homepage_featured(false)
        • brokerage_page_featured(false)
        • requested_homepage_featured_by_member(false)
        • homepage_featured_by_member(false)
        • dot_luxury_featured(false)
        • luxury_feed_featured(true)
        • force_luxury_feed_featured(false)
        • luxury_autofeed_imported(false)
        • luxury_feed_last_added_time2019-10-29 20:09:29
        • 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_sent2019-10-31 20:45:16
        • digital_ad_summary_price_changed(false)
        • wsj_detail_urlhttps://realestate.wsj.com/newyork/2204846-385-west-12th-street-10014?mod=search&pos=7&page=1&
        • ft_detail_urlhttps://propertylistings.ft.com/homes/2755194
        • nyt_detail_urlhttps://www.nytimes.com/real-estate/usa/ny/new-york/west-village/homes-for-sale/385-west-12th-street/1106-PRCH-2762625
        • juwai_detail_urlhttps://www.juwai.com/50318262.htm
        • pgl_detail_urlhttps://www.propgoluxury.com/en/homes/2755194
        • mg_detail_urlhttps://www.mansionglobal.com/newyork/2204846-385-west-12th-street-10014?mod=search&pos=6&page=1&&region=na,us
        • 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>385 West 12th Street, a boutique and state-of-the-art condominium in the West Village, boasts this magnificent 3-bedroom, 2.5-bathroom apartment. It is meticulously designed to the highest standard and spans 2,711SF. A private elevator landing opens to the heart of the home. Upon entering, the thoughtful layout leads left to the living areas and additional bedrooms, ensuring privacy to the master suite which is to the right. A powder room is cleverly tucked opposite the landing, perfect for guests. The sitting room is anchored by a gas fireplace and leads to the light-filled living room. Separating the living and dining areas is discreet storage. Treetops and the cobblestoned street can be seen through the massive, floor-to-ceiling window that frames the dining room. Overlooking the dining room is an oversized chef’s kitchen; ideal for both large events, and intimate, countertop eating. It boasts custom white lacquered oak cabinetry complimented by the marble countertops and backsplash. It’s equipped with top-of-the-line Miele and Gaggenau appliances, Franke sinks/faucets and wine fridge. The spacious master suite features a generous terrace, walk-in closet and stunning five-piece bathroom. The bathroom is outfitted in Italian marble with a deep-soaking tub, glass-enclosed shower, and radiant floor heating. A media room, home office, two additional bedrooms, an additional full bathroom and washer/dryer complete the home. Additional features include Control 4- fully integrated home automation. Completed in 2010, 385 West 12th Street is a boutique condominium with only 12 units among 7 stories. Amenities offer the perfect balance of leisure and entertainment and feature a recently renovated and beautifully landscaped rooftop with a 55-foot swimming pool, Jacuzzi, outdoor shower, two gas grills and dining space. Direct views of the Hudson River, the West Village, and Empire State Building, with views to the north crown the rooftop. Additional building amenities include a 24-hour doorman/concierge, millwork club locker in the lobby, bike storage, and cellar storage room.</p>
        • address385 West 12th Street
        • address_23WEST
        • cityNew York
        • stateNY
        • postal_code10014
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price5000000
        • price_20
        • price_usd5000000
        • 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_built2004
        • virtual_tour
        • video_tour
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num123456
        • wsj_property_typecondominium
        • nyt_property_type5
        • nyt_popular_features
        • propgolux_property_type2
        • juwai_property_typeApartments/Condo
        • juwai_categoryresidential
        • propgolux_property_style25
        • wapo_property_type
        • robb_property_type
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude40.737713
        • longitude-74.008759
        • 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 20:45:16
        • created2019-10-29 20:06:20
        • uri/property-detail/3754/385-west-12th-street-3west-new-york-ny-10014-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3754/385-west-12th-street-3west-new-york-ny-10014-usa
        • address_concat385 West 12th Street 3WEST New York NY 10014 USA
        • google_maps_query_string385+West+12th+Street+3WEST+New+York+NY+10014+USA
        • luxury_ad_enrolled_prettyYES
        • price_prettyUSD 5,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-29
        • overridden_brokerage_nameCORE
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id16
        • account_executive_id235
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties20
        • 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
        • WOEID12589342
        • 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
        • nameCORE
        • broker_of_record_name
        • short_nameCORE
        • usernameCORENYC
        • password6bbc31e8f00594b7e3433f0a9c0cd7334bff73ae
        • 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>CORE is the exclusive representative for Leverage Global Partners in New York City, New York, USA.</p> <p>CORE is the leading, full-service, boutique real estate brokerage specializing in the marketing of premiere residential properties. Headquartered in New York City, CORE was founded by CEO Shaun Osher and Jack Cayre, who envisioned a dynamic boutique brokerage based on integrity, informed by expertise and driven by innovation.</p> <p>CORE offers comprehensive real estate solutions for buyers, sellers, landlords, investors and developers. The firm is powered by an integrated team of accomplished professionals with extensive expertise in all aspects of real estate transactions.</p> <p>Thanks to a unique marketing approach, CORE ensures that its clients earn the highest market-driven prices. Our agents educate and shepherd buyers, sellers and landlords through the sales or leasing process. And we partner closely with developers, from the earliest stages of a project through closing; partnerships, which boast a proven, profitable track record. Within the past 8 years, CORE has marketed more than 30 new development properties and is the #1 brokerage in its class.</p>
        • communitiesManhattan Chelsea New York City Tribeca Midtown
        • websitehttp://corenyc.com/
        • address104 Fifth Avenue
        • address_2
        • cityNew York
        • stateNY
        • full_stateNew York
        • countryUSA
        • marketNew York
        • market_2
        • postal_code10011
        • phone(212) 726-0778
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameShaun Osher
        • contact_profile_link
        • contact_big_profile_linkhttp://www.leveragere.com/blog/meet-shaun-osher-founder-and-ceo-of-core/
        • contact_big_profile_link_text
        • contact_titleFounder and CEO
        • contact_dre_num
        • contact_quoteI invite you to contact me personally about New York City real estate.
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename16.jpg
        • logo_filename16.jpg
        • contact_image_filename16.jpg
        • all_properties_link_image_filename16.jpg
        • all_properties_linkhttp://corenyc.com/listings
        • video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/cxxGtpBt-qzxAOUo0.js"></script>
        • contact_video_embed_code
        • meta_titleNew York City Real Estate | CORE | Leverage Global Partners
        • meta_descriptionCORE is Leverage Global Partners' exclusive representative in New York City, NY, USA.
        • meta_keywordsnew york city real estate, manhattan real estate, shaun osher, CORE, leverage global partners
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-04-01 15:35:47
        • modified2019-10-29 20:06:57
        • dre_num012345
        • uri/brokerage-detail/16/core
        • website_shortcorenyc.com
        • name_with_locationCORE
      • 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)
          • id23063
          • modelProperty
          • model_id3754
          • tagImage
          • namePI-1tfv6b4i17.jpg
          • typeimage/jpeg
          • size1392149
          • uri/assets/23063.jpg
          • order0
          • created2019-10-29 20:06:00
          • modified2019-10-29 20:06:20
        • 1(array)
          • id23071
          • modelProperty
          • model_id3754
          • tagImage
          • namePI-1tia0th4t2.jpg
          • typeimage/jpeg
          • size745950
          • uri/assets/23071.jpg
          • order1
          • created2019-10-29 20:06:02
          • modified2019-10-29 20:06:20
        • 2(array)
          • id23061
          • modelProperty
          • model_id3754
          • tagImage
          • namePI-1tfv6ad5r0.jpg
          • typeimage/jpeg
          • size953561
          • uri/assets/23061.jpg
          • order2
          • created2019-10-29 20:06:00
          • modified2019-10-29 20:06:20
        • 3(array)
          • id23062
          • modelProperty
          • model_id3754
          • tagImage
          • namePI-1tfv5v65vv.jpg
          • typeimage/jpeg
          • size1120705
          • uri/assets/23062.jpg
          • order3
          • created2019-10-29 20:06:00
          • modified2019-10-29 20:06:20
        • 4(array)
          • id23064
          • modelProperty
          • model_id3754
          • tagImage
          • namePI-1tfv5ud7qf.jpg
          • typeimage/jpeg
          • size819805
          • uri/assets/23064.jpg
          • order4
          • created2019-10-29 20:06:00
          • modified2019-10-29 20:06:20
        • 5(array)
          • id23065
          • modelProperty
          • model_id3754
          • tagImage
          • namePI-1tfv5u6hao.jpg
          • typeimage/jpeg
          • size1354457
          • uri/assets/23065.jpg
          • order5
          • created2019-10-29 20:06:00
          • modified2019-10-29 20:06:20
        • 6(array)
          • id23066
          • modelProperty
          • model_id3754
          • tagImage
          • namePI-1tfv6c8c2k.jpg
          • typeimage/jpeg
          • size667117
          • uri/assets/23066.jpg
          • order6
          • created2019-10-29 20:06:00
          • modified2019-10-29 20:06:20
        • 7(array)
          • id23067
          • modelProperty
          • model_id3754
          • tagImage
          • namePI-1tfv62hm1n.jpg
          • typeimage/jpeg
          • size1142542
          • uri/assets/23067.jpg
          • order7
          • created2019-10-29 20:06:01
          • modified2019-10-29 20:06:20
        • 8(array)
          • id23068
          • modelProperty
          • model_id3754
          • tagImage
          • namePI-1tfv60kn0g.jpg
          • typeimage/jpeg
          • size900053
          • uri/assets/23068.jpg
          • order8
          • created2019-10-29 20:06:01
          • modified2019-10-29 20:06:20
        • 9(array)
          • id23069
          • modelProperty
          • model_id3754
          • tagImage
          • namePI-1tia0rna64.jpg
          • typeimage/jpeg
          • size667255
          • uri/assets/23069.jpg
          • order9
          • created2019-10-29 20:06:01
          • modified2019-10-29 20:06:20
        • 10(array)
          • id23070
          • modelProperty
          • model_id3754
          • tagImage
          • namePI-1tfv64a3ih.jpg
          • typeimage/jpeg
          • size1295530
          • uri/assets/23070.jpg
          • order10
          • created2019-10-29 20:06:01
          • modified2019-10-29 20:06:20
        • 11(array)
          • id23072
          • modelProperty
          • model_id3754
          • tagImage
          • namePI-1tia0uv5i1.jpg
          • typeimage/jpeg
          • size816357
          • uri/assets/23072.jpg
          • order11
          • created2019-10-29 20:06:02
          • modified2019-10-29 20:06:20
        • 12(array)
          • id23073
          • modelProperty
          • model_id3754
          • tagImage
          • namePI-1tfv64q2c3.jpg
          • typeimage/jpeg
          • size1246171
          • uri/assets/23073.jpg
          • order12
          • created2019-10-29 20:06:02
          • modified2019-10-29 20:06:20
        • 13(array)
          • id23074
          • modelProperty
          • model_id3754
          • tagImage
          • namePI-1tlejtukfi.jpg
          • typeimage/jpeg
          • size1296375
          • uri/assets/23074.jpg
          • order13
          • created2019-10-29 20:06:02
          • modified2019-10-29 20:06:20
        • 14(array)
          • id23075
          • modelProperty
          • model_id3754
          • tagImage
          • namePI-1tlek8ckib.jpg
          • typeimage/jpeg
          • size821336
          • uri/assets/23075.jpg
          • order14
          • created2019-10-29 20:06:02
          • modified2019-10-29 20:06:20
        • 15(array)
          • id23076
          • modelProperty
          • model_id3754
          • tagImage
          • namePI-1tlek3e9dr.jpg
          • typeimage/jpeg
          • size1122053
          • uri/assets/23076.jpg
          • order15
          • created2019-10-29 20:06:02
          • modified2019-10-29 20:06:20
        • 16(array)
          • id23077
          • modelProperty
          • model_id3754
          • tagImage
          • namePI-1tlek0qvrl.jpg
          • typeimage/jpeg
          • size1277836
          • uri/assets/23077.jpg
          • order16
          • created2019-10-29 20:06:03
          • modified2019-10-29 20:06:20
        • 17(array)
          • id23078
          • modelProperty
          • model_id3754
          • tagImage
          • namePI-1tlek8f4uk.jpg
          • typeimage/jpeg
          • size955578
          • uri/assets/23078.jpg
          • order17
          • created2019-10-29 20:06:03
          • modified2019-10-29 20:06:20
        • 18(array)
          • id23079
          • modelProperty
          • model_id3754
          • tagImage
          • namePI-1tlek8p84e.jpg
          • typeimage/jpeg
          • size900653
          • uri/assets/23079.jpg
          • order18
          • created2019-10-29 20:06:03
          • modified2019-10-29 20:06:20
        • 19(array)
          • id23080
          • modelProperty
          • model_id3754
          • tagImage
          • namePI-1tfv5smv25.jpg
          • typeimage/jpeg
          • size1276220
          • uri/assets/23080.jpg
          • order19
          • created2019-10-29 20:06:10
          • modified2019-10-29 20:06:20
      • User(empty)
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(empty)
      • Topic(empty)
    • 3(array)
      • Property(array)
        • id3718
        • brokerage_id4
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id1153
        • agent_2_id0
        • agent_3_id0
        • nameBeautifully Updated Spacious Traditional
        • 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>Beautifully updated 1-level Traditional North of Palms in the famed Mar Vista 'Wood Streets'. Newly renovated with bamboo floors, stainless steel appliances, granite counter-tops with large center island and wine fridge. This spacious and well laid out 4 bedroom 2 1/2 bath home is move-in ready with a large grassy front yard, a backyard with a new deck alongside a finished 2 car garage with epoxy coated flooring.</p>
        • address3468 Greenwood Avenue
        • address_2
        • cityLos Angeles
        • stateCA
        • postal_code90066
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price1695000
        • price_20
        • price_usd1695000
        • 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_feet1902
        • square_meters
        • acres0
        • interior_unitsq_ft
        • interior_size0
        • lot_unitacres
        • lot_size0
        • icon_1sq-ft
        • icon_2garage
        • icon_3
        • icon_4
        • icon_5
        • icon_6
        • websitehttp://3468greenwoodavenue.thepartnerstrust.com/
        • meta_titleBeautifully Updated Spacious Traditional | Los Angeles Real Estate | Partners Trust Real Estate Brokerage and Acquisitions
        • meta_description3468 Greenwood Avenue is a property offered for sale in Los Angeles, CA, USA, presented by Partners Trust Real Estate Brokerage and Acquisitions
        • meta_keywords
        • bathrooms_partial0
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built1946
        • virtual_tour
        • video_tourhttp://www.onvedeo.com/properties/717756/embed
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num16106400
        • wsj_property_typesingle family
        • nyt_property_type1
        • nyt_popular_features
        • propgolux_property_type9
        • juwai_property_type
        • juwai_category
        • propgolux_property_style42
        • 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.006554
        • longitude-118.447250
        • invalid_required_fields
        • invalid_optional_fieldsagent_2_id, bathrooms_partial, square_meters, acres, hectares, virtual_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-11 11:15:40
        • uri/property-detail/3718/3468-greenwood-avenue-los-angeles-ca-90066-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3718/3468-greenwood-avenue-los-angeles-ca-90066-usa
        • address_concat3468 Greenwood Avenue Los Angeles CA 90066 USA
        • google_maps_query_string3468+Greenwood+Avenue++Los+Angeles+CA+90066+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 1,695,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty4
        • bathrooms_pretty2
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms2
        • date_listed2016-04-11
        • overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id4
        • account_executive_id236
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties12
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties1
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(true)
        • country_id1
        • WOEID2488892
        • timezoneUS/Pacific
        • luxury_feed_enrollment_modemanual
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id
        • mlsidx_lux_autofeed(false)
        • mlsidx_lux_autofeed_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • namePartners Trust Real Estate Brokerage and Acquisitions
        • broker_of_record_name
        • short_namePartners Trust Real Estate
        • usernamePartnersTrustSM
        • password74c7d5ff6cf0a7cb1e382c45ff916c0d15196817
        • password_reset_hash
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date0000-00-00
        • monthly_invoice_end_date0000-00-00
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>Partners Trust is the exclusive representative for Leverage Global Partners in Santa Monica, California, USA.</p> <p>At Partners Trust, our real estate associates are the most professional, successful and ethical in the business, representing each of our clients with care, confidentiality and the utmost attention to service. As a company, we offer our associates and clients a level of technology and communication unmatched in today’s real estate market.</p> <p>Situated on the Pacific coast, Santa Monica’s excellent weather, proximity to the beach and its pedestrian and bike-friendly topography makes it one of the most desirable communities to call home in the country. Santa Monica offers an eclectic and rich mixture of commerce, affluent, single-family neighborhoods, renters, young professionals, and students.</p> <p>Our associates proudly represent a wide array of homes, ranging from a beachfront property or classic traditional, to the hillside contemporary estate. Whether our clients are homeowners or builders or international investors, Partners Trust associates understand their discerning needs and provide impeccable service with a high level of local area expertise.</p> <p>Partners Trust has additional office locations in <a href="../../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../../brokerage-detail/5/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Pasadena</a>, <a href="../../../brokerage-detail/142/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Malibu</a> and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai</a>.</p>
        • communitiesSanta Monica Marina Del Rey Venice Mar Vista Pacific Palisades
        • websitehttp://www.thepartnerstrust.com
        • address1333 Montana Avenue
        • address_2
        • citySanta Monica
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • marketSanta Monica
        • market_2
        • postal_code90403
        • phone(310) 500-1307
        • phone_2(310) 505-9420
        • phone_3
        • wide_contact_image(false)
        • contact_nameScott Carmody
        • contact_profile_link
        • contact_big_profile_linkhttp://www.leveragere.com/blog/meet-scott-carmody-managing-director-partners-trust-santa-monica/
        • contact_big_profile_link_text
        • contact_titleManaging Director
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2Nick Segal
        • contact_profile_link_2http://www.leveragere.com/brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2President/Co-Founder
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename4.jpg
        • logo_filename4.png
        • contact_image_filename4.JPG
        • all_properties_link_image_filename4.jpg
        • all_properties_linkhttp://www.thepartnerstrust.com/properties
        • video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
        • contact_video_embed_code
        • meta_titleSanta Monica Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
        • meta_descriptionPartners Trust Real Estate Brokerage and Acquisitions in Santa Monica, CA is a boutique real estate brokerage, focused on providing the highest level of service to home buyers and sellers in the Santa Monica real estate market.
        • meta_keywordspartners trust, partners trust real estate, santa monica real estate, santa monica real estate agents, scott carmody, leverage global partners
        • login_message_counter3
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-03-18 15:36:48
        • modified2016-04-08 16:33:22
        • dre_num012345
        • uri/brokerage-detail/4/partners-trust-real-estate-brokerage-and-acquisitions
        • website_shortwww.thepartnerstrust.com
        • name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
      • StripeSubscription(array)
        • id(null)
        • brokerage_id(null)
        • user_id(null)
        • property_id(null)
        • type(null)
        • stripe_id(null)
        • stripe_customer_id(null)
        • stripe_checkout_email(null)
        • stripe_promotion_code(null)
        • stripe_promotion_code_id(null)
        • stripe_coupon_code_id(null)
        • status(null)
        • current_period_end(null)
        • cancel_at_period_end(null)
        • ended(null)
        • last_change(null)
        • last_activity_email_sent(null)
        • created(null)
        • modified(null)
      • GlobalReachReport(array)
        • id(null)
        • property_id(null)
        • wsj_desktop(null)
        • wsj_mobile(null)
        • wsj_expires(null)
        • wsj_capture_started(null)
        • mg_desktop(null)
        • mg_mobile(null)
        • mg_expires(null)
        • mg_capture_started(null)
        • bp_desktop(null)
        • bp_mobile(null)
        • bp_expires(null)
        • gp_capture_started(null)
        • mw_desktop(null)
        • mw_mobile(null)
        • mw_expires(null)
        • mw_capture_started(null)
        • ft_desktop(null)
        • ft_mobile(null)
        • ft_expires(null)
        • ft_capture_started(null)
        • nikkei_desktop(null)
        • nikkei_mobile(null)
        • nikkei_expires(null)
        • nikkei_capture_started(null)
        • pgl_desktop(null)
        • pgl_mobile(null)
        • pgl_expires(null)
        • pgl_capture_started(null)
        • robb_desktop(null)
        • robb_mobile(null)
        • robb_expires(null)
        • robb_capture_started(null)
        • juwai_desktop(null)
        • juwai_mobile(null)
        • juwai_expires(null)
        • juwai_capture_started(null)
        • leverage_desktop(null)
        • leverage_mobile(null)
        • leverage_expires(null)
        • leverage_capture_started(null)
        • created(null)
        • modified(null)
        • wsj_available(false)
        • wsj_expired(true)
        • wsj_desktop_proxy_screenshot(null)
        • wsj_mobile_proxy_screenshot(null)
        • mg_available(false)
        • mg_expired(true)
        • mg_desktop_proxy_screenshot(null)
        • mg_mobile_proxy_screenshot(null)
        • bp_available(false)
        • bp_expired(true)
        • bp_desktop_proxy_screenshot(null)
        • bp_mobile_proxy_screenshot(null)
        • mw_available(false)
        • mw_expired(true)
        • mw_desktop_proxy_screenshot(null)
        • mw_mobile_proxy_screenshot(null)
        • nikkei_available(false)
        • nikkei_expired(true)
        • nikkei_desktop_proxy_screenshot(null)
        • nikkei_mobile_proxy_screenshot(null)
        • pgl_available(false)
        • pgl_expired(true)
        • pgl_desktop_proxy_screenshot(null)
        • pgl_mobile_proxy_screenshot(null)
        • robb_available(false)
        • robb_expired(true)
        • robb_desktop_proxy_screenshot(null)
        • robb_mobile_proxy_screenshot(null)
        • juwai_available(false)
        • juwai_expired(true)
        • juwai_desktop_proxy_screenshot(null)
        • juwai_mobile_proxy_screenshot(null)
        • capture_processing(false)
        • capture_error(empty)
      • Image(array)
        • 0(array)
          • id20633
          • modelProperty
          • model_id3718
          • tagImage
          • name36119.jpg
          • typeimage/jpeg
          • size1824137
          • uri/assets/20633.jpg
          • order0
          • created2016-04-11 18:19:20
          • modified2016-04-11 18:21:10
        • 1(array)
          • id20636
          • modelProperty
          • model_id3718
          • tagImage
          • name36120.jpg
          • typeimage/jpeg
          • size1790126
          • uri/assets/20636.jpg
          • order1
          • created2016-04-11 18:19:53
          • modified2016-04-11 18:21:10
        • 2(array)
          • id20634
          • modelProperty
          • model_id3718
          • tagImage
          • name36117.jpg
          • typeimage/jpeg
          • size6354295
          • uri/assets/20634.jpg
          • order2
          • created2016-04-11 18:19:21
          • modified2016-04-11 18:21:10
        • 3(array)
          • id20635
          • modelProperty
          • model_id3718
          • tagImage
          • name36118.jpg
          • typeimage/jpeg
          • size9352579
          • uri/assets/20635.jpg
          • order3
          • created2016-04-11 18:19:23
          • modified2016-04-11 18:21:10
        • 4(array)
          • id20638
          • modelProperty
          • model_id3718
          • tagImage
          • name36116.jpg
          • typeimage/jpeg
          • size5980232
          • uri/assets/20638.jpg
          • order4
          • created2016-04-11 18:20:57
          • modified2016-04-11 18:21:10
      • User(array)
        • 0(array)
          • id1222
          • typeAgent
          • brokerage_id4
          • email[email protected]
          • password6bec43a6c86d9cfff48b4d877c01d6b595651ebd
          • recover_hash
          • first_nameMark
          • last_nameKitching
          • title
          • dre_num
          • phone310.902.0221
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2017-08-07 15:23:59
          • created2017-08-07 15:23:59
          • notified(false)
          • full_nameMark Kitching
          • uri/agent-detail/1222/mark-kitching
          • profile_complete(true)
          • UsersProperty(array)
            • id1046
            • user_id1222
            • property_id3718
            • 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)
            • id4363
            • property_id3718
            • property_feature_id4
      • 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)
        • id442
        • modelLocation
        • model_id146
        • archived(false)
        • medium_featured(true)
        • large_featured(false)
        • titleLocation: Costa Rica
        • authorLeverageRE
        • date2016-03-28
        • lead_inPura vida isn't as much a mantra in Costa Rica as it is the thing that softly lures you back to this easygoing coastal country time after time. The "pure life" here revolves around happiness and living life to the fullest. Nowhere does that seem easier to do than in this well-rounded Central American state, which is filled with leafy rain forests, smoking volcanoes, and white-sand beaches. With about 4.8 million residents, Costa Rica is home to ample coastal area, and includes four distinctive regions: San José, Guanacaste, Puntarenas, and Alajuela.
        • body<p><img class="aligncenter wp-image-12870 pure-img" src="/assets/3078.png" /></p> <p>Leverage Partner <a href="http://www.leveragere.com/brokerage-detail/85/Plantaci%C3%B3n-Properties">Plantación Properties</a> has recognized each for unique, defining characteristics: San José, the capital; Guanacaste, with its ultra-blue waters; Puntarenas, a small, compact island; and the historic, stately city of Alajuela. San José showcases a mix of Victorian structures and more modern concrete buildings. The small but mighty Pre-Columbian Gold Museum, for instance, displays lavish trinkets from history, while nightclubs and dancehalls offer evening entertainment throughout the city. It's this juxtaposition of modernity and history, however, and the locals' ability to find pura vida that makes Costa Rica's capital stand out. Meanwhile, the Guanacaste region, home to striking marine waters and ultra-green landscapes, is more travel-friendly. Our favorite beaches, restaurants, and ways to while away the hours in each region follow here:</p> <p><strong>LOS ALTOS DE EROS BOUTIQUE HOTEL & SPA</strong>  This unrivaled Costa Rica Spa invites you to embark on the most pleasurable journey of your life. Unlike any other, Spa de Eros is composed of five private treatment rooms overlooking awe-inspiring views of the tropical forest and Pacific Ocean. Spa de Eros offers a range of rejuvenating treatments performed by highly qualified massage therapists. Services include everything from deep tissue massage and body scrubs to a soak in an ocean-view Indonesian tub.</p> <p><img class="aligncenter wp-image-12867 pure-img" src="/assets/3079.jpg" /></p> <p><strong>DRAKE BAY</strong>  Named for Sir Francis Drake, who was believed to have traveled here in the 16th century, Drake Bay is the place for thrill lovers who, like Drake himself, delight in exploring the land.</p> <p><img class="aligncenter wp-image-12862 pure-img" src="/assets/3080.png" /></p> <p><strong>ESCAZU</strong>  In the San José region, Avenida Escazu offers an updated, modern view of Costa Rican life.</p> <p><strong>PLAYAS DEL COCO</strong>  This beach town enjoys its status as a tourist hub. It recently opened a spectacular Hard Rock Cafe.</p> <p><img class="aligncenter wp-image-12863 pure-img" src="/assets/3081.png" /></p> <p><strong>GRECIA</strong>  With beautiful parks and a stunning red cathedral, this traditional Costa Rican town is worth exploring.</p> <p><strong>OSO PENINSULA</strong>  If you came to Costa Rica in search of the rain forest, look no further. This area boasts some of the leafiest landscapes in the world-plus it holds 2.5 percent of the world's biodiversity.</p> <p><img class="aligncenter wp-image-12864 pure-img" src="/assets/3082.png" /></p> <p><strong>EL LAGARTO</strong>  We love this restaurant as much for its tasty barbecue as for its stunning sunset views.</p> <p><strong>CORCOVADO NATIONAL PARK</strong>  Within the limits of this national park, you'll find 13 ecosystems that support all manner of wildlife and vegetation.</p> <p><img class="aligncenter wp-image-12865 pure-img" src="/assets/3083.png" /></p> <p><strong>MUSEO NACIONAL DE COSTA RICA</strong>  Originally a military barracks, this museum opened its doors in 1950 and houses important artifacts from Costa Rican history.</p> <p><strong>PLAYA DANTA</strong>  This popular beach in Las Cantinas is also home to plenty of great restaurants, like La Limonada.</p> <p><img class="aligncenter wp-image-12866 pure-img" src="/assets/3084.png" /></p> <p><strong>COCO LOCO</strong>  While we wouldn't exactly classify it as "Margaritaville," there's a certain je ne sais quoi about this beachfront bar. Order a round of drinks and watch the sun dip into the marine waters.</p> <p><img class="aligncenter wp-image-12861 pure-img" src="/assets/3085.png" /></p>
        • vimeo_id
        • created2016-04-05 14:30:25
        • modified2016-04-11 17:06:15
        • uri/articles/view/442/location-costa-rica
        • flattened_topics(array)
          • 0Voice from the Street
          • 1Beach
      • ParentBrokerage(array)
        • id(null)
        • account_executive_id(null)
        • archived(null)
        • type(null)
        • hide_from_frontend(null)
        • agent_brokerage_data_override(null)
        • featured_development(null)
        • membership_type(null)
        • max_properties(null)
        • max_homepage_featured_by_member_properties(null)
        • featured_properties_sort_method(null)
        • lux_feed_mode(null)
        • max_luxury_feed_properties(null)
        • membership_luxury_feed_properties(null)
        • can_participate_in_lux_feed_while_archived(null)
        • full_training_video_access(null)
        • country_id(null)
        • WOEID(null)
        • timezone(null)
        • luxury_feed_enrollment_mode(null)
        • luxury_feed_include_mlsidx_minimum_price(null)
        • luxury_feed_include_leverage_minimum_price(null)
        • digital_ad_contacts(null)
        • add_agents_to_grr_auto_recipients(null)
        • mlsidx_id(null)
        • mlsidx_lux_autofeed(null)
        • mlsidx_lux_autofeed_minimum_price(null)
        • mlsidx_logo_url(null)
        • mlsidx_disclaimer(null)
        • name(null)
        • broker_of_record_name(null)
        • short_name(null)
        • username(null)
        • password(null)
        • password_reset_hash(null)
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename(null)
        • active(null)
        • lead_in(null)
        • short_description(null)
        • description(null)
        • communities(null)
        • website(null)
        • address(null)
        • address_2(null)
        • city(null)
        • state(null)
        • full_state(null)
        • country(null)
        • market(null)
        • market_2(null)
        • postal_code(null)
        • phone(null)
        • phone_2(null)
        • phone_3(null)
        • wide_contact_image(null)
        • contact_name(null)
        • contact_profile_link(null)
        • contact_big_profile_link(null)
        • contact_big_profile_link_text(null)
        • contact_title(null)
        • contact_dre_num(null)
        • contact_quote(null)
        • contact_email(null)
        • contact_facebook(null)
        • contact_twitter(null)
        • contact_instagram(null)
        • contact_pinterest(null)
        • contact_linkedin(null)
        • contact_youtube(null)
        • contact_phone(null)
        • contact_email_2(null)
        • contact_2_facebook(null)
        • contact_2_twitter(null)
        • contact_2_instagram(null)
        • contact_2_pinterest(null)
        • contact_2_linkedin(null)
        • contact_2_youtube(null)
        • contact_phone_2(null)
        • contact_website(null)
        • contact_name_2(null)
        • contact_profile_link_2(null)
        • contact_big_profile_link_2(null)
        • contact_big_profile_link_text_2(null)
        • contact_title_2(null)
        • contact_dre_num_2(null)
        • contact_email_3(null)
        • contact_name_3(null)
        • contact_title_3(null)
        • contact_dre_num_3(null)
        • contact_phone_3(null)
        • contact_3_facebook(null)
        • contact_3_twitter(null)
        • contact_3_instagram(null)
        • contact_3_pinterest(null)
        • contact_3_linkedin(null)
        • contact_3_youtube(null)
        • image_filename(null)
        • logo_filename(null)
        • contact_image_filename(null)
        • all_properties_link_image_filename(null)
        • all_properties_link(null)
        • video_embed_code(null)
        • contact_video_embed_code(null)
        • meta_title(null)
        • meta_description(null)
        • meta_keywords(null)
        • login_message_counter(null)
        • stats_module_1_type(null)
        • stats_module_1_value(null)
        • stats_module_2_type(null)
        • stats_module_2_value(null)
        • stats_module_3_type(null)
        • stats_module_3_value(null)
        • last_activity_email_sent(null)
        • converted(null)
        • created(null)
        • modified(null)
        • dre_num(null)
        • name_with_location
      • ParentLocation(array)
        • id146
        • parent_id3
        • brokerage_id85
        • typeExclusive
        • archived(false)
        • use_as_topic(true)
        • name San Jose, Costa Rica
        • short_name San Jose, Costa Rica
        • group_index
        • latitude9.928069
        • longitude-84.090729
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_descriptionA unique, happy and caring nation with an international culture.
        • long_descriptionCosta Rica is ranked as one of the most visited international destinations. It is a democratic and peaceful and has not had an army since 1949. The secret still isn’t out that investors have a jewel to discover. Buyers from hot markets like California and Florida see Costa Rica as offering great value in comparison to similar beach real estate in the United States, the Caribbean and Hawaii. Offering an action packed city life, world class beach destinations, surfing, sport fishing, sailing, volcanoes, waterfalls, national parks and over 2% of the world’s biodiversity, Costa Rica has it all.
        • created2016-04-08 14:44:15
        • modified2016-04-14 10:40:03
        • timezoneAmerica/Mexico_City
        • population288054
        • uri/locations/view/146/san-jose-costa-rica
        • tile_name San Jose, Costa Rica
      • Image(array)
        • 0(array)
          • id3086
          • modelArticle
          • model_id442
          • tagImage
          • nameCosta-Rica-1.jpg
          • typeimage/jpg
          • size717936
          • uri/assets/3086.jpg
          • order0
          • created2016-04-05 14:30:27
          • modified2016-04-11 17:06:15
      • Brokerage(array)
        • 0(array)
          • id85
          • account_executive_id235
          • archived(false)
          • typebrokerage
          • hide_from_frontend(false)
          • agent_brokerage_data_override(false)
          • featured_development(false)
          • membership_typePremium
          • max_properties8
          • max_homepage_featured_by_member_properties0
          • featured_properties_sort_methodmanual
          • lux_feed_modeStripeSubscription
          • max_luxury_feed_properties0
          • membership_luxury_feed_properties0
          • can_participate_in_lux_feed_while_archived(false)
          • full_training_video_access(false)
          • country_id15
          • WOEID2345088
          • timezoneUS/Central
          • luxury_feed_enrollment_modemanual
          • luxury_feed_include_mlsidx_minimum_price0
          • luxury_feed_include_leverage_minimum_price0
          • digital_ad_contacts
          • add_agents_to_grr_auto_recipients(true)
          • mlsidx_id
          • mlsidx_lux_autofeed(false)
          • mlsidx_lux_autofeed_minimum_price0
          • mlsidx_logo_url
          • mlsidx_disclaimer
          • namePlantación Properties
          • broker_of_record_name
          • short_namePlantación Properties
          • usernamePlantacionProperties
          • password627b03b998ea7a1eb8df187fba6f4890eef328be
          • password_reset_hash
          • monthly_invoice_amount(null)
          • monthly_invoice_start_date0000-00-00
          • monthly_invoice_end_date0000-00-00
          • contract_filename
          • active(true)
          • lead_in
          • short_description
          • description<p>Plantación Properties is the exclusive representative for Leverage Global Partners in Costa Rica, to include San Jose, Playa Flamingo, Tamarindo, Mal Pais, Santa Teresa, Arenal, Heradura, Manuel Antonio, Osa, Jaco, and Arenal.</p> <p>Plantación Properties, offers to buyers and sellers access to an amplified market of luxury properties in Costa Rica, such as beach front, ocean view, mountain view, estates, land parcels, luxury city homes and condominiums.</p> <p>Through Plantación Properties, buyers and sellers of distinctive levels of quality have access to the amplified marketing efforts of our over 25 years of professional service to the discerning international real estate market.</p> <p>The combined marketing efforts of Plantación Properties and its global partners will provide far reaching exposure to a qualified audience of homeowners and homebuyers for exclusive properties in Costa Rica and beyond.</p>
          • communitiesPlaya Flamingo San Jose Flamingo Tamarindo Mal Pais Santa Teresa Arenal Heradura Manuel Antonio Osa Jaco Guanacaste
          • websitehttp://www.plantacionpropertiescr.com/
          • addressSan Jose
          • address_2
          • cityCosta Rica
          • state
          • full_state
          • countryCosta Rica
          • marketSan Jose
          • market_2
          • postal_code
          • phoneOffice: 1 (506) 2654-4004
          • phone_2Toll Free: 1 (877) 661-2060
          • phone_3
          • wide_contact_image(false)
          • contact_nameRobert Davey
          • contact_profile_link
          • contact_big_profile_linkhttp://www.leveragere.com/blog/meet-robert-davey-plantacion-properties/
          • contact_big_profile_link_text
          • contact_titlePresident
          • contact_dre_num
          • contact_quoteI invite you to contact me personally about Costa Rica Real Estate.
          • contact_email[email protected]
          • contact_facebook
          • contact_twitter
          • contact_instagram
          • contact_pinterest
          • contact_linkedin
          • contact_youtube
          • contact_phone
          • contact_email_2
          • contact_2_facebook
          • contact_2_twitter
          • contact_2_instagram
          • contact_2_pinterest
          • contact_2_linkedin
          • contact_2_youtube
          • contact_phone_2
          • contact_website
          • contact_name_2
          • contact_profile_link_2
          • contact_big_profile_link_2
          • contact_big_profile_link_text_2
          • contact_title_2
          • contact_dre_num_2
          • contact_email_3
          • contact_name_3
          • contact_title_3
          • contact_dre_num_3
          • contact_phone_3
          • contact_3_facebook
          • contact_3_twitter
          • contact_3_instagram
          • contact_3_pinterest
          • contact_3_linkedin
          • contact_3_youtube
          • image_filename85.jpg
          • logo_filename85.png
          • contact_image_filename85.JPG
          • all_properties_link_image_filename85.jpg
          • all_properties_linkhttp://www.plantacionpropertiescr.com/
          • video_embed_code
          • contact_video_embed_code
          • meta_titleCosta Rica Real Estate | Plantación Properties | Leverage Global Partners
          • meta_descriptionPlantación Properties is the exclusive representative for Leverage Global Partners in Costa Rica.
          • meta_keywordsPlantación Properties, Leverage Global Partners, Robert Davey, Playa Flamingo Real Estate, San Jose Real Estate, Flamingo Real Estate, Tamarindo Real Estate, Mal Pais Real Estate, Santa Teresa Real Estate, Arenal Real Estate, Heradura Real Estate, Manuel Antonio Real Estate, Osa Real Estate, Jaco Real Estate, Guanacaste Real Estate
          • login_message_counter0
          • stats_module_1_type
          • stats_module_1_value
          • stats_module_2_type
          • stats_module_2_value
          • stats_module_3_type
          • stats_module_3_value
          • last_activity_email_sent0000-00-00 00:00:00
          • converted(true)
          • created2014-01-22 11:37:46
          • modified2016-04-08 16:34:01
          • dre_num012345
          • uri/brokerage-detail/85/plantaci-n-properties
          • website_shortwww.plantacionpropertiescr.com
          • name_with_locationPlantación Properties
          • ArticlesBrokerage(array)
            • id59
            • article_id442
            • brokerage_id85
      • Location(empty)
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id24
          • nameVoice from the Street
          • created2016-02-25 11:38:06
          • modified2016-02-25 11:38:06
          • tile_nameVoice from the Street
          • ArticlesTopic(array)
            • id359
            • article_id442
            • topic_id24
        • 1(array)
          • id8
          • nameBeach
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:30:26
          • tile_nameBeach
          • ArticlesTopic(array)
            • id358
            • article_id442
            • topic_id8
    • 2(array)
      • Article(array)
        • id259
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(false)
        • large_featured(false)
        • titleTop 10 Ultra Swanky Luxury Condos
        • authorLeverageRE
        • date2014-08-27
        • lead_inThese 10 ultra swanky luxury condos, courtesy of our Leverage Global Partners around the world, are overflowing with ample luxury amenities, utilizing every available space, to give you the feel of a luxurious estate with a little less square footage.
        • body <p>Open the door to your next home.</p> <h1> <strong>Perfectly Positioned Condominium</strong><br> Represented by The Wailea Group  |  $3,795,000</h1> <p><img src="/assets/970.jpg" class="pure-img"></p> <p>Located on over 10 beautifully landscaped acres in Maui, Papali Wailea is a unique 24 residence condominium project perfectly positioned to capture amazing sunsets over the ocean.</p> <h1> <strong>Elegant Waterfront Condo</strong><br> Represented by Carriage Properties  |  $2,950,000</h1> <p><img src="/assets/971.jpg" class="pure-img"></p> <p>One of the most elegant waterfront condominiums in Charleston, South Carolina, this residence offers unique touches such as hand-painted details and a rooftop garden with spectacular views of the harbor.</p> <h1> <strong>Easy Living in Town with Privacy & Views</strong><br> Represented by Old Cashiers Realty  |  $875,000</h1> <p><img src="/assets/972.jpg" class="pure-img"></p> <p>These brand new luxury condos in Cashiers, North Carolina offer easy living and private mountain views, with the convenience of a central location in this popular vacation town.</p> <h1> <strong>Chic Contemporary Waterfront Condo</strong><br> Represented by Shelton & Stewart Realtors  |  $2,595,000</h1> <p><img src="/assets/973.jpg" class="pure-img"></p> <p>Sophisticated interiors lead to a wraparound terrace and views overlooking a glistening lagoon, providing inviting indoor and outdoor entertaining spaces in this Coral Gables, Florida condo.</p> <h1> <strong>Fabulous Oceanfront Condo</strong><br> Represented by Alex MacWilliam, Inc.  |  $2,500,000</h1> <p><img src="/assets/974.jpg" class="pure-img"></p> <p>This West Indies Colonial style condo in Vero Beach, Florida includes gorgeous furnishings, spacious interiors, and a dining area overlooking the ocean.</p> <h1> <strong>Elegant Condominium With Views Like No Other</strong><br> Represented by Ray & Poynor Properties  |  $1,200,000</h1> <p><img src="/assets/975.jpg" class="pure-img"></p> <p>A marble floored entry with a soaring ceiling and exquisite staircase welcomes you into this Birmingham, AL condo, which features elegant touches and views overlooking the city.</p> <h1> <strong>Fully Renovated Hualalai Condo</strong><br> Represented by Mauna Kea Realty  |  $4,895,000</h1> <p><img src="/assets/976.jpg" class="pure-img"></p> <p>Enjoy watching waves break over the golf course in this renovated Big Island, Hawaii condo, which is the closest to the water and the only one at Hualalai to have room service.</p> <h1> <strong>Stunning Walker Tower Condo</strong><br> Represented by CORE  |  $12,250,000</h1> <p><img src="/assets/977.jpg" class="pure-img"></p> <p>This New York City condo has redefined the market and raised the bar for luxury living, with sweeping 180-degree views of the city framed through floor-to-ceiling windows.</p> <h1> <strong>Atlântico Estoril Residence Condominium</strong><br> Represented by Porta da Frente  |  Price Upon Request</h1> <p><img src="/assets/978.jpg" class="pure-img"></p> <p>Atlântico Estoril Residence in Lisbon, Portugal offers interiors that generate a refined and tranquil atmosphere, and Atlantic Ocean views from its large verandas and terraces.</p> <h1> <strong>Aventura Home In the Sky</strong><br> Represented by Turnberry International Realty  |  $1,075,000</h1> <h1><img src="/assets/979.jpg" class="pure-img"></h1> <p>Step out of your private elevator into your own beautiful condo in Aventura, Florida, and enjoy a wraparound balcony and panoramic ocean and bay views from every room.</p> <p>Have you ever dreamed of owning your own luxurious condo? Share your thoughts and leave your comments below.</p>
        • vimeo_id
        • created2016-02-25 14:11:38
        • modified2016-04-05 14:41:07
        • uri/articles/view/259/top-10-ultra-swanky-luxury-condos
        • flattened_topics(array)
          • 0Urban Life
          • 1Ultra Lux
      • ParentBrokerage(array)
        • id(null)
        • account_executive_id(null)
        • archived(null)
        • type(null)
        • hide_from_frontend(null)
        • agent_brokerage_data_override(null)
        • featured_development(null)
        • membership_type(null)
        • max_properties(null)
        • max_homepage_featured_by_member_properties(null)
        • featured_properties_sort_method(null)
        • lux_feed_mode(null)
        • max_luxury_feed_properties(null)
        • membership_luxury_feed_properties(null)
        • can_participate_in_lux_feed_while_archived(null)
        • full_training_video_access(null)
        • country_id(null)
        • WOEID(null)
        • timezone(null)
        • luxury_feed_enrollment_mode(null)
        • luxury_feed_include_mlsidx_minimum_price(null)
        • luxury_feed_include_leverage_minimum_price(null)
        • digital_ad_contacts(null)
        • add_agents_to_grr_auto_recipients(null)
        • mlsidx_id(null)
        • mlsidx_lux_autofeed(null)
        • mlsidx_lux_autofeed_minimum_price(null)
        • mlsidx_logo_url(null)
        • mlsidx_disclaimer(null)
        • name(null)
        • broker_of_record_name(null)
        • short_name(null)
        • username(null)
        • password(null)
        • password_reset_hash(null)
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename(null)
        • active(null)
        • lead_in(null)
        • short_description(null)
        • description(null)
        • communities(null)
        • website(null)
        • address(null)
        • address_2(null)
        • city(null)
        • state(null)
        • full_state(null)
        • country(null)
        • market(null)
        • market_2(null)
        • postal_code(null)
        • phone(null)
        • phone_2(null)
        • phone_3(null)
        • wide_contact_image(null)
        • contact_name(null)
        • contact_profile_link(null)
        • contact_big_profile_link(null)
        • contact_big_profile_link_text(null)
        • contact_title(null)
        • contact_dre_num(null)
        • contact_quote(null)
        • contact_email(null)
        • contact_facebook(null)
        • contact_twitter(null)
        • contact_instagram(null)
        • contact_pinterest(null)
        • contact_linkedin(null)
        • contact_youtube(null)
        • contact_phone(null)
        • contact_email_2(null)
        • contact_2_facebook(null)
        • contact_2_twitter(null)
        • contact_2_instagram(null)
        • contact_2_pinterest(null)
        • contact_2_linkedin(null)
        • contact_2_youtube(null)
        • contact_phone_2(null)
        • contact_website(null)
        • contact_name_2(null)
        • contact_profile_link_2(null)
        • contact_big_profile_link_2(null)
        • contact_big_profile_link_text_2(null)
        • contact_title_2(null)
        • contact_dre_num_2(null)
        • contact_email_3(null)
        • contact_name_3(null)
        • contact_title_3(null)
        • contact_dre_num_3(null)
        • contact_phone_3(null)
        • contact_3_facebook(null)
        • contact_3_twitter(null)
        • contact_3_instagram(null)
        • contact_3_pinterest(null)
        • contact_3_linkedin(null)
        • contact_3_youtube(null)
        • image_filename(null)
        • logo_filename(null)
        • contact_image_filename(null)
        • all_properties_link_image_filename(null)
        • all_properties_link(null)
        • video_embed_code(null)
        • contact_video_embed_code(null)
        • meta_title(null)
        • meta_description(null)
        • meta_keywords(null)
        • login_message_counter(null)
        • stats_module_1_type(null)
        • stats_module_1_value(null)
        • stats_module_2_type(null)
        • stats_module_2_value(null)
        • stats_module_3_type(null)
        • stats_module_3_value(null)
        • last_activity_email_sent(null)
        • converted(null)
        • created(null)
        • modified(null)
        • dre_num(null)
        • name_with_location
      • ParentLocation(array)
        • id(null)
        • parent_id(null)
        • brokerage_id(null)
        • type(null)
        • archived(null)
        • use_as_topic(null)
        • name(null)
        • short_name(null)
        • group_index(null)
        • latitude(null)
        • longitude(null)
        • country_code(null)
        • north(null)
        • south(null)
        • east(null)
        • west(null)
        • zoom(null)
        • short_description(null)
        • long_description(null)
        • created(null)
        • modified(null)
        • timezone(null)
        • population(null)
      • Image(array)
        • 0(array)
          • id980
          • modelArticle
          • model_id259
          • tagImage
          • namePorta-de-Frente-2.jpg
          • typeimage/jpg
          • size296070
          • uri/assets/980.jpg
          • order0
          • created2016-02-25 14:11:39
          • modified2016-03-15 16:25:38
      • Brokerage(empty)
      • Location(empty)
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id5
          • nameUrban Life
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:36:03
          • tile_nameUrban Life
          • ArticlesTopic(array)
            • id145
            • article_id259
            • topic_id5
        • 1(array)
          • id20
          • nameUltra Lux
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:35:37
          • tile_nameUltra Lux
          • ArticlesTopic(array)
            • id146
            • article_id259
            • topic_id20
    • 3(array)
      • Article(array)
        • id466
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(false)
        • large_featured(true)
        • titleLocation: Lisbon
        • authorLeverageRE
        • date2016-03-15
        • lead_inSituated on the north bank of the Tagus River, Lisbon is the only European capital on the Atlantic, which supplies a bounty of fresh seafood to restaurants dishing out menu items varying from fresh and simple to Michelin-starred marvels.
        • body<p>With roots pre-dating Rome, Portugal's largest city is one of Europe's oldest, and home to two UNESCO World Heritage sites, the <a href="http://www.torrebelem.pt/pt/index.php" target="_blank">Belém Tower</a> and the <a href="http://www.mosteirojeronimos.pt/en/" target="_blank">Jerónimos Monas</a><a href="http://www.mosteirojeronimos.pt/en/">tery.</a> The latter is the birthplace of the country's famous custard tart, <em>p</em><em>a</em><em>s</em><em>t</em><em>e</em><em>l de nata</em>.</p> <p>Lisbon's rich history and temperate Mediterranean climate are a major draw for its 600,000 inhabitants, who live within loosely defined <em>bairr</em><em>o</em><em>s</em> (neighborhoods) totaling just 33 square miles.</p> <p>Despite an invasion by Napoléon Bonaparte in the 19th century, three revolutions in the 20th, and a devastating fire in 1988, Baixa Pombalina, the historic city center, is still dominated by elegant Pombaline- style buildings erected after an earthquake leveled much of the city in 1755. The luxury shopping district is Chiado, which includes the mile-long Avenida da Liberdade, where historical villas mix with boutiques.</p> <p>Eating is a perennial favorite pastime, while music festivals dominate the warmer months. (This summer's lineup includes <a href="http://rockinriolisboa.sapo.pt/" target="_blank">Rock in Rio</a> and <a href="http://www.optimusalive.com/en" target="_blank">Optimus Alive</a>.) Besides a rich past, all-star cuisine, and high profile events, here are more reasons to love the city:</p> <p><img class="aligncenter wp-image-12497 pure-img" src="/assets/3227.jpg" /></p> <p><a href="http://sapatariadocarmo.com/" target="_blank">SAPATARIA DO CARMO</a><br /> Red sofas and the smell of leather entice shoppers into this snug shoe store, which opened in 1904. Three generations later, the shoes are still handcrafted from high-quality materials.</p> <p><img class="aligncenter wp-image-12498 pure-img" src="/assets/3228.jpg" /><a href="http://www.avidaportuguesa.com/">A VIDA PORTUGUESA</a><br /> Egg-and-sugar candies in elegant packaging are among the traditional Portuguese specialties available at this Chiado shop.</p> <p><img class="aligncenter wp-image-12499 pure-img" src="/assets/3229.jpg" /></p> <p><a href="http://www.pasteisdebelem.pt/" target="_blank">PASTÉIS DE BELÉM</a><br /> The best place for <em>pastel</em><em> de nata </em>is the source. Just behind the 500-year-old Jerónimos Monastery is the bakery considered the birthplace of the country's famous pastry.</p> <p><img class="aligncenter wp-image-12500 pure-img" src="/assets/3230.jpg" /><a href="http://www.mude.pt/" target="_blank">MUDE</a><br /> Renovation at MUDE, the Museu do Design e da Moda, is a long-term work in progress. Yet the stripped walls add to the backdrop for the museum's collection of furniture and fashion.</p> <p><img class="aligncenter size-full wp-image-12502 pure-img" src="/assets/3231.png" /></p> <p><a href="http://www.christianchaize.com/category/praia-piquinia/" target="_blank">PRAIA PIQUINIA</a><br /> Capturing the beauty of this resort town is a pastime of photographer Christian Chaize, and his dreamy images are the perfect memento.</p> <p><img class="aligncenter wp-image-12501 pure-img" src="/assets/3232.png" /><a href="http://www.memmoalfama.com/hotel-overview.html" target="_blank">MEMMO ALFAMA</a><br /> The narrow cobblestoned street may be hard to find, but newcomer Memmo Alfama (opened in 2013) delivers a boutique design hotel experience from an exclusive riverfront spot in the city's historic center. Local firm Samuel Torres de Carvalho Arquitectos carved out the 42 rooms in the late-19th-century building, adding a rooftop bar and preserving the facade.</p> <p><img class="aligncenter wp-image-12503 pure-img" src="/assets/3233.png" /></p> <p><a href="http://belcanto.pt/EN/" target="_blank">BELCANTO</a><br /> Twice-roasted leg of lamb, suckling pig with oranges, and a wine list more than 350 selections long: those are just three reasons why Michelin-starred Belcanto in Chiado is the hottest restau- rant reservation in town. At the helm since 2012, chef José Avillez lists stints with Ferran Adrià and Alain Ducasse on his résumé.</p> <p><img class="aligncenter wp-image-12504 pure-img" src="/assets/3234.png" /></p> <p><a href="http://www.largo.pt/" target="_blank">LARGO</a><br /> Beneath vaulted ceilings in three large glass tanks mounted in a 30-foot-long wall, dozens of glowing jelly fish roam at Largo, designed by Miguel Cancio Martins. Cod with wild mint bread dumplings and pear and gorgonzola risotto are among the menu items, prepared by chef Miguel Castro e Silva.</p> <p><img class="aligncenter wp-image-12505 pure-img" src="/assets/3235.png" /><a href="http://www.fourseasons.com/lisbon/" target="_blank">FOUR SEASONS HOTEL RITZ LISBON</a><br /> Art Deco and Louis XVI-style furnishings and the city's largest privately owned Portuguese contemporary art collection add pump to this 10-story hilltop hotel, opened in 1959 and managed by Four Seasons since 1998.</p> <p><img class="aligncenter wp-image-12506 pure-img" src="/assets/3236.png" /><a href="http://museu.gulbenkian.pt/Museu/pt/Inicio" target="_blank">GULBENKIAN MUSEUM</a><br /> Totaling more than 6,000 pieces, the eclectic collection of oil magnet Calouste Gulbenkian (1869–1955) spans centuries, countries, and disciplines. Works by Rembrandt, Manet, and Degas are among the items on view.</p> <p><img class="aligncenter wp-image-12507 pure-img" src="/assets/3237.png" /><a href="https://www.facebook.com/Embaixada" target="_blank">EMBAIXADA</a><br /> Carved out of the Palacete Ribeiro da Cunha, a 19th-century Arabian palace included in a massive redevelopment of the Príncipe Real district, this 27,000-square-foot luxury shopping destination opened in 2013. In addition to retailers touting high- quality local wares, Embaixada houses cultural events and art exhibitions.</p>
        • vimeo_id
        • created2016-04-05 14:31:59
        • modified2016-04-12 07:29:33
        • uri/articles/view/466/location-lisbon
        • flattened_topics(array)
          • 0Travel
          • 1Urban Life
      • ParentBrokerage(array)
        • id(null)
        • account_executive_id(null)
        • archived(null)
        • type(null)
        • hide_from_frontend(null)
        • agent_brokerage_data_override(null)
        • featured_development(null)
        • membership_type(null)
        • max_properties(null)
        • max_homepage_featured_by_member_properties(null)
        • featured_properties_sort_method(null)
        • lux_feed_mode(null)
        • max_luxury_feed_properties(null)
        • membership_luxury_feed_properties(null)
        • can_participate_in_lux_feed_while_archived(null)
        • full_training_video_access(null)
        • country_id(null)
        • WOEID(null)
        • timezone(null)
        • luxury_feed_enrollment_mode(null)
        • luxury_feed_include_mlsidx_minimum_price(null)
        • luxury_feed_include_leverage_minimum_price(null)
        • digital_ad_contacts(null)
        • add_agents_to_grr_auto_recipients(null)
        • mlsidx_id(null)
        • mlsidx_lux_autofeed(null)
        • mlsidx_lux_autofeed_minimum_price(null)
        • mlsidx_logo_url(null)
        • mlsidx_disclaimer(null)
        • name(null)
        • broker_of_record_name(null)
        • short_name(null)
        • username(null)
        • password(null)
        • password_reset_hash(null)
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename(null)
        • active(null)
        • lead_in(null)
        • short_description(null)
        • description(null)
        • communities(null)
        • website(null)
        • address(null)
        • address_2(null)
        • city(null)
        • state(null)
        • full_state(null)
        • country(null)
        • market(null)
        • market_2(null)
        • postal_code(null)
        • phone(null)
        • phone_2(null)
        • phone_3(null)
        • wide_contact_image(null)
        • contact_name(null)
        • contact_profile_link(null)
        • contact_big_profile_link(null)
        • contact_big_profile_link_text(null)
        • contact_title(null)
        • contact_dre_num(null)
        • contact_quote(null)
        • contact_email(null)
        • contact_facebook(null)
        • contact_twitter(null)
        • contact_instagram(null)
        • contact_pinterest(null)
        • contact_linkedin(null)
        • contact_youtube(null)
        • contact_phone(null)
        • contact_email_2(null)
        • contact_2_facebook(null)
        • contact_2_twitter(null)
        • contact_2_instagram(null)
        • contact_2_pinterest(null)
        • contact_2_linkedin(null)
        • contact_2_youtube(null)
        • contact_phone_2(null)
        • contact_website(null)
        • contact_name_2(null)
        • contact_profile_link_2(null)
        • contact_big_profile_link_2(null)
        • contact_big_profile_link_text_2(null)
        • contact_title_2(null)
        • contact_dre_num_2(null)
        • contact_email_3(null)
        • contact_name_3(null)
        • contact_title_3(null)
        • contact_dre_num_3(null)
        • contact_phone_3(null)
        • contact_3_facebook(null)
        • contact_3_twitter(null)
        • contact_3_instagram(null)
        • contact_3_pinterest(null)
        • contact_3_linkedin(null)
        • contact_3_youtube(null)
        • image_filename(null)
        • logo_filename(null)
        • contact_image_filename(null)
        • all_properties_link_image_filename(null)
        • all_properties_link(null)
        • video_embed_code(null)
        • contact_video_embed_code(null)
        • meta_title(null)
        • meta_description(null)
        • meta_keywords(null)
        • login_message_counter(null)
        • stats_module_1_type(null)
        • stats_module_1_value(null)
        • stats_module_2_type(null)
        • stats_module_2_value(null)
        • stats_module_3_type(null)
        • stats_module_3_value(null)
        • last_activity_email_sent(null)
        • converted(null)
        • created(null)
        • modified(null)
        • dre_num(null)
        • name_with_location
      • ParentLocation(array)
        • 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)
          • id3238
          • modelArticle
          • model_id466
          • tagImage
          • nameLisbon.jpg
          • typeimage/jpg
          • size1065676
          • uri/assets/3238.jpg
          • order0
          • created2016-04-05 14:32:02
          • modified2016-04-12 07:29:33
      • Brokerage(array)
        • 0(array)
          • id73
          • 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_id13
          • WOEID742676
          • 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_id
          • mlsidx_lux_autofeed(false)
          • mlsidx_lux_autofeed_minimum_price0
          • mlsidx_logo_url
          • mlsidx_disclaimer
          • namePorta da Frente
          • broker_of_record_name
          • short_namePorta da Frente
          • usernamePortadaFrente
          • password32bdc972eb960b1abb44f4c864b114df2b21e383
          • 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>We are excited to announce Porta da Frente as the exclusive representative for Leverage Global Partners in Lisbon, Cascais, and Aletenjo, Portugal.</p> <p>Porta da Frente was born in 1995 with the clear objective of specialising in the medium-high to high segments of the residential property market.</p> <p>Entrepreneurial development and specialisation in this area of business have allowed the widening and diversification of the range of services it offers to its clients, a service of full support to the promoter, with particular emphasis on the after-sale phase, guaranteeing maximum assistance in the selection of the property, its sale/purchase/let, design, architecture, assessment of its true commercial value, finance and fiscal and/or legal advice.</p> <p>Porta da Frente has a solid sales team, comprising approximately 35 individuals comprising a department of short and long-term rentals made up of qualified professionals with a clear vocation for giving dedicated attention to each and every client. Increasing demand in other markets has led to the need to create a department exclusively dedicated to the international market.</p> <p>Talent, dedication, attentiveness, personal service and special treatment are traits that make it stand out against all the other players in the market.</p>
          • communitieslisbon cascais aletenjo
          • websitehttp://www.portadafrente.com/
          • addressAvenida Marginal, 8648 B
          • address_2
          • cityCascais
          • state
          • full_state
          • countryPortugal
          • marketLisbon
          • market_2
          • postal_code
          • phone(351) 214 866-560
          • phone_2
          • phone_3
          • wide_contact_image(false)
          • contact_nameRafael Ascenso
          • contact_profile_link
          • contact_big_profile_link
          • contact_big_profile_link_text
          • contact_titleGeneral Manager
          • 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_filename73.jpg
          • logo_filename73.jpg
          • contact_image_filename73.jpg
          • all_properties_link_image_filename73.jpg
          • all_properties_linkhttp://www.portadafrente.com/engb/properties
          • video_embed_code
          • contact_video_embed_code
          • meta_titleLisbon Real Estate | Porta de Frente | Leverage Global Partners
          • meta_descriptionPorta de Frente is the exclusive representative for Leverage Global Partners in Lisbon, Cascais, and Aletenjo, Portugal.
          • meta_keywordsPorta de Frente, Lisbon, Cascais, and Aletenjo, Portugal real estate, lisbon real estate, golden triangle real estate, lisbon real estate, cascais real estate, aletenjo real estate, leverage global partners, Rafael Ascenso
          • 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-26 18:16:38
          • modified2016-04-08 16:34:01
          • dre_num012345
          • uri/brokerage-detail/73/porta-da-frente
          • website_shortwww.portadafrente.com
          • name_with_locationPorta da Frente
          • ArticlesBrokerage(array)
            • id78
            • article_id466
            • brokerage_id73
      • Location(array)
        • 0(array)
          • id149
          • parent_id4
          • brokerage_id73
          • typeExclusive
          • archived(false)
          • use_as_topic(false)
          • nameLisbon, Portugal
          • short_nameLisbon, Portugal
          • group_index
          • latitude38.722252
          • longitude-9.139337
          • country_code
          • north53.700001
          • south19.700001
          • east-52.599998
          • west-146.600006
          • zoom0
          • short_description
          • long_descriptionMore information coming soon!
          • created2016-04-12 07:28:50
          • modified2016-04-12 07:28:50
          • timezoneEurope/Lisbon
          • population530000
          • uri/locations/view/149/lisbon-portugal
          • tile_nameLisbon, Portugal
          • ArticlesLocation(array)
            • id54
            • article_id466
            • location_id149
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id10
          • nameTravel
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:35:10
          • tile_nameTravel
          • ArticlesTopic(array)
            • id424
            • article_id466
            • topic_id10
        • 1(array)
          • id5
          • nameUrban Life
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:36:03
          • tile_nameUrban Life
          • ArticlesTopic(array)
            • id423
            • article_id466
            • topic_id5
  • sidebar_tiles(array)
    • 0(array)
      • Location(array)
        • id156
        • parent_id7
        • brokerage_id37
        • typeExclusive
        • archived(false)
        • use_as_topic(true)
        • nameNantucket, MA, USA
        • short_nameNantucket, MA, USA
        • group_index
        • latitude41.283470
        • longitude-70.099449
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_description
        • long_descriptionMore information coming soon!
        • created2016-04-12 15:41:00
        • modified2016-04-14 10:55:17
        • timezoneAmerica/New_York
        • population10500
        • uri/locations/view/156/nantucket-ma-usa
        • tile_nameNantucket, MA, USA
      • Brokerage(array)
        • id37
        • 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
        • WOEID2456968
        • 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
        • nameCongdon & Coleman Real Estate
        • broker_of_record_name
        • short_nameCongdon & Coleman
        • usernameCongdonColeman
        • passwordf9492e65b683bc67dda66f994a01ecfb704a5f81
        • 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>Congdon & Coleman Real Estate is the exclusive representative for Leverage Global Partners in Nantucket, Massachusetts, USA.</p> <p><strong>Resident Experts: Nantucket Real Estate & Summer Rentals </strong></p> <p>Congdon & Coleman Real Estate, founded in 1931, is a fourth generation Nantucket business. It is the only combined Nantucket real estate and insurance company on island. Our real estate agents are all Nantucket island residents who are active in the community and committed to preserving the quality of life here. If you choose to invest in Nantucket real estate, rely on the people who know it best.</p> <p>Congdon & Coleman Real Estate is a full service firm handling listing, selling and rentals. Each of our agents is a Realtor and a member of the Cape Cod & Islands Association of Realtors. We are also members of the Nantucket Association of Real Estate Brokers, which gives us accurate, current information on all properties for sale on Nantucket. When you list your property with Congdon & Coleman, inclusion with this service ensures that your property receives maximum exposure to all agents on Nantucket. Simply put, our brokers can show you any Nantucket real estate for sale on the island.</p>
        • communitiesNantucket
        • websitehttp://www.congdonandcoleman.com
        • address57 Main Street
        • address_2
        • cityNantucket
        • stateMA
        • full_stateMassachusetts
        • countryUSA
        • marketNantucket
        • market_2
        • postal_code02554
        • phone(508) 325-5016
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameTom Kennelly
        • contact_profile_link
        • contact_big_profile_linkhttp://www.leveragere.com/blog/meet-tom-kennelly-president-congdon-and-coleman-real-estate/
        • contact_big_profile_link_text
        • contact_titlePresident, Broker
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename37.jpg
        • logo_filename37.png
        • contact_image_filename37.jpg
        • all_properties_link_image_filename37.jpg
        • all_properties_linkhttp://www.congdonandcoleman.com/nantucket-sales/homes.asp
        • video_embed_code
        • contact_video_embed_code
        • meta_titleNantucket Real Estate | Congdon & Coleman Real Estate | Leverage Global Partners
        • meta_descriptionCongdon & Coleman Real Estate is Leverage Global Partners' exclusive representative in Nantucket, MA, USA.
        • meta_keywordsNantucket real estate, Massachusetts real estate, Tom Kennelly, Congdon & Coleman, leverage global partners
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-07-24 14:33:33
        • modified2016-04-08 16:33:30
        • dre_num012345
        • uri/brokerage-detail/37/congdon-coleman-real-estate
        • website_shortwww.congdonandcoleman.com
        • name_with_locationCongdon & Coleman Real Estate
      • Image(array)
        • id20713
        • modelLocation
        • model_id156
        • tagImage
        • nameScreen Shot 2016-04-12 at 3.40.28 PM.png
        • typeimage/png
        • size457517
        • uri/assets/20713.png
        • order0
        • created2016-04-12 15:40:48
        • modified2016-04-14 10:55:17
      • modelLocation
    • 1(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
    • 2(array)
      • Topic(array)
        • id16
        • nameInterior Design
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:32:53
        • tile_nameInterior Design
      • Image(array)
        • id12
        • modelTopic
        • model_id16
        • tagImage
        • nameInterior Design.jpg
        • typeimage/jpeg
        • size22577089
        • uri/assets/12.jpg
        • order0
        • created2016-02-25 11:32:48
        • modified2016-02-25 11:32:53
      • modelTopic
    • 3(array)
      • Topic(array)
        • id6
        • nameCountry Living
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:31:07
        • tile_nameCountry Living
      • Image(array)
        • id4
        • modelTopic
        • model_id6
        • tagImage
        • nameCountry Living.jpg
        • typeimage/jpeg
        • size597489
        • uri/assets/4.jpg
        • order0
        • created2016-02-25 11:31:04
        • modified2016-02-25 11:31:07
      • modelTopic
  • recent_articles(array)
    • 0(array)
      • Article(array)
        • id486
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(true)
        • large_featured(false)
        • titleFashion Trends: Spring 2016
        • authorLeverageRE
        • date2016-04-04
        • lead_inLadies! It's time to do some spring-cleaning to make room for some of this year's most fashionable essentials. So fold up your sweaters and put away your coats. It's time to fill your closet with looks for the most stylish season yet!
        • body<p>Put your own, personal touch on what's happening on the runway. From pleats and ruffles, to playful cuts, dainty laces, sequins and stripes, you, too, can rock the latest crazes with just a few statement pieces. Play a little and mix and match some of your classic pieces with a thing or two of this year's of-the-moment fashion.</p> <p><img class="aligncenter wp-image-12689 pure-img" src="/assets/3342.jpg" /></p> <h3><strong>OFF-THE-SHOULDER</strong></h3> <p>It's all about the shoulders! Seen all over the streets and runways, fashionistas are embracing the vintage vibe of off-the-shoulder silhouettes. Flash just the right amount of skin for a playful, sexy femininity, without being too obvious. Whether it's a top or dress, shoulder cutouts and off-the-shoulder designs make for an effortless and versatile look for any occasion, day or night.</p> <h3><strong>DAYTIME LINGERIE</strong></h3> <p>Lingerie by day is the "it" trend for spring. From lacey slip dresses to camisoles to open-back tops, layering innerwear with outerwear and exposing our undergarments is in. There's a whole lot of skin showing. Pair your sheer silhouette dress with chunky heels, flats or sandals. Contrast the daintiness by adding a vintage T-shirt underneath or throwing on a cardigan to make your look a little more wearable during the day.</p> <p><img class="aligncenter wp-image-12690 pure-img" src="/assets/3343.jpg" /></p> <h3><strong>PLEATS</strong></h3> <p>Pleats on pleats on pleats! Designers have enhanced what used to be a preppy, girlie girl look by adding some structure to sculptured pleats. Add a feminine touch to your wardrobe this season with a pleated dress or skirt. Pair a graphic t-shirt with some sneakers or sandals for a casual day look, or dress it up with a clutch and some heels for a night out on the town.</p> <h3><strong>DENIM</strong></h3> <p>A wardrobe staple, denim is a girl's best friend. For form-flattering shape, comfort and the effortlessness we emanate while wearing it, there's no way to go wrong with denim. Year after year, denim is continuously being reinvented and revived. This year, denim is making a statement! From denim on denim, the jumper, the mini-skirt, patchwork denim and all sorts of different cut jeans, you are sure to work one of these denim trends into your daily style. For a dose of fashion inspiration, check out Harper Bazaar's "<a href="http://www.harpersbazaar.com/fashion/trends/g6994/denim-trends-for-spring/">The 12 Coolest Trends in Denim Now</a>."</p> <p><img class="aligncenter wp-image-12692 pure-img" src="/assets/3344.jpg" /></p> <h3><strong>BUCKET BAGS</strong></h3> <p>No outfit is complete without a fabulous handbag. Spring's go-to carryall adds style and practicality to your daily wear. The "bucket bag" is structured and fashionable, without being over-the-top trendy and obnoxious in size. For a relaxed, casual vibe, go for a bright, beaded version. If you aim for subtlety, try a solid-color leather. With a plethora of different sizes, colors and materials, add the popular bag to your uniform without breaking the bank.</p> <h6><em>J</em><em>Photos courtesy of <a href="http://www.vogue.com/fashion-shows/spring-2016-ready-to-wear/madewell/slideshow/collection" target="_blank">Vogue</a>, <a href="http://www.popsugar.com/fashion/Spring-2016-Trends-Runway-38723166#photo-38727167" target="_blank">Popsugar</a>, <a href="https://www.jcrew.com/womens_feature/NewArrivals/bags.jsp" target="_blank">J.Crew</a></em></h6>
        • vimeo_id
        • created2016-04-05 14:35:20
        • modified2016-04-11 16:58:41
        • uri/articles/view/486/fashion-trends-spring-2016
      • Image(array)
        • 0(array)
          • id3345
          • modelArticle
          • model_id486
          • tagImage
          • nameFashion-blog.jpg
          • typeimage/jpg
          • size668869
          • uri/assets/3345.jpg
          • order0
          • created2016-04-05 14:35:21
          • modified2016-04-11 16:58:41
    • 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)
      • id446
      • modelLocation
      • model_id151
      • archived(false)
      • medium_featured(false)
      • large_featured(true)
      • titleLocation: Manhattan
      • authorLeverageRE
      • date2016-03-24
      • lead_inMade up of five boroughs, New York City has a population of 8.1 million people, making it the largest city in the United States. Often called "the city," Manhattan is the most densely populated borough, and on business days, the population reaches a whopping 5.28 million people. It is home to the financial capital of the world with the NASDAQ, New York Stock Exchange and United Nations.
      • body<p>A major benefit to living in "the city" is having access to virtually everything at any hour of the day. With attractions from dining and drinking to theater shows and live music, Manhattan is at the center of the action in New York City.</p> <p><strong>WALK.</strong>  <a href="http://www.madisonsquarepark.org/" target="_blank">Madison Square Park,</a> landscaped by Ignatz Pilat, a disciple of William Grant and Frederick Law Olmstead, offers people-watching benches, shady strolls through verdant plantings, a dog run, and elegant public monuments.</p> <p><img class="aligncenter wp-image-12804 pure-img" src="/assets/3105.png" /></p> <p><strong>DRESS.  </strong>Ann Taylor, Armani Exchange, Kate Spade, Club Monaco, and many more are only steps away.</p> <p><strong>EAT.  </strong>The Flatiron District is the epicenter of Danny Meyer's restaurant empire, with one of his eateries just a short walk in almost any direction: <a href="http://www.maialinonyc.com/" target="_blank">Maialino</a> (Italian), <a href="http://www.bluesmoke.com/" target="_blank">Blue Smoke</a> (BBQ and jazz), <a href="http://www.gramercytavern.com/" target="_blank">Gramercy Tavern</a> (classic American), <a href="http://unionsquarecafe.com/" target="_blank">Union Square Caf</a><a href="http://unionsquarecafe.com/">é</a> (American-Italian), or <a href="http://www.shakeshack.com/" target="_blank">Shake Shack</a> (burger-and- shake stand).</p> <p><img class="aligncenter wp-image-12806 pure-img" src="/assets/3106.png" /></p> <p><strong>INDULGE.  </strong><a href="http://eisenbergsnyc.com/" target="_blank">Eisenberg's Sandwich Shop</a> has been "raising New York's cholesterol since 1929" with its old-fashioned tuna melts, diner breakfasts, and Jewish classics like pastrami Rueben’s and tongue-on-rye.</p> <p><strong>NEST.  </strong>You're a stone's throw from <a href="http://www.restorationhardware.com/" target="_blank">Restoration Hardware</a>, <a href="http://www.boconcept.com/en-us/" target="_blank">BoConcept</a>, <a href="https://www.abchome.com/" target="_blank">ABC Carpet & Home</a>, <a href="http://www.lillianaugust.com/locations#nyc" target="_blank">Lillian August</a>, and other design shrines.</p> <p><img class="aligncenter wp-image-12803 pure-img" src="/assets/3107.png" /></p>
      • vimeo_id
      • created2016-04-05 14:30:39
      • modified2016-04-14 10:47:35
      • uri/articles/view/446/location-manhattan
      • flattened_topics(array)
        • 0Voice from the Street
        • 1Urban Life
    • ParentBrokerage(array)
      • id(null)
      • account_executive_id(null)
      • archived(null)
      • type(null)
      • hide_from_frontend(null)
      • agent_brokerage_data_override(null)
      • featured_development(null)
      • membership_type(null)
      • max_properties(null)
      • max_homepage_featured_by_member_properties(null)
      • featured_properties_sort_method(null)
      • lux_feed_mode(null)
      • max_luxury_feed_properties(null)
      • membership_luxury_feed_properties(null)
      • can_participate_in_lux_feed_while_archived(null)
      • full_training_video_access(null)
      • country_id(null)
      • WOEID(null)
      • timezone(null)
      • luxury_feed_enrollment_mode(null)
      • luxury_feed_include_mlsidx_minimum_price(null)
      • luxury_feed_include_leverage_minimum_price(null)
      • digital_ad_contacts(null)
      • add_agents_to_grr_auto_recipients(null)
      • mlsidx_id(null)
      • mlsidx_lux_autofeed(null)
      • mlsidx_lux_autofeed_minimum_price(null)
      • mlsidx_logo_url(null)
      • mlsidx_disclaimer(null)
      • name(null)
      • broker_of_record_name(null)
      • short_name(null)
      • username(null)
      • password(null)
      • password_reset_hash(null)
      • monthly_invoice_amount(null)
      • monthly_invoice_start_date(null)
      • monthly_invoice_end_date(null)
      • contract_filename(null)
      • active(null)
      • lead_in(null)
      • short_description(null)
      • description(null)
      • communities(null)
      • website(null)
      • address(null)
      • address_2(null)
      • city(null)
      • state(null)
      • full_state(null)
      • country(null)
      • market(null)
      • market_2(null)
      • postal_code(null)
      • phone(null)
      • phone_2(null)
      • phone_3(null)
      • wide_contact_image(null)
      • contact_name(null)
      • contact_profile_link(null)
      • contact_big_profile_link(null)
      • contact_big_profile_link_text(null)
      • contact_title(null)
      • contact_dre_num(null)
      • contact_quote(null)
      • contact_email(null)
      • contact_facebook(null)
      • contact_twitter(null)
      • contact_instagram(null)
      • contact_pinterest(null)
      • contact_linkedin(null)
      • contact_youtube(null)
      • contact_phone(null)
      • contact_email_2(null)
      • contact_2_facebook(null)
      • contact_2_twitter(null)
      • contact_2_instagram(null)
      • contact_2_pinterest(null)
      • contact_2_linkedin(null)
      • contact_2_youtube(null)
      • contact_phone_2(null)
      • contact_website(null)
      • contact_name_2(null)
      • contact_profile_link_2(null)
      • contact_big_profile_link_2(null)
      • contact_big_profile_link_text_2(null)
      • contact_title_2(null)
      • contact_dre_num_2(null)
      • contact_email_3(null)
      • contact_name_3(null)
      • contact_title_3(null)
      • contact_dre_num_3(null)
      • contact_phone_3(null)
      • contact_3_facebook(null)
      • contact_3_twitter(null)
      • contact_3_instagram(null)
      • contact_3_pinterest(null)
      • contact_3_linkedin(null)
      • contact_3_youtube(null)
      • image_filename(null)
      • logo_filename(null)
      • contact_image_filename(null)
      • all_properties_link_image_filename(null)
      • all_properties_link(null)
      • video_embed_code(null)
      • contact_video_embed_code(null)
      • meta_title(null)
      • meta_description(null)
      • meta_keywords(null)
      • login_message_counter(null)
      • stats_module_1_type(null)
      • stats_module_1_value(null)
      • stats_module_2_type(null)
      • stats_module_2_value(null)
      • stats_module_3_type(null)
      • stats_module_3_value(null)
      • last_activity_email_sent(null)
      • converted(null)
      • created(null)
      • modified(null)
      • dre_num(null)
      • name_with_location
    • ParentLocation(array)
      • id151
      • parent_id7
      • brokerage_id0
      • typeOrganizational
      • archived(false)
      • use_as_topic(true)
      • nameManhattan
      • short_nameManhattan
      • group_index
      • latitude40.783058
      • longitude-73.971252
      • country_code
      • north53.700001
      • south19.700001
      • east-52.599998
      • west-146.600006
      • zoom0
      • short_description
      • long_description
      • created2016-04-12 11:14:03
      • modified2016-04-14 10:47:50
      • timezoneAmerica/New_York
      • population1644518
      • uri/locations/view/151/manhattan
      • tile_nameManhattan
    • Image(array)
      • 0(array)
        • id3108
        • modelArticle
        • model_id446
        • tagImage
        • nameNYC-2.jpg
        • typeimage/jpg
        • size690658
        • uri/assets/3108.jpg
        • order0
        • created2016-04-05 14:30:40
        • modified2016-04-14 10:47:35
    • Brokerage(array)
      • 0(array)
        • id16
        • account_executive_id235
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties20
        • 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
        • WOEID12589342
        • 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
        • nameCORE
        • broker_of_record_name
        • short_nameCORE
        • usernameCORENYC
        • password6bbc31e8f00594b7e3433f0a9c0cd7334bff73ae
        • 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>CORE is the exclusive representative for Leverage Global Partners in New York City, New York, USA.</p> <p>CORE is the leading, full-service, boutique real estate brokerage specializing in the marketing of premiere residential properties. Headquartered in New York City, CORE was founded by CEO Shaun Osher and Jack Cayre, who envisioned a dynamic boutique brokerage based on integrity, informed by expertise and driven by innovation.</p> <p>CORE offers comprehensive real estate solutions for buyers, sellers, landlords, investors and developers. The firm is powered by an integrated team of accomplished professionals with extensive expertise in all aspects of real estate transactions.</p> <p>Thanks to a unique marketing approach, CORE ensures that its clients earn the highest market-driven prices. Our agents educate and shepherd buyers, sellers and landlords through the sales or leasing process. And we partner closely with developers, from the earliest stages of a project through closing; partnerships, which boast a proven, profitable track record. Within the past 8 years, CORE has marketed more than 30 new development properties and is the #1 brokerage in its class.</p>
        • communitiesManhattan Chelsea New York City Tribeca Midtown
        • websitehttp://corenyc.com/
        • address104 Fifth Avenue
        • address_2
        • cityNew York
        • stateNY
        • full_stateNew York
        • countryUSA
        • marketNew York
        • market_2
        • postal_code10011
        • phone(212) 726-0778
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameShaun Osher
        • contact_profile_link
        • contact_big_profile_linkhttp://www.leveragere.com/blog/meet-shaun-osher-founder-and-ceo-of-core/
        • contact_big_profile_link_text
        • contact_titleFounder and CEO
        • contact_dre_num
        • contact_quoteI invite you to contact me personally about New York City real estate.
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename16.jpg
        • logo_filename16.jpg
        • contact_image_filename16.jpg
        • all_properties_link_image_filename16.jpg
        • all_properties_linkhttp://corenyc.com/listings
        • video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/cxxGtpBt-qzxAOUo0.js"></script>
        • contact_video_embed_code
        • meta_titleNew York City Real Estate | CORE | Leverage Global Partners
        • meta_descriptionCORE is Leverage Global Partners' exclusive representative in New York City, NY, USA.
        • meta_keywordsnew york city real estate, manhattan real estate, shaun osher, CORE, leverage global partners
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-04-01 15:35:47
        • modified2019-10-29 20:06:57
        • dre_num012345
        • uri/brokerage-detail/16/core
        • website_shortcorenyc.com
        • name_with_locationCORE
        • ArticlesBrokerage(array)
          • id80
          • article_id446
          • brokerage_id16
    • Location(array)
      • 0(array)
        • id7
        • parent_id1
        • brokerage_id0
        • typeRegion
        • archived(false)
        • use_as_topic(false)
        • nameNortheast
        • short_nameNortheast
        • group_index120
        • latitude42.617790
        • longitude-73.300781
        • country_code
        • north48.111145
        • south38.251553
        • east-64.992577
        • west-81.473045
        • zoom0
        • short_description
        • long_description
        • created2016-03-30 11:09:47
        • modified2016-03-30 11:09:47
        • timezoneAmerica/New_York
        • population0
        • uri/locations/view/7/northeast
        • tile_nameNortheast
        • ArticlesLocation(array)
          • id56
          • article_id446
          • location_id7
    • 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)
          • id431
          • article_id446
          • topic_id24
      • 1(array)
        • id5
        • nameUrban Life
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:36:03
        • tile_nameUrban Life
        • ArticlesTopic(array)
          • id430
          • article_id446
          • topic_id5
  • 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/446/location-manhattan
  Query String
  Request Method	GET
  Server Protocol	HTTP/1.1
  Gateway Interface	CGI/1.1
  Redirect Url	/articles/view/446/location-manhattan
  Remote Port	21377
  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	172.71.28.165
  Server Port	443
  Server Addr	172.24.32.44
  Server Name	staging2.leveragere.com
  Server Software	Apache
  Server Signature
  Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
  Http Host	staging2.leveragere.com
  Http Connection	Keep-Alive
  Http X Forwarded Proto	https
  Http Cf Visitor	{"scheme":"https"}
  Http Cf Ipcountry	US
  Http Cf Connecting Ip	216.73.216.172
  Http Cdn Loop	cloudflare; loops=1
  Http Cf Ray	a09def4a2d0a11f8-CMH
  Http Accept Encoding	gzip, br
  Http Cookie	CAKEPHP=j5ui7knbjjqpecb1423mhj6k41
  Http Accept	*/*
  Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
  Http X Forwarded For	216.73.216.172
  Proxy-nokeepalive	1
  Ssl Tls Sni	staging2.leveragere.com
  Https	on
  Passenger Download Native Support Binary	0
  Passenger Compile Native Support Binary	0
  Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
  Unique Id	aio8G26JJRDGsdfxHgrOoAAAAgA
  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	aio8G26JJRDGsdfxHgrOoAAAAgA
  Fcgi Role	RESPONDER
  Php Self	/index.php
  Request Time Float	1781152795.3061
  Request Time	1781152795

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

  ====