SNL Painting, Inc.

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 346069,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.snlpainting.com/",
      "title": "SNL Painting, Inc.",
      "description": "This BBB and PCA accredited painting company specializes in providing comprehensive residential and commercial painting services throughout St. Louis and St. Charles, Missouri. With years of experience in both interior and exterior painting projects, they serve homes and businesses with professional expertise in new construction and existing properties. Their skilled team offers complete painting solutions including wall repairs, texture recreation, and color consultation to ensure customers achieve their desired results with quality workmanship and reliable service.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 96764,
      "approve_dt": "2025-08-19T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-04-29T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 25,
      "city_id": 12749,
      "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": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "7e60e109-24ac-11f0-a909-b66e99367f32",
      "subdate": "Apr 29, 2025",
      "subcategory": "Painting Contractors",
      "request_types": "",
      "visitcount": 23
   },
   "visits": {
      "storefront": 23,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We are a residential and commercial painting company with years of experience with custom painting both interiors and exteriors of homes and business throughout St. Louis and St. Charles counties.",
      "service1": "Residential interior painting",
      "service2": " Commercial exterior painting",
      "service3": " New construction painting",
      "service4": " Wall repair services",
      "service5": " Texture matching and recreation",
      "service6": " Color consultation assistance",
      "service7": " BBB accredited painting services",
      "submit_dt": "2025-04-29 03:46:12"
   },
   "location": {
      "uuid": "7e60e109-24ac-11f0-a909-b66e99367f32",
      "link_id": 346069,
      "account_id": 96764,
      "company": "SNL Painting, Inc.",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 25,
      "city": "12749",
      "zip": "63301",
      "address": "1600 Boone's Lick Rd",
      "phone": "(636) 724-6829",
      "fax": null,
      "email": "snlpaintinginc@brite-email.com",
      "name": "SNL Painting, Inc.",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "38.7747349",
      "lon": "-90.5066485",
      "cityname": "St. Charles",
      "statename": "Missouri"
   },
   "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": ""
}