Sergio''s Lawn Services Landscaping Chandler AZ

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 310402,
      "site_id": 69,
      "cat_id": 65,
      "priority": 0,
      "url": "http://azlawnservices.com",
      "title": "Sergio''s Lawn Services Landscaping Chandler AZ ",
      "description": "Since 1986, we have been providing exceptional landscaping services to the homes and businesses in Chandler, Phoenix, and the nearby areas. We have maintained a high quality of service through our dedication to going above and beyond client expectations. Our aim is to ensure your landscape is vibrant, verdant, and beautifully designed to complement your property.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 61637,
      "approve_dt": "2015-09-10T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-09-09T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1629,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 3,
      "city_id": 990,
      "ltop": "",
      "facebook": "",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 5222,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "954d12a5-56da-11ed-b77c-b66e99367f32",
      "subdate": "Sep 09, 2015",
      "subcategory": "Commercial Landscaping",
      "request_types": "",
      "visitcount": 1949
   },
   "visits": {
      "storefront": 1949,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 18,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Lawn Service and Maintenance
\nWhether you are in need of routine lawn maintenance or sod installation for your property, we provide you with the exact service you need to maintain your land in the best condition. Our expertise includes lawn maintenance, hardscape installations, and much more. Our comprehensive service will guarantee the enhanced appearance of your property, raising its value and providing you with increased enjoyment.\n
\n
Our staff has consistently provided landscaping services that have made us the company of choice throughout Phoenix and Chandler, AZ. Our landscapers can handle any size project with skill and efficiency.\n
\n
Whether you are in need of routine lawn maintenance or sod installation for your property, we provide you with the exact service you need to maintain your land in the best condition. Our expertise includes lawn maintenance, hardscape installations, and much more. Our comprehensive service will guarantee the enhanced appearance of your property, raising its value and providing you with increased enjoyment.\n
\n
We offer free estimates on all lawn services and maintenance work. You can rest assured that with Sergiou2019s Lawn Service, your lawn is always in the best of hands.",
      "service1": "Rock & Sod Installation",
      "service2": " New Lawn Installer",
      "service3": " Fertilizing",
      "service4": " Sprinkler Repair",
      "service5": " Weed Control",
      "service6": " Aeration",
      "service7": " Lawn Service",
      "submit_dt": "2015-09-10 03:00:50"
   },
   "location": {
      "uuid": "954d12a5-56da-11ed-b77c-b66e99367f32",
      "link_id": 310402,
      "account_id": 61637,
      "company": "Sergio''s Lawn Services",
      "sid": 69,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "990",
      "zip": "85008",
      "address": "3446 East Oak Street",
      "phone": "(602) 552-5400",
      "fax": "",
      "email": "sergiovalles32123@gmail.com",
      "name": "Sergio''s Lawn Services",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.4733363",
      "lon": "-112.0065586",
      "cityname": "Phoenix",
      "statename": "Arizona"
   },
   "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": ""
}