Norcal Water Systems

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 323642,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://norcalwater.net/",
      "title": "Norcal Water Systems",
      "description": "Kinetico Water of Placerville is your trusted provider of whole-house water treatment systems, water filtration systems, water softeners, and related products.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 74704,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2022-12-12T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 3,
      "clickcount": 10,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2357,
      "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": 246,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "059504b3-7a06-11ed-b5b4-b66e99367f32",
      "subdate": "Dec 12, 2022",
      "subcategory": "Security Services",
      "request_types": "",
      "visitcount": 27
   },
   "visits": {
      "storefront": 27,
      "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": "Kinetico Water of Placervilles expert water specialist can help you with hard water, acidic water, bad-tasting water, chlorine issues, sulfur and iron issues in addition to bacteria and arsenic that might be lurking in your water supply. Want to be sure? Contact us and we can help you find out what is in your water.",
      "service1": "Water Filtration Company",
      "service2": "Water service ",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2022-12-12 10:16:20"
   },
   "location": {
      "uuid": "059504b3-7a06-11ed-b5b4-b66e99367f32",
      "link_id": 323642,
      "account_id": 74704,
      "company": "",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2357",
      "zip": "95667",
      "address": null,
      "phone": "Norcal Water Systems",
      "fax": null,
      "email": "norcalwater@freekingkong.com.au",
      "name": "",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": null,
      "lon": null,
      "cityname": "Placerville",
      "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": ""
}

all our featured social media