All Aloha Plumbing Maui

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 345168,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://allalohaplumbing.com/maui/",
      "title": "All Aloha Plumbing Maui",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95863,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-04-11T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 4,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 11,
      "city_id": 4806,
      "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": 5026,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "3c761179-16b5-11f0-a909-b66e99367f32",
      "subdate": "Apr 11, 2025",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 37
   },
   "visits": {
      "storefront": 37,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 17,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "All Aloha Plumbing Maui is your trusted local plumbing company, providing top-quality residential and commercial plumbing services across Maui, HI. With a commitment to excellence and the Aloha spirit, we offer expert solutions, including drain cleaning, leak detection, water heater services, repiping, and emergency plumbing. Our skilled team ensures reliable, efficient, and affordable service with a customer-first approach. Whether you need routine maintenance or urgent repairs, All Aloha Plumbing Maui is here to keep your plumbing running smoothly. Experience professional service with a touch of Aloha. Call 24/7 to schedule all types of reliable Plumbing Services in Maui!",
      "service1": "Bathroom Remodeling",
      "service2": "Backflow Prevention",
      "service3": "Drain and Toilet Clog Removal",
      "service4": "Water Filtration Services",
      "service5": "Water Leak Repair",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-04-11 09:13:30"
   },
   "location": {
      "uuid": "3c761179-16b5-11f0-a909-b66e99367f32",
      "link_id": 345168,
      "account_id": 95863,
      "company": "All Aloha Plumbing Maui",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 11,
      "city": "4806",
      "zip": "96768",
      "address": "724 Onipaa Pl",
      "phone": "+18088718139",
      "fax": null,
      "email": "allalohapluhw@burst-email.com",
      "name": "All Aloha Plumbing Maui",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "20.844376",
      "lon": "-156.318767",
      "cityname": "Makawao",
      "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": ""
}