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 = 'waimanalo' OR postalCode = 'waimanalo' OR region like '%|waimanalo|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
“Notice: In compliance with the Revised Ordinances of the City and County of Honolulu, the Property will be made available for your use and occupancy for a period of thirty (30) days.”
$79.00 Admin Fee is for our Damage Protection Policy....
Registration Number: TA-063-319-9104-01, GE-06
9 bedroom
8 bathroom
Sleeps 20
HI> Waimanalo
"Hale Pohaku" - Waimanalo is a beautiful beachfront home on one of Oahu's most spectacular beaches; Waimanalo. Listed on the Register of Hawaii's Historic Homes this classic restored beach house was built of lava rock during the reign of King ...
Registration Number: TA-059-395-6864-01, 41004
3 bedroom
3 bathroom
Sleeps 8
HI> Waimanalo
We are cleaning and sanitizing thoroughly between guests, as well as laundering all bedding, linens and couch covers. We also offer self-check in.
According to local laws, we have a minimum rental period of 30 days. A minimum stay of 7 nights...
Registration Number: TA-143-873-0240-01, 41007
1 bedroom
1 bathroom
Sleeps 2
HI> Waimanalo
Right across the street from one of Oahu's most beautiful and uncrowded beaches voted # 1 in the USA.
Enjoy the breathtaking beauty and peaceful tranquility of this perfectly located Hawaiian style cottage, steps from the beach with a large ...
Registration Number: TA-130-535-0144-01
2 bedroom
2 bathroom
Sleeps 4
HI> Waimanalo
Notice: This is a 30 day minimum rental. INQUIRE for AVAILABILITY!
Experience Hawaii off the beaten path, away from the hustle and bustle in Waikiki in this island beach house. Perfectly located steps from Waimanalo Beach. This family home ...
Registration Number: TA-088-449-0240-01, GE-08
3 bedroom
2 bathroom
Sleeps 8
HI> Waimanalo
Aloha, this unique Premier Partner property is exclusively available for periods of thirty (30) days or more. There is NO requirement or obligation to occupy the property continuously for the entire 30 day period. The 30 day rental period will ...
Registration Number: TA-120-590-3360-01, GE-12
2 bedroom
1 bathroom
Sleeps 6
HI> Waimanalo
Furnished 3 large bedroom, 2 bath home ready for you and your family to come relax and enjoy the beauty of Waimanalo beach. Located only STEPS to the TOP RATED white sandy beach!!. Master bedroom: Cal-King bed and pullout ottoman with an ocean ...
Registration Number: TA-047-513-6000-01, GE-04
3 bedroom
2 bathroom
Sleeps 8
HI> Waimanalo
This spectacular property is located beach front and has the most amazing ocean views, lots of room to enjoy this pristine beach environment and an ultimate decor with a french touch. All the bedrooms enjoy a private, en-suite bath and all have ...
Registration Number: TA-199-621-0176-01, GE-19
5 bedroom
6 bathroom
Sleeps 10
HI> Waimanalo
Note:
1) Please always send messages to the host to confirm the schedule, how many guests, and other related questions before make your booking.
2) GREAT PRICE!
3) Be rented as monthly rental per local government’s requirement.
4) Per local...
Registration Number: TA-111-933-9520-01, 14100
2 bedroom
1 bathroom
Sleeps 4
HI> Waimanalo
Note:
1) Please always send messages to the host to confirm the schedule, how many guests, and other related questions before make your booking.
2) GREAT PRICE!
3) Be rented as monthly rental per local government’s requirement.
4) Per local...
Registration Number: TA-111-933-9520-01, GE-11
7 bedroom
4 bathroom
Sleeps 10
HI> Waimanalo