Plumber

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 328990,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://rotorooterutah.com",
      "title": "Plumber",
      "description": "With Roto-Rooter plumbers, you can always expect the best plumbing service around. Our team in St George, UT provides southern Utah with plumbing maintenance and repairs, including drain cleaning service, outdoor faucet repair, water damage cleanup, and more.\r\n\r\nTrusted and recommended since 1935, Roto-Rooter is the premier provider of plumbing and drain cleaning services in St George, UT. We serve both residential homes and commercial buildings with the finest plumbing services.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 79815,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-03-07T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 32,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 43,
      "city_id": 23012,
      "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": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "ff39ac1a-dc64-11ee-8344-b66e99367f32",
      "subdate": "Mar 07, 2024",
      "subcategory": "Home Plumbing",
      "request_types": "",
      "visitcount": 101
   },
   "visits": {
      "storefront": 101,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 10,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "Emergency Plumber",
      "service2": "Commercial Plumbing",
      "service3": "Leak & Pipe Repair",
      "service4": "Water Heaters",
      "service5": "Repiping",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-03-07 09:28:03"
   },
   "location": {
      "uuid": "ff39ac1a-dc64-11ee-8344-b66e99367f32",
      "link_id": 328990,
      "account_id": 79815,
      "company": "Roto-Rooter Plumbing & Water Cleanup",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 43,
      "city": "23012",
      "zip": "84790",
      "address": "376 Sunland Dr, Suite 2B",
      "phone": "435-673-2511",
      "fax": null,
      "email": "anthonycox@brite-post.com",
      "name": "Roto-Rooter Plumbing & Water Cleanup",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "37.086702",
      "lon": "-113.5755197",
      "cityname": "St. George",
      "statename": "Utah"
   },
   "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": ""
}