Blue Spruce Heating & Cooling

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 320699,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://bluespruceheatingandcooling.com/",
      "title": "Blue Spruce Heating & Cooling",
      "description": "Blue Spruce Heating & Cooling is one of the top-rated HVAC contractors across the Denver metro area. Your satisfaction with our AC and heating services is our top priority.Our company provides a wide range of commercial and residential heating solutions, as well as AC repair, maintenance, and installation. Our service area includes  Denver, Littleton, and Centennial, CO. Contact our courteous team and schedule your FREE estimate today.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 71891,
      "approve_dt": "2021-04-28T00:00:00.000Z",
      "source": null,
      "submit_dt": "2021-04-09T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 455,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 6,
      "city_id": 2896,
      "ltop": "",
      "facebook": "https://www.facebook.com/bluespruceheatingandcooling",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "https://www.yelp.com/biz/blue-spruce-heating-and-cooling-littleton",
      "foursquare": "",
      "instagram": "https://www.instagram.com/bluesprucehvac/",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 6601,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9580ff90-56da-11ed-b77c-b66e99367f32",
      "subdate": "Apr 09, 2021",
      "subcategory": "HVAC",
      "request_types": "",
      "visitcount": 638
   },
   "visits": {
      "storefront": 638,
      "articles": 0,
      "videos": 0,
      "reviews": 28,
      "coupons": 0,
      "products": 0,
      "social": 15,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Are you tired of scrolling through pages of search results for HVAC contractors? Choose Blue Spruce Heating&Cooling and get the best AC and heating service available in the Denver metro area.  \n
\n
From water heater or furnace repair at your home to commercial heating system installation and maintenance, the skilled technicians from our company do the job right, the first time. \n
\n
We proudly serve Denver, Littleton, and Centennial, CO. Get in touch with us for details and book your FREE estimate today.",
      "service1": "Heating",
      "service2": " Air Conditioning",
      "service3": " Indoor Air Quality",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2021-04-09 08:34:46"
   },
   "location": {
      "uuid": "9580ff90-56da-11ed-b77c-b66e99367f32",
      "link_id": 320699,
      "account_id": 71891,
      "company": "Blue Spruce Heating & Cooling",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 6,
      "city": "2896",
      "zip": "80125",
      "address": "3706 Norwood Dr. #13 ",
      "phone": "720-660-3742",
      "fax": null,
      "email": "bluespruceseodld@gmail.com",
      "name": "Blue Spruce Heating & Cooling",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "39.5548975",
      "lon": "-105.0372194",
      "cityname": "Littleton",
      "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": ""
}