Powell Roofing LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 320259,
      "site_id": 67,
      "cat_id": 81,
      "priority": 2,
      "url": "http://powellroofingllc.com",
      "title": "Powell Roofing LLC",
      "description": "Powell Roofing LLC is locally owned and operated. We offer competitive pricing and all workmanship is backed by a 10 year warranty. Powell Roofing LLC is proud to offer 50 year warranties upon request. For more information, visit us online!\r\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 71451,
      "approve_dt": "2021-03-02T00:00:00.000Z",
      "source": null,
      "submit_dt": "2020-12-17T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 574,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 39,
      "city_id": 20340,
      "ltop": "",
      "facebook": "https://www.facebook.com/Powell-Roofing-229535650390143/timeline/",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "https://www.yelp.com/biz/powell-roofing-ladson-2?osq=roofing",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 5103,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "957e8176-56da-11ed-b77c-b66e99367f32",
      "subdate": "Dec 17, 2020",
      "subcategory": "Roofers",
      "request_types": "",
      "visitcount": 787
   },
   "visits": {
      "storefront": 787,
      "articles": 0,
      "videos": 0,
      "reviews": 21,
      "coupons": 0,
      "products": 0,
      "social": 10,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We offer competitive pricing and all workmanship is backed by a 10 year warranty on our roofs. Our warranties are among the best roof warraties available with up to 50 year warranties upon request.\n\nOur mission is Quality Roofing made Affordable! \nPowell Roofing is dedicated to making the purchase of your new roof an easy and pleasant experience. Based upon a thorough inspection of your roof, we will answer all of your questions. Then, we'll give you all the information you need to make this a simple but educated decision! Call us today for a roofing company Charleston SC trusts!",
      "service1": "Roofing",
      "service2": " Siding",
      "service3": " Windows",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2020-12-17 12:20:16"
   },
   "location": {
      "uuid": "957e8176-56da-11ed-b77c-b66e99367f32",
      "link_id": 320259,
      "account_id": 71451,
      "company": "Powell Roofing LLC",
      "sid": 67,
      "country": 277,
      "countrycode": "US",
      "state": 39,
      "city": "20340",
      "zip": "29456",
      "address": "2047 Cripplecreek Drive",
      "phone": "843-270-2421",
      "fax": null,
      "email": "Powellroofing1@yahoo.com",
      "name": "Powell Roofing LLC",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.0208648",
      "lon": "-80.1043066",
      "cityname": "Ladson",
      "statename": "South Carolina"
   },
   "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": ""
}