WilletStainedGlassStudios

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348874,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://willet-studios.com/",
      "title": "WilletStainedGlassStudios",
      "description": "Willet Stained Glass Studios, founded in 1898 by William and Anne Lee Willet in Pittsburgh, Pennsylvania, is one of the world's largest stained glass studios with over 125 years of history. After merging with James Hauser's glass company in 1977 and being acquired by the Phillips family, the company was returned to its original name in 2023 by Aspen Mountain Partners, continuing its legacy of creating stunning stained glass works that grace churches and historic buildings across all 50 states and 14 countries.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 99568,
      "approve_dt": "2025-07-08T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-18T00: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": 23,
      "city_id": 11620,
      "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": 5735,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "669bc894-4c1c-11f0-a909-b66e99367f32",
      "subdate": "Jun 18, 2025",
      "subcategory": "Manufacturing",
      "request_types": "",
      "visitcount": 56
   },
   "visits": {
      "storefront": 56,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 24,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "With 125+ years of expertise, Willet Stained Glass Studios combines artistry and precision to create, restore, and preserve stunning stained glass windows. Our legacy ensures every project is a masterpiece that stands the test of time.\r
Our expertise includes stained glass repair, stained glass restoration, and stained glass conservation for church and historic buildings. We also design and install stained glass windows for both existing and new construction. We are also widely known for our on-site glass and frame repair.\r
Free inspections and appraisals offered.",
      "service1": "Church stained glass windows",
      "service2": "Stained glass repair and restoration",
      "service3": "Stained glass conservation",
      "service4": "Stained glass design",
      "service5": "New stained glass windows",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-06-18 08:15:31"
   },
   "location": {
      "uuid": "669bc894-4c1c-11f0-a909-b66e99367f32",
      "link_id": 348874,
      "account_id": 99568,
      "company": "Willet Stained Glass Studios",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 23,
      "city": "11620",
      "zip": "55987-6203",
      "address": "1685 Wilkie Dr",
      "phone": "(800) 533-3960",
      "fax": null,
      "email": "assoccrafts@mail-burst.com",
      "name": "Willet Stained Glass Studios",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "44.0217977",
      "lon": "-91.6094206",
      "cityname": "Winona",
      "statename": "Minnesota"
   },
   "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": ""
}