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 (city = '96815' OR postalCode = '96815' OR region like '%|96815|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Deluxe Panoramic Mountain View Condo - 37th Floor, Free parking & Wifi
Enjoy paradise with an incredible mountain view Waikiki Banyan condo suite only one block from world famous Waikiki Beach! Condo suite is located on the 37th floor and has ...
Registration Number: TA-024-432-8448-01
- 1 bedroom
- 1 bathroom
- Sleeps 6
HI> Honolulu
Beautifully renovated Waikiki studio in a fantastic location at the secure Kuhio Village building. Located right on Kuhio Ave., our guests enjoy easy access to the upscale Dukes Lane, newly built International Market Place, Kalakaua Ave and ...
Registration Number: TA-022-954-5984-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
Waikiki Sunset 2105 Paradise Awaits 1-bedroom Superior Suite with Incredible Views *** Covid-19 Required 3 Day Registration prior to arrival*** No Back to Back Bookings Due to New Covid-19 Guidelines***
World Famous Waikiki White Sandy Beaches...
Registration Number: TA-181-163-0080-01
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> Honolulu
Waikiki Park Heights 1208 Sun & Beach Fun only 3 minutes away
Live Aloha in this one bedroom apartment providing a comfortable place to enjoy. Central A/C to keep you cool on those warm, sunny days. Lovely lanai (balcony) to take in the ocean ...
Registration Number: TA-199-603-4048-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Honolulu
Beautiful Ocean View: Naturally well-lit Studio 1 bathroom apartment in Vibrant Waikiki. Close to the major bus lines, Shaka Tours, and shopping on Kalakaua Ave. Relax on the Balcony, pub style seating for two. Free Wifi, Queen bed plus comfy ...
Registration Number: TA-140-094-0544-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
***All unvaccinated guests are required to show proof of negative covid results prior to checking in the unit. Otherwise, vaccinated guests have to show vaccination info***
*Please note that our vaccination/covid test requirements are not the ...
Registration Number: TA-116-827-1360-03, GE-11
- 1 bedroom
- 1 bathroom
- Sleeps 3
HI> Honolulu
Deluxe High Level Renovated Condo with Ocean & Diamond Head View, Free parking & Wifi
Completely renovated in June 2017! New tile flooring all the way through to the lanai, this special unit has a beach feel with modern furnishings. Enjoy a ...
Registration Number: TA-034-157-9776-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Honolulu
Ready-to-work environment from the moment of check-in with complimentary high speed wifi.
Spacious desk for work-friendly environment.
Working from the Lanai with gorgeous ocean view.
Ilikai Oceanview & Hawaiian breeze - Easy access 3rd floor ...
Registration Number: TA-016-725-4016-01, GE-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Honolulu
Deluxe Ocean View Condo
Sleek and modern condo just a block from world famous Waikiki Beach!
Sleeping arrangements include two queen-sized beds in the bedroom and a sofa sleeper in the living room. The bathroom has a second door for your ...
Registration Number: TA-006-364-9792-01
- 1 bedroom
- 1 bathroom
- Sleeps 6
HI> Honolulu
Two short blocks to the World's most famous beach. Wake up and enjoy beautiful ocean views and tropical breezes from your eat-in kitchen or spacious lanai.
This is unit is one of our most popular and once you see the ocean views for yourself, ...
Registration Number: TA-029-703-5776-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
Recently renovated Waikiki studio with private lanai and fantastic location at the secure Kuhio Village building. Located right on Kuhio Ave., our guests enjoy easy access to the upscale Dukes Lane, newly built International Market Place, ...
Registration Number: TA-175-883-0592-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
Sweeping view of Ocean and Diamond Head from beautiful 1 bedroom sparkling just renovated condo unit in the Waikiki Sunset Hotel! The location is perfectly located just 2 short blocks to the main area of Waikiki beach, International ...
Registration Number: TA-027-765-7600-01, GE-02
- 1 bedroom
- 1 bathroom
- Sleeps 5
HI> Honolulu
Waikiki Banyan 1812 Tropical Oasis Parking and WiFi
1.5 blocks to white sand Waikiki Beach. Air Conditioned spacious living room that leads to the Lanai to relax and enjoy the views of the Ocean, Diamond Head and the famous Waikiki Banyan ...
Registration Number: TA-163-424-8704-01
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> Honolulu
Absolutely awesome unit located just a block from the beach. Large unit with kitchen and bath...ALL PRIVATE!
Within our CLEAN PRIVATE unit, GUESTS will enjoy:
• QUEEN to comfortably sleep two, with all bedding and linens
• LED HDTV with ...
Registration Number: TA-138-365-7472-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
Immerse yourself in the Hawaiian Lifestyle. The boutique-style accommodation features views from the mountains to the ocean! Free wifi, pool, fitness area and just three blocks from the beach.
Within our CLEAN PRIVATE unit, GUESTS will ...
Registration Number: TA-115-601-2032-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
