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 (`address` like '%4771 Pepelani Loop%' ) order by rating desc LIMIT 0, 15
LOCATION, PRIVACY & OUR COMFORTABLE BEAUTIFUL HOME.....Are just a few words that best describe this ground floor condo at Plantation at ...
-
2
bedroom
-
2
bathroom
-
Sleeps 6
HI>
Princeville
Light and Bright fully updated 3br.
Plantation of Princeville 3b/3b. Central Air Conditioning, Pool, Hot Tub, and BBQ. ...
-
3
bedroom
-
3
bathroom
-
Sleeps 6
HI>
Princeville
Welcome to The Cabana on Kauai!
This is a beautiful, newly remodeled condo with a balcony lanai. It has three comfortable bedroom/bathroom ...
-
3
bedroom
-
3
bathroom
-
Sleeps 6
HI>
Princeville
Spacious 3 bedroom/3bath 2nd story condo with awe inspiring waterfall and golf course views. Plantation in Princeville 721, sleeps 6 with ...
-
3
bedroom
-
3
bathroom
-
Sleeps 6
HI>
Princeville
Location along with the largest floor plan available for Plantation at Princeville make this three bedroom condo ideal for your Kauai vacation. ...
-
3
bedroom
-
3
bathroom
-
Sleeps 6
HI>
Princeville
Well appointed 2 bedroom, 2 bathroom home w/AC includes a gourmet kitchen, king-sized Westin Heavenly beds, a private lanai and a comfortable, ...
-
2
bedroom
-
2
bathroom
-
Sleeps 4
HI>
Princeville
RAINBOWS & TROPICAL BREEZES
Aloha! Welcome to our condo at the Plantation in Princeville, on the beautiful Garden Island of Kauai. Come and ...
-
3
bedroom
-
3
bathroom
-
Sleeps 6
HI>
Princeville
You'll find our 3 bedroom 3 bath unit welcoming and relaxing with all the comforts of home while you rest and unwind on the beautiful island of ...
-
3
bedroom
-
3
bathroom
-
Sleeps 6
HI>
Princeville
Offering one of the newest retreats in Princeville, these luxurious air conditioned Kauai vacation rentals offer spacious layouts, covered ...
-
2
bedroom
-
2
bathroom
-
Sleeps 4
HI>
Princeville
Our condo home is lovingly appointed with everything you need to feel like you’ve arrived in your own tropical home away from home. New, ...
-
3
bedroom
-
3
bathroom
-
Sleeps 6
HI>
Princeville
In the heart of Princeville, this newly refurnished two en-suite bedroom, 2 full bath condo includes new stainless steel appliances, A/C, ...
-
2
bedroom
-
2
bathroom
-
Sleeps 5
HI>
Princeville
'HANALEI BAY DREAMS' PLANTATION AT PRINCEVILLE #612
- MANAGED BY THE PARRISH COLLECTION KAUAI
- THE BEST LOCATION AND UNIT IN COMPLEX. TASTEFUL ...
-
2
bedroom
-
2
bathroom
-
Sleeps 6
HI>
Princeville
Few words can truly describe the beauty of Kauai! Why make a trip so far across the ocean unless you can enjoy every minute of it? From the ...
-
2
bedroom
-
2
bathroom
-
Sleeps 4
HI>
Princeville
Our dream can be yours too! Plantation condo #1522 has 3 bedrooms, each with it's own bath. It's air conditioned in the living, dining, kitchen ...
-
3
bedroom
-
3
bathroom
-
Sleeps 6
HI>
Princeville
Relax and enjoy Paradise in our luxurious and well maintained 2nd floor 3 bedroom, 3 full bath condo. The Plantation at Princeville is a ...
-
3
bedroom
-
3
bathroom
-
Sleeps 6
HI>
Princeville
