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 '%Kahana Outrigger%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Home away from home is the only good description of our "condo" in Kahana. Fantastic sunsets, outstanding views in all directions, romantic moonlit nights and whale watching (in season) are all to be expected at our Kahana Outrigger vacation ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
This 3 bedroom, 2 bath, 2 story loft style (closed off with windows) unit has its master bedroom and newly remodeled bathroom in the loft with rain shower head in a walk in tiled shower overlooking the living room. Entry, kitchen and dining ...
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
