Maui Pools & Design LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 329134,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.mauipoolsanddesignllc.com/",
      "title": "Maui Pools & Design LLC",
      "description": "Welcome to Maui Pools & Design LLC, your premier destination for exceptional pool, spa, landscape, and backyard designs in Maui County. Elevate your outdoor living with our bespoke creations, meticulously crafted to harmonize with Maui''s natural beauty. From stunning poolscapes to tranquil spas, our team of experts transforms your vision into a captivating reality. Dive into unparalleled design and transform your surroundings with us.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 79959,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-03-14T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 20,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 11,
      "city_id": 4788,
      "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": 6285,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "ba641518-e1ab-11ee-8344-b66e99367f32",
      "subdate": "Mar 14, 2024",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 70
   },
   "visits": {
      "storefront": 70,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "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": "",
      "service1": "Pool Design",
      "service2": "Spa Design",
      "service3": "Backyard Design",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-03-14 02:36:57"
   },
   "location": {
      "uuid": "ba641518-e1ab-11ee-8344-b66e99367f32",
      "link_id": 329134,
      "account_id": 79959,
      "company": "Maui Pools & Design LLC",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 11,
      "city": "4788",
      "zip": "96753",
      "address": "Serving Area",
      "phone": "808-264-3432",
      "fax": null,
      "email": "mauipools@brite-mail.com",
      "name": "Maui Pools & Design LLC",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "20.7132237",
      "lon": "-156.4390541",
      "cityname": "Kihei",
      "statename": "Hawaii"
   },
   "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": ""
}