select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) as vw where 1 and round(price)>0 and bedrooms>=0 and (registration_number like 'TA-%') AND (city = 'waianae' OR postalCode = 'waianae' OR region like '%|waianae|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Your unforgettable Hawaiian getaway begins at this 1-bath vacation rental studio condo in Makaha! ‘Pua Aina Hale’ is an oasis in the Makaha Valley Towers, about 1 mile from famous Makaha Beach, making it a romantic retreat for a couple ...
Registration Number: TA-096-279-0400-01, GE-09
0 bedroom
1 bathroom
Sleeps 3
HI> 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, 84002
1 bedroom
1 bathroom
Sleeps 4
HI> Waianae
***Dear Prospective Guest: although we are subject to the "30 day minimum" ordinance along with most vacation rentals on Oahu, shorter guest stays ARE allowed provided that the unit is not rented to another guest during the remainder of the 30 ...
Registration Number: TA-041-170-6368-01, 84004
1 bedroom
2 bathroom
Sleeps 4
HI> Waianae
Beautiful views of the Makaha Valley mountains and the ocean, on the West coast of Oahu. Here you will 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 ...
Registration Number: TA-144-190-5152-01
0 bedroom
0 bathroom
Sleeps 4
HI> Waianae
Aloha, our home is located on the leeward coast of Oahu where its filled with beautiful beaches and breath taking sunsets. You will be in walking distance from our island sands and crystal clear shorelines. Our home has 2bedrooms and 2 master ...
Registration Number: TA-124-225-7920-01, 18705
4 bedroom
3 bathroom
Sleeps 10
HI> Waianae
Secured complex of low rise condos 1.5 miles from the beach. Security gate to access and regularly patrolled. 2 pools and hot tubs with BBQ areas, tennis courts, Basket ball courts and other BBQ areas around the complex. Protected ...
Registration Number: TA-170-950-0928-01, GE-17
2 bedroom
1 bathroom
Sleeps 6
HI> 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: TA-175-671-0912-01, GE-17
0 bedroom
1 bathroom
Sleeps 3
HI> Waianae
Postcard Perfect Beach. you will be staying on one of the best beaches in the Hawaiian Islands. 30ft. from the ocean, sunset from your lanai or the white sand below. Fully equipped units INCLUDING Wi Fi and Cable...
Registration Number: TA-048-692-0192-01, W2288
1 bedroom
1 bathroom
Sleeps 6
HI> 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-06
0 bedroom
1 bathroom
Sleeps 3
HI> Waianae
6 min walk to the beach, restaurants 25 minutes away! Street parking available in safe neighborhood, earthy outdoor space, outdoor shower to enjoy after a excursion at the beach. Home fully renovated, full kitchen
2 perfect size rooms...
Registration Number: TA-016-315-0336-01, 84028
2 bedroom
3 bathroom
Sleeps 7
HI> Waianae
This is an exquisite19th 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 countertops ...
Registration Number: TA-207-582-5152-01, GE-20
1 bedroom
1 bathroom
Sleeps 2
HI> Waianae
WOW! 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 beauty of Hawaii ...
Registration Number: TA-187-550-9248-01, GE-18
1 bedroom
1 bathroom
Sleeps 4
HI> Waianae
HUGE ***NEW LISTING*** DISCOUNTS for March-June *MESSAGE ME*
House, 5 Bedrooms + Den, 4.5 Baths, Central A/C (Sleeps from 2-16)
~In order to conform to the county regulations this property will be renting to only (1) one party per 30 days. ...
Registration Number: TA-067-393-5360-01, GE-06
5 bedroom
5 bathroom
Sleeps 16
HI> Waianae
Condo, 1 Bedroom, 1 Bath, Sleeps 2-4, Children welcome, Air Condition
Enter the gates of Makaha Valley Towers to a luxury resort feeling! The immaculately landscaped secluded grounds will welcome you like any Five Star Resort. This facility ...
Registration Number: TA-100-884-5824-01, 18400
1 bedroom
1 bathroom
Sleeps 4
HI> Waianae
Minimum rental is 30 days
Monthly rental $6900.00
Call for more info.
Inspired by Japanese style home. This is a sophisticated and luxurious retreat that reflects that magical merging of inspiration and architecture. This guest house is a ...
Registration Number: TA-196-011-6224-01, GE-19
2 bedroom
3 bathroom
Sleeps 5
HI> Waianae