Nexgen Rooter

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 336937,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.nexgenrooter.com",
      "title": "Nexgen Rooter",
      "description": "Nexgen Rooter and Plumbing stands is a trusted local plumbing service in the East Bay Area. We are a full-service plumbing company that is fully bonded, licensed, and insured with over 11 years of experience, we are the right choice for your plumbing needs. Our licensed plumbers are very knowledgeable and reliable, and we make sure you get the highest quality work to repair or install your plumbing, we get the job done fast. As a  full-service emergency plumbing company, we strive to make sure our clients get the best value of work.  We offer the most competitive prices, and we make sure that all of our work follows building code and  city code regulations. Call us to schedule your service today.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 87668,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-10-17T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2012,
      "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": 5026,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "d4fff440-8c83-11ef-ab46-b66e99367f32",
      "subdate": "Oct 17, 2024",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 12
   },
   "visits": {
      "storefront": 12,
      "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": "Nexgen Rooter and Plumbing stands is a trusted local plumbing service in the East Bay Area. We are a full-service plumbing company that is fully bonded, licensed, and insured with over 11 years of experience, we are the right choice for your plumbing needs. Our licensed plumbers are very knowledgeable and reliable, and we make sure you get the highest quality work to repair or install your plumbing, we get the job done fast. As a  full-service emergency plumbing company, we strive to make sure our clients get the best value of work.  We offer the most competitive prices, and we make sure that all of our work follows building code and  city code regulations. Call us to schedule your service today.",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-10-17 12:32:11"
   },
   "location": {
      "uuid": "d4fff440-8c83-11ef-ab46-b66e99367f32",
      "link_id": 336937,
      "account_id": 87668,
      "company": "Nexgen Rooter",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2012",
      "zip": "94541",
      "address": "N/A",
      "phone": "510-876-3549",
      "fax": null,
      "email": "nexgenrooter@outlook.com",
      "name": "Nexgen Rooter",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "37.6737239",
      "lon": "-122.1007867",
      "cityname": "Hayward",
      "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": ""
}