{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 343526,
"site_id": 69,
"cat_id": 65,
"priority": 2,
"url": "https://mainstreetsod.com/",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 94221,
"approve_dt": null,
"source": null,
"submit_dt": "2025-03-10T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": 1,
"clickcount": 3,
"referrals": null,
"country": 277,
"countrycode": "US",
"loc_id": 277,
"state_id": 32,
"city_id": 15779,
"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": 5200,
"d_url": null,
"approved": null,
"logo_ext": null,
"screen_ext": "png",
"pack_id": null,
"uuid": "46c38ba5-fd78-11ef-a909-b66e99367f32",
"subdate": "Mar 10, 2025",
"subcategory": "Lawn Care",
"request_types": "",
"visitcount": 21
},
"visits": {
"storefront": 21,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 8,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "Main Street Sod Company is Charlotte, NC's trusted expert in sod installation for residential and commercial properties. Offering lush, high-quality sod that transforms ordinary landscapes into vibrant, green lawns. Whether you're a homeowner looking for an instant lawn upgrade or a business needing a durable, professional turf solution, our team ensures seamless installation and long-lasting results. We source only the best sod varieties, suited for the Carolina climate, ensuring superior growth, resilience, and curb appeal. From new construction to lawn replacements and erosion control, we provide expert guidance and precision installation to create a healthy, thriving lawn with minimal maintenance. Call now for a Free Estimate today.",
"service1": "Turf Installation",
"service2": "Sod Installation",
"service3": "Sod Repair",
"service4": "Sod Preparation",
"service5": "Mega Rolls",
"service6": "",
"service7": "",
"submit_dt": "2025-03-10 06:24:09"
},
"location": {
"uuid": "46c38ba5-fd78-11ef-a909-b66e99367f32",
"link_id": 343526,
"account_id": 94221,
"company": "Main Street Sod Company",
"sid": 69,
"country": 277,
"countrycode": "US",
"state": 32,
"city": "15779",
"zip": "28277",
"address": "15720 Brixham Hill Avenue, suite 305",
"phone": "+1 704-349-2872",
"fax": null,
"email": "mainstreetsodcompany@brite-mail.com",
"name": "Main Street Sod Company",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "35.0592291",
"lon": "-80.8520463",
"cityname": "Charlotte",
"statename": "North 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
