Royal Rooter

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 343025,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://royaldrains.com/",
      "title": "Royal Rooter",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 93720,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-02-27T00: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": 26,
      "city_id": 13596,
      "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": 5006,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "e8cf4bc6-f4c3-11ef-a909-b66e99367f32",
      "subdate": "Feb 27, 2025",
      "subcategory": "Commercial Plumbing",
      "request_types": "",
      "visitcount": 34
   },
   "visits": {
      "storefront": 34,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 9,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Royal Rooter is your trusted partner for all your drain cleaning needs in Omaha. We handle everything from minor clogs in your kitchen or bathroom sink to major blockages in your main sewer line. Our experienced technicians use the latest tools and techniques to ensure your plumbing flows freely. We're committed to providing top-notch service with a smile, because your satisfaction is our priority.",
      "service1": "Residential Drain Cleaning",
      "service2": "Commercial Drain Cleaning",
      "service3": "Main Sewer Line Camera Inspections",
      "service4": "Main Sewer Line Hydrojet",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-02-27 04:32:53"
   },
   "location": {
      "uuid": "e8cf4bc6-f4c3-11ef-a909-b66e99367f32",
      "link_id": 343025,
      "account_id": 93720,
      "company": "Royal Rooter",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 26,
      "city": "13596",
      "zip": "68046",
      "address": "302 E 1st St., Ste 103",
      "phone": "+1 402-734-1244",
      "fax": null,
      "email": "royaldrains@brite-post.com",
      "name": "Royal Rooter",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "41.1569561",
      "lon": "-96.0401286",
      "cityname": "Papillion",
      "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": ""
}