Unified Restoration LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 344106,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.unifiedaz.com/",
      "title": "Unified Restoration LLC",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 94801,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-03-21T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 6,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 3,
      "city_id": 961,
      "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": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "55ae61c0-061c-11f0-a909-b66e99367f32",
      "subdate": "Mar 21, 2025",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 49
   },
   "visits": {
      "storefront": 49,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 14,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Unified Restoration LLC brings 40+ years of experience in water damage restoration, fire cleanup, mold remediation, asbestos abatement, and emergency plumbing in Mesa, AZ, and surrounding areas. Our expert team responds fast to minimize damage and restore your property with insurance-approved solutions. Committed to excellence, integrity, and trust, we make the restoration process seamless by working with all insurance companies. Whether it's water, fire, or hazardous materials, we're here 24/7 to help homeowners and businesses recover. Call Unified Restoration LLC today for 24/7 emergency response and expert restoration services!",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-03-21 06:18:41"
   },
   "location": {
      "uuid": "55ae61c0-061c-11f0-a909-b66e99367f32",
      "link_id": 344106,
      "account_id": 94801,
      "company": "",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "961",
      "zip": "85209",
      "address": "9221 East Baseline Road, Ste 109-441",
      "phone": "+1 480-485-9060",
      "fax": null,
      "email": "unifiedaz@mail-burst.com",
      "name": "",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "33.3774373",
      "lon": "-111.6345385",
      "cityname": "Mesa",
      "statename": "Arizona"
   },
   "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": ""
}