CertaPro Painters of Clifton provides residential and commercial painting services

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 308987,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "http://clifton.certapro.com/",
      "title": "CertaPro Painters of Clifton provides residential and commercial painting services",
      "description": "CertaPro Painters of Clifton provides residential and commercial painting services. From prep, priming and painting to carpentry repairs, from specialty coating to help with color selection, we are the painting company for all your painting needs. Call us today to schedule a free painting consultation.\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 60223,
      "approve_dt": "2015-04-07T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-03-15T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 3948,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 29,
      "city_id": 0,
      "ltop": "",
      "facebook": "https://www.facebook.com/certapropaintersusa",
      "tiktok": "",
      "linkedin": "",
      "twitter": "https://twitter.com/CertaPro",
      "googleplus": "https://plus.google.com/108821395987662411822",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 5875,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "jpg",
      "pack_id": null,
      "uuid": "95455474-56da-11ed-b77c-b66e99367f32",
      "subdate": "Mar 15, 2015",
      "subcategory": "Painting Contractors",
      "request_types": "",
      "visitcount": 4371
   },
   "visits": {
      "storefront": 4371,
      "articles": 0,
      "videos": 0,
      "reviews": 28,
      "coupons": 0,
      "products": 0,
      "social": 7,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "CertaPro Painters of Clifton, NJ\nBergen & Passaic Counties:Clifton, Little Falls, Woodland Park, Passaic, Paterson, Carlstadt, East Rutherford, Elmwood Park, Fair Lawn, Hasbrouck Heights, Rochelle Park, Rutherford, Saddle Brook, Garfield, Hackensack, Little Ferry, Teaneck, Lodi, Lyndhurst, Maywood, Moonachie, North Arlington, South Hackensack, Teterboro, Wallington, Wood-Ridge, Bloomfield, Fairfield, Caldwell, Cedar Grove, Glen Ridge, Montclair, Pinebrook, Belleville, Nutley",
      "service1": "Painter",
      "service2": " Painting Company",
      "service3": " Painting Services",
      "service4": " Residential Painters",
      "service5": " Commercial Painters",
      "service6": " House Painters",
      "service7": " Interior Painting Services",
      "submit_dt": "2015-03-15 19:46:31"
   },
   "location": {
      "uuid": "95455474-56da-11ed-b77c-b66e99367f32",
      "link_id": 308987,
      "account_id": 60223,
      "company": "CertaPro Painters",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 29,
      "city": "",
      "zip": "07607",
      "address": "130 West Pleasant Avenue, Suite: #170 ",
      "phone": "",
      "fax": "",
      "email": "",
      "name": "",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.9157112",
      "lon": "-95.2694712"
   },
   "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": ""
}