Oak Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348286,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://oak.plumbing/",
      "title": "Oak Plumbing",
      "description": "Dealing with a plumbing issue is never something any homeowner wants to face. But while plumbing problems are a headache, finding a dependable plumber to fix them shouldnt be!At Oak Plumbing, we make it easy to work with us. Our expertly trained plumbers work diligently to make sure that your service with us is pleasant and hassle-free.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 98981,
      "approve_dt": "2025-07-15T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-06T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 10,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 1682,
      "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": 4996,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9b675903-42aa-11f0-a909-b66e99367f32",
      "subdate": "Jun 06, 2025",
      "subcategory": "Home Plumbing Repair",
      "request_types": "",
      "visitcount": 36
   },
   "visits": {
      "storefront": 36,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 9,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Oak Plumbing is an award-winning plumbing company established in 2016 by a master plumber with over 20 years of experience in residential, commercial, and industrial services. Founded on a culture of exceptional customer service and community dedication, Oak Plumbing combines the latest plumbing technologies with family values, featuring 100% certified, background-checked, and drug-tested technicians who take an honest, educational approach to solving plumbing problems at their root.",
      "service1": "residential plumbing repairs",
      "service2": " commercial plumbing services",
      "service3": " industrial plumbing solutions",
      "service4": " emergency plumbing response",
      "service5": " plumbing inspections",
      "service6": " drain cleaning",
      "service7": " water heater installation",
      "submit_dt": "2025-06-06 07:48:17"
   },
   "location": {
      "uuid": "9b675903-42aa-11f0-a909-b66e99367f32",
      "link_id": 348286,
      "account_id": 98981,
      "company": "Oak Plumbing",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "1682",
      "zip": "94510",
      "address": " 3852 Industrial Way, Benicia, CA 94510",
      "phone": "(800) 397-3799",
      "fax": null,
      "email": "oakplumbing43@gmail.com",
      "name": "Oak Plumbing",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "38.0680059",
      "lon": "-122.1220412",
      "cityname": "Benicia",
      "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": ""
}