Motherflushers Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 331399,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://motherflushers.com/",
      "title": "Motherflushers Plumbing",
      "description": "Motherflushers Plumbing provides state-of-the-art plumbing services to homes and commercial properties throughout Modesto, and the surrounding areas. Our licensed and highly trained plumbers perform every job with the highest degree of quality, integrity, and dependabilitygoing above and beyond to ensure service that exceeds your expectations. By pairing the most advanced equipment on the market with time-tested methods, we are able to deliver results that stand the test of time.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 82194,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-06-02T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 22,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2231,
      "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": 5026,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "91ff47d9-2093-11ef-8344-b66e99367f32",
      "subdate": "Jun 02, 2024",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 80
   },
   "visits": {
      "storefront": 80,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 4,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "Drain Cleaning",
      "service2": "Leak Detection",
      "service3": "Water Heaters",
      "service4": "Plumbing Installation",
      "service5": "Piping Services",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-06-02 03:52:46"
   },
   "location": {
      "uuid": "91ff47d9-2093-11ef-8344-b66e99367f32",
      "link_id": 331399,
      "account_id": 82194,
      "company": "Motherflushers Plumbing",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2231",
      "zip": "95354",
      "address": "931 10th Street, Suite 810",
      "phone": "(760) 475-8132",
      "fax": null,
      "email": "motherflushmod@brite-mail.com",
      "name": "Motherflushers Plumbing",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "37.6398548",
      "lon": "-121.0000666",
      "cityname": "Modesto",
      "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": ""
}