Yarde Metals

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 337282,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.yarde.com/",
      "title": "Yarde Metals",
      "description": "Yarde Metals is a premier metal service center offering a wide selection of certified aluminum, stainless, carbon, and brass products for various industries, including aerospace, construction, and manufacturing. The company is ISO9001:2015 and AS9100D certified, ensuring high-quality standards. Yarde also provides custom processing services, such as cutting, shearing, and edge conditioning. Customers can benefit from Yarde''s Drop Zone, which features discounted remnants from certified mill stock, and an online division, Fast Metals, for quick-turnaround small orders.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 88013,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-10-25T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 7,
      "city_id": 3139,
      "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": 220,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "8c60cae3-929d-11ef-ab46-b66e99367f32",
      "subdate": "Oct 25, 2024",
      "subcategory": "Auto Repair",
      "request_types": "",
      "visitcount": 49
   },
   "visits": {
      "storefront": 49,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-10-25 06:51:23"
   },
   "location": {
      "uuid": "8c60cae3-929d-11ef-ab46-b66e99367f32",
      "link_id": 337282,
      "account_id": 88013,
      "company": "Yarde Metals",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 7,
      "city": "3139",
      "zip": "06489",
      "address": "45 Newell St ",
      "phone": "1-860-406-6061",
      "fax": null,
      "email": "yardemetals75@gmail.com",
      "name": "Yarde Metals",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "41.6439014",
      "lon": "-72.8772722",
      "cityname": "South Windham",
      "statename": "Connecticut"
   },
   "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": ""
}