Schoenherr Roofing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 344412,
      "site_id": 67,
      "cat_id": 81,
      "priority": 2,
      "url": "https://www.schoenherrroofing.com/novi/?utm_source=GBP",
      "title": "Schoenherr Roofing",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95107,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-03-27T00: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": 10564,
      "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": 5046,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "10b7516d-0afd-11f0-a909-b66e99367f32",
      "subdate": "Mar 27, 2025",
      "subcategory": "Roofing",
      "request_types": "",
      "visitcount": 22
   },
   "visits": {
      "storefront": 22,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 9,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "As a leading roofing company in SE Michigan, Schoenherr Roofing has been serving Michigan homeowners for over 30 years. With over 6500+ installations under our belt, we deliver expertise and precision in every project. Excellence is our standard, offering honest, straightforward quotes with no games, gimmicks, or pressure. Our Exterior Specialists provide expert in-home evaluations, ensuring peace of mind. Whether it's roof installation, roof repair, roof replacement, siding installation, gutters, or insulation, trust Schoenherr Roofing for a seamless and integrity-driven experience. For unparalleled service and quality, choose Schoenherr Roofing"where excellence comes standard. Give our Novi, MI team a call today!",
      "service1": "Roof Replacement",
      "service2": "Roof Repair",
      "service3": "Metal Roofing",
      "service4": "Commercial Roofing",
      "service5": "Shingle Roofing",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-03-27 11:17:27"
   },
   "location": {
      "uuid": "10b7516d-0afd-11f0-a909-b66e99367f32",
      "link_id": 344412,
      "account_id": 95107,
      "company": "",
      "sid": 67,
      "country": 277,
      "countrycode": "US",
      "state": 22,
      "city": "10564",
      "zip": "48375",
      "address": "43000 W 9 Mile Road, #210",
      "phone": "+1 248-270-7344",
      "fax": null,
      "email": "schoenherrroofing@brite-mail.com",
      "name": "",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "",
      "lon": "",
      "cityname": "Novi",
      "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": ""
}