thepipeking

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 329141,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://www.thepipekingllc.com/",
      "title": "thepipeking",
      "description": "Welcome to The Pipe King, proudly owned and operated by Lewis Matthew, bringing over 20 years of expertise to Cranston, RI, and surrounding areas. Specializing in drain cleaning, high-pressure jetting, and camera main drain line inspections, we offer precise solutions to your plumbing needs. Known for our commitment to integrity, honesty, and transparency, The Pipe King provides free estimates, 24/7 emergency services, and a solid 5-15 year warranty on all services.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 79966,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-03-14T00: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": 38,
      "city_id": 20160,
      "ltop": "",
      "facebook": "https://www.thepipekingllc.com/",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "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": 4232,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "ac75e808-e1c2-11ee-8344-b66e99367f32",
      "subdate": "Mar 14, 2024",
      "subcategory": "Home Repair Professionals",
      "request_types": "",
      "visitcount": 20
   },
   "visits": {
      "storefront": 20,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 12,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "Drain Cleaning",
      "service2": "Pipe repair",
      "service3": "Septic Line Clogs",
      "service4": "Faucet repair",
      "service5": "Bathroom Clogs",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-03-14 05:21:12"
   },
   "location": {
      "uuid": "ac75e808-e1c2-11ee-8344-b66e99367f32",
      "link_id": 329141,
      "account_id": 79966,
      "company": "The Pipe King",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 38,
      "city": "20160",
      "zip": "02920",
      "address": "",
      "phone": "866-868-0679",
      "fax": null,
      "email": "thepipekingllc@brite-mail.com",
      "name": "The Pipe King",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": null,
      "lon": null,
      "cityname": "Cranston",
      "statename": "Rhode Island"
   },
   "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": ""
}