Rockwater Plumbing LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 332291,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://rockwater.plumbing/",
      "title": "Rockwater Plumbing LLC",
      "description": "We are a locally based plumbing company with the skills and resources required to tackle common repairs quickly, efficiently, and in a way that''s good for your budget. Since 2016, we have been maintaining a customer-first approach to doing business. We are backed by a team of caring, polite, well-trained technicians who make every homeowner feel like they are the number one priority. Make a confident choice by making Rockwater Plumbing your go-to source for residential plumbing repairs in Mansfield, TX, and nearby areas we serve. We look forward to including you as one of our many satisfied clients. Contact us today to schedule an appointment or request service.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 83078,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-06-27T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 12,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 21469,
      "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": 5000,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "4806a6a0-349d-11ef-8344-b66e99367f32",
      "subdate": "Jun 27, 2024",
      "subcategory": "Plumbing Services",
      "request_types": "",
      "visitcount": 44
   },
   "visits": {
      "storefront": 44,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 1,
      "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-06-27 15:52:39"
   },
   "location": {
      "uuid": "4806a6a0-349d-11ef-8344-b66e99367f32",
      "link_id": 332291,
      "account_id": 83078,
      "company": "Rockwater Plumbing LLC",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "21469",
      "zip": "76028",
      "address": "509 SW Wilshire Blvd Suite G2",
      "phone": "(817) 659-5929",
      "fax": null,
      "email": "rockwaterplumbingmarketing@gmail.com",
      "name": "Rockwater Plumbing LLC",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "32.5372455",
      "lon": "-97.3331116",
      "cityname": "Burleson",
      "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": ""
}