Professional Landscaping in Newberg, OR | Expert Landscape Contractors

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 347058,
      "site_id": 69,
      "cat_id": 65,
      "priority": 2,
      "url": "https://www.sierralakelandscapemaintenancellc.com/",
      "title": "Professional Landscaping in Newberg, OR | Expert Landscape Contractors",
      "description": "Sierra Lake Landscape is a professional landscaping company in Newberg, OR, and surrounding areas for more than 12 years,  that can help to make your outdoor space look amazing and beautiful.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 97753,
      "approve_dt": "2025-07-28T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-17T00: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": 36,
      "city_id": 18635,
      "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": 5190,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "5d06830d-32d0-11f0-a909-b66e99367f32",
      "subdate": "May 17, 2025",
      "subcategory": "Landscape Contractors",
      "request_types": "",
      "visitcount": 22
   },
   "visits": {
      "storefront": 22,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Sierra Lake Landscape Maintenance LLC has been serving residential and commercial customers in Newberg, Oregon, and surrounding areas for over 12 years as the top landscaping company in the area. We're passionate about landscape care and offer customized attention to meet each client's unique needs, staying ahead of the competition through our core values of responsibility, quality work, and punctuality while being fully insured and trained to operate professional landscaping equipment.",
      "service1": "residential and commercial landscaping design",
      "service2": " professional landscape maintenance and care",
      "service3": " customized landscaping project management",
      "service4": " innovative landscape design solutions",
      "service5": " professional landscaping equipment operation",
      "service6": " fully insured landscaping services",
      "service7": " ongoing landscape maintenance contracts",
      "submit_dt": "2025-05-17 03:38:14"
   },
   "location": {
      "uuid": "5d06830d-32d0-11f0-a909-b66e99367f32",
      "link_id": 347058,
      "account_id": 97753,
      "company": "Professional Landscaping in Newberg, OR | Expert Landscape Contractors",
      "sid": 69,
      "country": 277,
      "countrycode": "US",
      "state": 36,
      "city": "18635",
      "zip": "97132",
      "address": "PO Box 848, Newberg, OR 97132",
      "phone": "(971) 255-6334",
      "fax": null,
      "email": "sierralakelandscapemaintenancellc@proton.me",
      "name": "Professional Landscaping in Newberg, OR | Expert Landscape Contractors",
      "status": "",
      "start_dt": null,
      "end_dt": null,
      "lat": "45.3003268",
      "lon": "-122.9761318",
      "cityname": "Newberg",
      "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": ""
}