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 '%Kanaloa%') AND sleeps>=1 order by rating desc LIMIT 0, 20
This luxury condo is as close to the beautiful blue waters of the Pacific Ocean as you can get at Kanaloa at Kona. Unit 1804 is a top-floor (second floor) oceanfront condo with over 1700 square feet of living space with all the amenities of ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> 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
Hawaii> Kailua Kona
Kanaloa at Kona #2203: Inside, you’ll find a bright living area with generous seating and a large flat screen television, perfect for entertaining your friends and family! The suite’s full size galley kitchen has Koa wood cabinetry, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> 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
Hawaii> Kailua-Kona
Relax in luxurious comfort with spectacular sunsets from your private lanai only 20 yards from the surf and 20 yards from a world-class golf course. At night, be lulled to sleep with the gentle sounds of the waves against the lava rocks and feel...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> 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
Hawaii> Kailua Kona
Hale Honu is a luxurious and spacious one-bedroom condo with views of enchanting He'eia Bay and Pacific Ocean. Located in upscale Kanaola Resort, a private gated beautifully landscaped 17-acre community. Resort amenities include 3 pools, hot ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> 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
Hawaii> Kailua Kona
Excellent Ocean View Location
Central Air Conditioning (A/C)
Kitchen & Washer/Dryer
Spacious Waterfront Lanai
• Oceanfront Location• Sunset Views Year Round• Quiet, Residential Location• Walk to restaurants & stores• ...
- 3 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Kailua Kona
Excellent Ocean View Location
Central Air Conditioning (A/C)
Kitchen & Washer/Dryer
Spacious Waterfront Lanai
• Oceanfront Location• Sunset Views Year Round• Quiet, Residential Location• Walk to restaurants & stores• ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Kanaloa at Kona Condo 2204 is a dream! With breathtaking ocean views and luxurious amenities, this condo exceeds expectations. Guests love the well-appointed kitchen, comfy furnishings, and thoughtful extras like beach gear and toiletries. The ...
- 3 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Kailua Kona
Beautiful and Spacious Ocean View Condo:
Excellent Ocean View Location
Expansive & Private Fairway & Mountain Views
Central Air Conditioning (A/C)
Kitchen & Washer/Dryer
Two Spacious Lanais
• Oceanfront Location• ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Welcoming tropical breezes, the sound of ocean waves, glorious sunsets over the ocean, and the fragrance of exotic blossoms await you at Kanaloa 2104. Our condo is completely air conditioned! • Oceanfront Location• Sunset Views Year ...
- 1 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Kanaloa #303 at Keauhou on the Big Island
Please scroll down for detailed information
PLEASE NOTE: Kanaloa Complex will be replacing the asphalt in the parking lots and complex roadways from September 3-November 30, 2024. This is an ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Kanaloa at Kona by Outrigger is situated on 16 acres of a secluded oceanfront lava flow overlooking beautiful Keauhou bay. Kona sunsets are enjoyed right from your oceanfront coastline. Tropical gardens and lush flower filled landscape, embraces...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Kanaloa at Kona Condo 1602 offers an incredible stay with stunning ocean and golf course views. The condo is well-equipped with everything needed, from a fully stocked kitchen to beach gear like chairs, snorkels, and towels. Guests praise the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> 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 ...
- 1 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Unit 3104 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-363807] • Oceanfront...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Maximum occupancy strictly enforced in accordance with local ordinances.
Imagine having the privacy of your own little piece of paradise - that is exactly what you will find in this uniquely located condo. Situated at the end of the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
