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 (`headline` like '%Keauhou%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Relaxing is easy when listening to the sound of the waves from this cozy two-bedroom, two-bathroom ocean view suite. You’ll love how spacious this corner unit feels, with lots of room to sprawl out with family and friends.
Enjoy warm tropical...
2 bedroom
2 bathroom
Sleeps 6
HI> KAILUA-KONA
PLEASE NOTE that Hawai`i County currently has an Emergency Proclamation regarding travel and requires registration through Hawaii Safe Travels. The current proclamation does NOT allow for quarantining in a STVR (Short Term Vacation Rental). We ...
1 bedroom
1 bathroom
Sleeps 2
HI> Kailua-Kona
Keauhou Gardens 5-204 is a spacious three bedroom/two bath condo located in the Keauhou Gardens section of the Kona Coast Resort situated on 20+ acres of tropical landscaped Gardens and the beautiful Kona Coast Golf Course.
Keauhou Gardens are ...
4 bedroom
2 bathroom
Sleeps 8
HI> Kailua-Kona
Na Hale B-3 is a spacious 3-bedroom, 2-1/2 bath townhome in one of Kona's premier resort developments, Na Hale O Keauhou. Building B has a great location in the complex for great ocean & mountain views, and stunning Kona sunsets. This ...
3 bedroom
3 bathroom
Sleeps 6
HI> Kailua Kona
This stunning property is now accepting longer-term stays at reduced rates. Please inquire for details.
This private and peaceful residence with central air conditioning is beautifully appointed for a luxury vacation in paradise. Holua Kai 29 ...
3 bedroom
3 bathroom
Sleeps 6
HI> Kailua Kona
***Please read listing description for full details on this lovely property! We also have another listing at the Keauhou Surf and Racquet Club if this property isn't available: Vrbo 1620967.
We are an approved Short Term Vacation Rental ...
2 bedroom
2 bathroom
Sleeps 6
HI> Kailua-Kona
This space is a peaceful and tranquil 2 bedroom. This beautifully decorated and homey 2 bedroom is located within the Keauhou Punahele community. Keauhou Punahele is the perfect place to relax. Located next to a golf course, this location is ...
2 bedroom
2 bathroom
Sleeps 6
HI> Kailua Kona
In light of the COVID-19 Crisis, LUVA Vacation Rentals has taken extra cleaning precautions to assure our arriving guests that they can
Welcome to Keauhou Lani an exquisite private residence located in the desirable gated community of Keauhou ...
4 bedroom
4 bathroom
Sleeps 8
HI> Kailua-Kona
Serene, peaceful, and relaxing. This 3 bedroom, 2 bath single story home is located in Kailua-Kona, across the street from beautiful He'eia Bay (a one minute walk). The house sleeps 6 people and is stocked with most items needed for a relaxing ...
3 bedroom
2 bathroom
Sleeps 6
HI> Kailua-Kona
Welcome to our beautiful Na Hale O'Keauhou Townhome! An amazing place to enjoy your vacation on the Big Island. Just a short walk to Kahaluu Beach and breathtaking ocean views from the lanai. Na Hale O' Keauhou is a Premier Gated Community ...
3 bedroom
3 bathroom
Sleeps 6
HI> Kailua Kona
ENHANCED CLEANING PROCEDURES! Sit and relax on the lanai and enjoy stunning ocean and sunset views. Fully equipped kitchen with everything you could need. New kitchen cabinets, counter tops, floors, and bathrooms. New high definition ...
2 bedroom
2 bathroom
Sleeps 4
HI> Kailua Kona
A beautifully landscaped, quiet, and one of the newest properties in Kona. The townhome is in an upscale gated community. It is a 3 bedroom and 2.5 bath townhouse with a garage. The condo has 1700 sq. ft. not including 2 large lanais. It is ...
3 bedroom
3 bathroom
Sleeps 6
HI> Kailua-Kona
LOCATION: Oceanfront Kona Coast/Kailua-Kona, Big Island of Hawaii, USA. 25 minutes south of the Kona International Airport, within walking distance of shopping, restaurants, movie theater, and well known Snorkeling Beach, the Kahalu'u Beach Park...
2 bedroom
2 bathroom
Sleeps 4
HI> 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 Gated Complex• Large...
3 bedroom
3 bathroom
Sleeps 6
HI> Kailua Kona
The best location in the resort with Sunset Views Year Round:
Desirable Building #5
Ground Floor
Corner Unit with Large Lanai
Non-Smoking no vaping No service fee if booked at alohacondos.com email ...
2 bedroom
2 bathroom
Sleeps 4
HI> Kailua Kona
