Quality Window and Door Products, With Quality Service!

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 327588,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://www.windowanddoorshop.com/",
      "title": "Quality Window and Door Products, With Quality Service!",
      "description": "Credentials: NARI-Certified Remodeler Specialist, BBB A+ Rating, Installation Masters",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 78437,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-01-11T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 10,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2436,
      "ltop": "",
      "facebook": "https://www.facebook.com/wdssac/",
      "tiktok": null,
      "linkedin": "",
      "twitter": "https://twitter.com/WinDoorShopInc",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": null,
      "pinterest": "https://www.pinterest.com/thewindowanddoorshopinc0230/",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 4183,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "65ad060c-b085-11ee-8344-b66e99367f32",
      "subdate": "Jan 11, 2024",
      "subcategory": "Windows",
      "request_types": "",
      "visitcount": 17
   },
   "visits": {
      "storefront": 17,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "window replacement, window installation, fiberglass windows, wood windows, custom windows, aluminum windows, energy efficient windows, custom doors, sliding doors, patio doors, entry doors, french doors, bifold exterior doors, multislide doors, door replacement, moving glass wall systems, interior doors, door installation, skylights, door hardware, vinyl windows, vinyl sliding patio doors",
      "service1": "Window Installation Service",
      "service2": "Door Supplier",
      "service3": "Window Supplier",
      "service4": "Custom Wood Windows",
      "service5": "Custom Wood Doors",
      "service6": "Skylights",
      "service7": "Hardware",
      "submit_dt": "2024-01-11 13:29:07"
   },
   "location": {
      "uuid": "65ad060c-b085-11ee-8344-b66e99367f32",
      "link_id": 327588,
      "account_id": 78437,
      "company": "The Window and Door Shop, Inc.",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2436",
      "zip": "95825",
      "address": "1717 Bell St",
      "phone": "(916) 252-4100",
      "fax": null,
      "email": "thewindowdoorshop@localhoneyblog.com",
      "name": "The Window and Door Shop, Inc.",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "38.5966812",
      "lon": "-121.4111969",
      "cityname": "Sacramento",
      "statename": "California"
   },
   "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": ""
}