Franklin Plumbing & Drain Cleaning

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 329952,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://franklinplumbingsc.com/",
      "title": "Franklin Plumbing & Drain Cleaning",
      "description": "At Franklin Plumbing & Drain Cleaning, we provide a wide range of services to help our clients keep their plumbing systems in great condition. We''ve become a mainstay of our community by providing turnkey plumbing, gas, and drain cleaning services that homeowners can always rely on. The professionals at our Columbia plumbing company always strive to provide the highest quality workmanship possible, and we can always guarantee your complete satisfaction with our work.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 80765,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-04-15T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 18,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 39,
      "city_id": 20245,
      "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": 4977,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "2e3176e6-fb4e-11ee-8344-b66e99367f32",
      "subdate": "Apr 15, 2024",
      "subcategory": "Plumbing Repair",
      "request_types": "",
      "visitcount": 69
   },
   "visits": {
      "storefront": 69,
      "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": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-04-15 17:32:49"
   },
   "location": {
      "uuid": "2e3176e6-fb4e-11ee-8344-b66e99367f32",
      "link_id": 329952,
      "account_id": 80765,
      "company": "Franklin Plumbing & Drain Cleaning",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 39,
      "city": "20245",
      "zip": "29205",
      "address": "3004 Millwood Ave",
      "phone": "(803) 761-0167",
      "fax": null,
      "email": "franklinplumbingscmarketing@gmail.com",
      "name": "Franklin Plumbing & Drain Cleaning",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "34.0016007",
      "lon": "-80.9984754",
      "cityname": "Columbia",
      "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": ""
}