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) 1766124000 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) 1766124000 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) 1766124000 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) 1766124000 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) 1766124000 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) 1766124000 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) 1766124000 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) 1766124000 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
Gaslamp has taken Kailua’s nightlife by storm. It’s the town’s only hidden speakeasy and it does not disappoint. Located inside the Kailua Town Pub and Grill, Gaslamp is known for… Read More
You can get quality piercings you’ll be able to wear for a lifetime at Loyalty Tattoo. Along with custom tattoos, Loyalty Tattoo offers a range of body piercings as well as custom body… Read More
Boots and Kimo’s is the original home of the macadamia nut pancake, making it a must-stop when seeking out the best pancakes on Hawaii. The pancakes here are thick and fluffy and topped with an… Read More
Give yourself a treat with a luxe night out at Baci Bistro. This upscale Italian restaurant has a well-curated menu of all your Italian favorites, but be sure to leave some room for its legendary… Read More
Open for more than 10 years, 808 Skate is owned and run by skaters. They offer the best selection of skateboarding equipment on the island and in their online shop. Decks, wheels, trucks, and… 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
Get out on the water in your own kayak with a two hour (longer options are available) guided tour. This relaxed time on the water will take you past sea turtle feeding grounds, near bird nesting… Read More
This shop has two locations on the big island and has been in business for almost 30 years. The first shop carries everything from European art glass to collectible figurines and pottery for those… Read More
When you think of Waikiki Beach, surfing, not fine dining, generally comes to mind. This restaurant changes that mindset. It is an award-winning AAA Five-Diamond and Forbes 5 Star restaurant famous… Read More
If you’re a local looking for consistently delicious Thai food, Chiang Mai is the local’s favorite. Customers rave about the variety of tasty dishes–Pad Kee Mao, Princess Curry, and… 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 Mcbh Kaneohe Bay', '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.388479232788, 'lng' => (float) -157.7550201416, 'latlng' => '21.388479232788,-157.7550201416', 'city' => 'Mcbh Kaneohe Bay', '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' => 'mcbh-kaneohe-bay-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
Let everyone know about your organization. Click here to add it now.
From alerting folks to a meeting about an important town issue, the next gathering of your book group, a real estate open house or upcoming tag sale, make this your first stop in getting the word out
Mcbh Kaneohe Bay, Hawaii. You can view Mcbh Kaneohe Bay venues that host many Mcbh Kaneohe Bay HI events every year.
You can find a ton of properties for sale if you search the Mcbh Kaneohe Bay page on Zillow. Currently Mcbh Kaneohe Bay has an average listing price for homes for sale on the market of $895,501. More real estate facts about Mcbh Kaneohe Bay: The number of properties currently for sale in Mcbh Kaneohe Bay 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 Mcbh Kaneohe Bay 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 Mcbh Kaneohe Bay is $1,318,262. Interest rates for Mcbh Kaneohe Bay are at historic lows as well.
Mcbh Kaneohe Bay Hawaii has a latitude of 21.388479232788 and a longitude of -157.7550201416. 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":"ridgeway-wv"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 3 | |
| 2 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 3 | db.towns.find( {"sef_url":"mcbh-kaneohe-bay-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 | 3 | |
| 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":"mcbh-kaneohe-bay-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 | 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.75502014160156,21.388479232788086],"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(1766181549466)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1766181549466)","$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 | 86 | |
| 11 | db.ttd_towns.find( {"town_sef_url":"mcbh-kaneohe-bay-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 | 58 | |
| 13 | db.events_cache.find( {"_id":"67054afddcc3bebdef73c7454b8edaf6"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 23 | |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766124000)","$lt":"MongoDate(0.00000000 1766815199)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-157.75502014160156,21.388479232788086],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 | 173 | |
| 15 | db.events_cache.count( {"_id":"67054afddcc3bebdef73c7454b8edaf6"} ) | 0 | 0 | 43 | |
| 16 | db.events_cache.count( {"_id":"67054afddcc3bebdef73c7454b8edaf6"} ) | 0 | 0 | 3 | |
| 17 | db.events_cache.insert( {"_id":"67054afddcc3bebdef73c7454b8edaf6","town_sef_url":"mcbh-kaneohe-bay-hi","data_key":["68b8f82bc3af739f2556844d"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-157.75502014160156,21.388479232788086],\"has_next_page\":true}","modified":"MongoDate(0.34200000 1766181550)","created":"MongoDate(0.34200000 1766181550)"} , true) | 0 | 0 | 2 | |
| 18 | db.events_cache.find( {"_id":"ea8b775c5dcc6b7729ac05b0a1919969"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 6 | |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766124000)","$lt":"MongoDate(0.00000000 1766815199)"},"event_id":{"$nin":[76119642]},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.75502014160156,21.388479232788086],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 | 16 | |
| 20 | db.events_cache.count( {"_id":"ea8b775c5dcc6b7729ac05b0a1919969"} ) | 0 | 0 | 6 | |
| 21 | db.events_cache.count( {"_id":"ea8b775c5dcc6b7729ac05b0a1919969"} ) | 0 | 0 | 12 | |
| 22 | db.events_cache.insert( {"_id":"ea8b775c5dcc6b7729ac05b0a1919969","town_sef_url":"mcbh-kaneohe-bay-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-157.75502014160156,21.388479232788086],\"has_next_page\":false}","modified":"MongoDate(0.44200000 1766181550)","created":"MongoDate(0.44200000 1766181550)"} , true) | 0 | 0 | 5 | |
| 23 | db.events_cache.find( {"_id":"c5a5a7c4ed3f30a5f8990d773bcd174a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 2 | |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766124000)","$lt":"MongoDate(0.00000000 1767419999)"},"event_id":{"$nin":[76119642]},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.75502014160156,21.388479232788086],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 | 10 | |
| 25 | db.events_cache.count( {"_id":"c5a5a7c4ed3f30a5f8990d773bcd174a"} ) | 0 | 0 | 1 | |
| 26 | db.events_cache.count( {"_id":"c5a5a7c4ed3f30a5f8990d773bcd174a"} ) | 0 | 0 | 1 | |
| 27 | db.events_cache.insert( {"_id":"c5a5a7c4ed3f30a5f8990d773bcd174a","town_sef_url":"mcbh-kaneohe-bay-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-157.75502014160156,21.388479232788086],\"has_next_page\":false}","modified":"MongoDate(0.49000000 1766181550)","created":"MongoDate(0.49000000 1766181550)"} , true) | 0 | 0 | 2 | |
| 28 | db.events_cache.find( {"_id":"1916ba05c886d663fbcf73df9e33ccca"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766124000)","$lt":"MongoDate(0.00000000 1766469599)"},"event_id":{"$nin":[76119642]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-157.75502014160156,21.388479232788086],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 | |
| 30 | db.events_cache.count( {"_id":"1916ba05c886d663fbcf73df9e33ccca"} ) | 0 | 0 | 1 | |
| 31 | db.events_cache.count( {"_id":"1916ba05c886d663fbcf73df9e33ccca"} ) | 0 | 0 | 1 | |
| 32 | db.events_cache.insert( {"_id":"1916ba05c886d663fbcf73df9e33ccca","town_sef_url":"mcbh-kaneohe-bay-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-157.75502014160156,21.388479232788086],\"has_next_page\":false}","modified":"MongoDate(0.51300000 1766181550)","created":"MongoDate(0.51300000 1766181550)"} , true) | 0 | 0 | 5 | |
| 33 | db.events_cache.find( {"_id":"43b9b94436473abde634b5518e151c9e"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766124000)","$lt":"MongoDate(0.00000000 1768802399)"},"event_id":{"$nin":[76119642]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-157.75502014160156,21.388479232788086],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 | 2 | |
| 35 | db.events_cache.count( {"_id":"43b9b94436473abde634b5518e151c9e"} ) | 0 | 0 | 1 | |
| 36 | db.events_cache.count( {"_id":"43b9b94436473abde634b5518e151c9e"} ) | 0 | 0 | 1 | |
| 37 | db.events_cache.insert( {"_id":"43b9b94436473abde634b5518e151c9e","town_sef_url":"mcbh-kaneohe-bay-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-157.75502014160156,21.388479232788086],\"has_next_page\":false}","modified":"MongoDate(0.54000000 1766181550)","created":"MongoDate(0.54000000 1766181550)"} , true) | 0 | 0 | 3 | |
| 38 | db.events_cache.find( {"_id":"85ffd2e193200bd0ead23a2bfaaacf62"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 39 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766124000)","$lt":"MongoDate(0.00000000 1766642399)"},"event_id":{"$nin":[76119642]},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-157.75502014160156,21.388479232788086],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 | 2 | 28 | |
| 40 | db.events_cache.count( {"_id":"85ffd2e193200bd0ead23a2bfaaacf62"} ) | 0 | 0 | 1 | |
| 41 | db.events_cache.count( {"_id":"85ffd2e193200bd0ead23a2bfaaacf62"} ) | 0 | 0 | 1 | |
| 42 | db.events_cache.insert( {"_id":"85ffd2e193200bd0ead23a2bfaaacf62","town_sef_url":"mcbh-kaneohe-bay-hi","data_key":["6900aa91d749a9cd1b06ef5f"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-157.75502014160156,21.388479232788086],\"has_next_page\":true}","modified":"MongoDate(0.59500000 1766181550)","created":"MongoDate(0.59500000 1766181550)"} , true) | 0 | 0 | 1 | |
| 43 | db.events_cache.find( {"_id":"95dfe46078c186c5ce696de75d61ac87"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 2 | |
| 44 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766124000)","$lt":"MongoDate(0.00000000 1768024799)"},"event_id":{"$nin":[76119642,76281187]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-157.75502014160156,21.388479232788086],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 | 41 | 51 | |
| 45 | db.events_cache.count( {"_id":"95dfe46078c186c5ce696de75d61ac87"} ) | 0 | 0 | 3 | |
| 46 | db.events_cache.count( {"_id":"95dfe46078c186c5ce696de75d61ac87"} ) | 0 | 0 | 8 | |
| 47 | db.events_cache.insert( {"_id":"95dfe46078c186c5ce696de75d61ac87","town_sef_url":"mcbh-kaneohe-bay-hi","data_key":["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","6895714afb5e4bed1fd772c6","691d2a15de4ae56f5a437536","69251313de4ae56f5a252567","690c0698de4ae56f5a9c0d61","690c0698de4ae56f5a9c0d6a","690ab51cde4ae56f5a8411a1","68f84020c3af739f25dff23c","69251313de4ae56f5a2525d1","68f84020c3af739f25dff28f"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-157.75502014160156,21.388479232788086],\"has_next_page\":false}","modified":"MongoDate(0.73700000 1766181550)","created":"MongoDate(0.73800000 1766181550)"} , true) | 0 | 0 | 3 | |
| 48 | db.events_cache.find( {"_id":"c9bcc9f5536eb578864f68b8f95bd27a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 3 | |
| 49 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766124000)","$lt":"MongoDate(0.00000000 1768024799)"},"event_id":{"$nin":[76119642,76281187,76119643]},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.75502014160156,21.388479232788086],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 | 19 | |
| 50 | db.events_cache.count( {"_id":"c9bcc9f5536eb578864f68b8f95bd27a"} ) | 0 | 0 | 22 | |
| 51 | db.events_cache.count( {"_id":"c9bcc9f5536eb578864f68b8f95bd27a"} ) | 0 | 0 | 1 | |
| 52 | db.events_cache.insert( {"_id":"c9bcc9f5536eb578864f68b8f95bd27a","town_sef_url":"mcbh-kaneohe-bay-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-157.75502014160156,21.388479232788086],\"has_next_page\":false}","modified":"MongoDate(0.84500000 1766181550)","created":"MongoDate(0.84500000 1766181550)"} , true) | 0 | 0 | 2 | |
| 53 | db.places.find( {"geo":{"$near":[-157.75502014160156,21.388479232788086],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | 0 | 51 | 4 | |
| 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-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\">Gaslamp, Kailua, 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\">Gaslamp has taken Kailua’s nightlife by storm. It’s the town’s only hidden speakeasy and it does not disappoint. Located inside the Kailua Town Pub and Grill, Gaslamp is known for… <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-piercing-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\/piercing-shops\/\" target=\"_blank\">10 Best Piercing Shops in Hawaii<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/piercing-shops\/\" target=\"_blank\">Loyalty Tattoo, Kailua, 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\">You can get quality piercings you’ll be able to wear for a lifetime at Loyalty Tattoo. Along with custom tattoos, Loyalty Tattoo offers a range of body piercings as well as custom body… <a href=\"https:\/\/bestthingshi.com\/piercing-shops\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-pancakes-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/pancakes\/\" target=\"_blank\">The 8 Best Places for Pancakes 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\/pancakes\/\" target=\"_blank\">Boots and Kimo\u2019s, Kailua, 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\">Boots and Kimo’s is the original home of the macadamia nut pancake, making it a must-stop when seeking out the best pancakes on Hawaii. The pancakes here are thick and fluffy and topped with an… <a href=\"https:\/\/bestthingshi.com\/pancakes\/\" 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-italian-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\/italian-restaurants\/\" target=\"_blank\">9 Best Italian 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\/italian-restaurants\/\" target=\"_blank\">Baci Bistro, Kailua, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-chira,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Give yourself a treat with a luxe night out at Baci Bistro. This upscale Italian restaurant has a well-curated menu of all your Italian favorites, but be sure to leave some room for its legendary… <a href=\"https:\/\/bestthingshi.com\/italian-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-skate-shops-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/skate-shops\/\" target=\"_blank\">The 9 Best Skate Shops in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/skate-shops\/\" target=\"_blank\">808 Skate, Kailua, 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\">Open for more than 10 years, 808 Skate is owned and run by skaters. They offer the best selection of skateboarding equipment on the island and in their online shop. Decks, wheels, trucks, and… <a href=\"https:\/\/bestthingshi.com\/skate-shops\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-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-guided-tours-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/guided-tours\/\" target=\"_blank\">The 10 Best Guided Tours 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\/guided-tours\/\" target=\"_blank\">Kailua Beach Adventures, Kailua, 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\">Get out on the water in your own kayak with a two hour (longer options are available) guided tour. This relaxed time on the water will take you past sea turtle feeding grounds, near bird nesting… <a href=\"https:\/\/bestthingshi.com\/guided-tours\/\" 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-antique-stores-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/antique-stores\/\" target=\"_blank\">7 Best Antique Stores 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\/antique-stores\/\" target=\"_blank\">Ali\u2019i Antiques, Kailua, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">This shop has two locations on the big island and has been in business for almost 30 years. The first shop carries everything from European art glass to collectible figurines and pottery for those… <a href=\"https:\/\/bestthingshi.com\/antique-stores\/\" 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-french-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\/french-restaurants\/\" target=\"_blank\">7 Best French 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\/french-restaurants\/\" target=\"_blank\">La Mer, Honolulu, Oahu, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-shannen,edited-cynthia,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">When you think of Waikiki Beach, surfing, not fine dining, generally comes to mind. This restaurant changes that mindset. It is an award-winning AAA Five-Diamond and Forbes 5 Star restaurant famous… <a href=\"https:\/\/bestthingshi.com\/french-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-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\">Chiang Mai Thai Cuisine, Honolulu, 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\">If you’re a local looking for consistently delicious Thai food, Chiang Mai is the local’s favorite. Customers rave about the variety of tasty dishes–Pad Kee Mao, Princess Curry, and… <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<\/div>\n<\/div>\n\n\n","town_sef_url":"mcbh-kaneohe-bay-hi","title":"Hiking!","subtitle":"Maps, directions and reviews for hiking around {local_city_state}!","image_url":"{\"0\":{\"content_type\":\"movie\",\"movie\":\"\/movie\/black-panther-wakanda-forever-297863\/\",\"title\":\"Black Panther: Wakanda Forever\",\"thumbnail\":\"https:\/\/www.movienewsletters.net\/photos\/297863R4.jpg\"},\"1\":{\"content_type\":\"event_tag\",\"searchtag\":\"ticketmaster","url":"\/{town_sef_url}\/hiking\/","slots":[{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"ttl\":\"1\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-1.jpg\"}","expiration":1766185149,"type":"Event","id":76119642,"title":"Jake\u00a0Shimabukuro's Holidays In Hawai\u02bbi","url":"\/event\/jake-shimabukuros-holidays-in-hawaii-2025-12-19-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/796\/66db7215-d93a-445f-a780-c3ec70626796_SOURCE"},{"rule":"{\"content_type\":\"event_category\",\"radius\":\"10\",\"days\":\"5\",\"ttl\":\"1\",\"isempty\":1,\"event_category\":\"arts-and-entertainment\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/festivals-1.jpg\"}","expiration":1766185150,"type":"Event","id":76281187,"title":"Fort Street Mall Open Market","url":"\/event\/fort-street-mall-open-market-2025-12-19-honolulu-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-craft-fair-show-1.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":1766195950,"type":"Event","id":76119643,"title":"Jake\u00a0Shimabukuro's Holidays In Hawai\u02bbi","url":"\/event\/jake-shimabukuros-holidays-in-hawaii-1-2025-12-19-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/796\/66db7215-d93a-445f-a780-c3ec70626796_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":1766210350,"type":"Place","id":2010703,"title":"The Island Springtacular Craft and Gift Fair","url":"\/place\/the-island-springtacular-craft-and-gift-fair-kaneohe-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-craft-fair-show-2.jpg"}],"modified":"MongoDate(0.86700000 1766181550)","created":"MongoDate(0.86700000 1766181550)","_id":ObjectId ("6945caae412ee109a506ba23")} , true) | 0 | 0 | 1 | |
| 55 | db.events_cache.find( {"_id":"392f79d5dacb4a6b9a0c0007e91157dd"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 56 | db.events_radius_cache.find( {"_id":"93223d51dff2f0402d3098dec21cd8df"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 57 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766124000)"},"event_id":{"$nin":[76119642,76281187,76119643]},"geo":{"$geoWithin":{"$center":[[-157.75502014160156,21.388479232788086],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 | 115 | |
| 58 | db.events_cache.count( {"_id":"392f79d5dacb4a6b9a0c0007e91157dd"} ) | 0 | 0 | 1 | |
| 59 | db.events_cache.count( {"_id":"392f79d5dacb4a6b9a0c0007e91157dd"} ) | 0 | 0 | 1 | |
| 60 | db.events_cache.insert( {"_id":"392f79d5dacb4a6b9a0c0007e91157dd","town_sef_url":"mcbh-kaneohe-bay-hi","data_key":["685913a4fb5e4bed1fd995a7","687f4f92fb5e4bed1f73d5fd","69251312de4ae56f5a2520f5","685a658dfb5e4bed1f6558bd","6900a3ef3af6aa547c08399f"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Mcbh Kaneohe Bay\",\"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.388479232788086,\"lng\":-157.75502014160156,\"latlng\":\"21.388479232788,-157.7550201416\",\"city\":\"Mcbh Kaneohe Bay\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.02000000 1766181551)","created":"MongoDate(0.02000000 1766181551)"} , true) | 0 | 0 | 1 | |
| 61 | db.news.find( {"broadcast":{"$in":["usa","mcbh-kaneohe-bay-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 | 11 | |
| 62 | db.places.find( {"address.town_sef_url":"mcbh-kaneohe-bay-hi","group_id":{"$nin":[2010703]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | 0 | 0 | 1 | |
| 63 | db.modules.find( {"name":"AT - Organization Empty"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 64 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | 0 | 0 | 6 | |
| 65 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | 0 | 40 | 1 | |
| 66 | db.towns.find( {"sef_url":"mcbh-kaneohe-bay-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 67 | db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","mcbh-kaneohe-bay-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | 0 | 3 | 1 | |
| 68 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 | |
| 69 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 | |
| 70 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 | |
| 71 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 | |
| 72 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 73 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 74 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 |



