select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) as vw where 1 and round(price)>0 and bedrooms>=0 AND (`headline` like '%Villas on the Prince%') AND sleeps>=1 order by rating desc LIMIT 0, 15
The Villas on the Prince is a very similar luxury townhouse style resort also located in Princeville. The entrance to this resort is just as you enter the Princeville Resort itself and within walking distance to the Princeville Shopping Village ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Princeville
Villas on the Prince, offers a community pool, spa, BBQ and club house, all tucked away just off the rotary entrance to the Princeville Resort.
Spacious Great Room with 15' high cathedral ceilings and sweeping views of golf course greens. ...
- 3 bedroom
- 5 bathroom
- Sleeps 6
HI> Princeville
