TCH Co.

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349824,
      "site_id": 58,
      "cat_id": 53,
      "priority": 0,
      "url": "https://tchco.com/",
      "title": "TCH Co.",
      "description": "https://tchco.com/ : TCH offers comprehensive safety, security, and convenience solutions for all types of buildings—whether it’s new construction, facility upgrades, aftermarket projects, or national and enterprise accounts. We deliver customized systems that include doors, frames, hardware, access control, surveillance cameras, and restroom accessories. Backed by over 140 years of industry experience, we help ensure your buildings are secure, efficient, and prepared for the future. Contact us today.\n723 Hadley Ave N, Oakdale, Minnesota 55128",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100519,
      "approve_dt": "2025-09-13T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-08-25T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 23,
      "city_id": 11357,
      "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": 4177,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "d55aa6e1-8178-11f0-bb42-b66e99367f32",
      "subdate": "Aug 25, 2025",
      "subcategory": "Doors",
      "request_types": "",
      "visitcount": 40
   },
   "visits": {
      "storefront": 40,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 24,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "https://tchco.com/ : TCH offers comprehensive safety, security, and convenience solutions for all types of buildings—whether it’s new construction, facility upgrades, aftermarket projects, or national and enterprise accounts. We deliver customized systems that include doors, frames, hardware, access control, surveillance cameras, and restroom accessories. Backed by over 140 years of industry experience, we help ensure your buildings are secure, efficient, and prepared for the future. Contact us today.\n723 Hadley Ave N, Oakdale, Minnesota 55128",
      "service1": "Commercial Wood Doors\\",
      "service2": "Emergency Exit Devices",
      "service3": "Commercial-Door-Frames",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-08-25 06:00:42"
   },
   "location": {
      "uuid": "d55aa6e1-8178-11f0-bb42-b66e99367f32",
      "link_id": 349824,
      "account_id": 100519,
      "company": "tchco marketing",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 23,
      "city": "11357",
      "zip": "55128",
      "address": "723 Hadley Ave N",
      "phone": "(651) 735-2200",
      "fax": null,
      "email": "tchco.marketing1@outlook.com",
      "name": "TCH Co.",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Oakdale",
      "statename": "Minnesota"
   },
   "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": ""
}