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) 1769752800 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) 1769752800 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) 1769752800 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) 1769752800 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) 1769752800 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) 1769752800 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) 1769752800 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) 1769752800 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 193 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) 1769752800 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 193 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) 1769752800 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 193 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) 1769752800 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 193 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) 1769752800 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) 1769752800 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
Some restaurants focus on serving delicious food while others focus on creating a fun atmosphere. Happy Talk Lounge manages to do both, serving up mouth-watering eats including fried chicken wings in… Read More
Looking for a way to relax and refresh on a rainy day? Head to Aloha Massage. This popular Princeville massage parlor will pamper you and make you wish for rain every day.
Read MoreWho says you miss out on some amenities with the small-town life? In Hanalei, you certainly won’t miss out on high-quality hair services, because you have the talented stylists of Styles Studio in… Read More
Nearly any Hawaiian beach has the makings of a romantic day, but Hanalei Bay is one of the best. Whether you and your sweetheart want to simply relax on the sand, learn to surf, or enjoy a kayaking… Read More
Princeville Resort is a vacation spot that has everything. It has a ranch for your inner adventurer, a spa for your pampering pleasure, fine dining for your taste buds’ delight, and more.
Read MoreThe Spot North Shore isn’t just a brunch spot - it’s the brunch spot in Princeville. It’s best known for its popular bowls, including hot breakfast bowls, acai bowls, and much more.
Read MoreHanalei Gourmet has an extensive menu that goes beyond deli items and includes full lunch and dinner menus with entrees and local delicacies. However, the extensive sandwich menu belies a solid deli… Read More
The Anaina Hou Community Park is a hotspot for families, couples, and friends in Kilauea who want somewhere to relax and have a great time. One of the most unique and beloved features of this part is… Read More
This wine bar on Kauai’s north shore specializes in wines from “small, esoteric wineries from around the world” and strives to provide customers with an authentic and unpretentious… Read More
Located in Old Town Kapa’a, Little Tsunami Tattoo brings anything but destruction to those who choose this parlor for their body art. Both of the talented artists at this tattoo shop create… 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 Princeville', '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) 22.21190071106, 'lng' => (float) -159.47900390625, 'latlng' => '22.21190071106,-159.47900390625', 'city' => 'Princeville', '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' => 'princeville-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
Princeville, Hawaii. Population for Princeville from the last gathering is 1698. You can view Princeville venues that host many Princeville HI events every year.
You can find a ton of properties for sale if you search the Princeville page on Zillow. Currently Princeville has an average listing price for homes for sale on the market of $1,070,523. More real estate facts about Princeville: The number of properties currently for sale in Princeville 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 Princeville 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 Princeville is $2,027,951. Interest rates for Princeville are at historic lows as well.
Princeville Hawaii has a latitude of 22.21190071106 and a longitude of -159.47900390625. 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":"hammond-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 5 | |
| 2 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 3 | db.towns.find( {"sef_url":"princeville-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 4 | db.pages.find( {"type":"town","slug":{"$in":["home"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 5 | db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | 0 | 4 | 1 | |
| 6 | db.ttd_towns.find( {"town_sef_url":"princeville-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 7 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 8 | db.modules.find( {"module_id":"1022"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 9 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 10 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-159.47900390625,22.21190071105957],"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(1769835456026)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1769835456026)","$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 | 17 | |
| 11 | db.ttd_towns.find( {"town_sef_url":"princeville-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | 0 | 0 | 1 | |
| 12 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 13 | db.events_cache.find( {"_id":"4e8e8fdc25595e1c147ca20f6afecdf5"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1770443999)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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 | 2 | |
| 15 | db.events_cache.count( {"_id":"4e8e8fdc25595e1c147ca20f6afecdf5"} ) | 0 | 0 | 1 | |
| 16 | db.events_cache.count( {"_id":"4e8e8fdc25595e1c147ca20f6afecdf5"} ) | 0 | 0 | 1 | |
| 17 | db.events_cache.insert( {"_id":"4e8e8fdc25595e1c147ca20f6afecdf5","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"has_next_page\":false}","modified":"MongoDate(0.07600000 1769835456)","created":"MongoDate(0.07600000 1769835456)"} , true) | 0 | 0 | 2 | |
| 18 | db.events_cache.find( {"_id":"999cd82873d2bf05f133e72ce542e438"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1770703199)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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 | 3 | |
| 20 | db.events_cache.count( {"_id":"999cd82873d2bf05f133e72ce542e438"} ) | 0 | 0 | 1 | |
| 21 | db.events_cache.count( {"_id":"999cd82873d2bf05f133e72ce542e438"} ) | 0 | 0 | 1 | |
| 22 | db.events_cache.insert( {"_id":"999cd82873d2bf05f133e72ce542e438","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"10\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"has_next_page\":false}","modified":"MongoDate(0.09500000 1769835456)","created":"MongoDate(0.09500000 1769835456)"} , true) | 0 | 0 | 1 | |
| 23 | db.events_cache.find( {"_id":"780ac9b1216ae19f16e125dfe89a07a3"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1772431199)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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 | 2 | |
| 25 | db.events_cache.count( {"_id":"780ac9b1216ae19f16e125dfe89a07a3"} ) | 0 | 0 | 1 | |
| 26 | db.events_cache.count( {"_id":"780ac9b1216ae19f16e125dfe89a07a3"} ) | 0 | 0 | 1 | |
| 27 | db.events_cache.insert( {"_id":"780ac9b1216ae19f16e125dfe89a07a3","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"30\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"has_next_page\":false}","modified":"MongoDate(0.11400000 1769835456)","created":"MongoDate(0.11400000 1769835456)"} , true) | 0 | 0 | 1 | |
| 28 | db.events_cache.find( {"_id":"9149575de61b7db045198bd11758a6f5"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1770443999)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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 | 2 | |
| 30 | db.events_cache.count( {"_id":"9149575de61b7db045198bd11758a6f5"} ) | 0 | 0 | 1 | |
| 31 | db.events_cache.count( {"_id":"9149575de61b7db045198bd11758a6f5"} ) | 0 | 0 | 1 | |
| 32 | db.events_cache.insert( {"_id":"9149575de61b7db045198bd11758a6f5","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"has_next_page\":false}","modified":"MongoDate(0.13000000 1769835456)","created":"MongoDate(0.13000000 1769835456)"} , true) | 0 | 0 | 1 | |
| 33 | db.events_cache.find( {"_id":"ee7eb9439a23a854f95f7d58a8f2cb05"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1771048799)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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 | 2 | |
| 35 | db.events_cache.count( {"_id":"ee7eb9439a23a854f95f7d58a8f2cb05"} ) | 0 | 0 | 1 | |
| 36 | db.events_cache.count( {"_id":"ee7eb9439a23a854f95f7d58a8f2cb05"} ) | 0 | 0 | 1 | |
| 37 | db.events_cache.insert( {"_id":"ee7eb9439a23a854f95f7d58a8f2cb05","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"has_next_page\":false}","modified":"MongoDate(0.14800000 1769835456)","created":"MongoDate(0.14800000 1769835456)"} , true) | 0 | 0 | 1 | |
| 38 | db.events_cache.find( {"_id":"ca6fdc895ed07f9a69c38aa2e8e51ce9"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 39 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1770098399)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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 | 1 | |
| 40 | db.events_cache.count( {"_id":"ca6fdc895ed07f9a69c38aa2e8e51ce9"} ) | 0 | 0 | 1 | |
| 41 | db.events_cache.count( {"_id":"ca6fdc895ed07f9a69c38aa2e8e51ce9"} ) | 0 | 0 | 1 | |
| 42 | db.events_cache.insert( {"_id":"ca6fdc895ed07f9a69c38aa2e8e51ce9","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"has_next_page\":false}","modified":"MongoDate(0.16300000 1769835456)","created":"MongoDate(0.16300000 1769835456)"} , true) | 0 | 0 | 1 | |
| 43 | db.events_cache.find( {"_id":"231e2dd77f67dd7d609c48f42dbb58d5"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 44 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1772431199)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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 | 0 | 1 | |
| 45 | db.events_cache.count( {"_id":"231e2dd77f67dd7d609c48f42dbb58d5"} ) | 0 | 0 | 1 | |
| 46 | db.events_cache.count( {"_id":"231e2dd77f67dd7d609c48f42dbb58d5"} ) | 0 | 0 | 1 | |
| 47 | db.events_cache.insert( {"_id":"231e2dd77f67dd7d609c48f42dbb58d5","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"has_next_page\":false}","modified":"MongoDate(0.18100000 1769835456)","created":"MongoDate(0.18100000 1769835456)"} , true) | 0 | 0 | 1 | |
| 48 | db.events_cache.find( {"_id":"f2d2959cc09c06c81bcbd1129cac3030"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 49 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1770271199)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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 | 2 | |
| 50 | db.events_cache.count( {"_id":"f2d2959cc09c06c81bcbd1129cac3030"} ) | 0 | 0 | 1 | |
| 51 | db.events_cache.count( {"_id":"f2d2959cc09c06c81bcbd1129cac3030"} ) | 0 | 0 | 1 | |
| 52 | db.events_cache.insert( {"_id":"f2d2959cc09c06c81bcbd1129cac3030","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"has_next_page\":false}","modified":"MongoDate(0.20100000 1769835456)","created":"MongoDate(0.20100000 1769835456)"} , true) | 0 | 0 | 1 | |
| 53 | db.events_cache.find( {"_id":"acbec23cbc4557736e180e375e262cf8"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 3 | |
| 54 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1771135199)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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 | 3 | |
| 55 | db.events_cache.count( {"_id":"acbec23cbc4557736e180e375e262cf8"} ) | 0 | 0 | 1 | |
| 56 | db.events_cache.count( {"_id":"acbec23cbc4557736e180e375e262cf8"} ) | 0 | 0 | 1 | |
| 57 | db.events_cache.insert( {"_id":"acbec23cbc4557736e180e375e262cf8","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"15\",\"days\":\"15\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"has_next_page\":false}","modified":"MongoDate(0.22400000 1769835456)","created":"MongoDate(0.22400000 1769835456)"} , true) | 0 | 0 | 1 | |
| 58 | db.events_cache.find( {"_id":"0485b44ec8ba5ebf1bed74d8c5139dfd"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 59 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1771135199)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],0.43478260869565216]}}}, ["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 | 3 | |
| 60 | db.events_cache.count( {"_id":"0485b44ec8ba5ebf1bed74d8c5139dfd"} ) | 0 | 0 | 1 | |
| 61 | db.events_cache.count( {"_id":"0485b44ec8ba5ebf1bed74d8c5139dfd"} ) | 0 | 0 | 1 | |
| 62 | db.events_cache.insert( {"_id":"0485b44ec8ba5ebf1bed74d8c5139dfd","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"30\",\"days\":\"15\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"has_next_page\":false}","modified":"MongoDate(0.24400000 1769835456)","created":"MongoDate(0.24400000 1769835456)"} , true) | 0 | 0 | 1 | |
| 63 | db.events_cache.find( {"_id":"e5a6c388bc57a4887ce200245b19144c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 64 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1771135199)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],0.6521739130434783]}}}, ["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 | 3 | |
| 65 | db.events_cache.count( {"_id":"e5a6c388bc57a4887ce200245b19144c"} ) | 0 | 0 | 1 | |
| 66 | db.events_cache.count( {"_id":"e5a6c388bc57a4887ce200245b19144c"} ) | 0 | 0 | 1 | |
| 67 | db.events_cache.insert( {"_id":"e5a6c388bc57a4887ce200245b19144c","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"45\",\"days\":\"15\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"has_next_page\":false}","modified":"MongoDate(0.26400000 1769835456)","created":"MongoDate(0.26400000 1769835456)"} , true) | 0 | 0 | 1 | |
| 68 | db.events_cache.find( {"_id":"7e6e2e2ec3f547e208a9ff9c289e39ec"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 69 | db.events.find( {"_id":{"$in":[ObjectId ("68ef05a0c3af739f254c07fe")]}}, [] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | 0 | 1 | 1 | |
| 70 | db.events_cache.find( {"_id":"dc6f7332b3af5897bb5fb5e9ba17ea2a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 71 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1771653599)"},"event_id":{"$nin":[76238167]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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 | 2 | 39 | |
| 72 | db.events_cache.count( {"_id":"dc6f7332b3af5897bb5fb5e9ba17ea2a"} ) | 0 | 0 | 1 | |
| 73 | db.events_cache.count( {"_id":"dc6f7332b3af5897bb5fb5e9ba17ea2a"} ) | 0 | 0 | 1 | |
| 74 | db.events_cache.insert( {"_id":"dc6f7332b3af5897bb5fb5e9ba17ea2a","town_sef_url":"princeville-hi","data_key":["68dc90a1c3af739f25fd395f","68dc90a1c3af739f25fd3cb8"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-159.47900390625,22.21190071105957],\"has_next_page\":false}","modified":"MongoDate(0.36100000 1769835456)","created":"MongoDate(0.36100000 1769835456)"} , true) | 0 | 0 | 1 | |
| 75 | db.events_cache.find( {"_id":"96437a4cd2cfe97da5ce3709f3fd4cdd"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 76 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1771653599)"},"event_id":{"$nin":[76238167,76199100]},"tags":"music","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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 | 8 | |
| 77 | db.events_cache.count( {"_id":"96437a4cd2cfe97da5ce3709f3fd4cdd"} ) | 0 | 0 | 1 | |
| 78 | db.events_cache.count( {"_id":"96437a4cd2cfe97da5ce3709f3fd4cdd"} ) | 0 | 0 | 1 | |
| 79 | db.events_cache.insert( {"_id":"96437a4cd2cfe97da5ce3709f3fd4cdd","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-159.47900390625,22.21190071105957],\"has_next_page\":false}","modified":"MongoDate(0.39300000 1769835456)","created":"MongoDate(0.39300000 1769835456)"} , true) | 0 | 0 | 1 | |
| 80 | db.places.find( {"geo":{"$near":[-159.47900390625,22.21190071105957],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | 0 | 11 | 2 | |
| 81 | 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-fried-chicken-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/fried-chicken\/\" target=\"_blank\">10 Best Fried Chicken Joints in Hawaii for 2026!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/fried-chicken\/\" target=\"_blank\">Happy Talk Lounge, Princeville, 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\">Some restaurants focus on serving delicious food while others focus on creating a fun atmosphere. Happy Talk Lounge manages to do both, serving up mouth-watering eats including fried chicken wings in… <a href=\"https:\/\/bestthingshi.com\/fried-chicken\/\" 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-rainy-day-activities-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/rainy-day-thingstodo\/\" target=\"_blank\">10 Best Rainy Day Activities 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\/rainy-day-thingstodo\/\" target=\"_blank\">Aloha Massage, Princeville, 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\"><p>Looking for a way to relax and refresh on a rainy day? Head to Aloha Massage. This popular Princeville massage parlor will pamper you and make you wish for rain every day.<\/p> <a href=\"https:\/\/bestthingshi.com\/rainy-day-thingstodo\/\" 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-hair-salons-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/hair-salons\/\" target=\"_blank\">10 Best Hair Salons 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\/hair-salons\/\" target=\"_blank\">Styles Studio, Hanalei, 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\">Who says you miss out on some amenities with the small-town life? In Hanalei, you certainly won\u2019t miss out on high-quality hair services, because you have the talented stylists of Styles Studio in… <a href=\"https:\/\/bestthingshi.com\/hair-salons\/\" 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-romantic-places-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/romantic-places\/\" target=\"_blank\">10 Most Romantic 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\/romantic-places\/\" target=\"_blank\">Hanalei Bay, Hanalei, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,community-life-bt,community-life-p300,edited-shannen,valentines-day,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">Nearly any Hawaiian beach has the makings of a romantic day, but Hanalei Bay is one of the best. Whether you and your sweetheart want to simply relax on the sand, learn to surf, or enjoy a kayaking… <a href=\"https:\/\/bestthingshi.com\/romantic-places\/\" 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\">Princeville Resort, Princeville, 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\"><p>Princeville Resort is a vacation spot that has everything. It has a ranch for your inner adventurer, a spa for your pampering pleasure, fine dining for your taste buds\u2019 delight, and more.<\/p> <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-brunch-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\/brunch-spots\/\" target=\"_blank\">10 Best Brunch 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\/brunch-spots\/\" target=\"_blank\">The Spot North Shore, Princeville, 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\"><p>The Spot North Shore isn\u2019t just a brunch spot - it\u2019s the brunch spot in Princeville. It\u2019s best known for its popular bowls, including hot breakfast bowls, acai bowls, and much more.<\/p> <a href=\"https:\/\/bestthingshi.com\/brunch-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-delis-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/delis\/\" target=\"_blank\">10 Best Delis 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\/delis\/\" target=\"_blank\">Hanalei Gourmet, Hanalei, 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\">Hanalei Gourmet has an extensive menu that goes beyond deli items and includes full lunch and dinner menus with entrees and local delicacies. However, the extensive sandwich menu belies a solid deli… <a href=\"https:\/\/bestthingshi.com\/delis\/\" 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\">Kauai Miniature Golf and Botanical Garden, Kilauea, 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 Anaina Hou Community Park is a hotspot for families, couples, and friends in Kilauea who want somewhere to relax and have a great time. One of the most unique and beloved features of this part is… <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-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\">Palate Wine Bar, Kilauea, 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\">This wine bar on Kauai’s north shore specializes in wines from “small, esoteric wineries from around the world” and strives to provide customers with an authentic and unpretentious… <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-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\">Little Tsunami Tattoo and Art Studio, Kapa\u2019a, 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\">Located in Old Town Kapa\u2019a, Little Tsunami Tattoo brings anything but destruction to those who choose this parlor for their body art. Both of the talented artists at this tattoo shop create… <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<\/div>\n<\/div>\n\n\n","town_sef_url":"princeville-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_category\",\"radius\":\"75\",\"days\":\"30\",\"ttl\":\"8\",\"isempty\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/arts-2.jpg\"}","expiration":1769864256,"type":"Event","id":76238167,"title":"Dusty Slay: The Neighborhood Guy","url":"\/event\/dusty-slay-the-neighborhood-guy-2026-01-30-tm-charleston-wv.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/fb7\/7676e48b-a052-44f1-b0de-88945057ffb7_SOURCE"},{"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":1769849856,"type":"Event","id":76199100,"title":"Hawaii Rainbow Warriors Mens Basketball vs. UC San Diego Tritons Mens Basketball","url":"\/event\/hawaii-rainbow-warriors-mens-basketball-vs-uc-san-diego-tritons-mens-basketball-2026-02-07-tm-hanamaulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dbimages\/29516a.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":1769864256,"type":"Place","id":1680284,"title":"Ohana Fit Fest","url":"\/place\/ohana-fit-fest-hanalei-hi.html","image_url":"https:\/\/cdn-p300.americantowns.com\/img\/generic-icon.jpg"}],"modified":"MongoDate(0.40400000 1769835456)","created":"MongoDate(0.40400000 1769835456)","_id":ObjectId ("697d8bc036cd71988606a6b0")} , true) | 0 | 0 | 1 | |
| 82 | db.events_cache.find( {"_id":"3ba6068158a87f013909945393469eeb"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 83 | db.events_radius_cache.find( {"_id":"ea6f640587a9eb6285b33d5905bb7b2a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 84 | db.events.count( {"address.town_sef_url":"princeville-hi","start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1770357600)"}} ) | 0 | 0 | 1 | |
| 85 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1770616800)"}} ) | 0 | 0 | 19 | |
| 86 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1770616800)"}} ) | 0 | 0 | 17 | |
| 87 | db.events_radius_cache.count( {"_id":"ea6f640587a9eb6285b33d5905bb7b2a"} ) | 0 | 0 | 1 | |
| 88 | db.events_radius_cache.count( {"_id":"ea6f640587a9eb6285b33d5905bb7b2a"} ) | 0 | 0 | 1 | |
| 89 | db.events_radius_cache.insert( {"_id":"ea6f640587a9eb6285b33d5905bb7b2a","radius":25,"modified":"MongoDate(0.46700000 1769835456)","created":"MongoDate(0.46700000 1769835456)"} , true) | 0 | 0 | 1 | |
| 90 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)"},"event_id":{"$nin":[76238167,76199100]},"geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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 | 180 | |
| 91 | db.events_cache.count( {"_id":"3ba6068158a87f013909945393469eeb"} ) | 0 | 0 | 1 | |
| 92 | db.events_cache.count( {"_id":"3ba6068158a87f013909945393469eeb"} ) | 0 | 0 | 1 | |
| 93 | db.events_cache.insert( {"_id":"3ba6068158a87f013909945393469eeb","town_sef_url":"princeville-hi","data_key":["689965cffb5e4bed1f95411f","68dc90a1c3af739f25fd3cb8","68dc90a1c3af739f25fd3dbe","6944b712de4ae56f5ab971a4","68dc90a1c3af739f25fd41ac"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Princeville\",\"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\":22.21190071105957,\"lng\":-159.47900390625,\"latlng\":\"22.21190071106,-159.47900390625\",\"city\":\"Princeville\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.72000000 1769835456)","created":"MongoDate(0.72000000 1769835456)"} , true) | 0 | 0 | 1 | |
| 94 | db.news.find( {"broadcast":{"$in":["usa","princeville-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 | 2 | |
| 95 | db.places.find( {"address.town_sef_url":"princeville-hi","group_id":{"$nin":[1680284]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | 0 | 6 | 1 | |
| 96 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | 0 | 0 | 1 | |
| 97 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | 0 | 40 | 1 | |
| 98 | db.towns.find( {"sef_url":"princeville-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 99 | db.tokens.find( {"sef_url":{"$in":["usa","hi","kauai-county-hi","princeville-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | 0 | 4 | 1 | |
| 100 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 101 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 102 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 103 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 104 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 105 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 106 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 |

