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 '%anini beach%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Book now and enjoy an incredible adventure on beautiful Hawaii Island!
Manini Point House is the perfect location for friends and family of all ages. Manini Point House is located in a village with folks from around the world. Guests to this ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
Hawaii> Captain Cook
Everything you might need to enjoy an exciting or relaxing vacation right by the ocean at the beautiful and world famous, "Kealakekua Bay'.
This private location is perfect for adventuring around our quaint neighborhood, with quiet walks, ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Captain Cook
Located on Kauai's verdant North Shore, Anini is a haven for the traveler who wants to experience the unspoiled natural beauty of Hawaii. Protected by a large outer reef, the quiet waters of Anini are perfect for swimming, snorkeling, fishing, ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kilauea
Retreat from the cares of the world in this tastefully furnished, one-bedroom, one-bath, oceanfront home.
TVR #5082
Punana Aloha, which means 'Love Nest' in Hawaiian, is a one-bedroom, one-bath hideaway on incomparable Anini ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kilauea
Spacious 4,386 sq ft home with floor to ceiling glass, beautifully appointed with impeccable finishes, providing unrestricted ocean views, and capturing Kauai’s famous trade winds, this home is the perfect luxury vacation home that you've been...
- 4 bedroom
- 5 bathroom
- Sleeps 8
Hawaii> Princeville
With a spectacular oceanfront setting, this airy modern home lets you take full advantage of one of Kauai’s most beautiful beaches. Just steps from the door, the calm turquoise waters of Anini Beach offer year-round snorkeling and ...
- 4 bedroom
- 5 bathroom
- Sleeps 8
Hawaii> Kilauea
Impeccably Renovated Anini Beach Retreat: Complete with 3 Ensuite Bedrooms, 3.5 Baths, Sleeper Sofa, Front Lanai, Spacious Screened Back Lanai, Serene Fruit Grove, Ocean View from Master Suite. and only steps to the serene waters edge of Anini ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
Hawaii> Kilauea
Paradise at Princeville
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Perched in the beautiful community of Princeville, this bright and ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Mana Kauai Island Vacations has just taken back management of the Anini Reef Cottage! Please reach out for special rates through the end of 2024! Step back in time to the early charm of old Kauai at the Anini Reef Cottage. Slow down, unplug, and...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kilauea
A stylish reimagining of our ever-popular Coconut Hut. This perfectly positioned gem sits in a secluded park-like paradise within a 5-minute walk to the idyllic Anini beach. With new construction, the house contains hardwood floors, whole house ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kilauea
Beautiful private home located on Kauai’s majestic north shore, with gorgeous mountain views, and just a 1 minute walk to 'Anini Beach. Perfect location for snorkeling, paddle boarding, kayaking, swimming, and lounging! Just a 10 minute drive ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Anini
Enjoy an easy short stroll to world famous Anini Beach in a delightful two bedroom small cottage-like house on a newly expanded open lot. One king and one queen, each with its own private bathroom. Amenities include full kitchen, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kilauea
NEWLY RENOVATED!!!!! You'll be mesmerized by the sparkling water and soft sand beach just outside your door when you stay at the Anini Beach House. This vacation property is a stunning, contemporary and very private beachfront estate ...
- 5 bedroom
- 5 bathroom
- Sleeps 12
Hawaii> Kilauea
View House Tower
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
With incredible views that reach the ocean, pool, and Kauai's famous green ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Kai Malie TVNCU#4217
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
**Please note this Vacation Home is located in the tsunami evacuation ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kilauea
Just steps from the sand on Anini Beach, this spacious 3 bedroom home was JUST remodeled! With luxury furnishings and a gorgeous kitchen that will make even chef's mouths drop, this home is a true oasis on Anini Beach. Located near the end of ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kilauea
PLUMERIA
Plumeria is situated at beautiful Anini Beach, at 3585 Anini Road, 300 yards from the ocean, in an upscale yet relaxed residential area with the largest reef in the Hawaiian Islands. Our SPECIAL PERMIT NUMBER IS 2011-23 AND OUR ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Anini Beach
Kealakekua Bay (which means Pathway to the Gods) has one of the Big Island's most spectacular coral reefs. Because it is a Marine Life Sanctuary, the fish are plentiful and swarm over the well developed reef that slopes from the shores into the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Captain Cook
Enhanced COVID cleaning and disinfecting procedures for every check-in.
Completely remodeled with gorgeous upgraded kitchen and master bathroom, new flooring throughout, all new furnishings. You'll love the ocean view from Puamana 16B. ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Our Anini Beach rentals include this romantic home that fronts Anini Beach with its two-mile stretch of soft white sand and the largest living coral reef on Kauai. Near the end of the sandy road, finding a private spot on the sparsely populated ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kilauea
