All American Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 347895,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://allamerican-plumbing.com",
      "title": "All American Plumbing",
      "description": "All American Plumbing has over 10 years of experience providing reliable plumbing services across Houston, TX, and surrounding neighborhoods. Specializing in water heater repairs, drain cleaning, leak detection, faucet repairs, and emergency plumbing, they are committed to delivering fast, professional, and affordable solutions. Their licensed team ensures customer satisfaction with expert plumbing advice and trusted services.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 98590,
      "approve_dt": "2025-07-20T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-30T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "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": 5033,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "1ef51106-3d1f-11f0-a909-b66e99367f32",
      "subdate": "May 30, 2025",
      "subcategory": "Local Plumber",
      "request_types": "",
      "visitcount": 31
   },
   "visits": {
      "storefront": 31,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 14,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Professional Plumbing delivers high-quality plumbing services within your budget, committed to ethical business practices, fair pricing, and exceptional craftsmanship that goes above and beyond. With years of experience and quality equipment, we provide comfort, security, and peace of mind through fast, reliable service with competitive rates, free consultations, and 24/7 availability to keep your busy life running smoothly.",
      "service1": "Professional Plumbing Expertise",
      "service2": " Emergency 24/7 Service",
      "service3": " Free Consultation Services",
      "service4": " Quality Equipment Installation",
      "service5": " Fast Reliable Repairs",
      "service6": " Competitive Rate Solutions",
      "service7": " Customer Satisfaction Guarantee",
      "submit_dt": "2025-05-30 06:27:12"
   },
   "location": {
      "uuid": "1ef51106-3d1f-11f0-a909-b66e99367f32",
      "link_id": 347895,
      "account_id": 98590,
      "company": "All American Plumbing",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "21883",
      "zip": "77074",
      "address": "6127 Shadow Crest St",
      "phone": "(832) 280-5598",
      "fax": null,
      "email": "Aaplumbingmarketing@gmail.com",
      "name": "All American Plumbing",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "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": ""
}