The Best Brands Of Doors & Windows In The Bay Area

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 327672,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://www.alexanderco.com/",
      "title": "The Best Brands Of Doors & Windows In The Bay Area",
      "description": "Credentials: BBB A+ Rating, Family Owned Since 1971, Angie''s List Super Service Award, Best of Houzz, Diamond Certified, Hero Registered Contractor, Installation Masters, EPA Lead Safe Certified Firm, Energy Star, General Contractor",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 78521,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-01-15T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 27,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 1733,
      "ltop": "",
      "facebook": "https://www.facebook.com/bayareawindows/",
      "tiktok": null,
      "linkedin": "",
      "twitter": "https://twitter.com/AlexanderCmpny",
      "googleplus": "",
      "youtube_channel": "",
      "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": "9fd2a7f6-b3a7-11ee-8344-b66e99367f32",
      "subdate": "Jan 15, 2024",
      "subcategory": "Windows",
      "request_types": "",
      "visitcount": 71
   },
   "visits": {
      "storefront": 71,
      "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": "window replacement, window installation, vinyl windows, fiberglass windows, wood windows, aluminum windows, energy efficient windows, sliding doors, patio doors, entry doors, french doors, door replacement, door installation, residential window replacement, residential door replacement, commercial window replacement, commercial door replacement, residential windows, residential doors, commercial windows, commercial doors, skylights, window repair, door repair, bay windows, dry rot repair, stucco",
      "service1": "Window Replacement",
      "service2": "Door Replacement",
      "service3": "Window Installation Service",
      "service4": "Window Supplier",
      "service5": "Door Supplier",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-01-15 13:11:41"
   },
   "location": {
      "uuid": "9fd2a7f6-b3a7-11ee-8344-b66e99367f32",
      "link_id": 327672,
      "account_id": 78521,
      "company": "Alexander Company",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "1733",
      "zip": "94010",
      "address": "1322 Marsten Rd",
      "phone": "(650) 288-0813",
      "fax": null,
      "email": "alexanderwindow@wehaveprepared.com",
      "name": "Alexander Company",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "37.5909424",
      "lon": "-122.3635891",
      "cityname": "Burlingame",
      "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": ""
}