Columbia Tree Co.

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348746,
      "site_id": 69,
      "cat_id": 65,
      "priority": 2,
      "url": "https://ColumbiaTreeCo.com",
      "title": "Columbia Tree Co.",
      "description": "Columbia Tree Co. is a locally-founded tree care company serving Columbia, Missouri and surrounding areas with professionalism and expertise for over 10 years. We understand the importance of maintaining the natural beauty and safety of our environment, delivering top-notch services tailored to Columbia's unique landscapes and needs. As a home-grown business, we take pride in contributing to our city's beauty by maintaining healthy, safe, and aesthetically pleasing trees that enhance our community spaces, especially during major events like the True/False Film Fest and Roots N Blues Festival.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 99440,
      "approve_dt": "2025-07-10T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-16T00: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": 25,
      "city_id": 12167,
      "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": 5182,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "6b2c9ae2-4aa5-11f0-a909-b66e99367f32",
      "subdate": "Jun 16, 2025",
      "subcategory": "Landscaping Trees",
      "request_types": "",
      "visitcount": 85
   },
   "visits": {
      "storefront": 85,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 26,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Nestled in the heart of Columbia, Missouri, Columbia Tree Co. is your local source for professional arboricultural services. Our skilled team is dedicated to maintaining the health and beauty of your trees with expert tree removal, trimming, and pruning services designed to enhance your landscape's safety and aesthetic appeal. We understand that sometimes tree-related emergencies can arise unexpectedly; that's why we offer reliable emergency tree service to address any urgent needs swiftly and effectively. With a keen focus on providing top-notch columbia tree service, our crew employs the latest techniques and equipment to ensure every job is done correctly and safely. Whether you're looking to clear space for a new project or simply want to keep your trees in pristine condition, Columbia Tree Co. stands ready to deliver exceptional care and service tailored to the unique needs of your property.",
      "service1": "Tree removal",
      "service2": " Tree trimming and pruning",
      "service3": " Stump grinding",
      "service4": " Emergency tree services",
      "service5": " Tree health assessments",
      "service6": " Landscape maintenance",
      "service7": " Community event tree preparation",
      "submit_dt": "2025-06-16 11:31:17"
   },
   "location": {
      "uuid": "6b2c9ae2-4aa5-11f0-a909-b66e99367f32",
      "link_id": 348746,
      "account_id": 99440,
      "company": "Columbia Tree Co.",
      "sid": 69,
      "country": 277,
      "countrycode": "US",
      "state": 25,
      "city": "12167",
      "zip": "65202",
      "address": "113 Elk Dr.",
      "phone": "573-242-5335",
      "fax": null,
      "email": "columbiatreeco@businessmailsystem.com",
      "name": "Columbia Tree Co.",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "38.9851982",
      "lon": "-92.3349708",
      "cityname": "Columbia",
      "statename": "Missouri"
   },
   "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": ""
}