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 '%waikiki beach%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Wyndham Waikiki Beach Walk - 2 Bedroom Unit (Sleeps 8)
**PLEASE READ ENTIRE DESCRIPTION BEFORE REQUESTING RESERVATION**
Book our Amazing Condo & let The Timeshare Brokers, LLC make the booking process easy!
Key Points:
-You’re inquiring on...
Registration Number: TA-075-433-7792-01, GE-19
2 bedroom
2 bathroom
Sleeps 8
HI> Honolulu
Get away from typical tourist rentals and stay in this renovated and fully restored mid-century ranch-style Hawaiian home that harkens back to another era. Originally built in 1948, this home is situated at the base of the Aina Haina valley, a ...
Registration Number: TA-010-603-8272-01, 00000
4 bedroom
4 bathroom
Sleeps 8
HI> Honolulu
Check out the video in the photos.
One-of-a-kind luxuries 2 bedroom, 2 bath unit on the 23rd floor at the Waikiki Beach Tower. Exceptional ocean views. Over a million was spent in remodeling. The unit has a large lanai with a table, ...
Registration Number: TA-137-941-8112-01, GE-13
2 bedroom
2 bathroom
Sleeps 6
HI> Honolulu
Work and rest in our expansive unit! Our cleaning crew uses enhanced cleaning procedures after each guest. Discounts for longer stays available.
Your fully remodeled home away from home in paradise, with partial ocean views from the 2 lanais! ...
Registration Number: TA-109-676-9536-01, 26023
2 bedroom
2 bathroom
Sleeps 8
HI> Honolulu
*** Sanitation/Cleaning Update ***
Wyndham resorts have always met the highest standards of cleanliness, and now we are exceeding those standards with enhanced cleaning protocols and disinfecting measures, including the use of hospital-grade, ...
Registration Number: TA-097-684-8896-04, GE-07
1 bedroom
1 bathroom
Sleeps 4
HI> Honolulu, Ohau
Property Address: 155 Paoakalani Avenue, Honolulu HI 96815
Gorgeous newly remodeled Penthouse with Diamond Head and Ocean Views, located just a block from Waikiki Beach and the Honolulu Zoo, this 1,700+ s.f. (153.93 square meters) condo offers ...
Registration Number: TA-020-905-4208-01, GE-02
2 bedroom
2 bathroom
Sleeps 6
HI> Honolulu
Professionally managed high floor studio, with queen bed and desk area - Located in central Waikiki you are 3 blocks walking distance to the world famous Waikiki Beach - check out the new International Market Place - or hang out by the on-site ...
Registration Number: TA-163-375-3088-01
1 bedroom
1 bathroom
Sleeps 2
HI> Honolulu
*** Sanitation/Cleaning Update ***
Wyndham resorts have always met the highest standards of cleanliness, and now we are exceeding those standards with enhanced cleaning protocols and disinfecting measures, including the use of hospital-grade, ...
Registration Number: TA-097-684-8896-04, GE-07
1 bedroom
1 bathroom
Sleeps 4
HI> Honolulu, Ohau
This Unit is Legally Hotel Zoned vacation retal (2450 Prince Edwards St) and Cozy studio in Waikiki, fully furnished and great view with balcony.
1min walk to the Waikiki beach and everything Waikiki has to offer.
We have beach things also like ...
Registration Number: TA-054-917-6320-01, GE-05
0 bedroom
1 bathroom
Sleeps 2
HI> Honolulu
Step back in time into the lush, tropical surroundings of our courtyard. A quaint and inviting escape from the distractions of urban island life, this outdoor oasis is the perfect place to take a dip and catch some rays. Whether you're in ...
Registration Number: TA-017-073-5616-01, GE-01
3 bedroom
3 bathroom
Sleeps 12
HI> Honolulu
Foster Tower is located steps away from beautiful Waikiki beach. This is a one bed room unit in a highly desirable building and location. Enjoy beautiful ocean views and immediate access to the beach for surfing, swimming, snorkeling, hundreds ...
Registration Number: TA-069-363-0976-01, GE-06
1 bedroom
1 bathroom
Sleeps 4
HI> Honolulu
STUDIO 24 is a beautiful refurbished unit, located in the heart of Waikiki across the street from the International Marketplace. ABC stores are only a 5 minute walk away.
We offer Cleanliness and Confidence!
We promise you a clean, ...
Registration Number: TA-190-718-5664-01, GE-19
1 bedroom
1 bathroom
Sleeps 3
HI> Honolulu
Requires 30 minimum day rental. This location is out of the hustle and bustle of Waikiki (so a lot quieter at night) and close to many eateries. Honolulu Zoo is right next door. Also, Close to Diamond Head Crater and Waikiki Beach and Aquarium....
Registration Number: TA-123-378-0736-01, GE-12
3 bedroom
2 bathroom
Sleeps 8
HI> Honolulu
Our recently upgraded vacation rental with great beach and ocean views from your private lanai (balcony) is now available! It is literally a 1-minute walk to the beach!!!
It is a nicely furnished studio, has a new kitchen with granite counters,...
Registration Number: TA-182-936-1664-01
0 bedroom
1 bathroom
Sleeps 2
HI> Honolulu
Privately owned, Queen bed, 4th Floor, Kitchenette, Free Wifi, Elevator, Heated Pool, Jacuzzi, Private balcony, Facing West, Non-smoking.
There are NO extra charges. All charges are shown on the reservation form.
Aloha!
This charming studio ...
Registration Number: TA-168-519-6800-01, GE-16
0 bedroom
1 bathroom
Sleeps 2
HI> Honolulu