All Aloha Plumbing and Drain Cleaning Oahu

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 345135,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://allalohaplumbing.com/oahu/",
      "title": "All Aloha Plumbing and Drain Cleaning Oahu",
      "description": "Our proven team of plumbers provides fast, reliable solutions for all your plumbing needs, from minor water leaks to major emergencies, with 24/7 emergency plumbing services available to protect your home against burst pipes, slab leaks, gas line leaks, sewer line ruptures, and other urgent plumbing issues.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95830,
      "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": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 11,
      "city_id": 4854,
      "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": 4974,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "c530c169-1686-11f0-a909-b66e99367f32",
      "subdate": "Apr 11, 2025",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 49
   },
   "visits": {
      "storefront": 49,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 27,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "All Aloha Plumbing Oahu is your trusted local plumbing company, providing top-quality residential and commercial plumbing services across Waipahu, 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 Oahu 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 Waipahu!",
      "service1": "Bathroom Remodeling",
      "service2": "Drain Clearing",
      "service3": "Slab Leak Repair",
      "service4": "Water Filtration Services",
      "service5": "Water Heater Services",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-04-11 03:40:53"
   },
   "location": {
      "uuid": "c530c169-1686-11f0-a909-b66e99367f32",
      "link_id": 345135,
      "account_id": 95830,
      "company": "All Aloha Plumbing and Drain Cleaning Oahu",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 11,
      "city": "4854",
      "zip": "96797",
      "address": "94-150 Leoleo St, Ste A1118",
      "phone": "(808) 740-0678",
      "fax": null,
      "email": "allalohaplmbing@brite-post.com",
      "name": "",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "21.3765637",
      "lon": "-158.0206433",
      "cityname": "Waipahu",
      "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": ""
}