Location: Hawaii

LeverageRE

The country's youngest state (which joined the Union only in 1959) is something of an anomaly. It's the only one of the United States with a tropical rain forest and a royal palace, but it's also the only state that is made up entirely of islands-eight of them: Niihau, Kauai, Oahu, Maui, Molokai, Lanai, Kahoolawe, and the Big Island.  Leverage Partners Mauna Kea Realty (Big Island), The Wailea Group (Maui), and East Oahu Realty (Oahu) can attest that each island has its own unique characteristics.  But needless to say, wherever you are, you'll find an airy, summertime vibe year-round, with plenty of flower leis, luaus, and beach scenes.

Each of the Hawaiian islands has a distinct cultural relevance.  The Big Island, for instance, which is as big as all the others combined, encompasses about 4,000 square miles.  It's a trove of hidden beaches, volcanic national parks, rain forests, otherworldly waterfalls, and lush vegetation.

On Oahu, you'll find markers of both American history-Pearl Harbor, the USS Arizona Memorial-and Hawaiian history-the Iolani Palace and the Byodo-In Temple. It's also the location of the capital city, Honolulu, which is the biggest city in Hawaii. The island of Maui boasts pristine beaches and shimmering shores, but it also is home to the Road to Hana, one of the most traveled trails in the state.

Here, we explore destinations on the three islands in greater depth and share all the places to get out and enjoy before you say, "Aloha."

Located on Waikiki Beach, Halekulani welcomes travelers to an oasis of sophisticated luxury, and is recognized as one of the world's finest and most acclaimed independent luxury hotels since its inception in 1984.

Chef Peter Merriman had a vision for the growth of local agriculture and the potential of Hawaii's rich volcanic soils. He, along with twelve other prominent chefs, encouraged farmers to grow local fruits and vegetables, raise meats locally, and start a healthier more sustainable Hawaii. Showcasing locally sourced menus of fresh line caught fish, grass fed meats, and Hawaii grown produce, the authentic flavors of Hawaii await at Merriman's.

ZIPLINE AT UMAUMA FALLS

Catch the view from the top on this outdoor adventure, which boasts two miles of ziplines and family-friendly fun.

DOLPHIN SNORKEL SWIM, KAILUA-KONA

Swim with the dolphins in Hawaii's crystal-clear waters. The same company also offers whale watching.

WAIPIO VALLEY

The waterfalls in Waipio Valley, on the Big Island, are some of the most exquisite in the state. For a rustic adventure, see them from horseback.

DIAMOND HEAD

This crater was created by a giant eruption 300,000 years ago. Today, it's a landmark on Oahu, and a hiking trail (0.8 mile) winds through it.

HANAUMA BAY

When you imagine waters so blue that they'd be perfect for a postcard, this is the image that comes to mind. Sign up to snorkel to see angelfish, butterflyfish, and yellow tangs galore.

THE HIGHWAY HANA

Wind through approximately 600 curves on this Maui road to see the lush green countryside.

SNORKELING AT MOLOKINI

Swim with the turtles and fish at this Maui gem. For those who like to stay a bit drier, the yacht that takes you out is the perfect place to get a tan.

Share

• Topics:
• Beach
• Travel

• Location:
• BIG ISLAND OF HAWAII, HI, USA

Recent Articles

Fashion Trends: Spring 2016

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

Location: 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] => 455
            [model] => Location
            [model_id] => 114
            [archived] => 
            [medium_featured] => 1
            [large_featured] => 1
            [title] => Location: Hawaii
            [author] => LeverageRE
            [date] => 2016-03-23
            [lead_in] => The country's youngest state (which joined the Union only in 1959) is something of an anomaly. It's the only one of the United States with a tropical rain forest and a royal palace, but it's also the only state that is made up entirely of islands-eight of them: Niihau, Kauai, Oahu, Maui, Molokai, Lanai, Kahoolawe, and the Big Island.  Leverage Partners Mauna Kea Realty (Big Island), The Wailea Group (Maui), and East Oahu Realty (Oahu) can attest that each island has its own unique characteristics.  But needless to say, wherever you are, you'll find an airy, summertime vibe year-round, with plenty of flower leis, luaus, and beach scenes. 
            [body] => 
Each of the Hawaiian islands has a distinct cultural relevance.  The Big Island, for instance, which is as big as all the others combined, encompasses about 4,000 square miles.  It's a trove of hidden beaches, volcanic national parks, rain forests, otherworldly waterfalls, and lush vegetation.



On Oahu, you'll find markers of both American history-Pearl Harbor, the USS Arizona Memorial-and Hawaiian history-the Iolani Palace and the Byodo-In Temple. It's also the location of the capital city, Honolulu, which is the biggest city in Hawaii. The island of Maui boasts pristine beaches and shimmering shores, but it also is home to the Road to Hana, one of the most traveled trails in the state.

Here, we explore destinations on the three islands in greater depth and share all the places to get out and enjoy before you say, "Aloha."

Located on Waikiki Beach, Halekulani welcomes travelers to an oasis of sophisticated luxury, and is recognized as one of the world's finest and most acclaimed independent luxury hotels since its inception in 1984.



Chef Peter Merriman had a vision for the growth of local agriculture and the potential of Hawaii's rich volcanic soils. He, along with twelve other prominent chefs, encouraged farmers to grow local fruits and vegetables, raise meats locally, and start a healthier more sustainable Hawaii. Showcasing locally sourced menus of fresh line caught fish, grass fed meats, and Hawaii grown produce, the authentic flavors of Hawaii await at Merriman's.



ZIPLINE AT UMAUMA FALLS

Catch the view from the top on this outdoor adventure, which boasts two miles of ziplines and family-friendly fun.



DOLPHIN SNORKEL SWIM, KAILUA-KONA

Swim with the dolphins in Hawaii's crystal-clear waters. The same company also offers whale watching.



WAIPIO VALLEY

The waterfalls in Waipio Valley, on the Big Island, are some of the most exquisite in the state. For a rustic adventure, see them from horseback.



DIAMOND HEAD

This crater was created by a giant eruption 300,000 years ago. Today, it's a landmark on Oahu, and a hiking trail (0.8 mile) winds through it.



HANAUMA BAY

When you imagine waters so blue that they'd be perfect for a postcard, this is the image that comes to mind. Sign up to snorkel to see angelfish, butterflyfish, and yellow tangs galore.



THE HIGHWAY HANA

Wind through approximately 600 curves on this Maui road to see the lush green countryside.



SNORKELING AT MOLOKINI

Swim with the turtles and fish at this Maui gem. For those who like to stay a bit drier, the yacht that takes you out is the perfect place to get a tan.



            [vimeo_id] => 
            [created] => 2016-04-05 14:30:50
            [modified] => 2016-04-08 09:46:02
            [uri] => /articles/view/455/location-hawaii
            [flattened_topics] => Array
                (
                    [0] => Beach
                    [1] => Travel
                )

        )

    [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] => 114
            [parent_id] => 9
            [brokerage_id] => 48
            [type] => Exclusive
            [archived] => 
            [use_as_topic] => 
            [name] => BIG ISLAND OF HAWAII, HI, USA
            [short_name] => BIG ISLAND OF HAWAII, HI, USA
            [group_index] => 
            [latitude] => 37.090240
            [longitude] => -95.712891
            [country_code] => 
            [north] => 53.700001
            [south] => 19.700001
            [east] => -52.599998
            [west] => -146.600006
            [zoom] => 0
            [short_description] => The Kona-Kohala Coast is a contrast between the old and the new offering unspoiled natural beauty, a pristine environment together with world class properties and amenities.  
            [long_description] => The Kona-Kohala Coast of the Big Island of Hawaii is synonymous with world class resort/residential living. Home to some of Hawaii's finest golf courses, white sand beaches, restaurants and hotels, the Kona-Kohala Coast is within close proximity to ancient valleys, waterfalls, historically significant Heiaus and two of the tallest mountains in the world; Mauna Kea and Mauna Loa. Renown for its spectacular year round climate, the Big Island has attracted some of the titans of business, technology, medicine, entertainment, science and education who call the Kona-Kohala Coast their home away from home. Once the playground of Hawaiian royalty, the Big Island remains relatively untouched and offers a lifestyle found no where else in the world.  
            [created] => 2016-04-05 17:01:23
            [modified] => 2016-04-05 17:01:23
            [timezone] => Pacific/Honolulu
            [population] => 65000
            [uri] => /locations/view/114/big-island-of-hawaii-hi-usa
            [tile_name] => BIG ISLAND OF HAWAII, HI, USA
        )

    [Image] => Array
        (
            [0] => Array
                (
                    [id] => 3160
                    [model] => Article
                    [model_id] => 455
                    [tag] => Image
                    [name] => Screen-Shot-2016-03-23-at-3.51.26-PM.png
                    [type] => image/png
                    [size] => 2749979
                    [uri] => /assets/3160.png
                    [order] => 0
                    [created] => 2016-04-05 14:30:54
                    [modified] => 2016-04-08 09:46:03
                )

        )

    [Brokerage] => Array
        (
            [0] => Array
                (
                    [id] => 28
                    [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] => 0
                    [membership_luxury_feed_properties] => 0
                    [can_participate_in_lux_feed_while_archived] => 
                    [full_training_video_access] => 
                    [country_id] => 1
                    [WOEID] => 12485533
                    [timezone] => US/Hawaii
                    [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] => East Oahu Realty, RB-16090
                    [broker_of_record_name] => 
                    [short_name] => East Oahu Realty
                    [username] => EastOahu
                    [password] => 184254dea91b6c8586489ec50b8219bece099e54
                    [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] => 
East Oahu Realty is the exclusive representative for Leverage Global Partners in Honolulu, Oahu, Hawaii, USA.
In 1992, Jack Leslein, President & Founder of East Oahu Realty, Inc., ventured forward with his dream of creating a real estate company of Realtors that would make a difference. Our mission is to be a pacesetter in real estate services by sharing our knowledge and skillfully guiding our clients beyond their expectations.
Specializing in helping clients achieve their real estate objectives and focusing on personalized service and attention, East Oahu Realty became the home of trained and experienced Realtors, state of the art technology and dedicated support staff. East Oahu Realty is able to provide the utmost in professional real estate service.
As a locally owned, Kama’aina company, we respect and value our island heritage. We are committed to enhancing the lives of those who reside here by providing the utmost in service and community support. We know our market as well as the economic and social factors that shape it. Our knowledge, combined with our broad base of experience, assures you have the information you need to make an informed decision.
We are committed to your success, and we are leaders in our industry and our community. We take an active role in shaping the future of both. We are committed to maintaining our reputation of integrity and honesty.
We represent our clients enthusiastically and fairly and have done so since 1992. Choosing can make all the difference.
What Our Clients Can Expect:

Premier Market Presence
Select Team of Successful Real Estate Professionals
Global Networking and Exposure
Comprehensive Market Analysis & Plans
Member of Luxury Real Estate
State of the Art Technology
Multi-Lingual Realtors
Mortgage Services On-Site

                    [communities] => Honolulu Hawaii HI USA
Oahu Hawaii HI USA

                    [website] => http://www.eastoahu.com/
                    [address] => 6600 Kalanianaole Hwy # 114
                    [address_2] => 
                    [city] => Honolulu, Oahu
                    [state] => HI
                    [full_state] => Hawaii
                    [country] => USA
                    [market] => 
                    [market_2] => 
                    [postal_code] => 96825
                    [phone] => (808) 791-2216
                    [phone_2] => 
                    [phone_3] => 
                    [wide_contact_image] => 
                    [contact_name] => Cherie Tsukamoto
                    [contact_profile_link] => 
                    [contact_big_profile_link] => 
                    [contact_big_profile_link_text] => 
                    [contact_title] => Principal Broker, RB - 14911
                    [contact_dre_num] => 
                    [contact_quote] => I invite you to contact me personally regarding East Oahu Realty.
                    [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] => 28.jpg
                    [logo_filename] => 28.jpg
                    [contact_image_filename] => 28.jpg
                    [all_properties_link_image_filename] => 28.jpg
                    [all_properties_link] => http://www.eastoahu.com/search/FeaturedListings.aspx
                    [video_embed_code] => 
                    [contact_video_embed_code] => 
                    [meta_title] => Honolulu, Oahu Real Estate | East Oahu Realty | Leverage Global Partners
                    [meta_description] => East Oahu Realty is the exclusive representative for Leverage Global Partners in Oahu, Hawaii, USA.
                    [meta_keywords] => east oahu realty, oahu real estate, honolulu real estate, oahu hawaii, jack leslein, 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-05-10 18:19:12
                    [modified] => 2016-04-08 16:33:22
                    [dre_num] => 012345
                    [uri] => /brokerage-detail/28/east-oahu-realty-rb-16090
                    [website_short] => www.eastoahu.com
                    [name_with_location] => East Oahu Realty, RB-16090
                    [ArticlesBrokerage] => Array
                        (
                            [id] => 23
                            [article_id] => 455
                            [brokerage_id] => 28
                        )

                )

            [1] => Array
                (
                    [id] => 48
                    [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] => 0
                    [membership_luxury_feed_properties] => 0
                    [can_participate_in_lux_feed_while_archived] => 
                    [full_training_video_access] => 
                    [country_id] => 1
                    [WOEID] => 2513177
                    [timezone] => US/Hawaii
                    [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] => Mauna Kea Realty
                    [broker_of_record_name] => 
                    [short_name] => Mauna Kea Realty
                    [username] => MaunaKea
                    [password] => ce54200a54501e1e806c9faa3211e9ae1705158c
                    [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] => 
Mauna Kea Realty is the exclusive representative for Leverage Global Partners in the County of Hawaii, Hawaii, USA.

Aloha from Mauna Kea Realty, the exclusive real estate brokerage company at the legendary Mauna Kea Resort.

In addition to serving the needs of the property owners at Mauna Kea Resort, we also provide insight and services for the surrounding areas and resorts on the Kona-Kohala Coast. These include Kukio, Hualalai, Mauna Lani, Waikoloa, Puako, Kohala Waterfront, Kohala Ranch, Waimea and North Kohala.

The principals of Mauna Kea Realty started their real estate careers over 30 years ago, when the Kona Village Resort and the Mauna Kea Beach Hotel were the only lodging north of Kailua-Kona.

We have been part of the evolution of what has become one of the premier real estate markets in the world. We have participated in numerous transactions in all of the resorts and communities along the coast. We have a long-term perspective and the local knowledge that allows us to effectively serve the needs of our clients and customers.

Mauna Kea Realty has assembled a select group of highly talented professionals who service all sectors of the real estate market, including oceanfront, resort, ranch, single family, condominium and vacant land properties. Our combined $2+ billion in sales on the island, years of experience and market knowledge are some of the factors that separate Mauna Kea Realty from other real estate companies on the Big Island.

Please allow us the opportunity to demonstrate to you our professional commitment to finding the right place, at the right price for you and your family.

Mahalo,

Bob Chancer & Steve Hurwitz

                    [communities] => kona
kohala
hamakua
Huala
                    [website] => http://www.maunakearealty.com/
                    [address] => 62-100 Mauna Kea Beach Drive
                    [address_2] => 
                    [city] => Kohala Coast
                    [state] => HI
                    [full_state] => Hawaii
                    [country] => USA
                    [market] => Big Island of Hawaii
                    [market_2] => 
                    [postal_code] => 96743
                    [phone] => (808) 882-5600
                    [phone_2] => 
                    [phone_3] => 
                    [wide_contact_image] => 
                    [contact_name] => Steve Hurwitz
                    [contact_profile_link] => 
                    [contact_big_profile_link] => 
                    [contact_big_profile_link_text] => 
                    [contact_title] => President 
                    [contact_dre_num] => 
                    [contact_quote] => I invite you to contact me personally about Hawaii’s Big Island 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] => 48.jpg
                    [logo_filename] => 48.jpg
                    [contact_image_filename] => 48.jpg
                    [all_properties_link_image_filename] => 48.jpg
                    [all_properties_link] => http://maunakearealty.idxbroker.com/idx/featured
                    [video_embed_code] => 
                    [contact_video_embed_code] => 
                    [meta_title] => Big Island of Hawaii Real Estate | Mauna Kea Realty | Leverage Global Partners
                    [meta_description] => Mauna Kea Realty is the exclusive representative for Leverage Global Partners on the Island of Hawaii, HI, USA. 
                    [meta_keywords] => Mauna Kea Realty, hawaii real estate, Bob Chancer, leverage global partners, Steve Hurwitz
                    [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-09-13 16:06:14
                    [modified] => 2016-04-08 16:33:30
                    [dre_num] => 012345
                    [uri] => /brokerage-detail/48/mauna-kea-realty
                    [website_short] => www.maunakearealty.com
                    [name_with_location] => Mauna Kea Realty
                    [ArticlesBrokerage] => Array
                        (
                            [id] => 24
                            [article_id] => 455
                            [brokerage_id] => 48
                        )

                )

            [2] => Array
                (
                    [id] => 62
                    [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] => -1
                    [membership_luxury_feed_properties] => 0
                    [can_participate_in_lux_feed_while_archived] => 
                    [full_training_video_access] => 
                    [country_id] => 1
                    [WOEID] => 12588033
                    [timezone] => US/Hawaii
                    [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] => The Wailea Group
                    [broker_of_record_name] => 
                    [short_name] => The Wailea Group
                    [username] => WaileaGroup
                    [password] => 96cbf310f1191af607d1a68cb3d3240778537715
                    [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] => 
The Wailea Group is the exclusive representative for Leverage Global Partners in Maui, Lanai, and Moloka'i, Hawaii, USA.

The Wailea Group is a collaboration of sales and marketing professionals with deep respect for Wailea-Makena’s past, present and future. Wailea-Makena will continue to grow, this is a certainty. But equally certain is the control of that growth ensuring an unparalleled quality of life on Maui. We have already exclusively represented new development projects valued at over $2 billion, a tribute to the vision and integrity of our founders and our unique marketing insights and strategies. Wailea Beach Villas, Ho’olei and Papali were all represented by us and we’re now exclusively representing the Andaz. Our inventory of existing homes and condos and our knowledge of future development make us not only the logical choice among buyers and sellers but also the smart choice.

Visit Makali’i at Wailea

                    [communities] => Maui
Lanai
Moloka'i
                    [website] => http://www.thewaileagroup.com/HomeMain.aspx
                    [address] => 3750 Wailea Alanui
                    [address_2] => Suite 5EW
                    [city] => Wailea
                    [state] => HI
                    [full_state] => Hawaii
                    [country] => USA
                    [market] => Maui
                    [market_2] => 
                    [postal_code] => 96753
                    [phone] => Main: (808) 875-6911
                    [phone_2] => 
                    [phone_3] => 
                    [wide_contact_image] => 
                    [contact_name] => Scott Nelson
                    [contact_profile_link] => 
                    [contact_big_profile_link] => 
                    [contact_big_profile_link_text] => 
                    [contact_title] => Principal Broker
                    [contact_dre_num] => 
                    [contact_quote] => 
                    [contact_email] => [email protected]
                    [contact_facebook] => 
                    [contact_twitter] => 
                    [contact_instagram] => 
                    [contact_pinterest] => 
                    [contact_linkedin] => 
                    [contact_youtube] => 
                    [contact_phone] => 
                    [contact_email_2] => 
                    [contact_2_facebook] => 
                    [contact_2_twitter] => 
                    [contact_2_instagram] => 
                    [contact_2_pinterest] => 
                    [contact_2_linkedin] => 
                    [contact_2_youtube] => 
                    [contact_phone_2] => 
                    [contact_website] => 
                    [contact_name_2] => 
                    [contact_profile_link_2] => 
                    [contact_big_profile_link_2] => 
                    [contact_big_profile_link_text_2] => 
                    [contact_title_2] => 
                    [contact_dre_num_2] => 
                    [contact_email_3] => 
                    [contact_name_3] => 
                    [contact_title_3] => 
                    [contact_dre_num_3] => 
                    [contact_phone_3] => 
                    [contact_3_facebook] => 
                    [contact_3_twitter] => 
                    [contact_3_instagram] => 
                    [contact_3_pinterest] => 
                    [contact_3_linkedin] => 
                    [contact_3_youtube] => 
                    [image_filename] => 62.jpg
                    [logo_filename] => 62.gif
                    [contact_image_filename] => 62.jpg
                    [all_properties_link_image_filename] => 62.jpg
                    [all_properties_link] => http://www.thewaileagroup.com/Exclusive.aspx
                    [video_embed_code] => 
                    [contact_video_embed_code] => 
                    [meta_title] => Maui Real Estate | The Wailea Group | Leverage Global Partners
                    [meta_description] => The Wailea Group is the exclusive representative for Leverage Global Partners in Maui, HI, USA.
                    [meta_keywords] => The Wailea Group, maui real estate, hawaii real estate, rene sand, 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-10-09 12:08:12
                    [modified] => 2016-04-08 16:33:30
                    [dre_num] => 012345
                    [uri] => /brokerage-detail/62/the-wailea-group
                    [website_short] => www.thewaileagroup.com/HomeMain.aspx
                    [name_with_location] => The Wailea Group
                    [ArticlesBrokerage] => Array
                        (
                            [id] => 25
                            [article_id] => 455
                            [brokerage_id] => 62
                        )

                )

        )

    [Location] => Array
        (
            [0] => Array
                (
                    [id] => 32
                    [parent_id] => 9
                    [brokerage_id] => 28
                    [type] => Exclusive
                    [archived] => 
                    [use_as_topic] => 
                    [name] => Honolulu, Oahu, HI, USA
                    [short_name] => Honolulu, Oahu, HI, USA
                    [group_index] => 
                    [latitude] => 21.296232
                    [longitude] => -157.701981
                    [country_code] => 
                    [north] => 53.700001
                    [south] => 19.700001
                    [east] => -52.599998
                    [west] => -146.600006
                    [zoom] => 0
                    [short_description] => Honolulu, Oahu: Paradise has been found and it's calling your name!  
                    [long_description] => Whether you’re a sun-seeker, metropolitan maven, or adventure addict, Honolulu is the place to be! Located on beautiful Oahu, also known as the “The Gathering Place”, Hawaii’s most populous city is an alluring melting pot of cultures and cuisines. The relaxed lifestyle and ‘Aloha’ spirit will keep your mind at ease while our stunning mountains and pristine beaches keep you young and active. From famous historical sites to secluded natural treasures, residents here enjoy a boundless supply of scenic beauty and rejuvenating adventure. Also boasting world-class shopping, commerce and entertainment, you are sure to find your place in the sun!  

                    [created] => 2016-04-04 12:01:25
                    [modified] => 2016-04-04 12:03:35
                    [timezone] => Pacific/Honolulu
                    [population] => 953000
                    [uri] => /locations/view/32/honolulu-oahu-hi-usa
                    [tile_name] => Honolulu, Oahu, HI, USA
                    [ArticlesLocation] => Array
                        (
                            [id] => 18
                            [article_id] => 455
                            [location_id] => 32
                        )

                )

            [1] => Array
                (
                    [id] => 92
                    [parent_id] => 9
                    [brokerage_id] => 62
                    [type] => Exclusive
                    [archived] => 
                    [use_as_topic] => 
                    [name] => Maui, HI, USA
                    [short_name] => Maui, HI, USA
                    [group_index] => 
                    [latitude] => 20.798363
                    [longitude] => -156.331924
                    [country_code] => 
                    [north] => 53.700001
                    [south] => 19.700001
                    [east] => -52.599998
                    [west] => -146.600006
                    [zoom] => 0
                    [short_description] => 
                    [long_description] => More information coming soon!
                    [created] => 2016-04-05 11:22:53
                    [modified] => 2016-04-05 11:22:53
                    [timezone] => Pacific/Honolulu
                    [population] => 145000
                    [uri] => /locations/view/92/maui-hi-usa
                    [tile_name] => Maui, HI, USA
                    [ArticlesLocation] => Array
                        (
                            [id] => 19
                            [article_id] => 455
                            [location_id] => 92
                        )

                )

            [2] => Array
                (
                    [id] => 114
                    [parent_id] => 9
                    [brokerage_id] => 48
                    [type] => Exclusive
                    [archived] => 
                    [use_as_topic] => 
                    [name] => BIG ISLAND OF HAWAII, HI, USA
                    [short_name] => BIG ISLAND OF HAWAII, HI, USA
                    [group_index] => 
                    [latitude] => 37.090240
                    [longitude] => -95.712891
                    [country_code] => 
                    [north] => 53.700001
                    [south] => 19.700001
                    [east] => -52.599998
                    [west] => -146.600006
                    [zoom] => 0
                    [short_description] => The Kona-Kohala Coast is a contrast between the old and the new offering unspoiled natural beauty, a pristine environment together with world class properties and amenities.  
                    [long_description] => The Kona-Kohala Coast of the Big Island of Hawaii is synonymous with world class resort/residential living. Home to some of Hawaii's finest golf courses, white sand beaches, restaurants and hotels, the Kona-Kohala Coast is within close proximity to ancient valleys, waterfalls, historically significant Heiaus and two of the tallest mountains in the world; Mauna Kea and Mauna Loa. Renown for its spectacular year round climate, the Big Island has attracted some of the titans of business, technology, medicine, entertainment, science and education who call the Kona-Kohala Coast their home away from home. Once the playground of Hawaiian royalty, the Big Island remains relatively untouched and offers a lifestyle found no where else in the world.  
                    [created] => 2016-04-05 17:01:23
                    [modified] => 2016-04-05 17:01:23
                    [timezone] => Pacific/Honolulu
                    [population] => 65000
                    [uri] => /locations/view/114/big-island-of-hawaii-hi-usa
                    [tile_name] => BIG ISLAND OF HAWAII, HI, USA
                    [ArticlesLocation] => Array
                        (
                            [id] => 20
                            [article_id] => 455
                            [location_id] => 114
                        )

                )

        )

    [Property] => Array
        (
        )

    [Topic] => Array
        (
            [0] => Array
                (
                    [id] => 8
                    [name] => Beach
                    [created] => 2016-02-25 11:25:00
                    [modified] => 2016-02-25 11:30:26
                    [tile_name] => Beach
                    [ArticlesTopic] => Array
                        (
                            [id] => 270
                            [article_id] => 455
                            [topic_id] => 8
                        )

                )

            [1] => Array
                (
                    [id] => 10
                    [name] => Travel
                    [created] => 2016-02-25 11:25:00
                    [modified] => 2016-02-25 11:35:10
                    [tile_name] => Travel
                    [ArticlesTopic] => Array
                        (
                            [id] => 271
                            [article_id] => 455
                            [topic_id] => 10
                        )

                )

        )

)

