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 '%Lokelani%') AND sleeps>=1 order by rating desc LIMIT 0, 20
The Beach Villas at Ko Olina is the perfect family getaway. Ocean side on the second Lagoon in the exclusive Ko Olina Resort. Enjoy magnificent amenities and beautiful accommodations. This Condo has everything you need to relax in ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapolei
TVNCU-1226 TA #189-999-3088-01 - "Heavenly Rose"
Lokelani is a spacious and unique home with 3 bedrooms and 3 full baths, sleeping up to 6 people comfortably. The open plan living area sweeps from the kitchen, past the living room (with wall...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Hanalei
Welcome to Lokelani B102 Maui Beachfront Condo.
A panoramic ocean view steps from the lanai (patio) greets you upon arrival to your fully renovated (fall 2020) vacation condo. In addition to the fully stocked modern kitchen and king size...
- 2 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Lahaina
Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2024 and receive a 4-door rental car from one of our major rental car agency partners. The Car is complimentary, you pay only ...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Lahaina
Lokelani C-201 in Honokowai is an upgraded direct oceanfront air-conditioned two bedroom / two bath condominium. With spectacular views of the Pacific from both the living room and master bedroom lanai, you will have a front row seat watching ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina