{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 337428,
"site_id": 67,
"cat_id": 81,
"priority": 2,
"url": "https://www.schoenherrroofing.com",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 88157,
"approve_dt": null,
"source": null,
"submit_dt": "2024-10-29T00: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": 22,
"city_id": 10637,
"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": 5047,
"d_url": null,
"approved": null,
"logo_ext": "jpg",
"screen_ext": "png",
"pack_id": null,
"uuid": "acc4b8a2-95ba-11ef-ab46-b66e99367f32",
"subdate": "Oct 29, 2024",
"subcategory": "Roofing Contractor",
"request_types": "",
"visitcount": 33
},
"visits": {
"storefront": 33,
"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": "We want to provide you with the best experience you have ever had with a contractor. Schoenherr Roofing is an exterior and roofing contractor with our headquarters based in Romeo, MI, serving all of Southeast Michigan from this location. We primarily offer roof installation, roof repair, siding installation, gutter repair and replacements, insulation, and flat and commercial roofing services in Macomb and Oakland counties. We pride ourselves on our transparent and thorough approach.",
"service1": "Roof Installation",
"service2": "Roof Replacement",
"service3": "Roof Repair",
"service4": "Gutter Installation",
"service5": "Siding Installation",
"service6": "",
"service7": "",
"submit_dt": "2024-10-29 05:57:26"
},
"location": {
"uuid": "acc4b8a2-95ba-11ef-ab46-b66e99367f32",
"link_id": 337428,
"account_id": 88157,
"company": "Schoenherr Roofing",
"sid": 67,
"country": 277,
"countrycode": "US",
"state": 22,
"city": "10637",
"zip": "48065",
"address": "102 West Saint Clair Street",
"phone": "+1 (248) 678-8141",
"fax": null,
"email": "schoenherrroofing@burst-email.com",
"name": "Schoenherr Roofing",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "42.802715",
"lon": "-83.0137923",
"cityname": "Romeo",
"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
