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, rewritten_description,
(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, 50
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
- 2 bedroom
- 1 bathroom
- Sleeps 3
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: 260230560149, GE-199-719-4752-01, TA-199-719-4752-01
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
PLEASE NOTE ROOFTOP POOL DECK CLOSED UNTIL 3/18TH.
Soaring above Waikiki on the 32nd floor of Pacific Monarch, this stylish one-bedroom retreat offers the perfect blend of island charm and resort-style luxury. The elevated location
Registration Number: 260230560216, TA-209-650-8928-01, GE-209-650-8928-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
PLEASE NOTE ROOFTOP POOL DECK CLOSED UNTIL 3/18TH.
Step into your own slice of paradise in this beautifully appointed 23rd-floor retreat at Pacific Monarch. Designed for those who crave both luxury and the relaxed spirit of island living,
Registration Number: 260230560217, GE-209-650-8928-01, TA-209-650-8928-01
- 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-004-291-5840-01, TA-004-291-5840-01, 260230560088
- 2 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."
The Pacific Monarch building is centrally located in Waikiki, with a great variety of entertainment and dining
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!!
This classy studio will become a nice castle
Registration Number: GE-119-726-1824-01, 260210260427, TA-114-108-1088-01
- 1 bedroom
- 1 bathroom
- Sleeps 3
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
- 2 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
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Welcome to your new home away from home!
Step into paradise with our beautifully remodeled Honeymoon Luxury Suite on the 25th-floor studio, offering mesmerizing east-facing views of the ocean that defy description. Nestled in the heart of
Registration Number: GE-084-947-1488-01, TA-084-947-1488-01, 260230560162
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
