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, rewritten_description,
(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, 50
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
Experience the Elegance of Oceanfront Living at Lokelani B102 – Your Private Maui Escape
Step into your dream Maui getaway at Lokelani B102, a fully renovated beachfront sanctuary offering uninterrupted panoramic ocean views just steps
- 2 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Lahaina
The Beach Villas at Ko Olina is the ultimate getaway, perfectly situated oceanfront on the second lagoon in the exclusive Ko Olina Resort. This luxurious property combines tranquility and convenience, located next door to Disney’s Aulani yet
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapolei
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
Oceanfront 2-bedroom villa with dual lanais, panoramic views of Molokai and Lanai, full kitchen, and space for up to 6 guests. Enjoy snorkeling, sunsets, and peaceful island living by the shore.
*Special Offer- Book any KBM rental home in
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
