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 (`headline` like '%makaha valley%') AND sleeps>=1 order by rating desc LIMIT 0, 20
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.
The kitchen is newly remodeled with modern high end cupboards and appliances, granite ...
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 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
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
Enjoy this home away from home in this lovely one bedroom/one bath condo in Makaha Valley Towers.
In compliance with City & County of Honolulu's new laws, this condo has a minimum stay of 30 days.
Makaha Beach is only 20 minutes ...
Registration Number: 84002010, TA-116-514-1504-01, GE-116-514-1504-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Waianae
Book with confidence! This property is professionally managed by Ali’i Beach Rentals!
Note: Access to the community clubhouse, pool, hot tub, and gym will be available in late Fall 2024
Escape to your own private paradise in the ...
Registration Number: 840291500087, TA-062-242-6624-01, GE-062-242-6624-01, STR#1622
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waianae
🌺 Mahalo (thank you) for choosing to support LOCAL! 🤙🏻
We are brand NEW! We know you have many options available to you in this neighborhood from big corporations and companies but we promise that you will be pleased with your ...
Registration Number: 840291500076, STR Permit# 2203, TA-137-495-2448-01, GE-137-495-2448-01
- 5 bedroom
- 4 bathroom
- Sleeps 10
Hawaii> Makaha Valley
Want to get away from it all? This first floor, 2 Bedroom (plus Sofa Bed), 1 Bath Townhouse unit (sleeps 4, in a secluded condominium complex, nestled between the scenic Makaha Valley and the Waianae Mountain Range on the Leeward Coast of ...
Registration Number: TA-145-669-5296-01, GE-145-669-5296-01
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Waianae
Makaha can't be beat for those looking for uncrowded beaches, striking sunsets, hiking, and the incredible ease of real Hawaii. Our condo is outfitted with airy midcentury-modern styling and a hint of Hawaiiana as well as full frontal floor to ...
Registration Number: 840020100004, TA-170-824-3456-01, GE-170-824-3456-01
- 2 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Waianae
Book with confidence! This property is professionally managed by Ali’i Beach Rentals!
We are proud and excited to reintroduce our beautiful and newly built 1-story home located in a gated and secure community at Makaha Valley that ...
Registration Number: 840291500109, STR #1852, GE-088-884-7360-01, TA-088-884-7360-01
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Waianae
This locally owned, green, garden home with breathtaking Ocean and ; Mountain views, and Beach
minutes away in a secure 24/7 gated community is professionally managed by Ali’i Beach
Rentals.
Note: Access to the community ...
Registration Number: 840291500028, GE-200-203-6224-01, TA-200-203-6224-01, STR # 1566
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waianae
Relax and enjoy the North West side of Oahu.
While Hawaii is known as the gathering place, Makaha Valley allows you the space to "just be".
Our getaway place is located in a secure guarded gated property, a non-smoking property, just a ...
Registration Number: TA-021-717-6576-01, 020100124003, GE-021-717-6576-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Makaha Valley
Recently remodeled guard gated condominium on the 6th floor of Makaha Valley Towers. Brand new furnishings and beautifully decorated, along with fantastic views from expansive windows. Very convenient to parking and elevators. Includes a ...
Registration Number: TA-115-600-4352-01, GE-115-600-4352-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Waianae
Escape to paradise in this brand new vacation rental located in the secluded Makaha Valley. Just a short drive away from some of the world's most beautiful beaches, enjoy endless opportunities for hiking, golfing, and soaking up the sun. ...
Registration Number: 1840291500049, GE-029-607-6800-01, TA-029-607-6800-01, STR # 1020
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Waianae
Take a break and unwind at this peaceful oasis in paradise!
Enjoy Oahu and all that this beautiful island has to offer but away from much of the tourist crowds. This 2 bedroom/1 bath condo complex is 1 mile up from a beautiful sandy ...
Registration Number: TA-079-368-0896-01,GE-079-368-0896-01,840020490013
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Waianae
About this space
Enjoy this beautiful, private, brand new studio nestled in the mountains of Makaha Valley. This is located in a gated community with 24 hour security. Minutes from year round surfing and golfing. This is a LEGAL vacation ...
Registration Number: 840291500102, 184029150010, TA-013-994-8032-01, GE-013-994-8032-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Waianae
Mahalo (thank you) for choosing to support LOCAL!
We know you have many options available to you in this neighborhood from big corporations, but we promise that you will be pleased with your decision.
$1 cleaning fee! We refuse to ...
Registration Number: 840291500027, TA-137-495-2448-01, GE-137-495-2448-01
- 3 bedroom
- 3 bathroom
- Sleeps 12
Hawaii> Makaha Valley
One bedroom condo beautiful view 2 minutes from beach driving 15 minutes walking nice hiking in the area and great local food heated swimming pool 6 gas grills pinning area free parking 24 hour security...
Registration Number: TA-018-044-6720-01, GE-018-044-6720-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Waianae
If you are looking for gorgeous less crowded beaches, unique hikes, and perfect surf this is your kind of place. 2 bedroom, one bath unit in Makaha Valley, West Side of Oahu. Just 1.5 miles from beautiful beaches, only sand, ocean, surf and ...
Registration Number: 123456789012, TA-060-326-8608-01, GE-060-326-8608-01
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Waianae
