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 Sunset%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Waikiki Sunset 2105 Paradise Awaits 1-bedroom Superior Suite with Incredible Views Registration Number: GE-181-163-0080-01, TA-181-163-0080-01
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
See my other properties #3156864 and #3197017 and #3512192 for more 5-star reviews and to book multiple condos for large groups.Registration Number: TA-065-133-9776-01, GE-065-133-9776-01
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
The best Diamond Head view in all of Waikiki is yours to behold from this immaculate, beautifully furnished and well-appointed condominium. This is for you, the guest who appreciates quality and value.Registration Number: 260280110064, GE-212-869-3248-02, TA-212-869-3248-01
3 bedroom
1 bathroom
Sleeps 3
Hawaii> Honolulu
**Looking for other accommodations, please view my other unit located in the same building #2824127**Registration Number: TA-065-133-9776-01, W10360673-01, 1260280110204
3 bedroom
1 bathroom
Sleeps 6
Hawaii> Honolulu
**Looking for other accommodations, please view my other unit located in the same building #2773517**Registration Number: TA-065-133-9776-01, 1260280110395, GE-064-617-2672-01
2 bedroom
1 bathroom
Sleeps 6
Hawaii> Honolulu
Aloha from Midway Vacations! Our team of local hospitality experts is dedicated to turning your Hawaiian getaway into a reality. When you stay at one of our properties, you can count on a professionally cleaned and meticulously maintained ... Registration Number: GE-202-106-0608-01, TA-202-106-0608-01, NUC #: 90/TVU-1287/1990/NUC-1454, 260280110184
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Aloha from Midway Vacations! Our team of local hospitality experts is dedicated to turning your Hawaiian getaway into a reality. When you stay at one of our properties, you can count on a professionally cleaned and meticulously maintained ... Registration Number: 260280110034, TA-201-860-0960-01, GE-201-860-0960-01, 2211-CCH-0236
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Book with confidence! This property is professionally managed by Ali'i Beach Rentals.Registration Number: GE-029-812-5312-01, TA-029-812-5312-01, 260280110319
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Aloha from Midway Vacations! Our team of local hospitality experts is dedicated to turning your Hawaiian getaway into a reality. When you stay at one of our properties, you can count on a professionally cleaned and meticulously maintained ... Registration Number: GE-202-106-0608-01, TA-202-106-0608-01, NUC #: 90/TVU-1210/1990/NUC-1367, 260280110084
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Aloha from Midway Vacations! Our team of local hospitality experts is dedicated to turning your Hawaiian getaway into a reality. When you stay at one of our properties, you can count on a professionally cleaned and meticulously maintained ... Registration Number: NUC #: 90/TVU-1271 - 1990/NUC-1438 Exp. date: 09/30/2025, TA-161-478-9120-01, GE-161-478-9120-01, 126280110165
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Welcome and Aloha! Registration Number: GE-078-028-0832-01, 260280110024, TA-078-028-0832-01
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Be Cool... This is my own Hawaii!! Registration Number: 260280110238, GE-012-217-3440-01, TA-012-217-3440-01
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Welcome and Aloha!Registration Number: TA-068-483-1232-01, GE-068-483-1232-01, 260280110182
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Welcome and Aloha!Registration Number: GE-078-028-0832-01, 260280110113, TA-078-028-0832-01
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Spectacular Ocean & Diamond Head View 2 Bedroom Condo w/ Free Parking!Registration Number: 260280110343, TA-121-578-0864-01, GE-121-578-0864-01
3 bedroom
1 bathroom
Sleeps 6
Hawaii> Honolulu
Partial Ocean View Waikiki Sunset Condo, Free Parking & WifiRegistration Number: GE-121-578-0864-01, 260280110090, TA-121-578-0864-01
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Right in Waikiki close to the World Famous Waikiki Beach!!Registration Number: TA-012-352-0000-01, GE-012-352-0000-01, 260280110261
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” FEATURE***Registration Number: 260270350000, TA-033-867-4688-01, GE-199-896-9344-01
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
