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
Please be aware that an Asphalt Project will take place from October 7, 2024 to October 16, 2024. To account for any potential disruptions, we are offering a 10% discount on rates during this period.
Just a stone's throw from Heeia Bay, ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
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
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
Appreciate a modern, spacious and stylish experience at this one-bedroom, two-bath condo has a beautiful view overlooking He'eia Bay at Keauhou. The condo also has a Murphy Bed in the living room, providing additional sleeping opportunity for ...
- 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
Summary:
Kanaloa at Kona #201: Your Perfect Hawaiian Getaway
Discover the beauty of Kailua-Kona from the comfort of Kanaloa at Kona #201. This spacious 2-bedroom, 2-bathroom condo offers stunning views, modern amenities, and easy ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
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 ...
- 1 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 7
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
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
Hawaii> Kailua Kona
NEW Cleaning Procedures. We are supporting our guests and support staff by distancing bookings and sanitizing after every visit. We will do our best to work with you in the coming months and years to make your visit to Hawaii as comfortable ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
SPECTACULAR UNOBSTRUCTED OCEAN VIEWS OF KONA COASTLINE & AMAZING SUNSETS FROM YOUR PRIVATE LANAI!
Your vacation home features:
* 1500 luxurious square feet.
* Two spacious bedrooms with king beds.
* Two full bathrooms with en ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
