CertaPro Painters of Palatine

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 303933,
      "site_id": 58,
      "cat_id": 53,
      "priority": 0,
      "url": "http://northwest-suburbs.certapro.com",
      "title": "CertaPro Painters of Palatine",
      "description": "With every house painting service project, our house painters are committed to providing the highest quality work and professional service in the area. Residential painting or commercial painting, we're dedicated to the process of certainty - of a job well done. Whatever your needs, big or small, CertaPro Painters of Palatine's house painters  will provide a professional quality paint job and an experience you'll be thrilled with. That's our promise, that's Certainty.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 53487,
      "approve_dt": "2012-09-15T00:00:00.000Z",
      "source": null,
      "submit_dt": "2012-09-15T00:00:00.000Z",
      "filler": null,
      "points": 100,
      "ppc_remain": 0,
      "ppc_points": 0,
      "link_points": 122,
      "clickcount": 4562,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 13,
      "city_id": 5969,
      "ltop": "",
      "facebook": "",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "https://plus.google.com/105593231607366777324/about?hl=en",
      "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": 4179,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "jpg",
      "pack_id": null,
      "uuid": "952ebbab-56da-11ed-b77c-b66e99367f32",
      "subdate": "Sep 15, 2012",
      "subcategory": "Painting",
      "request_types": "",
      "visitcount": 4940
   },
   "visits": {
      "storefront": 4940,
      "articles": 0,
      "videos": 0,
      "reviews": 24,
      "coupons": 0,
      "products": 0,
      "social": 20,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "With every housepainting serviceproject, ourhouse paintersare committed to providing the highest qualitywork and professional service in the area.Residential paintingor commercial painting, we're dedicated to the process of certainty - of a job well done. Whatever your needs, big or small,CertaPro Painters of Palatine'shouse painterswill provide a professional qualitypaint joband an experience you'll be thrilled with.That's our promise, that's Certainty.",
      "service1": "power washing",
      "service2": "deck staining",
      "service3": "exterior painting",
      "service4": "drywall repair",
      "service5": "interior painting",
      "service6": "carpentry services",
      "service7": "",
      "submit_dt": "2015-04-08 09:00:59"
   },
   "location": {
      "uuid": "952ebbab-56da-11ed-b77c-b66e99367f32",
      "link_id": 303933,
      "account_id": 53487,
      "company": "CertaPro Painters of Palatine",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 13,
      "city": "5969",
      "zip": "60067",
      "address": "331 W Northwest Hwy, #204",
      "phone": "(800) 462-3782",
      "fax": "",
      "email": "certapro.painters.palatine@gmail.com",
      "name": "CertaPro Painters of Palatine",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "42.1225175",
      "lon": "-88.0522104",
      "cityname": "Palatine",
      "statename": "Illinois"
   },
   "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": ""
}