American Vision Windows of Arizona

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348573,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "http://americanvisionwindowsaz.coM/?utm_source=google&utm_medium=gmb&utm_campaign=avw&utm_content=LOCAL%20SEO%20GMB%20AZ",
      "title": "American Vision Windows of Arizona",
      "description": "American Vision Windows is a home improvement company focused on delivering incredible, lasting value through professional window installation and energy-efficient solutions. Built around a team of certified technicians and home improvement experts, they prioritize customer satisfaction, timely professional service, and quality workmanship, with many customers returning for multiple projects due to their commitment to keeping their word and finishing jobs right.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 99268,
      "approve_dt": "2025-07-11T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-12T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 0,
      "city_id": 0,
      "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": 6612,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "b67fab59-475e-11f0-a909-b66e99367f32",
      "subdate": "Jun 12, 2025",
      "subcategory": "Window Screens",
      "request_types": "",
      "visitcount": 15
   },
   "visits": {
      "storefront": 15,
      "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": "American Vision Windows of Arizona, established in 2010, is a premier window and door provider committed to transforming the home improvement experience. With over 10,000 satisfied customers, American Vision Windows of Arizona is now the leading window replacement company in Arizona. Our extensive range of superior quality windows and doors enhances the aesthetics and energy efficiency of your home. Known for second-to-none installation services, American Vision Windows is the authority when it comes to windows and doors in Arizona. (ROC 267599)",
      "service1": "window installation and replacement",
      "service2": " energy-efficient window solutions",
      "service3": " professional installation services",
      "service4": " home improvement consulting",
      "service5": " energy-saving advisory services",
      "service6": " certified technician installations",
      "service7": " multi-project home transformations",
      "submit_dt": "2025-06-12 07:27:36"
   },
   "location": {
      "uuid": "b67fab59-475e-11f0-a909-b66e99367f32",
      "link_id": 348573,
      "account_id": 99268,
      "company": "American Vision Windows of Arizona",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 0,
      "city": "0",
      "zip": "85233",
      "address": "377 South Hamilton Court, Gilbert, Arizona",
      "phone": "+1 480-805-1793",
      "fax": null,
      "email": "americanvisionwi@brite-email.com",
      "name": "",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "33.342935",
      "lon": "-111.8314269",
      "cityname": "",
      "statename": ""
   },
   "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": ""
}