Tri-State Office Furniture, Inc.

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 319460,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.tristateofficefurniture.com/",
      "title": "Tri-State Office Furniture, Inc.",
      "description": "Tri-State Office Furniture, Inc. has the huge selection of new, remanufactured, and used office furniture including task chairs, guest chairs and stacking chairs, cubicles, workstations, desks, file cabinets and storage, reception furniture, etc.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 70654,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2020-07-25T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 120,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 37,
      "city_id": 19714,
      "ltop": "",
      "facebook": "https://www.facebook.com/tristateofficefurniture/",
      "tiktok": null,
      "linkedin": "https://www.linkedin.com/organization-guest/company/tri-state-office-furniture-inc",
      "twitter": "https://twitter.com/tristateoffice",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "https://www.pinterest.com/tristate2010/",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 2745,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "957a6950-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jul 25, 2020",
      "subcategory": "Furniture",
      "request_types": "",
      "visitcount": 192
   },
   "visits": {
      "storefront": 192,
      "articles": 0,
      "videos": 0,
      "reviews": 14,
      "coupons": 0,
      "products": 0,
      "social": 6,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Tri-State Office Furniture, Inc. has the huge selection of new, remanufactured, and used office furniture including task chairs, guest chairs and stacking chairs, cubicles, workstations, desks, file cabinets and storage, reception furniture, etc.",
      "service1": "Furniture Store Near Me",
      "service2": "Office Separator",
      "service3": "Office Space Dividers",
      "service4": "Used Chairs",
      "service5": "Herman Miller Aeron Chair",
      "service6": "Desks",
      "service7": "File Cabinets",
      "submit_dt": "2020-07-25 09:08:26"
   },
   "location": {
      "uuid": "957a6950-56da-11ed-b77c-b66e99367f32",
      "link_id": 319460,
      "account_id": 70654,
      "company": "Tri-State Office Furniture, Inc.",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 37,
      "city": "19714",
      "zip": "15136",
      "address": "1 Sexton Road",
      "phone": "",
      "fax": null,
      "email": "tsofurniture1@gmail.com",
      "name": "Tri-State Office Furniture, Inc.",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.4784599",
      "lon": "-80.0533533",
      "cityname": "Pittsburgh",
      "statename": "Pennsylvania"
   },
   "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": ""
}