Spring Views Lawn Care

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 350355,
      "site_id": 69,
      "cat_id": 65,
      "priority": 0,
      "url": "https://springviewslawncare.com/",
      "title": "Spring Views Lawn Care",
      "description": "Spring Views Lawn Care is a locally owned, family-operated lawn care company based in Westerville, Ohio. They provide professional services including lawn maintenance, seasonal cleanups, and turf care, ensuring healthy, green, and well-kept lawns. Serving Westerville and surrounding areas like Columbus, New Albany, Lewis Center, and Hilliard, they combine experience, personalized service, and efficiency for all residential and commercial clients.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 101049,
      "approve_dt": "2025-10-15T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-10-15T00: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": 34,
      "city_id": 16903,
      "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": 5203,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "40a44556-a9a8-11f0-bb42-b66e99367f32",
      "subdate": "Oct 15, 2025",
      "subcategory": "Home Landscaping",
      "request_types": "",
      "visitcount": 9
   },
   "visits": {
      "storefront": 9,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 5,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Spring Views Lawn Care is a trusted, family-owned lawn care company serving Westerville, Ohio, and nearby areas including Columbus, New Albany, Lewis Center, and Hilliard. Specializing in comprehensive lawn care services, the company offers expert lawn maintenance, seasonal cleanups, and turf care solutions designed to keep residential and commercial properties lush, healthy, and visually appealing throughout the year. Our professional team focuses on quality and efficiency, handling mowing, trimming, edging, fertilization, and debris removal with care and precision. As a fully licensed and insured business, Spring Views Lawn Care combines experience with personalized customer service, treating each client like family and ensuring complete satisfaction.\n",
      "service1": "lawn mowing",
      "service2": "landscaping services",
      "service3": "lawn maintenance",
      "service4": "lawn care",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-10-15 09:20:55"
   },
   "location": {
      "uuid": "40a44556-a9a8-11f0-bb42-b66e99367f32",
      "link_id": 350355,
      "account_id": 101049,
      "company": "Spring Views Lawn Care",
      "sid": 69,
      "country": 277,
      "countrycode": "US",
      "state": 34,
      "city": "16903",
      "zip": "43231",
      "address": "5520 Palmira Way",
      "phone": "6145518258",
      "fax": null,
      "email": "springviewslawncareoh@gmail.com",
      "name": "Spring Views Lawn Care",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Columbus",
      "statename": "Ohio"
   },
   "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": ""
}