Service Professor

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 345675,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.serviceprofessor.com/",
      "title": "Service Professor",
      "description": "Comprehensive home services company established in 1978, originally founded as an electrical company and expanded to provide complete HVAC, plumbing, and electrical solutions. With over 40 years of experience, we're committed to unparalleled customer service and 100% satisfaction for all homeowner needs.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 96370,
      "approve_dt": "2025-09-19T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-04-21T00: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": 22,
      "city_id": 10436,
      "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": 6601,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "d8cd882d-1ec1-11f0-a909-b66e99367f32",
      "subdate": "Apr 21, 2025",
      "subcategory": "HVAC",
      "request_types": "",
      "visitcount": 21
   },
   "visits": {
      "storefront": 21,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Service Professor provides HVAC, plumbing and electrical services in Kalamazoo MI, and the surrounding area. Since 1978, customers have trusted us to deliver exceptional service and the highest quality work at every visit. Our team is committed to the safety and comfort of your home and family, and we believe you deserve our very best. Whether it's a heating, cooling, plumbing, drains, duct cleaning, or a household electrical project you need help with, you'll receive 5-star service. Call our Kalamazoo electricians, plumbers, heating & cooling contractors today!",
      "service1": "Water heater replacement & repair",
      "service2": "HVAC repairs & Installation",
      "service3": "Electrical replacement & repair",
      "service4": "Drain cleaning & repair",
      "service5": "Sewer services",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-04-21 15:03:56"
   },
   "location": {
      "uuid": "d8cd882d-1ec1-11f0-a909-b66e99367f32",
      "link_id": 345675,
      "account_id": 96370,
      "company": "Service Professor",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 22,
      "city": "10436",
      "zip": "49048",
      "address": "5015 East Michigan Avenue, Suite # D",
      "phone": "616-207-2224",
      "fax": null,
      "email": "serviceprofessor@mail-burst.com",
      "name": "Service Professor",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "42.2901909",
      "lon": "-85.5294316",
      "cityname": "Kalamazoo",
      "statename": "Michigan"
   },
   "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": ""
}