United Water Restoration Group of Charlotte

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 332103,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://www.uwrcharlotte.com/",
      "title": "United Water Restoration Group of Charlotte",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 82892,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-06-22T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 22,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 32,
      "city_id": 15779,
      "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": 6468,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpeg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "782d0138-3080-11ef-8344-b66e99367f32",
      "subdate": "Jun 22, 2024",
      "subcategory": "Water Restoration And Damage",
      "request_types": "",
      "visitcount": 80
   },
   "visits": {
      "storefront": 80,
      "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": "From strong storms to unforeseen accidents, a selection of situations can cause water or fire damages to your property. Recover fast from these disasters with help from the professionals at United Water Restoration Group of Charlotte. This woman-owned&operated company supplies 24/7 emergency situation cleanup and restoration services to clients throughout Charlotte, NC, and surrounding locations. Backed by greater than 40 years of experience, United Water Restoration Group of Charlotte has the expertise and resources to tackle issues for homes and businesses. Talented technicians are offered to perform water damage restorations. We additionally give help with insurance claims for fire damage cleanup, smoke damage restoration, mold remediation, and water mitigation.",
      "service1": "Water Damage-Related Cleanup & Repair",
      "service2": "Fire Damage Cleanup & Repair",
      "service3": "Carpet Cleaning",
      "service4": "Flood Cleanup",
      "service5": "Mold Cleaning",
      "service6": "Water Removal",
      "service7": "Water Damage In Your Home",
      "submit_dt": "2024-06-22 10:16:20"
   },
   "location": {
      "uuid": "782d0138-3080-11ef-8344-b66e99367f32",
      "link_id": 332103,
      "account_id": 82892,
      "company": "United Water Restoration Group of Charlotte",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 32,
      "city": "15779",
      "zip": "28273",
      "address": "2905 Westinghouse Blvd #800",
      "phone": "(704) 228-8888",
      "fax": null,
      "email": "uwrcharlottenorthcarolina@outlook.com",
      "name": "United Water Restoration Group of Charlotte",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "35.1316585",
      "lon": "-80.9526471",
      "cityname": "Charlotte",
      "statename": "North Carolina"
   },
   "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": ""
}