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 '%Kapiolani Park%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Looking for a beachfront getaway in Waikiki? Look no further than this convenient property! Just minutes from the most popular attractions, the excitement of Waikiki is all around you! And with comfortable amenities and authentic Hawaiian ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Honolulu
Looking for a beachfront getaway in Waikiki? Look no further than this convenient property! Just minutes from the most popular attractions, the excitement of Waikiki is all around you! And with comfortable amenities and authentic Hawaiian ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Looking for a beachfront getaway in Waikiki? Look no further than this convenient property! Just minutes from the most popular attractions, the excitement of Waikiki is all around you! And with comfortable amenities and authentic Hawaiian ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Looking for a beachfront getaway in Waikiki? Look no further than this convenient property! Just minutes from the most popular attractions, the excitement of Waikiki is all around you! And with comfortable amenities and authentic Hawaiian ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Looking for a beachfront getaway in Waikiki? Look no further than this convenient property! Just minutes from the most popular attractions, the excitement of Waikiki is all around you! And with comfortable amenities and authentic Hawaiian ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Honolulu
Looking for a beachfront getaway in Waikiki? Look no further than this convenient property! Just minutes from the most popular attractions, the excitement of Waikiki is all around you! And with comfortable amenities and authentic Hawaiian ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Honolulu
Looking for a beachfront getaway in Waikiki? Look no further than this convenient property! Just minutes from the most popular attractions, the excitement of Waikiki is all around you! And with comfortable amenities and authentic Hawaiian ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Honolulu
Looking for a beachfront getaway in Waikiki? Look no further than this convenient property! Just minutes from the most popular attractions, the excitement of Waikiki is all around you! And with comfortable amenities and authentic Hawaiian ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Honolulu
Looking for a beachfront getaway in Waikiki? Look no further than this convenient property! Just minutes from the most popular attractions, the excitement of Waikiki is all around you! And with comfortable amenities and authentic Hawaiian ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Honolulu
Looking for a beachfront getaway in Waikiki? Look no further than this convenient property! Just minutes from the most popular attractions, the excitement of Waikiki is all around you! And with comfortable amenities and authentic Hawaiian ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Honolulu
Looking for a beachfront getaway in Waikiki? Look no further than this convenient property! Just minutes from the most popular attractions, the excitement of Waikiki is all around you! And with comfortable amenities and authentic Hawaiian ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Honolulu
Looking for a beachfront getaway in Waikiki? Look no further than this convenient property! Just minutes from the most popular attractions, the excitement of Waikiki is all around you! And with comfortable amenities and authentic Hawaiian ...
- 3 bedroom
- 3 bathroom
- Sleeps 12
Hawaii> Honolulu
Your exciting family vacation or romantic escape starts here, right on the sands of Waikiki Beach! Just minutes from the best attractions, guests will also enjoy the resort pool with expansive sundecks and private cabanas as well as a poolside ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Honolulu
Your exciting family vacation or romantic escape starts here, right on the sands of Waikiki Beach! Just minutes from the best attractions, guests will also enjoy the resort pool with expansive sundecks and private cabanas as well as a poolside ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Honolulu
Come for the beaches, stay for the adventure! With comfortable amenities and convenience to local attractions, you’ll have everything you need for a relaxing getaway or exciting family vacation. Take a dip in the rooftop pool with views of ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Come for the beaches, stay for the adventure! With comfortable amenities and convenience to local attractions, you’ll have everything you need for a relaxing getaway or exciting family vacation. Take a dip in the rooftop pool with views of ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
You’ll feel right at home at this lovely boutique property in Waikiki! Enjoy grab-and-go breakfast in the comfort of your accommodations, take a dip in the heated outdoor pool, or make a little something in your own kitchenette and relax on ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
You’ll feel right at home at this lovely boutique property in Waikiki! Enjoy grab-and-go breakfast in the comfort of your accommodations, take a dip in the heated outdoor pool, or make a little something in your own kitchenette and relax on ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
