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
30 day rental
Description
Sea Breeze Combo is composed of two homes, Sea Breeze Manor and Sea Breeze Villa. Together, the two homes have 8 bedrooms and 7 bathrooms and can sleep up to 18 guests.
Sea Breeze Manor (5-bedroom)
This beautifully ... Registration Number: TA-048-778-0352-01
8 bedroom
8 bathroom
Sleeps 16
HI> Kaneohe
30 day rental
Description
Imagine yourself relaxing in your own private home over looking the beautiful Kane'ohe Bay. Kane'ohe Bay is one of the most photographed spots on the island. The Sea Breeze Villa is a 3-bedroom, 3-bath home is not ... Registration Number: TA-048-778-0352-01
3 bedroom
3 bathroom
Sleeps 6
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
**We take cleanliness seriously and sanitation is our number one priority. Our professional cleaner ensures that your safety comes first.
Description
This beautiful 6000 square foot, 6 bedroom bay front home, is not only in the perfect location... Registration Number: TA-048-778-0352-01
6 bedroom
6 bathroom
Sleeps 12
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
***Please inquire before booking. Dates are not confirmed until Owner/ Manager sends confirmation.
30 day rental
We take cleanliness seriously and sanitation is our number one priority. Our professional cleaner ensures that your safety comes ... Registration Number: TA-048-778-0352-01
4 bedroom
3 bathroom
Sleeps 8
HI> Kaneohe
30 Day rental
Description
This beautifully appointed manor is a 5-bedroom home with everything you will need. It has fine furnishings with beautiful marble flooring and Australian wood. It has a fully equipped modern kitchen, a grand piano, ... Registration Number: TA-048-778-0352-01
5 bedroom
5 bathroom
Sleeps 12
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
30 day rental
Description
Come relax in this resort style estate. Designed for home-like comfort, this rental is perfect for multi-family vacations. The Sea Breeze Estate is composed of 3 homes – the Sea Breeze Manor, the Sea Breeze House ... Registration Number: TA-048-778-0352-01
12 bedroom
11 bathroom
Sleeps 24
HI> Kaneohe
