TrenchFree

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 346783,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.trenchfree.com/",
      "title": "TrenchFree",
      "description": "TrenchFree eliminates the mess of traditional pipeline replacement in San Jose, CA. Their trenchless methods ensure seamless underground utility upgrades.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 97478,
      "approve_dt": "2025-07-30T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-12T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "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": 5018,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "8cb31597-2f64-11f0-a909-b66e99367f32",
      "subdate": "May 12, 2025",
      "subcategory": "General Plumbing",
      "request_types": "",
      "visitcount": 6
   },
   "visits": {
      "storefront": 6,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "TrenchFree is your trusted trenchless services provider specializing in innovative no-dig solutions for installing and replacing underground pipes and conduits throughout Santa Clara County, CA, and nearby areas. Our expert team handles sewer, water, electrical conduit, and gas line work without the need to tear up your yard or disrupt your landscape. We're committed to moving quickly while minimizing disruption to your property and daily life, guaranteeing that projects are completed on schedule. With TrenchFree at the helm of your underground utility projects, you can expect efficient, reliable service that preserves your property's integrity while delivering professional results.",
      "service1": "trenchless sewer repair",
      "service2": " pipe bursting",
      "service3": " directional drilling",
      "service4": " water line replacement",
      "service5": " electrical conduit installation",
      "service6": " gas line installation",
      "service7": " underground utility locating",
      "submit_dt": "2025-05-12 19:08:55"
   },
   "location": {
      "uuid": "8cb31597-2f64-11f0-a909-b66e99367f32",
      "link_id": 346783,
      "account_id": 97478,
      "company": "TrenchFree",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2463",
      "zip": "95125",
      "address": "1941 Stone Ave ",
      "phone": "(408) 726-7926",
      "fax": null,
      "email": "trenchfreemarketing@gmail.com",
      "name": "TrenchFree",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "37.3020587",
      "lon": "-121.8731213",
      "cityname": "San Jose",
      "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": ""
}