The Plumber

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349898,
      "site_id": 58,
      "cat_id": 53,
      "priority": 0,
      "url": "https://www.theplumberav.com/",
      "title": "The Plumber",
      "description": "The Plumber is your go-to local expert in Lancaster, CA, Palmdale, and Quartz Hill, delivering premier plumbing services for both homes and businesses. Our specialties include rapid emergency responses and comprehensive sewer line repairs, ensuring that every job meets the highest standards of quality and customer care. Whether it's tackling routine upkeep, fixing water leaks, or performing meticulous drain cleaning, our proficient team is ready to manage all your plumbing challenges. We are committed to providing dependable, efficient, and professional solutions to keep your plumbing system in optimal condition. Choose The Plumber for unparalleled quality and complete customer satisfaction in all your plumbing needs.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100593,
      "approve_dt": "2025-09-13T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-08-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": 5,
      "city_id": 2121,
      "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": 4197,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "39586e63-85a2-11f0-bb42-b66e99367f32",
      "subdate": "Aug 30, 2025",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 44
   },
   "visits": {
      "storefront": 44,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 20,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "The Plumber is your go-to local expert in Lancaster, CA, Palmdale, and Quartz Hill, delivering premier plumbing services for both homes and businesses. Our specialties include rapid emergency responses and comprehensive sewer line repairs, ensuring that every job meets the highest standards of quality and customer care. Whether it's tackling routine upkeep, fixing water leaks, or performing meticulous drain cleaning, our proficient team is ready to manage all your plumbing challenges. We are committed to providing dependable, efficient, and professional solutions to keep your plumbing system in optimal condition. Choose The Plumber for unparalleled quality and complete customer satisfaction in all your plumbing needs.\t",
      "service1": "Sewer scope",
      "service2": "Water line repair",
      "service3": "Water heater repair",
      "service4": "Water softener",
      "service5": "Commercial plumbing services",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-08-30 13:07:04"
   },
   "location": {
      "uuid": "39586e63-85a2-11f0-bb42-b66e99367f32",
      "link_id": 349898,
      "account_id": 100593,
      "company": "The Plumber",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2121",
      "zip": "93535",
      "address": "230 E Ave K4, Unit 1 &2",
      "phone": "6617226039",
      "fax": null,
      "email": "Avtheplumber@gmail.com",
      "name": "The Plumber",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Lancaster",
      "statename": "California"
   },
   "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": ""
}