{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 342422,
"site_id": 6,
"cat_id": 39,
"priority": 2,
"url": "https://tristarenvironment.com",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 93116,
"approve_dt": null,
"source": null,
"submit_dt": "2025-02-14T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 2,
"referrals": null,
"country": 99,
"countrycode": "CA",
"loc_id": 99,
"state_id": 0,
"city_id": 1323,
"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": 6646,
"d_url": null,
"approved": null,
"logo_ext": "jpg",
"screen_ext": "png",
"pack_id": null,
"uuid": "b0e32855-ea74-11ef-a909-b66e99367f32",
"subdate": "Feb 14, 2025",
"subcategory": "Construction",
"request_types": "",
"visitcount": 18
},
"visits": {
"storefront": 18,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 7,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "Tristar Environmental Services is your trusted hydrovac company in the Okanagan, offering 24/7 emergency and scheduled solutions. Our services include hydrovac, septic pumping, line flushing, sewer inspections, and daylighting. With over 10 years of expertise, a responsive team, and a diverse fleet, we guarantee safe and professional service for residential and commercial clients. Whether you need hydrovac rental, sewer line repair, or vacuum truck services, we're here to help. Call us today!",
"service1": "Hydrovac",
"service2": "Vacuum Truck",
"service3": "Septic Plumbing & Cleaning",
"service4": "Spill Response",
"service5": "Line Flushing, Inspections and Cleaning",
"service6": "",
"service7": "",
"submit_dt": "2025-02-14 01:40:37"
},
"location": {
"uuid": "b0e32855-ea74-11ef-a909-b66e99367f32",
"link_id": 342422,
"account_id": 93116,
"company": "Tristar Environmental Services Ltd.",
"sid": 6,
"country": 99,
"countrycode": "CA",
"state": 0,
"city": "1323",
"zip": "V4Y 0N1",
"address": "4260 Spallumcheen Dr",
"phone": "250-463-9797",
"fax": null,
"email": "tristarenvironme@brite-post.com",
"name": "Tristar Environmental Services Ltd.",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "50.4029431",
"lon": "-119.2215879",
"cityname": "British Columbia",
"statename": ""
},
"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": ""
}
all our featured social media
