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, 30
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
Welcome to Emmalani Court 414, a newly remodeled 2 bedroom 2 bathroom haven that sleeps up to 5 people, where guests can unwind and bask in the beauty of Kauai’s North Shore. Situated just steps away from the open ocean, and with breathtaking ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Princeville
TA#127-634-7392-02 - Emmalani Court #525
Beautiful Ocean View Air-Conditioned unit and just a short hike to the beach. Emmalani Court is a small, quiet condominium complex located near the newly renovated 1 Hotel Hanalei Bay in Princeville ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
TA#-008-487-1168-01
Emmalani Court is a 42-unit, two-level luxury condominium complex located on a bluff over the ocean in beautiful Princeville, on Kauai’s north shore. Unit 221 is at the quiet end of the complex - the closest two bedroom ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
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
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
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
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
