Renewal by Andersen Window Replacement

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 318451,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://philadelphiawindow.com/",
      "title": "Renewal by Andersen Window Replacement",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 69644,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2020-02-07T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 140,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 37,
      "city_id": 19350,
      "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": 4183,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "957561de-56da-11ed-b77c-b66e99367f32",
      "subdate": "Feb 07, 2020",
      "subcategory": "Windows",
      "request_types": "",
      "visitcount": 197
   },
   "visits": {
      "storefront": 197,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Renewal by Andersen of Greater Philadelphia is a start to finish installer of replacement windows and outdoor patio doors. We proudly serve Philadelphia, together with parts of New Jersey and Northern Delaware. In our over 100 years of service, we have established the perfect window frame material called Fibrex that is 2x stronger than vinyl window replacements and yet is easy to maintain. We are passionate regarding energy efficiency, long term value, and developing your home in Pennsylvania, New Jersey, or Delaware even more beautiful. Our company provides free in-home consultations where we can go over options and give an energy analysis to see how much your home could benefit from greater efficiency.",
      "service1": "replacement windows",
      "service2": "door installation",
      "service3": "window installation",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2020-02-08 04:51:56"
   },
   "location": {
      "uuid": "957561de-56da-11ed-b77c-b66e99367f32",
      "link_id": 318451,
      "account_id": 69644,
      "company": "Renewal by Andersen Window Replacement",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 37,
      "city": "19350",
      "zip": "19406",
      "address": "761 5th Ave #3",
      "phone": "(484) 371-4056",
      "fax": null,
      "email": "philadelphiawindowpa@gmail.com",
      "name": "Renewal by Andersen Window Replacement",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.1031062",
      "lon": "-75.4079774",
      "cityname": "King of Prussia",
      "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": ""
}