Midwest Basement Systems

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 309404,
      "site_id": 64,
      "cat_id": 50,
      "priority": 0,
      "url": "http://www.midwestbasementsystems.com/",
      "title": "Midwest Basement Systems",
      "description": "Welcome to Midwest Basement Systems, the leader for Iowa basement waterproofing. Midwest Basement Systems specializes in basement waterproofing, crawl space repair, foundation repair, and more in Iowa. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 60640,
      "approve_dt": "2015-05-06T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-05-05T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1606,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 15,
      "city_id": 7204,
      "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": 4810,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "jpg",
      "pack_id": null,
      "uuid": "9547cf48-56da-11ed-b77c-b66e99367f32",
      "subdate": "May 05, 2015",
      "subcategory": "Handyman Services",
      "request_types": "",
      "visitcount": 1931
   },
   "visits": {
      "storefront": 1931,
      "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": "Midwest Basement Systems is a locally owned and operated basement waterproofing contractor providing their professional home improvement services to residents all throughout the Greater Des Moines area. From structural foundation repair services to waterproofing the crawl spaces or basement - let the experts at Midwest Basement Systems help. Contact them today to get started on a free estimate!",
      "service1": "Basement Waterproofing",
      "service2": "Foundation Repair",
      "service3": "Concrete Lifting and Leveling",
      "service4": "Crawl Space Repair",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2015-05-05 16:44:25"
   },
   "location": {
      "uuid": "9547cf48-56da-11ed-b77c-b66e99367f32",
      "link_id": 309404,
      "account_id": 60640,
      "company": "Midwest Basement Systems",
      "sid": 64,
      "country": 277,
      "countrycode": "US",
      "state": 15,
      "city": "7204",
      "zip": "50313",
      "address": "5153 Northeast 17th ",
      "phone": "",
      "fax": "",
      "email": "",
      "name": "",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "41.653956",
      "lon": "-93.591719",
      "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": ""
}