deanzawater.com

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317505,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://deanzawater.com/",
      "title": "deanzawater.com",
      "description": "Since 1978, De Anza Water Conditioning have sold, installed, and serviced Kinetico brand water softeners, water filters, and reverse osmosis drinking water systems to residential and commercial customers from San Francisco to San Jose and surrounding areas",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68703,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-07-31T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 124,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 1750,
      "ltop": "",
      "facebook": "https://www.facebook.com/norcalbraincenter/",
      "tiktok": null,
      "linkedin": "https://www.linkedin.com/company/de-anza-water-conditioning/",
      "twitter": "https://twitter.com/DeAnzaWaterCo",
      "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": 4974,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95701a0e-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jul 31, 2019",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 153
   },
   "visits": {
      "storefront": 153,
      "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": "Almost four decades ago, founder and president of De Anza Water Conditioning, John Schafer, entered the water treatment business with a California State Contractoru2019s license, combined with a wide and deep understanding of wateru2014 the benefits of its best and the challenges of its worst. To compete in this industry, John knew that he needed to provide customers with unique and special solutions.",
      "service1": "water conditioning",
      "service2": "water softening",
      "service3": "water filtration",
      "service4": "drinking water systems",
      "service5": "water treatment services",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-07-31 07:55:21"
   },
   "location": {
      "uuid": "95701a0e-56da-11ed-b77c-b66e99367f32",
      "link_id": 317505,
      "account_id": 68703,
      "company": "De Anza Water Conditioning",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "1750",
      "zip": "95008",
      "address": "355 E McGlincy Lane, Suite H",
      "phone": "4083715521",
      "fax": null,
      "email": "deanzawaterconditioning2018@gmail.com",
      "name": "De Anza Water Conditioning",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "37.2764211",
      "lon": "-121.9438002",
      "cityname": "Campbell",
      "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": ""
}