SCOTT LOCKHART DRAINAGE & GENERAL CONTRACTING

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 347414,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.scottlockhartdrainagecontractor.com/",
      "title": "SCOTT LOCKHART DRAINAGE & GENERAL CONTRACTING",
      "description": "Scott Lockhart is a dedicated drainage contractor who delivers real results. Serving the Austin area, he focuses on solving complex drainage issues with tailored solutions that meet local Drainage Codes. Scott combines hands-on experience with in-depth knowledge of regulations to ensure every job is done right the first timesaving clients time, stress, and future repairs.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 98108,
      "approve_dt": "2025-07-25T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-22T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 0,
      "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": 4996,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "0bbe5dc7-36d2-11f0-a909-b66e99367f32",
      "subdate": "May 22, 2025",
      "subcategory": "Home Plumbing Repair",
      "request_types": "",
      "visitcount": 20
   },
   "visits": {
      "storefront": 20,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Jeffrey Scott Lockhart is a pioneer in stormwater management and sustainable construction with over 40 years of experience in Central Texas. As founder of Scott Lockhart Austin Drainage Specialists in 1987, Austin's original stormwater management firm, he has completed over 8,000 projects across residential, commercial, and municipal sectors, specializing in innovative drainage solutions and civil consultancy with a deep understanding of water and earth movement in natural and built environments.",
      "service1": "stormwater management systems",
      "service2": " drainage contracting",
      "service3": " civil engineering consultancy",
      "service4": " land restoration",
      "service5": " water damage protection",
      "service6": " sustainable construction solutions",
      "service7": " municipal infrastructure projects",
      "submit_dt": "2025-05-22 06:00:21"
   },
   "location": {
      "uuid": "0bbe5dc7-36d2-11f0-a909-b66e99367f32",
      "link_id": 347414,
      "account_id": 98108,
      "company": "SCOTT LOCKHART DRAINAGE & GENERAL CONTRACTING",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "0",
      "zip": "78756",
      "address": "4618 Shoalwood Avenue Austin, Texas 78756",
      "phone": "5129145177",
      "fax": null,
      "email": "scottlockhartdrainagecontracto@gmail.com",
      "name": "SCOTT LOCKHART DRAINAGE & GENERAL CONTRACTING",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "30.3197198",
      "lon": "-97.7437409",
      "cityname": "",
      "statename": ""
   },
   "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": ""
}