Keystone Green

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 344850,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://keystone-green.com/",
      "title": "Keystone Green",
      "description": "Keystone Green Lawns has been providing premier lawn and landscape services in Pennsylvania for nearly 50 years. Our expert team delivers golf course-quality lawn care, meticulous horticultural services, and innovative landscape design and construction. We aim to exceed your expectations by accommodating your vision and lifestyle to create stunning outdoor spaces. Whether you want added color around entertaining areas or a serene backyard getaway, trust Keystone Green to enhance your propertys beauty, value, and functionality.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95545,
      "approve_dt": "2025-10-27T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-04-07T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 37,
      "city_id": 18954,
      "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": 5870,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "0c8f3788-1357-11f0-a909-b66e99367f32",
      "subdate": "Apr 07, 2025",
      "subcategory": "Lawn Service",
      "request_types": "",
      "visitcount": 40
   },
   "visits": {
      "storefront": 40,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 18,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Keystone Green Lawns has been delivering premier lawn and landscape services across Pennsylvania for nearly 50 years. Our expert team specializes in golf course-quality lawn care, meticulous horticultural services, and innovative landscape design that transforms outdoor spaces. We're committed to exceeding expectations by creating stunning landscapes that enhance your property's beauty, value, and functionality.",
      "service1": "lawn care and maintenance",
      "service2": " landscape design",
      "service3": " landscape construction and installation",
      "service4": " horticultural services",
      "service5": " lawn fertilization and treatment",
      "service6": " hardscaping",
      "service7": " seasonal cleanup and maintenance",
      "submit_dt": "2025-04-07 02:21:44"
   },
   "location": {
      "uuid": "0c8f3788-1357-11f0-a909-b66e99367f32",
      "link_id": 344850,
      "account_id": 95545,
      "company": "Keystone Green",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 37,
      "city": "18954",
      "zip": "15024",
      "address": "3809 Saxonburg Blvd",
      "phone": "",
      "fax": null,
      "email": "keystonegreen.marketing@gmail.com",
      "name": "Keystone Green",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "40.5880088",
      "lon": "-79.8780567",
      "cityname": "Cheswick",
      "statename": "Pennsylvania"
   },
   "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": ""
}