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, 30
Take in beautiful views from this 2 bed / 1 bath on Kuhio Ave, featuring a lovely lanai offering both mountain and peekaboo ocean views. Located in the well-maintained Pacific Monarch building, this lovely home includes ac, Wi-Fi, cable, indoor ...
Registration Number: GE-133-929-0112-01, 260230560065, TA-133-929-0112-01
2 bedroom
1 bathroom
Sleeps 6
Hawaii> Honolulu
**COVID-19 Updated** We have enforced enhanced cleaning protocol, we guarantee you have clean, sanitised bedsheet, towels and we committed to provide more safety environment for you stay. *Due to high occupancy rate and extended ...
Registration Number: GE-012-554-4960-01, TA-012-554-4960-01, 260230560133
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Honolulu
Wake up to views of Diamond Head from your bed. Enjoy your favorite beverages on the lanai as you take in the view of the mountains, diamond head and ocean! King bed in the bedroom and pull out sofa in the living room. Sleeps a total of 4....
Registration Number: 260230560209, GE-143-800-9433-01, TA-143-800-9433-01
1 bedroom
1 bathroom
Sleeps 2
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
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
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
Welcome to your new home away from home! This charming studio, located on the 8th floor, accommodates 2 guests and is nestled right in the heart of historic Waikiki at the Pacific Monarch. We've given it a fresh makeover to create a ...
Registration Number: GE-084-947-1488-01, TA-084-947-1488-01, 260230560023
1 bedroom
1 bathroom
Sleeps 2
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
Book with confidence! This property is professionally managed by Ali'i Beach Rentals. ENHANCED PROTOCOLS : We have revised our protocols to include contactless check-in & check-out, professional EPA approved non-toxic undetectable ...
Registration Number: 126235621000, GE-111-394-2528-02, TA-111-394-2528-01
0 bedroom
1 bathroom
Sleeps 4
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
Property Management provided by Alohana Realty LLC. If the property you selected to book is unavailable or if you have further questions please feel free to contact us before booking online. **THIS IS A LEGAL VACATION RENTAL** ...
Registration Number: 260230560104, TA-078-028-0832-01, GE-078-028-0832-01
1 bedroom
1 bathroom
Sleeps 3
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
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: 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
Take in beautiful views from this 2 bed / 1 bath on Kuhio Ave, featuring a lovely lanai offering both mountain and peekaboo ocean views. Located in the well-maintained Pacific Monarch building, this lovely home includes ac, wifi, cable, indoor ...
Registration Number: 260230560065, GE-133-929-0112-01, TA-133-929-0112-01
2 bedroom
1 bathroom
Sleeps 6
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