BlueFire Signs & Graphics of Charlotte NC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 321752,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://bluefirevisual.com/",
      "title": "BlueFire Signs & Graphics of Charlotte NC",
      "description": "BlueFire Signs & Graphics of Charlotte, NC is a Veteran owned, full-service Commercial Printing, Custom Signs, and Display Company specializing in the production and installation of trade show graphics and event displays, architectural graphics, and custom interior branding, storefront signage, and retail point of purchase displays. BlueFire Signs & Graphics also specializes in the printing and direct mailing of publications like magazines, catalogs, newsletters, booklets, and marketing materials utilizing saddle-stitching, plastic coil, loop stitch, and perfect binding. We are a VA-certified Veteran-Owned Small Business (VOSB) and certified Small Business (SBE) with the City of Charlotte and Mecklenburg County.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 72930,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2022-02-10T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 91,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 32,
      "city_id": 15779,
      "ltop": "",
      "facebook": "https://www.facebook.com/BlueFire-Visual-104975341830844/https://www.facebook.com/BlueFire-Visual-104975341830844/",
      "tiktok": null,
      "linkedin": "https://www.linkedin.com/company/bluefire-visual",
      "twitter": "https://twitter.com/bluefirevisual",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "https://www.instagram.com/bluefire.visual/",
      "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": "9586d24d-56da-11ed-b77c-b66e99367f32",
      "subdate": "Feb 10, 2022",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 160
   },
   "visits": {
      "storefront": 160,
      "articles": 0,
      "videos": 0,
      "reviews": 17,
      "coupons": 0,
      "products": 0,
      "social": 4,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "BlueFire Signs&Graphics of Charlotte, NC is a Veteran owned, full-service Commercial Printing, Custom Signs, and Display Company specializing in the production and installation of trade show graphics and event displays, architectural graphics, and custom interior branding, storefront signage, and retail point of purchase displays. BlueFire Signs&Graphics also specializes in the printing and direct mailing of publications like magazines, catalogs, newsletters, booklets, and marketing materials utilizing saddle-stitching, plastic coil, loop stitch, and perfect binding. We are a VA-certified Veteran-Owned Small Business (VOSB) and certified Small Business (SBE) with the City of Charlotte and Mecklenburg County.",
      "service1": "storefront signage",
      "service2": "trade show graphics",
      "service3": "Custom Signs",
      "service4": "Commercial Printing",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2022-02-10 09:53:34"
   },
   "location": {
      "uuid": "9586d24d-56da-11ed-b77c-b66e99367f32",
      "link_id": 321752,
      "account_id": 72930,
      "company": "BlueFire Signs & Graphics of Charlotte NC",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 32,
      "city": "15779",
      "zip": "28208",
      "address": "2731 Interstate St Charlotte, NC 28208, United States",
      "phone": "704-655-1465",
      "fax": null,
      "email": "bluefirevisuals@gmail.com",
      "name": "BlueFire Signs & Graphics of Charlotte NC",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "35.2378299",
      "lon": "-80.9092084",
      "cityname": "Charlotte",
      "statename": "North Carolina"
   },
   "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": ""
}