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 = 'honokowai' OR postalCode = 'honokowai' OR region like '%|honokowai|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Situated on 13 acres of lush, tropical landscape, Papakea Resort is the ideal and picturesque oceanfront condominium complex. Located at North Ka’anapali Beach, this updated one bedroom/one bath condominium is perfect for a couple or small ...
1 bedroom
1 bathroom
Sleeps 4
HI> Honokowai
Located in the D building of Pakapkea Resort -Papakea Resort Oceanview Studio D-206 - Lahaina - a tropical oceanfront 13 acre resort - this spacious studio has everything you are looking for in your Maui Vacation.
Fully equipped kitchen with ...
0 bedroom
1 bathroom
Sleeps 4
HI> Honokowai
Enjoy the Lahaina side in comfort! One Bedroom, one bath Condo furnished Island Style. Great location across from beach park! Next door to farmers market, coffee house, historic church, and walking distance to many great beach spots! Great ...
1 bedroom
1 bathroom
Sleeps 4
HI> Honokowai
Enjoy the Lahaina side in comfort! One Bedroom, one bath Condo furnished Island Style. Great location across from beach park! Next door to farmers market, coffee house, historic church, and walking distance to many great beach spots! Great ...
1 bedroom
1 bathroom
Sleeps 4
HI> Honokowai
Enjoy the Lahaina side in comfort! Two Bedroom, one bath condo furnished 'Island Style'. Great location across from beach park! Next door to farmers market, coffee house, historic church, and walking distance to many great beach spots! Great ...
2 bedroom
1 bathroom
Sleeps 6
HI> Honokowai
Location!! Location!! Everything is here waiting for you to enjoy oceanfront resort living in this 2-bedroom direct oceanfront condo with a loft offering comfortable accommodations for 6 guests.
This upgraded condo is on the top floor (4th) of...
3 bedroom
2 bathroom
Sleeps 8
HI> Honokowai
MAKANI SANDS 106-Honokowai - Direct Beachfront - Sandy Beach - Pride of ownership apparent in every detail makes this beachfront and beautifully appointed spacious one bedroom condominium your perfect Maui escape.
* Direct oceanfront ground ...
1 bedroom
1 bathroom
Sleeps 4
HI> Honokowai
Paki Maui One Bedroom Garden View - Honokowai - this first floor garden view one bedroom/one bath is tastefully decorated and located in an ideal location with a peaceful garden view. Sit on your corner lanai and enjoy the beauty of the lush, ...
1 bedroom
1 bathroom
Sleeps 4
HI> Honokowai