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 '%hololani%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Hololani Resort A104 is a stunning resort condominium featuring spacious and elegant designs, offering panoramic views of the Pacific Ocean and the nearby islands of Molokai and Lanai. The condo comes equipped with all the modern amenities you
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Discover Tranquility at Hololani B301
Welcome to Hololani B301, a stunning oceanfront retreat where comfort meets breathtaking views. This spacious two-bedroom, two-bathroom condo offers 1,066 sq. ft. of beautifully designed living space
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
