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 (registration_number like 'TA-%') AND (city = 'kapolei' OR postalCode = 'kapolei' OR region like '%|kapolei|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Luxury Single Family offers 4 bedrooms & 3.5 bathrooms and sleeps 8 comfortably. This two story Estate has a beautiful open floor plan and located on world famous Ko Olina Golf course. The house comes with everything you will need to hit the...
Registration Number: TA-009-939-5584-01, GE-00
4 bedroom
4 bathroom
Sleeps 8
HI> Kapolei
This Gorgeous very spacious 2 story condo is located in the Magnificent Ko Olina Resort in the Beautiful gated community of The Coconut Plantation. The Condo is fully furnished. There are 3 Bedrooms & 2.5 Bathrooms. A Great choice for your ...
Registration Number: TA-132-769-4848-01
3 bedroom
3 bathroom
Sleeps 6
HI> Kapolei
STAY ALL OR PART OF THE MONTH! 406/670-7307
Rates vary by season and length of stay and are subject to change without notice.
SINCE VRBO'S INSTANT QUOTE FEATURE IS NOT ALWAYS 100% ACCURATE, PLEASE CONTACT OWNER VIA EMAIL OR PHONE FOR CORRECT ...
Registration Number: TA-205-512-7040-01, GE-20
2 bedroom
2 bathroom
Sleeps 6
HI> Kapolei
Located in the much sought after Coconut Plantation in the Ko Olina resort, our home is literally a five minute walk to the beach and minutes away from the fabulous Roy’s Restaurant and Hawaii’s Best Luau, Paradise Cove. With acres of lush ...
Registration Number: TA-088-614-7072-01, 91056
3 bedroom
3 bathroom
Sleeps 8
HI> Kapolei
The Perfect Home for your Family Vacation or Extended Stay!
This beautifully upgraded, fully furnished resort home is located in the well-known Coconut Plantation at Ko Olina Resort. The home has 4 bedrooms, 3 full baths and a fresh, bright and...
Registration Number: TA-101-009-8176-01
4 bedroom
3 bathroom
Sleeps 8
HI> Kapolei
Concierge Realty is proud to present luxury villas at Marriott's Ko'Olina Beach Club.
We are able to offer reservations in weekly increments with arrivals and departures Fridays, Saturdays and Sundays
This family friendly beach resort in Oahu ...
Registration Number: TA-137-506-6624-01, GE-13
2 bedroom
2 bathroom
Sleeps 8
HI> Kapolei
**Please "CONTACT HOST" to confirm that your dates are available, and to receive an accurate price quote. The "Request to Book" feature is a request for a reservation, and not a confirmed booking** Contact us first so we can confirm ...
Registration Number: TA-135-236-9152-01, 91057
2 bedroom
2 bathroom
Sleeps 8
HI> Kapolei
Aloha, this villa is scheduled to have exterior painting and maintenance that will affect your stay from February 24, 2022 to April 21, 2022. The lanai will be closed off during working hours (8:30 AM until 4:30 PM Monday through Friday). The ...
Registration Number: TA-157-347-1232-01
2 bedroom
2 bathroom
Sleeps 6
HI> Kapolei
Enjoy the Resort Lifestyle in this beautifully furnished, 3 bedroom 2 bath Ko Olina Kai rental. This is a perfect property for business travelers or long term vacation renters. The spacious master bedroom has a King size bed and master bath has ...
Registration Number: TA-102-177-8432-01, 19105
3 bedroom
2 bathroom
Sleeps 6
HI> Kapolei
Aloha, this villa is scheduled to have exterior painting and maintenance that will affect your stay from April 22, 2022 to May 18, 2022.(May 2, 2022 to June 20, 2022 entry lanai) The lanai will be closed off during working hours (8:30 AM until ...
Registration Number: TA-113-881-2928-01
3 bedroom
3 bathroom
Sleeps 7
HI> Kapolei
Aloha, this villa is scheduled to have exterior painting and maintenance that will affect your stay from February 24, 2022 to April 21, 2022. The lanai will be closed off during working hours (8:30 AM until 4:30 PM Monday through Friday). The ...
Registration Number: TA-081-672-1920-01
2 bedroom
2 bathroom
Sleeps 6
HI> Kapolei
Notice: February through March; The Beach Villas at Koolina is undergoing an extensive painting contract that affects the use of the balcony. We have adjusted (reduced) our pricing to reflect this inconvenience. We are not giving any credits ...
Registration Number: TA-071-028-5824-01, GE-07
2 bedroom
2 bathroom
Sleeps 6
HI> Kapolei
Aloha, this villa is scheduled to have exterior painting and maintenance that will affect your stay from February 24, 2022 to April 21, 2022. The lanai will be closed off during working hours (8:30 AM until 4:30 PM Monday through Friday). The ...
Registration Number: TA-062-892-2880-01
2 bedroom
2 bathroom
Sleeps 6
HI> Kapolei
Aloha, this villa is scheduled to have exterior painting and maintenance that will affect your stay from April 4, 2022 to May 18, 2022. The lanai will be unavailable Mon - Fri, 8 AM - 4:30 PM at the beginning and end of the period, and ...
Registration Number: TA-082-003-5584-01
3 bedroom
3 bathroom
Sleeps 6
HI> Kapolei
Aloha, this villa is scheduled to have exterior painting and maintenance that will affect your stay from April 22, 2022 to May 18, 2022. The lanai will be closed off during working hours (8:30 AM until 4:30 PM Monday through Friday). The lanai ...
Registration Number: TA-045-641-1136-01
3 bedroom
3 bathroom
Sleeps 8
HI> Kapolei