PremiumTurfLawnCareandMaintenanceLLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 327644,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "http://premiumturflawn.com/",
      "title": "PremiumTurfLawnCareandMaintenanceLLC",
      "description": "Welcome to Premium Turf Lawn Care and Maintenance LLC, your premier choice for both residential and commercial lawn care in Schertz, Converse, Live Oak, and surrounding areas. With our extensive experience and a deep love for outdoor aesthetics, we specialize in turning your lawns into beautifully maintained landscapes. Whether you''re a homeowner desiring a stunning outdoor retreat or a business seeking impressive curb appeal, our skilled team provides customized services.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 78493,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-01-15T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 23,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 22482,
      "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": 5870,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "bd66a6d2-b344-11ee-8344-b66e99367f32",
      "subdate": "Jan 15, 2024",
      "subcategory": "Lawn Service",
      "request_types": "",
      "visitcount": 58
   },
   "visits": {
      "storefront": 58,
      "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": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-01-15 01:23:51"
   },
   "location": {
      "uuid": "bd66a6d2-b344-11ee-8344-b66e99367f32",
      "link_id": 327644,
      "account_id": 78493,
      "company": "Premium Turf Lawn Care and Maintenance, LLC",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "22482",
      "zip": "78247",
      "address": "15851 Marisa Pl",
      "phone": "(210) 905-5982",
      "fax": null,
      "email": "premiumturflawn@mail-burst.com",
      "name": "Premium Turf Lawn Care and Maintenance, LLC",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "29.5922774",
      "lon": "-98.3969006",
      "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": ""
}