Sawyer Plumbing And Electric

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 324571,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://sawyerplumbingandelectric.com/",
      "title": "Sawyer Plumbing And Electric",
      "description": "Sawyer Plumbing and Electric is a trusted provider of professional plumbing and electrical services for both residential and commercial clients. They offer a comprehensive range of services tailored to meet the unique needs of each client, from routine plumbing maintenance and repairs to complex electrical installations and upgrades. Sawyer Plumbing and Electric is based in Rathdrum, Idaho. We offer Plumbing %38 Electrical service to North Idaho and plumbing service to Eastern Washington. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 75577,
      "approve_dt": "2023-04-10T00:00:00.000Z",
      "source": null,
      "submit_dt": "2023-04-06T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 329,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 12,
      "city_id": 5018,
      "ltop": "",
      "facebook": "https://www.facebook.com/sawyerplumbingelectric/",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 5732,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "aa9b1300-d43b-11ed-b5b4-b66e99367f32",
      "subdate": "Apr 06, 2023",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 471
   },
   "visits": {
      "storefront": 471,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 6,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We are licensed and insured, and provide services such as leak detection, faucet, and toilet repairs, drain cleaning, water heater installation, and repair, as well as panel upgrades, lighting installation, rewiring, and troubleshooting electrical issues. We prioritize customer satisfaction and provide personalized solutions to fit their budget and schedule, maintaining long-term relationships with their clients.\n\nAt Sawyer Plumbing and Electric, we solve your plumbing problems and get you back up and running. We work with Commercial and Multi Family plumbing customers. Call today!",
      "service1": "Plumbing & Electrical service to North Idaho",
      "service2": " Emergency Plumbing",
      "service3": "  Leak detection",
      "service4": " Faucet and toilet repairs",
      "service5": " Drain cleaning",
      "service6": " Water heater installation",
      "service7": "",
      "submit_dt": "2023-04-06 05:27:04"
   },
   "location": {
      "uuid": "aa9b1300-d43b-11ed-b5b4-b66e99367f32",
      "link_id": 324571,
      "account_id": 75577,
      "company": "Sawyer Plumbing And Electric",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 12,
      "city": "5018",
      "zip": "83858",
      "address": "14020 N Thayer St.",
      "phone": "(208)-777-7878",
      "fax": null,
      "email": "sawyerplumbingandelectric@gmail.com",
      "name": "Sawyer Plumbing And Electric",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "47.7995048",
      "lon": "-116.8768569",
      "cityname": "Rathdrum",
      "statename": "Idaho"
   },
   "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": ""
}