Foam Experts Roofing, Inc.

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317136,
      "site_id": 67,
      "cat_id": 81,
      "priority": 2,
      "url": "https://www.foamexpertsroofing.com/",
      "title": "Foam Experts Roofing, Inc.",
      "description": "Foam 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!\r\n\r\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68334,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-05-31T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 132,
      "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": 5064,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "956e1c1f-56da-11ed-b77c-b66e99367f32",
      "subdate": "May 31, 2019",
      "subcategory": "Commercial Roofing",
      "request_types": "",
      "visitcount": 148
   },
   "visits": {
      "storefront": 148,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 4,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Foam 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!\r\n\r\n",
      "service1": "commercial roof",
      "service2": "foam roof",
      "service3": "roofing",
      "service4": "roofers",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-05-31 20:59:38"
   },
   "location": {
      "uuid": "956e1c1f-56da-11ed-b77c-b66e99367f32",
      "link_id": 317136,
      "account_id": 68334,
      "company": "Foam Experts Roofing, Inc.",
      "sid": 67,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "961",
      "zip": "85210",
      "address": "1107 S Wilbur, Mesa, AZ 85210",
      "phone": "(480) 835-5404",
      "fax": null,
      "email": "myfoamexpertsroofing@gmail.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.3949832",
      "lon": "-111.824021",
      "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": ""
}