BETCO Scaffolds

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 331545,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.scaffold.com/",
      "title": "BETCO Scaffolds",
      "description": "BETCO Scaffolds has over 79 years of experience as a scaffolding company Houston, TX. Contractors trust BETCO to support construction and renovation projects of any size. Scaffolding is an essential tool for any construction project, providing a stable and secure structure to carry workers and material above the first floor. Investing in safe, quality scaffolding will help your project progress more smoothly and reduce construction costs in the long run.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 82338,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-06-06T00: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": 42,
      "city_id": 21883,
      "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": 6646,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "8aba93c8-23ba-11ef-8344-b66e99367f32",
      "subdate": "Jun 06, 2024",
      "subcategory": "Construction",
      "request_types": "",
      "visitcount": 64
   },
   "visits": {
      "storefront": 64,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "Temporary Fence",
      "service2": "Edge Protection",
      "service3": "Debris Chutes",
      "service4": "Safety Training",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-06-06 04:09:17"
   },
   "location": {
      "uuid": "8aba93c8-23ba-11ef-8344-b66e99367f32",
      "link_id": 331545,
      "account_id": 82338,
      "company": "BETCO Scaffolds",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "21883",
      "zip": "77009",
      "address": "1626 Enid Street",
      "phone": "+12818499745",
      "fax": null,
      "email": "betcoscaffolds@brite-mail.com",
      "name": "BETCO Scaffolds",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "29.8066375",
      "lon": "-95.3749816",
      "cityname": "Houston",
      "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": ""
}