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": null,
      "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": null,
      "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": 17
   },
   "visits": {
      "storefront": 17,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 13,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "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": ""
}