TrioHeating&Air

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 344648,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://trioheatingandair.com/",
      "title": "TrioHeating&Air",
      "description": "Trio Heating & Air offers a comprehensive range of heating, ventilation, air conditioning, and insulation services to residents and businesses in the San Jose area and throughout the Bay Area. They specialize in keeping homes and businesses comfortable year-round with reliable heating and cooling systems, while also improving indoor air quality through their air duct cleaning services.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95343,
      "approve_dt": "2025-10-31T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-04-02T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 2,
      "clickcount": 10,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2327,
      "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": 6285,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "4bfe4b2b-0f6a-11f0-a909-b66e99367f32",
      "subdate": "Apr 02, 2025",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 70
   },
   "visits": {
      "storefront": 70,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "TRIO Heating, Air & Plumbing is a leading HVAC and plumbing provider serving the greater San Francisco Bay Area from our San Jose, CA location. Founded on integrity, expertise, and exceptional customer care, we deliver reliable heating, cooling, and plumbing solutions with a commitment to environmental responsibility—planting a tree for every job completed. Our team of continuously trained technicians uses top-rated products and trusted brands to provide superior craftsmanship, prompt service, and competitive pricing that our community has come to depend on.",
      "service1": "heating system installation and repair",
      "service2": " air conditioning installation and repair",
      "service3": " HVAC maintenance",
      "service4": " plumbing services",
      "service5": " emergency HVAC service",
      "service6": " indoor air quality solutions",
      "service7": " energy-efficient system upgrades",
      "submit_dt": "2025-04-02 02:29:26"
   },
   "location": {
      "uuid": "4bfe4b2b-0f6a-11f0-a909-b66e99367f32",
      "link_id": 344648,
      "account_id": 95343,
      "company": "Trio Heating & Air",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2327",
      "zip": "94306",
      "address": "209 California Avenue",
      "phone": "415-903-4148",
      "fax": null,
      "email": "trioheatingandair@brite-mail.com",
      "name": "Trio Heating & Air",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "37.4281034",
      "lon": "-122.143092",
      "cityname": "Palo Alto",
      "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": ""
}