{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 327895,
"site_id": 76,
"cat_id": 11,
"priority": 2,
"url": "http://watsonconcreteinc.com/",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 78742,
"approve_dt": "2026-01-02T00:00:00.000Z",
"source": null,
"submit_dt": "2024-01-23T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 21,
"referrals": null,
"country": 277,
"countrycode": "US",
"loc_id": 277,
"state_id": 25,
"city_id": 12167,
"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": 5851,
"d_url": null,
"approved": {
"type": "Buffer",
"data": [
49
]
},
"logo_ext": "jpg",
"screen_ext": "png",
"pack_id": null,
"uuid": "9505d4ce-b9bf-11ee-8344-b66e99367f32",
"subdate": "Jan 23, 2024",
"subcategory": "Concrete Contractors",
"request_types": "",
"visitcount": 36
},
"visits": {
"storefront": 36,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 1,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "Watson Concrete offers premier commercial concrete services in Central Missouri. Our concrete contractors in Columbia, MO bring experience and expertise to structural concrete and flatwork. We can construct concrete parking lots, curbs, driveways, and streets that will outlast the competition. We also offer convenient trucking and hauling services! Get in touch with our Watson Concrete today to request a bid.",
"service1": "Structural concrete",
"service2": "Concrete parking lots",
"service3": "Concrete driveways",
"service4": "Street and road construction",
"service5": "Foundational concrete",
"service6": "",
"service7": "",
"submit_dt": "2024-01-23 07:18:18"
},
"location": {
"uuid": "9505d4ce-b9bf-11ee-8344-b66e99367f32",
"link_id": 327895,
"account_id": 78742,
"company": "Watson Concrete Inc.",
"sid": 76,
"country": 277,
"countrycode": "US",
"state": 25,
"city": "12167",
"zip": "65201",
"address": "4747 E Meyer Industrial Dr",
"phone": "(573) 228-6678",
"fax": null,
"email": "watsoncon@mail-burst.com",
"name": "Watson Concrete Inc.",
"status": "show",
"start_dt": "2024-08-08T00:00:00.000Z",
"end_dt": "2124-08-08T00:00:00.000Z",
"lat": "38.8855309",
"lon": "-92.2677709",
"cityname": "Columbia",
"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
