select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `address`,round(price) as price,minimum_nights, `rating`, `review_count`,`latitude`, `longitude`,case when propertyName='' then trim(address) else CONCAT(CONCAT(propertyName,'(',trim(address)),'',')') end as addre,propertyName,
(6371 *
acos(
cos( radians( 21.2759167 ) ) *
cos( radians( `latitude` ) ) *
cos(
radians( `longitude` ) - radians( -157.8233677 )
) +
sin(radians(21.2759167)) *
sin(radians(`latitude`))
)
) as distance from `vacationrentalindex` a inner join vacationrentalindexfeed b on a.uniturl=b.unitUrl and a.headline!='' and a.thumbnailUrl!='' and b.enabled=1) as vw where 1 and round(price)>0 and bedrooms>=0 AND (`headline` like '%kaha lani%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Embrace privacy in this 961sf suite with Pacific framed by tropical foliage. Prep a fresh catch in the kitchen to share on the lanai or dining area with floor-to-ceiling ocean view. Perks include hardwood floors, WiFi, flat screens, ceiling fans...
2 bedroom
2 bathroom
Sleeps 6
HI> LIHUE
This 739 sq. ft. second floor unit features beautiful views of our gardens and the Pacific. Other touches include a full kitchen, ceiling fans, flat screen, WiFi, and DVD. Sleeps 4 in 1 Queen and 1 Sofa bed.
Slip into an easy-going Kauai ...
1 bedroom
2 bathroom
Sleeps 4
HI> LIHUE
Slide into island mode in this spacious 1,183 sq. ft. home at the edge of the ocean. Sip coffee at sunrise on the lanai spanning the living area and master bedroom. Then enjoy breakfast prepped in the full kitchen. Touches include ceiling fans, ...
2 bedroom
2 bathroom
Sleeps 6
HI> LIHUE
Energy flows from the tropical-decor living area onto the lanai and across expansive lawns of this 739 sq. ft. ground floor villa with beautiful ocean view. Dine in with meals prepped in the full kitchen. Other touches include ceiling fans, flat...
1 bedroom
2 bathroom
Sleeps 4
HI> LIHUE
Gaze at Pacific surf from the lanai of this 150 sf tropical suite at the ocean’s edge. Floor-to-ceiling sliders bring paradise into the open living area and kitchen for “at home” dining pleasure. Touches include cool tile floors, ceiling ...
1 bedroom
1 bathroom
Sleeps 2
HI> LIHUE
This spacious 1,183 sq. ft. vacation unit overlooks Kauai’s eastern shores. Take in Kauai’s beautiful sunrises from your private lanai. Then enjoy breakfast prepped in the full kitchen. Extra touches include ceiling fans, flat screen, and ...
2 bedroom
2 bathroom
Sleeps 6
HI> LIHUE
Bask the splendor of this 739sf suite with furnished ground floor lanai that leads to the Pacific’s edge. Enjoy floor-to-ceiling windows spanning the living area with modern tropical décor, full kitchen for prepping meals, ceiling fans, flat ...
1 bedroom
2 bathroom
Sleeps 4
HI> LIHUE
Stand out over the Pacific in this 739 sq. ft. one bedroom oceanfront corner unit with convenient touches and island decor. Start the day off with Kauai’s beautiful sunrise before heading out on your Kauai adventure. The vaulted ceilings in ...
1 bedroom
2 bathroom
Sleeps 4
HI> LIHUE
This 739 sq. ft. ground floor villa features beautiful views of our gardens and the Pacific. Other touches include a full kitchen, ceiling fans, flat screen, WiFi, and DVD. Sleeps 4 in 1 Queen and 1 Sofa bed.
Slip into an easy-going Kauai ...
1 bedroom
2 bathroom
Sleeps 4
HI> LIHUE
Island-style comfort defines this 739 sq. ft. suite with private lanai flowing onto the resort’s landscaped grounds. The bedroom, kitchen, and bath shine with upgraded tile floors. Other comforts include a full kitchen for preparing meals, ...
1 bedroom
2 bathroom
Sleeps 4
HI> LIHUE
This 739 sq. ft. vacation unit looks out over our resort. Unit 203 features relaxing tropical décor along with convenient touches such as a full kitchen with dishwasher, ceiling fans, dining area, flat screen TV, and WiFi. Sleeps 4 in 1 Queen ...
1 bedroom
2 bathroom
Sleeps 4
HI> LIHUE
Comfy and casual, this 739 sq. ft. suite boasts a Pacific Ocean view that’s hard to beat! End a dreamy Kauai day with cocktails and fresh catch prepared to perfection in the full kitchen. Touches include a flat screen, WiFi, ceiling fans, DVD,...
1 bedroom
2 bathroom
Sleeps 4
HI> LIHUE
Kaha Lani Unit 129 is a beautiful ocean view home away from home. The spectacular Pacific Ocean is steps away - you will hear the sound of the waves and feel the trade winds blowing through your hair completely inspiring.
The Kaha Lani is ...
3 bedroom
2 bathroom
Sleeps 6
HI> Lihue
Kaha Lani Unit 129 is a beautiful ocean view home away from home. The spectacular Pacific Ocean is steps away - you will hear the sound of the waves and feel the trade winds blowing through your hair completely inspiring.
The Kaha Lani is ...
2 bedroom
2 bathroom
Sleeps 6
HI> Lihue
This top floor, ocean view condo is located at the beautiful Kaha Lani Resort, known for its lush landscaping, uncrowded beach, and peaceful atmosphere. This unit boasts a renovated kitchen and bathrooms with granite counter tops, stainless ...
1 bedroom
2 bathroom
Sleeps 2
HI> Lihue
