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, 50
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
6 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
2 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
2 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
3 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
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
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
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
Freshly updated 1BR condo on a high floor 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 ... 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
30 Day minimum @ $7800.00 monthly. Wake up each morning to the soothing sounds of the waves and go to sleep after watching a memorable sunset , relax and enjoy the breathtaking sunsets on the beautiful beaches of Makaha. Step right outside to ... Registration Number: 002906103055, TA-122-458-7801-01, GE-082-643-6096-01
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Waianae
Situated at the foot of the Makaha Mountains, this tropical escape boasts a screensaver-worthy backdrop and a prime location near Oahu's best beaches. By day, get your dose of sun and sand at Makaha Beach Park, and come evening, enjoy the view ... Registration Number: TA-169-498-0608-01, GE-169-498-0608-01, 1840291500074
5 bedroom
3 bathroom
Sleeps 8
Hawaii> Waianae
Surrounded by magical mountains that turn into mesmerizing waterfalls and beautiful ocean vistas. Our amazing house boasts gorgeous views from every single room. Perfect to unwind, relax, and enjoy nature at its best. 6 minutes away to ... Registration Number: TA-108-588-3904-01, GE-108-588-3904-01, 840291500050
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Waianae
Nestled in the beautiful Makaha Valley, this newly constructed home will sure you make your vacation memorable. Away from the hustle and bustle of the city, this home sits in preferred corner lot with no neighboring home on the side for maximum ... Registration Number: TA-008-626-3296-01, GE-008-626-3296-01, 840291500051
4 bedroom
3 bathroom
Sleeps 11
Hawaii> Waianae
Our one bedroom beachfront condo has everything you need to feel right at home in paradise. Located on the beautiful Waianae Coast, our condo at the Makaha Beach Cabanas and just steps away from Papaeoneone Beach. Wake up to postcard perfect ... Registration Number: 840040140120, GE-093-800-6528-01, TA-093-800-6528-01
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Waianae
Aloha! Welcome to Paradise Mahalo! Nestled in stunning mountains and ocean views, enjoy our modern, luxurious and cozy home located in the majestic Mākaha Valley. Whether it's a few rounds of golf, a hiking trails near by or a five minute drive... Registration Number: 840291500056, TA-158-343-3216-01, GE-158-343-3216-01
4 bedroom
3 bathroom
Sleeps 14
Hawaii> Waianae
Wake up in the morning, you see the greens & clouds kissing the mountains, hearing the birds chirping. You are a few minutes' drive to the beach. You can easily explore the most indigenous feel of Hawaii nearby. Surfing, swimming, hiking... ... Registration Number: GE-058-196-5824-01, TA-058-196-5824-01, 1840291500107
3 bedroom
3 bathroom
Sleeps 8
Hawaii> Waianae
BRAND NEW HOME located in a gated community in Mākaha Valley, with beautiful ocean and mountain views. Just a 5 minute drive to Mākaha Beach for swimming, surfing, boogie boarding or just relaxing. Home is equipped with all you need for a ... Registration Number: 840291500000, TA-011-319-8592-01, GE-011-319-8592-01
4 bedroom
3 bathroom
Sleeps 9
Hawaii> Waianae
Feel the Ohana spirit and create priceless memories, and have fun with your family and friends in this brand new 4 bedrooms, 2.5 bathrooms with amazing 360 views from the Majestic Mountain Views and endless Ocean Views, fully landscaped, 24/7 ... Registration Number: 840291500065, TA-196-011-6224-01, GE-196-011-6224-01
4 bedroom
3 bathroom
Sleeps 10
Hawaii> Waianae
Beautifully remodeled studio apartment with breathtaking views of the mountains and ocean. The Makaha Valley Towers is located in the scenic Makaha Valley and is minutes away from Makaha Surfing Beach. The area is known for its quiet, relaxed ... Registration Number: 1840020100181, TA-147-640-4736-01, GE-147-640-4736-01
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Waianae
Le'ale'a — that sunny, blissful feeling of wonder and joy you only feel when immersed in the beauty of a place like the Hawaiian islands. And there’s plenty of it here! In the heart of Mākaha Valley and surrounded by stunning tropical ... Registration Number: 840291500014, GE-152-179-6608-01, TA-152-179-6608-01
3 bedroom
3 bathroom
Sleeps 8
Hawaii> Waianae
Hawaiian Princess 1 bedroom, 1 1/2 bath end unit penthouse. There is no better ocean/beach view on the westside of the island than from the lanai of this 16th floor condo. This condo sits right on the beach. 850 square feet inside the condo, ... Registration Number: 1840040060120001, TA-070-956-2368-01, GE-070-956-2368-01
1 bedroom
2 bathroom
Sleeps 4
Hawaii> Waianae
Discover your haven at Magic Makaha Manor, our family retreat blending hilltop majesty with ocean tranquility. This well-appointed abode hosts large family cozily, catering to both organizers and impulsive explorers. Wave riders can surf close ... Registration Number: GE-039-909-1200-01, 840291500010, TA-039-909-1200-01
3 bedroom
2 bathroom
Sleeps 8
Hawaii> Waianae
Stylish Makaha Retreat near the Ocean. Experience the allure of island living in this serene vacation rental nestled amidst lush mountains. Just a short 2-mile drive down the valley, you'll find yourself at the sparkling shores of world famous ... Registration Number: TA-048-121-6000-01, GE-048-121-6000-01, 1840291500008
3 bedroom
2 bathroom
Sleeps 8
Hawaii> Waianae
Book with confidence! This property is professionally managed by Ali’i Beach Rentals!Registration Number: TA-031-773-6960-01, GE-031-773-6960-01, 840291500043, STR # 1492
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Waianae
Escape to our enchanting vacation rental nestled in the picturesque Makaha Valley. Ideal for nature lovers and beach enthusiasts, our cozy retreat offers the perfect blend of tranquility and adventure. Registration Number: TA-139-235-7376-01, 1840291500042, GE-139-235-7376-01
4 bedroom
3 bathroom
Sleeps 10
Hawaii> Waianae
Looking for a relaxing getaway that truly immerses you in the beauty and culture of Hawaii? Look no further than our charming and authentic Hawaiian home. Whether you're seeking a peaceful retreat or an adventure-filled vacation, our location ... Registration Number: 840291500023, GE-074-086-1440-01, TA-074-086-1440-01
4 bedroom
3 bathroom
Sleeps 7
Hawaii> Waianae
About this spaceRegistration Number: GE-144-816-1280-01, TA-144-816-1280-01, 184004014149
1 bedroom
1 bathroom
Sleeps 3
Hawaii> Waianae
Experience a true taste of Hawaiian paradise on the west side of Oahu at this new and stylish home with a relaxing coastal design. Spend quality time with your family and friends in this fully furnished home, away from the hustle and bustle of ... Registration Number: 1840291500002, GE-019-465-1136-01, TA-019-465-1136-01
5 bedroom
3 bathroom
Sleeps 9
Hawaii> Waianae
Summary:Registration Number: TA-064-728-4224-01, 840291500019, GE-064-728-4224-01
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Waianae
Kick back in the heart of Makaha Valley at Makaha Hideaway, a 3BR retreat that puts you 10 minutes from the beaches of Oahu. With a stunning view of tropical mountains from your backyard, this modern Hawaiian escape blends style, space, and a ... Registration Number: 2211-CCH-0243, 840291500060, GE-085-178-9312-01, TA-085-178-9312-01
4 bedroom
2 bathroom
Sleeps 8
Hawaii> Waianae
Kick back in the heart of Makaha Valley at Aloha Breeze, a 4BR retreat that puts you 10 minutes from the beaches of Oahu. With a stunning view of tropical mountains and the ocean from your backyard, this modern Hawaiian escape blends style, ... Registration Number: 840291500022, TA-036-350-5152-01, GE-036-350-5152-01, 2307-CCH-1481
5 bedroom
3 bathroom
Sleeps 10
Hawaii> Waianae
Oahu's best kept secret! Affordable, updated Hawaii condo is perfect for your stay in paradise. Off the beaten track and away from the crowds-live like a local with uncrowded, nearby beaches and a pristine, serene pool. Ko Olina lagoons, ... Registration Number: TA-050-915-0720-01, 84002010, GE-050-915-0720-01
2 bedroom
1 bathroom
Sleeps 5
Hawaii> Waianae
Indulge in the Unmatched Beauty of Contemporary Luxury at Ocean Escape — A Brand-New Retreat!Registration Number: 2302-CCH-1041, 840291500092, GE-129-119-4368-01, TA-129-119-4368-01
3 bedroom
3 bathroom
Sleeps 8
Hawaii> Waianae
Enjoy the beach life from this renovated and stylishly furnished apartment right on world famous Makaha Beach. Stroll on the beach. Swim with turtles. Snorkel with colorful reef fishes. Surf or just watch the surfers.Registration Number: GE-152-188-9280-01, TA-152-188-9280-01, 304, 840010050035
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Waianae
Kick back in the heart of Makaha Valley at 'Olu'olu, a 3BR retreat that puts you 6 minutes from the beaches of Oahu. With a stunning view of tropical mountains from your backyard patio, this modern Hawaiian escape blends style, space, and a ... Registration Number: GE-202-409-7280-01, TA-202-409-7280-01, 2301-CCH-0912, 840291500053
4 bedroom
2 bathroom
Sleeps 8
Hawaii> Waianae
Locally owned and operated. Newly renovated with upcycled local accents and eco friendly products. All new premium wood cabinets combine with one of a kind solid cement coulter tops, stainless steel appliances, and mango wood shelving in the ... Registration Number: TA-007-469-4656-01, 1840020100097, GE-007-469-4656-02
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Waianae
Welcome to Pakele Oahu, your dream getaway in Makaha Valley! Step into this former developer's model home, a haven of comfort and style. Immerse yourself in a spacious single-level residence adorned with upgraded features that redefine tropical ... Registration Number: 840291500046, 2305-CCH-1436, GE-077-326-8992-01, TA-077-326-8992-01
4 bedroom
2 bathroom
Sleeps 8
Hawaii> Waianae
Summary:Registration Number: GE-070-901-9136-01, 840291500017, TA-070-901-9136-01
8 bedroom
6 bathroom
Sleeps 15
Hawaii> Waianae
Located in Waianae, this vacation home is on the beach. Perfect for families and those who like surfing, 2 minutes walk away. 2 minutes to watch a beautiful Sunset , The area's natural beauty can be seen at Waianae Mountain...is and Tropic ... Registration Number: TA-024-360-3968-01, GE-024-360-3968-01, 850110070000
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Waianae
Uncover the enchantment of Makaha in this charming retreat tucked in the valley's embrace. Surrounded by lush mountains, a mere stroll from the beach, it's the epitome of serenity blended with adventure. Feel the laid-back vibes, savor the roomy... Registration Number: 1840291500064, TA-084-783-3088-01, GE-084-783-3088-03
3 bedroom
3 bathroom
Sleeps 9
Hawaii> Waianae
Registration Number: 1990/NUC-2228, 840040060023, TA-053-556-5824-01, GE-053-556-5824-01
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Waianae
Bring the whole family and more to this large fun Hawaii home. This single family home is nestled in a valley between two beautiful mountains. This large 11,000 sq ft property provides lots of outdoor space with 2 yards and a concrete patio ... Registration Number: GE-180-252-7581-01, TA-180-252-7581-01, 1850200690000
6 bedroom
4 bathroom
Sleeps 12
Hawaii> Waianae
★Pool with Ocean View★: Community center pool where kids can play and adults can chill.Registration Number: GE-039-909-1200-01, TA-039-909-1200-01, 1840291500033, 2305-CCH-1424
3 bedroom
2 bathroom
Sleeps 12
Hawaii> Waianae
Serendipity on the Moana is a Beautiful, Fully Furnished, one-bedroom condo directly on the beach with over 740 square feet in Maili Cove on Oahu. This unit is perfectly located in the center of the building on the second floor and has an ... Registration Number: 870280170031, GE-147-153-1008-01, TA-147-153-1008-01
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Waianae
