Plumber - Plumbing - Livermore, CA Greater Area

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 308365,
      "site_id": 66,
      "cat_id": 78,
      "priority": 0,
      "url": "http://www.rbtravisplumbing.com",
      "title": "Plumber - Plumbing - Livermore, CA Greater Area",
      "description": "RB Travis Plumbing provides plumbers for all your plumbing solutions including installation of new plumbing, sink repair, bath tub repair, shower repair, clogged drain repair, sewer line repair, copper pipe repair, copper repipe and heating repair.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 59590,
      "approve_dt": "2014-11-18T00:00:00.000Z",
      "source": null,
      "submit_dt": "2014-11-17T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1027,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2156,
      "ltop": "",
      "facebook": "",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 5026,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "jpg",
      "pack_id": null,
      "uuid": "95420ed4-56da-11ed-b77c-b66e99367f32",
      "subdate": "Nov 17, 2014",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 1189
   },
   "visits": {
      "storefront": 1189,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "RB Travis Plumbing provides plumbers for all your plumbing solutions including installation of new plumbing, sink repair, bath tub repair, shower repair, clogged drain repair, sewer line repair, copper pipe repair, copper repipe and heating repair.",
      "service1": "plumbing",
      "service2": "plumber",
      "service3": "drain cleaning",
      "service4": "sewer cleaning",
      "service5": "copper repipes",
      "service6": "heating contractor",
      "service7": "heating repair",
      "submit_dt": "2014-11-17 23:07:37"
   },
   "location": {
      "uuid": "95420ed4-56da-11ed-b77c-b66e99367f32",
      "link_id": 308365,
      "account_id": 59590,
      "company": "RB Travis Plumbing",
      "sid": 0,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2156",
      "zip": "94550",
      "address": "575 Leisure St",
      "phone": "",
      "fax": "",
      "email": "marketing@rbtravisplumbing.com",
      "name": "Plumber - Plumbing - Livermore, CA Greater Area",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "37.7101393",
      "lon": "-121.7189179",
      "cityname": "Livermore",
      "statename": "California"
   },
   "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": ""
}