Roofing Contractor

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 336308,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://hdroofingandsprayfoam.com/",
      "title": "Roofing Contractor",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 87043,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-10-04T00: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": 10,
      "city_id": 4335,
      "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": 288,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "66382942-81f1-11ef-ab46-b66e99367f32",
      "subdate": "Oct 04, 2024",
      "subcategory": "Home And Garden",
      "request_types": "",
      "visitcount": 38
   },
   "visits": {
      "storefront": 38,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Veteran and family owned and operated Roofing and Spray Foam company. HD Roofing and Spray foam provides top quality commercial and residential roofing, spray foam, remodeling and contractor services to north GA and surrounding areas. We have the experience and knowledge from hundreds of homes which allows us to quickly identify roof damage, causes, repairs, and prevention. We are also strong believers in the quality and efficiency of spray foam.",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-10-04 01:38:47"
   },
   "location": {
      "uuid": "66382942-81f1-11ef-ab46-b66e99367f32",
      "link_id": 336308,
      "account_id": 87043,
      "company": "HD Roofing and Spray Foam",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 10,
      "city": "4335",
      "zip": "30542",
      "address": "5633 Atlanta Hwy",
      "phone": "(470) 870-6729",
      "fax": null,
      "email": "hdroofingga@brite-post.com",
      "name": "HD Roofing and Spray Foam",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "34.1756531",
      "lon": "-83.9312362",
      "cityname": "Flowery Branch",
      "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": ""
}