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, 30
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
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...
- 1 bedroom
- 2 bathroom
- Sleeps 6
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
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
Excellent Ocean Front Location
Central Air Conditioning (A/C)
Kitchen & Washer/Dryer
Spacious Ocean Front Lanai
• Oceanfront Location• Sunset Views Year Round• Quiet, Residential Location• Walk to restaurants & stores• ...
- 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
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
(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
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
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
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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Spend your vacation at Hale Kalena which means "House of rest" in Hawaiian. Kanaloa at Kona 701 by Gather is a 1,700 sq. ft. two-bedroom, two-bathroom vacation rental with garden views and is the ideal place to experience the beauty of ...
- 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 ...
- 2 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
A pristine, well-equipped condo overlooking a hidden cove. Swim, snorkel, see turtles, reef fish and if the surf’s up, grab a board and hang 10! From the lanai watch dolphins and whales frolicing. Lovely furnishings and tropical art ...
- 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 ...
- 2 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