Decadent Dream Homes for 2016

LeverageRE

From mountaintop views and spa-like backyard paradises, to amenities designed for only the most discriminating of tastes, these dream properties from our Leverage Partners are truly fantasy-worthy:

Country Paradise
Presented by Leverage Partner Special Properties

Complete with a multi-waterfall koi pond, pool, hot tub, and nature paths, this custom-built country paradise offers high-end appointments throughout.

Red Mountain Grandeur
Presented by Leverage Partner Shane Aspen Real Estate

This elegant Aspen estate sits on over an acre, with an outdoor heated swimming pool, generous rooms, soaring ceilings, and dramatic views.

Historic Downtown Duplex
Presented by Leverage Partner CORE

At the crossroads of Greenwich Village, the West Village and Soho, this historic downtown NYC duplex features a massive wall of glass opening onto a beautifully planted 500-square-foot terrace.

The Storybook Life Begins in this Castle
Presented by Leverage Partner Partners Trust

Live the dream that is Manhattan Beach in this divinely-appointed French Normandy Chateau-style villa, boasting luxurious amenities including soaring ceilings, an opulent gourmet kitchen, a Hollywood-style movie theatre, and wine cellar.

Martis Camp
Presented by Leverage Partner Tahoe Mountain Realty

Refreshing architecture and clean presentation make this mountain retreat a perfect combination of everything you are looking for in Martis Camp.

Casa Rancho
Presented by Leverage Partner Timothy Real Estate Group

Nestled amid acres of lush tropical gardens in Punta Mita, Mexico, this 42,000 square foot estate offers unparalleled luxury set on 4.5 magnificent private beachfront acres.

Do you dream of living in a luxurious home in 2016? What does your fantasy dream home look like? Please share your thoughts and leave your comments below.

Share

• Topics:
• Ultra Lux

Recent Articles

Home Improvement: True Colors

The UK brand launched past fall, all created using the same age-old production methods that its...

Location: London

London Calling! Synonymous with Big Ben, Westminster Abbey, double-decker buses, and the Royal...

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] => 475
            [model] => Article
            [model_id] => 0
            [archived] => 
            [medium_featured] => 1
            [large_featured] => 1
            [title] => Decadent Dream Homes for 2016
            [author] => LeverageRE
            [date] => 2016-02-27
            [lead_in] => From mountaintop views and spa-like backyard paradises, to amenities designed for only the most discriminating of tastes, these dream properties from our Leverage Partners are truly fantasy-worthy:
            [body] => 
Country Paradise

Presented by Leverage Partner Special Properties



Complete with a multi-waterfall koi pond, pool, hot tub, and nature paths, this custom-built country paradise offers high-end appointments throughout.

Red Mountain Grandeur

Presented by Leverage Partner Shane Aspen Real Estate



This elegant Aspen estate sits on over an acre, with an outdoor heated swimming pool, generous rooms, soaring ceilings, and dramatic views.

Historic Downtown Duplex

Presented by Leverage Partner CORE



At the crossroads of Greenwich Village, the West Village and Soho, this historic downtown NYC duplex features a massive wall of glass opening onto a beautifully planted 500-square-foot terrace.

The Storybook Life Begins in this Castle

Presented by Leverage Partner Partners Trust



Live the dream that is Manhattan Beach in this divinely-appointed French Normandy Chateau-style villa, boasting luxurious amenities including soaring ceilings, an opulent gourmet kitchen, a Hollywood-style movie theatre, and wine cellar.

Martis Camp

Presented by Leverage Partner Tahoe Mountain Realty



Refreshing architecture and clean presentation make this mountain retreat a perfect combination of everything you are looking for in Martis Camp.

Casa Rancho

Presented by Leverage Partner Timothy Real Estate Group



Nestled amid acres of lush tropical gardens in Punta Mita, Mexico, this 42,000 square foot estate offers unparalleled luxury set on 4.5 magnificent private beachfront acres.

Do you dream of living in a luxurious home in 2016? What does your fantasy dream home look like? Please share your thoughts and leave your comments below.

            [vimeo_id] => 
            [created] => 2016-04-05 14:32:12
            [modified] => 2016-04-11 17:03:02
            [uri] => /articles/view/475/decadent-dream-homes-for-2016
            [flattened_topics] => Array
                (
                    [0] => Ultra Lux
                )

        )

    [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] => 
            [parent_id] => 
            [brokerage_id] => 
            [type] => 
            [archived] => 
            [use_as_topic] => 
            [name] => 
            [short_name] => 
            [group_index] => 
            [latitude] => 
            [longitude] => 
            [country_code] => 
            [north] => 
            [south] => 
            [east] => 
            [west] => 
            [zoom] => 
            [short_description] => 
            [long_description] => 
            [created] => 
            [modified] => 
            [timezone] => 
            [population] => 
        )

    [Image] => Array
        (
            [0] => Array
                (
                    [id] => 3288
                    [model] => Article
                    [model_id] => 475
                    [tag] => Image
                    [name] => 23997-1.jpg
                    [type] => image/jpg
                    [size] => 717675
                    [uri] => /assets/3288.jpg
                    [order] => 0
                    [created] => 2016-04-05 14:32:12
                    [modified] => 2016-04-11 17:03:02
                )

        )

    [Brokerage] => Array
        (
            [0] => Array
                (
                    [id] => 214
                    [account_executive_id] => 235
                    [archived] => 
                    [type] => brokerage
                    [hide_from_frontend] => 
                    [agent_brokerage_data_override] => 
                    [featured_development] => 
                    [membership_type] => Basic
                    [max_properties] => 8
                    [max_homepage_featured_by_member_properties] => 0
                    [featured_properties_sort_method] => manual
                    [lux_feed_mode] => StripeSubscription
                    [max_luxury_feed_properties] => 4
                    [membership_luxury_feed_properties] => 0
                    [can_participate_in_lux_feed_while_archived] => 
                    [full_training_video_access] => 
                    [country_id] => 0
                    [WOEID] => 2508245
                    [timezone] => US/Pacific
                    [luxury_feed_enrollment_mode] => manual
                    [luxury_feed_include_mlsidx_minimum_price] => 0
                    [luxury_feed_include_leverage_minimum_price] => 0
                    [digital_ad_contacts] => 
                    [add_agents_to_grr_auto_recipients] => 1
                    [mlsidx_id] => 
                    [mlsidx_lux_autofeed] => 
                    [mlsidx_lux_autofeed_minimum_price] => 0
                    [mlsidx_logo_url] => 
                    [mlsidx_disclaimer] => 
                    [name] => Tahoe Mountain Realty
                    [broker_of_record_name] => 
                    [short_name] => Tahoe Mountain Realty
                    [username] => TahoeMountainRealty
                    [password] => 4cef6eba416704066d3a8b841f2c8f2c4c322fea
                    [password_reset_hash] => 
                    [monthly_invoice_amount] => 
                    [monthly_invoice_start_date] => 
                    [monthly_invoice_end_date] => 
                    [contract_filename] => 
                    [active] => 1
                    [lead_in] => 
                    [short_description] => 
                    [description] => 
Tahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, Northstar, Mountainside at Northstar, Lahontan, Schaffer's Mill, Old Greenwood, and Gray's Crossing, CA, USA.

They are the leading brokerage for high end boutique luxury real estate with expertise in the most sought after resort communities and Tahoe lakefront properties in the North Tahoe region.

TAHOE MARKET EXPERTS

With a team of over 20 real estate professionals who love living the Tahoe life and enjoy helping others find their Tahoe dream, TMR is pleased to help you and your family with all your Tahoe real estate needs.

Our successful sales history begins with our absolute focus on client service and includes many market advantages, such as, our high-traffic sales galleries in The Village at Northstar, The Ritz-Carlton, Gray's Crossing and Old Greenwood, the area’s largest and most productive database of prospective buyers and data driven marketing programs.

                    [communities] => Truckee
Northstar
Mountainside at Northstar
Lahontan
Schaffer's Mill
Old Greenwood
Gray's Crossing
                    [website] => http://www.tmrrealestate.com/
                    [address] => 3001 Northstar Drive Suite 100 
                    [address_2] => PO Box 3757
                    [city] => Truckee
                    [state] => CA
                    [full_state] => California
                    [country] => USA
                    [market] => Truckee, Lake Tahoe
                    [market_2] => 
                    [postal_code] => 96160
                    [phone] => (530) 550-2000 
                    [phone_2] => 
                    [phone_3] => 
                    [wide_contact_image] => 
                    [contact_name] => Tahoe Market Experts
                    [contact_profile_link] => 
                    [contact_big_profile_link] => http://www.leveragere.com/leverage-lifestyle/meet-tahoe-mountain-realty/
                    [contact_big_profile_link_text] => Meet The Team at Tahoe Mountain Realty
                    [contact_title] => Luxury Real Estate Professionals
                    [contact_dre_num] => 
                    [contact_quote] => We invite you to contact us about Truckee, Lake Tahoe 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] => 214.jpg
                    [logo_filename] => 214.png
                    [contact_image_filename] => 214.jpg
                    [all_properties_link_image_filename] => 214.jpg
                    [all_properties_link] => http://tahoemountainrealty.idxbroker.com/idx/featured
                    [video_embed_code] => 
                    [contact_video_embed_code] => 
                    [meta_title] => Truckee Real Estate⎜Tahoe Mountain Realty⎜Leverage Global Partners
                    [meta_description] => Tahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, CA, USA.
                    [meta_keywords] => Tahoe Mountain Realty, Truckee Real Estate, Northstar Real Estate, Mountainside at Northstar Real Estate, Lahontan Real Estate, Schaffer's Mill Real Estate, Old Greenwood Real Estate, Gray's Crossing Real Estate, California Real Estate, Leverage Global Partners, Jeff Brown
                    [login_message_counter] => 1
                    [stats_module_1_type] => 
                    [stats_module_1_value] => 
                    [stats_module_2_type] => 
                    [stats_module_2_value] => 
                    [stats_module_3_type] => 
                    [stats_module_3_value] => 
                    [last_activity_email_sent] => 0000-00-00 00:00:00
                    [converted] => 1
                    [created] => 2015-07-21 10:20:40
                    [modified] => 2016-04-08 16:34:26
                    [dre_num] => 012345
                    [uri] => /brokerage-detail/214/tahoe-mountain-realty
                    [website_short] => www.tmrrealestate.com
                    [name_with_location] => Tahoe Mountain Realty
                    [ArticlesBrokerage] => Array
                        (
                            [id] => 53
                            [article_id] => 475
                            [brokerage_id] => 214
                        )

                )

            [1] => Array
                (
                    [id] => 206
                    [account_executive_id] => 235
                    [archived] => 
                    [type] => brokerage
                    [hide_from_frontend] => 
                    [agent_brokerage_data_override] => 
                    [featured_development] => 
                    [membership_type] => Basic
                    [max_properties] => 8
                    [max_homepage_featured_by_member_properties] => 0
                    [featured_properties_sort_method] => manual
                    [lux_feed_mode] => StripeSubscription
                    [max_luxury_feed_properties] => 0
                    [membership_luxury_feed_properties] => 0
                    [can_participate_in_lux_feed_while_archived] => 
                    [full_training_video_access] => 
                    [country_id] => 0
                    [WOEID] => 2486435
                    [timezone] => US/Eastern
                    [luxury_feed_enrollment_mode] => manual
                    [luxury_feed_include_mlsidx_minimum_price] => 0
                    [luxury_feed_include_leverage_minimum_price] => 0
                    [digital_ad_contacts] => 
                    [add_agents_to_grr_auto_recipients] => 1
                    [mlsidx_id] => 
                    [mlsidx_lux_autofeed] => 
                    [mlsidx_lux_autofeed_minimum_price] => 0
                    [mlsidx_logo_url] => 
                    [mlsidx_disclaimer] => 
                    [name] => Special Properties
                    [broker_of_record_name] => 
                    [short_name] => Special Properties
                    [username] => SpecialProperties
                    [password] => 80bff9ecdfafd4cb525f795d439c9f6d73b691dd
                    [password_reset_hash] => 
                    [monthly_invoice_amount] => 
                    [monthly_invoice_start_date] => 
                    [monthly_invoice_end_date] => 
                    [contract_filename] => 
                    [active] => 1
                    [lead_in] => 
                    [short_description] => 
                    [description] => 
Special Properties is the exclusive representative for Leverage Global Partners in Allendale, Alpine, Cliffside Park, Cresskill, Demarest, Edgewater, Englewood, Englewood Cliffs, Fort Lee, Franklin Lakes, Ho Ho Kus, Mahwah, Oakland, Old Tappan, Ramsey, Ridgewood, Saddle River, Tenafly, Upper Saddle River, Woodcliff Lake, Wyckoff, NJ USA.

Special Properties, Division of Brook Hollow Group, Inc. Realtors is a Real Estate brokerage firm located in Saddle River, NJ, serving New Jersey and New York. Established in 1992, we specialize in the marketing and selling of luxury properties. We market at the highest level and offer a full range of real estate services. Our Realtor Associates and our staff are highly experienced and operate at an unparalleled level.

We are pleased to announce the opening of 2 new offices in Mahwah and Franklin Lakes, New Jersey. Please contact us to find out more information regarding Special Properties Real Estate Services, LLC.

Our exclusive affiliation with Christie’s International Real Estate for Northwest Bergen County offers us the ability to relocate our clients anywhere in the world at the same high standard they expect in doing business with us.

Our newest affiliation with Leverage Global Partners is adding to our network of affiliates who have the same high level of marketing and service standards that we do. We are very excited about this new relationship. We have exclusive affiliations with several magazine publications which are national as well as New York City/Metropolitan area based.

Contact us for additional information about our extensive marketing program, our exclusive listings as well as all multiple listed properties on our website.

                    [communities] => Saddle River
Bergen County
Allendale
Alpine
Cliffside Park
Cresskill
Demarest 
Edgewater
Englewood
Englewood Cliffs
Fort Lee
Franklin Lakes
Ho Ho Kus
Mahwah
Oakland
Old Tappan
Ramsey
Ridgewood
Saddle River
Tenafly
Upper Saddle River
Woodcliff Lake
Wyckoff

                    [website] => http://www.specialproperties.com/
                    [address] => 158 West Saddle River Road
                    [address_2] => 
                    [city] => Saddle River
                    [state] => NJ
                    [full_state] => New Jersey
                    [country] => USA
                    [market] => 
                    [market_2] => 
                    [postal_code] => 07458
                    [phone] => Office: (201) 934-7111
                    [phone_2] => Cell: (201) 390-5880
                    [phone_3] => 
                    [wide_contact_image] => 
                    [contact_name] => Vicki Gaily
                    [contact_profile_link] => 
                    [contact_big_profile_link] => 
                    [contact_big_profile_link_text] => 
                    [contact_title] => Co Owner
                    [contact_dre_num] => 
                    [contact_quote] => 
                    [contact_email] => [email protected]
                    [contact_facebook] => 
                    [contact_twitter] => 
                    [contact_instagram] => 
                    [contact_pinterest] => 
                    [contact_linkedin] => 
                    [contact_youtube] => 
                    [contact_phone] => 
                    [contact_email_2] => 
                    [contact_2_facebook] => 
                    [contact_2_twitter] => 
                    [contact_2_instagram] => 
                    [contact_2_pinterest] => 
                    [contact_2_linkedin] => 
                    [contact_2_youtube] => 
                    [contact_phone_2] => 
                    [contact_website] => 
                    [contact_name_2] => 
                    [contact_profile_link_2] => 
                    [contact_big_profile_link_2] => 
                    [contact_big_profile_link_text_2] => 
                    [contact_title_2] => 
                    [contact_dre_num_2] => 
                    [contact_email_3] => 
                    [contact_name_3] => 
                    [contact_title_3] => 
                    [contact_dre_num_3] => 
                    [contact_phone_3] => 
                    [contact_3_facebook] => 
                    [contact_3_twitter] => 
                    [contact_3_instagram] => 
                    [contact_3_pinterest] => 
                    [contact_3_linkedin] => 
                    [contact_3_youtube] => 
                    [image_filename] => 206.jpg
                    [logo_filename] => 206.jpg
                    [contact_image_filename] => 206.jpg
                    [all_properties_link_image_filename] => 206.jpg
                    [all_properties_link] => http://www.specialproperties.com/sales/usa/broker-listings-dstype
                    [video_embed_code] => 
                    [contact_video_embed_code] => 
                    [meta_title] => Saddle River Real Estate | Special Properties | Leverage Global Partners
                    [meta_description] => Special Properties is the exclusive representative for Leverage Global Partners in Saddle River including all of Bergen County, NJ USA.
                    [meta_keywords] => Special Properties, Saddle River real estate, Bergen County real estate, North Jersey real estate
                    [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] => 2015-06-18 09:41:48
                    [modified] => 2016-04-08 16:34:26
                    [dre_num] => 012345
                    [uri] => /brokerage-detail/206/special-properties
                    [website_short] => www.specialproperties.com
                    [name_with_location] => Special Properties
                    [ArticlesBrokerage] => Array
                        (
                            [id] => 52
                            [article_id] => 475
                            [brokerage_id] => 206
                        )

                )

            [2] => Array
                (
                    [id] => 104
                    [account_executive_id] => 236
                    [archived] => 
                    [type] => brokerage
                    [hide_from_frontend] => 
                    [agent_brokerage_data_override] => 
                    [featured_development] => 
                    [membership_type] => Premium
                    [max_properties] => 8
                    [max_homepage_featured_by_member_properties] => 0
                    [featured_properties_sort_method] => manual
                    [lux_feed_mode] => StripeSubscription
                    [max_luxury_feed_properties] => 4
                    [membership_luxury_feed_properties] => 0
                    [can_participate_in_lux_feed_while_archived] => 
                    [full_training_video_access] => 
                    [country_id] => 0
                    [WOEID] => 137895
                    [timezone] => US/Central
                    [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] => Timothy Real Estate Group
                    [broker_of_record_name] => 
                    [short_name] => Timothy Real Estate Group
                    [username] => TimothyRealEstate
                    [password] => 6641f951de5e691deddeb17430232d757e8f463b
                    [password_reset_hash] => 
                    [monthly_invoice_amount] => 0.00
                    [monthly_invoice_start_date] => 
                    [monthly_invoice_end_date] => 
                    [contract_filename] => 
                    [active] => 1
                    [lead_in] => 
                    [short_description] => 
                    [description] => 
Timothy Real Estate Group is the exclusive representative for Levergae Global Partners in Puerto Vallarta, Punta de Mita, Riviera Nayarit, Bay of Banderas, Mexico.
Timothy Real Estate Group is a locally owned and operated full service real estate brokerage. We have the finest, most professionally trained estate agents in he Bay of Banderas. Throughout changing markets we have established our position as the consistent leader is sales volume and listing inventory year after year.
Because the Puerto Vallarta area has varying neighborhood personalities, we practice localized real estate service. We believe understanding neighborhoods is a top factor in satisfaction with your investment, and we know our communities well.
We enable our clients to realize their vision for the future. We understand and plan for their concerns and are dedicated to transforming those concerns into peace of mind and joy.
Our philosophy of transparency, integrity, and professionalism permeates our culture with a tangible sense of purpose and results in the length and depth of the quality relationships we enjoy. We believe buying or selling a home is first and foremost about people. Of course we have the latest technology, marketing tools, statistics and research, but a successful real estate transaction really comes down to people. We believe in collaboration by connecting people in ways that bring satisfaction and happiness.
When you combine extensive local knowledge and our long standing reputation for honesty and sound judgment, you have an unbeatable resource at your disposal. You have Timothy Real Estate Group, a constant leader in Puerto Vallarta real estate.
                    [communities] => Puerto Vallarta
Punta de Mita
Riviera Nayarit
Bay of Banderas
                    [website] => http://www.timothyrealestategroup.com/
                    [address] => Ignacio L. Vallarta 130 Local 7
                    [address_2] => Col. Emiliano Zapata
                    [city] =>  Puerto Vallarta
                    [state] => 
                    [full_state] => 
                    [country] => Mexico
                    [market] =>  Puerto Vallarta
                    [market_2] => 
                    [postal_code] => 48380
                    [phone] => (322) 223-5300
                    [phone_2] => 
                    [phone_3] => 
                    [wide_contact_image] => 
                    [contact_name] => Carl Timothy
                    [contact_profile_link] => 
                    [contact_big_profile_link] => 
                    [contact_big_profile_link_text] => 
                    [contact_title] => President
                    [contact_dre_num] => 
                    [contact_quote] => 
                    [contact_email] => [email protected]
                    [contact_facebook] => 
                    [contact_twitter] => 
                    [contact_instagram] => 
                    [contact_pinterest] => 
                    [contact_linkedin] => 
                    [contact_youtube] => 
                    [contact_phone] => 
                    [contact_email_2] => 
                    [contact_2_facebook] => 
                    [contact_2_twitter] => 
                    [contact_2_instagram] => 
                    [contact_2_pinterest] => 
                    [contact_2_linkedin] => 
                    [contact_2_youtube] => 
                    [contact_phone_2] => 
                    [contact_website] => 
                    [contact_name_2] => 
                    [contact_profile_link_2] => 
                    [contact_big_profile_link_2] => 
                    [contact_big_profile_link_text_2] => 
                    [contact_title_2] => 
                    [contact_dre_num_2] => 
                    [contact_email_3] => 
                    [contact_name_3] => 
                    [contact_title_3] => 
                    [contact_dre_num_3] => 
                    [contact_phone_3] => 
                    [contact_3_facebook] => 
                    [contact_3_twitter] => 
                    [contact_3_instagram] => 
                    [contact_3_pinterest] => 
                    [contact_3_linkedin] => 
                    [contact_3_youtube] => 
                    [image_filename] => 104.jpg
                    [logo_filename] => 104.png
                    [contact_image_filename] => 104.jpg
                    [all_properties_link_image_filename] => 104.jpg
                    [all_properties_link] => http://www.timothyrealestategroup.com/property-list/
                    [video_embed_code] => 
                    [contact_video_embed_code] => 
                    [meta_title] => Puerto Vallarta Real Estate | Timothy Real Estate Group | Leverage Global Partners
                    [meta_description] => Timothy Real Estate Group is the exclusive representative for Leverage Global Partners in Puerto Vallarta, Mexico.
                    [meta_keywords] => Timothy Real Estate Group, Puerto Vallarta Real Estate, Carl Timothy, Puerto Vallarta Punta de Mita Riviera Nayarit Bay of Banderas Real Estate, Puetro Vallarta, 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] => 2014-03-25 17:36:50
                    [modified] => 2016-04-08 16:34:09
                    [dre_num] => 012345
                    [uri] => /brokerage-detail/104/timothy-real-estate-group
                    [website_short] => www.timothyrealestategroup.com
                    [name_with_location] => Timothy Real Estate Group
                    [ArticlesBrokerage] => Array
                        (
                            [id] => 51
                            [article_id] => 475
                            [brokerage_id] => 104
                        )

                )

            [3] => Array
                (
                    [id] => 4
                    [account_executive_id] => 236
                    [archived] => 
                    [type] => brokerage
                    [hide_from_frontend] => 
                    [agent_brokerage_data_override] => 
                    [featured_development] => 
                    [membership_type] => Premium
                    [max_properties] => 12
                    [max_homepage_featured_by_member_properties] => 0
                    [featured_properties_sort_method] => manual
                    [lux_feed_mode] => StripeSubscription
                    [max_luxury_feed_properties] => 1
                    [membership_luxury_feed_properties] => 0
                    [can_participate_in_lux_feed_while_archived] => 
                    [full_training_video_access] => 1
                    [country_id] => 1
                    [WOEID] => 2488892
                    [timezone] => US/Pacific
                    [luxury_feed_enrollment_mode] => manual
                    [luxury_feed_include_mlsidx_minimum_price] => 0
                    [luxury_feed_include_leverage_minimum_price] => 0
                    [digital_ad_contacts] => 
                    [add_agents_to_grr_auto_recipients] => 1
                    [mlsidx_id] => 
                    [mlsidx_lux_autofeed] => 
                    [mlsidx_lux_autofeed_minimum_price] => 0
                    [mlsidx_logo_url] => 
                    [mlsidx_disclaimer] => 
                    [name] => Partners Trust Real Estate Brokerage and Acquisitions
                    [broker_of_record_name] => 
                    [short_name] => Partners Trust Real Estate
                    [username] => PartnersTrustSM
                    [password] => 74c7d5ff6cf0a7cb1e382c45ff916c0d15196817
                    [password_reset_hash] => 
                    [monthly_invoice_amount] => 
                    [monthly_invoice_start_date] => 0000-00-00
                    [monthly_invoice_end_date] => 0000-00-00
                    [contract_filename] => 
                    [active] => 1
                    [lead_in] => 
                    [short_description] => 
                    [description] => 
Partners Trust is the exclusive representative for Leverage Global Partners in Santa Monica, California, USA.

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.

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.

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.

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

                    [communities] => Santa Monica 
Marina Del Rey 
Venice 
Mar Vista 
Pacific Palisades 

                    [website] => http://www.thepartnerstrust.com
                    [address] => 1333 Montana Avenue
                    [address_2] => 
                    [city] => Santa Monica
                    [state] => CA
                    [full_state] => California
                    [country] => USA
                    [market] => Santa Monica
                    [market_2] => 
                    [postal_code] => 90403
                    [phone] => (310) 500-1307
                    [phone_2] => (310) 505-9420
                    [phone_3] => 
                    [wide_contact_image] => 
                    [contact_name] => Scott Carmody
                    [contact_profile_link] => 
                    [contact_big_profile_link] => http://www.leveragere.com/blog/meet-scott-carmody-managing-director-partners-trust-santa-monica/
                    [contact_big_profile_link_text] => 
                    [contact_title] => Managing Director
                    [contact_dre_num] => 
                    [contact_quote] => 
                    [contact_email] => [email protected]
                    [contact_facebook] => 
                    [contact_twitter] => 
                    [contact_instagram] => 
                    [contact_pinterest] => 
                    [contact_linkedin] => 
                    [contact_youtube] => 
                    [contact_phone] => 
                    [contact_email_2] => 
                    [contact_2_facebook] => 
                    [contact_2_twitter] => 
                    [contact_2_instagram] => 
                    [contact_2_pinterest] => 
                    [contact_2_linkedin] => 
                    [contact_2_youtube] => 
                    [contact_phone_2] => 
                    [contact_website] => 
                    [contact_name_2] => Nick Segal
                    [contact_profile_link_2] => http://www.leveragere.com/brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions
                    [contact_big_profile_link_2] => 
                    [contact_big_profile_link_text_2] => 
                    [contact_title_2] => President/Co-Founder
                    [contact_dre_num_2] => 
                    [contact_email_3] => 
                    [contact_name_3] => 
                    [contact_title_3] => 
                    [contact_dre_num_3] => 
                    [contact_phone_3] => 
                    [contact_3_facebook] => 
                    [contact_3_twitter] => 
                    [contact_3_instagram] => 
                    [contact_3_pinterest] => 
                    [contact_3_linkedin] => 
                    [contact_3_youtube] => 
                    [image_filename] => 4.jpg
                    [logo_filename] => 4.png
                    [contact_image_filename] => 4.JPG
                    [all_properties_link_image_filename] => 4.jpg
                    [all_properties_link] => http://www.thepartnerstrust.com/properties
                    [video_embed_code] => 
                    [contact_video_embed_code] => 
                    [meta_title] => Santa Monica Real Estate | Partners Trust Real Estate Brokerage and Acquisitions | Leverage Global Partners
                    [meta_description] => Partners 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_keywords] => partners trust, partners trust real estate, santa monica real estate, santa monica real estate agents, scott carmody, leverage global partners
                    [login_message_counter] => 3
                    [stats_module_1_type] => 
                    [stats_module_1_value] => 
                    [stats_module_2_type] => 
                    [stats_module_2_value] => 
                    [stats_module_3_type] => 
                    [stats_module_3_value] => 
                    [last_activity_email_sent] => 0000-00-00 00:00:00
                    [converted] => 1
                    [created] => 2013-03-18 15:36:48
                    [modified] => 2016-04-08 16:33:22
                    [dre_num] => 012345
                    [uri] => /brokerage-detail/4/partners-trust-real-estate-brokerage-and-acquisitions
                    [website_short] => www.thepartnerstrust.com
                    [name_with_location] => Partners Trust Real Estate Brokerage and Acquisitions
                    [ArticlesBrokerage] => Array
                        (
                            [id] => 50
                            [article_id] => 475
                            [brokerage_id] => 4
                        )

                )

            [4] => 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] => 49
                            [article_id] => 475
                            [brokerage_id] => 16
                        )

                )

        )

    [Location] => Array
        (
        )

    [Property] => Array
        (
        )

    [Topic] => Array
        (
            [0] => Array
                (
                    [id] => 20
                    [name] => Ultra Lux
                    [created] => 2016-02-25 11:25:00
                    [modified] => 2016-02-25 11:35:37
                    [tile_name] => Ultra Lux
                    [ArticlesTopic] => Array
                        (
                            [id] => 343
                            [article_id] => 475
                            [topic_id] => 20
                        )

                )

        )

)

