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 '%Village Manor%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Village Manor Apartment: #F11. Waipouli, Kapa'a, Kaua`i Vacation Rental.
2 bedroom, 1.5 bath, ground floor, cute and cozy end unit apartment with approximately 634 square feet of living area is conveniently located in Kapaa Town. A short ...
- 3 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapaa
Plumeria Hale, Village Manor Apartment: #B22. Waipouli, Kapa'a, Kaua`i Vacation Rental.
"Plumeria Hale" is a bright and airy second story, two-bedroom condo with partial ocean views, located a short walk to the beach. Named after the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapaa
Coconut Grove Apartment, Village Manor #A21. Just steps from the coastal bike path, walk to the beach, shops and grocery stores. Distant Ocean Views and Royal Coconut Grove views from the lanai.
Waipouli, Kapa'a, Kauai Vacation Rental. ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapaa
Village Manor Beach Side Apartment #D22. Waipouli, Kapa'a, Kaua`i Vacation Rental.
Second floor, walk up end unit apartment. Centrally located on Kauaiās eastern shore make this the perfect Kauai vacation rental.
Easy walking ...
- 3 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapaa