Detroit MI Signs and Graphics

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 340893,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://detroitsignsandgraphics.com/",
      "title": "Detroit MI Signs and Graphics",
      "description": "Detroit MI Signs and Graphics is the trusted sign company in Detroit that you can trust. We work with you through the entire sign manufacturing process. Our role as your full-service sign partner is a responsibility that we take seriously. We work with businesses throughout South East Michigan to craft stunning signage that doesnt just demonstrate your brand, it elevates it. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 91590,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-01-16T00: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": 22,
      "city_id": 10292,
      "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": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "581fbfb1-d411-11ef-a909-b66e99367f32",
      "subdate": "Jan 16, 2025",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 30
   },
   "visits": {
      "storefront": 30,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 17,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Detroit MI Signs and Graphics is the trusted sign company in Detroit that you can trust. We work with you through the entire sign manufacturing process. Our role as your full-service sign partner is a responsibility that we take seriously. We work with businesses throughout South East Michigan to craft stunning signage that doesnt just demonstrate your brand, it elevates it.",
      "service1": "channel letters",
      "service2": "monument signs",
      "service3": "lobby signs",
      "service4": "Vinyl signs",
      "service5": "window graphics",
      "service6": "Vinyl Wall murals ",
      "service7": "vehicle graphics",
      "submit_dt": "2025-01-16 13:54:03"
   },
   "location": {
      "uuid": "581fbfb1-d411-11ef-a909-b66e99367f32",
      "link_id": 340893,
      "account_id": 91590,
      "company": "Detroit MI Signs and Graphics",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 22,
      "city": "10292",
      "zip": "48071",
      "address": "25255 Dequindre Road Madison Heights MI, 48071 US",
      "phone": "248-397-8986",
      "fax": null,
      "email": "signsandgraphicsdetroit@gmail.com",
      "name": "Detroit MI Signs and Graphics",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "42.4789713",
      "lon": "-83.0853965",
      "cityname": "Detroit",
      "statename": "Michigan"
   },
   "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": ""
}