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, 30
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...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Lahaina
Your Hawaiian experience begins the moment you enter this home away from home. This beautiful 2 bedroom, 2-bathroom unit was completely remodeled in a very tasteful, tropical decor. All furniture and appliances have been replaced in this ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
This beautiful villa features 2 bedrooms and 2.5 bathrooms, with two oceanfront lanais. The townhouse style comfortably accommodates 1 to 6 guests, offering an oceanfront master with a king bed, a guest bedroom with two long twins or a king ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Lahaina
A LITTLE ABOUT THIS CONDO....
The sound of the waves is very soothing and this location is ideal. The water is right outside your double lanai doors. The nearly private beach is just steps away for snorkeling and swimming with the turtles and...
- 1 bedroom
- 1 bathroom
- Sleeps 4
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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Hale Ho'omaka'i, formerly know as the Lufkin House invites you to "E komo mai" (come belong). Our beloved Historic Inn in Wailuku town is a charming wonder to behold. Full of enchanting surprises around every corner. Centrally located, it is 15 ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Wailuku
