Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765692000 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765692000 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765692000 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765692000 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765692000 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765692000 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765692000 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765692000 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765692000 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Kukuiolono Park is described as a hidden gem and that’s an incredibly apt description because, settled in a quiet area, this little getaway is the perfect place to have fun with the family.… Read More
A casual spot with a huge breakfast menu, delicious coffee and a nice atmosphere, Kalaheo Café is a solid breakfast choice if you are visiting the island of Kauai. There are vegan and… Read More
For a simple, straightforward margarita served in a location with a beautiful atmosphere, Stevenson’s Sushi and Spirits inside of the Kauai Grand Hyatt is the spot to visit. The Original… Read More
The Kauai Chocolate Shop is family owned and operated and is located at Port Allen on the island of Kauai. Chocolates and treats are made in house and range from tropical truffles to local favorites… Read More
Everyone has their own opinions of what makes a great hotel, but when a resort has won multiple awards, it’s a safe bet that it will give you a premium experience. That’s what… Read More
Ko’a Kea Resort is the ultimate destination to bathe in luxury. This comprehensive Hawaii resort has everything you need for your vacation, including a full on-site spa and yoga and wellness… Read More
La Spezia does a great job with both brunch and dinner and the wine list is extensive. Another restaurant that specializes in Italian, you’ll find bruschetta, arancini and antipasti to start,… Read More
The Puka Dog is a must-mention if you are talking about hot dogs unique to Hawaii. Puka means “hole” and is called such because the bun is skewered on a spike that creates a hole for the… Read More
This sprawling resort will give you the privacy that you are looing for. With beautiful grounds offering pool activities, including a lazy river and waterfall, you will find many adventures await.… Read More
This relaxing, tree-filled shopping center offers free hula dancing performances every Monday and Thursday at 5 p.m. After enjoying the show, dig into a Hawaiian hot dog made from homemade Hawaiian… Read More
Notice (8): Trying to access array offset on value of type null [APP/Plugin/Core/Controller/Component/PlacesComponent.php, line 68]Code Contextif($params['tags'])$options['conditions']['tags'] = $params['tags'];else if($this->params['tags_logical'])$params = array( 'show' => (int) 5, 'title' => 'Organizations around Kalaheo', 'images' => false, 'group_type' => 'organization', 'sort' => 'created', 'sort_rule' => '-1', 'keyword' => '', 'radius' => null, 'limit' => (int) 15, 'page' => (int) 1, 'sef' => '', 'tags' => '', 'tags_logical' => '', 'terms' => '', 'show_limit' => (int) 3, 'days' => '', 'max-days' => (int) 365, 'max-miles' => (int) 45, 'message' => '[message to follow]', 'min' => (int) 50, 'prompt' => '', 'height' => '', 'width' => '', 'data_id' => '', 'more' => true, 'type' => '', 'autoshowmore' => false, 'link' => '', 'showdesc' => '', 'rankby' => '', 'empty-message' => '', 'ad_slots' => '', 'see-more-title' => '', 'searchdate' => '', 'searchenddate' => '', 'lat' => (float) 21.924900054932, 'lng' => (float) -159.52299499512, 'latlng' => '21.924900054932,-159.52299499512', 'city' => 'Kalaheo', 'state' => 'HI', 'theme' => '', 'page_type' => 'town' ) $options = array( 'page' => (int) 1, 'limit' => (int) 5, 'order' => array( 'created' => (int) -1 ), 'conditions' => array( 'address.town_sef_url' => 'kalaheo-hi' ) )PlacesComponent::search() - APP/Plugin/Core/Controller/Component/PlacesComponent.php, line 68 PlacesController::local() - APP/Controller/PlacesController.php, line 52 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Kalaheo, Hawaii. Population for Kalaheo from the last gathering is 3913. You can view Kalaheo venues that host many Kalaheo HI events every year.
You can find a ton of properties for sale if you search the Kalaheo page on Zillow. Currently Kalaheo has an average listing price for homes for sale on the market of $1,070,523. More real estate facts about Kalaheo: The number of properties currently for sale in Kalaheo is 1,009. The median homes for sale listing price is $649,833. This is broken down with the number of three bedroom houses in Kalaheo consisting of 282 with an average listing price for these house of $1,153,868. Out of the 134 houses that are four bedroom the average listing price for Kalaheo is $2,027,951. Interest rates for Kalaheo are at historic lows as well.
Kalaheo Hawaii has a latitude of 21.924900054932 and a longitude of -159.52299499512. View the full profile
On Yahoo, Yelp, SuperPages, AmericanTowns and 25 other directories!
Add your social media links and bio and promote your discounts, menus, events.
Be sure your listing is up on all the key local directories with all your important content (social links and product info).
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 4 | |
| 2 | db.towns.find( {"sef_url":"kalaheo-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 3 | db.pages.find( {"type":"town","slug":{"$in":["home"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 4 | db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | 0 | 4 | 1 | |
| 5 | db.ttd_towns.find( {"town_sef_url":"kalaheo-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 11 | |
| 6 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 7 | db.modules.find( {"module_id":"1022"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 8 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 9 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-159.5229949951172,21.92490005493164],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.025232135647961243,"spherical":true,"query":{"tags":"at-bt-articles-home","state":"HI"}}},{"$project":{"title":1,"homepage_title":1,"tags":1,"image_url":1,"distance":1,"page_path":1,"path":1,"article_hostname":1,"text":1,"publish_date":1,"site_canonical":1,"sections.title":1,"sections.geo":1,"sections.text":1}},{"$addFields":{"days_since":{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1765694819958)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1765694819958)","$publish_date"]},86400000]}]}}},{"$sort":{"relevance_score":1,"_id":1}},{"$skip":0},{"$limit":11}]}, ["article_id","title","homepage_title","tags","image_url","path","article_hostname","sef_tail","page_path","text","publish_date","site_canonical","sections.title","sections.text"] ).sort( {"relevance_score":1,"_id":1} ).limit( 11 ).skip( 0 ) | 0 | 11 | 25 | |
| 10 | db.ttd_towns.find( {"town_sef_url":"kalaheo-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | 0 | 0 | 6 | |
| 11 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 9 | |
| 12 | db.events_cache.find( {"_id":"65b620165afa8573f40da2fa4511f778"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 13 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766383199)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-159.5229949951172,21.92490005493164],0.21739130434782608]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | 0 | 0 | 42 | |
| 14 | db.events_cache.count( {"_id":"65b620165afa8573f40da2fa4511f778"} ) | 0 | 0 | 5 | |
| 15 | db.events_cache.count( {"_id":"65b620165afa8573f40da2fa4511f778"} ) | 0 | 0 | 1 | |
| 16 | db.events_cache.insert( {"_id":"65b620165afa8573f40da2fa4511f778","town_sef_url":"kalaheo-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-159.5229949951172,21.92490005493164],\"has_next_page\":false}","modified":"MongoDate(0.11000000 1765694820)","created":"MongoDate(0.11000000 1765694820)"} , true) | 0 | 0 | 3 | |
| 17 | db.events_cache.find( {"_id":"af7f2abe1041616f56d5e37d3d549b3b"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 18 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766642399)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-159.5229949951172,21.92490005493164],0.21739130434782608]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | 0 | 0 | 45 | |
| 19 | db.events_cache.count( {"_id":"af7f2abe1041616f56d5e37d3d549b3b"} ) | 0 | 0 | 9 | |
| 20 | db.events_cache.count( {"_id":"af7f2abe1041616f56d5e37d3d549b3b"} ) | 0 | 0 | 13 | |
| 21 | db.events_cache.insert( {"_id":"af7f2abe1041616f56d5e37d3d549b3b","town_sef_url":"kalaheo-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"10\",\"show\":1,\"geo\":[-159.5229949951172,21.92490005493164],\"has_next_page\":false}","modified":"MongoDate(0.25600000 1765694820)","created":"MongoDate(0.25600000 1765694820)"} , true) | 0 | 0 | 1 | |
| 22 | db.events_cache.find( {"_id":"954633bf15c3d5e10890934babe9771e"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 23 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1768370399)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-159.5229949951172,21.92490005493164],0.21739130434782608]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | 0 | 1 | 178 | |
| 24 | db.events_cache.count( {"_id":"954633bf15c3d5e10890934babe9771e"} ) | 0 | 0 | 118 | |
| 25 | db.events_cache.count( {"_id":"954633bf15c3d5e10890934babe9771e"} ) | 0 | 0 | 1 | |
| 26 | db.events_cache.insert( {"_id":"954633bf15c3d5e10890934babe9771e","town_sef_url":"kalaheo-hi","data_key":["68dc90a0c3af739f25fd3088"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"30\",\"show\":1,\"geo\":[-159.5229949951172,21.92490005493164],\"has_next_page\":false}","modified":"MongoDate(0.70800000 1765694820)","created":"MongoDate(0.70800000 1765694820)"} , true) | 0 | 0 | 8 | |
| 27 | db.events_cache.find( {"_id":"ed92bb45d768ecdfb22e77c631e3fd22"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 59 | |
| 28 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766383199)"},"event_id":{"$nin":[76199098]},"tags":"music","geo":{"$geoWithin":{"$center":[[-159.5229949951172,21.92490005493164],0.14492753623188406]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | 0 | 0 | 17 | |
| 29 | db.events_cache.count( {"_id":"ed92bb45d768ecdfb22e77c631e3fd22"} ) | 0 | 0 | 5 | |
| 30 | db.events_cache.count( {"_id":"ed92bb45d768ecdfb22e77c631e3fd22"} ) | 0 | 0 | 23 | |
| 31 | db.events_cache.insert( {"_id":"ed92bb45d768ecdfb22e77c631e3fd22","town_sef_url":"kalaheo-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-159.5229949951172,21.92490005493164],\"has_next_page\":false}","modified":"MongoDate(0.95900000 1765694820)","created":"MongoDate(0.95900000 1765694820)"} , true) | 0 | 0 | 1 | |
| 32 | db.events_cache.find( {"_id":"e2671d02e8bcc91d520e77e1a603d0f6"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 10 | |
| 33 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766987999)"},"event_id":{"$nin":[76199098]},"tags":"music","geo":{"$geoWithin":{"$center":[[-159.5229949951172,21.92490005493164],0.21739130434782608]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | 0 | 0 | 33 | |
| 34 | db.events_cache.count( {"_id":"e2671d02e8bcc91d520e77e1a603d0f6"} ) | 0 | 0 | 14 | |
| 35 | db.events_cache.count( {"_id":"e2671d02e8bcc91d520e77e1a603d0f6"} ) | 0 | 0 | 1 | |
| 36 | db.events_cache.insert( {"_id":"e2671d02e8bcc91d520e77e1a603d0f6","town_sef_url":"kalaheo-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-159.5229949951172,21.92490005493164],\"has_next_page\":false}","modified":"MongoDate(0.05800000 1765694821)","created":"MongoDate(0.05800000 1765694821)"} , true) | 0 | 0 | 1 | |
| 37 | db.events_cache.find( {"_id":"365c2e9e41c34b717ecf57c3bbd8c88d"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 4 | |
| 38 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766037599)"},"event_id":{"$nin":[76199098]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-159.5229949951172,21.92490005493164],0.21739130434782608]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | 0 | 0 | 5 | |
| 39 | db.events_cache.count( {"_id":"365c2e9e41c34b717ecf57c3bbd8c88d"} ) | 0 | 0 | 1 | |
| 40 | db.events_cache.count( {"_id":"365c2e9e41c34b717ecf57c3bbd8c88d"} ) | 0 | 0 | 1 | |
| 41 | db.events_cache.insert( {"_id":"365c2e9e41c34b717ecf57c3bbd8c88d","town_sef_url":"kalaheo-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-159.5229949951172,21.92490005493164],\"has_next_page\":false}","modified":"MongoDate(0.08800000 1765694821)","created":"MongoDate(0.08800000 1765694821)"} , true) | 0 | 0 | 1 | |
| 42 | db.events_cache.find( {"_id":"8392be2be90db54779a47762e7a30ea0"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 4 | |
| 43 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1768370399)"},"event_id":{"$nin":[76199098]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-159.5229949951172,21.92490005493164],0.8695652173913043]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | 0 | 2 | 2 | |
| 44 | db.events_cache.count( {"_id":"8392be2be90db54779a47762e7a30ea0"} ) | 0 | 0 | 2 | |
| 45 | db.events_cache.count( {"_id":"8392be2be90db54779a47762e7a30ea0"} ) | 0 | 0 | 3 | |
| 46 | db.events_cache.insert( {"_id":"8392be2be90db54779a47762e7a30ea0","town_sef_url":"kalaheo-hi","data_key":["6900bdcd293763705803efbb"],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-159.5229949951172,21.92490005493164],\"has_next_page\":true}","modified":"MongoDate(0.11800000 1765694821)","created":"MongoDate(0.11800000 1765694821)"} , true) | 0 | 0 | 1 | |
| 47 | db.events_cache.find( {"_id":"2848943f9717a6642648e3fbd1bcdefb"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 48 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1767592799)"},"event_id":{"$nin":[76199098,76281262]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-159.5229949951172,21.92490005493164],1.4492753623188406]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 51 ).skip( 0 ) | 0 | 0 | 53 | |
| 49 | db.events_cache.count( {"_id":"2848943f9717a6642648e3fbd1bcdefb"} ) | 0 | 0 | 1 | |
| 50 | db.events_cache.count( {"_id":"2848943f9717a6642648e3fbd1bcdefb"} ) | 0 | 0 | 1 | |
| 51 | db.events_cache.insert( {"_id":"2848943f9717a6642648e3fbd1bcdefb","town_sef_url":"kalaheo-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-159.5229949951172,21.92490005493164],\"has_next_page\":false}","modified":"MongoDate(0.22800000 1765694821)","created":"MongoDate(0.22800000 1765694821)"} , true) | 0 | 0 | 1 | |
| 52 | db.events_cache.find( {"_id":"6fe01ea28dd6f388d65c7a440826e555"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 53 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1767592799)"},"event_id":{"$nin":[76199098,76281262]},"tags":"music","geo":{"$geoWithin":{"$center":[[-159.5229949951172,21.92490005493164],1.4492753623188406]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 51 ).skip( 0 ) | 0 | 0 | 9 | |
| 54 | db.events_cache.count( {"_id":"6fe01ea28dd6f388d65c7a440826e555"} ) | 0 | 0 | 1 | |
| 55 | db.events_cache.count( {"_id":"6fe01ea28dd6f388d65c7a440826e555"} ) | 0 | 0 | 1 | |
| 56 | db.events_cache.insert( {"_id":"6fe01ea28dd6f388d65c7a440826e555","town_sef_url":"kalaheo-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-159.5229949951172,21.92490005493164],\"has_next_page\":false}","modified":"MongoDate(0.26400000 1765694821)","created":"MongoDate(0.26400000 1765694821)"} , true) | 0 | 0 | 1 | |
| 57 | db.places.find( {"geo":{"$near":[-159.5229949951172,21.92490005493164],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | 0 | 26 | 2 | |
| 58 | db.ttd_towns.insert( {"name":"Article Slideshow","main_slot_type":"module","main_slot_module_id":"1022","main_slot_html":"<div id=\"atCarousel\" class=\"carousel slide\" data-interval=\"5000\" data-ride=\"carousel\">\n\t<ol class=\"carousel-indicators\">\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"0\" class=\"active\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"1\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"2\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"3\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"4\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"5\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"6\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"7\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"8\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"9\" class=\"\"><\/li>\n\t\t\t<\/ol> \n\t<div class=\"carousel-inner\">\n\t\t\t\t<div class=\"item active\" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-mini-golf-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/mini-golf\/\" target=\"_blank\">8 Best Mini Golf Courses in Hawaii<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/mini-golf\/\" target=\"_blank\">Kukuiolono Park and Golf Course, Kalaheo, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,entertainment-bt,entertainment-p300,at-bt-articles-home,at-bt-articles-entertainment<\/div>\n\t\t\t\t<p class=\"small\">Kukuiolono Park is described as a hidden gem and that’s an incredibly apt description because, settled in a quiet area, this little getaway is the perfect place to have fun with the family.… <a href=\"https:\/\/bestthingshi.com\/mini-golf\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-breakfast-spot-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/breakfast-spots\/\" target=\"_blank\">10 Best Breakfast Spots in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/breakfast-spots\/\" target=\"_blank\">Kalaheo Caf\u00e9 and Coffee Company, Kalaheo, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">A casual spot with a huge breakfast menu, delicious coffee and a nice atmosphere, Kalaheo Café is a solid breakfast choice if you are visiting the island of Kauai. There are vegan and… <a href=\"https:\/\/bestthingshi.com\/breakfast-spots\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-margaritas-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/margaritas\/\" target=\"_blank\">7 Best Places for Margaritas in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/margaritas\/\" target=\"_blank\">Stevenson\u2019s Sushi and Spirits, Koloa, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">For a simple, straightforward margarita served in a location with a beautiful atmosphere, Stevenson’s Sushi and Spirits inside of the Kauai Grand Hyatt is the spot to visit. The Original… <a href=\"https:\/\/bestthingshi.com\/margaritas\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-candy-shop-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/candy-shops\/\" target=\"_blank\">10 Best Candy Shops in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/candy-shops\/\" target=\"_blank\">Kauai Chocolate Shop, Eleele, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">The Kauai Chocolate Shop is family owned and operated and is located at Port Allen on the island of Kauai. Chocolates and treats are made in house and range from tropical truffles to local favorites… <a href=\"https:\/\/bestthingshi.com\/candy-shops\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-spa-hotel-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/spa-hotels\/\" target=\"_blank\">10 Best Spa Hotels in Hawaii<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/spa-hotels\/\" target=\"_blank\">K\u014dloa Landing Resort, Koloa, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Everyone has their own opinions of what makes a great hotel, but when a resort has won multiple awards, it’s a safe bet that it will give you a premium experience. That’s what… <a href=\"https:\/\/bestthingshi.com\/spa-hotels\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-unique-hotels-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/unique-hotels\/\" target=\"_blank\">10 Most Unique Hotels in Hawaii<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/unique-hotels\/\" target=\"_blank\">Ko\u2019a Kea Resort on Poipu Beach, Koloa, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Ko’a Kea Resort is the ultimate destination to bathe in luxury. This comprehensive Hawaii resort has everything you need for your vacation, including a full on-site spa and yoga and wellness… <a href=\"https:\/\/bestthingshi.com\/unique-hotels\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-wine-bar-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/wine-bars\/\" target=\"_blank\">5 Best Wine Bars in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/wine-bars\/\" target=\"_blank\">La Spezia, Koloa, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">La Spezia does a great job with both brunch and dinner and the wine list is extensive. Another restaurant that specializes in Italian, you’ll find bruschetta, arancini and antipasti to start,… <a href=\"https:\/\/bestthingshi.com\/wine-bars\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-hot-dog-joints-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/hot-dog-joints\/\" target=\"_blank\">The 6 Best Hot Dog Joints in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/hot-dog-joints\/\" target=\"_blank\">Puka Dog, Koloa, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">The Puka Dog is a must-mention if you are talking about hot dogs unique to Hawaii. Puka means “hole” and is called such because the bun is skewered on a spike that creates a hole for the… <a href=\"https:\/\/bestthingshi.com\/hot-dog-joints\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-resorts-couples-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/resorts-for-couples\/\" target=\"_blank\">10 Best Hotels and Resorts for Couples in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/resorts-for-couples\/\" target=\"_blank\">Grand Hyatt Kauai, Koloa, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,entertainment-bt,entertainment-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-entertainment<\/div>\n\t\t\t\t<p class=\"small\">This sprawling resort will give you the privacy that you are looing for. With beautiful grounds offering pool activities, including a lazy river and waterfall, you will find many adventures await.… <a href=\"https:\/\/bestthingshi.com\/resorts-for-couples\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-shopping-outlet-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/shopping-outlets\/\" target=\"_blank\">The 10 Best Shopping Malls and Outlets in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/shopping-outlets\/\" target=\"_blank\">Poipu Shopping Village, Koloa, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">This relaxing, tree-filled shopping center offers free hula dancing performances every Monday and Thursday at 5 p.m. After enjoying the show, dig into a Hawaiian hot dog made from homemade Hawaiian… <a href=\"https:\/\/bestthingshi.com\/shopping-outlets\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t<\/div>\n<\/div>\n\n\n","town_sef_url":"kalaheo-hi","title":"Hiking!","subtitle":"Maps, directions and reviews for hiking around {local_city_state}!","image_url":"{\"0\":{\"content_type\":\"movie\",\"movie\":\"\/movie\/black-panther-wakanda-forever-297863\/\",\"title\":\"Black Panther: Wakanda Forever\",\"thumbnail\":\"https:\/\/www.movienewsletters.net\/photos\/297863R4.jpg\"},\"1\":{\"content_type\":\"event_tag\",\"searchtag\":\"ticketmaster","url":"\/{town_sef_url}\/hiking\/","slots":[{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"30\",\"ttl\":\"3\",\"isempty\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-1.jpg\"}","expiration":1765705620,"type":"Event","id":76199098,"title":"Hawaii Rainbow Warriors Mens Basketball vs. UC Irvine Anteaters Mens Basketball","url":"\/event\/hawaii-rainbow-warriors-mens-basketball-vs-uc-irvine-anteaters-mens-basketball-2026-01-10-tm-hanamaulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dbimages\/29516a.jpg"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"ttl\":\"2\",\"isempty\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/festivals-1.jpg\"}","expiration":1765702021,"type":"Event","id":76281262,"title":"Kauai Made Craft Fair","url":"\/event\/kauai-made-craft-fair-2025-12-19-lihue-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-fair-1.jpg"},{"rule":"{\"content_type\":\"group_category\",\"radius\":\"10\",\"ttl\":\"8\",\"israndom\":1,\"group_category\":\"arts-and-entertainment\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/arts-1.jpg\",\"days\":1}","expiration":1765723621,"type":"Place","id":1433885,"title":"McBryde Garden","url":"\/place\/mcbryde-garden-koloa-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-botanical-garden-5.jpg"}],"modified":"MongoDate(0.27800000 1765694821)","created":"MongoDate(0.27800000 1765694821)","_id":ObjectId ("693e5d657d22cc1d660b5f11")} , true) | 0 | 0 | 2 | |
| 59 | db.events_cache.find( {"_id":"1c36414406b3c3e6ae885c5f94484827"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 60 | db.events_radius_cache.find( {"_id":"49e2455f7f75c46f92ea5336c2902875"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 61 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)"},"event_id":{"$nin":[76199098,76281262]},"geo":{"$geoWithin":{"$center":[[-159.5229949951172,21.92490005493164],0.36231884057971014]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 6 ).skip( 0 ) | 0 | 6 | 333 | |
| 62 | db.events_cache.count( {"_id":"1c36414406b3c3e6ae885c5f94484827"} ) | 0 | 0 | 2 | |
| 63 | db.events_cache.count( {"_id":"1c36414406b3c3e6ae885c5f94484827"} ) | 0 | 0 | 9 | |
| 64 | db.events_cache.insert( {"_id":"1c36414406b3c3e6ae885c5f94484827","town_sef_url":"kalaheo-hi","data_key":["68527c99fb5e4bed1f028c48","685a6591fb5e4bed1f655e72","6900a79e1e2cec194a046987","68639fe0fb5e4bed1fa5bdba","686f7d69fb5e4bed1fed3870"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Kalaheo\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"images\":true,\"max-days\":365,\"max-miles\":45,\"message\":\"[message to follow]\",\"min\":50,\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"data_id\":\"\",\"more\":true,\"type\":\"\",\"autoshowmore\":false,\"link\":\"\",\"showdesc\":\"\",\"rankby\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":21.92490005493164,\"lng\":-159.5229949951172,\"latlng\":\"21.924900054932,-159.52299499512\",\"city\":\"Kalaheo\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.66400000 1765694821)","created":"MongoDate(0.66500000 1765694821)"} , true) | 0 | 0 | 2 | |
| 65 | db.news.find( {"broadcast":{"$in":["usa","kalaheo-hi","hi","kauai-county-hi"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 ) | 0 | 6 | 8 | |
| 66 | db.places.find( {"address.town_sef_url":"kalaheo-hi","group_id":{"$nin":[1433885]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | 0 | 6 | 2 | |
| 67 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | 0 | 0 | 6 | |
| 68 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | 0 | 40 | 12 | |
| 69 | db.towns.find( {"sef_url":"kalaheo-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 | |
| 70 | db.tokens.find( {"sef_url":{"$in":["usa","hi","kauai-county-hi","kalaheo-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | 0 | 4 | 1 | |
| 71 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 72 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 73 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 74 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 3 | |
| 75 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 76 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 4 | |
| 77 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 |





