Sharper Impressions Painting Co

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 353546,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "https://www.sharperimpressionspainting.com/service-area/columbus",
      "title": "Sharper Impressions Painting Co",
      "description": "Sharper Impressions Painting is a trusted residential and commercial painting contractor serving Atlanta, Columbus, Orlando, Kansas City, Indianapolis, and Nashville. Locally owned and operated, we deliver high-quality, eco-friendly painting services tailored to each home and business. Fully licensed and insured, our skilled painters use premium materials and modern techniques to ensure exceptional results. We're committed to safety, professionalism, and a hassle-free customer experience.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 104336,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2026-05-12T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": null,
      "countrycode": null,
      "loc_id": null,
      "state_id": null,
      "city_id": null,
      "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": 5875,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "51977464-4dc5-11f1-bb42-b66e99367f32",
      "subdate": "May 12, 2026",
      "subcategory": "Painting Contractors",
      "request_types": "",
      "visitcount": 1
   },
   "visits": {
      "storefront": 1,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 0,
      "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": "2026-05-12 05:42:09"
   },
   "location": {
      "uuid": "51977464-4dc5-11f1-bb42-b66e99367f32",
      "link_id": 353546,
      "account_id": 104336,
      "company": "",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 34,
      "city": "17452",
      "zip": "43064",
      "address": "7801 Corporate Blvd",
      "phone": "(614) 889-8383",
      "fax": null,
      "email": "sharperimpressions@brite-mail.com",
      "name": "Expert Painting Services in Columbus, OH",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Plain City",
      "statename": "Ohio"
   },
   "socialmedia": [
      {
         "title": "Facebook",
         "ptype_id": 29,
         "dbtable": "links_socialmedia",
         "item": "Facebook",
         "cnt": null
      },
      {
         "title": "Instagram",
         "ptype_id": 30,
         "dbtable": "links_socialmedia",
         "item": "Instagram",
         "cnt": null
      },
      {
         "title": "Youtube",
         "ptype_id": 31,
         "dbtable": "links_socialmedia",
         "item": "Youtube Video",
         "cnt": null
      },
      {
         "title": "LinkedIn",
         "ptype_id": 32,
         "dbtable": "links_socialmedia",
         "item": "LinkedIn",
         "cnt": null
      },
      {
         "title": "TikTok",
         "ptype_id": 33,
         "dbtable": "links_socialmedia",
         "item": "TikTok",
         "cnt": null
      },
      {
         "title": "Twitter",
         "ptype_id": 34,
         "dbtable": "links_socialmedia",
         "item": "Twitter",
         "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": ""
}