Zertuche Construction

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 320727,
      "site_id": 24,
      "cat_id": 91,
      "priority": 2,
      "url": "https://zertucheconstruction.com/",
      "title": "Zertuche Construction",
      "description": "Weve built commercial spaces of all designs and sizes. We can construct school buildings, medical facilities, corporate offices, retail stores, warehouses, and many other types of buildings. Thanks to our years of experience, we understand the challenges of building for different industries. No matter the goals and specifications for your upcoming project, rest assured that we will deliver.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 71919,
      "approve_dt": "2021-04-23T00:00:00.000Z",
      "source": null,
      "submit_dt": "2021-04-15T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 766,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 22016,
      "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": 6640,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95812e91-56da-11ed-b77c-b66e99367f32",
      "subdate": "Apr 15, 2021",
      "subcategory": "Business",
      "request_types": "",
      "visitcount": 1127
   },
   "visits": {
      "storefront": 1127,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "When you are getting work done, you want to make sure that you are hiring a contractor who is qualified to get the job done and has what it takes to get it done right the first time. At Zertuche Construction, our team of contractors have years and years of experience in the construction industry.\n\nWe make sure to keep up-to-date on current trends in the industry to always give you what you are looking for. Our construction management team ensures that we are staying within your budget as discussed in the beginning of the project so there are no surprises.\n\nIf you are looking for commercial construction and need builders in the Laredo, TX area, rely on our team! Call us today and beginning your project!\n\n",
      "service1": "Healthcare",
      "service2": " Retail & Restaurants",
      "service3": " Professional Offices",
      "service4": " Tenant Improvements",
      "service5": " Government",
      "service6": " K-12 Education",
      "service7": " Recreation",
      "submit_dt": "2021-04-15 08:51:10"
   },
   "location": {
      "uuid": "95812e91-56da-11ed-b77c-b66e99367f32",
      "link_id": 320727,
      "account_id": 71919,
      "company": "Zertuche Construction",
      "sid": 24,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "22016",
      "zip": "78041",
      "address": "107 Calle Del Norte Dr #4",
      "phone": "956-727-3112",
      "fax": null,
      "email": "zertueconstruction@gmail.com",
      "name": "Zertuche Construction",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "27.5537264",
      "lon": "-99.4947081",
      "cityname": "Laredo",
      "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": ""
}