Drain and Water Plumbing Services

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349982,
      "site_id": 66,
      "cat_id": 78,
      "priority": 0,
      "url": "https://www.drainandwater.com/",
      "title": "Drain and Water Plumbing Services",
      "description": "Drain&Water’s growing team of experienced technicians are knowledgeable and committed to handling complex plumbing projects quickly, and at reasonable rates. We invest in the latest leak detection, hydro jetting and pipe lining equipment to enable our teams to minimize disruption for our customers.\n\nLearn More: https://www.drainandwater.com/",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100677,
      "approve_dt": "2025-09-16T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-09-04T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2463,
      "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": 5018,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "4969aa95-89b7-11f0-bb42-b66e99367f32",
      "subdate": "Sep 04, 2025",
      "subcategory": "General Plumbing",
      "request_types": "",
      "visitcount": 31
   },
   "visits": {
      "storefront": 31,
      "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": "Drain & Water’s growing team of experienced technicians are knowledgeable and committed to handling complex plumbing projects quickly, and at reasonable rates. We invest in the latest leak detection, hydro jetting and pipe lining equipment to enable our teams to minimize disruption for our customers.\n
\n
\nLearn More: https://www.drainandwater.com/",
      "service1": "Pipe Lining",
      "service2": "Pipe Bursting",
      "service3": "Trenchless Pipe Repair",
      "service4": "Sewer Line Repair",
      "service5": "Drain Snaking",
      "service6": "Hydro Jetting",
      "service7": "Drain Cleaning",
      "submit_dt": "2025-09-04 17:47:55"
   },
   "location": {
      "uuid": "4969aa95-89b7-11f0-bb42-b66e99367f32",
      "link_id": 349982,
      "account_id": 100677,
      "company": "Drain and  Water",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2463",
      "zip": "95125",
      "address": "1913 Stone Ave, San Jose, CA ",
      "phone": "(408) 564-0580",
      "fax": null,
      "email": "drainandwatermarketing@gmail.com",
      "name": "Drain and Water Plumbing Services",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "San Jose",
      "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": ""
}