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 '%Mauna Kai%') AND sleeps>=1 order by rating desc LIMIT 0, 30
Complete with all new furniture and bedding, this beautifully remodeled Princeville condo provides privacy and plenty of space to accommodate eight guests. Mauna Kai 2 features tranquil and comfortable indoor and outdoor spaces; amenities such ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Princeville
If you're looking for a relaxing 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
10 out of 10, 2024 Traveler Award winning rental. Mauna Kai is an intimate, charming townhome complex walking distance to beaches, shopping, and dining. The hike to north shore Anini Beach - a beautiful, uncrowded, white-sand beach - is a ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Recently remodeled, with central air conditioning, comfortably sleeps 6. Very close to Princeville shopping center, 3-minute walk to the Westin resort and right next to the path to Anini beach.
The large common area and lanai offer lots ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Nicknamed Ke Ola Nani = The Beautiful Life ,Enjoy staying in the heart of Princeville in the stylish and family-friendly 2 level "Upside Down" 2 bedroom condo with lanais overlooking the pool and mountains beyond. Nicknamed "Ke Ola Nani" , ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
