Sawyers Heating and Air Conditioning

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 309198,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "http://www.dereksawyers.com",
      "title": "Sawyers Heating and Air Conditioning",
      "description": "Derek Sawyer's is a California-based heating and air conditioning company.Our aim is to provide homeowners with ultimate comfort throughout all seasons.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 60434,
      "approve_dt": "2015-04-13T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-04-10T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1835,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2231,
      "ltop": "",
      "facebook": "https://www.facebook.com/pages/Derek-Sawyers-Smart-Energy/371642659551217",
      "tiktok": "",
      "linkedin": "",
      "twitter": "https://twitter.com/dereksawyers",
      "googleplus": "https://plus.google.com/115028854434829748571/posts",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 5840,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9546a542-56da-11ed-b77c-b66e99367f32",
      "subdate": "Apr 10, 2015",
      "subcategory": "Air Conditioning",
      "request_types": "",
      "visitcount": 2179
   },
   "visits": {
      "storefront": 2179,
      "articles": 0,
      "videos": 0,
      "reviews": 29,
      "coupons": 0,
      "products": 0,
      "social": 16,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Heating&A/C Company - As a family owned business he know how important the comfort of home is. When you need heating and air conditioning services it is usually because you're hot when you want to be cold or cold when you need to be warm. Maybe that old energy guzzling unit costs too much to run. Maybe you need a Tune Up or want a new EnergyStar system but don't know what would be the best solution for you.",
      "service1": "Heater Repair",
      "service2": "Heating & Air Conditioning Repair",
      "service3": " Duct Cleaning",
      "service4": " Furnace Repair",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2015-04-10 10:34:34"
   },
   "location": {
      "uuid": "9546a542-56da-11ed-b77c-b66e99367f32",
      "link_id": 309198,
      "account_id": 60434,
      "company": "Derek Sawyers",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2231",
      "zip": "95351",
      "address": "1120 Doker Drive Suite 2",
      "phone": "",
      "fax": "",
      "email": "",
      "name": "",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "37.647034",
      "lon": "-121.024528",
      "cityname": "Modesto",
      "statename": "California"
   },
   "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": ""
}