{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 332719,
"site_id": 76,
"cat_id": 11,
"priority": 2,
"url": "http://rawtreeandland.com",
"title": "",
"description": "Rite-A-Way Tree Service, based in St. Charles, MO, is your trusted local expert in comprehensive tree services. Our team delivers professional tree removal, precise trimming, pruning, and stump removal. Count on us for emergency storm damage cleanup, ongoing tree care maintenance, and expert tree and shrub installation. Trust Rite-A-Way for top-quality tree services, backed by years of local experience and a commitment to excellence.",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 83498,
"approve_dt": null,
"source": null,
"submit_dt": "2024-07-09T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 8,
"referrals": null,
"country": 277,
"countrycode": "US",
"loc_id": 277,
"state_id": 25,
"city_id": 12749,
"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": 5884,
"d_url": null,
"approved": null,
"logo_ext": "jpg",
"screen_ext": "png",
"pack_id": null,
"uuid": "aa3b4f5d-3db0-11ef-8344-b66e99367f32",
"subdate": "Jul 09, 2024",
"subcategory": "Tree Services",
"request_types": "",
"visitcount": 39
},
"visits": {
"storefront": 39,
"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": "Tree Removal",
"service2": "Tree Maintenance",
"service3": "Tree Stump Removal",
"service4": "Storm Damage Cleanup",
"service5": "Tree Trimming",
"service6": "",
"service7": "",
"submit_dt": "2024-07-09 05:04:05"
},
"location": {
"uuid": "aa3b4f5d-3db0-11ef-8344-b66e99367f32",
"link_id": 332719,
"account_id": 83498,
"company": "Rite-A-Way Tree Service",
"sid": 76,
"country": 277,
"countrycode": "US",
"state": 25,
"city": "12749",
"zip": "63304",
"address": "1036 David Meadows Dr",
"phone": "(314) 427-7325",
"fax": null,
"email": "rawtreeandland@brite-mail.com",
"name": "Rite-A-Way Tree Service",
"status": "show",
"start_dt": "2024-08-08T00:00:00.000Z",
"end_dt": "2124-08-08T00:00:00.000Z",
"lat": "38.734162",
"lon": "-90.6601638",
"cityname": "St. Charles",
"statename": "Missouri"
},
"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
