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": "Spartan Ram Jack is an experienced residential and commercial structural repair specialist providing thorough inspections and custom solutions for foundation and waterproofing issues, backed by industry-leading products and trusted warranties.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95850,
      "approve_dt": "2025-10-13T00:00:00.000Z",
      "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": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "97c91aa2-16a3-11f0-a909-b66e99367f32",
      "subdate": "Apr 11, 2025",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 42
   },
   "visits": {
      "storefront": 42,
      "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": "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": "Foundation repair",
      "service2": " Waterproofing solutions",
      "service3": " Foundation wall repair",
      "service4": " Structural inspections",
      "service5": " Commercial structural repair",
      "service6": " Residential foundation services",
      "service7": " Basement waterproofing",
      "submit_dt": "2025-04-11 07:07:13"
   },
   "location": {
      "uuid": "97c91aa2-16a3-11f0-a909-b66e99367f32",
      "link_id": 345155,
      "account_id": 95850,
      "company": "Spartan Ram Jack Foundation Repair & Waterproofing - Wichita",
      "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": ""
}