Hecra Painting

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 345067,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://hecrapainting.ca/",
      "title": "Hecra Painting",
      "description": "At HECRA Painting, we don't just apply paint; we transform spaces into vibrant reflections of your personality and style. Serving the communities of Oakville, Burlington, Georgetown, Mississauga, and Hamilton, our expert team specializes in interior and exterior painting, as well as cabinet refinishing. Whether you're looking to brighten up your living room, enhance your home's curb appeal, or modernize your kitchen cabinets, we use premium-quality materials and meticulous craftsmanship to bring your vision to life.\r\n\r\nOur commitment to excellence ensures a seamless and stress-free experience from start to finish. We take the time to understand your unique vision and use only premium-quality paints and materials to ensure a lasting finish.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95762,
      "approve_dt": "2025-10-15T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-04-10T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "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": 5875,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "04323e66-15d0-11f0-a909-b66e99367f32",
      "subdate": "Apr 10, 2025",
      "subcategory": "Painting Contractors",
      "request_types": "",
      "visitcount": 27
   },
   "visits": {
      "storefront": 27,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 13,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Hecra Painting brings decades of experience to every project, transforming spaces with premium-quality materials and meticulous craftsmanship. From refreshing interiors and protecting exteriors to refinishing cabinets, our professional team delivers flawless results that exceed expectations. We take time to understand your vision and ensure a seamless, stress-free experience from start to finish—creating spaces that elevate the way you live.",
      "service1": "Interior Painting",
      "service2": " Exterior Painting",
      "service3": " Cabinet Painting & Refinishing",
      "service4": " Trim & Door Painting",
      "service5": " Deck & Fence Staining",
      "service6": " Drywall Repair",
      "service7": " Color Consultation",
      "submit_dt": "2025-04-10 05:52:41"
   },
   "location": {
      "uuid": "04323e66-15d0-11f0-a909-b66e99367f32",
      "link_id": 345067,
      "account_id": 95762,
      "company": "Hecra Painting",
      "sid": 76,
      "country": 99,
      "countrycode": "CA",
      "state": 0,
      "city": "1328",
      "zip": "L0R 1H2",
      "address": "233 Carlisle Road, Hamilton",
      "phone": "+1 437-296-0304",
      "fax": null,
      "email": "hecrapainting@brite-email.com",
      "name": "Hecra Painting",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "43.3916159",
      "lon": "-79.9847405",
      "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": ""
}