Trifusion Foundation Repair

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 333107,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.trifusionfoundationrepair.com/",
      "title": "Trifusion Foundation Repair",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 83884,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-07-17T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 15,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 35,
      "city_id": 17824,
      "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": 5851,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9078acb8-4431-11ef-8344-b66e99367f32",
      "subdate": "Jul 17, 2024",
      "subcategory": "Concrete Contractors",
      "request_types": "",
      "visitcount": 66
   },
   "visits": {
      "storefront": 66,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 9,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Trifusion Foundation Repair is your trusted local partner for foundation repair services in Broken Arrow, Tulsa, Sand Springs, Jenks, Bixby, Bartlesville, Collinsville, Sapulpa and all NE OK. With over 30 years of dedicated service, our commitment to excellence is reflected in our same-day response to foundation emergencies, ensuring your peace of mind. At Trifusion Foundation Repair, we specialize in a full range of foundation repairs: steel pier, polyurethane injections and more.",
      "service1": "crawl space",
      "service2": "steel piers",
      "service3": "polyurethane injection",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-07-17 11:41:53"
   },
   "location": {
      "uuid": "9078acb8-4431-11ef-8344-b66e99367f32",
      "link_id": 333107,
      "account_id": 83884,
      "company": "Trifusion Foundation Repair",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 35,
      "city": "17824",
      "zip": "74012",
      "address": "2104 North Yellowood Avenue",
      "phone": "+1 918-398-9070",
      "fax": null,
      "email": "trifusionfoundation@brite-email.com",
      "name": "Trifusion Foundation Repair",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "36.0725006",
      "lon": "-95.8417113",
      "cityname": "Broken Arrow",
      "statename": "Oklahoma"
   },
   "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": ""
}