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 = 'honolulu' OR postalCode = 'honolulu' OR region like '%|honolulu|%') 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
We welcome everyone and especially love hosting families and traveling professionals for extended stays. Easy access to highways in both directions for access to Waikiki, downtown, military bases and hospitals. Our guest house is completely ...
Registration Number: TA-093-987-6352-01, GE-09
2 bedroom
1 bathroom
Sleeps 6
HI> Honolulu
There’s no better way to experience Oahu’s south shore than from this charming Honolulu vacation rental home. Ideal for a romantic retreat, this 1-bedroom, 1-bath home for 2 is a short stroll from the scenic Koko Crater trail system, 1 mile ...
Registration Number: TA-038-936-9856-01, GE-03
1 bedroom
1 bathroom
Sleeps 2
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