Executive Real Estate / Amy Rio

Amy Rio

Brokerage:

www.executiverealestatellc.com | Cell: (860) 916-6048

Main Office
17 School Street
Glastonbury, CT 06033
USA

Amy Rio's Featured Properties

More Properties from Executive Real Estate

Recent Articles

Location: Hawaii

The country's youngest state (which joined the...

Location: Maui

Remarkable beaches, magnificent waterfalls and...

Celebrity Spotlight: Madison Hildebrand

Though reality television enthusiasts are...

Shop The Store: Saint-Louis

Saint-Louis, the famed French crystal company...

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

History
+
Request History
4 previous requests available
====
Session
+
Session
- 0(null)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerusers
- actionagent_view
- named(empty)
- pass(array)
  0165
  1amy-rio
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys(empty)
- options(empty)
- defaults(array)
  controllerusers
  actionagent_view
  plugin(null)
- template/agent-detail/*
====

Sql Log

Sql Logs

default

Total Time: 6 ms
Total Queries: 6 queries

Query	Affected	Num. rows	Took (ms)	Actions
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`, `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`, `BrokerageLogoOverride`.`id`, `BrokerageLogoOverride`.`model`, `BrokerageLogoOverride`.`model_id`, `BrokerageLogoOverride`.`tag`, `BrokerageLogoOverride`.`name`, `BrokerageLogoOverride`.`type`, `BrokerageLogoOverride`.`size`, `BrokerageLogoOverride`.`uri`, `BrokerageLogoOverride`.`order`, `BrokerageLogoOverride`.`created`, `BrokerageLogoOverride`.`modified` FROM `leveragere_staging2`.`users` AS `User` LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`User`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`assets` AS `Image` ON (`Image`.`model_id` = `User`.`id` AND `Image`.`model` = 'User' AND `Image`.`tag` = 'Image') LEFT JOIN `leveragere_staging2`.`assets` AS `BrokerageLogoOverride` ON (`BrokerageLogoOverride`.`model_id` = `User`.`id` AND `BrokerageLogoOverride`.`model` = 'User' AND `BrokerageLogoOverride`.`tag` = 'BrokerageLogoOverride') WHERE `User`.`brokerage_id` != 0 AND `Brokerage`.`archived` = '0' AND `User`.`type` IN ('Agent', 'BrokerageAdmin') AND `User`.`id` = 165 LIMIT 1	1	1	1
SELECT `Logo`.`id`, `Logo`.`model`, `Logo`.`model_id`, `Logo`.`tag`, `Logo`.`name`, `Logo`.`type`, `Logo`.`size`, `Logo`.`uri`, `Logo`.`order`, `Logo`.`created`, `Logo`.`modified` FROM `leveragere_staging2`.`assets` AS `Logo` WHERE `Logo`.`model_id` = 182 AND `Logo`.`model` = 'Brokerage' AND `Logo`.`tag` = 'Logo'	1	1	0
SELECT `Article`.`id` FROM `leveragere_staging2`.`articles` AS `Article` WHERE `Article`.`archived` = '0' AND NOT (`Article`.`model` = ('News')) ORDER BY `Article`.`created` DESC LIMIT 50	50	50	2
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 (499, 498, 497, 495, 494, 493, 492, 491, 490, 487, 488, 486, 484, 485, 483, 482, 481, 480, 479, 478, 477, 476, 475, 473, 472, 470, 471, 468, 467, 466, 465, 464, 463, 462, 461, 459, 460, 458, 457, 456, 455, 454, 452, 453, 451, 450, 449, 448, 447, 446) ORDER BY `Image`.`order` ASC	50	50	2
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, 498, 497, 495, 494, 493, 492, 491, 490, 487, 488, 486, 484, 485, 483, 482, 481, 480, 479, 478, 477, 476, 475, 473, 472, 470, 471, 468, 467, 466, 465, 464, 463, 462, 461, 459, 460, 458, 457, 456, 455, 454, 452, 453, 451, 450, 449, 448, 447, 446) ORDER BY RAND() ASC LIMIT 4	4	4	1	maybe slow
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (455, 478, 480, 461) ORDER BY `Image`.`order` ASC	4	4	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 8.14 MB

Message	Memory use
Component initialization	2.95 MB
Controller action start	3.86 MB
Controller render start	5.88 MB
View render complete	6.43 MB

Timers

Total Request Time: 157 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	25.88
Event: Controller.initialize	3.76
Event: Controller.startup	1.11
Controller action	21.92
Event: Controller.beforeRender	4.24
» Processing toolbar data	4.14
Rendering View	79.59
» Event: View.beforeRender	0.27
» Rendering APP/View/Users/agent_view.ctp	1.18
» » Rendering APP/View/Elements/sidebar/article_list.ctp	0.54
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.21
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	77.50
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- sidebar_articles(array)
  0(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
  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
  1(array)
  Article(array)
  id478
  modelLocation
  model_id92
  archived(false)
  medium_featured(false)
  large_featured(true)
  titleLocation: Maui
  authorLeverageRE
  date2016-03-29
  lead_inRemarkable beaches, magnificent waterfalls and breathtaking views, Maui radiates natural beauty. Settled between two mountains, Maui is referred to as the “Valley Isle,” and is the second largest Hawaiian island and home to Leverage Partner The Wailea Group.
  body<p>It is also home to more than 80 beaches, exhibiting black, white or red sand along its 120 miles of shoreline. Grab your camera and take one of the most scenic drives in the world on the Road to Hana, with over 60 curves and 54 bridges. In the mood for dining or shopping? Then Lahaina, once a thriving whaling port in the mid 1800’s, is the destination for you. Snorkeling, surfing, kiteboarding, and even whale watching are among the many activities to experience on Maui. Countless activities to be had on a little piece of paradise:</p> <p><img class="aligncenter wp-image-12905 pure-img" src="/assets/3294.png" /></p> <p><strong>REJUVENATE. </strong> Get pampered at the new Andaz Maui at Wailea's <a href="http://maui.andaz.hyatt.com/hyatt/pure/spas/" target="_blank">‘Awili Spa and Salon</a> with treatments featuring custom-blended products from the apothecary bar.</p> <p><img class="aligncenter wp-image-12900 pure-img" src="/assets/3295.png" /></p> <p><strong>SWING</strong>. Soak up the ocean views on the rugged terrain of the <a href="http://www.waileagolf.com/index.php?linksid=4" target="_blank">Wailea Golf Club's Gold Course</a> or the more player-friendly <a href="http://www.waileagolf.com/index.php?linksid=13" target="_blank">Emerald Course</a>.</p> <p><img class="aligncenter wp-image-12902 pure-img" src="/assets/3296.png" /></p> <p><strong>DINE.</strong> Tap into the island's Polynesian roots with a visit to the famed <a href="http://www.mamasfishhouse.com/" target="_blank">Mama's Fish House</a> restaurant,a local legend since 1973. Savor traditional fresh fare caught by local fi against the backdrop of a secluded white-sand beach.</p> <p><strong>DRESS.</strong> The <a href="http://www.fourseasons.com/maui/services_and_amenities/other_facilities_and_services/shopping_boutiques/" target="_blank">Four Seasons Resort Maui at Wailea</a> has earned its stripes not only as one of the island's premiere hotels, but as a shopping destination, too. Overseen by retail experts Seaside Luxe, three distinct boutiques on the property offer everything from branded resort wear to designer apparel from Tory Burch and Stella McCartney.</p> <p><img class="aligncenter wp-image-12901 pure-img" src="/assets/3297.png" /></p> <p><strong>SPLASH.</strong> With locations in Kihei and Lahaina, the pros at <a href="http://www.mauiwaveriders.com/" target="_blank">Maui Wave Riders</a> school have aspiring surfers and stand-up paddlers covered.</p> <p><img class="aligncenter wp-image-12906 pure-img" src="/assets/3298.png" /></p>
  vimeo_id
  created2016-04-05 14:34:57
  modified2016-04-14 12:19:38
  uri/articles/view/478/location-maui
  Image(array)
  0(array)
  id3299
  modelArticle
  model_id478
  tagImage
  nameScreen-Shot-2016-03-28-at-7.16.19-PM.png
  typeimage/png
  size1869697
  uri/assets/3299.png
  order0
  created2016-04-05 14:34:58
  modified2016-04-14 12:19:38
  2(array)
  Article(array)
  id480
  modelArticle
  model_id0
  archived(false)
  medium_featured(true)
  large_featured(false)
  titleCelebrity Spotlight: Madison Hildebrand
  authorLeverageRE
  date2016-03-29
  lead_inThough reality television enthusiasts are used to seeing Madison Hildebrand's million-dollar smile on BRAVO's Million Dollar Listing Los Angeles for the past eight seasons, this summer he could be found everywhere from a yacht on the French Riviera to wielding a shovel and mixing cement in Managua.
  body<div> <div> <div> </div> </div> <div> <div> <p>He started the summer as an ambassador with <a href="https://givebackhomes.com/" target="_blank">Give Back Homes</a>, traveling to the capital of Nicaragua to build a home for a local family.</p> <p>"With every brick you lay and shovel you shovel, every pile of rocks you move, you feel good. It's blood, sweat, and tears in the heat, but you can't help but feel good about it," Hildebrand said.</p> <p><img class="aligncenter size-full wp-image-12996 pure-img" src="/assets/3305.png" /></p> <p>Not one to miss an opportunity, Hildebrand mixed service with business and pleasure by meeting with Partners Trust and Leverage Global Partners while in Nicaragua-but in a slightly different locale.</p> <p>"We took a helicopter across the country to Guacalito, which is a surf town. To get there you fly over a massive volcano, which is incredible, and land at Mukul Resort. They hosted us and gave us a four-bedroom villa, a butler-it was an amazing couple of days," he reflected. "It was awesome and refreshing. It's one of the coolest things to build a house and experience a different part of the country."</p> <p><img class="aligncenter wp-image-12997 pure-img" src="/assets/3306.png" /></p> <p>Hildebrand has summered abroad every year since moving to Malibu in 1999 to attend Pepperdine University. This year's odyssey took him along the azure coasts of Italy and the French Riviera.</p> </div> <div> <p>"This summer I had the fortunate opportunity to board a 110-foot yacht that one of my clients and best friends booked. We flew into Florence, then eight of my best friends took the yacht from the port down to Positano, where one of my friends got engaged."</p> <p>From Positano to Corsica, Monaco, Nice, and Antibes, Hildebrand described the theme of the trip as "you don't even know what you don't even know," as only the host knew what adventure awaited them at the next port.</p> <p><img class="aligncenter size-full wp-image-12992 pure-img" src="/assets/3307.png" /></p> <div> <div> <div> <p>An avid traveler, gardener, real estate guru, and enthusiast of joie de vivre, Hildebrand believes in loving what you do and doing what you love. His company, <a href="http://www.themalibulife.com/" target="_blank">The Malibu Life</a>, is inspired by just that: the aspirational lifestyle that draws people to the area's more laid-back, yet glamorous, sensibility.</p> <p>"It's really that we are an extension of selling the lifestyle more than just a house. It's a very chic, but casually sophisticated group of people with all sorts of backgrounds," Hildebrand explains. "More than anything, Mother Nature is a key element that ties it all together, but you're still on the cusp of everything LA-so you still have fashion and the entertainment events-but out here it's much more easygoing and relaxed."</p> <p><img class="aligncenter size-full wp-image-12994 pure-img" src="/assets/3308.png" /></p> <p>Hildebrand wears many hats, including acting as a concierge of sorts. "My brand and myself are resources to live the lifestyle they came here to live. If they want surf instructors, or they want horseback riding, I have all those connections. You want fancy cars? I've got a car dealer. If they need a private jet, I've got an affiliation with that company."</p> </div> <div> <p>One of the roles he's taken on again this past year is appearing on Million Dollar Listing Los Angeles. He "retired" after season 6, but fans will see him come out of retirement with his own episodes midway through this season. Hildebrand said his hiatus from the show came from his regular practice of reevaluating priorities.</p> <p>"Our show in particular is one of the longest-filmed shows for reality. It takes about ten or eleven months to get the 12 to 14 episodes, and between filming and wardrobe, it's absolutely exhausting," he explains. "At the end of the day it was time to look at why I was doing it, and I just felt like it was time to tap out. I've come back because it can be on my terms, and I'm excited to update my fans on what's going on in my life."</p> <p><img class="aligncenter size-full wp-image-12993 pure-img" src="/assets/3309.png" /></p> </div> <div> <p>Hildebrand's priorities this fall include hosting the Breast Cancer Research Foundation's Play For P.I.N.K. golf tournament in October, a cause close to his heart after losing his grandmother to the disease. He will participate in another Give Back Homes buildsite in San Diego in November, as well as speaking at the National Association of Realtors Conference.</p> <p>Hildebrand's life won't be slowing down anytime soon-and that's just how he likes it.</p> <p>"I think you're either expanding or contracting," he said. "That's just the way it is. If you're not lifting weight, your muscles are deflating; if you are, they're inflating. Your mind is the same way. If I'm not doing something good for my soul like gardening or exercising, then I'm doing something healthy for my mind-so if that's meditating, reading, learning something new, or finding another passion, that's also a big part of who I am."</p> <p><img class="aligncenter wp-image-12995 pure-img" src="/assets/3310.png" /></p> </div> </div> </div> </div> </div> </div>
  vimeo_id
  created2016-04-05 14:35:00
  modified2016-04-11 17:49:35
  uri/articles/view/480/celebrity-spotlight-madison-hildebrand
  Image(array)
  0(array)
  id3311
  modelArticle
  model_id480
  tagImage
  name2-3.jpg
  typeimage/jpg
  size106052
  uri/assets/3311.jpg
  order0
  created2016-04-05 14:35:01
  modified2016-04-11 17:49:35
  3(array)
  Article(array)
  id461
  modelArticle
  model_id0
  archived(false)
  medium_featured(true)
  large_featured(false)
  titleShop The Store: Saint-Louis
  authorLeverageRE
  date2016-03-17
  lead_inSaint-Louis, the famed French crystal company established in 1586, has long been celebrated for its finely crafted stemware and objets, but lately, the oldest European crystal manufacturer has been carving a new path for itself with design collaborations that have forged the company into a new modern era.
  body<p>Based in Saint-Louis-lès-Bitche, in northeastern France, the company debuted several new lighting collections, including collaborations with Paola Navone Hervé van der Straeten Éric Gizard and Ionna Vautrin. While Saint-Louis today owned by Hermès, still upholds its reputation for traditional wares, the new lighting pieces are an excellent statement, whether on their own or blended with more classic styles. Although the website displays a comprehensive selection, purchasing is best done via telephone: 855.240.9740.</p> <p><a href="http://www.saint-louis.com/en/" target="_blank"><img class="aligncenter wp-image-12630 pure-img" src="/assets/3185.png" /></a><a href="http://www.saint-louis.com/en/" target="_blank"><img class="aligncenter wp-image-12627 pure-img" src="/assets/3186.png" /></a> <a href="http://www.saint-louis.com/en/" target="_blank"><img class="aligncenter wp-image-12636 pure-img" src="/assets/3187.png" /></a> <a href="http://www.saint-louis.com/en/" target="_blank"><img class="aligncenter wp-image-12634 pure-img" src="/assets/3188.png" /></a></p>
  vimeo_id
  created2016-04-05 14:31:48
  modified2016-04-11 17:16:40
  uri/articles/view/461/shop-the-store-saint-louis
  Image(array)
  0(array)
  id3189
  modelArticle
  model_id461
  tagImage
  nameSt-louis.jpg
  typeimage/jpg
  size69717
  uri/assets/3189.jpg
  order0
  created2016-04-05 14:31:49
  modified2016-04-11 17:16:40
- agent(array)
  User(array)
  id165
  typeBrokerageAdmin
  brokerage_id182
  email[email protected]
  password4c47b873ee3bf155444a6c1e0983923d63eb4293
  recover_hash
  first_nameAmy
  last_nameRio
  title
  dre_num
  phone
  max_luxury_feed_properties0
  headshot_filename
  bio
  brokerage_name_override
  stripe_customer_id
  digital_ad_first_free_month_couponineligible
  modified2025-09-05 10:57:27
  created2016-04-08 16:34:20
  notified(true)
  full_nameAmy Rio
  uri/agent-detail/165/amy-rio
  profile_complete(true)
  Brokerage(array)
  id182
  account_executive_id235
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties8
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties4
  membership_luxury_feed_properties4
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id0
  WOEID2410661
  timezone
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts[email protected]
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameExecutive Real Estate
  broker_of_record_name
  short_nameExecutive Real Estate
  usernameExecutiveRealEstate
  password4c47b873ee3bf155444a6c1e0983923d63eb4293
  password_reset_hash
  monthly_invoice_amount(null)
  monthly_invoice_start_date(null)
  monthly_invoice_end_date(null)
  contract_filename
  active(true)
  lead_in
  short_description
  description<p>Executive Real Estate is the exclusive representative for Leverage Global Partners in Hartford, Middlesex and Tolland counties, CT, USA.</p> <p>My Story,</p> <p>I began in real estate at the ripe age of 18. Right out of high school I worked at Century 21 in Glastonbury Village Green and felt as if I was this little girl in the big world of Real Estate. My first few months were hard, I felt as if I was spinning my wheels and having to borrow gas money to get to my appointments.</p> <p>My current office manager, Armand, who was my broker at that time, offered a trip to New York all-expenses paid which could be won through a contest. Being 18 I had never been to NYC so I thought it would be amazing to win the contest and the trip; 10 transactions in one month. I plotted a plan to do just that.</p> <p>Once again I borrowed money to get gas and food and went on a mission. I sought out and then knocked on doors of ‘for sale by owners’ and ‘expireds’. I was so wide eyed and eager to win that trip I informed every potential seller and buyer that I needed to not only list, but sell their home immediately to win the trip.</p> <p>I won the trip.</p> <p>I found that setting a GOAL had helped me achieve what I truly wanted. I then spent every month setting and obtaining those goals.</p> <p>At the age of 21 I was driving a Lincoln; I had a nicer car than most agents around me at the time. I was also pregnant with my first child. This seemed scary as I was making great sales, so my new goal was to stock up on my finances and secure a future for my baby boy.</p> <p>I knew the in and outs of Real Estate and only in a few short years living as an agent, I had superseded all my goals which happen to make me the Century 21 1997 Top 10 Producers in the state of CT. I was the Century 21 Top Producer.</p> <p>I calculated my career path and got extremely large, so large that my business model outgrew me. I had arranged a team of Agents for fielding my buyer calls and I maintained my personal referrals.</p> <p>The agents started to flock around me and after years of flourishing in this fashion my team came to me and asked if I would open my own firm. My team, the founding agents of Executive Real Estate, formed with me a new business entity. We immediately became one of the largest independent offices in our local Realtor market.</p> <p>We were all scared about venturing off on our own. But the simple truth is that if your Customer Service is held to the highest standard then growth is unstoppable. Our clients then began to grow our business; the personal referrals to all of our executive agents had flourished.</p> <p>Today, we are over 50 agents strong and always growing!</p>
  communitiesGlastonbury Hartford County Middlesex County Tolland County
  websitehttp://www.executiverealestatellc.com/
  address17 School Street
  address_2
  cityGlastonbury
  stateCT
  full_stateConnecticut
  countryUSA
  market
  market_2
  postal_code06033
  phoneCell: (860) 916-6048
  phone_2Office: (860) 633-8800
  phone_3
  wide_contact_image(false)
  contact_nameAmy Rio
  contact_profile_link
  contact_big_profile_link
  contact_big_profile_link_text
  contact_titleOwner/Broker
  contact_dre_num
  contact_quote
  contact_email[email protected]
  contact_facebook
  contact_twitter
  contact_instagram
  contact_pinterest
  contact_linkedin
  contact_youtube
  contact_phone
  contact_email_2
  contact_2_facebook
  contact_2_twitter
  contact_2_instagram
  contact_2_pinterest
  contact_2_linkedin
  contact_2_youtube
  contact_phone_2
  contact_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_filename182.jpg
  logo_filename182.jpg
  contact_image_filename182.png
  all_properties_link_image_filename182.jpg
  all_properties_link
  video_embed_code<iframe width="560" height="315" src="https://www.youtube.com/embed/mlI0ztD_zGo?controls=0&showinfo=0" frameborder="0" allowfullscreen></iframe>
  contact_video_embed_code
  meta_titleGlastonbury Real Estate⎜Executive Real Estate⎜Leverage Global Partners
  meta_descriptionExecutive Real Estate is the exclusive representative for Leverage Global Partners in Hartford, Middlesex and Tolland counties, CT, USA.
  meta_keywordsExecutive Real Estate, Leverage Global Partners, Hartford Real Estate, Middlesex Real Estate, Tolland Real Estate, Connecticut Real Estate
  login_message_counter0
  stats_module_1_type
  stats_module_1_value
  stats_module_2_type
  stats_module_2_value
  stats_module_3_type
  stats_module_3_value
  last_activity_email_sent0000-00-00 00:00:00
  converted(true)
  created2015-01-15 11:28:32
  modified2022-01-13 09:51:32
  dre_num012345
  Logo(array)
  id23093
  modelBrokerage
  model_id182
  tagLogo
  name142748.png
  typeimage/png
  size9564
  uri/assets/23093.png
  order0
  created2020-12-22 13:15:11
  modified2022-01-13 09:51:32
  uri/brokerage-detail/182/executive-real-estate
  website_shortwww.executiverealestatellc.com
  name_with_locationExecutive Real Estate
  Image(array)
  id23138
  modelUser
  model_id165
  tagImage
  namecharmeling.jpg
  typeimage/jpeg
  size12479
  uri/assets/23138.jpg
  order0
  created2025-09-05 10:57:25
  modified2025-09-05 10:57:27
  BrokerageLogoOverride(array)
  id(null)
  model(null)
  model_id(null)
  tag(null)
  name(null)
  type(null)
  size(null)
  uri(null)
  order(null)
  created(null)
  modified(null)
- 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)
  User(empty)
  Brokerage(empty)
  Logo(empty)
  BrokerageLogoOverride(empty)
  Image(empty)
  Article(empty)
  Location(empty)
  Property(empty)
  PropertyFeature(empty)
  SecondaryPropertyCategory(empty)
  Topic(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	/agent-detail/165/amy-rio
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/agent-detail/165/amy-rio
Remote Port	18847
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	162.159.115.42
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
Http Accept Encoding	gzip, br
Http Accept	/
Http Cf Ray	a09e01b8ad144603-CMH
Http X Forwarded For	216.73.216.172
Proxy-nokeepalive	1
Ssl Tls Sni	staging2.leveragere.com
Https	on
Passenger Download Native Support Binary	0
Passenger Compile Native Support Binary	0
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Unique Id	aio_DlLEEfcqtnCHo5UupgAAAAs
Redirect Status	200
Redirect Ssl Tls Sni	staging2.leveragere.com
Redirect Https	on
Redirect Passenger Download Native Support Binary	0
Redirect Passenger Compile Native Support Binary	0
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Unique Id	aio_DlLEEfcqtnCHo5UupgAAAAs
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781153550.2014
Request Time	1781153550

====

Include
+
Included Files

Include Paths
- 0/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib
- 2/opt/plesk/php/7.4/share/pear
- 3-> /var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/AuthComponent.php
  1CORE/Controller/Component/SessionComponent.php
  2CORE/Controller/Component/CookieComponent.php
  3CORE/Controller/Component/RequestHandlerComponent.php
  4CORE/Controller/Component/Auth/FormAuthenticate.php
  5CORE/Controller/Component/Auth/BaseAuthenticate.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/CakeObject.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/RedirectRoute.php
  7CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/CakeText.php
  5CORE/Utility/ClassRegistry.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Component(array)
  0APP/Controller/Component/PermissionComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/UsersController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/Subscription.php
  1APP/Model/AppModel.php
  2APP/Model/User.php
  3APP/Model/Brokerage.php
  4APP/Model/Asset.php
  5APP/Model/Article.php
  6APP/Model/Location.php
  7APP/Model/Property.php
  8APP/Model/PropertyFeature.php
  9APP/Model/PropertyCategory.php
  10APP/Model/Topic.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
====

Amy Rio

Amy Rio's Featured Properties

More Properties from Executive Real Estate

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 6 ms Total Queries: 6 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 6 ms
Total Queries: 6 queries