Finzel''s Heating and Cooling

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 310508,
      "site_id": 58,
      "cat_id": 53,
      "priority": 0,
      "url": "http://www.macombhvac.com",
      "title": "Finzel''s Heating and Cooling",
      "description": "Finzel's Heating and Cooling has been proudly serving Macomb, MI since 1985. We install and service all makes and models of furnaces and air conditioners, as well as other products to help keep your home or business comfortable. UV lights and air cleaners help kill the bacteria that are in the air you breathe. Humidifiers keep the moisture in the cold and dry winter air, which especially helps with dry skin and asthma.\n\nThere are many products and services that we offer to enhance the comfort ability of your home and/or office. Just call today to setup an appointment, and we can show you how!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 61743,
      "approve_dt": "2015-09-22T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-09-22T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 890,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 22,
      "city_id": 10486,
      "ltop": "",
      "facebook": "",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 4218,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "954db863-56da-11ed-b77c-b66e99367f32",
      "subdate": "Sep 22, 2015",
      "subcategory": "Air Conditioning",
      "request_types": "",
      "visitcount": 1025
   },
   "visits": {
      "storefront": 1025,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 19,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Finzel's Heating and Cooling has been proudly serving Macomb, MI since 1985. We install and service all makes and models of furnaces and air conditioners, as well as other products to help keep your home or business comfortable. UV lights and air cleaners help kill the bacteria that are in the air you breathe. Humidifiers keep the moisture in the cold and dry winter air, which especially helps with dry skin and asthma.\n\nThere are many products and services that we offer to enhance the comfort ability of your home and/or office. Just call today to setup an appointment, and we can show you how!",
      "service1": "Furnace Installation",
      "service2": " Air Conditioning Installation",
      "service3": " Furnace Service",
      "service4": " Air Conditioning Service",
      "service5": " UV lights",
      "service6": " Humidifiers",
      "service7": " Homes and Offices Service ",
      "submit_dt": "2015-09-22 11:09:55"
   },
   "location": {
      "uuid": "954db863-56da-11ed-b77c-b66e99367f32",
      "link_id": 310508,
      "account_id": 61743,
      "company": "Finzel's Heating and Cooling",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 22,
      "city": "10486",
      "zip": "48042",
      "address": "19881 Cayote Trail",
      "phone": "586-292-3917",
      "fax": "",
      "email": "jeniferfinzel12345@gmail.com",
      "name": "Finzel''s Heating and Cooling",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "42.6937328",
      "lon": "-82.9178838",
      "cityname": "Mackinac Island",
      "statename": "Michigan"
   },
   "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": ""
}