Reflection Signs and Graphics

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 321261,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://reflectionsigns.com/",
      "title": "Reflection Signs and Graphics",
      "description": "Reflection Signs is a full-service commercial sign company serving Colorado and the Front Range. We have on-site graphic sign designers and experienced project managers who will manage the exterior sign process from site survey to permit procurement to sign installation. We manage the entire commercial outdoor business sign project from conception to installation.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 72453,
      "approve_dt": "2021-12-16T00:00:00.000Z",
      "source": null,
      "submit_dt": "2021-09-16T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 589,
      "referrals": null,
      "country": 106,
      "countrycode": "",
      "loc_id": 106,
      "state_id": 0,
      "city_id": 0,
      "ltop": "",
      "facebook": "https://www.facebook.com/ReflectionSignsAndGraphics/",
      "tiktok": null,
      "linkedin": "https://www.linkedin.com/company/reflection-signs-and-graphics/",
      "twitter": "https://twitter.com/COSignBoss",
      "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": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95842380-56da-11ed-b77c-b66e99367f32",
      "subdate": "Sep 16, 2021",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 814
   },
   "visits": {
      "storefront": 814,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 23,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Reflection Signs is a full-service commercial sign company serving Colorado and the Front Range. We have on-site graphic sign designers and experienced project managers who will manage the exterior sign process from site survey to permit procurement to sign installation. We manage the entire commercial outdoor business sign project from conception to installation.",
      "service1": "exterior signs",
      "service2": " sign permits and site surveys",
      "service3": " window films",
      "service4": " sign design",
      "service5": " interior signs",
      "service6": "",
      "service7": "",
      "submit_dt": "2021-09-16 09:50:17"
   },
   "location": {
      "uuid": "95842380-56da-11ed-b77c-b66e99367f32",
      "link_id": 321261,
      "account_id": 72453,
      "company": "Reflection Signs and Graphics",
      "sid": 6,
      "country": 106,
      "countrycode": "",
      "state": 0,
      "city": "0",
      "zip": "80246",
      "address": "501 S. Cherry St, #1100  Denver, CO 80246",
      "phone": "303-450-3255",
      "fax": null,
      "email": "reflectionsigns@aol.com",
      "name": "Reflection Signs and Graphics",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "39.7069002",
      "lon": "-104.9344136",
      "statename": ""
   },
   "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": ""
}