Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2575 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2575 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2575 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

2481 Kaanapali Pkwy
Lahaina, HI 96761

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $85,000
Beds: 1
Baths: 2
Status: Active
SqFt: 905
Agency: Keller Williams Realty Maui

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential
Year Built: 1974
Notes: Enjoy this twelfth floor time interval with large lanai and fabulous location. WTIO 1270 is a 1 bedroom, 2 bathroom unit located on the inner courtyard of Tower II. The condo was renovated in 2013 which included new tile flooring, hardwood cabinetry, granite counter tops, stainless steel appliances, and fully remodeled bathroom. Occupancy for this interval is from August 20 to September 3 annually. The consecutive interval, 1270 S, is also listed for sale. The annual maintenance fees offer ease of payment with a portion billed in February and the balance due in the late summer/early fall. Fees include property taxes, grounds, building and unit maintenance, reserve fund, and housekeeping. The Whaler on Kaanapali Beach boasts amenities that include an ocean view pool along the famed Kaanapali Beach walk, state of the art workout facility, underground parking, tennis courts, and a business hub center. Beachside BBQs, on-site concierge services, and beach activity kiosk are some of the highlights offered on property. Ongoing improvements on the property include building spalling and painting. Take a stroll in the center courtyard while enjoying the tropical landscaping and Koi fish pond. Situated in the heart of Kaanapali Beach, The Whaler is a short distance away from famed Black Rock and world class shopping and dining, as well as championship golf courses. The Whaler is a Hotel Zoned property per County records.
MlsNumber: 402006


Listing Provided By: Keller Williams Realty Maui, original listing
Name: Keller Williams Realty Maui
Phone: (808) 270-1046
Office Name: Keller Williams Realty Maui-L
Office Phone: (808) 661-8777
Agent Name: Katie Zimmerman
Disclaimer: Copyright © 2024 Realtors ® Association of Maui, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App