Foam Experts Roofing, INC.

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 314963,
      "site_id": 67,
      "cat_id": 81,
      "priority": 2,
      "url": "http://www.foamexpertsroofing.com/",
      "title": "Foam Experts Roofing, INC.",
      "description": "Foam Experts Roofing\r\nFamily owned and operated since 1969\r\nFoam Experts Roofing has provided high-efficiency, durable and affordable polyurethane roofing installation services to commercial and residential clients for over 30 years. We provide Free Estimates on Roofing, Roof Repair, and New Roofs in Phoenix, Tucson, Mesa, Lake Havasu City Roofing and all over the great state of Arizona! Whether you need a Foam Roof, Flat Roof, Industrial or Commercial Roofing or a Roof for your home call us today for a Free Estimate!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 66182,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2018-05-01T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 118,
      "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": 5083,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95634c17-56da-11ed-b77c-b66e99367f32",
      "subdate": "May 01, 2018",
      "subcategory": "Foam Roofing",
      "request_types": "",
      "visitcount": 142
   },
   "visits": {
      "storefront": 142,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 5,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Foam Experts Roofing\r\nFamily owned and operated since 1969\r\nFoam Experts Roofing has provided high-efficiency, durable and affordable polyurethane roofing installation services to commercial and residential clients for over 30 years. We provide Free Estimates on Roofing, Roof Repair, and New Roofs in Phoenix, Tucson, Mesa, Lake Havasu City Roofing and all over the great state of Arizona! Whether you need a Foam Roof, Flat Roof, Industrial or Commercial Roofing or a Roof for your home call us today for a Free Estimate!",
      "service1": "roofing repair in mesa az",
      "service2": "rooof repair mesa",
      "service3": "roof repair mesa az",
      "service4": "roofers mesa az",
      "service5": "foam roofing",
      "service6": "roofing",
      "service7": "roofer",
      "submit_dt": "2018-05-01 21:55:37"
   },
   "location": {
      "uuid": "95634c17-56da-11ed-b77c-b66e99367f32",
      "link_id": 314963,
      "account_id": 66182,
      "company": "Foam Experts Roofing, INC.",
      "sid": 67,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "961",
      "zip": "85210",
      "address": "1107 South Wilbur Stree",
      "phone": "",
      "fax": null,
      "email": "myfoamexpertsroofing@yahoo.com",
      "name": "Foam Experts Roofing, INC.",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.3902569",
      "lon": "-111.8449346",
      "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": ""
}