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 '%kuhio village%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Kuhio Village 810A KING Studio, Waikiki Ocean View!
Ocean view form Balcony! RE-DECORATED with Linens & Artwork. Free WiFi!! NEW Air conditioner, NEW refrigerator! Enjoy this studio with plenty of sleeping room in a KING bed! Cable TV is...
Registration Number: GE-054-506-4960-01, TA-054-506-4960-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Kuhio Village 804A Prime WAIKIKI Private Apartment
Walk into a comfortable and quiet studio with all the essentials that will give you a home like feeling. Enjoy a night's rest in a queen bed with linens provided after a fun day of ...
Registration Number: GE-179-740-0576-01, TA-179-740-0576-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Over-sized upgraded studio with 2 balconies, facing mountains! Ceramic tile flooring with luminous lighting throughout the dwelling. This unit sleeps up to 3 with the King bed and Single day bed. Kitchenette includes granite counter tops and ...
Registration Number: GE-121-286-2464-01, TA-121-286-2464-01
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Honolulu
Kuhio Village 403A Clean and 2 Minutes to the Beach!!
Enjoy this studio with plenty of sleeping room for your guests!! There is a Queen size bed and Futon Couch, air conditioner, Cable TV is available on large 32" flat screen TV, ...
Registration Number: GE-028-193-1776-01, TA-028-193-1776-01
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Honolulu
Kuhio Village 702 Private Waterfall Room with Mountain View!
Great Studio for someone doing a vacation on a budget! Kuhio Village 702 offers accommodations in Honolulu, just 650 feet from Saint Augustine by-the-Sea .ONLY 2 MINS 2 BEACH!!...
Registration Number: GE-120-830-3616-01, TA-120-830-3616-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Kuhio Village 803A - Waikiki Private Getaway.... 2 mins to Waikiki Beach
Located only 2 short blocks to the beach, Duke's statue and Waikiki strip. Private studio newly renovated: laminate flooring, air conditioner, artwork, linens, and ...
Registration Number: GE-045-056-8192-01, TA-045-056-8192-01
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> 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, GE-140-094-0544-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Kuhio Village 708A Renovated Private Studio - 2 min Walk to the Beach!
Enjoy this studio with free WiFi and Cable TV, nicely Upgraded partial kitchen includes a one top burner, microwave, toaster, coffee maker, dishes, and a Refrigerator....
Registration Number: TA-007-601-7664-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Kuhio Village 510 KING Bed with Renovated Kitchenette
Enjoy this great, comfortable studio featuring a large KING bed and a Kitchenette with a large refrigerator, microwave, hot plate with pots and pans, coffee maker and tea kettle! ...
Registration Number: TA-140-094-0544-01, GE-140-094-0544-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> 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 Duke’s Lane, newly built International Market Place, ...
Registration Number: GE-175-883-0592-01, TA-175-883-0592-01, 1260230500078
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Welcome to Kuhio Village 202A - Your Waikiki Oasis with Ocean Views!
Immerse yourself in the vibrant spirit of Waikiki from the comfort of our newly remodeled Kuhio Village 202A condo. This enchanting studio unit offers an exceptional ...
Registration Number: TA-070-783-7952-01, GE-070-783-7952-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Newly remodeled and fantastically located Waikiki studio with private lanai at the secure Kuhio Village building. Located right on Kuhio Ave., our guests enjoy easy access to the upscale Duke’s Lane, newly built International Market Place, ...
Registration Number: GE-175-883-0592-01, TA-175-883-0592-01, 1260230500058
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> 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 Duke’s Lane, newly built International Market Place, Kalakaua Ave and ...
Registration Number: 1260230500070, TA-022-954-5984-01, GE-022-954-5984-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Stylishly 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 Duke’s Lane, newly built International Market Place, Kalakaua Ave and ...
Registration Number: GE-033-015-2448-01, TA-033-015-2448-01, 260230500041
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Newly Remodeled Kuhio Village 807 Waikiki Studio
Newly remodeled unit including new kitchenette, bath vanity, sink, paint, queen bed, bedding pillows, towels with all the comforts of home. Including all cooking utensils, dishes, coffee ...
Registration Number: GE-107-766-9888-01, TA-107-766-9888-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Take advantage of the amazing location of this Kuhio Village studio, right in the heart of Waikiki. In addition to the full bath, quaint kitchenette/dining area for 2, and private lanai with outdoor furniture, this unit features a flatscreen tv,...
Registration Number: TA-049-560-9344-01, GE-049-560-9344-01, 260230500074
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu