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, 20
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: GE-075-066-7776-01, TA-063-691-1616-01, 260100070634
- 1 bedroom
- 1 bathroom
- Sleeps 4
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
Ilikai Marina #386 – 1765 Ala Moana Blvd.
Enjoy spectacular sunsets and beautiful ocean and Ala Wai Yacht Harbor views from this conveniently located one-bedroom condo (651 sqft plus small lanai). 3 Adults, OR 2 Adults+2 Children ...
Registration Number: 260100020017, GE-182-470-2464-01, TA-182-470-2464-01
- 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
This beautiful condo resort near Ala Moana Center
Located close to Ala Wai Yacht Harbor and Fort DeRussy, Waikiki Marina Resort at the Ilikai provides a grocery/convenience store, a terrace, and shopping on site. The onsite American cuisine ...
Registration Number: 260100070381, GE-075-433-7792-01, TA-173-554-2784-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Summary:
Live like a super star when you stay at this resort, which has hosted celebrities, presidents, and jetsetters. You get easy access to Waikiki Beach, the most famous stretch of sand in the Pacific. Surf’s up.
Wyndham Waikiki ...
Registration Number: 260100070000, GE-068-663-8592-01, TA-068-663-8592-01
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
