Jolly Plumbing, Drains, Heating, and Air

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348157,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://jollyplumbing.com/",
      "title": "Jolly Plumbing, Drains, Heating, and Air",
      "description": "Jolly Plumbing, Drains, Heating, and Air has served Northern Kentucky and Greater Cincinnati for over 40 years now. Their goal day in and day out is to provide honest, friendly, and prompt customer service. Their services range from water heaters and drain clearings to new HVAC system installs. They provide free estimates, and our experienced technicians give you all the information you need to make the right decision for your family. Backed by over 1,000 five-star reviews on google, they would love to make your home, a Jolly Home.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 98852,
      "approve_dt": "2025-07-16T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-04T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 17,
      "city_id": 9011,
      "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": 5026,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9df8c272-413d-11f0-a909-b66e99367f32",
      "subdate": "Jun 04, 2025",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 49
   },
   "visits": {
      "storefront": 49,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 33,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "The Jolly Home Plan\nJoin the Jolly Home Plan as a proactive step in keeping your home a place of comfort. This $14.99 monthly charge allows you to stay on top of your home's needs while receiving Jolly's top-notch service and paying less for it. Members enjoy comprehensive annual inspections, priority service, and valuable discounts on repairs and emergency fees.",
      "service1": "Annual Heating System Check",
      "service2": " Carbon Monoxide Testing",
      "service3": " Annual Cooling System Check",
      "service4": " Annual Plumbing Inspection",
      "service5": " Main Sewer Camera Inspection",
      "service6": " Priority Service Access",
      "service7": " Repair and Emergency Fee Discounts",
      "submit_dt": "2025-06-04 12:15:34"
   },
   "location": {
      "uuid": "9df8c272-413d-11f0-a909-b66e99367f32",
      "link_id": 348157,
      "account_id": 98852,
      "company": "Jolly Plumbing, Drains, Heating, and Air",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 17,
      "city": "9011",
      "zip": "41076",
      "address": "101 Beacon Dr, #1",
      "phone": "859-781-7500",
      "fax": null,
      "email": "jollyplumbing@mail-burst.com",
      "name": "https://jollyplumbing.com/",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Wilder",
      "statename": "Kentucky"
   },
   "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": ""
}