Hamdan Quality Roofing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 344000,
      "site_id": 67,
      "cat_id": 81,
      "priority": 2,
      "url": "https://www.hamdanqualityroof.com/",
      "title": "Hamdan Quality Roofing",
      "description": "Hamdan Quality Roofing is your trusted roofing contractor in Hudson, MI, offering top-quality roof, siding, gutter, and window installation services. We specialize in metal roofs, roof repair, and expert siding installations that enhance the beauty and protection of your home. Our team is committed to providing reliable, long-lasting solutions for all your exterior needs. Whether you need a new roof, gutter system, or window installation, Hamdan Quality Roofing delivers exceptional service with a focus on quality and customer satisfaction. Contact us today for a free estimate!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 94695,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-03-19T00: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": 0,
      "city_id": 0,
      "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": 5047,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "07df7d25-04a8-11f0-a909-b66e99367f32",
      "subdate": "Mar 19, 2025",
      "subcategory": "Roofing Contractor",
      "request_types": "",
      "visitcount": 5
   },
   "visits": {
      "storefront": 5,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 1,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-03-19 09:53:38"
   },
   "location": {
      "uuid": "07df7d25-04a8-11f0-a909-b66e99367f32",
      "link_id": 344000,
      "account_id": 94695,
      "company": "Hamdan Quality Roofing",
      "sid": 67,
      "country": 277,
      "countrycode": "US",
      "state": 0,
      "city": "0",
      "zip": "",
      "address": "",
      "phone": "(517) 448-4440",
      "fax": null,
      "email": "hamdanqualityroofing@brite-mail.com",
      "name": "Hamdan Quality Roofing",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "",
      "statename": ""
   },
   "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": ""
}