C4 Plumbing, Heating & Cooling

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 325540,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://c4plumbing.com",
      "title": "C4 Plumbing, Heating & Cooling",
      "description": "C4 Plumbing, Heating & Cooling is a leading provider of plumbing and HVAC services throughout Aurora and the surrounding areas. Our technicians are able to provide maintenance, repair and new installation services.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 76461,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-08-07T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 6,
      "city_id": 2712,
      "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": 2702,
      "subcat_id": 4977,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "71d65e1e-3578-11ee-8344-b66e99367f32",
      "subdate": "Aug 07, 2023",
      "subcategory": "Plumbing Repair",
      "request_types": "",
      "visitcount": 7
   },
   "visits": {
      "storefront": 7,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We are equipped with the most advanced tools and technologies developed for our industry in order to effectively complete a wide range of different jobs. We provide services to diagnose and repair issues with plumbing, furnaces and air conditioners. We also provide maintenance and installation services for systems, components and appliances such as water softeners and AC units. Our services are available for both commercial and residential properties.",
      "service1": "plumbing repair",
      "service2": "ac repair",
      "service3": "furnace repair",
      "service4": "air conditioner installation",
      "service5": "furnace installation",
      "service6": "24/7 emergency plumbing",
      "service7": "hvac services",
      "submit_dt": "2023-08-07 23:16:31"
   },
   "location": {
      "uuid": "71d65e1e-3578-11ee-8344-b66e99367f32",
      "link_id": 325540,
      "account_id": 76461,
      "company": "C4 Plumbing, Heating & Cooling",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 6,
      "city": "2712",
      "zip": "80013",
      "address": "3033 S Andes St",
      "phone": "(720) 585-1471",
      "fax": null,
      "email": "co.canty.plumbing@gmail.com",
      "name": "C4 Plumbing, Heating & Cooling",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "39.6592516",
      "lon": "-104.7713209",
      "cityname": "Aurora",
      "statename": "Colorado"
   },
   "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": ""
}