{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 344095,
"site_id": 67,
"cat_id": 81,
"priority": 2,
"url": "https://localroofs.com/east-bay",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 94790,
"approve_dt": null,
"source": null,
"submit_dt": "2025-03-21T00: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": 5,
"city_id": 2360,
"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": 5046,
"d_url": null,
"approved": null,
"logo_ext": null,
"screen_ext": "png",
"pack_id": null,
"uuid": "48ea2f58-0603-11f0-a909-b66e99367f32",
"subdate": "Mar 21, 2025",
"subcategory": "Roofing",
"request_types": "",
"visitcount": 8
},
"visits": {
"storefront": 8,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 3,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "For over half a century, LocalRoofs has been repairing and replacing the roofs of homes and businesses in California. With offices in Pleasanton, we serve the East Bay community with unmatched craftsmanship and genuine care. Every day, LocalRoofs takes pride in doing things right, because we believe your home deserves nothing less. LocalRoofs provides free roof diagnostics and estimates, roof replacement and repair services, solar shingle roofs, and roof tune-ups. CSLB #1095477",
"service1": "",
"service2": "",
"service3": "",
"service4": "",
"service5": "",
"service6": "",
"service7": "",
"submit_dt": "2025-03-21 03:19:22"
},
"location": {
"uuid": "48ea2f58-0603-11f0-a909-b66e99367f32",
"link_id": 344095,
"account_id": 94790,
"company": "LocalRoofs",
"sid": 67,
"country": 277,
"countrycode": "US",
"state": 5,
"city": "2360",
"zip": "94588",
"address": "5890 Stoneridge Dr, Suite 109B",
"phone": "+1 925-257-4857",
"fax": null,
"email": "localroofsebca@burst-email.com",
"name": "LocalRoofs",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "37.6960028",
"lon": "-121.9323791",
"cityname": "Pleasanton",
"statename": "California"
},
"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
