{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 342978,
"site_id": 58,
"cat_id": 53,
"priority": 2,
"url": "https://www.arizonarolloffservices.com/",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 93673,
"approve_dt": null,
"source": null,
"submit_dt": "2025-02-26T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 7,
"referrals": null,
"country": 277,
"countrycode": "US",
"loc_id": 277,
"state_id": 3,
"city_id": 990,
"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": 4284,
"d_url": null,
"approved": null,
"logo_ext": "jpg",
"screen_ext": "png",
"pack_id": null,
"uuid": "4727c386-f413-11ef-a909-b66e99367f32",
"subdate": "Feb 26, 2025",
"subcategory": "Waste Removal",
"request_types": "",
"visitcount": 40
},
"visits": {
"storefront": 40,
"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": "From our drivers to our owners, we have decades of experience in the waste disposal business. We've seen it all when it comes to trash removal, and we know what it takes to get the job done. We'll put our dedication and experience to work for you to deliver the kind of efficient and reliable service you deserve.",
"service1": "",
"service2": "",
"service3": "",
"service4": "",
"service5": "",
"service6": "",
"service7": "",
"submit_dt": "2025-02-26 07:28:30"
},
"location": {
"uuid": "4727c386-f413-11ef-a909-b66e99367f32",
"link_id": 342978,
"account_id": 93673,
"company": "Arizona Roll Off & Front Load Services",
"sid": 58,
"country": 277,
"countrycode": "US",
"state": 3,
"city": "990",
"zip": "85034",
"address": "830 E Sherman St",
"phone": "(480) 725-7240",
"fax": null,
"email": "arizonarolloff@brite-email.com",
"name": "Arizona Roll Off & Front Load Services",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "33.4400706",
"lon": "-112.0634754",
"cityname": "Phoenix",
"statename": "Arizona"
},
"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
