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 '%Kanaloa%') 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
Tropical decor, surfboard art and views flowing “fore-ever” make this 1,850sf suite a winner! Replay the day on the lanai with a Volcano Winery Blush and fresh catch prepped in the modern kitchen. Enjoy a washer/dryer, flat screen TVs, WiFi,...
- 2 bedroom
- 2 bathroom
- Sleeps 8
HI> KAILUA-KONA
Welcome to your tropical haven accommodating up to six! Perfect for families or for those looking for a little extra space to unwind after a fun day, you’ll love relaxing on the lanai with dining table, wet bar and mini-fridge. The luxe master...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> KAILUA-KONA
Just a stone's throw from Heeia Bay, this private and spacious condo offers the ideal oceanfront setting for your Kona Resort getaway. Complete with huge ocean views, lovely Hawaiian décor, central air conditioning, wireless internet, cable, ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua Kona
Hawaii STVR Registration Number: STVR-19-355146 OUR CONDO HAS BEEN COMPLETELY RENOVATED !! NEW DUAL AIR CONDITIONING SYSTEMS - - KEEPS CONDO COOLER THAN MOST OTHER UNITS IN RESORT
PREMIUM OCEAN VIEWS AND SPECTACULAR SUNSETS EVERY ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kailua Kona
Kanaloa #801 at Keauhou on the Big Island
Please scroll down for detailed information
***PLEASE NOTE: Due to current Covid 19 protocols there may be modified hours for Pool Services, Fitness Rooms or Community/BBQ Areas *** For stays at ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kailua-Kona
This stunning property is now accepting longer-term stays at reduced rates. Please inquire for details.
Enjoy the tastefully appointed look of Kanaloa at Kona, which features plush furnishings, vaulted wood beam ceilings, and island-inspired ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua Kona
Unit 1904 in Kanaloa at Kona is a top-floor, air-conditioned luxury condo located in Kanaloa at Kona. Spacious 3 Bedroom, 3 Bath Condo Fully equipped Gourmet Kitchen Cable TV in 2 Rooms Ceiling Fans Throughout (6) • Oceanfront Location• ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Kailua Kona
Prime fairway front location - great for bird watching or watching golfers along the 11th fairway of the Kona Country Club Ocean Course. Peaceful and spacious with lovely Hawaiian decor, this condo is the perfect escape for two couples or a ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua-Kona
OCEANFRONT CONDO - As Kona residents for 25 years, our desire is to share ALOHA. This is your opportunity to Experience Tropical Paradise, spectacular sunsets year-round, spouting whales in winter, and frolicking dolphins. This secluded and ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kailua-Kona
Unit 2003 in Kanaloa at Kona is a top-floor, air-conditioned luxury condo located in Kanaloa at Kona. Spacious 3 Bedroom, 2 Bath Condo Fully equipped Gourmet Kitchen Cable TV in 2 Rooms Ceiling Fans Throughout (4) [STVR-19-363811] • Oceanfront...
- 3 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua Kona
Kanaloa at Kona is an idyllic tropical oasis located on a point of land and surrounded by He'eia Bay, the Pacific Ocean and the Kona Country Club Ocean Course. It is rated by many as the 'BEST' complex in Kailua-Kona. With lighted tennis ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua-Kona
Kanaloa at Kona is a premier vacation condo location in Kona Hawaii. The complex is nestled into a residential neighborhood away from traffic and other condos or hotels. Kanaloa is exceptionally beautiful with abundant space and tropical ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kailua Kona
HI STVR Registration Number: STVR-19-355508 --- Book your rental car ASAP as rental car inventory is Low! --- Due to recent COVID public health concerns, 24 hours will be automatically scheduled between reservations to allow ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua Kona
(To watch a virtual photo tour; please go to the 3rd photograph and click on the video start arrow.)
Overview of Location
We would love to have you stay in our remodeled and redecorated condo at the beautiful Four-Star Kanaloa at Kona Resort....
- 1 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua-Kona
