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 = 'waianae' OR postalCode = 'waianae' OR region like '%|waianae|%') AND sleeps>=1 order by rating desc LIMIT 0, 20
The perfect Dupe. Less crowded, a little unexpected, and truly delightful. The vibe here is RETO and CHILL. Friends and Family fun await you. Message us for details as we do not use the VRBO calendar. Registration Number: 840080160002, GE-088-190-7712-01, TA-088-190-7712-01
4 bedroom
2 bathroom
Sleeps 8
Hawaii> Waianae
Aloha and Welcome, Registration Number: 870230510000, GE-153-926-4512-01, TA-253-926-4512-01
4 bedroom
2 bathroom
Sleeps 8
Hawaii> Waianae
Ocean view penthouse condo. This studio is located in the Pokai bay Marinas. this condo has a well equipped kitchen and boosts beautiful coast line views. The building is equipped with fenced parking , modern day security entrance system. and ... Registration Number: TA-082-631-8848-01, GE-082-631-8848-02
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Waianae
Recently remodeled, THREE bedroom, 1 1/2 bath house located right next to the entrance of Pilila'au Army Recreation Center aka Rest Camp in Waianae, HI and 300 ft from shoreline. Entrance to beach through the military gate is typically ... Registration Number: GE-125-800-7040-01, TA-125-800-7040-01
3 bedroom
2 bathroom
Sleeps 8
Hawaii> Waianae
Registration Number: 84004006, TA-021-069-2096-01, GE-021-069-2096-01
1 bedroom
2 bathroom
Sleeps 3
Hawaii> Waianae
***Please note: As with most short-term rentals on Oahu, our condo is subject to the Honolulu "30 day minimum" law. We can accept reservations for stays less than 30 days (only one reservation in a 30 day period). We know this is very confusing,... Registration Number: TA-041-170-6368-01, 840040060035, GE-041-170-6368-01
1 bedroom
2 bathroom
Sleeps 4
Hawaii> Waianae
ALOHA, this beautiful, white sandy beach front home is located, right in front of Turtle Cove Beach. Not to mention, that it is also close to the world famous Makaha Surf Beach. Of course all the beaches on the West side are beautiful and is ... Registration Number: TA-145-669-5296-01, GE-145-669-5296-01
1 bedroom
1 bathroom
Sleeps 3
Hawaii> Waianae
Enjoy this renovated condo on a beautiful white, sandy beach in Makaha. Relax on the sunny leeward side of Oahu - just a 45 minute drive from the airport. Eat your breakfast on the lanai while watching for whales and enjoy the stunning sunsets... Registration Number: GE-053-454-5408-01, TA-053-454-5408-01
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Waianae
FOR A WOW EXPERIENCE! Less than an hours drive from Honolulu (yet only 10 minutes from local shops and restaurants) but a world away from big city life. If you want to relax and enjoy the ocean, beach, mountains and get a chance to see the real... Registration Number: GE-187-550-9248-01, 840010040026, TA-187-550-9248-01
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Waianae
Only accepting 30+ night rentals. Registration Number: 830020030000, TA-026-815-2832-01, GE-026-815-2832-01
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Waianae
Remodeled fourth floor unit in Makaha's ONLY Beachfront Condo! The other condos you will find are located about 2 miles to the South. Our studio has been completely remodeled, and is located on the cool side of the building, with Ocean and ... Registration Number: TA-066-607-6032-01, GE-066-807-6032-01, 840010050059
0 bedroom
1 bathroom
Sleeps 3
Hawaii> Waianae
Stay right on the sand and let the crashing waves lull you to sleep at night. Makaha is away from tourists and a unique Hawaii experience on the West Side of Oahu with a breathtaking coastline and empty beaches. You can't beat the ultimate ... Registration Number: GE-172-162-5088-01, TA-172-162-5088-01, 840040140012
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Waianae
Newly renovated and fully furnished condo with AC, Spectrum High-spreed Internet & Cable TV. Large screen TV's in Living Room and Master Bedroom. Beach towels, boogie boards in the unit. Two community pools, basketball and tennis courts. Unit ... Registration Number: 840020490349, TA-062-373-6832-01, GE-062-373-6832-01
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Waianae
We have a fabulous one bedroom apartment for rent in Hawaii by the month. The apartment is on the Island of Oahu on the west side about an hours drive from Honolulu. This one bedroom apartment with a Queen-size bed and a double pull-out sofa in... Registration Number: TA-115-115-6224-01, GE-115-115-6224-01, 840020100145
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Waianae
This is an exquisite 19th floor condo in a gated community. The views from this property are a breath taking panorama of mountains and ocean. Registration Number: 840020100572, TA-207-582-5152-01, GE-207-582-5152-01
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Waianae
THE STATE of HAWAII has re-zone Vacation rentals. Our unit is considered a Long Term Rental. 30-day reservations are the minimum. No exceptions. As owners, we could be awarded fines. We Will NOT host Short Term Rentals. Think about combining ... Registration Number: TA-200-811-3664-01, 870280170057, GE-200-811-3664-01
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Waianae
Beautiful views of the Makaha Valley mountains and the ocean, on the West coast of Oahu. Here you find ten miles of fabulous beaches, sun and sand, with much less wind and rain than other parts of the island. Waianae is just North of Honolulu, ... Registration Number: 840020100140, GE-144-190-5152-01, TA-144-190-5152-01
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Waianae
Newly updated 1 bedroom beachfront property with killer views of one of the loveliest beaches in Oahu. The unique configuration of this unit allows guests to enjoy the views of Papaoneone beach day and night, from the living room, kitchen, and ... Registration Number: GE-206-347-9296-01, 840040140032, TA-206-347-9296-01
1 bedroom
1 bathroom
Sleeps 3
Hawaii> Waianae
Freshly updated 1BR condo in beautiful Makaha Valley on the Leeward side of Oahu. Enjoy spectacular views of the mountains and ocean from the floor to ceiling windows. New cabinets and countertops in kitchen and bath, king size bed, and SS ... Registration Number: 840020100359, TA-173-839-8208-01, GE-173-839-8208-01
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Waianae
This 1985 VW Westfalia has everything you need to explore the island your way. This classic bus seats & sleeps up to 4 adults in its 2 fold out beds. It also includes a kitchenette with sink, mini fridge, and two burner stove. There are direct ... Registration Number: GE-206-728-2432-01, 870490340000, TA-206-728-2432-01
3 bedroom
3 bathroom
Sleeps 4
Hawaii> Waianae
