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 '%kuhio village%') AND sleeps>=1 order by rating desc LIMIT 0, 15
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
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
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
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: TA-209-828-2496-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> 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 soaking that...
Registration Number: TA-179-740-0576-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> 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, mounted on ...
Registration Number: TA-028-193-1776-01
- 1 bedroom
- 1 bathroom
- Sleeps 3
HI> 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!! The ...
Registration Number: TA-120-830-3616-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> 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 3
HI> Honolulu
Kuhio Village 609A Desirable Private Studio perfect for a Oahu Getaway
This studio comes with large Kitchenette that includes all cooking utensils, pots, pans, toaster, coffee maker, 2 burner stove, dishes, microwave, and refrigerator. Relax ...
Registration Number: TA-155-967-0784-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> 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! Sleeps 1-2...
Registration Number: TA-140-094-0544-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> 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 all the...
Registration Number: TA-045-056-8192-01
- 1 bedroom
- 1 bathroom
- Sleeps 3
HI> Honolulu
Kuhio Village 202A Waikiki Condo Recently Remodeled
Newly Remodeled, including new queen bed, bath, wall mounted 40" TV with Free WIFI & Cable, paint, tile flooring, wardrobe shelves, furniture, bedding, towels, induction cooktop. Everything ...
Registration Number: TA-070-783-7952-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
Kuhio Village 802A Cozy Studio with Ocean View!
ALOHA and WELCOME to Waikiki, Honolulu on Oahu! Ocean view from Balcony! Free Wifi!! Unit has A/C, fridge, TV & cable. Microwave/refrigerator included. The bathroom is equipped with extra towels ...
Registration Number: TA-123-157-7088-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
Enjoy being in the center of Waikiki, Penthouse floor & short walk to BEACH. Inside is a Queen bed with bathroom with draws below for extra storage. Flat Screen TV, Free Wifi, Kitchenette with built-in Cook-top. Linens and towels are provided. ...
Registration Number: TA-179-740-0576-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> 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 maker, ...
Registration Number: TA-153-194-2912-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
