CertaPro Painters of Loudoun

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 308176,
      "site_id": 0,
      "cat_id": 11,
      "priority": 0,
      "url": "http://sterling.certapro.com",
      "title": "CertaPro Painters of Loudoun",
      "description": "CertaPro Painters of Loudoun 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.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 59404,
      "approve_dt": "2014-06-13T00:00:00.000Z",
      "source": null,
      "submit_dt": "2014-06-12T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 4273,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 45,
      "city_id": 0,
      "ltop": "",
      "facebook": "https://www.facebook.com/certaproloudoun",
      "tiktok": "",
      "linkedin": "http://www.linkedin.com/pub/certapro-loudoun/39/917/552",
      "twitter": "https://twitter.com/CertaProLoudoun/with_replies",
      "googleplus": "https://plus.google.com/114346606396697558627/about",
      "youtube_channel": "https://www.youtube.com/watch?v=FTLMf473E5k",
      "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": "png",
      "screen_ext": "jpg",
      "pack_id": null,
      "uuid": "951ccb2d-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jun 12, 2014",
      "subcategory": "Painting Contractors",
      "request_types": "",
      "visitcount": 4770
   },
   "visits": {
      "storefront": 4770,
      "articles": 0,
      "videos": 0,
      "reviews": 33,
      "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": "Phone: (571) 348-0630 . \r
CertaPro Painters of Loudoun 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.",
      "service1": "interior painting, exterior painting, commercial painting, residential pain",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2014-06-12 04:25:40"
   },
   "location": {
      "uuid": "951ccb2d-56da-11ed-b77c-b66e99367f32",
      "link_id": 308176,
      "account_id": 59404,
      "company": "CertaPro Painters of Loudoun",
      "sid": 0,
      "country": 277,
      "countrycode": "US",
      "state": 45,
      "city": "",
      "zip": "20164",
      "address": "111 Carpenter Drive #200a, Sterling, VA",
      "phone": "",
      "fax": "",
      "email": "certapro_loudoun@viziamail.com",
      "name": "CertaPro Painters of Loudoun",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "35.0461954",
      "lon": "-88.4470541"
   },
   "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": ""
}