Sam''s Tree & Landscape LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317249,
      "site_id": 69,
      "cat_id": 65,
      "priority": 2,
      "url": "https://www.samscapes.net/",
      "title": "Sam''s Tree & Landscape LLC",
      "description": "Sam''s Tree & Landscape LLC is staffed by a team of tree specialists. We can provide you with everything from tree removal service to a team of dedicated hardscape landscapers for your outdoor needs in Spokane. From beautifully designed landscapes and water features, to stump grinding and landscape maintenance, let Sam’s be the partner for your next outdoor project. We have an excellent safety record for tree removal, and we use high-tech equipment to take trees down safely when needed. We’re fully licensed, bonded, and insured, and our dedicated crew has years of experience and knowledge that make the journey an enjoyable one. Contact us today to schedule a meeting with an arborist, or to request specific services. If you have an emergency situation, contact us immediately.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68447,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-06-13T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 137,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 46,
      "city_id": 23946,
      "ltop": "",
      "facebook": "https://www.facebook.com/Sams-Tree-Landscape-LLC-381924962276784",
      "tiktok": null,
      "linkedin": "https://www.linkedin.com/in/sam-maple-885817b0",
      "twitter": "https://twitter.com/SamsLawnTreeLa",
      "googleplus": "https://maps.google.com/maps?&cid=12503690669940544558",
      "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": 5194,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "956ec1ec-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jun 13, 2019",
      "subcategory": "Landscaping Company",
      "request_types": "",
      "visitcount": 186
   },
   "visits": {
      "storefront": 186,
      "articles": 0,
      "videos": 0,
      "reviews": 2,
      "coupons": 0,
      "products": 0,
      "social": 5,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Sam's Tree&Landscape LLC is staffed by a team of tree specialists. We can provide you with everything from tree removal service to a team of dedicated hardscape landscapers for your outdoor needs in Spokane. From beautifully designed landscapes and water features, to stump grinding and landscape maintenance, let Samu2019s be the partner for your next outdoor project. We have an excellent safety record for tree removal, and we use high-tech equipment to take trees down safely when needed. Weu2019re fully licensed, bonded, and insured, and our dedicated crew has years of experience and knowledge that make the journey an enjoyable one. Contact us today to schedule a meeting with an arborist, or to request specific services. If you have an emergency situation, contact us immediately.",
      "service1": "Tree Service",
      "service2": " Landscaping",
      "service3": " Stump Grinding",
      "service4": " Tree Removal",
      "service5": " Tree Service",
      "service6": " Landscaping",
      "service7": " Stump Grinding",
      "submit_dt": "2019-06-13 12:11:57"
   },
   "location": {
      "uuid": "956ec1ec-56da-11ed-b77c-b66e99367f32",
      "link_id": 317249,
      "account_id": 68447,
      "company": "Sam''s Tree & Landscape LLC",
      "sid": 69,
      "country": 277,
      "countrycode": "US",
      "state": 46,
      "city": "23946",
      "zip": "99208",
      "address": "8117 N Division St. Suite B",
      "phone": "509-467-3801",
      "fax": null,
      "email": "samscapes001@gmail.com",
      "name": "Sam's Tree & Landscape LLC",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "47.7445062",
      "lon": "-117.4121062",
      "cityname": "Spokane",
      "statename": "Washington"
   },
   "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": ""
}