Kennewick Landscaping Services

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 309228,
      "site_id": 69,
      "cat_id": 65,
      "priority": 0,
      "url": "http://legacy-lawn.com/",
      "title": "Kennewick Landscaping Services",
      "description": "Full service landscaping and lawn maintenance for the Tri-Cities (Richland Pasco Kennewick). Design Installation Maintenance Lawn Care Fencing Curbing Irrigation Pest Control",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 60464,
      "approve_dt": "2015-04-17T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-04-15T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1268,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 46,
      "city_id": 23870,
      "ltop": "",
      "facebook": "https://www.facebook.com/legacy.landscape",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 5178,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "jpg",
      "pack_id": null,
      "uuid": "9546c9e1-56da-11ed-b77c-b66e99367f32",
      "subdate": "Apr 15, 2015",
      "subcategory": "Landscaping",
      "request_types": "",
      "visitcount": 1474
   },
   "visits": {
      "storefront": 1474,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 16,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Legacy Lawn & Landscape was founded in 1999 by Nathan Pratt. Since this time we have passed many milestones along the way and gained knowledge and experience that has given us the reputation we have as a top quality landscaping firm.\n\nOur pledge is to establish lasting relationships with our customers by exceeding their expectations and gaining their trust through exceptional performance in everything that we do.\n\nWe have happily served the Tri-Cities area which includes Richland, Pasco, and Kennewick.  We are now offering landscaping and fencing services to the Cities of Walla Walla, Yakima and Spokane.",
      "service1": "Landscaping",
      "service2": " Landscape Maintenance",
      "service3": " Landscape Installation",
      "service4": " Lawn Care",
      "service5": " Concrete Lawn Curbing",
      "service6": " Fencing",
      "service7": " Irrigation",
      "submit_dt": "2015-04-15 05:14:25"
   },
   "location": {
      "uuid": "9546c9e1-56da-11ed-b77c-b66e99367f32",
      "link_id": 309228,
      "account_id": 60464,
      "company": "Legacy Lawn & Landscape LLC",
      "sid": 69,
      "country": 277,
      "countrycode": "US",
      "state": 46,
      "city": "23870",
      "zip": "",
      "address": "",
      "phone": "",
      "fax": "",
      "email": "",
      "name": "",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": null,
      "lon": null,
      "cityname": "Pasco",
      "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": ""
}