Ram Jack Systems Distribution, LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 334360,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.ramjack.com/ada/",
      "title": "Ram Jack Systems Distribution, LLC",
      "description": "Expert Help for Uneven Floors and Sticking Doors\r\n\r\nAt Ram Jack Oklahoma, we make sure our customers are completely satisfied with our work. More than that, we make sure to deliver systems that last—why do it twice when you can do it right the first time? Our team services Ada, Tulsa, Fort Smith, and more!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 85115,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-08-21T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 35,
      "city_id": 0,
      "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": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "8bd70779-5f62-11ef-ab46-b66e99367f32",
      "subdate": "Aug 21, 2024",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 34
   },
   "visits": {
      "storefront": 34,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 14,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "At Ram Jack Oklahoma, we make sure our customers are completely satisfied with our work. More than that, we make sure to deliver systems that last"why do it twice when you can do it right the first time? Our team services Ada, Tulsa, Fort Smith, and more!\r
",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-08-21 02:10:32"
   },
   "location": {
      "uuid": "8bd70779-5f62-11ef-ab46-b66e99367f32",
      "link_id": 334360,
      "account_id": 85115,
      "company": "Ram Jack Systems Distribution, LLC",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 35,
      "city": "",
      "zip": "74820",
      "address": "13655 Co Rd 1570",
      "phone": "(580) 332-9980",
      "fax": null,
      "email": "ramjackokl@outlook.com",
      "name": "Ram Jack Systems Distribution, LLC",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "34.7378232",
      "lon": "-96.7105509"
   },
   "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": ""
}