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 (`headline` like '%Na Hale O Keauhou%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Enjoy Panoramic Ocean Views from your private lanais. Sunset views 365 days a year. Your only decision, whether to use the upstairs lanai with chaise lounge and cosy sitting area perfect for morning coffee or wine and cheese at sunset, or the ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Best ocean view townhome in rhe resort:
Sunset Views Year Round
180 Degree Ocean Views
Walk to Kahalu'u Beach Park- the best snorkling beach in Kona
Adjacent to Restaurants, Cinema, Grocery Store
• Beautiful Ocean-View ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua Kona
This exceptional, three-bedroom, 2.5 bath townhome offers expansive ocean views
in the peaceful resort community of Na Hale O Keauhou.
The immaculate, gated neighborhood lies on the quiet end of town, but just a
mile from ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Maximum occupancy strictly enforced in accordance with local ordinances.
Welcome to Na Hale O Keauhou #I1! Located in one of Keuhou’s newer neighborhoods, this one is a delightful Hawaiian getaway home. Enjoy nearby beaches and glorious...
- 4 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Located in the highly desirable Na Hale Community, this beautiful well-appointed 2-bedroom, 2.5-bathroom
townhome offers spectacular ocean views and breathtaking sunsets. Both
bedrooms feature private, ensuite bathrooms. Additional in-home...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Welcome to Aloha!! Listen to the crashing surf from gorgeous Na Hale O Keauhou L-6. Spacious 2-story luxury air-conditioned Townhome with Panoramic Ocean Views. This wonderful remodeled and upgraded unit features 3 Bedrooms, 3 Baths, ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Immaculate ocean view townhome!
Ocean views, epic sunsets and poolside afternoons: That's what a true Hawaii vacation is all about. This immaculate, three-bedroom townhome is set in the quiet, gated community of Na Hale O Keauhou just...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Enjoy expansive ocean and golf course views from both upper and lower lanais and famous Kona sunsets right in front the upper lanai. Designer furnishings, Pacific Rim antiques and tropical décor. Original local artist works. The fully equipped ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
***Pool, spa and fitness room will be closed in August 2024 for maintenance.*** Na Hale O Keauhou K-1 is a spacious 1704 square foot 2-story luxury air-conditioned Townhome with Ocean Views. This delightful, well-appointed townhome is located on...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Best location at Na Hale O Keauhou and added to the website on December 18, 2014. • Beautiful Ocean-View Gated Complex• Large & Luxurious 2 & 3-Bedroom Townhomes• Resort Pool, Spa, Clubhouse & Fitness Facilty• Pavilion with Kitchen• ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua Kona
This beautiful two-bedroom townhouse offers spectacular ocean, golf course, coastline, and pool views from the living room, both Lanais, and the master bedroom. A delightful two-bedroom, 2.5 bathroom unit offering large spacious bedrooms, a ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Panoramic, 180 degree Ocean Views from Both Levels of the Townhome
Spacious 3 Bedroom, 3 Bath Townhome
Covered Lanais
Fully Equipped Gourmet Kitchen
Beautifully Furnished by Hawaii's Top Interior Designer
600 Count ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua Kona
This luxurious custom designed delectable 3 bedroom, 3 bathroom townhome with AC is tucked away in the corner of the complex with an expansive view of a green space preserve and small ocean views. Very private and quiet. Only a 1 block to ...
- 3 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Kailua-Kona
Glorious Na Hale O Keauhou is an exclusive luxury gated community in the heart of Keauhou. Unit B4 is a 3 bedroom, 2.5 bath townhome with 2 covered lanais. Enjoy spectacular 180 degree unobstructed ocean and sunset views from almost every room ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> KAILUA-KONA
Na Hale O Keauhou #F1 on the Big Island
This vacation rental is professionally managed by ResorticaHawaii
Please scroll down for detailed information
Bedroom Configuration:
Master Bedroom: King Bed
Guest Bedroom: Queen ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Book 5 nights and enjoy the 6th night free! Valid for new reservations from 10/13/24 for stays between 10/13/2024 - 11/21/2024!
Enjoy beautiful Keauhou, Hawaii from the comfort of this quiet, gated neighborhood complete with a pool, hot ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Aloha & Welcome to our beautiful townhome in Na Hale O' Keauhou, a premier gated community nestled in the heart of Kona - Keauhou. With just a short stroll to Kahaluu Beach and stunning ocean views from the lanais. This 2 bedroom, 3 bath condo ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Kailua-kona