nuView Pools & Landscape

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 319900,
      "site_id": 69,
      "cat_id": 65,
      "priority": 2,
      "url": "https://nuviewoutdoor.com/",
      "title": "nuView Pools & Landscape",
      "description": "nuView Pools & Landscape is an expert pool installation company with a passion for perfection. \r\nOpen Monday - Friday 8:00am to 6:00pm\r\nLICENSE: AZ ROC# 315641",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 71094,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2020-09-24T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 215,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 3,
      "city_id": 1002,
      "ltop": "",
      "facebook": "https://www.facebook.com/nuviewoutdoor/",
      "tiktok": null,
      "linkedin": "https://www.linkedin.com/company/nuview-outdoor/",
      "twitter": "https://twitter.com/nuView_Outdoor",
      "googleplus": "https://plus.google.com/u/1/b/111805368746178499770/",
      "youtube_channel": null,
      "youtube": "https://www.youtube.com/channel/UCyxOqbLluCDRJFhF111JciA",
      "youtube_title": null,
      "pinterest": "https://www.pinterest.com/nuviewoutdoor/",
      "yelp": "",
      "foursquare": "",
      "instagram": "https://www.instagram.com/nuviewoutdoor/",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 5220,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "957c8636-56da-11ed-b77c-b66e99367f32",
      "subdate": "Sep 24, 2020",
      "subcategory": "Landscaping Architect",
      "request_types": "",
      "visitcount": 359
   },
   "visits": {
      "storefront": 359,
      "articles": 0,
      "videos": 0,
      "reviews": 16,
      "coupons": 0,
      "products": 0,
      "social": 9,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Pool and landscape remodeling can be expensive, even to the point of impossibility for some homeowners. Pool remodeling and pool building options can be limited, both in concept and design and in affordability. At nuView Pools & Landscape in Queen Creek, we bring affordable options so that you can design your backyard, patio, or other area within your budget. Our installation and remodeling services are fast and efficient, and we offer a wide range of services, including, but not limited to:\r\n\r\nPool Design & Building\r\nPool Remodeling\r\nSwimming Pool Resurfacing\r\nPool Removal and Demolition\r\nLandscape Design & Planning\r\nLandscaping Installation\r\nFire Pit Installation\r\nOutdoor Built-In Kitchens\r\nBuilt-In Outdoor Barbecues\r\nCustom Pool Features\r\nBackyard Design & Planning\r\nArtificial Turf & Putting Greens\r\nAnd Much More!\r\n\r\nnuView Pools & Landscape is owner run and operated. We care about our clients, and we show it by treating each of their projects with care. We donu2019t have any inexperienced contractors at nuView, just experienced, professional, and talented workers. Our Queen Creek pool builders and landscape designers keep you up-to-date during each step of your project.\r\n\r\nWe also help you design your pool with experienced art & design specialists. We'll walk you through the step-by-step process and design your pool how you want with 3D rendering software, so you can see how it will look before you decide on the final product. If you want to install a new pool or landscape feature, want to give your pool a facelift with Queen Creek pool remodeling, or are looking for custom patio and backyard design, give us a call. Our experienced staff will provide you with a free quote. Call us today at 480-330-7090 or visit us on the web at nuviewoutdoor.com to learn more.\r\n\r\nnuView Pools & Landscape\r\n18472 Walnut Rd\r\nQueen Creek, AZ 85142\r\nPhone: 480-330-7090\r\nEmail: info@nuviewoutdoor.com\r\nWebsite: https://nuviewoutdoor.com/\r\n\r\nConnect With Us!\r\nFollow Us on Twitter: https://twitter.com/nuView_Outdoor\r\nLike Us on Facebook: https://www.facebook.com/nuviewoutdoor/\r\nSubscribe on YouTube: https://www.youtube.com/channel/UCyxOqbLluCDRJFhF111JciA\r\nConnect With Us on LinkedIn: https://www.linkedin.com/company/nuview-outdoor/\r\nMeet the Owner on LinkedIn: https://www.linkedin.com/in/shawn-palmer-az/\r\nFollow Us on Pinterest: https://www.pinterest.com/nuviewoutdoor/\r\nFollow Us on Instagram: https://www.instagram.com/nuviewoutdoor/\r\nFollow Us on Houzz: https://www.houzz.com/pro/nuviewoutdoor",
      "service1": "Outdoor Kitchen Installation",
      "service2": "Pool Renovation",
      "service3": "Patio Construction",
      "service4": "Backyard Design",
      "service5": "Landscape Planning",
      "service6": "Landscape Architecture",
      "service7": "Landscape Design",
      "submit_dt": "2020-09-24 22:52:18"
   },
   "location": {
      "uuid": "957c8636-56da-11ed-b77c-b66e99367f32",
      "link_id": 319900,
      "account_id": 71094,
      "company": "nuView Pools & Landscape",
      "sid": 69,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "1002",
      "zip": "85142",
      "address": "18472 Walnut Rd",
      "phone": "480-330-7090",
      "fax": null,
      "email": "nuviewoutdoor@yahoo.com",
      "name": "nuView Pools & Landscape",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.2611717",
      "lon": "-111.6842616",
      "cityname": "Queen Creek",
      "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": ""
}