Mickle Electric & Heating Inc.

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317197,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.mickle-inc.com/",
      "title": "Mickle Electric & Heating Inc.",
      "description": "Mickle Electric & Heating Inc provides quality electrician and heating services for your residential and commercial needs in Des Moines, IA. You will get the peace of mind during your residential or commercial project with our licensed and insured team, trusted for quality since 1987. We provide fast 24/7 emergency services. Call us at 515-261-0058 for FREE estimates!\r\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68395,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-06-06T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 201,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 15,
      "city_id": 7204,
      "ltop": "",
      "facebook": "https://www.facebook.com/MickleElectric/",
      "tiktok": null,
      "linkedin": "",
      "twitter": "https://twitter.com/MickleElectric1",
      "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": 5854,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "956e75a7-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jun 06, 2019",
      "subcategory": "Electricians",
      "request_types": "",
      "visitcount": 316
   },
   "visits": {
      "storefront": 316,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 15,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Mickle Electric & Heating Inc provides quality electrician and heating services for your residential and commercial needs in Des Moines, IA. You will get the peace of mind during your residential or commercial project with our licensed and insured team, trusted for quality since 1987. We provide fast 24/7 emergency services. Call us at 515-261-0058 for FREE estimates!\r\n",
      "service1": "Electrician & Heating",
      "service2": "heating services des moines ia",
      "service3": "electrician services Des Moines ia",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-06-06 05:59:48"
   },
   "location": {
      "uuid": "956e75a7-56da-11ed-b77c-b66e99367f32",
      "link_id": 317197,
      "account_id": 68395,
      "company": "Mickle Electric & Heating Inc.",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 15,
      "city": "7204",
      "zip": "50313",
      "address": "1448 E Madison Ave",
      "phone": "515-261-0058",
      "fax": null,
      "email": "mickleinc@hotmail.com",
      "name": "Mickle Electric & Heating Inc.",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "41.6337777",
      "lon": "-93.5982767",
      "cityname": "Des Moines",
      "statename": "Iowa"
   },
   "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": ""
}