Rooter Express

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349792,
      "site_id": 66,
      "cat_id": 78,
      "priority": 0,
      "url": "https://rooterexpsc.com/",
      "title": "Rooter Express",
      "description": "From minor issues to major fixes, Rooter Express SC in Anderson, SC, provides reliable septic repair. They are the professionals you can trust to get the job right the first time.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100487,
      "approve_dt": "2025-09-11T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-08-21T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 39,
      "city_id": 20185,
      "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": 5018,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "12045bbd-7ea0-11f0-bb42-b66e99367f32",
      "subdate": "Aug 21, 2025",
      "subcategory": "General Plumbing",
      "request_types": "",
      "visitcount": 62
   },
   "visits": {
      "storefront": 62,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 19,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "At Rooter Express SC, we’re a local business with a mission: offering the best plumbing, septic, and sewage services in the Palmetto State. We invite you to learn more about our business so that you can better understand the family-owned touch that sets us apart from our big-name competitors.",
      "service1": "Septic Tank Pumping",
      "service2": "Septic repair",
      "service3": "Drain Field Remediation",
      "service4": "Sewer Cleaning",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-08-21 15:04:01"
   },
   "location": {
      "uuid": "12045bbd-7ea0-11f0-bb42-b66e99367f32",
      "link_id": 349792,
      "account_id": 100487,
      "company": "Rooter  Express",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 39,
      "city": "20185",
      "zip": "29625",
      "address": "925 Centerville Rd Anderson, SC 29625",
      "phone": "864 385 1006",
      "fax": null,
      "email": "rooterexpscmarketing@gmail.com",
      "name": "Rooter Express",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Anderson",
      "statename": "South Carolina"
   },
   "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": ""
}