Plumbtree Plumbing & Rooter

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 328449,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://plumbtreeplumbing.com/",
      "title": "Plumbtree Plumbing & Rooter",
      "description": "Plumber",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 79286,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-02-16T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 14,
      "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": 5039,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "6a2bc886-cc69-11ee-8344-b66e99367f32",
      "subdate": "Feb 16, 2024",
      "subcategory": "Plumber Handbook",
      "request_types": "",
      "visitcount": 43
   },
   "visits": {
      "storefront": 43,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 1,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "When you're looking for plumbers in San Jose, CA, don't take a chance choosing just any company. Choose South Bay plumbing services you can trust by calling Plumbtree Plumbing&Rooter. We've been helping residents throughout the area for years and are dedicated to becoming \"Your Neighborhood Plumbing Experts\" and the only plumbing team you ever need to call. Our company is family-owned and locally operated and we serve the Greater Silicon Valley 24 hours a day, 365 days a year.",
      "service1": "Drain Cleaning",
      "service2": "Sewer Repair",
      "service3": "Trenchless Sewer Repair",
      "service4": "Main Water Valves",
      "service5": "Emergency Plumbing Services",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-02-16 01:19:22"
   },
   "location": {
      "uuid": "6a2bc886-cc69-11ee-8344-b66e99367f32",
      "link_id": 328449,
      "account_id": 79286,
      "company": "Plumbtree Plumbing & Rooter",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2463",
      "zip": "95119",
      "address": "210 Paraiso Court",
      "phone": "",
      "fax": null,
      "email": "plumbtree@brite-email.com",
      "name": "Plumbtree Plumbing & Rooter",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "37.2315164",
      "lon": "-121.785944",
      "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": ""
}