select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) as vw where 1 and round(price)>0 and bedrooms>=0 and (registration_number like 'TA-%') AND (`headline` like '%Hawaiian Monarch%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Waikiki Studio, furnished. Waikiki Studio, furnished. Location: Hawaiian Monarch Hotel building, 444 Niu Street. On the bus line, next to 7-11 convenience store, walking distance to a major supermarket.
$79/day, one time cleaning fee $75 . It...
Registration Number: TA-123-635-5072-01, GE-12
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
Ocean views high in the sky in this fabulously remodeled two-bedroom penthouse. Located at the beginning of Waikiki, this unit offers ac, flatscreen tv, wifi and cable a short walk from Fort DeRussy Beach Park, Hilton Hawaiian Village, Ala Wai ...
Registration Number: TA-056-678-2464-01
- 2 bedroom
- 2 bathroom
- Sleeps 8
HI> Honolulu
Enjoy ocean and pool views from this spacious studio at the ideally located Hawaiian Monarch. Nestled at the beginning of Waikiki, this unit features ac, smart tv, wifi and cable a short walk from Fort DeRussy Beach Park, Hilton Hawaiian ...
Registration Number: TA-178-838-9376-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
Simple and spacious Waikiki studio with city views and a great location at the Hawaiian Monarch building. This unit features ac, smart tv, Wi-Fi and cable a short walk from Fort DeRussy Beach Park, Hilton Hawaiian Village, Ala Wai Canal and ...
Registration Number: TA-001-224-7040-02
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
Gorgeously remodeled studio with ocean and pool views and a fantastic location at the Hawaiian Monarch building. This unit features ac, smart tv, Wi-Fi and cable a short walk from Fort DeRussy Beach Park, Hilton Hawaiian Village, Ala Wai Canal ...
Registration Number: TA-192-250-9312-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
Take in ocean views from this beautifully renovated studio at the Hawaiian Monarch building. Located at the beginning of Waikiki, this unit offers ac, smart tv, wifi and cable a short walk from Fort DeRussy Beach Park, Hilton Hawaiian Village, ...
Registration Number: TA-211-923-7632-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
Stylishly upgraded Waikiki studio in a fantastic location at the Hawaiian Monarch. This unit features ac, smart tv, wifi and cable a short walk from Fort DeRussy Beach Park, Hilton Hawaiian Village, Ala Wai Canal and more. The Hawaiian Monarch ...
Registration Number: TA-028-153-2928-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
Take in city and mountain views from this charming studio at the Hawaiian Monarch building. Located at the beginning of Waikiki, this unit offers ac, smart tv, wifi and cable a short walk from Fort DeRussy Beach Park, Hilton Hawaiian Village, ...
Registration Number: TA-107-026-9440-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
Cool, clean and spacious Waikiki studio in a great location at the Hawaiian Monarch. This unit features ac, smart tv, wifi and cable a short walk from Fort DeRussy Beach Park, Hilton Hawaiian Village, Ala Wai Canal and more. The Hawaiian Monarch...
Registration Number: TA-133-341-1840-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
Take in city and partial ocean views from this beautifully renovated studio at the Hawaiian Monarch building. Located at the beginning of Waikiki, this unit offers ac, smart tv, wifi and cable a short walk from Fort DeRussy Beach Park, Hilton ...
Registration Number: TA-134-556-6720-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
Gorgeously renovated Hawaiian Monarch studio with Ala Wai views and a fantastic location. This unit features ac, smart tv, wifi and cable a short walk from Fort DeRussy Beach Park, Hilton Hawaiian Village, Ala Wai Canal and more. The Hawaiian ...
Registration Number: TA-041-753-1904-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
Freshly updated, stylish studio with mountain and Ala Wai views in an awesome location at the beginning of Waikiki. This unit features ac, smart tv, Wi-Fi and cable a short walk from Fort DeRussy Beach Park, Hilton Hawaiian Village, Ala Wai ...
Registration Number: TA-034-954-4448-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
Cool and clean Waikiki studio with city views and a great location at the Hawaiian Monarch building. This unit features ac, smart tv, Wi-Fi and cable a short walk from Fort DeRussy Beach Park, Hilton Hawaiian Village, Ala Wai Canal and more. The...
Registration Number: TA-133-341-1840-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
Unique and fantastically located studio with palm tree views overlooking Ala Wai Canal. Nestled at the beginning of Waikiki, this unit features ac, smart tv, wifi and cable a short walk from Fort DeRussy Beach Park, Hilton Hawaiian Village, Ala ...
Registration Number: TA-082-953-2160-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
Spacious Hawaiian Monarch studio with Ala Wai views located at the beginning of Waikiki. This unit features ac, smart tv, wifi and cable a short walk from Fort DeRussy Beach Park, Hilton Hawaiian Village, Ala Wai Canal and more. The Hawaiian ...
Registration Number: TA-175-883-0592-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
