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 Hawaiian Resort%') AND sleeps>=1 order by rating desc LIMIT 0, 15
The Wyndham Kona Hawaiian Resort is situated on more than thirty acres overlooking Kahului Bay in Kailua-Kona on the Big Island of Hawaii, Amenities on-site include two outdoor swimming pools, a children s pool, exercise facility, and two ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua-Kona
Please note, some holiday weeks require a seven night stay, please confirm with agent. Prime weeks and holiday weeks have higher rates, your agent will send you an initial quote based on the dates you have chosen.
DASH REALTY GROUP, INC is ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua-Kona
The Wyndham Kona Hawaiian Resort is situated on more than thirty acres overlooking Kahului Bay in Kailua-Kona on the Big Island of Hawaii, Amenities on-site include two outdoor swimming pools, a children s pool, exercise facility, and two ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua-Kona
The Wyndham Kona Hawaiian Resort is situated on more than thirty acres overlooking Kahului Bay in Kailua-Kona on the Big Island of Hawaii, Amenities on-site include two outdoor swimming pools, a children s pool, exercise facility, and two ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua-Kona
Enjoy the ambiance of Hawaii as it was in the 30's.
A Step Back to Authentic Hawaiian Pleasures. When you stay at Wyndham Kona Hawaiian Resort in Kailua-Kona on the Big Island’s west coast, you’ll feel as if you’re stepping back in time ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua Kona
2 Bedroom, 2 Full Bath Villa located just a short drive or walk from the historic Kailua-Kona, aka Historic Kailua Village.
The unit sleeps 6 with a King in each bedroom and a queen sleeper sofa in the living room as well as a full kitchen and...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua-Kona
The Wyndham Kona Hawaiian Resort is situated on more than thirty acres overlooking Kahului Bay in Kailua-Kona on the Big Island of Hawaii, Amenities on-site include two outdoor swimming pools, a children s pool, exercise facility, and two ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua-Kona
Concierge Realty is proud to present luxury villas at this premier location on the Big Island!
We are able to offer reservations in weekly increments with arrivals and departures, Fridays, Saturdays, and Sundays.
Situated on more than thirty ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua Kona
Aloha and welcome to Wyndham Kona Hawaiian! This paradise within a paradise is designed to capture the charm of the 1930s and transport you to a simpler time. Your fully furnished condo is close to the beach and has a swimming pool and fitness ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua-Kona
The Wyndham Kona Hawaiian Resort is situated on more than thirty acres overlooking Kahului Bay in Kailua-Kona on the Big Island of Hawaii, Amenities on-site include two outdoor swimming pools, a children s pool, exercise facility, and two ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua-Kona
Please note, some holiday weeks require a seven night stay, please confirm with agent. Prime weeks and holiday weeks have higher rates, your agent will send you an initial quote based on the dates you have chosen.
DASH REALTY GROUP, INC is ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua-Kona
ONLY AVAILABLE OCTOBER 2nd-9th, 2022
Luxury Wyndham Kona Hawaiian Resort is an authentic resort designed in the style of an 1880's Hawaiian village. Palm thatched roofs and rustic bungalows dot the grounds and paths wind around flower and fruit...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua-Kona
The Wyndham Kona Hawaiian Resort is situated on more than thirty acres overlooking Kahului Bay in Kailua-Kona on the Big Island of Hawaii, Amenities on-site include two outdoor swimming pools, a children s pool, exercise facility, and two ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua-Kona