Mueller Insurance Services, LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349575,
      "site_id": 7,
      "cat_id": 70,
      "priority": 0,
      "url": "https://muellerinsuranceservices.com/",
      "title": "Mueller Insurance Services, LLC",
      "description": "Trusted insurance broker in St. Louis, MO. Get the best home, auto, and business insurance rates in Missouri. Compare quotes & save today!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100270,
      "approve_dt": "2025-07-25T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-07-24T00: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": 25,
      "city_id": 12264,
      "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": 29,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "ba4eef29-68e8-11f0-a909-b66e99367f32",
      "subdate": "Jul 24, 2025",
      "subcategory": "Home Insurance",
      "request_types": "",
      "visitcount": 44
   },
   "visits": {
      "storefront": 44,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 21,
      "services": 22,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 17
   },
   "services": {
      "service_description": "Mueller Insurance Services is an experienced independent insurance agency dedicated to serving as your trusted protection partner. We specialize in delivering customized insurance solutions tailored to meet your unique personal, business, and specialty coverage needs, guiding clients through every step of the insurance process with expert care and commitment.",
      "service1": "Life insurance",
      "service2": "car insurance",
      "service3": "home insurance",
      "service4": "Umbrella Insurance",
      "service5": "business insurance",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-07-24 23:48:41"
   },
   "location": {
      "uuid": "ba4eef29-68e8-11f0-a909-b66e99367f32",
      "link_id": 349575,
      "account_id": 100270,
      "company": "Mueller Insurance Services | David Mueller",
      "sid": 7,
      "country": 277,
      "countrycode": "US",
      "state": 25,
      "city": "12264",
      "zip": "63026",
      "address": "1799 Smizer Station Rd Suite 200A",
      "phone": "+13146390020",
      "fax": null,
      "email": "muellerinsuranceservicesllc@gmail.com",
      "name": "Mueller Insurance Services, LLC",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Fenton",
      "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": 1
      },
      {
         "item": "article_external",
         "cnt": 0
      },
      {
         "item": "video_external",
         "cnt": 0
      },
      {
         "item": "product_external",
         "cnt": 0
      },
      {
         "item": "coupon_external",
         "cnt": 0
      },
      {
         "item": "service_external",
         "cnt": 1
      }
   ],
   "featuredproduct": ""
}