{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 345653,
"site_id": 6,
"cat_id": 39,
"priority": 2,
"url": "https://spartanfoundationrepair.com/columbia/?utm_source=Google%2BBusiness%2BProfile&utm_medium=organic&utm_campaign=columbia",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 96348,
"approve_dt": null,
"source": null,
"submit_dt": "2025-04-21T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 2,
"referrals": null,
"country": 277,
"countrycode": "US",
"loc_id": 277,
"state_id": 25,
"city_id": 12167,
"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": 288,
"d_url": null,
"approved": null,
"logo_ext": "jpg",
"screen_ext": "png",
"pack_id": null,
"uuid": "ecfdbfe8-1e94-11f0-a909-b66e99367f32",
"subdate": "Apr 21, 2025",
"subcategory": "Home And Garden",
"request_types": "",
"visitcount": 26
},
"visits": {
"storefront": 26,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 12,
"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. For over 10 years, your locally owned Spartan Ram Jack Columbia, MO has served all over Columbia and Jefferson City providing the best foundation repair, waterproofing services, and concrete lifting & leveling services around. When you choose Spartan Ram Jack Columbia you choose American-made products, proven quality, and trusted expertise. Trust Spartan Ram Jack Columbia to provide you with the solution your home needs.",
"service1": "Foundation Repair",
"service2": "House Lifting",
"service3": "Exterior Waterproofing",
"service4": "Interior Waterproofing",
"service5": "Basement Waterproofing",
"service6": "",
"service7": "",
"submit_dt": "2025-04-21 09:42:22"
},
"location": {
"uuid": "ecfdbfe8-1e94-11f0-a909-b66e99367f32",
"link_id": 345653,
"account_id": 96348,
"company": "Spartan Ram Jack Foundation Repair & Waterproofing - Columbia",
"sid": 6,
"country": 277,
"countrycode": "US",
"state": 25,
"city": "12167",
"zip": "65202",
"address": "1495 Old U.S. 40, Suite B",
"phone": "+1 573-233-1117",
"fax": null,
"email": "spartanramjackmo@brite-email.com",
"name": "Spartan Ram Jack Foundation Repair & Waterproofing - Columbia",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "38.9550974",
"lon": "-92.1384592",
"cityname": "Columbia",
"statename": "Missouri"
},
"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": ""
}
all our featured social media
