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, 30
NOTE: You should know that the condo building will be undergoing some renovation work during December and maybe into January. It will take place on the walkways (not beachside) and there may be some noise - weekdays only - when most folks are ...
Registration Number: 840040060120, TA-070-956-2368-01, GE-070-956-2368-01
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waianae
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
NOTE: You should know that the condo building will be undergoing some renovation work at the beginning of October for approximately 2 - 3 months. It will take place on the walkways (not beachside) and there may be some noise associated with it...
Registration Number: GE-070-956-2368-01, TA-070-956-2368-01
- 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
Aloha!
Welcome to the West side of Oahu where the sunsets are amazing and the beaches are serene! The is one bedroom one bath condo is available for nightly rental.
Located right on the beach, you will enjoy all this gem has ...
Registration Number: GE-166-786-6624-01, TA-166-786-6624-01, 1840040060016
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Waianae