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, 20
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
Looking for a relaxing escape that offers it all? Look no further. This stunning property is within easy walking distance of the Princeville Shopping Center, offering everything from hiking trails and beautiful beaches to delicious dining ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
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
Come enjoy our slice of heaven!
Located in the Mauna Kai community, this beautiful, 1,500 Sq Ft condo has a private lanai, dedicated parking and a pool on site. With just a short walk through the canapy of trees you can go to a secluded ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Princeville
