Crystal Clear Windows & Doors

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 315788,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://crystalclearwindowinstalls.com/ \t",
      "title": "Crystal Clear Windows & Doors ",
      "description": "From sliding doors to sunrooms, our windows and door services are great for people who are looking to renovate their homes with brand new windows and doors. All our windows and doors are energy efficient, properly maintained and protected so they last longer and bring your home stability. Family owned and operated, we make our customers’ satisfaction the top priority. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 67000,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2018-09-18T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 144,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 9,
      "city_id": 3371,
      "ltop": "",
      "facebook": "https://www.facebook.com/windowsdoors1/ ",
      "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": 6613,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9566c405-56da-11ed-b77c-b66e99367f32",
      "subdate": "Sep 18, 2018",
      "subcategory": "Window Shields",
      "request_types": "",
      "visitcount": 195
   },
   "visits": {
      "storefront": 195,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 4,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Stationed in the heart of Clearwater, Crystal Clear Windows & Doors is dedicated to helping fortify and beautify your wonderful home. We are the best window installation experts in Clearwater, FL.",
      "service1": "Sliding doors and sunroom",
      "service2": "Impact Window Installation",
      "service3": "SGD install or Replace",
      "service4": "Double Doors and Single Doors - install or Replace",
      "service5": "Windows (Exterior) - install or Replace",
      "service6": "Doors (Exterior) - Install or Replace",
      "service7": "",
      "submit_dt": "2018-09-18 17:30:38"
   },
   "location": {
      "uuid": "9566c405-56da-11ed-b77c-b66e99367f32",
      "link_id": 315788,
      "account_id": 67000,
      "company": "Crystal Clear Windows & Doors ",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 9,
      "city": "3371",
      "zip": "33763\t",
      "address": "1885 Palm Drive",
      "phone": "727-210-3506 ",
      "fax": null,
      "email": "david23wtsdigital@gmail.com",
      "name": "Crystal Clear Windows & Doors ",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "28.0014408",
      "lon": "-82.7588385",
      "cityname": "Clearwater",
      "statename": "Florida"
   },
   "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": ""
}