Corvallis Premier Tree Care

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 344717,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://corvallispremiertreecare.com/",
      "title": "Corvallis Premier Tree Care",
      "description": "At Corvallis Premier Tree Care, we uphold the values of Safety, Honesty, and Professionalism as the pillars of our business. These values guide our office staff and field crew in delivering exceptional tree care services and ensuring customer satisfaction on every project.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95412,
      "approve_dt": "2025-10-29T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-04-03T00: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": 36,
      "city_id": 18502,
      "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": 5862,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "069fbaf4-1053-11f0-a909-b66e99367f32",
      "subdate": "Apr 03, 2025",
      "subcategory": "Gardeners",
      "request_types": "",
      "visitcount": 36
   },
   "visits": {
      "storefront": 36,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 13,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Corvallis Premier Tree Care is your trusted tree service expert serving Corvallis, OR, dedicated to enhancing and preserving the beauty, health, and safety of your landscape. Our team of certified arborists combines advanced equipment, professional expertise, and a passion for exceptional tree care to deliver services that keep your property well-maintained year-round. Whether you need routine pruning for a majestic oak, hazard tree assessment, emergency storm cleanup, or safe removal of dead or diseased trees, we're here to provide tailored solutions that meet your unique needs. With a commitment to exceeding customer expectations, we handle every project with precision and care, ensuring your trees remain healthy, beautiful, and structurally sound. Let Corvallis Premier Tree Care take the stress out of tree maintenance so you can enjoy a safe, stunning outdoor space.",
      "service1": "tree removal",
      "service2": " tree trimming and pruning",
      "service3": " hazard tree surveys",
      "service4": " storm damage cleanup",
      "service5": " tree health assessments",
      "service6": " emergency tree services",
      "service7": " certified arborist consultations",
      "submit_dt": "2025-04-03 06:15:24"
   },
   "location": {
      "uuid": "069fbaf4-1053-11f0-a909-b66e99367f32",
      "link_id": 344717,
      "account_id": 95412,
      "company": "Corvallis Premier Tree Care",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 36,
      "city": "18502",
      "zip": "97333",
      "address": "Corvallis, OR 97333",
      "phone": "(541)982-6063",
      "fax": null,
      "email": "corvallispremiertreecaremark@gmail.com",
      "name": "Corvallis Premier Tree Care",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Corvallis",
      "statename": "Oregon"
   },
   "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": ""
}