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 (registration_number like '%TA-%' or registration_number like '%TA %') AND (`headline` like '%hawaiian princess%') AND sleeps>=1 order by rating desc LIMIT 0, 20
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.
Watch turtles, dolphins and in ...
Registration Number: 840040060120, 1990/NUC-2276, TA-070-956-2368-01, GE-070-956-2368-01
- 1 bedroom
- 2 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
The Hawaiian Princess is a condominium complex located 30 miles from the airport and about 45 minutes from the crowds of Waikiki .This Slice of Paradise is situated on a beautiful 1/2 mile quiet , natural sand beach. There is great snorkeling ...
Registration Number: GE-021-401-6000-02, 260110080057, TA-021-401-6000-02
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waianae
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
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Makaha
Aloha!
Located on the beach, you an enjoy the sunsets from your sit out lanai! This 10th floor unit accommodates 4 people (queen bed and sofa sleeper). Its great for a weekend get-a-way or a longer stay. Complete with washer and ...
Registration Number: 1840040060076, GE-149-909-0944-01, TA-149-909-0944-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Waianae
