New York Sign Company

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 340420,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.newyorksigncompany.net/",
      "title": "New York Sign Company",
      "description": "New York Sign Company provides the signage you need to attract new customers and provide them with an outstanding experience that keeps them coming back for more. We are a leading sign maker offering customers an array of signage solutions. Our team designs and installs custom commercial signs on business storefronts and facades, lobbies, corporate vehicles, and more. Our New York sign company knows that without impactful signage, it can be a real challenge to attract new customers and clients to your business. That is why we focus on making it easy for you to get the right signs for your business.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 91117,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-01-08T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 4,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 31,
      "city_id": 15257,
      "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": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "c74f821d-cdbd-11ef-a909-b66e99367f32",
      "subdate": "Jan 08, 2025",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 25
   },
   "visits": {
      "storefront": 25,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 6,
      "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": "2025-01-08 12:40:45"
   },
   "location": {
      "uuid": "c74f821d-cdbd-11ef-a909-b66e99367f32",
      "link_id": 340420,
      "account_id": 91117,
      "company": "New York Sign Company",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 31,
      "city": "15257",
      "zip": "10801",
      "address": "57 Grand St, COMM1, New Rochelle, NY 10801",
      "phone": "(917) 508-0601",
      "fax": null,
      "email": "newyorksigncompanynyc@gmail.com",
      "name": "New York Sign Company",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "40.9125963",
      "lon": "-73.7852834",
      "cityname": "New Rochelle",
      "statename": "New York"
   },
   "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": ""
}