McQuarrie

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 316817,
      "site_id": 37,
      "cat_id": 57,
      "priority": 2,
      "url": "http://www.mcquarrie.com/",
      "title": "McQuarrie",
      "description": "


Service Hours: Monday-Friday: 8:30 am-5:00 pm
\r\nPayments Accepted: Credit Card (visa, mastercard, amex), Debit, Cash, Online Merchant (RBC, TD, CIBC, BMO, Scotia)",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68014,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-03-28T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 89,
      "referrals": null,
      "country": 99,
      "countrycode": "CA",
      "loc_id": 99,
      "state_id": 0,
      "city_id": 1323,
      "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": 2239,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "956c5421-56da-11ed-b77c-b66e99367f32",
      "subdate": "Mar 28, 2019",
      "subcategory": "Legal Services",
      "request_types": "",
      "visitcount": 106
   },
   "visits": {
      "storefront": 106,
      "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": "The law office of McQuarrie LLP is centrally located in Surrey, BC but also serves clients in the surrounding areas. The firm has over 50 years of experience in corporate, real estate & land development, commercial/private litigation, wills & estates, family and personal injury law matters.",
      "service1": "surrey corporate lawyer",
      "service2": "surrey real estate lawyer",
      "service3": "surrey family lawyer",
      "service4": "surrey personal injury lawyer",
      "service5": "surrey lawyer",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-03-28 04:42:40"
   },
   "location": {
      "uuid": "956c5421-56da-11ed-b77c-b66e99367f32",
      "link_id": 316817,
      "account_id": 68014,
      "company": "McQuarrie",
      "sid": 37,
      "country": 99,
      "countrycode": "CA",
      "state": 0,
      "city": "1323",
      "zip": "V3T 5X3",
      "address": "15th Floor, Central City Tower, Suite 1500, 13450 102nd Ave, Surrey",
      "phone": "(604) 581-7001",
      "fax": null,
      "email": "mcquarriesurrey@gmail.com",
      "name": "McQuarrie",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "49.187777",
      "lon": "-122.84943",
      "cityname": "British Columbia",
      "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": ""
}