Contractor in Hamilton, Ontario

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 347992,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://duarte.company/",
      "title": "Contractor in Hamilton, Ontario",
      "description": "We are a family owned company which began in Europe in 1996 and expanded into North America in 2011. Tile work and renovations are our specialty. We pride ourselves on expert craftsmanship and great relationships with both suppliers and customers. Forget hidden charges. We offer free on-site consultations resulting in a more accurate estimate taking all aspects of your project into consideration. Don't be left in the dark, contact us today!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 98687,
      "approve_dt": "2025-07-18T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-02T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 99,
      "countrycode": "CA",
      "loc_id": 99,
      "state_id": 0,
      "city_id": 1328,
      "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": 6285,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "5b671cff-3f8c-11f0-a909-b66e99367f32",
      "subdate": "Jun 02, 2025",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 41
   },
   "visits": {
      "storefront": 41,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 12,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We are a family owned company which began in Europe in 1996 and expanded into North America in 2011. Tile work and renovations are our specialty. We pride ourselves on expert craftsmanship and great relationships with both suppliers and customers. Forget hidden charges. We offer free on-site consultations resulting in a more accurate estimate taking all aspects of your project into consideration. Don't be left in the dark, contact us today!",
      "service1": "Tile contractor",
      "service2": "Interior Renovations",
      "service3": "Bathroom renovation",
      "service4": "Basement renovation",
      "service5": "Kitchen renovation",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-06-02 08:34:11"
   },
   "location": {
      "uuid": "5b671cff-3f8c-11f0-a909-b66e99367f32",
      "link_id": 347992,
      "account_id": 98687,
      "company": "Duarte Tile - Hamilton",
      "sid": 76,
      "country": 99,
      "countrycode": "CA",
      "state": 0,
      "city": "1328",
      "zip": "L8R 2G3",
      "address": "24 Colbourne St, Hamilton",
      "phone": "(289) 933-6583",
      "fax": null,
      "email": "duarte@brite-post.com",
      "name": "Duarte Tile - Hamilton",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "43.2638345",
      "lon": "-79.8671113",
      "cityname": "Ontario",
      "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": ""
}