Keystone Ridge Designs, Inc.

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 320753,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.keystoneridgedesigns.com",
      "title": "Keystone Ridge Designs, Inc.",
      "description": "Keystone Ridge Designs is a leading designer and American manufacturer of commercial-grade site furnishings. For 25 years, we have been transforming public spaces with our unique collection of powder coated steel benches, litter receptacles, bike racks, table sets, bollards, planters and other site amenities.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 71945,
      "approve_dt": "2021-04-23T00:00:00.000Z",
      "source": null,
      "submit_dt": "2021-04-22T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 662,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 37,
      "city_id": 18907,
      "ltop": "",
      "facebook": "https://www.facebook.com/KeystoneRidgeDesigns?fref=ts",
      "tiktok": null,
      "linkedin": "https://www.linkedin.com/company/2117915?trk=tyah",
      "twitter": "https://twitter.com/KRDBench",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": null,
      "pinterest": "https://www.pinterest.com/keystoneridge/",
      "yelp": "",
      "foursquare": "",
      "instagram": "https://instagram.com/keystoneridgedesigns/",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 5859,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95815309-56da-11ed-b77c-b66e99367f32",
      "subdate": "Apr 22, 2021",
      "subcategory": "Furniture Stores",
      "request_types": "",
      "visitcount": 904
   },
   "visits": {
      "storefront": 904,
      "articles": 0,
      "videos": 0,
      "reviews": 24,
      "coupons": 0,
      "products": 0,
      "social": 47,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Over our 25 years of site furniture manufacturing experience, Keystone Ridge Designs has always maintained a dedication to our customers. As we continue to innovate and move forward, you can rest assured that the core business of Keystone Ridge Designs remains the same – the same exceptional American-made quality, the same reliable customer service and the same product creativity and originality. We are proud of our two decades of growth and success. It is our pride, dedication and passion that keep us doing what we do best.\n\nFrom downtown streetscapes and parks to shopping centers, schools, office complexes and everything in between, Keystone Ridge Designs creates a positive client experience to those who value design, durability and practical function in site furnishings.",
      "service1": "Benches",
      "service2": " Litter Receptacles",
      "service3": " Recycling Containers",
      "service4": " Bicycle Racks",
      "service5": " Tables & Chairs",
      "service6": " Bollards",
      "service7": " Ash Receptacles",
      "submit_dt": "2021-04-22 07:43:31"
   },
   "location": {
      "uuid": "95815309-56da-11ed-b77c-b66e99367f32",
      "link_id": 320753,
      "account_id": 71945,
      "company": "Keystone Ridge Designs, Inc.",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 37,
      "city": "18907",
      "zip": "16001",
      "address": "670 Mercer Road",
      "phone": "800-284-8208",
      "fax": null,
      "email": "keystoneridgedesigns1@outlook.com",
      "name": "Keystone Ridge Designs, Inc.",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.8831041",
      "lon": "-79.9152934",
      "cityname": "Butler",
      "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": ""
}