Nandez Plumbing and Excavation

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 332855,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://nandezplumbing.com/",
      "title": "Nandez Plumbing and Excavation",
      "description": "Welcome to Nandez Plumbing and Excavation serving Houston, TX, we''re your comprehensive plumbing solution. From general plumbing to kitchen remodeling, our services include toilet repair, water heater maintenance, and more. Specializing in residential plumbing, sewer, and drain service, we guarantee top-quality work. Need excavating services? We''ve got you covered! With years of experience and a dedication to excellence, trust us for reliable solutions. Don''t let plumbing problems ruin your day  contact Nandez Plumbing and Excavation today for a free estimate with just one click!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 83634,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-07-11T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 4,
      "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": 5877,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "f032328d-3f39-11ef-8344-b66e99367f32",
      "subdate": "Jul 11, 2024",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 10
   },
   "visits": {
      "storefront": 10,
      "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-07-11 03:59:14"
   },
   "location": {
      "uuid": "f032328d-3f39-11ef-8344-b66e99367f32",
      "link_id": 332855,
      "account_id": 83634,
      "company": "Nandez Plumbing and Excavation",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "21883",
      "zip": "77089",
      "address": "11332 Sageburrow Dr",
      "phone": "832-428-8587",
      "fax": null,
      "email": "team.nandezplumbing@gmail.com",
      "name": "Nandez Plumbing and Excavation",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "29.5852155",
      "lon": "-95.22593",
      "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": ""
}