TurFresh

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 352499,
      "site_id": 69,
      "cat_id": 65,
      "priority": 0,
      "url": "https://turfresh.com/california/sacramento/",
      "title": "TurFresh",
      "description": "TurFresh offers artificial turf cleaning in Sacramento, California for homeowners and businesses that want clean, secure, and odor cost-free artificial grass all year. As a family had company with more than 20 years of experience, TurFresh specializes in specialist artificial turf cleaning and restoration using a warrantied 10 point procedure. This comprehensive service removes odor creating bacteria, restores turf systems, and refreshes artificial grass surfaces. Eco friendly cleaning methods help get rid of pet odors, enhance drain, and extend the life of artificial turf.\nWith a solid concentrate on tailored service and focus to detail, TurFresh supplies regular, dependable results relied on by Sacramento homeowner that desire their turf looking fresh, clean, and well maintained.\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 103238,
      "approve_dt": "2026-04-06T00:00:00.000Z",
      "source": null,
      "submit_dt": "2026-04-05T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2436,
      "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": 5200,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "07e459ee-3108-11f1-bb42-b66e99367f32",
      "subdate": "Apr 05, 2026",
      "subcategory": "Lawn Care",
      "request_types": "",
      "visitcount": 8
   },
   "visits": {
      "storefront": 8,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 0,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Phone number: +1 916-269-5545",
      "service1": "TurfScrub",
      "service2": "TurfSpray",
      "service3": "TurfAid",
      "service4": "TurFlush",
      "service5": "TurfSwap",
      "service6": "TurFix",
      "service7": "TurfBloom",
      "submit_dt": "2026-04-05 15:56:38"
   },
   "location": {
      "uuid": "07e459ee-3108-11f1-bb42-b66e99367f32",
      "link_id": 352499,
      "account_id": 103238,
      "company": "John  Pla",
      "sid": 69,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2436",
      "zip": "95819",
      "address": "5363 H St Ste A",
      "phone": "916-269-5545",
      "fax": null,
      "email": "turfreshcalifornia@gmail.com",
      "name": "TurFresh",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Sacramento",
      "statename": "California"
   },
   "socialmedia": [
      {
         "title": "Facebook",
         "ptype_id": 29,
         "dbtable": "links_socialmedia",
         "item": "Facebook",
         "cnt": null
      },
      {
         "title": "Instagram",
         "ptype_id": 30,
         "dbtable": "links_socialmedia",
         "item": "Instagram",
         "cnt": null
      },
      {
         "title": "Youtube",
         "ptype_id": 31,
         "dbtable": "links_socialmedia",
         "item": "Youtube Video",
         "cnt": null
      },
      {
         "title": "LinkedIn",
         "ptype_id": 32,
         "dbtable": "links_socialmedia",
         "item": "LinkedIn",
         "cnt": null
      },
      {
         "title": "TikTok",
         "ptype_id": 33,
         "dbtable": "links_socialmedia",
         "item": "TikTok",
         "cnt": null
      },
      {
         "title": "Twitter",
         "ptype_id": 34,
         "dbtable": "links_socialmedia",
         "item": "Twitter",
         "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": ""
}