Jerry Kelly Heating & Air Conditioning

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 332368,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.jerrykelly.com/",
      "title": "Jerry Kelly Heating & Air Conditioning",
      "description": "Jerry Kelly Heating & Air Conditioning is a Missouri mainstay with a reputation for excellence: in our service, products, and value. Since 1977, we have provided HVAC and indoor comfort solutions for homeowners in St. Peters and surrounding West County communities. As professional HVAC contractors, our goal is to prioritize customer satisfaction in everything we do and stand behind our products and workmanship 100%.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 83151,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-07-01T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 5,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 25,
      "city_id": 12019,
      "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": 6646,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "29512435-3764-11ef-8344-b66e99367f32",
      "subdate": "Jul 01, 2024",
      "subcategory": "Construction",
      "request_types": "",
      "visitcount": 25
   },
   "visits": {
      "storefront": 25,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 6,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "AC INstallation",
      "service2": "Heating Installation",
      "service3": "HVAC Repair",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-07-01 04:41:20"
   },
   "location": {
      "uuid": "29512435-3764-11ef-8344-b66e99367f32",
      "link_id": 332368,
      "account_id": 83151,
      "company": "Jerry Kelly Heating & Air Conditioning",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 25,
      "city": "12019",
      "zip": "63011",
      "address": "14548 Manchester Road",
      "phone": "+1 636-442-0338",
      "fax": null,
      "email": "jerrykellyhvac@brite.email",
      "name": "Jerry Kelly Heating & Air Conditioning",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "38.5927615",
      "lon": "-90.5247936",
      "cityname": "Ballwin",
      "statename": "Missouri"
   },
   "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": ""
}