American Vision Windows

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 340092,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://www.americanvisionwindows.com/locations/orange-county",
      "title": "American Vision Windows",
      "description": "American Vision Windows is the No. 1 window replacement company in California, with almost one million windows installed and a reputation for excellence. Over the last 20+ years, customers have turned to us for exceptional access to the leading window design styles and names, all in one place. But were also much more than panes and frames. American Vision Windows also specializes in door replacement, bathroom remodeling, and eco-friendly paint and texture coating to beautify your home and add value, with all products and brands installed by highly skilled craftsmen and appointments set around customers busy schedules.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 90791,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-01-03T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 4,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2597,
      "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": "cb059e93-c9c9-11ef-a909-b66e99367f32",
      "subdate": "Jan 03, 2025",
      "subcategory": "Windows",
      "request_types": "",
      "visitcount": 14
   },
   "visits": {
      "storefront": 14,
      "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": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-01-03 11:56:40"
   },
   "location": {
      "uuid": "cb059e93-c9c9-11ef-a909-b66e99367f32",
      "link_id": 340092,
      "account_id": 90791,
      "company": "",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2597",
      "zip": "92780",
      "address": "15401 Redhill Avenue, Suite F",
      "phone": "714-418-4966",
      "fax": null,
      "email": "americanvisiontustin@protonmail.com",
      "name": "American Vision Windows",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "33.7174154",
      "lon": "-117.832196",
      "cityname": "Tustin",
      "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": ""
}