Vanguard Concrete San Antonio

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 350664,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "https://vanguardconcretesanantonio.com/",
      "title": "Vanguard Concrete San Antonio",
      "description": "Vanguard Concrete San Antonio delivers high quality concrete work built for durability, function, and curb appeal. We specialize in concrete driveways, patios, slabs, sidewalks, stamped concrete, pool decks, sport courts, commercial pads, and more. Whether you need new installation, replacement, or demolition and rebuild, our team focuses on precision workmanship and clean, long-lasting results. From residential projects to large commercial jobs! Contact us today for a free estimate!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 101365,
      "approve_dt": "2025-11-20T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-11-20T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": null,
      "countrycode": null,
      "loc_id": null,
      "state_id": null,
      "city_id": null,
      "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": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "e346fe36-c610-11f0-bb42-b66e99367f32",
      "subdate": "Nov 20, 2025",
      "subcategory": "Concrete Contractors",
      "request_types": "",
      "visitcount": 2
   },
   "visits": {
      "storefront": 2,
      "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": "Vanguard Concrete San Antonio delivers high quality concrete work built for durability, function, and curb appeal. We specialize in concrete driveways, patios, slabs, sidewalks, stamped concrete, pool decks, sport courts, commercial pads, and more. Whether you need new installation, replacement, or demolition and rebuild, our team focuses on precision workmanship and clean, long-lasting results. From residential projects to large commercial jobs! Contact us today for a free estimate!",
      "service1": "Concrete Slabs",
      "service2": "Parking Lots",
      "service3": "Pool Decks",
      "service4": "Sport Courts",
      "service5": "Stamped Concrete",
      "service6": "Concrete Patios",
      "service7": "Concrete Driveways",
      "submit_dt": "2025-11-20 13:00:28"
   },
   "location": {
      "uuid": "e346fe36-c610-11f0-bb42-b66e99367f32",
      "link_id": 350664,
      "account_id": 101365,
      "company": "Vanguard Concrete San Antonio",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "22482",
      "zip": "78202",
      "address": "515 E Crockett St",
      "phone": "(726) 200-1600",
      "fax": null,
      "email": "noawilliamso072@gmail.com",
      "name": "Vanguard Concrete San Antonio",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "San Antonio",
      "statename": "Texas"
   },
   "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": ""
}