{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 332664,
"site_id": 66,
"cat_id": 78,
"priority": 2,
"url": "https://www.callhoover.com/?utm_source=GBP&utm_medium=organic&utm_campaign=gbp_organic",
"title": "",
"description": "Hoover Electric, Plumbing, Heating & Cooling offers all services you need under one roof and we are able to save money by doing so. This is why we are able to offer extremely competitive pricing while still maintaining our great customer service and guaranteed satisfaction. We are a full-service business, serving residential properties and offering maintenance, renovation, design-build, and project consulting assistance.",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 83443,
"approve_dt": null,
"source": null,
"submit_dt": "2024-07-08T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 3,
"referrals": null,
"country": 277,
"countrycode": "US",
"loc_id": 277,
"state_id": 22,
"city_id": 10715,
"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": 5033,
"d_url": null,
"approved": null,
"logo_ext": null,
"screen_ext": "png",
"pack_id": null,
"uuid": "6fdd307c-3cfa-11ef-8344-b66e99367f32",
"subdate": "Jul 08, 2024",
"subcategory": "Local Plumber",
"request_types": "",
"visitcount": 27
},
"visits": {
"storefront": 27,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 11,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "",
"service1": "",
"service2": "",
"service3": "",
"service4": "",
"service5": "",
"service6": "",
"service7": "",
"submit_dt": "2024-07-08 07:19:38"
},
"location": {
"uuid": "6fdd307c-3cfa-11ef-8344-b66e99367f32",
"link_id": 332664,
"account_id": 83443,
"company": "Hoover Electric Plumbing Heating Cooling",
"sid": 66,
"country": 277,
"countrycode": "US",
"state": 22,
"city": "10715",
"zip": "48083",
"address": "1871 Woodslee Avenue",
"phone": "+1 248-277-5967",
"fax": null,
"email": "hooverelectric@brite-mail.com",
"name": "Hoover Electric Plumbing Heating Cooling",
"status": "show",
"start_dt": "2024-08-08T00:00:00.000Z",
"end_dt": "2124-08-08T00:00:00.000Z",
"lat": "42.5527948",
"lon": "-83.1110219",
"cityname": "Troy",
"statename": "Michigan"
},
"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
