Plumber Fremont

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 321162,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://plumbingfremontca.com/",
      "title": "Plumber Fremont",
      "description": "Experienced and licensed plumbing services company with the most affordable rates in the area. Services include installation and repair of most major plumbing issues: water leaks, kitchen & bath repair, water heaters, copper repiping, sewer lines, and much more. The team at Plumber Fremont are true experts when dealing with all kinds of drain problems. We can help with various plumbing issues in your household, from a clogged sink to a blocked toilet, using top-of-the-line drain cleaning equipment. We are happy to provide our quality service any time you need them.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 72354,
      "approve_dt": "2021-09-04T00:00:00.000Z",
      "source": null,
      "submit_dt": "2021-08-26T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 422,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 1962,
      "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": 5000,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95602d59-56da-11ed-b77c-b66e99367f32",
      "subdate": "Aug 26, 2021",
      "subcategory": "Plumbing Services",
      "request_types": "",
      "visitcount": 589
   },
   "visits": {
      "storefront": 589,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Experienced and licensed plumbing services company with the most affordable rates in the area. Services include installation and repair of most major plumbing issues: water leaks, kitchen & bath repair, water heaters, copper repipping, sewer lines, and much more.",
      "service1": "Emergency Plumbing",
      "service2": " Leak Repair",
      "service3": " Clogged Drain",
      "service4": " Clogged Toilet",
      "service5": " Burst Pipe Repair",
      "service6": " Water Heater Repair",
      "service7": " Plumber Fremont",
      "submit_dt": "2021-08-26 19:03:59"
   },
   "location": {
      "uuid": "95602d59-56da-11ed-b77c-b66e99367f32",
      "link_id": 321162,
      "account_id": 72354,
      "company": "Plumber Fremont",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "1962",
      "zip": "93711",
      "address": "5166 N Marty Ave Ste 106, Fresno CA 93711",
      "phone": "5593142645",
      "fax": null,
      "email": "plumbingfremontca70@gmail.com",
      "name": "Plumber Fremont",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "36.811125",
      "lon": "-119.8581006",
      "cityname": "Fresno",
      "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": ""
}