Rocky Mountain Restoration

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317168,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://www.rmraz.com/",
      "title": "Rocky Mountain Restoration",
      "description": "When Water Damage in Phoenix, AZ Metro area and disaster strikes or the unexpected happens, the last thing you should have to worry about is making sure your home or business is put back in living and working order.\r\n\r\nWater Damage Phoenix or destruction turns life upside-down. With the wrong water and flood restoration company, it can also lead to additional stress when communication is poor or contractors cut corners.\r\n\r\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68366,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-06-03T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 178,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 3,
      "city_id": 990,
      "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": 4284,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "956e4c3b-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jun 03, 2019",
      "subcategory": "Waste Removal",
      "request_types": "",
      "visitcount": 312
   },
   "visits": {
      "storefront": 312,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "When Water Damage in Phoenix, AZ Metro area and disaster strikes or the unexpected happens, the last thing you should have to worry about is making sure your home or business is put back in living and working order.\r\n\r\nWater Damage Phoenix or destruction turns life upside-down. With the wrong water and flood restoration company, it can also lead to additional stress when communication is poor or contractors cut corners.\r\n\r\n",
      "service1": "fire damage",
      "service2": "mold removal",
      "service3": "water damage",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-06-03 16:57:55"
   },
   "location": {
      "uuid": "956e4c3b-56da-11ed-b77c-b66e99367f32",
      "link_id": 317168,
      "account_id": 68366,
      "company": "Rocky Mountain Restoration",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "990",
      "zip": "85233",
      "address": "728 N Monterey St, Gilbert, AZ 85233",
      "phone": " (480) 309-2524",
      "fax": null,
      "email": "rmrazemergencywaterremoval@gmail.com",
      "name": "Rocky Mountain Restoration",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.362124",
      "lon": "-111.800493",
      "cityname": "Phoenix",
      "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": ""
}