{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 347016,
"site_id": 6,
"cat_id": 39,
"priority": 2,
"url": "https://www.hotwaternowco.com/",
"title": " ",
"description": " Reliable Hot Water, Anytime You Need It!\r\n\r\nSince 2006, Hot Water Now! has been Denver’s trusted expert in water heating solutions, ensuring homes and businesses never run out of hot water. Whether you need tank or tankless water heater installation, repairs, maintenance, or cleaning, our skilled technicians are here to provide top-tier service.",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 97711,
"approve_dt": null,
"source": null,
"submit_dt": "2025-05-16T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 2,
"referrals": null,
"country": 277,
"countrycode": "US",
"loc_id": 277,
"state_id": 6,
"city_id": 3035,
"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": "jpg",
"screen_ext": "png",
"pack_id": null,
"uuid": "996b2e03-3208-11f0-a909-b66e99367f32",
"subdate": "May 16, 2025",
"subcategory": "Home And Garden",
"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": "Sump Pump Installation",
"service2": "Toilet Installation",
"service3": "Gas Line Installation",
"service4": "Frozen Pipes",
"service5": "Commercial Repair",
"service6": "",
"service7": "",
"submit_dt": "2025-05-16 03:48:16"
},
"location": {
"uuid": "996b2e03-3208-11f0-a909-b66e99367f32",
"link_id": 347016,
"account_id": 97711,
"company": "Hot Water Now!",
"sid": 6,
"country": 277,
"countrycode": "US",
"state": 6,
"city": "3035",
"zip": "80031",
"address": "9080 Marshall Ct",
"phone": "(303) 532-1013",
"fax": null,
"email": "hotwaternowco@burst-email.com",
"name": "Hot Water Now!",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "39.8586635",
"lon": "-105.0667173",
"cityname": "Westminster",
"statename": "Colorado"
},
"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
