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 (registration_number like 'TA-%') AND (`headline` like '%lanikai%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Nestled in the highly sought after wonderful Lanikai community, this beautiful executive home was newly built in 2014. This home is a perfect vantage point.
It boasts 3 bedrooms en suite that are generous in size and more than ample in comfort.... Registration Number: TA-209-884-5696-01, GE-20
3 bedroom
4 bathroom
Sleeps 8
HI> Kailua
Welcome to Lanikai Hale ~ Two Hawaiian style cottages on a large fenced-in property in the heart of Lanikai, just 2 miles from Kailua Town on the Windward side of Oahu.
There is plenty of parking and sleeping space for a group of 10 to 12 ... Registration Number: TA-107-927-8080-01, GE-10
5 bedroom
3 bathroom
Sleeps 12
HI> Kailua
*Our calendar may not reflect our current availability. Please feel free to reach out with any questions regarding quotes for our monthly rates and fees.
Oceanfront and private with unbeatable sunrises and sunsets overlooking the ocean and ... Registration Number: TA-183-951-1552-01, GE-18
2 bedroom
1 bathroom
Sleeps 4
HI> Kailua
Lovely quiet private studio with gorgeous ocean views from either common deck or your private deck as well as through studio main door. NEW: AC unit for warm nights (although overhead fan is usually all that is needed). Outdoor kitchenette is ... Registration Number: TA-080-695-9616-01, GE-08
1 bedroom
1 bathroom
Sleeps 2
HI> Kailua
Enjoy a restful respite in this private cozy cottage with a beautiful private garden. The Lanikai Bungalow is a private separate cottage. It has one bedroom with beautiful relaxing living spaces, full kitchen and bathroom. The cottage has a ... Registration Number: TA-123-128-4224-01, 43004
1 bedroom
1 bathroom
Sleeps 2
HI> Kailua
This beautifully remodeled one-bedroom one-bathroom unit is the perfect retreat for a Big Island vacation. Enjoy breathtaking views from the spacious lanai, while luxuriating in the comforts of this charming retreat.
A remodeled kitchen and ... Registration Number: TA-186-850-7136-01
1 bedroom
1 bathroom
Sleeps 4
HI> Kailua Kona
TA-035-471-3600-01/License No. 90/BB-0018. Lanikai means "heavenly water" . Just cross the street to one of best beaches in the world. Its sister beach, Kailua Beach, has been called the best beach in the US. Come relax in our spacious suite ... Registration Number: TA-035-471-3600-01, 90/BB
0 bedroom
1 bathroom
Sleeps 3
HI> Kailua
TA-035-471-3600-01/License No. 90/BB-0018. Lanikai means "heavenly water" . Just cross the street to one of best beaches in the world! Kailua Beach, best beach in the U.S. per Dr. Beach is 5 mins. walk. Come relax in our spacious guest suite ... Registration Number: TA-035-471-3600-01, 90/BB
1 bedroom
1 bathroom
Sleeps 3
HI> Kailua
Disclosure: During December 2021 and January 2022 guests stay may be impacted by beach rehabilitate work. Dates and times are to be determined
Looking for the perfect Kauai beach house rental? Explore Niulani Lanikai, a Kapa’a vacation rental... Registration Number: TA-144-331-6736-01
4 bedroom
4 bathroom
Sleeps 10
HI> Kapaa
Charming Cottage in beautiful Lanikai that has been totally renovated in 2021. Everything in the Cottage is new including the furnishings! Short walk to the beach. Enjoy the comforts of home with an efficient kitchen and own washer and dryer. ... Registration Number: TA-006-174-7200-01, GE-00
1 bedroom
1 bathroom
Sleeps 4
HI> Kailua
Minimum 30 day rental, this 3 bedroom, 3 bath with a private pool is the perfect location to relax and unwind. The entire property is surrounded by lush landscaping, beautiful palm trees and tropical flowers. The spacious yard is perfect for sun... Registration Number: TA-019-850-2400-01, GE-01
3 bedroom
3 bathroom
Sleeps 6
HI> Kailua
Lush tropical gardens make this private home into a quiet, comfortable retreat. Large enough for six adults, plus a couple of keiki (children), this home was designed by the late Vladimir Ossipoff, award-winning Hawaii architect. Mr. Ossipoff's ... Registration Number: TA-119-399-0144-01, GE-11
3 bedroom
2 bathroom
Sleeps 8
HI> Kailua
This beautifully updated 4 Bedroom, 3 bath private home in a Residential neighborhood is situated just steps from the ocean with beautiful views of the mountains. Available for those looking for a quiet stay near the beach. Beach access across ... Registration Number: TA-047-073-2800-01, GE-04
4 bedroom
3 bathroom
Sleeps 9
HI> Kailua
If you are looking for a great location close to the beach, love watching sunrises and moonrise, like spending time outdoors and on the water, and want to save money by making your own meals, this place is for you.
Relax in a large one bedroom ... Registration Number: TA-193-827-4304-02, 43007
1 bedroom
1 bathroom
Sleeps 2
HI> Kailua
