Drane Ranger

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 315787,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "http://draneranger.com/",
      "title": "Drane Ranger",
      "description": "Drane Ranger offers liquid waste management services including grit and lint trap cleaning, grease trap odor control, lift station and wet well cleaning, septic tank cleaning, wash bays for equipment, vacuum truck services, etc. in Houston, Manvel, Alvin, and Pearland.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 66999,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2018-09-18T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 126,
      "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": 4197,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9566cbba-56da-11ed-b77c-b66e99367f32",
      "subdate": "Sep 18, 2018",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 163
   },
   "visits": {
      "storefront": 163,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 1,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Drane Ranger offers liquid waste management services including grit and lint trap cleaning, grease trap odor control, lift station and wet well cleaning, septic tank cleaning, wash bays for equipment, vacuum truck services, etc. in Houston, Manvel, Alvin, and Pearland.",
      "service1": "Commercial Grease Trap Cleaning",
      "service2": "Restaurant Grease Trap Cleaning",
      "service3": "Grit Trap Cleaning Near Me",
      "service4": "Septic Tank Cleaning Houston Texas",
      "service5": "Septic Tank Pump Out Service",
      "service6": "Septic Tank Pumping Companies",
      "service7": "Septic Tank Maintenance in Alvin TX",
      "submit_dt": "2018-09-18 09:30:09"
   },
   "location": {
      "uuid": "9566cbba-56da-11ed-b77c-b66e99367f32",
      "link_id": 315787,
      "account_id": 66999,
      "company": "Drane Ranger",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "21883",
      "zip": "77047",
      "address": "13911 India St",
      "phone": "",
      "fax": null,
      "email": "draran04@gmail.com",
      "name": "Drane Ranger",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "29.6048847",
      "lon": "-95.4180304",
      "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": ""
}