Hazard Clean Restoration

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 346126,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://hazardclean.net/",
      "title": "Hazard Clean Restoration",
      "description": "Hazard Clean Restoration is a specialized 24/7 emergency restoration company providing expert trauma cleanup and property restoration services with trained, certified professionals who deliver empathetic care, rapid response, and high-quality restoration work while treating customers with dignity, respect, and privacy during difficult circumstances.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 96821,
      "approve_dt": "2025-08-18T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-04-30T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 4,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 9,
      "city_id": 4052,
      "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": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "fcaf54ab-2563-11f0-a909-b66e99367f32",
      "subdate": "Apr 30, 2025",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 14
   },
   "visits": {
      "storefront": 14,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We're here to help. Hazard Clean Restoration provides professional water, fire, biohazard, hoarder, and odor restoration services to families and companies in Indian River and Saint Lucie County. We care about making your home or business safe and livable again, which is why we provide rapid emergency response 24/7/365.",
      "service1": "Water damage restoration",
      "service2": " Fire damage restoration",
      "service3": " Biohazard cleanup services",
      "service4": " Trauma scene cleanup",
      "service5": " Emergency restoration response",
      "service6": " Hazardous material cleanup",
      "service7": " Property restoration services",
      "submit_dt": "2025-04-30 01:39:41"
   },
   "location": {
      "uuid": "fcaf54ab-2563-11f0-a909-b66e99367f32",
      "link_id": 346126,
      "account_id": 96821,
      "company": "Hazard Clean Restoration",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 9,
      "city": "4052",
      "zip": "32960",
      "address": "601 21st Street, Suite #200",
      "phone": "(772) 837-6039",
      "fax": null,
      "email": "hazardcleanrestoration@brite-mail.com",
      "name": "Hazard Clean Restoration",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "38.5806991",
      "lon": "-121.476613",
      "cityname": "Vero Beach",
      "statename": "Florida"
   },
   "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": ""
}