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 '%Hale Kahanalu%') AND sleeps>=1 order by rating desc LIMIT 0, 15
With an epic location, cozy ambiance and serene ocean views, this suite is the perfect choice for couples or a single traveler. Positioned in the top corner of a Hawaiian beach house, you’ll have plenty of privacy, yet panoramic windows to let...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Poipu
Be one of our first guests to step foot in the newly remodeled Hale Kahanalu! One of the most appealing interior designs in the area, the fresh feel of this vacation rental is a dream to come home to after a day of island adventuring!
The ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
HI> Poipu
Hale Kahanalu #4, Poipu Apartment, Kauai Vacation Rental, walk to Poipu Beach.
Cozy and affordable 720 square feet, 2 bedroom, 1 bath apartment unit just a 2 minute walk to Famous Poipu Beach and Brenneckes Beach. Portable AC in the living room...
- 2 bedroom
- 1 bathroom
- Sleeps 4
HI> Koloa