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 '%hololani%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Highly sought after corner penthouse oceanfront! Book NOW!
This exclusive stunning southwest facing fully furnished oceanfront penthouse 2-bedroom 2-bathroom corner unit boasts the most amazing and unobstructed views of Molokai and Lanai, the...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Napili-Honokowai
Hololani A203
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Leave your worries and stress behind as you slip into vacation mode at this stunning ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Hololani B603
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
West Maui awaits with this welcoming oceanfront condo. Easy beach access, stunning sunset ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
This fabulous oceanfront Hololani Resort condominium is on the 3rd floor with fantastic views towards the neighbor islands of Molokai & Lanai. Each Master Bedroom has its own lanai! Hololani is a small 64 unit complex on the water in Kahana. ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Hololani B803
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Treat yourself to a tropical getaway you'll never forget when you book your next escape to ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
Hololani B804
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
** Visitors arriving in Hawaii must either be fully vaccinated or (1) present a negative ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Lahaina
