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 '%waikiki marina%') AND sleeps>=1 order by rating desc LIMIT 0, 30
enjoy relaxing on your lanai and watching Friday night fireworks (when the resume) right next to ala moana shopping center and Ala wai boat harbor. Across the street from Hawaiian Hilton lagoon and the entrance of Waikiki. lots of restaurants ...
Registration Number: TA-018-667-1104-01, GE-018-667-1104-01, 260110220029
- 2 bedroom
- 1 bathroom
- Sleeps 8
Hawaii> HONOLULU
Ilikai Marina #590 – 1765 Ala Moana Blvd.
Relax in this newly furnished "beachy contemporary" 1-bedroom and take in beautiful views of the ocean and yacht harbor.
Although there is NO pool onsite, it's just a quick stroll to Duke...
Registration Number: GE-025-935-3088-01, TA-025-935-3088-01, 260100020035
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Come enjoy a magnificent, plush, upgraded studio in the heart of Waikiki. Centrally located in the heart of Waikiki, and just steps from the Waikiki Harbor and just a 5 minute walk to the World's Famous Waikiki Beach....
Registration Number: GE-004-374-7328-01, TA-004-374-7328-01, 260100020175
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Ilikai Marina #994 – 1765 Ala Moana Blvd.
You'll love this condo's sweeping panoramic views of the ocean, yacht harbor, Magic Island, and beautiful sunsets!
Although there is NO pool onsite, it's just a quick stroll to Duke ...
Registration Number: 260100020079, TA-121-644-2368-02, GE-121-644-2368-02
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Come enjoy this beautiful Waikiki resort! Now reopened!
COVID Update: Enhanced cleaning measures are in effect. Some amenities are open with access limitations.
• Must provide resort with negative covid tests taken within 72 ...
Registration Number: 260100070634, GE-075-066-7776-01, TA-063-691-1616-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu