Drain & Sewer Services in Houston, TX | Red One Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 339558,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.redoneplumbing.com/",
      "title": "Drain & Sewer Services in Houston, TX | Red One Plumbing",
      "description": "Welcome to Red One Plumbing, your trusted experts in drain and sewer services in Houston, TX. Since 2016, weve been dedicated to keeping your homes plumbing running smoothly, providing reliable and efficient solutions for all your drainage needs. What sets us apart? Its the personal care we bring to each service. From the moment you reach out, youll be met with a friendly voice, attentive service, and a quick response.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 90265,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-12-21T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 21883,
      "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": 4996,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "d6bc5210-bfe5-11ef-a909-b66e99367f32",
      "subdate": "Dec 21, 2024",
      "subcategory": "Home Plumbing Repair",
      "request_types": "",
      "visitcount": 11
   },
   "visits": {
      "storefront": 11,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-12-21 21:52:14"
   },
   "location": {
      "uuid": "d6bc5210-bfe5-11ef-a909-b66e99367f32",
      "link_id": 339558,
      "account_id": 90265,
      "company": "Drain & Sewer Services in Houston, TX | Red One Plumbing",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "21883",
      "zip": "77089",
      "address": "12055 Sabo Rd,",
      "phone": "2819673130",
      "fax": null,
      "email": "contact@redoneplumbing.com",
      "name": "Drain & Sewer Services in Houston, TX | Red One Plumbing",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "29.6065496",
      "lon": "-95.2165451",
      "cityname": "Houston",
      "statename": "Texas"
   },
   "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": ""
}