Predictable Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 346333,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "http://predictableplumbing.com",
      "title": "Predictable Plumbing",
      "description": "Your trusted residential plumbing experts serving Phoenix and the Twin Cities metro with reliable, honest service and clear communication. Our licensed plumbers bring a minimum of five years experience to every job, providing upfront pricing, hassle-free scheduling, and 100% satisfaction guarantee. We keep things simple and stress-free so you can get back to normal faster.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 97028,
      "approve_dt": "2025-08-13T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-03T00: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": 23,
      "city_id": 11243,
      "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": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "3f34600f-2823-11f0-a909-b66e99367f32",
      "subdate": "May 03, 2025",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 44
   },
   "visits": {
      "storefront": 44,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 7,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "As a family-owned business, we care about the same things you do: honesty, professionalism, and respect. Our plumbers are experienced, fully licensed for plumbing in Minneapolis and the twin cities, and focused on doing the job right. We're always predictable, explain things clearly, and clean up after ourselves-guaranteed. Whether you need help with your water heater, or any plumbing repair, we're here to serve you and your family.",
      "service1": "Water heater repair and installation",
      "service2": "water treatment",
      "service3": "sump pump repair",
      "service4": "water softener",
      "service5": "tankless water heater",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-05-03 13:33:50"
   },
   "location": {
      "uuid": "3f34600f-2823-11f0-a909-b66e99367f32",
      "link_id": 346333,
      "account_id": 97028,
      "company": "Predictable Plumbing",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 23,
      "city": "11243",
      "zip": "55357",
      "address": "5475 Town Hall Dr",
      "phone": "612-900-2026",
      "fax": null,
      "email": "predictableplb@brite-post.com",
      "name": "Predictable Plumbing",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "45.0738233",
      "lon": "-93.6641261",
      "cityname": "Loretto",
      "statename": "Minnesota"
   },
   "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": ""
}