https://bluespruceexteriors.com/

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 321025,
      "site_id": 67,
      "cat_id": 81,
      "priority": 2,
      "url": "https://bluespruceexteriors.com/",
      "title": "https://bluespruceexteriors.com/",
      "description": "Blue Spruce Roofing %38 Exteriors is your local roofing contractor dedicated to restoring the integrity of your home’s roofing system and exterior by providing quality service and long-lasting products.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 72217,
      "approve_dt": "2021-08-11T00:00:00.000Z",
      "source": null,
      "submit_dt": "2021-07-14T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 605,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 6,
      "city_id": 2885,
      "ltop": "",
      "facebook": "https://www.facebook.com/bluespruceexteriors/",
      "tiktok": null,
      "linkedin": "https://www.linkedin.com/company/blue-spruce-exteriors/about",
      "twitter": "https://twitter.com/blue_spruce",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 5069,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9582935e-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jul 14, 2021",
      "subcategory": "Roofing Repair",
      "request_types": "",
      "visitcount": 882
   },
   "visits": {
      "storefront": 882,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 17,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We are a locally owned and operated Colorado construction and roofing company. With more than 10 years of experience in roofing, construction, and project management, our mission is to deliver comprehensive building solutions to our clients. We use top-of-the-line equipment, leading techniques, and state-of-the-art materials in the industry to ensure that you receive final results that last decades. Our team is skilled, trained, and licensed to accomplish the project in a careful and professional manner.",
      "service1": "Roofing Services",
      "service2": " Roofing Materials",
      "service3": " Exterior Services",
      "service4": " Insurance Claims",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2021-07-14 04:31:53"
   },
   "location": {
      "uuid": "9582935e-56da-11ed-b77c-b66e99367f32",
      "link_id": 321025,
      "account_id": 72217,
      "company": "Blue Spruce Roofing & Exteriors",
      "sid": 67,
      "country": 277,
      "countrycode": "US",
      "state": 6,
      "city": "2885",
      "zip": "80215",
      "address": "11504 West Colfax Avenue",
      "phone": "303-906-9128",
      "fax": null,
      "email": "bluespruceexteriorseo@gmail.com",
      "name": "Blue Spruce Roofing & Exteriors",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "39.7400075",
      "lon": "-105.1268714",
      "cityname": "Lakewood",
      "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": ""
}