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 '%kona coast%') AND sleeps>=1 order by rating desc LIMIT 0, 15
This is a very nice 2 bedroom 2 bath townhouse close to Kahaluu Beach Park. This property includes a very private lanai, remodeled kitchen with granite counters,ductless split air conditioning and ceiling fans throughout, a washer and dyer, and ...
2 bedroom
2 bathroom
Sleeps 4
HI> Kailua Kona
Enhance your Big Island experience with a stay at this beautiful, custom designed home on Mt. Hualalai. Located on a secluded park-like setting only 15 minutes from the Kona International Airport, at a very comfortable elevation of 1600 feet. ...
2 bedroom
3 bathroom
Sleeps 2
HI> Kailua-Kona
Elevate your next trip to the 'Aloha State' when you stay at this beautifully remodeled 1-bedroom, 1-bathroom vacation rental condo in Kailua-Kona. Tropical elegance fills the oversize living space. Comfortably decorated for two guests to enjoy...
1 bedroom
1 bathroom
Sleeps 4
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
Kona recalls the Beach Boys playing their pop hits by the pool. The band left but the good vibrations linger. Situated on 9.5 gated acres, gated for with an amazing Hawaiian plantation-style home with separate sleeping quarters and a guest ...
5 bedroom
5 bathroom
Sleeps 14
HI> Captain Cook
Settle into your lovely 2 bedroom villa, one with king sized bed with cable TV, Blu-Ray DVD, Playstation, and bathroom with tub and shower. The second bedroom is furnished with two queen or double beds, and the same amenities and private ...
2 bedroom
3 bathroom
Sleeps 6
HI> Waikoloa Village
We know you'll just love this cozy guest apartment. We've been told it feels like a rather sophisticated tree house. Pretty rooms and comfy beds. Just a quick drive to the beach and activities, but none of the hustle-bustle or crowds. The ...
3 bedroom
1 bathroom
Sleeps 7
HI> Kailua-Kona
Official website. When Granma was 95, we had to move her in with us to take care of her. This left her little panabode cabin (900 square feet with a 500 square-foot wrap-around lanai) vacant. Lucky you . . . you can spend your Hawaiian vacation ...
1 bedroom
1 bathroom
Sleeps 4
HI> Kailua-Kona
Experience the best of Hawaii in this luxury 5,600 sq ft estate. Take a dip in the heated pool and hot tub (heated to your desired temperature), drink a beer in the billiards room, have an evening putting competition on the private putting ...
5 bedroom
8 bathroom
Sleeps 14
HI> Waimea
Enjoy the best Hawaii has to offer in this luxury 10,000 sq ft tropical estate. It includes a private heated pool/spa and includes access to Mauna Lani resort area amenities including a private beach and beach club(included with rental), tennis...
7 bedroom
6 bathroom
Sleeps 18
HI> Waimea
SAVE 15% on week long stays (7 nights or more), and save 25% on month long stays (over 28 nights)
Comfortable modern downstairs vacation apartment with garden views and its own entrance. Fully furnished with queen bed, kitchen table and chairs,...
1 bedroom
1 bathroom
Sleeps 4
HI> Kailua-Kona
Wow! VERY reasonably priced and in a GREAT location! THE CALENDAR IS UP TO DATE CHECK FOR AVAILABILITY THERE!
LOCATION! LOCATION! LOCATION! 11.5 Miles South of Kona Airport. 2 miles to Magic Sands Beach, 3.5 Miles to Kailua Kona Village. In ...
5 bedroom
3 bathroom
Sleeps 12
HI> Kailua-Kona
Newly renovated Two Bedroom Two Bath Condo with Full Ocean View in Center of Complex on 2nd Floor on the Kona Coast. Corner Unit
Wifi equipped
Ceiling Fans
Portable Air Conditioner in living room
Enjoy Dophins spinning and whale watching in ...
1 bedroom
2 bathroom
Sleeps 5
HI> Kailua-Kona
A spacious 2-Bedroom / 2-Bath luxury condo, all on one level, located at the bridge level (no flights of stairs to/from the unit, only a few steps to Bridge-way) in building 10, the highest point of resort to soak in the wonderful Kona Sunsets ...
2 bedroom
2 bathroom
Sleeps 4
HI> Kailua Kona
2-302 (1) The Beach Villas at Kahaluu is the perfect place for family and friends to stay on the Big Island of Hawaii. The vacation rental has 1 bedroom, 2 bathrooms, and an ocean view from the private lanai. Vacationers will find themselves in ...
1 bedroom
2 bathroom
Sleeps 2
HI> Kailua Kona