• 
• History
  +

  Request History

  4 previous requests available

  • Restore to current request
  • contacts/ajax_form?agent_id=1049
  • contacts/ajax_form?agent_id=1050
  • agent-detail/332/ann-pettit
  • locations/view/22/madison-wi-usa

  ====
• Session
  +

  Session

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

  ====
• Request
  +

  Request

  Cake Params

  • plugin(null)
  • controllerarticles
  • actionview
  • named(empty)
  • pass(array)
    • 0475
    • 1decadent-dream-homes-for-2016
  • isAjax(false)

  Post data

  No post data.

  Query string

  No querystring data.

  Cookie

  • 0(empty)

  Current Route

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

  ====
• Sql Log
  +

  Sql Logs

  default

  Total Time: 18 ms
  Total Queries: 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` = 475 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` = (475) 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` = 475 AND `ArticlesBrokerage`.`brokerage_id` = `Brokerage`.`id`)	5	5	1	maybe slow
  SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `ArticlesLocation`.`id`, `ArticlesLocation`.`article_id`, `ArticlesLocation`.`location_id` FROM `leveragere_staging2`.`locations` AS `Location` JOIN `leveragere_staging2`.`articles_locations` AS `ArticlesLocation` ON (`ArticlesLocation`.`article_id` = 475 AND `ArticlesLocation`.`location_id` = `Location`.`id`)	0	0	0
  SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created`, `ArticlesProperty`.`id`, `ArticlesProperty`.`article_id`, `ArticlesProperty`.`property_id` FROM `leveragere_staging2`.`properties` AS `Property` JOIN `leveragere_staging2`.`articles_properties` AS `ArticlesProperty` ON (`ArticlesProperty`.`article_id` = 475 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` = 475 AND `ArticlesTopic`.`topic_id` = `Topic`.`id`)	1	1	0
  SELECT `Article`.`id` FROM `leveragere_staging2`.`articles` AS `Article` WHERE `Article`.`archived` = '0' AND NOT (`Article`.`model` = ('News')) ORDER BY `Article`.`date` DESC LIMIT 10	10	10	1	maybe slow
  SELECT `Article`.`id`, `Article`.`model`, `Article`.`model_id`, `Article`.`archived`, `Article`.`medium_featured`, `Article`.`large_featured`, `Article`.`title`, `Article`.`author`, `Article`.`date`, `Article`.`lead_in`, `Article`.`body`, `Article`.`vimeo_id`, `Article`.`created`, `Article`.`modified` FROM `leveragere_staging2`.`articles` AS `Article` WHERE `Article`.`id` IN (499, 486, 488, 487, 436, 476, 437, 477, 481, 479) ORDER BY RAND() ASC LIMIT 2	2	2	1	maybe slow
  SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (437, 479) 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` = 475 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` = (475) 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` = 475 AND `ArticlesBrokerage`.`brokerage_id` = `Brokerage`.`id`)	5	5	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` = 475 AND `ArticlesLocation`.`location_id` = `Location`.`id`)	0	0	0
  SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created`, `ArticlesProperty`.`id`, `ArticlesProperty`.`article_id`, `ArticlesProperty`.`property_id` FROM `leveragere_staging2`.`properties` AS `Property` JOIN `leveragere_staging2`.`articles_properties` AS `ArticlesProperty` ON (`ArticlesProperty`.`article_id` = 475 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` = 475 AND `ArticlesTopic`.`topic_id` = `Topic`.`id`)	1	1	0
  SELECT `ArticlesTopic`.`id`, `ArticlesTopic`.`article_id` FROM `leveragere_staging2`.`articles_topics` AS `ArticlesTopic` WHERE `ArticlesTopic`.`topic_id` = (20)	29	29	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 (434, 414, 388, 382, 363, 357, 328, 323, 322, 300, 292, 288, 280, 276, 259, 246, 242, 239, 224, 216, 211, 204, 200, 198, 190, 174, 451, 469, 475) AND `Article`.`id` != 475 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 (242, 259, 200, 363) 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 (242, 259, 200, 363) AND `ArticlesBrokerage`.`brokerage_id` = `Brokerage`.`id`)	0	0	0
  SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `ArticlesLocation`.`id`, `ArticlesLocation`.`article_id`, `ArticlesLocation`.`location_id` FROM `leveragere_staging2`.`locations` AS `Location` JOIN `leveragere_staging2`.`articles_locations` AS `ArticlesLocation` ON (`ArticlesLocation`.`article_id` IN (242, 259, 200, 363) AND `ArticlesLocation`.`location_id` = `Location`.`id`)	0	0	0
  SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created`, `ArticlesProperty`.`id`, `ArticlesProperty`.`article_id`, `ArticlesProperty`.`property_id` FROM `leveragere_staging2`.`properties` AS `Property` JOIN `leveragere_staging2`.`articles_properties` AS `ArticlesProperty` ON (`ArticlesProperty`.`article_id` IN (242, 259, 200, 363) 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 (242, 259, 200, 363) AND `ArticlesTopic`.`topic_id` = `Topic`.`id`)	6	6	0
  SELECT `Property`.`id` FROM `leveragere_staging2`.`properties` AS `Property` WHERE `Property`.`archived` = '0' AND `Property`.`incomplete` = '0' ORDER BY `Property`.`created` DESC LIMIT 50	50	50	4	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 (3714, 3727, 3717, 3747) ORDER BY `Image`.`order` ASC	38	38	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 (3714, 3727, 3717, 3747) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	5	5	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 (3714, 3727, 3717, 3747) 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 (3714, 3727, 3717, 3747) 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 (3714, 3727, 3717, 3747) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	1	1	0

  6 duplicate queries run.

  Query Explain:

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

  ====
• Timer
  +

  Memory

  Peak Memory Use 11.39 MB

  Message	Memory use
  Component initialization	2.91 MB
  Controller action start	3.85 MB
  Controller render start	6.75 MB
  View render complete	7.37 MB

  Timers

  Total Request Time: 210 (ms)

  Message	Time in ms	Graph
  Core Processing (Derived from $_SERVER["REQUEST_TIME"])	26.98
  Event: Controller.initialize	3.78
  Event: Controller.startup	1.16
  Controller action	49.77
  Event: Controller.beforeRender	9.53
  » Processing toolbar data	9.42
  Rendering View	91.77
  » Event: View.beforeRender	0.28
  » Rendering APP/View/Articles/view.ctp	3.72
  » » Rendering APP/View/Elements/sidebar/explore.ctp	0.93
  » » » Rendering APP/View/Elements/explore_tile_small.ctp	0.14
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #2	0.15
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #3	0.13
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #4	0.12
  » » Rendering APP/View/Elements/sidebar/article_list.ctp	0.19
  » » Rendering APP/View/Elements/sidebar/property_search.ctp	0.21
  » » Rendering APP/View/Elements/sidebar/property_list.ctp	1.26
  » » » 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.15
  » » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
  » Event: View.afterRender	0.01
  » Event: View.beforeLayout	0.01
  » Rendering APP/View/Layouts/front.ctp	86.96
  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)
        • id3714
        • brokerage_id76
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id783
        • agent_2_id0
        • agent_3_id0
        • nameCozy Cabin Mountain Get-Away
        • 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>Cozy cabin with a great big panoramic view. Enjoy this view on the spacious deck or from the wall of windows in the living room. Open beamed ceilings, knotty pine through out. Bedrooms are on the lower level. Full bath is on the main. Level parking and entry. Lake Gregory, the park and Crestline village are only a couple minuets away by car. Hurry! Don’t miss out on this cabin in the mountains and all the summer fun you can have! - See more at: http://www.therealestateplace.com/property/cozy-cabin-with-a-giant-view/#sthash.ZnUX3nkP.dpuf</p>
        • address340 Donner Dr
        • address_2
        • cityLake Arrowhead
        • stateCA
        • postal_code92352
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price175000
        • price_20
        • price_usd175000
        • 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)
        • bedrooms2
        • bedrooms_20
        • bathrooms1
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet0
        • square_meters
        • acres0
        • interior_unitsq_ft
        • interior_size0
        • lot_unitacres
        • lot_size0
        • icon_1views
        • icon_2
        • icon_3
        • icon_4
        • icon_5
        • icon_6
        • websitehttp://www.therealestateplace.com/property/cozy-cabin-with-a-giant-view/
        • meta_titleCozy Cabin Mountain Get-Away | Lake Arrowhead Real Estate | Prime Properties
        • meta_description340 Donner Dr is a property offered for sale in Lake Arrowhead, CA, USA, presented by Prime Properties
        • meta_keywords
        • bathrooms_partial0
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built
        • virtual_tourhttp://www.tourfactory.com/1523656
        • video_tour
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num
        • wsj_property_type
        • nyt_property_type
        • nyt_popular_features
        • propgolux_property_type
        • juwai_property_type
        • juwai_category
        • propgolux_property_style
        • wapo_property_type
        • robb_property_type
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude0.000000
        • longitude0.000000
        • invalid_required_fieldslatitude, longitude
        • invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, year_built, video_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
        • went_live_today(true)
        • converted(true)
        • invalid(false)
        • mlsidx_full_address
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2016-04-18 05:33:03
        • created2016-04-07 11:14:42
        • uri/property-detail/3714/340-donner-dr-lake-arrowhead-ca-92352-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3714/340-donner-dr-lake-arrowhead-ca-92352-usa
        • address_concat340 Donner Dr Lake Arrowhead CA 92352 USA
        • google_maps_query_string340+Donner+Dr++Lake+Arrowhead+CA+92352+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 175,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty2
        • bathrooms_pretty1
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms1
        • date_listed2016-04-07
        • overridden_brokerage_namePrime Properties
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id76
        • account_executive_id236
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties8
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties0
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id1
        • WOEID2434729
        • timezoneUS/Pacific
        • luxury_feed_enrollment_modemanual
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id
        • mlsidx_lux_autofeed(false)
        • mlsidx_lux_autofeed_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • namePrime Properties
        • broker_of_record_name
        • short_namePrime Properties
        • usernamePrimeProperties
        • password4b7dee5c791770c42ce3df75d5b8fb072b481b38
        • password_reset_hash
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date0000-00-00
        • monthly_invoice_end_date0000-00-00
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>Prime Properties is the exclusive representative for Leverage Global Partners in Lake Arrowhead, California, USA.</p> <p>“Different isn’t always better, but better is always different,” has been founder, and president, Jeff Perlis’ motto for providing outstanding service to his clients for almost 25 years. Jeff created Prime Properties as a boutique real estate company that provides Nordstrom-quality customer service to its clients.</p> <p>The Prime Properties Team purposes to continually show community support. Such support can be exemplified by their sweeping transformation of its current office location. The office’s strategic location, houses the Arrowhead Welcome Center, Jeff’s vision for providing a warm and inviting first-stop for Lake Arrowhead visitors and clients. The Prime Properties Team includes, Arrowhead Rental Agency, the full-time rental department.</p> <p>Lake Arrowhead is a four season resort community centered around the uniqueness of a private lake. Located in an altitude of 5,100 feet, Lake Arrowhead has been described as the “Jewel of Southern California,” known as “Little Switzerland.” Close to local ski resorts and National Forest trails, Lake Arrowhead is less than a two-hour drive from Los Angeles, San Diego, or Palm Springs.</p>
        • communitieslake arrowhead
        • websitehttp://www.therealestateplace.com/
        • address26816 Highway 189
        • address_2
        • cityLake Arrowhead
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • marketLake Arrowhead
        • market_2
        • postal_code92352
        • phone(909) 337-7653
        • phone_2(909) 224-5631
        • phone_3
        • wide_contact_image(false)
        • contact_nameJeff Perlis
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titleOwner/Broker
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_websitehttp://www.JeffPerlis.com
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename76.jpg
        • logo_filename76.jpg
        • contact_image_filename76.jpg
        • all_properties_link_image_filename76.jpg
        • all_properties_linkhttp://www.therealestateplace.com/properties
        • video_embed_code
        • contact_video_embed_code
        • meta_titleLake Arrowhead Real Estate | Prime Properties | Leverage Global Partners
        • meta_descriptionPrime Properties is the exclusive representative for Leverage Global Partners in Lake Arrowhead, California, USA.
        • meta_keywordsLake Arrowhead Real Estate, Prime Properties, Leverage Global Partners, Jeff Perlis
        • login_message_counter2
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-12-09 16:21:37
        • modified2016-04-08 16:34:01
        • dre_num012345
        • uri/brokerage-detail/76/prime-properties
        • website_shortwww.therealestateplace.com
        • name_with_locationPrime Properties
      • StripeSubscription(array)
        • id(null)
        • brokerage_id(null)
        • user_id(null)
        • property_id(null)
        • type(null)
        • stripe_id(null)
        • stripe_customer_id(null)
        • stripe_checkout_email(null)
        • stripe_promotion_code(null)
        • stripe_promotion_code_id(null)
        • stripe_coupon_code_id(null)
        • status(null)
        • current_period_end(null)
        • cancel_at_period_end(null)
        • ended(null)
        • last_change(null)
        • last_activity_email_sent(null)
        • created(null)
        • modified(null)
      • GlobalReachReport(array)
        • id(null)
        • property_id(null)
        • wsj_desktop(null)
        • wsj_mobile(null)
        • wsj_expires(null)
        • wsj_capture_started(null)
        • mg_desktop(null)
        • mg_mobile(null)
        • mg_expires(null)
        • mg_capture_started(null)
        • bp_desktop(null)
        • bp_mobile(null)
        • bp_expires(null)
        • gp_capture_started(null)
        • mw_desktop(null)
        • mw_mobile(null)
        • mw_expires(null)
        • mw_capture_started(null)
        • ft_desktop(null)
        • ft_mobile(null)
        • ft_expires(null)
        • ft_capture_started(null)
        • nikkei_desktop(null)
        • nikkei_mobile(null)
        • nikkei_expires(null)
        • nikkei_capture_started(null)
        • pgl_desktop(null)
        • pgl_mobile(null)
        • pgl_expires(null)
        • pgl_capture_started(null)
        • robb_desktop(null)
        • robb_mobile(null)
        • robb_expires(null)
        • robb_capture_started(null)
        • juwai_desktop(null)
        • juwai_mobile(null)
        • juwai_expires(null)
        • juwai_capture_started(null)
        • leverage_desktop(null)
        • leverage_mobile(null)
        • leverage_expires(null)
        • leverage_capture_started(null)
        • created(null)
        • modified(null)
        • wsj_available(false)
        • wsj_expired(true)
        • wsj_desktop_proxy_screenshot(null)
        • wsj_mobile_proxy_screenshot(null)
        • mg_available(false)
        • mg_expired(true)
        • mg_desktop_proxy_screenshot(null)
        • mg_mobile_proxy_screenshot(null)
        • bp_available(false)
        • bp_expired(true)
        • bp_desktop_proxy_screenshot(null)
        • bp_mobile_proxy_screenshot(null)
        • mw_available(false)
        • mw_expired(true)
        • mw_desktop_proxy_screenshot(null)
        • mw_mobile_proxy_screenshot(null)
        • nikkei_available(false)
        • nikkei_expired(true)
        • nikkei_desktop_proxy_screenshot(null)
        • nikkei_mobile_proxy_screenshot(null)
        • pgl_available(false)
        • pgl_expired(true)
        • pgl_desktop_proxy_screenshot(null)
        • pgl_mobile_proxy_screenshot(null)
        • robb_available(false)
        • robb_expired(true)
        • robb_desktop_proxy_screenshot(null)
        • robb_mobile_proxy_screenshot(null)
        • juwai_available(false)
        • juwai_expired(true)
        • juwai_desktop_proxy_screenshot(null)
        • juwai_mobile_proxy_screenshot(null)
        • capture_processing(false)
        • capture_error(empty)
      • Image(array)
        • 0(array)
          • id20576
          • modelProperty
          • model_id3714
          • tagImage
          • name36057.jpg
          • typeimage/jpg
          • size4491599
          • uri/assets/20576.jpg
          • order2895
          • created2016-04-07 17:34:23
          • modified2016-04-07 17:34:23
        • 1(array)
          • id20577
          • modelProperty
          • model_id3714
          • tagImage
          • name36058.jpg
          • typeimage/jpg
          • size3978667
          • uri/assets/20577.jpg
          • order2896
          • created2016-04-07 17:34:25
          • modified2016-04-07 17:34:25
        • 2(array)
          • id20578
          • modelProperty
          • model_id3714
          • tagImage
          • name36059.jpg
          • typeimage/jpg
          • size2333726
          • uri/assets/20578.jpg
          • order2897
          • created2016-04-07 17:34:26
          • modified2016-04-07 17:34:26
        • 3(array)
          • id20579
          • modelProperty
          • model_id3714
          • tagImage
          • name36060.jpg
          • typeimage/jpg
          • size2771257
          • uri/assets/20579.jpg
          • order2898
          • created2016-04-07 17:34:28
          • modified2016-04-07 17:34:28
        • 4(array)
          • id20580
          • modelProperty
          • model_id3714
          • tagImage
          • name36061.jpg
          • typeimage/jpg
          • size3063397
          • uri/assets/20580.jpg
          • order2899
          • created2016-04-07 17:34:30
          • modified2016-04-07 17:34:30
        • 5(array)
          • id20581
          • modelProperty
          • model_id3714
          • tagImage
          • name36062.jpg
          • typeimage/jpg
          • size3961632
          • uri/assets/20581.jpg
          • order2900
          • created2016-04-07 17:34:31
          • modified2016-04-07 17:34:31
        • 6(array)
          • id20582
          • modelProperty
          • model_id3714
          • tagImage
          • name36063.jpg
          • typeimage/jpg
          • size3586973
          • uri/assets/20582.jpg
          • order2901
          • created2016-04-07 17:34:33
          • modified2016-04-07 17:34:33
        • 7(array)
          • id20583
          • modelProperty
          • model_id3714
          • tagImage
          • name36064.jpg
          • typeimage/jpg
          • size4205847
          • uri/assets/20583.jpg
          • order2902
          • created2016-04-07 17:34:34
          • modified2016-04-07 17:34:34
        • 8(array)
          • id20584
          • modelProperty
          • model_id3714
          • tagImage
          • name36065.jpg
          • typeimage/jpg
          • size4187920
          • uri/assets/20584.jpg
          • order2903
          • created2016-04-07 17:34:36
          • modified2016-04-07 17:34:36
        • 9(array)
          • id20585
          • modelProperty
          • model_id3714
          • tagImage
          • name36066.jpg
          • typeimage/jpg
          • size5185756
          • uri/assets/20585.jpg
          • order2904
          • created2016-04-07 17:34:37
          • modified2016-04-07 17:34:37
      • User(array)
        • 0(array)
          • id975
          • typeAgent
          • brokerage_id76
          • email[email protected]
          • passwordc6c6dec5d7e005197be3010c5570953a73f47b96
          • recover_hash
          • first_nameKerry
          • last_nameJenkins
          • title
          • dre_num
          • phone909-553-7087
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2017-08-07 15:23:46
          • created2017-08-07 15:23:46
          • notified(false)
          • full_nameKerry Jenkins
          • uri/agent-detail/975/kerry-jenkins
          • profile_complete(true)
          • UsersProperty(array)
            • id732
            • user_id975
            • property_id3714
            • sort_order0
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(array)
        • 0(array)
          • id14
          • nameViews
          • additional(false)
          • created2016-04-07 14:04:55
          • modified2016-04-07 14:04:55
          • PropertiesPropertyFeature(array)
            • id4355
            • property_id3714
            • property_feature_id14
      • Topic(empty)
    • 1(array)
      • Property(array)
        • id3727
        • brokerage_id34
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameHistoric Home In The Estate Section
        • incomplete(false)
        • archived(false)
        • last_archived0000-00-00 00:00:00
        • auto_archived_from_mlsidx(false)
        • paid_featured(false)
        • featured(false)
        • homepage_featured(false)
        • brokerage_page_featured(true)
        • requested_homepage_featured_by_member(false)
        • homepage_featured_by_member(false)
        • dot_luxury_featured(false)
        • luxury_feed_featured(false)
        • force_luxury_feed_featured(false)
        • luxury_autofeed_imported(false)
        • luxury_feed_last_added_time0000-00-00 00:00:00
        • luxury_feed_agent_user_id0
        • luxury_feed_locked_to_subscription_id0
        • luxury_feed_agent_purchase_date0000-00-00
        • luxury_feed_agent_expiration_date0000-00-00
        • digital_ad_summary_email_last_sent0000-00-00 00:00:00
        • digital_ad_summary_price_changed(false)
        • wsj_detail_url
        • ft_detail_url
        • nyt_detail_url
        • juwai_detail_url
        • pgl_detail_url
        • mg_detail_url
        • mg_c_detail_url
        • mg_s_detail_url
        • bp_detail_url
        • mw_detail_url
        • nikkei_detail_url
        • wapo_detail_url
        • robb_detail_url
        • medium_featured(false)
        • large_featured(false)
        • detail_page(false)
        • description<p>Historic Traditional Designed & Built For 4 Time Ny Governor & Presidential Candidate Alfred E. Smith; 6 Bdrms, 4.5 Baths, Gourmet Kitchen, Formal Living & Dining Rooms, Sun Room, Media Room, Private Loft/Office & Conference Room. Over An Acre W/ Lush Landscaping, Beautiful Specimen Trees, In Ground Pool, Pool House & All Weather Tennis Court. Truly Your Own Summer Resort!</p>
        • address14 Halsey Avenue
        • address_2
        • cityWesthampton Beach
        • stateNY
        • postal_code11978
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price3399000
        • price_20
        • price_usd3399000
        • price_usd_20
        • statusFor Sale
        • status_last_changed0000-00-00 00:00:00
        • status_last_changed_price_only0000-00-00 00:00:00
        • lease_period
        • price_upon_request(false)
        • bedrooms0
        • bedrooms_20
        • bathrooms0
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet0
        • square_meters
        • acres0
        • interior_unitsq_ft
        • interior_size0
        • lot_unitacres
        • lot_size0
        • icon_1
        • icon_2
        • icon_3
        • icon_4
        • icon_5
        • icon_6
        • website
        • meta_title
        • meta_description
        • meta_keywords
        • bathrooms_partial0
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built
        • virtual_tour
        • video_tour
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num
        • wsj_property_type
        • nyt_property_type
        • nyt_popular_features
        • propgolux_property_type
        • juwai_property_type
        • juwai_category
        • propgolux_property_style
        • wapo_property_type
        • robb_property_type
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude40.805931
        • longitude-72.658035
        • invalid_required_fields
        • invalid_optional_fields
        • went_live_today(false)
        • converted(true)
        • invalid(false)
        • mlsidx_full_address
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2016-04-18 05:33:03
        • created2016-04-14 13:41:32
        • uri/property-detail/3727/14-halsey-avenue-westhampton-beach-ny-11978-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3727/14-halsey-avenue-westhampton-beach-ny-11978-usa
        • address_concat14 Halsey Avenue Westhampton Beach NY 11978 USA
        • google_maps_query_string14+Halsey+Avenue++Westhampton+Beach+NY+11978+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 3,399,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty0
        • bathrooms_pretty0
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms0
        • date_listed2016-04-14
        • overridden_brokerage_nameFirst Hampton International Realty
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id34
        • account_executive_id235
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties8
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties0
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id1
        • WOEID2518253
        • timezoneUS/Eastern
        • luxury_feed_enrollment_modemanual
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id
        • mlsidx_lux_autofeed(false)
        • mlsidx_lux_autofeed_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • nameFirst Hampton International Realty
        • broker_of_record_name
        • short_nameFirst Hampton International Realty
        • usernameFirstHampton
        • passwordc6d7951ad2b1432ff444a7a5acca6784d6573bb9
        • password_reset_hash
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date0000-00-00
        • monthly_invoice_end_date0000-00-00
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>First Hampton International Realty is the exclusive representative for Leverage Global Partners in The Hamptons, New York, USA.</p> <p>Lawrence Citarelli Jr. is a successful, former finance/ economics executive of 14 years and possesses over 17 years of real estate investment and development experience. Mr. Citarelli has forged the Lawrence III Group, The group is comprised of a multi award winning design/construction management firm, Westhampton Partners, a development and acquisition arm and First Hampton International Realty, a global real estate entity. Through the vertical integration of these three entities clients and customers are provided with an experience and service model that is unrivaled in the industry. Mr. Citarelli is also a consummate humanitarian and is aligned with various noteworthy athletes, entertainers and celebrities. He has recently been awarded a congressional award for his international business dealings which are specifically tied to helping the less fortunate children and the communities where he is active.</p>
        • communitiesWesthampton Beach Westhampton Quogue Remsenburg hamptons southampton east hampton
        • websitehttp://www.firsthamptonrealty.com
        • address50 Main Street
        • address_2
        • cityWesthampton Beach
        • stateNY
        • full_stateNew York
        • countryUSA
        • marketHamptons
        • market_2
        • postal_code11978
        • phone(631) 872-0280
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameLawrence Citarelli
        • contact_profile_link
        • contact_big_profile_linkhttp://www.leveragere.com/blog/meet-lawrence-citarelli-principal-first-hampton-realty/
        • contact_big_profile_link_text
        • contact_titlePrincipal
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename34.jpg
        • logo_filename34.jpg
        • contact_image_filename34.jpg
        • all_properties_link_image_filename34.jpg
        • all_properties_linkhttp://www.firsthamptonrealty.com/featured
        • video_embed_code
        • contact_video_embed_code
        • meta_titleThe Hamptons Real Estate | First Hampton International Realty | Leverage Global Partners
        • meta_descriptionFirst Hampton International Realty is Leverage Global Partners' exclusive representative in the Hamptons, New York, USA.
        • meta_keywordsFirst Hampton International Realty, The Hamptons Real Estate, Westhampton beach real estate, Lawrence Citarelli, Leverage Global Partners
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-06-07 11:03:46
        • modified2016-04-08 16:33:30
        • dre_num012345
        • uri/brokerage-detail/34/first-hampton-international-realty
        • website_shortwww.firsthamptonrealty.com
        • name_with_locationFirst Hampton International Realty
      • StripeSubscription(array)
        • id(null)
        • brokerage_id(null)
        • user_id(null)
        • property_id(null)
        • type(null)
        • stripe_id(null)
        • stripe_customer_id(null)
        • stripe_checkout_email(null)
        • stripe_promotion_code(null)
        • stripe_promotion_code_id(null)
        • stripe_coupon_code_id(null)
        • status(null)
        • current_period_end(null)
        • cancel_at_period_end(null)
        • ended(null)
        • last_change(null)
        • last_activity_email_sent(null)
        • created(null)
        • modified(null)
      • GlobalReachReport(array)
        • id(null)
        • property_id(null)
        • wsj_desktop(null)
        • wsj_mobile(null)
        • wsj_expires(null)
        • wsj_capture_started(null)
        • mg_desktop(null)
        • mg_mobile(null)
        • mg_expires(null)
        • mg_capture_started(null)
        • bp_desktop(null)
        • bp_mobile(null)
        • bp_expires(null)
        • gp_capture_started(null)
        • mw_desktop(null)
        • mw_mobile(null)
        • mw_expires(null)
        • mw_capture_started(null)
        • ft_desktop(null)
        • ft_mobile(null)
        • ft_expires(null)
        • ft_capture_started(null)
        • nikkei_desktop(null)
        • nikkei_mobile(null)
        • nikkei_expires(null)
        • nikkei_capture_started(null)
        • pgl_desktop(null)
        • pgl_mobile(null)
        • pgl_expires(null)
        • pgl_capture_started(null)
        • robb_desktop(null)
        • robb_mobile(null)
        • robb_expires(null)
        • robb_capture_started(null)
        • juwai_desktop(null)
        • juwai_mobile(null)
        • juwai_expires(null)
        • juwai_capture_started(null)
        • leverage_desktop(null)
        • leverage_mobile(null)
        • leverage_expires(null)
        • leverage_capture_started(null)
        • created(null)
        • modified(null)
        • wsj_available(false)
        • wsj_expired(true)
        • wsj_desktop_proxy_screenshot(null)
        • wsj_mobile_proxy_screenshot(null)
        • mg_available(false)
        • mg_expired(true)
        • mg_desktop_proxy_screenshot(null)
        • mg_mobile_proxy_screenshot(null)
        • bp_available(false)
        • bp_expired(true)
        • bp_desktop_proxy_screenshot(null)
        • bp_mobile_proxy_screenshot(null)
        • mw_available(false)
        • mw_expired(true)
        • mw_desktop_proxy_screenshot(null)
        • mw_mobile_proxy_screenshot(null)
        • nikkei_available(false)
        • nikkei_expired(true)
        • nikkei_desktop_proxy_screenshot(null)
        • nikkei_mobile_proxy_screenshot(null)
        • pgl_available(false)
        • pgl_expired(true)
        • pgl_desktop_proxy_screenshot(null)
        • pgl_mobile_proxy_screenshot(null)
        • robb_available(false)
        • robb_expired(true)
        • robb_desktop_proxy_screenshot(null)
        • robb_mobile_proxy_screenshot(null)
        • juwai_available(false)
        • juwai_expired(true)
        • juwai_desktop_proxy_screenshot(null)
        • juwai_mobile_proxy_screenshot(null)
        • capture_processing(false)
        • capture_error(empty)
      • Image(array)
        • 0(array)
          • id20816
          • modelProperty
          • model_id3727
          • tagImage
          • nameHalsey-TREE.jpg
          • typeimage/jpeg
          • size2357806
          • uri/assets/20816.jpg
          • order0
          • created2016-04-14 13:40:50
          • modified2016-04-14 13:41:32
        • 1(array)
          • id20817
          • modelProperty
          • model_id3727
          • tagImage
          • nameWAR-ROOM-1.jpg
          • typeimage/jpeg
          • size1735454
          • uri/assets/20817.jpg
          • order1
          • created2016-04-14 13:41:14
          • modified2016-04-14 13:41:32
        • 2(array)
          • id20818
          • modelProperty
          • model_id3727
          • tagImage
          • namePOOL.jpg
          • typeimage/jpeg
          • size2027846
          • uri/assets/20818.jpg
          • order2
          • created2016-04-14 13:41:27
          • modified2016-04-14 13:41:32
      • User(empty)
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(empty)
      • Topic(empty)
    • 2(array)
      • Property(array)
        • id3717
        • brokerage_id4
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id1153
        • agent_2_id1228
        • agent_3_id0
        • nameCharming Craftsman in Premier Area
        • 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(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_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>Charming Castellammare Craftsman. A white picket fence welcomes you to a quality of life that offers cool ocean breezes, incredible schools and a convenient location in the famed Castellammare neighborhood. This turn-key home provides stainless steel appliances, butcher-block countertops, a wide-open family room with french doors guiding you to a beautiful backyard with a stunning trellis, an outdoor dining area with a lounge and firepit. This is a rare opportunity to live in a premier area in a home that is rich in character and amenities.</p>
        • address333 Bellino Drive
        • address_2
        • cityPacific Palisades
        • stateCA
        • postal_code90272
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price2125000
        • price_20
        • price_usd2125000
        • price_usd_20
        • statusFor Sale
        • status_last_changed0000-00-00 00:00:00
        • status_last_changed_price_only0000-00-00 00:00:00
        • lease_period
        • price_upon_request(false)
        • bedrooms3
        • bedrooms_20
        • bathrooms2
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet0
        • square_meters
        • acres0
        • interior_unitsq_ft
        • interior_size0
        • lot_unitacres
        • lot_size0
        • icon_1sq-ft
        • icon_2views
        • icon_3garage
        • icon_4
        • icon_5
        • icon_6
        • websitehttp://333bellinodrive.thepartnerstrust.com/
        • meta_titleCharming Craftsman in Premier Area | Pacific Palisades Real Estate | Partners Trust Real Estate Brokerage and Acquisitions
        • meta_description333 Bellino Drive is a property offered for sale in Pacific Palisades, 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_built1952
        • virtual_tour
        • video_tourhttp://www.onvedeo.com/properties/740302/embed
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num16110926
        • wsj_property_typesingle family
        • nyt_property_type1
        • nyt_popular_features
        • propgolux_property_type9
        • juwai_property_type
        • juwai_category
        • propgolux_property_style20
        • 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.045139
        • longitude-118.561409
        • invalid_required_fields
        • invalid_optional_fieldsbathrooms_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)
        • modified2024-10-24 08:42:56
        • created2016-04-11 10:42:59
        • uri/property-detail/3717/333-bellino-drive-pacific-palisades-ca-90272-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3717/333-bellino-drive-pacific-palisades-ca-90272-usa
        • address_concat333 Bellino Drive Pacific Palisades CA 90272 USA
        • google_maps_query_string333+Bellino+Drive++Pacific+Palisades+CA+90272+USA
        • luxury_ad_enrolled_prettyYES
        • price_prettyUSD 2,125,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty3
        • 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)
          • id20632
          • modelProperty
          • model_id3717
          • tagImage
          • name36086.jpg
          • typeimage/jpeg
          • size398741
          • uri/assets/20632.jpg
          • order0
          • created2016-04-11 18:18:35
          • modified2024-10-24 08:42:48
        • 1(array)
          • id20626
          • modelProperty
          • model_id3717
          • tagImage
          • name36090.jpg
          • typeimage/jpeg
          • size363363
          • uri/assets/20626.jpg
          • order1
          • created2016-04-11 18:18:26
          • modified2024-10-24 08:42:48
        • 2(array)
          • id20623
          • modelProperty
          • model_id3717
          • tagImage
          • name36091.jpg
          • typeimage/jpeg
          • size192923
          • uri/assets/20623.jpg
          • order2
          • created2016-04-11 18:18:25
          • modified2024-10-24 08:42:48
        • 3(array)
          • id20624
          • modelProperty
          • model_id3717
          • tagImage
          • name36088.jpg
          • typeimage/jpeg
          • size224311
          • uri/assets/20624.jpg
          • order3
          • created2016-04-11 18:18:25
          • modified2024-10-24 08:42:48
        • 4(array)
          • id20625
          • modelProperty
          • model_id3717
          • tagImage
          • name36087.jpg
          • typeimage/jpeg
          • size241455
          • uri/assets/20625.jpg
          • order4
          • created2016-04-11 18:18:25
          • modified2024-10-24 08:42:48
        • 5(array)
          • id20627
          • modelProperty
          • model_id3717
          • tagImage
          • name36089.jpg
          • typeimage/jpeg
          • size387159
          • uri/assets/20627.jpg
          • order5
          • created2016-04-11 18:18:26
          • modified2024-10-24 08:42:48
        • 6(array)
          • id20628
          • modelProperty
          • model_id3717
          • tagImage
          • name36092.jpg
          • typeimage/jpeg
          • size186447
          • uri/assets/20628.jpg
          • order6
          • created2016-04-11 18:18:26
          • modified2024-10-24 08:42:48
        • 7(array)
          • id20629
          • modelProperty
          • model_id3717
          • tagImage
          • name36093.jpg
          • typeimage/jpeg
          • size192625
          • uri/assets/20629.jpg
          • order7
          • created2016-04-11 18:18:26
          • modified2024-10-24 08:42:48
        • 8(array)
          • id20630
          • modelProperty
          • model_id3717
          • tagImage
          • name36094.jpg
          • typeimage/jpeg
          • size190386
          • uri/assets/20630.jpg
          • order8
          • created2016-04-11 18:18:26
          • modified2024-10-24 08:42:48
        • 9(array)
          • id20631
          • modelProperty
          • model_id3717
          • tagImage
          • name36095.jpg
          • typeimage/jpeg
          • size452931
          • uri/assets/20631.jpg
          • order9
          • created2016-04-11 18:18:27
          • modified2024-10-24 08:42:48
      • 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)
            • id1133
            • user_id1222
            • property_id3717
            • sort_order0
        • 1(array)
          • id1271
          • typeAgent
          • brokerage_id4
          • email[email protected]
          • passwordf7e6e6676d058ebcac2f2621cc1310ed2cb095b1
          • recover_hash
          • first_nameKristen
          • last_namePartipilo
          • title
          • dre_num
          • phone310.500.1304
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2017-08-07 15:24:02
          • created2017-08-07 15:24:02
          • notified(false)
          • full_nameKristen Partipilo
          • uri/agent-detail/1271/kristen-partipilo
          • profile_complete(true)
          • UsersProperty(array)
            • id1134
            • user_id1271
            • property_id3717
            • sort_order1
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(array)
        • 0(array)
          • id14
          • nameViews
          • additional(false)
          • created2016-04-07 14:04:55
          • modified2016-04-07 14:04:55
          • PropertiesPropertyFeature(array)
            • id4758
            • property_id3717
            • property_feature_id14
        • 1(array)
          • id4
          • nameGarage
          • additional(false)
          • created2016-04-07 14:01:52
          • modified2016-04-07 14:01:52
          • PropertiesPropertyFeature(array)
            • id4757
            • property_id3717
            • property_feature_id4
      • Topic(empty)
    • 3(array)
      • Property(array)
        • id3747
        • brokerage_id70
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • namePretty Pretty Piece of Land
        • 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_time2018-08-22 14:52:23
        • 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_urlhttps://propertylistings.ft.com/homes/2552920/new-york-property-for-sale/7-hubert-street-new-york-new-york
        • nyt_detail_urlhttps://www.nytimes.com/real-estate/usa/ca/beverly-hills/homes-for-sale/9491-rembert-ln/1995-801-1-19-524596
        • 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>8 Acres Located On Pawleys Island, Approximately 70 Miles Fromcharleston And 25 Miles South Of Myrtle Beach. It Is Known As One Of The Oldest And Most Unique Summer Resorts On The East Coast With Nearby Golf Courses. Home Of The Famous Rope Hammocks And World Known Hammock Shops And The Unspoiled, Casual, Delightful Stretch Of Wide Beach And Sand Dunes, Create A Charming Place To Live. Housing Developers Are Welcome. Pawleys Continues To Be Known For Its Shoeless, Carefree, Laid-back Life Style, Which Includes Crabbing In The Creek, Fishing, And The Stories Of Ghosts (Gray Man & Alice...to Name A Few). Come Enjoy This Charming Lifestyle.</p>
        • address980 MARTIN LUTHER KING ROAD
        • address_2
        • cityPawleys Island
        • stateSC
        • postal_code29585
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price680000
        • price_20
        • price_usd0
        • price_usd_20
        • statusFor Sale
        • status_last_changed0000-00-00 00:00:00
        • status_last_changed_price_only0000-00-00 00:00:00
        • lease_period
        • price_upon_request(false)
        • bedrooms0
        • bedrooms_20
        • bathrooms0
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet0
        • square_meters
        • acres0
        • interior_unitsq_ft
        • interior_size0
        • lot_unitacres
        • lot_size0
        • icon_1
        • icon_2
        • icon_3
        • icon_4
        • icon_5
        • icon_6
        • website
        • meta_title
        • meta_description
        • meta_keywords
        • bathrooms_partial0
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built
        • virtual_tour
        • video_tour
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num
        • wsj_property_typeapartment
        • nyt_property_type1
        • nyt_popular_features
        • propgolux_property_type1
        • juwai_property_type
        • juwai_category
        • propgolux_property_style1
        • wapo_property_type
        • robb_property_type
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude33.420074
        • longitude-79.183090
        • invalid_required_fields
        • invalid_optional_fields
        • went_live_today(false)
        • converted(false)
        • invalid(false)
        • mlsidx_full_address980 MARTIN LUTHER KING ROAD Pawleys Island SC
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2019-10-29 18:47:35
        • created2018-05-02 14:29:44
        • uri/property-detail/3747/980-martin-luther-king-road-pawleys-island-sc-29585-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3747/980-martin-luther-king-road-pawleys-island-sc-29585-usa
        • address_concat980 MARTIN LUTHER KING ROAD Pawleys Island SC 29585 USA
        • google_maps_query_string980+MARTIN+LUTHER+KING+ROAD++Pawleys+Island+SC+29585+USA
        • luxury_ad_enrolled_prettyYES
        • price_prettyUSD 680,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty0
        • bathrooms_pretty0
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms0
        • date_listed2018-05-02
        • overridden_brokerage_nameQuinta Properties
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id70
        • account_executive_id236
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties8
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties3
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id13
        • WOEID23706483
        • timezoneEurope/Lisbon
        • luxury_feed_enrollment_modemanual
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id9
        • mlsidx_lux_autofeed(false)
        • mlsidx_lux_autofeed_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • nameQuinta Properties
        • broker_of_record_name
        • short_nameQuinta Properties
        • usernameQuintaProperties
        • passwordbfa20d0f7d557565a3e9f0589db0a06e4c9546f3
        • password_reset_hash
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date0000-00-00
        • monthly_invoice_end_date0000-00-00
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>Quinta Properties is the exclusive representative for Leverage Global Partners in the Algarve, Portugal.</p> <p>Quinta Properties deal with some of the most exclusive luxury villas and exciting property in and around Quinta do Lago. As the chosen associates of Savills, they offer in-depth knowledge and experience to meet your real estate needs.</p> <p>Anyone who knows Quinta Properties and has dealt with Alison, Kerstin, and their team will know they are passionate about property.</p> <p>Their wide experience in the local property market enables them to recommend legal, architectural, financial and construction professionals who understand the needs of prospective buyers in the locality.</p> <p>Quinta Properties are registered with the Portuguese authorities as licensed agents, meeting stringent standards. Their staff are fluent in English, German, French, and Portuguese.</p> <p>"We make it our business to support you, to explain all the options, procedures and pitfalls and to carefully guide you through the entire process from purchasing to sellingluxury Quinta do Lago villas and other fine properties in the Quinta do Lago and the whole Algarve area." <em>--Alison Buechner Hojbjerg and Kerstin Buechner</em></p>
        • communitiesalgarve the algarve quinta do lago
        • websitehttp://www.quintaproperty.com/
        • addressAvenida da Gondra
        • address_2Quinta do Lago
        • cityAlmancil
        • state
        • full_state
        • countryPortugal
        • marketAlgarve
        • market_2
        • postal_code8135-162
        • phone+351 289 396 073
        • phone_2+351 289 398086 (Fax)
        • phone_3
        • wide_contact_image(false)
        • contact_nameAlison Buechner Hojbjerg and Kerstin Buechner
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titleDirectors
        • contact_dre_num
        • contact_quoteWe invite you to contact us about real estate in the Algarve
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename70.jpg
        • logo_filename70.jpg
        • contact_image_filename70.jpg
        • all_properties_link_image_filename70.jpg
        • all_properties_linkhttp://www.quintaproperty.com/algarve/
        • video_embed_code
        • contact_video_embed_code
        • meta_titleAlgarve Real Estate | Quinta Properties | Leverage Global Partners
        • meta_descriptionQuinta Properties is the exclusive representative for Leverage Global Partners in the Algarve, Portugal.
        • meta_keywordsQuinta Properties, Algarve Real Estate, Leverage Global Partners, Alison Buechner Hojbjerg
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-11-15 11:23:29
        • modified2020-11-20 12:05:11
        • dre_num012345
        • uri/brokerage-detail/70/quinta-properties
        • website_shortwww.quintaproperty.com
        • name_with_locationQuinta Properties
        • mlsidx_id_array(array)
          • 09
      • StripeSubscription(array)
        • id(null)
        • brokerage_id(null)
        • user_id(null)
        • property_id(null)
        • type(null)
        • stripe_id(null)
        • stripe_customer_id(null)
        • stripe_checkout_email(null)
        • stripe_promotion_code(null)
        • stripe_promotion_code_id(null)
        • stripe_coupon_code_id(null)
        • status(null)
        • current_period_end(null)
        • cancel_at_period_end(null)
        • ended(null)
        • last_change(null)
        • last_activity_email_sent(null)
        • created(null)
        • modified(null)
      • GlobalReachReport(array)
        • id(null)
        • property_id(null)
        • wsj_desktop(null)
        • wsj_mobile(null)
        • wsj_expires(null)
        • wsj_capture_started(null)
        • mg_desktop(null)
        • mg_mobile(null)
        • mg_expires(null)
        • mg_capture_started(null)
        • bp_desktop(null)
        • bp_mobile(null)
        • bp_expires(null)
        • gp_capture_started(null)
        • mw_desktop(null)
        • mw_mobile(null)
        • mw_expires(null)
        • mw_capture_started(null)
        • ft_desktop(null)
        • ft_mobile(null)
        • ft_expires(null)
        • ft_capture_started(null)
        • nikkei_desktop(null)
        • nikkei_mobile(null)
        • nikkei_expires(null)
        • nikkei_capture_started(null)
        • pgl_desktop(null)
        • pgl_mobile(null)
        • pgl_expires(null)
        • pgl_capture_started(null)
        • robb_desktop(null)
        • robb_mobile(null)
        • robb_expires(null)
        • robb_capture_started(null)
        • juwai_desktop(null)
        • juwai_mobile(null)
        • juwai_expires(null)
        • juwai_capture_started(null)
        • leverage_desktop(null)
        • leverage_mobile(null)
        • leverage_expires(null)
        • leverage_capture_started(null)
        • created(null)
        • modified(null)
        • wsj_available(false)
        • wsj_expired(true)
        • wsj_desktop_proxy_screenshot(null)
        • wsj_mobile_proxy_screenshot(null)
        • mg_available(false)
        • mg_expired(true)
        • mg_desktop_proxy_screenshot(null)
        • mg_mobile_proxy_screenshot(null)
        • bp_available(false)
        • bp_expired(true)
        • bp_desktop_proxy_screenshot(null)
        • bp_mobile_proxy_screenshot(null)
        • mw_available(false)
        • mw_expired(true)
        • mw_desktop_proxy_screenshot(null)
        • mw_mobile_proxy_screenshot(null)
        • nikkei_available(false)
        • nikkei_expired(true)
        • nikkei_desktop_proxy_screenshot(null)
        • nikkei_mobile_proxy_screenshot(null)
        • pgl_available(false)
        • pgl_expired(true)
        • pgl_desktop_proxy_screenshot(null)
        • pgl_mobile_proxy_screenshot(null)
        • robb_available(false)
        • robb_expired(true)
        • robb_desktop_proxy_screenshot(null)
        • robb_mobile_proxy_screenshot(null)
        • juwai_available(false)
        • juwai_expired(true)
        • juwai_desktop_proxy_screenshot(null)
        • juwai_mobile_proxy_screenshot(null)
        • capture_processing(false)
        • capture_error(empty)
      • Image(array)
        • 0(array)
          • id22844
          • modelProperty
          • model_id3747
          • tagImage
          • name1724068_5-1.jpg
          • typeimage/jpeg
          • size102864
          • uri/assets/22844.jpg
          • order0
          • created2018-05-02 14:29:45
          • modified2018-05-02 14:35:42
        • 1(array)
          • id22845
          • modelProperty
          • model_id3747
          • tagImage
          • name1724068_5-2.jpg
          • typeimage/jpeg
          • size86680
          • uri/assets/22845.jpg
          • order1
          • created2018-05-02 14:29:45
          • modified2018-05-02 14:35:42
        • 2(array)
          • id22846
          • modelProperty
          • model_id3747
          • tagImage
          • name1724068_5-3.jpg
          • typeimage/jpeg
          • size86613
          • uri/assets/22846.jpg
          • order2
          • created2018-05-02 14:29:45
          • modified2018-05-02 14:35:42
        • 3(array)
          • id22847
          • modelProperty
          • model_id3747
          • tagImage
          • name1724068_5-4.jpg
          • typeimage/jpeg
          • size130988
          • uri/assets/22847.jpg
          • order3
          • created2018-05-02 14:29:45
          • modified2018-05-02 14:35:42
        • 4(array)
          • id22848
          • modelProperty
          • model_id3747
          • tagImage
          • name1724068_5-5.jpg
          • typeimage/jpeg
          • size138280
          • uri/assets/22848.jpg
          • order4
          • created2018-05-02 14:29:45
          • modified2018-05-02 14:35:42
        • 5(array)
          • id22849
          • modelProperty
          • model_id3747
          • tagImage
          • name1724068_5-6.jpg
          • typeimage/jpeg
          • size140711
          • uri/assets/22849.jpg
          • order5
          • created2018-05-02 14:29:46
          • modified2018-05-02 14:35:42
        • 6(array)
          • id22850
          • modelProperty
          • model_id3747
          • tagImage
          • name1724068_5-7.jpg
          • typeimage/jpeg
          • size212343
          • uri/assets/22850.jpg
          • order6
          • created2018-05-02 14:29:46
          • modified2018-05-02 14:35:42
        • 7(array)
          • id22851
          • modelProperty
          • model_id3747
          • tagImage
          • name1724068_5-8.jpg
          • typeimage/jpeg
          • size199205
          • uri/assets/22851.jpg
          • order7
          • created2018-05-02 14:29:46
          • modified2018-05-02 14:35:42
        • 8(array)
          • id22852
          • modelProperty
          • model_id3747
          • tagImage
          • name1724068_5-9.jpg
          • typeimage/jpeg
          • size203812
          • uri/assets/22852.jpg
          • order8
          • created2018-05-02 14:29:46
          • modified2018-05-02 14:35:42
        • 9(array)
          • id22853
          • modelProperty
          • model_id3747
          • tagImage
          • name1724068_5-10.jpg
          • typeimage/jpeg
          • size205836
          • uri/assets/22853.jpg
          • order9
          • created2018-05-02 14:29:47
          • modified2018-05-02 14:35:42
        • 10(array)
          • id22854
          • modelProperty
          • model_id3747
          • tagImage
          • name1724068_5-11.jpg
          • typeimage/jpeg
          • size219211
          • uri/assets/22854.jpg
          • order10
          • created2018-05-02 14:29:47
          • modified2018-05-02 14:35:42
        • 11(array)
          • id22855
          • modelProperty
          • model_id3747
          • tagImage
          • name1724068_5-12.jpg
          • typeimage/jpeg
          • size195677
          • uri/assets/22855.jpg
          • order11
          • created2018-05-02 14:29:47
          • modified2018-05-02 14:35:42
        • 12(array)
          • id22856
          • modelProperty
          • model_id3747
          • tagImage
          • name1724068_5-13.jpg
          • typeimage/jpeg
          • size192282
          • uri/assets/22856.jpg
          • order12
          • created2018-05-02 14:29:47
          • modified2018-05-02 14:35:42
        • 13(array)
          • id22857
          • modelProperty
          • model_id3747
          • tagImage
          • name1724068_5-14.jpg
          • typeimage/jpeg
          • size185810
          • uri/assets/22857.jpg
          • order13
          • created2018-05-02 14:29:47
          • modified2018-05-02 14:35:42
        • 14(array)
          • id22858
          • modelProperty
          • model_id3747
          • tagImage
          • name1724068_5-15.jpg
          • typeimage/jpeg
          • size190086
          • uri/assets/22858.jpg
          • order14
          • created2018-05-02 14:29:48
          • modified2018-05-02 14:35:42
      • User(array)
        • 0(array)
          • id1281
          • typeAgent
          • brokerage_id70
          • email[email protected]
          • password6e83e74e5aad7dc2404b41f4dad53b857b4a34ae
          • recover_hash
          • first_nameMike
          • last_nameStratford
          • title
          • dre_num
          • phone4246341622
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2018-08-22 14:50:21
          • created2018-08-22 14:50:21
          • notified(false)
          • full_nameMike Stratford
          • uri/agent-detail/1281/mike-stratford
          • profile_complete(true)
          • UsersProperty(array)
            • id1110
            • user_id1281
            • property_id3747
            • sort_order0
        • 1(array)
          • id1278
          • typeAgent
          • brokerage_id70
          • email[email protected]
          • password6e83e74e5aad7dc2404b41f4dad53b857b4a34ae
          • recover_hash
          • first_nameCynthia
          • last_nameMurray
          • title
          • dre_num
          • phone8888888888
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2018-04-25 13:15:33
          • created2018-04-25 13:15:33
          • notified(false)
          • full_nameCynthia Murray
          • uri/agent-detail/1278/cynthia-murray
          • profile_complete(true)
          • UsersProperty(array)
            • id1111
            • user_id1278
            • property_id3747
            • sort_order1
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(array)
        • 0(array)
          • id2
          • nameBeach Access
          • additional(false)
          • created2016-04-07 14:00:52
          • modified2016-04-07 14:00:52
          • PropertiesPropertyFeature(array)
            • id4721
            • property_id3747
            • property_feature_id2
      • Topic(array)
        • 0(array)
          • id8
          • nameBeach
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:30:26
          • tile_nameBeach
          • PropertiesTopic(array)
            • id50
            • property_id3747
            • topic_id8
  • sidebar_articles(array)
    • 0(array)
      • Article(array)
        • id242
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(false)
        • large_featured(false)
        • title10 Unbelievable Luxury Homes Under $1 Million
        • authorLeverageRE
        • date2014-06-19
        • lead_inLuxury isn’t necessarily defined by an astronomical price tag. Believe it or not, opulent and lavishly luxe homes, filled with unique features and charming characteristics, can be within reach - without breaking the bank.
        • body <p>With the magnificence and splendor of homes exponentially higher in price, these 10 luxurious properties from our Leverage Global Partners are a steal for under $1 million:</p> <h1> <strong>1. Wooded Retreat</strong><br><strong>$675,000</strong><br> Represented by Ray & Poynor Properties</h1> <p><img src="/assets/852.jpg" class="pure-img"></p> <p>Constructed next to a flowing stream and waterfall, this stunning modern structure outside Birmingham, Alabama has over 5000 square feet of living space and sits on over 200 wooded acres.</p> <h1> <strong>2. Elegant Home in Southwest Durham</strong><br><strong>$789,000</strong><br> Represented by Peak, Swirles & Cavallito Properties</h1> <p><img src="/assets/853.jpg" class="pure-img"></p> <p>Upscale finishes adorn this elegant Durham, North Carolina home, including Bolivian Cherry floors, a cozy home theater, and a fantastic porch overlooking a wooded area. </p> <h1> <strong>3. Three Willows Ranch</strong><br><strong>$679,000</strong><br> Represented by Royce Real Estate</h1> <p><img src="/assets/854.jpg" class="pure-img"></p> <p>With lovely grounds full of willow trees and lush lawns, this gorgeous Ashland, Oregon ranch offers fabulous views and a turn-key operation for horses.</p> <h1> <strong>4. Extraordinary Designer’s Home</strong><br><strong>$589,000</strong><br> Represented by Prime Properties</h1> <p><img src="/assets/855.jpg" class="pure-img"></p> <p>This California property on Lake Arrowhead has no lack of amenities, featuring a wood spiral staircase, a grand fireplace in the living room, radiant floor heating, and a library with secret walls.</p> <h1> <strong>5. Craftsman Style East-Side Home</strong><br><strong>$539,000</strong><br> Represented by National Parks Realty</h1> <p><img src="/assets/856.jpg" class="pure-img"></p> <p>This spacious five bedroom Kalispell, Montana craftsman style home is perfect for families, with ample character and abundant room for entertaining. </p> <h1> <strong>6. Rustic Yet Elegant Lakefront Home</strong><br> $925,000<br> Represented by Lake James Real Estate</h1> <p><img src="/assets/857.jpg" class="pure-img"></p> <p>Superior craftsmanship is shown throughout the details of this Morganton, North Carolina home, including beautiful beamed ceilings and a covered deck with magnificent views of the lake.</p> <h1> <strong>7. Custom Waterfront Property</strong><br><strong>$950,000</strong><br> Represented by Madison & Company Properties</h1> <p><img src="/assets/858.jpg" class="pure-img"></p> <p>This dreamy Cape Cod waterfront property in Aurora, Colorado features both mountain and lake views, and a gourmet kitchen that would impresses the most discerning chef. </p> <h1> <strong>8. Historically Significant Rancho Mirage Home</strong><br><strong>$775,000</strong><br> Represented by Leaskou Partners</h1> <p><img src="/assets/859.jpg" class="pure-img"></p> <p>This unique mid-century modern home in Rancho Mirage, California was designed by prominent architect William Cody, and has been recently revamped and remodeled for modern living.</p> <h1> <strong>9. Remarkable Townhouse in Historic District</strong><br><strong>$595,000</strong><br> Represented by Three Oaks Realty Co.</h1> <p><img src="/assets/860.jpg" class="pure-img"></p> <p>Fully renovated and well-maintained, this "Beehive house" built circa 1806 is among the oldest properties in Savannah, Georgia, with features that offer a lifestyle of beauty, history, entertainment, and comfort.</p> <h1>10. <strong>Custom Built Sportsperson’s Retreat</strong><br><strong>$975,000</strong><br> Represented by Bandon Properties</h1> <p><img src="/assets/861.jpg" class="pure-img"></p> <p>Off the grid in a secluded 79 acre wilderness setting, this exceptional custom built home in Port Orford, Oregon is immersed in hardwood details and overlooks a creek, two ponds, and a canyon valley.</p> <h4><em>Do you dream of owning an ultra luxurious home, without spending millions of dollars? Please share your ideas and leave your comments below. </em></h4>
        • vimeo_id
        • created2016-02-25 14:11:24
        • modified2016-04-05 15:04:18
        • uri/articles/view/242/10-unbelievable-luxury-homes-under-1-million
        • flattened_topics(array)
          • 0Ultra 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)
          • id862
          • modelArticle
          • model_id242
          • tagImage
          • namePrime-Properties.jpg
          • typeimage/jpg
          • size424998
          • uri/assets/862.jpg
          • order0
          • created2016-02-25 14:11:25
          • modified2016-03-15 16:31:01
      • Brokerage(empty)
      • Location(empty)
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id20
          • nameUltra Lux
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:35:37
          • tile_nameUltra Lux
          • ArticlesTopic(array)
            • id161
            • article_id242
            • topic_id20
    • 1(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
    • 2(array)
      • Article(array)
        • id200
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(false)
        • large_featured(false)
        • title10 Ultra Luxe Properties You Have to See to Believe
        • authorLeverageRE
        • date2014-04-16
        • lead_inPrepare to be impressed. Leverage Global Partners represents some incredible real estate from around the world, with something for every taste imaginable. Here, we have compiled a list of our ten favorite ultra luxe properties. Where do you want to live next?
        • body <h1> <strong>1.</strong><strong> Clas</strong><strong>sic Mountain Estate</strong><br><strong>$17,950,000</strong><br> Represented by Shane Aspen Real Estate</h1> <p><img src="/assets/580.jpg" class="pure-img"></p> <p>This exquisite six-bedroom classic mountain estate sits majestically on just less than two acres of prime Aspen real estate. Its great room and decks provide <strong>front and center views of Aspen Mountain</strong>. With greater than 8,500 square feet of livable heated area plus a 1,430 square foot terrace, this is the perfect second home for your most discerning buyer.</p> <p> –</p> <h1> <strong>2. Fashion Farms</strong><br><strong>$50,000,000</strong><br> Represented by Lisa James Otto Country Properties</h1> <p><img src="/assets/581.jpg" class="pure-img"></p> <p>This outstanding complex of four impressive Bucks County, Pennsylvania horse farms is one of the most successful Standardbred horse operations in the United States and Canada. Sited on beautifully idyllic adjoining lands, or in close proximity to one another, these four farms, all with distinctive operations and characteristics, comprise the extraordinary <strong>463.75 acres</strong> that is Fashion Farms.</p> <p> –</p> <h1> <strong>3. Regal Elizabethan Estate</strong><br><strong>$28,800,000</strong><br> Represented by Clay Herman Realtor, Inc.</h1> <p><img src="/assets/582.jpg" class="pure-img"></p> <p>This world-class estate is situated on more than 6 acres of manicured grounds. The main house spans some 36,000 square feet and while it ranks as <strong>one of the West Coast's largest private residences</strong>, it is also a warm, family friendly home. Fireplaces, lush carpeting, and beautiful decor lend coziness to the bedrooms, family rooms and other living areas while formal rooms can accommodate entertaining on a grand scale.</p> <p> –</p> <h1> <strong> 4. Designer Penthouse </strong><strong>with </strong><strong>Sweeping  Views</strong><br><strong>$18,000,000</strong><br> Represented by First Hampton International Realty</h1> <p><img src="/assets/583.jpg" class="pure-img"></p> <p>Perched over the charming, historic town of Telluride, Colorado, this peerless 4-bedroom penthouse boasts sweeping 360-degree views of arguably the world's most magnificent box canyon. Conceived by renowned New York architect and designer Alan Wanzenberg, and built by Telluride's Fortenberry Construction, this <strong>6,000 plus-sq-ft</strong> <strong>property encompasses the building's entire top floor.           </strong></p> <p> –</p> <h1> <strong>5. Outstanding </strong><strong>South Beach </strong><strong>Cond0</strong><br><strong>$19,500,000</strong><br> Represented by Majestic Properties</h1> <p><img src="/assets/584.jpg" class="pure-img"></p> <p>This fabulous condominium in the southwest corner of the Continuum on South Beach is <strong>one of only five units</strong> that are part of the extraordinary ’03 line. Turnkey finished by Edward Nieto.</p> <p> –</p> <h1> <strong>6. Malibu Architectural </strong><strong>Masterpiece</strong><br><strong>$22,000,000</strong><br> Represented by Partners Trust Real Estate Brokerage & Acquisitions</h1> <p><img src="/assets/585.jpg" class="pure-img"></p> <p>John Lautner’s Stevens’ house (1968) is an architectural masterpiece on the beach in famed Malibu colony. This striking architectural is situated on approximately 37 feet of sandy beach with a large beach deck, grassy yard and swimming pool. This <strong>California state cultural landmark</strong> is a one of a kind treasure that has become a symbol of Lautner’s work and the Malibu coastline.</p> <p> –</p> <h1> <strong>7. Unparalleled French Country </strong><strong>Estate</strong><br><strong>$42,000,000</strong><br> Represented by J. Rockliff Realtors</h1> <p><img src="/assets/586.jpg" class="pure-img"></p> <p>This custom French Country estate is unparalleled in the Bay Area, and is not on MLS! <strong>101 acres in Alamo with double gated entry</strong>, terraces abound offering vistas of rolling hillsides and valleys. Main house boasts European courtyard entry with 8 bedrooms, 9 baths, and formal rooms: living/dining/breakfast, music room, and an elevator to wine cellar with dining room, powder room and dumbwaiter.</p> <p> –</p> <h1> <strong>8. Breathtaking Lyndhurst Road </strong><strong>Estate</strong><br><strong>£49,000,000</strong><br> Represented by Beauchamp Estates</h1> <p><img src="/assets/587.jpg" class="pure-img"></p> <p>Our list of 10 ultra luxe properties travels to London, where we spotlight Lyndhurst Road estate features <strong>8 bedrooms, 7 bathrooms</strong>, family room, drawing room, dining room, reception hall, entrance hall, reception room, kitchen, breakfast room, gymnasium, utility room, plant room, garage, staff flat, steam room, shower room, lift, pool room, parking, garden, terrace, roof terrace and balcony. Oh, wow!</p> <p> –</p> <h1> <strong>9. Waterfront Home with </strong><strong>Panoramic Views</strong><br><strong>€28,000,000</strong><br> Represented by Emile Garcin Properties</h1> <p><img src="/assets/588.jpg" class="pure-img"></p> <p>In the private residence of “Les Parcs de Saint-Tropez”, a beautiful waterfront property enjoying an excellent location with stunning panoramic views. Built by an Tropezian architect in the pure XVIIIth century Provencal style, <strong>the property includes several buildings, </strong>two swimming pools, a wonderful park 7,000m², a helipad, and access to a private beach.</p> <p> –</p> <h1> <strong>10. Breathtaking Montecito </strong><strong>Estate</strong><br><strong>$14,900,000</strong><br> Represented by Village Properties Realtors</h1> <p><img src="/assets/589.jpg" class="pure-img"></p> <p><strong>Expansive ocean and mountain views</strong> and 20+/- acres of unrivaled privacy are just the beginning. This luxurious Montecito Mediterranean estate’s offerings. 1st floor master, guest suites with private terraces, media/game room, 3,000+/- bottle wine cellar, 1 bedroom guest house and pool that are ideal for entertaining. Exquisite wood beamed ceilings, vine-covered patios, lawns and wildflower gardens adorn the exceptional property.</p>
        • vimeo_id
        • created2016-02-25 14:10:48
        • modified2016-04-05 14:41:06
        • uri/articles/view/200/10-ultra-luxe-properties-you-have-to-see-to-believe
        • flattened_topics(array)
          • 0Ultra 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)
          • id590
          • modelArticle
          • model_id200
          • tagImage
          • name2067.jpg
          • typeimage/jpg
          • size128937
          • uri/assets/590.jpg
          • order0
          • created2016-02-25 14:10:50
          • modified2016-03-15 16:40:24
      • Brokerage(empty)
      • Location(empty)
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id20
          • nameUltra Lux
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:35:37
          • tile_nameUltra Lux
          • ArticlesTopic(array)
            • id196
            • article_id200
            • topic_id20
    • 3(array)
      • Article(array)
        • id363
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(false)
        • large_featured(false)
        • titleFor the Film Fanatic: Ultra-Luxurious Home Theaters
        • authorLeverageRE
        • date2015-03-18
        • lead_inIt's a movie night: make some hot, buttery popcorn, stock up on your fave sweets and head downstairs– to your very own big screen theater.
        • body <p>With vibrant colors, cushy recliners, and state-of-the-art multimedia systems, these home theaters from some of our Leverage Partners are the perfect place to enjoy a grand cinematic experience, from the comfort of your very own home:</p> <h1> <strong>Executive Private Estate at Desert Canyon</strong><br> Represented by US Southwest </h1> <p><img src="/assets/1709.jpg" class="pure-img">Located in Bullhead City, Arizona, this high end retreat offers a luxurious theater room with powered seats and beautiful design.</p> <h1> <strong>Miami Landmark & Peaceful Haven</strong><br> Represented by Shelton & Stewart Realtors</h1> <p><img src="/assets/1710.jpg" class="pure-img">Built with a one-of-a-kind Moroccan design, the media room of this Miami landmark seats eight people in automatic reclining chairs.</p> <h1> <strong>Architectural Gem</strong><br> Represented by Partners Trust Real Estate Brokerage & Acquisitions</h1> <p><img src="/assets/1711.jpg" class="pure-img">With epic entertainment inside and out, this incredibly stylish Santa Monica home features a lower level with a game room, movie theater and utility kitchen.</p> <h1> <strong>Coral Gables Waterway Home</strong><br> Represented by Shelton & Stewart Realtors</h1> <p><img src="/assets/1712.jpg" class="pure-img"> Watch your favorite movies and TV shows in this custom theater complete with wood paneling, a coffered ceiling, and carpeting for acoustic integrity.</p> <h1> <strong>One-of-a-kind Home with Breathtaking Views</strong><br> Represented by HM Properties</h1> <p><img src="/assets/1713.jpg" class="pure-img">Nothing in this Charlotte, NC estate is short of spectacular, offering a 3-tier sound engineered home theater, game room, and dance floor.</p> <h1> <strong>Spectacular Contemporary Home</strong><br> Represented by Ventana Fine Properties</h1> <p><img src="/assets/1714.jpg" class="pure-img">Sit back, relax, and enjoy the show…the home theater inside this beautifully-designed Arizona masterpiece will keep you cool and entertained on those hot, sunny days.</p> <h1> <strong>Exquisite Escazu Residence</strong><br> Represented by Plantación Properties</h1> <p><img src="/assets/1715.jpg" class="pure-img">This home cinema offers a state-of-the-art intelligence system, and a large terrace with gorgeous Costa Rican hillside views.</p> <p>Which luxurious home theater design would you most like to have in your home? Please share your ideas and leave your comments below.</p>
        • vimeo_id
        • created2016-02-25 14:13:29
        • modified2016-04-05 14:41:07
        • uri/articles/view/363/for-the-film-fanatic-ultra-luxurious-home-theaters
        • flattened_topics(array)
          • 0Entertaining at Home
          • 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)
          • id1716
          • modelArticle
          • model_id363
          • tagImage
          • nameHome-Theater_Ventana-copy.jpg
          • typeimage/jpg
          • size772491
          • uri/assets/1716.jpg
          • order0
          • created2016-02-25 14:13:30
          • modified2016-03-14 15:54:34
      • Brokerage(empty)
      • Location(empty)
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id3
          • nameEntertaining at Home
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:31:34
          • tile_nameEntertaining at Home
          • ArticlesTopic(array)
            • id65
            • article_id363
            • topic_id3
        • 1(array)
          • id20
          • nameUltra Lux
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:35:37
          • tile_nameUltra Lux
          • ArticlesTopic(array)
            • id66
            • article_id363
            • topic_id20
  • sidebar_tiles(array)
    • 0(array)
      • Topic(array)
        • id4
        • nameKiller Views
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:33:10
        • tile_nameKiller Views
      • Image(array)
        • id13
        • modelTopic
        • model_id4
        • tagImage
        • nameKiller Views.jpg
        • typeimage/jpeg
        • size9220477
        • uri/assets/13.jpg
        • order0
        • created2016-02-25 11:33:03
        • modified2016-02-25 11:33:10
      • modelTopic
    • 1(array)
      • Location(array)
        • id91
        • parent_id9
        • brokerage_id46
        • typeExclusive
        • archived(false)
        • use_as_topic(true)
        • nameSonoma, CA, USA
        • short_nameSonoma, CA, USA
        • group_index
        • latitude38.406742
        • longitude-122.876129
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_descriptionAn extraordinary quality of life just north of San Francisco.
        • long_descriptionJust an hour north of San Francisco, the renowned Wine Country of Sonoma County offers an extraordinary quality of life. Distinctly unique small towns dot the rolling hillsides, lush vineyards, towering redwood forests and breathtaking coastline. Sonoma County’s world-class wineries easily rival those of its well-known neighbor, Napa County, just to the east. Wherever you go in Sonoma County there's a great sense of community. While each town and area retains its own style and pace, they all offer safe neighborhoods, bountiful Farmers Markets, good schools, open spaces, vineyards, orchards, festivals for every season, beautiful old farm houses...the list goes on and on.
        • created2016-04-05 11:20:44
        • modified2016-04-14 13:32:23
        • timezoneAmerica/Los_Angeles
        • population500292
        • uri/locations/view/91/sonoma-ca-usa
        • tile_nameSonoma, CA, USA
      • Brokerage(array)
        • id46
        • account_executive_id235
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties8
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties4
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id1
        • WOEID2495775
        • timezoneUS/Pacific
        • luxury_feed_enrollment_modemanual
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id
        • mlsidx_lux_autofeed(false)
        • mlsidx_lux_autofeed_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • nameVanguard Properties
        • broker_of_record_name
        • short_nameVanguard Properties
        • usernameVanguardSonoma
        • passworde8045814d4cc920c82b1497cdc9288d62d2c8c16
        • password_reset_hash
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date0000-00-00
        • monthly_invoice_end_date0000-00-00
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>Vanguard Properties is the exclusive representative for Leverage Global Partners in Sonoma, California, USA.</p> <p>For close to 30 years, Vanguard Properties has offered impeccable service to buyers and sellers throughout the Bay Area. Vanguard Properties Sonoma specializes in offering its clients service beyond their expectations whether buying or selling. Vanguard Properties represents many of the most prominent homes in the beautiful California wine country region of Sonoma County.</p> <p>Whether looking for an expansive luxury estate to a wonderful country farm house to vineyard land to produce estate grown grapes and perhaps build your dream home, Vanguard Properties Sonoma is your resource for quality Real Estate services to ensure a smooth transaction.</p> <p>In addition if you are looking to sell any of the aforementioned types of properties Vanguard Properties Sonoma has the expertise, the knowledge and the marketing savvy to expose your property to a worldwide network of realtors. Many Sonoma County home buyers are from San Francisco. That being said the Bay Area owned and operated <a href="../../../brokerage-detail/18/Vanguard-Properties" target="_blank">Vanguard Properties San Francisco</a> gives you the extra added value of being showcased not only in Sonoma County but in San Francisco, as well.</p> <p>We are proud of our team of professionals, who are service-driven and passionately share in your goal to find the home that’s right for you in the manner that fits your lifestyle.</p> <p>COMMITMENT</p> <p>At Vanguard, we stake our reputation on every relationship we create. Your unique client experience will be built on the high degree of professionalism and on our commitment to delivering service tailored to your individual needs, at every point of contact. With Vanguard by your side, you can feel confident that all aspects of your development are in good hands. We are proud to have provided developers with expert service for over twenty years now, including buyer insights that come by working with discerning buyers in highly dynamic markets. But we are only as good as the service we offer to the valued clients we work with today. They demand nothing but the best. Fortunately, we're in a position to deliver.</p> <p>DISTINCTION</p> <p>Vanguard brings exceptional homes to market, consistently and with outstanding results, under the guidance of some of the most respected professionals in the business. Our founder, James Nunemacher, is within the top 1% of real estate sales in the nation, and an acknowledged expert in the market. His exacting standards set the tone for everything we do. Simply put, no one is more qualified than Vanguard. This was true when we opened for business selling residential real estate. It has never been truer today, as our services have grown to encompass every aspect of the process of developing and marketing the most sought-after homes and developments in one of the most competitive markets.</p> <p>SERVICE</p> <p>Vanguard understands what discerning buyers and sellers are looking for, and equally importantly, what they are not. As your trusted partner, we will review and advise on every aspect of your home, from floor plans to finishing touches. Our instinct for detail may result in suggestions that surprise you.</p> <p>MARKETING</p> <p>Quality homes may be timeless. Marketing, however, demands the ability to match the leading-edge of customer expectations and stay several steps ahead of your competition. Vanguard's leadership is no more obvious than in the field of marketing. We will develop fresh, innovative strategies for you, incorporating a keen sense of brand-identity and integrating the technology that drives the housing market today. Your home is much more than simply brick and mortar. It is an investment upon which you expect the highest returns. With Vanguard's marketing acumen you can be confident that your home-buying audience is appropriately targeted and your return on investment is fully realized.</p>
        • communitiessonoma sebastopol healdsburg
        • websitehttp://vanguardsf.com/
        • address978 Gravenstein Highway South
        • address_2
        • citySebastopol
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • marketSonoma
        • market_2
        • postal_code95472
        • phone(415) 321-7007
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameJames Nunemacher
        • contact_profile_link
        • contact_big_profile_linkhttp://www.leveragere.com/blog/meet-james-nunemacher-principal-vanguard-properties/
        • contact_big_profile_link_text
        • contact_titleCEO
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename46.jpg
        • logo_filename46.jpg
        • contact_image_filename46.jpg
        • all_properties_link_image_filename46.jpg
        • all_properties_linkhttp://vanguardsf.com/VGlistings.php
        • video_embed_code
        • contact_video_embed_code
        • meta_titleSonoma Real Estate | Vanguard Properties| Leverage Global Partners
        • meta_descriptionVanguard Properties is the exclusive representative for Leverage Global Partners in Sonoma, CA, USA.
        • meta_keywordsVanguard Properties, sonoma real estate, James Nunemacher, leverage global partners
        • login_message_counter1
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2013-09-11 10:43:00
        • modified2016-04-08 16:33:30
        • dre_num012345
        • uri/brokerage-detail/46/vanguard-properties
        • website_shortvanguardsf.com
        • name_with_locationVanguard Properties
      • Image(array)
        • id3025
        • modelLocation
        • model_id91
        • tagImage
        • name46.jpg
        • typeimage/jpeg
        • size190364
        • uri/assets/3025.jpg
        • order0
        • created2016-04-05 11:20:35
        • modified2016-04-14 13:32:23
      • modelLocation
    • 2(array)
      • Topic(array)
        • id19
        • nameHome Improvement
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:32:33
        • tile_nameHome Improvement
      • Image(array)
        • id11
        • modelTopic
        • model_id19
        • tagImage
        • nameHome Improvement.jpg
        • typeimage/jpeg
        • size9696049
        • uri/assets/11.jpg
        • order0
        • created2016-02-25 11:32:29
        • modified2016-02-25 11:32:33
      • modelTopic
    • 3(array)
      • Topic(array)
        • id7
        • nameEquestrian
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:31:54
        • tile_nameEquestrian
      • Image(array)
        • id8
        • modelTopic
        • model_id7
        • tagImage
        • nameEquestrian.jpg
        • typeimage/jpeg
        • size5901188
        • uri/assets/8.jpg
        • order0
        • created2016-02-25 11:31:51
        • modified2016-02-25 11:31:54
      • modelTopic
  • recent_articles(array)
    • 0(array)
      • Article(array)
        • id437
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(true)
        • large_featured(true)
        • titleHome Improvement: True Colors
        • authorLeverageRE
        • date2016-03-29
        • lead_inThe UK brand launched past fall, all created using the same age-old production methods that its factory in Dorset, England, has been employing since the company's beginnings in 1946. The pigments - in bold shades like Yellow-cake - complement the ex-listing palette, which totals 132 interior and exterior finishes ($95–$126.50/ gallon), all of which have minimal volatile organic compounds (VOCs). Last winter, Farrow & Ball also unveiled four new wallpaper patterns. Each is available in find colorways. The new additions are hand-crafted using real paint, giving them a uniquely tactile appearance.
        • body<h3><strong><em>Nothing transforms a room as quickly and easily as a fresh coat of paint. Some of the world's lead- ing paint manufacturers recently introduced a fresh batch of colors, all in eco-friendly formulas.</em></strong></h3> <h3><strong><a href="http://us.farrow-ball.com/#1" target="_blank">Farrow & Ball Papers and Paint</a></strong></h3> <p><img class="aligncenter wp-image-12935 pure-img" src="/assets/3050.jpg" /></p> <h3><strong><a href="http://www.sherwin-williams.com/homeowners/products/catalog/categories/interior-paint-coatings/" target="_blank">Sherwin-Williams Enhanced Harmony</a></strong></h3> <p>Sherwin-Williams' <a href="http://www.sherwin-williams.com/homeowners/products/catalog/categories/interior-paint-coatings/" target="_blank">Enhanced Harmony</a> (from $48.99/gallon) delivers great coverage and a durable finish that can withstand frequent washings. But it also does something people don't expect from paint: Once it has dried, the paint's odor-eliminating technology reduces ambient odors of organic origin, such as those from cooking, smoke, and pets. The result is a beautiful room that stays fresher, longer. Enhanced Harmony also contains antimicrobial agents to inhibit the growth of mold and mildew on the paint film.</p> <p><img class="aligncenter wp-image-12937 pure-img" src="/assets/3051.png" /></p> <h3><strong><a href="http://www.benjaminmoore.com/en-us/welcome-to-benjamin-moore" target="_blank">Benjamin Moore Natura Renew</a></strong></h3> <p>Benjamin Moore's new <a href="http://www.benjaminmoore.com/en-us/for-your-home/paint-products/natura-waterborne-interior-paint?lang=en_US&role=H#advs=0&tab=2" target="_blank">Natura Renew</a> ($67.99/gallon) is an industry first. Made from a plant-based formula containing up to 40 percent bio-renewable materials, it has zero emissions and low odor but still goes on easily. Durable and washable, Natural Renew comes in thousands of colors with an eggshell and semi-gloss finish.</p> <p><img class="aligncenter wp-image-12936 pure-img" src="/assets/3052.png" /></p> <p> </p>
        • vimeo_id
        • created2016-04-05 14:30:21
        • modified2016-04-11 17:04:31
        • uri/articles/view/437/home-improvement-true-colors
      • Image(array)
        • 0(array)
          • id3053
          • modelArticle
          • model_id437
          • tagImage
          • nameHarmony-Room-image-1619-greige-and-green-living-room.jpg
          • typeimage/jpg
          • size1407496
          • uri/assets/3053.jpg
          • order0
          • created2016-04-05 14:30:21
          • modified2016-04-11 17:04:31
    • 1(array)
      • Article(array)
        • id479
        • modelLocation
        • model_id21
        • archived(false)
        • medium_featured(false)
        • large_featured(true)
        • titleLocation: London
        • authorLeverageRE
        • date2016-03-29
        • lead_inLondon Calling! Synonymous with Big Ben, Westminster Abbey, double-decker buses, and the Royal Family, London is undoubtedly the most fascinating city in the United Kingdom. Home of Leverage Partner Beauchamp Estates, London is also the political, economic and cultural capital of England, offering thousands of historical and modern-day attractions.
        • body<p>It is one of the world’s most visited cities, as well as being a global city steeped in arts, entertainment, media, fashion and finance. It boasts some 43 universities, and is culturally diverse, with more than 300 languages spoken in Greater London. The depth and array of what London has to offer is virtually unparalleled anywhere in the world!</p> <p><img src="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Screen-Shot-2016-03-28-at-7.35.29-PM.png" /></p> <p><strong>BA</strong><strong>T.</strong>  The Marylebone Cricket Club was founded in St. John's Wood in 1787, launching England's national sport. There's no better place to learn about wickets and donkey drops than <a href="http://www.lords.org/" target="_blank"><strong>Lord's</strong> <strong>Cricket</strong> <strong>Ground</strong></a>, which has a museum and hosts regular tours.</p> <p><img class="aligncenter wp-image-12911 pure-img" src="/assets/3301.png" /></p> <p><strong>LET</strong> <strong>IT</strong> <strong>BE.</strong>  <a href="http://www.abbeyroad.com/" target="_blank"><strong>Abbey</strong> <strong>Road</strong> <strong>Studios</strong></a> was immortalized by the Beatles, but Paul Robeson recorded there as far back as 1931. Fab Four pilgrims can't tour inside, but they can take a picture at the famous zebra crossing that graced the Beatles album and post it on the live "Crossing Cam," or write their name on the wall in front of the building.</p> <p><strong>PREEN.</strong>  The High Street area is chocka-block with cool boutiques: hip French labels like <a href="http://www.thekooples.com/" target="_blank"><strong>The</strong> <strong>Kooples</strong></a> and prêt-à-porter pioneer <a href="http://www.georges-rech.fr/" target="_blank"><strong>Georges</strong> <strong>Rech</strong></a>, the designer brand retailer <a href="http://www.joseph-fashion.com/" target="_blank"><strong>Joseph</strong></a> and one outpost of Nicky Kinnaird's beauty products empire, <a href="http://www.spacenk.com/" target="_blank"><strong>SpaceNK</strong></a>.</p> <p><img class="aligncenter wp-image-12910 pure-img" src="/assets/3302.png" /></p> <p><strong>STROLL.  </strong>Primrose Hill Park is where the locals hang. Its views of London are un-paralleled, and the bucolic quietude of this green space distills the reason why people live here.</p> <p><img class="aligncenter wp-image-12909 pure-img" src="/assets/3303.png" /></p> <p> </p>
        • vimeo_id
        • created2016-04-05 14:34:59
        • modified2016-04-11 16:51:49
        • uri/articles/view/479/location-london
      • Image(array)
        • 0(array)
          • id3304
          • modelArticle
          • model_id479
          • tagImage
          • nameScreen-Shot-2016-03-28-at-7.36.18-PM.png
          • typeimage/png
          • size1989440
          • uri/assets/3304.png
          • order0
          • created2016-04-05 14:35:00
          • modified2016-04-11 16:51:49
  • article(array)
    • Article(array)
      • id475
      • modelArticle
      • model_id0
      • archived(false)
      • medium_featured(true)
      • large_featured(true)
      • titleDecadent Dream Homes for 2016
      • authorLeverageRE
      • date2016-02-27
      • lead_inFrom mountaintop views and spa-like backyard paradises, to amenities designed for only the most discriminating of tastes, these dream properties from our Leverage Partners are truly fantasy-worthy:
      • body<h2><strong>Country Paradise</strong><br /> <strong>Presented by Leverage Partner Special Properties</strong></h2> <p><img class="aligncenter wp-image-12241 size-full pure-img" src="/assets/3282.jpg" /></p> <p>Complete with a multi-waterfall koi pond, pool, hot tub, and nature paths, this custom-built country paradise offers high-end appointments throughout.</p> <h2><strong>Red Mountain Grandeur</strong><br /> <strong>Presented by Leverage Partner Shane Aspen Real Estate</strong></h2> <p><img class="aligncenter wp-image-12247 size-full pure-img" src="/assets/3283.jpg" /></p> <p>This elegant Aspen estate sits on over an acre, with an outdoor heated swimming pool, generous rooms, soaring ceilings, and dramatic views.</p> <h2><strong>Historic Downtown Duplex</strong><br /> <strong>Presented by Leverage Partner CORE</strong></h2> <p><img class="aligncenter wp-image-12240 size-full pure-img" src="/assets/3284.jpg" /></p> <p>At the crossroads of Greenwich Village, the West Village and Soho, this historic downtown NYC duplex features a massive wall of glass opening onto a beautifully planted 500-square-foot terrace.</p> <h2><strong>The Storybook Life Begins in this Castle</strong><br /> <strong>Presented by Leverage Partner Partners Trust</strong></h2> <p><img class="aligncenter wp-image-12244 size-full pure-img" src="/assets/3285.jpg" /></p> <p>Live the dream that is Manhattan Beach in this divinely-appointed French Normandy Chateau-style villa, boasting luxurious amenities including soaring ceilings, an opulent gourmet kitchen, a Hollywood-style movie theatre, and wine cellar.</p> <h2><strong>Martis Camp</strong><br /> <strong>Presented by Leverage Partner Tahoe Mountain Realty</strong></h2> <p><img class="aligncenter wp-image-12245 size-full pure-img" src="/assets/3286.jpg" /></p> <p>Refreshing architecture and clean presentation make this mountain retreat a perfect combination of everything you are looking for in Martis Camp.</p> <h2><strong>Casa Rancho</strong><br /> <strong>Presented by Leverage Partner Timothy Real Estate Group</strong></h2> <p><img class="aligncenter wp-image-12246 size-full pure-img" src="/assets/3287.jpg" /></p> <p>Nestled amid acres of lush tropical gardens in Punta Mita, Mexico, this 42,000 square foot estate offers unparalleled luxury set on 4.5 magnificent private beachfront acres.</p> <p>Do you dream of living in a luxurious home in 2016? What does your fantasy dream home look like? Please share your thoughts and leave your comments below.</p>
      • vimeo_id
      • created2016-04-05 14:32:12
      • modified2016-04-11 17:03:02
      • uri/articles/view/475/decadent-dream-homes-for-2016
      • flattened_topics(array)
        • 0Ultra 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)
        • id3288
        • modelArticle
        • model_id475
        • tagImage
        • name23997-1.jpg
        • typeimage/jpg
        • size717675
        • uri/assets/3288.jpg
        • order0
        • created2016-04-05 14:32:12
        • modified2016-04-11 17:03:02
    • Brokerage(array)
      • 0(array)
        • id214
        • account_executive_id235
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typeBasic
        • max_properties8
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties4
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id0
        • WOEID2508245
        • 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
        • nameTahoe Mountain Realty
        • broker_of_record_name
        • short_nameTahoe Mountain Realty
        • usernameTahoeMountainRealty
        • password4cef6eba416704066d3a8b841f2c8f2c4c322fea
        • 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>Tahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, Northstar, Mountainside at Northstar, Lahontan, Schaffer's Mill, Old Greenwood, and Gray's Crossing, CA, USA.</p> <p>They are the leading brokerage for high end boutique luxury real estate with expertise in the most sought after resort communities and Tahoe lakefront properties in the North Tahoe region.</p> <p>TAHOE MARKET EXPERTS</p> <p>With a team of over 20 real estate professionals who love living the Tahoe life and enjoy helping others find their Tahoe dream, TMR is pleased to help you and your family with all your Tahoe real estate needs.</p> <p>Our successful sales history begins with our absolute focus on client service and includes many market advantages, such as, our high-traffic sales galleries in The Village at Northstar, The Ritz-Carlton, Gray's Crossing and Old Greenwood, the area’s largest and most productive database of prospective buyers and data driven marketing programs.</p>
        • communitiesTruckee Northstar Mountainside at Northstar Lahontan Schaffer's Mill Old Greenwood Gray's Crossing
        • websitehttp://www.tmrrealestate.com/
        • address3001 Northstar Drive Suite 100
        • address_2PO Box 3757
        • cityTruckee
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • marketTruckee, Lake Tahoe
        • market_2
        • postal_code96160
        • phone(530) 550-2000
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameTahoe Market Experts
        • contact_profile_link
        • contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-tahoe-mountain-realty/
        • contact_big_profile_link_textMeet The Team at Tahoe Mountain Realty
        • contact_titleLuxury Real Estate Professionals
        • contact_dre_num
        • contact_quoteWe invite you to contact us about Truckee, Lake Tahoe 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_filename214.jpg
        • logo_filename214.png
        • contact_image_filename214.jpg
        • all_properties_link_image_filename214.jpg
        • all_properties_linkhttp://tahoemountainrealty.idxbroker.com/idx/featured
        • video_embed_code
        • contact_video_embed_code
        • meta_titleTruckee Real Estate⎜Tahoe Mountain Realty⎜Leverage Global Partners
        • meta_descriptionTahoe Mountain Realty is the exclusive representative for Leverage Global Partners in Truckee, CA, USA.
        • meta_keywordsTahoe Mountain Realty, Truckee Real Estate, Northstar Real Estate, Mountainside at Northstar Real Estate, Lahontan Real Estate, Schaffer's Mill Real Estate, Old Greenwood Real Estate, Gray's Crossing Real Estate, California Real Estate, Leverage Global Partners, Jeff 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)
        • created2015-07-21 10:20:40
        • modified2016-04-08 16:34:26
        • dre_num012345
        • uri/brokerage-detail/214/tahoe-mountain-realty
        • website_shortwww.tmrrealestate.com
        • name_with_locationTahoe Mountain Realty
        • ArticlesBrokerage(array)
          • id53
          • article_id475
          • brokerage_id214
      • 1(array)
        • id206
        • account_executive_id235
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typeBasic
        • max_properties8
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties0
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id0
        • WOEID2486435
        • 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
        • nameSpecial Properties
        • broker_of_record_name
        • short_nameSpecial Properties
        • usernameSpecialProperties
        • password80bff9ecdfafd4cb525f795d439c9f6d73b691dd
        • 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>Special Properties is the exclusive representative for Leverage Global Partners in Allendale, Alpine, Cliffside Park, Cresskill, Demarest, Edgewater, Englewood, Englewood Cliffs, Fort Lee, Franklin Lakes, Ho Ho Kus, Mahwah, Oakland, Old Tappan, Ramsey, Ridgewood, Saddle River, Tenafly, Upper Saddle River, Woodcliff Lake, Wyckoff, NJ USA.</p> <p>Special Properties, Division of Brook Hollow Group, Inc. Realtors is a Real Estate brokerage firm located in Saddle River, NJ, serving New Jersey and New York. Established in 1992, we specialize in the marketing and selling of luxury properties. We market at the highest level and offer a full range of real estate services. Our Realtor Associates and our staff are highly experienced and operate at an unparalleled level.</p> <p>We are pleased to announce the opening of 2 new offices in Mahwah and Franklin Lakes, New Jersey. Please contact us to find out more information regarding Special Properties Real Estate Services, LLC.</p> <p>Our exclusive affiliation with Christie’s International Real Estate for Northwest Bergen County offers us the ability to relocate our clients anywhere in the world at the same high standard they expect in doing business with us.</p> <p>Our newest affiliation with Leverage Global Partners is adding to our network of affiliates who have the same high level of marketing and service standards that we do. We are very excited about this new relationship. We have exclusive affiliations with several magazine publications which are national as well as New York City/Metropolitan area based.</p> <p>Contact us for additional information about our extensive marketing program, our exclusive listings as well as all multiple listed properties on our website.</p>
        • communitiesSaddle River Bergen County Allendale Alpine Cliffside Park Cresskill Demarest Edgewater Englewood Englewood Cliffs Fort Lee Franklin Lakes Ho Ho Kus Mahwah Oakland Old Tappan Ramsey Ridgewood Saddle River Tenafly Upper Saddle River Woodcliff Lake Wyckoff
        • websitehttp://www.specialproperties.com/
        • address158 West Saddle River Road
        • address_2
        • citySaddle River
        • stateNJ
        • full_stateNew Jersey
        • countryUSA
        • market
        • market_2
        • postal_code07458
        • phoneOffice: (201) 934-7111
        • phone_2Cell: (201) 390-5880
        • phone_3
        • wide_contact_image(false)
        • contact_nameVicki Gaily
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titleCo 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_filename206.jpg
        • logo_filename206.jpg
        • contact_image_filename206.jpg
        • all_properties_link_image_filename206.jpg
        • all_properties_linkhttp://www.specialproperties.com/sales/usa/broker-listings-dstype
        • video_embed_code
        • contact_video_embed_code
        • meta_titleSaddle River Real Estate | Special Properties | Leverage Global Partners
        • meta_descriptionSpecial Properties is the exclusive representative for Leverage Global Partners in Saddle River including all of Bergen County, NJ USA.
        • meta_keywordsSpecial Properties, Saddle River real estate, Bergen County real estate, North Jersey real estate
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2015-06-18 09:41:48
        • modified2016-04-08 16:34:26
        • dre_num012345
        • uri/brokerage-detail/206/special-properties
        • website_shortwww.specialproperties.com
        • name_with_locationSpecial Properties
        • ArticlesBrokerage(array)
          • id52
          • article_id475
          • brokerage_id206
      • 2(array)
        • id104
        • account_executive_id236
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties8
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties4
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id0
        • WOEID137895
        • 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
        • nameTimothy Real Estate Group
        • broker_of_record_name
        • short_nameTimothy Real Estate Group
        • usernameTimothyRealEstate
        • password6641f951de5e691deddeb17430232d757e8f463b
        • password_reset_hash
        • monthly_invoice_amount0.00
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename
        • active(true)
        • lead_in
        • short_description
        • description<p>Timothy Real Estate Group is the exclusive representative for Levergae Global Partners in Puerto Vallarta, Punta de Mita, Riviera Nayarit, Bay of Banderas, Mexico.</p> <p>Timothy Real Estate Group is a locally owned and operated full service real estate brokerage. We have the finest, most professionally trained estate agents in he Bay of Banderas. Throughout changing markets we have established our position as the consistent leader is sales volume and listing inventory year after year.</p> <p>Because the Puerto Vallarta area has varying neighborhood personalities, we practice localized real estate service. We believe understanding neighborhoods is a top factor in satisfaction with your investment, and we know our communities well.</p> <p>We enable our clients to realize their vision for the future. We understand and plan for their concerns and are dedicated to transforming those concerns into peace of mind and joy.</p> <p>Our philosophy of transparency, integrity, and professionalism permeates our culture with a tangible sense of purpose and results in the length and depth of the quality relationships we enjoy. We believe buying or selling a home is first and foremost about people. Of course we have the latest technology, marketing tools, statistics and research, but a successful real estate transaction really comes down to people. We believe in collaboration by connecting people in ways that bring satisfaction and happiness.</p> <p>When you combine extensive local knowledge and our long standing reputation for honesty and sound judgment, you have an unbeatable resource at your disposal. You have Timothy Real Estate Group, a constant leader in Puerto Vallarta real estate.</p>
        • communitiesPuerto Vallarta Punta de Mita Riviera Nayarit Bay of Banderas
        • websitehttp://www.timothyrealestategroup.com/
        • addressIgnacio L. Vallarta 130 Local 7
        • address_2Col. Emiliano Zapata
        • city Puerto Vallarta
        • state
        • full_state
        • countryMexico
        • market Puerto Vallarta
        • market_2
        • postal_code48380
        • phone(322) 223-5300
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameCarl Timothy
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titlePresident
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename104.jpg
        • logo_filename104.png
        • contact_image_filename104.jpg
        • all_properties_link_image_filename104.jpg
        • all_properties_linkhttp://www.timothyrealestategroup.com/property-list/
        • video_embed_code
        • contact_video_embed_code
        • meta_titlePuerto Vallarta Real Estate | Timothy Real Estate Group | Leverage Global Partners
        • meta_descriptionTimothy Real Estate Group is the exclusive representative for Leverage Global Partners in Puerto Vallarta, Mexico.
        • meta_keywordsTimothy Real Estate Group, Puerto Vallarta Real Estate, Carl Timothy, Puerto Vallarta Punta de Mita Riviera Nayarit Bay of Banderas Real Estate, Puetro Vallarta, 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)
        • created2014-03-25 17:36:50
        • modified2016-04-08 16:34:09
        • dre_num012345
        • uri/brokerage-detail/104/timothy-real-estate-group
        • website_shortwww.timothyrealestategroup.com
        • name_with_locationTimothy Real Estate Group
        • ArticlesBrokerage(array)
          • id51
          • article_id475
          • brokerage_id104
      • 3(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
        • ArticlesBrokerage(array)
          • id50
          • article_id475
          • brokerage_id4
      • 4(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)
          • id49
          • article_id475
          • brokerage_id16
    • Location(empty)
    • Property(empty)
    • Topic(array)
      • 0(array)
        • id20
        • nameUltra Lux
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:35:37
        • tile_nameUltra Lux
        • ArticlesTopic(array)
          • id343
          • article_id475
          • topic_id20
  • 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/475/decadent-dream-homes-for-2016
  Query String
  Request Method	GET
  Server Protocol	HTTP/1.1
  Gateway Interface	CGI/1.1
  Redirect Url	/articles/view/475/decadent-dream-homes-for-2016
  Remote Port	17157
  Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
  Server Admin	root@localhost
  Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
  Context Prefix
  Request Scheme	https
  Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
  Remote Addr	104.23.197.115
  Server Port	443
  Server Addr	172.24.32.44
  Server Name	staging2.leveragere.com
  Server Software	Apache
  Server Signature
  Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
  Http Host	staging2.leveragere.com
  Http Connection	Keep-Alive
  Http X Forwarded Proto	https
  Http Cf Visitor	{"scheme":"https"}
  Http Cf Ipcountry	US
  Http Cf Connecting Ip	216.73.216.172
  Http Cdn Loop	cloudflare; loops=1
  Http Cf Ray	a09d851b0cb0cf52-CMH
  Http Accept Encoding	gzip, br
  Http Cookie	CAKEPHP=aipf32o4lmcjsm810ju1vvnt01
  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	aiorHfK8CRJnCvkkTtrrtQAAANY
  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	aiorHfK8CRJnCvkkTtrrtQAAANY
  Fcgi Role	RESPONDER
  Php Self	/index.php
  Request Time Float	1781148445.9485
  Request Time	1781148445

  ====
• Include
  +

  Included Files

  Include Paths

  • 0/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib
  • 2/opt/plesk/php/7.4/share/pear
  • 3-> /var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib/Cake/

  Included Files

  • core(array)
    • Behavior(array)
      • 0CORE/Model/Behavior/ContainableBehavior.php
    • Cache(array)
      • 0CORE/Cache/Cache.php
      • 1CORE/Cache/Engine/FileEngine.php
      • 2CORE/Cache/CacheEngine.php
    • Component(array)
      • 0CORE/Controller/Component/AuthComponent.php
      • 1CORE/Controller/Component/SessionComponent.php
      • 2CORE/Controller/Component/CookieComponent.php
      • 3CORE/Controller/Component/RequestHandlerComponent.php
      • 4CORE/Controller/Component/Auth/FormAuthenticate.php
      • 5CORE/Controller/Component/Auth/BaseAuthenticate.php
    • Config(array)
      • 0CORE/Config/routes.php
      • 1CORE/Config/config.php
    • Controller(array)
      • 0CORE/Controller/Controller.php
      • 1CORE/Controller/ComponentCollection.php
      • 2CORE/Controller/Component.php
    • Datasource(array)
      • 0CORE/Model/Datasource/CakeSession.php
      • 1CORE/Model/Datasource/Database/Mysql.php
      • 2CORE/Model/Datasource/DboSource.php
      • 3CORE/Model/Datasource/DataSource.php
    • Error(array)
      • 0CORE/Error/exceptions.php
      • 1CORE/Error/ErrorHandler.php
    • I18n(array)
      • 0CORE/I18n/I18n.php
      • 1CORE/I18n/L10n.php
    • Log(array)
      • 0CORE/Log/CakeLog.php
      • 1CORE/Log/LogEngineCollection.php
      • 2CORE/Log/Engine/FileLog.php
      • 3CORE/Log/Engine/BaseLog.php
      • 4CORE/Log/CakeLogInterface.php
    • Model(array)
      • 0CORE/Model/Model.php
      • 1CORE/Model/BehaviorCollection.php
      • 2CORE/Model/ModelBehavior.php
      • 3CORE/Model/ConnectionManager.php
    • Network(array)
      • 0CORE/Network/CakeRequest.php
      • 1CORE/Network/CakeResponse.php
    • Other(array)
      • 0CORE/bootstrap.php
      • 1CORE/basics.php
      • 2CORE/Core/App.php
      • 3CORE/Core/Configure.php
      • 4CORE/Core/CakePlugin.php
      • 5CORE/Event/CakeEventListener.php
      • 6CORE/Event/CakeEvent.php
      • 7CORE/Event/CakeEventManager.php
      • 8CORE/Core/CakeObject.php
    • Routing(array)
      • 0CORE/Routing/Dispatcher.php
      • 1CORE/Routing/Filter/AssetDispatcher.php
      • 2CORE/Routing/DispatcherFilter.php
      • 3CORE/Routing/Filter/CacheDispatcher.php
      • 4CORE/Routing/Router.php
      • 5CORE/Routing/Route/CakeRoute.php
      • 6CORE/Routing/Route/RedirectRoute.php
      • 7CORE/Routing/Route/PluginShortRoute.php
    • Utility(array)
      • 0CORE/Utility/Hash.php
      • 1CORE/Utility/Inflector.php
      • 2CORE/Utility/ObjectCollection.php
      • 3CORE/Utility/Debugger.php
      • 4CORE/Utility/CakeText.php
      • 5CORE/Utility/ClassRegistry.php
    • View(array)
      • 0CORE/View/HelperCollection.php
  • app(array)
    • Component(array)
      • 0APP/Controller/Component/PermissionComponent.php
      • 1APP/Controller/Component/ExploreComponent.php
      • 2APP/Controller/Component/LocationSearchComponent.php
    • Config(array)
      • 0APP/Config/core.php
      • 1APP/Config/bootstrap.php
      • 2APP/Config/routes.php
      • 3APP/Config/database.php
    • Controller(array)
      • 0APP/Controller/ArticlesController.php
      • 1APP/Controller/AppController.php
    • Model(array)
      • 0APP/Model/Subscription.php
      • 1APP/Model/AppModel.php
      • 2APP/Model/Article.php
      • 3APP/Model/Brokerage.php
      • 4APP/Model/Location.php
      • 5APP/Model/Property.php
      • 6APP/Model/User.php
      • 7APP/Model/PropertyFeature.php
      • 8APP/Model/PropertyCategory.php
      • 9APP/Model/Topic.php
      • 10APP/Model/Asset.php
      • 11APP/Model/StripeSubscription.php
      • 12APP/Model/GlobalReachReport.php
    • Other(array)
      • 0APP/webroot/index.php
      • 1APP/Vendor/permissions.php
  • plugins(array)
    • DebugKit(array)
      • Component(array)
        • 0DebugKit/Controller/Component/ToolbarComponent.php
      • Plugin(array)
        • 0DebugKit/Lib/DebugMemory.php
        • 1DebugKit/Lib/Panel/HistoryPanel.php
        • 2DebugKit/Lib/DebugPanel.php
        • 3DebugKit/Lib/Panel/SessionPanel.php
        • 4DebugKit/Lib/Panel/RequestPanel.php
        • 5DebugKit/Lib/Panel/SqlLogPanel.php
        • 6DebugKit/Lib/Panel/TimerPanel.php
        • 7DebugKit/Lib/Panel/LogPanel.php
        • 8DebugKit/Lib/Log/Engine/DebugKitLog.php
        • 9DebugKit/Lib/Panel/VariablesPanel.php
        • 10DebugKit/Lib/Panel/EnvironmentPanel.php
        • 11DebugKit/Lib/Panel/IncludePanel.php
        • 12DebugKit/Lib/DebugTimer.php

  ====