Emergency Restoration Service

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 316997,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.emergencyrs.com/",
      "title": "Emergency Restoration Service",
      "description": "Emergency Restoration Service provides the Kelso, WA area with home fire and water damage cleanup services. Whether your home has been flooded or engulfed in flames, we have the house fire and water damage cleanup and remediation services you need. We pride ourselves on our customer service, which is why we offer our clients a 100% satisfaction guarantee on all of our cleaning services. The team at ERS Construction has the experience and craftsmenship to recreate your vision and meet your needs. Call us for fast services you can count on!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68194,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-05-13T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 139,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 46,
      "city_id": 23728,
      "ltop": "",
      "facebook": "https://www.facebook.com/Emergency-Restoration-Services-168858769848847",
      "tiktok": null,
      "linkedin": "",
      "twitter": "https://twitter.com/EmergencyResto",
      "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": 6285,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "956d518b-56da-11ed-b77c-b66e99367f32",
      "subdate": "May 13, 2019",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 213
   },
   "visits": {
      "storefront": 213,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Emergency Restoration Service provides the Kelso, WA area with home fire and water damage cleanup services. Whether your home has been flooded or engulfed in flames, we have the house fire and water damage cleanup and remediation services you need. We pride ourselves on our customer service, which is why we offer our clients a 100% satisfaction guarantee on all of our cleaning services. The team at ERS Construction has the experience and craftsmenship to recreate your vision and meet your needs. Call us for fast services you can count on!",
      "service1": "emergency-restoration",
      "service2": " fire",
      "service3": " flood",
      "service4": " water",
      "service5": " wind",
      "service6": " smoke",
      "service7": " damage",
      "submit_dt": "2019-05-13 11:38:07"
   },
   "location": {
      "uuid": "956d518b-56da-11ed-b77c-b66e99367f32",
      "link_id": 316997,
      "account_id": 68194,
      "company": "Emergency Restoration Service",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 46,
      "city": "23728",
      "zip": "98626",
      "address": "500 Grade Street",
      "phone": "360-425-4700",
      "fax": null,
      "email": "emergencyrs@hotmail.com",
      "name": "Emergency Restoration Service",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "46.14331",
      "lon": "-122.908466",
      "cityname": "Kelso",
      "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": ""
}