Cesar''s Roofing LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 324669,
      "site_id": 67,
      "cat_id": 81,
      "priority": 2,
      "url": "https://www.cesarsroofing.com/issaquah-roofer/",
      "title": "Cesar''s Roofing LLC",
      "description": "At Cesars Roofing, our first priority is the 100% satisfaction of our customers. Any and all issues are handled directly by the owner himself, Cesar, and he is also the one to inspect and sign off on the completion of every job. We have extensive experience installing, replacing, repairing and cleaning roofs in the Pacific Northwest! We offer comprehensive roofing services to help keep your roof in great shape. You may only need a simple repair or it might be time for a complete roof replacement, our team of experienced roofing professionals will get the job done right, on time, and within the agreed upon estimate.We pride ourselves on being the best roofing contractor Renton offers by providing outstanding service and top-notch quality.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 75671,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-04-19T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 2,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 46,
      "city_id": 23896,
      "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": 5058,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "ae3d646e-dea0-11ed-b5b4-b66e99367f32",
      "subdate": "Apr 19, 2023",
      "subcategory": "Roofing Installation",
      "request_types": "",
      "visitcount": 14
   },
   "visits": {
      "storefront": 14,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 5,
      "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": "2023-04-19 10:55:21"
   },
   "location": {
      "uuid": "ae3d646e-dea0-11ed-b5b4-b66e99367f32",
      "link_id": 324669,
      "account_id": 75671,
      "company": "Cesar''s Roofing LLC",
      "sid": 67,
      "country": 277,
      "countrycode": "US",
      "state": 46,
      "city": "23896",
      "zip": "98056",
      "address": "9834 124th Ave SE Renton, WA 98056",
      "phone": "3602866383",
      "fax": null,
      "email": "cesarroofingllc19@gmail.com",
      "name": "Cesar''s Roofing LLC",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": null,
      "lon": null,
      "cityname": "Renton",
      "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": ""
}