Clean Stream Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348528,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.cleanstreamplumbing.com/",
      "title": "Clean Stream Plumbing",
      "description": "Clean Stream Plumbing is your go-to solution for all plumbing needs in Ottawa. Our expert plumbers offer various services, from general plumbing repairs to emergency plumbing assistance, drain cleaning, water filtration, water softener, water heater repair, sump pump installation, and many more.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 99223,
      "approve_dt": "2025-07-13T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-11T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 3,
      "referrals": null,
      "country": 99,
      "countrycode": "CA",
      "loc_id": 99,
      "state_id": 0,
      "city_id": 161,
      "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": 5009,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "c8b5d039-46be-11f0-a909-b66e99367f32",
      "subdate": "Jun 11, 2025",
      "subcategory": "Home Plumbing",
      "request_types": "",
      "visitcount": 71
   },
   "visits": {
      "storefront": 71,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 17,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "At Clean Stream Plumbing, we offer a wide variety of plumbing services and take pride in our attention to detail. Our number one priority is ensuring our customers are fully satisfied once the work is completed. We proudly serve Winchester, Ottawa, and the surrounding communities with reliable, high-quality plumbing solutions. Our experienced team is committed to delivering exceptional workmanship and customer service for all your residential and commercial plumbing needs\n",
      "service1": "Emergency Plumbing Repairs",
      "service2": " Drain Cleaning and Unclogging",
      "service3": " Water Heater Installation and Repair",
      "service4": " Pipe Replacement and Repiping",
      "service5": " Bathroom and Kitchen Plumbing",
      "service6": " Sewer Line Services",
      "service7": " Leak Detection and Repair",
      "submit_dt": "2025-06-11 12:22:47"
   },
   "location": {
      "uuid": "c8b5d039-46be-11f0-a909-b66e99367f32",
      "link_id": 348528,
      "account_id": 99223,
      "company": "Clean Stream Plumbing",
      "sid": 66,
      "country": 99,
      "countrycode": "CA",
      "state": 0,
      "city": "161",
      "zip": "K0C 2K0",
      "address": "453 Clarence Street, Winchester, ON, Canada",
      "phone": "6138674082",
      "fax": null,
      "email": "cleanstreamplumbing7@gmail.com",
      "name": "Clean Stream Plumbing",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "45.0916105",
      "lon": "-75.3477075",
      "cityname": "Ottawa",
      "statename": ""
   },
   "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": ""
}