Hope Plumbing LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 322045,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.hopeplumbingllc.com/",
      "title": "Hope Plumbing LLC",
      "description": "Hope Plumbling LLC is a fourth-generation family-owned business since its establishment on established 1978. We help our clients with remodels & renovations of their homes, plumbing service, and repairing & replacing water heaters. We offer a complete suite of plumbing services for any remodeling or addition and will work with our clients to ensure that they are satisfied with our project. Our mission is to provide unparalleled service and allow our work to exceed all expectations of professionalism, integrity, and effectiveness.\r\n\r\n3110 N Radiant Star Rd, Post Falls, Idaho, 83854, USA",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 73197,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2022-05-06T00: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": 12,
      "city_id": 5014,
      "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": 5877,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95888aa8-56da-11ed-b77c-b66e99367f32",
      "subdate": "May 06, 2022",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 32
   },
   "visits": {
      "storefront": 32,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 13,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Hope Plumbling LLC is a fourth-generation family-owned business since its establishment on established 1978. We help our clients with remodels&renovations of their homes, plumbing service, and repairing&replacing water heaters. We offer a complete suite of plumbing services for any remodeling or addition and will work with our clients to ensure that they are satisfied with our project. Our mission is to provide unparalleled service and allow our work to exceed all expectations of professionalism, integrity, and effectiveness.\r
\r
3110 N Radiant Star Rd, Post Falls, Idaho, 83854, USA",
      "service1": "Water Heater Repair Idaho",
      "service2": "Home Renovation Idaho",
      "service3": "Plumbing Repair Post Falls",
      "service4": "Plumbing Services Post Falls",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2022-05-06 12:04:22"
   },
   "location": {
      "uuid": "95888aa8-56da-11ed-b77c-b66e99367f32",
      "link_id": 322045,
      "account_id": 73197,
      "company": "Hope Plumbing LLC",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 12,
      "city": "5014",
      "zip": "83854",
      "address": "3110 N Radiant Star Rd",
      "phone": "(208) 771-3170",
      "fax": null,
      "email": "hopeplumbingllc@outlook.com",
      "name": "Hope Plumbing LLC",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "47.7341144",
      "lon": "-116.9704319",
      "cityname": "Post Falls",
      "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": ""
}