North Creek Roofing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 337415,
      "site_id": 67,
      "cat_id": 81,
      "priority": 2,
      "url": "https://www.northcreekroofing.com/",
      "title": "North Creek Roofing",
      "description": "North Creek Roofing is proud to have built its reputation as one of the most trustworthy residential roofing contractors in the area. At North Creek Roofing you are more than just a customer to us you're our neighbor! Specializing in re-roofs, repairs, roof cleanings, gutters, and more, we are the roofing company ready to serve you. With our years of experience and tens of thousands of satisfied customers North Creek Roofing truly is \"A Name You Can Trust\" .",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 88144,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-10-29T00: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": 46,
      "city_id": 23806,
      "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": "2bfd6dbb-95a4-11ef-ab46-b66e99367f32",
      "subdate": "Oct 29, 2024",
      "subcategory": "Roofing Contractor",
      "request_types": "",
      "visitcount": 54
   },
   "visits": {
      "storefront": 54,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 18,
      "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": "2024-10-29 03:16:21"
   },
   "location": {
      "uuid": "2bfd6dbb-95a4-11ef-ab46-b66e99367f32",
      "link_id": 337415,
      "account_id": 88144,
      "company": "North Creek Roofing",
      "sid": 67,
      "country": 277,
      "countrycode": "US",
      "state": 46,
      "city": "23806",
      "zip": "98012",
      "address": "16000 Mill Creek Boulevard, #102",
      "phone": "+1 425-483-7986",
      "fax": null,
      "email": "northcreekroof@brite-post.com",
      "name": "North Creek Roofing",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "47.8530019",
      "lon": "-122.2214953",
      "cityname": "Mill Creek",
      "statename": "Washington"
   },
   "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": ""
}