select * from (Select a.`postalCode`,a.`uniturl`, `region`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `source`, `property_type`, `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 and b.blocked=0 ) as vw where 1 and round(price)>0 and bedrooms>=0 AND (`headline` like '%waipouli%') AND sleeps>=1 order by rating desc LIMIT 0, 30
Special* Book Now & We Pay Your Daily Resort Fee's!
Click the contact owner button and I will respond with a complete quote for you within a few minutes.
Covid-19 UPDATE: IF there is a mandatory quarantine in effect on the day of ...
- 2 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Kapaa
If a sanctuary on one the worlds most beautiful islands is what you are looking for, Waipouli Beach Resort & Spa is where you want to be. A beautiful beach front setting with Lush Tropical landscaping and Spectacular Views awaits you. The resort...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kapaa
A204 is a prime Royal Oceanfront unit with gorgeous ocean views from every window. Sleep to the sounds of the waves right out your bedroom window. Prepare meals in the state of the art kitchen, featuring a large Sub-Zero refrigerator, Wolf ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapaa