Hydro Rooter and Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 331182,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.hydrorooterandplumbing.com/",
      "title": "Hydro Rooter and Plumbing",
      "description": "Hydro Rooter and Plumbing Services are excited to be growing into our new office here in Tucson. We are here for all of your plumbing, drain cleaning and service needs. At Hydro Rooter and Plumbing, we aim to provide you with the best service and ensure that you and your needs always come first. With a professional and trustworthy staff, your satisfaction is guaranteed.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 81983,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-05-27T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 19,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 3,
      "city_id": 1070,
      "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": 5009,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "252e0e4f-1bef-11ef-8344-b66e99367f32",
      "subdate": "May 27, 2024",
      "subcategory": "Home Plumbing",
      "request_types": "",
      "visitcount": 68
   },
   "visits": {
      "storefront": 68,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Hydro Rooter and Plumbing Services are excited to be growing into our new office here in Tucson. We are here for all of your plumbing, drain cleaning and service needs. At Hydro Rooter and Plumbing, we aim to provide you with the best service and ensure that you and your needs always come first. With a professional and trustworthy staff, your satisfaction is guaranteed.",
      "service1": "Drain Cleaning",
      "service2": "Hydro jetting",
      "service3": "Sewer Lining",
      "service4": "Emergency Plumbing",
      "service5": "Pipe Repair",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-05-27 06:05:40"
   },
   "location": {
      "uuid": "252e0e4f-1bef-11ef-8344-b66e99367f32",
      "link_id": 331182,
      "account_id": 81983,
      "company": "",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "1070",
      "zip": "85710",
      "address": "7057 E 21ST Street",
      "phone": " (520) 788-3839\t",
      "fax": null,
      "email": "hydrorooter@brite-mail.com",
      "name": "Hydro Rooter and Plumbing",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "32.2001457",
      "lon": "-110.8876692",
      "cityname": "Tucson",
      "statename": "Arizona"
   },
   "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": ""
}