OnStage Hawai'i

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349946,
      "site_id": 10,
      "cat_id": 61,
      "priority": 0,
      "url": "https://onstagehi.com",
      "title": "OnStage Hawai'i",
      "description": "OnStage Hawai'i is a premier event production company serving all Hawaiian islands with over 40 years of industry expertise. Our seasoned team specializes in delivering comprehensive turnkey solutions for events of any scale, from intimate gatherings to large-scale concerts and corporate conventions. We create immersive experiences through state-of-the-art LED walls, advanced lighting systems, and sophisticated staging equipment, much of which is exclusive to our clients before reaching the open market. As your dedicated event partner, we transform ordinary occasions into extraordinary experiences, providing not just equipment rentals but complete production solutions backed by our team's technical expertise and commitment to excellence.\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100641,
      "approve_dt": "2025-09-15T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-09-02T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 11,
      "city_id": 4729,
      "ltop": "",
      "facebook": "",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 5607,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "3ff2f3ce-87f6-11f0-bb42-b66e99367f32",
      "subdate": "Sep 02, 2025",
      "subcategory": "Wedding Music",
      "request_types": "",
      "visitcount": 81
   },
   "visits": {
      "storefront": 81,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 19,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "OnStage Hawai'i is a premier event production company serving all Hawaiian islands with over 40 years of industry expertise. Our seasoned team specializes in delivering comprehensive turnkey solutions for events of any scale, from intimate gatherings to large-scale concerts and corporate conventions. We create immersive experiences through state-of-the-art LED walls, advanced lighting systems, and sophisticated staging equipment, much of which is exclusive to our clients before reaching the open market. As your dedicated event partner, we transform ordinary occasions into extraordinary experiences, providing not just equipment rentals but complete production solutions backed by our team's technical expertise and commitment to excellence.\n",
      "service1": "Event Production Company In Hawaii",
      "service2": " Audio Visual Services In Hawaii",
      "service3": " Computer-aided Design For Events (Cad) In Hawaii",
      "service4": " Concert And Event Equipment In Hawaii",
      "service5": " Event Management In Hawaii",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-09-02 12:13:35"
   },
   "location": {
      "uuid": "3ff2f3ce-87f6-11f0-bb42-b66e99367f32",
      "link_id": 349946,
      "account_id": 100641,
      "company": "OnStage Hawai'i",
      "sid": 10,
      "country": 277,
      "countrycode": "US",
      "state": 11,
      "city": "4729",
      "zip": "96701",
      "address": "99-994 Iwaena St, # 101",
      "phone": "808-570-0088",
      "fax": null,
      "email": "onstagehawaii@outlook.com",
      "name": "OnStage Hawai'i",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Aiea",
      "statename": "Hawaii"
   },
   "socialmedia": [
      {
         "title": "Facebook",
         "ptype_id": 29,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Instagram",
         "ptype_id": 30,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Youtube",
         "ptype_id": 31,
         "dbtable": "links_socialmedia",
         "item": "Youtube Video",
         "cnt": null
      },
      {
         "title": "LinkedIn",
         "ptype_id": 32,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "TikTok",
         "ptype_id": 33,
         "dbtable": "links_socialmedia",
         "item": "Videos",
         "cnt": null
      },
      {
         "title": "Twitter",
         "ptype_id": 34,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Reddit",
         "ptype_id": 37,
         "dbtable": "links_socialmedia",
         "item": "Reddit",
         "cnt": null
      },
      {
         "title": "SnapChat",
         "ptype_id": 38,
         "dbtable": "links_socialmedia",
         "item": "SnapChat",
         "cnt": null
      }
   ],
   "promos": [
      {
         "item": "article",
         "cnt": 0
      },
      {
         "item": "video",
         "cnt": 0
      },
      {
         "item": "product",
         "cnt": 0
      },
      {
         "item": "coupon",
         "cnt": 0
      },
      {
         "item": "service",
         "cnt": 0
      },
      {
         "item": "article_external",
         "cnt": 0
      },
      {
         "item": "video_external",
         "cnt": 0
      },
      {
         "item": "product_external",
         "cnt": 0
      },
      {
         "item": "coupon_external",
         "cnt": 0
      },
      {
         "item": "service_external",
         "cnt": 0
      }
   ],
   "featuredproduct": ""
}