Blue Frog Roofing Limited

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 334680,
      "site_id": 67,
      "cat_id": 81,
      "priority": 2,
      "url": "https://bluefrogroofing.com/",
      "title": "Blue Frog Roofing Limited",
      "description": "Blue Frog Roofing Limited is a premier roofing company serving Colorado, Southern Wyoming, and South Florida. Our areas of expertise include residential roofing, commercial roofing, roof repair, replacement and maintenance. We can provide quality installation of all types of roofing: asphalt shingles, wood shake shingles, tile roofing, solar roofing, metal roofing, flat roof repairs and installation (TPO, rolled roofing, etc), and much more. For more information on our roofing and maintenance services, call us on 970.699.5575. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 85433,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-08-29T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 6,
      "city_id": 2930,
      "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": 5046,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "71982440-65d4-11ef-ab46-b66e99367f32",
      "subdate": "Aug 29, 2024",
      "subcategory": "Roofing",
      "request_types": "",
      "visitcount": 27
   },
   "visits": {
      "storefront": 27,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 12,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Blue Frog Roofing Limited is a premier roofing company serving Colorado, Southern Wyoming, and South Florida. Our areas of expertise include residential roofing, commercial roofing, roof repair, replacement and maintenance. We can provide quality installation of all types of roofing: asphalt shingles, wood shake shingles, tile roofing, solar roofing, metal roofing, flat roof repairs and installation (TPO, rolled roofing, etc), and much more. For more information on our roofing and maintenance services, call us on 970.699.5575.",
      "service1": "commercial roofing northglenn co",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-08-29 07:00:59"
   },
   "location": {
      "uuid": "71982440-65d4-11ef-ab46-b66e99367f32",
      "link_id": 334680,
      "account_id": 85433,
      "company": "",
      "sid": 67,
      "country": 277,
      "countrycode": "US",
      "state": 6,
      "city": "2930",
      "zip": "80233",
      "address": "11990 Grant St Suite 550",
      "phone": "970.699.5575",
      "fax": null,
      "email": "bluefrogroofing3@gmail.com",
      "name": "Blue Frog Roofing Limited",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "39.9134354",
      "lon": "-104.9840696",
      "cityname": "Northglenn",
      "statename": "Colorado"
   },
   "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": ""
}