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
0 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
2 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
2 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
1 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-075-354-3168-01, TA-075-354-3168-01, 260280110090, 2305-CCH-1376
1 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, 260280110184, 90/TVU-1287
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Book with confidence! This property is professionally managed by Ali'i Beach Rentals.Registration Number: GE-200-949-9136-01, 260280110355, TA-200-949-9136-01
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Book with confidence! This property is professionally managed by Ali'i Beach Rentals.Registration Number: 260280110327, GE-197-489-9296-01, TA-197-489-9296-01
1 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
1 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
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Book with confidence! This property is professionally managed by Ali'i Beach Rentals.Registration Number: 260280110172, GE-083-583-7952-01, TA-083-583-7952-01
1 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, 90/TVU-1210 , TA-202-106-0608-01, 260280110084
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Book with confidence! This property is professionally managed by Ali'i Beach Rentals.Registration Number: TA-154-522-5216-01, GE-154-522-5216-01, 26281196
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Welcome and Aloha! Registration Number: GE-078-028-0832-01, 260280110024, TA-078-028-0832-01
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Book with confidence! This property is professionally managed by Ali'i Beach Rentals.Registration Number: 260280110069, STR #1128, TA-176-441-0880-01, GE-176-441-0880-01
1 bedroom
1 bathroom
Sleeps 3
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
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Welcome and Aloha!Registration Number: GE-078-028-0832-01, 260280110113, TA-078-028-0832-01
1 bedroom
1 bathroom
Sleeps 4
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
