{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 346219,
"site_id": 6,
"cat_id": 39,
"priority": 2,
"url": "https://www.247restorationshamilton.com/",
"title": " ",
"description": " ",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 96914,
"approve_dt": null,
"source": null,
"submit_dt": "2025-05-01T00: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": 4,
"city_id": 157,
"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": 288,
"d_url": null,
"approved": null,
"logo_ext": null,
"screen_ext": "png",
"pack_id": null,
"uuid": "e035686d-2658-11f0-a909-b66e99367f32",
"subdate": "May 01, 2025",
"subcategory": "Home And Garden",
"request_types": "",
"visitcount": 53
},
"visits": {
"storefront": 53,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 27,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "We're your trusted partner for renovation, restoration & emergency mitigation services for homeowners, commercial real estate owners, and business owners. We're a locally-owned renovation & disaster recovery company serving clients throughout Hamilton and the surrounding area. Our team of skilled contractors can assist you with water damage restoration, fire damage restoration, emergency remediation services, along with both asbestos removal and mould removal services. We provide repairs, renovations, and emergency mitigation solutions to homeowners and commercial clients across the Golden Horseshoe. Give us a call today for a free no obligations quote. Our experts are available 24 hours a day, 7 days a week; call us anytime you need help.",
"service1": "Fire Damage Restoration Services",
"service2": "Water Damage Restoration Services",
"service3": "Emergency Remediation Services",
"service4": "Asbestos Removal Services",
"service5": "Mould Removal Services",
"service6": "",
"service7": "",
"submit_dt": "2025-05-01 06:52:40"
},
"location": {
"uuid": "e035686d-2658-11f0-a909-b66e99367f32",
"link_id": 346219,
"account_id": 96914,
"company": "",
"sid": 6,
"country": 99,
"countrycode": "CA",
"state": 4,
"city": "157",
"zip": "L8L 5Y4",
"address": "42 Madison Avenue",
"phone": "+12897689263",
"fax": null,
"email": "restorationshamilton@brite-email.com",
"name": " ",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "35.8945979",
"lon": "-91.0852672",
"cityname": "Hamilton",
"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": ""
}
all our featured social media
