Vancouver Plumbing and Drain Services | Roto Pro

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 350343,
      "site_id": 66,
      "cat_id": 78,
      "priority": 0,
      "url": "https://24hourrotopro.com",
      "title": "Vancouver Plumbing and Drain Services | Roto Pro",
      "description": "Roto Pro - Plumbing and Drain in Vancouver, WA and all of Clark County. Roto Pro is a licensed general contractor serving Vancouver, WA and the greater Clark County area. The company specializes in sewer, septic, drainage, and utility services that keep homes and businesses safe, reliable, and code compliant. While Roto Pro does not perform interior plumbing, the team focuses on the heavy excavation, installation, and exterior site work that supports plumbing systems and protects properties for the long term.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 101037,
      "approve_dt": "2025-10-14T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-10-14T00: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": 46,
      "city_id": 23992,
      "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": 5018,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "28f6a178-a8c3-11f0-bb42-b66e99367f32",
      "subdate": "Oct 14, 2025",
      "subcategory": "General Plumbing",
      "request_types": "",
      "visitcount": 23
   },
   "visits": {
      "storefront": 23,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Roto Pro provides plumbing and drain services in Clark County and Vancouver, Washington.  A certified general contractor, Roto Pro serves the larger Clark County area as well as Vancouver, Washington.  The business specializes in utility, drainage, septic, and sewer services that maintain homes and businesses secure, dependable, and in compliance with codes.  Roto Pro focuses on the extensive excavation, installation, and external site work that maintains plumbing systems and safeguards homes over time, even though the crew does not handle interior plumbing.",
      "service1": "Hydro jetting",
      "service2": "Rooter services",
      "service3": "Drainage service",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-10-14 06:01:00"
   },
   "location": {
      "uuid": "28f6a178-a8c3-11f0-bb42-b66e99367f32",
      "link_id": 350343,
      "account_id": 101037,
      "company": "Roto Pro",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 46,
      "city": "23992",
      "zip": "98664",
      "address": "",
      "phone": "360-2227686",
      "fax": null,
      "email": "rotoprovancouver@gmail.com",
      "name": "Vancouver Plumbing and Drain Services | Roto Pro",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Vancouver",
      "statename": "Washington"
   },
   "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": ""
}