Avon Lake Sheet Metal Company, Inc.

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317325,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "http://www.avonlakesheetmetal.com",
      "title": "Avon Lake Sheet Metal Company, Inc.",
      "description": "Avon Lake Sheet Metal Company Inc. has been in the business of custom fabrication and contracting services for sheet metal and structural steel since 1953. Our main lines of business include sheet metal fabrication, structural fabrication, industrial contracting, and HVAC contracting. We produce high quality productsusing CNC laser cutting, CNC forming, certified welding and other value added services. Visitour website for more information.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68523,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-06-21T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 125,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 34,
      "city_id": 16740,
      "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": 5732,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "956f2b18-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jun 21, 2019",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 175
   },
   "visits": {
      "storefront": 175,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 7,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Avon Lake Sheet Metal Company Inc. has been in the business of custom fabrication and contracting services for sheet metal and structural steel since 1953. Our main lines of business include sheet metal fabrication, structural fabrication, industrial contracting, and HVAC contracting. We produce high quality productsusing CNC laser cutting, CNC forming, certified welding and other value added services. Visitour website for more information.",
      "service1": "tig welding cleveland",
      "service2": "cnc laser cutter cleveland",
      "service3": "cnc plasma cutting cleveland",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-06-21 12:18:03"
   },
   "location": {
      "uuid": "956f2b18-56da-11ed-b77c-b66e99367f32",
      "link_id": 317325,
      "account_id": 68523,
      "company": "Avon Lake Sheet Metal Company, Inc.",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 34,
      "city": "16740",
      "zip": "44012",
      "address": "33574 Pin Oak Parkway",
      "phone": "440-933-3505",
      "fax": null,
      "email": "info.avonlakesheetmetal@gmail.com",
      "name": "Avon Lake Sheet Metal Company, Inc.",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "41.4823585",
      "lon": "-82.040288",
      "cityname": "Avon Lake",
      "statename": "Ohio"
   },
   "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": ""
}