Bermuda Dunes Landscaping Experts

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 319217,
      "site_id": 69,
      "cat_id": 65,
      "priority": 2,
      "url": "https://www.waterwiselandscape.net/",
      "title": "Bermuda Dunes Landscaping Experts",
      "description": "Bermuda Dunes Landscaping Experts, Landscaper Bermuda Dunes, Landscape Installation Bermuda Dunes, Paving Contractors Bermuda Dunes, Landscape Design Bermuda Dunes, Landscape designer Bermuda Dunes, Paving Bermuda Dunes, Best Landscaper Bermuda Dunes",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 70412,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2020-06-16T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 146,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 1685,
      "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": 5190,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "94f6ec45-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jun 16, 2020",
      "subcategory": "Landscape Contractors",
      "request_types": "",
      "visitcount": 211
   },
   "visits": {
      "storefront": 211,
      "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": "At Water Wise Landscape, we have earned a reputation for providing excellent landscaping services to the Coachella Valley and San Diego County in the form of landscape design, outdoor lighting, landscape architecture, drip irrigation, xeriscaping, pool landscaping, and paver installation that current customers have come to rely on. Since our origination in 2007, we strived to provide the highest quality of services to our customers and work to promote eco-friendly and thriving landscapes. Whether youu2019re looking to improve an existing landscape or embark in new construction, Water Wise Landscape has the staff and experience to walk you through all the stages of installation from design to construction to maintenance. Call today!",
      "service1": "Bermuda Dunes Landscaping Experts",
      "service2": "Paving Contractors Bermuda Dunes",
      "service3": "Landscaper Bermuda Dunes",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2020-06-16 16:28:05"
   },
   "location": {
      "uuid": "94f6ec45-56da-11ed-b77c-b66e99367f32",
      "link_id": 319217,
      "account_id": 70412,
      "company": "Bermuda Dunes Landscaping Experts",
      "sid": 69,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "1685",
      "zip": "92203",
      "address": "78300 Darby Rd",
      "phone": "(760) 345-7301",
      "fax": null,
      "email": "landscaperbermudadunes@gmail.com",
      "name": "Bermuda Dunes Landscaping Experts",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.7348363",
      "lon": "-116.297152",
      "cityname": "Bermuda Dunes",
      "statename": "California"
   },
   "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": ""
}