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 '%pearl harbor%') AND sleeps>=1 order by rating desc LIMIT 0, 50
House, 1 Bedroom + Convertible bed, kid zone with 2 twin beds, 1 Bath, (Sleeps 2-5) Double Occupancy Rate
***** Private - Picturesque - Peaceful - Free WiFi - Free Parking, no resort fees!
Panoramic views of Pearl Harbor, valley, ...
- 2 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Aiea
Spacious custom built post and beam home featuring huge ceilings and massive beams throughout home. Gourmet kitchen with huge great room and massive deck. Spectacular views and incredible location!!!!...
- 5 bedroom
- 5 bathroom
- Sleeps 16
Hawaii> Aiea
Welcome to Hillside Perfection on the Greens at Golf Ridge Homes!
Discover your ideal fully furnished, 5 bedroom, air conditioned executive home located in central Honolulu. Perfect for leisure visitors, savvy ...
- 5 bedroom
- 5 bathroom
- Sleeps 8
Hawaii> Honolulu
Nestled atop a hill, our home offers an enchanting view of Pearl Harbor. Perfect for remote professionals and families alike, our property provides the perfect blend of comfort and scenic beauty.
Welcome to our inviting home, where you can ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Honolulu