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, 50
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 ...
- 3 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 ...
- 4 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 ...
- 2 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 has a one time $30.00 resort fee.
Bedroom Configuration:
Master Bedroom: King Bed
Guest Bedroom: Queen ...
- 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
(To watch a virtual photo tour; please go to the photo tour and look for the video start arrow on one of the photos.)
Overview of Location
We would love to have you stay in our remodeled and redecorated condo at the beautiful 18 ...
- 3 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
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
Please read NOTICE towards end of this description affecting November 18 - December 1, 2024.
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...
- 3 bedroom
- 2 bathroom
- Sleeps 6
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...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
This luxury condo is within a stone's throw of the beautiful blue waters of the Pacific Ocean. Unit 3001 is a first-floor ocean view condo with over 1400 square feet of living space with all the amenities of home. The views of the ocean and the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Please be aware that an Asphalt Project will take place from October 28, 2024, to November 11, 2024. To account for any potential disruptions, we are offering a 10% discount on rates during this period.
Spend your vacation at Hale Kalena ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Aloha and Welcome to Kanaloa at Kona, #3602. Turn moments into memories with your friends and family at this fantastic property. Enjoy an incredible ocean view at this 2-bedroom, 2-bathroom, high-speed internet, beach views, and ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
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
Enjoy your tranquil Hawaiian experience in this spacious 2 Bedroom/2 Bath End Unit. Located off the 11th Fairway with stunning garden views from our 2 lanais, our home sleeps 6 with a sleeper sofa in the living room. Envision yourself sipping a ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Unit 1901 in Kanaloa at Kona is a beautiful two-bedroom, two bathroom, groundfloor oceanfront condo with a fully equipped kitchen, TV in three rooms, ceiling fans throughout and air conditioning. • Oceanfront Location• Sunset Views Year ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
This condo is great for couples and families that want to Vacation by the Lovely Oceanfront Pool at Kanaloa:
Incredible Pool & Ocean Views
Large Oceanfront Lanai
Sunset Dining
• Oceanfront Location• Sunset Views Year ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Peek-a-Boo Ocean Views from Both rooms of the Condo
Covered Front and Back Lanais
Beautiful Teak Furniture, Window Coverings, & Linens
Beautiful Furniture, Window Coverings, & Linens
Cable TV in 2 Rooms
Ceiling Fans Throughout ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua Kona
The best located condos at Kanaloa include this top floor luxury condo.
Sunset Views Year Round
Directly Oceanfront
Top Floor
Arguably the Best Location in Kanaloa
Recent Kitchen Renovation
• Oceanfront Location• ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Castle Kanaloa at Kona Resort #2106 - 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> KAILUA-KONA
This luxury condo has the best of both world's with spectacular unobstructed views of the ocean to the mountains looking down the signature hole on Kona Country Club Golf Course to the ocean.
The view of the ocean is spectacular ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Kanaloa at Kona Condo 1803 is an exceptional oceanfront getaway with breathtaking views and luxurious amenities. Guests rave about the spacious, well-appointed interior, fully equipped kitchen, and ample beach gear. The lanai is perfect for ...
- 4 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Kailua Kona
Castle Kanaloa at Kona #3102 - It’s hard to top this 1,850sf ocean’s edge suite! Toast sunsets and crashing waves on the lanai. Family ease rolls out with a roomy living area, gourmet kitchen, washer/dryer, WiFi, DVD, flat screens, double ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> KAILUA-KONA
Maximum occupancy strictly enforced in accordance with local ordinances.
The Kanaloa at Kona, is an exclusive 5-Star oceanfront tropical gated resort, and is the premier vacation destination in Kailua-Kona on the Big Island of Hawaii. The...
- 2 bedroom
- 2 bathroom
- Sleeps 4
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
This vacation rental is professionally managed by ResorticaHawaii
Kanaloa #801 at Keauhou on the Big Island
Please scroll down for detailed information
****PLEASE NOTE: Kanaloa has a one time $30.00 resort ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Kanaloa at Kona Condo 703: Discover the ultimate getaway at our beautiful Kona condo! Immaculate accommodations, stunning décor, and convenient amenities, including 3 pools and a nearby grocery store. Guests rave about the comfort, cleanliness,...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Kanaloa at Kona 2906 is a luxury 1600 square foot oceanfront condo that is built on an ancient lava flow from the Hualalai shield volcano that last erupted over 200 years ago. It has a spectacular west-southwest ocean front facing view. ...
- 3 bedroom
- 3 bathroom
- Sleeps 5
Hawaii> Kailua Kona
SPECTACULAR UNOBSTRUCTED OCEAN & GOLF VIEWS FROM YOUR PRIVATE LANAI!
Your vacation home features:
1900 luxurious square feet.
Spectacular vaulted ceilings and koa wood details.
Two spacious bedrooms and additional loft ...
- 4 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Kailua Kona
Great ocean view location facing west-southwest with snorkeling and surfing. Hawaiian decor throughout, this condo is the perfect escape for a couple or a small family.
Check out this Beautiful New Listing (July 2013)
Western Facing ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Kanaloa at Kona is considered by many to be the nicest resort on the Kona Coast. It sits on an ancient Lava flow that juts out into the Ocean about 1/2 mile, thereby separating the resort from the noise and traffic of Alii Drive, with entrance ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Our unit 1002 at Kanaloa provides just the right blend of luxury and value, in an unsurpassed Hawaiian setting. This large (1500+ sq.ft.) and elegant condo is situated on the north edge of the Kanaloa complex, facing the Kona Country Club course...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Kanaloa at Kona condo 1801 offers the ultimate Hawaiian escape! Guests rave about the breathtaking ocean views, modern amenities, and exceptional comfort. This immaculate, well-furnished condo is equipped with everything you need, including ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Please be aware that an Asphalt Project will take place from September 3, 2024 to September 16, 2024. To account for any potential disruptions, we are offering a 10% discount on rates during this period.
This stunning property is now ...
- 3 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Kailua Kona
Welcome to your dream vacation at Kanaloa at Keauhou, Unit 2003! Nestled on the stunning Kona coast, this oceanfront, second-floor condo offers breathtaking views and the perfect blend of Hawaii and island charm.
Property ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Castle Kanaloa at Kona #901 - From the moment you step inside this two-bedroom two-bathroom unit you’ll feel at home. Enjoy a mix of island-style furnishings and contemporary touches that make this unit comfortable, casual, and stylish. Common...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> KAILUA-KONA
Castle Kanaloa at Kona Resort #3101 - The private atmosphere of the unit combined with modern coastal furniture will melt your stress away. The open design of the living area features plenty of comfortable seating for guests. Sit back, relax ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> KAILUA-KONA
Castle Kanaloa at Kona #1902 - This spectacular ocean front accommodation allows you to relax in splendor listening to the soothing sounds of the ocean where dolphins can be seen and whales too, when in season. Enjoy dreamy sunsets lounging on ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> KAILUA-KONA
Kanaloa at Kona unit #406: One look inside this massive two-bedroom/two-bathroom tropical-themed vacation retreat and you’ll see why it’s a favorite. This retreat has chic island décor with attractive furniture and modern touches that ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> KAILUA-KONA