• 
• History
  +

  Request History

  4 previous requests available

  • Restore to current request
  • articles/view/272/cul
  • private.key
  • private_key.pem
  • server.key

  ====
• Session
  +

  Session

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

  ====
• Request
  +

  Request

  Cake Params

  • plugin(null)
  • controllerarticles
  • actionview
  • named(empty)
  • pass(array)
    • 0455
    • 1location-hawaii
  • 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: 67 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` = 455 LIMIT 1	1	1	4	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` = (455) 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` = 455 AND `ArticlesBrokerage`.`brokerage_id` = `Brokerage`.`id`)	3	3	1	maybe slow
  SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `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` = 455 AND `ArticlesLocation`.`location_id` = `Location`.`id`)	3	3	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` = 455 AND `ArticlesProperty`.`property_id` = `Property`.`id`)	0	0	1	maybe slow
  SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `ArticlesTopic`.`id`, `ArticlesTopic`.`article_id`, `ArticlesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`articles_topics` AS `ArticlesTopic` ON (`ArticlesTopic`.`article_id` = 455 AND `ArticlesTopic`.`topic_id` = `Topic`.`id`)	2	2	3	maybe slow
  SELECT `Article`.`id` FROM `leveragere_staging2`.`articles` AS `Article` WHERE `Article`.`archived` = '0' AND NOT (`Article`.`model` = ('News')) ORDER BY `Article`.`date` DESC LIMIT 10	10	10	2	maybe slow
  SELECT `Article`.`id`, `Article`.`model`, `Article`.`model_id`, `Article`.`archived`, `Article`.`medium_featured`, `Article`.`large_featured`, `Article`.`title`, `Article`.`author`, `Article`.`date`, `Article`.`lead_in`, `Article`.`body`, `Article`.`vimeo_id`, `Article`.`created`, `Article`.`modified` FROM `leveragere_staging2`.`articles` AS `Article` WHERE `Article`.`id` IN (499, 486, 488, 487, 436, 476, 437, 477, 481, 479) ORDER BY RAND() ASC LIMIT 2	2	2	1	maybe slow
  SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (486, 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	1	maybe slow
  SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`locations` AS `Location` LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Location`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`assets` AS `Image` ON (`Image`.`model_id` = `Location`.`id` AND `Image`.`model` = 'Location' AND `Image`.`tag` = 'Image') WHERE `Location`.`use_as_topic` = '1' AND NOT (`Location`.`id` IS NULL) ORDER BY RAND() ASC LIMIT 1	1	1	2	maybe slow
  SELECT `Article`.`id`, `Article`.`model`, `Article`.`model_id`, `Article`.`archived`, `Article`.`medium_featured`, `Article`.`large_featured`, `Article`.`title`, `Article`.`author`, `Article`.`date`, `Article`.`lead_in`, `Article`.`body`, `Article`.`vimeo_id`, `Article`.`created`, `Article`.`modified`, `ParentBrokerage`.`id`, `ParentBrokerage`.`account_executive_id`, `ParentBrokerage`.`archived`, `ParentBrokerage`.`type`, `ParentBrokerage`.`hide_from_frontend`, `ParentBrokerage`.`agent_brokerage_data_override`, `ParentBrokerage`.`featured_development`, `ParentBrokerage`.`membership_type`, `ParentBrokerage`.`max_properties`, `ParentBrokerage`.`max_homepage_featured_by_member_properties`, `ParentBrokerage`.`featured_properties_sort_method`, `ParentBrokerage`.`lux_feed_mode`, `ParentBrokerage`.`max_luxury_feed_properties`, `ParentBrokerage`.`membership_luxury_feed_properties`, `ParentBrokerage`.`can_participate_in_lux_feed_while_archived`, `ParentBrokerage`.`full_training_video_access`, `ParentBrokerage`.`country_id`, `ParentBrokerage`.`WOEID`, `ParentBrokerage`.`timezone`, `ParentBrokerage`.`luxury_feed_enrollment_mode`, `ParentBrokerage`.`luxury_feed_include_mlsidx_minimum_price`, `ParentBrokerage`.`luxury_feed_include_leverage_minimum_price`, `ParentBrokerage`.`digital_ad_contacts`, `ParentBrokerage`.`add_agents_to_grr_auto_recipients`, `ParentBrokerage`.`mlsidx_id`, `ParentBrokerage`.`mlsidx_lux_autofeed`, `ParentBrokerage`.`mlsidx_lux_autofeed_minimum_price`, `ParentBrokerage`.`mlsidx_logo_url`, `ParentBrokerage`.`mlsidx_disclaimer`, `ParentBrokerage`.`name`, `ParentBrokerage`.`broker_of_record_name`, `ParentBrokerage`.`short_name`, `ParentBrokerage`.`username`, `ParentBrokerage`.`password`, `ParentBrokerage`.`password_reset_hash`, `ParentBrokerage`.`monthly_invoice_amount`, `ParentBrokerage`.`monthly_invoice_start_date`, `ParentBrokerage`.`monthly_invoice_end_date`, `ParentBrokerage`.`contract_filename`, `ParentBrokerage`.`active`, `ParentBrokerage`.`lead_in`, `ParentBrokerage`.`short_description`, `ParentBrokerage`.`description`, `ParentBrokerage`.`communities`, `ParentBrokerage`.`website`, `ParentBrokerage`.`address`, `ParentBrokerage`.`address_2`, `ParentBrokerage`.`city`, `ParentBrokerage`.`state`, `ParentBrokerage`.`full_state`, `ParentBrokerage`.`country`, `ParentBrokerage`.`market`, `ParentBrokerage`.`market_2`, `ParentBrokerage`.`postal_code`, `ParentBrokerage`.`phone`, `ParentBrokerage`.`phone_2`, `ParentBrokerage`.`phone_3`, `ParentBrokerage`.`wide_contact_image`, `ParentBrokerage`.`contact_name`, `ParentBrokerage`.`contact_profile_link`, `ParentBrokerage`.`contact_big_profile_link`, `ParentBrokerage`.`contact_big_profile_link_text`, `ParentBrokerage`.`contact_title`, `ParentBrokerage`.`contact_dre_num`, `ParentBrokerage`.`contact_quote`, `ParentBrokerage`.`contact_email`, `ParentBrokerage`.`contact_facebook`, `ParentBrokerage`.`contact_twitter`, `ParentBrokerage`.`contact_instagram`, `ParentBrokerage`.`contact_pinterest`, `ParentBrokerage`.`contact_linkedin`, `ParentBrokerage`.`contact_youtube`, `ParentBrokerage`.`contact_phone`, `ParentBrokerage`.`contact_email_2`, `ParentBrokerage`.`contact_2_facebook`, `ParentBrokerage`.`contact_2_twitter`, `ParentBrokerage`.`contact_2_instagram`, `ParentBrokerage`.`contact_2_pinterest`, `ParentBrokerage`.`contact_2_linkedin`, `ParentBrokerage`.`contact_2_youtube`, `ParentBrokerage`.`contact_phone_2`, `ParentBrokerage`.`contact_website`, `ParentBrokerage`.`contact_name_2`, `ParentBrokerage`.`contact_profile_link_2`, `ParentBrokerage`.`contact_big_profile_link_2`, `ParentBrokerage`.`contact_big_profile_link_text_2`, `ParentBrokerage`.`contact_title_2`, `ParentBrokerage`.`contact_dre_num_2`, `ParentBrokerage`.`contact_email_3`, `ParentBrokerage`.`contact_name_3`, `ParentBrokerage`.`contact_title_3`, `ParentBrokerage`.`contact_dre_num_3`, `ParentBrokerage`.`contact_phone_3`, `ParentBrokerage`.`contact_3_facebook`, `ParentBrokerage`.`contact_3_twitter`, `ParentBrokerage`.`contact_3_instagram`, `ParentBrokerage`.`contact_3_pinterest`, `ParentBrokerage`.`contact_3_linkedin`, `ParentBrokerage`.`contact_3_youtube`, `ParentBrokerage`.`image_filename`, `ParentBrokerage`.`logo_filename`, `ParentBrokerage`.`contact_image_filename`, `ParentBrokerage`.`all_properties_link_image_filename`, `ParentBrokerage`.`all_properties_link`, `ParentBrokerage`.`video_embed_code`, `ParentBrokerage`.`contact_video_embed_code`, `ParentBrokerage`.`meta_title`, `ParentBrokerage`.`meta_description`, `ParentBrokerage`.`meta_keywords`, `ParentBrokerage`.`login_message_counter`, `ParentBrokerage`.`stats_module_1_type`, `ParentBrokerage`.`stats_module_1_value`, `ParentBrokerage`.`stats_module_2_type`, `ParentBrokerage`.`stats_module_2_value`, `ParentBrokerage`.`stats_module_3_type`, `ParentBrokerage`.`stats_module_3_value`, `ParentBrokerage`.`last_activity_email_sent`, `ParentBrokerage`.`converted`, `ParentBrokerage`.`created`, `ParentBrokerage`.`modified`, `ParentBrokerage`.`dre_num`, `ParentLocation`.`id`, `ParentLocation`.`parent_id`, `ParentLocation`.`brokerage_id`, `ParentLocation`.`type`, `ParentLocation`.`archived`, `ParentLocation`.`use_as_topic`, `ParentLocation`.`name`, `ParentLocation`.`short_name`, `ParentLocation`.`group_index`, `ParentLocation`.`latitude`, `ParentLocation`.`longitude`, `ParentLocation`.`country_code`, `ParentLocation`.`north`, `ParentLocation`.`south`, `ParentLocation`.`east`, `ParentLocation`.`west`, `ParentLocation`.`zoom`, `ParentLocation`.`short_description`, `ParentLocation`.`long_description`, `ParentLocation`.`created`, `ParentLocation`.`modified`, `ParentLocation`.`timezone`, `ParentLocation`.`population` FROM `leveragere_staging2`.`articles` AS `Article` LEFT JOIN `leveragere_staging2`.`brokerages` AS `ParentBrokerage` ON (`Article`.`model_id` = `ParentBrokerage`.`id` AND `Article`.`model` = 'Brokerage') LEFT JOIN `leveragere_staging2`.`locations` AS `ParentLocation` ON (`Article`.`model_id` = `ParentLocation`.`id` AND `Article`.`model` = 'Location') WHERE `Article`.`id` = 455 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` = (455) 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` = 455 AND `ArticlesBrokerage`.`brokerage_id` = `Brokerage`.`id`)	3	3	1	maybe slow
  SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `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` = 455 AND `ArticlesLocation`.`location_id` = `Location`.`id`)	3	3	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` = 455 AND `ArticlesProperty`.`property_id` = `Property`.`id`)	0	0	1	maybe slow
  SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `ArticlesTopic`.`id`, `ArticlesTopic`.`article_id`, `ArticlesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`articles_topics` AS `ArticlesTopic` ON (`ArticlesTopic`.`article_id` = 455 AND `ArticlesTopic`.`topic_id` = `Topic`.`id`)	2	2	0
  SELECT `ArticlesTopic`.`id`, `ArticlesTopic`.`article_id` FROM `leveragere_staging2`.`articles_topics` AS `ArticlesTopic` WHERE `ArticlesTopic`.`topic_id` IN (8, 10)	47	47	0
  SELECT `Article`.`id`, `Article`.`model`, `Article`.`model_id`, `Article`.`archived`, `Article`.`medium_featured`, `Article`.`large_featured`, `Article`.`title`, `Article`.`author`, `Article`.`date`, `Article`.`lead_in`, `Article`.`body`, `Article`.`vimeo_id`, `Article`.`created`, `Article`.`modified`, `ParentBrokerage`.`id`, `ParentBrokerage`.`account_executive_id`, `ParentBrokerage`.`archived`, `ParentBrokerage`.`type`, `ParentBrokerage`.`hide_from_frontend`, `ParentBrokerage`.`agent_brokerage_data_override`, `ParentBrokerage`.`featured_development`, `ParentBrokerage`.`membership_type`, `ParentBrokerage`.`max_properties`, `ParentBrokerage`.`max_homepage_featured_by_member_properties`, `ParentBrokerage`.`featured_properties_sort_method`, `ParentBrokerage`.`lux_feed_mode`, `ParentBrokerage`.`max_luxury_feed_properties`, `ParentBrokerage`.`membership_luxury_feed_properties`, `ParentBrokerage`.`can_participate_in_lux_feed_while_archived`, `ParentBrokerage`.`full_training_video_access`, `ParentBrokerage`.`country_id`, `ParentBrokerage`.`WOEID`, `ParentBrokerage`.`timezone`, `ParentBrokerage`.`luxury_feed_enrollment_mode`, `ParentBrokerage`.`luxury_feed_include_mlsidx_minimum_price`, `ParentBrokerage`.`luxury_feed_include_leverage_minimum_price`, `ParentBrokerage`.`digital_ad_contacts`, `ParentBrokerage`.`add_agents_to_grr_auto_recipients`, `ParentBrokerage`.`mlsidx_id`, `ParentBrokerage`.`mlsidx_lux_autofeed`, `ParentBrokerage`.`mlsidx_lux_autofeed_minimum_price`, `ParentBrokerage`.`mlsidx_logo_url`, `ParentBrokerage`.`mlsidx_disclaimer`, `ParentBrokerage`.`name`, `ParentBrokerage`.`broker_of_record_name`, `ParentBrokerage`.`short_name`, `ParentBrokerage`.`username`, `ParentBrokerage`.`password`, `ParentBrokerage`.`password_reset_hash`, `ParentBrokerage`.`monthly_invoice_amount`, `ParentBrokerage`.`monthly_invoice_start_date`, `ParentBrokerage`.`monthly_invoice_end_date`, `ParentBrokerage`.`contract_filename`, `ParentBrokerage`.`active`, `ParentBrokerage`.`lead_in`, `ParentBrokerage`.`short_description`, `ParentBrokerage`.`description`, `ParentBrokerage`.`communities`, `ParentBrokerage`.`website`, `ParentBrokerage`.`address`, `ParentBrokerage`.`address_2`, `ParentBrokerage`.`city`, `ParentBrokerage`.`state`, `ParentBrokerage`.`full_state`, `ParentBrokerage`.`country`, `ParentBrokerage`.`market`, `ParentBrokerage`.`market_2`, `ParentBrokerage`.`postal_code`, `ParentBrokerage`.`phone`, `ParentBrokerage`.`phone_2`, `ParentBrokerage`.`phone_3`, `ParentBrokerage`.`wide_contact_image`, `ParentBrokerage`.`contact_name`, `ParentBrokerage`.`contact_profile_link`, `ParentBrokerage`.`contact_big_profile_link`, `ParentBrokerage`.`contact_big_profile_link_text`, `ParentBrokerage`.`contact_title`, `ParentBrokerage`.`contact_dre_num`, `ParentBrokerage`.`contact_quote`, `ParentBrokerage`.`contact_email`, `ParentBrokerage`.`contact_facebook`, `ParentBrokerage`.`contact_twitter`, `ParentBrokerage`.`contact_instagram`, `ParentBrokerage`.`contact_pinterest`, `ParentBrokerage`.`contact_linkedin`, `ParentBrokerage`.`contact_youtube`, `ParentBrokerage`.`contact_phone`, `ParentBrokerage`.`contact_email_2`, `ParentBrokerage`.`contact_2_facebook`, `ParentBrokerage`.`contact_2_twitter`, `ParentBrokerage`.`contact_2_instagram`, `ParentBrokerage`.`contact_2_pinterest`, `ParentBrokerage`.`contact_2_linkedin`, `ParentBrokerage`.`contact_2_youtube`, `ParentBrokerage`.`contact_phone_2`, `ParentBrokerage`.`contact_website`, `ParentBrokerage`.`contact_name_2`, `ParentBrokerage`.`contact_profile_link_2`, `ParentBrokerage`.`contact_big_profile_link_2`, `ParentBrokerage`.`contact_big_profile_link_text_2`, `ParentBrokerage`.`contact_title_2`, `ParentBrokerage`.`contact_dre_num_2`, `ParentBrokerage`.`contact_email_3`, `ParentBrokerage`.`contact_name_3`, `ParentBrokerage`.`contact_title_3`, `ParentBrokerage`.`contact_dre_num_3`, `ParentBrokerage`.`contact_phone_3`, `ParentBrokerage`.`contact_3_facebook`, `ParentBrokerage`.`contact_3_twitter`, `ParentBrokerage`.`contact_3_instagram`, `ParentBrokerage`.`contact_3_pinterest`, `ParentBrokerage`.`contact_3_linkedin`, `ParentBrokerage`.`contact_3_youtube`, `ParentBrokerage`.`image_filename`, `ParentBrokerage`.`logo_filename`, `ParentBrokerage`.`contact_image_filename`, `ParentBrokerage`.`all_properties_link_image_filename`, `ParentBrokerage`.`all_properties_link`, `ParentBrokerage`.`video_embed_code`, `ParentBrokerage`.`contact_video_embed_code`, `ParentBrokerage`.`meta_title`, `ParentBrokerage`.`meta_description`, `ParentBrokerage`.`meta_keywords`, `ParentBrokerage`.`login_message_counter`, `ParentBrokerage`.`stats_module_1_type`, `ParentBrokerage`.`stats_module_1_value`, `ParentBrokerage`.`stats_module_2_type`, `ParentBrokerage`.`stats_module_2_value`, `ParentBrokerage`.`stats_module_3_type`, `ParentBrokerage`.`stats_module_3_value`, `ParentBrokerage`.`last_activity_email_sent`, `ParentBrokerage`.`converted`, `ParentBrokerage`.`created`, `ParentBrokerage`.`modified`, `ParentBrokerage`.`dre_num`, `ParentLocation`.`id`, `ParentLocation`.`parent_id`, `ParentLocation`.`brokerage_id`, `ParentLocation`.`type`, `ParentLocation`.`archived`, `ParentLocation`.`use_as_topic`, `ParentLocation`.`name`, `ParentLocation`.`short_name`, `ParentLocation`.`group_index`, `ParentLocation`.`latitude`, `ParentLocation`.`longitude`, `ParentLocation`.`country_code`, `ParentLocation`.`north`, `ParentLocation`.`south`, `ParentLocation`.`east`, `ParentLocation`.`west`, `ParentLocation`.`zoom`, `ParentLocation`.`short_description`, `ParentLocation`.`long_description`, `ParentLocation`.`created`, `ParentLocation`.`modified`, `ParentLocation`.`timezone`, `ParentLocation`.`population` FROM `leveragere_staging2`.`articles` AS `Article` LEFT JOIN `leveragere_staging2`.`brokerages` AS `ParentBrokerage` ON (`Article`.`model_id` = `ParentBrokerage`.`id` AND `Article`.`model` = 'Brokerage') LEFT JOIN `leveragere_staging2`.`locations` AS `ParentLocation` ON (`Article`.`model_id` = `ParentLocation`.`id` AND `Article`.`model` = 'Location') WHERE `Article`.`id` IN (401, 347, 264, 245, 206, 176, 442, 449, 450, 455, 465, 469, 478, 488, 487, 426, 412, 401, 398, 397, 382, 338, 339, 354, 332, 272, 263, 260, 251, 245, 236, 216, 205, 189, 188, 176, 170, 32, 3, 449, 450, 455, 465, 466, 467, 478, 479) AND `Article`.`id` != 455 AND `Article`.`model` != 'News' AND `Article`.`archived` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	35	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 (272, 264, 245, 263) ORDER BY `Image`.`order` ASC	4	4	3	maybe slow
  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 (272, 264, 245, 263) 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 (272, 264, 245, 263) 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 (272, 264, 245, 263) 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 (272, 264, 245, 263) AND `ArticlesTopic`.`topic_id` = `Topic`.`id`)	10	10	0
  SELECT `Property`.`id` FROM `leveragere_staging2`.`properties` AS `Property` WHERE `Property`.`archived` = '0' AND `Property`.`incomplete` = '0' ORDER BY `Property`.`created` DESC LIMIT 50	50	50	3	maybe slow
  SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created`, `PrimaryPropertyCategory`.`id`, `PrimaryPropertyCategory`.`name`, `PrimaryPropertyCategory`.`created`, `PrimaryPropertyCategory`.`modified`, `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `StripeSubscription`.`id`, `StripeSubscription`.`brokerage_id`, `StripeSubscription`.`user_id`, `StripeSubscription`.`property_id`, `StripeSubscription`.`type`, `StripeSubscription`.`stripe_id`, `StripeSubscription`.`stripe_customer_id`, `StripeSubscription`.`stripe_checkout_email`, `StripeSubscription`.`stripe_promotion_code`, `StripeSubscription`.`stripe_promotion_code_id`, `StripeSubscription`.`stripe_coupon_code_id`, `StripeSubscription`.`status`, `StripeSubscription`.`current_period_end`, `StripeSubscription`.`cancel_at_period_end`, `StripeSubscription`.`ended`, `StripeSubscription`.`last_change`, `StripeSubscription`.`last_activity_email_sent`, `StripeSubscription`.`created`, `StripeSubscription`.`modified`, `GlobalReachReport`.`id`, `GlobalReachReport`.`property_id`, `GlobalReachReport`.`wsj_desktop`, `GlobalReachReport`.`wsj_mobile`, `GlobalReachReport`.`wsj_expires`, `GlobalReachReport`.`wsj_capture_started`, `GlobalReachReport`.`mg_desktop`, `GlobalReachReport`.`mg_mobile`, `GlobalReachReport`.`mg_expires`, `GlobalReachReport`.`mg_capture_started`, `GlobalReachReport`.`bp_desktop`, `GlobalReachReport`.`bp_mobile`, `GlobalReachReport`.`bp_expires`, `GlobalReachReport`.`gp_capture_started`, `GlobalReachReport`.`mw_desktop`, `GlobalReachReport`.`mw_mobile`, `GlobalReachReport`.`mw_expires`, `GlobalReachReport`.`mw_capture_started`, `GlobalReachReport`.`ft_desktop`, `GlobalReachReport`.`ft_mobile`, `GlobalReachReport`.`ft_expires`, `GlobalReachReport`.`ft_capture_started`, `GlobalReachReport`.`nikkei_desktop`, `GlobalReachReport`.`nikkei_mobile`, `GlobalReachReport`.`nikkei_expires`, `GlobalReachReport`.`nikkei_capture_started`, `GlobalReachReport`.`pgl_desktop`, `GlobalReachReport`.`pgl_mobile`, `GlobalReachReport`.`pgl_expires`, `GlobalReachReport`.`pgl_capture_started`, `GlobalReachReport`.`robb_desktop`, `GlobalReachReport`.`robb_mobile`, `GlobalReachReport`.`robb_expires`, `GlobalReachReport`.`robb_capture_started`, `GlobalReachReport`.`juwai_desktop`, `GlobalReachReport`.`juwai_mobile`, `GlobalReachReport`.`juwai_expires`, `GlobalReachReport`.`juwai_capture_started`, `GlobalReachReport`.`leverage_desktop`, `GlobalReachReport`.`leverage_mobile`, `GlobalReachReport`.`leverage_expires`, `GlobalReachReport`.`leverage_capture_started`, `GlobalReachReport`.`created`, `GlobalReachReport`.`modified` FROM `leveragere_staging2`.`properties` AS `Property` LEFT JOIN `leveragere_staging2`.`property_categories` AS `PrimaryPropertyCategory` ON (`Property`.`primary_property_category_id` = `PrimaryPropertyCategory`.`id`) LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Property`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`stripe_subscriptions` AS `StripeSubscription` ON (`StripeSubscription`.`property_id` = `Property`.`id` AND `StripeSubscription`.`status` = 'active') LEFT JOIN `leveragere_staging2`.`global_reach_reports` AS `GlobalReachReport` ON (`GlobalReachReport`.`property_id` = `Property`.`id`) WHERE `Property`.`id` IN (3762, 3761, 3760, 3759, 3758, 3757, 3756, 3755, 3754, 3753, 3752, 3749, 3747, 3745, 3743, 3742, 3741, 3740, 3739, 3738, 3736, 3734, 3733, 3732, 3731, 3730, 3729, 3728, 3727, 3726, 3724, 3723, 3722, 3721, 3719, 3718, 3717, 3716, 3715, 3714, 3713, 3712, 3711, 3710, 3708, 3707, 3706, 3705, 3704, 3703) AND `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	5	maybe slow
  SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (3749, 3755, 3710, 3721) ORDER BY `Image`.`order` ASC	20	20	1	maybe slow
  SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (3749, 3755, 3710, 3721) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	1	1	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 (3749, 3755, 3710, 3721) 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 (3749, 3755, 3710, 3721) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	1	1	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 (3749, 3755, 3710, 3721) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	2	maybe slow

  6 duplicate queries run.

  Query Explain:

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

  ====
