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 (registration_number like '%TA-%' or registration_number like '%TA %') AND (`headline` like '%hawaiian princess%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Hawaiian Princess 1 bedroom, 1 1/2 bath end unit penthouse. There is no better ocean/beach view on the westside of the island than from the lanai of this 16th floor condo. This condo sits right on the beach. 850 square feet inside the condo,
Registration Number: 1840040060120001, TA-070-956-2368-01, GE-070-956-2368-01
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waianae
Aloha! If you're looking for an authentic Hawaiian experience, stunning beaches, local eateries, and a peaceful atmosphere far from the Waikiki hustle and bustle, you've found it!
This one-bedroom, one-bath condo at Hawaiian Princess in
Registration Number: TA-134-978-0992-01, 840040060092, GE-134-978-0992-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Waianae
This one bedroom beachfront condo at the Hawaiian Princess Resort in Makaha is on one of the very best beaches on the island. This high floor unit has a spectacular sunset ocean view from the lanai, one of the best on the entire island. The
Registration Number: 1840040060088, GE-070-956-2368-01, TA-070-956-2368-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Makaha
This mid-floor beachfront condo at the Hawaiian Princess comes complete with a spectacular sunset ocean view from the lanai. The condo has been remodeled with the best of everything. Amenities include a deluxe fully equipped kitchen with
Registration Number: 1990/NUC-2254, GE-070-956-2368-01, TA-070-956-2368-01, 1840040060069
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Makaha