Freedom Underground Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 353249,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "https://builtwithfreedom.com/",
      "title": "Freedom Underground Plumbing",
      "description": "20+ Years of expertise in advising and helping customers resolve their water, sewer, septic, french drain, and other utility needs. We specialize in underground plumbing projects and can advise our customers on the best solution for their projects. We do free estimates. We work with Property Owners, Builders, and other contractors.\n\nWe also offer pipe and septic inspection services.\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 104024,
      "approve_dt": "2026-05-07T00:00:00.000Z",
      "source": null,
      "submit_dt": "2026-05-07T00: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": 2463,
      "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": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "f9071857-49e6-11f1-bb42-b66e99367f32",
      "subdate": "May 07, 2026",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 0
   },
   "visits": {
      "storefront": 0,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 0,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "20+ Years of expertise in advising and helping customers resolve their water, sewer, septic, french drain, and other utility needs. We specialize in underground plumbing projects and can advise our customers on the best solution for their projects. We do free estimates. We work with Property Owners, Builders, and other contractors.\n\nWe also offer pipe and septic inspection services.\n",
      "service1": "Electrical Conduit Installation",
      "service2": "Storm Drain and French Drain Solutions",
      "service3": "Trenchless Sewer Installation",
      "service4": "Sewer Line Repair",
      "service5": "Trenchless Water Line Installation",
      "service6": "Water Leak Repair",
      "service7": "Water Leak Detection",
      "submit_dt": "2026-05-07 07:32:59"
   },
   "location": {
      "uuid": "f9071857-49e6-11f1-bb42-b66e99367f32",
      "link_id": 353249,
      "account_id": 104024,
      "company": "Freedom Underground Plumbing",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2463",
      "zip": "95110",
      "address": "546 McKendrie St",
      "phone": "408-693-6018",
      "fax": null,
      "email": "freedomundergroundplumbing1@outlook.com",
      "name": "Freedom Underground Plumbing",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "San Jose",
      "statename": "California"
   },
   "socialmedia": [
      {
         "title": "Facebook",
         "ptype_id": 29,
         "dbtable": "links_socialmedia",
         "item": "Facebook",
         "cnt": null
      },
      {
         "title": "Instagram",
         "ptype_id": 30,
         "dbtable": "links_socialmedia",
         "item": "Instagram",
         "cnt": null
      },
      {
         "title": "Youtube",
         "ptype_id": 31,
         "dbtable": "links_socialmedia",
         "item": "Youtube Video",
         "cnt": null
      },
      {
         "title": "LinkedIn",
         "ptype_id": 32,
         "dbtable": "links_socialmedia",
         "item": "LinkedIn",
         "cnt": null
      },
      {
         "title": "TikTok",
         "ptype_id": 33,
         "dbtable": "links_socialmedia",
         "item": "TikTok",
         "cnt": null
      },
      {
         "title": "Twitter",
         "ptype_id": 34,
         "dbtable": "links_socialmedia",
         "item": "Twitter",
         "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": ""
}