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 (city = 'Lihue' OR postalCode = 'Lihue' OR region like '%|Lihue|%') 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
Capture the tranquility and beauty of the Garden Isle from this charming, centrally located condotel unit at the Kauai Beach Resort. From your private lanai, take in Kauai's lush landscape and majestic mountain views, while enjoying the island's...
0 bedroom
1 bathroom
Sleeps 2
HI> Lihue
Beautiful ocean and park view second floor studio with balcony . Comfortable king bed with a chaise lounge.
A beautiful Hawaiian plantation-style resort located on 25 acres of lush Garden Isle, centrally located between Kauai’s south and north...
1 bedroom
1 bathroom
Sleeps 2
HI> Lihue
Hawaii TAT Lic: TA-069-764-5056-01
Hawaii GET Lic: GE-069-764-5056-01
New to VRBO, this unit has many great reviews on Airbnb
*** THIS UNIT IS PROFESSIONALLY STEAM CLEANED***
We use a hospital grade DAIMER steam cleaner to disinfect all ...
2 bedroom
2 bathroom
Sleeps 4
HI> Lihue
