1-800 Water Damage of Cleveland West

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 347685,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.1800waterdamage.com/cleveland-west/",
      "title": "1-800 Water Damage of Cleveland West",
      "description": "1-800 WATER DAMAGE is a leading property restoration company serving Cleveland West and surrounding areas with trained and certified experts ready to respond when customers need them most. They provide comprehensive restoration solutions from initial cleanup to complete restoration, focusing on stress-free processes and unmatched customer service to help restore what matters most.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 98380,
      "approve_dt": "2025-07-20T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-27T00: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": 34,
      "city_id": 17383,
      "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": 6285,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "43c3c060-3ad3-11f0-a909-b66e99367f32",
      "subdate": "May 27, 2025",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 25
   },
   "visits": {
      "storefront": 25,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 9,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "1-800 WATER DAMAGE of Cleveland West is a trusted, locally owned property restoration company based in North Olmsted, Ohio. Serving Lorain, Cuyahoga, and Medina Counties, they specialize in comprehensive restoration services, including water and flood damage restoration, mold remediation, sewage cleanup, fire and smoke damage recovery, and professional carpet cleaning.",
      "service1": "Water damage restoration",
      "service2": " Mold remediation services",
      "service3": " Fire and smoke damage restoration",
      "service4": " Sewage cleanup solutions",
      "service5": " Professional deep cleaning",
      "service6": " Comprehensive property restoration",
      "service7": " Emergency response services",
      "submit_dt": "2025-05-27 08:19:09"
   },
   "location": {
      "uuid": "43c3c060-3ad3-11f0-a909-b66e99367f32",
      "link_id": 347685,
      "account_id": 98380,
      "company": "1-800 WATER DAMAGE",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 34,
      "city": "17383",
      "zip": "44070",
      "address": "31400 Industrial Parkway",
      "phone": "(440) 545-7786",
      "fax": null,
      "email": "oneeightwaterdamage@brite-post.com",
      "name": "",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "41.3913012",
      "lon": "-81.9656965",
      "cityname": "North Olmsted",
      "statename": "Ohio"
   },
   "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": ""
}