Anderson Landscape & Tree Service

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349135,
      "site_id": 58,
      "cat_id": 53,
      "priority": 0,
      "url": "http://www.andersonlandscapemain.com/",
      "title": "Anderson Landscape & Tree Service",
      "description": "We're a family-owned and operated Landscape & Tree Service. We have a couple of girls in the office who answer the phones, respond to emails, and work up estimates. We have 2 estimators, who are the owners. And 3 crews: a tree crew, a landscape renovation and hardscape crew, and a maintenance crew. We provide services from small clean-ups to full yard makeovers with hardscaping and all tree services. We streamline our process from initial contact to completed job using the Jobber software, which all of my crew members have access to via an app with a login. Clients also have a portal to track estimates, jobs, and invoices.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 99829,
      "approve_dt": "2025-07-04T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-27T00: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": 18618,
      "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": 4201,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "d490878b-5309-11f0-a909-b66e99367f32",
      "subdate": "Jun 27, 2025",
      "subcategory": "Landscaping",
      "request_types": "",
      "visitcount": 60
   },
   "visits": {
      "storefront": 60,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 32,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We're a family-owned and operated Landscape & Tree Service. We have a couple of girls in the office who answer the phones, respond to emails, and work up estimates. We have 2 estimators, who are the owners. And 3 crews: a tree crew, a landscape renovation and hardscape crew, and a maintenance crew. We provide services from small clean-ups to full yard makeovers with hardscaping and all tree services. We streamline our process from initial contact to completed job using the Jobber software, which all of my crew members have access to via an app with a login. Clients also have a portal to track estimates, jobs, and invoices.",
      "service1": "Hardscaping services",
      "service2": "Residential tree care services",
      "service3": "Lawn care and maintenance",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-06-27 03:50:13"
   },
   "location": {
      "uuid": "d490878b-5309-11f0-a909-b66e99367f32",
      "link_id": 349135,
      "account_id": 99829,
      "company": "Anderson Landscape & Tree Service",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 36,
      "city": "18618",
      "zip": "97222",
      "address": "2403 SE Monroe St Suite A-2",
      "phone": "+1 503-659-3172",
      "fax": null,
      "email": "andersonlandscapeor@brite-mail.com",
      "name": "Anderson Landscape & Tree Service",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Milwaukie",
      "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": ""
}