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 '%Pacific Monarch%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Visits to Hawaii have always been expensive, but each year prices seem to go higher. However, I think if you compare my condo with other options, you will realize it is a good deal. I try to keep the nightly rate about $100 less than what the ... Registration Number: GE-088-423-0144-01, TA-088-423-0144-01
1 bedroom
1 bathroom
Sleeps 3
Hawaii> Honolulu
***IMPORTANT NOTICE***Registration Number: GE-012-554-4960-01, TA-012-554-4960-01, 260230560133
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Welcome to your new home away from home!Registration Number: GE-004-291-5840-01, TA-004-291-5840-01, 260230560088
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Popular Pacific Monarch, located 2 blocks from Waikiki Beach. Enjoy beautiful ocean views during the day, nightly sunsets at the end of the day and city lights at night from the large lanai. Enjoy indoor and outdoor dining. Enjoy the ... Registration Number: 260230560216, TA-209-650-8928-01, GE-209-650-8928-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-084-947-1488-01, TA-084-947-1488-01, 260230560023
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Honolulu
Enjoy Ocean, Diamond Head and Mountain Views from this 32nd floor condo. Located in the popular Pacific Monarch, just 2 blocks from Waikiki Beach. Amenities include roof top pool, spa, sun deck, and on site laundry room. Condo has full ... Registration Number: 260230560217, GE-209-650-8928-01, TA-209-650-8928-01
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Enjoy the lovely Hawaiian breeze in this high-floor 1-bedroom unit. Within walking distance to Waikiki's finest destinations." Registration Number: GE-061-697-0752-01, 260230560193, TA-061-697-0752-01
1 bedroom
1 bathroom
Sleeps 3
Hawaii> Honolulu
Feel the Hawaiian breeze from Large window (PM04). One of the most affordable rooms in Pacific Monarch and all over Waikiki. You will be suprised with the high quality of the room with the price!! Registration Number: GE-119-726-1824-01, 260210260427, TA-114-108-1088-01
0 bedroom
1 bathroom
Sleeps 3
Hawaii> Honolulu
Welcome to your charming home away from home!Registration Number: TA-048-824-1664-01, GE-048-824-1664-01, 260230560024
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Enjoy expansive ocean views in this beautiful one-bedroom one-bath with large wraparound lanai on Kuhio Ave. Located in the lovely Pacific Monarch building, this gorgeous home includes both indoor and outdoor dining areas, full kitchen, full ... Registration Number: 1260230560037, TA-045-301-0456-01, GE-045-301-0456-01
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Enjoy expansive ocean views in this beautiful one-bedroom one-bath with large wraparound lanai on Kuhio Ave. Located in the luxurious Pacific Monarch building, this gorgeous home includes both indoor and outdoor dining areas, full kitchen, full ... Registration Number: 1260230560027, GE-207-993-3440-01, TA-207-993-3440-01
0 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Summary:Registration Number: GE-006-723-4304-01, TA-006-723-4304-01, 1260230560145
1 bedroom
1 bathroom
Sleeps 5
Hawaii> Honolulu
Welcome to your new home away from home!Registration Number: GE-084-947-1488-01, TA-084-947-1488-01, 260230560162
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Honolulu
