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 '%Mauna Kai%') AND sleeps>=1 order by rating desc LIMIT 0, 15
If you're looking for a getaway that has it all, this is where you need to land. Located within easy walking distance of the Princeville Shopping Center, there's something for everyone from hikes, to beaches, to delicious eating adventures.
...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
The community pool at Mauna Kai will be closed for repair from March 15 - May 1, 2022.
Complete with all new furniture and bedding, this beautifully remodeled Princeville condo provides privacy and plenty of space to accommodate eight guests. ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
HI> Princeville
Enhanced COVID cleaning and disinfecting procedures for every check-in.
Walk to beach, shopping, and dining from this updated and very spacious condo with pool and BBQ grill at Mauna Kai Princeville.
Mauna Kai is a charming townhome complex in...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
***Please note the pool will be closed beginning 03.15.2022 - 05.01.22***
Experience the very best of the North Shore at this upgraded private & spacious condo in Princeville. This luxe island style retreat is located near all the attractions ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
The community pool at Mauna Kai will be closed for repair from March 15 - May 1, 2022.
Recently remodeled, with central air conditioning, comfortably sleeps 6. Very close to Princeville shopping center, 3-minute walk to the Westin resort and ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Princeville
