Spartan Ram Jack Foundation Repair & Waterproofing - Wichita

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 345155,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://spartanfoundationrepair.com/kansas-city/",
      "title": " Spartan Ram Jack Foundation Repair & Waterproofing - Wichita",
      "description": " ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95850,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-04-11T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 16,
      "city_id": 8254,
      "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": 6285,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "97c91aa2-16a3-11f0-a909-b66e99367f32",
      "subdate": "Apr 11, 2025",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 30
   },
   "visits": {
      "storefront": 30,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Ensuring a stable, reliable foundation for your property is essential when avoiding further complications. Our services include foundation repair, basement waterproofing, concrete lifting, and more. Your locally owned Spartan Ram Jack Kansas City has been the foundation repair&waterproofing experts in Kansas City for over 10 years. When you choose Spartan Ram Jack Kansas City you choose American-made products, proven quality, and trusted expertise. We serve the Kansas City region including Blue Springs, Independence, Saint Joseph, Lawrence, Olathe, Overland Park, Lenexa, Shawnee and Topeka. Request an appointment today with your local Ram Jack contractors call today!",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-04-11 07:07:13"
   },
   "location": {
      "uuid": "97c91aa2-16a3-11f0-a909-b66e99367f32",
      "link_id": 345155,
      "account_id": 95850,
      "company": "",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 16,
      "city": "8254",
      "zip": "66215",
      "address": "9010 Rosehill Road",
      "phone": "(816) 237-0017",
      "fax": null,
      "email": "spartanramjack@brite-mail.com",
      "name": "",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "38.9654311",
      "lon": "-94.733472",
      "cityname": "Lenexa",
      "statename": "Kansas"
   },
   "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": ""
}