Emerald Roofing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 340261,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "http://www.emeraldroofing.net/",
      "title": "Emerald Roofing",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 90958,
      "approve_dt": "2025-11-24T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-01-07T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 26,
      "city_id": 13579,
      "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": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "18972aa1-cca8-11ef-a909-b66e99367f32",
      "subdate": "Jan 07, 2025",
      "subcategory": "Home And Garden",
      "request_types": "",
      "visitcount": 34
   },
   "visits": {
      "storefront": 34,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 13,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Wondering why you should choose Emerald Roofing as your roofing company in the Omaha area? Many of the high-quality shingles and materials we use come with a lengthy manufacturer's warranty, providing you with peace of mind in protecting your roofing investment. However, these warranties typically just cover materials, which are not the main reason roofs fail. Shoddy workmanship is typically the cause of roofs not lasting as long as they should.",
      "service1": "Roof replacement",
      "service2": "Siding",
      "service3": "Roof inspections",
      "service4": "Metal roofing",
      "service5": "Roof repair",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-01-07 03:33:01"
   },
   "location": {
      "uuid": "18972aa1-cca8-11ef-a909-b66e99367f32",
      "link_id": 340261,
      "account_id": 90958,
      "company": "Emerald Roofing",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 26,
      "city": "13579",
      "zip": "68130",
      "address": "2435 South 156th Circle",
      "phone": "+1 402-581-7222",
      "fax": null,
      "email": "emeraldroofing@mail-burst.com",
      "name": "Emerald Roofing",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "41.2366945",
      "lon": "-96.1572525",
      "cityname": "Omaha",
      "statename": "Nebraska"
   },
   "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": ""
}