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": "Our team of proven plumbers in Maui provides fast, reliable solutions for all your plumbing needs, from minor leaks to major emergencies. We offer 24/7 emergency plumbing services to protect your home from burst pipes, slab leaks, gas line leaks, sewer line ruptures, and other urgent situations. With quick response times and long-lasting solutions, we're here to take control of any plumbing problem and restore your peace of mind.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95863,
      "approve_dt": "2025-10-13T00:00:00.000Z",
      "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": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "3c761179-16b5-11f0-a909-b66e99367f32",
      "subdate": "Apr 11, 2025",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 38
   },
   "visits": {
      "storefront": 38,
      "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": ""
}