EnergyGuard Windows & Doors

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 337073,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://www.energyguardwindows.com",
      "title": "EnergyGuard Windows & Doors",
      "description": "40 Years of Experience Providing Window and Door Design and Installation Services to the Greater Portland Metropolitan Area",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 87804,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-10-21T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 3,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 36,
      "city_id": 18635,
      "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": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "7caba845-8f9d-11ef-ab46-b66e99367f32",
      "subdate": "Oct 21, 2024",
      "subcategory": "Windows",
      "request_types": "",
      "visitcount": 31
   },
   "visits": {
      "storefront": 31,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 15,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Credentials:\r
BBB A+ Rating, Family Owned and Operated, EPA Lead-Safe Certified Firm, AAMA Installation Master Certified, Energy Trust of Oregon Network Contractor, Clark Public Utilities Weatherization Contractor\r
\r
Products and Services:\r
window replacement, window installation, vinyl windows, fiberglass windows, wood windows, aluminum windows, energy efficient windows, patio doors, entry doors, door replacement, door installation, custom windows, wood clad windows, interior doors, new construction window installation, new construction door installation\r
\r
Serving Cities:\r
Portland, Beaverton, Tigard, Lake Oswego, Oregon City, West Linn, Sherwood, Tualatin, Wilsonville, Hillsboro, Newberg",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-10-21 11:13:23"
   },
   "location": {
      "uuid": "7caba845-8f9d-11ef-ab46-b66e99367f32",
      "link_id": 337073,
      "account_id": 87804,
      "company": "",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 36,
      "city": "18635",
      "zip": "97132",
      "address": "516 E 2nd St",
      "phone": "(503) 554-5500",
      "fax": null,
      "email": "energyguardwindowsdoors@localhoneyblog.com",
      "name": "EnergyGuard Windows & Doors",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "45.2993136",
      "lon": "-122.9742051",
      "cityname": "Newberg",
      "statename": "Oregon"
   },
   "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": ""
}