Nor-Cal Pipeline Services

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 321905,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "http://norcalpipe.com/",
      "title": "Nor-Cal Pipeline Services",
      "description": "NorCal Pipeline Services offers pipeline inspection, cleaning, sewer inspection, and rehabilitation services. Nor-Cal is dedicated to providing a safe and healthy working environment to protect our employees, contractors, clients, property, the environment, and general public. Nor Cal Storm and Sewer Cleaning preserves flows and improves life when weather strikes. Contact us Anytime, anywhere we get the job done.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 73071,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2022-03-28T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 72,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2428,
      "ltop": "",
      "facebook": "https://www.facebook.com/norcalpipe",
      "tiktok": null,
      "linkedin": "",
      "twitter": "https://twitter.com/norcalpipelines",
      "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": 6475,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9587c121-56da-11ed-b77c-b66e99367f32",
      "subdate": "Mar 28, 2022",
      "subcategory": "Paving",
      "request_types": "",
      "visitcount": 125
   },
   "visits": {
      "storefront": 125,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 5,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "NorCal Pipeline Services offers pipeline inspection, cleaning, sewer inspection, and rehabilitation services. Nor-Cal is dedicated to providing a safe and healthy working environment to protect our employees, contractors, clients, property, the environment, and general public. Nor Cal Storm and Sewer Cleaning preserves flows and improves life when weather strikes. Contact us Anytime, anywhere we get the job done.",
      "service1": "Pipe Cleaning Roseville",
      "service2": "Hydrovac Excavation Services Roseville",
      "service3": "CCTV Inspection Services Roseville",
      "service4": "Hydroexcavation Roseville",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2022-03-28 04:26:37"
   },
   "location": {
      "uuid": "9587c121-56da-11ed-b77c-b66e99367f32",
      "link_id": 321905,
      "account_id": 73071,
      "company": "Nor-Cal Pipeline Services",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2428",
      "zip": "95678",
      "address": "983 Reserve Dr",
      "phone": "916-442-5400",
      "fax": null,
      "email": "norcalpipe0@outlook.com",
      "name": "Nor-Cal Pipeline Services",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "38.7658448",
      "lon": "-121.271469",
      "cityname": "Roseville",
      "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": ""
}