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***
***The building is undergoing spalling work on the exterior from September 3 to Feb 21. This work is expected to be messy and loud, and will be carried out in sections.
Our Section Impact: Nov 18 - Dec 20 ( ...
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!
Step into this fantastic 1-bedroom condo, situated on the East-facing 16th floor, where you'll be treated to mesmerizing ocean views that truly need to be seen to be believed. Your home away from ...
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."
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
- 0 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Honolulu
Welcome to your charming home away from home!
This delightful 1-bedroom condo offers stunning Waikiki city views and accommodates up to 4 guests in the heart of historic Waikiki at the Pacific Monarch!
Prepare for the ultimate ...
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:
Beautiful views from this ample, breezy and bright one bedroom apartment in the heart of Waikiki. Located at the boutique hotel Pacific Monarch , just 1.5 blocks from world famous Waikiki Beach. Around the corner from Kalakaua Ave ...
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!
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