{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 330467,
"site_id": 58,
"cat_id": 53,
"priority": 2,
"url": "https://www.scoopgator.com/poop-removal-columbia-sc",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 81272,
"approve_dt": "2025-12-24T00:00:00.000Z",
"source": null,
"submit_dt": "2024-05-02T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 20,
"referrals": null,
"country": 277,
"countrycode": "US",
"loc_id": 277,
"state_id": 39,
"city_id": 20245,
"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": {
"type": "Buffer",
"data": [
49
]
},
"logo_ext": "jpg",
"screen_ext": "png",
"pack_id": null,
"uuid": "0cdb93ca-08c5-11ef-8344-b66e99367f32",
"subdate": "May 02, 2024",
"subcategory": "Waste Removal",
"request_types": "",
"visitcount": 51
},
"visits": {
"storefront": 51,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 0,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "We are a dog waste removal service for your yard and we get rid of dog poop in your yard on a weekly basis. We also offer deodorizing and sanitizing services so that your yard will be left smelling fresh and free of brown spots. When you're busy with life, hiring us as your pooper scooper service will make your backyard cleaner, more sanitary, and will give you more time to spend with your dogs.",
"service1": "Pet Waste Removal",
"service2": "Dog Poop Pick Up Service",
"service3": "Pooper Scooper Service",
"service4": "Dog Waste Station Servicing",
"service5": "",
"service6": "",
"service7": "",
"submit_dt": "2024-05-02 20:46:29"
},
"location": {
"uuid": "0cdb93ca-08c5-11ef-8344-b66e99367f32",
"link_id": 330467,
"account_id": 81272,
"company": "Scoop Gator",
"sid": 58,
"country": 277,
"countrycode": "US",
"state": 39,
"city": "20245",
"zip": "29210",
"address": "810 Dutch Square Blvd Ste 210",
"phone": "8038067000",
"fax": null,
"email": "scoopgator@mail-burst.com",
"name": "Scoop Gator",
"status": "show",
"start_dt": "2024-08-08T00:00:00.000Z",
"end_dt": "2124-08-08T00:00:00.000Z",
"lat": "34.0341698",
"lon": "-81.0947191",
"cityname": "Columbia",
"statename": "South Carolina"
},
"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
