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
What you will find. A 30-day rental that is less crowded, a little unexpected, and truly delightful. The vibe here is RETRO and CHILL. Friends and Family fun await you. Please 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
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 vacation rentals on Oahu, our condo is subject to the Honolulu "30 day minimum" law. We can accept reservations for stays of less than 30 days (only one reservation in a 30 day period). We know this law is 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
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
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, cooler, 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,Registration Number: 870190010000, TA-156-544-3584-01, GE-156-544-3584-01, 1216202245233
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 & create priceless memories w/ family & friends in this new modern, LARGEST one story! 3 bedrooms, 2 bathrooms. Master bedroom w/ 1 king bed, 2nd bedroom with 1 queen bed, 3rd bedroom with 1 bunk bed (double and twin) ... Registration Number: TA-061-952-1536-01, GE-061-952-1536-01, 840291500113, 1726
3 bedroom
2 bathroom
Sleeps 10
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
5 bedroom
3 bathroom
Sleeps 10
Hawaii> Waianae
Summary:Registration Number: 840291500015, GE-119-477-1456-01, TA-119-477-1456-01
4 bedroom
3 bathroom
Sleeps 10
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
Welcome to "Surfside Serenity" in Makaha, HawaiiRegistration Number: 1840291500045, GE-069-541-3248-02, TA-069-541-3248-02
3 bedroom
2 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
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
Escape to the enchanting shores of Oahu at Makaha-465 Farrington Hwy by Gather, a stunning beachfront home that has been a cherished family gem since the 1940s. Recently rebuilt to cater to modern vacations while retaining its familial charm, ... Registration Number: TA-036-844-4416-02, GE-036-844-4416-01, 840080180000
4 bedroom
4 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 8
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
Nestled in the town of Makaha, our 1-bedroom condo offers a tranquil retreat for your Hawaiian getaway. As you step inside, you'll be greeted by a gorgeous ocean view! A kitchenette, complete with a stove, oven, refrigerator, and all the ... Registration Number: TA-196-923-0336-01, GE-196-923-0336-01, 0530202445243, 850170080148
1 bedroom
1 bathroom
Sleeps 2
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
Aloha and welcome to Cottage Nene, your serene Hawaiian escape nestled in the lush Makaha Valley. This beautifully designed home combines luxurious comfort, tropical landscape, and breathtaking natural surroundings. Whether sipping your morning ... Registration Number: GE-091-023-5648-01, TA-091-023-5648-01, 448, 840291500052
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Waianae
Aloha! If you're looking for an authentic Hawaiian experience, stunning beaches, local eateries, and a peaceful atmosphere far from the Waikiki hustle and bustle, you've found it! Registration Number: TA-134-978-0992-01, 840040060092, GE-134-978-0992-01
1 bedroom
1 bathroom
Sleeps 4
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, 90/TVU-0073, GE-147-153-1008-01, TA-147-153-1008-01
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Waianae
Newly remodeled condo on the 19th floor with gorgeous unobstructed views of mountains and ocean!This is nestled in the Makaha Valley away from the hustle and bustle of the city. Located in the Makaha Valley Towers that is a resort style living... Registration Number: GE-175-671-0912-01, TA-175-671-0912-01
1 bedroom
1 bathroom
Sleeps 3
Hawaii> Waianae