• Timer
  +

  Memory

  Peak Memory Use 10.98 MB

  Message	Memory use
  Component initialization	2.91 MB
  Controller action start	3.84 MB
  Controller render start	6.72 MB
  View render complete	7.33 MB

  Timers

  Total Request Time: 270 (ms)

  Message	Time in ms	Graph
  Core Processing (Derived from $_SERVER["REQUEST_TIME"])	25.83
  Event: Controller.initialize	3.79
  Event: Controller.startup	1.11
  Controller action	101.02
  Event: Controller.beforeRender	5.69
  » Processing toolbar data	5.59
  Rendering View	108.65
  » Event: View.beforeRender	0.27
  » Rendering APP/View/Articles/view.ctp	3.82
  » » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.15
  » » Rendering APP/View/Elements/sidebar/explore.ctp	0.90
  » » » Rendering APP/View/Elements/explore_tile_small.ctp	0.15
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #2	0.13
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #3	0.13
  » » » Rendering APP/View/Elements/explore_tile_small.ctp #4	0.12
  » » Rendering APP/View/Elements/sidebar/article_list.ctp	0.18
  » » Rendering APP/View/Elements/sidebar/property_search.ctp	0.21
  » » Rendering APP/View/Elements/sidebar/property_list.ctp	1.25
  » » » Rendering APP/View/Elements/static_property_price.ctp	0.37
  » » » Rendering APP/View/Elements/static_property_price.ctp #2	0.16
  » » » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
  » » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
  » Event: View.afterRender	0.01
  » Event: View.beforeLayout	0.01
  » Rendering APP/View/Layouts/front.ctp	103.88
  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)
        • id3749
        • brokerage_id70
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameDebordieu Colony.
        • 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-08 16:16:24
        • 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>Welcome To Debordieu Colony...An Exclusive Oceanfront Gated Community Surrounded By Hundreds Of Acres Of Wildlife And Nature Preserves With Private Golf And Tennis Along With An Beachfront Pool And Dining. This Charming Home Is Located On A Corner Lot With A Floating Dock Giving You Direct Boat Access To The Creeks, North Inlet And The Atlantic Ocean Plus Walking Distance To The Beach. A Direct Beach Access Is Located Across The Street From Tabby Lane. With Approx. 4500 Heated Sq Ft, 3 Levels Of Living Space, 8 Bedrooms, 8 Baths, 3 Living Areas, A Huge Kitchen With A Breakfast Bar That Seats 8, Plus A Large Open Dining Area, This Wonderful Family Home Has All The Space You Will Need For Your Entire Family! A Rooftop Deck Gives Way To Incredible Panoramic Views Of The Ocean And Creek. What An Amazing Place To Relax And Watch The Sunrise With A Cup Of Coffee Or Sunset With A Glass Of Wine. The Home Boost Large Double Wrap Around Screened Porches With Access To These Porches From Several Of The Bedrooms And Living Areas. The Ground Floor Has The Foyer Entrance And Parking Underneath The House With Ample Storage Space For Your Beach Toys, Golf Cart, Kayaks, Etc And An Outside Shower. All Levels Are Accessible By An Elevator. The First Floor Has 4 Bedroom/4 Bath And A Living Area. The Main Floor Is An Open Floor Plan With A Large Family Room With Built In Book Cases, A Gas Fireplace, Large Dining Area And Kitchen With A Breakfast Bar That Seats 8. The Kitchen Has A Double Oven, 2 Refrigerators, 2 Pantry Areas, Granite Counter Tops, A Gas Cook Top And Lots And Lots Of Cabinets And Work Space. There Are Also 2 Bedrooms/2 Baths On The Main Level As Well. The Third Floor Has 2 Bedrooms/2 Baths And Living Area. This Is A Great Place For Kids To Have Their Own Space. There Are Stairs To The Roof Top Deck From The Third Level. Beautiful Wood Flooring In All The Living Areas And Kitchen. Debordieu Is Located Just South Of Pawleys Island And About 90 Minutes North Of Charle</p>
        • address84 Tabby Lane
        • address_2
        • cityGeorgetown
        • stateSC
        • postal_code29440
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price1895000
        • 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)
        • bedrooms8
        • bedrooms_20
        • bathrooms8
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet4501
        • 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_built2010
        • virtual_tour
        • video_tour
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num
        • wsj_property_typesingle family
        • nyt_property_type1
        • nyt_popular_features
        • propgolux_property_type9
        • juwai_property_type
        • juwai_category
        • propgolux_property_style21
        • wapo_property_type
        • robb_property_type
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude33.366425
        • longitude-79.153259
        • invalid_required_fields
        • invalid_optional_fields
        • went_live_today(false)
        • converted(false)
        • invalid(false)
        • mlsidx_full_address84 Tabby Lane Georgetown SC
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2018-08-08 16:16:24
        • created2018-07-10 15:50:16
        • uri/property-detail/3749/84-tabby-lane-georgetown-sc-29440-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3749/84-tabby-lane-georgetown-sc-29440-usa
        • address_concat84 Tabby Lane Georgetown SC 29440 USA
        • google_maps_query_string84+Tabby+Lane++Georgetown+SC+29440+USA
        • luxury_ad_enrolled_prettyYES
        • price_prettyUSD 1,895,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty8
        • bathrooms_pretty8
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms8
        • date_listed2018-07-10
        • 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)
          • id22884
          • modelProperty
          • model_id3749
          • tagImage
          • namekitchen-3.jpg
          • typeimage/jpeg
          • size405594
          • uri/assets/22884.jpg
          • order0
          • created2018-07-10 15:51:35
          • modified2018-07-10 15:51:38
      • User(empty)
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(empty)
      • Topic(empty)
    • 1(array)
      • Property(array)
        • id3755
        • brokerage_id244
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameSunset Strip Complex
        • incomplete(false)
        • archived(false)
        • last_archived0000-00-00 00:00:00
        • auto_archived_from_mlsidx(false)
        • paid_featured(false)
        • featured(false)
        • homepage_featured(false)
        • brokerage_page_featured(true)
        • requested_homepage_featured_by_member(false)
        • homepage_featured_by_member(false)
        • dot_luxury_featured(false)
        • luxury_feed_featured(false)
        • force_luxury_feed_featured(false)
        • luxury_autofeed_imported(false)
        • luxury_feed_last_added_time0000-00-00 00:00:00
        • luxury_feed_agent_user_id0
        • luxury_feed_locked_to_subscription_id0
        • luxury_feed_agent_purchase_date0000-00-00
        • luxury_feed_agent_expiration_date0000-00-00
        • digital_ad_summary_email_last_sent0000-00-00 00:00:00
        • digital_ad_summary_price_changed(true)
        • wsj_detail_url
        • ft_detail_url
        • nyt_detail_url
        • juwai_detail_url
        • pgl_detail_url
        • mg_detail_url
        • mg_c_detail_url
        • mg_s_detail_url
        • bp_detail_url
        • mw_detail_url
        • nikkei_detail_url
        • wapo_detail_url
        • robb_detail_url
        • medium_featured(false)
        • large_featured(false)
        • detail_page(false)
        • description<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris ut gravida metus, sit amet ornare nisl. In sed velit magna. Vestibulum convallis, lectus eu luctus aliquam, velit mi suscipit nibh, eget ullamcorper nunc turpis vehicula dolor. Quisque aliquet eros nec nibh accumsan, sed suscipit risus pharetra. Curabitur condimentum porta dolor, eget porta erat placerat id. Curabitur eget mollis leo, et ornare dolor. Mauris eget dui libero. Interdum et malesuada fames ac ante ipsum primis in faucibus. Phasellus consequat diam et magna molestie, at condimentum ipsum consequat.</p>
        • address9255 Swallow Drive
        • address_2
        • cityLos Angeles
        • stateCA
        • postal_code90069
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price12000000
        • price_20
        • price_usd12000000
        • price_usd_20
        • statusFor Sale
        • status_last_changed0000-00-00 00:00:00
        • status_last_changed_price_only0000-00-00 00:00:00
        • lease_period
        • price_upon_request(false)
        • bedrooms0
        • bedrooms_20
        • bathrooms0
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet0
        • square_meters
        • acres0
        • interior_unitsq_ft
        • interior_size0
        • lot_unitacres
        • lot_size0
        • icon_1
        • icon_2
        • icon_3
        • icon_4
        • icon_5
        • icon_6
        • website
        • meta_title
        • meta_description
        • meta_keywords
        • bathrooms_partial0
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built
        • virtual_tour
        • video_tour
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num
        • wsj_property_type
        • nyt_property_type
        • nyt_popular_features
        • propgolux_property_type
        • juwai_property_type
        • juwai_category
        • propgolux_property_style
        • wapo_property_type
        • robb_property_type
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude34.104874
        • longitude-118.389793
        • invalid_required_fields
        • invalid_optional_fields
        • went_live_today(false)
        • converted(false)
        • invalid(false)
        • mlsidx_full_address
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2019-10-31 00:13:54
        • created2019-10-31 00:13:45
        • uri/property-detail/3755/9255-swallow-drive-los-angeles-ca-90069-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3755/9255-swallow-drive-los-angeles-ca-90069-usa
        • address_concat9255 Swallow Drive Los Angeles CA 90069 USA
        • google_maps_query_string9255+Swallow+Drive++Los+Angeles+CA+90069+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 12,000,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty0
        • bathrooms_pretty0
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms0
        • date_listed2019-10-31
        • overridden_brokerage_nameSmith & Berg
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id244
        • account_executive_id0
        • archived(false)
        • typeteam
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typeBasic
        • max_properties10
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties0
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id0
        • WOEID(null)
        • timezoneAmerica/Los_Angeles
        • luxury_feed_enrollment_modemanual
        • luxury_feed_include_mlsidx_minimum_price0
        • luxury_feed_include_leverage_minimum_price0
        • digital_ad_contacts
        • add_agents_to_grr_auto_recipients(true)
        • mlsidx_id
        • mlsidx_lux_autofeed(false)
        • mlsidx_lux_autofeed_minimum_price0
        • mlsidx_logo_url
        • mlsidx_disclaimer
        • nameSmith & Berg
        • broker_of_record_nameCompass
        • short_nameSmith & Berg
        • username
        • password
        • password_reset_hash
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename
        • active(true)
        • lead_inYou've tried the rest, now try the best
        • short_description
        • description<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed et est ut dui hendrerit auctor sit amet ut lorem. Proin eleifend tristique felis. Curabitur bibendum enim mauris, nec volutpat lectus aliquam a. Vestibulum laoreet tellus ac porta consectetur. Quisque quam tellus, tempus vel sollicitudin id, convallis ut erat. Nullam laoreet aliquet sapien non porttitor. Curabitur eu commodo quam, in pellentesque nibh. Etiam non dolor fermentum velit commodo feugiat a ut augue. Sed faucibus tincidunt vestibulum. Pellentesque tincidunt sed lorem at efficitur. Suspendisse maximus arcu eget fermentum pharetra. Praesent dapibus justo sit amet vestibulum molestie.</p> <p>Nullam eu faucibus nisi, sed lacinia eros. Quisque finibus nec ante eu scelerisque. In hac habitasse platea dictumst. Nam turpis augue, ornare sed odio a, placerat vestibulum augue. Curabitur posuere turpis sed nisl tempus, id feugiat ipsum dictum. Praesent venenatis pharetra nunc at tincidunt. Ut sollicitudin quam sit amet tortor molestie, at bibendum diam cursus. Cras ac metus vitae sapien condimentum consequat sit amet eget metus. Vestibulum et venenatis purus. Donec tincidunt pharetra ex quis tempor. Vivamus non sapien eget elit auctor ultrices at eget turpis. Nulla volutpat ut nibh eget placerat.</p>
        • communitiesLos Angeles
        • websitehttps://compass.com
        • address680 E. Colorado Blvd
        • address_2Suite 150
        • cityPasadena
        • stateCA
        • full_stateCalifornia
        • countryUSA
        • market
        • market_2
        • postal_code91101
        • phone8888888888
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameF. Ron Smith
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titlePrincipal
        • contact_dre_num11624555
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone565-135-7745
        • contact_email_2[email protected]
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2878-829-1672
        • contact_website
        • contact_name_2Chris Stephonovich
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2Associate Realtor
        • contact_dre_num_241768321
        • contact_email_3[email protected]
        • contact_name_3Courtney P. Wolpertinger
        • contact_title_3Associate Realtor
        • contact_dre_num_384919983
        • contact_phone_3158-646-8246
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename
        • logo_filename
        • contact_image_filename
        • all_properties_link_image_filename
        • all_properties_link
        • video_embed_code
        • contact_video_embed_code
        • meta_title
        • meta_description
        • meta_keywords
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(false)
        • created2019-10-31 00:07:13
        • modified2021-07-18 10:40:16
        • dre_num012345
        • uri/team-detail/244/smith-berg
        • website_shortcompass.com
        • name_with_locationSmith & Berg
      • StripeSubscription(array)
        • id(null)
        • brokerage_id(null)
        • user_id(null)
        • property_id(null)
        • type(null)
        • stripe_id(null)
        • stripe_customer_id(null)
        • stripe_checkout_email(null)
        • stripe_promotion_code(null)
        • stripe_promotion_code_id(null)
        • stripe_coupon_code_id(null)
        • status(null)
        • current_period_end(null)
        • cancel_at_period_end(null)
        • ended(null)
        • last_change(null)
        • last_activity_email_sent(null)
        • created(null)
        • modified(null)
      • GlobalReachReport(array)
        • id(null)
        • property_id(null)
        • wsj_desktop(null)
        • wsj_mobile(null)
        • wsj_expires(null)
        • wsj_capture_started(null)
        • mg_desktop(null)
        • mg_mobile(null)
        • mg_expires(null)
        • mg_capture_started(null)
        • bp_desktop(null)
        • bp_mobile(null)
        • bp_expires(null)
        • gp_capture_started(null)
        • mw_desktop(null)
        • mw_mobile(null)
        • mw_expires(null)
        • mw_capture_started(null)
        • ft_desktop(null)
        • ft_mobile(null)
        • ft_expires(null)
        • ft_capture_started(null)
        • nikkei_desktop(null)
        • nikkei_mobile(null)
        • nikkei_expires(null)
        • nikkei_capture_started(null)
        • pgl_desktop(null)
        • pgl_mobile(null)
        • pgl_expires(null)
        • pgl_capture_started(null)
        • robb_desktop(null)
        • robb_mobile(null)
        • robb_expires(null)
        • robb_capture_started(null)
        • juwai_desktop(null)
        • juwai_mobile(null)
        • juwai_expires(null)
        • juwai_capture_started(null)
        • leverage_desktop(null)
        • leverage_mobile(null)
        • leverage_expires(null)
        • leverage_capture_started(null)
        • created(null)
        • modified(null)
        • wsj_available(false)
        • wsj_expired(true)
        • wsj_desktop_proxy_screenshot(null)
        • wsj_mobile_proxy_screenshot(null)
        • mg_available(false)
        • mg_expired(true)
        • mg_desktop_proxy_screenshot(null)
        • mg_mobile_proxy_screenshot(null)
        • bp_available(false)
        • bp_expired(true)
        • bp_desktop_proxy_screenshot(null)
        • bp_mobile_proxy_screenshot(null)
        • mw_available(false)
        • mw_expired(true)
        • mw_desktop_proxy_screenshot(null)
        • mw_mobile_proxy_screenshot(null)
        • nikkei_available(false)
        • nikkei_expired(true)
        • nikkei_desktop_proxy_screenshot(null)
        • nikkei_mobile_proxy_screenshot(null)
        • pgl_available(false)
        • pgl_expired(true)
        • pgl_desktop_proxy_screenshot(null)
        • pgl_mobile_proxy_screenshot(null)
        • robb_available(false)
        • robb_expired(true)
        • robb_desktop_proxy_screenshot(null)
        • robb_mobile_proxy_screenshot(null)
        • juwai_available(false)
        • juwai_expired(true)
        • juwai_desktop_proxy_screenshot(null)
        • juwai_mobile_proxy_screenshot(null)
        • capture_processing(false)
        • capture_error(empty)
      • Image(array)
        • 0(array)
          • id23088
          • modelProperty
          • model_id3755
          • tagImage
          • name7ab079e6d3fcc3f540f780f5080587df8beb7d73.jpeg
          • typeimage/jpeg
          • size520160
          • uri/assets/23088.jpeg
          • order0
          • created2019-10-31 00:13:42
          • modified2019-10-31 00:13:45
      • User(empty)
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(empty)
      • Topic(empty)
    • 2(array)
      • Property(array)
        • id3710
        • brokerage_id155
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id981
        • agent_2_id0
        • agent_3_id0
        • name1853 W Grace St - In the Fan!
        • 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(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(true)
        • large_featured(false)
        • detail_page(true)
        • description<p>Welcome to 1853 W Grace Street c. 1910, a Historic National Landmark & Richmond treasure has been lovingly restored with all the grand details preserved. The large center hall welcomes you & highlights the 12' ceilings, plaster moldings, rich detailing and original light fixtures that grace all the formal rooms. The dining room with its original chandelier & curved bay with 3 windows is one of the highlights of the house. A conservatory spilling out to a private walled garden, terrace, and salt water swimming pool make this house ideal for entertaining inside or out! There is a butlers pantry and large kitchen with commercial appliances. Plenty of bedrooms & bathrooms, a large master suite upstairs that has it's own bath, dressing room & a private balcony where you can enjoy the view overlooking the pool and gardens. In the heart of the Fan district and the Historic Grace Street district, this unique home offers hard to find grand scale living with city convenience. There is off street parking for 4 cars and garage offers parking with guest quarters (perfect "nanny" quarters) up. The property has been run as The Grace Manor Inn and can continue to be run as a B&B is desired.</p>
        • address1853 W Grace Street,
        • address_2
        • cityRichmond
        • stateVA
        • postal_code23220
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price1147000
        • price_20
        • price_usd1147000
        • 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)
        • bedrooms10
        • bedrooms_20
        • bathrooms6
        • 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_title1853 W Grace St - In the Fan! | Richmond Real Estate | Small & Associates Real Estate
        • meta_description1853 W Grace Street, is a property offered for sale in Richmond, VA, USA, presented by Small & Associates Real Estate
        • meta_keywords
        • bathrooms_partial0
        • bathrooms_partial_20
        • bathrooms_3_40
        • bathrooms_3_4_20
        • year_built1906
        • virtual_tour
        • video_tour
        • digital_brochure
        • video_tour_embed_code
        • digital_brochure_embed_code
        • mls_num1609528
        • wsj_property_typesingle family
        • nyt_property_type1
        • nyt_popular_features
        • propgolux_property_type9
        • juwai_property_type
        • juwai_category
        • propgolux_property_style48
        • wapo_property_type
        • robb_property_type
        • propgolux_location_id_override
        • open_house_1_start0000-00-00 00:00:00
        • open_house_1_end_time00:00:00
        • latitude37.555672
        • longitude-77.461388
        • invalid_required_fields
        • invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
        • went_live_today(false)
        • converted(true)
        • invalid(false)
        • mlsidx_full_address
        • mlsidx_date_listed0000-00-00
        • mls_market
        • primary_property_category_id0
        • realstaq_initial_image_sync(false)
        • digital_ad_listing_urls_automated(null)
        • modified2016-04-18 05:33:02
        • created2016-04-06 15:04:52
        • uri/property-detail/3710/1853-w-grace-street-richmond-va-23220-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3710/1853-w-grace-street-richmond-va-23220-usa
        • address_concat1853 W Grace Street, Richmond VA 23220 USA
        • google_maps_query_string1853+W+Grace+Street%2C++Richmond+VA+23220+USA
        • luxury_ad_enrolled_prettyYES
        • price_prettyUSD 1,147,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty10
        • bathrooms_pretty6
        • bathrooms_partial_pretty0
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms6
        • date_listed2016-04-06
        • overridden_brokerage_nameSmall & Associates Real Estate
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id155
        • 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_properties1
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id0
        • WOEID2480894
        • 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
        • nameSmall & Associates Real Estate
        • broker_of_record_name
        • short_nameSmall & Associates Real Estate
        • usernameSmallAssociatesRealEstate
        • passwordd16e623ad2ac5d8c1266af342ea6f1394f860fb3
        • 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>Small & Associates Real Estate is the exclusive representative for Leverage Global Partners in Richmond, Chesterfield County, Goochland County, Henrico County, Hanover County, Virginia, USA.</p> <p>When Chris Small named his real estate company Small & Associates, it wasn’t because of his surname. It was also because of his vision – a vision for a close-knit “family” of real estate professionals bonded by a commitment to always making the customer’s needs their first priority. </p> <p>Chris soon found that his “quality over quantity” approach was appreciated not only by the company’s elite clientele, but also by many of the best agents Richmond has to offer. One by one they joined Small & Associates, along the way building an unsurpassed reputation for outstanding real estate services. So the next time you’re buying or selling a home or a property, <em>For Big Result, Think Small.</em></p> <p>When it comes to Richmond real estate, size does matter. At Small & Associates Real Estate, owner and founder Chris Small never desired to create another large, faceless real estate behemoth. Instead he set out to develop a small, tight-knit company that put quality over quantity and took pride in providing an elevated level of personal service to fellow Richmond residents.</p> <p><!--[if gte mso 9]><xml> <o:DocumentProperties> <o:Revision>0</o:Revision> <o:TotalTime>0</o:TotalTime> <o:Pages>1</o:Pages> <o:Words>202</o:Words> <o:Characters>1152</o:Characters> <o:Company>Leverage Global Partners</o:Company> <o:Lines>9</o:Lines> <o:Paragraphs>2</o:Paragraphs> <o:CharactersWithSpaces>1352</o:CharactersWithSpaces> <o:Version>14.0</o:Version> </o:DocumentProperties> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>JA</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:EnableOpenTypeKerning/> <w:DontFlipMirrorIndents/> <w:OverrideTableStyleHps/> <w:UseFELayout/> </w:Compatibility> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="276"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin;} </style> <![endif]--><!--StartFragment--><!--EndFragment--></p> <p>That was in 1982. Today, Small & Associates has earned a sterling reputation throughout the region for living up to Chris’s lofty ideals. The company’s strong local connections and independent ownership provide a superior alternative to the franchises and huge, corporate-owned companies.</p>
        • communitiesRichmond Chesterfield County Goochland County Henrico County Hanover County
        • websitehttp://www.smallrealestate.com/#&panel1-1
        • address5413 Patterson Avenue
        • address_2Suite 200
        • cityRichmond
        • stateVA
        • full_stateVirginia
        • countryUSA
        • market
        • market_2
        • postal_code23226
        • phoneOffice: (804) 343-6860
        • phone_2Mobile: (804) 350-0879
        • phone_3
        • wide_contact_image(false)
        • contact_nameChris Small
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titlePrincipal Broker
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename155.jpg
        • logo_filename155.jpg
        • contact_image_filename155.jpg
        • all_properties_link_image_filename155.jpg
        • all_properties_linkhttp://smallrealestate.com/main/homes?isfeatured=1&isnew
        • video_embed_code
        • contact_video_embed_code
        • meta_titleRichmond Real Estate | Small & Associates Real Estate | Leverage Global Partners
        • meta_descriptionSmall & Associates Real Estate is the exclusive representative for Leverage Global Partners in Richmond, Virginia, USA.
        • meta_keywordsSmall & Associates Real Estate, Richmond Real Estate, Chesterfield County Real Estate, Goochland County Real Estate, Henrico County Real Estate, Real Estate Hanover County
        • 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)
        • created2014-08-26 18:10:55
        • modified2016-04-08 16:34:15
        • dre_num012345
        • uri/brokerage-detail/155/small-associates-real-estate
        • website_shortwww.smallrealestate.com/#&panel1-1
        • name_with_locationSmall & Associates Real Estate
      • StripeSubscription(array)
        • id(null)
        • brokerage_id(null)
        • user_id(null)
        • property_id(null)
        • type(null)
        • stripe_id(null)
        • stripe_customer_id(null)
        • stripe_checkout_email(null)
        • stripe_promotion_code(null)
        • stripe_promotion_code_id(null)
        • stripe_coupon_code_id(null)
        • status(null)
        • current_period_end(null)
        • cancel_at_period_end(null)
        • ended(null)
        • last_change(null)
        • last_activity_email_sent(null)
        • created(null)
        • modified(null)
      • GlobalReachReport(array)
        • id(null)
        • property_id(null)
        • wsj_desktop(null)
        • wsj_mobile(null)
        • wsj_expires(null)
        • wsj_capture_started(null)
        • mg_desktop(null)
        • mg_mobile(null)
        • mg_expires(null)
        • mg_capture_started(null)
        • bp_desktop(null)
        • bp_mobile(null)
        • bp_expires(null)
        • gp_capture_started(null)
        • mw_desktop(null)
        • mw_mobile(null)
        • mw_expires(null)
        • mw_capture_started(null)
        • ft_desktop(null)
        • ft_mobile(null)
        • ft_expires(null)
        • ft_capture_started(null)
        • nikkei_desktop(null)
        • nikkei_mobile(null)
        • nikkei_expires(null)
        • nikkei_capture_started(null)
        • pgl_desktop(null)
        • pgl_mobile(null)
        • pgl_expires(null)
        • pgl_capture_started(null)
        • robb_desktop(null)
        • robb_mobile(null)
        • robb_expires(null)
        • robb_capture_started(null)
        • juwai_desktop(null)
        • juwai_mobile(null)
        • juwai_expires(null)
        • juwai_capture_started(null)
        • leverage_desktop(null)
        • leverage_mobile(null)
        • leverage_expires(null)
        • leverage_capture_started(null)
        • created(null)
        • modified(null)
        • wsj_available(false)
        • wsj_expired(true)
        • wsj_desktop_proxy_screenshot(null)
        • wsj_mobile_proxy_screenshot(null)
        • mg_available(false)
        • mg_expired(true)
        • mg_desktop_proxy_screenshot(null)
        • mg_mobile_proxy_screenshot(null)
        • bp_available(false)
        • bp_expired(true)
        • bp_desktop_proxy_screenshot(null)
        • bp_mobile_proxy_screenshot(null)
        • mw_available(false)
        • mw_expired(true)
        • mw_desktop_proxy_screenshot(null)
        • mw_mobile_proxy_screenshot(null)
        • nikkei_available(false)
        • nikkei_expired(true)
        • nikkei_desktop_proxy_screenshot(null)
        • nikkei_mobile_proxy_screenshot(null)
        • pgl_available(false)
        • pgl_expired(true)
        • pgl_desktop_proxy_screenshot(null)
        • pgl_mobile_proxy_screenshot(null)
        • robb_available(false)
        • robb_expired(true)
        • robb_desktop_proxy_screenshot(null)
        • robb_mobile_proxy_screenshot(null)
        • juwai_available(false)
        • juwai_expired(true)
        • juwai_desktop_proxy_screenshot(null)
        • juwai_mobile_proxy_screenshot(null)
        • capture_processing(false)
        • capture_error(empty)
      • Image(array)
        • 0(array)
          • id12202
          • modelProperty
          • model_id3710
          • tagImage
          • name36016.jpg
          • typeimage/jpg
          • size968952
          • uri/assets/12202.jpg
          • order0
          • created2016-04-07 16:31:06
          • modified2016-04-07 16:31:06
        • 1(array)
          • id12201
          • modelProperty
          • model_id3710
          • tagImage
          • name36023.jpg
          • typeimage/jpg
          • size1021773
          • uri/assets/12201.jpg
          • order1
          • created2016-04-07 16:31:06
          • modified2016-04-07 16:31:06
        • 2(array)
          • id12197
          • modelProperty
          • model_id3710
          • tagImage
          • name36024.jpg
          • typeimage/jpg
          • size1054408
          • uri/assets/12197.jpg
          • order2
          • created2016-04-07 16:31:06
          • modified2016-04-07 16:31:06
        • 3(array)
          • id12203
          • modelProperty
          • model_id3710
          • tagImage
          • name36022.jpg
          • typeimage/jpg
          • size1155112
          • uri/assets/12203.jpg
          • order3
          • created2016-04-07 16:31:06
          • modified2016-04-07 16:31:06
        • 4(array)
          • id12205
          • modelProperty
          • model_id3710
          • tagImage
          • name36015.jpg
          • typeimage/jpg
          • size1085631
          • uri/assets/12205.jpg
          • order4
          • created2016-04-07 16:31:06
          • modified2016-04-07 16:31:06
        • 5(array)
          • id12200
          • modelProperty
          • model_id3710
          • tagImage
          • name36018.jpg
          • typeimage/jpg
          • size1032962
          • uri/assets/12200.jpg
          • order5
          • created2016-04-07 16:31:06
          • modified2016-04-07 16:31:06
        • 6(array)
          • id12199
          • modelProperty
          • model_id3710
          • tagImage
          • name36020.jpg
          • typeimage/jpg
          • size1149075
          • uri/assets/12199.jpg
          • order6
          • created2016-04-07 16:31:06
          • modified2016-04-07 16:31:06
        • 7(array)
          • id12198
          • modelProperty
          • model_id3710
          • tagImage
          • name36021.jpg
          • typeimage/jpg
          • size918078
          • uri/assets/12198.jpg
          • order7
          • created2016-04-07 16:31:06
          • modified2016-04-07 16:31:06
        • 8(array)
          • id12204
          • modelProperty
          • model_id3710
          • tagImage
          • name36014.jpg
          • typeimage/jpg
          • size1060533
          • uri/assets/12204.jpg
          • order8
          • created2016-04-07 16:31:06
          • modified2016-04-07 16:31:06
        • 9(array)
          • id12196
          • modelProperty
          • model_id3710
          • tagImage
          • name36025.jpg
          • typeimage/jpg
          • size898562
          • uri/assets/12196.jpg
          • order9
          • created2016-04-07 16:31:06
          • modified2016-04-07 16:31:06
      • User(empty)
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(empty)
      • Topic(empty)
    • 3(array)
      • Property(array)
        • id3721
        • brokerage_id165
        • created_by_user_id0
        • order0
        • multi_unit(false)
        • agent_1_id0
        • agent_2_id0
        • agent_3_id0
        • nameIconic corner brownstone on uptown Garden Street
        • 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>Iconic corner brownstone on uptown Garden Street with 2+ car parking. A truly exceptional property, 1200 Garden Street offers southern, eastern & western exposures, a contemporary open floor plan, deck & large yard professionally landscaped by Hufnagel. Three beautiful bay windows grace the parlor floor accompanied by a gas fireplace, parquet floors with marquetry inlay border, formal dining room & powder room. The designer kitchen has a Viking 6 burner gas range, Sub Zero refrigerator, Bosch dishwasher and double wall ovens. The second floor offers a master retreat with cathedral ceiling, skylights and sliding glass doors to Juliette balcony. Private en suite bath features marble and limestone tile, dual sink vanity, separate shower & freestanding Bain Ultra air bubble tub. Completing the second floor – an additional bedroom/family room with custom built-in cabinetry and additional full bathroom. The top floor has 2 large, bright bedrooms and a full bath. Other features include a finished basement/playroom, storage, laundry center with laundry chute, gas baseboard heat, 3 zone high velocity heat & central air conditioning, central alarm system, crown moldings, medallions, hardwood floors & custom window shutters.</p>
        • address1200 Garden St.
        • address_2
        • cityHoboken
        • stateNJ
        • postal_code07030
        • countryUSA
        • use_lat_lng_for_google_map(false)
        • currencyUSD
        • price2850000
        • price_20
        • price_usd2850000
        • price_usd_20
        • statusFor Sale
        • status_last_changed0000-00-00 00:00:00
        • status_last_changed_price_only0000-00-00 00:00:00
        • lease_period
        • price_upon_request(false)
        • bedrooms4
        • bedrooms_20
        • bathrooms3
        • bathrooms_20
        • no_beds_baths(false)
        • square_feet0
        • square_meters
        • acres0
        • interior_unitsq_ft
        • interior_size0
        • lot_unitacres
        • lot_size0
        • icon_1
        • icon_2
        • icon_3
        • icon_4
        • icon_5
        • icon_6
        • websitehttp://homes.hudsonplacerealty.com/idx/details/homes/b120/160005043/1200-GARDEN-ST-Hoboken-New-Jersey
        • meta_title
        • meta_description
        • meta_keywords
        • bathrooms_partial2
        • 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.751541
        • longitude-74.028709
        • 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 10:33:01
        • created2016-04-12 10:02:35
        • uri/property-detail/3721/1200-garden-st-hoboken-nj-07030-usa
        • absolute_urihttps://staging2.leveragere.com/property-detail/3721/1200-garden-st-hoboken-nj-07030-usa
        • address_concat1200 Garden St. Hoboken NJ 07030 USA
        • google_maps_query_string1200+Garden+St.++Hoboken+NJ+07030+USA
        • luxury_ad_enrolled_prettyNO
        • price_prettyUSD 2,850,000
        • interior_unit_prettySq. Ft.
        • lot_unit_prettyAcres
        • bedrooms_pretty4
        • bathrooms_pretty3
        • bathrooms_partial_pretty2
        • bathrooms_3_4_pretty0
        • feed_full_bathrooms3
        • date_listed2016-04-12
        • overridden_brokerage_nameHudson Place Realty
        • overridden_brokerage_logo_uri
        • lux_ad_auto_enrolled(false)
      • PrimaryPropertyCategory(array)
        • id(null)
        • name(null)
        • created(null)
        • modified(null)
      • Brokerage(array)
        • id165
        • account_executive_id235
        • archived(false)
        • typebrokerage
        • hide_from_frontend(false)
        • agent_brokerage_data_override(false)
        • featured_development(false)
        • membership_typePremium
        • max_properties8
        • max_homepage_featured_by_member_properties0
        • featured_properties_sort_methodmanual
        • lux_feed_modeStripeSubscription
        • max_luxury_feed_properties0
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id0
        • WOEID2422673
        • 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
        • nameHudson Place Realty
        • broker_of_record_name
        • short_nameHudson Place Realty
        • usernameHudsonPlaceRealty
        • passwordbef5e4553a98ab317b9ec8fad37181955e6d7c1a
        • 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>Hudson Place Realty is the exclusive representative for Leverage Global Partners in Hoboken, Jersey City, Weehawken, Hudson County, New Jersey, USA.</p> <p>A Tradition of Professionalism</p> <p>Established in 1979, Hudson Place Realty has provided intelligent and sophisticated real estate services to buyers and sellers in Hoboken, Jersey City and the extended Hudson County communities.</p> <p>Though initially just a handful of agents, the firm was positioned to be a pivotal contributor to the renaissance of Hoboken. Its mission was clear to help re- energize the community by drawing attention to the opportunities that lay here. As residents ourselves, we saw the potential for a dynamic community carrying on a grand urban tradition. From the beginning, HPR felt that the best way to serve our neighbors was from the community out. Through good times and bad, HPR has been steadfast, continuing to help our clients realize their goals with our extensive knowledge of the market, home-grown business savvy, and the distinctive HPR personal touch that has earned their loyalty and friendship.</p> <p>In those early years, Hudson Place Realty agents became experts in our fields of service, whether residential, commercial, investment or development. Today, we have added the immense power of technology and advanced marketing strategies. We remain a community-based boutique firm and our first priority, now as then, is to build strong relationships with our clients and to continue fostering the neighborhoods we serve.</p> <p>We have recruited over the years a highly selective group of the best agents in the business who every day offer their knowledge and skills to the clients we are privileged to serve. Our office, like the neighborhoods we live in, is comprised of a wide diversity of personalities, talents, and professional training. Collectively, we hold a vast network of resources to benefit our eclectic, urban clientele. Now, as then, we are united in our commitment to one goal: Uncompromising excellence in the service we provide to our clients.</p>
        • communitiesHoboken Jersey City Weehawken Hudson County
        • websitehttp://hudsonplacerealty.com/
        • address132 Washington Street
        • address_2
        • cityHoboken
        • stateNJ
        • full_stateNew Jersey
        • countryUSA
        • market
        • market_2
        • postal_code07030
        • phone(201) 420-7393
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameJon Sisti
        • 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_filename165.jpg
        • logo_filename165.jpg
        • contact_image_filename165.jpg
        • all_properties_link_image_filename165.jpg
        • all_properties_linkhttp://homes.hudsonplacerealty.com/idx/featured
        • video_embed_code
        • contact_video_embed_code
        • meta_titleHoboken Real Estate | Hudson Place Realty | Leverage Global Partners
        • meta_descriptionHudson Place Realty is the exclusive representative for Leverage Global Partners in Hoboken, NJ, USA.
        • meta_keywordsHudson Place Realty, Hoboken Real Estate, Jon Sisti, Jersey City real estate, Weehawken real estate, Hudson County real estate
        • login_message_counter0
        • stats_module_1_type
        • stats_module_1_value
        • stats_module_2_type
        • stats_module_2_value
        • stats_module_3_type
        • stats_module_3_value
        • last_activity_email_sent0000-00-00 00:00:00
        • converted(true)
        • created2014-09-30 14:36:22
        • modified2016-04-08 16:34:15
        • dre_num012345
        • uri/brokerage-detail/165/hudson-place-realty
        • website_shorthudsonplacerealty.com
        • name_with_locationHudson Place 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)
          • id20670
          • modelProperty
          • model_id3721
          • tagImage
          • name_DSC6585.jpg
          • typeimage/jpeg
          • size5140581
          • uri/assets/20670.jpg
          • order0
          • created2016-04-12 10:02:21
          • modified2016-04-12 10:02:35
        • 1(array)
          • id20663
          • modelProperty
          • model_id3721
          • tagImage
          • name_DSC6065.jpg
          • typeimage/jpeg
          • size6451893
          • uri/assets/20663.jpg
          • order1
          • created2016-04-12 09:59:00
          • modified2016-04-12 10:02:35
        • 2(array)
          • id20664
          • modelProperty
          • model_id3721
          • tagImage
          • name_DSC6071.jpg
          • typeimage/jpeg
          • size4847028
          • uri/assets/20664.jpg
          • order2
          • created2016-04-12 09:59:16
          • modified2016-04-12 10:02:35
        • 3(array)
          • id20665
          • modelProperty
          • model_id3721
          • tagImage
          • name_DSC6088.jpg
          • typeimage/jpeg
          • size6703840
          • uri/assets/20665.jpg
          • order3
          • created2016-04-12 09:59:49
          • modified2016-04-12 10:02:35
        • 4(array)
          • id20666
          • modelProperty
          • model_id3721
          • tagImage
          • name_DSC6095.jpg
          • typeimage/jpeg
          • size6828837
          • uri/assets/20666.jpg
          • order4
          • created2016-04-12 09:59:59
          • modified2016-04-12 10:02:35
        • 5(array)
          • id20667
          • modelProperty
          • model_id3721
          • tagImage
          • name_DSC6124.jpg
          • typeimage/jpeg
          • size5918753
          • uri/assets/20667.jpg
          • order5
          • created2016-04-12 10:01:04
          • modified2016-04-12 10:02:35
        • 6(array)
          • id20668
          • modelProperty
          • model_id3721
          • tagImage
          • name_DSC6129.jpg
          • typeimage/jpeg
          • size6880195
          • uri/assets/20668.jpg
          • order6
          • created2016-04-12 10:01:33
          • modified2016-04-12 10:02:35
        • 7(array)
          • id20669
          • modelProperty
          • model_id3721
          • tagImage
          • nameIMG_4560.jpg
          • typeimage/jpeg
          • size6551733
          • uri/assets/20669.jpg
          • order7
          • created2016-04-12 10:02:00
          • modified2016-04-12 10:02:35
      • User(array)
        • 0(array)
          • id1198
          • typeAgent
          • brokerage_id165
          • email[email protected]
          • passwordce7171db7786602ed88319856b5134098996f127
          • recover_hash
          • first_nameIrene
          • last_namePerello
          • title
          • dre_num
          • phone20168161910
          • max_luxury_feed_properties0
          • headshot_filename
          • bio
          • brokerage_name_override
          • stripe_customer_id
          • digital_ad_first_free_month_couponineligible
          • modified2017-08-07 15:23:58
          • created2017-08-07 15:23:58
          • notified(false)
          • full_nameIrene Perello
          • uri/agent-detail/1198/irene-perello
          • profile_complete(true)
          • UsersProperty(array)
            • id1005
            • user_id1198
            • property_id3721
            • sort_order0
      • SecondaryPropertyCategory(empty)
      • PropertyFeature(array)
        • 0(array)
          • id16
          • nameWasher Dryer
          • additional(false)
          • created2016-04-07 14:05:42
          • modified2016-04-07 14:05:42
          • PropertiesPropertyFeature(array)
            • id4370
            • property_id3721
            • property_feature_id16
      • Topic(empty)
  • sidebar_articles(array)
    • 0(array)
      • Article(array)
        • id272
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(false)
        • large_featured(false)
        • titlecul
        • authorLeverageRE
        • date2014-09-15
        • lead_inOne of the best ways to experience the essence of a city and its traditions is to savour and indulge in the unique flavors, ingredients and presentations of its food. We invite you now to send your taste buds on a tour of the most delicious, mouth-watering cuisines found around the world, featured in several of our Leverage Partner cities.
        • body <h1> <strong>Paris, France</strong><br> Home of Emile Garcin Properties</h1> <p><img src="/assets/1073.jpg" class="pure-img"></p> <p>From the traditional (croissants) to the unique (escargot), Paris is renowned for its delicious food. No trip to the city is complete without stopping in a patisserie to grab macaroons and other delectable sweets.</p> <h1> <strong>Sydney, Australia</strong><br> Home of Agency Bowen and Burns & Burns  </h1> <p><img src="/assets/1074.jpg" class="pure-img"></p> <p>Australians do much more than just put a shrimp on the barbie. Meat is a core ingredient in many Australian dishes, and grilling is the traditional way to prepare everything from chops and sausages,  to prawns and scallops.</p> <h1> <strong>Tokyo, Japan</strong><br> Home of Housing Japan</h1> <p><img src="/assets/1075.jpg" class="pure-img"> Many traditional  Japanese dishes are based around rice. Fish, ubiquitous in Tokyo cuisine,  is often grilled, or served raw as sashimi or sushi. Vegetables are commonly deep-fried in a light batter as a tasty tempura.</p> <h1> <strong>Tuscany, Italy</strong><br> Home of Beauchamp Estates</h1> <p><img src="/assets/1076.jpg" class="pure-img"></p> <p>Tuscan cuisine uses fresh ingredients grown in the countryside, with legumes, cheese, vegetables, and fruit as dietary staples. The most prominent cooking additives are wine and olive oil for a rich flavor in pasta and meat dishes.</p> <h1> <strong>Boston, Massachusetts</strong><br> Home of Sprogis & Neale Real Estate</h1> <p><img src="/assets/1077.png" class="pure-img"></p> <p>With a coastal location on the Atlantic Ocean, much of Boston's cuisine revolves around fresh local seafood, including cod, lobster, and clams. Boston clam chowder is arguably the city's culinary claim to fame.</p> <h1> <strong>Mykonos, Greece</strong><br> Home of Beauchamp Estates</h1> <p><img src="/assets/1078.jpg" class="pure-img"></p> <p>On the Greek island of Mykonos, fish has always played an important role in the local cuisine. Fresh salads with tomatoes, cucumbers, feta, onions, and olives are a popular choice, topped off with exquisite views of the Aegean Sea.</p> <h1> <strong>Austin, Texas</strong><br> Home of Turnquist Partners Realtors</h1> <p><img src="/assets/1079.jpg" class="pure-img"></p> <p>The Texas capital is known for great food, including Tex-Mex, a north-of-the border variation of Mexican food that incorporates shredded cheese, beef, black beans, and wheat tortillas.</p> <p>Which one of these cities do you think has the most delicious cuisine? Do you have some favorites to share with us? Please leave your comments in the space below.</p> <p>_____________________________________________</p> <h6><em>Photo Credits: <a href="https://www.flickr.com/photos/marshagladhart/5130891974/" target="_blank">Paris</a>, <a href="http://www.gposydney.com/Sydneys-Best-Steak-Restaurant-and-Steakhouse---Prime-15.html" target="_blank">Sydney</a>, <a href="http://sightseeingpostcards.blogspot.com/2010/07/youve-got-mail.html" target="_blank">Toyko</a>, <a href="http://shop.legalseafoods.com/Lobster-and-Chowder" target="_blank">Boston</a>, <a href="http://www.vencia.gr/mykonos_hotel.php?ID=karavaki_restaurant" target="_blank">Mykonos</a>, <a href="http://austin.eat24hours.com/mexican" target="_blank">Austin</a></em></h6>
        • vimeo_id
        • created2016-02-25 14:11:49
        • modified2016-04-05 14:41:07
        • uri/articles/view/272/cul
        • flattened_topics(array)
          • 0Arts & Culture
          • 1Travel
          • 2Culinary
      • 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)
          • id1080
          • modelArticle
          • model_id272
          • tagImage
          • nameTuscany-Cuisine1.jpg
          • typeimage/jpg
          • size479931
          • uri/assets/1080.jpg
          • order0
          • created2016-02-25 14:11:49
          • modified2016-03-15 16:16:28
      • Brokerage(empty)
      • Location(empty)
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id1
          • nameArts & Culture
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:29:58
          • tile_nameArts & Culture
          • ArticlesTopic(array)
            • id132
            • article_id272
            • topic_id1
        • 1(array)
          • id10
          • nameTravel
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:35:10
          • tile_nameTravel
          • ArticlesTopic(array)
            • id133
            • article_id272
            • topic_id10
        • 2(array)
          • id18
          • nameCulinary
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:31:19
          • tile_nameCulinary
          • ArticlesTopic(array)
            • id134
            • article_id272
            • topic_id18
    • 1(array)
      • Article(array)
        • id264
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(false)
        • large_featured(false)
        • titleTop 10 Ocean View Properties
        • authorLeverageRE
        • date2014-08-05
        • lead_inEnjoy the pure, natural splendor of the ocean by living close to the beach, waking up and going to sleep each evening with the calming sound of the waves as they crash onto the shore. This dream can be yours if you lived here.
        • body <p>Open the door to these spectacular properties with incredible ocean views from some of our Leverage Global Partners:</p> <h1> <strong>1. The Pier House</strong><br> Represented by Partners Trust Real Estate Brokerage & Acquisitions</h1> <p><img src="/assets/1022.jpg" class="pure-img"></p> <p>This spectacular contemporary Malibu home features walls of glass that look out onto the sparkling Pacific Ocean.</p> <h1> <strong>2. Secluded Bayfront Residence</strong><br> Represented by Moorings Realty Inc.</h1> <p><img src="/assets/1023.jpg" class="pure-img"></p> <p>Located in a private enclave of Key Largo, this secluded Florida residence offers gorgeous views of the Keys.</p> <h1> <strong>3. Villa Kismet</strong><br> Represented by Timothy Real Estate Group</h1> <p><img src="/assets/1024.jpg" class="pure-img"></p> <p>Villa Kismet is a spectacular beachfront home with breathtaking views of the Pacific and Zen-like oceanfront gardens.</p> <h1> <strong>4. Puako Oceanfront</strong><br> Represented by Mauna Kea Realty</h1> <p><img src="/assets/1025.jpg" class="pure-img"></p> <p>Situated in idyllic Kamuela, Hawaii, this custom oceanfront home features views of the beautiful Pacific Ocean.</p> <h1> <strong>5. Hawaiian Style Waterfront Home</strong><br> Represented by East Oahu Realty</h1> <p><img src="/assets/1026.jpg" class="pure-img"></p> <p>This Hawaiian style home in Honolulu offers stunning ocean views and your own private beach.</p> <h1> <strong>6. Bandon Ocean View Executive Retreat</strong><br> Represented by Bandon Property</h1> <p><img src="/assets/1027.jpg" class="pure-img"></p> <p>This chic retreat in Bandon, Oregon has a stunning great room with views of the Pacific Ocean and the Offshore Islands Wildlife Refuge.</p> <h1> <strong>7. Historical Beachfront Home</strong><br> Represented by Pam Harrington Exclusives</h1> <p><img src="/assets/1028.jpg" class="pure-img"></p> <p>A fabulous beachfront home in Johns Island offers a private boardwalk to the beach and panoramic ocean views.</p> <h1> <strong>8. Atlântico Estoril Residence Condominium</strong><br> Represented by Porta da Frente</h1> <p><img src="/assets/1029.jpg" class="pure-img"></p> <p>Enjoy resort style living in these ultra luxurious condominiums in Lisbon, Portugal with ocean views from the large verandas and terraces.</p> <h1> <strong>9. Fort Lauderdale Beach</strong><br> Represented by Intercoastal Realty</h1> <p><img src="/assets/1030.jpg" class="pure-img"></p> <p>A luxxe penthouse in Fort Lauderdale has custom high-end features and finishes and offers unobstructed ocean views.</p> <h1> <strong>10. Contemporary Oceanside Retreat</strong><br> Represented by Pack Maynard & Associates</h1> <p><img src="/assets/1031.jpg" class="pure-img"></p> <p>This contemporary oceanside property in Kennebunkport, Maine offers serene 180-degree vistas of the Atlantic Ocean.</p> <p>Do you dream of an ocean view? Please share your thoughts by leaving your comments below.</p>
        • vimeo_id
        • created2016-02-25 14:11:43
        • modified2016-04-05 14:41:07
        • uri/articles/view/264/top-10-ocean-view-properties
        • flattened_topics(array)
          • 0Killer Views
          • 1Beach
      • ParentBrokerage(array)
        • id(null)
        • account_executive_id(null)
        • archived(null)
        • type(null)
        • hide_from_frontend(null)
        • agent_brokerage_data_override(null)
        • featured_development(null)
        • membership_type(null)
        • max_properties(null)
        • max_homepage_featured_by_member_properties(null)
        • featured_properties_sort_method(null)
        • lux_feed_mode(null)
        • max_luxury_feed_properties(null)
        • membership_luxury_feed_properties(null)
        • can_participate_in_lux_feed_while_archived(null)
        • full_training_video_access(null)
        • country_id(null)
        • WOEID(null)
        • timezone(null)
        • luxury_feed_enrollment_mode(null)
        • luxury_feed_include_mlsidx_minimum_price(null)
        • luxury_feed_include_leverage_minimum_price(null)
        • digital_ad_contacts(null)
        • add_agents_to_grr_auto_recipients(null)
        • mlsidx_id(null)
        • mlsidx_lux_autofeed(null)
        • mlsidx_lux_autofeed_minimum_price(null)
        • mlsidx_logo_url(null)
        • mlsidx_disclaimer(null)
        • name(null)
        • broker_of_record_name(null)
        • short_name(null)
        • username(null)
        • password(null)
        • password_reset_hash(null)
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename(null)
        • active(null)
        • lead_in(null)
        • short_description(null)
        • description(null)
        • communities(null)
        • website(null)
        • address(null)
        • address_2(null)
        • city(null)
        • state(null)
        • full_state(null)
        • country(null)
        • market(null)
        • market_2(null)
        • postal_code(null)
        • phone(null)
        • phone_2(null)
        • phone_3(null)
        • wide_contact_image(null)
        • contact_name(null)
        • contact_profile_link(null)
        • contact_big_profile_link(null)
        • contact_big_profile_link_text(null)
        • contact_title(null)
        • contact_dre_num(null)
        • contact_quote(null)
        • contact_email(null)
        • contact_facebook(null)
        • contact_twitter(null)
        • contact_instagram(null)
        • contact_pinterest(null)
        • contact_linkedin(null)
        • contact_youtube(null)
        • contact_phone(null)
        • contact_email_2(null)
        • contact_2_facebook(null)
        • contact_2_twitter(null)
        • contact_2_instagram(null)
        • contact_2_pinterest(null)
        • contact_2_linkedin(null)
        • contact_2_youtube(null)
        • contact_phone_2(null)
        • contact_website(null)
        • contact_name_2(null)
        • contact_profile_link_2(null)
        • contact_big_profile_link_2(null)
        • contact_big_profile_link_text_2(null)
        • contact_title_2(null)
        • contact_dre_num_2(null)
        • contact_email_3(null)
        • contact_name_3(null)
        • contact_title_3(null)
        • contact_dre_num_3(null)
        • contact_phone_3(null)
        • contact_3_facebook(null)
        • contact_3_twitter(null)
        • contact_3_instagram(null)
        • contact_3_pinterest(null)
        • contact_3_linkedin(null)
        • contact_3_youtube(null)
        • image_filename(null)
        • logo_filename(null)
        • contact_image_filename(null)
        • all_properties_link_image_filename(null)
        • all_properties_link(null)
        • video_embed_code(null)
        • contact_video_embed_code(null)
        • meta_title(null)
        • meta_description(null)
        • meta_keywords(null)
        • login_message_counter(null)
        • stats_module_1_type(null)
        • stats_module_1_value(null)
        • stats_module_2_type(null)
        • stats_module_2_value(null)
        • stats_module_3_type(null)
        • stats_module_3_value(null)
        • last_activity_email_sent(null)
        • converted(null)
        • created(null)
        • modified(null)
        • dre_num(null)
        • name_with_location
      • ParentLocation(array)
        • id(null)
        • parent_id(null)
        • brokerage_id(null)
        • type(null)
        • archived(null)
        • use_as_topic(null)
        • name(null)
        • short_name(null)
        • group_index(null)
        • latitude(null)
        • longitude(null)
        • country_code(null)
        • north(null)
        • south(null)
        • east(null)
        • west(null)
        • zoom(null)
        • short_description(null)
        • long_description(null)
        • created(null)
        • modified(null)
        • timezone(null)
        • population(null)
      • Image(array)
        • 0(array)
          • id1032
          • modelArticle
          • model_id264
          • tagImage
          • nameOcean-View-Thumb.jpg
          • typeimage/jpg
          • size347407
          • uri/assets/1032.jpg
          • order0
          • created2016-02-25 14:11:44
          • modified2016-03-15 16:23:51
      • Brokerage(empty)
      • Location(empty)
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id4
          • nameKiller Views
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:33:10
          • tile_nameKiller Views
          • ArticlesTopic(array)
            • id138
            • article_id264
            • topic_id4
        • 1(array)
          • id8
          • nameBeach
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:30:26
          • tile_nameBeach
          • ArticlesTopic(array)
            • id139
            • article_id264
            • topic_id8
    • 2(array)
      • Article(array)
        • id245
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(false)
        • large_featured(false)
        • titleIn Search of... The Most Fabulous Beaches in the World
        • authorLeverageRE
        • date2014-06-17
        • lead_inSummer vacation plans in the works? Dreaming of the soft sand between your toes? For many, there is nothing better than a trip to the beach to find that true feeling of getting away from it all. Here are some of the most fabulous beaches in the world, some better known than others, but all offering the ideal setting for both relaxing, fun-in-the-sun activities and all-out entertaining. Let’s wander the globe to see what stunning spots we find...
        • body <h1><strong>Saint Tropez, France</strong></h1> <p><img src="/assets/870.png" class="pure-img"></p> <p>Tahiti Beach in Saint Tropez, France is one of the area’s most famous private beaches. Situated on the idyllic French Riviera, Tahiti plays host to an elite clientele and offers luxury amenities and the chance to sunbathe without getting tan lines, if you know what we mean.</p> <h1><strong>Algarve, Portugal</strong></h1> <p><img src="/assets/871.jpg" class="pure-img"></p> <p>The Algarve, the southern most region of Portugal, offers spectacular beaches including the world famous Marinha Beach (Praia de Marinha).</p> <h1><strong>Mallorca, Spain</strong></h1> <p><img src="/assets/872.jpg" class="pure-img">Mallorca, Spain is a dream vacation destination with incredible beaches such as the stunning and sandy Cala Agulla, with clear, shallow water and a beautiful backdrop of pine forests.</p> <h1><strong>Puerto Vallarta, Mexico</strong></h1> <p><img src="/assets/873.jpg" class="pure-img"></p> <p>Puerto Vallarta in Mexico is a popular travel destination with over 40 beautiful beaches such as the ominous sounding, yet surprisingly lively Los Muertos Beach and Playa de Oro, known for its great watersports.</p> <h1><strong>San Jose, Costa Rica</strong></h1> <p><img src="/assets/874.jpg" class="pure-img"></p> <p>Though the city is landlocked, there are many beaches in close proximity to San Jose, Costa Rica and well worth the trip, including the aptly named Playa Hermosa, a truly beautiful beach in Guanacaste, providing great vacation amenities, such as snorkeling in the bay.</p> <h1><strong>Cabrera, Dominican Republic</strong></h1> <p><img src="/assets/875.jpg" class="pure-img"></p> <p>Playa Grande is a popular and amazing spot in Cabrera, Dominican Republic, with crystal blue water, fabulous sandy beaches and fine dining options.</p> <h1><strong>The Big Island, Hawaii</strong></h1> <p><img src="/assets/876.jpg" class="pure-img"></p> <p>Vacationers flock to The Big Island of Hawaii, which is known for its gorgeous, pristine beaches. Punalu'u Beach, with its breathtaking jet-black sand, is home to the majestic, endangered green sea turtles.</p> <h1><strong>Rivas, Nicaragua</strong></h1> <p><img src="/assets/877.jpg" class="pure-img"></p> <p>The beaches of Rivas are the most well-known and beloved in Nicaragua, featuring strong waves for incredible surfing.</p> <h1><strong>Mykonos, Greece</strong></h1> <p><img src="/assets/878.jpg" class="pure-img"></p> <p>Mykonos, Greece is a high-end destination with many beautiful beaches offering a variety of vibes including Paradise Beach and Super Paradise Beach, known for their wild parties, and the more secluded and tranquil Agia Anna Beach.</p> <h1><strong>Koh Samet Island, Thailand</strong></h1> <p><img src="/assets/879.jpg" class="pure-img"></p> <p>The most popular island in the Gulf of Thailand, Koh Samet Island is a stunning travel destination with superb beaches including the popular spots Chaweng Beach and Lamai Beach, with white sand, gorgeous views and resort amenities.</p> <p>What is your favorite beach? Which of these dreamy beaches would you most like to visit? Please share your thoughts and leave your comments below.</p> <p><em>Photos courtesy of Leverage Global Partners, Wikipedia, <a href="http://www.visitmexico.com/en/extreme-sports-in-puerto-vallarta" target="_blank" title="Visit Mexico">Visit Mexico</a>,<br><a href="http://www.southerncostarica.biz/" target="_blank">SouthernCostaRica.biz</a>, </em><em><a href="http://www.playagrande.com/#gallery" target="_blank" title="Playa Grande">Playa Grande</a> (DR), <a href="http://www.atripsouth.com/" target="_blank">A Trip South</a> (Nicaragua),  <a href="http://www.kosamui.com/lamai-beach/" target="_blank" title="Ko Samui">Ko Samui</a></em></p>
        • vimeo_id
        • created2016-02-25 14:11:26
        • modified2016-04-05 14:41:07
        • uri/articles/view/245/in-search-of-the-most-fabulous-beaches-in-the-world
        • flattened_topics(array)
          • 0Beach
          • 1Travel
      • ParentBrokerage(array)
        • id(null)
        • account_executive_id(null)
        • archived(null)
        • type(null)
        • hide_from_frontend(null)
        • agent_brokerage_data_override(null)
        • featured_development(null)
        • membership_type(null)
        • max_properties(null)
        • max_homepage_featured_by_member_properties(null)
        • featured_properties_sort_method(null)
        • lux_feed_mode(null)
        • max_luxury_feed_properties(null)
        • membership_luxury_feed_properties(null)
        • can_participate_in_lux_feed_while_archived(null)
        • full_training_video_access(null)
        • country_id(null)
        • WOEID(null)
        • timezone(null)
        • luxury_feed_enrollment_mode(null)
        • luxury_feed_include_mlsidx_minimum_price(null)
        • luxury_feed_include_leverage_minimum_price(null)
        • digital_ad_contacts(null)
        • add_agents_to_grr_auto_recipients(null)
        • mlsidx_id(null)
        • mlsidx_lux_autofeed(null)
        • mlsidx_lux_autofeed_minimum_price(null)
        • mlsidx_logo_url(null)
        • mlsidx_disclaimer(null)
        • name(null)
        • broker_of_record_name(null)
        • short_name(null)
        • username(null)
        • password(null)
        • password_reset_hash(null)
        • monthly_invoice_amount(null)
        • monthly_invoice_start_date(null)
        • monthly_invoice_end_date(null)
        • contract_filename(null)
        • active(null)
        • lead_in(null)
        • short_description(null)
        • description(null)
        • communities(null)
        • website(null)
        • address(null)
        • address_2(null)
        • city(null)
        • state(null)
        • full_state(null)
        • country(null)
        • market(null)
        • market_2(null)
        • postal_code(null)
        • phone(null)
        • phone_2(null)
        • phone_3(null)
        • wide_contact_image(null)
        • contact_name(null)
        • contact_profile_link(null)
        • contact_big_profile_link(null)
        • contact_big_profile_link_text(null)
        • contact_title(null)
        • contact_dre_num(null)
        • contact_quote(null)
        • contact_email(null)
        • contact_facebook(null)
        • contact_twitter(null)
        • contact_instagram(null)
        • contact_pinterest(null)
        • contact_linkedin(null)
        • contact_youtube(null)
        • contact_phone(null)
        • contact_email_2(null)
        • contact_2_facebook(null)
        • contact_2_twitter(null)
        • contact_2_instagram(null)
        • contact_2_pinterest(null)
        • contact_2_linkedin(null)
        • contact_2_youtube(null)
        • contact_phone_2(null)
        • contact_website(null)
        • contact_name_2(null)
        • contact_profile_link_2(null)
        • contact_big_profile_link_2(null)
        • contact_big_profile_link_text_2(null)
        • contact_title_2(null)
        • contact_dre_num_2(null)
        • contact_email_3(null)
        • contact_name_3(null)
        • contact_title_3(null)
        • contact_dre_num_3(null)
        • contact_phone_3(null)
        • contact_3_facebook(null)
        • contact_3_twitter(null)
        • contact_3_instagram(null)
        • contact_3_pinterest(null)
        • contact_3_linkedin(null)
        • contact_3_youtube(null)
        • image_filename(null)
        • logo_filename(null)
        • contact_image_filename(null)
        • all_properties_link_image_filename(null)
        • all_properties_link(null)
        • video_embed_code(null)
        • contact_video_embed_code(null)
        • meta_title(null)
        • meta_description(null)
        • meta_keywords(null)
        • login_message_counter(null)
        • stats_module_1_type(null)
        • stats_module_1_value(null)
        • stats_module_2_type(null)
        • stats_module_2_value(null)
        • stats_module_3_type(null)
        • stats_module_3_value(null)
        • last_activity_email_sent(null)
        • converted(null)
        • created(null)
        • modified(null)
        • dre_num(null)
        • name_with_location
      • ParentLocation(array)
        • id(null)
        • parent_id(null)
        • brokerage_id(null)
        • type(null)
        • archived(null)
        • use_as_topic(null)
        • name(null)
        • short_name(null)
        • group_index(null)
        • latitude(null)
        • longitude(null)
        • country_code(null)
        • north(null)
        • south(null)
        • east(null)
        • west(null)
        • zoom(null)
        • short_description(null)
        • long_description(null)
        • created(null)
        • modified(null)
        • timezone(null)
        • population(null)
      • Image(array)
        • 0(array)
          • id880
          • modelArticle
          • model_id245
          • tagImage
          • nameDR.jpg
          • typeimage/jpg
          • size165929
          • uri/assets/880.jpg
          • order0
          • created2016-02-25 14:11:27
          • modified2016-03-15 16:30:29
      • Brokerage(empty)
      • Location(empty)
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id8
          • nameBeach
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:30:26
          • tile_nameBeach
          • ArticlesTopic(array)
            • id159
            • article_id245
            • topic_id8
        • 1(array)
          • id10
          • nameTravel
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:35:10
          • tile_nameTravel
          • ArticlesTopic(array)
            • id160
            • article_id245
            • topic_id10
    • 3(array)
      • Article(array)
        • id263
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(false)
        • large_featured(false)
        • titleIn Search Of... Fabulous Fine Dining Around the World
        • authorLeverageRE
        • date2014-08-08
        • lead_inEver wonder where the locals go to leisurely wine and dine when you are traveling to a new city? Ready to discover fresh and exciting dining spots in your own town? Take a tour of some of our favorite restaurants around the world, featured in several of our Leverage Partner cities. Bon appetit!
        • body <h2><strong>Steel Bar & Grille | Sydney, Australia</strong></h2> <p><img src="/assets/1007.png" class="pure-img"></p> <p><img src="/assets/1008.jpg" class="pure-img"></p> <p>Located in the heart of Sydney’s bustling central business district, <a href="http://www.steelbarandgrill.com/main/">Steel Bar & Grille</a> is a modern hangout appropriate for high-profile business meetings, relaxing with friends, or anything in between. The restaurant offers a contemporary Australian menu that caters to everything from a light meal with delicate flavors to a dry-aged ribeye on the bone.</p> <h2> <br><strong>Cactus Club Cafe | Vancouver, British Columbia</strong> </h2> <p><img src="/assets/1009.jpg" class="pure-img"></p> <p><img src="/assets/1010.jpg" class="pure-img"></p> <p>The first <a href="http://www.cactusclubcafe.com/">Cactus Club Cafe</a> opened in Vancouver in 1988, and has since grown into 25 restaurants that span both British Columbia and Alberta. Cactus is a beloved favorite among locals, offering a fun, upscale restaurant where you are welcomed with great food and friendly service in a relaxed, unpretentious atmosphere.</p> <h2> <br><strong>Spruce | San Francisco, California</strong> </h2> <p><img src="/assets/1011.jpg" class="pure-img"></p> <p><img src="/assets/1012.jpg" class="pure-img"><a href="http://www.sprucesf.com/">Spruce</a> showcases California-inspired American cuisine highlighted by seasonal produce and naturally raised meats, poultry, and fish. This distinctive restaurant reflects the charm of its Presidio Heights neighborhood surroundings, and provides residents with a welcoming place to dine, socialize and relax.</p> <h2> <br><strong>Topping Rose House | Bridgehampton, New York</strong> </h2> <p><img src="/assets/1013.jpg" class="pure-img"></p> <p><img src="/assets/1014.jpg" class="pure-img">Open daily year-round, <a href="http://www.toppingrosehouse.com/restaurant/">Topping Rose House</a> is a favorite for both visitors and locals in the Hamptons. With its seasonal American cooking and wide wood-plank floors reminiscent of a country barn, this hot spot mixes contemporary and traditional elements creating  an inviting, modern atmosphere in its 50-seat dining room.</p> <h2> <br><strong>Belcanto | Lisbon, Portugal</strong> </h2> <p><img src="/assets/1015.jpg" class="pure-img"><img src="/assets/1016.png" class="pure-img"></p> <p>The <a href="http://belcanto.pt/EN/">Belcanto</a> restaurant originally opened in 1958, and was revived in 2011 when Chef José Avillez began an extensive refurbishment of the kitchens and dining areas. At the revamped Belcanto, one can enjoy new Portuguese cuisine in a sophisticated atmosphere, reminiscent of the historical romance of the city.</p> <h2> <br><strong>Bo London | London, England</strong> </h2> <p><img src="/assets/1017.jpg" class="pure-img"></p> <p><img src="/assets/1018.jpg" class="pure-img"></p> <p><a href="http://bolondonrestaurant.com/">Bo London</a> chef Alvin Leung introduced "X-treme Chinese" to the city, his signature cooking style that combines centuries-old recipes with modern cooking methods. The self-taught chef breaks down perceptions of traditional and regional Chinese food, creating an entirely new dimension for his diners to explore.</p> <h2> <br><strong>CHAR | Shanghai, China</strong> </h2> <p><img src="/assets/1019.png" class="pure-img"></p> <p><img src="/assets/1020.jpg" class="pure-img"></p> <p>Even though <a href="http://www.char-thebund.com/en/default.aspx">CHAR</a> is surrounded by stunning panoramic views of Shanghai, the food holds its own against the glittery backdrop so well you might forget the restaurant has windows at all. The kitchen prides itself on simplicity of flavors and playfulness in presentation, with a menu that is constantly changing according to the season.</p> <p> </p> <p>Have you dined at any of these fabulous restaurants, or do you have a favorite that you would like to add to the list? Please share your thoughts by leaving your comments below.</p> <h6><em>Photos courtesy of <a href="http://www.steelbarandgrill.com/main/" target="_blank">Steel Bar & Grille</a>, <a href="http://www.sprucesf.com/" target="_blank">Spruce</a>, <a href="http://www.cactusclubcafe.com/" target="_blank">Cactus Club Cafe</a>,<br><a href="http://www.toppingrosehouse.com/restaurant/" target="_blank">Topping Rose House</a>, <a href="http://bestemergingchefs.com/2010/03/23/8-jose-avillez-tavares-lisbon-portugal/" target="_blank">Best Emerging Chefs</a>, <a href="http://belcanto.pt/EN/" target="_blank">Belcanto</a>, <a href="http://bolondonrestaurant.com/" target="_blank">Bo London</a>, and <a href="http://www.char-thebund.com/en/default.aspx" target="_blank">CHAR</a>.</em></h6>
        • vimeo_id
        • created2016-02-25 14:11:42
        • modified2016-04-05 14:41:07
        • uri/articles/view/263/in-search-of-fabulous-fine-dining-around-the-world
        • flattened_topics(array)
          • 0Arts & Culture
          • 1Travel
          • 2Culinary
      • 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)
          • id1021
          • modelArticle
          • model_id263
          • tagImage
          • nameRestaurant-Dining-Thumb.jpg
          • typeimage/jpg
          • size177206
          • uri/assets/1021.jpg
          • order0
          • created2016-02-25 14:11:43
          • modified2016-03-15 16:24:13
      • Brokerage(empty)
      • Location(empty)
      • Property(empty)
      • Topic(array)
        • 0(array)
          • id1
          • nameArts & Culture
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:29:58
          • tile_nameArts & Culture
          • ArticlesTopic(array)
            • id140
            • article_id263
            • topic_id1
        • 1(array)
          • id10
          • nameTravel
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:35:10
          • tile_nameTravel
          • ArticlesTopic(array)
            • id141
            • article_id263
            • topic_id10
        • 2(array)
          • id18
          • nameCulinary
          • created2016-02-25 11:25:00
          • modified2016-02-25 11:31:19
          • tile_nameCulinary
          • ArticlesTopic(array)
            • id142
            • article_id263
            • topic_id18
  • sidebar_tiles(array)
    • 0(array)
      • Topic(array)
        • id16
        • nameInterior Design
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:32:53
        • tile_nameInterior Design
      • Image(array)
        • id12
        • modelTopic
        • model_id16
        • tagImage
        • nameInterior Design.jpg
        • typeimage/jpeg
        • size22577089
        • uri/assets/12.jpg
        • order0
        • created2016-02-25 11:32:48
        • modified2016-02-25 11:32:53
      • modelTopic
    • 1(array)
      • Topic(array)
        • id2
        • nameSustainable Living
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:34:20
        • tile_nameSustainable Living
      • Image(array)
        • id18
        • modelTopic
        • model_id2
        • tagImage
        • nameSustainable Living.jpg
        • typeimage/jpeg
        • size26034943
        • uri/assets/18.jpg
        • order0
        • created2016-02-25 11:34:16
        • modified2016-02-25 11:34:20
      • modelTopic
    • 2(array)
      • Location(array)
        • id143
        • parent_id7
        • brokerage_id34
        • typeExclusive
        • archived(false)
        • use_as_topic(true)
        • nameHamptons, NY, USA
        • short_nameHamptons, NY, USA
        • group_index
        • latitude40.924618
        • longitude-72.354790
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_description The Hamptons, the world's playground for the rich and famous.
        • long_descriptionThe absolute bastion of luxury and real estate opulence. The Hamptons has been the home of America's most expensive and resilient real estate since the turn of the 20th Century. Located just 90 miles from the financial center of the world, New York City, the East End is the preferred resort community for businessmen and celebrities alike. A collection of small, unique towns and hamlets, the area is home to world renown restaurants, designer boutiques, unparalleled entertainment and of course the east coast's most beautiful ocean beaches. A true paradise and one of the most sought after real estate markets.
        • created2016-04-07 16:14:57
        • modified2016-04-14 10:51:05
        • timezoneAmerica/New_York
        • population15000
        • uri/locations/view/143/hamptons-ny-usa
        • tile_nameHamptons, NY, USA
      • 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
      • Image(array)
        • id9030
        • modelLocation
        • model_id143
        • tagImage
        • nameHamptons.jpg
        • typeimage/jpeg
        • size240646
        • uri/assets/9030.jpg
        • order0
        • created2016-04-07 16:12:57
        • modified2016-04-14 10:51:05
      • modelLocation
    • 3(array)
      • Topic(array)
        • id20
        • nameUltra Lux
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:35:37
        • tile_nameUltra Lux
      • Image(array)
        • id23
        • modelTopic
        • model_id20
        • tagImage
        • nameUltra Lux.jpg
        • typeimage/jpeg
        • size3943384
        • uri/assets/23.jpg
        • order0
        • created2016-02-25 11:35:34
        • modified2016-02-25 11:35:37
      • modelTopic
  • recent_articles(array)
    • 0(array)
      • Article(array)
        • id486
        • modelArticle
        • model_id0
        • archived(false)
        • medium_featured(true)
        • large_featured(false)
        • titleFashion Trends: Spring 2016
        • authorLeverageRE
        • date2016-04-04
        • lead_inLadies! It's time to do some spring-cleaning to make room for some of this year's most fashionable essentials. So fold up your sweaters and put away your coats. It's time to fill your closet with looks for the most stylish season yet!
        • body<p>Put your own, personal touch on what's happening on the runway. From pleats and ruffles, to playful cuts, dainty laces, sequins and stripes, you, too, can rock the latest crazes with just a few statement pieces. Play a little and mix and match some of your classic pieces with a thing or two of this year's of-the-moment fashion.</p> <p><img class="aligncenter wp-image-12689 pure-img" src="/assets/3342.jpg" /></p> <h3><strong>OFF-THE-SHOULDER</strong></h3> <p>It's all about the shoulders! Seen all over the streets and runways, fashionistas are embracing the vintage vibe of off-the-shoulder silhouettes. Flash just the right amount of skin for a playful, sexy femininity, without being too obvious. Whether it's a top or dress, shoulder cutouts and off-the-shoulder designs make for an effortless and versatile look for any occasion, day or night.</p> <h3><strong>DAYTIME LINGERIE</strong></h3> <p>Lingerie by day is the "it" trend for spring. From lacey slip dresses to camisoles to open-back tops, layering innerwear with outerwear and exposing our undergarments is in. There's a whole lot of skin showing. Pair your sheer silhouette dress with chunky heels, flats or sandals. Contrast the daintiness by adding a vintage T-shirt underneath or throwing on a cardigan to make your look a little more wearable during the day.</p> <p><img class="aligncenter wp-image-12690 pure-img" src="/assets/3343.jpg" /></p> <h3><strong>PLEATS</strong></h3> <p>Pleats on pleats on pleats! Designers have enhanced what used to be a preppy, girlie girl look by adding some structure to sculptured pleats. Add a feminine touch to your wardrobe this season with a pleated dress or skirt. Pair a graphic t-shirt with some sneakers or sandals for a casual day look, or dress it up with a clutch and some heels for a night out on the town.</p> <h3><strong>DENIM</strong></h3> <p>A wardrobe staple, denim is a girl's best friend. For form-flattering shape, comfort and the effortlessness we emanate while wearing it, there's no way to go wrong with denim. Year after year, denim is continuously being reinvented and revived. This year, denim is making a statement! From denim on denim, the jumper, the mini-skirt, patchwork denim and all sorts of different cut jeans, you are sure to work one of these denim trends into your daily style. For a dose of fashion inspiration, check out Harper Bazaar's "<a href="http://www.harpersbazaar.com/fashion/trends/g6994/denim-trends-for-spring/">The 12 Coolest Trends in Denim Now</a>."</p> <p><img class="aligncenter wp-image-12692 pure-img" src="/assets/3344.jpg" /></p> <h3><strong>BUCKET BAGS</strong></h3> <p>No outfit is complete without a fabulous handbag. Spring's go-to carryall adds style and practicality to your daily wear. The "bucket bag" is structured and fashionable, without being over-the-top trendy and obnoxious in size. For a relaxed, casual vibe, go for a bright, beaded version. If you aim for subtlety, try a solid-color leather. With a plethora of different sizes, colors and materials, add the popular bag to your uniform without breaking the bank.</p> <h6><em>J</em><em>Photos courtesy of <a href="http://www.vogue.com/fashion-shows/spring-2016-ready-to-wear/madewell/slideshow/collection" target="_blank">Vogue</a>, <a href="http://www.popsugar.com/fashion/Spring-2016-Trends-Runway-38723166#photo-38727167" target="_blank">Popsugar</a>, <a href="https://www.jcrew.com/womens_feature/NewArrivals/bags.jsp" target="_blank">J.Crew</a></em></h6>
        • vimeo_id
        • created2016-04-05 14:35:20
        • modified2016-04-11 16:58:41
        • uri/articles/view/486/fashion-trends-spring-2016
      • Image(array)
        • 0(array)
          • id3345
          • modelArticle
          • model_id486
          • tagImage
          • nameFashion-blog.jpg
          • typeimage/jpg
          • size668869
          • uri/assets/3345.jpg
          • order0
          • created2016-04-05 14:35:21
          • modified2016-04-11 16:58:41
    • 1(array)
      • Article(array)
        • 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_model_overrideLocation
  • article(array)
    • Article(array)
      • id455
      • modelLocation
      • model_id114
      • archived(false)
      • medium_featured(true)
      • large_featured(true)
      • titleLocation: Hawaii
      • authorLeverageRE
      • date2016-03-23
      • lead_inThe country's youngest state (which joined the Union only in 1959) is something of an anomaly. It's the only one of the United States with a tropical rain forest and a royal palace, but it's also the only state that is made up entirely of islands-eight of them: Niihau, Kauai, Oahu, Maui, Molokai, Lanai, Kahoolawe, and the Big Island.  Leverage Partners Mauna Kea Realty (Big Island), The Wailea Group (Maui), and East Oahu Realty (Oahu) can attest that each island has its own unique characteristics.  But needless to say, wherever you are, you'll find an airy, summertime vibe year-round, with plenty of flower leis, luaus, and beach scenes.
      • body<p>Each of the Hawaiian islands has a distinct cultural relevance.  The Big Island, for instance, which is as big as all the others combined, encompasses about 4,000 square miles.  It's a trove of hidden beaches, volcanic national parks, rain forests, otherworldly waterfalls, and lush vegetation.</p> <p><img class="aligncenter wp-image-12718 pure-img" src="/assets/3150.png" /></p> <p>On Oahu, you'll find markers of both American history-Pearl Harbor, the USS Arizona Memorial-and Hawaiian history-the Iolani Palace and the Byodo-In Temple. It's also the location of the capital city, Honolulu, which is the biggest city in Hawaii. The island of Maui boasts pristine beaches and shimmering shores, but it also is home to the Road to Hana, one of the most traveled trails in the state.</p> <p>Here, we explore destinations on the three islands in greater depth and share all the places to get out and enjoy before you say, "Aloha."</p> <p>Located on Waikiki Beach, <strong><a href="http://www.halekulani.com/" target="_blank">Halekulani</a></strong> welcomes travelers to an oasis of sophisticated luxury, and is recognized as one of the world's finest and most acclaimed independent luxury hotels since its inception in 1984.</p> <p><img class="aligncenter size-full wp-image-12711 pure-img" src="/assets/3151.png" /></p> <p>Chef Peter Merriman had a vision for the growth of local agriculture and the potential of Hawaii's rich volcanic soils. He, along with twelve other prominent chefs, encouraged farmers to grow local fruits and vegetables, raise meats locally, and start a healthier more sustainable Hawaii. Showcasing locally sourced menus of fresh line caught fish, grass fed meats, and Hawaii grown produce, the authentic flavors of Hawaii await at <strong><a href="https://www.merrimanshawaii.com/fish-house/" target="_blank">Merriman's</a></strong>.</p> <p><img class="aligncenter wp-image-12710 pure-img" src="/assets/3152.png" /></p> <h3><strong>ZIPLINE AT UMAUMA FALLS</strong></h3> <p>Catch the view from the top on this outdoor adventure, which boasts two miles of ziplines and family-friendly fun.</p> <p><img class="aligncenter wp-image-12709 pure-img" src="/assets/3153.png" /></p> <h3><strong>DOLPHIN SNORKEL SWIM, KAILUA-KONA</strong></h3> <p>Swim with the dolphins in Hawaii's crystal-clear waters. The same company also offers whale watching.</p> <p><img class="aligncenter wp-image-12712 pure-img" src="/assets/3154.png" /></p> <h3><strong>WAIPIO VALLEY</strong></h3> <p>The waterfalls in Waipio Valley, on the Big Island, are some of the most exquisite in the state. For a rustic adventure, see them from horseback.</p> <p><img class="aligncenter wp-image-12719 pure-img" src="/assets/3155.png" /></p> <h3><strong>DIAMOND HEAD</strong></h3> <p>This crater was created by a giant eruption 300,000 years ago. Today, it's a landmark on Oahu, and a hiking trail (0.8 mile) winds through it.</p> <p><img class="aligncenter wp-image-12716 pure-img" src="/assets/3156.png" /></p> <h3><strong>HANAUMA</strong> <strong>BAY</strong></h3> <p>When you imagine waters so blue that they'd be perfect for a postcard, this is the image that comes to mind. Sign up to snorkel to see angelfish, butterflyfish, and yellow tangs galore.</p> <p><img class="aligncenter wp-image-12714 pure-img" src="/assets/3157.png" /></p> <h3><strong>THE HIGHWAY HANA</strong></h3> <p>Wind through approximately 600 curves on this Maui road to see the lush green countryside.</p> <p><img class="aligncenter wp-image-12708 pure-img" src="/assets/3158.png" /></p> <h3><strong>SNORKELING AT MOLOKINI</strong></h3> <p>Swim with the turtles and fish at this Maui gem. For those who like to stay a bit drier, the yacht that takes you out is the perfect place to get a tan.</p> <p><img class="aligncenter wp-image-12715 pure-img" src="/assets/3159.png" /></p>
      • vimeo_id
      • created2016-04-05 14:30:50
      • modified2016-04-08 09:46:02
      • uri/articles/view/455/location-hawaii
      • flattened_topics(array)
        • 0Beach
        • 1Travel
    • ParentBrokerage(array)
      • id(null)
      • account_executive_id(null)
      • archived(null)
      • type(null)
      • hide_from_frontend(null)
      • agent_brokerage_data_override(null)
      • featured_development(null)
      • membership_type(null)
      • max_properties(null)
      • max_homepage_featured_by_member_properties(null)
      • featured_properties_sort_method(null)
      • lux_feed_mode(null)
      • max_luxury_feed_properties(null)
      • membership_luxury_feed_properties(null)
      • can_participate_in_lux_feed_while_archived(null)
      • full_training_video_access(null)
      • country_id(null)
      • WOEID(null)
      • timezone(null)
      • luxury_feed_enrollment_mode(null)
      • luxury_feed_include_mlsidx_minimum_price(null)
      • luxury_feed_include_leverage_minimum_price(null)
      • digital_ad_contacts(null)
      • add_agents_to_grr_auto_recipients(null)
      • mlsidx_id(null)
      • mlsidx_lux_autofeed(null)
      • mlsidx_lux_autofeed_minimum_price(null)
      • mlsidx_logo_url(null)
      • mlsidx_disclaimer(null)
      • name(null)
      • broker_of_record_name(null)
      • short_name(null)
      • username(null)
      • password(null)
      • password_reset_hash(null)
      • monthly_invoice_amount(null)
      • monthly_invoice_start_date(null)
      • monthly_invoice_end_date(null)
      • contract_filename(null)
      • active(null)
      • lead_in(null)
      • short_description(null)
      • description(null)
      • communities(null)
      • website(null)
      • address(null)
      • address_2(null)
      • city(null)
      • state(null)
      • full_state(null)
      • country(null)
      • market(null)
      • market_2(null)
      • postal_code(null)
      • phone(null)
      • phone_2(null)
      • phone_3(null)
      • wide_contact_image(null)
      • contact_name(null)
      • contact_profile_link(null)
      • contact_big_profile_link(null)
      • contact_big_profile_link_text(null)
      • contact_title(null)
      • contact_dre_num(null)
      • contact_quote(null)
      • contact_email(null)
      • contact_facebook(null)
      • contact_twitter(null)
      • contact_instagram(null)
      • contact_pinterest(null)
      • contact_linkedin(null)
      • contact_youtube(null)
      • contact_phone(null)
      • contact_email_2(null)
      • contact_2_facebook(null)
      • contact_2_twitter(null)
      • contact_2_instagram(null)
      • contact_2_pinterest(null)
      • contact_2_linkedin(null)
      • contact_2_youtube(null)
      • contact_phone_2(null)
      • contact_website(null)
      • contact_name_2(null)
      • contact_profile_link_2(null)
      • contact_big_profile_link_2(null)
      • contact_big_profile_link_text_2(null)
      • contact_title_2(null)
      • contact_dre_num_2(null)
      • contact_email_3(null)
      • contact_name_3(null)
      • contact_title_3(null)
      • contact_dre_num_3(null)
      • contact_phone_3(null)
      • contact_3_facebook(null)
      • contact_3_twitter(null)
      • contact_3_instagram(null)
      • contact_3_pinterest(null)
      • contact_3_linkedin(null)
      • contact_3_youtube(null)
      • image_filename(null)
      • logo_filename(null)
      • contact_image_filename(null)
      • all_properties_link_image_filename(null)
      • all_properties_link(null)
      • video_embed_code(null)
      • contact_video_embed_code(null)
      • meta_title(null)
      • meta_description(null)
      • meta_keywords(null)
      • login_message_counter(null)
      • stats_module_1_type(null)
      • stats_module_1_value(null)
      • stats_module_2_type(null)
      • stats_module_2_value(null)
      • stats_module_3_type(null)
      • stats_module_3_value(null)
      • last_activity_email_sent(null)
      • converted(null)
      • created(null)
      • modified(null)
      • dre_num(null)
      • name_with_location
    • ParentLocation(array)
      • id114
      • parent_id9
      • brokerage_id48
      • typeExclusive
      • archived(false)
      • use_as_topic(false)
      • nameBIG ISLAND OF HAWAII, HI, USA
      • short_nameBIG ISLAND OF HAWAII, HI, USA
      • group_index
      • latitude37.090240
      • longitude-95.712891
      • country_code
      • north53.700001
      • south19.700001
      • east-52.599998
      • west-146.600006
      • zoom0
      • short_descriptionThe Kona-Kohala Coast is a contrast between the old and the new offering unspoiled natural beauty, a pristine environment together with world class properties and amenities.
      • long_descriptionThe Kona-Kohala Coast of the Big Island of Hawaii is synonymous with world class resort/residential living. Home to some of Hawaii's finest golf courses, white sand beaches, restaurants and hotels, the Kona-Kohala Coast is within close proximity to ancient valleys, waterfalls, historically significant Heiaus and two of the tallest mountains in the world; Mauna Kea and Mauna Loa. Renown for its spectacular year round climate, the Big Island has attracted some of the titans of business, technology, medicine, entertainment, science and education who call the Kona-Kohala Coast their home away from home. Once the playground of Hawaiian royalty, the Big Island remains relatively untouched and offers a lifestyle found no where else in the world.
      • created2016-04-05 17:01:23
      • modified2016-04-05 17:01:23
      • timezonePacific/Honolulu
      • population65000
      • uri/locations/view/114/big-island-of-hawaii-hi-usa
      • tile_nameBIG ISLAND OF HAWAII, HI, USA
    • Image(array)
      • 0(array)
        • id3160
        • modelArticle
        • model_id455
        • tagImage
        • nameScreen-Shot-2016-03-23-at-3.51.26-PM.png
        • typeimage/png
        • size2749979
        • uri/assets/3160.png
        • order0
        • created2016-04-05 14:30:54
        • modified2016-04-08 09:46:03
    • Brokerage(array)
      • 0(array)
        • id28
        • 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
        • WOEID12485533
        • timezoneUS/Hawaii
        • 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
        • nameEast Oahu Realty, RB-16090
        • broker_of_record_name
        • short_nameEast Oahu Realty
        • usernameEastOahu
        • password184254dea91b6c8586489ec50b8219bece099e54
        • 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>East Oahu Realty is the exclusive representative for Leverage Global Partners in Honolulu, Oahu, Hawaii, USA.</p> <p>In 1992, Jack Leslein, President & Founder of East Oahu Realty, Inc., ventured forward with his dream of creating a real estate company of Realtors that would make a difference. Our mission is to be a pacesetter in real estate services by sharing our knowledge and skillfully guiding our clients beyond their expectations.</p> <p>Specializing in helping clients achieve their real estate objectives and focusing on personalized service and attention, East Oahu Realty became the home of trained and experienced Realtors, state of the art technology and dedicated support staff. East Oahu Realty is able to provide the utmost in professional real estate service.</p> <p>As a locally owned, Kama’aina company, we respect and value our island heritage. We are committed to enhancing the lives of those who reside here by providing the utmost in service and community support. We know our market as well as the economic and social factors that shape it. Our knowledge, combined with our broad base of experience, assures you have the information you need to make an informed decision.</p> <p>We are committed to your success, and we are leaders in our industry and our community. We take an active role in shaping the future of both. We are committed to maintaining our reputation of integrity and honesty.</p> <p>We represent our clients enthusiastically and fairly and have done so since 1992. Choosing can make all the difference.</p> <p>What Our Clients Can Expect:</p> <ul> <li>Premier Market Presence</li> <li>Select Team of Successful Real Estate Professionals</li> <li>Global Networking and Exposure</li> <li>Comprehensive Market Analysis & Plans</li> <li>Member of Luxury Real Estate</li> <li>State of the Art Technology</li> <li>Multi-Lingual Realtors</li> <li>Mortgage Services On-Site</li> </ul>
        • communitiesHonolulu Hawaii HI USA Oahu Hawaii HI USA
        • websitehttp://www.eastoahu.com/
        • address6600 Kalanianaole Hwy # 114
        • address_2
        • cityHonolulu, Oahu
        • stateHI
        • full_stateHawaii
        • countryUSA
        • market
        • market_2
        • postal_code96825
        • phone(808) 791-2216
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameCherie Tsukamoto
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titlePrincipal Broker, RB - 14911
        • contact_dre_num
        • contact_quoteI invite you to contact me personally regarding East Oahu Realty.
        • 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_filename28.jpg
        • logo_filename28.jpg
        • contact_image_filename28.jpg
        • all_properties_link_image_filename28.jpg
        • all_properties_linkhttp://www.eastoahu.com/search/FeaturedListings.aspx
        • video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/4U1wTm0Z-qzxAOUo0.js"></script>
        • contact_video_embed_code
        • meta_titleHonolulu, Oahu Real Estate | East Oahu Realty | Leverage Global Partners
        • meta_descriptionEast Oahu Realty is the exclusive representative for Leverage Global Partners in Oahu, Hawaii, USA.
        • meta_keywordseast oahu realty, oahu real estate, honolulu real estate, oahu hawaii, jack leslein, 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-05-10 18:19:12
        • modified2016-04-08 16:33:22
        • dre_num012345
        • uri/brokerage-detail/28/east-oahu-realty-rb-16090
        • website_shortwww.eastoahu.com
        • name_with_locationEast Oahu Realty, RB-16090
        • ArticlesBrokerage(array)
          • id23
          • article_id455
          • brokerage_id28
      • 1(array)
        • id48
        • 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
        • WOEID2513177
        • timezoneUS/Hawaii
        • 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
        • nameMauna Kea Realty
        • broker_of_record_name
        • short_nameMauna Kea Realty
        • usernameMaunaKea
        • passwordce54200a54501e1e806c9faa3211e9ae1705158c
        • 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>Mauna Kea Realty is the exclusive representative for Leverage Global Partners in the County of Hawaii, Hawaii, USA.</p> <p>Aloha from Mauna Kea Realty, the exclusive real estate brokerage company at the legendary Mauna Kea Resort.</p> <p>In addition to serving the needs of the property owners at Mauna Kea Resort, we also provide insight and services for the surrounding areas and resorts on the Kona-Kohala Coast. These include Kukio, Hualalai, Mauna Lani, Waikoloa, Puako, Kohala Waterfront, Kohala Ranch, Waimea and North Kohala.</p> <p>The principals of Mauna Kea Realty started their real estate careers over 30 years ago, when the Kona Village Resort and the Mauna Kea Beach Hotel were the only lodging north of Kailua-Kona.</p> <p>We have been part of the evolution of what has become one of the premier real estate markets in the world. We have participated in numerous transactions in all of the resorts and communities along the coast. We have a long-term perspective and the local knowledge that allows us to effectively serve the needs of our clients and customers.</p> <p>Mauna Kea Realty has assembled a select group of highly talented professionals who service all sectors of the real estate market, including oceanfront, resort, ranch, single family, condominium and vacant land properties. Our combined $2+ billion in sales on the island, years of experience and market knowledge are some of the factors that separate Mauna Kea Realty from other real estate companies on the Big Island.</p> <p>Please allow us the opportunity to demonstrate to you our professional commitment to finding the right place, at the right price for you and your family.</p> <p>Mahalo,</p> <p>Bob Chancer & Steve Hurwitz</p>
        • communitieskona kohala hamakua Huala
        • websitehttp://www.maunakearealty.com/
        • address62-100 Mauna Kea Beach Drive
        • address_2
        • cityKohala Coast
        • stateHI
        • full_stateHawaii
        • countryUSA
        • marketBig Island of Hawaii
        • market_2
        • postal_code96743
        • phone(808) 882-5600
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameSteve Hurwitz
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titlePresident
        • contact_dre_num
        • contact_quoteI invite you to contact me personally about Hawaii’s Big Island 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_filename48.jpg
        • logo_filename48.jpg
        • contact_image_filename48.jpg
        • all_properties_link_image_filename48.jpg
        • all_properties_linkhttp://maunakearealty.idxbroker.com/idx/featured
        • video_embed_code
        • contact_video_embed_code
        • meta_titleBig Island of Hawaii Real Estate | Mauna Kea Realty | Leverage Global Partners
        • meta_descriptionMauna Kea Realty is the exclusive representative for Leverage Global Partners on the Island of Hawaii, HI, USA.
        • meta_keywordsMauna Kea Realty, hawaii real estate, Bob Chancer, leverage global partners, Steve Hurwitz
        • 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-09-13 16:06:14
        • modified2016-04-08 16:33:30
        • dre_num012345
        • uri/brokerage-detail/48/mauna-kea-realty
        • website_shortwww.maunakearealty.com
        • name_with_locationMauna Kea Realty
        • ArticlesBrokerage(array)
          • id24
          • article_id455
          • brokerage_id48
      • 2(array)
        • id62
        • 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_properties-1
        • membership_luxury_feed_properties0
        • can_participate_in_lux_feed_while_archived(false)
        • full_training_video_access(false)
        • country_id1
        • WOEID12588033
        • timezoneUS/Hawaii
        • 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
        • nameThe Wailea Group
        • broker_of_record_name
        • short_nameThe Wailea Group
        • usernameWaileaGroup
        • password96cbf310f1191af607d1a68cb3d3240778537715
        • 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>The Wailea Group is the exclusive representative for Leverage Global Partners in Maui, Lanai, and Moloka'i, Hawaii, USA.</p> <p>The Wailea Group is a collaboration of sales and marketing professionals with deep respect for Wailea-Makena’s past, present and future. Wailea-Makena will continue to grow, this is a certainty. But equally certain is the control of that growth ensuring an unparalleled quality of life on Maui. We have already exclusively represented new development projects valued at over $2 billion, a tribute to the vision and integrity of our founders and our unique marketing insights and strategies. Wailea Beach Villas, Ho’olei and Papali were all represented by us and we’re now exclusively representing the Andaz. Our inventory of existing homes and condos and our knowledge of future development make us not only the logical choice among buyers and sellers but also the smart choice.</p> <p><a href="http://www.leveragere.com/project-detail/24/Makali'i-at-Wailea,-Maui,-Hawaii" target="_blank">Visit Makali’i at Wailea</a></p>
        • communitiesMaui Lanai Moloka'i
        • websitehttp://www.thewaileagroup.com/HomeMain.aspx
        • address3750 Wailea Alanui
        • address_2Suite 5EW
        • cityWailea
        • stateHI
        • full_stateHawaii
        • countryUSA
        • marketMaui
        • market_2
        • postal_code96753
        • phoneMain: (808) 875-6911
        • phone_2
        • phone_3
        • wide_contact_image(false)
        • contact_nameScott Nelson
        • contact_profile_link
        • contact_big_profile_link
        • contact_big_profile_link_text
        • contact_titlePrincipal Broker
        • contact_dre_num
        • contact_quote
        • contact_email[email protected]
        • contact_facebook
        • contact_twitter
        • contact_instagram
        • contact_pinterest
        • contact_linkedin
        • contact_youtube
        • contact_phone
        • contact_email_2
        • contact_2_facebook
        • contact_2_twitter
        • contact_2_instagram
        • contact_2_pinterest
        • contact_2_linkedin
        • contact_2_youtube
        • contact_phone_2
        • contact_website
        • contact_name_2
        • contact_profile_link_2
        • contact_big_profile_link_2
        • contact_big_profile_link_text_2
        • contact_title_2
        • contact_dre_num_2
        • contact_email_3
        • contact_name_3
        • contact_title_3
        • contact_dre_num_3
        • contact_phone_3
        • contact_3_facebook
        • contact_3_twitter
        • contact_3_instagram
        • contact_3_pinterest
        • contact_3_linkedin
        • contact_3_youtube
        • image_filename62.jpg
        • logo_filename62.gif
        • contact_image_filename62.jpg
        • all_properties_link_image_filename62.jpg
        • all_properties_linkhttp://www.thewaileagroup.com/Exclusive.aspx
        • video_embed_code
        • contact_video_embed_code
        • meta_titleMaui Real Estate | The Wailea Group | Leverage Global Partners
        • meta_descriptionThe Wailea Group is the exclusive representative for Leverage Global Partners in Maui, HI, USA.
        • meta_keywordsThe Wailea Group, maui real estate, hawaii real estate, rene sand, 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-10-09 12:08:12
        • modified2016-04-08 16:33:30
        • dre_num012345
        • uri/brokerage-detail/62/the-wailea-group
        • website_shortwww.thewaileagroup.com/HomeMain.aspx
        • name_with_locationThe Wailea Group
        • ArticlesBrokerage(array)
          • id25
          • article_id455
          • brokerage_id62
    • Location(array)
      • 0(array)
        • id32
        • parent_id9
        • brokerage_id28
        • typeExclusive
        • archived(false)
        • use_as_topic(false)
        • nameHonolulu, Oahu, HI, USA
        • short_nameHonolulu, Oahu, HI, USA
        • group_index
        • latitude21.296232
        • longitude-157.701981
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_descriptionHonolulu, Oahu: Paradise has been found and it's calling your name!
        • long_descriptionWhether you’re a sun-seeker, metropolitan maven, or adventure addict, Honolulu is the place to be! Located on beautiful Oahu, also known as the “The Gathering Place”, Hawaii’s most populous city is an alluring melting pot of cultures and cuisines. The relaxed lifestyle and ‘Aloha’ spirit will keep your mind at ease while our stunning mountains and pristine beaches keep you young and active. From famous historical sites to secluded natural treasures, residents here enjoy a boundless supply of scenic beauty and rejuvenating adventure. Also boasting world-class shopping, commerce and entertainment, you are sure to find your place in the sun!
        • created2016-04-04 12:01:25
        • modified2016-04-04 12:03:35
        • timezonePacific/Honolulu
        • population953000
        • uri/locations/view/32/honolulu-oahu-hi-usa
        • tile_nameHonolulu, Oahu, HI, USA
        • ArticlesLocation(array)
          • id18
          • article_id455
          • location_id32
      • 1(array)
        • id92
        • parent_id9
        • brokerage_id62
        • typeExclusive
        • archived(false)
        • use_as_topic(false)
        • nameMaui, HI, USA
        • short_nameMaui, HI, USA
        • group_index
        • latitude20.798363
        • longitude-156.331924
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_description
        • long_descriptionMore information coming soon!
        • created2016-04-05 11:22:53
        • modified2016-04-05 11:22:53
        • timezonePacific/Honolulu
        • population145000
        • uri/locations/view/92/maui-hi-usa
        • tile_nameMaui, HI, USA
        • ArticlesLocation(array)
          • id19
          • article_id455
          • location_id92
      • 2(array)
        • id114
        • parent_id9
        • brokerage_id48
        • typeExclusive
        • archived(false)
        • use_as_topic(false)
        • nameBIG ISLAND OF HAWAII, HI, USA
        • short_nameBIG ISLAND OF HAWAII, HI, USA
        • group_index
        • latitude37.090240
        • longitude-95.712891
        • country_code
        • north53.700001
        • south19.700001
        • east-52.599998
        • west-146.600006
        • zoom0
        • short_descriptionThe Kona-Kohala Coast is a contrast between the old and the new offering unspoiled natural beauty, a pristine environment together with world class properties and amenities.
        • long_descriptionThe Kona-Kohala Coast of the Big Island of Hawaii is synonymous with world class resort/residential living. Home to some of Hawaii's finest golf courses, white sand beaches, restaurants and hotels, the Kona-Kohala Coast is within close proximity to ancient valleys, waterfalls, historically significant Heiaus and two of the tallest mountains in the world; Mauna Kea and Mauna Loa. Renown for its spectacular year round climate, the Big Island has attracted some of the titans of business, technology, medicine, entertainment, science and education who call the Kona-Kohala Coast their home away from home. Once the playground of Hawaiian royalty, the Big Island remains relatively untouched and offers a lifestyle found no where else in the world.
        • created2016-04-05 17:01:23
        • modified2016-04-05 17:01:23
        • timezonePacific/Honolulu
        • population65000
        • uri/locations/view/114/big-island-of-hawaii-hi-usa
        • tile_nameBIG ISLAND OF HAWAII, HI, USA
        • ArticlesLocation(array)
          • id20
          • article_id455
          • location_id114
    • Property(empty)
    • Topic(array)
      • 0(array)
        • id8
        • nameBeach
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:30:26
        • tile_nameBeach
        • ArticlesTopic(array)
          • id270
          • article_id455
          • topic_id8
      • 1(array)
        • id10
        • nameTravel
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:35:10
        • tile_nameTravel
        • ArticlesTopic(array)
          • id271
          • article_id455
          • topic_id10
  • 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/455/location-hawaii
  Query String
  Request Method	GET
  Server Protocol	HTTP/1.1
  Gateway Interface	CGI/1.1
  Redirect Url	/articles/view/455/location-hawaii
  Remote Port	15846
  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 User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
  Http Accept Encoding	gzip, br
  Http Accept	*/*
  Http Cf Ray	a09d83596eced287-CMH
  Http X Forwarded For	216.73.216.172
  Proxy-nokeepalive	1
  Ssl Tls Sni	staging2.leveragere.com
  Https	on
  Passenger Download Native Support Binary	0
  Passenger Compile Native Support Binary	0
  Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
  Unique Id	aioq1vK8CRJnCvkkTtrp7AAAAMg
  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	aioq1vK8CRJnCvkkTtrp7AAAAMg
  Fcgi Role	RESPONDER
  Php Self	/index.php
  Request Time Float	1781148374.0805
  Request Time	1781148374

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

  ====