Charlie McNabb Painting

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349478,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "https://charliemcnabbpainting.com",
      "title": "Charlie McNabb Painting",
      "description": "\nPainting Contractor in Lakeport, CA \n\nPainting Contractor, House Painting, Residential Painting, Commercial Painting, Interior Painting, Painters , House Painters, Painting Company , Exterior Painting, Apartment Painting \n        \n\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100173,
      "approve_dt": "2025-07-19T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-07-19T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2111,
      "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": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "6f7533c5-6463-11f0-a909-b66e99367f32",
      "subdate": "Jul 19, 2025",
      "subcategory": "Painting Contractors",
      "request_types": "",
      "visitcount": 42
   },
   "visits": {
      "storefront": 42,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 19,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Charlie McNabb Painting is a well-established painting contractor serving Kelseyville, California since 1998. As a highly rated company specializing in residential and commercial painting services, they are committed to delivering the highest quality work on schedule and under budget. With experienced, professional, and courteous workers, Charlie McNabb Painting has built a strong reputation in the community for reliable service and exceptional results for both homes and businesses.",
      "service1": "house painting",
      "service2": " residential painting",
      "service3": " commercial painting",
      "service4": " interior painting",
      "service5": " exterior painting",
      "service6": " surface preparation",
      "service7": " paint consultation",
      "submit_dt": "2025-07-19 05:44:28"
   },
   "location": {
      "uuid": "6f7533c5-6463-11f0-a909-b66e99367f32",
      "link_id": 349478,
      "account_id": 100173,
      "company": "Charlie McNabb Painting",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2111",
      "zip": "95453",
      "address": "1200 11th St ",
      "phone": "707-278-0507",
      "fax": null,
      "email": "charliemcnabbpainting@protonmail.com",
      "name": "Charlie McNabb Painting",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Lakeport",
      "statename": "California"
   },
   "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": ""
}