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 (registration_number like '%TA-%' or registration_number like '%TA %') AND (city = '96734' OR postalCode = '96734' OR region like '%|96734|%') AND sleeps>=1 order by rating desc LIMIT 0, 30
Aloha, this unique Premier Partner property is exclusively available for rental for periods of thirty (30) days or more. Questions, please contact us for the dates you are interested in and we will respond wiki-wiki (fast !).Registration Number: 420480020000, TA-120-590-3360-01, GE-120-590-3360-01
1 bedroom
2 bathroom
Sleeps 4
Hawaii> Kailua
Calendar may not reflect accurate availability. Please contact owner with custom requests.Registration Number: TA-123-607-8592-01, GE-123-607-8592-01
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Kailua
Welcome to Walker's Lanikai Beach House. John Walker, was a Scotsman who made his way to Hawaii as a young man in the 1870's to become a contractor of choice to Queen Liliuokalani, and erect such notable buildings as the Bishop Museum and ... Registration Number: 430080930000, TA-043-470-0288-01, GE-043-470-0288-01
5 bedroom
4 bathroom
Sleeps 14
Hawaii> Kailua
Place in Paradise - Kailua offers casual oceanfront accommodations on one of the most beautiful beaches in Hawaii. Kailua Beach has been voted "Best Beach in the United States" by a variety of publications. Five bedrooms and five and half ... Registration Number: GE-060-877-8240-01, 430210250000, TA-060-877-8240-01
5 bedroom
6 bathroom
Sleeps 14
Hawaii> Kailua
This beautiful four bedroom (two luxury master suites, one guest suite and guest bedroom, all air conditioned), four bath Hawaiian style home is just a short walk to pristine Kailua Beach.Registration Number: TA-065-681-2032-01
4 bedroom
4 bathroom
Sleeps 8
Hawaii> Kailua
30 day minimum rental due to local laws. We are truly beachside with just two houses between the suite and the private beach gate. Namala Place is a wide street with sidewalks and plenty of parking. We are situated halfway between Kalaheo ... Registration Number: 430200660000, GE-078-209-6384-01, TA-078-209-6384-01
1 bedroom
1 bathroom
Sleeps 3
Hawaii> Kailua
This airy, spacious four bedroom Kailua beachside vacation rental home with AC provides the essence of tropical Hawaiian living. Recently remodeled kitchen and bath(s) finish off this stunning home. Whether you prefer lounging in the sun ... Registration Number: 430190530000, GE-126-659-1744-01, TA-126-659-1744-01
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Kailua
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.Registration Number: 430050050000, TA-209-884-5696-01, GE-209-884-5696-01
3 bedroom
4 bathroom
Sleeps 8
Hawaii> Kailua
Due to local laws we have a rental contract of 30 days. Registration Number: TA-143-873-0240-01, 430750280000, GE-143-873-0240-01
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Kailua
Beachfront! The White Sand of Kailua Beach at Your Door!Registration Number: GE-189-305-8560-01, TA-189-305-8560-01
4 bedroom
4 bathroom
Sleeps 8
Hawaii> Kailua
Tropical setting just steps away from beautiful Kailua Beach. Located on a quiet cul-de-sac beachside of Kalaheo Ave. This quiet and private accommodation is ideal for 2 couples or a small family. Aprox 900sq ft of indoor living area, complete ... Registration Number: TA-036-719-8208-01, GE-036-719-8208-01
2 bedroom
2 bathroom
Sleeps 4
Hawaii> kailua
2 Night Minimum Stay Registration Number: GE-168-049-0496-01, 430180480000, TA-168-049-0496-01
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Kailua
*Our calendar may not reflect our current availability. Please feel free to reach out with any questions regarding quotes for our monthly rates, fees and availability at lanikaisunrise808@gmail.comRegistration Number: 430050510000, GE-183-951-1552-01, TA-183-951-1552-01
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Kailua
Aloha! We renovated this old-style Hawaiian home so that it will have the charm of old Hawaii with modern conveniences.Registration Number: GE-077-835-2640-01, TA-077-835-2640-01, 430110790000
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Kailua
QUIET LOCATION: Secluded on the side of our Kailua home you’ll find Holiday Palms. This private cottage is a remodeled, 600 sq ft, one-bedroom unit, steps from beautiful Kailua Beach. Tucked away amid tropical palm trees, with your own shady ... Registration Number: GE-091-387-9040-01, TA-091-387-9040-01
1 bedroom
1 bathroom
Sleeps 5
Hawaii> Kailua
Indulge in the tranquility of Lanikai Beach, just a stone's throw away, and let the allure of this coastal paradise wash over you. With the studio's inviting comforts and the endless ocean possibilities at your disposal, your stay promises to be... Registration Number: GE-095-917-0560-01, TA-095-917-0560-01, 143005018000
0 bedroom
1 bathroom
Sleeps 2
Hawaii> Kailua
This Kailua, beachside, pool home was completely remodeled in 2019 with all new kitchen, bathrooms, pool house, pool surround, landscaping, TV's, furnishings, etc. And NO CLEANING FEE on 30 day bookings!Registration Number: GE-174-185-2672-01, TA-174-185-2672-01, 430190450000
5 bedroom
4 bathroom
Sleeps 10
Hawaii> Kailua
Perfect Kailua Home on 18,000 square feet of land all your own!! Lots of room to spread out!! We have a gorgeous newly tiled Swimming Pool and spa! You are invited to rest and relax in “Ka Hale Lai” , Kailua’s House of Serenity, 5 ... Registration Number: TA-027-765-7600-01, GE-027-765-7600-01
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Kailua
ALOHA! The Kailua Bliss Beach House is a casual and relaxed beach house in the quiet Beachside neighborhood in Kailua, located on a private street, 1 house from the white sands of Kailua beach (Private beach gate is located adjacent to our ... Registration Number: TA-068-883-0976-01, GE-068-883-0976-01, 143018061000
4 bedroom
4 bathroom
Sleeps 10
Hawaii> Kailua
Aloha and Welcome to Kolea LandingRegistration Number: 430070230000, GE-082-679-2448-01, TA-082-679-2448-01
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Kailua
Welcome to Lanikai Hale ~ Two Hawaiian style cottages (which can be rented together or separately) on a large fenced-in property in the heart of Lanikai, just 2 miles from Kailua Town on the Windward side of Oahu.Registration Number: TA-107-927-8080-01, GE-107-927-8080-01
5 bedroom
3 bathroom
Sleeps 12
Hawaii> Kailua
We have many, many 5 star reviews from another popular website which we were only using until recently. I can share those with you. We have decided to start using VRBO more often so please disregard the lack of reviews and booking acceptance.... Registration Number: 430250610000, TA-179-364-9152-01, GE-179-364-9152-01
3 bedroom
1 bathroom
Sleeps 8
Hawaii> Kailua
Welcome to Holoholo Hale in the beautiful town of Kailua on the island of Oahu. Kailua is the home of two of the best beaches in the world, Kailua Beach Park and Lanikai Beach. The home is a short drive to all the island has to offer including ... Registration Number: 420560420000, GE-141-882-0096-01, TA-141-882-0096-01
7 bedroom
4 bathroom
Sleeps 14
Hawaii> Kailua
The Pool House in Kailua offers 3,200 sq ft with 6 bedrooms, 4 baths and one amazing pool. Located in a peaceful and lush neighborhood with views of the Ko’olau Mountain range, it is an easy walk to Kailua Beach, Lanikai Beach and Buzz's ... Registration Number: 420540580000, TA-036-329-7280-01, GE-036-329-7280-01
6 bedroom
4 bathroom
Sleeps 15
Hawaii> Kailua
Minimum Stay: 2 night Registration Number: GE-168-049-0496-01, 430180480000, TA-168-049-0496-01
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Kailua
LOCATION LOCATION LOCATION.....Registration Number: TA-064-669-6960-02, GE-064-669-6960-02
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Kailua
This adorable pup-friendly, 3 bedroom, 1 bath vacation rental is ideally located, walking/biking distance to both the quaint shops and eateries of Kailua Town and renowned Kailua Beach! Fill your days with walks on the beach, surfing, SUP or ... Registration Number: TA-006-886-2976-01, 4306304400000, GE-006-886-2976-01
3 bedroom
1 bathroom
Sleeps 6
Hawaii> Kailua
Bright and airy home with ample large windows to let in the fresh ocean breeze. Brand new built in 2021! Spacious rooms with a beautiful kitchen to prepare your favorite island dishes. Downstairs 3 bedroom 1 bath lockout unit also available. ... Registration Number: 4306304400000, TA-006-886-2976-01, GE-006-886-2976-01
4 bedroom
2 bathroom
Sleeps 8
Hawaii> Kailua
This spacious studio is a permitted short term rental unit conveniently located in Kailua. Walking distance to Kailua Beach, Kailua Town, shopping and restaurants.Registration Number: GE-121-728-3584-01, TA-121-728-3584-01, 143071110000
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Kailua
This stylish, designer decorated, 4 bed, 4 Bath home is just across the street from Kailua Beach. We call her Coastal Soul. Lounge in the beach chic living room, cook in the gourmet, fully equipped kitchen, or swim in the heated lagoon pool. ... Registration Number: GE-018-450-1760-01, TA-018-450-1760-01, 430100190001
4 bedroom
4 bathroom
Sleeps 8
Hawaii> Kailua
