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 '%Alii Kai%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Open the door Hali'i Kai15B and feel the Aloha greeting of the crashing blue waves! Relax in the serenity of your luxury retreat-the private lanai is on the water's edge-perfect for alfresco dining and the most perfect view of Hawaiian ...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Waikoloa Village
Sit back, relax and enjoy the best view of the Waikoloa Beach Resort! The view from this villa is nothing short of breathtaking. From this villa you overlook the signature hole of the golf course and onto the blue waters of the Pacific Ocean. ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa
Island touches shine in this upscale two bedroom villa with its lanai, gourmet kitchen and comfy living area. Enjoy homey comforts like a laundry room, stylish master bedroom and bathroom, high-speed Internet and ceiling fans. Amid 29-acres ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> WAIKOLOA
Welcome to our bright and beautiful condo, ideally situated near the front of the complex—just steps away from the beach! Thoughtfully upgraded with new furniture in Summer 2022, this is the only condo we own, and we’ve equipped it with all...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Able to comfortably sleep up to 6, in one king and two twin beds, the unit is tastefully designed with earthy, stained-wood accents to exude vintage island charm. All rooms offer cozy furnishings and boast soft lighting with air-conditioning and...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> WAIKOLOA
Ground Unit #9B Oceanview condo in Halii Kai, famed newer development near Waikoloa Hilton and Mauna Lani beach homes. Halii Kai has an incredible salt water pool, spa covered workout room, poolside restaurant/bar right on ocean front. The ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa
È Komo Mai! We are pleased to welcome and invite you to stay in our oceanfront villa in Waikoloa Beach Resort on the Big Island. You will feel relaxed and inspired in our Hawaiian island retreat. Hali’i Kai is the only true oceanfront ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa
This vacation rental is professionally managed by ResorticaHawaii
Halii Kai 13A. Includes Waikoloa Gold Golf Membership Discounts
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Waikoloa Beach Resort
Blissful island living defines this air-conditioned 1,082sf suite with Pacific view from the ground floor lanai. You’ll love the tropical decor, open-style gourmet kitchen for meal ease, washer/dryer, ceiling fans, WiFi, flat screens and roomy...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> WAIKOLOA
Summary:
Unit D-205. Located across the street from the kamaole beach park. This property has all new furnishings and king size bed. Air conditioning, 65 in tv, full queen mattress wall bed as well as two twin sofa sleepers,, full kitchen ...
- 3 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
This vacation rental is professionally managed by ResorticaHawaii
Halii Kai 10G. Ocean Views!
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: Queen Bed
Guest ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
PROPERTY SUMMARY:
Serene and modern, this spacious 2 bedroom - 2 bath fully remodeled condo is conveniently located steps from an amazing selection of casual restaurants, fine dining, shopping and beach rentals, and all this directly across ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Aloha and Welcome! We are pleased to invite you to stay in our well-maintained, newly furnished villa in Waikoloa Beach Resort on the West Coast of the Big Island. This corner, ground floor unit comfortably sleeps up to 6 people with 3 bedrooms,...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa
The Halii Kai 12B villa located in the Waikoloa Beach Resort is nothing short of spectacular. It has a stunning ocean view across the signature hole of the Waikoloa Beach Golf Course. The lanai is the perfect place to watch the sunset after a ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa
Style, space and homey perks wow in this 1,930 sq ft island-chic home with master bed/bath combo, laundry room and open gourmet kitchen to prep meals for sharing on the ground floor lanai. Enjoy air conditioning, ceiling fans, HD (high ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> WAIKOLOA
The Princeville Resort is located on the beautiful north shore of Garden Island of Kauai. Surrounded by incredible beauty are the perfect backdrop for world-class golf with outstanding views and challenging play, sightseeing, and all outdoor ...
- 3 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
Hali’i Kai oceanfront homes are located on the Kohala Coast of Hawaii’s Big Island, approximately 18 miles from the Keahole Kona International Airport. Birthplace of the great King Kamehameha I, tales of the favored status of this stretch of...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Waikoloa Village
Luxury Hali’i Kai oceanfront homes are located on the Kohala Coast of Hawaii’s Big Island, approximately 18 miles from the Keahole Kona International Airport. Birthplace of the great King Kamehameha I, tales of the favored status of this ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Waikoloa Village
This vacation rental is professionally managed by ResorticaHawaii
Halii Kai 13E. Ocean Front With Stunning Views!
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: ...
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Waikoloa Village
This vacation rental is professionally managed by ResorticaHawaii
Halii Kai 14B. Ocean Front With Stunning Views!
Please scroll down for detailed information
Waikoloa Beach Resort Gold Membership Golf benefits (discounted tee ...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Waikoloa Village
Hali'i Kai is one of the most sought out places to stay while visiting the Kohala Coast on Big Island. It features meticulous well kept grounds, beautiful and comfortable living spaces along with a luxurious amenity center, the Ocean Club. The ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waikoloa
Relax at our Whispering Palms ...home away from home. This is a spacious ground floor furnished 2 bed, 2 bath condo with two king beds sleeps 4 comfortably and can add a full sleeper sofa to comfortably sleep a total of 6 guests, per guest ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
This vacation rental is professionally managed by ResorticaHawaii
Halii Kai 15H
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: Queen Bed
Guest Bedroom: 2 ...
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Waikoloa Beach Resort
Halii Kai 18E
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
The best of island living awaits at this upscale three-bedroom, two-bath Halii ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kamuela
Welcome to Alii Kai 7201 by Gather, a serene Princeville retreat for four, featuring breathtaking ocean views and lush amenities for an unparalleled island experience.
Nestled on the bluffs of Princeville, Alii Kai 7201 opens its doors to...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
Prepare to shaka in this air-conditioned villa saluting surf through art and attitude! Prep meals and snacks in the gourmet kitchen to enjoy on the lanai. Then retreat to themed-motif bedrooms. Touches include a laundry room and master bath with...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> WAIKOLOA
This vacation rental is professionally managed by ResorticaHawaii
PLEASE NOTE: Halii Kai 8D is currently listed for sale. Real Estate Showings will not be scheduled during guest stays. Please reach out with any questions.
Halii ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Village
Say aloha to this island-style home away from home with tropical-inspired bedrooms, luxe master bath, gourmet kitchen, open living area and lanai. You’ll love the convenient dishwasher, air conditioning, ceiling fans, laundry room and ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> WAIKOLOA
Aloha to Hali'i Kai at the Waikoloa Beach Resort. Discover the captivating allure and serenity of the sunny Kohala Coast on the magnificent Big Island. Embrace the renowned Waikoloa Resort as you embark on a journey to Kamako Iki at Hali’i ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa Village
Indulge in a premium golf experience with our exclusive GOLD GOLF KINGS' CLUB membership, offering discounted rates and access to one of Big Island's top resorts.
Waikoloa 2B condo features a spacious private master bedroom with an ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa,
Welcome to Alii Kai II 12D, your ideal Kauai vacation condo located in Princeville on the stunning North Shore of Kauai. Enjoy beautiful mountan views and sunsets from your Kauai condo facing the "Bali Hai" Na Pali mountain range.
Condo ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Kihei Alii Kai #B-307 is a 1 bedroom, 1 bath ocean view unit on the 3rd floor. It has a fully-equipped kitchen, washer & dryer, dishwasher, 55 in. flat-screen TV in the living room with DVD, and free wireless Internet. Stay cool during the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Slip into island mode within this air-conditioned retreat with three-seat recliner sofa, open gourmet kitchen with dishwasher, lanai with gas grill and sleigh frame in the tropical master bedroom. Other amenities include high-speed Internet, ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> WAIKOLOA
We are blessed with our 2021 renovated, beautiful ocean view, building 7 Alii Kai condo. We are willing to share it with clean, conscientious vacationers.
This is an ideal place to stay for exploring the abundance of year-round activities ...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Princeville
This vacation rental is professionally managed by ResorticaHawaii
Halii Kai 24H. Stunning 3 bedrooms. Ocean Front Pool Club
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest ...
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Waikoloa Village
Welcome to Maui and our beautifully tropical décor 1 bedroom, 3rd floor condo – C307 in Kihei Alii Kai. We are in the upper building on the "quiet side of the complex", close to the parking lot and elevator access. The grounds are beautiful...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Kihei Alii Kai #A-305 is a 700 sqft. one bedroom / one bath unit with a tropical garden view. The unit is equipped with a full kitchen, washer/dryer, and complimentary Wi-Fi service. Stay cool in the summers with the dual-zone split system air ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Your presence is not only appreciated but also essential in helping our local economy and our beloved island to recover. Lahaina is the only area that is not open to the public at this time. ****
Aloha from Midway Vacations! Our team of ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Take advantage of this spectacular panoramic oceanfront view of the coastline when you book this vacation rental condo. Experience a real treat when you book between mid-December through early May and get a chance to see the friendly whales ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa
open gourmet kitchen. Bedrooms feature tropical accents, while the master bath pampers with glass-wall shower and separate tub. A laundry room with beach gear adds appeal. Amid 29-acres stretching along Waikoloa’s Beach Course and the Pacific,...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> WAIKOLOA
Ocean Views of Kamaole Beach Park from this spacious lanai! Perfect for your morning coffee and the newspaper or an afternoon relaxer watching sunset. Great location in the Kihei "Super Block" close to shopping, dining and Kamaole Beach Park ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
This vacation rental is professionally managed by ResorticaHawaii
Halii Kai 22H. Three Bedroom. Includes Beach Gear. Ocean Front Pool Club
Please scroll down for detailed information
Please note: There is a mandatory $25 per ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Village
Trans Tax ID TA207913062401 General excise tax GE207913062401 TMK 4-5-4-5-16-56 This peaceful second floor condo overlooks the beautiful blue seas of Kauai’s North Shore. Located in Princeville; it’s just minutes from shopping and the ...
- 3 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
This elegantly-designed, air-conditioned villa offers a lanai with ocean views, gourmet kitchen and sleeping bliss in three bedrooms with flat screens. The master bath appeals with double sink vanity and walk-in shower. Also enjoy high-speed ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> WAIKOLOA
Book with us and come to Maui to explore everything we have to offer!
A fantastic 1 bedroom 1 bath air conditioned ground floor unit at Kihei Alii Kai with sleeper sofa in living room. Enjoy the relaxing sunny garden area and relax in ...
- 2 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Kihei
**Reach out for seasonal discounts/specials**
Aloha! Hali'i Kai is the only resort on the Kohala Gold Coast with a private ocean-view, 4-tier pool, sand-bottom hot tub, full bar and grill. This 2006-built complex has beautiful ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Village
Welcome to your island-style home away from home with tropical-inspired bedrooms, luxe master bath, gourmet kitchen, open living area and lanai with gas grill. You’ll love the convenient dishwasher, air conditioning, ceiling fans, laundry room...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> WAIKOLOA
This spacious vacation villa nestled in beautiful Waikoloa Resort on the sunny Kohala Coast is as spacious as it is stylish. Stylishly designed with contemporary furniture and décor, this relaxing villa is the perfect base for your Hawaii ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> WAIKOLOA
With gorgeous hardwood floors and Hawaiian artwork, this stylish villa pampers via private lanai and open gourmet kitchen with stainless steel appliances. The master bath offers double sink vanity, walk-in shower and separate tub. For added ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> WAIKOLOA
Slip into chic tropical style in this 1,082sf ground floor suite fringing the fairway. Enjoy “at home” dining ease with the modern kitchen and grill on the furnished lanai. Touches include cool tile floors, AC, ceiling fans, washer/dryer, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> WAIKOLOA
