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 '%Village by the Sea%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Serene, sunny, renovated AIR CONDITIONED oceanfront condo in Central Kihei, renovated oceanfront condo has all the comforts of home and all the amenities of a vacation getaway. One bedroom KING SIZE BED/1 bath condo sleeps up to 4 persons. ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
For your next Hawaiian escape, reserve this stunning 1-bedroom, 1-bathroom Kihei vacation rental. Settled right on the beachfront with great views in one of the best central locations in Maui, this coastal condo ensures a genuinely relaxing ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
