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 '%Emmalani Court%') AND sleeps>=1 order by rating desc LIMIT 0, 15
* NOTE - Covid-19 See Hawaii.gov and Kauai.gov for specific protocols.
Garden level one bedroom with king bed, 1.75 bath condo overlooking the 8th fairway of the Makai Ocean Course, landscaped greenbelt and distant ocean views.
Tastefully ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
HI> Princeville
Emmalani Court is a hidden gem in Princeville on the North Shore of Kauai. It is only 42 units and adjacent to the 8th hole of the top rated Robert Trent Jones Jr designed Makai golf course. This well maintained complex is located within ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
* NOTE - Covid-19 Effective April 5, 2021 - arriving gu
Arriving guests are required to have proof of a negative Covid19 test result within 72 hours of arriving on Kauai. Hawaii State residents are required to have proof of Covid19 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
All travelers are responsible for investigating all travel restrictions to Kauai. Travelers are advised that travel restrictions to Kauai may be different than travel requirements to the State of Hawaii.
Emmalani Court #525
Beautiful Ocean View...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
Enjoy this luxurious Kauai condo next to the Makai Golf Course at Princeville Resort. This small resort features only 42 units, pool, spa and outdoor barbecue area. Conveniently located near our North Shore office at the Princeville Resort ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
Emmalani Court condominiums are located on the spectacular North Shore of the Garden Island of Kauai in Princeville. This spacious condominium is adjacent to the Makai Golf Course in Princeville.
Some nights you may just want to stay in and ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
Emmalani Court is a resort condo property situated on the Makai "Oceans" golf course. This spacious, 1100 sq ft,. two bedroom condo is an excellent home base for your Kauai adventures. Whether you are into relaxing by the pool with a book or ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
Enjoy this luxurious Kauai condo next to the Makai Golf Course at Princeville Resort. This small resort features only 42 units, pool, spa and outdoor barbecue area. Conveniently located near our North Shore office at the Princeville Resort ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
