Superior Roofing Company of Georgia

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 311816,
      "site_id": 67,
      "cat_id": 81,
      "priority": 0,
      "url": "http://superiorroofs.com/index.html",
      "title": "Superior Roofing Company of Georgia",
      "description": "Superior Roofing Company of Georgia is a full service residential roofing company dedicated to providing customer with the highest standard of service and workmanship.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 63051,
      "approve_dt": "2016-04-01T00:00:00.000Z",
      "source": null,
      "submit_dt": "2016-03-31T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1942,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 10,
      "city_id": 4441,
      "ltop": "",
      "facebook": "https://www.facebook.com/pages/Superior-Roofing-Company-of-Georgia-Inc/338167632953246?fref=ts",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "https://plus.google.com/b/117649475090444681719/dashboard/overview (in process of trying to claim)",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 5068,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95547e09-56da-11ed-b77c-b66e99367f32",
      "subdate": "Mar 31, 2016",
      "subcategory": "Residential Roofing",
      "request_types": "",
      "visitcount": 2199
   },
   "visits": {
      "storefront": 2199,
      "articles": 0,
      "videos": 0,
      "reviews": 12,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Superior Roofing Company of Georgia is a full service residential roofing company dedicated to providing customers with the highest standard of service and workmanship.\nFounded in 1990, Superior Roofing Company has been serving Alpharetta and the surrounding areas, one customer at a time.\n\nOur goal is not only to meet the roofing needs of our customers, but to leave them with a superior experience, one which they will remember for a lifetime and one that they will tell others about. Continually ranked by consumers and independent agencies as a top roofing company in Alpharetta, Superior Roofing Company of Georgia is reaching their goal. If you require roofing work find out why thousands of satisfied customers call this roofing company Superior.",
      "service1": "Pans and Shrouds",
      "service2": "Chimney Caps",
      "service3": "Custom Skylights",
      "service4": "Roof Replacement",
      "service5": "Roofing",
      "service6": "",
      "service7": "",
      "submit_dt": "2016-03-31 15:41:25"
   },
   "location": {
      "uuid": "95547e09-56da-11ed-b77c-b66e99367f32",
      "link_id": 311816,
      "account_id": 63051,
      "company": "Superior Roofing Company of Georgia, Inc.",
      "sid": 67,
      "country": 277,
      "countrycode": "US",
      "state": 10,
      "city": "4441",
      "zip": "30047",
      "address": "1257 Aquila Ct.",
      "phone": "",
      "fax": "",
      "email": "superiorroofingcompanyofga@gmail.com",
      "name": "Superior Roofing Company of Georgia",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.856278",
      "lon": "-84.098223",
      "cityname": "Lilburn",
      "statename": "Georgia"
   },
   "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": ""
}