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 '%kauai%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Discover the ultimate Kauai getaway at Ka Pua Hale, our vacation rental also known as "Blossom House." Nestled strategically in Princeville, Kauai, our rental provides unmatched convenience:
- Close proximity to North Shore beaches, golf ...
- 4 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Paradise Found..! Surrounded by Lush Tropical Landscape ~ This Spacious 2 Bedroom 2 Bathroom, Ground Level Condo, Opens Up to a Sprawling Green Courtyard with a Partial & Distant Ocean View
Beautiful & Newly Decorated with High End ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
Located on a picturesque lava bluff, our top floor condo offers privacy, cooling trade winds and panoramic ocean vistas which a camera can't begin to capture.
Crashing waves, migrating whales and sunrise/sunset views are what you'll see as...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Koloa
Tucked into the Lanai Villas section of the tropical Poipu Kai Resort, Maikalani is a Kauai vacation rental home exquisitely decorated and outfitted with all the necessities of home, including zoned air conditioning. Located on the lush green ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
One of the best locations in sunny Poipu Beach Kauai, Nihi Kai Villas Resort is just steps away from the Poipu shoreline and a little over 300 yards to world-famous body surfing Brennecke’s Beach and Poipu Beach Park. The plantation style ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
An oceanfront Kauai resort in Poipu Beach featuring spacious Kauai condos and spectacular sunset views. With its classic Hawaii plantation style architecture and design, complemented by a wonderful pool and guest amenities, this is a sought ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
Located in the quaint and historic beach community of Hanalei Bay, this comfortable Kauai vacation home offers its guests a spacious and relaxing place to settle in and enjoy beach life. Hale O’Kale is walking distance to all of Hanalei town ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Hanalei
Unit #324 is third floor (Top Floor) DIRECT oceanfront and is in a perfect location in the complex. It has panoramic ocean views of the stunning Pacific Ocean. Being that it is on the top floor, you have the great views and optimal privacy. ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapaa
Castle Kaha Lani Resort #102 - Energy flows from the tropical decor living area onto the lanai and across expansive lawns of this 739 sq. ft. ground floor villa with beautiful ocean view. Dine in with meals prepped in the full kitchen. Other ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> LIHUE
WHY STAY HERE
Kauai Coast Resort at the Beachboy is the perfect beachfront location in Kapaa next to the Coconut Marketplace. The spacious suites are decorated to let the Hawaiian culture be seen throughout the resort. Filled with ...
- 2 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Kappa
Enjoy the best of island life at one of Poipu’s finest Kauai oceanfront rentals. The 2 bedroom, 2 bathroom coastline gem is in a prime location for family or friends who love to live by the water. Its design takes full advantage of the million...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
The Kauai Coast is a beautiful Shell Vacations/ Wyndham Resort located near the Coconut Marketplace in the centrally located town of Kapaa, Kauai. This beautiful resort offers beach access and features a full kitchen, with living room/dining ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
This extraordinary 4 bedroom, 4 bathroom luxury home is one of the finest Kauai oceanfront rentals on the island. The grand entrance opens to expansive cathedral ceilings showcasing the magnificent oceanfront living areas surrounded by tropical ...
- 4 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Koloa
Amazing Kauai oceanfront rentals from Parrish Kauai feature this beautiful home at sunny Poipu Beach. Highlights include Hawaii plantation style design and décor and all the must have comforts, including spectacular ocean views from almost ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
Hawaii> Koloa
Enjoy the luxury and comfort of our newest Elite home centrally located in Poipu Beach Estates. This custom home takes full advantage of many views and is also positioned to enjoy the fabulous trade wind breezes. The spacious and open great room...
- 5 bedroom
- 5 bathroom
- Sleeps 10
Hawaii> Poipu
New home construction next door started in Jan 2022
This luxury Kauai vacation rental is located in the luxury resort community of Kukuiula. This fabulous new home has lovely distant ocean views from both the main living area and the ...
- 4 bedroom
- 5 bathroom
- Sleeps 10
Hawaii> Koloa
An architectural masterpiece, Hale Makai is a one-of-a-kind oceanfront Kauai oceanfront rentals that offers its guests a distinguished Kauai vacation rental. This magnificent Poipu Beach residence boasts an oceanfront master bedroom suite with ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Koloa
One of the island’s finest Kauai oceanfront rentals set on the dramatic Poipu Beach coastline. Remodeled to perfection, this home has ocean and coastline views from almost every room and offers the perfect setting for the vacation of a ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Koloa
Welcome to Hale Kokio, a well loved getaway, designed for two. This is the place to stay on North Shore Kauai for relaxation, privacy and island living. Enjoy a quiet setting and a convenient location. The newly updated cottage is designed with...
- 2 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kilauea
This premium Sealodge vacation rental has one of the most spectacular views in all of Princeville, Kauai! It is perched on an oceanfront cliff with expansive views of the Pacific Ocean, Kauai north shore coastline, Anini reef and Kilauea ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville
RiverSong is nestled in two tropical acres alongside Kilauea River. The river sings below and waterfalls splash beneath your private, secluded lanai. Our gardens abound with color from red ginger, gardenia, orange and yellow heliconia, purple ...
- 2 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kilauea
Marriott Kauai Beach Club1 Bedroom Unit Sleeps 4
**Photos are stock images of the resort and do not guarantee the view type shown"
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” FEATURE***
...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lihue
Hale Kanani is NEWLY renovated inside and out! With fresh paint, brand new cabinetry, vanities, quartz countertops and flooring throughout, as well as a new high-performance washer and dryer, on-demand water heater and dishwasher, this ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Hanalei
Welcome to Leilani Villa, a stunning 3-bedroom, 2.5-bathroom vacation rental ideally situated in Princeville on the north shore of Kauai. This villa provides convenient access to some of the most beautiful beaches on the island, including ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Discover the ultimate beachside oasis with this exquisite end unit boasting breathtaking ocean views from every angle. Step onto not one, but two expansive decks - perfect for soaking up the sun while grilling your favorite dishes or unwinding ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
**THIS RENTAL IS EXCLUSIVE TO VRBO - DO NOT RENT OFF CRAIG'S LIST OR ANY OTHER WEB SITE**
If you are looking for the ultimate Kauai experience, then look no further! Located on the North Shore, the most desirable area of Kauai, known for...
- 2 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kilauea
Ocean Front, breathtaking views from every room. Our two bedroom, two bath, well equipped condo sits on the bluff of Kauai's beautiful North Shore. Completely remodeled from floor to ceiling. Ground level entry, no stairs. Pool & BBQ on site....
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Beautiful Princeville Pali Ke Kua condo perched on a cliff overlooking Bali Hai, with unobstructed views of the ocean, sunsets, waterfalls, and rainbows. Turtles can be seen swimming in the cove below. December through April whales can be seen ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
Located 35 feet from the surf, my Poipu condo is one of the best places to stay on the Island of Kauai. It has the best close up ocean views on the entire Island. Miles of beautiful coastline, crashing waves, breaching whales, sea turtles, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
Hale Huna ('Hidden House') is a wonderful cottage on a hillside near the end of the road on the North Shore of Kauai. Located on hill and a quiet cul-de-sac with only a few other local houses. Very private and peaceful (It is NOT on/near the ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Hanalei
This handsomely designed and decorated Kauai cottage offers the details of early plantation days yet with the modern conveniences of central air conditioning, as well as everything else one needs to indulge themselves on a luxury Kauai vacation....
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Koloa
Concierge Realty is proud to present luxury villas at Marriott's Kauai Lagoons!
** Reservations are available in weekly (7 night) increments with arrivals and departures on Fridays, Saturdays, and Sundays only.
** All bookings are ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lihue-Kauai
The best views on the Island! Your own private lanai that looks onto the beautiful Bali Hai peninsula and Hanalei bay. Fully refurbished and equipped 2 bedroom condo, each room has it's own bathroom, plus large living, dining, kitchen area. ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Princeville
This listing is for a studio suite. A studio comes with a Murphy wall bed with a real mattress and a kitchenette. Marriotts owners calendar does not sync with VRBO. Please click on ask owner a question button before pressing book it now. ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lihue
Prep farmer’s market fare in the full kitchen to share on the private lanai unfolding to gorgeous plumeria, bougainvillea and hibiscus. Then explore your lush surroundings. This 690sf home away from home appeals with WiFi, flat screens, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> KOLOA
Hale Honu is a beautiful, new island-style luxury condo in Poipu's Pili Mai condominium complex on Kauai's South Shore. Offering extensive amenities on site including AC and pool, and just minutes away from Poipu Beach, shopping, fine dining, ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Koloa
The Kauai Beach Club resort features an array of amazing on-site amenities such as a 26,000 square-foot pool rimmed with colonnades and waterfalls, a children's pool, spa, fitness center, and two 18-hole championship golf courses designed by ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lihue
Whether you are coming to Kauai to golf, surf, snorkel, the beaches, Hawai'iana, or just relaxing, you'll not find a better place at this price (Standard Occupancy is 2*). Perfect for two, Hoku Lani, is located close to the entrance of ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Princeville
Hawaiian Island Beachfront cottage with an incredible location on the North Shore of Kauai in between Hanalei and Haena close to Tunnels. The 3/4 acre property features a large sandy beach point. Some of the islands best snorkeling and shelling ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Hanalei
TVNC-1238
A classic Hawaiian style home, this Haena beach house, known as Hale Pulelehu'a (The Butterfly House), is a wonderful place for your family & friends to experience the island lifestyle on the North Shore of Kauai. Immaculately cared...
- 5 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Hanalei
Enjoy spectacular ocean views in one of Koloa’s most sought-after oceanfront condominiums. This south and west facing 2-bedroom, 2-bath corner condo has a unique view of Kauai's unsurpassed sunsets. Floor to ceiling windows, an elevated ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Located across from Hanalei Bay, is the magical Kauikeolani Estate. Mature gardens, expansive lawns, and an ancient Hawaiian fishpond are just a taste of the treasures which awaits you! The home is on the National Register of Historic Places. ...
- 6 bedroom
- 6 bathroom
- Sleeps 12
Hawaii> Hanalei
This Kaua’i Marriott Resort on Kalapaki Beach is known for its warm island hospitality and idyllic location on the Garden Isle. It underwent a $50 million upgrade, with major enhancements to all of the guest rooms, suites, restaurants and pool...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lihue
PROPERTY OVERVIEW:
House, 2 Bedrooms, 1.25 Baths, (Sleeps 4)
The Nene Nest, Kauai is a classic, sugar plantation- style cottage located on the always sunny West Side of Kauai. Just 152 steps from the ocean, it offers a true ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kekaha
Please Send An Inquiry Before Requesting To Book By Clicking The Contact Host Tab.
This resort is a tropical haven that overlooks the stunning Hanalei Bay on the north shore of the “garden island,” Kauai. Vacationers are humbled by ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Spacious 4-bedroom, 3.5-bathroom condo features two master bedrooms with En Suite bathrooms, upgraded amenities such as A/C, Marbau flooring, granite countertops and Bosch appliances, a washer, dryer and much more!
The sparkling new Pili ...
- 4 bedroom
- 4 bathroom
- Sleeps 10
Hawaii> Koloa
The Villas at Poipu Kai are one of the newer luxury condominium resorts on the South side of Kauai in Poipu. These spacious and upscale condominiums are part of the Poipu Kai Resort that offers access to additional recreational amenities to all ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Koloa
**Please read 'Other Things to Note' in listing** Capture the tranquility and beauty of the Garden Isle from this charming, centrally located condotel unit at the Kauai Beach Resort. From your private lanai, take in Kauai's lush landscape and ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lihue
Renovated and expanded in July 2011 to include 7 bedrooms! Hanalei's classic property sits on over one acre of land. The largest oceanfront rental property in Hanalei Bay!
The residence and guesthouse have been upgraded throughout. New...
- 7 bedroom
- 7 bathroom
- Sleeps 10
Hawaii> Hanalei
Enjoy an amazing 180-degree view of the ocean overlooking Wailua Bay, a wonderful sandy beach and beautiful green mountains in the background. Your stay here puts you just steps away from the water and on one of the few swimmable beaches on the ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
