Plumber

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 332244,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.mrrooter.com/amarillo",
      "title": "Plumber",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 83033,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-06-27T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 22,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 21311,
      "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": 288,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "fb709cce-3428-11ef-8344-b66e99367f32",
      "subdate": "Jun 27, 2024",
      "subcategory": "Home And Garden",
      "request_types": "",
      "visitcount": 49
   },
   "visits": {
      "storefront": 49,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Mr. Rooter Plumbing of Amarillo, with over 50 years of experience, offers courteous plumbing services for both residential and commercial needs. Our licensed and insured experts handle everything from drain cleaning and water line repair to emergencies, including fruit fly issues, clogged toilets, and P-trap replacements to prevent gas entry. Benefit from our flat-rate pricing without overtime charges and our Neighborly Done Right Promise: if not right, we'll correct it. Guaranteed!",
      "service1": "plumbing repair & service",
      "service2": "Drain Cleaning",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-06-27 02:00:09"
   },
   "location": {
      "uuid": "fb709cce-3428-11ef-8344-b66e99367f32",
      "link_id": 332244,
      "account_id": 83033,
      "company": "Mr. Rooter Plumbing of Amarillo",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "21311",
      "zip": "79106",
      "address": "3801 Amarillo Blvd West",
      "phone": "(806) 223-2906",
      "fax": null,
      "email": "mrrooterplumbingtx@outlook.com",
      "name": "Mr. Rooter Plumbing of Amarillo",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "35.2216143",
      "lon": "-101.8796623",
      "cityname": "Amarillo",
      "statename": "Texas"
   },
   "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": ""
}