select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) 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, 15
Kai Hale... TVNCU #1381
Beachfront at beautiful Anini Beach, this fabulous home is truly a paradise. Perfectly designed to take full advantage of its premier location, Kai Hale is surrounded by a lush, Hawaiian garden and meticulously manicured...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Kilauea
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
HI> Kilauea
Our Anini Beach rentals include this beach cottage that is located just across the road from Anini Beach with its two-mile stretch of soft white sand and the largest living coral reef on Kauai. This home is just steps away from the beach access...
- 3 bedroom
- 2 bathroom
- Sleeps 6
HI> Kilauea
*** COVID 19 UPDATE - please be sure to familiarize yourself with our state and county Covid 19 travel protocols BEFORE making a reservation. It is the travelers responsibility to meet requirements put forth by the State of Hawaii and County of...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kilauea
GE-033-843-7120-01
TA-033-843-7120-01
NEWLY REMODELED TOP TO BOTTOM -3 Primary Bedrooms, 3 1/2 Baths, Sofa Sleeper, Front Lanai, Back Screened Lanai, Fruit Grove, Ocean View
Anini Kai, is a luxury beach home located on the North Shore of Kaua'i...
- 3 bedroom
- 4 bathroom
- Sleeps 8
HI> Kilauea
*** COVID 19 UPDATE - please be sure to familiarize yourself with our state and county Covid 19 travel protocols BEFORE making a reservation. It is the travelers responsibility to meet requirements put forth by the State of Hawaii and County of...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Kilauea
COVID-19 UPDATE: HAWAII IS OPEN TO OUT-OF-STATE TRAVELERS. Please visit safetravelshawaii.com for specific requirements.
Experience spinner dolphins, sea turtles, hump-back whales (in winter), manta rays, amazing fish and coral reefs at ...
- 3 bedroom
- 2 bathroom
- Sleeps 7
HI> Capt.Cook
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
HI> Kilauea
We are pleased to welcome you to reserve your dates for your stay at Manini Point House in 2022! Check with Safe Travels to fill out a form regarding your current health as well as obtaining a QR card showing that you've been vaccinated to make ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
HI> 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. Sit in...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
Enhanced COVID cleaning and disinfecting procedures for every check-in.
Walk to beach, shopping, and dining from this updated and very spacious condo with pool and BBQ grill at Mauna Kai Princeville.
Mauna Kai is a charming townhome complex in...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
Blue Hawaii House
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Located on a quiet cul-de-sac, this magnificent, custom four-bedroom/four-bathroom home ...
- 4 bedroom
- 4 bathroom
- Sleeps 12
HI> Princeville
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
HI> Captain Cook
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 TVNC ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
HI> Anini Beach
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 to...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Anini
