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 = 'kaneohe' OR postalCode = 'kaneohe' OR region like '%|kaneohe|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Please check with our current government regulations regarding arrival restrictions and guidelines for the Hawaiian islands. This property is not available to anyone who is required to quarantine.
Hale Maluhia (translates to peaceful and ... Registration Number: TA-020-525-0560-01, GE-02
4 bedroom
3 bathroom
Sleeps 8
HI> Kaneohe
Waterfront home with a million dollar view of Kaneohe Bay! Enjoy fresh tradewinds on your covered decks, and the comfort of a/c inside. This custom home has spacious living areas on both levels with fast WIFI indoors AND out! 5 bedrooms, 2 ... Registration Number: TA-090-839-4496-01, 45001
5 bedroom
4 bathroom
Sleeps 10
HI> Kaneohe
Located on Kaneohe Bay, a separate apartment with private entrance. TempurPedic California King bed, air conditioning, washer & dryer in unit, high speed fiber internet, cable with movie channels, 5 mins from beaches and shops in Kailua.
... Registration Number: TA-161-175-8080-01, GE-16
1 bedroom
1 bathroom
Sleeps 3
HI> Kaneohe
Step Into Serenity......This peaceful retreat, with its tropical palate and vibe, invites you to come inside and bask in the Spirit of Aloha, even as the sea beckons you down to the shore to rest at the 'aekai (water's edge), admire the tropical... Registration Number: TA-158-127-3088-01, GE-15
2 bedroom
1 bathroom
Sleeps 4
HI> Kaneohe
Relax in our newly renovated private upstairs two-bedroom unit. Each room includes AC, tv, mini-fridge and wet-bar with hotplate. Sip on your favorite beverage while enjoying the sunrise and sunset from your private balcony. Shared bathroom ... Registration Number: TA-057-018-5728-02, GE-05
2 bedroom
1 bathroom
Sleeps 4
HI> Kaneohe
***Please inquire before booking. Dates are not confirmed until Owner/ Manager sends confirmation.
30 day rental
Description
Pacific Tradewinds is located on east Oahu along beautiful Kaneohe Bay with breathtaking views of the bay, ocean, and... Registration Number: TA-128-412-7232-01, GE-12
5 bedroom
4 bathroom
Sleeps 14
HI> Kaneohe
Enjoy this peaceful & private tropical oceanfront estate with beautiful views of the Koolau mountains and Chinaman's Hat. With easy access to the water, water activities and located conveniently between North Shore and town, this is the perfect ... Registration Number: TA-044-665-9072-01, GE-04
3 bedroom
2 bathroom
Sleeps 4
HI> Kaneohe
