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) 1765605600 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) 1765605600 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) 1765605600 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) 1765605600 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) 1765605600 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) 1765605600 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) 1765605600 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) 1765605600 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
For body art fit for a king or queen, Monarch Tattoo Studio is a sure bet. Known for its spectacular custom artwork, Monarch Tattoo Studio is a family-run studio operated by artists Mike and Laura… Read More
You don’t have to be a culinary student to learn from the experts at Windward Community College. This local institution proudly offers a one-day baking class to teach you all the basics you… Read More
Keo’s Kitchen is the most diverse Thai restaurant on this list. They also serve breakfast and many classic Hawaiian dishes.
Read MoreTurtle Bay is one of the most beloved Hawaiian resorts, and for a good reason. It’s a place you can go for all the pampering and luxury you could want along with unique adventures like… Read More
Bay View Mini-Putt and Zipline is among Hawaii’s best-known mini golf courses, and for good reason. This beautiful putt-putt course is available for either 18 holes or 36 holes so you can enjoy… Read More
Kemo’o Farms Pub and Grill isn’t hidden behind a password like a typical speakeasy but it has an intimate speakeasy-type atmosphere that can be a fun switch for your next night out.… Read More
With just one look at the menu at Guadalajara Grill, you’re going to want to find time to dine there. This tasty restaurant features a delicious enchiladas plate, taquitos, Mexican garlic… Read More
Tea Time Taiwan is an authentic Taiwanese dessert place specialized in bubble tea, smoothies, puddings, and honey toast. The menu is huge here, with orders ranging from simple, like black tea, to… Read More
Not one to spend your vacation lounging on the beach all week? Turtle Bay Resort is uniquely renowned for its massive list of activities guests can enjoy. Horseback riding, golfing, helicopter rides,… Read More
The Polynesian Cultural Center is a Polynesian theme park and living museum located in Laie, on the northern shore of Oahu, Hawaii. At this center, Pacific island people “demonstrate their… 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 Kaaawa', '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.555700302124, 'lng' => (float) -157.85299682617, 'latlng' => '21.555700302124,-157.85299682617', 'city' => 'Kaaawa', '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' => 'kaaawa-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
Kaaawa, Hawaii. Population for Kaaawa from the last gathering is 1324. You can view Kaaawa venues that host many Kaaawa HI events every year.
You can find a ton of properties for sale if you search the Kaaawa page on Zillow. Currently Kaaawa has an average listing price for homes for sale on the market of $895,501. More real estate facts about Kaaawa: The number of properties currently for sale in Kaaawa is 3,118. The median homes for sale listing price is $453,333. This is broken down with the number of three bedroom houses in Kaaawa consisting of 813 with an average listing price for these house of $743,821. Out of the 419 houses that are four bedroom the average listing price for Kaaawa is $1,318,262. Interest rates for Kaaawa are at historic lows as well.
Kaaawa Hawaii has a latitude of 21.555700302124 and a longitude of -157.85299682617. 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.towns.find( {"sef_url":"trenton-ut"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 5 | |
| 2 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 10 | |
| 3 | db.towns.find( {"sef_url":"kaaawa-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 6 | |
| 4 | db.pages.find( {"type":"town","slug":{"$in":["home"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 12 | |
| 5 | db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | 0 | 4 | 3 | |
| 6 | db.ttd_towns.find( {"town_sef_url":"kaaawa-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 6 | |
| 7 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 4 | |
| 8 | db.modules.find( {"module_id":"1022"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 | |
| 9 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 10 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-157.85299682617188,21.555700302124023],"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(1765679645030)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1765679645030)","$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 | 49 | |
| 11 | db.ttd_towns.find( {"town_sef_url":"kaaawa-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | 0 | 0 | 2 | |
| 12 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 10 | |
| 13 | db.events_cache.find( {"_id":"267af98c4f43b0981f933fda5799cde0"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 3 | |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1766296799)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-157.85299682617188,21.555700302124023],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 | 31 | |
| 15 | db.events_cache.count( {"_id":"267af98c4f43b0981f933fda5799cde0"} ) | 0 | 0 | 25 | |
| 16 | db.events_cache.count( {"_id":"267af98c4f43b0981f933fda5799cde0"} ) | 0 | 0 | 9 | |
| 17 | db.events_cache.insert( {"_id":"267af98c4f43b0981f933fda5799cde0","town_sef_url":"kaaawa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-157.85299682617188,21.555700302124023],\"has_next_page\":false}","modified":"MongoDate(0.30400000 1765679645)","created":"MongoDate(0.30400000 1765679645)"} , true) | 0 | 0 | 10 | |
| 18 | db.events_cache.find( {"_id":"b7fb47a59d1f9b5cbed159fd1c91c430"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1766555999)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-157.85299682617188,21.555700302124023],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 | 70 | |
| 20 | db.events_cache.count( {"_id":"b7fb47a59d1f9b5cbed159fd1c91c430"} ) | 0 | 0 | 16 | |
| 21 | db.events_cache.count( {"_id":"b7fb47a59d1f9b5cbed159fd1c91c430"} ) | 0 | 0 | 11 | |
| 22 | db.events_cache.insert( {"_id":"b7fb47a59d1f9b5cbed159fd1c91c430","town_sef_url":"kaaawa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"10\",\"show\":1,\"geo\":[-157.85299682617188,21.555700302124023],\"has_next_page\":false}","modified":"MongoDate(0.53400000 1765679645)","created":"MongoDate(0.53400000 1765679645)"} , true) | 0 | 0 | 10 | |
| 23 | db.events_cache.find( {"_id":"a96e5047a5f3fa63c7d5ef470e6710dc"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 9 | |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1768283999)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-157.85299682617188,21.555700302124023],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 | 168 | |
| 25 | db.events_cache.count( {"_id":"a96e5047a5f3fa63c7d5ef470e6710dc"} ) | 0 | 0 | 4 | |
| 26 | db.events_cache.count( {"_id":"a96e5047a5f3fa63c7d5ef470e6710dc"} ) | 0 | 0 | 5 | |
| 27 | db.events_cache.insert( {"_id":"a96e5047a5f3fa63c7d5ef470e6710dc","town_sef_url":"kaaawa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"30\",\"show\":1,\"geo\":[-157.85299682617188,21.555700302124023],\"has_next_page\":false}","modified":"MongoDate(0.05800000 1765679646)","created":"MongoDate(0.05800000 1765679646)"} , true) | 0 | 0 | 1 | |
| 28 | db.events_cache.find( {"_id":"85ef163137aad68379d7b61034f031fb"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 2 | |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1766296799)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.85299682617188,21.555700302124023],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 | 14 | |
| 30 | db.events_cache.count( {"_id":"85ef163137aad68379d7b61034f031fb"} ) | 0 | 0 | 10 | |
| 31 | db.events_cache.count( {"_id":"85ef163137aad68379d7b61034f031fb"} ) | 0 | 0 | 24 | |
| 32 | db.events_cache.insert( {"_id":"85ef163137aad68379d7b61034f031fb","town_sef_url":"kaaawa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-157.85299682617188,21.555700302124023],\"has_next_page\":false}","modified":"MongoDate(0.17400000 1765679646)","created":"MongoDate(0.17400000 1765679646)"} , true) | 0 | 0 | 3 | |
| 33 | db.events_cache.find( {"_id":"17fa84a8b40c013ff61361cc9bcdae25"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 4 | |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1766901599)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.85299682617188,21.555700302124023],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 | |
| 35 | db.events_cache.count( {"_id":"17fa84a8b40c013ff61361cc9bcdae25"} ) | 0 | 0 | 11 | |
| 36 | db.events_cache.count( {"_id":"17fa84a8b40c013ff61361cc9bcdae25"} ) | 0 | 0 | 2 | |
| 37 | db.events_cache.insert( {"_id":"17fa84a8b40c013ff61361cc9bcdae25","town_sef_url":"kaaawa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-157.85299682617188,21.555700302124023],\"has_next_page\":false}","modified":"MongoDate(0.33800000 1765679646)","created":"MongoDate(0.33800000 1765679646)"} , true) | 0 | 0 | 9 | |
| 38 | db.events_cache.find( {"_id":"4c3ae6722d644cee70234e9397ec5e74"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 10 | |
| 39 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1765951199)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-157.85299682617188,21.555700302124023],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 | 2 | 11 | |
| 40 | db.events_cache.count( {"_id":"4c3ae6722d644cee70234e9397ec5e74"} ) | 0 | 0 | 7 | |
| 41 | db.events_cache.count( {"_id":"4c3ae6722d644cee70234e9397ec5e74"} ) | 0 | 0 | 9 | |
| 42 | db.events_cache.insert( {"_id":"4c3ae6722d644cee70234e9397ec5e74","town_sef_url":"kaaawa-hi","data_key":["68fc9c93b968d244290c2f01"],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-157.85299682617188,21.555700302124023],\"has_next_page\":true}","modified":"MongoDate(0.44400000 1765679646)","created":"MongoDate(0.44400000 1765679646)"} , true) | 0 | 0 | 2 | |
| 43 | db.events_cache.find( {"_id":"10c383468a44b7a2d58c5cf2d0538dd1"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 8 | |
| 44 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1767506399)"},"event_id":{"$nin":[76275636]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-157.85299682617188,21.555700302124023],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 | 43 | 215 | |
| 45 | db.events_cache.count( {"_id":"10c383468a44b7a2d58c5cf2d0538dd1"} ) | 0 | 0 | 1 | |
| 46 | db.events_cache.count( {"_id":"10c383468a44b7a2d58c5cf2d0538dd1"} ) | 0 | 0 | 8 | |
| 47 | db.events_cache.insert( {"_id":"10c383468a44b7a2d58c5cf2d0538dd1","town_sef_url":"kaaawa-hi","data_key":["69169295de4ae56f5ad4e42c","68dde21fc3af739f25c566f7","68dde21fc3af739f25c567c0","68b8f82ac3af739f25568274","68b8f82ac3af739f255682c7","68b8f82ac3af739f25568306","68b8f82ac3af739f25568368","68b8f82bc3af739f2556838b","68d74abcc3af739f25e1e209","68b8f82bc3af739f25568422","68b8f82bc3af739f2556844d","687f4f92fb5e4bed1f73d5fd","68b8f82bc3af739f255684dc","69251312de4ae56f5a2520f5","689d5a3efb5e4bed1f4b017e","68d74abdc3af739f25e1e35b","689ab73efb5e4bed1fded3f3","689d5a3efb5e4bed1f4b01f7","69251312de4ae56f5a2521a4","68d74abdc3af739f25e1e408","68e86e1ec3af739f25218ea7","68a2a04cfb5e4bed1fbe5471","68a2a04cfb5e4bed1fbe5483","68a2a04cfb5e4bed1fbe5491","68a2a04cfb5e4bed1fbe54a8","690ab51cde4ae56f5a840ed7","68639ff5fb5e4bed1fa5e9ff","690ab51cde4ae56f5a840f0c","69266493de4ae56f5ae4877a","6930f092de4ae56f5aa6e8dd","69266493de4ae56f5ae48797","690ab51cde4ae56f5a840f68","690ab51cde4ae56f5a840f77","690c0697de4ae56f5a9c0c24","690c0697de4ae56f5a9c0c3a","690c0697de4ae56f5a9c0c4f","690c0698de4ae56f5a9c0cd5","6917e415de4ae56f5a8ffbe0","6917e415de4ae56f5a8ffbea","6917e415de4ae56f5a8ffbed","6917e415de4ae56f5a8ffc19","6895714afb5e4bed1fd7728d","6895714afb5e4bed1fd772b7"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-157.85299682617188,21.555700302124023],\"has_next_page\":false}","modified":"MongoDate(0.87100000 1765679646)","created":"MongoDate(0.87100000 1765679646)"} , true) | 0 | 0 | 8 | |
| 48 | db.events_cache.find( {"_id":"ad0f2324b0318dd9ae7c4c24b3378b5f"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 3 | |
| 49 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1767506399)"},"event_id":{"$nin":[76275636,76304785]},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.85299682617188,21.555700302124023],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 | 17 | |
| 50 | db.events_cache.count( {"_id":"ad0f2324b0318dd9ae7c4c24b3378b5f"} ) | 0 | 0 | 2 | |
| 51 | db.events_cache.count( {"_id":"ad0f2324b0318dd9ae7c4c24b3378b5f"} ) | 0 | 0 | 1 | |
| 52 | db.events_cache.insert( {"_id":"ad0f2324b0318dd9ae7c4c24b3378b5f","town_sef_url":"kaaawa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-157.85299682617188,21.555700302124023],\"has_next_page\":false}","modified":"MongoDate(0.95200000 1765679646)","created":"MongoDate(0.95200000 1765679646)"} , true) | 0 | 0 | 1 | |
| 53 | db.places.find( {"geo":{"$near":[-157.85299682617188,21.555700302124023],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | 0 | 17 | 2 | |
| 54 | 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-tattoo-parlor-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/tattoo-parlors\/\" target=\"_blank\">10 Best Tattoo Parlors 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\/tattoo-parlors\/\" target=\"_blank\">Monarch Tattoo Studio, Hauula, 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\">For body art fit for a king or queen, Monarch Tattoo Studio is a sure bet. Known for its spectacular custom artwork, Monarch Tattoo Studio is a family-run studio operated by artists Mike and Laura… <a href=\"https:\/\/bestthingshi.com\/tattoo-parlors\/\" 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-cooking-classes-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/cooking-classes\/\" target=\"_blank\">10 Best Cooking Classes 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\/cooking-classes\/\" target=\"_blank\">Windward Community College, Kaneohe, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,community-life-bt,community-life-p300,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">You don’t have to be a culinary student to learn from the experts at Windward Community College. This local institution proudly offers a one-day baking class to teach you all the basics you… <a href=\"https:\/\/bestthingshi.com\/cooking-classes\/\" 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-thai-restaurants-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/thai-restaurants\/\" target=\"_blank\">10 Best Thai Restaurants 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\/thai-restaurants\/\" target=\"_blank\">Keo\u2019s Kitchen, Wahiawa, 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\"><p>Keo’s Kitchen is the most diverse Thai restaurant on this list. They also serve breakfast and many classic Hawaiian dishes.<\/p> <a href=\"https:\/\/bestthingshi.com\/thai-restaurants\/\" 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\">Turtle Bay Resort, Kahuku, 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\">Turtle Bay is one of the most beloved Hawaiian resorts, and for a good reason. It’s a place you can go for all the pampering and luxury you could want along with unique adventures like… <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-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\">Bay View Mini-Putt and Zipline, Kaneohe, 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\">Bay View Mini-Putt and Zipline is among Hawaii’s best-known mini golf courses, and for good reason. This beautiful putt-putt course is available for either 18 holes or 36 holes so you can enjoy… <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-speakeasies-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/speakeasy-bars\/\" target=\"_blank\">7 Best Speakeasies 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\/speakeasy-bars\/\" target=\"_blank\">Kemo\u2019o Farms Pub and Grill, Wahiawa, 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\">Kemo’o Farms Pub and Grill isn’t hidden behind a password like a typical speakeasy but it has an intimate speakeasy-type atmosphere that can be a fun switch for your next night out.… <a href=\"https:\/\/bestthingshi.com\/speakeasy-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-mexican-restaurant-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/mexican-restaurants\/\" target=\"_blank\">The 9 Best Mexican Restaurants 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\/mexican-restaurants\/\" target=\"_blank\">Guadalajara Grill, Laie, 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\">With just one look at the menu at Guadalajara Grill, you’re going to want to find time to dine there. This tasty restaurant features a delicious enchiladas plate, taquitos, Mexican garlic… <a href=\"https:\/\/bestthingshi.com\/mexican-restaurants\/\" 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-bubble-tea-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/bubble-tea\/\" target=\"_blank\">6 Best Bubble Tea Places 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\/bubble-tea\/\" target=\"_blank\">Tea Time Taiwan, Pearl City, 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\">Tea Time Taiwan is an authentic Taiwanese dessert place specialized in bubble tea, smoothies, puddings, and honey toast. The menu is huge here, with orders ranging from simple, like black tea, to… <a href=\"https:\/\/bestthingshi.com\/bubble-tea\/\" 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\">Turtle Bay Resort, Kahuku, 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\">Not one to spend your vacation lounging on the beach all week? Turtle Bay Resort is uniquely renowned for its massive list of activities guests can enjoy. Horseback riding, golfing, helicopter rides,… <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-museums-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/museums\/\" target=\"_blank\">The 9 Best Museums 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\/museums\/\" target=\"_blank\">Polynesian Cultural Center, Laie, Oahu, 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\">The Polynesian Cultural Center is a Polynesian theme park and living museum located in Laie, on the northern shore of Oahu, Hawaii. At this center, Pacific island people “demonstrate their… <a href=\"https:\/\/bestthingshi.com\/museums\/\" 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":"kaaawa-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\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"ttl\":\"1\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/festivals-1.jpg\"}","expiration":1765683246,"type":"Event","id":76275636,"title":"Moanalua High School Winter Craft Fair","url":"\/event\/moanalua-high-school-winter-craft-fair-2025-12-13-honolulu-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-fair-2.jpg"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"ttl\":\"4\",\"israndom\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-1.jpg\"}","expiration":1765694046,"type":"Event","id":76304785,"title":"Big Daddy Kane With Live Band","url":"\/event\/big-daddy-kane-with-live-band-2025-12-30-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/e9f\/ef625275-3e8e-42bd-8f1f-fd1fbe9dfe9f_SOURCE"},{"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":1765708446,"type":"Place","id":2145025,"title":"Tricks and Treats Gift Fair","url":"\/place\/tricks-and-treats-gift-fair-kaneohe-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-fair-2.jpg"}],"modified":"MongoDate(0.96500000 1765679646)","created":"MongoDate(0.96500000 1765679646)","_id":ObjectId ("693e221e7365407db807eacb")} , true) | 0 | 0 | 14 | |
| 55 | db.events_cache.find( {"_id":"f2eb06a32925af307be900d0bfe55ab9"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 9 | |
| 56 | db.events_radius_cache.find( {"_id":"a01c7f773335370b49286438a0df001c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 7 | |
| 57 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)"},"event_id":{"$nin":[76275636,76304785]},"geo":{"$geoWithin":{"$center":[[-157.85299682617188,21.555700302124023],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( 6 ).skip( 0 ) | 0 | 6 | 1791 | |
| 58 | db.events_cache.count( {"_id":"f2eb06a32925af307be900d0bfe55ab9"} ) | 0 | 0 | 48 | |
| 59 | db.events_cache.count( {"_id":"f2eb06a32925af307be900d0bfe55ab9"} ) | 0 | 0 | 3 | |
| 60 | db.events_cache.insert( {"_id":"f2eb06a32925af307be900d0bfe55ab9","town_sef_url":"kaaawa-hi","data_key":["68fca36334c9e7cdf6042e6b","68527c92fb5e4bed1f02806a","68527c92fb5e4bed1f028077","68527c92fb5e4bed1f02809c","68f9e46169adceb60507b8d3"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Kaaawa\",\"keyword\":\"\",\"radius\":15,\"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.555700302124023,\"lng\":-157.85299682617188,\"latlng\":\"21.555700302124,-157.85299682617\",\"city\":\"Kaaawa\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.99700000 1765679648)","created":"MongoDate(0.99700000 1765679648)"} , true) | 0 | 0 | 17 | |
| 61 | db.news.find( {"broadcast":{"$in":["usa","kaaawa-hi","hi","honolulu-county-hi"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 ) | 0 | 6 | 26 | |
| 62 | db.places.find( {"address.town_sef_url":"kaaawa-hi","group_id":{"$nin":[2145025]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | 0 | 3 | 67 | |
| 63 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | 0 | 0 | 96 | |
| 64 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | 0 | 40 | 11 | |
| 65 | db.towns.find( {"sef_url":"kaaawa-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 12 | |
| 66 | db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","kaaawa-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | 0 | 4 | 4 | |
| 67 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 7 | |
| 68 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 11 | |
| 69 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 70 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 26 | |
| 71 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 36 | |
| 72 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 6 | |
| 73 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 31 |





