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 (`headline` like '%pcc%') AND sleeps>=1 order by rating desc LIMIT 0, 50
30-day rental. Please inquire.
Welcome to Moku Paradise B! This 1 bedroom, 1 bath island-style oceanfront cottage has breathtaking ocean views and a semi-private beach. This is a perfect getaway paradise for those seeking a calm, private,...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Laie
Direct beachfront! Situated a mere 21 feet from our property seawall, the unit feels a bit like being on a boat, with ocean as far as the eye can see. Unit highlights: vaulted ceilings, oversized lanai, comfy king bed, Jacuzzi tub, free WiFi, ...
- 2 bedroom
- 2 bathroom
- Sleeps 3
Hawaii> Hauula
This cozy beach house is backed directly up to your own private beach walking trails beautiful palm trees surround you. Located within a short distance of the Polynesian Culture Center and BYU-Hawaii and downtown and great food and within a ...
- 5 bedroom
- 3 bathroom
- Sleeps 16
Hawaii> Hauula
Experience the charm of Aloha Studio, nestled in a serene North Shore neighborhood. This cozy retreat features a queen bed and an air mattress for extra sleeping space, accommodating 2-3 guests comfortably.
Stay cool and refreshed in the ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Hauula
Description
The Shaka Hale Combo is composed of a 2-bedroom unit called Shaka Hale and a studio apartment called Shaka Studio.
🍍Shaka Hale🍍
You will fall in love with Shaka Hale. Relax away from all of the chaos in this great ...
- 4 bedroom
- 2 bathroom
- Sleeps 10
Hawaii> Hauula
*PER COUNTY REGULATION THIS PROPERTY ONLY ACCEPTS 1 BOOKING PER 30 DAYS
AIR CONDITIONING in every room. Wow! This newly remodeled 5-bedroom, 2-bath home speaks comfort and convenience. Aside from having cool and relaxing bedrooms, the ...
- 5 bedroom
- 2 bathroom
- Sleeps 13
Hawaii> Laie
**30 day rental. Please inquire. 888-799-6920
Welcome to Moku Paradise! This 3 bedroom, 3 bath island style oceanfront home has breathtaking ocean views and semi-private beach. This is a perfect getaway paradise for those seeking a calm, ...
- 3 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Laie
You will discover the true Hawaii as you stay in this 3-bedroom, 1-bath Hawaiian home in Hauula. This newly-renovated bottom floor unit (the caretaker lives upstairs) getaway that sleeps 8-9 guests and is located about 5 minutes away from ...
- 4 bedroom
- 1 bathroom
- Sleeps 9
Hawaii> Hauula
Nestled at the base of the lush tropical Koolauloa mountains range, a hiker’s paradise awaits. Secluded beaches are walking distance away. Polynesian Cultural Center, zip lines, and horse back riding are 5 to 10 minutes away. The studio is ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Hauula
