Big City Windows & Doors

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 342177,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://www.bigcitywindows.com/",
      "title": "Big City Windows & Doors",
      "description": "Experience the difference with Big City Windows & Doors Ottawa! We offer top-quality replacement windows and doors backed by lifetime fully-transferable warranties. Our expert consultants provide free in-home quotations, showcasing our Canadian-made products tailored to local climate conditions. With price matching and flexible financing, we make home improvement easy and affordable. Explore our stylish vinyl windows, durable exterior doors, and efficient caulking services to enhance your home''s energy efficiency and aesthetics. Contact us today to transform your living space!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 92871,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-02-10T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 3,
      "referrals": null,
      "country": 99,
      "countrycode": "CA",
      "loc_id": 99,
      "state_id": 0,
      "city_id": 161,
      "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": "d6318c3e-e791-11ef-a909-b66e99367f32",
      "subdate": "Feb 10, 2025",
      "subcategory": "Windows",
      "request_types": "",
      "visitcount": 19
   },
   "visits": {
      "storefront": 19,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 5,
      "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-02-10 09:31:42"
   },
   "location": {
      "uuid": "d6318c3e-e791-11ef-a909-b66e99367f32",
      "link_id": 342177,
      "account_id": 92871,
      "company": "Big City Windows & Doors",
      "sid": 58,
      "country": 99,
      "countrycode": "CA",
      "state": 0,
      "city": "161",
      "zip": "K1B 5L8",
      "address": "2615 Lancaster Rd #18-19",
      "phone": "613-706-0884",
      "fax": null,
      "email": "bigcitywindowsdoorslocal@gmail.com",
      "name": "Big City Windows & Doors",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "32.715885",
      "lon": "-96.8050416",
      "cityname": "Ottawa",
      "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": ""
}