Rossco Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 344711,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://rosscoplumbing.com",
      "title": "Rossco Plumbing",
      "description": "Rossco Plumbing is Vancouver, WA's trusted plumbing expert, proudly serving Clark County residents for nearly a decade with professional, reliable service at transparent flat-rate prices. Our team of Licensed Certified Master Plumbers is committed to delivering excellence on every project, from routine maintenance to complex repairs and installations. When you call Rossco Plumbing at 360-218-2986, you'll experience five-star customer service from start to finish—beginning with our courteous team answering your call and continuing through to job completion. We understand that plumbing issues can disrupt your home and daily life, which is why we prioritize quality workmanship, honest pricing, and respectful service that puts your needs first. Whether you're dealing with an emergency or planning an upgrade, you can trust that your home is in good hands with our experienced professionals.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95406,
      "approve_dt": "2025-10-29T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-04-03T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 5,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 46,
      "city_id": 23546,
      "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": 5035,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "af70a9ca-1048-11f0-a909-b66e99367f32",
      "subdate": "Apr 03, 2025",
      "subcategory": "Emergency Plumber",
      "request_types": "",
      "visitcount": 56
   },
   "visits": {
      "storefront": 56,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 19,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Serving Battle Ground, Vancouver, Longview and the surrounding areas, Rossco Plumbing specializes in plumbing and restoration services. With 8 years of industry experience, we are committed to delivering excellence in every job, offering flat-rate pricing and flexible scheduling to meet our clients' needs. Our team, carefully selected for their integrity and professionalism, upholds our core values of honesty, quality, and reliability. Rossco Plumbing  is the preferred choice for plumbing and restoration work in Battle Ground, Longview, Vancouver, and the surrounding areas. Get in touch with us today to see why our expertise and dedication have earned us a strong reputation in the community.",
      "service1": "emergency plumbing repairs",
      "service2": " drain cleaning and unclogging",
      "service3": " water heater installation and repair",
      "service4": " leak detection and repair",
      "service5": " pipe repair and replacement",
      "service6": " plumbing fixture installation",
      "service7": " sewer line services",
      "submit_dt": "2025-04-03 05:01:21"
   },
   "location": {
      "uuid": "af70a9ca-1048-11f0-a909-b66e99367f32",
      "link_id": 344711,
      "account_id": 95406,
      "company": "Rossco Plumbing",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 46,
      "city": "23546",
      "zip": "",
      "address": "819 SE 14th Loop suite 101i",
      "phone": "360-207-0076",
      "fax": null,
      "email": "rosscoplumbingwa@gmail.com",
      "name": "Rossco Plumbing",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "45.7748493",
      "lon": "-122.5230902",
      "cityname": "Battle Ground",
      "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": ""
}