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 '%Emmalani Court%') AND sleeps>=1 order by rating desc LIMIT 0, 20
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
Hawaii> Princeville
POOL CLOSURE NOTICE: The pool will be closed October and November 2024 for a renovation and repair.
Emmalani Court is a 42-unit, two-level luxury condominium complex located on a bluff over the ocean in beautiful Princeville, on ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
POOL CLOSURE NOTICE: The pool will be closed October and November 2024 for a renovation and repair.
TA#127-634-7392-02 - Emmalani Court #525
Beautiful Ocean View Air-Conditioned unit and just a short hike to the beach. Emmalani Court ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Emmalani Court condos 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.
The living area and bedrooms are air ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> 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
Hawaii> Princeville
Please be advised that the pool and spa at Emmalani Court 414 will be closed for repairs starting October 7, 2024. The closure is expected to last for approximately 4 to 6 weeks. We understand that this may cause some inconvenience and ...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> 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
Hawaii> Princeville
Greetings and a heartfelt aloha, we welcome you to our enchanting Princeville Sanctuary! Nestled on the top floor, our spacious two-bedroom, two-bath private condo offers a serene escape amidst the stunning backdrop of the 8th hole of the Makai ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
Are you prepared to embark on a truly unforgettable Hawaiian adventure? Your journey to an extraordinary experience begins by securing this meticulously renovated 1,456-square-foot, 2-bedroom, 2-bathroom private condominium nestled in the heart ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville