Specialty Heating & Cooling LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 326322,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "http://www.specialtyheating.com/",
      "title": "Specialty Heating & Cooling LLC",
      "description": "Since 1985, Specialty Heating and Cooling has been the premier heating and cooling company for Tigard, OR. We''ve been recognized for our service around the Portland Metro area by several organizations, with an Angie''s List Super Service Award, Carrier Dealer Awards, the Carrier President Award, and more. We''re BBB A+ rated and accredited, and our technicians are highly skilled and NATE certified.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 77207,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-11-14T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 36,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 36,
      "city_id": 18715,
      "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": 4218,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "1f783013-8294-11ee-8344-b66e99367f32",
      "subdate": "Nov 14, 2023",
      "subcategory": "Air Conditioning",
      "request_types": "",
      "visitcount": 105
   },
   "visits": {
      "storefront": 105,
      "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": "",
      "service1": "AC Installation",
      "service2": "AC Maintenance",
      "service3": "Furnace Installation",
      "service4": "Furnace Maintenance",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2023-11-14 02:18:39"
   },
   "location": {
      "uuid": "1f783013-8294-11ee-8344-b66e99367f32",
      "link_id": 326322,
      "account_id": 77207,
      "company": "Specialty Heating & Cooling LLC",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 36,
      "city": "18715",
      "zip": "97223",
      "address": "7500 Southwest Tech Center Drive, #130",
      "phone": "503-946-6396",
      "fax": null,
      "email": "specialtyheating@mail-burst.com",
      "name": "Specialty Heating & Cooling LLC",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "45.4195308",
      "lon": "-122.7536646",
      "cityname": "Tigard",
      "statename": "Oregon"
   },
   "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": ""
}