Andrew Picone Painting & Paper Hanging, Inc.

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 319115,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://www.piconepaintingandpaperhanging.com/",
      "title": "Andrew Picone Painting & Paper Hanging, Inc.",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 70310,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2020-05-29T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 210,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 29,
      "city_id": 0,
      "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": 4179,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9578e16b-56da-11ed-b77c-b66e99367f32",
      "subdate": "May 29, 2020",
      "subcategory": "Painting",
      "request_types": "",
      "visitcount": 312
   },
   "visits": {
      "storefront": 312,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 9,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "At Andrew Picone Painting&Paper Hanging, we provide reliable, consistent, and professional painting services for northern NJ homeowners. Our professional crews are skilled at delivering exceptional and quality painting, and we are dedicated to proving our quality and craftsmanship for all interior and exterior painting projects. Schedule a Painting Estimate with the Experts at Picone Painting!",
      "service1": "Interior Painters",
      "service2": "Painting Companies",
      "service3": "Painting Contractor",
      "service4": "Painting Company",
      "service5": "Painter",
      "service6": "",
      "service7": "",
      "submit_dt": "2020-05-29 05:08:10"
   },
   "location": {
      "uuid": "9578e16b-56da-11ed-b77c-b66e99367f32",
      "link_id": 319115,
      "account_id": 70310,
      "company": "Andrew Picone Painting & Paper Hanging, Inc.",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 29,
      "city": "",
      "zip": "07933",
      "address": "60 Johnson Ave, Gillette",
      "phone": "908-464-6952",
      "fax": null,
      "email": "piconepaintingandpaperhanging1@gmail.com",
      "name": "Andrew Picone Painting & Paper Hanging, Inc.",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.6776066",
      "lon": "-74.4656828"
   },
   "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": ""
}