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, rewritten_description,
(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 your family’s ideal getaway in the heart of Princeville at Hanalei, Kauai! Our spacious vacation rental offers a tranquil oasis surrounded by lush landscapes and tranquil gardens. Designed for relaxation and connection, this private
- 4 bedroom
- 3 bathroom
- Sleeps 6
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
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
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
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
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
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
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 gorgeous property is a favorite vacation spot for well-known actors, musicians, athletes, artists, doctors and entrepreneurs. We have many repeat visitors who feel that our house is their second home.
Rising from the Pacific,
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Haena-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
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
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
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
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
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
Hale Hiwa Hiwa or our "Beloved Home" at Wainani is the perfect place to spend a relaxing and pampered vacation on Kauai. Located in a cul-de-sac on Kiahuna Plantation Drive you are centrally located in Poipu and close to shopping, dining and
- 3 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Koloa
Discover the perfect Garden Island retreat at Kilohana Makai, Hawaiian for “Unsurpassed Excellence near the Ocean.” This four-bedroom, three-and-a-half-bath villa truly lives up to its name, offering a picture-perfect tropical family retreat
- 4 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Koloa
ALOHA! This 1st floor, updated unit has a private lanai to enjoy spectacular ocean views, stunning sunrises or perhaps an evening moonrise, if the time is right! This place has it all! The pool is just 20-feet from the lanai, and world-famous
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapa?a
Enjoy a relaxing and fun filled vacation in one of the newest homes in the centrally located Poipu Beach Estates neighborhood. This five bedroom residence consists of a three bedroom main home and a private two bedroom Ohana located above the
- 5 bedroom
- 5 bathroom
- Sleeps 11
Hawaii> Koloa
Sugar Mill Cottage is located in the heart of the Poipu Kai Resort community. It is the perfect location for beach access to either Shipwrecks beach or Poipu Beach park. A short stroll in either direction will take you to sun and
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
COMPLETELY REMODELED AND NEWLY INSTALLED SPLIT SYSTEM AC!! Come and enjoy this beautiful condo with unparalleled view of the Wailua Bay and Pacific. One our most requested condos. Very tastefully decorated and updated (just remodeled spring
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapa?a
There is not a Four Seasons Resort on Kauai, so we decided to make our own. Kiahuna Plantation #198 is one of the very few beachfront condominiums available on the island and is the ideal vacation destination for a couple or a family looking for
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Koloa
E Komo Mai, Welcome to “Plantation House In Poipu Beach Estates”
Luxury Hawaiian living at its best! Enjoy cooking in a fully equipped gourmet kitchen with an open dining and living floor plan. This new and modern vacation home is
- 3 bedroom
- 4 bathroom
- Sleeps 6
Hawaii> Koloa
E Komo Mai, Welcome to Mala Pua Regency 610!
A 2-bd/2-ba ground floor condo in the heart of beautiful sunny Poipu offers the perfect home away from home. Enjoy open living space with two sofas, TV entertainment center, and a
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
Settle into a blissful sense of calm at Hale Anuenue, which means “House of the Rainbow” in Hawaiian. This three-bedroom, three-and-a-half-bath villa features beautifully appointed interiors featuring contemporary coastal décor and
- 4 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Koloa
This quintessential tropical beachfront home with 4 bedrooms and 4 baths with air conditioning throughout is surrounded by lush tropical foliage and swaying palm trees is located on one of Kauai's most beautiful beaches. The expansive stretch
- 4 bedroom
- 4 bathroom
- Sleeps 12
Hawaii> Anahola
