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 = 552 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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 = 552 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 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 = 552 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 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;

4460 Nehe Rd
Lihue, HI 96766
Diane Pavao with Kauai Landmark Realty, original listing - (808) 822-3100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $750,000
Beds: 1
Baths: Full: 1, ½: 1
Status: Active
SqFt: 739 Square Feet
Agency: Kauai Landmark Realty
Agency Phone: (808) 822-3100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Condominium
Year Built: 1975
Notes: Centrally located on the east side oceanfront of Kauai, Kaha Lani is the ideal resort just minutes away from the airport and from Lihue and Kapaa towns. Kaha Lani #203 is a well-kept corner unit on the second floor of building #2 for security and an enhanced ocean view over the heated pool to the ocean beyond, and is in close proximity to parking. It is fully furnished and is a turnkey vacation rental in the On-Site rental program by Castle Resorts & Hotels. The kitchen and baths have updated island cabinetry with granite countertops and backsplash. Enjoy the comforts of island style living with rattan furniture including a sofa sleeper, love seat, recliner chair, and dining set for four. Ceiling fans and the cross breeze of this corner unit keep it comfortable day and night. On property, relax in the heated swimming pool, have a barbeque with your family, or challenge your friends to a tennis/pickleball match. Walk or bike out to the Ke Ala Hele Makalae coastal multiuse path that leads to the adjacent Lydgate Park and nearby Wailua River, walk the 2 mile-long sand beach, or golf nearby at the renowned Wailua Municipal Golf Course. Enjoy the many great restaurants and shops in Kapaa and Lihue only a few miles from the property. It would be a comfortable vacation rental, or first or second home to the perfect person to call it their "heavenly place".<br /> <br /> Property is centrally located on the Royal Coconut Coast yet off the beaten path, beautifully landscaped, non-smoking with two designated smoking areas, with a credit card operated laundry room, two barbeque areas, heated pool, and a tennis / pickleball court.
MlsNumber: --
ListingId: 711977


Listing Provided By: Kauai Landmark Realty, original listing
Phone: (808) 651-3557
Office Phone: (808) 822-3100
Agent Name: Diane Pavao
Disclaimer: Copyright © 2024 Hawaii Information Service. 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