CG Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 346738,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.cgplumbingservice.com/",
      "title": "CG Plumbing",
      "description": "Are you tired of dealing with clogged drains or leaky faucets? Do you need one of your plumbing fixtures replaced? CG Plumbing can help with all of that and more. We offer reliable plumbing services in Shingle Springs, CA and the surrounding areas. We make excellent customer service our top priority, handling each job with care to make sure your plumbing needs are fully met. Get in touch with us now to speak to one of our professional plumbing contractors.\r\n\r\nContact Telephone:\r\n(916) 413-2480",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 97433,
      "approve_dt": "2025-07-31T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-11T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 0,
      "city_id": 0,
      "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": 4974,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9733b440-2e7f-11f0-a909-b66e99367f32",
      "subdate": "May 11, 2025",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 6
   },
   "visits": {
      "storefront": 6,
      "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": "CG Plumbing is a local plumbing company serving El Dorado, Sacramento, Placer, Nevada, and Amador Counties in California. Founded on the principle of making plumbing less stressful, they focus on clear communication, reliability, and treating every customer like a neighbor, handling everything from minor repairs to major system failures.",
      "service1": "leaky faucet repairs",
      "service2": " full plumbing system installations",
      "service3": " emergency plumbing services",
      "service4": " residential plumbing maintenance",
      "service5": " commercial plumbing solutions",
      "service6": " pipe repair and replacement",
      "service7": " plumbing system diagnostics",
      "submit_dt": "2025-05-11 15:49:58"
   },
   "location": {
      "uuid": "9733b440-2e7f-11f0-a909-b66e99367f32",
      "link_id": 346738,
      "account_id": 97433,
      "company": "CG Plumbing",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 0,
      "city": "",
      "zip": "",
      "address": "",
      "phone": "(916) 413-2480",
      "fax": null,
      "email": "cgplumbing@brite-email.com",
      "name": "CG Plumbing",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null
   },
   "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": ""
}